DBA Data[Home] [Help]

APPS.HR_TIP_BUS dependencies on HR_TIP_SHD

Line 141: (p_rec in hr_tip_shd.g_rec_type

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

Line 153: IF NOT hr_tip_shd.api_updating

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

Line 164: nvl(hr_tip_shd.g_old_rec.template_item_id,hr_api.g_number)

160: fnd_message.raise_error;
161: END IF;
162: --
163: IF (nvl(p_rec.template_item_id,hr_api.g_number) <>
164: nvl(hr_tip_shd.g_old_rec.template_item_id,hr_api.g_number)
165: ) THEN
166: l_argument := 'template_item_id';
167: RAISE l_error;
168: END IF;

Line 171: nvl(hr_tip_shd.g_old_rec.template_tab_page_id,hr_api.g_number)

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

Line 285: l_api_updating := hr_tip_shd.api_updating

281: --
282: Begin
283: hr_utility.set_location('Entering:'||l_proc, 10);
284: --
285: l_api_updating := hr_tip_shd.api_updating
286: (p_template_item_tab_page_id => p_template_item_tab_page_id
287: ,p_object_version_number => p_object_version_number
288: );
289: hr_utility.set_location(l_proc,20);

Line 294: and ( nvl(hr_tip_shd.g_old_rec.template_item_id,hr_api.g_number) <>

290: --
291: -- Only proceed with SQL validation if absolutely necessary
292: --
293: if ( ( l_api_updating
294: and ( nvl(hr_tip_shd.g_old_rec.template_item_id,hr_api.g_number) <>
295: nvl(p_template_item_id,hr_api.g_number)
296: or nvl(hr_tip_shd.g_old_rec.template_tab_page_id,hr_api.g_number) <>
297: nvl(p_template_tab_page_id,hr_api.g_number)))
298: or (NOT l_api_updating)) then

Line 296: or nvl(hr_tip_shd.g_old_rec.template_tab_page_id,hr_api.g_number) <>

292: --
293: if ( ( l_api_updating
294: and ( nvl(hr_tip_shd.g_old_rec.template_item_id,hr_api.g_number) <>
295: nvl(p_template_item_id,hr_api.g_number)
296: or nvl(hr_tip_shd.g_old_rec.template_tab_page_id,hr_api.g_number) <>
297: nvl(p_template_tab_page_id,hr_api.g_number)))
298: or (NOT l_api_updating)) then
299: --
300: hr_utility.set_location(l_proc,30);

Line 360: (p_rec in hr_tip_shd.g_rec_type

356: -- ----------------------------------------------------------------------------
357: -- |------------------------------< chk_delete >------------------------------|
358: -- ----------------------------------------------------------------------------
359: Procedure chk_delete
360: (p_rec in hr_tip_shd.g_rec_type
361: ) is
362: --
363: l_proc varchar2(72) := g_package||'chk_delete';
364: --

Line 379: (p_rec in hr_tip_shd.g_rec_type

375: -- ----------------------------------------------------------------------------
376: -- |---------------------------< insert_validate >----------------------------|
377: -- ----------------------------------------------------------------------------
378: Procedure insert_validate
379: (p_rec in hr_tip_shd.g_rec_type
380: ) is
381: --
382: l_proc varchar2(72) := g_package||'insert_validate';
383: --

Line 416: (p_rec in hr_tip_shd.g_rec_type

412: -- ----------------------------------------------------------------------------
413: -- |---------------------------< update_validate >----------------------------|
414: -- ----------------------------------------------------------------------------
415: Procedure update_validate
416: (p_rec in hr_tip_shd.g_rec_type
417: ) is
418: --
419: l_proc varchar2(72) := g_package||'update_validate';
420: --

Line 457: (p_rec in hr_tip_shd.g_rec_type

453: -- ----------------------------------------------------------------------------
454: -- |---------------------------< delete_validate >----------------------------|
455: -- ----------------------------------------------------------------------------
456: Procedure delete_validate
457: (p_rec in hr_tip_shd.g_rec_type
458: ) is
459: --
460: l_proc varchar2(72) := g_package||'delete_validate';
461: --