24: p_ps_id IN NUMBER)
25: IS
26: BEGIN
27: IF party_site_in_match (p_party_id , p_ctx_id , p_ps_id) = 'N' THEN
28: INSERT INTO hz_matched_party_sites_gt
29: (PARTY_ID ,PARTY_SITE_ID,SEARCH_CONTEXT_ID ,SCORE) VALUES
30: (p_party_id,p_ps_id ,p_ctx_id, 0);
31: END IF;
32: END;
157: END;
158:
159: FUNCTION party_site_in_match
160: ----------------------------------------------------------
161: -- Return Y if p_cpt_id found in HZ_MATCHED_PARTY_SITES_GT
162: -- N otherwise
163: ----------------------------------------------------------
164: (p_party_id IN NUMBER,
165: p_ctx_id IN NUMBER,
167: RETURN VARCHAR2
168: IS
169: CURSOR c_exist IS
170: SELECT 'Y'
171: FROM hz_matched_party_sites_gt
172: WHERE party_id = p_party_id
173: AND search_context_id = p_ctx_id
174: AND party_site_id = p_ps_id;
175: ret VARCHAR2(1) := 'N';