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_PGM_BUS dependencies on BEN_PGM_SHD

Line 48: l_api_updating := ben_pgm_shd.api_updating

44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_pgm_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pgm_id => p_pgm_id,
51: p_object_version_number => p_object_version_number);
52: --

Line 55: <> ben_pgm_shd.g_old_rec.pgm_id) then

51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_pgm_id,hr_api.g_number)
55: <> ben_pgm_shd.g_old_rec.pgm_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_pgm_shd.constraint_error('BEN_PGM_PK');

Line 59: ben_pgm_shd.constraint_error('BEN_PGM_PK');

55: <> ben_pgm_shd.g_old_rec.pgm_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_pgm_shd.constraint_error('BEN_PGM_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 134: l_api_updating := ben_pgm_shd.api_updating

130: Begin
131: --
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: l_api_updating := ben_pgm_shd.api_updating
135: (p_pgm_id => p_pgm_id,
136: p_effective_date => p_effective_date,
137: p_object_version_number => p_object_version_number);
138: --

Line 141: <> ben_pgm_shd.g_old_rec.auto_enrt_mthd_rl

137: p_object_version_number => p_object_version_number);
138: --
139: if (l_api_updating
140: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)
141: <> ben_pgm_shd.g_old_rec.auto_enrt_mthd_rl
142: or not l_api_updating)
143: and p_auto_enrt_mthd_rl is not null then
144: --
145: -- check if value of formula rule is valid.

Line 279: l_api_updating := ben_pgm_shd.api_updating

275: Begin
276: --
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: l_api_updating := ben_pgm_shd.api_updating
280: (p_pgm_id => p_pgm_id,
281: p_effective_date => p_effective_date,
282: p_object_version_number => p_object_version_number);
283: --

Line 286: <> ben_pgm_shd.g_old_rec.enrt_rl

282: p_object_version_number => p_object_version_number);
283: --
284: if (l_api_updating
285: and nvl(p_enrt_rl,hr_api.g_number)
286: <> ben_pgm_shd.g_old_rec.enrt_rl
287: or not l_api_updating)
288: and p_enrt_rl is not null then
289: --
290: -- check if value of formula rule is valid.

Line 372: l_api_updating := ben_pgm_shd.api_updating

368: Begin
369: --
370: hr_utility.set_location('Entering:'||l_proc, 5);
371: --
372: l_api_updating := ben_pgm_shd.api_updating
373: (p_pgm_id => p_pgm_id,
374: p_effective_date => p_effective_date,
375: p_object_version_number => p_object_version_number);
376: --

Line 379: <> ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_rl

375: p_object_version_number => p_object_version_number);
376: --
377: if (l_api_updating
378: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
379: <> ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_rl
380: or not l_api_updating)
381: and p_enrt_cvg_strt_dt_rl is not null then
382: --
383: -- check if value of formula rule is valid.

Line 465: l_api_updating := ben_pgm_shd.api_updating

461: Begin
462: --
463: hr_utility.set_location('Entering:'||l_proc, 5);
464: --
465: l_api_updating := ben_pgm_shd.api_updating
466: (p_pgm_id => p_pgm_id,
467: p_effective_date => p_effective_date,
468: p_object_version_number => p_object_version_number);
469: --

Line 472: <> ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_rl

468: p_object_version_number => p_object_version_number);
469: --
470: if (l_api_updating
471: and nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
472: <> ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_rl
473: or not l_api_updating)
474: and p_enrt_cvg_end_dt_rl is not null then
475: --
476: -- check if value of formula rule is valid.

Line 517: l_api_updating := ben_pgm_shd.api_updating

513: Begin
514: --
515: hr_utility.set_location('Entering:'||l_proc, 5);
516: --
517: l_api_updating := ben_pgm_shd.api_updating
518: (p_pgm_id => p_pgm_id,
519: p_effective_date => p_effective_date,
520: p_object_version_number => p_object_version_number);
521: --

Line 524: <> nvl(ben_pgm_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)

520: p_object_version_number => p_object_version_number);
521: --
522: if (l_api_updating
523: and p_vrfy_fmly_mmbr_cd
524: <> nvl(ben_pgm_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)
525: or not l_api_updating)
526: and p_vrfy_fmly_mmbr_cd is not null
527: then
528: --

Line 572: l_api_updating := ben_pgm_shd.api_updating

568: Begin
569: --
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: l_api_updating := ben_pgm_shd.api_updating
573: (p_effective_date => p_effective_date,
574: p_pgm_id => p_pgm_id,
575: p_object_version_number => p_object_version_number);
576: --

Line 579: <> ben_pgm_shd.g_old_rec.vrfy_fmly_mmbr_rl

575: p_object_version_number => p_object_version_number);
576: --
577: if (l_api_updating
578: and nvl(p_vrfy_fmly_mmbr_rl,hr_api.g_number)
579: <> ben_pgm_shd.g_old_rec.vrfy_fmly_mmbr_rl
580: or not l_api_updating)
581: and p_vrfy_fmly_mmbr_rl is not null then
582: --
583: -- check if value of formula rule is valid.

Line 665: l_api_updating := ben_pgm_shd.api_updating

661: Begin
662: --
663: hr_utility.set_location('Entering:'||l_proc, 5);
664: --
665: l_api_updating := ben_pgm_shd.api_updating
666: (p_pgm_id => p_pgm_id,
667: p_effective_date => p_effective_date,
668: p_object_version_number => p_object_version_number);
669: --

Line 672: <> ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl

668: p_object_version_number => p_object_version_number);
669: --
670: if (l_api_updating
671: and nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
672: <> ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl
673: or not l_api_updating)
674: and p_dpnt_cvg_strt_dt_rl is not null then
675: --
676: -- check if value of formula rule is valid.

Line 757: l_api_updating := ben_pgm_shd.api_updating

753: Begin
754: --
755: hr_utility.set_location('Entering:'||l_proc, 5);
756: --
757: l_api_updating := ben_pgm_shd.api_updating
758: (p_pgm_id => p_pgm_id,
759: p_effective_date => p_effective_date,
760: p_object_version_number => p_object_version_number);
761: --

Line 764: <> ben_pgm_shd.g_old_rec.rt_end_dt_rl

760: p_object_version_number => p_object_version_number);
761: --
762: if (l_api_updating
763: and nvl(p_rt_end_dt_rl,hr_api.g_number)
764: <> ben_pgm_shd.g_old_rec.rt_end_dt_rl
765: or not l_api_updating)
766: and p_rt_end_dt_rl is not null then
767: --
768: -- check if value of formula rule is valid.

Line 851: l_api_updating := ben_pgm_shd.api_updating

847: Begin
848: --
849: hr_utility.set_location('Entering:'||l_proc, 5);
850: --
851: l_api_updating := ben_pgm_shd.api_updating
852: (p_pgm_id => p_pgm_id,
853: p_effective_date => p_effective_date,
854: p_object_version_number => p_object_version_number);
855: --

Line 858: <> ben_pgm_shd.g_old_rec.rt_strt_dt_rl

854: p_object_version_number => p_object_version_number);
855: --
856: if (l_api_updating
857: and nvl(p_rt_strt_dt_rl,hr_api.g_number)
858: <> ben_pgm_shd.g_old_rec.rt_strt_dt_rl
859: or not l_api_updating)
860: and p_rt_strt_dt_rl is not null then
861: --
862: -- check if value of formula rule is valid.

Line 946: l_api_updating := ben_pgm_shd.api_updating

942: Begin
943: --
944: hr_utility.set_location('Entering:'||l_proc, 5);
945: --
946: l_api_updating := ben_pgm_shd.api_updating
947: (p_pgm_id => p_pgm_id,
948: p_effective_date => p_effective_date,
949: p_object_version_number => p_object_version_number);
950: --

