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 HR_API

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 263: (nvl(p_dt_cd,hr_api.g_varchar2)

259: p_object_version_number => p_object_version_number);
260: --
261: if (l_api_updating
262: and
263: (nvl(p_dt_cd,hr_api.g_varchar2)
264: <> nvl(p_old_dt_cd,hr_api.g_varchar2)
265: or
266: nvl(p_dt_rl,hr_api.g_number)
267: <> nvl(p_old_dt_rl,hr_api.g_number))

Line 264: <> nvl(p_old_dt_cd,hr_api.g_varchar2)

260: --
261: if (l_api_updating
262: and
263: (nvl(p_dt_cd,hr_api.g_varchar2)
264: <> nvl(p_old_dt_cd,hr_api.g_varchar2)
265: or
266: nvl(p_dt_rl,hr_api.g_number)
267: <> nvl(p_old_dt_rl,hr_api.g_number))
268: or not l_api_updating) then

Line 266: nvl(p_dt_rl,hr_api.g_number)

262: and
263: (nvl(p_dt_cd,hr_api.g_varchar2)
264: <> nvl(p_old_dt_cd,hr_api.g_varchar2)
265: or
266: nvl(p_dt_rl,hr_api.g_number)
267: <> nvl(p_old_dt_rl,hr_api.g_number))
268: or not l_api_updating) then
269: --
270: if (p_dt_cd = 'RL' and p_dt_rl is null) then

Line 267: <> nvl(p_old_dt_rl,hr_api.g_number))

263: (nvl(p_dt_cd,hr_api.g_varchar2)
264: <> nvl(p_old_dt_cd,hr_api.g_varchar2)
265: or
266: nvl(p_dt_rl,hr_api.g_number)
267: <> nvl(p_old_dt_rl,hr_api.g_number))
268: or not l_api_updating) then
269: --
270: if (p_dt_cd = 'RL' and p_dt_rl is null) then
271: --

Line 277: if nvl(p_dt_cd,hr_api.g_varchar2) <> 'RL'

273: fnd_message.raise_error;
274: --
275: end if;
276: --
277: if nvl(p_dt_cd,hr_api.g_varchar2) <> 'RL'
278: and p_dt_rl is not null then
279: --
280: fnd_message.set_name('BEN','BEN_91381_DPNT_CVG_ST_DT_2');
281: fnd_message.raise_error;

Line 404: and nvl(p_ptip_id,hr_api.g_number)

400: p_ptip_id => p_ptip_id,
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: --

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 480: if hr_api.not_exists_in_hr_lookups

476: and p_rqd_enrt_perd_tco_cd is not null then
477: --
478: -- check if value of lookup falls within lookup type.
479: --
480: if hr_api.not_exists_in_hr_lookups
481: (p_lookup_type => 'BEN_RQD_ENRT_PERD_TCO',
482: p_lookup_code => p_rqd_enrt_perd_tco_cd,
483: p_effective_date => p_effective_date) then
484: --

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 526: if hr_api.not_exists_in_hr_lookups

522: --
523: -- check if value of lookup falls within lookup type.
524: --
525:
526: if hr_api.not_exists_in_hr_lookups
527: (p_lookup_type => 'BEN_FMLY_MMBR',
528: p_lookup_code => p_vrfy_fmly_mmbr_cd,
529: p_effective_date => p_effective_date) then
530: --

Line 572: and nvl(p_vrfy_fmly_mmbr_rl,hr_api.g_number)

568: p_ptip_id => p_ptip_id,
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: --

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 656: if hr_api.not_exists_in_hr_lookups

652: and p_no_mn_pl_typ_overid_flag is not null then
653: --
654: -- check if value of lookup falls within lookup type.
655: --
656: if hr_api.not_exists_in_hr_lookups
657: (p_lookup_type => 'YES_NO',
658: p_lookup_code => p_no_mn_pl_typ_overid_flag,
659: p_effective_date => p_effective_date) then
660: --

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 725: if hr_api.not_exists_in_hr_lookups

721: and p_drvbl_fctr_apls_rts_flag is not null then
722: --
723: -- check if value of lookup falls within lookup type.
724: --
725: if hr_api.not_exists_in_hr_lookups
726: (p_lookup_type => 'YES_NO',
727: p_lookup_code => p_drvbl_fctr_apls_rts_flag,
728: p_effective_date => p_effective_date) then
729: --

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 796: if hr_api.not_exists_in_hr_lookups

