eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_52 dependencies on CONTAINS

Line 1156: p_contains_str VARCHAR2,

1152:
1153: PROCEDURE open_party_cursor(
1154: p_dup_party_id NUMBER,
1155: p_restrict_sql VARCHAR2,
1156: p_contains_str VARCHAR2,
1157: p_search_ctx_id NUMBER,
1158: p_match_str VARCHAR2,
1159: p_search_merged VARCHAR2,
1160: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

Line 1163: IF p_contains_str IS NULL THEN

1159: p_search_merged VARCHAR2,
1160: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1161: l_sqlstr VARCHAR2(4000);
1162: BEGIN
1163: IF p_contains_str IS NULL THEN
1164: OPEN x_cursor FOR
1165: SELECT PARTY_ID , TX2, TX59, lpad(rtrim(TX41),9,chr(48)), TX45
1166: FROM HZ_STAGED_PARTIES stage
1167: WHERE PARTY_ID = p_dup_party_id;

Line 1256: OPEN x_cursor FOR l_sqlstr USING p_contains_str

1252: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';
1253: IF p_search_merged IS NULL OR p_search_merged <> 'Y' THEN
1254: l_sqlstr := l_sqlstr ||' AND nvl(stage.status,''A'') in (''A'')';
1255: END IF;
1256: OPEN x_cursor FOR l_sqlstr USING p_contains_str
1257: ,g_party_stage_rec.TX36,g_party_stage_rec.TX36
1258: ,g_party_stage_rec.TX46,g_party_stage_rec.TX46
1259: ,p_dup_party_id, p_dup_party_id;
1260: END IF;

Line 1277: p_contains_str VARCHAR2,

1273: PROCEDURE open_party_site_cursor(
1274: p_dup_party_id NUMBER,
1275: p_party_id NUMBER,
1276: p_restrict_sql VARCHAR2,
1277: p_contains_str VARCHAR2,
1278: p_search_ctx_id NUMBER,
1279: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1280: l_sqlstr VARCHAR2(4000);
1281: BEGIN

Line 1354: OPEN x_cursor FOR l_sqlstr USING p_contains_str

1350: ' AND p.party_id = stage.party_id ' ||
1351: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36) AND (:TX46 IS NULL OR :TX46||'' '' = p.TX46))) ' ||
1352: ' AND ('||p_restrict_sql||')' ||
1353: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';
1354: OPEN x_cursor FOR l_sqlstr USING p_contains_str
1355: ,g_party_stage_rec.TX36,g_party_stage_rec.TX36
1356: ,g_party_stage_rec.TX46,g_party_stage_rec.TX46
1357: ,p_dup_party_id, p_dup_party_id;
1358: END IF;

Line 1374: p_contains_str VARCHAR2,

1370: PROCEDURE open_contact_cursor(
1371: p_dup_party_id NUMBER,
1372: p_party_id NUMBER,
1373: p_restrict_sql VARCHAR2,
1374: p_contains_str VARCHAR2,
1375: p_search_ctx_id NUMBER,
1376: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1377: l_sqlstr VARCHAR2(4000);
1378: BEGIN

Line 1455: OPEN x_cursor FOR l_sqlstr USING p_contains_str

1451: ' WHERE p.party_id = stage.party_id ' ||
1452: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36) AND (:TX46 IS NULL OR :TX46||'' '' = p.TX46))) ' ||
1453: ' AND ('||p_restrict_sql||')' ||
1454: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';
1455: OPEN x_cursor FOR l_sqlstr USING p_contains_str
1456: ,g_party_stage_rec.TX36,g_party_stage_rec.TX36
1457: ,g_party_stage_rec.TX46,g_party_stage_rec.TX46
1458: ,p_dup_party_id, p_dup_party_id;
1459: END IF;

Line 1475: p_contains_str VARCHAR2,

1471: PROCEDURE open_contact_pt_cursor(
1472: p_dup_party_id NUMBER,
1473: p_party_id NUMBER,
1474: p_restrict_sql VARCHAR2,
1475: p_contains_str VARCHAR2,
1476: p_search_ctx_id NUMBER,
1477: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1478: l_sqlstr VARCHAR2(4000);
1479: BEGIN

Line 1596: OPEN x_cursor FOR l_sqlstr USING p_contains_str

1592: ' WHERE p.party_id = stage.party_id ' ||
1593: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36) AND (:TX46 IS NULL OR :TX46||'' '' = p.TX46))) ' ||
1594: ' AND ('||p_restrict_sql||')' ||
1595: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';
1596: OPEN x_cursor FOR l_sqlstr USING p_contains_str
1597: ,g_party_stage_rec.TX36,g_party_stage_rec.TX36
1598: ,g_party_stage_rec.TX46,g_party_stage_rec.TX46
1599: ,p_dup_party_id, p_dup_party_id;
1600: END IF;

Line 1670: l_party_contains_str VARCHAR2(32000);

1666: x_num_matches OUT NUMBER
1667: ) IS
1668:
1669: -- Strings to hold the generated Intermedia query strings
1670: l_party_contains_str VARCHAR2(32000);
1671: l_party_site_contains_str VARCHAR2(32000);
1672: l_contact_contains_str VARCHAR2(32000);
1673: l_contact_pt_contains_str VARCHAR2(32000);
1674: l_denorm_str VARCHAR2(32000);

Line 1671: l_party_site_contains_str VARCHAR2(32000);

1667: ) IS
1668:
1669: -- Strings to hold the generated Intermedia query strings
1670: l_party_contains_str VARCHAR2(32000);
1671: l_party_site_contains_str VARCHAR2(32000);
1672: l_contact_contains_str VARCHAR2(32000);
1673: l_contact_pt_contains_str VARCHAR2(32000);
1674: l_denorm_str VARCHAR2(32000);
1675: l_ps_denorm_str VARCHAR2(32000);

Line 1672: l_contact_contains_str VARCHAR2(32000);

1668:
1669: -- Strings to hold the generated Intermedia query strings
1670: l_party_contains_str VARCHAR2(32000);
1671: l_party_site_contains_str VARCHAR2(32000);
1672: l_contact_contains_str VARCHAR2(32000);
1673: l_contact_pt_contains_str VARCHAR2(32000);
1674: l_denorm_str VARCHAR2(32000);
1675: l_ps_denorm_str VARCHAR2(32000);
1676: l_ct_denorm_str VARCHAR2(32000);

