APPS.BEN_XDD_BUS dependencies on BEN_XDD_SHD

Line 106: l_api_updating := ben_xdd_shd.api_updating

102: Begin
103: --
104: hr_utility.set_location('Entering:'||l_proc, 5);
105: --
106: l_api_updating := ben_xdd_shd.api_updating
107: (p_ext_data_elmt_decd_id => p_ext_data_elmt_decd_id,
108: p_object_version_number => p_object_version_number);
109: --
110: if (l_api_updating

Line 112: <> ben_xdd_shd.g_old_rec.ext_data_elmt_decd_id) then

108: p_object_version_number => p_object_version_number);
109: --
110: if (l_api_updating
111: and nvl(p_ext_data_elmt_decd_id,hr_api.g_number)
112: <> ben_xdd_shd.g_old_rec.ext_data_elmt_decd_id) then
113: --
114: -- raise error as PK has changed
115: --
116: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_PK');

Line 116: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_PK');

112: <> ben_xdd_shd.g_old_rec.ext_data_elmt_decd_id) then
113: --
114: -- raise error as PK has changed
115: --
116: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_PK');
117: --
118: elsif not l_api_updating then
119: --
120: -- check if PK is null

Line 126: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_PK');

122: if p_ext_data_elmt_decd_id is not null then
123: --
124: -- raise error as PK is not null
125: --
126: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_PK');
127: --
128: end if;
129: --
130: end if;

Line 178: l_api_updating := ben_xdd_shd.api_updating

174: Begin
175: --
176: hr_utility.set_location('Entering:'||l_proc,5);
177: --
178: l_api_updating := ben_xdd_shd.api_updating
179: (p_ext_data_elmt_decd_id => p_ext_data_elmt_decd_id,
180: p_object_version_number => p_object_version_number);
181: --
182: if (l_api_updating

Line 184: <> nvl(ben_xdd_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)

180: p_object_version_number => p_object_version_number);
181: --
182: if (l_api_updating
183: and nvl(p_ext_data_elmt_id,hr_api.g_number)
184: <> nvl(ben_xdd_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)
185: or not l_api_updating) then
186: --
187: -- check if ext_data_elmt_id value exists in ben_ext_data_elmt table
188: --

Line 199: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_FK1');

195: --
196: -- raise error as FK does not relate to PK in ben_ext_data_elmt
197: -- table.
198: --
199: ben_xdd_shd.constraint_error('BEN_EXT_DATA_ELMT_DECD_FK1');
200: --
201: end if;
202: --
203: close c1;

Line 412: Procedure insert_validate(p_rec in ben_xdd_shd.g_rec_type) is

408: --
409: -- ----------------------------------------------------------------------------
410: -- |---------------------------< insert_validate >----------------------------|
411: -- ----------------------------------------------------------------------------
412: Procedure insert_validate(p_rec in ben_xdd_shd.g_rec_type) is
413: --
414: l_proc varchar2(72) := g_package||'insert_validate';
415: --
416: Begin

Line 459: Procedure update_validate(p_rec in ben_xdd_shd.g_rec_type) is

455: --
456: -- ----------------------------------------------------------------------------
457: -- |---------------------------< update_validate >----------------------------|
458: -- ----------------------------------------------------------------------------
459: Procedure update_validate(p_rec in ben_xdd_shd.g_rec_type) is
460: --
461: l_proc varchar2(72) := g_package||'update_validate';
462: --
463: Begin

Line 506: Procedure delete_validate(p_rec in ben_xdd_shd.g_rec_type) is

502: --
503: -- ----------------------------------------------------------------------------
504: -- |---------------------------< delete_validate >----------------------------|
505: -- ----------------------------------------------------------------------------
506: Procedure delete_validate(p_rec in ben_xdd_shd.g_rec_type) is
507: --
508: l_proc varchar2(72) := g_package||'delete_validate';
509: --
510: Begin

Line 516: ,ben_xdd_shd.g_old_rec.business_group_id

512: --
513: -- Call all supporting business operations
514: --
515: chk_startup_action(False
516: ,ben_xdd_shd.g_old_rec.business_group_id
517: ,ben_xdd_shd.g_old_rec.legislation_code);
518: --
519: hr_utility.set_location(' Leaving:'||l_proc, 10);
520: End delete_validate;

Line 517: ,ben_xdd_shd.g_old_rec.legislation_code);

513: -- Call all supporting business operations
514: --
515: chk_startup_action(False
516: ,ben_xdd_shd.g_old_rec.business_group_id
517: ,ben_xdd_shd.g_old_rec.legislation_code);
518: --
519: hr_utility.set_location(' Leaving:'||l_proc, 10);
520: End delete_validate;
521: --