eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_GET_ELIG dependencies on PER_ELIG_OBJ

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 22: l_per_elig_obj per_elig_obj;

18: , x_return_message OUT NOCOPY VARCHAR2
19: ) IS
20:
21: l_proc VARCHAR2(50);
22: l_per_elig_obj per_elig_obj;
23:
24: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
25: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
26: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;

Line 39: l_per_elig_obj := per_elig_obj(NULL,NULL,NULL,NULL,NULL,NULL);

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';
42: x_return_message := '';
43:

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 107: l_per_elig_obj.elig_obj_id := l_elig_obj_id;

103:
104: hr_utility.set_location('Eligible', 36);
105:
106: -- Capture details of eligibile object
107: l_per_elig_obj.elig_obj_id := l_elig_obj_id;
108: l_per_elig_obj.tab_name := p_table_name;
109: l_per_elig_obj.col_name := l_column_name;
110: l_per_elig_obj.col_value := l_column_value;
111: l_per_elig_obj.eff_start_date := l_elig_obj_eff_st_dt;

Line 108: l_per_elig_obj.tab_name := p_table_name;

104: hr_utility.set_location('Eligible', 36);
105:
106: -- Capture details of eligibile object
107: l_per_elig_obj.elig_obj_id := l_elig_obj_id;
108: l_per_elig_obj.tab_name := p_table_name;
109: l_per_elig_obj.col_name := l_column_name;
110: l_per_elig_obj.col_value := l_column_value;
111: l_per_elig_obj.eff_start_date := l_elig_obj_eff_st_dt;
112: l_per_elig_obj.eff_end_date := l_elig_obj_eff_en_dt;

Line 109: l_per_elig_obj.col_name := l_column_name;

105:
106: -- Capture details of eligibile object
107: l_per_elig_obj.elig_obj_id := l_elig_obj_id;
108: l_per_elig_obj.tab_name := p_table_name;
109: l_per_elig_obj.col_name := l_column_name;
110: l_per_elig_obj.col_value := l_column_value;
111: l_per_elig_obj.eff_start_date := l_elig_obj_eff_st_dt;
112: l_per_elig_obj.eff_end_date := l_elig_obj_eff_en_dt;
113:

Line 110: l_per_elig_obj.col_value := l_column_value;

106: -- Capture details of eligibile object
107: l_per_elig_obj.elig_obj_id := l_elig_obj_id;
108: l_per_elig_obj.tab_name := p_table_name;
109: l_per_elig_obj.col_name := l_column_name;
110: l_per_elig_obj.col_value := l_column_value;
111: l_per_elig_obj.eff_start_date := l_elig_obj_eff_st_dt;
112: l_per_elig_obj.eff_end_date := l_elig_obj_eff_en_dt;
113:
114: -- Save eligibile object into array

Line 111: l_per_elig_obj.eff_start_date := l_elig_obj_eff_st_dt;

107: l_per_elig_obj.elig_obj_id := l_elig_obj_id;
108: l_per_elig_obj.tab_name := p_table_name;
109: l_per_elig_obj.col_name := l_column_name;
110: l_per_elig_obj.col_value := l_column_value;
111: l_per_elig_obj.eff_start_date := l_elig_obj_eff_st_dt;
112: l_per_elig_obj.eff_end_date := l_elig_obj_eff_en_dt;
113:
114: -- Save eligibile object into array
115: x_eligible_object.EXTEND(1);

Line 112: l_per_elig_obj.eff_end_date := l_elig_obj_eff_en_dt;

108: l_per_elig_obj.tab_name := p_table_name;
109: l_per_elig_obj.col_name := l_column_name;
110: l_per_elig_obj.col_value := l_column_value;
111: l_per_elig_obj.eff_start_date := l_elig_obj_eff_st_dt;
112: l_per_elig_obj.eff_end_date := l_elig_obj_eff_en_dt;
113:
114: -- Save eligibile object into array
115: x_eligible_object.EXTEND(1);
116: x_eligible_object(x_eligible_object.COUNT) := l_per_elig_obj;

Line 116: x_eligible_object(x_eligible_object.COUNT) := l_per_elig_obj;

112: l_per_elig_obj.eff_end_date := l_elig_obj_eff_en_dt;
113:
114: -- Save eligibile object into array
115: x_eligible_object.EXTEND(1);
116: x_eligible_object(x_eligible_object.COUNT) := l_per_elig_obj;
117: END IF;
118:
119: END LOOP; -- Loop for eligibility objects
120: CLOSE c_elig_obj;

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 154: l_per_elig_obj per_elig_obj;

