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

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

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

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

Line 1842: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 2043: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 2150: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2162: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2238: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 2261: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

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

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

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

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

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

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

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

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

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

Line 2749: 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: H_PARTY_ID.DELETE;
2746: H_PARTY_ID_LIST.DELETE;
2747: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2748: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2749: 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);
2750: END IF;
2751: l_ctx_id := l_search_ctx_id;
2752: FORALL I in 1..H_PARTY_ID.COUNT
2753: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

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

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

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

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

Line 2861: 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: H_PARTY_ID.DELETE;
2858: H_PARTY_ID_LIST.DELETE;
2859: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2860: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2861: 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);
2862: END IF;
2863: l_ctx_id := l_search_ctx_id;
2864: FORALL I in 1..H_PARTY_ID.COUNT
2865: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

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

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

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

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

Line 2972: 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: H_PARTY_ID.DELETE;
2969: H_PARTY_ID_LIST.DELETE;
2970: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2971: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2972: 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);
2973: END IF;
2974: l_ctx_id := l_search_ctx_id;
2975: FORALL I in 1..H_PARTY_ID.COUNT
2976: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

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

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

3592: set_person_party_type;
3593: IF l_match_str = ' AND ' 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: H_PARTY_ID.DELETE;
3599: H_PARTY_ID_LIST.DELETE;
3600: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3599: H_PARTY_ID_LIST.DELETE;
3600: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3601: l_ctx_id := l_search_ctx_id;
3602: FORALL I in 1..H_PARTY_ID.COUNT
3603: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3604: l_search_ctx_id,H_PARTY_ID(I));
3605: l_party_id_idx := H_PARTY_ID.COUNT+1;
3606: ELSE
3607: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3702: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3703: FROM HZ_STAGED_CONTACTS stage
3704: WHERE contains( concat_col, p_contains_str)>0
3705: AND ORG_CONTACT_ID in (
3706: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3707: org_contact_id
3708: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3709: where d.party_id = r.subject_id
3710: and oc.party_relationship_id = r.relationship_id

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

3704: WHERE contains( concat_col, p_contains_str)>0
3705: AND ORG_CONTACT_ID in (
3706: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3707: org_contact_id
3708: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3709: where d.party_id = r.subject_id
3710: and oc.party_relationship_id = r.relationship_id
3711: and d.search_context_id = p_search_ctx_id);
3712: exception

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

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

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

3745: H_PARTY_ID_LIST.DELETE;
3746: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3747: l_ctx_id := l_search_ctx_id;
3748: FORALL I in 1..H_PARTY_ID.COUNT
3749: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3750: l_search_ctx_id,H_PARTY_ID(I));
3751: l_party_id_idx := H_PARTY_ID.COUNT+1;
3752: ELSE
3753: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3836: SAVEPOINT eval_start;
3837: l_ctx_id := l_search_ctx_id;
3838: unset_person_party_type;
3839: FORALL I in 1..H_PARTY_ID.COUNT
3840: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3841: l_search_ctx_id,H_PARTY_ID(I));
3842: l_party_id_idx := H_PARTY_ID.COUNT+1;
3843: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3844: LOOP

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

3903: unset_person_party_type;
3904: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3905: l_ctx_id := l_search_ctx_id;
3906: FORALL I in 1..H_PARTY_ID.COUNT
3907: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3908: l_search_ctx_id,H_PARTY_ID(I));
3909: H_PARTY_ID.DELETE;
3910: H_PARTY_ID_LIST.DELETE;
3911: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3909: H_PARTY_ID.DELETE;
3910: H_PARTY_ID_LIST.DELETE;
3911: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3912: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3913: 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);
3914: END IF;
3915: l_ctx_id := l_search_ctx_id;
3916: FORALL I in 1..H_PARTY_ID.COUNT
3917: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3913: 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);
3914: END IF;
3915: l_ctx_id := l_search_ctx_id;
3916: FORALL I in 1..H_PARTY_ID.COUNT
3917: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3918: l_search_ctx_id,H_PARTY_ID(I));
3919: l_party_id_idx := H_PARTY_ID.COUNT+1;
3920: ELSE
3921: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3918: l_search_ctx_id,H_PARTY_ID(I));
3919: l_party_id_idx := H_PARTY_ID.COUNT+1;
3920: ELSE
3921: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3922: 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);
3923: END IF;
3924: l_ctx_id := NULL;
3925: l_party_id_idx := H_PARTY_ID.COUNT+1;
3926: END IF;

Line 5183: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5179: IF l_match_str = ' AND ' OR (
5180: ((l_cpt_max_score/l_entered_max_score)<(76/505))
5181: ) THEN
5182: FORALL I in 1..l_match_ps_list.COUNT
5183: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5184: values (l_search_ctx_id,l_match_ps_list(I));
5185: 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');
5186: ELSE
5187: 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 5410: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5406: IF l_match_str = ' AND ' OR (
5407: ((l_cpt_max_score/l_entered_max_score)<(76/505))
5408: ) THEN
5409: FORALL I in 1..l_match_contact_list.COUNT
5410: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5411: values (l_search_ctx_id,l_match_contact_list(I));
5412: 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');
5413: ELSE
5414: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);