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_LPR_BUS dependencies on BEN_LPR_SHD

Line 48: l_api_updating := ben_lpr_shd.api_updating

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

Line 55: <> ben_lpr_shd.g_old_rec.ler_chg_plip_enrt_id) then

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

Line 59: ben_lpr_shd.constraint_error('BEN_LER_CHG_PLIP_EN_PK');

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

Line 69: ben_lpr_shd.constraint_error('BEN_LER_CHG_PLIP_EN_PK');

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

Line 135: l_api_updating := ben_lpr_shd.api_updating

131: Begin
132: --
133: hr_utility.set_location('Entering:'||l_proc, 5);
134: --
135: l_api_updating := ben_lpr_shd.api_updating
136: (p_ler_chg_plip_enrt_id => p_ler_chg_plip_enrt_id ,
137: p_effective_date => p_effective_date,
138: p_object_version_number => p_object_version_number);
139: --

Line 142: <> nvl(ben_lpr_shd.g_old_rec.ler_id,hr_api.g_number)

138: p_object_version_number => p_object_version_number);
139: --
140: if (l_api_updating
141: and p_ler_id
142: <> nvl(ben_lpr_shd.g_old_rec.ler_id,hr_api.g_number)
143: or not l_api_updating) then
144: --
145: -- this value must be unique
146: --

Line 208: l_api_updating := ben_lpr_shd.api_updating

204: Begin
205: --
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: l_api_updating := ben_lpr_shd.api_updating
209: (p_ler_chg_plip_enrt_id => p_ler_chg_plip_enrt_id,
210: p_effective_date => p_effective_date,
211: p_object_version_number => p_object_version_number);
212: --

Line 215: <> nvl(ben_lpr_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

211: p_object_version_number => p_object_version_number);
212: --
213: if (l_api_updating
214: and p_enrt_cd
215: <> nvl(ben_lpr_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
216: or not l_api_updating)
217: and p_enrt_cd is not null then
218: --
219: -- check if value of lookup falls within lookup type.

Line 279: l_api_updating := ben_lpr_shd.api_updating

275: Begin
276: --
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: l_api_updating := ben_lpr_shd.api_updating
280: (p_ler_chg_plip_enrt_id => p_ler_chg_plip_enrt_id,
281: p_effective_date => p_effective_date,
282: p_object_version_number => p_object_version_number);
283: --

Line 286: <> nvl(ben_lpr_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)

282: p_object_version_number => p_object_version_number);
283: --
284: if (l_api_updating
285: and p_stl_elig_cant_chg_flag
286: <> nvl(ben_lpr_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)
287: or not l_api_updating)
288: and p_stl_elig_cant_chg_flag is not null then
289: --
290: -- check if value of lookup falls within lookup type.

Line 350: l_api_updating := ben_lpr_shd.api_updating

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

Line 357: <> nvl(ben_lpr_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)

353: p_object_version_number => p_object_version_number);
354: --
355: if (l_api_updating
356: and p_enrt_mthd_cd
357: <> nvl(ben_lpr_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)
358: or not l_api_updating)
359: and p_enrt_mthd_cd is not null then
360: --
361: -- check if value of lookup falls within lookup type.

Line 421: l_api_updating := ben_lpr_shd.api_updating

417: Begin
418: --
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: l_api_updating := ben_lpr_shd.api_updating
422: (p_ler_chg_plip_enrt_id => p_ler_chg_plip_enrt_id,
423: p_effective_date => p_effective_date,
424: p_object_version_number => p_object_version_number);
425: --

Line 428: <> nvl(ben_lpr_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)

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

Line 509: l_api_updating := ben_lpr_shd.api_updating

505: Begin
506: --
507: hr_utility.set_location('Entering:'||l_proc, 5);
508: --
509: l_api_updating := ben_lpr_shd.api_updating
510: (p_ler_chg_plip_enrt_id => p_ler_chg_plip_enrt_id,
511: p_effective_date => p_effective_date,
512: p_object_version_number => p_object_version_number);
513: --

Line 516: <> nvl(ben_lpr_shd.g_old_rec.enrt_rl,hr_api.g_number)

512: p_object_version_number => p_object_version_number);
513: --
514: if (l_api_updating
515: and p_enrt_rl
516: <> nvl(ben_lpr_shd.g_old_rec.enrt_rl,hr_api.g_number)
517: or not l_api_updating)
518: and p_enrt_rl is not null then
519: --
520: -- check if value of formula rule is valid.

Line 604: l_api_updating := ben_lpr_shd.api_updating

600: Begin
601: --
602: hr_utility.set_location('Entering:'||l_proc, 5);
603: --
604: l_api_updating := ben_lpr_shd.api_updating
605: (p_ler_chg_plip_enrt_id => p_ler_chg_plip_enrt_id,
606: p_effective_date => p_effective_date,
607: p_object_version_number => p_object_version_number);
608: --