792: and p_drvbl_fctr_prtn_elig_flag is not null then
793: --
794: -- check if value of lookup falls within lookup type.
795: --
796: if hr_api.not_exists_in_hr_lookups
797: (p_lookup_type => 'YES_NO',
798: p_lookup_code => p_drvbl_fctr_prtn_elig_flag,
799: p_effective_date => p_effective_date) then
800: --

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 918: if hr_api.not_exists_in_hr_lookups

914: and p_elig_apls_flag is not null then
915: --
916: -- check if value of lookup falls within lookup type.
917: --
918: if hr_api.not_exists_in_hr_lookups
919: (p_lookup_type => 'YES_NO',
920: p_lookup_code => p_elig_apls_flag,
921: p_effective_date => p_effective_date) then
922: --

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 990: if hr_api.not_exists_in_hr_lookups

986: and p_prtn_elig_ovrid_alwd_flag is not null then
987: --
988: -- check if value of lookup falls within lookup type.
989: --
990: if hr_api.not_exists_in_hr_lookups
991: (p_lookup_type => 'YES_NO',
992: p_lookup_code => p_prtn_elig_ovrid_alwd_flag,
993: p_effective_date => p_effective_date) then
994: --

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 1062: if hr_api.not_exists_in_hr_lookups

1058: and p_trk_inelig_per_flag is not null then
1059: --
1060: -- check if value of lookup falls within lookup type.
1061: --
1062: if hr_api.not_exists_in_hr_lookups
1063: (p_lookup_type => 'YES_NO',
1064: p_lookup_code => p_trk_inelig_per_flag,
1065: p_effective_date => p_effective_date) then
1066: --

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 1133: if hr_api.not_exists_in_hr_lookups

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.
1132: --
1133: if hr_api.not_exists_in_hr_lookups
1134: (p_lookup_type => 'YES_NO',
1135: p_lookup_code => p_sbj_to_sps_lf_ins_mx_flag,
1136: p_effective_date => p_effective_date) then
1137: --

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 1204: if hr_api.not_exists_in_hr_lookups

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.
1203: --
1204: if hr_api.not_exists_in_hr_lookups
1205: (p_lookup_type => 'YES_NO',
1206: p_lookup_code => p_sbj_to_dpnt_lf_ins_mx_flag,
1207: p_effective_date => p_effective_date) then
1208: --

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 1275: if hr_api.not_exists_in_hr_lookups

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.
1274: --
1275: if hr_api.not_exists_in_hr_lookups
1276: (p_lookup_type => 'YES_NO',
1277: p_lookup_code => p_use_to_sum_ee_lf_ins_flag,
1278: p_effective_date => p_effective_date) then
1279: --

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 1346: if hr_api.not_exists_in_hr_lookups

1342: and p_drvd_fctr_dpnt_cvg_flag is not null then
1343: --
1344: -- check if value of lookup falls within lookup type.
1345: --
1346: if hr_api.not_exists_in_hr_lookups
1347: (p_lookup_type => 'YES_NO',
1348: p_lookup_code => p_drvd_fctr_dpnt_cvg_flag,
1349: p_effective_date => p_effective_date) then
1350: --

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 1415: if hr_api.not_exists_in_hr_lookups

1411: and p_dpnt_dob_rqd_flag is not null then
1412: --
1413: -- check if value of lookup falls within lookup type.
1414: --
1415: if hr_api.not_exists_in_hr_lookups
1416: (p_lookup_type => 'YES_NO',
1417: p_lookup_code => p_dpnt_dob_rqd_flag,
1418: p_effective_date => p_effective_date) then
1419: --

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 1487: if hr_api.not_exists_in_hr_lookups

1483: and p_dpnt_legv_id_rqd_flag is not null then
1484: --
1485: -- check if value of lookup falls within lookup type.
1486: --
1487: if hr_api.not_exists_in_hr_lookups
1488: (p_lookup_type => 'YES_NO',
1489: p_lookup_code => p_dpnt_legv_id_rqd_flag,
1490: p_effective_date => p_effective_date) then
1491: --

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 1558: if hr_api.not_exists_in_hr_lookups

