APPS.BEN_EVALUATE_PTNL_LF_EVT dependencies on FND_GLOBAL

Line 40: ,p_program_application_id => fnd_global.prog_appl_id

36: ,p_person_id => p_ptnl_rec.person_id
37: ,p_business_group_id => p_ptnl_rec.business_group_id
38: ,p_object_version_number => p_ptnl_rec.object_version_number
39: ,p_effective_date => p_effective_date
40: ,p_program_application_id => fnd_global.prog_appl_id
41: ,p_program_id => fnd_global.conc_program_id
42: ,p_request_id => fnd_global.conc_request_id
43: ,p_program_update_date => sysdate);
44: --

Line 41: ,p_program_id => fnd_global.conc_program_id

37: ,p_business_group_id => p_ptnl_rec.business_group_id
38: ,p_object_version_number => p_ptnl_rec.object_version_number
39: ,p_effective_date => p_effective_date
40: ,p_program_application_id => fnd_global.prog_appl_id
41: ,p_program_id => fnd_global.conc_program_id
42: ,p_request_id => fnd_global.conc_request_id
43: ,p_program_update_date => sysdate);
44: --
45: end update_ptnl_per_for_ler;

Line 42: ,p_request_id => fnd_global.conc_request_id

38: ,p_object_version_number => p_ptnl_rec.object_version_number
39: ,p_effective_date => p_effective_date
40: ,p_program_application_id => fnd_global.prog_appl_id
41: ,p_program_id => fnd_global.conc_program_id
42: ,p_request_id => fnd_global.conc_request_id
43: ,p_program_update_date => sysdate);
44: --
45: end update_ptnl_per_for_ler;
46: --

Line 337: ,p_program_application_id => fnd_global.prog_appl_id

333: ,p_person_id => l_ppl_rec.person_id
334: ,p_business_group_id => l_ppl_rec.business_group_id
335: ,p_object_version_number => l_ppl_rec.object_version_number
336: ,p_effective_date => p_effective_date
337: ,p_program_application_id => fnd_global.prog_appl_id
338: ,p_program_id => fnd_global.conc_program_id
339: ,p_request_id => fnd_global.conc_request_id
340: ,p_program_update_date => sysdate);
341: --

Line 338: ,p_program_id => fnd_global.conc_program_id

334: ,p_business_group_id => l_ppl_rec.business_group_id
335: ,p_object_version_number => l_ppl_rec.object_version_number
336: ,p_effective_date => p_effective_date
337: ,p_program_application_id => fnd_global.prog_appl_id
338: ,p_program_id => fnd_global.conc_program_id
339: ,p_request_id => fnd_global.conc_request_id
340: ,p_program_update_date => sysdate);
341: --
342: else

Line 339: ,p_request_id => fnd_global.conc_request_id

335: ,p_object_version_number => l_ppl_rec.object_version_number
336: ,p_effective_date => p_effective_date
337: ,p_program_application_id => fnd_global.prog_appl_id
338: ,p_program_id => fnd_global.conc_program_id
339: ,p_request_id => fnd_global.conc_request_id
340: ,p_program_update_date => sysdate);
341: --
342: else
343: --

Line 350: ,p_program_application_id => fnd_global.prog_appl_id

346: ,p_ptnl_ler_for_per_id => l_ppl_rec.ptnl_ler_for_per_id
347: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
348: ,p_object_version_number => l_ppl_rec.object_version_number
349: ,p_effective_date => p_effective_date
350: ,p_program_application_id => fnd_global.prog_appl_id
351: ,p_program_id => fnd_global.conc_program_id
352: ,p_request_id => fnd_global.conc_request_id
353: ,p_program_update_date => sysdate
354: ,p_voidd_dt => p_effective_date);

Line 351: ,p_program_id => fnd_global.conc_program_id

347: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
348: ,p_object_version_number => l_ppl_rec.object_version_number
349: ,p_effective_date => p_effective_date
350: ,p_program_application_id => fnd_global.prog_appl_id
351: ,p_program_id => fnd_global.conc_program_id
352: ,p_request_id => fnd_global.conc_request_id
353: ,p_program_update_date => sysdate
354: ,p_voidd_dt => p_effective_date);
355: --

Line 352: ,p_request_id => fnd_global.conc_request_id

348: ,p_object_version_number => l_ppl_rec.object_version_number
349: ,p_effective_date => p_effective_date
350: ,p_program_application_id => fnd_global.prog_appl_id
351: ,p_program_id => fnd_global.conc_program_id
352: ,p_request_id => fnd_global.conc_request_id
353: ,p_program_update_date => sysdate
354: ,p_voidd_dt => p_effective_date);
355: --
356: end if;

