DBA Data[Home] [Help]

APPS.BEN_XRC_BUS dependencies on BEN_XRC_SHD

Line 155: l_api_updating := ben_xrc_shd.api_updating

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

Line 161: <> ben_xrc_shd.g_old_rec.ext_rcd_id) then

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

Line 165: ben_xrc_shd.constraint_error('BEN_EXT_RCD_PK');

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

Line 175: ben_xrc_shd.constraint_error('BEN_EXT_RCD_PK');

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

Line 288: l_api_updating := ben_xrc_shd.api_updating

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

Line 294: <> nvl(ben_xrc_shd.g_old_rec.rcd_type_cd,hr_api.g_varchar2)

290: p_object_version_number => p_object_version_number);
291: --
292: if (l_api_updating
293: and p_rcd_type_cd
294: <> nvl(ben_xrc_shd.g_old_rec.rcd_type_cd,hr_api.g_varchar2)
295: or not l_api_updating)
296: and p_rcd_type_cd is not null then
297: --
298: -- check if value of lookup falls within lookup type.

Line 379: l_api_updating := ben_xrc_shd.api_updating

375: Begin
376: --
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: l_api_updating := ben_xrc_shd.api_updating
380: (p_ext_rcd_id => p_ext_rcd_id,
381: p_object_version_number => p_object_version_number);
382: --
383: if (l_api_updating

Line 385: <> nvl(ben_xrc_shd.g_old_rec.low_lvl_cd,hr_api.g_varchar2)

381: p_object_version_number => p_object_version_number);
382: --
383: if (l_api_updating
384: and p_low_lvl_cd
385: <> nvl(ben_xrc_shd.g_old_rec.low_lvl_cd,hr_api.g_varchar2)
386: or not l_api_updating)
387: and p_low_lvl_cd is not null then
388: --
389: -- check if value of lookup falls within lookup type.

Line 474: l_api_updating := ben_xrc_shd.api_updating

470: Begin
471: --
472: hr_utility.set_location('Entering:'||l_proc, 5);
473: --
474: l_api_updating := ben_xrc_shd.api_updating
475: (p_ext_rcd_id => p_ext_rcd_id,
476: p_object_version_number => p_object_version_number);
477: --
478: if (l_api_updating

Line 480: <> nvl(ben_xrc_shd.g_old_rec.rcd_type_cd,hr_api.g_varchar2)

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

Line 521: Procedure insert_validate(p_rec in ben_xrc_shd.g_rec_type

517: end chk_rcd_data_typ;
518: -- ----------------------------------------------------------------------------
519: -- |---------------------------< insert_validate >----------------------------|
520: -- ----------------------------------------------------------------------------
521: Procedure insert_validate(p_rec in ben_xrc_shd.g_rec_type
522: ,p_effective_date in date) is
523: --
524: l_proc varchar2(72) := g_package||'insert_validate';
525: --

Line 569: Procedure update_validate(p_rec in ben_xrc_shd.g_rec_type

565: --
566: -- ----------------------------------------------------------------------------
567: -- |---------------------------< update_validate >----------------------------|
568: -- ----------------------------------------------------------------------------
569: Procedure update_validate(p_rec in ben_xrc_shd.g_rec_type
570: ,p_effective_date in date) is
571: --
572: l_proc varchar2(72) := g_package||'update_validate';
573: --

Line 622: Procedure delete_validate(p_rec in ben_xrc_shd.g_rec_type

618: --
619: -- ----------------------------------------------------------------------------
620: -- |---------------------------< delete_validate >----------------------------|
621: -- ----------------------------------------------------------------------------
622: Procedure delete_validate(p_rec in ben_xrc_shd.g_rec_type
623: ,p_effective_date in date) is
624: --
625: l_proc varchar2(72) := g_package||'delete_validate';
626: --

Line 633: ,ben_xrc_shd.g_old_rec.business_group_id

629: --
630: -- Call all supporting business operations
631: --
632: chk_startup_action(False
633: ,ben_xrc_shd.g_old_rec.business_group_id
634: ,ben_xrc_shd.g_old_rec.legislation_code);
635: --
636: hr_utility.set_location(' Leaving:'||l_proc, 10);
637: End delete_validate;

Line 634: ,ben_xrc_shd.g_old_rec.legislation_code);

630: -- Call all supporting business operations
631: --
632: chk_startup_action(False
633: ,ben_xrc_shd.g_old_rec.business_group_id
634: ,ben_xrc_shd.g_old_rec.legislation_code);
635: --
636: hr_utility.set_location(' Leaving:'||l_proc, 10);
637: End delete_validate;
638: --