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.PER_PERIODS_OF_SERVICE_PKG_V2 dependencies on PER_PERIODS_OF_SERVICE

Line 1: PACKAGE BODY PER_PERIODS_OF_SERVICE_PKG_V2 AS

1: PACKAGE BODY PER_PERIODS_OF_SERVICE_PKG_V2 AS
2: /* $Header: pepds02t.pkb 120.1 2006/05/08 08:44:47 lsilveir noship $ */
3: --
4: -- flemonni
5: -- hire date changes bug # 625423

Line 34: 'per_periods_of_service_pkg_v2.Get_Max_Last_Process_date';

30: IS
31: --
32: l_date DATE;
33: l_proc VARCHAR2 (100) :=
34: 'per_periods_of_service_pkg_v2.Get_Max_Last_Process_date';
35: --
36: CURSOR cur_get_max_date (p_person_id NUMBER)
37: IS
38: SELECT max(final_process_date)

Line 39: FROM per_periods_of_service

35: --
36: CURSOR cur_get_max_date (p_person_id NUMBER)
37: IS
38: SELECT max(final_process_date)
39: FROM per_periods_of_service
40: WHERE person_id = p_person_id;
41: --
42: BEGIN
43: hr_utility.set_location('Entering ' || l_proc, 10);

Line 59: RETURN per_periods_of_service%ROWTYPE

55: -------------------------------------------------------------------------------
56: FUNCTION Get_Current_PDS_Record
57: ( p_person_id IN per_people_f.person_id%TYPE
58: )
59: RETURN per_periods_of_service%ROWTYPE
60: IS
61: l_record per_periods_of_service%ROWTYPE;
62: --
63: CURSOR csr_pds_status

Line 61: l_record per_periods_of_service%ROWTYPE;

57: ( p_person_id IN per_people_f.person_id%TYPE
58: )
59: RETURN per_periods_of_service%ROWTYPE
60: IS
61: l_record per_periods_of_service%ROWTYPE;
62: --
63: CURSOR csr_pds_status
64: ( p_person_id per_people_f.person_id%TYPE
65: )

Line 68: FROM per_periods_of_service

64: ( p_person_id per_people_f.person_id%TYPE
65: )
66: IS
67: SELECT *
68: FROM per_periods_of_service
69: WHERE period_of_service_id =
70: ( SELECT max(period_of_service_id)
71: FROM per_periods_of_service
72: WHERE person_id = p_person_id

Line 71: FROM per_periods_of_service

67: SELECT *
68: FROM per_periods_of_service
69: WHERE period_of_service_id =
70: ( SELECT max(period_of_service_id)
71: FROM per_periods_of_service
72: WHERE person_id = p_person_id
73: );
74: BEGIN
75: OPEN csr_pds_status

Line 93: l_record per_periods_of_service%ROWTYPE;

89: ( p_person_id IN per_people_f.person_id%TYPE
90: )
91: RETURN NUMBER
92: IS
93: l_record per_periods_of_service%ROWTYPE;
94: BEGIN
95: l_record := Get_Current_PDS_Record
96: ( p_person_id => p_person_id);
97: --

Line 112: l_record per_periods_of_service%ROWTYPE;

108: RETURN BOOLEAN
109: IS
110: --
111: l_boolean BOOLEAN := FALSE;
112: l_record per_periods_of_service%ROWTYPE;
113: BEGIN
114: l_record := Get_Current_PDS_Record
115: ( p_person_id => p_person_id);
116:

Line 140: 'per_periods_of_service_pkg_v2.Get_Person_Age_Min_Max_Dates';

136: l_record Age_dates;
137: l_min NUMBER;
138: l_max NUMBER;
139: l_proc VARCHAR2 (100) :=
140: 'per_periods_of_service_pkg_v2.Get_Person_Age_Min_Max_Dates';
141: --
142: CURSOR csr_dob
143: ( p_person_id per_all_people_f.person_id%TYPE
144: , p_session_date DATE)

Line 194: l_proc VARCHAR2 (100) := 'per_periods_of_service_pkg_v2.Get_atd';

190: )
191: RETURN date
192: IS
193: l_date DATE := null;
194: l_proc VARCHAR2 (100) := 'per_periods_of_service_pkg_v2.Get_atd';
195: --
196: CURSOR csr_atd
197: ( p_person_id per_all_people_f.person_id%type
198: , p_final_process_date date)

Line 201: FROM per_periods_of_service

197: ( p_person_id per_all_people_f.person_id%type
198: , p_final_process_date date)
199: IS
200: SELECT actual_termination_date
201: FROM per_periods_of_service
202: WHERE person_id = p_person_id
203: AND final_process_date = p_final_process_date;
204: BEGIN
205: hr_utility.set_location('Entering ' || l_proc, 10);

Line 224: 'per_periods_of_service_pkg_v2.Get_Current_PDS_Start_Date';

220: RETURN DATE
221: IS
222: l_date DATE;
223: l_proc VARCHAR2 (100) :=
224: 'per_periods_of_service_pkg_v2.Get_Current_PDS_Start_Date';
225: --
226: CURSOR csr_pds_start_date
227: (p_person_id per_all_people_f.person_id%TYPE)
228: IS