Line 478: ,p_program_application_id => fnd_global.prog_appl_id

474: ,p_ptnl_ler_for_per_id => l_ppl_rec.ptnl_ler_for_per_id
475: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
476: ,p_object_version_number => l_ppl_rec.object_version_number
477: ,p_effective_date => p_effective_date
478: ,p_program_application_id => fnd_global.prog_appl_id
479: ,p_program_id => fnd_global.conc_program_id
480: ,p_request_id => fnd_global.conc_request_id
481: ,p_program_update_date => sysdate
482: ,p_voidd_dt => p_effective_date);

Line 479: ,p_program_id => fnd_global.conc_program_id

475: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
476: ,p_object_version_number => l_ppl_rec.object_version_number
477: ,p_effective_date => p_effective_date
478: ,p_program_application_id => fnd_global.prog_appl_id
479: ,p_program_id => fnd_global.conc_program_id
480: ,p_request_id => fnd_global.conc_request_id
481: ,p_program_update_date => sysdate
482: ,p_voidd_dt => p_effective_date);
483: --

Line 480: ,p_request_id => fnd_global.conc_request_id

476: ,p_object_version_number => l_ppl_rec.object_version_number
477: ,p_effective_date => p_effective_date
478: ,p_program_application_id => fnd_global.prog_appl_id
479: ,p_program_id => fnd_global.conc_program_id
480: ,p_request_id => fnd_global.conc_request_id
481: ,p_program_update_date => sysdate
482: ,p_voidd_dt => p_effective_date);
483: --
484: end loop;

Line 534: ,p_program_application_id => fnd_global.prog_appl_id

530: ,p_ntfn_dt => l_winning_ptnl_rec.ntfn_dt
531: ,p_trgr_table_pk_id => l_winning_ptnl_rec.trgr_table_pk_id
532: ,p_object_version_number => l_object_version_number
533: ,p_effective_date => p_effective_date
534: ,p_program_application_id => fnd_global.prog_appl_id
535: ,p_program_id => fnd_global.conc_program_id
536: ,p_request_id => fnd_global.conc_request_id
537: ,p_program_update_date => sysdate
538: ,p_procd_dt => l_procd_dt

Line 535: ,p_program_id => fnd_global.conc_program_id

531: ,p_trgr_table_pk_id => l_winning_ptnl_rec.trgr_table_pk_id
532: ,p_object_version_number => l_object_version_number
533: ,p_effective_date => p_effective_date
534: ,p_program_application_id => fnd_global.prog_appl_id
535: ,p_program_id => fnd_global.conc_program_id
536: ,p_request_id => fnd_global.conc_request_id
537: ,p_program_update_date => sysdate
538: ,p_procd_dt => l_procd_dt
539: ,p_strtd_dt => l_strtd_dt

Line 536: ,p_request_id => fnd_global.conc_request_id

532: ,p_object_version_number => l_object_version_number
533: ,p_effective_date => p_effective_date
534: ,p_program_application_id => fnd_global.prog_appl_id
535: ,p_program_id => fnd_global.conc_program_id
536: ,p_request_id => fnd_global.conc_request_id
537: ,p_program_update_date => sysdate
538: ,p_procd_dt => l_procd_dt
539: ,p_strtd_dt => l_strtd_dt
540: ,p_voidd_dt => l_voidd_dt);

Line 581: ,p_program_application_id => fnd_global.prog_appl_id

577: ,p_person_id => l_winning_ptnl_rec.person_id
578: ,p_business_group_id => l_winning_ptnl_rec.business_group_id
579: ,p_object_version_number => l_winning_ptnl_rec.object_version_number
580: ,p_effective_date => p_effective_date
581: ,p_program_application_id => fnd_global.prog_appl_id
582: ,p_program_id => fnd_global.conc_program_id
583: ,p_request_id => fnd_global.conc_request_id
584: ,p_program_update_date => sysdate);
585:

Line 582: ,p_program_id => fnd_global.conc_program_id

578: ,p_business_group_id => l_winning_ptnl_rec.business_group_id
579: ,p_object_version_number => l_winning_ptnl_rec.object_version_number
580: ,p_effective_date => p_effective_date
581: ,p_program_application_id => fnd_global.prog_appl_id
582: ,p_program_id => fnd_global.conc_program_id
583: ,p_request_id => fnd_global.conc_request_id
584: ,p_program_update_date => sysdate);
585:
586: p_created_ler_id := l_winning_ptnl_rec.ler_id;

Line 583: ,p_request_id => fnd_global.conc_request_id

579: ,p_object_version_number => l_winning_ptnl_rec.object_version_number
580: ,p_effective_date => p_effective_date
581: ,p_program_application_id => fnd_global.prog_appl_id
582: ,p_program_id => fnd_global.conc_program_id
583: ,p_request_id => fnd_global.conc_request_id
584: ,p_program_update_date => sysdate);
585:
586: p_created_ler_id := l_winning_ptnl_rec.ler_id;
587:

Line 802: ,p_program_application_id => fnd_global.prog_appl_id

798: ,p_ws_mgr_id => l_ws_mgr_id
799: ,p_assignment_id => l_assignment_id
800: ,p_object_version_number => l_object_version_number
801: ,p_effective_date => p_effective_date
802: ,p_program_application_id => fnd_global.prog_appl_id
803: ,p_program_id => fnd_global.conc_program_id
804: ,p_request_id => fnd_global.conc_request_id
805: ,p_program_update_date => sysdate
806: ,p_procd_dt => l_procd_dt

Line 803: ,p_program_id => fnd_global.conc_program_id

799: ,p_assignment_id => l_assignment_id
800: ,p_object_version_number => l_object_version_number
801: ,p_effective_date => p_effective_date
802: ,p_program_application_id => fnd_global.prog_appl_id
803: ,p_program_id => fnd_global.conc_program_id
804: ,p_request_id => fnd_global.conc_request_id
805: ,p_program_update_date => sysdate
806: ,p_procd_dt => l_procd_dt
807: ,p_strtd_dt => l_strtd_dt

Line 804: ,p_request_id => fnd_global.conc_request_id

800: ,p_object_version_number => l_object_version_number
801: ,p_effective_date => p_effective_date
802: ,p_program_application_id => fnd_global.prog_appl_id
803: ,p_program_id => fnd_global.conc_program_id
804: ,p_request_id => fnd_global.conc_request_id
805: ,p_program_update_date => sysdate
806: ,p_procd_dt => l_procd_dt
807: ,p_strtd_dt => l_strtd_dt
808: ,p_voidd_dt => l_voidd_dt);

Line 1218: ,p_program_application_id => fnd_global.prog_appl_id

1214: ,p_business_group_id => l_min_ptnl.business_group_id
1215: ,p_ntfn_dt => l_min_ptnl.ntfn_dt
1216: ,p_object_version_number => l_object_version_number
1217: ,p_effective_date => p_effective_date
1218: ,p_program_application_id => fnd_global.prog_appl_id
1219: ,p_program_id => fnd_global.conc_program_id
1220: ,p_request_id => fnd_global.conc_request_id
1221: ,p_program_update_date => sysdate
1222: ,p_procd_dt => l_procd_dt

Line 1219: ,p_program_id => fnd_global.conc_program_id

1215: ,p_ntfn_dt => l_min_ptnl.ntfn_dt
1216: ,p_object_version_number => l_object_version_number
1217: ,p_effective_date => p_effective_date
1218: ,p_program_application_id => fnd_global.prog_appl_id
1219: ,p_program_id => fnd_global.conc_program_id
1220: ,p_request_id => fnd_global.conc_request_id
1221: ,p_program_update_date => sysdate
1222: ,p_procd_dt => l_procd_dt
1223: ,p_strtd_dt => l_strtd_dt

Line 1220: ,p_request_id => fnd_global.conc_request_id

1216: ,p_object_version_number => l_object_version_number
1217: ,p_effective_date => p_effective_date
1218: ,p_program_application_id => fnd_global.prog_appl_id
1219: ,p_program_id => fnd_global.conc_program_id
1220: ,p_request_id => fnd_global.conc_request_id
1221: ,p_program_update_date => sysdate
1222: ,p_procd_dt => l_procd_dt
1223: ,p_strtd_dt => l_strtd_dt
1224: ,p_voidd_dt => l_voidd_dt);

Line 1260: ,p_program_application_id => fnd_global.prog_appl_id

1256: ,p_person_id => l_min_ptnl.person_id
1257: ,p_business_group_id => l_min_ptnl.business_group_id
1258: ,p_object_version_number => l_min_ptnl.object_version_number
1259: ,p_effective_date => p_effective_date
1260: ,p_program_application_id => fnd_global.prog_appl_id
1261: ,p_program_id => fnd_global.conc_program_id
1262: ,p_request_id => fnd_global.conc_request_id
1263: ,p_program_update_date => sysdate);
1264: --

Line 1261: ,p_program_id => fnd_global.conc_program_id

1257: ,p_business_group_id => l_min_ptnl.business_group_id
1258: ,p_object_version_number => l_min_ptnl.object_version_number
1259: ,p_effective_date => p_effective_date
1260: ,p_program_application_id => fnd_global.prog_appl_id
1261: ,p_program_id => fnd_global.conc_program_id
1262: ,p_request_id => fnd_global.conc_request_id
1263: ,p_program_update_date => sysdate);
1264: --
1265: end if;

