1 Package hr_position_swi AUTHID CURRENT_USER As
2 /* $Header: hrposswi.pkh 120.1 2012/02/03 09:40:32 shpatro ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------------< create_position >---------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: hr_position_api.create_position
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_position
27 (p_position_id out nocopy number
28 ,p_effective_start_date out nocopy date
29 ,p_effective_end_date out nocopy date
30 ,p_position_definition_id out nocopy number
31 ,p_name out nocopy varchar2
32 ,p_object_version_number out nocopy number
33 ,p_job_id in number
34 ,p_organization_id in number
35 ,p_effective_date in date
36 ,p_date_effective in date
37 ,p_validate in number default hr_api.g_false_num
38 ,p_availability_status_id in number default null
39 ,p_business_group_id in number default null
40 ,p_entry_step_id in number default null
41 ,p_entry_grade_rule_id in number default null
42 ,p_location_id in number default null
43 ,p_pay_freq_payroll_id in number default null
44 ,p_position_transaction_id in number default null
45 ,p_prior_position_id in number default null
46 ,p_relief_position_id in number default null
47 ,p_entry_grade_id in number default null
48 ,p_successor_position_id in number default null
49 ,p_supervisor_position_id in number default null
53 ,p_bargaining_unit_cd in varchar2 default null
50 ,p_amendment_date in date default null
51 ,p_amendment_recommendation in varchar2 default null
52 ,p_amendment_ref_number in varchar2 default null
54 ,p_comments in CLOB default null -- Bug#13375642
55 ,p_current_job_prop_end_date in date default null
56 ,p_current_org_prop_end_date in date default null
57 ,p_avail_status_prop_end_date in date default null
58 ,p_date_end in date default null
59 ,p_earliest_hire_date in date default null
60 ,p_fill_by_date in date default null
61 ,p_frequency in varchar2 default null
62 ,p_fte in number default null
63 ,p_max_persons in number default null
64 ,p_overlap_period in number default null
65 ,p_overlap_unit_cd in varchar2 default null
66 ,p_pay_term_end_day_cd in varchar2 default null
67 ,p_pay_term_end_month_cd in varchar2 default null
68 ,p_permanent_temporary_flag in varchar2 default null
69 ,p_permit_recruitment_flag in varchar2 default null
70 ,p_position_type in varchar2 default null
71 ,p_posting_description in varchar2 default null
72 ,p_probation_period in number default null
73 ,p_probation_period_unit_cd in varchar2 default null
74 ,p_replacement_required_flag in varchar2 default null
75 ,p_review_flag in varchar2 default null
76 ,p_seasonal_flag in varchar2 default null
77 ,p_security_requirements in varchar2 default null
78 ,p_status in varchar2 default null
79 ,p_term_start_day_cd in varchar2 default null
80 ,p_term_start_month_cd in varchar2 default null
81 ,p_time_normal_finish in varchar2 default null
82 ,p_time_normal_start in varchar2 default null
83 ,p_update_source_cd in varchar2 default null
84 ,p_working_hours in number default null
85 ,p_works_council_approval_flag in varchar2 default null
86 ,p_work_period_type_cd in varchar2 default null
87 ,p_work_term_end_day_cd in varchar2 default null
88 ,p_work_term_end_month_cd in varchar2 default null
89 ,p_proposed_fte_for_layoff in number default null
90 ,p_proposed_date_for_layoff in date default null
91 ,p_pay_basis_id in number default null
92 ,p_supervisor_id in number default null
93 ,p_information1 in varchar2 default null
94 ,p_information2 in varchar2 default null
95 ,p_information3 in varchar2 default null
96 ,p_information4 in varchar2 default null
97 ,p_information5 in varchar2 default null
98 ,p_information6 in varchar2 default null
99 ,p_information7 in varchar2 default null
100 ,p_information8 in varchar2 default null
101 ,p_information9 in varchar2 default null
102 ,p_information10 in varchar2 default null
103 ,p_information11 in varchar2 default null
104 ,p_information12 in varchar2 default null
105 ,p_information13 in varchar2 default null
106 ,p_information14 in varchar2 default null
107 ,p_information15 in varchar2 default null
108 ,p_information16 in varchar2 default null
109 ,p_information17 in varchar2 default null
110 ,p_information18 in varchar2 default null
111 ,p_information19 in varchar2 default null
112 ,p_information20 in varchar2 default null
113 ,p_information21 in varchar2 default null
114 ,p_information22 in varchar2 default null
115 ,p_information23 in varchar2 default null
116 ,p_information24 in varchar2 default null
117 ,p_information25 in varchar2 default null
118 ,p_information26 in varchar2 default null
119 ,p_information27 in varchar2 default null
120 ,p_information28 in varchar2 default null
121 ,p_information29 in varchar2 default null
122 ,p_information30 in varchar2 default null
123 ,p_information_category in varchar2 default null
124 ,p_attribute1 in varchar2 default null
125 ,p_attribute2 in varchar2 default null
126 ,p_attribute3 in varchar2 default null
127 ,p_attribute4 in varchar2 default null
128 ,p_attribute5 in varchar2 default null
129 ,p_attribute6 in varchar2 default null
130 ,p_attribute7 in varchar2 default null
131 ,p_attribute8 in varchar2 default null
132 ,p_attribute9 in varchar2 default null
133 ,p_attribute10 in varchar2 default null
134 ,p_attribute11 in varchar2 default null
135 ,p_attribute12 in varchar2 default null
136 ,p_attribute13 in varchar2 default null
137 ,p_attribute14 in varchar2 default null
138 ,p_attribute15 in varchar2 default null
142 ,p_attribute19 in varchar2 default null
139 ,p_attribute16 in varchar2 default null
140 ,p_attribute17 in varchar2 default null
141 ,p_attribute18 in varchar2 default null
143 ,p_attribute20 in varchar2 default null
144 ,p_attribute21 in varchar2 default null
145 ,p_attribute22 in varchar2 default null
146 ,p_attribute23 in varchar2 default null
147 ,p_attribute24 in varchar2 default null
148 ,p_attribute25 in varchar2 default null
149 ,p_attribute26 in varchar2 default null
150 ,p_attribute27 in varchar2 default null
151 ,p_attribute28 in varchar2 default null
152 ,p_attribute29 in varchar2 default null
153 ,p_attribute30 in varchar2 default null
154 ,p_attribute_category in varchar2 default null
155 ,p_segment1 in varchar2 default null
156 ,p_segment2 in varchar2 default null
157 ,p_segment3 in varchar2 default null
158 ,p_segment4 in varchar2 default null
159 ,p_segment5 in varchar2 default null
160 ,p_segment6 in varchar2 default null
161 ,p_segment7 in varchar2 default null
162 ,p_segment8 in varchar2 default null
163 ,p_segment9 in varchar2 default null
164 ,p_segment10 in varchar2 default null
165 ,p_segment11 in varchar2 default null
166 ,p_segment12 in varchar2 default null
167 ,p_segment13 in varchar2 default null
168 ,p_segment14 in varchar2 default null
169 ,p_segment15 in varchar2 default null
170 ,p_segment16 in varchar2 default null
171 ,p_segment17 in varchar2 default null
172 ,p_segment18 in varchar2 default null
173 ,p_segment19 in varchar2 default null
174 ,p_segment20 in varchar2 default null
175 ,p_segment21 in varchar2 default null
176 ,p_segment22 in varchar2 default null
177 ,p_segment23 in varchar2 default null
178 ,p_segment24 in varchar2 default null
179 ,p_segment25 in varchar2 default null
180 ,p_segment26 in varchar2 default null
181 ,p_segment27 in varchar2 default null
182 ,p_segment28 in varchar2 default null
183 ,p_segment29 in varchar2 default null
184 ,p_segment30 in varchar2 default null
185 ,p_concat_segments in varchar2 default null
186 ,p_request_id in number default null
187 ,p_program_application_id in number default null
188 ,p_program_id in number default null
189 ,p_program_update_date in date default null
190 ,p_security_profile_id in number default null
191 ,p_return_status out nocopy varchar2
192 );
193 -- ----------------------------------------------------------------------------
194 -- |----------------------------< delete_position >---------------------------|
195 -- ----------------------------------------------------------------------------
196 -- {Start of comments}
197 --
198 -- Description:
199 -- This procedure is the self-service wrapper procedure to the following
200 -- API: hr_position_api.delete_position
201 --
202 -- Pre-requisites
203 -- All 'IN' parameters to this procedure have been appropriately derived.
204 --
205 -- Post Success:
206 -- p_return_status will return value indicating success.
207 --
208 -- Post Failure:
209 -- p_return_status will return value indication failure.
210 --
211 -- Access Status:
212 -- Internal Development use only.
213 --
214 -- {End of comments}
215 -- ----------------------------------------------------------------------------
216 PROCEDURE delete_position
217 (p_validate in number default hr_api.g_false_num
218 ,p_position_id in number
219 ,p_effective_start_date out nocopy date
220 ,p_effective_end_date out nocopy date
221 ,p_object_version_number in out nocopy number
222 ,p_effective_date in date
223 ,p_datetrack_mode in varchar2
224 ,p_security_profile_id in number default hr_api.g_number
225 ,p_return_status out nocopy varchar2
226 );
227 -- ----------------------------------------------------------------------------
228 -- |----------------------------------< lck >---------------------------------|
229 -- ----------------------------------------------------------------------------
230 -- {Start of comments}
231 --
232 -- Description:
233 -- This procedure is the self-service wrapper procedure to the following
234 -- API: hr_position_api.lck
235 --
236 -- Pre-requisites
237 -- All 'IN' parameters to this procedure have been appropriately derived.
238 --
239 -- Post Success:
240 -- p_return_status will return value indicating success.
241 --
242 -- Post Failure:
243 -- p_return_status will return value indication failure.
244 --
245 -- Access Status:
246 -- Internal Development use only.
247 --
251 (p_position_id in number
248 -- {End of comments}
249 -- ----------------------------------------------------------------------------
250 PROCEDURE lck
252 ,p_object_version_number in number
253 ,p_effective_date in date
254 ,p_datetrack_mode in varchar2
255 ,p_validation_start_date out nocopy date
256 ,p_validation_end_date out nocopy date
257 ,p_return_status out nocopy varchar2
258 );
259 -- ----------------------------------------------------------------------------
260 -- |----------------------------< update_position >---------------------------|
261 -- ----------------------------------------------------------------------------
262 -- {Start of comments}
263 --
264 -- Description:
265 -- This procedure is the self-service wrapper procedure to the following
266 -- API: hr_position_api.update_position
267 --
268 -- Pre-requisites
269 -- All 'IN' parameters to this procedure have been appropriately derived.
270 --
271 -- Post Success:
272 -- p_return_status will return value indicating success.
273 --
274 -- Post Failure:
275 -- p_return_status will return value indication failure.
276 --
277 -- Access Status:
278 -- Internal Development use only.
279 --
280 -- {End of comments}
281 -- ----------------------------------------------------------------------------
282 PROCEDURE update_position
283 (p_validate in number default hr_api.g_false_num
284 ,p_position_id in number
285 ,p_effective_start_date out nocopy date
286 ,p_effective_end_date out nocopy date
287 ,p_position_definition_id out nocopy number
288 ,p_name out nocopy varchar2
289 ,p_availability_status_id in number default hr_api.g_number
290 ,p_entry_step_id in number default hr_api.g_number
291 ,p_entry_grade_rule_id in number default hr_api.g_number
292 ,p_location_id in number default hr_api.g_number
293 ,p_pay_freq_payroll_id in number default hr_api.g_number
294 ,p_position_transaction_id in number default hr_api.g_number
295 ,p_prior_position_id in number default hr_api.g_number
296 ,p_relief_position_id in number default hr_api.g_number
297 ,p_entry_grade_id in number default hr_api.g_number
298 ,p_successor_position_id in number default hr_api.g_number
299 ,p_supervisor_position_id in number default hr_api.g_number
300 ,p_amendment_date in date default hr_api.g_date
301 ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
302 ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
303 ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
304 ,p_comments in CLOB default hr_api.g_varchar2 -- Bug#13375642
305 ,p_current_job_prop_end_date in date default hr_api.g_date
306 ,p_current_org_prop_end_date in date default hr_api.g_date
307 ,p_avail_status_prop_end_date in date default hr_api.g_date
308 ,p_date_effective in date default hr_api.g_date
309 ,p_date_end in date default hr_api.g_date
310 ,p_earliest_hire_date in date default hr_api.g_date
311 ,p_fill_by_date in date default hr_api.g_date
312 ,p_frequency in varchar2 default hr_api.g_varchar2
313 ,p_fte in number default hr_api.g_number
314 ,p_max_persons in number default hr_api.g_number
315 ,p_overlap_period in number default hr_api.g_number
316 ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
317 ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
318 ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
319 ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
320 ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
321 ,p_position_type in varchar2 default hr_api.g_varchar2
322 ,p_posting_description in varchar2 default hr_api.g_varchar2
323 ,p_probation_period in number default hr_api.g_number
324 ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
325 ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
326 ,p_review_flag in varchar2 default hr_api.g_varchar2
327 ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
328 ,p_security_requirements in varchar2 default hr_api.g_varchar2
329 ,p_status in varchar2 default hr_api.g_varchar2
330 ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
331 ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
332 ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
333 ,p_time_normal_start in varchar2 default hr_api.g_varchar2
334 ,p_update_source_cd in varchar2 default hr_api.g_varchar2
335 ,p_working_hours in number default hr_api.g_number
336 ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
337 ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
338 ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
339 ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
340 ,p_proposed_fte_for_layoff in number default hr_api.g_number
341 ,p_proposed_date_for_layoff in date default hr_api.g_date
342 ,p_pay_basis_id in number default hr_api.g_number
343 ,p_supervisor_id in number default hr_api.g_number
344 ,p_information1 in varchar2 default hr_api.g_varchar2
345 ,p_information2 in varchar2 default hr_api.g_varchar2
346 ,p_information3 in varchar2 default hr_api.g_varchar2
347 ,p_information4 in varchar2 default hr_api.g_varchar2
348 ,p_information5 in varchar2 default hr_api.g_varchar2
349 ,p_information6 in varchar2 default hr_api.g_varchar2
350 ,p_information7 in varchar2 default hr_api.g_varchar2
351 ,p_information8 in varchar2 default hr_api.g_varchar2
352 ,p_information9 in varchar2 default hr_api.g_varchar2
353 ,p_information10 in varchar2 default hr_api.g_varchar2
354 ,p_information11 in varchar2 default hr_api.g_varchar2
355 ,p_information12 in varchar2 default hr_api.g_varchar2
356 ,p_information13 in varchar2 default hr_api.g_varchar2
357 ,p_information14 in varchar2 default hr_api.g_varchar2
358 ,p_information15 in varchar2 default hr_api.g_varchar2
359 ,p_information16 in varchar2 default hr_api.g_varchar2
360 ,p_information17 in varchar2 default hr_api.g_varchar2
361 ,p_information18 in varchar2 default hr_api.g_varchar2
362 ,p_information19 in varchar2 default hr_api.g_varchar2
363 ,p_information20 in varchar2 default hr_api.g_varchar2
364 ,p_information21 in varchar2 default hr_api.g_varchar2
365 ,p_information22 in varchar2 default hr_api.g_varchar2
366 ,p_information23 in varchar2 default hr_api.g_varchar2
367 ,p_information24 in varchar2 default hr_api.g_varchar2
368 ,p_information25 in varchar2 default hr_api.g_varchar2
369 ,p_information26 in varchar2 default hr_api.g_varchar2
370 ,p_information27 in varchar2 default hr_api.g_varchar2
371 ,p_information28 in varchar2 default hr_api.g_varchar2
372 ,p_information29 in varchar2 default hr_api.g_varchar2
373 ,p_information30 in varchar2 default hr_api.g_varchar2
374 ,p_information_category in varchar2 default hr_api.g_varchar2
375 ,p_attribute1 in varchar2 default hr_api.g_varchar2
376 ,p_attribute2 in varchar2 default hr_api.g_varchar2
377 ,p_attribute3 in varchar2 default hr_api.g_varchar2
378 ,p_attribute4 in varchar2 default hr_api.g_varchar2
379 ,p_attribute5 in varchar2 default hr_api.g_varchar2
380 ,p_attribute6 in varchar2 default hr_api.g_varchar2
381 ,p_attribute7 in varchar2 default hr_api.g_varchar2
382 ,p_attribute8 in varchar2 default hr_api.g_varchar2
383 ,p_attribute9 in varchar2 default hr_api.g_varchar2
384 ,p_attribute10 in varchar2 default hr_api.g_varchar2
385 ,p_attribute11 in varchar2 default hr_api.g_varchar2
386 ,p_attribute12 in varchar2 default hr_api.g_varchar2
387 ,p_attribute13 in varchar2 default hr_api.g_varchar2
388 ,p_attribute14 in varchar2 default hr_api.g_varchar2
389 ,p_attribute15 in varchar2 default hr_api.g_varchar2
390 ,p_attribute16 in varchar2 default hr_api.g_varchar2
391 ,p_attribute17 in varchar2 default hr_api.g_varchar2
392 ,p_attribute18 in varchar2 default hr_api.g_varchar2
393 ,p_attribute19 in varchar2 default hr_api.g_varchar2
394 ,p_attribute20 in varchar2 default hr_api.g_varchar2
395 ,p_attribute21 in varchar2 default hr_api.g_varchar2
396 ,p_attribute22 in varchar2 default hr_api.g_varchar2
397 ,p_attribute23 in varchar2 default hr_api.g_varchar2
398 ,p_attribute24 in varchar2 default hr_api.g_varchar2
399 ,p_attribute25 in varchar2 default hr_api.g_varchar2
400 ,p_attribute26 in varchar2 default hr_api.g_varchar2
401 ,p_attribute27 in varchar2 default hr_api.g_varchar2
402 ,p_attribute28 in varchar2 default hr_api.g_varchar2
403 ,p_attribute29 in varchar2 default hr_api.g_varchar2
404 ,p_attribute30 in varchar2 default hr_api.g_varchar2
405 ,p_attribute_category in varchar2 default hr_api.g_varchar2
406 ,p_segment1 in varchar2 default hr_api.g_varchar2
407 ,p_segment2 in varchar2 default hr_api.g_varchar2
408 ,p_segment3 in varchar2 default hr_api.g_varchar2
409 ,p_segment4 in varchar2 default hr_api.g_varchar2
410 ,p_segment5 in varchar2 default hr_api.g_varchar2
411 ,p_segment6 in varchar2 default hr_api.g_varchar2
412 ,p_segment7 in varchar2 default hr_api.g_varchar2
413 ,p_segment8 in varchar2 default hr_api.g_varchar2
414 ,p_segment9 in varchar2 default hr_api.g_varchar2
415 ,p_segment10 in varchar2 default hr_api.g_varchar2
416 ,p_segment11 in varchar2 default hr_api.g_varchar2
417 ,p_segment12 in varchar2 default hr_api.g_varchar2
418 ,p_segment13 in varchar2 default hr_api.g_varchar2
419 ,p_segment14 in varchar2 default hr_api.g_varchar2
420 ,p_segment15 in varchar2 default hr_api.g_varchar2
421 ,p_segment16 in varchar2 default hr_api.g_varchar2
422 ,p_segment17 in varchar2 default hr_api.g_varchar2
423 ,p_segment18 in varchar2 default hr_api.g_varchar2
424 ,p_segment19 in varchar2 default hr_api.g_varchar2
425 ,p_segment20 in varchar2 default hr_api.g_varchar2
426 ,p_segment21 in varchar2 default hr_api.g_varchar2
427 ,p_segment22 in varchar2 default hr_api.g_varchar2
428 ,p_segment23 in varchar2 default hr_api.g_varchar2
429 ,p_segment24 in varchar2 default hr_api.g_varchar2
430 ,p_segment25 in varchar2 default hr_api.g_varchar2
431 ,p_segment26 in varchar2 default hr_api.g_varchar2
432 ,p_segment27 in varchar2 default hr_api.g_varchar2
433 ,p_segment28 in varchar2 default hr_api.g_varchar2
434 ,p_segment29 in varchar2 default hr_api.g_varchar2
435 ,p_segment30 in varchar2 default hr_api.g_varchar2
436 ,p_concat_segments in varchar2 default hr_api.g_varchar2
437 ,p_request_id in number default hr_api.g_number
438 ,p_program_application_id in number default hr_api.g_number
439 ,p_program_id in number default hr_api.g_number
440 ,p_program_update_date in date default hr_api.g_date
441 ,p_object_version_number in out nocopy number
442 ,p_effective_date in date
443 ,p_datetrack_mode in varchar2
444 ,p_return_status out nocopy varchar2
445 );
446 end hr_position_swi;