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_ECT_BUS dependencies on BEN_ECT_SHD

Line 48: l_api_updating := ben_ect_shd.api_updating

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

Line 55: <> ben_ect_shd.g_old_rec.elig_dsblty_ctg_prte_id) then

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

Line 59: ben_ect_shd.constraint_error('BEN_ELIG_PER_TYP_PK');

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

Line 69: ben_ect_shd.constraint_error('BEN_ELIG_PER_TYP_PK');

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

Line 186: l_api_updating := ben_ect_shd.api_updating

182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc,5);
185: --
186: l_api_updating := ben_ect_shd.api_updating
187: (p_elig_dsblty_ctg_prte_id => p_elig_dsblty_ctg_prte_id,
188: p_effective_date => p_effective_date,
189: p_object_version_number => p_object_version_number);
190: --

Line 193: <> nvl(ben_ect_shd.g_old_rec.category,hr_api.g_number)

189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and nvl(p_category,hr_api.g_number)
193: <> nvl(ben_ect_shd.g_old_rec.category,hr_api.g_number)
194: or not l_api_updating) then
195: --
196: -- check if category value exists in per_person_types table
197: --

Line 208: ben_ect_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');

204: --
205: -- raise error as FK does not relate to PK in per_person_types
206: -- table.
207: --
208: ben_ect_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');
209: --
210: end if;
211: --
212: close c1;

Line 240: -- ben_ect_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');

236: close c2;
237: --
238: -- raise error as person type can not be set to not employee
239: -- need to create message
240: -- ben_ect_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');
241: fnd_message.set_name('BEN', 'BEN_91387_INV_PER_TYPE');
242: fnd_message.raise_error;
243: --
244: end if;

Line 302: l_api_updating := ben_ect_shd.api_updating

298: Begin
299: --
300: hr_utility.set_location('Entering:'||l_proc, 5);
301: --
302: l_api_updating := ben_ect_shd.api_updating
303: (p_effective_date =>p_effective_date,
304: p_elig_dsblty_ctg_prte_id => p_elig_dsblty_ctg_prte_id,
305: p_object_version_number =>p_object_version_number);
306: --

Line 309: <>nvl(ben_ect_shd.g_old_rec.category,hr_api.g_varchar2)

305: p_object_version_number =>p_object_version_number);
306: --
307: if (l_api_updating
308: and p_category
309: <>nvl(ben_ect_shd.g_old_rec.category,hr_api.g_varchar2)
310: or not l_api_updating)
311: and p_category is not null then
312: --
313: open c1;

Line 372: l_api_updating := ben_ect_shd.api_updating

368: Begin
369: --
370: hr_utility.set_location('Entering:'||l_proc, 5);
371: --
372: l_api_updating := ben_ect_shd.api_updating
373: (p_elig_dsblty_ctg_prte_id => p_elig_dsblty_ctg_prte_id,
374: p_effective_date => p_effective_date,
375: p_object_version_number => p_object_version_number);
376: --

Line 379: <> nvl(ben_ect_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

375: p_object_version_number => p_object_version_number);
376: --
377: if (l_api_updating
378: and p_excld_flag
379: <> nvl(ben_ect_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
380: or not l_api_updating) then
381: --
382: -- check if value of lookup falls within lookup type.
383: --

Line 611: (p_rec in ben_ect_shd.g_rec_type,

607: -- ----------------------------------------------------------------------------
608: -- |---------------------------< insert_validate >----------------------------|
609: -- ----------------------------------------------------------------------------
610: Procedure insert_validate
611: (p_rec in ben_ect_shd.g_rec_type,
612: p_effective_date in date,
613: p_datetrack_mode in varchar2,
614: p_validation_start_date in date,
615: p_validation_end_date in date) is

Line 663: (p_rec in ben_ect_shd.g_rec_type,

659: -- ----------------------------------------------------------------------------
660: -- |---------------------------< update_validate >----------------------------|
661: -- ----------------------------------------------------------------------------
662: Procedure update_validate
663: (p_rec in ben_ect_shd.g_rec_type,
664: p_effective_date in date,
665: p_datetrack_mode in varchar2,
666: p_validation_start_date in date,
667: p_validation_end_date in date) is

Line 723: (p_rec in ben_ect_shd.g_rec_type,

719: -- ----------------------------------------------------------------------------
720: -- |---------------------------< delete_validate >----------------------------|
721: -- ----------------------------------------------------------------------------
722: Procedure delete_validate
723: (p_rec in ben_ect_shd.g_rec_type,
724: p_effective_date in date,
725: p_datetrack_mode in varchar2,
726: p_validation_start_date in date,
727: p_validation_end_date in date) is