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 596: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;

592: l_asg_future_changes_warning boolean := FALSE;
593: l_entries_changed_warning varchar2(1) := 'N';
594: l_event_warning boolean := FALSE;
595: l_interview_warning boolean := FALSE;
596: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
597: l_last_std_process_date_in per_periods_of_service.last_standard_process_date%TYPE;
598: l_pds_object_version_number per_assignments_f.object_version_number%TYPE;
599: l_ovn per_assignments_f.object_version_number%TYPE := p_object_version_number;
600: l_recruiter_warning boolean := FALSE;

Line 597: l_last_std_process_date_in per_periods_of_service.last_standard_process_date%TYPE;

593: l_entries_changed_warning varchar2(1) := 'N';
594: l_event_warning boolean := FALSE;
595: l_interview_warning boolean := FALSE;
596: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
597: l_last_std_process_date_in per_periods_of_service.last_standard_process_date%TYPE;
598: l_pds_object_version_number per_assignments_f.object_version_number%TYPE;
599: l_ovn per_assignments_f.object_version_number%TYPE := p_object_version_number;
600: l_recruiter_warning boolean := FALSE;
601: l_review_warning boolean := FALSE;

Line 655: l_saved_atd per_periods_of_service.actual_termination_date%TYPE;

651: l_ptu_object_version_number per_person_type_usages_f.object_version_number%TYPE;
652: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
653: l_action_chk VARCHAR2(1) := 'N';
654:
655: l_saved_atd per_periods_of_service.actual_termination_date%TYPE;
656: l_saved_lspd per_periods_of_service.last_standard_process_date%TYPE;
657: --
658:
659: cursor csr_future_per_changes is

Line 656: l_saved_lspd per_periods_of_service.last_standard_process_date%TYPE;

652: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
653: l_action_chk VARCHAR2(1) := 'N';
654:
655: l_saved_atd per_periods_of_service.actual_termination_date%TYPE;
656: l_saved_lspd per_periods_of_service.last_standard_process_date%TYPE;
657: --
658:
659: cursor csr_future_per_changes is
660: select null

Line 687: , per_periods_of_service pds

683: , pds.actual_termination_date
684: , pds.last_standard_process_date
685: from per_all_people_f per
686: , per_business_groups bus
687: , per_periods_of_service pds
688: , per_person_types pet
689: where pds.period_of_service_id = p_period_of_service_id
690: and bus.business_group_id = pds.business_group_id
691: and per.person_id = pds.person_id

Line 716: l_pds_rec per_periods_of_service%rowtype;

712: where person_id = l_person_id;
713: --
714: -- Fix for bug 3829474 starts here.
715: --
716: l_pds_rec per_periods_of_service%rowtype;
717: --
718: cursor l_pds_cur is
719: select *
720: from per_periods_of_service

Line 720: from per_periods_of_service

716: l_pds_rec per_periods_of_service%rowtype;
717: --
718: cursor l_pds_cur is
719: select *
720: from per_periods_of_service
721: where period_of_service_id = p_period_of_service_id;
722: --
723: -- Fix for bug 3829474 ends here.
724: --

Line 1873: l_final_process_date per_periods_of_service.final_process_date%TYPE;

1869: -- Out variables
1870: --
1871: l_asg_future_changes_warning boolean := FALSE;
1872: l_entries_changed_warning varchar2(1) := 'N';
1873: l_final_process_date per_periods_of_service.final_process_date%TYPE;
1874: l_temp_date per_periods_of_service.final_process_date%TYPE := p_final_process_date;
1875: l_ovn per_periods_of_service.object_version_number%type := p_object_version_number;
1876: l_org_now_no_manager_warning boolean := FALSE;
1877: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;

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

