DBA Data[Home] [Help]

APPS.HR_TTP_BUS dependencies on HR_TTP_SHD

Line 144: (p_rec in hr_ttp_shd.g_rec_type

140: --
141: -- {End Of Comments}
142: -- ----------------------------------------------------------------------------
143: Procedure chk_non_updateable_args
144: (p_rec in hr_ttp_shd.g_rec_type
145: ) IS
146: --
147: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
148: l_error EXCEPTION;

Line 156: IF NOT hr_ttp_shd.api_updating

152: --
153: -- Only proceed with the validation if a row exists for the current
154: -- record in the HR Schema.
155: --
156: IF NOT hr_ttp_shd.api_updating
157: (p_template_tab_page_id => p_rec.template_tab_page_id
158: ,p_object_version_number => p_rec.object_version_number
159: ) THEN
160: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 167: nvl(hr_ttp_shd.g_old_rec.form_tab_page_id,hr_api.g_number)

163: fnd_message.raise_error;
164: END IF;
165: --
166: IF (nvl(p_rec.form_tab_page_id,hr_api.g_number) <>
167: nvl(hr_ttp_shd.g_old_rec.form_tab_page_id,hr_api.g_number)
168: ) THEN
169: l_argument := 'form_tab_page_id';
170: RAISE l_error;
171: END IF;

Line 174: nvl(hr_ttp_shd.g_old_rec.template_canvas_id,hr_api.g_number)

170: RAISE l_error;
171: END IF;
172: --
173: IF (nvl(p_rec.template_canvas_id,hr_api.g_number) <>
174: nvl(hr_ttp_shd.g_old_rec.template_canvas_id,hr_api.g_number)
175: ) THEN
176: l_argument := 'template_canvas_id';
177: RAISE l_error;
178: END IF;

Line 269: l_api_updating := hr_ttp_shd.api_updating

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

Line 278: and ( nvl(hr_ttp_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>

274: --
275: -- Only proceed with SQL validation if absolutely necessary
276: --
277: if ( ( l_api_updating
278: and ( nvl(hr_ttp_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
279: nvl(p_form_tab_page_id,hr_api.g_number)
280: or nvl(hr_ttp_shd.g_old_rec.template_canvas_id,hr_api.g_number) <>
281: nvl(p_template_canvas_id,hr_api.g_number)))
282: or (NOT l_api_updating)) then

Line 280: or nvl(hr_ttp_shd.g_old_rec.template_canvas_id,hr_api.g_number) <>

276: --
277: if ( ( l_api_updating
278: and ( nvl(hr_ttp_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
279: nvl(p_form_tab_page_id,hr_api.g_number)
280: or nvl(hr_ttp_shd.g_old_rec.template_canvas_id,hr_api.g_number) <>
281: nvl(p_template_canvas_id,hr_api.g_number)))
282: or (NOT l_api_updating)) then
283: --
284: hr_utility.set_location(l_proc,30);

Line 329: (p_rec in hr_ttp_shd.g_rec_type

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

Line 348: (p_rec in hr_ttp_shd.g_rec_type

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

Line 385: (p_rec in hr_ttp_shd.g_rec_type

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

Line 426: (p_rec in hr_ttp_shd.g_rec_type

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