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.BEN_CTP_BUS dependencies on BEN_CTP_SHD

Line 186: l_api_updating := ben_ctp_shd.api_updating

182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: l_api_updating := ben_ctp_shd.api_updating
187: (p_ptip_id => p_ptip_id,
188: p_effective_date => p_effective_date,
189: p_object_version_number => p_object_version_number);
190: --

Line 193: <> nvl(ben_ctp_shd.g_old_rec.wvbl_flag,hr_api.g_varchar2)

189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and p_wvbl_flag
193: <> nvl(ben_ctp_shd.g_old_rec.wvbl_flag,hr_api.g_varchar2)
194: or not l_api_updating) then
195:
196: if p_wvbl_flag = 'Y' then
197: open c1;

Line 256: l_api_updating := ben_ctp_shd.api_updating

252: Begin
253: --
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: l_api_updating := ben_ctp_shd.api_updating
257: (p_ptip_id => p_ptip_id,
258: p_effective_date => p_effective_date,
259: p_object_version_number => p_object_version_number);
260: --

Line 398: l_api_updating := ben_ctp_shd.api_updating

394: Begin
395: --
396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: l_api_updating := ben_ctp_shd.api_updating
399: (p_effective_date => p_effective_date,
400: p_ptip_id => p_ptip_id,
401: p_object_version_number => p_object_version_number);
402: --

Line 405: <> ben_ctp_shd.g_old_rec.ptip_id) then

401: p_object_version_number => p_object_version_number);
402: --
403: if (l_api_updating
404: and nvl(p_ptip_id,hr_api.g_number)
405: <> ben_ctp_shd.g_old_rec.ptip_id) then
406: --
407: -- raise error as PK has changed
408: --
409: ben_ctp_shd.constraint_error('BEN_PTIP_PK');

Line 409: ben_ctp_shd.constraint_error('BEN_PTIP_PK');

405: <> ben_ctp_shd.g_old_rec.ptip_id) then
406: --
407: -- raise error as PK has changed
408: --
409: ben_ctp_shd.constraint_error('BEN_PTIP_PK');
410: --
411: elsif not l_api_updating then
412: --
413: -- check if PK is null

Line 419: ben_ctp_shd.constraint_error('BEN_PTIP_PK');

415: if p_ptip_id is not null then
416: --
417: -- raise error as PK is not null
418: --
419: ben_ctp_shd.constraint_error('BEN_PTIP_PK');
420: --
421: end if;
422: --
423: end if;

Line 467: l_api_updating := ben_ctp_shd.api_updating

463: Begin
464: --
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: --
467: l_api_updating := ben_ctp_shd.api_updating
468: (p_ptip_id => p_ptip_id,
469: p_effective_date => p_effective_date,
470: p_object_version_number => p_object_version_number);
471: --

Line 474: <> nvl(ben_ctp_shd.g_old_rec.rqd_enrt_perd_tco_cd,hr_api.g_varchar2)

470: p_object_version_number => p_object_version_number);
471: --
472: if (l_api_updating
473: and p_rqd_enrt_perd_tco_cd
474: <> nvl(ben_ctp_shd.g_old_rec.rqd_enrt_perd_tco_cd,hr_api.g_varchar2)
475: or not l_api_updating)
476: and p_rqd_enrt_perd_tco_cd is not null then
477: --
478: -- check if value of lookup falls within lookup type.

Line 511: l_api_updating := ben_ctp_shd.api_updating

507: Begin
508: --
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: l_api_updating := ben_ctp_shd.api_updating
512: (p_ptip_id => p_ptip_id,
513: p_effective_date => p_effective_date,
514: p_object_version_number => p_object_version_number);
515: --

Line 518: <> nvl(ben_ctp_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)

514: p_object_version_number => p_object_version_number);
515: --
516: if (l_api_updating
517: and p_vrfy_fmly_mmbr_cd
518: <> nvl(ben_ctp_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)
519: or not l_api_updating)
520: and p_vrfy_fmly_mmbr_cd is not null
521: then
522: --

Line 566: l_api_updating := ben_ctp_shd.api_updating

562: Begin
563: --
564: hr_utility.set_location('Entering:'||l_proc, 5);
565: --
566: l_api_updating := ben_ctp_shd.api_updating
567: (p_effective_date => p_effective_date,
568: p_ptip_id => p_ptip_id,
569: p_object_version_number => p_object_version_number);
570: --

Line 573: <> ben_ctp_shd.g_old_rec.vrfy_fmly_mmbr_rl

569: p_object_version_number => p_object_version_number);
570: --
571: if (l_api_updating
572: and nvl(p_vrfy_fmly_mmbr_rl,hr_api.g_number)
573: <> ben_ctp_shd.g_old_rec.vrfy_fmly_mmbr_rl
574: or not l_api_updating)
575: and p_vrfy_fmly_mmbr_rl is not null then
576: --
577: -- check if value of formula rule is valid.

Line 643: l_api_updating := ben_ctp_shd.api_updating

639: Begin
640: --
641: hr_utility.set_location('Entering:'||l_proc, 5);
642: --
643: l_api_updating := ben_ctp_shd.api_updating
644: (p_ptip_id => p_ptip_id,
645: p_effective_date => p_effective_date,
646: p_object_version_number => p_object_version_number);
647: --

Line 650: <> nvl(ben_ctp_shd.g_old_rec.no_mn_pl_typ_overid_flag,hr_api.g_varchar2)

646: p_object_version_number => p_object_version_number);
647: --
648: if (l_api_updating
649: and p_no_mn_pl_typ_overid_flag
650: <> nvl(ben_ctp_shd.g_old_rec.no_mn_pl_typ_overid_flag,hr_api.g_varchar2)
651: or not l_api_updating)
652: and p_no_mn_pl_typ_overid_flag is not null then
653: --
654: -- check if value of lookup falls within lookup type.

Line 712: l_api_updating := ben_ctp_shd.api_updating

708: Begin
709: --
710: hr_utility.set_location('Entering:'||l_proc, 5);
711: --
712: l_api_updating := ben_ctp_shd.api_updating
713: (p_ptip_id => p_ptip_id,
714: p_effective_date => p_effective_date,
715: p_object_version_number => p_object_version_number);
716: --

Line 719: <> nvl(ben_ctp_shd.g_old_rec.drvbl_fctr_apls_rts_flag,hr_api.g_varchar2)

715: p_object_version_number => p_object_version_number);
716: --
717: if (l_api_updating
718: and p_drvbl_fctr_apls_rts_flag
719: <> nvl(ben_ctp_shd.g_old_rec.drvbl_fctr_apls_rts_flag,hr_api.g_varchar2)
720: or not l_api_updating)
721: and p_drvbl_fctr_apls_rts_flag is not null then
722: --
723: -- check if value of lookup falls within lookup type.

Line 783: l_api_updating := ben_ctp_shd.api_updating

779: Begin
780: --
781: hr_utility.set_location('Entering:'||l_proc, 5);
782: --
783: l_api_updating := ben_ctp_shd.api_updating
784: (p_ptip_id => p_ptip_id,
785: p_effective_date => p_effective_date,
786: p_object_version_number => p_object_version_number);
787: --

Line 790: <> nvl(ben_ctp_shd.g_old_rec.drvbl_fctr_prtn_elig_flag,hr_api.g_varchar2)

786: p_object_version_number => p_object_version_number);
787: --
788: if (l_api_updating
789: and p_drvbl_fctr_prtn_elig_flag
790: <> nvl(ben_ctp_shd.g_old_rec.drvbl_fctr_prtn_elig_flag,hr_api.g_varchar2)
791: or not l_api_updating)
792: and p_drvbl_fctr_prtn_elig_flag is not null then
793: --
794: -- check if value of lookup falls within lookup type.

Line 905: l_api_updating := ben_ctp_shd.api_updating

901: Begin
902: --
903: hr_utility.set_location('Entering:'||l_proc, 5);
904: --
905: l_api_updating := ben_ctp_shd.api_updating
906: (p_ptip_id => p_ptip_id,
907: p_effective_date => p_effective_date,
908: p_object_version_number => p_object_version_number);
909: --

Line 912: <> nvl(ben_ctp_shd.g_old_rec.elig_apls_flag,hr_api.g_varchar2)

908: p_object_version_number => p_object_version_number);
909: --
910: if (l_api_updating
911: and p_elig_apls_flag
912: <> nvl(ben_ctp_shd.g_old_rec.elig_apls_flag,hr_api.g_varchar2)
913: or not l_api_updating)
914: and p_elig_apls_flag is not null then
915: --
916: -- check if value of lookup falls within lookup type.

Line 977: l_api_updating := ben_ctp_shd.api_updating

973: Begin
974: --
975: hr_utility.set_location('Entering:'||l_proc, 5);
976: --
977: l_api_updating := ben_ctp_shd.api_updating
978: (p_ptip_id => p_ptip_id,
979: p_effective_date => p_effective_date,
980: p_object_version_number => p_object_version_number);
981: --

