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

Line 1658: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

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

Line 1817: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1813: END IF;
1814: IF p_person_api = 'Y' THEN
1815: OPEN x_cursor FOR
1816: 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, TX22
1817: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1818: WHERE contains( concat_col, p_contains_str)>0
1819: AND( (l_search_merged ='Y' )
1820: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1821: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1823: AND d.party_id = stage.party_id
1824: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1825: UNION
1826: 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, TX22
1827: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, 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 1840: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1836: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1837: ELSE
1838: OPEN x_cursor FOR
1839: 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, TX22
1840: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1841: WHERE contains( concat_col, p_contains_str)>0
1842: AND( (l_search_merged ='Y' )
1843: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1844: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2041: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 2148: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2160: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2236: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2232: END IF;
2233: IF p_person_api = 'Y' THEN
2234: OPEN x_cursor FOR
2235: 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
2236: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2237: WHERE contains( concat_col, p_contains_str)>0
2238: AND d.search_context_id = p_search_ctx_id
2239: AND d.party_id = stage.party_id
2240: AND( (l_search_merged ='Y' )

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

2242: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2243: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2244: UNION
2245: 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
2246: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, 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 = r.subject_id
2250: AND r.relationship_id = oc.party_relationship_id

Line 2259: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2255: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2256: ELSE
2257: OPEN x_cursor FOR
2258: 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
2259: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2260: WHERE contains( concat_col, p_contains_str)>0
2261: AND d.search_context_id = p_search_ctx_id
2262: AND d.party_id = stage.party_id
2263: AND( (l_search_merged ='Y' )

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

2597: SAVEPOINT eval_start;
2598: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2599: l_ctx_id := l_search_ctx_id;
2600: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2601: 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);
2602: END IF;
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));

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

2600: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2601: 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);
2602: END IF;
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: H_PARTY_ID.DELETE;
2607: H_PARTY_ID_LIST.DELETE;
2608: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

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

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

2730: END IF;
2731: SAVEPOINT eval_start;
2732: IF l_match_str = ' AND ' 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 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);
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 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);
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: H_PARTY_ID.DELETE;
2741: H_PARTY_ID_LIST.DELETE;
2742: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

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

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

2842: END IF;
2843: SAVEPOINT eval_start;
2844: IF l_match_str = ' AND ' 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 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);
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 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);
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: H_PARTY_ID.DELETE;
2853: H_PARTY_ID_LIST.DELETE;
2854: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

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

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

2953: END IF;
2954: SAVEPOINT eval_start;
2955: IF l_match_str = ' AND ' 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 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);
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 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);
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: H_PARTY_ID.DELETE;
2964: H_PARTY_ID_LIST.DELETE;
2965: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5175: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5171: IF l_match_str = ' AND ' OR (
5172: ((l_cpt_max_score/l_entered_max_score)<(76/505))
5173: ) THEN
5174: FORALL I in 1..l_match_ps_list.COUNT
5175: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5176: values (l_search_ctx_id,l_match_ps_list(I));
5177: 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');
5178: ELSE
5179: 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 5402: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5398: IF l_match_str = ' AND ' OR (
5399: ((l_cpt_max_score/l_entered_max_score)<(76/505))
5400: ) THEN
5401: FORALL I in 1..l_match_contact_list.COUNT
5402: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5403: values (l_search_ctx_id,l_match_contact_list(I));
5404: 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');
5405: ELSE
5406: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);