Line 953: <> ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl

949: p_object_version_number => p_object_version_number);
950: --
951: if (l_api_updating
952: and nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
953: <> ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl
954: or not l_api_updating)
955: and p_dpnt_cvg_end_dt_rl is not null then
956: --
957: -- check if value of formula rule is valid.

Line 1038: l_api_updating := ben_pgm_shd.api_updating

1034: Begin
1035: --
1036: hr_utility.set_location('Entering:'||l_proc, 5);
1037: --
1038: l_api_updating := ben_pgm_shd.api_updating
1039: (p_pgm_id => p_pgm_id,
1040: p_effective_date => p_effective_date,
1041: p_object_version_number => p_object_version_number);
1042: --

Line 1045: <> ben_pgm_shd.g_old_rec.prtn_end_dt_rl

1041: p_object_version_number => p_object_version_number);
1042: --
1043: if (l_api_updating
1044: and nvl(p_prtn_end_dt_rl,hr_api.g_number)
1045: <> ben_pgm_shd.g_old_rec.prtn_end_dt_rl
1046: or not l_api_updating)
1047: and p_prtn_end_dt_rl is not null then
1048: --
1049: -- check if value of formula rule is valid.

Line 1132: l_api_updating := ben_pgm_shd.api_updating

1128: Begin
1129: --
1130: hr_utility.set_location('Entering:'||l_proc, 5);
1131: --
1132: l_api_updating := ben_pgm_shd.api_updating
1133: (p_pgm_id => p_pgm_id,
1134: p_effective_date => p_effective_date,
1135: p_object_version_number => p_object_version_number);
1136: --

Line 1139: <> ben_pgm_shd.g_old_rec.prtn_strt_dt_rl

1135: p_object_version_number => p_object_version_number);
1136: --
1137: if (l_api_updating
1138: and nvl(p_prtn_strt_dt_rl,hr_api.g_number)
1139: <> ben_pgm_shd.g_old_rec.prtn_strt_dt_rl
1140: or not l_api_updating)
1141: and p_prtn_strt_dt_rl is not null then
1142: --
1143: -- check if value of formula rule is valid.

Line 1211: l_api_updating := ben_pgm_shd.api_updating

1207: Begin
1208: --
1209: hr_utility.set_location('Entering:'||l_proc, 5);
1210: --
1211: l_api_updating := ben_pgm_shd.api_updating
1212: (p_pgm_id => p_pgm_id,
1213: p_effective_date => p_effective_date,
1214: p_object_version_number => p_object_version_number);
1215: --

Line 1218: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2)

1214: p_object_version_number => p_object_version_number);
1215: --
1216: if (l_api_updating
1217: and p_dpnt_adrs_rqd_flag
1218: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2)
1219: or not l_api_updating)
1220: and p_dpnt_adrs_rqd_flag is not null then
1221: --
1222: -- check if value of lookup falls within lookup type.

Line 1282: l_api_updating := ben_pgm_shd.api_updating

1278: Begin
1279: --
1280: hr_utility.set_location('Entering:'||l_proc, 5);
1281: --
1282: l_api_updating := ben_pgm_shd.api_updating
1283: (p_pgm_id => p_pgm_id,
1284: p_effective_date => p_effective_date,
1285: p_object_version_number => p_object_version_number);
1286: --

Line 1289: <> nvl(ben_pgm_shd.g_old_rec.elig_apls_to_all_pls_flag,hr_api.g_varchar2)

1285: p_object_version_number => p_object_version_number);
1286: --
1287: if (l_api_updating
1288: and p_elig_apls_to_all_pls_flag
1289: <> nvl(ben_pgm_shd.g_old_rec.elig_apls_to_all_pls_flag,hr_api.g_varchar2)
1290: or not l_api_updating)
1291: and p_elig_apls_to_all_pls_flag is not null then
1292: --
1293: -- check if value of lookup falls within lookup type.

Line 1353: l_api_updating := ben_pgm_shd.api_updating

1349: Begin
1350: --
1351: hr_utility.set_location('Entering:'||l_proc, 5);
1352: --
1353: l_api_updating := ben_pgm_shd.api_updating
1354: (p_pgm_id => p_pgm_id,
1355: p_effective_date => p_effective_date,
1356: p_object_version_number => p_object_version_number);
1357: --

Line 1360: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2)

1356: p_object_version_number => p_object_version_number);
1357: --
1358: if (l_api_updating
1359: and p_dpnt_dob_rqd_flag
1360: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2)
1361: or not l_api_updating)
1362: and p_dpnt_dob_rqd_flag is not null then
1363: --
1364: -- check if value of lookup falls within lookup type.

Line 1423: l_api_updating := ben_pgm_shd.api_updating

1419: Begin
1420: --
1421: hr_utility.set_location('Entering:'||l_proc, 5);
1422: --
1423: l_api_updating := ben_pgm_shd.api_updating
1424: (p_pgm_id => p_pgm_id,
1425: p_effective_date => p_effective_date,
1426: p_object_version_number => p_object_version_number);
1427: --

Line 1430: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_auto_enrt_flag,hr_api.g_varchar2)

1426: p_object_version_number => p_object_version_number);
1427: --
1428: if (l_api_updating
1429: and p_pgm_prvds_no_auto_enrt_flag
1430: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_auto_enrt_flag,hr_api.g_varchar2)
1431: or not l_api_updating)
1432: and p_pgm_prvds_no_auto_enrt_flag is not null then
1433: --
1434: -- check if value of lookup falls within lookup type.

Line 1493: l_api_updating := ben_pgm_shd.api_updating

1489: Begin
1490: --
1491: hr_utility.set_location('Entering:'||l_proc, 5);
1492: --
1493: l_api_updating := ben_pgm_shd.api_updating
1494: (p_pgm_id => p_pgm_id,
1495: p_effective_date => p_effective_date,
1496: p_object_version_number => p_object_version_number);
1497: --

Line 1500: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)

1496: p_object_version_number => p_object_version_number);
1497: --
1498: if (l_api_updating
1499: and p_pgm_prvds_no_dflt_enrt_flag
1500: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)
1501: or not l_api_updating)
1502: and p_pgm_prvds_no_dflt_enrt_flag is not null then
1503: --
1504: -- check if value of lookup falls within lookup type.

Line 1563: l_api_updating := ben_pgm_shd.api_updating

1559: Begin
1560: --
1561: hr_utility.set_location('Entering:'||l_proc, 5);
1562: --
1563: l_api_updating := ben_pgm_shd.api_updating
1564: (p_pgm_id => p_pgm_id,
1565: p_effective_date => p_effective_date,
1566: p_object_version_number => p_object_version_number);
1567: --

Line 1570: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2)

1566: p_object_version_number => p_object_version_number);
1567: --
1568: if (l_api_updating
1569: and p_dpnt_legv_id_rqd_flag
1570: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
1571: or not l_api_updating)
1572: and p_dpnt_legv_id_rqd_flag is not null then
1573: --
1574: -- check if value of lookup falls within lookup type.

Line 1633: l_api_updating := ben_pgm_shd.api_updating

1629: Begin
1630: --
1631: hr_utility.set_location('Entering:'||l_proc, 5);
1632: --
1633: l_api_updating := ben_pgm_shd.api_updating
1634: (p_pgm_id => p_pgm_id,
1635: p_effective_date => p_effective_date,
1636: p_object_version_number => p_object_version_number);
1637: --

Line 1640: <> nvl(ben_pgm_shd.g_old_rec.elig_apls_flag,hr_api.g_varchar2)

