DBA Data[Home] [Help]

APPS.BEN_XCR_BUS dependencies on BEN_XCR_SHD

Line 155: l_api_updating := ben_xcr_shd.api_updating

151: Begin
152: --
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: l_api_updating := ben_xcr_shd.api_updating
156: (p_ext_crit_prfl_id => p_ext_crit_prfl_id,
157: p_object_version_number => p_object_version_number);
158: --
159: if (l_api_updating

Line 161: <> ben_xcr_shd.g_old_rec.ext_crit_prfl_id) then

157: p_object_version_number => p_object_version_number);
158: --
159: if (l_api_updating
160: and nvl(p_ext_crit_prfl_id,hr_api.g_number)
161: <> ben_xcr_shd.g_old_rec.ext_crit_prfl_id) then
162: --
163: -- raise error as PK has changed
164: --
165: ben_xcr_shd.constraint_error('BEN_EXT_CRIT_PRFL_PK');

Line 165: ben_xcr_shd.constraint_error('BEN_EXT_CRIT_PRFL_PK');

161: <> ben_xcr_shd.g_old_rec.ext_crit_prfl_id) then
162: --
163: -- raise error as PK has changed
164: --
165: ben_xcr_shd.constraint_error('BEN_EXT_CRIT_PRFL_PK');
166: --
167: elsif not l_api_updating then
168: --
169: -- check if PK is null

Line 175: ben_xcr_shd.constraint_error('BEN_EXT_CRIT_PRFL_PK');

171: if p_ext_crit_prfl_id is not null then
172: --
173: -- raise error as PK is not null
174: --
175: ben_xcr_shd.constraint_error('BEN_EXT_CRIT_PRFL_PK');
176: --
177: end if;
178: --
179: end if;

Line 238: l_api_updating := ben_xcr_shd.api_updating

234: --
235: Begin
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: --
238: l_api_updating := ben_xcr_shd.api_updating
239: (p_ext_crit_prfl_id => p_ext_crit_prfl_id,
240: p_object_version_number => p_object_version_number);
241: --
242: if (l_api_updating

Line 244: <> ben_xcr_shd.g_old_rec.name

240: p_object_version_number => p_object_version_number);
241: --
242: if (l_api_updating
243: and nvl(p_name,hr_api.g_varchar2)
244: <> ben_xcr_shd.g_old_rec.name
245: or not l_api_updating) then
246: --
247: open c1;
248: fetch c1 into l_dummy;

Line 287: l_api_updating := ben_xcr_shd.api_updating

283: --
284: Begin
285: hr_utility.set_location('Entering:'||l_proc, 5);
286: --
287: l_api_updating := ben_xcr_shd.api_updating
288: (p_ext_crit_prfl_id => p_ext_crit_prfl_id,
289: p_object_version_number => p_object_version_number);
290: --
291: if (l_api_updating

Line 293: <> ben_xcr_shd.g_old_rec.ext_global_flag

289: p_object_version_number => p_object_version_number);
290: --
291: if (l_api_updating
292: and nvl(p_ext_global_flag,hr_api.g_varchar2)
293: <> ben_xcr_shd.g_old_rec.ext_global_flag
294: or not l_api_updating) then
295:
296:
297: if p_business_group_id is not null then

Line 331: if ben_xcr_shd.g_old_rec.ext_global_flag = 'Y' and p_ext_global_flag = 'N' then

327: end if ;
328:
329: --- when the old flag is 'Y' and current flag 'N' then
330: -- make sure no child belongs to global
331: if ben_xcr_shd.g_old_rec.ext_global_flag = 'Y' and p_ext_global_flag = 'N' then
332: open c ;
333: fetch c into l_dummy ;
334: if c%found then
335: --- create new error

Line 353: Procedure insert_validate(p_rec in ben_xcr_shd.g_rec_type) is

349:
350: -- ----------------------------------------------------------------------------
351: -- |---------------------------< insert_validate >----------------------------|
352: -- ----------------------------------------------------------------------------
353: Procedure insert_validate(p_rec in ben_xcr_shd.g_rec_type) is
354: --
355: l_proc varchar2(72) := g_package||'insert_validate';
356: --
357: Begin

Line 400: Procedure update_validate(p_rec in ben_xcr_shd.g_rec_type) is

396: --
397: -- ----------------------------------------------------------------------------
398: -- |---------------------------< update_validate >----------------------------|
399: -- ----------------------------------------------------------------------------
400: Procedure update_validate(p_rec in ben_xcr_shd.g_rec_type) is
401: --
402: l_proc varchar2(72) := g_package||'update_validate';
403: --
404: Begin

Line 445: Procedure delete_validate(p_rec in ben_xcr_shd.g_rec_type) is

441: --
442: -- ----------------------------------------------------------------------------
443: -- |---------------------------< delete_validate >----------------------------|
444: -- ----------------------------------------------------------------------------
445: Procedure delete_validate(p_rec in ben_xcr_shd.g_rec_type) is
446: --
447: l_proc varchar2(72) := g_package||'delete_validate';
448: --
449: Begin

Line 455: ,ben_xcr_shd.g_old_rec.business_group_id

451: --
452: -- Call all supporting business operations
453: --
454: chk_startup_action(False
455: ,ben_xcr_shd.g_old_rec.business_group_id
456: ,ben_xcr_shd.g_old_rec.legislation_code);
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 10);
459: End delete_validate;

Line 456: ,ben_xcr_shd.g_old_rec.legislation_code);

452: -- Call all supporting business operations
453: --
454: chk_startup_action(False
455: ,ben_xcr_shd.g_old_rec.business_group_id
456: ,ben_xcr_shd.g_old_rec.legislation_code);
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 10);
459: End delete_validate;
460: --