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_EX_EMPLOYEE_API dependencies on PER_PERIODS_OF_SERVICE

Line 52: per_periods_of_service pds where pds.PERIOD_OF_SERVICE_ID =paf.PERIOD_OF_SERVICE_ID

48: -- Bug 12870406 Start
49: and paf.assignment_type='E'
50: and p_session_date between paf.effective_start_date and paf.effective_end_date
51: and exists (select null from
52: per_periods_of_service pds where pds.PERIOD_OF_SERVICE_ID =paf.PERIOD_OF_SERVICE_ID
53: and (pds.ACTUAL_TERMINATION_DATE is not null and pds.ACTUAL_TERMINATION_DATE >= p_session_date)));*/
54: -- Bug 12870406 End
55:
56: -- Commented for Bug#13869378

Line 619: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;

615: l_asg_future_changes_warning boolean := FALSE;
616: l_entries_changed_warning varchar2(1) := 'N';
617: l_event_warning boolean := FALSE;
618: l_interview_warning boolean := FALSE;
619: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
620: l_last_std_process_date_in per_periods_of_service.last_standard_process_date%TYPE;
621: l_pds_object_version_number per_assignments_f.object_version_number%TYPE;
622: l_ovn per_assignments_f.object_version_number%TYPE := p_object_version_number;
623: l_recruiter_warning boolean := FALSE;

Line 620: l_last_std_process_date_in per_periods_of_service.last_standard_process_date%TYPE;

616: l_entries_changed_warning varchar2(1) := 'N';
617: l_event_warning boolean := FALSE;
618: l_interview_warning boolean := FALSE;
619: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
620: l_last_std_process_date_in per_periods_of_service.last_standard_process_date%TYPE;
621: l_pds_object_version_number per_assignments_f.object_version_number%TYPE;
622: l_ovn per_assignments_f.object_version_number%TYPE := p_object_version_number;
623: l_recruiter_warning boolean := FALSE;
624: l_review_warning boolean := FALSE;

Line 678: l_saved_atd per_periods_of_service.actual_termination_date%TYPE;

674: l_ptu_object_version_number per_person_type_usages_f.object_version_number%TYPE;
675: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
676: l_action_chk VARCHAR2(1) := 'N';
677:
678: l_saved_atd per_periods_of_service.actual_termination_date%TYPE;
679: l_saved_lspd per_periods_of_service.last_standard_process_date%TYPE;
680: l_person_id2 number := -1;
681: --
682:

Line 679: l_saved_lspd per_periods_of_service.last_standard_process_date%TYPE;

675: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
676: l_action_chk VARCHAR2(1) := 'N';
677:
678: l_saved_atd per_periods_of_service.actual_termination_date%TYPE;
679: l_saved_lspd per_periods_of_service.last_standard_process_date%TYPE;
680: l_person_id2 number := -1;
681: --
682:
683:

Line 745: , per_periods_of_service pds

741: , pds.actual_termination_date
742: , pds.last_standard_process_date
743: from per_all_people_f per
744: , per_business_groups bus
745: , per_periods_of_service pds
746: , per_person_types pet
747: where pds.period_of_service_id = p_period_of_service_id
748: and bus.business_group_id = pds.business_group_id
749: and per.person_id = pds.person_id

Line 774: l_pds_rec per_periods_of_service%rowtype;

770: where person_id = l_person_id;
771: --
772: -- Fix for bug 3829474 starts here.
773: --
774: l_pds_rec per_periods_of_service%rowtype;
775: --
776: cursor l_pds_cur is
777: select *
778: from per_periods_of_service

Line 778: from per_periods_of_service

774: l_pds_rec per_periods_of_service%rowtype;
775: --
776: cursor l_pds_cur is
777: select *
778: from per_periods_of_service
779: where period_of_service_id = p_period_of_service_id;
780: --
781: -- Fix for bug 3829474 ends here.
782: --

Line 823: select person_id from per_periods_of_service

819: --
820: --
821: --dparthas
822: CURSOR get_person_info IS
823: select person_id from per_periods_of_service
824: where PERIOD_OF_SERVICE_ID = p_period_of_service_id;
825: --dparthas
826:
827:

Line 2164: l_final_process_date per_periods_of_service.final_process_date%TYPE;

2160: -- Out variables
2161: --
2162: l_asg_future_changes_warning boolean := FALSE;
2163: l_entries_changed_warning varchar2(1) := 'N';
2164: l_final_process_date per_periods_of_service.final_process_date%TYPE;
2165: l_temp_date per_periods_of_service.final_process_date%TYPE := p_final_process_date;
2166: l_ovn per_periods_of_service.object_version_number%type := p_object_version_number;
2167: l_org_now_no_manager_warning boolean := FALSE;
2168: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;