Line 611: <> nvl(ben_lpr_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number)

607: p_object_version_number => p_object_version_number);
608: --
609: if (l_api_updating
610: and p_dflt_enrt_rl
611: <> nvl(ben_lpr_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number)
612: or not l_api_updating)
613: and p_dflt_enrt_rl is not null then
614: --
615: -- check if value of formula rule is valid.

Line 702: l_api_updating := ben_lpr_shd.api_updating

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

Line 709: <> nvl(ben_lpr_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

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

Line 791: l_api_updating := ben_lpr_shd.api_updating

787: Begin
788: --
789: hr_utility.set_location('Entering:'||l_proc, 5);
790: --
791: l_api_updating := ben_lpr_shd.api_updating
792: (p_ler_chg_plip_enrt_id => p_ler_chg_plip_enrt_id,
793: p_effective_date => p_effective_date,
794: p_object_version_number => p_object_version_number);
795: --

Line 798: <> nvl(ben_lpr_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)

794: p_object_version_number => p_object_version_number);
795: --
796: if (l_api_updating
797: and p_crnt_enrt_prclds_chg_flag
798: <> nvl(ben_lpr_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)
799: or not l_api_updating)
800: and p_crnt_enrt_prclds_chg_flag is not null then
801: --
802: -- check if value of lookup falls within lookup type.

Line 862: l_api_updating := ben_lpr_shd.api_updating

858: Begin
859: --
860: hr_utility.set_location('Entering:'||l_proc, 5);
861: --
862: l_api_updating := ben_lpr_shd.api_updating
863: (p_ler_chg_plip_enrt_id => p_ler_chg_plip_enrt_id,
864: p_effective_date => p_effective_date,
865: p_object_version_number => p_object_version_number);
866: --

Line 869: <> nvl(ben_lpr_shd.g_old_rec.tco_chg_enrt_cd,hr_api.g_varchar2)

865: p_object_version_number => p_object_version_number);
866: --
867: if (l_api_updating
868: and p_tco_chg_enrt_cd
869: <> nvl(ben_lpr_shd.g_old_rec.tco_chg_enrt_cd,hr_api.g_varchar2)
870: or not l_api_updating)
871: and p_tco_chg_enrt_cd is not null then
872: --
873: -- check if value of lookup falls within lookup type.

Line 952: l_api_updating := ben_lpr_shd.api_updating

948: Begin
949: --
950: hr_utility.set_location('Entering:'||l_proc, 5);
951: --
952: l_api_updating := ben_lpr_shd.api_updating
953: (p_ler_chg_plip_enrt_id => p_ler_chg_plip_enrt_id,
954: p_effective_date => p_effective_date,
955: p_object_version_number => p_object_version_number);
956: --

Line 959: <> nvl(ben_lpr_shd.g_old_rec.auto_enrt_mthd_rl,hr_api.g_number)

955: p_object_version_number => p_object_version_number);
956: --
957: if (l_api_updating
958: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)
959: <> nvl(ben_lpr_shd.g_old_rec.auto_enrt_mthd_rl,hr_api.g_number)
960: or not l_api_updating) and p_auto_enrt_mthd_rl is not null then
961: --
962: -- check if value of formula rule is valid.
963: --

Line 1214: (p_rec in ben_lpr_shd.g_rec_type,

1210: -- ----------------------------------------------------------------------------
1211: -- |---------------------------< insert_validate >----------------------------|
1212: -- ----------------------------------------------------------------------------
1213: Procedure insert_validate
1214: (p_rec in ben_lpr_shd.g_rec_type,
1215: p_effective_date in date,
1216: p_datetrack_mode in varchar2,
1217: p_validation_start_date in date,
1218: p_validation_end_date in date) is

Line 1319: (p_rec in ben_lpr_shd.g_rec_type,

1315: -- ----------------------------------------------------------------------------
1316: -- |---------------------------< update_validate >----------------------------|
1317: -- ----------------------------------------------------------------------------
1318: Procedure update_validate
1319: (p_rec in ben_lpr_shd.g_rec_type,
1320: p_effective_date in date,
1321: p_datetrack_mode in varchar2,
1322: p_validation_start_date in date,
1323: p_validation_end_date in date) is

Line 1433: (p_rec in ben_lpr_shd.g_rec_type,

1429: -- ----------------------------------------------------------------------------
1430: -- |---------------------------< delete_validate >----------------------------|
1431: -- ----------------------------------------------------------------------------
1432: Procedure delete_validate
1433: (p_rec in ben_lpr_shd.g_rec_type,
1434: p_effective_date in date,
1435: p_datetrack_mode in varchar2,
1436: p_validation_start_date in date,
1437: p_validation_end_date in date) is