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_PEL_BUS dependencies on BEN_PEL_SHD

Line 46: l_api_updating := ben_pel_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_pel_shd.api_updating
47: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> ben_pel_shd.g_old_rec.pil_elctbl_chc_popl_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_pil_elctbl_chc_popl_id,hr_api.g_number)
52: <> ben_pel_shd.g_old_rec.pil_elctbl_chc_popl_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_PK');

Line 56: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_PK');

52: <> ben_pel_shd.g_old_rec.pil_elctbl_chc_popl_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_PK');

62: if p_pil_elctbl_chc_popl_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_PK');
67: --
68: end if;
69: --
70: end if;

Line 118: l_api_updating := ben_pel_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc, 5);
117: --
118: l_api_updating := ben_pel_shd.api_updating
119: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating

Line 124: <> nvl(ben_pel_shd.g_old_rec.uom,hr_api.g_varchar2)

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

Line 195: l_api_updating := ben_pel_shd.api_updating

191: Begin
192: --
193: hr_utility.set_location('Entering:'||l_proc,5);
194: --
195: l_api_updating := ben_pel_shd.api_updating
196: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
197: p_object_version_number => p_object_version_number);
198: --
199: if (l_api_updating

Line 201: <> nvl(ben_pel_shd.g_old_rec.per_in_ler_id,hr_api.g_number)

197: p_object_version_number => p_object_version_number);
198: --
199: if (l_api_updating
200: and nvl(p_per_in_ler_id,hr_api.g_number)
201: <> nvl(ben_pel_shd.g_old_rec.per_in_ler_id,hr_api.g_number)
202: or not l_api_updating) then
203: --
204: -- check if per_in_ler_id value exists in ben_per_in_ler table
205: --

Line 216: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_DT2');

212: --
213: -- raise error as FK does not relate to PK in ben_per_in_ler
214: -- table.
215: --
216: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_DT2');
217: --
218: end if;
219: --
220: close c1;

Line 275: l_api_updating := ben_pel_shd.api_updating

271: Begin
272: --
273: hr_utility.set_location('Entering:'||l_proc,5);
274: --
275: l_api_updating := ben_pel_shd.api_updating
276: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
277: p_object_version_number => p_object_version_number);
278: --
279: if (l_api_updating

Line 281: <> nvl(ben_pel_shd.g_old_rec.lee_rsn_id,hr_api.g_number)

277: p_object_version_number => p_object_version_number);
278: --
279: if (l_api_updating
280: and nvl(p_lee_rsn_id,hr_api.g_number)
281: <> nvl(ben_pel_shd.g_old_rec.lee_rsn_id,hr_api.g_number)
282: or not l_api_updating) then
283: --
284: -- check if lee_rsn_id value exists in ben_lee_rsn_f table
285: --

Line 296: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_DT1');

292: --
293: -- raise error as FK does not relate to PK in ben_lee_rsn_f
294: -- table.
295: --
296: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_DT1');
297: --
298: end if;
299: --
300: close c1;

Line 350: l_api_updating := ben_pel_shd.api_updating

346: Begin
347: --
348: hr_utility.set_location('Entering:'||l_proc,5);
349: --
350: l_api_updating := ben_pel_shd.api_updating
351: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
352: p_object_version_number => p_object_version_number);
353: --
354: if ((l_api_updating

Line 356: <> nvl(ben_pel_shd.g_old_rec.enrt_perd_id,hr_api.g_number)) --Bug 4068639

352: p_object_version_number => p_object_version_number);
353: --
354: if ((l_api_updating
355: and nvl(p_enrt_perd_id,hr_api.g_number)
356: <> nvl(ben_pel_shd.g_old_rec.enrt_perd_id,hr_api.g_number)) --Bug 4068639
357: or not l_api_updating) and
358: p_enrt_perd_id is not null then
359: --
360: -- check if enrt_perd_id value exists in ben_enrt_perd table

Line 372: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_FK1');

368: --
369: -- raise error as FK does not relate to PK in ben_enrt_perd
370: -- table.
371: --
372: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_FK1');
373: --
374: end if;
375: --
376: close c1;

