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_LGE_BUS dependencies on BEN_LGE_SHD

Line 48: l_api_updating := ben_lge_shd.api_updating

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

Line 55: <> ben_lge_shd.g_old_rec.ler_chg_pgm_enrt_id) then

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

Line 59: ben_lge_shd.constraint_error('BEN_LER_CHG_PGM_ENRT_F_PK');

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

Line 69: ben_lge_shd.constraint_error('BEN_LER_CHG_PGM_ENRT_F_PK');

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

Line 118: l_api_updating := ben_lge_shd.api_updating

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

Line 125: <> ben_lge_shd.g_old_rec.dflt_enrt_rl

121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_dflt_enrt_rl,hr_api.g_number)
125: <> ben_lge_shd.g_old_rec.dflt_enrt_rl
126: or not l_api_updating)
127: and p_dflt_enrt_rl is not null then
128: --
129: -- check if value of formula rule is valid.

Line 190: l_api_updating := ben_lge_shd.api_updating

186: Begin
187: --
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: l_api_updating := ben_lge_shd.api_updating
191: (p_ler_chg_pgm_enrt_id => p_ler_chg_pgm_enrt_id,
192: p_effective_date => p_effective_date,
193: p_object_version_number => p_object_version_number);
194: --

Line 197: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)

193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating
196: and p_dflt_enrt_cd
197: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)
198: or not l_api_updating)
199: and p_dflt_enrt_cd is not null then
200: --
201: -- check if value of lookup falls within lookup type.

Line 261: l_api_updating := ben_lge_shd.api_updating

257: Begin
258: --
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: l_api_updating := ben_lge_shd.api_updating
262: (p_ler_chg_pgm_enrt_id => p_ler_chg_pgm_enrt_id,
263: p_effective_date => p_effective_date,
264: p_object_version_number => p_object_version_number);
265: --

Line 268: <> nvl(ben_lge_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)

264: p_object_version_number => p_object_version_number);
265: --
266: if (l_api_updating
267: and p_crnt_enrt_prclds_chg_flag
268: <> nvl(ben_lge_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)
269: or not l_api_updating) then
270: --
271: -- check if value of lookup falls within lookup type.
272: --

Line 333: l_api_updating := ben_lge_shd.api_updating

329: Begin
330: --
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: l_api_updating := ben_lge_shd.api_updating
334: (p_ler_chg_pgm_enrt_id => p_ler_chg_pgm_enrt_id,
335: p_effective_date => p_effective_date,
336: p_object_version_number => p_object_version_number);
337: --

Line 340: <> ben_lge_shd.g_old_rec.auto_enrt_mthd_rl

336: p_object_version_number => p_object_version_number);
337: --
338: if (l_api_updating
339: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)
340: <> ben_lge_shd.g_old_rec.auto_enrt_mthd_rl
341: or not l_api_updating)
342: and p_auto_enrt_mthd_rl is not null then
343: --
344: -- check if value of formula rule is valid.

Line 405: l_api_updating := ben_lge_shd.api_updating

401: Begin
402: --
403: hr_utility.set_location('Entering:'||l_proc, 5);
404: --
405: l_api_updating := ben_lge_shd.api_updating
406: (p_ler_chg_pgm_enrt_id => p_ler_chg_pgm_enrt_id,
407: p_effective_date => p_effective_date,
408: p_object_version_number => p_object_version_number);
409: --

Line 412: <> nvl(ben_lge_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)

408: p_object_version_number => p_object_version_number);
409: --
410: if (l_api_updating
411: and p_enrt_mthd_cd
412: <> nvl(ben_lge_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)
413: or not l_api_updating)
414: and p_enrt_mthd_cd is not null then
415: --
416: -- check if value of lookup falls within lookup type.

Line 476: l_api_updating := ben_lge_shd.api_updating

472: Begin
473: --
474: hr_utility.set_location('Entering:'||l_proc, 5);
475: --
476: l_api_updating := ben_lge_shd.api_updating
477: (p_ler_chg_pgm_enrt_id => p_ler_chg_pgm_enrt_id,
478: p_effective_date => p_effective_date,
479: p_object_version_number => p_object_version_number);
480: --

Line 483: <> nvl(ben_lge_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

479: p_object_version_number => p_object_version_number);
480: --
481: if (l_api_updating
482: and p_enrt_cd
483: <> nvl(ben_lge_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
484: or not l_api_updating)
485: and p_enrt_cd is not null then
486: --
487: -- check if value of lookup falls within lookup type.

Line 547: l_api_updating := ben_lge_shd.api_updating

543: Begin
544: --
545: hr_utility.set_location('Entering:'||l_proc, 5);
546: --
547: l_api_updating := ben_lge_shd.api_updating
548: (p_ler_chg_pgm_enrt_id => p_ler_chg_pgm_enrt_id,
549: p_effective_date => p_effective_date,
550: p_object_version_number => p_object_version_number);
551: --

Line 554: <> nvl(ben_lge_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)

550: p_object_version_number => p_object_version_number);
551: --
552: if (l_api_updating
553: and p_stl_elig_cant_chg_flag
554: <> nvl(ben_lge_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)
555: or not l_api_updating) then
556: --
557: -- check if value of lookup falls within lookup type.
558: --

