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_EPE_BUS dependencies on BEN_EPE_SHD

Line 55: l_api_updating := ben_epe_shd.api_updating

51: Begin
52: --
53: hr_utility.set_location('Entering:'||l_proc,5);
54: --
55: l_api_updating := ben_epe_shd.api_updating
56: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
57: p_object_version_number => p_object_version_number);
58: --
59: if (l_api_updating

Line 61: <> nvl(ben_epe_shd.g_old_rec.pil_elctbl_chc_popl_id,hr_api.g_number)

57: p_object_version_number => p_object_version_number);
58: --
59: if (l_api_updating
60: and nvl(p_pil_elctbl_chc_popl_id,hr_api.g_number)
61: <> nvl(ben_epe_shd.g_old_rec.pil_elctbl_chc_popl_id,hr_api.g_number)
62: or not l_api_updating) and
63: p_pil_elctbl_chc_popl_id is not null then
64: --
65: -- check if pil_elctbl_chc_popl_id value exists in ben_pil_elctbl_chc_popl table

Line 77: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_?');

73: --
74: -- raise error as FK does not relate to PK in ben_pil_elctbl_chc_popl
75: -- table.
76: --
77: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_?');
78: --
79: end if;
80: --
81: close c1;

Line 134: l_api_updating := ben_epe_shd.api_updating

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

Line 140: <> nvl(ben_epe_shd.g_old_rec.pl_typ_id,hr_api.g_number)

136: p_object_version_number => p_object_version_number);
137: --
138: if (l_api_updating
139: and nvl(p_pl_typ_id,hr_api.g_number)
140: <> nvl(ben_epe_shd.g_old_rec.pl_typ_id,hr_api.g_number)
141: or not l_api_updating) and
142: p_pl_typ_id is not null then
143: --
144: -- check if pl_typ_id value exists in ben_pl_typ table

Line 156: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT7');

152: --
153: -- raise error a PK does not relate to PK in ben_pl_typ
154: -- table.
155: --
156: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT7');
157: --
158: end if;
159: --
160: close c1;

Line 212: l_api_updating := ben_epe_shd.api_updating

208: Begin
209: --
210: hr_utility.set_location('Entering:'||l_proc,5);
211: --
212: l_api_updating := ben_epe_shd.api_updating
213: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
214: p_object_version_number => p_object_version_number);
215: --
216: if (l_api_updating

Line 218: <> nvl(ben_epe_shd.g_old_rec.spcl_rt_oipl_id,hr_api.g_number)

214: p_object_version_number => p_object_version_number);
215: --
216: if (l_api_updating
217: and nvl(p_spcl_rt_oipl_id,hr_api.g_number)
218: <> nvl(ben_epe_shd.g_old_rec.spcl_rt_oipl_id,hr_api.g_number)
219: or not l_api_updating) and
220: p_spcl_rt_oipl_id is not null then
221: --
222: -- check if spcl_rt_oipl_id value exists in ben_spcl_rt_oipl table

Line 234: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT13');

230: --
231: -- raise error as FK does not relate to PK in ben_spcl_rt_oipl
232: -- table.
233: --
234: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT13');
235: --
236: end if;
237: --
238: close c1;

Line 290: l_api_updating := ben_epe_shd.api_updating

286: Begin
287: --
288: hr_utility.set_location('Entering:'||l_proc,5);
289: --
290: l_api_updating := ben_epe_shd.api_updating
291: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
292: p_object_version_number => p_object_version_number);
293: --
294: if (l_api_updating

Line 296: <> nvl(ben_epe_shd.g_old_rec.spcl_rt_pl_id,hr_api.g_number)

292: p_object_version_number => p_object_version_number);
293: --
294: if (l_api_updating
295: and nvl(p_spcl_rt_pl_id,hr_api.g_number)
296: <> nvl(ben_epe_shd.g_old_rec.spcl_rt_pl_id,hr_api.g_number)
297: or not l_api_updating) and
298: p_spcl_rt_pl_id is not null then
299: --
300: -- check if spcl_rt_pl_id value exists in ben_spcl_rt_pl table

Line 312: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT12');

308: --
309: -- raise error as FK does not relate to PK in ben_spcl_rt_pl
310: -- table.
311: --
312: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT12');
313: --
314: end if;
315: --
316: close c1;

Line 368: l_api_updating := ben_epe_shd.api_updating

364: Begin
365: --
366: hr_utility.set_location('Entering:'||l_proc,5);
367: --
368: l_api_updating := ben_epe_shd.api_updating
369: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
370: p_object_version_number => p_object_version_number);
371: --
372: if (l_api_updating

Line 374: <> nvl(ben_epe_shd.g_old_rec.plip_id,hr_api.g_number)

370: p_object_version_number => p_object_version_number);
371: --
372: if (l_api_updating
373: and nvl(p_plip_id,hr_api.g_number)
374: <> nvl(ben_epe_shd.g_old_rec.plip_id,hr_api.g_number)
375: or not l_api_updating) and
376: p_plip_id is not null then
377: --
378: -- check if plip_id value exists in ben_plip table

