1 Package hr_grade_api as
2 /* $Header: pegrdapi.pkh 120.1.12010000.3 2008/12/05 08:02:39 sidsaxen ship $ */
3 /*#
4 * The package contains APIs that maintain grade information.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Grade
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-------------------------------< create_grade >---------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a grade.
17 *
18 * A component of an employee assignment that defines their level and can be
19 * used to control the value of their salary and other compensation elements.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources.
23 *
24 * <p><b>Prerequisites</b><br>
25 * A business group must exist. A grade keyflex field must be defined for the
26 * business group the grade is to be created in. At least one segment of this
27 * flexfield must have a value.
28 *
29 * <p><b>Post Success</b><br>
30 * A grade will be created.
31 *
32 * <p><b>Post Failure</b><br>
33 * A grade will not be created and an error will be raised.
34 * @param p_validate If true, then validation alone will be performed and the
35 * database will remain unchanged. If false and all validation checks pass,
36 * then the database will be modified.
37 * @param p_business_group_id The identifier of the business group that the
38 * grade will be created in.
39 * @param p_date_from The date on which the grade is active.
40 * @param p_sequence Numerical identifier that orders the sequence of grades.
41 * Must be unique within the business group.
42 * @param p_effective_date Reference date for validating lookup values are
43 * applicable during the start to end active date range. This date does not
44 * determine when the changes take effect.
45 * @param p_date_to The date after which the grade is no longer active
46 * @param p_request_id When the API is executed from a concurrent program set
47 * to the concurrent request identifier.
48 * @param p_program_application_id When the API is executed from a concurrent
49 * program set to the program's Application.
50 * @param p_program_id When the API is executed from a concurrent program set
51 * to the program's identifier.
52 * @param p_program_update_date When the API is executed from a concurrent
53 * program set to when the program was ran.
54 * @param p_last_update_date The date upon which the record was last updated.
55 * @param p_last_updated_by The system identifier of the user who last updated
56 * the record.
57 * @param p_last_update_login The operating system login of the user who last
58 * updated the record.
59 * @param p_created_by The system identifier of the user who created the
60 * record.
61 * @param p_creation_date The date upon which the record was created.
62 * @param p_attribute_category This context value determines which flexfield
63 * structure to use with the descriptive flexfield segments.
64 * @param p_attribute1 Descriptive flexfield segment.
65 * @param p_attribute2 Descriptive flexfield segment.
66 * @param p_attribute3 Descriptive flexfield segment.
67 * @param p_attribute4 Descriptive flexfield segment.
68 * @param p_attribute5 Descriptive flexfield segment.
69 * @param p_attribute6 Descriptive flexfield segment.
70 * @param p_attribute7 Descriptive flexfield segment.
71 * @param p_attribute8 Descriptive flexfield segment.
72 * @param p_attribute9 Descriptive flexfield segment.
73 * @param p_attribute10 Descriptive flexfield segment.
74 * @param p_attribute11 Descriptive flexfield segment.
75 * @param p_attribute12 Descriptive flexfield segment.
76 * @param p_attribute13 Descriptive flexfield segment.
77 * @param p_attribute14 Descriptive flexfield segment.
78 * @param p_attribute15 Descriptive flexfield segment.
79 * @param p_attribute16 Descriptive flexfield segment.
80 * @param p_attribute17 Descriptive flexfield segment.
81 * @param p_attribute18 Descriptive flexfield segment.
82 * @param p_attribute19 Descriptive flexfield segment.
83 * @param p_attribute20 Descriptive flexfield segment.
84 * @param p_information_category This context value determines which flexfield
85 * structure to use with the developer descriptive flexfield segments.
86 * @param p_information1 Developer descriptive flexfield segment.
87 * @param p_information2 Developer descriptive flexfield segment.
88 * @param p_information3 Developer descriptive flexfield segment.
89 * @param p_information4 Developer descriptive flexfield segment.
90 * @param p_information5 Developer descriptive flexfield segment.
91 * @param p_information6 Developer descriptive flexfield segment.
92 * @param p_information7 Developer descriptive flexfield segment.
93 * @param p_information8 Developer descriptive flexfield segment.
94 * @param p_information9 Developer descriptive flexfield segment.
95 * @param p_information10 Developer descriptive flexfield segment.
96 * @param p_information11 Developer descriptive flexfield segment.
97 * @param p_information12 Developer descriptive flexfield segment.
98 * @param p_information13 Developer descriptive flexfield segment.
99 * @param p_information14 Developer descriptive flexfield segment.
100 * @param p_information15 Developer descriptive flexfield segment.
101 * @param p_information16 Developer descriptive flexfield segment.
102 * @param p_information17 Developer descriptive flexfield segment.
103 * @param p_information18 Developer descriptive flexfield segment.
104 * @param p_information19 Developer descriptive flexfield segment.
105 * @param p_information20 Developer descriptive flexfield segment.
106 * @param p_segment1 Key flexfield segment.
107 * @param p_segment2 Key flexfield segment.
108 * @param p_segment3 Key flexfield segment.
109 * @param p_segment4 Key flexfield segment.
110 * @param p_segment5 Key flexfield segment.
111 * @param p_segment6 Key flexfield segment.
112 * @param p_segment7 Key flexfield segment.
113 * @param p_segment8 Key flexfield segment.
114 * @param p_segment9 Key flexfield segment.
115 * @param p_segment10 Key flexfield segment.
116 * @param p_segment11 Key flexfield segment.
117 * @param p_segment12 Key flexfield segment.
118 * @param p_segment13 Key flexfield segment.
119 * @param p_segment14 Key flexfield segment.
120 * @param p_segment15 Key flexfield segment.
121 * @param p_segment16 Key flexfield segment.
122 * @param p_segment17 Key flexfield segment.
123 * @param p_segment18 Key flexfield segment.
124 * @param p_segment19 Key flexfield segment.
125 * @param p_segment20 Key flexfield segment.
126 * @param p_segment21 Key flexfield segment.
127 * @param p_segment22 Key flexfield segment.
128 * @param p_segment23 Key flexfield segment.
129 * @param p_segment24 Key flexfield segment.
130 * @param p_segment25 Key flexfield segment.
131 * @param p_segment26 Key flexfield segment.
132 * @param p_segment27 Key flexfield segment.
133 * @param p_segment28 Key flexfield segment.
134 * @param p_segment29 Key flexfield segment.
135 * @param p_segment30 Key flexfield segment.
136 * @param p_language_code Specifies to which language the translation values
137 * apply. You can set to the base or any installed language. The default value
138 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
139 * value.
140 * @param p_concat_segments Alternative to passing in individual key flexfield
141 * segments.
142 * @param p_short_name Short name for the grade, used in grade step
143 * progression. Has to be unique within the business group.
144 * @param p_grade_id If p_validate is false, uniquely identifies the grade
145 * created. If p_validate is true, set to null.
146 * @param p_object_version_number If p_validate is false, then set to the
147 * version number of the created grade. If p_validate is true, then the value
148 * will be null.
149 * @param p_grade_definition_id If p_validate is false, uniquely identifies the
150 * combination of segments passed. If p_validate is true, set to null.
151 * @param p_name If p_validate is false, concatenation of all segments. If
152 * p_validate is true, set to null.
153 * @rep:displayname Create Grade
154 * @rep:category BUSINESS_ENTITY PER_GRADE
155 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
156 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
157 * @rep:scope public
158 * @rep:lifecycle active
159 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
160 */
161 --
162 -- {End Of Comments}
163 --
164 procedure create_grade
165 (p_validate in boolean default false
166 ,p_business_group_id in number
167 ,p_date_from in date
168 ,p_sequence in number
169 ,p_effective_date in date default null
170 ,p_date_to in date default null
171 ,p_request_id in number default null
172 ,p_program_application_id in number default null
173 ,p_program_id in number default null
174 ,p_program_update_date in date default null
175 ,p_last_update_date in date default null
176 ,p_last_updated_by in number default null
177 ,p_last_update_login in number default null
178 ,p_created_by in number default null
179 ,p_creation_date in date default null
180 ,p_attribute_category in varchar2 default null
181 ,p_attribute1 in varchar2 default null
182 ,p_attribute2 in varchar2 default null
183 ,p_attribute3 in varchar2 default null
184 ,p_attribute4 in varchar2 default null
185 ,p_attribute5 in varchar2 default null
186 ,p_attribute6 in varchar2 default null
187 ,p_attribute7 in varchar2 default null
188 ,p_attribute8 in varchar2 default null
189 ,p_attribute9 in varchar2 default null
190 ,p_attribute10 in varchar2 default null
191 ,p_attribute11 in varchar2 default null
192 ,p_attribute12 in varchar2 default null
193 ,p_attribute13 in varchar2 default null
194 ,p_attribute14 in varchar2 default null
195 ,p_attribute15 in varchar2 default null
196 ,p_attribute16 in varchar2 default null
197 ,p_attribute17 in varchar2 default null
198 ,p_attribute18 in varchar2 default null
199 ,p_attribute19 in varchar2 default null
200 ,p_attribute20 in varchar2 default null
201 ,p_information_category in varchar2 default null
202 ,p_information1 in varchar2 default null
203 ,p_information2 in varchar2 default null
204 ,p_information3 in varchar2 default null
205 ,p_information4 in varchar2 default null
206 ,p_information5 in varchar2 default null
207 ,p_information6 in varchar2 default null
208 ,p_information7 in varchar2 default null
209 ,p_information8 in varchar2 default null
210 ,p_information9 in varchar2 default null
211 ,p_information10 in varchar2 default null
212 ,p_information11 in varchar2 default null
213 ,p_information12 in varchar2 default null
214 ,p_information13 in varchar2 default null
215 ,p_information14 in varchar2 default null
216 ,p_information15 in varchar2 default null
217 ,p_information16 in varchar2 default null
218 ,p_information17 in varchar2 default null
219 ,p_information18 in varchar2 default null
220 ,p_information19 in varchar2 default null
221 ,p_information20 in varchar2 default null
222 ,p_segment1 in varchar2 default null
223 ,p_segment2 in varchar2 default null
224 ,p_segment3 in varchar2 default null
225 ,p_segment4 in varchar2 default null
226 ,p_segment5 in varchar2 default null
227 ,p_segment6 in varchar2 default null
228 ,p_segment7 in varchar2 default null
229 ,p_segment8 in varchar2 default null
230 ,p_segment9 in varchar2 default null
231 ,p_segment10 in varchar2 default null
232 ,p_segment11 in varchar2 default null
233 ,p_segment12 in varchar2 default null
234 ,p_segment13 in varchar2 default null
235 ,p_segment14 in varchar2 default null
236 ,p_segment15 in varchar2 default null
237 ,p_segment16 in varchar2 default null
238 ,p_segment17 in varchar2 default null
239 ,p_segment18 in varchar2 default null
240 ,p_segment19 in varchar2 default null
241 ,p_segment20 in varchar2 default null
242 ,p_segment21 in varchar2 default null
243 ,p_segment22 in varchar2 default null
244 ,p_segment23 in varchar2 default null
245 ,p_segment24 in varchar2 default null
246 ,p_segment25 in varchar2 default null
247 ,p_segment26 in varchar2 default null
248 ,p_segment27 in varchar2 default null
249 ,p_segment28 in varchar2 default null
250 ,p_segment29 in varchar2 default null
251 ,p_segment30 in varchar2 default null
252 ,p_language_code in varchar2 default hr_api.userenv_lang
253 ,p_concat_segments in varchar2 default null
254 ,p_short_name in varchar2 default null
255 ,p_grade_id out nocopy number
256 ,p_object_version_number out nocopy number
257 ,p_grade_definition_id in out nocopy number
258 ,p_name in out nocopy varchar2
259 );
260 --
261 -- ----------------------------------------------------------------------------
262 -- |-------------------------------< update_grade >---------------------------|
263 -- ----------------------------------------------------------------------------
264 --
265 -- {Start Of Comments}
266 /*#
267 * This API updates a grade.
268 *
269 * A component of an employee assignment that defines their level and can be
270 * used to control the value of their salary and other compensation elements.
271 *
272 * <p><b>Licensing</b><br>
273 * This API is licensed for use with Human Resources.
274 *
275 * <p><b>Prerequisites</b><br>
276 * A grade must exist.
277 *
278 * <p><b>Post Success</b><br>
279 * The grade will be updated.
280 *
281 * <p><b>Post Failure</b><br>
282 * The grade is not updated and an error will be raised.
283 * @param p_validate If true, then validation alone will be performed and the
284 * database will remain unchanged. If false and all validation checks pass,
285 * then the database will be modified.
286 * @param p_grade_id Uniquely identifies the grade to be updated.
287 * @param p_sequence Numerical identifier that orders the sequence of grades.
288 * Must be unique within the business group.
289 * @param p_date_from The date on which the grade is active.
290 * @param p_effective_date Reference date for validating lookup values are
291 * applicable during the start to end active date range. This date does not
292 * determine when the changes take effect.
293 * @param p_date_to The date after which the grade is no longer active
294 * @param p_request_id When the API is executed from a concurrent program set
295 * to the concurrent request identifier.
296 * @param p_program_application_id When the API is executed from a concurrent
297 * program set to the program's Application.
298 * @param p_program_id When the API is executed from a concurrent program set
299 * to the program's identifier.
300 * @param p_program_update_date When the API is executed from a concurrent
301 * program set to when the program was ran.
302 * @param p_attribute_category This context value determines which flexfield
303 * structure to use with the descriptive flexfield segments.
304 * @param p_attribute1 Descriptive flexfield segment.
305 * @param p_attribute2 Descriptive flexfield segment.
306 * @param p_attribute3 Descriptive flexfield segment.
307 * @param p_attribute4 Descriptive flexfield segment.
308 * @param p_attribute5 Descriptive flexfield segment.
309 * @param p_attribute6 Descriptive flexfield segment.
310 * @param p_attribute7 Descriptive flexfield segment.
311 * @param p_attribute8 Descriptive flexfield segment.
312 * @param p_attribute9 Descriptive flexfield segment.
313 * @param p_attribute10 Descriptive flexfield segment.
314 * @param p_attribute11 Descriptive flexfield segment.
315 * @param p_attribute12 Descriptive flexfield segment.
316 * @param p_attribute13 Descriptive flexfield segment.
317 * @param p_attribute14 Descriptive flexfield segment.
318 * @param p_attribute15 Descriptive flexfield segment.
319 * @param p_attribute16 Descriptive flexfield segment.
320 * @param p_attribute17 Descriptive flexfield segment.
321 * @param p_attribute18 Descriptive flexfield segment.
322 * @param p_attribute19 Descriptive flexfield segment.
323 * @param p_attribute20 Descriptive flexfield segment.
324 * @param p_information_category This context value determines which flexfield
325 * structure to use with the developer descriptive flexfield segments.
326 * @param p_information1 Developer descriptive flexfield segment.
327 * @param p_information2 Developer descriptive flexfield segment.
328 * @param p_information3 Developer descriptive flexfield segment.
329 * @param p_information4 Developer descriptive flexfield segment.
330 * @param p_information5 Developer descriptive flexfield segment.
331 * @param p_information6 Developer descriptive flexfield segment.
332 * @param p_information7 Developer descriptive flexfield segment.
333 * @param p_information8 Developer descriptive flexfield segment.
334 * @param p_information9 Developer descriptive flexfield segment.
335 * @param p_information10 Developer descriptive flexfield segment.
336 * @param p_information11 Developer descriptive flexfield segment.
337 * @param p_information12 Developer descriptive flexfield segment.
338 * @param p_information13 Developer descriptive flexfield segment.
339 * @param p_information14 Developer descriptive flexfield segment.
340 * @param p_information15 Developer descriptive flexfield segment.
341 * @param p_information16 Developer descriptive flexfield segment.
342 * @param p_information17 Developer descriptive flexfield segment.
343 * @param p_information18 Developer descriptive flexfield segment.
344 * @param p_information19 Developer descriptive flexfield segment.
345 * @param p_information20 Developer descriptive flexfield segment.
346 * @param p_last_update_date The date upon which the record was last updated.
347 * @param p_last_updated_by The system identifier of the user who last updated
348 * the record.
349 * @param p_last_update_login The operating system login of the user who last
350 * updated the record.
351 * @param p_created_by The system identifier of the user who created the
352 * record.
353 * @param p_creation_date The date upon which the record was created.
354 * @param p_segment1 Key flexfield segment.
355 * @param p_segment2 Key flexfield segment.
356 * @param p_segment3 Key flexfield segment.
357 * @param p_segment4 Key flexfield segment.
358 * @param p_segment5 Key flexfield segment.
359 * @param p_segment6 Key flexfield segment.
360 * @param p_segment7 Key flexfield segment.
361 * @param p_segment8 Key flexfield segment.
362 * @param p_segment9 Key flexfield segment.
363 * @param p_segment10 Key flexfield segment.
364 * @param p_segment11 Key flexfield segment.
365 * @param p_segment12 Key flexfield segment.
366 * @param p_segment13 Key flexfield segment.
367 * @param p_segment14 Key flexfield segment.
368 * @param p_segment15 Key flexfield segment.
369 * @param p_segment16 Key flexfield segment.
370 * @param p_segment17 Key flexfield segment.
371 * @param p_segment18 Key flexfield segment.
372 * @param p_segment19 Key flexfield segment.
373 * @param p_segment20 Key flexfield segment.
374 * @param p_segment21 Key flexfield segment.
375 * @param p_segment22 Key flexfield segment.
376 * @param p_segment23 Key flexfield segment.
377 * @param p_segment24 Key flexfield segment.
378 * @param p_segment25 Key flexfield segment.
379 * @param p_segment26 Key flexfield segment.
380 * @param p_segment27 Key flexfield segment.
381 * @param p_segment28 Key flexfield segment.
382 * @param p_segment29 Key flexfield segment.
383 * @param p_segment30 Key flexfield segment.
384 * @param p_language_code Specifies to which language the translation values
385 * apply. You can set to the base or any installed language. The default value
386 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
387 * value.
388 * @param p_short_name Short name for the grade, used in grade step
389 * progression. Has to be unique within the business group.
390 * @param p_concat_segments Alternative to passing in individual key flexfield
391 * segments.
392 * @param p_name If p_validate is false, concatenation of all segments. If
393 * p_validate is true, set to null.
394 * @param p_object_version_number Pass in the current version number of the
395 * grade to be updated. When the API completes if p_validate is false, will be
396 * set to the new version number of the updated grade If p_validate is true
397 * will be set to the same value which was passed in.
398 * @param p_grade_definition_id If p_validate is false, uniquely identifies the
399 * combination of segments passed. If p_validate is true, set to null.
400 * @param p_form_calling Specifies where the API is being called from and perform
401 * action according to it. If p_form_calling is true, update only the grade
402 * definition. If p_form_calling is false then along with grade definition update
403 * call other APIs to update its dependent records.
404 * @rep:displayname Update Grade
405 * @rep:category BUSINESS_ENTITY PER_GRADE
406 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
407 * @rep:scope public
408 * @rep:lifecycle active
409 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
410 */
411 --
412 -- {End Of Comments}
413 --
414 procedure update_grade
415 (P_VALIDATE IN BOOLEAN default false
416 ,P_GRADE_ID IN NUMBER
417 ,P_SEQUENCE IN NUMBER default hr_api.g_number
418 ,P_DATE_FROM IN DATE default hr_api.g_date
419 ,p_effective_date in date default hr_api.g_date
420 ,P_DATE_TO IN DATE default hr_api.g_date
421 ,P_REQUEST_ID IN NUMBER default hr_api.g_number
422 ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
423 ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
424 ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
425 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
426 ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
427 ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
428 ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
429 ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
430 ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
431 ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
432 ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
433 ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
434 ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
435 ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
436 ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
437 ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
438 ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
439 ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
440 ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
441 ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
442 ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
443 ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
444 ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
445 ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
446 ,P_INFORMATION_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
447 ,P_INFORMATION1 IN VARCHAR2 default hr_api.g_varchar2
448 ,P_INFORMATION2 IN VARCHAR2 default hr_api.g_varchar2
449 ,P_INFORMATION3 IN VARCHAR2 default hr_api.g_varchar2
450 ,P_INFORMATION4 IN VARCHAR2 default hr_api.g_varchar2
451 ,P_INFORMATION5 IN VARCHAR2 default hr_api.g_varchar2
452 ,P_INFORMATION6 IN VARCHAR2 default hr_api.g_varchar2
453 ,P_INFORMATION7 IN VARCHAR2 default hr_api.g_varchar2
454 ,P_INFORMATION8 IN VARCHAR2 default hr_api.g_varchar2
455 ,P_INFORMATION9 IN VARCHAR2 default hr_api.g_varchar2
456 ,P_INFORMATION10 IN VARCHAR2 default hr_api.g_varchar2
457 ,P_INFORMATION11 IN VARCHAR2 default hr_api.g_varchar2
458 ,P_INFORMATION12 IN VARCHAR2 default hr_api.g_varchar2
459 ,P_INFORMATION13 IN VARCHAR2 default hr_api.g_varchar2
460 ,P_INFORMATION14 IN VARCHAR2 default hr_api.g_varchar2
461 ,P_INFORMATION15 IN VARCHAR2 default hr_api.g_varchar2
462 ,P_INFORMATION16 IN VARCHAR2 default hr_api.g_varchar2
463 ,P_INFORMATION17 IN VARCHAR2 default hr_api.g_varchar2
464 ,P_INFORMATION18 IN VARCHAR2 default hr_api.g_varchar2
465 ,P_INFORMATION19 IN VARCHAR2 default hr_api.g_varchar2
466 ,P_INFORMATION20 IN VARCHAR2 default hr_api.g_varchar2
467 ,P_LAST_UPDATE_DATE IN DATE default hr_api.g_date
468 ,P_LAST_UPDATED_BY IN NUMBER default hr_api.g_number
469 ,P_LAST_UPDATE_LOGIN IN NUMBER default hr_api.g_number
470 ,P_CREATED_BY IN NUMBER default hr_api.g_number
471 ,P_CREATION_DATE IN DATE default hr_api.g_date
472 ,P_SEGMENT1 IN VARCHAR2 default hr_api.g_varchar2
473 ,P_SEGMENT2 IN VARCHAR2 default hr_api.g_varchar2
474 ,P_SEGMENT3 IN VARCHAR2 default hr_api.g_varchar2
475 ,P_SEGMENT4 IN VARCHAR2 default hr_api.g_varchar2
476 ,P_SEGMENT5 IN VARCHAR2 default hr_api.g_varchar2
477 ,P_SEGMENT6 IN VARCHAR2 default hr_api.g_varchar2
478 ,P_SEGMENT7 IN VARCHAR2 default hr_api.g_varchar2
479 ,P_SEGMENT8 IN VARCHAR2 default hr_api.g_varchar2
480 ,P_SEGMENT9 IN VARCHAR2 default hr_api.g_varchar2
481 ,P_SEGMENT10 IN VARCHAR2 default hr_api.g_varchar2
482 ,P_SEGMENT11 IN VARCHAR2 default hr_api.g_varchar2
483 ,P_SEGMENT12 IN VARCHAR2 default hr_api.g_varchar2
484 ,P_SEGMENT13 IN VARCHAR2 default hr_api.g_varchar2
485 ,P_SEGMENT14 IN VARCHAR2 default hr_api.g_varchar2
486 ,P_SEGMENT15 IN VARCHAR2 default hr_api.g_varchar2
487 ,P_SEGMENT16 IN VARCHAR2 default hr_api.g_varchar2
488 ,P_SEGMENT17 IN VARCHAR2 default hr_api.g_varchar2
489 ,P_SEGMENT18 IN VARCHAR2 default hr_api.g_varchar2
490 ,P_SEGMENT19 IN VARCHAR2 default hr_api.g_varchar2
491 ,P_SEGMENT20 IN VARCHAR2 default hr_api.g_varchar2
492 ,P_SEGMENT21 IN VARCHAR2 default hr_api.g_varchar2
493 ,P_SEGMENT22 IN VARCHAR2 default hr_api.g_varchar2
494 ,P_SEGMENT23 IN VARCHAR2 default hr_api.g_varchar2
495 ,P_SEGMENT24 IN VARCHAR2 default hr_api.g_varchar2
496 ,P_SEGMENT25 IN VARCHAR2 default hr_api.g_varchar2
497 ,P_SEGMENT26 IN VARCHAR2 default hr_api.g_varchar2
498 ,P_SEGMENT27 IN VARCHAR2 default hr_api.g_varchar2
499 ,P_SEGMENT28 IN VARCHAR2 default hr_api.g_varchar2
500 ,P_SEGMENT29 IN VARCHAR2 default hr_api.g_varchar2
501 ,P_SEGMENT30 IN VARCHAR2 default hr_api.g_varchar2
502 ,P_LANGUAGE_CODE IN VARCHAR2 default hr_api.userenv_lang
503 ,P_SHORT_NAME IN VARCHAR2 default hr_api.g_varchar2
504 ,P_CONCAT_SEGMENTS IN OUT NOCOPY VARCHAR2
505 ,P_NAME IN OUT NOCOPY varchar2
506 ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
507 ,P_GRADE_DEFINITION_ID IN OUT NOCOPY NUMBER
508 ,P_FORM_CALLING IN BOOLEAN default false --for bug 6522394
509 );
510 --
511 -- ----------------------------------------------------------------------------
512 -- |-------------------------------< delete_grade >---------------------------|
513 -- ----------------------------------------------------------------------------
514 --
515 -- {Start Of Comments}
516 /*#
517 * This API deletes a grade.
518 *
519 * A component of an employee assignment that defines their level and can be
520 * used to control the value of their salary and other compensation elements.
521 *
522 * <p><b>Licensing</b><br>
523 * This API is licensed for use with Human Resources.
524 *
525 * <p><b>Prerequisites</b><br>
526 * A grade must exist and not be attached to any assignment.
527 *
528 * <p><b>Post Success</b><br>
529 * The grade will be deleted.
530 *
531 * <p><b>Post Failure</b><br>
532 * The grade will not be deleted and en error will be raised.
533 * @param p_validate If true, then validation alone will be performed and the
534 * database will remain unchanged. If false and all validation checks pass,
535 * then the database will be modified.
536 * @param p_grade_id Uniquely identifies the grade to be deleted.
537 * @param p_object_version_number Current version number of the grade to be
538 * deleted.
539 * @rep:displayname Delete Grade
540 * @rep:category BUSINESS_ENTITY PER_GRADE
541 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
542 * @rep:scope public
543 * @rep:lifecycle active
544 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
545 */
546 --
547 -- {End Of Comments}
548 --
549 procedure delete_grade
550 (p_validate in boolean default false
551 ,p_grade_id in number
552 ,p_object_version_number in out nocopy number);
553
554 --
555 end hr_grade_api;
556 --