Line 1673: l_contact_pt_contains_str VARCHAR2(32000);

1669: -- Strings to hold the generated Intermedia query strings
1670: l_party_contains_str VARCHAR2(32000);
1671: l_party_site_contains_str VARCHAR2(32000);
1672: l_contact_contains_str VARCHAR2(32000);
1673: l_contact_pt_contains_str VARCHAR2(32000);
1674: l_denorm_str VARCHAR2(32000);
1675: l_ps_denorm_str VARCHAR2(32000);
1676: l_ct_denorm_str VARCHAR2(32000);
1677: l_cpt_denorm_str VARCHAR2(32000);

Line 1772: PROCEDURE eval_party_level(p_party_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER) IS

1768: call_type(2) := 'OR';
1769: END;
1770:
1771: /** Private procedure to acquire and score at party level ***/
1772: PROCEDURE eval_party_level(p_party_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER) IS
1773: l_party_id_idx NUMBER:=1;
1774: l_ctx_id NUMBER;
1775: BEGIN
1776: SAVEPOINT eval_start;

Line 1794: open_party_cursor(p_dup_party_id, p_restrict_sql, p_party_contains_str,l_ctx_id, l_match_str,p_search_merged,l_party_cur);

1790: ELSE
1791: l_ctx_id := NULL;
1792: l_party_id_idx := H_PARTY_ID.COUNT+1;
1793: END IF;
1794: open_party_cursor(p_dup_party_id, p_restrict_sql, p_party_contains_str,l_ctx_id, l_match_str,p_search_merged,l_party_cur);
1795: LOOP
1796: FETCH l_party_cur INTO
1797: l_party_id , l_TX2, l_TX59, l_TX41, l_TX45;
1798: EXIT WHEN l_party_cur%NOTFOUND;

Line 1838: PROCEDURE eval_party_site_level(p_party_site_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER,p_ins_details VARCHAR2,p_emax_score NUMBER) IS

1834: ROLLBACK to eval_start;
1835: END;
1836:
1837: /** Private procedure to acquire and score at party site level ***/
1838: PROCEDURE eval_party_site_level(p_party_site_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
1839: l_party_id_idx NUMBER:=1;
1840: l_ctx_id NUMBER;
1841: BEGIN
1842: SAVEPOINT eval_start;

Line 1860: open_party_site_cursor(p_dup_party_id,NULL, p_restrict_sql, p_party_site_contains_str,l_ctx_id, l_party_site_cur);

1856: ELSE
1857: l_party_id_idx := H_PARTY_ID.COUNT+1;
1858: l_ctx_id := NULL;
1859: END IF;
1860: open_party_site_cursor(p_dup_party_id,NULL, p_restrict_sql, p_party_site_contains_str,l_ctx_id, l_party_site_cur);
1861: LOOP
1862: FETCH l_party_site_cur INTO
1863: l_party_site_id, l_ps_party_id, l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;
1864: EXIT WHEN l_party_site_cur%NOTFOUND;

Line 1915: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER,p_ins_details VARCHAR2,p_emax_score NUMBER) IS

1911: ROLLBACK to eval_start;
1912: END;
1913:
1914: /** Private procedure to acquire and score at party site level ***/
1915: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
1916: l_party_id_idx NUMBER:=1;
1917: l_ctx_id NUMBER;
1918: BEGIN
1919: SAVEPOINT eval_start;

Line 1937: open_contact_cursor(p_dup_party_id,NULL, p_restrict_sql, p_contact_contains_str,l_ctx_id, l_contact_cur);

1933: ELSE
1934: l_ctx_id := NULL;
1935: l_party_id_idx := H_PARTY_ID.COUNT+1;
1936: END IF;
1937: open_contact_cursor(p_dup_party_id,NULL, p_restrict_sql, p_contact_contains_str,l_ctx_id, l_contact_cur);
1938: LOOP
1939: FETCH l_contact_cur INTO
1940: l_org_contact_id, l_ct_party_id , l_TX2, l_TX23, l_TX22;
1941: EXIT WHEN l_contact_cur%NOTFOUND;

Line 1990: PROCEDURE eval_cpt_level(p_contact_pt_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER, p_ins_details VARCHAR2,p_emax_score NUMBER) IS

1986: ROLLBACK to eval_start;
1987: END;
1988:
1989: /** Private procedure to acquire and score at contact point level ***/
1990: PROCEDURE eval_cpt_level(p_contact_pt_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER, p_ins_details VARCHAR2,p_emax_score NUMBER) IS
1991: l_party_id_idx NUMBER:=1;
1992: l_ctx_id NUMBER;
1993: BEGIN
1994: SAVEPOINT eval_start;

Line 2012: open_contact_pt_cursor(p_dup_party_id,NULL, p_restrict_sql, p_contact_pt_contains_str,l_ctx_id, l_contact_pt_cur);

2008: ELSE
2009: l_ctx_id := NULL;
2010: l_party_id_idx := H_PARTY_ID.COUNT+1;
2011: END IF;
2012: open_contact_pt_cursor(p_dup_party_id,NULL, p_restrict_sql, p_contact_pt_contains_str,l_ctx_id, l_contact_pt_cur);
2013: LOOP
2014: FETCH l_contact_pt_cur INTO
2015: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX7, l_TX10, l_TX158;
2016: EXIT WHEN l_contact_pt_cur%NOTFOUND;

Line 2089: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

2085: FND_MSG_PUB.ADD;
2086: RAISE FND_API.G_EXC_ERROR;
2087: END IF;
2088: END IF;
2089: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2090: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2091: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2092: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2093: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN

Line 2090: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

2086: RAISE FND_API.G_EXC_ERROR;
2087: END IF;
2088: END IF;
2089: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2090: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2091: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2092: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2093: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
2094: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));

Line 2091: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN

2087: END IF;
2088: END IF;
2089: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2090: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2091: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2092: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2093: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
2094: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2095: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN

Line 2092: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));

2088: END IF;
2089: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2090: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2091: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2092: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2093: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
2094: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2095: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2096: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));

Line 2093: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN

2089: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2090: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2091: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2092: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2093: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
2094: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2095: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2096: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2097: END IF;

Line 2094: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));

2090: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2091: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2092: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2093: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
2094: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2095: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2096: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2097: END IF;
2098: END;