Line 1262: ,p_request_id => fnd_global.conc_request_id

1258: ,p_object_version_number => l_min_ptnl.object_version_number
1259: ,p_effective_date => p_effective_date
1260: ,p_program_application_id => fnd_global.prog_appl_id
1261: ,p_program_id => fnd_global.conc_program_id
1262: ,p_request_id => fnd_global.conc_request_id
1263: ,p_program_update_date => sysdate);
1264: --
1265: end if;
1266: hr_utility.set_location('Leaving:'|| l_proc, 10);

Line 1551: ,p_program_application_id => fnd_global.prog_appl_id

1547: ,p_person_id => p_ptnl_rec.person_id
1548: ,p_business_group_id => p_ptnl_rec.business_group_id
1549: ,p_object_version_number => p_ptnl_rec.object_version_number
1550: ,p_effective_date => p_effective_date
1551: ,p_program_application_id => fnd_global.prog_appl_id
1552: ,p_program_id => fnd_global.conc_program_id
1553: ,p_request_id => fnd_global.conc_request_id
1554: ,p_program_update_date => sysdate);
1555: --

Line 1552: ,p_program_id => fnd_global.conc_program_id

1548: ,p_business_group_id => p_ptnl_rec.business_group_id
1549: ,p_object_version_number => p_ptnl_rec.object_version_number
1550: ,p_effective_date => p_effective_date
1551: ,p_program_application_id => fnd_global.prog_appl_id
1552: ,p_program_id => fnd_global.conc_program_id
1553: ,p_request_id => fnd_global.conc_request_id
1554: ,p_program_update_date => sysdate);
1555: --
1556: end update_ptnl_per_for_ler;

Line 1553: ,p_request_id => fnd_global.conc_request_id

1549: ,p_object_version_number => p_ptnl_rec.object_version_number
1550: ,p_effective_date => p_effective_date
1551: ,p_program_application_id => fnd_global.prog_appl_id
1552: ,p_program_id => fnd_global.conc_program_id
1553: ,p_request_id => fnd_global.conc_request_id
1554: ,p_program_update_date => sysdate);
1555: --
1556: end update_ptnl_per_for_ler;
1557: */

Line 1593: ,p_program_application_id => fnd_global.prog_appl_id

1589: ,p_business_group_id => p_ptnl_rec.business_group_id
1590: ,p_ntfn_dt => p_ptnl_rec.ntfn_dt
1591: ,p_object_version_number => l_object_version_number
1592: ,p_effective_date => p_effective_date
1593: ,p_program_application_id => fnd_global.prog_appl_id
1594: ,p_program_id => fnd_global.conc_program_id
1595: ,p_request_id => fnd_global.conc_request_id
1596: ,p_program_update_date => sysdate
1597: ,p_procd_dt => l_procd_dt

Line 1594: ,p_program_id => fnd_global.conc_program_id

1590: ,p_ntfn_dt => p_ptnl_rec.ntfn_dt
1591: ,p_object_version_number => l_object_version_number
1592: ,p_effective_date => p_effective_date
1593: ,p_program_application_id => fnd_global.prog_appl_id
1594: ,p_program_id => fnd_global.conc_program_id
1595: ,p_request_id => fnd_global.conc_request_id
1596: ,p_program_update_date => sysdate
1597: ,p_procd_dt => l_procd_dt
1598: ,p_strtd_dt => l_strtd_dt

Line 1595: ,p_request_id => fnd_global.conc_request_id

1591: ,p_object_version_number => l_object_version_number
1592: ,p_effective_date => p_effective_date
1593: ,p_program_application_id => fnd_global.prog_appl_id
1594: ,p_program_id => fnd_global.conc_program_id
1595: ,p_request_id => fnd_global.conc_request_id
1596: ,p_program_update_date => sysdate
1597: ,p_procd_dt => l_procd_dt
1598: ,p_strtd_dt => l_strtd_dt
1599: ,p_voidd_dt => l_voidd_dt);

Line 1810: ,p_program_application_id => fnd_global.prog_appl_id

1806: ,p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id
1807: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
1808: ,p_object_version_number => l_potent.object_version_number
1809: ,p_effective_date => p_effective_date
1810: ,p_program_application_id => fnd_global.prog_appl_id
1811: ,p_program_id => fnd_global.conc_program_id
1812: ,p_request_id => fnd_global.conc_request_id
1813: ,p_program_update_date => sysdate
1814: ,p_voidd_dt => p_effective_date);

Line 1811: ,p_program_id => fnd_global.conc_program_id

1807: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
1808: ,p_object_version_number => l_potent.object_version_number
1809: ,p_effective_date => p_effective_date
1810: ,p_program_application_id => fnd_global.prog_appl_id
1811: ,p_program_id => fnd_global.conc_program_id
1812: ,p_request_id => fnd_global.conc_request_id
1813: ,p_program_update_date => sysdate
1814: ,p_voidd_dt => p_effective_date);
1815: --

Line 1812: ,p_request_id => fnd_global.conc_request_id

1808: ,p_object_version_number => l_potent.object_version_number
1809: ,p_effective_date => p_effective_date
1810: ,p_program_application_id => fnd_global.prog_appl_id
1811: ,p_program_id => fnd_global.conc_program_id
1812: ,p_request_id => fnd_global.conc_request_id
1813: ,p_program_update_date => sysdate
1814: ,p_voidd_dt => p_effective_date);
1815: --
1816: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;-- added during iRec

Line 1865: ,p_program_application_id => fnd_global.prog_appl_id

1861: ,p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id
1862: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
1863: ,p_object_version_number => l_potent.object_version_number
1864: ,p_effective_date => p_effective_date
1865: ,p_program_application_id => fnd_global.prog_appl_id
1866: ,p_program_id => fnd_global.conc_program_id
1867: ,p_request_id => fnd_global.conc_request_id
1868: ,p_program_update_date => sysdate
1869: ,p_voidd_dt => p_effective_date);

Line 1866: ,p_program_id => fnd_global.conc_program_id

1862: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
1863: ,p_object_version_number => l_potent.object_version_number
1864: ,p_effective_date => p_effective_date
1865: ,p_program_application_id => fnd_global.prog_appl_id
1866: ,p_program_id => fnd_global.conc_program_id
1867: ,p_request_id => fnd_global.conc_request_id
1868: ,p_program_update_date => sysdate
1869: ,p_voidd_dt => p_effective_date);
1870: --

Line 1867: ,p_request_id => fnd_global.conc_request_id

1863: ,p_object_version_number => l_potent.object_version_number
1864: ,p_effective_date => p_effective_date
1865: ,p_program_application_id => fnd_global.prog_appl_id
1866: ,p_program_id => fnd_global.conc_program_id
1867: ,p_request_id => fnd_global.conc_request_id
1868: ,p_program_update_date => sysdate
1869: ,p_voidd_dt => p_effective_date);
1870: --
1871: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;-- + added during iREC

Line 1949: ,p_program_application_id => fnd_global.prog_appl_id

1945: ,p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id
1946: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
1947: ,p_object_version_number => l_potent.object_version_number
1948: ,p_effective_date => p_effective_date
1949: ,p_program_application_id => fnd_global.prog_appl_id
1950: ,p_program_id => fnd_global.conc_program_id
1951: ,p_request_id => fnd_global.conc_request_id
1952: ,p_program_update_date => sysdate
1953: ,p_voidd_dt => p_effective_date);

Line 1950: ,p_program_id => fnd_global.conc_program_id

1946: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
1947: ,p_object_version_number => l_potent.object_version_number
1948: ,p_effective_date => p_effective_date
1949: ,p_program_application_id => fnd_global.prog_appl_id
1950: ,p_program_id => fnd_global.conc_program_id
1951: ,p_request_id => fnd_global.conc_request_id
1952: ,p_program_update_date => sysdate
1953: ,p_voidd_dt => p_effective_date);
1954: --

Line 1951: ,p_request_id => fnd_global.conc_request_id

1947: ,p_object_version_number => l_potent.object_version_number
1948: ,p_effective_date => p_effective_date
1949: ,p_program_application_id => fnd_global.prog_appl_id
1950: ,p_program_id => fnd_global.conc_program_id
1951: ,p_request_id => fnd_global.conc_request_id
1952: ,p_program_update_date => sysdate
1953: ,p_voidd_dt => p_effective_date);
1954: --
1955: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;

Line 2014: ,p_program_application_id => fnd_global.prog_appl_id

2010: ,p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id
2011: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
2012: ,p_object_version_number => l_potent.object_version_number
2013: ,p_effective_date => p_effective_date
2014: ,p_program_application_id => fnd_global.prog_appl_id
2015: ,p_program_id => fnd_global.conc_program_id
2016: ,p_request_id => fnd_global.conc_request_id
2017: ,p_program_update_date => sysdate
2018: ,p_mnl_dt => p_effective_date);

Line 2015: ,p_program_id => fnd_global.conc_program_id

2011: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
2012: ,p_object_version_number => l_potent.object_version_number
2013: ,p_effective_date => p_effective_date
2014: ,p_program_application_id => fnd_global.prog_appl_id
2015: ,p_program_id => fnd_global.conc_program_id
2016: ,p_request_id => fnd_global.conc_request_id
2017: ,p_program_update_date => sysdate
2018: ,p_mnl_dt => p_effective_date);
2019: --

Line 2016: ,p_request_id => fnd_global.conc_request_id

2012: ,p_object_version_number => l_potent.object_version_number
2013: ,p_effective_date => p_effective_date
2014: ,p_program_application_id => fnd_global.prog_appl_id
2015: ,p_program_id => fnd_global.conc_program_id
2016: ,p_request_id => fnd_global.conc_request_id
2017: ,p_program_update_date => sysdate
2018: ,p_mnl_dt => p_effective_date);
2019: --
2020: l_mnl_ptnl_cnt := l_mnl_ptnl_cnt + 1;

Line 2043: ,p_program_application_id => fnd_global.prog_appl_id

2039: ,p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id
2040: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
2041: ,p_object_version_number => l_potent.object_version_number
2042: ,p_effective_date => p_effective_date
2043: ,p_program_application_id => fnd_global.prog_appl_id
2044: ,p_program_id => fnd_global.conc_program_id
2045: ,p_request_id => fnd_global.conc_request_id
2046: ,p_program_update_date => sysdate
2047: ,p_mnl_dt => p_effective_date);

Line 2044: ,p_program_id => fnd_global.conc_program_id

2040: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
2041: ,p_object_version_number => l_potent.object_version_number
2042: ,p_effective_date => p_effective_date
2043: ,p_program_application_id => fnd_global.prog_appl_id
2044: ,p_program_id => fnd_global.conc_program_id
2045: ,p_request_id => fnd_global.conc_request_id
2046: ,p_program_update_date => sysdate
2047: ,p_mnl_dt => p_effective_date);
2048: --

Line 2045: ,p_request_id => fnd_global.conc_request_id

2041: ,p_object_version_number => l_potent.object_version_number
2042: ,p_effective_date => p_effective_date
2043: ,p_program_application_id => fnd_global.prog_appl_id
2044: ,p_program_id => fnd_global.conc_program_id
2045: ,p_request_id => fnd_global.conc_request_id
2046: ,p_program_update_date => sysdate
2047: ,p_mnl_dt => p_effective_date);
2048: --
2049: l_mnl_ptnl_cnt := l_mnl_ptnl_cnt + 1;

Line 2105: ,p_program_application_id => fnd_global.prog_appl_id

2101: ,p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id
2102: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
2103: ,p_object_version_number => l_potent.object_version_number
2104: ,p_effective_date => p_effective_date
2105: ,p_program_application_id => fnd_global.prog_appl_id
2106: ,p_program_id => fnd_global.conc_program_id
2107: ,p_request_id => fnd_global.conc_request_id
2108: ,p_program_update_date => sysdate
2109: ,p_mnl_dt => p_effective_date);

Line 2106: ,p_program_id => fnd_global.conc_program_id

2102: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
2103: ,p_object_version_number => l_potent.object_version_number
2104: ,p_effective_date => p_effective_date
2105: ,p_program_application_id => fnd_global.prog_appl_id
2106: ,p_program_id => fnd_global.conc_program_id
2107: ,p_request_id => fnd_global.conc_request_id
2108: ,p_program_update_date => sysdate
2109: ,p_mnl_dt => p_effective_date);
2110: --

Line 2107: ,p_request_id => fnd_global.conc_request_id

2103: ,p_object_version_number => l_potent.object_version_number
2104: ,p_effective_date => p_effective_date
2105: ,p_program_application_id => fnd_global.prog_appl_id
2106: ,p_program_id => fnd_global.conc_program_id
2107: ,p_request_id => fnd_global.conc_request_id
2108: ,p_program_update_date => sysdate
2109: ,p_mnl_dt => p_effective_date);
2110: --
2111: l_mnl_ptnl_cnt := l_mnl_ptnl_cnt + 1;

Line 2488: p_program_application_id => fnd_global.prog_appl_id,

2484: p_dtctd_dt => l_dtctd_dt,
2485: p_business_group_id => p_business_group_id,
2486: p_object_version_number => l_object_version_number,
2487: p_effective_date => p_effective_date,
2488: p_program_application_id => fnd_global.prog_appl_id,
2489: p_program_id => fnd_global.conc_program_id,
2490: p_request_id => fnd_global.conc_request_id,
2491: p_program_update_date => sysdate);
2492: --

Line 2489: p_program_id => fnd_global.conc_program_id,

2485: p_business_group_id => p_business_group_id,
2486: p_object_version_number => l_object_version_number,
2487: p_effective_date => p_effective_date,
2488: p_program_application_id => fnd_global.prog_appl_id,
2489: p_program_id => fnd_global.conc_program_id,
2490: p_request_id => fnd_global.conc_request_id,
2491: p_program_update_date => sysdate);
2492: --
2493: -- hr_utility.set_location('Step 5 ' ,195);

Line 2490: p_request_id => fnd_global.conc_request_id,

2486: p_object_version_number => l_object_version_number,
2487: p_effective_date => p_effective_date,
2488: p_program_application_id => fnd_global.prog_appl_id,
2489: p_program_id => fnd_global.conc_program_id,
2490: p_request_id => fnd_global.conc_request_id,
2491: p_program_update_date => sysdate);
2492: --
2493: -- hr_utility.set_location('Step 5 ' ,195);
2494: if l_ptnl_ler_for_per_stat_cd = 'MNL' then

Line 2796: ,p_program_application_id => fnd_global.prog_appl_id

2792: ,p_ptnl_ler_for_per_id => l_ptnl.ptnl_ler_for_per_id
2793: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
2794: ,p_object_version_number => l_ptnl.object_version_number
2795: ,p_effective_date => p_effective_date
2796: ,p_program_application_id => fnd_global.prog_appl_id
2797: ,p_program_id => fnd_global.conc_program_id
2798: ,p_request_id => fnd_global.conc_request_id
2799: ,p_program_update_date => sysdate
2800: ,p_voidd_dt => p_effective_date);

Line 2797: ,p_program_id => fnd_global.conc_program_id

2793: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
2794: ,p_object_version_number => l_ptnl.object_version_number
2795: ,p_effective_date => p_effective_date
2796: ,p_program_application_id => fnd_global.prog_appl_id
2797: ,p_program_id => fnd_global.conc_program_id
2798: ,p_request_id => fnd_global.conc_request_id
2799: ,p_program_update_date => sysdate
2800: ,p_voidd_dt => p_effective_date);
2801: --

Line 2798: ,p_request_id => fnd_global.conc_request_id

2794: ,p_object_version_number => l_ptnl.object_version_number
2795: ,p_effective_date => p_effective_date
2796: ,p_program_application_id => fnd_global.prog_appl_id
2797: ,p_program_id => fnd_global.conc_program_id
2798: ,p_request_id => fnd_global.conc_request_id
2799: ,p_program_update_date => sysdate
2800: ,p_voidd_dt => p_effective_date);
2801: --
2802: end if;

Line 3246: ,p_program_application_id => fnd_global.prog_appl_id

3242: ,p_ptnl_ler_for_per_id => l_ptnl_rec.ptnl_ler_for_per_id
3243: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
3244: ,p_object_version_number => l_ptnl_rec.object_version_number
3245: ,p_effective_date => p_effective_date
3246: ,p_program_application_id => fnd_global.prog_appl_id
3247: ,p_program_id => fnd_global.conc_program_id
3248: ,p_request_id => fnd_global.conc_request_id
3249: ,p_program_update_date => sysdate
3250: ,p_mnl_dt => p_effective_date);

Line 3247: ,p_program_id => fnd_global.conc_program_id

3243: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
3244: ,p_object_version_number => l_ptnl_rec.object_version_number
3245: ,p_effective_date => p_effective_date
3246: ,p_program_application_id => fnd_global.prog_appl_id
3247: ,p_program_id => fnd_global.conc_program_id
3248: ,p_request_id => fnd_global.conc_request_id
3249: ,p_program_update_date => sysdate
3250: ,p_mnl_dt => p_effective_date);
3251: --

Line 3248: ,p_request_id => fnd_global.conc_request_id

3244: ,p_object_version_number => l_ptnl_rec.object_version_number
3245: ,p_effective_date => p_effective_date
3246: ,p_program_application_id => fnd_global.prog_appl_id
3247: ,p_program_id => fnd_global.conc_program_id
3248: ,p_request_id => fnd_global.conc_request_id
3249: ,p_program_update_date => sysdate
3250: ,p_mnl_dt => p_effective_date);
3251: --
3252: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

Line 3637: ,p_program_application_id => fnd_global.prog_appl_id

3633: ,p_person_id => l_ptnl_rec.person_id
3634: ,p_business_group_id => l_ptnl_rec.business_group_id
3635: ,p_object_version_number => l_ptnl_rec.object_version_number
3636: ,p_effective_date => p_lf_evt_ocrd_dt
3637: ,p_program_application_id => fnd_global.prog_appl_id
3638: ,p_program_id => fnd_global.conc_program_id
3639: ,p_request_id => fnd_global.conc_request_id
3640: ,p_program_update_date => sysdate);
3641: --