Line 984: <> nvl(ben_ctp_shd.g_old_rec.prtn_elig_ovrid_alwd_flag,hr_api.g_varchar2)

980: p_object_version_number => p_object_version_number);
981: --
982: if (l_api_updating
983: and p_prtn_elig_ovrid_alwd_flag
984: <> nvl(ben_ctp_shd.g_old_rec.prtn_elig_ovrid_alwd_flag,hr_api.g_varchar2)
985: or not l_api_updating)
986: and p_prtn_elig_ovrid_alwd_flag is not null then
987: --
988: -- check if value of lookup falls within lookup type.

Line 1049: l_api_updating := ben_ctp_shd.api_updating

1045: Begin
1046: --
1047: hr_utility.set_location('Entering:'||l_proc, 5);
1048: --
1049: l_api_updating := ben_ctp_shd.api_updating
1050: (p_ptip_id => p_ptip_id,
1051: p_effective_date => p_effective_date,
1052: p_object_version_number => p_object_version_number);
1053: --

Line 1056: <> nvl(ben_ctp_shd.g_old_rec.trk_inelig_per_flag,hr_api.g_varchar2)

1052: p_object_version_number => p_object_version_number);
1053: --
1054: if (l_api_updating
1055: and p_trk_inelig_per_flag
1056: <> nvl(ben_ctp_shd.g_old_rec.trk_inelig_per_flag,hr_api.g_varchar2)
1057: or not l_api_updating)
1058: and p_trk_inelig_per_flag is not null then
1059: --
1060: -- check if value of lookup falls within lookup type.

Line 1120: l_api_updating := ben_ctp_shd.api_updating

1116: Begin
1117: --
1118: hr_utility.set_location('Entering:'||l_proc, 5);
1119: --
1120: l_api_updating := ben_ctp_shd.api_updating
1121: (p_ptip_id => p_ptip_id,
1122: p_effective_date => p_effective_date,
1123: p_object_version_number => p_object_version_number);
1124: --

Line 1127: <> nvl(ben_ctp_shd.g_old_rec.sbj_to_sps_lf_ins_mx_flag,hr_api.g_varchar2)

1123: p_object_version_number => p_object_version_number);
1124: --
1125: if (l_api_updating
1126: and p_sbj_to_sps_lf_ins_mx_flag
1127: <> nvl(ben_ctp_shd.g_old_rec.sbj_to_sps_lf_ins_mx_flag,hr_api.g_varchar2)
1128: or not l_api_updating)
1129: and p_sbj_to_sps_lf_ins_mx_flag is not null then
1130: --
1131: -- check if value of lookup falls within lookup type.

Line 1191: l_api_updating := ben_ctp_shd.api_updating

1187: Begin
1188: --
1189: hr_utility.set_location('Entering:'||l_proc, 5);
1190: --
1191: l_api_updating := ben_ctp_shd.api_updating
1192: (p_ptip_id => p_ptip_id,
1193: p_effective_date => p_effective_date,
1194: p_object_version_number => p_object_version_number);
1195: --

Line 1198: <> nvl(ben_ctp_shd.g_old_rec.sbj_to_dpnt_lf_ins_mx_flag,hr_api.g_varchar2)

1194: p_object_version_number => p_object_version_number);
1195: --
1196: if (l_api_updating
1197: and p_sbj_to_dpnt_lf_ins_mx_flag
1198: <> nvl(ben_ctp_shd.g_old_rec.sbj_to_dpnt_lf_ins_mx_flag,hr_api.g_varchar2)
1199: or not l_api_updating)
1200: and p_sbj_to_dpnt_lf_ins_mx_flag is not null then
1201: --
1202: -- check if value of lookup falls within lookup type.

Line 1262: l_api_updating := ben_ctp_shd.api_updating

1258: Begin
1259: --
1260: hr_utility.set_location('Entering:'||l_proc, 5);
1261: --
1262: l_api_updating := ben_ctp_shd.api_updating
1263: (p_ptip_id => p_ptip_id,
1264: p_effective_date => p_effective_date,
1265: p_object_version_number => p_object_version_number);
1266: --

Line 1269: <> nvl(ben_ctp_shd.g_old_rec.use_to_sum_ee_lf_ins_flag,hr_api.g_varchar2)

1265: p_object_version_number => p_object_version_number);
1266: --
1267: if (l_api_updating
1268: and p_use_to_sum_ee_lf_ins_flag
1269: <> nvl(ben_ctp_shd.g_old_rec.use_to_sum_ee_lf_ins_flag,hr_api.g_varchar2)
1270: or not l_api_updating)
1271: and p_use_to_sum_ee_lf_ins_flag is not null then
1272: --
1273: -- check if value of lookup falls within lookup type.

Line 1333: l_api_updating := ben_ctp_shd.api_updating

1329: Begin
1330: --
1331: hr_utility.set_location('Entering:'||l_proc, 5);
1332: --
1333: l_api_updating := ben_ctp_shd.api_updating
1334: (p_ptip_id => p_ptip_id,
1335: p_effective_date => p_effective_date,
1336: p_object_version_number => p_object_version_number);
1337: --

Line 1340: <> nvl(ben_ctp_shd.g_old_rec.drvd_fctr_dpnt_cvg_flag,hr_api.g_varchar2)

1336: p_object_version_number => p_object_version_number);
1337: --
1338: if (l_api_updating
1339: and p_drvd_fctr_dpnt_cvg_flag
1340: <> nvl(ben_ctp_shd.g_old_rec.drvd_fctr_dpnt_cvg_flag,hr_api.g_varchar2)
1341: or not l_api_updating)
1342: and p_drvd_fctr_dpnt_cvg_flag is not null then
1343: --
1344: -- check if value of lookup falls within lookup type.

Line 1402: l_api_updating := ben_ctp_shd.api_updating

1398: Begin
1399: --
1400: hr_utility.set_location('Entering:'||l_proc, 5);
1401: --
1402: l_api_updating := ben_ctp_shd.api_updating
1403: (p_ptip_id => p_ptip_id,
1404: p_effective_date => p_effective_date,
1405: p_object_version_number => p_object_version_number);
1406: --

Line 1409: <> nvl(ben_ctp_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2)

1405: p_object_version_number => p_object_version_number);
1406: --
1407: if (l_api_updating
1408: and p_dpnt_dob_rqd_flag
1409: <> nvl(ben_ctp_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2)
1410: or not l_api_updating)
1411: and p_dpnt_dob_rqd_flag is not null then
1412: --
1413: -- check if value of lookup falls within lookup type.

Line 1474: l_api_updating := ben_ctp_shd.api_updating

1470: Begin
1471: --
1472: hr_utility.set_location('Entering:'||l_proc, 5);
1473: --
1474: l_api_updating := ben_ctp_shd.api_updating
1475: (p_ptip_id => p_ptip_id,
1476: p_effective_date => p_effective_date,
1477: p_object_version_number => p_object_version_number);
1478: --

Line 1481: <> nvl(ben_ctp_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2)

1477: p_object_version_number => p_object_version_number);
1478: --
1479: if (l_api_updating
1480: and p_dpnt_legv_id_rqd_flag
1481: <> nvl(ben_ctp_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
1482: or not l_api_updating)
1483: and p_dpnt_legv_id_rqd_flag is not null then
1484: --
1485: -- check if value of lookup falls within lookup type.

Line 1545: l_api_updating := ben_ctp_shd.api_updating

1541: Begin
1542: --
1543: hr_utility.set_location('Entering:'||l_proc, 5);
1544: --
1545: l_api_updating := ben_ctp_shd.api_updating
1546: (p_ptip_id => p_ptip_id,
1547: p_effective_date => p_effective_date,
1548: p_object_version_number => p_object_version_number);
1549: --

Line 1552: <> nvl(ben_ctp_shd.g_old_rec.wvbl_flag,hr_api.g_varchar2)

1548: p_object_version_number => p_object_version_number);
1549: --
1550: if (l_api_updating
1551: and p_wvbl_flag
1552: <> nvl(ben_ctp_shd.g_old_rec.wvbl_flag,hr_api.g_varchar2)
1553: or not l_api_updating)
1554: and p_wvbl_flag is not null then
1555: --
1556: -- check if value of lookup falls within lookup type.

Line 1614: l_api_updating := ben_ctp_shd.api_updating

1610: Begin
1611: --
1612: hr_utility.set_location('Entering:'||l_proc, 5);
1613: --
1614: l_api_updating := ben_ctp_shd.api_updating
1615: (p_ptip_id => p_ptip_id,
1616: p_effective_date => p_effective_date,
1617: p_object_version_number => p_object_version_number);
1618: --

Line 1621: <> nvl(ben_ctp_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2)