Line 619: l_api_updating := ben_lge_shd.api_updating

615: Begin
616: --
617: hr_utility.set_location('Entering:'||l_proc, 5);
618: --
619: l_api_updating := ben_lge_shd.api_updating
620: (p_ler_chg_pgm_enrt_id => p_ler_chg_pgm_enrt_id,
621: p_effective_date => p_effective_date,
622: p_object_version_number => p_object_version_number);
623: --

Line 626: <> ben_lge_shd.g_old_rec.enrt_rl

622: p_object_version_number => p_object_version_number);
623: --
624: if (l_api_updating
625: and nvl(p_enrt_rl,hr_api.g_number)
626: <> ben_lge_shd.g_old_rec.enrt_rl
627: or not l_api_updating)
628: and p_enrt_rl is not null then
629: --
630: -- check if value of formula rule is valid.

Line 699: l_api_updating := ben_lge_shd.api_updating

695: Begin
696: --
697: hr_utility.set_location('Entering:'||l_proc, 5);
698: --
699: l_api_updating := ben_lge_shd.api_updating
700: (p_ler_chg_pgm_enrt_id => p_ler_chg_pgm_enrt_id,
701: p_effective_date => p_effective_date,
702: p_object_version_number => p_object_version_number);
703: --

Line 707: <> nvl(ben_lge_shd.g_old_rec.enrt_cd,hr_api.g_varchar2) or

703: --
704: if (l_api_updating
705: and
706: (nvl(p_enrt_cd,hr_api.g_varchar2)
707: <> nvl(ben_lge_shd.g_old_rec.enrt_cd,hr_api.g_varchar2) or
708: nvl(p_enrt_rl,hr_api.g_number)
709: <> nvl(ben_lge_shd.g_old_rec.enrt_rl,hr_api.g_number))
710:
711: or not l_api_updating) then

Line 709: <> nvl(ben_lge_shd.g_old_rec.enrt_rl,hr_api.g_number))

705: and
706: (nvl(p_enrt_cd,hr_api.g_varchar2)
707: <> nvl(ben_lge_shd.g_old_rec.enrt_cd,hr_api.g_varchar2) or
708: nvl(p_enrt_rl,hr_api.g_number)
709: <> nvl(ben_lge_shd.g_old_rec.enrt_rl,hr_api.g_number))
710:
711: or not l_api_updating) then
712: --
713: if (p_enrt_cd = 'RL' and p_enrt_rl is null) then

Line 733: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or

729: --
730: if (l_api_updating
731: and
732: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)
733: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or
734: nvl(p_dflt_enrt_rl,hr_api.g_number)
735: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number))
736:
737: or not l_api_updating) then

Line 735: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number))

731: and
732: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)
733: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or
734: nvl(p_dflt_enrt_rl,hr_api.g_number)
735: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number))
736:
737: or not l_api_updating) then
738: --
739: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_rl is null) then

Line 977: (p_rec in ben_lge_shd.g_rec_type,

973: -- ----------------------------------------------------------------------------
974: -- |---------------------------< insert_validate >----------------------------|
975: -- ----------------------------------------------------------------------------
976: Procedure insert_validate
977: (p_rec in ben_lge_shd.g_rec_type,
978: p_effective_date in date,
979: p_datetrack_mode in varchar2,
980: p_validation_start_date in date,
981: p_validation_end_date in date) is

Line 1065: (p_rec in ben_lge_shd.g_rec_type,

1061: -- ----------------------------------------------------------------------------
1062: -- |---------------------------< update_validate >----------------------------|
1063: -- ----------------------------------------------------------------------------
1064: Procedure update_validate
1065: (p_rec in ben_lge_shd.g_rec_type,
1066: p_effective_date in date,
1067: p_datetrack_mode in varchar2,
1068: p_validation_start_date in date,
1069: p_validation_end_date in date) is

Line 1162: (p_rec in ben_lge_shd.g_rec_type,

1158: -- ----------------------------------------------------------------------------
1159: -- |---------------------------< delete_validate >----------------------------|
1160: -- ----------------------------------------------------------------------------
1161: Procedure delete_validate
1162: (p_rec in ben_lge_shd.g_rec_type,
1163: p_effective_date in date,
1164: p_datetrack_mode in varchar2,
1165: p_validation_start_date in date,
1166: p_validation_end_date in date) is