APPS.HZ_EXTRACT_ORG_CONT_BO_PVT dependencies on HZ_ORG_CONTACTS

Line 8: * @rep:category BUSINESS_ENTITY HZ_ORG_CONTACTS

4: * This package contains the private APIs for org contact information.
5: * @rep:scope private
6: * @rep:product HZ
7: * @rep:display name org contact
8: * @rep:category BUSINESS_ENTITY HZ_ORG_CONTACTS
9: * @rep:lifecycle active
10: * @rep:doccd 115hztig.pdf Get APIs
11: */
12:

Line 19: from hz_relationships r, hz_org_contacts oc

15: function get_id(p_org_cont_id in number, p_type in varchar2 ) return number is
16:
17: cursor get_cont_info_csr is
18: select r.subject_id, r.party_id
19: from hz_relationships r, hz_org_contacts oc
20: where r.relationship_id = oc.party_relationship_id
21: and oc.org_contact_id = p_org_cont_id
22: and r.subject_type = 'PERSON';
23:

Line 585: FROM HZ_ORG_CONTACTS OC, HZ_PARTIES P, HZ_RELATIONSHIPS R

581: HZ_EMAIL_CP_BO_TBL(),
582: HZ_WEB_CP_BO_TBL(),
583: HZ_SMS_CP_BO_TBL(),
584: HZ_CONTACT_PREF_OBJ_TBL())
585: FROM HZ_ORG_CONTACTS OC, HZ_PARTIES P, HZ_RELATIONSHIPS R
586: WHERE OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
587: AND R.SUBJECT_ID = P.PARTY_ID
588: AND R.OBJECT_TYPE = 'PERSON'
589: AND ((P_ORG_CONTACT_ID IS NULL AND P.PARTY_ID = P_ORGANIZATION_ID)

Line 651: p_owner_table_name => 'HZ_ORG_CONTACTS',

647:
648: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
649: (p_init_msg_list => fnd_api.g_false,
650: p_owner_table_id => x_org_contact_objs(i).org_contact_id,
651: p_owner_table_name => 'HZ_ORG_CONTACTS',
652: p_action_type => NULL, --p_action_type,
653: x_orig_sys_ref_objs => x_org_contact_objs(i).orig_sys_objs,
654: x_return_status => x_return_status,
655: x_msg_count => x_msg_count,