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 1347: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1370: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 1571: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 1678: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1690: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1766: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 1789: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4655: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

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

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