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

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

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

1368: AND d.party_id = stage.party_id
1369: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1370: UNION
1371: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX3
1372: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1373: WHERE contains( concat_col, p_contains_str)>0
1374: AND( (l_search_merged ='Y' )
1375: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1376: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1385: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 1586: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 1693: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1705: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1781: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1777: END IF;
1778: IF p_person_api = 'Y' THEN
1779: OPEN x_cursor FOR
1780: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1781: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1782: WHERE contains( concat_col, p_contains_str)>0
1783: AND d.search_context_id = p_search_ctx_id
1784: AND d.party_id = stage.party_id
1785: AND( (l_search_merged ='Y' )

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

1787: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1788: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1789: UNION
1790: 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
1791: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1792: WHERE contains( concat_col, p_contains_str)>0
1793: AND d.search_context_id = p_search_ctx_id
1794: AND d.party_id = r.subject_id
1795: AND r.relationship_id = oc.party_relationship_id

Line 1804: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1800: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1801: ELSE
1802: OPEN x_cursor FOR
1803: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1804: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1805: WHERE contains( concat_col, p_contains_str)>0
1806: AND d.search_context_id = p_search_ctx_id
1807: AND d.party_id = stage.party_id
1808: AND( (l_search_merged ='Y' )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3077: set_person_party_type;
3078: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3079: l_ctx_id := l_search_ctx_id;
3080: FORALL I in 1..H_PARTY_ID.COUNT
3081: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3082: l_search_ctx_id,H_PARTY_ID(I));
3083: H_PARTY_ID.DELETE;
3084: H_PARTY_ID_LIST.DELETE;
3085: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

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

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

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

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

3221: unset_person_party_type;
3222: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3223: l_ctx_id := l_search_ctx_id;
3224: FORALL I in 1..H_PARTY_ID.COUNT
3225: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3226: l_search_ctx_id,H_PARTY_ID(I));
3227: H_PARTY_ID.DELETE;
3228: H_PARTY_ID_LIST.DELETE;
3229: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

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

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

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

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

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

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

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

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

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

Line 4563: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

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

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