Line 230: FROM per_periods_of_service

226: CURSOR csr_pds_start_date
227: (p_person_id per_all_people_f.person_id%TYPE)
228: IS
229: SELECT max(date_start)
230: FROM per_periods_of_service
231: WHERE person_id = p_person_id
232: AND final_process_date is null;
233:
234: CURSOR csr_pds_start_date_nn

Line 238: FROM per_periods_of_service

234: CURSOR csr_pds_start_date_nn
235: (p_person_id per_all_people_f.person_id%TYPE)
236: IS
237: SELECT max(date_start)
238: FROM per_periods_of_service
239: WHERE person_id = p_person_id;
240:
241: BEGIN
242: hr_utility.set_location('Entering ' || l_proc, 10);

Line 272: 'per_periods_of_service_pkg_v2.Get_Max_Asg_Hire_Date';

268: RETURN date
269: IS
270: l_date DATE := NULL;
271: l_proc VARCHAR2 (100) :=
272: 'per_periods_of_service_pkg_v2.Get_Max_Asg_Hire_Date';
273: --
274: CURSOR Get_Max_Asg_Hire_Date
275: ( p_person_id per_all_people_f.person_id%TYPE
276: , p_check_date date)

Line 301: 'per_periods_of_service_pkg_v2.Get_Min_Asg_Hire_Date';

297: RETURN date
298: IS
299: l_date DATE := NULL;
300: l_proc VARCHAR2 (100) :=
301: 'per_periods_of_service_pkg_v2.Get_Min_Asg_Hire_Date';
302: --
303: CURSOR Get_Min_Asg_Hire_Date
304: ( p_person_id per_all_people_f.person_id%TYPE
305: , p_check_date date)

Line 331: 'per_periods_of_service_pkg_v2.Get_Min_Person_End_Date';

327: RETURN DATE
328: IS
329: l_date DATE;
330: l_proc VARCHAR2 (100) :=
331: 'per_periods_of_service_pkg_v2.Get_Min_Person_End_Date';
332: --
333: CURSOR csr_get_end_date
334: ( p_person_id per_all_people_f.person_id%TYPE
335: , p_date_from DATE

Line 363: 'per_periods_of_service_pkg_v2.Get_Max_Person_Start_Date';

359: RETURN DATE
360: IS
361: l_date DATE;
362: l_proc VARCHAR2 (100) :=
363: 'per_periods_of_service_pkg_v2.Get_Max_Person_Start_Date';
364: --
365: CURSOR csr_get_start_date
366: ( p_person_id per_all_people_f.person_id%TYPE
367: , p_date_from DATE

Line 395: 'per_periods_of_service_pkg_v2.

391: IS
392: l_boolean BOOLEAN;
393: l_effective_start_date DATE;
394: l_proc VARCHAR2 (100) :=
395: 'per_periods_of_service_pkg_v2.
396: Is_Back_to_Back_Allowed';
397: --
398: CURSOR csr_person_type_change
399: ( p_person_id per_all_people_f.person_id%TYPE

Line 443: 'per_periods_of_service_pkg_v2.Set_Date_Using_FPD';

439: l_count NUMBER;
440: l_person_type_id NUMBER;
441: l_pt_changes_exist BOOLEAN := FALSE;
442: l_proc VARCHAR2 (100) :=
443: 'per_periods_of_service_pkg_v2.Set_Date_Using_FPD';
444: --
445: -- + 2
446: -- there must be at least an ex_empp_ record but no other changes
447: --

Line 519: 'per_periods_of_service_pkg_v2.Get_Min_Asg_Accepted';

515: RETURN DATE
516: IS
517: l_date DATE;
518: l_proc VARCHAR2 (100) :=
519: 'per_periods_of_service_pkg_v2.Get_Min_Asg_Accepted';
520: --
521: CURSOR csr_Get_Accepted_Asg
522: (p_person_id per_all_people_f.person_id%TYPE)
523: IS

Line 568: 'per_periods_of_service_pkg_v2.Get_valid_hire_dates';

564: l_min_years NUMBER;
565: l_max_years NUMBER;
566: l_fail_step NUMBER;
567: l_proc VARCHAR2 (100) :=
568: 'per_periods_of_service_pkg_v2.Get_valid_hire_dates';
569: BEGIN
570: hr_utility.set_location('Entering ' || l_proc, 10);
571: --
572: -- nb: hd = hire date

Line 954: 'per_periods_of_service_pkg_v2.IsBackToBackContract';

950: l_fpd DATE;
951: l_atd DATE;
952: l_boolean BOOLEAN;
953: l_proc VARCHAR2 (100) :=
954: 'per_periods_of_service_pkg_v2.IsBackToBackContract';
955: --
956: BEGIN
957: hr_utility.set_location('Entering ' || l_proc, 10);
958: l_fpd := Get_Max_Last_process_Date (p_person_id);

Line 979: END PER_PERIODS_OF_SERVICE_PKG_V2;

975: RETURN FALSE;
976: END IF;
977: END IsBackToBackContract;
978: --
979: END PER_PERIODS_OF_SERVICE_PKG_V2;