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_LBR_BUS dependencies on BEN_LBR_SHD

Line 48: l_api_updating := ben_lbr_shd.api_updating

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

Line 55: <> ben_lbr_shd.g_old_rec.ler_bnft_rstrn_id) then

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

Line 59: ben_lbr_shd.constraint_error('BEN_LER_BNFT_RSTRN_F_PK');

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

Line 69: ben_lbr_shd.constraint_error('BEN_LER_BNFT_RSTRN_F_PK');

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

Line 117: l_api_updating := ben_lbr_shd.api_updating

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

Line 124: <> nvl(ben_lbr_shd.g_old_rec.no_mx_cvg_incr_apls_flag,hr_api.g_varchar2)

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

Line 188: l_api_updating := ben_lbr_shd.api_updating

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

Line 195: <> nvl(ben_lbr_shd.g_old_rec.no_mn_cvg_incr_apls_flag,hr_api.g_varchar2)

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

Line 259: l_api_updating := ben_lbr_shd.api_updating

255: Begin
256: --
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: l_api_updating := ben_lbr_shd.api_updating
260: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
261: p_effective_date => p_effective_date,
262: p_object_version_number => p_object_version_number);
263: --

Line 266: <> nvl(ben_lbr_shd.g_old_rec.no_mx_cvg_amt_apls_flag,hr_api.g_varchar2)

262: p_object_version_number => p_object_version_number);
263: --
264: if (l_api_updating
265: and p_no_mx_cvg_amt_apls_flag
266: <> nvl(ben_lbr_shd.g_old_rec.no_mx_cvg_amt_apls_flag,hr_api.g_varchar2)
267: or not l_api_updating) then
268: --
269: -- check if value of lookup falls within lookup type.
270: --

Line 330: l_api_updating := ben_lbr_shd.api_updating

326: Begin
327: --
328: hr_utility.set_location('Entering:'||l_proc, 5);
329: --
330: l_api_updating := ben_lbr_shd.api_updating
331: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
332: p_effective_date => p_effective_date,
333: p_object_version_number => p_object_version_number);
334: --

Line 337: <> nvl(ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd,hr_api.g_varchar2)

333: p_object_version_number => p_object_version_number);
334: --
335: if (l_api_updating
336: and p_cvg_incr_r_decr_only_cd
337: <> nvl(ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd,hr_api.g_varchar2)
338: or not l_api_updating)
339: and p_cvg_incr_r_decr_only_cd is not null then
340: --
341: -- check if value of lookup falls within lookup type.

Line 401: l_api_updating := ben_lbr_shd.api_updating

397: Begin
398: --
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: l_api_updating := ben_lbr_shd.api_updating
402: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
403: p_effective_date => p_effective_date,
404: p_object_version_number => p_object_version_number);
405: --

Line 408: <> nvl(ben_lbr_shd.g_old_rec.unsspnd_enrt_cd,hr_api.g_varchar2)

404: p_object_version_number => p_object_version_number);
405: --
406: if (l_api_updating
407: and p_unsspnd_enrt_cd
408: <> nvl(ben_lbr_shd.g_old_rec.unsspnd_enrt_cd,hr_api.g_varchar2)
409: or not l_api_updating)
410: and p_unsspnd_enrt_cd is not null then
411: --
412: -- check if value of lookup falls within lookup type.

Line 472: l_api_updating := ben_lbr_shd.api_updating

468: Begin
469: --
470: hr_utility.set_location('Entering:'||l_proc, 5);
471: --
472: l_api_updating := ben_lbr_shd.api_updating
473: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
474: p_effective_date => p_effective_date,
475: p_object_version_number => p_object_version_number);
476: --

Line 479: <> nvl(ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd,hr_api.g_varchar2)

475: p_object_version_number => p_object_version_number);
476: --
477: if (l_api_updating
478: and p_dflt_to_asn_pndg_ctfn_cd
479: <> nvl(ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd,hr_api.g_varchar2)
480: or not l_api_updating)
481: and p_dflt_to_asn_pndg_ctfn_cd is not null then
482: --
483: -- check if value of lookup falls within lookup type.