Line 390: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT8');

386: --
387: -- raise error as FK does not relate to PK in ben_plip
388: -- table.
389: --
390: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT8');
391: --
392: end if;
393: --
394: close c1;

Line 446: l_api_updating := ben_epe_shd.api_updating

442: Begin
443: --
444: hr_utility.set_location('Entering:'||l_proc,5);
445: --
446: l_api_updating := ben_epe_shd.api_updating
447: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
448: p_object_version_number => p_object_version_number);
449: --
450: if (l_api_updating

Line 452: <> nvl(ben_epe_shd.g_old_rec.cmbn_ptip_id,hr_api.g_number)

448: p_object_version_number => p_object_version_number);
449: --
450: if (l_api_updating
451: and nvl(p_cmbn_ptip_id,hr_api.g_number)
452: <> nvl(ben_epe_shd.g_old_rec.cmbn_ptip_id,hr_api.g_number)
453: or not l_api_updating) and
454: p_cmbn_ptip_id is not null then
455: --
456: -- check if cmbn_ptip_id value exists in ben_cmbn_ptip table

Line 468: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT15');

464: --
465: -- raise error as FK does not relate to PK in ben_cmbn_ptip
466: -- table.
467: --
468: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT15');
469: --
470: end if;
471: --
472: close c1;

Line 524: l_api_updating := ben_epe_shd.api_updating

520: Begin
521: --
522: hr_utility.set_location('Entering:'||l_proc,5);
523: --
524: l_api_updating := ben_epe_shd.api_updating
525: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
526: p_object_version_number => p_object_version_number);
527: --
528: if (l_api_updating

Line 530: <> nvl(ben_epe_shd.g_old_rec.cmbn_plip_id,hr_api.g_number)

526: p_object_version_number => p_object_version_number);
527: --
528: if (l_api_updating
529: and nvl(p_cmbn_plip_id,hr_api.g_number)
530: <> nvl(ben_epe_shd.g_old_rec.cmbn_plip_id,hr_api.g_number)
531: or not l_api_updating) and
532: p_cmbn_plip_id is not null then
533: --
534: -- check if cmbn_plip_id value exists in ben_cmbn_plip table

Line 546: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT15');

542: --
543: -- raise error as FK does not relate to PK in ben_cmbn_plip
544: -- table.
545: --
546: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT15');
547: --
548: end if;
549: --
550: close c1;

Line 602: l_api_updating := ben_epe_shd.api_updating

598: Begin
599: --
600: hr_utility.set_location('Entering:'||l_proc,5);
601: --
602: l_api_updating := ben_epe_shd.api_updating
603: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
604: p_object_version_number => p_object_version_number);
605: --
606: if (l_api_updating

Line 608: <> nvl(ben_epe_shd.g_old_rec.ptip_id,hr_api.g_number)

604: p_object_version_number => p_object_version_number);
605: --
606: if (l_api_updating
607: and nvl(p_ptip_id,hr_api.g_number)
608: <> nvl(ben_epe_shd.g_old_rec.ptip_id,hr_api.g_number)
609: or not l_api_updating) and
610: p_ptip_id is not null then
611: --
612: -- check if ptip_id value exists in ben_ptip table

Line 624: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT9');

620: --
621: -- raise error as FK does not relate to PK in ben_ptip
622: -- table.
623: --
624: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT9');
625: --
626: end if;
627: --
628: close c1;

Line 680: l_api_updating := ben_epe_shd.api_updating

676: Begin
677: --
678: hr_utility.set_location('Entering:'||l_proc,5);
679: --
680: l_api_updating := ben_epe_shd.api_updating
681: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
682: p_object_version_number => p_object_version_number);
683: --
684: if (l_api_updating

Line 686: <> nvl(ben_epe_shd.g_old_rec.cmbn_ptip_opt_id,hr_api.g_number)

682: p_object_version_number => p_object_version_number);
683: --
684: if (l_api_updating
685: and nvl(p_cmbn_ptip_opt_id,hr_api.g_number)
686: <> nvl(ben_epe_shd.g_old_rec.cmbn_ptip_opt_id,hr_api.g_number)
687: or not l_api_updating) and
688: p_cmbn_ptip_opt_id is not null then
689: --
690: -- check if cmbn_ptip_opt_id value exists in ben_cmbn_ptip_opt table

Line 702: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT16');

698: --
699: -- raise error as FK does not relate to PK in ben_cmbn_ptip_opt
700: -- table.
701: --
702: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT16');
703: --
704: end if;
705: --
706: close c1;

Line 758: l_api_updating := ben_epe_shd.api_updating

