1 Package hr_previous_employment_api AUTHID CURRENT_USER as
2 /* $Header: pepemapi.pkh 120.1.12010000.1 2008/07/28 05:11:13 appldev ship $ */
3 /*#
4 * This package contains APIs that maintain previous employment information for
5 * an employee.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Previous Employment
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-------------------------< create_previous_employer >---------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates new previous employer details.
18 *
19 * Details can include the previous employer's name, address, and type of
20 * industry. You can specify how long a person worked for the previous
21 * employer, and the associated start and end dates. With public sector
22 * industries in particular, rules associated with previous employment details
23 * can affect multiple assignments, such as determining the speed in which
24 * employees move up a grade scale.
25 *
26 * <p><b>Licensing</b><br>
27 * This API is licensed for use with Human Resources.
28 *
29 * <p><b>Prerequisites</b><br>
30 * A person must exist before a period of previous employment can be entered.
31 * Previous employment can be recorded for all person types except people of
32 * person type 'OTHER'.
33 *
34 * <p><b>Post Success</b><br>
35 * The previous employer record will be created.
36 *
37 * <p><b>Post Failure</b><br>
38 * The previous employer record will not be created and an error will be
39 * raised.
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_validate If true, then validation alone will be performed and the
44 * database will remain unchanged. If false and all validation checks pass,
45 * then the database will be modified.
46 * @param p_business_group_id Uniquely identifies the business group in which
47 * the previous employer record is created. It must be the same as the person's
48 * own business group.
49 * @param p_person_id Uniquely identifies the person for whom the previous
50 * employer record is created. The person type cannot be 'OTHER'.
51 * @param p_party_id Uniquely identiies employer information for a party, so
52 * that users can see the information for all instances of the person in
53 * different business groups.
54 * @param p_start_date The start date of the employee's previous employment.
55 * @param p_end_date The end date of the employee's previous employment.
56 * @param p_period_years The number of years the employee worked with the
57 * previous employer. If left null, the process calculates this based on the
58 * start date and end date. For example, if the start date is '01-JAN-2000' and
59 * the end date is '05-MAR-2004', the process sets four years.
60 * @param p_period_months The number of months the employee worked over and
61 * above the years worked. If left null, the process calculates this from the
62 * start and end date. For example, if the start date is '01-JAN-2000' and the
63 * end date is '05-MAR-2004', the the process sets two months.
64 * @param p_period_days The number of days worked over and above the years and
65 * months worked. If left null, the process calculatese this from the start and
66 * end date. For example, if the start date is '01-JAN-2000' and the end date
67 * is '05-MAR-2004', the process sets five days.
68 * @param p_employer_name The name of the previous employer
69 * @param p_employer_country The country in which the previous employer is
70 * located. For global previous employers, set to the country in which the
71 * company headquarters is located or the country in which the employment took
72 * place.
73 * @param p_employer_address The address of the previous employer.
74 * @param p_employer_type Type of previous employer. Valid values for this
75 * field are defined by the lookup type 'PREV_EMP_TYPE'. Values your enterprise
76 * defines for this lookup type should be high level, vertical descriptions for
77 * the industry, for example, 'Public Sector', 'Manufacturing', etc.
78 * @param p_employer_subtype The subtype of the previous employer. Valid values
79 * for this field are defined by the lookup type 'PREV_EMP_SUBTYPE'. Values
80 * your enterprise defines for this lookup type should identify the employer
81 * type more specifically. For example, for the employer type of 'Public
82 * Sector', you can define subtypes such as 'Civil Service', 'Teaching', or
83 * 'Health Care'.
84 * @param p_description Description of the previous employer.
85 * @param p_all_assignments Set to 'Y' if the previous employment applies to
86 * all of the employee's assignments. Otherwise set to 'N'. In order to create
87 * previous job usage records (using the create_previous_job_usage API), set
88 * this flag to 'N'.
89 * @param p_pem_attribute_category Descriptive flexfield structure defining
90 * column.
91 * @param p_pem_attribute1 Descriptive flexfield column
92 * @param p_pem_attribute2 Descriptive flexfield column
93 * @param p_pem_attribute3 Descriptive flexfield column
94 * @param p_pem_attribute4 Descriptive flexfield column
95 * @param p_pem_attribute5 Descriptive flexfield column
96 * @param p_pem_attribute6 Descriptive flexfield column
97 * @param p_pem_attribute7 Descriptive flexfield column
98 * @param p_pem_attribute8 Descriptive flexfield column
99 * @param p_pem_attribute9 Descriptive flexfield column
100 * @param p_pem_attribute10 Descriptive flexfield column
101 * @param p_pem_attribute11 Descriptive flexfield column
102 * @param p_pem_attribute12 Descriptive flexfield column
103 * @param p_pem_attribute13 Descriptive flexfield column
104 * @param p_pem_attribute14 Descriptive flexfield column
105 * @param p_pem_attribute15 Descriptive flexfield column
106 * @param p_pem_attribute16 Descriptive flexfield column
107 * @param p_pem_attribute17 Descriptive flexfield column
108 * @param p_pem_attribute18 Descriptive flexfield column
109 * @param p_pem_attribute19 Descriptive flexfield column
110 * @param p_pem_attribute20 Descriptive flexfield column
111 * @param p_pem_attribute21 Descriptive flexfield column
112 * @param p_pem_attribute22 Descriptive flexfield column
113 * @param p_pem_attribute23 Descriptive flexfield column
114 * @param p_pem_attribute24 Descriptive flexfield column
115 * @param p_pem_attribute25 Descriptive flexfield column
116 * @param p_pem_attribute26 Descriptive flexfield column
117 * @param p_pem_attribute27 Descriptive flexfield column
118 * @param p_pem_attribute28 Descriptive flexfield column
119 * @param p_pem_attribute29 Descriptive flexfield column
120 * @param p_pem_attribute30 Descriptive flexfield column
121 * @param p_pem_information_category Developer Descriptive flexfield defining
122 * column
123 * @param p_pem_information1 Developer Descriptive flexfield defining column
124 * @param p_pem_information2 Developer Descriptive flexfield defining column
125 * @param p_pem_information3 Developer Descriptive flexfield defining column
126 * @param p_pem_information4 Developer Descriptive flexfield defining column
127 * @param p_pem_information5 Developer Descriptive flexfield defining column
128 * @param p_pem_information6 Developer Descriptive flexfield defining column
129 * @param p_pem_information7 Developer Descriptive flexfield defining column
130 * @param p_pem_information8 Developer Descriptive flexfield defining column
131 * @param p_pem_information9 Developer Descriptive flexfield defining column
132 * @param p_pem_information10 Developer Descriptive flexfield defining column
133 * @param p_pem_information11 Developer Descriptive flexfield defining column
134 * @param p_pem_information12 Developer Descriptive flexfield defining column
135 * @param p_pem_information13 Developer Descriptive flexfield defining column
136 * @param p_pem_information14 Developer Descriptive flexfield defining column
137 * @param p_pem_information15 Developer Descriptive flexfield defining column
138 * @param p_pem_information16 Developer Descriptive flexfield defining column
139 * @param p_pem_information17 Developer Descriptive flexfield defining column
140 * @param p_pem_information18 Developer Descriptive flexfield defining column
141 * @param p_pem_information19 Developer Descriptive flexfield defining column
142 * @param p_pem_information20 Developer Descriptive flexfield defining column
143 * @param p_pem_information21 Developer Descriptive flexfield defining column
144 * @param p_pem_information22 Developer Descriptive flexfield defining column
145 * @param p_pem_information23 Developer Descriptive flexfield defining column
146 * @param p_pem_information24 Developer Descriptive flexfield defining column
147 * @param p_pem_information25 Developer Descriptive flexfield defining column
148 * @param p_pem_information26 Developer Descriptive flexfield defining column
149 * @param p_pem_information27 Developer Descriptive flexfield defining column
150 * @param p_pem_information28 Developer Descriptive flexfield defining column
151 * @param p_pem_information29 Developer Descriptive flexfield defining column
152 * @param p_pem_information30 Developer Descriptive flexfield defining column
153 * @param p_previous_employer_id If p_validate is false, then this uniquely
154 * identifies the previous employer created. If p_validate is true, then set to
155 * null.
156 * @param p_object_version_number If p_validate is false, then set to the
157 * version number of the created previous employer. If p_validate is true, then
158 * the value will be null.
159 * @rep:displayname Create Previous Employer
160 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
161 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
162 * @rep:scope public
163 * @rep:lifecycle active
164 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
165 */
166 --
167 -- {End Of Comments}
168 --
169 procedure create_previous_employer
170 ( p_effective_date IN date
171 ,p_validate IN boolean default false
172 ,p_business_group_id IN number
173 ,p_person_id IN number
174 ,p_party_id IN number default null
175 ,p_start_date IN date default null
176 ,p_end_date IN date default null
177 ,p_period_years IN number default null
178 ,p_period_months IN number default null
179 ,p_period_days IN number default null
180 ,p_employer_name IN varchar2 default null
181 ,p_employer_country IN varchar2 default null
182 ,p_employer_address IN varchar2 default null
183 ,p_employer_type IN varchar2 default null
184 ,p_employer_subtype IN varchar2 default null
185 ,p_description IN varchar2 default null
186 ,p_all_assignments IN varchar2 default 'N'
187 ,p_pem_attribute_category IN varchar2 default null
188 ,p_pem_attribute1 IN varchar2 default null
189 ,p_pem_attribute2 IN varchar2 default null
190 ,p_pem_attribute3 IN varchar2 default null
191 ,p_pem_attribute4 IN varchar2 default null
192 ,p_pem_attribute5 IN varchar2 default null
193 ,p_pem_attribute6 IN varchar2 default null
194 ,p_pem_attribute7 IN varchar2 default null
195 ,p_pem_attribute8 IN varchar2 default null
196 ,p_pem_attribute9 IN varchar2 default null
197 ,p_pem_attribute10 IN varchar2 default null
198 ,p_pem_attribute11 IN varchar2 default null
199 ,p_pem_attribute12 IN varchar2 default null
200 ,p_pem_attribute13 IN varchar2 default null
201 ,p_pem_attribute14 IN varchar2 default null
202 ,p_pem_attribute15 IN varchar2 default null
203 ,p_pem_attribute16 IN varchar2 default null
204 ,p_pem_attribute17 IN varchar2 default null
205 ,p_pem_attribute18 IN varchar2 default null
206 ,p_pem_attribute19 IN varchar2 default null
207 ,p_pem_attribute20 IN varchar2 default null
208 ,p_pem_attribute21 IN varchar2 default null
209 ,p_pem_attribute22 IN varchar2 default null
210 ,p_pem_attribute23 IN varchar2 default null
211 ,p_pem_attribute24 IN varchar2 default null
212 ,p_pem_attribute25 IN varchar2 default null
213 ,p_pem_attribute26 IN varchar2 default null
214 ,p_pem_attribute27 IN varchar2 default null
215 ,p_pem_attribute28 IN varchar2 default null
216 ,p_pem_attribute29 IN varchar2 default null
217 ,p_pem_attribute30 IN varchar2 default null
218 ,p_pem_information_category IN varchar2 default null
219 ,p_pem_information1 IN varchar2 default null
220 ,p_pem_information2 IN varchar2 default null
221 ,p_pem_information3 IN varchar2 default null
222 ,p_pem_information4 IN varchar2 default null
223 ,p_pem_information5 IN varchar2 default null
224 ,p_pem_information6 IN varchar2 default null
225 ,p_pem_information7 IN varchar2 default null
226 ,p_pem_information8 IN varchar2 default null
227 ,p_pem_information9 IN varchar2 default null
228 ,p_pem_information10 IN varchar2 default null
229 ,p_pem_information11 IN varchar2 default null
230 ,p_pem_information12 IN varchar2 default null
231 ,p_pem_information13 IN varchar2 default null
232 ,p_pem_information14 IN varchar2 default null
233 ,p_pem_information15 IN varchar2 default null
234 ,p_pem_information16 IN varchar2 default null
235 ,p_pem_information17 IN varchar2 default null
236 ,p_pem_information18 IN varchar2 default null
237 ,p_pem_information19 IN varchar2 default null
238 ,p_pem_information20 IN varchar2 default null
239 ,p_pem_information21 IN varchar2 default null
240 ,p_pem_information22 IN varchar2 default null
241 ,p_pem_information23 IN varchar2 default null
242 ,p_pem_information24 IN varchar2 default null
243 ,p_pem_information25 IN varchar2 default null
244 ,p_pem_information26 IN varchar2 default null
245 ,p_pem_information27 IN varchar2 default null
246 ,p_pem_information28 IN varchar2 default null
247 ,p_pem_information29 IN varchar2 default null
248 ,p_pem_information30 IN varchar2 default null
249 ,p_previous_employer_id OUT NOCOPY number
250 ,p_object_version_number OUT NOCOPY number
251 );
252 --
253 -- ----------------------------------------------------------------------------
254 -- |-------------------------< update_previous_employer >---------------------|
255 -- ----------------------------------------------------------------------------
256 --
257 -- {Start Of Comments}
258 /*#
259 * This API updates previous employer details.
260 *
261 * Details can include the previous employer's name, address, and type of
262 * industry. You can specify how long a person worked for the previous
263 * employer, and the associated start and end dates. With public sector
264 * industries in particular, rules associated with previous employment details
265 * can affect multiple assignments, such as determining the speed in which
266 * employees move up a grade scale.
267 *
268 * <p><b>Licensing</b><br>
269 * This API is licensed for use with Human Resources.
270 *
271 * <p><b>Prerequisites</b><br>
272 * The previous employer record must exist for the person
273 *
274 * <p><b>Post Success</b><br>
275 * The previous employer record will be updated.
276 *
277 * <p><b>Post Failure</b><br>
278 * The previous employer record will not be updated and an error will be
279 * raised.
280 * @param p_effective_date Reference date for validating lookup values are
281 * applicable during the start to end active date range. This date does not
282 * determine when the changes take effect.
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.
289 * @param p_end_date The end date of the employee's previous employment.
286 * @param p_previous_employer_id Uniquely identifies the previous employer
287 * record to be updated.
288 * @param p_start_date The start date of the employee's previous employment.
290 * @param p_period_years The number of years the employee worked with the
291 * previous employer. If left null, the process calculates this based on the
292 * start date and end date. For example, if the start date is '01-JAN-2000' and
293 * the end date is '05-MAR-2004', the process sets four years.
294 * @param p_period_months The number of months the employee worked over and
295 * above the years worked. If left null, the process calculates this from the
296 * start and end date. For example, if the start date is '01-JAN-2000' and the
297 * end date is '05-MAR-2004', the the process sets two months.
298 * @param p_period_days The number of days worked over and above the years and
299 * months worked. If left null, the process calculatese this from the start and
300 * end date. For example, if the start date is '01-JAN-2000' and the end date
301 * is '05-MAR-2004', the process sets five days.
302 * @param p_employer_name The name of the previous employer
303 * @param p_employer_country The country in which the previous employer is
304 * located. For global previous employers, set to the country in which the
305 * company headquarters is located or the country in which the employment took
306 * place.
307 * @param p_employer_address The address of the previous employer.
308 * @param p_employer_type Type of previous employer. Valid values for this
309 * field are defined by the lookup type 'PREV_EMP_TYPE'. Values your enterprise
310 * defines for this lookup type should be high level, vertical descriptions for
311 * the industry, for example, 'Public Sector', 'Manufacturing', etc.
312 * @param p_employer_subtype The subtype of the previous employer. Valid values
313 * for this field are defined by the lookup type 'PREV_EMP_SUBTYPE'. Values
314 * your enterprise defines for this lookup type should identify the employer
315 * type more specifically. For example, for the employer type of 'Public
316 * Sector', you can define subtypes such as 'Civil Service', 'Teaching', or
317 * 'Health Care'.
318 * @param p_description Description of the previous employer.
319 * @param p_all_assignments Set to 'Y' if the previous employment applies to
320 * all of the employee's assignments. Otherwise set to 'N'. In order to create
321 * previous job usage records (using the create_previous_job_usage API), set
322 * this flag to 'N'.
323 * @param p_pem_attribute_category Descriptive flexfield structure defining
324 * column.
325 * @param p_pem_attribute1 Descriptive flexfield structure defining column.
326 * @param p_pem_attribute2 Descriptive flexfield structure defining column.
327 * @param p_pem_attribute3 Descriptive flexfield structure defining column.
328 * @param p_pem_attribute4 Descriptive flexfield structure defining column.
329 * @param p_pem_attribute5 Descriptive flexfield structure defining column.
330 * @param p_pem_attribute6 Descriptive flexfield structure defining column.
331 * @param p_pem_attribute7 Descriptive flexfield structure defining column.
332 * @param p_pem_attribute8 Descriptive flexfield structure defining column.
333 * @param p_pem_attribute9 Descriptive flexfield structure defining column.
334 * @param p_pem_attribute10 Descriptive flexfield structure defining column.
335 * @param p_pem_attribute11 Descriptive flexfield structure defining column.
336 * @param p_pem_attribute12 Descriptive flexfield structure defining column.
337 * @param p_pem_attribute13 Descriptive flexfield structure defining column.
338 * @param p_pem_attribute14 Descriptive flexfield structure defining column.
339 * @param p_pem_attribute15 Descriptive flexfield structure defining column.
340 * @param p_pem_attribute16 Descriptive flexfield structure defining column.
341 * @param p_pem_attribute17 Descriptive flexfield structure defining column.
342 * @param p_pem_attribute18 Descriptive flexfield structure defining column.
343 * @param p_pem_attribute19 Descriptive flexfield structure defining column.
344 * @param p_pem_attribute20 Descriptive flexfield structure defining column.
345 * @param p_pem_attribute21 Descriptive flexfield structure defining column.
346 * @param p_pem_attribute22 Descriptive flexfield structure defining column.
347 * @param p_pem_attribute23 Descriptive flexfield structure defining column.
348 * @param p_pem_attribute24 Descriptive flexfield structure defining column.
349 * @param p_pem_attribute25 Descriptive flexfield structure defining column.
350 * @param p_pem_attribute26 Descriptive flexfield structure defining column.
351 * @param p_pem_attribute27 Descriptive flexfield structure defining column.
352 * @param p_pem_attribute28 Descriptive flexfield structure defining column.
353 * @param p_pem_attribute29 Descriptive flexfield structure defining column.
354 * @param p_pem_attribute30 Descriptive flexfield structure defining column.
355 * @param p_pem_information_category Developer Descriptive flexfield defining
356 * column
357 * @param p_pem_information1 Developer Descriptive flexfield defining column
358 * @param p_pem_information2 Developer Descriptive flexfield defining column
359 * @param p_pem_information3 Developer Descriptive flexfield defining column
360 * @param p_pem_information4 Developer Descriptive flexfield defining column
361 * @param p_pem_information5 Developer Descriptive flexfield defining column
362 * @param p_pem_information6 Developer Descriptive flexfield defining column
363 * @param p_pem_information7 Developer Descriptive flexfield defining column
364 * @param p_pem_information8 Developer Descriptive flexfield defining column
365 * @param p_pem_information9 Developer Descriptive flexfield defining column
369 * @param p_pem_information13 Developer Descriptive flexfield defining column
366 * @param p_pem_information10 Developer Descriptive flexfield defining column
367 * @param p_pem_information11 Developer Descriptive flexfield defining column
368 * @param p_pem_information12 Developer Descriptive flexfield defining column
370 * @param p_pem_information14 Developer Descriptive flexfield defining column
371 * @param p_pem_information15 Developer Descriptive flexfield defining column
372 * @param p_pem_information16 Developer Descriptive flexfield defining column
373 * @param p_pem_information17 Developer Descriptive flexfield defining column
374 * @param p_pem_information18 Developer Descriptive flexfield defining column
375 * @param p_pem_information19 Developer Descriptive flexfield defining column
376 * @param p_pem_information20 Developer Descriptive flexfield defining column
377 * @param p_pem_information21 Developer Descriptive flexfield defining column
378 * @param p_pem_information22 Developer Descriptive flexfield defining column
379 * @param p_pem_information23 Developer Descriptive flexfield defining column
380 * @param p_pem_information24 Developer Descriptive flexfield defining column
381 * @param p_pem_information25 Developer Descriptive flexfield defining column
382 * @param p_pem_information26 Developer Descriptive flexfield defining column
383 * @param p_pem_information27 Developer Descriptive flexfield defining column
384 * @param p_pem_information28 Developer Descriptive flexfield defining column
385 * @param p_pem_information29 Developer Descriptive flexfield defining column
386 * @param p_pem_information30 Developer Descriptive flexfield defining column
387 * @param p_object_version_number Pass in the current version number of the
388 * previous employer to be updated. When the API completes if p_validate is
389 * false, will be set to the new version number of the updated previous
390 * employer. If p_validate is true will be set to the same value which was
391 * passed in.
392 * @rep:displayname Update Previous Employer
393 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
394 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
395 * @rep:scope public
396 * @rep:lifecycle active
397 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
398 */
399 --
400 -- {End Of Comments}
401 --
402 procedure update_previous_employer
403 ( p_effective_date IN date
404 ,p_validate IN boolean default false
405 ,p_previous_employer_id IN number
406 ,p_start_date IN date default hr_api.g_date
407 ,p_end_date IN date default hr_api.g_date
408 ,p_period_years IN number default hr_api.g_number
409 ,p_period_months IN number default hr_api.g_number
410 ,p_period_days IN number default hr_api.g_number
411 ,p_employer_name IN varchar2 default hr_api.g_varchar2
412 ,p_employer_country IN varchar2 default hr_api.g_varchar2
413 ,p_employer_address IN varchar2 default hr_api.g_varchar2
414 ,p_employer_type IN varchar2 default hr_api.g_varchar2
415 ,p_employer_subtype IN varchar2 default hr_api.g_varchar2
416 ,p_description IN varchar2 default hr_api.g_varchar2
417 ,p_all_assignments IN varchar2 default 'N'
418 ,p_pem_attribute_category IN varchar2 default hr_api.g_varchar2
419 ,p_pem_attribute1 IN varchar2 default hr_api.g_varchar2
420 ,p_pem_attribute2 IN varchar2 default hr_api.g_varchar2
421 ,p_pem_attribute3 IN varchar2 default hr_api.g_varchar2
422 ,p_pem_attribute4 IN varchar2 default hr_api.g_varchar2
423 ,p_pem_attribute5 IN varchar2 default hr_api.g_varchar2
424 ,p_pem_attribute6 IN varchar2 default hr_api.g_varchar2
425 ,p_pem_attribute7 IN varchar2 default hr_api.g_varchar2
426 ,p_pem_attribute8 IN varchar2 default hr_api.g_varchar2
427 ,p_pem_attribute9 IN varchar2 default hr_api.g_varchar2
428 ,p_pem_attribute10 IN varchar2 default hr_api.g_varchar2
429 ,p_pem_attribute11 IN varchar2 default hr_api.g_varchar2
430 ,p_pem_attribute12 IN varchar2 default hr_api.g_varchar2
431 ,p_pem_attribute13 IN varchar2 default hr_api.g_varchar2
432 ,p_pem_attribute14 IN varchar2 default hr_api.g_varchar2
433 ,p_pem_attribute15 IN varchar2 default hr_api.g_varchar2
434 ,p_pem_attribute16 IN varchar2 default hr_api.g_varchar2
435 ,p_pem_attribute17 IN varchar2 default hr_api.g_varchar2
436 ,p_pem_attribute18 IN varchar2 default hr_api.g_varchar2
437 ,p_pem_attribute19 IN varchar2 default hr_api.g_varchar2
438 ,p_pem_attribute20 IN varchar2 default hr_api.g_varchar2
439 ,p_pem_attribute21 IN varchar2 default hr_api.g_varchar2
440 ,p_pem_attribute22 IN varchar2 default hr_api.g_varchar2
441 ,p_pem_attribute23 IN varchar2 default hr_api.g_varchar2
442 ,p_pem_attribute24 IN varchar2 default hr_api.g_varchar2
443 ,p_pem_attribute25 IN varchar2 default hr_api.g_varchar2
444 ,p_pem_attribute26 IN varchar2 default hr_api.g_varchar2
445 ,p_pem_attribute27 IN varchar2 default hr_api.g_varchar2
446 ,p_pem_attribute28 IN varchar2 default hr_api.g_varchar2
447 ,p_pem_attribute29 IN varchar2 default hr_api.g_varchar2
451 ,p_pem_information2 IN varchar2 default hr_api.g_varchar2
448 ,p_pem_attribute30 IN varchar2 default hr_api.g_varchar2
449 ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
450 ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
452 ,p_pem_information3 IN varchar2 default hr_api.g_varchar2
453 ,p_pem_information4 IN varchar2 default hr_api.g_varchar2
454 ,p_pem_information5 IN varchar2 default hr_api.g_varchar2
455 ,p_pem_information6 IN varchar2 default hr_api.g_varchar2
456 ,p_pem_information7 IN varchar2 default hr_api.g_varchar2
457 ,p_pem_information8 IN varchar2 default hr_api.g_varchar2
458 ,p_pem_information9 IN varchar2 default hr_api.g_varchar2
459 ,p_pem_information10 IN varchar2 default hr_api.g_varchar2
460 ,p_pem_information11 IN varchar2 default hr_api.g_varchar2
461 ,p_pem_information12 IN varchar2 default hr_api.g_varchar2
462 ,p_pem_information13 IN varchar2 default hr_api.g_varchar2
463 ,p_pem_information14 IN varchar2 default hr_api.g_varchar2
464 ,p_pem_information15 IN varchar2 default hr_api.g_varchar2
465 ,p_pem_information16 IN varchar2 default hr_api.g_varchar2
466 ,p_pem_information17 IN varchar2 default hr_api.g_varchar2
467 ,p_pem_information18 IN varchar2 default hr_api.g_varchar2
468 ,p_pem_information19 IN varchar2 default hr_api.g_varchar2
469 ,p_pem_information20 IN varchar2 default hr_api.g_varchar2
470 ,p_pem_information21 IN varchar2 default hr_api.g_varchar2
471 ,p_pem_information22 IN varchar2 default hr_api.g_varchar2
472 ,p_pem_information23 IN varchar2 default hr_api.g_varchar2
473 ,p_pem_information24 IN varchar2 default hr_api.g_varchar2
474 ,p_pem_information25 IN varchar2 default hr_api.g_varchar2
475 ,p_pem_information26 IN varchar2 default hr_api.g_varchar2
476 ,p_pem_information27 IN varchar2 default hr_api.g_varchar2
477 ,p_pem_information28 IN varchar2 default hr_api.g_varchar2
478 ,p_pem_information29 IN varchar2 default hr_api.g_varchar2
479 ,p_pem_information30 IN varchar2 default hr_api.g_varchar2
480 ,p_object_version_number IN OUT NOCOPY number
481 );
482 --
483 -- ----------------------------------------------------------------------------
484 -- |-------------------------< delete_previous_employer >---------------------|
485 -- ----------------------------------------------------------------------------
486 --
487 -- {Start Of Comments}
488 /*#
489 * This API deletes a previous employer.
490 *
491 *
492 * <p><b>Licensing</b><br>
493 * This API is licensed for use with Human Resources.
494 *
495 * <p><b>Prerequisites</b><br>
496 * The previous employer must exist and have no previous job, previous job
497 * extra information or previous job usages records.
498 *
499 * <p><b>Post Success</b><br>
500 * The previous employer is deleted.
501 *
502 * <p><b>Post Failure</b><br>
503 * The previous employer is not deleted and an error will be raised
504 * @param p_validate If true, then validation alone will be performed and the
505 * database will remain unchanged. If false and all validation checks pass,
506 * then the database will be modified.
507 * @param p_previous_employer_id Uniquely identifies the previous employer
508 * record to be deleted.
509 * @param p_object_version_number Current version number of the previous
510 * employer to be deleted.
511 * @rep:displayname Delete Previous Employer
512 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
513 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
514 * @rep:scope public
515 * @rep:lifecycle active
516 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
517 */
518 --
519 -- {End Of Comments}
520 --
521 procedure delete_previous_employer
522 (p_validate in boolean default false
523 ,p_previous_employer_id in number
524 ,p_object_version_number in out nocopy number
525 );
526 --
527 -- ----------------------------------------------------------------------------
528 -- |---------------------------< create_previous_job >------------------------|
529 -- ----------------------------------------------------------------------------
530 --
531 -- {Start Of Comments}
532 /*#
533 * This API creates a previous job held with a previous employer.
534 *
535 * Each job an employee performed with a previous employer can affect current
536 * employment. For example, a person with four years of teaching experience may
537 * have spent one of those years as a Head Teacher. Creating a previous job
538 * enables HRMS to account for the Head Teacher experience.
539 *
540 * <p><b>Licensing</b><br>
541 * This API is licensed for use with Human Resources.
542 *
543 * <p><b>Prerequisites</b><br>
544 * A previous employer must exist for this person.
545 *
546 * <p><b>Post Success</b><br>
547 * The previous job record will be created.
548 *
549 * <p><b>Post Failure</b><br>
550 * The previous job record will not be created and an error will be raised.
551 * @param p_effective_date Reference date for validating lookup values are
552 * applicable during the start to end active date range. This date does not
553 * determine when the changes take effect.
557 * @param p_previous_employer_id Uniquely identifies the previous employer for
554 * @param p_validate If true, then validation alone will be performed and the
555 * database will remain unchanged. If false and all validation checks pass,
556 * then the database will be modified.
558 * which the previous job was performed
559 * @param p_start_date The start date of the previous job.
560 * @param p_end_date The end date of the previous job.
561 * @param p_period_years The number of years the employee worked on the
562 * previous job. If left null, the process calculates this based on the start
563 * date and end date. For example, if the start date is '01-JAN-2000' and the
564 * end date is '05-MAR-2004', the process sets four years.
565 * @param p_period_months The number of months the employee worked on the
566 * previous job over and above the years worked. If left null, the process
567 * calculates this from the start and end date. For example, if the start date
568 * is '01-JAN-2000' and the end date is '05-MAR-2004', the process sets two
569 * months.
570 * @param p_period_days The number of days the employee worked on the previous
571 * job over and above the years and months worked. If left null, the process
572 * calculates this from the start and end date. For example, if the start date
573 * is '01-JAN-2000' and the end date is '05-MAR-2004', the process sets five
574 * days.
575 * @param p_job_name The name of the previous job. This is free text, and
576 * should not be confused with jobs held with the current employer stored
577 * within Oracle Human Resources.
578 * @param p_employment_category The employee category of the previous job.
579 * Valid values are defined by the lookup type 'EMPLOYEE_CATG'. Examples are
580 * 'Civil Servant', 'Blue Collar' and 'Technical White Collar'.
581 * @param p_description The description of the previous job.
582 * @param p_all_assignments Set to 'Y' if the previous employment applies to
583 * all of the employee's assignments. Otherwise set to 'N'. In order to create
584 * previous job usage records (using the create_previous_job_usage API), set
585 * this flag to 'N'.
586 * @param p_pjo_attribute_category Descriptive flexfield Structure defining
587 * column.
588 * @param p_pjo_attribute1 Descriptive flexfield column
589 * @param p_pjo_attribute2 Descriptive flexfield column
590 * @param p_pjo_attribute3 Descriptive flexfield column
591 * @param p_pjo_attribute4 Descriptive flexfield column
592 * @param p_pjo_attribute5 Descriptive flexfield column
593 * @param p_pjo_attribute6 Descriptive flexfield column
594 * @param p_pjo_attribute7 Descriptive flexfield column
595 * @param p_pjo_attribute8 Descriptive flexfield column
596 * @param p_pjo_attribute9 Descriptive flexfield column
597 * @param p_pjo_attribute10 Descriptive flexfield column
598 * @param p_pjo_attribute11 Descriptive flexfield column
599 * @param p_pjo_attribute12 Descriptive flexfield column
600 * @param p_pjo_attribute13 Descriptive flexfield column
601 * @param p_pjo_attribute14 Descriptive flexfield column
602 * @param p_pjo_attribute15 Descriptive flexfield column
603 * @param p_pjo_attribute16 Descriptive flexfield column
604 * @param p_pjo_attribute17 Descriptive flexfield column
605 * @param p_pjo_attribute18 Descriptive flexfield column
606 * @param p_pjo_attribute19 Descriptive flexfield column
607 * @param p_pjo_attribute20 Descriptive flexfield column
608 * @param p_pjo_attribute21 Descriptive flexfield column
609 * @param p_pjo_attribute22 Descriptive flexfield column
610 * @param p_pjo_attribute23 Descriptive flexfield column
611 * @param p_pjo_attribute24 Descriptive flexfield column
612 * @param p_pjo_attribute25 Descriptive flexfield column
613 * @param p_pjo_attribute26 Descriptive flexfield column
614 * @param p_pjo_attribute27 Descriptive flexfield column
615 * @param p_pjo_attribute28 Descriptive flexfield column
616 * @param p_pjo_attribute29 Descriptive flexfield column
617 * @param p_pjo_attribute30 Descriptive flexfield column
618 * @param p_pjo_information_category Developer Descriptive flexfield structure
619 * defining column
620 * @param p_pjo_information1 Developer Descriptive flexfield column
621 * @param p_pjo_information2 Developer Descriptive flexfield column
622 * @param p_pjo_information3 Developer Descriptive flexfield column
623 * @param p_pjo_information4 Developer Descriptive flexfield column
624 * @param p_pjo_information5 Developer Descriptive flexfield column
625 * @param p_pjo_information6 Developer Descriptive flexfield column
626 * @param p_pjo_information7 Developer Descriptive flexfield column
627 * @param p_pjo_information8 Developer Descriptive flexfield column
628 * @param p_pjo_information9 Developer Descriptive flexfield column
629 * @param p_pjo_information10 Developer Descriptive flexfield column
630 * @param p_pjo_information11 Developer Descriptive flexfield column
631 * @param p_pjo_information12 Developer Descriptive flexfield column
632 * @param p_pjo_information13 Developer Descriptive flexfield column
633 * @param p_pjo_information14 Developer Descriptive flexfield column
634 * @param p_pjo_information15 Developer Descriptive flexfield column
635 * @param p_pjo_information16 Developer Descriptive flexfield column
636 * @param p_pjo_information17 Developer Descriptive flexfield column
637 * @param p_pjo_information18 Developer Descriptive flexfield column
638 * @param p_pjo_information19 Developer Descriptive flexfield column
639 * @param p_pjo_information20 Developer Descriptive flexfield column
640 * @param p_pjo_information21 Developer Descriptive flexfield column
641 * @param p_pjo_information22 Developer Descriptive flexfield column
642 * @param p_pjo_information23 Developer Descriptive flexfield column
646 * @param p_pjo_information27 Developer Descriptive flexfield column
643 * @param p_pjo_information24 Developer Descriptive flexfield column
644 * @param p_pjo_information25 Developer Descriptive flexfield column
645 * @param p_pjo_information26 Developer Descriptive flexfield column
647 * @param p_pjo_information28 Developer Descriptive flexfield column
648 * @param p_pjo_information29 Developer Descriptive flexfield column
649 * @param p_pjo_information30 Developer Descriptive flexfield column
650 * @param p_previous_job_id If p_validate is false, then this uniquely
651 * identifies the previous job created. If p_validate is true, then set to
652 * null.
653 * @param p_object_version_number If p_validate is false, then set to the
654 * version number of the previous job created. If p_validate is true, then set
655 * to null.
656 * @rep:displayname Create Previous Job
657 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
658 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
659 * @rep:scope public
660 * @rep:lifecycle active
661 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
662 */
663 --
664 -- {End Of Comments}
665 --
666 procedure create_previous_job
667 ( p_effective_date in date
668 ,p_validate in boolean default false
669 ,p_previous_employer_id in number
670 ,p_start_date in date default null
671 ,p_end_date in date default null
672 ,p_period_years in number default null
673 ,p_period_months in number default null
674 ,p_period_days in number default null
675 ,p_job_name in varchar2 default null
676 ,p_employment_category in varchar2 default null
677 ,p_description in varchar2 default null
678 ,p_all_assignments in varchar2 default 'N'
679 ,p_pjo_attribute_category in varchar2 default null
680 ,p_pjo_attribute1 in varchar2 default null
681 ,p_pjo_attribute2 in varchar2 default null
682 ,p_pjo_attribute3 in varchar2 default null
683 ,p_pjo_attribute4 in varchar2 default null
684 ,p_pjo_attribute5 in varchar2 default null
685 ,p_pjo_attribute6 in varchar2 default null
686 ,p_pjo_attribute7 in varchar2 default null
687 ,p_pjo_attribute8 in varchar2 default null
688 ,p_pjo_attribute9 in varchar2 default null
689 ,p_pjo_attribute10 in varchar2 default null
690 ,p_pjo_attribute11 in varchar2 default null
691 ,p_pjo_attribute12 in varchar2 default null
692 ,p_pjo_attribute13 in varchar2 default null
693 ,p_pjo_attribute14 in varchar2 default null
694 ,p_pjo_attribute15 in varchar2 default null
695 ,p_pjo_attribute16 in varchar2 default null
696 ,p_pjo_attribute17 in varchar2 default null
697 ,p_pjo_attribute18 in varchar2 default null
698 ,p_pjo_attribute19 in varchar2 default null
699 ,p_pjo_attribute20 in varchar2 default null
700 ,p_pjo_attribute21 in varchar2 default null
701 ,p_pjo_attribute22 in varchar2 default null
702 ,p_pjo_attribute23 in varchar2 default null
703 ,p_pjo_attribute24 in varchar2 default null
704 ,p_pjo_attribute25 in varchar2 default null
705 ,p_pjo_attribute26 in varchar2 default null
706 ,p_pjo_attribute27 in varchar2 default null
707 ,p_pjo_attribute28 in varchar2 default null
708 ,p_pjo_attribute29 in varchar2 default null
709 ,p_pjo_attribute30 in varchar2 default null
710 ,p_pjo_information_category in varchar2 default null
711 ,p_pjo_information1 in varchar2 default null
712 ,p_pjo_information2 in varchar2 default null
713 ,p_pjo_information3 in varchar2 default null
714 ,p_pjo_information4 in varchar2 default null
715 ,p_pjo_information5 in varchar2 default null
716 ,p_pjo_information6 in varchar2 default null
717 ,p_pjo_information7 in varchar2 default null
718 ,p_pjo_information8 in varchar2 default null
719 ,p_pjo_information9 in varchar2 default null
720 ,p_pjo_information10 in varchar2 default null
721 ,p_pjo_information11 in varchar2 default null
722 ,p_pjo_information12 in varchar2 default null
723 ,p_pjo_information13 in varchar2 default null
724 ,p_pjo_information14 in varchar2 default null
725 ,p_pjo_information15 in varchar2 default null
726 ,p_pjo_information16 in varchar2 default null
727 ,p_pjo_information17 in varchar2 default null
728 ,p_pjo_information18 in varchar2 default null
729 ,p_pjo_information19 in varchar2 default null
730 ,p_pjo_information20 in varchar2 default null
731 ,p_pjo_information21 in varchar2 default null
732 ,p_pjo_information22 in varchar2 default null
733 ,p_pjo_information23 in varchar2 default null
734 ,p_pjo_information24 in varchar2 default null
738 ,p_pjo_information28 in varchar2 default null
735 ,p_pjo_information25 in varchar2 default null
736 ,p_pjo_information26 in varchar2 default null
737 ,p_pjo_information27 in varchar2 default null
739 ,p_pjo_information29 in varchar2 default null
740 ,p_pjo_information30 in varchar2 default null
741 ,p_previous_job_id out nocopy number
742 ,p_object_version_number out nocopy number
743 );
744 --
745 -- ----------------------------------------------------------------------------
746 -- |---------------------------< update_previous_job >------------------------|
747 -- ----------------------------------------------------------------------------
748 --
749 -- {Start Of Comments}
750 /*#
751 * This API updates a previous job held with a previous employer.
752 *
753 * Each job an employee performed with a previous employer can affect current
754 * employment. For example, a person with four years of teaching experience may
755 * have spent one of those years as a Head Teacher. Creating a previous job
756 * enables HRMS to account for the Head Teacher experience.
757 *
758 * <p><b>Licensing</b><br>
759 * This API is licensed for use with Human Resources.
760 *
761 * <p><b>Prerequisites</b><br>
762 * A previous job must exist for this previous employer.
763 *
764 * <p><b>Post Success</b><br>
765 * The previous job will be updated.
766 *
767 * <p><b>Post Failure</b><br>
768 * The previous job will not be updated.
769 * @param p_effective_date Reference date for validating lookup values are
770 * applicable during the start to end active date range. This date does not
771 * determine when the changes take effect.
772 * @param p_validate If true, then validation alone will be performed and the
773 * database will remain unchanged. If false and all validation checks pass,
774 * then the database will be modified.
775 * @param p_previous_job_id Uniquely identifes the previous job to be updated.
776 * @param p_start_date The start date of the previous job.
777 * @param p_end_date The end date of the previous job.
778 * @param p_period_years The number of years the employee worked on the
779 * previous job. If left null, the process calculates this based on the start
780 * date and end date. For example, if the start date is '01-JAN-2000' and the
781 * end date is '05-MAR-2004', the process sets four years.
782 * @param p_period_months The number of months the employee worked on the
783 * previous job over and above the years worked. If left null, the process
784 * calculates this from the start and end date. For example, if the start date
785 * is '01-JAN-2000' and the end date is '05-MAR-2004', the process sets two
786 * months.
787 * @param p_period_days The number of days the employee worked on the previous
788 * job over and above the years and months worked. If left null, the process
789 * calculates this from the start and end date. For example, if the start date
790 * is '01-JAN-2000' and the end date is '05-MAR-2004', the process sets five
791 * days.
792 * @param p_job_name The name of the previous job. This is free text, and
793 * should not be confused with jobs held with the current employer stored
794 * within Oracle Human Resources.
795 * @param p_employment_category The employee category of the previous job.
796 * Valid values are defined by the lookup type 'EMPLOYEE_CATG'. Examples are
797 * 'Civil Servant', 'Blue Collar' and 'Technical White Collar'.
798 * @param p_description The description of the previous job.
799 * @param p_all_assignments Set to 'Y' if the previous employment applies to
800 * all of the employee's assignments. Otherwise set to 'N'. In order to create
801 * previous job usage records (using the create_previous_job_usage API), set
802 * this flag to 'N'.
803 * @param p_pjo_attribute_category Descriptive flexfield Structure defining
804 * column.
805 * @param p_pjo_attribute1 Descriptive flexfield column
806 * @param p_pjo_attribute2 Descriptive flexfield column
807 * @param p_pjo_attribute3 Descriptive flexfield column
808 * @param p_pjo_attribute4 Descriptive flexfield column
809 * @param p_pjo_attribute5 Descriptive flexfield column
810 * @param p_pjo_attribute6 Descriptive flexfield column
811 * @param p_pjo_attribute7 Descriptive flexfield column
812 * @param p_pjo_attribute8 Descriptive flexfield column
813 * @param p_pjo_attribute9 Descriptive flexfield column
814 * @param p_pjo_attribute10 Descriptive flexfield column
815 * @param p_pjo_attribute11 Descriptive flexfield column
816 * @param p_pjo_attribute12 Descriptive flexfield column
817 * @param p_pjo_attribute13 Descriptive flexfield column
818 * @param p_pjo_attribute14 Descriptive flexfield column
819 * @param p_pjo_attribute15 Descriptive flexfield column
820 * @param p_pjo_attribute16 Descriptive flexfield column
821 * @param p_pjo_attribute17 Descriptive flexfield column
822 * @param p_pjo_attribute18 Descriptive flexfield column
823 * @param p_pjo_attribute19 Descriptive flexfield column
824 * @param p_pjo_attribute20 Descriptive flexfield column
825 * @param p_pjo_attribute21 Descriptive flexfield column
826 * @param p_pjo_attribute22 Descriptive flexfield column
827 * @param p_pjo_attribute23 Descriptive flexfield column
828 * @param p_pjo_attribute24 Descriptive flexfield column
829 * @param p_pjo_attribute25 Descriptive flexfield column
830 * @param p_pjo_attribute26 Descriptive flexfield column
831 * @param p_pjo_attribute27 Descriptive flexfield column
832 * @param p_pjo_attribute28 Descriptive flexfield column
836 * defining column
833 * @param p_pjo_attribute29 Descriptive flexfield column
834 * @param p_pjo_attribute30 Descriptive flexfield column
835 * @param p_pjo_information_category Developer Descriptive flexfield structure
837 * @param p_pjo_information1 Developer Descriptive flexfield column
838 * @param p_pjo_information2 Developer Descriptive flexfield column
839 * @param p_pjo_information3 Developer Descriptive flexfield column
840 * @param p_pjo_information4 Developer Descriptive flexfield column
841 * @param p_pjo_information5 Developer Descriptive flexfield column
842 * @param p_pjo_information6 Developer Descriptive flexfield column
843 * @param p_pjo_information7 Developer Descriptive flexfield column
844 * @param p_pjo_information8 Developer Descriptive flexfield column
845 * @param p_pjo_information9 Developer Descriptive flexfield column
846 * @param p_pjo_information10 Developer Descriptive flexfield column
847 * @param p_pjo_information11 Developer Descriptive flexfield column
848 * @param p_pjo_information12 Developer Descriptive flexfield column
849 * @param p_pjo_information13 Developer Descriptive flexfield column
850 * @param p_pjo_information14 Developer Descriptive flexfield column
851 * @param p_pjo_information15 Developer Descriptive flexfield column
852 * @param p_pjo_information16 Developer Descriptive flexfield column
853 * @param p_pjo_information17 Developer Descriptive flexfield column
854 * @param p_pjo_information18 Developer Descriptive flexfield column
855 * @param p_pjo_information19 Developer Descriptive flexfield column
856 * @param p_pjo_information20 Developer Descriptive flexfield column
857 * @param p_pjo_information21 Developer Descriptive flexfield column
858 * @param p_pjo_information22 Developer Descriptive flexfield column
859 * @param p_pjo_information23 Developer Descriptive flexfield column
860 * @param p_pjo_information24 Developer Descriptive flexfield column
861 * @param p_pjo_information25 Developer Descriptive flexfield column
862 * @param p_pjo_information26 Developer Descriptive flexfield column
863 * @param p_pjo_information27 Developer Descriptive flexfield column
864 * @param p_pjo_information28 Developer Descriptive flexfield column
865 * @param p_pjo_information29 Developer Descriptive flexfield column
866 * @param p_pjo_information30 Developer Descriptive flexfield column
867 * @param p_object_version_number Pass in the current version number of the
868 * previous job to be updated. When the API completes if p_validate is false,
869 * will be set to the new version number of the updated previous job. If
870 * p_validate is true will be set to the same value which was passed in.
871 * @rep:displayname Update Previous Job
872 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
873 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
874 * @rep:scope public
875 * @rep:lifecycle active
876 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
877 */
878 --
879 -- {End Of Comments}
880 --
881 procedure update_previous_job
882 (p_effective_date in date
883 ,p_validate in boolean default false
884 ,p_previous_job_id in number
885 ,p_start_date in date default hr_api.g_date
886 ,p_end_date in date default hr_api.g_date
887 ,p_period_years in number default hr_api.g_number
888 ,p_period_months in number default hr_api.g_number
889 ,p_period_days in number default hr_api.g_number
890 ,p_job_name in varchar2 default hr_api.g_varchar2
891 ,p_employment_category in varchar2 default hr_api.g_varchar2
892 ,p_description in varchar2 default hr_api.g_varchar2
893 ,p_all_assignments in varchar2 default 'N'
894 ,p_pjo_attribute_category in varchar2 default hr_api.g_varchar2
895 ,p_pjo_attribute1 in varchar2 default hr_api.g_varchar2
896 ,p_pjo_attribute2 in varchar2 default hr_api.g_varchar2
897 ,p_pjo_attribute3 in varchar2 default hr_api.g_varchar2
898 ,p_pjo_attribute4 in varchar2 default hr_api.g_varchar2
899 ,p_pjo_attribute5 in varchar2 default hr_api.g_varchar2
900 ,p_pjo_attribute6 in varchar2 default hr_api.g_varchar2
901 ,p_pjo_attribute7 in varchar2 default hr_api.g_varchar2
902 ,p_pjo_attribute8 in varchar2 default hr_api.g_varchar2
903 ,p_pjo_attribute9 in varchar2 default hr_api.g_varchar2
904 ,p_pjo_attribute10 in varchar2 default hr_api.g_varchar2
905 ,p_pjo_attribute11 in varchar2 default hr_api.g_varchar2
906 ,p_pjo_attribute12 in varchar2 default hr_api.g_varchar2
907 ,p_pjo_attribute13 in varchar2 default hr_api.g_varchar2
908 ,p_pjo_attribute14 in varchar2 default hr_api.g_varchar2
909 ,p_pjo_attribute15 in varchar2 default hr_api.g_varchar2
910 ,p_pjo_attribute16 in varchar2 default hr_api.g_varchar2
911 ,p_pjo_attribute17 in varchar2 default hr_api.g_varchar2
912 ,p_pjo_attribute18 in varchar2 default hr_api.g_varchar2
913 ,p_pjo_attribute19 in varchar2 default hr_api.g_varchar2
914 ,p_pjo_attribute20 in varchar2 default hr_api.g_varchar2
915 ,p_pjo_attribute21 in varchar2 default hr_api.g_varchar2
916 ,p_pjo_attribute22 in varchar2 default hr_api.g_varchar2
917 ,p_pjo_attribute23 in varchar2 default hr_api.g_varchar2
918 ,p_pjo_attribute24 in varchar2 default hr_api.g_varchar2
922 ,p_pjo_attribute28 in varchar2 default hr_api.g_varchar2
919 ,p_pjo_attribute25 in varchar2 default hr_api.g_varchar2
920 ,p_pjo_attribute26 in varchar2 default hr_api.g_varchar2
921 ,p_pjo_attribute27 in varchar2 default hr_api.g_varchar2
923 ,p_pjo_attribute29 in varchar2 default hr_api.g_varchar2
924 ,p_pjo_attribute30 in varchar2 default hr_api.g_varchar2
925 ,p_pjo_information_category in varchar2 default hr_api.g_varchar2
926 ,p_pjo_information1 in varchar2 default hr_api.g_varchar2
927 ,p_pjo_information2 in varchar2 default hr_api.g_varchar2
928 ,p_pjo_information3 in varchar2 default hr_api.g_varchar2
929 ,p_pjo_information4 in varchar2 default hr_api.g_varchar2
930 ,p_pjo_information5 in varchar2 default hr_api.g_varchar2
931 ,p_pjo_information6 in varchar2 default hr_api.g_varchar2
932 ,p_pjo_information7 in varchar2 default hr_api.g_varchar2
933 ,p_pjo_information8 in varchar2 default hr_api.g_varchar2
934 ,p_pjo_information9 in varchar2 default hr_api.g_varchar2
935 ,p_pjo_information10 in varchar2 default hr_api.g_varchar2
936 ,p_pjo_information11 in varchar2 default hr_api.g_varchar2
937 ,p_pjo_information12 in varchar2 default hr_api.g_varchar2
938 ,p_pjo_information13 in varchar2 default hr_api.g_varchar2
939 ,p_pjo_information14 in varchar2 default hr_api.g_varchar2
940 ,p_pjo_information15 in varchar2 default hr_api.g_varchar2
941 ,p_pjo_information16 in varchar2 default hr_api.g_varchar2
942 ,p_pjo_information17 in varchar2 default hr_api.g_varchar2
943 ,p_pjo_information18 in varchar2 default hr_api.g_varchar2
944 ,p_pjo_information19 in varchar2 default hr_api.g_varchar2
945 ,p_pjo_information20 in varchar2 default hr_api.g_varchar2
946 ,p_pjo_information21 in varchar2 default hr_api.g_varchar2
947 ,p_pjo_information22 in varchar2 default hr_api.g_varchar2
948 ,p_pjo_information23 in varchar2 default hr_api.g_varchar2
949 ,p_pjo_information24 in varchar2 default hr_api.g_varchar2
950 ,p_pjo_information25 in varchar2 default hr_api.g_varchar2
951 ,p_pjo_information26 in varchar2 default hr_api.g_varchar2
952 ,p_pjo_information27 in varchar2 default hr_api.g_varchar2
953 ,p_pjo_information28 in varchar2 default hr_api.g_varchar2
954 ,p_pjo_information29 in varchar2 default hr_api.g_varchar2
955 ,p_pjo_information30 in varchar2 default hr_api.g_varchar2
956 ,p_object_version_number in out nocopy number
957 );
958 --
959 -- ----------------------------------------------------------------------------
960 -- |---------------------------< delete_previous_job >------------------------|
961 -- ----------------------------------------------------------------------------
962 --
963 -- {Start Of Comments}
964 /*#
965 * This API deletes a previous job held with a previous employer.
966 *
967 *
968 * <p><b>Licensing</b><br>
969 * This API is licensed for use with Human Resources.
970 *
971 * <p><b>Prerequisites</b><br>
972 * A previous job must exist for this previous employer.
973 *
974 * <p><b>Post Success</b><br>
975 * The previous job will be deleted.
976 *
977 * <p><b>Post Failure</b><br>
978 * The previous job will not be deleted.
979 * @param p_validate If true, then validation alone will be performed and the
980 * database will remain unchanged. If false and all validation checks pass,
981 * then the database will be modified.
982 * @param p_previous_job_id Uniquely identifes the previous job to be deleted.
983 * @param p_object_version_number Current version number of the previous job to
984 * be deleted.
985 * @rep:displayname Delete Previous Job
986 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
987 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
988 * @rep:scope public
989 * @rep:lifecycle active
990 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
991 */
992 --
993 -- {End Of Comments}
994 --
995 procedure delete_previous_job
996 (p_validate in boolean default false
997 ,p_previous_job_id in number
998 ,p_object_version_number in out nocopy number
999 );
1000 --
1001 -- ----------------------------------------------------------------------------
1002 -- |------------------------< create_prev_job_extra_info >--------------------|
1003 -- ----------------------------------------------------------------------------
1004 --
1005 -- {Start Of Comments}
1006 /*#
1007 * This API creates extra information for a previous job.
1008 *
1009 * The type of information the process captures will vary, depending on the
1010 * legislation of the person's business group.
1011 *
1012 * <p><b>Licensing</b><br>
1013 * This API is licensed for use with Human Resources.
1014 *
1015 * <p><b>Prerequisites</b><br>
1016 * A previous job must exist for this previous employer.
1017 *
1018 * <p><b>Post Success</b><br>
1019 * Extra information is created for this previous job.
1020 *
1021 * <p><b>Post Failure</b><br>
1022 * Extra information is not created for this previous job and an error will be
1023 * raised.
1027 * @param p_previous_job_id Uniquely identifies the previous job for which the
1024 * @param p_validate If true, then validation alone will be performed and the
1025 * database will remain unchanged. If false and all validation checks pass,
1026 * then the database will be modified.
1028 * extra information will be created.
1029 * @param p_information_type The type of information being captured. Valid
1030 * values are stored in the column PER_PREV_INFO_TYPES.INFORMATION_TYPE.
1031 * @param p_pji_attribute_category Descriptive flexfield structure defining
1032 * column.
1033 * @param p_pji_attribute1 Descriptive flexfield column
1034 * @param p_pji_attribute2 Descriptive flexfield column
1035 * @param p_pji_attribute3 Descriptive flexfield column
1036 * @param p_pji_attribute4 Descriptive flexfield column
1037 * @param p_pji_attribute5 Descriptive flexfield column
1038 * @param p_pji_attribute6 Descriptive flexfield column
1039 * @param p_pji_attribute7 Descriptive flexfield column
1040 * @param p_pji_attribute8 Descriptive flexfield column
1041 * @param p_pji_attribute9 Descriptive flexfield column
1042 * @param p_pji_attribute10 Descriptive flexfield column
1043 * @param p_pji_attribute11 Descriptive flexfield column
1044 * @param p_pji_attribute12 Descriptive flexfield column
1045 * @param p_pji_attribute13 Descriptive flexfield column
1046 * @param p_pji_attribute14 Descriptive flexfield column
1047 * @param p_pji_attribute15 Descriptive flexfield column
1048 * @param p_pji_attribute16 Descriptive flexfield column
1049 * @param p_pji_attribute17 Descriptive flexfield column
1050 * @param p_pji_attribute18 Descriptive flexfield column
1051 * @param p_pji_attribute19 Descriptive flexfield column
1052 * @param p_pji_attribute20 Descriptive flexfield column
1053 * @param p_pji_attribute21 Descriptive flexfield column
1054 * @param p_pji_attribute22 Descriptive flexfield column
1055 * @param p_pji_attribute23 Descriptive flexfield column
1056 * @param p_pji_attribute24 Descriptive flexfield column
1057 * @param p_pji_attribute25 Descriptive flexfield column
1058 * @param p_pji_attribute26 Descriptive flexfield column
1059 * @param p_pji_attribute27 Descriptive flexfield column
1060 * @param p_pji_attribute28 Descriptive flexfield column
1061 * @param p_pji_attribute29 Descriptive flexfield column
1062 * @param p_pji_attribute30 Descriptive flexfield column
1063 * @param p_pji_information_category Developer descriptive flexfield structure
1064 * defining column
1065 * @param p_pji_information1 Developer descriptive flexfield column
1066 * @param p_pji_information2 Developer descriptive flexfield column
1067 * @param p_pji_information3 Developer descriptive flexfield column
1068 * @param p_pji_information4 Developer descriptive flexfield column
1069 * @param p_pji_information5 Developer descriptive flexfield column
1070 * @param p_pji_information6 Developer descriptive flexfield column
1071 * @param p_pji_information7 Developer descriptive flexfield column
1072 * @param p_pji_information8 Developer descriptive flexfield column
1073 * @param p_pji_information9 Developer descriptive flexfield column
1074 * @param p_pji_information10 Developer descriptive flexfield column
1075 * @param p_pji_information11 Developer descriptive flexfield column
1076 * @param p_pji_information12 Developer descriptive flexfield column
1077 * @param p_pji_information13 Developer descriptive flexfield column
1078 * @param p_pji_information14 Developer descriptive flexfield column
1079 * @param p_pji_information15 Developer descriptive flexfield column
1080 * @param p_pji_information16 Developer descriptive flexfield column
1081 * @param p_pji_information17 Developer descriptive flexfield column
1082 * @param p_pji_information18 Developer descriptive flexfield column
1083 * @param p_pji_information19 Developer descriptive flexfield column
1084 * @param p_pji_information20 Developer descriptive flexfield column
1085 * @param p_pji_information21 Developer descriptive flexfield column
1086 * @param p_pji_information22 Developer descriptive flexfield column
1087 * @param p_pji_information23 Developer descriptive flexfield column
1088 * @param p_pji_information24 Developer descriptive flexfield column
1089 * @param p_pji_information25 Developer descriptive flexfield column
1090 * @param p_pji_information26 Developer descriptive flexfield column
1091 * @param p_pji_information27 Developer descriptive flexfield column
1092 * @param p_pji_information28 Developer descriptive flexfield column
1093 * @param p_pji_information29 Developer descriptive flexfield column
1094 * @param p_pji_information30 Developer descriptive flexfield column
1095 * @param p_previous_job_extra_info_id If p_validate is false, then this
1096 * uniquely identifies the previous job extra information created. If
1097 * p_validate is true, then set to null.
1098 * @param p_object_version_number If p_validate is false, then set to the
1099 * version number of the created previous job information. If p_validate is
1100 * true, then the value will be null.
1101 * @rep:displayname Create Previous Job Extra Information
1102 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
1103 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1104 * @rep:scope public
1105 * @rep:lifecycle active
1106 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1107 */
1108 --
1109 -- {End Of Comments}
1110 --
1111 procedure create_prev_job_extra_info
1112 (p_validate in boolean default false
1113 ,p_previous_job_id in number
1114 ,p_information_type in varchar2 default null
1115 ,p_pji_attribute_category in varchar2 default null
1116 ,p_pji_attribute1 in varchar2 default null
1117 ,p_pji_attribute2 in varchar2 default null
1121 ,p_pji_attribute6 in varchar2 default null
1118 ,p_pji_attribute3 in varchar2 default null
1119 ,p_pji_attribute4 in varchar2 default null
1120 ,p_pji_attribute5 in varchar2 default null
1122 ,p_pji_attribute7 in varchar2 default null
1123 ,p_pji_attribute8 in varchar2 default null
1124 ,p_pji_attribute9 in varchar2 default null
1125 ,p_pji_attribute10 in varchar2 default null
1126 ,p_pji_attribute11 in varchar2 default null
1127 ,p_pji_attribute12 in varchar2 default null
1128 ,p_pji_attribute13 in varchar2 default null
1129 ,p_pji_attribute14 in varchar2 default null
1130 ,p_pji_attribute15 in varchar2 default null
1131 ,p_pji_attribute16 in varchar2 default null
1132 ,p_pji_attribute17 in varchar2 default null
1133 ,p_pji_attribute18 in varchar2 default null
1134 ,p_pji_attribute19 in varchar2 default null
1135 ,p_pji_attribute20 in varchar2 default null
1136 ,p_pji_attribute21 in varchar2 default null
1137 ,p_pji_attribute22 in varchar2 default null
1138 ,p_pji_attribute23 in varchar2 default null
1139 ,p_pji_attribute24 in varchar2 default null
1140 ,p_pji_attribute25 in varchar2 default null
1141 ,p_pji_attribute26 in varchar2 default null
1142 ,p_pji_attribute27 in varchar2 default null
1143 ,p_pji_attribute28 in varchar2 default null
1144 ,p_pji_attribute29 in varchar2 default null
1145 ,p_pji_attribute30 in varchar2 default null
1146 ,p_pji_information_category in varchar2 default null
1147 ,p_pji_information1 in varchar2 default null
1148 ,p_pji_information2 in varchar2 default null
1149 ,p_pji_information3 in varchar2 default null
1150 ,p_pji_information4 in varchar2 default null
1151 ,p_pji_information5 in varchar2 default null
1152 ,p_pji_information6 in varchar2 default null
1153 ,p_pji_information7 in varchar2 default null
1154 ,p_pji_information8 in varchar2 default null
1155 ,p_pji_information9 in varchar2 default null
1156 ,p_pji_information10 in varchar2 default null
1157 ,p_pji_information11 in varchar2 default null
1158 ,p_pji_information12 in varchar2 default null
1159 ,p_pji_information13 in varchar2 default null
1160 ,p_pji_information14 in varchar2 default null
1161 ,p_pji_information15 in varchar2 default null
1162 ,p_pji_information16 in varchar2 default null
1163 ,p_pji_information17 in varchar2 default null
1164 ,p_pji_information18 in varchar2 default null
1165 ,p_pji_information19 in varchar2 default null
1166 ,p_pji_information20 in varchar2 default null
1167 ,p_pji_information21 in varchar2 default null
1168 ,p_pji_information22 in varchar2 default null
1169 ,p_pji_information23 in varchar2 default null
1170 ,p_pji_information24 in varchar2 default null
1171 ,p_pji_information25 in varchar2 default null
1172 ,p_pji_information26 in varchar2 default null
1173 ,p_pji_information27 in varchar2 default null
1174 ,p_pji_information28 in varchar2 default null
1175 ,p_pji_information29 in varchar2 default null
1176 ,p_pji_information30 in varchar2 default null
1177 ,p_previous_job_extra_info_id out nocopy number
1178 ,p_object_version_number out nocopy number
1179 );
1180 --
1181 -- ----------------------------------------------------------------------------
1182 -- |------------------------< update_prev_job_extra_info >--------------------|
1183 -- ----------------------------------------------------------------------------
1184 --
1185 -- {Start Of Comments}
1186 /*#
1187 * This API updates extra information for a previous job.
1188 *
1189 * The type of information the process captures will vary, depending on the
1190 * legislation of the person's business group.
1191 *
1192 * <p><b>Licensing</b><br>
1193 * This API is licensed for use with Human Resources.
1194 *
1195 * <p><b>Prerequisites</b><br>
1196 * Extra information for the previous job must exist.
1197 *
1198 * <p><b>Post Success</b><br>
1199 * Extra information is updated for this previous job.
1200 *
1201 * <p><b>Post Failure</b><br>
1202 * Extra information is not updated for this previous job and an error will be
1203 * raised.
1204 * @param p_validate If true, then validation alone will be performed and the
1205 * database will remain unchanged. If false and all validation checks pass,
1206 * then the database will be modified.
1207 * @param p_previous_job_id Uniquely identifies the previous job for which this
1208 * extra information will be updated. Cannot be updated.
1209 * @param p_information_type The type of information being captured. Valid
1210 * values are stored in the column PER_PREV_INFO_TYPES.INFORMATION_TYPE.
1211 * @param p_pji_attribute_category Descriptive flexfield structure defining
1212 * column.
1213 * @param p_pji_attribute1 Descriptive flexfield column
1214 * @param p_pji_attribute2 Descriptive flexfield column
1215 * @param p_pji_attribute3 Descriptive flexfield column
1219 * @param p_pji_attribute7 Descriptive flexfield column
1216 * @param p_pji_attribute4 Descriptive flexfield column
1217 * @param p_pji_attribute5 Descriptive flexfield column
1218 * @param p_pji_attribute6 Descriptive flexfield column
1220 * @param p_pji_attribute8 Descriptive flexfield column
1221 * @param p_pji_attribute9 Descriptive flexfield column
1222 * @param p_pji_attribute10 Descriptive flexfield column
1223 * @param p_pji_attribute11 Descriptive flexfield column
1224 * @param p_pji_attribute12 Descriptive flexfield column
1225 * @param p_pji_attribute13 Descriptive flexfield column
1226 * @param p_pji_attribute14 Descriptive flexfield column
1227 * @param p_pji_attribute15 Descriptive flexfield column
1228 * @param p_pji_attribute16 Descriptive flexfield column
1229 * @param p_pji_attribute17 Descriptive flexfield column
1230 * @param p_pji_attribute18 Descriptive flexfield column
1231 * @param p_pji_attribute19 Descriptive flexfield column
1232 * @param p_pji_attribute20 Descriptive flexfield column
1233 * @param p_pji_attribute21 Descriptive flexfield column
1234 * @param p_pji_attribute22 Descriptive flexfield column
1235 * @param p_pji_attribute23 Descriptive flexfield column
1236 * @param p_pji_attribute24 Descriptive flexfield column
1237 * @param p_pji_attribute25 Descriptive flexfield column
1238 * @param p_pji_attribute26 Descriptive flexfield column
1239 * @param p_pji_attribute27 Descriptive flexfield column
1240 * @param p_pji_attribute28 Descriptive flexfield column
1241 * @param p_pji_attribute29 Descriptive flexfield column
1242 * @param p_pji_attribute30 Descriptive flexfield column
1243 * @param p_pji_information_category Developer Descriptive structure defining
1244 * column.
1245 * @param p_pji_information1 Developer Descriptive flexfield column
1246 * @param p_pji_information2 Developer Descriptive flexfield column
1247 * @param p_pji_information3 Developer Descriptive flexfield column
1248 * @param p_pji_information4 Developer Descriptive flexfield column
1249 * @param p_pji_information5 Developer Descriptive flexfield column
1250 * @param p_pji_information6 Developer Descriptive flexfield column
1251 * @param p_pji_information7 Developer Descriptive flexfield column
1252 * @param p_pji_information8 Developer Descriptive flexfield column
1253 * @param p_pji_information9 Developer Descriptive flexfield column
1254 * @param p_pji_information10 Developer Descriptive flexfield column
1255 * @param p_pji_information11 Developer Descriptive flexfield column
1256 * @param p_pji_information12 Developer Descriptive flexfield column
1257 * @param p_pji_information13 Developer Descriptive flexfield column
1258 * @param p_pji_information14 Developer Descriptive flexfield column
1259 * @param p_pji_information15 Developer Descriptive flexfield column
1260 * @param p_pji_information16 Developer Descriptive flexfield column
1261 * @param p_pji_information17 Developer Descriptive flexfield column
1262 * @param p_pji_information18 Developer Descriptive flexfield column
1263 * @param p_pji_information19 Developer Descriptive flexfield column
1264 * @param p_pji_information20 Developer Descriptive flexfield column
1265 * @param p_pji_information21 Developer Descriptive flexfield column
1266 * @param p_pji_information22 Developer Descriptive flexfield column
1267 * @param p_pji_information23 Developer Descriptive flexfield column
1268 * @param p_pji_information24 Developer Descriptive flexfield column
1269 * @param p_pji_information25 Developer Descriptive flexfield column
1270 * @param p_pji_information26 Developer Descriptive flexfield column
1271 * @param p_pji_information27 Developer Descriptive flexfield column
1272 * @param p_pji_information28 Developer Descriptive flexfield column
1273 * @param p_pji_information29 Developer Descriptive flexfield column
1274 * @param p_pji_information30 Developer Descriptive flexfield column
1275 * @param p_previous_job_extra_info_id Uniquely identifies the extra
1276 * information record to be updated.
1277 * @param p_object_version_number Pass in the current version number of the
1278 * previous job extra information to be updated. When the API completes if
1279 * p_validate is false, will be set to the new version number of the updated
1280 * previous job extra information. If p_validate is true will be set to the
1281 * same value which was passed in.
1282 * @rep:displayname Update Previous Job Extra Information
1283 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
1284 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1285 * @rep:scope public
1286 * @rep:lifecycle active
1287 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1288 */
1289 --
1290 -- {End Of Comments}
1291 --
1292 procedure update_prev_job_extra_info
1293 (p_validate in boolean default false
1294 ,p_previous_job_id in number
1295 ,p_information_type in varchar2 default hr_api.g_varchar2
1296 ,p_pji_attribute_category in varchar2 default hr_api.g_varchar2
1297 ,p_pji_attribute1 in varchar2 default hr_api.g_varchar2
1298 ,p_pji_attribute2 in varchar2 default hr_api.g_varchar2
1299 ,p_pji_attribute3 in varchar2 default hr_api.g_varchar2
1300 ,p_pji_attribute4 in varchar2 default hr_api.g_varchar2
1301 ,p_pji_attribute5 in varchar2 default hr_api.g_varchar2
1302 ,p_pji_attribute6 in varchar2 default hr_api.g_varchar2
1303 ,p_pji_attribute7 in varchar2 default hr_api.g_varchar2
1304 ,p_pji_attribute8 in varchar2 default hr_api.g_varchar2
1305 ,p_pji_attribute9 in varchar2 default hr_api.g_varchar2
1306 ,p_pji_attribute10 in varchar2 default hr_api.g_varchar2
1310 ,p_pji_attribute14 in varchar2 default hr_api.g_varchar2
1307 ,p_pji_attribute11 in varchar2 default hr_api.g_varchar2
1308 ,p_pji_attribute12 in varchar2 default hr_api.g_varchar2
1309 ,p_pji_attribute13 in varchar2 default hr_api.g_varchar2
1311 ,p_pji_attribute15 in varchar2 default hr_api.g_varchar2
1312 ,p_pji_attribute16 in varchar2 default hr_api.g_varchar2
1313 ,p_pji_attribute17 in varchar2 default hr_api.g_varchar2
1314 ,p_pji_attribute18 in varchar2 default hr_api.g_varchar2
1315 ,p_pji_attribute19 in varchar2 default hr_api.g_varchar2
1316 ,p_pji_attribute20 in varchar2 default hr_api.g_varchar2
1317 ,p_pji_attribute21 in varchar2 default hr_api.g_varchar2
1318 ,p_pji_attribute22 in varchar2 default hr_api.g_varchar2
1319 ,p_pji_attribute23 in varchar2 default hr_api.g_varchar2
1320 ,p_pji_attribute24 in varchar2 default hr_api.g_varchar2
1321 ,p_pji_attribute25 in varchar2 default hr_api.g_varchar2
1322 ,p_pji_attribute26 in varchar2 default hr_api.g_varchar2
1323 ,p_pji_attribute27 in varchar2 default hr_api.g_varchar2
1324 ,p_pji_attribute28 in varchar2 default hr_api.g_varchar2
1325 ,p_pji_attribute29 in varchar2 default hr_api.g_varchar2
1326 ,p_pji_attribute30 in varchar2 default hr_api.g_varchar2
1327 ,p_pji_information_category in varchar2 default hr_api.g_varchar2
1328 ,p_pji_information1 in varchar2 default hr_api.g_varchar2
1329 ,p_pji_information2 in varchar2 default hr_api.g_varchar2
1330 ,p_pji_information3 in varchar2 default hr_api.g_varchar2
1331 ,p_pji_information4 in varchar2 default hr_api.g_varchar2
1332 ,p_pji_information5 in varchar2 default hr_api.g_varchar2
1333 ,p_pji_information6 in varchar2 default hr_api.g_varchar2
1334 ,p_pji_information7 in varchar2 default hr_api.g_varchar2
1335 ,p_pji_information8 in varchar2 default hr_api.g_varchar2
1336 ,p_pji_information9 in varchar2 default hr_api.g_varchar2
1337 ,p_pji_information10 in varchar2 default hr_api.g_varchar2
1338 ,p_pji_information11 in varchar2 default hr_api.g_varchar2
1339 ,p_pji_information12 in varchar2 default hr_api.g_varchar2
1340 ,p_pji_information13 in varchar2 default hr_api.g_varchar2
1341 ,p_pji_information14 in varchar2 default hr_api.g_varchar2
1342 ,p_pji_information15 in varchar2 default hr_api.g_varchar2
1343 ,p_pji_information16 in varchar2 default hr_api.g_varchar2
1344 ,p_pji_information17 in varchar2 default hr_api.g_varchar2
1345 ,p_pji_information18 in varchar2 default hr_api.g_varchar2
1346 ,p_pji_information19 in varchar2 default hr_api.g_varchar2
1347 ,p_pji_information20 in varchar2 default hr_api.g_varchar2
1348 ,p_pji_information21 in varchar2 default hr_api.g_varchar2
1349 ,p_pji_information22 in varchar2 default hr_api.g_varchar2
1350 ,p_pji_information23 in varchar2 default hr_api.g_varchar2
1351 ,p_pji_information24 in varchar2 default hr_api.g_varchar2
1352 ,p_pji_information25 in varchar2 default hr_api.g_varchar2
1353 ,p_pji_information26 in varchar2 default hr_api.g_varchar2
1354 ,p_pji_information27 in varchar2 default hr_api.g_varchar2
1355 ,p_pji_information28 in varchar2 default hr_api.g_varchar2
1356 ,p_pji_information29 in varchar2 default hr_api.g_varchar2
1357 ,p_pji_information30 in varchar2 default hr_api.g_varchar2
1358 ,p_previous_job_extra_info_id in number
1359 ,p_object_version_number in out nocopy number
1360 );
1361 --
1362 -- ----------------------------------------------------------------------------
1363 -- |------------------------< delete_prev_job_extra_info >--------------------|
1364 -- ----------------------------------------------------------------------------
1365 --
1366 -- {Start Of Comments}
1367 /*#
1368 * This API deletes extra information for a previous job.
1369 *
1370 *
1371 * <p><b>Licensing</b><br>
1372 * This API is licensed for use with Human Resources.
1373 *
1374 * <p><b>Prerequisites</b><br>
1375 * Extra information for the previous job must exist.
1376 *
1377 * <p><b>Post Success</b><br>
1378 * Extra information is deleted for this previous job.
1379 *
1380 * <p><b>Post Failure</b><br>
1381 * Extra information is not deleted for this previous job and an error will be
1382 * raised.
1383 * @param p_validate If true, then validation alone will be performed and the
1384 * database will remain unchanged. If false and all validation checks pass,
1385 * then the database will be modified.
1386 * @param p_previous_job_extra_info_id Uniquely identifies the previous job
1387 * extra information record to be deleted.
1388 * @param p_object_version_number Current version number of the previous job
1389 * extra information to be deleted.
1390 * @rep:displayname Delete Previous Job Extra Information
1391 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
1392 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1393 * @rep:scope public
1394 * @rep:lifecycle active
1395 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1396 */
1397 --
1398 -- {End Of Comments}
1399 --
1400 procedure delete_prev_job_extra_info
1401 (p_validate in boolean
1402 ,p_previous_job_extra_info_id in number
1403 ,p_object_version_number in out nocopy number
1404 );
1405 --
1409 --
1406 -- ----------------------------------------------------------------------------
1407 -- |------------------------< create_previous_job_usage >---------------------|
1408 -- ----------------------------------------------------------------------------
1410 -- {Start Of Comments}
1411 /*#
1412 * This API creates a previous job usage.
1413 *
1414 * A job usage record stores information about which previous job records (and
1415 * which durations of time worked on previous jobs) apply to which of the
1416 * employee's current assignments. Job usage applies mainly to public sector
1417 * enterprises that enforce strict rules for grade step progression based on
1418 * previous periods of employment. For example, an employee's past teaching
1419 * experience may only be relevant to the employee's primary assignment.
1420 *
1421 * <p><b>Licensing</b><br>
1422 * This API is licensed for use with Human Resources.
1423 *
1424 * <p><b>Prerequisites</b><br>
1425 * The person must have a previous job with a previous employer. The previous
1426 * employer must have the 'Applies to all assignments' flag set to 'N'.
1427 *
1428 * <p><b>Post Success</b><br>
1429 * A previous job usage is created.
1430 *
1431 * <p><b>Post Failure</b><br>
1432 * A previous job is not created and an error will be raised.
1433 * @param p_validate If true, then validation alone will be performed and the
1434 * database will remain unchanged. If false and all validation checks pass,
1435 * then the database will be modified.
1436 * @param p_assignment_id Indicates which assigment record this previous period
1437 * of employment is relevant to.
1438 * @param p_previous_employer_id Uniquely identifies the employer associated
1439 * with the previous job.
1440 * @param p_previous_job_id Uniquely indicates which previous job is relevant
1441 * to the specified assignment. If you do not specify a value, the process
1442 * assumes that all previous jobs are relevant to the specified assignment.
1443 * @param p_start_date The start date of the period of service in the previous
1444 * job relevant to the specified assignment. If left null, the process assumes
1445 * that the start date of either the parent previous job or previous employment
1446 * is relevant to the assigment.
1447 * @param p_end_date The end date of the period of service for the previous job
1448 * relevant to the specified assignment. If left null, the process assumes that
1449 * the end date of either the parent previous job or the previous employment is
1450 * relevant to the assigment.
1451 * @param p_period_years The number of years of previous employment time
1452 * relevant to the specified assignment. If left null, the process calculates
1453 * this based on the start date and end date. For example, if the start date is
1454 * '01-JAN-2000' and the end date is '05-MAR-2004', the process sets four
1455 * years.
1456 * @param p_period_months The number of months of previous employment time
1457 * relevant to the specified assignment, over and above years. If left null,
1458 * the process calculates this from the start and end date. For example, if the
1459 * start date is '01-JAN-2000' and the end date is '05-MAR-2004', the process
1460 * sets two months.
1461 * @param p_period_days The number of days of previous employment time relevant
1462 * to the specified assignment, over and above years and months. If left null,
1463 * the process calculates this from the start and end date. For example, if the
1464 * start date is '01-JAN-2000' and the end date is '05-MAR-2004', the process
1465 * sets five days.
1466 * @param p_pju_attribute_category Descriptive flexfield structure defining
1467 * column.
1468 * @param p_pju_attribute1 Descriptive flexfield column
1469 * @param p_pju_attribute2 Descriptive flexfield column
1470 * @param p_pju_attribute3 Descriptive flexfield column
1471 * @param p_pju_attribute4 Descriptive flexfield column
1472 * @param p_pju_attribute5 Descriptive flexfield column
1473 * @param p_pju_attribute6 Descriptive flexfield column
1474 * @param p_pju_attribute7 Descriptive flexfield column
1475 * @param p_pju_attribute8 Descriptive flexfield column
1476 * @param p_pju_attribute9 Descriptive flexfield column
1477 * @param p_pju_attribute10 Descriptive flexfield column
1478 * @param p_pju_attribute11 Descriptive flexfield column
1479 * @param p_pju_attribute12 Descriptive flexfield column
1480 * @param p_pju_attribute13 Descriptive flexfield column
1481 * @param p_pju_attribute14 Descriptive flexfield column
1482 * @param p_pju_attribute15 Descriptive flexfield column
1483 * @param p_pju_attribute16 Descriptive flexfield column
1484 * @param p_pju_attribute17 Descriptive flexfield column
1485 * @param p_pju_attribute18 Descriptive flexfield column
1486 * @param p_pju_attribute19 Descriptive flexfield column
1487 * @param p_pju_attribute20 Descriptive flexfield column
1488 * @param p_pju_information_category Developer Descriptive flexfield structure
1489 * defining column.
1490 * @param p_pju_information1 Developer Descriptive flexfield column
1491 * @param p_pju_information2 Developer Descriptive flexfield column
1492 * @param p_pju_information3 Developer Descriptive flexfield column
1493 * @param p_pju_information4 Developer Descriptive flexfield column
1494 * @param p_pju_information5 Developer Descriptive flexfield column
1495 * @param p_pju_information6 Developer Descriptive flexfield column
1496 * @param p_pju_information7 Developer Descriptive flexfield column
1497 * @param p_pju_information8 Developer Descriptive flexfield column
1498 * @param p_pju_information9 Developer Descriptive flexfield column
1499 * @param p_pju_information10 Developer Descriptive flexfield column
1500 * @param p_pju_information11 Developer Descriptive flexfield column
1501 * @param p_pju_information12 Developer Descriptive flexfield column
1505 * @param p_pju_information16 Developer Descriptive flexfield column
1502 * @param p_pju_information13 Developer Descriptive flexfield column
1503 * @param p_pju_information14 Developer Descriptive flexfield column
1504 * @param p_pju_information15 Developer Descriptive flexfield column
1506 * @param p_pju_information17 Developer Descriptive flexfield column
1507 * @param p_pju_information18 Developer Descriptive flexfield column
1508 * @param p_pju_information19 Developer Descriptive flexfield column
1509 * @param p_pju_information20 Developer Descriptive flexfield column
1510 * @param p_previous_job_usage_id If p_validate is false, then this uniquely
1511 * identifies the previous job usage created. If p_validate is true, then set
1512 * to null.
1513 * @param p_object_version_number If p_validate is false, then set to the
1514 * version number of the created previous job usage. If p_validate is true,
1515 * then the value will be null.
1516 * @rep:displayname Create Previous Job Usage
1517 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
1518 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1519 * @rep:scope public
1520 * @rep:lifecycle active
1521 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1522 */
1523 --
1524 -- {End Of Comments}
1525 --
1526 procedure create_previous_job_usage
1527 (p_validate in boolean
1528 ,p_assignment_id in number
1529 ,p_previous_employer_id in number
1530 ,p_previous_job_id in number
1531 ,p_start_date in date default null
1532 ,p_end_date in date default null
1533 ,p_period_years in number default null
1534 ,p_period_months in number default null
1535 ,p_period_days in number default null
1536 ,p_pju_attribute_category in varchar2 default null
1537 ,p_pju_attribute1 in varchar2 default null
1538 ,p_pju_attribute2 in varchar2 default null
1539 ,p_pju_attribute3 in varchar2 default null
1540 ,p_pju_attribute4 in varchar2 default null
1541 ,p_pju_attribute5 in varchar2 default null
1542 ,p_pju_attribute6 in varchar2 default null
1543 ,p_pju_attribute7 in varchar2 default null
1544 ,p_pju_attribute8 in varchar2 default null
1545 ,p_pju_attribute9 in varchar2 default null
1546 ,p_pju_attribute10 in varchar2 default null
1547 ,p_pju_attribute11 in varchar2 default null
1548 ,p_pju_attribute12 in varchar2 default null
1549 ,p_pju_attribute13 in varchar2 default null
1550 ,p_pju_attribute14 in varchar2 default null
1551 ,p_pju_attribute15 in varchar2 default null
1552 ,p_pju_attribute16 in varchar2 default null
1553 ,p_pju_attribute17 in varchar2 default null
1554 ,p_pju_attribute18 in varchar2 default null
1555 ,p_pju_attribute19 in varchar2 default null
1556 ,p_pju_attribute20 in varchar2 default null
1557 ,p_pju_information_category in varchar2 default null
1558 ,p_pju_information1 in varchar2 default null
1559 ,p_pju_information2 in varchar2 default null
1560 ,p_pju_information3 in varchar2 default null
1561 ,p_pju_information4 in varchar2 default null
1562 ,p_pju_information5 in varchar2 default null
1563 ,p_pju_information6 in varchar2 default null
1564 ,p_pju_information7 in varchar2 default null
1565 ,p_pju_information8 in varchar2 default null
1566 ,p_pju_information9 in varchar2 default null
1567 ,p_pju_information10 in varchar2 default null
1568 ,p_pju_information11 in varchar2 default null
1569 ,p_pju_information12 in varchar2 default null
1570 ,p_pju_information13 in varchar2 default null
1571 ,p_pju_information14 in varchar2 default null
1572 ,p_pju_information15 in varchar2 default null
1573 ,p_pju_information16 in varchar2 default null
1574 ,p_pju_information17 in varchar2 default null
1575 ,p_pju_information18 in varchar2 default null
1576 ,p_pju_information19 in varchar2 default null
1577 ,p_pju_information20 in varchar2 default null
1578 ,p_previous_job_usage_id out nocopy number
1579 ,p_object_version_number out nocopy number
1580 );
1581 --
1582 -- ----------------------------------------------------------------------------
1583 -- |------------------------< update_previous_job_usage >---------------------|
1584 -- ----------------------------------------------------------------------------
1585 --
1586 -- {Start Of Comments}
1587 /*#
1588 * This API updates a previous job usage.
1589 *
1590 * A job usage record stores information about which previous job records (and
1591 * which durations of time worked on previous jobs) apply to which of the
1592 * employee's current assignments. Job usage applies mainly to public sector
1593 * enterprises that enforce strict rules for grade step progression based on
1594 * previous periods of employment. For example, an employee's past teaching
1595 * experience may only be relevant to the employee's primary assignment.
1596 *
1597 * <p><b>Licensing</b><br>
1601 * A previous job usage must exist.
1598 * This API is licensed for use with Human Resources.
1599 *
1600 * <p><b>Prerequisites</b><br>
1602 *
1603 * <p><b>Post Success</b><br>
1604 * The previous job usage is updated
1605 *
1606 * <p><b>Post Failure</b><br>
1607 * The previous job usage is not updated and an error will be raised.
1608 * @param p_validate If true, then validation alone will be performed and the
1609 * database will remain unchanged. If false and all validation checks pass,
1610 * then the database will be modified.
1611 * @param p_previous_job_usage_id Uniquely identifies the previous job usage to
1612 * be updated.
1613 * @param p_assignment_id Indicates which assigment record this previous period
1614 * of employment is relevant to.
1615 * @param p_previous_employer_id Uniquely identifies the employer associated
1616 * with the previous job.
1617 * @param p_previous_job_id Uniquely indicates which previous job is relevant
1618 * to the specified assignment. If you do not specify a value, the process
1619 * assumes that all previous jobs are relevant to the specified assignment.
1620 * @param p_start_date The start date of the period of service in the previous
1621 * job relevant to the specified assignment. If left null, the process assumes
1622 * that the start date of either the parent previous job or previous employment
1623 * is relevant to the assigment.
1624 * @param p_end_date The end date of the period of service for the previous job
1625 * relevant to the specified assignment. If left null, the process assumes that
1626 * the end date of either the parent previous job or the previous employment is
1627 * relevant to the assigment.
1628 * @param p_period_years The number of years of previous employment time
1629 * relevant to the specified assignment. If left null, the process calculates
1630 * this based on the start date and end date. For example, if the start date is
1631 * '01-JAN-2000' and the end date is '05-MAR-2004', the process sets four
1632 * years.
1633 * @param p_period_months The number of months of previous employment time
1634 * relevant to the specified assignment, over and above years. If left null,
1635 * the process calculates this from the start and end date. For example, if the
1636 * start date is '01-JAN-2000' and the end date is '05-MAR-2004', the process
1637 * sets two months.
1638 * @param p_period_days The number of days of previous employment time relevant
1639 * to the specified assignment, over and above years and months. If left null,
1640 * the process calculates this from the start and end date. For example, if the
1641 * start date is '01-JAN-2000' and the end date is '05-MAR-2004', the process
1642 * sets five days.
1643 * @param p_pju_attribute_category Descriptive flexfield structure defining
1644 * column.
1645 * @param p_pju_attribute1 Descriptive flexfield column
1646 * @param p_pju_attribute2 Descriptive flexfield column
1647 * @param p_pju_attribute3 Descriptive flexfield column
1648 * @param p_pju_attribute4 Descriptive flexfield column
1649 * @param p_pju_attribute5 Descriptive flexfield column
1650 * @param p_pju_attribute6 Descriptive flexfield column
1651 * @param p_pju_attribute7 Descriptive flexfield column
1652 * @param p_pju_attribute8 Descriptive flexfield column
1653 * @param p_pju_attribute9 Descriptive flexfield column
1654 * @param p_pju_attribute10 Descriptive flexfield column
1655 * @param p_pju_attribute11 Descriptive flexfield column
1656 * @param p_pju_attribute12 Descriptive flexfield column
1657 * @param p_pju_attribute13 Descriptive flexfield column
1658 * @param p_pju_attribute14 Descriptive flexfield column
1659 * @param p_pju_attribute15 Descriptive flexfield column
1660 * @param p_pju_attribute16 Descriptive flexfield column
1661 * @param p_pju_attribute17 Descriptive flexfield column
1662 * @param p_pju_attribute18 Descriptive flexfield column
1663 * @param p_pju_attribute19 Descriptive flexfield column
1664 * @param p_pju_attribute20 Descriptive flexfield column
1665 * @param p_pju_information_category Developer Descriptive flexfield structure
1666 * defining column.
1667 * @param p_pju_information1 Developer Descriptive flexfield column
1668 * @param p_pju_information2 Developer Descriptive flexfield column
1669 * @param p_pju_information3 Developer Descriptive flexfield column
1670 * @param p_pju_information4 Developer Descriptive flexfield column
1671 * @param p_pju_information5 Developer Descriptive flexfield column
1672 * @param p_pju_information6 Developer Descriptive flexfield column
1673 * @param p_pju_information7 Developer Descriptive flexfield column
1674 * @param p_pju_information8 Developer Descriptive flexfield column
1675 * @param p_pju_information9 Developer Descriptive flexfield column
1676 * @param p_pju_information10 Developer Descriptive flexfield column
1677 * @param p_pju_information11 Developer Descriptive flexfield column
1678 * @param p_pju_information12 Developer Descriptive flexfield column
1679 * @param p_pju_information13 Developer Descriptive flexfield column
1680 * @param p_pju_information14 Developer Descriptive flexfield column
1681 * @param p_pju_information15 Developer Descriptive flexfield column
1682 * @param p_pju_information16 Developer Descriptive flexfield column
1683 * @param p_pju_information17 Developer Descriptive flexfield column
1684 * @param p_pju_information18 Developer Descriptive flexfield column
1685 * @param p_pju_information19 Developer Descriptive flexfield column
1686 * @param p_pju_information20 Developer Descriptive flexfield column
1687 * @param p_object_version_number Pass in the current version number of the
1688 * previous job usage to be updated. When the API completes if p_validate is
1689 * false, will be set to the new version number of the updated previous job
1693 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
1690 * usage. If p_validate is true will be set to the same value which was passed
1691 * in.
1692 * @rep:displayname Update Previous Job Usage
1694 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1695 * @rep:scope public
1696 * @rep:lifecycle active
1697 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1698 */
1699 --
1700 -- {End Of Comments}
1701 --
1702 procedure update_previous_job_usage
1703 (p_validate in boolean
1704 ,p_previous_job_usage_id in number
1705 ,p_assignment_id in number
1706 ,p_previous_employer_id in number
1707 ,p_previous_job_id in number
1708 ,p_start_date in date default hr_api.g_date
1709 ,p_end_date in date default hr_api.g_date
1710 ,p_period_years in number default hr_api.g_number
1711 ,p_period_months in number default hr_api.g_number
1712 ,p_period_days in number default hr_api.g_number
1713 ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
1714 ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
1715 ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
1716 ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
1717 ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
1718 ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
1719 ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
1720 ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
1721 ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
1722 ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
1723 ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
1724 ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
1725 ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
1726 ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
1727 ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
1728 ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
1729 ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
1730 ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
1731 ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
1732 ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
1733 ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
1734 ,p_pju_information_category in varchar2 default hr_api.g_varchar2
1735 ,p_pju_information1 in varchar2 default hr_api.g_varchar2
1736 ,p_pju_information2 in varchar2 default hr_api.g_varchar2
1737 ,p_pju_information3 in varchar2 default hr_api.g_varchar2
1738 ,p_pju_information4 in varchar2 default hr_api.g_varchar2
1739 ,p_pju_information5 in varchar2 default hr_api.g_varchar2
1740 ,p_pju_information6 in varchar2 default hr_api.g_varchar2
1741 ,p_pju_information7 in varchar2 default hr_api.g_varchar2
1742 ,p_pju_information8 in varchar2 default hr_api.g_varchar2
1743 ,p_pju_information9 in varchar2 default hr_api.g_varchar2
1744 ,p_pju_information10 in varchar2 default hr_api.g_varchar2
1745 ,p_pju_information11 in varchar2 default hr_api.g_varchar2
1746 ,p_pju_information12 in varchar2 default hr_api.g_varchar2
1747 ,p_pju_information13 in varchar2 default hr_api.g_varchar2
1748 ,p_pju_information14 in varchar2 default hr_api.g_varchar2
1749 ,p_pju_information15 in varchar2 default hr_api.g_varchar2
1750 ,p_pju_information16 in varchar2 default hr_api.g_varchar2
1751 ,p_pju_information17 in varchar2 default hr_api.g_varchar2
1752 ,p_pju_information18 in varchar2 default hr_api.g_varchar2
1753 ,p_pju_information19 in varchar2 default hr_api.g_varchar2
1754 ,p_pju_information20 in varchar2 default hr_api.g_varchar2
1755 ,p_object_version_number in out nocopy number
1756 );
1757 --
1758 -- ----------------------------------------------------------------------------
1759 -- |------------------------< delete_previous_job_usage >---------------------|
1760 -- ----------------------------------------------------------------------------
1761 --
1762 -- {Start Of Comments}
1763 /*#
1764 * This API deletes a previous job usage.
1765 *
1766 *
1767 * <p><b>Licensing</b><br>
1768 * This API is licensed for use with Human Resources.
1769 *
1770 * <p><b>Prerequisites</b><br>
1771 * A previous job usage must exist.
1772 *
1773 * <p><b>Post Success</b><br>
1774 * The previous job usage is deleted.
1775 *
1776 * <p><b>Post Failure</b><br>
1777 * The previous job usage is not deleted and an error will be raised.
1778 * @param p_validate If true, then validation alone will be performed and the
1779 * database will remain unchanged. If false and all validation checks pass,
1780 * then the database will be modified.
1781 * @param p_previous_job_usage_id Uniquely identifies the previous job usage to
1782 * be deleted.
1783 * @param p_object_version_number Current version number of the previous job
1784 * usage to be deleted.
1785 * @rep:displayname Delete Previous Job Usage
1786 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
1787 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1788 * @rep:scope public
1789 * @rep:lifecycle active
1790 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1791 */
1792 --
1793 -- {End Of Comments}
1794 --
1795 procedure delete_previous_job_usage
1796 (p_validate in boolean
1797 ,p_previous_job_usage_id in number
1798 ,p_object_version_number in out nocopy number
1799 );
1800 --
1801
1802 --
1803 end hr_previous_employment_api;
[Home] [Help]