21: --
22: -- ARGUMENTS
23: -- IN:
24: -- p_init_msg_list Initialize message stack if it is set to
25: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
26: -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
27: -- the completeness of business object.
28: -- p_org_cust_obj Logical org customer account object.
29: -- p_created_by_module Created by module.
22: -- ARGUMENTS
23: -- IN:
24: -- p_init_msg_list Initialize message stack if it is set to
25: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
26: -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
27: -- the completeness of business object.
28: -- p_org_cust_obj Logical org customer account object.
29: -- p_created_by_module Created by module.
30: -- OUT:
28: -- p_org_cust_obj Logical org customer account object.
29: -- p_created_by_module Created by module.
30: -- OUT:
31: -- x_return_status Return status after the call. The status can
32: -- be fnd_api.g_ret_sts_success (success),
33: -- fnd_api.g_ret_sts_error (error),
34: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
35: -- x_msg_count Number of messages in message stack.
36: -- x_msg_data Message text if x_msg_count is 1.
29: -- p_created_by_module Created by module.
30: -- OUT:
31: -- x_return_status Return status after the call. The status can
32: -- be fnd_api.g_ret_sts_success (success),
33: -- fnd_api.g_ret_sts_error (error),
34: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
35: -- x_msg_count Number of messages in message stack.
36: -- x_msg_data Message text if x_msg_count is 1.
37: -- x_organization_id Organization ID.
30: -- OUT:
31: -- x_return_status Return status after the call. The status can
32: -- be fnd_api.g_ret_sts_success (success),
33: -- fnd_api.g_ret_sts_error (error),
34: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
35: -- x_msg_count Number of messages in message stack.
36: -- x_msg_data Message text if x_msg_count is 1.
37: -- x_organization_id Organization ID.
38: --
42: --
43: -- 14-DEC-2004 Arnold Ng Created.
44:
45: PROCEDURE create_org_cust_bo(
46: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
47: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
48: p_org_cust_obj IN HZ_ORG_CUST_BO,
49: p_created_by_module IN VARCHAR2,
50: x_return_status OUT NOCOPY VARCHAR2,
43: -- 14-DEC-2004 Arnold Ng Created.
44:
45: PROCEDURE create_org_cust_bo(
46: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
47: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
48: p_org_cust_obj IN HZ_ORG_CUST_BO,
49: p_created_by_module IN VARCHAR2,
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
74: * @rep:displayname Create Organization Customer Business Object
75: * @rep:doccd 120hztig.pdf Create Organization Customer Business Object, Oracle Trading Community Architecture Technical Implementation Guide
76: */
77: PROCEDURE create_org_cust_bo(
78: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
79: p_org_cust_obj IN HZ_ORG_CUST_BO,
80: p_created_by_module IN VARCHAR2,
81: p_obj_source IN VARCHAR2 := null,
82: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
78: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
79: p_org_cust_obj IN HZ_ORG_CUST_BO,
80: p_created_by_module IN VARCHAR2,
81: p_obj_source IN VARCHAR2 := null,
82: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
85: x_return_obj OUT NOCOPY HZ_ORG_CUST_BO,
86: x_organization_id OUT NOCOPY NUMBER
95: --
96: -- ARGUMENTS
97: -- IN:
98: -- p_init_msg_list Initialize message stack if it is set to
99: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
100: -- p_org_cust_obj Logical org customer account object.
101: -- p_created_by_module Created by module.
102: -- OUT:
103: -- x_return_status Return status after the call. The status can
100: -- p_org_cust_obj Logical org customer account object.
101: -- p_created_by_module Created by module.
102: -- OUT:
103: -- x_return_status Return status after the call. The status can
104: -- be fnd_api.g_ret_sts_success (success),
105: -- fnd_api.g_ret_sts_error (error),
106: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
107: -- x_msg_count Number of messages in message stack.
108: -- x_msg_data Message text if x_msg_count is 1.
101: -- p_created_by_module Created by module.
102: -- OUT:
103: -- x_return_status Return status after the call. The status can
104: -- be fnd_api.g_ret_sts_success (success),
105: -- fnd_api.g_ret_sts_error (error),
106: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
107: -- x_msg_count Number of messages in message stack.
108: -- x_msg_data Message text if x_msg_count is 1.
109: -- x_organization_id Organization ID.
102: -- OUT:
103: -- x_return_status Return status after the call. The status can
104: -- be fnd_api.g_ret_sts_success (success),
105: -- fnd_api.g_ret_sts_error (error),
106: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
107: -- x_msg_count Number of messages in message stack.
108: -- x_msg_data Message text if x_msg_count is 1.
109: -- x_organization_id Organization ID.
110: --
114: --
115: -- 14-DEC-2004 Arnold Ng Created.
116:
117: PROCEDURE update_org_cust_bo(
118: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
119: p_org_cust_obj IN HZ_ORG_CUST_BO,
120: p_created_by_module IN VARCHAR2,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
147: PROCEDURE update_org_cust_bo(
148: p_org_cust_obj IN HZ_ORG_CUST_BO,
149: p_created_by_module IN VARCHAR2,
150: p_obj_source IN VARCHAR2 := null,
151: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
154: x_return_obj OUT NOCOPY HZ_ORG_CUST_BO,
155: x_organization_id OUT NOCOPY NUMBER
164: --
165: -- ARGUMENTS
166: -- IN:
167: -- p_init_msg_list Initialize message stack if it is set to
168: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
169: -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
170: -- the completeness of business object.
171: -- p_org_cust_obj Logical org customer account object.
172: -- p_created_by_module Created by module.
165: -- ARGUMENTS
166: -- IN:
167: -- p_init_msg_list Initialize message stack if it is set to
168: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
169: -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
170: -- the completeness of business object.
171: -- p_org_cust_obj Logical org customer account object.
172: -- p_created_by_module Created by module.
173: -- OUT:
171: -- p_org_cust_obj Logical org customer account object.
172: -- p_created_by_module Created by module.
173: -- OUT:
174: -- x_return_status Return status after the call. The status can
175: -- be fnd_api.g_ret_sts_success (success),
176: -- fnd_api.g_ret_sts_error (error),
177: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
178: -- x_msg_count Number of messages in message stack.
179: -- x_msg_data Message text if x_msg_count is 1.
172: -- p_created_by_module Created by module.
173: -- OUT:
174: -- x_return_status Return status after the call. The status can
175: -- be fnd_api.g_ret_sts_success (success),
176: -- fnd_api.g_ret_sts_error (error),
177: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
178: -- x_msg_count Number of messages in message stack.
179: -- x_msg_data Message text if x_msg_count is 1.
180: -- x_organization_id Organization ID.
173: -- OUT:
174: -- x_return_status Return status after the call. The status can
175: -- be fnd_api.g_ret_sts_success (success),
176: -- fnd_api.g_ret_sts_error (error),
177: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
178: -- x_msg_count Number of messages in message stack.
179: -- x_msg_data Message text if x_msg_count is 1.
180: -- x_organization_id Organization ID.
181: --
185: --
186: -- 14-DEC-2004 Arnold Ng Created.
187:
188: PROCEDURE save_org_cust_bo(
189: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
190: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
191: p_org_cust_obj IN HZ_ORG_CUST_BO,
192: p_created_by_module IN VARCHAR2,
193: x_return_status OUT NOCOPY VARCHAR2,
186: -- 14-DEC-2004 Arnold Ng Created.
187:
188: PROCEDURE save_org_cust_bo(
189: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
190: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
191: p_org_cust_obj IN HZ_ORG_CUST_BO,
192: p_created_by_module IN VARCHAR2,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
220: * @rep:displayname Save Organization Customer Business Object
221: * @rep:doccd 120hztig.pdf Save Organization Customer Business Object, Oracle Trading Community Architecture Technical Implementation Guide
222: */
223: PROCEDURE save_org_cust_bo(
224: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
225: p_org_cust_obj IN HZ_ORG_CUST_BO,
226: p_created_by_module IN VARCHAR2,
227: p_obj_source IN VARCHAR2 := null,
228: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
224: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
225: p_org_cust_obj IN HZ_ORG_CUST_BO,
226: p_created_by_module IN VARCHAR2,
227: p_obj_source IN VARCHAR2 := null,
228: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
231: x_return_obj OUT NOCOPY HZ_ORG_CUST_BO,
232: x_organization_id OUT NOCOPY NUMBER
242: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
243: --
244: -- ARGUMENTS
245: -- IN:
246: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
247: -- p_organization_id Organization ID.
248: -- p_organization_os Organization orig system.
249: -- p_organization_osr Organization orig system reference.
250: -- OUT:
249: -- p_organization_osr Organization orig system reference.
250: -- OUT:
251: -- x_org_cust_obj Logical organization customer record.
252: -- x_return_status Return status after the call. The status can
253: -- be fnd_api.g_ret_sts_success (success),
254: -- fnd_api.g_ret_sts_error (error),
255: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
256: -- x_msg_count Number of messages in message stack.
257: -- x_msg_data Message text if x_msg_count is 1.
250: -- OUT:
251: -- x_org_cust_obj Logical organization customer record.
252: -- x_return_status Return status after the call. The status can
253: -- be fnd_api.g_ret_sts_success (success),
254: -- fnd_api.g_ret_sts_error (error),
255: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
256: -- x_msg_count Number of messages in message stack.
257: -- x_msg_data Message text if x_msg_count is 1.
258: --
251: -- x_org_cust_obj Logical organization customer record.
252: -- x_return_status Return status after the call. The status can
253: -- be fnd_api.g_ret_sts_success (success),
254: -- fnd_api.g_ret_sts_error (error),
255: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
256: -- x_msg_count Number of messages in message stack.
257: -- x_msg_data Message text if x_msg_count is 1.
258: --
259: -- NOTES
283: */
284:
285:
286: PROCEDURE get_org_cust_bo(
287: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
288: p_organization_id IN NUMBER,
289: p_organization_os IN VARCHAR2,
290: p_organization_osr IN VARCHAR2,
291: x_org_cust_obj OUT NOCOPY HZ_ORG_CUST_BO,
334: -- ARGUMENTS
335: -- IN:
336: -- p_init_msg_list Initialize message stack if it is set to
337: -- p_event_id BES Event identifier.
338: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
339: -- OUT:
340: -- x_org_cust_objs One or more created logical organization customer.
341: -- x_return_status Return status after the call. The status can
342: -- be fnd_api.g_ret_sts_success (success),
338: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
339: -- OUT:
340: -- x_org_cust_objs One or more created logical organization customer.
341: -- x_return_status Return status after the call. The status can
342: -- be fnd_api.g_ret_sts_success (success),
343: -- fnd_api.g_ret_sts_error (error),
344: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
345: -- x_msg_count Number of messages in message stack.
346: -- x_msg_data Message text if x_msg_count is 1.
339: -- OUT:
340: -- x_org_cust_objs One or more created logical organization customer.
341: -- x_return_status Return status after the call. The status can
342: -- be fnd_api.g_ret_sts_success (success),
343: -- fnd_api.g_ret_sts_error (error),
344: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
345: -- x_msg_count Number of messages in message stack.
346: -- x_msg_data Message text if x_msg_count is 1.
347: --
340: -- x_org_cust_objs One or more created logical organization customer.
341: -- x_return_status Return status after the call. The status can
342: -- be fnd_api.g_ret_sts_success (success),
343: -- fnd_api.g_ret_sts_error (error),
344: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
345: -- x_msg_count Number of messages in message stack.
346: -- x_msg_data Message text if x_msg_count is 1.
347: --
348: -- NOTES
367: them in a table structure and returns them to the caller.
368: */
369:
370: PROCEDURE get_org_custs_created(
371: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
372: p_event_id IN NUMBER,
373: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,
374: x_return_status OUT NOCOPY VARCHAR2,
375: x_msg_count OUT NOCOPY NUMBER,
414: -- ARGUMENTS
415: -- IN:
416: -- p_init_msg_list Initialize message stack if it is set to
417: -- p_event_id BES Event identifier.
418: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
419: -- OUT:
420: -- x_org_cust_objs One or more created logical org customer.
421: -- x_return_status Return status after the call. The status can
422: -- be fnd_api.g_ret_sts_success (success),
418: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
419: -- OUT:
420: -- x_org_cust_objs One or more created logical org customer.
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.
419: -- OUT:
420: -- x_org_cust_objs One or more created logical org customer.
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: --
420: -- x_org_cust_objs One or more created logical org customer.
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
443: Gathering all of the returned database objects from those API calls, the procedure packages them in a table structure and returns
444: them to the caller.
445: */
446: PROCEDURE get_org_custs_updated(
447: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
448: p_event_id IN NUMBER,
449: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,
450: x_return_status OUT NOCOPY VARCHAR2,
451: x_msg_count OUT NOCOPY NUMBER,
499: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
500: );
501:
502: PROCEDURE get_org_cust_updated(
503: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
504: p_event_id IN NUMBER,
505: p_org_cust_id IN NUMBER,
506: x_org_cust_obj OUT NOCOPY HZ_ORG_CUST_BO,
507: x_return_status OUT NOCOPY VARCHAR2,
577: * @rep:displayname Get Identifiers for Created Organization Customer Business Objects
578: * @rep:doccd 120hztig.pdf Get Business Object API Procedures, Oracle Trading Community Architecture Technical Implementation Guide
579: */
580: PROCEDURE get_ids_org_custs_created (
581: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
582: p_event_id IN NUMBER,
583: x_org_cust_ids OUT NOCOPY HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL,
584: x_return_status OUT NOCOPY VARCHAR2,
585: x_msg_count OUT NOCOPY NUMBER,
606: * @rep:displayname Get Identifiers for Updated Organization Customer Business Objects
607: * @rep:doccd 120hztig.pdf Get Updated Business Object Procedures, Oracle Trading Community Architecture Technical Implementation Guide
608: */
609: PROCEDURE get_ids_org_custs_updated (
610: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
611: p_event_id IN NUMBER,
612: x_org_cust_ids OUT NOCOPY HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL,
613: x_return_status OUT NOCOPY VARCHAR2,
614: x_msg_count OUT NOCOPY NUMBER,
624: --
625: -- ARGUMENTS
626: -- IN:
627: -- p_init_msg_list Initialize message stack if it is set to
628: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
629: -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
630: -- the completeness of business object.
631: -- p_org_cust_v2_obj Logical org customer account object.
632: -- p_created_by_module Created by module.
625: -- ARGUMENTS
626: -- IN:
627: -- p_init_msg_list Initialize message stack if it is set to
628: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
629: -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
630: -- the completeness of business object.
631: -- p_org_cust_v2_obj Logical org customer account object.
632: -- p_created_by_module Created by module.
633: -- OUT:
631: -- p_org_cust_v2_obj Logical org customer account object.
632: -- p_created_by_module Created by module.
633: -- OUT:
634: -- x_return_status Return status after the call. The status can
635: -- be fnd_api.g_ret_sts_success (success),
636: -- fnd_api.g_ret_sts_error (error),
637: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
638: -- x_msg_count Number of messages in message stack.
639: -- x_messages Messages from message stack.
632: -- p_created_by_module Created by module.
633: -- OUT:
634: -- x_return_status Return status after the call. The status can
635: -- be fnd_api.g_ret_sts_success (success),
636: -- fnd_api.g_ret_sts_error (error),
637: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
638: -- x_msg_count Number of messages in message stack.
639: -- x_messages Messages from message stack.
640: -- x_organization_id Organization ID.
633: -- OUT:
634: -- x_return_status Return status after the call. The status can
635: -- be fnd_api.g_ret_sts_success (success),
636: -- fnd_api.g_ret_sts_error (error),
637: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
638: -- x_msg_count Number of messages in message stack.
639: -- x_messages Messages from message stack.
640: -- x_organization_id Organization ID.
641: --
667: * @rep:displayname Create Organization Customer Business Object
668: * @rep:doccd 120hztig.pdf Create Organization Customer Business Object, Oracle Trading Community Architecture Technical Implementation Guide
669: */
670: PROCEDURE create_org_cust_v2_bo(
671: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
672: p_org_cust_v2_obj IN HZ_org_cust_v2_bo,
673: p_created_by_module IN VARCHAR2,
674: p_obj_source IN VARCHAR2 := null,
675: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
671: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
672: p_org_cust_v2_obj IN HZ_org_cust_v2_bo,
673: p_created_by_module IN VARCHAR2,
674: p_obj_source IN VARCHAR2 := null,
675: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
676: x_return_status OUT NOCOPY VARCHAR2,
677: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
678: x_return_obj OUT NOCOPY HZ_org_cust_v2_bo,
679: x_organization_id OUT NOCOPY NUMBER
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_org_cust_v2_obj Logical org customer account object.
694: -- p_created_by_module Created by module.
695: -- OUT:
696: -- x_return_status Return status after the call. The status can
693: -- p_org_cust_v2_obj Logical org customer account object.
694: -- p_created_by_module Created by module.
695: -- OUT:
696: -- x_return_status Return status after the call. The status can
697: -- be fnd_api.g_ret_sts_success (success),
698: -- fnd_api.g_ret_sts_error (error),
699: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
700: -- x_msg_count Number of messages in message stack.
701: -- x_messages Messages from message stack.
694: -- p_created_by_module Created by module.
695: -- OUT:
696: -- x_return_status Return status after the call. The status can
697: -- be fnd_api.g_ret_sts_success (success),
698: -- fnd_api.g_ret_sts_error (error),
699: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
700: -- x_msg_count Number of messages in message stack.
701: -- x_messages Messages from message stack.
702: -- x_organization_id Organization ID.
695: -- OUT:
696: -- x_return_status Return status after the call. The status can
697: -- be fnd_api.g_ret_sts_success (success),
698: -- fnd_api.g_ret_sts_error (error),
699: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
700: -- x_msg_count Number of messages in message stack.
701: -- x_messages Messages from message stack.
702: -- x_organization_id Organization ID.
703: --
731: PROCEDURE update_org_cust_v2_bo(
732: p_org_cust_v2_obj IN HZ_org_cust_v2_bo,
733: p_created_by_module IN VARCHAR2,
734: p_obj_source IN VARCHAR2 := null,
735: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
736: x_return_status OUT NOCOPY VARCHAR2,
737: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
738: x_return_obj OUT NOCOPY HZ_org_cust_v2_bo,
739: x_organization_id OUT NOCOPY NUMBER
748: --
749: -- ARGUMENTS
750: -- IN:
751: -- p_init_msg_list Initialize message stack if it is set to
752: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
753: -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
754: -- the completeness of business object.
755: -- p_org_cust_v2_obj Logical org customer account object.
756: -- p_created_by_module Created by module.
749: -- ARGUMENTS
750: -- IN:
751: -- p_init_msg_list Initialize message stack if it is set to
752: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
753: -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
754: -- the completeness of business object.
755: -- p_org_cust_v2_obj Logical org customer account object.
756: -- p_created_by_module Created by module.
757: -- OUT:
755: -- p_org_cust_v2_obj Logical org customer account object.
756: -- p_created_by_module Created by module.
757: -- OUT:
758: -- x_return_status Return status after the call. The status can
759: -- be fnd_api.g_ret_sts_success (success),
760: -- fnd_api.g_ret_sts_error (error),
761: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
762: -- x_msg_count Number of messages in message stack.
763: -- x_messages Messages from message stack
756: -- p_created_by_module Created by module.
757: -- OUT:
758: -- x_return_status Return status after the call. The status can
759: -- be fnd_api.g_ret_sts_success (success),
760: -- fnd_api.g_ret_sts_error (error),
761: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
762: -- x_msg_count Number of messages in message stack.
763: -- x_messages Messages from message stack
764: -- x_organization_id Organization ID.
757: -- OUT:
758: -- x_return_status Return status after the call. The status can
759: -- be fnd_api.g_ret_sts_success (success),
760: -- fnd_api.g_ret_sts_error (error),
761: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
762: -- x_msg_count Number of messages in message stack.
763: -- x_messages Messages from message stack
764: -- x_organization_id Organization ID.
765: --
793: * @rep:displayname Save Organization Customer Business Object
794: * @rep:doccd 120hztig.pdf Save Organization Customer Business Object, Oracle Trading Community Architecture Technical Implementation Guide
795: */
796: PROCEDURE save_org_cust_v2_bo(
797: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
798: p_org_cust_v2_obj IN HZ_org_cust_v2_bo,
799: p_created_by_module IN VARCHAR2,
800: p_obj_source IN VARCHAR2 := null,
801: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
797: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
798: p_org_cust_v2_obj IN HZ_org_cust_v2_bo,
799: p_created_by_module IN VARCHAR2,
800: p_obj_source IN VARCHAR2 := null,
801: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
802: x_return_status OUT NOCOPY VARCHAR2,
803: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
804: x_return_obj OUT NOCOPY HZ_org_cust_v2_bo,
805: x_organization_id OUT NOCOPY NUMBER
817: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
818: --
819: -- ARGUMENTS
820: -- IN:
821: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
822: -- p_organization_id Organization ID.
823: -- p_organization_os Organization orig system.
824: -- p_organization_osr Organization orig system reference.
825: -- OUT:
824: -- p_organization_osr Organization orig system reference.
825: -- OUT:
826: -- x_org_cust_v2_obj Logical organization customer record.
827: -- x_return_status Return status after the call. The status can
828: -- be fnd_api.g_ret_sts_success (success),
829: -- fnd_api.g_ret_sts_error (error),
830: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
831: -- x_msg_count Number of messages in message stack.
832: -- x_msg_data Message text if x_msg_count is 1.
825: -- OUT:
826: -- x_org_cust_v2_obj Logical organization customer record.
827: -- x_return_status Return status after the call. The status can
828: -- be fnd_api.g_ret_sts_success (success),
829: -- fnd_api.g_ret_sts_error (error),
830: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
831: -- x_msg_count Number of messages in message stack.
832: -- x_msg_data Message text if x_msg_count is 1.
833: --
826: -- x_org_cust_v2_obj Logical organization customer record.
827: -- x_return_status Return status after the call. The status can
828: -- be fnd_api.g_ret_sts_success (success),
829: -- fnd_api.g_ret_sts_error (error),
830: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
831: -- x_msg_count Number of messages in message stack.
832: -- x_msg_data Message text if x_msg_count is 1.
833: --
834: -- NOTES
858: */
859:
860:
861: PROCEDURE get_org_cust_v2_bo(
862: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
863: p_organization_id IN NUMBER,
864: p_organization_os IN VARCHAR2,
865: p_organization_osr IN VARCHAR2,
866: x_org_cust_v2_obj OUT NOCOPY HZ_ORG_CUST_V2_BO,
909: -- ARGUMENTS
910: -- IN:
911: -- p_init_msg_list Initialize message stack if it is set to
912: -- p_event_id BES Event identifier.
913: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
914: -- OUT:
915: -- x_org_cust_v2_objs One or more created logical organization customer.
916: -- x_return_status Return status after the call. The status can
917: -- be fnd_api.g_ret_sts_success (success),
913: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
914: -- OUT:
915: -- x_org_cust_v2_objs One or more created logical organization customer.
916: -- x_return_status Return status after the call. The status can
917: -- be fnd_api.g_ret_sts_success (success),
918: -- fnd_api.g_ret_sts_error (error),
919: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
920: -- x_msg_count Number of messages in message stack.
921: -- x_msg_data Message text if x_msg_count is 1.
914: -- OUT:
915: -- x_org_cust_v2_objs One or more created logical organization customer.
916: -- x_return_status Return status after the call. The status can
917: -- be fnd_api.g_ret_sts_success (success),
918: -- fnd_api.g_ret_sts_error (error),
919: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
920: -- x_msg_count Number of messages in message stack.
921: -- x_msg_data Message text if x_msg_count is 1.
922: --
915: -- x_org_cust_v2_objs One or more created logical organization customer.
916: -- x_return_status Return status after the call. The status can
917: -- be fnd_api.g_ret_sts_success (success),
918: -- fnd_api.g_ret_sts_error (error),
919: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
920: -- x_msg_count Number of messages in message stack.
921: -- x_msg_data Message text if x_msg_count is 1.
922: --
923: -- NOTES
942: them in a table structure and returns them to the caller.
943: */
944:
945: PROCEDURE get_v2_org_custs_created(
946: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
947: p_event_id IN NUMBER,
948: x_org_cust_v2_objs OUT NOCOPY HZ_ORG_CUST_V2_BO_TBL,
949: x_return_status OUT NOCOPY VARCHAR2,
950: x_msg_count OUT NOCOPY NUMBER,
989: -- ARGUMENTS
990: -- IN:
991: -- p_init_msg_list Initialize message stack if it is set to
992: -- p_event_id BES Event identifier.
993: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
994: -- OUT:
995: -- x_org_cust_v2_objs One or more created logical org customer.
996: -- x_return_status Return status after the call. The status can
997: -- be fnd_api.g_ret_sts_success (success),
993: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
994: -- OUT:
995: -- x_org_cust_v2_objs One or more created logical org customer.
996: -- x_return_status Return status after the call. The status can
997: -- be fnd_api.g_ret_sts_success (success),
998: -- fnd_api.g_ret_sts_error (error),
999: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1000: -- x_msg_count Number of messages in message stack.
1001: -- x_msg_data Message text if x_msg_count is 1.
994: -- OUT:
995: -- x_org_cust_v2_objs One or more created logical org customer.
996: -- x_return_status Return status after the call. The status can
997: -- be fnd_api.g_ret_sts_success (success),
998: -- fnd_api.g_ret_sts_error (error),
999: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1000: -- x_msg_count Number of messages in message stack.
1001: -- x_msg_data Message text if x_msg_count is 1.
1002: --
995: -- x_org_cust_v2_objs One or more created logical org customer.
996: -- x_return_status Return status after the call. The status can
997: -- be fnd_api.g_ret_sts_success (success),
998: -- fnd_api.g_ret_sts_error (error),
999: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1000: -- x_msg_count Number of messages in message stack.
1001: -- x_msg_data Message text if x_msg_count is 1.
1002: --
1003: -- NOTES
1018: Gathering all of the returned database objects from those API calls, the procedure packages them in a table structure and returns
1019: them to the caller.
1020: */
1021: PROCEDURE get_v2_org_custs_updated(
1022: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1023: p_event_id IN NUMBER,
1024: x_org_cust_v2_objs OUT NOCOPY HZ_ORG_CUST_V2_BO_TBL,
1025: x_return_status OUT NOCOPY VARCHAR2,
1026: x_msg_count OUT NOCOPY NUMBER,
1074: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1075: );
1076:
1077: PROCEDURE get_v2_org_cust_updated(
1078: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1079: p_event_id IN NUMBER,
1080: p_org_cust_id IN NUMBER,
1081: x_org_cust_v2_obj OUT NOCOPY HZ_ORG_CUST_V2_BO,
1082: x_return_status OUT NOCOPY VARCHAR2,