1554: and p_wvbl_flag is not null then
1555: --
1556: -- check if value of lookup falls within lookup type.
1557: --
1558: if hr_api.not_exists_in_hr_lookups
1559: (p_lookup_type => 'YES_NO',
1560: p_lookup_code => p_wvbl_flag,
1561: p_effective_date => p_effective_date) then
1562: --

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 1627: if hr_api.not_exists_in_hr_lookups

1623: and p_dpnt_adrs_rqd_flag is not null then
1624: --
1625: -- check if value of lookup falls within lookup type.
1626: --
1627: if hr_api.not_exists_in_hr_lookups
1628: (p_lookup_type => 'YES_NO',
1629: p_lookup_code => p_dpnt_adrs_rqd_flag,
1630: p_effective_date => p_effective_date) then
1631: --

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 1699: if hr_api.not_exists_in_hr_lookups

1695: and p_dpnt_cvg_no_ctfn_rqd_flag is not null then
1696: --
1697: -- check if value of lookup falls within lookup type.
1698: --
1699: if hr_api.not_exists_in_hr_lookups
1700: (p_lookup_type => 'YES_NO',
1701: p_lookup_code => p_dpnt_cvg_no_ctfn_rqd_flag,
1702: p_effective_date => p_effective_date) then
1703: --

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 1770: if hr_api.not_exists_in_hr_lookups

1766: and p_rqd_perd_enrt_nenrt_tm_uom is not null then
1767: --
1768: -- check if value of lookup falls within lookup type.
1769: --
1770: if hr_api.not_exists_in_hr_lookups
1771: (p_lookup_type => 'BEN_RQD_PERD_ENRT_NENRT_TM_UOM',
1772: p_lookup_code => p_rqd_perd_enrt_nenrt_tm_uom,
1773: p_effective_date => p_effective_date) then
1774: --

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 1839: if hr_api.not_exists_in_hr_lookups

1835: and p_prvds_cr_flag is not null then
1836: --
1837: -- check if value of lookup falls within lookup type.
1838: --
1839: if hr_api.not_exists_in_hr_lookups
1840: (p_lookup_type => 'YES_NO',
1841: p_lookup_code => p_prvds_cr_flag,
1842: p_effective_date => p_effective_date) then
1843: --

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 1908: if hr_api.not_exists_in_hr_lookups

1904: and p_no_mx_pl_typ_ovrid_flag is not null then
1905: --
1906: -- check if value of lookup falls within lookup type.
1907: --
1908: if hr_api.not_exists_in_hr_lookups
1909: (p_lookup_type => 'YES_NO',
1910: p_lookup_code => p_no_mx_pl_typ_ovrid_flag,
1911: p_effective_date => p_effective_date) then
1912: --

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 1977: if hr_api.not_exists_in_hr_lookups

1973: --
1974: -- check if value of lookup falls within lookup type.
1975: --
1976: --
1977: if hr_api.not_exists_in_hr_lookups
1978: (p_lookup_type => 'BEN_STAT',
1979: p_lookup_code => p_ptip_stat_cd,
1980: p_effective_date => p_effective_date) then
1981: --

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 2047: if hr_api.not_exists_in_hr_lookups

2043: and p_crs_this_pl_typ_only_flag is not null then
2044: --
2045: -- check if value of lookup falls within lookup type.
2046: --
2047: if hr_api.not_exists_in_hr_lookups
2048: (p_lookup_type => 'YES_NO',
2049: p_lookup_code => p_crs_this_pl_typ_only_flag,
2050: p_effective_date => p_effective_date) then
2051: --

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 2122: if hr_api.not_exists_in_hr_lookups

2118: -- check if value of lookup falls within lookup type.
2119: --
2120: --
2121: if p_dpnt_dsgn_cd is not null then
2122: if hr_api.not_exists_in_hr_lookups
2123: (p_lookup_type => 'BEN_DPNT_DSGN',
2124: p_lookup_code => p_dpnt_dsgn_cd,
2125: p_effective_date => p_effective_date) then
2126: --

Line 2212: and nvl(p_postelcn_edit_rl,hr_api.g_number)

2208: p_effective_date => p_effective_date,
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: --

Line 2308: and nvl(p_rt_end_dt_rl,hr_api.g_number)

2304: p_effective_date => p_effective_date,
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: --

