1 Package HR_JPBP_API as
2 /* $Header: pejpapi.pkh 120.3 2005/11/02 06:12:43 sgottipa noship $ */
3 /*#
4 * This package contains business process APIs for Japan.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Business Process for Japan
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------------< create_jp_educ_sit >------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a special information record of JP Educational Background
17 * for a person identified by person_id for the Japan localization.
18 *
19 *
20 * <p><b>Licensing</b><br>
21 * This API is licensed for use with Human Resources.
22 *
23 * <p><b>Prerequisites</b><br>
24 * A person identified by person_id must exist in a JP business group. Special
25 * Information Type of JP Educational Background must be set enabled against
26 * the business group.
27 *
28 * <p><b>Post Success</b><br>
29 * The special information will be successfully inserted into the database.
30 *
31 * <p><b>Post Failure</b><br>
32 * The special information will not be created and an error will be raised.
33 * @param p_validate If true, then validation alone will be performed and the
34 * database will remain unchanged. If false and all validation checks pass,
35 * then the database will be modified.
36 * @param p_person_id Identifies the person for whom you create the special
37 * information record.
38 * @param p_business_group_id Business group id.
39 * @param p_effective_date Reference date for validating the person. This date
40 * does not determine when the changes take effect.
41 * @param p_comments Comment text.
42 * @param p_date_from {@rep:casecolumn PER_PERSON_ANALYSES.DATE_FROM}
43 * @param p_date_to {@rep:casecolumn PER_PERSON_ANALYSES.DATE_TO}
44 * @param p_attribute_category This context value determines which flexfield
45 * structure to use with the descriptive flexfield segments.
46 * @param p_attribute1 Descriptive flexfield segment.
47 * @param p_attribute2 Descriptive flexfield segment.
48 * @param p_attribute3 Descriptive flexfield segment.
49 * @param p_attribute4 Descriptive flexfield segment.
50 * @param p_attribute5 Descriptive flexfield segment.
51 * @param p_attribute6 Descriptive flexfield segment.
52 * @param p_attribute7 Descriptive flexfield segment.
53 * @param p_attribute8 Descriptive flexfield segment.
54 * @param p_attribute9 Descriptive flexfield segment.
55 * @param p_attribute10 Descriptive flexfield segment.
56 * @param p_attribute11 Descriptive flexfield segment.
57 * @param p_attribute12 Descriptive flexfield segment.
58 * @param p_attribute13 Descriptive flexfield segment.
59 * @param p_attribute14 Descriptive flexfield segment.
60 * @param p_attribute15 Descriptive flexfield segment.
61 * @param p_attribute16 Descriptive flexfield segment.
62 * @param p_attribute17 Descriptive flexfield segment.
63 * @param p_attribute18 Descriptive flexfield segment.
64 * @param p_attribute19 Descriptive flexfield segment.
65 * @param p_attribute20 Descriptive flexfield segment.
66 * @param p_segment1 JP Educ Bkgrd flexfield segment.
67 * @param p_segment2 JP Educ Bkgrd flexfield segment.
68 * @param p_segment3 JP Educ Bkgrd flexfield segment.
69 * @param p_segment4 JP Educ Bkgrd flexfield segment.
70 * @param p_segment5 JP Educ Bkgrd flexfield segment.
71 * @param p_segment6 JP Educ Bkgrd flexfield segment.
72 * @param p_segment7 JP Educ Bkgrd flexfield segment.
73 * @param p_segment8 JP Educ Bkgrd flexfield segment.
74 * @param p_segment9 JP Educ Bkgrd flexfield segment.
75 * @param p_segment10 JP Educ Bkgrd flexfield segment.
76 * @param p_segment11 JP Educ Bkgrd flexfield segment.
77 * @param p_segment12 JP Educ Bkgrd flexfield segment.
78 * @param p_segment13 JP Educ Bkgrd flexfield segment.
79 * @param p_segment14 JP Educ Bkgrd flexfield segment.
80 * @param p_segment15 JP Educ Bkgrd flexfield segment.
81 * @param p_segment16 JP Educ Bkgrd flexfield segment.
82 * @param p_segment17 JP Educ Bkgrd flexfield segment.
83 * @param p_segment18 JP Educ Bkgrd flexfield segment.
84 * @param p_segment19 JP Educ Bkgrd flexfield segment.
85 * @param p_segment20 JP Educ Bkgrd flexfield segment.
86 * @param p_segment21 JP Educ Bkgrd flexfield segment.
87 * @param p_segment22 JP Educ Bkgrd flexfield segment.
88 * @param p_segment23 JP Educ Bkgrd flexfield segment.
89 * @param p_segment24 JP Educ Bkgrd flexfield segment.
90 * @param p_segment25 JP Educ Bkgrd flexfield segment.
91 * @param p_segment26 JP Educ Bkgrd flexfield segment.
92 * @param p_segment27 JP Educ Bkgrd flexfield segment.
93 * @param p_segment28 JP Educ Bkgrd flexfield segment.
94 * @param p_segment29 JP Educ Bkgrd flexfield segment.
95 * @param p_segment30 JP Educ Bkgrd flexfield segment.
96 * @param p_analysis_criteria_id If p_validate is false, this uniquely
97 * identifies the combination of the personal analysis flexfield segments
98 * created. If p_validate is true this parameter will be null.
99 * @param p_person_analysis_id If p_validate is false, this uniquely identifies
100 * the special information record created. If p_validate is true this parameter
101 * will be null.
102 * @param p_pea_object_version_number If p_validate is false, then set to the
103 * version number of the created special information record. If p_validate is
104 * true, then the value will be null.
105 * @rep:displayname Create Educational Background Special Information Type for Japan
106 * @rep:category BUSINESS_ENTITY HR_PERSON
107 * @rep:scope public
108 * @rep:lifecycle active
109 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
110 */
111 --
112 -- {End Of Comments}
113 --
114 procedure create_jp_educ_sit
115 ( p_validate in boolean default false
116 ,p_person_id in number
117 ,p_business_group_id in number
118 ,p_effective_date in date
119 ,p_comments in varchar2 default null
120 ,p_date_from in date default null
121 ,p_date_to in date default null
122 ,p_attribute_category in varchar2 default null
123 ,p_attribute1 in varchar2 default null
124 ,p_attribute2 in varchar2 default null
125 ,p_attribute3 in varchar2 default null
126 ,p_attribute4 in varchar2 default null
127 ,p_attribute5 in varchar2 default null
128 ,p_attribute6 in varchar2 default null
129 ,p_attribute7 in varchar2 default null
130 ,p_attribute8 in varchar2 default null
131 ,p_attribute9 in varchar2 default null
132 ,p_attribute10 in varchar2 default null
133 ,p_attribute11 in varchar2 default null
134 ,p_attribute12 in varchar2 default null
135 ,p_attribute13 in varchar2 default null
136 ,p_attribute14 in varchar2 default null
137 ,p_attribute15 in varchar2 default null
138 ,p_attribute16 in varchar2 default null
139 ,p_attribute17 in varchar2 default null
140 ,p_attribute18 in varchar2 default null
141 ,p_attribute19 in varchar2 default null
142 ,p_attribute20 in varchar2 default null
143 ,p_segment1 in varchar2 default null
144 ,p_segment2 in varchar2 default null
145 ,p_segment3 in varchar2 default null
146 ,p_segment4 in varchar2 default null
147 ,p_segment5 in varchar2 default null
148 ,p_segment6 in varchar2 default null
149 ,p_segment7 in varchar2 default null
150 ,p_segment8 in varchar2 default null
151 ,p_segment9 in varchar2 default null
152 ,p_segment10 in varchar2 default null
153 ,p_segment11 in varchar2 default null
154 ,p_segment12 in varchar2 default null
155 ,p_segment13 in varchar2 default null
156 ,p_segment14 in varchar2 default null
157 ,p_segment15 in varchar2 default null
158 ,p_segment16 in varchar2 default null
159 ,p_segment17 in varchar2 default null
160 ,p_segment18 in varchar2 default null
161 ,p_segment19 in varchar2 default null
162 ,p_segment20 in varchar2 default null
163 ,p_segment21 in varchar2 default null
164 ,p_segment22 in varchar2 default null
165 ,p_segment23 in varchar2 default null
166 ,p_segment24 in varchar2 default null
167 ,p_segment25 in varchar2 default null
168 ,p_segment26 in varchar2 default null
169 ,p_segment27 in varchar2 default null
170 ,p_segment28 in varchar2 default null
171 ,p_segment29 in varchar2 default null
172 ,p_segment30 in varchar2 default null
173 ,p_analysis_criteria_id out nocopy number
174 ,p_person_analysis_id out nocopy number
175 ,p_pea_object_version_number out nocopy number
176 );
177 --
178 -- ----------------------------------------------------------------------------
179 -- |-----------------------< create_jp_employee_with_sit >--------------------|
180 -- ----------------------------------------------------------------------------
181 --
182 -- {Start Of Comments}
183 /*#
184 * This API creates a new JP employee including a special information record, a
185 * default primary assignment and a period of service for the employee.
186 *
187 *
188 * <p><b>Licensing</b><br>
189 * This API is licensed for use with Human Resources.
190 *
191 * <p><b>Prerequisites</b><br>
192 * If person_type_id is supplied, it must have a corresponding system person
193 * type of 'EMP', must be active and be in the same business group as that of
194 * the employee being created. Special Information Type must be set enabled
195 * against the business group.
196 *
197 * <p><b>Post Success</b><br>
198 * The person, special information record, primary assignment and period of
199 * service will be successfully created.
200 *
201 * <p><b>Post Failure</b><br>
202 * The person, special information record, primary assignment and period of
203 * service will not be created and an error will be raised.
204 * @param p_validate If true, then validation alone will be performed and the
205 * database will remain unchanged. If false and all validation checks pass,
206 * then the database will be modified.
207 * @param p_hire_date The employee hire date and the effective start date of
208 * the person, primary assignment and period of service.
209 * @param p_business_group_id The employee's Business Group ID.
210 * @param p_last_name Employee's last name (Kanji).
211 * @param p_last_name_kana Employee's last name (Kana).
212 * @param p_sex {@rep:casecolumn PER_ALL_PEOPLE_F.SEX}
213 * @param p_person_type_id Person type id. If this value is omitted then the
214 * person_type_id of the default `EMP' system person type in the employee's
215 * business group is used.
216 * @param p_per_comments Comments for person record.
217 * @param p_date_employee_data_verified The date on which the employee data was
218 * last verified.
219 * @param p_date_of_birth {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_BIRTH}
220 * @param p_email_address {@rep:casecolumn PER_ALL_PEOPLE_F.EMAIL_ADDRESS}
221 * @param p_employee_number The business group's employee number generation
222 * method determines when the API derives and passes out an employee number or
223 * when the calling program should pass in a value. When the API call completes
224 * if p_validate is false then will be set to the employee number. If
225 * p_validate is true then this will be set to the passed value.
226 * @param p_expense_check_send_to_addres {@rep:casecolumn
227 * PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS}
228 * @param p_first_name Employee's first name (Kanji).
229 * @param p_first_name_kana Employee's first name (Kana).
230 * @param p_known_as {@rep:casecolumn PER_ALL_PEOPLE_F.KNOWN_AS}
231 * @param p_marital_status {@rep:casecolumn PER_ALL_PEOPLE_F.MARITAL_STATUS}
232 * @param p_middle_names Employee's middle name(s).
233 * @param p_nationality {@rep:casecolumn PER_ALL_PEOPLE_F.NATIONALITY}
234 * @param p_national_identifier {@rep:casecolumn
235 * PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER}
236 * @param p_previous_last_name Previous last name (Kanji).
237 * @param p_previous_last_name_kana Previous last name (Kana).
238 * @param p_registered_disabled_flag {@rep:casecolumn
239 * PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG}
240 * @param p_title Employee's title.
241 * @param p_vendor_id {@rep:casecolumn PER_ALL_PEOPLE_F.VENDOR_ID}
242 * @param p_work_telephone {@rep:casecolumn PER_ALL_PEOPLE_F.WORK_TELEPHONE}
243 * @param p_per_attribute_category This context value determines which
244 * Flexfield Structure to use with the Descriptive flexfield segments.
245 * @param p_per_attribute1 Descriptive flexfield segment.
246 * @param p_per_attribute2 Descriptive flexfield segment.
247 * @param p_per_attribute3 Descriptive flexfield segment.
248 * @param p_per_attribute4 Descriptive flexfield segment.
249 * @param p_per_attribute5 Descriptive flexfield segment.
250 * @param p_per_attribute6 Descriptive flexfield segment.
251 * @param p_per_attribute7 Descriptive flexfield segment.
252 * @param p_per_attribute8 Descriptive flexfield segment.
253 * @param p_per_attribute9 Descriptive flexfield segment.
254 * @param p_per_attribute10 Descriptive flexfield segment.
255 * @param p_per_attribute11 Descriptive flexfield segment.
256 * @param p_per_attribute12 Descriptive flexfield segment.
257 * @param p_per_attribute13 Descriptive flexfield segment.
258 * @param p_per_attribute14 Descriptive flexfield segment.
259 * @param p_per_attribute15 Descriptive flexfield segment.
260 * @param p_per_attribute16 Descriptive flexfield segment.
261 * @param p_per_attribute17 Descriptive flexfield segment.
262 * @param p_per_attribute18 Descriptive flexfield segment.
263 * @param p_per_attribute19 Descriptive flexfield segment.
264 * @param p_per_attribute20 Descriptive flexfield segment.
265 * @param p_per_attribute21 Descriptive flexfield segment.
266 * @param p_per_attribute22 Descriptive flexfield segment.
267 * @param p_per_attribute23 Descriptive flexfield segment.
268 * @param p_per_attribute24 Descriptive flexfield segment.
269 * @param p_per_attribute25 Descriptive flexfield segment.
270 * @param p_per_attribute26 Descriptive flexfield segment.
271 * @param p_per_attribute27 Descriptive flexfield segment.
272 * @param p_per_attribute28 Descriptive flexfield segment.
273 * @param p_per_attribute29 Descriptive flexfield segment.
274 * @param p_per_attribute30 Descriptive flexfield segment.
275 * @param p_date_of_death {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_DEATH}
276 * @param p_blood_type {@rep:casecolumn PER_ALL_PEOPLE_F.BLOOD_TYPE}
277 * @param p_correspondence_language {@rep:casecolumn
278 * PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE}
279 * @param p_fte_capacity {@rep:casecolumn PER_ALL_PEOPLE_F.FTE_CAPACITY}
280 * @param p_honors {@rep:casecolumn PER_ALL_PEOPLE_F.HONORS}
281 * @param p_internal_location {@rep:casecolumn
282 * PER_ALL_PEOPLE_F.INTERNAL_LOCATION}
283 * @param p_last_medical_test_by {@rep:casecolumn
284 * PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_BY}
285 * @param p_last_medical_test_date {@rep:casecolumn
286 * PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_DATE}
287 * @param p_mailstop {@rep:casecolumn PER_ALL_PEOPLE_F.MAILSTOP}
288 * @param p_office_number {@rep:casecolumn PER_ALL_PEOPLE_F.OFFICE_NUMBER}
289 * @param p_on_military_service {@rep:casecolumn
290 * PER_ALL_PEOPLE_F.ON_MILITARY_SERVICE}
291 * @param p_resume_exists {@rep:casecolumn PER_ALL_PEOPLE_F.RESUME_EXISTS}
292 * @param p_resume_last_updated {@rep:casecolumn
293 * PER_ALL_PEOPLE_F.RESUME_LAST_UPDATED}
294 * @param p_second_passport_exists {@rep:casecolumn
298 * @param p_original_date_of_hire {@rep:casecolumn
295 * PER_ALL_PEOPLE_F.SECOND_PASSPORT_EXISTS}
296 * @param p_student_status {@rep:casecolumn PER_ALL_PEOPLE_F.STUDENT_STATUS}
297 * @param p_work_schedule {@rep:casecolumn PER_ALL_PEOPLE_F.WORK_SCHEDULE}
299 * PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE}
300 * @param p_person_id If p_validate is false, then this uniquely identifies the
301 * person created. If p_validate is true, then set to null.
302 * @param p_assignment_id If p_validate is false, then this uniquely identifies
303 * the created assignment. If p_validate is true, then set to null.
304 * @param p_per_object_version_number If p_validate is false, then set to the
305 * version number of the created person. If p_validate is true, then the value
306 * will be null.
307 * @param p_asg_object_version_number If p_validate is false, then this
308 * parameter is set to the version number of the assignment created. If
309 * p_validate is true, then this parameter is null.
310 * @param p_per_effective_start_date If p_validate is false, then set to the
311 * earliest effective start date for the created person. If p_validate is true,
312 * then set to null.
313 * @param p_per_effective_end_date If p_validate is false, then set to the
314 * effective end date for the created person. If p_validate is true, then set
315 * to null.
316 * @param p_full_name If p_validate is false, this will be set to the complete
317 * full name of the person. If p_validate is true this will be null.
318 * @param p_per_comment_id If p_validate is false and comment text was
319 * provided, then this will be set to the identifier of the created person
320 * comment record. If p_validate is true or no comment text was provided, then
321 * this will be null.
322 * @param p_assignment_sequence If p_validate is false this will be set to the
323 * sequence number of the primary assignment. If p_validate is true this will
324 * be null.
325 * @param p_assignment_number If p_validate is false this will be set to the
326 * assignment number of the primary assignment. If p_validate is true this will
327 * be null.
328 * @param p_name_combination_warning If set to true, then the combination of
329 * last name, first name and date of birth existed prior to calling this API.
330 * @param p_assign_payroll_warning If set to true, then the date of birth is
331 * not entered. If set to false, then the date of birth has been entered.
332 * Indicates if it will be possible to set the payroll on any of this person's
333 * assignments.
334 * @param p_orig_hire_warning This is set to true if the original date of hire
335 * is not null and the person type is not EMP,EMP_APL, EX_EMP or EX_EMP_APL.
336 * @param p_id_flex_num Id flex number of the Personal Analysis key flexfield
337 * structure.
338 * @param p_pea_comments Comments.
339 * @param p_date_from The date from which the special information record
340 * applies.
341 * @param p_date_to The date on which the special information record no longer
342 * applies.
343 * @param p_pea_attribute_category This context value determines which
344 * Flexfield Structure to use with the Descriptive flexfield segments.
345 * @param p_pea_attribute1 Descriptive flexfield segment.
346 * @param p_pea_attribute2 Descriptive flexfield segment.
347 * @param p_pea_attribute3 Descriptive flexfield segment.
348 * @param p_pea_attribute4 Descriptive flexfield segment.
349 * @param p_pea_attribute5 Descriptive flexfield segment.
350 * @param p_pea_attribute6 Descriptive flexfield segment.
351 * @param p_pea_attribute7 Descriptive flexfield segment.
352 * @param p_pea_attribute8 Descriptive flexfield segment.
353 * @param p_pea_attribute9 Descriptive flexfield segment.
354 * @param p_pea_attribute10 Descriptive flexfield segment.
355 * @param p_pea_attribute11 Descriptive flexfield segment.
356 * @param p_pea_attribute12 Descriptive flexfield segment.
357 * @param p_pea_attribute13 Descriptive flexfield segment.
358 * @param p_pea_attribute14 Descriptive flexfield segment.
359 * @param p_pea_attribute15 Descriptive flexfield segment.
360 * @param p_pea_attribute16 Descriptive flexfield segment.
361 * @param p_pea_attribute17 Descriptive flexfield segment.
362 * @param p_pea_attribute18 Descriptive flexfield segment.
363 * @param p_pea_attribute19 Descriptive flexfield segment.
364 * @param p_pea_attribute20 Descriptive flexfield segment.
365 * @param p_segment1 Key flexfield segment.
366 * @param p_segment2 Key flexfield segment.
367 * @param p_segment3 Key flexfield segment.
368 * @param p_segment4 Key flexfield segment.
369 * @param p_segment5 Key flexfield segment.
370 * @param p_segment6 Key flexfield segment.
371 * @param p_segment7 Key flexfield segment.
372 * @param p_segment8 Key flexfield segment.
373 * @param p_segment9 Key flexfield segment.
374 * @param p_segment10 Key flexfield segment.
375 * @param p_segment11 Key flexfield segment.
376 * @param p_segment12 Key flexfield segment.
377 * @param p_segment13 Key flexfield segment.
378 * @param p_segment14 Key flexfield segment.
379 * @param p_segment15 Key flexfield segment.
380 * @param p_segment16 Key flexfield segment.
381 * @param p_segment17 Key flexfield segment.
382 * @param p_segment18 Key flexfield segment.
383 * @param p_segment19 Key flexfield segment.
384 * @param p_segment20 Key flexfield segment.
385 * @param p_segment21 Key flexfield segment.
386 * @param p_segment22 Key flexfield segment.
387 * @param p_segment23 Key flexfield segment.
388 * @param p_segment24 Key flexfield segment.
389 * @param p_segment25 Key flexfield segment.
390 * @param p_segment26 Key flexfield segment.
391 * @param p_segment27 Key flexfield segment.
392 * @param p_segment28 Key flexfield segment.
393 * @param p_segment29 Key flexfield segment.
397 * true, then the value will be null.
394 * @param p_segment30 Key flexfield segment.
395 * @param p_pea_object_version_number If p_validate is false, then set to the
396 * version number of the created special information record. If p_validate is
398 * @param p_analysis_criteria_id If p_validate is false, this uniquely
399 * identifies the combination of the personal analysis flexfield segments
400 * created. If p_validate is true this parameter will be null.
401 * @param p_person_analysis_id If p_validate is false, this uniquely identifies
402 * the special information record created. If p_validate is true this parameter
403 * will be null.
404 * @param p_english_last_name Employees Last Name in english words. The value
405 * would get stored in per_information21 Developer descriptive flexfield
406 * segment.
407 * @param p_english_first_name Employees First Name in english words. The value * would get stored in per_information22 Developer descriptive flexfield
408 * segment.
409 * @param p_per_information23 Developer descriptive flexfield segment.
410 * @param p_per_information24 Developer descriptive flexfield segment.
411 * @param p_per_information25 Developer descriptive flexfield segment.
412 * @param p_per_information26 Developer descriptive flexfield segment.
413 * @param p_per_information27 Developer descriptive flexfield segment.
414 * @param p_per_information28 Developer descriptive flexfield segment.
415 * @param p_per_information29 Developer descriptive flexfield segment.
416 * @param p_per_information30 Developer descriptive flexfield segment.
417 * @rep:displayname Create Employee with Special Information for Japan
418 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE
419 * @rep:scope public
420 * @rep:lifecycle active
421 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
422 */
423 --
424 -- {End Of Comments}
425 --
426 procedure create_jp_employee_with_sit
427 (
428 -- for employee
429 --
430 p_validate in boolean default false
431 ,p_hire_date in date
432 ,p_business_group_id in number
433 ,p_last_name in varchar2
434 ,p_last_name_kana in varchar2
435 ,p_sex in varchar2
436 ,p_person_type_id in number default null
437 ,p_per_comments in varchar2 default null
438 ,p_date_employee_data_verified in date default null
439 ,p_date_of_birth in date default null
440 ,p_email_address in varchar2 default null
441 ,p_employee_number in out nocopy varchar2
442 ,p_expense_check_send_to_addres in varchar2 default null
443 ,p_first_name in varchar2 default null
444 ,p_first_name_kana in varchar2 default null
445 ,p_known_as in varchar2 default null
446 ,p_marital_status in varchar2 default null
447 ,p_middle_names in varchar2 default null
448 ,p_nationality in varchar2 default null
449 ,p_national_identifier in varchar2 default null
450 ,p_previous_last_name in varchar2 default null
451 ,p_previous_last_name_kana in varchar2 default null
452 ,p_registered_disabled_flag in varchar2 default null
453 ,p_title in varchar2 default null
454 ,p_vendor_id in number default null
455 ,p_work_telephone in varchar2 default null
456 ,p_per_attribute_category in varchar2 default null
457 ,p_per_attribute1 in varchar2 default null
458 ,p_per_attribute2 in varchar2 default null
459 ,p_per_attribute3 in varchar2 default null
460 ,p_per_attribute4 in varchar2 default null
461 ,p_per_attribute5 in varchar2 default null
462 ,p_per_attribute6 in varchar2 default null
463 ,p_per_attribute7 in varchar2 default null
464 ,p_per_attribute8 in varchar2 default null
465 ,p_per_attribute9 in varchar2 default null
466 ,p_per_attribute10 in varchar2 default null
467 ,p_per_attribute11 in varchar2 default null
468 ,p_per_attribute12 in varchar2 default null
469 ,p_per_attribute13 in varchar2 default null
470 ,p_per_attribute14 in varchar2 default null
471 ,p_per_attribute15 in varchar2 default null
472 ,p_per_attribute16 in varchar2 default null
473 ,p_per_attribute17 in varchar2 default null
474 ,p_per_attribute18 in varchar2 default null
475 ,p_per_attribute19 in varchar2 default null
476 ,p_per_attribute20 in varchar2 default null
477 ,p_per_attribute21 in varchar2 default null
478 ,p_per_attribute22 in varchar2 default null
479 ,p_per_attribute23 in varchar2 default null
480 ,p_per_attribute24 in varchar2 default null
481 ,p_per_attribute25 in varchar2 default null
482 ,p_per_attribute26 in varchar2 default null
483 ,p_per_attribute27 in varchar2 default null
484 ,p_per_attribute28 in varchar2 default null
485 ,p_per_attribute29 in varchar2 default null
486 ,p_per_attribute30 in varchar2 default null
487 ,p_date_of_death in date default null
488 ,p_blood_type in varchar2 default null
492 ,p_internal_location in varchar2 default null
489 ,p_correspondence_language in varchar2 default null
490 ,p_fte_capacity in number default null
491 ,p_honors in varchar2 default null
493 ,p_last_medical_test_by in varchar2 default null
494 ,p_last_medical_test_date in date default null
495 ,p_mailstop in varchar2 default null
496 ,p_office_number in varchar2 default null
497 ,p_on_military_service in varchar2 default null
498 ,p_resume_exists in varchar2 default null
499 ,p_resume_last_updated in date default null
500 ,p_second_passport_exists in varchar2 default null
501 ,p_student_status in varchar2 default null
502 ,p_work_schedule in varchar2 default null
503 ,p_original_date_of_hire in date default null
504 ,p_person_id out nocopy number
505 ,p_assignment_id out nocopy number
506 ,p_per_object_version_number out nocopy number
507 ,p_asg_object_version_number out nocopy number
508 ,p_per_effective_start_date out nocopy date
509 ,p_per_effective_end_date out nocopy date
510 ,p_full_name out nocopy varchar2
511 ,p_per_comment_id out nocopy number
512 ,p_assignment_sequence out nocopy number
513 ,p_assignment_number out nocopy varchar2
514 ,p_name_combination_warning out nocopy boolean
515 ,p_assign_payroll_warning out nocopy boolean
516 ,p_orig_hire_warning out nocopy boolean
517
518 /* for special information */
519
520 ,p_id_flex_num in number
521 ,p_pea_comments in varchar2 default null
522 ,p_date_from in date default null
523 ,p_date_to in date default null
524 ,p_pea_attribute_category in varchar2 default null
525 ,p_pea_attribute1 in varchar2 default null
526 ,p_pea_attribute2 in varchar2 default null
527 ,p_pea_attribute3 in varchar2 default null
528 ,p_pea_attribute4 in varchar2 default null
529 ,p_pea_attribute5 in varchar2 default null
530 ,p_pea_attribute6 in varchar2 default null
531 ,p_pea_attribute7 in varchar2 default null
532 ,p_pea_attribute8 in varchar2 default null
533 ,p_pea_attribute9 in varchar2 default null
534 ,p_pea_attribute10 in varchar2 default null
535 ,p_pea_attribute11 in varchar2 default null
536 ,p_pea_attribute12 in varchar2 default null
537 ,p_pea_attribute13 in varchar2 default null
538 ,p_pea_attribute14 in varchar2 default null
539 ,p_pea_attribute15 in varchar2 default null
540 ,p_pea_attribute16 in varchar2 default null
541 ,p_pea_attribute17 in varchar2 default null
542 ,p_pea_attribute18 in varchar2 default null
543 ,p_pea_attribute19 in varchar2 default null
544 ,p_pea_attribute20 in varchar2 default null
545 ,p_segment1 in varchar2 default null
546 ,p_segment2 in varchar2 default null
547 ,p_segment3 in varchar2 default null
548 ,p_segment4 in varchar2 default null
549 ,p_segment5 in varchar2 default null
550 ,p_segment6 in varchar2 default null
551 ,p_segment7 in varchar2 default null
552 ,p_segment8 in varchar2 default null
553 ,p_segment9 in varchar2 default null
554 ,p_segment10 in varchar2 default null
555 ,p_segment11 in varchar2 default null
556 ,p_segment12 in varchar2 default null
557 ,p_segment13 in varchar2 default null
558 ,p_segment14 in varchar2 default null
559 ,p_segment15 in varchar2 default null
560 ,p_segment16 in varchar2 default null
561 ,p_segment17 in varchar2 default null
562 ,p_segment18 in varchar2 default null
563 ,p_segment19 in varchar2 default null
564 ,p_segment20 in varchar2 default null
565 ,p_segment21 in varchar2 default null
566 ,p_segment22 in varchar2 default null
567 ,p_segment23 in varchar2 default null
568 ,p_segment24 in varchar2 default null
569 ,p_segment25 in varchar2 default null
570 ,p_segment26 in varchar2 default null
571 ,p_segment27 in varchar2 default null
572 ,p_segment28 in varchar2 default null
573 ,p_segment29 in varchar2 default null
574 ,p_segment30 in varchar2 default null
575 ,p_pea_object_version_number out nocopy number
576 ,p_analysis_criteria_id out nocopy number
577 ,p_person_analysis_id out nocopy number
578
579 /* Additional parameters for Bug:4161160 */
580
581 ,p_english_last_name in varchar2 default null
582 ,p_english_first_name in varchar2 default null
586 ,p_per_information26 in varchar2 default null
583 ,p_per_information23 in varchar2 default null
584 ,p_per_information24 in varchar2 default null
585 ,p_per_information25 in varchar2 default null
587 ,p_per_information27 in varchar2 default null
588 ,p_per_information28 in varchar2 default null
589 ,p_per_information29 in varchar2 default null
590 ,p_per_information30 in varchar2 default null
591 );
592 --
593 -- ----------------------------------------------------------------------------
594 -- |-----------------------< create_jp_emp_with_educ_add >--------------------|
595 -- ----------------------------------------------------------------------------
596 --
597 -- {Start Of Comments}
598 /*#
599 * This API creates a new employee for Japan including a special information
600 * record of JP Educational Background, a primary JP address, a default primary
601 * assignment and a period of service for the employee.
602 *
603 *
604 * <p><b>Licensing</b><br>
605 * This API is licensed for use with Human Resources.
606 *
607 * <p><b>Prerequisites</b><br>
608 * If person_type_id is supplied, it must have a corresponding system person
609 * type of 'EMP', must be active and be in the same business group as that of
610 * the employee being created. Special Information Type of JP Educational
611 * Background must be set enabled against the business group. The address_type
612 * attribute can only be used after QuickCodes have been defined for the
613 * 'ADDRESS_TYPE' lookup type.
614 *
615 * <p><b>Post Success</b><br>
616 * The person, special information record, address, primary assignment and
617 * period of service will be successfully created.
618 *
619 * <p><b>Post Failure</b><br>
620 * The person, special information record, address, primary assignment or
621 * period of service will not be created and an error will be raised.
622 * @param p_validate If true, then validation alone will be performed and the
623 * database will remain unchanged. If false and all validation checks pass,
624 * then the database will be modified.
625 * @param p_hire_date The employee hire date and the effective start date of
626 * the person, primary assignment and period of service.
627 * @param p_business_group_id The employee's Business Group ID.
628 * @param p_last_name Employee's last name (Kanji).
629 * @param p_last_name_kana Employee's last name (Kana).
630 * @param p_sex {@rep:casecolumn PER_ALL_PEOPLE_F.SEX}
631 * @param p_person_type_id Person type id. If this value is omitted then the
632 * person_type_id of the default `EMP' system person type in the employee's
633 * business group is used.
634 * @param p_per_comments Comments for person record.
635 * @param p_date_employee_data_verified The date on which the employee data was
636 * last verified.
637 * @param p_date_of_birth {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_BIRTH}
638 * @param p_email_address {@rep:casecolumn PER_ALL_PEOPLE_F.EMAIL_ADDRESS}
639 * @param p_employee_number The business group's employee number generation
640 * method determines when the API derives and passes out an employee number or
641 * when the calling program should pass in a value. When the API call completes
642 * if p_validate is false then will be set to the employee number. If
643 * p_validate is true then will be set to the passed value.
644 * @param p_expense_check_send_to_addres {@rep:casecolumn
645 * PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS}
646 * @param p_first_name Employee's first name (Kanji).
647 * @param p_first_name_kana Employee's first name (Kana).
648 * @param p_known_as {@rep:casecolumn PER_ALL_PEOPLE_F.KNOWN_AS}
649 * @param p_marital_status {@rep:casecolumn PER_ALL_PEOPLE_F.MARITAL_STATUS}
650 * @param p_middle_names Employee's middle name(s).
651 * @param p_nationality Employee's nationality.
652 * @param p_national_identifier {@rep:casecolumn
653 * PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER}
654 * @param p_previous_last_name_kana Previous last name (Kana).
655 * @param p_previous_last_name Previous last name (Kanji).
656 * @param p_registered_disabled_flag {@rep:casecolumn
657 * PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG}
658 * @param p_title Employee's title.
659 * @param p_vendor_id {@rep:casecolumn PER_ALL_PEOPLE_F.VENDOR_ID}
660 * @param p_work_telephone {@rep:casecolumn PER_ALL_PEOPLE_F.WORK_TELEPHONE}
661 * @param p_per_attribute_category This context value determines which
662 * Flexfield Structure to use with the Descriptive flexfield segments.
663 * @param p_per_attribute1 Descriptive flexfield segment.
664 * @param p_per_attribute2 Descriptive flexfield segment.
665 * @param p_per_attribute3 Descriptive flexfield segment.
666 * @param p_per_attribute4 Descriptive flexfield segment.
667 * @param p_per_attribute5 Descriptive flexfield segment.
668 * @param p_per_attribute6 Descriptive flexfield segment.
669 * @param p_per_attribute7 Descriptive flexfield segment.
670 * @param p_per_attribute8 Descriptive flexfield segment.
671 * @param p_per_attribute9 Descriptive flexfield segment.
672 * @param p_per_attribute10 Descriptive flexfield segment.
673 * @param p_per_attribute11 Descriptive flexfield segment.
674 * @param p_per_attribute12 Descriptive flexfield segment.
675 * @param p_per_attribute13 Descriptive flexfield segment.
676 * @param p_per_attribute14 Descriptive flexfield segment.
677 * @param p_per_attribute15 Descriptive flexfield segment.
678 * @param p_per_attribute16 Descriptive flexfield segment.
679 * @param p_per_attribute17 Descriptive flexfield segment.
680 * @param p_per_attribute18 Descriptive flexfield segment.
684 * @param p_per_attribute22 Descriptive flexfield segment.
681 * @param p_per_attribute19 Descriptive flexfield segment.
682 * @param p_per_attribute20 Descriptive flexfield segment.
683 * @param p_per_attribute21 Descriptive flexfield segment.
685 * @param p_per_attribute23 Descriptive flexfield segment.
686 * @param p_per_attribute24 Descriptive flexfield segment.
687 * @param p_per_attribute25 Descriptive flexfield segment.
688 * @param p_per_attribute26 Descriptive flexfield segment.
689 * @param p_per_attribute27 Descriptive flexfield segment.
690 * @param p_per_attribute28 Descriptive flexfield segment.
691 * @param p_per_attribute29 Descriptive flexfield segment.
692 * @param p_per_attribute30 Descriptive flexfield segment.
693 * @param p_date_of_death {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_DEATH}
694 * @param p_blood_type {@rep:casecolumn PER_ALL_PEOPLE_F.BLOOD_TYPE}
695 * @param p_correspondence_language {@rep:casecolumn
696 * PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE}
697 * @param p_fte_capacity {@rep:casecolumn PER_ALL_PEOPLE_F.FTE_CAPACITY}
698 * @param p_honors {@rep:casecolumn PER_ALL_PEOPLE_F.HONORS}
699 * @param p_internal_location {@rep:casecolumn
700 * PER_ALL_PEOPLE_F.INTERNAL_LOCATION}
701 * @param p_last_medical_test_by {@rep:casecolumn
702 * PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_BY}
703 * @param p_last_medical_test_date {@rep:casecolumn
704 * PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_DATE}
705 * @param p_mailstop {@rep:casecolumn PER_ALL_PEOPLE_F.MAILSTOP}
706 * @param p_office_number {@rep:casecolumn PER_ALL_PEOPLE_F.OFFICE_NUMBER}
707 * @param p_on_military_service {@rep:casecolumn
708 * PER_ALL_PEOPLE_F.ON_MILITARY_SERVICE}
709 * @param p_resume_exists {@rep:casecolumn PER_ALL_PEOPLE_F.RESUME_EXISTS}
710 * @param p_resume_last_updated {@rep:casecolumn
711 * PER_ALL_PEOPLE_F.RESUME_LAST_UPDATED}
712 * @param p_second_passport_exists {@rep:casecolumn
713 * PER_ALL_PEOPLE_F.SECOND_PASSPORT_EXISTS}
714 * @param p_student_status {@rep:casecolumn PER_ALL_PEOPLE_F.STUDENT_STATUS}
715 * @param p_work_schedule {@rep:casecolumn PER_ALL_PEOPLE_F.WORK_SCHEDULE}
716 * @param p_original_date_of_hire {@rep:casecolumn
717 * PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE}
718 * @param p_person_id If p_validate is false, then this uniquely identifies the
719 * person created. If p_validate is true, then this is set to null.
720 * @param p_assignment_id If p_validate is false, then this uniquely identifies
721 * the created assignment. If p_validate is true, then this is set to null.
722 * @param p_per_object_version_number If p_validate is false, then set to the
723 * version number of the created person. If p_validate is true, then the value
724 * will be null.
725 * @param p_asg_object_version_number If p_validate is false, then this
726 * parameter is set to the version number of the assignment created. If
727 * p_validate is true, then this parameter is null.
728 * @param p_per_effective_start_date If p_validate is false, then set to the
729 * earliest effective start date for the created person. If p_validate is true,
730 * then set to null.
731 * @param p_per_effective_end_date If p_validate is false, then set to the
732 * effective end date for the created person. If p_validate is true, then set
733 * to null.
734 * @param p_full_name If p_validate is false, this will be set to the complete
735 * full name of the person. If p_validate is true this will be null.
736 * @param p_per_comment_id If p_validate is false and comment text was
737 * provided, then will be set to the identifier of the created person comment
738 * record. If p_validate is true or no comment text was provided, then will be
739 * null.
740 * @param p_assignment_sequence If p_validate is false this will be set to the
741 * sequence number of the primary assignment. If p_validate is true this will
742 * be null.
743 * @param p_assignment_number If p_validate is false this will be set to the
744 * assignment number of the primary assignment. If p_validate is true this will
745 * be null.
746 * @param p_name_combination_warning If set to true, then the combination of
747 * last name, first name and date of birth existed prior to calling this API.
748 * @param p_assign_payroll_warning If set to true, then the date of birth is
749 * not entered. If set to false, then the date of birth has been entered.
750 * Indicates if it will be possible to set the payroll on any of this person's
751 * assignments.
752 * @param p_orig_hire_warning This is set to true if the original date of hire
753 * is not null and the person type is not EMP,EMP_APL, EX_EMP or EX_EMP_APL.
754 * @param p_pea_comments Comments for the special information record.
755 * @param p_pea_date_from The date from which the special information record
756 * applies.
757 * @param p_pea_date_to The date on which the special information record no
758 * longer applies.
759 * @param p_pea_attribute_category This context value determines which
760 * Flexfield Structure to use with the Descriptive flexfield segments.
761 * @param p_pea_attribute1 Descriptive flexfield segment.
762 * @param p_pea_attribute2 Descriptive flexfield segment.
763 * @param p_pea_attribute3 Descriptive flexfield segment.
764 * @param p_pea_attribute4 Descriptive flexfield segment.
765 * @param p_pea_attribute5 Descriptive flexfield segment.
766 * @param p_pea_attribute6 Descriptive flexfield segment.
767 * @param p_pea_attribute7 Descriptive flexfield segment.
768 * @param p_pea_attribute8 Descriptive flexfield segment.
769 * @param p_pea_attribute9 Descriptive flexfield segment.
770 * @param p_pea_attribute10 Descriptive flexfield segment.
771 * @param p_pea_attribute11 Descriptive flexfield segment.
772 * @param p_pea_attribute12 Descriptive flexfield segment.
776 * @param p_pea_attribute16 Descriptive flexfield segment.
773 * @param p_pea_attribute13 Descriptive flexfield segment.
774 * @param p_pea_attribute14 Descriptive flexfield segment.
775 * @param p_pea_attribute15 Descriptive flexfield segment.
777 * @param p_pea_attribute17 Descriptive flexfield segment.
778 * @param p_pea_attribute18 Descriptive flexfield segment.
779 * @param p_pea_attribute19 Descriptive flexfield segment.
780 * @param p_pea_attribute20 Descriptive flexfield segment.
781 * @param p_school_type Type of School. Valid values are defined by
782 * 'JP_SCHOOL_TYPE' lookup type.
783 * @param p_school_id {@rep:casecolumn PER_JP_SCHOOL_LOOKUPS.SCHOOL_ID}
784 * @param p_school_name {@rep:casecolumn PER_JP_SCHOOL_LOOKUPS.SCHOOL_NAME}
785 * @param p_school_name_kana {@rep:casecolumn
786 * PER_JP_SCHOOL_LOOKUPS.SCHOOL_NAME_KANA}
787 * @param p_major {@rep:casecolumn PER_JP_SCHOOL_LOOKUPS.MAJOR}
788 * @param p_major_kana {@rep:casecolumn PER_JP_SCHOOL_LOOKUPS.MAJOR_KANA}
789 * @param p_advisor Department.
790 * @param p_graduation_date Graduation Date.
791 * @param p_note Note.
792 * @param p_last_flag This identifies the last educational background detail.
793 * @param p_pea_object_version_number If p_validate is false, then set to the
794 * version number of the created special information record. If p_validate is
795 * true, then the value will be null.
796 * @param p_analysis_criteria_id If p_validate is false, this uniquely
797 * identifies the combination of the personal analysis flexfield segments
798 * created. If p_validate is true this parameter will be null.
799 * @param p_person_analysis_id If p_validate is false, this uniquely identifies
800 * the special information record created. If p_validate is true this parameter
801 * will be null.
802 * @param p_add_date_from The date from which the address applies.
803 * @param p_add_date_to The date on which the address no longer applies.
804 * @param p_address_type Type of address. Valid values are defined by
805 * 'ADDRESS_TYPE' lookup type.
806 * @param p_add_comments Comment text for address.
807 * @param p_address_line1 Line 1 of address.
808 * @param p_address_line2 Line 2 of address.
809 * @param p_address_line3 Line 3 of address.
810 * @param p_district_code District code.
811 * @param p_address_line1_kana Line 1 of address (Kana).
812 * @param p_address_line2_kana Line 2 of address (Kana).
813 * @param p_address_line3_kana Line 3 of address (Kana).
814 * @param p_postcode Postal Code.
815 * @param p_country Country.
816 * @param p_telephone_number_1 Telephone number.
817 * @param p_telephone_number_2 Telephone number.
818 * @param p_fax_number Fax Number.
819 * @param p_addr_attribute_category This context value determines which
820 * flexfield structure to use with the Person Address descriptive flexfield
821 * segments.
822 * @param p_addr_attribute1 Descriptive flexfield segment.
823 * @param p_addr_attribute2 Descriptive flexfield segment.
824 * @param p_addr_attribute3 Descriptive flexfield segment.
825 * @param p_addr_attribute4 Descriptive flexfield segment.
826 * @param p_addr_attribute5 Descriptive flexfield segment.
827 * @param p_addr_attribute6 Descriptive flexfield segment.
828 * @param p_addr_attribute7 Descriptive flexfield segment.
829 * @param p_addr_attribute8 Descriptive flexfield segment.
830 * @param p_addr_attribute9 Descriptive flexfield segment.
831 * @param p_addr_attribute10 Descriptive flexfield segment.
832 * @param p_addr_attribute11 Descriptive flexfield segment.
833 * @param p_addr_attribute12 Descriptive flexfield segment.
834 * @param p_addr_attribute13 Descriptive flexfield segment.
835 * @param p_addr_attribute14 Descriptive flexfield segment.
836 * @param p_addr_attribute15 Descriptive flexfield segment.
837 * @param p_addr_attribute16 Descriptive flexfield segment.
838 * @param p_addr_attribute17 Descriptive flexfield segment.
839 * @param p_addr_attribute18 Descriptive flexfield segment.
840 * @param p_addr_attribute19 Descriptive flexfield segment.
841 * @param p_addr_attribute20 Descriptive flexfield segment.
842 * @param p_address_id If p_validate is false, uniquely identifies the address
843 * created. If p_validate is true, set to null.
844 * @param p_add_object_version_number If p_validate is false, then set to the
845 * version number of the created address. If p_validate is true, then the value
846 * will be null.
847 * @param p_english_last_name Employees Last Name in english words. The value
848 * would get stored in per_information21 Developer descriptive flexfield
849 * segment.
850 * @param p_english_first_name Employees First Name in english words. The value
851 * would get stored in per_information22 Developer descriptive flexfield
852 * segment.
853 * @param p_per_information23 Developer descriptive flexfield segment.
854 * @param p_per_information24 Developer descriptive flexfield segment.
855 * @param p_per_information25 Developer descriptive flexfield segment.
856 * @param p_per_information26 Developer descriptive flexfield segment.
857 * @param p_per_information27 Developer descriptive flexfield segment.
858 * @param p_per_information28 Developer descriptive flexfield segment.
859 * @param p_per_information29 Developer descriptive flexfield segment.
860 * @param p_per_information30 Developer descriptive flexfield segment.
861 * @rep:displayname Create Employee with Education Background and Address for Japan
862 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE
863 * @rep:scope public
864 * @rep:lifecycle active
865 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
866 */
867 --
868 -- {End Of Comments}
869 --
870 procedure create_jp_emp_with_educ_add
871 (
872 -- for employee
873 --
877 ,p_last_name in varchar2
874 p_validate in boolean default false
875 ,p_hire_date in date
876 ,p_business_group_id in number
878 ,p_last_name_kana in varchar2
879 ,p_sex in varchar2
880 ,p_person_type_id in number default null
881 ,p_per_comments in varchar2 default null
882 ,p_date_employee_data_verified in date default null
883 ,p_date_of_birth in date default null
884 ,p_email_address in varchar2 default null
885 ,p_employee_number in out nocopy varchar2
886 ,p_expense_check_send_to_addres in varchar2 default null
887 ,p_first_name in varchar2 default null
888 ,p_first_name_kana in varchar2 default null
889 ,p_known_as in varchar2 default null
890 ,p_marital_status in varchar2 default null
891 ,p_middle_names in varchar2 default null
892 ,p_nationality in varchar2 default null
893 ,p_national_identifier in varchar2 default null
894 ,p_previous_last_name_kana in varchar2 default null
895 ,p_previous_last_name in varchar2 default null
896 ,p_registered_disabled_flag in varchar2 default null
897 ,p_title in varchar2 default null
898 ,p_vendor_id in number default null
899 ,p_work_telephone in varchar2 default null
900 ,p_per_attribute_category in varchar2 default null
901 ,p_per_attribute1 in varchar2 default null
902 ,p_per_attribute2 in varchar2 default null
903 ,p_per_attribute3 in varchar2 default null
904 ,p_per_attribute4 in varchar2 default null
905 ,p_per_attribute5 in varchar2 default null
906 ,p_per_attribute6 in varchar2 default null
907 ,p_per_attribute7 in varchar2 default null
908 ,p_per_attribute8 in varchar2 default null
909 ,p_per_attribute9 in varchar2 default null
910 ,p_per_attribute10 in varchar2 default null
911 ,p_per_attribute11 in varchar2 default null
912 ,p_per_attribute12 in varchar2 default null
913 ,p_per_attribute13 in varchar2 default null
914 ,p_per_attribute14 in varchar2 default null
915 ,p_per_attribute15 in varchar2 default null
916 ,p_per_attribute16 in varchar2 default null
917 ,p_per_attribute17 in varchar2 default null
918 ,p_per_attribute18 in varchar2 default null
919 ,p_per_attribute19 in varchar2 default null
920 ,p_per_attribute20 in varchar2 default null
921 ,p_per_attribute21 in varchar2 default null
922 ,p_per_attribute22 in varchar2 default null
923 ,p_per_attribute23 in varchar2 default null
924 ,p_per_attribute24 in varchar2 default null
925 ,p_per_attribute25 in varchar2 default null
926 ,p_per_attribute26 in varchar2 default null
927 ,p_per_attribute27 in varchar2 default null
928 ,p_per_attribute28 in varchar2 default null
929 ,p_per_attribute29 in varchar2 default null
930 ,p_per_attribute30 in varchar2 default null
931 ,p_date_of_death in date default null
932 ,p_blood_type in varchar2 default null
933 ,p_correspondence_language in varchar2 default null
934 ,p_fte_capacity in number default null
935 ,p_honors in varchar2 default null
936 ,p_internal_location in varchar2 default null
937 ,p_last_medical_test_by in varchar2 default null
938 ,p_last_medical_test_date in date default null
939 ,p_mailstop in varchar2 default null
940 ,p_office_number in varchar2 default null
941 ,p_on_military_service in varchar2 default null
942 ,p_resume_exists in varchar2 default null
943 ,p_resume_last_updated in date default null
944 ,p_second_passport_exists in varchar2 default null
945 ,p_student_status in varchar2 default null
946 ,p_work_schedule in varchar2 default null
947 ,p_original_date_of_hire in date default null
948 ,p_person_id out nocopy number
949 ,p_assignment_id out nocopy number
950 ,p_per_object_version_number out nocopy number
951 ,p_asg_object_version_number out nocopy number
952 ,p_per_effective_start_date out nocopy date
953 ,p_per_effective_end_date out nocopy date
954 ,p_full_name out nocopy varchar2
955 ,p_per_comment_id out nocopy number
956 ,p_assignment_sequence out nocopy number
957 ,p_assignment_number out nocopy varchar2
958 ,p_name_combination_warning out nocopy boolean
959 ,p_assign_payroll_warning out nocopy boolean
960 ,p_orig_hire_warning out nocopy boolean
961 --
962 -- for special information
963 --
964 ,p_pea_comments in varchar2 default null
965 ,p_pea_date_from in date default null
969 ,p_pea_attribute2 in varchar2 default null
966 ,p_pea_date_to in date default null
967 ,p_pea_attribute_category in varchar2 default null
968 ,p_pea_attribute1 in varchar2 default null
970 ,p_pea_attribute3 in varchar2 default null
971 ,p_pea_attribute4 in varchar2 default null
972 ,p_pea_attribute5 in varchar2 default null
973 ,p_pea_attribute6 in varchar2 default null
974 ,p_pea_attribute7 in varchar2 default null
975 ,p_pea_attribute8 in varchar2 default null
976 ,p_pea_attribute9 in varchar2 default null
977 ,p_pea_attribute10 in varchar2 default null
978 ,p_pea_attribute11 in varchar2 default null
979 ,p_pea_attribute12 in varchar2 default null
980 ,p_pea_attribute13 in varchar2 default null
981 ,p_pea_attribute14 in varchar2 default null
982 ,p_pea_attribute15 in varchar2 default null
983 ,p_pea_attribute16 in varchar2 default null
984 ,p_pea_attribute17 in varchar2 default null
985 ,p_pea_attribute18 in varchar2 default null
986 ,p_pea_attribute19 in varchar2 default null
987 ,p_pea_attribute20 in varchar2 default null
988 ,p_school_type in varchar2 default null
989 ,p_school_id in varchar2 default null
990 ,p_school_name in varchar2 default null
991 ,p_school_name_kana in varchar2 default null
992 ,p_major in varchar2 default null
993 ,p_major_kana in varchar2 default null
994 ,p_advisor in varchar2 default null
995 ,p_graduation_date in varchar2 default null
996 ,p_note in varchar2 default null
997 ,p_last_flag in varchar2 default null
998 ,p_pea_object_version_number out nocopy number
999 ,p_analysis_criteria_id out nocopy number
1000 ,p_person_analysis_id out nocopy number
1001 --
1002 -- for address
1003 --
1004 ,p_add_date_from in date default null
1005 ,p_add_date_to in date default null
1006 ,p_address_type in varchar2 default null
1007 ,p_add_comments in varchar2 default null
1008 ,p_address_line1 in varchar2 default null
1009 ,p_address_line2 in varchar2 default null
1010 ,p_address_line3 in varchar2 default null
1011 ,p_district_code in varchar2 default null
1012 ,p_address_line1_kana in varchar2 default null
1013 ,p_address_line2_kana in varchar2 default null
1014 ,p_address_line3_kana in varchar2 default null
1015 ,p_postcode in varchar2 default null
1016 ,p_country in varchar2 default null
1017 ,p_telephone_number_1 in varchar2 default null
1018 ,p_telephone_number_2 in varchar2 default null
1019 ,p_fax_number in varchar2 default null
1020 ,p_addr_attribute_category in varchar2 default null
1021 ,p_addr_attribute1 in varchar2 default null
1022 ,p_addr_attribute2 in varchar2 default null
1023 ,p_addr_attribute3 in varchar2 default null
1024 ,p_addr_attribute4 in varchar2 default null
1025 ,p_addr_attribute5 in varchar2 default null
1026 ,p_addr_attribute6 in varchar2 default null
1027 ,p_addr_attribute7 in varchar2 default null
1028 ,p_addr_attribute8 in varchar2 default null
1029 ,p_addr_attribute9 in varchar2 default null
1030 ,p_addr_attribute10 in varchar2 default null
1031 ,p_addr_attribute11 in varchar2 default null
1032 ,p_addr_attribute12 in varchar2 default null
1033 ,p_addr_attribute13 in varchar2 default null
1034 ,p_addr_attribute14 in varchar2 default null
1035 ,p_addr_attribute15 in varchar2 default null
1036 ,p_addr_attribute16 in varchar2 default null
1037 ,p_addr_attribute17 in varchar2 default null
1038 ,p_addr_attribute18 in varchar2 default null
1039 ,p_addr_attribute19 in varchar2 default null
1040 ,p_addr_attribute20 in varchar2 default null
1041 ,p_address_id out nocopy number
1042 ,p_add_object_version_number out nocopy number
1043
1044 /* Additional parameters for Bug:4161160 */
1045
1046 ,p_english_last_name in varchar2 default null
1047 ,p_english_first_name in varchar2 default null
1048 ,p_per_information23 in varchar2 default null
1049 ,p_per_information24 in varchar2 default null
1050 ,p_per_information25 in varchar2 default null
1051 ,p_per_information26 in varchar2 default null
1052 ,p_per_information27 in varchar2 default null
1053 ,p_per_information28 in varchar2 default null
1054 ,p_per_information29 in varchar2 default null
1055 ,p_per_information30 in varchar2 default null
1056 );
1057 --
1058 -- ----------------------------------------------------------------------------
1059 -- |-----------------------< create_jp_applicant_with_sit >-------------------|
1063 /*#
1060 -- ----------------------------------------------------------------------------
1061 --
1062 -- {Start Of Comments}
1064 * This API creates a new applicant for Japan.
1065 *
1066 * The person details, an application, a special information record, a default
1067 * applicant assignment and if required associated assignment budget values and
1068 * a letter request are created.
1069 *
1070 * <p><b>Licensing</b><br>
1071 * This API is licensed for use with Human Resources.
1072 *
1073 * <p><b>Prerequisites</b><br>
1074 * A valid business_group_id of a JP legislation. A valid person_type_id, if
1075 * specified, with a corresponding system type of 'APL', must be active and in
1076 * the same business group as that of the applicant being created. If a
1077 * person_type_id is not specified the API will use the default 'APL' type for
1078 * the business group. Special Information Type must be set enabled against the
1079 * business group.
1080 *
1081 * <p><b>Post Success</b><br>
1082 * The person, application, special information record, default applicant
1083 * assignment and if required associated assignment budget values and a letter
1084 * request will be created.
1085 *
1086 * <p><b>Post Failure</b><br>
1087 * The person, special information record, default applicant assignment,
1088 * associated assignment budget values and a letter request will not be created
1089 * and an error will be raised.
1090 * @param p_validate If true, then validation alone will be performed and the
1091 * database will remain unchanged. If false and all validation checks pass,
1092 * then the database will be modified.
1093 * @param p_date_received The date an application was received and thus the
1094 * effective start date of the person, application and assignment.
1095 * @param p_business_group_id The applicant's business group.
1096 * @param p_last_name Applicant's last name (Kanji).
1097 * @param p_last_name_kana Applicant's last name (Kana).
1098 * @param p_sex {@rep:casecolumn PER_ALL_PEOPLE_F.SEX}
1099 * @param p_person_type_id Person type id. If a person_type_id is not specified
1100 * the API will use the default 'APL' type for the business group.
1101 * @param p_per_comments Comments for person record.
1102 * @param p_date_employee_data_verified The date on which the applicant data
1103 * was last verified.
1104 * @param p_date_of_birth {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_BIRTH}
1105 * @param p_email_address {@rep:casecolumn PER_ALL_PEOPLE_F.EMAIL_ADDRESS}
1106 * @param p_applicant_number This paramater details the applicant number. If
1107 * the number generation method is Manual then this parameter is mandatory. If
1108 * the number generation method is Automatic then the value of this parameter
1109 * must be NULL. If p_validate is false and the applicant number generation
1110 * method is Automatic, this will be set to to the generated applicant number
1111 * of the person created. If p_validate is false and the applicant number
1112 * generation method is manual, this will be set to the same value passed in.
1113 * If p_validate is true this will be set to the same value as passed in.
1114 * @param p_expense_check_send_to_addres {@rep:casecolumn
1115 * PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS}
1116 * @param p_first_name Applicant's first name (Kanji).
1117 * @param p_first_name_kana Applicant's first name (Kana).
1118 * @param p_known_as {@rep:casecolumn PER_ALL_PEOPLE_F.KNOWN_AS}
1119 * @param p_marital_status {@rep:casecolumn PER_ALL_PEOPLE_F.MARITAL_STATUS}
1120 * @param p_middle_names Applicant's middle name(s).
1121 * @param p_nationality Applicant's nationality.
1122 * @param p_national_identifier {@rep:casecolumn
1123 * PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER}
1124 * @param p_previous_last_name Previous last name (Kanji).
1125 * @param p_previous_last_name_kana Previous last name (Kana).
1126 * @param p_registered_disabled_flag {@rep:casecolumn
1127 * PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG}
1128 * @param p_title Applicant's title.
1129 * @param p_work_telephone {@rep:casecolumn PER_ALL_PEOPLE_F.WORK_TELEPHONE}
1130 * @param p_per_attribute_category This context value determines which
1131 * Flexfield Structure to use with the Descriptive flexfield segments.
1132 * @param p_per_attribute1 Descriptive flexfield segment.
1133 * @param p_per_attribute2 Descriptive flexfield segment.
1134 * @param p_per_attribute3 Descriptive flexfield segment.
1135 * @param p_per_attribute4 Descriptive flexfield segment.
1136 * @param p_per_attribute5 Descriptive flexfield segment.
1137 * @param p_per_attribute6 Descriptive flexfield segment.
1138 * @param p_per_attribute7 Descriptive flexfield segment.
1139 * @param p_per_attribute8 Descriptive flexfield segment.
1140 * @param p_per_attribute9 Descriptive flexfield segment.
1141 * @param p_per_attribute10 Descriptive flexfield segment.
1142 * @param p_per_attribute11 Descriptive flexfield segment.
1143 * @param p_per_attribute12 Descriptive flexfield segment.
1144 * @param p_per_attribute13 Descriptive flexfield segment.
1145 * @param p_per_attribute14 Descriptive flexfield segment.
1146 * @param p_per_attribute15 Descriptive flexfield segment.
1147 * @param p_per_attribute16 Descriptive flexfield segment.
1148 * @param p_per_attribute17 Descriptive flexfield segment.
1149 * @param p_per_attribute18 Descriptive flexfield segment.
1150 * @param p_per_attribute19 Descriptive flexfield segment.
1151 * @param p_per_attribute20 Descriptive flexfield segment.
1152 * @param p_per_attribute21 Descriptive flexfield segment.
1153 * @param p_per_attribute22 Descriptive flexfield segment.
1154 * @param p_per_attribute23 Descriptive flexfield segment.
1155 * @param p_per_attribute24 Descriptive flexfield segment.
1156 * @param p_per_attribute25 Descriptive flexfield segment.
1160 * @param p_per_attribute29 Descriptive flexfield segment.
1157 * @param p_per_attribute26 Descriptive flexfield segment.
1158 * @param p_per_attribute27 Descriptive flexfield segment.
1159 * @param p_per_attribute28 Descriptive flexfield segment.
1161 * @param p_per_attribute30 Descriptive flexfield segment.
1162 * @param p_correspondence_language {@rep:casecolumn
1163 * PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE}
1164 * @param p_fte_capacity {@rep:casecolumn PER_ALL_PEOPLE_F.FTE_CAPACITY}
1165 * @param p_hold_applicant_date_until {@rep:casecolumn
1166 * PER_ALL_PEOPLE_F.HOLD_APPLICANT_DATE_UNTIL}
1167 * @param p_honors {@rep:casecolumn PER_ALL_PEOPLE_F.HONORS}
1168 * @param p_mailstop {@rep:casecolumn PER_ALL_PEOPLE_F.MAILSTOP}
1169 * @param p_office_number {@rep:casecolumn PER_ALL_PEOPLE_F.OFFICE_NUMBER}
1170 * @param p_on_military_service {@rep:casecolumn
1171 * PER_ALL_PEOPLE_F.ON_MILITARY_SERVICE}
1172 * @param p_resume_exists {@rep:casecolumn PER_ALL_PEOPLE_F.RESUME_EXISTS}
1173 * @param p_resume_last_updated {@rep:casecolumn
1174 * PER_ALL_PEOPLE_F.RESUME_LAST_UPDATED}
1175 * @param p_student_status {@rep:casecolumn PER_ALL_PEOPLE_F.STUDENT_STATUS}
1176 * @param p_work_schedule {@rep:casecolumn PER_ALL_PEOPLE_F.WORK_SCHEDULE}
1177 * @param p_date_of_death {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_DEATH}
1178 * @param p_original_date_of_hire {@rep:casecolumn
1179 * PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE}
1180 * @param p_person_id If p_validate is false, then this uniquely identifies the
1181 * person created. If p_validate is true, then set to null.
1182 * @param p_assignment_id If p_validate is false, then this uniquely identifies
1183 * the created assignment. If p_validate is true, then set to null.
1184 * @param p_application_id If p_validate is false, this uniquely identifies the
1185 * application created. If p_validate is true this parameter will be null.
1186 * @param p_per_object_version_number If p_validate is false, then set to the
1187 * version number of the created person. If p_validate is true, then the value
1188 * will be null.
1189 * @param p_asg_object_version_number If p_validate is false, then this
1190 * parameter is set to the version number of the assignment created. If
1191 * p_validate is true, then this parameter is null.
1192 * @param p_apl_object_version_number If p_validate is false, this will be set
1193 * to the version number of the application created. If p_validate is true this
1194 * parameter will be set to null.
1195 * @param p_per_effective_start_date If p_validate is false, then set to the
1196 * earliest effective start date for the created person. If p_validate is true,
1197 * then set to null.
1198 * @param p_per_effective_end_date If p_validate is false, then set to the
1199 * effective end date for the created person. If p_validate is true, then set
1200 * to null.
1201 * @param p_full_name If p_validate is false, this will be set to the complete
1202 * full name of the person. If p_validate is true this will be null.
1203 * @param p_per_comment_id If p_validate is false and comment text was
1204 * provided, then will be set to the identifier of the created person comment
1205 * record. If p_validate is true or no comment text was provided, then will be
1206 * null.
1207 * @param p_assignment_sequence If p_validate is false this will be set to the
1208 * sequence number of the default assignment. If p_validate is true this will
1209 * be null.
1210 * @param p_name_combination_warning If set to true, then the combination of
1211 * last name, first name and date of birth existed prior to calling this API.
1212 * @param p_orig_hire_warning This is set to true if the original date of hire
1213 * is not null and the person type is not EMP,EMP_APL, EX_EMP or EX_EMP_APL.
1214 * @param p_id_flex_num Id flex number of the Personal Analysis key flexfield
1215 * structure.
1216 * @param p_pea_comments Comments.
1217 * @param p_date_from The date from which the special information record
1218 * applies.
1219 * @param p_date_to The date on which the special information record no longer
1220 * applies.
1221 * @param p_pea_attribute_category This context value determines which
1222 * Flexfield Structure to use with the Descriptive flexfield segments.
1223 * @param p_pea_attribute1 Descriptive flexfield segment.
1224 * @param p_pea_attribute2 Descriptive flexfield segment.
1225 * @param p_pea_attribute3 Descriptive flexfield segment.
1226 * @param p_pea_attribute4 Descriptive flexfield segment.
1227 * @param p_pea_attribute5 Descriptive flexfield segment.
1228 * @param p_pea_attribute6 Descriptive flexfield segment.
1229 * @param p_pea_attribute7 Descriptive flexfield segment.
1230 * @param p_pea_attribute8 Descriptive flexfield segment.
1231 * @param p_pea_attribute9 Descriptive flexfield segment.
1232 * @param p_pea_attribute10 Descriptive flexfield segment.
1233 * @param p_pea_attribute11 Descriptive flexfield segment.
1234 * @param p_pea_attribute12 Descriptive flexfield segment.
1235 * @param p_pea_attribute13 Descriptive flexfield segment.
1236 * @param p_pea_attribute14 Descriptive flexfield segment.
1237 * @param p_pea_attribute15 Descriptive flexfield segment.
1238 * @param p_pea_attribute16 Descriptive flexfield segment.
1239 * @param p_pea_attribute17 Descriptive flexfield segment.
1240 * @param p_pea_attribute18 Descriptive flexfield segment.
1241 * @param p_pea_attribute19 Descriptive flexfield segment.
1242 * @param p_pea_attribute20 Descriptive flexfield segment.
1243 * @param p_segment1 Key flexfield segment.
1244 * @param p_segment2 Key flexfield segment.
1245 * @param p_segment3 Key flexfield segment.
1246 * @param p_segment4 Key flexfield segment.
1247 * @param p_segment5 Key flexfield segment.
1248 * @param p_segment6 Key flexfield segment.
1249 * @param p_segment7 Key flexfield segment.
1253 * @param p_segment11 Key flexfield segment.
1250 * @param p_segment8 Key flexfield segment.
1251 * @param p_segment9 Key flexfield segment.
1252 * @param p_segment10 Key flexfield segment.
1254 * @param p_segment12 Key flexfield segment.
1255 * @param p_segment13 Key flexfield segment.
1256 * @param p_segment14 Key flexfield segment.
1257 * @param p_segment15 Key flexfield segment.
1258 * @param p_segment16 Key flexfield segment.
1259 * @param p_segment17 Key flexfield segment.
1260 * @param p_segment18 Key flexfield segment.
1261 * @param p_segment19 Key flexfield segment.
1262 * @param p_segment20 Key flexfield segment.
1263 * @param p_segment21 Key flexfield segment.
1264 * @param p_segment22 Key flexfield segment.
1265 * @param p_segment23 Key flexfield segment.
1266 * @param p_segment24 Key flexfield segment.
1267 * @param p_segment25 Key flexfield segment.
1268 * @param p_segment26 Key flexfield segment.
1269 * @param p_segment27 Key flexfield segment.
1270 * @param p_segment28 Key flexfield segment.
1271 * @param p_segment29 Key flexfield segment.
1272 * @param p_segment30 Key flexfield segment.
1273 * @param p_pea_object_version_number If p_validate is false, then this is set
1274 * to the version number of the created special information record. If
1275 * p_validate is true, then the value will be null.
1276 * @param p_analysis_criteria_id If p_validate is false, this uniquely
1277 * identifies the combination of the personal analysis flexfield segments
1278 * created. If p_validate is true this parameter will be null.
1279 * @param p_person_analysis_id If p_validate is false, this uniquely identifies
1280 * the special information record created. If p_validate is true this parameter
1281 * will be null.
1282 * @rep:displayname Create Applicant with Special Information Type for Japan
1283 * @rep:category BUSINESS_ENTITY PER_APPLICANT
1284 * @rep:scope public
1285 * @rep:lifecycle active
1286 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1287 */
1288 --
1289 -- {End Of Comments}
1290 --
1291 procedure create_jp_applicant_with_sit
1292 (
1293 -- for applicant
1294 --
1295 p_validate in boolean default false
1296 ,p_date_received in date
1297 ,p_business_group_id in number
1298 ,p_last_name in varchar2
1299 ,p_last_name_kana in varchar2
1300 ,p_sex in varchar2 default null
1301 ,p_person_type_id in number default null
1302 ,p_per_comments in varchar2 default null
1303 ,p_date_employee_data_verified in date default null
1304 ,p_date_of_birth in date default null
1305 ,p_email_address in varchar2 default null
1306 ,p_applicant_number in out nocopy varchar2
1307 ,p_expense_check_send_to_addres in varchar2 default null
1308 ,p_first_name in varchar2 default null
1309 ,p_first_name_kana in varchar2 default null
1310 ,p_known_as in varchar2 default null
1311 ,p_marital_status in varchar2 default null
1312 ,p_middle_names in varchar2 default null
1313 ,p_nationality in varchar2 default null
1314 ,p_national_identifier in varchar2 default null
1315 ,p_previous_last_name in varchar2 default null
1316 ,p_previous_last_name_kana in varchar2 default null
1317 ,p_registered_disabled_flag in varchar2 default null
1318 ,p_title in varchar2 default null
1319 ,p_work_telephone in varchar2 default null
1320 ,p_per_attribute_category in varchar2 default null
1321 ,p_per_attribute1 in varchar2 default null
1322 ,p_per_attribute2 in varchar2 default null
1323 ,p_per_attribute3 in varchar2 default null
1324 ,p_per_attribute4 in varchar2 default null
1325 ,p_per_attribute5 in varchar2 default null
1326 ,p_per_attribute6 in varchar2 default null
1327 ,p_per_attribute7 in varchar2 default null
1328 ,p_per_attribute8 in varchar2 default null
1329 ,p_per_attribute9 in varchar2 default null
1330 ,p_per_attribute10 in varchar2 default null
1331 ,p_per_attribute11 in varchar2 default null
1332 ,p_per_attribute12 in varchar2 default null
1333 ,p_per_attribute13 in varchar2 default null
1334 ,p_per_attribute14 in varchar2 default null
1335 ,p_per_attribute15 in varchar2 default null
1336 ,p_per_attribute16 in varchar2 default null
1337 ,p_per_attribute17 in varchar2 default null
1338 ,p_per_attribute18 in varchar2 default null
1339 ,p_per_attribute19 in varchar2 default null
1340 ,p_per_attribute20 in varchar2 default null
1341 ,p_per_attribute21 in varchar2 default null
1342 ,p_per_attribute22 in varchar2 default null
1343 ,p_per_attribute23 in varchar2 default null
1344 ,p_per_attribute24 in varchar2 default null
1345 ,p_per_attribute25 in varchar2 default null
1346 ,p_per_attribute26 in varchar2 default null
1347 ,p_per_attribute27 in varchar2 default null
1348 ,p_per_attribute28 in varchar2 default null
1349 ,p_per_attribute29 in varchar2 default null
1353 ,p_hold_applicant_date_until in date default null
1350 ,p_per_attribute30 in varchar2 default null
1351 ,p_correspondence_language in varchar2 default null
1352 ,p_fte_capacity in number default null
1354 ,p_honors in varchar2 default null
1355 ,p_mailstop in varchar2 default null
1356 ,p_office_number in varchar2 default null
1357 ,p_on_military_service in varchar2 default null
1358 ,p_resume_exists in varchar2 default null
1359 ,p_resume_last_updated in date default null
1360 ,p_student_status in varchar2 default null
1361 ,p_work_schedule in varchar2 default null
1362 ,p_date_of_death in date default null
1363 ,p_original_date_of_hire in date default null
1364 ,p_person_id out nocopy number
1365 ,p_assignment_id out nocopy number
1366 ,p_application_id out nocopy number
1367 ,p_per_object_version_number out nocopy number
1368 ,p_asg_object_version_number out nocopy number
1369 ,p_apl_object_version_number out nocopy number
1370 ,p_per_effective_start_date out nocopy date
1371 ,p_per_effective_end_date out nocopy date
1372 ,p_full_name out nocopy varchar2
1373 ,p_per_comment_id out nocopy number
1374 ,p_assignment_sequence out nocopy number
1375 ,p_name_combination_warning out nocopy boolean
1376 ,p_orig_hire_warning out nocopy boolean
1377
1378 /* for special information */
1379
1380 ,p_id_flex_num in number
1381 ,p_pea_comments in varchar2 default null
1382 ,p_date_from in date default null
1383 ,p_date_to in date default null
1384 ,p_pea_attribute_category in varchar2 default null
1385 ,p_pea_attribute1 in varchar2 default null
1386 ,p_pea_attribute2 in varchar2 default null
1387 ,p_pea_attribute3 in varchar2 default null
1388 ,p_pea_attribute4 in varchar2 default null
1389 ,p_pea_attribute5 in varchar2 default null
1390 ,p_pea_attribute6 in varchar2 default null
1391 ,p_pea_attribute7 in varchar2 default null
1392 ,p_pea_attribute8 in varchar2 default null
1393 ,p_pea_attribute9 in varchar2 default null
1394 ,p_pea_attribute10 in varchar2 default null
1395 ,p_pea_attribute11 in varchar2 default null
1396 ,p_pea_attribute12 in varchar2 default null
1397 ,p_pea_attribute13 in varchar2 default null
1398 ,p_pea_attribute14 in varchar2 default null
1399 ,p_pea_attribute15 in varchar2 default null
1400 ,p_pea_attribute16 in varchar2 default null
1401 ,p_pea_attribute17 in varchar2 default null
1402 ,p_pea_attribute18 in varchar2 default null
1403 ,p_pea_attribute19 in varchar2 default null
1404 ,p_pea_attribute20 in varchar2 default null
1405 ,p_segment1 in varchar2 default null
1406 ,p_segment2 in varchar2 default null
1407 ,p_segment3 in varchar2 default null
1408 ,p_segment4 in varchar2 default null
1409 ,p_segment5 in varchar2 default null
1410 ,p_segment6 in varchar2 default null
1411 ,p_segment7 in varchar2 default null
1412 ,p_segment8 in varchar2 default null
1413 ,p_segment9 in varchar2 default null
1414 ,p_segment10 in varchar2 default null
1415 ,p_segment11 in varchar2 default null
1416 ,p_segment12 in varchar2 default null
1417 ,p_segment13 in varchar2 default null
1418 ,p_segment14 in varchar2 default null
1419 ,p_segment15 in varchar2 default null
1420 ,p_segment16 in varchar2 default null
1421 ,p_segment17 in varchar2 default null
1422 ,p_segment18 in varchar2 default null
1423 ,p_segment19 in varchar2 default null
1424 ,p_segment20 in varchar2 default null
1425 ,p_segment21 in varchar2 default null
1426 ,p_segment22 in varchar2 default null
1427 ,p_segment23 in varchar2 default null
1428 ,p_segment24 in varchar2 default null
1429 ,p_segment25 in varchar2 default null
1430 ,p_segment26 in varchar2 default null
1431 ,p_segment27 in varchar2 default null
1432 ,p_segment28 in varchar2 default null
1433 ,p_segment29 in varchar2 default null
1434 ,p_segment30 in varchar2 default null
1435 ,p_pea_object_version_number out nocopy number
1436 ,p_analysis_criteria_id out nocopy number
1437 ,p_person_analysis_id out nocopy number
1438 );
1439 --
1440 -- ----------------------------------------------------------------------------
1441 -- |-----------------------< create_jp_appl_with_educ_add >-------------------|
1445 /*#
1442 -- ----------------------------------------------------------------------------
1443 --
1444 -- {Start Of Comments}
1446 * This API creates a new applicant for Japan.
1447 *
1448 * The person details, an application, a special information record of JP
1449 * Educational Background, a primary JP address, a default applicant assignment
1450 * and if required associated assignment budget values and a letter request are
1451 * created.
1452 *
1453 * <p><b>Licensing</b><br>
1454 * This API is licensed for use with Human Resources.
1455 *
1456 * <p><b>Prerequisites</b><br>
1457 * A valid business_group_id of a JP legislation. A valid person_type_id, if
1458 * specified, with a corresponding system type of 'APL', must be active and in
1459 * the same business group as that of the applicant being created. If a
1460 * person_type_id is not specified the API will use the default 'APL' type for
1461 * the business group. Special Information Type of JP Educational Background
1462 * must be set enabled against the business group.
1463 *
1464 * <p><b>Post Success</b><br>
1465 * The person, application, special information record, address, default
1466 * applicant assignment and if required associated assignment budget values and
1467 * a letter request will be created.
1468 *
1469 * <p><b>Post Failure</b><br>
1470 * The person, special information record, address, default applicant
1471 * assignment, associated assignment budget values and a letter request will
1472 * not be created and an error will be raised.
1473 * @param p_validate If true, then validation alone will be performed and the
1474 * database will remain unchanged. If false and all validation checks pass,
1475 * then the database will be modified.
1476 * @param p_date_received The date an application was received and the
1477 * effective start date of the person, application and assignment.
1478 * @param p_business_group_id The applicant's business group.
1479 * @param p_last_name Applicant's last name (Kanji).
1480 * @param p_last_name_kana Applicant's last name (Kana).
1481 * @param p_sex {@rep:casecolumn PER_ALL_PEOPLE_F.SEX}
1482 * @param p_person_type_id Person type id. If a person_type_id is not specified
1483 * the API will use the default 'APL' type for the business group.
1484 * @param p_per_comments Comments for person record.
1485 * @param p_date_employee_data_verified The date on which the applicant data
1486 * was last verified.
1487 * @param p_date_of_birth {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_BIRTH}
1488 * @param p_email_address {@rep:casecolumn PER_ALL_PEOPLE_F.EMAIL_ADDRESS}
1489 * @param p_applicant_number This parameter details the applicant number. If
1490 * the number generation method is Manua,l then this parameter is mandatory. If
1491 * the number generation method is Automatic, then the value of this parameter
1492 * must be NULL. If p_validate is false and the applicant number generation
1493 * method is Automatic, this will be set to to the generated applicant number
1494 * of the person created. If p_validate is false and the applicant number
1495 * generation method is manual, this will be set to the same value passed in.
1496 * If p_validate is true this will be set to the same value as passed in.
1497 * @param p_expense_check_send_to_addres {@rep:casecolumn
1498 * PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS}
1499 * @param p_first_name Applicant's first name (Kanji).
1500 * @param p_first_name_kana Applicant's first name (Kana).
1501 * @param p_known_as {@rep:casecolumn PER_ALL_PEOPLE_F.KNOWN_AS}
1502 * @param p_marital_status {@rep:casecolumn PER_ALL_PEOPLE_F.MARITAL_STATUS}
1503 * @param p_middle_names Applicant's middle name(s).
1504 * @param p_nationality Applicant's nationality.
1505 * @param p_national_identifier {@rep:casecolumn
1506 * PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER}
1507 * @param p_previous_last_name Previous last name (Kanji).
1508 * @param p_previous_last_name_kana Previous last name (Kana).
1509 * @param p_registered_disabled_flag {@rep:casecolumn
1510 * PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG}
1511 * @param p_title Applicant's title.
1512 * @param p_work_telephone {@rep:casecolumn PER_ALL_PEOPLE_F.WORK_TELEPHONE}
1513 * @param p_per_attribute_category This context value determines which
1514 * Flexfield Structure to use with the Descriptive flexfield segments.
1515 * @param p_per_attribute1 Descriptive flexfield segment.
1516 * @param p_per_attribute2 Descriptive flexfield segment.
1517 * @param p_per_attribute3 Descriptive flexfield segment.
1518 * @param p_per_attribute4 Descriptive flexfield segment.
1519 * @param p_per_attribute5 Descriptive flexfield segment.
1520 * @param p_per_attribute6 Descriptive flexfield segment.
1521 * @param p_per_attribute7 Descriptive flexfield segment.
1522 * @param p_per_attribute8 Descriptive flexfield segment.
1523 * @param p_per_attribute9 Descriptive flexfield segment.
1524 * @param p_per_attribute10 Descriptive flexfield segment.
1525 * @param p_per_attribute11 Descriptive flexfield segment.
1526 * @param p_per_attribute12 Descriptive flexfield segment.
1527 * @param p_per_attribute13 Descriptive flexfield segment.
1528 * @param p_per_attribute14 Descriptive flexfield segment.
1529 * @param p_per_attribute15 Descriptive flexfield segment.
1530 * @param p_per_attribute16 Descriptive flexfield segment.
1531 * @param p_per_attribute17 Descriptive flexfield segment.
1532 * @param p_per_attribute18 Descriptive flexfield segment.
1533 * @param p_per_attribute19 Descriptive flexfield segment.
1534 * @param p_per_attribute20 Descriptive flexfield segment.
1535 * @param p_per_attribute21 Descriptive flexfield segment.
1536 * @param p_per_attribute22 Descriptive flexfield segment.
1537 * @param p_per_attribute23 Descriptive flexfield segment.
1538 * @param p_per_attribute24 Descriptive flexfield segment.
1542 * @param p_per_attribute28 Descriptive flexfield segment.
1539 * @param p_per_attribute25 Descriptive flexfield segment.
1540 * @param p_per_attribute26 Descriptive flexfield segment.
1541 * @param p_per_attribute27 Descriptive flexfield segment.
1543 * @param p_per_attribute29 Descriptive flexfield segment.
1544 * @param p_per_attribute30 Descriptive flexfield segment.
1545 * @param p_correspondence_language {@rep:casecolumn
1546 * PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE}
1547 * @param p_fte_capacity {@rep:casecolumn PER_ALL_PEOPLE_F.FTE_CAPACITY}
1548 * @param p_hold_applicant_date_until {@rep:casecolumn
1549 * PER_ALL_PEOPLE_F.HOLD_APPLICANT_DATE_UNTIL}
1550 * @param p_honors {@rep:casecolumn PER_ALL_PEOPLE_F.HONORS}
1551 * @param p_mailstop {@rep:casecolumn PER_ALL_PEOPLE_F.MAILSTOP}
1552 * @param p_office_number {@rep:casecolumn PER_ALL_PEOPLE_F.OFFICE_NUMBER}
1553 * @param p_on_military_service {@rep:casecolumn
1554 * PER_ALL_PEOPLE_F.ON_MILITARY_SERVICE}
1555 * @param p_resume_exists {@rep:casecolumn PER_ALL_PEOPLE_F.RESUME_EXISTS}
1556 * @param p_resume_last_updated {@rep:casecolumn
1557 * PER_ALL_PEOPLE_F.RESUME_LAST_UPDATED}
1558 * @param p_student_status {@rep:casecolumn PER_ALL_PEOPLE_F.STUDENT_STATUS}
1559 * @param p_work_schedule {@rep:casecolumn PER_ALL_PEOPLE_F.WORK_SCHEDULE}
1560 * @param p_date_of_death {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_DEATH}
1561 * @param p_original_date_of_hire {@rep:casecolumn
1562 * PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE}
1563 * @param p_person_id If p_validate is false, then this uniquely identifies the
1564 * person created. If p_validate is true, then this is set to null.
1565 * @param p_assignment_id If p_validate is false, then this uniquely identifies
1566 * the created assignment. If p_validate is true, then this is set to null.
1567 * @param p_application_id If p_validate is false, this uniquely identifies the
1568 * application created. If p_validate is true this parameter will be null.
1569 * @param p_per_object_version_number If p_validate is false, then set to the
1570 * version number of the created person. If p_validate is true, then the value
1571 * will be null.
1572 * @param p_asg_object_version_number If p_validate is false, then this
1573 * parameter is set to the version number of the assignment created. If
1574 * p_validate is true, then this parameter is null.
1575 * @param p_apl_object_version_number If p_validate is false, this will be set
1576 * to the version number of the application created. If p_validate is true this
1577 * parameter will be set to null.
1578 * @param p_per_effective_start_date If p_validate is false, then set to the
1579 * earliest effective start date for the created person. If p_validate is true,
1580 * then set to null.
1581 * @param p_per_effective_end_date If p_validate is false, then set to the
1582 * effective end date for the created person. If p_validate is true, then set
1583 * to null.
1584 * @param p_full_name If p_validate is false, this will be set to the complete
1585 * full name of the person. If p_validate is true this will be null.
1586 * @param p_per_comment_id If p_validate is false and comment text was
1587 * provided, then will be set to the identifier of the created person comment
1588 * record. If p_validate is true or no comment text was provided, then will be
1589 * null.
1590 * @param p_assignment_sequence If p_validate is false this will be set to the
1591 * sequence number of the default assignment. If p_validate is true this will
1592 * be null.
1593 * @param p_name_combination_warning If set to true, then the combination of
1594 * last name, first name and date of birth existed prior to calling this API.
1595 * @param p_orig_hire_warning Set to true if the original date of hire is not
1596 * null and the person type is not EMP,EMP_APL, EX_EMP or EX_EMP_APL.
1597 * @param p_pea_comments Comments for the special information record.
1598 * @param p_pea_date_from The date from which the special information record
1599 * applies.
1600 * @param p_pea_date_to The date on which the special information record no
1601 * longer applies.
1602 * @param p_pea_attribute_category This context value determines which
1603 * Flexfield Structure to use with the Descriptive flexfield segments.
1604 * @param p_pea_attribute1 Descriptive flexfield segment.
1605 * @param p_pea_attribute2 Descriptive flexfield segment.
1606 * @param p_pea_attribute3 Descriptive flexfield segment.
1607 * @param p_pea_attribute4 Descriptive flexfield segment.
1608 * @param p_pea_attribute5 Descriptive flexfield segment.
1609 * @param p_pea_attribute6 Descriptive flexfield segment.
1610 * @param p_pea_attribute7 Descriptive flexfield segment.
1611 * @param p_pea_attribute8 Descriptive flexfield segment.
1612 * @param p_pea_attribute9 Descriptive flexfield segment.
1613 * @param p_pea_attribute10 Descriptive flexfield segment.
1614 * @param p_pea_attribute11 Descriptive flexfield segment.
1615 * @param p_pea_attribute12 Descriptive flexfield segment.
1616 * @param p_pea_attribute13 Descriptive flexfield segment.
1617 * @param p_pea_attribute14 Descriptive flexfield segment.
1618 * @param p_pea_attribute15 Descriptive flexfield segment.
1619 * @param p_pea_attribute16 Descriptive flexfield segment.
1620 * @param p_pea_attribute17 Descriptive flexfield segment.
1621 * @param p_pea_attribute18 Descriptive flexfield segment.
1622 * @param p_pea_attribute19 Descriptive flexfield segment.
1623 * @param p_pea_attribute20 Descriptive flexfield segment.
1624 * @param p_school_type Type of School. Valid values are defined by
1625 * 'JP_SCHOOL_TYPE' lookup type.
1626 * @param p_school_id {@rep:casecolumn PER_JP_SCHOOL_LOOKUPS.SCHOOL_ID}
1627 * @param p_school_name {@rep:casecolumn PER_JP_SCHOOL_LOOKUPS.SCHOOL_NAME}
1628 * @param p_school_name_kana {@rep:casecolumn
1629 * PER_JP_SCHOOL_LOOKUPS.SCHOOL_NAME_KANA}
1633 * @param p_graduation_date Graduation Date.
1630 * @param p_major {@rep:casecolumn PER_JP_SCHOOL_LOOKUPS.MAJOR}
1631 * @param p_major_kana {@rep:casecolumn PER_JP_SCHOOL_LOOKUPS.MAJOR_KANA}
1632 * @param p_advisor Department.
1634 * @param p_note Note.
1635 * @param p_last_flag This identifies the last educational background detail
1636 * for the applicant.
1637 * @param p_pea_object_version_number If p_validate is false, then this is set
1638 * to the version number of the created special information record. If
1639 * p_validate is true, then the value will be null.
1640 * @param p_analysis_criteria_id If p_validate is false, this uniquely
1641 * identifies the combination of the personal analysis flexfield segments
1642 * created. If p_validate is true this parameter will be null.
1643 * @param p_person_analysis_id If p_validate is false, this uniquely identifies
1644 * the special information record created. If p_validate is true this parameter
1645 * will be null.
1646 * @param p_add_date_from The date from which the address applies.
1647 * @param p_add_date_to The date on which the address no longer applies.
1648 * @param p_address_type Type of address. Valid values are defined by
1649 * 'ADDRESS_TYPE' lookup type.
1650 * @param p_add_comments Comment text for address.
1651 * @param p_address_line1 Line 1 of address.
1652 * @param p_address_line2 Line 2 of address.
1653 * @param p_address_line3 Line 3 of address.
1654 * @param p_district_code District code.
1655 * @param p_address_line1_kana Line 1 of address (Kana).
1656 * @param p_address_line2_kana Line 2 of address (Kana).
1657 * @param p_address_line3_kana Line 3 of address (Kana).
1658 * @param p_postcode Postal Code.
1659 * @param p_country Country.
1660 * @param p_telephone_number_1 Telephone number.
1661 * @param p_telephone_number_2 Telephone number.
1662 * @param p_fax_number Fax Number.
1663 * @param p_addr_attribute_category This context value determines which
1664 * flexfield structure to use with the Person Address descriptive flexfield
1665 * segments.
1666 * @param p_addr_attribute1 Descriptive flexfield segment.
1667 * @param p_addr_attribute2 Descriptive flexfield segment.
1668 * @param p_addr_attribute3 Descriptive flexfield segment.
1669 * @param p_addr_attribute4 Descriptive flexfield segment.
1670 * @param p_addr_attribute5 Descriptive flexfield segment.
1671 * @param p_addr_attribute6 Descriptive flexfield segment.
1672 * @param p_addr_attribute7 Descriptive flexfield segment.
1673 * @param p_addr_attribute8 Descriptive flexfield segment.
1674 * @param p_addr_attribute9 Descriptive flexfield segment.
1675 * @param p_addr_attribute10 Descriptive flexfield segment.
1676 * @param p_addr_attribute11 Descriptive flexfield segment.
1677 * @param p_addr_attribute12 Descriptive flexfield segment.
1678 * @param p_addr_attribute13 Descriptive flexfield segment.
1679 * @param p_addr_attribute14 Descriptive flexfield segment.
1680 * @param p_addr_attribute15 Descriptive flexfield segment.
1681 * @param p_addr_attribute16 Descriptive flexfield segment.
1682 * @param p_addr_attribute17 Descriptive flexfield segment.
1683 * @param p_addr_attribute18 Descriptive flexfield segment.
1684 * @param p_addr_attribute19 Descriptive flexfield segment.
1685 * @param p_addr_attribute20 Descriptive flexfield segment.
1686 * @param p_address_id If p_validate is false, this uniquely identifies the
1687 * address created. If p_validate is true, this is set to null.
1688 * @param p_add_object_version_number If p_validate is false, then this is set
1689 * to the version number of the created address. If p_validate is true, then
1690 * the value will be null.
1691 * @rep:displayname Create Applicant with Education Background and Address for Japan
1692 * @rep:category BUSINESS_ENTITY PER_APPLICANT
1693 * @rep:scope public
1694 * @rep:lifecycle active
1695 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1696 */
1697 --
1698 -- {End Of Comments}
1699 --
1700 procedure create_jp_appl_with_educ_add
1701 (
1702 -- for per_people_f
1703 --
1704 p_validate in boolean default false
1705 ,p_date_received in date
1706 ,p_business_group_id in number
1707 ,p_last_name in varchar2
1708 ,p_last_name_kana in varchar2
1709 ,p_sex in varchar2 default null
1710 ,p_person_type_id in number default null
1711 ,p_per_comments in varchar2 default null
1712 ,p_date_employee_data_verified in date default null
1713 ,p_date_of_birth in date default null
1714 ,p_email_address in varchar2 default null
1715 ,p_applicant_number in out nocopy varchar2
1716 ,p_expense_check_send_to_addres in varchar2 default null
1717 ,p_first_name in varchar2 default null
1718 ,p_first_name_kana in varchar2 default null
1719 ,p_known_as in varchar2 default null
1720 ,p_marital_status in varchar2 default null
1721 ,p_middle_names in varchar2 default null
1722 ,p_nationality in varchar2 default null
1723 ,p_national_identifier in varchar2 default null
1724 ,p_previous_last_name in varchar2 default null
1725 ,p_previous_last_name_kana in varchar2 default null
1726 ,p_registered_disabled_flag in varchar2 default null
1727 ,p_title in varchar2 default null
1728 ,p_work_telephone in varchar2 default null
1729 ,p_per_attribute_category in varchar2 default null
1733 ,p_per_attribute4 in varchar2 default null
1730 ,p_per_attribute1 in varchar2 default null
1731 ,p_per_attribute2 in varchar2 default null
1732 ,p_per_attribute3 in varchar2 default null
1734 ,p_per_attribute5 in varchar2 default null
1735 ,p_per_attribute6 in varchar2 default null
1736 ,p_per_attribute7 in varchar2 default null
1737 ,p_per_attribute8 in varchar2 default null
1738 ,p_per_attribute9 in varchar2 default null
1739 ,p_per_attribute10 in varchar2 default null
1740 ,p_per_attribute11 in varchar2 default null
1741 ,p_per_attribute12 in varchar2 default null
1742 ,p_per_attribute13 in varchar2 default null
1743 ,p_per_attribute14 in varchar2 default null
1744 ,p_per_attribute15 in varchar2 default null
1745 ,p_per_attribute16 in varchar2 default null
1746 ,p_per_attribute17 in varchar2 default null
1747 ,p_per_attribute18 in varchar2 default null
1748 ,p_per_attribute19 in varchar2 default null
1749 ,p_per_attribute20 in varchar2 default null
1750 ,p_per_attribute21 in varchar2 default null
1751 ,p_per_attribute22 in varchar2 default null
1752 ,p_per_attribute23 in varchar2 default null
1753 ,p_per_attribute24 in varchar2 default null
1754 ,p_per_attribute25 in varchar2 default null
1755 ,p_per_attribute26 in varchar2 default null
1756 ,p_per_attribute27 in varchar2 default null
1757 ,p_per_attribute28 in varchar2 default null
1758 ,p_per_attribute29 in varchar2 default null
1759 ,p_per_attribute30 in varchar2 default null
1760 ,p_correspondence_language in varchar2 default null
1761 ,p_fte_capacity in number default null
1762 ,p_hold_applicant_date_until in date default null
1763 ,p_honors in varchar2 default null
1764 ,p_mailstop in varchar2 default null
1765 ,p_office_number in varchar2 default null
1766 ,p_on_military_service in varchar2 default null
1767 ,p_resume_exists in varchar2 default null
1768 ,p_resume_last_updated in date default null
1769 ,p_student_status in varchar2 default null
1770 ,p_work_schedule in varchar2 default null
1771 ,p_date_of_death in date default null
1772 ,p_original_date_of_hire in date default null
1773 ,p_person_id out nocopy number
1774 ,p_assignment_id out nocopy number
1775 ,p_application_id out nocopy number
1776 ,p_per_object_version_number out nocopy number
1777 ,p_asg_object_version_number out nocopy number
1778 ,p_apl_object_version_number out nocopy number
1779 ,p_per_effective_start_date out nocopy date
1780 ,p_per_effective_end_date out nocopy date
1781 ,p_full_name out nocopy varchar2
1782 ,p_per_comment_id out nocopy number
1783 ,p_assignment_sequence out nocopy number
1784 ,p_name_combination_warning out nocopy boolean
1785 ,p_orig_hire_warning out nocopy boolean
1786 --
1787 -- for special information
1788 --
1789 ,p_pea_comments in varchar2 default null
1790 ,p_pea_date_from in date default null
1791 ,p_pea_date_to in date default null
1792 ,p_pea_attribute_category in varchar2 default null
1793 ,p_pea_attribute1 in varchar2 default null
1794 ,p_pea_attribute2 in varchar2 default null
1795 ,p_pea_attribute3 in varchar2 default null
1796 ,p_pea_attribute4 in varchar2 default null
1797 ,p_pea_attribute5 in varchar2 default null
1798 ,p_pea_attribute6 in varchar2 default null
1799 ,p_pea_attribute7 in varchar2 default null
1800 ,p_pea_attribute8 in varchar2 default null
1801 ,p_pea_attribute9 in varchar2 default null
1802 ,p_pea_attribute10 in varchar2 default null
1803 ,p_pea_attribute11 in varchar2 default null
1804 ,p_pea_attribute12 in varchar2 default null
1805 ,p_pea_attribute13 in varchar2 default null
1806 ,p_pea_attribute14 in varchar2 default null
1807 ,p_pea_attribute15 in varchar2 default null
1808 ,p_pea_attribute16 in varchar2 default null
1809 ,p_pea_attribute17 in varchar2 default null
1810 ,p_pea_attribute18 in varchar2 default null
1811 ,p_pea_attribute19 in varchar2 default null
1812 ,p_pea_attribute20 in varchar2 default null
1813 ,p_school_type in varchar2 default null
1814 ,p_school_id in varchar2 default null
1815 ,p_school_name in varchar2 default null
1816 ,p_school_name_kana in varchar2 default null
1817 ,p_major in varchar2 default null
1818 ,p_major_kana in varchar2 default null
1819 ,p_advisor in varchar2 default null
1823 ,p_pea_object_version_number out nocopy number
1820 ,p_graduation_date in varchar2 default null
1821 ,p_note in varchar2 default null
1822 ,p_last_flag in varchar2 default null
1824 ,p_analysis_criteria_id out nocopy number
1825 ,p_person_analysis_id out nocopy number
1826 --
1827 -- for per_addresses
1828 --
1829 ,p_add_date_from in date default null
1830 ,p_add_date_to in date default null
1831 ,p_address_type in varchar2 default null
1832 ,p_add_comments in varchar2 default null
1833 ,p_address_line1 in varchar2 default null
1834 ,p_address_line2 in varchar2 default null
1835 ,p_address_line3 in varchar2 default null
1836 ,p_district_code in varchar2 default null
1837 ,p_address_line1_kana in varchar2 default null
1838 ,p_address_line2_kana in varchar2 default null
1839 ,p_address_line3_kana in varchar2 default null
1840 ,p_postcode in varchar2 default null
1841 ,p_country in varchar2 default null
1842 ,p_telephone_number_1 in varchar2 default null
1843 ,p_telephone_number_2 in varchar2 default null
1844 ,p_fax_number in varchar2 default null
1845 ,p_addr_attribute_category in varchar2 default null
1846 ,p_addr_attribute1 in varchar2 default null
1847 ,p_addr_attribute2 in varchar2 default null
1848 ,p_addr_attribute3 in varchar2 default null
1849 ,p_addr_attribute4 in varchar2 default null
1850 ,p_addr_attribute5 in varchar2 default null
1851 ,p_addr_attribute6 in varchar2 default null
1852 ,p_addr_attribute7 in varchar2 default null
1853 ,p_addr_attribute8 in varchar2 default null
1854 ,p_addr_attribute9 in varchar2 default null
1855 ,p_addr_attribute10 in varchar2 default null
1856 ,p_addr_attribute11 in varchar2 default null
1857 ,p_addr_attribute12 in varchar2 default null
1858 ,p_addr_attribute13 in varchar2 default null
1859 ,p_addr_attribute14 in varchar2 default null
1860 ,p_addr_attribute15 in varchar2 default null
1861 ,p_addr_attribute16 in varchar2 default null
1862 ,p_addr_attribute17 in varchar2 default null
1863 ,p_addr_attribute18 in varchar2 default null
1864 ,p_addr_attribute19 in varchar2 default null
1865 ,p_addr_attribute20 in varchar2 default null
1866 ,p_address_id out nocopy number
1867 ,p_add_object_version_number out nocopy number
1868 );
1869
1870 --
1871 end HR_JPBP_API;
[Home] [Help]