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_PEO_BUS dependencies on BEN_PEO_SHD

Line 48: l_api_updating := ben_peo_shd.api_updating

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

Line 55: <> ben_peo_shd.g_old_rec.elig_to_prte_rsn_id) then

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

Line 59: ben_peo_shd.constraint_error('BEN_ELIG_TO_PRTE_RSN_PK');

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

Line 69: ben_peo_shd.constraint_error('BEN_ELIG_TO_PRTE_RSN_PK');

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

Line 117: l_api_updating := ben_peo_shd.api_updating

113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_peo_shd.api_updating
118: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
119: p_effective_date => p_effective_date,
120: p_object_version_number => p_object_version_number);
121: --

Line 124: <> nvl(ben_peo_shd.g_old_rec.ignr_prtn_ovrid_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_ignr_prtn_ovrid_flag
124: <> nvl(ben_peo_shd.g_old_rec.ignr_prtn_ovrid_flag,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_ignr_prtn_ovrid_flag is not null then
127: --
128: -- check if value of lookup falls within lookup type.

Line 188: l_api_updating := ben_peo_shd.api_updating

184: Begin
185: --
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: l_api_updating := ben_peo_shd.api_updating
189: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
190: p_effective_date => p_effective_date,
191: p_object_version_number => p_object_version_number);
192: --

Line 195: <> nvl(ben_peo_shd.g_old_rec.prtn_ovridbl_flag,hr_api.g_varchar2)

191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating
194: and p_prtn_ovridbl_flag
195: <> nvl(ben_peo_shd.g_old_rec.prtn_ovridbl_flag,hr_api.g_varchar2)
196: or not l_api_updating)
197: and p_prtn_ovridbl_flag is not null then
198: --
199: -- check if value of lookup falls within lookup type.

Line 259: l_api_updating := ben_peo_shd.api_updating

255: Begin
256: --
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: l_api_updating := ben_peo_shd.api_updating
260: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
261: p_effective_date => p_effective_date,
262: p_object_version_number => p_object_version_number);
263: --

Line 266: <> nvl(ben_peo_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)

262: p_object_version_number => p_object_version_number);
263: --
264: if (l_api_updating
265: and p_vrfy_fmly_mmbr_cd
266: <> nvl(ben_peo_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)
267: or not l_api_updating)
268: and p_vrfy_fmly_mmbr_cd is not null
269: then
270: --

Line 332: l_api_updating := ben_peo_shd.api_updating

328: Begin
329: --
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: l_api_updating := ben_peo_shd.api_updating
333: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
334: p_effective_date => p_effective_date,
335: p_object_version_number => p_object_version_number);
336: --

Line 339: <> nvl(ben_peo_shd.g_old_rec.elig_inelig_cd,hr_api.g_varchar2)

335: p_object_version_number => p_object_version_number);
336: --
337: if (l_api_updating
338: and p_elig_inelig_cd
339: <> nvl(ben_peo_shd.g_old_rec.elig_inelig_cd,hr_api.g_varchar2)
340: or not l_api_updating)
341: and p_elig_inelig_cd is not null
342: then
343: --

Line 405: l_api_updating := ben_peo_shd.api_updating

401: Begin
402: --
403: hr_utility.set_location('Entering:'||l_proc, 5);
404: --
405: l_api_updating := ben_peo_shd.api_updating
406: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
407: p_effective_date => p_effective_date,
408: p_object_version_number => p_object_version_number);
409: --

Line 412: <> nvl(ben_peo_shd.g_old_rec.prtn_eff_strt_dt_cd,hr_api.g_varchar2)

408: p_object_version_number => p_object_version_number);
409: --
410: if (l_api_updating
411: and p_prtn_eff_strt_dt_cd
412: <> nvl(ben_peo_shd.g_old_rec.prtn_eff_strt_dt_cd,hr_api.g_varchar2)
413: or not l_api_updating)
414: and p_prtn_eff_strt_dt_cd is not null
415: then
416: --

Line 481: l_api_updating := ben_peo_shd.api_updating

477: Begin
478: --
479: hr_utility.set_location('Entering:'||l_proc, 5);
480: --
481: l_api_updating := ben_peo_shd.api_updating
482: (p_effective_date => p_effective_date,
483: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
484: p_object_version_number => p_object_version_number);
485: --

Line 488: <> ben_peo_shd.g_old_rec.vrfy_fmly_mmbr_rl

484: p_object_version_number => p_object_version_number);
485: --
486: if (l_api_updating
487: and nvl(p_vrfy_fmly_mmbr_rl,hr_api.g_number)
488: <> ben_peo_shd.g_old_rec.vrfy_fmly_mmbr_rl
489: or not l_api_updating)
490: and p_vrfy_fmly_mmbr_rl is not null then
491: --
492: -- check if value of formula rule is valid.

Line 556: l_api_updating := ben_peo_shd.api_updating

