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

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

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

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

Line 1274: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 1475: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 1582: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1594: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1670: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1666: END IF;
1667: IF p_person_api = 'Y' THEN
1668: OPEN x_cursor FOR
1669: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1670: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1671: WHERE contains( concat_col, p_contains_str)>0
1672: AND d.search_context_id = p_search_ctx_id
1673: AND d.party_id = stage.party_id
1674: AND( (l_search_merged ='Y' )

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

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

Line 1693: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4434: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

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

4657: IF l_match_str = ' AND ' OR (
4658: ((l_cpt_max_score/l_entered_max_score)<(65/110))
4659: ) THEN
4660: FORALL I in 1..l_match_contact_list.COUNT
4661: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4662: values (l_search_ctx_id,l_match_contact_list(I));
4663: 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');
4664: ELSE
4665: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);