1 PACKAGE HZ_PERSON_INFO_V2PUB AUTHID CURRENT_USER AS
2 /* $Header: ARH2PISS.pls 120.11 2006/08/17 10:13:13 idali noship $ */
3 /*#
4 * This package contains the public APIs for person-related entities.
5 * @rep:scope public
6 * @rep:product HZ
7 * @rep:displayname Person Information
8 * @rep:category BUSINESS_ENTITY HZ_PERSON
9 * @rep:lifecycle active
10 * @rep:doccd 120hztig.pdf Person Info APIs, Oracle Trading Community Architecture Technical Implementation Guide
11 */
12
13 --------------------------------------
14 -- declaration of record type
15 --------------------------------------
16
17 TYPE person_language_rec_type IS RECORD(
18 language_use_reference_id NUMBER,
19 language_name VARCHAR2(4),
20 party_id NUMBER,
21 native_language VARCHAR2(1),
22 primary_language_indicator VARCHAR2(1),
23 reads_level VARCHAR2(30),
24 speaks_level VARCHAR2(30),
25 writes_level VARCHAR2(30),
26 spoken_comprehension_level VARCHAR2(30),
27 status VARCHAR2(1),
28 created_by_module VARCHAR2(150),
29 application_id NUMBER
30 );
31
32 TYPE citizenship_rec_type IS RECORD(
33 citizenship_id NUMBER,
34 party_id NUMBER,
35 birth_or_selected VARCHAR(30),
36 country_code VARCHAR2(2),
37 date_recognized DATE,
38 date_disowned DATE,
39 end_date DATE,
40 document_type VARCHAR2(30),
41 document_reference VARCHAR2(60),
42 status VARCHAR2(1),
43 created_by_module VARCHAR2(150),
44 application_id NUMBER
45 );
46
47
48 TYPE education_rec_type IS RECORD(
49 education_id NUMBER,
50 party_id NUMBER,
51 course_major VARCHAR2(60),
52 degree_received VARCHAR2(60),
53 start_date_attended DATE,
54 last_date_attended DATE,
55 school_attended_name VARCHAR2(60),
56 school_party_id NUMBER,
57 -- Code modified for Bug 3473418 starts here
58 type_of_school VARCHAR2(30),
59 -- Code modified for Bug 3473418 ends here
60 status VARCHAR2(1),
61 created_by_module VARCHAR2(150),
62 application_id NUMBER
63 );
64
65 TYPE employment_history_rec_type IS RECORD(
66 employment_history_id NUMBER,
67 party_id NUMBER,
68 begin_date DATE,
69 end_date DATE,
70 employment_type_code VARCHAR2(30),
71 employed_as_title_code VARCHAR2(30),
72 employed_as_title VARCHAR2(60),
73 employed_by_name_company VARCHAR2(60),
74 employed_by_party_id NUMBER,
75 employed_by_division_name VARCHAR2(60),
76 supervisor_name VARCHAR2(60),
77 branch VARCHAR2(80),
78 military_rank VARCHAR2(240),
79 served VARCHAR2(240),
80 station VARCHAR2(240),
81 responsibility VARCHAR2(240),
82 weekly_work_hours NUMBER,
83 reason_for_leaving VARCHAR2(240),
84 faculty_position_flag VARCHAR2(1),
85 tenure_code VARCHAR2(30),
86 fraction_of_tenure NUMBER,
87 comments VARCHAR2(2000),
88 status VARCHAR2(1),
89 created_by_module VARCHAR2(150),
90 application_id NUMBER
91 );
92
93 TYPE work_class_rec_type IS RECORD(
94 work_class_id NUMBER,
95 level_of_experience VARCHAR2(60),
96 work_class_name VARCHAR2(240),
97 employment_history_id NUMBER,
98 status VARCHAR2(1),
99 created_by_module VARCHAR2(150),
100 application_id NUMBER
101 );
102
103 TYPE person_interest_rec_type IS RECORD(
104 person_interest_id NUMBER,
105 level_of_interest VARCHAR2(30),
106 party_id NUMBER,
107 level_of_participation VARCHAR2(30),
108 interest_type_code VARCHAR2(30),
109 comments VARCHAR2(240),
110 sport_indicator VARCHAR2(1),
111 sub_interest_type_code VARCHAR2(30),
112 interest_name VARCHAR2(240),
113 team VARCHAR2(240),
114 since DATE,
115 status VARCHAR(1),
116 created_by_module VARCHAR2(150),
117 application_id NUMBER
118 );
119
120
121 --------------------------------------
122 -- declaration of public procedures and functions
123 --------------------------------------
124
125 /**
126 * PROCEDURE create_person_language
127 *
128 * DESCRIPTION
129 * Creates person language.
130 *
131 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
132 *
133 * ARGUMENTS
134 * IN:
135 * p_init_msg_list Initialize message stack if it is set to
136 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
137 * p_person_language_rec Person language record.
138 * IN/OUT:
139 * OUT:
140 * x_language_use_reference_id Language use reference ID.
141 * x_return_status Return status after the call. The status can
142 * be FND_API.G_RET_STS_SUCCESS (success),
143 * FND_API.G_RET_STS_ERROR (error),
144 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
145 * x_msg_count Number of messages in message stack.
146 * x_msg_data Message text if x_msg_count is 1.
147 *
148 * NOTES
149 *
150 * MODIFICATION HISTORY
151 *
152 * 07-23-2001 Indrajit Sen o Created.
153 *
154 */
155
156 /*#
157 * Use this routine to create a language for a party. This API creates records in the
158 * HZ_PERSON_LANGUAGE table. You must create the Person party before you can
159 * create a language record for the party. You can create multiple language records with
160 * different language names for a party. This API lets you flag one language record as the
161 * person's primary language and one language record as the person's native language.
162 * @rep:scope public
163 * @rep:lifecycle active
164 * @rep:displayname Create Person Language
165 * @rep:businessevent oracle.apps.ar.hz.PersonLanguage.create
166 * @rep:doccd 120hztig.pdf Person Info APIs, Oracle Trading Community Architecture Technical Implementation Guide
167 */
168 PROCEDURE create_person_language(
169 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170 p_person_language_rec IN PERSON_LANGUAGE_REC_TYPE,
171 x_language_use_reference_id OUT NOCOPY NUMBER,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2
175 );
176
177 /**
178 * PROCEDURE update_person_language
179 *
180 * DESCRIPTION
181 * Updates person language.
182 *
183 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
184 *
185 * ARGUMENTS
186 * IN:
187 * p_init_msg_list Initialize message stack if it is set to
188 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
189 * p_person_language_rec Person language record.
190 * IN/OUT:
191 * p_object_version_number Used for locking the being updated record.
192 * OUT:
193 * x_return_status Return status after the call. The status can
194 * be FND_API.G_RET_STS_SUCCESS (success),
195 * FND_API.G_RET_STS_ERROR (error),
196 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
197 * x_msg_count Number of messages in message stack.
198 * x_msg_data Message text if x_msg_count is 1.
199 *
200 * NOTES
201 *
202 * MODIFICATION HISTORY
203 *
204 * 07-23-2001 Indrajit Sen o Created.
205 *
206 */
207
208 /*#
209 * Use this routine to update the language record for a party. This API updates a record
210 * in the HZ_PERSON_LANGUAGE table. You cannot update the language name, but you
211 * can change other attributes of the language record.
212 * @rep:scope public
213 * @rep:lifecycle active
214 * @rep:displayname Update Person Language
215 * @rep:businessevent oracle.apps.ar.hz.PersonLanguage.update
216 * @rep:doccd 120hztig.pdf Person Info APIs, Oracle Trading Community Architecture Technical Implementation Guide
217 */
218 PROCEDURE update_person_language(
219 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220 p_person_language_rec IN PERSON_LANGUAGE_REC_TYPE,
221 p_object_version_number IN OUT NOCOPY NUMBER,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2
225 );
226
227 /**
228 * PROCEDURE get_person_language_rec
229 *
230 * DESCRIPTION
231 * Gets person language record.
232 *
233 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
234 *
235 * ARGUMENTS
236 * IN:
237 * p_init_msg_list Initialize message stack if it is set to
238 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
239 * p_language_use_reference_id Language use reference ID.
240 * IN/OUT:
241 * OUT:
242 * x_person_language_rec Returned person language record.
243 * x_return_status Return status after the call. The status can
244 * be FND_API.G_RET_STS_SUCCESS (success),
245 * FND_API.G_RET_STS_ERROR (error),
246 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
247 * x_msg_count Number of messages in message stack.
248 * x_msg_data Message text if x_msg_count is 1.
249 *
250 * NOTES
251 *
252 * MODIFICATION HISTORY
253 *
254 * 07-23-2001 Indrajit Sen o Created.
255 *
256 */
257
258 PROCEDURE get_person_language_rec (
259 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
260 p_language_use_reference_id IN NUMBER,
261 p_person_language_rec OUT NOCOPY PERSON_LANGUAGE_REC_TYPE,
262 x_return_status OUT NOCOPY VARCHAR2,
263 x_msg_count OUT NOCOPY NUMBER,
264 x_msg_data OUT NOCOPY VARCHAR2
265 );
266
267 /**
268 * PROCEDURE create_citizenship
269 *
270 * DESCRIPTION
271 * Creates citizenship.
272 *
273 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
274 *
275 * ARGUMENTS
276 * IN:
277 * p_init_msg_list Initialize message stack if it is set to
278 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
279 * p_citizenship_rec Citizenship record.
280 * IN/OUT:
281 * OUT:
282 * x_citizenship_id Citizenship ID.
283 * x_return_status Return status after the call. The status can
284 * be FND_API.G_RET_STS_SUCCESS (success),
285 * FND_API.G_RET_STS_ERROR (error),
286 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
287 * x_msg_count Number of messages in message stack.
288 * x_msg_data Message text if x_msg_count is 1.
289 *
290 * NOTES
291 *
292 * MODIFICATION HISTORY
293 *
294 * 31-Jan-2003 Porkodi Chinnandar o Created.
295 *
296 */
297
298 /*#
299 * Use this routine to create a citizenship record for a party. This API creates a
300 * record in the HZ_CITIZENSHIP table.
301 * @rep:scope public
302 * @rep:lifecycle active
303 * @rep:displayname Create Citizenship
304 * @rep:businessevent oracle.apps.ar.hz.Citizenship.create
305 * @rep:doccd 120hztig.pdf Person Info APIs, Oracle Trading Community Architecture Technical Implementation Guide
306 */
307 PROCEDURE create_citizenship(
308 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
309 p_citizenship_rec IN CITIZENSHIP_REC_TYPE,
310 x_citizenship_id OUT NOCOPY NUMBER,
311 x_return_status OUT NOCOPY VARCHAR2,
312 x_msg_count OUT NOCOPY NUMBER,
313 x_msg_data OUT NOCOPY VARCHAR2
314 );
315
316 /**
317 * PROCEDURE update_citizenship
318 *
319 * DESCRIPTION
320 * Updates citizenship.
321 *
322 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
323 *
324 * ARGUMENTS
325 * IN:
326 * p_init_msg_list Initialize message stack if it is set to
327 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
328 * p_citizenship_rec citizenship record.
329 * IN/OUT:
330 * p_object_version_number Used for locking the being updated record.
331 * OUT:
332 * x_return_status Return status after the call. The status can
333 * be FND_API.G_RET_STS_SUCCESS (success),
334 * FND_API.G_RET_STS_ERROR (error),
338 *
335 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
336 * x_msg_count Number of messages in message stack.
337 * x_msg_data Message text if x_msg_count is 1.
339 * NOTES
340 *
341 * MODIFICATION HISTORY
342 *
343 * 31-Jan-2003 Porkodi Chinnandar o Created.
344 *
345 */
346
347 /*#
348 * Use this routine to update the citizenship record for a Person party.
349 * @rep:scope public
350 * @rep:lifecycle active
351 * @rep:displayname Update Citizenship
352 * @rep:businessevent oracle.apps.ar.hz.Citizenship.update
353 * @rep:doccd 120hztig.pdf Person Info APIs, Oracle Trading Community Architecture Technical Implementation Guide
354 */
355 PROCEDURE update_citizenship(
356 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
357 p_citizenship_rec IN CITIZENSHIP_REC_TYPE,
358 p_object_version_number IN OUT NOCOPY NUMBER,
359 x_return_status OUT NOCOPY VARCHAR2,
360 x_msg_count OUT NOCOPY NUMBER,
361 x_msg_data OUT NOCOPY VARCHAR2
362 );
363
364 /**
365 * PROCEDURE get_citizenship_rec
366 *
367 * DESCRIPTION
368 * Gets citizenship record.
369 *
370 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
371 *
372 * ARGUMENTS
373 * IN:
374 * p_init_msg_list Initialize message stack if it is set to
375 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
376 * p_citizenship_id Citizenship ID.
377 * IN/OUT:
378 * OUT:
379 * x_citizenship_rec Returned citizenship record.
380 * x_return_status Return status after the call. The status can
381 * be FND_API.G_RET_STS_SUCCESS (success),
382 * FND_API.G_RET_STS_ERROR (error),
383 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
384 * x_msg_count Number of messages in message stack.
385 * x_msg_data Message text if x_msg_count is 1.
386 *
387 * NOTES
388 *
389 * MODIFICATION HISTORY
390 *
391 * 31-Jan-2003 Porkodi Chinnandar o Created.
392 *
393 */
394
395 PROCEDURE get_citizenship_rec (
396 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
397 p_citizenship_id IN NUMBER,
398 x_citizenship_rec OUT NOCOPY CITIZENSHIP_REC_TYPE,
399 x_return_status OUT NOCOPY VARCHAR2,
400 x_msg_count OUT NOCOPY NUMBER,
401 x_msg_data OUT NOCOPY VARCHAR2
402 );
403
404
405 /**
406 * PROCEDURE create_education
407 *
408 * DESCRIPTION
409 * Creates education.
410 *
411 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
412 *
413 * ARGUMENTS
414 * IN:
415 * p_init_msg_list Initialize message stack if it is set to
416 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
417 * p_education_rec Education record.
418 * IN/OUT:
419 * OUT:
420 * x_education_id Education ID.
421 * x_return_status Return status after the call. The status can
422 * be FND_API.G_RET_STS_SUCCESS (success),
423 * FND_API.G_RET_STS_ERROR (error),
424 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
425 * x_msg_count Number of messages in message stack.
426 * x_msg_data Message text if x_msg_count is 1.
427 *
428 * NOTES
429 *
430 * MODIFICATION HISTORY
431 *
432 * 31-Jan-2003 Porkodi Chinnandar o Created.
433 *
434 */
435
436 /*#
437 * Use this routine to create an education record for a Person party. This API creates a
438 * record in the HZ_EDUCATION table.
439 * @rep:scope public
440 * @rep:lifecycle active
441 * @rep:displayname Create Education
442 * @rep:businessevent oracle.apps.ar.hz.Education.create
443 * @rep:doccd 120hztig.pdf Person Info APIs, Oracle Trading Community Architecture Technical Implementation Guide
444 */
445 PROCEDURE create_education(
446 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
447 p_education_rec IN EDUCATION_REC_TYPE,
448 x_education_id OUT NOCOPY NUMBER,
449 x_return_status OUT NOCOPY VARCHAR2,
450 x_msg_count OUT NOCOPY NUMBER,
451 x_msg_data OUT NOCOPY VARCHAR2
452 );
453
454 /**
455 * PROCEDURE update_education
456 *
457 * DESCRIPTION
458 * Updates Education.
459 *
460 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
461 *
462 * ARGUMENTS
463 * IN:
467 * IN/OUT:
464 * p_init_msg_list Initialize message stack if it is set to
465 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
466 * p_education_rec Education record.
468 * p_object_version_number Used for locking the being updated record.
469 * OUT:
470 * x_return_status Return status after the call. The status can
471 * be FND_API.G_RET_STS_SUCCESS (success),
472 * FND_API.G_RET_STS_ERROR (error),
473 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
474 * x_msg_count Number of messages in message stack.
475 * x_msg_data Message text if x_msg_count is 1.
476 *
477 * NOTES
478 *
479 * MODIFICATION HISTORY
480 *
481 * 31-Jan-2003 Porkodi Chinnandar o Created.
482 *
483 */
484
485 /*#
486 * Use this routine to update the education record for a Person party.
487 * @rep:scope public
488 * @rep:lifecycle active
489 * @rep:displayname Update Education
490 * @rep:businessevent oracle.apps.ar.hz.Education.update
491 * @rep:doccd 120hztig.pdf Person Info APIs, Oracle Trading Community Architecture Technical Implementation Guide
492 */
493 PROCEDURE update_education(
494 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
495 p_education_rec IN EDUCATION_REC_TYPE,
496 p_object_version_number IN OUT NOCOPY NUMBER,
497 x_return_status OUT NOCOPY VARCHAR2,
498 x_msg_count OUT NOCOPY NUMBER,
499 x_msg_data OUT NOCOPY VARCHAR2
500 );
501
502 /**
503 * PROCEDURE get_education_rec
504 *
505 * DESCRIPTION
506 * Gets Education record.
507 *
508 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
509 *
510 * ARGUMENTS
511 * IN:
512 * p_init_msg_list Initialize message stack if it is set to
513 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
514 * p_education_id Education ID.
515 * IN/OUT:
516 * OUT:
517 * x_education_rec Returned Education record.
518 * x_return_status Return status after the call. The status can
519 * be FND_API.G_RET_STS_SUCCESS (success),
520 * FND_API.G_RET_STS_ERROR (error),
521 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
522 * x_msg_count Number of messages in message stack.
523 * x_msg_data Message text if x_msg_count is 1.
524 *
525 * NOTES
526 *
527 * MODIFICATION HISTORY
528 *
529 * 31-Jan-2003 Porkodi Chinnandar o Created.
530 *
531 */
532
533 PROCEDURE get_education_rec (
534 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
535 p_education_id IN NUMBER,
536 x_education_rec OUT NOCOPY EDUCATION_REC_TYPE,
537 x_return_status OUT NOCOPY VARCHAR2,
538 x_msg_count OUT NOCOPY NUMBER,
539 x_msg_data OUT NOCOPY VARCHAR2
540 );
541
542
543 /**
544 * PROCEDURE create_employment_history
545 *
546 * DESCRIPTION
547 * Creates employment_history record.
548 *
549 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
550 *
551 * ARGUMENTS
552 * IN:
553 * p_init_msg_list Initialize message stack if it is set to
554 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
555 * p_employment_history_rec Employment history record.
556 * IN/OUT:
557 * OUT:
558 * x_employment_history_id Employment history ID.
559 * x_return_status Return status after the call. The status can
560 * be FND_API.G_RET_STS_SUCCESS (success),
561 * FND_API.G_RET_STS_ERROR (error),
562 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
563 * x_msg_count Number of messages in message stack.
564 * x_msg_data Message text if x_msg_count is 1.
565 *
566 * NOTES
567 *
568 * MODIFICATION HISTORY
569 *
570 * 31-Jan-2003 Porkodi Chinnandar o Created.
571 *
572 */
573
574 /*#
575 * Use this routine to create an employment history for a party. This API
576 * creates a record in the HZ_EMPLOYMENT_HISTORY table.
577 * @rep:scope public
578 * @rep:lifecycle active
582 */
579 * @rep:displayname Create Employment History
580 * @rep:businessevent oracle.apps.ar.hz.EmploymentHistory.create
581 * @rep:doccd 120hztig.pdf Person Info APIs, Oracle Trading Community Architecture Technical Implementation Guide
583 PROCEDURE create_employment_history(
584 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
585 p_employment_history_rec IN EMPLOYMENT_HISTORY_REC_TYPE,
586 x_employment_history_id OUT NOCOPY NUMBER,
587 x_return_status OUT NOCOPY VARCHAR2,
588 x_msg_count OUT NOCOPY NUMBER,
589 x_msg_data OUT NOCOPY VARCHAR2
590 );
591
592 /**
593 * PROCEDURE update_employment_history
594 *
595 * DESCRIPTION
596 * Updates Employment history.
597 *
598 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
599 *
600 * ARGUMENTS
601 * IN:
602 * p_init_msg_list Initialize message stack if it is set to
603 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
604 * p_employment_history_rec Employment history record.
605 * IN/OUT:
606 * p_object_version_number Used for locking the being updated record.
607 * OUT:
608 * x_return_status Return status after the call. The status can
609 * be FND_API.G_RET_STS_SUCCESS (success),
610 * FND_API.G_RET_STS_ERROR (error),
611 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
612 * x_msg_count Number of messages in message stack.
613 * x_msg_data Message text if x_msg_count is 1.
614 *
615 * NOTES
616 *
617 * MODIFICATION HISTORY
618 *
619 * 31-Jan-2003 Porkodi Chinnandar o Created.
620 *
621 */
622
623 /*#
624 * Use this routine to update the employment history for a party.
625 * @rep:scope public
626 * @rep:lifecycle active
627 * @rep:displayname Update Employment History
628 * @rep:businessevent oracle.apps.ar.hz.EmploymentHistory.update
629 * @rep:doccd 120hztig.pdf Person Info APIs, Oracle Trading Community Architecture Technical Implementation Guide
630 */
631 PROCEDURE update_employment_history(
632 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
633 p_employment_history_rec IN EMPLOYMENT_HISTORY_REC_TYPE,
634 p_object_version_number IN OUT NOCOPY NUMBER,
635 x_return_status OUT NOCOPY VARCHAR2,
636 x_msg_count OUT NOCOPY NUMBER,
637 x_msg_data OUT NOCOPY VARCHAR2
638 );
639
640 /**
641 * PROCEDURE get_employment_history_rec
642 *
643 * DESCRIPTION
644 * Gets Employment history record.
645 *
646 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
647 *
648 * ARGUMENTS
649 * IN:
650 * p_init_msg_list Initialize message stack if it is set to
651 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
652 * p_employment_history_id Employment history ID.
653 * IN/OUT:
654 * OUT:
655 * x_employment_history_rec Returned Employment history record.
656 * x_return_status Return status after the call. The status can
657 * be FND_API.G_RET_STS_SUCCESS (success),
658 * FND_API.G_RET_STS_ERROR (error),
659 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
660 * x_msg_count Number of messages in message stack.
661 * x_msg_data Message text if x_msg_count is 1.
662 *
663 * NOTES
664 *
665 * MODIFICATION HISTORY
666 *
667 * 31-Jan-2003 Porkodi Chinnandar o Created.
668 *
669 */
670
671 PROCEDURE get_employment_history_rec (
672 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
673 p_employment_history_id IN NUMBER,
674 x_employment_history_rec OUT NOCOPY EMPLOYMENT_HISTORY_REC_TYPE,
675 x_return_status OUT NOCOPY VARCHAR2,
676 x_msg_count OUT NOCOPY NUMBER,
677 x_msg_data OUT NOCOPY VARCHAR2
678 );
679
680
681 /**
682 * PROCEDURE create_work_class
683 *
684 * DESCRIPTION
685 * Creates work_class record.
686 *
687 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
688 *
689 * ARGUMENTS
690 * IN:
691 * p_init_msg_list Initialize message stack if it is set to
692 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
693 * p_work_class_rec Work class record.
694 * IN/OUT:
695 * OUT:
696 * x_work_class_id Work class ID.
697 * x_return_status Return status after the call. The status can
698 * be FND_API.G_RET_STS_SUCCESS (success),
702 * x_msg_data Message text if x_msg_count is 1.
699 * FND_API.G_RET_STS_ERROR (error),
700 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
701 * x_msg_count Number of messages in message stack.
703 *
704 * NOTES
705 *
706 * MODIFICATION HISTORY
707 *
708 * 02-Feb-2003 Porkodi Chinnandar o Created.
709 *
710 */
711
712 /*#
713 * Use this routine to create a work class record for a party. This API create records in
714 * the HZ_WORK_CLASS table.
715 * @rep:scope public
716 * @rep:lifecycle active
717 * @rep:displayname Create Work Class
718 * @rep:businessevent oracle.apps.ar.hz.WorkClass.create
719 * @rep:doccd 120hztig.pdf Person Info APIs, Oracle Trading Community Architecture Technical Implementation Guide
720 */
721 PROCEDURE create_work_class(
722 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
723 p_work_class_rec IN WORK_CLASS_REC_TYPE,
724 x_work_class_id OUT NOCOPY NUMBER,
725 x_return_status OUT NOCOPY VARCHAR2,
726 x_msg_count OUT NOCOPY NUMBER,
727 x_msg_data OUT NOCOPY VARCHAR2
728 );
729
730 /**
731 * PROCEDURE update_work_class
732 *
733 * DESCRIPTION
734 * Updates Work_class.
735 *
736 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
737 *
738 * ARGUMENTS
739 * IN:
740 * p_init_msg_list Initialize message stack if it is set to
741 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
742 * p_work_class_rec Work class record.
743 * IN/OUT:
744 * p_object_version_number Used for locking the being updated record.
745 * OUT:
746 * x_return_status Return status after the call. The status can
747 * be FND_API.G_RET_STS_SUCCESS (success),
748 * FND_API.G_RET_STS_ERROR (error),
749 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
750 * x_msg_count Number of messages in message stack.
751 * x_msg_data Message text if x_msg_count is 1.
752 *
753 * NOTES
754 *
755 * MODIFICATION HISTORY
756 *
757 * 02-Feb-2003 Porkodi Chinnandar o Created.
758 *
759 */
760
761 /*#
762 * Use this routine to update the work class record for a party.
763 * @rep:scope public
764 * @rep:lifecycle active
765 * @rep:displayname Update Work Class
766 * @rep:businessevent oracle.apps.ar.hz.WorkClass.update
767 * @rep:doccd 120hztig.pdf Person Info APIs, Oracle Trading Community Architecture Technical Implementation Guide
768 */
769 PROCEDURE update_work_class(
770 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
771 p_work_class_rec IN WORK_CLASS_REC_TYPE,
772 p_object_version_number IN OUT NOCOPY NUMBER,
773 x_return_status OUT NOCOPY VARCHAR2,
774 x_msg_count OUT NOCOPY NUMBER,
775 x_msg_data OUT NOCOPY VARCHAR2
776 );
777
778 /**
779 * PROCEDURE get_work_class_rec
780 *
781 * DESCRIPTION
782 * Gets Work class record.
783 *
784 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
785 *
786 * ARGUMENTS
787 * IN:
788 * p_init_msg_list Initialize message stack if it is set to
789 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
790 * p_work_class_id Work class ID.
791 * IN/OUT:
792 * OUT:
793 * x_work_class_rec Returned Work class record.
794 * x_return_status Return status after the call. The status can
795 * be FND_API.G_RET_STS_SUCCESS (success),
796 * FND_API.G_RET_STS_ERROR (error),
797 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
798 * x_msg_count Number of messages in message stack.
799 * x_msg_data Message text if x_msg_count is 1.
800 *
801 * NOTES
802 *
803 * MODIFICATION HISTORY
804 *
805 * 02-Feb-2003 Porkodi Chinnandar o Created.
806 *
807 */
808
809 PROCEDURE get_work_class_rec (
810 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
811 p_work_class_id IN NUMBER,
812 x_work_class_rec OUT NOCOPY WORK_CLASS_REC_TYPE,
813 x_return_status OUT NOCOPY VARCHAR2,
814 x_msg_count OUT NOCOPY NUMBER,
815 x_msg_data OUT NOCOPY VARCHAR2
816 );
817
818 /**
819 * PROCEDURE create_person_interest
820 *
821 * DESCRIPTION
822 * Creates person_interest record.
823 *
824 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
825 *
826 * ARGUMENTS
827 * IN:
828 * p_init_msg_list Initialize message stack if it is set to
829 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
830 * p_person_interest_rec Person interest record.
831 * IN/OUT:
832 * OUT:
833 * x_person_interest_id Person interest ID.
834 * x_return_status Return status after the call. The status can
835 * be FND_API.G_RET_STS_SUCCESS (success),
836 * FND_API.G_RET_STS_ERROR (error),
837 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
838 * x_msg_count Number of messages in message stack.
839 * x_msg_data Message text if x_msg_count is 1.
840 *
841 * NOTES
842 *
843 * MODIFICATION HISTORY
844 *
845 * 02-Feb-2003 Porkodi Chinnandar o Created.
846 *
847 */
848
849 /*#
850 * Use this routine to create a person interest record for a party. This API creates
851 * records in the HZ_PERSON_INTEREST table.
852 * @rep:scope public
853 * @rep:lifecycle active
854 * @rep:displayname Create Person Interest
855 * @rep:businessevent oracle.apps.ar.hz.PersonInterest.create
856 * @rep:doccd 120hztig.pdf Person Info APIs, Oracle Trading Community Architecture Technical Implementation Guide
857 */
858 PROCEDURE create_person_interest(
859 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
860 p_person_interest_rec IN PERSON_INTEREST_REC_TYPE,
861 x_person_interest_id OUT NOCOPY NUMBER,
862 x_return_status OUT NOCOPY VARCHAR2,
863 x_msg_count OUT NOCOPY NUMBER,
864 x_msg_data OUT NOCOPY VARCHAR2
865 );
866
867 /**
871 * Updates person interest.
868 * PROCEDURE update_person_interest
869 *
870 * DESCRIPTION
872 *
873 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
874 *
875 * ARGUMENTS
876 * IN:
877 * p_init_msg_list Initialize message stack if it is set to
878 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
879 * p_person_interest_rec person interest record.
880 * IN/OUT:
881 * p_object_version_number Used for locking the being updated record.
882 * OUT:
883 * x_return_status Return status after the call. The status can
884 * be FND_API.G_RET_STS_SUCCESS (success),
885 * FND_API.G_RET_STS_ERROR (error),
886 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
887 * x_msg_count Number of messages in message stack.
888 * x_msg_data Message text if x_msg_count is 1.
889 *
890 * NOTES
891 *
892 * MODIFICATION HISTORY
893 *
894 * 02-Feb-2003 Porkodi Chinnandar o Created.
895 *
896 */
897
898 /*#
899 * Use this routine to update the person interest record for a party.
900 * @rep:scope public
901 * @rep:lifecycle active
902 * @rep:displayname Update Person Interest
903 * @rep:businessevent oracle.apps.ar.hz.PersonInterest.update
904 * @rep:doccd 120hztig.pdf Person Info APIs, Oracle Trading Community Architecture Technical Implementation Guide
905 */
906 PROCEDURE update_person_interest(
907 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
908 p_person_interest_rec IN PERSON_INTEREST_REC_TYPE,
909 p_object_version_number IN OUT NOCOPY NUMBER,
910 x_return_status OUT NOCOPY VARCHAR2,
911 x_msg_count OUT NOCOPY NUMBER,
912 x_msg_data OUT NOCOPY VARCHAR2
913 );
914
915 /**
916 * PROCEDURE get_person_interest_rec
917 *
918 * DESCRIPTION
919 * Gets Person interest record.
920 *
921 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
922 *
923 * ARGUMENTS
924 * IN:
925 * p_init_msg_list Initialize message stack if it is set to
926 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
927 * p_person_interest_id Person interest ID.
928 * IN/OUT:
929 * OUT:
930 * x_person_interest_rec Returned person interest record.
931 * x_return_status Return status after the call. The status can
932 * be FND_API.G_RET_STS_SUCCESS (success),
933 * FND_API.G_RET_STS_ERROR (error),
934 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
935 * x_msg_count Number of messages in message stack.
936 * x_msg_data Message text if x_msg_count is 1.
937 *
941 *
938 * NOTES
939 *
940 * MODIFICATION HISTORY
942 * 02-Feb-2003 Porkodi Chinnandar o Created.
943 *
944 */
945
946 PROCEDURE get_person_interest_rec (
947 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
948 p_person_interest_id IN NUMBER,
949 x_person_interest_rec OUT NOCOPY PERSON_INTEREST_REC_TYPE,
950 x_return_status OUT NOCOPY VARCHAR2,
951 x_msg_count OUT NOCOPY NUMBER,
952 x_msg_data OUT NOCOPY VARCHAR2
953 );
954
955
956 END HZ_PERSON_INFO_V2PUB;