Line 2095: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN

2091: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2092: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2093: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
2094: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2095: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2096: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2097: END IF;
2098: END;
2099: /************ End of find_parties private procedures **********/

Line 2096: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));

2092: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2093: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
2094: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2095: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2096: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2097: END IF;
2098: END;
2099: /************ End of find_parties private procedures **********/
2100:

Line 2151: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);

2147: g_score_until_thresh := true;
2148: ELSE
2149: g_score_until_thresh := false;
2150: END IF;
2151: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2152: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2153: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2154: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2155: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);

Line 2152: l_contact_contains_str := check_contacts_bulk (p_contact_list);

2148: ELSE
2149: g_score_until_thresh := false;
2150: END IF;
2151: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2152: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2153: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2154: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2155: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2156:

Line 2153: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

2149: g_score_until_thresh := false;
2150: END IF;
2151: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2152: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2153: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2154: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2155: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2156:
2157: -- Setup Search Context ID

Line 2154: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;

2150: END IF;
2151: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2152: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2153: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2154: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2155: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2156:
2157: -- Setup Search Context ID
2158: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

Line 2161: IF l_party_contains_str IS NULL THEN

2157: -- Setup Search Context ID
2158: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
2159: x_search_ctx_id := l_search_ctx_id;
2160:
2161: IF l_party_contains_str IS NULL THEN
2162: defpt := 1;
2163: END IF;
2164: IF l_party_site_contains_str IS NULL THEN
2165: defps := 1;

Line 2164: IF l_party_site_contains_str IS NULL THEN

2160:
2161: IF l_party_contains_str IS NULL THEN
2162: defpt := 1;
2163: END IF;
2164: IF l_party_site_contains_str IS NULL THEN
2165: defps := 1;
2166: END IF;
2167: IF l_contact_contains_str IS NULL THEN
2168: defct := 1;

Line 2167: IF l_contact_contains_str IS NULL THEN

2163: END IF;
2164: IF l_party_site_contains_str IS NULL THEN
2165: defps := 1;
2166: END IF;
2167: IF l_contact_contains_str IS NULL THEN
2168: defct := 1;
2169: END IF;
2170: IF l_contact_pt_contains_str IS NULL THEN
2171: defcpt := 1;

Line 2170: IF l_contact_pt_contains_str IS NULL THEN

