22: --
23: -- ARGUMENTS
24: -- IN:
25: -- p_init_msg_list Initialize message stack if it is set to
26: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
27: -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
28: -- the completeness of business object.
29: -- p_organization_obj Organization object.
30: -- p_created_by_module Created by module.
23: -- ARGUMENTS
24: -- IN:
25: -- p_init_msg_list Initialize message stack if it is set to
26: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
27: -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
28: -- the completeness of business object.
29: -- p_organization_obj Organization object.
30: -- p_created_by_module Created by module.
31: -- OUT:
29: -- p_organization_obj Organization object.
30: -- p_created_by_module Created by module.
31: -- OUT:
32: -- x_return_status Return status after the call. The status can
33: -- be fnd_api.g_ret_sts_success (success),
34: -- fnd_api.g_ret_sts_error (error),
35: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
36: -- x_msg_count Number of messages in message stack.
37: -- x_msg_data Message text if x_msg_count is 1.
30: -- p_created_by_module Created by module.
31: -- OUT:
32: -- x_return_status Return status after the call. The status can
33: -- be fnd_api.g_ret_sts_success (success),
34: -- fnd_api.g_ret_sts_error (error),
35: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
36: -- x_msg_count Number of messages in message stack.
37: -- x_msg_data Message text if x_msg_count is 1.
38: -- x_organization_id Organization ID.
31: -- OUT:
32: -- x_return_status Return status after the call. The status can
33: -- be fnd_api.g_ret_sts_success (success),
34: -- fnd_api.g_ret_sts_error (error),
35: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
36: -- x_msg_count Number of messages in message stack.
37: -- x_msg_data Message text if x_msg_count is 1.
38: -- x_organization_id Organization ID.
39: -- x_organization_os Organization orig system.
46: -- 02-MAR-2005 Arnold Ng Created.
47: --
48:
49: PROCEDURE create_organization_bo(
50: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
51: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
52: p_organization_obj IN HZ_ORGANIZATION_BO,
53: p_created_by_module IN VARCHAR2,
54: x_return_status OUT NOCOPY VARCHAR2,
47: --
48:
49: PROCEDURE create_organization_bo(
50: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
51: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
52: p_organization_obj IN HZ_ORGANIZATION_BO,
53: p_created_by_module IN VARCHAR2,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
83: * @rep:doccd 120hztig.pdf Create Organization Business Object, Oracle Trading Community Architecture Technical Implementation Guide
84: */
85:
86: PROCEDURE create_organization_bo(
87: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
88: p_organization_obj IN HZ_ORGANIZATION_BO,
89: p_created_by_module IN VARCHAR2,
90: p_obj_source IN VARCHAR2 := null,
91: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
87: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
88: p_organization_obj IN HZ_ORGANIZATION_BO,
89: p_created_by_module IN VARCHAR2,
90: p_obj_source IN VARCHAR2 := null,
91: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
94: x_return_obj OUT NOCOPY HZ_ORGANIZATION_BO,
95: x_organization_id OUT NOCOPY NUMBER,
106: --
107: -- ARGUMENTS
108: -- IN:
109: -- p_init_msg_list Initialize message stack if it is set to
110: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
111: -- p_organization_obj Organization object.
112: -- p_created_by_module Created by module.
113: -- OUT:
114: -- x_return_status Return status after the call. The status can
111: -- p_organization_obj Organization object.
112: -- p_created_by_module Created by module.
113: -- OUT:
114: -- x_return_status Return status after the call. The status can
115: -- be fnd_api.g_ret_sts_success (success),
116: -- fnd_api.g_ret_sts_error (error),
117: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
118: -- x_msg_count Number of messages in message stack.
119: -- x_msg_data Message text if x_msg_count is 1.
112: -- p_created_by_module Created by module.
113: -- OUT:
114: -- x_return_status Return status after the call. The status can
115: -- be fnd_api.g_ret_sts_success (success),
116: -- fnd_api.g_ret_sts_error (error),
117: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
118: -- x_msg_count Number of messages in message stack.
119: -- x_msg_data Message text if x_msg_count is 1.
120: -- x_organization_id Organization ID.
113: -- OUT:
114: -- x_return_status Return status after the call. The status can
115: -- be fnd_api.g_ret_sts_success (success),
116: -- fnd_api.g_ret_sts_error (error),
117: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
118: -- x_msg_count Number of messages in message stack.
119: -- x_msg_data Message text if x_msg_count is 1.
120: -- x_organization_id Organization ID.
121: -- x_organization_os Organization orig system.
127: --
128: -- 02-MAR-2005 Arnold Ng Created.
129:
130: PROCEDURE update_organization_bo(
131: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
132: p_organization_obj IN HZ_ORGANIZATION_BO,
133: p_created_by_module IN VARCHAR2,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
165: PROCEDURE update_organization_bo(
166: p_organization_obj IN HZ_ORGANIZATION_BO,
167: p_created_by_module IN VARCHAR2,
168: p_obj_source IN VARCHAR2 := null,
169: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
172: x_return_obj OUT NOCOPY HZ_ORGANIZATION_BO,
173: x_organization_id OUT NOCOPY NUMBER,
184: --
185: -- ARGUMENTS
186: -- IN:
187: -- p_init_msg_list Initialize message stack if it is set to
188: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
189: -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
190: -- the completeness of business object.
191: -- p_organization_obj Organization object.
192: -- p_created_by_module Created by module.
185: -- ARGUMENTS
186: -- IN:
187: -- p_init_msg_list Initialize message stack if it is set to
188: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
189: -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
190: -- the completeness of business object.
191: -- p_organization_obj Organization object.
192: -- p_created_by_module Created by module.
193: -- OUT:
191: -- p_organization_obj Organization object.
192: -- p_created_by_module Created by module.
193: -- OUT:
194: -- x_return_status Return status after the call. The status can
195: -- be fnd_api.g_ret_sts_success (success),
196: -- fnd_api.g_ret_sts_error (error),
197: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
198: -- x_msg_count Number of messages in message stack.
199: -- x_msg_data Message text if x_msg_count is 1.
192: -- p_created_by_module Created by module.
193: -- OUT:
194: -- x_return_status Return status after the call. The status can
195: -- be fnd_api.g_ret_sts_success (success),
196: -- fnd_api.g_ret_sts_error (error),
197: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
198: -- x_msg_count Number of messages in message stack.
199: -- x_msg_data Message text if x_msg_count is 1.
200: -- x_organization_id Organization ID.
193: -- OUT:
194: -- x_return_status Return status after the call. The status can
195: -- be fnd_api.g_ret_sts_success (success),
196: -- fnd_api.g_ret_sts_error (error),
197: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
198: -- x_msg_count Number of messages in message stack.
199: -- x_msg_data Message text if x_msg_count is 1.
200: -- x_organization_id Organization ID.
201: -- x_organization_os Organization orig system.
207: --
208: -- 02-MAR-2005 Arnold Ng Created.
209:
210: PROCEDURE save_organization_bo(
211: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
212: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
213: p_organization_obj IN HZ_ORGANIZATION_BO,
214: p_created_by_module IN VARCHAR2,
215: x_return_status OUT NOCOPY VARCHAR2,
208: -- 02-MAR-2005 Arnold Ng Created.
209:
210: PROCEDURE save_organization_bo(
211: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
212: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
213: p_organization_obj IN HZ_ORGANIZATION_BO,
214: p_created_by_module IN VARCHAR2,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
247: * @rep:doccd 120hztig.pdf Save Organization Business Object, Oracle Trading Community Architecture Technical Implementation Guide
248: */
249:
250: PROCEDURE save_organization_bo(
251: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
252: p_organization_obj IN HZ_ORGANIZATION_BO,
253: p_created_by_module IN VARCHAR2,
254: p_obj_source IN VARCHAR2 := null,
255: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
251: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
252: p_organization_obj IN HZ_ORGANIZATION_BO,
253: p_created_by_module IN VARCHAR2,
254: p_obj_source IN VARCHAR2 := null,
255: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
258: x_return_obj OUT NOCOPY HZ_ORGANIZATION_BO,
259: x_organization_id OUT NOCOPY NUMBER,
271: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
272: --
273: -- ARGUMENTS
274: -- IN:
275: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
276: -- p_organization_id Organization ID.
277: -- p_organization_os Org orig system.
278: -- p_organization_osr Org orig system reference.
279: -- OUT:
278: -- p_organization_osr Org orig system reference.
279: -- OUT:
280: -- x_organization_obj Logical organization record.
281: -- x_return_status Return status after the call. The status can
282: -- be fnd_api.g_ret_sts_success (success),
283: -- fnd_api.g_ret_sts_error (error),
284: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
285: -- x_msg_count Number of messages in message stack.
286: -- x_msg_data Message text if x_msg_count is 1.
279: -- OUT:
280: -- x_organization_obj Logical organization record.
281: -- x_return_status Return status after the call. The status can
282: -- be fnd_api.g_ret_sts_success (success),
283: -- fnd_api.g_ret_sts_error (error),
284: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
285: -- x_msg_count Number of messages in message stack.
286: -- x_msg_data Message text if x_msg_count is 1.
287: --
280: -- x_organization_obj Logical organization record.
281: -- x_return_status Return status after the call. The status can
282: -- be fnd_api.g_ret_sts_success (success),
283: -- fnd_api.g_ret_sts_error (error),
284: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
285: -- x_msg_count Number of messages in message stack.
286: -- x_msg_data Message text if x_msg_count is 1.
287: --
288: -- NOTES
332: */
333:
334:
335: PROCEDURE get_organization_bo(
336: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
337: p_organization_id IN NUMBER,
338: p_organization_os IN VARCHAR2,
339: p_organization_osr IN VARCHAR2,
340: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,
384: -- ARGUMENTS
385: -- IN:
386: -- p_init_msg_list Initialize message stack if it is set to
387: -- p_event_id BES Event identifier.
388: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
389: -- OUT:
390: -- x_organization_objs One or more created logical organization.
391: -- x_return_status Return status after the call. The status can
392: -- be fnd_api.g_ret_sts_success (success),
388: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
389: -- OUT:
390: -- x_organization_objs One or more created logical organization.
391: -- x_return_status Return status after the call. The status can
392: -- be fnd_api.g_ret_sts_success (success),
393: -- fnd_api.g_ret_sts_error (error),
394: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
395: -- x_msg_count Number of messages in message stack.
396: -- x_msg_data Message text if x_msg_count is 1.
389: -- OUT:
390: -- x_organization_objs One or more created logical organization.
391: -- x_return_status Return status after the call. The status can
392: -- be fnd_api.g_ret_sts_success (success),
393: -- fnd_api.g_ret_sts_error (error),
394: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
395: -- x_msg_count Number of messages in message stack.
396: -- x_msg_data Message text if x_msg_count is 1.
397: --
390: -- x_organization_objs One or more created logical organization.
391: -- x_return_status Return status after the call. The status can
392: -- be fnd_api.g_ret_sts_success (success),
393: -- fnd_api.g_ret_sts_error (error),
394: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
395: -- x_msg_count Number of messages in message stack.
396: -- x_msg_data Message text if x_msg_count is 1.
397: --
398: -- NOTES
418: */
419:
420:
421: PROCEDURE get_organizations_created(
422: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
423: p_event_id IN NUMBER,
424: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,
425: x_return_status OUT NOCOPY VARCHAR2,
426: x_msg_count OUT NOCOPY NUMBER,
465: -- ARGUMENTS
466: -- IN:
467: -- p_init_msg_list Initialize message stack if it is set to
468: -- p_event_id BES Event identifier.
469: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
470: -- OUT:
471: -- x_organization_objs One or more created logical organization.
472: -- x_return_status Return status after the call. The status can
473: -- be fnd_api.g_ret_sts_success (success),
469: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
470: -- OUT:
471: -- x_organization_objs One or more created logical organization.
472: -- x_return_status Return status after the call. The status can
473: -- be fnd_api.g_ret_sts_success (success),
474: -- fnd_api.g_ret_sts_error (error),
475: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
476: -- x_msg_count Number of messages in message stack.
477: -- x_msg_data Message text if x_msg_count is 1.
470: -- OUT:
471: -- x_organization_objs One or more created logical organization.
472: -- x_return_status Return status after the call. The status can
473: -- be fnd_api.g_ret_sts_success (success),
474: -- fnd_api.g_ret_sts_error (error),
475: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
476: -- x_msg_count Number of messages in message stack.
477: -- x_msg_data Message text if x_msg_count is 1.
478: --
471: -- x_organization_objs One or more created logical organization.
472: -- x_return_status Return status after the call. The status can
473: -- be fnd_api.g_ret_sts_success (success),
474: -- fnd_api.g_ret_sts_error (error),
475: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
476: -- x_msg_count Number of messages in message stack.
477: -- x_msg_data Message text if x_msg_count is 1.
478: --
479: -- NOTES
495: returns them to the caller.
496: */
497:
498: PROCEDURE get_organizations_updated(
499: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
500: p_event_id IN NUMBER,
501: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,
502: x_return_status OUT NOCOPY VARCHAR2,
503: x_msg_count OUT NOCOPY NUMBER,
564: -- ARGUMENTS
565: -- IN:
566: -- p_init_msg_list Initialize message stack if it is set to
567: -- p_event_id BES Event identifier.
568: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
569: -- OUT:
570: -- x_organization_objs One or more created logical organization.
571: -- x_return_status Return status after the call. The status can
572: -- be fnd_api.g_ret_sts_success (success),
568: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
569: -- OUT:
570: -- x_organization_objs One or more created logical organization.
571: -- x_return_status Return status after the call. The status can
572: -- be fnd_api.g_ret_sts_success (success),
573: -- fnd_api.g_ret_sts_error (error),
574: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
575: -- x_msg_count Number of messages in message stack.
576: -- x_msg_data Message text if x_msg_count is 1.
569: -- OUT:
570: -- x_organization_objs One or more created logical organization.
571: -- x_return_status Return status after the call. The status can
572: -- be fnd_api.g_ret_sts_success (success),
573: -- fnd_api.g_ret_sts_error (error),
574: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
575: -- x_msg_count Number of messages in message stack.
576: -- x_msg_data Message text if x_msg_count is 1.
577: --
570: -- x_organization_objs One or more created logical organization.
571: -- x_return_status Return status after the call. The status can
572: -- be fnd_api.g_ret_sts_success (success),
573: -- fnd_api.g_ret_sts_error (error),
574: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
575: -- x_msg_count Number of messages in message stack.
576: -- x_msg_data Message text if x_msg_count is 1.
577: --
578: -- NOTES
582: -- 06-JUN-2005 AWU Created.
583: --
584:
585: PROCEDURE get_organization_updated(
586: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
587: p_event_id IN NUMBER,
588: p_organization_id IN NUMBER,
589: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,
590: x_return_status OUT NOCOPY VARCHAR2,
659: * @rep:doccd 120hztig.pdf Get Business Object API Procedures, Oracle Trading Community Architecture Technical Implementation Guide
660: */
661: -- get TCA identifiers for create event
662: PROCEDURE get_ids_organizations_created (
663: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
664: p_event_id IN NUMBER,
665: x_organization_ids OUT NOCOPY HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL,
666: x_return_status OUT NOCOPY VARCHAR2,
667: x_msg_count OUT NOCOPY NUMBER,
688: * @rep:displayname Get Identifiers for Updated Organization Business Objects
689: * @rep:doccd 120hztig.pdf Get Updated Business Object Procedures, Oracle Trading Community Architecture Technical Implementation Guide
690: */
691: PROCEDURE get_ids_organizations_updated (
692: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
693: p_event_id IN NUMBER,
694: x_organization_ids OUT NOCOPY HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL,
695: x_return_status OUT NOCOPY VARCHAR2,
696: x_msg_count OUT NOCOPY NUMBER,
697: x_msg_data OUT NOCOPY VARCHAR2
698: );
699:
700: PROCEDURE do_create_organization_bo(
701: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
702: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
703: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,
704: p_created_by_module IN VARCHAR2,
705: p_obj_source IN VARCHAR2 := null,
698: );
699:
700: PROCEDURE do_create_organization_bo(
701: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
702: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
703: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,
704: p_created_by_module IN VARCHAR2,
705: p_obj_source IN VARCHAR2 := null,
706: x_return_status OUT NOCOPY VARCHAR2,
711: x_organization_osr OUT NOCOPY VARCHAR2
712: );
713:
714: PROCEDURE do_update_organization_bo(
715: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
716: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,
717: p_created_by_module IN VARCHAR2,
718: p_obj_source IN VARCHAR2 := null,
719: x_return_status OUT NOCOPY VARCHAR2,
724: x_organization_osr OUT NOCOPY VARCHAR2
725: );
726:
727: PROCEDURE do_save_organization_bo(
728: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
729: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
730: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,
731: p_created_by_module IN VARCHAR2,
732: p_obj_source IN VARCHAR2 := null,
725: );
726:
727: PROCEDURE do_save_organization_bo(
728: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
729: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
730: p_organization_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,
731: p_created_by_module IN VARCHAR2,
732: p_obj_source IN VARCHAR2 := null,
733: x_return_status OUT NOCOPY VARCHAR2,