APPS.ARH_DQM_TREE_HELPER dependencies on HZ_MATCHED_CPTS_GT

Line 54: INSERT INTO hz_matched_cpts_gt

50: p_cpt_id IN NUMBER)
51: IS
52: BEGIN
53: IF cpt_in_match (p_party_id , p_ctx_id , p_cpt_id) = 'N' THEN
54: INSERT INTO hz_matched_cpts_gt
55: (PARTY_ID , CONTACT_POINT_ID, SEARCH_CONTEXT_ID , SCORE) VALUES
56: (p_party_id, p_cpt_id , p_ctx_id, 0);
57: END IF;
58: END;

Line 107: -- Return Y if p_cpt_id found in HZ_MATCHED_CPTS_GT

103:
104:
105: FUNCTION cpt_in_match
106: ---------------------------------------------------
107: -- Return Y if p_cpt_id found in HZ_MATCHED_CPTS_GT
108: -- N otherwise
109: ---------------------------------------------------
110: (p_party_id IN NUMBER,
111: p_ctx_id IN NUMBER,

Line 117: FROM hz_matched_cpts_gt

113: RETURN VARCHAR2
114: IS
115: CURSOR c_exist IS
116: SELECT 'Y'
117: FROM hz_matched_cpts_gt
118: WHERE party_id = p_party_id
119: AND search_context_id = p_ctx_id
120: AND contact_point_id = p_cpt_id;
121: ret VARCHAR2(1) := 'N';