DBA Data[Home] [Help]

APPS.BEN_BPP_BUS dependencies on BEN_BPP_SHD

Line 48: l_api_updating := ben_bpp_shd.api_updating

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

Line 55: <> ben_bpp_shd.g_old_rec.bnft_prvdr_pool_id) then

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

Line 59: ben_bpp_shd.constraint_error('BEN_BNFT_PRVDR_POOL_PK');

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

Line 69: ben_bpp_shd.constraint_error('BEN_BNFT_PRVDR_POOL_PK');

65: if p_bnft_prvdr_pool_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_bpp_shd.constraint_error('BEN_BNFT_PRVDR_POOL_PK');
70: --
71: end if;
72: --
73: end if;

Line 128: l_api_updating := ben_bpp_shd.api_updating

124: --
125: Begin
126: hr_utility.set_location('Entering:'||l_proc, 5);
127: --
128: l_api_updating := ben_bpp_shd.api_updating
129: (p_effective_date => p_effective_date,
130: p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
131: p_object_version_number => p_object_version_number);
132: --

Line 192: l_api_updating := ben_bpp_shd.api_updating

188: Begin
189: --
190: hr_utility.set_location('Entering:'||l_proc, 5);
191: --
192: l_api_updating := ben_bpp_shd.api_updating
193: (p_effective_date => p_effective_date,
194: p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
195: p_object_version_number => p_object_version_number);
196: --

Line 253: l_api_updating := ben_bpp_shd.api_updating

249: Begin
250: --
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: l_api_updating := ben_bpp_shd.api_updating
254: (p_effective_date => p_effective_date,
255: p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
256: p_object_version_number => p_object_version_number);
257: --

Line 314: l_api_updating := ben_bpp_shd.api_updating

310: Begin
311: --
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: l_api_updating := ben_bpp_shd.api_updating
315: (p_effective_date => p_effective_date,
316: p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
317: p_object_version_number => p_object_version_number);
318: --

Line 375: l_api_updating := ben_bpp_shd.api_updating

371: Begin
372: --
373: hr_utility.set_location('Entering:'||l_proc, 5);
374: --
375: l_api_updating := ben_bpp_shd.api_updating
376: (p_effective_date => p_effective_date,
377: p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
378: p_object_version_number => p_object_version_number);
379: --

Line 437: l_api_updating := ben_bpp_shd.api_updating

433: Begin
434: --
435: hr_utility.set_location('Entering:'||l_proc, 5);
436: --
437: l_api_updating := ben_bpp_shd.api_updating
438: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
439: p_effective_date => p_effective_date,
440: p_object_version_number => p_object_version_number);
441: --

Line 445: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or

441: --
442: if (l_api_updating
443: and
444: (nvl(p_pct_rndg_cd,hr_api.g_varchar2)
445: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or
446: nvl(p_pct_rndg_rl,hr_api.g_number)
447: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))
448: or not l_api_updating) then
449: --

Line 447: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))

443: and
444: (nvl(p_pct_rndg_cd,hr_api.g_varchar2)
445: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or
446: nvl(p_pct_rndg_rl,hr_api.g_number)
447: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))
448: or not l_api_updating) then
449: --
450: if (p_pct_rndg_cd = 'RL' and p_pct_rndg_rl is null) then
451: --

Line 513: l_api_updating := ben_bpp_shd.api_updating

509: Begin
510: --
511: hr_utility.set_location('Entering:'||l_proc, 5);
512: --
513: l_api_updating := ben_bpp_shd.api_updating
514: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
515: p_effective_date => p_effective_date,
516: p_object_version_number => p_object_version_number);
517: --

Line 521: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or

517: --
518: if (l_api_updating
519: and
520: (nvl(p_val_rndg_cd,hr_api.g_varchar2)
521: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or
522: nvl(p_val_rndg_rl,hr_api.g_number)
523: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_rl,hr_api.g_number))
524: or not l_api_updating) then
525: --

Line 523: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_rl,hr_api.g_number))

519: and
520: (nvl(p_val_rndg_cd,hr_api.g_varchar2)
521: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or
522: nvl(p_val_rndg_rl,hr_api.g_number)
523: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_rl,hr_api.g_number))
524: or not l_api_updating) then
525: --
526: if (p_val_rndg_cd = 'RL' and p_val_rndg_rl is null) then
527: --

Line 601: l_api_updating := ben_bpp_shd.api_updating

597: Begin
598: --
599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: l_api_updating := ben_bpp_shd.api_updating
602: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
603: p_effective_date => p_effective_date,
604: p_object_version_number => p_object_version_number);
605: --

Line 608: <> ben_bpp_shd.g_old_rec.val_rndg_rl

604: p_object_version_number => p_object_version_number);
605: --
606: if (l_api_updating
607: and nvl(p_val_rndg_rl,hr_api.g_number)
608: <> ben_bpp_shd.g_old_rec.val_rndg_rl
609: or not l_api_updating)
610: and p_val_rndg_rl is not null then
611: --
612: -- check if value of formula rule is valid.

Line 679: l_api_updating := ben_bpp_shd.api_updating

675: Begin
676: --
677: hr_utility.set_location('Entering:'||l_proc, 5);
678: --
679: l_api_updating := ben_bpp_shd.api_updating
680: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
681: p_effective_date => p_effective_date,
682: p_object_version_number => p_object_version_number);
683: --

Line 686: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2)

682: p_object_version_number => p_object_version_number);
683: --
684: if (l_api_updating
685: and p_val_rndg_cd
686: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2)
687: or not l_api_updating)
688: and p_val_rndg_cd is not null then
689: --
690: -- check if value of lookup falls within lookup type.

Line 767: l_api_updating := ben_bpp_shd.api_updating

763: Begin
764: --
765: hr_utility.set_location('Entering:'||l_proc, 5);
766: --
767: l_api_updating := ben_bpp_shd.api_updating
768: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
769: p_effective_date => p_effective_date,
770: p_object_version_number => p_object_version_number);
771: --

Line 774: <> ben_bpp_shd.g_old_rec.pct_rndg_rl

770: p_object_version_number => p_object_version_number);
771: --
772: if (l_api_updating
773: and nvl(p_pct_rndg_rl,hr_api.g_number)
774: <> ben_bpp_shd.g_old_rec.pct_rndg_rl
775: or not l_api_updating)
776: and p_pct_rndg_rl is not null then
777: --
778: -- check if value of formula rule is valid.

Line 845: l_api_updating := ben_bpp_shd.api_updating

841: Begin
842: --
843: hr_utility.set_location('Entering:'||l_proc, 5);
844: --
845: l_api_updating := ben_bpp_shd.api_updating
846: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
847: p_effective_date => p_effective_date,
848: p_object_version_number => p_object_version_number);
849: --

Line 852: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2)

848: p_object_version_number => p_object_version_number);
849: --
850: if (l_api_updating
851: and p_pct_rndg_cd
852: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2)
853: or not l_api_updating)
854: and p_pct_rndg_cd is not null then
855: --
856: -- check if value of lookup falls within lookup type.

Line 916: l_api_updating := ben_bpp_shd.api_updating

912: Begin
913: --
914: hr_utility.set_location('Entering:'||l_proc, 5);
915: --
916: l_api_updating := ben_bpp_shd.api_updating
917: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
918: p_effective_date => p_effective_date,
919: p_object_version_number => p_object_version_number);
920: --

Line 923: <> nvl(ben_bpp_shd.g_old_rec.pgm_pool_flag,hr_api.g_varchar2)

