eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_CWK_TERMINATION_SWI dependencies on PER_ALL_PEOPLE_F

Line 648: l_person_id per_all_people_f.person_id%TYPE;

644: -- and Rehire Reason. Hence we make following call to Person API
645: -- to update the Fields.
646:
647: DECLARE
648: l_person_id per_all_people_f.person_id%TYPE;
649: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
650: l_employee_number per_all_people_f.employee_number%TYPE;
651: l_effective_start_date date;
652: l_effective_end_date date;

Line 649: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

645: -- to update the Fields.
646:
647: DECLARE
648: l_person_id per_all_people_f.person_id%TYPE;
649: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
650: l_employee_number per_all_people_f.employee_number%TYPE;
651: l_effective_start_date date;
652: l_effective_end_date date;
653: l_full_name per_all_people_f.full_name%TYPE;

Line 650: l_employee_number per_all_people_f.employee_number%TYPE;

646:
647: DECLARE
648: l_person_id per_all_people_f.person_id%TYPE;
649: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
650: l_employee_number per_all_people_f.employee_number%TYPE;
651: l_effective_start_date date;
652: l_effective_end_date date;
653: l_full_name per_all_people_f.full_name%TYPE;
654: l_comment_id per_all_people_f.comment_id%TYPE;

Line 653: l_full_name per_all_people_f.full_name%TYPE;

649: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
650: l_employee_number per_all_people_f.employee_number%TYPE;
651: l_effective_start_date date;
652: l_effective_end_date date;
653: l_full_name per_all_people_f.full_name%TYPE;
654: l_comment_id per_all_people_f.comment_id%TYPE;
655: l_name_combination_warning boolean;
656: l_assign_payroll_warning boolean;
657: l_orig_hire_warning boolean;

Line 654: l_comment_id per_all_people_f.comment_id%TYPE;

650: l_employee_number per_all_people_f.employee_number%TYPE;
651: l_effective_start_date date;
652: l_effective_end_date date;
653: l_full_name per_all_people_f.full_name%TYPE;
654: l_comment_id per_all_people_f.comment_id%TYPE;
655: l_name_combination_warning boolean;
656: l_assign_payroll_warning boolean;
657: l_orig_hire_warning boolean;
658:

Line 663: from per_all_people_f per

659: cursor csr_get_derived_details is
660: select per.person_id
661: , per.employee_number
662: , per.object_version_number
663: from per_all_people_f per
664: where per.person_id = p_person_id
665: and p_actual_termination_date between per.effective_start_date
666: and per.effective_end_date;
667:

Line 2217: l_person_type_id per_all_people_f.person_type_id%TYPE;

2213:
2214: l_person_id per_periods_of_placement.person_id%TYPE;
2215: l_date_start per_periods_of_placement.date_start%TYPE;
2216: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2217: l_person_type_id per_all_people_f.person_type_id%TYPE;
2218: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2219: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2220: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2221: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;

Line 2223: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;

2219: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2220: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2221: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2222: l_termination_reason per_periods_of_placement.termination_reason%TYPE;
2223: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
2224: l_rehire_reason per_all_people_f.rehire_reason%TYPE;
2225:
2226: l_proc varchar2(72) := g_package ||'process_api';
2227: l_effective_date date;

Line 2224: l_rehire_reason per_all_people_f.rehire_reason%TYPE;

2220: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2221: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2222: l_termination_reason per_periods_of_placement.termination_reason%TYPE;
2223: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
2224: l_rehire_reason per_all_people_f.rehire_reason%TYPE;
2225:
2226: l_proc varchar2(72) := g_package ||'process_api';
2227: l_effective_date date;
2228: