DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ORG_CUST_BO_PVT dependencies on HZ_ORG_CUST_V2_BO

Line 1281: x_org_cust_v2_obj OUT NOCOPY HZ_ORG_CUST_V2_BO,

1277: PROCEDURE get_org_cust_v2_bo(
1278: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1279: p_organization_id IN NUMBER,
1280: p_action_type IN VARCHAR2 := NULL,
1281: x_org_cust_v2_obj OUT NOCOPY HZ_ORG_CUST_V2_BO,
1282: x_return_status OUT NOCOPY VARCHAR2,
1283: x_msg_count OUT NOCOPY NUMBER,
1284: x_msg_data OUT NOCOPY VARCHAR2
1285: ) is

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

1301: p_prefix=>l_debug_prefix,
1302: p_msg_level=>fnd_log.level_procedure);
1303: END IF;
1304:
1305: x_org_cust_v2_obj := HZ_ORG_CUST_V2_BO(p_action_type, NULL, NULL);
1306:
1307: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_bo(
1308: p_init_msg_list => fnd_api.g_false,
1309: p_organization_id => p_organization_id,

Line 1470: x_org_cust_v2_objs OUT NOCOPY HZ_ORG_CUST_V2_BO_TBL,

1466:
1467: PROCEDURE get_v2_org_custs_created(
1468: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1469: p_event_id IN NUMBER,
1470: x_org_cust_v2_objs OUT NOCOPY HZ_ORG_CUST_V2_BO_TBL,
1471: x_return_status OUT NOCOPY VARCHAR2,
1472: x_msg_count OUT NOCOPY NUMBER,
1473: x_msg_data OUT NOCOPY VARCHAR2
1474: ) is

Line 1524: x_org_cust_v2_objs := HZ_ORG_CUST_V2_BO_TBL();

1520:
1521:
1522: -- call event API get_org_cust_updated for each id.
1523:
1524: x_org_cust_v2_objs := HZ_ORG_CUST_V2_BO_TBL();
1525:
1526:
1527: for i in 1..l_obj_root_ids.count loop
1528:

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

1527: for i in 1..l_obj_root_ids.count loop
1528:
1529: x_org_cust_v2_objs.extend;
1530:
1531: x_org_cust_v2_objs(i) := HZ_ORG_CUST_V2_BO('UNCHANGED', NULL, NULL);
1532:
1533: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_bo(
1534: p_init_msg_list => fnd_api.g_false,
1535: p_organization_id => l_obj_root_ids(i),

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

1663: -- PROCEDURE get_v2_org_custs_updated
1664: --
1665: -- DESCRIPTION
1666: --The caller provides an identifier for the Organization Customers update business event and
1667: --the procedure returns database objects of the type HZ_ORG_CUST_V2_BO for all of
1668: --the Organization Customer business objects from the business event.
1669:
1670: --
1671: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

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

1697: The Get Organization Customers Updated procedure is a service to retrieve all of the Organization Customer business
1698: objects whose updates have been captured by the logical business event. Each Organization Customers Updated business
1699: event signifies that one or more Organization Customer business objects have been updated.
1700: The caller provides an identifier for the Organization Customers Update business event and the procedure returns
1701: database objects of the type HZ_ORG_CUST_V2_BO for all of the Organization Customer business objects from the business event.
1702: Gathering all of the returned database objects from those API calls, the procedure packages them in a table structure
1703: and returns them to the caller.
1704: */
1705:

Line 1709: x_org_cust_v2_objs OUT NOCOPY HZ_ORG_CUST_V2_BO_TBL,

1705:
1706: PROCEDURE get_v2_org_custs_updated(
1707: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1708: p_event_id IN NUMBER,
1709: x_org_cust_v2_objs OUT NOCOPY HZ_ORG_CUST_V2_BO_TBL,
1710: x_return_status OUT NOCOPY VARCHAR2,
1711: x_msg_count OUT NOCOPY NUMBER,
1712: x_msg_data OUT NOCOPY VARCHAR2
1713: ) is

Line 1751: x_org_cust_v2_objs := HZ_ORG_CUST_V2_BO_TBL();

1747: END IF;
1748:
1749:
1750:
1751: x_org_cust_v2_objs := HZ_ORG_CUST_V2_BO_TBL();
1752:
1753: for i in 1..l_obj_root_ids.count loop
1754: x_org_cust_v2_objs.extend;
1755: get_v2_org_cust_updated(

Line 2064: px_org_cust_v2_obj IN OUT NOCOPY HZ_ORG_CUST_V2_BO,

2060: end set_v2_org_acct_bo_action_type;
2061:
2062: procedure set_v2_org_cust_bo_action_type(p_event_id IN NUMBER,
2063: p_root_id IN NUMBER,
2064: px_org_cust_v2_obj IN OUT NOCOPY HZ_ORG_CUST_V2_BO,
2065: x_return_status OUT NOCOPY VARCHAR2) is
2066:
2067: cursor c1 is
2068:

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

2196: -- PROCEDURE get_v2_org_cust_updated
2197: --
2198: -- DESCRIPTION
2199: --The caller provides an identifier for the Organization customer update business event and organization id
2200: --the procedure returns one database object of the type HZ_ORG_CUST_V2_BO
2201: --
2202: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2203: --
2204: -- ARGUMENTS

Line 2231: x_org_cust_v2_obj OUT NOCOPY HZ_ORG_CUST_V2_BO,

2227: PROCEDURE get_v2_org_cust_updated(
2228: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2229: p_event_id IN NUMBER,
2230: p_org_cust_id IN NUMBER,
2231: x_org_cust_v2_obj OUT NOCOPY HZ_ORG_CUST_V2_BO,
2232: x_return_status OUT NOCOPY VARCHAR2,
2233: x_msg_count OUT NOCOPY NUMBER,
2234: x_msg_data OUT NOCOPY VARCHAR2
2235: ) is

Line 2238: l_org_cust_obj HZ_ORG_CUST_V2_BO;

2234: x_msg_data OUT NOCOPY VARCHAR2
2235: ) is
2236: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
2237: l_debug_prefix VARCHAR2(30) := '';
2238: l_org_cust_obj HZ_ORG_CUST_V2_BO;
2239: begin
2240:
2241: -- initialize API return status to success.
2242: x_return_status := FND_API.G_RET_STS_SUCCESS;