Line 2405: and nvl(p_rt_strt_dt_rl,hr_api.g_number)

2401: p_effective_date => p_effective_date,
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: --

Line 2501: and nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)

2497: p_effective_date => p_effective_date,
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: --

Line 2597: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)

2593: p_effective_date => p_effective_date,
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: --

Line 2694: and nvl(p_rqd_perd_enrt_nenrt_rl,hr_api.g_number)

2690: p_effective_date => p_effective_date,
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: --

Line 2790: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)

2786: p_effective_date => p_effective_date,
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: --

Line 2886: and nvl(p_enrt_rl,hr_api.g_number)

2882: p_effective_date => p_effective_date,
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: --

Line 2982: and nvl(p_dflt_enrt_det_rl,hr_api.g_number)

2978: p_effective_date => p_effective_date,
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: --

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 3068: if hr_api.not_exists_in_hr_lookups

3064: -- check if value of lookup falls within lookup type.
3065: --
3066: --
3067: if p_enrt_mthd_cd is not null then
3068: if hr_api.not_exists_in_hr_lookups
3069: (p_lookup_type => 'BEN_ENRT_MTHD',
3070: p_lookup_code => p_enrt_mthd_cd,
3071: p_effective_date => p_effective_date) then
3072: --

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 3142: if hr_api.not_exists_in_hr_lookups

3138: -- check if value of lookup falls within lookup type.
3139: --
3140: --
3141: if p_enrt_cd is not null then
3142: if hr_api.not_exists_in_hr_lookups
3143: (p_lookup_type => 'BEN_ENRT',
3144: p_lookup_code => p_enrt_cd,
3145: p_effective_date => p_effective_date) then
3146: --

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 3216: if hr_api.not_exists_in_hr_lookups

3212: -- check if value of lookup falls within lookup type.
3213: --
3214: --
3215: if p_dflt_enrt_cd is not null then
3216: if hr_api.not_exists_in_hr_lookups
3217: (p_lookup_type => 'BEN_DFLT_ENRT',
3218: p_lookup_code => p_dflt_enrt_cd,
3219: p_effective_date => p_effective_date) then
3220: --

Line 3300: and nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)

3296: p_effective_date => p_effective_date,
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: --

Line 3397: and nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)

3393: p_effective_date => p_effective_date,
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: --

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 3483: if hr_api.not_exists_in_hr_lookups

3479: -- check if value of lookup falls within lookup type.
3480: --
3481: --
3482: if p_dpnt_cvg_strt_dt_cd is not null then
3483: if hr_api.not_exists_in_hr_lookups
3484: (p_lookup_type => 'BEN_DPNT_CVG_STRT',
3485: p_lookup_code => p_dpnt_cvg_strt_dt_cd,
3486: p_effective_date => p_effective_date) then
3487: --

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 3556: if hr_api.not_exists_in_hr_lookups

3552: -- check if value of lookup falls within lookup type.
3553: --
3554: --
3555: if p_rt_strt_dt_cd is not null then
3556: if hr_api.not_exists_in_hr_lookups
3557: (p_lookup_type => 'BEN_RT_STRT',
3558: p_lookup_code => p_rt_strt_dt_cd,
3559: p_effective_date => p_effective_date) then
3560: --

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 3629: if hr_api.not_exists_in_hr_lookups

3625: -- check if value of lookup falls within lookup type.
3626: --
3627: --
3628: if p_rt_end_dt_cd is not null then
3629: if hr_api.not_exists_in_hr_lookups
3630: (p_lookup_type => 'BEN_RT_END',
3631: p_lookup_code => p_rt_end_dt_cd,
3632: p_effective_date => p_effective_date) then
3633: --

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 3702: if hr_api.not_exists_in_hr_lookups

3698: -- check if value of lookup falls within lookup type.
3699: --
3700: --
3701: if p_enrt_cvg_end_dt_cd is not null then
3702: if hr_api.not_exists_in_hr_lookups
3703: (p_lookup_type => 'BEN_ENRT_CVG_END',
3704: p_lookup_code => p_enrt_cvg_end_dt_cd,
3705: p_effective_date => p_effective_date) then
3706: --

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 3775: if hr_api.not_exists_in_hr_lookups