552: Begin
553: --
554: hr_utility.set_location('Entering:'||l_proc, 5);
555: --
556: l_api_updating := ben_peo_shd.api_updating
557: (p_effective_date => p_effective_date,
558: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
559: p_object_version_number => p_object_version_number);
560: --

Line 563: <> ben_peo_shd.g_old_rec.prtn_eff_strt_dt_rl

559: p_object_version_number => p_object_version_number);
560: --
561: if (l_api_updating
562: and nvl(p_prtn_eff_strt_dt_rl,hr_api.g_number)
563: <> ben_peo_shd.g_old_rec.prtn_eff_strt_dt_rl
564: or not l_api_updating)
565: and p_prtn_eff_strt_dt_rl is not null then
566: --
567: -- check if value of formula rule is valid.

Line 628: l_api_updating := ben_peo_shd.api_updating

624: Begin
625: --
626: hr_utility.set_location('Entering:'||l_proc, 5);
627: --
628: l_api_updating := ben_peo_shd.api_updating
629: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
630: p_effective_date => p_effective_date,
631: p_object_version_number => p_object_version_number);
632: --

Line 635: <> nvl(ben_peo_shd.g_old_rec.prtn_eff_end_dt_cd,hr_api.g_varchar2)

631: p_object_version_number => p_object_version_number);
632: --
633: if (l_api_updating
634: and p_prtn_eff_end_dt_cd
635: <> nvl(ben_peo_shd.g_old_rec.prtn_eff_end_dt_cd,hr_api.g_varchar2)
636: or not l_api_updating)
637: and p_prtn_eff_end_dt_cd is not null
638: then
639: --

Line 702: l_api_updating := ben_peo_shd.api_updating

698: Begin
699: --
700: hr_utility.set_location('Entering:'||l_proc, 5);
701: --
702: l_api_updating := ben_peo_shd.api_updating
703: (p_effective_date => p_effective_date,
704: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
705: p_object_version_number => p_object_version_number);
706: --

Line 709: <> ben_peo_shd.g_old_rec.prtn_eff_end_dt_rl

705: p_object_version_number => p_object_version_number);
706: --
707: if (l_api_updating
708: and nvl(p_prtn_eff_end_dt_rl,hr_api.g_number)
709: <> ben_peo_shd.g_old_rec.prtn_eff_end_dt_rl
710: or not l_api_updating)
711: and p_prtn_eff_end_dt_rl is not null then
712: --
713: -- check if value of formula rule is valid.

Line 776: l_api_updating := ben_peo_shd.api_updating

772: Begin
773: --
774: hr_utility.set_location('Entering:'||l_proc, 5);
775: --
776: l_api_updating := ben_peo_shd.api_updating
777: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
778: p_effective_date => p_effective_date,
779: p_object_version_number => p_object_version_number);
780: --

Line 783: <> nvl(ben_peo_shd.g_old_rec.wait_perd_dt_to_use_cd,hr_api.g_varchar2)

779: p_object_version_number => p_object_version_number);
780: --
781: if (l_api_updating
782: and p_wait_perd_dt_to_use_cd
783: <> nvl(ben_peo_shd.g_old_rec.wait_perd_dt_to_use_cd,hr_api.g_varchar2)
784: or not l_api_updating)
785: and p_wait_perd_dt_to_use_cd is not null
786: then
787: --

Line 905: l_api_updating := ben_peo_shd.api_updating

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

Line 912: <> ben_peo_shd.g_old_rec.wait_perd_dt_to_use_rl

908: p_object_version_number => p_object_version_number);
909: --
910: if (l_api_updating
911: and nvl(p_wait_perd_dt_to_use_rl,hr_api.g_number)
912: <> ben_peo_shd.g_old_rec.wait_perd_dt_to_use_rl
913: or not l_api_updating)
914: and p_wait_perd_dt_to_use_rl is not null then
915: --
916: -- check if value of formula rule is valid.

Line 977: l_api_updating := ben_peo_shd.api_updating

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

Line 984: <> nvl(ben_peo_shd.g_old_rec.wait_perd_uom,hr_api.g_varchar2)

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

Line 1051: l_api_updating := ben_peo_shd.api_updating

1047: Begin
1048: --
1049: hr_utility.set_location('Entering:'||l_proc, 5);
1050: --
1051: l_api_updating := ben_peo_shd.api_updating
1052: (p_effective_date => p_effective_date,
1053: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
1054: p_object_version_number => p_object_version_number);
1055: --

Line 1058: <> ben_peo_shd.g_old_rec.wait_perd_rl

1054: p_object_version_number => p_object_version_number);
1055: --
1056: if (l_api_updating
1057: and nvl(p_wait_perd_rl,hr_api.g_number)
1058: <> ben_peo_shd.g_old_rec.wait_perd_rl
1059: or not l_api_updating)
1060: and p_wait_perd_rl is not null then
1061: --
1062: -- check if value of formula rule is valid.

Line 1125: l_api_updating := ben_peo_shd.api_updating

1121: Begin
1122: --
1123: hr_utility.set_location('Entering:'||l_proc, 5);
1124: --
1125: l_api_updating := ben_peo_shd.api_updating
1126: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
1127: p_effective_date => p_effective_date,
1128: p_object_version_number => p_object_version_number);
1129: --

Line 1132: <> nvl(ben_peo_shd.g_old_rec.mx_poe_uom,hr_api.g_varchar2)

1128: p_object_version_number => p_object_version_number);
1129: --
1130: if (l_api_updating
1131: and p_mx_poe_uom
1132: <> nvl(ben_peo_shd.g_old_rec.mx_poe_uom,hr_api.g_varchar2)
1133: or not l_api_updating)
1134: and p_mx_poe_uom is not null then
1135: --
1136: -- check if value of lookup falls within lookup type.

Line 1199: l_api_updating := ben_peo_shd.api_updating

1195: Begin
1196: --
1197: hr_utility.set_location('Entering:'||l_proc, 5);
1198: --
1199: l_api_updating := ben_peo_shd.api_updating
1200: (p_effective_date => p_effective_date,
1201: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
1202: p_object_version_number => p_object_version_number);
1203: --

Line 1206: <> ben_peo_shd.g_old_rec.mx_poe_det_dt_rl

1202: p_object_version_number => p_object_version_number);
1203: --
1204: if (l_api_updating
1205: and nvl(p_mx_poe_det_dt_rl,hr_api.g_number)
1206: <> ben_peo_shd.g_old_rec.mx_poe_det_dt_rl
1207: or not l_api_updating)
1208: and p_mx_poe_det_dt_rl is not null then
1209: --
1210: -- check if value of formula rule is valid.

Line 1274: l_api_updating := ben_peo_shd.api_updating

1270: Begin
1271: --
1272: hr_utility.set_location('Entering:'||l_proc, 5);
1273: --
1274: l_api_updating := ben_peo_shd.api_updating
1275: (p_effective_date => p_effective_date,
1276: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
1277: p_object_version_number => p_object_version_number);
1278: --

Line 1281: <> ben_peo_shd.g_old_rec.mx_poe_rl

1277: p_object_version_number => p_object_version_number);
1278: --
1279: if (l_api_updating
1280: and nvl(p_mx_poe_rl,hr_api.g_number)
1281: <> ben_peo_shd.g_old_rec.mx_poe_rl
1282: or not l_api_updating)
1283: and p_mx_poe_rl is not null then
1284: --
1285: -- check if value of formula rule is valid.

Line 1349: l_api_updating := ben_peo_shd.api_updating

1345: Begin
1346: --
1347: hr_utility.set_location('Entering:'||l_proc, 5);
1348: --
1349: l_api_updating := ben_peo_shd.api_updating
1350: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
1351: p_effective_date => p_effective_date,
1352: p_object_version_number => p_object_version_number);
1353: --

Line 1356: <> nvl(ben_peo_shd.g_old_rec.mx_poe_det_dt_cd,hr_api.g_varchar2)

1352: p_object_version_number => p_object_version_number);
1353: --
1354: if (l_api_updating
1355: and p_mx_poe_det_dt_cd
1356: <> nvl(ben_peo_shd.g_old_rec.mx_poe_det_dt_cd,hr_api.g_varchar2)
1357: or not l_api_updating)
1358: and p_mx_poe_det_dt_cd is not null then
1359: --
1360: -- check if value of lookup falls within lookup type.

Line 1422: l_api_updating := ben_peo_shd.api_updating

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

Line 1429: <> nvl(ben_peo_shd.g_old_rec.mx_poe_apls_cd,hr_api.g_varchar2)

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

Line 1788: (p_rec in ben_peo_shd.g_rec_type

1784: -- ----------------------------------------------------------------------------
1785: -- |---------------------------< insert_validate >----------------------------|
1786: -- ----------------------------------------------------------------------------
1787: Procedure insert_validate
1788: (p_rec in ben_peo_shd.g_rec_type
1789: ,p_effective_date in date
1790: ,p_datetrack_mode in varchar2
1791: ,p_validation_start_date in date
1792: ,p_validation_end_date in date) is

Line 1944: (p_rec in ben_peo_shd.g_rec_type

1940: -- ----------------------------------------------------------------------------
1941: -- |---------------------------< update_validate >----------------------------|
1942: -- ----------------------------------------------------------------------------
1943: Procedure update_validate
1944: (p_rec in ben_peo_shd.g_rec_type
1945: ,p_effective_date in date
1946: ,p_datetrack_mode in varchar2
1947: ,p_validation_start_date in date
1948: ,p_validation_end_date in date)

Line 2109: (p_rec in ben_peo_shd.g_rec_type,

2105: -- ----------------------------------------------------------------------------
2106: -- |---------------------------< delete_validate >----------------------------|
2107: -- ----------------------------------------------------------------------------
2108: Procedure delete_validate
2109: (p_rec in ben_peo_shd.g_rec_type,
2110: p_effective_date in date,
2111: p_datetrack_mode in varchar2,
2112: p_validation_start_date in date,
2113: p_validation_end_date in date) is