2166: END IF;
2167: IF l_contact_contains_str IS NULL THEN
2168: defct := 1;
2169: END IF;
2170: IF l_contact_pt_contains_str IS NULL THEN
2171: defcpt := 1;
2172: END IF;
2173:
2174: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2176: hz_utility_v2pub.debug(p_message=>'l_party_contains_str '||l_party_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2172: END IF;
2173:
2174: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2175: 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);
2176: hz_utility_v2pub.debug(p_message=>'l_party_contains_str '||l_party_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2177: hz_utility_v2pub.debug(p_message=>'l_party_site_contains_str '||l_party_site_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2178: hz_utility_v2pub.debug(p_message=>'l_contact_contains_str '||l_contact_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2179: 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);
2180: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 2177: hz_utility_v2pub.debug(p_message=>'l_party_site_contains_str '||l_party_site_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2173:
2174: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2175: 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);
2176: hz_utility_v2pub.debug(p_message=>'l_party_contains_str '||l_party_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2177: hz_utility_v2pub.debug(p_message=>'l_party_site_contains_str '||l_party_site_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2178: hz_utility_v2pub.debug(p_message=>'l_contact_contains_str '||l_contact_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2179: 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);
2180: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2181: END IF;

Line 2178: hz_utility_v2pub.debug(p_message=>'l_contact_contains_str '||l_contact_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2174: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2175: 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);
2176: hz_utility_v2pub.debug(p_message=>'l_party_contains_str '||l_party_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2177: hz_utility_v2pub.debug(p_message=>'l_party_site_contains_str '||l_party_site_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2178: hz_utility_v2pub.debug(p_message=>'l_contact_contains_str '||l_contact_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2179: 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);
2180: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2181: END IF;
2182: FOR I in 1..5 LOOP

Line 2179: 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);

2175: 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);
2176: hz_utility_v2pub.debug(p_message=>'l_party_contains_str '||l_party_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2177: hz_utility_v2pub.debug(p_message=>'l_party_site_contains_str '||l_party_site_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2178: hz_utility_v2pub.debug(p_message=>'l_contact_contains_str '||l_contact_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2179: 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);
2180: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2181: END IF;
2182: FOR I in 1..5 LOOP
2183: do_eval(I);

Line 2297: l_party_contains_str VARCHAR2(32000);

2293: x_num_matches OUT NUMBER
2294: ) IS
2295:
2296: -- Strings to hold the generated Intermedia query strings
2297: l_party_contains_str VARCHAR2(32000);
2298: l_party_site_contains_str VARCHAR2(32000);
2299: l_contact_contains_str VARCHAR2(32000);
2300: l_contact_pt_contains_str VARCHAR2(32000);
2301: l_denorm_str VARCHAR2(32000);

Line 2298: l_party_site_contains_str VARCHAR2(32000);

2294: ) IS
2295:
2296: -- Strings to hold the generated Intermedia query strings
2297: l_party_contains_str VARCHAR2(32000);
2298: l_party_site_contains_str VARCHAR2(32000);
2299: l_contact_contains_str VARCHAR2(32000);
2300: l_contact_pt_contains_str VARCHAR2(32000);
2301: l_denorm_str VARCHAR2(32000);
2302: l_ps_denorm_str VARCHAR2(32000);

Line 2299: l_contact_contains_str VARCHAR2(32000);

2295:
2296: -- Strings to hold the generated Intermedia query strings
2297: l_party_contains_str VARCHAR2(32000);
2298: l_party_site_contains_str VARCHAR2(32000);
2299: l_contact_contains_str VARCHAR2(32000);
2300: l_contact_pt_contains_str VARCHAR2(32000);
2301: l_denorm_str VARCHAR2(32000);
2302: l_ps_denorm_str VARCHAR2(32000);
2303: l_ct_denorm_str VARCHAR2(32000);

Line 2300: l_contact_pt_contains_str VARCHAR2(32000);

2296: -- Strings to hold the generated Intermedia query strings
2297: l_party_contains_str VARCHAR2(32000);
2298: l_party_site_contains_str VARCHAR2(32000);
2299: l_contact_contains_str VARCHAR2(32000);
2300: l_contact_pt_contains_str VARCHAR2(32000);
2301: l_denorm_str VARCHAR2(32000);
2302: l_ps_denorm_str VARCHAR2(32000);
2303: l_ct_denorm_str VARCHAR2(32000);
2304: l_cpt_denorm_str VARCHAR2(32000);

Line 2435: PROCEDURE eval_party_level(p_party_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER) IS

2431: call_type(2) := 'OR';
2432: END;
2433:
2434: /** Private procedure to acquire and score at party level ***/
2435: PROCEDURE eval_party_level(p_party_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER) IS
2436: l_party_id_idx NUMBER:=1;
2437: l_ctx_id NUMBER;
2438: BEGIN
2439: SAVEPOINT eval_start;

Line 2458: open_party_cursor(null, p_restrict_sql, p_party_contains_str,l_ctx_id, l_match_str,null,l_party_cur);

2454: ELSE
2455: l_ctx_id := NULL;
2456: l_party_id_idx := H_PARTY_ID.COUNT+1;
2457: END IF;
2458: open_party_cursor(null, p_restrict_sql, p_party_contains_str,l_ctx_id, l_match_str,null,l_party_cur);
2459: LOOP
2460: FETCH l_party_cur INTO
2461: l_party_id , l_TX2, l_TX59, l_TX41, l_TX45;
2462: EXIT WHEN l_party_cur%NOTFOUND;

Line 2501: p_contains_str VARCHAR2,

2497: CLOSE l_party_cur;
2498: ROLLBACK to eval_start;
2499: END;
2500: PROCEDURE open_person_contact_cursor(
2501: p_contains_str VARCHAR2,
2502: p_search_ctx_id NUMBER,
2503: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2504: BEGIN
2505: OPEN x_cursor FOR

Line 2508: WHERE contains( concat_col, p_contains_str)>0

2504: BEGIN
2505: OPEN x_cursor FOR
2506: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX23, TX22
2507: FROM HZ_STAGED_CONTACTS stage
2508: WHERE contains( concat_col, p_contains_str)>0
2509: AND ORG_CONTACT_ID in (
2510: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
2511: org_contact_id
2512: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc

Line 2532: PROCEDURE eval_party_site_level(p_party_site_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER,p_ins_details VARCHAR2,p_emax_score NUMBER) IS

2528: end if;
2529: END;
2530:
2531: /** Private procedure to acquire and score at party site level ***/
2532: PROCEDURE eval_party_site_level(p_party_site_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
2533: l_party_id_idx NUMBER:=1;
2534: l_ctx_id NUMBER;
2535: l_person_id NUMBER;
2536: BEGIN

Line 2568: open_party_site_cursor(null,NULL, p_restrict_sql, p_party_site_contains_str,l_ctx_id, l_party_site_cur);

2564: ELSE
2565: l_party_id_idx := H_PARTY_ID.COUNT+1;
2566: l_ctx_id := NULL;
2567: END IF;
2568: open_party_site_cursor(null,NULL, p_restrict_sql, p_party_site_contains_str,l_ctx_id, l_party_site_cur);
2569: LOOP
2570: FETCH l_party_site_cur INTO
2571: l_party_site_id, l_ps_party_id, l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;
2572: EXIT WHEN l_party_site_cur%NOTFOUND;

Line 2626: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_ins_details VARCHAR2,p_emax_score NUMBER) IS

2622: ROLLBACK to eval_start;
2623: END;
2624:
2625: /** Private procedure to acquire and score at party site level ***/
2626: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
2627: l_party_id_idx NUMBER:=1;
2628: l_ctx_id NUMBER;
2629: BEGIN
2630: SAVEPOINT eval_start;

Line 2637: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);

2633: FORALL I in 1..H_PARTY_ID.COUNT
2634: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2635: l_search_ctx_id,H_PARTY_ID(I));
2636: l_party_id_idx := H_PARTY_ID.COUNT+1;
2637: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
2638: LOOP
2639: FETCH l_contact_cur INTO
2640: l_org_contact_id, l_ct_party_id , l_TX2, l_TX23, l_TX22;
2641: EXIT WHEN l_contact_cur%NOTFOUND;

Line 2670: PROCEDURE eval_cpt_level(p_contact_pt_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER, p_ins_details VARCHAR2,p_emax_score NUMBER) IS

2666: ROLLBACK to eval_start;
2667: END;
2668:
2669: /** Private procedure to acquire and score at contact point level ***/
2670: PROCEDURE eval_cpt_level(p_contact_pt_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER, p_ins_details VARCHAR2,p_emax_score NUMBER) IS
2671: l_party_id_idx NUMBER:=1;
2672: l_ctx_id NUMBER;
2673: BEGIN
2674: SAVEPOINT eval_start;

Line 2705: open_contact_pt_cursor(null,NULL, p_restrict_sql, p_contact_pt_contains_str,l_ctx_id, l_contact_pt_cur);

2701: ELSE
2702: l_ctx_id := NULL;
2703: l_party_id_idx := H_PARTY_ID.COUNT+1;
2704: END IF;
2705: open_contact_pt_cursor(null,NULL, p_restrict_sql, p_contact_pt_contains_str,l_ctx_id, l_contact_pt_cur);
2706: LOOP
2707: FETCH l_contact_pt_cur INTO
2708: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX7, l_TX10, l_TX158;
2709: EXIT WHEN l_contact_pt_cur%NOTFOUND;

Line 2790: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

2786: FND_MSG_PUB.ADD;
2787: RAISE FND_API.G_EXC_ERROR;
2788: END IF;
2789: END IF;
2790: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2791: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2792: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2793: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2794: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN

Line 2791: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

2787: RAISE FND_API.G_EXC_ERROR;
2788: END IF;
2789: END IF;
2790: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2791: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2792: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2793: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2794: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2795: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));

Line 2792: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN

2788: END IF;
2789: END IF;
2790: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2791: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2792: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2793: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2794: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2795: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2796: END IF;

Line 2793: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));

2789: END IF;
2790: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2791: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2792: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2793: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2794: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2795: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2796: END IF;
2797: END;

Line 2794: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN

2790: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2791: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2792: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2793: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2794: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2795: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2796: END IF;
2797: END;
2798: /************ End of find_persons private procedures **********/

