1 Package hr_in_person_extra_info_api AS
2 /* $Header: pepeiini.pkh 120.1 2005/10/02 02:43 aroussel $ */
3 /*#
4 * This package contains person extra information APIs.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Person Extra Information for India
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_in_person_extra_info >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates miscellaneous extra information for a person.
17 *
18 * For the extra information type 'IN_MISCELLANEOUS', a record is created for
19 * the person.
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 * Person must exist. Extra Person Information Type IN_MISCELLANEOUS must
26 * exist.
27 *
28 * <p><b>Post Success</b><br>
29 * The miscellaneous extra information is created for the person.
30 *
31 * <p><b>Post Failure</b><br>
32 * The API does not create the person extra info and raises an error.
33 *
34 * @param p_validate If true, then validation alone will be performed and the
35 * database will remain unchanged. If false and all validation checks pass,
36 * then the database will be modified.
37 * @param p_person_id Identifies the person for whom you create the extra
38 * person information record.
39 * @param p_pei_attribute_category Determines context of the pei_attribute
40 * descriptive flexfield in parameters
41 * @param p_pei_attribute1 Descriptive flexfield segment.
42 * @param p_pei_attribute2 Descriptive flexfield segment.
43 * @param p_pei_attribute3 Descriptive flexfield segment.
44 * @param p_pei_attribute4 Descriptive flexfield segment.
45 * @param p_pei_attribute5 Descriptive flexfield segment.
46 * @param p_pei_attribute6 Descriptive flexfield segment.
47 * @param p_pei_attribute7 Descriptive flexfield segment.
48 * @param p_pei_attribute8 Descriptive flexfield segment.
49 * @param p_pei_attribute9 Descriptive flexfield segment.
50 * @param p_pei_attribute10 Descriptive flexfield segment.
51 * @param p_pei_attribute11 Descriptive flexfield segment.
52 * @param p_pei_attribute12 Descriptive flexfield segment.
53 * @param p_pei_attribute13 Descriptive flexfield segment.
54 * @param p_pei_attribute14 Descriptive flexfield segment.
55 * @param p_pei_attribute15 Descriptive flexfield segment.
56 * @param p_pei_attribute16 Descriptive flexfield segment.
57 * @param p_pei_attribute17 Descriptive flexfield segment.
58 * @param p_pei_attribute18 Descriptive flexfield segment.
59 * @param p_pei_attribute19 Descriptive flexfield segment.
60 * @param p_pei_attribute20 Descriptive flexfield segment.
61 * @param p_religion Religion of the person
62 * @param p_community Community of the person
63 * @param p_caste_or_tribe Caste or tribe of the person
64 * @param p_height Height of the person
65 * @param p_weight Weight of the person
66 * @param p_person_extra_info_id If p_validate is false, uniquely identifies
67 * the person extra info created. If p_validate is true, set to null.
68 * @param p_object_version_number If p_validate is false, then set to the
69 * version number of the created extra person information. If p_validate is
70 * true, then the value will be null.
71 * @rep:displayname Create Miscellaneous Person Extra Information for India
72 * @rep:category BUSINESS_ENTITY HR_PERSON
73 * @rep:lifecycle active
74 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
75 * @rep:scope public
76 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
77 */
78 --
79 -- {End Of Comments}
80 --
81 PROCEDURE create_in_person_extra_info
82 (p_validate IN BOOLEAN default false
83 ,p_person_id IN NUMBER
84 ,p_pei_attribute_category IN VARCHAR2 default null
85 ,p_pei_attribute1 IN VARCHAR2 default null
86 ,p_pei_attribute2 IN VARCHAR2 default null
87 ,p_pei_attribute3 IN VARCHAR2 default null
88 ,p_pei_attribute4 IN VARCHAR2 default null
89 ,p_pei_attribute5 IN VARCHAR2 default null
90 ,p_pei_attribute6 IN VARCHAR2 default null
91 ,p_pei_attribute7 IN VARCHAR2 default null
92 ,p_pei_attribute8 IN VARCHAR2 default null
93 ,p_pei_attribute9 IN VARCHAR2 default null
94 ,p_pei_attribute10 IN VARCHAR2 default null
95 ,p_pei_attribute11 IN VARCHAR2 default null
96 ,p_pei_attribute12 IN VARCHAR2 default null
97 ,p_pei_attribute13 IN VARCHAR2 default null
98 ,p_pei_attribute14 IN VARCHAR2 default null
99 ,p_pei_attribute15 IN VARCHAR2 default null
100 ,p_pei_attribute16 IN VARCHAR2 default null
101 ,p_pei_attribute17 IN VARCHAR2 default null
102 ,p_pei_attribute18 IN VARCHAR2 default null
103 ,p_pei_attribute19 IN VARCHAR2 default null
104 ,p_pei_attribute20 IN VARCHAR2 default null
105 ,p_religion IN VARCHAR2 default null
106 ,p_community IN VARCHAR2 default null
107 ,p_caste_or_tribe IN VARCHAR2 default null
108 ,p_height IN VARCHAR2 default null
109 ,p_weight IN VARCHAR2 default null
110 ,p_person_extra_info_id OUT NOCOPY NUMBER
111 ,p_object_version_number OUT NOCOPY NUMBER
112 );
113 --
114 -- ----------------------------------------------------------------------------
115 -- |------------------------< create_in_passport_details >--------------------|
116 -- ----------------------------------------------------------------------------
117 --
118 -- {Start Of Comments}
119 /*#
120 * This API creates passport details extra information for a person.
121 *
122 * For the extra information type 'IN_PASSPORT_DETAILS', a record is created
123 * for the person.
124 *
125 * <p><b>Licensing</b><br>
126 * This API is licensed for use with Human Resources.
127 *
128 * <p><b>Prerequisites</b><br>
129 * Person must exist. Extra Person Information Type IN_PASSPORT_DETAILS must
130 * exist.
131 *
132 * <p><b>Post Success</b><br>
133 * The passport details extra information is created for the person.
134 *
135 * <p><b>Post Failure</b><br>
136 * The API does not create the person extra info and raises an error.
137 *
138 * @param p_validate If true, then validation alone will be performed and the
139 * database will remain unchanged. If false and all validation checks pass,
140 * then the database will be modified.
141 * @param p_person_id Identifies the person for whom you create the extra
142 * person information record.
143 * @param p_pei_attribute_category Determines context of the pei_attribute
144 * descriptive flexfield in parameters
145 * @param p_pei_attribute1 Descriptive flexfield segment.
146 * @param p_pei_attribute2 Descriptive flexfield segment.
147 * @param p_pei_attribute3 Descriptive flexfield segment.
148 * @param p_pei_attribute4 Descriptive flexfield segment.
149 * @param p_pei_attribute5 Descriptive flexfield segment.
150 * @param p_pei_attribute6 Descriptive flexfield segment.
151 * @param p_pei_attribute7 Descriptive flexfield segment.
152 * @param p_pei_attribute8 Descriptive flexfield segment.
153 * @param p_pei_attribute9 Descriptive flexfield segment.
154 * @param p_pei_attribute10 Descriptive flexfield segment.
155 * @param p_pei_attribute11 Descriptive flexfield segment.
156 * @param p_pei_attribute12 Descriptive flexfield segment.
157 * @param p_pei_attribute13 Descriptive flexfield segment.
158 * @param p_pei_attribute14 Descriptive flexfield segment.
159 * @param p_pei_attribute15 Descriptive flexfield segment.
160 * @param p_pei_attribute16 Descriptive flexfield segment.
161 * @param p_pei_attribute17 Descriptive flexfield segment.
162 * @param p_pei_attribute18 Descriptive flexfield segment.
163 * @param p_pei_attribute19 Descriptive flexfield segment.
164 * @param p_pei_attribute20 Descriptive flexfield segment.
165 * @param p_passport_name Name of the person as in Passport
166 * @param p_passport_number Passport number of the person
167 * @param p_place_of_issue Place of issue of the passport
168 * @param p_issue_date Issue Date of the passport
169 * @param p_expiry_date Expiry Date of the passport
170 * @param p_ecnr_required ECNR Required in the passport. Valid values are
171 * defined by 'YES_NO' lookup type.
172 * @param p_issuing_country Issuing Country of the passport. Valid values in
173 * the FND_TERRITORIES table.
174 * @param p_person_extra_info_id If p_validate is false, uniquely identifies
175 * the person extra info created. If p_validate is true, set to null.
176 * @param p_object_version_number If p_validate is false, then set to the
177 * version number of the created extra person information. If p_validate is
178 * true, then the value will be null.
179 * @rep:displayname Create Passport Details for India
180 * @rep:category BUSINESS_ENTITY HR_PERSON
181 * @rep:lifecycle active
182 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
183 * @rep:scope public
184 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
185 */
186 --
187 -- {End Of Comments}
188 --
189 PROCEDURE create_in_passport_details
190 (p_validate IN BOOLEAN default false
191 ,p_person_id IN NUMBER
192 ,p_pei_attribute_category IN VARCHAR2 default null
193 ,p_pei_attribute1 IN VARCHAR2 default null
194 ,p_pei_attribute2 IN VARCHAR2 default null
195 ,p_pei_attribute3 IN VARCHAR2 default null
196 ,p_pei_attribute4 IN VARCHAR2 default null
197 ,p_pei_attribute5 IN VARCHAR2 default null
198 ,p_pei_attribute6 IN VARCHAR2 default null
199 ,p_pei_attribute7 IN VARCHAR2 default null
200 ,p_pei_attribute8 IN VARCHAR2 default null
201 ,p_pei_attribute9 IN VARCHAR2 default null
202 ,p_pei_attribute10 IN VARCHAR2 default null
203 ,p_pei_attribute11 IN VARCHAR2 default null
204 ,p_pei_attribute12 IN VARCHAR2 default null
205 ,p_pei_attribute13 IN VARCHAR2 default null
206 ,p_pei_attribute14 IN VARCHAR2 default null
207 ,p_pei_attribute15 IN VARCHAR2 default null
208 ,p_pei_attribute16 IN VARCHAR2 default null
209 ,p_pei_attribute17 IN VARCHAR2 default null
210 ,p_pei_attribute18 IN VARCHAR2 default null
211 ,p_pei_attribute19 IN VARCHAR2 default null
212 ,p_pei_attribute20 IN VARCHAR2 default null
213 ,p_passport_name IN VARCHAR2
214 ,p_passport_number IN VARCHAR2
215 ,p_place_of_issue IN VARCHAR2
216 ,p_issue_date IN VARCHAR2
217 ,p_expiry_date IN VARCHAR2
218 ,p_ecnr_required IN VARCHAR2
219 ,p_issuing_country IN VARCHAR2
220 ,p_person_extra_info_id OUT NOCOPY NUMBER
221 ,p_object_version_number OUT NOCOPY NUMBER
222 );
223 --
224 -- ----------------------------------------------------------------------------
225 -- |-----------------------< update_in_person_extra_info >--------------------|
226 -- ----------------------------------------------------------------------------
227 --
228 -- {Start Of Comments}
229 /*#
230 * This API updates miscellaneous extra information for a person.
231 *
232 * This API updates extra information for the information type
233 * 'IN_MISCELLANEOUS' for a given person as identified by the in parameter
234 * p_person_extra_info_id and the in out parameter p_object_version_number.
235 *
236 * <p><b>Licensing</b><br>
237 * This API is licensed for use with Human Resources.
238 *
239 * <p><b>Prerequisites</b><br>
240 * Person must exist. Extra Person Information Type IN_MISCELLANEOUS must
241 * exist.
242 *
243 * <p><b>Post Success</b><br>
244 * The miscellaneous extra information is updated for the person.
245 *
246 * <p><b>Post Failure</b><br>
247 * The API does not update the person extra info and raises an error.
248 *
249 * @param p_validate If true, then validation alone will be performed and the
250 * database will remain unchanged. If false and all validation checks pass,
251 * then the database will be modified.
252 * @param p_person_extra_info_id Primary key to identify the person extra
253 * information record.
254 * @param p_object_version_number Pass in the current version number of the
255 * extra person information to be updated. When the API completes if p_validate
256 * is false, will be set to the new version number of the updated extra person
257 * information. If p_validate is true will be set to the same value which was
258 * passed in.
259 * @param p_pei_attribute_category Determines context of the pei_attribute
260 * descriptive flexfield in parameters.
261 * @param p_pei_attribute1 Descriptive flexfield segment.
262 * @param p_pei_attribute2 Descriptive flexfield segment.
263 * @param p_pei_attribute3 Descriptive flexfield segment.
264 * @param p_pei_attribute4 Descriptive flexfield segment.
265 * @param p_pei_attribute5 Descriptive flexfield segment.
266 * @param p_pei_attribute6 Descriptive flexfield segment.
267 * @param p_pei_attribute7 Descriptive flexfield segment.
268 * @param p_pei_attribute8 Descriptive flexfield segment.
269 * @param p_pei_attribute9 Descriptive flexfield segment.
270 * @param p_pei_attribute10 Descriptive flexfield segment.
271 * @param p_pei_attribute11 Descriptive flexfield segment.
272 * @param p_pei_attribute12 Descriptive flexfield segment.
273 * @param p_pei_attribute13 Descriptive flexfield segment.
274 * @param p_pei_attribute14 Descriptive flexfield segment.
275 * @param p_pei_attribute15 Descriptive flexfield segment.
276 * @param p_pei_attribute16 Descriptive flexfield segment.
277 * @param p_pei_attribute17 Descriptive flexfield segment.
278 * @param p_pei_attribute18 Descriptive flexfield segment.
279 * @param p_pei_attribute19 Descriptive flexfield segment.
280 * @param p_pei_attribute20 Descriptive flexfield segment.
281 * @param p_religion Religion of the person.
282 * @param p_community Community of the person.
283 * @param p_caste_or_tribe Caste or tribe of the person.
284 * @param p_height Height of the person.
285 * @param p_weight Weight of the person.
286 * @rep:displayname Update Miscellaneous Person Extra Information for India
287 * @rep:category BUSINESS_ENTITY HR_PERSON
288 * @rep:lifecycle active
289 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
290 * @rep:scope public
291 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
292 */
293 --
294 -- {End Of Comments}
295 --
296 PROCEDURE update_in_person_extra_info
297 (p_validate IN BOOLEAN default false
298 ,p_person_extra_info_id IN NUMBER
299 ,p_object_version_number IN OUT NOCOPY NUMBER
300 ,p_pei_attribute_category IN VARCHAR2 default hr_api.g_varchar2
301 ,p_pei_attribute1 IN VARCHAR2 default hr_api.g_varchar2
302 ,p_pei_attribute2 IN VARCHAR2 default hr_api.g_varchar2
303 ,p_pei_attribute3 IN VARCHAR2 default hr_api.g_varchar2
304 ,p_pei_attribute4 IN VARCHAR2 default hr_api.g_varchar2
305 ,p_pei_attribute5 IN VARCHAR2 default hr_api.g_varchar2
306 ,p_pei_attribute6 IN VARCHAR2 default hr_api.g_varchar2
307 ,p_pei_attribute7 IN VARCHAR2 default hr_api.g_varchar2
308 ,p_pei_attribute8 IN VARCHAR2 default hr_api.g_varchar2
309 ,p_pei_attribute9 IN VARCHAR2 default hr_api.g_varchar2
310 ,p_pei_attribute10 IN VARCHAR2 default hr_api.g_varchar2
311 ,p_pei_attribute11 IN VARCHAR2 default hr_api.g_varchar2
312 ,p_pei_attribute12 IN VARCHAR2 default hr_api.g_varchar2
313 ,p_pei_attribute13 IN VARCHAR2 default hr_api.g_varchar2
314 ,p_pei_attribute14 IN VARCHAR2 default hr_api.g_varchar2
315 ,p_pei_attribute15 IN VARCHAR2 default hr_api.g_varchar2
316 ,p_pei_attribute16 IN VARCHAR2 default hr_api.g_varchar2
317 ,p_pei_attribute17 IN VARCHAR2 default hr_api.g_varchar2
321 ,p_religion IN VARCHAR2 default hr_api.g_varchar2
318 ,p_pei_attribute18 IN VARCHAR2 default hr_api.g_varchar2
319 ,p_pei_attribute19 IN VARCHAR2 default hr_api.g_varchar2
320 ,p_pei_attribute20 IN VARCHAR2 default hr_api.g_varchar2
322 ,p_community IN VARCHAR2 default hr_api.g_varchar2
323 ,p_caste_or_tribe IN VARCHAR2 default hr_api.g_varchar2
324 ,p_height IN VARCHAR2 default hr_api.g_varchar2
325 ,p_weight IN VARCHAR2 default hr_api.g_varchar2
326 );
327 --
328 -- ----------------------------------------------------------------------------
329 -- |------------------------< update_in_passport_details >--------------------|
330 -- ----------------------------------------------------------------------------
331 --
332 -- {Start Of Comments}
333 /*#
334 * This API updates passport details extra information for a person.
335 *
336 * This API updates extra information for the information type
337 * 'IN_PASSPORT_DETAILS' for a given person as identified by the in parameter
338 * p_person_extra_info_id and the in out parameter p_object_version_number.
339 *
340 * <p><b>Licensing</b><br>
341 * This API is licensed for use with Human Resources.
342 *
343 * <p><b>Prerequisites</b><br>
344 * Person must exist. Extra Person Information Type IN_PASSPORT_DETAILS must
345 * exist.
346 *
347 * <p><b>Post Success</b><br>
348 * The passport details extra information is updated for the person.
349 *
350 * <p><b>Post Failure</b><br>
351 * The API does not update the person extra info and raises an error.
352 *
353 * @param p_validate If true, then validation alone will be performed and the
354 * database will remain unchanged. If false and all validation checks pass,
355 * then the database will be modified.
356 * @param p_person_extra_info_id Primary key to identify the person extra
357 * information record.
358 * @param p_object_version_number Pass in the current version number of the
359 * extra person information to be updated. When the API completes if p_validate
360 * is false, will be set to the new version number of the updated extra person
361 * information. If p_validate is true will be set to the same value which was
362 * passed in.
363 * @param p_pei_attribute_category Determines context of the pei_attribute
364 * descriptive flexfield in parameters.
365 * @param p_pei_attribute1 Descriptive flexfield segment.
366 * @param p_pei_attribute2 Descriptive flexfield segment.
367 * @param p_pei_attribute3 Descriptive flexfield segment.
368 * @param p_pei_attribute4 Descriptive flexfield segment.
369 * @param p_pei_attribute5 Descriptive flexfield segment.
370 * @param p_pei_attribute6 Descriptive flexfield segment.
371 * @param p_pei_attribute7 Descriptive flexfield segment.
372 * @param p_pei_attribute8 Descriptive flexfield segment.
373 * @param p_pei_attribute9 Descriptive flexfield segment.
374 * @param p_pei_attribute10 Descriptive flexfield segment.
375 * @param p_pei_attribute11 Descriptive flexfield segment.
376 * @param p_pei_attribute12 Descriptive flexfield segment.
377 * @param p_pei_attribute13 Descriptive flexfield segment.
378 * @param p_pei_attribute14 Descriptive flexfield segment.
379 * @param p_pei_attribute15 Descriptive flexfield segment.
380 * @param p_pei_attribute16 Descriptive flexfield segment.
381 * @param p_pei_attribute17 Descriptive flexfield segment.
382 * @param p_pei_attribute18 Descriptive flexfield segment.
383 * @param p_pei_attribute19 Descriptive flexfield segment.
384 * @param p_pei_attribute20 Descriptive flexfield segment.
385 * @param p_passport_name Name of the person as in Passport.
386 * @param p_passport_number Passport number of the person.
387 * @param p_place_of_issue Place of issue of the passport.
388 * @param p_issue_date Issue Date of the passport.
389 * @param p_expiry_date ECNR Required in the passport. Valid values are defined
390 * by 'YES_NO' lookup type.
391 * @param p_ecnr_required Issuing Country of the passport. Valid values in the
392 * FND_TERRITORIES table.
393 * @param p_issuing_country Issuing Country of the passport.
394 * @rep:displayname Update Passport Details for India
395 * @rep:category BUSINESS_ENTITY HR_PERSON
396 * @rep:lifecycle active
397 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
398 * @rep:scope public
399 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
400 */
401 --
402 -- {End Of Comments}
403 --
404 PROCEDURE update_in_passport_details
405 (p_validate IN BOOLEAN default false
406 ,p_person_extra_info_id IN NUMBER
407 ,p_object_version_number IN OUT NOCOPY NUMBER
408 ,p_pei_attribute_category IN VARCHAR2 default hr_api.g_varchar2
409 ,p_pei_attribute1 IN VARCHAR2 default hr_api.g_varchar2
410 ,p_pei_attribute2 IN VARCHAR2 default hr_api.g_varchar2
411 ,p_pei_attribute3 IN VARCHAR2 default hr_api.g_varchar2
412 ,p_pei_attribute4 IN VARCHAR2 default hr_api.g_varchar2
413 ,p_pei_attribute5 IN VARCHAR2 default hr_api.g_varchar2
414 ,p_pei_attribute6 IN VARCHAR2 default hr_api.g_varchar2
415 ,p_pei_attribute7 IN VARCHAR2 default hr_api.g_varchar2
416 ,p_pei_attribute8 IN VARCHAR2 default hr_api.g_varchar2
417 ,p_pei_attribute9 IN VARCHAR2 default hr_api.g_varchar2
418 ,p_pei_attribute10 IN VARCHAR2 default hr_api.g_varchar2
419 ,p_pei_attribute11 IN VARCHAR2 default hr_api.g_varchar2
420 ,p_pei_attribute12 IN VARCHAR2 default hr_api.g_varchar2
421 ,p_pei_attribute13 IN VARCHAR2 default hr_api.g_varchar2
422 ,p_pei_attribute14 IN VARCHAR2 default hr_api.g_varchar2
423 ,p_pei_attribute15 IN VARCHAR2 default hr_api.g_varchar2
424 ,p_pei_attribute16 IN VARCHAR2 default hr_api.g_varchar2
425 ,p_pei_attribute17 IN VARCHAR2 default hr_api.g_varchar2
426 ,p_pei_attribute18 IN VARCHAR2 default hr_api.g_varchar2
427 ,p_pei_attribute19 IN VARCHAR2 default hr_api.g_varchar2
428 ,p_pei_attribute20 IN VARCHAR2 default hr_api.g_varchar2
429 ,p_passport_name IN VARCHAR2 default hr_api.g_varchar2
430 ,p_passport_number IN VARCHAR2 default hr_api.g_varchar2
431 ,p_place_of_issue IN VARCHAR2 default hr_api.g_varchar2
432 ,p_issue_date IN VARCHAR2 default hr_api.g_varchar2
433 ,p_expiry_date IN VARCHAR2 default hr_api.g_varchar2
434 ,p_ecnr_required IN VARCHAR2 default hr_api.g_varchar2
435 ,p_issuing_country IN VARCHAR2 default hr_api.g_varchar2
436 );
437
438
439 END hr_in_person_extra_info_api;