APPS.PER_GET_ELIG dependencies on PER_GET_ELIG

Line 1: PACKAGE BODY per_get_elig AS

1: PACKAGE BODY per_get_elig AS
2: -- $Header: perellst.pkb 120.0 2005/05/31 17:34:47 appldev noship $
3:
4: -----------------------------------------------------------------------------
5: --

Line 37: l_proc := 'per_get_elig.get_elig_obj_for_per_asg_live';

33: c_per_asg cur_type;
34: c_elig_obj cur_type;
35:
36: BEGIN
37: l_proc := 'per_get_elig.get_elig_obj_for_per_asg_live';
38: hr_utility.set_location('Entering: '|| l_proc, 10);
39: l_per_elig_obj := per_elig_obj(NULL,NULL,NULL,NULL,NULL,NULL);
40: x_eligible_object := per_elig_obj_varray(); -- initialize empty
41: x_return_status := '0';

Line 179: l_proc := 'per_get_elig.get_elig_obj_for_per_asg_cache';

175: AND OBJ.effective_start_date <= cp_effective_date
176: AND OBJ.effective_end_date >= cp_effective_date;
177:
178: BEGIN
179: l_proc := 'per_get_elig.get_elig_obj_for_per_asg_cache';
180: hr_utility.set_location('Entering: '|| l_proc, 10);
181: l_per_elig_obj := per_elig_obj(NULL,NULL,NULL,NULL,NULL,NULL);
182: x_eligible_object := per_elig_obj_varray(); -- initialize empty
183: x_return_status := '0';

Line 271: l_proc := 'per_get_elig.get_per_asg_for_elig_obj_live';

267: c_per cur_type;
268: c_asg cur_type;
269:
270: BEGIN
271: l_proc := 'per_get_elig.get_per_asg_for_elig_obj_live';
272: hr_utility.set_location('Entering: '|| l_proc, 10);
273: l_per_asg_obj := per_asg_obj(NULL,NULL,NULL,NULL,NULL);
274: x_person_assignment := per_asg_varray(); -- initialize empty
275: x_return_status := '0';

Line 440: l_proc := 'per_get_elig.get_per_asg_for_elig_obj_cache';

436: AND effective_start_date <= cp_effective_date
437: AND effective_end_date >= cp_effective_date;
438:
439: BEGIN
440: l_proc := 'per_get_elig.get_per_asg_for_elig_obj_cache';
441: hr_utility.set_location('Entering: '|| l_proc, 10);
442: l_per_asg_obj := per_asg_obj(NULL,NULL,NULL,NULL,NULL);
443: x_person_assignment := per_asg_varray(); -- initialize empty
444: x_return_status := '0';

Line 525: l_proc := 'per_get_elig.get_elig_obj_for_per_asg';

521: ) IS
522: l_proc VARCHAR2(50);
523: l_data_mode VARCHAR2(1);
524: BEGIN
525: l_proc := 'per_get_elig.get_elig_obj_for_per_asg';
526: hr_utility.set_location('Entering: '|| l_proc, 10);
527:
528: CASE
529: WHEN p_data_mode IS NULL THEN

Line 585: l_proc := 'per_get_elig.get_per_asg_for_elig_obj';

581: ) IS
582: l_proc VARCHAR2(50);
583: l_data_mode VARCHAR2(1);
584: BEGIN
585: l_proc := 'per_get_elig.get_per_asg_for_elig_obj';
586: hr_utility.set_location('Entering: '|| l_proc, 10);
587:
588: CASE
589: WHEN p_data_mode IS NULL THEN

Line 665: l_proc := 'per_get_elig.get_sch_for_per_asg';

661: AND start_date_active = cp_start_date
662: AND end_date_active = cp_end_date;
663:
664: BEGIN
665: l_proc := 'per_get_elig.get_sch_for_per_asg';
666: hr_utility.set_location('Entering: '|| l_proc, 10);
667: l_elig_obj_varray := per_elig_obj_varray();
668: l_elig_obj := per_elig_obj(NULL,NULL,NULL,NULL,NULL,NULL);
669: l_work_sch_obj := per_work_sch_obj(NULL,NULL,NULL,NULL,NULL);

Line 760: l_proc := 'per_get_elig.get_per_asg_for_sch';

756: AND start_date_active <= cp_effective_date
757: AND end_date_active >= cp_effective_date;
758:
759: BEGIN
760: l_proc := 'per_get_elig.get_per_asg_for_sch';
761: hr_utility.set_location('Entering: '|| l_proc, 10);
762: x_person_assignment := per_asg_varray(); -- initialize empty
763: x_return_status := '0';
764: x_return_message := '';

Line 799: END per_get_elig;

795: x_return_message := SQLERRM;
796:
797: END get_per_asg_for_sch;
798:
799: END per_get_elig;