[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_fwn_bus.set_security_group_id
32: (p_form_window_id => p_form_window_id
33: );
31: hr_fwn_bus.set_security_group_id
32: (p_form_window_id => p_form_window_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: -- Legislation code not available for form windows
57: --
58: l_legislation_code := hr_fwn_bus.return_legislation_code
58: l_legislation_code := hr_fwn_bus.return_legislation_code
59: (p_form_window_id => p_form_window_id
60: );
61: --
62: hr_utility.set_location(' Leaving:'|| l_proc, 40);
63: return l_legislation_code;
64: end return_legislation_code;
65: --
66: -- ----------------------------------------------------------------------------
142: l_api_updating boolean;
143: l_installed_flag varchar2(30);
144: --
145: Begin
146: hr_utility.set_location('Entering:'||l_proc, 10);
147: --
148: l_api_updating := hr_fwt_shd.api_updating
149: (p_form_window_id => p_form_window_id
150: ,p_language => p_language
148: l_api_updating := hr_fwt_shd.api_updating
149: (p_form_window_id => p_form_window_id
150: ,p_language => p_language
151: );
152: hr_utility.set_location(l_proc,20);
153: --
154: -- Only proceed with SQL validation if absolutely necessary
155: --
156: if ( ( l_api_updating
157: and nvl(hr_fwt_shd.g_old_rec.source_lang,hr_api.g_varchar2) <>
158: nvl(p_source_lang,hr_api.g_varchar2))
159: or (NOT l_api_updating)) then
160: --
161: hr_utility.set_location(l_proc,30);
162: --
163: -- Check value has been passed
164: --
165: hr_api.mandatory_arg_error
167: ,p_argument => 'source_lang'
168: ,p_argument_value => p_source_lang
169: );
170: --
171: hr_utility.set_location(l_proc,40);
172: --
173: -- Check source language exists and is base or installed language
174: --
175: open csr_language;
191: end if;
192: --
193: end if;
194: --
195: hr_utility.set_location('Leaving:'||l_proc, 100);
196: End chk_source_lang;
197: --
198: -- ----------------------------------------------------------------------------
199: -- |-------------------------< chk_user_window_name >-------------------------|
207: l_proc varchar2(72) := g_package || 'chk_user_window_name';
208: l_api_updating boolean;
209: --
210: Begin
211: hr_utility.set_location('Entering:'||l_proc, 10);
212: --
213: -- Check value has been passed
214: --
215: hr_api.mandatory_arg_error
217: ,p_argument => 'user_window_name'
218: ,p_argument_value => p_user_window_name
219: );
220: --
221: hr_utility.set_location('Leaving:'||l_proc, 100);
222: End chk_user_window_name;
223: --
224: -- ----------------------------------------------------------------------------
225: -- |---------------------------< chk_description >----------------------------|
233: l_proc varchar2(72) := g_package || 'chk_description';
234: l_api_updating boolean;
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 10);
238: --
239: -- No additional validation required
240: --
241: null;
239: -- No additional validation required
240: --
241: null;
242: --
243: hr_utility.set_location('Leaving:'||l_proc, 100);
244: End chk_description;
245: --
246: -- ----------------------------------------------------------------------------
247: -- |------------------------------< chk_delete >------------------------------|
252: --
253: l_proc varchar2(72) := g_package||'chk_delete';
254: --
255: Begin
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: -- No additional validation required
259: --
260: null;
258: -- No additional validation required
259: --
260: null;
261: --
262: hr_utility.set_location(' Leaving:'||l_proc, 10);
263: End chk_delete;
264: --
265: -- ----------------------------------------------------------------------------
266: -- |---------------------------< insert_validate >----------------------------|
271: --
272: l_proc varchar2(72) := g_package||'insert_validate';
273: --
274: Begin
275: hr_utility.set_location('Entering:'||l_proc, 5);
276: --
277: -- Call all supporting business operations
278: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
279: --
294: ,p_language => p_rec.language
295: ,p_description => p_rec.description
296: );
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 10);
299: End insert_validate;
300: --
301: -- ----------------------------------------------------------------------------
302: -- |---------------------------< update_validate >----------------------------|
307: --
308: l_proc varchar2(72) := g_package||'update_validate';
309: --
310: Begin
311: hr_utility.set_location('Entering:'||l_proc, 5);
312: --
313: -- Call all supporting business operations
314: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
315: --
334: ,p_language => p_rec.language
335: ,p_description => p_rec.description
336: );
337: --
338: hr_utility.set_location(' Leaving:'||l_proc, 10);
339: End update_validate;
340: --
341: -- ----------------------------------------------------------------------------
342: -- |---------------------------< delete_validate >----------------------------|
347: --
348: l_proc varchar2(72) := g_package||'delete_validate';
349: --
350: Begin
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: -- Call all supporting business operations
354: --
355: chk_delete
355: chk_delete
356: (p_rec => p_rec
357: );
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 10);
360: End delete_validate;
361: --
362: end hr_fwt_bus;