754: Begin
755: --
756: hr_utility.set_location('Entering:'||l_proc,5);
757: --
758: l_api_updating := ben_epe_shd.api_updating
759: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
760: p_object_version_number => p_object_version_number);
761: --
762: if (l_api_updating

Line 764: <> nvl(ben_epe_shd.g_old_rec.pgm_id,hr_api.g_number)

760: p_object_version_number => p_object_version_number);
761: --
762: if (l_api_updating
763: and nvl(p_pgm_id,hr_api.g_number)
764: <> nvl(ben_epe_shd.g_old_rec.pgm_id,hr_api.g_number)
765: or not l_api_updating) and
766: p_pgm_id is not null then
767: --
768: -- check if pgm_id value exists in ben_pgm table

Line 780: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT3');

776: --
777: -- raise error as FK does not relate to PK in ben_pgm
778: -- table.
779: --
780: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT3');
781: --
782: end if;
783: --
784: close c1;

Line 836: l_api_updating := ben_epe_shd.api_updating

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

Line 842: <> nvl(ben_epe_shd.g_old_rec.oipl_id,hr_api.g_number)

838: p_object_version_number => p_object_version_number);
839: --
840: if (l_api_updating
841: and nvl(p_oipl_id,hr_api.g_number)
842: <> nvl(ben_epe_shd.g_old_rec.oipl_id,hr_api.g_number)
843: or not l_api_updating) and
844: p_oipl_id is not null then
845: --
846: -- check if oipl_id value exists in ben_oipl table

Line 858: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT2');

854: --
855: -- raise error as FK does not relate to PK in ben_oipl
856: -- table.
857: --
858: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT2');
859: --
860: end if;
861: --
862: close c1;

Line 914: l_api_updating := ben_epe_shd.api_updating

910: Begin
911: --
912: hr_utility.set_location('Entering:'||l_proc,5);
913: --
914: l_api_updating := ben_epe_shd.api_updating
915: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
916: p_object_version_number => p_object_version_number);
917: --
918: if (l_api_updating

Line 920: <> nvl(ben_epe_shd.g_old_rec.pl_id,hr_api.g_number)

916: p_object_version_number => p_object_version_number);
917: --
918: if (l_api_updating
919: and nvl(p_pl_id,hr_api.g_number)
920: <> nvl(ben_epe_shd.g_old_rec.pl_id,hr_api.g_number)
921: or not l_api_updating) and
922: p_pl_id is not null then
923: --
924: -- check if pl_id value exists in ben_pl table

Line 936: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT2');

932: --
933: -- raise error as FK does not relate to PK in ben_pl
934: -- table.
935: --
936: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT2');
937: --
938: end if;
939: --
940: close c1;

Line 992: l_api_updating := ben_epe_shd.api_updating

988: Begin
989: --
990: hr_utility.set_location('Entering:'||l_proc,5);
991: --
992: l_api_updating := ben_epe_shd.api_updating
993: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
994: p_object_version_number => p_object_version_number);
995: --
996: if (l_api_updating

Line 998: <> nvl(ben_epe_shd.g_old_rec.bnft_prvdr_pool_id,hr_api.g_number)

994: p_object_version_number => p_object_version_number);
995: --
996: if (l_api_updating
997: and nvl(p_bnft_prvdr_pool_id,hr_api.g_number)
998: <> nvl(ben_epe_shd.g_old_rec.bnft_prvdr_pool_id,hr_api.g_number)
999: or not l_api_updating) and
1000: p_bnft_prvdr_pool_id is not null then
1001: --
1002: -- check if bnft_prvdr_pool_id value exists in ben_bnft_prvdr_pool table

Line 1014: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT14');

1010: --
1011: -- raise error as FK does not relate to PK in ben_bnft_prvdr_pool
1012: -- table.
1013: --
1014: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT14');
1015: --
1016: end if;
1017: --
1018: close c1;

Line 1071: l_api_updating := ben_epe_shd.api_updating

1067: Begin
1068: --
1069: hr_utility.set_location('Entering:'||l_proc,5);
1070: --
1071: l_api_updating := ben_epe_shd.api_updating
1072: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1073: p_object_version_number => p_object_version_number);
1074: --
1075: if (l_api_updating

Line 1077: <> nvl(ben_epe_shd.g_old_rec.prtt_enrt_rslt_id,hr_api.g_number)

1073: p_object_version_number => p_object_version_number);
1074: --
1075: if (l_api_updating
1076: and nvl(p_prtt_enrt_rslt_id,hr_api.g_number)
1077: <> nvl(ben_epe_shd.g_old_rec.prtt_enrt_rslt_id,hr_api.g_number)
1078: or not l_api_updating) and
1079: p_prtt_enrt_rslt_id is not null then
1080: --
1081: -- check if prtt_enrt_rslt_id value exists in ben_prtt_enrt_rslt table.

Line 1095: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT5');

