DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ACCT_SITE_BO_PVT dependencies on HZ_CUSTOMER_PROFILE_BO

Line 18: x_cust_profile_obj OUT NOCOPY HZ_CUSTOMER_PROFILE_BO,

14: PROCEDURE get_site_use_profile_bo(
15: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
16: p_site_use_id IN NUMBER,
17: p_action_type IN VARCHAR2 := NULL,
18: x_cust_profile_obj OUT NOCOPY HZ_CUSTOMER_PROFILE_BO,
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_CUSTOMER_PROFILE_BO(

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

Line 511: NULL, --HZ_CUSTOMER_PROFILE_BO

507: FROM HZ_ORIG_SYS_REFERENCES OSR
508: WHERE OSR.OWNER_TABLE_ID = CSU.SITE_USE_ID
509: AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'
510: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
511: NULL, --HZ_CUSTOMER_PROFILE_BO
512: CAST(MULTISET (
513: SELECT HZ_BANK_ACCT_USE_OBJ(
514: P_ACTION_TYPE,
515: NULL, -- COMMON_OBJ_ID

Line 1257: NULL, --HZ_CUSTOMER_PROFILE_BO

1253: FROM HZ_ORIG_SYS_REFERENCES OSR
1254: WHERE OSR.OWNER_TABLE_ID = CSU.SITE_USE_ID
1255: AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'
1256: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1257: NULL, --HZ_CUSTOMER_PROFILE_BO
1258: CAST(MULTISET (
1259: SELECT HZ_BANK_ACCT_USE_OBJ(
1260: P_ACTION_TYPE,
1261: NULL, -- COMMON_OBJ_ID