Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00306 Error calling HR_ASSIGNMENT_API.update_apl_asg

Jason ORCLOct 14 2010 — edited Oct 14 2010
I keep getting this error.

Error(506,7): PLS-00306: wrong number or types of arguments in call to 'UPDATE_APL_ASG'

Here is my call...working on R12. What is wrong here? Look at r_assignment_api.update_apl_asg




PROCEDURE new_applicant_assignment (
p_person_type_id IN NUMBER,
p_ss_number IN VARCHAR2,
p_eff_date IN DATE,
p_grade_id IN NUMBER,
p_file_type IN VARCHAR2,
p_service_component IN VARCHAR2,
p_record_status IN VARCHAR2,
p_org_id IN NUMBER,
p_afriss IN BOOLEAN,
po_person_id OUT NUMBER,
po_assignment_id OUT NUMBER
)
IS

v_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
v_apl_object_version_number NUMBER;
v_per_object_version_number per_all_people_f.object_version_number%TYPE;
v_per_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
v_per_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
v_full_name per_all_people_f.full_name%TYPE;
v_per_comment_id per_people.comment_id%TYPE;
v_assignment_sequence NUMBER;
v_name_combination_warning BOOLEAN;
v_application_id per_all_assignments_f.application_id%TYPE;
v_assignment_id NUMBER;
v_comment_id NUMBER;
v_people_group_id NUMBER;
v_group_name VARCHAR2 (100);
v_effective_start_date DATE;
v_effective_end_date DATE;
v_ss_number VARCHAR2 (11);
v_person_id NUMBER;


v_soft_coding_keyflex_id NUMBER;
v_concatenated_segments VARCHAR2(1000);
v_cagr_grade_def_id NUMBER;


BEGIN
v_ss_number := p_ss_number;
apps.hr_applicant_api.create_applicant (p_date_received => ra027d_pkg.emp_rec.dob+ 1,
p_business_group_id => 101,
p_last_name => UPPER (SUBSTR(ra027d_pkg.emp_rec.name_last,1,30)),
p_applicant_number => v_ss_number,
p_person_type_id => p_person_type_id,
p_date_of_birth => ra027d_pkg.emp_rec.dob,
p_first_name => UPPER (SUBSTR (ra027d_pkg.emp_rec.name_first,
1,
20
)
),
p_middle_names => UPPER (SUBSTR (ra027d_pkg.emp_rec.name_middle,
1,
10
)
),
p_marital_status => NVL (ra027d_pkg.emp_rec.married_status,
'S'
),
p_national_identifier => p_ss_number,
p_sex => UPPER (ra027d_pkg.emp_rec.gender
),
p_pre_name_adjunct => UPPER (SUBSTR (ra027d_pkg.emp_rec.name_prefix,
1,
3
)
),
p_suffix => UPPER (SUBSTR (ra027d_pkg.emp_rec.name_suffix,
1,
3
)
),
p_person_id => v_person_id,
p_assignment_id => v_assignment_id,
p_application_id => v_application_id,
p_per_object_version_number => v_per_object_version_number,
p_asg_object_version_number => v_asg_object_version_number,
p_apl_object_version_number => v_apl_object_version_number,
p_per_effective_start_date => v_per_effective_start_date,
p_per_effective_end_date => v_per_effective_end_date,
p_full_name => v_full_name,
p_per_comment_id => v_per_comment_id,
p_assignment_sequence => v_assignment_sequence,
p_name_combination_warning => v_name_combination_warning
);
OPEN c_organization (p_org_id);
FETCH c_organization INTO v_location_id;
CLOSE c_organization;
OPEN c_afsc ('9T000');
FETCH c_afsc INTO v_job_id;
CLOSE c_afsc;
hr_assignment_api.update_apl_asg (
p_effective_date => p_eff_date-2,
p_datetrack_update_mode => 'CORRECTION',
p_assignment_id => v_assignment_id,
p_grade_id => p_grade_id,
p_position_id => NULL,
p_job_id => v_job_id,
p_location_id => v_location_id,
p_scl_segment1 => p_service_component,
p_scl_segment2 => p_file_type,
p_scl_segment3 => p_record_status,
p_organization_id => p_org_id,
p_object_version_number => v_asg_object_version_number,
p_comment_id => v_comment_id,
p_people_group_id => v_people_group_id,
p_group_name => v_group_name,
p_effective_start_date => v_effective_start_date,
p_effective_end_date => v_effective_end_date
,p_cagr_grade_def_id => v_cagr_grade_def_id
,p_cagr_concatenated_segments =>v_concatenated_segments
,p_soft_coding_keyflex_id =>v_soft_coding_keyflex_id

);



po_person_id := v_person_id;
po_assignment_id := v_assignment_id;

ra_7d_pkg.insert_error_table ( 'Applicant assignment processed for '
|| p_ss_number,
p_ss_number,
p_afriss
);
END new_applicant_assignment;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 11 2010
Added on Oct 14 2010
2 comments
593 views