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