[Home] [Help]
31: l_proc varchar2(72) := g_package||'set_security_group_id';
32: --
33: begin
34: --
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Ensure that all the mandatory parameter are not null
38: --
39: hr_api.mandatory_arg_error
62: hr_api.set_security_group_id
63: (p_security_group_id => l_security_group_id
64: );
65: --
66: hr_utility.set_location(' Leaving:'|| l_proc, 20);
67: --
68: end set_security_group_id;
69:
70: --
149: l_api_updating boolean;
150: --
151: Begin
152: --
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: l_api_updating := ben_xcr_shd.api_updating
156: (p_ext_crit_prfl_id => p_ext_crit_prfl_id,
157: p_object_version_number => p_object_version_number);
177: end if;
178: --
179: end if;
180: --
181: hr_utility.set_location('Leaving:'||l_proc, 10);
182: --
183: End chk_ext_crit_prfl_id;
184: --
185: -- ----------------------------------------------------------------------------
232: and business_group_id = p_business_group_id)
233: );
234: --
235: Begin
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: --
238: l_api_updating := ben_xcr_shd.api_updating
239: (p_ext_crit_prfl_id => p_ext_crit_prfl_id,
240: p_object_version_number => p_object_version_number);
252: fnd_message.raise_error;
253: end if;
254: end if;
255: --
256: hr_utility.set_location('Leaving:'||l_proc, 15);
257: End chk_name_unique;
258: --
259:
260:
281: and ecv.ext_crit_bg_id <> ecv.business_group_id
282: ;
283: --
284: Begin
285: hr_utility.set_location('Entering:'||l_proc, 5);
286: --
287: l_api_updating := ben_xcr_shd.api_updating
288: (p_ext_crit_prfl_id => p_ext_crit_prfl_id,
289: p_object_version_number => p_object_version_number);
341: end if ;
342:
343: end if;
344: --
345: hr_utility.set_location('Leaving:'||l_proc, 15);
346: End chk_ext_global_flag;
347:
348:
349:
354: --
355: l_proc varchar2(72) := g_package||'insert_validate';
356: --
357: Begin
358: hr_utility.set_location('Entering:'||l_proc, 5);
359: --
360: -- Call all supporting business operations
361: --
362: --
390: ) ;
391:
392:
393:
394: hr_utility.set_location(' Leaving:'||l_proc, 10);
395: End insert_validate;
396: --
397: -- ----------------------------------------------------------------------------
398: -- |---------------------------< update_validate >----------------------------|
401: --
402: l_proc varchar2(72) := g_package||'update_validate';
403: --
404: Begin
405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: -- Call all supporting business operations
408: --
409: --
435: ,p_effective_date => trunc(sysdate)
436: ) ;
437:
438:
439: hr_utility.set_location(' Leaving:'||l_proc, 10);
440: End update_validate;
441: --
442: -- ----------------------------------------------------------------------------
443: -- |---------------------------< delete_validate >----------------------------|
446: --
447: l_proc varchar2(72) := g_package||'delete_validate';
448: --
449: Begin
450: hr_utility.set_location('Entering:'||l_proc, 5);
451: --
452: -- Call all supporting business operations
453: --
454: chk_startup_action(False
454: chk_startup_action(False
455: ,ben_xcr_shd.g_old_rec.business_group_id
456: ,ben_xcr_shd.g_old_rec.legislation_code);
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 10);
459: End delete_validate;
460: --
461: --
462: -- ---------------------------------------------------------------------------
481: l_proc varchar2(72) := g_package||'return_legislation_code';
482: --
483: begin
484: --
485: hr_utility.set_location('Entering:'|| l_proc, 10);
486: --
487: -- Ensure that all the mandatory parameter are not null
488: --
489: hr_api.mandatory_arg_error(p_api_name => l_proc,
506: end if;
507: --
508: close csr_leg_code;
509: --
510: hr_utility.set_location(' Leaving:'|| l_proc, 20);
511: --
512: return l_legislation_code;
513: --
514: end return_legislation_code;