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

Line 1186: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1182: 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);
1183: END IF;
1184: OPEN x_cursor FOR
1185: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44
1186: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1187: WHERE contains( concat_col, p_contains_str)>0
1188: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1189: AND d.party_id = stage.party_id
1190: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1345: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1341: END IF;
1342: IF p_person_api = 'Y' THEN
1343: OPEN x_cursor FOR
1344: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1345: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1346: WHERE contains( concat_col, p_contains_str)>0
1347: AND( (l_search_merged ='Y' )
1348: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1349: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1351: AND d.party_id = stage.party_id
1352: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1353: UNION
1354: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX3
1355: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1356: WHERE contains( concat_col, p_contains_str)>0
1357: AND( (l_search_merged ='Y' )
1358: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1359: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1368: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1364: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1365: ELSE
1366: OPEN x_cursor FOR
1367: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1368: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1369: WHERE contains( concat_col, p_contains_str)>0
1370: AND( (l_search_merged ='Y' )
1371: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1372: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1569: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1565: 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);
1566: END IF;
1567: OPEN x_cursor FOR
1568: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1569: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1570: WHERE contains( concat_col, p_contains_str)>0
1571: AND d.search_context_id = p_search_ctx_id
1572: AND d.party_id = stage.party_id
1573: AND( (l_search_merged ='Y' )

Line 1676: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1672: IF p_restrict_entity = 'CONTACTS'
1673: THEN
1674: OPEN x_cursor FOR
1675: 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
1676: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1677: WHERE contains( concat_col, p_contains_str)>0
1678: AND d.search_context_id = p_search_ctx_id
1679: AND( (l_search_merged ='Y' )
1680: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1688: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1684: IF p_restrict_entity = 'PARTY_SITES'
1685: THEN
1686: OPEN x_cursor FOR
1687: 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
1688: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1689: WHERE contains( concat_col, p_contains_str)>0
1690: AND d.search_context_id = p_search_ctx_id
1691: AND( (l_search_merged ='Y' )
1692: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1764: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1760: END IF;
1761: IF p_person_api = 'Y' THEN
1762: OPEN x_cursor FOR
1763: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1764: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1765: WHERE contains( concat_col, p_contains_str)>0
1766: AND d.search_context_id = p_search_ctx_id
1767: AND d.party_id = stage.party_id
1768: AND( (l_search_merged ='Y' )

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

1770: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1771: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1772: UNION
1773: 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
1774: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1775: WHERE contains( concat_col, p_contains_str)>0
1776: AND d.search_context_id = p_search_ctx_id
1777: AND d.party_id = r.subject_id
1778: AND r.relationship_id = oc.party_relationship_id

Line 1787: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1783: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1784: ELSE
1785: OPEN x_cursor FOR
1786: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1787: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1788: WHERE contains( concat_col, p_contains_str)>0
1789: AND d.search_context_id = p_search_ctx_id
1790: AND d.party_id = stage.party_id
1791: AND( (l_search_merged ='Y' )

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

2116: SAVEPOINT eval_start;
2117: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2118: l_ctx_id := l_search_ctx_id;
2119: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2120: 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);
2121: END IF;
2122: FORALL I in 1..H_PARTY_ID.COUNT
2123: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2124: l_search_ctx_id,H_PARTY_ID(I));

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

2119: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2120: 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);
2121: END IF;
2122: FORALL I in 1..H_PARTY_ID.COUNT
2123: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2124: l_search_ctx_id,H_PARTY_ID(I));
2125: H_PARTY_ID.DELETE;
2126: H_PARTY_ID_LIST.DELETE;
2127: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2125: H_PARTY_ID.DELETE;
2126: H_PARTY_ID_LIST.DELETE;
2127: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2128: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2129: 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);
2130: END IF;
2131: l_ctx_id := l_search_ctx_id;
2132: FORALL I in 1..H_PARTY_ID.COUNT
2133: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2129: 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);
2130: END IF;
2131: l_ctx_id := l_search_ctx_id;
2132: FORALL I in 1..H_PARTY_ID.COUNT
2133: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2134: l_search_ctx_id,H_PARTY_ID(I));
2135: l_party_id_idx := H_PARTY_ID.COUNT+1;
2136: ELSE
2137: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2249: END IF;
2250: SAVEPOINT eval_start;
2251: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2252: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2253: 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);
2254: END IF;
2255: l_ctx_id := l_search_ctx_id;
2256: FORALL I in 1..H_PARTY_ID.COUNT
2257: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2253: 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);
2254: END IF;
2255: l_ctx_id := l_search_ctx_id;
2256: FORALL I in 1..H_PARTY_ID.COUNT
2257: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2258: l_search_ctx_id,H_PARTY_ID(I));
2259: H_PARTY_ID.DELETE;
2260: H_PARTY_ID_LIST.DELETE;
2261: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2259: H_PARTY_ID.DELETE;
2260: H_PARTY_ID_LIST.DELETE;
2261: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2262: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2263: 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);
2264: END IF;
2265: l_ctx_id := l_search_ctx_id;
2266: FORALL I in 1..H_PARTY_ID.COUNT
2267: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2263: 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);
2264: END IF;
2265: l_ctx_id := l_search_ctx_id;
2266: FORALL I in 1..H_PARTY_ID.COUNT
2267: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2268: l_search_ctx_id,H_PARTY_ID(I));
2269: l_party_id_idx := H_PARTY_ID.COUNT+1;
2270: ELSE
2271: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2361: END IF;
2362: SAVEPOINT eval_start;
2363: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2364: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2365: 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);
2366: END IF;
2367: l_ctx_id := l_search_ctx_id;
2368: FORALL I in 1..H_PARTY_ID.COUNT
2369: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2365: 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);
2366: END IF;
2367: l_ctx_id := l_search_ctx_id;
2368: FORALL I in 1..H_PARTY_ID.COUNT
2369: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2370: l_search_ctx_id,H_PARTY_ID(I));
2371: H_PARTY_ID.DELETE;
2372: H_PARTY_ID_LIST.DELETE;
2373: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2371: H_PARTY_ID.DELETE;
2372: H_PARTY_ID_LIST.DELETE;
2373: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2374: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2375: 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);
2376: END IF;
2377: l_ctx_id := l_search_ctx_id;
2378: FORALL I in 1..H_PARTY_ID.COUNT
2379: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2375: 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);
2376: END IF;
2377: l_ctx_id := l_search_ctx_id;
2378: FORALL I in 1..H_PARTY_ID.COUNT
2379: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2380: l_search_ctx_id,H_PARTY_ID(I));
2381: l_party_id_idx := H_PARTY_ID.COUNT+1;
2382: ELSE
2383: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2472: END IF;
2473: SAVEPOINT eval_start;
2474: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2475: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2476: 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);
2477: END IF;
2478: l_ctx_id := l_search_ctx_id;
2479: FORALL I in 1..H_PARTY_ID.COUNT
2480: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2476: 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);
2477: END IF;
2478: l_ctx_id := l_search_ctx_id;
2479: FORALL I in 1..H_PARTY_ID.COUNT
2480: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2481: l_search_ctx_id,H_PARTY_ID(I));
2482: H_PARTY_ID.DELETE;
2483: H_PARTY_ID_LIST.DELETE;
2484: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2482: H_PARTY_ID.DELETE;
2483: H_PARTY_ID_LIST.DELETE;
2484: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2486: 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);
2487: END IF;
2488: l_ctx_id := l_search_ctx_id;
2489: FORALL I in 1..H_PARTY_ID.COUNT
2490: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2486: 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);
2487: END IF;
2488: l_ctx_id := l_search_ctx_id;
2489: FORALL I in 1..H_PARTY_ID.COUNT
2490: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2491: l_search_ctx_id,H_PARTY_ID(I));
2492: l_party_id_idx := H_PARTY_ID.COUNT+1;
2493: ELSE
2494: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3096: set_person_party_type;
3097: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3098: l_ctx_id := l_search_ctx_id;
3099: FORALL I in 1..H_PARTY_ID.COUNT
3100: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3101: l_search_ctx_id,H_PARTY_ID(I));
3102: H_PARTY_ID.DELETE;
3103: H_PARTY_ID_LIST.DELETE;
3104: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3103: H_PARTY_ID_LIST.DELETE;
3104: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3105: l_ctx_id := l_search_ctx_id;
3106: FORALL I in 1..H_PARTY_ID.COUNT
3107: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3108: l_search_ctx_id,H_PARTY_ID(I));
3109: l_party_id_idx := H_PARTY_ID.COUNT+1;
3110: ELSE
3111: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3204: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3205: FROM HZ_STAGED_CONTACTS stage
3206: WHERE contains( concat_col, p_contains_str)>0
3207: AND ORG_CONTACT_ID in (
3208: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3209: org_contact_id
3210: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3211: where d.party_id = r.subject_id
3212: and oc.party_relationship_id = r.relationship_id

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

3206: WHERE contains( concat_col, p_contains_str)>0
3207: AND ORG_CONTACT_ID in (
3208: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3209: org_contact_id
3210: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3211: where d.party_id = r.subject_id
3212: and oc.party_relationship_id = r.relationship_id
3213: and d.search_context_id = p_search_ctx_id);
3214: exception

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

3240: unset_person_party_type;
3241: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3242: l_ctx_id := l_search_ctx_id;
3243: FORALL I in 1..H_PARTY_ID.COUNT
3244: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3245: l_search_ctx_id,H_PARTY_ID(I));
3246: H_PARTY_ID.DELETE;
3247: H_PARTY_ID_LIST.DELETE;
3248: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3247: H_PARTY_ID_LIST.DELETE;
3248: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3249: l_ctx_id := l_search_ctx_id;
3250: FORALL I in 1..H_PARTY_ID.COUNT
3251: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3252: l_search_ctx_id,H_PARTY_ID(I));
3253: l_party_id_idx := H_PARTY_ID.COUNT+1;
3254: ELSE
3255: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3338: SAVEPOINT eval_start;
3339: l_ctx_id := l_search_ctx_id;
3340: unset_person_party_type;
3341: FORALL I in 1..H_PARTY_ID.COUNT
3342: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3343: l_search_ctx_id,H_PARTY_ID(I));
3344: l_party_id_idx := H_PARTY_ID.COUNT+1;
3345: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3346: LOOP

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

3405: unset_person_party_type;
3406: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3407: l_ctx_id := l_search_ctx_id;
3408: FORALL I in 1..H_PARTY_ID.COUNT
3409: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3410: l_search_ctx_id,H_PARTY_ID(I));
3411: H_PARTY_ID.DELETE;
3412: H_PARTY_ID_LIST.DELETE;
3413: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3411: H_PARTY_ID.DELETE;
3412: H_PARTY_ID_LIST.DELETE;
3413: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3414: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3415: 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);
3416: END IF;
3417: l_ctx_id := l_search_ctx_id;
3418: FORALL I in 1..H_PARTY_ID.COUNT
3419: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3415: 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);
3416: END IF;
3417: l_ctx_id := l_search_ctx_id;
3418: FORALL I in 1..H_PARTY_ID.COUNT
3419: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3420: l_search_ctx_id,H_PARTY_ID(I));
3421: l_party_id_idx := H_PARTY_ID.COUNT+1;
3422: ELSE
3423: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3420: l_search_ctx_id,H_PARTY_ID(I));
3421: l_party_id_idx := H_PARTY_ID.COUNT+1;
3422: ELSE
3423: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3424: 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);
3425: END IF;
3426: l_ctx_id := NULL;
3427: l_party_id_idx := H_PARTY_ID.COUNT+1;
3428: END IF;

Line 4651: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4647: IF l_match_str = ' AND ' OR (
4648: ((l_cpt_max_score/l_entered_max_score)<(80/250))
4649: ) THEN
4650: FORALL I in 1..l_match_ps_list.COUNT
4651: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4652: values (l_search_ctx_id,l_match_ps_list(I));
4653: 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');
4654: ELSE
4655: 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 4878: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4874: IF l_match_str = ' AND ' OR (
4875: ((l_cpt_max_score/l_entered_max_score)<(80/250))
4876: ) THEN
4877: FORALL I in 1..l_match_contact_list.COUNT
4878: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4879: values (l_search_ctx_id,l_match_contact_list(I));
4880: 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');
4881: ELSE
4882: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);