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

Line 2043: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES 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_PARTIES_U1) */ stage.PARTY_ID , TX34, TX40, TX158, TX39, TX44, TX45, TX46, TX47
2043: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES 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 ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 2204: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2200: END IF;
2201: IF p_person_api = 'Y' THEN
2202: OPEN x_cursor FOR
2203: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2204: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2205: WHERE contains( concat_col, p_contains_str)>0
2206: AND( (l_search_merged ='Y' )
2207: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2208: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2210: AND d.party_id = stage.party_id
2211: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2212: UNION
2213: 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
2214: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2215: WHERE contains( concat_col, p_contains_str)>0
2216: AND( (l_search_merged ='Y' )
2217: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2218: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2227: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2223: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2224: ELSE
2225: OPEN x_cursor FOR
2226: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
2227: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2228: WHERE contains( concat_col, p_contains_str)>0
2229: AND( (l_search_merged ='Y' )
2230: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2231: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2428: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2424: 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);
2425: END IF;
2426: OPEN x_cursor FOR
2427: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX2, TX156, TX6, TX5
2428: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2429: WHERE contains( concat_col, p_contains_str)>0
2430: AND d.search_context_id = p_search_ctx_id
2431: AND d.party_id = stage.party_id
2432: AND( (l_search_merged ='Y' )

Line 2535: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2531: IF p_restrict_entity = 'CONTACTS'
2532: THEN
2533: OPEN x_cursor FOR
2534: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2535: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2536: WHERE contains( concat_col, p_contains_str)>0
2537: AND d.search_context_id = p_search_ctx_id
2538: AND( (l_search_merged ='Y' )
2539: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2547: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2543: IF p_restrict_entity = 'PARTY_SITES'
2544: THEN
2545: OPEN x_cursor FOR
2546: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2547: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2548: WHERE contains( concat_col, p_contains_str)>0
2549: AND d.search_context_id = p_search_ctx_id
2550: AND( (l_search_merged ='Y' )
2551: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2623: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2619: END IF;
2620: IF p_person_api = 'Y' THEN
2621: OPEN x_cursor FOR
2622: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2623: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2624: WHERE contains( concat_col, p_contains_str)>0
2625: AND d.search_context_id = p_search_ctx_id
2626: AND d.party_id = stage.party_id
2627: AND( (l_search_merged ='Y' )

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

2629: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2630: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2631: UNION
2632: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
2633: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2634: WHERE contains( concat_col, p_contains_str)>0
2635: AND d.search_context_id = p_search_ctx_id
2636: AND d.party_id = r.subject_id
2637: AND r.relationship_id = oc.party_relationship_id

Line 2646: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2642: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2643: ELSE
2644: OPEN x_cursor FOR
2645: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2646: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2647: WHERE contains( concat_col, p_contains_str)>0
2648: AND d.search_context_id = p_search_ctx_id
2649: AND d.party_id = stage.party_id
2650: AND( (l_search_merged ='Y' )

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

2991: SAVEPOINT eval_start;
2992: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2993: l_ctx_id := l_search_ctx_id;
2994: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2995: 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);
2996: END IF;
2997: FORALL I in 1..H_PARTY_ID.COUNT
2998: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2999: l_search_ctx_id,H_PARTY_ID(I));

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

2994: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2995: 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);
2996: END IF;
2997: FORALL I in 1..H_PARTY_ID.COUNT
2998: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2999: l_search_ctx_id,H_PARTY_ID(I));
3000: H_PARTY_ID.DELETE;
3001: H_PARTY_ID_LIST.DELETE;
3002: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3000: H_PARTY_ID.DELETE;
3001: H_PARTY_ID_LIST.DELETE;
3002: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3003: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3004: 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);
3005: END IF;
3006: l_ctx_id := l_search_ctx_id;
3007: FORALL I in 1..H_PARTY_ID.COUNT
3008: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3004: 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);
3005: END IF;
3006: l_ctx_id := l_search_ctx_id;
3007: FORALL I in 1..H_PARTY_ID.COUNT
3008: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3009: l_search_ctx_id,H_PARTY_ID(I));
3010: l_party_id_idx := H_PARTY_ID.COUNT+1;
3011: ELSE
3012: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3124: END IF;
3125: SAVEPOINT eval_start;
3126: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3127: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3128: 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);
3129: END IF;
3130: l_ctx_id := l_search_ctx_id;
3131: FORALL I in 1..H_PARTY_ID.COUNT
3132: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3128: 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);
3129: END IF;
3130: l_ctx_id := l_search_ctx_id;
3131: FORALL I in 1..H_PARTY_ID.COUNT
3132: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3133: l_search_ctx_id,H_PARTY_ID(I));
3134: H_PARTY_ID.DELETE;
3135: H_PARTY_ID_LIST.DELETE;
3136: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3134: H_PARTY_ID.DELETE;
3135: H_PARTY_ID_LIST.DELETE;
3136: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3137: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3138: 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);
3139: END IF;
3140: l_ctx_id := l_search_ctx_id;
3141: FORALL I in 1..H_PARTY_ID.COUNT
3142: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3138: 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);
3139: END IF;
3140: l_ctx_id := l_search_ctx_id;
3141: FORALL I in 1..H_PARTY_ID.COUNT
3142: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3143: l_search_ctx_id,H_PARTY_ID(I));
3144: l_party_id_idx := H_PARTY_ID.COUNT+1;
3145: ELSE
3146: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3236: END IF;
3237: SAVEPOINT eval_start;
3238: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
3239: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3240: 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);
3241: END IF;
3242: l_ctx_id := l_search_ctx_id;
3243: FORALL I in 1..H_PARTY_ID.COUNT
3244: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3240: 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);
3241: END IF;
3242: l_ctx_id := l_search_ctx_id;
3243: FORALL I in 1..H_PARTY_ID.COUNT
3244: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3245: l_search_ctx_id,H_PARTY_ID(I));
3246: H_PARTY_ID.DELETE;
3247: H_PARTY_ID_LIST.DELETE;
3248: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3246: H_PARTY_ID.DELETE;
3247: H_PARTY_ID_LIST.DELETE;
3248: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3249: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3250: 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);
3251: END IF;
3252: l_ctx_id := l_search_ctx_id;
3253: FORALL I in 1..H_PARTY_ID.COUNT
3254: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3250: 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);
3251: END IF;
3252: l_ctx_id := l_search_ctx_id;
3253: FORALL I in 1..H_PARTY_ID.COUNT
3254: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3255: l_search_ctx_id,H_PARTY_ID(I));
3256: l_party_id_idx := H_PARTY_ID.COUNT+1;
3257: ELSE
3258: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3347: END IF;
3348: SAVEPOINT eval_start;
3349: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3350: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3351: 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);
3352: END IF;
3353: l_ctx_id := l_search_ctx_id;
3354: FORALL I in 1..H_PARTY_ID.COUNT
3355: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3351: 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);
3352: END IF;
3353: l_ctx_id := l_search_ctx_id;
3354: FORALL I in 1..H_PARTY_ID.COUNT
3355: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3356: l_search_ctx_id,H_PARTY_ID(I));
3357: H_PARTY_ID.DELETE;
3358: H_PARTY_ID_LIST.DELETE;
3359: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3357: H_PARTY_ID.DELETE;
3358: H_PARTY_ID_LIST.DELETE;
3359: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3360: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3361: 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);
3362: END IF;
3363: l_ctx_id := l_search_ctx_id;
3364: FORALL I in 1..H_PARTY_ID.COUNT
3365: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3361: 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);
3362: END IF;
3363: l_ctx_id := l_search_ctx_id;
3364: FORALL I in 1..H_PARTY_ID.COUNT
3365: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3366: l_search_ctx_id,H_PARTY_ID(I));
3367: l_party_id_idx := H_PARTY_ID.COUNT+1;
3368: ELSE
3369: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3987: set_person_party_type;
3988: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3989: l_ctx_id := l_search_ctx_id;
3990: FORALL I in 1..H_PARTY_ID.COUNT
3991: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3992: l_search_ctx_id,H_PARTY_ID(I));
3993: H_PARTY_ID.DELETE;
3994: H_PARTY_ID_LIST.DELETE;
3995: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3994: H_PARTY_ID_LIST.DELETE;
3995: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3996: l_ctx_id := l_search_ctx_id;
3997: FORALL I in 1..H_PARTY_ID.COUNT
3998: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3999: l_search_ctx_id,H_PARTY_ID(I));
4000: l_party_id_idx := H_PARTY_ID.COUNT+1;
4001: ELSE
4002: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

4095: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX156, TX6, TX5
4096: FROM HZ_STAGED_CONTACTS stage
4097: WHERE contains( concat_col, p_contains_str)>0
4098: AND ORG_CONTACT_ID in (
4099: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
4100: org_contact_id
4101: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
4102: where d.party_id = r.subject_id
4103: and oc.party_relationship_id = r.relationship_id

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

4097: WHERE contains( concat_col, p_contains_str)>0
4098: AND ORG_CONTACT_ID in (
4099: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
4100: org_contact_id
4101: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
4102: where d.party_id = r.subject_id
4103: and oc.party_relationship_id = r.relationship_id
4104: and d.search_context_id = p_search_ctx_id);
4105: exception

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

4131: unset_person_party_type;
4132: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
4133: l_ctx_id := l_search_ctx_id;
4134: FORALL I in 1..H_PARTY_ID.COUNT
4135: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4136: l_search_ctx_id,H_PARTY_ID(I));
4137: H_PARTY_ID.DELETE;
4138: H_PARTY_ID_LIST.DELETE;
4139: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

4138: H_PARTY_ID_LIST.DELETE;
4139: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
4140: l_ctx_id := l_search_ctx_id;
4141: FORALL I in 1..H_PARTY_ID.COUNT
4142: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4143: l_search_ctx_id,H_PARTY_ID(I));
4144: l_party_id_idx := H_PARTY_ID.COUNT+1;
4145: ELSE
4146: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

4229: SAVEPOINT eval_start;
4230: l_ctx_id := l_search_ctx_id;
4231: unset_person_party_type;
4232: FORALL I in 1..H_PARTY_ID.COUNT
4233: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4234: l_search_ctx_id,H_PARTY_ID(I));
4235: l_party_id_idx := H_PARTY_ID.COUNT+1;
4236: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
4237: LOOP

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

4296: unset_person_party_type;
4297: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
4298: l_ctx_id := l_search_ctx_id;
4299: FORALL I in 1..H_PARTY_ID.COUNT
4300: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4301: l_search_ctx_id,H_PARTY_ID(I));
4302: H_PARTY_ID.DELETE;
4303: H_PARTY_ID_LIST.DELETE;
4304: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

4302: H_PARTY_ID.DELETE;
4303: H_PARTY_ID_LIST.DELETE;
4304: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
4305: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4306: 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);
4307: END IF;
4308: l_ctx_id := l_search_ctx_id;
4309: FORALL I in 1..H_PARTY_ID.COUNT
4310: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

4306: 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);
4307: END IF;
4308: l_ctx_id := l_search_ctx_id;
4309: FORALL I in 1..H_PARTY_ID.COUNT
4310: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4311: l_search_ctx_id,H_PARTY_ID(I));
4312: l_party_id_idx := H_PARTY_ID.COUNT+1;
4313: ELSE
4314: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

4311: l_search_ctx_id,H_PARTY_ID(I));
4312: l_party_id_idx := H_PARTY_ID.COUNT+1;
4313: ELSE
4314: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4315: 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);
4316: END IF;
4317: l_ctx_id := NULL;
4318: l_party_id_idx := H_PARTY_ID.COUNT+1;
4319: END IF;

Line 5648: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5644: IF l_match_str = ' AND ' OR (
5645: ((l_cpt_max_score/l_entered_max_score)<(75/685))
5646: ) THEN
5647: FORALL I in 1..l_match_ps_list.COUNT
5648: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5649: values (l_search_ctx_id,l_match_ps_list(I));
5650: 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');
5651: ELSE
5652: 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 5880: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5876: IF l_match_str = ' AND ' OR (
5877: ((l_cpt_max_score/l_entered_max_score)<(75/685))
5878: ) THEN
5879: FORALL I in 1..l_match_contact_list.COUNT
5880: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5881: values (l_search_ctx_id,l_match_contact_list(I));
5882: 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');
5883: ELSE
5884: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);