1636: p_object_version_number => p_object_version_number);
1637: --
1638: if (l_api_updating
1639: and p_elig_apls_flag
1640: <> nvl(ben_pgm_shd.g_old_rec.elig_apls_flag,hr_api.g_varchar2)
1641: or not l_api_updating)
1642: and p_elig_apls_flag is not null then
1643: --
1644: -- check if value of lookup falls within lookup type.

Line 1703: l_api_updating := ben_pgm_shd.api_updating

1699: Begin
1700: --
1701: hr_utility.set_location('Entering:'||l_proc, 5);
1702: --
1703: l_api_updating := ben_pgm_shd.api_updating
1704: (p_pgm_id => p_pgm_id,
1705: p_effective_date => p_effective_date,
1706: p_object_version_number => p_object_version_number);
1707: --

Line 1710: <> nvl(ben_pgm_shd.g_old_rec.uses_all_asmts_for_rts_flag,hr_api.g_varchar2)

1706: p_object_version_number => p_object_version_number);
1707: --
1708: if (l_api_updating
1709: and p_uses_all_asmts_for_rts_flag
1710: <> nvl(ben_pgm_shd.g_old_rec.uses_all_asmts_for_rts_flag,hr_api.g_varchar2)
1711: or not l_api_updating)
1712: and p_uses_all_asmts_for_rts_flag is not null then
1713: --
1714: -- check if value of lookup falls within lookup type.

Line 1773: l_api_updating := ben_pgm_shd.api_updating

1769: Begin
1770: --
1771: hr_utility.set_location('Entering:'||l_proc, 5);
1772: --
1773: l_api_updating := ben_pgm_shd.api_updating
1774: (p_pgm_id => p_pgm_id,
1775: p_effective_date => p_effective_date,
1776: p_object_version_number => p_object_version_number);
1777: --

Line 1780: <> nvl(ben_pgm_shd.g_old_rec.prtn_elig_ovrid_alwd_flag,hr_api.g_varchar2)

1776: p_object_version_number => p_object_version_number);
1777: --
1778: if (l_api_updating
1779: and p_prtn_elig_ovrid_alwd_flag
1780: <> nvl(ben_pgm_shd.g_old_rec.prtn_elig_ovrid_alwd_flag,hr_api.g_varchar2)
1781: or not l_api_updating)
1782: and p_prtn_elig_ovrid_alwd_flag is not null then
1783: --
1784: -- check if value of lookup falls within lookup type.

Line 1845: l_api_updating := ben_pgm_shd.api_updating

1841: Begin
1842: --
1843: hr_utility.set_location('Entering:'||l_proc, 5);
1844: --
1845: l_api_updating := ben_pgm_shd.api_updating
1846: (p_pgm_id => p_pgm_id,
1847: p_effective_date => p_effective_date,
1848: p_object_version_number => p_object_version_number);
1849: --

Line 1852: <> nvl(ben_pgm_shd.g_old_rec.tmprl_fctr_apls_rts_flag,hr_api.g_varchar2)

1848: p_object_version_number => p_object_version_number);
1849: --
1850: if (l_api_updating
1851: and p_tmprl_fctr_apls_rts_flag
1852: <> nvl(ben_pgm_shd.g_old_rec.tmprl_fctr_apls_rts_flag,hr_api.g_varchar2)
1853: or not l_api_updating)
1854: and p_tmprl_fctr_apls_rts_flag is not null then
1855: --
1856: -- check if value of lookup falls within lookup type.

Line 1916: l_api_updating := ben_pgm_shd.api_updating

1912: Begin
1913: --
1914: hr_utility.set_location('Entering:'||l_proc, 5);
1915: --
1916: l_api_updating := ben_pgm_shd.api_updating
1917: (p_pgm_id => p_pgm_id,
1918: p_effective_date => p_effective_date,
1919: p_object_version_number => p_object_version_number);
1920: --

Line 1923: <> nvl(ben_pgm_shd.g_old_rec.pgm_use_all_asnts_elig_flag,hr_api.g_varchar2)

1919: p_object_version_number => p_object_version_number);
1920: --
1921: if (l_api_updating
1922: and p_pgm_use_all_asnts_elig_flag
1923: <> nvl(ben_pgm_shd.g_old_rec.pgm_use_all_asnts_elig_flag,hr_api.g_varchar2)
1924: or not l_api_updating)
1925: and p_pgm_use_all_asnts_elig_flag is not null then
1926: --
1927: -- check if value of lookup falls within lookup type.

Line 1987: l_api_updating := ben_pgm_shd.api_updating

1983: Begin
1984: --
1985: hr_utility.set_location('Entering:'||l_proc, 5);
1986: --
1987: l_api_updating := ben_pgm_shd.api_updating
1988: (p_pgm_id => p_pgm_id,
1989: p_effective_date => p_effective_date,
1990: p_object_version_number => p_object_version_number);
1991: --

Line 1994: <> nvl(ben_pgm_shd.g_old_rec.coord_cvg_for_all_pls_flg,hr_api.g_varchar2)

1990: p_object_version_number => p_object_version_number);
1991: --
1992: if (l_api_updating
1993: and p_coord_cvg_for_all_pls_flg
1994: <> nvl(ben_pgm_shd.g_old_rec.coord_cvg_for_all_pls_flg,hr_api.g_varchar2)
1995: or not l_api_updating)
1996: and p_coord_cvg_for_all_pls_flg is not null then
1997: --
1998: -- check if value of lookup falls within lookup type.

Line 2058: l_api_updating := ben_pgm_shd.api_updating

2054: Begin
2055: --
2056: hr_utility.set_location('Entering:'||l_proc, 5);
2057: --
2058: l_api_updating := ben_pgm_shd.api_updating
2059: (p_pgm_id => p_pgm_id,
2060: p_effective_date => p_effective_date,
2061: p_object_version_number => p_object_version_number);
2062: --

Line 2065: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)

2061: p_object_version_number => p_object_version_number);
2062: --
2063: if (l_api_updating
2064: and p_drvbl_fctr_dpnt_elig_flag
2065: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
2066: or not l_api_updating)
2067: and p_drvbl_fctr_dpnt_elig_flag is not null then
2068: --
2069: -- check if value of lookup falls within lookup type.

Line 2130: l_api_updating := ben_pgm_shd.api_updating

2126: Begin
2127: --
2128: hr_utility.set_location('Entering:'||l_proc, 5);
2129: --
2130: l_api_updating := ben_pgm_shd.api_updating
2131: (p_pgm_id => p_pgm_id,
2132: p_effective_date => p_effective_date,
2133: p_object_version_number => p_object_version_number);
2134: --

Line 2137: <> nvl(ben_pgm_shd.g_old_rec.mt_one_dpnt_cvg_elig_flag,hr_api.g_varchar2)

2133: p_object_version_number => p_object_version_number);
2134: --
2135: if (l_api_updating
2136: and p_mt_one_dpnt_cvg_elig_flag
2137: <> nvl(ben_pgm_shd.g_old_rec.mt_one_dpnt_cvg_elig_flag,hr_api.g_varchar2)
2138: or not l_api_updating)
2139: and p_mt_one_dpnt_cvg_elig_flag is not null then
2140: --
2141: -- check if value of lookup falls within lookup type.

Line 2201: l_api_updating := ben_pgm_shd.api_updating

2197: Begin
2198: --
2199: hr_utility.set_location('Entering:'||l_proc, 5);
2200: --
2201: l_api_updating := ben_pgm_shd.api_updating
2202: (p_pgm_id => p_pgm_id,
2203: p_effective_date => p_effective_date,
2204: p_object_version_number => p_object_version_number);
2205: --

Line 2208: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_prtn_elig_flag,hr_api.g_varchar2)

