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

Line 1112: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1108: 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);
1109: END IF;
1110: OPEN x_cursor FOR
1111: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX44
1112: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1113: WHERE contains( concat_col, p_contains_str)>0
1114: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1115: AND d.party_id = stage.party_id
1116: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1273: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1269: END IF;
1270: IF p_person_api = 'Y' THEN
1271: OPEN x_cursor FOR
1272: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1273: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1274: WHERE contains( concat_col, p_contains_str)>0
1275: AND( (l_search_merged ='Y' )
1276: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1277: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1279: AND d.party_id = stage.party_id
1280: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1281: UNION
1282: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1283: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1284: WHERE contains( concat_col, p_contains_str)>0
1285: AND( (l_search_merged ='Y' )
1286: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1287: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1296: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1292: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1293: ELSE
1294: OPEN x_cursor FOR
1295: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1296: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1297: WHERE contains( concat_col, p_contains_str)>0
1298: AND( (l_search_merged ='Y' )
1299: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1300: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1497: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1493: 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);
1494: END IF;
1495: OPEN x_cursor FOR
1496: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1497: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1498: WHERE contains( concat_col, p_contains_str)>0
1499: AND d.search_context_id = p_search_ctx_id
1500: AND d.party_id = stage.party_id
1501: AND( (l_search_merged ='Y' )

Line 1604: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1600: IF p_restrict_entity = 'CONTACTS'
1601: THEN
1602: OPEN x_cursor FOR
1603: 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 , TX1, TX6, TX5
1604: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1605: WHERE contains( concat_col, p_contains_str)>0
1606: AND d.search_context_id = p_search_ctx_id
1607: AND( (l_search_merged ='Y' )
1608: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1616: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1612: IF p_restrict_entity = 'PARTY_SITES'
1613: THEN
1614: OPEN x_cursor FOR
1615: 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 , TX1, TX6, TX5
1616: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1617: WHERE contains( concat_col, p_contains_str)>0
1618: AND d.search_context_id = p_search_ctx_id
1619: AND( (l_search_merged ='Y' )
1620: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1692: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1688: END IF;
1689: IF p_person_api = 'Y' THEN
1690: OPEN x_cursor FOR
1691: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1692: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1693: WHERE contains( concat_col, p_contains_str)>0
1694: AND d.search_context_id = p_search_ctx_id
1695: AND d.party_id = stage.party_id
1696: AND( (l_search_merged ='Y' )

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

1698: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1699: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1700: UNION
1701: 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 , TX1, TX6, TX5
1702: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1703: WHERE contains( concat_col, p_contains_str)>0
1704: AND d.search_context_id = p_search_ctx_id
1705: AND d.party_id = r.subject_id
1706: AND r.relationship_id = oc.party_relationship_id

Line 1715: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1711: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1712: ELSE
1713: OPEN x_cursor FOR
1714: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1715: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1716: WHERE contains( concat_col, p_contains_str)>0
1717: AND d.search_context_id = p_search_ctx_id
1718: AND d.party_id = stage.party_id
1719: AND( (l_search_merged ='Y' )

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

2043: SAVEPOINT eval_start;
2044: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2045: l_ctx_id := l_search_ctx_id;
2046: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2047: 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);
2048: END IF;
2049: FORALL I in 1..H_PARTY_ID.COUNT
2050: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2051: l_search_ctx_id,H_PARTY_ID(I));

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

2046: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2047: 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);
2048: END IF;
2049: FORALL I in 1..H_PARTY_ID.COUNT
2050: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2051: l_search_ctx_id,H_PARTY_ID(I));
2052: H_PARTY_ID.DELETE;
2053: H_PARTY_ID_LIST.DELETE;
2054: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2052: H_PARTY_ID.DELETE;
2053: H_PARTY_ID_LIST.DELETE;
2054: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2055: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2056: 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);
2057: END IF;
2058: l_ctx_id := l_search_ctx_id;
2059: FORALL I in 1..H_PARTY_ID.COUNT
2060: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2056: 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);
2057: END IF;
2058: l_ctx_id := l_search_ctx_id;
2059: FORALL I in 1..H_PARTY_ID.COUNT
2060: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2061: l_search_ctx_id,H_PARTY_ID(I));
2062: l_party_id_idx := H_PARTY_ID.COUNT+1;
2063: ELSE
2064: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2176: END IF;
2177: SAVEPOINT eval_start;
2178: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2179: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2180: 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);
2181: END IF;
2182: l_ctx_id := l_search_ctx_id;
2183: FORALL I in 1..H_PARTY_ID.COUNT
2184: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2180: 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);
2181: END IF;
2182: l_ctx_id := l_search_ctx_id;
2183: FORALL I in 1..H_PARTY_ID.COUNT
2184: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2185: l_search_ctx_id,H_PARTY_ID(I));
2186: H_PARTY_ID.DELETE;
2187: H_PARTY_ID_LIST.DELETE;
2188: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2186: H_PARTY_ID.DELETE;
2187: H_PARTY_ID_LIST.DELETE;
2188: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2189: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2190: 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);
2191: END IF;
2192: l_ctx_id := l_search_ctx_id;
2193: FORALL I in 1..H_PARTY_ID.COUNT
2194: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2190: 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);
2191: END IF;
2192: l_ctx_id := l_search_ctx_id;
2193: FORALL I in 1..H_PARTY_ID.COUNT
2194: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2195: l_search_ctx_id,H_PARTY_ID(I));
2196: l_party_id_idx := H_PARTY_ID.COUNT+1;
2197: ELSE
2198: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2288: END IF;
2289: SAVEPOINT eval_start;
2290: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2291: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2292: 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);
2293: END IF;
2294: l_ctx_id := l_search_ctx_id;
2295: FORALL I in 1..H_PARTY_ID.COUNT
2296: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2292: 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);
2293: END IF;
2294: l_ctx_id := l_search_ctx_id;
2295: FORALL I in 1..H_PARTY_ID.COUNT
2296: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2297: l_search_ctx_id,H_PARTY_ID(I));
2298: H_PARTY_ID.DELETE;
2299: H_PARTY_ID_LIST.DELETE;
2300: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2298: H_PARTY_ID.DELETE;
2299: H_PARTY_ID_LIST.DELETE;
2300: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2301: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2302: 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);
2303: END IF;
2304: l_ctx_id := l_search_ctx_id;
2305: FORALL I in 1..H_PARTY_ID.COUNT
2306: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2302: 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);
2303: END IF;
2304: l_ctx_id := l_search_ctx_id;
2305: FORALL I in 1..H_PARTY_ID.COUNT
2306: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2307: l_search_ctx_id,H_PARTY_ID(I));
2308: l_party_id_idx := H_PARTY_ID.COUNT+1;
2309: ELSE
2310: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2399: END IF;
2400: SAVEPOINT eval_start;
2401: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2402: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2403: 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);
2404: END IF;
2405: l_ctx_id := l_search_ctx_id;
2406: FORALL I in 1..H_PARTY_ID.COUNT
2407: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2403: 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);
2404: END IF;
2405: l_ctx_id := l_search_ctx_id;
2406: FORALL I in 1..H_PARTY_ID.COUNT
2407: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2408: l_search_ctx_id,H_PARTY_ID(I));
2409: H_PARTY_ID.DELETE;
2410: H_PARTY_ID_LIST.DELETE;
2411: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2409: H_PARTY_ID.DELETE;
2410: H_PARTY_ID_LIST.DELETE;
2411: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2412: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2413: 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);
2414: END IF;
2415: l_ctx_id := l_search_ctx_id;
2416: FORALL I in 1..H_PARTY_ID.COUNT
2417: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2413: 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);
2414: END IF;
2415: l_ctx_id := l_search_ctx_id;
2416: FORALL I in 1..H_PARTY_ID.COUNT
2417: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2418: l_search_ctx_id,H_PARTY_ID(I));
2419: l_party_id_idx := H_PARTY_ID.COUNT+1;
2420: ELSE
2421: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2984: set_person_party_type;
2985: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2986: l_ctx_id := l_search_ctx_id;
2987: FORALL I in 1..H_PARTY_ID.COUNT
2988: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2989: l_search_ctx_id,H_PARTY_ID(I));
2990: H_PARTY_ID.DELETE;
2991: H_PARTY_ID_LIST.DELETE;
2992: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2991: H_PARTY_ID_LIST.DELETE;
2992: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2993: l_ctx_id := l_search_ctx_id;
2994: FORALL I in 1..H_PARTY_ID.COUNT
2995: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2996: l_search_ctx_id,H_PARTY_ID(I));
2997: l_party_id_idx := H_PARTY_ID.COUNT+1;
2998: ELSE
2999: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3092: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3093: FROM HZ_STAGED_CONTACTS stage
3094: WHERE contains( concat_col, p_contains_str)>0
3095: AND ORG_CONTACT_ID in (
3096: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3097: org_contact_id
3098: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3099: where d.party_id = r.subject_id
3100: and oc.party_relationship_id = r.relationship_id

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

3094: WHERE contains( concat_col, p_contains_str)>0
3095: AND ORG_CONTACT_ID in (
3096: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3097: org_contact_id
3098: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3099: where d.party_id = r.subject_id
3100: and oc.party_relationship_id = r.relationship_id
3101: and d.search_context_id = p_search_ctx_id);
3102: exception

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

3128: unset_person_party_type;
3129: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3130: l_ctx_id := l_search_ctx_id;
3131: FORALL I in 1..H_PARTY_ID.COUNT
3132: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3133: l_search_ctx_id,H_PARTY_ID(I));
3134: H_PARTY_ID.DELETE;
3135: H_PARTY_ID_LIST.DELETE;
3136: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3135: H_PARTY_ID_LIST.DELETE;
3136: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3137: l_ctx_id := l_search_ctx_id;
3138: FORALL I in 1..H_PARTY_ID.COUNT
3139: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3140: l_search_ctx_id,H_PARTY_ID(I));
3141: l_party_id_idx := H_PARTY_ID.COUNT+1;
3142: ELSE
3143: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3226: SAVEPOINT eval_start;
3227: l_ctx_id := l_search_ctx_id;
3228: unset_person_party_type;
3229: FORALL I in 1..H_PARTY_ID.COUNT
3230: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3231: l_search_ctx_id,H_PARTY_ID(I));
3232: l_party_id_idx := H_PARTY_ID.COUNT+1;
3233: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3234: LOOP

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