919: p_object_version_number => p_object_version_number);
920: --
921: if (l_api_updating
922: and p_pgm_pool_flag
923: <> nvl(ben_bpp_shd.g_old_rec.pgm_pool_flag,hr_api.g_varchar2)
924: or not l_api_updating) then
925: --
926: -- check if value of lookup falls within lookup type.
927: --

Line 985: l_api_updating := ben_bpp_shd.api_updating

981: Begin
982: --
983: hr_utility.set_location('Entering:'||l_proc, 5);
984: --
985: l_api_updating := ben_bpp_shd.api_updating
986: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
987: p_effective_date => p_effective_date,
988: p_object_version_number => p_object_version_number);
989: --

Line 992: <> nvl(ben_bpp_shd.g_old_rec.no_mn_dstrbl_pct_flag,hr_api.g_varchar2)

988: p_object_version_number => p_object_version_number);
989: --
990: if (l_api_updating
991: and p_no_mn_dstrbl_pct_flag
992: <> nvl(ben_bpp_shd.g_old_rec.no_mn_dstrbl_pct_flag,hr_api.g_varchar2)
993: or not l_api_updating) then
994: --
995: -- check if value of lookup falls within lookup type.
996: --

Line 1054: l_api_updating := ben_bpp_shd.api_updating

1050: Begin
1051: --
1052: hr_utility.set_location('Entering:'||l_proc, 5);
1053: --
1054: l_api_updating := ben_bpp_shd.api_updating
1055: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1056: p_effective_date => p_effective_date,
1057: p_object_version_number => p_object_version_number);
1058: --

Line 1061: <> nvl(ben_bpp_shd.g_old_rec.no_mx_dstrbl_pct_flag,hr_api.g_varchar2)

1057: p_object_version_number => p_object_version_number);
1058: --
1059: if (l_api_updating
1060: and p_no_mx_dstrbl_pct_flag
1061: <> nvl(ben_bpp_shd.g_old_rec.no_mx_dstrbl_pct_flag,hr_api.g_varchar2)
1062: or not l_api_updating) then
1063: --
1064: -- check if value of lookup falls within lookup type.
1065: --

Line 1123: l_api_updating := ben_bpp_shd.api_updating

1119: Begin
1120: --
1121: hr_utility.set_location('Entering:'||l_proc, 5);
1122: --
1123: l_api_updating := ben_bpp_shd.api_updating
1124: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1125: p_effective_date => p_effective_date,
1126: p_object_version_number => p_object_version_number);
1127: --

Line 1130: <> nvl(ben_bpp_shd.g_old_rec.no_mn_dstrbl_val_flag,hr_api.g_varchar2)

1126: p_object_version_number => p_object_version_number);
1127: --
1128: if (l_api_updating
1129: and p_no_mn_dstrbl_val_flag
1130: <> nvl(ben_bpp_shd.g_old_rec.no_mn_dstrbl_val_flag,hr_api.g_varchar2)
1131: or not l_api_updating) then
1132: --
1133: -- check if value of lookup falls within lookup type.
1134: --

Line 1192: l_api_updating := ben_bpp_shd.api_updating

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

Line 1199: <> nvl(ben_bpp_shd.g_old_rec.no_mx_dstrbl_val_flag,hr_api.g_varchar2)

1195: p_object_version_number => p_object_version_number);
1196: --
1197: if (l_api_updating
1198: and p_no_mx_dstrbl_val_flag
1199: <> nvl(ben_bpp_shd.g_old_rec.no_mx_dstrbl_val_flag,hr_api.g_varchar2)
1200: or not l_api_updating) then
1201: --
1202: -- check if value of lookup falls within lookup type.
1203: --

Line 1261: l_api_updating := ben_bpp_shd.api_updating

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

Line 1270: <> nvl(ben_bpp_shd.g_old_rec.auto_alct_excs_flag,hr_api.g_varchar2)

