[Home] [Help]
PACKAGE BODY: APPS.GHR_EXTRA_INFO
Source
1 PACKAGE BODY GHR_EXTRA_INFO AS
2 /* $Header: ghexinfo.pkb 115.3 99/10/18 00:35:19 porting ship $ */
3
4 g_package VARCHAR2(30) := 'GHR_EXTRA_INFO.';
5
6
7 -- -----------------------
8 PROCEDURE CLOSE_CURSOR(c_extra_info IN OUT c_extra_info_type)
9 -- -----------------------
10 IS
11 l_proc VARCHAR2(61) := g_package || 'CLOSE_CURSOR';
12 begin
13 hr_utility.set_location('Entering :' || l_proc, 10);
14 IF c_extra_info%ISOPEN THEN
15 hr_utility.set_location('Cursor Closed :' || l_proc, 10);
16 CLOSE c_extra_info;
17 END IF;
18 hr_utility.set_location('Leaving :' || l_proc, 10);
19 END;
20
21 -- -----------------------
22 FUNCTION OPEN_FETCH_CURSOR (
23 -- -----------------------
24 p_form_name in varchar2
25 ,p_date_effective in out date
26 ,p_id in out number
27 ,p_information_type in out varchar2
28 )
29 RETURN NUMBER
30 IS
31 l_proc VARCHAR2(61) := g_package || 'OPEN_FETCH_CURSOR';
32 l_result_code varchar2(30);
33 c_extra_info c_extra_info_type;
34 r_short_extra_info r_short_extra_info_type;
35 BEGIN
36
37 hr_utility.set_location('Entering :' || l_proc, 10);
38 hr_utility.set_location('ID :' || to_char(p_id) || l_proc, 11);
39 hr_utility.set_location('Date Effective : ' || to_char(p_date_effective, 'YYYY/MM/DD') || l_proc, 12);
40 hr_utility.set_location('Form Name :' || p_form_name || l_proc, 13);
41 hr_utility.set_location('Info Type :' || p_information_type || l_proc, 14);
42 g_records_fetched := 0;
43 g_current_record := 1;
44 IF p_form_name IN ('PERWSPOI','GHRWSPOC') THEN
45 open c_extra_info for
46 select
47 poi.position_extra_info_id extra_info_id
48 ,poi.position_id id
49 ,poi.information_type information_type
50 ,poi.object_version_number object_version_number
51 ,poi.last_update_date last_update_date
52 ,poi.last_updated_by last_updated_by
53 ,poi.last_update_login last_update_login
54 ,poi.created_by created_by
55 ,poi.creation_date creation_date
56 from per_position_extra_info poi
57 where poi.position_id = p_id
58 and poi.information_type = p_information_type;
59 ELSIF p_form_name = 'PERWSPEI' THEN
60 open c_extra_info for
61 select
62 pei.person_extra_info_id extra_info_id
63 ,pei.person_id id
64 ,pei.information_type information_type
65 ,pei.object_version_number object_version_number
66 ,pei.last_update_date last_update_date
67 ,pei.last_updated_by last_updated_by
68 ,pei.last_update_login last_update_login
69 ,pei.created_by created_by
70 ,pei.creation_date creation_date
71 from per_people_extra_info pei
72 where pei.person_id = p_id
73 and pei.information_type = p_information_type;
74 ELSIF p_form_name = 'PERWSAEI' THEN
75 open c_extra_info for
76 select
77 aei.assignment_extra_info_id extra_info_id
78 ,aei.assignment_id id
79 ,aei.information_type information_type
80 ,aei.object_version_number object_version_number
81 ,aei.last_update_date last_update_date
82 ,aei.last_updated_by last_updated_by
83 ,aei.last_update_login last_update_login
84 ,aei.created_by created_by
85 ,aei.creation_date creation_date
86 from per_assignment_extra_info aei
87 where aei.assignment_id = p_id
88 and aei.information_type = p_information_type;
89 END IF;
90 LOOP
91 g_records_fetched := g_records_fetched + 1;
92 FETCH c_extra_info INTO r_short_extra_info;
93 --
94 IF c_extra_info%NOTFOUND THEN
95 g_records_fetched := g_records_fetched - 1;
96 close_cursor(c_extra_info);
97 return g_records_fetched;
98 END IF;
99 --
100 r_extra_info_tab(g_records_fetched).extra_info_id := r_short_extra_info.extra_info_id;
101 r_extra_info_tab(g_records_fetched).information_type := r_short_extra_info.information_type;
102 r_extra_info_tab(g_records_fetched).id := r_short_extra_info.id;
103
104 hr_utility.set_location('Calling ghr_history_fetch.fetch_.....ei' || l_proc, 20);
105
106 IF p_form_name IN ('PERWSPOI','GHRWSPOC') THEN
107
108 ghr_history_fetch.fetch_positionei(
109 p_position_extra_info_id => r_extra_info_tab(g_records_fetched).extra_info_id
110 ,p_date_effective => p_date_effective
111 ,p_position_id => r_extra_info_tab(g_records_fetched).id
112 ,p_information_type => r_extra_info_tab(g_records_fetched).information_type
113 ,p_request_id => r_extra_info_tab(g_records_fetched).request_id
114 ,p_program_application_id => r_extra_info_tab(g_records_fetched).program_application_id
115 ,p_program_id => r_extra_info_tab(g_records_fetched).program_id
116 ,p_program_update_date => r_extra_info_tab(g_records_fetched).program_update_date
117 ,p_poei_attribute_category => r_extra_info_tab(g_records_fetched).attribute_category
118 ,p_poei_attribute1 => r_extra_info_tab(g_records_fetched).attribute1
119 ,p_poei_attribute2 => r_extra_info_tab(g_records_fetched).attribute2
120 ,p_poei_attribute3 => r_extra_info_tab(g_records_fetched).attribute3
121 ,p_poei_attribute4 => r_extra_info_tab(g_records_fetched).attribute4
122 ,p_poei_attribute5 => r_extra_info_tab(g_records_fetched).attribute5
123 ,p_poei_attribute6 => r_extra_info_tab(g_records_fetched).attribute6
124 ,p_poei_attribute7 => r_extra_info_tab(g_records_fetched).attribute7
125 ,p_poei_attribute8 => r_extra_info_tab(g_records_fetched).attribute8
126 ,p_poei_attribute9 => r_extra_info_tab(g_records_fetched).attribute9
127 ,p_poei_attribute10 => r_extra_info_tab(g_records_fetched).attribute10
128 ,p_poei_attribute11 => r_extra_info_tab(g_records_fetched).attribute11
129 ,p_poei_attribute12 => r_extra_info_tab(g_records_fetched).attribute12
130 ,p_poei_attribute13 => r_extra_info_tab(g_records_fetched).attribute13
131 ,p_poei_attribute14 => r_extra_info_tab(g_records_fetched).attribute14
132 ,p_poei_attribute15 => r_extra_info_tab(g_records_fetched).attribute15
133 ,p_poei_attribute16 => r_extra_info_tab(g_records_fetched).attribute16
134 ,p_poei_attribute17 => r_extra_info_tab(g_records_fetched).attribute17
135 ,p_poei_attribute18 => r_extra_info_tab(g_records_fetched).attribute18
136 ,p_poei_attribute19 => r_extra_info_tab(g_records_fetched).attribute19
137 ,p_poei_attribute20 => r_extra_info_tab(g_records_fetched).attribute20
138 ,p_poei_information_category => r_extra_info_tab(g_records_fetched).information_category
139 ,p_poei_information1 => r_extra_info_tab(g_records_fetched).information1
140 ,p_poei_information2 => r_extra_info_tab(g_records_fetched).information2
141 ,p_poei_information3 => r_extra_info_tab(g_records_fetched).information3
142 ,p_poei_information4 => r_extra_info_tab(g_records_fetched).information4
143 ,p_poei_information5 => r_extra_info_tab(g_records_fetched).information5
144 ,p_poei_information6 => r_extra_info_tab(g_records_fetched).information6
145 ,p_poei_information7 => r_extra_info_tab(g_records_fetched).information7
146 ,p_poei_information8 => r_extra_info_tab(g_records_fetched).information8
147 ,p_poei_information9 => r_extra_info_tab(g_records_fetched).information9
148 ,p_poei_information10 => r_extra_info_tab(g_records_fetched).information10
149 ,p_poei_information11 => r_extra_info_tab(g_records_fetched).information11
150 ,p_poei_information12 => r_extra_info_tab(g_records_fetched).information12
151 ,p_poei_information13 => r_extra_info_tab(g_records_fetched).information13
152 ,p_poei_information14 => r_extra_info_tab(g_records_fetched).information14
153 ,p_poei_information15 => r_extra_info_tab(g_records_fetched).information15
154 ,p_poei_information16 => r_extra_info_tab(g_records_fetched).information16
155 ,p_poei_information17 => r_extra_info_tab(g_records_fetched).information17
156 ,p_poei_information18 => r_extra_info_tab(g_records_fetched).information18
157 ,p_poei_information19 => r_extra_info_tab(g_records_fetched).information19
158 ,p_poei_information20 => r_extra_info_tab(g_records_fetched).information20
159 ,p_poei_information21 => r_extra_info_tab(g_records_fetched).information21
160 ,p_poei_information22 => r_extra_info_tab(g_records_fetched).information22
161 ,p_poei_information23 => r_extra_info_tab(g_records_fetched).information23
162 ,p_poei_information24 => r_extra_info_tab(g_records_fetched).information24
163 ,p_poei_information25 => r_extra_info_tab(g_records_fetched).information25
164 ,p_poei_information26 => r_extra_info_tab(g_records_fetched).information26
165 ,p_poei_information27 => r_extra_info_tab(g_records_fetched).information27
166 ,p_poei_information28 => r_extra_info_tab(g_records_fetched).information28
167 ,p_poei_information29 => r_extra_info_tab(g_records_fetched).information29
168 ,p_poei_information30 => r_extra_info_tab(g_records_fetched).information30
169 ,p_object_version_number => r_extra_info_tab(g_records_fetched).object_version_number
170 ,p_last_update_date => r_extra_info_tab(g_records_fetched).last_update_date
171 ,p_last_updated_by => r_extra_info_tab(g_records_fetched).last_updated_by
172 ,p_last_update_login => r_extra_info_tab(g_records_fetched).last_update_login
173 ,p_created_by => r_extra_info_tab(g_records_fetched).created_by
174 ,p_creation_date => r_extra_info_tab(g_records_fetched).creation_date
175 ,p_result_code => l_result_code
176 );
177 ELSIF p_form_name = 'PERWSPEI' THEN
178
179 ghr_history_fetch.fetch_peopleei(
180 p_person_extra_info_id => r_extra_info_tab(g_records_fetched).extra_info_id
181 ,p_date_effective => p_date_effective
182 ,p_person_id => r_extra_info_tab(g_records_fetched).id
183 ,p_information_type => r_extra_info_tab(g_records_fetched).information_type
184 ,p_request_id => r_extra_info_tab(g_records_fetched).request_id
185 ,p_program_application_id => r_extra_info_tab(g_records_fetched).program_application_id
186 ,p_program_id => r_extra_info_tab(g_records_fetched).program_id
187 ,p_program_update_date => r_extra_info_tab(g_records_fetched).program_update_date
188 ,p_pei_attribute_category => r_extra_info_tab(g_records_fetched).attribute_category
189 ,p_pei_attribute1 => r_extra_info_tab(g_records_fetched).attribute1
190 ,p_pei_attribute2 => r_extra_info_tab(g_records_fetched).attribute2
191 ,p_pei_attribute3 => r_extra_info_tab(g_records_fetched).attribute3
192 ,p_pei_attribute4 => r_extra_info_tab(g_records_fetched).attribute4
193 ,p_pei_attribute5 => r_extra_info_tab(g_records_fetched).attribute5
194 ,p_pei_attribute6 => r_extra_info_tab(g_records_fetched).attribute6
195 ,p_pei_attribute7 => r_extra_info_tab(g_records_fetched).attribute7
196 ,p_pei_attribute8 => r_extra_info_tab(g_records_fetched).attribute8
197 ,p_pei_attribute9 => r_extra_info_tab(g_records_fetched).attribute9
198 ,p_pei_attribute10 => r_extra_info_tab(g_records_fetched).attribute10
199 ,p_pei_attribute11 => r_extra_info_tab(g_records_fetched).attribute11
200 ,p_pei_attribute12 => r_extra_info_tab(g_records_fetched).attribute12
201 ,p_pei_attribute13 => r_extra_info_tab(g_records_fetched).attribute13
202 ,p_pei_attribute14 => r_extra_info_tab(g_records_fetched).attribute14
203 ,p_pei_attribute15 => r_extra_info_tab(g_records_fetched).attribute15
204 ,p_pei_attribute16 => r_extra_info_tab(g_records_fetched).attribute16
205 ,p_pei_attribute17 => r_extra_info_tab(g_records_fetched).attribute17
206 ,p_pei_attribute18 => r_extra_info_tab(g_records_fetched).attribute18
207 ,p_pei_attribute19 => r_extra_info_tab(g_records_fetched).attribute19
208 ,p_pei_attribute20 => r_extra_info_tab(g_records_fetched).attribute20
209 ,p_pei_information_category => r_extra_info_tab(g_records_fetched).information_category
210 ,p_pei_information1 => r_extra_info_tab(g_records_fetched).information1
211 ,p_pei_information2 => r_extra_info_tab(g_records_fetched).information2
212 ,p_pei_information3 => r_extra_info_tab(g_records_fetched).information3
213 ,p_pei_information4 => r_extra_info_tab(g_records_fetched).information4
214 ,p_pei_information5 => r_extra_info_tab(g_records_fetched).information5
215 ,p_pei_information6 => r_extra_info_tab(g_records_fetched).information6
216 ,p_pei_information7 => r_extra_info_tab(g_records_fetched).information7
217 ,p_pei_information8 => r_extra_info_tab(g_records_fetched).information8
218 ,p_pei_information9 => r_extra_info_tab(g_records_fetched).information9
219 ,p_pei_information10 => r_extra_info_tab(g_records_fetched).information10
220 ,p_pei_information11 => r_extra_info_tab(g_records_fetched).information11
221 ,p_pei_information12 => r_extra_info_tab(g_records_fetched).information12
222 ,p_pei_information13 => r_extra_info_tab(g_records_fetched).information13
223 ,p_pei_information14 => r_extra_info_tab(g_records_fetched).information14
224 ,p_pei_information15 => r_extra_info_tab(g_records_fetched).information15
225 ,p_pei_information16 => r_extra_info_tab(g_records_fetched).information16
226 ,p_pei_information17 => r_extra_info_tab(g_records_fetched).information17
227 ,p_pei_information18 => r_extra_info_tab(g_records_fetched).information18
228 ,p_pei_information19 => r_extra_info_tab(g_records_fetched).information19
229 ,p_pei_information20 => r_extra_info_tab(g_records_fetched).information20
230 ,p_pei_information21 => r_extra_info_tab(g_records_fetched).information21
231 ,p_pei_information22 => r_extra_info_tab(g_records_fetched).information22
232 ,p_pei_information23 => r_extra_info_tab(g_records_fetched).information23
233 ,p_pei_information24 => r_extra_info_tab(g_records_fetched).information24
234 ,p_pei_information25 => r_extra_info_tab(g_records_fetched).information25
235 ,p_pei_information26 => r_extra_info_tab(g_records_fetched).information26
236 ,p_pei_information27 => r_extra_info_tab(g_records_fetched).information27
237 ,p_pei_information28 => r_extra_info_tab(g_records_fetched).information28
238 ,p_pei_information29 => r_extra_info_tab(g_records_fetched).information29
242 ,p_last_updated_by => r_extra_info_tab(g_records_fetched).last_updated_by
239 ,p_pei_information30 => r_extra_info_tab(g_records_fetched).information30
240 ,p_object_version_number => r_extra_info_tab(g_records_fetched).object_version_number
241 ,p_last_update_date => r_extra_info_tab(g_records_fetched).last_update_date
243 ,p_last_update_login => r_extra_info_tab(g_records_fetched).last_update_login
244 ,p_created_by => r_extra_info_tab(g_records_fetched).created_by
245 ,p_creation_date => r_extra_info_tab(g_records_fetched).creation_date
246 ,p_result_code => l_result_code
247 );
248
249 ELSIF p_form_name = 'PERWSAEI' THEN
250
251 ghr_history_fetch.fetch_asgei(
252 p_assignment_extra_info_id => r_extra_info_tab(g_records_fetched).extra_info_id
253 ,p_date_effective => p_date_effective
254 ,p_assignment_id => r_extra_info_tab(g_records_fetched).id
255 ,p_information_type => r_extra_info_tab(g_records_fetched).information_type
256 ,p_request_id => r_extra_info_tab(g_records_fetched).request_id
257 ,p_program_application_id => r_extra_info_tab(g_records_fetched).program_application_id
258 ,p_program_id => r_extra_info_tab(g_records_fetched).program_id
259 ,p_program_update_date => r_extra_info_tab(g_records_fetched).program_update_date
260 ,p_aei_attribute_category => r_extra_info_tab(g_records_fetched).attribute_category
261 ,p_aei_attribute1 => r_extra_info_tab(g_records_fetched).attribute1
262 ,p_aei_attribute2 => r_extra_info_tab(g_records_fetched).attribute2
263 ,p_aei_attribute3 => r_extra_info_tab(g_records_fetched).attribute3
264 ,p_aei_attribute4 => r_extra_info_tab(g_records_fetched).attribute4
265 ,p_aei_attribute5 => r_extra_info_tab(g_records_fetched).attribute5
266 ,p_aei_attribute6 => r_extra_info_tab(g_records_fetched).attribute6
267 ,p_aei_attribute7 => r_extra_info_tab(g_records_fetched).attribute7
268 ,p_aei_attribute8 => r_extra_info_tab(g_records_fetched).attribute8
269 ,p_aei_attribute9 => r_extra_info_tab(g_records_fetched).attribute9
270 ,p_aei_attribute10 => r_extra_info_tab(g_records_fetched).attribute10
271 ,p_aei_attribute11 => r_extra_info_tab(g_records_fetched).attribute11
272 ,p_aei_attribute12 => r_extra_info_tab(g_records_fetched).attribute12
273 ,p_aei_attribute13 => r_extra_info_tab(g_records_fetched).attribute13
274 ,p_aei_attribute14 => r_extra_info_tab(g_records_fetched).attribute14
275 ,p_aei_attribute15 => r_extra_info_tab(g_records_fetched).attribute15
276 ,p_aei_attribute16 => r_extra_info_tab(g_records_fetched).attribute16
277 ,p_aei_attribute17 => r_extra_info_tab(g_records_fetched).attribute17
278 ,p_aei_attribute18 => r_extra_info_tab(g_records_fetched).attribute18
279 ,p_aei_attribute19 => r_extra_info_tab(g_records_fetched).attribute19
280 ,p_aei_attribute20 => r_extra_info_tab(g_records_fetched).attribute20
281 ,p_aei_information_category => r_extra_info_tab(g_records_fetched).information_category
282 ,p_aei_information1 => r_extra_info_tab(g_records_fetched).information1
283 ,p_aei_information2 => r_extra_info_tab(g_records_fetched).information2
284 ,p_aei_information3 => r_extra_info_tab(g_records_fetched).information3
285 ,p_aei_information4 => r_extra_info_tab(g_records_fetched).information4
286 ,p_aei_information5 => r_extra_info_tab(g_records_fetched).information5
287 ,p_aei_information6 => r_extra_info_tab(g_records_fetched).information6
288 ,p_aei_information7 => r_extra_info_tab(g_records_fetched).information7
289 ,p_aei_information8 => r_extra_info_tab(g_records_fetched).information8
290 ,p_aei_information9 => r_extra_info_tab(g_records_fetched).information9
291 ,p_aei_information10 => r_extra_info_tab(g_records_fetched).information10
292 ,p_aei_information11 => r_extra_info_tab(g_records_fetched).information11
293 ,p_aei_information12 => r_extra_info_tab(g_records_fetched).information12
294 ,p_aei_information13 => r_extra_info_tab(g_records_fetched).information13
295 ,p_aei_information14 => r_extra_info_tab(g_records_fetched).information14
296 ,p_aei_information15 => r_extra_info_tab(g_records_fetched).information15
297 ,p_aei_information16 => r_extra_info_tab(g_records_fetched).information16
298 ,p_aei_information17 => r_extra_info_tab(g_records_fetched).information17
299 ,p_aei_information18 => r_extra_info_tab(g_records_fetched).information18
300 ,p_aei_information19 => r_extra_info_tab(g_records_fetched).information19
301 ,p_aei_information20 => r_extra_info_tab(g_records_fetched).information20
302 ,p_aei_information21 => r_extra_info_tab(g_records_fetched).information21
303 ,p_aei_information22 => r_extra_info_tab(g_records_fetched).information22
304 ,p_aei_information23 => r_extra_info_tab(g_records_fetched).information23
308 ,p_aei_information27 => r_extra_info_tab(g_records_fetched).information27
305 ,p_aei_information24 => r_extra_info_tab(g_records_fetched).information24
306 ,p_aei_information25 => r_extra_info_tab(g_records_fetched).information25
307 ,p_aei_information26 => r_extra_info_tab(g_records_fetched).information26
309 ,p_aei_information28 => r_extra_info_tab(g_records_fetched).information28
310 ,p_aei_information29 => r_extra_info_tab(g_records_fetched).information29
311 ,p_aei_information30 => r_extra_info_tab(g_records_fetched).information30
312 ,p_object_version_number => r_extra_info_tab(g_records_fetched).object_version_number
313 ,p_last_update_date => r_extra_info_tab(g_records_fetched).last_update_date
314 ,p_last_updated_by => r_extra_info_tab(g_records_fetched).last_updated_by
315 ,p_last_update_login => r_extra_info_tab(g_records_fetched).last_update_login
316 ,p_created_by => r_extra_info_tab(g_records_fetched).created_by
317 ,p_creation_date => r_extra_info_tab(g_records_fetched).creation_date
318 ,p_result_code => l_result_code
319 );
320
321 END IF;
322 hr_utility.set_location('Back to ' || l_proc, 30);
323
324 hr_utility.set_location('Result Code :' || NVL(l_result_code, 'NULL'), 34);
325
326 hr_utility.set_location('Current Record :' || to_char(g_current_record), 35);
327 hr_utility.set_location('Records Fetched :' || to_char(g_records_fetched), 36);
328
329 IF l_result_code IS NOT NULL THEN
330 r_extra_info_tab(g_records_fetched).extra_info_id := r_short_extra_info.extra_info_id;
331 r_extra_info_tab(g_records_fetched).information_type := r_short_extra_info.information_type;
332 r_extra_info_tab(g_records_fetched).id := r_short_extra_info.id;
333 -- g_records_fetched := g_records_fetched - 1;
334 hr_utility.set_location('Current Record :' || to_char(g_current_record), 37);
335 hr_utility.set_location('Records Fetched :' || to_char(g_records_fetched), 38);
336 END IF;
337 r_extra_info_tab(g_records_fetched).object_version_number := r_short_extra_info.object_version_number;
338 r_extra_info_tab(g_records_fetched).last_update_date := r_short_extra_info.last_update_date;
339 r_extra_info_tab(g_records_fetched).last_updated_by := r_short_extra_info.last_updated_by;
340 r_extra_info_tab(g_records_fetched).last_update_login := r_short_extra_info.last_update_login;
341 r_extra_info_tab(g_records_fetched).created_by := r_short_extra_info.created_by;
342 r_extra_info_tab(g_records_fetched).creation_date := r_short_extra_info.creation_date;
343 END LOOP;
344 hr_utility.set_location('Leaving :' || l_proc, 40);
345 END;
346 -- -----------------------
347 FUNCTION FETCH_CURSOR(
348 -- -----------------------
349 p_extra_info_id out number
350 ,p_id out number
351 ,p_information_type out varchar2
352 ,p_request_id out number
353 ,p_program_application_id out number
354 ,p_program_id out number
355 ,p_program_update_date out date
356 ,p_attribute_category out varchar2
357 ,p_attribute1 out varchar2
358 ,p_attribute2 out varchar2
359 ,p_attribute3 out varchar2
360 ,p_attribute4 out varchar2
361 ,p_attribute5 out varchar2
362 ,p_attribute6 out varchar2
363 ,p_attribute7 out varchar2
364 ,p_attribute8 out varchar2
365 ,p_attribute9 out varchar2
366 ,p_attribute10 out varchar2
367 ,p_attribute11 out varchar2
368 ,p_attribute12 out varchar2
369 ,p_attribute13 out varchar2
370 ,p_attribute14 out varchar2
371 ,p_attribute15 out varchar2
372 ,p_attribute16 out varchar2
373 ,p_attribute17 out varchar2
374 ,p_attribute18 out varchar2
375 ,p_attribute19 out varchar2
376 ,p_attribute20 out varchar2
377 ,p_information_category out varchar2
378 ,p_information1 out varchar2
379 ,p_information2 out varchar2
380 ,p_information3 out varchar2
381 ,p_information4 out varchar2
382 ,p_information5 out varchar2
383 ,p_information6 out varchar2
384 ,p_information7 out varchar2
385 ,p_information8 out varchar2
386 ,p_information9 out varchar2
387 ,p_information10 out varchar2
388 ,p_information11 out varchar2
389 ,p_information12 out varchar2
390 ,p_information13 out varchar2
391 ,p_information14 out varchar2
392 ,p_information15 out varchar2
393 ,p_information16 out varchar2
394 ,p_information17 out varchar2
395 ,p_information18 out varchar2
396 ,p_information19 out varchar2
397 ,p_information20 out varchar2
398 ,p_information21 out varchar2
399 ,p_information22 out varchar2
400 ,p_information23 out varchar2
401 ,p_information24 out varchar2
402
403 ,p_information25 out varchar2
407 ,p_information29 out varchar2
404 ,p_information26 out varchar2
405 ,p_information27 out varchar2
406 ,p_information28 out varchar2
408 ,p_information30 out varchar2
409 ,p_object_version_number out number
410 ,p_last_update_date out date
411 ,p_last_updated_by out number
412 ,p_last_update_login out number
413 ,p_created_by out number
414 ,p_creation_date out date
415 )
416 RETURN VARCHAR2
417 IS
418 l_proc VARCHAR2(61) := g_package || 'FETCH_CURSOR';
419 BEGIN
420 hr_utility.set_location('Entering :' || l_proc, 10);
421 hr_utility.set_location('Current Record :' || to_char(g_current_record), 13);
422 hr_utility.set_location('Records Fetched :' || to_char(g_records_fetched), 18);
423 IF g_current_record > g_records_fetched THEN
424 hr_utility.set_location('Leaving :' || l_proc, 20);
425 RETURN 'FALSE';
426 END IF;
427 p_extra_info_id := r_extra_info_tab(g_current_record).extra_info_id;
428 p_id := r_extra_info_tab(g_current_record).id;
429 p_information_type := r_extra_info_tab(g_current_record).information_type;
430 p_request_id := r_extra_info_tab(g_current_record).request_id;
431 p_program_application_id := r_extra_info_tab(g_current_record).program_application_id;
432 p_program_id := r_extra_info_tab(g_current_record).program_id;
433 p_program_update_date := r_extra_info_tab(g_current_record).program_update_date;
434 p_attribute_category := r_extra_info_tab(g_current_record).attribute_category;
435 p_attribute1 := r_extra_info_tab(g_current_record).attribute1;
436 p_attribute2 := r_extra_info_tab(g_current_record).attribute2;
437 p_attribute3 := r_extra_info_tab(g_current_record).attribute3;
438 p_attribute4 := r_extra_info_tab(g_current_record).attribute4;
439 p_attribute5 := r_extra_info_tab(g_current_record).attribute5;
440 p_attribute6 := r_extra_info_tab(g_current_record).attribute6;
441 p_attribute7 := r_extra_info_tab(g_current_record).attribute7;
442 p_attribute8 := r_extra_info_tab(g_current_record).attribute8;
443 p_attribute9 := r_extra_info_tab(g_current_record).attribute9;
444 p_attribute10 := r_extra_info_tab(g_current_record).attribute10;
445 p_attribute11 := r_extra_info_tab(g_current_record).attribute11;
446 p_attribute12 := r_extra_info_tab(g_current_record).attribute12;
447 p_attribute13 := r_extra_info_tab(g_current_record).attribute13;
448 p_attribute14 := r_extra_info_tab(g_current_record).attribute14;
449 p_attribute15 := r_extra_info_tab(g_current_record).attribute15;
450 p_attribute16 := r_extra_info_tab(g_current_record).attribute16;
451 p_attribute17 := r_extra_info_tab(g_current_record).attribute17;
452 p_attribute18 := r_extra_info_tab(g_current_record).attribute18;
453 p_attribute19 := r_extra_info_tab(g_current_record).attribute19;
454 p_attribute20 := r_extra_info_tab(g_current_record).attribute20;
455 p_information_category := r_extra_info_tab(g_current_record).information_category;
456 p_information1 := r_extra_info_tab(g_current_record).information1;
457 p_information2 := r_extra_info_tab(g_current_record).information2;
458 p_information3 := r_extra_info_tab(g_current_record).information3;
459 p_information4 := r_extra_info_tab(g_current_record).information4;
460 p_information5 := r_extra_info_tab(g_current_record).information5;
461 p_information6 := r_extra_info_tab(g_current_record).information6;
462 p_information7 := r_extra_info_tab(g_current_record).information7;
463 p_information8 := r_extra_info_tab(g_current_record).information8;
464 p_information9 := r_extra_info_tab(g_current_record).information9;
465 p_information10 := r_extra_info_tab(g_current_record).information10;
466 p_information11 := r_extra_info_tab(g_current_record).information11;
467 p_information12 := r_extra_info_tab(g_current_record).information12;
468 p_information13 := r_extra_info_tab(g_current_record).information13;
469 p_information14 := r_extra_info_tab(g_current_record).information14;
470 p_information15 := r_extra_info_tab(g_current_record).information15;
471 p_information16 := r_extra_info_tab(g_current_record).information16;
472 p_information17 := r_extra_info_tab(g_current_record).information17;
473 p_information18 := r_extra_info_tab(g_current_record).information18;
474 p_information19 := r_extra_info_tab(g_current_record).information19;
475 p_information20 := r_extra_info_tab(g_current_record).information20;
476 p_information21 := r_extra_info_tab(g_current_record).information21;
477 p_information22 := r_extra_info_tab(g_current_record).information22;
478 p_information23 := r_extra_info_tab(g_current_record).information23;
479 p_information24 := r_extra_info_tab(g_current_record).information24;
480 p_information25 := r_extra_info_tab(g_current_record).information25;
481 p_information26 := r_extra_info_tab(g_current_record).information26;
482 p_information27 := r_extra_info_tab(g_current_record).information27;
483 p_information28 := r_extra_info_tab(g_current_record).information28;
484 p_information29 := r_extra_info_tab(g_current_record).information29;
485 p_information30 := r_extra_info_tab(g_current_record).information30;
486 p_object_version_number := r_extra_info_tab(g_current_record).object_version_number;
487 p_last_update_date := r_extra_info_tab(g_current_record).last_update_date;
488 p_last_updated_by := r_extra_info_tab(g_current_record).last_updated_by;
489 p_last_update_login := r_extra_info_tab(g_current_record).last_update_login;
490 p_created_by := r_extra_info_tab(g_current_record).created_by;
491 p_creation_date := r_extra_info_tab(g_current_record).creation_date;
492
493
494 hr_utility.set_location('Current Record ' || to_char(g_current_record)|| l_proc, 15);
495 hr_utility.set_location('extra_info_id :' || r_extra_info_tab(g_current_record).extra_info_id || l_proc, 20);
496 hr_utility.set_location('Information1 :' || r_extra_info_tab(g_current_record).information1|| l_proc, 30);
497 hr_utility.set_location('Information2 :' || r_extra_info_tab(g_current_record).information2|| l_proc, 40);
498 hr_utility.set_location('Information3 :' || r_extra_info_tab(g_current_record).information3|| l_proc, 50);
499 hr_utility.set_location('Information4 :' || r_extra_info_tab(g_current_record).information4|| l_proc, 60);
500 hr_utility.set_location('Information5 :' || r_extra_info_tab(g_current_record).information5|| l_proc, 70);
501 hr_utility.set_location('Information6 :' || r_extra_info_tab(g_current_record).information6|| l_proc, 80);
502
503 g_current_record := g_current_record + 1;
504 hr_utility.set_location('Leaving :' || l_proc, 90);
505 RETURN 'TRUE';
506 END;
507 END;