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_50 dependencies on CONTAINS

Line 1110: p_contains_str VARCHAR2,

1106:
1107: PROCEDURE open_party_cursor(
1108: p_dup_party_id NUMBER,
1109: p_restrict_sql VARCHAR2,
1110: p_contains_str VARCHAR2,
1111: p_search_ctx_id NUMBER,
1112: p_match_str VARCHAR2,
1113: p_search_merged VARCHAR2,
1114: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

Line 1117: IF p_contains_str IS NULL THEN

1113: p_search_merged VARCHAR2,
1114: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1115: l_sqlstr VARCHAR2(4000);
1116: BEGIN
1117: IF p_contains_str IS NULL THEN
1118: OPEN x_cursor FOR
1119: SELECT PARTY_ID , TX2, TX59, lpad(rtrim(TX41),9,chr(48)), TX45
1120: FROM HZ_STAGED_PARTIES stage
1121: WHERE PARTY_ID = p_dup_party_id;

Line 1210: OPEN x_cursor FOR l_sqlstr USING p_contains_str

1206: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';
1207: IF p_search_merged IS NULL OR p_search_merged <> 'Y' THEN
1208: l_sqlstr := l_sqlstr ||' AND nvl(stage.status,''A'') in (''A'')';
1209: END IF;
1210: OPEN x_cursor FOR l_sqlstr USING p_contains_str
1211: ,g_party_stage_rec.TX36,g_party_stage_rec.TX36
1212: ,g_party_stage_rec.TX46,g_party_stage_rec.TX46
1213: ,p_dup_party_id, p_dup_party_id;
1214: END IF;

Line 1231: p_contains_str VARCHAR2,

1227: PROCEDURE open_party_site_cursor(
1228: p_dup_party_id NUMBER,
1229: p_party_id NUMBER,
1230: p_restrict_sql VARCHAR2,
1231: p_contains_str VARCHAR2,
1232: p_search_ctx_id NUMBER,
1233: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1234: l_sqlstr VARCHAR2(4000);
1235: BEGIN

Line 1308: OPEN x_cursor FOR l_sqlstr USING p_contains_str

1304: ' AND p.party_id = stage.party_id ' ||
1305: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36) AND (:TX46 IS NULL OR :TX46||'' '' = p.TX46))) ' ||
1306: ' AND ('||p_restrict_sql||')' ||
1307: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';
1308: OPEN x_cursor FOR l_sqlstr USING p_contains_str
1309: ,g_party_stage_rec.TX36,g_party_stage_rec.TX36
1310: ,g_party_stage_rec.TX46,g_party_stage_rec.TX46
1311: ,p_dup_party_id, p_dup_party_id;
1312: END IF;

Line 1328: p_contains_str VARCHAR2,

1324: PROCEDURE open_contact_cursor(
1325: p_dup_party_id NUMBER,
1326: p_party_id NUMBER,
1327: p_restrict_sql VARCHAR2,
1328: p_contains_str VARCHAR2,
1329: p_search_ctx_id NUMBER,
1330: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1331: l_sqlstr VARCHAR2(4000);
1332: BEGIN

Line 1409: OPEN x_cursor FOR l_sqlstr USING p_contains_str

1405: ' WHERE p.party_id = stage.party_id ' ||
1406: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36) AND (:TX46 IS NULL OR :TX46||'' '' = p.TX46))) ' ||
1407: ' AND ('||p_restrict_sql||')' ||
1408: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';
1409: OPEN x_cursor FOR l_sqlstr USING p_contains_str
1410: ,g_party_stage_rec.TX36,g_party_stage_rec.TX36
1411: ,g_party_stage_rec.TX46,g_party_stage_rec.TX46
1412: ,p_dup_party_id, p_dup_party_id;
1413: END IF;

Line 1429: p_contains_str VARCHAR2,

1425: PROCEDURE open_contact_pt_cursor(
1426: p_dup_party_id NUMBER,
1427: p_party_id NUMBER,
1428: p_restrict_sql VARCHAR2,
1429: p_contains_str VARCHAR2,
1430: p_search_ctx_id NUMBER,
1431: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1432: l_sqlstr VARCHAR2(4000);
1433: BEGIN

Line 1530: OPEN x_cursor FOR l_sqlstr USING p_contains_str

1526: ' WHERE p.party_id = stage.party_id ' ||
1527: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36) AND (:TX46 IS NULL OR :TX46||'' '' = p.TX46))) ' ||
1528: ' AND ('||p_restrict_sql||')' ||
1529: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';
1530: OPEN x_cursor FOR l_sqlstr USING p_contains_str
1531: ,g_party_stage_rec.TX36,g_party_stage_rec.TX36
1532: ,g_party_stage_rec.TX46,g_party_stage_rec.TX46
1533: ,p_dup_party_id, p_dup_party_id;
1534: END IF;

Line 1604: l_party_contains_str VARCHAR2(32000);

1600: x_num_matches OUT NUMBER
1601: ) IS
1602:
1603: -- Strings to hold the generated Intermedia query strings
1604: l_party_contains_str VARCHAR2(32000);
1605: l_party_site_contains_str VARCHAR2(32000);
1606: l_contact_contains_str VARCHAR2(32000);
1607: l_contact_pt_contains_str VARCHAR2(32000);
1608: l_denorm_str VARCHAR2(32000);

Line 1605: l_party_site_contains_str VARCHAR2(32000);

1601: ) IS
1602:
1603: -- Strings to hold the generated Intermedia query strings
1604: l_party_contains_str VARCHAR2(32000);
1605: l_party_site_contains_str VARCHAR2(32000);
1606: l_contact_contains_str VARCHAR2(32000);
1607: l_contact_pt_contains_str VARCHAR2(32000);
1608: l_denorm_str VARCHAR2(32000);
1609: l_ps_denorm_str VARCHAR2(32000);

Line 1606: l_contact_contains_str VARCHAR2(32000);

1602:
1603: -- Strings to hold the generated Intermedia query strings
1604: l_party_contains_str VARCHAR2(32000);
1605: l_party_site_contains_str VARCHAR2(32000);
1606: l_contact_contains_str VARCHAR2(32000);
1607: l_contact_pt_contains_str VARCHAR2(32000);
1608: l_denorm_str VARCHAR2(32000);
1609: l_ps_denorm_str VARCHAR2(32000);
1610: l_ct_denorm_str VARCHAR2(32000);

Line 1607: l_contact_pt_contains_str VARCHAR2(32000);

1603: -- Strings to hold the generated Intermedia query strings
1604: l_party_contains_str VARCHAR2(32000);
1605: l_party_site_contains_str VARCHAR2(32000);
1606: l_contact_contains_str VARCHAR2(32000);
1607: l_contact_pt_contains_str VARCHAR2(32000);
1608: l_denorm_str VARCHAR2(32000);
1609: l_ps_denorm_str VARCHAR2(32000);
1610: l_ct_denorm_str VARCHAR2(32000);
1611: l_cpt_denorm_str VARCHAR2(32000);

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

1701: call_type(2) := 'OR';
1702: END;
1703:
1704: /** Private procedure to acquire and score at party level ***/
1705: PROCEDURE eval_party_level(p_party_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER) IS
1706: l_party_id_idx NUMBER:=1;
1707: l_ctx_id NUMBER;
1708: BEGIN
1709: SAVEPOINT eval_start;

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

1723: ELSE
1724: l_ctx_id := NULL;
1725: l_party_id_idx := H_PARTY_ID.COUNT+1;
1726: END IF;
1727: 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);
1728: LOOP
1729: FETCH l_party_cur INTO
1730: l_party_id , l_TX2, l_TX59, l_TX41, l_TX45;
1731: EXIT WHEN l_party_cur%NOTFOUND;

Line 1771: 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

1767: ROLLBACK to eval_start;
1768: END;
1769:
1770: /** Private procedure to acquire and score at party site level ***/
1771: 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
1772: l_party_id_idx NUMBER:=1;
1773: l_ctx_id NUMBER;
1774: BEGIN
1775: SAVEPOINT eval_start;

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

1789: ELSE
1790: l_party_id_idx := H_PARTY_ID.COUNT+1;
1791: l_ctx_id := NULL;
1792: END IF;
1793: open_party_site_cursor(p_dup_party_id,NULL, p_restrict_sql, p_party_site_contains_str,l_ctx_id, l_party_site_cur);
1794: LOOP
1795: FETCH l_party_site_cur INTO
1796: l_party_site_id, l_ps_party_id, l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;
1797: EXIT WHEN l_party_site_cur%NOTFOUND;

Line 1848: 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

1844: ROLLBACK to eval_start;
1845: END;
1846:
1847: /** Private procedure to acquire and score at party site level ***/
1848: 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
1849: l_party_id_idx NUMBER:=1;
1850: l_ctx_id NUMBER;
1851: BEGIN
1852: SAVEPOINT eval_start;

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

1866: ELSE
1867: l_ctx_id := NULL;
1868: l_party_id_idx := H_PARTY_ID.COUNT+1;
1869: END IF;
1870: open_contact_cursor(p_dup_party_id,NULL, p_restrict_sql, p_contact_contains_str,l_ctx_id, l_contact_cur);
1871: LOOP
1872: FETCH l_contact_cur INTO
1873: l_org_contact_id, l_ct_party_id , l_TX2, l_TX23, l_TX22;
1874: EXIT WHEN l_contact_cur%NOTFOUND;

Line 1923: 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

1919: ROLLBACK to eval_start;
1920: END;
1921:
1922: /** Private procedure to acquire and score at contact point level ***/
1923: 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
1924: l_party_id_idx NUMBER:=1;
1925: l_ctx_id NUMBER;
1926: BEGIN
1927: SAVEPOINT eval_start;

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

1941: ELSE
1942: l_ctx_id := NULL;
1943: l_party_id_idx := H_PARTY_ID.COUNT+1;
1944: END IF;
1945: open_contact_pt_cursor(p_dup_party_id,NULL, p_restrict_sql, p_contact_pt_contains_str,l_ctx_id, l_contact_pt_cur);
1946: LOOP
1947: FETCH l_contact_pt_cur INTO
1948: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX7, l_TX158, l_TX10;
1949: EXIT WHEN l_contact_pt_cur%NOTFOUND;

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

2018: FND_MSG_PUB.ADD;
2019: RAISE FND_API.G_EXC_ERROR;
2020: END IF;
2021: END IF;
2022: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2023: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2024: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2025: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2026: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN

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

2019: RAISE FND_API.G_EXC_ERROR;
2020: END IF;
2021: END IF;
2022: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2023: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2024: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2025: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2026: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
2027: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));

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

2020: END IF;
2021: END IF;
2022: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2023: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2024: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2025: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2026: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
2027: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2028: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN

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

2021: END IF;
2022: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2023: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2024: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2025: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2026: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
2027: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2028: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2029: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));

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

2022: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2023: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2024: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2025: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2026: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
2027: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2028: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2029: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2030: END IF;

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

2023: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2024: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2025: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2026: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
2027: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2028: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2029: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2030: END IF;
2031: END;

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

2024: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2025: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2026: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
2027: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2028: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2029: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2030: END IF;
2031: END;
2032: /************ End of find_parties private procedures **********/

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

2025: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2026: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
2027: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2028: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2029: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2030: END IF;
2031: END;
2032: /************ End of find_parties private procedures **********/
2033:

Line 2084: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);

2080: g_score_until_thresh := true;
2081: ELSE
2082: g_score_until_thresh := false;
2083: END IF;
2084: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2085: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2086: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2087: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2088: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);

Line 2085: l_contact_contains_str := check_contacts_bulk (p_contact_list);

2081: ELSE
2082: g_score_until_thresh := false;
2083: END IF;
2084: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2085: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2086: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2087: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2088: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2089:

Line 2086: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

2082: g_score_until_thresh := false;
2083: END IF;
2084: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2085: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2086: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2087: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2088: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2089:
2090: -- Setup Search Context ID

Line 2087: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;

2083: END IF;
2084: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2085: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2086: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2087: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2088: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2089:
2090: -- Setup Search Context ID
2091: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

Line 2094: IF l_party_contains_str IS NULL THEN

2090: -- Setup Search Context ID
2091: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
2092: x_search_ctx_id := l_search_ctx_id;
2093:
2094: IF l_party_contains_str IS NULL THEN
2095: defpt := 1;
2096: END IF;
2097: IF l_party_site_contains_str IS NULL THEN
2098: defps := 1;

Line 2097: IF l_party_site_contains_str IS NULL THEN

2093:
2094: IF l_party_contains_str IS NULL THEN
2095: defpt := 1;
2096: END IF;
2097: IF l_party_site_contains_str IS NULL THEN
2098: defps := 1;
2099: END IF;
2100: IF l_contact_contains_str IS NULL THEN
2101: defct := 1;

Line 2100: IF l_contact_contains_str IS NULL THEN

2096: END IF;
2097: IF l_party_site_contains_str IS NULL THEN
2098: defps := 1;
2099: END IF;
2100: IF l_contact_contains_str IS NULL THEN
2101: defct := 1;
2102: END IF;
2103: IF l_contact_pt_contains_str IS NULL THEN
2104: defcpt := 1;

Line 2103: IF l_contact_pt_contains_str IS NULL THEN

2099: END IF;
2100: IF l_contact_contains_str IS NULL THEN
2101: defct := 1;
2102: END IF;
2103: IF l_contact_pt_contains_str IS NULL THEN
2104: defcpt := 1;
2105: END IF;
2106:
2107: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2105: END IF;
2106:
2107: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2108: 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);
2109: 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);
2110: 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);
2111: 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);
2112: 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);
2113: 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 2110: 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);

2106:
2107: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2108: 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);
2109: 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);
2110: 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);
2111: 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);
2112: 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);
2113: 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);
2114: END IF;

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

2107: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2108: 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);
2109: 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);
2110: 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);
2111: 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);
2112: 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);
2113: 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);
2114: END IF;
2115: FOR I in 1..5 LOOP

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

2108: 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);
2109: 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);
2110: 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);
2111: 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);
2112: 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);
2113: 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);
2114: END IF;
2115: FOR I in 1..5 LOOP
2116: do_eval(I);

Line 2230: l_party_contains_str VARCHAR2(32000);

2226: x_num_matches OUT NUMBER
2227: ) IS
2228:
2229: -- Strings to hold the generated Intermedia query strings
2230: l_party_contains_str VARCHAR2(32000);
2231: l_party_site_contains_str VARCHAR2(32000);
2232: l_contact_contains_str VARCHAR2(32000);
2233: l_contact_pt_contains_str VARCHAR2(32000);
2234: l_denorm_str VARCHAR2(32000);

Line 2231: l_party_site_contains_str VARCHAR2(32000);

2227: ) IS
2228:
2229: -- Strings to hold the generated Intermedia query strings
2230: l_party_contains_str VARCHAR2(32000);
2231: l_party_site_contains_str VARCHAR2(32000);
2232: l_contact_contains_str VARCHAR2(32000);
2233: l_contact_pt_contains_str VARCHAR2(32000);
2234: l_denorm_str VARCHAR2(32000);
2235: l_ps_denorm_str VARCHAR2(32000);

Line 2232: l_contact_contains_str VARCHAR2(32000);

2228:
2229: -- Strings to hold the generated Intermedia query strings
2230: l_party_contains_str VARCHAR2(32000);
2231: l_party_site_contains_str VARCHAR2(32000);
2232: l_contact_contains_str VARCHAR2(32000);
2233: l_contact_pt_contains_str VARCHAR2(32000);
2234: l_denorm_str VARCHAR2(32000);
2235: l_ps_denorm_str VARCHAR2(32000);
2236: l_ct_denorm_str VARCHAR2(32000);

Line 2233: l_contact_pt_contains_str VARCHAR2(32000);

2229: -- Strings to hold the generated Intermedia query strings
2230: l_party_contains_str VARCHAR2(32000);
2231: l_party_site_contains_str VARCHAR2(32000);
2232: l_contact_contains_str VARCHAR2(32000);
2233: l_contact_pt_contains_str VARCHAR2(32000);
2234: l_denorm_str VARCHAR2(32000);
2235: l_ps_denorm_str VARCHAR2(32000);
2236: l_ct_denorm_str VARCHAR2(32000);
2237: l_cpt_denorm_str VARCHAR2(32000);

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

2363: call_type(2) := 'OR';
2364: END;
2365:
2366: /** Private procedure to acquire and score at party level ***/
2367: PROCEDURE eval_party_level(p_party_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER) IS
2368: l_party_id_idx NUMBER:=1;
2369: l_ctx_id NUMBER;
2370: BEGIN
2371: SAVEPOINT eval_start;

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

2386: ELSE
2387: l_ctx_id := NULL;
2388: l_party_id_idx := H_PARTY_ID.COUNT+1;
2389: END IF;
2390: open_party_cursor(null, p_restrict_sql, p_party_contains_str,l_ctx_id, l_match_str,null,l_party_cur);
2391: LOOP
2392: FETCH l_party_cur INTO
2393: l_party_id , l_TX2, l_TX59, l_TX41, l_TX45;
2394: EXIT WHEN l_party_cur%NOTFOUND;

Line 2433: p_contains_str VARCHAR2,

2429: CLOSE l_party_cur;
2430: ROLLBACK to eval_start;
2431: END;
2432: PROCEDURE open_person_contact_cursor(
2433: p_contains_str VARCHAR2,
2434: p_search_ctx_id NUMBER,
2435: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2436: BEGIN
2437: OPEN x_cursor FOR

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

2436: BEGIN
2437: OPEN x_cursor FOR
2438: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX23, TX22
2439: FROM HZ_STAGED_CONTACTS stage
2440: WHERE contains( concat_col, p_contains_str)>0
2441: AND ORG_CONTACT_ID in (
2442: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
2443: org_contact_id
2444: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc

Line 2464: 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

2460: end if;
2461: END;
2462:
2463: /** Private procedure to acquire and score at party site level ***/
2464: 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
2465: l_party_id_idx NUMBER:=1;
2466: l_ctx_id NUMBER;
2467: l_person_id NUMBER;
2468: BEGIN

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

2496: ELSE
2497: l_party_id_idx := H_PARTY_ID.COUNT+1;
2498: l_ctx_id := NULL;
2499: END IF;
2500: open_party_site_cursor(null,NULL, p_restrict_sql, p_party_site_contains_str,l_ctx_id, l_party_site_cur);
2501: LOOP
2502: FETCH l_party_site_cur INTO
2503: l_party_site_id, l_ps_party_id, l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;
2504: EXIT WHEN l_party_site_cur%NOTFOUND;

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

2554: ROLLBACK to eval_start;
2555: END;
2556:
2557: /** Private procedure to acquire and score at party site level ***/
2558: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
2559: l_party_id_idx NUMBER:=1;
2560: l_ctx_id NUMBER;
2561: BEGIN
2562: SAVEPOINT eval_start;

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

2565: FORALL I in 1..H_PARTY_ID.COUNT
2566: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2567: l_search_ctx_id,H_PARTY_ID(I));
2568: l_party_id_idx := H_PARTY_ID.COUNT+1;
2569: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
2570: LOOP
2571: FETCH l_contact_cur INTO
2572: l_org_contact_id, l_ct_party_id , l_TX2, l_TX23, l_TX22;
2573: EXIT WHEN l_contact_cur%NOTFOUND;

Line 2602: 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

2598: ROLLBACK to eval_start;
2599: END;
2600:
2601: /** Private procedure to acquire and score at contact point level ***/
2602: 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
2603: l_party_id_idx NUMBER:=1;
2604: l_ctx_id NUMBER;
2605: BEGIN
2606: SAVEPOINT eval_start;

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

2633: ELSE
2634: l_ctx_id := NULL;
2635: l_party_id_idx := H_PARTY_ID.COUNT+1;
2636: END IF;
2637: open_contact_pt_cursor(null,NULL, p_restrict_sql, p_contact_pt_contains_str,l_ctx_id, l_contact_pt_cur);
2638: LOOP
2639: FETCH l_contact_pt_cur INTO
2640: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX7, l_TX158, l_TX10;
2641: EXIT WHEN l_contact_pt_cur%NOTFOUND;

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

2718: FND_MSG_PUB.ADD;
2719: RAISE FND_API.G_EXC_ERROR;
2720: END IF;
2721: END IF;
2722: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2723: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2724: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2725: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2726: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN

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

2719: RAISE FND_API.G_EXC_ERROR;
2720: END IF;
2721: END IF;
2722: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2723: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2724: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2725: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2726: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2727: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));

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

2720: END IF;
2721: END IF;
2722: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2723: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2724: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2725: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2726: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2727: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2728: END IF;

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

2721: END IF;
2722: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2723: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2724: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2725: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2726: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2727: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2728: END IF;
2729: END;

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

2722: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2723: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2724: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2725: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2726: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2727: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2728: END IF;
2729: END;
2730: /************ End of find_persons private procedures **********/

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

2723: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2724: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2725: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2726: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2727: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2728: END IF;
2729: END;
2730: /************ End of find_persons private procedures **********/
2731:

Line 2761: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);

2757: g_score_until_thresh := true;
2758: ELSE
2759: g_score_until_thresh := false;
2760: END IF;
2761: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2762: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2763: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2764: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2765: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);

Line 2762: l_contact_contains_str := check_contacts_bulk (p_contact_list);

2758: ELSE
2759: g_score_until_thresh := false;
2760: END IF;
2761: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2762: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2763: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2764: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2765: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2766:

Line 2763: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

2759: g_score_until_thresh := false;
2760: END IF;
2761: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2762: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2763: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2764: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2765: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2766:
2767: -- Setup Search Context ID

Line 2764: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;

2760: END IF;
2761: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2762: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2763: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2764: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2765: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2766:
2767: -- Setup Search Context ID
2768: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

Line 2771: IF l_party_contains_str IS NULL THEN

2767: -- Setup Search Context ID
2768: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
2769: x_search_ctx_id := l_search_ctx_id;
2770:
2771: IF l_party_contains_str IS NULL THEN
2772: defpt := 1;
2773: END IF;
2774: IF l_party_site_contains_str IS NULL THEN
2775: defps := 1;

Line 2774: IF l_party_site_contains_str IS NULL THEN

2770:
2771: IF l_party_contains_str IS NULL THEN
2772: defpt := 1;
2773: END IF;
2774: IF l_party_site_contains_str IS NULL THEN
2775: defps := 1;
2776: END IF;
2777: IF l_contact_contains_str IS NULL THEN
2778: defct := 1;

Line 2777: IF l_contact_contains_str IS NULL THEN

2773: END IF;
2774: IF l_party_site_contains_str IS NULL THEN
2775: defps := 1;
2776: END IF;
2777: IF l_contact_contains_str IS NULL THEN
2778: defct := 1;
2779: END IF;
2780: IF l_contact_pt_contains_str IS NULL THEN
2781: defcpt := 1;

Line 2780: IF l_contact_pt_contains_str IS NULL THEN

2776: END IF;
2777: IF l_contact_contains_str IS NULL THEN
2778: defct := 1;
2779: END IF;
2780: IF l_contact_pt_contains_str IS NULL THEN
2781: defcpt := 1;
2782: END IF;
2783:
2784: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2782: END IF;
2783:
2784: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2785: 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);
2786: 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);
2787: 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);
2788: 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);
2789: 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);
2790: 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 2787: 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);

2783:
2784: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2785: 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);
2786: 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);
2787: 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);
2788: 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);
2789: 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);
2790: 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);
2791: END IF;

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

2784: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2785: 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);
2786: 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);
2787: 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);
2788: 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);
2789: 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);
2790: 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);
2791: END IF;
2792: FOR I in 1..5 LOOP

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

2785: 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);
2786: 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);
2787: 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);
2788: 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);
2789: 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);
2790: 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);
2791: END IF;
2792: FOR I in 1..5 LOOP
2793: do_eval(I);

Line 2796: IF l_contact_contains_str IS NOT NULL THEN

2792: FOR I in 1..5 LOOP
2793: do_eval(I);
2794: END LOOP;
2795: ROLLBACK to find_persons;
2796: IF l_contact_contains_str IS NOT NULL THEN
2797: eval_contact_level(l_contact_contains_str,p_ins_details,l_contact_max_score);
2798: END IF;
2799: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2800: hz_utility_v2pub.debug(p_message=>'Evaluating Matches. Threshold : 24 ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

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

2793: do_eval(I);
2794: END LOOP;
2795: ROLLBACK to find_persons;
2796: IF l_contact_contains_str IS NOT NULL THEN
2797: eval_contact_level(l_contact_contains_str,p_ins_details,l_contact_max_score);
2798: END IF;
2799: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2800: hz_utility_v2pub.debug(p_message=>'Evaluating Matches. Threshold : 24 ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2801: END IF;

Line 3664: l_party_contains_str VARCHAR2(32000);

3660: x_num_matches OUT NUMBER
3661: ) IS
3662:
3663: -- Strings to hold the generated Intermedia query strings
3664: l_party_contains_str VARCHAR2(32000);
3665: l_match_idx NUMBER;
3666: l_party_site_contains_str VARCHAR2(32000);
3667: l_contact_contains_str VARCHAR2(32000);
3668: l_contact_pt_contains_str VARCHAR2(32000);

Line 3666: l_party_site_contains_str VARCHAR2(32000);

3662:
3663: -- Strings to hold the generated Intermedia query strings
3664: l_party_contains_str VARCHAR2(32000);
3665: l_match_idx NUMBER;
3666: l_party_site_contains_str VARCHAR2(32000);
3667: l_contact_contains_str VARCHAR2(32000);
3668: l_contact_pt_contains_str VARCHAR2(32000);
3669: l_tmp VARCHAR2(32000);
3670:

Line 3667: l_contact_contains_str VARCHAR2(32000);

3663: -- Strings to hold the generated Intermedia query strings
3664: l_party_contains_str VARCHAR2(32000);
3665: l_match_idx NUMBER;
3666: l_party_site_contains_str VARCHAR2(32000);
3667: l_contact_contains_str VARCHAR2(32000);
3668: l_contact_pt_contains_str VARCHAR2(32000);
3669: l_tmp VARCHAR2(32000);
3670:
3671: -- Other local variables

Line 3668: l_contact_pt_contains_str VARCHAR2(32000);

3664: l_party_contains_str VARCHAR2(32000);
3665: l_match_idx NUMBER;
3666: l_party_site_contains_str VARCHAR2(32000);
3667: l_contact_contains_str VARCHAR2(32000);
3668: l_contact_pt_contains_str VARCHAR2(32000);
3669: l_tmp VARCHAR2(32000);
3670:
3671: -- Other local variables
3672: l_match_str VARCHAR2(30); -- Match type (AND or OR)

Line 3742: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);

3738: 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);
3739: g_score_until_thresh := false;
3740: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3741:
3742: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
3743: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3744: 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);
3745:
3746: -- Setup Search Context ID

Line 3743: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

3739: g_score_until_thresh := false;
3740: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3741:
3742: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
3743: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3744: 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);
3745:
3746: -- Setup Search Context ID
3747: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

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

3748: x_search_ctx_id := l_search_ctx_id;
3749:
3750: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3751: 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);
3752: 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);
3753: 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);
3754: 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);
3755: END IF;
3756: IF l_party_site_contains_str IS NULL THEN

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

3749:
3750: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3751: 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);
3752: 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);
3753: 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);
3754: 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);
3755: END IF;
3756: IF l_party_site_contains_str IS NULL THEN
3757: defps := 1;

Line 3756: IF l_party_site_contains_str IS NULL THEN

3752: 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);
3753: 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);
3754: 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);
3755: END IF;
3756: IF l_party_site_contains_str IS NULL THEN
3757: defps := 1;
3758: END IF;
3759: IF l_contact_pt_contains_str IS NULL THEN
3760: defcpt := 1;

Line 3759: IF l_contact_pt_contains_str IS NULL THEN

3755: END IF;
3756: IF l_party_site_contains_str IS NULL THEN
3757: defps := 1;
3758: END IF;
3759: IF l_contact_pt_contains_str IS NULL THEN
3760: defcpt := 1;
3761: END IF;
3762:
3763: IF l_party_site_contains_str IS NOT NULL THEN

Line 3763: IF l_party_site_contains_str IS NOT NULL THEN

3759: IF l_contact_pt_contains_str IS NULL THEN
3760: defcpt := 1;
3761: END IF;
3762:
3763: IF l_party_site_contains_str IS NOT NULL THEN
3764: open_party_site_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_party_site_contains_str,NULL,l_party_site_cur);
3765: LOOP
3766: FETCH l_party_site_cur INTO
3767: l_party_site_id, l_ps_party_id, l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;

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

3760: defcpt := 1;
3761: END IF;
3762:
3763: IF l_party_site_contains_str IS NOT NULL THEN
3764: open_party_site_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_party_site_contains_str,NULL,l_party_site_cur);
3765: LOOP
3766: FETCH l_party_site_cur INTO
3767: l_party_site_id, l_ps_party_id, l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;
3768: EXIT WHEN l_party_site_cur%NOTFOUND;

Line 3785: IF l_contact_pt_contains_str IS NOT NULL THEN

3781: END LOOP;
3782: CLOSE l_party_site_cur;
3783: END IF;
3784:
3785: IF l_contact_pt_contains_str IS NOT NULL THEN
3786: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
3787: LOOP
3788: FETCH l_contact_pt_cur INTO
3789: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX7, l_TX158, l_TX10;

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

3782: CLOSE l_party_site_cur;
3783: END IF;
3784:
3785: IF l_contact_pt_contains_str IS NOT NULL THEN
3786: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
3787: LOOP
3788: FETCH l_contact_pt_cur INTO
3789: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX7, l_TX158, l_TX10;
3790: EXIT WHEN l_contact_pt_cur%NOTFOUND;

Line 3891: l_party_contains_str VARCHAR2(32000);

3887: x_num_matches OUT NUMBER
3888: ) IS
3889:
3890: -- Strings to hold the generated Intermedia query strings
3891: l_party_contains_str VARCHAR2(32000);
3892: l_party_site_contains_str VARCHAR2(32000);
3893: l_contact_contains_str VARCHAR2(32000);
3894: l_contact_pt_contains_str VARCHAR2(32000);
3895: l_tmp VARCHAR2(32000);

Line 3892: l_party_site_contains_str VARCHAR2(32000);

3888: ) IS
3889:
3890: -- Strings to hold the generated Intermedia query strings
3891: l_party_contains_str VARCHAR2(32000);
3892: l_party_site_contains_str VARCHAR2(32000);
3893: l_contact_contains_str VARCHAR2(32000);
3894: l_contact_pt_contains_str VARCHAR2(32000);
3895: l_tmp VARCHAR2(32000);
3896:

Line 3893: l_contact_contains_str VARCHAR2(32000);

3889:
3890: -- Strings to hold the generated Intermedia query strings
3891: l_party_contains_str VARCHAR2(32000);
3892: l_party_site_contains_str VARCHAR2(32000);
3893: l_contact_contains_str VARCHAR2(32000);
3894: l_contact_pt_contains_str VARCHAR2(32000);
3895: l_tmp VARCHAR2(32000);
3896:
3897: -- Other local variables

Line 3894: l_contact_pt_contains_str VARCHAR2(32000);

3890: -- Strings to hold the generated Intermedia query strings
3891: l_party_contains_str VARCHAR2(32000);
3892: l_party_site_contains_str VARCHAR2(32000);
3893: l_contact_contains_str VARCHAR2(32000);
3894: l_contact_pt_contains_str VARCHAR2(32000);
3895: l_tmp VARCHAR2(32000);
3896:
3897: -- Other local variables
3898: l_match_str VARCHAR2(30); -- Match type (AND or OR)

Line 3967: l_contact_contains_str := check_contacts_bulk (p_contact_list);

3963: 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);
3964: g_score_until_thresh := false;
3965: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3966:
3967: l_contact_contains_str := check_contacts_bulk (p_contact_list);
3968: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3969: 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);
3970:
3971: -- Setup Search Context ID

Line 3968: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

3964: g_score_until_thresh := false;
3965: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3966:
3967: l_contact_contains_str := check_contacts_bulk (p_contact_list);
3968: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3969: 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);
3970:
3971: -- Setup Search Context ID
3972: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

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

3973: x_search_ctx_id := l_search_ctx_id;
3974:
3975: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3976: 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);
3977: 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);
3978: 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);
3979: 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);
3980: END IF;
3981: IF l_contact_contains_str IS NULL THEN

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

3974:
3975: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3976: 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);
3977: 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);
3978: 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);
3979: 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);
3980: END IF;
3981: IF l_contact_contains_str IS NULL THEN
3982: defct := 1;

Line 3981: IF l_contact_contains_str IS NULL THEN

3977: 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);
3978: 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);
3979: 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);
3980: END IF;
3981: IF l_contact_contains_str IS NULL THEN
3982: defct := 1;
3983: END IF;
3984: IF l_contact_pt_contains_str IS NULL THEN
3985: defcpt := 1;

Line 3984: IF l_contact_pt_contains_str IS NULL THEN

3980: END IF;
3981: IF l_contact_contains_str IS NULL THEN
3982: defct := 1;
3983: END IF;
3984: IF l_contact_pt_contains_str IS NULL THEN
3985: defcpt := 1;
3986: END IF;
3987:
3988: IF l_contact_contains_str IS NOT NULL THEN

Line 3988: IF l_contact_contains_str IS NOT NULL THEN

3984: IF l_contact_pt_contains_str IS NULL THEN
3985: defcpt := 1;
3986: END IF;
3987:
3988: IF l_contact_contains_str IS NOT NULL THEN
3989: open_contact_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_contains_str,NULL,l_contact_cur);
3990: LOOP
3991: FETCH l_contact_cur INTO
3992: l_org_contact_id, l_ct_party_id , l_TX2, l_TX23, l_TX22;

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

3985: defcpt := 1;
3986: END IF;
3987:
3988: IF l_contact_contains_str IS NOT NULL THEN
3989: open_contact_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_contains_str,NULL,l_contact_cur);
3990: LOOP
3991: FETCH l_contact_cur INTO
3992: l_org_contact_id, l_ct_party_id , l_TX2, l_TX23, l_TX22;
3993: EXIT WHEN l_contact_cur%NOTFOUND;

Line 4008: IF l_contact_pt_contains_str IS NOT NULL THEN

4004: END LOOP;
4005: CLOSE l_contact_cur;
4006: END IF;
4007:
4008: IF l_contact_pt_contains_str IS NOT NULL THEN
4009: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
4010: LOOP
4011: FETCH l_contact_pt_cur INTO
4012: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX7, l_TX158, l_TX10;

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

4005: CLOSE l_contact_cur;
4006: END IF;
4007:
4008: IF l_contact_pt_contains_str IS NOT NULL THEN
4009: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
4010: LOOP
4011: FETCH l_contact_pt_cur INTO
4012: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX7, l_TX158, l_TX10;
4013: EXIT WHEN l_contact_pt_cur%NOTFOUND;

Line 4113: l_contact_pt_contains_str VARCHAR2(32000);

4109: ) IS
4110:
4111:
4112: -- Strings to hold the generated Intermedia query strings
4113: l_contact_pt_contains_str VARCHAR2(32000);
4114: l_tmp VARCHAR2(32000);
4115:
4116: -- Other local variables
4117: l_match_str VARCHAR2(30); -- Match type (AND or OR)

Line 4172: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

4168: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
4169: g_score_until_thresh := false;
4170: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4171:
4172: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4173: 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);
4174:
4175: -- Setup Search Context ID
4176: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

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

4176: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
4177: x_search_ctx_id := l_search_ctx_id;
4178: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4179: 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);
4180: 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);
4181: 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);
4182: END IF;
4183:
4184: IF l_contact_pt_contains_str IS NOT NULL THEN

Line 4184: IF l_contact_pt_contains_str IS NOT NULL THEN

4180: 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);
4181: 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);
4182: END IF;
4183:
4184: IF l_contact_pt_contains_str IS NOT NULL THEN
4185: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
4186: cnt := 1;
4187: LOOP
4188: FETCH l_contact_pt_cur INTO

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

4181: 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);
4182: END IF;
4183:
4184: IF l_contact_pt_contains_str IS NOT NULL THEN
4185: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
4186: cnt := 1;
4187: LOOP
4188: FETCH l_contact_pt_cur INTO
4189: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX7, l_TX158, l_TX10;

Line 4260: l_party_contains_str VARCHAR2(32000);

4256: x_search_ctx_id IN OUT NUMBER
4257: ) IS
4258:
4259: -- Strings to hold the generated Intermedia query strings
4260: l_party_contains_str VARCHAR2(32000);
4261: l_party_site_contains_str VARCHAR2(32000);
4262: l_contact_contains_str VARCHAR2(32000);
4263: l_contact_pt_contains_str VARCHAR2(32000);
4264: l_tmp VARCHAR2(32000);

Line 4261: l_party_site_contains_str VARCHAR2(32000);

4257: ) IS
4258:
4259: -- Strings to hold the generated Intermedia query strings
4260: l_party_contains_str VARCHAR2(32000);
4261: l_party_site_contains_str VARCHAR2(32000);
4262: l_contact_contains_str VARCHAR2(32000);
4263: l_contact_pt_contains_str VARCHAR2(32000);
4264: l_tmp VARCHAR2(32000);
4265:

Line 4262: l_contact_contains_str VARCHAR2(32000);

4258:
4259: -- Strings to hold the generated Intermedia query strings
4260: l_party_contains_str VARCHAR2(32000);
4261: l_party_site_contains_str VARCHAR2(32000);
4262: l_contact_contains_str VARCHAR2(32000);
4263: l_contact_pt_contains_str VARCHAR2(32000);
4264: l_tmp VARCHAR2(32000);
4265:
4266: -- Other local variables

Line 4263: l_contact_pt_contains_str VARCHAR2(32000);

4259: -- Strings to hold the generated Intermedia query strings
4260: l_party_contains_str VARCHAR2(32000);
4261: l_party_site_contains_str VARCHAR2(32000);
4262: l_contact_contains_str VARCHAR2(32000);
4263: l_contact_pt_contains_str VARCHAR2(32000);
4264: l_tmp VARCHAR2(32000);
4265:
4266: -- Other local variables
4267: l_match_str VARCHAR2(30); -- Match type (AND or OR)

Line 4338: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);

4334:
4335: 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);
4336: g_score_until_thresh := false;
4337: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4338: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
4339: l_contact_contains_str := check_contacts_bulk (p_contact_list);
4340: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4341: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
4342:

Line 4339: l_contact_contains_str := check_contacts_bulk (p_contact_list);

4335: 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);
4336: g_score_until_thresh := false;
4337: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4338: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
4339: l_contact_contains_str := check_contacts_bulk (p_contact_list);
4340: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4341: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
4342:
4343: -- Setup Search Context ID

Line 4340: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

4336: g_score_until_thresh := false;
4337: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4338: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
4339: l_contact_contains_str := check_contacts_bulk (p_contact_list);
4340: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4341: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
4342:
4343: -- Setup Search Context ID
4344: IF x_search_ctx_id IS NULL THEN

Line 4360: IF l_party_site_contains_str IS NOT NULL THEN

4356: 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);
4357: END LOOP;
4358: CLOSE l_party_cur;
4359:
4360: IF l_party_site_contains_str IS NOT NULL THEN
4361: l_max_score := 0;
4362: l_max_id := 0;
4363: l_max_idx := 0;
4364: open_party_site_cursor(null, p_party_id, null, l_party_site_contains_str,NULL,l_party_site_cur);

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

4360: IF l_party_site_contains_str IS NOT NULL THEN
4361: l_max_score := 0;
4362: l_max_id := 0;
4363: l_max_idx := 0;
4364: open_party_site_cursor(null, p_party_id, null, l_party_site_contains_str,NULL,l_party_site_cur);
4365: LOOP
4366: FETCH l_party_site_cur INTO
4367: l_party_site_id, l_ps_party_id,l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;
4368: EXIT WHEN l_party_site_cur%NOTFOUND;

Line 4386: IF l_contact_contains_str IS NOT NULL THEN

4382: 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);
4383: END IF;
4384: END IF;
4385:
4386: IF l_contact_contains_str IS NOT NULL THEN
4387: l_max_score := 0;
4388: l_max_id := 0;
4389: l_max_idx := 0;
4390: open_contact_cursor(null, p_party_id, null, l_contact_contains_str,NULL,l_contact_cur);

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

4386: IF l_contact_contains_str IS NOT NULL THEN
4387: l_max_score := 0;
4388: l_max_id := 0;
4389: l_max_idx := 0;
4390: open_contact_cursor(null, p_party_id, null, l_contact_contains_str,NULL,l_contact_cur);
4391: LOOP
4392: FETCH l_contact_cur INTO
4393: l_org_contact_id, l_ct_party_id , l_TX2, l_TX23, l_TX22;
4394: EXIT WHEN l_contact_cur%NOTFOUND;

Line 4411: IF l_contact_pt_contains_str IS NOT NULL THEN

4407: 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);
4408: END IF;
4409: END IF;
4410:
4411: IF l_contact_pt_contains_str IS NOT NULL THEN
4412: l_max_score := 0;
4413: l_max_id := 0;
4414: l_max_idx := 0;
4415: open_contact_pt_cursor(null, p_party_id, null, l_contact_pt_contains_str,NULL,l_contact_pt_cur);

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

4411: IF l_contact_pt_contains_str IS NOT NULL THEN
4412: l_max_score := 0;
4413: l_max_id := 0;
4414: l_max_idx := 0;
4415: open_contact_pt_cursor(null, p_party_id, null, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
4416: LOOP
4417: FETCH l_contact_pt_cur INTO
4418: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX7, l_TX158, l_TX10;
4419: EXIT WHEN l_contact_pt_cur%NOTFOUND;