[Home] [Help]
25: l_proc varchar2(72) := g_package||'set_security_group_id';
26: --
27: begin
28: --
29: hr_utility.set_location('Entering:'|| l_proc, 10);
30: --
31: hr_fim_bus.set_security_group_id
32: (p_form_item_id => p_form_item_id
33: );
31: hr_fim_bus.set_security_group_id
32: (p_form_item_id => p_form_item_id
33: );
34: --
35: hr_utility.set_location(' Leaving:'|| l_proc, 20);
36: --
37: end set_security_group_id;
38: --
39: -- ---------------------------------------------------------------------------
50: l_proc varchar2(72) := g_package||'return_legislation_code';
51: --
52: Begin
53: --
54: hr_utility.set_location('Entering:'|| l_proc, 10);
55: --
56: l_legislation_code := hr_fim_bus.return_legislation_code
57: (p_form_item_id => p_form_item_id
58: );
56: l_legislation_code := hr_fim_bus.return_legislation_code
57: (p_form_item_id => p_form_item_id
58: );
59: --
60: hr_utility.set_location(' Leaving:'|| l_proc, 40);
61: return l_legislation_code;
62: end return_legislation_code;
63: --
64: -- ----------------------------------------------------------------------------
140: l_api_updating boolean;
141: l_installed_flag varchar2(30);
142: --
143: Begin
144: hr_utility.set_location('Entering:'||l_proc, 10);
145: --
146: l_api_updating := hr_fit_shd.api_updating
147: (p_form_item_id => p_form_item_id
148: ,p_language => p_language
146: l_api_updating := hr_fit_shd.api_updating
147: (p_form_item_id => p_form_item_id
148: ,p_language => p_language
149: );
150: hr_utility.set_location(l_proc,20);
151: --
152: -- Only proceed with SQL validation if absolutely necessary
153: --
154: if ( ( l_api_updating
155: and nvl(hr_fit_shd.g_old_rec.source_lang,hr_api.g_varchar2) <>
156: nvl(p_source_lang,hr_api.g_varchar2))
157: or (NOT l_api_updating)) then
158: --
159: hr_utility.set_location(l_proc,30);
160: --
161: -- Check value has been passed
162: --
163: hr_api.mandatory_arg_error
165: ,p_argument => 'source_lang'
166: ,p_argument_value => p_source_lang
167: );
168: --
169: hr_utility.set_location(l_proc,40);
170: --
171: -- Check source language exists and is base or installed language
172: --
173: open csr_language;
189: end if;
190: --
191: end if;
192: --
193: hr_utility.set_location('Leaving:'||l_proc, 100);
194: End chk_source_lang;
195: --
196: -- ----------------------------------------------------------------------------
197: -- |--------------------------< chk_user_item_name >--------------------------|
205: l_proc varchar2(72) := g_package || 'chk_user_item_name';
206: l_api_updating boolean;
207: --
208: Begin
209: hr_utility.set_location('Entering:'||l_proc, 10);
210: --
211: -- Check value has been passed
212: --
213: hr_api.mandatory_arg_error
215: ,p_argument => 'user_item_name'
216: ,p_argument_value => p_user_item_name
217: );
218: --
219: hr_utility.set_location('Leaving:'||l_proc, 100);
220: End chk_user_item_name;
221: --
222: -- ----------------------------------------------------------------------------
223: -- |---------------------------< chk_description >----------------------------|
231: l_proc varchar2(72) := g_package || 'chk_description';
232: l_api_updating boolean;
233: --
234: Begin
235: hr_utility.set_location('Entering:'||l_proc, 10);
236: --
237: -- No additional validation required
238: --
239: null;
237: -- No additional validation required
238: --
239: null;
240: --
241: hr_utility.set_location('Leaving:'||l_proc, 100);
242: End chk_description;
243: --
244: -- ----------------------------------------------------------------------------
245: -- |------------------------------< chk_delete >------------------------------|
250: --
251: l_proc varchar2(72) := g_package||'chk_delete';
252: --
253: Begin
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: -- No additional validation required
257: --
258: null;
256: -- No additional validation required
257: --
258: null;
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: End chk_delete;
262: --
263: -- ----------------------------------------------------------------------------
264: -- |---------------------------< insert_validate >----------------------------|
269: --
270: l_proc varchar2(72) := g_package||'insert_validate';
271: --
272: Begin
273: hr_utility.set_location('Entering:'||l_proc, 5);
274: --
275: -- Call all supporting business operations
276: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
277: --
292: ,p_language => p_rec.language
293: ,p_description => p_rec.description
294: );
295: --
296: hr_utility.set_location(' Leaving:'||l_proc, 10);
297: End insert_validate;
298: --
299: -- ----------------------------------------------------------------------------
300: -- |---------------------------< update_validate >----------------------------|
305: --
306: l_proc varchar2(72) := g_package||'update_validate';
307: --
308: Begin
309: hr_utility.set_location('Entering:'||l_proc, 5);
310: --
311: -- Call all supporting business operations
312: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
313: --
332: ,p_language => p_rec.language
333: ,p_description => p_rec.description
334: );
335: --
336: hr_utility.set_location(' Leaving:'||l_proc, 10);
337: End update_validate;
338: --
339: -- ----------------------------------------------------------------------------
340: -- |---------------------------< delete_validate >----------------------------|
345: --
346: l_proc varchar2(72) := g_package||'delete_validate';
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: -- Call all supporting business operations
352: --
353: chk_delete
353: chk_delete
354: (p_rec => p_rec
355: );
356: --
357: hr_utility.set_location(' Leaving:'||l_proc, 10);
358: End delete_validate;
359: --
360: end hr_fit_bus;