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_LOP_BUS dependencies on BEN_LOP_SHD

Line 48: l_api_updating := ben_lop_shd.api_updating

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

Line 55: <> ben_lop_shd.g_old_rec.ler_chg_oipl_enrt_id) then

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

Line 59: ben_lop_shd.constraint_error('BEN_LER_CHG_OIPL_ENRT_PK');

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

Line 69: ben_lop_shd.constraint_error('BEN_LER_CHG_OIPL_ENRT_PK');

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

Line 117: l_api_updating := ben_lop_shd.api_updating

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

Line 124: <> nvl(ben_lop_shd.g_old_rec.auto_enrt_flag,hr_api.g_varchar2)

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

Line 188: l_api_updating := ben_lop_shd.api_updating

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

Line 195: <> nvl(ben_lop_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)

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

Line 257: l_api_updating := ben_lop_shd.api_updating

253: Begin
254: --
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: l_api_updating := ben_lop_shd.api_updating
258: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
259: p_effective_date => p_effective_date,
260: p_object_version_number => p_object_version_number);
261: --

Line 264: <> nvl(ben_lop_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating
263: and p_dflt_flag
264: <> nvl(ben_lop_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
265: or not l_api_updating)
266: and p_dflt_flag is not null then
267: --
268: -- check if value of lookup falls within lookup type.

Line 326: l_api_updating := ben_lop_shd.api_updating

322: Begin
323: --
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: l_api_updating := ben_lop_shd.api_updating
327: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
328: p_effective_date => p_effective_date,
329: p_object_version_number => p_object_version_number);
330: --

Line 333: <> nvl(ben_lop_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)

329: p_object_version_number => p_object_version_number);
330: --
331: if (l_api_updating
332: and p_dflt_enrt_cd
333: <> nvl(ben_lop_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)
334: or not l_api_updating)
335: and p_dflt_enrt_cd is not null then
336: --
337: -- check if value of lookup falls within lookup type.

Line 413: l_api_updating := ben_lop_shd.api_updating

409: Begin
410: --
411: hr_utility.set_location('Entering:'||l_proc, 5);
412: --
413: l_api_updating := ben_lop_shd.api_updating
414: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
415: p_effective_date => p_effective_date,
416: p_object_version_number => p_object_version_number);
417: --

Line 420: <> nvl(ben_lop_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number)

416: p_object_version_number => p_object_version_number);
417: --
418: if (l_api_updating
419: and p_dflt_enrt_rl
420: <> nvl(ben_lop_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number)
421: or not l_api_updating)
422: and p_dflt_enrt_rl is not null then
423: --
424: -- check if value of formula rule is valid.

Line 491: l_api_updating := ben_lop_shd.api_updating

487: Begin
488: --
489: hr_utility.set_location('Entering:'||l_proc, 5);
490: --
491: l_api_updating := ben_lop_shd.api_updating
492: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
493: p_effective_date => p_effective_date,
494: p_object_version_number => p_object_version_number);
495: --

Line 498: <> nvl(ben_lop_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

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

Line 578: l_api_updating := ben_lop_shd.api_updating

574: Begin
575: --
576: hr_utility.set_location('Entering:'||l_proc, 5);
577: --
578: l_api_updating := ben_lop_shd.api_updating
579: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
580: p_effective_date => p_effective_date,
581: p_object_version_number => p_object_version_number);
582: --

Line 585: <> nvl(ben_lop_shd.g_old_rec.enrt_rl,hr_api.g_number)

581: p_object_version_number => p_object_version_number);
582: --
583: if (l_api_updating
584: and p_enrt_rl
585: <> nvl(ben_lop_shd.g_old_rec.enrt_rl,hr_api.g_number)
586: or not l_api_updating)
587: and p_enrt_rl is not null then
588: --
589: -- check if value of formula rule is valid.

Line 674: l_api_updating := ben_lop_shd.api_updating

670: Begin
671: --
672: hr_utility.set_location('Entering:'||l_proc, 5);
673: --
674: l_api_updating := ben_lop_shd.api_updating
675: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
676: p_effective_date => p_effective_date,
677: p_object_version_number => p_object_version_number);
678: --

Line 681: <> nvl(ben_lop_shd.g_old_rec.auto_enrt_mthd_rl,hr_api.g_number)

677: p_object_version_number => p_object_version_number);
678: --
679: if (l_api_updating
680: and p_auto_enrt_mthd_rl
681: <> nvl(ben_lop_shd.g_old_rec.auto_enrt_mthd_rl,hr_api.g_number)
682: or not l_api_updating)
683: and p_auto_enrt_mthd_rl is not null then
684: --
685: -- check if value of formula rule is valid.

Line 754: l_api_updating := ben_lop_shd.api_updating

