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

Line 50: per_periods_of_service.accepted_termination_date%TYPE) is

46: -- ----------------------------------------------------------------------------
47: procedure chk_accepted_termination_date
48: --
49: (p_accepted_termination_date in
50: per_periods_of_service.accepted_termination_date%TYPE) is
51: --
52: l_proc varchar2(72) := g_package||'chk_accepted_termination_date';
53: --
54: begin

Line 108: per_periods_of_service.actual_termination_date%TYPE

104: -- ----------------------------------------------------------------------------
105: procedure chk_actual_termination_date
106: --
107: (p_actual_termination_date in
108: per_periods_of_service.actual_termination_date%TYPE
109: ,p_date_start in per_periods_of_service.date_start%TYPE
110: ,p_last_standard_process_date in
111: per_periods_of_service.last_standard_process_date%TYPE
112: ,p_object_version_number in

Line 109: ,p_date_start in per_periods_of_service.date_start%TYPE

105: procedure chk_actual_termination_date
106: --
107: (p_actual_termination_date in
108: per_periods_of_service.actual_termination_date%TYPE
109: ,p_date_start in per_periods_of_service.date_start%TYPE
110: ,p_last_standard_process_date in
111: per_periods_of_service.last_standard_process_date%TYPE
112: ,p_object_version_number in
113: per_periods_of_service.object_version_number%TYPE

Line 111: per_periods_of_service.last_standard_process_date%TYPE

107: (p_actual_termination_date in
108: per_periods_of_service.actual_termination_date%TYPE
109: ,p_date_start in per_periods_of_service.date_start%TYPE
110: ,p_last_standard_process_date in
111: per_periods_of_service.last_standard_process_date%TYPE
112: ,p_object_version_number in
113: per_periods_of_service.object_version_number%TYPE
114: ,p_period_of_service_id in
115: per_periods_of_service.period_of_service_id%TYPE

Line 113: per_periods_of_service.object_version_number%TYPE

109: ,p_date_start in per_periods_of_service.date_start%TYPE
110: ,p_last_standard_process_date in
111: per_periods_of_service.last_standard_process_date%TYPE
112: ,p_object_version_number in
113: per_periods_of_service.object_version_number%TYPE
114: ,p_period_of_service_id in
115: per_periods_of_service.period_of_service_id%TYPE
116: ,p_person_id in per_periods_of_service.person_id%TYPE
117: ) is

Line 115: per_periods_of_service.period_of_service_id%TYPE

111: per_periods_of_service.last_standard_process_date%TYPE
112: ,p_object_version_number in
113: per_periods_of_service.object_version_number%TYPE
114: ,p_period_of_service_id in
115: per_periods_of_service.period_of_service_id%TYPE
116: ,p_person_id in per_periods_of_service.person_id%TYPE
117: ) is
118: --
119: l_api_updating boolean;

Line 116: ,p_person_id in per_periods_of_service.person_id%TYPE

112: ,p_object_version_number in
113: per_periods_of_service.object_version_number%TYPE
114: ,p_period_of_service_id in
115: per_periods_of_service.period_of_service_id%TYPE
116: ,p_person_id in per_periods_of_service.person_id%TYPE
117: ) is
118: --
119: l_api_updating boolean;
120: l_no_data_found boolean;

Line 316: (p_date_start in per_periods_of_service.date_start%TYPE) is

312: -- {End Of Comments}
313: -- ----------------------------------------------------------------------------
314: procedure chk_date_start
315: --
316: (p_date_start in per_periods_of_service.date_start%TYPE) is
317: --
318: l_proc varchar2(72) := g_package||'chk_date_start';
319: --
320: begin

Line 376: per_periods_of_service.actual_termination_date%TYPE,