Line 2795: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));

2791: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2792: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2793: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2794: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2795: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2796: END IF;
2797: END;
2798: /************ End of find_persons private procedures **********/
2799:

Line 2829: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);

2825: g_score_until_thresh := true;
2826: ELSE
2827: g_score_until_thresh := false;
2828: END IF;
2829: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2830: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2831: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2832: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2833: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);

Line 2830: l_contact_contains_str := check_contacts_bulk (p_contact_list);

2826: ELSE
2827: g_score_until_thresh := false;
2828: END IF;
2829: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2830: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2831: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2832: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2833: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2834:

Line 2831: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

2827: g_score_until_thresh := false;
2828: END IF;
2829: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2830: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2831: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2832: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2833: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2834:
2835: -- Setup Search Context ID

Line 2832: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;

2828: END IF;
2829: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2830: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2831: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2832: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2833: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2834:
2835: -- Setup Search Context ID
2836: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

Line 2839: IF l_party_contains_str IS NULL THEN

2835: -- Setup Search Context ID
2836: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
2837: x_search_ctx_id := l_search_ctx_id;
2838:
2839: IF l_party_contains_str IS NULL THEN
2840: defpt := 1;
2841: END IF;
2842: IF l_party_site_contains_str IS NULL THEN
2843: defps := 1;

Line 2842: IF l_party_site_contains_str IS NULL THEN

2838:
2839: IF l_party_contains_str IS NULL THEN
2840: defpt := 1;
2841: END IF;
2842: IF l_party_site_contains_str IS NULL THEN
2843: defps := 1;
2844: END IF;
2845: IF l_contact_contains_str IS NULL THEN
2846: defct := 1;

Line 2845: IF l_contact_contains_str IS NULL THEN

2841: END IF;
2842: IF l_party_site_contains_str IS NULL THEN
2843: defps := 1;
2844: END IF;
2845: IF l_contact_contains_str IS NULL THEN
2846: defct := 1;
2847: END IF;
2848: IF l_contact_pt_contains_str IS NULL THEN
2849: defcpt := 1;

Line 2848: IF l_contact_pt_contains_str IS NULL THEN

2844: END IF;
2845: IF l_contact_contains_str IS NULL THEN
2846: defct := 1;
2847: END IF;
2848: IF l_contact_pt_contains_str IS NULL THEN
2849: defcpt := 1;
2850: END IF;
2851:
2852: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2854: hz_utility_v2pub.debug(p_message=>'l_party_contains_str '||l_party_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2850: END IF;
2851:
2852: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2853: 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);
2854: hz_utility_v2pub.debug(p_message=>'l_party_contains_str '||l_party_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2855: hz_utility_v2pub.debug(p_message=>'l_party_site_contains_str '||l_party_site_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2856: hz_utility_v2pub.debug(p_message=>'l_contact_contains_str '||l_contact_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2857: 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);
2858: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 2855: hz_utility_v2pub.debug(p_message=>'l_party_site_contains_str '||l_party_site_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2851:
2852: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2853: 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);
2854: hz_utility_v2pub.debug(p_message=>'l_party_contains_str '||l_party_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2855: hz_utility_v2pub.debug(p_message=>'l_party_site_contains_str '||l_party_site_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2856: hz_utility_v2pub.debug(p_message=>'l_contact_contains_str '||l_contact_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2857: 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);
2858: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2859: END IF;

Line 2856: hz_utility_v2pub.debug(p_message=>'l_contact_contains_str '||l_contact_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2852: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2853: 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);
2854: hz_utility_v2pub.debug(p_message=>'l_party_contains_str '||l_party_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2855: hz_utility_v2pub.debug(p_message=>'l_party_site_contains_str '||l_party_site_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2856: hz_utility_v2pub.debug(p_message=>'l_contact_contains_str '||l_contact_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2857: 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);
2858: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2859: END IF;
2860: FOR I in 1..5 LOOP

Line 2857: 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);

2853: 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);
2854: hz_utility_v2pub.debug(p_message=>'l_party_contains_str '||l_party_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2855: hz_utility_v2pub.debug(p_message=>'l_party_site_contains_str '||l_party_site_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2856: hz_utility_v2pub.debug(p_message=>'l_contact_contains_str '||l_contact_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2857: 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);
2858: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2859: END IF;
2860: FOR I in 1..5 LOOP
2861: do_eval(I);

Line 2864: IF l_contact_contains_str IS NOT NULL THEN

2860: FOR I in 1..5 LOOP
2861: do_eval(I);
2862: END LOOP;
2863: ROLLBACK to find_persons;
2864: IF l_contact_contains_str IS NOT NULL THEN
2865: eval_contact_level(l_contact_contains_str,p_ins_details,l_contact_max_score);
2866: END IF;
2867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2868: hz_utility_v2pub.debug(p_message=>'Evaluating Matches. Threshold : 22 ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 2865: eval_contact_level(l_contact_contains_str,p_ins_details,l_contact_max_score);

2861: do_eval(I);
2862: END LOOP;
2863: ROLLBACK to find_persons;
2864: IF l_contact_contains_str IS NOT NULL THEN
2865: eval_contact_level(l_contact_contains_str,p_ins_details,l_contact_max_score);
2866: END IF;
2867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2868: hz_utility_v2pub.debug(p_message=>'Evaluating Matches. Threshold : 22 ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2869: END IF;

Line 3756: l_party_contains_str VARCHAR2(32000);

3752: x_num_matches OUT NUMBER
3753: ) IS
3754:
3755: -- Strings to hold the generated Intermedia query strings
3756: l_party_contains_str VARCHAR2(32000);
3757: l_match_idx NUMBER;
3758: l_party_site_contains_str VARCHAR2(32000);
3759: l_contact_contains_str VARCHAR2(32000);
3760: l_contact_pt_contains_str VARCHAR2(32000);

Line 3758: l_party_site_contains_str VARCHAR2(32000);

3754:
3755: -- Strings to hold the generated Intermedia query strings
3756: l_party_contains_str VARCHAR2(32000);
3757: l_match_idx NUMBER;
3758: l_party_site_contains_str VARCHAR2(32000);
3759: l_contact_contains_str VARCHAR2(32000);
3760: l_contact_pt_contains_str VARCHAR2(32000);
3761: l_tmp VARCHAR2(32000);
3762:

Line 3759: l_contact_contains_str VARCHAR2(32000);

3755: -- Strings to hold the generated Intermedia query strings
3756: l_party_contains_str VARCHAR2(32000);
3757: l_match_idx NUMBER;
3758: l_party_site_contains_str VARCHAR2(32000);
3759: l_contact_contains_str VARCHAR2(32000);
3760: l_contact_pt_contains_str VARCHAR2(32000);
3761: l_tmp VARCHAR2(32000);
3762:
3763: -- Other local variables

Line 3760: l_contact_pt_contains_str VARCHAR2(32000);

3756: l_party_contains_str VARCHAR2(32000);
3757: l_match_idx NUMBER;
3758: l_party_site_contains_str VARCHAR2(32000);
3759: l_contact_contains_str VARCHAR2(32000);
3760: l_contact_pt_contains_str VARCHAR2(32000);
3761: l_tmp VARCHAR2(32000);
3762:
3763: -- Other local variables
3764: l_match_str VARCHAR2(30); -- Match type (AND or OR)

Line 3835: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);

3831: l_entered_max_score:= init_search( HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC, p_party_site_list, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST, p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
3832: g_score_until_thresh := false;
3833: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3834:
3835: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
3836: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3837: 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);
3838:
3839: -- Setup Search Context ID

Line 3836: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

3832: g_score_until_thresh := false;
3833: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3834:
3835: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
3836: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3837: 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);
3838:
3839: -- Setup Search Context ID
3840: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

Line 3845: hz_utility_v2pub.debug(p_message=>'l_party_site_contains_str '||l_party_site_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

3841: x_search_ctx_id := l_search_ctx_id;
3842:
3843: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3844: 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);
3845: hz_utility_v2pub.debug(p_message=>'l_party_site_contains_str '||l_party_site_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3846: 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);
3847: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3848: END IF;
3849: IF l_party_site_contains_str IS NULL THEN

Line 3846: 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);

3842:
3843: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3844: 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);
3845: hz_utility_v2pub.debug(p_message=>'l_party_site_contains_str '||l_party_site_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3846: 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);
3847: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3848: END IF;
3849: IF l_party_site_contains_str IS NULL THEN
3850: defps := 1;

Line 3849: IF l_party_site_contains_str IS NULL THEN

3845: hz_utility_v2pub.debug(p_message=>'l_party_site_contains_str '||l_party_site_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3846: 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);
3847: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3848: END IF;
3849: IF l_party_site_contains_str IS NULL THEN
3850: defps := 1;
3851: END IF;
3852: IF l_contact_pt_contains_str IS NULL THEN
3853: defcpt := 1;

Line 3852: IF l_contact_pt_contains_str IS NULL THEN

3848: END IF;
3849: IF l_party_site_contains_str IS NULL THEN
3850: defps := 1;
3851: END IF;
3852: IF l_contact_pt_contains_str IS NULL THEN
3853: defcpt := 1;
3854: END IF;
3855:
3856: IF l_party_site_contains_str IS NOT NULL THEN

Line 3856: IF l_party_site_contains_str IS NOT NULL THEN

3852: IF l_contact_pt_contains_str IS NULL THEN
3853: defcpt := 1;
3854: END IF;
3855:
3856: IF l_party_site_contains_str IS NOT NULL THEN
3857: open_party_site_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_party_site_contains_str,NULL,l_party_site_cur);
3858: LOOP
3859: FETCH l_party_site_cur INTO
3860: l_party_site_id, l_ps_party_id, l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;

Line 3857: open_party_site_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_party_site_contains_str,NULL,l_party_site_cur);

3853: defcpt := 1;
3854: END IF;
3855:
3856: IF l_party_site_contains_str IS NOT NULL THEN
3857: open_party_site_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_party_site_contains_str,NULL,l_party_site_cur);
3858: LOOP
3859: FETCH l_party_site_cur INTO
3860: l_party_site_id, l_ps_party_id, l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;
3861: EXIT WHEN l_party_site_cur%NOTFOUND;

