[Home] [Help]
262: PROCEDURE get_organization_bo(
263: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
264: p_organization_id IN NUMBER,
265: p_action_type IN VARCHAR2 := NULL,
266: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2
270: ) is
269: x_msg_data OUT NOCOPY VARCHAR2
270: ) is
271:
272: CURSOR C1 IS
273: SELECT HZ_ORGANIZATION_BO(
274: P_ACTION_TYPE,
275: NULL, -- COMMON_OBJ_ID
276: P.PARTY_ID,
277: NULL, --ORIG_SYSTEM,
980: -- PROCEDURE get_organizations_created
981: --
982: -- DESCRIPTION
983: --The caller provides an identifier for the Organizations created business event and
984: --the procedure returns database objects of the type HZ_ORGANIZATION_BO for all of
985: --the Organization business objects from the business event.
986:
987: --
988: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1016: business event signifies that one or more Organization business objects have been created.
1017: The caller provides an identifier for the Organizations Created business event and the procedure
1018: returns all of the Organization business objects from the business event. For each business object
1019: creation captured in the business event, the procedure calls the generic Get operation:
1020: HZ_ORGANIZATION_BO_PVT.get_organization_bo
1021:
1022: Gathering all of the returned business objects from those API calls, the procedure packages
1023: them in a table structure and returns them to the caller.
1024: */
1026:
1027: PROCEDURE get_organizations_created(
1028: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1029: p_event_id IN NUMBER,
1030: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,
1031: x_return_status OUT NOCOPY VARCHAR2,
1032: x_msg_count OUT NOCOPY NUMBER,
1033: x_msg_data OUT NOCOPY VARCHAR2
1034: ) is
1065: RAISE FND_API.G_EXC_ERROR;
1066: END IF;
1067:
1068:
1069: x_organization_objs := HZ_ORGANIZATION_BO_TBL();
1070:
1071: for i in 1..l_obj_root_ids.count loop
1072: x_organization_objs.extend;
1073: get_organization_bo(
1171: -- PROCEDURE get_organizations_updated
1172: --
1173: -- DESCRIPTION
1174: --The caller provides an identifier for the Organizations update business event and
1175: --the procedure returns database objects of the type HZ_ORGANIZATION_BO for all of
1176: --the Organization business objects from the business event.
1177:
1178: --
1179: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1205: The Get Organizations Updated procedure is a service to retrieve all of the Organization business objects whose updates
1206: have been captured by the logical business event. Each Organizations Updated business event signifies that one or more
1207: Organization business objects have been updated.
1208: The caller provides an identifier for the Organizations Update business event and the procedure returns database objects
1209: of the type HZ_ORGANIZATION_BO for all of the Organization business objects from the business event.
1210: Gathering all of the returned database objects from those API calls, the procedure packages them in a table structure and
1211: returns them to the caller.
1212: */
1213:
1213:
1214: PROCEDURE get_organizations_updated(
1215: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1216: p_event_id IN NUMBER,
1217: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,
1218: x_return_status OUT NOCOPY VARCHAR2,
1219: x_msg_count OUT NOCOPY NUMBER,
1220: x_msg_data OUT NOCOPY VARCHAR2
1221: ) is
1255: END IF;
1256:
1257: -- call event API get_organization_updated for each id.
1258:
1259: x_organization_objs := HZ_ORGANIZATION_BO_TBL();
1260:
1261: for i in 1..l_obj_root_ids.count loop
1262: x_organization_objs.extend;
1263: get_organization_updated(
1454: -- Based on BOT, for updated branch, set action_type = 'UPDATED'/'CREATED'
1455:
1456: procedure set_org_bo_action_type(p_event_id IN NUMBER,
1457: p_root_id IN NUMBER,
1458: px_org_obj IN OUT NOCOPY HZ_ORGANIZATION_BO,
1459: x_return_status OUT NOCOPY VARCHAR2) is
1460: cursor c1 is
1461:
1462: SELECT
2023: -- PROCEDURE get_organization_updated
2024: --
2025: -- DESCRIPTION
2026: --The caller provides an identifier for the Organizations update business event and organization id
2027: --the procedure returns one database object of the type HZ_ORGANIZATION_BO
2028: --
2029: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2030: --
2031: -- ARGUMENTS
2052: PROCEDURE get_organization_updated(
2053: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2054: p_event_id IN NUMBER,
2055: p_organization_id IN NUMBER,
2056: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,
2057: x_return_status OUT NOCOPY VARCHAR2,
2058: x_msg_count OUT NOCOPY NUMBER,
2059: x_msg_data OUT NOCOPY VARCHAR2
2060: ) is
2060: ) is
2061:
2062: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
2063: l_debug_prefix VARCHAR2(30) := '';
2064: l_organization_obj HZ_ORGANIZATION_BO;
2065:
2066: begin
2067:
2068: -- initialize API return status to success.