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_BPR_BUS dependencies on BEN_BPR_SHD

Line 48: l_api_updating := ben_bpr_shd.api_updating

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

Line 55: <> ben_bpr_shd.g_old_rec.bnft_pool_rlovr_rqmt_id) then

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

Line 59: ben_bpr_shd.constraint_error('BEN_BNFT_POOL_RLOVR_RQMT_PK');

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

Line 69: ben_bpr_shd.constraint_error('BEN_BNFT_POOL_RLOVR_RQMT_PK');

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

Line 121: l_api_updating := ben_bpr_shd.api_updating

117: Begin
118: --
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: --
121: l_api_updating := ben_bpr_shd.api_updating
122: (p_effective_date => p_effective_date,
123: p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
124: p_object_version_number => p_object_version_number);
125: --

Line 182: l_api_updating := ben_bpr_shd.api_updating

178: Begin
179: --
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: l_api_updating := ben_bpr_shd.api_updating
183: (p_effective_date => p_effective_date,
184: p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
185: p_object_version_number => p_object_version_number);
186: --

Line 243: l_api_updating := ben_bpr_shd.api_updating

239: Begin
240: --
241: hr_utility.set_location('Entering:'||l_proc, 5);
242: --
243: l_api_updating := ben_bpr_shd.api_updating
244: (p_effective_date => p_effective_date,
245: p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
246: p_object_version_number => p_object_version_number);
247: --

Line 304: l_api_updating := ben_bpr_shd.api_updating

300: Begin
301: --
302: hr_utility.set_location('Entering:'||l_proc, 5);
303: --
304: l_api_updating := ben_bpr_shd.api_updating
305: (p_effective_date => p_effective_date,
306: p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
307: p_object_version_number => p_object_version_number);
308: --

Line 366: l_api_updating := ben_bpr_shd.api_updating

362: Begin
363: --
364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: l_api_updating := ben_bpr_shd.api_updating
367: (p_effective_date => p_effective_date,
368: p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
369: p_object_version_number => p_object_version_number);
370: --

Line 374: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or

370: --
371: if (l_api_updating
372: and
373: (nvl(p_pct_rndg_cd,hr_api.g_varchar2)
374: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or
375: nvl(p_pct_rndg_rl,hr_api.g_number)
376: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))
377: or not l_api_updating) then
378: --

Line 376: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))

372: and
373: (nvl(p_pct_rndg_cd,hr_api.g_varchar2)
374: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or
375: nvl(p_pct_rndg_rl,hr_api.g_number)
376: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))
377: or not l_api_updating) then
378: --
379: if (p_pct_rndg_cd = 'RL' and p_pct_rndg_rl is null) then
380: --

Line 442: l_api_updating := ben_bpr_shd.api_updating

438: Begin
439: --
440: hr_utility.set_location('Entering:'||l_proc, 5);
441: --
442: l_api_updating := ben_bpr_shd.api_updating
443: (p_effective_date => p_effective_date,
444: p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
445: p_object_version_number => p_object_version_number);
446: --

Line 450: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or

446: --
447: if (l_api_updating
448: and
449: (nvl(p_val_rndg_cd,hr_api.g_varchar2)
450: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or
451: nvl(p_val_rndg_rl,hr_api.g_number)
452: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_rl,hr_api.g_number))
453: or not l_api_updating) then
454: --

Line 452: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_rl,hr_api.g_number))

448: and
449: (nvl(p_val_rndg_cd,hr_api.g_varchar2)
450: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or
451: nvl(p_val_rndg_rl,hr_api.g_number)
452: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_rl,hr_api.g_number))
453: or not l_api_updating) then
454: --
455: if (p_val_rndg_cd = 'RL' and p_val_rndg_rl is null) then
456: --

Line 513: l_api_updating := ben_bpr_shd.api_updating

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

Line 520: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2)

516: p_object_version_number => p_object_version_number);
517: --
518: if (l_api_updating
519: and p_pct_rndg_cd
520: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2)
521: or not l_api_updating)
522: and p_pct_rndg_cd is not null then
523: --
524: -- check if value of lookup falls within lookup type.

Line 601: l_api_updating := ben_bpr_shd.api_updating

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

Line 608: <> ben_bpr_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_bpr_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_bpr_shd.api_updating

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

Line 686: <> nvl(ben_bpr_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_bpr_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 750: l_api_updating := ben_bpr_shd.api_updating

746: Begin
747: --
748: hr_utility.set_location('Entering:'||l_proc, 5);
749: --
750: l_api_updating := ben_bpr_shd.api_updating
751: (p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
752: p_effective_date => p_effective_date,
753: p_object_version_number => p_object_version_number);
754: --

Line 757: <> nvl(ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag,hr_api.g_varchar2)

753: p_object_version_number => p_object_version_number);
754: --
755: if (l_api_updating
756: and p_no_mx_rlovr_val_dfnd_flag
757: <> nvl(ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag,hr_api.g_varchar2)
758: or not l_api_updating) then
759: --
760: -- check if value of lookup falls within lookup type.
761: --