1870: --
1871: l_asg_future_changes_warning boolean := FALSE;
1872: l_entries_changed_warning varchar2(1) := 'N';
1873: l_final_process_date per_periods_of_service.final_process_date%TYPE;
1874: l_temp_date per_periods_of_service.final_process_date%TYPE := p_final_process_date;
1875: l_ovn per_periods_of_service.object_version_number%type := p_object_version_number;
1876: l_org_now_no_manager_warning boolean := FALSE;
1877: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
1878: --

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

1871: l_asg_future_changes_warning boolean := FALSE;
1872: l_entries_changed_warning varchar2(1) := 'N';
1873: l_final_process_date per_periods_of_service.final_process_date%TYPE;
1874: l_temp_date per_periods_of_service.final_process_date%TYPE := p_final_process_date;
1875: l_ovn per_periods_of_service.object_version_number%type := p_object_version_number;
1876: l_org_now_no_manager_warning boolean := FALSE;
1877: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
1878: --
1879: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

Line 1877: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;

1873: l_final_process_date per_periods_of_service.final_process_date%TYPE;
1874: l_temp_date per_periods_of_service.final_process_date%TYPE := p_final_process_date;
1875: l_ovn per_periods_of_service.object_version_number%type := p_object_version_number;
1876: l_org_now_no_manager_warning boolean := FALSE;
1877: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
1878: --
1879: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1880: l_cr_asg_future_changes_warn boolean := FALSE;
1881: l_cr_entries_changed_warn varchar2(1) := 'N';

Line 1879: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

1875: l_ovn per_periods_of_service.object_version_number%type := p_object_version_number;
1876: l_org_now_no_manager_warning boolean := FALSE;
1877: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
1878: --
1879: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1880: l_cr_asg_future_changes_warn boolean := FALSE;
1881: l_cr_entries_changed_warn varchar2(1) := 'N';
1882: l_cr_org_now_no_manager_warn boolean := FALSE;
1883: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

Line 1886: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;

1882: l_cr_org_now_no_manager_warn boolean := FALSE;
1883: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
1884: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1885: l_exists varchar2(1);
1886: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
1887: l_legislation_code per_business_groups.legislation_code%TYPE;
1888: l_object_version_number per_periods_of_service.object_version_number%TYPE;
1889: l_person_id per_all_people_f.person_id%TYPE;
1890: l_proc varchar2(72) := g_package || 'final_process_emp';

Line 1888: l_object_version_number per_periods_of_service.object_version_number%TYPE;

1884: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1885: l_exists varchar2(1);
1886: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
1887: l_legislation_code per_business_groups.legislation_code%TYPE;
1888: l_object_version_number per_periods_of_service.object_version_number%TYPE;
1889: l_person_id per_all_people_f.person_id%TYPE;
1890: l_proc varchar2(72) := g_package || 'final_process_emp';
1891: l_exemppet_eff_date date;
1892: l_action_chk VARCHAR2(1) := 'N';

Line 1901: , per_periods_of_service pds

1897: , pds.last_standard_process_date
1898: , pds.person_id
1899: , pds.object_version_number
1900: from per_business_groups bus
1901: , per_periods_of_service pds
1902: where pds.period_of_service_id = p_period_of_service_id
1903: and bus.business_group_id = pds.business_group_id;
1904: --
1905: cursor csr_get_asgs_to_final_proc is

Line 1937: l_pds_rec per_periods_of_service%rowtype;

1933: and pet.system_person_type = 'EX_EMP';
1934: --
1935: -- Fix for bug 3829474 starts here.
1936: --
1937: l_pds_rec per_periods_of_service%rowtype;
1938: --
1939: cursor l_pds_cur is
1940: select *
1941: from per_periods_of_service

Line 1941: from per_periods_of_service

1937: l_pds_rec per_periods_of_service%rowtype;
1938: --
1939: cursor l_pds_cur is
1940: select *
1941: from per_periods_of_service
1942: where period_of_service_id = p_period_of_service_id;
1943: --
1944: -- Fix for bug 3829474 ends here.
1945: --