1 package GHR_HISTORY_FETCH as
2 /* $Header: ghhisfet.pkh 120.0.12010000.1 2008/07/28 10:31:30 appldev ship $ */
3
4 Procedure fetch_people (
5 p_person_id in number default null,
6 p_date_effective in date default null,
7 p_altered_pa_request_id in number default null,
8 p_noa_id_corrected in number default null,
9 p_rowid in rowid default null,
10 p_pa_history_id in number default null,
11 p_people_data out nocopy per_all_people_f%rowtype,
12 p_result_code out nocopy varchar2);
13
14 Procedure fetch_asgei (
15 p_assignment_extra_info_id in number default null,
16 p_date_effective in date default null,
17 p_altered_pa_request_id in number default null,
18 p_noa_id_corrected in number default null,
19 p_rowid in rowid default null,
20 p_pa_history_id in number default null,
21 p_get_ovn_flag in varchar2 default 'N',
22 p_asgei_data out nocopy per_assignment_extra_info%rowtype,
23 p_result_code out nocopy varchar2) ;
24
25 Procedure fetch_asgei (
26 p_assignment_id in number,
27 p_information_type in varchar2,
28 p_date_effective in date,
29 p_asg_ei_data out nocopy per_assignment_extra_info%rowtype);
30
31 Procedure get_date_eff_eleevl(
32 p_element_entry_value_id in number,
33 p_date_effective in date,
34 p_element_entry_data out nocopy pay_element_entry_values_f%rowtype,
35 p_result_code out nocopy varchar2,
36 p_pa_history_id out nocopy number);
37
38 Procedure fetch_assignment (
39 p_assignment_id in number default null,
40 p_date_effective in date default null,
41 p_altered_pa_request_id in number default null,
42 p_noa_id_corrected in number default null,
43 p_rowid in rowid default null,
44 p_pa_history_id in number default null,
45 p_assignment_data out nocopy per_all_assignments_f%rowtype,
46 p_result_code out nocopy varchar2);
47
48 Procedure fetch_peopleei (
49 p_person_extra_info_id in number default null,
50 p_date_effective in date default null,
51 p_altered_pa_request_id in number default null,
52 p_noa_id_corrected in number default null,
53 p_rowid in rowid default null,
54 p_pa_history_id in number default null,
55 p_get_ovn_flag in varchar2 default 'N',
56 p_peopleei_data in out nocopy per_people_extra_info%rowtype,
57 p_result_code out nocopy varchar2);
58
59 Procedure fetch_peopleei(
60 p_person_id in number,
61 p_information_type in varchar2,
62 p_date_effective in date,
63 p_per_ei_data in out nocopy per_people_extra_info%rowtype);
64
65 Procedure fetch_positionei (
66 p_position_extra_info_id in number default null,
67 p_date_effective in date default null,
68 p_altered_pa_request_id in number default null,
69 p_noa_id_corrected in number default null,
70 p_rowid in rowid default null,
71 p_pa_history_id in number default null,
72 p_get_ovn_flag in varchar2 default 'N',
73 p_posei_data out nocopy per_position_extra_info%rowtype,
74 p_result_code out nocopy varchar2 ) ;
75
76 Procedure fetch_positionei(
77 p_position_id in number,
78 p_information_type in varchar2,
79 p_date_effective in date,
80 p_pos_ei_data out nocopy per_position_extra_info%rowtype
81 ) ;
82
83 Procedure fetch_position (
84 p_position_id in number default null,
85 p_date_effective in date default null,
86 p_altered_pa_request_id in number default null,
87 p_noa_id_corrected in number default null,
88 p_rowid in rowid default null,
89 p_pa_history_id in number default null,
90 p_get_ovn_flag in varchar2 default 'N',
91 p_position_data out nocopy hr_all_positions_f%rowtype,
92 p_result_code out nocopy varchar2 ) ;
93
94 Procedure fetch_element_entries (
95 p_element_entry_id in number default null,
96 p_date_effective in date default null,
97 p_altered_pa_request_id in number default null,
98 p_noa_id_corrected in number default null,
99 p_rowid in rowid default null,
100 p_pa_history_id in number default null,
101 p_element_entry_data out nocopy pay_element_entries_f%rowtype,
102 p_result_code out nocopy varchar2 );
103
104 Procedure fetch_element_entry_value (
105 p_element_entry_value_id in number default null,
106 p_date_effective in date default null,
107 p_altered_pa_request_id in number default null,
108 p_noa_id_corrected in number default null,
109 p_rowid in rowid default null,
110 p_pa_history_id in number default null,
111 p_element_entry_data out nocopy pay_element_entry_values_f%rowtype,
112 p_result_code out nocopy varchar2 );
113
114 Procedure fetch_element_entry_value(
115 p_element_name in pay_element_types_f.element_name%type,
116 p_input_value_name in pay_input_values_f.name%type,
117 p_assignment_id in per_assignments_f.assignment_id%type,
118 p_date_effective in date,
119 p_screen_entry_value out nocopy pay_element_entry_values_f.screen_entry_value%type );
120
121
122 Procedure fetch_element_info_cor (
123 p_element_name in pay_element_types_f.element_name%type
124 ,p_input_value_name in pay_input_values_f.name%type
125 ,p_assignment_id in pay_element_entries_f.assignment_id%type
126 ,p_effective_date in date
127 ,p_element_link_id out nocopy pay_element_links_f.element_link_id%type
128 ,p_input_value_id out nocopy pay_input_values_f.input_value_id%type
129 ,p_element_entry_id out nocopy pay_element_entries_f.element_entry_id%type
130 ,p_value out nocopy pay_element_entry_values_f.screen_entry_value%type
131 ,p_object_version_number out nocopy pay_element_entries_f.object_version_number%type );
132
133
134 Procedure fetch_person_analyses (
135 p_person_analysis_id in number default null,
136 p_date_effective in date default null,
137 p_altered_pa_request_id in number default null,
138 p_noa_id_corrected in number default null,
139 p_rowid in rowid default null,
140 p_pa_history_id in number default null,
141 p_peranalyses_data out nocopy per_person_analyses%rowtype,
142 p_result_code out nocopy varchar2 );
143
144
145 Procedure fetch_positionei (
146 p_position_extra_info_id in out nocopy number
147 ,p_date_effective in out nocopy date
148 ,p_position_id out nocopy number
149 ,p_information_type out nocopy varchar2
150 ,p_request_id out nocopy number
151 ,p_program_application_id out nocopy number
152 ,p_program_id out nocopy number
153 ,p_program_update_date out nocopy date
154 ,p_poei_attribute_category out nocopy varchar2
155 ,p_poei_attribute1 out nocopy varchar2
156 ,p_poei_attribute2 out nocopy varchar2
157 ,p_poei_attribute3 out nocopy varchar2
158 ,p_poei_attribute4 out nocopy varchar2
159 ,p_poei_attribute5 out nocopy varchar2
160 ,p_poei_attribute6 out nocopy varchar2
161 ,p_poei_attribute7 out nocopy varchar2
162 ,p_poei_attribute8 out nocopy varchar2
163 ,p_poei_attribute9 out nocopy varchar2
164 ,p_poei_attribute10 out nocopy varchar2
165 ,p_poei_attribute11 out nocopy varchar2
166 ,p_poei_attribute12 out nocopy varchar2
167 ,p_poei_attribute13 out nocopy varchar2
168 ,p_poei_attribute14 out nocopy varchar2
169 ,p_poei_attribute15 out nocopy varchar2
170 ,p_poei_attribute16 out nocopy varchar2
171 ,p_poei_attribute17 out nocopy varchar2
172 ,p_poei_attribute18 out nocopy varchar2
173 ,p_poei_attribute19 out nocopy varchar2
174 ,p_poei_attribute20 out nocopy varchar2
175 ,p_poei_information_category out nocopy varchar2
176 ,p_poei_information1 out nocopy varchar2
177 ,p_poei_information2 out nocopy varchar2
178 ,p_poei_information3 out nocopy varchar2
179 ,p_poei_information4 out nocopy varchar2
180 ,p_poei_information5 out nocopy varchar2
181 ,p_poei_information6 out nocopy varchar2
182 ,p_poei_information7 out nocopy varchar2
183 ,p_poei_information8 out nocopy varchar2
184 ,p_poei_information9 out nocopy varchar2
185 ,p_poei_information10 out nocopy varchar2
186 ,p_poei_information11 out nocopy varchar2
187 ,p_poei_information12 out nocopy varchar2
188 ,p_poei_information13 out nocopy varchar2
189 ,p_poei_information14 out nocopy varchar2
190 ,p_poei_information15 out nocopy varchar2
191 ,p_poei_information16 out nocopy varchar2
192 ,p_poei_information17 out nocopy varchar2
193 ,p_poei_information18 out nocopy varchar2
194 ,p_poei_information19 out nocopy varchar2
195 ,p_poei_information20 out nocopy varchar2
196 ,p_poei_information21 out nocopy varchar2
197 ,p_poei_information22 out nocopy varchar2
198 ,p_poei_information23 out nocopy varchar2
199 ,p_poei_information24 out nocopy varchar2
200 ,p_poei_information25 out nocopy varchar2
201 ,p_poei_information26 out nocopy varchar2
202 ,p_poei_information27 out nocopy varchar2
203 ,p_poei_information28 out nocopy varchar2
204 ,p_poei_information29 out nocopy varchar2
205 ,p_poei_information30 out nocopy varchar2
206 ,p_object_version_number out nocopy number
207 ,p_last_update_date out nocopy date
208 ,p_last_updated_by out nocopy number
209 ,p_last_update_login out nocopy number
210 ,p_created_by out nocopy number
211 ,p_creation_date out nocopy date
212 ,p_result_code out nocopy varchar2
213 );
214
215 Procedure fetch_peopleei (
216 p_person_extra_info_id in out nocopy number
217 ,p_date_effective in out nocopy date
218 ,p_person_id out nocopy number
219 ,p_information_type out nocopy varchar2
220 ,p_request_id out nocopy number
221 ,p_program_application_id out nocopy number
222 ,p_program_id out nocopy number
223 ,p_program_update_date out nocopy date
224 ,p_pei_attribute_category out nocopy varchar2
225 ,p_pei_attribute1 out nocopy varchar2
226 ,p_pei_attribute2 out nocopy varchar2
227 ,p_pei_attribute3 out nocopy varchar2
228 ,p_pei_attribute4 out nocopy varchar2
229 ,p_pei_attribute5 out nocopy varchar2
230 ,p_pei_attribute6 out nocopy varchar2
231 ,p_pei_attribute7 out nocopy varchar2
232 ,p_pei_attribute8 out nocopy varchar2
233 ,p_pei_attribute9 out nocopy varchar2
234 ,p_pei_attribute10 out nocopy varchar2
235 ,p_pei_attribute11 out nocopy varchar2
236 ,p_pei_attribute12 out nocopy varchar2
237 ,p_pei_attribute13 out nocopy varchar2
238 ,p_pei_attribute14 out nocopy varchar2
239 ,p_pei_attribute15 out nocopy varchar2
240 ,p_pei_attribute16 out nocopy varchar2
241 ,p_pei_attribute17 out nocopy varchar2
242 ,p_pei_attribute18 out nocopy varchar2
243 ,p_pei_attribute19 out nocopy varchar2
244 ,p_pei_attribute20 out nocopy varchar2
245 ,p_pei_information_category out nocopy varchar2
246 ,p_pei_information1 out nocopy varchar2
247 ,p_pei_information2 out nocopy varchar2
248 ,p_pei_information3 out nocopy varchar2
249 ,p_pei_information4 out nocopy varchar2
250 ,p_pei_information5 out nocopy varchar2
251 ,p_pei_information6 out nocopy varchar2
252 ,p_pei_information7 out nocopy varchar2
253 ,p_pei_information8 out nocopy varchar2
254 ,p_pei_information9 out nocopy varchar2
255 ,p_pei_information10 out nocopy varchar2
256 ,p_pei_information11 out nocopy varchar2
257 ,p_pei_information12 out nocopy varchar2
258 ,p_pei_information13 out nocopy varchar2
259 ,p_pei_information14 out nocopy varchar2
260 ,p_pei_information15 out nocopy varchar2
261 ,p_pei_information16 out nocopy varchar2
262 ,p_pei_information17 out nocopy varchar2
263 ,p_pei_information18 out nocopy varchar2
264 ,p_pei_information19 out nocopy varchar2
265 ,p_pei_information20 out nocopy varchar2
266 ,p_pei_information21 out nocopy varchar2
267 ,p_pei_information22 out nocopy varchar2
268 ,p_pei_information23 out nocopy varchar2
269 ,p_pei_information24 out nocopy varchar2
270 ,p_pei_information25 out nocopy varchar2
271 ,p_pei_information26 out nocopy varchar2
272 ,p_pei_information27 out nocopy varchar2
273 ,p_pei_information28 out nocopy varchar2
274 ,p_pei_information29 out nocopy varchar2
275 ,p_pei_information30 out nocopy varchar2
276 ,p_object_version_number out nocopy number
277 ,p_last_update_date out nocopy date
278 ,p_last_updated_by out nocopy number
279 ,p_last_update_login out nocopy number
280 ,p_created_by out nocopy number
281 ,p_creation_date out nocopy date
282 ,p_result_code out nocopy varchar2
283 );
284
285 Procedure fetch_asgei (
286 p_assignment_extra_info_id in out nocopy number
287 ,p_date_effective in out nocopy date
288 ,p_assignment_id out nocopy number
289 ,p_information_type out nocopy varchar2
290 ,p_request_id out nocopy number
291 ,p_program_application_id out nocopy number
292 ,p_program_id out nocopy number
293 ,p_program_update_date out nocopy date
294 ,p_aei_attribute_category out nocopy varchar2
295 ,p_aei_attribute1 out nocopy varchar2
296 ,p_aei_attribute2 out nocopy varchar2
297 ,p_aei_attribute3 out nocopy varchar2
298 ,p_aei_attribute4 out nocopy varchar2
299 ,p_aei_attribute5 out nocopy varchar2
300 ,p_aei_attribute6 out nocopy varchar2
301 ,p_aei_attribute7 out nocopy varchar2
302 ,p_aei_attribute8 out nocopy varchar2
303 ,p_aei_attribute9 out nocopy varchar2
304 ,p_aei_attribute10 out nocopy varchar2
305 ,p_aei_attribute11 out nocopy varchar2
306 ,p_aei_attribute12 out nocopy varchar2
307 ,p_aei_attribute13 out nocopy varchar2
308 ,p_aei_attribute14 out nocopy varchar2
309 ,p_aei_attribute15 out nocopy varchar2
310 ,p_aei_attribute16 out nocopy varchar2
311 ,p_aei_attribute17 out nocopy varchar2
312 ,p_aei_attribute18 out nocopy varchar2
313 ,p_aei_attribute19 out nocopy varchar2
314 ,p_aei_attribute20 out nocopy varchar2
315 ,p_aei_information_category out nocopy varchar2
316 ,p_aei_information1 out nocopy varchar2
317 ,p_aei_information2 out nocopy varchar2
318 ,p_aei_information3 out nocopy varchar2
319 ,p_aei_information4 out nocopy varchar2
320 ,p_aei_information5 out nocopy varchar2
321 ,p_aei_information6 out nocopy varchar2
322 ,p_aei_information7 out nocopy varchar2
323 ,p_aei_information8 out nocopy varchar2
324 ,p_aei_information9 out nocopy varchar2
325 ,p_aei_information10 out nocopy varchar2
326 ,p_aei_information11 out nocopy varchar2
327 ,p_aei_information12 out nocopy varchar2
328 ,p_aei_information13 out nocopy varchar2
329 ,p_aei_information14 out nocopy varchar2
330 ,p_aei_information15 out nocopy varchar2
331 ,p_aei_information16 out nocopy varchar2
332 ,p_aei_information17 out nocopy varchar2
333 ,p_aei_information18 out nocopy varchar2
334 ,p_aei_information19 out nocopy varchar2
335 ,p_aei_information20 out nocopy varchar2
336 ,p_aei_information21 out nocopy varchar2
337 ,p_aei_information22 out nocopy varchar2
338 ,p_aei_information23 out nocopy varchar2
339 ,p_aei_information24 out nocopy varchar2
340 ,p_aei_information25 out nocopy varchar2
341 ,p_aei_information26 out nocopy varchar2
342 ,p_aei_information27 out nocopy varchar2
343 ,p_aei_information28 out nocopy varchar2
344 ,p_aei_information29 out nocopy varchar2
345 ,p_aei_information30 out nocopy varchar2
346 ,p_object_version_number out nocopy number
347 ,p_last_update_date out nocopy date
348 ,p_last_updated_by out nocopy number
349 ,p_last_update_login out nocopy number
350 ,p_created_by out nocopy number
351 ,p_creation_date out nocopy date
352 ,p_result_code out nocopy varchar2
353 );
354
355 Procedure fetch_address (
356 p_address_id in number default null,
357 p_date_effective in date default null,
358 p_altered_pa_request_id in number default null,
359 p_noa_id_corrected in number default null,
360 p_rowid in rowid default null,
361 p_pa_history_id in number default null,
362 p_address_data out nocopy per_addresses%rowtype,
363 p_result_code out nocopy varchar2 );
364
365 -- ---------------------------------------------------------------------------
366 -- |--------------------------< return_special_information >----------------|
367 -- --------------------------------------------------------------------------
368
369 Procedure return_special_information(
370 p_person_id in number,
371 p_structure_name in varchar2,
372 p_effective_date in date,
373 p_special_info out nocopy ghr_api.special_information_type
374 );
375
376 Procedure Fetch_ASGEI_prior_root_sf50(
377 p_assignment_id in number ,
378 p_information_type in varchar2,
379 p_altered_pa_request_id in number ,
380 p_noa_id_corrected in number ,
381 p_date_effective in date default null,
382 p_get_ovn_flag in varchar2 default 'N' ,
383 p_asgei_data out nocopy per_assignment_extra_info%rowtype);
384
385
386 Procedure Fetch_asgn_prior_root_sf50(
387 p_assignment_id in number ,
388 p_altered_pa_request_id in number ,
389 p_noa_id_corrected in number ,
390 p_date_effective in date default null,
391 -- p_get_ovn_flag in varchar2 default 'N' ,
392 p_assignment_data out nocopy per_all_assignments_f%rowtype);
393
394 End GHR_HISTORY_FETCH;