Line 422: l_api_updating := ben_pel_shd.api_updating

418: Begin
419: --
420: hr_utility.set_location('Entering:'||l_proc, 5);
421: --
422: l_api_updating := ben_pel_shd.api_updating
423: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
424: p_object_version_number => p_object_version_number);
425: --
426: if (l_api_updating

Line 428: <> nvl(ben_pel_shd.g_old_rec.enrt_typ_cycl_cd,hr_api.g_varchar2)

424: p_object_version_number => p_object_version_number);
425: --
426: if (l_api_updating
427: and p_enrt_typ_cycl_cd
428: <> nvl(ben_pel_shd.g_old_rec.enrt_typ_cycl_cd,hr_api.g_varchar2)
429: or not l_api_updating)
430: and p_enrt_typ_cycl_cd is not null then
431: --
432: -- check if value of lookup falls within lookup type.

Line 492: l_api_updating := ben_pel_shd.api_updating

488: Begin
489: --
490: hr_utility.set_location('Entering:'||l_proc, 5);
491: --
492: l_api_updating := ben_pel_shd.api_updating
493: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
494: p_object_version_number => p_object_version_number);
495: --
496: if (l_api_updating

Line 498: <> nvl(ben_pel_shd.g_old_rec.ws_stat_cd,hr_api.g_varchar2)

494: p_object_version_number => p_object_version_number);
495: --
496: if (l_api_updating
497: and p_ws_stat_cd
498: <> nvl(ben_pel_shd.g_old_rec.ws_stat_cd,hr_api.g_varchar2)
499: or not l_api_updating)
500: and p_ws_stat_cd is not null then
501: --
502: -- check if value of lookup falls within lookup type.

Line 562: l_api_updating := ben_pel_shd.api_updating

558: Begin
559: --
560: hr_utility.set_location('Entering:'||l_proc, 5);
561: --
562: l_api_updating := ben_pel_shd.api_updating
563: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
564: p_object_version_number => p_object_version_number);
565: --
566: if (l_api_updating

Line 568: <> nvl(ben_pel_shd.g_old_rec.ws_acc_cd,hr_api.g_varchar2)

564: p_object_version_number => p_object_version_number);
565: --
566: if (l_api_updating
567: and p_ws_acc_cd
568: <> nvl(ben_pel_shd.g_old_rec.ws_acc_cd,hr_api.g_varchar2)
569: or not l_api_updating)
570: and p_ws_acc_cd is not null then
571: --
572: -- check if value of lookup falls within lookup type.

Line 632: l_api_updating := ben_pel_shd.api_updating

628: Begin
629: --
630: hr_utility.set_location('Entering:'||l_proc, 5);
631: --
632: l_api_updating := ben_pel_shd.api_updating
633: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
634: p_object_version_number => p_object_version_number);
635: --
636: if (l_api_updating

Line 638: <> nvl(ben_pel_shd.g_old_rec.bdgt_stat_cd,hr_api.g_varchar2)

634: p_object_version_number => p_object_version_number);
635: --
636: if (l_api_updating
637: and p_bdgt_stat_cd
638: <> nvl(ben_pel_shd.g_old_rec.bdgt_stat_cd,hr_api.g_varchar2)
639: or not l_api_updating)
640: and p_bdgt_stat_cd is not null then
641: --
642: -- check if value of lookup falls within lookup type.

Line 702: l_api_updating := ben_pel_shd.api_updating

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

Line 708: <> nvl(ben_pel_shd.g_old_rec.pop_cd,hr_api.g_varchar2)

704: p_object_version_number => p_object_version_number);
705: --
706: if (l_api_updating
707: and p_pop_cd
708: <> nvl(ben_pel_shd.g_old_rec.pop_cd,hr_api.g_varchar2)
709: or not l_api_updating)
710: and p_pop_cd is not null then
711: --
712: -- check if value of lookup falls within lookup type.

Line 772: l_api_updating := ben_pel_shd.api_updating

