1 PACKAGE hr_rate_api AS
2 /* $Header: pypyrapi.pkh 120.1 2005/10/02 02:34:02 aroussel $ */
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 * @rep:displayname Update Rate
204 * @rep:category BUSINESS_ENTITY PER_CWK_RATE
205 * @rep:category BUSINESS_ENTITY PER_GRADE
206 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
207 * @rep:scope public
208 * @rep:lifecycle active
209 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
210 */
211 --
212 -- {End Of Comments}
213 --
214 PROCEDURE update_rate
215 (p_validate IN BOOLEAN DEFAULT FALSE
216 ,p_rate_id IN NUMBER
217 ,p_object_version_number IN OUT NOCOPY NUMBER
218 ,p_effective_date IN DATE
219 ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
220 ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
221 ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
222 ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
223 ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
224 ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
225 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
226 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
227 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
228 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
229 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
230 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
231 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
232 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
233 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
234 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
235 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
236 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
237 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
238 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
239 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
240 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
241 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
242 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
243 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
244 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
245 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2);
246 --
247 -- ----------------------------------------------------------------------------
248 -- |-------------------------------< delete_rate >----------------------------|
249 -- ----------------------------------------------------------------------------
250 --
251 -- {Start Of Comments}
252 /*#
253 * This API deletes a pay rate.
254 *
255 * Use this API to delete one of the three types of pay rates (Grade Rates, Pay
256 * Scale Rates, and Assignment Rates). The process deletes any database items
257 * already created.
258 *
259 * <p><b>Licensing</b><br>
260 * This API is licensed for use with Human Resources.
261 *
262 * <p><b>Prerequisites</b><br>
263 * The rate that is being deleted must already exist.
264 *
265 * <p><b>Post Success</b><br>
266 * The rate will have been deleted.
267 *
268 * <p><b>Post Failure</b><br>
269 * The rate will not be deleted and an error will be raised.
270 * @param p_validate If true, then validation alone will be performed and the
271 * database will remain unchanged. If false and all validation checks pass,
272 * then the database will be modified.
273 * @param p_effective_date Reference date for validating lookup values are
274 * applicable during the start to end active date range. This date does not
275 * determine when the changes take effect.
276 * @param p_rate_id Uniquely identifies the rate that is being deleted.
277 * @param p_rate_type The type of pay rate: Grade or Pay Scale. Valid values
278 * are defined by the 'RATE_TYPE' lookup type.
279 * @param p_object_version_number Current version number of the Rate to be
280 * deleted.
281 * @rep:displayname Delete Rate
282 * @rep:category BUSINESS_ENTITY PER_CWK_RATE
283 * @rep:category BUSINESS_ENTITY PER_GRADE
284 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
285 * @rep:scope public
286 * @rep:lifecycle active
287 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
288 */
289 --
290 -- {End Of Comments}
291 --
292 PROCEDURE delete_rate
293 (p_validate IN BOOLEAN DEFAULT FALSE
294 ,p_effective_date IN DATE
295 ,p_rate_id IN NUMBER
296 ,p_rate_type IN VARCHAR2
297 ,p_object_version_number IN OUT NOCOPY NUMBER
298 );
299 --
300 -- ----------------------------------------------------------------------------
301 -- |--------------------------< create_assignment_rate >----------------------|
302 -- ----------------------------------------------------------------------------
303 --
304 -- {Start Of Comments}
305 /*#
306 * This API creates Assignment Rate Types.
307 *
308 * Use this API to define rates for use with contingent worker assignments. In
309 * addition to the rate itself, database items are created automatically for
310 * each rate type. To create grade rates or pay scale rates, use the Create
311 * Rate API.
312 *
316 * <p><b>Prerequisites</b><br>
313 * <p><b>Licensing</b><br>
314 * This API is licensed for use with Human Resources.
315 *
317 * The Business Group must already exist. The 'RATE_BASIS' and
318 * 'PRICE_DIFFERENTIALS' lookup types must have values.
319 *
320 * <p><b>Post Success</b><br>
321 * The Assignment Rate Type will have been created.
322 *
323 * <p><b>Post Failure</b><br>
324 * The Assignment Rate Type will not be created and an error will be raised.
325 * @param p_validate If true, then validation alone will be performed and the
326 * database will remain unchanged. If false and all validation checks pass,
327 * then the database will be modified.
328 * @param p_effective_date Reference date for validating lookup values are
329 * applicable during the start to end active date range. This date does not
330 * determine when the changes take effect.
331 * @param p_business_group_id The business group under which the assignment
332 * rate will be created.
333 * @param p_name Named reference for the Assignment Rate Type.
334 * @param p_rate_basis The basis for the Assignment Rate Type, such as Hourly
335 * or Weekly. Valid values are defined by the 'RATE_BASIS' lookup type.
336 * @param p_asg_rate_type The assignment rate type associated with the rate.
337 * Valid values are defined by the 'PRICE_DIFFERENTIALS' lookup type.
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.
356 * @param p_attribute17 Descriptive flexfield segment.
357 * @param p_attribute18 Descriptive flexfield segment.
358 * @param p_attribute19 Descriptive flexfield segment.
359 * @param p_attribute20 Descriptive flexfield segment.
360 * @param p_object_version_number If p_validate is false, then set to the
361 * version number of the created assignment rate record. If p_validate is true,
362 * then the value will be null.
363 * @param p_rate_id If p_validate is false, uniquely identifies the assignment
364 * rate created. If p_validate is true, set to null.
365 * @rep:displayname Create Assignment Rate
366 * @rep:category BUSINESS_ENTITY PER_CWK_RATE
367 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
368 * @rep:scope public
369 * @rep:lifecycle active
370 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
371 */
372 --
373 -- {End Of Comments}
374 --
375 PROCEDURE create_assignment_rate
376 (p_validate IN BOOLEAN DEFAULT FALSE
377 ,p_effective_date IN DATE
378 ,p_business_group_id IN NUMBER
379 ,p_name IN VARCHAR2
380 ,p_rate_basis IN VARCHAR2
381 ,p_asg_rate_type IN VARCHAR2 DEFAULT NULL
382 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
383 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
384 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
385 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
386 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
387 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
388 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
389 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
390 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
391 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
392 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
393 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
394 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
395 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
396 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
397 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
398 ,p_attribute16 IN VARCHAR2 DEFAULT NULL
399 ,p_attribute17 IN VARCHAR2 DEFAULT NULL
400 ,p_attribute18 IN VARCHAR2 DEFAULT NULL
401 ,p_attribute19 IN VARCHAR2 DEFAULT NULL
402 ,p_attribute20 IN VARCHAR2 DEFAULT NULL
403 ,p_object_version_number OUT NOCOPY NUMBER
404 ,p_rate_id OUT NOCOPY NUMBER);
405 --
406 -- ----------------------------------------------------------------------------
407 -- |--------------------------< update_assignment_rate >----------------------|
408 -- ----------------------------------------------------------------------------
409 --
410 -- {Start Of Comments}
411 /*#
412 * This API updates Assignment Rate Types.
413 *
414 * Use this API to update assignment rate types, which define rates for use
415 * with contingent worker assignments. In addition to the rate itself, database
416 * items are created automatically for each rate type. To update grade rates or
417 * pay scale rates, use the Update Rate API.
418 *
419 * <p><b>Licensing</b><br>
420 * This API is licensed for use with Human Resources.
421 *
422 * <p><b>Prerequisites</b><br>
423 * The Assignment Rate Type that is being updated must already exist.
424 *
425 * <p><b>Post Success</b><br>
426 * The Assignment Rate Type will have been updated.
427 *
428 * <p><b>Post Failure</b><br>
429 * The Assignment Rate Type will not be updated and an error will be raised.
430 * @param p_validate If true, then validation alone will be performed and the
431 * database will remain unchanged. If false and all validation checks pass,
432 * then the database will be modified.
433 * @param p_rate_id Uniquely identifies the Assignment Rate Type that is being
434 * updated.
435 * @param p_object_version_number Pass in the current version number of the
436 * Assignment Rate to be updated. When the API completes if p_validate is
437 * false, will be set to the new version number of the updated Assignment Rate.
438 * If p_validate is true will be set to the same value which was passed in.
439 * @param p_effective_date Reference date for validating lookup values are
440 * applicable during the start to end active date range. This date does not
441 * determine when the changes take effect.
442 * @param p_name Named reference for the Assignment Rate Type.
443 * @param p_rate_basis The basis for the Assignment Rate Type, for example,
444 * Hourly or Weekly. Valid values are defined by the 'RATE_BASIS' lookup type.
445 * @param p_asg_rate_type The assignment rate type associated with the rate.
446 * Valid values are defined by the 'PRICE_DIFFERENTIALS' lookup type.
447 * @param p_attribute_category This context value determines which flexfield
448 * structure to use with the descriptive flexfield segments.
449 * @param p_attribute1 Descriptive flexfield segment.
450 * @param p_attribute2 Descriptive flexfield segment.
451 * @param p_attribute3 Descriptive flexfield segment.
452 * @param p_attribute4 Descriptive flexfield segment.
453 * @param p_attribute5 Descriptive flexfield segment.
454 * @param p_attribute6 Descriptive flexfield segment.
455 * @param p_attribute7 Descriptive flexfield segment.
456 * @param p_attribute8 Descriptive flexfield segment.
457 * @param p_attribute9 Descriptive flexfield segment.
458 * @param p_attribute10 Descriptive flexfield segment.
459 * @param p_attribute11 Descriptive flexfield segment.
460 * @param p_attribute12 Descriptive flexfield segment.
461 * @param p_attribute13 Descriptive flexfield segment.
462 * @param p_attribute14 Descriptive flexfield segment.
463 * @param p_attribute15 Descriptive flexfield segment.
464 * @param p_attribute16 Descriptive flexfield segment.
465 * @param p_attribute17 Descriptive flexfield segment.
466 * @param p_attribute18 Descriptive flexfield segment.
467 * @param p_attribute19 Descriptive flexfield segment.
468 * @param p_attribute20 Descriptive flexfield segment.
469 * @rep:displayname Update Assignment Rate
470 * @rep:category BUSINESS_ENTITY PER_CWK_RATE
471 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
472 * @rep:scope public
473 * @rep:lifecycle active
474 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
475 */
476 --
477 -- {End Of Comments}
478 --
479 PROCEDURE update_assignment_rate
480 (p_validate IN BOOLEAN DEFAULT FALSE
481 ,p_rate_id IN NUMBER
482 ,p_object_version_number IN OUT NOCOPY NUMBER
483 ,p_effective_date IN DATE
484 ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
485 ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
486 ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
487 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
488 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
494 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2);
508 --
509 END hr_rate_api;
[Home] [Help]