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

1351: END IF;
1352: IF p_person_api = 'Y' THEN
1353: OPEN x_cursor FOR
1354: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3
1355: FROM HZ_DQM_PARTIES_GT d, 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 1365: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage

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

Line 1378: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 1579: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 1686: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1698: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1774: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1770: END IF;
1771: IF p_person_api = 'Y' THEN
1772: OPEN x_cursor FOR
1773: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1774: FROM HZ_DQM_PARTIES_GT d, 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 = stage.party_id
1778: AND( (l_search_merged ='Y' )

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

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

Line 1797: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1793: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1794: ELSE
1795: OPEN x_cursor FOR
1796: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1797: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1798: WHERE contains( concat_col, p_contains_str)>0
1799: AND d.search_context_id = p_search_ctx_id
1800: AND d.party_id = stage.party_id
1801: AND( (l_search_merged ='Y' )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4544: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

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

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