HR Assignment API Error: Procedure sort_segment_order at Step 40
I'm attempting to update job_id using the update_emp_asg_criteria proc in the hr_assignment api. Here is the code I'm using:
o_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%type;
o_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type;
o_comment_id per_all_assignments_f.comment_id%type;
o_effective_start_date per_all_assignments_f.effective_start_date%type;
o_effective_end_date per_all_assignments_f.effective_end_date%type;
o_no_managers_warnings BOOLEAN;
o_other_manager_warning BOOLEAN;
o_org_now_no_manager_warning BOOLEAN;
o_special_ceiling_step_id NUMBER;
o_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type;
o_comment_id per_all_assignments_f.comment_id%type;
o_effective_start_date per_all_assignments_f.effective_start_date%type;
o_effective_end_date per_all_assignments_f.effective_end_date%type;
o_no_managers_warnings BOOLEAN;
o_other_manager_warning BOOLEAN;
o_org_now_no_manager_warning BOOLEAN;
o_special_ceiling_step_id NUMBER;
Tagged:
0