DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ACCT_SITE_BO_PVT dependencies on HZ_CUST_SITE_USE_V2_BO_TBL

Line 1096: x_cust_site_use_v2_objs OUT NOCOPY HZ_CUST_SITE_USE_V2_BO_TBL,

1092: PROCEDURE get_cust_site_use_v2_bos(
1093: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1094: p_cust_acct_site_id IN NUMBER,
1095: p_action_type IN VARCHAR2 := NULL,
1096: x_cust_site_use_v2_objs OUT NOCOPY HZ_CUST_SITE_USE_V2_BO_TBL,
1097: x_return_status OUT NOCOPY VARCHAR2,
1098: x_msg_count OUT NOCOPY NUMBER,
1099: x_msg_data OUT NOCOPY VARCHAR2
1100: ) is

Line 1336: x_cust_site_use_v2_objs := HZ_CUST_SITE_USE_V2_BO_TBL();

1332: p_prefix=>l_debug_prefix,
1333: p_msg_level=>fnd_log.level_procedure);
1334: END IF;
1335:
1336: x_cust_site_use_v2_objs := HZ_CUST_SITE_USE_V2_BO_TBL();
1337: open c1;
1338: fetch c1 BULK COLLECT into x_cust_site_use_v2_objs;
1339: close c1;
1340:

Line 1679: HZ_CUST_SITE_USE_V2_BO_TBL(),

1675: WHERE
1676: OSR.OWNER_TABLE_ID = CAS.PARTY_SITE_ID
1677: AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
1678: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- party site ssm
1679: HZ_CUST_SITE_USE_V2_BO_TBL(),
1680: HZ_CUST_ACCT_CONTACT_BO_TBL())
1681: FROM HZ_CUST_ACCT_SITES CAS
1682: WHERE ((P_CUST_ACCT_SITE_ID IS NULL AND CUST_ACCOUNT_ID = P_PARENT_ID)
1683: OR (P_CUST_ACCT_SITE_ID IS NOT NULL