DBA Data[Home] [Help]

APPS.HR_SFT_BUS dependencies on HR_SFT_SHD

Line 90: (p_rec in hr_sft_shd.g_rec_type

86: --
87: -- {End Of Comments}
88: -- ----------------------------------------------------------------------------
89: Procedure chk_non_updateable_args
90: (p_rec in hr_sft_shd.g_rec_type
91: ) IS
92: --
93: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
94: l_error EXCEPTION;

Line 102: IF NOT hr_sft_shd.api_updating

98: --
99: -- Only proceed with the validation if a row exists for the current
100: -- record in the HR Schema.
101: --
102: IF NOT hr_sft_shd.api_updating
103: (p_source_form_template_id => p_rec.source_form_template_id
104: ,p_object_version_number => p_rec.object_version_number
105: ) THEN
106: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 113: nvl(hr_sft_shd.g_old_rec.form_template_id_from,hr_api.g_number)

109: fnd_message.raise_error;
110: END IF;
111: --
112: IF (nvl(p_rec.form_template_id_from,hr_api.g_number) <>
113: nvl(hr_sft_shd.g_old_rec.form_template_id_from,hr_api.g_number)
114: ) THEN
115: l_argument := 'form_template_id_from';
116: RAISE l_error;
117: END IF;

Line 120: nvl(hr_sft_shd.g_old_rec.form_template_id_to,hr_api.g_number)

116: RAISE l_error;
117: END IF;
118: --
119: IF (nvl(p_rec.form_template_id_to,hr_api.g_number) <>
120: nvl(hr_sft_shd.g_old_rec.form_template_id_to,hr_api.g_number)
121: ) THEN
122: l_argument := 'form_template_id_to';
123: RAISE l_error;
124: END IF;

Line 209: l_api_updating := hr_sft_shd.api_updating

205: --
206: Begin
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: --
209: l_api_updating := hr_sft_shd.api_updating
210: (p_source_form_template_id => p_source_form_template_id
211: ,p_object_version_number => p_object_version_number
212: );
213: hr_utility.set_location(l_proc,20);

Line 218: and ( nvl(hr_sft_shd.g_old_rec.form_template_id_from,hr_api.g_number) <>

214: --
215: -- Only proceed with SQL validation if absolutely necessary
216: --
217: if ( ( l_api_updating
218: and ( nvl(hr_sft_shd.g_old_rec.form_template_id_from,hr_api.g_number) <>
219: nvl(p_form_template_id_from,hr_api.g_number)
220: or nvl(hr_sft_shd.g_old_rec.form_template_id_to,hr_api.g_number) <>
221: nvl(p_form_template_id_to,hr_api.g_number)))
222: or (NOT l_api_updating)) then

Line 220: or nvl(hr_sft_shd.g_old_rec.form_template_id_to,hr_api.g_number) <>

216: --
217: if ( ( l_api_updating
218: and ( nvl(hr_sft_shd.g_old_rec.form_template_id_from,hr_api.g_number) <>
219: nvl(p_form_template_id_from,hr_api.g_number)
220: or nvl(hr_sft_shd.g_old_rec.form_template_id_to,hr_api.g_number) <>
221: nvl(p_form_template_id_to,hr_api.g_number)))
222: or (NOT l_api_updating)) then
223: --
224: hr_utility.set_location(l_proc,30);

Line 280: (p_rec in hr_sft_shd.g_rec_type

276: -- ----------------------------------------------------------------------------
277: -- |------------------------------< chk_delete >------------------------------|
278: -- ----------------------------------------------------------------------------
279: Procedure chk_delete
280: (p_rec in hr_sft_shd.g_rec_type
281: ) is
282: --
283: l_proc varchar2(72) := g_package||'chk_delete';
284: --

Line 299: (p_rec in hr_sft_shd.g_rec_type

295: -- ----------------------------------------------------------------------------
296: -- |---------------------------< insert_validate >----------------------------|
297: -- ----------------------------------------------------------------------------
298: Procedure insert_validate
299: (p_rec in hr_sft_shd.g_rec_type
300: ) is
301: --
302: l_proc varchar2(72) := g_package||'insert_validate';
303: --

Line 334: (p_rec in hr_sft_shd.g_rec_type

330: -- ----------------------------------------------------------------------------
331: -- |---------------------------< update_validate >----------------------------|
332: -- ----------------------------------------------------------------------------
333: Procedure update_validate
334: (p_rec in hr_sft_shd.g_rec_type
335: ) is
336: --
337: l_proc varchar2(72) := g_package||'update_validate';
338: --

Line 373: (p_rec in hr_sft_shd.g_rec_type

369: -- ----------------------------------------------------------------------------
370: -- |---------------------------< delete_validate >----------------------------|
371: -- ----------------------------------------------------------------------------
372: Procedure delete_validate
373: (p_rec in hr_sft_shd.g_rec_type
374: ) is
375: --
376: l_proc varchar2(72) := g_package||'delete_validate';
377: --