Line 545: l_api_updating := ben_lbr_shd.api_updating

541: Begin
542: --
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: l_api_updating := ben_lbr_shd.api_updating
546: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
547: p_effective_date => p_effective_date,
548: p_object_version_number => p_object_version_number);
549: --

Line 552: <> ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl

548: p_object_version_number => p_object_version_number);
549: --
550: if (l_api_updating
551: and nvl(p_dflt_to_asn_pndg_ctfn_rl,hr_api.g_number)
552: <> ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
553: or not l_api_updating)
554: and p_dflt_to_asn_pndg_ctfn_rl is not null then
555: --
556: -- check if value of formula rule is valid.

Line 618: l_api_updating := ben_lbr_shd.api_updating

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

Line 625: <> ben_lbr_shd.g_old_rec.mn_cvg_rl

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

Line 691: l_api_updating := ben_lbr_shd.api_updating

687: Begin
688: --
689: hr_utility.set_location('Entering:'||l_proc, 5);
690: --
691: l_api_updating := ben_lbr_shd.api_updating
692: (p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
693: p_effective_date => p_effective_date,
694: p_object_version_number => p_object_version_number);
695: --

Line 698: <> ben_lbr_shd.g_old_rec.mx_cvg_rl

694: p_object_version_number => p_object_version_number);
695: --
696: if (l_api_updating
697: and nvl(p_mx_cvg_rl,hr_api.g_number)
698: <> ben_lbr_shd.g_old_rec.mx_cvg_rl
699: or not l_api_updating)
700: and p_mx_cvg_rl is not null then
701: --
702: -- check if value of formula rule is valid.

Line 795: l_api_updating := ben_lbr_shd.api_updating

791: Begin
792: --
793: hr_utility.set_location('Entering:'||l_proc, 5);
794: --
795: l_api_updating := ben_lbr_shd.api_updating
796: (p_effective_date => p_effective_date,
797: p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
798: p_object_version_number => p_object_version_number);
799: --

Line 802: <> nvl(ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd, '***')

798: p_object_version_number => p_object_version_number);
799: --
800: if (l_api_updating
801: and nvl(p_dflt_to_asn_pndg_ctfn_cd,hr_api.g_varchar2)
802: <> nvl(ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd, '***')
803: or not l_api_updating)
804: and p_dflt_to_asn_pndg_ctfn_cd is not null then
805: --
806: if (instr(p_dflt_to_asn_pndg_ctfn_cd,'NL'))>0 then

Line 1082: (p_rec in ben_lbr_shd.g_rec_type,

1078: -- ----------------------------------------------------------------------------
1079: -- |---------------------------< insert_validate >----------------------------|
1080: -- ----------------------------------------------------------------------------
1081: Procedure insert_validate
1082: (p_rec in ben_lbr_shd.g_rec_type,
1083: p_effective_date in date,
1084: p_datetrack_mode in varchar2,
1085: p_validation_start_date in date,
1086: p_validation_end_date in date) is

Line 1182: (p_rec in ben_lbr_shd.g_rec_type,

1178: -- ----------------------------------------------------------------------------
1179: -- |---------------------------< update_validate >----------------------------|
1180: -- ----------------------------------------------------------------------------
1181: Procedure update_validate
1182: (p_rec in ben_lbr_shd.g_rec_type,
1183: p_effective_date in date,
1184: p_datetrack_mode in varchar2,
1185: p_validation_start_date in date,
1186: p_validation_end_date in date) is

Line 1291: (p_rec in ben_lbr_shd.g_rec_type,

1287: -- ----------------------------------------------------------------------------
1288: -- |---------------------------< delete_validate >----------------------------|
1289: -- ----------------------------------------------------------------------------
1290: Procedure delete_validate
1291: (p_rec in ben_lbr_shd.g_rec_type,
1292: p_effective_date in date,
1293: p_datetrack_mode in varchar2,
1294: p_validation_start_date in date,
1295: p_validation_end_date in date) is