1091: --
1092: -- raise error as FK does not relate to PK in ben_prtt_enrt_rslt
1093: -- table.
1094: --
1095: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT5');
1096: --
1097: end if;
1098: --
1099: close c1;

Line 1152: l_api_updating := ben_epe_shd.api_updating

1148: Begin
1149: --
1150: hr_utility.set_location('Entering:'||l_proc,5);
1151: --
1152: l_api_updating := ben_epe_shd.api_updating
1153: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1154: p_object_version_number => p_object_version_number);
1155: --
1156: if (l_api_updating

Line 1158: <> nvl(ben_epe_shd.g_old_rec.per_in_ler_id,hr_api.g_number)

1154: p_object_version_number => p_object_version_number);
1155: --
1156: if (l_api_updating
1157: and nvl(p_per_in_ler_id,hr_api.g_number)
1158: <> nvl(ben_epe_shd.g_old_rec.per_in_ler_id,hr_api.g_number)
1159: or not l_api_updating) and
1160: p_per_in_ler_id is not null then
1161: --
1162: -- check if per_in_ler_id value exists in ben_per_in_ler table, and that

Line 1175: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT6');

1171: --
1172: -- raise error as FK does not relate to PK in ben_per_in_ler
1173: -- table.
1174: --
1175: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT6');
1176: --
1177: end if;
1178: --
1179: close c1;

Line 1231: l_api_updating := ben_epe_shd.api_updating

1227: Begin
1228: --
1229: hr_utility.set_location('Entering:'||l_proc,5);
1230: --
1231: l_api_updating := ben_epe_shd.api_updating
1232: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1233: p_object_version_number => p_object_version_number);
1234: --
1235: if (l_api_updating

Line 1237: <> nvl(ben_epe_shd.g_old_rec.must_enrl_anthr_pl_id,hr_api.g_number)

1233: p_object_version_number => p_object_version_number);
1234: --
1235: if (l_api_updating
1236: and nvl(p_must_enrl_anthr_pl_id,hr_api.g_number)
1237: <> nvl(ben_epe_shd.g_old_rec.must_enrl_anthr_pl_id,hr_api.g_number)
1238: or not l_api_updating) and
1239: p_must_enrl_anthr_pl_id is not null then
1240: --
1241: -- check if must_enrl_anthr_pl_id value exists in ben_must_enrl_anthr_pl table

Line 1253: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT11');

1249: --
1250: -- raise error as FK does not relate to PK in ben_must_enrl_anthr_pl
1251: -- table.
1252: --
1253: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT11');
1254: --
1255: end if;
1256: --
1257: close c1;

Line 1309: l_api_updating := ben_epe_shd.api_updating

1305: Begin
1306: --
1307: hr_utility.set_location('Entering:'||l_proc,5);
1308: --
1309: l_api_updating := ben_epe_shd.api_updating
1310: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1311: p_object_version_number => p_object_version_number);
1312: --
1313: if (l_api_updating

Line 1315: <> nvl(ben_epe_shd.g_old_rec.int_elig_per_elctbl_chc_id,hr_api.g_number)

1311: p_object_version_number => p_object_version_number);
1312: --
1313: if (l_api_updating
1314: and nvl(p_int_elig_per_elctbl_chc_id,hr_api.g_number)
1315: <> nvl(ben_epe_shd.g_old_rec.int_elig_per_elctbl_chc_id,hr_api.g_number)
1316: or not l_api_updating) and
1317: p_int_elig_per_elctbl_chc_id is not null then
1318: --
1319: -- check if int_elig_per_elctbl_chc_id value exists in table

Line 1331: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_FK18');

1327: --
1328: -- raise error as FK does not relate to PK in
1329: -- table.
1330: --
1331: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_FK18');
1332: --
1333: end if;
1334: --
1335: close c1;

Line 1387: l_api_updating := ben_epe_shd.api_updating

1383: Begin
1384: --
1385: hr_utility.set_location('Entering:'||l_proc,5);
1386: --
1387: l_api_updating := ben_epe_shd.api_updating
1388: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1389: p_object_version_number => p_object_version_number);
1390: --
1391: if (l_api_updating

Line 1393: <> nvl(ben_epe_shd.g_old_rec.yr_perd_id,hr_api.g_number)

1389: p_object_version_number => p_object_version_number);
1390: --
1391: if (l_api_updating
1392: and nvl(p_yr_perd_id,hr_api.g_number)
1393: <> nvl(ben_epe_shd.g_old_rec.yr_perd_id,hr_api.g_number)
1394: or not l_api_updating) and
1395: p_yr_perd_id is not null then
1396: --
1397: -- check if yr_perd_id value exists in ben_yr_perd table

Line 1409: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_FK15');

1405: --
1406: -- raise error as FK does not relate to PK in ben_yr_perd
1407: -- table.
1408: --
1409: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_FK15');
1410: --
1411: end if;
1412: --
1413: close c1;

