1 Package pqh_accommodations_api as
2 /* $Header: pqaccapi.pkh 120.1 2005/10/02 02:25:22 aroussel $ */
3 /*#
4 * This package contains APIs to create, update and delete accommodations.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Accommodation for France
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |---------------------------< create_accommodation >-----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API validates and creates an accommodation.
17 *
18 * This API allows to setup an employer's accommodation. Details recorded
19 * include whether the accommodation is suitable for disabled, owning
20 * department, rental value, number of persons accommodated etc.
21 *
22 * <p><b>Licensing</b><br>
23 * This API is licensed for use with Human Resources.
24 *
25 * <p><b>Prerequisites</b><br>
26 * An accommodation can be created for an existing business group only.
27 *
28 * <p><b>Post Success</b><br>
29 * A new accommodation is created for the specified business group.
30 *
31 * <p><b>Post Failure</b><br>
32 * An accommodation is not created in the database and an error is raised
33 * @param p_validate If true, then validation alone will be performed and the
34 * database will remain unchanged. If false and all validation checks pass,
35 * then the database will be modified.
36 * @param p_effective_date Determines when the Date Track operation comes into
37 * force
38 * @param p_accommodation_name Identifies the unique accommodation name
39 * @param p_business_group_id Identifies the business group for which the
40 * accommodation is created.
41 * @param p_location_id Identifies the HR location for the accommodation.
42 * Foreign Key to HR_ALL_LOCATIONS table.
43 * @param p_accommodation_desc Any general description of the accommodation
44 * @param p_accommodation_type Identifies the type of accommodation, for
45 * example, independent house, company flat. Valid values are identified by
46 * lookup type 'PQH_ACC_TYPE'
47 * @param p_style Identifies the address style selected for providing address
48 * information of the accommodation
49 * @param p_address_line_1 {@rep:casecolumn
50 * PQH_ACCOMMODATIONS_F.ADDRESS_LINE_1}
51 * @param p_address_line_2 {@rep:casecolumn
52 * PQH_ACCOMMODATIONS_F.ADDRESS_LINE_2}
53 * @param p_address_line_3 {@rep:casecolumn
54 * PQH_ACCOMMODATIONS_F.ADDRESS_LINE_3}
55 * @param p_town_or_city Identifies the name of the city or town given as a
56 * part of the address of the accommodation
57 * @param p_country Identifies the name of the country given as part of the
58 * address of the accommodation
59 * @param p_postal_code Identifies the postal code given as part of the address
60 * of the accommodation
61 * @param p_region_1 {@rep:casecolumn PQH_ACCOMMODATIONS_F.REGION_1}
62 * @param p_region_2 {@rep:casecolumn PQH_ACCOMMODATIONS_F.REGION_2}
63 * @param p_region_3 {@rep:casecolumn PQH_ACCOMMODATIONS_F.REGION_3}
64 * @param p_telephone_number_1 {@rep:casecolumn
65 * PQH_ACCOMMODATIONS_F.TELEPHONE_NUMBER_1}
66 * @param p_telephone_number_2 {@rep:casecolumn
67 * PQH_ACCOMMODATIONS_F.TELEPHONE_NUMBER_2}
68 * @param p_telephone_number_3 {@rep:casecolumn
69 * PQH_ACCOMMODATIONS_F.TELEPHONE_NUMBER_3}
70 * @param p_floor_number Identifies the floor number of the accommodation
71 * @param p_floor_area Identifies the floor area of the accommodation given in
72 * terms of units mentioned in floor area unit parameter
73 * @param p_floor_area_measure_unit Identifies a unit of area measurement in
74 * terms of which floor area is provided. Valid values are identified by lookup
75 * type 'PQH_ACC_AREA_TYPE'
76 * @param p_main_rooms Identifies the number of main rooms in the accommodation
77 * @param p_family_size Identifies the family size that can be accommodated in
78 * the accommodation
79 * @param p_suitability_disabled A flag that denotes whether the accommodation
80 * is suitable for a disabled person or not
81 * @param p_rental_value Rental value of the accommodation in terms of currency
82 * given in currency parameter
83 * @param p_rental_value_currency Currency in terms of which rental value is
84 * provided. This is a foreign key to FND_CURRENCIES.
85 * @param p_owner Name of the organization, legal entity etc that owns the
86 * accommodation. This is a foreign key to HR_ALL_ORGANIZATION_UNITS table.
87 * @param p_comments Comment text
88 * @param p_information_category This context value determines which flexfield
89 * structure to use with the developer descriptive flexfield segments.
90 * @param p_information1 Developer descriptive flexfield segment.
91 * @param p_information2 Developer descriptive flexfield segment.
92 * @param p_information3 Developer descriptive flexfield segment.
93 * @param p_information4 Developer descriptive flexfield segment.
94 * @param p_information5 Developer descriptive flexfield segment.
95 * @param p_information6 Developer descriptive flexfield segment.
96 * @param p_information7 Developer descriptive flexfield segment.
97 * @param p_information8 Developer descriptive flexfield segment.
98 * @param p_information9 Developer descriptive flexfield segment.
99 * @param p_information10 Developer descriptive flexfield segment.
100 * @param p_information11 Developer descriptive flexfield segment.
101 * @param p_information12 Developer descriptive flexfield segment.
102 * @param p_information13 Developer descriptive flexfield segment.
103 * @param p_information14 Developer descriptive flexfield segment.
104 * @param p_information15 Developer descriptive flexfield segment.
105 * @param p_information16 Developer descriptive flexfield segment.
106 * @param p_information17 Developer descriptive flexfield segment.
107 * @param p_information18 Developer descriptive flexfield segment.
108 * @param p_information19 Developer descriptive flexfield segment.
109 * @param p_information20 Developer descriptive flexfield segment.
110 * @param p_information21 Developer descriptive flexfield segment.
111 * @param p_information22 Developer descriptive flexfield segment.
112 * @param p_information23 Developer descriptive flexfield segment.
113 * @param p_information24 Developer descriptive flexfield segment.
114 * @param p_information25 Developer descriptive flexfield segment.
115 * @param p_information26 Developer descriptive flexfield segment.
116 * @param p_information27 Developer descriptive flexfield segment.
117 * @param p_information28 Developer descriptive flexfield segment.
118 * @param p_information29 Developer descriptive flexfield segment.
119 * @param p_information30 Developer descriptive flexfield segment.
120 * @param p_attribute_category This context value determines which flexfield
121 * structure to use with the descriptive flexfield segments.
122 * @param p_attribute1 Descriptive flexfield segment.
123 * @param p_attribute2 Descriptive flexfield segment.
124 * @param p_attribute3 Descriptive flexfield segment.
125 * @param p_attribute4 Descriptive flexfield segment.
126 * @param p_attribute5 Descriptive flexfield segment.
127 * @param p_attribute6 Descriptive flexfield segment.
128 * @param p_attribute7 Descriptive flexfield segment.
129 * @param p_attribute8 Descriptive flexfield segment.
130 * @param p_attribute9 Descriptive flexfield segment.
131 * @param p_attribute10 Descriptive flexfield segment.
132 * @param p_attribute11 Descriptive flexfield segment.
133 * @param p_attribute12 Descriptive flexfield segment.
134 * @param p_attribute13 Descriptive flexfield segment.
135 * @param p_attribute14 Descriptive flexfield segment.
136 * @param p_attribute15 Descriptive flexfield segment.
137 * @param p_attribute16 Descriptive flexfield segment.
138 * @param p_attribute17 Descriptive flexfield segment.
139 * @param p_attribute18 Descriptive flexfield segment.
140 * @param p_attribute19 Descriptive flexfield segment.
141 * @param p_attribute20 Descriptive flexfield segment.
142 * @param p_attribute21 Descriptive flexfield segment.
143 * @param p_attribute22 Descriptive flexfield segment.
144 * @param p_attribute23 Descriptive flexfield segment.
145 * @param p_attribute24 Descriptive flexfield segment.
146 * @param p_attribute25 Descriptive flexfield segment.
147 * @param p_attribute26 Descriptive flexfield segment.
148 * @param p_attribute27 Descriptive flexfield segment.
149 * @param p_attribute28 Descriptive flexfield segment.
150 * @param p_attribute29 Descriptive flexfield segment.
151 * @param p_attribute30 Descriptive flexfield segment.
152 * @param p_accommodation_id The process returns the unique accommodation
153 * identifier generated for the new accommodation record.
154 * @param p_object_version_number If p_validate is false, the process returns
155 * the version number of the created accommodation record. If p_validate is
156 * true, it returns null.
157 * @param p_effective_start_date If p_validate is false, the process returns
158 * the earliest effective start date for the created accommodation record. If
159 * p_validate is true, it returns null.
160 * @param p_effective_end_date If p_validate is false, the process returns
161 * effective end date for the created accommodation record. If p_validate is
162 * true, it returns null.
163 * @rep:displayname Create Accommodation
164 * @rep:category BUSINESS_ENTITY PQH_EMPLOYER_ACCOMMODATION
165 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
166 * @rep:scope public
167 * @rep:lifecycle active
168 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
169 */
170 --
171 -- {End Of Comments}
172 --
173 procedure create_accommodation
174 (p_validate in boolean default false
175 ,p_effective_date in date
176 ,p_accommodation_name in varchar2
177 ,p_business_group_id in number
178 ,p_location_id in number
179 ,p_accommodation_desc in varchar2 default null
180 ,p_accommodation_type in varchar2 default null
181 ,p_style in varchar2 default null
182 ,p_address_line_1 in varchar2 default null
183 ,p_address_line_2 in varchar2 default null
184 ,p_address_line_3 in varchar2 default null
185 ,p_town_or_city in varchar2 default null
186 ,p_country in varchar2 default null
187 ,p_postal_code in varchar2 default null
188 ,p_region_1 in varchar2 default null
189 ,p_region_2 in varchar2 default null
190 ,p_region_3 in varchar2 default null
191 ,p_telephone_number_1 in varchar2 default null
192 ,p_telephone_number_2 in varchar2 default null
193 ,p_telephone_number_3 in varchar2 default null
194 ,p_floor_number in varchar2 default null
195 ,p_floor_area in number default null
196 ,p_floor_area_measure_unit in varchar2 default null
197 ,p_main_rooms in number default null
198 ,p_family_size in number default null
199 ,p_suitability_disabled in varchar2 default null
200 ,p_rental_value in number default null
201 ,p_rental_value_currency in varchar2 default null
202 ,p_owner in varchar2 default null
203 ,p_comments in varchar2 default null
204 ,p_information_category in varchar2 default null
205 ,p_information1 in varchar2 default null
206 ,p_information2 in varchar2 default null
207 ,p_information3 in varchar2 default null
208 ,p_information4 in varchar2 default null
209 ,p_information5 in varchar2 default null
210 ,p_information6 in varchar2 default null
211 ,p_information7 in varchar2 default null
212 ,p_information8 in varchar2 default null
213 ,p_information9 in varchar2 default null
214 ,p_information10 in varchar2 default null
215 ,p_information11 in varchar2 default null
216 ,p_information12 in varchar2 default null
217 ,p_information13 in varchar2 default null
218 ,p_information14 in varchar2 default null
219 ,p_information15 in varchar2 default null
220 ,p_information16 in varchar2 default null
221 ,p_information17 in varchar2 default null
222 ,p_information18 in varchar2 default null
223 ,p_information19 in varchar2 default null
224 ,p_information20 in varchar2 default null
225 ,p_information21 in varchar2 default null
226 ,p_information22 in varchar2 default null
227 ,p_information23 in varchar2 default null
228 ,p_information24 in varchar2 default null
229 ,p_information25 in varchar2 default null
230 ,p_information26 in varchar2 default null
231 ,p_information27 in varchar2 default null
232 ,p_information28 in varchar2 default null
233 ,p_information29 in varchar2 default null
234 ,p_information30 in varchar2 default null
235 ,p_attribute_category in varchar2 default null
236 ,p_attribute1 in varchar2 default null
237 ,p_attribute2 in varchar2 default null
238 ,p_attribute3 in varchar2 default null
239 ,p_attribute4 in varchar2 default null
240 ,p_attribute5 in varchar2 default null
241 ,p_attribute6 in varchar2 default null
242 ,p_attribute7 in varchar2 default null
243 ,p_attribute8 in varchar2 default null
244 ,p_attribute9 in varchar2 default null
245 ,p_attribute10 in varchar2 default null
246 ,p_attribute11 in varchar2 default null
247 ,p_attribute12 in varchar2 default null
248 ,p_attribute13 in varchar2 default null
249 ,p_attribute14 in varchar2 default null
250 ,p_attribute15 in varchar2 default null
251 ,p_attribute16 in varchar2 default null
252 ,p_attribute17 in varchar2 default null
253 ,p_attribute18 in varchar2 default null
254 ,p_attribute19 in varchar2 default null
255 ,p_attribute20 in varchar2 default null
256 ,p_attribute21 in varchar2 default null
257 ,p_attribute22 in varchar2 default null
258 ,p_attribute23 in varchar2 default null
259 ,p_attribute24 in varchar2 default null
260 ,p_attribute25 in varchar2 default null
261 ,p_attribute26 in varchar2 default null
262 ,p_attribute27 in varchar2 default null
263 ,p_attribute28 in varchar2 default null
264 ,p_attribute29 in varchar2 default null
265 ,p_attribute30 in varchar2 default null
266 ,p_accommodation_id OUT NOCOPY number
267 ,p_object_version_number OUT NOCOPY number
268 ,p_effective_start_date OUT NOCOPY date
269 ,p_effective_end_date OUT NOCOPY date
270 );
271 --
272 -- ----------------------------------------------------------------------------
273 -- |---------------------------< update_accommodation >-----------------------|
274 -- ----------------------------------------------------------------------------
275 --
276 -- {Start Of Comments}
277 /*#
278 * This API updates the employer's accommodation details.
279 *
280 * Details that can be updated by this API include rental value, number of
281 * rooms, family size, size of the accommodation etc.
282 *
283 * <p><b>Licensing</b><br>
284 * This API is licensed for use with Human Resources.
285 *
286 * <p><b>Prerequisites</b><br>
287 * This accommodation record must exist with the specified object version
288 * number.
289 *
290 * <p><b>Post Success</b><br>
291 * The existing accommodation record is updated in the database.
292 *
293 * <p><b>Post Failure</b><br>
294 * The existing accommodation record is not changed in the database and an
295 * error is raised
299 * @param p_effective_date Determines when the Date Track operation comes into
296 * @param p_validate If true, then validation alone will be performed and the
297 * database will remain unchanged. If false and all validation checks pass,
298 * then the database will be modified.
300 * force
301 * @param p_datetrack_mode Indicates which Date Track mode to use when updating
302 * the record. It can be either UPDATE, CORRECTION, UPDATE_OVERRIDE or
303 * UPDATE_CHANGE_INSERT. Modes available for use with a particular record
304 * depend on the dates of previous record changes and the effective date of
305 * this change
306 * @param p_accommodation_id Unique accommodation identifier assigned to the
307 * accommodation record while creation as a primary key
308 * @param p_object_version_number Passes the current version number of the
309 * accommodation record to be updated. When the API completes if p_validate is
310 * false, the process returns the new version number of the updated
311 * accommodation record. If p_validate is true, it returns the same value which
312 * was passed in
313 * @param p_accommodation_name Identifies the unique accommodation name
314 * @param p_business_group_id Identifies the business group for which the
315 * accommodation is created.
316 * @param p_location_id Identifies the HR location for the accommodation.
317 * Foreign key to HR_ALL_LOCATIONS table.
318 * @param p_accommodation_desc General description of the accommodation
319 * @param p_accommodation_type Identifies the type of accommodation, for
320 * example, independent house, company flat. Valid values are identified by
321 * lookup type 'PQH_ACC_TYPE'
322 * @param p_style Identifies the address style selected for providing address
323 * information of the accommodation
324 * @param p_address_line_1 {@rep:casecolumn
325 * PQH_ACCOMMODATIONS_F.ADDRESS_LINE_1}
326 * @param p_address_line_2 {@rep:casecolumn
327 * PQH_ACCOMMODATIONS_F.ADDRESS_LINE_2}
328 * @param p_address_line_3 {@rep:casecolumn
329 * PQH_ACCOMMODATIONS_F.ADDRESS_LINE_3}
330 * @param p_town_or_city Identifies the name of the city or town given as a
331 * part of the address of the accommodation
335 * of the accommodation
332 * @param p_country Identifies the name of the country given as part of the
333 * address of the accommodation
334 * @param p_postal_code Identifies the postal code given as part of the address
336 * @param p_region_1 {@rep:casecolumn PQH_ACCOMMODATIONS_F.REGION_1}
337 * @param p_region_2 {@rep:casecolumn PQH_ACCOMMODATIONS_F.REGION_2}
338 * @param p_region_3 {@rep:casecolumn PQH_ACCOMMODATIONS_F.REGION_3}
339 * @param p_telephone_number_1 {@rep:casecolumn
340 * PQH_ACCOMMODATIONS_F.TELEPHONE_NUMBER_1}
341 * @param p_telephone_number_2 {@rep:casecolumn
342 * PQH_ACCOMMODATIONS_F.TELEPHONE_NUMBER_2}
343 * @param p_telephone_number_3 {@rep:casecolumn
344 * PQH_ACCOMMODATIONS_F.TELEPHONE_NUMBER_3}
345 * @param p_floor_number Identifies the floor number of the accommodation
346 * @param p_floor_area Identifies the floor area of the accommodation given in
347 * terms of units mentioned in floor area unit parameter
348 * @param p_floor_area_measure_unit Identifies a unit of area measurement in
349 * terms of which floor area is provided. Valid values are identified by lookup
350 * type 'PQH_ACC_AREA_TYPE'
351 * @param p_main_rooms Identifies the number of main rooms in the accommodation
352 * @param p_family_size Identifies the family size that can be accommodated in
353 * the accommodation
354 * @param p_suitability_disabled A flag that denotes whether the accommodation
355 * is suitable for a disabled person or not
356 * @param p_rental_value Rental value of the accommodation in terms of currency
357 * given in currency parameter
358 * @param p_rental_value_currency Currency in terms of which rental value is
359 * provided. This is a foreign key to FND_CURRENCIES.
360 * @param p_owner Name of the organization, legal entity etc. that owns the
361 * accommodation. This is a foreign key to HR_ALL_ORGANIZATION_UNITS table.
362 * @param p_comments Comment text
363 * @param p_information_category This context value determines which flexfield
364 * structure to use with the developer descriptive flexfield segments.
365 * @param p_information1 Developer descriptive flexfield segment.
366 * @param p_information2 Developer descriptive flexfield segment.
367 * @param p_information3 Developer descriptive flexfield segment.
368 * @param p_information4 Developer descriptive flexfield segment.
369 * @param p_information5 Developer descriptive flexfield segment.
370 * @param p_information6 Developer descriptive flexfield segment.
371 * @param p_information7 Developer descriptive flexfield segment.
372 * @param p_information8 Developer descriptive flexfield segment.
373 * @param p_information9 Developer descriptive flexfield segment.
374 * @param p_information10 Developer descriptive flexfield segment.
375 * @param p_information11 Developer descriptive flexfield segment.
376 * @param p_information12 Developer descriptive flexfield segment.
377 * @param p_information13 Developer descriptive flexfield segment.
378 * @param p_information14 Developer descriptive flexfield segment.
379 * @param p_information15 Developer descriptive flexfield segment.
380 * @param p_information16 Developer descriptive flexfield segment.
381 * @param p_information17 Developer descriptive flexfield segment.
382 * @param p_information18 Developer descriptive flexfield segment.
383 * @param p_information19 Developer descriptive flexfield segment.
384 * @param p_information20 Developer descriptive flexfield segment.
385 * @param p_information21 Developer descriptive flexfield segment.
386 * @param p_information22 Developer descriptive flexfield segment.
387 * @param p_information23 Developer descriptive flexfield segment.
388 * @param p_information24 Developer descriptive flexfield segment.
389 * @param p_information25 Developer descriptive flexfield segment.
390 * @param p_information26 Developer descriptive flexfield segment.
391 * @param p_information27 Developer descriptive flexfield segment.
392 * @param p_information28 Developer descriptive flexfield segment.
393 * @param p_information29 Developer descriptive flexfield segment.
394 * @param p_information30 Developer descriptive flexfield segment.
395 * @param p_attribute_category This context value determines which flexfield
396 * structure to use with the descriptive flexfield segments.
397 * @param p_attribute1 Descriptive flexfield segment.
398 * @param p_attribute2 Descriptive flexfield segment.
399 * @param p_attribute3 Descriptive flexfield segment.
400 * @param p_attribute4 Descriptive flexfield segment.
401 * @param p_attribute5 Descriptive flexfield segment.
402 * @param p_attribute6 Descriptive flexfield segment.
403 * @param p_attribute7 Descriptive flexfield segment.
404 * @param p_attribute8 Descriptive flexfield segment.
405 * @param p_attribute9 Descriptive flexfield segment.
406 * @param p_attribute10 Descriptive flexfield segment.
407 * @param p_attribute11 Descriptive flexfield segment.
408 * @param p_attribute12 Descriptive flexfield segment.
409 * @param p_attribute13 Descriptive flexfield segment.
410 * @param p_attribute14 Descriptive flexfield segment.
411 * @param p_attribute15 Descriptive flexfield segment.
412 * @param p_attribute16 Descriptive flexfield segment.
413 * @param p_attribute17 Descriptive flexfield segment.
414 * @param p_attribute18 Descriptive flexfield segment.
415 * @param p_attribute19 Descriptive flexfield segment.
416 * @param p_attribute20 Descriptive flexfield segment.
417 * @param p_attribute21 Descriptive flexfield segment.
418 * @param p_attribute22 Descriptive flexfield segment.
419 * @param p_attribute23 Descriptive flexfield segment.
420 * @param p_attribute24 Descriptive flexfield segment.
421 * @param p_attribute25 Descriptive flexfield segment.
422 * @param p_attribute26 Descriptive flexfield segment.
423 * @param p_attribute27 Descriptive flexfield segment.
424 * @param p_attribute28 Descriptive flexfield segment.
425 * @param p_attribute29 Descriptive flexfield segment.
426 * @param p_attribute30 Descriptive flexfield segment.
430 * @param p_effective_end_date If p_validate is false, the process returns the
427 * @param p_effective_start_date If p_validate is false, the process returns
428 * the effective start date on the updated accommodation row which now exists
429 * as of the effective date. If p_validate is true, it returns null
431 * effective end date on the updated accommodation row which now exists as of
432 * the effective date. If p_validate is true, it returns null
433 * @rep:displayname Update Accommodation
434 * @rep:category BUSINESS_ENTITY PQH_EMPLOYER_ACCOMMODATION
435 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
436 * @rep:scope public
437 * @rep:lifecycle active
438 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
439 */
440 --
441 -- {End Of Comments}
442 --
443 procedure update_accommodation
444 (p_validate in boolean default false
445 ,p_effective_date in date
446 ,p_datetrack_mode in varchar2
447 ,p_accommodation_id in number
448 ,p_object_version_number in OUT NOCOPY number
449 ,p_accommodation_name in varchar2 default hr_api.g_varchar2
450 ,p_business_group_id in number default hr_api.g_number
451 ,p_location_id in number default hr_api.g_number
452 ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
453 ,p_accommodation_type in varchar2 default hr_api.g_varchar2
454 ,p_style in varchar2 default hr_api.g_varchar2
455 ,p_address_line_1 in varchar2 default hr_api.g_varchar2
456 ,p_address_line_2 in varchar2 default hr_api.g_varchar2
457 ,p_address_line_3 in varchar2 default hr_api.g_varchar2
458 ,p_town_or_city in varchar2 default hr_api.g_varchar2
459 ,p_country in varchar2 default hr_api.g_varchar2
460 ,p_postal_code in varchar2 default hr_api.g_varchar2
461 ,p_region_1 in varchar2 default hr_api.g_varchar2
462 ,p_region_2 in varchar2 default hr_api.g_varchar2
463 ,p_region_3 in varchar2 default hr_api.g_varchar2
464 ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
465 ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
466 ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
467 ,p_floor_number in varchar2 default hr_api.g_varchar2
468 ,p_floor_area in number default hr_api.g_number
469 ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
470 ,p_main_rooms in number default hr_api.g_number
471 ,p_family_size in number default hr_api.g_number
472 ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
473 ,p_rental_value in number default hr_api.g_number
474 ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
475 ,p_owner in varchar2 default hr_api.g_varchar2
476 ,p_comments in varchar2 default hr_api.g_varchar2
477 ,p_information_category in varchar2 default hr_api.g_varchar2
478 ,p_information1 in varchar2 default hr_api.g_varchar2
479 ,p_information2 in varchar2 default hr_api.g_varchar2
480 ,p_information3 in varchar2 default hr_api.g_varchar2
481 ,p_information4 in varchar2 default hr_api.g_varchar2
482 ,p_information5 in varchar2 default hr_api.g_varchar2
483 ,p_information6 in varchar2 default hr_api.g_varchar2
484 ,p_information7 in varchar2 default hr_api.g_varchar2
485 ,p_information8 in varchar2 default hr_api.g_varchar2
486 ,p_information9 in varchar2 default hr_api.g_varchar2
487 ,p_information10 in varchar2 default hr_api.g_varchar2
488 ,p_information11 in varchar2 default hr_api.g_varchar2
489 ,p_information12 in varchar2 default hr_api.g_varchar2
490 ,p_information13 in varchar2 default hr_api.g_varchar2
491 ,p_information14 in varchar2 default hr_api.g_varchar2
492 ,p_information15 in varchar2 default hr_api.g_varchar2
493 ,p_information16 in varchar2 default hr_api.g_varchar2
494 ,p_information17 in varchar2 default hr_api.g_varchar2
495 ,p_information18 in varchar2 default hr_api.g_varchar2
496 ,p_information19 in varchar2 default hr_api.g_varchar2
497 ,p_information20 in varchar2 default hr_api.g_varchar2
498 ,p_information21 in varchar2 default hr_api.g_varchar2
499 ,p_information22 in varchar2 default hr_api.g_varchar2
500 ,p_information23 in varchar2 default hr_api.g_varchar2
501 ,p_information24 in varchar2 default hr_api.g_varchar2
502 ,p_information25 in varchar2 default hr_api.g_varchar2
503 ,p_information26 in varchar2 default hr_api.g_varchar2
504 ,p_information27 in varchar2 default hr_api.g_varchar2
505 ,p_information28 in varchar2 default hr_api.g_varchar2
506 ,p_information29 in varchar2 default hr_api.g_varchar2
507 ,p_information30 in varchar2 default hr_api.g_varchar2
508 ,p_attribute_category in varchar2 default hr_api.g_varchar2
509 ,p_attribute1 in varchar2 default hr_api.g_varchar2
510 ,p_attribute2 in varchar2 default hr_api.g_varchar2
511 ,p_attribute3 in varchar2 default hr_api.g_varchar2
512 ,p_attribute4 in varchar2 default hr_api.g_varchar2
516 ,p_attribute8 in varchar2 default hr_api.g_varchar2
513 ,p_attribute5 in varchar2 default hr_api.g_varchar2
514 ,p_attribute6 in varchar2 default hr_api.g_varchar2
515 ,p_attribute7 in varchar2 default hr_api.g_varchar2
517 ,p_attribute9 in varchar2 default hr_api.g_varchar2
518 ,p_attribute10 in varchar2 default hr_api.g_varchar2
519 ,p_attribute11 in varchar2 default hr_api.g_varchar2
520 ,p_attribute12 in varchar2 default hr_api.g_varchar2
521 ,p_attribute13 in varchar2 default hr_api.g_varchar2
522 ,p_attribute14 in varchar2 default hr_api.g_varchar2
523 ,p_attribute15 in varchar2 default hr_api.g_varchar2
524 ,p_attribute16 in varchar2 default hr_api.g_varchar2
525 ,p_attribute17 in varchar2 default hr_api.g_varchar2
526 ,p_attribute18 in varchar2 default hr_api.g_varchar2
527 ,p_attribute19 in varchar2 default hr_api.g_varchar2
528 ,p_attribute20 in varchar2 default hr_api.g_varchar2
529 ,p_attribute21 in varchar2 default hr_api.g_varchar2
530 ,p_attribute22 in varchar2 default hr_api.g_varchar2
531 ,p_attribute23 in varchar2 default hr_api.g_varchar2
532 ,p_attribute24 in varchar2 default hr_api.g_varchar2
533 ,p_attribute25 in varchar2 default hr_api.g_varchar2
534 ,p_attribute26 in varchar2 default hr_api.g_varchar2
535 ,p_attribute27 in varchar2 default hr_api.g_varchar2
536 ,p_attribute28 in varchar2 default hr_api.g_varchar2
537 ,p_attribute29 in varchar2 default hr_api.g_varchar2
538 ,p_attribute30 in varchar2 default hr_api.g_varchar2
539 ,p_effective_start_date OUT NOCOPY date
540 ,p_effective_end_date OUT NOCOPY date
541 );
542 --
543 -- ----------------------------------------------------------------------------
544 -- |---------------------------< delete_accommodation >-----------------------|
545 -- ----------------------------------------------------------------------------
546 --
547 -- {Start Of Comments}
548 /*#
549 * This API deletes an accommodation record from the database.
550 *
551 *
552 * <p><b>Licensing</b><br>
553 * This API is licensed for use with Human Resources.
554 *
555 * <p><b>Prerequisites</b><br>
556 * A record should exist with the specified object version number. Also
557 * references for this accommodation must exist in the system.
558 *
559 * <p><b>Post Success</b><br>
560 * The accommodation record is deleted from the database.
561 *
562 * <p><b>Post Failure</b><br>
563 * The accommodation record is not deleted from the database and an error is
564 * raised
565 * @param p_validate If true, then validation alone will be performed and the
566 * database will remain unchanged. If false and all validation checks pass,
567 * then the database will be modified.
568 * @param p_effective_date Determines when the Date Track operation comes into
569 * force
570 * @param p_datetrack_mode Indicates which Date Track mode to use when deleting
571 * the record. It can either ZAP, DELETE, FUTURE_CHANGE or DELETE_NEXT_CHANGE.
572 * Modes available for use with a particular record depend on the dates of
573 * previous record changes and the effective date of this change
574 * @param p_accommodation_id Unique accommodation identifier assigned to the
575 * accommodation record when created as primary key
576 * @param p_object_version_number Current version number of the accommodation
577 * record to be deleted
578 * @param p_effective_start_date If p_validate is false, the process returns
579 * the earliest effective start date for the created accommodation record. If
580 * p_validate is true, it returns null.
581 * @param p_effective_end_date If p_validate is false, the process returns
582 * effective end date for the created accommodation record. If p_validate is
583 * true, it returns null.
584 * @rep:displayname Delete Accommodation
585 * @rep:category BUSINESS_ENTITY PQH_EMPLOYER_ACCOMMODATION
586 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
587 * @rep:scope public
588 * @rep:lifecycle active
589 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
590 */
591 --
592 -- {End Of Comments}
593 --
594 procedure delete_accommodation
595 (p_validate in boolean default false
596 ,p_effective_date in date
597 ,p_datetrack_mode in varchar2
598 ,p_accommodation_id in number
599 ,p_object_version_number in OUT NOCOPY number
600 ,p_effective_start_date OUT NOCOPY date
601 ,p_effective_end_date OUT NOCOPY date
602 );
603
604 --
605 end pqh_accommodations_api;
[Home] [Help]