Line 3878: IF l_contact_pt_contains_str IS NOT NULL THEN

3874: END LOOP;
3875: CLOSE l_party_site_cur;
3876: END IF;
3877:
3878: IF l_contact_pt_contains_str IS NOT NULL THEN
3879: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
3880: LOOP
3881: FETCH l_contact_pt_cur INTO
3882: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX7, l_TX10, l_TX158;

Line 3879: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);

3875: CLOSE l_party_site_cur;
3876: END IF;
3877:
3878: IF l_contact_pt_contains_str IS NOT NULL THEN
3879: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
3880: LOOP
3881: FETCH l_contact_pt_cur INTO
3882: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX7, l_TX10, l_TX158;
3883: EXIT WHEN l_contact_pt_cur%NOTFOUND;

Line 3984: l_party_contains_str VARCHAR2(32000);

3980: x_num_matches OUT NUMBER
3981: ) IS
3982:
3983: -- Strings to hold the generated Intermedia query strings
3984: l_party_contains_str VARCHAR2(32000);
3985: l_party_site_contains_str VARCHAR2(32000);
3986: l_contact_contains_str VARCHAR2(32000);
3987: l_contact_pt_contains_str VARCHAR2(32000);
3988: l_tmp VARCHAR2(32000);

Line 3985: l_party_site_contains_str VARCHAR2(32000);

3981: ) IS
3982:
3983: -- Strings to hold the generated Intermedia query strings
3984: l_party_contains_str VARCHAR2(32000);
3985: l_party_site_contains_str VARCHAR2(32000);
3986: l_contact_contains_str VARCHAR2(32000);
3987: l_contact_pt_contains_str VARCHAR2(32000);
3988: l_tmp VARCHAR2(32000);
3989:

Line 3986: l_contact_contains_str VARCHAR2(32000);

3982:
3983: -- Strings to hold the generated Intermedia query strings
3984: l_party_contains_str VARCHAR2(32000);
3985: l_party_site_contains_str VARCHAR2(32000);
3986: l_contact_contains_str VARCHAR2(32000);
3987: l_contact_pt_contains_str VARCHAR2(32000);
3988: l_tmp VARCHAR2(32000);
3989:
3990: -- Other local variables

Line 3987: l_contact_pt_contains_str VARCHAR2(32000);

