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

Line 1643: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1639: 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);
1640: END IF;
1641: OPEN x_cursor FOR
1642: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX40, TX39
1643: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1644: WHERE contains( concat_col, p_contains_str)>0
1645: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1646: AND d.party_id = stage.party_id
1647: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1804: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1800: END IF;
1801: IF p_person_api = 'Y' THEN
1802: OPEN x_cursor FOR
1803: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1804: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1805: WHERE contains( concat_col, p_contains_str)>0
1806: AND( (l_search_merged ='Y' )
1807: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1808: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1810: AND d.party_id = stage.party_id
1811: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1812: UNION
1813: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1814: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1815: WHERE contains( concat_col, p_contains_str)>0
1816: AND( (l_search_merged ='Y' )
1817: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1818: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1827: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1823: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1824: ELSE
1825: OPEN x_cursor FOR
1826: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1827: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1828: WHERE contains( concat_col, p_contains_str)>0
1829: AND( (l_search_merged ='Y' )
1830: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1831: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2028: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2024: 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);
2025: END IF;
2026: OPEN x_cursor FOR
2027: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX22
2028: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2029: WHERE contains( concat_col, p_contains_str)>0
2030: AND d.search_context_id = p_search_ctx_id
2031: AND d.party_id = stage.party_id
2032: AND( (l_search_merged ='Y' )

Line 2135: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2131: IF p_restrict_entity = 'CONTACTS'
2132: THEN
2133: OPEN x_cursor FOR
2134: 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
2135: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2136: WHERE contains( concat_col, p_contains_str)>0
2137: AND d.search_context_id = p_search_ctx_id
2138: AND( (l_search_merged ='Y' )
2139: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2147: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2143: IF p_restrict_entity = 'PARTY_SITES'
2144: THEN
2145: OPEN x_cursor FOR
2146: 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
2147: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2148: WHERE contains( concat_col, p_contains_str)>0
2149: AND d.search_context_id = p_search_ctx_id
2150: AND( (l_search_merged ='Y' )
2151: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2223: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2219: END IF;
2220: IF p_person_api = 'Y' THEN
2221: OPEN x_cursor FOR
2222: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2223: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2224: WHERE contains( concat_col, p_contains_str)>0
2225: AND d.search_context_id = p_search_ctx_id
2226: AND d.party_id = stage.party_id
2227: AND( (l_search_merged ='Y' )

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

2229: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2230: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2231: UNION
2232: 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
2233: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2234: WHERE contains( concat_col, p_contains_str)>0
2235: AND d.search_context_id = p_search_ctx_id
2236: AND d.party_id = r.subject_id
2237: AND r.relationship_id = oc.party_relationship_id

Line 2246: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2242: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2243: ELSE
2244: OPEN x_cursor FOR
2245: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2246: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2247: WHERE contains( concat_col, p_contains_str)>0
2248: AND d.search_context_id = p_search_ctx_id
2249: AND d.party_id = stage.party_id
2250: AND( (l_search_merged ='Y' )

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

2587: SAVEPOINT eval_start;
2588: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2589: l_ctx_id := l_search_ctx_id;
2590: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2591: 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);
2592: END IF;
2593: FORALL I in 1..H_PARTY_ID.COUNT
2594: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2595: l_search_ctx_id,H_PARTY_ID(I));

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

2590: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2591: 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);
2592: END IF;
2593: FORALL I in 1..H_PARTY_ID.COUNT
2594: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2595: l_search_ctx_id,H_PARTY_ID(I));
2596: H_PARTY_ID.DELETE;
2597: H_PARTY_ID_LIST.DELETE;
2598: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2596: H_PARTY_ID.DELETE;
2597: H_PARTY_ID_LIST.DELETE;
2598: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2599: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2600: 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);
2601: END IF;
2602: l_ctx_id := l_search_ctx_id;
2603: FORALL I in 1..H_PARTY_ID.COUNT
2604: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2600: 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);
2601: END IF;
2602: l_ctx_id := l_search_ctx_id;
2603: FORALL I in 1..H_PARTY_ID.COUNT
2604: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2605: l_search_ctx_id,H_PARTY_ID(I));
2606: l_party_id_idx := H_PARTY_ID.COUNT+1;
2607: ELSE
2608: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2720: END IF;
2721: SAVEPOINT eval_start;
2722: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2723: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2724: 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);
2725: END IF;
2726: l_ctx_id := l_search_ctx_id;
2727: FORALL I in 1..H_PARTY_ID.COUNT
2728: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2724: 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);
2725: END IF;
2726: l_ctx_id := l_search_ctx_id;
2727: FORALL I in 1..H_PARTY_ID.COUNT
2728: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2729: l_search_ctx_id,H_PARTY_ID(I));
2730: H_PARTY_ID.DELETE;
2731: H_PARTY_ID_LIST.DELETE;
2732: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2730: H_PARTY_ID.DELETE;
2731: H_PARTY_ID_LIST.DELETE;
2732: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2733: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2734: 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);
2735: END IF;
2736: l_ctx_id := l_search_ctx_id;
2737: FORALL I in 1..H_PARTY_ID.COUNT
2738: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2734: 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);
2735: END IF;
2736: l_ctx_id := l_search_ctx_id;
2737: FORALL I in 1..H_PARTY_ID.COUNT
2738: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2739: l_search_ctx_id,H_PARTY_ID(I));
2740: l_party_id_idx := H_PARTY_ID.COUNT+1;
2741: ELSE
2742: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2832: END IF;
2833: SAVEPOINT eval_start;
2834: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2835: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2836: 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);
2837: END IF;
2838: l_ctx_id := l_search_ctx_id;
2839: FORALL I in 1..H_PARTY_ID.COUNT
2840: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2836: 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);
2837: END IF;
2838: l_ctx_id := l_search_ctx_id;
2839: FORALL I in 1..H_PARTY_ID.COUNT
2840: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2841: l_search_ctx_id,H_PARTY_ID(I));
2842: H_PARTY_ID.DELETE;
2843: H_PARTY_ID_LIST.DELETE;
2844: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2842: H_PARTY_ID.DELETE;
2843: H_PARTY_ID_LIST.DELETE;
2844: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2845: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2846: 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);
2847: END IF;
2848: l_ctx_id := l_search_ctx_id;
2849: FORALL I in 1..H_PARTY_ID.COUNT
2850: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2846: 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);
2847: END IF;
2848: l_ctx_id := l_search_ctx_id;
2849: FORALL I in 1..H_PARTY_ID.COUNT
2850: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2851: l_search_ctx_id,H_PARTY_ID(I));
2852: l_party_id_idx := H_PARTY_ID.COUNT+1;
2853: ELSE
2854: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2943: END IF;
2944: SAVEPOINT eval_start;
2945: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2946: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2947: 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);
2948: END IF;
2949: l_ctx_id := l_search_ctx_id;
2950: FORALL I in 1..H_PARTY_ID.COUNT
2951: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2947: 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);
2948: END IF;
2949: l_ctx_id := l_search_ctx_id;
2950: FORALL I in 1..H_PARTY_ID.COUNT
2951: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2952: l_search_ctx_id,H_PARTY_ID(I));
2953: H_PARTY_ID.DELETE;
2954: H_PARTY_ID_LIST.DELETE;
2955: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2953: H_PARTY_ID.DELETE;
2954: H_PARTY_ID_LIST.DELETE;
2955: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2956: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2957: 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);
2958: END IF;
2959: l_ctx_id := l_search_ctx_id;
2960: FORALL I in 1..H_PARTY_ID.COUNT
2961: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2957: 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);
2958: END IF;
2959: l_ctx_id := l_search_ctx_id;
2960: FORALL I in 1..H_PARTY_ID.COUNT
2961: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2962: l_search_ctx_id,H_PARTY_ID(I));
2963: l_party_id_idx := H_PARTY_ID.COUNT+1;
2964: ELSE
2965: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3541: set_person_party_type;
3542: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3543: l_ctx_id := l_search_ctx_id;
3544: FORALL I in 1..H_PARTY_ID.COUNT
3545: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3546: l_search_ctx_id,H_PARTY_ID(I));
3547: H_PARTY_ID.DELETE;
3548: H_PARTY_ID_LIST.DELETE;
3549: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3548: H_PARTY_ID_LIST.DELETE;
3549: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3550: l_ctx_id := l_search_ctx_id;
3551: FORALL I in 1..H_PARTY_ID.COUNT
3552: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3553: l_search_ctx_id,H_PARTY_ID(I));
3554: l_party_id_idx := H_PARTY_ID.COUNT+1;
3555: ELSE
3556: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3649: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX22
3650: FROM HZ_STAGED_CONTACTS stage
3651: WHERE contains( concat_col, p_contains_str)>0
3652: AND ORG_CONTACT_ID in (
3653: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3654: org_contact_id
3655: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3656: where d.party_id = r.subject_id
3657: and oc.party_relationship_id = r.relationship_id

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

3651: WHERE contains( concat_col, p_contains_str)>0
3652: AND ORG_CONTACT_ID in (
3653: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3654: org_contact_id
3655: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3656: where d.party_id = r.subject_id
3657: and oc.party_relationship_id = r.relationship_id
3658: and d.search_context_id = p_search_ctx_id);
3659: exception

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

3685: unset_person_party_type;
3686: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3687: l_ctx_id := l_search_ctx_id;
3688: FORALL I in 1..H_PARTY_ID.COUNT
3689: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3690: l_search_ctx_id,H_PARTY_ID(I));
3691: H_PARTY_ID.DELETE;
3692: H_PARTY_ID_LIST.DELETE;
3693: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3692: H_PARTY_ID_LIST.DELETE;
3693: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3694: l_ctx_id := l_search_ctx_id;
3695: FORALL I in 1..H_PARTY_ID.COUNT
3696: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3697: l_search_ctx_id,H_PARTY_ID(I));
3698: l_party_id_idx := H_PARTY_ID.COUNT+1;
3699: ELSE
3700: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3783: SAVEPOINT eval_start;
3784: l_ctx_id := l_search_ctx_id;
3785: unset_person_party_type;
3786: FORALL I in 1..H_PARTY_ID.COUNT
3787: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3788: l_search_ctx_id,H_PARTY_ID(I));
3789: l_party_id_idx := H_PARTY_ID.COUNT+1;
3790: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3791: LOOP

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

3850: unset_person_party_type;
3851: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3852: l_ctx_id := l_search_ctx_id;
3853: FORALL I in 1..H_PARTY_ID.COUNT
3854: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3855: l_search_ctx_id,H_PARTY_ID(I));
3856: H_PARTY_ID.DELETE;
3857: H_PARTY_ID_LIST.DELETE;
3858: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3856: H_PARTY_ID.DELETE;
3857: H_PARTY_ID_LIST.DELETE;
3858: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3859: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3860: 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);
3861: END IF;
3862: l_ctx_id := l_search_ctx_id;
3863: FORALL I in 1..H_PARTY_ID.COUNT
3864: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3860: 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);
3861: END IF;
3862: l_ctx_id := l_search_ctx_id;
3863: FORALL I in 1..H_PARTY_ID.COUNT
3864: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3865: l_search_ctx_id,H_PARTY_ID(I));
3866: l_party_id_idx := H_PARTY_ID.COUNT+1;
3867: ELSE
3868: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3865: l_search_ctx_id,H_PARTY_ID(I));
3866: l_party_id_idx := H_PARTY_ID.COUNT+1;
3867: ELSE
3868: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3869: 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);
3870: END IF;
3871: l_ctx_id := NULL;
3872: l_party_id_idx := H_PARTY_ID.COUNT+1;
3873: END IF;

Line 5109: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5105: IF l_match_str = ' AND ' OR (
5106: ((l_cpt_max_score/l_entered_max_score)<(160/620))
5107: ) THEN
5108: FORALL I in 1..l_match_ps_list.COUNT
5109: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5110: values (l_search_ctx_id,l_match_ps_list(I));
5111: 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');
5112: ELSE
5113: 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 5340: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5336: IF l_match_str = ' AND ' OR (
5337: ((l_cpt_max_score/l_entered_max_score)<(160/620))
5338: ) THEN
5339: FORALL I in 1..l_match_contact_list.COUNT
5340: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5341: values (l_search_ctx_id,l_match_contact_list(I));
5342: 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');
5343: ELSE
5344: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);