768: Begin
769: --
770: hr_utility.set_location('Entering:'||l_proc, 5);
771: --
772: l_api_updating := ben_pel_shd.api_updating
773: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
774: p_object_version_number => p_object_version_number);
775: --
776: if (l_api_updating

Line 778: <> nvl(ben_pel_shd.g_old_rec.bdgt_acc_cd,hr_api.g_varchar2)

774: p_object_version_number => p_object_version_number);
775: --
776: if (l_api_updating
777: and p_bdgt_acc_cd
778: <> nvl(ben_pel_shd.g_old_rec.bdgt_acc_cd,hr_api.g_varchar2)
779: or not l_api_updating)
780: and p_bdgt_acc_cd is not null then
781: --
782: -- check if value of lookup falls within lookup type.

Line 842: l_api_updating := ben_pel_shd.api_updating

838: Begin
839: --
840: hr_utility.set_location('Entering:'||l_proc, 5);
841: --
842: l_api_updating := ben_pel_shd.api_updating
843: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
844: p_object_version_number => p_object_version_number);
845: --
846: if (l_api_updating

Line 848: <> nvl(ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd,hr_api.g_varchar2)

844: p_object_version_number => p_object_version_number);
845: --
846: if (l_api_updating
847: and p_cls_enrt_dt_to_use_cd
848: <> nvl(ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd,hr_api.g_varchar2)
849: or not l_api_updating)
850: and p_cls_enrt_dt_to_use_cd is not null then
851: --
852: -- check if value of lookup falls within lookup type.

Line 912: l_api_updating := ben_pel_shd.api_updating

908: Begin
909: --
910: hr_utility.set_location('Entering:'||l_proc, 5);
911: --
912: l_api_updating := ben_pel_shd.api_updating
913: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
914: p_object_version_number => p_object_version_number);
915: --
916: if (l_api_updating

Line 918: <> nvl(ben_pel_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)

914: p_object_version_number => p_object_version_number);
915: --
916: if (l_api_updating
917: and p_acty_ref_perd_cd
918: <> nvl(ben_pel_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)
919: or not l_api_updating)
920: and p_acty_ref_perd_cd is not null then
921: --
922: -- check if value of lookup falls within lookup type.

Line 982: l_api_updating := ben_pel_shd.api_updating

978: Begin
979: --
980: hr_utility.set_location('Entering:'||l_proc, 5);
981: --
982: l_api_updating := ben_pel_shd.api_updating
983: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
984: p_object_version_number => p_object_version_number);
985: --
986: if (l_api_updating

Line 988: <> nvl(ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd,hr_api.g_varchar2)

984: p_object_version_number => p_object_version_number);
985: --
986: if (l_api_updating
987: and p_pil_elctbl_popl_stat_cd
988: <> nvl(ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd,hr_api.g_varchar2)
989: or not l_api_updating)
990: and p_pil_elctbl_popl_stat_cd is not null then
991: --
992: -- check if value of lookup falls within lookup type.

Line 1027: l_api_updating := ben_pel_shd.api_updating

1023: Begin
1024: --
1025: hr_utility.set_location('Entering:'||l_proc, 5);
1026: --
1027: l_api_updating := ben_pel_shd.api_updating
1028: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
1029: p_object_version_number => p_object_version_number);
1030: --
1031: if (l_api_updating

Line 1033: <> nvl(ben_pel_shd.g_old_rec.reinstate_cd,hr_api.g_varchar2)

1029: p_object_version_number => p_object_version_number);
1030: --
1031: if (l_api_updating
1032: and p_reinstate_cd
1033: <> nvl(ben_pel_shd.g_old_rec.reinstate_cd,hr_api.g_varchar2)
1034: or not l_api_updating)
1035: and p_reinstate_cd is not null then
1036: --
1037: -- check if value of lookup falls within lookup type.

Line 1072: l_api_updating := ben_pel_shd.api_updating

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

Line 1078: <> nvl(ben_pel_shd.g_old_rec.reinstate_ovrdn_cd,hr_api.g_varchar2)

