DBA Data[Home] [Help]

APPS.HZ_EXTRACT_CUST_ACCT_BO_PVT dependencies on HZ_CUST_ACCT_RELATE_OBJ

Line 18: x_cust_acct_relate_objs OUT NOCOPY HZ_CUST_ACCT_RELATE_OBJ_TBL,

14: PROCEDURE get_cust_acct_relate_objs(
15: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
16: p_cust_acct_id IN NUMBER,
17: p_action_type IN VARCHAR2 := NULL,
18: x_cust_acct_relate_objs OUT NOCOPY HZ_CUST_ACCT_RELATE_OBJ_TBL,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2
22: ) is

Line 26: SELECT HZ_CUST_ACCT_RELATE_OBJ (

22: ) is
23: l_debug_prefix VARCHAR2(30) := '';
24:
25: CURSOR C1 IS
26: SELECT HZ_CUST_ACCT_RELATE_OBJ (
27: P_ACTION_TYPE,
28: NULL, -- COMMON_OBJ_ID
29: CUST_ACCOUNT_ID,
30: RELATED_CUST_ACCOUNT_ID,

Line 778: HZ_CUST_ACCT_RELATE_OBJ_TBL(),

774: WHERE
775: OSR.OWNER_TABLE_ID = CA.CUST_ACCOUNT_ID
776: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
777: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
778: HZ_CUST_ACCT_RELATE_OBJ_TBL(),
779: HZ_CUST_ACCT_SITE_BO_TBL(),
780: HZ_CUST_ACCT_CONTACT_BO_TBL(),
781: NULL, --CUST_PROFILE_OBJ,
782: CAST(MULTISET (

Line 1238: HZ_CUST_ACCT_RELATE_OBJ_TBL(),

1234: WHERE
1235: OSR.OWNER_TABLE_ID = CA.CUST_ACCOUNT_ID
1236: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
1237: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1238: HZ_CUST_ACCT_RELATE_OBJ_TBL(),
1239: HZ_CUST_ACCT_SITE_V2_BO_TBL(),
1240: HZ_CUST_ACCT_CONTACT_BO_TBL(),
1241: NULL, --CUST_PROFILE_OBJ,
1242: CAST(MULTISET (