1 Package pqh_assign_accommodations_api as
2 /* $Header: pqasaapi.pkh 120.1 2005/10/02 02:25:29 aroussel $ */
3 /*#
4 * This package contains APIs to create, update and delete an employee's
5 * accommodation row.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Assign Accommodation for France
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-----------------------< create_assign_accommodation >--------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates a new accommodation assignment, recording the employee
18 * accommodated.
19 *
20 * API associates an employee to an accommodation starting from the effective
21 * date.
22 *
23 * <p><b>Licensing</b><br>
24 * This API is licensed for use with Human Resources.
25 *
26 * <p><b>Prerequisites</b><br>
27 * Accommodation and the employee must exist as of the effective date.
28 *
29 * <p><b>Post Success</b><br>
30 * A new accommodation assignment record is created in the database.
31 *
32 * <p><b>Post Failure</b><br>
33 * An accommodation assignment record is not created in the database and an
34 * error is raised
35 * @param p_validate If true, then validation alone will be performed and the
36 * database will remain unchanged. If false and all validation checks pass,
37 * then the database will be modified.
38 * @param p_effective_date Determines when the Date Track operation comes into
39 * force
40 * @param p_business_group_id Identifies the business group for which the
41 * accommodation assignment is created
42 * @param p_assignment_id Identifies the employee assignment to which the
43 * accommodation is assigned. Must be a valid 'Employee' assignment as of the
44 * effective date.
45 * @param p_accommodation_given Flag denoting whether the employee is
46 * accommodated or not.
47 * @param p_temporary_assignment Flag denoting whether the accommodation is
48 * being temporarily or permanently assigned. Valid values are identified by
49 * lookup type 'PQH_ACCO_ASSIGN_TYPE'
50 * @param p_accommodation_id Identifies the accommodation which is being
51 * assigned. It references PQH_ACCOMMODATIONS_F table
52 * @param p_acceptance_date Date on which the employee accepted the
53 * accommodation assignment.
54 * @param p_moving_date Date on which the employee will move in to the
55 * accommodation.
56 * @param p_refusal_date Date on which employee refused the accommodation
57 * assignment.
58 * @param p_comments Comment text
59 * @param p_indemnity_entitlement Flag denoting whether the employee is
60 * eligible to be paid the indemnity for accommodation.
61 * @param p_indemnity_amount Indemnity amount to be paid to the employee, if
62 * not accommodated.
63 * @param p_type_of_payment Identifies the type of the payment. Value can only
64 * be not null if accommodation_given parameter is set to false.
65 * @param p_information_category This context value determines which flexfield
66 * structure to use with the developer descriptive flexfield segments.
67 * @param p_information1 Developer descriptive flexfield segment.
68 * @param p_information2 Developer descriptive flexfield segment.
69 * @param p_information3 Developer descriptive flexfield segment.
70 * @param p_information4 Developer descriptive flexfield segment.
71 * @param p_information5 Developer descriptive flexfield segment.
72 * @param p_information6 Developer descriptive flexfield segment.
73 * @param p_information7 Developer descriptive flexfield segment.
74 * @param p_information8 Developer descriptive flexfield segment.
75 * @param p_information9 Developer descriptive flexfield segment.
76 * @param p_information10 Developer descriptive flexfield segment.
77 * @param p_information11 Developer descriptive flexfield segment.
78 * @param p_information12 Developer descriptive flexfield segment.
79 * @param p_information13 Developer descriptive flexfield segment.
80 * @param p_information14 Developer descriptive flexfield segment.
81 * @param p_information15 Developer descriptive flexfield segment.
82 * @param p_information16 Developer descriptive flexfield segment.
83 * @param p_information17 Developer descriptive flexfield segment.
84 * @param p_information18 Developer descriptive flexfield segment.
85 * @param p_information19 Developer descriptive flexfield segment.
86 * @param p_information20 Developer descriptive flexfield segment.
87 * @param p_information21 Developer descriptive flexfield segment.
88 * @param p_information22 Developer descriptive flexfield segment.
89 * @param p_information23 Developer descriptive flexfield segment.
90 * @param p_information24 Developer descriptive flexfield segment.
91 * @param p_information25 Developer descriptive flexfield segment.
92 * @param p_information26 Developer descriptive flexfield segment.
93 * @param p_information27 Developer descriptive flexfield segment.
94 * @param p_information28 Developer descriptive flexfield segment.
95 * @param p_information29 Developer descriptive flexfield segment.
96 * @param p_information30 Developer descriptive flexfield segment.
97 * @param p_attribute_category This context value determines which flexfield
98 * structure to use with the descriptive flexfield segments.
99 * @param p_attribute1 Descriptive flexfield segment.
100 * @param p_attribute2 Descriptive flexfield segment.
101 * @param p_attribute3 Descriptive flexfield segment.
102 * @param p_attribute4 Descriptive flexfield segment.
103 * @param p_attribute5 Descriptive flexfield segment.
104 * @param p_attribute6 Descriptive flexfield segment.
105 * @param p_attribute7 Descriptive flexfield segment.
106 * @param p_attribute8 Descriptive flexfield segment.
107 * @param p_attribute9 Descriptive flexfield segment.
108 * @param p_attribute10 Descriptive flexfield segment.
109 * @param p_attribute11 Descriptive flexfield segment.
110 * @param p_attribute12 Descriptive flexfield segment.
111 * @param p_attribute13 Descriptive flexfield segment.
112 * @param p_attribute14 Descriptive flexfield segment.
113 * @param p_attribute15 Descriptive flexfield segment.
114 * @param p_attribute16 Descriptive flexfield segment.
115 * @param p_attribute17 Descriptive flexfield segment.
116 * @param p_attribute18 Descriptive flexfield segment.
117 * @param p_attribute19 Descriptive flexfield segment.
118 * @param p_attribute20 Descriptive flexfield segment.
119 * @param p_attribute21 Descriptive flexfield segment.
120 * @param p_attribute22 Descriptive flexfield segment.
121 * @param p_attribute23 Descriptive flexfield segment.
122 * @param p_attribute24 Descriptive flexfield segment.
123 * @param p_attribute25 Descriptive flexfield segment.
124 * @param p_attribute26 Descriptive flexfield segment.
125 * @param p_attribute27 Descriptive flexfield segment.
126 * @param p_attribute28 Descriptive flexfield segment.
127 * @param p_attribute29 Descriptive flexfield segment.
128 * @param p_attribute30 Descriptive flexfield segment.
129 * @param p_reason_for_no_acco Reason for not assigning accommodation to the
130 * employee, for example, refusal or unavailable. Valid values are identified
131 * by the lookup type 'PQH_ACC_REASON_FOR_NO_ACCO'. Value can only be not null
132 * if accommodation_given parameter is set to false.
133 * @param p_indemnity_currency Currency in terms of which indemnity amount is
134 * provided. This references the FND_CURRENCIES table. Value can only be not
135 * null if accommodation_given parameter is set to false.
136 * @param p_assignment_acco_id The process returns the unique accommodation
137 * assignment identifier generated for the new record
138 * @param p_object_version_number If p_validate is false, the process returns
139 * the version number of the created accommodation assignment record. If
140 * p_validate is true, it returns null.
141 * @param p_effective_start_date If p_validate is false, the process returns
142 * the earliest effective start date for the accommodation assignment record
143 * created. If p_validate is true, it returns null
144 * @param p_effective_end_date If p_validate is false, the process returns the
145 * effective end date for the created accommodation assignment record. If
146 * p_validate is true, it returns null
147 * @rep:displayname Create Accommodation Assignment
148 * @rep:category BUSINESS_ENTITY PQH_EMPLOYEE_ACCOMMODATION
149 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
150 * @rep:scope public
151 * @rep:lifecycle active
152 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
153 */
154 --
155 -- {End Of Comments}
156 --
157 procedure create_assign_accommodation
158 (p_validate in boolean default false
159 ,p_effective_date in date
160 ,p_business_group_id in number
161 ,p_assignment_id in number
162 ,p_accommodation_given in varchar2
163 ,p_temporary_assignment in varchar2 default null
164 ,p_accommodation_id in number default null
165 ,p_acceptance_date in date default null
166 ,p_moving_date in date default null
167 ,p_refusal_date in date default null
168 ,p_comments in varchar2 default null
169 ,p_indemnity_entitlement in varchar2 default null
170 ,p_indemnity_amount in number default null
171 ,p_type_of_payment in varchar2 default null
172 ,p_information_category in varchar2 default null
173 ,p_information1 in varchar2 default null
174 ,p_information2 in varchar2 default null
175 ,p_information3 in varchar2 default null
176 ,p_information4 in varchar2 default null
177 ,p_information5 in varchar2 default null
178 ,p_information6 in varchar2 default null
179 ,p_information7 in varchar2 default null
180 ,p_information8 in varchar2 default null
181 ,p_information9 in varchar2 default null
182 ,p_information10 in varchar2 default null
183 ,p_information11 in varchar2 default null
184 ,p_information12 in varchar2 default null
185 ,p_information13 in varchar2 default null
186 ,p_information14 in varchar2 default null
187 ,p_information15 in varchar2 default null
188 ,p_information16 in varchar2 default null
189 ,p_information17 in varchar2 default null
190 ,p_information18 in varchar2 default null
191 ,p_information19 in varchar2 default null
192 ,p_information20 in varchar2 default null
193 ,p_information21 in varchar2 default null
194 ,p_information22 in varchar2 default null
195 ,p_information23 in varchar2 default null
196 ,p_information24 in varchar2 default null
197 ,p_information25 in varchar2 default null
198 ,p_information26 in varchar2 default null
199 ,p_information27 in varchar2 default null
200 ,p_information28 in varchar2 default null
201 ,p_information29 in varchar2 default null
202 ,p_information30 in varchar2 default null
203 ,p_attribute_category in varchar2 default null
204 ,p_attribute1 in varchar2 default null
205 ,p_attribute2 in varchar2 default null
206 ,p_attribute3 in varchar2 default null
207 ,p_attribute4 in varchar2 default null
208 ,p_attribute5 in varchar2 default null
209 ,p_attribute6 in varchar2 default null
210 ,p_attribute7 in varchar2 default null
211 ,p_attribute8 in varchar2 default null
212 ,p_attribute9 in varchar2 default null
213 ,p_attribute10 in varchar2 default null
214 ,p_attribute11 in varchar2 default null
215 ,p_attribute12 in varchar2 default null
216 ,p_attribute13 in varchar2 default null
217 ,p_attribute14 in varchar2 default null
218 ,p_attribute15 in varchar2 default null
219 ,p_attribute16 in varchar2 default null
220 ,p_attribute17 in varchar2 default null
221 ,p_attribute18 in varchar2 default null
222 ,p_attribute19 in varchar2 default null
223 ,p_attribute20 in varchar2 default null
224 ,p_attribute21 in varchar2 default null
225 ,p_attribute22 in varchar2 default null
226 ,p_attribute23 in varchar2 default null
227 ,p_attribute24 in varchar2 default null
228 ,p_attribute25 in varchar2 default null
229 ,p_attribute26 in varchar2 default null
230 ,p_attribute27 in varchar2 default null
231 ,p_attribute28 in varchar2 default null
232 ,p_attribute29 in varchar2 default null
233 ,p_attribute30 in varchar2 default null
234 ,p_reason_for_no_acco in varchar2 default null
235 ,p_indemnity_currency in varchar2 default null
236 ,p_assignment_acco_id out nocopy number
237 ,p_object_version_number out nocopy number
238 ,p_effective_start_date out nocopy date
239 ,p_effective_end_date out nocopy date
240 );
241 --
242 -- ----------------------------------------------------------------------------
243 -- |-----------------------< update_assign_accommodation >--------------------|
244 -- ----------------------------------------------------------------------------
245 --
246 -- {Start Of Comments}
247 /*#
248 * This API validates the record when an existing accommodation assignment is
249 * changed and updates the record in the database.
250 *
251 *
252 * <p><b>Licensing</b><br>
253 * This API is licensed for use with Human Resources.
254 *
255 * <p><b>Prerequisites</b><br>
259 * <p><b>Post Success</b><br>
256 * The accommodation assignment record must exist with the specified object
257 * version number.
258 *
260 * The existing accommodation assignment record is updated in the database.
261 *
262 * <p><b>Post Failure</b><br>
263 * The accommodation assignment is not updated in the database and an error is
264 * raised
265 * @param p_validate If true, then validation alone will be performed and the
266 * database will remain unchanged. If false and all validation checks pass,
267 * then the database will be modified.
268 * @param p_effective_date Determines when the Date Track operation comes into
269 * force
270 * @param p_datetrack_mode Indicates which Date Track mode to use when updating
271 * the record. It can either UPDATE, CORRECTION, UPDATE_OVERRIDE or
272 * UPDATE_CHANGE_INSERT.Modes available for use with a particular record depend
273 * on the dates of previous record changes and the effective date of this
274 * change
275 * @param p_assignment_acco_id Unique accommodation assignment identifier
276 * generated for this record when created as primary key
277 * @param p_object_version_number Passes the current version number of the
278 * assign accommodation to be updated. When the API completes if p_validate is
279 * false, the process returns the new version number of the updated assign
280 * accommodation. If p_validate is true, it returns the same value which was
281 * passed in
282 * @param p_business_group_id Identifies the business group for which the
283 * accommodation assignment is created
284 * @param p_assignment_id Identifies the assignment for which the accommodation
285 * assignment is created
286 * @param p_accommodation_given Flag denoting whether the employee is
287 * accommodated or not.
288 * @param p_temporary_assignment Flag denoting whether the accommodation is
289 * being temporarily or permanently assigned. Valid values are identified by
290 * lookup type 'PQH_ACCO_ASSIGN_TYPE'
291 * @param p_accommodation_id Identifies the accommodation which is being
292 * assigned. It references PQH_ACCOMMODATIONS_F table
293 * @param p_acceptance_date Date on which the employee accepted the
294 * accommodation assignment.
295 * @param p_moving_date Date on which the employee will move in to the
296 * accommodation.
297 * @param p_refusal_date Date on which employee refused the accommodation
298 * assignment.
299 * @param p_comments Comment text
300 * @param p_indemnity_entitlement Flag denoting whether the employee is
301 * eligible to be paid the indemnity for accommodation.
302 * @param p_indemnity_amount Indemnity amount to be paid to the employee, if
303 * not accommodated.
304 * @param p_type_of_payment Identifies the type of the payment. Value can only
305 * be not null if accommodation_given parameter is set to false.
309 * @param p_information2 Developer descriptive flexfield segment.
306 * @param p_information_category This context value determines which flexfield
307 * structure to use with the developer descriptive flexfield segments.
308 * @param p_information1 Developer descriptive flexfield segment.
310 * @param p_information3 Developer descriptive flexfield segment.
311 * @param p_information4 Developer descriptive flexfield segment.
312 * @param p_information5 Developer descriptive flexfield segment.
313 * @param p_information6 Developer descriptive flexfield segment.
314 * @param p_information7 Developer descriptive flexfield segment.
315 * @param p_information8 Developer descriptive flexfield segment.
316 * @param p_information9 Developer descriptive flexfield segment.
317 * @param p_information10 Developer descriptive flexfield segment.
318 * @param p_information11 Developer descriptive flexfield segment.
319 * @param p_information12 Developer descriptive flexfield segment.
320 * @param p_information13 Developer descriptive flexfield segment.
321 * @param p_information14 Developer descriptive flexfield segment.
322 * @param p_information15 Developer descriptive flexfield segment.
323 * @param p_information16 Developer descriptive flexfield segment.
324 * @param p_information17 Developer descriptive flexfield segment.
325 * @param p_information18 Developer descriptive flexfield segment.
326 * @param p_information19 Developer descriptive flexfield segment.
327 * @param p_information20 Developer descriptive flexfield segment.
328 * @param p_information21 Developer descriptive flexfield segment.
329 * @param p_information22 Developer descriptive flexfield segment.
330 * @param p_information23 Developer descriptive flexfield segment.
331 * @param p_information24 Developer descriptive flexfield segment.
332 * @param p_information25 Developer descriptive flexfield segment.
333 * @param p_information26 Developer descriptive flexfield segment.
334 * @param p_information27 Developer descriptive flexfield segment.
335 * @param p_information28 Developer descriptive flexfield segment.
336 * @param p_information29 Developer descriptive flexfield segment.
337 * @param p_information30 Developer descriptive flexfield segment.
338 * @param p_attribute_category This context value determines which flexfield
339 * structure to use with the descriptive flexfield segments.
340 * @param p_attribute1 Descriptive flexfield segment.
341 * @param p_attribute2 Descriptive flexfield segment.
342 * @param p_attribute3 Descriptive flexfield segment.
343 * @param p_attribute4 Descriptive flexfield segment.
344 * @param p_attribute5 Descriptive flexfield segment.
345 * @param p_attribute6 Descriptive flexfield segment.
346 * @param p_attribute7 Descriptive flexfield segment.
347 * @param p_attribute8 Descriptive flexfield segment.
348 * @param p_attribute9 Descriptive flexfield segment.
349 * @param p_attribute10 Descriptive flexfield segment.
350 * @param p_attribute11 Descriptive flexfield segment.
351 * @param p_attribute12 Descriptive flexfield segment.
352 * @param p_attribute13 Descriptive flexfield segment.
353 * @param p_attribute14 Descriptive flexfield segment.
354 * @param p_attribute15 Descriptive flexfield segment.
355 * @param p_attribute16 Descriptive flexfield segment.
359 * @param p_attribute20 Descriptive flexfield segment.
356 * @param p_attribute17 Descriptive flexfield segment.
357 * @param p_attribute18 Descriptive flexfield segment.
358 * @param p_attribute19 Descriptive flexfield segment.
360 * @param p_attribute21 Descriptive flexfield segment.
361 * @param p_attribute22 Descriptive flexfield segment.
362 * @param p_attribute23 Descriptive flexfield segment.
363 * @param p_attribute24 Descriptive flexfield segment.
364 * @param p_attribute25 Descriptive flexfield segment.
365 * @param p_attribute26 Descriptive flexfield segment.
366 * @param p_attribute27 Descriptive flexfield segment.
367 * @param p_attribute28 Descriptive flexfield segment.
368 * @param p_attribute29 Descriptive flexfield segment.
369 * @param p_attribute30 Descriptive flexfield segment.
370 * @param p_reason_for_no_acco Describes the reason for not assigning
371 * accommodation to the employee, for example, refusal or unavailable. Value
372 * can only be not null if accommodation_given parameter is set to false. Valid
373 * values are identified by the lookup type 'PQH_ACC_REASON_FOR_NO_ACCO'
374 * @param p_indemnity_currency Currency in terms of which indemnity amount is
375 * provided. Value can only be not null if accommodation_given parameter is set
376 * to false.
377 * @param p_effective_start_date If p_validate is false, the process returns
378 * the earliest effective start date for the accommodation assignment record
379 * updated. If p_validate is true, it returns null
380 * @param p_effective_end_date If p_validate is false, the process returns the
381 * effective end date for the updated accommodation assignment record. If
382 * p_validate is true, the process returns null
383 * @rep:displayname Update Accommodation Assignment
384 * @rep:category BUSINESS_ENTITY PQH_EMPLOYEE_ACCOMMODATION
385 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
386 * @rep:scope public
387 * @rep:lifecycle active
388 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
389 */
390 --
391 -- {End Of Comments}
392 --
393 procedure update_assign_accommodation
394 (p_validate in boolean default false
395 ,p_effective_date in date
396 ,p_datetrack_mode in varchar2
397 ,p_assignment_acco_id in number
398 ,p_object_version_number in out nocopy number
399 ,p_business_group_id in number default hr_api.g_number
400 ,p_assignment_id in number default hr_api.g_number
401 ,p_accommodation_given in varchar2 default hr_api.g_varchar2
402 ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
403 ,p_accommodation_id in number default hr_api.g_number
404 ,p_acceptance_date in date default hr_api.g_date
405 ,p_moving_date in date default hr_api.g_date
406 ,p_refusal_date in date default hr_api.g_date
407 ,p_comments in varchar2 default hr_api.g_varchar2
408 ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
409 ,p_indemnity_amount in number default hr_api.g_number
410 ,p_type_of_payment in varchar2 default hr_api.g_varchar2
411 ,p_information_category in varchar2 default hr_api.g_varchar2
412 ,p_information1 in varchar2 default hr_api.g_varchar2
413 ,p_information2 in varchar2 default hr_api.g_varchar2
414 ,p_information3 in varchar2 default hr_api.g_varchar2
415 ,p_information4 in varchar2 default hr_api.g_varchar2
416 ,p_information5 in varchar2 default hr_api.g_varchar2
417 ,p_information6 in varchar2 default hr_api.g_varchar2
418 ,p_information7 in varchar2 default hr_api.g_varchar2
419 ,p_information8 in varchar2 default hr_api.g_varchar2
420 ,p_information9 in varchar2 default hr_api.g_varchar2
421 ,p_information10 in varchar2 default hr_api.g_varchar2
422 ,p_information11 in varchar2 default hr_api.g_varchar2
423 ,p_information12 in varchar2 default hr_api.g_varchar2
424 ,p_information13 in varchar2 default hr_api.g_varchar2
425 ,p_information14 in varchar2 default hr_api.g_varchar2
426 ,p_information15 in varchar2 default hr_api.g_varchar2
427 ,p_information16 in varchar2 default hr_api.g_varchar2
428 ,p_information17 in varchar2 default hr_api.g_varchar2
429 ,p_information18 in varchar2 default hr_api.g_varchar2
430 ,p_information19 in varchar2 default hr_api.g_varchar2
431 ,p_information20 in varchar2 default hr_api.g_varchar2
432 ,p_information21 in varchar2 default hr_api.g_varchar2
433 ,p_information22 in varchar2 default hr_api.g_varchar2
434 ,p_information23 in varchar2 default hr_api.g_varchar2
435 ,p_information24 in varchar2 default hr_api.g_varchar2
436 ,p_information25 in varchar2 default hr_api.g_varchar2
437 ,p_information26 in varchar2 default hr_api.g_varchar2
438 ,p_information27 in varchar2 default hr_api.g_varchar2
439 ,p_information28 in varchar2 default hr_api.g_varchar2
440 ,p_information29 in varchar2 default hr_api.g_varchar2
441 ,p_information30 in varchar2 default hr_api.g_varchar2
442 ,p_attribute_category in varchar2 default hr_api.g_varchar2
443 ,p_attribute1 in varchar2 default hr_api.g_varchar2
447 ,p_attribute5 in varchar2 default hr_api.g_varchar2
444 ,p_attribute2 in varchar2 default hr_api.g_varchar2
445 ,p_attribute3 in varchar2 default hr_api.g_varchar2
446 ,p_attribute4 in varchar2 default hr_api.g_varchar2
448 ,p_attribute6 in varchar2 default hr_api.g_varchar2
449 ,p_attribute7 in varchar2 default hr_api.g_varchar2
450 ,p_attribute8 in varchar2 default hr_api.g_varchar2
451 ,p_attribute9 in varchar2 default hr_api.g_varchar2
452 ,p_attribute10 in varchar2 default hr_api.g_varchar2
453 ,p_attribute11 in varchar2 default hr_api.g_varchar2
454 ,p_attribute12 in varchar2 default hr_api.g_varchar2
455 ,p_attribute13 in varchar2 default hr_api.g_varchar2
456 ,p_attribute14 in varchar2 default hr_api.g_varchar2
457 ,p_attribute15 in varchar2 default hr_api.g_varchar2
458 ,p_attribute16 in varchar2 default hr_api.g_varchar2
459 ,p_attribute17 in varchar2 default hr_api.g_varchar2
460 ,p_attribute18 in varchar2 default hr_api.g_varchar2
461 ,p_attribute19 in varchar2 default hr_api.g_varchar2
462 ,p_attribute20 in varchar2 default hr_api.g_varchar2
463 ,p_attribute21 in varchar2 default hr_api.g_varchar2
464 ,p_attribute22 in varchar2 default hr_api.g_varchar2
465 ,p_attribute23 in varchar2 default hr_api.g_varchar2
466 ,p_attribute24 in varchar2 default hr_api.g_varchar2
467 ,p_attribute25 in varchar2 default hr_api.g_varchar2
468 ,p_attribute26 in varchar2 default hr_api.g_varchar2
469 ,p_attribute27 in varchar2 default hr_api.g_varchar2
470 ,p_attribute28 in varchar2 default hr_api.g_varchar2
471 ,p_attribute29 in varchar2 default hr_api.g_varchar2
472 ,p_attribute30 in varchar2 default hr_api.g_varchar2
473 ,p_reason_for_no_acco in varchar2 default hr_api.g_varchar2
474 ,p_indemnity_currency in varchar2 default hr_api.g_varchar2
475 ,p_effective_start_date out nocopy date
476 ,p_effective_end_date out nocopy date
477 );
478 --
479 -- ----------------------------------------------------------------------------
480 -- |-----------------------< delete_assign_accommodation >--------------------|
481 -- ----------------------------------------------------------------------------
482 --
483 -- {Start Of Comments}
484 /*#
485 * This API deletes an accommodation assignment.
486 *
487 * Deleting the accommodation assignment makes the accommodation vacant and new
488 * assignment can be created for a different employee.
489 *
490 * <p><b>Licensing</b><br>
491 * This API is licensed for use with Human Resources.
492 *
493 * <p><b>Prerequisites</b><br>
494 * The accommodation assignment must exist with the specified object version
495 * number.
496 *
497 * <p><b>Post Success</b><br>
498 * This accommodation assignment record is deleted from the database.
499 *
500 * <p><b>Post Failure</b><br>
501 * The accommodation assignment record is not deleted from the database and an
502 * error is raised
503 * @param p_validate If true, then validation alone will be performed and the
504 * database will remain unchanged. If false and all validation checks pass,
505 * then the database will be modified.
506 * @param p_effective_date Determines when the Date Track operation comes into
507 * force
508 * @param p_datetrack_mode Indicates which Date Track mode to use when deleting
509 * the record. It can be either ZAP, DELETE, FUTURE_CHANGE or
510 * DELETE_NEXT_CHANGE. Modes available for use with a particular record depend
511 * on the dates of previous record changes and the effective date of this
512 * change
513 * @param p_assignment_acco_id Unique assign accommodation identifier generated
514 * for this record while created as Primary Key
515 * @param p_object_version_number Current version number of the accommodation
516 * record to be deleted
517 * @param p_effective_start_date If p_validate is false, the process returns
518 * the earliest effective start date for the accommodation assignment record
519 * created. If p_validate is true, it returns null
520 * @param p_effective_end_date If p_validate is false, the process returns the
521 * effective end date for the created accommodation assignment record. If
522 * p_validate is true, it returns null
523 * @rep:displayname Delete Accommodation Assignment
524 * @rep:category BUSINESS_ENTITY PQH_EMPLOYEE_ACCOMMODATION
525 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
526 * @rep:scope public
527 * @rep:lifecycle active
528 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
529 */
530 --
531 -- {End Of Comments}
532 --
533 procedure delete_assign_accommodation
534 (p_validate in boolean default false
535 ,p_effective_date in date
536 ,p_datetrack_mode in varchar2
537 ,p_assignment_acco_id in number
538 ,p_object_version_number in out nocopy number
539 ,p_effective_start_date out nocopy date
540 ,p_effective_end_date out nocopy date
541 );
542
543 --
544 end pqh_assign_accommodations_api;
[Home] [Help]