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