DBA Data[Home] [Help]

APPS.PER_GET_ELIG dependencies on PER_ELIG_OBJ_VARRAY

Line 16: , x_eligible_object OUT NOCOPY per_elig_obj_varray

12: ( p_person_id IN NUMBER
13: , p_assignment_id IN NUMBER DEFAULT NULL
14: , p_effective_date IN DATE
15: , p_table_name IN VARCHAR2
16: , x_eligible_object OUT NOCOPY per_elig_obj_varray
17: , x_return_status OUT NOCOPY NUMBER
18: , x_return_message OUT NOCOPY VARCHAR2
19: ) IS
20:

Line 40: x_eligible_object := per_elig_obj_varray(); -- initialize empty

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';
42: x_return_message := '';
43:
44: -- Cursor to fetch all the effective assignments for the given person

Line 148: , x_eligible_object OUT NOCOPY per_elig_obj_varray

144: ( p_person_id IN NUMBER
145: , p_assignment_id IN NUMBER DEFAULT NULL
146: , p_effective_date IN DATE
147: , p_table_name IN VARCHAR2
148: , x_eligible_object OUT NOCOPY per_elig_obj_varray
149: , x_return_status OUT NOCOPY NUMBER
150: , x_return_message OUT NOCOPY VARCHAR2
151: ) IS
152:

Line 182: x_eligible_object := per_elig_obj_varray(); -- initialize empty

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';
184: x_return_message := '';
185:
186: -- Cursor to fetch all the eligibile objects for the given person

Line 518: , x_eligible_object OUT NOCOPY per_elig_obj_varray

514: , p_assignment_id IN NUMBER DEFAULT NULL
515: , p_effective_date IN DATE
516: , p_table_name IN VARCHAR2
517: , p_data_mode IN VARCHAR2 DEFAULT NULL
518: , x_eligible_object OUT NOCOPY per_elig_obj_varray
519: , x_return_status OUT NOCOPY NUMBER
520: , x_return_message OUT NOCOPY VARCHAR2
521: ) IS
522: l_proc VARCHAR2(50);

Line 645: l_elig_obj_varray per_elig_obj_varray;

641: , x_return_message OUT NOCOPY VARCHAR2
642: ) IS
643:
644: l_proc VARCHAR2(50);
645: l_elig_obj_varray per_elig_obj_varray;
646: l_elig_obj per_elig_obj;
647: l_work_sch_obj per_work_sch_obj;
648:
649: l_schedule_name cac_sr_schedules_vl.schedule_name%TYPE;

Line 667: l_elig_obj_varray := per_elig_obj_varray();

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);
670: x_schedule := per_work_sch_varray(); -- initialize empty
671: x_return_status := '0';