3983: -- Strings to hold the generated Intermedia query strings
3984: l_party_contains_str VARCHAR2(32000);
3985: l_party_site_contains_str VARCHAR2(32000);
3986: l_contact_contains_str VARCHAR2(32000);
3987: l_contact_pt_contains_str VARCHAR2(32000);
3988: l_tmp VARCHAR2(32000);
3989:
3990: -- Other local variables
3991: l_match_str VARCHAR2(30); -- Match type (AND or OR)

Line 4061: l_contact_contains_str := check_contacts_bulk (p_contact_list);

4057: l_entered_max_score:= init_search( HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC, HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, p_contact_list, p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
4058: g_score_until_thresh := false;
4059: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4060:
4061: l_contact_contains_str := check_contacts_bulk (p_contact_list);
4062: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4063: 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);
4064:
4065: -- Setup Search Context ID

Line 4062: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

4058: g_score_until_thresh := false;
4059: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4060:
4061: l_contact_contains_str := check_contacts_bulk (p_contact_list);
4062: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4063: 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);
4064:
4065: -- Setup Search Context ID
4066: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

Line 4071: hz_utility_v2pub.debug(p_message=>'l_contact_contains_str '||l_contact_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

4067: x_search_ctx_id := l_search_ctx_id;
4068:
4069: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4070: 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);
4071: hz_utility_v2pub.debug(p_message=>'l_contact_contains_str '||l_contact_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4072: 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);
4073: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4074: END IF;
4075: IF l_contact_contains_str IS NULL THEN

Line 4072: 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);

4068:
4069: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4070: 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);
4071: hz_utility_v2pub.debug(p_message=>'l_contact_contains_str '||l_contact_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4072: 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);
4073: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4074: END IF;
4075: IF l_contact_contains_str IS NULL THEN
4076: defct := 1;

Line 4075: IF l_contact_contains_str IS NULL THEN

4071: hz_utility_v2pub.debug(p_message=>'l_contact_contains_str '||l_contact_contains_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4072: 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);
4073: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4074: END IF;
4075: IF l_contact_contains_str IS NULL THEN
4076: defct := 1;
4077: END IF;
4078: IF l_contact_pt_contains_str IS NULL THEN
4079: defcpt := 1;

Line 4078: IF l_contact_pt_contains_str IS NULL THEN

4074: END IF;
4075: IF l_contact_contains_str IS NULL THEN
4076: defct := 1;
4077: END IF;
4078: IF l_contact_pt_contains_str IS NULL THEN
4079: defcpt := 1;
4080: END IF;
4081:
4082: IF l_contact_contains_str IS NOT NULL THEN

Line 4082: IF l_contact_contains_str IS NOT NULL THEN

4078: IF l_contact_pt_contains_str IS NULL THEN
4079: defcpt := 1;
4080: END IF;
4081:
4082: IF l_contact_contains_str IS NOT NULL THEN
4083: open_contact_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_contains_str,NULL,l_contact_cur);
4084: LOOP
4085: FETCH l_contact_cur INTO
4086: l_org_contact_id, l_ct_party_id , l_TX2, l_TX23, l_TX22;

Line 4083: open_contact_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_contains_str,NULL,l_contact_cur);

4079: defcpt := 1;
4080: END IF;
4081:
4082: IF l_contact_contains_str IS NOT NULL THEN
4083: open_contact_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_contains_str,NULL,l_contact_cur);
4084: LOOP
4085: FETCH l_contact_cur INTO
4086: l_org_contact_id, l_ct_party_id , l_TX2, l_TX23, l_TX22;
4087: EXIT WHEN l_contact_cur%NOTFOUND;

Line 4102: IF l_contact_pt_contains_str IS NOT NULL THEN

4098: END LOOP;
4099: CLOSE l_contact_cur;
4100: END IF;
4101:
4102: IF l_contact_pt_contains_str IS NOT NULL THEN
4103: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
4104: LOOP
4105: FETCH l_contact_pt_cur INTO
4106: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX7, l_TX10, l_TX158;

Line 4103: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);

4099: CLOSE l_contact_cur;
4100: END IF;
4101:
4102: IF l_contact_pt_contains_str IS NOT NULL THEN
4103: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
4104: LOOP
4105: FETCH l_contact_pt_cur INTO
4106: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX7, l_TX10, l_TX158;
4107: EXIT WHEN l_contact_pt_cur%NOTFOUND;

Line 4207: l_contact_pt_contains_str VARCHAR2(32000);

4203: ) IS
4204:
4205:
4206: -- Strings to hold the generated Intermedia query strings
4207: l_contact_pt_contains_str VARCHAR2(32000);
4208: l_tmp VARCHAR2(32000);
4209:
4210: -- Other local variables
4211: l_match_str VARCHAR2(30); -- Match type (AND or OR)

Line 4267: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

4263: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
4264: g_score_until_thresh := false;
4265: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4266:
4267: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4268: 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);
4269:
4270: -- Setup Search Context ID
4271: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

Line 4275: 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);

4271: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
4272: x_search_ctx_id := l_search_ctx_id;
4273: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4274: 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);
4275: 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);
4276: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4277: END IF;
4278:
4279: IF l_contact_pt_contains_str IS NOT NULL THEN

Line 4279: IF l_contact_pt_contains_str IS NOT NULL THEN

4275: 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);
4276: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4277: END IF;
4278:
4279: IF l_contact_pt_contains_str IS NOT NULL THEN
4280: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
4281: cnt := 1;
4282: LOOP
4283: FETCH l_contact_pt_cur INTO

Line 4280: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);

4276: hz_utility_v2pub.debug(p_message=>'l_search_ctx_id '||l_search_ctx_id,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4277: END IF;
4278:
4279: IF l_contact_pt_contains_str IS NOT NULL THEN
4280: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
4281: cnt := 1;
4282: LOOP
4283: FETCH l_contact_pt_cur INTO
4284: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX7, l_TX10, l_TX158;

Line 4355: l_party_contains_str VARCHAR2(32000);

4351: x_search_ctx_id IN OUT NUMBER
4352: ) IS
4353:
4354: -- Strings to hold the generated Intermedia query strings
4355: l_party_contains_str VARCHAR2(32000);
4356: l_party_site_contains_str VARCHAR2(32000);
4357: l_contact_contains_str VARCHAR2(32000);
4358: l_contact_pt_contains_str VARCHAR2(32000);
4359: l_tmp VARCHAR2(32000);

Line 4356: l_party_site_contains_str VARCHAR2(32000);

4352: ) IS
4353:
4354: -- Strings to hold the generated Intermedia query strings
4355: l_party_contains_str VARCHAR2(32000);
4356: l_party_site_contains_str VARCHAR2(32000);
4357: l_contact_contains_str VARCHAR2(32000);
4358: l_contact_pt_contains_str VARCHAR2(32000);
4359: l_tmp VARCHAR2(32000);
4360:

Line 4357: l_contact_contains_str VARCHAR2(32000);

4353:
4354: -- Strings to hold the generated Intermedia query strings
4355: l_party_contains_str VARCHAR2(32000);
4356: l_party_site_contains_str VARCHAR2(32000);
4357: l_contact_contains_str VARCHAR2(32000);
4358: l_contact_pt_contains_str VARCHAR2(32000);
4359: l_tmp VARCHAR2(32000);
4360:
4361: -- Other local variables

Line 4358: l_contact_pt_contains_str VARCHAR2(32000);

4354: -- Strings to hold the generated Intermedia query strings
4355: l_party_contains_str VARCHAR2(32000);
4356: l_party_site_contains_str VARCHAR2(32000);
4357: l_contact_contains_str VARCHAR2(32000);
4358: l_contact_pt_contains_str VARCHAR2(32000);
4359: l_tmp VARCHAR2(32000);
4360:
4361: -- Other local variables
4362: l_match_str VARCHAR2(30); -- Match type (AND or OR)

Line 4435: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);

4431:
4432: l_entered_max_score:= init_search(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list,' OR ', l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
4433: g_score_until_thresh := false;
4434: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4435: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
4436: l_contact_contains_str := check_contacts_bulk (p_contact_list);
4437: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4438: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
4439:

Line 4436: l_contact_contains_str := check_contacts_bulk (p_contact_list);

4432: l_entered_max_score:= init_search(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list,' OR ', l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
4433: g_score_until_thresh := false;
4434: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4435: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
4436: l_contact_contains_str := check_contacts_bulk (p_contact_list);
4437: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4438: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
4439:
4440: -- Setup Search Context ID

Line 4437: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

4433: g_score_until_thresh := false;
4434: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4435: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
4436: l_contact_contains_str := check_contacts_bulk (p_contact_list);
4437: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4438: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
4439:
4440: -- Setup Search Context ID
4441: IF x_search_ctx_id IS NULL THEN

Line 4457: IF l_party_site_contains_str IS NOT NULL THEN

4453: INSERT_PARTY_SCORE(p_party_id, p_party_id, l_search_ctx_id, p_party_search_rec, g_party_stage_rec, l_TX2,l_TX59,l_TX41,l_TX45,1);
4454: END LOOP;
4455: CLOSE l_party_cur;
4456:
4457: IF l_party_site_contains_str IS NOT NULL THEN
4458: l_max_score := 0;
4459: l_max_id := 0;
4460: l_max_idx := 0;
4461: open_party_site_cursor(null, p_party_id, null, l_party_site_contains_str,NULL,l_party_site_cur);

Line 4461: open_party_site_cursor(null, p_party_id, null, l_party_site_contains_str,NULL,l_party_site_cur);

4457: IF l_party_site_contains_str IS NOT NULL THEN
4458: l_max_score := 0;
4459: l_max_id := 0;
4460: l_max_idx := 0;
4461: open_party_site_cursor(null, p_party_id, null, l_party_site_contains_str,NULL,l_party_site_cur);
4462: LOOP
4463: FETCH l_party_site_cur INTO
4464: l_party_site_id, l_ps_party_id,l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;
4465: EXIT WHEN l_party_site_cur%NOTFOUND;

Line 4483: IF l_contact_contains_str IS NOT NULL THEN

4479: INSERT_PARTY_SITES_SCORE(p_party_id,l_max_id,l_search_ctx_id, p_party_site_list(l_max_idx), g_party_site_stage_list(l_max_idx) ,l_max_TX26,l_max_TX9,l_max_TX14,l_max_TX22,l_max_idx);
4480: END IF;
4481: END IF;
4482:
4483: IF l_contact_contains_str IS NOT NULL THEN
4484: l_max_score := 0;
4485: l_max_id := 0;
4486: l_max_idx := 0;
4487: open_contact_cursor(null, p_party_id, null, l_contact_contains_str,NULL,l_contact_cur);

Line 4487: open_contact_cursor(null, p_party_id, null, l_contact_contains_str,NULL,l_contact_cur);

4483: IF l_contact_contains_str IS NOT NULL THEN
4484: l_max_score := 0;
4485: l_max_id := 0;
4486: l_max_idx := 0;
4487: open_contact_cursor(null, p_party_id, null, l_contact_contains_str,NULL,l_contact_cur);
4488: LOOP
4489: FETCH l_contact_cur INTO
4490: l_org_contact_id, l_ct_party_id , l_TX2, l_TX23, l_TX22;
4491: EXIT WHEN l_contact_cur%NOTFOUND;

Line 4508: IF l_contact_pt_contains_str IS NOT NULL THEN

4504: INSERT_CONTACTS_SCORE(p_party_id,l_max_id,l_search_ctx_id, p_contact_list(l_max_idx), g_contact_stage_list(l_max_idx) ,l_max_TX2,l_max_TX23,l_max_TX22,l_max_idx);
4505: END IF;
4506: END IF;
4507:
4508: IF l_contact_pt_contains_str IS NOT NULL THEN
4509: l_max_score := 0;
4510: l_max_id := 0;
4511: l_max_idx := 0;
4512: open_contact_pt_cursor(null, p_party_id, null, l_contact_pt_contains_str,NULL,l_contact_pt_cur);

Line 4512: open_contact_pt_cursor(null, p_party_id, null, l_contact_pt_contains_str,NULL,l_contact_pt_cur);

4508: IF l_contact_pt_contains_str IS NOT NULL THEN
4509: l_max_score := 0;
4510: l_max_id := 0;
4511: l_max_idx := 0;
4512: open_contact_pt_cursor(null, p_party_id, null, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
4513: LOOP
4514: FETCH l_contact_pt_cur INTO
4515: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX7, l_TX10, l_TX158;
4516: EXIT WHEN l_contact_pt_cur%NOTFOUND;