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

Line 1655: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1651: 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);
1652: END IF;
1653: OPEN x_cursor FOR
1654: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48))
1655: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1656: WHERE contains( concat_col, p_contains_str)>0
1657: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1658: AND d.party_id = stage.party_id
1659: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1816: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1812: END IF;
1813: IF p_person_api = 'Y' THEN
1814: OPEN x_cursor FOR
1815: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1816: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1817: WHERE contains( concat_col, p_contains_str)>0
1818: AND( (l_search_merged ='Y' )
1819: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1820: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1822: AND d.party_id = stage.party_id
1823: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1824: UNION
1825: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1826: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1827: WHERE contains( concat_col, p_contains_str)>0
1828: AND( (l_search_merged ='Y' )
1829: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1830: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1839: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1835: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1836: ELSE
1837: OPEN x_cursor FOR
1838: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1839: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1840: WHERE contains( concat_col, p_contains_str)>0
1841: AND( (l_search_merged ='Y' )
1842: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1843: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2040: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2036: 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);
2037: END IF;
2038: OPEN x_cursor FOR
2039: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX6, TX5
2040: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2041: WHERE contains( concat_col, p_contains_str)>0
2042: AND d.search_context_id = p_search_ctx_id
2043: AND d.party_id = stage.party_id
2044: AND( (l_search_merged ='Y' )

Line 2147: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2143: IF p_restrict_entity = 'CONTACTS'
2144: THEN
2145: OPEN x_cursor FOR
2146: 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, TX5, TX6, TX8
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 2159: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2155: IF p_restrict_entity = 'PARTY_SITES'
2156: THEN
2157: OPEN x_cursor FOR
2158: 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, TX5, TX6, TX8
2159: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2160: WHERE contains( concat_col, p_contains_str)>0
2161: AND d.search_context_id = p_search_ctx_id
2162: AND( (l_search_merged ='Y' )
2163: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2235: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2231: END IF;
2232: IF p_person_api = 'Y' THEN
2233: OPEN x_cursor FOR
2234: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8
2235: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2236: WHERE contains( concat_col, p_contains_str)>0
2237: AND d.search_context_id = p_search_ctx_id
2238: AND d.party_id = stage.party_id
2239: AND( (l_search_merged ='Y' )

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

2241: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2242: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2243: UNION
2244: 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, TX5, TX6, TX8
2245: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2246: WHERE contains( concat_col, p_contains_str)>0
2247: AND d.search_context_id = p_search_ctx_id
2248: AND d.party_id = r.subject_id
2249: AND r.relationship_id = oc.party_relationship_id

Line 2258: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2254: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2255: ELSE
2256: OPEN x_cursor FOR
2257: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8
2258: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2259: WHERE contains( concat_col, p_contains_str)>0
2260: AND d.search_context_id = p_search_ctx_id
2261: AND d.party_id = stage.party_id
2262: AND( (l_search_merged ='Y' )

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

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

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

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

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

2605: H_PARTY_ID.DELETE;
2606: H_PARTY_ID_LIST.DELETE;
2607: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2608: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2609: 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);
2610: END IF;
2611: l_ctx_id := l_search_ctx_id;
2612: FORALL I in 1..H_PARTY_ID.COUNT
2613: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2609: 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);
2610: END IF;
2611: l_ctx_id := l_search_ctx_id;
2612: FORALL I in 1..H_PARTY_ID.COUNT
2613: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2614: l_search_ctx_id,H_PARTY_ID(I));
2615: l_party_id_idx := H_PARTY_ID.COUNT+1;
2616: ELSE
2617: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

2739: H_PARTY_ID.DELETE;
2740: H_PARTY_ID_LIST.DELETE;
2741: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2742: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2743: 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);
2744: END IF;
2745: l_ctx_id := l_search_ctx_id;
2746: FORALL I in 1..H_PARTY_ID.COUNT
2747: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2743: 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);
2744: END IF;
2745: l_ctx_id := l_search_ctx_id;
2746: FORALL I in 1..H_PARTY_ID.COUNT
2747: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2748: l_search_ctx_id,H_PARTY_ID(I));
2749: l_party_id_idx := H_PARTY_ID.COUNT+1;
2750: ELSE
2751: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

2851: H_PARTY_ID.DELETE;
2852: H_PARTY_ID_LIST.DELETE;
2853: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2854: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2855: 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);
2856: END IF;
2857: l_ctx_id := l_search_ctx_id;
2858: FORALL I in 1..H_PARTY_ID.COUNT
2859: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2855: 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);
2856: END IF;
2857: l_ctx_id := l_search_ctx_id;
2858: FORALL I in 1..H_PARTY_ID.COUNT
2859: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2860: l_search_ctx_id,H_PARTY_ID(I));
2861: l_party_id_idx := H_PARTY_ID.COUNT+1;
2862: ELSE
2863: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

2962: H_PARTY_ID.DELETE;
2963: H_PARTY_ID_LIST.DELETE;
2964: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2965: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2966: 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);
2967: END IF;
2968: l_ctx_id := l_search_ctx_id;
2969: FORALL I in 1..H_PARTY_ID.COUNT
2970: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2966: 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);
2967: END IF;
2968: l_ctx_id := l_search_ctx_id;
2969: FORALL I in 1..H_PARTY_ID.COUNT
2970: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2971: l_search_ctx_id,H_PARTY_ID(I));
2972: l_party_id_idx := H_PARTY_ID.COUNT+1;
2973: ELSE
2974: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3585: set_person_party_type;
3586: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3587: l_ctx_id := l_search_ctx_id;
3588: FORALL I in 1..H_PARTY_ID.COUNT
3589: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3590: l_search_ctx_id,H_PARTY_ID(I));
3591: H_PARTY_ID.DELETE;
3592: H_PARTY_ID_LIST.DELETE;
3593: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3592: H_PARTY_ID_LIST.DELETE;
3593: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3594: l_ctx_id := l_search_ctx_id;
3595: FORALL I in 1..H_PARTY_ID.COUNT
3596: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3597: l_search_ctx_id,H_PARTY_ID(I));
3598: l_party_id_idx := H_PARTY_ID.COUNT+1;
3599: ELSE
3600: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3693: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX6, TX5
3694: FROM HZ_STAGED_CONTACTS stage
3695: WHERE contains( concat_col, p_contains_str)>0
3696: AND ORG_CONTACT_ID in (
3697: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3698: org_contact_id
3699: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3700: where d.party_id = r.subject_id
3701: and oc.party_relationship_id = r.relationship_id

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

3695: WHERE contains( concat_col, p_contains_str)>0
3696: AND ORG_CONTACT_ID in (
3697: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3698: org_contact_id
3699: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3700: where d.party_id = r.subject_id
3701: and oc.party_relationship_id = r.relationship_id
3702: and d.search_context_id = p_search_ctx_id);
3703: exception

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

3729: unset_person_party_type;
3730: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3731: l_ctx_id := l_search_ctx_id;
3732: FORALL I in 1..H_PARTY_ID.COUNT
3733: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3734: l_search_ctx_id,H_PARTY_ID(I));
3735: H_PARTY_ID.DELETE;
3736: H_PARTY_ID_LIST.DELETE;
3737: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3736: H_PARTY_ID_LIST.DELETE;
3737: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3738: l_ctx_id := l_search_ctx_id;
3739: FORALL I in 1..H_PARTY_ID.COUNT
3740: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3741: l_search_ctx_id,H_PARTY_ID(I));
3742: l_party_id_idx := H_PARTY_ID.COUNT+1;
3743: ELSE
3744: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3827: SAVEPOINT eval_start;
3828: l_ctx_id := l_search_ctx_id;
3829: unset_person_party_type;
3830: FORALL I in 1..H_PARTY_ID.COUNT
3831: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3832: l_search_ctx_id,H_PARTY_ID(I));
3833: l_party_id_idx := H_PARTY_ID.COUNT+1;
3834: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3835: LOOP

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

3894: unset_person_party_type;
3895: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3896: l_ctx_id := l_search_ctx_id;
3897: FORALL I in 1..H_PARTY_ID.COUNT
3898: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3899: l_search_ctx_id,H_PARTY_ID(I));
3900: H_PARTY_ID.DELETE;
3901: H_PARTY_ID_LIST.DELETE;
3902: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3900: H_PARTY_ID.DELETE;
3901: H_PARTY_ID_LIST.DELETE;
3902: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3903: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3904: 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);
3905: END IF;
3906: l_ctx_id := l_search_ctx_id;
3907: FORALL I in 1..H_PARTY_ID.COUNT
3908: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3904: 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);
3905: END IF;
3906: l_ctx_id := l_search_ctx_id;
3907: FORALL I in 1..H_PARTY_ID.COUNT
3908: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3909: l_search_ctx_id,H_PARTY_ID(I));
3910: l_party_id_idx := H_PARTY_ID.COUNT+1;
3911: ELSE
3912: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3909: l_search_ctx_id,H_PARTY_ID(I));
3910: l_party_id_idx := H_PARTY_ID.COUNT+1;
3911: ELSE
3912: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3913: 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);
3914: END IF;
3915: l_ctx_id := NULL;
3916: l_party_id_idx := H_PARTY_ID.COUNT+1;
3917: END IF;

Line 5228: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5224: IF l_match_str = ' AND ' OR (
5225: ((l_cpt_max_score/l_entered_max_score)<(78/460))
5226: ) THEN
5227: FORALL I in 1..l_match_ps_list.COUNT
5228: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5229: values (l_search_ctx_id,l_match_ps_list(I));
5230: 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');
5231: ELSE
5232: 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 5459: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5455: IF l_match_str = ' AND ' OR (
5456: ((l_cpt_max_score/l_entered_max_score)<(78/460))
5457: ) THEN
5458: FORALL I in 1..l_match_contact_list.COUNT
5459: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5460: values (l_search_ctx_id,l_match_contact_list(I));
5461: 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');
5462: ELSE
5463: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);