[Home] [Help]
PACKAGE: APPS.HZ_PARTY_V2PUB
Source
1 PACKAGE HZ_PARTY_V2PUB AS
2 /*$Header: ARH2PASS.pls 120.13 2006/08/17 10:12:15 idali noship $ */
3 /*#
4 * This package contains the public APIs to create and update persons, organizations, and groups.
5 * @rep:scope public
6 * @rep:product HZ
7 * @rep:displayname Party
8 * @rep:category BUSINESS_ENTITY HZ_ORGANIZATION
9 * @rep:category BUSINESS_ENTITY HZ_PERSON
10 * @rep:category BUSINESS_ENTITY HZ_GROUP
11 * @rep:category BUSINESS_ENTITY HZ_PARTY
12 * @rep:lifecycle active
13 * @rep:doccd 120hztig.pdf Party APIs, Oracle Trading Community Architecture Technical Implementation Guide
14 */
15
16 --------------------------------------
17 -- declaration of record type
18 --------------------------------------
19
20 G_MISS_CONTENT_SOURCE_TYPE CONSTANT VARCHAR2(30) := 'USER_ENTERED';
21 G_SST_SOURCE_TYPE CONSTANT VARCHAR2(30) := 'SST';
22
23 TYPE party_rec_type IS RECORD(
24 party_id NUMBER,
25 party_number VARCHAR2(30),
26 validated_flag VARCHAR2(1),
27 orig_system_reference VARCHAR2(240),
28 orig_system VARCHAR2(30),
29 status VARCHAR2(1),
30 category_code VARCHAR2(30),
31 salutation VARCHAR2(60),
32 attribute_category VARCHAR2(30),
33 attribute1 VARCHAR2(150),
34 attribute2 VARCHAR2(150),
35 attribute3 VARCHAR2(150),
36 attribute4 VARCHAR2(150),
37 attribute5 VARCHAR2(150),
38 attribute6 VARCHAR2(150),
39 attribute7 VARCHAR2(150),
40 attribute8 VARCHAR2(150),
41 attribute9 VARCHAR2(150),
42 attribute10 VARCHAR2(150),
43 attribute11 VARCHAR2(150),
44 attribute12 VARCHAR2(150),
45 attribute13 VARCHAR2(150),
46 attribute14 VARCHAR2(150),
47 attribute15 VARCHAR2(150),
48 attribute16 VARCHAR2(150),
49 attribute17 VARCHAR2(150),
50 attribute18 VARCHAR2(150),
51 attribute19 VARCHAR2(150),
52 attribute20 VARCHAR2(150),
53 attribute21 VARCHAR2(150),
54 attribute22 VARCHAR2(150),
55 attribute23 VARCHAR2(150),
56 attribute24 VARCHAR2(150)
57 );
58
59 G_MISS_PARTY_REC PARTY_REC_TYPE;
60
61 TYPE person_rec_type IS RECORD(
62 person_pre_name_adjunct VARCHAR2(30),
63 person_first_name VARCHAR2(150),
64 person_middle_name VARCHAR2(60),
65 person_last_name VARCHAR2(150),
66 person_name_suffix VARCHAR2(30),
67 person_title VARCHAR2(60),
68 person_academic_title VARCHAR2(30),
69 person_previous_last_name VARCHAR2(150),
70 person_initials VARCHAR2(6),
71 known_as VARCHAR2(240),
72 known_as2 VARCHAR2(240),
73 known_as3 VARCHAR2(240),
74 known_as4 VARCHAR2(240),
75 known_as5 VARCHAR2(240),
76 person_name_phonetic VARCHAR2(320),
77 person_first_name_phonetic VARCHAR2(60),
78 person_last_name_phonetic VARCHAR2(60),
79 middle_name_phonetic VARCHAR2(60),
80 tax_reference VARCHAR2(50),
81 jgzz_fiscal_code VARCHAR2(20),
82 person_iden_type VARCHAR2(30),
83 person_identifier VARCHAR2(60),
84 date_of_birth DATE,
85 place_of_birth VARCHAR2(60),
86 date_of_death DATE,
87 deceased_flag VARCHAR2(1),
88 gender VARCHAR2(30),
89 declared_ethnicity VARCHAR2(60),
90 marital_status VARCHAR2(30),
91 marital_status_effective_date DATE,
92 personal_income NUMBER,
93 head_of_household_flag VARCHAR2(1),
94 household_income NUMBER,
95 household_size NUMBER,
96 rent_own_ind VARCHAR2(30),
97 last_known_gps VARCHAR2(60),
98 content_source_type VARCHAR2(30):= G_MISS_CONTENT_SOURCE_TYPE,
99 internal_flag VARCHAR2(2),
100 attribute_category VARCHAR2(30),
101 attribute1 VARCHAR2(150) ,
102 attribute2 VARCHAR2(150) ,
103 attribute3 VARCHAR2(150) ,
104 attribute4 VARCHAR2(150) ,
105 attribute5 VARCHAR2(150) ,
106 attribute6 VARCHAR2(150) ,
107 attribute7 VARCHAR2(150) ,
108 attribute8 VARCHAR2(150) ,
109 attribute9 VARCHAR2(150) ,
110 attribute10 VARCHAR2(150) ,
111 attribute11 VARCHAR2(150) ,
112 attribute12 VARCHAR2(150) ,
113 attribute13 VARCHAR2(150) ,
114 attribute14 VARCHAR2(150) ,
115 attribute15 VARCHAR2(150) ,
116 attribute16 VARCHAR2(150) ,
117 attribute17 VARCHAR2(150) ,
118 attribute18 VARCHAR2(150) ,
119 attribute19 VARCHAR2(150) ,
120 attribute20 VARCHAR2(150) ,
121 created_by_module VARCHAR2(150),
122 application_id NUMBER,
123 actual_content_source VARCHAR2(30) := G_SST_SOURCE_TYPE,
124 party_rec PARTY_REC_TYPE := G_MISS_PARTY_REC
125 );
126
127 G_MISS_PERSON_REC PERSON_REC_TYPE;
128
129 TYPE group_rec_type IS RECORD(
130 group_name VARCHAR2(255),
131 group_type VARCHAR2(30),
132 created_by_module VARCHAR2(150),
133 -- Bug 2467872
134 mission_statement VARCHAR2(2000),
135 application_id NUMBER,
136 party_rec PARTY_REC_TYPE := G_MISS_PARTY_REC
137 );
138
139 G_MISS_GROUP_REC GROUP_REC_TYPE;
140
141 TYPE organization_rec_type IS RECORD(
142 organization_name VARCHAR2(360),
143 duns_number_c VARCHAR2(30),
144 enquiry_duns VARCHAR2(15),
145 ceo_name VARCHAR2(240),
146 ceo_title VARCHAR2(240),
147 principal_name VARCHAR2(240),
148 principal_title VARCHAR2(240),
149 legal_status VARCHAR2(30),
150 control_yr NUMBER,
151 employees_total NUMBER,
152 hq_branch_ind VARCHAR2(30),
153 branch_flag VARCHAR2(1),
154 oob_ind VARCHAR2(30),
155 line_of_business VARCHAR2(240),
156 cong_dist_code VARCHAR2(2),
157 sic_code VARCHAR2(30),
158 import_ind VARCHAR2(30),
159 export_ind VARCHAR2(30),
160 labor_surplus_ind VARCHAR2(30),
161 debarment_ind VARCHAR2(30),
162 minority_owned_ind VARCHAR2(30),
163 minority_owned_type VARCHAR2(30),
164 woman_owned_ind VARCHAR2(30),
165 disadv_8a_ind VARCHAR2(30),
166 small_bus_ind VARCHAR2(30),
167 rent_own_ind VARCHAR2(30),
168 debarments_count NUMBER,
169 debarments_date DATE,
170 failure_score VARCHAR2(30),
171 failure_score_natnl_percentile NUMBER,
172 failure_score_override_code VARCHAR2(30),
173 failure_score_commentary VARCHAR2(30),
174 global_failure_score VARCHAR2(5),
175 db_rating VARCHAR2(5),
176 credit_score VARCHAR2(30),
177 credit_score_commentary VARCHAR2(30),
178 paydex_score VARCHAR2(3),
179 paydex_three_months_ago VARCHAR2(3),
180 paydex_norm VARCHAR2(3),
181 best_time_contact_begin DATE,
182 best_time_contact_end DATE,
183 organization_name_phonetic VARCHAR2(320),
184 tax_reference VARCHAR2(50),
185 gsa_indicator_flag VARCHAR2(1),
186 jgzz_fiscal_code VARCHAR2(20),
187 analysis_fy VARCHAR2(5),
188 fiscal_yearend_month VARCHAR2(30),
189 curr_fy_potential_revenue NUMBER,
190 next_fy_potential_revenue NUMBER,
191 year_established NUMBER,
192 mission_statement VARCHAR2(2000),
193 organization_type VARCHAR2(30),
194 business_scope VARCHAR2(20),
195 corporation_class VARCHAR2(60),
196 known_as VARCHAR2(240),
197 known_as2 VARCHAR2(240),
198 known_as3 VARCHAR2(240),
199 known_as4 VARCHAR2(240),
200 known_as5 VARCHAR2(240),
201 local_bus_iden_type VARCHAR2(30),
202 local_bus_identifier VARCHAR2(60),
203 pref_functional_currency VARCHAR2(30),
204 registration_type VARCHAR2(30),
205 total_employees_text VARCHAR2(60),
206 total_employees_ind VARCHAR2(30),
207 total_emp_est_ind VARCHAR2(30),
208 total_emp_min_ind VARCHAR2(30),
209 parent_sub_ind VARCHAR2(30),
210 incorp_year NUMBER,
211 sic_code_type VARCHAR2(30),
212 public_private_ownership_flag VARCHAR2(1),
213 internal_flag VARCHAR2(30),
214 local_activity_code_type VARCHAR2(30),
215 local_activity_code VARCHAR2(30),
216 emp_at_primary_adr VARCHAR2(10),
217 emp_at_primary_adr_text VARCHAR2(12),
218 emp_at_primary_adr_est_ind VARCHAR2(30),
219 emp_at_primary_adr_min_ind VARCHAR2(30),
220 high_credit NUMBER,
221 avg_high_credit NUMBER,
222 total_payments NUMBER,
223 credit_score_class NUMBER,
224 credit_score_natl_percentile NUMBER,
225 credit_score_incd_default NUMBER,
226 credit_score_age NUMBER,
227 credit_score_date DATE,
228 credit_score_commentary2 VARCHAR2(30),
229 credit_score_commentary3 VARCHAR2(30),
230 credit_score_commentary4 VARCHAR2(30),
231 credit_score_commentary5 VARCHAR2(30),
232 credit_score_commentary6 VARCHAR2(30),
233 credit_score_commentary7 VARCHAR2(30),
234 credit_score_commentary8 VARCHAR2(30),
235 credit_score_commentary9 VARCHAR2(30),
236 credit_score_commentary10 VARCHAR2(30),
237 failure_score_class NUMBER,
238 failure_score_incd_default NUMBER,
239 failure_score_age NUMBER,
240 failure_score_date DATE,
241 failure_score_commentary2 VARCHAR2(30),
242 failure_score_commentary3 VARCHAR2(30),
243 failure_score_commentary4 VARCHAR2(30),
244 failure_score_commentary5 VARCHAR2(30),
245 failure_score_commentary6 VARCHAR2(30),
246 failure_score_commentary7 VARCHAR2(30),
247 failure_score_commentary8 VARCHAR2(30),
248 failure_score_commentary9 VARCHAR2(30),
249 failure_score_commentary10 VARCHAR2(30),
250 maximum_credit_recommendation NUMBER,
251 maximum_credit_currency_code VARCHAR2(240),
252 displayed_duns_party_id NUMBER,
253 content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
254 content_source_number VARCHAR2(30),
255 attribute_category VARCHAR2(30),
256 attribute1 VARCHAR2(150),
257 attribute2 VARCHAR2(150),
258 attribute3 VARCHAR2(150),
259 attribute4 VARCHAR2(150),
260 attribute5 VARCHAR2(150),
261 attribute6 VARCHAR2(150),
262 attribute7 VARCHAR2(150),
263 attribute8 VARCHAR2(150),
264 attribute9 VARCHAR2(150),
265 attribute10 VARCHAR2(150),
266 attribute11 VARCHAR2(150),
267 attribute12 VARCHAR2(150),
268 attribute13 VARCHAR2(150),
269 attribute14 VARCHAR2(150),
270 attribute15 VARCHAR2(150),
271 attribute16 VARCHAR2(150),
272 attribute17 VARCHAR2(150),
273 attribute18 VARCHAR2(150),
274 attribute19 VARCHAR2(150),
275 attribute20 VARCHAR2(150),
279 actual_content_source VARCHAR2(30) := G_SST_SOURCE_TYPE,
276 created_by_module VARCHAR2(150),
277 application_id NUMBER,
278 do_not_confuse_with VARCHAR2(255),
280 home_country VARCHAR2(2),
281 party_rec PARTY_REC_TYPE:= G_MISS_PARTY_REC
282
283 );
284
285 G_MISS_ORGANIZATION_REC ORGANIZATION_REC_TYPE;
286
287 --------------------------------------
288 -- declaration of public procedures and functions
289 --------------------------------------
290
291 /**
292 * PROCEDURE create_person
293 *
294 * DESCRIPTION
295 * Creates person.
296 *
297 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
298 *
299 * ARGUMENTS
300 * IN:
301 * p_init_msg_list Initialize message stack if it is set to
302 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
303 * p_person_rec Person record.
304 * IN/OUT:
305 * OUT:
306 * x_party_id Party ID.
307 * x_party_number Party number.
308 * x_profile_id Person profile ID.
309 * x_return_status Return status after the call. The status can
310 * be FND_API.G_RET_STS_SUCCESS (success),
311 * FND_API.G_RET_STS_ERROR (error),
312 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
313 * x_msg_count Number of messages in message stack.
314 * x_msg_data Message text if x_msg_count is 1.
315 *
316 * NOTES
317 *
318 * MODIFICATION HISTORY
319 *
320 * 07-23-2001 Indrajit Sen o Created.
321 *
322 */
323
324 /*#
325 * Use this routine to create information about a person. This API creates a record in the
326 * HZ_PARTIES table with party type PERSON. The HZ_PARTIES table holds the basic
327 * information about the party. The API also creates a record in the HZ_PERSON_PROFILES
328 * table. That record holds more detailed and specific information about the person.
329 * @rep:scope public
330 * @rep:lifecycle active
331 * @rep:displayname Create Person
332 * @rep:businessevent oracle.apps.ar.hz.Person.create
333 * @rep:doccd 120hztig.pdf Party APIs, Oracle Trading Community Architecture Technical Implementation Guide
334 */
335 PROCEDURE create_person (
336 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
337 p_person_rec IN PERSON_REC_TYPE,
338 x_party_id OUT NOCOPY NUMBER,
339 x_party_number OUT NOCOPY VARCHAR2,
340 x_profile_id OUT NOCOPY NUMBER,
341 x_return_status OUT NOCOPY VARCHAR2,
342 x_msg_count OUT NOCOPY NUMBER,
343 x_msg_data OUT NOCOPY VARCHAR2
344 );
345
346 /**
347 * PROCEDURE create_person
348 *
349 * DESCRIPTION
350 * Creates person.
351 *
352 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
353 *
354 * ARGUMENTS
355 * IN:
356 * p_init_msg_list Initialize message stack if it is set to
357 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
358 * p_person_rec Person record.
359 * p_party_usage_code Party Usage Code.
360 * IN/OUT:
361 * OUT:
362 * x_party_id Party ID.
363 * x_party_number Party number.
364 * x_profile_id Person profile ID.
365 * x_return_status Return status after the call. The status can
366 * be FND_API.G_RET_STS_SUCCESS (success),
367 * FND_API.G_RET_STS_ERROR (error),
368 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
369 * x_msg_count Number of messages in message stack.
370 * x_msg_data Message text if x_msg_count is 1.
371 *
372 * NOTES
373 *
374 * MODIFICATION HISTORY
375 *
376 * 05-15-2005 Jianying Huang o Created.
377 *
378 */
379
380 PROCEDURE create_person (
381 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
382 p_person_rec IN PERSON_REC_TYPE,
383 p_party_usage_code IN VARCHAR2,
384 x_party_id OUT NOCOPY NUMBER,
385 x_party_number OUT NOCOPY VARCHAR2,
386 x_profile_id OUT NOCOPY NUMBER,
387 x_return_status OUT NOCOPY VARCHAR2,
388 x_msg_count OUT NOCOPY NUMBER,
389 x_msg_data OUT NOCOPY VARCHAR2
390 );
391
392 /**
393 * PROCEDURE update_person
394 *
395 * DESCRIPTION
396 * Updates person.
397 *
398 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
399 *
400 * ARGUMENTS
401 * IN:
402 * p_init_msg_list Initialize message stack if it is set to
403 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
407 * OUT:
404 * p_person_rec Person record.
405 * IN/OUT:
406 * p_party_object_version_number Used for locking the being updated record.
408 * x_profile_id Person profile ID.
409 * x_return_status Return status after the call. The status can
410 * be FND_API.G_RET_STS_SUCCESS (success),
411 * FND_API.G_RET_STS_ERROR (error),
412 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
413 * x_msg_count Number of messages in message stack.
414 * x_msg_data Message text if x_msg_count is 1.
415 *
416 * NOTES
417 *
418 * MODIFICATION HISTORY
419 *
420 * 07-23-2001 Indrajit Sen o Created.
421 *
422 */
423
424 /*#
425 * Use this routine to update information about a person. This API updates the party record
426 * for a person in the HZ_PARTIES table. The API also creates or updates a record in the
427 * HZ_PERSON_PROFILES table. If the record about a person is updated on the same day that
428 * the record is created, then the active profile record is updated. Otherwise, a new
429 * profile record is created, and an end date is assigned to the old profile record.
430 * @rep:scope public
431 * @rep:lifecycle active
432 * @rep:displayname Update Person
433 * @rep:businessevent oracle.apps.ar.hz.Person.update
434 * @rep:doccd 120hztig.pdf Party APIs, Oracle Trading Community Architecture Technical Implementation Guide
435 */
436 PROCEDURE update_person (
437 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
438 p_person_rec IN PERSON_REC_TYPE,
439 p_party_object_version_number IN OUT NOCOPY NUMBER,
440 x_profile_id OUT NOCOPY NUMBER,
441 x_return_status OUT NOCOPY VARCHAR2,
442 x_msg_count OUT NOCOPY NUMBER,
443 x_msg_data OUT NOCOPY VARCHAR2
444 );
445
446 /**
447 * PROCEDURE create_group
448 *
449 * DESCRIPTION
450 * Creates group.
451 *
452 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
453 *
454 * ARGUMENTS
455 * IN:
456 * p_init_msg_list Initialize message stack if it is set to
457 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
458 * p_group_rec Group record.
459 * IN/OUT:
460 * OUT:
461 * x_party_id Party ID.
462 * x_party_number Party number.
463 * x_return_status Return status after the call. The status can
464 * be FND_API.G_RET_STS_SUCCESS (success),
465 * FND_API.G_RET_STS_ERROR (error),
466 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
467 * x_msg_count Number of messages in message stack.
468 * x_msg_data Message text if x_msg_count is 1.
469 *
470 * NOTES
471 *
472 * MODIFICATION HISTORY
473 *
474 * 07-23-2001 Indrajit Sen o Created.
475 *
476 */
477
478 /*#
479 * Use this routine to create a record about a group. This API creates records in the
480 * HZ_PARTIES table with the GROUP party type. The HZ_PARTIES table stores basic
481 * information about the party. Unlike an Organization or Person party, there is no profile
482 * information for a Group party.
483 * @rep:scope public
484 * @rep:lifecycle active
485 * @rep:displayname Create Group
486 * @rep:businessevent oracle.apps.ar.hz.Group.create
487 * @rep:doccd 120hztig.pdf Party APIs, Oracle Trading Community Architecture Technical Implementation Guide
488 */
489 PROCEDURE create_group (
490 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
491 p_group_rec IN GROUP_REC_TYPE,
492 x_party_id OUT NOCOPY NUMBER,
493 x_party_number OUT NOCOPY VARCHAR2,
494 x_return_status OUT NOCOPY VARCHAR2,
495 x_msg_count OUT NOCOPY NUMBER,
496 x_msg_data OUT NOCOPY VARCHAR2
497 );
498
499 /**
500 * PROCEDURE update_group
501 *
502 * DESCRIPTION
503 * Updates group.
504 *
505 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
506 *
507 * ARGUMENTS
508 * IN:
509 * p_init_msg_list Initialize message stack if it is set to
510 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
511 * p_group_rec Group record.
512 * IN/OUT:
513 * p_party_object_version_number Used for locking the being updated record.
514 * OUT:
515 * x_return_status Return status after the call. The status can
516 * be FND_API.G_RET_STS_SUCCESS (success),
517 * FND_API.G_RET_STS_ERROR (error),
518 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
519 * x_msg_count Number of messages in message stack.
520 * x_msg_data Message text if x_msg_count is 1.
521 *
522 * NOTES
523 *
524 * MODIFICATION HISTORY
528 */
525 *
526 * 07-23-2001 Indrajit Sen o Created.
527 *
529
530 /*#
531 * Use this routine to update a record about a group. This API updates the party record for
532 * the group in the HZ_PARTIES table.
533 * @rep:scope public
534 * @rep:lifecycle active
535 * @rep:displayname Update Group
536 * @rep:businessevent oracle.apps.ar.hz.Group.update
537 * @rep:doccd 120hztig.pdf Party APIs, Oracle Trading Community Architecture Technical Implementation Guide
538 */
539 PROCEDURE update_group (
540 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
541 p_group_rec IN GROUP_REC_TYPE,
542 p_party_object_version_number IN OUT NOCOPY NUMBER,
543 x_return_status OUT NOCOPY VARCHAR2,
544 x_msg_count OUT NOCOPY NUMBER,
545 x_msg_data OUT NOCOPY VARCHAR2
546 );
547
548 /**
549 * PROCEDURE create_organization
550 *
551 * DESCRIPTION
552 * Creates organization.
553 *
554 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
555 *
556 * ARGUMENTS
557 * IN:
558 * p_init_msg_list Initialize message stack if it is set to
559 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
560 * p_organization_rec Organization record.
561 * IN/OUT:
562 * OUT:
563 * x_party_id Party ID.
564 * x_party_number Party number.
565 * x_profile_id Organization profile ID.
566 * x_return_status Return status after the call. The status can
567 * be FND_API.G_RET_STS_SUCCESS (success),
568 * FND_API.G_RET_STS_ERROR (error),
569 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
570 * x_msg_count Number of messages in message stack.
571 * x_msg_data Message text if x_msg_count is 1.
572 *
573 * NOTES
574 *
575 * MODIFICATION HISTORY
576 *
577 * 07-23-2001 Indrajit Sen o Created.
578 *
579 */
580
581 /*#
582 * Use this routine to create a record about an organization. This API creates records in
583 * the HZ_PARTIES table with Organization party type. The HZ_PARTIES table stores basic
584 * information about the party. The API also creates a record in the
585 * HZ_ORGANIZATION_PROFILES table. That record holds more detailed and specific information
586 * about the organization.
587 * @rep:scope public
588 * @rep:lifecycle active
589 * @rep:displayname Create Organization
590 * @rep:businessevent oracle.apps.ar.hz.Organization.create
591 * @rep:doccd 120hztig.pdf Party APIs, Oracle Trading Community Architecture Technical Implementation Guide
592 */
593 PROCEDURE create_organization (
594 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
595 p_organization_rec IN ORGANIZATION_REC_TYPE,
596 x_return_status OUT NOCOPY VARCHAR2,
597 x_msg_count OUT NOCOPY NUMBER,
598 x_msg_data OUT NOCOPY VARCHAR2,
599 x_party_id OUT NOCOPY NUMBER,
600 x_party_number OUT NOCOPY VARCHAR2,
601 x_profile_id OUT NOCOPY NUMBER
602 );
603
604 /**
605 * PROCEDURE create_organization
606 *
607 * DESCRIPTION
608 * Creates organization.
609 *
610 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
611 *
612 * ARGUMENTS
613 * IN:
614 * p_init_msg_list Initialize message stack if it is set to
615 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
616 * p_organization_rec Organization record.
617 * p_party_usage_code Party Usage Code.
618 * IN/OUT:
619 * OUT:
620 * x_party_id Party ID.
621 * x_party_number Party number.
622 * x_profile_id Organization profile ID.
623 * x_return_status Return status after the call. The status can
624 * be FND_API.G_RET_STS_SUCCESS (success),
625 * FND_API.G_RET_STS_ERROR (error),
626 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
627 * x_msg_count Number of messages in message stack.
628 * x_msg_data Message text if x_msg_count is 1.
629 *
630 * NOTES
631 *
632 * MODIFICATION HISTORY
633 *
634 * 05-15-2005 Jianying Huang o Created.
635 *
636 */
637
638 PROCEDURE create_organization (
639 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
640 p_organization_rec IN ORGANIZATION_REC_TYPE,
641 p_party_usage_code IN VARCHAR2,
642 x_return_status OUT NOCOPY VARCHAR2,
643 x_msg_count OUT NOCOPY NUMBER,
644 x_msg_data OUT NOCOPY VARCHAR2,
645 x_party_id OUT NOCOPY NUMBER,
646 x_party_number OUT NOCOPY VARCHAR2,
647 x_profile_id OUT NOCOPY NUMBER
648 );
649
650 /**
654 * Updates organization.
651 * PROCEDURE update_organization
652 *
653 * DESCRIPTION
655 *
656 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
657 *
658 * ARGUMENTS
659 * IN:
660 * p_init_msg_list Initialize message stack if it is set to
661 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
662 * p_organization_rec Organization record.
663 * IN/OUT:
664 * p_party_object_version_number Used for locking the being updated record.
665 * OUT:
666 * x_profile_id Organization profile ID.
667 * x_return_status Return status after the call. The status can
668 * be FND_API.G_RET_STS_SUCCESS (success),
669 * FND_API.G_RET_STS_ERROR (error),
670 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
671 * x_msg_count Number of messages in message stack.
672 * x_msg_data Message text if x_msg_count is 1.
673 *
674 * NOTES
675 *
676 * MODIFICATION HISTORY
677 *
678 * 07-23-2001 Indrajit Sen o Created.
679 *
680 */
681
682 /*#
683 * Use this routine to update a record about an organization. This API updates the party
684 * record for the organization in the HZ_PARTIES table. The API also creates or updates a
685 * record in the HZ_ORGANIZATION_PROFILES table. If the record about an organization is
686 * updated on the same day that it is created, then the active profile record is updated.
687 * Otherwise, a new profile record that is created and an end date is assigned to the old
688 * profile record.
689 * @rep:scope public
690 * @rep:lifecycle active
691 * @rep:displayname Update Organization
692 * @rep:businessevent oracle.apps.ar.hz.Organization.update
693 * @rep:doccd 120hztig.pdf Party APIs, Oracle Trading Community Architecture Technical Implementation Guide
694 */
695 PROCEDURE update_organization (
696 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
697 p_organization_rec IN ORGANIZATION_REC_TYPE,
698 p_party_object_version_number IN OUT NOCOPY NUMBER,
699 x_profile_id OUT NOCOPY NUMBER,
700 x_return_status OUT NOCOPY VARCHAR2,
701 x_msg_count OUT NOCOPY NUMBER,
702 x_msg_data OUT NOCOPY VARCHAR2
703 );
704
705 /**
706 * PROCEDURE get_party_rec
707 *
708 * DESCRIPTION
709 * Gets party record.
710 *
711 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
712 *
713 * ARGUMENTS
714 * IN:
715 * p_init_msg_list Initialize message stack if it is set to
716 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
717 * p_party_id Party ID.
718 * IN/OUT:
719 * OUT:
720 * x_party_rec Returned party record.
721 * x_return_status Return status after the call. The status can
722 * be FND_API.G_RET_STS_SUCCESS (success),
723 * FND_API.G_RET_STS_ERROR (error),
724 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
725 * x_msg_count Number of messages in message stack.
726 * x_msg_data Message text if x_msg_count is 1.
727 *
728 * NOTES
729 *
730 * MODIFICATION HISTORY
731 *
732 * 07-23-2001 Indrajit Sen o Created.
733 *
734 */
735
736 PROCEDURE get_party_rec (
737 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
738 p_party_id IN NUMBER,
739 x_party_rec OUT NOCOPY PARTY_REC_TYPE,
740 x_return_status OUT NOCOPY VARCHAR2,
741 x_msg_count OUT NOCOPY NUMBER,
742 x_msg_data OUT NOCOPY VARCHAR2
743 );
744
745 /**
746 * PROCEDURE get_organization_rec
747 *
748 * DESCRIPTION
749 * Gets organization record.
750 *
751 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
752 *
753 * ARGUMENTS
754 * IN:
755 * p_init_msg_list Initialize message stack if it is set to
756 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
757 * p_party_id Party ID.
758 * p_content_source_type Content source type.
759 * IN/OUT:
760 * OUT:
761 * x_organization_rec Returned organization record.
762 * x_return_status Return status after the call. The status can
763 * be FND_API.G_RET_STS_SUCCESS (success),
764 * FND_API.G_RET_STS_ERROR (error),
765 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
766 * x_msg_count Number of messages in message stack.
767 * x_msg_data Message text if x_msg_count is 1.
768 *
769 * NOTES
770 *
771 * MODIFICATION HISTORY
772 *
773 * 07-23-2001 Indrajit Sen o Created.
774 *
775 */
776
777 PROCEDURE get_organization_rec (
781 x_organization_rec OUT NOCOPY ORGANIZATION_REC_TYPE,
778 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
779 p_party_id IN NUMBER,
780 p_content_source_type IN VARCHAR2 := G_MISS_CONTENT_SOURCE_TYPE,
782 x_return_status OUT NOCOPY VARCHAR2,
783 x_msg_count OUT NOCOPY NUMBER,
784 x_msg_data OUT NOCOPY VARCHAR2
785 );
786
787 /**
788 * PROCEDURE get_person_rec
789 *
790 * DESCRIPTION
791 * Gets person record.
792 *
793 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
794 *
795 * ARGUMENTS
796 * IN:
797 * p_init_msg_list Initialize message stack if it is set to
798 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
799 * p_party_id Party ID.
800 * p_content_source_type Content source type.
801 * IN/OUT:
802 * OUT:
803 * x_person_rec Returned person record.
804 * x_return_status Return status after the call. The status can
805 * be FND_API.G_RET_STS_SUCCESS (success),
806 * FND_API.G_RET_STS_ERROR (error),
807 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
808 * x_msg_count Number of messages in message stack.
809 * x_msg_data Message text if x_msg_count is 1.
810 *
811 * NOTES
812 *
813 * MODIFICATION HISTORY
814 *
815 * 07-23-2001 Indrajit Sen o Created.
816 *
817 */
818
819 PROCEDURE get_person_rec (
820 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
824 x_return_status OUT NOCOPY VARCHAR2,
821 p_party_id IN NUMBER,
822 p_content_source_type IN VARCHAR2 := G_MISS_CONTENT_SOURCE_TYPE,
823 x_person_rec OUT NOCOPY PERSON_REC_TYPE,
825 x_msg_count OUT NOCOPY NUMBER,
826 x_msg_data OUT NOCOPY VARCHAR2
827 );
828
829 /**
830 * PROCEDURE get_group_rec
831 *
832 * DESCRIPTION
833 * Gets group record.
834 *
835 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
836 *
837 * ARGUMENTS
838 * IN:
839 * p_init_msg_list Initialize message stack if it is set to
840 * FND_API.G_TRUE. Default is fnd_api.g_false.
841 * p_party_id Party ID.
842 * IN/OUT:
843 * OUT:
844 * x_group_rec Returned group record.
845 * x_return_status Return status after the call. The status can
846 * be fnd_api.g_ret_sts_success (success),
847 * fnd_api.g_ret_sts_error (error),
848 * fnd_api.g_ret_sts_unexp_error (unexpected error).
849 * x_msg_count Number of messages in message stack.
850 * x_msg_data Message text if x_msg_count is 1.
851 *
852 * NOTES
853 *
854 * MODIFICATION HISTORY
855 *
856 * 04-25-2002 Jianying Huang o Created.
857 *
858 */
859
860 PROCEDURE get_group_rec (
861 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
862 p_party_id IN NUMBER,
863 x_group_rec OUT NOCOPY GROUP_REC_TYPE,
864 x_return_status OUT NOCOPY VARCHAR2,
865 x_msg_count OUT NOCOPY NUMBER,
866 x_msg_data OUT NOCOPY VARCHAR2
867 );
868
869 END HZ_PARTY_V2PUB;