1 Package pqh_position_transactions_api as
2 /* $Header: pqptxapi.pkh 120.0 2005/05/29 02:22:09 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_position_transaction >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_action_date No date
18 -- p_position_id No number
19 -- p_availability_status_id No number
20 -- p_business_group_id No number Business Group of Record
21 -- p_entry_step_id No number
22 -- p_entry_grade_rule_id No number
23 -- p_job_id No number
24 -- p_location_id No number
25 -- p_organization_id No number
26 -- p_pay_freq_payroll_id No number
27 -- p_position_definition_id No number
28 -- p_prior_position_id No number
29 -- p_relief_position_id No number
30 -- p_entry_grade_id No number
31 -- p_successor_position_id No number
32 -- p_supervisor_position_id No number
33 -- p_amendment_date No date
34 -- p_amendment_recommendation No varchar2
35 -- p_amendment_ref_number No varchar2
36 -- p_avail_status_prop_end_date No date
37 -- p_bargaining_unit_cd No varchar2
38 -- p_comments No long
39 -- p_country1 No varchar2
40 -- p_country2 No varchar2
41 -- p_country3 No varchar2
42 -- p_current_job_prop_end_date No date
43 -- p_current_org_prop_end_date No date
44 -- p_date_effective No date
45 -- p_date_end No date
46 -- p_earliest_hire_date No date
47 -- p_fill_by_date No date
48 -- p_frequency No varchar2
49 -- p_fte No number
50 -- p_fte_capacity No varchar2
51 -- p_location1 No varchar2
52 -- p_location2 No varchar2
53 -- p_location3 No varchar2
54 -- p_max_persons No number
55 -- p_name No varchar2
56 -- p_other_requirements No varchar2
57 -- p_overlap_period No number
58 -- p_overlap_unit_cd No varchar2
59 -- p_passport_required No varchar2
60 -- p_pay_term_end_day_cd No varchar2
61 -- p_pay_term_end_month_cd No varchar2
62 -- p_permanent_temporary_flag No varchar2
63 -- p_permit_recruitment_flag No varchar2
64 -- p_position_type No varchar2
65 -- p_posting_description No varchar2
66 -- p_probation_period No number
67 -- p_probation_period_unit_cd No varchar2
68 -- p_relocate_domestically No varchar2
69 -- p_relocate_internationally No varchar2
70 -- p_replacement_required_flag No varchar2
71 -- p_review_flag No varchar2
72 -- p_seasonal_flag No varchar2
73 -- p_security_requirements No varchar2
74 -- p_service_minimum No varchar2
75 -- p_term_start_day_cd No varchar2
76 -- p_term_start_month_cd No varchar2
77 -- p_time_normal_finish No varchar2
78 -- p_time_normal_start No varchar2
79 -- p_transaction_status No varchar2
80 -- p_travel_required No varchar2
81 -- p_working_hours No number
82 -- p_works_council_approval_flag No varchar2
83 -- p_work_any_country No varchar2
84 -- p_work_any_location No varchar2
85 -- p_work_period_type_cd No varchar2
86 -- p_work_schedule No varchar2
87 -- p_work_duration No varchar2
88 -- p_work_term_end_day_cd No varchar2
89 -- p_work_term_end_month_cd No varchar2
90 -- p_proposed_fte_for_layoff No number
91 -- p_proposed_date_for_layoff No Date
92 -- p_information1 No varchar2
93 -- p_information2 No varchar2
94 -- p_information3 No varchar2
95 -- p_information4 No varchar2
96 -- p_information5 No varchar2
97 -- p_information6 No varchar2
98 -- p_information7 No varchar2
99 -- p_information8 No varchar2
100 -- p_information9 No varchar2
101 -- p_information10 No varchar2
102 -- p_information11 No varchar2
103 -- p_information12 No varchar2
104 -- p_information13 No varchar2
105 -- p_information14 No varchar2
106 -- p_information15 No varchar2
107 -- p_information16 No varchar2
108 -- p_information17 No varchar2
109 -- p_information18 No varchar2
110 -- p_information19 No varchar2
111 -- p_information20 No varchar2
112 -- p_information21 No varchar2
113 -- p_information22 No varchar2
114 -- p_information23 No varchar2
115 -- p_information24 No varchar2
116 -- p_information25 No varchar2
117 -- p_information26 No varchar2
118 -- p_information27 No varchar2
119 -- p_information28 No varchar2
120 -- p_information29 No varchar2
121 -- p_information30 No varchar2
122 -- p_information_category No varchar2
123 -- p_attribute1 No varchar2 Descriptive Flexfield
124 -- p_attribute2 No varchar2 Descriptive Flexfield
125 -- p_attribute3 No varchar2 Descriptive Flexfield
126 -- p_attribute4 No varchar2 Descriptive Flexfield
127 -- p_attribute5 No varchar2 Descriptive Flexfield
128 -- p_attribute6 No varchar2 Descriptive Flexfield
129 -- p_attribute7 No varchar2 Descriptive Flexfield
130 -- p_attribute8 No varchar2 Descriptive Flexfield
131 -- p_attribute9 No varchar2 Descriptive Flexfield
132 -- p_attribute10 No varchar2 Descriptive Flexfield
133 -- p_attribute11 No varchar2 Descriptive Flexfield
134 -- p_attribute12 No varchar2 Descriptive Flexfield
135 -- p_attribute13 No varchar2 Descriptive Flexfield
136 -- p_attribute14 No varchar2 Descriptive Flexfield
137 -- p_attribute15 No varchar2 Descriptive Flexfield
138 -- p_attribute16 No varchar2 Descriptive Flexfield
139 -- p_attribute17 No varchar2 Descriptive Flexfield
140 -- p_attribute18 No varchar2 Descriptive Flexfield
141 -- p_attribute19 No varchar2 Descriptive Flexfield
142 -- p_attribute20 No varchar2 Descriptive Flexfield
143 -- p_attribute21 No varchar2 Descriptive Flexfield
144 -- p_attribute22 No varchar2 Descriptive Flexfield
145 -- p_attribute23 No varchar2 Descriptive Flexfield
146 -- p_attribute24 No varchar2 Descriptive Flexfield
147 -- p_attribute25 No varchar2 Descriptive Flexfield
148 -- p_attribute26 No varchar2 Descriptive Flexfield
149 -- p_attribute27 No varchar2 Descriptive Flexfield
150 -- p_attribute28 No varchar2 Descriptive Flexfield
151 -- p_attribute29 No varchar2 Descriptive Flexfield
152 -- p_attribute30 No varchar2 Descriptive Flexfield
153 -- p_attribute_category No varchar2 Descriptive Flexfield
154 -- p_effective_date Yes date Session Date.
155 -- p_pay_basis_id No number Pay Basis
156 -- p_supervisor_id No number Supervisor
157 -- p_wf_transaction_category_id No number Wf Transaction Category Id
158 --
159 -- Post Success:
160 --
161 -- Out Parameters:
162 -- Name Type Description
163 -- p_position_transaction_id Yes number PK of record
164 -- p_object_version_number Yes number OVN of record
165 --
166 -- Post Failure:
167 --
168 -- Access Status:
169 -- Public.
170 --
171 -- {End Of Comments}
172 --
173 procedure create_position_transaction
174 (
175 p_validate in boolean default false
176 ,p_position_transaction_id out nocopy number
177 ,p_action_date in date default null
178 ,p_position_id in number default null
179 ,p_availability_status_id in number default null
180 ,p_business_group_id in number default null
181 ,p_entry_step_id in number default null
182 ,p_entry_grade_rule_id in number default null
183 ,p_job_id in number default null
184 ,p_location_id in number default null
185 ,p_organization_id in number default null
186 ,p_pay_freq_payroll_id in number default null
187 ,p_position_definition_id in number default null
188 ,p_prior_position_id in number default null
189 ,p_relief_position_id in number default null
190 ,p_entry_grade_id in number default null
191 ,p_successor_position_id in number default null
192 ,p_supervisor_position_id in number default null
193 ,p_amendment_date in date default null
194 ,p_amendment_recommendation in varchar2 default null
195 ,p_amendment_ref_number in varchar2 default null
196 ,p_avail_status_prop_end_date in date default null
197 ,p_bargaining_unit_cd in varchar2 default null
198 ,p_comments in long default null
199 ,p_country1 in varchar2 default null
200 ,p_country2 in varchar2 default null
201 ,p_country3 in varchar2 default null
202 ,p_current_job_prop_end_date in date default null
203 ,p_current_org_prop_end_date in date default null
204 ,p_date_effective in date default null
205 ,p_date_end in date default null
206 ,p_earliest_hire_date in date default null
207 ,p_fill_by_date in date default null
208 ,p_frequency in varchar2 default null
209 ,p_fte in number default null
210 ,p_fte_capacity in varchar2 default null
211 ,p_location1 in varchar2 default null
212 ,p_location2 in varchar2 default null
213 ,p_location3 in varchar2 default null
214 ,p_max_persons in number default null
215 ,p_name in varchar2 default null
216 ,p_other_requirements in varchar2 default null
217 ,p_overlap_period in number default null
218 ,p_overlap_unit_cd in varchar2 default null
219 ,p_passport_required in varchar2 default null
220 ,p_pay_term_end_day_cd in varchar2 default null
221 ,p_pay_term_end_month_cd in varchar2 default null
222 ,p_permanent_temporary_flag in varchar2 default null
223 ,p_permit_recruitment_flag in varchar2 default null
224 ,p_position_type in varchar2 default null
225 ,p_posting_description in varchar2 default null
226 ,p_probation_period in number default null
227 ,p_probation_period_unit_cd in varchar2 default null
228 ,p_relocate_domestically in varchar2 default null
229 ,p_relocate_internationally in varchar2 default null
230 ,p_replacement_required_flag in varchar2 default null
231 ,p_review_flag in varchar2 default null
232 ,p_seasonal_flag in varchar2 default null
233 ,p_security_requirements in varchar2 default null
234 ,p_service_minimum in varchar2 default null
235 ,p_term_start_day_cd in varchar2 default null
236 ,p_term_start_month_cd in varchar2 default null
237 ,p_time_normal_finish in varchar2 default null
238 ,p_time_normal_start in varchar2 default null
239 ,p_transaction_status in varchar2 default null
240 ,p_travel_required in varchar2 default null
241 ,p_working_hours in number default null
242 ,p_works_council_approval_flag in varchar2 default null
243 ,p_work_any_country in varchar2 default null
244 ,p_work_any_location in varchar2 default null
245 ,p_work_period_type_cd in varchar2 default null
246 ,p_work_schedule in varchar2 default null
247 ,p_work_duration in varchar2 default null
248 ,p_work_term_end_day_cd in varchar2 default null
249 ,p_work_term_end_month_cd in varchar2 default null
250 ,p_proposed_fte_for_layoff in number default null
251 ,p_proposed_date_for_layoff in date default null
252 ,p_information1 in varchar2 default null
253 ,p_information2 in varchar2 default null
254 ,p_information3 in varchar2 default null
255 ,p_information4 in varchar2 default null
256 ,p_information5 in varchar2 default null
257 ,p_information6 in varchar2 default null
258 ,p_information7 in varchar2 default null
259 ,p_information8 in varchar2 default null
260 ,p_information9 in varchar2 default null
261 ,p_information10 in varchar2 default null
262 ,p_information11 in varchar2 default null
263 ,p_information12 in varchar2 default null
264 ,p_information13 in varchar2 default null
265 ,p_information14 in varchar2 default null
266 ,p_information15 in varchar2 default null
267 ,p_information16 in varchar2 default null
268 ,p_information17 in varchar2 default null
269 ,p_information18 in varchar2 default null
270 ,p_information19 in varchar2 default null
271 ,p_information20 in varchar2 default null
272 ,p_information21 in varchar2 default null
273 ,p_information22 in varchar2 default null
274 ,p_information23 in varchar2 default null
275 ,p_information24 in varchar2 default null
276 ,p_information25 in varchar2 default null
277 ,p_information26 in varchar2 default null
278 ,p_information27 in varchar2 default null
279 ,p_information28 in varchar2 default null
280 ,p_information29 in varchar2 default null
281 ,p_information30 in varchar2 default null
282 ,p_information_category in varchar2 default null
283 ,p_attribute1 in varchar2 default null
284 ,p_attribute2 in varchar2 default null
285 ,p_attribute3 in varchar2 default null
286 ,p_attribute4 in varchar2 default null
287 ,p_attribute5 in varchar2 default null
288 ,p_attribute6 in varchar2 default null
289 ,p_attribute7 in varchar2 default null
290 ,p_attribute8 in varchar2 default null
291 ,p_attribute9 in varchar2 default null
292 ,p_attribute10 in varchar2 default null
293 ,p_attribute11 in varchar2 default null
294 ,p_attribute12 in varchar2 default null
295 ,p_attribute13 in varchar2 default null
296 ,p_attribute14 in varchar2 default null
300 ,p_attribute18 in varchar2 default null
297 ,p_attribute15 in varchar2 default null
298 ,p_attribute16 in varchar2 default null
299 ,p_attribute17 in varchar2 default null
301 ,p_attribute19 in varchar2 default null
302 ,p_attribute20 in varchar2 default null
303 ,p_attribute21 in varchar2 default null
304 ,p_attribute22 in varchar2 default null
305 ,p_attribute23 in varchar2 default null
306 ,p_attribute24 in varchar2 default null
307 ,p_attribute25 in varchar2 default null
308 ,p_attribute26 in varchar2 default null
309 ,p_attribute27 in varchar2 default null
310 ,p_attribute28 in varchar2 default null
311 ,p_attribute29 in varchar2 default null
312 ,p_attribute30 in varchar2 default null
313 ,p_attribute_category in varchar2 default null
314 ,p_object_version_number out nocopy number
315 ,p_effective_date in date
316 ,p_pay_basis_id in number default null
317 ,p_supervisor_id in number default null
318 ,p_wf_transaction_category_id in number default null
319 );
320 -- ----------------------------------------------------------------------------
321 -- |------------------------< update_position_transaction >------------------------|
322 -- ----------------------------------------------------------------------------
323 -- {Start Of Comments}
324 --
325 -- Description:
326 --
327 -- Prerequisites:
328 --
329 --
330 -- In Parameters:
331 -- Name Reqd Type Description
332 -- p_validate Yes boolean Commit or Rollback.
333 -- p_position_transaction_id Yes number PK of record
334 -- p_action_date No date
335 -- p_position_id No number
336 -- p_availability_status_id No number
337 -- p_business_group_id No number Business Group of Record
338 -- p_entry_step_id No number
339 -- p_entry_grade_rule_id No number
340 -- p_job_id No number
341 -- p_location_id No number
342 -- p_organization_id No number
343 -- p_pay_freq_payroll_id No number
344 -- p_position_definition_id No number
345 -- p_prior_position_id No number
346 -- p_relief_position_id No number
347 -- p_entry_grade_id No number
348 -- p_successor_position_id No number
349 -- p_supervisor_position_id No number
350 -- p_amendment_date No date
351 -- p_amendment_recommendation No varchar2
352 -- p_amendment_ref_number No varchar2
353 -- p_avail_status_prop_end_date No date
354 -- p_bargaining_unit_cd No varchar2
355 -- p_comments No long
356 -- p_country1 No varchar2
357 -- p_country2 No varchar2
358 -- p_country3 No varchar2
359 -- p_current_job_prop_end_date No date
360 -- p_current_org_prop_end_date No date
361 -- p_date_effective No date
362 -- p_date_end No date
363 -- p_earliest_hire_date No date
364 -- p_fill_by_date No date
365 -- p_frequency No varchar2
366 -- p_fte No number
367 -- p_fte_capacity No varchar2
368 -- p_location1 No varchar2
369 -- p_location2 No varchar2
370 -- p_location3 No varchar2
371 -- p_max_persons No number
372 -- p_name No varchar2
373 -- p_other_requirements No varchar2
374 -- p_overlap_period No number
375 -- p_overlap_unit_cd No varchar2
376 -- p_passport_required No varchar2
377 -- p_pay_term_end_day_cd No varchar2
378 -- p_pay_term_end_month_cd No varchar2
379 -- p_permanent_temporary_flag No varchar2
380 -- p_permit_recruitment_flag No varchar2
381 -- p_position_type No varchar2
382 -- p_posting_description No varchar2
383 -- p_probation_period No number
384 -- p_probation_period_unit_cd No varchar2
385 -- p_relocate_domestically No varchar2
386 -- p_relocate_internationally No varchar2
387 -- p_replacement_required_flag No varchar2
388 -- p_review_flag No varchar2
389 -- p_seasonal_flag No varchar2
390 -- p_security_requirements No varchar2
391 -- p_service_minimum No varchar2
392 -- p_term_start_day_cd No varchar2
393 -- p_term_start_month_cd No varchar2
394 -- p_time_normal_finish No varchar2
395 -- p_time_normal_start No varchar2
396 -- p_transaction_status No varchar2
397 -- p_travel_required No varchar2
398 -- p_working_hours No number
399 -- p_works_council_approval_flag No varchar2
400 -- p_work_any_country No varchar2
401 -- p_work_any_location No varchar2
402 -- p_work_period_type_cd No varchar2
406 -- p_work_term_end_month_cd No varchar2
403 -- p_work_schedule No varchar2
404 -- p_work_duration No varchar2
405 -- p_work_term_end_day_cd No varchar2
407 -- p_proposed_fte_for_layoff No number
408 -- p_proposed_date_for_layoff No Date
409 -- p_information1 No varchar2
410 -- p_information2 No varchar2
411 -- p_information3 No varchar2
412 -- p_information4 No varchar2
413 -- p_information5 No varchar2
414 -- p_information6 No varchar2
415 -- p_information7 No varchar2
416 -- p_information8 No varchar2
417 -- p_information9 No varchar2
418 -- p_information10 No varchar2
419 -- p_information11 No varchar2
420 -- p_information12 No varchar2
421 -- p_information13 No varchar2
422 -- p_information14 No varchar2
423 -- p_information15 No varchar2
424 -- p_information16 No varchar2
425 -- p_information17 No varchar2
426 -- p_information18 No varchar2
427 -- p_information19 No varchar2
428 -- p_information20 No varchar2
429 -- p_information21 No varchar2
430 -- p_information22 No varchar2
431 -- p_information23 No varchar2
432 -- p_information24 No varchar2
433 -- p_information25 No varchar2
434 -- p_information26 No varchar2
435 -- p_information27 No varchar2
436 -- p_information28 No varchar2
437 -- p_information29 No varchar2
438 -- p_information30 No varchar2
439 -- p_information_category No varchar2
440 -- p_attribute1 No varchar2 Descriptive Flexfield
441 -- p_attribute2 No varchar2 Descriptive Flexfield
442 -- p_attribute3 No varchar2 Descriptive Flexfield
443 -- p_attribute4 No varchar2 Descriptive Flexfield
444 -- p_attribute5 No varchar2 Descriptive Flexfield
445 -- p_attribute6 No varchar2 Descriptive Flexfield
446 -- p_attribute7 No varchar2 Descriptive Flexfield
447 -- p_attribute8 No varchar2 Descriptive Flexfield
448 -- p_attribute9 No varchar2 Descriptive Flexfield
449 -- p_attribute10 No varchar2 Descriptive Flexfield
450 -- p_attribute11 No varchar2 Descriptive Flexfield
451 -- p_attribute12 No varchar2 Descriptive Flexfield
452 -- p_attribute13 No varchar2 Descriptive Flexfield
453 -- p_attribute14 No varchar2 Descriptive Flexfield
454 -- p_attribute15 No varchar2 Descriptive Flexfield
455 -- p_attribute16 No varchar2 Descriptive Flexfield
456 -- p_attribute17 No varchar2 Descriptive Flexfield
457 -- p_attribute18 No varchar2 Descriptive Flexfield
458 -- p_attribute19 No varchar2 Descriptive Flexfield
459 -- p_attribute20 No varchar2 Descriptive Flexfield
460 -- p_attribute21 No varchar2 Descriptive Flexfield
461 -- p_attribute22 No varchar2 Descriptive Flexfield
462 -- p_attribute23 No varchar2 Descriptive Flexfield
463 -- p_attribute24 No varchar2 Descriptive Flexfield
464 -- p_attribute25 No varchar2 Descriptive Flexfield
465 -- p_attribute26 No varchar2 Descriptive Flexfield
466 -- p_attribute27 No varchar2 Descriptive Flexfield
467 -- p_attribute28 No varchar2 Descriptive Flexfield
468 -- p_attribute29 No varchar2 Descriptive Flexfield
469 -- p_attribute30 No varchar2 Descriptive Flexfield
470 -- p_attribute_category No varchar2 Descriptive Flexfield
471 -- p_effective_date Yes date Session Date.
472 -- p_pay_basis_id No number Pay Basis
473 -- p_supervisor_id No number Supervisor
474 -- p_wf_transaction_category_id No number Wf Transaction Category Id
475 --
476 -- Post Success:
477 --
478 -- Name Type Description
479 -- p_object_version_number Yes number OVN of record
480 --
481 -- Post Failure:
482 --
483 -- Access Status:
484 -- Public.
485 --
486 -- {End Of Comments}
487 --
488 procedure update_position_transaction
489 (
490 p_validate in boolean default false
491 ,p_position_transaction_id in number
492 ,p_action_date in date default hr_api.g_date
493 ,p_position_id in number default hr_api.g_number
494 ,p_availability_status_id in number default hr_api.g_number
495 ,p_business_group_id in number default hr_api.g_number
496 ,p_entry_step_id in number default hr_api.g_number
497 ,p_entry_grade_rule_id in number default hr_api.g_number
498 ,p_job_id in number default hr_api.g_number
499 ,p_location_id in number default hr_api.g_number
500 ,p_organization_id in number default hr_api.g_number
501 ,p_pay_freq_payroll_id in number default hr_api.g_number
505 ,p_entry_grade_id in number default hr_api.g_number
502 ,p_position_definition_id in number default hr_api.g_number
503 ,p_prior_position_id in number default hr_api.g_number
504 ,p_relief_position_id in number default hr_api.g_number
506 ,p_successor_position_id in number default hr_api.g_number
507 ,p_supervisor_position_id in number default hr_api.g_number
508 ,p_amendment_date in date default hr_api.g_date
509 ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
510 ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
511 ,p_avail_status_prop_end_date in date default hr_api.g_date
512 ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
513 ,p_comments in long default null
514 ,p_country1 in varchar2 default hr_api.g_varchar2
515 ,p_country2 in varchar2 default hr_api.g_varchar2
516 ,p_country3 in varchar2 default hr_api.g_varchar2
517 ,p_current_job_prop_end_date in date default hr_api.g_date
518 ,p_current_org_prop_end_date in date default hr_api.g_date
519 ,p_date_effective in date default hr_api.g_date
520 ,p_date_end in date default hr_api.g_date
521 ,p_earliest_hire_date in date default hr_api.g_date
522 ,p_fill_by_date in date default hr_api.g_date
523 ,p_frequency in varchar2 default hr_api.g_varchar2
524 ,p_fte in number default hr_api.g_number
525 ,p_fte_capacity in varchar2 default hr_api.g_varchar2
526 ,p_location1 in varchar2 default hr_api.g_varchar2
527 ,p_location2 in varchar2 default hr_api.g_varchar2
528 ,p_location3 in varchar2 default hr_api.g_varchar2
529 ,p_max_persons in number default hr_api.g_number
530 ,p_name in varchar2 default hr_api.g_varchar2
531 ,p_other_requirements in varchar2 default hr_api.g_varchar2
532 ,p_overlap_period in number default hr_api.g_number
533 ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
534 ,p_passport_required in varchar2 default hr_api.g_varchar2
535 ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
536 ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
537 ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
538 ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
539 ,p_position_type in varchar2 default hr_api.g_varchar2
540 ,p_posting_description in varchar2 default hr_api.g_varchar2
541 ,p_probation_period in number default hr_api.g_number
542 ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
543 ,p_relocate_domestically in varchar2 default hr_api.g_varchar2
544 ,p_relocate_internationally in varchar2 default hr_api.g_varchar2
545 ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
546 ,p_review_flag in varchar2 default hr_api.g_varchar2
547 ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
548 ,p_security_requirements in varchar2 default hr_api.g_varchar2
549 ,p_service_minimum in varchar2 default hr_api.g_varchar2
550 ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
551 ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
552 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
553 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
554 ,p_transaction_status in varchar2 default hr_api.g_varchar2
555 ,p_travel_required in varchar2 default hr_api.g_varchar2
556 ,p_working_hours in number default hr_api.g_number
557 ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
558 ,p_work_any_country in varchar2 default hr_api.g_varchar2
559 ,p_work_any_location in varchar2 default hr_api.g_varchar2
560 ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
561 ,p_work_schedule in varchar2 default hr_api.g_varchar2
562 ,p_work_duration in varchar2 default hr_api.g_varchar2
563 ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
564 ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
565 ,p_proposed_fte_for_layoff in number default hr_api.g_number
566 ,p_proposed_date_for_layoff in date default hr_api.g_date
567 ,p_information1 in varchar2 default hr_api.g_varchar2
568 ,p_information2 in varchar2 default hr_api.g_varchar2
569 ,p_information3 in varchar2 default hr_api.g_varchar2
570 ,p_information4 in varchar2 default hr_api.g_varchar2
571 ,p_information5 in varchar2 default hr_api.g_varchar2
572 ,p_information6 in varchar2 default hr_api.g_varchar2
573 ,p_information7 in varchar2 default hr_api.g_varchar2
574 ,p_information8 in varchar2 default hr_api.g_varchar2
575 ,p_information9 in varchar2 default hr_api.g_varchar2
576 ,p_information10 in varchar2 default hr_api.g_varchar2
577 ,p_information11 in varchar2 default hr_api.g_varchar2
578 ,p_information12 in varchar2 default hr_api.g_varchar2
579 ,p_information13 in varchar2 default hr_api.g_varchar2
580 ,p_information14 in varchar2 default hr_api.g_varchar2
581 ,p_information15 in varchar2 default hr_api.g_varchar2
582 ,p_information16 in varchar2 default hr_api.g_varchar2
583 ,p_information17 in varchar2 default hr_api.g_varchar2
584 ,p_information18 in varchar2 default hr_api.g_varchar2
585 ,p_information19 in varchar2 default hr_api.g_varchar2
586 ,p_information20 in varchar2 default hr_api.g_varchar2
587 ,p_information21 in varchar2 default hr_api.g_varchar2
588 ,p_information22 in varchar2 default hr_api.g_varchar2
589 ,p_information23 in varchar2 default hr_api.g_varchar2
590 ,p_information24 in varchar2 default hr_api.g_varchar2
591 ,p_information25 in varchar2 default hr_api.g_varchar2
592 ,p_information26 in varchar2 default hr_api.g_varchar2
593 ,p_information27 in varchar2 default hr_api.g_varchar2
594 ,p_information28 in varchar2 default hr_api.g_varchar2
595 ,p_information29 in varchar2 default hr_api.g_varchar2
596 ,p_information30 in varchar2 default hr_api.g_varchar2
597 ,p_information_category in varchar2 default hr_api.g_varchar2
598 ,p_attribute1 in varchar2 default hr_api.g_varchar2
599 ,p_attribute2 in varchar2 default hr_api.g_varchar2
600 ,p_attribute3 in varchar2 default hr_api.g_varchar2
601 ,p_attribute4 in varchar2 default hr_api.g_varchar2
602 ,p_attribute5 in varchar2 default hr_api.g_varchar2
603 ,p_attribute6 in varchar2 default hr_api.g_varchar2
604 ,p_attribute7 in varchar2 default hr_api.g_varchar2
605 ,p_attribute8 in varchar2 default hr_api.g_varchar2
606 ,p_attribute9 in varchar2 default hr_api.g_varchar2
607 ,p_attribute10 in varchar2 default hr_api.g_varchar2
608 ,p_attribute11 in varchar2 default hr_api.g_varchar2
609 ,p_attribute12 in varchar2 default hr_api.g_varchar2
610 ,p_attribute13 in varchar2 default hr_api.g_varchar2
611 ,p_attribute14 in varchar2 default hr_api.g_varchar2
612 ,p_attribute15 in varchar2 default hr_api.g_varchar2
613 ,p_attribute16 in varchar2 default hr_api.g_varchar2
614 ,p_attribute17 in varchar2 default hr_api.g_varchar2
615 ,p_attribute18 in varchar2 default hr_api.g_varchar2
616 ,p_attribute19 in varchar2 default hr_api.g_varchar2
617 ,p_attribute20 in varchar2 default hr_api.g_varchar2
618 ,p_attribute21 in varchar2 default hr_api.g_varchar2
619 ,p_attribute22 in varchar2 default hr_api.g_varchar2
620 ,p_attribute23 in varchar2 default hr_api.g_varchar2
621 ,p_attribute24 in varchar2 default hr_api.g_varchar2
622 ,p_attribute25 in varchar2 default hr_api.g_varchar2
623 ,p_attribute26 in varchar2 default hr_api.g_varchar2
624 ,p_attribute27 in varchar2 default hr_api.g_varchar2
625 ,p_attribute28 in varchar2 default hr_api.g_varchar2
626 ,p_attribute29 in varchar2 default hr_api.g_varchar2
627 ,p_attribute30 in varchar2 default hr_api.g_varchar2
628 ,p_attribute_category in varchar2 default hr_api.g_varchar2
629 ,p_object_version_number in out nocopy number
630 ,p_effective_date in date
631 ,p_pay_basis_id in number default hr_api.g_number
632 ,p_supervisor_id in number default hr_api.g_number
633 ,p_wf_transaction_category_id in number default hr_api.g_number
634 );
635 --
636 -- ----------------------------------------------------------------------------
637 -- |------------------------< delete_position_transaction >------------------------|
638 -- ----------------------------------------------------------------------------
639 -- {Start Of Comments}
640 --
641 -- Description:
642 --
643 -- Prerequisites:
644 --
645 --
646 -- In Parameters:
647 -- Name Reqd Type Description
648 -- p_validate Yes boolean Commit or Rollback.
649 -- p_position_transaction_id Yes number PK of record
650 -- p_effective_date Yes date Session Date.
651 --
652 -- Post Success:
653 --
654 -- Name Type Description
655 -- p_object_version_number Yes number OVN of record
656 --
657 -- Post Failure:
658 --
659 -- Access Status:
660 -- Public.
661 --
662 -- {End Of Comments}
663 --
664 procedure delete_position_transaction
665 (
666 p_validate in boolean default false
667 ,p_position_transaction_id in number
668 ,p_object_version_number in number
669 ,p_effective_date in date
670 );
671 --
672 --
673 end pqh_position_transactions_api;
[Home] [Help]