372: -- ----------------------------------------------------------------------------
373: procedure chk_final_process_date
374: --
375: (p_actual_termination_date in
376: per_periods_of_service.actual_termination_date%TYPE,
377: p_date_start in per_periods_of_service.date_start%TYPE,
378: p_final_process_date in
379: per_periods_of_service.final_process_date%TYPE,
380: p_last_standard_process_date in

Line 377: p_date_start in per_periods_of_service.date_start%TYPE,

373: procedure chk_final_process_date
374: --
375: (p_actual_termination_date in
376: per_periods_of_service.actual_termination_date%TYPE,
377: p_date_start in per_periods_of_service.date_start%TYPE,
378: p_final_process_date in
379: per_periods_of_service.final_process_date%TYPE,
380: p_last_standard_process_date in
381: per_periods_of_service.last_standard_process_date%TYPE,

Line 379: per_periods_of_service.final_process_date%TYPE,

375: (p_actual_termination_date in
376: per_periods_of_service.actual_termination_date%TYPE,
377: p_date_start in per_periods_of_service.date_start%TYPE,
378: p_final_process_date in
379: per_periods_of_service.final_process_date%TYPE,
380: p_last_standard_process_date in
381: per_periods_of_service.last_standard_process_date%TYPE,
382: p_object_version_number in
383: per_periods_of_service.object_version_number%TYPE,

Line 381: per_periods_of_service.last_standard_process_date%TYPE,

377: p_date_start in per_periods_of_service.date_start%TYPE,
378: p_final_process_date in
379: per_periods_of_service.final_process_date%TYPE,
380: p_last_standard_process_date in
381: per_periods_of_service.last_standard_process_date%TYPE,
382: p_object_version_number in
383: per_periods_of_service.object_version_number%TYPE,
384: p_period_of_service_id in
385: per_periods_of_service.period_of_service_id%TYPE) is

Line 383: per_periods_of_service.object_version_number%TYPE,

379: per_periods_of_service.final_process_date%TYPE,
380: p_last_standard_process_date in
381: per_periods_of_service.last_standard_process_date%TYPE,
382: p_object_version_number in
383: per_periods_of_service.object_version_number%TYPE,
384: p_period_of_service_id in
385: per_periods_of_service.period_of_service_id%TYPE) is
386: --
387: l_assigned_payroll boolean;

Line 385: per_periods_of_service.period_of_service_id%TYPE) is

381: per_periods_of_service.last_standard_process_date%TYPE,
382: p_object_version_number in
383: per_periods_of_service.object_version_number%TYPE,
384: p_period_of_service_id in
385: per_periods_of_service.period_of_service_id%TYPE) is
386: --
387: l_assigned_payroll boolean;
388: l_api_updating boolean;
389: l_max_end_date per_periods_of_service.final_process_date%TYPE;

Line 389: l_max_end_date per_periods_of_service.final_process_date%TYPE;

385: per_periods_of_service.period_of_service_id%TYPE) is
386: --
387: l_assigned_payroll boolean;
388: l_api_updating boolean;
389: l_max_end_date per_periods_of_service.final_process_date%TYPE;
390: l_proc varchar2(72) := g_package||'chk_final_process_date';
391: --
392: --
393: -- 115.30 (START)

Line 400: FROM per_periods_of_service pds1

396: SELECT pds2.date_start
397: ,pds2.actual_termination_date
398: ,pds2.last_standard_process_date
399: ,pds2.final_process_date
400: FROM per_periods_of_service pds1
401: ,per_periods_of_service pds2
402: WHERE pds1.period_of_service_id = p_period_of_service_id
403: AND pds1.person_id = pds2.person_id
404: AND pds1.period_of_service_id <> pds2.period_of_service_id

Line 401: ,per_periods_of_service pds2

397: ,pds2.actual_termination_date
398: ,pds2.last_standard_process_date
399: ,pds2.final_process_date
400: FROM per_periods_of_service pds1
401: ,per_periods_of_service pds2
402: WHERE pds1.period_of_service_id = p_period_of_service_id
403: AND pds1.person_id = pds2.person_id
404: AND pds1.period_of_service_id <> pds2.period_of_service_id
405: AND pds2.date_start > pds1.date_start

Line 412: FROM per_periods_of_service pds1

408: lr_next_pds csr_next_pds%ROWTYPE;
409: --
410: CURSOR csr_later_fpd IS
411: SELECT pds2.final_process_date
412: FROM per_periods_of_service pds1
413: ,per_periods_of_service pds2
414: WHERE pds1.period_of_service_id = p_period_of_service_id
415: AND pds1.person_id = pds2.person_id
416: AND pds1.period_of_service_id <> pds2.period_of_service_id

