DBA Data[Home] [Help]

APPS.HR_TCN_BUS dependencies on HR_TCN_SHD

Line 141: (p_rec in hr_tcn_shd.g_rec_type

137: --
138: -- {End Of Comments}
139: -- ----------------------------------------------------------------------------
140: Procedure chk_non_updateable_args
141: (p_rec in hr_tcn_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_tcn_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_tcn_shd.api_updating
154: (p_template_canvas_id => p_rec.template_canvas_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_tcn_shd.g_old_rec.form_canvas_id,hr_api.g_number)

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

Line 171: nvl(hr_tcn_shd.g_old_rec.template_window_id,hr_api.g_number)

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

Line 207: l_api_updating := hr_tcn_shd.api_updating

203: --
204: Begin
205: hr_utility.set_location('Entering:'||l_proc, 10);
206: --
207: l_api_updating := hr_tcn_shd.api_updating
208: (p_template_canvas_id => p_template_canvas_id
209: ,p_object_version_number => p_object_version_number
210: );
211: hr_utility.set_location(l_proc,20);

Line 311: l_api_updating := hr_tcn_shd.api_updating

307: --
308: Begin
309: hr_utility.set_location('Entering:'||l_proc, 10);
310: --
311: l_api_updating := hr_tcn_shd.api_updating
312: (p_template_canvas_id => p_template_canvas_id
313: ,p_object_version_number => p_object_version_number
314: );
315: hr_utility.set_location(l_proc,20);

Line 320: and ( nvl(hr_tcn_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

316: --
317: -- Only proceed with SQL validation if absolutely necessary
318: --
319: if ( ( l_api_updating
320: and ( nvl(hr_tcn_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
321: nvl(p_form_canvas_id,hr_api.g_number)
322: or nvl(hr_tcn_shd.g_old_rec.template_window_id,hr_api.g_number) <>
323: nvl(p_template_window_id,hr_api.g_number)))
324: or (NOT l_api_updating)) then

Line 322: or nvl(hr_tcn_shd.g_old_rec.template_window_id,hr_api.g_number) <>

318: --
319: if ( ( l_api_updating
320: and ( nvl(hr_tcn_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
321: nvl(p_form_canvas_id,hr_api.g_number)
322: or nvl(hr_tcn_shd.g_old_rec.template_window_id,hr_api.g_number) <>
323: nvl(p_template_window_id,hr_api.g_number)))
324: or (NOT l_api_updating)) then
325: --
326: hr_utility.set_location(l_proc,30);

Line 371: (p_rec in hr_tcn_shd.g_rec_type

367: -- ----------------------------------------------------------------------------
368: -- |------------------------------< chk_delete >------------------------------|
369: -- ----------------------------------------------------------------------------
370: Procedure chk_delete
371: (p_rec in hr_tcn_shd.g_rec_type
372: ) is
373: --
374: l_proc varchar2(72) := g_package||'chk_delete';
375: --

Line 390: (p_rec in hr_tcn_shd.g_rec_type

386: -- ----------------------------------------------------------------------------
387: -- |---------------------------< insert_validate >----------------------------|
388: -- ----------------------------------------------------------------------------
389: Procedure insert_validate
390: (p_rec in hr_tcn_shd.g_rec_type
391: ) is
392: --
393: l_proc varchar2(72) := g_package||'insert_validate';
394: --

Line 427: (p_rec in hr_tcn_shd.g_rec_type

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

Line 468: (p_rec in hr_tcn_shd.g_rec_type

464: -- ----------------------------------------------------------------------------
465: -- |---------------------------< delete_validate >----------------------------|
466: -- ----------------------------------------------------------------------------
467: Procedure delete_validate
468: (p_rec in hr_tcn_shd.g_rec_type
469: ) is
470: --
471: l_proc varchar2(72) := g_package||'delete_validate';
472: --