1074: p_object_version_number => p_object_version_number);
1075: --
1076: if (l_api_updating
1077: and p_reinstate_ovrdn_cd
1078: <> nvl(ben_pel_shd.g_old_rec.reinstate_ovrdn_cd,hr_api.g_varchar2)
1079: or not l_api_updating)
1080: and p_reinstate_ovrdn_cd is not null then
1081: --
1082: -- check if value of lookup falls within lookup type.

Line 1176: l_api_updating := ben_pel_shd.api_updating

1172: fetch get_system_date into l_system_date;
1173: close get_system_date;
1174: */ -- Bug 3653034
1175: --
1176: l_api_updating := ben_pel_shd.api_updating
1177: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
1178: p_object_version_number => p_object_version_number);
1179: --
1180: -- hr_utility.set_location('Me here :'||l_proc, 8);

Line 1183: <> nvl(ben_pel_shd.g_old_rec.enrt_perd_end_dt,hr_api.g_date)) then

1179: --
1180: -- hr_utility.set_location('Me here :'||l_proc, 8);
1181: if (l_api_updating
1182: and p_enrt_perd_end_dt
1183: <> nvl(ben_pel_shd.g_old_rec.enrt_perd_end_dt,hr_api.g_date)) then
1184: If p_pil_elctbl_popl_stat_cd = 'STRTD' then
1185: /*
1186: if (trunc(p_enrt_perd_end_dt) < trunc(l_system_date)) then
1187: fnd_message.set_name('BEN','BEN_92298_ENRT_PEREND_LT_SYSD');

Line 1202: <> nvl(ben_pel_shd.g_old_rec.dflt_enrt_dt,hr_api.g_date)) then

1198: -- hr_utility.set_location('Me here :'||l_proc, 10);
1199: --
1200: if (l_api_updating
1201: and p_dflt_enrt_dt
1202: <> nvl(ben_pel_shd.g_old_rec.dflt_enrt_dt,hr_api.g_date)) then
1203: If p_pil_elctbl_popl_stat_cd = 'STRTD' then
1204: If p_dflt_asnd_dt is not null then
1205: fnd_message.set_name('BEN','BEN_92295_DFLT_ENRT_W_ASND');
1206: fnd_message.raise_error;

Line 1292: <> nvl(ben_pel_shd.g_old_rec.ws_mgr_id,hr_api.g_number)) then

1288:
1289: hr_utility.set_location(' Entering:'||l_proc, 10);
1290:
1291: if (p_ws_mgr_id
1292: <> nvl(ben_pel_shd.g_old_rec.ws_mgr_id,hr_api.g_number)) then
1293:
1294: open c1;
1295: fetch c1 into l_person1,l_person2;
1296: if c1%found then

Line 1312: Procedure insert_validate(p_rec in ben_pel_shd.g_rec_type

1308: end chk_ws_mgr_id;
1309: -- ----------------------------------------------------------------------------
1310: -- |---------------------------< insert_validate >----------------------------|
1311: -- ----------------------------------------------------------------------------
1312: Procedure insert_validate(p_rec in ben_pel_shd.g_rec_type
1313: ,p_effective_date in date) is
1314: --
1315: l_proc varchar2(72) := g_package||'insert_validate';
1316: --

Line 1433: Procedure update_validate(p_rec in ben_pel_shd.g_rec_type

1429: --
1430: -- ----------------------------------------------------------------------------
1431: -- |---------------------------< update_validate >----------------------------|
1432: -- ----------------------------------------------------------------------------
1433: Procedure update_validate(p_rec in ben_pel_shd.g_rec_type
1434: ,p_effective_date in date) is
1435: --
1436: l_proc varchar2(72) := g_package||'update_validate';
1437: --

Line 1573: Procedure delete_validate(p_rec in ben_pel_shd.g_rec_type

1569: --
1570: -- ----------------------------------------------------------------------------
1571: -- |---------------------------< delete_validate >----------------------------|
1572: -- ----------------------------------------------------------------------------
1573: Procedure delete_validate(p_rec in ben_pel_shd.g_rec_type
1574: ,p_effective_date in date) is
1575: --
1576: l_proc varchar2(72) := g_package||'delete_validate';
1577: