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

Line 945: p_contains_str VARCHAR2,

941:
942: PROCEDURE open_party_cursor(
943: p_dup_party_id NUMBER,
944: p_restrict_sql VARCHAR2,
945: p_contains_str VARCHAR2,
946: p_search_ctx_id NUMBER,
947: p_match_str VARCHAR2,
948: p_search_merged VARCHAR2,
949: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS

Line 952: IF p_contains_str IS NULL THEN

948: p_search_merged VARCHAR2,
949: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
950: l_sqlstr VARCHAR2(4000);
951: BEGIN
952: IF p_contains_str IS NULL THEN
953: OPEN x_cursor FOR
954: SELECT PARTY_ID , TX2, TX59, TX45
955: FROM HZ_STAGED_PARTIES stage
956: WHERE PARTY_ID = p_dup_party_id;

Line 1030: OPEN x_cursor FOR l_sqlstr USING p_contains_str

1026: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';
1027: IF p_search_merged IS NULL OR p_search_merged <> 'Y' THEN
1028: l_sqlstr := l_sqlstr ||' AND nvl(stage.status,''A'') in (''A'')';
1029: END IF;
1030: OPEN x_cursor FOR l_sqlstr USING p_contains_str
1031: ,g_party_stage_rec.TX36,g_party_stage_rec.TX36
1032: ,p_dup_party_id, p_dup_party_id;
1033: END IF;
1034: END IF;

Line 1050: p_contains_str VARCHAR2,

1046: PROCEDURE open_party_site_cursor(
1047: p_dup_party_id NUMBER,
1048: p_party_id NUMBER,
1049: p_restrict_sql VARCHAR2,
1050: p_contains_str VARCHAR2,
1051: p_search_ctx_id NUMBER,
1052: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1053: l_sqlstr VARCHAR2(4000);
1054: BEGIN

Line 1127: OPEN x_cursor FOR l_sqlstr USING p_contains_str

1123: ' AND p.party_id = stage.party_id ' ||
1124: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36))) ' ||
1125: ' AND ('||p_restrict_sql||')' ||
1126: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';
1127: OPEN x_cursor FOR l_sqlstr USING p_contains_str
1128: ,g_party_stage_rec.TX36,g_party_stage_rec.TX36
1129: ,p_dup_party_id, p_dup_party_id;
1130: END IF;
1131: exception

Line 1146: p_contains_str VARCHAR2,

1142: PROCEDURE open_contact_cursor(
1143: p_dup_party_id NUMBER,
1144: p_party_id NUMBER,
1145: p_restrict_sql VARCHAR2,
1146: p_contains_str VARCHAR2,
1147: p_search_ctx_id NUMBER,
1148: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1149: l_sqlstr VARCHAR2(4000);
1150: BEGIN

Line 1158: p_contains_str VARCHAR2,

1154: PROCEDURE open_contact_pt_cursor(
1155: p_dup_party_id NUMBER,
1156: p_party_id NUMBER,
1157: p_restrict_sql VARCHAR2,
1158: p_contains_str VARCHAR2,
1159: p_search_ctx_id NUMBER,
1160: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
1161: l_sqlstr VARCHAR2(4000);
1162: BEGIN

Line 1259: OPEN x_cursor FOR l_sqlstr USING p_contains_str

1255: ' WHERE p.party_id = stage.party_id ' ||
1256: ' AND ((:TX36 IS NULL OR :TX36||'' '' = p.TX36))) ' ||
1257: ' AND ('||p_restrict_sql||')' ||
1258: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';
1259: OPEN x_cursor FOR l_sqlstr USING p_contains_str
1260: ,g_party_stage_rec.TX36,g_party_stage_rec.TX36
1261: ,p_dup_party_id, p_dup_party_id;
1262: END IF;
1263: exception

Line 1332: l_party_contains_str VARCHAR2(32000);

1328: x_num_matches OUT NUMBER
1329: ) IS
1330:
1331: -- Strings to hold the generated Intermedia query strings
1332: l_party_contains_str VARCHAR2(32000);
1333: l_party_site_contains_str VARCHAR2(32000);
1334: l_contact_contains_str VARCHAR2(32000);
1335: l_contact_pt_contains_str VARCHAR2(32000);
1336: l_denorm_str VARCHAR2(32000);

Line 1333: l_party_site_contains_str VARCHAR2(32000);

1329: ) IS
1330:
1331: -- Strings to hold the generated Intermedia query strings
1332: l_party_contains_str VARCHAR2(32000);
1333: l_party_site_contains_str VARCHAR2(32000);
1334: l_contact_contains_str VARCHAR2(32000);
1335: l_contact_pt_contains_str VARCHAR2(32000);
1336: l_denorm_str VARCHAR2(32000);
1337: l_ps_denorm_str VARCHAR2(32000);

Line 1334: l_contact_contains_str VARCHAR2(32000);

1330:
1331: -- Strings to hold the generated Intermedia query strings
1332: l_party_contains_str VARCHAR2(32000);
1333: l_party_site_contains_str VARCHAR2(32000);
1334: l_contact_contains_str VARCHAR2(32000);
1335: l_contact_pt_contains_str VARCHAR2(32000);
1336: l_denorm_str VARCHAR2(32000);
1337: l_ps_denorm_str VARCHAR2(32000);
1338: l_ct_denorm_str VARCHAR2(32000);

Line 1335: l_contact_pt_contains_str VARCHAR2(32000);

1331: -- Strings to hold the generated Intermedia query strings
1332: l_party_contains_str VARCHAR2(32000);
1333: l_party_site_contains_str VARCHAR2(32000);
1334: l_contact_contains_str VARCHAR2(32000);
1335: l_contact_pt_contains_str VARCHAR2(32000);
1336: l_denorm_str VARCHAR2(32000);
1337: l_ps_denorm_str VARCHAR2(32000);
1338: l_ct_denorm_str VARCHAR2(32000);
1339: l_cpt_denorm_str VARCHAR2(32000);

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

1427: call_type(2) := 'OR';
1428: END;
1429:
1430: /** Private procedure to acquire and score at party level ***/
1431: PROCEDURE eval_party_level(p_party_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER) IS
1432: l_party_id_idx NUMBER:=1;
1433: l_ctx_id NUMBER;
1434: BEGIN
1435: SAVEPOINT eval_start;

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

1449: ELSE
1450: l_ctx_id := NULL;
1451: l_party_id_idx := H_PARTY_ID.COUNT+1;
1452: END IF;
1453: 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);
1454: LOOP
1455: FETCH l_party_cur INTO
1456: l_party_id , l_TX2, l_TX59, l_TX45;
1457: EXIT WHEN l_party_cur%NOTFOUND;

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

1493: ROLLBACK to eval_start;
1494: END;
1495:
1496: /** Private procedure to acquire and score at party site level ***/
1497: 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
1498: l_party_id_idx NUMBER:=1;
1499: l_ctx_id NUMBER;
1500: BEGIN
1501: SAVEPOINT eval_start;

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

1515: ELSE
1516: l_party_id_idx := H_PARTY_ID.COUNT+1;
1517: l_ctx_id := NULL;
1518: END IF;
1519: open_party_site_cursor(p_dup_party_id,NULL, p_restrict_sql, p_party_site_contains_str,l_ctx_id, l_party_site_cur);
1520: LOOP
1521: FETCH l_party_site_cur INTO
1522: l_party_site_id, l_ps_party_id, l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;
1523: EXIT WHEN l_party_site_cur%NOTFOUND;

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

1570: ROLLBACK to eval_start;
1571: END;
1572:
1573: /** Private procedure to acquire and score at party site level ***/
1574: 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
1575: l_party_id_idx NUMBER:=1;
1576: l_ctx_id NUMBER;
1577: BEGIN
1578: SAVEPOINT eval_start;

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

1592: ELSE
1593: l_ctx_id := NULL;
1594: l_party_id_idx := H_PARTY_ID.COUNT+1;
1595: END IF;
1596: open_contact_cursor(p_dup_party_id,NULL, p_restrict_sql, p_contact_contains_str,l_ctx_id, l_contact_cur);
1597: LOOP
1598: FETCH l_contact_cur INTO
1599: l_org_contact_id, l_ct_party_id ;
1600: EXIT WHEN l_contact_cur%NOTFOUND;

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

1645: ROLLBACK to eval_start;
1646: END;
1647:
1648: /** Private procedure to acquire and score at contact point level ***/
1649: 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
1650: l_party_id_idx NUMBER:=1;
1651: l_ctx_id NUMBER;
1652: BEGIN
1653: SAVEPOINT eval_start;

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

1667: ELSE
1668: l_ctx_id := NULL;
1669: l_party_id_idx := H_PARTY_ID.COUNT+1;
1670: END IF;
1671: open_contact_pt_cursor(p_dup_party_id,NULL, p_restrict_sql, p_contact_pt_contains_str,l_ctx_id, l_contact_pt_cur);
1672: LOOP
1673: FETCH l_contact_pt_cur INTO
1674: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX158, l_TX10;
1675: EXIT WHEN l_contact_pt_cur%NOTFOUND;

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

1744: FND_MSG_PUB.ADD;
1745: RAISE FND_API.G_EXC_ERROR;
1746: END IF;
1747: END IF;
1748: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
1749: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
1750: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
1751: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1752: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN

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

1745: RAISE FND_API.G_EXC_ERROR;
1746: END IF;
1747: END IF;
1748: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
1749: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
1750: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
1751: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1752: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
1753: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));

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

1746: END IF;
1747: END IF;
1748: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
1749: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
1750: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
1751: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1752: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
1753: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1754: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN

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

1747: END IF;
1748: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
1749: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
1750: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
1751: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1752: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
1753: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1754: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
1755: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));

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

1748: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
1749: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
1750: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
1751: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1752: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
1753: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1754: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
1755: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1756: END IF;

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

1749: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
1750: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
1751: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1752: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
1753: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1754: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
1755: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1756: END IF;
1757: END;

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

1750: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
1751: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1752: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
1753: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1754: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
1755: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1756: END IF;
1757: END;
1758: /************ End of find_parties private procedures **********/

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

1751: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1752: ELSIF call_order(p_index) = 'CONTACT' AND l_contact_contains_str IS NOT NULL THEN
1753: eval_contact_level(l_contact_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1754: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
1755: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
1756: END IF;
1757: END;
1758: /************ End of find_parties private procedures **********/
1759:

Line 1810: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);

1806: g_score_until_thresh := true;
1807: ELSE
1808: g_score_until_thresh := false;
1809: END IF;
1810: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
1811: l_contact_contains_str := check_contacts_bulk (p_contact_list);
1812: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
1813: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
1814: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);

Line 1811: l_contact_contains_str := check_contacts_bulk (p_contact_list);

1807: ELSE
1808: g_score_until_thresh := false;
1809: END IF;
1810: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
1811: l_contact_contains_str := check_contacts_bulk (p_contact_list);
1812: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
1813: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
1814: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
1815:

Line 1812: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

1808: g_score_until_thresh := false;
1809: END IF;
1810: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
1811: l_contact_contains_str := check_contacts_bulk (p_contact_list);
1812: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
1813: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
1814: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
1815:
1816: -- Setup Search Context ID

Line 1813: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;

1809: END IF;
1810: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
1811: l_contact_contains_str := check_contacts_bulk (p_contact_list);
1812: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
1813: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
1814: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
1815:
1816: -- Setup Search Context ID
1817: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

Line 1820: IF l_party_contains_str IS NULL THEN

1816: -- Setup Search Context ID
1817: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
1818: x_search_ctx_id := l_search_ctx_id;
1819:
1820: IF l_party_contains_str IS NULL THEN
1821: defpt := 1;
1822: END IF;
1823: IF l_party_site_contains_str IS NULL THEN
1824: defps := 1;

Line 1823: IF l_party_site_contains_str IS NULL THEN

1819:
1820: IF l_party_contains_str IS NULL THEN
1821: defpt := 1;
1822: END IF;
1823: IF l_party_site_contains_str IS NULL THEN
1824: defps := 1;
1825: END IF;
1826: IF l_contact_contains_str IS NULL THEN
1827: defct := 1;

Line 1826: IF l_contact_contains_str IS NULL THEN

1822: END IF;
1823: IF l_party_site_contains_str IS NULL THEN
1824: defps := 1;
1825: END IF;
1826: IF l_contact_contains_str IS NULL THEN
1827: defct := 1;
1828: END IF;
1829: IF l_contact_pt_contains_str IS NULL THEN
1830: defcpt := 1;

Line 1829: IF l_contact_pt_contains_str IS NULL THEN

1825: END IF;
1826: IF l_contact_contains_str IS NULL THEN
1827: defct := 1;
1828: END IF;
1829: IF l_contact_pt_contains_str IS NULL THEN
1830: defcpt := 1;
1831: END IF;
1832:
1833: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1831: END IF;
1832:
1833: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1834: 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);
1835: 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);
1836: 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);
1837: 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);
1838: 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);
1839: 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 1836: 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);

1832:
1833: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1834: 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);
1835: 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);
1836: 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);
1837: 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);
1838: 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);
1839: 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);
1840: END IF;

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

1833: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1834: 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);
1835: 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);
1836: 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);
1837: 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);
1838: 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);
1839: 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);
1840: END IF;
1841: FOR I in 1..5 LOOP

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

1834: 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);
1835: 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);
1836: 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);
1837: 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);
1838: 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);
1839: 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);
1840: END IF;
1841: FOR I in 1..5 LOOP
1842: do_eval(I);

Line 1956: l_party_contains_str VARCHAR2(32000);

1952: x_num_matches OUT NUMBER
1953: ) IS
1954:
1955: -- Strings to hold the generated Intermedia query strings
1956: l_party_contains_str VARCHAR2(32000);
1957: l_party_site_contains_str VARCHAR2(32000);
1958: l_contact_contains_str VARCHAR2(32000);
1959: l_contact_pt_contains_str VARCHAR2(32000);
1960: l_denorm_str VARCHAR2(32000);

Line 1957: l_party_site_contains_str VARCHAR2(32000);

1953: ) IS
1954:
1955: -- Strings to hold the generated Intermedia query strings
1956: l_party_contains_str VARCHAR2(32000);
1957: l_party_site_contains_str VARCHAR2(32000);
1958: l_contact_contains_str VARCHAR2(32000);
1959: l_contact_pt_contains_str VARCHAR2(32000);
1960: l_denorm_str VARCHAR2(32000);
1961: l_ps_denorm_str VARCHAR2(32000);

Line 1958: l_contact_contains_str VARCHAR2(32000);

1954:
1955: -- Strings to hold the generated Intermedia query strings
1956: l_party_contains_str VARCHAR2(32000);
1957: l_party_site_contains_str VARCHAR2(32000);
1958: l_contact_contains_str VARCHAR2(32000);
1959: l_contact_pt_contains_str VARCHAR2(32000);
1960: l_denorm_str VARCHAR2(32000);
1961: l_ps_denorm_str VARCHAR2(32000);
1962: l_ct_denorm_str VARCHAR2(32000);

Line 1959: l_contact_pt_contains_str VARCHAR2(32000);

1955: -- Strings to hold the generated Intermedia query strings
1956: l_party_contains_str VARCHAR2(32000);
1957: l_party_site_contains_str VARCHAR2(32000);
1958: l_contact_contains_str VARCHAR2(32000);
1959: l_contact_pt_contains_str VARCHAR2(32000);
1960: l_denorm_str VARCHAR2(32000);
1961: l_ps_denorm_str VARCHAR2(32000);
1962: l_ct_denorm_str VARCHAR2(32000);
1963: l_cpt_denorm_str VARCHAR2(32000);

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

2087: call_type(2) := 'OR';
2088: END;
2089:
2090: /** Private procedure to acquire and score at party level ***/
2091: PROCEDURE eval_party_level(p_party_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER) IS
2092: l_party_id_idx NUMBER:=1;
2093: l_ctx_id NUMBER;
2094: BEGIN
2095: SAVEPOINT eval_start;

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

2110: ELSE
2111: l_ctx_id := NULL;
2112: l_party_id_idx := H_PARTY_ID.COUNT+1;
2113: END IF;
2114: open_party_cursor(null, p_restrict_sql, p_party_contains_str,l_ctx_id, l_match_str,null,l_party_cur);
2115: LOOP
2116: FETCH l_party_cur INTO
2117: l_party_id , l_TX2, l_TX59, l_TX45;
2118: EXIT WHEN l_party_cur%NOTFOUND;

Line 2157: p_contains_str VARCHAR2,

2153: CLOSE l_party_cur;
2154: ROLLBACK to eval_start;
2155: END;
2156: PROCEDURE open_person_contact_cursor(
2157: p_contains_str VARCHAR2,
2158: p_search_ctx_id NUMBER,
2159: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2160: BEGIN
2161: OPEN x_cursor FOR

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

2160: BEGIN
2161: OPEN x_cursor FOR
2162: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
2163: FROM HZ_STAGED_CONTACTS stage
2164: WHERE contains( concat_col, p_contains_str)>0
2165: AND ORG_CONTACT_ID in (
2166: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
2167: org_contact_id
2168: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc

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

2184: end if;
2185: END;
2186:
2187: /** Private procedure to acquire and score at party site level ***/
2188: 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
2189: l_party_id_idx NUMBER:=1;
2190: l_ctx_id NUMBER;
2191: l_person_id NUMBER;
2192: BEGIN

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

2220: ELSE
2221: l_party_id_idx := H_PARTY_ID.COUNT+1;
2222: l_ctx_id := NULL;
2223: END IF;
2224: open_party_site_cursor(null,NULL, p_restrict_sql, p_party_site_contains_str,l_ctx_id, l_party_site_cur);
2225: LOOP
2226: FETCH l_party_site_cur INTO
2227: l_party_site_id, l_ps_party_id, l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;
2228: EXIT WHEN l_party_site_cur%NOTFOUND;

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

2278: ROLLBACK to eval_start;
2279: END;
2280:
2281: /** Private procedure to acquire and score at party site level ***/
2282: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
2283: l_party_id_idx NUMBER:=1;
2284: l_ctx_id NUMBER;
2285: BEGIN
2286: SAVEPOINT eval_start;

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

2289: FORALL I in 1..H_PARTY_ID.COUNT
2290: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2291: l_search_ctx_id,H_PARTY_ID(I));
2292: l_party_id_idx := H_PARTY_ID.COUNT+1;
2293: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
2294: LOOP
2295: FETCH l_contact_cur INTO
2296: l_org_contact_id, l_ct_party_id ;
2297: EXIT WHEN l_contact_cur%NOTFOUND;

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

2322: ROLLBACK to eval_start;
2323: END;
2324:
2325: /** Private procedure to acquire and score at contact point level ***/
2326: 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
2327: l_party_id_idx NUMBER:=1;
2328: l_ctx_id NUMBER;
2329: BEGIN
2330: SAVEPOINT eval_start;

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

2357: ELSE
2358: l_ctx_id := NULL;
2359: l_party_id_idx := H_PARTY_ID.COUNT+1;
2360: END IF;
2361: open_contact_pt_cursor(null,NULL, p_restrict_sql, p_contact_pt_contains_str,l_ctx_id, l_contact_pt_cur);
2362: LOOP
2363: FETCH l_contact_pt_cur INTO
2364: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX158, l_TX10;
2365: EXIT WHEN l_contact_pt_cur%NOTFOUND;

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

2442: FND_MSG_PUB.ADD;
2443: RAISE FND_API.G_EXC_ERROR;
2444: END IF;
2445: END IF;
2446: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2447: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2448: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2449: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2450: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN

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

2443: RAISE FND_API.G_EXC_ERROR;
2444: END IF;
2445: END IF;
2446: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2447: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2448: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2449: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2450: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2451: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));

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

2444: END IF;
2445: END IF;
2446: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2447: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2448: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2449: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2450: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2451: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2452: END IF;

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

2445: END IF;
2446: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2447: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2448: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2449: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2450: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2451: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2452: END IF;
2453: END;

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

2446: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2447: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2448: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2449: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2450: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2451: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2452: END IF;
2453: END;
2454: /************ End of find_persons private procedures **********/

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

2447: eval_party_level(l_party_contains_str,call_type(p_index), p_index);
2448: ELSIF call_order(p_index) = 'PARTY_SITE' AND l_party_site_contains_str IS NOT NULL THEN
2449: eval_party_site_level(l_party_site_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2450: ELSIF call_order(p_index) = 'CONTACT_POINT' AND l_contact_pt_contains_str IS NOT NULL THEN
2451: eval_cpt_level(l_contact_pt_contains_str,call_type(p_index), p_index,p_ins_details,call_max_score(p_index));
2452: END IF;
2453: END;
2454: /************ End of find_persons private procedures **********/
2455:

Line 2485: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);

2481: g_score_until_thresh := true;
2482: ELSE
2483: g_score_until_thresh := false;
2484: END IF;
2485: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2486: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2487: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2488: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2489: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);

Line 2486: l_contact_contains_str := check_contacts_bulk (p_contact_list);

2482: ELSE
2483: g_score_until_thresh := false;
2484: END IF;
2485: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2486: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2487: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2488: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2489: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2490:

Line 2487: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

2483: g_score_until_thresh := false;
2484: END IF;
2485: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2486: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2487: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2488: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2489: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2490:
2491: -- Setup Search Context ID

Line 2488: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;

2484: END IF;
2485: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
2486: l_contact_contains_str := check_contacts_bulk (p_contact_list);
2487: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
2488: l_party_contains_str := check_parties_bulk (p_party_search_rec) ;
2489: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
2490:
2491: -- Setup Search Context ID
2492: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

Line 2495: IF l_party_contains_str IS NULL THEN

2491: -- Setup Search Context ID
2492: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
2493: x_search_ctx_id := l_search_ctx_id;
2494:
2495: IF l_party_contains_str IS NULL THEN
2496: defpt := 1;
2497: END IF;
2498: IF l_party_site_contains_str IS NULL THEN
2499: defps := 1;

Line 2498: IF l_party_site_contains_str IS NULL THEN

2494:
2495: IF l_party_contains_str IS NULL THEN
2496: defpt := 1;
2497: END IF;
2498: IF l_party_site_contains_str IS NULL THEN
2499: defps := 1;
2500: END IF;
2501: IF l_contact_contains_str IS NULL THEN
2502: defct := 1;

Line 2501: IF l_contact_contains_str IS NULL THEN

2497: END IF;
2498: IF l_party_site_contains_str IS NULL THEN
2499: defps := 1;
2500: END IF;
2501: IF l_contact_contains_str IS NULL THEN
2502: defct := 1;
2503: END IF;
2504: IF l_contact_pt_contains_str IS NULL THEN
2505: defcpt := 1;

Line 2504: IF l_contact_pt_contains_str IS NULL THEN

2500: END IF;
2501: IF l_contact_contains_str IS NULL THEN
2502: defct := 1;
2503: END IF;
2504: IF l_contact_pt_contains_str IS NULL THEN
2505: defcpt := 1;
2506: END IF;
2507:
2508: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2506: END IF;
2507:
2508: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2509: 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);
2510: 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);
2511: 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);
2512: 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);
2513: 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);
2514: 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 2511: 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);

2507:
2508: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2509: 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);
2510: 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);
2511: 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);
2512: 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);
2513: 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);
2514: 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);
2515: END IF;

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

2508: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2509: 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);
2510: 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);
2511: 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);
2512: 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);
2513: 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);
2514: 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);
2515: END IF;
2516: FOR I in 1..5 LOOP

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

2509: 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);
2510: 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);
2511: 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);
2512: 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);
2513: 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);
2514: 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);
2515: END IF;
2516: FOR I in 1..5 LOOP
2517: do_eval(I);

Line 2520: IF l_contact_contains_str IS NOT NULL THEN

2516: FOR I in 1..5 LOOP
2517: do_eval(I);
2518: END LOOP;
2519: ROLLBACK to find_persons;
2520: IF l_contact_contains_str IS NOT NULL THEN
2521: eval_contact_level(l_contact_contains_str,p_ins_details,l_contact_max_score);
2522: END IF;
2523: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2524: hz_utility_v2pub.debug(p_message=>'Evaluating Matches. Threshold : 33 ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

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

2517: do_eval(I);
2518: END LOOP;
2519: ROLLBACK to find_persons;
2520: IF l_contact_contains_str IS NOT NULL THEN
2521: eval_contact_level(l_contact_contains_str,p_ins_details,l_contact_max_score);
2522: END IF;
2523: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2524: hz_utility_v2pub.debug(p_message=>'Evaluating Matches. Threshold : 33 ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2525: END IF;

Line 3360: l_party_contains_str VARCHAR2(32000);

3356: x_num_matches OUT NUMBER
3357: ) IS
3358:
3359: -- Strings to hold the generated Intermedia query strings
3360: l_party_contains_str VARCHAR2(32000);
3361: l_match_idx NUMBER;
3362: l_party_site_contains_str VARCHAR2(32000);
3363: l_contact_contains_str VARCHAR2(32000);
3364: l_contact_pt_contains_str VARCHAR2(32000);

Line 3362: l_party_site_contains_str VARCHAR2(32000);

3358:
3359: -- Strings to hold the generated Intermedia query strings
3360: l_party_contains_str VARCHAR2(32000);
3361: l_match_idx NUMBER;
3362: l_party_site_contains_str VARCHAR2(32000);
3363: l_contact_contains_str VARCHAR2(32000);
3364: l_contact_pt_contains_str VARCHAR2(32000);
3365: l_tmp VARCHAR2(32000);
3366:

Line 3363: l_contact_contains_str VARCHAR2(32000);

3359: -- Strings to hold the generated Intermedia query strings
3360: l_party_contains_str VARCHAR2(32000);
3361: l_match_idx NUMBER;
3362: l_party_site_contains_str VARCHAR2(32000);
3363: l_contact_contains_str VARCHAR2(32000);
3364: l_contact_pt_contains_str VARCHAR2(32000);
3365: l_tmp VARCHAR2(32000);
3366:
3367: -- Other local variables

Line 3364: l_contact_pt_contains_str VARCHAR2(32000);

3360: l_party_contains_str VARCHAR2(32000);
3361: l_match_idx NUMBER;
3362: l_party_site_contains_str VARCHAR2(32000);
3363: l_contact_contains_str VARCHAR2(32000);
3364: l_contact_pt_contains_str VARCHAR2(32000);
3365: l_tmp VARCHAR2(32000);
3366:
3367: -- Other local variables
3368: l_match_str VARCHAR2(30); -- Match type (AND or OR)

Line 3438: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);

3434: 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);
3435: g_score_until_thresh := false;
3436: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3437:
3438: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
3439: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3440: 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);
3441:
3442: -- Setup Search Context ID

Line 3439: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

3435: g_score_until_thresh := false;
3436: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3437:
3438: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
3439: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3440: 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);
3441:
3442: -- Setup Search Context ID
3443: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

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

3444: x_search_ctx_id := l_search_ctx_id;
3445:
3446: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3447: 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);
3448: 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);
3449: 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);
3450: 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);
3451: END IF;
3452: IF l_party_site_contains_str IS NULL THEN

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

3445:
3446: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3447: 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);
3448: 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);
3449: 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);
3450: 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);
3451: END IF;
3452: IF l_party_site_contains_str IS NULL THEN
3453: defps := 1;

Line 3452: IF l_party_site_contains_str IS NULL THEN

3448: 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);
3449: 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);
3450: 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);
3451: END IF;
3452: IF l_party_site_contains_str IS NULL THEN
3453: defps := 1;
3454: END IF;
3455: IF l_contact_pt_contains_str IS NULL THEN
3456: defcpt := 1;

Line 3455: IF l_contact_pt_contains_str IS NULL THEN

3451: END IF;
3452: IF l_party_site_contains_str IS NULL THEN
3453: defps := 1;
3454: END IF;
3455: IF l_contact_pt_contains_str IS NULL THEN
3456: defcpt := 1;
3457: END IF;
3458:
3459: IF l_party_site_contains_str IS NOT NULL THEN

Line 3459: IF l_party_site_contains_str IS NOT NULL THEN

3455: IF l_contact_pt_contains_str IS NULL THEN
3456: defcpt := 1;
3457: END IF;
3458:
3459: IF l_party_site_contains_str IS NOT NULL THEN
3460: open_party_site_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_party_site_contains_str,NULL,l_party_site_cur);
3461: LOOP
3462: FETCH l_party_site_cur INTO
3463: l_party_site_id, l_ps_party_id, l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;

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

3456: defcpt := 1;
3457: END IF;
3458:
3459: IF l_party_site_contains_str IS NOT NULL THEN
3460: open_party_site_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_party_site_contains_str,NULL,l_party_site_cur);
3461: LOOP
3462: FETCH l_party_site_cur INTO
3463: l_party_site_id, l_ps_party_id, l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;
3464: EXIT WHEN l_party_site_cur%NOTFOUND;

Line 3481: IF l_contact_pt_contains_str IS NOT NULL THEN

3477: END LOOP;
3478: CLOSE l_party_site_cur;
3479: END IF;
3480:
3481: IF l_contact_pt_contains_str IS NOT NULL THEN
3482: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
3483: LOOP
3484: FETCH l_contact_pt_cur INTO
3485: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX158, l_TX10;

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

3478: CLOSE l_party_site_cur;
3479: END IF;
3480:
3481: IF l_contact_pt_contains_str IS NOT NULL THEN
3482: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
3483: LOOP
3484: FETCH l_contact_pt_cur INTO
3485: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX158, l_TX10;
3486: EXIT WHEN l_contact_pt_cur%NOTFOUND;

Line 3587: l_party_contains_str VARCHAR2(32000);

3583: x_num_matches OUT NUMBER
3584: ) IS
3585:
3586: -- Strings to hold the generated Intermedia query strings
3587: l_party_contains_str VARCHAR2(32000);
3588: l_party_site_contains_str VARCHAR2(32000);
3589: l_contact_contains_str VARCHAR2(32000);
3590: l_contact_pt_contains_str VARCHAR2(32000);
3591: l_tmp VARCHAR2(32000);

Line 3588: l_party_site_contains_str VARCHAR2(32000);

3584: ) IS
3585:
3586: -- Strings to hold the generated Intermedia query strings
3587: l_party_contains_str VARCHAR2(32000);
3588: l_party_site_contains_str VARCHAR2(32000);
3589: l_contact_contains_str VARCHAR2(32000);
3590: l_contact_pt_contains_str VARCHAR2(32000);
3591: l_tmp VARCHAR2(32000);
3592:

Line 3589: l_contact_contains_str VARCHAR2(32000);

3585:
3586: -- Strings to hold the generated Intermedia query strings
3587: l_party_contains_str VARCHAR2(32000);
3588: l_party_site_contains_str VARCHAR2(32000);
3589: l_contact_contains_str VARCHAR2(32000);
3590: l_contact_pt_contains_str VARCHAR2(32000);
3591: l_tmp VARCHAR2(32000);
3592:
3593: -- Other local variables

Line 3590: l_contact_pt_contains_str VARCHAR2(32000);

3586: -- Strings to hold the generated Intermedia query strings
3587: l_party_contains_str VARCHAR2(32000);
3588: l_party_site_contains_str VARCHAR2(32000);
3589: l_contact_contains_str VARCHAR2(32000);
3590: l_contact_pt_contains_str VARCHAR2(32000);
3591: l_tmp VARCHAR2(32000);
3592:
3593: -- Other local variables
3594: l_match_str VARCHAR2(30); -- Match type (AND or OR)

Line 3660: l_contact_contains_str := check_contacts_bulk (p_contact_list);

3656: 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);
3657: g_score_until_thresh := false;
3658: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3659:
3660: l_contact_contains_str := check_contacts_bulk (p_contact_list);
3661: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3662: 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);
3663:
3664: -- Setup Search Context ID

Line 3661: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

3657: g_score_until_thresh := false;
3658: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3659:
3660: l_contact_contains_str := check_contacts_bulk (p_contact_list);
3661: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3662: 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);
3663:
3664: -- Setup Search Context ID
3665: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

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

3666: x_search_ctx_id := l_search_ctx_id;
3667:
3668: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3669: 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);
3670: 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);
3671: 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);
3672: 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);
3673: END IF;
3674: IF l_contact_contains_str IS NULL THEN

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

3667:
3668: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3669: 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);
3670: 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);
3671: 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);
3672: 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);
3673: END IF;
3674: IF l_contact_contains_str IS NULL THEN
3675: defct := 1;

Line 3674: IF l_contact_contains_str IS NULL THEN

3670: 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);
3671: 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);
3672: 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);
3673: END IF;
3674: IF l_contact_contains_str IS NULL THEN
3675: defct := 1;
3676: END IF;
3677: IF l_contact_pt_contains_str IS NULL THEN
3678: defcpt := 1;

Line 3677: IF l_contact_pt_contains_str IS NULL THEN

3673: END IF;
3674: IF l_contact_contains_str IS NULL THEN
3675: defct := 1;
3676: END IF;
3677: IF l_contact_pt_contains_str IS NULL THEN
3678: defcpt := 1;
3679: END IF;
3680:
3681: IF l_contact_contains_str IS NOT NULL THEN

Line 3681: IF l_contact_contains_str IS NOT NULL THEN

3677: IF l_contact_pt_contains_str IS NULL THEN
3678: defcpt := 1;
3679: END IF;
3680:
3681: IF l_contact_contains_str IS NOT NULL THEN
3682: open_contact_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_contains_str,NULL,l_contact_cur);
3683: LOOP
3684: FETCH l_contact_cur INTO
3685: l_org_contact_id, l_ct_party_id ;

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

3678: defcpt := 1;
3679: END IF;
3680:
3681: IF l_contact_contains_str IS NOT NULL THEN
3682: open_contact_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_contains_str,NULL,l_contact_cur);
3683: LOOP
3684: FETCH l_contact_cur INTO
3685: l_org_contact_id, l_ct_party_id ;
3686: EXIT WHEN l_contact_cur%NOTFOUND;

Line 3701: IF l_contact_pt_contains_str IS NOT NULL THEN

3697: END LOOP;
3698: CLOSE l_contact_cur;
3699: END IF;
3700:
3701: IF l_contact_pt_contains_str IS NOT NULL THEN
3702: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
3703: LOOP
3704: FETCH l_contact_pt_cur INTO
3705: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX158, l_TX10;

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

3698: CLOSE l_contact_cur;
3699: END IF;
3700:
3701: IF l_contact_pt_contains_str IS NOT NULL THEN
3702: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
3703: LOOP
3704: FETCH l_contact_pt_cur INTO
3705: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX158, l_TX10;
3706: EXIT WHEN l_contact_pt_cur%NOTFOUND;

Line 3806: l_contact_pt_contains_str VARCHAR2(32000);

3802: ) IS
3803:
3804:
3805: -- Strings to hold the generated Intermedia query strings
3806: l_contact_pt_contains_str VARCHAR2(32000);
3807: l_tmp VARCHAR2(32000);
3808:
3809: -- Other local variables
3810: l_match_str VARCHAR2(30); -- Match type (AND or OR)

Line 3865: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

3861: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
3862: g_score_until_thresh := false;
3863: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3864:
3865: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
3866: 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);
3867:
3868: -- Setup Search Context ID
3869: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;

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

3869: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
3870: x_search_ctx_id := l_search_ctx_id;
3871: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3872: 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);
3873: 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);
3874: 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);
3875: END IF;
3876:
3877: IF l_contact_pt_contains_str IS NOT NULL THEN

Line 3877: IF l_contact_pt_contains_str IS NOT NULL THEN

3873: 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);
3874: 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);
3875: END IF;
3876:
3877: IF l_contact_pt_contains_str IS NOT NULL THEN
3878: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
3879: cnt := 1;
3880: LOOP
3881: FETCH l_contact_pt_cur INTO

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

3874: 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);
3875: END IF;
3876:
3877: IF l_contact_pt_contains_str IS NOT NULL THEN
3878: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
3879: cnt := 1;
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_TX158, l_TX10;

Line 3953: l_party_contains_str VARCHAR2(32000);

3949: x_search_ctx_id IN OUT NUMBER
3950: ) IS
3951:
3952: -- Strings to hold the generated Intermedia query strings
3953: l_party_contains_str VARCHAR2(32000);
3954: l_party_site_contains_str VARCHAR2(32000);
3955: l_contact_contains_str VARCHAR2(32000);
3956: l_contact_pt_contains_str VARCHAR2(32000);
3957: l_tmp VARCHAR2(32000);

Line 3954: l_party_site_contains_str VARCHAR2(32000);

3950: ) IS
3951:
3952: -- Strings to hold the generated Intermedia query strings
3953: l_party_contains_str VARCHAR2(32000);
3954: l_party_site_contains_str VARCHAR2(32000);
3955: l_contact_contains_str VARCHAR2(32000);
3956: l_contact_pt_contains_str VARCHAR2(32000);
3957: l_tmp VARCHAR2(32000);
3958:

Line 3955: l_contact_contains_str VARCHAR2(32000);

3951:
3952: -- Strings to hold the generated Intermedia query strings
3953: l_party_contains_str VARCHAR2(32000);
3954: l_party_site_contains_str VARCHAR2(32000);
3955: l_contact_contains_str VARCHAR2(32000);
3956: l_contact_pt_contains_str VARCHAR2(32000);
3957: l_tmp VARCHAR2(32000);
3958:
3959: -- Other local variables

Line 3956: l_contact_pt_contains_str VARCHAR2(32000);

3952: -- Strings to hold the generated Intermedia query strings
3953: l_party_contains_str VARCHAR2(32000);
3954: l_party_site_contains_str VARCHAR2(32000);
3955: l_contact_contains_str VARCHAR2(32000);
3956: l_contact_pt_contains_str VARCHAR2(32000);
3957: l_tmp VARCHAR2(32000);
3958:
3959: -- Other local variables
3960: l_match_str VARCHAR2(30); -- Match type (AND or OR)

Line 4027: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);

4023:
4024: 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);
4025: g_score_until_thresh := false;
4026: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4027: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
4028: l_contact_contains_str := check_contacts_bulk (p_contact_list);
4029: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4030: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
4031:

Line 4028: l_contact_contains_str := check_contacts_bulk (p_contact_list);

4024: 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);
4025: g_score_until_thresh := false;
4026: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4027: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
4028: l_contact_contains_str := check_contacts_bulk (p_contact_list);
4029: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4030: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
4031:
4032: -- Setup Search Context ID

Line 4029: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);

4025: g_score_until_thresh := false;
4026: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4027: l_party_site_contains_str := check_party_sites_bulk (p_party_site_list);
4028: l_contact_contains_str := check_contacts_bulk (p_contact_list);
4029: l_contact_pt_contains_str := check_cpts_bulk (p_contact_point_list);
4030: init_score_context(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list);
4031:
4032: -- Setup Search Context ID
4033: IF x_search_ctx_id IS NULL THEN

Line 4049: IF l_party_site_contains_str IS NOT NULL THEN

4045: 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_TX45,1);
4046: END LOOP;
4047: CLOSE l_party_cur;
4048:
4049: IF l_party_site_contains_str IS NOT NULL THEN
4050: l_max_score := 0;
4051: l_max_id := 0;
4052: l_max_idx := 0;
4053: open_party_site_cursor(null, p_party_id, null, l_party_site_contains_str,NULL,l_party_site_cur);

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

4049: IF l_party_site_contains_str IS NOT NULL THEN
4050: l_max_score := 0;
4051: l_max_id := 0;
4052: l_max_idx := 0;
4053: open_party_site_cursor(null, p_party_id, null, l_party_site_contains_str,NULL,l_party_site_cur);
4054: LOOP
4055: FETCH l_party_site_cur INTO
4056: l_party_site_id, l_ps_party_id,l_ps_contact_id , l_TX26, l_TX9, l_TX14, l_TX22;
4057: EXIT WHEN l_party_site_cur%NOTFOUND;

Line 4075: IF l_contact_contains_str IS NOT NULL THEN

4071: 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);
4072: END IF;
4073: END IF;
4074:
4075: IF l_contact_contains_str IS NOT NULL THEN
4076: l_max_score := 0;
4077: l_max_id := 0;
4078: l_max_idx := 0;
4079: open_contact_cursor(null, p_party_id, null, l_contact_contains_str,NULL,l_contact_cur);

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

4075: IF l_contact_contains_str IS NOT NULL THEN
4076: l_max_score := 0;
4077: l_max_id := 0;
4078: l_max_idx := 0;
4079: open_contact_cursor(null, p_party_id, null, l_contact_contains_str,NULL,l_contact_cur);
4080: LOOP
4081: FETCH l_contact_cur INTO
4082: l_org_contact_id, l_ct_party_id ;
4083: EXIT WHEN l_contact_cur%NOTFOUND;

Line 4097: IF l_contact_pt_contains_str IS NOT NULL THEN

4093: 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_idx);
4094: END IF;
4095: END IF;
4096:
4097: IF l_contact_pt_contains_str IS NOT NULL THEN
4098: l_max_score := 0;
4099: l_max_id := 0;
4100: l_max_idx := 0;
4101: open_contact_pt_cursor(null, p_party_id, null, l_contact_pt_contains_str,NULL,l_contact_pt_cur);

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

4097: IF l_contact_pt_contains_str IS NOT NULL THEN
4098: l_max_score := 0;
4099: l_max_id := 0;
4100: l_max_idx := 0;
4101: open_contact_pt_cursor(null, p_party_id, null, l_contact_pt_contains_str,NULL,l_contact_pt_cur);
4102: LOOP
4103: FETCH l_contact_pt_cur INTO
4104: l_contact_pt_id, l_cpt_party_id, l_cpt_ps_id, l_cpt_contact_id , l_TX5, l_TX158, l_TX10;
4105: EXIT WHEN l_contact_pt_cur%NOTFOUND;