3293: unset_person_party_type;
3294: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3295: l_ctx_id := l_search_ctx_id;
3296: FORALL I in 1..H_PARTY_ID.COUNT
3297: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3298: l_search_ctx_id,H_PARTY_ID(I));
3299: H_PARTY_ID.DELETE;
3300: H_PARTY_ID_LIST.DELETE;
3301: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3299: H_PARTY_ID.DELETE;
3300: H_PARTY_ID_LIST.DELETE;
3301: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3302: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3303: 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);
3304: END IF;
3305: l_ctx_id := l_search_ctx_id;
3306: FORALL I in 1..H_PARTY_ID.COUNT
3307: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3303: 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);
3304: END IF;
3305: l_ctx_id := l_search_ctx_id;
3306: FORALL I in 1..H_PARTY_ID.COUNT
3307: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3308: l_search_ctx_id,H_PARTY_ID(I));
3309: l_party_id_idx := H_PARTY_ID.COUNT+1;
3310: ELSE
3311: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3308: l_search_ctx_id,H_PARTY_ID(I));
3309: l_party_id_idx := H_PARTY_ID.COUNT+1;
3310: ELSE
3311: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3312: 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);
3313: END IF;
3314: l_ctx_id := NULL;
3315: l_party_id_idx := H_PARTY_ID.COUNT+1;
3316: END IF;

Line 4491: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4487: IF l_match_str = ' AND ' OR (
4488: ((l_cpt_max_score/l_entered_max_score)<(15/60))
4489: ) THEN
4490: FORALL I in 1..l_match_ps_list.COUNT
4491: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4492: values (l_search_ctx_id,l_match_ps_list(I));
4493: 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');
4494: ELSE
4495: 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 4721: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4717: IF l_match_str = ' AND ' OR (
4718: ((l_cpt_max_score/l_entered_max_score)<(15/60))
4719: ) THEN
4720: FORALL I in 1..l_match_contact_list.COUNT
4721: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4722: values (l_search_ctx_id,l_match_contact_list(I));
4723: 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');
4724: ELSE
4725: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);