150: , x_return_message OUT NOCOPY VARCHAR2
151: ) IS
152:
153: l_proc VARCHAR2(50);
154: l_per_elig_obj per_elig_obj;
155:
156: -- Cursor to fetch all the eligibile objects for the given person
157: CURSOR c_elig_obj ( cp_person_id IN NUMBER
158: , cp_assignment_id IN NUMBER

Line 181: l_per_elig_obj := per_elig_obj(NULL,NULL,NULL,NULL,NULL,NULL);

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';
184: x_return_message := '';
185:

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 195: FETCH c_elig_obj INTO l_per_elig_obj.elig_obj_id

191:
192: hr_utility.set_location(l_proc, 20);
193:
194: LOOP -- for eligibility objects
195: FETCH c_elig_obj INTO l_per_elig_obj.elig_obj_id
196: ,l_per_elig_obj.tab_name
197: ,l_per_elig_obj.col_name
198: ,l_per_elig_obj.col_value
199: ,l_per_elig_obj.eff_start_date

Line 196: ,l_per_elig_obj.tab_name

192: hr_utility.set_location(l_proc, 20);
193:
194: LOOP -- for eligibility objects
195: FETCH c_elig_obj INTO l_per_elig_obj.elig_obj_id
196: ,l_per_elig_obj.tab_name
197: ,l_per_elig_obj.col_name
198: ,l_per_elig_obj.col_value
199: ,l_per_elig_obj.eff_start_date
200: ,l_per_elig_obj.eff_end_date;

Line 197: ,l_per_elig_obj.col_name

193:
194: LOOP -- for eligibility objects
195: FETCH c_elig_obj INTO l_per_elig_obj.elig_obj_id
196: ,l_per_elig_obj.tab_name
197: ,l_per_elig_obj.col_name
198: ,l_per_elig_obj.col_value
199: ,l_per_elig_obj.eff_start_date
200: ,l_per_elig_obj.eff_end_date;
201: EXIT WHEN c_elig_obj%NOTFOUND;

Line 198: ,l_per_elig_obj.col_value

194: LOOP -- for eligibility objects
195: FETCH c_elig_obj INTO l_per_elig_obj.elig_obj_id
196: ,l_per_elig_obj.tab_name
197: ,l_per_elig_obj.col_name
198: ,l_per_elig_obj.col_value
199: ,l_per_elig_obj.eff_start_date
200: ,l_per_elig_obj.eff_end_date;
201: EXIT WHEN c_elig_obj%NOTFOUND;
202: hr_utility.set_location('EligObjId '||l_per_elig_obj.elig_obj_id, 25);

Line 199: ,l_per_elig_obj.eff_start_date

195: FETCH c_elig_obj INTO l_per_elig_obj.elig_obj_id
196: ,l_per_elig_obj.tab_name
197: ,l_per_elig_obj.col_name
198: ,l_per_elig_obj.col_value
199: ,l_per_elig_obj.eff_start_date
200: ,l_per_elig_obj.eff_end_date;
201: EXIT WHEN c_elig_obj%NOTFOUND;
202: hr_utility.set_location('EligObjId '||l_per_elig_obj.elig_obj_id, 25);
203:

Line 200: ,l_per_elig_obj.eff_end_date;

196: ,l_per_elig_obj.tab_name
197: ,l_per_elig_obj.col_name
198: ,l_per_elig_obj.col_value
199: ,l_per_elig_obj.eff_start_date
200: ,l_per_elig_obj.eff_end_date;
201: EXIT WHEN c_elig_obj%NOTFOUND;
202: hr_utility.set_location('EligObjId '||l_per_elig_obj.elig_obj_id, 25);
203:
204: -- Save eligibile object into array

Line 202: hr_utility.set_location('EligObjId '||l_per_elig_obj.elig_obj_id, 25);

198: ,l_per_elig_obj.col_value
199: ,l_per_elig_obj.eff_start_date
200: ,l_per_elig_obj.eff_end_date;
201: EXIT WHEN c_elig_obj%NOTFOUND;
202: hr_utility.set_location('EligObjId '||l_per_elig_obj.elig_obj_id, 25);
203:
204: -- Save eligibile object into array
205: x_eligible_object.EXTEND(1);
206: x_eligible_object(x_eligible_object.COUNT) := l_per_elig_obj;

Line 206: x_eligible_object(x_eligible_object.COUNT) := l_per_elig_obj;

202: hr_utility.set_location('EligObjId '||l_per_elig_obj.elig_obj_id, 25);
203:
204: -- Save eligibile object into array
205: x_eligible_object.EXTEND(1);
206: x_eligible_object(x_eligible_object.COUNT) := l_per_elig_obj;
207:
208: END LOOP; -- for eligibility objects
209: CLOSE c_elig_obj;
210:

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 646: l_elig_obj per_elig_obj;

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;
650: l_schedule_category cac_sr_schedules_vl.schedule_category%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';

Line 668: l_elig_obj := per_elig_obj(NULL,NULL,NULL,NULL,NULL,NULL);

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';
672: x_return_message := '';