1266: hr_utility.set_location('auto_alct_excs_flag:'||p_auto_alct_excs_flag, 5);
1267: --
1268: if (l_api_updating
1269: and p_auto_alct_excs_flag
1270: <> nvl(ben_bpp_shd.g_old_rec.auto_alct_excs_flag,hr_api.g_varchar2)
1271: or not l_api_updating) then
1272: --
1273: -- check if value of lookup falls within lookup type.
1274: --

Line 1341: l_api_updating := ben_bpp_shd.api_updating

1337: Begin
1338: --
1339: hr_utility.set_location('Entering:'||l_proc,5);
1340: --
1341: l_api_updating := ben_bpp_shd.api_updating
1342: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1343: p_effective_date => p_effective_date,
1344: p_object_version_number => p_object_version_number);
1345: --

Line 1348: <> nvl(ben_bpp_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)

1344: p_object_version_number => p_object_version_number);
1345: --
1346: if (l_api_updating
1347: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
1348: <> nvl(ben_bpp_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
1349: or not l_api_updating)
1350: and p_comp_lvl_fctr_id is not null then
1351: --
1352: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table

Line 1368: ben_bpp_shd.constraint_error('BEN_BNFT_PRVDR_POOL_F_FK2');

1364: --
1365: -- raise error as FK does not relate to PK in ben_comp_lvl_fctr
1366: -- table.
1367: --
1368: ben_bpp_shd.constraint_error('BEN_BNFT_PRVDR_POOL_F_FK2');
1369: --
1370: end if;
1371: --
1372: close c1;

Line 1422: l_api_updating := ben_bpp_shd.api_updating

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

Line 1429: <> nvl(ben_bpp_shd.g_old_rec.alws_ngtv_crs_flag,hr_api.g_varchar2)

1425: p_object_version_number => p_object_version_number);
1426: --
1427: if (l_api_updating
1428: and p_alws_ngtv_crs_flag
1429: <> nvl(ben_bpp_shd.g_old_rec.alws_ngtv_crs_flag,hr_api.g_varchar2)
1430: or not l_api_updating) then
1431: --
1432: -- check if value of lookup falls within lookup type.
1433: --

Line 1508: l_api_updating := ben_bpp_shd.api_updating

1504: Begin
1505: --
1506: hr_utility.set_location('Entering:'||l_proc, 5);
1507: --
1508: l_api_updating := ben_bpp_shd.api_updating
1509: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1510: p_effective_date => p_effective_date,
1511: p_object_version_number => p_object_version_number);
1512: --

Line 1515: <> nvl(ben_bpp_shd.g_old_rec.uses_net_crs_mthd_flag,hr_api.g_varchar2)

1511: p_object_version_number => p_object_version_number);
1512: --
1513: if (l_api_updating
1514: and p_uses_net_crs_mthd_flag
1515: <> nvl(ben_bpp_shd.g_old_rec.uses_net_crs_mthd_flag,hr_api.g_varchar2)
1516: or not l_api_updating) then
1517: --
1518: -- check if value of lookup falls within lookup type.
1519: --

Line 1596: l_api_updating := ben_bpp_shd.api_updating

1592: Begin
1593: --
1594: hr_utility.set_location('Entering:'||l_proc, 5);
1595: --
1596: l_api_updating := ben_bpp_shd.api_updating
1597: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1598: p_effective_date => p_effective_date,
1599: p_object_version_number => p_object_version_number);
1600: --

Line 1603: <> nvl(ben_bpp_shd.g_old_rec.excs_trtmt_cd,hr_api.g_varchar2)

1599: p_object_version_number => p_object_version_number);
1600: --
1601: if (l_api_updating
1602: and p_excs_trtmt_cd
1603: <> nvl(ben_bpp_shd.g_old_rec.excs_trtmt_cd,hr_api.g_varchar2)
1604: or not l_api_updating)
1605: and p_excs_trtmt_cd is not null then
1606: --
1607: -- check if value of lookup falls within lookup type.

