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

Line 1090: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1086: 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);
1087: END IF;
1088: OPEN x_cursor FOR
1089: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX2, TX8, TX4
1090: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1091: WHERE contains( concat_col, p_contains_str)>0
1092: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1093: AND d.party_id = stage.party_id
1094: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1249: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1245: END IF;
1246: IF p_person_api = 'Y' THEN
1247: OPEN x_cursor FOR
1248: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1249: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1250: WHERE contains( concat_col, p_contains_str)>0
1251: AND( (l_search_merged ='Y' )
1252: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1253: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1255: AND d.party_id = stage.party_id
1256: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1257: UNION
1258: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX3
1259: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1260: WHERE contains( concat_col, p_contains_str)>0
1261: AND( (l_search_merged ='Y' )
1262: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1263: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1272: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1268: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1269: ELSE
1270: OPEN x_cursor FOR
1271: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX3
1272: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1273: WHERE contains( concat_col, p_contains_str)>0
1274: AND( (l_search_merged ='Y' )
1275: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1276: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1473: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1469: 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);
1470: END IF;
1471: OPEN x_cursor FOR
1472: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1473: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1474: WHERE contains( concat_col, p_contains_str)>0
1475: AND d.search_context_id = p_search_ctx_id
1476: AND d.party_id = stage.party_id
1477: AND( (l_search_merged ='Y' )

Line 1580: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1576: IF p_restrict_entity = 'CONTACTS'
1577: THEN
1578: OPEN x_cursor FOR
1579: 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
1580: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1581: WHERE contains( concat_col, p_contains_str)>0
1582: AND d.search_context_id = p_search_ctx_id
1583: AND( (l_search_merged ='Y' )
1584: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1592: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1588: IF p_restrict_entity = 'PARTY_SITES'
1589: THEN
1590: OPEN x_cursor FOR
1591: 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
1592: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1593: WHERE contains( concat_col, p_contains_str)>0
1594: AND d.search_context_id = p_search_ctx_id
1595: AND( (l_search_merged ='Y' )
1596: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1668: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1664: END IF;
1665: IF p_person_api = 'Y' THEN
1666: OPEN x_cursor FOR
1667: 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
1668: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1669: WHERE contains( concat_col, p_contains_str)>0
1670: AND d.search_context_id = p_search_ctx_id
1671: AND d.party_id = stage.party_id
1672: AND( (l_search_merged ='Y' )

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

1674: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1675: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1676: UNION
1677: 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
1678: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1679: WHERE contains( concat_col, p_contains_str)>0
1680: AND d.search_context_id = p_search_ctx_id
1681: AND d.party_id = r.subject_id
1682: AND r.relationship_id = oc.party_relationship_id

Line 1691: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1687: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1688: ELSE
1689: OPEN x_cursor FOR
1690: 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
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 d.party_id = stage.party_id
1695: AND( (l_search_merged ='Y' )

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

2018: SAVEPOINT eval_start;
2019: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2020: l_ctx_id := l_search_ctx_id;
2021: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2022: 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);
2023: END IF;
2024: FORALL I in 1..H_PARTY_ID.COUNT
2025: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2026: l_search_ctx_id,H_PARTY_ID(I));

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

2021: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2022: 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);
2023: END IF;
2024: FORALL I in 1..H_PARTY_ID.COUNT
2025: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2026: l_search_ctx_id,H_PARTY_ID(I));
2027: H_PARTY_ID.DELETE;
2028: H_PARTY_ID_LIST.DELETE;
2029: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2027: H_PARTY_ID.DELETE;
2028: H_PARTY_ID_LIST.DELETE;
2029: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2030: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2031: 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);
2032: END IF;
2033: l_ctx_id := l_search_ctx_id;
2034: FORALL I in 1..H_PARTY_ID.COUNT
2035: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2031: 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);
2032: END IF;
2033: l_ctx_id := l_search_ctx_id;
2034: FORALL I in 1..H_PARTY_ID.COUNT
2035: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2036: l_search_ctx_id,H_PARTY_ID(I));
2037: l_party_id_idx := H_PARTY_ID.COUNT+1;
2038: ELSE
2039: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2151: END IF;
2152: SAVEPOINT eval_start;
2153: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2154: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2155: 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);
2156: END IF;
2157: l_ctx_id := l_search_ctx_id;
2158: FORALL I in 1..H_PARTY_ID.COUNT
2159: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2155: 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);
2156: END IF;
2157: l_ctx_id := l_search_ctx_id;
2158: FORALL I in 1..H_PARTY_ID.COUNT
2159: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2160: l_search_ctx_id,H_PARTY_ID(I));
2161: H_PARTY_ID.DELETE;
2162: H_PARTY_ID_LIST.DELETE;
2163: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2161: H_PARTY_ID.DELETE;
2162: H_PARTY_ID_LIST.DELETE;
2163: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2164: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2165: 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);
2166: END IF;
2167: l_ctx_id := l_search_ctx_id;
2168: FORALL I in 1..H_PARTY_ID.COUNT
2169: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2165: 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);
2166: END IF;
2167: l_ctx_id := l_search_ctx_id;
2168: FORALL I in 1..H_PARTY_ID.COUNT
2169: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2170: l_search_ctx_id,H_PARTY_ID(I));
2171: l_party_id_idx := H_PARTY_ID.COUNT+1;
2172: ELSE
2173: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

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

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

2374: END IF;
2375: SAVEPOINT eval_start;
2376: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2377: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2378: hz_utility_v2pub.debug(p_message=>'Match rule is 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: l_ctx_id := l_search_ctx_id;
2381: FORALL I in 1..H_PARTY_ID.COUNT
2382: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2378: hz_utility_v2pub.debug(p_message=>'Match rule is 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: l_ctx_id := l_search_ctx_id;
2381: FORALL I in 1..H_PARTY_ID.COUNT
2382: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2383: l_search_ctx_id,H_PARTY_ID(I));
2384: H_PARTY_ID.DELETE;
2385: H_PARTY_ID_LIST.DELETE;
2386: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

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

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

2958: set_person_party_type;
2959: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2960: l_ctx_id := l_search_ctx_id;
2961: FORALL I in 1..H_PARTY_ID.COUNT
2962: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2963: l_search_ctx_id,H_PARTY_ID(I));
2964: H_PARTY_ID.DELETE;
2965: H_PARTY_ID_LIST.DELETE;
2966: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2965: H_PARTY_ID_LIST.DELETE;
2966: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2967: l_ctx_id := l_search_ctx_id;
2968: FORALL I in 1..H_PARTY_ID.COUNT
2969: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2970: l_search_ctx_id,H_PARTY_ID(I));
2971: l_party_id_idx := H_PARTY_ID.COUNT+1;
2972: ELSE
2973: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3066: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3067: FROM HZ_STAGED_CONTACTS stage
3068: WHERE contains( concat_col, p_contains_str)>0
3069: AND ORG_CONTACT_ID in (
3070: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3071: org_contact_id
3072: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3073: where d.party_id = r.subject_id
3074: and oc.party_relationship_id = r.relationship_id

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

3068: WHERE contains( concat_col, p_contains_str)>0
3069: AND ORG_CONTACT_ID in (
3070: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3071: org_contact_id
3072: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3073: where d.party_id = r.subject_id
3074: and oc.party_relationship_id = r.relationship_id
3075: and d.search_context_id = p_search_ctx_id);
3076: exception

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

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

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

3109: H_PARTY_ID_LIST.DELETE;
3110: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3111: l_ctx_id := l_search_ctx_id;
3112: FORALL I in 1..H_PARTY_ID.COUNT
3113: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3114: l_search_ctx_id,H_PARTY_ID(I));
3115: l_party_id_idx := H_PARTY_ID.COUNT+1;
3116: ELSE
3117: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3200: SAVEPOINT eval_start;
3201: l_ctx_id := l_search_ctx_id;
3202: unset_person_party_type;
3203: FORALL I in 1..H_PARTY_ID.COUNT
3204: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3205: l_search_ctx_id,H_PARTY_ID(I));
3206: l_party_id_idx := H_PARTY_ID.COUNT+1;
3207: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3208: LOOP

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

3267: unset_person_party_type;
3268: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3269: l_ctx_id := l_search_ctx_id;
3270: FORALL I in 1..H_PARTY_ID.COUNT
3271: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3272: l_search_ctx_id,H_PARTY_ID(I));
3273: H_PARTY_ID.DELETE;
3274: H_PARTY_ID_LIST.DELETE;
3275: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3273: H_PARTY_ID.DELETE;
3274: H_PARTY_ID_LIST.DELETE;
3275: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3276: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3277: 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);
3278: END IF;
3279: l_ctx_id := l_search_ctx_id;
3280: FORALL I in 1..H_PARTY_ID.COUNT
3281: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3277: 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);
3278: END IF;
3279: l_ctx_id := l_search_ctx_id;
3280: FORALL I in 1..H_PARTY_ID.COUNT
3281: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3282: l_search_ctx_id,H_PARTY_ID(I));
3283: l_party_id_idx := H_PARTY_ID.COUNT+1;
3284: ELSE
3285: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3282: l_search_ctx_id,H_PARTY_ID(I));
3283: l_party_id_idx := H_PARTY_ID.COUNT+1;
3284: ELSE
3285: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3286: 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);
3287: END IF;
3288: l_ctx_id := NULL;
3289: l_party_id_idx := H_PARTY_ID.COUNT+1;
3290: END IF;

Line 4430: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4426: IF l_match_str = ' AND ' OR (
4427: ((l_cpt_max_score/l_entered_max_score)<(65/110))
4428: ) THEN
4429: FORALL I in 1..l_match_ps_list.COUNT
4430: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4431: values (l_search_ctx_id,l_match_ps_list(I));
4432: 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');
4433: ELSE
4434: 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 4657: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4653: IF l_match_str = ' AND ' OR (
4654: ((l_cpt_max_score/l_entered_max_score)<(65/110))
4655: ) THEN
4656: FORALL I in 1..l_match_contact_list.COUNT
4657: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4658: values (l_search_ctx_id,l_match_contact_list(I));
4659: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur,'CONTACTS');
4660: ELSE
4661: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);