750: Begin
751: --
752: hr_utility.set_location('Entering:'||l_proc, 5);
753: --
754: l_api_updating := ben_lop_shd.api_updating
755: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
756: p_effective_date => p_effective_date,
757: p_object_version_number => p_object_version_number);
758: --

Line 761: <> nvl(ben_lop_shd.g_old_rec.use_schedd_enrt_dfns_flag,hr_api.g_varchar2)

757: p_object_version_number => p_object_version_number);
758: --
759: if (l_api_updating
760: and p_use_schedd_enrt_dfns_flag
761: <> nvl(ben_lop_shd.g_old_rec.use_schedd_enrt_dfns_flag,hr_api.g_varchar2)
762: or not l_api_updating)
763: and p_use_schedd_enrt_dfns_flag is not null then
764: --
765: -- check if value of lookup falls within lookup type.

Line 827: l_api_updating := ben_lop_shd.api_updating

823: Begin
824: --
825: hr_utility.set_location('Entering:'||l_proc, 5);
826: --
827: l_api_updating := ben_lop_shd.api_updating
828: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
829: p_effective_date => p_effective_date,
830: p_object_version_number => p_object_version_number);
831: --

Line 834: <> nvl(ben_lop_shd.g_old_rec.use_schedd_enrt_dflts_flag,hr_api.g_varchar2)

830: p_object_version_number => p_object_version_number);
831: --
832: if (l_api_updating
833: and p_use_schedd_enrt_dflts_flag
834: <> nvl(ben_lop_shd.g_old_rec.use_schedd_enrt_dflts_flag,hr_api.g_varchar2)
835: or not l_api_updating)
836: and p_use_schedd_enrt_dflts_flag is not null then
837: --
838: -- check if value of lookup falls within lookup type.

Line 899: l_api_updating := ben_lop_shd.api_updating

895: Begin
896: --
897: hr_utility.set_location('Entering:'||l_proc, 5);
898: --
899: l_api_updating := ben_lop_shd.api_updating
900: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
901: p_effective_date => p_effective_date,
902: p_object_version_number => p_object_version_number);
903: --

Line 906: <> nvl(ben_lop_shd.g_old_rec.new_crnt_enrl_cd,hr_api.g_varchar2)

902: p_object_version_number => p_object_version_number);
903: --
904: if (l_api_updating
905: and p_new_crnt_enrl_cd
906: <> nvl(ben_lop_shd.g_old_rec.new_crnt_enrl_cd,hr_api.g_varchar2)
907: or not l_api_updating) then
908: --
909: -- check if value of lookup falls within lookup type.
910: --

Line 969: l_api_updating := ben_lop_shd.api_updating

965: Begin
966: --
967: hr_utility.set_location('Entering:'||l_proc, 5);
968: --
969: l_api_updating := ben_lop_shd.api_updating
970: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
971: p_effective_date => p_effective_date,
972: p_object_version_number => p_object_version_number);
973: --

Line 976: <> nvl(ben_lop_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)

972: p_object_version_number => p_object_version_number);
973: --
974: if (l_api_updating
975: and p_crnt_enrt_prclds_chg_flag
976: <> nvl(ben_lop_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)
977: or not l_api_updating)
978: and p_crnt_enrt_prclds_chg_flag is not null then
979: --
980: -- check if value of lookup falls within lookup type.

Line 1225: (p_rec in ben_lop_shd.g_rec_type,

1221: -- ----------------------------------------------------------------------------
1222: -- |---------------------------< insert_validate >----------------------------|
1223: -- ----------------------------------------------------------------------------
1224: Procedure insert_validate
1225: (p_rec in ben_lop_shd.g_rec_type,
1226: p_effective_date in date,
1227: p_datetrack_mode in varchar2,
1228: p_validation_start_date in date,
1229: p_validation_end_date in date) is

Line 1332: (p_rec in ben_lop_shd.g_rec_type,

1328: -- ----------------------------------------------------------------------------
1329: -- |---------------------------< update_validate >----------------------------|
1330: -- ----------------------------------------------------------------------------
1331: Procedure update_validate
1332: (p_rec in ben_lop_shd.g_rec_type,
1333: p_effective_date in date,
1334: p_datetrack_mode in varchar2,
1335: p_validation_start_date in date,
1336: p_validation_end_date in date) is

Line 1447: (p_rec in ben_lop_shd.g_rec_type,

1443: -- ----------------------------------------------------------------------------
1444: -- |---------------------------< delete_validate >----------------------------|
1445: -- ----------------------------------------------------------------------------
1446: Procedure delete_validate
1447: (p_rec in ben_lop_shd.g_rec_type,
1448: p_effective_date in date,
1449: p_datetrack_mode in varchar2,
1450: p_validation_start_date in date,
1451: p_validation_end_date in date) is