1 package hr_sg_employee_api as
2 /* $Header: hrsgwree.pkh 120.6 2007/10/26 01:32:59 jalin noship $ */
3 /*#
4 * This API creates employes for Singapore.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Employee for Singapore
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------------< create_sg_employee >------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates an employee for a Singapore business group.
17 *
18 * The API performs mapping of Developer Descriptive Flexfield segments. This
19 * ensures appropriate identification information has been entered ie. National
20 * identifier or Passport information, Legal Name, Work authority, Community
21 * Fund.
22 *
23 * <p><b>Licensing</b><br>
24 * This API is licensed for use with Human Resources.
25 *
26 * <p><b>Prerequisites</b><br>
27 * If person_type_id is supplied, it must have a corresponding system person
28 * type of 'EMP', must be active and be in the same business group as that of
29 * the employee being created. Also the business group supplied should be a
30 * Singapore business group.
31 *
32 * <p><b>Post Success</b><br>
33 * Successfully creates the person, primary assignment and period of service in
34 * the database.
35 *
36 * <p><b>Post Failure</b><br>
37 * The API does not create the person, primary assignment or period of service
38 * and raises an error.
39 * @param p_validate If true, then validation alone will be performed and the
40 * database will remain unchanged. If false and all validation checks pass,
41 * then the database will be modified.
42 * @param p_hire_date Indicates the date on which the employee is hired.
43 * @param p_business_group_id {@rep:casecolumn
44 * PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID}
45 * @param p_last_name {@rep:casecolumn PER_ALL_PEOPLE_F.LAST_NAME}
46 * @param p_sex Indicates the Employee's Legal gender. Valid values are defined
47 * by 'SEX' lookup type.
48 * @param p_person_type_id {@rep:casecolumn PER_ALL_PEOPLE_F.PERSON_TYPE_ID}
49 * @param p_comments Comment text.
50 * @param p_date_employee_data_verified {@rep:casecolumn
51 * PER_ALL_PEOPLE_F.DATE_EMPLOYEE_DATA_VERIFIED}
52 * @param p_date_of_birth {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_BIRTH}
53 * @param p_email_address {@rep:casecolumn PER_ALL_PEOPLE_F.EMAIL_ADDRESS}
54 * @param p_employee_number The business group's employee number generation
55 * method determines when the API derives and passes out an employee number or
56 * when the calling program should pass in a value. When the API call completes
57 * if p_validate is false then will be set to the employee number. If
58 * p_validate is true then will be set to the passed value.
59 * @param p_expense_check_send_to_addres Indicates the Employee's Address to
60 * which the expense must be sent. Valid values are determined by 'HOME_OFFICE'
61 * lookup type.
62 * @param p_first_name {@rep:casecolumn PER_ALL_PEOPLE_F.FIRST_NAME}
63 * @param p_known_as {@rep:casecolumn PER_ALL_PEOPLE_F.KNOWN_AS}
64 * @param p_marital_status Indicates the Employee's Marital status. Valid
65 * values are defined by 'MAR_STATUS' lookup type.
66 * @param p_middle_names {@rep:casecolumn PER_ALL_PEOPLE_F.MIDDLE_NAMES}
67 * @param p_nationality Indicates the Employee's Nationality. Valid values are
68 * defined by 'NATIONALITY' lookup type.
69 * @param p_national_identifier {@rep:casecolumn
70 * PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER}
71 * @param p_previous_last_name {@rep:casecolumn
72 * PER_ALL_PEOPLE_F.PREVIOUS_LAST_NAME}
73 * @param p_registered_disabled_flag Flag indicating whether person is
74 * classified as disabled. Valid values are defined by 'REGISTERED_DISABLED'
75 * lookup type.
76 * @param p_title Title e.g. Mr, Mrs, Dr. Valid values are defined by 'TITLE'
77 * lookup type.
78 * @param p_vendor_id {@rep:casecolumn PER_ALL_PEOPLE_F.VENDOR_ID}
79 * @param p_work_telephone {@rep:casecolumn PER_ALL_PEOPLE_F.WORK_TELEPHONE}
80 * @param p_attribute_category This context value determines which flexfield
81 * structure to use with the descriptive flexfield segments.
82 * @param p_attribute1 Descriptive flexfield segment.
83 * @param p_attribute2 Descriptive flexfield segment.
84 * @param p_attribute3 Descriptive flexfield segment.
85 * @param p_attribute4 Descriptive flexfield segment.
86 * @param p_attribute5 Descriptive flexfield segment.
87 * @param p_attribute6 Descriptive flexfield segment.
88 * @param p_attribute7 Descriptive flexfield segment.
89 * @param p_attribute8 Descriptive flexfield segment.
90 * @param p_attribute9 Descriptive flexfield segment.
91 * @param p_attribute10 Descriptive flexfield segment.
92 * @param p_attribute11 Descriptive flexfield segment.
93 * @param p_attribute12 Descriptive flexfield segment.
94 * @param p_attribute13 Descriptive flexfield segment.
95 * @param p_attribute14 Descriptive flexfield segment.
96 * @param p_attribute15 Descriptive flexfield segment.
97 * @param p_attribute16 Descriptive flexfield segment.
98 * @param p_attribute17 Descriptive flexfield segment.
99 * @param p_attribute18 Descriptive flexfield segment.
100 * @param p_attribute19 Descriptive flexfield segment.
101 * @param p_attribute20 Descriptive flexfield segment.
102 * @param p_attribute21 Descriptive flexfield segment.
103 * @param p_attribute22 Descriptive flexfield segment.
104 * @param p_attribute23 Descriptive flexfield segment.
105 * @param p_attribute24 Descriptive flexfield segment.
106 * @param p_attribute25 Descriptive flexfield segment.
107 * @param p_attribute26 Descriptive flexfield segment.
108 * @param p_attribute27 Descriptive flexfield segment.
109 * @param p_attribute28 Descriptive flexfield segment.
110 * @param p_attribute29 Descriptive flexfield segment.
111 * @param p_attribute30 Descriptive flexfield segment.
112 * @param p_legal_name {@rep:casecolumn PER_ALL_PEOPLE_F.PER_INFORMATION1}
113 * @param p_passport_number {@rep:casecolumn PER_ALL_PEOPLE_F.PER_INFORMATION2}
114 * @param p_passport_country_of_issue {@rep:casecolumn
115 * PER_ALL_PEOPLE_F.PER_INFORMATION3}
116 * @param p_passport_date_issued {@rep:casecolumn
117 * PER_ALL_PEOPLE_F.PER_INFORMATION4}
118 * @param p_passport_expiry_date {@rep:casecolumn
119 * PER_ALL_PEOPLE_F.PER_INFORMATION5}
120 * @param p_permit_type {@rep:casecolumn PER_ALL_PEOPLE_F.PER_INFORMATION6}
121 * @param p_permit_number {@rep:casecolumn PER_ALL_PEOPLE_F.PER_INFORMATION7}
122 * @param p_permit_category {@rep:casecolumn PER_ALL_PEOPLE_F.PER_INFORMATION8}
123 * @param p_permit_date_issued {@rep:casecolumn
124 * PER_ALL_PEOPLE_F.PER_INFORMATION9}
125 * @param p_permit_expiry_date {@rep:casecolumn
126 * PER_ALL_PEOPLE_F.PER_INFORMATION10}
127 * @param p_permit_date_cancelled {@rep:casecolumn
128 * PER_ALL_PEOPLE_F.PER_INFORMATION11}
129 * @param p_income_tax_number {@rep:casecolumn
130 * PER_ALL_PEOPLE_F.PER_INFORMATION12}
131 * @param p_income_tax_number_spouse {@rep:casecolumn
132 * PER_ALL_PEOPLE_F.PER_INFORMATION13}
133 * @param p_cpf_account_number {@rep:casecolumn
134 * PER_ALL_PEOPLE_F.PER_INFORMATION14}
135 * @param p_nric_colour {@rep:casecolumn PER_ALL_PEOPLE_F.PER_INFORMATION15}
136 * @param p_religion {@rep:casecolumn PER_ALL_PEOPLE_F.PER_INFORMATION16}
137 * @param p_cpf_category {@rep:casecolumn PER_ALL_PEOPLE_F.PER_INFORMATION17}
138 * @param p_race {@rep:casecolumn PER_ALL_PEOPLE_F.PER_INFORMATION18}
139 * @param p_community_fund_category {@rep:casecolumn
140 * PER_ALL_PEOPLE_F.PER_INFORMATION19}
141 * @param p_date_of_death {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_DEATH}
142 * @param p_background_check_status Indicates the Background check status of
143 * the employee. Valid values as applicable are defined by 'YES_NO' lookup
144 * type.
145 * @param p_background_date_check {@rep:casecolumn
146 * PER_ALL_PEOPLE_F.BACKGROUND_DATE_CHECK}
147 * @param p_blood_type Blood Type. Valid values are defined by the 'BLOOD_TYPE'
148 * lookup type.
149 * @param p_correspondence_language {@rep:casecolumn
150 * PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE}
151 * @param p_fast_path_employee {@rep:casecolumn
152 * PER_ALL_PEOPLE_F.FAST_PATH_EMPLOYEE}
153 * @param p_fte_capacity {@rep:casecolumn PER_ALL_PEOPLE_F.FTE_CAPACITY}
154 * @param p_honors {@rep:casecolumn PER_ALL_PEOPLE_F.HONORS}
155 * @param p_internal_location {@rep:casecolumn
156 * PER_ALL_PEOPLE_F.INTERNAL_LOCATION}
157 * @param p_last_medical_test_by {@rep:casecolumn
158 * PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_BY}
159 * @param p_last_medical_test_date {@rep:casecolumn
160 * PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_DATE}
161 * @param p_mailstop {@rep:casecolumn PER_ALL_PEOPLE_F.MAILSTOP}
162 * @param p_office_number {@rep:casecolumn PER_ALL_PEOPLE_F.OFFICE_NUMBER}
163 * @param p_on_military_service Indicates whether the employee was in the
164 * military service. Valid values as applicable are defined by 'YES_NO' lookup
165 * type.
166 * @param p_pre_name_adjunct {@rep:casecolumn
167 * PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT}
168 * @param p_projected_start_date {@rep:casecolumn
169 * PER_ALL_PEOPLE_F.PROJECTED_START_DATE}
170 * @param p_resume_exists Indicates whether the Employee's Resume already
171 * exists in the database. Valid values as applicable are defined by 'YES_NO'
172 * lookup type.
173 * @param p_resume_last_updated {@rep:casecolumn
174 * PER_ALL_PEOPLE_F.RESUME_LAST_UPDATED}
175 * @param p_second_passport_exists Second passport available flag. Valid values
176 * are defined by 'YES_NO' lookup type.
177 * @param p_student_status Student Status. Valid values are defined by the
178 * 'STUDENT_STATUS' lookup type.
179 * @param p_work_schedule Indicates the Employee's Work schedule. Valid values
180 * are defined by 'WORK_SCHEDULE' lookup type.
181 * @param p_suffix {@rep:casecolumn PER_ALL_PEOPLE_F.SUFFIX}
182 * @param p_benefit_group_id {@rep:casecolumn
183 * PER_ALL_PEOPLE_F.BENEFIT_GROUP_ID}
184 * @param p_receipt_of_death_cert_date {@rep:casecolumn
185 * PER_ALL_PEOPLE_F.RECEIPT_OF_DEATH_CERT_DATE}
186 * @param p_coord_ben_med_pln_no {@rep:casecolumn
187 * PER_ALL_PEOPLE_F.COORD_BEN_MED_PLN_NO}
188 * @param p_coord_ben_no_cvg_flag Indicates whether the employee has any
189 * coverage other than the Coordination of benefits. Valid values as applicable
190 * are defined by 'YES_NO' lookup type.
191 * @param p_uses_tobacco_flag Indicates whether the employee uses tabacco.
192 * Valid values as applicable are defined by 'YES_NO' lookup type.
193 * @param p_dpdnt_adoption_date {@rep:casecolumn
194 * PER_ALL_PEOPLE_F.DPDNT_ADOPTION_DATE}
195 * @param p_dpdnt_vlntry_svce_flag Indicates whether the employee was in the
196 * dependent voluntary service. Valid values are defined by 'YES_NO' lookup
197 * type.
198 * @param p_original_date_of_hire {@rep:casecolumn
199 * PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE}
200 * @param p_adjusted_svc_date {@rep:casecolumn
201 * PER_PERIODS_OF_SERVICE.ADJUSTED_SVC_DATE}
202 * @param p_town_of_birth {@rep:casecolumn PER_ALL_PEOPLE_F.TOWN_OF_BIRTH}
203 * @param p_region_of_birth {@rep:casecolumn PER_ALL_PEOPLE_F.REGION_OF_BIRTH}
204 * @param p_country_of_birth {@rep:casecolumn
205 * PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH}
206 * @param p_global_person_id {@rep:casecolumn
207 * PER_ALL_PEOPLE_F.GLOBAL_PERSON_ID}
208 * @param p_person_id Identifies the person for whom you create the employee
209 * record.
210 * @param p_assignment_id If p_validate is false, then this uniquely identifies
211 * the created assignment. If p_validate is true, then set to null.
212 * @param p_per_object_version_number If p_validate is false, then set to the
213 * version number of the created person. If p_validate is true, then the value
214 * will be null.
215 * @param p_asg_object_version_number If p_validate is false, then set to the
216 * version number of the created assignment. If p_validate is true, then the
217 * value will be null.
218 * @param p_per_effective_start_date If p_validate is false, this will be set
219 * to the effective start date of the person. If p_validate is true this will
220 * be null.
221 * @param p_per_effective_end_date If p_validate is false, this will be set to
222 * the effective end date of the person. If p_validate is true this will be
223 * null.
224 * @param p_full_name If p_validate is false, then set to the full name of the
225 * person. If p_validate is true, then set to null.
226 * @param p_per_comment_id If p_validate is false, this will be set to the
227 * comments for the person. If p_validate is true this will be null.
228 * @param p_assignment_sequence If p_validate is false, this will be set to the
229 * assignment sequence for the person. If p_validate is true this will be null.
230 * @param p_assignment_number If p_validate is false, this will be set to the
231 * assignment number of the person. If p_validate is true this will be null.
232 * @param p_name_combination_warning If set to true, then the combination of
233 * last name, first name and date of birth existed prior to calling this API.
234 * @param p_assign_payroll_warning If set to true, then the date of birth is
235 * not entered. If set to false, then the date of birth has been entered.
236 * Indicates if it will be possible to set the payroll on any of this person's
237 * assignments.
238 * @param p_orig_hire_warning If p_validate is false, the original date of hire
239 * is provided and the person type is not
240 * Employee,Employee-Applicant,Ex-Employee or Ex-Employee Applicant, then set
241 * to true.
242 * @param p_rehire_recommendation Obsolete parameter, do not use.
243 * @param p_coord_ben_med_ext_er Secondary external medical coverage. Column
244 * used for external processing.
245 * @param p_coord_ben_med_pl_name Secondary medical coverage name. Column used
246 * for external processing.
247 * @param p_coord_ben_med_insr_crr_name Secondary medical coverage insurance
248 * carrier name. Column used for external processing.
249 * @param p_coord_ben_med_insr_crr_ident Secondary medical coverage insurance
250 * carrier identifier. Column used for external processing.
251 * @param p_coord_ben_med_cvg_strt_dt Secondary medical coverage effective
252 * start date. Column used for external processing.
253 * @param p_coord_ben_med_cvg_end_dt Secondary medical coverage effective end
254 * date. Column used for external processing.
255 * @param p_party_id TCA party for whom you create the person record.
256 * @param p_payee_id_type {@rep:casecolumn PER_ALL_PEOPLE_F.PER_INFORMATION23}
257 * @param p_ee_er_rate {@rep:casecolumn PER_ALL_PEOPLE_F.PER_INFORMATION20}
258 * @param p_mbf {@rep:casecolumn PER_ALL_PEOPLE_F.PER_INFORMATION21}
259 * @param p_mdk {@rep:casecolumn PER_ALL_PEOPLE_F.PER_INFORMATION22}
260 * @rep:displayname Create Employee for Singapore
261 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE
262 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
263 * @rep:scope public
264 * @rep:lifecycle active
265 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
266 */
267 --
268 -- {End Of Comments}
269 --
270 PROCEDURE create_sg_employee
271 (p_validate in boolean default false
272 ,p_hire_date in date
273 ,p_business_group_id in number
274 ,p_last_name in varchar2
275 ,p_sex in varchar2
276 ,p_person_type_id in number default null
277 ,p_comments in varchar2 default null
278 ,p_date_employee_data_verified in date default null
279 ,p_date_of_birth in date default null
280 ,p_email_address in varchar2 default null
281 ,p_employee_number in out nocopy varchar2
282 ,p_expense_check_send_to_addres in varchar2 default null
283 ,p_first_name in varchar2 default null
284 ,p_known_as in varchar2 default null
285 ,p_marital_status in varchar2 default null
286 ,p_middle_names in varchar2 default null
287 ,p_nationality in varchar2 default null
288 ,p_national_identifier in varchar2 default null
289 ,p_previous_last_name in varchar2 default null
290 ,p_registered_disabled_flag in varchar2 default null
291 ,p_title in varchar2 default null
292 ,p_vendor_id in number default null
293 ,p_work_telephone in varchar2 default null
294 ,p_attribute_category in varchar2 default null
295 ,p_attribute1 in varchar2 default null
296 ,p_attribute2 in varchar2 default null
297 ,p_attribute3 in varchar2 default null
298 ,p_attribute4 in varchar2 default null
299 ,p_attribute5 in varchar2 default null
300 ,p_attribute6 in varchar2 default null
301 ,p_attribute7 in varchar2 default null
302 ,p_attribute8 in varchar2 default null
303 ,p_attribute9 in varchar2 default null
304 ,p_attribute10 in varchar2 default null
305 ,p_attribute11 in varchar2 default null
306 ,p_attribute12 in varchar2 default null
307 ,p_attribute13 in varchar2 default null
308 ,p_attribute14 in varchar2 default null
309 ,p_attribute15 in varchar2 default null
310 ,p_attribute16 in varchar2 default null
311 ,p_attribute17 in varchar2 default null
312 ,p_attribute18 in varchar2 default null
313 ,p_attribute19 in varchar2 default null
314 ,p_attribute20 in varchar2 default null
315 ,p_attribute21 in varchar2 default null
316 ,p_attribute22 in varchar2 default null
317 ,p_attribute23 in varchar2 default null
318 ,p_attribute24 in varchar2 default null
319 ,p_attribute25 in varchar2 default null
320 ,p_attribute26 in varchar2 default null
321 ,p_attribute27 in varchar2 default null
322 ,p_attribute28 in varchar2 default null
323 ,p_attribute29 in varchar2 default null
324 ,p_attribute30 in varchar2 default null
325 ,p_legal_name in varchar2
326 ,p_passport_number in varchar2 default null
327 ,p_passport_country_of_issue in varchar2 default null
328 ,p_passport_date_issued in date default null
329 ,p_passport_expiry_date in date default null
330 ,p_permit_type in varchar2
331 ,p_permit_number in varchar2 default null
332 ,p_permit_category in varchar2 default null
333 ,p_permit_date_issued in date default null
334 ,p_permit_expiry_date in date default null
335 ,p_permit_date_cancelled in date default null
336 ,p_income_tax_number in varchar2 default null
337 ,p_income_tax_number_spouse in varchar2 default null
338 ,p_cpf_account_number in varchar2 default null
339 ,p_nric_colour in varchar2 default null
340 ,p_religion in varchar2 default null
341 ,p_cpf_category in varchar2 default null
342 ,p_race in varchar2 default null
343 ,p_community_fund_category in varchar2
344 ,p_date_of_death in date default null
345 ,p_background_check_status in varchar2 default null
346 ,p_background_date_check in date default null
347 ,p_blood_type in varchar2 default null
348 ,p_correspondence_language in varchar2 default null
349 ,p_fast_path_employee in varchar2 default null
350 ,p_fte_capacity in number default null
351 ,p_honors in varchar2 default null
352 ,p_internal_location in varchar2 default null
353 ,p_last_medical_test_by in varchar2 default null
354 ,p_last_medical_test_date in date default null
355 ,p_mailstop in varchar2 default null
356 ,p_office_number in varchar2 default null
357 ,p_on_military_service in varchar2 default null
358 ,p_pre_name_adjunct in varchar2 default null
359 ,p_rehire_recommendation in varchar2 default null
360 ,p_projected_start_date in date default null
361 ,p_resume_exists in varchar2 default null
362 ,p_resume_last_updated in date default null
363 ,p_second_passport_exists in varchar2 default null
364 ,p_student_status in varchar2 default null
365 ,p_work_schedule in varchar2 default null
366 ,p_suffix in varchar2 default null
370 ,p_coord_ben_no_cvg_flag in varchar2 default 'N'
367 ,p_benefit_group_id in number default null
368 ,p_receipt_of_death_cert_date in date default null
369 ,p_coord_ben_med_pln_no in varchar2 default null
371 ,p_coord_ben_med_ext_er in varchar2 default null
372 ,p_coord_ben_med_pl_name in varchar2 default null
373 ,p_coord_ben_med_insr_crr_name in varchar2 default null
374 ,p_coord_ben_med_insr_crr_ident in varchar2 default null
375 ,p_coord_ben_med_cvg_strt_dt in date default null
376 ,p_coord_ben_med_cvg_end_dt in date default null
377 ,p_uses_tobacco_flag in varchar2 default null
378 ,p_dpdnt_adoption_date in date default null
379 ,p_dpdnt_vlntry_svce_flag in varchar2 default 'N'
380 ,p_original_date_of_hire in date default null
381 ,p_adjusted_svc_date in date default null
382 ,p_town_of_birth in varchar2 default null
383 ,p_region_of_birth in varchar2 default null
384 ,p_country_of_birth in varchar2 default null
385 ,p_global_person_id in varchar2 default null
386 ,p_party_id in number default null
387 ,p_payee_id_type in varchar2 default null
388 ,p_ee_er_rate in varchar2 default null/*Bug 6393528*/
389 ,p_mbf in varchar2 default null/*Bug 6393528,6526444*/
390 ,p_mdk in varchar2 default null/*Bug 6393528,6526444*/
391 ,p_person_id out nocopy number
392 ,p_assignment_id out nocopy number
393 ,p_per_object_version_number out nocopy number
394 ,p_asg_object_version_number out nocopy number
395 ,p_per_effective_start_date out nocopy date
396 ,p_per_effective_end_date out nocopy date
397 ,p_full_name out nocopy varchar2
398 ,p_per_comment_id out nocopy number
399 ,p_assignment_sequence out nocopy number
400 ,p_assignment_number out nocopy varchar2
401 ,p_name_combination_warning out nocopy boolean
402 ,p_assign_payroll_warning out nocopy boolean
403 ,p_orig_hire_warning out nocopy boolean);
404 --
405 -- ----------------------------------------------------------------------------
406 -- |-----------------------------< create_employee >--------------------------|
407 -- ----------------------------------------------------------------------------
408 --
409 -- This version of the API is now out-of-date however it has been provided to
410 -- you for backward compatibility support and will be removed in the future.
411 -- Oracle recommends you to modify existing calling programs in advance of the
412 -- support being withdrawn thus avoiding any potential disruption.
413 --
414 PROCEDURE create_sg_employee
415 (p_validate in boolean default false
416 ,p_hire_date in date
417 ,p_business_group_id in number
418 ,p_last_name in varchar2
419 ,p_sex in varchar2
420 ,p_person_type_id in number default null
421 ,p_comments in varchar2 default null
422 ,p_date_employee_data_verified in date default null
423 ,p_date_of_birth in date default null
424 ,p_email_address in varchar2 default null
425 ,p_employee_number in out nocopy varchar2
426 ,p_expense_check_send_to_addres in varchar2 default null
427 ,p_first_name in varchar2 default null
428 ,p_known_as in varchar2 default null
429 ,p_marital_status in varchar2 default null
430 ,p_middle_names in varchar2 default null
431 ,p_nationality in varchar2 default null
432 ,p_national_identifier in varchar2 default null
433 ,p_previous_last_name in varchar2 default null
434 ,p_registered_disabled_flag in varchar2 default null
435 ,p_title in varchar2 default null
436 ,p_vendor_id in number default null
437 ,p_work_telephone in varchar2 default null
438 ,p_attribute_category in varchar2 default null
439 ,p_attribute1 in varchar2 default null
440 ,p_attribute2 in varchar2 default null
441 ,p_attribute3 in varchar2 default null
442 ,p_attribute4 in varchar2 default null
443 ,p_attribute5 in varchar2 default null
444 ,p_attribute6 in varchar2 default null
445 ,p_attribute7 in varchar2 default null
446 ,p_attribute8 in varchar2 default null
447 ,p_attribute9 in varchar2 default null
448 ,p_attribute10 in varchar2 default null
449 ,p_attribute11 in varchar2 default null
450 ,p_attribute12 in varchar2 default null
451 ,p_attribute13 in varchar2 default null
452 ,p_attribute14 in varchar2 default null
453 ,p_attribute15 in varchar2 default null
457 ,p_attribute19 in varchar2 default null
454 ,p_attribute16 in varchar2 default null
455 ,p_attribute17 in varchar2 default null
456 ,p_attribute18 in varchar2 default null
458 ,p_attribute20 in varchar2 default null
459 ,p_attribute21 in varchar2 default null
460 ,p_attribute22 in varchar2 default null
461 ,p_attribute23 in varchar2 default null
462 ,p_attribute24 in varchar2 default null
463 ,p_attribute25 in varchar2 default null
464 ,p_attribute26 in varchar2 default null
465 ,p_attribute27 in varchar2 default null
466 ,p_attribute28 in varchar2 default null
467 ,p_attribute29 in varchar2 default null
468 ,p_attribute30 in varchar2 default null
469 ,p_legal_name in varchar2
470 ,p_passport_number in varchar2 default null
471 ,p_passport_country_of_issue in varchar2 default null
472 ,p_passport_date_issued in date default null
473 ,p_passport_expiry_date in date default null
474 ,p_permit_type in varchar2
475 ,p_permit_number in varchar2 default null
476 ,p_permit_category in varchar2 default null
477 ,p_permit_date_issued in date default null
478 ,p_permit_expiry_date in date default null
479 ,p_permit_date_cancelled in date default null
480 ,p_income_tax_number in varchar2 default null
481 ,p_income_tax_number_spouse in varchar2 default null
482 ,p_cpf_account_number in varchar2 default null
483 ,p_nric_colour in varchar2 default null
484 ,p_religion in varchar2 default null
485 ,p_cpf_category in varchar2 default null
486 ,p_race in varchar2 default null
487 ,p_community_fund_category in varchar2
488 ,p_date_of_death in date default null
489 ,p_background_check_status in varchar2 default null
490 ,p_background_date_check in date default null
491 ,p_blood_type in varchar2 default null
492 ,p_correspondence_language in varchar2 default null
493 ,p_fast_path_employee in varchar2 default null
494 ,p_fte_capacity in number default null
495 ,p_honors in varchar2 default null
496 ,p_internal_location in varchar2 default null
497 ,p_last_medical_test_by in varchar2 default null
498 ,p_last_medical_test_date in date default null
499 ,p_mailstop in varchar2 default null
500 ,p_office_number in varchar2 default null
501 ,p_on_military_service in varchar2 default null
502 ,p_pre_name_adjunct in varchar2 default null
503 ,p_rehire_recommendation in varchar2 default null
504 ,p_projected_start_date in date default null
505 ,p_resume_exists in varchar2 default null
506 ,p_resume_last_updated in date default null
507 ,p_second_passport_exists in varchar2 default null
508 ,p_student_status in varchar2 default null
509 ,p_work_schedule in varchar2 default null
510 ,p_suffix in varchar2 default null
511 ,p_benefit_group_id in number default null
512 ,p_receipt_of_death_cert_date in date default null
513 ,p_coord_ben_med_pln_no in varchar2 default null
514 ,p_coord_ben_no_cvg_flag in varchar2 default 'N'
515 ,p_coord_ben_med_ext_er in varchar2 default null
516 ,p_coord_ben_med_pl_name in varchar2 default null
517 ,p_coord_ben_med_insr_crr_name in varchar2 default null
518 ,p_coord_ben_med_insr_crr_ident in varchar2 default null
519 ,p_coord_ben_med_cvg_strt_dt in date default null
520 ,p_coord_ben_med_cvg_end_dt in date default null
521 ,p_uses_tobacco_flag in varchar2 default null
522 ,p_dpdnt_adoption_date in date default null
523 ,p_dpdnt_vlntry_svce_flag in varchar2 default 'N'
524 ,p_original_date_of_hire in date default null
525 ,p_adjusted_svc_date in date default null
526 ,p_town_of_birth in varchar2 default null
527 ,p_region_of_birth in varchar2 default null
528 ,p_country_of_birth in varchar2 default null
529 ,p_global_person_id in varchar2 default null
530 ,p_party_id in number default null
531 ,p_payee_id_type in varchar2 default null
532 ,p_ee_er_rate in varchar2 default null/* 6393528*/
533 ,p_mbf in varchar2 default null/* 6393528*/
534 ,p_mdk in varchar2 default null/* 6393528*/
535 ,p_person_id out nocopy number
536 ,p_assignment_id out nocopy number
537 ,p_per_object_version_number out nocopy number
538 ,p_asg_object_version_number out nocopy number
542 ,p_per_comment_id out nocopy number
539 ,p_per_effective_start_date out nocopy date
540 ,p_per_effective_end_date out nocopy date
541 ,p_full_name out nocopy varchar2
543 ,p_assignment_sequence out nocopy number
544 ,p_assignment_number out nocopy varchar2
545 ,p_name_combination_warning out nocopy boolean
546 ,p_assign_payroll_warning out nocopy boolean);
547
548
549 END hr_sg_employee_api;