1 PACKAGE per_qh_maintain_update AUTHID CURRENT_USER AS
2 /* $Header: peqhmnti.pkh 120.5.12020000.1 2012/06/29 01:56:39 appldev ship $ */
3
4 -- Fix For Bug 8246722 Starts--
5
6 p_qh_organization_id per_all_assignments_f.organization_id%TYPE default NULL;
7
8 -- Fix For Bug 8246722 Ends--
9
10 PROCEDURE insert_maintain_data
11 (p_effective_date IN DATE
12 ,p_person_id OUT NOCOPY per_all_people_f.person_id%TYPE
13 ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
14 ,p_legislation_code IN VARCHAR2
15 ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
16 ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
17 ,p_per_validation_start_date OUT NOCOPY DATE
18 ,p_per_validation_end_date OUT NOCOPY DATE
19 ,p_person_type IN per_person_types.user_person_type%TYPE
20 ,p_system_person_type IN per_person_types.system_person_type%TYPE
21 ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
22 ,p_last_name IN per_all_people_f.last_name%TYPE
23 ,p_start_date IN per_all_people_f.start_date%TYPE
24 ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
25 ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
26 ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
27 ,p_blood_type IN per_all_people_f.blood_type%TYPE
28 ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
29 ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
30 ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
31 ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
32 ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
33 --CWK
34 ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
35 ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
36 ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
37 ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
38 ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
39 ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
40 ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
41 ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
42 ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
43 ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
44 ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
45 ,p_project_title IN per_all_assignments_f.project_title%TYPE
46 ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
47 ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
48 ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
49 ,p_rate_value IN pay_grade_rules_f.value%TYPE
50 ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
51 ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
52 ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
53 --
54 ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
55 ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
56 ,p_email_address IN per_all_people_f.email_address%TYPE
57 ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
58 ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
59 ,p_first_name IN per_all_people_f.first_name%TYPE
60 ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
61 ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
62 ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
63 ,p_honors IN per_all_people_f.honors%TYPE
64 ,p_internal_location IN per_all_people_f.internal_location%TYPE
65 ,p_known_as IN per_all_people_f.known_as%TYPE
66 ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
67 ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
68 ,p_mailstop IN per_all_people_f.mailstop%TYPE
69 ,p_marital_status IN per_all_people_f.marital_status%TYPE
70 ,p_middle_names IN per_all_people_f.middle_names%TYPE
71 ,p_nationality IN per_all_people_f.nationality%TYPE
72 ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
73 ,p_office_number IN per_all_people_f.office_number%TYPE
74 ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
75 ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
76 ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
77 ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
78 ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
79 ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
80 ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
81 ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
82 ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
83 ,p_sex IN per_all_people_f.sex%TYPE
84 ,p_student_status IN per_all_people_f.student_status%TYPE
85 ,p_suffix IN per_all_people_f.suffix%TYPE
86 ,p_title IN per_all_people_f.title%TYPE
87 ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
88 ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
89 ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
90 ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
91 ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
92 ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
93 ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
94 ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
95 ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
96 ,p_attribute1 IN per_all_people_f.attribute1%TYPE
97 ,p_attribute2 IN per_all_people_f.attribute2%TYPE
98 ,p_attribute3 IN per_all_people_f.attribute3%TYPE
99 ,p_attribute4 IN per_all_people_f.attribute4%TYPE
100 ,p_attribute5 IN per_all_people_f.attribute5%TYPE
101 ,p_attribute6 IN per_all_people_f.attribute6%TYPE
102 ,p_attribute7 IN per_all_people_f.attribute7%TYPE
103 ,p_attribute8 IN per_all_people_f.attribute8%TYPE
104 ,p_attribute9 IN per_all_people_f.attribute9%TYPE
105 ,p_attribute10 IN per_all_people_f.attribute10%TYPE
106 ,p_attribute11 IN per_all_people_f.attribute11%TYPE
107 ,p_attribute12 IN per_all_people_f.attribute12%TYPE
108 ,p_attribute13 IN per_all_people_f.attribute13%TYPE
109 ,p_attribute14 IN per_all_people_f.attribute14%TYPE
110 ,p_attribute15 IN per_all_people_f.attribute15%TYPE
111 ,p_attribute16 IN per_all_people_f.attribute16%TYPE
112 ,p_attribute17 IN per_all_people_f.attribute17%TYPE
113 ,p_attribute18 IN per_all_people_f.attribute18%TYPE
114 ,p_attribute19 IN per_all_people_f.attribute19%TYPE
115 ,p_attribute20 IN per_all_people_f.attribute20%TYPE
116 ,p_attribute21 IN per_all_people_f.attribute21%TYPE
117 ,p_attribute22 IN per_all_people_f.attribute22%TYPE
118 ,p_attribute23 IN per_all_people_f.attribute23%TYPE
119 ,p_attribute24 IN per_all_people_f.attribute24%TYPE
120 ,p_attribute25 IN per_all_people_f.attribute25%TYPE
121 ,p_attribute26 IN per_all_people_f.attribute26%TYPE
122 ,p_attribute27 IN per_all_people_f.attribute27%TYPE
123 ,p_attribute28 IN per_all_people_f.attribute28%TYPE
124 ,p_attribute29 IN per_all_people_f.attribute29%TYPE
125 ,p_attribute30 IN per_all_people_f.attribute30%TYPE
126 ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
127 ,p_per_information1 IN per_all_people_f.attribute1%TYPE
128 ,p_per_information2 IN per_all_people_f.attribute2%TYPE
129 ,p_per_information3 IN per_all_people_f.attribute3%TYPE
130 ,p_per_information4 IN per_all_people_f.attribute4%TYPE
131 ,p_per_information5 IN per_all_people_f.attribute5%TYPE
132 ,p_per_information6 IN per_all_people_f.attribute6%TYPE
133 ,p_per_information7 IN per_all_people_f.attribute7%TYPE
134 ,p_per_information8 IN per_all_people_f.attribute8%TYPE
135 ,p_per_information9 IN per_all_people_f.attribute9%TYPE
136 ,p_per_information10 IN per_all_people_f.attribute10%TYPE
137 ,p_per_information11 IN per_all_people_f.attribute11%TYPE
138 ,p_per_information12 IN per_all_people_f.attribute12%TYPE
139 ,p_per_information13 IN per_all_people_f.attribute13%TYPE
140 ,p_per_information14 IN per_all_people_f.attribute14%TYPE
141 ,p_per_information15 IN per_all_people_f.attribute15%TYPE
142 ,p_per_information16 IN per_all_people_f.attribute16%TYPE
143 ,p_per_information17 IN per_all_people_f.attribute17%TYPE
144 ,p_per_information18 IN per_all_people_f.attribute18%TYPE
145 ,p_per_information19 IN per_all_people_f.attribute19%TYPE
146 ,p_per_information20 IN per_all_people_f.attribute20%TYPE
147 ,p_per_information21 IN per_all_people_f.attribute21%TYPE
148 ,p_per_information22 IN per_all_people_f.attribute22%TYPE
149 ,p_per_information23 IN per_all_people_f.attribute23%TYPE
150 ,p_per_information24 IN per_all_people_f.attribute24%TYPE
151 ,p_per_information25 IN per_all_people_f.attribute25%TYPE
152 ,p_per_information26 IN per_all_people_f.attribute26%TYPE
153 ,p_per_information27 IN per_all_people_f.attribute27%TYPE
154 ,p_per_information28 IN per_all_people_f.attribute28%TYPE
155 ,p_per_information29 IN per_all_people_f.attribute29%TYPE
156 ,p_per_information30 IN per_all_people_f.attribute30%TYPE
157 ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
158 ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
159 ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
160 ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
161 ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
162 ,p_party_id IN per_all_people_f.party_id%TYPE default null
163 ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
164 ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
165 ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
166 ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
167 ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
168 ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
169 ,p_asg_validation_start_date OUT NOCOPY DATE
170 ,p_asg_validation_end_date OUT NOCOPY DATE
171 ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
172 ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
173 ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
174 ,p_position_id IN per_all_assignments_f.position_id%TYPE
175 ,p_job_id IN per_all_assignments_f.job_id%TYPE
176 ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
177 ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
178 ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
179 ,p_location_id IN per_all_assignments_f.location_id%TYPE
180 ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
181 ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
182 ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
183 ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
184 ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
185 ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
186 ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
187 ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
188 ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
189 ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
190 ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
191 ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
192 ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
193 ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
194 ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
195 ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
196 ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
197 ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
198 ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
199 ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
200 ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
201 ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
202 ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
203 ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
204 ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
205 ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
206 ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
207 ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
208 ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
209 ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
210 ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
211 ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
212 ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
213 ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
214 ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
215 ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
216 ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
217 ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
218 ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
219 ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
220 ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
221 ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
222 ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
223 ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
224 ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
225 ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
226 ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
227 ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
228 ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
229 ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
230 ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
231 ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
232 ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
233 ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
234 ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
235 ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
236 ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
237 ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
238 ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
239 ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
240 ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
241 ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
242 ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
243 ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
244 ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
245 ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
246 ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
247 ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
248 ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
249 ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
250 ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
251 ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
252 ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
253 ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
254 ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
255 ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
256 ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
257 ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
258 ,p_frequency IN per_all_assignments_f.frequency%TYPE
259 ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
260 ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
261 ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
262 ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
263 ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
264 ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
265 --
266 ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
267 ,p_billing_title IN per_all_assignments_f.title%type
268 --
269 ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
270 ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
271 ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
272 ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
273 ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
274 ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
275 ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
276 ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
277 ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
278 ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
279 ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
280 ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
281 ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
282 ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
283 ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
284 ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
285 ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
286 ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
287 ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
288 ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
289 ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
290 ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
291 ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
292 ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
293 ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
294 ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
295 ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
296 ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
297 ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
298 ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
299 ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
300 ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
301 ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
302 ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
303 ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
304 ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
305 ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
306 ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
307 ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
308 ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
309 ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
310 ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
311 ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
312 ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
313 ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
314 ,p_source_type IN per_all_assignments_f.source_type%TYPE
315 ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
316 ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
317 ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
318 ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
319 ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
320 --Bug 3063591 Start Here
321 ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
322 --Bug 3063591 End Here
323 ,p_application_id OUT NOCOPY per_applications.application_id%TYPE
324 -- Bug 3900299 Starts Here
325 ,p_app_date_received IN OUT NOCOPY per_applications.date_received%TYPE
326 -- Bug 3900299 Ends Here
327 ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
328 ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
329 ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
330 ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
331 ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
332 ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
333 ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
334 ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
335 ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
336 ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
337 ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
338 ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
339 ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
340 ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
341 ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
342 ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
343 ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
344 ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
345 ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
346 ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
347 ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
348 ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
349 ,p_current_employer IN per_applications.current_employer%TYPE
350 ,p_termination_reason IN per_applications.termination_reason%TYPE
351 ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
352 ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
353 ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
354 ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE
355 ,p_adr_date_from IN per_addresses.date_from%TYPE
356 ,p_style IN per_addresses.style%TYPE
357 ,p_address_line1 IN per_addresses.address_line1%TYPE
358 ,p_address_line2 IN per_addresses.address_line2%TYPE
359 ,p_address_line3 IN per_addresses.address_line3%TYPE
360 ,p_address_type IN per_addresses.address_type%TYPE
361 ,p_country IN per_addresses.country%TYPE
362 ,p_adr_date_to IN per_addresses.date_to%TYPE
363 ,p_postal_code IN per_addresses.postal_code%TYPE
364 ,p_region_1 IN per_addresses.region_1%TYPE
365 ,p_region_2 IN per_addresses.region_2%TYPE
366 ,p_region_3 IN per_addresses.region_3%TYPE
367 ,p_town_or_city IN per_addresses.town_or_city%TYPE
368 ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
369 ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
370 ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
371 ,p_add_information13 IN per_addresses.add_information13%TYPE
372 ,p_add_information14 IN per_addresses.add_information14%TYPE
373 ,p_add_information15 IN per_addresses.add_information15%TYPE
374 ,p_add_information16 IN per_addresses.add_information16%TYPE
375 ,p_add_information17 IN per_addresses.add_information17%TYPE
376 ,p_add_information18 IN per_addresses.add_information18%TYPE
377 ,p_add_information19 IN per_addresses.add_information19%TYPE
378 ,p_add_information20 IN per_addresses.add_information20%TYPE
379 ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
380 ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
381 ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
382 ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
383 ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
384 ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
385 ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
386 ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
387 ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
388 ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
389 ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
390 ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
391 ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
392 ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
393 ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
394 ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
395 ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
396 ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
397 ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
398 ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
399 ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
400 ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE
401 ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE
402 ,p_phn_h_date_from IN per_phones.date_from%TYPE
403 ,p_phn_h_date_to IN per_phones.date_to%TYPE
404 ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
405 ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
406 ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
407 ,p_phn_w_date_from IN per_phones.date_from%TYPE
408 ,p_phn_w_date_to IN per_phones.date_to%TYPE
409 ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
410 ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
411 ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
412 ,p_phn_m_date_from IN per_phones.date_from%TYPE
413 ,p_phn_m_date_to IN per_phones.date_to%TYPE
414 ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
415 ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
416 ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
417 ,p_phn_hf_date_from IN per_phones.date_from%TYPE
418 ,p_phn_hf_date_to IN per_phones.date_to%TYPE
419 ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
420 ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
421 ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
422 ,p_phn_wf_date_from IN per_phones.date_from%TYPE
423 ,p_phn_wf_date_to IN per_phones.date_to%TYPE
424 ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
425 ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
426 ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
427 ,p_change_date IN per_pay_proposals.change_date%TYPE
428 ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
429 ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
430 ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
431 ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
432 ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
433 ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
434 ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
435 ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
436 ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
437 ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
438 ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
439 ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
440 ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
441 ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
442 ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
443 ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
444 ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
445 ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
446 ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
447 ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
448 ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
449 ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
450 ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE
451 ,p_pyp_object_version_number OUT NOCOPY per_pay_proposals.object_version_number%TYPE
452 ,p_approved IN per_pay_proposals.approved%TYPE
453 ,p_deployment_factor_id OUT NOCOPY per_deployment_factors.deployment_factor_id%TYPE
454 ,p_work_any_country IN per_deployment_factors.work_any_country%TYPE
455 ,p_work_any_location IN per_deployment_factors.work_any_location%TYPE
456 ,p_relocate_domestically IN per_deployment_factors.relocate_domestically%TYPE
457 ,p_relocate_internationally IN per_deployment_factors.relocate_internationally%TYPE
458 ,p_travel_required IN per_deployment_factors.travel_required%TYPE
459 ,p_country1 IN per_deployment_factors.country1%TYPE
460 ,p_country2 IN per_deployment_factors.country2%TYPE
461 ,p_country3 IN per_deployment_factors.country3%TYPE
462 ,p_dpf_work_duration IN per_deployment_factors.work_duration%TYPE
463 ,p_dpf_work_schedule IN per_deployment_factors.work_schedule%TYPE
464 ,p_dpf_work_hours IN per_deployment_factors.work_hours%TYPE
465 ,p_dpf_fte_capacity IN per_deployment_factors.fte_capacity%TYPE
466 ,p_visit_internationally IN per_deployment_factors.visit_internationally%TYPE
467 ,p_only_current_location IN per_deployment_factors.only_current_location%TYPE
468 ,p_no_country1 IN per_deployment_factors.no_country1%TYPE
469 ,p_no_country2 IN per_deployment_factors.no_country2%TYPE
470 ,p_no_country3 IN per_deployment_factors.no_country3%TYPE
471 ,p_earliest_available_date IN per_deployment_factors.earliest_available_date%TYPE
472 ,p_available_for_transfer IN per_deployment_factors.available_for_transfer%TYPE
473 ,p_relocation_preference IN per_deployment_factors.relocation_preference%TYPE
474 ,p_dpf_object_version_number OUT NOCOPY per_deployment_factors.object_version_number%TYPE
475 ,p_dpf_attribute_category IN per_deployment_factors.attribute_category%TYPE
476 ,p_dpf_attribute1 IN per_deployment_factors.attribute1%TYPE
477 ,p_dpf_attribute2 IN per_deployment_factors.attribute2%TYPE
478 ,p_dpf_attribute3 IN per_deployment_factors.attribute3%TYPE
479 ,p_dpf_attribute4 IN per_deployment_factors.attribute4%TYPE
480 ,p_dpf_attribute5 IN per_deployment_factors.attribute5%TYPE
481 ,p_dpf_attribute6 IN per_deployment_factors.attribute6%TYPE
482 ,p_dpf_attribute7 IN per_deployment_factors.attribute7%TYPE
483 ,p_dpf_attribute8 IN per_deployment_factors.attribute8%TYPE
484 ,p_dpf_attribute9 IN per_deployment_factors.attribute9%TYPE
485 ,p_dpf_attribute10 IN per_deployment_factors.attribute10%TYPE
486 ,p_dpf_attribute11 IN per_deployment_factors.attribute11%TYPE
487 ,p_dpf_attribute12 IN per_deployment_factors.attribute12%TYPE
488 ,p_dpf_attribute13 IN per_deployment_factors.attribute13%TYPE
489 ,p_dpf_attribute14 IN per_deployment_factors.attribute14%TYPE
490 ,p_dpf_attribute15 IN per_deployment_factors.attribute15%TYPE
491 ,p_dpf_attribute16 IN per_deployment_factors.attribute16%TYPE
492 ,p_dpf_attribute17 IN per_deployment_factors.attribute17%TYPE
493 ,p_dpf_attribute18 IN per_deployment_factors.attribute18%TYPE
494 ,p_dpf_attribute19 IN per_deployment_factors.attribute19%TYPE
495 ,p_dpf_attribute20 IN per_deployment_factors.attribute20%TYPE
496 ,p_chk1_checklist_item_id OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
497 ,p_chk1_item_code IN per_checklist_items.item_code%TYPE
498 ,p_chk1_date_due IN per_checklist_items.date_due%TYPE
499 ,p_chk1_date_done IN per_checklist_items.date_done%TYPE
500 ,p_chk1_status IN per_checklist_items.status%TYPE
501 ,p_chk1_notes IN per_checklist_items.notes%TYPE
502 ,p_chk1_object_version_number OUT NOCOPY per_checklist_items.object_version_number%TYPE
503 ,p_chk2_checklist_item_id OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
504 ,p_chk2_item_code IN per_checklist_items.item_code%TYPE
505 ,p_chk2_date_due IN per_checklist_items.date_due%TYPE
506 ,p_chk2_date_done IN per_checklist_items.date_done%TYPE
507 ,p_chk2_status IN per_checklist_items.status%TYPE
508 ,p_chk2_notes IN per_checklist_items.notes%TYPE
509 ,p_chk2_object_version_number OUT NOCOPY per_checklist_items.object_version_number%TYPE
510 ,p_chk3_checklist_item_id OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
511 ,p_chk3_item_code IN per_checklist_items.item_code%TYPE
512 ,p_chk3_date_due IN per_checklist_items.date_due%TYPE
513 ,p_chk3_date_done IN per_checklist_items.date_done%TYPE
514 ,p_chk3_status IN per_checklist_items.status%TYPE
515 ,p_chk3_notes IN per_checklist_items.notes%TYPE
516 ,p_chk3_object_version_number OUT NOCOPY per_checklist_items.object_version_number%TYPE
517 ,p_chk4_checklist_item_id OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
518 ,p_chk4_item_code IN per_checklist_items.item_code%TYPE
519 ,p_chk4_date_due IN per_checklist_items.date_due%TYPE
520 ,p_chk4_date_done IN per_checklist_items.date_done%TYPE
521 ,p_chk4_status IN per_checklist_items.status%TYPE
522 ,p_chk4_notes IN per_checklist_items.notes%TYPE
523 ,p_chk4_object_version_number OUT NOCOPY per_checklist_items.object_version_number%TYPE
524 ,p_chk5_checklist_item_id OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
525 ,p_chk5_item_code IN per_checklist_items.item_code%TYPE
526 ,p_chk5_date_due IN per_checklist_items.date_due%TYPE
527 ,p_chk5_date_done IN per_checklist_items.date_done%TYPE
528 ,p_chk5_status IN per_checklist_items.status%TYPE
529 ,p_chk5_notes IN per_checklist_items.notes%TYPE
530 ,p_chk5_object_version_number OUT NOCOPY per_checklist_items.object_version_number%TYPE
531 ,p_chk6_checklist_item_id OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
532 ,p_chk6_item_code IN per_checklist_items.item_code%TYPE
533 ,p_chk6_date_due IN per_checklist_items.date_due%TYPE
534 ,p_chk6_date_done IN per_checklist_items.date_done%TYPE
535 ,p_chk6_status IN per_checklist_items.status%TYPE
536 ,p_chk6_notes IN per_checklist_items.notes%TYPE
537 ,p_chk6_object_version_number OUT NOCOPY per_checklist_items.object_version_number%TYPE
538 ,p_chk7_checklist_item_id OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
539 ,p_chk7_item_code IN per_checklist_items.item_code%TYPE
540 ,p_chk7_date_due IN per_checklist_items.date_due%TYPE
541 ,p_chk7_date_done IN per_checklist_items.date_done%TYPE
542 ,p_chk7_status IN per_checklist_items.status%TYPE
543 ,p_chk7_notes IN per_checklist_items.notes%TYPE
544 ,p_chk7_object_version_number OUT NOCOPY per_checklist_items.object_version_number%TYPE
545 ,p_chk8_checklist_item_id OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
546 ,p_chk8_item_code IN per_checklist_items.item_code%TYPE
547 ,p_chk8_date_due IN per_checklist_items.date_due%TYPE
548 ,p_chk8_date_done IN per_checklist_items.date_done%TYPE
549 ,p_chk8_status IN per_checklist_items.status%TYPE
550 ,p_chk8_notes IN per_checklist_items.notes%TYPE
551 ,p_chk8_object_version_number OUT NOCOPY per_checklist_items.object_version_number%TYPE
552 ,p_chk9_checklist_item_id OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
553 ,p_chk9_item_code IN per_checklist_items.item_code%TYPE
554 ,p_chk9_date_due IN per_checklist_items.date_due%TYPE
555 ,p_chk9_date_done IN per_checklist_items.date_done%TYPE
556 ,p_chk9_status IN per_checklist_items.status%TYPE
557 ,p_chk9_notes IN per_checklist_items.notes%TYPE
558 ,p_chk9_object_version_number OUT NOCOPY per_checklist_items.object_version_number%TYPE
559 ,p_chk10_checklist_item_id OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
560 ,p_chk10_item_code IN per_checklist_items.item_code%TYPE
561 ,p_chk10_date_due IN per_checklist_items.date_due%TYPE
562 ,p_chk10_date_done IN per_checklist_items.date_done%TYPE
563 ,p_chk10_status IN per_checklist_items.status%TYPE
564 ,p_chk10_notes IN per_checklist_items.notes%TYPE
565 ,p_chk10_object_version_number OUT NOCOPY per_checklist_items.object_version_number%TYPE
566 ,p_tax_effective_start_date IN OUT NOCOPY DATE
567 ,p_tax_effective_end_date IN OUT NOCOPY DATE
568 ,p_tax_field1 IN OUT NOCOPY VARCHAR2
569 ,p_tax_field2 IN OUT NOCOPY VARCHAR2
570 ,p_tax_field3 IN OUT NOCOPY VARCHAR2
571 ,p_tax_field4 IN OUT NOCOPY VARCHAR2
572 ,p_tax_field5 IN OUT NOCOPY VARCHAR2
573 ,p_tax_field6 IN OUT NOCOPY VARCHAR2
574 ,p_tax_field7 IN OUT NOCOPY VARCHAR2
575 ,p_tax_field8 IN OUT NOCOPY VARCHAR2
576 ,p_tax_field9 IN OUT NOCOPY VARCHAR2
577 ,p_tax_field10 IN OUT NOCOPY VARCHAR2
578 ,p_tax_field11 IN OUT NOCOPY VARCHAR2
579 ,p_tax_field12 IN OUT NOCOPY VARCHAR2
580 ,p_tax_field13 IN OUT NOCOPY VARCHAR2
581 ,p_tax_field14 IN OUT NOCOPY VARCHAR2
582 ,p_tax_field15 IN OUT NOCOPY VARCHAR2
583 ,p_tax_field16 IN OUT NOCOPY VARCHAR2
584 ,p_tax_field17 IN OUT NOCOPY VARCHAR2
585 ,p_tax_field18 IN OUT NOCOPY VARCHAR2
586 ,p_tax_field19 IN OUT NOCOPY VARCHAR2
587 ,p_tax_field20 IN OUT NOCOPY VARCHAR2
588 ,p_tax_field21 IN OUT NOCOPY VARCHAR2
589 ,p_tax_field22 IN OUT NOCOPY VARCHAR2
590 ,p_tax_field23 IN OUT NOCOPY VARCHAR2
591 ,p_tax_field24 IN OUT NOCOPY VARCHAR2
592 ,p_tax_field25 IN OUT NOCOPY VARCHAR2
593 ,p_tax_field26 IN OUT NOCOPY VARCHAR2
594 ,p_tax_field27 IN OUT NOCOPY VARCHAR2
595 ,p_tax_field28 IN OUT NOCOPY VARCHAR2
596 ,p_tax_field29 IN OUT NOCOPY VARCHAR2
597 ,p_tax_field30 IN OUT NOCOPY VARCHAR2
598 ,p_tax_field31 IN OUT NOCOPY VARCHAR2
599 ,p_tax_field32 IN OUT NOCOPY VARCHAR2
600 ,p_tax_field33 IN OUT NOCOPY VARCHAR2
601 ,p_tax_field34 IN OUT NOCOPY VARCHAR2
602 ,p_tax_field35 IN OUT NOCOPY VARCHAR2
603 ,p_tax_field36 IN OUT NOCOPY VARCHAR2
604 ,p_tax_field37 IN OUT NOCOPY VARCHAR2
605 ,p_tax_field38 IN OUT NOCOPY VARCHAR2
606 ,p_tax_field39 IN OUT NOCOPY VARCHAR2
607 ,p_tax_field40 IN OUT NOCOPY VARCHAR2
608 ,p_tax_field41 IN OUT NOCOPY VARCHAR2
609 ,p_tax_field42 IN OUT NOCOPY VARCHAR2
610 ,p_tax_field43 IN OUT NOCOPY VARCHAR2
611 ,p_tax_field44 IN OUT NOCOPY VARCHAR2
612 ,p_tax_field45 IN OUT NOCOPY VARCHAR2
613 ,p_tax_field46 IN OUT NOCOPY VARCHAR2
614 ,p_tax_field47 IN OUT NOCOPY VARCHAR2
615 ,p_tax_field48 IN OUT NOCOPY VARCHAR2
616 ,p_tax_field49 IN OUT NOCOPY VARCHAR2
617 ,p_tax_field50 IN OUT NOCOPY VARCHAR2
618 ,p_tax_field51 IN OUT NOCOPY VARCHAR2
619 ,p_tax_field52 IN OUT NOCOPY VARCHAR2
620 ,p_tax_field53 IN OUT NOCOPY VARCHAR2
621 ,p_tax_field54 IN OUT NOCOPY VARCHAR2
622 ,p_tax_field55 IN OUT NOCOPY VARCHAR2
623 ,p_tax_field56 IN OUT NOCOPY VARCHAR2
624 ,p_tax_field57 IN OUT NOCOPY VARCHAR2
625 ,p_tax_field58 IN OUT NOCOPY VARCHAR2
626 ,p_tax_field59 IN OUT NOCOPY VARCHAR2
627 ,p_tax_field60 IN OUT NOCOPY VARCHAR2
628 ,p_tax_field61 IN OUT NOCOPY VARCHAR2
629 ,p_tax_field62 IN OUT NOCOPY VARCHAR2
630 ,p_tax_field63 IN OUT NOCOPY VARCHAR2
631 ,p_tax_field64 IN OUT NOCOPY VARCHAR2
632 ,p_tax_field65 IN OUT NOCOPY VARCHAR2
633 ,p_tax_field66 IN OUT NOCOPY VARCHAR2
634 ,p_tax_field67 IN OUT NOCOPY VARCHAR2
635 ,p_tax_field68 IN OUT NOCOPY VARCHAR2
636 ,p_tax_field69 IN OUT NOCOPY VARCHAR2
637 ,p_tax_field70 IN OUT NOCOPY VARCHAR2
638 ,p_tax_field71 IN OUT NOCOPY VARCHAR2
639 ,p_tax_field72 IN OUT NOCOPY VARCHAR2
640 ,p_tax_field73 IN OUT NOCOPY VARCHAR2
641 ,p_tax_field74 IN OUT NOCOPY VARCHAR2
642 ,p_tax_field75 IN OUT NOCOPY VARCHAR2
643 ,p_tax_field76 IN OUT NOCOPY VARCHAR2
644 ,p_tax_field77 IN OUT NOCOPY VARCHAR2
645 ,p_tax_field78 IN OUT NOCOPY VARCHAR2
646 ,p_tax_field79 IN OUT NOCOPY VARCHAR2
647 ,p_tax_field80 IN OUT NOCOPY VARCHAR2
648 ,p_tax_field81 IN OUT NOCOPY VARCHAR2
649 ,p_tax_field82 IN OUT NOCOPY VARCHAR2
650 ,p_tax_field83 IN OUT NOCOPY VARCHAR2
651 ,p_tax_field84 IN OUT NOCOPY VARCHAR2
652 ,p_tax_field85 IN OUT NOCOPY VARCHAR2
653 ,p_tax_field86 IN OUT NOCOPY VARCHAR2
654 ,p_tax_field87 IN OUT NOCOPY VARCHAR2
655 ,p_tax_field88 IN OUT NOCOPY VARCHAR2
656 ,p_tax_field89 IN OUT NOCOPY VARCHAR2
657 ,p_tax_field90 IN OUT NOCOPY VARCHAR2
658 ,p_tax_field91 IN OUT NOCOPY VARCHAR2
659 ,p_tax_field92 IN OUT NOCOPY VARCHAR2
660 ,p_tax_field93 IN OUT NOCOPY VARCHAR2
661 ,p_tax_field94 IN OUT NOCOPY VARCHAR2
662 ,p_tax_field95 IN OUT NOCOPY VARCHAR2
663 ,p_tax_field96 IN OUT NOCOPY VARCHAR2
664 ,p_tax_field97 IN OUT NOCOPY VARCHAR2
665 ,p_tax_field98 IN OUT NOCOPY VARCHAR2
666 ,p_tax_field99 IN OUT NOCOPY VARCHAR2
667 ,p_tax_field100 IN OUT NOCOPY VARCHAR2
668 ,p_tax_field101 IN OUT NOCOPY VARCHAR2
669 ,p_tax_field102 IN OUT NOCOPY VARCHAR2
670 ,p_tax_field103 IN OUT NOCOPY VARCHAR2
671 ,p_tax_field104 IN OUT NOCOPY VARCHAR2
672 ,p_tax_field105 IN OUT NOCOPY VARCHAR2
673 ,p_tax_field106 IN OUT NOCOPY VARCHAR2
674 ,p_tax_field107 IN OUT NOCOPY VARCHAR2
675 ,p_tax_field108 IN OUT NOCOPY VARCHAR2
676 ,p_tax_field109 IN OUT NOCOPY VARCHAR2
677 ,p_tax_field110 IN OUT NOCOPY VARCHAR2
678 ,p_tax_field111 IN OUT NOCOPY VARCHAR2
679 ,p_tax_field112 IN OUT NOCOPY VARCHAR2
680 ,p_tax_field113 IN OUT NOCOPY VARCHAR2
681 ,p_tax_field114 IN OUT NOCOPY VARCHAR2
682 ,p_tax_field115 IN OUT NOCOPY VARCHAR2
683 ,p_tax_field116 IN OUT NOCOPY VARCHAR2
684 ,p_tax_field117 IN OUT NOCOPY VARCHAR2
685 ,p_tax_field118 IN OUT NOCOPY VARCHAR2
686 ,p_tax_field119 IN OUT NOCOPY VARCHAR2
687 ,p_tax_field120 IN OUT NOCOPY VARCHAR2
688 ,p_tax_field121 IN OUT NOCOPY VARCHAR2
689 ,p_tax_field122 IN OUT NOCOPY VARCHAR2
690 ,p_tax_field123 IN OUT NOCOPY VARCHAR2
691 ,p_tax_field124 IN OUT NOCOPY VARCHAR2
692 ,p_tax_field125 IN OUT NOCOPY VARCHAR2
693 ,p_tax_field126 IN OUT NOCOPY VARCHAR2
694 ,p_tax_field127 IN OUT NOCOPY VARCHAR2
695 ,p_tax_field128 IN OUT NOCOPY VARCHAR2
696 ,p_tax_field129 IN OUT NOCOPY VARCHAR2
697 ,p_tax_field130 IN OUT NOCOPY VARCHAR2
698 ,p_tax_field131 IN OUT NOCOPY VARCHAR2
699 ,p_tax_field132 IN OUT NOCOPY VARCHAR2
700 ,p_tax_field133 IN OUT NOCOPY VARCHAR2
701 ,p_tax_field134 IN OUT NOCOPY VARCHAR2
702 ,p_tax_field135 IN OUT NOCOPY VARCHAR2
703 ,p_tax_field136 IN OUT NOCOPY VARCHAR2
704 ,p_tax_field137 IN OUT NOCOPY VARCHAR2
705 ,p_tax_field138 IN OUT NOCOPY VARCHAR2
706 ,p_tax_field139 IN OUT NOCOPY VARCHAR2
707 ,p_tax_field140 IN OUT NOCOPY VARCHAR2
708 -- Bug 3357807 Start Here
709 ,p_tax_field141 IN OUT NOCOPY DATE
710 ,p_tax_field142 IN OUT NOCOPY DATE
711 ,p_tax_field143 IN OUT NOCOPY DATE
712 ,p_tax_field144 IN OUT NOCOPY DATE
713 ,p_tax_field145 IN OUT NOCOPY DATE
714 ,p_tax_field146 IN OUT NOCOPY DATE
715 ,p_tax_field147 IN OUT NOCOPY DATE
716 ,p_tax_field148 IN OUT NOCOPY DATE
717 ,p_tax_field149 IN OUT NOCOPY DATE
718 ,p_tax_field150 IN OUT NOCOPY DATE
719 -- Bug 3357807 End Here
720 ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
721 ,p_org_now_no_manager_warning OUT NOCOPY BOOLEAN
722 ,p_other_manager_warning OUT NOCOPY BOOLEAN
723 ,p_spp_delete_warning OUT NOCOPY BOOLEAN
724 ,p_entries_changed_warning OUT NOCOPY VARCHAR2
725 ,p_tax_district_changed_warning OUT NOCOPY BOOLEAN
726 ,p_proposed_salary_warning OUT NOCOPY BOOLEAN
727 ,p_approved_warning OUT NOCOPY BOOLEAN
728 ,p_payroll_warning OUT NOCOPY BOOLEAN
729 ,p_gsp_post_process_warning OUT NOCOPY VARCHAR2
730 );
731 --
732 PROCEDURE update_maintain_data
733 (p_effective_date IN DATE
734 ,p_datetrack_update_mode IN VARCHAR2
735 ,p_person_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
736 ,p_person_id IN per_all_people_f.person_id%TYPE
737 ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
738 ,p_legislation_code IN VARCHAR2
739 ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
740 ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
741 ,p_per_validation_start_date OUT NOCOPY DATE
742 ,p_per_validation_end_date OUT NOCOPY DATE
743 ,p_person_type IN per_person_types.user_person_type%TYPE
744 ,p_system_person_type IN per_person_types.system_person_type%TYPE
745 ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
746 ,p_last_name IN per_all_people_f.last_name%TYPE
747 ,p_start_date IN per_all_people_f.start_date%TYPE
748 ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
749 ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
750 ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
751 ,p_blood_type IN per_all_people_f.blood_type%TYPE
752 ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
753 ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
754 ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
755 ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
756 --CWK
757 ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
758 ,p_npw_number IN per_all_people_f.npw_number%TYPE
759 ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
760 ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
761 ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
762 ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
763 ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
764 ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
765 ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
766 ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
767 ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
768 ,p_project_title IN per_all_assignments_f.project_title%TYPE
769 ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
770 ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
771 ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
772 ,p_rate_value IN pay_grade_rules_f.value%TYPE
773 ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
774 ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
775 ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
776 --
777 ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
778 ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
779 ,p_email_address IN per_all_people_f.email_address%TYPE
780 ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
781 ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
782 ,p_first_name IN per_all_people_f.first_name%TYPE
783 ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
784 ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
785 ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
786 ,p_honors IN per_all_people_f.honors%TYPE
787 ,p_internal_location IN per_all_people_f.internal_location%TYPE
788 ,p_known_as IN per_all_people_f.known_as%TYPE
789 ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
790 ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
791 ,p_mailstop IN per_all_people_f.mailstop%TYPE
792 ,p_marital_status IN per_all_people_f.marital_status%TYPE
793 ,p_middle_names IN per_all_people_f.middle_names%TYPE
794 ,p_nationality IN per_all_people_f.nationality%TYPE
795 ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
796 ,p_office_number IN per_all_people_f.office_number%TYPE
797 ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
798 ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
799 ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
800 ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
801 ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
802 ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
803 ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
804 ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
805 ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
806 ,p_sex IN per_all_people_f.sex%TYPE
807 ,p_student_status IN per_all_people_f.student_status%TYPE
808 ,p_suffix IN per_all_people_f.suffix%TYPE
809 ,p_title IN per_all_people_f.title%TYPE
810 ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
811 ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
812 ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
813 ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
814 ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
815 ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
816 ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
817 ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
818 ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
819 ,p_attribute1 IN per_all_people_f.attribute1%TYPE
820 ,p_attribute2 IN per_all_people_f.attribute2%TYPE
821 ,p_attribute3 IN per_all_people_f.attribute3%TYPE
822 ,p_attribute4 IN per_all_people_f.attribute4%TYPE
823 ,p_attribute5 IN per_all_people_f.attribute5%TYPE
824 ,p_attribute6 IN per_all_people_f.attribute6%TYPE
825 ,p_attribute7 IN per_all_people_f.attribute7%TYPE
826 ,p_attribute8 IN per_all_people_f.attribute8%TYPE
827 ,p_attribute9 IN per_all_people_f.attribute9%TYPE
828 ,p_attribute10 IN per_all_people_f.attribute10%TYPE
829 ,p_attribute11 IN per_all_people_f.attribute11%TYPE
830 ,p_attribute12 IN per_all_people_f.attribute12%TYPE
831 ,p_attribute13 IN per_all_people_f.attribute13%TYPE
832 ,p_attribute14 IN per_all_people_f.attribute14%TYPE
833 ,p_attribute15 IN per_all_people_f.attribute15%TYPE
834 ,p_attribute16 IN per_all_people_f.attribute16%TYPE
835 ,p_attribute17 IN per_all_people_f.attribute17%TYPE
836 ,p_attribute18 IN per_all_people_f.attribute18%TYPE
837 ,p_attribute19 IN per_all_people_f.attribute19%TYPE
838 ,p_attribute20 IN per_all_people_f.attribute20%TYPE
839 ,p_attribute21 IN per_all_people_f.attribute21%TYPE
840 ,p_attribute22 IN per_all_people_f.attribute22%TYPE
841 ,p_attribute23 IN per_all_people_f.attribute23%TYPE
842 ,p_attribute24 IN per_all_people_f.attribute24%TYPE
843 ,p_attribute25 IN per_all_people_f.attribute25%TYPE
844 ,p_attribute26 IN per_all_people_f.attribute26%TYPE
845 ,p_attribute27 IN per_all_people_f.attribute27%TYPE
846 ,p_attribute28 IN per_all_people_f.attribute28%TYPE
847 ,p_attribute29 IN per_all_people_f.attribute29%TYPE
848 ,p_attribute30 IN per_all_people_f.attribute30%TYPE
849 ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
850 ,p_per_information1 IN per_all_people_f.attribute1%TYPE
851 ,p_per_information2 IN per_all_people_f.attribute2%TYPE
852 ,p_per_information3 IN per_all_people_f.attribute3%TYPE
853 ,p_per_information4 IN per_all_people_f.attribute4%TYPE
854 ,p_per_information5 IN per_all_people_f.attribute5%TYPE
855 ,p_per_information6 IN per_all_people_f.attribute6%TYPE
856 ,p_per_information7 IN per_all_people_f.attribute7%TYPE
857 ,p_per_information8 IN per_all_people_f.attribute8%TYPE
858 ,p_per_information9 IN per_all_people_f.attribute9%TYPE
859 ,p_per_information10 IN per_all_people_f.attribute10%TYPE
860 ,p_per_information11 IN per_all_people_f.attribute11%TYPE
861 ,p_per_information12 IN per_all_people_f.attribute12%TYPE
862 ,p_per_information13 IN per_all_people_f.attribute13%TYPE
863 ,p_per_information14 IN per_all_people_f.attribute14%TYPE
864 ,p_per_information15 IN per_all_people_f.attribute15%TYPE
865 ,p_per_information16 IN per_all_people_f.attribute16%TYPE
866 ,p_per_information17 IN per_all_people_f.attribute17%TYPE
867 ,p_per_information18 IN per_all_people_f.attribute18%TYPE
868 ,p_per_information19 IN per_all_people_f.attribute19%TYPE
869 ,p_per_information20 IN per_all_people_f.attribute20%TYPE
870 ,p_per_information21 IN per_all_people_f.attribute21%TYPE
871 ,p_per_information22 IN per_all_people_f.attribute22%TYPE
872 ,p_per_information23 IN per_all_people_f.attribute23%TYPE
873 ,p_per_information24 IN per_all_people_f.attribute24%TYPE
874 ,p_per_information25 IN per_all_people_f.attribute25%TYPE
875 ,p_per_information26 IN per_all_people_f.attribute26%TYPE
876 ,p_per_information27 IN per_all_people_f.attribute27%TYPE
877 ,p_per_information28 IN per_all_people_f.attribute28%TYPE
878 ,p_per_information29 IN per_all_people_f.attribute29%TYPE
879 ,p_per_information30 IN per_all_people_f.attribute30%TYPE
880 ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
881 ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
882 ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
883 ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
884 ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
885 ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
886 ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
887 ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
888 ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
889 ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
890 ,p_asg_validation_start_date OUT NOCOPY DATE
891 ,p_asg_validation_end_date OUT NOCOPY DATE
892 ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
893 ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
894 ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
895 ,p_position_id IN per_all_assignments_f.position_id%TYPE
896 ,p_job_id IN per_all_assignments_f.job_id%TYPE
897 ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
898 ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
899 ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
900 ,p_location_id IN per_all_assignments_f.location_id%TYPE
901 ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
902 ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
903 ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
904 ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
905 ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
906 ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
907 ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
908 ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
909 ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
910 ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE
911 ,p_pgp_segment5 IN pay_people_groups.segment5%TYPE
912 ,p_pgp_segment6 IN pay_people_groups.segment6%TYPE
913 ,p_pgp_segment7 IN pay_people_groups.segment7%TYPE
914 ,p_pgp_segment8 IN pay_people_groups.segment8%TYPE
915 ,p_pgp_segment9 IN pay_people_groups.segment9%TYPE
916 ,p_pgp_segment10 IN pay_people_groups.segment10%TYPE
917 ,p_pgp_segment11 IN pay_people_groups.segment11%TYPE
918 ,p_pgp_segment12 IN pay_people_groups.segment12%TYPE
919 ,p_pgp_segment13 IN pay_people_groups.segment13%TYPE
920 ,p_pgp_segment14 IN pay_people_groups.segment14%TYPE
921 ,p_pgp_segment15 IN pay_people_groups.segment15%TYPE
922 ,p_pgp_segment16 IN pay_people_groups.segment16%TYPE
923 ,p_pgp_segment17 IN pay_people_groups.segment17%TYPE
924 ,p_pgp_segment18 IN pay_people_groups.segment18%TYPE
925 ,p_pgp_segment19 IN pay_people_groups.segment19%TYPE
926 ,p_pgp_segment20 IN pay_people_groups.segment20%TYPE
927 ,p_pgp_segment21 IN pay_people_groups.segment21%TYPE
928 ,p_pgp_segment22 IN pay_people_groups.segment22%TYPE
929 ,p_pgp_segment23 IN pay_people_groups.segment23%TYPE
930 ,p_pgp_segment24 IN pay_people_groups.segment24%TYPE
931 ,p_pgp_segment25 IN pay_people_groups.segment25%TYPE
932 ,p_pgp_segment26 IN pay_people_groups.segment26%TYPE
933 ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
934 ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
935 ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
936 ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
937 ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
938 ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
939 ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
940 ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
941 ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE
942 ,p_scl_segment5 IN hr_soft_coding_keyflex.segment5%TYPE
943 ,p_scl_segment6 IN hr_soft_coding_keyflex.segment6%TYPE
944 ,p_scl_segment7 IN hr_soft_coding_keyflex.segment7%TYPE
945 ,p_scl_segment8 IN hr_soft_coding_keyflex.segment8%TYPE
946 ,p_scl_segment9 IN hr_soft_coding_keyflex.segment9%TYPE
947 ,p_scl_segment10 IN hr_soft_coding_keyflex.segment10%TYPE
948 ,p_scl_segment11 IN hr_soft_coding_keyflex.segment11%TYPE
949 ,p_scl_segment12 IN hr_soft_coding_keyflex.segment12%TYPE
950 ,p_scl_segment13 IN hr_soft_coding_keyflex.segment13%TYPE
951 ,p_scl_segment14 IN hr_soft_coding_keyflex.segment14%TYPE
952 ,p_scl_segment15 IN hr_soft_coding_keyflex.segment15%TYPE
953 ,p_scl_segment16 IN hr_soft_coding_keyflex.segment16%TYPE
954 ,p_scl_segment17 IN hr_soft_coding_keyflex.segment17%TYPE
955 ,p_scl_segment18 IN hr_soft_coding_keyflex.segment18%TYPE
956 ,p_scl_segment19 IN hr_soft_coding_keyflex.segment19%TYPE
957 ,p_scl_segment20 IN hr_soft_coding_keyflex.segment20%TYPE
958 ,p_scl_segment21 IN hr_soft_coding_keyflex.segment21%TYPE
959 ,p_scl_segment22 IN hr_soft_coding_keyflex.segment22%TYPE
960 ,p_scl_segment23 IN hr_soft_coding_keyflex.segment23%TYPE
961 ,p_scl_segment24 IN hr_soft_coding_keyflex.segment24%TYPE
962 ,p_scl_segment25 IN hr_soft_coding_keyflex.segment25%TYPE
963 ,p_scl_segment26 IN hr_soft_coding_keyflex.segment26%TYPE
964 ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
965 ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
966 ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
967 ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
968 ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
969 ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
970 ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
971 ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
972 ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
973 ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
974 ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
975 ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
976 ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
977 ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
978 ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
979 ,p_frequency IN per_all_assignments_f.frequency%TYPE
980 ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
981 ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
982 ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
983 ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
984 ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
985 ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
986 --
987 ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
988 ,p_billing_title IN per_all_assignments_f.title%type
989 --
990 ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
991 ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
992 ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
993 ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
994 ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
995 ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
996 ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
997 ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
998 ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
999 ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
1000 ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
1001 ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
1002 ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
1003 ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
1004 ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
1005 ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
1006 ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1007 ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1008 ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1009 ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1010 ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1011 ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1012 ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1013 ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1014 ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1015 ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1016 ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1017 ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1018 ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1019 ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1020 ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1021 ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1022 ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1023 ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1024 ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1025 ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1026 ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1027 ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1028 ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1029 ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1030 ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1031 ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1032 ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1033 ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1034 ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1035 ,p_source_type IN per_all_assignments_f.source_type%TYPE
1036 ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1037 ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1038 ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1039 ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
1040 ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
1041 --Bug 3063591 Start Here
1042 ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
1043 --Bug 3063591 End Here
1044 ,p_application_id IN per_applications.application_id%TYPE
1045 ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1046 ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE
1047 ,p_appl_attribute1 IN per_applications.appl_attribute1%TYPE
1048 ,p_appl_attribute2 IN per_applications.appl_attribute2%TYPE
1049 ,p_appl_attribute3 IN per_applications.appl_attribute3%TYPE
1050 ,p_appl_attribute4 IN per_applications.appl_attribute4%TYPE
1051 ,p_appl_attribute5 IN per_applications.appl_attribute5%TYPE
1052 ,p_appl_attribute6 IN per_applications.appl_attribute6%TYPE
1053 ,p_appl_attribute7 IN per_applications.appl_attribute7%TYPE
1054 ,p_appl_attribute8 IN per_applications.appl_attribute8%TYPE
1055 ,p_appl_attribute9 IN per_applications.appl_attribute9%TYPE
1056 ,p_appl_attribute10 IN per_applications.appl_attribute10%TYPE
1057 ,p_appl_attribute11 IN per_applications.appl_attribute11%TYPE
1058 ,p_appl_attribute12 IN per_applications.appl_attribute12%TYPE
1059 ,p_appl_attribute13 IN per_applications.appl_attribute13%TYPE
1060 ,p_appl_attribute14 IN per_applications.appl_attribute14%TYPE
1061 ,p_appl_attribute15 IN per_applications.appl_attribute15%TYPE
1062 ,p_appl_attribute16 IN per_applications.appl_attribute16%TYPE
1063 ,p_appl_attribute17 IN per_applications.appl_attribute17%TYPE
1064 ,p_appl_attribute18 IN per_applications.appl_attribute18%TYPE
1065 ,p_appl_attribute19 IN per_applications.appl_attribute19%TYPE
1066 ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1067 ,p_current_employer IN per_applications.current_employer%TYPE
1068 ,p_termination_reason IN per_applications.termination_reason%TYPE
1069 ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1070 ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1071 ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
1072 ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
1073 ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
1074 ,p_adr_date_from IN per_addresses.date_from%TYPE
1075 ,p_style IN per_addresses.style%TYPE
1076 ,p_address_line1 IN per_addresses.address_line1%TYPE
1077 ,p_address_line2 IN per_addresses.address_line2%TYPE
1078 ,p_address_line3 IN per_addresses.address_line3%TYPE
1079 ,p_address_type IN per_addresses.address_type%TYPE
1080 ,p_country IN per_addresses.country%TYPE
1081 ,p_adr_date_to IN per_addresses.date_to%TYPE
1082 ,p_postal_code IN per_addresses.postal_code%TYPE
1083 ,p_region_1 IN per_addresses.region_1%TYPE
1084 ,p_region_2 IN per_addresses.region_2%TYPE
1085 ,p_region_3 IN per_addresses.region_3%TYPE
1086 ,p_town_or_city IN per_addresses.town_or_city%TYPE
1087 ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
1088 ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
1089 ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
1090 ,p_add_information13 IN per_addresses.add_information13%TYPE
1091 ,p_add_information14 IN per_addresses.add_information14%TYPE
1092 ,p_add_information15 IN per_addresses.add_information15%TYPE
1093 ,p_add_information16 IN per_addresses.add_information16%TYPE
1094 ,p_add_information17 IN per_addresses.add_information17%TYPE
1095 ,p_add_information18 IN per_addresses.add_information18%TYPE
1096 ,p_add_information19 IN per_addresses.add_information19%TYPE
1097 ,p_add_information20 IN per_addresses.add_information20%TYPE
1098 ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
1099 ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
1100 ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
1101 ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
1102 ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
1103 ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
1104 ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
1105 ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
1106 ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
1107 ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
1108 ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
1109 ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
1110 ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
1111 ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
1112 ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
1113 ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
1114 ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
1115 ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
1116 ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
1117 ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
1118 ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
1119 ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
1120 ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1121 ,p_phn_h_date_from IN per_phones.date_from%TYPE
1122 ,p_phn_h_date_to IN per_phones.date_to%TYPE
1123 ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
1124 ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1125 ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1126 ,p_phn_w_date_from IN per_phones.date_from%TYPE
1127 ,p_phn_w_date_to IN per_phones.date_to%TYPE
1128 ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
1129 ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1130 ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1131 ,p_phn_m_date_from IN per_phones.date_from%TYPE
1132 ,p_phn_m_date_to IN per_phones.date_to%TYPE
1133 ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
1134 ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1135 ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1136 ,p_phn_hf_date_from IN per_phones.date_from%TYPE
1137 ,p_phn_hf_date_to IN per_phones.date_to%TYPE
1138 ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
1139 ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1140 ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1141 ,p_phn_wf_date_from IN per_phones.date_from%TYPE
1142 ,p_phn_wf_date_to IN per_phones.date_to%TYPE
1143 ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
1144 ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
1145 ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
1146 ,p_change_date IN per_pay_proposals.change_date%TYPE
1147 ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
1148 ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE
1149 ,p_pyp_attribute_category IN per_pay_proposals.attribute_category%TYPE
1150 ,p_pyp_attribute1 IN per_pay_proposals.attribute1%TYPE
1151 ,p_pyp_attribute2 IN per_pay_proposals.attribute2%TYPE
1152 ,p_pyp_attribute3 IN per_pay_proposals.attribute3%TYPE
1153 ,p_pyp_attribute4 IN per_pay_proposals.attribute4%TYPE
1154 ,p_pyp_attribute5 IN per_pay_proposals.attribute5%TYPE
1155 ,p_pyp_attribute6 IN per_pay_proposals.attribute6%TYPE
1156 ,p_pyp_attribute7 IN per_pay_proposals.attribute7%TYPE
1157 ,p_pyp_attribute8 IN per_pay_proposals.attribute8%TYPE
1158 ,p_pyp_attribute9 IN per_pay_proposals.attribute9%TYPE
1159 ,p_pyp_attribute10 IN per_pay_proposals.attribute10%TYPE
1160 ,p_pyp_attribute11 IN per_pay_proposals.attribute11%TYPE
1161 ,p_pyp_attribute12 IN per_pay_proposals.attribute12%TYPE
1162 ,p_pyp_attribute13 IN per_pay_proposals.attribute13%TYPE
1163 ,p_pyp_attribute14 IN per_pay_proposals.attribute14%TYPE
1164 ,p_pyp_attribute15 IN per_pay_proposals.attribute15%TYPE
1165 ,p_pyp_attribute16 IN per_pay_proposals.attribute16%TYPE
1166 ,p_pyp_attribute17 IN per_pay_proposals.attribute17%TYPE
1167 ,p_pyp_attribute18 IN per_pay_proposals.attribute18%TYPE
1168 ,p_pyp_attribute19 IN per_pay_proposals.attribute19%TYPE
1169 ,p_pyp_attribute20 IN per_pay_proposals.attribute20%TYPE
1170 ,p_pyp_object_version_number IN OUT NOCOPY per_pay_proposals.object_version_number%TYPE
1171 ,p_approved IN per_pay_proposals.approved%TYPE
1172 ,p_deployment_factor_id IN OUT NOCOPY per_deployment_factors.deployment_factor_id%TYPE
1173 ,p_work_any_country IN per_deployment_factors.work_any_country%TYPE
1174 ,p_work_any_location IN per_deployment_factors.work_any_location%TYPE
1175 ,p_relocate_domestically IN per_deployment_factors.relocate_domestically%TYPE
1176 ,p_relocate_internationally IN per_deployment_factors.relocate_internationally%TYPE
1177 ,p_travel_required IN per_deployment_factors.travel_required%TYPE
1178 ,p_country1 IN per_deployment_factors.country1%TYPE
1179 ,p_country2 IN per_deployment_factors.country2%TYPE
1180 ,p_country3 IN per_deployment_factors.country3%TYPE
1181 ,p_dpf_work_duration IN per_deployment_factors.work_duration%TYPE
1182 ,p_dpf_work_schedule IN per_deployment_factors.work_schedule%TYPE
1183 ,p_dpf_work_hours IN per_deployment_factors.work_hours%TYPE
1184 ,p_dpf_fte_capacity IN per_deployment_factors.fte_capacity%TYPE
1185 ,p_visit_internationally IN per_deployment_factors.visit_internationally%TYPE
1186 ,p_only_current_location IN per_deployment_factors.only_current_location%TYPE
1187 ,p_no_country1 IN per_deployment_factors.no_country1%TYPE
1188 ,p_no_country2 IN per_deployment_factors.no_country2%TYPE
1189 ,p_no_country3 IN per_deployment_factors.no_country3%TYPE
1190 ,p_earliest_available_date IN per_deployment_factors.earliest_available_date%TYPE
1191 ,p_available_for_transfer IN per_deployment_factors.available_for_transfer%TYPE
1192 ,p_relocation_preference IN per_deployment_factors.relocation_preference%TYPE
1193 ,p_dpf_object_version_number IN OUT NOCOPY per_deployment_factors.object_version_number%TYPE
1194 ,p_dpf_attribute_category IN per_deployment_factors.attribute_category%TYPE
1195 ,p_dpf_attribute1 IN per_deployment_factors.attribute1%TYPE
1196 ,p_dpf_attribute2 IN per_deployment_factors.attribute2%TYPE
1197 ,p_dpf_attribute3 IN per_deployment_factors.attribute3%TYPE
1198 ,p_dpf_attribute4 IN per_deployment_factors.attribute4%TYPE
1199 ,p_dpf_attribute5 IN per_deployment_factors.attribute5%TYPE
1200 ,p_dpf_attribute6 IN per_deployment_factors.attribute6%TYPE
1201 ,p_dpf_attribute7 IN per_deployment_factors.attribute7%TYPE
1202 ,p_dpf_attribute8 IN per_deployment_factors.attribute8%TYPE
1203 ,p_dpf_attribute9 IN per_deployment_factors.attribute9%TYPE
1204 ,p_dpf_attribute10 IN per_deployment_factors.attribute10%TYPE
1205 ,p_dpf_attribute11 IN per_deployment_factors.attribute11%TYPE
1206 ,p_dpf_attribute12 IN per_deployment_factors.attribute12%TYPE
1207 ,p_dpf_attribute13 IN per_deployment_factors.attribute13%TYPE
1208 ,p_dpf_attribute14 IN per_deployment_factors.attribute14%TYPE
1209 ,p_dpf_attribute15 IN per_deployment_factors.attribute15%TYPE
1210 ,p_dpf_attribute16 IN per_deployment_factors.attribute16%TYPE
1211 ,p_dpf_attribute17 IN per_deployment_factors.attribute17%TYPE
1212 ,p_dpf_attribute18 IN per_deployment_factors.attribute18%TYPE
1213 ,p_dpf_attribute19 IN per_deployment_factors.attribute19%TYPE
1214 ,p_dpf_attribute20 IN per_deployment_factors.attribute20%TYPE
1215 ,p_chk1_checklist_item_id IN OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
1216 ,p_chk1_item_code IN per_checklist_items.item_code%TYPE
1217 ,p_chk1_date_due IN per_checklist_items.date_due%TYPE
1218 ,p_chk1_date_done IN per_checklist_items.date_done%TYPE
1219 ,p_chk1_status IN per_checklist_items.status%TYPE
1220 ,p_chk1_notes IN per_checklist_items.notes%TYPE
1221 ,p_chk1_object_version_number IN OUT NOCOPY per_checklist_items.object_version_number%TYPE
1222 ,p_chk2_checklist_item_id IN OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
1223 ,p_chk2_item_code IN per_checklist_items.item_code%TYPE
1224 ,p_chk2_date_due IN per_checklist_items.date_due%TYPE
1225 ,p_chk2_date_done IN per_checklist_items.date_done%TYPE
1226 ,p_chk2_status IN per_checklist_items.status%TYPE
1227 ,p_chk2_notes IN per_checklist_items.notes%TYPE
1228 ,p_chk2_object_version_number IN OUT NOCOPY per_checklist_items.object_version_number%TYPE
1229 ,p_chk3_checklist_item_id IN OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
1230 ,p_chk3_item_code IN per_checklist_items.item_code%TYPE
1231 ,p_chk3_date_due IN per_checklist_items.date_due%TYPE
1232 ,p_chk3_date_done IN per_checklist_items.date_done%TYPE
1233 ,p_chk3_status IN per_checklist_items.status%TYPE
1234 ,p_chk3_notes IN per_checklist_items.notes%TYPE
1235 ,p_chk3_object_version_number IN OUT NOCOPY per_checklist_items.object_version_number%TYPE
1236 ,p_chk4_checklist_item_id IN OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
1237 ,p_chk4_item_code IN per_checklist_items.item_code%TYPE
1238 ,p_chk4_date_due IN per_checklist_items.date_due%TYPE
1239 ,p_chk4_date_done IN per_checklist_items.date_done%TYPE
1240 ,p_chk4_status IN per_checklist_items.status%TYPE
1241 ,p_chk4_notes IN per_checklist_items.notes%TYPE
1242 ,p_chk4_object_version_number IN OUT NOCOPY per_checklist_items.object_version_number%TYPE
1243 ,p_chk5_checklist_item_id IN OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
1244 ,p_chk5_item_code IN per_checklist_items.item_code%TYPE
1245 ,p_chk5_date_due IN per_checklist_items.date_due%TYPE
1246 ,p_chk5_date_done IN per_checklist_items.date_done%TYPE
1247 ,p_chk5_status IN per_checklist_items.status%TYPE
1248 ,p_chk5_notes IN per_checklist_items.notes%TYPE
1249 ,p_chk5_object_version_number IN OUT NOCOPY per_checklist_items.object_version_number%TYPE
1250 ,p_chk6_checklist_item_id IN OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
1251 ,p_chk6_item_code IN per_checklist_items.item_code%TYPE
1252 ,p_chk6_date_due IN per_checklist_items.date_due%TYPE
1253 ,p_chk6_date_done IN per_checklist_items.date_done%TYPE
1254 ,p_chk6_status IN per_checklist_items.status%TYPE
1255 ,p_chk6_notes IN per_checklist_items.notes%TYPE
1256 ,p_chk6_object_version_number IN OUT NOCOPY per_checklist_items.object_version_number%TYPE
1257 ,p_chk7_checklist_item_id IN OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
1258 ,p_chk7_item_code IN per_checklist_items.item_code%TYPE
1259 ,p_chk7_date_due IN per_checklist_items.date_due%TYPE
1260 ,p_chk7_date_done IN per_checklist_items.date_done%TYPE
1261 ,p_chk7_status IN per_checklist_items.status%TYPE
1262 ,p_chk7_notes IN per_checklist_items.notes%TYPE
1263 ,p_chk7_object_version_number IN OUT NOCOPY per_checklist_items.object_version_number%TYPE
1264 ,p_chk8_checklist_item_id IN OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
1265 ,p_chk8_item_code IN per_checklist_items.item_code%TYPE
1266 ,p_chk8_date_due IN per_checklist_items.date_due%TYPE
1267 ,p_chk8_date_done IN per_checklist_items.date_done%TYPE
1268 ,p_chk8_status IN per_checklist_items.status%TYPE
1269 ,p_chk8_notes IN per_checklist_items.notes%TYPE
1270 ,p_chk8_object_version_number IN OUT NOCOPY per_checklist_items.object_version_number%TYPE
1271 ,p_chk9_checklist_item_id IN OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
1272 ,p_chk9_item_code IN per_checklist_items.item_code%TYPE
1273 ,p_chk9_date_due IN per_checklist_items.date_due%TYPE
1274 ,p_chk9_date_done IN per_checklist_items.date_done%TYPE
1275 ,p_chk9_status IN per_checklist_items.status%TYPE
1276 ,p_chk9_notes IN per_checklist_items.notes%TYPE
1277 ,p_chk9_object_version_number IN OUT NOCOPY per_checklist_items.object_version_number%TYPE
1278 ,p_chk10_checklist_item_id IN OUT NOCOPY per_checklist_items.checklist_item_id%TYPE
1279 ,p_chk10_item_code IN per_checklist_items.item_code%TYPE
1280 ,p_chk10_date_due IN per_checklist_items.date_due%TYPE
1281 ,p_chk10_date_done IN per_checklist_items.date_done%TYPE
1282 ,p_chk10_status IN per_checklist_items.status%TYPE
1283 ,p_chk10_notes IN per_checklist_items.notes%TYPE
1284 ,p_chk10_object_version_number IN OUT NOCOPY per_checklist_items.object_version_number%TYPE
1285 ,p_tax_effective_start_date IN OUT NOCOPY DATE
1286 ,p_tax_effective_end_date IN OUT NOCOPY DATE
1287 ,p_tax_field1 IN OUT NOCOPY VARCHAR2
1288 ,p_tax_field2 IN OUT NOCOPY VARCHAR2
1289 ,p_tax_field3 IN OUT NOCOPY VARCHAR2
1290 ,p_tax_field4 IN OUT NOCOPY VARCHAR2
1291 ,p_tax_field5 IN OUT NOCOPY VARCHAR2
1292 ,p_tax_field6 IN OUT NOCOPY VARCHAR2
1293 ,p_tax_field7 IN OUT NOCOPY VARCHAR2
1294 ,p_tax_field8 IN OUT NOCOPY VARCHAR2
1295 ,p_tax_field9 IN OUT NOCOPY VARCHAR2
1296 ,p_tax_field10 IN OUT NOCOPY VARCHAR2
1297 ,p_tax_field11 IN OUT NOCOPY VARCHAR2
1298 ,p_tax_field12 IN OUT NOCOPY VARCHAR2
1299 ,p_tax_field13 IN OUT NOCOPY VARCHAR2
1300 ,p_tax_field14 IN OUT NOCOPY VARCHAR2
1301 ,p_tax_field15 IN OUT NOCOPY VARCHAR2
1302 ,p_tax_field16 IN OUT NOCOPY VARCHAR2
1303 ,p_tax_field17 IN OUT NOCOPY VARCHAR2
1304 ,p_tax_field18 IN OUT NOCOPY VARCHAR2
1305 ,p_tax_field19 IN OUT NOCOPY VARCHAR2
1306 ,p_tax_field20 IN OUT NOCOPY VARCHAR2
1307 ,p_tax_field21 IN OUT NOCOPY VARCHAR2
1308 ,p_tax_field22 IN OUT NOCOPY VARCHAR2
1309 ,p_tax_field23 IN OUT NOCOPY VARCHAR2
1310 ,p_tax_field24 IN OUT NOCOPY VARCHAR2
1311 ,p_tax_field25 IN OUT NOCOPY VARCHAR2
1312 ,p_tax_field26 IN OUT NOCOPY VARCHAR2
1313 ,p_tax_field27 IN OUT NOCOPY VARCHAR2
1314 ,p_tax_field28 IN OUT NOCOPY VARCHAR2
1315 ,p_tax_field29 IN OUT NOCOPY VARCHAR2
1316 ,p_tax_field30 IN OUT NOCOPY VARCHAR2
1317 ,p_tax_field31 IN OUT NOCOPY VARCHAR2
1318 ,p_tax_field32 IN OUT NOCOPY VARCHAR2
1319 ,p_tax_field33 IN OUT NOCOPY VARCHAR2
1320 ,p_tax_field34 IN OUT NOCOPY VARCHAR2
1321 ,p_tax_field35 IN OUT NOCOPY VARCHAR2
1322 ,p_tax_field36 IN OUT NOCOPY VARCHAR2
1323 ,p_tax_field37 IN OUT NOCOPY VARCHAR2
1324 ,p_tax_field38 IN OUT NOCOPY VARCHAR2
1325 ,p_tax_field39 IN OUT NOCOPY VARCHAR2
1326 ,p_tax_field40 IN OUT NOCOPY VARCHAR2
1327 ,p_tax_field41 IN OUT NOCOPY VARCHAR2
1328 ,p_tax_field42 IN OUT NOCOPY VARCHAR2
1329 ,p_tax_field43 IN OUT NOCOPY VARCHAR2
1330 ,p_tax_field44 IN OUT NOCOPY VARCHAR2
1331 ,p_tax_field45 IN OUT NOCOPY VARCHAR2
1332 ,p_tax_field46 IN OUT NOCOPY VARCHAR2
1333 ,p_tax_field47 IN OUT NOCOPY VARCHAR2
1334 ,p_tax_field48 IN OUT NOCOPY VARCHAR2
1335 ,p_tax_field49 IN OUT NOCOPY VARCHAR2
1336 ,p_tax_field50 IN OUT NOCOPY VARCHAR2
1337 ,p_tax_field51 IN OUT NOCOPY VARCHAR2
1338 ,p_tax_field52 IN OUT NOCOPY VARCHAR2
1339 ,p_tax_field53 IN OUT NOCOPY VARCHAR2
1340 ,p_tax_field54 IN OUT NOCOPY VARCHAR2
1341 ,p_tax_field55 IN OUT NOCOPY VARCHAR2
1342 ,p_tax_field56 IN OUT NOCOPY VARCHAR2
1343 ,p_tax_field57 IN OUT NOCOPY VARCHAR2
1344 ,p_tax_field58 IN OUT NOCOPY VARCHAR2
1345 ,p_tax_field59 IN OUT NOCOPY VARCHAR2
1346 ,p_tax_field60 IN OUT NOCOPY VARCHAR2
1347 ,p_tax_field61 IN OUT NOCOPY VARCHAR2
1348 ,p_tax_field62 IN OUT NOCOPY VARCHAR2
1349 ,p_tax_field63 IN OUT NOCOPY VARCHAR2
1350 ,p_tax_field64 IN OUT NOCOPY VARCHAR2
1351 ,p_tax_field65 IN OUT NOCOPY VARCHAR2
1352 ,p_tax_field66 IN OUT NOCOPY VARCHAR2
1353 ,p_tax_field67 IN OUT NOCOPY VARCHAR2
1354 ,p_tax_field68 IN OUT NOCOPY VARCHAR2
1355 ,p_tax_field69 IN OUT NOCOPY VARCHAR2
1356 ,p_tax_field70 IN OUT NOCOPY VARCHAR2
1357 ,p_tax_field71 IN OUT NOCOPY VARCHAR2
1358 ,p_tax_field72 IN OUT NOCOPY VARCHAR2
1359 ,p_tax_field73 IN OUT NOCOPY VARCHAR2
1360 ,p_tax_field74 IN OUT NOCOPY VARCHAR2
1361 ,p_tax_field75 IN OUT NOCOPY VARCHAR2
1362 ,p_tax_field76 IN OUT NOCOPY VARCHAR2
1363 ,p_tax_field77 IN OUT NOCOPY VARCHAR2
1364 ,p_tax_field78 IN OUT NOCOPY VARCHAR2
1365 ,p_tax_field79 IN OUT NOCOPY VARCHAR2
1366 ,p_tax_field80 IN OUT NOCOPY VARCHAR2
1367 ,p_tax_field81 IN OUT NOCOPY VARCHAR2
1368 ,p_tax_field82 IN OUT NOCOPY VARCHAR2
1369 ,p_tax_field83 IN OUT NOCOPY VARCHAR2
1370 ,p_tax_field84 IN OUT NOCOPY VARCHAR2
1371 ,p_tax_field85 IN OUT NOCOPY VARCHAR2
1372 ,p_tax_field86 IN OUT NOCOPY VARCHAR2
1373 ,p_tax_field87 IN OUT NOCOPY VARCHAR2
1374 ,p_tax_field88 IN OUT NOCOPY VARCHAR2
1375 ,p_tax_field89 IN OUT NOCOPY VARCHAR2
1376 ,p_tax_field90 IN OUT NOCOPY VARCHAR2
1377 ,p_tax_field91 IN OUT NOCOPY VARCHAR2
1378 ,p_tax_field92 IN OUT NOCOPY VARCHAR2
1379 ,p_tax_field93 IN OUT NOCOPY VARCHAR2
1380 ,p_tax_field94 IN OUT NOCOPY VARCHAR2
1381 ,p_tax_field95 IN OUT NOCOPY VARCHAR2
1382 ,p_tax_field96 IN OUT NOCOPY VARCHAR2
1383 ,p_tax_field97 IN OUT NOCOPY VARCHAR2
1384 ,p_tax_field98 IN OUT NOCOPY VARCHAR2
1385 ,p_tax_field99 IN OUT NOCOPY VARCHAR2
1386 ,p_tax_field100 IN OUT NOCOPY VARCHAR2
1387 ,p_tax_field101 IN OUT NOCOPY VARCHAR2
1388 ,p_tax_field102 IN OUT NOCOPY VARCHAR2
1389 ,p_tax_field103 IN OUT NOCOPY VARCHAR2
1390 ,p_tax_field104 IN OUT NOCOPY VARCHAR2
1391 ,p_tax_field105 IN OUT NOCOPY VARCHAR2
1392 ,p_tax_field106 IN OUT NOCOPY VARCHAR2
1393 ,p_tax_field107 IN OUT NOCOPY VARCHAR2
1394 ,p_tax_field108 IN OUT NOCOPY VARCHAR2
1395 ,p_tax_field109 IN OUT NOCOPY VARCHAR2
1396 ,p_tax_field110 IN OUT NOCOPY VARCHAR2
1397 ,p_tax_field111 IN OUT NOCOPY VARCHAR2
1398 ,p_tax_field112 IN OUT NOCOPY VARCHAR2
1399 ,p_tax_field113 IN OUT NOCOPY VARCHAR2
1400 ,p_tax_field114 IN OUT NOCOPY VARCHAR2
1401 ,p_tax_field115 IN OUT NOCOPY VARCHAR2
1402 ,p_tax_field116 IN OUT NOCOPY VARCHAR2
1403 ,p_tax_field117 IN OUT NOCOPY VARCHAR2
1404 ,p_tax_field118 IN OUT NOCOPY VARCHAR2
1405 ,p_tax_field119 IN OUT NOCOPY VARCHAR2
1406 ,p_tax_field120 IN OUT NOCOPY VARCHAR2
1407 ,p_tax_field121 IN OUT NOCOPY VARCHAR2
1408 ,p_tax_field122 IN OUT NOCOPY VARCHAR2
1409 ,p_tax_field123 IN OUT NOCOPY VARCHAR2
1410 ,p_tax_field124 IN OUT NOCOPY VARCHAR2
1411 ,p_tax_field125 IN OUT NOCOPY VARCHAR2
1412 ,p_tax_field126 IN OUT NOCOPY VARCHAR2
1413 ,p_tax_field127 IN OUT NOCOPY VARCHAR2
1414 ,p_tax_field128 IN OUT NOCOPY VARCHAR2
1415 ,p_tax_field129 IN OUT NOCOPY VARCHAR2
1416 ,p_tax_field130 IN OUT NOCOPY VARCHAR2
1417 ,p_tax_field131 IN OUT NOCOPY VARCHAR2
1418 ,p_tax_field132 IN OUT NOCOPY VARCHAR2
1419 ,p_tax_field133 IN OUT NOCOPY VARCHAR2
1420 ,p_tax_field134 IN OUT NOCOPY VARCHAR2
1421 ,p_tax_field135 IN OUT NOCOPY VARCHAR2
1422 ,p_tax_field136 IN OUT NOCOPY VARCHAR2
1423 ,p_tax_field137 IN OUT NOCOPY VARCHAR2
1424 ,p_tax_field138 IN OUT NOCOPY VARCHAR2
1425 ,p_tax_field139 IN OUT NOCOPY VARCHAR2
1426 ,p_tax_field140 IN OUT NOCOPY VARCHAR2
1427 -- Bug 3357807 Start Here
1428 ,p_tax_field141 IN OUT NOCOPY DATE
1429 ,p_tax_field142 IN OUT NOCOPY DATE
1430 ,p_tax_field143 IN OUT NOCOPY DATE
1431 ,p_tax_field144 IN OUT NOCOPY DATE
1432 ,p_tax_field145 IN OUT NOCOPY DATE
1433 ,p_tax_field146 IN OUT NOCOPY DATE
1434 ,p_tax_field147 IN OUT NOCOPY DATE
1435 ,p_tax_field148 IN OUT NOCOPY DATE
1436 ,p_tax_field149 IN OUT NOCOPY DATE
1437 ,p_tax_field150 IN OUT NOCOPY DATE
1438 -- Bug 3357807 End Here
1439 ,p_tax_update_allowed IN OUT NOCOPY VARCHAR2
1440 ,p_orig_hire_warning OUT NOCOPY BOOLEAN
1441 ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
1442 ,p_org_now_no_manager_warning OUT NOCOPY BOOLEAN
1443 ,p_other_manager_warning OUT NOCOPY BOOLEAN
1444 ,p_spp_delete_warning OUT NOCOPY BOOLEAN
1445 ,p_entries_changed_warning OUT NOCOPY VARCHAR2
1446 ,p_tax_district_changed_warning OUT NOCOPY BOOLEAN
1447 ,p_proposed_salary_warning OUT NOCOPY BOOLEAN
1448 ,p_approved_warning OUT NOCOPY BOOLEAN
1449 ,p_payroll_warning OUT NOCOPY BOOLEAN
1450 ,p_gsp_post_process_warning OUT NOCOPY VARCHAR2
1451 );
1452 --
1453 PROCEDURE lock_maintain_data
1454 (p_effective_date DATE
1455 ,p_datetrack_update_mode VARCHAR2
1456 ,p_person_update_allowed VARCHAR2 DEFAULT 'TRUE'
1457 ,p_person_id per_all_people_f.person_id%TYPE
1458 ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
1459 ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
1460 ,p_per_validation_start_date OUT NOCOPY DATE
1461 ,p_per_validation_end_date OUT NOCOPY DATE
1462 ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
1463 --CWK
1464 ,p_placement_date_start per_periods_of_placement.date_start%TYPE
1465 ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
1466 ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
1467 ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
1468 ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
1469 ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
1470 --
1471 ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
1472 ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
1473 ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
1474 ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
1475 ,p_asg_validation_start_date OUT NOCOPY DATE
1476 ,p_asg_validation_end_date OUT NOCOPY DATE
1477 ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
1478 ,p_application_id per_applications.application_id%TYPE
1479 ,p_app_object_version_number per_applications.object_version_number%TYPE
1480 ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
1481 ,p_pds_hire_date per_periods_of_service.date_start%TYPE
1482 ,p_address_id per_addresses.address_id%TYPE
1483 ,p_addr_object_version_number per_addresses.object_version_number%TYPE
1484 ,p_phn_h_phone_id per_phones.phone_id%TYPE
1485 ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
1486 ,p_phn_w_phone_id per_phones.phone_id%TYPE
1487 ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
1488 ,p_phn_m_phone_id per_phones.phone_id%TYPE
1489 ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
1490 ,p_phn_hf_phone_id per_phones.phone_id%TYPE
1491 ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
1492 ,p_phn_wf_phone_id per_phones.phone_id%TYPE
1493 ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE
1494 ,p_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE
1495 ,p_pyp_object_version_number per_pay_proposals.object_version_number%TYPE
1496 ,p_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE
1497 ,p_dpf_object_version_number per_deployment_factors.object_version_number%TYPE
1498 ,p_chk1_checklist_item_id per_checklist_items.checklist_item_id%TYPE
1499 ,p_chk1_object_version_number per_checklist_items.object_version_number%TYPE
1500 ,p_chk2_checklist_item_id per_checklist_items.checklist_item_id%TYPE
1501 ,p_chk2_object_version_number per_checklist_items.object_version_number%TYPE
1502 ,p_chk3_checklist_item_id per_checklist_items.checklist_item_id%TYPE
1503 ,p_chk3_object_version_number per_checklist_items.object_version_number%TYPE
1504 ,p_chk4_checklist_item_id per_checklist_items.checklist_item_id%TYPE
1505 ,p_chk4_object_version_number per_checklist_items.object_version_number%TYPE
1506 ,p_chk5_checklist_item_id per_checklist_items.checklist_item_id%TYPE
1507 ,p_chk5_object_version_number per_checklist_items.object_version_number%TYPE
1508 ,p_chk6_checklist_item_id per_checklist_items.checklist_item_id%TYPE
1509 ,p_chk6_object_version_number per_checklist_items.object_version_number%TYPE
1510 ,p_chk7_checklist_item_id per_checklist_items.checklist_item_id%TYPE
1511 ,p_chk7_object_version_number per_checklist_items.object_version_number%TYPE
1512 ,p_chk8_checklist_item_id per_checklist_items.checklist_item_id%TYPE
1513 ,p_chk8_object_version_number per_checklist_items.object_version_number%TYPE
1514 ,p_chk9_checklist_item_id per_checklist_items.checklist_item_id%TYPE
1515 ,p_chk9_object_version_number per_checklist_items.object_version_number%TYPE
1516 ,p_chk10_checklist_item_id per_checklist_items.checklist_item_id%TYPE
1517 ,p_chk10_object_version_number per_checklist_items.object_version_number%TYPE
1518 );
1519 END;