1 Package hr_pl_contingent_worker_api as
2 /* $Header: pecwkpli.pkh 120.4 2006/05/12 00:00:10 mseshadr noship $ */
3 /*#
4 * This package contains contingent worker APIs for Poland.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Contingent Worker for Poland
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< create_pl_cwk >---------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * The following procedure(older version) creates a Polish contingent worker.
17 *
18 * This procedure is used to create a person record and a default contingent
19 * worker assignment for a new non-payroll worker.
20 *
21 * <P> This version of the API is now out-of-date however it has been provided
22 * to you for backward compatibility support and will be removed in the future.
23 * Oracle recommends you to modify existing calling programs in advance of the
24 * support being withdrawn thus avoiding any potential disruption.
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 * The business group for Poland legislation must already exist. Also a valid
31 * person_type_id, with a corresponding system type of 'CWK', must be active
32 * and in the same business group as that of the applicant being created.
33 *
34 * <p><b>Post Success</b><br>
35 * The person, primary contingent worker assignment and period of placement
36 * will be successfully inserted into the database.
37 *
38 * <p><b>Post Failure</b><br>
39 * The contingent worker will not be created and an error will be raised.
40 *
41 * @param p_validate If true, then validation alone will be performed and the
42 * database will remain unchanged. If false and all validation checks pass,
43 * then the database will be modified.
44 * @param p_start_date Start date for person, default assignment and placement
45 * record.
46 * @param p_business_group_id The contingent worker's business group.
47 * @param p_last_name Last name of the contingent worker.
48 * @param p_person_type_id This is the identifier corrresponding to the type of
49 * person. If an identification number is not specified, then the API will use
50 * the default 'CWK' type for the business group.
51 * @param p_npw_number Number of non-payroll worker.
52 * @param p_background_check_status Y/N flag indicates whether background check
53 * has been performed.
54 * @param p_background_date_check Date background check was performed.
55 * @param p_blood_type Blood type of the contingent worker.
56 * @param p_comments Contingent worker comment text.
57 * @param p_correspondence_language Preferred language for correspondance.
58 * @param p_country_of_birth Country of birth of the contingent worker.
59 * @param p_date_of_birth Date of birth of the contingent worker.
60 * @param p_date_of_death Date of death of the contingent worker.
61 * @param p_dpdnt_adoption_date Date dependent was adopted.
62 * @param p_dpdnt_vlntry_svce_flag Indicates whether the dependent is on
63 * voluntary service.
64 * @param p_email_address Email address of the contingent worker.
65 * @param p_first_name First name of the contingent worker.
66 * @param p_fte_capacity Full-time employment capacity of the contingent
67 * worker.
68 * @param p_honors Honors or degrees awarded.
69 * @param p_internal_location Internal location of office of the contingent
70 * worker.
71 * @param p_preferred_name Alternative name of the contingent worker.
72 * @param p_last_medical_test_by Name of physician who performed last medical
73 * test.
74 * @param p_last_medical_test_date Date of last medical test.
75 * @param p_mailstop Internal mail location for the contingent worker.
76 * @param p_marital_status Marital status of the contingent worker. Valid
77 * values are defined by 'MAR_STATUS' lookup type.
78 * @param p_middle_names Contingent worker's middle name(s).
79 * @param p_pesel_number National identifier of the contingent worker.
80 * @param p_nationality Contingent worker's nationality. Valid values are
81 * defined by 'NATIONALITY' lookup type.
82 * @param p_office_number Office Number of the contingent worker.
83 * @param p_on_military_service Y/N flag indicating whether the contingent
84 * worker is employed in military service.
85 * @param p_party_id Identifier for the party.
86 * @param p_prefix Obsolete parameter, do not use.
87 * @param p_maiden_name Previous last name of the contingent worker.
88 * @param p_projected_placement_end Obsolete parameter, do not use.
89 * @param p_receipt_of_death_cert_date Date when the death certificate is
90 * received.
91 * @param p_region_of_birth Geographical region of birth of the contingent
92 * worker.
93 * @param p_registered_disabled_flag Indicates whether person is classified as
94 * disabled. Valid values are defined by 'REGISTERED_DISABLED' lookup type.
95 * @param p_resume_exists Y/N flag indicating whether resume is on file.
96 * @param p_resume_last_updated Date when the resume was last updated.
97 * @param p_second_passport_exists Y/N flag indicaing whether the person has
98 * multiple passports.
99 * @param p_sex Contingent worker's gender.
100 * @param p_student_status Full time/part time status of the contingent worker.
101 * @param p_suffix Obsolete parameter, do not use.
102 * @param p_title Title of the contingent worker. Valid values are defined by
103 * 'TITLE' lookup type.
104 * @param p_town_of_birth Town or city of birth of the contingent worker.
105 * @param p_uses_tobacco_flag Tobacoo type used by the contingent worker. Valid
106 * values are defined by 'TOBACCO_USER' lookup type.
107 * @param p_vendor_id Identifier for the organisation supplying contingent
108 * workers.
109 * @param p_work_schedule Type of work schedule indicating which days the
110 * contingent worker works. Valid values are defined by 'WORK_SCHEDULE' lookup
111 * type.
112 * @param p_work_telephone Work telephone of the contingent worker.
113 * @param p_exp_check_send_to_address Mailing address of the contingent worker.
114 * @param p_hold_applicant_date_until Date until which the applicant should be
115 * put on hold.
116 * @param p_date_employee_data_verified Date when the employee last verified
117 * the data.
118 * @param p_benefit_group_id Identification for benefit group.
119 * @param p_coord_ben_med_pln_no Coordination of benefits medical group plan
120 * number.
121 * @param p_coord_ben_no_cvg_flag Coordination of benefits no other coverage
122 * flag.
123 * @param p_original_date_of_hire Original date of hire of the contingent
124 * worker.
125 * @param p_attribute_category This context value determines which flexfield
126 * structure to use with the descriptive flexfield segments.
127 * @param p_attribute1 Descriptive flexfield segment.
128 * @param p_attribute2 Descriptive flexfield segment.
129 * @param p_attribute3 Descriptive flexfield segment.
130 * @param p_attribute4 Descriptive flexfield segment.
131 * @param p_attribute5 Descriptive flexfield segment.
132 * @param p_attribute6 Descriptive flexfield segment.
133 * @param p_attribute7 Descriptive flexfield segment.
134 * @param p_attribute8 Descriptive flexfield segment.
135 * @param p_attribute9 Descriptive flexfield segment.
136 * @param p_attribute10 Descriptive flexfield segment.
137 * @param p_attribute11 Descriptive flexfield segment.
138 * @param p_attribute12 Descriptive flexfield segment.
139 * @param p_attribute13 Descriptive flexfield segment.
140 * @param p_attribute14 Descriptive flexfield segment.
141 * @param p_attribute15 Descriptive flexfield segment.
142 * @param p_attribute16 Descriptive flexfield segment.
143 * @param p_attribute17 Descriptive flexfield segment.
144 * @param p_attribute18 Descriptive flexfield segment.
145 * @param p_attribute19 Descriptive flexfield segment.
146 * @param p_attribute20 Descriptive flexfield segment.
147 * @param p_attribute21 Descriptive flexfield segment.
148 * @param p_attribute22 Descriptive flexfield segment.
149 * @param p_attribute23 Descriptive flexfield segment.
150 * @param p_attribute24 Descriptive flexfield segment.
151 * @param p_attribute25 Descriptive flexfield segment.
152 * @param p_attribute26 Descriptive flexfield segment.
153 * @param p_attribute27 Descriptive flexfield segment.
154 * @param p_attribute28 Descriptive flexfield segment.
155 * @param p_attribute29 Descriptive flexfield segment.
156 * @param p_attribute30 Descriptive flexfield segment.
157 * @param p_per_information_category Obsolete parameter, do not use.
158 * @param p_nip_number The National Polish Tax identifier of the contingent
159 * worker.
160 * @param p_per_information2 Developer descriptive flexfield segment.
161 * @param p_per_information3 Developer descriptive flexfield segment.
162 * @param p_per_information4 Developer descriptive flexfield segment.
163 * @param p_per_information5 Developer descriptive flexfield segment.
164 * @param p_per_information6 Developer descriptive flexfield segment.
165 * @param p_per_information7 Developer descriptive flexfield segment.
166 * @param p_per_information8 Developer descriptive flexfield segment.
167 * @param p_per_information9 Developer descriptive flexfield segment.
168 * @param p_per_information10 Developer descriptive flexfield segment.
169 * @param p_per_information11 Developer descriptive flexfield segment.
170 * @param p_per_information12 Developer descriptive flexfield segment.
171 * @param p_per_information13 Developer descriptive flexfield segment.
172 * @param p_per_information14 Developer descriptive flexfield segment.
173 * @param p_per_information15 Developer descriptive flexfield segment.
174 * @param p_per_information16 Developer descriptive flexfield segment.
175 * @param p_per_information17 Developer descriptive flexfield segment.
176 * @param p_per_information18 Developer descriptive flexfield segment.
177 * @param p_per_information19 Developer descriptive flexfield segment.
178 * @param p_per_information20 Developer descriptive flexfield segment.
179 * @param p_per_information21 Developer descriptive flexfield segment.
180 * @param p_per_information22 Developer descriptive flexfield segment.
181 * @param p_per_information23 Developer descriptive flexfield segment.
182 * @param p_per_information24 Developer descriptive flexfield segment.
183 * @param p_per_information25 Developer descriptive flexfield segment.
184 * @param p_per_information26 Developer descriptive flexfield segment.
185 * @param p_per_information27 Developer descriptive flexfield segment.
186 * @param p_per_information28 Developer descriptive flexfield segment.
187 * @param p_per_information29 Developer descriptive flexfield segment.
188 * @param p_per_information30 Developer descriptive flexfield segment.
189 * @param p_person_id If p_validate is false, then this uniquely identifies the
190 * person created. If p_validate is true, then set to null.
191 * @param p_per_object_version_number If p_validate is false, then set to the
192 * version number of the created person. If p_validate is true, then the value
193 * will be null.
194 * @param p_per_effective_start_date If p_validate is false, this will be set
195 * to the effective start date of the person. If p_validate is true this will
196 * be null.
197 * @param p_per_effective_end_date If p_validate is false, this will be set to
198 * the effective end date of the person. If p_validate is true this will be
199 * null.
200 * @param p_pdp_object_version_number If p_validate is false, this will be set
201 * to the version number of the person created. If p_validate is true this
202 * parameter will be set to null.
203 * @param p_full_name If p_validate is false, this will be set to the complete
204 * full name of the person. If p_validate is true this will be null.
205 * @param p_comment_id If p_validate is false and comment text was provided,
206 * then will be set to the identifier of the created contingent worker comment
207 * record. If p_validate is true or no comment text was provided, then will be
208 * null.
209 * @param p_assignment_id If p_validate is false, then this uniquely identifies
210 * the created assignment. If p_validate is true, then set to null.
211 * @param p_asg_object_version_number If p_validate is false, then this
212 * parameter is set to the version number of the assignment created. If
213 * p_validate is true, then this parameter is null.
214 * @param p_assignment_sequence If p_validate is false, this will be set to the
215 * sequence number of the default assignment created. If p_validate is true
216 * this parameter will be set to null.
217 * @param p_assignment_number If p_validate is false this will be set to the
218 * assignment number of the primary assignment. If p_validate is true this will
219 * be null.
220 * @param p_name_combination_warning If set to true, then the combination of
221 * last name, first name and date of birth existed prior to calling this API.
222 * @rep:displayname Create Contigent Worker for Poland
223 * @rep:category BUSINESS_ENTITY PER_CWK
224 * @rep:scope public
225 * @rep:lifecycle deprecated
226 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
227 */
228 --
229 -- {End Of Comments}
230 --
231 procedure create_pl_cwk
232 (p_validate in boolean default false
233 ,p_start_date in date
234 ,p_business_group_id in number
235 ,p_last_name in varchar2
236 ,p_person_type_id in number default null
237 ,p_npw_number in out nocopy varchar2
238 ,p_background_check_status in varchar2 default null
239 ,p_background_date_check in date default null
240 ,p_blood_type in varchar2 default null
241 ,p_comments in varchar2 default null
242 ,p_correspondence_language in varchar2 default null
243 ,p_country_of_birth in varchar2 default null
244 ,p_date_of_birth in date default null
245 ,p_date_of_death in date default null
246 ,p_dpdnt_adoption_date in date default null
247 ,p_dpdnt_vlntry_svce_flag in varchar2 default null
248 ,p_email_address in varchar2 default null
249 ,p_first_name in varchar2
250 ,p_fte_capacity in number default null
251 ,p_honors in varchar2 default null
252 ,p_internal_location in varchar2 default null
253 ,p_preferred_name in varchar2 default null
254 ,p_last_medical_test_by in varchar2 default null
255 ,p_last_medical_test_date in date default null
256 ,p_mailstop in varchar2 default null
257 ,p_marital_status in varchar2 default null
258 ,p_middle_names in varchar2 default null
259 ,p_pesel_number in varchar2 default null
260 ,p_nationality in varchar2 default null
264 ,p_prefix in varchar2 default null
261 ,p_office_number in varchar2 default null
262 ,p_on_military_service in varchar2 default null
263 ,p_party_id in number default null
265 ,p_maiden_name in varchar2 default null
266 ,p_projected_placement_end in date default null
267 ,p_receipt_of_death_cert_date in date default null
268 ,p_region_of_birth in varchar2 default null
269 ,p_registered_disabled_flag in varchar2 default null
270 ,p_resume_exists in varchar2 default null
271 ,p_resume_last_updated in date default null
272 ,p_second_passport_exists in varchar2 default null
273 ,p_sex in varchar2 default null
274 ,p_student_status in varchar2 default null
275 ,p_suffix in varchar2 default null
276 ,p_title in varchar2 default null
277 ,p_town_of_birth in varchar2 default null
278 ,p_uses_tobacco_flag in varchar2 default null
279 ,p_vendor_id in number default null
280 ,p_work_schedule in varchar2 default null
281 ,p_work_telephone in varchar2 default null
282 ,p_exp_check_send_to_address in varchar2 default null
283 ,p_hold_applicant_date_until in date default null
284 ,p_date_employee_data_verified in date default null
285 ,p_benefit_group_id in number default null
286 ,p_coord_ben_med_pln_no in varchar2 default null
287 ,p_coord_ben_no_cvg_flag in varchar2 default null
288 ,p_original_date_of_hire in date default null
289 ,p_attribute_category in varchar2 default null
290 ,p_attribute1 in varchar2 default null
291 ,p_attribute2 in varchar2 default null
292 ,p_attribute3 in varchar2 default null
293 ,p_attribute4 in varchar2 default null
294 ,p_attribute5 in varchar2 default null
295 ,p_attribute6 in varchar2 default null
296 ,p_attribute7 in varchar2 default null
297 ,p_attribute8 in varchar2 default null
298 ,p_attribute9 in varchar2 default null
299 ,p_attribute10 in varchar2 default null
300 ,p_attribute11 in varchar2 default null
301 ,p_attribute12 in varchar2 default null
302 ,p_attribute13 in varchar2 default null
303 ,p_attribute14 in varchar2 default null
304 ,p_attribute15 in varchar2 default null
305 ,p_attribute16 in varchar2 default null
306 ,p_attribute17 in varchar2 default null
307 ,p_attribute18 in varchar2 default null
308 ,p_attribute19 in varchar2 default null
309 ,p_attribute20 in varchar2 default null
310 ,p_attribute21 in varchar2 default null
311 ,p_attribute22 in varchar2 default null
312 ,p_attribute23 in varchar2 default null
313 ,p_attribute24 in varchar2 default null
314 ,p_attribute25 in varchar2 default null
315 ,p_attribute26 in varchar2 default null
316 ,p_attribute27 in varchar2 default null
317 ,p_attribute28 in varchar2 default null
318 ,p_attribute29 in varchar2 default null
319 ,p_attribute30 in varchar2 default null
320 ,p_per_information_category in varchar2 default null
321 ,p_nip_number in varchar2 default null
322 ,p_per_information2 in varchar2 default null
323 ,p_per_information3 in varchar2 default null
324 ,p_per_information4 in varchar2 default null
325 ,p_per_information5 in varchar2 default null
326 ,p_per_information6 in varchar2 default null
327 ,p_per_information7 in varchar2 default null
328 ,p_per_information8 in varchar2 default null
329 ,p_per_information9 in varchar2 default null
330 ,p_per_information10 in varchar2 default null
331 ,p_per_information11 in varchar2 default null
332 ,p_per_information12 in varchar2 default null
333 ,p_per_information13 in varchar2 default null
334 ,p_per_information14 in varchar2 default null
335 ,p_per_information15 in varchar2 default null
336 ,p_per_information16 in varchar2 default null
337 ,p_per_information17 in varchar2 default null
338 ,p_per_information18 in varchar2 default null
339 ,p_per_information19 in varchar2 default null
340 ,p_per_information20 in varchar2 default null
341 ,p_per_information21 in varchar2 default null
342 ,p_per_information22 in varchar2 default null
343 ,p_per_information23 in varchar2 default null
344 ,p_per_information24 in varchar2 default null
345 ,p_per_information25 in varchar2 default null
346 ,p_per_information26 in varchar2 default null
347 ,p_per_information27 in varchar2 default null
348 ,p_per_information28 in varchar2 default null
349 ,p_per_information29 in varchar2 default null
350 ,p_per_information30 in varchar2 default null
351 ,p_person_id out nocopy number
352 ,p_per_object_version_number out nocopy number
356 ,p_full_name out nocopy varchar2
353 ,p_per_effective_start_date out nocopy date
354 ,p_per_effective_end_date out nocopy date
355 ,p_pdp_object_version_number out nocopy number
357 ,p_comment_id out nocopy number
358 ,p_assignment_id out nocopy number
359 ,p_asg_object_version_number out nocopy number
360 ,p_assignment_sequence out nocopy number
361 ,p_assignment_number out nocopy varchar2
362 ,p_name_combination_warning out nocopy boolean
363 );
364 --
365 -- ----------------------------------------------------------------------------
366 -- |----------------------------< create_pl_cwk >-----------------------------|
367 -- ----------------------------------------------------------------------------
368 -- {Start Of Comments}
369 /*#
370 * The following procedure creates a Polish contingent worker.
371 *
372 * This procedure is used to create a person record and a default contingent
373 * worker assignment for a new non-payroll worker.
374 *
375 * <p><b>Licensing</b><br>
376 * This API is licensed for use with Human Resources.
377 *
378 * <p><b>Prerequisites</b><br>
379 * The business group for Poland legislation must already exist. Also a valid
380 * person_type_id, with a corresponding system type of 'CWK', must be active
381 * and in the same business group as that of the applicant being created.
382 *
383 * <p><b>Post Success</b><br>
384 * The person, primary contingent worker assignment and period of placement
385 * will be successfully inserted into the database.
386 *
387 * <p><b>Post Failure</b><br>
388 * The contingent worker will not be created and an error will be raised.
389 *
390 * @param p_validate If true, then validation alone will be performed and the
391 * database will remain unchanged. If false and all validation checks pass,
392 * then the database will be modified.
393 * @param p_start_date Start date for person, default assignment and placement
394 * record.
395 * @param p_business_group_id The contingent worker's business group.
396 * @param p_last_name Last name of the contingent worker.
397 * @param p_person_type_id This is the identifier corrresponding to the type of
398 * person. If an identification number is not specified, then the API will use
399 * the default 'CWK' type for the business group.
400 * @param p_npw_number Number of non-payroll worker.
401 * @param p_background_check_status Yes/No flag indicates whether
402 * background check has been performed.
403 * @param p_background_date_check Date background check was performed.
404 * @param p_blood_type Blood type of the contingent worker.
405 * @param p_comments Contingent worker comment text.
406 * @param p_correspondence_language Preferred language for correspondance.
407 * @param p_country_of_birth Country of birth of the contingent worker.
408 * @param p_date_of_birth Date of birth of the contingent worker.
409 * @param p_date_of_death Date of death of the contingent worker.
410 * @param p_dpdnt_adoption_date Date dependent was adopted.
411 * @param p_dpdnt_vlntry_svce_flag Indicates whether the dependent is on
412 * voluntary service.
413 * @param p_email_address Email address of the contingent worker.
414 * @param p_first_name First name of the contingent worker.
415 * @param p_fte_capacity Full-time employment capacity of the contingent
416 * worker.
417 * @param p_honors Honors or degrees awarded.
418 * @param p_internal_location Internal location of office of the contingent
419 * worker.
420 * @param p_preferred_name Alternative name of the contingent worker.
421 * @param p_last_medical_test_by Name of physician who performed last medical
422 * test.
423 * @param p_last_medical_test_date Date of last medical test.
424 * @param p_mailstop Internal mail location for the contingent worker.
425 * @param p_marital_status Marital status of the contingent worker. Valid
426 * values are defined by 'MAR_STATUS' lookup type.
427 * @param p_middle_names Contingent worker's middle name(s).
428 * @param p_pesel National identifier of the contingent worker.
429 * @param p_nationality Contingent worker's nationality. Valid values are
430 * defined by 'NATIONALITY' lookup type.
431 * @param p_office_number Office Number of the contingent worker.
432 * @param p_on_military_service Yes/No flag indicating whether the contingent
433 * worker is employed in military service.
434 * @param p_party_id Identifier for the party.
435 * @param p_prefix Obsolete parameter, do not use.
436 * @param p_maiden_name Previous last name of the contingent worker.
437 * @param p_projected_placement_end Obsolete parameter, do not use.
438 * @param p_receipt_of_death_cert_date Date when the death certificate is
439 * received.
440 * @param p_region_of_birth Geographical region of birth of the contingent
441 * worker.
442 * @param p_registered_disabled_flag Indicates whether person is classified as
443 * disabled. Valid values are defined by 'REGISTERED_DISABLED' lookup type.
444 * @param p_resume_exists Yes/No flag indicating whether resume is on file.
445 * @param p_resume_last_updated Date when the resume was last updated.
446 * @param p_second_passport_exists Yes/No flag indicaing whether the person has
447 * multiple passports.
448 * @param p_sex Contingent worker's gender.
449 * @param p_student_status Full time/part time status of the contingent worker.
450 * @param p_suffix Obsolete parameter, do not use.
451 * @param p_title Title of the contingent worker. Valid values are defined by
452 * 'TITLE' lookup type.
453 * @param p_town_of_birth Town or city of birth of the contingent worker.
454 * @param p_uses_tobacco_flag Tobacoo type used by the contingent worker. Valid
455 * values are defined by 'TOBACCO_USER' lookup type.
456 * @param p_vendor_id Identifier for the organisation supplying contingent
457 * workers.
461 * @param p_work_telephone Work telephone of the contingent worker.
458 * @param p_work_schedule Type of work schedule indicating which days the
459 * contingent worker works. Valid values are defined by 'WORK_SCHEDULE' lookup
460 * type.
462 * @param p_exp_check_send_to_address Mailing address of the contingent worker.
463 * @param p_hold_applicant_date_until Date until which the applicant should be
464 * put on hold.
465 * @param p_date_employee_data_verified Date when the employee last verified
466 * the data.
467 * @param p_benefit_group_id Identification for benefit group.
468 * @param p_coord_ben_med_pln_no Coordination of benefits medical group plan
469 * number.
470 * @param p_coord_ben_no_cvg_flag Coordination of benefits no other coverage
471 * flag.
472 * @param p_original_date_of_hire Original date of hire of the contingent
473 * worker.
474 * @param p_attribute_category This context value determines which flexfield
475 * structure to use with the descriptive flexfield segments.
476 * @param p_attribute1 Descriptive flexfield segment.
477 * @param p_attribute2 Descriptive flexfield segment.
478 * @param p_attribute3 Descriptive flexfield segment.
479 * @param p_attribute4 Descriptive flexfield segment.
480 * @param p_attribute5 Descriptive flexfield segment.
481 * @param p_attribute6 Descriptive flexfield segment.
482 * @param p_attribute7 Descriptive flexfield segment.
483 * @param p_attribute8 Descriptive flexfield segment.
484 * @param p_attribute9 Descriptive flexfield segment.
485 * @param p_attribute10 Descriptive flexfield segment.
486 * @param p_attribute11 Descriptive flexfield segment.
487 * @param p_attribute12 Descriptive flexfield segment.
488 * @param p_attribute13 Descriptive flexfield segment.
489 * @param p_attribute14 Descriptive flexfield segment.
490 * @param p_attribute15 Descriptive flexfield segment.
491 * @param p_attribute16 Descriptive flexfield segment.
492 * @param p_attribute17 Descriptive flexfield segment.
493 * @param p_attribute18 Descriptive flexfield segment.
494 * @param p_attribute19 Descriptive flexfield segment.
495 * @param p_attribute20 Descriptive flexfield segment.
496 * @param p_attribute21 Descriptive flexfield segment.
497 * @param p_attribute22 Descriptive flexfield segment.
498 * @param p_attribute23 Descriptive flexfield segment.
499 * @param p_attribute24 Descriptive flexfield segment.
500 * @param p_attribute25 Descriptive flexfield segment.
501 * @param p_attribute26 Descriptive flexfield segment.
502 * @param p_attribute27 Descriptive flexfield segment.
503 * @param p_attribute28 Descriptive flexfield segment.
504 * @param p_attribute29 Descriptive flexfield segment.
505 * @param p_attribute30 Descriptive flexfield segment.
506 * @param p_per_information_category Obsolete parameter, do not use.
507 * @param p_nip Contingent worker's national Polish tax
508 * identifier.
509 * @param p_oldage_pension_rights This indicates whether the contingent worker
510 * has old age or pension rights.'Valid values are defined by
511 * 'PL_OLDAGE_PENSION_RIGHTS' lookup type.
512 * @param p_national_fund_of_health This indicates the national fund of health
513 * to which the contingent worker belongs.Valid values are defined by
514 * 'PL_NATIONAL_FUND_OF_HEALTH' lookup type.
515 * @param p_tax_office Specifies the tax office of the contingent worker.
516 * @param p_legal_employer Specifies the legal employer of the contingent worker.
517 * @param p_citizenship This indicates the citizenship of the contingent worker.
518 * Valid values are defined by 'PL_CITIZENSHIP' lookup type.
519 * @param p_person_id If p_validate is false, then this uniquely identifies the
520 * person created. If p_validate is true, then set to null.
521 * @param p_per_object_version_number If p_validate is false, then set to the
522 * version number of the created person. If p_validate is true, then the value
523 * will be null.
524 * @param p_per_effective_start_date If p_validate is false, this will be set
525 * to the effective start date of the person. If p_validate is true this will
526 * be null.
527 * @param p_per_effective_end_date If p_validate is false, this will be set to
528 * the effective end date of the person. If p_validate is true this will be
529 * null.
530 * @param p_pdp_object_version_number If p_validate is false, this will be set
531 * to the version number of the person created. If p_validate is true this
532 * parameter will be set to null.
533 * @param p_full_name If p_validate is false, this will be set to the complete
534 * full name of the person. If p_validate is true this will be null.
535 * @param p_comment_id If p_validate is false and comment text was provided,
536 * then will be set to the identifier of the created contingent worker comment
537 * record. If p_validate is true or no comment text was provided, then will be
538 * null.
539 * @param p_assignment_id If p_validate is false, then this uniquely identifies
540 * the created assignment. If p_validate is true, then set to null.
541 * @param p_asg_object_version_number If p_validate is false, then this
542 * parameter is set to the version number of the assignment created. If
543 * p_validate is true, then this parameter is null.
544 * @param p_assignment_sequence If p_validate is false, this will be set to the
545 * sequence number of the default assignment created. If p_validate is true
546 * this parameter will be set to null.
547 * @param p_assignment_number If p_validate is false this will be set to the
548 * assignment number of the primary assignment. If p_validate is true this will
549 * be null.
550 * @param p_name_combination_warning If set to true, then the combination of
551 * last name, first name and date of birth existed prior to calling this API.
552 * @rep:displayname Create Contigent Worker for Poland
553 * @rep:category BUSINESS_ENTITY PER_CWK
554 * @rep:primaryinstance
555 * @rep:scope public
556 * @rep:lifecycle active
557 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
558 */
559 --
560 -- {End Of Comments}
564 (p_validate in boolean default false
561 --
562
563 procedure create_pl_cwk
565 ,p_start_date in date
566 ,p_business_group_id in number
567 ,p_last_name in varchar2
568 ,p_person_type_id in number default null
569 ,p_npw_number in out nocopy varchar2
570 ,p_background_check_status in varchar2 default null
571 ,p_background_date_check in date default null
572 ,p_blood_type in varchar2 default null
573 ,p_comments in varchar2 default null
574 ,p_correspondence_language in varchar2 default null
575 ,p_country_of_birth in varchar2 default null
576 ,p_date_of_birth in date default null
577 ,p_date_of_death in date default null
578 ,p_dpdnt_adoption_date in date default null
579 ,p_dpdnt_vlntry_svce_flag in varchar2 default null
580 ,p_email_address in varchar2 default null
581 ,p_first_name in varchar2
582 ,p_fte_capacity in number default null
583 ,p_honors in varchar2 default null
584 ,p_internal_location in varchar2 default null
585 ,p_preferred_name in varchar2 default null
586 ,p_last_medical_test_by in varchar2 default null
587 ,p_last_medical_test_date in date default null
588 ,p_mailstop in varchar2 default null
589 ,p_marital_status in varchar2 default null
590 ,p_middle_names in varchar2 default null
591 ,p_pesel in varchar2 default null
592 ,p_nationality in varchar2 default null
593 ,p_office_number in varchar2 default null
594 ,p_on_military_service in varchar2 default null
595 ,p_party_id in number default null
596 ,p_prefix in varchar2 default null
597 ,p_maiden_name in varchar2 default null
598 ,p_projected_placement_end in date default null
599 ,p_receipt_of_death_cert_date in date default null
600 ,p_region_of_birth in varchar2 default null
601 ,p_registered_disabled_flag in varchar2 default null
602 ,p_resume_exists in varchar2 default null
603 ,p_resume_last_updated in date default null
604 ,p_second_passport_exists in varchar2 default null
605 ,p_sex in varchar2 default null
606 ,p_student_status in varchar2 default null
607 ,p_suffix in varchar2 default null
608 ,p_title in varchar2 default null
609 ,p_town_of_birth in varchar2 default null
610 ,p_uses_tobacco_flag in varchar2 default null
611 ,p_vendor_id in number default null
612 ,p_work_schedule in varchar2 default null
613 ,p_work_telephone in varchar2 default null
614 ,p_exp_check_send_to_address in varchar2 default null
615 ,p_hold_applicant_date_until in date default null
616 ,p_date_employee_data_verified in date default null
617 ,p_benefit_group_id in number default null
618 ,p_coord_ben_med_pln_no in varchar2 default null
619 ,p_coord_ben_no_cvg_flag in varchar2 default null
620 ,p_original_date_of_hire in date default null
621 ,p_attribute_category in varchar2 default null
622 ,p_attribute1 in varchar2 default null
623 ,p_attribute2 in varchar2 default null
624 ,p_attribute3 in varchar2 default null
625 ,p_attribute4 in varchar2 default null
626 ,p_attribute5 in varchar2 default null
627 ,p_attribute6 in varchar2 default null
628 ,p_attribute7 in varchar2 default null
629 ,p_attribute8 in varchar2 default null
630 ,p_attribute9 in varchar2 default null
631 ,p_attribute10 in varchar2 default null
632 ,p_attribute11 in varchar2 default null
633 ,p_attribute12 in varchar2 default null
634 ,p_attribute13 in varchar2 default null
635 ,p_attribute14 in varchar2 default null
636 ,p_attribute15 in varchar2 default null
637 ,p_attribute16 in varchar2 default null
638 ,p_attribute17 in varchar2 default null
639 ,p_attribute18 in varchar2 default null
640 ,p_attribute19 in varchar2 default null
641 ,p_attribute20 in varchar2 default null
642 ,p_attribute21 in varchar2 default null
643 ,p_attribute22 in varchar2 default null
644 ,p_attribute23 in varchar2 default null
645 ,p_attribute24 in varchar2 default null
646 ,p_attribute25 in varchar2 default null
647 ,p_attribute26 in varchar2 default null
648 ,p_attribute27 in varchar2 default null
649 ,p_attribute28 in varchar2 default null
650 ,p_attribute29 in varchar2 default null
651 ,p_attribute30 in varchar2 default null
652 ,p_per_information_category in varchar2 default null
653 ,p_nip in varchar2 default null
654 ,p_oldage_pension_rights in varchar2 default null
655 ,p_national_fund_of_health in varchar2 default null
656 ,p_tax_office in varchar2 default null
657 ,p_legal_employer in varchar2 default null
658 ,p_citizenship in varchar2 default null
659 ,p_person_id out nocopy number
660 ,p_per_object_version_number out nocopy number
661 ,p_per_effective_start_date out nocopy date
662 ,p_per_effective_end_date out nocopy date
663 ,p_pdp_object_version_number out nocopy number
664 ,p_full_name out nocopy varchar2
665 ,p_comment_id out nocopy number
666 ,p_assignment_id out nocopy number
667 ,p_asg_object_version_number out nocopy number
668 ,p_assignment_sequence out nocopy number
669 ,p_assignment_number out nocopy varchar2
670 ,p_name_combination_warning out nocopy boolean
671 );
672 End hr_pl_contingent_worker_api;
[Home] [Help]