Line 1464: l_api_updating := ben_epe_shd.api_updating

1460: /*
1461: hr_utility.set_location('Entering:'||l_proc, 5);
1462: */
1463: --
1464: l_api_updating := ben_epe_shd.api_updating
1465: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1466: p_object_version_number => p_object_version_number);
1467:
1468: if (l_api_updating

Line 1543: l_api_updating := ben_epe_shd.api_updating

1539: /*
1540: hr_utility.set_location('Entering:'||l_proc, 5);
1541: --
1542: */
1543: l_api_updating := ben_epe_shd.api_updating
1544: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1545: p_object_version_number => p_object_version_number);
1546: --
1547: /*

Line 1650: l_api_updating := ben_epe_shd.api_updating

1646: Begin
1647: --
1648: hr_utility.set_location('Entering:'||l_proc, 5);
1649: --
1650: l_api_updating := ben_epe_shd.api_updating
1651: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1652: p_object_version_number => p_object_version_number);
1653: --
1654: if (l_api_updating

Line 1656: <> ben_epe_shd.g_old_rec.enrt_cvg_strt_dt_rl

1652: p_object_version_number => p_object_version_number);
1653: --
1654: if (l_api_updating
1655: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
1656: <> ben_epe_shd.g_old_rec.enrt_cvg_strt_dt_rl
1657: or not l_api_updating)
1658: and p_enrt_cvg_strt_dt_rl is not null then
1659: --
1660: -- check if value of formula rule is valid.

Line 1745: l_api_updating := ben_epe_shd.api_updating

1741: Begin
1742: --
1743: hr_utility.set_location('Entering:'||l_proc, 5);
1744: --
1745: l_api_updating := ben_epe_shd.api_updating
1746: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1747: p_object_version_number => p_object_version_number);
1748: --
1749: if (l_api_updating

Line 1751: <> ben_epe_shd.g_old_rec.dpnt_cvg_strt_dt_rl

1747: p_object_version_number => p_object_version_number);
1748: --
1749: if (l_api_updating
1750: and nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
1751: <> ben_epe_shd.g_old_rec.dpnt_cvg_strt_dt_rl
1752: or not l_api_updating)
1753: and p_dpnt_cvg_strt_dt_rl is not null then
1754: --
1755: -- check if value of formula rule is valid.

Line 1860: Procedure insert_validate(p_rec in ben_epe_shd.g_rec_type

1856:
1857: -- ----------------------------------------------------------------------------
1858: -- |---------------------------< insert_validate >----------------------------|
1859: -- ----------------------------------------------------------------------------
1860: Procedure insert_validate(p_rec in ben_epe_shd.g_rec_type
1861: ,p_effective_date in date) is
1862: --
1863: l_proc varchar2(72) := g_package||'insert_validate';
1864: --

Line 1993: -- p_old_cd => ben_epe_shd.g_old_rec.rt_strt_dt_cd,

1989: -- chk_all_cds
1990: -- (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
1991: -- p_lookup_type => 'BEN_RT_STRT',
1992: -- p_cd => p_rec.rt_strt_dt_cd,
1993: -- p_old_cd => ben_epe_shd.g_old_rec.rt_strt_dt_cd,
1994: -- p_effective_date => p_effective_date,
1995: -- p_object_version_number => p_rec.object_version_number);
1996: --
1997: --

Line 2002: p_old_cd => ben_epe_shd.g_old_rec.enrt_cvg_strt_dt_cd,

1998: chk_all_cds
1999: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2000: p_lookup_type => 'BEN_ENRT_CVG_STRT',
2001: p_cd => p_rec.enrt_cvg_strt_dt_cd,
2002: p_old_cd => ben_epe_shd.g_old_rec.enrt_cvg_strt_dt_cd,
2003: p_effective_date => p_effective_date,
2004: p_object_version_number => p_rec.object_version_number);
2005: --
2006: --

Line 2011: p_old_cd => ben_epe_shd.g_old_rec.dpnt_cvg_strt_dt_cd,

2007: chk_all_cds
2008: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2009: p_lookup_type => 'BEN_DPNT_CVG_STRT',
2010: p_cd => p_rec.dpnt_cvg_strt_dt_cd,
2011: p_old_cd => ben_epe_shd.g_old_rec.dpnt_cvg_strt_dt_cd,
2012: p_effective_date => p_effective_date,
2013: p_object_version_number => p_rec.object_version_number);
2014: --
2015: chk_all_cds

Line 2019: p_old_cd => ben_epe_shd.g_old_rec.comp_lvl_cd,

2015: chk_all_cds
2016: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2017: p_lookup_type => 'BEN_COMP_LVL',
2018: p_cd => p_rec.comp_lvl_cd,
2019: p_old_cd => ben_epe_shd.g_old_rec.comp_lvl_cd,
2020: p_effective_date => p_effective_date,
2021: p_object_version_number => p_rec.object_version_number);
2022: --
2023: chk_all_cds

Line 2027: p_old_cd => ben_epe_shd.g_old_rec.ler_chg_dpnt_cvg_cd,

2023: chk_all_cds
2024: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2025: p_lookup_type => 'BEN_LER_CHG_DPNT_CVG',
2026: p_cd => p_rec.ler_chg_dpnt_cvg_cd,
2027: p_old_cd => ben_epe_shd.g_old_rec.ler_chg_dpnt_cvg_cd,
2028: p_effective_date => p_effective_date,
2029: p_object_version_number => p_rec.object_version_number);
2030: --
2031: chk_all_cds

Line 2035: p_old_cd => ben_epe_shd.g_old_rec.dpnt_dsgn_cd,

2031: chk_all_cds
2032: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2033: p_lookup_type => 'BEN_DPNT_DSGN',
2034: p_cd => p_rec.dpnt_dsgn_cd,
2035: p_old_cd => ben_epe_shd.g_old_rec.dpnt_dsgn_cd,
2036: p_effective_date => p_effective_date,
2037: p_object_version_number => p_rec.object_version_number);
2038: --cwb
2039: chk_all_cds

Line 2043: p_old_cd => ben_epe_shd.g_old_rec.inelig_rsn_cd,

2039: chk_all_cds
2040: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2041: p_lookup_type => 'BEN_INELIG_RSN',
2042: p_cd => p_rec.inelig_rsn_cd,
2043: p_old_cd => ben_epe_shd.g_old_rec.inelig_rsn_cd,
2044: p_effective_date => p_effective_date,
2045: p_object_version_number => p_rec.object_version_number);
2046: --cwb
2047: chk_all_flags

Line 2050: p_old_flag => ben_epe_shd.g_old_rec.alws_dpnt_dsgn_flag,

2046: --cwb
2047: chk_all_flags
2048: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2049: p_flag => p_rec.alws_dpnt_dsgn_flag,
2050: p_old_flag => ben_epe_shd.g_old_rec.alws_dpnt_dsgn_flag,
2051: p_effective_date => p_effective_date,
2052: p_object_version_number => p_rec.object_version_number);
2053: --
2054: chk_all_flags

Line 2057: p_old_flag => ben_epe_shd.g_old_rec.auto_enrt_flag,

2053: --
2054: chk_all_flags
2055: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2056: p_flag => p_rec.auto_enrt_flag,
2057: p_old_flag => ben_epe_shd.g_old_rec.auto_enrt_flag,
2058: p_effective_date => p_effective_date,
2059: p_object_version_number => p_rec.object_version_number);
2060: --
2061: chk_all_flags

Line 2064: p_old_flag => ben_epe_shd.g_old_rec.crntly_enrd_flag,

2060: --
2061: chk_all_flags
2062: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2063: p_flag => p_rec.crntly_enrd_flag,
2064: p_old_flag => ben_epe_shd.g_old_rec.crntly_enrd_flag,
2065: p_effective_date => p_effective_date,
2066: p_object_version_number => p_rec.object_version_number);
2067: --
2068: chk_all_flags

Line 2071: p_old_flag => ben_epe_shd.g_old_rec.dflt_flag,

2067: --
2068: chk_all_flags
2069: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2070: p_flag => p_rec.dflt_flag,
2071: p_old_flag => ben_epe_shd.g_old_rec.dflt_flag,
2072: p_effective_date => p_effective_date,
2073: p_object_version_number => p_rec.object_version_number);
2074: --
2075: chk_all_flags

Line 2078: p_old_flag => ben_epe_shd.g_old_rec.elctbl_flag,

2074: --
2075: chk_all_flags
2076: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2077: p_flag => p_rec.elctbl_flag,
2078: p_old_flag => ben_epe_shd.g_old_rec.elctbl_flag,
2079: p_effective_date => p_effective_date,
2080: p_object_version_number => p_rec.object_version_number);
2081: --
2082: chk_all_flags

Line 2085: p_old_flag => ben_epe_shd.g_old_rec.mndtry_flag,

2081: --
2082: chk_all_flags
2083: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2084: p_flag => p_rec.mndtry_flag,
2085: p_old_flag => ben_epe_shd.g_old_rec.mndtry_flag,
2086: p_effective_date => p_effective_date,
2087: p_object_version_number => p_rec.object_version_number);
2088: /** Temporarily commented
2089: --cwb

Line 2093: p_old_flag => ben_epe_shd.g_old_rec.elig_flag,

2089: --cwb
2090: chk_all_flags
2091: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2092: p_flag => p_rec.elig_flag,
2093: p_old_flag => ben_epe_shd.g_old_rec.elig_flag,
2094: p_effective_date => p_effective_date,
2095: p_object_version_number => p_rec.object_version_number);
2096: --cwb
2097: */