3771: -- check if value of lookup falls within lookup type.
3772: --
3773: --
3774: if p_enrt_cvg_strt_dt_cd is not null then
3775: if hr_api.not_exists_in_hr_lookups
3776: (p_lookup_type => 'BEN_ENRT_CVG_STRT',
3777: p_lookup_code => p_enrt_cvg_strt_dt_cd,
3778: p_effective_date => p_effective_date) then
3779: --

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 3849: if hr_api.not_exists_in_hr_lookups

3845: -- check if value of lookup falls within lookup type.
3846: --
3847: --
3848: if p_dpnt_cvg_end_dt_cd is not null then
3849: if hr_api.not_exists_in_hr_lookups
3850: (p_lookup_type => 'BEN_DPNT_CVG_END',
3851: p_lookup_code => p_dpnt_cvg_end_dt_cd,
3852: p_effective_date => p_effective_date) then
3853: --

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 3921: if hr_api.not_exists_in_hr_lookups

3917: and p_coord_cvg_for_all_pls_flag is not null then
3918: --
3919: -- check if value of lookup falls within lookup type.
3920: --
3921: if hr_api.not_exists_in_hr_lookups
3922: (p_lookup_type => 'YES_NO',
3923: p_lookup_code => p_coord_cvg_for_all_pls_flag,
3924: p_effective_date => p_effective_date) then
3925: --

Line 3987: (nvl(p_rqd_perd_enrt_nenrt_val,hr_api.g_number)

3983: p_object_version_number => p_object_version_number);
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

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 3989: nvl(p_rqd_perd_enrt_nenrt_tm_uom,hr_api.g_varchar2)

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: --
3993: -- check dependency.

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 4059: (nvl(p_mx_enrd_alwd_ovrid_num,hr_api.g_number)

4055: p_object_version_number => p_object_version_number);
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

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 4061: nvl(p_no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2)

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: --
4065: -- If flag = 'Y' then num must be null.

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 4128: (nvl(p_mn_enrd_rqd_ovrid_num,hr_api.g_number)

4124: p_object_version_number => p_object_version_number);
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

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 4130: nvl(p_no_mn_pl_typ_overid_flag,hr_api.g_varchar2)

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: --
4134: -- If flag = 'Y' then num must be null.

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 4204: and nvl(p_mx_enrd_alwd_ovrid_num,hr_api.g_number)

4200: p_effective_date => p_effective_date,
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

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 4288: and nvl(p_mn_enrd_rqd_ovrid_num,hr_api.g_number)

4284: p_effective_date => p_effective_date,
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

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 4371: (nvl(p_mx_enrd_alwd_ovrid_num,hr_api.g_number)

4367: p_object_version_number => p_object_version_number);
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)

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 4373: nvl(p_no_mx_pl_typ_ovrid_flag,hr_api.g_varchar2)

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))
4377: or not l_api_updating) then

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 4375: nvl(p_mn_enrd_rqd_ovrid_num,hr_api.g_number)

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: --
4379: -- If min amount has value then max amount must have value or flag must be 'Y'.

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 4444: (nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)

4440: p_object_version_number => p_object_version_number);
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

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 4446: nvl(p_drvd_fctr_dpnt_cvg_flag,hr_api.g_varchar2)

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: --
4450: if nvl(p_dpnt_dsgn_cd,'X') not in ('R','O') and

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 4537: and nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)

4533: p_object_version_number => p_object_version_number);
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: --

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 4661: (nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)

