DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ACCT_CONT_BO_PVT dependencies on HZ_CUST_ACCT_CONTACT_BO

Line 76: x_cust_acct_contact_objs OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO_TBL,

72: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
73: p_parent_id IN NUMBER,
74: p_cust_acct_contact_id IN NUMBER,
75: p_action_type IN VARCHAR2 := NULL,
76: x_cust_acct_contact_objs OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO_TBL,
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,
79: x_msg_data OUT NOCOPY VARCHAR2
80: ) is

Line 84: SELECT HZ_CUST_ACCT_CONTACT_BO(

80: ) is
81: l_debug_prefix VARCHAR2(30) := '';
82:
83: CURSOR C1 IS
84: SELECT HZ_CUST_ACCT_CONTACT_BO(
85: P_ACTION_TYPE,
86: NULL, --COMMON_OBJ_ID
87: CAR.CUST_ACCOUNT_ROLE_ID, --CUST_ACCT_CONTACT_ID,
88: NULL, --ORIG_SYSTEM,

Line 287: x_cust_acct_contact_objs := HZ_CUST_ACCT_CONTACT_BO_TBL();

283: p_prefix=>l_debug_prefix,
284: p_msg_level=>fnd_log.level_procedure);
285: END IF;
286:
287: x_cust_acct_contact_objs := HZ_CUST_ACCT_CONTACT_BO_TBL();
288: open c1;
289: fetch c1 BULK COLLECT into x_cust_acct_contact_objs;
290: close c1;
291: