APPS.ARH_DQM_TREE_HELPER dependencies on HZ_MATCHED_CONTACTS_GT

Line 41: INSERT INTO hz_matched_contacts_gt

37: p_contact_id IN NUMBER)
38: IS
39: BEGIN
40: IF contact_in_match (p_party_id , p_ctx_id , p_contact_id) = 'N' THEN
41: INSERT INTO hz_matched_contacts_gt
42: (PARTY_ID , ORG_CONTACT_ID, SEARCH_CONTEXT_ID, SCORE ) VALUES
43: (p_party_id, p_contact_id ,p_ctx_id, 0);
44: END IF;
45: END;

Line 134: -- Return Y if p_cpt_id found in HZ_MATCHED_CONTACTS_GT

130: END;
131:
132: FUNCTION contact_in_match
133: -------------------------------------------------------
134: -- Return Y if p_cpt_id found in HZ_MATCHED_CONTACTS_GT
135: -- N otherwise
136: -------------------------------------------------------
137: (p_party_id IN NUMBER,
138: p_ctx_id IN NUMBER,

Line 144: FROM hz_matched_contacts_gt

140: RETURN VARCHAR2
141: IS
142: CURSOR c_exist IS
143: SELECT 'Y'
144: FROM hz_matched_contacts_gt
145: WHERE party_id = p_party_id
146: AND search_context_id = p_ctx_id
147: AND org_contact_id = p_contact_id;
148: ret VARCHAR2(1) := 'N';