1 PACKAGE hr_cn_person_api AUTHID CURRENT_USER AS
2 /* $Header: hrcnwrpe.pkh 120.4 2011/12/20 12:07:30 jmarupil ship $ */
3 /*#
4 * This package contains an API for update of person details for China.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Person for China
8 */
9 g_trace boolean := false;
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-----------------------------< update_cn_person >-------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API updates the details of a person in business groups using the
18 * legislation for China.
19 *
20 * This API calls the generic update_person API. It maps certain columns to
21 * user-friendly names appropriate for China so as to ensure easy
22 * identification.As this API is an alternative API, see the generic
23 * update_person API for further explanation.
24 *
25 * <p><b>Licensing</b><br>
26 * This API is licensed for use with Human Resources.
27 *
28 * <p><b>Prerequisites</b><br>
29 * The person must exist at the effective date. The business group of the
30 * person must belong to Chinese legislation. See the corresponding generic API
31 * for further details.
32 *
33 * <p><b>Post Success</b><br>
34 * The details of the person will be updated.
35 *
36 * <p><b>Post Failure</b><br>
37 * The API does not update the person and raises an error.
38 * @param p_validate If true, then validation alone will be performed and the
39 * database will remain unchanged. If false and all validation checks pass,
40 * then the database will be modified.
41 * @param p_effective_date Determines when the DateTrack operation takes
42 * effect.
43 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
44 * updating the record. You must set to either UPDATE, CORRECTION,
45 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
46 * particular record depend on the dates of previous record changes and the
47 * effective date of this change.
48 * @param p_person_id Identifies the person record to modify.
49 * @param p_object_version_number Passes in the current version number of the
50 * person to be updated. When the API completes, if p_validate is false, this
51 * will be set to the new version number of the updated person. If p_validate
52 * is true, this will be set to the same value which was passed in.
53 * @param p_person_type_id {@rep:casecolumn PER_ALL_PEOPLE_F.PERSON_TYPE_ID}
54 * @param p_family_or_last_name {@rep:casecolumn PER_ALL_PEOPLE_F.LAST_NAME}
55 * @param p_applicant_number The business group's employee number generation
56 * method determines when you can update the person value. To keep the existing
57 * employee number pass in hr_api.g_varchar2. When the API call completes if
58 * p_validate is true then this will be set to the employee numb
59 * @param p_comments Person Comment Text
60 * @param p_date_employee_data_verified {@rep:casecolumn
61 * PER_ALL_PEOPLE_F.DATE_EMPLOYEE_DATA_VERIFIED}
62 * @param p_date_of_birth {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_BIRTH}
63 * @param p_email_address {@rep:casecolumn PER_ALL_PEOPLE_F.EMAIL_ADDRESS}
64 * @param p_employee_number The business group's employee number generation
65 * method determines when you can update the employee value. To keep the
66 * existing employee number pass in hr_api.g_varchar2. When the API call
67 * completes if p_validate is false then will be set to the employee nu
68 * @param p_expense_check_send_to_addres Address to which the expense should be
69 * sent. Valid values are determined by the 'HOME_OFFICE' lookup type.
70 * @param p_given_or_first_name {@rep:casecolumn PER_ALL_PEOPLE_F.FIRST_NAME}
71 * @param p_known_as {@rep:casecolumn PER_ALL_PEOPLE_F.KNOWN_AS}
72 * @param p_marital_status Marital status. Valid values are defined by
73 * 'MAR_STATUS' lookup type.
74 * @param p_middle_names {@rep:casecolumn PER_ALL_PEOPLE_F.MIDDLE_NAMES}
75 * @param p_nationality Nationality. Valid values are defined by the
76 * 'NATIONALITY' lookup type.
77 * @param p_citizen_identification_num {@rep:casecolumn
78 * PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER}
79 * @param p_previous_last_name {@rep:casecolumn
80 * PER_ALL_PEOPLE_F.PREVIOUS_LAST_NAME}
81 * @param p_registered_disabled_flag This flag indicates whether the person is
82 * classified as disabled. Valid values are defined by the
83 * 'REGISTERED_DISABLED' lookup type.
84 * @param p_sex Legal gender. Valid values are defined by the 'SEX' lookup
85 * type.
86 * @param p_title Title e.g. Mr, Mrs, Dr. Valid values are defined by the
87 * 'TITLE' lookup type.
88 * @param p_vendor_id {@rep:casecolumn PER_ALL_PEOPLE_F.VENDOR_ID}
89 * @param p_work_telephone {@rep:casecolumn PER_ALL_PEOPLE_F.WORK_TELEPHONE}
90 * @param p_attribute_category This context value determines which flexfield
91 * structure to use with the descriptive flexfield segments.
92 * @param p_attribute1 Descriptive flexfield segment.
93 * @param p_attribute2 Descriptive flexfield segment.
94 * @param p_attribute3 Descriptive flexfield segment.
95 * @param p_attribute4 Descriptive flexfield segment.
96 * @param p_attribute5 Descriptive flexfield segment.
97 * @param p_attribute6 Descriptive flexfield segment.
98 * @param p_attribute7 Descriptive flexfield segment.
99 * @param p_attribute8 Descriptive flexfield segment.
100 * @param p_attribute9 Descriptive flexfield segment.
101 * @param p_attribute10 Descriptive flexfield segment.
102 * @param p_attribute11 Descriptive flexfield segment.
103 * @param p_attribute12 Descriptive flexfield segment.
104 * @param p_attribute13 Descriptive flexfield segment.
105 * @param p_attribute14 Descriptive flexfield segment.
106 * @param p_attribute15 Descriptive flexfield segment.
107 * @param p_attribute16 Descriptive flexfield segment.
108 * @param p_attribute17 Descriptive flexfield segment.
109 * @param p_attribute18 Descriptive flexfield segment.
110 * @param p_attribute19 Descriptive flexfield segment.
111 * @param p_attribute20 Descriptive flexfield segment.
112 * @param p_attribute21 Descriptive flexfield segment.
113 * @param p_attribute22 Descriptive flexfield segment.
114 * @param p_attribute23 Descriptive flexfield segment.
115 * @param p_attribute24 Descriptive flexfield segment.
116 * @param p_attribute25 Descriptive flexfield segment.
117 * @param p_attribute26 Descriptive flexfield segment.
118 * @param p_attribute27 Descriptive flexfield segment.
119 * @param p_attribute28 Descriptive flexfield segment.
120 * @param p_attribute29 Descriptive flexfield segment.
121 * @param p_attribute30 Descriptive flexfield segment.
122 * @param p_hukou_type Hukou Type. Valid values are defined by the
123 * 'CN_HUKOU_TYPE' lookup type.
124 * @param p_hukou_location Hukou Location. Valid values are defined by the
125 * 'CN_HUKOU_LOCN' lookup type.
126 * @param p_highest_education_level Highest education level. Valid values are
127 * defined by the 'CN_HIGH_EDU_LEVEL' lookup type.
128 * @param p_number_of_children Number of children. This fields stores the
129 * number of children the person has. Valid values are whole numbers.
130 * @param p_expatriate_indicator This indicates if the person is an expatriate.
131 * Valid values are defined by the 'YES_NO' lookup type.
132 * @param p_health_status Health status details for the person. Valid values
133 * are defined by the 'CN_HEALTH_STATUS' lookup type.
134 * @param p_tax_exemption_indicator This indicates if the person is entitled to
135 * a tax exemption. Valid values are defined by the 'YES_NO' lookup type.
136 * @param p_percentage This indicates the tax exemption percentage. This
137 * determines the percentage of Special Tax Exemption based on the Tax
138 * Exemption Indicator. If left blank this would default to a global value
139 * defined by MOLSS, as per the current tax regulations.
140 * @param p_family_han_yu_pin_yin_name Han Yu Pin Yin Last Name as specified on
141 * the Passport for Chinese residents.
142 * @param p_given_han_yu_pin_yin_name Han Yu Pin Yin First Name as specified on
143 * the Passport for Chinese residents.
144 * @param p_previous_name Previous name of the person, in cases of a change in
145 * name.
146 * @param p_race_ethnic_orgin Race ethnic origin details for the person. Valid
147 * values are defined by the 'CN_RACE' lookup type.
148 * @param p_social_security_ic_number Social security identification number for
149 * the person.
150 * @param p_date_of_death {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_DEATH}
151 * @param p_background_check_status Background check status. Valid values are
152 * defined by the 'YES_NO' lookup type.
153 * @param p_background_date_check {@rep:casecolumn
154 * PER_ALL_PEOPLE_F.BACKGROUND_DATE_CHECK}
155 * @param p_blood_type Indicates the blood type of the person. Valid values are
156 * defined by the 'BLOOD_TYPE' lookup type.
157 * @param p_correspondence_language {@rep:casecolumn
158 * PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE}
159 * @param p_fast_path_employee {@rep:casecolumn
160 * PER_ALL_PEOPLE_F.FAST_PATH_EMPLOYEE}
161 * @param p_fte_capacity {@rep:casecolumn PER_ALL_PEOPLE_F.FTE_CAPACITY}
162 * @param p_hold_applicant_date_until {@rep:casecolumn
163 * PER_ALL_PEOPLE_F.HOLD_APPLICANT_DATE_UNTIL}
164 * @param p_honors {@rep:casecolumn PER_ALL_PEOPLE_F.HONORS}
165 * @param p_internal_location {@rep:casecolumn
166 * PER_ALL_PEOPLE_F.INTERNAL_LOCATION}
167 * @param p_last_medical_test_by {@rep:casecolumn
168 * PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_BY}
169 * @param p_last_medical_test_date {@rep:casecolumn
170 * PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_DATE}
171 * @param p_mailstop {@rep:casecolumn PER_ALL_PEOPLE_F.MAILSTOP}
172 * @param p_office_number {@rep:casecolumn PER_ALL_PEOPLE_F.OFFICE_NUMBER}
173 * @param p_on_military_service On military service. Valid values are defined
174 * by 'YES_NO' lookup type.
175 * @param p_pre_name_adjunct Prefix for the person name
176 * @param p_projected_start_date {@rep:casecolumn
177 * PER_ALL_PEOPLE_F.PROJECTED_START_DATE}
178 * @param p_rehire_authorizor {@rep:casecolumn
179 * PER_ALL_PEOPLE_F.REHIRE_AUTHORIZOR}
180 * @param p_rehire_recommendation {@rep:casecolumn
181 * PER_ALL_PEOPLE_F.REHIRE_RECOMMENDATION}
182 * @param p_resume_exists Indicates if a resume exists for the person. Valid
183 * values are defined by the 'YES_NO' lookup type.
184 * @param p_resume_last_updated {@rep:casecolumn
185 * PER_ALL_PEOPLE_F.RESUME_LAST_UPDATED}
186 * @param p_second_passport_exists Indicates if a second passport is available
187 * for the person. Valid values are defined by the 'YES_NO' lookup type.
188 * @param p_student_status Indicates the student status of the applicant. Valid
189 * values are defined by the 'STUDENT_STATUS' lookup type.
190 * @param p_work_schedule Work schedule. Valid values are defined by the
191 * 'WORK_SCHEDULE' lookup type.
192 * @param p_rehire_reason {@rep:casecolumn PER_ALL_PEOPLE_F.REHIRE_REASON}
193 * @param p_suffix Suffix for the person name
194 * @param p_benefit_group_id {@rep:casecolumn
195 * PER_ALL_PEOPLE_F.BENEFIT_GROUP_ID}
196 * @param p_receipt_of_death_cert_date {@rep:casecolumn
197 * PER_ALL_PEOPLE_F.RECEIPT_OF_DEATH_CERT_DATE}
198 * @param p_coord_ben_med_pln_no {@rep:casecolumn
199 * PER_ALL_PEOPLE_F.COORD_BEN_MED_PLN_NO}
200 * @param p_coord_ben_no_cvg_flag Coordination of benefits no other coverage
201 * flag. Valid values are defined by the 'YES_NO' lookup type.
202 * @param p_coord_ben_med_ext_er {@rep:casecolumn
203 * PER_ALL_PEOPLE_F.COORD_BEN_MED_EXT_ER}
204 * @param p_coord_ben_med_pl_name {@rep:casecolumn
205 * PER_ALL_PEOPLE_F.COORD_BEN_MED_PL_NAME}
206 * @param p_coord_ben_med_insr_crr_name {@rep:casecolumn
207 * PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME}
208 * @param p_coord_ben_med_insr_crr_ident {@rep:casecolumn
209 * PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_IDENT}
210 * @param p_coord_ben_med_cvg_strt_dt {@rep:casecolumn
211 * PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT}
212 * @param p_coord_ben_med_cvg_end_dt {@rep:casecolumn
213 * PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT}
214 * @param p_uses_tobacco_flag Indicates if the person uses tabacco. Valid
215 * values are defined by the 'YES_NO' lookup type.
216 * @param p_dpdnt_adoption_date {@rep:casecolumn
217 * PER_ALL_PEOPLE_F.DPDNT_ADOPTION_DATE}
218 * @param p_dpdnt_vlntry_svce_flag Indicates if the person has any dependents
219 * on voluntary service. Valid values are defined by the 'YES_NO' lookup type.
220 * @param p_original_date_of_hire {@rep:casecolumn
221 * PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE}
222 * @param p_adjusted_svc_date {@rep:casecolumn
223 * PER_PERIODS_OF_SERVICE.ADJUSTED_SVC_DATE}
224 * @param p_town_of_birth Indicates town of birth
225 * @param p_region_of_birth Indicates region of birth
226 * @param p_country_of_birth Indicates the country of birth of Person. Valid
227 * values are defined by the view FND_TERRITORIES_VL
228 * @param p_global_person_id Global Person Id
229 * @param p_party_id Party for whom the address applies.
230 * @param p_npw_number {@rep:casecolumn PER_ALL_PEOPLE_F.NPW_NUMBER}
231 * @param p_effective_start_date If p_validate is false, then set to the
232 * effective start date on the updated person row which now exists as of the
233 * effective date. If p_validate is true, then set to null.
234 * @param p_effective_end_date If p_validate is false, then set to the
235 * effective end date on the updated person row which now exists as of the
236 * effective date. If p_validate is true, then set to null.
237 * @param p_full_name If p_validate is false, set to the complete full name of
238 * the person. If p_validate is true, set to null.
239 * @param p_comment_id If p_validate is false and new or existing comment text
240 * exists, then will be set to the identifier of the person comment record. If
241 * p_validate is true or no comment text exists, then will be null.
242 * @param p_name_combination_warning If set to true, then the combination of
243 * last name, first name and date of birth existed prior to calling this API.
244 * @param p_assign_payroll_warning If set to true, then the date of birth is
245 * not entered. If set to false, then the date of birth has been entered.
246 * Indicates if it will be possible to set the payroll on any of this person's
247 * assignments.
248 * @param p_orig_hire_warning If p_validate is false, this will be set if an
249 * warnings exists. If p_validate is true this will be null.
250 * @rep:displayname Update Person for China
251 * @rep:category BUSINESS_ENTITY HR_PERSON
252 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
253 * @rep:scope public
254 * @rep:lifecycle active
255 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
256 */
257 --
258 -- {End Of Comments}
259 --
260 PROCEDURE update_cn_person
261 ( p_validate IN BOOLEAN DEFAULT false
262 ,p_effective_date IN DATE
263 ,p_datetrack_update_mode IN VARCHAR2
264 ,p_person_id IN NUMBER
265 ,p_object_version_number IN OUT NOCOPY NUMBER
266 ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
267 ,p_family_or_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
268 ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
269 ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
270 ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
271 ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
272 ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
273 ,p_employee_number IN OUT NOCOPY VARCHAR2
274 ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
275 ,p_given_or_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
276 ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
277 ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
278 ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
279 ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
280 ,p_citizen_identification_num IN VARCHAR2 DEFAULT hr_api.g_varchar2
281 ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
282 ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
283 ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
284 ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
285 ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
286 ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
287 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
288 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
289 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
290 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
291 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
292 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
296 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
297 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
298 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
299 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
300 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
301 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
302 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
303 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
304 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
305 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308 ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
309 ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
310 ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
311 ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
312 ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313 ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314 ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315 ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
316 ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317 ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318 ,p_hukou_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
319 ,p_hukou_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
320 ,p_highest_education_level IN VARCHAR2 DEFAULT hr_api.g_varchar2
321 ,p_number_of_children IN VARCHAR2 DEFAULT hr_api.g_varchar2
322 ,p_expatriate_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
323 ,p_health_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
324 ,p_tax_exemption_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
325 ,p_percentage IN VARCHAR2 DEFAULT hr_api.g_varchar2
326 ,p_family_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
327 ,p_given_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
328 ,p_previous_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
329 ,p_race_ethnic_orgin IN VARCHAR2 DEFAULT hr_api.g_varchar2
330 ,p_social_security_ic_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
331 ,p_date_of_death IN DATE DEFAULT hr_api.g_date
332 ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
333 ,p_background_date_check IN DATE DEFAULT hr_api.g_date
334 ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
335 ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
336 ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
337 ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
338 ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
339 ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
340 ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
341 ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
342 ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
343 ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
344 ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
345 ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
346 ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
347 ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
348 ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
349 ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
350 ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
351 ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
352 ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
353 ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
354 ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
355 ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
356 ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
357 ,p_benefit_group_id IN NUMBER DEFAULT hr_api.g_number
358 ,p_receipt_of_death_cert_date IN DATE DEFAULT hr_api.g_date
359 ,p_coord_ben_med_pln_no IN VARCHAR2 DEFAULT hr_api.g_varchar2
360 ,p_coord_ben_no_cvg_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
361 ,p_coord_ben_med_ext_er IN VARCHAR2 DEFAULT hr_api.g_varchar2
362 ,p_coord_ben_med_pl_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
363 ,p_coord_ben_med_insr_crr_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
364 ,p_coord_ben_med_insr_crr_ident IN VARCHAR2 DEFAULT hr_api.g_varchar2
365 ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT hr_api.g_date
366 ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT hr_api.g_date
367 ,p_uses_tobacco_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
368 ,p_dpdnt_adoption_date IN DATE DEFAULT hr_api.g_date
369 ,p_dpdnt_vlntry_svce_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
370 ,p_original_date_of_hire IN DATE DEFAULT hr_api.g_date
371 ,p_adjusted_svc_date IN DATE DEFAULT hr_api.g_date
372 ,p_town_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
373 ,p_region_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
374 ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
375 ,p_global_person_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
376 ,p_party_id IN NUMBER DEFAULT hr_api.g_number
377 ,p_npw_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
378 --
379 ,p_effective_start_date OUT NOCOPY DATE
380 ,p_effective_end_date OUT NOCOPY DATE
381 ,p_full_name OUT NOCOPY VARCHAR2
382 ,p_comment_id OUT NOCOPY NUMBER
383 ,p_name_combination_warning OUT NOCOPY BOOLEAN
384 ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
385 ,p_orig_hire_warning OUT NOCOPY BOOLEAN );
386 --
387 END hr_cn_person_api;
[Home] [Help]