DBA Data[Home] [Help]

APPS.PER_GB_ABSENCE_RULES dependencies on PER_GB_ABSENCE_RULES

Line 1: PACKAGE BODY per_gb_absence_rules AS

1: PACKAGE BODY per_gb_absence_rules AS
2: /* $Header: pegbabsr.pkb 120.16 2010/08/10 07:33:35 npannamp noship $ */
3:
4:
5: -------------------------------------------------------------------------------

Line 151: l_proc := 'PER_GB_ABSENCE_RULES';

147: -- Added for GSI Bug 5472781
148: --
149: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
150: --
151: l_proc := 'PER_GB_ABSENCE_RULES';
152:
153: hr_utility.set_location('Entering:'|| l_proc, 10);
154: hr_utility.trace(l_proc||': Opening get_abs_category'||
155: ', p_absence_attendance_id='||p_absence_attendance_id);

Line 219: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_CREATE ');

215: BEGIN
216: --
217: -- Added for GSI Bug 5472781
218: --
219: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_CREATE ');
220: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
221: --
222: -- Get absence_category
223: --

Line 256: hr_utility.trace(' Leaving PER_GB_ABSENCE_RULES.VALIDATE_ABS_CREATE ');

252: end if;
253: -- Bug 6888892 begin
254:
255: END IF;
256: hr_utility.trace(' Leaving PER_GB_ABSENCE_RULES.VALIDATE_ABS_CREATE ');
257: END validate_abs_create;
258:
259: -------------------------------------------------------------------------------
260: -- VALIDATE_ABS_UPDATE

Line 321: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_UPDATE ');

317: --7287548 End
318:
319: BEGIN
320: --
321: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_UPDATE ');
322: hr_utility.trace(' p_date_start '||p_date_start );
323: hr_utility.trace(' p_date_end '|| p_date_end );
324: hr_utility.trace(' p_time_start '||p_time_start);
325: hr_utility.trace(' p_time_end '|| p_time_end);

Line 502: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE ');

498: BEGIN
499: --
500: -- Added for GSI Bug 5472781
501: --
502: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE ');
503: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
504: --
505: -- Get absence_category
506: --

Line 507: hr_utility.trace('PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE : Fetching absence category');

503: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
504: --
505: -- Get absence_category
506: --
507: hr_utility.trace('PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE : Fetching absence category');
508: OPEN get_abs_category;
509: FETCH get_abs_category INTO l_abs_category;
510: CLOSE get_abs_category;
511: hr_utility.trace('PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE : absence category :'||l_abs_category);

Line 511: hr_utility.trace('PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE : absence category :'||l_abs_category);

507: hr_utility.trace('PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE : Fetching absence category');
508: OPEN get_abs_category;
509: FETCH get_abs_category INTO l_abs_category;
510: CLOSE get_abs_category;
511: hr_utility.trace('PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE : absence category :'||l_abs_category);
512:
513: IF l_abs_category = 'S' THEN
514: OPEN csr_absences;
515: FETCH csr_absences INTO l_absence;

Line 525: hr_utility.trace(' Leaving PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE ');

521: close csr_absences;
522: end if;
523: END IF;
524: END IF;
525: hr_utility.trace(' Leaving PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE ');
526: END validate_abs_delete;
527: --
528: END per_gb_absence_rules;

Line 528: END per_gb_absence_rules;

524: END IF;
525: hr_utility.trace(' Leaving PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE ');
526: END validate_abs_delete;
527: --
528: END per_gb_absence_rules;