Line 2103: p_old_flag => ben_epe_shd.g_old_rec.mndtry_flag,

2099: /*
2100: chk_all_flags
2101: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2102: p_flag => p_rec.in_pndg_wkflow_flag,
2103: p_old_flag => ben_epe_shd.g_old_rec.mndtry_flag,
2104: p_effective_date => p_effective_date,
2105: p_object_version_number => p_rec.object_version_number);
2106: */
2107: --

Line 2111: p_old_flag => ben_epe_shd.g_old_rec.roll_crs_flag,

2107: --
2108: chk_all_flags
2109: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2110: p_flag => p_rec.roll_crs_flag,
2111: p_old_flag => ben_epe_shd.g_old_rec.roll_crs_flag,
2112: p_effective_date => p_effective_date,
2113: p_object_version_number => p_rec.object_version_number);
2114: --
2115: chk_enrt_cvg_strt_dt_rl

Line 2135: Procedure update_validate(p_rec in ben_epe_shd.g_rec_type,

2131: --
2132: -- ----------------------------------------------------------------------------
2133: -- |---------------------------< update_validate >----------------------------|
2134: -- ----------------------------------------------------------------------------
2135: Procedure update_validate(p_rec in ben_epe_shd.g_rec_type,
2136: p_effective_date in date) is
2137: --
2138: l_proc varchar2(72) := g_package||'update_validate';
2139: --

Line 2268: -- p_old_cd => ben_epe_shd.g_old_rec.rt_strt_dt_cd,

2264: -- chk_all_cds
2265: -- (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2266: -- p_lookup_type => 'BEN_RT_STRT',
2267: -- p_cd => p_rec.rt_strt_dt_cd,
2268: -- p_old_cd => ben_epe_shd.g_old_rec.rt_strt_dt_cd,
2269: -- p_effective_date => p_effective_date,
2270: -- p_object_version_number => p_rec.object_version_number);
2271: --
2272: --

Line 2277: p_old_cd => ben_epe_shd.g_old_rec.enrt_cvg_strt_dt_cd,

2273: chk_all_cds
2274: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2275: p_lookup_type => 'BEN_ENRT_CVG_STRT',
2276: p_cd => p_rec.enrt_cvg_strt_dt_cd,
2277: p_old_cd => ben_epe_shd.g_old_rec.enrt_cvg_strt_dt_cd,
2278: p_effective_date => p_effective_date,
2279: p_object_version_number => p_rec.object_version_number);
2280: --
2281: --

