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_ELP_BUS dependencies on BEN_ELP_SHD

Line 48: l_api_updating := ben_elp_shd.api_updating

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

Line 55: <> ben_elp_shd.g_old_rec.eligy_prfl_id) then

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

Line 59: ben_elp_shd.constraint_error('BEN_ELIGY_PRFL_PK');

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

Line 69: ben_elp_shd.constraint_error('BEN_ELIGY_PRFL_PK');

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

Line 134: l_api_updating := ben_elp_shd.api_updating

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

Line 140: and p_name <> ben_elp_shd.g_old_rec.name) or

136: p_eligy_prfl_id => p_eligy_prfl_id,
137: p_object_version_number => p_object_version_number);
138: --
139: if (l_api_updating
140: and p_name <> ben_elp_shd.g_old_rec.name) or
141: not l_api_updating then
142: --
143: hr_utility.set_location('Entering:'||l_proc, 10);
144: --

Line 154: ben_elp_shd.constraint_error('BEN_ELIGY_PRFL_UK1');

150: close csr_name;
151: --
152: -- raise error as UK1 is violated
153: --
154: ben_elp_shd.constraint_error('BEN_ELIGY_PRFL_UK1');
155: --
156: end if;
157: --
158: end if;

Line 202: l_api_updating := ben_elp_shd.api_updating

198: Begin
199: --
200: hr_utility.set_location('Entering:'||l_proc, 5);
201: --
202: l_api_updating := ben_elp_shd.api_updating
203: (p_eligy_prfl_id => p_eligy_prfl_id,
204: p_effective_date => p_effective_date,
205: p_object_version_number => p_object_version_number);
206: --

Line 209: <> nvl(ben_elp_shd.g_old_rec.stat_cd,hr_api.g_varchar2)

205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and p_stat_cd
209: <> nvl(ben_elp_shd.g_old_rec.stat_cd,hr_api.g_varchar2)
210: or not l_api_updating) then
211: --
212: -- check if value of lookup falls within lookup type.
213: --

Line 271: l_api_updating := ben_elp_shd.api_updating

267: Begin
268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: l_api_updating := ben_elp_shd.api_updating
272: (p_eligy_prfl_id => p_eligy_prfl_id,
273: p_effective_date => p_effective_date,
274: p_object_version_number => p_object_version_number);
275: --

Line 278: <> nvl(ben_elp_shd.g_old_rec.asmt_to_use_cd,hr_api.g_varchar2)

274: p_object_version_number => p_object_version_number);
275: --
276: if (l_api_updating
277: and p_asmt_to_use_cd
278: <> nvl(ben_elp_shd.g_old_rec.asmt_to_use_cd,hr_api.g_varchar2)
279: or not l_api_updating) then
280: --
281: -- check if value of lookup falls within lookup type.
282: --

Line 577: l_api_updating := ben_elp_shd.api_updating

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

Line 1554: (p_rec in ben_elp_shd.g_rec_type,

1550: -- ----------------------------------------------------------------------------
1551: -- |---------------------------< insert_validate >----------------------------|
1552: -- ----------------------------------------------------------------------------
1553: Procedure insert_validate
1554: (p_rec in ben_elp_shd.g_rec_type,
1555: p_effective_date in date,
1556: p_datetrack_mode in varchar2,
1557: p_validation_start_date in date,
1558: p_validation_end_date in date) is

Line 1603: (p_rec in ben_elp_shd.g_rec_type,

1599: -- ----------------------------------------------------------------------------
1600: -- |---------------------------< update_validate >----------------------------|
1601: -- ----------------------------------------------------------------------------
1602: Procedure update_validate
1603: (p_rec in ben_elp_shd.g_rec_type,
1604: p_effective_date in date,
1605: p_datetrack_mode in varchar2,
1606: p_validation_start_date in date,
1607: p_validation_end_date in date) is

Line 1659: (p_rec in ben_elp_shd.g_rec_type,

1655: -- ----------------------------------------------------------------------------
1656: -- |---------------------------< delete_validate >----------------------------|
1657: -- ----------------------------------------------------------------------------
1658: Procedure delete_validate
1659: (p_rec in ben_elp_shd.g_rec_type,
1660: p_effective_date in date,
1661: p_datetrack_mode in varchar2,
1662: p_validation_start_date in date,
1663: p_validation_end_date in date) is