4657: p_object_version_number => p_object_version_number);
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

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 4663: nvl(p_drvd_fctr_dpnt_cvg_flag,hr_api.g_varchar2)

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: --
4667: open c1;

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 4723: (p_pgm_id in number default hr_api.g_number,

4719: --
4720: -- {End Of Comments}
4721: -- ----------------------------------------------------------------------------
4722: Procedure dt_update_validate
4723: (p_pgm_id in number default hr_api.g_number,
4724: p_cmbn_ptip_id in number default hr_api.g_number,
4725: p_cmbn_ptip_opt_id in number default hr_api.g_number,
4726: p_acrs_ptip_cvg_id in number default hr_api.g_number,
4727: p_pl_typ_id in number default hr_api.g_number,

Line 4724: p_cmbn_ptip_id in number default hr_api.g_number,

4720: -- {End Of Comments}
4721: -- ----------------------------------------------------------------------------
4722: Procedure dt_update_validate
4723: (p_pgm_id in number default hr_api.g_number,
4724: p_cmbn_ptip_id in number default hr_api.g_number,
4725: p_cmbn_ptip_opt_id in number default hr_api.g_number,
4726: p_acrs_ptip_cvg_id in number default hr_api.g_number,
4727: p_pl_typ_id in number default hr_api.g_number,
4728: p_datetrack_mode in varchar2,

Line 4725: p_cmbn_ptip_opt_id in number default hr_api.g_number,

4721: -- ----------------------------------------------------------------------------
4722: Procedure dt_update_validate
4723: (p_pgm_id in number default hr_api.g_number,
4724: p_cmbn_ptip_id in number default hr_api.g_number,
4725: p_cmbn_ptip_opt_id in number default hr_api.g_number,
4726: p_acrs_ptip_cvg_id in number default hr_api.g_number,
4727: p_pl_typ_id in number default hr_api.g_number,
4728: p_datetrack_mode in varchar2,
4729: p_validation_start_date in date,

Line 4726: p_acrs_ptip_cvg_id in number default hr_api.g_number,

4722: Procedure dt_update_validate
4723: (p_pgm_id in number default hr_api.g_number,
4724: p_cmbn_ptip_id in number default hr_api.g_number,
4725: p_cmbn_ptip_opt_id in number default hr_api.g_number,
4726: p_acrs_ptip_cvg_id in number default hr_api.g_number,
4727: p_pl_typ_id in number default hr_api.g_number,
4728: p_datetrack_mode in varchar2,
4729: p_validation_start_date in date,
4730: p_validation_end_date in date) Is

Line 4727: p_pl_typ_id in number default hr_api.g_number,

4723: (p_pgm_id in number default hr_api.g_number,
4724: p_cmbn_ptip_id in number default hr_api.g_number,
4725: p_cmbn_ptip_opt_id in number default hr_api.g_number,
4726: p_acrs_ptip_cvg_id in number default hr_api.g_number,
4727: p_pl_typ_id in number default hr_api.g_number,
4728: p_datetrack_mode in varchar2,
4729: p_validation_start_date in date,
4730: p_validation_end_date in date) Is
4731: --

Line 4741: hr_api.mandatory_arg_error

4737: hr_utility.set_location('Entering:'||l_proc, 5);
4738: --
4739: -- Ensure that the p_datetrack_mode argument is not null
4740: --
4741: hr_api.mandatory_arg_error
4742: (p_api_name => l_proc,
4743: p_argument => 'datetrack_mode',
4744: p_argument_value => p_datetrack_mode);
4745: --

Line 4753: hr_api.mandatory_arg_error

4749: --
4750: --
4751: -- Ensure the arguments are not null
4752: --
4753: hr_api.mandatory_arg_error
4754: (p_api_name => l_proc,
4755: p_argument => 'validation_start_date',
4756: p_argument_value => p_validation_start_date);
4757: --

Line 4758: hr_api.mandatory_arg_error

4754: (p_api_name => l_proc,
4755: p_argument => 'validation_start_date',
4756: p_argument_value => p_validation_start_date);
4757: --
4758: hr_api.mandatory_arg_error
4759: (p_api_name => l_proc,
4760: p_argument => 'validation_end_date',
4761: p_argument_value => p_validation_end_date);
4762: --

Line 4763: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

4759: (p_api_name => l_proc,
4760: p_argument => 'validation_end_date',
4761: p_argument_value => p_validation_end_date);
4762: --
4763: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
4764: NOT (dt_api.check_min_max_dates
4765: (p_base_table_name => 'ben_pgm_f',
4766: p_base_key_column => 'pgm_id',
4767: p_base_key_value => p_pgm_id,

Line 4773: If ((nvl(p_cmbn_ptip_id, hr_api.g_number) <> hr_api.g_number) and

4769: p_to_date => p_validation_end_date))) Then
4770: l_table_name := 'ben_pgm_f';
4771: Raise l_integrity_error;
4772: End If;
4773: If ((nvl(p_cmbn_ptip_id, hr_api.g_number) <> hr_api.g_number) and
4774: NOT (dt_api.check_min_max_dates
4775: (p_base_table_name => 'ben_cmbn_ptip_f',
4776: p_base_key_column => 'cmbn_ptip_id',
4777: p_base_key_value => p_cmbn_ptip_id,

Line 4783: If ((nvl(p_cmbn_ptip_opt_id, hr_api.g_number) <> hr_api.g_number) and

4779: p_to_date => p_validation_end_date))) Then
4780: l_table_name := 'ben_cmbn_ptip_f';
4781: Raise l_integrity_error;
4782: End If;
4783: If ((nvl(p_cmbn_ptip_opt_id, hr_api.g_number) <> hr_api.g_number) and
4784: NOT (dt_api.check_min_max_dates
4785: (p_base_table_name => 'ben_cmbn_ptip_opt_f',
4786: p_base_key_column => 'cmbn_ptip_opt_id',
4787: p_base_key_value => p_cmbn_ptip_opt_id,

Line 4793: If ((nvl(p_acrs_ptip_cvg_id, hr_api.g_number) <> hr_api.g_number) and

4789: p_to_date => p_validation_end_date))) Then
4790: l_table_name := 'ben_cmbn_ptip_f';
4791: Raise l_integrity_error;
4792: End If;
4793: If ((nvl(p_acrs_ptip_cvg_id, hr_api.g_number) <> hr_api.g_number) and
4794: NOT (dt_api.check_min_max_dates
4795: (p_base_table_name => 'ben_acrs_ptip_cvg_f',
4796: p_base_key_column => 'acrs_ptip_cvg_id',
4797: p_base_key_value => p_acrs_ptip_cvg_id,

Line 4803: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and

4799: p_to_date => p_validation_end_date))) Then
4800: l_table_name := 'ben_cmbn_ptip_f';
4801: Raise l_integrity_error;
4802: End If;
4803: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and
4804: NOT (dt_api.check_min_max_dates
4805: (p_base_table_name => 'ben_pl_typ_f',
4806: p_base_key_column => 'pl_typ_id',
4807: p_base_key_value => p_pl_typ_id,

Line 4885: hr_api.mandatory_arg_error

4881: hr_utility.set_location('Entering:'||l_proc, 5);
4882: --
4883: -- Ensure that the p_datetrack_mode argument is not null
4884: --
4885: hr_api.mandatory_arg_error
4886: (p_api_name => l_proc,
4887: p_argument => 'datetrack_mode',
4888: p_argument_value => p_datetrack_mode);
4889: --

Line 4899: hr_api.mandatory_arg_error

4895: --
4896: --
4897: -- Ensure the arguments are not null
4898: --
4899: hr_api.mandatory_arg_error
4900: (p_api_name => l_proc,
4901: p_argument => 'validation_start_date',
4902: p_argument_value => p_validation_start_date);
4903: --

Line 4904: hr_api.mandatory_arg_error

4900: (p_api_name => l_proc,
4901: p_argument => 'validation_start_date',
4902: p_argument_value => p_validation_start_date);
4903: --
4904: hr_api.mandatory_arg_error
4905: (p_api_name => l_proc,
4906: p_argument => 'validation_end_date',
4907: p_argument_value => p_validation_end_date);
4908: --

Line 4909: hr_api.mandatory_arg_error

4905: (p_api_name => l_proc,
4906: p_argument => 'validation_end_date',
4907: p_argument_value => p_validation_end_date);
4908: --
4909: hr_api.mandatory_arg_error
4910: (p_api_name => l_proc,
4911: p_argument => 'ptip_id',
4912: p_argument_value => p_ptip_id);
4913: --

Line 5009: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

5005: -- Call all supporting business operations
5006: --
5007: --
5008: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
5009: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
5010: end if;
5011: --
5012: chk_ptip_id
5013: (p_ptip_id => p_rec.ptip_id,

Line 5489: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

5485: -- Call all supporting business operations
5486: --
5487: --
5488: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
5489: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
5490: end if;
5491: --
5492: chk_ptip_id
5493: (p_ptip_id => p_rec.ptip_id,

Line 6014: hr_api.mandatory_arg_error(p_api_name => l_proc,

6010: hr_utility.set_location('Entering:'|| l_proc, 10);
6011: --
6012: -- Ensure that all the mandatory parameter are not null
6013: --
6014: hr_api.mandatory_arg_error(p_api_name => l_proc,
6015: p_argument => 'ptip_id',
6016: p_argument_value => p_ptip_id);
6017: --
6018: open csr_leg_code;