2204: p_object_version_number => p_object_version_number);
2205: --
2206: if (l_api_updating
2207: and p_drvbl_fctr_prtn_elig_flag
2208: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_prtn_elig_flag,hr_api.g_varchar2)
2209: or not l_api_updating)
2210: and p_drvbl_fctr_prtn_elig_flag is not null then
2211: --
2212: -- check if value of lookup falls within lookup type.

Line 2274: l_api_updating := ben_pgm_shd.api_updating

2270: Begin
2271: --
2272: hr_utility.set_location('Entering:'||l_proc, 5);
2273: --
2274: l_api_updating := ben_pgm_shd.api_updating
2275: (p_pgm_id => p_pgm_id,
2276: p_effective_date => p_effective_date,
2277: p_object_version_number => p_object_version_number);
2278: --

Line 2281: <> nvl(ben_pgm_shd.g_old_rec.alws_unrstrctd_enrt_flag,hr_api.g_varchar2)

2277: p_object_version_number => p_object_version_number);
2278: --
2279: if (l_api_updating
2280: and p_alws_unrstrctd_enrt_flag
2281: <> nvl(ben_pgm_shd.g_old_rec.alws_unrstrctd_enrt_flag,hr_api.g_varchar2)
2282: or not l_api_updating)
2283: and p_alws_unrstrctd_enrt_flag is not null then
2284: --
2285: -- check if value of lookup falls within lookup type.

Line 2344: l_api_updating := ben_pgm_shd.api_updating

2340: Begin
2341: --
2342: hr_utility.set_location('Entering:'||l_proc, 5);
2343: --
2344: l_api_updating := ben_pgm_shd.api_updating
2345: (p_pgm_id => p_pgm_id,
2346: p_effective_date => p_effective_date,
2347: p_object_version_number => p_object_version_number);
2348: --

Line 2351: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_apls_rts_flag,hr_api.g_varchar2)

2347: p_object_version_number => p_object_version_number);
2348: --
2349: if (l_api_updating
2350: and p_drvbl_fctr_apls_rts_flag
2351: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_apls_rts_flag,hr_api.g_varchar2)
2352: or not l_api_updating)
2353: and p_drvbl_fctr_apls_rts_flag is not null then
2354: --
2355: -- check if value of lookup falls within lookup type.

Line 2416: l_api_updating := ben_pgm_shd.api_updating

2412: Begin
2413: --
2414: hr_utility.set_location('Entering:'||l_proc, 5);
2415: --
2416: l_api_updating := ben_pgm_shd.api_updating
2417: (p_pgm_id => p_pgm_id,
2418: p_effective_date => p_effective_date,
2419: p_object_version_number => p_object_version_number);
2420: --

Line 2423: <> nvl(ben_pgm_shd.g_old_rec.tmprl_fctr_dpnt_elig_flag,hr_api.g_varchar2)

2419: p_object_version_number => p_object_version_number);
2420: --
2421: if (l_api_updating
2422: and p_tmprl_fctr_dpnt_elig_flag
2423: <> nvl(ben_pgm_shd.g_old_rec.tmprl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
2424: or not l_api_updating)
2425: and p_tmprl_fctr_dpnt_elig_flag is not null then
2426: --
2427: -- check if value of lookup falls within lookup type.

Line 2487: l_api_updating := ben_pgm_shd.api_updating

2483: Begin
2484: --
2485: hr_utility.set_location('Entering:'||l_proc, 5);
2486: --
2487: l_api_updating := ben_pgm_shd.api_updating
2488: (p_pgm_id => p_pgm_id,
2489: p_effective_date => p_effective_date,
2490: p_object_version_number => p_object_version_number);
2491: --

Line 2494: <> nvl(ben_pgm_shd.g_old_rec.tmprl_fctr_prtn_elig_flag,hr_api.g_varchar2)

2490: p_object_version_number => p_object_version_number);
2491: --
2492: if (l_api_updating
2493: and p_tmprl_fctr_prtn_elig_flag
2494: <> nvl(ben_pgm_shd.g_old_rec.tmprl_fctr_prtn_elig_flag,hr_api.g_varchar2)
2495: or not l_api_updating)
2496: and p_tmprl_fctr_prtn_elig_flag is not null then
2497: --
2498: -- check if value of lookup falls within lookup type.

Line 2558: l_api_updating := ben_pgm_shd.api_updating

2554: Begin
2555: --
2556: hr_utility.set_location('Entering:'||l_proc, 5);
2557: --
2558: l_api_updating := ben_pgm_shd.api_updating
2559: (p_pgm_id => p_pgm_id,
2560: p_effective_date => p_effective_date,
2561: p_object_version_number => p_object_version_number);
2562: --

Line 2565: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)

2561: p_object_version_number => p_object_version_number);
2562: --
2563: if (l_api_updating
2564: and p_dpnt_dsgn_no_ctfn_rqd_flag
2565: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
2566: or not l_api_updating)
2567: and p_dpnt_dsgn_no_ctfn_rqd_flag is not null then
2568: --
2569: -- check if value of lookup falls within lookup type.

Line 2629: l_api_updating := ben_pgm_shd.api_updating

2625: Begin
2626: --
2627: hr_utility.set_location('Entering:'||l_proc, 5);
2628: --
2629: l_api_updating := ben_pgm_shd.api_updating
2630: (p_pgm_id => p_pgm_id,
2631: p_effective_date => p_effective_date,
2632: p_object_version_number => p_object_version_number);
2633: --

Line 2636: <> nvl(ben_pgm_shd.g_old_rec.trk_inelig_per_flag,hr_api.g_varchar2)

2632: p_object_version_number => p_object_version_number);
2633: --
2634: if (l_api_updating
2635: and p_trk_inelig_per_flag
2636: <> nvl(ben_pgm_shd.g_old_rec.trk_inelig_per_flag,hr_api.g_varchar2)
2637: or not l_api_updating)
2638: and p_trk_inelig_per_flag is not null then
2639: --
2640: -- check if value of lookup falls within lookup type.

Line 2912: l_api_updating := ben_pgm_shd.api_updating

2908: --
2909: hr_utility.set_location('Entering:'||l_proc, 5);
2910:
2911: --
2912: l_api_updating := ben_pgm_shd.api_updating
2913: (p_pgm_id => p_pgm_id,
2914: p_effective_date => p_effective_date,
2915: p_object_version_number => p_object_version_number);
2916: --

Line 2919: <> nvl(ben_pgm_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)

2915: p_object_version_number => p_object_version_number);
2916: --
2917: if (l_api_updating
2918: and p_enrt_mthd_cd
2919: <> nvl(ben_pgm_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)
2920: or not l_api_updating)
2921: and p_enrt_mthd_cd is not null then
2922: --
2923: -- check if value of lookup falls within lookup type.

Line 2984: l_api_updating := ben_pgm_shd.api_updating

2980: --
2981: hr_utility.set_location('Entering:'||l_proc, 5);
2982:
2983: --
2984: l_api_updating := ben_pgm_shd.api_updating
2985: (p_pgm_id => p_pgm_id,
2986: p_effective_date => p_effective_date,
2987: p_object_version_number => p_object_version_number);
2988: --

Line 2991: <> nvl(ben_pgm_shd.g_old_rec.poe_lvl_cd,hr_api.g_varchar2)

2987: p_object_version_number => p_object_version_number);
2988: --
2989: if (l_api_updating
2990: and p_poe_lvl_cd
2991: <> nvl(ben_pgm_shd.g_old_rec.poe_lvl_cd,hr_api.g_varchar2)
2992: or not l_api_updating)
2993: and p_poe_lvl_cd is not null then
2994: --
2995: -- check if value of lookup falls within lookup type.

Line 3057: l_api_updating := ben_pgm_shd.api_updating

