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

Line 1194: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1190: 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);
1191: END IF;
1192: OPEN x_cursor FOR
1193: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX39, lpad(rtrim(TX41),9,chr(48)), TX44
1194: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1195: WHERE contains( concat_col, p_contains_str)>0
1196: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1197: AND d.party_id = stage.party_id
1198: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1353: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1349: END IF;
1350: IF p_person_api = 'Y' THEN
1351: OPEN x_cursor FOR
1352: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3
1353: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1354: WHERE contains( concat_col, p_contains_str)>0
1355: AND( (l_search_merged ='Y' )
1356: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1357: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1359: AND d.party_id = stage.party_id
1360: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1361: UNION
1362: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3
1363: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1364: WHERE contains( concat_col, p_contains_str)>0
1365: AND( (l_search_merged ='Y' )
1366: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1367: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1376: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1372: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1373: ELSE
1374: OPEN x_cursor FOR
1375: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3
1376: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1377: WHERE contains( concat_col, p_contains_str)>0
1378: AND( (l_search_merged ='Y' )
1379: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1380: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1577: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 1684: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1696: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1692: IF p_restrict_entity = 'PARTY_SITES'
1693: THEN
1694: OPEN x_cursor FOR
1695: 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
1696: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1697: WHERE contains( concat_col, p_contains_str)>0
1698: AND d.search_context_id = p_search_ctx_id
1699: AND( (l_search_merged ='Y' )
1700: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1772: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1768: END IF;
1769: IF p_person_api = 'Y' THEN
1770: OPEN x_cursor FOR
1771: 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
1772: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1773: WHERE contains( concat_col, p_contains_str)>0
1774: AND d.search_context_id = p_search_ctx_id
1775: AND d.party_id = stage.party_id
1776: AND( (l_search_merged ='Y' )

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

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

Line 1795: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1791: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1792: ELSE
1793: OPEN x_cursor FOR
1794: 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
1795: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1796: WHERE contains( concat_col, p_contains_str)>0
1797: AND d.search_context_id = p_search_ctx_id
1798: AND d.party_id = stage.party_id
1799: AND( (l_search_merged ='Y' )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3062: set_person_party_type;
3063: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3064: l_ctx_id := l_search_ctx_id;
3065: FORALL I in 1..H_PARTY_ID.COUNT
3066: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3067: l_search_ctx_id,H_PARTY_ID(I));
3068: H_PARTY_ID.DELETE;
3069: H_PARTY_ID_LIST.DELETE;
3070: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3069: H_PARTY_ID_LIST.DELETE;
3070: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3071: l_ctx_id := l_search_ctx_id;
3072: FORALL I in 1..H_PARTY_ID.COUNT
3073: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3074: l_search_ctx_id,H_PARTY_ID(I));
3075: l_party_id_idx := H_PARTY_ID.COUNT+1;
3076: ELSE
3077: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3170: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3171: FROM HZ_STAGED_CONTACTS stage
3172: WHERE contains( concat_col, p_contains_str)>0
3173: AND ORG_CONTACT_ID in (
3174: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3175: org_contact_id
3176: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3177: where d.party_id = r.subject_id
3178: and oc.party_relationship_id = r.relationship_id

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

3172: WHERE contains( concat_col, p_contains_str)>0
3173: AND ORG_CONTACT_ID in (
3174: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3175: org_contact_id
3176: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3177: where d.party_id = r.subject_id
3178: and oc.party_relationship_id = r.relationship_id
3179: and d.search_context_id = p_search_ctx_id);
3180: exception

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

3206: unset_person_party_type;
3207: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3208: l_ctx_id := l_search_ctx_id;
3209: FORALL I in 1..H_PARTY_ID.COUNT
3210: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3211: l_search_ctx_id,H_PARTY_ID(I));
3212: H_PARTY_ID.DELETE;
3213: H_PARTY_ID_LIST.DELETE;
3214: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3213: H_PARTY_ID_LIST.DELETE;
3214: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3215: l_ctx_id := l_search_ctx_id;
3216: FORALL I in 1..H_PARTY_ID.COUNT
3217: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3218: l_search_ctx_id,H_PARTY_ID(I));
3219: l_party_id_idx := H_PARTY_ID.COUNT+1;
3220: ELSE
3221: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3304: SAVEPOINT eval_start;
3305: l_ctx_id := l_search_ctx_id;
3306: unset_person_party_type;
3307: FORALL I in 1..H_PARTY_ID.COUNT
3308: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3309: l_search_ctx_id,H_PARTY_ID(I));
3310: l_party_id_idx := H_PARTY_ID.COUNT+1;
3311: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3312: LOOP

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

3371: unset_person_party_type;
3372: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3373: l_ctx_id := l_search_ctx_id;
3374: FORALL I in 1..H_PARTY_ID.COUNT
3375: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3376: l_search_ctx_id,H_PARTY_ID(I));
3377: H_PARTY_ID.DELETE;
3378: H_PARTY_ID_LIST.DELETE;
3379: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3377: H_PARTY_ID.DELETE;
3378: H_PARTY_ID_LIST.DELETE;
3379: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3380: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3381: 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);
3382: END IF;
3383: l_ctx_id := l_search_ctx_id;
3384: FORALL I in 1..H_PARTY_ID.COUNT
3385: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3381: 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);
3382: END IF;
3383: l_ctx_id := l_search_ctx_id;
3384: FORALL I in 1..H_PARTY_ID.COUNT
3385: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3386: l_search_ctx_id,H_PARTY_ID(I));
3387: l_party_id_idx := H_PARTY_ID.COUNT+1;
3388: ELSE
3389: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3386: l_search_ctx_id,H_PARTY_ID(I));
3387: l_party_id_idx := H_PARTY_ID.COUNT+1;
3388: ELSE
3389: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3390: 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);
3391: END IF;
3392: l_ctx_id := NULL;
3393: l_party_id_idx := H_PARTY_ID.COUNT+1;
3394: END IF;

Line 4540: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4536: IF l_match_str = ' AND ' OR (
4537: ((l_cpt_max_score/l_entered_max_score)<(20/78))
4538: ) THEN
4539: FORALL I in 1..l_match_ps_list.COUNT
4540: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4541: values (l_search_ctx_id,l_match_ps_list(I));
4542: 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');
4543: ELSE
4544: 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 4767: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4763: IF l_match_str = ' AND ' OR (
4764: ((l_cpt_max_score/l_entered_max_score)<(20/78))
4765: ) THEN
4766: FORALL I in 1..l_match_contact_list.COUNT
4767: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4768: values (l_search_ctx_id,l_match_contact_list(I));
4769: 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');
4770: ELSE
4771: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);