DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ORG_CUST_BO_PVT dependencies on HZ_ORG_CUST_V2_BO

Line 1243: x_org_cust_v2_obj OUT NOCOPY HZ_ORG_CUST_V2_BO,

1239: PROCEDURE get_org_cust_v2_bo(
1240: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1241: p_organization_id IN NUMBER,
1242: p_action_type IN VARCHAR2 := NULL,
1243: x_org_cust_v2_obj OUT NOCOPY HZ_ORG_CUST_V2_BO,
1244: x_return_status OUT NOCOPY VARCHAR2,
1245: x_msg_count OUT NOCOPY NUMBER,
1246: x_msg_data OUT NOCOPY VARCHAR2
1247: ) is

Line 1267: x_org_cust_v2_obj := HZ_ORG_CUST_V2_BO(p_action_type, NULL, NULL);

1263: p_prefix=>l_debug_prefix,
1264: p_msg_level=>fnd_log.level_procedure);
1265: END IF;
1266:
1267: x_org_cust_v2_obj := HZ_ORG_CUST_V2_BO(p_action_type, NULL, NULL);
1268:
1269: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_bo(
1270: p_init_msg_list => fnd_api.g_false,
1271: p_organization_id => p_organization_id,

Line 1432: x_org_cust_v2_objs OUT NOCOPY HZ_ORG_CUST_V2_BO_TBL,

1428:
1429: PROCEDURE get_v2_org_custs_created(
1430: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1431: p_event_id IN NUMBER,
1432: x_org_cust_v2_objs OUT NOCOPY HZ_ORG_CUST_V2_BO_TBL,
1433: x_return_status OUT NOCOPY VARCHAR2,
1434: x_msg_count OUT NOCOPY NUMBER,
1435: x_msg_data OUT NOCOPY VARCHAR2
1436: ) is

Line 1486: x_org_cust_v2_objs := HZ_ORG_CUST_V2_BO_TBL();

1482:
1483:
1484: -- call event API get_org_cust_updated for each id.
1485:
1486: x_org_cust_v2_objs := HZ_ORG_CUST_V2_BO_TBL();
1487:
1488:
1489: for i in 1..l_obj_root_ids.count loop
1490:

Line 1493: x_org_cust_v2_objs(i) := HZ_ORG_CUST_V2_BO('UNCHANGED', NULL, NULL);

1489: for i in 1..l_obj_root_ids.count loop
1490:
1491: x_org_cust_v2_objs.extend;
1492:
1493: x_org_cust_v2_objs(i) := HZ_ORG_CUST_V2_BO('UNCHANGED', NULL, NULL);
1494:
1495: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_bo(
1496: p_init_msg_list => fnd_api.g_false,
1497: p_organization_id => l_obj_root_ids(i),

Line 1629: --the procedure returns database objects of the type HZ_ORG_CUST_V2_BO for all of

1625: -- PROCEDURE get_v2_org_custs_updated
1626: --
1627: -- DESCRIPTION
1628: --The caller provides an identifier for the Organization Customers update business event and
1629: --the procedure returns database objects of the type HZ_ORG_CUST_V2_BO for all of
1630: --the Organization Customer business objects from the business event.
1631:
1632: --
1633: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 1663: database objects of the type HZ_ORG_CUST_V2_BO for all of the Organization Customer business objects from the business event.

1659: The Get Organization Customers Updated procedure is a service to retrieve all of the Organization Customer business
1660: objects whose updates have been captured by the logical business event. Each Organization Customers Updated business
1661: event signifies that one or more Organization Customer business objects have been updated.
1662: The caller provides an identifier for the Organization Customers Update business event and the procedure returns
1663: database objects of the type HZ_ORG_CUST_V2_BO for all of the Organization Customer business objects from the business event.
1664: Gathering all of the returned database objects from those API calls, the procedure packages them in a table structure
1665: and returns them to the caller.
1666: */
1667:

Line 1671: x_org_cust_v2_objs OUT NOCOPY HZ_ORG_CUST_V2_BO_TBL,

1667:
1668: PROCEDURE get_v2_org_custs_updated(
1669: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1670: p_event_id IN NUMBER,
1671: x_org_cust_v2_objs OUT NOCOPY HZ_ORG_CUST_V2_BO_TBL,
1672: x_return_status OUT NOCOPY VARCHAR2,
1673: x_msg_count OUT NOCOPY NUMBER,
1674: x_msg_data OUT NOCOPY VARCHAR2
1675: ) is

Line 1713: x_org_cust_v2_objs := HZ_ORG_CUST_V2_BO_TBL();

1709: END IF;
1710:
1711:
1712:
1713: x_org_cust_v2_objs := HZ_ORG_CUST_V2_BO_TBL();
1714:
1715: for i in 1..l_obj_root_ids.count loop
1716: x_org_cust_v2_objs.extend;
1717: get_v2_org_cust_updated(

Line 2026: px_org_cust_v2_obj IN OUT NOCOPY HZ_ORG_CUST_V2_BO,

2022: end set_v2_org_acct_bo_action_type;
2023:
2024: procedure set_v2_org_cust_bo_action_type(p_event_id IN NUMBER,
2025: p_root_id IN NUMBER,
2026: px_org_cust_v2_obj IN OUT NOCOPY HZ_ORG_CUST_V2_BO,
2027: x_return_status OUT NOCOPY VARCHAR2) is
2028:
2029: cursor c1 is
2030:

Line 2162: --the procedure returns one database object of the type HZ_ORG_CUST_V2_BO

2158: -- PROCEDURE get_v2_org_cust_updated
2159: --
2160: -- DESCRIPTION
2161: --The caller provides an identifier for the Organization customer update business event and organization id
2162: --the procedure returns one database object of the type HZ_ORG_CUST_V2_BO
2163: --
2164: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2165: --
2166: -- ARGUMENTS

Line 2193: x_org_cust_v2_obj OUT NOCOPY HZ_ORG_CUST_V2_BO,

2189: PROCEDURE get_v2_org_cust_updated(
2190: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2191: p_event_id IN NUMBER,
2192: p_org_cust_id IN NUMBER,
2193: x_org_cust_v2_obj OUT NOCOPY HZ_ORG_CUST_V2_BO,
2194: x_return_status OUT NOCOPY VARCHAR2,
2195: x_msg_count OUT NOCOPY NUMBER,
2196: x_msg_data OUT NOCOPY VARCHAR2
2197: ) is

Line 2200: l_org_cust_obj HZ_ORG_CUST_V2_BO;

2196: x_msg_data OUT NOCOPY VARCHAR2
2197: ) is
2198: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
2199: l_debug_prefix VARCHAR2(30) := '';
2200: l_org_cust_obj HZ_ORG_CUST_V2_BO;
2201: begin
2202:
2203: -- initialize API return status to success.
2204: x_return_status := FND_API.G_RET_STS_SUCCESS;