1617: p_object_version_number => p_object_version_number);
1618: --
1619: if (l_api_updating
1620: and p_dpnt_adrs_rqd_flag
1621: <> nvl(ben_ctp_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2)
1622: or not l_api_updating)
1623: and p_dpnt_adrs_rqd_flag is not null then
1624: --
1625: -- check if value of lookup falls within lookup type.

Line 1686: l_api_updating := ben_ctp_shd.api_updating

1682: Begin
1683: --
1684: hr_utility.set_location('Entering:'||l_proc, 5);
1685: --
1686: l_api_updating := ben_ctp_shd.api_updating
1687: (p_ptip_id => p_ptip_id,
1688: p_effective_date => p_effective_date,
1689: p_object_version_number => p_object_version_number);
1690: --

Line 1693: <> nvl(ben_ctp_shd.g_old_rec.dpnt_cvg_no_ctfn_rqd_flag,hr_api.g_varchar2)

1689: p_object_version_number => p_object_version_number);
1690: --
1691: if (l_api_updating
1692: and p_dpnt_cvg_no_ctfn_rqd_flag
1693: <> nvl(ben_ctp_shd.g_old_rec.dpnt_cvg_no_ctfn_rqd_flag,hr_api.g_varchar2)
1694: or not l_api_updating)
1695: and p_dpnt_cvg_no_ctfn_rqd_flag is not null then
1696: --
1697: -- check if value of lookup falls within lookup type.

Line 1757: l_api_updating := ben_ctp_shd.api_updating

1753: Begin
1754: --
1755: hr_utility.set_location('Entering:'||l_proc, 5);
1756: --
1757: l_api_updating := ben_ctp_shd.api_updating
1758: (p_ptip_id => p_ptip_id,
1759: p_effective_date => p_effective_date,
1760: p_object_version_number => p_object_version_number);
1761: --

Line 1764: <> nvl(ben_ctp_shd.g_old_rec.rqd_perd_enrt_nenrt_tm_uom,hr_api.g_varchar2)

1760: p_object_version_number => p_object_version_number);
1761: --
1762: if (l_api_updating
1763: and p_rqd_perd_enrt_nenrt_tm_uom
1764: <> nvl(ben_ctp_shd.g_old_rec.rqd_perd_enrt_nenrt_tm_uom,hr_api.g_varchar2)
1765: or not l_api_updating)
1766: and p_rqd_perd_enrt_nenrt_tm_uom is not null then
1767: --
1768: -- check if value of lookup falls within lookup type.

Line 1826: l_api_updating := ben_ctp_shd.api_updating

1822: Begin
1823: --
1824: hr_utility.set_location('Entering:'||l_proc, 5);
1825: --
1826: l_api_updating := ben_ctp_shd.api_updating
1827: (p_ptip_id => p_ptip_id,
1828: p_effective_date => p_effective_date,
1829: p_object_version_number => p_object_version_number);
1830: --

Line 1833: <> nvl(ben_ctp_shd.g_old_rec.prvds_cr_flag,hr_api.g_varchar2)

1829: p_object_version_number => p_object_version_number);
1830: --
1831: if (l_api_updating
1832: and p_prvds_cr_flag
1833: <> nvl(ben_ctp_shd.g_old_rec.prvds_cr_flag,hr_api.g_varchar2)
1834: or not l_api_updating)
1835: and p_prvds_cr_flag is not null then
1836: --
1837: -- check if value of lookup falls within lookup type.

Line 1895: l_api_updating := ben_ctp_shd.api_updating

1891: Begin
1892: --
1893: hr_utility.set_location('Entering:'||l_proc, 5);
1894: --
1895: l_api_updating := ben_ctp_shd.api_updating
1896: (p_ptip_id => p_ptip_id,
1897: p_effective_date => p_effective_date,
1898: p_object_version_number => p_object_version_number);
1899: --

Line 1902: <> nvl(ben_ctp_shd.g_old_rec.no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2)

1898: p_object_version_number => p_object_version_number);
1899: --
1900: if (l_api_updating
1901: and p_no_mx_pl_typ_ovrid_flag
1902: <> nvl(ben_ctp_shd.g_old_rec.no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2)
1903: or not l_api_updating)
1904: and p_no_mx_pl_typ_ovrid_flag is not null then
1905: --
1906: -- check if value of lookup falls within lookup type.

Line 1964: l_api_updating := ben_ctp_shd.api_updating

1960: Begin
1961: --
1962: hr_utility.set_location('Entering:'||l_proc, 5);
1963: --
1964: l_api_updating := ben_ctp_shd.api_updating
1965: (p_ptip_id => p_ptip_id,
1966: p_effective_date => p_effective_date,
1967: p_object_version_number => p_object_version_number);
1968: --

Line 1971: <> nvl(ben_ctp_shd.g_old_rec.ptip_stat_cd,hr_api.g_varchar2)

1967: p_object_version_number => p_object_version_number);
1968: --
1969: if (l_api_updating
1970: and p_ptip_stat_cd
1971: <> nvl(ben_ctp_shd.g_old_rec.ptip_stat_cd,hr_api.g_varchar2)
1972: or not l_api_updating) then
1973: --
1974: -- check if value of lookup falls within lookup type.
1975: --

Line 2034: l_api_updating := ben_ctp_shd.api_updating

2030: Begin
2031: --
2032: hr_utility.set_location('Entering:'||l_proc, 5);
2033: --
2034: l_api_updating := ben_ctp_shd.api_updating
2035: (p_ptip_id => p_ptip_id,
2036: p_effective_date => p_effective_date,
2037: p_object_version_number => p_object_version_number);
2038: --

Line 2041: <> nvl(ben_ctp_shd.g_old_rec.crs_this_pl_typ_only_flag,hr_api.g_varchar2)

2037: p_object_version_number => p_object_version_number);
2038: --
2039: if (l_api_updating
2040: and p_crs_this_pl_typ_only_flag
2041: <> nvl(ben_ctp_shd.g_old_rec.crs_this_pl_typ_only_flag,hr_api.g_varchar2)
2042: or not l_api_updating)
2043: and p_crs_this_pl_typ_only_flag is not null then
2044: --
2045: -- check if value of lookup falls within lookup type.

Line 2108: l_api_updating := ben_ctp_shd.api_updating

2104: Begin
2105: --
2106: hr_utility.set_location('Entering:'||l_proc, 5);
2107: --
2108: l_api_updating := ben_ctp_shd.api_updating
2109: (p_ptip_id => p_ptip_id,
2110: p_effective_date => p_effective_date,
2111: p_object_version_number => p_object_version_number);
2112: --

Line 2115: <> nvl(ben_ctp_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2)

2111: p_object_version_number => p_object_version_number);
2112: --
2113: if (l_api_updating
2114: and p_dpnt_dsgn_cd
2115: <> nvl(ben_ctp_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2)
2116: or not l_api_updating) then
2117: --
2118: -- check if value of lookup falls within lookup type.
2119: --

Line 2206: l_api_updating := ben_ctp_shd.api_updating

2202: Begin
2203: --
2204: hr_utility.set_location('Entering:'||l_proc, 5);
2205: --
2206: l_api_updating := ben_ctp_shd.api_updating
2207: (p_ptip_id => p_ptip_id,
2208: p_effective_date => p_effective_date,
2209: p_object_version_number => p_object_version_number);
2210: --

Line 2213: <> ben_ctp_shd.g_old_rec.postelcn_edit_rl

2209: p_object_version_number => p_object_version_number);
2210: --
2211: if (l_api_updating
2212: and nvl(p_postelcn_edit_rl,hr_api.g_number)
2213: <> ben_ctp_shd.g_old_rec.postelcn_edit_rl
2214: or not l_api_updating)
2215: and p_postelcn_edit_rl is not null then
2216: --
2217: -- check if value of formula rule is valid.

Line 2302: l_api_updating := ben_ctp_shd.api_updating

2298: Begin
2299: --
2300: hr_utility.set_location('Entering:'||l_proc, 5);
2301: --
2302: l_api_updating := ben_ctp_shd.api_updating
2303: (p_ptip_id => p_ptip_id,
2304: p_effective_date => p_effective_date,
2305: p_object_version_number => p_object_version_number);
2306: --

Line 2309: <> ben_ctp_shd.g_old_rec.rt_end_dt_rl

2305: p_object_version_number => p_object_version_number);
2306: --
2307: if (l_api_updating
2308: and nvl(p_rt_end_dt_rl,hr_api.g_number)
2309: <> ben_ctp_shd.g_old_rec.rt_end_dt_rl
2310: or not l_api_updating)
2311: and p_rt_end_dt_rl is not null then
2312: --
2313: -- check if value of formula rule is valid.

Line 2399: l_api_updating := ben_ctp_shd.api_updating

