[Home] [Help]
PACKAGE BODY: APPS.PQH_POSITION_TRANSACTIONS_API
Source
1 Package Body pqh_position_transactions_api as
2 /* $Header: pqptxapi.pkb 115.12 2002/12/06 18:07:14 rpasapul ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' pqh_position_transactions_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_position_transaction >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_position_transaction
13 (p_validate in boolean default false
14 ,p_position_transaction_id out nocopy number
15 ,p_action_date in date default null
16 ,p_position_id in number default null
17 ,p_availability_status_id in number default null
18 ,p_business_group_id in number default null
19 ,p_entry_step_id in number default null
20 ,p_entry_grade_rule_id in number default null
21 ,p_job_id in number default null
22 ,p_location_id in number default null
23 ,p_organization_id in number default null
24 ,p_pay_freq_payroll_id in number default null
25 ,p_position_definition_id in number default null
26 ,p_prior_position_id in number default null
27 ,p_relief_position_id in number default null
28 ,p_entry_grade_id in number default null
29 ,p_successor_position_id in number default null
30 ,p_supervisor_position_id in number default null
31 ,p_amendment_date in date default null
32 ,p_amendment_recommendation in varchar2 default null
33 ,p_amendment_ref_number in varchar2 default null
34 ,p_avail_status_prop_end_date in date default null
35 ,p_bargaining_unit_cd in varchar2 default null
36 ,p_comments in long default null
37 ,p_country1 in varchar2 default null
38 ,p_country2 in varchar2 default null
39 ,p_country3 in varchar2 default null
40 ,p_current_job_prop_end_date in date default null
41 ,p_current_org_prop_end_date in date default null
42 ,p_date_effective in date default null
43 ,p_date_end in date default null
44 ,p_earliest_hire_date in date default null
45 ,p_fill_by_date in date default null
46 ,p_frequency in varchar2 default null
47 ,p_fte in number default null
48 ,p_fte_capacity in varchar2 default null
49 ,p_location1 in varchar2 default null
50 ,p_location2 in varchar2 default null
51 ,p_location3 in varchar2 default null
52 ,p_max_persons in number default null
53 ,p_name in varchar2 default null
54 ,p_other_requirements in varchar2 default null
55 ,p_overlap_period in number default null
56 ,p_overlap_unit_cd in varchar2 default null
57 ,p_passport_required in varchar2 default null
58 ,p_pay_term_end_day_cd in varchar2 default null
59 ,p_pay_term_end_month_cd in varchar2 default null
60 ,p_permanent_temporary_flag in varchar2 default null
61 ,p_permit_recruitment_flag in varchar2 default null
62 ,p_position_type in varchar2 default null
63 ,p_posting_description in varchar2 default null
64 ,p_probation_period in number default null
65 ,p_probation_period_unit_cd in varchar2 default null
66 ,p_relocate_domestically in varchar2 default null
67 ,p_relocate_internationally in varchar2 default null
68 ,p_replacement_required_flag in varchar2 default null
69 ,p_review_flag in varchar2 default null
70 ,p_seasonal_flag in varchar2 default null
71 ,p_security_requirements in varchar2 default null
72 ,p_service_minimum in varchar2 default null
73 ,p_term_start_day_cd in varchar2 default null
74 ,p_term_start_month_cd in varchar2 default null
75 ,p_time_normal_finish in varchar2 default null
76 ,p_time_normal_start in varchar2 default null
77 ,p_transaction_status in varchar2 default null
78 ,p_travel_required in varchar2 default null
79 ,p_working_hours in number default null
80 ,p_works_council_approval_flag in varchar2 default null
81 ,p_work_any_country in varchar2 default null
82 ,p_work_any_location in varchar2 default null
83 ,p_work_period_type_cd in varchar2 default null
84 ,p_work_schedule in varchar2 default null
85 ,p_work_duration in varchar2 default null
86 ,p_work_term_end_day_cd in varchar2 default null
87 ,p_work_term_end_month_cd in varchar2 default null
88 ,p_proposed_fte_for_layoff in number default null
89 ,p_proposed_date_for_layoff in date default null
90 ,p_information1 in varchar2 default null
91 ,p_information2 in varchar2 default null
92 ,p_information3 in varchar2 default null
93 ,p_information4 in varchar2 default null
94 ,p_information5 in varchar2 default null
95 ,p_information6 in varchar2 default null
96 ,p_information7 in varchar2 default null
97 ,p_information8 in varchar2 default null
98 ,p_information9 in varchar2 default null
99 ,p_information10 in varchar2 default null
100 ,p_information11 in varchar2 default null
101 ,p_information12 in varchar2 default null
102 ,p_information13 in varchar2 default null
103 ,p_information14 in varchar2 default null
104 ,p_information15 in varchar2 default null
105 ,p_information16 in varchar2 default null
106 ,p_information17 in varchar2 default null
107 ,p_information18 in varchar2 default null
108 ,p_information19 in varchar2 default null
109 ,p_information20 in varchar2 default null
110 ,p_information21 in varchar2 default null
111 ,p_information22 in varchar2 default null
112 ,p_information23 in varchar2 default null
113 ,p_information24 in varchar2 default null
114 ,p_information25 in varchar2 default null
115 ,p_information26 in varchar2 default null
116 ,p_information27 in varchar2 default null
117 ,p_information28 in varchar2 default null
118 ,p_information29 in varchar2 default null
119 ,p_information30 in varchar2 default null
120 ,p_information_category in varchar2 default null
121 ,p_attribute1 in varchar2 default null
122 ,p_attribute2 in varchar2 default null
123 ,p_attribute3 in varchar2 default null
124 ,p_attribute4 in varchar2 default null
125 ,p_attribute5 in varchar2 default null
126 ,p_attribute6 in varchar2 default null
127 ,p_attribute7 in varchar2 default null
128 ,p_attribute8 in varchar2 default null
129 ,p_attribute9 in varchar2 default null
130 ,p_attribute10 in varchar2 default null
131 ,p_attribute11 in varchar2 default null
132 ,p_attribute12 in varchar2 default null
133 ,p_attribute13 in varchar2 default null
134 ,p_attribute14 in varchar2 default null
135 ,p_attribute15 in varchar2 default null
136 ,p_attribute16 in varchar2 default null
137 ,p_attribute17 in varchar2 default null
138 ,p_attribute18 in varchar2 default null
139 ,p_attribute19 in varchar2 default null
140 ,p_attribute20 in varchar2 default null
141 ,p_attribute21 in varchar2 default null
142 ,p_attribute22 in varchar2 default null
143 ,p_attribute23 in varchar2 default null
144 ,p_attribute24 in varchar2 default null
145 ,p_attribute25 in varchar2 default null
146 ,p_attribute26 in varchar2 default null
147 ,p_attribute27 in varchar2 default null
148 ,p_attribute28 in varchar2 default null
149 ,p_attribute29 in varchar2 default null
150 ,p_attribute30 in varchar2 default null
151 ,p_attribute_category in varchar2 default null
152 ,p_object_version_number out nocopy number
153 ,p_effective_date in date
154 ,p_pay_basis_id in number default null
155 ,p_supervisor_id in number default null
156 ,p_wf_transaction_category_id in number default null
157 ) is
158 --
159 -- Declare cursors and local variables
160 --
161 l_position_transaction_id pqh_position_transactions.position_transaction_id%TYPE;
162 l_proc varchar2(72) := g_package||'create_position_transaction';
163 l_object_version_number pqh_position_transactions.object_version_number%TYPE;
164 --
165 begin
166 --
167 hr_utility.set_location('Entering:'|| l_proc, 10);
168 --
169 -- Issue a savepoint if operating in validation only mode
170 --
171 savepoint create_position_transaction;
172 --
173 hr_utility.set_location(l_proc, 20);
174 --
175 -- Process Logic
176 --
177 begin
178 --
179 -- Start of API User Hook for the before hook of create_position_transaction
180 --
181 pqh_position_transactions_bk1.create_position_transaction_b
182 (
183 p_action_date => p_action_date
184 ,p_position_id => p_position_id
185 ,p_availability_status_id => p_availability_status_id
186 ,p_business_group_id => p_business_group_id
187 ,p_entry_step_id => p_entry_step_id
188 ,p_entry_grade_rule_id => p_entry_grade_rule_id
189 ,p_job_id => p_job_id
190 ,p_location_id => p_location_id
191 ,p_organization_id => p_organization_id
192 ,p_pay_freq_payroll_id => p_pay_freq_payroll_id
193 ,p_position_definition_id => p_position_definition_id
194 ,p_prior_position_id => p_prior_position_id
195 ,p_relief_position_id => p_relief_position_id
196 ,p_entry_grade_id => p_entry_grade_id
197 ,p_successor_position_id => p_successor_position_id
198 ,p_supervisor_position_id => p_supervisor_position_id
199 ,p_amendment_date => p_amendment_date
200 ,p_amendment_recommendation => p_amendment_recommendation
201 ,p_amendment_ref_number => p_amendment_ref_number
202 ,p_avail_status_prop_end_date => p_avail_status_prop_end_date
203 ,p_bargaining_unit_cd => p_bargaining_unit_cd
204 ,p_comments => p_comments
205 ,p_country1 => p_country1
206 ,p_country2 => p_country2
207 ,p_country3 => p_country3
208 ,p_current_job_prop_end_date => p_current_job_prop_end_date
209 ,p_current_org_prop_end_date => p_current_org_prop_end_date
210 ,p_date_effective => p_date_effective
211 ,p_date_end => p_date_end
212 ,p_earliest_hire_date => p_earliest_hire_date
213 ,p_fill_by_date => p_fill_by_date
214 ,p_frequency => p_frequency
215 ,p_fte => p_fte
216 ,p_fte_capacity => p_fte_capacity
217 ,p_location1 => p_location1
218 ,p_location2 => p_location2
219 ,p_location3 => p_location3
220 ,p_max_persons => p_max_persons
221 ,p_name => p_name
222 ,p_other_requirements => p_other_requirements
223 ,p_overlap_period => p_overlap_period
224 ,p_overlap_unit_cd => p_overlap_unit_cd
225 ,p_passport_required => p_passport_required
226 ,p_pay_term_end_day_cd => p_pay_term_end_day_cd
227 ,p_pay_term_end_month_cd => p_pay_term_end_month_cd
228 ,p_permanent_temporary_flag => p_permanent_temporary_flag
229 ,p_permit_recruitment_flag => p_permit_recruitment_flag
230 ,p_position_type => p_position_type
231 ,p_posting_description => p_posting_description
232 ,p_probation_period => p_probation_period
233 ,p_probation_period_unit_cd => p_probation_period_unit_cd
234 ,p_relocate_domestically => p_relocate_domestically
235 ,p_relocate_internationally => p_relocate_internationally
236 ,p_replacement_required_flag => p_replacement_required_flag
237 ,p_review_flag => p_review_flag
238 ,p_seasonal_flag => p_seasonal_flag
239 ,p_security_requirements => p_security_requirements
243 ,p_time_normal_finish => p_time_normal_finish
240 ,p_service_minimum => p_service_minimum
241 ,p_term_start_day_cd => p_term_start_day_cd
242 ,p_term_start_month_cd => p_term_start_month_cd
244 ,p_time_normal_start => p_time_normal_start
245 ,p_transaction_status => p_transaction_status
246 ,p_travel_required => p_travel_required
247 ,p_working_hours => p_working_hours
248 ,p_works_council_approval_flag => p_works_council_approval_flag
249 ,p_work_any_country => p_work_any_country
250 ,p_work_any_location => p_work_any_location
251 ,p_work_period_type_cd => p_work_period_type_cd
252 ,p_work_schedule => p_work_schedule
253 ,p_work_duration => p_work_duration
254 ,p_work_term_end_day_cd => p_work_term_end_day_cd
255 ,p_work_term_end_month_cd => p_work_term_end_month_cd
256 ,p_proposed_fte_for_layoff => p_proposed_fte_for_layoff
257 ,p_proposed_date_for_layoff => p_proposed_date_for_layoff
258 ,p_information1 => p_information1
259 ,p_information2 => p_information2
260 ,p_information3 => p_information3
261 ,p_information4 => p_information4
262 ,p_information5 => p_information5
263 ,p_information6 => p_information6
264 ,p_information7 => p_information7
265 ,p_information8 => p_information8
266 ,p_information9 => p_information9
267 ,p_information10 => p_information10
268 ,p_information11 => p_information11
269 ,p_information12 => p_information12
270 ,p_information13 => p_information13
271 ,p_information14 => p_information14
272 ,p_information15 => p_information15
273 ,p_information16 => p_information16
274 ,p_information17 => p_information17
275 ,p_information18 => p_information18
276 ,p_information19 => p_information19
277 ,p_information20 => p_information20
278 ,p_information21 => p_information21
279 ,p_information22 => p_information22
280 ,p_information23 => p_information23
281 ,p_information24 => p_information24
282 ,p_information25 => p_information25
283 ,p_information26 => p_information26
284 ,p_information27 => p_information27
285 ,p_information28 => p_information28
286 ,p_information29 => p_information29
287 ,p_information30 => p_information30
288 ,p_information_category => p_information_category
289 ,p_attribute1 => p_attribute1
290 ,p_attribute2 => p_attribute2
291 ,p_attribute3 => p_attribute3
292 ,p_attribute4 => p_attribute4
293 ,p_attribute5 => p_attribute5
294 ,p_attribute6 => p_attribute6
295 ,p_attribute7 => p_attribute7
296 ,p_attribute8 => p_attribute8
297 ,p_attribute9 => p_attribute9
298 ,p_attribute10 => p_attribute10
299 ,p_attribute11 => p_attribute11
300 ,p_attribute12 => p_attribute12
301 ,p_attribute13 => p_attribute13
302 ,p_attribute14 => p_attribute14
303 ,p_attribute15 => p_attribute15
304 ,p_attribute16 => p_attribute16
305 ,p_attribute17 => p_attribute17
306 ,p_attribute18 => p_attribute18
307 ,p_attribute19 => p_attribute19
308 ,p_attribute20 => p_attribute20
309 ,p_attribute21 => p_attribute21
310 ,p_attribute22 => p_attribute22
311 ,p_attribute23 => p_attribute23
312 ,p_attribute24 => p_attribute24
313 ,p_attribute25 => p_attribute25
314 ,p_attribute26 => p_attribute26
315 ,p_attribute27 => p_attribute27
316 ,p_attribute28 => p_attribute28
317 ,p_attribute29 => p_attribute29
318 ,p_attribute30 => p_attribute30
319 ,p_attribute_category => p_attribute_category
320 ,p_effective_date => trunc(p_effective_date)
321 ,p_pay_basis_id => p_pay_basis_id
322 ,p_supervisor_id => p_supervisor_id
323 ,p_wf_transaction_category_id => p_wf_transaction_category_id
324 );
325 exception
326 when hr_api.cannot_find_prog_unit then
327 hr_api.cannot_find_prog_unit_error
328 (
329 p_module_name => 'CREATE_POSITION_TRANSACTION'
330 ,p_hook_type => 'BP'
331 );
332 --
333 -- End of API User Hook for the before hook of create_position_transaction
334 --
335 end;
336 --
337 pqh_ptx_ins.ins
341 ,p_position_id => p_position_id
338 (
339 p_position_transaction_id => l_position_transaction_id
340 ,p_action_date => p_action_date
342 ,p_availability_status_id => p_availability_status_id
343 ,p_business_group_id => p_business_group_id
344 ,p_entry_step_id => p_entry_step_id
345 ,p_entry_grade_rule_id => p_entry_grade_rule_id
346 ,p_job_id => p_job_id
347 ,p_location_id => p_location_id
348 ,p_organization_id => p_organization_id
349 ,p_pay_freq_payroll_id => p_pay_freq_payroll_id
350 ,p_position_definition_id => p_position_definition_id
351 ,p_prior_position_id => p_prior_position_id
352 ,p_relief_position_id => p_relief_position_id
353 ,p_entry_grade_id => p_entry_grade_id
354 ,p_successor_position_id => p_successor_position_id
355 ,p_supervisor_position_id => p_supervisor_position_id
356 ,p_amendment_date => p_amendment_date
357 ,p_amendment_recommendation => p_amendment_recommendation
358 ,p_amendment_ref_number => p_amendment_ref_number
359 ,p_avail_status_prop_end_date => p_avail_status_prop_end_date
360 ,p_bargaining_unit_cd => p_bargaining_unit_cd
361 ,p_comments => p_comments
362 ,p_country1 => p_country1
363 ,p_country2 => p_country2
364 ,p_country3 => p_country3
365 ,p_current_job_prop_end_date => p_current_job_prop_end_date
366 ,p_current_org_prop_end_date => p_current_org_prop_end_date
367 ,p_date_effective => p_date_effective
368 ,p_date_end => p_date_end
369 ,p_earliest_hire_date => p_earliest_hire_date
370 ,p_fill_by_date => p_fill_by_date
371 ,p_frequency => p_frequency
372 ,p_fte => p_fte
373 ,p_fte_capacity => p_fte_capacity
374 ,p_location1 => p_location1
375 ,p_location2 => p_location2
376 ,p_location3 => p_location3
377 ,p_max_persons => p_max_persons
378 ,p_name => p_name
379 ,p_other_requirements => p_other_requirements
380 ,p_overlap_period => p_overlap_period
381 ,p_overlap_unit_cd => p_overlap_unit_cd
382 ,p_passport_required => p_passport_required
383 ,p_pay_term_end_day_cd => p_pay_term_end_day_cd
384 ,p_pay_term_end_month_cd => p_pay_term_end_month_cd
385 ,p_permanent_temporary_flag => p_permanent_temporary_flag
386 ,p_permit_recruitment_flag => p_permit_recruitment_flag
387 ,p_position_type => p_position_type
388 ,p_posting_description => p_posting_description
389 ,p_probation_period => p_probation_period
390 ,p_probation_period_unit_cd => p_probation_period_unit_cd
391 ,p_relocate_domestically => p_relocate_domestically
392 ,p_relocate_internationally => p_relocate_internationally
393 ,p_replacement_required_flag => p_replacement_required_flag
394 ,p_review_flag => p_review_flag
395 ,p_seasonal_flag => p_seasonal_flag
396 ,p_security_requirements => p_security_requirements
397 ,p_service_minimum => p_service_minimum
398 ,p_term_start_day_cd => p_term_start_day_cd
399 ,p_term_start_month_cd => p_term_start_month_cd
400 ,p_time_normal_finish => p_time_normal_finish
401 ,p_time_normal_start => p_time_normal_start
402 ,p_transaction_status => p_transaction_status
403 ,p_travel_required => p_travel_required
404 ,p_working_hours => p_working_hours
405 ,p_works_council_approval_flag => p_works_council_approval_flag
406 ,p_work_any_country => p_work_any_country
407 ,p_work_any_location => p_work_any_location
408 ,p_work_period_type_cd => p_work_period_type_cd
409 ,p_work_schedule => p_work_schedule
410 ,p_work_duration => p_work_duration
411 ,p_work_term_end_day_cd => p_work_term_end_day_cd
412 ,p_work_term_end_month_cd => p_work_term_end_month_cd
413 ,p_proposed_fte_for_layoff => p_proposed_fte_for_layoff
414 ,p_proposed_date_for_layoff => p_proposed_date_for_layoff
415 ,p_information1 => p_information1
416 ,p_information2 => p_information2
417 ,p_information3 => p_information3
418 ,p_information4 => p_information4
419 ,p_information5 => p_information5
420 ,p_information6 => p_information6
421 ,p_information7 => p_information7
422 ,p_information8 => p_information8
423 ,p_information9 => p_information9
424 ,p_information10 => p_information10
425 ,p_information11 => p_information11
426 ,p_information12 => p_information12
427 ,p_information13 => p_information13
428 ,p_information14 => p_information14
429 ,p_information15 => p_information15
430 ,p_information16 => p_information16
431 ,p_information17 => p_information17
435 ,p_information21 => p_information21
432 ,p_information18 => p_information18
433 ,p_information19 => p_information19
434 ,p_information20 => p_information20
436 ,p_information22 => p_information22
437 ,p_information23 => p_information23
438 ,p_information24 => p_information24
439 ,p_information25 => p_information25
440 ,p_information26 => p_information26
441 ,p_information27 => p_information27
442 ,p_information28 => p_information28
443 ,p_information29 => p_information29
444 ,p_information30 => p_information30
445 ,p_information_category => p_information_category
446 ,p_attribute1 => p_attribute1
447 ,p_attribute2 => p_attribute2
448 ,p_attribute3 => p_attribute3
449 ,p_attribute4 => p_attribute4
450 ,p_attribute5 => p_attribute5
451 ,p_attribute6 => p_attribute6
452 ,p_attribute7 => p_attribute7
453 ,p_attribute8 => p_attribute8
454 ,p_attribute9 => p_attribute9
455 ,p_attribute10 => p_attribute10
456 ,p_attribute11 => p_attribute11
457 ,p_attribute12 => p_attribute12
458 ,p_attribute13 => p_attribute13
459 ,p_attribute14 => p_attribute14
460 ,p_attribute15 => p_attribute15
461 ,p_attribute16 => p_attribute16
462 ,p_attribute17 => p_attribute17
463 ,p_attribute18 => p_attribute18
464 ,p_attribute19 => p_attribute19
465 ,p_attribute20 => p_attribute20
466 ,p_attribute21 => p_attribute21
467 ,p_attribute22 => p_attribute22
468 ,p_attribute23 => p_attribute23
469 ,p_attribute24 => p_attribute24
470 ,p_attribute25 => p_attribute25
471 ,p_attribute26 => p_attribute26
472 ,p_attribute27 => p_attribute27
473 ,p_attribute28 => p_attribute28
474 ,p_attribute29 => p_attribute29
475 ,p_attribute30 => p_attribute30
476 ,p_attribute_category => p_attribute_category
477 ,p_object_version_number => l_object_version_number
478 ,p_effective_date => trunc(p_effective_date)
479 ,p_pay_basis_id => p_pay_basis_id
480 ,p_supervisor_id => p_supervisor_id
481 ,p_wf_transaction_category_id => p_wf_transaction_category_id
482 );
483 --
484 begin
485 --
486 -- Start of API User Hook for the after hook of create_position_transaction
487 --
488 pqh_position_transactions_bk1.create_position_transaction_a
489 (
490 p_position_transaction_id => l_position_transaction_id
491 ,p_action_date => p_action_date
492 ,p_position_id => p_position_id
493 ,p_availability_status_id => p_availability_status_id
494 ,p_business_group_id => p_business_group_id
495 ,p_entry_step_id => p_entry_step_id
496 ,p_entry_grade_rule_id => p_entry_grade_rule_id
497 ,p_job_id => p_job_id
498 ,p_location_id => p_location_id
499 ,p_organization_id => p_organization_id
500 ,p_pay_freq_payroll_id => p_pay_freq_payroll_id
501 ,p_position_definition_id => p_position_definition_id
502 ,p_prior_position_id => p_prior_position_id
503 ,p_relief_position_id => p_relief_position_id
504 ,p_entry_grade_id => p_entry_grade_id
505 ,p_successor_position_id => p_successor_position_id
506 ,p_supervisor_position_id => p_supervisor_position_id
507 ,p_amendment_date => p_amendment_date
508 ,p_amendment_recommendation => p_amendment_recommendation
509 ,p_amendment_ref_number => p_amendment_ref_number
510 ,p_avail_status_prop_end_date => p_avail_status_prop_end_date
511 ,p_bargaining_unit_cd => p_bargaining_unit_cd
512 ,p_comments => p_comments
513 ,p_country1 => p_country1
514 ,p_country2 => p_country2
515 ,p_country3 => p_country3
516 ,p_current_job_prop_end_date => p_current_job_prop_end_date
517 ,p_current_org_prop_end_date => p_current_org_prop_end_date
518 ,p_date_effective => p_date_effective
519 ,p_date_end => p_date_end
520 ,p_earliest_hire_date => p_earliest_hire_date
521 ,p_fill_by_date => p_fill_by_date
522 ,p_frequency => p_frequency
523 ,p_fte => p_fte
524 ,p_fte_capacity => p_fte_capacity
525 ,p_location1 => p_location1
526 ,p_location2 => p_location2
527 ,p_location3 => p_location3
528 ,p_max_persons => p_max_persons
529 ,p_name => p_name
533 ,p_passport_required => p_passport_required
530 ,p_other_requirements => p_other_requirements
531 ,p_overlap_period => p_overlap_period
532 ,p_overlap_unit_cd => p_overlap_unit_cd
534 ,p_pay_term_end_day_cd => p_pay_term_end_day_cd
535 ,p_pay_term_end_month_cd => p_pay_term_end_month_cd
536 ,p_permanent_temporary_flag => p_permanent_temporary_flag
537 ,p_permit_recruitment_flag => p_permit_recruitment_flag
538 ,p_position_type => p_position_type
539 ,p_posting_description => p_posting_description
540 ,p_probation_period => p_probation_period
541 ,p_probation_period_unit_cd => p_probation_period_unit_cd
542 ,p_relocate_domestically => p_relocate_domestically
543 ,p_relocate_internationally => p_relocate_internationally
544 ,p_replacement_required_flag => p_replacement_required_flag
545 ,p_review_flag => p_review_flag
546 ,p_seasonal_flag => p_seasonal_flag
547 ,p_security_requirements => p_security_requirements
548 ,p_service_minimum => p_service_minimum
549 ,p_term_start_day_cd => p_term_start_day_cd
550 ,p_term_start_month_cd => p_term_start_month_cd
551 ,p_time_normal_finish => p_time_normal_finish
552 ,p_time_normal_start => p_time_normal_start
553 ,p_transaction_status => p_transaction_status
554 ,p_travel_required => p_travel_required
555 ,p_working_hours => p_working_hours
556 ,p_works_council_approval_flag => p_works_council_approval_flag
557 ,p_work_any_country => p_work_any_country
558 ,p_work_any_location => p_work_any_location
559 ,p_work_period_type_cd => p_work_period_type_cd
560 ,p_work_schedule => p_work_schedule
561 ,p_work_duration => p_work_duration
562 ,p_work_term_end_day_cd => p_work_term_end_day_cd
563 ,p_work_term_end_month_cd => p_work_term_end_month_cd
564 ,p_proposed_fte_for_layoff => p_proposed_fte_for_layoff
565 ,p_proposed_date_for_layoff => p_proposed_date_for_layoff
566 ,p_information1 => p_information1
567 ,p_information2 => p_information2
568 ,p_information3 => p_information3
569 ,p_information4 => p_information4
570 ,p_information5 => p_information5
571 ,p_information6 => p_information6
572 ,p_information7 => p_information7
573 ,p_information8 => p_information8
574 ,p_information9 => p_information9
575 ,p_information10 => p_information10
576 ,p_information11 => p_information11
577 ,p_information12 => p_information12
578 ,p_information13 => p_information13
579 ,p_information14 => p_information14
580 ,p_information15 => p_information15
581 ,p_information16 => p_information16
582 ,p_information17 => p_information17
583 ,p_information18 => p_information18
584 ,p_information19 => p_information19
585 ,p_information20 => p_information20
586 ,p_information21 => p_information21
587 ,p_information22 => p_information22
588 ,p_information23 => p_information23
589 ,p_information24 => p_information24
590 ,p_information25 => p_information25
591 ,p_information26 => p_information26
592 ,p_information27 => p_information27
593 ,p_information28 => p_information28
594 ,p_information29 => p_information29
595 ,p_information30 => p_information30
596 ,p_information_category => p_information_category
597 ,p_attribute1 => p_attribute1
598 ,p_attribute2 => p_attribute2
599 ,p_attribute3 => p_attribute3
600 ,p_attribute4 => p_attribute4
601 ,p_attribute5 => p_attribute5
602 ,p_attribute6 => p_attribute6
603 ,p_attribute7 => p_attribute7
604 ,p_attribute8 => p_attribute8
605 ,p_attribute9 => p_attribute9
606 ,p_attribute10 => p_attribute10
607 ,p_attribute11 => p_attribute11
608 ,p_attribute12 => p_attribute12
609 ,p_attribute13 => p_attribute13
610 ,p_attribute14 => p_attribute14
611 ,p_attribute15 => p_attribute15
612 ,p_attribute16 => p_attribute16
613 ,p_attribute17 => p_attribute17
614 ,p_attribute18 => p_attribute18
615 ,p_attribute19 => p_attribute19
616 ,p_attribute20 => p_attribute20
617 ,p_attribute21 => p_attribute21
618 ,p_attribute22 => p_attribute22
619 ,p_attribute23 => p_attribute23
623 ,p_attribute27 => p_attribute27
620 ,p_attribute24 => p_attribute24
621 ,p_attribute25 => p_attribute25
622 ,p_attribute26 => p_attribute26
624 ,p_attribute28 => p_attribute28
625 ,p_attribute29 => p_attribute29
626 ,p_attribute30 => p_attribute30
627 ,p_attribute_category => p_attribute_category
628 ,p_object_version_number => l_object_version_number
629 ,p_effective_date => trunc(p_effective_date)
630 ,p_pay_basis_id => p_pay_basis_id
631 ,p_supervisor_id => p_supervisor_id
632 ,p_wf_transaction_category_id => p_wf_transaction_category_id
633 );
634 exception
635 when hr_api.cannot_find_prog_unit then
636 hr_api.cannot_find_prog_unit_error
637 (p_module_name => 'CREATE_POSITION_TRANSACTION'
638 ,p_hook_type => 'AP'
639 );
640 --
641 -- End of API User Hook for the after hook of create_position_transaction
642 --
643 end;
644 --
645 hr_utility.set_location(l_proc, 60);
646 --
647 -- When in validation only mode raise the Validate_Enabled exception
648 --
649 if p_validate then
650 raise hr_api.validate_enabled;
651 end if;
652 --
653 -- Set all output arguments
654 --
655 p_position_transaction_id := l_position_transaction_id;
656 p_object_version_number := l_object_version_number;
657 --
658 hr_utility.set_location(' Leaving:'||l_proc, 70);
659 --
660 exception
661 --
662 when hr_api.validate_enabled then
663 --
664 -- As the Validate_Enabled exception has been raised
665 -- we must rollback to the savepoint
666 --
667 ROLLBACK TO create_position_transaction;
668 --
669 -- Only set output warning arguments
670 -- (Any key or derived arguments must be set to null
671 -- when validation only mode is being used.)
672 --
673 p_position_transaction_id := null;
674 p_object_version_number := null;
675 hr_utility.set_location(' Leaving:'||l_proc, 80);
676 --
677 when others then
678 p_position_transaction_id := null;
679 p_object_version_number := null;
680 --
681 -- A validation or unexpected error has occured
682 --
683 ROLLBACK TO create_position_transaction;
684 raise;
685 --
686 end create_position_transaction;
687 -- ----------------------------------------------------------------------------
688 -- |------------------------< update_position_transaction >---------------------|
689 -- ----------------------------------------------------------------------------
690 --
691 procedure update_position_transaction
692 (p_validate in boolean default false
693 ,p_position_transaction_id in number
694 ,p_action_date in date default hr_api.g_date
695 ,p_position_id in number default hr_api.g_number
696 ,p_availability_status_id in number default hr_api.g_number
697 ,p_business_group_id in number default hr_api.g_number
698 ,p_entry_step_id in number default hr_api.g_number
699 ,p_entry_grade_rule_id in number default hr_api.g_number
700 ,p_job_id in number default hr_api.g_number
701 ,p_location_id in number default hr_api.g_number
702 ,p_organization_id in number default hr_api.g_number
703 ,p_pay_freq_payroll_id in number default hr_api.g_number
704 ,p_position_definition_id in number default hr_api.g_number
705 ,p_prior_position_id in number default hr_api.g_number
706 ,p_relief_position_id in number default hr_api.g_number
707 ,p_entry_grade_id in number default hr_api.g_number
708 ,p_successor_position_id in number default hr_api.g_number
709 ,p_supervisor_position_id in number default hr_api.g_number
710 ,p_amendment_date in date default hr_api.g_date
711 ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
712 ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
713 ,p_avail_status_prop_end_date in date default hr_api.g_date
714 ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
715 ,p_comments in long default null
716 ,p_country1 in varchar2 default hr_api.g_varchar2
717 ,p_country2 in varchar2 default hr_api.g_varchar2
718 ,p_country3 in varchar2 default hr_api.g_varchar2
719 ,p_current_job_prop_end_date in date default hr_api.g_date
720 ,p_current_org_prop_end_date in date default hr_api.g_date
721 ,p_date_effective in date default hr_api.g_date
722 ,p_date_end in date default hr_api.g_date
723 ,p_earliest_hire_date in date default hr_api.g_date
724 ,p_fill_by_date in date default hr_api.g_date
725 ,p_frequency in varchar2 default hr_api.g_varchar2
726 ,p_fte in number default hr_api.g_number
727 ,p_fte_capacity in varchar2 default hr_api.g_varchar2
728 ,p_location1 in varchar2 default hr_api.g_varchar2
729 ,p_location2 in varchar2 default hr_api.g_varchar2
733 ,p_other_requirements in varchar2 default hr_api.g_varchar2
730 ,p_location3 in varchar2 default hr_api.g_varchar2
731 ,p_max_persons in number default hr_api.g_number
732 ,p_name in varchar2 default hr_api.g_varchar2
734 ,p_overlap_period in number default hr_api.g_number
735 ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
736 ,p_passport_required in varchar2 default hr_api.g_varchar2
737 ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
738 ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
739 ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
740 ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
741 ,p_position_type in varchar2 default hr_api.g_varchar2
742 ,p_posting_description in varchar2 default hr_api.g_varchar2
743 ,p_probation_period in number default hr_api.g_number
744 ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
745 ,p_relocate_domestically in varchar2 default hr_api.g_varchar2
746 ,p_relocate_internationally in varchar2 default hr_api.g_varchar2
747 ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
748 ,p_review_flag in varchar2 default hr_api.g_varchar2
749 ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
750 ,p_security_requirements in varchar2 default hr_api.g_varchar2
751 ,p_service_minimum in varchar2 default hr_api.g_varchar2
752 ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
753 ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
754 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
755 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
756 ,p_transaction_status in varchar2 default hr_api.g_varchar2
757 ,p_travel_required in varchar2 default hr_api.g_varchar2
758 ,p_working_hours in number default hr_api.g_number
759 ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
760 ,p_work_any_country in varchar2 default hr_api.g_varchar2
761 ,p_work_any_location in varchar2 default hr_api.g_varchar2
762 ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
763 ,p_work_schedule in varchar2 default hr_api.g_varchar2
764 ,p_work_duration in varchar2 default hr_api.g_varchar2
765 ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
766 ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
767 ,p_proposed_fte_for_layoff in number default hr_api.g_number
768 ,p_proposed_date_for_layoff in date default hr_api.g_date
769 ,p_information1 in varchar2 default hr_api.g_varchar2
770 ,p_information2 in varchar2 default hr_api.g_varchar2
771 ,p_information3 in varchar2 default hr_api.g_varchar2
772 ,p_information4 in varchar2 default hr_api.g_varchar2
773 ,p_information5 in varchar2 default hr_api.g_varchar2
774 ,p_information6 in varchar2 default hr_api.g_varchar2
775 ,p_information7 in varchar2 default hr_api.g_varchar2
776 ,p_information8 in varchar2 default hr_api.g_varchar2
777 ,p_information9 in varchar2 default hr_api.g_varchar2
778 ,p_information10 in varchar2 default hr_api.g_varchar2
779 ,p_information11 in varchar2 default hr_api.g_varchar2
780 ,p_information12 in varchar2 default hr_api.g_varchar2
781 ,p_information13 in varchar2 default hr_api.g_varchar2
782 ,p_information14 in varchar2 default hr_api.g_varchar2
783 ,p_information15 in varchar2 default hr_api.g_varchar2
784 ,p_information16 in varchar2 default hr_api.g_varchar2
785 ,p_information17 in varchar2 default hr_api.g_varchar2
786 ,p_information18 in varchar2 default hr_api.g_varchar2
787 ,p_information19 in varchar2 default hr_api.g_varchar2
788 ,p_information20 in varchar2 default hr_api.g_varchar2
789 ,p_information21 in varchar2 default hr_api.g_varchar2
790 ,p_information22 in varchar2 default hr_api.g_varchar2
791 ,p_information23 in varchar2 default hr_api.g_varchar2
792 ,p_information24 in varchar2 default hr_api.g_varchar2
793 ,p_information25 in varchar2 default hr_api.g_varchar2
794 ,p_information26 in varchar2 default hr_api.g_varchar2
795 ,p_information27 in varchar2 default hr_api.g_varchar2
796 ,p_information28 in varchar2 default hr_api.g_varchar2
797 ,p_information29 in varchar2 default hr_api.g_varchar2
798 ,p_information30 in varchar2 default hr_api.g_varchar2
799 ,p_information_category in varchar2 default hr_api.g_varchar2
800 ,p_attribute1 in varchar2 default hr_api.g_varchar2
801 ,p_attribute2 in varchar2 default hr_api.g_varchar2
802 ,p_attribute3 in varchar2 default hr_api.g_varchar2
803 ,p_attribute4 in varchar2 default hr_api.g_varchar2
804 ,p_attribute5 in varchar2 default hr_api.g_varchar2
808 ,p_attribute9 in varchar2 default hr_api.g_varchar2
805 ,p_attribute6 in varchar2 default hr_api.g_varchar2
806 ,p_attribute7 in varchar2 default hr_api.g_varchar2
807 ,p_attribute8 in varchar2 default hr_api.g_varchar2
809 ,p_attribute10 in varchar2 default hr_api.g_varchar2
810 ,p_attribute11 in varchar2 default hr_api.g_varchar2
811 ,p_attribute12 in varchar2 default hr_api.g_varchar2
812 ,p_attribute13 in varchar2 default hr_api.g_varchar2
813 ,p_attribute14 in varchar2 default hr_api.g_varchar2
814 ,p_attribute15 in varchar2 default hr_api.g_varchar2
815 ,p_attribute16 in varchar2 default hr_api.g_varchar2
816 ,p_attribute17 in varchar2 default hr_api.g_varchar2
817 ,p_attribute18 in varchar2 default hr_api.g_varchar2
818 ,p_attribute19 in varchar2 default hr_api.g_varchar2
819 ,p_attribute20 in varchar2 default hr_api.g_varchar2
820 ,p_attribute21 in varchar2 default hr_api.g_varchar2
821 ,p_attribute22 in varchar2 default hr_api.g_varchar2
822 ,p_attribute23 in varchar2 default hr_api.g_varchar2
823 ,p_attribute24 in varchar2 default hr_api.g_varchar2
824 ,p_attribute25 in varchar2 default hr_api.g_varchar2
825 ,p_attribute26 in varchar2 default hr_api.g_varchar2
826 ,p_attribute27 in varchar2 default hr_api.g_varchar2
827 ,p_attribute28 in varchar2 default hr_api.g_varchar2
828 ,p_attribute29 in varchar2 default hr_api.g_varchar2
829 ,p_attribute30 in varchar2 default hr_api.g_varchar2
830 ,p_attribute_category in varchar2 default hr_api.g_varchar2
831 ,p_object_version_number in out nocopy number
832 ,p_effective_date in date
833 ,p_pay_basis_id in number default hr_api.g_number
834 ,p_supervisor_id in number default hr_api.g_number
835 ,p_wf_transaction_category_id in number default hr_api.g_number
836 ) is
837 --
838 -- Declare cursors and local variables
839 --
840 l_proc varchar2(72) := g_package||'update_position_transaction';
841 l_object_version_number pqh_position_transactions.object_version_number%TYPE;
842 --
843 begin
844 --
845 hr_utility.set_location('Entering:'|| l_proc, 10);
846 --
847 -- Issue a savepoint if operating in validation only mode
848 --
849 savepoint update_position_transaction;
850 --
851 hr_utility.set_location(l_proc, 20);
852 --
853 -- Process Logic
854 --
855 l_object_version_number := p_object_version_number;
856 --
857 begin
858 --
859 -- Start of API User Hook for the before hook of update_position_transaction
860 --
861 pqh_position_transactions_bk2.update_position_transaction_b
862 (
863 p_position_transaction_id => p_position_transaction_id
864 ,p_action_date => p_action_date
865 ,p_position_id => p_position_id
866 ,p_availability_status_id => p_availability_status_id
867 ,p_business_group_id => p_business_group_id
868 ,p_entry_step_id => p_entry_step_id
869 ,p_entry_grade_rule_id => p_entry_grade_rule_id
870 ,p_job_id => p_job_id
871 ,p_location_id => p_location_id
872 ,p_organization_id => p_organization_id
873 ,p_pay_freq_payroll_id => p_pay_freq_payroll_id
874 ,p_position_definition_id => p_position_definition_id
875 ,p_prior_position_id => p_prior_position_id
876 ,p_relief_position_id => p_relief_position_id
877 ,p_entry_grade_id => p_entry_grade_id
878 ,p_successor_position_id => p_successor_position_id
879 ,p_supervisor_position_id => p_supervisor_position_id
880 ,p_amendment_date => p_amendment_date
881 ,p_amendment_recommendation => p_amendment_recommendation
882 ,p_amendment_ref_number => p_amendment_ref_number
883 ,p_avail_status_prop_end_date => p_avail_status_prop_end_date
884 ,p_bargaining_unit_cd => p_bargaining_unit_cd
885 ,p_comments => p_comments
886 ,p_country1 => p_country1
887 ,p_country2 => p_country2
888 ,p_country3 => p_country3
889 ,p_current_job_prop_end_date => p_current_job_prop_end_date
890 ,p_current_org_prop_end_date => p_current_org_prop_end_date
891 ,p_date_effective => p_date_effective
892 ,p_date_end => p_date_end
893 ,p_earliest_hire_date => p_earliest_hire_date
894 ,p_fill_by_date => p_fill_by_date
895 ,p_frequency => p_frequency
896 ,p_fte => p_fte
897 ,p_fte_capacity => p_fte_capacity
898 ,p_location1 => p_location1
899 ,p_location2 => p_location2
900 ,p_location3 => p_location3
901 ,p_max_persons => p_max_persons
905 ,p_overlap_unit_cd => p_overlap_unit_cd
902 ,p_name => p_name
903 ,p_other_requirements => p_other_requirements
904 ,p_overlap_period => p_overlap_period
906 ,p_passport_required => p_passport_required
907 ,p_pay_term_end_day_cd => p_pay_term_end_day_cd
908 ,p_pay_term_end_month_cd => p_pay_term_end_month_cd
909 ,p_permanent_temporary_flag => p_permanent_temporary_flag
910 ,p_permit_recruitment_flag => p_permit_recruitment_flag
911 ,p_position_type => p_position_type
912 ,p_posting_description => p_posting_description
913 ,p_probation_period => p_probation_period
914 ,p_probation_period_unit_cd => p_probation_period_unit_cd
915 ,p_relocate_domestically => p_relocate_domestically
916 ,p_relocate_internationally => p_relocate_internationally
917 ,p_replacement_required_flag => p_replacement_required_flag
918 ,p_review_flag => p_review_flag
919 ,p_seasonal_flag => p_seasonal_flag
920 ,p_security_requirements => p_security_requirements
921 ,p_service_minimum => p_service_minimum
922 ,p_term_start_day_cd => p_term_start_day_cd
923 ,p_term_start_month_cd => p_term_start_month_cd
924 ,p_time_normal_finish => p_time_normal_finish
925 ,p_time_normal_start => p_time_normal_start
926 ,p_transaction_status => p_transaction_status
927 ,p_travel_required => p_travel_required
928 ,p_working_hours => p_working_hours
929 ,p_works_council_approval_flag => p_works_council_approval_flag
930 ,p_work_any_country => p_work_any_country
931 ,p_work_any_location => p_work_any_location
932 ,p_work_period_type_cd => p_work_period_type_cd
933 ,p_work_schedule => p_work_schedule
934 ,p_work_duration => p_work_duration
935 ,p_work_term_end_day_cd => p_work_term_end_day_cd
936 ,p_work_term_end_month_cd => p_work_term_end_month_cd
937 ,p_proposed_fte_for_layoff => p_proposed_fte_for_layoff
938 ,p_proposed_date_for_layoff => p_proposed_date_for_layoff
939 ,p_information1 => p_information1
940 ,p_information2 => p_information2
941 ,p_information3 => p_information3
942 ,p_information4 => p_information4
943 ,p_information5 => p_information5
944 ,p_information6 => p_information6
945 ,p_information7 => p_information7
946 ,p_information8 => p_information8
947 ,p_information9 => p_information9
948 ,p_information10 => p_information10
949 ,p_information11 => p_information11
950 ,p_information12 => p_information12
951 ,p_information13 => p_information13
952 ,p_information14 => p_information14
953 ,p_information15 => p_information15
954 ,p_information16 => p_information16
955 ,p_information17 => p_information17
956 ,p_information18 => p_information18
957 ,p_information19 => p_information19
958 ,p_information20 => p_information20
959 ,p_information21 => p_information21
960 ,p_information22 => p_information22
961 ,p_information23 => p_information23
962 ,p_information24 => p_information24
963 ,p_information25 => p_information25
964 ,p_information26 => p_information26
965 ,p_information27 => p_information27
966 ,p_information28 => p_information28
967 ,p_information29 => p_information29
968 ,p_information30 => p_information30
969 ,p_information_category => p_information_category
970 ,p_attribute1 => p_attribute1
971 ,p_attribute2 => p_attribute2
972 ,p_attribute3 => p_attribute3
973 ,p_attribute4 => p_attribute4
974 ,p_attribute5 => p_attribute5
975 ,p_attribute6 => p_attribute6
976 ,p_attribute7 => p_attribute7
977 ,p_attribute8 => p_attribute8
978 ,p_attribute9 => p_attribute9
979 ,p_attribute10 => p_attribute10
980 ,p_attribute11 => p_attribute11
981 ,p_attribute12 => p_attribute12
982 ,p_attribute13 => p_attribute13
983 ,p_attribute14 => p_attribute14
984 ,p_attribute15 => p_attribute15
985 ,p_attribute16 => p_attribute16
986 ,p_attribute17 => p_attribute17
987 ,p_attribute18 => p_attribute18
988 ,p_attribute19 => p_attribute19
989 ,p_attribute20 => p_attribute20
990 ,p_attribute21 => p_attribute21
991 ,p_attribute22 => p_attribute22
992 ,p_attribute23 => p_attribute23
993 ,p_attribute24 => p_attribute24
997 ,p_attribute28 => p_attribute28
994 ,p_attribute25 => p_attribute25
995 ,p_attribute26 => p_attribute26
996 ,p_attribute27 => p_attribute27
998 ,p_attribute29 => p_attribute29
999 ,p_attribute30 => p_attribute30
1000 ,p_attribute_category => p_attribute_category
1001 ,p_object_version_number => p_object_version_number
1002 ,p_effective_date => trunc(p_effective_date)
1003 ,p_pay_basis_id => p_pay_basis_id
1004 ,p_supervisor_id => p_supervisor_id
1005 ,p_wf_transaction_category_id => p_wf_transaction_category_id
1006 );
1007 exception
1008 when hr_api.cannot_find_prog_unit then
1009 hr_api.cannot_find_prog_unit_error
1010 (p_module_name => 'UPDATE_POSITION_TRANSACTION'
1011 ,p_hook_type => 'BP'
1012 );
1013 --
1014 -- End of API User Hook for the before hook of update_position_transaction
1015 --
1016 end;
1017 --
1018 pqh_ptx_upd.upd
1019 (
1020 p_position_transaction_id => p_position_transaction_id
1021 ,p_action_date => p_action_date
1022 ,p_position_id => p_position_id
1023 ,p_availability_status_id => p_availability_status_id
1024 ,p_business_group_id => p_business_group_id
1025 ,p_entry_step_id => p_entry_step_id
1026 ,p_entry_grade_rule_id => p_entry_grade_rule_id
1027 ,p_job_id => p_job_id
1028 ,p_location_id => p_location_id
1029 ,p_organization_id => p_organization_id
1030 ,p_pay_freq_payroll_id => p_pay_freq_payroll_id
1031 ,p_position_definition_id => p_position_definition_id
1032 ,p_prior_position_id => p_prior_position_id
1033 ,p_relief_position_id => p_relief_position_id
1034 ,p_entry_grade_id => p_entry_grade_id
1035 ,p_successor_position_id => p_successor_position_id
1036 ,p_supervisor_position_id => p_supervisor_position_id
1037 ,p_amendment_date => p_amendment_date
1038 ,p_amendment_recommendation => p_amendment_recommendation
1039 ,p_amendment_ref_number => p_amendment_ref_number
1040 ,p_avail_status_prop_end_date => p_avail_status_prop_end_date
1041 ,p_bargaining_unit_cd => p_bargaining_unit_cd
1042 ,p_comments => p_comments
1043 ,p_country1 => p_country1
1044 ,p_country2 => p_country2
1045 ,p_country3 => p_country3
1046 ,p_current_job_prop_end_date => p_current_job_prop_end_date
1047 ,p_current_org_prop_end_date => p_current_org_prop_end_date
1048 ,p_date_effective => p_date_effective
1049 ,p_date_end => p_date_end
1050 ,p_earliest_hire_date => p_earliest_hire_date
1051 ,p_fill_by_date => p_fill_by_date
1052 ,p_frequency => p_frequency
1053 ,p_fte => p_fte
1054 ,p_fte_capacity => p_fte_capacity
1055 ,p_location1 => p_location1
1056 ,p_location2 => p_location2
1057 ,p_location3 => p_location3
1058 ,p_max_persons => p_max_persons
1059 ,p_name => p_name
1060 ,p_other_requirements => p_other_requirements
1061 ,p_overlap_period => p_overlap_period
1062 ,p_overlap_unit_cd => p_overlap_unit_cd
1063 ,p_passport_required => p_passport_required
1064 ,p_pay_term_end_day_cd => p_pay_term_end_day_cd
1065 ,p_pay_term_end_month_cd => p_pay_term_end_month_cd
1066 ,p_permanent_temporary_flag => p_permanent_temporary_flag
1067 ,p_permit_recruitment_flag => p_permit_recruitment_flag
1068 ,p_position_type => p_position_type
1069 ,p_posting_description => p_posting_description
1070 ,p_probation_period => p_probation_period
1071 ,p_probation_period_unit_cd => p_probation_period_unit_cd
1072 ,p_relocate_domestically => p_relocate_domestically
1073 ,p_relocate_internationally => p_relocate_internationally
1074 ,p_replacement_required_flag => p_replacement_required_flag
1075 ,p_review_flag => p_review_flag
1076 ,p_seasonal_flag => p_seasonal_flag
1077 ,p_security_requirements => p_security_requirements
1078 ,p_service_minimum => p_service_minimum
1079 ,p_term_start_day_cd => p_term_start_day_cd
1080 ,p_term_start_month_cd => p_term_start_month_cd
1081 ,p_time_normal_finish => p_time_normal_finish
1082 ,p_time_normal_start => p_time_normal_start
1083 ,p_transaction_status => p_transaction_status
1084 ,p_travel_required => p_travel_required
1085 ,p_working_hours => p_working_hours
1086 ,p_works_council_approval_flag => p_works_council_approval_flag
1087 ,p_work_any_country => p_work_any_country
1088 ,p_work_any_location => p_work_any_location
1089 ,p_work_period_type_cd => p_work_period_type_cd
1090 ,p_work_schedule => p_work_schedule
1091 ,p_work_duration => p_work_duration
1092 ,p_work_term_end_day_cd => p_work_term_end_day_cd
1096 ,p_information1 => p_information1
1093 ,p_work_term_end_month_cd => p_work_term_end_month_cd
1094 ,p_proposed_fte_for_layoff => p_proposed_fte_for_layoff
1095 ,p_proposed_date_for_layoff => p_proposed_date_for_layoff
1097 ,p_information2 => p_information2
1098 ,p_information3 => p_information3
1099 ,p_information4 => p_information4
1100 ,p_information5 => p_information5
1101 ,p_information6 => p_information6
1102 ,p_information7 => p_information7
1103 ,p_information8 => p_information8
1104 ,p_information9 => p_information9
1105 ,p_information10 => p_information10
1106 ,p_information11 => p_information11
1107 ,p_information12 => p_information12
1108 ,p_information13 => p_information13
1109 ,p_information14 => p_information14
1110 ,p_information15 => p_information15
1111 ,p_information16 => p_information16
1112 ,p_information17 => p_information17
1113 ,p_information18 => p_information18
1114 ,p_information19 => p_information19
1115 ,p_information20 => p_information20
1116 ,p_information21 => p_information21
1117 ,p_information22 => p_information22
1118 ,p_information23 => p_information23
1119 ,p_information24 => p_information24
1120 ,p_information25 => p_information25
1121 ,p_information26 => p_information26
1122 ,p_information27 => p_information27
1123 ,p_information28 => p_information28
1124 ,p_information29 => p_information29
1125 ,p_information30 => p_information30
1126 ,p_information_category => p_information_category
1127 ,p_attribute1 => p_attribute1
1128 ,p_attribute2 => p_attribute2
1129 ,p_attribute3 => p_attribute3
1130 ,p_attribute4 => p_attribute4
1131 ,p_attribute5 => p_attribute5
1132 ,p_attribute6 => p_attribute6
1133 ,p_attribute7 => p_attribute7
1134 ,p_attribute8 => p_attribute8
1135 ,p_attribute9 => p_attribute9
1136 ,p_attribute10 => p_attribute10
1137 ,p_attribute11 => p_attribute11
1138 ,p_attribute12 => p_attribute12
1139 ,p_attribute13 => p_attribute13
1140 ,p_attribute14 => p_attribute14
1141 ,p_attribute15 => p_attribute15
1142 ,p_attribute16 => p_attribute16
1143 ,p_attribute17 => p_attribute17
1144 ,p_attribute18 => p_attribute18
1145 ,p_attribute19 => p_attribute19
1146 ,p_attribute20 => p_attribute20
1147 ,p_attribute21 => p_attribute21
1148 ,p_attribute22 => p_attribute22
1149 ,p_attribute23 => p_attribute23
1150 ,p_attribute24 => p_attribute24
1151 ,p_attribute25 => p_attribute25
1152 ,p_attribute26 => p_attribute26
1153 ,p_attribute27 => p_attribute27
1154 ,p_attribute28 => p_attribute28
1155 ,p_attribute29 => p_attribute29
1156 ,p_attribute30 => p_attribute30
1157 ,p_attribute_category => p_attribute_category
1158 ,p_object_version_number => l_object_version_number
1159 ,p_effective_date => trunc(p_effective_date)
1160 ,p_pay_basis_id => p_pay_basis_id
1161 ,p_supervisor_id => p_supervisor_id
1162 ,p_wf_transaction_category_id => p_wf_transaction_category_id
1163 );
1164 --
1165 begin
1166 --
1167 -- Start of API User Hook for the after hook of update_position_transaction
1168 --
1169 pqh_position_transactions_bk2.update_position_transaction_a
1170 (
1171 p_position_transaction_id => p_position_transaction_id
1172 ,p_action_date => p_action_date
1173 ,p_position_id => p_position_id
1174 ,p_availability_status_id => p_availability_status_id
1175 ,p_business_group_id => p_business_group_id
1176 ,p_entry_step_id => p_entry_step_id
1177 ,p_entry_grade_rule_id => p_entry_grade_rule_id
1178 ,p_job_id => p_job_id
1179 ,p_location_id => p_location_id
1180 ,p_organization_id => p_organization_id
1181 ,p_pay_freq_payroll_id => p_pay_freq_payroll_id
1182 ,p_position_definition_id => p_position_definition_id
1183 ,p_prior_position_id => p_prior_position_id
1184 ,p_relief_position_id => p_relief_position_id
1185 ,p_entry_grade_id => p_entry_grade_id
1186 ,p_successor_position_id => p_successor_position_id
1187 ,p_supervisor_position_id => p_supervisor_position_id
1188 ,p_amendment_date => p_amendment_date
1189 ,p_amendment_recommendation => p_amendment_recommendation
1190 ,p_amendment_ref_number => p_amendment_ref_number
1194 ,p_country1 => p_country1
1191 ,p_avail_status_prop_end_date => p_avail_status_prop_end_date
1192 ,p_bargaining_unit_cd => p_bargaining_unit_cd
1193 ,p_comments => p_comments
1195 ,p_country2 => p_country2
1196 ,p_country3 => p_country3
1197 ,p_current_job_prop_end_date => p_current_job_prop_end_date
1198 ,p_current_org_prop_end_date => p_current_org_prop_end_date
1199 ,p_date_effective => p_date_effective
1200 ,p_date_end => p_date_end
1201 ,p_earliest_hire_date => p_earliest_hire_date
1202 ,p_fill_by_date => p_fill_by_date
1203 ,p_frequency => p_frequency
1204 ,p_fte => p_fte
1205 ,p_fte_capacity => p_fte_capacity
1206 ,p_location1 => p_location1
1207 ,p_location2 => p_location2
1208 ,p_location3 => p_location3
1209 ,p_max_persons => p_max_persons
1210 ,p_name => p_name
1211 ,p_other_requirements => p_other_requirements
1212 ,p_overlap_period => p_overlap_period
1213 ,p_overlap_unit_cd => p_overlap_unit_cd
1214 ,p_passport_required => p_passport_required
1215 ,p_pay_term_end_day_cd => p_pay_term_end_day_cd
1216 ,p_pay_term_end_month_cd => p_pay_term_end_month_cd
1217 ,p_permanent_temporary_flag => p_permanent_temporary_flag
1218 ,p_permit_recruitment_flag => p_permit_recruitment_flag
1219 ,p_position_type => p_position_type
1220 ,p_posting_description => p_posting_description
1221 ,p_probation_period => p_probation_period
1222 ,p_probation_period_unit_cd => p_probation_period_unit_cd
1223 ,p_relocate_domestically => p_relocate_domestically
1224 ,p_relocate_internationally => p_relocate_internationally
1225 ,p_replacement_required_flag => p_replacement_required_flag
1226 ,p_review_flag => p_review_flag
1227 ,p_seasonal_flag => p_seasonal_flag
1228 ,p_security_requirements => p_security_requirements
1229 ,p_service_minimum => p_service_minimum
1230 ,p_term_start_day_cd => p_term_start_day_cd
1231 ,p_term_start_month_cd => p_term_start_month_cd
1232 ,p_time_normal_finish => p_time_normal_finish
1233 ,p_time_normal_start => p_time_normal_start
1234 ,p_transaction_status => p_transaction_status
1235 ,p_travel_required => p_travel_required
1236 ,p_working_hours => p_working_hours
1237 ,p_works_council_approval_flag => p_works_council_approval_flag
1238 ,p_work_any_country => p_work_any_country
1239 ,p_work_any_location => p_work_any_location
1240 ,p_work_period_type_cd => p_work_period_type_cd
1241 ,p_work_schedule => p_work_schedule
1242 ,p_work_duration => p_work_duration
1243 ,p_work_term_end_day_cd => p_work_term_end_day_cd
1244 ,p_work_term_end_month_cd => p_work_term_end_month_cd
1245 ,p_proposed_fte_for_layoff => p_proposed_fte_for_layoff
1246 ,p_proposed_date_for_layoff => p_proposed_date_for_layoff
1247 ,p_information1 => p_information1
1248 ,p_information2 => p_information2
1249 ,p_information3 => p_information3
1250 ,p_information4 => p_information4
1251 ,p_information5 => p_information5
1252 ,p_information6 => p_information6
1253 ,p_information7 => p_information7
1254 ,p_information8 => p_information8
1255 ,p_information9 => p_information9
1256 ,p_information10 => p_information10
1257 ,p_information11 => p_information11
1258 ,p_information12 => p_information12
1259 ,p_information13 => p_information13
1260 ,p_information14 => p_information14
1261 ,p_information15 => p_information15
1262 ,p_information16 => p_information16
1263 ,p_information17 => p_information17
1264 ,p_information18 => p_information18
1265 ,p_information19 => p_information19
1266 ,p_information20 => p_information20
1267 ,p_information21 => p_information21
1268 ,p_information22 => p_information22
1269 ,p_information23 => p_information23
1270 ,p_information24 => p_information24
1271 ,p_information25 => p_information25
1272 ,p_information26 => p_information26
1273 ,p_information27 => p_information27
1274 ,p_information28 => p_information28
1275 ,p_information29 => p_information29
1276 ,p_information30 => p_information30
1277 ,p_information_category => p_information_category
1278 ,p_attribute1 => p_attribute1
1279 ,p_attribute2 => p_attribute2
1280 ,p_attribute3 => p_attribute3
1284 ,p_attribute7 => p_attribute7
1281 ,p_attribute4 => p_attribute4
1282 ,p_attribute5 => p_attribute5
1283 ,p_attribute6 => p_attribute6
1285 ,p_attribute8 => p_attribute8
1286 ,p_attribute9 => p_attribute9
1287 ,p_attribute10 => p_attribute10
1288 ,p_attribute11 => p_attribute11
1289 ,p_attribute12 => p_attribute12
1290 ,p_attribute13 => p_attribute13
1291 ,p_attribute14 => p_attribute14
1292 ,p_attribute15 => p_attribute15
1293 ,p_attribute16 => p_attribute16
1294 ,p_attribute17 => p_attribute17
1295 ,p_attribute18 => p_attribute18
1296 ,p_attribute19 => p_attribute19
1297 ,p_attribute20 => p_attribute20
1298 ,p_attribute21 => p_attribute21
1299 ,p_attribute22 => p_attribute22
1300 ,p_attribute23 => p_attribute23
1301 ,p_attribute24 => p_attribute24
1302 ,p_attribute25 => p_attribute25
1303 ,p_attribute26 => p_attribute26
1304 ,p_attribute27 => p_attribute27
1305 ,p_attribute28 => p_attribute28
1306 ,p_attribute29 => p_attribute29
1307 ,p_attribute30 => p_attribute30
1308 ,p_attribute_category => p_attribute_category
1309 ,p_object_version_number => l_object_version_number
1310 ,p_effective_date => trunc(p_effective_date)
1311 ,p_pay_basis_id => p_pay_basis_id
1312 ,p_supervisor_id => p_supervisor_id
1313 ,p_wf_transaction_category_id => p_wf_transaction_category_id
1314 );
1315 exception
1316 when hr_api.cannot_find_prog_unit then
1317 hr_api.cannot_find_prog_unit_error
1318 (p_module_name => 'UPDATE_POSITION_TRANSACTION'
1319 ,p_hook_type => 'AP'
1320 );
1321 --
1322 -- End of API User Hook for the after hook of update_position_transaction
1323 --
1324 end;
1325 --
1326 hr_utility.set_location(l_proc, 60);
1327 --
1328 -- When in validation only mode raise the Validate_Enabled exception
1329 --
1330 if p_validate then
1331 raise hr_api.validate_enabled;
1332 end if;
1333 --
1334 -- Set all output arguments
1335 --
1336 p_object_version_number := l_object_version_number;
1337 --
1338 hr_utility.set_location(' Leaving:'||l_proc, 70);
1339 --
1340 exception
1341 --
1342 when hr_api.validate_enabled then
1343 --
1344 -- As the Validate_Enabled exception has been raised
1345 -- we must rollback to the savepoint
1346 --
1347 ROLLBACK TO update_position_transaction;
1348 --
1349 -- Only set output warning arguments
1350 -- (Any key or derived arguments must be set to null
1351 -- when validation only mode is being used.)
1352 --
1353 hr_utility.set_location(' Leaving:'||l_proc, 80);
1354 --
1355 when others then
1356 p_object_version_number := l_object_version_number;
1357 --
1358 -- A validation or unexpected error has occured
1359 --
1360 ROLLBACK TO update_position_transaction;
1361 raise;
1362 --
1363 end update_position_transaction;
1364 -- ----------------------------------------------------------------------------
1365 -- |------------------------< delete_position_transaction >----------------------|
1366 -- ----------------------------------------------------------------------------
1367 --
1368 procedure delete_position_transaction
1369 (p_validate in boolean default false
1370 ,p_position_transaction_id in number
1371 ,p_object_version_number in number
1372 ,p_effective_date in date
1373 ) is
1374 --
1375 -- Declare cursors and local variables
1376 --
1377 l_proc varchar2(72) := g_package||'delete_position_transaction';
1378 l_object_version_number pqh_position_transactions.object_version_number%TYPE;
1379 --
1380 begin
1381 --
1382 hr_utility.set_location('Entering:'|| l_proc, 10);
1383 --
1384 -- Issue a savepoint if operating in validation only mode
1385 --
1386 savepoint delete_position_transaction;
1387 --
1388 hr_utility.set_location(l_proc, 20);
1389 --
1390 -- Process Logic
1391 --
1392 l_object_version_number := p_object_version_number;
1393 --
1394 --
1395 begin
1396 --
1397 -- Start of API User Hook for the before hook of delete_position_transaction
1398 --
1399 pqh_position_transactions_bk3.delete_position_transaction_b
1400 (
1401 p_position_transaction_id => p_position_transaction_id
1402 ,p_object_version_number => p_object_version_number
1403 ,p_effective_date => trunc(p_effective_date)
1404 );
1405 exception
1406 when hr_api.cannot_find_prog_unit then
1407 hr_api.cannot_find_prog_unit_error
1408 (p_module_name => 'DELETE_POSITION_TRANSACTION'
1409 ,p_hook_type => 'BP'
1410 );
1411 --
1415 --
1412 -- End of API User Hook for the before hook of delete_position_transaction
1413 --
1414 end;
1416 pqh_ptx_del.del
1417 (
1418 p_position_transaction_id => p_position_transaction_id
1419 ,p_object_version_number => l_object_version_number
1420 ,p_effective_date => p_effective_date
1421 );
1422 --
1423 begin
1424 --
1425 -- Start of API User Hook for the after hook of delete_position_transaction
1426 --
1427 pqh_position_transactions_bk3.delete_position_transaction_a
1428 (
1429 p_position_transaction_id => p_position_transaction_id
1430 ,p_object_version_number => l_object_version_number
1431 ,p_effective_date => trunc(p_effective_date)
1432 );
1433 exception
1434 when hr_api.cannot_find_prog_unit then
1435 hr_api.cannot_find_prog_unit_error
1436 (p_module_name => 'DELETE_POSITION_TRANSACTION'
1437 ,p_hook_type => 'AP'
1438 );
1439 --
1440 -- End of API User Hook for the after hook of delete_position_transaction
1441 --
1442 end;
1443 --
1444 hr_utility.set_location(l_proc, 60);
1445 --
1446 -- When in validation only mode raise the Validate_Enabled exception
1447 --
1448 if p_validate then
1449 raise hr_api.validate_enabled;
1450 end if;
1451 --
1452 hr_utility.set_location(' Leaving:'||l_proc, 70);
1453 --
1454 exception
1455 --
1456 when hr_api.validate_enabled then
1457 --
1458 -- As the Validate_Enabled exception has been raised
1459 -- we must rollback to the savepoint
1460 --
1461 ROLLBACK TO delete_position_transaction;
1462 --
1463 -- Only set output warning arguments
1464 -- (Any key or derived arguments must be set to null
1465 -- when validation only mode is being used.)
1466 --
1467 --
1468 when others then
1469 --
1470 -- A validation or unexpected error has occured
1471 --
1472 ROLLBACK TO delete_position_transaction;
1473 raise;
1474 --
1475 end delete_position_transaction;
1476 --
1477 -- ----------------------------------------------------------------------------
1478 -- |-------------------------------< lck >------------------------------------|
1479 -- ----------------------------------------------------------------------------
1480 --
1481 procedure lck
1482 (
1483 p_position_transaction_id in number
1484 ,p_object_version_number in number
1485 ) is
1486 --
1487 --
1488 -- Declare cursors and local variables
1489 --
1490 l_proc varchar2(72) := g_package||'lck';
1491 --
1492 begin
1493 --
1494 hr_utility.set_location('Entering:'|| l_proc, 10);
1495 --
1496 pqh_ptx_shd.lck
1497 (
1498 p_position_transaction_id => p_position_transaction_id
1499 ,p_object_version_number => p_object_version_number
1500 );
1501 --
1502 hr_utility.set_location(' Leaving:'||l_proc, 70);
1503 --
1504 end lck;
1505 --
1506 end pqh_position_transactions_api;