1 PACKAGE hr_rate_api AUTHID CURRENT_USER AS
2 /* $Header: pypyrapi.pkh 120.2 2010/03/04 12:04:48 sidsaxen ship $ */
3 /*#
4 * This package contains HR Rate APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Rate
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-------------------------------< create_rate >----------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates Grade Rates and Grade Scale Rates.
17 *
18 * Use this API to create two types of Pay Rates: Grade Rates and Pay Scale
19 * Rates. Create Grade Rates to enter fixed amounts and ranges for each grade.
20 * Create Pay Scale Rates to enter values for each point in a pay scale. In
21 * addition to the rate itself, the process automatically creates database
22 * items for each pay rate. To create Assignment Rate Types, use the Create
23 * Assignment Rate API.
24 *
25 * <p><b>Licensing</b><br>
26 * This API is licensed for use with Human Resources.
27 *
28 * <p><b>Prerequisites</b><br>
29 * The Grade for which this rate is created must already exist. The Pay Scale
30 * for which this rate is created must already exist.
31 *
32 * <p><b>Post Success</b><br>
33 * The pay rate will have been created.
34 *
35 * <p><b>Post Failure</b><br>
36 * The pay rate will not be created and an error will be raised.
37 * @param p_validate If true, then validation alone will be performed and the
38 * database will remain unchanged. If false and all validation checks pass,
39 * then the database will be modified.
40 * @param p_effective_date Reference date for validating lookup values are
41 * applicable during the start to end active date range. This date does not
42 * determine when the changes take effect.
43 * @param p_business_group_id The business group under which the pay rate is
44 * created.
45 * @param p_name Named reference for the pay rate.
46 * @param p_rate_type The type of pay rate: Grade or Pay Scale. Valid values
47 * are defined by the 'RATE_TYPE' lookup type.
48 * @param p_rate_uom The rate's unit of measure (UOM). Valid values are defined
49 * by the 'RATE_TYPE' lookup type.
50 * @param p_parent_spine_id The pay scale for which this rate is being created.
51 * For use when creating rates for a Pay Scale.
52 * @param p_comments Comment text.
53 * @param p_rate_basis The rate basis associated with the rate. Valid values
54 * are defined by the 'RATE_BASIS' lookup type, but rate basis is specific to
55 * assignment rates. Use the Assignment Rate APIs instead.
56 * @param p_asg_rate_type The assignment rate type associated with the rate.
57 * Valid values are defined by the 'PRICE_DIFFERENTIALS' lookup type, but this
58 * is specific to assignment rates. Use the Assignment Rate APIs instead.
59 * @param p_attribute_category This context value determines which flexfield
60 * structure to use with the descriptive flexfield segments.
61 * @param p_attribute1 Descriptive flexfield segment.
62 * @param p_attribute2 Descriptive flexfield segment.
63 * @param p_attribute3 Descriptive flexfield segment.
64 * @param p_attribute4 Descriptive flexfield segment.
65 * @param p_attribute5 Descriptive flexfield segment.
66 * @param p_attribute6 Descriptive flexfield segment.
67 * @param p_attribute7 Descriptive flexfield segment.
68 * @param p_attribute8 Descriptive flexfield segment.
69 * @param p_attribute9 Descriptive flexfield segment.
70 * @param p_attribute10 Descriptive flexfield segment.
71 * @param p_attribute11 Descriptive flexfield segment.
72 * @param p_attribute12 Descriptive flexfield segment.
73 * @param p_attribute13 Descriptive flexfield segment.
74 * @param p_attribute14 Descriptive flexfield segment.
75 * @param p_attribute15 Descriptive flexfield segment.
76 * @param p_attribute16 Descriptive flexfield segment.
77 * @param p_attribute17 Descriptive flexfield segment.
78 * @param p_attribute18 Descriptive flexfield segment.
79 * @param p_attribute19 Descriptive flexfield segment.
80 * @param p_attribute20 Descriptive flexfield segment.
81 * @param p_object_version_number If p_validate is false, then set to the
82 * version number of the created pay rate record. If p_validate is true, then
83 * the value will be null.
84 * @param p_rate_id If p_validate is false, then this uniquely identifies the
85 * pay rate created. If p_validate is true, then this is set to null.
86 * @rep:displayname Create Rate
87 * @rep:category BUSINESS_ENTITY PER_CWK_RATE
88 * @rep:category BUSINESS_ENTITY PER_GRADE
89 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
90 * @rep:scope public
91 * @rep:lifecycle active
92 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
93 */
94 --
95 -- {End Of Comments}
96 --
97 PROCEDURE create_rate
98 (p_validate IN BOOLEAN DEFAULT FALSE
99 ,p_effective_date IN DATE
100 ,p_business_group_id IN NUMBER
101 ,p_name IN VARCHAR2
102 ,p_rate_type IN VARCHAR2
103 ,p_rate_uom IN VARCHAR2
104 ,p_parent_spine_id IN NUMBER DEFAULT NULL
105 ,p_comments IN VARCHAR2 DEFAULT NULL
106 ,p_rate_basis IN VARCHAR2 DEFAULT NULL
107 ,p_asg_rate_type IN VARCHAR2 DEFAULT NULL
108 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
109 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
110 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
111 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
112 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
113 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
114 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
115 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
116 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
117 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
118 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
119 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
120 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
121 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
122 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
123 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
124 ,p_attribute16 IN VARCHAR2 DEFAULT NULL
125 ,p_attribute17 IN VARCHAR2 DEFAULT NULL
126 ,p_attribute18 IN VARCHAR2 DEFAULT NULL
127 ,p_attribute19 IN VARCHAR2 DEFAULT NULL
128 ,p_attribute20 IN VARCHAR2 DEFAULT NULL
129 ,p_object_version_number OUT NOCOPY NUMBER
130 ,p_rate_id OUT NOCOPY NUMBER);
131 --
132 -- ----------------------------------------------------------------------------
133 -- |-------------------------------< update_rate >----------------------------|
134 -- ----------------------------------------------------------------------------
135 --
136 -- {Start Of Comments}
137 /*#
138 * This API updates Grade Rates or Grade Scale Rates.
139 *
140 * Use this API to update two types of Pay Rates: Grade Rates and Pay Scale
141 * Rates. Update Grade Rates to enter fixed amounts and ranges for each grade.
142 * Update Pay Scale Rates to enter values for each point in a pay scale. In
143 * addition to the rate itself, the process automatically creates/updates
144 * database items for each pay rate. To update Assignment Rate Types, use the
145 * Update Assignment Rate API.
146 *
147 * <p><b>Licensing</b><br>
148 * This API is licensed for use with Human Resources.
149 *
150 * <p><b>Prerequisites</b><br>
151 * The Pay Rate that is being updated must already exist.
152 *
153 * <p><b>Post Success</b><br>
154 * The pay rate will have been updated.
155 *
156 * <p><b>Post Failure</b><br>
157 * The pay rate will not be updated and an error will be raised.
158 * @param p_validate If true, then validation alone will be performed and the
159 * database will remain unchanged. If false and all validation checks pass,
160 * then the database will be modified.
161 * @param p_rate_id Uniquely identifies the pay rate that is being updated.
162 * @param p_object_version_number Pass in the current version number of the
163 * Rate to be updated. When the API completes if p_validate is false, will be
164 * set to the new version number of the updated Rate. If p_validate is true
165 * will be set to the same value which was passed in.
166 * @param p_effective_date Reference date for validating lookup values are
167 * applicable during the start to end active date range. This date does not
168 * determine when the changes take effect.
169 * @param p_name Named reference for the pay rate.
170 * @param p_rate_uom The rate's unit of measure (UOM). Valid values are defined
171 * by the 'RATE_TYPE' lookup type.
172 * @param p_parent_spine_id The pay scale for which this rate is being created.
173 * For use when creating rates for a Pay Scale.
174 * @param p_comments Comment text.
175 * @param p_rate_basis The rate basis associated with the rate. Valid values
176 * are defined by the 'RATE_BASIS' lookup type, but rate basis is specific to
177 * assignment rates. Use the Assignment Rate APIs instead.
178 * @param p_asg_rate_type The assignment rate type associated with the rate.
179 * Valid values are defined by the 'PRICE_DIFFERENTIALS' lookup type, but this
180 * is specific to assignment rates. Use the Assignment Rate APIs instead.
181 * @param p_attribute_category This context value determines which flexfield
182 * structure to use with the descriptive flexfield segments.
183 * @param p_attribute1 Descriptive flexfield segment.
184 * @param p_attribute2 Descriptive flexfield segment.
185 * @param p_attribute3 Descriptive flexfield segment.
186 * @param p_attribute4 Descriptive flexfield segment.
187 * @param p_attribute5 Descriptive flexfield segment.
188 * @param p_attribute6 Descriptive flexfield segment.
189 * @param p_attribute7 Descriptive flexfield segment.
190 * @param p_attribute8 Descriptive flexfield segment.
191 * @param p_attribute9 Descriptive flexfield segment.
192 * @param p_attribute10 Descriptive flexfield segment.
193 * @param p_attribute11 Descriptive flexfield segment.
194 * @param p_attribute12 Descriptive flexfield segment.
195 * @param p_attribute13 Descriptive flexfield segment.
196 * @param p_attribute14 Descriptive flexfield segment.
197 * @param p_attribute15 Descriptive flexfield segment.
198 * @param p_attribute16 Descriptive flexfield segment.
199 * @param p_attribute17 Descriptive flexfield segment.
200 * @param p_attribute18 Descriptive flexfield segment.
201 * @param p_attribute19 Descriptive flexfield segment.
202 * @param p_attribute20 Descriptive flexfield segment.
203 * @param p_called_from Pass in the calling program name. The valid values are
204 * API, FORM and GSPW.
205 * @rep:displayname Update Rate
206 * @rep:category BUSINESS_ENTITY PER_CWK_RATE
207 * @rep:category BUSINESS_ENTITY PER_GRADE
208 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
209 * @rep:scope public
210 * @rep:lifecycle active
211 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
212 */
213 --
214 -- {End Of Comments}
215 --
216 PROCEDURE update_rate
217 (p_validate IN BOOLEAN DEFAULT FALSE
218 ,p_rate_id IN NUMBER
219 ,p_object_version_number IN OUT NOCOPY NUMBER
220 ,p_effective_date IN DATE
221 ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
222 ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
223 ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
224 ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
225 ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
226 ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
227 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
228 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
229 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
230 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
231 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
232 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
233 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
234 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
235 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
236 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
237 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
238 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
239 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
240 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
241 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
242 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
243 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
244 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
245 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
246 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
247 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
248 ,p_called_from IN VARCHAR2 --added for bug 9328526
249 );
250
251 -- Start changes for bug 9328526
252 PROCEDURE update_rate
253 (p_validate IN BOOLEAN DEFAULT FALSE
254 ,p_rate_id IN NUMBER
255 ,p_object_version_number IN OUT NOCOPY NUMBER
256 ,p_effective_date IN DATE
257 ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
258 ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
259 ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
260 ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
261 ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
262 ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
263 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
264 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
265 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
266 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
267 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
268 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
269 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
270 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
271 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
272 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
273 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
274 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
275 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
276 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
277 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
278 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
279 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
280 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
281 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
282 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
283 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
284 );
285 -- End changes for bug 9328526
286 --
287 -- ----------------------------------------------------------------------------
288 -- |-------------------------------< delete_rate >----------------------------|
289 -- ----------------------------------------------------------------------------
290 --
291 -- {Start Of Comments}
292 /*#
293 * This API deletes a pay rate.
294 *
295 * Use this API to delete one of the three types of pay rates (Grade Rates, Pay
296 * Scale Rates, and Assignment Rates). The process deletes any database items
297 * already created.
298 *
299 * <p><b>Licensing</b><br>
300 * This API is licensed for use with Human Resources.
301 *
302 * <p><b>Prerequisites</b><br>
303 * The rate that is being deleted must already exist.
304 *
305 * <p><b>Post Success</b><br>
306 * The rate will have been deleted.
307 *
308 * <p><b>Post Failure</b><br>
309 * The rate will not be deleted and an error will be raised.
310 * @param p_validate If true, then validation alone will be performed and the
311 * database will remain unchanged. If false and all validation checks pass,
312 * then the database will be modified.
313 * @param p_effective_date Reference date for validating lookup values are
314 * applicable during the start to end active date range. This date does not
315 * determine when the changes take effect.
316 * @param p_rate_id Uniquely identifies the rate that is being deleted.
317 * @param p_rate_type The type of pay rate: Grade or Pay Scale. Valid values
318 * are defined by the 'RATE_TYPE' lookup type.
319 * @param p_object_version_number Current version number of the Rate to be
320 * deleted.
321 * @param p_called_from Pass in the calling program name. The valid values are
322 * API, FORM and GSPW.
323 * @rep:displayname Delete Rate
324 * @rep:category BUSINESS_ENTITY PER_CWK_RATE
325 * @rep:category BUSINESS_ENTITY PER_GRADE
326 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
327 * @rep:scope public
328 * @rep:lifecycle active
329 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
330 */
331 --
332 -- {End Of Comments}
333 --
334 PROCEDURE delete_rate
335 (p_validate IN BOOLEAN DEFAULT FALSE
336 ,p_effective_date IN DATE
337 ,p_rate_id IN NUMBER
338 ,p_rate_type IN VARCHAR2
339 ,p_object_version_number IN OUT NOCOPY NUMBER
340 ,p_called_from IN VARCHAR2 --added for bug 9328526
341 );
342
343 -- Start changes for bug 9328526
344 -- Overloaded procedure delete_rate
345 --
346 -- ----------------------------------------------------------------------------
347 -- |-------------------------------< delete_rate >----------------------------|
348 -- ----------------------------------------------------------------------------
349 --
350 PROCEDURE delete_rate
351 (p_validate IN BOOLEAN DEFAULT FALSE
352 ,p_effective_date IN DATE
353 ,p_rate_id IN NUMBER
354 ,p_rate_type IN VARCHAR2
355 ,p_object_version_number IN OUT NOCOPY NUMBER
356 );
357 -- End changes for bug 9328526
358
359 --
360 -- ----------------------------------------------------------------------------
361 -- |--------------------------< create_assignment_rate >----------------------|
362 -- ----------------------------------------------------------------------------
363 --
364 -- {Start Of Comments}
365 /*#
366 * This API creates Assignment Rate Types.
367 *
368 * Use this API to define rates for use with contingent worker assignments. In
369 * addition to the rate itself, database items are created automatically for
370 * each rate type. To create grade rates or pay scale rates, use the Create
371 * Rate API.
372 *
373 * <p><b>Licensing</b><br>
374 * This API is licensed for use with Human Resources.
375 *
376 * <p><b>Prerequisites</b><br>
377 * The Business Group must already exist. The 'RATE_BASIS' and
378 * 'PRICE_DIFFERENTIALS' lookup types must have values.
379 *
380 * <p><b>Post Success</b><br>
381 * The Assignment Rate Type will have been created.
382 *
383 * <p><b>Post Failure</b><br>
384 * The Assignment Rate Type will not be created and an error will be raised.
385 * @param p_validate If true, then validation alone will be performed and the
386 * database will remain unchanged. If false and all validation checks pass,
387 * then the database will be modified.
388 * @param p_effective_date Reference date for validating lookup values are
389 * applicable during the start to end active date range. This date does not
390 * determine when the changes take effect.
391 * @param p_business_group_id The business group under which the assignment
392 * rate will be created.
393 * @param p_name Named reference for the Assignment Rate Type.
394 * @param p_rate_basis The basis for the Assignment Rate Type, such as Hourly
395 * or Weekly. Valid values are defined by the 'RATE_BASIS' lookup type.
396 * @param p_asg_rate_type The assignment rate type associated with the rate.
397 * Valid values are defined by the 'PRICE_DIFFERENTIALS' lookup type.
398 * @param p_attribute_category This context value determines which flexfield
399 * structure to use with the descriptive flexfield segments.
400 * @param p_attribute1 Descriptive flexfield segment.
401 * @param p_attribute2 Descriptive flexfield segment.
402 * @param p_attribute3 Descriptive flexfield segment.
403 * @param p_attribute4 Descriptive flexfield segment.
404 * @param p_attribute5 Descriptive flexfield segment.
405 * @param p_attribute6 Descriptive flexfield segment.
406 * @param p_attribute7 Descriptive flexfield segment.
407 * @param p_attribute8 Descriptive flexfield segment.
408 * @param p_attribute9 Descriptive flexfield segment.
409 * @param p_attribute10 Descriptive flexfield segment.
410 * @param p_attribute11 Descriptive flexfield segment.
411 * @param p_attribute12 Descriptive flexfield segment.
412 * @param p_attribute13 Descriptive flexfield segment.
413 * @param p_attribute14 Descriptive flexfield segment.
414 * @param p_attribute15 Descriptive flexfield segment.
415 * @param p_attribute16 Descriptive flexfield segment.
416 * @param p_attribute17 Descriptive flexfield segment.
417 * @param p_attribute18 Descriptive flexfield segment.
418 * @param p_attribute19 Descriptive flexfield segment.
419 * @param p_attribute20 Descriptive flexfield segment.
420 * @param p_object_version_number If p_validate is false, then set to the
421 * version number of the created assignment rate record. If p_validate is true,
422 * then the value will be null.
423 * @param p_rate_id If p_validate is false, uniquely identifies the assignment
424 * rate created. If p_validate is true, set to null.
425 * @rep:displayname Create Assignment Rate
426 * @rep:category BUSINESS_ENTITY PER_CWK_RATE
427 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
428 * @rep:scope public
429 * @rep:lifecycle active
430 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
431 */
432 --
433 -- {End Of Comments}
434 --
435 PROCEDURE create_assignment_rate
436 (p_validate IN BOOLEAN DEFAULT FALSE
437 ,p_effective_date IN DATE
438 ,p_business_group_id IN NUMBER
439 ,p_name IN VARCHAR2
440 ,p_rate_basis IN VARCHAR2
441 ,p_asg_rate_type IN VARCHAR2 DEFAULT NULL
442 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
443 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
444 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
445 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
446 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
447 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
448 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
449 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
450 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
451 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
452 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
453 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
454 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
455 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
456 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
457 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
458 ,p_attribute16 IN VARCHAR2 DEFAULT NULL
459 ,p_attribute17 IN VARCHAR2 DEFAULT NULL
460 ,p_attribute18 IN VARCHAR2 DEFAULT NULL
461 ,p_attribute19 IN VARCHAR2 DEFAULT NULL
462 ,p_attribute20 IN VARCHAR2 DEFAULT NULL
463 ,p_object_version_number OUT NOCOPY NUMBER
464 ,p_rate_id OUT NOCOPY NUMBER);
465 --
466 -- ----------------------------------------------------------------------------
467 -- |--------------------------< update_assignment_rate >----------------------|
468 -- ----------------------------------------------------------------------------
469 --
470 -- {Start Of Comments}
471 /*#
472 * This API updates Assignment Rate Types.
473 *
474 * Use this API to update assignment rate types, which define rates for use
475 * with contingent worker assignments. In addition to the rate itself, database
476 * items are created automatically for each rate type. To update grade rates or
477 * pay scale rates, use the Update Rate API.
478 *
479 * <p><b>Licensing</b><br>
480 * This API is licensed for use with Human Resources.
481 *
482 * <p><b>Prerequisites</b><br>
483 * The Assignment Rate Type that is being updated must already exist.
484 *
485 * <p><b>Post Success</b><br>
486 * The Assignment Rate Type will have been updated.
487 *
488 * <p><b>Post Failure</b><br>
489 * The Assignment Rate Type will not be updated and an error will be raised.
490 * @param p_validate If true, then validation alone will be performed and the
491 * database will remain unchanged. If false and all validation checks pass,
492 * then the database will be modified.
493 * @param p_rate_id Uniquely identifies the Assignment Rate Type that is being
494 * updated.
495 * @param p_object_version_number Pass in the current version number of the
496 * Assignment Rate to be updated. When the API completes if p_validate is
497 * false, will be set to the new version number of the updated Assignment Rate.
498 * If p_validate is true will be set to the same value which was passed in.
499 * @param p_effective_date Reference date for validating lookup values are
500 * applicable during the start to end active date range. This date does not
501 * determine when the changes take effect.
502 * @param p_name Named reference for the Assignment Rate Type.
503 * @param p_rate_basis The basis for the Assignment Rate Type, for example,
504 * Hourly or Weekly. Valid values are defined by the 'RATE_BASIS' lookup type.
505 * @param p_asg_rate_type The assignment rate type associated with the rate.
506 * Valid values are defined by the 'PRICE_DIFFERENTIALS' lookup type.
507 * @param p_attribute_category This context value determines which flexfield
508 * structure to use with the descriptive flexfield segments.
509 * @param p_attribute1 Descriptive flexfield segment.
510 * @param p_attribute2 Descriptive flexfield segment.
511 * @param p_attribute3 Descriptive flexfield segment.
512 * @param p_attribute4 Descriptive flexfield segment.
513 * @param p_attribute5 Descriptive flexfield segment.
514 * @param p_attribute6 Descriptive flexfield segment.
515 * @param p_attribute7 Descriptive flexfield segment.
516 * @param p_attribute8 Descriptive flexfield segment.
517 * @param p_attribute9 Descriptive flexfield segment.
518 * @param p_attribute10 Descriptive flexfield segment.
519 * @param p_attribute11 Descriptive flexfield segment.
520 * @param p_attribute12 Descriptive flexfield segment.
521 * @param p_attribute13 Descriptive flexfield segment.
522 * @param p_attribute14 Descriptive flexfield segment.
523 * @param p_attribute15 Descriptive flexfield segment.
524 * @param p_attribute16 Descriptive flexfield segment.
525 * @param p_attribute17 Descriptive flexfield segment.
526 * @param p_attribute18 Descriptive flexfield segment.
527 * @param p_attribute19 Descriptive flexfield segment.
528 * @param p_attribute20 Descriptive flexfield segment.
529 * @rep:displayname Update Assignment Rate
530 * @rep:category BUSINESS_ENTITY PER_CWK_RATE
531 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
532 * @rep:scope public
533 * @rep:lifecycle active
534 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
535 */
536 --
537 -- {End Of Comments}
538 --
539 PROCEDURE update_assignment_rate
540 (p_validate IN BOOLEAN DEFAULT FALSE
541 ,p_rate_id IN NUMBER
542 ,p_object_version_number IN OUT NOCOPY NUMBER
543 ,p_effective_date IN DATE
544 ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
545 ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
546 ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
547 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
548 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
562 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
563 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
564 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
565 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
566 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
567 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2);
568 --
569 END hr_rate_api;
[Home] [Help]