2395: Begin
2396: --
2397: hr_utility.set_location('Entering:'||l_proc, 5);
2398: --
2399: l_api_updating := ben_ctp_shd.api_updating
2400: (p_ptip_id => p_ptip_id,
2401: p_effective_date => p_effective_date,
2402: p_object_version_number => p_object_version_number);
2403: --

Line 2406: <> ben_ctp_shd.g_old_rec.rt_strt_dt_rl

2402: p_object_version_number => p_object_version_number);
2403: --
2404: if (l_api_updating
2405: and nvl(p_rt_strt_dt_rl,hr_api.g_number)
2406: <> ben_ctp_shd.g_old_rec.rt_strt_dt_rl
2407: or not l_api_updating)
2408: and p_rt_strt_dt_rl is not null then
2409: --
2410: -- check if value of formula rule is valid.

Line 2495: l_api_updating := ben_ctp_shd.api_updating

2491: Begin
2492: --
2493: hr_utility.set_location('Entering:'||l_proc, 5);
2494: --
2495: l_api_updating := ben_ctp_shd.api_updating
2496: (p_ptip_id => p_ptip_id,
2497: p_effective_date => p_effective_date,
2498: p_object_version_number => p_object_version_number);
2499: --

Line 2502: <> ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_rl

2498: p_object_version_number => p_object_version_number);
2499: --
2500: if (l_api_updating
2501: and nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
2502: <> ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_rl
2503: or not l_api_updating)
2504: and p_enrt_cvg_end_dt_rl is not null then
2505: --
2506: -- check if value of formula rule is valid.

Line 2591: l_api_updating := ben_ctp_shd.api_updating

2587: Begin
2588: --
2589: hr_utility.set_location('Entering:'||l_proc, 5);
2590: --
2591: l_api_updating := ben_ctp_shd.api_updating
2592: (p_ptip_id => p_ptip_id,
2593: p_effective_date => p_effective_date,
2594: p_object_version_number => p_object_version_number);
2595: --

Line 2598: <> ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_rl

2594: p_object_version_number => p_object_version_number);
2595: --
2596: if (l_api_updating
2597: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
2598: <> ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_rl
2599: or not l_api_updating)
2600: and p_enrt_cvg_strt_dt_rl is not null then
2601: --
2602: -- check if value of formula rule is valid.

Line 2688: l_api_updating := ben_ctp_shd.api_updating

2684: Begin
2685: --
2686: hr_utility.set_location('Entering:'||l_proc, 5);
2687: --
2688: l_api_updating := ben_ctp_shd.api_updating
2689: (p_ptip_id => p_ptip_id,
2690: p_effective_date => p_effective_date,
2691: p_object_version_number => p_object_version_number);
2692: --

Line 2695: <> ben_ctp_shd.g_old_rec.rqd_perd_enrt_nenrt_rl

2691: p_object_version_number => p_object_version_number);
2692: --
2693: if (l_api_updating
2694: and nvl(p_rqd_perd_enrt_nenrt_rl,hr_api.g_number)
2695: <> ben_ctp_shd.g_old_rec.rqd_perd_enrt_nenrt_rl
2696: or not l_api_updating)
2697: and p_rqd_perd_enrt_nenrt_rl is not null then
2698: --
2699: -- check if value of formula rule is valid.

Line 2784: l_api_updating := ben_ctp_shd.api_updating

2780: Begin
2781: --
2782: hr_utility.set_location('Entering:'||l_proc, 5);
2783: --
2784: l_api_updating := ben_ctp_shd.api_updating
2785: (p_ptip_id => p_ptip_id,
2786: p_effective_date => p_effective_date,
2787: p_object_version_number => p_object_version_number);
2788: --

Line 2791: <> ben_ctp_shd.g_old_rec.auto_enrt_mthd_rl

2787: p_object_version_number => p_object_version_number);
2788: --
2789: if (l_api_updating
2790: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)
2791: <> ben_ctp_shd.g_old_rec.auto_enrt_mthd_rl
2792: or not l_api_updating)
2793: and p_auto_enrt_mthd_rl is not null then
2794: --
2795: -- check if value of formula rule is valid.

Line 2880: l_api_updating := ben_ctp_shd.api_updating

2876: Begin
2877: --
2878: hr_utility.set_location('Entering:'||l_proc, 5);
2879: --
2880: l_api_updating := ben_ctp_shd.api_updating
2881: (p_ptip_id => p_ptip_id,
2882: p_effective_date => p_effective_date,
2883: p_object_version_number => p_object_version_number);
2884: --

Line 2887: <> ben_ctp_shd.g_old_rec.enrt_rl

2883: p_object_version_number => p_object_version_number);
2884: --
2885: if (l_api_updating
2886: and nvl(p_enrt_rl,hr_api.g_number)
2887: <> ben_ctp_shd.g_old_rec.enrt_rl
2888: or not l_api_updating)
2889: and p_enrt_rl is not null then
2890: --
2891: -- check if value of formula rule is valid.

Line 2976: l_api_updating := ben_ctp_shd.api_updating

2972: Begin
2973: --
2974: hr_utility.set_location('Entering:'||l_proc, 5);
2975: --
2976: l_api_updating := ben_ctp_shd.api_updating
2977: (p_ptip_id => p_ptip_id,
2978: p_effective_date => p_effective_date,
2979: p_object_version_number => p_object_version_number);
2980: --

Line 2983: <> ben_ctp_shd.g_old_rec.dflt_enrt_det_rl

2979: p_object_version_number => p_object_version_number);
2980: --
2981: if (l_api_updating
2982: and nvl(p_dflt_enrt_det_rl,hr_api.g_number)
2983: <> ben_ctp_shd.g_old_rec.dflt_enrt_det_rl
2984: or not l_api_updating)
2985: and p_dflt_enrt_det_rl is not null then
2986: --
2987: -- check if value of formula rule is valid.

Line 3054: l_api_updating := ben_ctp_shd.api_updating

3050: Begin
3051: --
3052: hr_utility.set_location('Entering:'||l_proc, 5);
3053: --
3054: l_api_updating := ben_ctp_shd.api_updating
3055: (p_ptip_id => p_ptip_id,
3056: p_effective_date => p_effective_date,
3057: p_object_version_number => p_object_version_number);
3058: --

Line 3061: <> nvl(ben_ctp_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)

3057: p_object_version_number => p_object_version_number);
3058: --
3059: if (l_api_updating
3060: and p_enrt_mthd_cd
3061: <> nvl(ben_ctp_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)
3062: or not l_api_updating) then
3063: --
3064: -- check if value of lookup falls within lookup type.
3065: --

Line 3128: l_api_updating := ben_ctp_shd.api_updating

3124: Begin
3125: --
3126: hr_utility.set_location('Entering:'||l_proc, 5);
3127: --
3128: l_api_updating := ben_ctp_shd.api_updating
3129: (p_ptip_id => p_ptip_id,
3130: p_effective_date => p_effective_date,
3131: p_object_version_number => p_object_version_number);
3132: --

Line 3135: <> nvl(ben_ctp_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

3131: p_object_version_number => p_object_version_number);
3132: --
3133: if (l_api_updating
3134: and p_enrt_cd
3135: <> nvl(ben_ctp_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
3136: or not l_api_updating) then
3137: --
3138: -- check if value of lookup falls within lookup type.
3139: --

Line 3202: l_api_updating := ben_ctp_shd.api_updating

3198: Begin
3199: --
3200: hr_utility.set_location('Entering:'||l_proc, 5);
3201: --
3202: l_api_updating := ben_ctp_shd.api_updating
3203: (p_ptip_id => p_ptip_id,
3204: p_effective_date => p_effective_date,
3205: p_object_version_number => p_object_version_number);
3206: --

Line 3209: <> nvl(ben_ctp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)

3205: p_object_version_number => p_object_version_number);
3206: --
3207: if (l_api_updating
3208: and p_dflt_enrt_cd
3209: <> nvl(ben_ctp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)
3210: or not l_api_updating) then
3211: --
3212: -- check if value of lookup falls within lookup type.
3213: --

Line 3294: l_api_updating := ben_ctp_shd.api_updating

3290: Begin
3291: --
3292: hr_utility.set_location('Entering:'||l_proc, 5);
3293: --
3294: l_api_updating := ben_ctp_shd.api_updating
3295: (p_ptip_id => p_ptip_id,
3296: p_effective_date => p_effective_date,
3297: p_object_version_number => p_object_version_number);
3298: --

Line 3301: <> ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_rl

3297: p_object_version_number => p_object_version_number);
3298: --
3299: if (l_api_updating
3300: and nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
3301: <> ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_rl
3302: or not l_api_updating)
3303: and p_dpnt_cvg_end_dt_rl is not null then
3304: --
3305: -- check if value of formula rule is valid.

Line 3391: l_api_updating := ben_ctp_shd.api_updating

