DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_35 dependencies on HZ_MATCHED_PARTY_SITES_GT

Line 2687: hz_utility_v2pub.debug(p_message=>'In eval_party_site_level inserting into HZ_MATCHED_PARTY_SITES_GT from the H_PS_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2683: CLOSE l_party_site_cur;
2684: ROLLBACK to eval_start;
2685: IF p_ins_details = 'Y' THEN
2686: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2687: hz_utility_v2pub.debug(p_message=>'In eval_party_site_level inserting into HZ_MATCHED_PARTY_SITES_GT from the H_PS_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2688: END IF;
2689: FORALL I in 1..h_ps_id.COUNT
2690: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID,PARTY_SITE_ID,PARTY_ID,SCORE) VALUES (
2691: l_search_ctx_id, h_ps_id(I), h_ps_party_id(I), h_ps_score(I));

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

2686: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2687: hz_utility_v2pub.debug(p_message=>'In eval_party_site_level inserting into HZ_MATCHED_PARTY_SITES_GT from the H_PS_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2688: END IF;
2689: FORALL I in 1..h_ps_id.COUNT
2690: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID,PARTY_SITE_ID,PARTY_ID,SCORE) VALUES (
2691: l_search_ctx_id, h_ps_id(I), h_ps_party_id(I), h_ps_score(I));
2692: END IF;
2693: END;
2694:

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

3671: CLOSE l_party_site_cur;
3672: ROLLBACK to eval_start;
3673: IF p_ins_details = 'Y' THEN
3674: FORALL I in 1..h_ps_id.COUNT
3675: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID,PARTY_SITE_ID,PARTY_ID,SCORE) VALUES (
3676: l_search_ctx_id, h_ps_id(I), h_ps_party_id(I), h_ps_score(I));
3677: END IF;
3678: END;
3679:

Line 4196: DELETE FROM HZ_MATCHED_PARTY_SITES_GT ps WHERE SEARCH_CONTEXT_ID = x_search_ctx_id

4192: END IF;
4193: find_parties(p_rule_id,p_party_search_rec,p_party_site_list, p_contact_list, p_contact_point_list,
4194: p_restrict_sql,p_match_type,p_search_merged,null,null, null,'Y',
4195: x_search_ctx_id,x_num_matches);
4196: DELETE FROM HZ_MATCHED_PARTY_SITES_GT ps WHERE SEARCH_CONTEXT_ID = x_search_ctx_id
4197: AND NOT EXISTS
4198: (SELECT 1 FROM HZ_MATCHED_PARTIES_GT p WHERE SEARCH_CONTEXT_ID = x_search_ctx_id AND p.PARTY_ID = ps.PARTY_ID);
4199: DELETE FROM HZ_MATCHED_CONTACTS_GT ct WHERE SEARCH_CONTEXT_ID = x_search_ctx_id
4200: AND NOT EXISTS

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

5076: 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);
5077: END IF;
5078: IF l_match_str = ' OR ' THEN
5079: IF (H_SCORES(l_party_site_id).TOTAL_SCORE/l_entered_max_score)>=( 71/215 ) THEN
5080: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID, PARTY_ID, PARTY_SITE_ID, SCORE)
5081: 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);
5082: x_num_matches := x_num_matches+1;
5083: END IF;
5084: ELSE

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

5084: ELSE
5085: IF H_SCORES(l_party_site_id).PARTY_SITE_SCORE>0 AND
5086: H_SCORES(l_party_site_id).CONTACT_POINT_SCORE>0 AND
5087: (H_SCORES(l_party_site_id).TOTAL_SCORE/l_entered_max_score)>=(71/215) THEN
5088: INSERT INTO HZ_MATCHED_PARTY_SITES_GT (SEARCH_CONTEXT_ID, PARTY_ID, PARTY_SITE_ID, SCORE)
5089: 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));
5090: x_num_matches := x_num_matches+1;
5091: END IF;
5092: END IF;