Line 836: l_api_updating := ben_bpr_shd.api_updating

832: Begin
833: --
834: hr_utility.set_location('Entering:'||l_proc, 5);
835: --
836: l_api_updating := ben_bpr_shd.api_updating
837: (p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
838: p_effective_date => p_effective_date,
839: p_object_version_number => p_object_version_number);
840: --

Line 843: <> ben_bpr_shd.g_old_rec.rlovr_val_rl

839: p_object_version_number => p_object_version_number);
840: --
841: if (l_api_updating
842: and nvl(p_rlovr_val_rl,hr_api.g_number)
843: <> ben_bpr_shd.g_old_rec.rlovr_val_rl
844: or not l_api_updating)
845: and p_rlovr_val_rl is not null then
846: --
847: -- check if value of formula rule is valid.

Line 915: l_api_updating := ben_bpr_shd.api_updating

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

Line 922: <> nvl(ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag,hr_api.g_varchar2)

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

Line 984: l_api_updating := ben_bpr_shd.api_updating

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

Line 991: <> nvl(ben_bpr_shd.g_old_rec.no_mx_rlovr_pct_dfnd_flag,hr_api.g_varchar2)

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

Line 1053: l_api_updating := ben_bpr_shd.api_updating

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

Line 1060: <> nvl(ben_bpr_shd.g_old_rec.no_mn_rlovr_pct_dfnd_flag,hr_api.g_varchar2)

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

Line 1123: l_api_updating := ben_bpr_shd.api_updating

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

Line 1131: <> nvl(ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd,hr_api.g_varchar2)

1127: --
1128: hr_utility.set_location('p_crs_rlovr_procg_cd:'||p_crs_rlovr_procg_cd, 5);
1129: if (l_api_updating
1130: and p_crs_rlovr_procg_cd
1131: <> nvl(ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd,hr_api.g_varchar2)
1132: or not l_api_updating)
1133: and p_crs_rlovr_procg_cd is not null then
1134: --
1135: -- check if value of lookup falls within lookup type.

Line 1213: l_api_updating := ben_bpr_shd.api_updating

1209: Begin
1210: --
1211: hr_utility.set_location('Entering:'||l_proc, 5);
1212: --
1213: l_api_updating := ben_bpr_shd.api_updating
1214: (p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
1215: p_effective_date => p_effective_date,
1216: p_object_version_number => p_object_version_number);
1217: --

Line 1220: <> ben_bpr_shd.g_old_rec.pct_rndg_rl

1216: p_object_version_number => p_object_version_number);
1217: --
1218: if (l_api_updating
1219: and nvl(p_pct_rndg_rl,hr_api.g_number)
1220: <> ben_bpr_shd.g_old_rec.pct_rndg_rl
1221: or not l_api_updating)
1222: and p_pct_rndg_rl is not null then
1223: --
1224: -- check if value of formula rule is valid.

Line 1308: l_api_updating := ben_bpr_shd.api_updating

1304: Begin
1305: --
1306: hr_utility.set_location('Entering:'||l_proc, 5);
1307: --
1308: l_api_updating := ben_bpr_shd.api_updating
1309: (p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
1310: p_effective_date => p_effective_date,
1311: p_object_version_number => p_object_version_number);
1312: --

Line 1315: <> ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl

1311: p_object_version_number => p_object_version_number);
1312: --
1313: if (l_api_updating
1314: and nvl(p_prtt_elig_rlovr_rl,hr_api.g_number)
1315: <> ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl
1316: or not l_api_updating)
1317: and p_prtt_elig_rlovr_rl is not null then
1318: --
1319: -- check if value of formula rule is valid.

Line 1611: (p_rec in ben_bpr_shd.g_rec_type,

1607: -- ----------------------------------------------------------------------------
1608: -- |---------------------------< insert_validate >----------------------------|
1609: -- ----------------------------------------------------------------------------
1610: Procedure insert_validate
1611: (p_rec in ben_bpr_shd.g_rec_type,
1612: p_effective_date in date,
1613: p_datetrack_mode in varchar2,
1614: p_validation_start_date in date,
1615: p_validation_end_date in date) is

Line 1751: (p_rec in ben_bpr_shd.g_rec_type,

1747: -- ----------------------------------------------------------------------------
1748: -- |---------------------------< update_validate >----------------------------|
1749: -- ----------------------------------------------------------------------------
1750: Procedure update_validate
1751: (p_rec in ben_bpr_shd.g_rec_type,
1752: p_effective_date in date,
1753: p_datetrack_mode in varchar2,
1754: p_validation_start_date in date,
1755: p_validation_end_date in date) is

Line 1901: (p_rec in ben_bpr_shd.g_rec_type,

1897: -- ----------------------------------------------------------------------------
1898: -- |---------------------------< delete_validate >----------------------------|
1899: -- ----------------------------------------------------------------------------
1900: Procedure delete_validate
1901: (p_rec in ben_bpr_shd.g_rec_type,
1902: p_effective_date in date,
1903: p_datetrack_mode in varchar2,
1904: p_validation_start_date in date,
1905: p_validation_end_date in date) is