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

Line 1201: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1197: 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);
1198: END IF;
1199: OPEN x_cursor FOR
1200: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX2, TX4, TX8, lpad(rtrim(TX41),9,chr(48)), TX44
1201: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1202: WHERE contains( concat_col, p_contains_str)>0
1203: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1204: AND d.party_id = stage.party_id
1205: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1360: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1356: END IF;
1357: IF p_person_api = 'Y' THEN
1358: OPEN x_cursor FOR
1359: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1360: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1361: WHERE contains( concat_col, p_contains_str)>0
1362: AND( (l_search_merged ='Y' )
1363: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1364: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1366: AND d.party_id = stage.party_id
1367: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1368: UNION
1369: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX3
1370: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, 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 1383: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1379: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1380: ELSE
1381: OPEN x_cursor FOR
1382: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1383: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1384: WHERE contains( concat_col, p_contains_str)>0
1385: AND( (l_search_merged ='Y' )
1386: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1387: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1584: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 1691: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1703: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1779: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1775: END IF;
1776: IF p_person_api = 'Y' THEN
1777: OPEN x_cursor FOR
1778: 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
1779: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1780: WHERE contains( concat_col, p_contains_str)>0
1781: AND d.search_context_id = p_search_ctx_id
1782: AND d.party_id = stage.party_id
1783: AND( (l_search_merged ='Y' )

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

1785: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1786: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1787: UNION
1788: 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
1789: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, 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 = r.subject_id
1793: AND r.relationship_id = oc.party_relationship_id

Line 1802: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1798: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1799: ELSE
1800: OPEN x_cursor FOR
1801: 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
1802: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1803: WHERE contains( concat_col, p_contains_str)>0
1804: AND d.search_context_id = p_search_ctx_id
1805: AND d.party_id = stage.party_id
1806: AND( (l_search_merged ='Y' )

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

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

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

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

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

2140: H_PARTY_ID.DELETE;
2141: H_PARTY_ID_LIST.DELETE;
2142: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2143: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2144: 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);
2145: END IF;
2146: l_ctx_id := l_search_ctx_id;
2147: FORALL I in 1..H_PARTY_ID.COUNT
2148: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2144: 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);
2145: END IF;
2146: l_ctx_id := l_search_ctx_id;
2147: FORALL I in 1..H_PARTY_ID.COUNT
2148: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2149: l_search_ctx_id,H_PARTY_ID(I));
2150: l_party_id_idx := H_PARTY_ID.COUNT+1;
2151: ELSE
2152: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

2274: H_PARTY_ID.DELETE;
2275: H_PARTY_ID_LIST.DELETE;
2276: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2277: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2278: 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);
2279: END IF;
2280: l_ctx_id := l_search_ctx_id;
2281: FORALL I in 1..H_PARTY_ID.COUNT
2282: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2278: 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);
2279: END IF;
2280: l_ctx_id := l_search_ctx_id;
2281: FORALL I in 1..H_PARTY_ID.COUNT
2282: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2283: l_search_ctx_id,H_PARTY_ID(I));
2284: l_party_id_idx := H_PARTY_ID.COUNT+1;
2285: ELSE
2286: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

2386: H_PARTY_ID.DELETE;
2387: H_PARTY_ID_LIST.DELETE;
2388: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2389: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2390: 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);
2391: END IF;
2392: l_ctx_id := l_search_ctx_id;
2393: FORALL I in 1..H_PARTY_ID.COUNT
2394: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2390: 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);
2391: END IF;
2392: l_ctx_id := l_search_ctx_id;
2393: FORALL I in 1..H_PARTY_ID.COUNT
2394: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2395: l_search_ctx_id,H_PARTY_ID(I));
2396: l_party_id_idx := H_PARTY_ID.COUNT+1;
2397: ELSE
2398: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

2497: H_PARTY_ID.DELETE;
2498: H_PARTY_ID_LIST.DELETE;
2499: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2500: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2501: 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);
2502: END IF;
2503: l_ctx_id := l_search_ctx_id;
2504: FORALL I in 1..H_PARTY_ID.COUNT
2505: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2501: 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);
2502: END IF;
2503: l_ctx_id := l_search_ctx_id;
2504: FORALL I in 1..H_PARTY_ID.COUNT
2505: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2506: l_search_ctx_id,H_PARTY_ID(I));
2507: l_party_id_idx := H_PARTY_ID.COUNT+1;
2508: ELSE
2509: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3073: set_person_party_type;
3074: IF l_match_str = ' AND ' 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: H_PARTY_ID.DELETE;
3080: H_PARTY_ID_LIST.DELETE;
3081: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3080: H_PARTY_ID_LIST.DELETE;
3081: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3082: l_ctx_id := l_search_ctx_id;
3083: FORALL I in 1..H_PARTY_ID.COUNT
3084: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3085: l_search_ctx_id,H_PARTY_ID(I));
3086: l_party_id_idx := H_PARTY_ID.COUNT+1;
3087: ELSE
3088: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3181: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3182: FROM HZ_STAGED_CONTACTS stage
3183: WHERE contains( concat_col, p_contains_str)>0
3184: AND ORG_CONTACT_ID in (
3185: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3186: org_contact_id
3187: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3188: where d.party_id = r.subject_id
3189: and oc.party_relationship_id = r.relationship_id

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

3183: WHERE contains( concat_col, p_contains_str)>0
3184: AND ORG_CONTACT_ID in (
3185: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3186: org_contact_id
3187: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3188: where d.party_id = r.subject_id
3189: and oc.party_relationship_id = r.relationship_id
3190: and d.search_context_id = p_search_ctx_id);
3191: exception

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

3217: unset_person_party_type;
3218: IF l_match_str = ' AND ' 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: H_PARTY_ID.DELETE;
3224: H_PARTY_ID_LIST.DELETE;
3225: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3224: H_PARTY_ID_LIST.DELETE;
3225: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3226: l_ctx_id := l_search_ctx_id;
3227: FORALL I in 1..H_PARTY_ID.COUNT
3228: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3229: l_search_ctx_id,H_PARTY_ID(I));
3230: l_party_id_idx := H_PARTY_ID.COUNT+1;
3231: ELSE
3232: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3315: SAVEPOINT eval_start;
3316: l_ctx_id := l_search_ctx_id;
3317: unset_person_party_type;
3318: FORALL I in 1..H_PARTY_ID.COUNT
3319: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3320: l_search_ctx_id,H_PARTY_ID(I));
3321: l_party_id_idx := H_PARTY_ID.COUNT+1;
3322: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3323: LOOP

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

3382: unset_person_party_type;
3383: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3384: l_ctx_id := l_search_ctx_id;
3385: FORALL I in 1..H_PARTY_ID.COUNT
3386: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3387: l_search_ctx_id,H_PARTY_ID(I));
3388: H_PARTY_ID.DELETE;
3389: H_PARTY_ID_LIST.DELETE;
3390: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3388: H_PARTY_ID.DELETE;
3389: H_PARTY_ID_LIST.DELETE;
3390: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3391: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3392: 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);
3393: END IF;
3394: l_ctx_id := l_search_ctx_id;
3395: FORALL I in 1..H_PARTY_ID.COUNT
3396: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3392: 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);
3393: END IF;
3394: l_ctx_id := l_search_ctx_id;
3395: FORALL I in 1..H_PARTY_ID.COUNT
3396: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3397: l_search_ctx_id,H_PARTY_ID(I));
3398: l_party_id_idx := H_PARTY_ID.COUNT+1;
3399: ELSE
3400: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3397: l_search_ctx_id,H_PARTY_ID(I));
3398: l_party_id_idx := H_PARTY_ID.COUNT+1;
3399: ELSE
3400: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3401: 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);
3402: END IF;
3403: l_ctx_id := NULL;
3404: l_party_id_idx := H_PARTY_ID.COUNT+1;
3405: END IF;

Line 4559: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4555: IF l_match_str = ' AND ' OR (
4556: ((l_cpt_max_score/l_entered_max_score)<(55/250))
4557: ) THEN
4558: FORALL I in 1..l_match_ps_list.COUNT
4559: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4560: values (l_search_ctx_id,l_match_ps_list(I));
4561: 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');
4562: ELSE
4563: 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 4786: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4782: IF l_match_str = ' AND ' OR (
4783: ((l_cpt_max_score/l_entered_max_score)<(55/250))
4784: ) THEN
4785: FORALL I in 1..l_match_contact_list.COUNT
4786: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4787: values (l_search_ctx_id,l_match_contact_list(I));
4788: 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');
4789: ELSE
4790: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);