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_98 dependencies on HZ_DQM_PARTIES_GT

Line 1218: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1214: hz_utility_v2pub.debug(p_message=>'Search context id is not null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1215: END IF;
1216: OPEN x_cursor FOR
1217: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX40, TX39
1218: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1219: WHERE contains( concat_col, p_contains_str)>0
1220: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1221: AND d.party_id = stage.party_id
1222: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1379: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1375: END IF;
1376: IF p_person_api = 'Y' THEN
1377: OPEN x_cursor FOR
1378: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1379: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1380: WHERE contains( concat_col, p_contains_str)>0
1381: AND( (l_search_merged ='Y' )
1382: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1383: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1389: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage

1385: AND d.party_id = stage.party_id
1386: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1387: UNION
1388: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1389: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1390: WHERE contains( concat_col, p_contains_str)>0
1391: AND( (l_search_merged ='Y' )
1392: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1393: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1402: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1398: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1399: ELSE
1400: OPEN x_cursor FOR
1401: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1402: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1403: WHERE contains( concat_col, p_contains_str)>0
1404: AND( (l_search_merged ='Y' )
1405: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1406: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1603: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1599: hz_utility_v2pub.debug(p_message=>'Search Context id is not null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1600: END IF;
1601: OPEN x_cursor FOR
1602: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX22
1603: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1604: WHERE contains( concat_col, p_contains_str)>0
1605: AND d.search_context_id = p_search_ctx_id
1606: AND d.party_id = stage.party_id
1607: AND( (l_search_merged ='Y' )

Line 1710: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1706: IF p_restrict_entity = 'CONTACTS'
1707: THEN
1708: OPEN x_cursor FOR
1709: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1710: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1711: WHERE contains( concat_col, p_contains_str)>0
1712: AND d.search_context_id = p_search_ctx_id
1713: AND( (l_search_merged ='Y' )
1714: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1722: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1718: IF p_restrict_entity = 'PARTY_SITES'
1719: THEN
1720: OPEN x_cursor FOR
1721: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1722: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1723: WHERE contains( concat_col, p_contains_str)>0
1724: AND d.search_context_id = p_search_ctx_id
1725: AND( (l_search_merged ='Y' )
1726: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1798: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1794: END IF;
1795: IF p_person_api = 'Y' THEN
1796: OPEN x_cursor FOR
1797: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1798: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1799: WHERE contains( concat_col, p_contains_str)>0
1800: AND d.search_context_id = p_search_ctx_id
1801: AND d.party_id = stage.party_id
1802: AND( (l_search_merged ='Y' )

Line 1808: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage

1804: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1805: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1806: UNION
1807: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
1808: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1809: WHERE contains( concat_col, p_contains_str)>0
1810: AND d.search_context_id = p_search_ctx_id
1811: AND d.party_id = r.subject_id
1812: AND r.relationship_id = oc.party_relationship_id

Line 1821: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1817: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1818: ELSE
1819: OPEN x_cursor FOR
1820: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1821: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1822: WHERE contains( concat_col, p_contains_str)>0
1823: AND d.search_context_id = p_search_ctx_id
1824: AND d.party_id = stage.party_id
1825: AND( (l_search_merged ='Y' )

Line 2155: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2151: SAVEPOINT eval_start;
2152: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2153: l_ctx_id := l_search_ctx_id;
2154: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2155: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2156: END IF;
2157: FORALL I in 1..H_PARTY_ID.COUNT
2158: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2159: l_search_ctx_id,H_PARTY_ID(I));

Line 2158: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2154: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2155: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2156: END IF;
2157: FORALL I in 1..H_PARTY_ID.COUNT
2158: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2159: l_search_ctx_id,H_PARTY_ID(I));
2160: H_PARTY_ID.DELETE;
2161: H_PARTY_ID_LIST.DELETE;
2162: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 2164: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2160: H_PARTY_ID.DELETE;
2161: H_PARTY_ID_LIST.DELETE;
2162: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2163: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2164: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2165: END IF;
2166: l_ctx_id := l_search_ctx_id;
2167: FORALL I in 1..H_PARTY_ID.COUNT
2168: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 2168: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2164: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2165: END IF;
2166: l_ctx_id := l_search_ctx_id;
2167: FORALL I in 1..H_PARTY_ID.COUNT
2168: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2169: l_search_ctx_id,H_PARTY_ID(I));
2170: l_party_id_idx := H_PARTY_ID.COUNT+1;
2171: ELSE
2172: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

Line 2288: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2284: END IF;
2285: SAVEPOINT eval_start;
2286: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2287: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2288: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2289: END IF;
2290: l_ctx_id := l_search_ctx_id;
2291: FORALL I in 1..H_PARTY_ID.COUNT
2292: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 2292: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2288: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2289: END IF;
2290: l_ctx_id := l_search_ctx_id;
2291: FORALL I in 1..H_PARTY_ID.COUNT
2292: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2293: l_search_ctx_id,H_PARTY_ID(I));
2294: H_PARTY_ID.DELETE;
2295: H_PARTY_ID_LIST.DELETE;
2296: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 2298: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2294: H_PARTY_ID.DELETE;
2295: H_PARTY_ID_LIST.DELETE;
2296: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2297: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2298: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2299: END IF;
2300: l_ctx_id := l_search_ctx_id;
2301: FORALL I in 1..H_PARTY_ID.COUNT
2302: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 2302: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2298: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2299: END IF;
2300: l_ctx_id := l_search_ctx_id;
2301: FORALL I in 1..H_PARTY_ID.COUNT
2302: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2303: l_search_ctx_id,H_PARTY_ID(I));
2304: l_party_id_idx := H_PARTY_ID.COUNT+1;
2305: ELSE
2306: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

Line 2400: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2396: END IF;
2397: SAVEPOINT eval_start;
2398: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2399: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2400: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2401: END IF;
2402: l_ctx_id := l_search_ctx_id;
2403: FORALL I in 1..H_PARTY_ID.COUNT
2404: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 2404: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2400: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2401: END IF;
2402: l_ctx_id := l_search_ctx_id;
2403: FORALL I in 1..H_PARTY_ID.COUNT
2404: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2405: l_search_ctx_id,H_PARTY_ID(I));
2406: H_PARTY_ID.DELETE;
2407: H_PARTY_ID_LIST.DELETE;
2408: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 2410: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2406: H_PARTY_ID.DELETE;
2407: H_PARTY_ID_LIST.DELETE;
2408: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2409: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2410: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2411: END IF;
2412: l_ctx_id := l_search_ctx_id;
2413: FORALL I in 1..H_PARTY_ID.COUNT
2414: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 2414: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2410: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2411: END IF;
2412: l_ctx_id := l_search_ctx_id;
2413: FORALL I in 1..H_PARTY_ID.COUNT
2414: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2415: l_search_ctx_id,H_PARTY_ID(I));
2416: l_party_id_idx := H_PARTY_ID.COUNT+1;
2417: ELSE
2418: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

Line 2511: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2507: END IF;
2508: SAVEPOINT eval_start;
2509: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2510: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2511: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2512: END IF;
2513: l_ctx_id := l_search_ctx_id;
2514: FORALL I in 1..H_PARTY_ID.COUNT
2515: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 2515: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2511: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2512: END IF;
2513: l_ctx_id := l_search_ctx_id;
2514: FORALL I in 1..H_PARTY_ID.COUNT
2515: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2516: l_search_ctx_id,H_PARTY_ID(I));
2517: H_PARTY_ID.DELETE;
2518: H_PARTY_ID_LIST.DELETE;
2519: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 2521: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2517: H_PARTY_ID.DELETE;
2518: H_PARTY_ID_LIST.DELETE;
2519: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2520: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2521: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2522: END IF;
2523: l_ctx_id := l_search_ctx_id;
2524: FORALL I in 1..H_PARTY_ID.COUNT
2525: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 2525: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

2521: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2522: END IF;
2523: l_ctx_id := l_search_ctx_id;
2524: FORALL I in 1..H_PARTY_ID.COUNT
2525: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2526: l_search_ctx_id,H_PARTY_ID(I));
2527: l_party_id_idx := H_PARTY_ID.COUNT+1;
2528: ELSE
2529: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

Line 3136: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3132: set_person_party_type;
3133: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3134: l_ctx_id := l_search_ctx_id;
3135: FORALL I in 1..H_PARTY_ID.COUNT
3136: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3137: l_search_ctx_id,H_PARTY_ID(I));
3138: H_PARTY_ID.DELETE;
3139: H_PARTY_ID_LIST.DELETE;
3140: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 3143: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3139: H_PARTY_ID_LIST.DELETE;
3140: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3141: l_ctx_id := l_search_ctx_id;
3142: FORALL I in 1..H_PARTY_ID.COUNT
3143: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3144: l_search_ctx_id,H_PARTY_ID(I));
3145: l_party_id_idx := H_PARTY_ID.COUNT+1;
3146: ELSE
3147: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

Line 3244: SELECT /+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)/

3240: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX22
3241: FROM HZ_STAGED_CONTACTS stage
3242: WHERE contains( concat_col, p_contains_str)>0
3243: AND ORG_CONTACT_ID in (
3244: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3245: org_contact_id
3246: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3247: where d.party_id = r.subject_id
3248: and oc.party_relationship_id = r.relationship_id

Line 3246: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc

3242: WHERE contains( concat_col, p_contains_str)>0
3243: AND ORG_CONTACT_ID in (
3244: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3245: org_contact_id
3246: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3247: where d.party_id = r.subject_id
3248: and oc.party_relationship_id = r.relationship_id
3249: and d.search_context_id = p_search_ctx_id);
3250: exception

Line 3280: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3276: unset_person_party_type;
3277: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3278: l_ctx_id := l_search_ctx_id;
3279: FORALL I in 1..H_PARTY_ID.COUNT
3280: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3281: l_search_ctx_id,H_PARTY_ID(I));
3282: H_PARTY_ID.DELETE;
3283: H_PARTY_ID_LIST.DELETE;
3284: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 3287: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3283: H_PARTY_ID_LIST.DELETE;
3284: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3285: l_ctx_id := l_search_ctx_id;
3286: FORALL I in 1..H_PARTY_ID.COUNT
3287: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3288: l_search_ctx_id,H_PARTY_ID(I));
3289: l_party_id_idx := H_PARTY_ID.COUNT+1;
3290: ELSE
3291: l_party_id_idx := H_PARTY_ID.COUNT+1;

Line 3378: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3374: SAVEPOINT eval_start;
3375: l_ctx_id := l_search_ctx_id;
3376: unset_person_party_type;
3377: FORALL I in 1..H_PARTY_ID.COUNT
3378: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3379: l_search_ctx_id,H_PARTY_ID(I));
3380: l_party_id_idx := H_PARTY_ID.COUNT+1;
3381: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3382: LOOP

Line 3445: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3441: unset_person_party_type;
3442: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3443: l_ctx_id := l_search_ctx_id;
3444: FORALL I in 1..H_PARTY_ID.COUNT
3445: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3446: l_search_ctx_id,H_PARTY_ID(I));
3447: H_PARTY_ID.DELETE;
3448: H_PARTY_ID_LIST.DELETE;
3449: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

Line 3451: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

3447: H_PARTY_ID.DELETE;
3448: H_PARTY_ID_LIST.DELETE;
3449: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3450: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3451: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3452: END IF;
3453: l_ctx_id := l_search_ctx_id;
3454: FORALL I in 1..H_PARTY_ID.COUNT
3455: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

Line 3455: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3451: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3452: END IF;
3453: l_ctx_id := l_search_ctx_id;
3454: FORALL I in 1..H_PARTY_ID.COUNT
3455: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3456: l_search_ctx_id,H_PARTY_ID(I));
3457: l_party_id_idx := H_PARTY_ID.COUNT+1;
3458: ELSE
3459: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3460: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

3456: l_search_ctx_id,H_PARTY_ID(I));
3457: l_party_id_idx := H_PARTY_ID.COUNT+1;
3458: ELSE
3459: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3460: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3461: END IF;
3462: l_ctx_id := NULL;
3463: l_party_id_idx := H_PARTY_ID.COUNT+1;
3464: END IF;

Line 4708: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4704: IF l_match_str = ' AND ' OR (
4705: ((l_cpt_max_score/l_entered_max_score)<(144/180))
4706: ) THEN
4707: FORALL I in 1..l_match_ps_list.COUNT
4708: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4709: values (l_search_ctx_id,l_match_ps_list(I));
4710: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur,'PARTY_SITES');
4711: ELSE
4712: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);

Line 4939: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4935: IF l_match_str = ' AND ' OR (
4936: ((l_cpt_max_score/l_entered_max_score)<(144/180))
4937: ) THEN
4938: FORALL I in 1..l_match_contact_list.COUNT
4939: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4940: values (l_search_ctx_id,l_match_contact_list(I));
4941: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur,'CONTACTS');
4942: ELSE
4943: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);