199: *
200: * ARGUMENTS
201: * IN:
202: * p_init_msg_list Initialize message stack if it is set to
203: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
204: * p_cust_acct_site_rec Customer account site record.
205: * IN/OUT:
206: * OUT:
207: * x_cust_acct_site_id Customer account site ID.
205: * IN/OUT:
206: * OUT:
207: * x_cust_acct_site_id Customer account site ID.
208: * x_return_status Return status after the call. The status can
209: * be FND_API.G_RET_STS_SUCCESS (success),
210: * FND_API.G_RET_STS_ERROR (error),
211: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
212: * x_msg_count Number of messages in message stack.
213: * x_msg_data Message text if x_msg_count is 1.
206: * OUT:
207: * x_cust_acct_site_id Customer account site ID.
208: * x_return_status Return status after the call. The status can
209: * be FND_API.G_RET_STS_SUCCESS (success),
210: * FND_API.G_RET_STS_ERROR (error),
211: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
212: * x_msg_count Number of messages in message stack.
213: * x_msg_data Message text if x_msg_count is 1.
214: *
207: * x_cust_acct_site_id Customer account site ID.
208: * x_return_status Return status after the call. The status can
209: * be FND_API.G_RET_STS_SUCCESS (success),
210: * FND_API.G_RET_STS_ERROR (error),
211: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
212: * x_msg_count Number of messages in message stack.
213: * x_msg_data Message text if x_msg_count is 1.
214: *
215: * NOTES
233: * @rep:businessevent oracle.apps.ar.hz.CustAcctSite.create
234: * @rep:doccd 120hztig.pdf Customer Account Site APIs, Oracle Trading Community Architecture Technical Implementation Guide
235: */
236: PROCEDURE create_cust_acct_site (
237: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
238: p_cust_acct_site_rec IN CUST_ACCT_SITE_REC_TYPE,
239: x_cust_acct_site_id OUT NOCOPY NUMBER,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
252: *
253: * ARGUMENTS
254: * IN:
255: * p_init_msg_list Initialize message stack if it is set to
256: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
257: * p_cust_acct_site_rec Customer account site record.
258: * IN/OUT:
259: * p_object_version_number Used for locking the being updated record.
260: * OUT:
258: * IN/OUT:
259: * p_object_version_number Used for locking the being updated record.
260: * OUT:
261: * x_return_status Return status after the call. The status can
262: * be FND_API.G_RET_STS_SUCCESS (success),
263: * FND_API.G_RET_STS_ERROR (error),
264: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
265: * x_msg_count Number of messages in message stack.
266: * x_msg_data Message text if x_msg_count is 1.
259: * p_object_version_number Used for locking the being updated record.
260: * OUT:
261: * x_return_status Return status after the call. The status can
262: * be FND_API.G_RET_STS_SUCCESS (success),
263: * FND_API.G_RET_STS_ERROR (error),
264: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
265: * x_msg_count Number of messages in message stack.
266: * x_msg_data Message text if x_msg_count is 1.
267: *
260: * OUT:
261: * x_return_status Return status after the call. The status can
262: * be FND_API.G_RET_STS_SUCCESS (success),
263: * FND_API.G_RET_STS_ERROR (error),
264: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
265: * x_msg_count Number of messages in message stack.
266: * x_msg_data Message text if x_msg_count is 1.
267: *
268: * NOTES
284: * @rep:businessevent oracle.apps.ar.hz.CustAcctSite.update
285: * @rep:doccd 120hztig.pdf Customer Account Site APIs, Oracle Trading Community Architecture Technical Implementation Guide
286: */
287: PROCEDURE update_cust_acct_site (
288: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
289: p_cust_acct_site_rec IN CUST_ACCT_SITE_REC_TYPE,
290: p_object_version_number IN OUT NOCOPY NUMBER,
291: x_return_status OUT NOCOPY VARCHAR2,
292: x_msg_count OUT NOCOPY NUMBER,
303: *
304: * ARGUMENTS
305: * IN:
306: * p_init_msg_list Initialize message stack if it is set to
307: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
308: * p_cust_acct_site_id Customer account site id.
309: * IN/OUT:
310: * OUT:
311: * x_cust_acct_site_rec Returned customer account site record.
309: * IN/OUT:
310: * OUT:
311: * x_cust_acct_site_rec Returned customer account site record.
312: * x_return_status Return status after the call. The status can
313: * be FND_API.G_RET_STS_SUCCESS (success),
314: * FND_API.G_RET_STS_ERROR (error),
315: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
316: * x_msg_count Number of messages in message stack.
317: * x_msg_data Message text if x_msg_count is 1.
310: * OUT:
311: * x_cust_acct_site_rec Returned customer account site record.
312: * x_return_status Return status after the call. The status can
313: * be FND_API.G_RET_STS_SUCCESS (success),
314: * FND_API.G_RET_STS_ERROR (error),
315: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
316: * x_msg_count Number of messages in message stack.
317: * x_msg_data Message text if x_msg_count is 1.
318: *
311: * x_cust_acct_site_rec Returned customer account site record.
312: * x_return_status Return status after the call. The status can
313: * be FND_API.G_RET_STS_SUCCESS (success),
314: * FND_API.G_RET_STS_ERROR (error),
315: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
316: * x_msg_count Number of messages in message stack.
317: * x_msg_data Message text if x_msg_count is 1.
318: *
319: * NOTES
324: *
325: */
326:
327: PROCEDURE get_cust_acct_site_rec (
328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
329: p_cust_acct_site_id IN NUMBER,
330: x_cust_acct_site_rec OUT NOCOPY CUST_ACCT_SITE_REC_TYPE,
331: x_return_status OUT NOCOPY VARCHAR2,
332: x_msg_count OUT NOCOPY NUMBER,
343: *
344: * ARGUMENTS
345: * IN:
346: * p_init_msg_list Initialize message stack if it is set to
347: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
348: * p_cust_site_use_rec Customer account site use record.
349: * p_customer_profile_rec Customer profile record. One customer account
350: * must have a customer profile.
351: * p_create_profile If it is set to FND_API.G_TRUE, API create customer
347: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
348: * p_cust_site_use_rec Customer account site use record.
349: * p_customer_profile_rec Customer profile record. One customer account
350: * must have a customer profile.
351: * p_create_profile If it is set to FND_API.G_TRUE, API create customer
352: * profile based on the customer profile record passed
353: * in.
354: * p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer
355: * profile amounts by copying corresponding data
350: * must have a customer profile.
351: * p_create_profile If it is set to FND_API.G_TRUE, API create customer
352: * profile based on the customer profile record passed
353: * in.
354: * p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer
355: * profile amounts by copying corresponding data
356: * from customer profile class amounts.
357: * IN/OUT:
358: * OUT:
357: * IN/OUT:
358: * OUT:
359: * x_site_use_id Customer account site use ID.
360: * x_return_status Return status after the call. The status can
361: * be FND_API.G_RET_STS_SUCCESS (success),
362: * FND_API.G_RET_STS_ERROR (error),
363: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
364: * x_msg_count Number of messages in message stack.
365: * x_msg_data Message text if x_msg_count is 1.
358: * OUT:
359: * x_site_use_id Customer account site use ID.
360: * x_return_status Return status after the call. The status can
361: * be FND_API.G_RET_STS_SUCCESS (success),
362: * FND_API.G_RET_STS_ERROR (error),
363: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
364: * x_msg_count Number of messages in message stack.
365: * x_msg_data Message text if x_msg_count is 1.
366: *
359: * x_site_use_id Customer account site use ID.
360: * x_return_status Return status after the call. The status can
361: * be FND_API.G_RET_STS_SUCCESS (success),
362: * FND_API.G_RET_STS_ERROR (error),
363: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
364: * x_msg_count Number of messages in message stack.
365: * x_msg_data Message text if x_msg_count is 1.
366: *
367: * NOTES
386: * @rep:businessevent oracle.apps.ar.hz.CustAcctSiteUse.create
387: * @rep:doccd 120hztig.pdf Customer Account Site APIs, Oracle Trading Community Architecture Technical Implementation Guide
388: */
389: PROCEDURE create_cust_site_use (
390: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
391: p_cust_site_use_rec IN CUST_SITE_USE_REC_TYPE,
392: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
393: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
394: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
389: PROCEDURE create_cust_site_use (
390: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
391: p_cust_site_use_rec IN CUST_SITE_USE_REC_TYPE,
392: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
393: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
394: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
395: x_site_use_id OUT NOCOPY NUMBER,
396: x_return_status OUT NOCOPY VARCHAR2,
397: x_msg_count OUT NOCOPY NUMBER,
390: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
391: p_cust_site_use_rec IN CUST_SITE_USE_REC_TYPE,
392: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
393: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
394: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
395: x_site_use_id OUT NOCOPY NUMBER,
396: x_return_status OUT NOCOPY VARCHAR2,
397: x_msg_count OUT NOCOPY NUMBER,
398: x_msg_data OUT NOCOPY VARCHAR2
408: *
409: * ARGUMENTS
410: * IN:
411: * p_init_msg_list Initialize message stack if it is set to
412: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
413: * p_cust_site_use_rec Customer account site use record.
414: * IN/OUT:
415: * p_object_version_number Used for locking the being updated record.
416: * OUT:
414: * IN/OUT:
415: * p_object_version_number Used for locking the being updated record.
416: * OUT:
417: * x_return_status Return status after the call. The status can
418: * be FND_API.G_RET_STS_SUCCESS (success),
419: * FND_API.G_RET_STS_ERROR (error),
420: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
421: * x_msg_count Number of messages in message stack.
422: * x_msg_data Message text if x_msg_count is 1.
415: * p_object_version_number Used for locking the being updated record.
416: * OUT:
417: * x_return_status Return status after the call. The status can
418: * be FND_API.G_RET_STS_SUCCESS (success),
419: * FND_API.G_RET_STS_ERROR (error),
420: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
421: * x_msg_count Number of messages in message stack.
422: * x_msg_data Message text if x_msg_count is 1.
423: *
416: * OUT:
417: * x_return_status Return status after the call. The status can
418: * be FND_API.G_RET_STS_SUCCESS (success),
419: * FND_API.G_RET_STS_ERROR (error),
420: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
421: * x_msg_count Number of messages in message stack.
422: * x_msg_data Message text if x_msg_count is 1.
423: *
424: * NOTES
440: * @rep:businessevent oracle.apps.ar.hz.CustAcctSiteUse.update
441: * @rep:doccd 120hztig.pdf Customer Account Site APIs, Oracle Trading Community Architecture Technical Implementation Guide
442: */
443: PROCEDURE update_cust_site_use (
444: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
445: p_cust_site_use_rec IN CUST_SITE_USE_REC_TYPE,
446: p_object_version_number IN OUT NOCOPY NUMBER,
447: x_return_status OUT NOCOPY VARCHAR2,
448: x_msg_count OUT NOCOPY NUMBER,
459: *
460: * ARGUMENTS
461: * IN:
462: * p_init_msg_list Initialize message stack if it is set to
463: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
464: * p_cust_site_use_id Customer account site use id.
465: * IN/OUT:
466: * OUT:
467: * x_cust_site_use_rec Returned customer account site use record.
466: * OUT:
467: * x_cust_site_use_rec Returned customer account site use record.
468: * x_customer_profile_rec Returned customer profile record.
469: * x_return_status Return status after the call. The status can
470: * be FND_API.G_RET_STS_SUCCESS (success),
471: * FND_API.G_RET_STS_ERROR (error),
472: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
473: * x_msg_count Number of messages in message stack.
474: * x_msg_data Message text if x_msg_count is 1.
467: * x_cust_site_use_rec Returned customer account site use record.
468: * x_customer_profile_rec Returned customer profile record.
469: * x_return_status Return status after the call. The status can
470: * be FND_API.G_RET_STS_SUCCESS (success),
471: * FND_API.G_RET_STS_ERROR (error),
472: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
473: * x_msg_count Number of messages in message stack.
474: * x_msg_data Message text if x_msg_count is 1.
475: *
468: * x_customer_profile_rec Returned customer profile record.
469: * x_return_status Return status after the call. The status can
470: * be FND_API.G_RET_STS_SUCCESS (success),
471: * FND_API.G_RET_STS_ERROR (error),
472: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
473: * x_msg_count Number of messages in message stack.
474: * x_msg_data Message text if x_msg_count is 1.
475: *
476: * NOTES
481: *
482: */
483:
484: PROCEDURE get_cust_site_use_rec (
485: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
486: p_site_use_id IN NUMBER,
487: x_cust_site_use_rec OUT NOCOPY CUST_SITE_USE_REC_TYPE,
488: x_customer_profile_rec OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
489: x_return_status OUT NOCOPY VARCHAR2,