DBA Data[Home] [Help]

APPS.HR_TCP_BUS dependencies on HR_TCP_SHD

Line 143: (p_rec in hr_tcp_shd.g_rec_type

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

Line 155: IF NOT hr_tcp_shd.api_updating

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

Line 166: nvl(hr_tcp_shd.g_old_rec.template_item_context_id,hr_api.g_number)

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

Line 173: nvl(hr_tcp_shd.g_old_rec.template_tab_page_id,hr_api.g_number)

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

Line 291: l_api_updating := hr_tcp_shd.api_updating

287: --
288: Begin
289: hr_utility.set_location('Entering:'||l_proc, 10);
290: --
291: l_api_updating := hr_tcp_shd.api_updating
292: (p_template_item_context_page_i => p_template_item_context_page_i
293: ,p_object_version_number => p_object_version_number
294: );
295: hr_utility.set_location(l_proc,20);

Line 300: and ( nvl(hr_tcp_shd.g_old_rec.template_item_context_id,hr_api.g_number) <>

296: --
297: -- Only proceed with SQL validation if absolutely necessary
298: --
299: if ( ( l_api_updating
300: and ( nvl(hr_tcp_shd.g_old_rec.template_item_context_id,hr_api.g_number) <>
301: nvl(p_template_item_context_id,hr_api.g_number)
302: or nvl(hr_tcp_shd.g_old_rec.template_tab_page_id,hr_api.g_number) <>
303: nvl(p_template_tab_page_id,hr_api.g_number)))
304: or (NOT l_api_updating)) then

Line 302: or nvl(hr_tcp_shd.g_old_rec.template_tab_page_id,hr_api.g_number) <>

298: --
299: if ( ( l_api_updating
300: and ( nvl(hr_tcp_shd.g_old_rec.template_item_context_id,hr_api.g_number) <>
301: nvl(p_template_item_context_id,hr_api.g_number)
302: or nvl(hr_tcp_shd.g_old_rec.template_tab_page_id,hr_api.g_number) <>
303: nvl(p_template_tab_page_id,hr_api.g_number)))
304: or (NOT l_api_updating)) then
305: --
306: hr_utility.set_location(l_proc,30);

Line 366: (p_rec in hr_tcp_shd.g_rec_type

362: -- ----------------------------------------------------------------------------
363: -- |------------------------------< chk_delete >------------------------------|
364: -- ----------------------------------------------------------------------------
365: Procedure chk_delete
366: (p_rec in hr_tcp_shd.g_rec_type
367: ) is
368: --
369: l_proc varchar2(72) := g_package||'chk_delete';
370: --

Line 385: (p_rec in hr_tcp_shd.g_rec_type

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

Line 422: (p_rec in hr_tcp_shd.g_rec_type

418: -- ----------------------------------------------------------------------------
419: -- |---------------------------< update_validate >----------------------------|
420: -- ----------------------------------------------------------------------------
421: Procedure update_validate
422: (p_rec in hr_tcp_shd.g_rec_type
423: ) is
424: --
425: l_proc varchar2(72) := g_package||'update_validate';
426: --

Line 463: (p_rec in hr_tcp_shd.g_rec_type

459: -- ----------------------------------------------------------------------------
460: -- |---------------------------< delete_validate >----------------------------|
461: -- ----------------------------------------------------------------------------
462: Procedure delete_validate
463: (p_rec in hr_tcp_shd.g_rec_type
464: ) is
465: --
466: l_proc varchar2(72) := g_package||'delete_validate';
467: --