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 2595: p_program_application_id => fnd_global.prog_appl_id,

2591: p_dtctd_dt => l_dtctd_dt,
2592: p_business_group_id => p_business_group_id,
2593: p_object_version_number => l_object_version_number,
2594: p_effective_date => p_effective_date,
2595: p_program_application_id => fnd_global.prog_appl_id,
2596: p_program_id => fnd_global.conc_program_id,
2597: p_request_id => fnd_global.conc_request_id,
2598: p_program_update_date => sysdate);
2599: --

Line 2596: p_program_id => fnd_global.conc_program_id,

2592: p_business_group_id => p_business_group_id,
2593: p_object_version_number => l_object_version_number,
2594: p_effective_date => p_effective_date,
2595: p_program_application_id => fnd_global.prog_appl_id,
2596: p_program_id => fnd_global.conc_program_id,
2597: p_request_id => fnd_global.conc_request_id,
2598: p_program_update_date => sysdate);
2599: --
2600: -- hr_utility.set_location('Step 5 ' ,195);

Line 2597: p_request_id => fnd_global.conc_request_id,

2593: p_object_version_number => l_object_version_number,
2594: p_effective_date => p_effective_date,
2595: p_program_application_id => fnd_global.prog_appl_id,
2596: p_program_id => fnd_global.conc_program_id,
2597: p_request_id => fnd_global.conc_request_id,
2598: p_program_update_date => sysdate);
2599: --
2600: -- hr_utility.set_location('Step 5 ' ,195);
2601: if l_ptnl_ler_for_per_stat_cd = 'MNL' then

Line 2926: ,p_program_application_id => fnd_global.prog_appl_id

2922: ,p_ptnl_ler_for_per_id => l_ptnl.ptnl_ler_for_per_id
2923: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
2924: ,p_object_version_number => l_ptnl.object_version_number
2925: ,p_effective_date => p_effective_date
2926: ,p_program_application_id => fnd_global.prog_appl_id
2927: ,p_program_id => fnd_global.conc_program_id
2928: ,p_request_id => fnd_global.conc_request_id
2929: ,p_program_update_date => sysdate
2930: ,p_voidd_dt => p_effective_date);

Line 2927: ,p_program_id => fnd_global.conc_program_id

2923: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
2924: ,p_object_version_number => l_ptnl.object_version_number
2925: ,p_effective_date => p_effective_date
2926: ,p_program_application_id => fnd_global.prog_appl_id
2927: ,p_program_id => fnd_global.conc_program_id
2928: ,p_request_id => fnd_global.conc_request_id
2929: ,p_program_update_date => sysdate
2930: ,p_voidd_dt => p_effective_date);
2931: --

Line 2928: ,p_request_id => fnd_global.conc_request_id

2924: ,p_object_version_number => l_ptnl.object_version_number
2925: ,p_effective_date => p_effective_date
2926: ,p_program_application_id => fnd_global.prog_appl_id
2927: ,p_program_id => fnd_global.conc_program_id
2928: ,p_request_id => fnd_global.conc_request_id
2929: ,p_program_update_date => sysdate
2930: ,p_voidd_dt => p_effective_date);
2931: --
2932: end if;

Line 3376: ,p_program_application_id => fnd_global.prog_appl_id

3372: ,p_ptnl_ler_for_per_id => l_ptnl_rec.ptnl_ler_for_per_id
3373: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
3374: ,p_object_version_number => l_ptnl_rec.object_version_number
3375: ,p_effective_date => p_effective_date
3376: ,p_program_application_id => fnd_global.prog_appl_id
3377: ,p_program_id => fnd_global.conc_program_id
3378: ,p_request_id => fnd_global.conc_request_id
3379: ,p_program_update_date => sysdate
3380: ,p_mnl_dt => p_effective_date);

Line 3377: ,p_program_id => fnd_global.conc_program_id

3373: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
3374: ,p_object_version_number => l_ptnl_rec.object_version_number
3375: ,p_effective_date => p_effective_date
3376: ,p_program_application_id => fnd_global.prog_appl_id
3377: ,p_program_id => fnd_global.conc_program_id
3378: ,p_request_id => fnd_global.conc_request_id
3379: ,p_program_update_date => sysdate
3380: ,p_mnl_dt => p_effective_date);
3381: --

Line 3378: ,p_request_id => fnd_global.conc_request_id

3374: ,p_object_version_number => l_ptnl_rec.object_version_number
3375: ,p_effective_date => p_effective_date
3376: ,p_program_application_id => fnd_global.prog_appl_id
3377: ,p_program_id => fnd_global.conc_program_id
3378: ,p_request_id => fnd_global.conc_request_id
3379: ,p_program_update_date => sysdate
3380: ,p_mnl_dt => p_effective_date);
3381: --
3382: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

Line 3767: ,p_program_application_id => fnd_global.prog_appl_id