Line 2286: p_old_cd => ben_epe_shd.g_old_rec.dpnt_cvg_strt_dt_cd,

2282: chk_all_cds
2283: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2284: p_lookup_type => 'BEN_DPNT_CVG_STRT',
2285: p_cd => p_rec.dpnt_cvg_strt_dt_cd,
2286: p_old_cd => ben_epe_shd.g_old_rec.dpnt_cvg_strt_dt_cd,
2287: p_effective_date => p_effective_date,
2288: p_object_version_number => p_rec.object_version_number);
2289: --
2290: chk_all_cds

Line 2294: p_old_cd => ben_epe_shd.g_old_rec.comp_lvl_cd,

2290: chk_all_cds
2291: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2292: p_lookup_type => 'BEN_COMP_LVL',
2293: p_cd => p_rec.comp_lvl_cd,
2294: p_old_cd => ben_epe_shd.g_old_rec.comp_lvl_cd,
2295: p_effective_date => p_effective_date,
2296: p_object_version_number => p_rec.object_version_number);
2297: --
2298: chk_all_cds

Line 2302: p_old_cd => ben_epe_shd.g_old_rec.ler_chg_dpnt_cvg_cd,

2298: chk_all_cds
2299: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2300: p_lookup_type => 'BEN_LER_CHG_DPNT_CVG',
2301: p_cd => p_rec.ler_chg_dpnt_cvg_cd,
2302: p_old_cd => ben_epe_shd.g_old_rec.ler_chg_dpnt_cvg_cd,
2303: p_effective_date => p_effective_date,
2304: p_object_version_number => p_rec.object_version_number);
2305: --
2306: chk_all_cds

Line 2310: p_old_cd => ben_epe_shd.g_old_rec.dpnt_dsgn_cd,

2306: chk_all_cds
2307: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2308: p_lookup_type => 'BEN_DPNT_DSGN',
2309: p_cd => p_rec.dpnt_dsgn_cd,
2310: p_old_cd => ben_epe_shd.g_old_rec.dpnt_dsgn_cd,
2311: p_effective_date => p_effective_date,
2312: p_object_version_number => p_rec.object_version_number);
2313: --
2314: --cwb

Line 2319: p_old_cd => ben_epe_shd.g_old_rec.inelig_rsn_cd,

