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,
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:
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.
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: *
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
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,
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,
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,
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:
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.
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: *
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
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,
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,
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:
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.
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: *
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
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,
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.
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.
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: *
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
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,
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
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.
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: *
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
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
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.
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.
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: *
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
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,
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:
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.
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: *
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
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,
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.
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.
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: *
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.
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,
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:
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.
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: *
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
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,