DBA Data[Home] [Help]

APPS.HZ_EXTRACT_CONT_POINT_BO_PVT dependencies on HZ_PHONE_CP_BO

Line 72: x_phone_objs OUT NOCOPY HZ_PHONE_CP_BO_TBL,

68: p_phone_id IN NUMBER,
69: p_parent_id IN NUMBER,
70: p_parent_table_name IN VARCHAR2,
71: p_action_type IN VARCHAR2 := NULL,
72: x_phone_objs OUT NOCOPY HZ_PHONE_CP_BO_TBL,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2
76: ) is

Line 80: SELECT HZ_PHONE_CP_BO(

76: ) is
77:
78:
79: cursor c1 is
80: SELECT HZ_PHONE_CP_BO(
81: P_ACTION_TYPE,
82: NULL, -- COMMON_OBJ_ID
83: CONTACT_POINT_ID,
84: NULL, -- ORIG_SYSTEM,

Line 232: x_phone_objs := HZ_PHONE_CP_BO_TBL();

228: p_prefix=>l_debug_prefix,
229: p_msg_level=>fnd_log.level_procedure);
230: END IF;
231:
232: x_phone_objs := HZ_PHONE_CP_BO_TBL();
233: open c1;
234: fetch c1 BULK COLLECT into x_phone_objs;
235: close c1;
236: