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_EPO_BUS dependencies on BEN_EPO_SHD

Line 65: l_api_updating := ben_epo_shd.api_updating

61: Begin
62: --
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: --
65: l_api_updating := ben_epo_shd.api_updating
66: (p_effective_date => p_effective_date,
67: p_elig_per_opt_id => p_elig_per_opt_id,
68: p_object_version_number => p_object_version_number);
69: --

Line 72: <> ben_epo_shd.g_old_rec.elig_per_opt_id) then

68: p_object_version_number => p_object_version_number);
69: --
70: if (l_api_updating
71: and nvl(p_elig_per_opt_id,hr_api.g_number)
72: <> ben_epo_shd.g_old_rec.elig_per_opt_id) then
73: --
74: -- raise error as PK has changed
75: --
76: ben_epo_shd.constraint_error('BEN_ELIG_PER_F_PK');

Line 76: ben_epo_shd.constraint_error('BEN_ELIG_PER_F_PK');

72: <> ben_epo_shd.g_old_rec.elig_per_opt_id) then
73: --
74: -- raise error as PK has changed
75: --
76: ben_epo_shd.constraint_error('BEN_ELIG_PER_F_PK');
77: --
78: elsif not l_api_updating then
79: --
80: -- check if PK is null

Line 86: ben_epo_shd.constraint_error('BEN_ELIG_PER_F_PK');

82: if p_elig_per_opt_id is not null then
83: --
84: -- raise error as PK is not null
85: --
86: ben_epo_shd.constraint_error('BEN_ELIG_PER_F_PK');
87: --
88: end if;
89: --
90: end if;

Line 96: <> nvl(ben_epo_shd.g_old_rec.elig_per_opt_id,hr_api.g_number)

92: hr_utility.set_location('In:'||l_proc, 7);
93:
94: if (l_api_updating
95: and p_elig_per_opt_id
96: <> nvl(ben_epo_shd.g_old_rec.elig_per_opt_id,hr_api.g_number)
97: or not l_api_updating) then
98: --
99: open c1;
100: --

Line 187: l_api_updating:= ben_epo_shd.api_updating

183: fnd_message.raise_error;
184: --
185: end if;
186: --
187: l_api_updating:= ben_epo_shd.api_updating
188: (p_elig_per_opt_id => p_elig_per_opt_id,
189: p_effective_date => p_effective_date,
190: p_object_version_number => p_object_version_number);
191: --

Line 194: <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,hr_api.g_varchar2)

190: p_object_version_number => p_object_version_number);
191: --
192: if (l_api_updating
193: and p_comp_ref_uom
194: <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,hr_api.g_varchar2)
195: or not l_api_updating) and p_comp_ref_uom IS NOT NULL then
196: --
197: -- check if comp_ref_uom value exists in hr_lookups table
198: --

Line 216: <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,hr_api.g_varchar2)

212: end if;
213: --
214: if (l_api_updating
215: and p_rt_comp_ref_uom
216: <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,hr_api.g_varchar2)
217: or not l_api_updating) and p_rt_comp_ref_uom IS NOT NULL then
218: --
219: -- check if rt_comp_ref_uom value exists in hr_lookups table
220: --

Line 278: l_api_updating := ben_epo_shd.api_updating

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

Line 285: <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)

281: p_object_version_number => p_object_version_number);
282: --
283: if (l_api_updating
284: and nvl(p_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
285: <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
286: or not l_api_updating) and p_hrs_wkd_bndry_perd_cd IS NOT NULL then
287: --
288: -- check if value of lookup falls within lookup type.
289: --

Line 308: <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)

304: end if;
305: --
306: if (l_api_updating
307: and nvl(p_rt_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
308: <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
309: or not l_api_updating) and p_rt_hrs_wkd_bndry_perd_cd IS NOT NULL then
310: --
311: -- check if value of lookup falls within lookup type.
312: --

Line 438: l_api_updating := ben_epo_shd.api_updating

434: fnd_message.raise_error;
435: --
436: end if;
437: --
438: l_api_updating := ben_epo_shd.api_updating
439: (p_elig_per_opt_id => p_elig_per_opt_id,
440: p_effective_date => p_effective_date,
441: p_object_version_number => p_object_version_number);
442: --

Line 445: <> nvl(ben_epo_shd.g_old_rec.age_uom,hr_api.g_varchar2)

441: p_object_version_number => p_object_version_number);
442: --
443: if (l_api_updating
444: and p_age_uom
445: <> nvl(ben_epo_shd.g_old_rec.age_uom,hr_api.g_varchar2)
446: or not l_api_updating) and p_age_uom IS NOT NULL then
447: --
448: -- check if value of lookup falls within lookup type.
449: --

Line 468: <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,hr_api.g_varchar2)

464: end if;
465: --
466: if (l_api_updating
467: and p_rt_age_uom
468: <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,hr_api.g_varchar2)
469: or not l_api_updating) and p_rt_age_uom IS NOT NULL then
470: --
471: -- check if value of lookup falls within lookup type.
472: --

Line 530: l_api_updating := ben_epo_shd.api_updating

526: Begin
527: --
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: l_api_updating := ben_epo_shd.api_updating
531: (p_elig_per_opt_id => p_elig_per_opt_id,
532: p_effective_date => p_effective_date,
533: p_object_version_number => p_object_version_number);
534: --

Line 537: <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,hr_api.g_varchar2)

533: p_object_version_number => p_object_version_number);
534: --
535: if (l_api_updating
536: and p_once_r_cntug_cd
537: <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,hr_api.g_varchar2)
538: or not l_api_updating) and p_once_r_cntug_cd IS NOT NULL then
539: --
540: -- check if value of lookup falls within lookup type.
541: --

Line 599: l_api_updating := ben_epo_shd.api_updating

595: Begin
596: --
597: hr_utility.set_location('Entering:'||l_proc, 5);
598: --
599: l_api_updating := ben_epo_shd.api_updating
600: (p_elig_per_opt_id => p_elig_per_opt_id,
601: p_effective_date => p_effective_date,
602: p_object_version_number => p_object_version_number);
603: --

Line 606: <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,hr_api.g_varchar2)

602: p_object_version_number => p_object_version_number);
603: --
604: if (l_api_updating
605: and p_inelg_rsn_cd
606: <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,hr_api.g_varchar2)
607: or not l_api_updating) and p_inelg_rsn_cd IS NOT NULL then
608: --
609: -- check if value of lookup falls within lookup type.
610: --

Line 687: l_api_updating := ben_epo_shd.api_updating

683: fnd_message.raise_error;
684: --
685: end if;
686: --
687: l_api_updating := ben_epo_shd.api_updating
688: (p_elig_per_opt_id => p_elig_per_opt_id,
689: p_effective_date => p_effective_date,
690: p_object_version_number => p_object_version_number);
691: --

Line 694: <> nvl(ben_epo_shd.g_old_rec.los_uom,hr_api.g_varchar2)

690: p_object_version_number => p_object_version_number);
691: --
692: if (l_api_updating
693: and p_los_uom
694: <> nvl(ben_epo_shd.g_old_rec.los_uom,hr_api.g_varchar2)
695: or not l_api_updating) and p_los_uom IS NOT NULL then
696: --
697: -- check if value of lookup falls within lookup type.
698: --

Line 717: <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,hr_api.g_varchar2)

713: end if;
714: --
715: if (l_api_updating
716: and p_rt_los_uom
717: <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,hr_api.g_varchar2)
718: or not l_api_updating) and p_rt_los_uom IS NOT NULL then
719: --
720: -- check if value of lookup falls within lookup type.
721: --

Line 779: l_api_updating := ben_epo_shd.api_updating

775: Begin
776: --
777: hr_utility.set_location('Entering:'||l_proc, 5);
778: --
779: l_api_updating := ben_epo_shd.api_updating
780: (p_elig_per_opt_id => p_elig_per_opt_id,
781: p_effective_date => p_effective_date,
782: p_object_version_number => p_object_version_number);
783: --

Line 786: <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd,hr_api.g_varchar2)

782: p_object_version_number => p_object_version_number);
783: --
784: if (l_api_updating
785: and p_prtn_ovridn_rsn_cd
786: <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd,hr_api.g_varchar2)
787: or not l_api_updating)
788: and p_prtn_ovridn_rsn_cd is not null then
789: --
790: -- check if value of lookup falls within lookup type.

Line 850: l_api_updating := ben_epo_shd.api_updating

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

Line 857: <> nvl(ben_epo_shd.g_old_rec.elig_flag,hr_api.g_varchar2)

853: p_object_version_number => p_object_version_number);
854: --
855: if (l_api_updating
856: and p_elig_flag
857: <> nvl(ben_epo_shd.g_old_rec.elig_flag,hr_api.g_varchar2)
858: or not l_api_updating) then
859: --
860: -- check if value of lookup falls within lookup type.
861: --

Line 921: l_api_updating := ben_epo_shd.api_updating

917: Begin
918: --
919: hr_utility.set_location('Entering:'||l_proc, 5);
920: --
921: l_api_updating := ben_epo_shd.api_updating
922: (p_elig_per_opt_id => p_elig_per_opt_id,
923: p_effective_date => p_effective_date,
924: p_object_version_number => p_object_version_number);
925: --

Line 928: <> nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,hr_api.g_varchar2)

924: p_object_version_number => p_object_version_number);
925: --
926: if (l_api_updating
927: and p_no_mx_prtn_ovrid_thru_flag
928: <> nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,hr_api.g_varchar2)
929: or not l_api_updating) then
930: --
931: -- check if value of lookup falls within lookup type.
932: --

Line 1015: l_api_updating := ben_epo_shd.api_updating

1011: Begin
1012: --
1013: hr_utility.set_location('Entering:'||l_proc, 5);
1014: --
1015: l_api_updating := ben_epo_shd.api_updating
1016: (p_elig_per_opt_id => p_elig_per_opt_id,
1017: p_effective_date => p_effective_date,
1018: p_object_version_number => p_object_version_number);
1019: --

Line 1023: <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,hr_api.g_varchar2)

1019: --
1020: hr_utility.set_location('RFLF:'||l_proc, 5);
1021: if (l_api_updating
1022: and p_rt_frz_los_flag
1023: <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,hr_api.g_varchar2)
1024: or not l_api_updating) then
1025: --
1026: -- check if value of lookup falls within lookup type.
1027: --

Line 1048: <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,hr_api.g_varchar2)

1044: --
1045: hr_utility.set_location('RFAF:'||l_proc, 5);
1046: if (l_api_updating
1047: and p_rt_frz_age_flag
1048: <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,hr_api.g_varchar2)
1049: or not l_api_updating) then
1050: --
1051: -- check if value of lookup falls within lookup type.
1052: --

Line 1072: <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,hr_api.g_varchar2)

1068: --
1069: hr_utility.set_location('RFCLF:'||l_proc, 5);
1070: if (l_api_updating
1071: and p_rt_frz_cmp_lvl_flag
1072: <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,hr_api.g_varchar2)
1073: or not l_api_updating) then
1074: --
1075: -- check if value of lookup falls within lookup type.
1076: --

Line 1096: <> nvl(ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag,hr_api.g_varchar2)

1092: --
1093: hr_utility.set_location('RFPFTF:'||l_proc, 5);
1094: if (l_api_updating
1095: and p_rt_frz_pct_fl_tm_flag
1096: <> nvl(ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag,hr_api.g_varchar2)
1097: or not l_api_updating) then
1098: --
1099: -- check if value of lookup falls within lookup type.
1100: --

Line 1120: <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,hr_api.g_varchar2)

1116: --
1117: hr_utility.set_location('RFHWF:'||l_proc, 5);
1118: if (l_api_updating
1119: and p_rt_frz_hrs_wkd_flag
1120: <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,hr_api.g_varchar2)
1121: or not l_api_updating) then
1122: --
1123: -- check if value of lookup falls within lookup type.
1124: --

Line 1144: <> nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,hr_api.g_varchar2)

1140: --
1141: hr_utility.set_location('RFCAALF:'||l_proc, 5);
1142: if (l_api_updating
1143: and p_rt_frz_comb_age_and_los_flag
1144: <> nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,hr_api.g_varchar2)
1145: or not l_api_updating) then
1146: --
1147: -- check if value of lookup falls within lookup type.
1148: --

Line 1168: <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,hr_api.g_varchar2)

1164: --
1165: hr_utility.set_location('FLF:'||l_proc, 5);
1166: if (l_api_updating
1167: and p_frz_los_flag
1168: <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,hr_api.g_varchar2)
1169: or not l_api_updating) then
1170: --
1171: -- check if value of lookup falls within lookup type.
1172: --

Line 1192: <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,hr_api.g_varchar2)

1188: --
1189: hr_utility.set_location('FAF:'||l_proc, 5);
1190: if (l_api_updating
1191: and p_frz_age_flag
1192: <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,hr_api.g_varchar2)
1193: or not l_api_updating) then
1194: --
1195: -- check if value of lookup falls within lookup type.
1196: --

Line 1216: <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,hr_api.g_varchar2)

1212: --
1213: hr_utility.set_location('FCLF:'||l_proc, 5);
1214: if (l_api_updating
1215: and p_frz_cmp_lvl_flag
1216: <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,hr_api.g_varchar2)
1217: or not l_api_updating) then
1218: --
1219: -- check if value of lookup falls within lookup type.
1220: --

Line 1240: <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,hr_api.g_varchar2)

1236: --
1237: hr_utility.set_location('FPFTF:'||l_proc, 5);
1238: if (l_api_updating
1239: and p_frz_pct_fl_tm_flag
1240: <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,hr_api.g_varchar2)
1241: or not l_api_updating) then
1242: --
1243: -- check if value of lookup falls within lookup type.
1244: --

Line 1264: <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,hr_api.g_varchar2)

1260: --
1261: hr_utility.set_location('FHWFF:'||l_proc, 5);
1262: if (l_api_updating
1263: and p_frz_hrs_wkd_flag
1264: <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,hr_api.g_varchar2)
1265: or not l_api_updating) then
1266: --
1267: -- check if value of lookup falls within lookup type.
1268: --

Line 1326: l_api_updating := ben_epo_shd.api_updating

1322: Begin
1323: --
1324: hr_utility.set_location('Entering:'||l_proc, 5);
1325: --
1326: l_api_updating := ben_epo_shd.api_updating
1327: (p_elig_per_opt_id => p_elig_per_opt_id,
1328: p_effective_date => p_effective_date,
1329: p_object_version_number => p_object_version_number);
1330: --

Line 1333: <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,hr_api.g_varchar2)

1329: p_object_version_number => p_object_version_number);
1330: --
1331: if (l_api_updating
1332: and p_prtn_ovridn_flag
1333: <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,hr_api.g_varchar2)
1334: or not l_api_updating) then
1335: --
1336: -- check if value of lookup falls within lookup type.
1337: --

Line 1577: (p_rec in ben_epo_shd.g_rec_type,

1573: -- ----------------------------------------------------------------------------
1574: -- |---------------------------< insert_validate >----------------------------|
1575: -- ----------------------------------------------------------------------------
1576: Procedure insert_validate
1577: (p_rec in ben_epo_shd.g_rec_type,
1578: p_effective_date in date,
1579: p_datetrack_mode in varchar2,
1580: p_validation_start_date in date,
1581: p_validation_end_date in date) is

Line 1698: (p_rec in ben_epo_shd.g_rec_type,

1694: -- ----------------------------------------------------------------------------
1695: -- |---------------------------< update_validate >----------------------------|
1696: -- ----------------------------------------------------------------------------
1697: Procedure update_validate
1698: (p_rec in ben_epo_shd.g_rec_type,
1699: p_effective_date in date,
1700: p_datetrack_mode in varchar2,
1701: p_validation_start_date in date,
1702: p_validation_end_date in date) is

Line 1828: (p_rec in ben_epo_shd.g_rec_type,

1824: -- ----------------------------------------------------------------------------
1825: -- |---------------------------< delete_validate >----------------------------|
1826: -- ----------------------------------------------------------------------------
1827: Procedure delete_validate
1828: (p_rec in ben_epo_shd.g_rec_type,
1829: p_effective_date in date,
1830: p_datetrack_mode in varchar2,
1831: p_validation_start_date in date,
1832: p_validation_end_date in date) is