DBA Data[Home] [Help]

APPS.HR_TDG_BUS dependencies on HR_TDG_SHD

Line 139: (p_rec in hr_tdg_shd.g_rec_type

135: --
136: -- {End Of Comments}
137: -- ----------------------------------------------------------------------------
138: Procedure chk_non_updateable_args
139: (p_rec in hr_tdg_shd.g_rec_type
140: ) IS
141: --
142: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
143: l_error EXCEPTION;

Line 151: IF NOT hr_tdg_shd.api_updating

147: --
148: -- Only proceed with the validation if a row exists for the current
149: -- record in the HR Schema.
150: --
151: IF NOT hr_tdg_shd.api_updating
152: (p_template_data_group_id => p_rec.template_data_group_id
153: ,p_object_version_number => p_rec.object_version_number
154: ) THEN
155: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 162: nvl(hr_tdg_shd.g_old_rec.form_data_group_id,hr_api.g_number)

158: fnd_message.raise_error;
159: END IF;
160: --
161: IF (nvl(p_rec.form_data_group_id,hr_api.g_number) <>
162: nvl(hr_tdg_shd.g_old_rec.form_data_group_id,hr_api.g_number)
163: ) THEN
164: l_argument := 'form_data_group_id';
165: RAISE l_error;
166: END IF;

Line 169: nvl(hr_tdg_shd.g_old_rec.form_template_id,hr_api.g_number)

165: RAISE l_error;
166: END IF;
167: --
168: IF (nvl(p_rec.form_template_id,hr_api.g_number) <>
169: nvl(hr_tdg_shd.g_old_rec.form_template_id,hr_api.g_number)
170: ) THEN
171: l_argument := 'form_template_id';
172: RAISE l_error;
173: END IF;

Line 268: l_api_updating := hr_tdg_shd.api_updating

264: --
265: Begin
266: hr_utility.set_location('Entering:'||l_proc, 10);
267: --
268: l_api_updating := hr_tdg_shd.api_updating
269: (p_template_data_group_id => p_template_data_group_id
270: ,p_object_version_number => p_object_version_number
271: );
272: hr_utility.set_location(l_proc,20);

Line 277: and ( nvl(hr_tdg_shd.g_old_rec.form_data_group_id,hr_api.g_number) <>

273: --
274: -- Only proceed with SQL validation if absolutely necessary
275: --
276: if ( ( l_api_updating
277: and ( nvl(hr_tdg_shd.g_old_rec.form_data_group_id,hr_api.g_number) <>
278: nvl(p_form_data_group_id,hr_api.g_number)
279: or nvl(hr_tdg_shd.g_old_rec.form_template_id,hr_api.g_number) <>
280: nvl(p_form_template_id,hr_api.g_number)))
281: or (NOT l_api_updating)) then

Line 279: or nvl(hr_tdg_shd.g_old_rec.form_template_id,hr_api.g_number) <>

275: --
276: if ( ( l_api_updating
277: and ( nvl(hr_tdg_shd.g_old_rec.form_data_group_id,hr_api.g_number) <>
278: nvl(p_form_data_group_id,hr_api.g_number)
279: or nvl(hr_tdg_shd.g_old_rec.form_template_id,hr_api.g_number) <>
280: nvl(p_form_template_id,hr_api.g_number)))
281: or (NOT l_api_updating)) then
282: --
283: hr_utility.set_location(l_proc,30);

Line 330: (p_rec in hr_tdg_shd.g_rec_type

326: -- ----------------------------------------------------------------------------
327: -- |------------------------------< chk_delete >------------------------------|
328: -- ----------------------------------------------------------------------------
329: Procedure chk_delete
330: (p_rec in hr_tdg_shd.g_rec_type
331: ) is
332: --
333: l_proc varchar2(72) := g_package||'chk_delete';
334: --

Line 349: (p_rec in hr_tdg_shd.g_rec_type

345: -- ----------------------------------------------------------------------------
346: -- |---------------------------< insert_validate >----------------------------|
347: -- ----------------------------------------------------------------------------
348: Procedure insert_validate
349: (p_rec in hr_tdg_shd.g_rec_type
350: ) is
351: --
352: l_proc varchar2(72) := g_package||'insert_validate';
353: --

Line 386: (p_rec in hr_tdg_shd.g_rec_type

382: -- ----------------------------------------------------------------------------
383: -- |---------------------------< update_validate >----------------------------|
384: -- ----------------------------------------------------------------------------
385: Procedure update_validate
386: (p_rec in hr_tdg_shd.g_rec_type
387: ) is
388: --
389: l_proc varchar2(72) := g_package||'update_validate';
390: --

Line 427: (p_rec in hr_tdg_shd.g_rec_type

423: -- ----------------------------------------------------------------------------
424: -- |---------------------------< delete_validate >----------------------------|
425: -- ----------------------------------------------------------------------------
426: Procedure delete_validate
427: (p_rec in hr_tdg_shd.g_rec_type
428: ) is
429: --
430: l_proc varchar2(72) := g_package||'delete_validate';
431: --