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