Line 1669: l_api_updating := ben_bpp_shd.api_updating

1665: Begin
1666: --
1667: hr_utility.set_location('Entering:'||l_proc, 5);
1668: --
1669: l_api_updating := ben_bpp_shd.api_updating
1670: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1671: p_effective_date => p_effective_date,
1672: p_object_version_number => p_object_version_number);
1673: --

Line 1676: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd,hr_api.g_varchar2)

1672: p_object_version_number => p_object_version_number);
1673: --
1674: if (l_api_updating
1675: and p_dflt_excs_trtmt_cd
1676: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd,hr_api.g_varchar2)
1677: or not l_api_updating)
1678: and p_dflt_excs_trtmt_cd is not null then
1679: --
1680: -- check if value of lookup falls within lookup type.

Line 1758: l_api_updating := ben_bpp_shd.api_updating

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

Line 1765: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl,hr_api.g_number)

1761: p_object_version_number => p_object_version_number);
1762: --
1763: if (l_api_updating
1764: and p_dflt_excs_trtmt_rl
1765: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl,hr_api.g_number)
1766: or not l_api_updating)
1767: and p_dflt_excs_trtmt_rl is not null then
1768: --
1769: -- check if value of rule id is valid.

Line 1842: l_api_updating := ben_bpp_shd.api_updating

1838: Begin
1839: --
1840: hr_utility.set_location('Entering:'||l_proc, 5);
1841: --
1842: l_api_updating := ben_bpp_shd.api_updating
1843: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1844: p_effective_date => p_effective_date,
1845: p_object_version_number => p_object_version_number);
1846: --

Line 1850: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd,hr_api.g_varchar2) or

1846: --
1847: if (l_api_updating
1848: and
1849: (nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2)
1850: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd,hr_api.g_varchar2) or
1851: nvl(p_dflt_excs_trtmt_rl,hr_api.g_number)
1852: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl,hr_api.g_number))
1853: or not l_api_updating) then
1854: --

Line 1852: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl,hr_api.g_number))

1848: and
1849: (nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2)
1850: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd,hr_api.g_varchar2) or
1851: nvl(p_dflt_excs_trtmt_rl,hr_api.g_number)
1852: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl,hr_api.g_number))
1853: or not l_api_updating) then
1854: --
1855: if (p_dflt_excs_trtmt_cd = 'RL' and p_dflt_excs_trtmt_rl is null) then
1856: --

Line 2175: (p_rec in ben_bpp_shd.g_rec_type,

2171: -- ----------------------------------------------------------------------------
2172: -- |---------------------------< insert_validate >----------------------------|
2173: -- ----------------------------------------------------------------------------
2174: Procedure insert_validate
2175: (p_rec in ben_bpp_shd.g_rec_type,
2176: p_effective_date in date,
2177: p_datetrack_mode in varchar2,
2178: p_validation_start_date in date,
2179: p_validation_end_date in date) is

Line 2374: (p_rec in ben_bpp_shd.g_rec_type,

2370: -- ----------------------------------------------------------------------------
2371: -- |---------------------------< update_validate >----------------------------|
2372: -- ----------------------------------------------------------------------------
2373: Procedure update_validate
2374: (p_rec in ben_bpp_shd.g_rec_type,
2375: p_effective_date in date,
2376: p_datetrack_mode in varchar2,
2377: p_validation_start_date in date,
2378: p_validation_end_date in date) is

Line 2589: (p_rec in ben_bpp_shd.g_rec_type,

2585: -- ----------------------------------------------------------------------------
2586: -- |---------------------------< delete_validate >----------------------------|
2587: -- ----------------------------------------------------------------------------
2588: Procedure delete_validate
2589: (p_rec in ben_bpp_shd.g_rec_type,
2590: p_effective_date in date,
2591: p_datetrack_mode in varchar2,
2592: p_validation_start_date in date,
2593: p_validation_end_date in date) is