DBA Data[Home] [Help]

PACKAGE: APPS.HR_NZ_PERSON_API

Source


1 PACKAGE hr_nz_person_api AUTHID CURRENT_USER AS
2 /* $Header: hrnzwrup.pkh 120.4 2011/12/21 08:13:44 jmarupil ship $ */
3 /*#
4  * This package contains API for updation of Person details.
5  * @rep:scope public
6  * @rep:product per
7  * @rep:displayname Person for New Zealand
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------------< update_nz_person >-------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16  * This API updates the person record for New Zealand.
17  *
18  * The details of the person for whom the details have to be updated is
19  * identified by using the person_id and object_version_number for the record.
20  *
21  * <p><b>Licensing</b><br>
22  * This API is licensed for use with Human Resources.
23  *
24  * <p><b>Prerequisites</b><br>
25  * The person record and object version number should already exist.
26  *
27  * <p><b>Post Success</b><br>
28  * Successfully updates the details of the person.
29  *
30  * <p><b>Post Failure</b><br>
31  * The API will not update the person and raises an error.
32  * @param p_validate If true, then validation alone will be performed and the
33  * database will remain unchanged. If false and all validation checks pass,
34  * then the database will be modified.
35  * @param p_effective_date Determines when the DateTrack operation takes
36  * effect.
37  * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
38  * updating the record. You must set to either UPDATE, CORRECTION,
39  * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
40  * particular record depend on the dates of previous record changes and the
41  * effective date of this change.
42  * @param p_person_id Identifies the person record to modify.
43  * @param p_object_version_number Pass in the current version number of the
44  * person to be updated. When the API completes if p_validate is false, will be
45  * set to the new version number of the updated person. If p_validate is true
46  * will be set to the same value which was passed in.
47  * @param p_person_type_id {@rep:casecolumn PER_ALL_PEOPLE_F.PERSON_TYPE_ID}
48  * @param p_last_name {@rep:casecolumn PER_ALL_PEOPLE_F.LAST_NAME}
49  * @param p_applicant_number {@rep:casecolumn
50  * PER_ALL_PEOPLE_F.APPLICANT_NUMBER}
51  * @param p_comments Comment text.
52  * @param p_date_employee_data_verified {@rep:casecolumn
53  * PER_ALL_PEOPLE_F.DATE_EMPLOYEE_DATA_VERIFIED}
54  * @param p_date_of_birth {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_BIRTH}
55  * @param p_email_address {@rep:casecolumn PER_ALL_PEOPLE_F.EMAIL_ADDRESS}
56  * @param p_employee_number The business group's employee number generation
57  * method determines when the API derives and passes out an employee number or
58  * when the calling program should pass in a value. When the API call completes
59  * if p_validate is false then will be set to the employee number. If
60  * p_validate is true then will be set to the passed value.
61  * @param p_expense_check_send_to_addres Person's Address to which the expense
62  * should be sent. Valid values are determined by 'HOME_OFFICE' lookup type.
63  * @param p_first_name {@rep:casecolumn PER_ALL_PEOPLE_F.FIRST_NAME}
64  * @param p_known_as {@rep:casecolumn PER_ALL_PEOPLE_F.KNOWN_AS}
65  * @param p_marital_status Indicates the Person's Marital status. Valid values
66  * are defined by 'MAR_STATUS' lookup type.
67  * @param p_middle_names {@rep:casecolumn PER_ALL_PEOPLE_F.MIDDLE_NAMES}
68  * @param p_nationality Indicates the Person's Nationality. Valid values are
69  * defined by 'NATIONALITY' lookup type.
70  * @param p_ird_number {@rep:casecolumn 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 Indicates whether person is classified as
74  * disabled. Valid values are defined by 'REGISTERED_DISABLED' lookup type.
75  * @param p_sex Indicates the Person's Legal gender. Valid values are defined
76  * by 'SEX' lookup type.
77  * @param p_title Person's Title e.g. Mr, Mrs, Dr. Valid values are defined by
78  * 'TITLE' lookup type.
79  * @param p_vendor_id {@rep:casecolumn PER_ALL_PEOPLE_F.VENDOR_ID}
80  * @param p_work_telephone {@rep:casecolumn PER_ALL_PEOPLE_F.WORK_TELEPHONE}
81  * @param p_attribute_category This context value determines which flexfield
82  * structure to use with the descriptive flexfield segments.
83  * @param p_attribute1 Descriptive flexfield segment.
84  * @param p_attribute2 Descriptive flexfield segment.
85  * @param p_attribute3 Descriptive flexfield segment.
86  * @param p_attribute4 Descriptive flexfield segment.
87  * @param p_attribute5 Descriptive flexfield segment.
88  * @param p_attribute6 Descriptive flexfield segment.
89  * @param p_attribute7 Descriptive flexfield segment.
90  * @param p_attribute8 Descriptive flexfield segment.
91  * @param p_attribute9 Descriptive flexfield segment.
92  * @param p_attribute10 Descriptive flexfield segment.
93  * @param p_attribute11 Descriptive flexfield segment.
94  * @param p_attribute12 Descriptive flexfield segment.
95  * @param p_attribute13 Descriptive flexfield segment.
96  * @param p_attribute14 Descriptive flexfield segment.
97  * @param p_attribute15 Descriptive flexfield segment.
98  * @param p_attribute16 Descriptive flexfield segment.
99  * @param p_attribute17 Descriptive flexfield segment.
100  * @param p_attribute18 Descriptive flexfield segment.
101  * @param p_attribute19 Descriptive flexfield segment.
102  * @param p_attribute20 Descriptive flexfield segment.
103  * @param p_attribute21 Descriptive flexfield segment.
104  * @param p_attribute22 Descriptive flexfield segment.
105  * @param p_attribute23 Descriptive flexfield segment.
106  * @param p_attribute24 Descriptive flexfield segment.
107  * @param p_attribute25 Descriptive flexfield segment.
108  * @param p_attribute26 Descriptive flexfield segment.
109  * @param p_attribute27 Descriptive flexfield segment.
110  * @param p_attribute28 Descriptive flexfield segment.
111  * @param p_attribute29 Descriptive flexfield segment.
112  * @param p_attribute30 Descriptive flexfield segment.
113  * @param p_country_born Indicates the country of birth of Person. Valid values
114  * are defined by the view FND_TERRITORIES_VL
115  * @param p_work_permit_number Identifies the person by the 7 digit work permit
116  * number
117  * @param p_work_permit_expiry_date Indicates the Person's work permit expiry
118  * date
119  * @param p_ethnic_origin Indicates the Person's ethnic origin. Valid values
120  * are defined by 'NZ_ETHNIC_ORIGIN' lookup type.
121  * @param p_tribal_group Indicates the Person's tribal group. Valid values are
122  * defined by 'NZ_TRIBAL_GROUP' lookup type.
123  * @param p_district_of_origin Indicates the Person's district of origin. Valid
124  * values are defined by 'NZ_DISTRICT_OF_ORIGIN' lookup type.
125  * @param p_employment_category Statistics New Zealand employment category.
126  * Valid values are defined by 'NZ_STATS_NZ_EMP_CAT' lookup type.
127  * @param p_working_time Statistics New Zealand working time. Valid values are
128  * defined by 'NZ_STATS_NZ_WORKING_TIME' lookup type.
129  * @param p_date_of_death {@rep:casecolumn PER_ALL_PEOPLE_F.DATE_OF_DEATH}
130  * @param p_background_check_status Indicates the Background check status of
131  * the person. Valid values as applicable are defined by 'YES_NO' lookup type.
132  * @param p_background_date_check {@rep:casecolumn
133  * PER_ALL_PEOPLE_F.BACKGROUND_DATE_CHECK}
134  * @param p_blood_type Identifies the person's Blood Group. Valid values are
135  * defined by 'BLOOD_TYPE' lookup type.
136  * @param p_correspondence_language {@rep:casecolumn
137  * PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE}
138  * @param p_fast_path_employee {@rep:casecolumn
139  * PER_ALL_PEOPLE_F.FAST_PATH_EMPLOYEE}
140  * @param p_fte_capacity {@rep:casecolumn PER_ALL_PEOPLE_F.FTE_CAPACITY}
141  * @param p_hold_applicant_date_until {@rep:casecolumn
142  * PER_ALL_PEOPLE_F.HOLD_APPLICANT_DATE_UNTIL}
143  * @param p_honors {@rep:casecolumn PER_ALL_PEOPLE_F.HONORS}
144  * @param p_internal_location {@rep:casecolumn
145  * PER_ALL_PEOPLE_F.INTERNAL_LOCATION}
146  * @param p_last_medical_test_by {@rep:casecolumn
147  * PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_BY}
148  * @param p_last_medical_test_date {@rep:casecolumn
149  * PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_DATE}
150  * @param p_mailstop {@rep:casecolumn PER_ALL_PEOPLE_F.MAILSTOP}
151  * @param p_office_number {@rep:casecolumn PER_ALL_PEOPLE_F.OFFICE_NUMBER}
152  * @param p_on_military_service Indicates whether the person was in the
153  * military service. Valid values as applicable are defined by 'YES_NO' lookup
154  * type.
155  * @param p_pre_name_adjunct {@rep:casecolumn
156  * PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT}
157  * @param p_projected_start_date {@rep:casecolumn
158  * PER_ALL_PEOPLE_F.PROJECTED_START_DATE}
159  * @param p_rehire_authorizor {@rep:casecolumn
160  * PER_ALL_PEOPLE_F.REHIRE_AUTHORIZOR}
161  * @param p_rehire_recommendation Indicates the person's Re-hire recommendation
162  * details. Valid values as applicable are defined by 'YES_NO' lookup type.
163  * @param p_resume_exists Indicates whether the person's Resume already exists
164  * in the database. Valid values as applicable are defined by 'YES_NO' lookup
165  * type.
166  * @param p_resume_last_updated {@rep:casecolumn
167  * PER_ALL_PEOPLE_F.RESUME_LAST_UPDATED}
168  * @param p_second_passport_exists Indicates the availability of the Person's
169  * Second passport. Valid values as applicable are defined by 'YES_NO' lookup
170  * type.
171  * @param p_student_status Indicates the student status of the Person. Valid
172  * values as applicable are defined by 'STUDENT_STATUS' lookup type.
173  * @param p_work_schedule Indicates the person's Work schedule. Valid values
174  * are defined by 'WORK_SCHEDULE' lookup type.
175  * @param p_rehire_reason {@rep:casecolumn PER_ALL_PEOPLE_F.REHIRE_REASON}
176  * @param p_suffix {@rep:casecolumn PER_ALL_PEOPLE_F.SUFFIX}
177  * @param p_benefit_group_id {@rep:casecolumn
178  * PER_ALL_PEOPLE_F.BENEFIT_GROUP_ID}
179  * @param p_receipt_of_death_cert_date {@rep:casecolumn
180  * PER_ALL_PEOPLE_F.RECEIPT_OF_DEATH_CERT_DATE}
181  * @param p_coord_ben_med_pln_no {@rep:casecolumn
182  * PER_ALL_PEOPLE_F.COORD_BEN_MED_PLN_NO}
183  * @param p_coord_ben_no_cvg_flag Indicates whether the person has any coverage
184  * other than the Coordination of benefits. Valid values as applicable are
185  * defined by 'YES_NO' lookup type.
186  * @param p_coord_ben_med_ext_er Secondary external medical coverage. Column
187  * used for external processing.
188  * @param p_coord_ben_med_pl_name Secondary medical coverage name. Column used
189  * for external processing.
190  * @param p_coord_ben_med_insr_crr_name Secondary medical coverage insurance
191  * carrier name. Column used for external processing.
192  * @param p_coord_ben_med_insr_crr_ident Secondary medical coverage insurance
193  * carrier identifier. Column used for external processing.
194  * @param p_coord_ben_med_cvg_strt_dt Secondary medical coverage effective
195  * start date. Column used for external processing.
196  * @param p_coord_ben_med_cvg_end_dt Secondary medical coverage effective end
197  * date. Column used for external processing.
198  * @param p_uses_tobacco_flag Indicates whether the person uses tabacco. Valid
199  * values as applicable are defined by 'YES_NO' lookup type.
200  * @param p_dpdnt_adoption_date {@rep:casecolumn
201  * PER_ALL_PEOPLE_F.DPDNT_ADOPTION_DATE}
202  * @param p_dpdnt_vlntry_svce_flag Indicates whether the person was in the
203  * dependent voluntary service. Valid values are defined by 'YES_NO' lookup
204  * type.
205  * @param p_original_date_of_hire {@rep:casecolumn
206  * PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE}
207  * @param p_adjusted_svc_date {@rep:casecolumn
208  * PER_PERIODS_OF_SERVICE.ADJUSTED_SVC_DATE}
209  * @param p_town_of_birth Town or city of birth.
210  * @param p_region_of_birth Geographical region of birth.
211  * @param p_country_of_birth Country of birth.
212  * @param p_global_person_id Obsolete parameter, do not use.
213  * @param p_party_id TCA party for whom you are modifying the person record.
214  * @param p_npw_number The business group's contingent worker number generation
215  * @param p_effective_start_date If p_validate is false, then set to the
216  * effective start date on the updated person row which now exists as of the
217  * effective date. If p_validate is true, then set to null.
218  * @param p_effective_end_date If p_validate is false, then set to the
219  * effective end date on the updated person row which now exists as of the
220  * effective date. If p_validate is true, then set to null.
221  * @param p_full_name If p_validate is false, then set to the full name of the
222  * person. If p_validate is true, then set to null.
223  * @param p_comment_id If p_validate is false and new or existing comment text
224  * exists, then will be set to the identifier of the person comment record. If
225  * p_validate is true or no comment text exists, then will be null.
226  * @param p_name_combination_warning If set to true, then the combination of
227  * last name, first name and date of birth existed prior to calling this API.
228  * @param p_assign_payroll_warning If set to true, then the date of birth is
229  * not entered. If set to false, then the date of birth has been entered.
230  * Indicates if it will be possible to set the payroll on any of this person's
231  * assignments.
232  * @param p_orig_hire_warning If p_validate is false, the original date of hire
233  * is provided and the person type is not
234  * Employee,Employee-Applicant,Ex-Employee or Ex-Employee Applicant, then set
235  * to true.
236  * @rep:displayname Update Person details for New Zealand
237  * @rep:category BUSINESS_ENTITY HR_PERSON
238  * @rep:category MISC_EXTENSIONS HR_DATAPUMP
239  * @rep:scope public
240  * @rep:lifecycle active
241  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
242 */
243 --
244 -- {End Of Comments}
245 --
246 PROCEDURE update_nz_person
247   (p_validate                     IN      BOOLEAN   DEFAULT FALSE
248   ,p_effective_date               IN      DATE
249   ,p_datetrack_update_mode        IN      VARCHAR2
250   ,p_person_id                    IN      NUMBER
251   ,p_object_version_number        IN OUT NOCOPY NUMBER
252   ,p_person_type_id               IN      NUMBER   DEFAULT hr_api.g_number
253   ,p_last_name                    IN      VARCHAR2 DEFAULT hr_api.g_varchar2
254   ,p_applicant_number             IN      VARCHAR2 DEFAULT hr_api.g_varchar2
255   ,p_comments                     IN      hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
256   ,p_date_employee_data_verified  IN      DATE     DEFAULT hr_api.g_date
257   ,p_date_of_birth                IN      DATE     DEFAULT hr_api.g_date
258   ,p_email_address                IN      VARCHAR2 DEFAULT hr_api.g_varchar2
259   ,p_employee_number              IN OUT NOCOPY VARCHAR2
260   ,p_expense_check_send_to_addres IN      VARCHAR2 DEFAULT hr_api.g_varchar2
261   ,p_first_name                   IN      VARCHAR2 DEFAULT hr_api.g_varchar2
262   ,p_known_as                     IN      VARCHAR2 DEFAULT hr_api.g_varchar2
263   ,p_marital_status               IN      VARCHAR2 DEFAULT hr_api.g_varchar2
264   ,p_middle_names                 IN      VARCHAR2 DEFAULT hr_api.g_varchar2
265   ,p_nationality                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
266   ,p_ird_number                   IN      VARCHAR2 DEFAULT hr_api.g_varchar2
267   ,p_previous_last_name           IN      VARCHAR2 DEFAULT hr_api.g_varchar2
268   ,p_registered_disabled_flag     IN      VARCHAR2 DEFAULT hr_api.g_varchar2
269   ,p_sex                          IN      VARCHAR2 DEFAULT hr_api.g_varchar2
270   ,p_title                        IN      VARCHAR2 DEFAULT hr_api.g_varchar2
271   ,p_vendor_id                    IN      NUMBER   DEFAULT hr_api.g_number
272   ,p_work_telephone               IN      VARCHAR2 DEFAULT hr_api.g_varchar2
273   ,p_attribute_category           IN      VARCHAR2 DEFAULT hr_api.g_varchar2
274   ,p_attribute1                   IN      VARCHAR2 DEFAULT hr_api.g_varchar2
275   ,p_attribute2                   IN      VARCHAR2 DEFAULT hr_api.g_varchar2
276   ,p_attribute3                   IN      VARCHAR2 DEFAULT hr_api.g_varchar2
277   ,p_attribute4                   IN      VARCHAR2 DEFAULT hr_api.g_varchar2
278   ,p_attribute5                   IN      VARCHAR2 DEFAULT hr_api.g_varchar2
279   ,p_attribute6                   IN      VARCHAR2 DEFAULT hr_api.g_varchar2
280   ,p_attribute7                   IN      VARCHAR2 DEFAULT hr_api.g_varchar2
281   ,p_attribute8                   IN      VARCHAR2 DEFAULT hr_api.g_varchar2
282   ,p_attribute9                   IN      VARCHAR2 DEFAULT hr_api.g_varchar2
283   ,p_attribute10                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
284   ,p_attribute11                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
285   ,p_attribute12                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
286   ,p_attribute13                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
287   ,p_attribute14                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
288   ,p_attribute15                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
289   ,p_attribute16                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
290   ,p_attribute17                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
291   ,p_attribute18                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
292   ,p_attribute19                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
293   ,p_attribute20                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
294   ,p_attribute21                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
295   ,p_attribute22                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
296   ,p_attribute23                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
297   ,p_attribute24                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
298   ,p_attribute25                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
299   ,p_attribute26                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
300   ,p_attribute27                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
301   ,p_attribute28                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
302   ,p_attribute29                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
303   ,p_attribute30                  IN      VARCHAR2 DEFAULT hr_api.g_varchar2
304   ,p_country_born                 IN      VARCHAR2 DEFAULT hr_api.g_varchar2
305   ,p_work_permit_number           IN      VARCHAR2 DEFAULT hr_api.g_varchar2
306   ,p_work_permit_expiry_date      IN      VARCHAR2 DEFAULT hr_api.g_varchar2
307   ,p_ethnic_origin                IN      VARCHAR2 DEFAULT hr_api.g_varchar2
308   ,p_tribal_group                 IN      VARCHAR2 DEFAULT hr_api.g_varchar2
309   ,p_district_of_origin           IN      VARCHAR2 DEFAULT hr_api.g_varchar2
310   ,p_employment_category          IN      VARCHAR2 DEFAULT hr_api.g_varchar2
311   ,p_working_time                 IN      VARCHAR2 DEFAULT hr_api.g_varchar2
312   ,p_date_of_death                IN      DATE     DEFAULT hr_api.g_date
313   ,p_background_check_status      IN      VARCHAR2 DEFAULT hr_api.g_varchar2
314   ,p_background_date_check        IN      DATE     DEFAULT hr_api.g_date
315   ,p_blood_type                   IN      VARCHAR2 DEFAULT hr_api.g_varchar2
316   ,p_correspondence_language      IN      VARCHAR2 DEFAULT hr_api.g_varchar2
317   ,p_fast_path_employee           IN      VARCHAR2 DEFAULT hr_api.g_varchar2
318   ,p_fte_capacity                 IN      NUMBER   DEFAULT hr_api.g_number
319   ,p_hold_applicant_date_until    IN      DATE     DEFAULT hr_api.g_date
320   ,p_honors                       IN      VARCHAR2 DEFAULT hr_api.g_varchar2
321   ,p_internal_location            IN      VARCHAR2 DEFAULT hr_api.g_varchar2
322   ,p_last_medical_test_by         IN      VARCHAR2 DEFAULT hr_api.g_varchar2
323   ,p_last_medical_test_date       IN      DATE     DEFAULT hr_api.g_date
324   ,p_mailstop                     IN      VARCHAR2 DEFAULT hr_api.g_varchar2
325   ,p_office_number                IN      VARCHAR2 DEFAULT hr_api.g_varchar2
326   ,p_on_military_service          IN      VARCHAR2 DEFAULT hr_api.g_varchar2
327   ,p_pre_name_adjunct             IN      VARCHAR2 DEFAULT hr_api.g_varchar2
328   ,p_projected_start_date         IN      DATE     DEFAULT hr_api.g_date
329   ,p_rehire_authorizor            IN      VARCHAR2 DEFAULT hr_api.g_varchar2
330   ,p_rehire_recommendation        IN      VARCHAR2 DEFAULT hr_api.g_varchar2
331   ,p_resume_exists                IN      VARCHAR2 DEFAULT hr_api.g_varchar2
332   ,p_resume_last_updated          IN      DATE     DEFAULT hr_api.g_date
333   ,p_second_passport_exists       IN      VARCHAR2 DEFAULT hr_api.g_varchar2
334   ,p_student_status               IN      VARCHAR2 DEFAULT hr_api.g_varchar2
335   ,p_work_schedule                IN      VARCHAR2 DEFAULT hr_api.g_varchar2
336   ,p_rehire_reason                IN      VARCHAR2 DEFAULT hr_api.g_varchar2
337   ,p_suffix                       IN      VARCHAR2 DEFAULT hr_api.g_varchar2
338   ,p_benefit_group_id             in      number   default hr_api.g_number
339   ,p_receipt_of_death_cert_date   in      date     default hr_api.g_date
340   ,p_coord_ben_med_pln_no         in      VARCHAR2  DEFAULT hr_api.g_varchar2
341   ,p_coord_ben_no_cvg_flag        in      varchar2 default hr_api.g_varchar2
342   ,p_coord_ben_med_ext_er         in      varchar2 default hr_api.g_varchar2
343   ,p_coord_ben_med_pl_name        in      varchar2 default hr_api.g_varchar2
344   ,p_coord_ben_med_insr_crr_name  in      varchar2 default hr_api.g_varchar2
345   ,p_coord_ben_med_insr_crr_ident in      varchar2 default hr_api.g_varchar2
346   ,p_coord_ben_med_cvg_strt_dt    in      date     default hr_api.g_date
347   ,p_coord_ben_med_cvg_end_dt     in      date     default hr_api.g_date
348   ,p_uses_tobacco_flag            in      varchar2 default hr_api.g_varchar2
349   ,p_dpdnt_adoption_date          in      date     default hr_api.g_date
350   ,p_dpdnt_vlntry_svce_flag       in      varchar2 default hr_api.g_varchar2
351   ,p_original_date_of_hire        in      date     default hr_api.g_date
352   ,p_adjusted_svc_date            in      date     default hr_api.g_date
353   ,p_town_of_birth                in      varchar2 default hr_api.g_varchar2
354   ,p_region_of_birth              in      varchar2 default hr_api.g_varchar2
355   ,p_country_of_birth             in      varchar2 default hr_api.g_varchar2
356   ,p_global_person_id             in      varchar2 default hr_api.g_varchar2
357   ,p_party_id                     in      number   default hr_api.g_number
358   ,p_npw_number                   in      varchar2 default hr_api.g_varchar2
359   ,p_effective_start_date         OUT NOCOPY    DATE
360   ,p_effective_end_date           OUT NOCOPY    DATE
361   ,p_full_name                    OUT NOCOPY    VARCHAR2
362   ,p_comment_id                   OUT NOCOPY    NUMBER
363   ,p_name_combination_warning     OUT NOCOPY    BOOLEAN
364   ,p_assign_payroll_warning       OUT NOCOPY    BOOLEAN
365   ,p_orig_hire_warning            OUT NOCOPY    BOOLEAN
366   );
367   END hr_nz_person_api;