Line 413: ,per_periods_of_service pds2

409: --
410: CURSOR csr_later_fpd IS
411: SELECT pds2.final_process_date
412: FROM per_periods_of_service pds1
413: ,per_periods_of_service pds2
414: WHERE pds1.period_of_service_id = p_period_of_service_id
415: AND pds1.person_id = pds2.person_id
416: AND pds1.period_of_service_id <> pds2.period_of_service_id
417: AND pds2.date_start > pds1.date_start;

Line 419: l_later_fpd per_periods_of_service.final_process_date%TYPE;

415: AND pds1.person_id = pds2.person_id
416: AND pds1.period_of_service_id <> pds2.period_of_service_id
417: AND pds2.date_start > pds1.date_start;
418: --
419: l_later_fpd per_periods_of_service.final_process_date%TYPE;
420: --
421: CURSOR csr_prev_pds_fpd IS
422: SELECT MAX(pds2.final_process_date)
423: FROM per_periods_of_service pds1

Line 423: FROM per_periods_of_service pds1

419: l_later_fpd per_periods_of_service.final_process_date%TYPE;
420: --
421: CURSOR csr_prev_pds_fpd IS
422: SELECT MAX(pds2.final_process_date)
423: FROM per_periods_of_service pds1
424: ,per_periods_of_service pds2
425: WHERE pds1.period_of_service_id = p_period_of_service_id
426: AND pds1.person_id = pds2.person_id
427: AND pds1.period_of_service_id <> pds2.period_of_service_id

Line 424: ,per_periods_of_service pds2

420: --
421: CURSOR csr_prev_pds_fpd IS
422: SELECT MAX(pds2.final_process_date)
423: FROM per_periods_of_service pds1
424: ,per_periods_of_service pds2
425: WHERE pds1.period_of_service_id = p_period_of_service_id
426: AND pds1.person_id = pds2.person_id
427: AND pds1.period_of_service_id <> pds2.period_of_service_id
428: AND pds2.date_start < pds1.date_start;

Line 430: l_prev_pds_fpd per_periods_of_service.final_process_date%TYPE;

426: AND pds1.person_id = pds2.person_id
427: AND pds1.period_of_service_id <> pds2.period_of_service_id
428: AND pds2.date_start < pds1.date_start;
429: --
430: l_prev_pds_fpd per_periods_of_service.final_process_date%TYPE;
431: --
432: --
433: -- 115.30 (END)
434: --

Line 775: per_periods_of_service.actual_termination_date%TYPE

771: --
772: procedure chk_last_standard_process_date
773: --
774: (p_actual_termination_date in
775: per_periods_of_service.actual_termination_date%TYPE
776: ,p_business_group_id in
777: per_periods_of_service.business_group_id%TYPE
778: ,p_date_start in per_periods_of_service.date_start%TYPE
779: ,p_last_standard_process_date in

Line 777: per_periods_of_service.business_group_id%TYPE

773: --
774: (p_actual_termination_date in
775: per_periods_of_service.actual_termination_date%TYPE
776: ,p_business_group_id in
777: per_periods_of_service.business_group_id%TYPE
778: ,p_date_start in per_periods_of_service.date_start%TYPE
779: ,p_last_standard_process_date in
780: per_periods_of_service.last_standard_process_date%TYPE
781: ,p_object_version_number in

Line 778: ,p_date_start in per_periods_of_service.date_start%TYPE

774: (p_actual_termination_date in
775: per_periods_of_service.actual_termination_date%TYPE
776: ,p_business_group_id in
777: per_periods_of_service.business_group_id%TYPE
778: ,p_date_start in per_periods_of_service.date_start%TYPE
779: ,p_last_standard_process_date in
780: per_periods_of_service.last_standard_process_date%TYPE
781: ,p_object_version_number in
782: per_periods_of_service.object_version_number%TYPE

Line 780: per_periods_of_service.last_standard_process_date%TYPE

776: ,p_business_group_id in
777: per_periods_of_service.business_group_id%TYPE
778: ,p_date_start in per_periods_of_service.date_start%TYPE
779: ,p_last_standard_process_date in
780: per_periods_of_service.last_standard_process_date%TYPE
781: ,p_object_version_number in
782: per_periods_of_service.object_version_number%TYPE
783: ,p_period_of_service_id in
784: per_periods_of_service.period_of_service_id%TYPE

Line 782: per_periods_of_service.object_version_number%TYPE

778: ,p_date_start in per_periods_of_service.date_start%TYPE
779: ,p_last_standard_process_date in
780: per_periods_of_service.last_standard_process_date%TYPE
781: ,p_object_version_number in
782: per_periods_of_service.object_version_number%TYPE
783: ,p_period_of_service_id in
784: per_periods_of_service.period_of_service_id%TYPE
785: ) is
786: --

Line 784: per_periods_of_service.period_of_service_id%TYPE

780: per_periods_of_service.last_standard_process_date%TYPE
781: ,p_object_version_number in
782: per_periods_of_service.object_version_number%TYPE
783: ,p_period_of_service_id in
784: per_periods_of_service.period_of_service_id%TYPE
785: ) is
786: --
787: l_api_updating boolean;
788: l_assigned_payroll boolean;

Line 790: l_max_end_date per_periods_of_service.final_process_date%TYPE;

786: --
787: l_api_updating boolean;
788: l_assigned_payroll boolean;
789: l_legislation_code per_business_groups.legislation_code%TYPE;
790: l_max_end_date per_periods_of_service.final_process_date%TYPE;
791: l_proc varchar2(72)
792: := g_package||'chk_last_standard_process_date';
793: --
794: cursor csr_get_legislation_code is

Line 993: (p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE

989: -- ----------------------------------------------------------------------------
990: -- commented out this routine for fix of bug#2784295
991: /* procedure chk_at_date_lsp_date
992: --
993: (p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
994: ,p_last_standard_process_date in per_periods_of_service.last_standard_process_date%TYPE
995: ,p_object_version_number in per_periods_of_service.object_version_number%TYPE
996: ,p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE
997: ,p_business_group_id in per_periods_of_service.business_group_id%TYPE

Line 994: ,p_last_standard_process_date in per_periods_of_service.last_standard_process_date%TYPE

990: -- commented out this routine for fix of bug#2784295
991: /* procedure chk_at_date_lsp_date
992: --
993: (p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
994: ,p_last_standard_process_date in per_periods_of_service.last_standard_process_date%TYPE
995: ,p_object_version_number in per_periods_of_service.object_version_number%TYPE
996: ,p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE
997: ,p_business_group_id in per_periods_of_service.business_group_id%TYPE
998: ) is

Line 995: ,p_object_version_number in per_periods_of_service.object_version_number%TYPE

991: /* procedure chk_at_date_lsp_date
992: --
993: (p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
994: ,p_last_standard_process_date in per_periods_of_service.last_standard_process_date%TYPE
995: ,p_object_version_number in per_periods_of_service.object_version_number%TYPE
996: ,p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE
997: ,p_business_group_id in per_periods_of_service.business_group_id%TYPE
998: ) is
999: --

Line 996: ,p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE

992: --
993: (p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
994: ,p_last_standard_process_date in per_periods_of_service.last_standard_process_date%TYPE
995: ,p_object_version_number in per_periods_of_service.object_version_number%TYPE
996: ,p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE
997: ,p_business_group_id in per_periods_of_service.business_group_id%TYPE
998: ) is
999: --
1000: l_proc varchar2(72) := g_package||'chk_at_date_lsp_date';

Line 997: ,p_business_group_id in per_periods_of_service.business_group_id%TYPE

993: (p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
994: ,p_last_standard_process_date in per_periods_of_service.last_standard_process_date%TYPE
995: ,p_object_version_number in per_periods_of_service.object_version_number%TYPE
996: ,p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE
997: ,p_business_group_id in per_periods_of_service.business_group_id%TYPE
998: ) is
999: --
1000: l_proc varchar2(72) := g_package||'chk_at_date_lsp_date';
1001: l_api_updating boolean;

Line 1110: (p_leaving_reason in per_periods_of_service.leaving_reason%TYPE,

1106: -- {End Of Comments}
1107: -- ----------------------------------------------------------------------------
1108: procedure chk_leaving_reason
1109: --
1110: (p_leaving_reason in per_periods_of_service.leaving_reason%TYPE,
1111: p_effective_date in date,
1112: p_object_version_number in
1113: per_periods_of_service.object_version_number%TYPE,
1114: p_period_of_service_id in

Line 1113: per_periods_of_service.object_version_number%TYPE,

1109: --
1110: (p_leaving_reason in per_periods_of_service.leaving_reason%TYPE,
1111: p_effective_date in date,
1112: p_object_version_number in
1113: per_periods_of_service.object_version_number%TYPE,
1114: p_period_of_service_id in
1115: per_periods_of_service.period_of_service_id%TYPE) is
1116: --
1117: l_api_updating boolean;

Line 1115: per_periods_of_service.period_of_service_id%TYPE) is

1111: p_effective_date in date,
1112: p_object_version_number in
1113: per_periods_of_service.object_version_number%TYPE,
1114: p_period_of_service_id in
1115: per_periods_of_service.period_of_service_id%TYPE) is
1116: --
1117: l_api_updating boolean;
1118: l_proc varchar2(72) := g_package||'chk_leaving_reason';
1119: l_rec per_pds_shd.g_rec_type;

Line 1212: (p_date_start in per_periods_of_service.date_start%TYPE,

1208: -- {End Of Comments}
1209: -- ----------------------------------------------------------------------------
1210: procedure chk_notified_termination_date
1211: --
1212: (p_date_start in per_periods_of_service.date_start%TYPE,
1213: p_notified_termination_date in
1214: per_periods_of_service.notified_termination_date%TYPE,
1215: p_object_version_number in
1216: per_periods_of_service.object_version_number%TYPE,

Line 1214: per_periods_of_service.notified_termination_date%TYPE,

1210: procedure chk_notified_termination_date
1211: --
1212: (p_date_start in per_periods_of_service.date_start%TYPE,
1213: p_notified_termination_date in
1214: per_periods_of_service.notified_termination_date%TYPE,
1215: p_object_version_number in
1216: per_periods_of_service.object_version_number%TYPE,
1217: p_period_of_service_id in
1218: per_periods_of_service.period_of_service_id%TYPE) is

Line 1216: per_periods_of_service.object_version_number%TYPE,

1212: (p_date_start in per_periods_of_service.date_start%TYPE,
1213: p_notified_termination_date in
1214: per_periods_of_service.notified_termination_date%TYPE,
1215: p_object_version_number in
1216: per_periods_of_service.object_version_number%TYPE,
1217: p_period_of_service_id in
1218: per_periods_of_service.period_of_service_id%TYPE) is
1219: --
1220: l_api_updating boolean;

Line 1218: per_periods_of_service.period_of_service_id%TYPE) is

1214: per_periods_of_service.notified_termination_date%TYPE,
1215: p_object_version_number in
1216: per_periods_of_service.object_version_number%TYPE,
1217: p_period_of_service_id in
1218: per_periods_of_service.period_of_service_id%TYPE) is
1219: --
1220: l_api_updating boolean;
1221: l_proc varchar2(72) := g_package||'chk_notified_termination_date';
1222: --

Line 1311: (p_person_id in per_periods_of_service.person_id%TYPE,

1307: -- {End Of Comments}
1308: -- ----------------------------------------------------------------------------
1309: procedure chk_person_id
1310: --
1311: (p_person_id in per_periods_of_service.person_id%TYPE,
1312: p_termination_accepted_person in
1313: per_periods_of_service.termination_accepted_person_id%TYPE) is
1314: --
1315: l_proc varchar2(72) := g_package||'chk_person_id';

Line 1313: per_periods_of_service.termination_accepted_person_id%TYPE) is

1309: procedure chk_person_id
1310: --
1311: (p_person_id in per_periods_of_service.person_id%TYPE,
1312: p_termination_accepted_person in
1313: per_periods_of_service.termination_accepted_person_id%TYPE) is
1314: --
1315: l_proc varchar2(72) := g_package||'chk_person_id';
1316: l_rec per_pds_shd.g_rec_type;
1317: --

Line 1374: (p_date_start in per_periods_of_service.date_start%TYPE,

1370: -- {End Of Comments}
1371: -- ----------------------------------------------------------------------------
1372: procedure chk_person_id_date_start
1373: --
1374: (p_date_start in per_periods_of_service.date_start%TYPE,
1375: p_object_version_number in per_periods_of_service.object_version_number%TYPE,
1376: p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE,
1377: p_person_id in per_periods_of_service.person_id%TYPE) is
1378: --

Line 1375: p_object_version_number in per_periods_of_service.object_version_number%TYPE,

1371: -- ----------------------------------------------------------------------------
1372: procedure chk_person_id_date_start
1373: --
1374: (p_date_start in per_periods_of_service.date_start%TYPE,
1375: p_object_version_number in per_periods_of_service.object_version_number%TYPE,
1376: p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE,
1377: p_person_id in per_periods_of_service.person_id%TYPE) is
1378: --
1379: l_api_updating boolean;

Line 1376: p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE,

1372: procedure chk_person_id_date_start
1373: --
1374: (p_date_start in per_periods_of_service.date_start%TYPE,
1375: p_object_version_number in per_periods_of_service.object_version_number%TYPE,
1376: p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE,
1377: p_person_id in per_periods_of_service.person_id%TYPE) is
1378: --
1379: l_api_updating boolean;
1380: l_exists varchar2(1);

Line 1377: p_person_id in per_periods_of_service.person_id%TYPE) is

1373: --
1374: (p_date_start in per_periods_of_service.date_start%TYPE,
1375: p_object_version_number in per_periods_of_service.object_version_number%TYPE,
1376: p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE,
1377: p_person_id in per_periods_of_service.person_id%TYPE) is
1378: --
1379: l_api_updating boolean;
1380: l_exists varchar2(1);
1381: l_proc varchar2(72) := g_package||'chk_person_id_date_start';

Line 1385: from per_periods_of_service pds

1381: l_proc varchar2(72) := g_package||'chk_person_id_date_start';
1382: --
1383: cursor csr_new_pers_date is
1384: select null
1385: from per_periods_of_service pds
1386: where pds.person_id = p_person_id
1387: and pds.date_start = p_date_start;
1388: --
1389: cursor csr_valid_pers_date is

Line 1427: -- on PER_PERIODS_OF_SERVICE

1423: if not l_api_updating
1424: then
1425: --
1426: -- Check that the Person ID and Date Start combination does not exist
1427: -- on PER_PERIODS_OF_SERVICE
1428: --
1429: hr_utility.set_location(l_proc, 6);
1430: --
1431: open csr_new_pers_date;

Line 1503: (p_date_start in per_periods_of_service.date_start%TYPE,

1499: -- {End Of Comments}
1500: -- ----------------------------------------------------------------------------
1501: procedure chk_projected_termination_date
1502: --
1503: (p_date_start in per_periods_of_service.date_start%TYPE,
1504: p_object_version_number in
1505: per_periods_of_service.object_version_number%TYPE,
1506: p_period_of_service_id in
1507: per_periods_of_service.period_of_service_id%TYPE,

Line 1505: per_periods_of_service.object_version_number%TYPE,

1501: procedure chk_projected_termination_date
1502: --
1503: (p_date_start in per_periods_of_service.date_start%TYPE,
1504: p_object_version_number in
1505: per_periods_of_service.object_version_number%TYPE,
1506: p_period_of_service_id in
1507: per_periods_of_service.period_of_service_id%TYPE,
1508: p_projected_termination_date in
1509: per_periods_of_service.projected_termination_date%TYPE) is

Line 1507: per_periods_of_service.period_of_service_id%TYPE,

1503: (p_date_start in per_periods_of_service.date_start%TYPE,
1504: p_object_version_number in
1505: per_periods_of_service.object_version_number%TYPE,
1506: p_period_of_service_id in
1507: per_periods_of_service.period_of_service_id%TYPE,
1508: p_projected_termination_date in
1509: per_periods_of_service.projected_termination_date%TYPE) is
1510: --
1511: l_api_updating boolean;

Line 1509: per_periods_of_service.projected_termination_date%TYPE) is

1505: per_periods_of_service.object_version_number%TYPE,
1506: p_period_of_service_id in
1507: per_periods_of_service.period_of_service_id%TYPE,
1508: p_projected_termination_date in
1509: per_periods_of_service.projected_termination_date%TYPE) is
1510: --
1511: l_api_updating boolean;
1512: l_proc varchar2(72) := g_package||'chk_projected_termination_date';
1513: --

Line 1599: (p_accepted_termination_date in per_periods_of_service.date_start%TYPE,

1595: -- processing is terminated.
1596: --
1597: procedure chk_termination_accepted_pers
1598: --
1599: (p_accepted_termination_date in per_periods_of_service.date_start%TYPE,
1600: p_object_version_number in per_periods_of_service.object_version_number%TYPE,
1601: p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE,
1602: p_person_id in per_periods_of_service.person_id%TYPE,
1603: p_termination_accepted_person in per_periods_of_service.termination_accepted_person_id%TYPE,

Line 1600: p_object_version_number in per_periods_of_service.object_version_number%TYPE,

1596: --
1597: procedure chk_termination_accepted_pers
1598: --
1599: (p_accepted_termination_date in per_periods_of_service.date_start%TYPE,
1600: p_object_version_number in per_periods_of_service.object_version_number%TYPE,
1601: p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE,
1602: p_person_id in per_periods_of_service.person_id%TYPE,
1603: p_termination_accepted_person in per_periods_of_service.termination_accepted_person_id%TYPE,
1604: p_effective_date in date) is

Line 1601: p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE,

1597: procedure chk_termination_accepted_pers
1598: --
1599: (p_accepted_termination_date in per_periods_of_service.date_start%TYPE,
1600: p_object_version_number in per_periods_of_service.object_version_number%TYPE,
1601: p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE,
1602: p_person_id in per_periods_of_service.person_id%TYPE,
1603: p_termination_accepted_person in per_periods_of_service.termination_accepted_person_id%TYPE,
1604: p_effective_date in date) is
1605: --

Line 1602: p_person_id in per_periods_of_service.person_id%TYPE,

1598: --
1599: (p_accepted_termination_date in per_periods_of_service.date_start%TYPE,
1600: p_object_version_number in per_periods_of_service.object_version_number%TYPE,
1601: p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE,
1602: p_person_id in per_periods_of_service.person_id%TYPE,
1603: p_termination_accepted_person in per_periods_of_service.termination_accepted_person_id%TYPE,
1604: p_effective_date in date) is
1605: --
1606: l_api_updating boolean;

Line 1603: p_termination_accepted_person in per_periods_of_service.termination_accepted_person_id%TYPE,

1599: (p_accepted_termination_date in per_periods_of_service.date_start%TYPE,
1600: p_object_version_number in per_periods_of_service.object_version_number%TYPE,
1601: p_period_of_service_id in per_periods_of_service.period_of_service_id%TYPE,
1602: p_person_id in per_periods_of_service.person_id%TYPE,
1603: p_termination_accepted_person in per_periods_of_service.termination_accepted_person_id%TYPE,
1604: p_effective_date in date) is
1605: --
1606: l_api_updating boolean;
1607: l_exists varchar2(1);

Line 1974: ,p_descflex_name => 'PER_PERIODS_OF_SERVICE'

1970: -- validate flex segment values
1971: --
1972: hr_dflex_utility.ins_or_upd_descflex_attribs(
1973: p_appl_short_name => 'PER'
1974: ,p_descflex_name => 'PER_PERIODS_OF_SERVICE'
1975: ,p_attribute_category => p_rec.attribute_category
1976: ,p_attribute1_name => 'ATTRIBUTE1'
1977: ,p_attribute1_value => p_rec.attribute1
1978: ,p_attribute2_name => 'ATTRIBUTE2'

Line 2667: , per_periods_of_service pds

2663: --
2664: cursor csr_leg_code is
2665: select pbg.legislation_code
2666: from per_business_groups pbg
2667: , per_periods_of_service pds
2668: where pds.period_of_service_id = p_period_of_service_id
2669: and pbg.business_group_id = pds.business_group_id;
2670: --
2671: -- Declare local variables