APPS.HZ_MATCH_RULE_50 dependencies on HZ_MATCHED_PARTY_SITES_GT

Line 2176: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID,PARTY_SITE_ID,PARTY_ID,SCORE) VALUES (

2172:
2173: ----------INSERT INTO HZ_MATCHED_PARTY_SITES -----
2174: IF p_ins_details = 'Y' THEN
2175: FORALL I in 1..h_ps_id.COUNT
2176: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID,PARTY_SITE_ID,PARTY_ID,SCORE) VALUES (
2177: l_search_ctx_id, h_ps_id(I), h_ps_party_id(I), h_ps_score(I));
2178: END IF;
2179: ----------INSERT INTO HZ_MATCHED_CONTACTS-----
2180: IF p_ins_details = 'Y' THEN

Line 2830: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID,PARTY_SITE_ID,PARTY_ID,SCORE) VALUES (

2826:
2827: ----------INSERT INTO HZ_MATCHED_PARTY_SITES -----
2828: IF p_ins_details = 'Y' THEN
2829: FORALL I in 1..h_ps_id.COUNT
2830: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID,PARTY_SITE_ID,PARTY_ID,SCORE) VALUES (
2831: l_search_ctx_id, h_ps_id(I), h_ps_party_id(I), h_ps_score(I));
2832: END IF;
2833: ----------INSERT INTO HZ_MATCHED_CONTACTS-----
2834: IF p_ins_details = 'Y' THEN

Line 2911: DELETE FROM HZ_MATCHED_PARTY_SITES_GT ps WHERE SEARCH_CONTEXT_ID = x_search_ctx_id

2907: END IF;
2908: find_parties(p_rule_id,p_party_search_rec,p_party_site_list, p_contact_list, p_contact_point_list,
2909: p_restrict_sql,p_match_type,p_search_merged,null,null, null,'Y',
2910: x_search_ctx_id,x_num_matches);
2911: DELETE FROM HZ_MATCHED_PARTY_SITES_GT ps WHERE SEARCH_CONTEXT_ID = x_search_ctx_id
2912: AND NOT EXISTS
2913: (SELECT 1 FROM HZ_MATCHED_PARTIES_GT p WHERE SEARCH_CONTEXT_ID = x_search_ctx_id AND p.PARTY_ID = ps.PARTY_ID);
2914: DELETE FROM HZ_MATCHED_CONTACTS_GT ct WHERE SEARCH_CONTEXT_ID = x_search_ctx_id
2915: AND NOT EXISTS

Line 3840: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID, PARTY_ID, PARTY_SITE_ID, SCORE)

3836: hz_utility_v2pub.debug(p_message=>'Score '||round((H_SCORES(l_party_site_id).TOTAL_SCORE/l_entered_max_score)*100),p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3837: END IF;
3838: IF l_match_str = ' OR ' THEN
3839: IF (H_SCORES(l_party_site_id).TOTAL_SCORE/l_entered_max_score)>=(175/725) THEN
3840: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID, PARTY_ID, PARTY_SITE_ID, SCORE)
3841: VALUES (l_search_ctx_id,H_SCORES(l_party_site_id).PARTY_ID, H_SCORES(l_party_site_id).PARTY_SITE_ID, (H_SCORES(l_party_site_id).TOTAL_SCORE/l_entered_max_score)*100);
3842: x_num_matches := x_num_matches+1;
3843: END IF;
3844: ELSE

Line 3848: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID, PARTY_ID, PARTY_SITE_ID, SCORE)

3844: ELSE
3845: IF H_SCORES(l_party_site_id).PARTY_SITE_SCORE>0 AND
3846: H_SCORES(l_party_site_id).CONTACT_POINT_SCORE>0 AND
3847: (H_SCORES(l_party_site_id).TOTAL_SCORE/l_entered_max_score)>=(175/725) THEN
3848: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID, PARTY_ID, PARTY_SITE_ID, SCORE)
3849: VALUES (l_search_ctx_id,H_SCORES(l_party_site_id).PARTY_ID, H_SCORES(l_party_site_id).PARTY_SITE_ID, round((H_SCORES(l_party_site_id).TOTAL_SCORE/l_entered_max_score)*100));
3850: x_num_matches := x_num_matches+1;
3851: END IF;
3852: END IF;