[Home] [Help]
PACKAGE BODY: APPS.PQH_PTX_UPD
Source
1 Package Body pqh_ptx_upd as
2 /* $Header: pqptxrhi.pkb 120.1 2008/01/31 09:40:13 brsinha noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' pqh_ptx_upd.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< update_dml >------------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This procedure controls the actual dml update logic. The processing of
17 -- this procedure is:
18 -- 1) Increment the object_version_number by 1 if the object_version_number
19 -- is defined as an attribute for this entity.
20 -- 3) To update the specified row in the schema using the primary key in
21 -- the predicates.
22 -- 4) To trap any constraint violations that may have occurred.
23 -- 5) To raise any other errors.
24 --
25 -- Prerequisites:
26 -- This is an internal private procedure which must be called from the upd
27 -- procedure.
28 --
29 -- In Parameters:
30 -- A Pl/Sql record structre.
31 --
32 -- Post Success:
33 -- The specified row will be updated in the schema.
34 --
35 -- Post Failure:
36 -- If a check, unique or parent integrity constraint violation is raised the
37 -- constraint_error procedure will be called.
38 --
39 -- Developer Implementation Notes:
40 -- The update 'set' attribute list should be modified if any of your
41 -- attributes are not updateable.
42 --
43 -- Access Status:
44 -- Internal Row Handler Use Only.
45 --
46 -- {End Of Comments}
47 -- ----------------------------------------------------------------------------
48 Procedure update_dml(p_rec in out nocopy pqh_ptx_shd.g_rec_type) is
49 --
50 l_proc varchar2(72) := g_package||'update_dml';
51 --
52 Begin
53 hr_utility.set_location('Entering:'||l_proc, 5);
54 --
55 -- Increment the object version
56 --
57 p_rec.object_version_number := p_rec.object_version_number + 1;
58 --
59 --
60 -- Update the pqh_position_transactions Row
61 --
62 update pqh_position_transactions
63 set
64 position_transaction_id = p_rec.position_transaction_id,
65 action_date = p_rec.action_date,
66 position_id = p_rec.position_id,
67 availability_status_id = p_rec.availability_status_id,
68 business_group_id = p_rec.business_group_id,
69 entry_step_id = p_rec.entry_step_id,
70 entry_grade_rule_id = p_rec.entry_grade_rule_id,
71 job_id = p_rec.job_id,
72 location_id = p_rec.location_id,
73 organization_id = p_rec.organization_id,
74 pay_freq_payroll_id = p_rec.pay_freq_payroll_id,
75 position_definition_id = p_rec.position_definition_id,
76 prior_position_id = p_rec.prior_position_id,
77 relief_position_id = p_rec.relief_position_id,
78 entry_grade_id = p_rec.entry_grade_id,
79 successor_position_id = p_rec.successor_position_id,
80 supervisor_position_id = p_rec.supervisor_position_id,
81 amendment_date = p_rec.amendment_date,
82 amendment_recommendation = p_rec.amendment_recommendation,
83 amendment_ref_number = p_rec.amendment_ref_number,
84 avail_status_prop_end_date = p_rec.avail_status_prop_end_date,
85 bargaining_unit_cd = p_rec.bargaining_unit_cd,
86 comments = p_rec.comments,
87 country1 = p_rec.country1,
88 country2 = p_rec.country2,
89 country3 = p_rec.country3,
90 current_job_prop_end_date = p_rec.current_job_prop_end_date,
91 current_org_prop_end_date = p_rec.current_org_prop_end_date,
92 date_effective = p_rec.date_effective,
93 date_end = p_rec.date_end,
94 earliest_hire_date = p_rec.earliest_hire_date,
95 fill_by_date = p_rec.fill_by_date,
96 frequency = p_rec.frequency,
97 fte = p_rec.fte,
98 fte_capacity = p_rec.fte_capacity,
99 location1 = p_rec.location1,
100 location2 = p_rec.location2,
101 location3 = p_rec.location3,
102 max_persons = p_rec.max_persons,
103 name = p_rec.name,
104 other_requirements = p_rec.other_requirements,
105 overlap_period = p_rec.overlap_period,
106 overlap_unit_cd = p_rec.overlap_unit_cd,
107 passport_required = p_rec.passport_required,
108 pay_term_end_day_cd = p_rec.pay_term_end_day_cd,
109 pay_term_end_month_cd = p_rec.pay_term_end_month_cd,
110 permanent_temporary_flag = p_rec.permanent_temporary_flag,
111 permit_recruitment_flag = p_rec.permit_recruitment_flag,
112 position_type = p_rec.position_type,
113 posting_description = p_rec.posting_description,
114 probation_period = p_rec.probation_period,
115 probation_period_unit_cd = p_rec.probation_period_unit_cd,
116 relocate_domestically = p_rec.relocate_domestically,
117 relocate_internationally = p_rec.relocate_internationally,
118 replacement_required_flag = p_rec.replacement_required_flag,
119 review_flag = p_rec.review_flag,
120 seasonal_flag = p_rec.seasonal_flag,
121 security_requirements = p_rec.security_requirements,
122 service_minimum = p_rec.service_minimum,
123 term_start_day_cd = p_rec.term_start_day_cd,
124 term_start_month_cd = p_rec.term_start_month_cd,
125 time_normal_finish = p_rec.time_normal_finish,
126 time_normal_start = p_rec.time_normal_start,
127 transaction_status = p_rec.transaction_status,
128 travel_required = p_rec.travel_required,
129 working_hours = p_rec.working_hours,
130 works_council_approval_flag = p_rec.works_council_approval_flag,
131 work_any_country = p_rec.work_any_country,
132 work_any_location = p_rec.work_any_location,
133 work_period_type_cd = p_rec.work_period_type_cd,
134 work_schedule = p_rec.work_schedule,
135 work_duration = p_rec.work_duration,
136 work_term_end_day_cd = p_rec.work_term_end_day_cd,
137 work_term_end_month_cd = p_rec.work_term_end_month_cd,
138 proposed_fte_for_layoff = p_rec.proposed_fte_for_layoff,
139 proposed_date_for_layoff = p_rec.proposed_date_for_layoff,
140 information1 = p_rec.information1,
141 information2 = p_rec.information2,
142 information3 = p_rec.information3,
143 information4 = p_rec.information4,
144 information5 = p_rec.information5,
145 information6 = p_rec.information6,
146 information7 = p_rec.information7,
147 information8 = p_rec.information8,
148 information9 = p_rec.information9,
149 information10 = p_rec.information10,
150 information11 = p_rec.information11,
151 information12 = p_rec.information12,
152 information13 = p_rec.information13,
153 information14 = p_rec.information14,
154 information15 = p_rec.information15,
155 information16 = p_rec.information16,
156 information17 = p_rec.information17,
157 information18 = p_rec.information18,
158 information19 = p_rec.information19,
159 information20 = p_rec.information20,
160 information21 = p_rec.information21,
161 information22 = p_rec.information22,
162 information23 = p_rec.information23,
163 information24 = p_rec.information24,
164 information25 = p_rec.information25,
165 information26 = p_rec.information26,
166 information27 = p_rec.information27,
167 information28 = p_rec.information28,
168 information29 = p_rec.information29,
169 information30 = p_rec.information30,
170 information_category = p_rec.information_category,
171 attribute1 = p_rec.attribute1,
172 attribute2 = p_rec.attribute2,
173 attribute3 = p_rec.attribute3,
174 attribute4 = p_rec.attribute4,
175 attribute5 = p_rec.attribute5,
176 attribute6 = p_rec.attribute6,
177 attribute7 = p_rec.attribute7,
178 attribute8 = p_rec.attribute8,
179 attribute9 = p_rec.attribute9,
180 attribute10 = p_rec.attribute10,
181 attribute11 = p_rec.attribute11,
182 attribute12 = p_rec.attribute12,
183 attribute13 = p_rec.attribute13,
184 attribute14 = p_rec.attribute14,
185 attribute15 = p_rec.attribute15,
186 attribute16 = p_rec.attribute16,
187 attribute17 = p_rec.attribute17,
188 attribute18 = p_rec.attribute18,
189 attribute19 = p_rec.attribute19,
190 attribute20 = p_rec.attribute20,
191 attribute21 = p_rec.attribute21,
192 attribute22 = p_rec.attribute22,
193 attribute23 = p_rec.attribute23,
194 attribute24 = p_rec.attribute24,
195 attribute25 = p_rec.attribute25,
196 attribute26 = p_rec.attribute26,
197 attribute27 = p_rec.attribute27,
198 attribute28 = p_rec.attribute28,
199 attribute29 = p_rec.attribute29,
200 attribute30 = p_rec.attribute30,
201 attribute_category = p_rec.attribute_category,
202 object_version_number = p_rec.object_version_number,
203 pay_basis_id = p_rec.pay_basis_id,
204 supervisor_id = p_rec.supervisor_id,
205 wf_transaction_category_id = p_rec.wf_transaction_category_id
206 where position_transaction_id = p_rec.position_transaction_id;
207 --
208 --
209 hr_utility.set_location(' Leaving:'||l_proc, 10);
210 --
211 Exception
212 When hr_api.check_integrity_violated Then
213 -- A check constraint has been violated
214 pqh_ptx_shd.constraint_error
215 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
216 When hr_api.parent_integrity_violated Then
217 -- Parent integrity has been violated
218 pqh_ptx_shd.constraint_error
219 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220 When hr_api.unique_integrity_violated Then
221 -- Unique integrity has been violated
222 pqh_ptx_shd.constraint_error
223 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
224 When Others Then
225 Raise;
226 End update_dml;
227 --
228 -- ----------------------------------------------------------------------------
229 -- |------------------------------< pre_update >------------------------------|
230 -- ----------------------------------------------------------------------------
231 -- {Start Of Comments}
232 --
233 -- Description:
234 -- This private procedure contains any processing which is required before
235 -- the update dml.
236 --
237 -- Prerequisites:
238 -- This is an internal procedure which is called from the upd procedure.
239 --
240 -- In Parameters:
241 -- A Pl/Sql record structre.
242 --
243 -- Post Success:
244 -- Processing continues.
245 --
246 -- Post Failure:
247 -- If an error has occurred, an error message and exception will be raised
248 -- but not handled.
249 --
250 -- Developer Implementation Notes:
251 -- Any pre-processing required before the update dml is issued should be
252 -- coded within this procedure. It is important to note that any 3rd party
253 -- maintenance should be reviewed before placing in this procedure.
254 --
255 -- Access Status:
256 -- Internal Row Handler Use Only.
257 --
258 -- {End Of Comments}
259 -- ----------------------------------------------------------------------------
260 Procedure pre_update(p_rec in pqh_ptx_shd.g_rec_type) is
261 --
262 l_proc varchar2(72) := g_package||'pre_update';
263 --
264 Begin
265 hr_utility.set_location('Entering:'||l_proc, 5);
266 --
267 hr_utility.set_location(' Leaving:'||l_proc, 10);
268 End pre_update;
269 --
270 -- ----------------------------------------------------------------------------
271 -- |-----------------------------< post_update >------------------------------|
272 -- ----------------------------------------------------------------------------
273 -- {Start Of Comments}
274 --
275 -- Description:
276 -- This private procedure contains any processing which is required after the
277 -- update dml.
278 --
279 -- Prerequisites:
280 -- This is an internal procedure which is called from the upd procedure.
281 --
282 -- In Parameters:
283 -- A Pl/Sql record structre.
284 --
285 -- Post Success:
286 -- Processing continues.
287 --
288 -- Post Failure:
289 -- If an error has occurred, an error message and exception will be raised
290 -- but not handled.
291 --
292 -- Developer Implementation Notes:
293 -- Any post-processing required after the update dml is issued should be
294 -- coded within this procedure. It is important to note that any 3rd party
295 -- maintenance should be reviewed before placing in this procedure.
296 --
297 -- Access Status:
298 -- Internal Row Handler Use Only.
299 --
300 -- {End Of Comments}
301 -- ----------------------------------------------------------------------------
302 Procedure post_update(
303 p_effective_date in date,p_rec in pqh_ptx_shd.g_rec_type) is
304 --
305 l_proc varchar2(72) := g_package||'post_update';
306 --
307 l_effective_start_date date;
308 l_effective_end_date date;
309 l_position_definition_id number;
310 l_valid_grades_changed_warning boolean;
311 l_name hr_all_positions_f.name%type;
312 l_review_flag hr_all_positions_f.review_flag%type;
313 l_object_version_number number;
314 l_effective_date date :=sysdate;
315 l_datetrack_mode varchar2(20):='UPDATE';
316 --
317 --
318 cursor c_review_flag(p_position_id number) is
319 select review_flag
320 from hr_all_positions_f
321 where position_id = p_position_id;
322 --
323 cursor c1(p_position_id number, p_effective_date date) is
324 select review_flag, object_version_number
325 from hr_all_positions_f
326 where position_id = p_position_id
327 and p_effective_date between effective_start_date and effective_end_date;
328 --
329 Begin
330 hr_utility.set_location('Entering:'||l_proc, 5);
331 --
332 if p_rec.position_id is not null then
333 open c_review_flag(p_rec.position_id);
334 fetch c_review_flag into l_review_flag;
335 close c_review_flag;
336 --
337 if (nvl(p_rec.review_flag,'N') = 'Y' and nvl(l_review_flag,'N') = 'Y'
338 and nvl(pqh_ptx_shd.g_old_rec.review_flag,'N') = 'N')then
339 hr_utility.set_message(1802, 'PQH_POSITION_UNDER_REVIEW');
340 hr_utility.raise_error;
341 /* Bug 6524175 changes
342 elsif ((nvl(p_rec.review_flag,'N') = 'Y' and nvl(l_review_flag,'N') = 'N')
343 or (nvl(p_rec.review_flag,'N') = 'N' and nvl(l_review_flag,'N') = 'Y'))then */
344 --
345 else
346 update hr_all_positions_f
347 set review_flag = p_rec.review_flag
348 where position_id = p_rec.position_id;
349 /*
350 hr_position_api.update_position(
351 p_validate => false,
352 p_position_id => p_rec.position_id,
353 p_effective_start_date => l_effective_start_date,
354 p_effective_end_date => l_effective_end_date,
355 p_position_definition_id => l_position_definition_id,
356 p_valid_grades_changed_warning=> l_valid_grades_changed_warning,
357 p_name => l_name,
358 p_review_flag => p_rec.review_flag,
359 p_object_version_number => l_object_version_number,
360 p_effective_date => l_effective_date,
361 p_datetrack_mode => l_datetrack_mode
362 );
363 */
364 end if;
365 end if;
366 --
367 -- Start of API User Hook for post_update.
368 --
369 begin
370 --
371 pqh_ptx_rku.after_update
372 (
373 p_position_transaction_id =>p_rec.position_transaction_id
374 ,p_action_date =>p_rec.action_date
375 ,p_position_id =>p_rec.position_id
376 ,p_availability_status_id =>p_rec.availability_status_id
377 ,p_business_group_id =>p_rec.business_group_id
378 ,p_entry_step_id =>p_rec.entry_step_id
379 ,p_entry_grade_rule_id =>p_rec.entry_grade_rule_id
380 ,p_job_id =>p_rec.job_id
381 ,p_location_id =>p_rec.location_id
382 ,p_organization_id =>p_rec.organization_id
383 ,p_pay_freq_payroll_id =>p_rec.pay_freq_payroll_id
384 ,p_position_definition_id =>p_rec.position_definition_id
385 ,p_prior_position_id =>p_rec.prior_position_id
386 ,p_relief_position_id =>p_rec.relief_position_id
387 ,p_entry_grade_id =>p_rec.entry_grade_id
388 ,p_successor_position_id =>p_rec.successor_position_id
389 ,p_supervisor_position_id =>p_rec.supervisor_position_id
390 ,p_amendment_date =>p_rec.amendment_date
391 ,p_amendment_recommendation =>p_rec.amendment_recommendation
392 ,p_amendment_ref_number =>p_rec.amendment_ref_number
393 ,p_avail_status_prop_end_date =>p_rec.avail_status_prop_end_date
394 ,p_bargaining_unit_cd =>p_rec.bargaining_unit_cd
395 ,p_comments =>p_rec.comments
396 ,p_country1 =>p_rec.country1
397 ,p_country2 =>p_rec.country2
398 ,p_country3 =>p_rec.country3
399 ,p_current_job_prop_end_date =>p_rec.current_job_prop_end_date
400 ,p_current_org_prop_end_date =>p_rec.current_org_prop_end_date
401 ,p_date_effective =>p_rec.date_effective
402 ,p_date_end =>p_rec.date_end
403 ,p_earliest_hire_date =>p_rec.earliest_hire_date
404 ,p_fill_by_date =>p_rec.fill_by_date
405 ,p_frequency =>p_rec.frequency
406 ,p_fte =>p_rec.fte
407 ,p_fte_capacity =>p_rec.fte_capacity
408 ,p_location1 =>p_rec.location1
409 ,p_location2 =>p_rec.location2
410 ,p_location3 =>p_rec.location3
411 ,p_max_persons =>p_rec.max_persons
412 ,p_name =>p_rec.name
413 ,p_other_requirements =>p_rec.other_requirements
414 ,p_overlap_period =>p_rec.overlap_period
415 ,p_overlap_unit_cd =>p_rec.overlap_unit_cd
416 ,p_passport_required =>p_rec.passport_required
417 ,p_pay_term_end_day_cd =>p_rec.pay_term_end_day_cd
418 ,p_pay_term_end_month_cd =>p_rec.pay_term_end_month_cd
419 ,p_permanent_temporary_flag =>p_rec.permanent_temporary_flag
420 ,p_permit_recruitment_flag =>p_rec.permit_recruitment_flag
421 ,p_position_type =>p_rec.position_type
422 ,p_posting_description =>p_rec.posting_description
423 ,p_probation_period =>p_rec.probation_period
424 ,p_probation_period_unit_cd =>p_rec.probation_period_unit_cd
425 ,p_relocate_domestically =>p_rec.relocate_domestically
426 ,p_relocate_internationally =>p_rec.relocate_internationally
427 ,p_replacement_required_flag =>p_rec.replacement_required_flag
428 ,p_review_flag =>p_rec.review_flag
429 ,p_seasonal_flag =>p_rec.seasonal_flag
430 ,p_security_requirements =>p_rec.security_requirements
431 ,p_service_minimum =>p_rec.service_minimum
432 ,p_term_start_day_cd =>p_rec.term_start_day_cd
433 ,p_term_start_month_cd =>p_rec.term_start_month_cd
434 ,p_time_normal_finish =>p_rec.time_normal_finish
435 ,p_time_normal_start =>p_rec.time_normal_start
436 ,p_transaction_status =>p_rec.transaction_status
437 ,p_travel_required =>p_rec.travel_required
438 ,p_working_hours =>p_rec.working_hours
439 ,p_works_council_approval_flag =>p_rec.works_council_approval_flag
440 ,p_work_any_country =>p_rec.work_any_country
441 ,p_work_any_location =>p_rec.work_any_location
442 ,p_work_period_type_cd =>p_rec.work_period_type_cd
443 ,p_work_schedule =>p_rec.work_schedule
444 ,p_work_duration =>p_rec.work_duration
445 ,p_work_term_end_day_cd =>p_rec.work_term_end_day_cd
446 ,p_work_term_end_month_cd =>p_rec.work_term_end_month_cd
447 ,p_proposed_fte_for_layoff =>p_rec.proposed_fte_for_layoff
448 ,p_proposed_date_for_layoff =>p_rec.proposed_date_for_layoff
449 ,p_information1 =>p_rec.information1
450 ,p_information2 =>p_rec.information2
451 ,p_information3 =>p_rec.information3
452 ,p_information4 =>p_rec.information4
453 ,p_information5 =>p_rec.information5
454 ,p_information6 =>p_rec.information6
455 ,p_information7 =>p_rec.information7
456 ,p_information8 =>p_rec.information8
457 ,p_information9 =>p_rec.information9
458 ,p_information10 =>p_rec.information10
459 ,p_information11 =>p_rec.information11
460 ,p_information12 =>p_rec.information12
461 ,p_information13 =>p_rec.information13
462 ,p_information14 =>p_rec.information14
463 ,p_information15 =>p_rec.information15
464 ,p_information16 =>p_rec.information16
465 ,p_information17 =>p_rec.information17
466 ,p_information18 =>p_rec.information18
467 ,p_information19 =>p_rec.information19
468 ,p_information20 =>p_rec.information20
469 ,p_information21 =>p_rec.information21
470 ,p_information22 =>p_rec.information22
471 ,p_information23 =>p_rec.information23
472 ,p_information24 =>p_rec.information24
473 ,p_information25 =>p_rec.information25
474 ,p_information26 =>p_rec.information26
475 ,p_information27 =>p_rec.information27
476 ,p_information28 =>p_rec.information28
477 ,p_information29 =>p_rec.information29
478 ,p_information30 =>p_rec.information30
479 ,p_information_category =>p_rec.information_category
480 ,p_attribute1 =>p_rec.attribute1
481 ,p_attribute2 =>p_rec.attribute2
482 ,p_attribute3 =>p_rec.attribute3
483 ,p_attribute4 =>p_rec.attribute4
484 ,p_attribute5 =>p_rec.attribute5
485 ,p_attribute6 =>p_rec.attribute6
486 ,p_attribute7 =>p_rec.attribute7
487 ,p_attribute8 =>p_rec.attribute8
488 ,p_attribute9 =>p_rec.attribute9
489 ,p_attribute10 =>p_rec.attribute10
490 ,p_attribute11 =>p_rec.attribute11
491 ,p_attribute12 =>p_rec.attribute12
492 ,p_attribute13 =>p_rec.attribute13
493 ,p_attribute14 =>p_rec.attribute14
494 ,p_attribute15 =>p_rec.attribute15
495 ,p_attribute16 =>p_rec.attribute16
496 ,p_attribute17 =>p_rec.attribute17
497 ,p_attribute18 =>p_rec.attribute18
498 ,p_attribute19 =>p_rec.attribute19
499 ,p_attribute20 =>p_rec.attribute20
500 ,p_attribute21 =>p_rec.attribute21
501 ,p_attribute22 =>p_rec.attribute22
502 ,p_attribute23 =>p_rec.attribute23
503 ,p_attribute24 =>p_rec.attribute24
504 ,p_attribute25 =>p_rec.attribute25
505 ,p_attribute26 =>p_rec.attribute26
506 ,p_attribute27 =>p_rec.attribute27
507 ,p_attribute28 =>p_rec.attribute28
508 ,p_attribute29 =>p_rec.attribute29
509 ,p_attribute30 =>p_rec.attribute30
510 ,p_attribute_category =>p_rec.attribute_category
511 ,p_object_version_number =>p_rec.object_version_number
512 ,p_effective_date =>p_effective_date
513 ,p_action_date_o =>pqh_ptx_shd.g_old_rec.action_date
514 ,p_position_id_o =>pqh_ptx_shd.g_old_rec.position_id
515 ,p_availability_status_id_o =>pqh_ptx_shd.g_old_rec.availability_status_id
516 ,p_business_group_id_o =>pqh_ptx_shd.g_old_rec.business_group_id
517 ,p_entry_step_id_o =>pqh_ptx_shd.g_old_rec.entry_step_id
518 ,p_entry_grade_rule_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_rule_id
519 ,p_job_id_o =>pqh_ptx_shd.g_old_rec.job_id
520 ,p_location_id_o =>pqh_ptx_shd.g_old_rec.location_id
521 ,p_organization_id_o =>pqh_ptx_shd.g_old_rec.organization_id
522 ,p_pay_freq_payroll_id_o =>pqh_ptx_shd.g_old_rec.pay_freq_payroll_id
523 ,p_position_definition_id_o =>pqh_ptx_shd.g_old_rec.position_definition_id
524 ,p_prior_position_id_o =>pqh_ptx_shd.g_old_rec.prior_position_id
525 ,p_relief_position_id_o =>pqh_ptx_shd.g_old_rec.relief_position_id
526 ,p_entry_grade_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_id
527 ,p_successor_position_id_o =>pqh_ptx_shd.g_old_rec.successor_position_id
528 ,p_supervisor_position_id_o =>pqh_ptx_shd.g_old_rec.supervisor_position_id
529 ,p_amendment_date_o =>pqh_ptx_shd.g_old_rec.amendment_date
530 ,p_amendment_recommendation_o =>pqh_ptx_shd.g_old_rec.amendment_recommendation
531 ,p_amendment_ref_number_o =>pqh_ptx_shd.g_old_rec.amendment_ref_number
532 ,p_avail_status_prop_end_date_o =>pqh_ptx_shd.g_old_rec.avail_status_prop_end_date
533 ,p_bargaining_unit_cd_o =>pqh_ptx_shd.g_old_rec.bargaining_unit_cd
534 ,p_comments_o =>pqh_ptx_shd.g_old_rec.comments
535 ,p_country1_o =>pqh_ptx_shd.g_old_rec.country1
536 ,p_country2_o =>pqh_ptx_shd.g_old_rec.country2
537 ,p_country3_o =>pqh_ptx_shd.g_old_rec.country3
538 ,p_current_job_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_job_prop_end_date
539 ,p_current_org_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_org_prop_end_date
540 ,p_date_effective_o =>pqh_ptx_shd.g_old_rec.date_effective
541 ,p_date_end_o =>pqh_ptx_shd.g_old_rec.date_end
542 ,p_earliest_hire_date_o =>pqh_ptx_shd.g_old_rec.earliest_hire_date
543 ,p_fill_by_date_o =>pqh_ptx_shd.g_old_rec.fill_by_date
544 ,p_frequency_o =>pqh_ptx_shd.g_old_rec.frequency
545 ,p_fte_o =>pqh_ptx_shd.g_old_rec.fte
546 ,p_fte_capacity_o =>pqh_ptx_shd.g_old_rec.fte_capacity
547 ,p_location1_o =>pqh_ptx_shd.g_old_rec.location1
548 ,p_location2_o =>pqh_ptx_shd.g_old_rec.location2
549 ,p_location3_o =>pqh_ptx_shd.g_old_rec.location3
550 ,p_max_persons_o =>pqh_ptx_shd.g_old_rec.max_persons
551 ,p_name_o =>pqh_ptx_shd.g_old_rec.name
552 ,p_other_requirements_o =>pqh_ptx_shd.g_old_rec.other_requirements
553 ,p_overlap_period_o =>pqh_ptx_shd.g_old_rec.overlap_period
554 ,p_overlap_unit_cd_o =>pqh_ptx_shd.g_old_rec.overlap_unit_cd
555 ,p_passport_required_o =>pqh_ptx_shd.g_old_rec.passport_required
556 ,p_pay_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_day_cd
557 ,p_pay_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_month_cd
558 ,p_permanent_temporary_flag_o =>pqh_ptx_shd.g_old_rec.permanent_temporary_flag
559 ,p_permit_recruitment_flag_o =>pqh_ptx_shd.g_old_rec.permit_recruitment_flag
560 ,p_position_type_o =>pqh_ptx_shd.g_old_rec.position_type
561 ,p_posting_description_o =>pqh_ptx_shd.g_old_rec.posting_description
562 ,p_probation_period_o =>pqh_ptx_shd.g_old_rec.probation_period
563 ,p_probation_period_unit_cd_o =>pqh_ptx_shd.g_old_rec.probation_period_unit_cd
564 ,p_relocate_domestically_o =>pqh_ptx_shd.g_old_rec.relocate_domestically
565 ,p_relocate_internationally_o =>pqh_ptx_shd.g_old_rec.relocate_internationally
566 ,p_replacement_required_flag_o =>pqh_ptx_shd.g_old_rec.replacement_required_flag
567 ,p_review_flag_o =>pqh_ptx_shd.g_old_rec.review_flag
568 ,p_seasonal_flag_o =>pqh_ptx_shd.g_old_rec.seasonal_flag
569 ,p_security_requirements_o =>pqh_ptx_shd.g_old_rec.security_requirements
570 ,p_service_minimum_o =>pqh_ptx_shd.g_old_rec.service_minimum
571 ,p_term_start_day_cd_o =>pqh_ptx_shd.g_old_rec.term_start_day_cd
572 ,p_term_start_month_cd_o =>pqh_ptx_shd.g_old_rec.term_start_month_cd
573 ,p_time_normal_finish_o =>pqh_ptx_shd.g_old_rec.time_normal_finish
574 ,p_time_normal_start_o =>pqh_ptx_shd.g_old_rec.time_normal_start
575 ,p_transaction_status_o =>pqh_ptx_shd.g_old_rec.transaction_status
576 ,p_travel_required_o =>pqh_ptx_shd.g_old_rec.travel_required
577 ,p_working_hours_o =>pqh_ptx_shd.g_old_rec.working_hours
578 ,p_works_council_approval_fla_o =>pqh_ptx_shd.g_old_rec.works_council_approval_flag
579 ,p_work_any_country_o =>pqh_ptx_shd.g_old_rec.work_any_country
580 ,p_work_any_location_o =>pqh_ptx_shd.g_old_rec.work_any_location
581 ,p_work_period_type_cd_o =>pqh_ptx_shd.g_old_rec.work_period_type_cd
582 ,p_work_schedule_o =>pqh_ptx_shd.g_old_rec.work_schedule
583 ,p_work_duration_o =>pqh_ptx_shd.g_old_rec.work_duration
584 ,p_work_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_day_cd
585 ,p_work_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_month_cd
586 ,p_proposed_fte_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff
587 ,p_proposed_date_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_date_for_layoff
588 ,p_information1_o =>pqh_ptx_shd.g_old_rec.information1
589 ,p_information2_o =>pqh_ptx_shd.g_old_rec.information2
590 ,p_information3_o =>pqh_ptx_shd.g_old_rec.information3
591 ,p_information4_o =>pqh_ptx_shd.g_old_rec.information4
592 ,p_information5_o =>pqh_ptx_shd.g_old_rec.information5
593 ,p_information6_o =>pqh_ptx_shd.g_old_rec.information6
594 ,p_information7_o =>pqh_ptx_shd.g_old_rec.information7
595 ,p_information8_o =>pqh_ptx_shd.g_old_rec.information8
596 ,p_information9_o =>pqh_ptx_shd.g_old_rec.information9
597 ,p_information10_o =>pqh_ptx_shd.g_old_rec.information10
598 ,p_information11_o =>pqh_ptx_shd.g_old_rec.information11
599 ,p_information12_o =>pqh_ptx_shd.g_old_rec.information12
600 ,p_information13_o =>pqh_ptx_shd.g_old_rec.information13
601 ,p_information14_o =>pqh_ptx_shd.g_old_rec.information14
602 ,p_information15_o =>pqh_ptx_shd.g_old_rec.information15
603 ,p_information16_o =>pqh_ptx_shd.g_old_rec.information16
604 ,p_information17_o =>pqh_ptx_shd.g_old_rec.information17
605 ,p_information18_o =>pqh_ptx_shd.g_old_rec.information18
606 ,p_information19_o =>pqh_ptx_shd.g_old_rec.information19
607 ,p_information20_o =>pqh_ptx_shd.g_old_rec.information20
608 ,p_information21_o =>pqh_ptx_shd.g_old_rec.information21
609 ,p_information22_o =>pqh_ptx_shd.g_old_rec.information22
610 ,p_information23_o =>pqh_ptx_shd.g_old_rec.information23
611 ,p_information24_o =>pqh_ptx_shd.g_old_rec.information24
612 ,p_information25_o =>pqh_ptx_shd.g_old_rec.information25
613 ,p_information26_o =>pqh_ptx_shd.g_old_rec.information26
614 ,p_information27_o =>pqh_ptx_shd.g_old_rec.information27
615 ,p_information28_o =>pqh_ptx_shd.g_old_rec.information28
616 ,p_information29_o =>pqh_ptx_shd.g_old_rec.information29
617 ,p_information30_o =>pqh_ptx_shd.g_old_rec.information30
618 ,p_information_category_o =>pqh_ptx_shd.g_old_rec.information_category
619 ,p_attribute1_o =>pqh_ptx_shd.g_old_rec.attribute1
620 ,p_attribute2_o =>pqh_ptx_shd.g_old_rec.attribute2
621 ,p_attribute3_o =>pqh_ptx_shd.g_old_rec.attribute3
622 ,p_attribute4_o =>pqh_ptx_shd.g_old_rec.attribute4
623 ,p_attribute5_o =>pqh_ptx_shd.g_old_rec.attribute5
624 ,p_attribute6_o =>pqh_ptx_shd.g_old_rec.attribute6
625 ,p_attribute7_o =>pqh_ptx_shd.g_old_rec.attribute7
626 ,p_attribute8_o =>pqh_ptx_shd.g_old_rec.attribute8
627 ,p_attribute9_o =>pqh_ptx_shd.g_old_rec.attribute9
628 ,p_attribute10_o =>pqh_ptx_shd.g_old_rec.attribute10
629 ,p_attribute11_o =>pqh_ptx_shd.g_old_rec.attribute11
630 ,p_attribute12_o =>pqh_ptx_shd.g_old_rec.attribute12
631 ,p_attribute13_o =>pqh_ptx_shd.g_old_rec.attribute13
632 ,p_attribute14_o =>pqh_ptx_shd.g_old_rec.attribute14
633 ,p_attribute15_o =>pqh_ptx_shd.g_old_rec.attribute15
634 ,p_attribute16_o =>pqh_ptx_shd.g_old_rec.attribute16
635 ,p_attribute17_o =>pqh_ptx_shd.g_old_rec.attribute17
636 ,p_attribute18_o =>pqh_ptx_shd.g_old_rec.attribute18
637 ,p_attribute19_o =>pqh_ptx_shd.g_old_rec.attribute19
638 ,p_attribute20_o =>pqh_ptx_shd.g_old_rec.attribute20
639 ,p_attribute21_o =>pqh_ptx_shd.g_old_rec.attribute21
640 ,p_attribute22_o =>pqh_ptx_shd.g_old_rec.attribute22
641 ,p_attribute23_o =>pqh_ptx_shd.g_old_rec.attribute23
642 ,p_attribute24_o =>pqh_ptx_shd.g_old_rec.attribute24
643 ,p_attribute25_o =>pqh_ptx_shd.g_old_rec.attribute25
644 ,p_attribute26_o =>pqh_ptx_shd.g_old_rec.attribute26
645 ,p_attribute27_o =>pqh_ptx_shd.g_old_rec.attribute27
646 ,p_attribute28_o =>pqh_ptx_shd.g_old_rec.attribute28
647 ,p_attribute29_o =>pqh_ptx_shd.g_old_rec.attribute29
648 ,p_attribute30_o =>pqh_ptx_shd.g_old_rec.attribute30
649 ,p_attribute_category_o =>pqh_ptx_shd.g_old_rec.attribute_category
650 ,p_object_version_number_o =>pqh_ptx_shd.g_old_rec.object_version_number
651 ,p_pay_basis_id_o =>pqh_ptx_shd.g_old_rec.pay_basis_id
652 ,p_supervisor_id_o =>pqh_ptx_shd.g_old_rec.supervisor_id
653 ,p_wf_transaction_category_id_o =>pqh_ptx_shd.g_old_rec.wf_transaction_category_id
654 );
655 --
656 exception
657 --
658 when hr_api.cannot_find_prog_unit then
659 --
660 hr_api.cannot_find_prog_unit_error
661 (p_module_name => 'pqh_position_transactions'
662 ,p_hook_type => 'AU');
663 --
664 end;
665 --
666 -- End of API User Hook for post_update.
667 --
668 --
669 hr_utility.set_location(' Leaving:'||l_proc, 10);
670 End post_update;
671 --
672 -- ----------------------------------------------------------------------------
673 -- |-----------------------------< convert_defs >-----------------------------|
674 -- ----------------------------------------------------------------------------
675 -- {Start Of Comments}
676 --
677 -- Description:
678 -- The Convert_Defs procedure has one very important function:
679 -- It must return the record structure for the row with all system defaulted
680 -- values converted into its corresponding parameter value for update. When
681 -- we attempt to update a row through the Upd process , certain
682 -- parameters can be defaulted which enables flexibility in the calling of
683 -- the upd process (e.g. only attributes which need to be updated need to be
684 -- specified). For the upd process to determine which attributes
685 -- have NOT been specified we need to check if the parameter has a reserved
686 -- system default value. Therefore, for all parameters which have a
687 -- corresponding reserved system default mechanism specified we need to
688 -- check if a system default is being used. If a system default is being
689 -- used then we convert the defaulted value into its corresponding attribute
690 -- value held in the g_old_rec data structure.
691 --
692 -- Prerequisites:
693 -- This private function can only be called from the upd process.
694 --
695 -- In Parameters:
696 -- A Pl/Sql record structre.
697 --
698 -- Post Success:
699 -- The record structure will be returned with all system defaulted parameter
700 -- values converted into its current row attribute value.
701 --
702 -- Post Failure:
703 -- No direct error handling is required within this function. Any possible
704 -- errors within this procedure will be a PL/SQL value error due to conversion
705 -- of datatypes or data lengths.
706 --
707 -- Developer Implementation Notes:
708 -- None.
709 --
710 -- Access Status:
711 -- Internal Row Handler Use Only.
712 --
713 -- {End Of Comments}
714 -- ----------------------------------------------------------------------------
715 Procedure convert_defs(p_rec in out nocopy pqh_ptx_shd.g_rec_type) is
716 --
717 l_proc varchar2(72) := g_package||'convert_defs';
718 --
719 Begin
720 --
721 hr_utility.set_location('Entering:'||l_proc, 5);
722 --
723 -- We must now examine each argument value in the
724 -- p_rec plsql record structure
725 -- to see if a system default is being used. If a system default
726 -- is being used then we must set to the 'current' argument value.
727 --
728 If (p_rec.action_date = hr_api.g_date) then
729 p_rec.action_date :=
730 pqh_ptx_shd.g_old_rec.action_date;
731 End If;
732 If (p_rec.position_id = hr_api.g_number) then
733 p_rec.position_id :=
734 pqh_ptx_shd.g_old_rec.position_id;
735 End If;
736 If (p_rec.availability_status_id = hr_api.g_number) then
737 p_rec.availability_status_id :=
738 pqh_ptx_shd.g_old_rec.availability_status_id;
739 End If;
740 If (p_rec.business_group_id = hr_api.g_number) then
741 p_rec.business_group_id :=
742 pqh_ptx_shd.g_old_rec.business_group_id;
743 End If;
744 If (p_rec.entry_step_id = hr_api.g_number) then
745 p_rec.entry_step_id :=
746 pqh_ptx_shd.g_old_rec.entry_step_id;
747 End If;
748 If (p_rec.entry_grade_rule_id = hr_api.g_number) then
749 p_rec.entry_grade_rule_id :=
750 pqh_ptx_shd.g_old_rec.entry_grade_rule_id;
751 End If;
752 If (p_rec.job_id = hr_api.g_number) then
753 p_rec.job_id :=
754 pqh_ptx_shd.g_old_rec.job_id;
755 End If;
756 If (p_rec.location_id = hr_api.g_number) then
757 p_rec.location_id :=
758 pqh_ptx_shd.g_old_rec.location_id;
759 End If;
760 If (p_rec.organization_id = hr_api.g_number) then
761 p_rec.organization_id :=
762 pqh_ptx_shd.g_old_rec.organization_id;
763 End If;
764 If (p_rec.pay_freq_payroll_id = hr_api.g_number) then
765 p_rec.pay_freq_payroll_id :=
766 pqh_ptx_shd.g_old_rec.pay_freq_payroll_id;
767 End If;
768 If (p_rec.position_definition_id = hr_api.g_number) then
769 p_rec.position_definition_id :=
770 pqh_ptx_shd.g_old_rec.position_definition_id;
771 End If;
772 If (p_rec.prior_position_id = hr_api.g_number) then
773 p_rec.prior_position_id :=
774 pqh_ptx_shd.g_old_rec.prior_position_id;
775 End If;
776 If (p_rec.relief_position_id = hr_api.g_number) then
777 p_rec.relief_position_id :=
778 pqh_ptx_shd.g_old_rec.relief_position_id;
779 End If;
780 If (p_rec.entry_grade_id = hr_api.g_number) then
781 p_rec.entry_grade_id :=
782 pqh_ptx_shd.g_old_rec.entry_grade_id;
783 End If;
784 If (p_rec.successor_position_id = hr_api.g_number) then
785 p_rec.successor_position_id :=
786 pqh_ptx_shd.g_old_rec.successor_position_id;
787 End If;
788 If (p_rec.supervisor_position_id = hr_api.g_number) then
789 p_rec.supervisor_position_id :=
790 pqh_ptx_shd.g_old_rec.supervisor_position_id;
791 End If;
792 If (p_rec.amendment_date = hr_api.g_date) then
793 p_rec.amendment_date :=
794 pqh_ptx_shd.g_old_rec.amendment_date;
795 End If;
796 If (p_rec.amendment_recommendation = hr_api.g_varchar2) then
797 p_rec.amendment_recommendation :=
798 pqh_ptx_shd.g_old_rec.amendment_recommendation;
799 End If;
800 If (p_rec.amendment_ref_number = hr_api.g_varchar2) then
801 p_rec.amendment_ref_number :=
802 pqh_ptx_shd.g_old_rec.amendment_ref_number;
803 End If;
804 If (p_rec.avail_status_prop_end_date = hr_api.g_date) then
805 p_rec.avail_status_prop_end_date :=
806 pqh_ptx_shd.g_old_rec.avail_status_prop_end_date;
807 End If;
808 If (p_rec.bargaining_unit_cd = hr_api.g_varchar2) then
809 p_rec.bargaining_unit_cd :=
810 pqh_ptx_shd.g_old_rec.bargaining_unit_cd;
811 End If;
812 If (p_rec.comments = hr_api.g_varchar2) then
813 p_rec.comments :=
814 pqh_ptx_shd.g_old_rec.comments;
815 End If;
816 If (p_rec.country1 = hr_api.g_varchar2) then
817 p_rec.country1 :=
818 pqh_ptx_shd.g_old_rec.country1;
819 End If;
820 If (p_rec.country2 = hr_api.g_varchar2) then
821 p_rec.country2 :=
822 pqh_ptx_shd.g_old_rec.country2;
823 End If;
824 If (p_rec.country3 = hr_api.g_varchar2) then
825 p_rec.country3 :=
826 pqh_ptx_shd.g_old_rec.country3;
827 End If;
828 If (p_rec.current_job_prop_end_date = hr_api.g_date) then
829 p_rec.current_job_prop_end_date :=
830 pqh_ptx_shd.g_old_rec.current_job_prop_end_date;
831 End If;
832 If (p_rec.current_org_prop_end_date = hr_api.g_date) then
833 p_rec.current_org_prop_end_date :=
834 pqh_ptx_shd.g_old_rec.current_org_prop_end_date;
835 End If;
836 If (p_rec.date_effective = hr_api.g_date) then
837 p_rec.date_effective :=
838 pqh_ptx_shd.g_old_rec.date_effective;
839 End If;
840 If (p_rec.date_end = hr_api.g_date) then
841 p_rec.date_end :=
842 pqh_ptx_shd.g_old_rec.date_end;
843 End If;
844 If (p_rec.earliest_hire_date = hr_api.g_date) then
845 p_rec.earliest_hire_date :=
846 pqh_ptx_shd.g_old_rec.earliest_hire_date;
847 End If;
848 If (p_rec.fill_by_date = hr_api.g_date) then
849 p_rec.fill_by_date :=
850 pqh_ptx_shd.g_old_rec.fill_by_date;
851 End If;
852 If (p_rec.frequency = hr_api.g_varchar2) then
853 p_rec.frequency :=
854 pqh_ptx_shd.g_old_rec.frequency;
855 End If;
856 If (p_rec.fte = hr_api.g_number) then
857 p_rec.fte :=
858 pqh_ptx_shd.g_old_rec.fte;
859 End If;
860 If (p_rec.fte_capacity = hr_api.g_varchar2) then
861 p_rec.fte_capacity :=
862 pqh_ptx_shd.g_old_rec.fte_capacity;
863 End If;
864 If (p_rec.location1 = hr_api.g_varchar2) then
865 p_rec.location1 :=
866 pqh_ptx_shd.g_old_rec.location1;
867 End If;
868 If (p_rec.location2 = hr_api.g_varchar2) then
869 p_rec.location2 :=
870 pqh_ptx_shd.g_old_rec.location2;
871 End If;
872 If (p_rec.location3 = hr_api.g_varchar2) then
873 p_rec.location3 :=
874 pqh_ptx_shd.g_old_rec.location3;
875 End If;
876 If (p_rec.max_persons = hr_api.g_number) then
877 p_rec.max_persons :=
878 pqh_ptx_shd.g_old_rec.max_persons;
879 End If;
880 If (p_rec.name = hr_api.g_varchar2) then
881 p_rec.name :=
882 pqh_ptx_shd.g_old_rec.name;
883 End If;
884 If (p_rec.other_requirements = hr_api.g_varchar2) then
885 p_rec.other_requirements :=
886 pqh_ptx_shd.g_old_rec.other_requirements;
887 End If;
888 If (p_rec.overlap_period = hr_api.g_number) then
889 p_rec.overlap_period :=
890 pqh_ptx_shd.g_old_rec.overlap_period;
891 End If;
892 If (p_rec.overlap_unit_cd = hr_api.g_varchar2) then
893 p_rec.overlap_unit_cd :=
894 pqh_ptx_shd.g_old_rec.overlap_unit_cd;
895 End If;
896 If (p_rec.passport_required = hr_api.g_varchar2) then
897 p_rec.passport_required :=
898 pqh_ptx_shd.g_old_rec.passport_required;
899 End If;
900 If (p_rec.pay_term_end_day_cd = hr_api.g_varchar2) then
901 p_rec.pay_term_end_day_cd :=
902 pqh_ptx_shd.g_old_rec.pay_term_end_day_cd;
903 End If;
904 If (p_rec.pay_term_end_month_cd = hr_api.g_varchar2) then
905 p_rec.pay_term_end_month_cd :=
906 pqh_ptx_shd.g_old_rec.pay_term_end_month_cd;
907 End If;
908 If (p_rec.permanent_temporary_flag = hr_api.g_varchar2) then
909 p_rec.permanent_temporary_flag :=
910 pqh_ptx_shd.g_old_rec.permanent_temporary_flag;
911 End If;
912 If (p_rec.permit_recruitment_flag = hr_api.g_varchar2) then
913 p_rec.permit_recruitment_flag :=
914 pqh_ptx_shd.g_old_rec.permit_recruitment_flag;
915 End If;
916 If (p_rec.position_type = hr_api.g_varchar2) then
917 p_rec.position_type :=
918 pqh_ptx_shd.g_old_rec.position_type;
919 End If;
920 If (p_rec.posting_description = hr_api.g_varchar2) then
921 p_rec.posting_description :=
922 pqh_ptx_shd.g_old_rec.posting_description;
923 End If;
924 If (p_rec.probation_period = hr_api.g_number) then
925 p_rec.probation_period :=
926 pqh_ptx_shd.g_old_rec.probation_period;
927 End If;
928 If (p_rec.probation_period_unit_cd = hr_api.g_varchar2) then
929 p_rec.probation_period_unit_cd :=
930 pqh_ptx_shd.g_old_rec.probation_period_unit_cd;
931 End If;
932 If (p_rec.relocate_domestically = hr_api.g_varchar2) then
933 p_rec.relocate_domestically :=
934 pqh_ptx_shd.g_old_rec.relocate_domestically;
935 End If;
936 If (p_rec.relocate_internationally = hr_api.g_varchar2) then
937 p_rec.relocate_internationally :=
938 pqh_ptx_shd.g_old_rec.relocate_internationally;
939 End If;
940 If (p_rec.replacement_required_flag = hr_api.g_varchar2) then
941 p_rec.replacement_required_flag :=
942 pqh_ptx_shd.g_old_rec.replacement_required_flag;
943 End If;
944 If (p_rec.review_flag = hr_api.g_varchar2) then
945 p_rec.review_flag :=
946 pqh_ptx_shd.g_old_rec.review_flag;
947 End If;
948 If (p_rec.seasonal_flag = hr_api.g_varchar2) then
949 p_rec.seasonal_flag :=
950 pqh_ptx_shd.g_old_rec.seasonal_flag;
951 End If;
952 If (p_rec.security_requirements = hr_api.g_varchar2) then
953 p_rec.security_requirements :=
954 pqh_ptx_shd.g_old_rec.security_requirements;
955 End If;
956 If (p_rec.service_minimum = hr_api.g_varchar2) then
957 p_rec.service_minimum :=
958 pqh_ptx_shd.g_old_rec.service_minimum;
959 End If;
960 If (p_rec.term_start_day_cd = hr_api.g_varchar2) then
961 p_rec.term_start_day_cd :=
962 pqh_ptx_shd.g_old_rec.term_start_day_cd;
963 End If;
964 If (p_rec.term_start_month_cd = hr_api.g_varchar2) then
965 p_rec.term_start_month_cd :=
966 pqh_ptx_shd.g_old_rec.term_start_month_cd;
967 End If;
968 If (p_rec.time_normal_finish = hr_api.g_varchar2) then
969 p_rec.time_normal_finish :=
970 pqh_ptx_shd.g_old_rec.time_normal_finish;
971 End If;
972 If (p_rec.time_normal_start = hr_api.g_varchar2) then
973 p_rec.time_normal_start :=
974 pqh_ptx_shd.g_old_rec.time_normal_start;
975 End If;
976 If (p_rec.transaction_status = hr_api.g_varchar2) then
977 p_rec.transaction_status :=
978 pqh_ptx_shd.g_old_rec.transaction_status;
979 End If;
980 If (p_rec.travel_required = hr_api.g_varchar2) then
981 p_rec.travel_required :=
982 pqh_ptx_shd.g_old_rec.travel_required;
983 End If;
984 If (p_rec.working_hours = hr_api.g_number) then
985 p_rec.working_hours :=
986 pqh_ptx_shd.g_old_rec.working_hours;
987 End If;
988 If (p_rec.works_council_approval_flag = hr_api.g_varchar2) then
989 p_rec.works_council_approval_flag :=
990 pqh_ptx_shd.g_old_rec.works_council_approval_flag;
991 End If;
992 If (p_rec.work_any_country = hr_api.g_varchar2) then
993 p_rec.work_any_country :=
994 pqh_ptx_shd.g_old_rec.work_any_country;
995 End If;
996 If (p_rec.work_any_location = hr_api.g_varchar2) then
997 p_rec.work_any_location :=
998 pqh_ptx_shd.g_old_rec.work_any_location;
999 End If;
1000 If (p_rec.work_period_type_cd = hr_api.g_varchar2) then
1001 p_rec.work_period_type_cd :=
1002 pqh_ptx_shd.g_old_rec.work_period_type_cd;
1003 End If;
1004 If (p_rec.work_schedule = hr_api.g_varchar2) then
1005 p_rec.work_schedule :=
1006 pqh_ptx_shd.g_old_rec.work_schedule;
1007 End If;
1008 If (p_rec.work_duration = hr_api.g_varchar2) then
1009 p_rec.work_duration :=
1010 pqh_ptx_shd.g_old_rec.work_duration;
1011 End If;
1012 If (p_rec.work_term_end_day_cd = hr_api.g_varchar2) then
1013 p_rec.work_term_end_day_cd :=
1014 pqh_ptx_shd.g_old_rec.work_term_end_day_cd;
1015 End If;
1016 If (p_rec.work_term_end_month_cd = hr_api.g_varchar2) then
1017 p_rec.work_term_end_month_cd :=
1018 pqh_ptx_shd.g_old_rec.work_term_end_month_cd;
1019 End If;
1020 If (p_rec.proposed_fte_for_layoff = hr_api.g_number) then
1021 p_rec.proposed_fte_for_layoff :=
1022 pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff;
1023 End If;
1024 If (p_rec.proposed_date_for_layoff = hr_api.g_date) then
1025 p_rec.proposed_date_for_layoff :=
1026 pqh_ptx_shd.g_old_rec.proposed_date_for_layoff;
1027 End If;
1028 If (p_rec.information1 = hr_api.g_varchar2) then
1029 p_rec.information1 :=
1030 pqh_ptx_shd.g_old_rec.information1;
1031 End If;
1032 If (p_rec.information2 = hr_api.g_varchar2) then
1033 p_rec.information2 :=
1034 pqh_ptx_shd.g_old_rec.information2;
1035 End If;
1036 If (p_rec.information3 = hr_api.g_varchar2) then
1037 p_rec.information3 :=
1038 pqh_ptx_shd.g_old_rec.information3;
1039 End If;
1040 If (p_rec.information4 = hr_api.g_varchar2) then
1041 p_rec.information4 :=
1042 pqh_ptx_shd.g_old_rec.information4;
1043 End If;
1044 If (p_rec.information5 = hr_api.g_varchar2) then
1045 p_rec.information5 :=
1046 pqh_ptx_shd.g_old_rec.information5;
1047 End If;
1048 If (p_rec.information6 = hr_api.g_varchar2) then
1049 p_rec.information6 :=
1050 pqh_ptx_shd.g_old_rec.information6;
1051 End If;
1052 If (p_rec.information7 = hr_api.g_varchar2) then
1053 p_rec.information7 :=
1054 pqh_ptx_shd.g_old_rec.information7;
1055 End If;
1056 If (p_rec.information8 = hr_api.g_varchar2) then
1057 p_rec.information8 :=
1058 pqh_ptx_shd.g_old_rec.information8;
1059 End If;
1060 If (p_rec.information9 = hr_api.g_varchar2) then
1061 p_rec.information9 :=
1062 pqh_ptx_shd.g_old_rec.information9;
1063 End If;
1064 If (p_rec.information10 = hr_api.g_varchar2) then
1065 p_rec.information10 :=
1066 pqh_ptx_shd.g_old_rec.information10;
1067 End If;
1068 If (p_rec.information11 = hr_api.g_varchar2) then
1069 p_rec.information11 :=
1070 pqh_ptx_shd.g_old_rec.information11;
1071 End If;
1072 If (p_rec.information12 = hr_api.g_varchar2) then
1073 p_rec.information12 :=
1074 pqh_ptx_shd.g_old_rec.information12;
1075 End If;
1076 If (p_rec.information13 = hr_api.g_varchar2) then
1077 p_rec.information13 :=
1078 pqh_ptx_shd.g_old_rec.information13;
1079 End If;
1080 If (p_rec.information14 = hr_api.g_varchar2) then
1081 p_rec.information14 :=
1082 pqh_ptx_shd.g_old_rec.information14;
1083 End If;
1084 If (p_rec.information15 = hr_api.g_varchar2) then
1085 p_rec.information15 :=
1086 pqh_ptx_shd.g_old_rec.information15;
1087 End If;
1088 If (p_rec.information16 = hr_api.g_varchar2) then
1089 p_rec.information16 :=
1090 pqh_ptx_shd.g_old_rec.information16;
1091 End If;
1092 If (p_rec.information17 = hr_api.g_varchar2) then
1093 p_rec.information17 :=
1094 pqh_ptx_shd.g_old_rec.information17;
1095 End If;
1096 If (p_rec.information18 = hr_api.g_varchar2) then
1097 p_rec.information18 :=
1098 pqh_ptx_shd.g_old_rec.information18;
1099 End If;
1100 If (p_rec.information19 = hr_api.g_varchar2) then
1101 p_rec.information19 :=
1102 pqh_ptx_shd.g_old_rec.information19;
1103 End If;
1104 If (p_rec.information20 = hr_api.g_varchar2) then
1105 p_rec.information20 :=
1106 pqh_ptx_shd.g_old_rec.information20;
1107 End If;
1108 If (p_rec.information21 = hr_api.g_varchar2) then
1109 p_rec.information21 :=
1110 pqh_ptx_shd.g_old_rec.information21;
1111 End If;
1112 If (p_rec.information22 = hr_api.g_varchar2) then
1113 p_rec.information22 :=
1114 pqh_ptx_shd.g_old_rec.information22;
1115 End If;
1116 If (p_rec.information23 = hr_api.g_varchar2) then
1117 p_rec.information23 :=
1118 pqh_ptx_shd.g_old_rec.information23;
1119 End If;
1120 If (p_rec.information24 = hr_api.g_varchar2) then
1121 p_rec.information24 :=
1122 pqh_ptx_shd.g_old_rec.information24;
1123 End If;
1124 If (p_rec.information25 = hr_api.g_varchar2) then
1125 p_rec.information25 :=
1126 pqh_ptx_shd.g_old_rec.information25;
1127 End If;
1128 If (p_rec.information26 = hr_api.g_varchar2) then
1129 p_rec.information26 :=
1130 pqh_ptx_shd.g_old_rec.information26;
1131 End If;
1132 If (p_rec.information27 = hr_api.g_varchar2) then
1133 p_rec.information27 :=
1134 pqh_ptx_shd.g_old_rec.information27;
1135 End If;
1136 If (p_rec.information28 = hr_api.g_varchar2) then
1137 p_rec.information28 :=
1138 pqh_ptx_shd.g_old_rec.information28;
1139 End If;
1140 If (p_rec.information29 = hr_api.g_varchar2) then
1141 p_rec.information29 :=
1142 pqh_ptx_shd.g_old_rec.information29;
1143 End If;
1144 If (p_rec.information30 = hr_api.g_varchar2) then
1145 p_rec.information30 :=
1146 pqh_ptx_shd.g_old_rec.information30;
1147 End If;
1148 If (p_rec.information_category = hr_api.g_varchar2) then
1149 p_rec.information_category :=
1150 pqh_ptx_shd.g_old_rec.information_category;
1151 End If;
1152 If (p_rec.attribute1 = hr_api.g_varchar2) then
1153 p_rec.attribute1 :=
1154 pqh_ptx_shd.g_old_rec.attribute1;
1155 End If;
1156 If (p_rec.attribute2 = hr_api.g_varchar2) then
1157 p_rec.attribute2 :=
1158 pqh_ptx_shd.g_old_rec.attribute2;
1159 End If;
1160 If (p_rec.attribute3 = hr_api.g_varchar2) then
1161 p_rec.attribute3 :=
1162 pqh_ptx_shd.g_old_rec.attribute3;
1163 End If;
1164 If (p_rec.attribute4 = hr_api.g_varchar2) then
1165 p_rec.attribute4 :=
1166 pqh_ptx_shd.g_old_rec.attribute4;
1167 End If;
1168 If (p_rec.attribute5 = hr_api.g_varchar2) then
1169 p_rec.attribute5 :=
1170 pqh_ptx_shd.g_old_rec.attribute5;
1171 End If;
1172 If (p_rec.attribute6 = hr_api.g_varchar2) then
1173 p_rec.attribute6 :=
1174 pqh_ptx_shd.g_old_rec.attribute6;
1175 End If;
1176 If (p_rec.attribute7 = hr_api.g_varchar2) then
1177 p_rec.attribute7 :=
1178 pqh_ptx_shd.g_old_rec.attribute7;
1179 End If;
1180 If (p_rec.attribute8 = hr_api.g_varchar2) then
1181 p_rec.attribute8 :=
1182 pqh_ptx_shd.g_old_rec.attribute8;
1183 End If;
1184 If (p_rec.attribute9 = hr_api.g_varchar2) then
1185 p_rec.attribute9 :=
1186 pqh_ptx_shd.g_old_rec.attribute9;
1187 End If;
1188 If (p_rec.attribute10 = hr_api.g_varchar2) then
1189 p_rec.attribute10 :=
1190 pqh_ptx_shd.g_old_rec.attribute10;
1191 End If;
1192 If (p_rec.attribute11 = hr_api.g_varchar2) then
1193 p_rec.attribute11 :=
1194 pqh_ptx_shd.g_old_rec.attribute11;
1195 End If;
1196 If (p_rec.attribute12 = hr_api.g_varchar2) then
1197 p_rec.attribute12 :=
1198 pqh_ptx_shd.g_old_rec.attribute12;
1199 End If;
1200 If (p_rec.attribute13 = hr_api.g_varchar2) then
1201 p_rec.attribute13 :=
1202 pqh_ptx_shd.g_old_rec.attribute13;
1203 End If;
1204 If (p_rec.attribute14 = hr_api.g_varchar2) then
1205 p_rec.attribute14 :=
1206 pqh_ptx_shd.g_old_rec.attribute14;
1207 End If;
1208 If (p_rec.attribute15 = hr_api.g_varchar2) then
1209 p_rec.attribute15 :=
1210 pqh_ptx_shd.g_old_rec.attribute15;
1211 End If;
1212 If (p_rec.attribute16 = hr_api.g_varchar2) then
1213 p_rec.attribute16 :=
1214 pqh_ptx_shd.g_old_rec.attribute16;
1215 End If;
1216 If (p_rec.attribute17 = hr_api.g_varchar2) then
1217 p_rec.attribute17 :=
1218 pqh_ptx_shd.g_old_rec.attribute17;
1219 End If;
1220 If (p_rec.attribute18 = hr_api.g_varchar2) then
1221 p_rec.attribute18 :=
1222 pqh_ptx_shd.g_old_rec.attribute18;
1223 End If;
1224 If (p_rec.attribute19 = hr_api.g_varchar2) then
1225 p_rec.attribute19 :=
1226 pqh_ptx_shd.g_old_rec.attribute19;
1227 End If;
1228 If (p_rec.attribute20 = hr_api.g_varchar2) then
1229 p_rec.attribute20 :=
1230 pqh_ptx_shd.g_old_rec.attribute20;
1231 End If;
1232 If (p_rec.attribute21 = hr_api.g_varchar2) then
1233 p_rec.attribute21 :=
1234 pqh_ptx_shd.g_old_rec.attribute21;
1235 End If;
1236 If (p_rec.attribute22 = hr_api.g_varchar2) then
1237 p_rec.attribute22 :=
1238 pqh_ptx_shd.g_old_rec.attribute22;
1239 End If;
1240 If (p_rec.attribute23 = hr_api.g_varchar2) then
1241 p_rec.attribute23 :=
1242 pqh_ptx_shd.g_old_rec.attribute23;
1243 End If;
1244 If (p_rec.attribute24 = hr_api.g_varchar2) then
1245 p_rec.attribute24 :=
1246 pqh_ptx_shd.g_old_rec.attribute24;
1247 End If;
1248 If (p_rec.attribute25 = hr_api.g_varchar2) then
1249 p_rec.attribute25 :=
1250 pqh_ptx_shd.g_old_rec.attribute25;
1251 End If;
1252 If (p_rec.attribute26 = hr_api.g_varchar2) then
1253 p_rec.attribute26 :=
1254 pqh_ptx_shd.g_old_rec.attribute26;
1255 End If;
1256 If (p_rec.attribute27 = hr_api.g_varchar2) then
1257 p_rec.attribute27 :=
1258 pqh_ptx_shd.g_old_rec.attribute27;
1259 End If;
1260 If (p_rec.attribute28 = hr_api.g_varchar2) then
1261 p_rec.attribute28 :=
1262 pqh_ptx_shd.g_old_rec.attribute28;
1263 End If;
1264 If (p_rec.attribute29 = hr_api.g_varchar2) then
1265 p_rec.attribute29 :=
1266 pqh_ptx_shd.g_old_rec.attribute29;
1267 End If;
1268 If (p_rec.attribute30 = hr_api.g_varchar2) then
1269 p_rec.attribute30 :=
1270 pqh_ptx_shd.g_old_rec.attribute30;
1271 End If;
1272 If (p_rec.attribute_category = hr_api.g_varchar2) then
1273 p_rec.attribute_category :=
1274 pqh_ptx_shd.g_old_rec.attribute_category;
1275 End If;
1276 If (p_rec.pay_basis_id = hr_api.g_number) then
1277 p_rec.pay_basis_id :=
1278 pqh_ptx_shd.g_old_rec.pay_basis_id;
1279 End If;
1280 If (p_rec.supervisor_id = hr_api.g_number) then
1281 p_rec.supervisor_id :=
1282 pqh_ptx_shd.g_old_rec.supervisor_id;
1283 End If;
1284 If (p_rec.wf_transaction_category_id = hr_api.g_number) then
1285 p_rec.wf_transaction_category_id :=
1286 pqh_ptx_shd.g_old_rec.wf_transaction_category_id;
1287 End If;
1288
1289 --
1290 hr_utility.set_location(' Leaving:'||l_proc, 10);
1291 --
1292 End convert_defs;
1293 --
1294 -- ----------------------------------------------------------------------------
1295 -- |---------------------------------< upd >----------------------------------|
1296 -- ----------------------------------------------------------------------------
1297 Procedure upd
1298 (
1299 p_effective_date in date,
1300 p_rec in out nocopy pqh_ptx_shd.g_rec_type
1301 ) is
1302 --
1303 l_proc varchar2(72) := g_package||'upd';
1304 --
1305 Begin
1306 hr_utility.set_location('Entering:'||l_proc, 5);
1307 --
1308 -- We must lock the row which we need to update.
1309 --
1310 pqh_ptx_shd.lck
1311 (
1312 p_rec.position_transaction_id,
1313 p_rec.object_version_number
1314 );
1315 --
1316 -- 1. During an update system defaults are used to determine if
1317 -- arguments have been defaulted or not. We must therefore
1318 -- derive the full record structure values to be updated.
1319 --
1320 -- 2. Call the supporting update validate operations.
1321 --
1322 convert_defs(p_rec);
1323 pqh_ptx_bus.update_validate(p_rec
1324 ,p_effective_date);
1325 --
1326 -- Call the supporting pre-update operation
1327 --
1328 pre_update(p_rec);
1329 --
1330 -- Update the row.
1331 --
1332 update_dml(p_rec);
1333 --
1334 -- Call the supporting post-update operation
1335 --
1336 post_update(
1337 p_effective_date,p_rec);
1338 End upd;
1339 --
1340 -- ----------------------------------------------------------------------------
1341 -- |---------------------------------< upd >----------------------------------|
1342 -- ----------------------------------------------------------------------------
1343 Procedure upd
1344 (
1345 p_effective_date in date,
1346 p_position_transaction_id in number,
1347 p_action_date in date default hr_api.g_date,
1348 p_position_id in number default hr_api.g_number,
1349 p_availability_status_id in number default hr_api.g_number,
1350 p_business_group_id in number default hr_api.g_number,
1351 p_entry_step_id in number default hr_api.g_number,
1352 p_entry_grade_rule_id in number default hr_api.g_number,
1353 p_job_id in number default hr_api.g_number,
1354 p_location_id in number default hr_api.g_number,
1355 p_organization_id in number default hr_api.g_number,
1356 p_pay_freq_payroll_id in number default hr_api.g_number,
1357 p_position_definition_id in number default hr_api.g_number,
1358 p_prior_position_id in number default hr_api.g_number,
1359 p_relief_position_id in number default hr_api.g_number,
1360 p_entry_grade_id in number default hr_api.g_number,
1361 p_successor_position_id in number default hr_api.g_number,
1362 p_supervisor_position_id in number default hr_api.g_number,
1363 p_amendment_date in date default hr_api.g_date,
1364 p_amendment_recommendation in varchar2 default hr_api.g_varchar2,
1365 p_amendment_ref_number in varchar2 default hr_api.g_varchar2,
1366 p_avail_status_prop_end_date in date default hr_api.g_date,
1367 p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2,
1368 p_comments in varchar2 default hr_api.g_varchar2,
1369 p_country1 in varchar2 default hr_api.g_varchar2,
1370 p_country2 in varchar2 default hr_api.g_varchar2,
1371 p_country3 in varchar2 default hr_api.g_varchar2,
1372 p_current_job_prop_end_date in date default hr_api.g_date,
1373 p_current_org_prop_end_date in date default hr_api.g_date,
1374 p_date_effective in date default hr_api.g_date,
1375 p_date_end in date default hr_api.g_date,
1376 p_earliest_hire_date in date default hr_api.g_date,
1377 p_fill_by_date in date default hr_api.g_date,
1378 p_frequency in varchar2 default hr_api.g_varchar2,
1379 p_fte in number default hr_api.g_number,
1380 p_fte_capacity in varchar2 default hr_api.g_varchar2,
1381 p_location1 in varchar2 default hr_api.g_varchar2,
1382 p_location2 in varchar2 default hr_api.g_varchar2,
1383 p_location3 in varchar2 default hr_api.g_varchar2,
1384 p_max_persons in number default hr_api.g_number,
1385 p_name in varchar2 default hr_api.g_varchar2,
1386 p_other_requirements in varchar2 default hr_api.g_varchar2,
1387 p_overlap_period in number default hr_api.g_number,
1388 p_overlap_unit_cd in varchar2 default hr_api.g_varchar2,
1389 p_passport_required in varchar2 default hr_api.g_varchar2,
1390 p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1391 p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1392 p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2,
1393 p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2,
1394 p_position_type in varchar2 default hr_api.g_varchar2,
1395 p_posting_description in varchar2 default hr_api.g_varchar2,
1396 p_probation_period in number default hr_api.g_number,
1397 p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2,
1398 p_relocate_domestically in varchar2 default hr_api.g_varchar2,
1399 p_relocate_internationally in varchar2 default hr_api.g_varchar2,
1400 p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
1401 p_review_flag in varchar2 default hr_api.g_varchar2,
1402 p_seasonal_flag in varchar2 default hr_api.g_varchar2,
1403 p_security_requirements in varchar2 default hr_api.g_varchar2,
1404 p_service_minimum in varchar2 default hr_api.g_varchar2,
1405 p_term_start_day_cd in varchar2 default hr_api.g_varchar2,
1406 p_term_start_month_cd in varchar2 default hr_api.g_varchar2,
1407 p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1408 p_time_normal_start in varchar2 default hr_api.g_varchar2,
1409 p_transaction_status in varchar2 default hr_api.g_varchar2,
1410 p_travel_required in varchar2 default hr_api.g_varchar2,
1411 p_working_hours in number default hr_api.g_number,
1412 p_works_council_approval_flag in varchar2 default hr_api.g_varchar2,
1413 p_work_any_country in varchar2 default hr_api.g_varchar2,
1414 p_work_any_location in varchar2 default hr_api.g_varchar2,
1415 p_work_period_type_cd in varchar2 default hr_api.g_varchar2,
1416 p_work_schedule in varchar2 default hr_api.g_varchar2,
1417 p_work_duration in varchar2 default hr_api.g_varchar2,
1418 p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1419 p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1420 p_proposed_fte_for_layoff in number default hr_api.g_number,
1421 p_proposed_date_for_layoff in date default hr_api.g_date,
1422 p_information1 in varchar2 default hr_api.g_varchar2,
1423 p_information2 in varchar2 default hr_api.g_varchar2,
1424 p_information3 in varchar2 default hr_api.g_varchar2,
1425 p_information4 in varchar2 default hr_api.g_varchar2,
1426 p_information5 in varchar2 default hr_api.g_varchar2,
1427 p_information6 in varchar2 default hr_api.g_varchar2,
1428 p_information7 in varchar2 default hr_api.g_varchar2,
1429 p_information8 in varchar2 default hr_api.g_varchar2,
1430 p_information9 in varchar2 default hr_api.g_varchar2,
1431 p_information10 in varchar2 default hr_api.g_varchar2,
1432 p_information11 in varchar2 default hr_api.g_varchar2,
1433 p_information12 in varchar2 default hr_api.g_varchar2,
1434 p_information13 in varchar2 default hr_api.g_varchar2,
1435 p_information14 in varchar2 default hr_api.g_varchar2,
1436 p_information15 in varchar2 default hr_api.g_varchar2,
1437 p_information16 in varchar2 default hr_api.g_varchar2,
1438 p_information17 in varchar2 default hr_api.g_varchar2,
1439 p_information18 in varchar2 default hr_api.g_varchar2,
1440 p_information19 in varchar2 default hr_api.g_varchar2,
1441 p_information20 in varchar2 default hr_api.g_varchar2,
1442 p_information21 in varchar2 default hr_api.g_varchar2,
1443 p_information22 in varchar2 default hr_api.g_varchar2,
1444 p_information23 in varchar2 default hr_api.g_varchar2,
1445 p_information24 in varchar2 default hr_api.g_varchar2,
1446 p_information25 in varchar2 default hr_api.g_varchar2,
1447 p_information26 in varchar2 default hr_api.g_varchar2,
1448 p_information27 in varchar2 default hr_api.g_varchar2,
1449 p_information28 in varchar2 default hr_api.g_varchar2,
1450 p_information29 in varchar2 default hr_api.g_varchar2,
1451 p_information30 in varchar2 default hr_api.g_varchar2,
1452 p_information_category in varchar2 default hr_api.g_varchar2,
1453 p_attribute1 in varchar2 default hr_api.g_varchar2,
1454 p_attribute2 in varchar2 default hr_api.g_varchar2,
1455 p_attribute3 in varchar2 default hr_api.g_varchar2,
1456 p_attribute4 in varchar2 default hr_api.g_varchar2,
1457 p_attribute5 in varchar2 default hr_api.g_varchar2,
1458 p_attribute6 in varchar2 default hr_api.g_varchar2,
1459 p_attribute7 in varchar2 default hr_api.g_varchar2,
1460 p_attribute8 in varchar2 default hr_api.g_varchar2,
1461 p_attribute9 in varchar2 default hr_api.g_varchar2,
1462 p_attribute10 in varchar2 default hr_api.g_varchar2,
1463 p_attribute11 in varchar2 default hr_api.g_varchar2,
1464 p_attribute12 in varchar2 default hr_api.g_varchar2,
1465 p_attribute13 in varchar2 default hr_api.g_varchar2,
1466 p_attribute14 in varchar2 default hr_api.g_varchar2,
1467 p_attribute15 in varchar2 default hr_api.g_varchar2,
1468 p_attribute16 in varchar2 default hr_api.g_varchar2,
1469 p_attribute17 in varchar2 default hr_api.g_varchar2,
1470 p_attribute18 in varchar2 default hr_api.g_varchar2,
1471 p_attribute19 in varchar2 default hr_api.g_varchar2,
1472 p_attribute20 in varchar2 default hr_api.g_varchar2,
1473 p_attribute21 in varchar2 default hr_api.g_varchar2,
1474 p_attribute22 in varchar2 default hr_api.g_varchar2,
1475 p_attribute23 in varchar2 default hr_api.g_varchar2,
1476 p_attribute24 in varchar2 default hr_api.g_varchar2,
1477 p_attribute25 in varchar2 default hr_api.g_varchar2,
1478 p_attribute26 in varchar2 default hr_api.g_varchar2,
1479 p_attribute27 in varchar2 default hr_api.g_varchar2,
1480 p_attribute28 in varchar2 default hr_api.g_varchar2,
1481 p_attribute29 in varchar2 default hr_api.g_varchar2,
1482 p_attribute30 in varchar2 default hr_api.g_varchar2,
1483 p_attribute_category in varchar2 default hr_api.g_varchar2,
1484 p_object_version_number in out nocopy number ,
1485 p_pay_basis_id in number default hr_api.g_number,
1486 p_supervisor_id in number default hr_api.g_number,
1487 p_wf_transaction_category_id in number default hr_api.g_number
1488 ) is
1489 --
1490 l_rec pqh_ptx_shd.g_rec_type;
1491 l_proc varchar2(72) := g_package||'upd';
1492 --
1493 Begin
1494 hr_utility.set_location('Entering:'||l_proc, 5);
1495 --
1496 -- Call conversion function to turn arguments into the
1497 -- l_rec structure.
1498 --
1499 l_rec :=
1500 pqh_ptx_shd.convert_args
1501 (
1502 p_position_transaction_id,
1503 p_action_date,
1504 p_position_id,
1505 p_availability_status_id,
1506 p_business_group_id,
1507 p_entry_step_id,
1508 p_entry_grade_rule_id,
1509 p_job_id,
1510 p_location_id,
1511 p_organization_id,
1512 p_pay_freq_payroll_id,
1513 p_position_definition_id,
1514 p_prior_position_id,
1515 p_relief_position_id,
1516 p_entry_grade_id,
1517 p_successor_position_id,
1518 p_supervisor_position_id,
1519 p_amendment_date,
1520 p_amendment_recommendation,
1521 p_amendment_ref_number,
1522 p_avail_status_prop_end_date,
1523 p_bargaining_unit_cd,
1524 p_comments,
1525 p_country1,
1526 p_country2,
1527 p_country3,
1528 p_current_job_prop_end_date,
1529 p_current_org_prop_end_date,
1530 p_date_effective,
1531 p_date_end,
1532 p_earliest_hire_date,
1533 p_fill_by_date,
1534 p_frequency,
1535 p_fte,
1536 p_fte_capacity,
1537 p_location1,
1538 p_location2,
1539 p_location3,
1540 p_max_persons,
1541 p_name,
1542 p_other_requirements,
1543 p_overlap_period,
1544 p_overlap_unit_cd,
1545 p_passport_required,
1546 p_pay_term_end_day_cd,
1547 p_pay_term_end_month_cd,
1548 p_permanent_temporary_flag,
1549 p_permit_recruitment_flag,
1550 p_position_type,
1551 p_posting_description,
1552 p_probation_period,
1553 p_probation_period_unit_cd,
1554 p_relocate_domestically,
1555 p_relocate_internationally,
1556 p_replacement_required_flag,
1557 p_review_flag,
1558 p_seasonal_flag,
1559 p_security_requirements,
1560 p_service_minimum,
1561 p_term_start_day_cd,
1562 p_term_start_month_cd,
1563 p_time_normal_finish,
1564 p_time_normal_start,
1565 p_transaction_status,
1566 p_travel_required,
1567 p_working_hours,
1568 p_works_council_approval_flag,
1569 p_work_any_country,
1570 p_work_any_location,
1571 p_work_period_type_cd,
1572 p_work_schedule,
1573 p_work_duration,
1574 p_work_term_end_day_cd,
1575 p_work_term_end_month_cd,
1576 p_proposed_fte_for_layoff,
1577 p_proposed_date_for_layoff,
1578 p_information1,
1579 p_information2,
1580 p_information3,
1581 p_information4,
1582 p_information5,
1583 p_information6,
1584 p_information7,
1585 p_information8,
1586 p_information9,
1587 p_information10,
1588 p_information11,
1589 p_information12,
1590 p_information13,
1591 p_information14,
1592 p_information15,
1593 p_information16,
1594 p_information17,
1595 p_information18,
1596 p_information19,
1597 p_information20,
1598 p_information21,
1599 p_information22,
1600 p_information23,
1601 p_information24,
1602 p_information25,
1603 p_information26,
1604 p_information27,
1605 p_information28,
1606 p_information29,
1607 p_information30,
1608 p_information_category,
1609 p_attribute1,
1610 p_attribute2,
1611 p_attribute3,
1612 p_attribute4,
1613 p_attribute5,
1614 p_attribute6,
1615 p_attribute7,
1616 p_attribute8,
1617 p_attribute9,
1618 p_attribute10,
1619 p_attribute11,
1620 p_attribute12,
1621 p_attribute13,
1622 p_attribute14,
1623 p_attribute15,
1624 p_attribute16,
1625 p_attribute17,
1626 p_attribute18,
1627 p_attribute19,
1628 p_attribute20,
1629 p_attribute21,
1630 p_attribute22,
1631 p_attribute23,
1632 p_attribute24,
1633 p_attribute25,
1634 p_attribute26,
1635 p_attribute27,
1636 p_attribute28,
1637 p_attribute29,
1638 p_attribute30,
1639 p_attribute_category,
1640 p_object_version_number,
1641 p_pay_basis_id,
1642 p_supervisor_id,
1643 p_wf_transaction_category_id
1644 );
1645 --
1646 -- Having converted the arguments into the
1647 -- plsql record structure we call the corresponding record
1648 -- business process.
1649 --
1650 upd(
1651 p_effective_date,l_rec);
1652 p_object_version_number := l_rec.object_version_number;
1653 --
1654 hr_utility.set_location(' Leaving:'||l_proc, 10);
1655 End upd;
1656 --
1657 end pqh_ptx_upd;