APPS.HZ_EXTRACT_ACCT_SITE_BO_PVT dependencies on HZ_CUST_SITE_USE_BO

Line 350: x_cust_site_use_objs OUT NOCOPY HZ_CUST_SITE_USE_BO_TBL,

346: PROCEDURE get_cust_site_use_bos(
347: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
348: p_cust_acct_site_id IN NUMBER,
349: p_action_type IN VARCHAR2 := NULL,
350: x_cust_site_use_objs OUT NOCOPY HZ_CUST_SITE_USE_BO_TBL,
351: x_return_status OUT NOCOPY VARCHAR2,
352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2
354: ) is

Line 358: SELECT HZ_CUST_SITE_USE_BO(

354: ) is
355: l_debug_prefix VARCHAR2(30) := '';
356:
357: CURSOR C1 IS
358: SELECT HZ_CUST_SITE_USE_BO(
359: P_ACTION_TYPE,
360: NULL, -- COMMON_OBJ_ID
361: CSU.SITE_USE_ID,
362: NULL, --CSU.ORIG_SYSTEM,

Line 590: x_cust_site_use_objs := HZ_CUST_SITE_USE_BO_TBL();

586: p_prefix=>l_debug_prefix,
587: p_msg_level=>fnd_log.level_procedure);
588: END IF;
589:
590: x_cust_site_use_objs := HZ_CUST_SITE_USE_BO_TBL();
591: open c1;
592: fetch c1 BULK COLLECT into x_cust_site_use_objs;
593: close c1;
594:

Line 933: HZ_CUST_SITE_USE_BO_TBL(),

929: WHERE
930: OSR.OWNER_TABLE_ID = CAS.PARTY_SITE_ID
931: AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
932: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- party site ssm
933: HZ_CUST_SITE_USE_BO_TBL(),
934: HZ_CUST_ACCT_CONTACT_BO_TBL())
935: FROM HZ_CUST_ACCT_SITES CAS
936: WHERE ((P_CUST_ACCT_SITE_ID IS NULL AND CUST_ACCOUNT_ID = P_PARENT_ID)
937: OR (P_CUST_ACCT_SITE_ID IS NOT NULL