3053: --
3054: hr_utility.set_location('Entering:'||l_proc, 5);
3055:
3056: --
3057: l_api_updating := ben_pgm_shd.api_updating
3058: (p_pgm_id => p_pgm_id,
3059: p_effective_date => p_effective_date,
3060: p_object_version_number => p_object_version_number);
3061: --

Line 3064: <> nvl(ben_pgm_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

3060: p_object_version_number => p_object_version_number);
3061: --
3062: if (l_api_updating
3063: and p_enrt_cd
3064: <> nvl(ben_pgm_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
3065: or not l_api_updating)
3066: and p_enrt_cd is not null then
3067: --
3068: -- check if value of lookup falls within lookup type.

Line 3128: l_api_updating := ben_pgm_shd.api_updating

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

Line 3135: <> nvl(ben_pgm_shd.g_old_rec.pgm_stat_cd,hr_api.g_varchar2)

3131: p_object_version_number => p_object_version_number);
3132: --
3133: if (l_api_updating
3134: and p_pgm_stat_cd
3135: <> nvl(ben_pgm_shd.g_old_rec.pgm_stat_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 3197: l_api_updating := ben_pgm_shd.api_updating

3193: Begin
3194: --
3195: hr_utility.set_location('Entering:'||l_proc, 5);
3196: --
3197: l_api_updating := ben_pgm_shd.api_updating
3198: (p_pgm_id => p_pgm_id,
3199: p_effective_date => p_effective_date,
3200: p_object_version_number => p_object_version_number);
3201: --

Line 3204: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)

3200: p_object_version_number => p_object_version_number);
3201: --
3202: if (l_api_updating
3203: and p_dpnt_dsgn_lvl_cd
3204: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
3205: or not l_api_updating) then
3206: --
3207: -- check if value of lookup falls within lookup type.
3208: --

Line 3268: l_api_updating := ben_pgm_shd.api_updating

3264: Begin
3265: --
3266: hr_utility.set_location('Entering:'||l_proc, 5);
3267: --
3268: l_api_updating := ben_pgm_shd.api_updating
3269: (p_pgm_id => p_pgm_id,
3270: p_effective_date => p_effective_date,
3271: p_object_version_number => p_object_version_number);
3272: --

Line 3275: <> nvl(ben_pgm_shd.g_old_rec.pgm_typ_cd,hr_api.g_varchar2)

3271: p_object_version_number => p_object_version_number);
3272: --
3273: if (l_api_updating
3274: and p_pgm_typ_cd
3275: <> nvl(ben_pgm_shd.g_old_rec.pgm_typ_cd,hr_api.g_varchar2)
3276: or not l_api_updating) then
3277: --
3278: -- check if value of lookup falls within lookup type.
3279: --

Line 3344: l_api_updating := ben_pgm_shd.api_updating

3340: Begin
3341: --
3342: hr_utility.set_location('Entering:'||l_proc, 5);
3343: --
3344: l_api_updating := ben_pgm_shd.api_updating
3345: (p_pgm_id => p_pgm_id,
3346: p_effective_date => p_effective_date,
3347: p_object_version_number => p_object_version_number);
3348: --

Line 3351: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2)

3347: p_object_version_number => p_object_version_number);
3348: --
3349: if (l_api_updating
3350: and p_dpnt_dsgn_cd
3351: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2)
3352: or not l_api_updating) then
3353: --
3354: -- check if value of lookup falls within lookup type.
3355: --

Line 3435: l_api_updating := ben_pgm_shd.api_updating

3431: Begin
3432: --
3433: hr_utility.set_location('Entering:'||l_proc, 5);
3434: --
3435: l_api_updating := ben_pgm_shd.api_updating
3436: (p_pgm_id => p_pgm_id,
3437: p_effective_date => p_effective_date,
3438: p_object_version_number => p_object_version_number);
3439: --

Line 3442: <> nvl(ben_pgm_shd.g_old_rec.pgm_grp_cd,hr_api.g_varchar2)

3438: p_object_version_number => p_object_version_number);
3439: --
3440: if (l_api_updating
3441: and p_pgm_grp_cd
3442: <> nvl(ben_pgm_shd.g_old_rec.pgm_grp_cd,hr_api.g_varchar2)
3443: or not l_api_updating) then
3444: --
3445: -- check if value of lookup falls within lookup type.
3446: --

Line 3506: l_api_updating := ben_pgm_shd.api_updating

3502: Begin
3503: --
3504: hr_utility.set_location('Entering:'||l_proc, 5);
3505: --
3506: l_api_updating := ben_pgm_shd.api_updating
3507: (p_pgm_id => p_pgm_id,
3508: p_effective_date => p_effective_date,
3509: p_object_version_number => p_object_version_number);
3510: --

Line 3513: <> nvl(ben_pgm_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)

3509: p_object_version_number => p_object_version_number);
3510: --
3511: if (l_api_updating
3512: and p_acty_ref_perd_cd
3513: <> nvl(ben_pgm_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)
3514: or not l_api_updating) then
3515: --
3516: -- check if value of lookup falls within lookup type.
3517: --

Line 3577: l_api_updating := ben_pgm_shd.api_updating

3573: Begin
3574: --
3575: hr_utility.set_location('Entering:'||l_proc, 5);
3576: --
3577: l_api_updating := ben_pgm_shd.api_updating
3578: (p_pgm_id => p_pgm_id,
3579: p_effective_date => p_effective_date,
3580: p_object_version_number => p_object_version_number);
3581: --

Line 3584: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)

3580: p_object_version_number => p_object_version_number);
3581: --
3582: if (l_api_updating
3583: and p_enrt_cvg_strt_dt_cd
3584: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
3585: or not l_api_updating) then
3586: --
3587: -- check if value of lookup falls within lookup type.
3588: --

Line 3648: l_api_updating := ben_pgm_shd.api_updating

3644: Begin
3645: --
3646: hr_utility.set_location('Entering:'||l_proc, 5);
3647: --
3648: l_api_updating := ben_pgm_shd.api_updating
3649: (p_pgm_id => p_pgm_id,
3650: p_effective_date => p_effective_date,
3651: p_object_version_number => p_object_version_number);
3652: --

Line 3655: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)

3651: p_object_version_number => p_object_version_number);
3652: --
3653: if (l_api_updating
3654: and p_enrt_cvg_end_dt_cd
3655: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)
3656: or not l_api_updating) then
3657: --
3658: -- check if value of lookup falls within lookup type.
3659: --

Line 3720: l_api_updating := ben_pgm_shd.api_updating

3716: Begin
3717: --
3718: hr_utility.set_location('Entering:'||l_proc, 5);
3719: --
3720: l_api_updating := ben_pgm_shd.api_updating
3721: (p_pgm_id => p_pgm_id,
3722: p_effective_date => p_effective_date,
3723: p_object_version_number => p_object_version_number);
3724: --

Line 3727: <> nvl(ben_pgm_shd.g_old_rec.prtn_strt_dt_cd,hr_api.g_varchar2)

3723: p_object_version_number => p_object_version_number);
3724: --
3725: if (l_api_updating
3726: and p_prtn_strt_dt_cd
3727: <> nvl(ben_pgm_shd.g_old_rec.prtn_strt_dt_cd,hr_api.g_varchar2)
3728: or not l_api_updating) then
3729: --
3730: -- check if value of lookup falls within lookup type.
3731: --

Line 3791: l_api_updating := ben_pgm_shd.api_updating

3787: Begin
3788: --
3789: hr_utility.set_location('Entering:'||l_proc, 5);
3790: --
3791: l_api_updating := ben_pgm_shd.api_updating
3792: (p_pgm_id => p_pgm_id,
3793: p_effective_date => p_effective_date,
3794: p_object_version_number => p_object_version_number);
3795: --

