APPS.HR_TWN_BUS dependencies on HR_TWN_SHD

Line 139: (p_rec in hr_twn_shd.g_rec_type

135: --
136: -- {End Of Comments}
137: -- ----------------------------------------------------------------------------
138: Procedure chk_non_updateable_args
139: (p_rec in hr_twn_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_twn_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_twn_shd.api_updating
152: (p_template_window_id => p_rec.template_window_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_twn_shd.g_old_rec.form_window_id,hr_api.g_number)

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

Line 169: nvl(hr_twn_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_twn_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 269: l_api_updating := hr_twn_shd.api_updating

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

Line 278: and ( nvl(hr_twn_shd.g_old_rec.form_window_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_twn_shd.g_old_rec.form_window_id,hr_api.g_number) <>
279: nvl(p_form_window_id,hr_api.g_number)
280: or nvl(hr_twn_shd.g_old_rec.form_template_id,hr_api.g_number) <>
281: nvl(p_form_template_id,hr_api.g_number)))
282: or (NOT l_api_updating)) then

Line 280: or nvl(hr_twn_shd.g_old_rec.form_template_id,hr_api.g_number) <>

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

Line 331: (p_rec in hr_twn_shd.g_rec_type

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

Line 350: (p_rec in hr_twn_shd.g_rec_type

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

Line 387: (p_rec in hr_twn_shd.g_rec_type

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

Line 428: (p_rec in hr_twn_shd.g_rec_type

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