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_wnp_bus.set_security_group_id
32: (p_window_property_id => p_window_property_id
33: );
31: hr_wnp_bus.set_security_group_id
32: (p_window_property_id => p_window_property_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_wnp_bus.return_legislation_code
57: (p_window_property_id => p_window_property_id
58: );
56: l_legislation_code := hr_wnp_bus.return_legislation_code
57: (p_window_property_id => p_window_property_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_wpt_shd.api_updating
147: (p_window_property_id => p_window_property_id
148: ,p_language => p_language
146: l_api_updating := hr_wpt_shd.api_updating
147: (p_window_property_id => p_window_property_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_wpt_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;
191: */
192: --
193: end if;
194: --
195: hr_utility.set_location('Leaving:'||l_proc, 100);
196: End chk_source_lang;
197: --
198: -- ----------------------------------------------------------------------------
199: -- |------------------------------< chk_title >-------------------------------|
207: l_proc varchar2(72) := g_package || 'chk_title';
208: l_api_updating boolean;
209: --
210: Begin
211: hr_utility.set_location('Entering:'||l_proc, 10);
212: --
213: -- No additional validation
214: --
215: null;
213: -- No additional validation
214: --
215: null;
216: --
217: hr_utility.set_location('Leaving:'||l_proc, 100);
218: End chk_title;
219: --
220: -- ----------------------------------------------------------------------------
221: -- |------------------------------< chk_delete >------------------------------|
226: --
227: l_proc varchar2(72) := g_package||'chk_delete';
228: --
229: Begin
230: hr_utility.set_location('Entering:'||l_proc, 5);
231: --
232: -- No additional validation required
233: --
234: null;
232: -- No additional validation required
233: --
234: null;
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: End chk_delete;
238: --
239: -- ----------------------------------------------------------------------------
240: -- |---------------------------< insert_validate >----------------------------|
245: --
246: l_proc varchar2(72) := g_package||'insert_validate';
247: --
248: Begin
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: -- Call all supporting business operations
252: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
253: --
262: ,p_language => p_rec.language
263: ,p_title => p_rec.title
264: );
265: --
266: hr_utility.set_location(' Leaving:'||l_proc, 10);
267: End insert_validate;
268: --
269: -- ----------------------------------------------------------------------------
270: -- |---------------------------< update_validate >----------------------------|
275: --
276: l_proc varchar2(72) := g_package||'update_validate';
277: --
278: Begin
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: -- Call all supporting business operations
282: -- No business group context. HR_STANDARD_LOOKUPS used for validation.
283: --
296: ,p_language => p_rec.language
297: ,p_title => p_rec.title
298: );
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
301: End update_validate;
302: --
303: -- ----------------------------------------------------------------------------
304: -- |---------------------------< delete_validate >----------------------------|
309: --
310: l_proc varchar2(72) := g_package||'delete_validate';
311: --
312: Begin
313: hr_utility.set_location('Entering:'||l_proc, 5);
314: --
315: -- Call all supporting business operations
316: --
317: chk_delete
317: chk_delete
318: (p_rec => p_rec
319: );
320: --
321: hr_utility.set_location(' Leaving:'||l_proc, 10);
322: End delete_validate;
323: --
324: end hr_wpt_bus;