1 Package hr_job_api AUTHID CURRENT_USER as
2 /* $Header: pejobapi.pkh 120.1 2005/10/02 02:18:12 aroussel $ */
3 /*#
4 * This package contains APIs for maintaining job details.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Job
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------------< create_job >----------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a job in the specified business group.
17 *
18 *
19 * <p><b>Licensing</b><br>
20 * This API is licensed for use with Human Resources and HR Foundation.
21 *
22 * <p><b>Prerequisites</b><br>
23 * At least one segment of the job key flexfield must have a value.
24 *
25 * <p><b>Post Success</b><br>
26 * The API creates the job.
27 *
28 * <p><b>Post Failure</b><br>
29 * The API does not create the job and raises an error.
30 * @param p_validate If true, then validation alone will be performed and the
31 * database will remain unchanged. If false and all validation checks pass,
32 * then the database will be modified.
33 * @param p_business_group_id Business group in which the job is to be created.
34 * @param p_date_from The date on which the job becomes active.
35 * @param p_comments Comment text.
36 * @param p_date_to The date on which the job ceases to be active.
37 * @param p_approval_authority Indicates if job has approval authority.
38 * @param p_benchmark_job_flag Value 'Y' indicates that the job is a benchmark
39 * job
40 * @param p_benchmark_job_id Unique identifier for the benchmark job
41 * @param p_emp_rights_flag Value 'Y' indicates that there are extended
42 * employment rights associated with this job.
43 * @param p_job_group_id Identifies the job group with which the job is to be
44 * associated.
45 * @param p_attribute_category This context value determines which flexfield
46 * structure to use with the descriptive flexfield segments.
47 * @param p_attribute1 Descriptive flexfield segment.
48 * @param p_attribute2 Descriptive flexfield segment.
49 * @param p_attribute3 Descriptive flexfield segment.
50 * @param p_attribute4 Descriptive flexfield segment.
51 * @param p_attribute5 Descriptive flexfield segment.
52 * @param p_attribute6 Descriptive flexfield segment.
53 * @param p_attribute7 Descriptive flexfield segment.
54 * @param p_attribute8 Descriptive flexfield segment.
55 * @param p_attribute9 Descriptive flexfield segment.
56 * @param p_attribute10 Descriptive flexfield segment.
57 * @param p_attribute11 Descriptive flexfield segment.
58 * @param p_attribute12 Descriptive flexfield segment.
59 * @param p_attribute13 Descriptive flexfield segment.
60 * @param p_attribute14 Descriptive flexfield segment.
61 * @param p_attribute15 Descriptive flexfield segment.
62 * @param p_attribute16 Descriptive flexfield segment.
63 * @param p_attribute17 Descriptive flexfield segment.
64 * @param p_attribute18 Descriptive flexfield segment.
65 * @param p_attribute19 Descriptive flexfield segment.
66 * @param p_attribute20 Descriptive flexfield segment.
67 * @param p_job_information_category This context value determines which
68 * Flexfield Structure to use with the Developer Descriptive flexfield
69 * segments.
70 * @param p_job_information1 Developer Descriptive flexfield segment.
71 * @param p_job_information2 Developer Descriptive flexfield segment.
72 * @param p_job_information3 Developer Descriptive flexfield segment.
73 * @param p_job_information4 Developer Descriptive flexfield segment.
74 * @param p_job_information5 Developer Descriptive flexfield segment.
75 * @param p_job_information6 Developer Descriptive flexfield segment.
76 * @param p_job_information7 Developer Descriptive flexfield segment.
77 * @param p_job_information8 Developer Descriptive flexfield segment.
78 * @param p_job_information9 Developer Descriptive flexfield segment.
79 * @param p_job_information10 Developer Descriptive flexfield segment.
80 * @param p_job_information11 Developer Descriptive flexfield segment.
81 * @param p_job_information12 Developer Descriptive flexfield segment.
82 * @param p_job_information13 Developer Descriptive flexfield segment.
83 * @param p_job_information14 Developer Descriptive flexfield segment.
84 * @param p_job_information15 Developer Descriptive flexfield segment.
85 * @param p_job_information16 Developer Descriptive flexfield segment.
86 * @param p_job_information17 Developer Descriptive flexfield segment.
87 * @param p_job_information18 Developer Descriptive flexfield segment.
88 * @param p_job_information19 Developer Descriptive flexfield segment.
89 * @param p_job_information20 Developer Descriptive flexfield segment.
90 * @param p_segment1 Job Key flexfield segment.
91 * @param p_segment2 Job Key flexfield segment.
92 * @param p_segment3 Job Key flexfield segment.
93 * @param p_segment4 Job Key flexfield segment.
94 * @param p_segment5 Job Key flexfield segment.
95 * @param p_segment6 Job Key flexfield segment.
96 * @param p_segment7 Job Key flexfield segment.
97 * @param p_segment8 Job Key flexfield segment.
98 * @param p_segment9 Job Key flexfield segment.
99 * @param p_segment10 Job Key flexfield segment.
100 * @param p_segment11 Job Key flexfield segment.
101 * @param p_segment12 Job Key flexfield segment.
102 * @param p_segment13 Job Key flexfield segment.
103 * @param p_segment14 Job Key flexfield segment.
104 * @param p_segment15 Job Key flexfield segment.
105 * @param p_segment16 Job Key flexfield segment.
106 * @param p_segment17 Job Key flexfield segment.
107 * @param p_segment18 Job Key flexfield segment.
108 * @param p_segment19 Job Key flexfield segment.
109 * @param p_segment20 Job Key flexfield segment.
110 * @param p_segment21 Job Key flexfield segment.
111 * @param p_segment22 Job Key flexfield segment.
112 * @param p_segment23 Job Key flexfield segment.
113 * @param p_segment24 Job Key flexfield segment.
114 * @param p_segment25 Job Key flexfield segment.
115 * @param p_segment26 Job Key flexfield segment.
116 * @param p_segment27 Job Key flexfield segment.
117 * @param p_segment28 Job Key flexfield segment.
118 * @param p_segment29 Job Key flexfield segment.
119 * @param p_segment30 Job Key flexfield segment.
120 * @param p_concat_segments Concatenated segments for the Job Key Flexfield.
121 * @param p_language_code Specifies to which language the translation values
122 * apply. You can set to the base or any installed language. The default value
123 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
124 * value.
125 * @param p_job_id If p_validate is false, uniquely identifies the job created.
126 * If p_validate is true, set to null.
127 * @param p_object_version_number If p_validate is false, then set to the
128 * version number of the created job. If p_validate is true, then the value
129 * will be null.
130 * @param p_job_definition_id If p_validate is false, uniquely identifies the
131 * Job Key flexfield combination for this job. If p_validate is true, set to
132 * null.
133 * @param p_name If p_validate is false, concatenation of all key flexfield
134 * segments. If p_validate is true, set to null.
135 * @rep:displayname Create Job
136 * @rep:category BUSINESS_ENTITY PER_JOB
137 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
138 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
139 * @rep:scope public
140 * @rep:lifecycle active
141 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
142 */
143 --
144 -- {End Of Comments}
145 --
146 procedure create_job
147 (p_validate in boolean default false
148 ,p_business_group_id in number
149 ,p_date_from in date
150 ,p_comments in varchar2 default null
151 ,p_date_to in date default null
152 ,p_approval_authority in number default null
153 ,p_benchmark_job_flag in varchar2 default 'N'
154 ,p_benchmark_job_id in number default null
155 ,p_emp_rights_flag in varchar2 default 'N'
156 ,p_job_group_id in number
157 ,p_attribute_category in varchar2 default null
158 ,p_attribute1 in varchar2 default null
159 ,p_attribute2 in varchar2 default null
160 ,p_attribute3 in varchar2 default null
161 ,p_attribute4 in varchar2 default null
162 ,p_attribute5 in varchar2 default null
163 ,p_attribute6 in varchar2 default null
164 ,p_attribute7 in varchar2 default null
165 ,p_attribute8 in varchar2 default null
166 ,p_attribute9 in varchar2 default null
167 ,p_attribute10 in varchar2 default null
168 ,p_attribute11 in varchar2 default null
169 ,p_attribute12 in varchar2 default null
170 ,p_attribute13 in varchar2 default null
171 ,p_attribute14 in varchar2 default null
172 ,p_attribute15 in varchar2 default null
173 ,p_attribute16 in varchar2 default null
174 ,p_attribute17 in varchar2 default null
175 ,p_attribute18 in varchar2 default null
176 ,p_attribute19 in varchar2 default null
177 ,p_attribute20 in varchar2 default null
178 ,p_job_information_category in varchar2 default null
179 ,p_job_information1 in varchar2 default null
180 ,p_job_information2 in varchar2 default null
181 ,p_job_information3 in varchar2 default null
182 ,p_job_information4 in varchar2 default null
183 ,p_job_information5 in varchar2 default null
184 ,p_job_information6 in varchar2 default null
185 ,p_job_information7 in varchar2 default null
186 ,p_job_information8 in varchar2 default null
187 ,p_job_information9 in varchar2 default null
188 ,p_job_information10 in varchar2 default null
189 ,p_job_information11 in varchar2 default null
190 ,p_job_information12 in varchar2 default null
191 ,p_job_information13 in varchar2 default null
192 ,p_job_information14 in varchar2 default null
193 ,p_job_information15 in varchar2 default null
194 ,p_job_information16 in varchar2 default null
195 ,p_job_information17 in varchar2 default null
196 ,p_job_information18 in varchar2 default null
197 ,p_job_information19 in varchar2 default null
198 ,p_job_information20 in varchar2 default null
199 ,p_segment1 in varchar2 default null
200 ,p_segment2 in varchar2 default null
201 ,p_segment3 in varchar2 default null
202 ,p_segment4 in varchar2 default null
203 ,p_segment5 in varchar2 default null
204 ,p_segment6 in varchar2 default null
205 ,p_segment7 in varchar2 default null
206 ,p_segment8 in varchar2 default null
207 ,p_segment9 in varchar2 default null
208 ,p_segment10 in varchar2 default null
209 ,p_segment11 in varchar2 default null
210 ,p_segment12 in varchar2 default null
211 ,p_segment13 in varchar2 default null
212 ,p_segment14 in varchar2 default null
213 ,p_segment15 in varchar2 default null
214 ,p_segment16 in varchar2 default null
215 ,p_segment17 in varchar2 default null
216 ,p_segment18 in varchar2 default null
217 ,p_segment19 in varchar2 default null
218 ,p_segment20 in varchar2 default null
219 ,p_segment21 in varchar2 default null
220 ,p_segment22 in varchar2 default null
221 ,p_segment23 in varchar2 default null
222 ,p_segment24 in varchar2 default null
223 ,p_segment25 in varchar2 default null
224 ,p_segment26 in varchar2 default null
225 ,p_segment27 in varchar2 default null
226 ,p_segment28 in varchar2 default null
227 ,p_segment29 in varchar2 default null
228 ,p_segment30 in varchar2 default null
229 ,p_concat_segments in varchar2 default null
230 ,p_language_code in varchar2 default hr_api.userenv_lang
231 ,p_job_id out nocopy number
232 ,p_object_version_number out nocopy number
233 ,p_job_definition_id in out nocopy number
234 ,p_name out nocopy varchar2
235 );
236 --
237 -- ----------------------------------------------------------------------------
238 -- |-----------------------------< update_job >--------------------------------
239 -- ----------------------------------------------------------------------------
240 -- {Start Of Comments}
241 --
242 -- Description:
243 -- This API updates a job as identified by the in parameter
244 -- p_job_id and the in out parameter p_object_version_number.
245 --
246 --
247 -- Prerequisites:
248 -- The job as identified by the in parameter p_job_id and the in
249 -- out parameter p_object_version_number must already exist.
250 --
251 --
252 -- In Parameters:
253 -- Name Reqd Type Description
254 -- p_validate No boolean If true, the database
255 -- remains unchanged. If false,
256 -- the job is updated.
257 -- p_job_id Yes number The primary key of the
258 -- job.
259 -- p_object_version_number Yes number The current version of the
260 -- job to be updated.
261 -- p_date_from No date Start date of job
262 -- p_comments No varchar2 Comments
263 -- p_date_to No date The end date of the job.
264 -- p_benchmark_job_flag No varchar2 Flag to indicate whether
265 -- the job is a benchmark job.
266 -- p_benchmark_job_id No number ID of the benchmark job.
267 -- p_emp_rights_flag No varchar2 Flag to indicate whether
268 -- there are extended
269 -- employment rights
270 -- associated with this job.
271 -- p_attribute_category No varchar2 Determines context of the
272 -- attribute Descriptive
273 -- flexfield in parameters.
274 -- p_attribute1 No varchar2 Descriptive flexfield.
275 -- p_attribute2 No varchar2 Descriptive flexfield.
276 -- p_attribute3 No varchar2 Descriptive flexfield.
277 -- p_attribute4 No varchar2 Descriptive flexfield.
278 -- p_attribute5 No varchar2 Descriptive flexfield.
279 -- p_attribute6 No varchar2 Descriptive flexfield.
280 -- p_attribute7 No varchar2 Descriptive flexfield.
281 -- p_attribute8 No varchar2 Descriptive flexfield.
282 -- p_attribute9 No varchar2 Descriptive flexfield.
283 -- p_attribute10 No varchar2 Descriptive flexfield.
284 -- p_attribute11 No varchar2 Descriptive flexfield.
285 -- p_attribute12 No varchar2 Descriptive flexfield.
286 -- p_attribute13 No varchar2 Descriptive flexfield.
287 -- p_attribute14 No varchar2 Descriptive flexfield.
288 -- p_attribute15 No varchar2 Descriptive flexfield.
289 -- p_attribute16 No varchar2 Descriptive flexfield.
290 -- p_attribute17 No varchar2 Descriptive flexfield.
291 -- p_attribute18 No varchar2 Descriptive flexfield.
292 -- p_attribute19 No varchar2 Descriptive flexfield.
293 -- p_attribute20 No varchar2 Descriptive flexfield.
294 -- p_job_information_category No varchar2 Developer descriptive flexfield
295 -- p_job_information1 No varchar2 Developer descriptive flexfield
296 -- p_job_information2 No varchar2 Developer descriptive flexfield
297 -- p_job_information3 No varchar2 Developer descriptive flexfield
298 -- p_job_information4 No varchar2 Developer descriptive flexfield
299 -- p_job_information5 No varchar2 Developer descriptive flexfield
300 -- p_job_information6 No varchar2 Developer descriptive flexfield
301 -- p_job_information7 No varchar2 Developer descriptive flexfield
302 -- p_job_information8 No varchar2 Developer descriptive flexfield
303 -- p_job_information9 No varchar2 Developer descriptive flexfield
304 -- p_job_information10 No varchar2 Developer descriptive flexfield
305 -- p_job_information11 No varchar2 Developer descriptive flexfield
306 -- p_job_information12 No varchar2 Developer descriptive flexfield
307 -- p_job_information13 No varchar2 Developer descriptive flexfield
308 -- p_job_information14 No varchar2 Developer descriptive flexfield
309 -- p_job_information15 No varchar2 Developer descriptive flexfield
310 -- p_job_information16 No varchar2 Developer descriptive flexfield
311 -- p_job_information17 No varchar2 Developer descriptive flexfield
312 -- p_job_information18 No varchar2 Developer descriptive flexfield
313 -- p_job_information19 No varchar2 Developer descriptive flexfield
314 -- p_job_information20 No varchar2 Developer descriptive flexfield
315 -- p_segment1 No varchar2 For the Job key flexfield
316 -- p_segment2 No varchar2 For the Job key flexfield
317 -- p_segment3 No varchar2 For the Job key flexfield
318 -- p_segment4 No varchar2 For the Job key flexfield
319 -- p_segment5 No varchar2 For the Job key flexfield
320 -- p_segment6 No varchar2 For the Job key flexfield
321 -- p_segment7 No varchar2 For the Job key flexfield
322 -- p_segment8 No varchar2 For the Job key flexfield
323 -- p_segment9 No varchar2 For the Job key flexfield
324 -- p_segment10 No varchar2 For the Job key flexfield
325 -- p_segment11 No varchar2 For the Job key flexfield
326 -- p_segment12 No varchar2 For the Job key flexfield
327 -- p_segment13 No varchar2 For the Job key flexfield
328 -- p_segment14 No varchar2 For the Job key flexfield
329 -- p_segment15 No varchar2 For the Job key flexfield
330 -- p_segment16 No varchar2 For the Job key flexfield
331 -- p_segment17 No varchar2 For the Job key flexfield
332 -- p_segment18 No varchar2 For the Job key flexfield
333 -- p_segment19 No varchar2 For the Job key flexfield
334 -- p_segment20 No varchar2 For the Job key flexfield
335 -- p_segment21 No varchar2 For the Job key flexfield
336 -- p_segment22 No varchar2 For the Job key flexfield
337 -- p_segment23 No varchar2 For the Job key flexfield
338 -- p_segment24 No varchar2 For the Job key flexfield
339 -- p_segment25 No varchar2 For the Job key flexfield
340 -- p_segment26 No varchar2 For the Job key flexfield
341 -- p_segment27 No varchar2 For the Job key flexfield
342 -- p_segment28 No varchar2 For the Job key flexfield
343 -- p_segment29 No varchar2 For the Job key flexfield
344 -- p_segment30 No varchar2 For the Job key flexfield
345 -- p_language_code No varchar2 The current language
346 -- p_effective_date Yes date Effective date
347 -- Post Success:
348 -- When the job is valid, the API updates the job and sets the
349 -- following out parameters.
350 --
351 -- Name Type Description
352 -- p_object_version_number number If p_validate is false, set to
353 -- the version number of this
354 -- job. If p_validate is true,
355 -- set to null.
356 -- p_job_definition_id number Set to the code combination ID of
357 -- the Job key flexfield.
358 -- p_name varchar2 Set to the concatenated segments
359 -- as on the per_job_definitions
360 -- table.
361 -- p_valid_grade_changed_warning boolean Set to true when either the
362 -- job date to or date
363 -- from has been modified and at
364 -- least one valid grade has been
365 -- updated or deleted. Set to false
366 -- when neither the job date
367 -- from or date to has been
368 -- modified, or, either of them has
369 -- been modified but no valid grades
370 -- were altered.
371 --
372 -- Post Failure:
373 -- The API does not update the job and raises an error.
374 --
375 -- Access Status:
376 -- Public.
377 --
378 -- {End Of Comments}
379 --
380 -- ----------------------------------------------------------------------------
381 procedure update_job
382 (p_validate in boolean default false
383 ,p_job_id in number
384 ,p_object_version_number in out nocopy number
385 ,p_date_from in date default hr_api.g_date
386 ,p_comments in varchar2 default hr_api.g_varchar2
387 ,p_date_to in date default hr_api.g_date
388 ,p_benchmark_job_flag in varchar2 default hr_api.g_varchar2
389 ,p_benchmark_job_id in number default hr_api.g_number
390 ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
391 ,p_attribute_category in varchar2 default hr_api.g_varchar2
392 ,p_attribute1 in varchar2 default hr_api.g_varchar2
393 ,p_attribute2 in varchar2 default hr_api.g_varchar2
394 ,p_attribute3 in varchar2 default hr_api.g_varchar2
395 ,p_attribute4 in varchar2 default hr_api.g_varchar2
396 ,p_attribute5 in varchar2 default hr_api.g_varchar2
397 ,p_attribute6 in varchar2 default hr_api.g_varchar2
398 ,p_attribute7 in varchar2 default hr_api.g_varchar2
399 ,p_attribute8 in varchar2 default hr_api.g_varchar2
400 ,p_attribute9 in varchar2 default hr_api.g_varchar2
401 ,p_attribute10 in varchar2 default hr_api.g_varchar2
402 ,p_attribute11 in varchar2 default hr_api.g_varchar2
403 ,p_attribute12 in varchar2 default hr_api.g_varchar2
404 ,p_attribute13 in varchar2 default hr_api.g_varchar2
405 ,p_attribute14 in varchar2 default hr_api.g_varchar2
406 ,p_attribute15 in varchar2 default hr_api.g_varchar2
407 ,p_attribute16 in varchar2 default hr_api.g_varchar2
408 ,p_attribute17 in varchar2 default hr_api.g_varchar2
409 ,p_attribute18 in varchar2 default hr_api.g_varchar2
410 ,p_attribute19 in varchar2 default hr_api.g_varchar2
411 ,p_attribute20 in varchar2 default hr_api.g_varchar2
412 ,p_job_information_category in varchar2 default hr_api.g_varchar2
413 ,p_job_information1 in varchar2 default hr_api.g_varchar2
414 ,p_job_information2 in varchar2 default hr_api.g_varchar2
415 ,p_job_information3 in varchar2 default hr_api.g_varchar2
416 ,p_job_information4 in varchar2 default hr_api.g_varchar2
417 ,p_job_information5 in varchar2 default hr_api.g_varchar2
418 ,p_job_information6 in varchar2 default hr_api.g_varchar2
419 ,p_job_information7 in varchar2 default hr_api.g_varchar2
420 ,p_job_information8 in varchar2 default hr_api.g_varchar2
421 ,p_job_information9 in varchar2 default hr_api.g_varchar2
422 ,p_job_information10 in varchar2 default hr_api.g_varchar2
423 ,p_job_information11 in varchar2 default hr_api.g_varchar2
424 ,p_job_information12 in varchar2 default hr_api.g_varchar2
425 ,p_job_information13 in varchar2 default hr_api.g_varchar2
426 ,p_job_information14 in varchar2 default hr_api.g_varchar2
427 ,p_job_information15 in varchar2 default hr_api.g_varchar2
428 ,p_job_information16 in varchar2 default hr_api.g_varchar2
429 ,p_job_information17 in varchar2 default hr_api.g_varchar2
430 ,p_job_information18 in varchar2 default hr_api.g_varchar2
431 ,p_job_information19 in varchar2 default hr_api.g_varchar2
432 ,p_job_information20 in varchar2 default hr_api.g_varchar2
433 ,p_segment1 in varchar2 default hr_api.g_varchar2
434 ,p_segment2 in varchar2 default hr_api.g_varchar2
435 ,p_segment3 in varchar2 default hr_api.g_varchar2
436 ,p_segment4 in varchar2 default hr_api.g_varchar2
437 ,p_segment5 in varchar2 default hr_api.g_varchar2
438 ,p_segment6 in varchar2 default hr_api.g_varchar2
439 ,p_segment7 in varchar2 default hr_api.g_varchar2
440 ,p_segment8 in varchar2 default hr_api.g_varchar2
441 ,p_segment9 in varchar2 default hr_api.g_varchar2
442 ,p_segment10 in varchar2 default hr_api.g_varchar2
443 ,p_segment11 in varchar2 default hr_api.g_varchar2
444 ,p_segment12 in varchar2 default hr_api.g_varchar2
445 ,p_segment13 in varchar2 default hr_api.g_varchar2
446 ,p_segment14 in varchar2 default hr_api.g_varchar2
447 ,p_segment15 in varchar2 default hr_api.g_varchar2
448 ,p_segment16 in varchar2 default hr_api.g_varchar2
449 ,p_segment17 in varchar2 default hr_api.g_varchar2
450 ,p_segment18 in varchar2 default hr_api.g_varchar2
451 ,p_segment19 in varchar2 default hr_api.g_varchar2
452 ,p_segment20 in varchar2 default hr_api.g_varchar2
453 ,p_segment21 in varchar2 default hr_api.g_varchar2
454 ,p_segment22 in varchar2 default hr_api.g_varchar2
455 ,p_segment23 in varchar2 default hr_api.g_varchar2
456 ,p_segment24 in varchar2 default hr_api.g_varchar2
457 ,p_segment25 in varchar2 default hr_api.g_varchar2
458 ,p_segment26 in varchar2 default hr_api.g_varchar2
459 ,p_segment27 in varchar2 default hr_api.g_varchar2
460 ,p_segment28 in varchar2 default hr_api.g_varchar2
461 ,p_segment29 in varchar2 default hr_api.g_varchar2
462 ,p_segment30 in varchar2 default hr_api.g_varchar2
463 ,p_concat_segments in varchar2 default hr_api.g_varchar2
464 ,p_approval_authority in number default hr_api.g_number
465 ,p_language_code in varchar2 default hr_api.userenv_lang
466 ,p_job_definition_id in out nocopy number
467 ,p_name out nocopy varchar2
468 ,p_valid_grades_changed_warning out nocopy boolean
469 ,p_effective_date in date default hr_api.g_date --Added for bug# 1760707
470 );
471
472 -- ------------------------------------------------------------------------+
473 -- |-----------------------------< delete_job >----------------------------|
474 -- ------------------------------------------------------------------------+
475 -- {Start Of Comments}
476 --
477 -- Description:
478 -- This API deletes a job as identified by the in parameter
479 -- p_job_id and the in out parameter p_object_version_number.
480 --
481 -- Pre Conditions:
482 -- The job as identified by the in parameter p_job_id and the in
483 -- out parameter p_object_version_number must already exist.
484 --
485 -- In Arguments:
486 -- Name Reqd Type Description
487 -- p_validate No boolean If true, the database
488 -- remains unchanged. If false,
489 -- the job is updated.
490 -- p_job_id Yes number The primary key of the
491 -- job.
492 -- p_object_version_number Yes number The current version of the
493 -- job to be updated.
494 --
495 -- Post Success:
496 -- Job is deleted
497 --
498 -- Post Failure:
499 -- The API does not delete the job and raises an error.
500 --
501 -- Access Status:
502 -- Public.
503 --
504 -- {End Of Comments}
505 --
506 ----------------------------------------------------------------------------
507 procedure delete_job
508 (p_validate in boolean default false
509 ,p_job_id in number
510 ,p_object_version_number in out nocopy number);
511
512 --
513
514 -- ------------------------------------------------------------------------+
515 -- |-----------------------------< get_next_sequence >---------------------|
516 -- ------------------------------------------------------------------------+
517 -- {Start Of Comments}
518 --
519 -- Description:
520 -- This procedure will get the next available sequence number from
521 -- per_jobs_s
522 --
523 -- Pre Conditions:
524 -- Sequence must be existing
525 --
526 -- In Arguments:
527 -- p_job_id
528 --
529 -- Post Success:
530 -- Next available sequence will be returned
531 --
532 -- Post Failure:
533 -- None
534 --
535 -- Access Status:
536 -- Public.
537 --
538 -- {End Of Comments}
539 --
540 ----------------------------------------------------------------------------
541 procedure get_next_sequence(p_job_id IN OUT NOCOPY NUMBER);
542 --
543 -- ------------------------------------------------------------------------+
544 -- |-----------------------------< get_job_flex_structure >----------------|
545 -- ------------------------------------------------------------------------+
546 -- {Start Of Comments}
547 --
548 -- Description:
549 -- This procedure will return job_flex_structure_id for a given job
550 --
551 -- Pre Conditions:
552 -- A valid job must be existing
553 --
554 -- In Arguments:
555 -- p_job_id
556 -- p_structure_defining_column
557 --
558 -- Post Success:
559 -- Will return job_flex_structure_id for the given job
560 --
561 -- Post Failure:
562 -- None
563 --
564 -- Access Status:
565 -- Public.
566 --
567 -- {End Of Comments}
568 --
569 ----------------------------------------------------------------------------
570 procedure get_job_flex_structure(
571 p_structure_defining_column in out nocopy varchar2,
572 p_job_group_id in number);
573 --
574 -- ----------------------------------------------------------------------------
575 -- |---------------------------< update_valid_grades >------------------------|
576 -- ----------------------------------------------------------------------------
577 --
578 -- {Start Of Comments}
579 /*#
580 * This procedure updates the valid grades for a given job.
581 *
582 * Update valid grade end dates to match the job end date, where the job end
583 * date is earlier than the grade end date or the previous end dates matched.
584 *
585 * <p><b>Licensing</b><br>
586 * This API is licensed for use with Human Resources.
587 *
588 * <p><b>Prerequisites</b><br>
589 * Atleast one valid grade must exist for the given job.
590 *
591 * <p><b>Post Success</b><br>
592 * Will update the valid grades end dates.
593 *
594 * <p><b>Post Failure</b><br>
595 * An error will be raised, and an appropriate message will be shown to the
596 * user.
597 *
598 * @param p_business_group_id Identifies the business group in which the valid
599 * grades exist.
600 * @param p_job_id Identifies the job for which you are updating the valid
601 * grades.
602 * @param p_date_to End date to set for the valid grades.
603 * @param p_end_of_time If the parameter p_date_to is passed as null, a date
604 * well in future should be set as the end date for valid grades.
605 * @rep:displayname Update Valid Grades
606 * @rep:category BUSINESS_ENTITY PER_JOB
607 * @rep:lifecycle active
608 * @rep:scope public
609 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
610 */
611 --
612 -- {End Of Comments}
613 --
614 procedure update_valid_grades(p_business_group_id number,
615 p_job_id number,
616 p_date_to date,
617 p_end_of_time date);
618 --
619 -- ----------------------------------------------------------------------------
620 -- |---------------------------< delete_valid_grades >------------------------|
621 -- ----------------------------------------------------------------------------
622 --
623 -- {Start Of Comments}
624 /*#
625 * This procedure deletes the valid grades.
626 *
627 * Valid grades are deleted if the end date of the job has been made earlier
628 * than the start date of the valid grade.
629 *
630 * <p><b>Licensing</b><br>
631 * This API is licensed for use with Human Resources.
632 *
633 * <p><b>Prerequisites</b><br>
634 * A valid grade must exist for the given job.
635 *
636 * <p><b>Post Success</b><br>
637 * Valid grades will be deleted based on the end date of the job.
638 *
639 * <p><b>Post Failure</b><br>
640 * An error will be raised, and an appropriate message will be shown to the
641 * user.
642 *
643 * @param p_business_group_id Identifies the business group in which valid
644 * grades exist.
645 * @param p_job_id Identifies the job for which you are deleting the valid
646 * grades.
647 * @param p_date_to Date after which the valid grades are deleted.
648 * @rep:displayname Delete Valid Grades
649 * @rep:category BUSINESS_ENTITY PER_JOB
650 * @rep:lifecycle active
651 * @rep:scope public
652 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
653 */
654 --
655 -- {End Of Comments}
656 --
657 procedure delete_valid_grades(p_business_group_id number,
658 p_job_id number,
659 p_date_to date);
660 --
661 end hr_job_api;