1 PACKAGE HZ_CUST_ACCOUNT_V2PUB AUTHID CURRENT_USER AS
2 /*$Header: ARH2CASS.pls 120.13 2011/12/16 11:25:07 rgokavar ship $ */
3 /*#
4 * This package contains the public APIs for customer accounts and related entities.
5 * @rep:scope public
6 * @rep:product HZ
7 * @rep:displayname Customer Account
8 * @rep:category BUSINESS_ENTITY HZ_CUSTOMER_ACCOUNT
9 * @rep:category BUSINESS_ENTITY HZ_ORGANIZATION
10 * @rep:category BUSINESS_ENTITY HZ_PERSON
11 * @rep:lifecycle active
12 * @rep:doccd 120hztig.pdf Customer Account APIs, Oracle Trading Community Architecture Technical Implementation Guide
13 */
14
15 --------------------------------------
16 -- declaration of record type
17 --------------------------------------
18
19 TYPE cust_account_rec_type IS RECORD (
20 cust_account_id NUMBER,
21 account_number VARCHAR2(30),
22 attribute_category VARCHAR2(30),
23 attribute1 VARCHAR2(150),
24 attribute2 VARCHAR2(150),
25 attribute3 VARCHAR2(150),
26 attribute4 VARCHAR2(150),
27 attribute5 VARCHAR2(150),
28 attribute6 VARCHAR2(150),
29 attribute7 VARCHAR2(150),
30 attribute8 VARCHAR2(150),
31 attribute9 VARCHAR2(150),
32 attribute10 VARCHAR2(150),
33 attribute11 VARCHAR2(150),
34 attribute12 VARCHAR2(150),
35 attribute13 VARCHAR2(150),
36 attribute14 VARCHAR2(150),
37 attribute15 VARCHAR2(150),
38 attribute16 VARCHAR2(150),
39 attribute17 VARCHAR2(150),
40 attribute18 VARCHAR2(150),
41 attribute19 VARCHAR2(150),
42 attribute20 VARCHAR2(150),
43 global_attribute_category VARCHAR2(30),
44 global_attribute1 VARCHAR2(150),
45 global_attribute2 VARCHAR2(150),
46 global_attribute3 VARCHAR2(150),
47 global_attribute4 VARCHAR2(150),
48 global_attribute5 VARCHAR2(150),
49 global_attribute6 VARCHAR2(150),
50 global_attribute7 VARCHAR2(150),
51 global_attribute8 VARCHAR2(150),
52 global_attribute9 VARCHAR2(150),
53 global_attribute10 VARCHAR2(150),
54 global_attribute11 VARCHAR2(150),
55 global_attribute12 VARCHAR2(150),
56 global_attribute13 VARCHAR2(150),
57 global_attribute14 VARCHAR2(150),
58 global_attribute15 VARCHAR2(150),
59 global_attribute16 VARCHAR2(150),
60 global_attribute17 VARCHAR2(150),
61 global_attribute18 VARCHAR2(150),
62 global_attribute19 VARCHAR2(150),
63 global_attribute20 VARCHAR2(150),
64 orig_system_reference VARCHAR2(240),
65 orig_system VARCHAR2(30),
66 status VARCHAR2(1),
67 customer_type VARCHAR2(30),
68 customer_class_code VARCHAR2(30),
69 primary_salesrep_id NUMBER,
70 sales_channel_code VARCHAR2(30),
71 order_type_id NUMBER,
72 price_list_id NUMBER,
73 tax_code VARCHAR2(50),
74 fob_point VARCHAR2(30),
75 freight_term VARCHAR2(30),
76 ship_partial VARCHAR2(1),
77 ship_via VARCHAR2(30),
78 warehouse_id NUMBER,
79 tax_header_level_flag VARCHAR2(1),
80 tax_rounding_rule VARCHAR2(30),
81 coterminate_day_month VARCHAR2(6),
82 primary_specialist_id NUMBER,
83 secondary_specialist_id NUMBER,
84 account_liable_flag VARCHAR2(1),
85 current_balance NUMBER,
86 account_established_date DATE,
87 account_termination_date DATE,
88 account_activation_date DATE,
89 department VARCHAR2(30),
90 held_bill_expiration_date DATE,
91 hold_bill_flag VARCHAR2(1),
92 realtime_rate_flag VARCHAR2(1),
93 acct_life_cycle_status VARCHAR2(30),
94 account_name VARCHAR2(240),
95 deposit_refund_method VARCHAR2(20),
96 dormant_account_flag VARCHAR2(1),
97 npa_number VARCHAR2(60),
98 suspension_date DATE,
99 source_code VARCHAR2(150),
100 comments VARCHAR2(240),
101 dates_negative_tolerance NUMBER,
102 dates_positive_tolerance NUMBER,
103 date_type_preference VARCHAR2(20),
104 over_shipment_tolerance NUMBER,
105 under_shipment_tolerance NUMBER,
106 over_return_tolerance NUMBER,
107 under_return_tolerance NUMBER,
108 item_cross_ref_pref VARCHAR2(30),
109 ship_sets_include_lines_flag VARCHAR2(1),
110 arrivalsets_include_lines_flag VARCHAR2(1),
111 sched_date_push_flag VARCHAR2(1),
112 invoice_quantity_rule VARCHAR2(30),
113 pricing_event VARCHAR2(30),
114 status_update_date DATE,
115 autopay_flag VARCHAR2(1),
116 notify_flag VARCHAR2(1),
117 last_batch_id NUMBER,
118 selling_party_id NUMBER,
119 created_by_module VARCHAR2(150),
120 application_id NUMBER,
121 federal_entity_type VARCHAR2(30),
122 trading_partner_agency_id VARCHAR2(3),
123 duns_extension VARCHAR2(4),
124 advance_payment_indicator VARCHAR2(30)
125 );
126
127 TYPE cust_acct_relate_rec_type IS RECORD (
128 cust_account_id NUMBER,
129 related_cust_account_id NUMBER,
130 relationship_type VARCHAR2(30),
131 comments VARCHAR2(240),
132 attribute_category VARCHAR2(30),
133 attribute1 VARCHAR2(150),
134 attribute2 VARCHAR2(150),
135 attribute3 VARCHAR2(150),
136 attribute4 VARCHAR2(150),
137 attribute5 VARCHAR2(150),
138 attribute6 VARCHAR2(150),
139 attribute7 VARCHAR2(150),
140 attribute8 VARCHAR2(150),
141 attribute9 VARCHAR2(150),
142 attribute10 VARCHAR2(150),
143 customer_reciprocal_flag VARCHAR2(1),
144 status VARCHAR2(1),
145 attribute11 VARCHAR2(150),
146 attribute12 VARCHAR2(150),
147 attribute13 VARCHAR2(150),
148 attribute14 VARCHAR2(150),
149 attribute15 VARCHAR2(150),
150 bill_to_flag VARCHAR2(1),
151 ship_to_flag VARCHAR2(1),
152 created_by_module VARCHAR2(150),
153 application_id NUMBER,
154 org_id NUMBER, /* Bug 3456489 */
155 cust_acct_relate_id NUMBER -- Bug 4529413
156 );
157
158 --------------------------------------
159 -- declaration of public procedures and functions
160 --------------------------------------
161
162 /**
163 * PROCEDURE create_cust_account
164 *
165 * DESCRIPTION
166 * Creates customer account for person party.
167 *
168 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
169 * HZ_PARTY_V2PUB.create_person
170 * HZ_CUSTOMER_PROFIE_V2PUB.create_customer_profile
171 *
172 * ARGUMENTS
173 * IN:
174 * p_init_msg_list Initialize message stack if it is set to
175 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
176 * p_cust_account_rec Customer account record.
177 * p_person_rec Person party record which being created account
178 * belongs to. If party_id in person record is not
179 * passed in or party_id does not exist in hz_parties,
180 * API ceates a person party based on this record.
181 * p_customer_profile_rec Customer profile record. One customer account
182 * must have a customer profile.
183 * p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer
184 * profile amounts by copying corresponding data
185 * from customer profile class amounts.
186 * IN/OUT:
187 * OUT:
188 * x_cust_account_id Customer account ID.
189 * x_account_number Customer account number.
190 * x_party_id Party ID of the person party which this account
191 * belongs to.
192 * x_party_number Party number of the person party which this account
193 * belongs to.
194 * x_profile_id Person profile ID.
195 * x_return_status Return status after the call. The status can
196 * be FND_API.G_RET_STS_SUCCESS (success),
197 * FND_API.G_RET_STS_ERROR (error),
198 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
199 * x_msg_count Number of messages in message stack.
200 * x_msg_data Message text if x_msg_count is 1.
201 *
202 * NOTES
203 *
204 * MODIFICATION HISTORY
205 *
206 * 07-23-2001 Jianying Huang o Created.
207 *
208 */
209 /*#
210 * Use this routine to create a customer account. The API creates records in the
211 * HZ_CUST_ACCOUNTS table for the Person party type. You can create a customer account for
212 * an existing party by passing the party_id value of the party. Alternatively, this
213 * routine creates a new party and an account for that party. You can also create a
214 * customer profile record in the HZ_CUSTOMER_PROFILES table, while calling this routine
215 * based on value passed in p_customer_profile_rec. This routine is overloaded for Person
216 * and Organization. If an orig_system_reference is passed in, then the API creates a
217 * record in the HZ_ORIG_SYS_REFERENCES table to store the mapping between the source
218 * system reference and the TCA primary key. If orig_system_reference is not passed in,
219 * then the default is UNKNOWN.
220 * @rep:scope public
221 * @rep:lifecycle active
222 * @rep:displayname Create Customer Account (For Person party)
223 * @rep:businessevent oracle.apps.ar.hz.CustAccount.create
224 * @rep:doccd 120hztig.pdf Customer Account APIs, Oracle Trading Community Architecture Technical Implementation Guide
225 */
226 PROCEDURE create_cust_account (
227 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
228 p_cust_account_rec IN CUST_ACCOUNT_REC_TYPE,
229 p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
230 p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
231 p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
232 x_cust_account_id OUT NOCOPY NUMBER,
233 x_account_number OUT NOCOPY VARCHAR2,
234 x_party_id OUT NOCOPY NUMBER,
235 x_party_number OUT NOCOPY VARCHAR2,
236 x_profile_id OUT NOCOPY NUMBER,
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2
240 );
241
242 /**
243 * PROCEDURE create_cust_account
244 *
245 * DESCRIPTION
246 * Creates customer account for organization party.
247 *
248 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
249 * HZ_PARTY_V2PUB.create_organization
250 * HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile
251 *
252 * ARGUMENTS
253 * IN:
254 * p_init_msg_list Initialize message stack if it is set to
255 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
256 * p_cust_account_rec Customer account record.
257 * p_organization_rec Organization party record which being created account
258 * belongs to. If party_id in organization record is not
259 * passed in or party_id does not exist in hz_parties,
260 * API ceates a organization party based on this record.
261 * p_customer_profile_rec Customer profile record. One customer account
262 * must have a customer profile.
263 * p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer
264 * profile amounts by copying corresponding data
265 * from customer profile class amounts.
266 * IN/OUT:
267 * OUT:
268 * x_cust_account_id Customer account ID.
269 * x_account_number Customer account number.
270 * x_party_id Party ID of the organization party which this account
271 * belongs to.
272 * x_party_number Party number of the organization party which this
273 * account belongs to.
274 * x_profile_id Organization profile ID.
275 * x_return_status Return status after the call. The status can
276 * be FND_API.G_RET_STS_SUCCESS (success),
277 * FND_API.G_RET_STS_ERROR (error),
278 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
279 * x_msg_count Number of messages in message stack.
280 * x_msg_data Message text if x_msg_count is 1.
281 *
282 * NOTES
283 *
284 * MODIFICATION HISTORY
285 *
286 * 07-23-2001 Jianying Huang o Created.
287 *
288 */
289 /*#
290 * Use this routine to create a customer account. This API creates records in the
291 * HZ_CUST_ACCOUNTS table for the Organization party type. You can create an account for
292 * an existing party by passing party_id of the party. Alternatively, you can use this
293 * routine to create a new party and an account for that party. You can also create a
294 * customer profile record in the HZ_CUSTOMER_PROFILES table, while calling this routine
295 * based on the value passed in p_customer_profile_rec. This routine is overloaded for
296 * Person and Organization. If an orig_system_reference is passed in, then the API creates
297 * a record in the HZ_ORIG_SYS_REFERENCES table to store the mapping between the source
298 * system reference and the TCA primary key. If orig_system_reference is not passed in,
299 * then the default is UNKNOWN.
300 * @rep:scope public
301 * @rep:lifecycle active
302 * @rep:displayname Create Customer Account (For Organization party)
303 * @rep:businessevent oracle.apps.ar.hz.CustAccount.create
304 * @rep:doccd 120hztig.pdf Customer Account APIs, Oracle Trading Community Architecture Technical Implementation Guide
305 */
306 PROCEDURE create_cust_account (
307 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
308 p_cust_account_rec IN CUST_ACCOUNT_REC_TYPE,
309 p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
310 p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
311 p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
312 x_cust_account_id OUT NOCOPY NUMBER,
313 x_account_number OUT NOCOPY VARCHAR2,
314 x_party_id OUT NOCOPY NUMBER,
315 x_party_number OUT NOCOPY VARCHAR2,
316 x_profile_id OUT NOCOPY NUMBER,
317 x_return_status OUT NOCOPY VARCHAR2,
318 x_msg_count OUT NOCOPY NUMBER,
319 x_msg_data OUT NOCOPY VARCHAR2
320 );
321
322 /**
323 * PROCEDURE update_cust_account
324 *
325 * DESCRIPTION
326 * Updates customer account.
327 *
328 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
329 *
330 * ARGUMENTS
331 * IN:
332 * p_init_msg_list Initialize message stack if it is set to
333 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
334 * p_cust_account_rec Customer account record.
335 * IN/OUT:
336 * p_object_version_number Used for locking the being updated record.
337 * OUT:
338 * x_return_status Return status after the call. The status can
339 * be FND_API.G_RET_STS_SUCCESS (success),
340 * FND_API.G_RET_STS_ERROR (error),
341 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
342 * x_msg_count Number of messages in message stack.
343 * x_msg_data Message text if x_msg_count is 1.
344 *
345 * NOTES
346 *
347 * MODIFICATION HISTORY
348 *
349 * 07-23-2001 Jianying Huang o Created.
350 *
351 */
352 /*#
353 * Use this routine to update a customer account. This API updates records in the
354 * HZ_CUST_ACCOUNTS table. The customer account can belong to a party of type
355 * Person or Organization. The same routine updates all types of accounts,
356 * whether the account belongs to a person or an organization. If the primary key is not
357 * passed in, then get the primary key from the HZ_ORIG_SYS_REFERENCES table, based on
358 * orig_system and orig_system_reference. Note: orig_system and orig_system_reference must
359 * be unique and not null and unique.
360 * @rep:scope public
361 * @rep:lifecycle active
362 * @rep:displayname Update Customer Account
363 * @rep:businessevent oracle.apps.ar.hz.CustAccount.update
364 * @rep:doccd 120hztig.pdf Customer Account APIs, Oracle Trading Community Architecture Technical Implementation Guide
365 */
366 PROCEDURE update_cust_account (
367 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
368 p_cust_account_rec IN CUST_ACCOUNT_REC_TYPE,
369 p_object_version_number IN OUT NOCOPY NUMBER,
370 x_return_status OUT NOCOPY VARCHAR2,
371 x_msg_count OUT NOCOPY NUMBER,
372 x_msg_data OUT NOCOPY VARCHAR2
373 );
374
375 /**
376 * PROCEDURE get_cust_account_rec
377 *
378 * DESCRIPTION
379 * Gets customer account record
380 *
381 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
382 *
383 * ARGUMENTS
384 * IN:
385 * p_init_msg_list Initialize message stack if it is set to
386 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
387 * p_cust_account_id Customer account id.
388 * IN/OUT:
389 * OUT:
390 * x_cust_account_rec Returned customer account record.
391 * x_customer_profile_rec Returned customer profile record.
392 * x_return_status Return status after the call. The status can
393 * be FND_API.G_RET_STS_SUCCESS (success),
394 * FND_API.G_RET_STS_ERROR (error),
395 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
396 * x_msg_count Number of messages in message stack.
397 * x_msg_data Message text if x_msg_count is 1.
398 *
399 * NOTES
400 *
401 * MODIFICATION HISTORY
402 *
403 * 07-23-2001 Jianying Huang o Created.
404 *
405 */
406
407 PROCEDURE get_cust_account_rec (
408 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
409 p_cust_account_id IN NUMBER,
410 x_cust_account_rec OUT NOCOPY CUST_ACCOUNT_REC_TYPE,
411 x_customer_profile_rec OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
412 x_return_status OUT NOCOPY VARCHAR2,
413 x_msg_count OUT NOCOPY NUMBER,
414 x_msg_data OUT NOCOPY VARCHAR2
415 );
416
417 /**
418 * PROCEDURE create_cust_acct_relate ( signature 1)
419 *
420 * DESCRIPTION
421 * Creates relationship between two customer accounts.
422 *
423 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
424 *
425 * ARGUMENTS
426 * IN:
427 * p_init_msg_list Initialize message stack if it is set to
428 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
429 * p_cust_acct_relate_rec Customer account relate record.
430 * IN/OUT:
431 * OUT:
432 * x_return_status Return status after the call. The status can
433 * be FND_API.G_RET_STS_SUCCESS (success),
434 * FND_API.G_RET_STS_ERROR (error),
435 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
436 * x_msg_count Number of messages in message stack.
437 * x_msg_data Message text if x_msg_count is 1.
438 *
439 * NOTES
440 *
441 * MODIFICATION HISTORY
442 *
443 * 07-23-2001 Jianying Huang o Created.
444 *
445 */
446 /*#
447 * Use this routine to create a customer account relationship. This API creates records in
448 * the HZ_CUST_ACCT_RELATE table. You can use this process to relate two different
449 * customer accounts. Use the Relationship APIs to create relationships between parties.
450 * @rep:scope public
451 * @rep:lifecycle active
452 * @rep:displayname Create Customer Account Relationship
453 * @rep:businessevent oracle.apps.ar.hz.CustAcctRelate.create
454 * @rep:doccd 120hztig.pdf Customer Account APIs, Oracle Trading Community Architecture Technical Implementation Guide
455 */
456 PROCEDURE create_cust_acct_relate (
457 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
458 p_cust_acct_relate_rec IN CUST_ACCT_RELATE_REC_TYPE,
459 x_return_status OUT NOCOPY VARCHAR2,
460 x_msg_count OUT NOCOPY NUMBER,
461 x_msg_data OUT NOCOPY VARCHAR2
462 );
463
464
465
466 /**
467 * PROCEDURE create_cust_acct_relate ( signature 2)
468 *
469 * DESCRIPTION
470 * Creates relationship between two customer accounts.Overloaded with
471 * x_cust_acct_relate_id parameter.
472 *
473 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
474 *
475 * ARGUMENTS
476 * IN:
477 * p_init_msg_list Initialize message stack if it is set to
478 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
479 * p_cust_acct_relate_rec Customer account relate record.
480 * IN/OUT:
481 * OUT:
482 * x_cust_acct_relate_id Return primary key after creation of record.
483 * x_return_status Return status after the call. The status can
484 * be FND_API.G_RET_STS_SUCCESS (success),
485 * FND_API.G_RET_STS_ERROR (error),
486 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
487 * x_msg_count Number of messages in message stack.
488 * x_msg_data Message text if x_msg_count is 1.
489 *
490 * NOTES
491 *
492 * MODIFICATION HISTORY
493 *
494 * 08-23-2005 Idris Ali o Created.
495 *
496 */
497 /*#
498 * Use this routine to create a customer account relationship. This API creates records in
499 * the HZ_CUST_ACCT_RELATE table. You can use this process to relate two different
500 * customer accounts. Use the Relationship APIs to create relationships between parties.
501 * @rep:scope public
502 * @rep:lifecycle active
503 * @rep:displayname Create Customer Account Relationship
504 * @rep:businessevent oracle.apps.ar.hz.CustAcctRelate.create
505 * @rep:doccd 120hztig.pdf Customer Account APIs, Oracle Trading Community Architecture Technical Implementation Guide
506 */
507 PROCEDURE create_cust_acct_relate (
508 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
509 p_cust_acct_relate_rec IN CUST_ACCT_RELATE_REC_TYPE,
510 x_cust_acct_relate_id OUT NOCOPY NUMBER,
511 x_return_status OUT NOCOPY VARCHAR2,
512 x_msg_count OUT NOCOPY NUMBER,
513 x_msg_data OUT NOCOPY VARCHAR2
514 );
515
516
517 /**
518 * PROCEDURE update_cust_acct_relate (signature 1.)
519 *
520 * DESCRIPTION
521 * Updates relationship between two customer accounts.This will update the active
522 * record between the two customer accounts specified. To update an inactive record
523 * use the overloaded procedure update_cust_acct_relate which accepts rowid as
524 * parameter.
525 *
526 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
527 *
528 * ARGUMENTS
529 * IN:
530 * p_init_msg_list Initialize message stack if it is set to
531 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
532 * p_cust_acct_relate_rec Customer account relate record.
533 * IN/OUT:
534 * p_object_version_number Used for locking the being updated record.
535 * OUT:
536 * x_return_status Return status after the call. The status can
537 * be FND_API.G_RET_STS_SUCCESS (success),
538 * FND_API.G_RET_STS_ERROR (error),
539 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
540 * x_msg_count Number of messages in message stack.
541 * x_msg_data Message text if x_msg_count is 1.
542 *
543 * NOTES
544 *
545 * MODIFICATION HISTORY
546 *
547 * 07-23-2001 Jianying Huang o Created.
548 *
549 */
550 /*#
551 * Use this routine to update a customer account relationship. This API updates records
552 * in the HZ_CUST_ACCT_RELATE table.
553 * @rep:scope public
554 * @rep:lifecycle active
555 * @rep:displayname Update Customer Account Relationship
556 * @rep:businessevent oracle.apps.ar.hz.CustAcctRelate.update
557 * @rep:doccd 120hztig.pdf Customer Account APIs, Oracle Trading Community Architecture Technical Implementation Guide
558 */
559 PROCEDURE update_cust_acct_relate (
560 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
561 p_cust_acct_relate_rec IN CUST_ACCT_RELATE_REC_TYPE,
562 p_object_version_number IN OUT NOCOPY NUMBER,
563 x_return_status OUT NOCOPY VARCHAR2,
564 x_msg_count OUT NOCOPY NUMBER,
565 x_msg_data OUT NOCOPY VARCHAR2
566 );
567
568
569
570 /**
571 * PROCEDURE update_cust_acct_relate (signature 2.)
572 *
573 * DESCRIPTION
574 * Updates relationship between two customer accounts. This is the overloaded procedure
575 * which accepts the rowid of the record in HZ_CUST_ACCT_RELATE as a parameter.
576 *
577 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
578 *
579 * ARGUMENTS
580 * IN:
581 *
582 * p_init_msg_list Initialize message stack if it is set to
583 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
584 *
585 * p_cust_acct_relate_rec Customer account relate record.
586 *
587 * p_rowid Rowid of record in HZ_CUST_ACCT_RELATE.
588 *
589 * IN/OUT:
590 *
591 * p_object_version_number Used for locking the being updated record.
592 *
593 * OUT:
594 *
595 * x_return_status Return status after the call. The status can
596 * be FND_API.G_RET_STS_SUCCESS (success),
597 * FND_API.G_RET_STS_ERROR (error),
598 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
599 *
600 * x_msg_count Number of messages in message stack.
601 *
602 * x_msg_data Message text if x_msg_count is 1.
603 *
604 * NOTES
605 *
606 * MODIFICATION HISTORY
607 *
608 * 04-21-2004 Rajib Ranjan Borah o Bug 3449118. Created.
609 */
610
611 PROCEDURE update_cust_acct_relate (
612 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
613 p_cust_acct_relate_rec IN CUST_ACCT_RELATE_REC_TYPE,
614 p_rowid IN ROWID,
615 p_object_version_number IN OUT NOCOPY NUMBER,
616 x_return_status OUT NOCOPY VARCHAR2,
617 x_msg_count OUT NOCOPY NUMBER,
618 x_msg_data OUT NOCOPY VARCHAR2
619 );
620
621
622 /**
623 * PROCEDURE get_cust_acct_relate_rec
624 *
625 * DESCRIPTION
626 * Gets customer account relationship record
627 *
628 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
629 *
630 * ARGUMENTS
631 * IN:
632 * p_init_msg_list Initialize message stack if it is set to
633 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
634 * p_cust_account_id Customer account id.
635 * p_related_cust_account_id Related customer account id.
636 * p_cust_acct_relate_id Customer account relate id.
637 * IN/OUT:
638 * OUT:
639 * x_cust_acct_relate_rec Returned customer account relate record.
640 * x_return_status Return status after the call. The status can
641 * be FND_API.G_RET_STS_SUCCESS (success),
642 * FND_API.G_RET_STS_ERROR (error),
643 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
644 * x_msg_count Number of messages in message stack.
645 * x_msg_data Message text if x_msg_count is 1.
646 *
647 * NOTES
648 *
649 * MODIFICATION HISTORY
650 *
651 * 07-23-2001 Jianying Huang o Created.
652 * 04-20-2004 Rajib Ranjan Borah o Bug 3449118. Added rowid as parameter.
653 * 08-12-2004 Idris Ali o Bug 4529413. Added p_cust_acct_relate_id parameter
654 */
655
656 PROCEDURE get_cust_acct_relate_rec (
657 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
658 p_cust_account_id IN NUMBER,
659 p_related_cust_account_id IN NUMBER,
660 p_cust_acct_relate_id IN NUMBER, -- Bug 4529413
661 p_rowid IN ROWID,
662 x_cust_acct_relate_rec OUT NOCOPY CUST_ACCT_RELATE_REC_TYPE,
663 x_return_status OUT NOCOPY VARCHAR2,
664 x_msg_count OUT NOCOPY NUMBER,
665 x_msg_data OUT NOCOPY VARCHAR2
666 );
667
668 END HZ_CUST_ACCOUNT_V2PUB;