Line 3798: <> nvl(ben_pgm_shd.g_old_rec.prtn_end_dt_cd,hr_api.g_varchar2)

3794: p_object_version_number => p_object_version_number);
3795: --
3796: if (l_api_updating
3797: and p_prtn_end_dt_cd
3798: <> nvl(ben_pgm_shd.g_old_rec.prtn_end_dt_cd,hr_api.g_varchar2)
3799: or not l_api_updating) then
3800: --
3801: -- check if value of lookup falls within lookup type.
3802: --

Line 3870: l_api_updating := ben_pgm_shd.api_updating

3866: --
3867: hr_utility.set_location('Entering:'||l_proc, 5);
3868: --
3869:
3870: l_api_updating := ben_pgm_shd.api_updating
3871: (p_pgm_id => p_pgm_id,
3872: p_effective_date => p_effective_date,
3873: p_object_version_number => p_object_version_number);
3874: --

Line 3877: <> nvl(ben_pgm_shd.g_old_rec.pgm_uom,hr_api.g_varchar2)

3873: p_object_version_number => p_object_version_number);
3874: --
3875: if (l_api_updating
3876: and p_pgm_uom
3877: <> nvl(ben_pgm_shd.g_old_rec.pgm_uom,hr_api.g_varchar2)
3878: or not l_api_updating)
3879: and p_pgm_uom is not null then
3880: --
3881: -- check if value of lookup falls within fnd_currencies.

Line 3957: l_api_updating := ben_pgm_shd.api_updating

3953: Begin
3954: --
3955: hr_utility.set_location('Entering:'||l_proc, 5);
3956: --
3957: l_api_updating := ben_pgm_shd.api_updating
3958: (p_pgm_id => p_pgm_id,
3959: p_effective_date => p_effective_date,
3960: p_object_version_number => p_object_version_number);
3961: --

Line 3964: <> ben_pgm_shd.g_old_rec.Dflt_step_rl

3960: p_object_version_number => p_object_version_number);
3961: --
3962: if (l_api_updating
3963: and nvl(p_Dflt_step_rl,hr_api.g_number)
3964: <> ben_pgm_shd.g_old_rec.Dflt_step_rl
3965: or not l_api_updating)
3966: and p_Dflt_step_rl is not null then
3967: --
3968: -- check if value of formula rule is valid.

Line 3995: <> ben_pgm_shd.g_old_rec.Scores_calc_rl

3991: end if;
3992: --
3993: if (l_api_updating
3994: and nvl(p_Scores_calc_rl,hr_api.g_number)
3995: <> ben_pgm_shd.g_old_rec.Scores_calc_rl
3996: or not l_api_updating)
3997: and p_Scores_calc_rl is not null then
3998: --
3999: -- check if value of formula rule is valid.

Line 4067: l_api_updating := ben_pgm_shd.api_updating

4063: Begin
4064: --
4065: hr_utility.set_location('Entering:'||l_proc, 5);
4066: --
4067: l_api_updating := ben_pgm_shd.api_updating
4068: (p_pgm_id => p_pgm_id,
4069: p_effective_date => p_effective_date,
4070: p_object_version_number => p_object_version_number);
4071: --

Line 4074: <> nvl(ben_pgm_shd.g_old_rec.Dflt_step_cd,hr_api.g_varchar2)

4070: p_object_version_number => p_object_version_number);
4071: --
4072: if (l_api_updating
4073: and p_Dflt_step_cd
4074: <> nvl(ben_pgm_shd.g_old_rec.Dflt_step_cd,hr_api.g_varchar2)
4075: or not l_api_updating) then
4076: --
4077: -- check if value of lookup falls within lookup type.
4078: --

Line 4102: <> nvl(ben_pgm_shd.g_old_rec.Update_salary_cd,hr_api.g_varchar2)

4098: --
4099: --
4100: if (l_api_updating
4101: and p_Update_salary_cd
4102: <> nvl(ben_pgm_shd.g_old_rec.Update_salary_cd,hr_api.g_varchar2)
4103: or not l_api_updating) then
4104: --
4105: -- check if value of lookup falls within lookup type.
4106: --

Line 4129: <> nvl(ben_pgm_shd.g_old_rec.Scores_calc_mthd_cd,hr_api.g_varchar2)

4125: end if;
4126: --
4127: if (l_api_updating
4128: and p_Scores_calc_mthd_cd
4129: <> nvl(ben_pgm_shd.g_old_rec.Scores_calc_mthd_cd,hr_api.g_varchar2)
4130: or not l_api_updating) then
4131: --
4132: -- check if value of lookup falls within lookup type.
4133: --

Line 4157: <> nvl(ben_pgm_shd.g_old_rec.salary_calc_mthd_cd,hr_api.g_varchar2)

4153: --
4154: --
4155: if (l_api_updating
4156: and p_salary_calc_mthd_cd
4157: <> nvl(ben_pgm_shd.g_old_rec.salary_calc_mthd_cd,hr_api.g_varchar2)
4158: or not l_api_updating) then
4159: --
4160: -- check if value of lookup falls within lookup type.
4161: --

Line 4226: l_api_updating := ben_pgm_shd.api_updating

4222: Begin
4223: --
4224: hr_utility.set_location('Entering:'||l_proc, 5);
4225: --
4226: l_api_updating := ben_pgm_shd.api_updating
4227: (p_pgm_id => p_pgm_id,
4228: p_effective_date => p_effective_date,
4229: p_object_version_number => p_object_version_number);
4230: --

Line 4233: <> nvl(ben_pgm_shd.g_old_rec.enrt_info_rt_freq_cd,hr_api.g_varchar2)

4229: p_object_version_number => p_object_version_number);
4230: --
4231: if (l_api_updating
4232: and p_enrt_info_rt_freq_cd
4233: <> nvl(ben_pgm_shd.g_old_rec.enrt_info_rt_freq_cd,hr_api.g_varchar2)
4234: or not l_api_updating) then
4235: --
4236: -- check if value of lookup falls within lookup type.
4237: --

Line 4297: l_api_updating := ben_pgm_shd.api_updating

4293: Begin
4294: --
4295: hr_utility.set_location('Entering:'||l_proc, 5);
4296: --
4297: l_api_updating := ben_pgm_shd.api_updating
4298: (p_pgm_id => p_pgm_id,
4299: p_effective_date => p_effective_date,
4300: p_object_version_number => p_object_version_number);
4301: --

Line 4304: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)

4300: p_object_version_number => p_object_version_number);
4301: --
4302: if (l_api_updating
4303: and p_dpnt_cvg_strt_dt_cd
4304: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4305: or not l_api_updating) then
4306: --
4307: -- check if value of lookup falls within lookup type.
4308: --

Line 4368: l_api_updating := ben_pgm_shd.api_updating

4364: Begin
4365: --
4366: hr_utility.set_location('Entering:'||l_proc, 5);
4367: --
4368: l_api_updating := ben_pgm_shd.api_updating
4369: (p_pgm_id => p_pgm_id,
4370: p_effective_date => p_effective_date,
4371: p_object_version_number => p_object_version_number);
4372: --

Line 4375: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2)

4371: p_object_version_number => p_object_version_number);
4372: --
4373: if (l_api_updating
4374: and p_dpnt_cvg_end_dt_cd
4375: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4376: or not l_api_updating) then
4377: --
4378: -- check if value of lookup falls within lookup type.
4379: --

Line 4444: l_api_updating := ben_pgm_shd.api_updating

4440: Begin
4441: --
4442: hr_utility.set_location('Entering:'||l_proc, 5);
4443: --
4444: l_api_updating := ben_pgm_shd.api_updating
4445: (p_pgm_id => p_pgm_id,
4446: p_effective_date => p_effective_date,
4447: p_object_version_number => p_object_version_number);
4448: --