Line 2165: l_temp_date per_periods_of_service.final_process_date%TYPE := p_final_process_date;

2161: --
2162: l_asg_future_changes_warning boolean := FALSE;
2163: l_entries_changed_warning varchar2(1) := 'N';
2164: l_final_process_date per_periods_of_service.final_process_date%TYPE;
2165: l_temp_date per_periods_of_service.final_process_date%TYPE := p_final_process_date;
2166: l_ovn per_periods_of_service.object_version_number%type := p_object_version_number;
2167: l_org_now_no_manager_warning boolean := FALSE;
2168: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
2169: --

Line 2166: l_ovn per_periods_of_service.object_version_number%type := p_object_version_number;

2162: l_asg_future_changes_warning boolean := FALSE;
2163: l_entries_changed_warning varchar2(1) := 'N';
2164: l_final_process_date per_periods_of_service.final_process_date%TYPE;
2165: l_temp_date per_periods_of_service.final_process_date%TYPE := p_final_process_date;
2166: l_ovn per_periods_of_service.object_version_number%type := p_object_version_number;
2167: l_org_now_no_manager_warning boolean := FALSE;
2168: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
2169: --
2170: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

Line 2168: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;

2164: l_final_process_date per_periods_of_service.final_process_date%TYPE;
2165: l_temp_date per_periods_of_service.final_process_date%TYPE := p_final_process_date;
2166: l_ovn per_periods_of_service.object_version_number%type := p_object_version_number;
2167: l_org_now_no_manager_warning boolean := FALSE;
2168: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
2169: --
2170: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
2171: l_cr_asg_future_changes_warn boolean := FALSE;
2172: l_cr_entries_changed_warn varchar2(1) := 'N';

Line 2170: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

2166: l_ovn per_periods_of_service.object_version_number%type := p_object_version_number;
2167: l_org_now_no_manager_warning boolean := FALSE;
2168: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
2169: --
2170: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
2171: l_cr_asg_future_changes_warn boolean := FALSE;
2172: l_cr_entries_changed_warn varchar2(1) := 'N';
2173: l_cr_org_now_no_manager_warn boolean := FALSE;
2174: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

Line 2177: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;

2173: l_cr_org_now_no_manager_warn boolean := FALSE;
2174: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
2175: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2176: l_exists varchar2(1);
2177: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
2178: l_legislation_code per_business_groups.legislation_code%TYPE;
2179: l_object_version_number per_periods_of_service.object_version_number%TYPE;
2180: l_person_id per_all_people_f.person_id%TYPE;
2181: l_proc varchar2(72) := g_package || 'final_process_emp';

Line 2179: l_object_version_number per_periods_of_service.object_version_number%TYPE;

2175: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2176: l_exists varchar2(1);
2177: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
2178: l_legislation_code per_business_groups.legislation_code%TYPE;
2179: l_object_version_number per_periods_of_service.object_version_number%TYPE;
2180: l_person_id per_all_people_f.person_id%TYPE;
2181: l_proc varchar2(72) := g_package || 'final_process_emp';
2182: l_exemppet_eff_date date;
2183: l_action_chk VARCHAR2(1) := 'N';

Line 2192: , per_periods_of_service pds

2188: , pds.last_standard_process_date
2189: , pds.person_id
2190: , pds.object_version_number
2191: from per_business_groups bus
2192: , per_periods_of_service pds
2193: where pds.period_of_service_id = p_period_of_service_id
2194: and bus.business_group_id = pds.business_group_id;
2195: --
2196: cursor csr_get_asgs_to_final_proc is

Line 2228: l_pds_rec per_periods_of_service%rowtype;

2224: and pet.system_person_type = 'EX_EMP';
2225: --
2226: -- Fix for bug 3829474 starts here.
2227: --
2228: l_pds_rec per_periods_of_service%rowtype;
2229: --
2230: cursor l_pds_cur is
2231: select *
2232: from per_periods_of_service

Line 2232: from per_periods_of_service

2228: l_pds_rec per_periods_of_service%rowtype;
2229: --
2230: cursor l_pds_cur is
2231: select *
2232: from per_periods_of_service
2233: where period_of_service_id = p_period_of_service_id;
2234: --
2235: -- Fix for bug 3829474 ends here.
2236: --