3387: Begin
3388: --
3389: hr_utility.set_location('Entering:'||l_proc, 5);
3390: --
3391: l_api_updating := ben_ctp_shd.api_updating
3392: (p_ptip_id => p_ptip_id,
3393: p_effective_date => p_effective_date,
3394: p_object_version_number => p_object_version_number);
3395: --

Line 3398: <> ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_rl

3394: p_object_version_number => p_object_version_number);
3395: --
3396: if (l_api_updating
3397: and nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
3398: <> ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_rl
3399: or not l_api_updating)
3400: and p_dpnt_cvg_strt_dt_rl is not null then
3401: --
3402: -- check if value of formula rule is valid.

Line 3469: l_api_updating := ben_ctp_shd.api_updating

3465: Begin
3466: --
3467: hr_utility.set_location('Entering:'||l_proc, 5);
3468: --
3469: l_api_updating := ben_ctp_shd.api_updating
3470: (p_ptip_id => p_ptip_id,
3471: p_effective_date => p_effective_date,
3472: p_object_version_number => p_object_version_number);
3473: --

Line 3476: <> nvl(ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)

3472: p_object_version_number => p_object_version_number);
3473: --
3474: if (l_api_updating
3475: and p_dpnt_cvg_strt_dt_cd
3476: <> nvl(ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
3477: or not l_api_updating) then
3478: --
3479: -- check if value of lookup falls within lookup type.
3480: --

Line 3542: l_api_updating := ben_ctp_shd.api_updating

3538: Begin
3539: --
3540: hr_utility.set_location('Entering:'||l_proc, 5);
3541: --
3542: l_api_updating := ben_ctp_shd.api_updating
3543: (p_ptip_id => p_ptip_id,
3544: p_effective_date => p_effective_date,
3545: p_object_version_number => p_object_version_number);
3546: --

Line 3549: <> nvl(ben_ctp_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2)

3545: p_object_version_number => p_object_version_number);
3546: --
3547: if (l_api_updating
3548: and p_rt_strt_dt_cd
3549: <> nvl(ben_ctp_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2)
3550: or not l_api_updating) then
3551: --
3552: -- check if value of lookup falls within lookup type.
3553: --

Line 3615: l_api_updating := ben_ctp_shd.api_updating

3611: Begin
3612: --
3613: hr_utility.set_location('Entering:'||l_proc, 5);
3614: --
3615: l_api_updating := ben_ctp_shd.api_updating
3616: (p_ptip_id => p_ptip_id,
3617: p_effective_date => p_effective_date,
3618: p_object_version_number => p_object_version_number);
3619: --

Line 3622: <> nvl(ben_ctp_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2)

3618: p_object_version_number => p_object_version_number);
3619: --
3620: if (l_api_updating
3621: and p_rt_end_dt_cd
3622: <> nvl(ben_ctp_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2)
3623: or not l_api_updating) then
3624: --
3625: -- check if value of lookup falls within lookup type.
3626: --

Line 3688: l_api_updating := ben_ctp_shd.api_updating

3684: Begin
3685: --
3686: hr_utility.set_location('Entering:'||l_proc, 5);
3687: --
3688: l_api_updating := ben_ctp_shd.api_updating
3689: (p_ptip_id => p_ptip_id,
3690: p_effective_date => p_effective_date,
3691: p_object_version_number => p_object_version_number);
3692: --

Line 3695: <> nvl(ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)

3691: p_object_version_number => p_object_version_number);
3692: --
3693: if (l_api_updating
3694: and p_enrt_cvg_end_dt_cd
3695: <> nvl(ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)
3696: or not l_api_updating) then
3697: --
3698: -- check if value of lookup falls within lookup type.
3699: --

Line 3761: l_api_updating := ben_ctp_shd.api_updating

3757: Begin
3758: --
3759: hr_utility.set_location('Entering:'||l_proc, 5);
3760: --
3761: l_api_updating := ben_ctp_shd.api_updating
3762: (p_ptip_id => p_ptip_id,
3763: p_effective_date => p_effective_date,
3764: p_object_version_number => p_object_version_number);
3765: --

Line 3768: <> nvl(ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)

3764: p_object_version_number => p_object_version_number);
3765: --
3766: if (l_api_updating
3767: and p_enrt_cvg_strt_dt_cd
3768: <> nvl(ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
3769: or not l_api_updating) then
3770: --
3771: -- check if value of lookup falls within lookup type.
3772: --

Line 3835: l_api_updating := ben_ctp_shd.api_updating

3831: Begin
3832: --
3833: hr_utility.set_location('Entering:'||l_proc, 5);
3834: --
3835: l_api_updating := ben_ctp_shd.api_updating
3836: (p_ptip_id => p_ptip_id,
3837: p_effective_date => p_effective_date,
3838: p_object_version_number => p_object_version_number);
3839: --

Line 3842: <> nvl(ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2)

3838: p_object_version_number => p_object_version_number);
3839: --
3840: if (l_api_updating
3841: and p_dpnt_cvg_end_dt_cd
3842: <> nvl(ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
3843: or not l_api_updating) then
3844: --
3845: -- check if value of lookup falls within lookup type.
3846: --

Line 3908: l_api_updating := ben_ctp_shd.api_updating

3904: Begin
3905: --
3906: hr_utility.set_location('Entering:'||l_proc, 5);
3907: --
3908: l_api_updating := ben_ctp_shd.api_updating
3909: (p_ptip_id => p_ptip_id,
3910: p_effective_date => p_effective_date,
3911: p_object_version_number => p_object_version_number);
3912: --

Line 3915: <> nvl(ben_ctp_shd.g_old_rec.coord_cvg_for_all_pls_flag,hr_api.g_varchar2)

3911: p_object_version_number => p_object_version_number);
3912: --
3913: if (l_api_updating
3914: and p_coord_cvg_for_all_pls_flag
3915: <> nvl(ben_ctp_shd.g_old_rec.coord_cvg_for_all_pls_flag,hr_api.g_varchar2)
3916: or not l_api_updating)
3917: and p_coord_cvg_for_all_pls_flag is not null then
3918: --
3919: -- check if value of lookup falls within lookup type.

Line 3980: l_api_updating := ben_ctp_shd.api_updating

3976: Begin
3977: --
3978: hr_utility.set_location('Entering:'||l_proc, 5);
3979: --
3980: l_api_updating := ben_ctp_shd.api_updating
3981: (p_ptip_id => p_ptip_id,
3982: p_effective_date => p_effective_date,
3983: p_object_version_number => p_object_version_number);
3984: --

Line 3988: <> nvl(ben_ctp_shd.g_old_rec.rqd_perd_enrt_nenrt_val,hr_api.g_number) or

3984: --
3985: if (l_api_updating
3986: and
3987: (nvl(p_rqd_perd_enrt_nenrt_val,hr_api.g_number)
3988: <> nvl(ben_ctp_shd.g_old_rec.rqd_perd_enrt_nenrt_val,hr_api.g_number) or
3989: nvl(p_rqd_perd_enrt_nenrt_tm_uom,hr_api.g_varchar2)
3990: <> nvl(ben_ctp_shd.g_old_rec.rqd_perd_enrt_nenrt_tm_uom,hr_api.g_varchar2))
3991: or not l_api_updating) then
3992: --

Line 3990: <> nvl(ben_ctp_shd.g_old_rec.rqd_perd_enrt_nenrt_tm_uom,hr_api.g_varchar2))

3986: and
3987: (nvl(p_rqd_perd_enrt_nenrt_val,hr_api.g_number)
3988: <> nvl(ben_ctp_shd.g_old_rec.rqd_perd_enrt_nenrt_val,hr_api.g_number) or
3989: nvl(p_rqd_perd_enrt_nenrt_tm_uom,hr_api.g_varchar2)
3990: <> nvl(ben_ctp_shd.g_old_rec.rqd_perd_enrt_nenrt_tm_uom,hr_api.g_varchar2))
3991: or not l_api_updating) then
3992: --
3993: -- check dependency.
3994: --

Line 4052: l_api_updating := ben_ctp_shd.api_updating

4048: Begin
4049: --
4050: hr_utility.set_location('Entering:'||l_proc, 5);
4051: --
4052: l_api_updating := ben_ctp_shd.api_updating
4053: (p_ptip_id => p_ptip_id,
4054: p_effective_date => p_effective_date,
4055: p_object_version_number => p_object_version_number);
4056: --

Line 4060: <> nvl(ben_ctp_shd.g_old_rec.mx_enrd_alwd_ovrid_num,hr_api.g_number) or

4056: --
4057: if (l_api_updating
4058: and
4059: (nvl(p_mx_enrd_alwd_ovrid_num,hr_api.g_number)
4060: <> nvl(ben_ctp_shd.g_old_rec.mx_enrd_alwd_ovrid_num,hr_api.g_number) or
4061: nvl(p_no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2)
4062: <> nvl(ben_ctp_shd.g_old_rec.no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2))
4063: or not l_api_updating) then
4064: --

Line 4062: <> nvl(ben_ctp_shd.g_old_rec.no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2))

4058: and
4059: (nvl(p_mx_enrd_alwd_ovrid_num,hr_api.g_number)
4060: <> nvl(ben_ctp_shd.g_old_rec.mx_enrd_alwd_ovrid_num,hr_api.g_number) or
4061: nvl(p_no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2)
4062: <> nvl(ben_ctp_shd.g_old_rec.no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2))
4063: or not l_api_updating) then
4064: --
4065: -- If flag = 'Y' then num must be null.
4066: --

Line 4121: l_api_updating := ben_ctp_shd.api_updating

4117: Begin
4118: --
4119: hr_utility.set_location('Entering:'||l_proc, 5);
4120: --
4121: l_api_updating := ben_ctp_shd.api_updating
4122: (p_ptip_id => p_ptip_id,
4123: p_effective_date => p_effective_date,
4124: p_object_version_number => p_object_version_number);
4125: --

Line 4129: <> nvl(ben_ctp_shd.g_old_rec.mn_enrd_rqd_ovrid_num,hr_api.g_number) or

4125: --
4126: if (l_api_updating
4127: and
4128: (nvl(p_mn_enrd_rqd_ovrid_num,hr_api.g_number)
4129: <> nvl(ben_ctp_shd.g_old_rec.mn_enrd_rqd_ovrid_num,hr_api.g_number) or
4130: nvl(p_no_mn_pl_typ_overid_flag,hr_api.g_varchar2)
4131: <> nvl(ben_ctp_shd.g_old_rec.no_mn_pl_typ_overid_flag,hr_api.g_varchar2))
4132: or not l_api_updating) then
4133: --

Line 4131: <> nvl(ben_ctp_shd.g_old_rec.no_mn_pl_typ_overid_flag,hr_api.g_varchar2))

4127: and
4128: (nvl(p_mn_enrd_rqd_ovrid_num,hr_api.g_number)
4129: <> nvl(ben_ctp_shd.g_old_rec.mn_enrd_rqd_ovrid_num,hr_api.g_number) or
4130: nvl(p_no_mn_pl_typ_overid_flag,hr_api.g_varchar2)
4131: <> nvl(ben_ctp_shd.g_old_rec.no_mn_pl_typ_overid_flag,hr_api.g_varchar2))
4132: or not l_api_updating) then
4133: --
4134: -- If flag = 'Y' then num must be null.
4135: --

Line 4198: l_api_updating := ben_ctp_shd.api_updating

4194: Begin
4195: --
4196: hr_utility.set_location('Entering:'||l_proc, 5);
4197: --
4198: l_api_updating := ben_ctp_shd.api_updating
4199: (p_ptip_id => p_ptip_id,
4200: p_effective_date => p_effective_date,
4201: p_object_version_number => p_object_version_number);
4202: --

Line 4205: <> nvl(ben_ctp_shd.g_old_rec.mx_enrd_alwd_ovrid_num,hr_api.g_number)

4201: p_object_version_number => p_object_version_number);
4202: --
4203: if (l_api_updating
4204: and nvl(p_mx_enrd_alwd_ovrid_num,hr_api.g_number)
4205: <> nvl(ben_ctp_shd.g_old_rec.mx_enrd_alwd_ovrid_num,hr_api.g_number)
4206: or not l_api_updating) then
4207: --
4208: -- Max enrolled allowed override number must be greater than that of plan type
4209: -- Bypass this edit if either is null - Verify this.

Line 4282: l_api_updating := ben_ctp_shd.api_updating

4278: Begin
4279: --
4280: hr_utility.set_location('Entering:'||l_proc, 5);
4281: --
4282: l_api_updating := ben_ctp_shd.api_updating
4283: (p_ptip_id => p_ptip_id,
4284: p_effective_date => p_effective_date,
4285: p_object_version_number => p_object_version_number);
4286: --

Line 4289: <> nvl(ben_ctp_shd.g_old_rec.mn_enrd_rqd_ovrid_num,hr_api.g_number)

4285: p_object_version_number => p_object_version_number);
4286: --
4287: if (l_api_updating
4288: and nvl(p_mn_enrd_rqd_ovrid_num,hr_api.g_number)
4289: <> nvl(ben_ctp_shd.g_old_rec.mn_enrd_rqd_ovrid_num,hr_api.g_number)
4290: or not l_api_updating) then
4291: --
4292: -- Min enrolled allowed override number must be greater than that of plan type
4293: -- Bypass this edit if either is null - Verify this.

Line 4364: l_api_updating := ben_ctp_shd.api_updating

4360: Begin
4361: --
4362: hr_utility.set_location('Entering:'||l_proc, 5);
4363: --
4364: l_api_updating := ben_ctp_shd.api_updating
4365: (p_ptip_id => p_ptip_id,
4366: p_effective_date => p_effective_date,
4367: p_object_version_number => p_object_version_number);
4368: --

Line 4372: <> nvl(ben_ctp_shd.g_old_rec.mx_enrd_alwd_ovrid_num,hr_api.g_number) or

4368: --
4369: if (l_api_updating
4370: and
4371: (nvl(p_mx_enrd_alwd_ovrid_num,hr_api.g_number)
4372: <> nvl(ben_ctp_shd.g_old_rec.mx_enrd_alwd_ovrid_num,hr_api.g_number) or
4373: nvl(p_no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2)
4374: <> nvl(ben_ctp_shd.g_old_rec.no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2) or
4375: nvl(p_mn_enrd_rqd_ovrid_num,hr_api.g_number)
4376: <> nvl(ben_ctp_shd.g_old_rec.mn_enrd_rqd_ovrid_num,hr_api.g_number))

Line 4374: <> nvl(ben_ctp_shd.g_old_rec.no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2) or

4370: and
4371: (nvl(p_mx_enrd_alwd_ovrid_num,hr_api.g_number)
4372: <> nvl(ben_ctp_shd.g_old_rec.mx_enrd_alwd_ovrid_num,hr_api.g_number) or
4373: nvl(p_no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2)
4374: <> nvl(ben_ctp_shd.g_old_rec.no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2) or
4375: nvl(p_mn_enrd_rqd_ovrid_num,hr_api.g_number)
4376: <> nvl(ben_ctp_shd.g_old_rec.mn_enrd_rqd_ovrid_num,hr_api.g_number))
4377: or not l_api_updating) then
4378: --

Line 4376: <> nvl(ben_ctp_shd.g_old_rec.mn_enrd_rqd_ovrid_num,hr_api.g_number))

4372: <> nvl(ben_ctp_shd.g_old_rec.mx_enrd_alwd_ovrid_num,hr_api.g_number) or
4373: nvl(p_no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2)
4374: <> nvl(ben_ctp_shd.g_old_rec.no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2) or
4375: nvl(p_mn_enrd_rqd_ovrid_num,hr_api.g_number)
4376: <> nvl(ben_ctp_shd.g_old_rec.mn_enrd_rqd_ovrid_num,hr_api.g_number))
4377: or not l_api_updating) then
4378: --
4379: -- If min amount has value then max amount must have value or flag must be 'Y'.
4380: --

Line 4437: l_api_updating := ben_ctp_shd.api_updating

4433: Begin
4434: --
4435: hr_utility.set_location('Entering:'||l_proc, 5);
4436: --
4437: l_api_updating := ben_ctp_shd.api_updating
4438: (p_ptip_id => p_ptip_id,
4439: p_effective_date => p_effective_date,
4440: p_object_version_number => p_object_version_number);
4441: --