Line 4451: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2) or

4447: p_object_version_number => p_object_version_number);
4448: --
4449: if (l_api_updating
4450: and (nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
4451: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4452: nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
4453: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_rl,hr_api.g_number))
4454: or not l_api_updating) then
4455: --

Line 4453: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_rl,hr_api.g_number))

4449: if (l_api_updating
4450: and (nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
4451: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4452: nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
4453: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_rl,hr_api.g_number))
4454: or not l_api_updating) then
4455: --
4456: if (p_enrt_cvg_strt_dt_cd = 'RL' and p_enrt_cvg_strt_dt_rl is null) then
4457: --

Line 4520: l_api_updating := ben_pgm_shd.api_updating

4516: Begin
4517: --
4518: hr_utility.set_location('Entering:'||l_proc, 5);
4519: --
4520: l_api_updating := ben_pgm_shd.api_updating
4521: (p_pgm_id => p_pgm_id,
4522: p_effective_date => p_effective_date,
4523: p_object_version_number => p_object_version_number);
4524: --

Line 4528: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2) or

4524: --
4525: if (l_api_updating
4526: and
4527: (nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2)
4528: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2) or
4529: nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
4530: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_rl,hr_api.g_number))
4531: or not l_api_updating) then
4532: --

Line 4530: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_rl,hr_api.g_number))

4526: and
4527: (nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2)
4528: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2) or
4529: nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
4530: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_rl,hr_api.g_number))
4531: or not l_api_updating) then
4532: --
4533: if (p_enrt_cvg_end_dt_cd = 'RL' and p_enrt_cvg_end_dt_rl is null) then
4534: --

Line 4596: l_api_updating := ben_pgm_shd.api_updating

4592: Begin
4593: --
4594: hr_utility.set_location('Entering:'||l_proc, 5);
4595: --
4596: l_api_updating := ben_pgm_shd.api_updating
4597: (p_pgm_id => p_pgm_id,
4598: p_effective_date => p_effective_date,
4599: p_object_version_number => p_object_version_number);
4600: --

Line 4604: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or

4600: --
4601: if (l_api_updating
4602: and
4603: (nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4604: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4605: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4606: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number))
4607: or not l_api_updating) then
4608: --

Line 4606: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number))

4602: and
4603: (nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4604: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4605: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4606: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number))
4607: or not l_api_updating) then
4608: --
4609: if (p_dpnt_cvg_strt_dt_cd = 'RL' and p_dpnt_cvg_strt_dt_rl is null) then
4610: --

Line 4671: l_api_updating := ben_pgm_shd.api_updating

4667: Begin
4668: --
4669: hr_utility.set_location('Entering:'||l_proc, 5);
4670: --
4671: l_api_updating := ben_pgm_shd.api_updating
4672: (p_pgm_id => p_pgm_id,
4673: p_effective_date => p_effective_date,
4674: p_object_version_number => p_object_version_number);
4675: --

Line 4679: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or

4675: --
4676: if (l_api_updating
4677: and
4678: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4679: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4680: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4681: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number))
4682: or not l_api_updating) then
4683: --

Line 4681: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number))

4677: and
4678: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4679: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4680: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4681: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number))
4682: or not l_api_updating) then
4683: --
4684: if (p_dpnt_cvg_end_dt_cd = 'RL' and p_dpnt_cvg_end_dt_rl is null) then
4685: --

Line 4763: l_api_updating := ben_pgm_shd.api_updating

4759: Begin
4760: --
4761: hr_utility.set_location('Entering:'||l_proc, 5);
4762: --
4763: l_api_updating := ben_pgm_shd.api_updating
4764: (p_pgm_id => p_pgm_id,
4765: p_effective_date => p_effective_date,
4766: p_object_version_number => p_object_version_number);
4767: --

Line 4771: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or

4767: --
4768: if (l_api_updating
4769: and
4770: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4771: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4772: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4773: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
4774: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or

Line 4773: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or

4769: and
4770: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4771: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4772: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4773: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
4774: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4776: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or

Line 4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or

4771: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4772: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4773: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
4774: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4776: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4778: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or

Line 4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or

4773: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
4774: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4776: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4778: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
4780: nvl(p_dpnt_adrs_rqd_flag,hr_api.g_varchar2)
4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or

Line 4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or

4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4776: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4778: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
4780: nvl(p_dpnt_adrs_rqd_flag,hr_api.g_varchar2)
4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or
4782: nvl(p_dpnt_dob_rqd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or

Line 4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or

4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4778: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
4780: nvl(p_dpnt_adrs_rqd_flag,hr_api.g_varchar2)
4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or
4782: nvl(p_dpnt_dob_rqd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or
4784: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or

Line 4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or

4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
4780: nvl(p_dpnt_adrs_rqd_flag,hr_api.g_varchar2)
4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or
4782: nvl(p_dpnt_dob_rqd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or
4784: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
4786: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
4787: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or

Line 4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or

4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or
4782: nvl(p_dpnt_dob_rqd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or
4784: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
4786: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
4787: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
4788: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
4789: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)) or

Line 4787: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or

4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or
4784: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
4786: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
4787: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
4788: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
4789: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)) or
4790: not l_api_updating) then
4791: --

Line 4789: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)) or

4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
4786: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
4787: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
4788: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
4789: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)) or
4790: not l_api_updating) then
4791: --
4792: if nvl(p_dpnt_dsgn_cd,'X') not in ('R','O') and
4793: (p_dpnt_cvg_strt_dt_cd is not null or

Line 4868: l_api_updating := ben_pgm_shd.api_updating

4864: Begin
4865: --
4866: hr_utility.set_location('Entering:'||l_proc, 5);
4867: --
4868: l_api_updating := ben_pgm_shd.api_updating
4869: (p_pgm_id => p_pgm_id,
4870: p_effective_date => p_effective_date,
4871: p_object_version_number => p_object_version_number);
4872: --

Line 4876: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_auto_enrt_flag,hr_api.g_varchar2)

4872: --
4873:
4874: if (l_api_updating
4875: and nvl(p_pgm_prvds_no_auto_enrt_flag,hr_api.g_varchar2)
4876: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_auto_enrt_flag,hr_api.g_varchar2)
4877: or not l_api_updating) then
4878: --
4879: -- If pgm provides no auto enroll flag = 'Y' then enrt mthd code can't be 'A'.
4880: --

Line 4956: l_api_updating := ben_pgm_shd.api_updating

4952: Begin
4953: --
4954: hr_utility.set_location('Entering:'||l_proc, 5);
4955: --
4956: l_api_updating := ben_pgm_shd.api_updating
4957: (p_pgm_id => p_pgm_id,
4958: p_effective_date => p_effective_date,
4959: p_object_version_number => p_object_version_number);
4960: --

Line 4964: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)

4960: --
4961:
4962: if (l_api_updating
4963: and nvl(p_pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)
4964: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)
4965: or not l_api_updating) then
4966: --
4967: -- If pgm provides no dflt enroll flag = 'Y' dflt fields must be null.
4968: --

Line 5048: l_api_updating := ben_pgm_shd.api_updating

5044: Begin
5045: --
5046: hr_utility.set_location('Entering:'||l_proc, 5);
5047: --
5048: l_api_updating := ben_pgm_shd.api_updating
5049: (p_pgm_id => p_pgm_id,
5050: p_effective_date => p_effective_date,
5051: p_object_version_number => p_object_version_number);
5052: --

Line 5056: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)

5052: --
5053:
5054: if (l_api_updating
5055: and nvl(p_pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)
5056: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)
5057: or not l_api_updating) then
5058: --
5059: -- If cursor is found then at least one dflt num was found.
5060: --

Line 5142: l_api_updating := ben_pgm_shd.api_updating

