APPS.HZ_MATCH_RULE_51 dependencies on HZ_MATCHED_PARTY_SITES_GT

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

1898:
1899: ----------INSERT INTO HZ_MATCHED_PARTY_SITES -----
1900: IF p_ins_details = 'Y' THEN
1901: FORALL I in 1..h_ps_id.COUNT
1902: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID,PARTY_SITE_ID,PARTY_ID,SCORE) VALUES (
1903: l_search_ctx_id, h_ps_id(I), h_ps_party_id(I), h_ps_score(I));
1904: END IF;
1905: ----------INSERT INTO HZ_MATCHED_CONTACTS-----
1906: IF p_ins_details = 'Y' THEN

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

2550:
2551: ----------INSERT INTO HZ_MATCHED_PARTY_SITES -----
2552: IF p_ins_details = 'Y' THEN
2553: FORALL I in 1..h_ps_id.COUNT
2554: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID,PARTY_SITE_ID,PARTY_ID,SCORE) VALUES (
2555: l_search_ctx_id, h_ps_id(I), h_ps_party_id(I), h_ps_score(I));
2556: END IF;
2557: ----------INSERT INTO HZ_MATCHED_CONTACTS-----
2558: IF p_ins_details = 'Y' THEN

Line 2635: DELETE FROM HZ_MATCHED_PARTY_SITES_GT ps WHERE SEARCH_CONTEXT_ID = x_search_ctx_id

2631: END IF;
2632: find_parties(p_rule_id,p_party_search_rec,p_party_site_list, p_contact_list, p_contact_point_list,
2633: p_restrict_sql,p_match_type,p_search_merged,null,null, null,'Y',
2634: x_search_ctx_id,x_num_matches);
2635: DELETE FROM HZ_MATCHED_PARTY_SITES_GT ps WHERE SEARCH_CONTEXT_ID = x_search_ctx_id
2636: AND NOT EXISTS
2637: (SELECT 1 FROM HZ_MATCHED_PARTIES_GT p WHERE SEARCH_CONTEXT_ID = x_search_ctx_id AND p.PARTY_ID = ps.PARTY_ID);
2638: DELETE FROM HZ_MATCHED_CONTACTS_GT ct WHERE SEARCH_CONTEXT_ID = x_search_ctx_id
2639: AND NOT EXISTS

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

3532: 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);
3533: END IF;
3534: IF l_match_str = ' OR ' THEN
3535: IF (H_SCORES(l_party_site_id).TOTAL_SCORE/l_entered_max_score)>=(175/525) THEN
3536: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID, PARTY_ID, PARTY_SITE_ID, SCORE)
3537: 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);
3538: x_num_matches := x_num_matches+1;
3539: END IF;
3540: ELSE

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

3540: ELSE
3541: IF H_SCORES(l_party_site_id).PARTY_SITE_SCORE>0 AND
3542: H_SCORES(l_party_site_id).CONTACT_POINT_SCORE>0 AND
3543: (H_SCORES(l_party_site_id).TOTAL_SCORE/l_entered_max_score)>=(175/525) THEN
3544: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID, PARTY_ID, PARTY_SITE_ID, SCORE)
3545: 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));
3546: x_num_matches := x_num_matches+1;
3547: END IF;
3548: END IF;