2315: chk_all_cds
2316: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2317: p_lookup_type => 'BEN_INELIG_RSN',
2318: p_cd => p_rec.inelig_rsn_cd,
2319: p_old_cd => ben_epe_shd.g_old_rec.inelig_rsn_cd,
2320: p_effective_date => p_effective_date,
2321: p_object_version_number => p_rec.object_version_number);
2322: --cwb
2323: /** Temporarily commented

Line 2328: p_old_flag => ben_epe_shd.g_old_rec.elig_flag,

2324: --cwb
2325: chk_all_flags
2326: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2327: p_flag => p_rec.elig_flag,
2328: p_old_flag => ben_epe_shd.g_old_rec.elig_flag,
2329: p_effective_date => p_effective_date,
2330: p_object_version_number => p_rec.object_version_number);
2331: --cwb
2332: */

Line 2336: p_old_flag => ben_epe_shd.g_old_rec.alws_dpnt_dsgn_flag,

2332: */
2333: chk_all_flags
2334: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2335: p_flag => p_rec.alws_dpnt_dsgn_flag,
2336: p_old_flag => ben_epe_shd.g_old_rec.alws_dpnt_dsgn_flag,
2337: p_effective_date => p_effective_date,
2338: p_object_version_number => p_rec.object_version_number);
2339: --
2340: chk_all_flags

Line 2343: p_old_flag => ben_epe_shd.g_old_rec.auto_enrt_flag,

2339: --
2340: chk_all_flags
2341: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2342: p_flag => p_rec.auto_enrt_flag,
2343: p_old_flag => ben_epe_shd.g_old_rec.auto_enrt_flag,
2344: p_effective_date => p_effective_date,
2345: p_object_version_number => p_rec.object_version_number);
2346: --
2347: chk_all_flags

Line 2350: p_old_flag => ben_epe_shd.g_old_rec.crntly_enrd_flag,

2346: --
2347: chk_all_flags
2348: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2349: p_flag => p_rec.crntly_enrd_flag,
2350: p_old_flag => ben_epe_shd.g_old_rec.crntly_enrd_flag,
2351: p_effective_date => p_effective_date,
2352: p_object_version_number => p_rec.object_version_number);
2353: --
2354: chk_all_flags

Line 2357: p_old_flag => ben_epe_shd.g_old_rec.dflt_flag,

2353: --
2354: chk_all_flags
2355: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2356: p_flag => p_rec.dflt_flag,
2357: p_old_flag => ben_epe_shd.g_old_rec.dflt_flag,
2358: p_effective_date => p_effective_date,
2359: p_object_version_number => p_rec.object_version_number);
2360: --
2361: chk_all_flags

Line 2364: p_old_flag => ben_epe_shd.g_old_rec.elctbl_flag,

2360: --
2361: chk_all_flags
2362: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2363: p_flag => p_rec.elctbl_flag,
2364: p_old_flag => ben_epe_shd.g_old_rec.elctbl_flag,
2365: p_effective_date => p_effective_date,
2366: p_object_version_number => p_rec.object_version_number);
2367: --
2368: chk_all_flags

Line 2371: p_old_flag => ben_epe_shd.g_old_rec.mndtry_flag,

2367: --
2368: chk_all_flags
2369: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2370: p_flag => p_rec.mndtry_flag,
2371: p_old_flag => ben_epe_shd.g_old_rec.mndtry_flag,
2372: p_effective_date => p_effective_date,
2373: p_object_version_number => p_rec.object_version_number);
2374: -- bug 1830930
2375: /*

Line 2379: p_old_flag => ben_epe_shd.g_old_rec.mndtry_flag,

2375: /*
2376: chk_all_flags
2377: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2378: p_flag => p_rec.in_pndg_wkflow_flag,
2379: p_old_flag => ben_epe_shd.g_old_rec.mndtry_flag,
2380: p_effective_date => p_effective_date,
2381: p_object_version_number => p_rec.object_version_number);
2382: */
2383: --

Line 2387: p_old_flag => ben_epe_shd.g_old_rec.roll_crs_flag,

2383: --
2384: chk_all_flags
2385: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2386: p_flag => p_rec.roll_crs_flag,
2387: p_old_flag => ben_epe_shd.g_old_rec.roll_crs_flag,
2388: p_effective_date => p_effective_date,
2389: p_object_version_number => p_rec.object_version_number);
2390: --
2391: chk_enrt_cvg_strt_dt_rl

Line 2411: Procedure delete_validate(p_rec in ben_epe_shd.g_rec_type

2407: --
2408: -- ----------------------------------------------------------------------------
2409: -- |---------------------------< delete_validate >----------------------------|
2410: -- ----------------------------------------------------------------------------
2411: Procedure delete_validate(p_rec in ben_epe_shd.g_rec_type
2412: ,p_effective_date in date) is
2413: --
2414: l_proc varchar2(72) := g_package||'delete_validate';
2415: --