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_LPL_BUS dependencies on BEN_LPL_SHD

Line 48: l_api_updating := ben_lpl_shd.api_updating

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

Line 56: <> ben_lpl_shd.g_old_rec.ler_per_info_cs_ler_id) then

52: --
53:
54: if (l_api_updating
55: and nvl(p_ler_per_info_cs_ler_id,hr_api.g_number)
56: <> ben_lpl_shd.g_old_rec.ler_per_info_cs_ler_id) then
57: --
58: -- raise error as PK has changed
59: --
60: ben_lpl_shd.constraint_error('BEN_LER_PER_INFO_CS_LER_F_PK');

Line 60: ben_lpl_shd.constraint_error('BEN_LER_PER_INFO_CS_LER_F_PK');

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

Line 70: ben_lpl_shd.constraint_error('BEN_LER_PER_INFO_CS_LER_F_PK');

66: if p_ler_per_info_cs_ler_id is not null then
67: --
68: -- raise error as PK is not null
69: --
70: ben_lpl_shd.constraint_error('BEN_LER_PER_INFO_CS_LER_F_PK');
71: --
72: end if;
73: --
74: end if;

Line 152: l_api_updating := ben_lpl_shd.api_updating

148: fnd_message.set_name('BEN', 'BEN_91016_PERSON_CHANGE_REQ');
149: fnd_message.raise_error;
150: end if;
151:
152: l_api_updating := ben_lpl_shd.api_updating
153: (p_ler_per_info_cs_ler_id => p_ler_per_info_cs_ler_id,
154: p_effective_date => p_effective_date,
155: p_object_version_number => p_object_version_number);
156:

Line 160: <> nvl(ben_lpl_shd.g_old_rec.per_info_chg_cs_ler_id,hr_api.g_number)

156:
157: --
158: if (l_api_updating
159: and nvl(p_per_info_chg_cs_ler_id,hr_api.g_number)
160: <> nvl(ben_lpl_shd.g_old_rec.per_info_chg_cs_ler_id,hr_api.g_number)
161: or not l_api_updating) then
162: --
163: -- check if per_info_chg_cs_ler_id value exists in
164: -- ben_per_info_chg_cs_ler_f table

Line 171: ben_lpl_shd.constraint_error('BEN_LER_PER_INFO_CS_LER_FK2');

167: if c1%notfound then
168: close c1;
169: -- raise error as FK does not relate to PK in ben_per_info_chg_cs_ler
170: -- table.
171: ben_lpl_shd.constraint_error('BEN_LER_PER_INFO_CS_LER_FK2');
172: end if;
173: close c1;
174: --
175: -- check if per_info_chg_cs_ler_id is unique for this ler.

Line 251: l_api_updating := ben_lpl_shd.api_updating

247: Begin
248: --
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: l_api_updating := ben_lpl_shd.api_updating
252: (p_ler_per_info_cs_ler_id => p_ler_per_info_cs_ler_id,
253: p_effective_date => p_effective_date,
254: p_object_version_number => p_object_version_number);
255: --

Line 258: <> ben_lpl_shd.g_old_rec.ler_per_info_cs_ler_rl

254: p_object_version_number => p_object_version_number);
255: --
256: if (l_api_updating
257: and nvl(p_ler_per_info_cs_ler_rl,hr_api.g_number)
258: <> ben_lpl_shd.g_old_rec.ler_per_info_cs_ler_rl
259: or not l_api_updating)
260: and p_ler_per_info_cs_ler_rl is not null then
261: --
262: -- check if value of formula rule is valid.

Line 538: l_api_updating := ben_lpl_shd.api_updating

534: Begin
535: --
536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: l_api_updating := ben_lpl_shd.api_updating
539: (p_ler_per_info_cs_ler_id => p_ler_per_info_cs_ler_id,
540: p_effective_date => p_effective_date,
541: p_object_version_number => p_object_version_number);
542: --

Line 545: <> ben_lpl_shd.g_old_rec.per_info_chg_cs_ler_id

541: p_object_version_number => p_object_version_number);
542: --
543: if (l_api_updating
544: and nvl(p_per_info_chg_cs_ler_id,hr_api.g_number)
545: <> ben_lpl_shd.g_old_rec.per_info_chg_cs_ler_id
546: or not l_api_updating)
547: and p_per_info_chg_cs_ler_id is not null then
548: --
549: open c_source_table;

Line 783: (p_rec in ben_lpl_shd.g_rec_type,

779: -- ----------------------------------------------------------------------------
780: -- |---------------------------< insert_validate >----------------------------|
781: -- ----------------------------------------------------------------------------
782: Procedure insert_validate
783: (p_rec in ben_lpl_shd.g_rec_type,
784: p_effective_date in date,
785: p_datetrack_mode in varchar2,
786: p_validation_start_date in date,
787: p_validation_end_date in date) is

Line 844: (p_rec in ben_lpl_shd.g_rec_type,

840: -- ----------------------------------------------------------------------------
841: -- |---------------------------< update_validate >----------------------------|
842: -- ----------------------------------------------------------------------------
843: Procedure update_validate
844: (p_rec in ben_lpl_shd.g_rec_type,
845: p_effective_date in date,
846: p_datetrack_mode in varchar2,
847: p_validation_start_date in date,
848: p_validation_end_date in date) is

Line 906: (p_rec in ben_lpl_shd.g_rec_type,

902: -- ----------------------------------------------------------------------------
903: -- |---------------------------< delete_validate >----------------------------|
904: -- ----------------------------------------------------------------------------
905: Procedure delete_validate
906: (p_rec in ben_lpl_shd.g_rec_type,
907: p_effective_date in date,
908: p_datetrack_mode in varchar2,
909: p_validation_start_date in date,
910: p_validation_end_date in date) is