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_BLI_BUS dependencies on BEN_BLI_SHD

Line 46: l_api_updating := ben_bli_shd.api_updating

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

Line 52: <> ben_bli_shd.g_old_rec.batch_ler_id) then

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

Line 56: ben_bli_shd.constraint_error('BEN_BATCH_LER_INFO_PK');

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

Line 66: ben_bli_shd.constraint_error('BEN_BATCH_LER_INFO_PK');

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

Line 123: l_api_updating := ben_bli_shd.api_updating

119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_bli_shd.api_updating
124: (p_batch_ler_id => p_batch_ler_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating

Line 129: <> nvl(ben_bli_shd.g_old_rec.ler_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_ler_id,hr_api.g_number)
129: <> nvl(ben_bli_shd.g_old_rec.ler_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if ler_id value exists in ben_ler_f table
133: --

Line 144: ben_bli_shd.constraint_error('BEN_BATCH_LER_INFO_DT2');

140: --
141: -- raise error as FK does not relate to PK in ben_ler_f
142: -- table.
143: --
144: ben_bli_shd.constraint_error('BEN_BATCH_LER_INFO_DT2');
145: --
146: end if;
147: --
148: close c1;

Line 203: l_api_updating := ben_bli_shd.api_updating

199: Begin
200: --
201: hr_utility.set_location('Entering:'||l_proc,5);
202: --
203: l_api_updating := ben_bli_shd.api_updating
204: (p_batch_ler_id => p_batch_ler_id,
205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating

Line 209: <> nvl(ben_bli_shd.g_old_rec.person_id,hr_api.g_number)

205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and nvl(p_person_id,hr_api.g_number)
209: <> nvl(ben_bli_shd.g_old_rec.person_id,hr_api.g_number)
210: or not l_api_updating) then
211: --
212: -- check if person_id value exists in per_all_people_f table
213: --

Line 224: ben_bli_shd.constraint_error('BEN_BATCH_LER_INFO_DT1');

220: --
221: -- raise error as FK does not relate to PK in per_all_people_f
222: -- table.
223: --
224: ben_bli_shd.constraint_error('BEN_BATCH_LER_INFO_DT1');
225: --
226: end if;
227: --
228: close c1;

Line 278: l_api_updating := ben_bli_shd.api_updating

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

Line 284: <> nvl(ben_bli_shd.g_old_rec.benefit_action_id,hr_api.g_number)

280: p_object_version_number => p_object_version_number);
281: --
282: if (l_api_updating
283: and nvl(p_benefit_action_id,hr_api.g_number)
284: <> nvl(ben_bli_shd.g_old_rec.benefit_action_id,hr_api.g_number)
285: or not l_api_updating) then
286: --
287: -- check if benefit_action_id value exists in ben_benefit_actions table
288: --

Line 299: ben_bli_shd.constraint_error('BEN_BATCH_LER_INFO_FK1');

295: --
296: -- raise error as FK does not relate to PK in ben_benefit_actions
297: -- table.
298: --
299: ben_bli_shd.constraint_error('BEN_BATCH_LER_INFO_FK1');
300: --
301: end if;
302: --
303: close c1;

Line 349: l_api_updating := ben_bli_shd.api_updating

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

Line 355: <> nvl(ben_bli_shd.g_old_rec.dltd_flag,hr_api.g_varchar2)

351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and p_dltd_flag
355: <> nvl(ben_bli_shd.g_old_rec.dltd_flag,hr_api.g_varchar2)
356: or not l_api_updating) then
357: --
358: -- check if value of lookup falls within lookup type.
359: --

Line 419: l_api_updating := ben_bli_shd.api_updating

415: Begin
416: --
417: hr_utility.set_location('Entering:'||l_proc, 5);
418: --
419: l_api_updating := ben_bli_shd.api_updating
420: (p_batch_ler_id => p_batch_ler_id,
421: p_object_version_number => p_object_version_number);
422: --
423: if (l_api_updating

Line 425: <> nvl(ben_bli_shd.g_old_rec.tmprl_flag,hr_api.g_varchar2)

421: p_object_version_number => p_object_version_number);
422: --
423: if (l_api_updating
424: and p_tmprl_flag
425: <> nvl(ben_bli_shd.g_old_rec.tmprl_flag,hr_api.g_varchar2)
426: or not l_api_updating) then
427: --
428: -- check if value of lookup falls within lookup type.
429: --

Line 489: l_api_updating := ben_bli_shd.api_updating

