DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_99 dependencies on DUAL

Line 3352: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

3348: l_party_contains_str := INIT_PARTY_QUERY(l_match_str, l_denorm_str, l_party_max_score, l_denorm_max_score, l_non_denorm_max_score, round((269/340)*l_entered_max_score));
3349: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
3350:
3351: -- Setup Search Context ID
3352: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
3353: x_search_ctx_id := l_search_ctx_id;
3354:
3355: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3356: hz_utility_v2pub.debug(p_message=>'Search context id in find_parties is '||x_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 4229: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

4225: l_party_contains_str := INIT_PARTY_QUERY(l_match_str, null, 0, 0, 0,0);
4226: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
4227:
4228: -- Setup Search Context ID
4229: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
4230: x_search_ctx_id := l_search_ctx_id;
4231:
4232: IF l_party_contains_str IS NULL THEN
4233: defpt := 1;

Line 4441: SELECT HZ_MERGE_BATCH_S.nextval INTO x_dup_set_id FROM DUAL;

4437: RETURN;
4438: END IF;
4439: x_dup_set_id := NULL;
4440: IF p_dup_batch_id IS NOT NULL THEN
4441: SELECT HZ_MERGE_BATCH_S.nextval INTO x_dup_set_id FROM DUAL;
4442: END IF;
4443:
4444: --Fix for bug 4417124
4445: IF l_party_rec.PARTY_TYPE = 'PERSON' AND (l_use_contact_addr_info OR l_use_contact_cpt_info) THEN

Line 5182: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

5178: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
5179: init_score_context(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,p_party_site_list,HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,p_contact_point_list);
5180:
5181: -- Setup Search Context ID
5182: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
5183: x_search_ctx_id := l_search_ctx_id;
5184:
5185: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5186: hz_utility_v2pub.debug(p_message=>'l_match_str '||l_match_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 5415: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

5411: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
5412: init_score_context(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,p_contact_list,p_contact_point_list);
5413:
5414: -- Setup Search Context ID
5415: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
5416: x_search_ctx_id := l_search_ctx_id;
5417:
5418: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5419: hz_utility_v2pub.debug(p_message=>'l_match_str '||l_match_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 5626: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

5622: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
5623: init_score_context(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,p_contact_point_list);
5624:
5625: -- Setup Search Context ID
5626: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
5627: x_search_ctx_id := l_search_ctx_id;
5628: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5629: hz_utility_v2pub.debug(p_message=>'l_match_str '||l_match_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5630: hz_utility_v2pub.debug(p_message=>'l_contact_pt_contains_str '||l_contact_pt_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 5804: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

5800: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
5801:
5802: -- Setup Search Context ID
5803: IF x_search_ctx_id IS NULL THEN
5804: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
5805: x_search_ctx_id := l_search_ctx_id;
5806: ELSE
5807: l_search_ctx_id := x_search_ctx_id;
5808: END IF;