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

1810: END IF;
1811: IF p_person_api = 'Y' THEN
1812: OPEN x_cursor FOR
1813: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1814: FROM HZ_DQM_PARTIES_GT d, 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 1824: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage

1820: AND d.party_id = stage.party_id
1821: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1822: UNION
1823: 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
1824: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1825: WHERE contains( concat_col, p_contains_str)>0
1826: AND( (l_search_merged ='Y' )
1827: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1828: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1837: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 2038: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 2145: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2157: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2233: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2229: END IF;
2230: IF p_person_api = 'Y' THEN
2231: OPEN x_cursor FOR
2232: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX5, TX6, TX8
2233: FROM HZ_DQM_PARTIES_GT d, 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 = stage.party_id
2237: AND( (l_search_merged ='Y' )

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

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

Line 2256: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5224: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

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

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