5138: Begin
5139: --
5140: hr_utility.set_location('Entering:'||l_proc, 5);
5141: --
5142: l_api_updating := ben_pgm_shd.api_updating
5143: (p_pgm_id => p_pgm_id,
5144: p_effective_date => p_effective_date,
5145: p_object_version_number => p_object_version_number);
5146: --

Line 5150: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or

5146: --
5147: if (l_api_updating
5148: and
5149: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
5150: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
5151: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
5152: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
5153: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or

Line 5152: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or

5148: and
5149: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
5150: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
5151: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
5152: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
5153: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
5155: nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or

Line 5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or

5150: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
5151: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
5152: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
5153: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
5155: nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or
5157: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or

Line 5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or

5152: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
5153: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
5155: nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or
5157: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
5159: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or

Line 5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or

5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
5155: nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or
5157: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
5159: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
5161: nvl(p_dpnt_adrs_rqd_flag ,hr_api.g_varchar2)
5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or

Line 5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or

5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or
5157: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
5159: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
5161: nvl(p_dpnt_adrs_rqd_flag ,hr_api.g_varchar2)
5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or
5163: nvl(p_dpnt_dob_rqd_flag ,hr_api.g_varchar2)
5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or

Line 5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or

5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
5159: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
5161: nvl(p_dpnt_adrs_rqd_flag ,hr_api.g_varchar2)
5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or
5163: nvl(p_dpnt_dob_rqd_flag ,hr_api.g_varchar2)
5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or
5165: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or

Line 5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or

5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
5161: nvl(p_dpnt_adrs_rqd_flag ,hr_api.g_varchar2)
5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or
5163: nvl(p_dpnt_dob_rqd_flag ,hr_api.g_varchar2)
5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or
5165: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
5167: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
5168: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or

Line 5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or

5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or
5163: nvl(p_dpnt_dob_rqd_flag ,hr_api.g_varchar2)
5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or
5165: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
5167: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
5168: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
5169: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
5170: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2) or

Line 5168: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or

5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or
5165: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
5167: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
5168: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
5169: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
5170: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2) or
5171: not l_api_updating)) then
5172: --

Line 5170: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2) or

5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
5167: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
5168: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
5169: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
5170: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2) or
5171: not l_api_updating)) then
5172: --
5173: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PGM') and
5174: (p_dpnt_dsgn_cd is not null or

Line 5266: l_api_updating := ben_pgm_shd.api_updating

5262: Begin
5263: --
5264: hr_utility.set_location('Entering:'||l_proc, 5);
5265: --
5266: l_api_updating := ben_pgm_shd.api_updating
5267: (p_pgm_id => p_pgm_id,
5268: p_effective_date => p_effective_date,
5269: p_object_version_number => p_object_version_number);
5270: --

Line 5274: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2)

5270: --
5271:
5272: if (l_api_updating
5273: and nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5274: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2)
5275: or not l_api_updating) then
5276: null;
5277: --
5278: -- If ldc records exists and designation is null then error

Line 5404: l_api_updating := ben_pgm_shd.api_updating

5400: Begin
5401: --
5402: hr_utility.set_location('Entering:'||l_proc, 5);
5403: --
5404: l_api_updating := ben_pgm_shd.api_updating
5405: (p_pgm_id => p_pgm_id,
5406: p_effective_date => p_effective_date,
5407: p_object_version_number => p_object_version_number);
5408: --

Line 5412: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)

5408: --
5409:
5410: if (l_api_updating
5411: and nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5412: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5413: or not l_api_updating) then
5414: null;
5415: --
5416: -- If ldc records exists and designation level not 'PGM' then error

Line 5529: l_api_updating := ben_pgm_shd.api_updating

5525: Begin
5526: --
5527: hr_utility.set_location('Entering:'||l_proc, 5);
5528: --
5529: l_api_updating := ben_pgm_shd.api_updating
5530: (p_pgm_id => p_pgm_id,
5531: p_effective_date => p_effective_date,
5532: p_object_version_number => p_object_version_number);
5533: --

Line 5537: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)

5533: --
5534:
5535: if (l_api_updating
5536: and nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5537: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5538: or not l_api_updating) then
5539: --
5540: -- If dsgn_lvl not = PTIP and cursor found then error.
5541: --

Line 5642: l_api_updating := ben_pgm_shd.api_updating

5638: Begin
5639: --
5640: hr_utility.set_location('Entering:'||l_proc, 5);
5641: --
5642: l_api_updating := ben_pgm_shd.api_updating
5643: (p_pgm_id => p_pgm_id,
5644: p_effective_date => p_effective_date,
5645: p_object_version_number => p_object_version_number);
5646: --

Line 5650: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)

5646: --
5647:
5648: if (l_api_updating
5649: and nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5650: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5651: or not l_api_updating) then null;
5652: --
5653: -- If ldc records exists and designation level not 'PTIP' then error
5654: --

Line 5750: l_api_updating := ben_pgm_shd.api_updating

5746: --
5747: hr_utility.set_location('Entering:'||l_proc, 5);
5748:
5749: --
5750: l_api_updating := ben_pgm_shd.api_updating
5751: (p_pgm_id => p_pgm_id,
5752: p_effective_date => p_effective_date,
5753: p_object_version_number => p_object_version_number);
5754: --

Line 5757: p_enrt_cd <> nvl(ben_pgm_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

5753: p_object_version_number => p_object_version_number);
5754: --
5755: if (l_api_updating
5756: and (
5757: p_enrt_cd <> nvl(ben_pgm_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
5758: or p_pgm_typ_cd <> nvl(ben_pgm_shd.g_old_rec.pgm_typ_cd,hr_api.g_varchar2)
5759: )
5760: or not l_api_updating)
5761: and p_enrt_cd is not null then

Line 5758: or p_pgm_typ_cd <> nvl(ben_pgm_shd.g_old_rec.pgm_typ_cd,hr_api.g_varchar2)

5754: --
5755: if (l_api_updating
5756: and (
5757: p_enrt_cd <> nvl(ben_pgm_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
5758: or p_pgm_typ_cd <> nvl(ben_pgm_shd.g_old_rec.pgm_typ_cd,hr_api.g_varchar2)
5759: )
5760: or not l_api_updating)
5761: and p_enrt_cd is not null then
5762: --

Line 6218: (p_rec in ben_pgm_shd.g_rec_type,

6214: -- ----------------------------------------------------------------------------
6215: -- |---------------------------< insert_validate >----------------------------|
6216: -- ----------------------------------------------------------------------------
6217: Procedure insert_validate
6218: (p_rec in ben_pgm_shd.g_rec_type,
6219: p_effective_date in date,
6220: p_datetrack_mode in varchar2,
6221: p_validation_start_date in date,
6222: p_validation_end_date in date) is

Line 6726: (p_rec in ben_pgm_shd.g_rec_type,

6722: -- ----------------------------------------------------------------------------
6723: -- |---------------------------< update_validate >----------------------------|
6724: -- ----------------------------------------------------------------------------
6725: Procedure update_validate
6726: (p_rec in ben_pgm_shd.g_rec_type,
6727: p_effective_date in date,
6728: p_datetrack_mode in varchar2,
6729: p_validation_start_date in date,
6730: p_validation_end_date in date) is

Line 7240: (p_rec in ben_pgm_shd.g_rec_type,

7236: -- ----------------------------------------------------------------------------
7237: -- |---------------------------< delete_validate >----------------------------|
7238: -- ----------------------------------------------------------------------------
7239: Procedure delete_validate
7240: (p_rec in ben_pgm_shd.g_rec_type,
7241: p_effective_date in date,
7242: p_datetrack_mode in varchar2,
7243: p_validation_start_date in date,
7244: p_validation_end_date in date) is