485: Begin
486: --
487: hr_utility.set_location('Entering:'||l_proc, 5);
488: --
489: l_api_updating := ben_bli_shd.api_updating
490: (p_batch_ler_id => p_batch_ler_id,
491: p_object_version_number => p_object_version_number);
492: --
493: if (l_api_updating

Line 495: <> nvl(ben_bli_shd.g_old_rec.crtd_flag,hr_api.g_varchar2)

491: p_object_version_number => p_object_version_number);
492: --
493: if (l_api_updating
494: and p_crtd_flag
495: <> nvl(ben_bli_shd.g_old_rec.crtd_flag,hr_api.g_varchar2)
496: or not l_api_updating) then
497: --
498: -- check if value of lookup falls within lookup type.
499: --

Line 559: l_api_updating := ben_bli_shd.api_updating

555: Begin
556: --
557: hr_utility.set_location('Entering:'||l_proc, 5);
558: --
559: l_api_updating := ben_bli_shd.api_updating
560: (p_batch_ler_id => p_batch_ler_id,
561: p_object_version_number => p_object_version_number);
562: --
563: if (l_api_updating

Line 565: <> nvl(ben_bli_shd.g_old_rec.clpsd_flag,hr_api.g_varchar2)

561: p_object_version_number => p_object_version_number);
562: --
563: if (l_api_updating
564: and p_clpsd_flag
565: <> nvl(ben_bli_shd.g_old_rec.clpsd_flag,hr_api.g_varchar2)
566: or not l_api_updating) then
567: --
568: -- check if value of lookup falls within lookup type.
569: --

Line 628: l_api_updating := ben_bli_shd.api_updating

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

Line 634: <> nvl(ben_bli_shd.g_old_rec.clsn_flag,hr_api.g_varchar2)

630: p_object_version_number => p_object_version_number);
631: --
632: if (l_api_updating
633: and p_clsn_flag
634: <> nvl(ben_bli_shd.g_old_rec.clsn_flag,hr_api.g_varchar2)
635: or not l_api_updating) then
636: --
637: -- check if value of lookup falls within lookup type.
638: --

Line 697: l_api_updating := ben_bli_shd.api_updating

693: Begin
694: --
695: hr_utility.set_location('Entering:'||l_proc, 5);
696: --
697: l_api_updating := ben_bli_shd.api_updating
698: (p_batch_ler_id => p_batch_ler_id,
699: p_object_version_number => p_object_version_number);
700: --
701: if (l_api_updating

Line 703: <> nvl(ben_bli_shd.g_old_rec.no_effect_flag,hr_api.g_varchar2)

699: p_object_version_number => p_object_version_number);
700: --
701: if (l_api_updating
702: and p_no_effect_flag
703: <> nvl(ben_bli_shd.g_old_rec.no_effect_flag,hr_api.g_varchar2)
704: or not l_api_updating) then
705: --
706: -- check if value of lookup falls within lookup type.
707: --

Line 766: l_api_updating := ben_bli_shd.api_updating

762: Begin
763: --
764: hr_utility.set_location('Entering:'||l_proc, 5);
765: --
766: l_api_updating := ben_bli_shd.api_updating
767: (p_batch_ler_id => p_batch_ler_id,
768: p_object_version_number => p_object_version_number);
769: --
770: if (l_api_updating

Line 772: <> nvl(ben_bli_shd.g_old_rec.cvrge_rt_prem_flag,hr_api.g_varchar2)

768: p_object_version_number => p_object_version_number);
769: --
770: if (l_api_updating
771: and p_cvrge_rt_prem_flag
772: <> nvl(ben_bli_shd.g_old_rec.cvrge_rt_prem_flag,hr_api.g_varchar2)
773: or not l_api_updating) then
774: --
775: -- check if value of lookup falls within lookup type.
776: --

Line 835: l_api_updating := ben_bli_shd.api_updating

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

Line 841: <> nvl(ben_bli_shd.g_old_rec.replcd_flag,hr_api.g_varchar2)

837: p_object_version_number => p_object_version_number);
838: --
839: if (l_api_updating
840: and p_replcd_flag
841: <> nvl(ben_bli_shd.g_old_rec.replcd_flag,hr_api.g_varchar2)
842: or not l_api_updating) then
843: --
844: -- check if value of lookup falls within lookup type.
845: --

Line 905: l_api_updating := ben_bli_shd.api_updating

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

Line 911: <> nvl(ben_bli_shd.g_old_rec.open_and_clsd_flag,hr_api.g_varchar2)

