[Home] [Help]
PACKAGE: APPS.GHR_HISTORY_CONV_RG
Source
1 Package GHR_HISTORY_CONV_RG AUTHID CURRENT_USER as
2 /* $Header: ghconvrg.pkh 115.6 2003/09/02 02:39:22 ajose ship $ */
3 --
4 --
5 -- ----------------------------------------------------------------------------
6 -- |--------------------------< <Ghr_History_API> >--------------------------|
7 -- ----------------------------------------------------------------------------
8 --
9
10 g_hist_date_format constant varchar2(30):='yyyy/mm/dd hh24:mi:ss';
11
12 Procedure copy_field_value(
13 p_source_field in varchar2,
14 p_target_field in out nocopy varchar2 );
15
16 Procedure copy_field_value(
17 p_source_field in date,
18 p_target_field in out nocopy date );
19
20 Procedure copy_field_value(
21 p_source_field in number,
22 p_target_field in out nocopy number );
23
24 Procedure conv_to_people_rg(
25 p_person_id in per_people_f.person_id%type default null,
26 p_effective_start_date in per_people_f.effective_start_date%type default null,
27 p_effective_end_date in per_people_f.effective_end_date%type default null,
28 p_business_group_id in per_people_f.business_group_id%type default null,
29 p_person_type_id in per_people_f.person_type_id%type default null,
30 p_last_name in per_people_f.last_name%type default null,
31 p_start_date in per_people_f.start_date%type default null,
32 p_applicant_number in per_people_f.applicant_number%type default null,
33 p_background_check_status in per_people_f.background_check_status%type default null,
34 p_background_date_check in per_people_f.background_date_check%type default null,
35 p_blood_type in per_people_f.blood_type%type default null,
36 p_comment_id in per_people_f.comment_id%type default null,
37 p_correspondence_language in per_people_f.correspondence_language%type default null,
38 p_current_applicant_flag in per_people_f.current_applicant_flag%type default null,
39 p_current_emp_or_apl_flag in per_people_f.current_emp_or_apl_flag%type default null,
40 p_current_employee_flag in per_people_f.current_employee_flag%type default null,
41 p_date_employee_data_verified in per_people_f.date_employee_data_verified%type default null,
42 p_date_of_birth in per_people_f.date_of_birth%type default null,
43 p_email_address in per_people_f.email_address%type default null,
44 p_employee_number in per_people_f.employee_number%type default null,
45 p_expense_check_send_to_add in per_people_f.expense_check_send_to_address%type default null,
46 p_fast_path_employee in per_people_f.fast_path_employee%type default null,
47 p_first_name in per_people_f.first_name%type default null,
48 p_fte_capacity in per_people_f.fte_capacity%type default null,
49 p_full_name in per_people_f.full_name%type default null,
50 p_hold_applicant_date_until in per_people_f.hold_applicant_date_until%type default null,
51 p_honors in per_people_f.honors%type default null,
52 p_internal_location in per_people_f.internal_location%type default null,
53 p_known_as in per_people_f.known_as%type default null,
54 p_last_medical_test_by in per_people_f.last_medical_test_by%type default null,
55 p_last_medical_test_date in per_people_f.last_medical_test_date%type default null,
56 p_mailstop in per_people_f.mailstop%type default null,
57 p_marital_status in per_people_f.marital_status%type default null,
58 p_middle_names in per_people_f.middle_names%type default null,
59 p_nationality in per_people_f.nationality%type default null,
60 p_national_identifier in per_people_f.national_identifier%type default null,
61 p_office_number in per_people_f.office_number%type default null,
62 p_on_military_service in per_people_f.on_military_service%type default null,
63 p_order_name in per_people_f.order_name%type default null,
64 p_pre_name_adjunct in per_people_f.pre_name_adjunct%type default null,
65 p_previous_last_name in per_people_f.previous_last_name%type default null,
66 p_projected_start_date in per_people_f.projected_start_date%type default null,
67 p_rehire_authorizor in per_people_f.rehire_authorizor%type default null,
68 p_rehire_recommendation in per_people_f.rehire_recommendation%type default null,
69 p_resume_exists in per_people_f.resume_exists%type default null,
70 p_resume_last_updated in per_people_f.resume_last_updated%type default null,
71 p_registered_disabled_flag in per_people_f.registered_disabled_flag%type default null,
72 p_second_passport_exists in per_people_f.second_passport_exists%type default null,
73 p_sex in per_people_f.sex%type default null,
74 p_student_status in per_people_f.student_status%type default null,
75 p_suffix in per_people_f.suffix%type default null,
76 p_title in per_people_f.title%type default null,
77 p_vendor_id in per_people_f.vendor_id%type default null,
78 p_work_schedule in per_people_f.work_schedule%type default null,
79 p_work_telephone in per_people_f.work_telephone%type default null,
80 p_request_id in per_people_f.request_id%type default null,
81 p_program_application_id in per_people_f.program_application_id%type default null,
82 p_program_id in per_people_f.program_id%type default null,
83 p_program_update_date in per_people_f.program_update_date%type default null,
84 p_attribute_category in per_people_f.attribute_category%type default null,
85 p_attribute1 in per_people_f.attribute1%type default null,
86 p_attribute2 in per_people_f.attribute2%type default null,
87 p_attribute3 in per_people_f.attribute3%type default null,
88 p_attribute4 in per_people_f.attribute4%type default null,
89 p_attribute5 in per_people_f.attribute5%type default null,
90 p_attribute6 in per_people_f.attribute6%type default null,
91 p_attribute7 in per_people_f.attribute7%type default null,
92 p_attribute8 in per_people_f.attribute8%type default null,
93 p_attribute9 in per_people_f.attribute9%type default null,
94 p_attribute10 in per_people_f.attribute10%type default null,
95 p_attribute11 in per_people_f.attribute11%type default null,
96 p_attribute12 in per_people_f.attribute12%type default null,
97 p_attribute13 in per_people_f.attribute13%type default null,
98 p_attribute14 in per_people_f.attribute14%type default null,
99 p_attribute15 in per_people_f.attribute15%type default null,
100 p_attribute16 in per_people_f.attribute16%type default null,
101 p_attribute17 in per_people_f.attribute17%type default null,
102 p_attribute18 in per_people_f.attribute18%type default null,
103 p_attribute19 in per_people_f.attribute19%type default null,
104 p_attribute20 in per_people_f.attribute20%type default null,
105 p_attribute21 in per_people_f.attribute21%type default null,
106 p_attribute22 in per_people_f.attribute22%type default null,
107 p_attribute23 in per_people_f.attribute23%type default null,
108 p_attribute24 in per_people_f.attribute24%type default null,
109 p_attribute25 in per_people_f.attribute25%type default null,
110 p_attribute26 in per_people_f.attribute26%type default null,
111 p_attribute27 in per_people_f.attribute27%type default null,
112 p_attribute28 in per_people_f.attribute28%type default null,
113 p_attribute29 in per_people_f.attribute29%type default null,
114 p_attribute30 in per_people_f.attribute30%type default null,
115 p_per_information_category in per_people_f.per_information_category%type default null,
116 p_per_information1 in per_people_f.per_information1%type default null,
117 p_per_information2 in per_people_f.per_information2%type default null,
118 p_per_information3 in per_people_f.per_information3%type default null,
119 p_per_information4 in per_people_f.per_information4%type default null,
120 p_per_information5 in per_people_f.per_information5%type default null,
121 p_per_information6 in per_people_f.per_information6%type default null,
122 p_per_information7 in per_people_f.per_information7%type default null,
123 p_per_information8 in per_people_f.per_information8%type default null,
124 p_per_information9 in per_people_f.per_information9%type default null,
125 p_per_information10 in per_people_f.per_information10%type default null,
126 p_per_information11 in per_people_f.per_information11%type default null,
127 p_per_information12 in per_people_f.per_information12%type default null,
128 p_per_information13 in per_people_f.per_information13%type default null,
129 p_per_information14 in per_people_f.per_information14%type default null,
130 p_per_information15 in per_people_f.per_information15%type default null,
131 p_per_information16 in per_people_f.per_information16%type default null,
132 p_per_information17 in per_people_f.per_information17%type default null,
133 p_per_information18 in per_people_f.per_information18%type default null,
134 p_per_information19 in per_people_f.per_information19%type default null,
135 p_per_information20 in per_people_f.per_information20%type default null,
136 p_per_information21 in per_people_f.per_information21%type default null,
137 p_per_information22 in per_people_f.per_information22%type default null,
138 p_per_information23 in per_people_f.per_information23%type default null,
139 p_per_information24 in per_people_f.per_information24%type default null,
140 p_per_information25 in per_people_f.per_information25%type default null,
141 p_per_information26 in per_people_f.per_information26%type default null,
142 p_per_information27 in per_people_f.per_information27%type default null,
143 p_per_information28 in per_people_f.per_information28%type default null,
144 p_per_information29 in per_people_f.per_information29%type default null,
145 p_per_information30 in per_people_f.per_information30%type default null,
146 -- p_object_version_number in per_people_f.object_version_number%type default null,
147 p_date_of_death in per_people_f.date_of_death%type default null,
148 p_rehire_reason in per_people_f.rehire_reason%type default null,
149 p_people_data in out nocopy per_all_people_f%rowtype );
150
151 Procedure conv_to_people_rg (
152 p_people_h_v in ghr_people_h_v%rowtype,
153 p_people_data out nocopy per_all_people_f%rowtype);
154
155 Procedure conv_people_rg_to_hist_rg(
156 p_people_data in per_all_people_f%rowtype,
157 p_history_data in out nocopy ghr_pa_history%rowtype);
158
159 Procedure conv_to_people_rg(
160 p_history_data in ghr_pa_history%rowtype,
161 p_people_data in out nocopy per_all_people_f%rowtype);
162
163 Procedure conv_to_asgnei_rg(
164 p_asgnei_h_v in ghr_assignment_extra_info_h_v%rowtype,
165 p_asgnei_data out nocopy per_assignment_extra_info%rowtype);
166
167 Procedure conv_to_asgnei_rg(
168 p_assignment_extra_info_id in per_assignment_extra_info.assignment_extra_info_id%type default null,
169 p_assignment_id in per_assignment_extra_info.assignment_id%type default null,
170 p_information_type in per_assignment_extra_info.information_type%type default null,
171 p_aei_information_category in per_assignment_extra_info.aei_information_category%type default null,
172 p_aei_information1 in per_assignment_extra_info.aei_information1%type default null,
173 p_aei_information2 in per_assignment_extra_info.aei_information2%type default null,
174 p_aei_information3 in per_assignment_extra_info.aei_information3%type default null,
175 p_aei_information4 in per_assignment_extra_info.aei_information4%type default null,
176 p_aei_information5 in per_assignment_extra_info.aei_information5%type default null,
177 p_aei_information6 in per_assignment_extra_info.aei_information6%type default null,
178 p_aei_information7 in per_assignment_extra_info.aei_information7%type default null,
179 p_aei_information8 in per_assignment_extra_info.aei_information8%type default null,
180 p_aei_information9 in per_assignment_extra_info.aei_information9%type default null,
181 p_aei_information10 in per_assignment_extra_info.aei_information10%type default null,
182 p_aei_information11 in per_assignment_extra_info.aei_information11%type default null,
183 p_aei_information12 in per_assignment_extra_info.aei_information12%type default null,
184 p_aei_information13 in per_assignment_extra_info.aei_information13%type default null,
185 p_aei_information14 in per_assignment_extra_info.aei_information14%type default null,
186 p_aei_information15 in per_assignment_extra_info.aei_information15%type default null,
187 p_aei_information16 in per_assignment_extra_info.aei_information16%type default null,
188 p_aei_information17 in per_assignment_extra_info.aei_information17%type default null,
189 p_aei_information18 in per_assignment_extra_info.aei_information18%type default null,
190 p_aei_information19 in per_assignment_extra_info.aei_information19%type default null,
191 p_aei_information20 in per_assignment_extra_info.aei_information20%type default null,
192 p_aei_information21 in per_assignment_extra_info.aei_information21%type default null,
193 p_aei_information22 in per_assignment_extra_info.aei_information22%type default null,
194 p_aei_information23 in per_assignment_extra_info.aei_information23%type default null,
195 p_aei_information24 in per_assignment_extra_info.aei_information24%type default null,
196 p_aei_information25 in per_assignment_extra_info.aei_information25%type default null,
197 p_aei_information26 in per_assignment_extra_info.aei_information26%type default null,
198 p_aei_information27 in per_assignment_extra_info.aei_information27%type default null,
199 p_aei_information28 in per_assignment_extra_info.aei_information28%type default null,
200 p_aei_information29 in per_assignment_extra_info.aei_information29%type default null,
201 p_aei_information30 in per_assignment_extra_info.aei_information30%type default null,
202 p_request_id in per_assignment_extra_info.request_id%type default null,
203 p_program_application_id in per_assignment_extra_info.program_application_id%type default null,
204 p_program_id in per_assignment_extra_info.program_id%type default null,
205 p_program_update_date in per_assignment_extra_info.program_update_date%type default null,
206 p_aei_attribute_category in per_assignment_extra_info.aei_attribute_category%type default null,
207 p_aei_attribute1 in per_assignment_extra_info.aei_attribute1%type default null,
208 p_aei_attribute2 in per_assignment_extra_info.aei_attribute2%type default null,
209 p_aei_attribute3 in per_assignment_extra_info.aei_attribute3%type default null,
210 p_aei_attribute4 in per_assignment_extra_info.aei_attribute4%type default null,
211 p_aei_attribute5 in per_assignment_extra_info.aei_attribute5%type default null,
212 p_aei_attribute6 in per_assignment_extra_info.aei_attribute6%type default null,
213 p_aei_attribute7 in per_assignment_extra_info.aei_attribute7%type default null,
214 p_aei_attribute8 in per_assignment_extra_info.aei_attribute8%type default null,
215 p_aei_attribute9 in per_assignment_extra_info.aei_attribute9%type default null,
216 p_aei_attribute10 in per_assignment_extra_info.aei_attribute10%type default null,
217 p_aei_attribute11 in per_assignment_extra_info.aei_attribute11%type default null,
218 p_aei_attribute12 in per_assignment_extra_info.aei_attribute12%type default null,
219 p_aei_attribute13 in per_assignment_extra_info.aei_attribute13%type default null,
220 p_aei_attribute14 in per_assignment_extra_info.aei_attribute14%type default null,
221 p_aei_attribute15 in per_assignment_extra_info.aei_attribute15%type default null,
222 p_aei_attribute16 in per_assignment_extra_info.aei_attribute16%type default null,
223 p_aei_attribute17 in per_assignment_extra_info.aei_attribute17%type default null,
224 p_aei_attribute18 in per_assignment_extra_info.aei_attribute18%type default null,
225 p_aei_attribute19 in per_assignment_extra_info.aei_attribute19%type default null,
226 p_aei_attribute20 in per_assignment_extra_info.aei_attribute20 %type default null,
227 -- p_object_version_number in per_assignment_extra_info.object_version_number%type default null,
228 p_asgnei_data in out nocopy per_assignment_extra_info%rowtype);
229
230 Procedure conv_asgnei_rg_to_hist_rg(
231 p_asgnei_data in per_assignment_extra_info%rowtype,
232 p_history_data in out nocopy ghr_pa_history%rowtype);
233
234 Procedure conv_to_asgnei_rg(
235 p_history_data in ghr_pa_history%rowtype,
236 p_asgnei_data in out nocopy per_assignment_extra_info%rowtype);
237
238 Procedure conv_to_asgn_rg(
239 p_assignment_id in per_assignments_f.assignment_id%type default null,
240 p_effective_start_date in per_assignments_f.effective_start_date%type default null,
241 p_effective_end_date in per_assignments_f.effective_end_date%type default null,
242 p_business_group_id in per_assignments_f.business_group_id%type default null,
243 p_recruiter_id in per_assignments_f.recruiter_id%type default null,
244 p_grade_id in per_assignments_f.grade_id%type default null,
245 p_position_id in per_assignments_f.position_id%type default null,
246 p_job_id in per_assignments_f.job_id%type default null,
247 p_assignment_status_type_id in per_assignments_f.assignment_status_type_id%type default null,
248 p_payroll_id in per_assignments_f.payroll_id%type default null,
249 p_location_id in per_assignments_f.location_id%type default null,
250 p_person_referred_by_id in per_assignments_f.person_referred_by_id%type default null,
251 p_supervisor_id in per_assignments_f.supervisor_id%type default null,
252 p_special_ceiling_step_id in per_assignments_f.special_ceiling_step_id%type default null,
253 p_person_id in per_assignments_f.person_id%type default null,
254 p_recruitment_activity_id in per_assignments_f.recruitment_activity_id%type default null,
255 p_source_organization_id in per_assignments_f.source_organization_id%type default null,
256 p_organization_id in per_assignments_f.organization_id%type default null,
257 p_people_group_id in per_assignments_f.people_group_id%type default null,
258 p_soft_coding_keyflex_id in per_assignments_f.soft_coding_keyflex_id%type default null,
259 p_vacancy_id in per_assignments_f.vacancy_id%type default null,
260 p_pay_basis_id in per_assignments_f.pay_basis_id%type default null,
261 p_assignment_sequence in per_assignments_f.assignment_sequence%type default null,
262 p_assignment_type in per_assignments_f.assignment_type%type default null,
263 p_primary_flag in per_assignments_f.primary_flag%type default null,
264 p_application_id in per_assignments_f.application_id%type default null,
265 p_assignment_number in per_assignments_f.assignment_number%type default null,
266 p_change_reason in per_assignments_f.change_reason%type default null,
267 p_comment_id in per_assignments_f.comment_id%type default null,
268 p_date_probation_end in per_assignments_f.date_probation_end%type default null,
269 p_default_code_comb_id in per_assignments_f.default_code_comb_id%type default null,
270 p_employment_category in per_assignments_f.employment_category%type default null,
271 p_frequency in per_assignments_f.frequency%type default null,
272 p_internal_address_line in per_assignments_f.internal_address_line%type default null,
273 p_manager_flag in per_assignments_f.manager_flag%type default null,
274 p_normal_hours in per_assignments_f.normal_hours%type default null,
275 p_perf_review_period in per_assignments_f.perf_review_period%type default null,
276 p_perf_review_period_frequency in per_assignments_f.perf_review_period_frequency%type default null,
277 p_period_of_service_id in per_assignments_f.period_of_service_id%type default null,
278 p_probation_period in per_assignments_f.probation_period%type default null,
279 p_probation_unit in per_assignments_f.probation_unit%type default null,
280 p_sal_review_period in per_assignments_f.sal_review_period%type default null,
281 p_sal_review_period_frequency in per_assignments_f.sal_review_period_frequency%type default null,
282 p_set_of_books_id in per_assignments_f.set_of_books_id%type default null,
283 p_source_type in per_assignments_f.source_type%type default null,
284 p_time_normal_finish in per_assignments_f.time_normal_finish%type default null,
285 p_time_normal_start in per_assignments_f.time_normal_start%type default null,
286 p_request_id in per_assignments_f.request_id%type default null,
287 p_program_application_id in per_assignments_f.program_application_id%type default null,
288 p_program_id in per_assignments_f.program_id%type default null,
289 p_program_update_date in per_assignments_f.program_update_date%type default null,
290 p_ass_attribute_category in per_assignments_f.ass_attribute_category%type default null,
291 p_ass_attribute1 in per_assignments_f.ass_attribute1%type default null,
292 p_ass_attribute2 in per_assignments_f.ass_attribute2%type default null,
293 p_ass_attribute3 in per_assignments_f.ass_attribute3%type default null,
294 p_ass_attribute4 in per_assignments_f.ass_attribute4%type default null,
295 p_ass_attribute5 in per_assignments_f.ass_attribute5%type default null,
296 p_ass_attribute6 in per_assignments_f.ass_attribute6%type default null,
297 p_ass_attribute7 in per_assignments_f.ass_attribute7%type default null,
298 p_ass_attribute8 in per_assignments_f.ass_attribute8%type default null,
299 p_ass_attribute9 in per_assignments_f.ass_attribute9%type default null,
300 p_ass_attribute10 in per_assignments_f.ass_attribute10%type default null,
301 p_ass_attribute11 in per_assignments_f.ass_attribute11%type default null,
302 p_ass_attribute12 in per_assignments_f.ass_attribute12%type default null,
303 p_ass_attribute13 in per_assignments_f.ass_attribute13%type default null,
304 p_ass_attribute14 in per_assignments_f.ass_attribute14%type default null,
305 p_ass_attribute15 in per_assignments_f.ass_attribute15%type default null,
306 p_ass_attribute16 in per_assignments_f.ass_attribute16%type default null,
307 p_ass_attribute17 in per_assignments_f.ass_attribute17%type default null,
308 p_ass_attribute18 in per_assignments_f.ass_attribute18%type default null,
309 p_ass_attribute19 in per_assignments_f.ass_attribute19%type default null,
310 p_ass_attribute20 in per_assignments_f.ass_attribute20%type default null,
311 p_ass_attribute21 in per_assignments_f.ass_attribute21%type default null,
312 p_ass_attribute22 in per_assignments_f.ass_attribute22%type default null,
313 p_ass_attribute23 in per_assignments_f.ass_attribute23%type default null,
314 p_ass_attribute24 in per_assignments_f.ass_attribute24%type default null,
315 p_ass_attribute25 in per_assignments_f.ass_attribute25%type default null,
316 p_ass_attribute26 in per_assignments_f.ass_attribute26%type default null,
317 p_ass_attribute27 in per_assignments_f.ass_attribute27%type default null,
318 p_ass_attribute28 in per_assignments_f.ass_attribute28%type default null,
319 p_ass_attribute29 in per_assignments_f.ass_attribute29%type default null,
320 p_ass_attribute30 in per_assignments_f.ass_attribute30%type default null,
321 p_title in per_assignments_f.title%type default null,
322 -- p_object_version_number in per_assignments_f.object_version_number%type default null,
323 p_asgn_data in out nocopy per_all_assignments_f%rowtype);
324
325 Procedure conv_to_asgn_rg (
326 p_asgn_h_v in ghr_assignments_h_v%rowtype,
327 p_asgn_data out nocopy per_all_assignments_f%rowtype);
328
329 procedure conv_asgn_rg_to_hist_rg(
330 p_assignment_data in per_all_assignments_f%rowtype,
331 p_history_data in out nocopy ghr_pa_history%rowtype);
332
333 procedure conv_to_asgn_rg(
334 p_history_data in ghr_pa_history%rowtype,
335 p_assignment_data in out nocopy per_all_assignments_f%rowtype);
336
337 Procedure conv_to_peopleei_rg (
338 p_peopleei_h_v in ghr_people_extra_info_h_v%rowtype,
339 p_peopleei_data out nocopy per_people_extra_info%rowtype);
340
341 Procedure conv_to_peopleei_rg(
342 p_history_data in ghr_pa_history%rowtype,
343 p_people_ei_data in out nocopy per_people_extra_info%rowtype );
344
345 Procedure conv_to_peopleei_rg (
346 p_person_extra_info_id in per_people_extra_info.person_extra_info_id%type default null,
347 p_person_id in per_people_extra_info.person_id%type default null,
348 p_information_type in per_people_extra_info.information_type%type default null,
349 p_request_id in per_people_extra_info.request_id%type default null,
350 p_program_application_id in per_people_extra_info.program_application_id%type default null,
351 p_program_id in per_people_extra_info.program_id%type default null,
352 p_program_update_date in per_people_extra_info.program_update_date%type default null,
353 p_pei_attribute_category in per_people_extra_info.pei_attribute_category%type default null,
354 p_pei_attribute1 in per_people_extra_info.pei_attribute1%type default null,
355 p_pei_attribute2 in per_people_extra_info.pei_attribute2%type default null,
356 p_pei_attribute3 in per_people_extra_info.pei_attribute3%type default null,
357 p_pei_attribute4 in per_people_extra_info.pei_attribute4%type default null,
358 p_pei_attribute5 in per_people_extra_info.pei_attribute5%type default null,
359 p_pei_attribute6 in per_people_extra_info.pei_attribute6%type default null,
360 p_pei_attribute7 in per_people_extra_info.pei_attribute7%type default null,
361 p_pei_attribute8 in per_people_extra_info.pei_attribute8%type default null,
362 p_pei_attribute9 in per_people_extra_info.pei_attribute9%type default null,
363 p_pei_attribute10 in per_people_extra_info.pei_attribute10%type default null,
364 p_pei_attribute11 in per_people_extra_info.pei_attribute11%type default null,
365 p_pei_attribute12 in per_people_extra_info.pei_attribute12%type default null,
366 p_pei_attribute13 in per_people_extra_info.pei_attribute13%type default null,
367 p_pei_attribute14 in per_people_extra_info.pei_attribute14%type default null,
368 p_pei_attribute15 in per_people_extra_info.pei_attribute15%type default null,
369 p_pei_attribute16 in per_people_extra_info.pei_attribute16%type default null,
370 p_pei_attribute17 in per_people_extra_info.pei_attribute17%type default null,
371 p_pei_attribute18 in per_people_extra_info.pei_attribute18%type default null,
372 p_pei_attribute19 in per_people_extra_info.pei_attribute19%type default null,
373 p_pei_attribute20 in per_people_extra_info.pei_attribute20%type default null,
374 p_pei_information_category in per_people_extra_info.pei_information_category%type default null,
375 p_pei_information1 in per_people_extra_info.pei_information1%type default null,
376 p_pei_information2 in per_people_extra_info.pei_information2%type default null,
377 p_pei_information3 in per_people_extra_info.pei_information3%type default null,
378 p_pei_information4 in per_people_extra_info.pei_information4%type default null,
379 p_pei_information5 in per_people_extra_info.pei_information5%type default null,
380 p_pei_information6 in per_people_extra_info.pei_information6%type default null,
381 p_pei_information7 in per_people_extra_info.pei_information7%type default null,
382 p_pei_information8 in per_people_extra_info.pei_information8%type default null,
383 p_pei_information9 in per_people_extra_info.pei_information9%type default null,
384 p_pei_information10 in per_people_extra_info.pei_information10%type default null,
385 p_pei_information11 in per_people_extra_info.pei_information11%type default null,
386 p_pei_information12 in per_people_extra_info.pei_information12%type default null,
387 p_pei_information13 in per_people_extra_info.pei_information13%type default null,
388 p_pei_information14 in per_people_extra_info.pei_information14%type default null,
389 p_pei_information15 in per_people_extra_info.pei_information15%type default null,
390 p_pei_information16 in per_people_extra_info.pei_information16%type default null,
391 p_pei_information17 in per_people_extra_info.pei_information17%type default null,
392 p_pei_information18 in per_people_extra_info.pei_information18%type default null,
393 p_pei_information19 in per_people_extra_info.pei_information19%type default null,
394 p_pei_information20 in per_people_extra_info.pei_information20%type default null,
395 p_pei_information21 in per_people_extra_info.pei_information21%type default null,
396 p_pei_information22 in per_people_extra_info.pei_information22%type default null,
397 p_pei_information23 in per_people_extra_info.pei_information23%type default null,
398 p_pei_information24 in per_people_extra_info.pei_information24%type default null,
399 p_pei_information25 in per_people_extra_info.pei_information25%type default null,
400 p_pei_information26 in per_people_extra_info.pei_information26%type default null,
401 p_pei_information27 in per_people_extra_info.pei_information27%type default null,
402 p_pei_information28 in per_people_extra_info.pei_information28%type default null,
403 p_pei_information29 in per_people_extra_info.pei_information29%type default null,
404 p_pei_information30 in per_people_extra_info.pei_information30%type default null,
405 -- p_object_version_number in per_people_extra_info.object_version_number%type default null,
406 p_peopleei_data in out nocopy per_people_extra_info%rowtype);
407
408 Procedure conv_peopleei_rg_to_hist_rg(
409 p_people_ei_data in per_people_extra_info%rowtype,
410 p_history_data in out nocopy ghr_pa_history%rowtype);
411
412
413 Procedure conv_to_positionei_rg(
414 p_position_extra_info_id in per_position_extra_info.position_extra_info_id%type default null,
415 p_position_id in per_position_extra_info.position_id%type default null,
416 p_information_type in per_position_extra_info.information_type%type default null,
417 p_request_id in per_position_extra_info.request_id%type default null,
418 p_program_application_id in per_position_extra_info.program_application_id%type default null,
419 p_program_id in per_position_extra_info.program_id%type default null,
420 p_program_update_date in per_position_extra_info.program_update_date%type default null,
421 p_poei_attribute_category in per_position_extra_info.poei_attribute_category%type default null,
422 p_poei_attribute1 in per_position_extra_info.poei_attribute1%type default null,
423 p_poei_attribute2 in per_position_extra_info.poei_attribute2%type default null,
424 p_poei_attribute3 in per_position_extra_info.poei_attribute3%type default null,
425 p_poei_attribute4 in per_position_extra_info.poei_attribute4%type default null,
426 p_poei_attribute5 in per_position_extra_info.poei_attribute5%type default null,
427 p_poei_attribute6 in per_position_extra_info.poei_attribute6%type default null,
428 p_poei_attribute7 in per_position_extra_info.poei_attribute7%type default null,
429 p_poei_attribute8 in per_position_extra_info.poei_attribute8%type default null,
430 p_poei_attribute9 in per_position_extra_info.poei_attribute9%type default null,
431 p_poei_attribute10 in per_position_extra_info.poei_attribute10%type default null,
432 p_poei_attribute11 in per_position_extra_info.poei_attribute11%type default null,
433 p_poei_attribute12 in per_position_extra_info.poei_attribute12%type default null,
434 p_poei_attribute13 in per_position_extra_info.poei_attribute13%type default null,
435 p_poei_attribute14 in per_position_extra_info.poei_attribute14%type default null,
436 p_poei_attribute15 in per_position_extra_info.poei_attribute15%type default null,
437 p_poei_attribute16 in per_position_extra_info.poei_attribute16%type default null,
438 p_poei_attribute17 in per_position_extra_info.poei_attribute17%type default null,
439 p_poei_attribute18 in per_position_extra_info.poei_attribute18%type default null,
440 p_poei_attribute19 in per_position_extra_info.poei_attribute19%type default null,
441 p_poei_attribute20 in per_position_extra_info.poei_attribute20%type default null,
442 p_poei_information_category in per_position_extra_info.poei_information_category%type default null,
443 p_poei_information1 in per_position_extra_info.poei_information1%type default null,
444 p_poei_information2 in per_position_extra_info.poei_information2%type default null,
445 p_poei_information3 in per_position_extra_info.poei_information3%type default null,
446 p_poei_information4 in per_position_extra_info.poei_information4%type default null,
447 p_poei_information5 in per_position_extra_info.poei_information5%type default null,
448 p_poei_information6 in per_position_extra_info.poei_information6%type default null,
449 p_poei_information7 in per_position_extra_info.poei_information7%type default null,
450 p_poei_information8 in per_position_extra_info.poei_information8%type default null,
451 p_poei_information9 in per_position_extra_info.poei_information9%type default null,
452 p_poei_information10 in per_position_extra_info.poei_information10%type default null,
453 p_poei_information11 in per_position_extra_info.poei_information11%type default null,
454 p_poei_information12 in per_position_extra_info.poei_information12%type default null,
455 p_poei_information13 in per_position_extra_info.poei_information13%type default null,
456 p_poei_information14 in per_position_extra_info.poei_information14%type default null,
457 p_poei_information15 in per_position_extra_info.poei_information15%type default null,
458 p_poei_information16 in per_position_extra_info.poei_information16%type default null,
459 p_poei_information17 in per_position_extra_info.poei_information17%type default null,
460 p_poei_information18 in per_position_extra_info.poei_information18%type default null,
461 p_poei_information19 in per_position_extra_info.poei_information19%type default null,
462 p_poei_information20 in per_position_extra_info.poei_information20%type default null,
463 p_poei_information21 in per_position_extra_info.poei_information21%type default null,
464 p_poei_information22 in per_position_extra_info.poei_information22%type default null,
465 p_poei_information23 in per_position_extra_info.poei_information23%type default null,
466 p_poei_information24 in per_position_extra_info.poei_information24%type default null,
467 p_poei_information25 in per_position_extra_info.poei_information25%type default null,
468 p_poei_information26 in per_position_extra_info.poei_information26%type default null,
469 p_poei_information27 in per_position_extra_info.poei_information27%type default null,
470 p_poei_information28 in per_position_extra_info.poei_information28%type default null,
471 p_poei_information29 in per_position_extra_info.poei_information29%type default null,
472 p_poei_information30 in per_position_extra_info.poei_information30%type default null,
473 -- p_object_version_number in per_position_extra_info.object_version_number%type default null,
474 p_position_extra_info_data in out nocopy per_position_extra_info%rowtype );
475
476 Procedure conv_to_positionei_rg (
477 p_positionei_h_v in ghr_position_extra_info_h_v%rowtype,
478 p_positionei_data out nocopy per_position_extra_info%rowtype);
479
480 Procedure conv_positionei_rg_to_hist_rg(
481 p_position_ei_data in per_position_extra_info%rowtype,
482 p_history_data in out nocopy ghr_pa_history%rowtype);
483
484 Procedure conv_to_positionei_rg(
485 p_history_data in ghr_pa_history%rowtype,
486 p_position_ei_data in out nocopy per_position_extra_info%rowtype);
487
488 Procedure conv_to_element_entry_rg(
489 p_element_entry_id in pay_element_entries_f.element_entry_id%type default null,
490 p_effective_start_date in pay_element_entries_f.effective_start_date%type default null,
491 p_effective_end_date in pay_element_entries_f.effective_end_date%type default null,
492 p_cost_allocation_keyflex_id in pay_element_entries_f.cost_allocation_keyflex_id%type default null,
493 p_assignment_id in pay_element_entries_f.assignment_id%type default null,
494 p_updating_action_id in pay_element_entries_f.updating_action_id%type default null,
495 p_element_link_id in pay_element_entries_f.element_link_id%type default null,
496 p_original_entry_id in pay_element_entries_f.original_entry_id%type default null,
497 p_creator_type in pay_element_entries_f.creator_type%type default null,
498 p_entry_type in pay_element_entries_f.entry_type%type default null,
499 p_comment_id in pay_element_entries_f.comment_id%type default null,
500 p_creator_id in pay_element_entries_f.creator_id%type default null,
501 p_reason in pay_element_entries_f.reason%type default null,
502 p_target_entry_id in pay_element_entries_f.target_entry_id%type default null,
503 p_attribute_category in pay_element_entries_f.attribute_category%type default null,
504 p_attribute1 in pay_element_entries_f.attribute1%type default null,
505 p_attribute2 in pay_element_entries_f.attribute2%type default null,
506 p_attribute3 in pay_element_entries_f.attribute3%type default null,
507 p_attribute4 in pay_element_entries_f.attribute4%type default null,
508 p_attribute5 in pay_element_entries_f.attribute5%type default null,
509 p_attribute6 in pay_element_entries_f.attribute6%type default null,
510 p_attribute7 in pay_element_entries_f.attribute7%type default null,
511 p_attribute8 in pay_element_entries_f.attribute8%type default null,
512 p_attribute9 in pay_element_entries_f.attribute9%type default null,
513 p_attribute10 in pay_element_entries_f.attribute10%type default null,
514 p_attribute11 in pay_element_entries_f.attribute11%type default null,
515 p_attribute12 in pay_element_entries_f.attribute12%type default null,
516 p_attribute13 in pay_element_entries_f.attribute13%type default null,
517 p_attribute14 in pay_element_entries_f.attribute14%type default null,
518 p_attribute15 in pay_element_entries_f.attribute15%type default null,
519 p_attribute16 in pay_element_entries_f.attribute16%type default null,
520 p_attribute17 in pay_element_entries_f.attribute17%type default null,
521 p_attribute18 in pay_element_entries_f.attribute18%type default null,
522 p_attribute19 in pay_element_entries_f.attribute19%type default null,
523 p_attribute20 in pay_element_entries_f.attribute20%type default null,
524 p_subpriority in pay_element_entries_f.subpriority%type default null,
525 p_personal_payment_method_id in pay_element_entries_f.personal_payment_method_id%type default null,
526 p_date_earned in pay_element_entries_f.date_earned%type default null,
527 p_element_entry_data in out nocopy pay_element_entries_f%rowtype);
528
529 Procedure conv_to_element_entry_rg(
530 p_element_entry_h_v in ghr_element_entries_h_v%rowtype,
531 p_element_entry_data out nocopy pay_element_entries_f%rowtype);
532
533 procedure conv_element_entry_rg_to_hist(
534 p_element_entries_data in pay_element_entries_f%rowtype,
535 p_history_data in out nocopy ghr_pa_history%rowtype);
536
537 procedure conv_to_element_entry_rg(
538 p_history_data in ghr_pa_history%rowtype,
539 p_element_entries_data in out nocopy pay_element_entries_f%rowtype);
540
541
542 Procedure conv_to_element_entval_rg(
543 p_element_entry_value_id in pay_element_entry_values_f.element_entry_value_id%type,
544 p_effective_start_date in pay_element_entry_values_f.effective_start_date%type,
545 p_effective_end_date in pay_element_entry_values_f.effective_end_date%type,
546 p_input_value_id in pay_element_entry_values_f.input_value_id%type,
547 p_element_entry_id in pay_element_entry_values_f.element_entry_id%type,
548 p_screen_entry_value in pay_element_entry_values_f.screen_entry_value%type,
549 p_elmeval_data in out nocopy pay_element_entry_values_f%rowtype);
550
551 Procedure conv_to_element_entval_rg(
552 p_element_entval_h_v in ghr_element_entry_values_h_v%rowtype,
553 p_element_entval_data out nocopy pay_element_entry_values_f%rowtype);
554
555 procedure conv_element_entval_rg_to_hist(
556 p_element_entval_data in pay_element_entry_values_f%rowtype,
557 p_history_data in out nocopy ghr_pa_history%rowtype);
558
559 procedure conv_to_element_entval_rg(
560 p_history_data in ghr_pa_history%rowtype,
561 p_element_entval_data in out nocopy pay_element_entry_values_f%rowtype);
562
563 Procedure conv_to_addresses_rg(
564 p_address_id in per_addresses.address_id%type default null,
565 p_business_group_id in per_addresses.business_group_id%type default null,
566 p_person_id in per_addresses.person_id%type default null,
567 p_date_from in per_addresses.date_from%type default null,
568 p_primary_flag in per_addresses.primary_flag%type default null,
569 p_style in per_addresses.style%type default null,
570 p_address_line1 in per_addresses.address_line1%type default null,
571 p_address_line2 in per_addresses.address_line2%type default null,
572 p_address_line3 in per_addresses.address_line3%type default null,
573 p_address_type in per_addresses.address_type%type default null,
574 -- p_comments in per_addresses.comments%type default null,
575 p_country in per_addresses.country%type default null,
576 p_date_to in per_addresses.date_to%type default null,
577 p_postal_code in per_addresses.postal_code%type default null,
578 p_region_1 in per_addresses.region_1%type default null,
579 p_region_2 in per_addresses.region_2%type default null,
580 p_region_3 in per_addresses.region_3%type default null,
581 p_telephone_number_1 in per_addresses.telephone_number_1%type default null,
582 p_telephone_number_2 in per_addresses.telephone_number_2%type default null,
583 p_telephone_number_3 in per_addresses.telephone_number_3%type default null,
584 p_town_or_city in per_addresses.town_or_city%type default null,
585 p_request_id in per_addresses.request_id%type default null,
586 p_program_application_id in per_addresses.program_application_id%type default null,
587 p_program_id in per_addresses.program_id%type default null,
588 p_program_update_date in per_addresses.program_update_date%type default null,
589 p_addr_attribute_category in per_addresses.addr_attribute_category%type default null,
590 p_addr_attribute1 in per_addresses.addr_attribute1%type default null,
591 p_addr_attribute2 in per_addresses.addr_attribute2%type default null,
592 p_addr_attribute3 in per_addresses.addr_attribute3%type default null,
593 p_addr_attribute4 in per_addresses.addr_attribute4%type default null,
594 p_addr_attribute5 in per_addresses.addr_attribute5%type default null,
595 p_addr_attribute6 in per_addresses.addr_attribute6%type default null,
596 p_addr_attribute7 in per_addresses.addr_attribute7%type default null,
597 p_addr_attribute8 in per_addresses.addr_attribute8%type default null,
598 p_addr_attribute9 in per_addresses.addr_attribute9%type default null,
599 p_addr_attribute10 in per_addresses.addr_attribute10%type default null,
600 p_addr_attribute11 in per_addresses.addr_attribute11%type default null,
601 p_addr_attribute12 in per_addresses.addr_attribute12%type default null,
602 p_addr_attribute13 in per_addresses.addr_attribute13%type default null,
603 p_addr_attribute14 in per_addresses.addr_attribute14%type default null,
604 p_addr_attribute15 in per_addresses.addr_attribute15%type default null,
605 p_addr_attribute16 in per_addresses.addr_attribute16%type default null,
606 p_addr_attribute17 in per_addresses.addr_attribute17%type default null,
607 p_addr_attribute18 in per_addresses.addr_attribute18%type default null,
608 p_addr_attribute19 in per_addresses.addr_attribute19%type default null,
609 p_addr_attribute20 in per_addresses.addr_attribute20%type default null,
610 -- p_object_version_number in per_addresses.object_version_number%type default null,
611 p_addresses_data in out nocopy per_addresses%rowtype);
612
613 Procedure conv_to_addresses_rg(
614 p_addresses_h_v in ghr_addresses_h_v%rowtype,
615 p_addresses_data out nocopy per_addresses%rowtype);
616
617 Procedure conv_addresses_rg_to_hist_rg(
618 p_addresses_data in per_addresses%rowtype,
619 p_history_data in out nocopy ghr_pa_history%rowtype);
620
621 Procedure conv_to_addresses_rg(
622 p_history_data in ghr_pa_history%rowtype,
623 p_addresses_data in out nocopy per_addresses%rowtype);
624
625
626 Procedure conv_peranalyses_rg_to_hist_rg(
627 p_peranalyses_data in per_person_analyses%rowtype,
628 p_history_data in out nocopy ghr_pa_history%rowtype);
629
630 Procedure conv_to_peranalyses_rg(
631 p_history_data in ghr_pa_history%rowtype,
632 p_peranalyses_data in out nocopy per_person_analyses%rowtype);
633
634 Procedure conv_to_peranalyses_rg(p_peranalyses_h_v in ghr_person_analyses_h_v%rowtype,
635 p_peranalyses_data out nocopy per_person_analyses%rowtype);
636
637 Procedure conv_to_peranalyses_rg(
638 p_person_analysis_id in per_person_analyses.person_analysis_id%type default null,
639 p_business_group_id in per_person_analyses.business_group_id%type default null,
640 p_analysis_criteria_id in per_person_analyses.analysis_criteria_id%type default null,
641 p_person_id in per_person_analyses.person_id%type default null,
642 p_comments in per_person_analyses.comments%type default null,
643 p_date_from in per_person_analyses.date_from%type default null,
644 p_date_to in per_person_analyses.date_to%type default null,
645 p_id_flex_num in per_person_analyses.id_flex_num%type default null,
646 p_request_id in per_person_analyses.request_id%type default null,
647 p_program_application_id in per_person_analyses.program_application_id%type default null,
648 p_program_id in per_person_analyses.program_id%type default null,
649 p_program_update_date in per_person_analyses.program_update_date%type default null,
650 p_attribute_category in per_person_analyses.attribute_category%type default null,
651 p_attribute1 in per_person_analyses.attribute1%type default null,
652 p_attribute2 in per_person_analyses.attribute2%type default null,
653 p_attribute3 in per_person_analyses.attribute3%type default null,
654 p_attribute4 in per_person_analyses.attribute4%type default null,
655 p_attribute5 in per_person_analyses.attribute5%type default null,
656 p_attribute6 in per_person_analyses.attribute6%type default null,
657 p_attribute7 in per_person_analyses.attribute7%type default null,
658 p_attribute8 in per_person_analyses.attribute8%type default null,
659 p_attribute9 in per_person_analyses.attribute9%type default null,
660 p_attribute10 in per_person_analyses.attribute10%type default null,
661 p_attribute11 in per_person_analyses.attribute11%type default null,
662 p_attribute12 in per_person_analyses.attribute12%type default null,
663 p_attribute13 in per_person_analyses.attribute13%type default null,
664 p_attribute14 in per_person_analyses.attribute14%type default null,
665 p_attribute15 in per_person_analyses.attribute15%type default null,
666 p_attribute16 in per_person_analyses.attribute16%type default null,
667 p_attribute17 in per_person_analyses.attribute17%type default null,
668 p_attribute18 in per_person_analyses.attribute18%type default null,
669 p_attribute19 in per_person_analyses.attribute19%type default null,
670 p_attribute20 in per_person_analyses.attribute20%type default null,
671 p_peranalyses_data in out nocopy per_person_analyses%rowtype );
672
673 Procedure convert_shadow_to_sf52 (
674 p_shadow in ghr_pa_request_shadow%rowtype,
675 p_sf52 out nocopy ghr_pa_requests%rowtype);
676
677 Procedure convert_sf52_to_shadow (
678 p_sf52 in ghr_pa_requests%rowtype,
679 p_shadow out nocopy ghr_pa_request_shadow%rowtype);
680
681 /* Changed for new date tracked positions table
682
683 Procedure conv_to_position_rg(
684 p_position_id in per_positions.position_id%type default null,
685 p_business_group_id in per_positions.business_group_id%type default null,
686 p_job_id in per_positions.job_id%type default null,
687 p_organization_id in per_positions.organization_id%type default null,
688 p_successor_position_id in per_positions.successor_position_id%type default null,
689 p_relief_position_id in per_positions.relief_position_id%type default null,
690 p_location_id in per_positions.location_id%type default null,
691 p_position_definition_id in per_positions.position_definition_id%type default null,
692 p_date_effective in per_positions.date_effective%type default null,
693 p_date_end in per_positions.date_end%type default null,
694 p_frequency in per_positions.frequency%type default null,
695 p_name in per_positions.name%type default null,
696 p_probation_period in per_positions.probation_period%type default null,
697 p_probation_period_units in per_positions.probation_period_units%type default null,
698 p_replacement_required_flag in per_positions.replacement_required_flag%type default null,
699 p_time_normal_finish in per_positions.time_normal_finish%type default null,
700 p_time_normal_start in per_positions.time_normal_start%type default null,
701 p_working_hours in per_positions.working_hours%type default null,
702 p_request_id in per_positions.request_id%type default null,
703 p_program_application_id in per_positions.program_application_id%type default null,
704 p_program_id in per_positions.program_id%type default null,
705 p_program_update_date in per_positions.program_update_date%type default null,
706 p_attribute_category in per_positions.attribute_category%type default null,
707 p_attribute1 in per_positions.attribute1%type default null,
708 p_attribute2 in per_positions.attribute2%type default null,
709 p_attribute3 in per_positions.attribute3%type default null,
710 p_attribute4 in per_positions.attribute4%type default null,
711 p_attribute5 in per_positions.attribute5%type default null,
712 p_attribute6 in per_positions.attribute6%type default null,
713 p_attribute7 in per_positions.attribute7%type default null,
714 p_attribute8 in per_positions.attribute8%type default null,
715 p_attribute9 in per_positions.attribute9%type default null,
716 p_attribute10 in per_positions.attribute10%type default null,
717 p_attribute11 in per_positions.attribute11%type default null,
718 p_attribute12 in per_positions.attribute12%type default null,
719 p_attribute13 in per_positions.attribute13%type default null,
720 p_attribute14 in per_positions.attribute14%type default null,
721 p_attribute15 in per_positions.attribute15%type default null,
722 p_attribute16 in per_positions.attribute16%type default null,
723 p_attribute17 in per_positions.attribute17%type default null,
724 p_attribute18 in per_positions.attribute18%type default null,
725 p_attribute19 in per_positions.attribute19%type default null,
726 p_attribute20 in per_positions.attribute20%type default null,
727 p_status in per_positions.status%type default null,
728 p_position_data in out nocopy per_positions%rowtype );
729
730 Procedure conv_to_position_rg (
731 p_position_h_v in ghr_positions_h_v%rowtype,
732 p_position_data out nocopy per_positions%rowtype);
733
734 Procedure conv_position_rg_to_hist_rg(
735 p_position_data in per_positions%rowtype,
736 p_history_data in out nocopy ghr_pa_history%rowtype);
737
738 Procedure conv_to_position_rg(
739 p_history_data in ghr_pa_history%rowtype,
740 p_position_data in out nocopy per_positions%rowtype);
741
742 */
743
744 Procedure conv_to_position_rg(
745 p_position_id in hr_all_positions_f.position_id%TYPE default NULL,
746 p_effective_start_date in hr_all_positions_f.effective_start_date%TYPE default NULL,
747 p_effective_end_date in hr_all_positions_f.effective_end_date%TYPE default NULL,
748 p_availability_status_id in hr_all_positions_f.availability_status_id%TYPE default NULL,
749 p_business_group_id in hr_all_positions_f.business_group_id%TYPE default NULL,
750 p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE default NULL,
751 p_job_id in hr_all_positions_f.job_id%TYPE default NULL,
752 p_location_id in hr_all_positions_f.location_id%TYPE default NULL,
753 p_organization_id in hr_all_positions_f.organization_id%TYPE default NULL,
754 p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE default NULL,
755 p_position_definition_id in hr_all_positions_f.position_definition_id%TYPE default NULL,
756 p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE default NULL,
757 p_prior_position_id in hr_all_positions_f.prior_position_id%TYPE default NULL,
758 p_relief_position_id in hr_all_positions_f.relief_position_id%TYPE default NULL,
759 p_successor_position_id in hr_all_positions_f.successor_position_id%TYPE default NULL,
760 p_supervisor_position_id in hr_all_positions_f.supervisor_position_id%TYPE default NULL,
761 p_amendment_date in hr_all_positions_f.amendment_date%TYPE default NULL,
762 p_amendment_recommendation in hr_all_positions_f.amendment_recommendation%TYPE default NULL,
763 p_amendment_ref_number in hr_all_positions_f.amendment_ref_number%TYPE default NULL,
764 p_bargaining_unit_cd in hr_all_positions_f.bargaining_unit_cd%TYPE default NULL,
765 p_current_job_prop_end_date in hr_all_positions_f.current_job_prop_end_date%TYPE default NULL,
766 p_current_org_prop_end_date in hr_all_positions_f.current_org_prop_end_date%TYPE default NULL,
767 p_avail_status_prop_end_date in hr_all_positions_f.avail_status_prop_end_date%TYPE default NULL,
768 p_date_effective in hr_all_positions_f.date_effective%TYPE default NULL,
769 p_date_end in hr_all_positions_f.date_end%TYPE default NULL,
770 p_earliest_hire_date in hr_all_positions_f.earliest_hire_date%TYPE default NULL,
771 p_fill_by_date in hr_all_positions_f.fill_by_date%TYPE default NULL,
772 p_frequency in hr_all_positions_f.frequency%TYPE default NULL,
773 p_fte in hr_all_positions_f.fte%TYPE default NULL,
774 p_max_persons in hr_all_positions_f.max_persons%TYPE default NULL,
775 p_name in hr_all_positions_f.name%TYPE default NULL,
776 p_overlap_period in hr_all_positions_f.overlap_period%TYPE default NULL,
777 p_overlap_unit_cd in hr_all_positions_f.overlap_unit_cd%TYPE default NULL,
778 p_pay_term_end_day_cd in hr_all_positions_f.pay_term_end_day_cd%TYPE default NULL,
779 p_pay_term_end_month_cd in hr_all_positions_f.pay_term_end_month_cd%TYPE default NULL,
780 p_permanent_temporary_flag in hr_all_positions_f.permanent_temporary_flag%TYPE default NULL,
781 p_permit_recruitment_flag in hr_all_positions_f.permit_recruitment_flag%TYPE default NULL,
782 p_position_type in hr_all_positions_f.position_type%TYPE default NULL,
783 p_posting_description in hr_all_positions_f.posting_description%TYPE default NULL,
784 p_probation_period in hr_all_positions_f.probation_period%TYPE default NULL,
785 p_probation_period_unit_cd in hr_all_positions_f.probation_period_unit_cd%TYPE default NULL,
786 p_replacement_required_flag in hr_all_positions_f.replacement_required_flag%TYPE default NULL,
787 p_review_flag in hr_all_positions_f.review_flag%TYPE default NULL,
788 p_seasonal_flag in hr_all_positions_f.seasonal_flag%TYPE default NULL,
789 p_security_requirements in hr_all_positions_f.security_requirements%TYPE default NULL,
790 p_status in hr_all_positions_f.status%TYPE default NULL,
791 p_term_start_day_cd in hr_all_positions_f.term_start_day_cd%TYPE default NULL,
792 p_term_start_month_cd in hr_all_positions_f.term_start_month_cd%TYPE default NULL,
793 p_time_normal_finish in hr_all_positions_f.time_normal_finish%TYPE default NULL,
794 p_time_normal_start in hr_all_positions_f.time_normal_start%TYPE default NULL,
795 p_update_source_cd in hr_all_positions_f.update_source_cd%TYPE default NULL,
796 p_working_hours in hr_all_positions_f.working_hours%TYPE default NULL,
797 p_works_council_approval_flag in hr_all_positions_f.works_council_approval_flag%TYPE default NULL,
798 p_work_period_type_cd in hr_all_positions_f.work_period_type_cd%TYPE default NULL,
799 p_work_term_end_day_cd in hr_all_positions_f.work_term_end_day_cd%TYPE default NULL,
800 p_work_term_end_month_cd in hr_all_positions_f.work_term_end_month_cd%TYPE default NULL,
801 p_information_category in hr_all_positions_f.information_category%TYPE default NULL,
802 p_information1 in hr_all_positions_f.information1%TYPE default NULL,
803 p_information2 in hr_all_positions_f.information2%TYPE default NULL,
804 p_information3 in hr_all_positions_f.information3%TYPE default NULL,
805 p_information4 in hr_all_positions_f.information4%TYPE default NULL,
806 p_information5 in hr_all_positions_f.information5%TYPE default NULL,
807 p_information6 in hr_all_positions_f.information6%TYPE default NULL,
808 p_information7 in hr_all_positions_f.information7%TYPE default NULL,
809 p_information8 in hr_all_positions_f.information8%TYPE default NULL,
810 p_information9 in hr_all_positions_f.information9%TYPE default NULL,
811 p_information10 in hr_all_positions_f.information10%TYPE default NULL,
812 p_information11 in hr_all_positions_f.information11%TYPE default NULL,
813 p_information12 in hr_all_positions_f.information12%TYPE default NULL,
814 p_information13 in hr_all_positions_f.information13%TYPE default NULL,
815 p_information14 in hr_all_positions_f.information14%TYPE default NULL,
816 p_information15 in hr_all_positions_f.information15%TYPE default NULL,
817 p_information16 in hr_all_positions_f.information16%TYPE default NULL,
818 p_information17 in hr_all_positions_f.information17%TYPE default NULL,
819 p_information18 in hr_all_positions_f.information18%TYPE default NULL,
820 p_information19 in hr_all_positions_f.information19%TYPE default NULL,
821 p_information20 in hr_all_positions_f.information20%TYPE default NULL,
822 p_information21 in hr_all_positions_f.information21%TYPE default NULL,
823 p_information22 in hr_all_positions_f.information22%TYPE default NULL,
824 p_information23 in hr_all_positions_f.information23%TYPE default NULL,
825 p_information24 in hr_all_positions_f.information24%TYPE default NULL,
826 p_information25 in hr_all_positions_f.information25%TYPE default NULL,
827 p_information26 in hr_all_positions_f.information26%TYPE default NULL,
828 p_information27 in hr_all_positions_f.information27%TYPE default NULL,
829 p_information28 in hr_all_positions_f.information28%TYPE default NULL,
830 p_information29 in hr_all_positions_f.information29%TYPE default NULL,
831 p_information30 in hr_all_positions_f.information30%TYPE default NULL,
832 p_attribute_category in hr_all_positions_f.attribute_category%TYPE default NULL,
833 p_attribute1 in hr_all_positions_f.attribute1%TYPE default NULL,
834 p_attribute2 in hr_all_positions_f.attribute2%TYPE default NULL,
835 p_attribute3 in hr_all_positions_f.attribute3%TYPE default NULL,
836 p_attribute4 in hr_all_positions_f.attribute4%TYPE default NULL,
837 p_attribute5 in hr_all_positions_f.attribute5%TYPE default NULL,
838 p_attribute6 in hr_all_positions_f.attribute6%TYPE default NULL,
839 p_attribute7 in hr_all_positions_f.attribute7%TYPE default NULL,
840 p_attribute8 in hr_all_positions_f.attribute8%TYPE default NULL,
841 p_attribute9 in hr_all_positions_f.attribute9%TYPE default NULL,
842 p_attribute10 in hr_all_positions_f.attribute10%TYPE default NULL,
843 p_attribute11 in hr_all_positions_f.attribute11%TYPE default NULL,
844 p_attribute12 in hr_all_positions_f.attribute12%TYPE default NULL,
845 p_attribute13 in hr_all_positions_f.attribute13%TYPE default NULL,
846 p_attribute14 in hr_all_positions_f.attribute14%TYPE default NULL,
847 p_attribute15 in hr_all_positions_f.attribute15%TYPE default NULL,
848 p_attribute16 in hr_all_positions_f.attribute16%TYPE default NULL,
849 p_attribute17 in hr_all_positions_f.attribute17%TYPE default NULL,
850 p_attribute18 in hr_all_positions_f.attribute18%TYPE default NULL,
851 p_attribute19 in hr_all_positions_f.attribute19%TYPE default NULL,
852 p_attribute20 in hr_all_positions_f.attribute20%TYPE default NULL,
853 p_attribute21 in hr_all_positions_f.attribute21%TYPE default NULL,
854 p_attribute22 in hr_all_positions_f.attribute22%TYPE default NULL,
855 p_attribute23 in hr_all_positions_f.attribute23%TYPE default NULL,
856 p_attribute24 in hr_all_positions_f.attribute24%TYPE default NULL,
857 p_attribute25 in hr_all_positions_f.attribute25%TYPE default NULL,
858 p_attribute26 in hr_all_positions_f.attribute26%TYPE default NULL,
859 p_attribute27 in hr_all_positions_f.attribute27%TYPE default NULL,
860 p_attribute28 in hr_all_positions_f.attribute28%TYPE default NULL,
861 p_attribute29 in hr_all_positions_f.attribute29%TYPE default NULL,
862 p_attribute30 in hr_all_positions_f.attribute30%TYPE default NULL,
863 p_request_id in hr_all_positions_f.request_id%TYPE default NULL,
864 p_program_application_id in hr_all_positions_f.program_application_id%TYPE default NULL,
865 p_program_id in hr_all_positions_f.program_id%TYPE default NULL,
866 p_program_update_date in hr_all_positions_f.program_update_date%TYPE default NULL,
867 p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE default NULL,
868 p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE default NULL,
869 p_proposed_fte_for_layoff in hr_all_positions_f.proposed_fte_for_layoff%TYPE default NULL,
870 p_proposed_date_for_layoff in hr_all_positions_f.proposed_date_for_layoff%TYPE default NULL,
871 p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE default NULL,
872 p_supervisor_id in hr_all_positions_f.supervisor_id%TYPE default NULL,
873 p_copied_to_old_table_flag in hr_all_positions_f.copied_to_old_table_flag%TYPE default NULL,
874 p_position_data in out nocopy hr_all_positions_f%rowtype );
875
876 Procedure conv_to_position_rg (
877 p_position_h_v in ghr_positions_h_v%rowtype,
878 p_position_data out nocopy hr_all_positions_f%rowtype);
879
880 Procedure conv_position_rg_to_hist_rg(
881 p_position_data in hr_all_positions_f%rowtype,
882 p_history_data in out nocopy ghr_pa_history%rowtype);
883
884 Procedure conv_to_position_rg(
885 p_history_data in ghr_pa_history%rowtype,
886 p_position_data in out nocopy hr_all_positions_f%rowtype);
887
888
889 End GHR_HISTORY_CONV_RG;