Sunday, October 5, 2008

R12 HRMS: Single record insertion for Assignment(Jobs, Position..)

DECLARE
l_org_now_no_manager_warning BOOLEAN;
l_other_manager_warning BOOLEAN;
l_spp_delete_warning BOOLEAN;
l_entries_changed_warning VARCHAR2 (500);
l_tax_district_changed_warning BOOLEAN;
l_object_version_number NUMBER;
l_people_group_id NUMBER;
l_special_ceiling_step_id NUMBER;
l_group_name VARCHAR2 (500);
l_effective_start_date DATE;
l_effective_end_date DATE;
BEGIN
--l_people_group_id := 155;
l_object_version_number := 3;
--l_group_name := '1A';
hr_assignment_api.update_emp_asg_criteria
(p_validate => FALSE,
p_effective_date => TRUNC (SYSDATE),
p_datetrack_update_mode => 'CORRECTION',
p_assignment_id => 27920,
p_object_version_number => l_object_version_number,
p_job_id => 18,
p_grade_id => 37,
p_position_id => NULL,
p_organization_id => 202,
p_location_id => 206,
p_pay_basis_id => 2,
p_payroll_id => 155,
p_special_ceiling_step_id => l_special_ceiling_step_id,
p_group_name => l_group_name,
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
p_people_group_id => l_people_group_id,
--emp_upload_rec.people_group_id,
p_segment1 => NULL,
p_segment2 => NULL,
p_segment3 => NULL,
p_segment4 => NULL,
p_segment5 => NULL,
p_segment6 => NULL,
p_segment7 => NULL,
p_segment8 => NULL,
p_segment9 => NULL,
p_segment10 => NULL,
p_segment11 => NULL,
p_segment12 => NULL,
p_segment13 => NULL,
p_segment14 => NULL,
p_segment15 => NULL,
p_segment16 => NULL,
p_segment17 => NULL,
p_segment18 => NULL,
p_segment19 => NULL,
p_segment20 => NULL,
p_segment21 => NULL,
p_segment22 => NULL,
p_segment23 => NULL,
p_segment24 => NULL,
p_segment25 => NULL,
p_segment26 => NULL,
p_segment27 => NULL,
p_segment28 => NULL,
p_segment29 => NULL,
p_segment30 => NULL,
p_concat_segments => '1A.Boston.No....',
p_employment_category => 'FR',
p_org_now_no_manager_warning => l_org_now_no_manager_warning,
p_other_manager_warning => l_other_manager_warning,
p_spp_delete_warning => l_spp_delete_warning,
p_entries_changed_warning => l_entries_changed_warning,
p_tax_district_changed_warning => l_tax_district_changed_warning
);
DBMS_OUTPUT.put_line (SQLERRM);
COMMIT;
END;

No comments: