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

Line 1246: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1242: 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);
1243: END IF;
1244: OPEN x_cursor FOR
1245: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX4
1246: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1247: WHERE contains( concat_col, p_contains_str)>0
1248: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1249: AND d.party_id = stage.party_id
1250: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1407: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1403: END IF;
1404: IF p_person_api = 'Y' THEN
1405: OPEN x_cursor FOR
1406: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1407: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1408: WHERE contains( concat_col, p_contains_str)>0
1409: AND( (l_search_merged ='Y' )
1410: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1411: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1413: AND d.party_id = stage.party_id
1414: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1415: UNION
1416: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX11
1417: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1418: WHERE contains( concat_col, p_contains_str)>0
1419: AND( (l_search_merged ='Y' )
1420: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1421: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1430: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1426: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1427: ELSE
1428: OPEN x_cursor FOR
1429: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX11
1430: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1431: WHERE contains( concat_col, p_contains_str)>0
1432: AND( (l_search_merged ='Y' )
1433: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1434: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1631: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1627: 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);
1628: END IF;
1629: OPEN x_cursor FOR
1630: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1631: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1632: WHERE contains( concat_col, p_contains_str)>0
1633: AND d.search_context_id = p_search_ctx_id
1634: AND d.party_id = stage.party_id
1635: AND( (l_search_merged ='Y' )

Line 1738: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1734: IF p_restrict_entity = 'CONTACTS'
1735: THEN
1736: OPEN x_cursor FOR
1737: 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 , TX2, TX6
1738: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1739: WHERE contains( concat_col, p_contains_str)>0
1740: AND d.search_context_id = p_search_ctx_id
1741: AND( (l_search_merged ='Y' )
1742: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1750: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1746: IF p_restrict_entity = 'PARTY_SITES'
1747: THEN
1748: OPEN x_cursor FOR
1749: 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 , TX2, TX6
1750: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1751: WHERE contains( concat_col, p_contains_str)>0
1752: AND d.search_context_id = p_search_ctx_id
1753: AND( (l_search_merged ='Y' )
1754: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1826: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1822: END IF;
1823: IF p_person_api = 'Y' THEN
1824: OPEN x_cursor FOR
1825: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2, TX6
1826: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1827: WHERE contains( concat_col, p_contains_str)>0
1828: AND d.search_context_id = p_search_ctx_id
1829: AND d.party_id = stage.party_id
1830: AND( (l_search_merged ='Y' )

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

1832: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1833: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1834: UNION
1835: 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 , TX2, TX6
1836: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1837: WHERE contains( concat_col, p_contains_str)>0
1838: AND d.search_context_id = p_search_ctx_id
1839: AND d.party_id = r.subject_id
1840: AND r.relationship_id = oc.party_relationship_id

Line 1849: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1845: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1846: ELSE
1847: OPEN x_cursor FOR
1848: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2, TX6
1849: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1850: WHERE contains( concat_col, p_contains_str)>0
1851: AND d.search_context_id = p_search_ctx_id
1852: AND d.party_id = stage.party_id
1853: AND( (l_search_merged ='Y' )

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

2177: SAVEPOINT eval_start;
2178: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2179: l_ctx_id := l_search_ctx_id;
2180: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2181: 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);
2182: END IF;
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));

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

2180: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2181: 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);
2182: END IF;
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 2314: 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);

2310: END IF;
2311: SAVEPOINT eval_start;
2312: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2313: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2314: 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);
2315: END IF;
2316: l_ctx_id := l_search_ctx_id;
2317: FORALL I in 1..H_PARTY_ID.COUNT
2318: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2314: 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);
2315: END IF;
2316: l_ctx_id := l_search_ctx_id;
2317: FORALL I in 1..H_PARTY_ID.COUNT
2318: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2319: l_search_ctx_id,H_PARTY_ID(I));
2320: H_PARTY_ID.DELETE;
2321: H_PARTY_ID_LIST.DELETE;
2322: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2320: H_PARTY_ID.DELETE;
2321: H_PARTY_ID_LIST.DELETE;
2322: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2323: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2324: 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);
2325: END IF;
2326: l_ctx_id := l_search_ctx_id;
2327: FORALL I in 1..H_PARTY_ID.COUNT
2328: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2324: 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);
2325: END IF;
2326: l_ctx_id := l_search_ctx_id;
2327: FORALL I in 1..H_PARTY_ID.COUNT
2328: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2329: l_search_ctx_id,H_PARTY_ID(I));
2330: l_party_id_idx := H_PARTY_ID.COUNT+1;
2331: ELSE
2332: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2422: END IF;
2423: SAVEPOINT eval_start;
2424: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2425: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2426: 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);
2427: END IF;
2428: l_ctx_id := l_search_ctx_id;
2429: FORALL I in 1..H_PARTY_ID.COUNT
2430: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2426: 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);
2427: END IF;
2428: l_ctx_id := l_search_ctx_id;
2429: FORALL I in 1..H_PARTY_ID.COUNT
2430: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2431: l_search_ctx_id,H_PARTY_ID(I));
2432: H_PARTY_ID.DELETE;
2433: H_PARTY_ID_LIST.DELETE;
2434: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2432: H_PARTY_ID.DELETE;
2433: H_PARTY_ID_LIST.DELETE;
2434: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2435: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2436: 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);
2437: END IF;
2438: l_ctx_id := l_search_ctx_id;
2439: FORALL I in 1..H_PARTY_ID.COUNT
2440: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2436: 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);
2437: END IF;
2438: l_ctx_id := l_search_ctx_id;
2439: FORALL I in 1..H_PARTY_ID.COUNT
2440: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2441: l_search_ctx_id,H_PARTY_ID(I));
2442: l_party_id_idx := H_PARTY_ID.COUNT+1;
2443: ELSE
2444: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2533: END IF;
2534: SAVEPOINT eval_start;
2535: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2536: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2537: 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);
2538: END IF;
2539: l_ctx_id := l_search_ctx_id;
2540: FORALL I in 1..H_PARTY_ID.COUNT
2541: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2537: 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);
2538: END IF;
2539: l_ctx_id := l_search_ctx_id;
2540: FORALL I in 1..H_PARTY_ID.COUNT
2541: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2542: l_search_ctx_id,H_PARTY_ID(I));
2543: H_PARTY_ID.DELETE;
2544: H_PARTY_ID_LIST.DELETE;
2545: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2543: H_PARTY_ID.DELETE;
2544: H_PARTY_ID_LIST.DELETE;
2545: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2546: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2547: 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);
2548: END IF;
2549: l_ctx_id := l_search_ctx_id;
2550: FORALL I in 1..H_PARTY_ID.COUNT
2551: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2547: 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);
2548: END IF;
2549: l_ctx_id := l_search_ctx_id;
2550: FORALL I in 1..H_PARTY_ID.COUNT
2551: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2552: l_search_ctx_id,H_PARTY_ID(I));
2553: l_party_id_idx := H_PARTY_ID.COUNT+1;
2554: ELSE
2555: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3156: set_person_party_type;
3157: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3158: l_ctx_id := l_search_ctx_id;
3159: FORALL I in 1..H_PARTY_ID.COUNT
3160: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3161: l_search_ctx_id,H_PARTY_ID(I));
3162: H_PARTY_ID.DELETE;
3163: H_PARTY_ID_LIST.DELETE;
3164: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3163: H_PARTY_ID_LIST.DELETE;
3164: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3165: l_ctx_id := l_search_ctx_id;
3166: FORALL I in 1..H_PARTY_ID.COUNT
3167: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3168: l_search_ctx_id,H_PARTY_ID(I));
3169: l_party_id_idx := H_PARTY_ID.COUNT+1;
3170: ELSE
3171: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3264: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3265: FROM HZ_STAGED_CONTACTS stage
3266: WHERE contains( concat_col, p_contains_str)>0
3267: AND ORG_CONTACT_ID in (
3268: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3269: org_contact_id
3270: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3271: where d.party_id = r.subject_id
3272: and oc.party_relationship_id = r.relationship_id

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

3266: WHERE contains( concat_col, p_contains_str)>0
3267: AND ORG_CONTACT_ID in (
3268: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3269: org_contact_id
3270: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3271: where d.party_id = r.subject_id
3272: and oc.party_relationship_id = r.relationship_id
3273: and d.search_context_id = p_search_ctx_id);
3274: exception

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

3300: unset_person_party_type;
3301: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3302: l_ctx_id := l_search_ctx_id;
3303: FORALL I in 1..H_PARTY_ID.COUNT
3304: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3305: l_search_ctx_id,H_PARTY_ID(I));
3306: H_PARTY_ID.DELETE;
3307: H_PARTY_ID_LIST.DELETE;
3308: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3307: H_PARTY_ID_LIST.DELETE;
3308: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3309: l_ctx_id := l_search_ctx_id;
3310: FORALL I in 1..H_PARTY_ID.COUNT
3311: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3312: l_search_ctx_id,H_PARTY_ID(I));
3313: l_party_id_idx := H_PARTY_ID.COUNT+1;
3314: ELSE
3315: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3398: SAVEPOINT eval_start;
3399: l_ctx_id := l_search_ctx_id;
3400: unset_person_party_type;
3401: FORALL I in 1..H_PARTY_ID.COUNT
3402: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3403: l_search_ctx_id,H_PARTY_ID(I));
3404: l_party_id_idx := H_PARTY_ID.COUNT+1;
3405: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3406: LOOP

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

3465: unset_person_party_type;
3466: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3467: l_ctx_id := l_search_ctx_id;
3468: FORALL I in 1..H_PARTY_ID.COUNT
3469: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3470: l_search_ctx_id,H_PARTY_ID(I));
3471: H_PARTY_ID.DELETE;
3472: H_PARTY_ID_LIST.DELETE;
3473: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3471: H_PARTY_ID.DELETE;
3472: H_PARTY_ID_LIST.DELETE;
3473: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3474: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3475: 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);
3476: END IF;
3477: l_ctx_id := l_search_ctx_id;
3478: FORALL I in 1..H_PARTY_ID.COUNT
3479: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3475: 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);
3476: END IF;
3477: l_ctx_id := l_search_ctx_id;
3478: FORALL I in 1..H_PARTY_ID.COUNT
3479: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3480: l_search_ctx_id,H_PARTY_ID(I));
3481: l_party_id_idx := H_PARTY_ID.COUNT+1;
3482: ELSE
3483: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3480: l_search_ctx_id,H_PARTY_ID(I));
3481: l_party_id_idx := H_PARTY_ID.COUNT+1;
3482: ELSE
3483: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3484: 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);
3485: END IF;
3486: l_ctx_id := NULL;
3487: l_party_id_idx := H_PARTY_ID.COUNT+1;
3488: END IF;

Line 4740: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4736: IF l_match_str = ' AND ' OR (
4737: ((l_cpt_max_score/l_entered_max_score)<(65/100))
4738: ) THEN
4739: FORALL I in 1..l_match_ps_list.COUNT
4740: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4741: values (l_search_ctx_id,l_match_ps_list(I));
4742: 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');
4743: ELSE
4744: 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 4969: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4965: IF l_match_str = ' AND ' OR (
4966: ((l_cpt_max_score/l_entered_max_score)<(65/100))
4967: ) THEN
4968: FORALL I in 1..l_match_contact_list.COUNT
4969: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4970: values (l_search_ctx_id,l_match_contact_list(I));
4971: 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');
4972: ELSE
4973: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);