907: p_object_version_number => p_object_version_number);
908: --
909: if (l_api_updating
910: and p_open_and_clsd_flag
911: <> nvl(ben_bli_shd.g_old_rec.open_and_clsd_flag,hr_api.g_varchar2)
912: or not l_api_updating) then
913: --
914: -- check if value of lookup falls within lookup type.
915: --

Line 974: l_api_updating := ben_bli_shd.api_updating

970: Begin
971: --
972: hr_utility.set_location('Entering:'||l_proc, 5);
973: --
974: l_api_updating := ben_bli_shd.api_updating
975: (p_batch_ler_id => p_batch_ler_id,
976: p_object_version_number => p_object_version_number);
977: --
978: if (l_api_updating

Line 980: <> nvl(ben_bli_shd.g_old_rec.clsd_flag,hr_api.g_varchar2)

976: p_object_version_number => p_object_version_number);
977: --
978: if (l_api_updating
979: and p_clsd_flag
980: <> nvl(ben_bli_shd.g_old_rec.clsd_flag,hr_api.g_varchar2)
981: or not l_api_updating) then
982: --
983: -- check if value of lookup falls within lookup type.
984: --

Line 1043: l_api_updating := ben_bli_shd.api_updating

1039: Begin
1040: --
1041: hr_utility.set_location('Entering:'||l_proc, 5);
1042: --
1043: l_api_updating := ben_bli_shd.api_updating
1044: (p_batch_ler_id => p_batch_ler_id,
1045: p_object_version_number => p_object_version_number);
1046: --
1047: if (l_api_updating

Line 1049: <> nvl(ben_bli_shd.g_old_rec.not_crtd_flag,hr_api.g_varchar2)

1045: p_object_version_number => p_object_version_number);
1046: --
1047: if (l_api_updating
1048: and p_not_crtd_flag
1049: <> nvl(ben_bli_shd.g_old_rec.not_crtd_flag,hr_api.g_varchar2)
1050: or not l_api_updating) then
1051: --
1052: -- check if value of lookup falls within lookup type.
1053: --

Line 1112: l_api_updating := ben_bli_shd.api_updating

1108: Begin
1109: --
1110: hr_utility.set_location('Entering:'||l_proc, 5);
1111: --
1112: l_api_updating := ben_bli_shd.api_updating
1113: (p_batch_ler_id => p_batch_ler_id,
1114: p_object_version_number => p_object_version_number);
1115: --
1116: if (l_api_updating

Line 1118: <> nvl(ben_bli_shd.g_old_rec.stl_actv_flag,hr_api.g_varchar2)

1114: p_object_version_number => p_object_version_number);
1115: --
1116: if (l_api_updating
1117: and p_stl_actv_flag
1118: <> nvl(ben_bli_shd.g_old_rec.stl_actv_flag,hr_api.g_varchar2)
1119: or not l_api_updating) then
1120: --
1121: -- check if value of lookup falls within lookup type.
1122: --

Line 1146: Procedure insert_validate(p_rec in ben_bli_shd.g_rec_type

1142: end chk_stl_actv_flag;
1143: -- ----------------------------------------------------------------------------
1144: -- |---------------------------< insert_validate >----------------------------|
1145: -- ----------------------------------------------------------------------------
1146: Procedure insert_validate(p_rec in ben_bli_shd.g_rec_type
1147: ,p_effective_date in date) is
1148: --
1149: l_proc varchar2(72) := g_package||'insert_validate';
1150: --

Line 1258: Procedure update_validate(p_rec in ben_bli_shd.g_rec_type

1254: --
1255: -- ----------------------------------------------------------------------------
1256: -- |---------------------------< update_validate >----------------------------|
1257: -- ----------------------------------------------------------------------------
1258: Procedure update_validate(p_rec in ben_bli_shd.g_rec_type
1259: ,p_effective_date in date) is
1260: --
1261: l_proc varchar2(72) := g_package||'update_validate';
1262: --

Line 1370: Procedure delete_validate(p_rec in ben_bli_shd.g_rec_type

1366: --
1367: -- ----------------------------------------------------------------------------
1368: -- |---------------------------< delete_validate >----------------------------|
1369: -- ----------------------------------------------------------------------------
1370: Procedure delete_validate(p_rec in ben_bli_shd.g_rec_type
1371: ,p_effective_date in date) is
1372: --
1373: l_proc varchar2(72) := g_package||'delete_validate';
1374: --