Line 3638: ,p_program_id => fnd_global.conc_program_id

3634: ,p_business_group_id => l_ptnl_rec.business_group_id
3635: ,p_object_version_number => l_ptnl_rec.object_version_number
3636: ,p_effective_date => p_lf_evt_ocrd_dt
3637: ,p_program_application_id => fnd_global.prog_appl_id
3638: ,p_program_id => fnd_global.conc_program_id
3639: ,p_request_id => fnd_global.conc_request_id
3640: ,p_program_update_date => sysdate);
3641: --
3642: -- Now create the per in ler.

Line 3639: ,p_request_id => fnd_global.conc_request_id

3635: ,p_object_version_number => l_ptnl_rec.object_version_number
3636: ,p_effective_date => p_lf_evt_ocrd_dt
3637: ,p_program_application_id => fnd_global.prog_appl_id
3638: ,p_program_id => fnd_global.conc_program_id
3639: ,p_request_id => fnd_global.conc_request_id
3640: ,p_program_update_date => sysdate);
3641: --
3642: -- Now create the per in ler.
3643: --

Line 3665: p_program_application_id => fnd_global.prog_appl_id,

3661: p_dtctd_dt => l_dtctd_dt,
3662: p_business_group_id => p_business_group_id,
3663: p_object_version_number => l_object_version_number,
3664: p_effective_date => p_lf_evt_ocrd_dt,
3665: p_program_application_id => fnd_global.prog_appl_id,
3666: p_program_id => fnd_global.conc_program_id,
3667: p_request_id => fnd_global.conc_request_id,
3668: p_program_update_date => sysdate);
3669: --

Line 3666: p_program_id => fnd_global.conc_program_id,

3662: p_business_group_id => p_business_group_id,
3663: p_object_version_number => l_object_version_number,
3664: p_effective_date => p_lf_evt_ocrd_dt,
3665: p_program_application_id => fnd_global.prog_appl_id,
3666: p_program_id => fnd_global.conc_program_id,
3667: p_request_id => fnd_global.conc_request_id,
3668: p_program_update_date => sysdate);
3669: --
3670: l_create_pil := 'Y';

Line 3667: p_request_id => fnd_global.conc_request_id,

3663: p_object_version_number => l_object_version_number,
3664: p_effective_date => p_lf_evt_ocrd_dt,
3665: p_program_application_id => fnd_global.prog_appl_id,
3666: p_program_id => fnd_global.conc_program_id,
3667: p_request_id => fnd_global.conc_request_id,
3668: p_program_update_date => sysdate);
3669: --
3670: l_create_pil := 'Y';
3671: --

Line 3689: ,p_program_application_id => fnd_global.prog_appl_id

3685: ,p_ntfn_dt => trunc(sysdate) -- p_ptnl_rec.ntfn_dt
3686: ,p_assignment_id => p_assignment_id
3687: ,p_object_version_number => l_pil_object_version_number
3688: ,p_effective_date => p_lf_evt_ocrd_dt
3689: ,p_program_application_id => fnd_global.prog_appl_id
3690: ,p_program_id => fnd_global.conc_program_id
3691: ,p_request_id => fnd_global.conc_request_id
3692: ,p_program_update_date => sysdate
3693: ,p_procd_dt => l_procd_dt

Line 3690: ,p_program_id => fnd_global.conc_program_id

3686: ,p_assignment_id => p_assignment_id
3687: ,p_object_version_number => l_pil_object_version_number
3688: ,p_effective_date => p_lf_evt_ocrd_dt
3689: ,p_program_application_id => fnd_global.prog_appl_id
3690: ,p_program_id => fnd_global.conc_program_id
3691: ,p_request_id => fnd_global.conc_request_id
3692: ,p_program_update_date => sysdate
3693: ,p_procd_dt => l_procd_dt
3694: ,p_strtd_dt => l_strtd_dt

Line 3691: ,p_request_id => fnd_global.conc_request_id

3687: ,p_object_version_number => l_pil_object_version_number
3688: ,p_effective_date => p_lf_evt_ocrd_dt
3689: ,p_program_application_id => fnd_global.prog_appl_id
3690: ,p_program_id => fnd_global.conc_program_id
3691: ,p_request_id => fnd_global.conc_request_id
3692: ,p_program_update_date => sysdate
3693: ,p_procd_dt => l_procd_dt
3694: ,p_strtd_dt => l_strtd_dt
3695: ,p_voidd_dt => l_voidd_dt);