Line 4445: <> nvl(ben_ctp_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or

4441: --
4442: if (l_api_updating
4443: and
4444: (nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4445: <> nvl(ben_ctp_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4446: nvl(p_drvd_fctr_dpnt_cvg_flag,hr_api.g_varchar2)
4447: <> nvl(ben_ctp_shd.g_old_rec.drvd_fctr_dpnt_cvg_flag,hr_api.g_varchar2))
4448: or not l_api_updating) then
4449: --

Line 4447: <> nvl(ben_ctp_shd.g_old_rec.drvd_fctr_dpnt_cvg_flag,hr_api.g_varchar2))

4443: and
4444: (nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4445: <> nvl(ben_ctp_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4446: nvl(p_drvd_fctr_dpnt_cvg_flag,hr_api.g_varchar2)
4447: <> nvl(ben_ctp_shd.g_old_rec.drvd_fctr_dpnt_cvg_flag,hr_api.g_varchar2))
4448: or not l_api_updating) then
4449: --
4450: if nvl(p_dpnt_dsgn_cd,'X') not in ('R','O') and
4451: (p_drvd_fctr_dpnt_cvg_flag = 'Y' ) then

Line 4530: l_api_updating := ben_ctp_shd.api_updating

4526: Begin
4527: --
4528: hr_utility.set_location('Entering:'||l_proc, 5);
4529: --
4530: l_api_updating := ben_ctp_shd.api_updating
4531: (p_ptip_id => p_ptip_id,
4532: p_effective_date => p_effective_date,
4533: p_object_version_number => p_object_version_number);
4534: --

Line 4538: <> nvl(ben_ctp_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2)

4534: --
4535:
4536: if (l_api_updating
4537: and nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4538: <> nvl(ben_ctp_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2)
4539: or not l_api_updating) then
4540: null;
4541: --
4542: -- If ldc records exists and designation is null then error

Line 4654: l_api_updating := ben_ctp_shd.api_updating

4650: Begin
4651: --
4652: hr_utility.set_location('Entering:'||l_proc, 5);
4653: --
4654: l_api_updating := ben_ctp_shd.api_updating
4655: (p_ptip_id => p_ptip_id,
4656: p_effective_date => p_effective_date,
4657: p_object_version_number => p_object_version_number);
4658: --

Line 4662: <> nvl(ben_ctp_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or

4658: --
4659: if (l_api_updating
4660: and
4661: (nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4662: <> nvl(ben_ctp_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4663: nvl(p_drvd_fctr_dpnt_cvg_flag,hr_api.g_varchar2)
4664: <> nvl(ben_ctp_shd.g_old_rec.drvd_fctr_dpnt_cvg_flag,hr_api.g_varchar2))
4665: or not l_api_updating) then
4666: --

Line 4664: <> nvl(ben_ctp_shd.g_old_rec.drvd_fctr_dpnt_cvg_flag,hr_api.g_varchar2))

4660: and
4661: (nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4662: <> nvl(ben_ctp_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4663: nvl(p_drvd_fctr_dpnt_cvg_flag,hr_api.g_varchar2)
4664: <> nvl(ben_ctp_shd.g_old_rec.drvd_fctr_dpnt_cvg_flag,hr_api.g_varchar2))
4665: or not l_api_updating) then
4666: --
4667: open c1;
4668: fetch c1 into l_value;

Line 4994: (p_rec in ben_ctp_shd.g_rec_type,

4990: -- ----------------------------------------------------------------------------
4991: -- |---------------------------< insert_validate >----------------------------|
4992: -- ----------------------------------------------------------------------------
4993: Procedure insert_validate
4994: (p_rec in ben_ctp_shd.g_rec_type,
4995: p_effective_date in date,
4996: p_datetrack_mode in varchar2,
4997: p_validation_start_date in date,
4998: p_validation_end_date in date) is

Line 5331: p_old_dt_cd => ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_cd,

5327: --
5328: chk_date_dpndcy
5329: (p_ptip_id => p_rec.ptip_id,
5330: p_dt_cd => p_rec.dpnt_cvg_strt_dt_cd,
5331: p_old_dt_cd => ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_cd,
5332: p_dt_rl => p_rec.dpnt_cvg_strt_dt_rl,
5333: p_old_dt_rl => ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_rl,
5334: p_effective_date => p_effective_date,
5335: p_object_version_number => p_rec.object_version_number);

Line 5333: p_old_dt_rl => ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_rl,

5329: (p_ptip_id => p_rec.ptip_id,
5330: p_dt_cd => p_rec.dpnt_cvg_strt_dt_cd,
5331: p_old_dt_cd => ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_cd,
5332: p_dt_rl => p_rec.dpnt_cvg_strt_dt_rl,
5333: p_old_dt_rl => ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_rl,
5334: p_effective_date => p_effective_date,
5335: p_object_version_number => p_rec.object_version_number);
5336: --
5337: chk_date_dpndcy

Line 5340: p_old_dt_cd => ben_ctp_shd.g_old_rec.rt_end_dt_cd,

5336: --
5337: chk_date_dpndcy
5338: (p_ptip_id => p_rec.ptip_id,
5339: p_dt_cd => p_rec.rt_end_dt_cd,
5340: p_old_dt_cd => ben_ctp_shd.g_old_rec.rt_end_dt_cd,
5341: p_dt_rl => p_rec.rt_end_dt_rl,
5342: p_old_dt_rl => ben_ctp_shd.g_old_rec.rt_end_dt_rl,
5343: p_effective_date => p_effective_date,
5344: p_object_version_number => p_rec.object_version_number);

Line 5342: p_old_dt_rl => ben_ctp_shd.g_old_rec.rt_end_dt_rl,

5338: (p_ptip_id => p_rec.ptip_id,
5339: p_dt_cd => p_rec.rt_end_dt_cd,
5340: p_old_dt_cd => ben_ctp_shd.g_old_rec.rt_end_dt_cd,
5341: p_dt_rl => p_rec.rt_end_dt_rl,
5342: p_old_dt_rl => ben_ctp_shd.g_old_rec.rt_end_dt_rl,
5343: p_effective_date => p_effective_date,
5344: p_object_version_number => p_rec.object_version_number);
5345: --
5346: chk_date_dpndcy

Line 5349: p_old_dt_cd => ben_ctp_shd.g_old_rec.rt_strt_dt_cd,

5345: --
5346: chk_date_dpndcy
5347: (p_ptip_id => p_rec.ptip_id,
5348: p_dt_cd => p_rec.rt_strt_dt_cd,
5349: p_old_dt_cd => ben_ctp_shd.g_old_rec.rt_strt_dt_cd,
5350: p_dt_rl => p_rec.rt_strt_dt_rl,
5351: p_old_dt_rl => ben_ctp_shd.g_old_rec.rt_strt_dt_rl,
5352: p_effective_date => p_effective_date,
5353: p_object_version_number => p_rec.object_version_number);

Line 5351: p_old_dt_rl => ben_ctp_shd.g_old_rec.rt_strt_dt_rl,

5347: (p_ptip_id => p_rec.ptip_id,
5348: p_dt_cd => p_rec.rt_strt_dt_cd,
5349: p_old_dt_cd => ben_ctp_shd.g_old_rec.rt_strt_dt_cd,
5350: p_dt_rl => p_rec.rt_strt_dt_rl,
5351: p_old_dt_rl => ben_ctp_shd.g_old_rec.rt_strt_dt_rl,
5352: p_effective_date => p_effective_date,
5353: p_object_version_number => p_rec.object_version_number);
5354: --
5355: chk_date_dpndcy

Line 5358: p_old_dt_cd => ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_cd,

5354: --
5355: chk_date_dpndcy
5356: (p_ptip_id => p_rec.ptip_id,
5357: p_dt_cd => p_rec.enrt_cvg_end_dt_cd,
5358: p_old_dt_cd => ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_cd,
5359: p_dt_rl => p_rec.enrt_cvg_end_dt_rl,
5360: p_old_dt_rl => ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_rl,
5361: p_effective_date => p_effective_date,
5362: p_object_version_number => p_rec.object_version_number);

Line 5360: p_old_dt_rl => ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_rl,

5356: (p_ptip_id => p_rec.ptip_id,
5357: p_dt_cd => p_rec.enrt_cvg_end_dt_cd,
5358: p_old_dt_cd => ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_cd,
5359: p_dt_rl => p_rec.enrt_cvg_end_dt_rl,
5360: p_old_dt_rl => ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_rl,
5361: p_effective_date => p_effective_date,
5362: p_object_version_number => p_rec.object_version_number);
5363: --
5364: chk_date_dpndcy

Line 5367: p_old_dt_cd => ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_cd,

5363: --
5364: chk_date_dpndcy
5365: (p_ptip_id => p_rec.ptip_id,
5366: p_dt_cd => p_rec.enrt_cvg_strt_dt_cd,
5367: p_old_dt_cd => ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_cd,
5368: p_dt_rl => p_rec.enrt_cvg_strt_dt_rl,
5369: p_old_dt_rl => ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_rl,
5370: p_effective_date => p_effective_date,
5371: p_object_version_number => p_rec.object_version_number);

Line 5369: p_old_dt_rl => ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_rl,

5365: (p_ptip_id => p_rec.ptip_id,
5366: p_dt_cd => p_rec.enrt_cvg_strt_dt_cd,
5367: p_old_dt_cd => ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_cd,
5368: p_dt_rl => p_rec.enrt_cvg_strt_dt_rl,
5369: p_old_dt_rl => ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_rl,
5370: p_effective_date => p_effective_date,
5371: p_object_version_number => p_rec.object_version_number);
5372: --
5373: chk_date_dpndcy

Line 5376: p_old_dt_cd => ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_cd,

5372: --
5373: chk_date_dpndcy
5374: (p_ptip_id => p_rec.ptip_id,
5375: p_dt_cd => p_rec.dpnt_cvg_end_dt_cd,
5376: p_old_dt_cd => ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_cd,
5377: p_dt_rl => p_rec.dpnt_cvg_end_dt_rl,
5378: p_old_dt_rl => ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_rl,
5379: p_effective_date => p_effective_date,
5380: p_object_version_number => p_rec.object_version_number);

Line 5378: p_old_dt_rl => ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_rl,

5374: (p_ptip_id => p_rec.ptip_id,
5375: p_dt_cd => p_rec.dpnt_cvg_end_dt_cd,
5376: p_old_dt_cd => ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_cd,
5377: p_dt_rl => p_rec.dpnt_cvg_end_dt_rl,
5378: p_old_dt_rl => ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_rl,
5379: p_effective_date => p_effective_date,
5380: p_object_version_number => p_rec.object_version_number);
5381: --
5382: /*chk_plan_typ_temporal

Line 5474: (p_rec in ben_ctp_shd.g_rec_type,

5470: -- ----------------------------------------------------------------------------
5471: -- |---------------------------< update_validate >----------------------------|
5472: -- ----------------------------------------------------------------------------
5473: Procedure update_validate
5474: (p_rec in ben_ctp_shd.g_rec_type,
5475: p_effective_date in date,
5476: p_datetrack_mode in varchar2,
5477: p_validation_start_date in date,
5478: p_validation_end_date in date) is

Line 5806: p_old_dt_cd => ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_cd,

5802: --
5803: chk_date_dpndcy
5804: (p_ptip_id => p_rec.ptip_id,
5805: p_dt_cd => p_rec.dpnt_cvg_strt_dt_cd,
5806: p_old_dt_cd => ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_cd,
5807: p_dt_rl => p_rec.dpnt_cvg_strt_dt_rl,
5808: p_old_dt_rl => ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_rl,
5809: p_effective_date => p_effective_date,
5810: p_object_version_number => p_rec.object_version_number);

Line 5808: p_old_dt_rl => ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_rl,

5804: (p_ptip_id => p_rec.ptip_id,
5805: p_dt_cd => p_rec.dpnt_cvg_strt_dt_cd,
5806: p_old_dt_cd => ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_cd,
5807: p_dt_rl => p_rec.dpnt_cvg_strt_dt_rl,
5808: p_old_dt_rl => ben_ctp_shd.g_old_rec.dpnt_cvg_strt_dt_rl,
5809: p_effective_date => p_effective_date,
5810: p_object_version_number => p_rec.object_version_number);
5811: --
5812: chk_date_dpndcy

Line 5815: p_old_dt_cd => ben_ctp_shd.g_old_rec.rt_end_dt_cd,

5811: --
5812: chk_date_dpndcy
5813: (p_ptip_id => p_rec.ptip_id,
5814: p_dt_cd => p_rec.rt_end_dt_cd,
5815: p_old_dt_cd => ben_ctp_shd.g_old_rec.rt_end_dt_cd,
5816: p_dt_rl => p_rec.rt_end_dt_rl,
5817: p_old_dt_rl => ben_ctp_shd.g_old_rec.rt_end_dt_rl,
5818: p_effective_date => p_effective_date,
5819: p_object_version_number => p_rec.object_version_number);

Line 5817: p_old_dt_rl => ben_ctp_shd.g_old_rec.rt_end_dt_rl,

5813: (p_ptip_id => p_rec.ptip_id,
5814: p_dt_cd => p_rec.rt_end_dt_cd,
5815: p_old_dt_cd => ben_ctp_shd.g_old_rec.rt_end_dt_cd,
5816: p_dt_rl => p_rec.rt_end_dt_rl,
5817: p_old_dt_rl => ben_ctp_shd.g_old_rec.rt_end_dt_rl,
5818: p_effective_date => p_effective_date,
5819: p_object_version_number => p_rec.object_version_number);
5820: --
5821: chk_date_dpndcy

Line 5824: p_old_dt_cd => ben_ctp_shd.g_old_rec.rt_strt_dt_cd,

5820: --
5821: chk_date_dpndcy
5822: (p_ptip_id => p_rec.ptip_id,
5823: p_dt_cd => p_rec.rt_strt_dt_cd,
5824: p_old_dt_cd => ben_ctp_shd.g_old_rec.rt_strt_dt_cd,
5825: p_dt_rl => p_rec.rt_strt_dt_rl,
5826: p_old_dt_rl => ben_ctp_shd.g_old_rec.rt_strt_dt_rl,
5827: p_effective_date => p_effective_date,
5828: p_object_version_number => p_rec.object_version_number);

Line 5826: p_old_dt_rl => ben_ctp_shd.g_old_rec.rt_strt_dt_rl,

5822: (p_ptip_id => p_rec.ptip_id,
5823: p_dt_cd => p_rec.rt_strt_dt_cd,
5824: p_old_dt_cd => ben_ctp_shd.g_old_rec.rt_strt_dt_cd,
5825: p_dt_rl => p_rec.rt_strt_dt_rl,
5826: p_old_dt_rl => ben_ctp_shd.g_old_rec.rt_strt_dt_rl,
5827: p_effective_date => p_effective_date,
5828: p_object_version_number => p_rec.object_version_number);
5829: --
5830: chk_date_dpndcy

Line 5833: p_old_dt_cd => ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_cd,

5829: --
5830: chk_date_dpndcy
5831: (p_ptip_id => p_rec.ptip_id,
5832: p_dt_cd => p_rec.enrt_cvg_end_dt_cd,
5833: p_old_dt_cd => ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_cd,
5834: p_dt_rl => p_rec.enrt_cvg_end_dt_rl,
5835: p_old_dt_rl => ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_rl,
5836: p_effective_date => p_effective_date,
5837: p_object_version_number => p_rec.object_version_number);

Line 5835: p_old_dt_rl => ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_rl,

5831: (p_ptip_id => p_rec.ptip_id,
5832: p_dt_cd => p_rec.enrt_cvg_end_dt_cd,
5833: p_old_dt_cd => ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_cd,
5834: p_dt_rl => p_rec.enrt_cvg_end_dt_rl,
5835: p_old_dt_rl => ben_ctp_shd.g_old_rec.enrt_cvg_end_dt_rl,
5836: p_effective_date => p_effective_date,
5837: p_object_version_number => p_rec.object_version_number);
5838: --
5839: chk_date_dpndcy

Line 5842: p_old_dt_cd => ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_cd,

5838: --
5839: chk_date_dpndcy
5840: (p_ptip_id => p_rec.ptip_id,
5841: p_dt_cd => p_rec.enrt_cvg_strt_dt_cd,
5842: p_old_dt_cd => ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_cd,
5843: p_dt_rl => p_rec.enrt_cvg_strt_dt_rl,
5844: p_old_dt_rl => ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_rl,
5845: p_effective_date => p_effective_date,
5846: p_object_version_number => p_rec.object_version_number);

Line 5844: p_old_dt_rl => ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_rl,

5840: (p_ptip_id => p_rec.ptip_id,
5841: p_dt_cd => p_rec.enrt_cvg_strt_dt_cd,
5842: p_old_dt_cd => ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_cd,
5843: p_dt_rl => p_rec.enrt_cvg_strt_dt_rl,
5844: p_old_dt_rl => ben_ctp_shd.g_old_rec.enrt_cvg_strt_dt_rl,
5845: p_effective_date => p_effective_date,
5846: p_object_version_number => p_rec.object_version_number);
5847: --
5848: chk_date_dpndcy

Line 5851: p_old_dt_cd => ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_cd,

5847: --
5848: chk_date_dpndcy
5849: (p_ptip_id => p_rec.ptip_id,
5850: p_dt_cd => p_rec.dpnt_cvg_end_dt_cd,
5851: p_old_dt_cd => ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_cd,
5852: p_dt_rl => p_rec.dpnt_cvg_end_dt_rl,
5853: p_old_dt_rl => ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_rl,
5854: p_effective_date => p_effective_date,
5855: p_object_version_number => p_rec.object_version_number);

Line 5853: p_old_dt_rl => ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_rl,

5849: (p_ptip_id => p_rec.ptip_id,
5850: p_dt_cd => p_rec.dpnt_cvg_end_dt_cd,
5851: p_old_dt_cd => ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_cd,
5852: p_dt_rl => p_rec.dpnt_cvg_end_dt_rl,
5853: p_old_dt_rl => ben_ctp_shd.g_old_rec.dpnt_cvg_end_dt_rl,
5854: p_effective_date => p_effective_date,
5855: p_object_version_number => p_rec.object_version_number);
5856: --
5857: /*chk_plan_typ_temporal

Line 5963: (p_rec in ben_ctp_shd.g_rec_type,

5959: -- ----------------------------------------------------------------------------
5960: -- |---------------------------< delete_validate >----------------------------|
5961: -- ----------------------------------------------------------------------------
5962: Procedure delete_validate
5963: (p_rec in ben_ctp_shd.g_rec_type,
5964: p_effective_date in date,
5965: p_datetrack_mode in varchar2,
5966: p_validation_start_date in date,
5967: p_validation_end_date in date) is