DBA Data[Home] [Help]

APPS.HZ_EXTRACT_RELATIONSHIP_BO_PVT dependencies on HZ_RELATIONSHIP_OBJ

Line 50: x_relationship_objs OUT NOCOPY HZ_RELATIONSHIP_OBJ_TBL,

46: PROCEDURE get_relationship_bos(
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
48: p_subject_id IN NUMBER,
49: p_action_type IN VARCHAR2 := NULL,
50: x_relationship_objs OUT NOCOPY HZ_RELATIONSHIP_OBJ_TBL,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2
54: ) is

Line 57: SELECT HZ_RELATIONSHIP_OBJ(

53: x_msg_data OUT NOCOPY VARCHAR2
54: ) is
55:
56: CURSOR C1 IS
57: SELECT HZ_RELATIONSHIP_OBJ(
58: P_ACTION_TYPE,
59: NULL, -- COMMON_OBJ_ID
60: RELATIONSHIP_ID,
61: DECODE(SUBJECT_TYPE, 'ORGANIZATION', 'ORG', SUBJECT_TYPE),

Line 202: x_relationship_objs := HZ_RELATIONSHIP_OBJ_TBL();

198: p_prefix=>l_debug_prefix,
199: p_msg_level=>fnd_log.level_procedure);
200: END IF;
201:
202: x_relationship_objs := HZ_RELATIONSHIP_OBJ_TBL();
203: open c1;
204: fetch c1 BULK COLLECT into x_relationship_objs;
205: close c1;
206: