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_COMPILE dependencies on HZ_MATCH_RULES_VL

Line 538: FROM HZ_MATCH_RULES_VL

534:
535: BEGIN
536: -- Verify that the match rule exists
537: SELECT 1 INTO l_batch_flag
538: FROM HZ_MATCH_RULES_VL
539: WHERE match_rule_id = l_rule_id;
540:
541: EXCEPTION
542: WHEN NO_DATA_FOUND THEN

Line 549: SELECT RULE_PURPOSE,NVL(MATCH_RULE_TYPE,'SINGLE') into l_purpose,l_match_rule_type FROM HZ_MATCH_RULES_VL --Code Change for Match Rule Set

545: RAISE FND_API.G_EXC_ERROR;
546: END;
547:
548:
549: SELECT RULE_PURPOSE,NVL(MATCH_RULE_TYPE,'SINGLE') into l_purpose,l_match_rule_type FROM HZ_MATCH_RULES_VL --Code Change for Match Rule Set
550: WHERE match_rule_id = l_rule_id;
551:
552: --Start of Code Change for Match Rule Set
553: IF (l_match_rule_type = 'SET') THEN

Line 822: l(' FROM HZ_MATCH_RULES_VL ');

818: l(' x_msg_data OUT VARCHAR2');
819: l(') IS');
820: l(' CURSOR c_match_rule IS ');
821: l(' SELECT COMPILATION_FLAG ');
822: l(' FROM HZ_MATCH_RULES_VL ');
823: l(' WHERE MATCH_RULE_ID = p_rule_id;');
824: l(' l_cmp_flag VARCHAR2(1);');
825: l(' BEGIN');
826: l('');

Line 855: FROM HZ_MATCH_RULES_VL

851: l(' END IF;');
852:
853: FIRST := TRUE;
854: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
855: FROM HZ_MATCH_RULES_VL
856: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
857: AND (nvl(COMPILATION_FLAG,'N') = 'C'
858: OR MATCH_RULE_ID = p_rule_id)) LOOP
859: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 908: l(' FROM HZ_MATCH_RULES_VL ');

904: l(' x_msg_data OUT VARCHAR2');
905: l(') IS');
906: l(' CURSOR c_match_rule IS ');
907: l(' SELECT COMPILATION_FLAG ');
908: l(' FROM HZ_MATCH_RULES_VL ');
909: l(' WHERE MATCH_RULE_ID = p_rule_id;');
910: l(' l_cmp_flag VARCHAR2(1);');
911: l(' BEGIN');
912: l('');

Line 946: FROM HZ_MATCH_RULES_VL

942: 'null,null,null,null,x,y); end;';
943:
944: FIRST := TRUE;
945: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
946: FROM HZ_MATCH_RULES_VL
947: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
948: AND (nvl(COMPILATION_FLAG,'N') = 'C'
949: OR MATCH_RULE_ID = p_rule_id)) LOOP
950: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 1023: l(' FROM HZ_MATCH_RULES_VL ');

1019: l(' x_msg_data OUT VARCHAR2');
1020: l(') IS');
1021: l(' CURSOR c_match_rule IS ');
1022: l(' SELECT COMPILATION_FLAG ');
1023: l(' FROM HZ_MATCH_RULES_VL ');
1024: l(' WHERE MATCH_RULE_ID = p_rule_id;');
1025: l(' l_cmp_flag VARCHAR2(1);');
1026: l(' BEGIN');
1027:

Line 1061: FROM HZ_MATCH_RULES_VL

1057: l(' END IF;');
1058:
1059: FIRST := TRUE;
1060: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
1061: FROM HZ_MATCH_RULES_VL
1062: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
1063: AND (nvl(COMPILATION_FLAG,'N') = 'C'
1064: OR MATCH_RULE_ID = p_rule_id)) LOOP
1065: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 1104: l(' FROM HZ_MATCH_RULES_VL ');

1100: l(' x_msg_data OUT VARCHAR2');
1101: l(') IS');
1102: l(' CURSOR c_match_rule IS ');
1103: l(' SELECT COMPILATION_FLAG ');
1104: l(' FROM HZ_MATCH_RULES_VL ');
1105: l(' WHERE MATCH_RULE_ID = p_rule_id;');
1106: l(' l_cmp_flag VARCHAR2(1);');
1107: l(' BEGIN');
1108:

Line 1144: FROM HZ_MATCH_RULES_VL

1140: l(' END IF;');
1141:
1142: FIRST := TRUE;
1143: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
1144: FROM HZ_MATCH_RULES_VL
1145: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
1146: AND (nvl(COMPILATION_FLAG,'N') = 'C'
1147: OR MATCH_RULE_ID = p_rule_id)) LOOP
1148: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 1188: l(' FROM HZ_MATCH_RULES_VL ');

1184: l(' x_msg_data OUT VARCHAR2');
1185: l(') IS');
1186: l(' CURSOR c_match_rule IS ');
1187: l(' SELECT COMPILATION_FLAG ');
1188: l(' FROM HZ_MATCH_RULES_VL ');
1189: l(' WHERE MATCH_RULE_ID = p_rule_id;');
1190: l(' l_cmp_flag VARCHAR2(1);');
1191: l(' BEGIN');
1192:

Line 1224: FROM HZ_MATCH_RULES_VL

1220: l(' END IF;');
1221:
1222: FIRST := TRUE;
1223: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
1224: FROM HZ_MATCH_RULES_VL
1225: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
1226: AND (nvl(COMPILATION_FLAG,'N') = 'C'
1227: OR MATCH_RULE_ID = p_rule_id)) LOOP
1228: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 1267: l(' FROM HZ_MATCH_RULES_VL ');

1263: l(' x_msg_data OUT VARCHAR2');
1264: l(') IS');
1265: l(' CURSOR c_match_rule IS ');
1266: l(' SELECT COMPILATION_FLAG ');
1267: l(' FROM HZ_MATCH_RULES_VL ');
1268: l(' WHERE MATCH_RULE_ID = p_rule_id;');
1269: l(' l_cmp_flag VARCHAR2(1);');
1270: l(' BEGIN');
1271:

Line 1303: FROM HZ_MATCH_RULES_VL

1299: l(' END IF;');
1300:
1301: FIRST := TRUE;
1302: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
1303: FROM HZ_MATCH_RULES_VL
1304: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
1305: AND (nvl(COMPILATION_FLAG,'N') = 'C'
1306: OR MATCH_RULE_ID = p_rule_id)) LOOP
1307: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 1346: l(' FROM HZ_MATCH_RULES_VL ');

1342: l(' x_msg_data OUT VARCHAR2');
1343: l(') IS');
1344: l(' CURSOR c_match_rule IS ');
1345: l(' SELECT COMPILATION_FLAG ');
1346: l(' FROM HZ_MATCH_RULES_VL ');
1347: l(' WHERE MATCH_RULE_ID = p_rule_id;');
1348: l(' l_cmp_flag VARCHAR2(1);');
1349: l(' BEGIN');
1350:

Line 1382: FROM HZ_MATCH_RULES_VL

1378: l(' END IF;');
1379:
1380: FIRST := TRUE;
1381: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
1382: FROM HZ_MATCH_RULES_VL
1383: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
1384: AND (nvl(COMPILATION_FLAG,'N') = 'C'
1385: OR MATCH_RULE_ID = p_rule_id)) LOOP
1386: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 1464: l(' FROM HZ_MATCH_RULES_VL ');

1460: l(' x_msg_data OUT VARCHAR2');
1461: l(') IS');
1462: l(' CURSOR c_match_rule IS ');
1463: l(' SELECT COMPILATION_FLAG ');
1464: l(' FROM HZ_MATCH_RULES_VL ');
1465: l(' WHERE MATCH_RULE_ID = p_rule_id;');
1466: l(' l_cmp_flag VARCHAR2(1);');
1467: l(' BEGIN');
1468:

Line 1500: FROM HZ_MATCH_RULES_VL

1496: l(' END IF;');
1497:
1498: FIRST := TRUE;
1499: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
1500: FROM HZ_MATCH_RULES_VL
1501: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
1502: AND (nvl(COMPILATION_FLAG,'N') = 'C'
1503: OR MATCH_RULE_ID = p_rule_id)) LOOP
1504: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 1591: l(' FROM HZ_MATCH_RULES_VL ');

1587: l(' x_msg_data OUT VARCHAR2');
1588: l(') IS');
1589: l(' CURSOR c_match_rule IS ');
1590: l(' SELECT COMPILATION_FLAG ');
1591: l(' FROM HZ_MATCH_RULES_VL ');
1592: l(' WHERE MATCH_RULE_ID = p_rule_id;');
1593: l(' l_cmp_flag VARCHAR2(1);');
1594: l(' BEGIN');
1595:

Line 1633: FROM HZ_MATCH_RULES_VL

1629:
1630:
1631: FIRST := TRUE;
1632: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
1633: FROM HZ_MATCH_RULES_VL
1634: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
1635: AND (nvl(COMPILATION_FLAG,'N') = 'C'
1636: OR MATCH_RULE_ID = p_rule_id)) LOOP
1637: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 1721: l(' FROM HZ_MATCH_RULES_VL ');

1717: l(' x_msg_data OUT VARCHAR2');
1718: l(') IS');
1719: l(' CURSOR c_match_rule IS ');
1720: l(' SELECT COMPILATION_FLAG ');
1721: l(' FROM HZ_MATCH_RULES_VL ');
1722: l(' WHERE MATCH_RULE_ID = p_rule_id;');
1723: l(' l_cmp_flag VARCHAR2(1);');
1724: l(' BEGIN');
1725:

Line 1755: FROM HZ_MATCH_RULES_VL

1751: l(' END IF;');
1752:
1753: FIRST := TRUE;
1754: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
1755: FROM HZ_MATCH_RULES_VL
1756: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
1757: AND (nvl(COMPILATION_FLAG,'N') = 'C'
1758: OR MATCH_RULE_ID = p_rule_id)) LOOP
1759: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 1824: l(' FROM HZ_MATCH_RULES_VL ');

1820: l(' x_msg_data OUT VARCHAR2');
1821: l(') IS');
1822: l(' CURSOR c_match_rule IS ');
1823: l(' SELECT COMPILATION_FLAG ');
1824: l(' FROM HZ_MATCH_RULES_VL ');
1825: l(' WHERE MATCH_RULE_ID = p_rule_id;');
1826: l(' l_cmp_flag VARCHAR2(1);');
1827: l(' BEGIN');
1828:

Line 1858: FROM HZ_MATCH_RULES_VL

1854: l(' END IF;');
1855:
1856: FIRST := TRUE;
1857: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
1858: FROM HZ_MATCH_RULES_VL
1859: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
1860: AND (nvl(COMPILATION_FLAG,'N') = 'C'
1861: OR MATCH_RULE_ID = p_rule_id)) LOOP
1862: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 1924: l(' FROM HZ_MATCH_RULES_VL ');

1920: l(' x_msg_data OUT VARCHAR2');
1921: l(') IS');
1922: l(' CURSOR c_match_rule IS ');
1923: l(' SELECT COMPILATION_FLAG ');
1924: l(' FROM HZ_MATCH_RULES_VL ');
1925: l(' WHERE MATCH_RULE_ID = p_rule_id;');
1926: l(' l_cmp_flag VARCHAR2(1);');
1927: l(' BEGIN');
1928:

Line 1957: FROM HZ_MATCH_RULES_VL

1953: l(' END IF;');
1954:
1955: FIRST := TRUE;
1956: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
1957: FROM HZ_MATCH_RULES_VL
1958: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
1959: AND (nvl(COMPILATION_FLAG,'N') = 'C'
1960: OR MATCH_RULE_ID = p_rule_id)) LOOP
1961: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 2028: l(' FROM HZ_MATCH_RULES_VL ');

2024: l(' x_msg_data OUT VARCHAR2');
2025: l(') IS');
2026: l(' CURSOR c_match_rule IS ');
2027: l(' SELECT COMPILATION_FLAG ');
2028: l(' FROM HZ_MATCH_RULES_VL ');
2029: l(' WHERE MATCH_RULE_ID = p_rule_id;');
2030: l(' l_cmp_flag VARCHAR2(1);');
2031: l(' BEGIN');
2032:

Line 2062: FROM HZ_MATCH_RULES_VL

2058: l(' END IF;');
2059:
2060: FIRST := TRUE;
2061: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
2062: FROM HZ_MATCH_RULES_VL
2063: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
2064: AND (nvl(COMPILATION_FLAG,'N') = 'C'
2065: OR MATCH_RULE_ID = p_rule_id)) LOOP
2066: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 2102: l(' FROM HZ_MATCH_RULES_VL ');

2098: l(' x_msg_data OUT VARCHAR2');
2099: l(') IS');
2100: l(' CURSOR c_match_rule IS ');
2101: l(' SELECT COMPILATION_FLAG ');
2102: l(' FROM HZ_MATCH_RULES_VL ');
2103: l(' WHERE MATCH_RULE_ID = p_rule_id;');
2104: l(' l_cmp_flag VARCHAR2(1);');
2105: l(' BEGIN');
2106:

Line 2135: FROM HZ_MATCH_RULES_VL

2131: l(' END IF;');
2132:
2133: FIRST := TRUE;
2134: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
2135: FROM HZ_MATCH_RULES_VL
2136: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
2137: AND (nvl(COMPILATION_FLAG,'N') = 'C'
2138: OR MATCH_RULE_ID = p_rule_id)) LOOP
2139: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 2178: l(' FROM HZ_MATCH_RULES_VL ');

2174: l(' x_msg_data OUT VARCHAR2');
2175: l(') IS');
2176: l(' CURSOR c_match_rule IS ');
2177: l(' SELECT COMPILATION_FLAG ');
2178: l(' FROM HZ_MATCH_RULES_VL ');
2179: l(' WHERE MATCH_RULE_ID = p_rule_id;');
2180: l(' l_cmp_flag VARCHAR2(1);');
2181: l(' BEGIN');
2182:

Line 2210: FROM HZ_MATCH_RULES_VL

2206: l(' END IF;');
2207:
2208: FIRST := TRUE;
2209: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME
2210: FROM HZ_MATCH_RULES_VL
2211: WHERE nvl(ACTIVE_FLAG,'Y')='Y'
2212: AND (nvl(COMPILATION_FLAG,'N') = 'C'
2213: OR MATCH_RULE_ID = p_rule_id)) LOOP
2214: l(' -- Code for Match rule '||RULE.RULE_NAME);

Line 2942: FROM HZ_MATCH_RULES_VL

2938: -- Query match thresholds and search type
2939: SELECT RULE_PURPOSE, MATCH_SCORE, nvl(AUTO_MERGE_SCORE,99999), decode(MATCH_ALL_FLAG,'Y',' AND ',' OR '),
2940: NVL(match_rule_type,'SINGLE') ---Code Change for Match Rule Set
2941: INTO l_purpose, l_match_threshold, l_auto_merge_score, l_match_str,l_rule_type---Code Change for Match Rule Set
2942: FROM HZ_MATCH_RULES_VL
2943: WHERE match_rule_id = p_rule_id;
2944:
2945: SELECT nvl(SUM(SCORE),1) INTO l_max_score
2946: FROM HZ_MATCH_RULE_SECONDARY

Line 8784: FROM HZ_MATCH_RULES_VL

8780:
8781: -- Query match thresholds and search type
8782: SELECT RULE_PURPOSE, MATCH_SCORE, nvl(AUTO_MERGE_SCORE,99999), decode(MATCH_ALL_FLAG,'Y',' AND ',' OR ')
8783: INTO l_purpose, l_match_threshold, l_auto_merge_score, l_match_str
8784: FROM HZ_MATCH_RULES_VL
8785: WHERE match_rule_id = p_rule_id;
8786:
8787: SELECT nvl(SUM(SCORE),1) INTO l_max_score
8788: FROM HZ_MATCH_RULE_SECONDARY

Line 15143: SELECT nvl(match_rule_type,'SINGLE') into l_rule_type FROM HZ_MATCH_RULES_VL

15139: FIRST BOOLEAN := FALSE;
15140: l_rule_type varchar2(30); ---Code Change for Match Rule Set
15141: BEGIN
15142: ---Start of Code Change for Match Rule Set
15143: SELECT nvl(match_rule_type,'SINGLE') into l_rule_type FROM HZ_MATCH_RULES_VL
15144: WHERE match_rule_id = p_rule_id;
15145: ---End of Code Change for Match Rule Set
15146:
15147: l('FUNCTION check_staged RETURN BOOLEAN IS');

Line 15635: SELECT MATCH_RULE_ID,RULE_NAME FROM HZ_MATCH_RULES_VL

15631: l_msg_count number(15) := 0;
15632: l_msg_data varchar2(4000) := null;
15633:
15634: CURSOR c_rules_for_compile IS
15635: SELECT MATCH_RULE_ID,RULE_NAME FROM HZ_MATCH_RULES_VL
15636: where rule_purpose = p_rule_purpose ;
15637:
15638: l_cur_date DATE;
15639:

Line 15698: SELECT MATCH_RULE_ID,RULE_NAME FROM HZ_MATCH_RULES_VL ORDER BY match_rule_type DESC nulls first;--bug 5263694

15694: l_msg_count number(15) := 0;
15695: l_msg_data varchar2(4000) := null;
15696:
15697: CURSOR c_rules_for_compile IS
15698: SELECT MATCH_RULE_ID,RULE_NAME FROM HZ_MATCH_RULES_VL ORDER BY match_rule_type DESC nulls first;--bug 5263694
15699:
15700: l_cur_date DATE;
15701:
15702: l_match_rule_id NUMBER;

Line 16050: SELECT UNIQUE MATCH_RULE_ID,RULE_NAME FROM HZ_MATCH_RULES_VL

16046: l_msg_count number(15) := 0;
16047: l_msg_data varchar2(4000) := null;
16048:
16049: CURSOR c_rulesets_for_compile IS
16050: SELECT UNIQUE MATCH_RULE_ID,RULE_NAME FROM HZ_MATCH_RULES_VL
16051: WHERE COMPILATION_FLAG <> 'C'
16052: AND MATCH_RULE_ID IN (SELECT UNIQUE MATCH_RULE_SET_ID FROM HZ_MATCH_RULE_CONDITIONS
16053: WHERE CONDITION_MATCH_RULE_ID = p_cond_rule_id)
16054: ;

Line 16182: l(' CURSOR c_rule_name(p_rule_id NUMBER) IS SELECT rule_name FROM hz_match_rules_vl ');

16178: --Start of Bug No: 4234203
16179: l('DECLARE');
16180: l(' l_condition_match_rule_id NUMBER(15);');
16181: l(' l_cond_rule_name VARCHAR2(255);');
16182: l(' CURSOR c_rule_name(p_rule_id NUMBER) IS SELECT rule_name FROM hz_match_rules_vl ');
16183: l(' where match_rule_id=p_rule_id ;');
16184: l('BEGIN');
16185: --End of Bug No: 4234203
16186: OPEN c_ref_conditions FOR l_sql;