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_ALL_PEOPLE_F

Line 127: ( p_person_id IN per_all_people_f.person_id%TYPE

123: RETURN l_boolean;
124: END Is_Max_PDS_Not_Closed;
125: -------------------------------------------------------------------------------
126: FUNCTION Get_Person_Age_Min_Max_Dates
127: ( p_person_id IN per_all_people_f.person_id%TYPE
128: , p_session_date IN DATE
129: , p_dob IN DATE
130: , p_business_group_id IN NUMBER
131: )

Line 143: ( p_person_id per_all_people_f.person_id%TYPE

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)
145: IS
146: SELECT date_of_birth, business_group_id
147: FROM per_people_f ppf

Line 188: ( p_person_id IN per_all_people_f.person_id%type

184: RETURN l_record;
185: END Get_Person_Age_Min_Max_Dates;
186: -------------------------------------------------------------------------------
187: FUNCTION Get_atd
188: ( p_person_id IN per_all_people_f.person_id%type
189: , p_final_process_date IN DATE
190: )
191: RETURN date
192: IS

Line 197: ( p_person_id per_all_people_f.person_id%type

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)
199: IS
200: SELECT actual_termination_date
201: FROM per_periods_of_service

Line 217: ( p_person_id IN per_all_people_f.person_id%TYPE

213: RETURN l_date;
214: END Get_atd;
215: -------------------------------------------------------------------------------
216: FUNCTION Get_Current_PDS_Start_Date
217: ( p_person_id IN per_all_people_f.person_id%TYPE
218: , p_type IN VARCHAR2 DEFAULT NULL
219: )
220: RETURN DATE
221: IS

Line 227: (p_person_id per_all_people_f.person_id%TYPE)

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
229: SELECT max(date_start)
230: FROM per_periods_of_service
231: WHERE person_id = p_person_id

Line 235: (p_person_id per_all_people_f.person_id%TYPE)

231: WHERE person_id = p_person_id
232: AND final_process_date is null;
233:
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;

Line 265: ( p_person_id IN per_all_people_f.person_id%TYPE

261: RETURN l_date;
262: END Get_Current_PDS_Start_Date;
263: -------------------------------------------------------------------------------
264: FUNCTION Get_Max_Asg_Hire_Date
265: ( p_person_id IN per_all_people_f.person_id%TYPE
266: , p_check_date IN date
267: )
268: RETURN date
269: IS

Line 275: ( p_person_id per_all_people_f.person_id%TYPE

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)
277: IS
278: SELECT Min(effective_start_date) + 1
279: FROM per_all_assignments_f

Line 294: ( p_person_id IN per_all_people_f.person_id%TYPE

290: RETURN l_date;
291: END Get_Max_Asg_Hire_Date;
292: -------------------------------------------------------------------------------
293: FUNCTION Get_Min_Asg_Hire_Date
294: ( p_person_id IN per_all_people_f.person_id%TYPE
295: , p_check_date IN date
296: )
297: RETURN date
298: IS

Line 304: ( p_person_id per_all_people_f.person_id%TYPE

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)
306: IS
307: SELECT Max(effective_start_date) + 1
308: FROM per_all_assignments_f

Line 323: ( p_person_id IN per_all_people_f.person_id%TYPE

319: RETURN l_date;
320: END Get_Min_Asg_Hire_Date;
321: -------------------------------------------------------------------------------
322: FUNCTION Get_Min_Person_End_Date
323: ( p_person_id IN per_all_people_f.person_id%TYPE
324: , p_date_from IN DATE
325: , p_date_to IN DATE
326: )
327: RETURN DATE

Line 334: ( p_person_id per_all_people_f.person_id%TYPE

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
336: , p_date_to DATE)
337: IS
338: SELECT min(effective_end_date)

Line 339: FROM per_all_people_f

335: , p_date_from DATE
336: , p_date_to DATE)
337: IS
338: SELECT min(effective_end_date)
339: FROM per_all_people_f
340: WHERE person_id = p_person_id
341: AND effective_end_date between p_date_from + 1 and p_date_to -1;
342: BEGIN
343: hr_utility.set_location('Entering ' || l_proc, 10);

Line 355: ( p_person_id IN per_all_people_f.person_id%TYPE

351: RETURN l_date;
352: END Get_Min_Person_End_Date;
353: -------------------------------------------------------------------------------
354: FUNCTION Get_Max_Person_Start_Date
355: ( p_person_id IN per_all_people_f.person_id%TYPE
356: , p_date_from IN DATE
357: , p_date_to IN DATE
358: )
359: RETURN DATE

Line 366: ( p_person_id per_all_people_f.person_id%TYPE

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
368: , p_date_to DATE)
369: IS
370: SELECT max(effective_start_date) +1

Line 371: FROM per_all_people_f

367: , p_date_from DATE
368: , p_date_to DATE)
369: IS
370: SELECT max(effective_start_date) +1
371: FROM per_all_people_f
372: WHERE person_id = p_person_id
373: AND effective_start_date between p_date_from + 1 and p_date_to -1;
374: BEGIN
375: hr_utility.set_location('Entering ' || l_proc, 10);

Line 388: , p_person_id IN per_all_people_f.person_id%TYPE

384: END Get_Max_Person_Start_Date;
385: -------------------------------------------------------------------------------
386: FUNCTION Is_Back_to_Back_Allowed
387: ( p_pds_hd_bb IN DATE
388: , p_person_id IN per_all_people_f.person_id%TYPE
389: , p_current_hire_date IN DATE)
390: RETURN BOOLEAN
391: IS
392: l_boolean BOOLEAN;

Line 399: ( p_person_id per_all_people_f.person_id%TYPE

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
400: , p_current_hire_date DATE)
401: IS
402: SELECT effective_start_date
403: FROM per_people_f ppf, per_person_types ppt

Line 432: ( p_person_id IN per_all_people_f.person_id%TYPE

428: RETURN nvl(l_boolean, false);
429: END Is_Back_to_Back_Allowed;
430: -------------------------------------------------------------------------------
431: FUNCTION Set_Date_Using_FPD
432: ( p_person_id IN per_all_people_f.person_id%TYPE
433: , p_final_process_date date
434: )
435: RETURN DATE
436: IS

Line 513: ( p_person_id IN per_all_people_f.person_id%TYPE

509: RETURN l_date;
510: END Set_Date_Using_FPD;
511: -------------------------------------------------------------------------------
512: FUNCTION Get_Min_Asg_Accepted
513: ( p_person_id IN per_all_people_f.person_id%TYPE
514: )
515: RETURN DATE
516: IS
517: l_date DATE;

Line 522: (p_person_id per_all_people_f.person_id%TYPE)

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
524: SELECT min(effective_start_date) + 1
525: FROM per_all_assignments_f paf
526: , per_assignment_status_types past

Line 541: ( p_person_id IN per_all_people_f.person_id%TYPE

537: RETURN l_date;
538: END Get_Min_Asg_Accepted;
539: -------------------------------------------------------------------------------
540: PROCEDURE Get_Valid_Hire_Dates
541: ( p_person_id IN per_all_people_f.person_id%TYPE
542: , p_session_date IN DATE
543: , p_dob IN DATE
544: , p_business_group_id IN NUMBER
545: , p_min_date OUT NOCOPY DATE