1 Package hr_pl_previous_employment_api as
2 /* $Header: pepempli.pkh 120.1 2005/10/02 02:43:48 aroussel $ */
3 /*#
4 * This package contains previous employment APIs.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Previous Employment for Poland
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_pl_previous_employer >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates previous employer.
17 *
18 * This API is effectively an alternative to the API create_previous_employer.
19 * If p_validate is set to false, a previous employer is created.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources.
23 *
24 * <p><b>Prerequisites</b><br>
25 * The employee must already exist.
26 *
27 * <p><b>Post Success</b><br>
28 * The previous employer will be successfully inserted into the database.
29 *
30 * <p><b>Post Failure</b><br>
31 * The previous employer will not be created and an error will be raised.
32 *
33 * @param p_effective_date Reference date for validating lookup values are
34 * applicable during the start to end active date range. This date does not
35 * determine when the changes take effect.
36 * @param p_validate If true, then validation alone will be performed and the
37 * database will remain unchanged. If false and all validation checks pass,
38 * then the database will be modified.
39 * @param p_business_group_id ID of person's business group.
40 * @param p_person_id Identifies the person for whom you create the previous
41 * employer record.
42 * @param p_party_id Party ID.
43 * @param p_start_date The date from which the employee worked with the
44 * previous employer. This field is mandatory if employer type is 'Parallel'.
45 * @param p_end_date The date on which the employee left the previous employer.
46 * @param p_period_years Number of years the employee worked. This is
47 * calculated based on the start date and the end date.
48 * @param p_period_months Number of months the employee worked. This is
49 * calculated based on the start date and end date.
50 * @param p_period_days Remaining number of days and is calculated from period
51 * days.
52 * @param p_employer_name Previous employer name.
53 * @param p_employer_country The country in which the previous employer is
54 * located.
55 * @param p_employer_address Address of the previous employer.
56 * @param p_employer_type Type of previous employer. Valid values are defined
57 * by PREV_EMP_TYPE lookup type.
58 * @param p_employer_subtype Subtype of the previous employer. This is
59 * dependent on employer type. Valid values are defined by PREV_EMP_SUBTYPE
60 * lookup type.
61 * @param p_description Description of the previous employer.
62 * @param p_all_assignments Indicates whether previous employer is applicable
63 * to all assignments of the current employer.
64 * @param p_pem_attribute_category This context value determines which
65 * flexfield structure to use with the descriptive flexfield columns.
66 * @param p_pem_attribute1 Descriptive flexfield column.
67 * @param p_pem_attribute2 Descriptive flexfield column.
68 * @param p_pem_attribute3 Descriptive flexfield column.
69 * @param p_pem_attribute4 Descriptive flexfield column.
70 * @param p_pem_attribute5 Descriptive flexfield column.
71 * @param p_pem_attribute6 Descriptive flexfield column.
72 * @param p_pem_attribute7 Descriptive flexfield column.
73 * @param p_pem_attribute8 Descriptive flexfield column.
74 * @param p_pem_attribute9 Descriptive flexfield column.
75 * @param p_pem_attribute10 Descriptive flexfield column.
76 * @param p_pem_attribute11 Descriptive flexfield column.
77 * @param p_pem_attribute12 Descriptive flexfield column.
78 * @param p_pem_attribute13 Descriptive flexfield column.
79 * @param p_pem_attribute14 Descriptive flexfield column.
80 * @param p_pem_attribute15 Descriptive flexfield column.
81 * @param p_pem_attribute16 Descriptive flexfield column.
82 * @param p_pem_attribute17 Descriptive flexfield column.
83 * @param p_pem_attribute18 Descriptive flexfield column.
84 * @param p_pem_attribute19 Descriptive flexfield column.
85 * @param p_pem_attribute20 Descriptive flexfield column.
86 * @param p_pem_attribute21 Descriptive flexfield column.
87 * @param p_pem_attribute22 Descriptive flexfield column.
88 * @param p_pem_attribute23 Descriptive flexfield column.
89 * @param p_pem_attribute24 Descriptive flexfield column.
90 * @param p_pem_attribute25 Descriptive flexfield column.
91 * @param p_pem_attribute26 Descriptive flexfield column.
92 * @param p_pem_attribute27 Descriptive flexfield column.
93 * @param p_pem_attribute28 Descriptive flexfield column.
94 * @param p_pem_attribute29 Descriptive flexfield column.
95 * @param p_pem_attribute30 Descriptive flexfield column.
96 * @param p_pem_information_category This context value determines which
97 * flexfield structure to use with the developer descriptive flexfield columns.
98 * @param direction_number Direction number of the previous employer.
99 * @param telephone Telephone number of the previous employer.
100 * @param mobile Mobile number of the previous employer.
101 * @param fax Fax number of the previous employer.
102 * @param e_mail Email address of the previous employer.
103 * @param contact_information Additional contact information for previous
104 * employer.
105 * @param p_pem_information7 Developer Descriptive flexfield column.
106 * @param p_pem_information8 Developer Descriptive flexfield column.
107 * @param p_pem_information9 Developer Descriptive flexfield column.
108 * @param p_pem_information10 Developer Descriptive flexfield column.
109 * @param p_pem_information11 Developer Descriptive flexfield column.
110 * @param p_pem_information12 Developer Descriptive flexfield column.
111 * @param p_pem_information13 Developer Descriptive flexfield column.
112 * @param p_pem_information14 Developer Descriptive flexfield column.
113 * @param p_pem_information15 Developer Descriptive flexfield column.
114 * @param p_pem_information16 Developer Descriptive flexfield column.
115 * @param p_pem_information17 Developer Descriptive flexfield column.
116 * @param p_pem_information18 Developer Descriptive flexfield column.
117 * @param p_pem_information19 Developer Descriptive flexfield column.
118 * @param p_pem_information20 Developer Descriptive flexfield column.
119 * @param p_pem_information21 Developer Descriptive flexfield column.
120 * @param p_pem_information22 Developer Descriptive flexfield column.
121 * @param p_pem_information23 Developer Descriptive flexfield column.
122 * @param p_pem_information24 Developer Descriptive flexfield column.
123 * @param p_pem_information25 Developer Descriptive flexfield column.
124 * @param p_pem_information26 Developer Descriptive flexfield column.
125 * @param p_pem_information27 Developer Descriptive flexfield column.
126 * @param p_pem_information28 Developer Descriptive flexfield column.
127 * @param p_pem_information29 Developer Descriptive flexfield column.
128 * @param p_pem_information30 Developer Descriptive flexfield column.
129 * @param p_previous_employer_id If p_validate is false, then this uniquely
130 * identifies the created previous employer. If p_validate is true, then set to
131 * null.
132 * @param p_object_version_number If p_validate is false, then set to the
133 * version number of the created previous employer. If p_validate is true, then
134 * the value will be null.
135 * @rep:displayname Create Previous Employer for Poland
136 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
137 * @rep:lifecycle active
138 * @rep:scope public
139 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
140 */
141 --
142 -- {End Of Comments}
143 --
144 procedure create_pl_previous_employer
145 (
146 p_effective_date IN date
147 ,p_validate IN boolean default false
148 ,p_business_group_id IN number
149 ,p_person_id IN number
150 ,p_party_id IN number default null
151 ,p_start_date IN date default null
152 ,p_end_date IN date default null
153 ,p_period_years IN number default null
154 ,p_period_months IN number default null
155 ,p_period_days IN number default null
156 ,p_employer_name IN varchar2
157 ,p_employer_country IN varchar2 default null
158 ,p_employer_address IN varchar2 default null
159 ,p_employer_type IN varchar2 default null
160 ,p_employer_subtype IN varchar2 default null
161 ,p_description IN varchar2 default null
162 ,p_all_assignments IN varchar2 default 'N'
163 ,p_pem_attribute_category IN varchar2 default null
164 ,p_pem_attribute1 IN varchar2 default null
165 ,p_pem_attribute2 IN varchar2 default null
166 ,p_pem_attribute3 IN varchar2 default null
167 ,p_pem_attribute4 IN varchar2 default null
168 ,p_pem_attribute5 IN varchar2 default null
169 ,p_pem_attribute6 IN varchar2 default null
170 ,p_pem_attribute7 IN varchar2 default null
171 ,p_pem_attribute8 IN varchar2 default null
172 ,p_pem_attribute9 IN varchar2 default null
173 ,p_pem_attribute10 IN varchar2 default null
174 ,p_pem_attribute11 IN varchar2 default null
175 ,p_pem_attribute12 IN varchar2 default null
176 ,p_pem_attribute13 IN varchar2 default null
177 ,p_pem_attribute14 IN varchar2 default null
178 ,p_pem_attribute15 IN varchar2 default null
179 ,p_pem_attribute16 IN varchar2 default null
180 ,p_pem_attribute17 IN varchar2 default null
181 ,p_pem_attribute18 IN varchar2 default null
182 ,p_pem_attribute19 IN varchar2 default null
183 ,p_pem_attribute20 IN varchar2 default null
184 ,p_pem_attribute21 IN varchar2 default null
185 ,p_pem_attribute22 IN varchar2 default null
186 ,p_pem_attribute23 IN varchar2 default null
187 ,p_pem_attribute24 IN varchar2 default null
188 ,p_pem_attribute25 IN varchar2 default null
189 ,p_pem_attribute26 IN varchar2 default null
190 ,p_pem_attribute27 IN varchar2 default null
191 ,p_pem_attribute28 IN varchar2 default null
192 ,p_pem_attribute29 IN varchar2 default null
193 ,p_pem_attribute30 IN varchar2 default null
194 ,p_pem_information_category IN varchar2 default null
195 ,Direction_Number IN varchar2 default null
196 ,Telephone IN varchar2 default null
197 ,Mobile IN varchar2 default null
198 ,Fax IN varchar2 default null
199 ,E_mail IN varchar2 default null
200 ,Contact_Information IN varchar2 default null
201 ,p_pem_information7 IN varchar2 default null
202 ,p_pem_information8 IN varchar2 default null
203 ,p_pem_information9 IN varchar2 default null
204 ,p_pem_information10 IN varchar2 default null
205 ,p_pem_information11 IN varchar2 default null
206 ,p_pem_information12 IN varchar2 default null
207 ,p_pem_information13 IN varchar2 default null
208 ,p_pem_information14 IN varchar2 default null
209 ,p_pem_information15 IN varchar2 default null
210 ,p_pem_information16 IN varchar2 default null
211 ,p_pem_information17 IN varchar2 default null
212 ,p_pem_information18 IN varchar2 default null
213 ,p_pem_information19 IN varchar2 default null
214 ,p_pem_information20 IN varchar2 default null
215 ,p_pem_information21 IN varchar2 default null
216 ,p_pem_information22 IN varchar2 default null
217 ,p_pem_information23 IN varchar2 default null
218 ,p_pem_information24 IN varchar2 default null
219 ,p_pem_information25 IN varchar2 default null
220 ,p_pem_information26 IN varchar2 default null
221 ,p_pem_information27 IN varchar2 default null
222 ,p_pem_information28 IN varchar2 default null
223 ,p_pem_information29 IN varchar2 default null
224 ,p_pem_information30 IN varchar2 default null
225 ,p_previous_employer_id OUT NOCOPY number
226 ,p_object_version_number OUT NOCOPY number
227 );
228 --
229 -- ----------------------------------------------------------------------------
230 -- |-----------------------< update_pl_previous_employer >--------------------|
231 -- ----------------------------------------------------------------------------
232 --
233 -- {Start Of Comments}
234 /*#
235 * This API modifies a previous employer.
236 *
237 * This API is effectively an alternative to the API update_previous_employer.
238 * If p_validate is set to false, the previous employer is updated.
239 *
240 * <p><b>Licensing</b><br>
241 * This API is licensed for use with Human Resources.
242 *
243 * <p><b>Prerequisites</b><br>
244 * The previous employer identified by p_previous_employer_id must already
245 * exist.
246 *
247 * <p><b>Post Success</b><br>
248 * The previous employer will be updated.
249 *
250 * <p><b>Post Failure</b><br>
251 * The previous employer will not be updated and an error will be raised.
252 *
253 * @param p_effective_date Reference date for validating lookup values are
254 * applicable during the start to end active date range. This date does not
255 * determine when the changes take effect.
256 * @param p_validate If true, then validation alone will be performed and the
257 * database will remain unchanged. If false and all validation checks pass,
258 * then the database will be modified.
259 * @param p_previous_employer_id Identifies the previous employer record to be
260 * modified.
261 * @param p_start_date The date from which the employee worked with the
262 * previous employer. This field is mandatory if employer type is 'Parallel'.
263 * @param p_end_date The date on which the employee left the previous employer.
264 * @param p_period_years Number of years of previous employment based on the
265 * employment start and end dates.
266 * @param p_period_months Number of months of previous employment based on the
267 * employment start and end dates.
268 * @param p_period_days Remaining number of days of employment based on number
269 * of days in period.
270 * @param p_employer_name Previous employer name.
271 * @param p_employer_country The country in which the previous employer is
272 * located.
273 * @param p_employer_address Address of the previous employer.
274 * @param p_employer_type Type of previous employer. Valid values are defined
275 * by PREV_EMP_TYPE lookup type.
276 * @param p_employer_subtype Subtype of the previous employer. This is
277 * dependent on employer type. Valid values are defined by PREV_EMP_SUBTYPE
278 * lookup type.
279 * @param p_description Description of the previous employer.
280 * @param p_all_assignments Indicates whether previous employer is applicable
281 * to all assignments of the current employer.
282 * @param p_pem_attribute_category This context value determines which
283 * flexfield structure to use with the descriptive flexfield columns.
284 * @param p_pem_attribute1 Descriptive flexfield column.
285 * @param p_pem_attribute2 Descriptive flexfield column.
286 * @param p_pem_attribute3 Descriptive flexfield column.
287 * @param p_pem_attribute4 Descriptive flexfield column.
288 * @param p_pem_attribute5 Descriptive flexfield column.
289 * @param p_pem_attribute6 Descriptive flexfield column.
290 * @param p_pem_attribute7 Descriptive flexfield column.
291 * @param p_pem_attribute8 Descriptive flexfield column.
292 * @param p_pem_attribute9 Descriptive flexfield column.
293 * @param p_pem_attribute10 Descriptive flexfield column.
294 * @param p_pem_attribute11 Descriptive flexfield column.
295 * @param p_pem_attribute12 Descriptive flexfield column.
296 * @param p_pem_attribute13 Descriptive flexfield column.
297 * @param p_pem_attribute14 Descriptive flexfield column.
298 * @param p_pem_attribute15 Descriptive flexfield column.
299 * @param p_pem_attribute16 Descriptive flexfield column.
300 * @param p_pem_attribute17 Descriptive flexfield column.
301 * @param p_pem_attribute18 Descriptive flexfield column.
302 * @param p_pem_attribute19 Descriptive flexfield column.
303 * @param p_pem_attribute20 Descriptive flexfield column.
304 * @param p_pem_attribute21 Descriptive flexfield column.
305 * @param p_pem_attribute22 Descriptive flexfield column.
306 * @param p_pem_attribute23 Descriptive flexfield column.
307 * @param p_pem_attribute24 Descriptive flexfield column.
308 * @param p_pem_attribute25 Descriptive flexfield column.
309 * @param p_pem_attribute26 Descriptive flexfield column.
310 * @param p_pem_attribute27 Descriptive flexfield column.
311 * @param p_pem_attribute28 Descriptive flexfield column.
312 * @param p_pem_attribute29 Descriptive flexfield column.
313 * @param p_pem_attribute30 Descriptive flexfield column.
314 * @param p_pem_information_category This context value determines which
315 * flexfield structure to use with the developer descriptive flexfield columns.
316 * @param direction_number Direction number of the previous employer.
317 * @param telephone Telephone number of the previous employer.
318 * @param mobile Mobile number of the previous employer.
319 * @param fax Fax number of the previous employer.
320 * @param e_mail Email address of the previous employer.
321 * @param contact_information Additional contact information for previous
322 * employer.
323 * @param p_pem_information7 Developer Descriptive flexfield column.
324 * @param p_pem_information8 Developer Descriptive flexfield column.
325 * @param p_pem_information9 Developer Descriptive flexfield column.
326 * @param p_pem_information10 Developer Descriptive flexfield column.
327 * @param p_pem_information11 Developer Descriptive flexfield column.
328 * @param p_pem_information12 Developer Descriptive flexfield column.
329 * @param p_pem_information13 Developer Descriptive flexfield column.
330 * @param p_pem_information14 Developer Descriptive flexfield column.
331 * @param p_pem_information15 Developer Descriptive flexfield column.
332 * @param p_pem_information16 Developer Descriptive flexfield column.
333 * @param p_pem_information17 Developer Descriptive flexfield column.
334 * @param p_pem_information18 Developer Descriptive flexfield column.
335 * @param p_pem_information19 Developer Descriptive flexfield column.
336 * @param p_pem_information20 Developer Descriptive flexfield column.
337 * @param p_pem_information21 Developer Descriptive flexfield column.
338 * @param p_pem_information22 Developer Descriptive flexfield column.
339 * @param p_pem_information23 Developer Descriptive flexfield column.
340 * @param p_pem_information24 Developer Descriptive flexfield column.
341 * @param p_pem_information25 Developer Descriptive flexfield column.
342 * @param p_pem_information26 Developer Descriptive flexfield column.
343 * @param p_pem_information27 Developer Descriptive flexfield column.
344 * @param p_pem_information28 Developer Descriptive flexfield column.
345 * @param p_pem_information29 Developer Descriptive flexfield column.
346 * @param p_pem_information30 Developer Descriptive flexfield column.
347 * @param p_object_version_number Pass in the current version number of the
348 * previous employer to be updated. When the API completes if p_validate is
349 * false, will be set to the new version number of the updated previous
350 * employer. If p_validate is true will be set to the same value which was
351 * passed in.
352 * @rep:displayname Update Previous Employer for Poland
353 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
354 * @rep:lifecycle active
355 * @rep:scope public
356 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
357 */
358 --
359 -- {End Of Comments}
360 --
361 procedure update_pl_previous_employer
362 ( p_effective_date IN date
363 ,p_validate IN boolean default false
364 ,p_previous_employer_id IN number
365 ,p_start_date IN date default hr_api.g_date
366 ,p_end_date IN date default hr_api.g_date
367 ,p_period_years IN number default hr_api.g_number
368 ,p_period_months IN number default hr_api.g_number
369 ,p_period_days IN number default hr_api.g_number
370 ,p_employer_name IN varchar2 default hr_api.g_varchar2
371 ,p_employer_country IN varchar2 default hr_api.g_varchar2
372 ,p_employer_address IN varchar2 default hr_api.g_varchar2
373 ,p_employer_type IN varchar2 default hr_api.g_varchar2
374 ,p_employer_subtype IN varchar2 default hr_api.g_varchar2
375 ,p_description IN varchar2 default hr_api.g_varchar2
376 ,p_all_assignments IN varchar2 default 'N'
377 ,p_pem_attribute_category IN varchar2 default hr_api.g_varchar2
378 ,p_pem_attribute1 IN varchar2 default hr_api.g_varchar2
379 ,p_pem_attribute2 IN varchar2 default hr_api.g_varchar2
380 ,p_pem_attribute3 IN varchar2 default hr_api.g_varchar2
381 ,p_pem_attribute4 IN varchar2 default hr_api.g_varchar2
382 ,p_pem_attribute5 IN varchar2 default hr_api.g_varchar2
383 ,p_pem_attribute6 IN varchar2 default hr_api.g_varchar2
384 ,p_pem_attribute7 IN varchar2 default hr_api.g_varchar2
385 ,p_pem_attribute8 IN varchar2 default hr_api.g_varchar2
386 ,p_pem_attribute9 IN varchar2 default hr_api.g_varchar2
387 ,p_pem_attribute10 IN varchar2 default hr_api.g_varchar2
388 ,p_pem_attribute11 IN varchar2 default hr_api.g_varchar2
389 ,p_pem_attribute12 IN varchar2 default hr_api.g_varchar2
390 ,p_pem_attribute13 IN varchar2 default hr_api.g_varchar2
391 ,p_pem_attribute14 IN varchar2 default hr_api.g_varchar2
392 ,p_pem_attribute15 IN varchar2 default hr_api.g_varchar2
393 ,p_pem_attribute16 IN varchar2 default hr_api.g_varchar2
394 ,p_pem_attribute17 IN varchar2 default hr_api.g_varchar2
395 ,p_pem_attribute18 IN varchar2 default hr_api.g_varchar2
396 ,p_pem_attribute19 IN varchar2 default hr_api.g_varchar2
397 ,p_pem_attribute20 IN varchar2 default hr_api.g_varchar2
398 ,p_pem_attribute21 IN varchar2 default hr_api.g_varchar2
399 ,p_pem_attribute22 IN varchar2 default hr_api.g_varchar2
400 ,p_pem_attribute23 IN varchar2 default hr_api.g_varchar2
401 ,p_pem_attribute24 IN varchar2 default hr_api.g_varchar2
402 ,p_pem_attribute25 IN varchar2 default hr_api.g_varchar2
403 ,p_pem_attribute26 IN varchar2 default hr_api.g_varchar2
404 ,p_pem_attribute27 IN varchar2 default hr_api.g_varchar2
405 ,p_pem_attribute28 IN varchar2 default hr_api.g_varchar2
406 ,p_pem_attribute29 IN varchar2 default hr_api.g_varchar2
407 ,p_pem_attribute30 IN varchar2 default hr_api.g_varchar2
408 ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
409 ,Direction_Number IN varchar2 default hr_api.g_varchar2
410 ,Telephone IN varchar2 default hr_api.g_varchar2
411 ,Mobile IN varchar2 default hr_api.g_varchar2
412 ,Fax IN varchar2 default hr_api.g_varchar2
413 ,E_mail IN varchar2 default hr_api.g_varchar2
414 ,Contact_Information IN varchar2 default hr_api.g_varchar2
415 ,p_pem_information7 IN varchar2 default hr_api.g_varchar2
416 ,p_pem_information8 IN varchar2 default hr_api.g_varchar2
417 ,p_pem_information9 IN varchar2 default hr_api.g_varchar2
418 ,p_pem_information10 IN varchar2 default hr_api.g_varchar2
419 ,p_pem_information11 IN varchar2 default hr_api.g_varchar2
420 ,p_pem_information12 IN varchar2 default hr_api.g_varchar2
421 ,p_pem_information13 IN varchar2 default hr_api.g_varchar2
422 ,p_pem_information14 IN varchar2 default hr_api.g_varchar2
423 ,p_pem_information15 IN varchar2 default hr_api.g_varchar2
424 ,p_pem_information16 IN varchar2 default hr_api.g_varchar2
425 ,p_pem_information17 IN varchar2 default hr_api.g_varchar2
426 ,p_pem_information18 IN varchar2 default hr_api.g_varchar2
427 ,p_pem_information19 IN varchar2 default hr_api.g_varchar2
428 ,p_pem_information20 IN varchar2 default hr_api.g_varchar2
429 ,p_pem_information21 IN varchar2 default hr_api.g_varchar2
430 ,p_pem_information22 IN varchar2 default hr_api.g_varchar2
431 ,p_pem_information23 IN varchar2 default hr_api.g_varchar2
432 ,p_pem_information24 IN varchar2 default hr_api.g_varchar2
433 ,p_pem_information25 IN varchar2 default hr_api.g_varchar2
434 ,p_pem_information26 IN varchar2 default hr_api.g_varchar2
435 ,p_pem_information27 IN varchar2 default hr_api.g_varchar2
436 ,p_pem_information28 IN varchar2 default hr_api.g_varchar2
437 ,p_pem_information29 IN varchar2 default hr_api.g_varchar2
438 ,p_pem_information30 IN varchar2 default hr_api.g_varchar2
439 ,p_object_version_number IN OUT NOCOPY number
440 );
441 --
442 -- ----------------------------------------------------------------------------
443 -- |--------------------------< create_pl_previous_job >----------------------|
444 -- ----------------------------------------------------------------------------
445 --
446 -- {Start Of Comments}
447 /*#
448 * This API creates previous job details.
449 *
450 * This API is effectively an alternative to the API create_previous_job. If
451 * p_validate is set to false, a previous job is created.
452 *
453 * <p><b>Licensing</b><br>
454 * This API is licensed for use with Human Resources.
455 *
456 * <p><b>Prerequisites</b><br>
457 * The previous employer identified by p_previous_employer_id must already
458 * exist.
459 *
460 * <p><b>Post Success</b><br>
461 * The previous job will be successfully inserted into the database.
462 *
463 * <p><b>Post Failure</b><br>
464 * The previous job will not be created and an error will be raised.
465 *
466 * @param p_effective_date Reference date for validating lookup values are
467 * applicable during the start to end active date range. This date does not
468 * determine when the changes take effect.
469 * @param p_validate If true, then validation alone will be performed and the
470 * database will remain unchanged. If false and all validation checks pass,
471 * then the database will be modified.
472 * @param p_previous_employer_id Identifies the previous employer for whom you
473 * create the previous job record.
474 * @param p_start_date The date from which the employee worked with the
475 * previous job. The start date should be between the start and end dates of
476 * the previous employer.
477 * @param p_end_date The date on which the employee left the previous job.
478 * @param p_period_years Number of years of previous employment based on the
479 * employment start and end dates.
480 * @param p_period_months Number of months of previous employment based on the
481 * employment start and end dates.
482 * @param p_period_days Remaining number of days of employment based on number
483 * of days in period.
484 * @param p_job_name Name of the previous job.
485 * @param p_employment_category Obsolete parameter, do not use.
486 * @param p_description Description of the previous job.
487 * @param p_all_assignments Indicates whether previous employer is applicable
488 * to all assignments of the current employer.
489 * @param p_pjo_attribute_category This context value determines which
490 * flexfield structure to use with the descriptive flexfield columns.
491 * @param p_pjo_attribute1 Descriptive flexfield column.
492 * @param p_pjo_attribute2 Descriptive flexfield column.
493 * @param p_pjo_attribute3 Descriptive flexfield column.
494 * @param p_pjo_attribute4 Descriptive flexfield column.
495 * @param p_pjo_attribute5 Descriptive flexfield column.
496 * @param p_pjo_attribute6 Descriptive flexfield column.
497 * @param p_pjo_attribute7 Descriptive flexfield column.
498 * @param p_pjo_attribute8 Descriptive flexfield column.
499 * @param p_pjo_attribute9 Descriptive flexfield column.
500 * @param p_pjo_attribute10 Descriptive flexfield column.
501 * @param p_pjo_attribute11 Descriptive flexfield column.
502 * @param p_pjo_attribute12 Descriptive flexfield column.
503 * @param p_pjo_attribute13 Descriptive flexfield column.
504 * @param p_pjo_attribute14 Descriptive flexfield column.
505 * @param p_pjo_attribute15 Descriptive flexfield column.
506 * @param p_pjo_attribute16 Descriptive flexfield column.
507 * @param p_pjo_attribute17 Descriptive flexfield column.
508 * @param p_pjo_attribute18 Descriptive flexfield column.
509 * @param p_pjo_attribute19 Descriptive flexfield column.
510 * @param p_pjo_attribute20 Descriptive flexfield column.
511 * @param p_pjo_attribute21 Descriptive flexfield column.
512 * @param p_pjo_attribute22 Descriptive flexfield column.
513 * @param p_pjo_attribute23 Descriptive flexfield column.
514 * @param p_pjo_attribute24 Descriptive flexfield column.
515 * @param p_pjo_attribute25 Descriptive flexfield column.
516 * @param p_pjo_attribute26 Descriptive flexfield column.
517 * @param p_pjo_attribute27 Descriptive flexfield column.
518 * @param p_pjo_attribute28 Descriptive flexfield column.
519 * @param p_pjo_attribute29 Descriptive flexfield column.
520 * @param p_pjo_attribute30 Descriptive flexfield column.
521 * @param p_pjo_information_category This context value determines which
522 * flexfield structure to use with the developer descriptive flexfield columns.
523 * @param type_of_service Type of service. Valid values are defined by
524 * PL_TYPE_OF_SERVICE lookup type.
525 * @param p_pjo_information2 Developer Descriptive flexfield column.
526 * @param p_pjo_information3 Developer Descriptive flexfield column.
527 * @param p_pjo_information4 Developer Descriptive flexfield column.
528 * @param p_pjo_information5 Developer Descriptive flexfield column.
529 * @param p_pjo_information6 Developer Descriptive flexfield column.
530 * @param p_pjo_information7 Developer Descriptive flexfield column.
531 * @param p_pjo_information8 Developer Descriptive flexfield column.
532 * @param p_pjo_information9 Developer Descriptive flexfield column.
533 * @param p_pjo_information10 Developer Descriptive flexfield column.
534 * @param p_pjo_information11 Developer Descriptive flexfield column.
535 * @param p_pjo_information12 Developer Descriptive flexfield column.
536 * @param p_pjo_information13 Developer Descriptive flexfield column.
537 * @param p_pjo_information14 Developer Descriptive flexfield column.
538 * @param p_pjo_information15 Developer Descriptive flexfield column.
539 * @param p_pjo_information16 Developer Descriptive flexfield column.
540 * @param p_pjo_information17 Developer Descriptive flexfield column.
541 * @param p_pjo_information18 Developer Descriptive flexfield column.
542 * @param p_pjo_information19 Developer Descriptive flexfield column.
543 * @param p_pjo_information20 Developer Descriptive flexfield column.
544 * @param p_pjo_information21 Developer Descriptive flexfield column.
545 * @param p_pjo_information22 Developer Descriptive flexfield column.
546 * @param p_pjo_information23 Developer Descriptive flexfield column.
547 * @param p_pjo_information24 Developer Descriptive flexfield column.
548 * @param p_pjo_information25 Developer Descriptive flexfield column.
549 * @param p_pjo_information26 Developer Descriptive flexfield column
550 * @param p_pjo_information27 Developer Descriptive flexfield column
551 * @param p_pjo_information28 Developer Descriptive flexfield column
552 * @param p_pjo_information29 Developer Descriptive flexfield column
553 * @param p_pjo_information30 Developer Descriptive flexfield column
554 * @param p_previous_job_id If p_validate is false, then this uniquely
555 * identifies the created previous job. If p_validate is true, then set to
556 * null.
557 * @param p_object_version_number If p_validate is false, then set to the
558 * version number of the created previous job. If p_validate is true, then the
559 * value will be null.
560 * @rep:displayname Create Previous Job for Poland
561 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
562 * @rep:lifecycle active
563 * @rep:scope public
564 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
565 */
566 --
567 -- {End Of Comments}
568 --
569 procedure create_pl_previous_job
570 ( p_effective_date in date
571 ,p_validate in boolean default false
572 ,p_previous_employer_id in number
573 ,p_start_date in date default null
574 ,p_end_date in date default null
575 ,p_period_years in number default null
576 ,p_period_months in number default null
577 ,p_period_days in number default null
578 ,p_job_name in varchar2 default null
579 ,p_employment_category in varchar2 default null
580 ,p_description in varchar2 default null
581 ,p_all_assignments in varchar2 default 'N'
582 ,p_pjo_attribute_category in varchar2 default null
583 ,p_pjo_attribute1 in varchar2 default null
584 ,p_pjo_attribute2 in varchar2 default null
585 ,p_pjo_attribute3 in varchar2 default null
586 ,p_pjo_attribute4 in varchar2 default null
587 ,p_pjo_attribute5 in varchar2 default null
588 ,p_pjo_attribute6 in varchar2 default null
589 ,p_pjo_attribute7 in varchar2 default null
590 ,p_pjo_attribute8 in varchar2 default null
591 ,p_pjo_attribute9 in varchar2 default null
592 ,p_pjo_attribute10 in varchar2 default null
593 ,p_pjo_attribute11 in varchar2 default null
594 ,p_pjo_attribute12 in varchar2 default null
595 ,p_pjo_attribute13 in varchar2 default null
596 ,p_pjo_attribute14 in varchar2 default null
597 ,p_pjo_attribute15 in varchar2 default null
598 ,p_pjo_attribute16 in varchar2 default null
599 ,p_pjo_attribute17 in varchar2 default null
600 ,p_pjo_attribute18 in varchar2 default null
601 ,p_pjo_attribute19 in varchar2 default null
602 ,p_pjo_attribute20 in varchar2 default null
603 ,p_pjo_attribute21 in varchar2 default null
604 ,p_pjo_attribute22 in varchar2 default null
605 ,p_pjo_attribute23 in varchar2 default null
606 ,p_pjo_attribute24 in varchar2 default null
607 ,p_pjo_attribute25 in varchar2 default null
608 ,p_pjo_attribute26 in varchar2 default null
609 ,p_pjo_attribute27 in varchar2 default null
610 ,p_pjo_attribute28 in varchar2 default null
611 ,p_pjo_attribute29 in varchar2 default null
612 ,p_pjo_attribute30 in varchar2 default null
613 ,p_pjo_information_category in varchar2 default null
614 ,Type_Of_Service in varchar2
615 ,p_pjo_information2 in varchar2 default null
616 ,p_pjo_information3 in varchar2 default null
617 ,p_pjo_information4 in varchar2 default null
618 ,p_pjo_information5 in varchar2 default null
619 ,p_pjo_information6 in varchar2 default null
620 ,p_pjo_information7 in varchar2 default null
621 ,p_pjo_information8 in varchar2 default null
622 ,p_pjo_information9 in varchar2 default null
623 ,p_pjo_information10 in varchar2 default null
624 ,p_pjo_information11 in varchar2 default null
625 ,p_pjo_information12 in varchar2 default null
626 ,p_pjo_information13 in varchar2 default null
627 ,p_pjo_information14 in varchar2 default null
628 ,p_pjo_information15 in varchar2 default null
629 ,p_pjo_information16 in varchar2 default null
630 ,p_pjo_information17 in varchar2 default null
631 ,p_pjo_information18 in varchar2 default null
632 ,p_pjo_information19 in varchar2 default null
633 ,p_pjo_information20 in varchar2 default null
634 ,p_pjo_information21 in varchar2 default null
635 ,p_pjo_information22 in varchar2 default null
636 ,p_pjo_information23 in varchar2 default null
637 ,p_pjo_information24 in varchar2 default null
638 ,p_pjo_information25 in varchar2 default null
639 ,p_pjo_information26 in varchar2 default null
640 ,p_pjo_information27 in varchar2 default null
641 ,p_pjo_information28 in varchar2 default null
642 ,p_pjo_information29 in varchar2 default null
643 ,p_pjo_information30 in varchar2 default null
644 ,p_previous_job_id out nocopy number
645 ,p_object_version_number out nocopy number
646 );
647 --
648 -- ----------------------------------------------------------------------------
649 -- |--------------------------< update_pl_previous_job >----------------------|
650 -- ----------------------------------------------------------------------------
651 --
652 -- {Start Of Comments}
653 /*#
654 * This API modifies a previous job.
655 *
656 * This API is effectively an alternative to the API update_previous_job. If
657 * p_validate is set to false, the previous job is updated.
658 *
659 * <p><b>Licensing</b><br>
660 * This API is licensed for use with Human Resources.
661 *
662 * <p><b>Prerequisites</b><br>
663 * The previous job record identified by p_previous_job_id must already exist.
664 *
665 * <p><b>Post Success</b><br>
666 * The previous job will be updated.
667 *
668 * <p><b>Post Failure</b><br>
669 * The previous job will not be updated and an error will be raised.
670 *
671 * @param p_effective_date Reference date for validating lookup values are
672 * applicable during the start to end active date range. This date does not
673 * determine when the changes take effect.
674 * @param p_validate If true, then validation alone will be performed and the
675 * database will remain unchanged. If false and all validation checks pass,
676 * then the database will be modified.
677 * @param p_previous_job_id Identifies the previous job record to be modified.
678 * @param p_start_date The date from which the employee worked with the
679 * previous job. The start date should be between the start and end dates of
680 * the previous employer record.
681 * @param p_end_date The date on which the employee left the previous job.
682 * @param p_period_years Number of years of previous employment based on the
683 * employment start and end dates.
684 * @param p_period_months Number of months of previous employment based on the
685 * employment start and end dates.
686 * @param p_period_days Remaining number of days of employment based on number
687 * of days in period.
688 * @param p_job_name Name of the previous job.
689 * @param p_employment_category Obsolete parameter, do not use.
690 * @param p_description Description of the previous job.
691 * @param p_all_assignments Indicates whether previous employer is applicable
692 * to all assignments of the current employer.
693 * @param p_pjo_attribute_category This context value determines which
694 * flexfield structure to use with the descriptive flexfield columns.
695 * @param p_pjo_attribute1 Descriptive flexfield column.
696 * @param p_pjo_attribute2 Descriptive flexfield column.
697 * @param p_pjo_attribute3 Descriptive flexfield column.
698 * @param p_pjo_attribute4 Descriptive flexfield column.
699 * @param p_pjo_attribute5 Descriptive flexfield column.
700 * @param p_pjo_attribute6 Descriptive flexfield column.
701 * @param p_pjo_attribute7 Descriptive flexfield column.
702 * @param p_pjo_attribute8 Descriptive flexfield column.
703 * @param p_pjo_attribute9 Descriptive flexfield column.
704 * @param p_pjo_attribute10 Descriptive flexfield column.
705 * @param p_pjo_attribute11 Descriptive flexfield column.
706 * @param p_pjo_attribute12 Descriptive flexfield column.
707 * @param p_pjo_attribute13 Descriptive flexfield column.
708 * @param p_pjo_attribute14 Descriptive flexfield column.
709 * @param p_pjo_attribute15 Descriptive flexfield column.
710 * @param p_pjo_attribute16 Descriptive flexfield column.
711 * @param p_pjo_attribute17 Descriptive flexfield column.
712 * @param p_pjo_attribute18 Descriptive flexfield column.
713 * @param p_pjo_attribute19 Descriptive flexfield column.
714 * @param p_pjo_attribute20 Descriptive flexfield column.
715 * @param p_pjo_attribute21 Descriptive flexfield column.
716 * @param p_pjo_attribute22 Descriptive flexfield column.
717 * @param p_pjo_attribute23 Descriptive flexfield column.
718 * @param p_pjo_attribute24 Descriptive flexfield column.
719 * @param p_pjo_attribute25 Descriptive flexfield column.
720 * @param p_pjo_attribute26 Descriptive flexfield column.
721 * @param p_pjo_attribute27 Descriptive flexfield column.
722 * @param p_pjo_attribute28 Descriptive flexfield column.
723 * @param p_pjo_attribute29 Descriptive flexfield column.
724 * @param p_pjo_attribute30 Descriptive flexfield column.
725 * @param p_pjo_information_category This context value determines which
726 * flexfield structure to use with the developer descriptive flexfield columns.
727 * @param type_of_service Type of service. Valid values are defined by
728 * PL_TYPE_OF_SERVICE lookup type.
729 * @param p_pjo_information2 Developer Descriptive flexfield column.
730 * @param p_pjo_information3 Developer Descriptive flexfield column.
731 * @param p_pjo_information4 Developer Descriptive flexfield column.
732 * @param p_pjo_information5 Developer Descriptive flexfield column.
733 * @param p_pjo_information6 Developer Descriptive flexfield column.
734 * @param p_pjo_information7 Developer Descriptive flexfield column.
735 * @param p_pjo_information8 Developer Descriptive flexfield column.
736 * @param p_pjo_information9 Developer Descriptive flexfield column.
737 * @param p_pjo_information10 Developer Descriptive flexfield column.
738 * @param p_pjo_information11 Developer Descriptive flexfield column.
739 * @param p_pjo_information12 Developer Descriptive flexfield column.
740 * @param p_pjo_information13 Developer Descriptive flexfield column.
741 * @param p_pjo_information14 Developer Descriptive flexfield column.
742 * @param p_pjo_information15 Developer Descriptive flexfield column.
743 * @param p_pjo_information16 Developer Descriptive flexfield column.
744 * @param p_pjo_information17 Developer Descriptive flexfield column.
745 * @param p_pjo_information18 Developer Descriptive flexfield column.
746 * @param p_pjo_information19 Developer Descriptive flexfield column.
747 * @param p_pjo_information20 Developer Descriptive flexfield column.
748 * @param p_pjo_information21 Developer Descriptive flexfield column.
749 * @param p_pjo_information22 Developer Descriptive flexfield column.
750 * @param p_pjo_information23 Developer Descriptive flexfield column.
751 * @param p_pjo_information24 Developer Descriptive flexfield column.
752 * @param p_pjo_information25 Developer Descriptive flexfield column.
753 * @param p_pjo_information26 Developer Descriptive flexfield column.
754 * @param p_pjo_information27 Developer Descriptive flexfield column.
755 * @param p_pjo_information28 Developer Descriptive flexfield column.
756 * @param p_pjo_information29 Developer Descriptive flexfield column.
757 * @param p_pjo_information30 Developer Descriptive flexfield column.
758 * @param p_object_version_number Pass in the current version number of the
759 * previous job to be updated. When the API completes if p_validate is false,
760 * will be set to the new version number of the updated previous job. If
761 * p_validate is true will be set to the same value which was passed in.
762 * @rep:displayname Update Previous Job for Poland
763 * @rep:category BUSINESS_ENTITY PER_PREVIOUS_EMPLOYMENT
764 * @rep:lifecycle active
765 * @rep:scope public
766 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
767 */
768 --
769 -- {End Of Comments}
770 --
771 procedure update_pl_previous_job
772 ( p_effective_date in date
773 ,p_validate in boolean default false
774 ,p_previous_job_id in number
775 ,p_start_date in date default hr_api.g_date
776 ,p_end_date in date default hr_api.g_date
777 ,p_period_years in number default hr_api.g_number
778 ,p_period_months in number default hr_api.g_number
779 ,p_period_days in number default hr_api.g_number
780 ,p_job_name in varchar2 default hr_api.g_varchar2
781 ,p_employment_category in varchar2 default hr_api.g_varchar2
782 ,p_description in varchar2 default hr_api.g_varchar2
783 ,p_all_assignments in varchar2 default 'N'
784 ,p_pjo_attribute_category in varchar2 default hr_api.g_varchar2
785 ,p_pjo_attribute1 in varchar2 default hr_api.g_varchar2
786 ,p_pjo_attribute2 in varchar2 default hr_api.g_varchar2
787 ,p_pjo_attribute3 in varchar2 default hr_api.g_varchar2
788 ,p_pjo_attribute4 in varchar2 default hr_api.g_varchar2
789 ,p_pjo_attribute5 in varchar2 default hr_api.g_varchar2
790 ,p_pjo_attribute6 in varchar2 default hr_api.g_varchar2
791 ,p_pjo_attribute7 in varchar2 default hr_api.g_varchar2
792 ,p_pjo_attribute8 in varchar2 default hr_api.g_varchar2
793 ,p_pjo_attribute9 in varchar2 default hr_api.g_varchar2
794 ,p_pjo_attribute10 in varchar2 default hr_api.g_varchar2
795 ,p_pjo_attribute11 in varchar2 default hr_api.g_varchar2
796 ,p_pjo_attribute12 in varchar2 default hr_api.g_varchar2
797 ,p_pjo_attribute13 in varchar2 default hr_api.g_varchar2
798 ,p_pjo_attribute14 in varchar2 default hr_api.g_varchar2
799 ,p_pjo_attribute15 in varchar2 default hr_api.g_varchar2
800 ,p_pjo_attribute16 in varchar2 default hr_api.g_varchar2
801 ,p_pjo_attribute17 in varchar2 default hr_api.g_varchar2
802 ,p_pjo_attribute18 in varchar2 default hr_api.g_varchar2
803 ,p_pjo_attribute19 in varchar2 default hr_api.g_varchar2
804 ,p_pjo_attribute20 in varchar2 default hr_api.g_varchar2
805 ,p_pjo_attribute21 in varchar2 default hr_api.g_varchar2
806 ,p_pjo_attribute22 in varchar2 default hr_api.g_varchar2
807 ,p_pjo_attribute23 in varchar2 default hr_api.g_varchar2
808 ,p_pjo_attribute24 in varchar2 default hr_api.g_varchar2
809 ,p_pjo_attribute25 in varchar2 default hr_api.g_varchar2
810 ,p_pjo_attribute26 in varchar2 default hr_api.g_varchar2
811 ,p_pjo_attribute27 in varchar2 default hr_api.g_varchar2
812 ,p_pjo_attribute28 in varchar2 default hr_api.g_varchar2
813 ,p_pjo_attribute29 in varchar2 default hr_api.g_varchar2
814 ,p_pjo_attribute30 in varchar2 default hr_api.g_varchar2
815 ,p_pjo_information_category in varchar2 default hr_api.g_varchar2
816 ,Type_Of_Service in varchar2 default hr_api.g_varchar2
817 ,p_pjo_information2 in varchar2 default hr_api.g_varchar2
818 ,p_pjo_information3 in varchar2 default hr_api.g_varchar2
819 ,p_pjo_information4 in varchar2 default hr_api.g_varchar2
820 ,p_pjo_information5 in varchar2 default hr_api.g_varchar2
821 ,p_pjo_information6 in varchar2 default hr_api.g_varchar2
822 ,p_pjo_information7 in varchar2 default hr_api.g_varchar2
823 ,p_pjo_information8 in varchar2 default hr_api.g_varchar2
824 ,p_pjo_information9 in varchar2 default hr_api.g_varchar2
825 ,p_pjo_information10 in varchar2 default hr_api.g_varchar2
826 ,p_pjo_information11 in varchar2 default hr_api.g_varchar2
827 ,p_pjo_information12 in varchar2 default hr_api.g_varchar2
828 ,p_pjo_information13 in varchar2 default hr_api.g_varchar2
829 ,p_pjo_information14 in varchar2 default hr_api.g_varchar2
830 ,p_pjo_information15 in varchar2 default hr_api.g_varchar2
831 ,p_pjo_information16 in varchar2 default hr_api.g_varchar2
832 ,p_pjo_information17 in varchar2 default hr_api.g_varchar2
833 ,p_pjo_information18 in varchar2 default hr_api.g_varchar2
834 ,p_pjo_information19 in varchar2 default hr_api.g_varchar2
835 ,p_pjo_information20 in varchar2 default hr_api.g_varchar2
836 ,p_pjo_information21 in varchar2 default hr_api.g_varchar2
837 ,p_pjo_information22 in varchar2 default hr_api.g_varchar2
838 ,p_pjo_information23 in varchar2 default hr_api.g_varchar2
839 ,p_pjo_information24 in varchar2 default hr_api.g_varchar2
840 ,p_pjo_information25 in varchar2 default hr_api.g_varchar2
841 ,p_pjo_information26 in varchar2 default hr_api.g_varchar2
842 ,p_pjo_information27 in varchar2 default hr_api.g_varchar2
843 ,p_pjo_information28 in varchar2 default hr_api.g_varchar2
844 ,p_pjo_information29 in varchar2 default hr_api.g_varchar2
845 ,p_pjo_information30 in varchar2 default hr_api.g_varchar2
846 ,p_object_version_number in out nocopy number
847 );
848 End hr_pl_previous_employment_api;
[Home] [Help]