3763: ,p_person_id => l_ptnl_rec.person_id
3764: ,p_business_group_id => l_ptnl_rec.business_group_id
3765: ,p_object_version_number => l_ptnl_rec.object_version_number
3766: ,p_effective_date => p_lf_evt_ocrd_dt
3767: ,p_program_application_id => fnd_global.prog_appl_id
3768: ,p_program_id => fnd_global.conc_program_id
3769: ,p_request_id => fnd_global.conc_request_id
3770: ,p_program_update_date => sysdate);
3771: --

Line 3768: ,p_program_id => fnd_global.conc_program_id

3764: ,p_business_group_id => l_ptnl_rec.business_group_id
3765: ,p_object_version_number => l_ptnl_rec.object_version_number
3766: ,p_effective_date => p_lf_evt_ocrd_dt
3767: ,p_program_application_id => fnd_global.prog_appl_id
3768: ,p_program_id => fnd_global.conc_program_id
3769: ,p_request_id => fnd_global.conc_request_id
3770: ,p_program_update_date => sysdate);
3771: --
3772: -- Now create the per in ler.

Line 3769: ,p_request_id => fnd_global.conc_request_id

3765: ,p_object_version_number => l_ptnl_rec.object_version_number
3766: ,p_effective_date => p_lf_evt_ocrd_dt
3767: ,p_program_application_id => fnd_global.prog_appl_id
3768: ,p_program_id => fnd_global.conc_program_id
3769: ,p_request_id => fnd_global.conc_request_id
3770: ,p_program_update_date => sysdate);
3771: --
3772: -- Now create the per in ler.
3773: --

Line 3795: p_program_application_id => fnd_global.prog_appl_id,

3791: p_dtctd_dt => l_dtctd_dt,
3792: p_business_group_id => p_business_group_id,
3793: p_object_version_number => l_object_version_number,
3794: p_effective_date => p_lf_evt_ocrd_dt,
3795: p_program_application_id => fnd_global.prog_appl_id,
3796: p_program_id => fnd_global.conc_program_id,
3797: p_request_id => fnd_global.conc_request_id,
3798: p_program_update_date => sysdate);
3799: --

Line 3796: p_program_id => fnd_global.conc_program_id,

3792: p_business_group_id => p_business_group_id,
3793: p_object_version_number => l_object_version_number,
3794: p_effective_date => p_lf_evt_ocrd_dt,
3795: p_program_application_id => fnd_global.prog_appl_id,
3796: p_program_id => fnd_global.conc_program_id,
3797: p_request_id => fnd_global.conc_request_id,
3798: p_program_update_date => sysdate);
3799: --
3800: l_create_pil := 'Y';

Line 3797: p_request_id => fnd_global.conc_request_id,

3793: p_object_version_number => l_object_version_number,
3794: p_effective_date => p_lf_evt_ocrd_dt,
3795: p_program_application_id => fnd_global.prog_appl_id,
3796: p_program_id => fnd_global.conc_program_id,
3797: p_request_id => fnd_global.conc_request_id,
3798: p_program_update_date => sysdate);
3799: --
3800: l_create_pil := 'Y';
3801: --

Line 3819: ,p_program_application_id => fnd_global.prog_appl_id

3815: ,p_ntfn_dt => trunc(sysdate) -- p_ptnl_rec.ntfn_dt
3816: ,p_assignment_id => p_assignment_id
3817: ,p_object_version_number => l_pil_object_version_number
3818: ,p_effective_date => p_lf_evt_ocrd_dt
3819: ,p_program_application_id => fnd_global.prog_appl_id
3820: ,p_program_id => fnd_global.conc_program_id
3821: ,p_request_id => fnd_global.conc_request_id
3822: ,p_program_update_date => sysdate
3823: ,p_procd_dt => l_procd_dt

Line 3820: ,p_program_id => fnd_global.conc_program_id

3816: ,p_assignment_id => p_assignment_id
3817: ,p_object_version_number => l_pil_object_version_number
3818: ,p_effective_date => p_lf_evt_ocrd_dt
3819: ,p_program_application_id => fnd_global.prog_appl_id
3820: ,p_program_id => fnd_global.conc_program_id
3821: ,p_request_id => fnd_global.conc_request_id
3822: ,p_program_update_date => sysdate
3823: ,p_procd_dt => l_procd_dt
3824: ,p_strtd_dt => l_strtd_dt

Line 3821: ,p_request_id => fnd_global.conc_request_id

3817: ,p_object_version_number => l_pil_object_version_number
3818: ,p_effective_date => p_lf_evt_ocrd_dt
3819: ,p_program_application_id => fnd_global.prog_appl_id
3820: ,p_program_id => fnd_global.conc_program_id
3821: ,p_request_id => fnd_global.conc_request_id
3822: ,p_program_update_date => sysdate
3823: ,p_procd_dt => l_procd_dt
3824: ,p_strtd_dt => l_strtd_dt
3825: ,p_voidd_dt => l_voidd_dt);