APPS.HZ_EXTRACT_ORG_CONT_BO_PVT dependencies on HZ_ORG_CONTACT_ROLE_OBJ

Line 292: x_org_cont_role_objs OUT NOCOPY HZ_ORG_CONTACT_ROLE_OBJ_TBL,

288: PROCEDURE get_org_contact_role_bos(
289: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
290: p_org_cont_id IN NUMBER,
291: p_action_type IN VARCHAR2 := NULL,
292: x_org_cont_role_objs OUT NOCOPY HZ_ORG_CONTACT_ROLE_OBJ_TBL,
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2
296: ) is

Line 299: SELECT HZ_ORG_CONTACT_ROLE_OBJ(

295: x_msg_data OUT NOCOPY VARCHAR2
296: ) is
297:
298: CURSOR C1 IS
299: SELECT HZ_ORG_CONTACT_ROLE_OBJ(
300: P_ACTION_TYPE,
301: NULL, -- COMMON_OBJ_ID
302: ORG_CONTACT_ROLE_ID,
303: NULL, --ORIG_SYSTEM,

Line 386: x_org_cont_role_objs := HZ_ORG_CONTACT_ROLE_OBJ_TBL();

382: p_prefix=>l_debug_prefix,
383: p_msg_level=>fnd_log.level_procedure);
384: END IF;
385:
386: x_org_cont_role_objs := HZ_ORG_CONTACT_ROLE_OBJ_TBL();
387: open c1;
388: fetch c1 BULK COLLECT into x_org_cont_role_objs;
389: close c1;
390:

Line 577: HZ_ORG_CONTACT_ROLE_OBJ_TBL(),

573: R.END_DATE,
574: R.STATUS,
575: HZ_ORIG_SYS_REF_OBJ_TBL(),
576: NULL, --PERSON_PROFILE_OBJ,
577: HZ_ORG_CONTACT_ROLE_OBJ_TBL(),
578: HZ_PARTY_SITE_BO_TBL(),
579: HZ_PHONE_CP_BO_TBL(),
580: HZ_TELEX_CP_BO_TBL(),
581: HZ_EMAIL_CP_BO_TBL(),