HRMS Previous Employer and Jobs API
DECLARE l_person_id Number; l_business_group_id number := 81; l_party_id number; l_flag varchar2(5); V_Error varchar2(3000); V_Error2 varchar2(3000); l_previous_employer_id number; l_object_version_number number; l_previous_job_id number; l_status varchar2(5) := 'True' ; l_error_message varchar2(1000); l_validate_cnt number; l_join_date date; l_total_records number := 0; l_success_records number := 0; l_failure_records number := 0; begin Begin hr_previous_employment_api.create_previous_employer ( p_effective_date => sysdate ,p_person_id => 141 --csr_rec.person_id ,p_business_group_id => l_business_group_id ,p_party_id => l_party_id ,p_start_date => sysdate - 1000 --csr_rec.date_of_change ,p_end_date => sysdate -10 ,p_employer_name => 'XX DISTRIBUTION' ,p_employer_country => 'AE' ,p_employer_type => 'CM' ,p_previous_employer_id => l_previous_employer_id ,p_object_version_number => l_object_version_number ); COMMIT; dbms_output.put_line ('Y'); Exception when others then V_Error := SQLERRM; dbms_output.put_line (V_Error); END; begin hr_previous_employment_api.create_previous_job ( p_effective_date => sysdate ,p_previous_employer_id => l_previous_employer_id ,p_start_date => sysdate - 1000 ,p_end_date => sysdate -10 ,p_job_name => 'Technical' ,p_description => 'ITS' --,p_pjo_attribute1 => csr_rec.grade ,p_previous_job_id => l_previous_job_id ,p_object_version_number => l_object_version_number ); COMMIT; dbms_output.put_line ('Done'); Exception when others then V_Error2 := SQLERRM; dbms_output.put_line (V_Error2); end; end; /