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

Line 1867: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1863: 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);
1864: END IF;
1865: OPEN x_cursor FOR
1866: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX32, TX33, TX34, TX35, TX40, TX39
1867: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1868: WHERE contains( concat_col, p_contains_str)>0
1869: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1870: AND d.party_id = stage.party_id
1871: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 2028: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2024: END IF;
2025: IF p_person_api = 'Y' THEN
2026: OPEN x_cursor FOR
2027: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
2028: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2029: WHERE contains( concat_col, p_contains_str)>0
2030: AND( (l_search_merged ='Y' )
2031: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2032: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2034: AND d.party_id = stage.party_id
2035: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2036: UNION
2037: 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, TX17, TX22
2038: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2039: WHERE contains( concat_col, p_contains_str)>0
2040: AND( (l_search_merged ='Y' )
2041: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2042: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2051: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2047: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2048: ELSE
2049: OPEN x_cursor FOR
2050: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
2051: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2052: WHERE contains( concat_col, p_contains_str)>0
2053: AND( (l_search_merged ='Y' )
2054: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2055: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2252: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2248: 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);
2249: END IF;
2250: OPEN x_cursor FOR
2251: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX6, TX5
2252: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2253: WHERE contains( concat_col, p_contains_str)>0
2254: AND d.search_context_id = p_search_ctx_id
2255: AND d.party_id = stage.party_id
2256: AND( (l_search_merged ='Y' )

Line 2359: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2355: IF p_restrict_entity = 'CONTACTS'
2356: THEN
2357: OPEN x_cursor FOR
2358: 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
2359: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2360: WHERE contains( concat_col, p_contains_str)>0
2361: AND d.search_context_id = p_search_ctx_id
2362: AND( (l_search_merged ='Y' )
2363: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2371: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2367: IF p_restrict_entity = 'PARTY_SITES'
2368: THEN
2369: OPEN x_cursor FOR
2370: 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
2371: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2372: WHERE contains( concat_col, p_contains_str)>0
2373: AND d.search_context_id = p_search_ctx_id
2374: AND( (l_search_merged ='Y' )
2375: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2447: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2443: END IF;
2444: IF p_person_api = 'Y' THEN
2445: OPEN x_cursor FOR
2446: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2447: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2448: WHERE contains( concat_col, p_contains_str)>0
2449: AND d.search_context_id = p_search_ctx_id
2450: AND d.party_id = stage.party_id
2451: AND( (l_search_merged ='Y' )

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

2453: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2454: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2455: UNION
2456: 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
2457: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2458: WHERE contains( concat_col, p_contains_str)>0
2459: AND d.search_context_id = p_search_ctx_id
2460: AND d.party_id = r.subject_id
2461: AND r.relationship_id = oc.party_relationship_id

Line 2470: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2466: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2467: ELSE
2468: OPEN x_cursor FOR
2469: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2470: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2471: WHERE contains( concat_col, p_contains_str)>0
2472: AND d.search_context_id = p_search_ctx_id
2473: AND d.party_id = stage.party_id
2474: AND( (l_search_merged ='Y' )

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

2812: SAVEPOINT eval_start;
2813: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2814: l_ctx_id := l_search_ctx_id;
2815: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2816: 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);
2817: END IF;
2818: FORALL I in 1..H_PARTY_ID.COUNT
2819: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2820: l_search_ctx_id,H_PARTY_ID(I));

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

2815: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2816: 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);
2817: END IF;
2818: FORALL I in 1..H_PARTY_ID.COUNT
2819: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2820: l_search_ctx_id,H_PARTY_ID(I));
2821: H_PARTY_ID.DELETE;
2822: H_PARTY_ID_LIST.DELETE;
2823: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2821: H_PARTY_ID.DELETE;
2822: H_PARTY_ID_LIST.DELETE;
2823: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2824: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2825: 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);
2826: END IF;
2827: l_ctx_id := l_search_ctx_id;
2828: FORALL I in 1..H_PARTY_ID.COUNT
2829: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2825: 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);
2826: END IF;
2827: l_ctx_id := l_search_ctx_id;
2828: FORALL I in 1..H_PARTY_ID.COUNT
2829: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2830: l_search_ctx_id,H_PARTY_ID(I));
2831: l_party_id_idx := H_PARTY_ID.COUNT+1;
2832: ELSE
2833: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2947: END IF;
2948: SAVEPOINT eval_start;
2949: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2950: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2951: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2952: END IF;
2953: l_ctx_id := l_search_ctx_id;
2954: FORALL I in 1..H_PARTY_ID.COUNT
2955: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2951: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2952: END IF;
2953: l_ctx_id := l_search_ctx_id;
2954: FORALL I in 1..H_PARTY_ID.COUNT
2955: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2956: l_search_ctx_id,H_PARTY_ID(I));
2957: H_PARTY_ID.DELETE;
2958: H_PARTY_ID_LIST.DELETE;
2959: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2957: H_PARTY_ID.DELETE;
2958: H_PARTY_ID_LIST.DELETE;
2959: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2960: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2961: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2962: END IF;
2963: l_ctx_id := l_search_ctx_id;
2964: FORALL I in 1..H_PARTY_ID.COUNT
2965: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2961: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2962: END IF;
2963: l_ctx_id := l_search_ctx_id;
2964: FORALL I in 1..H_PARTY_ID.COUNT
2965: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2966: l_search_ctx_id,H_PARTY_ID(I));
2967: l_party_id_idx := H_PARTY_ID.COUNT+1;
2968: ELSE
2969: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3059: END IF;
3060: SAVEPOINT eval_start;
3061: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
3062: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3063: 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);
3064: END IF;
3065: l_ctx_id := l_search_ctx_id;
3066: FORALL I in 1..H_PARTY_ID.COUNT
3067: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3063: 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);
3064: END IF;
3065: l_ctx_id := l_search_ctx_id;
3066: FORALL I in 1..H_PARTY_ID.COUNT
3067: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3068: l_search_ctx_id,H_PARTY_ID(I));
3069: H_PARTY_ID.DELETE;
3070: H_PARTY_ID_LIST.DELETE;
3071: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3069: H_PARTY_ID.DELETE;
3070: H_PARTY_ID_LIST.DELETE;
3071: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3072: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3073: 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);
3074: END IF;
3075: l_ctx_id := l_search_ctx_id;
3076: FORALL I in 1..H_PARTY_ID.COUNT
3077: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3073: 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);
3074: END IF;
3075: l_ctx_id := l_search_ctx_id;
3076: FORALL I in 1..H_PARTY_ID.COUNT
3077: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3078: l_search_ctx_id,H_PARTY_ID(I));
3079: l_party_id_idx := H_PARTY_ID.COUNT+1;
3080: ELSE
3081: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3170: END IF;
3171: SAVEPOINT eval_start;
3172: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3173: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3174: 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);
3175: END IF;
3176: l_ctx_id := l_search_ctx_id;
3177: FORALL I in 1..H_PARTY_ID.COUNT
3178: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3174: 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);
3175: END IF;
3176: l_ctx_id := l_search_ctx_id;
3177: FORALL I in 1..H_PARTY_ID.COUNT
3178: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3179: l_search_ctx_id,H_PARTY_ID(I));
3180: H_PARTY_ID.DELETE;
3181: H_PARTY_ID_LIST.DELETE;
3182: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3180: H_PARTY_ID.DELETE;
3181: H_PARTY_ID_LIST.DELETE;
3182: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3183: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3184: 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);
3185: END IF;
3186: l_ctx_id := l_search_ctx_id;
3187: FORALL I in 1..H_PARTY_ID.COUNT
3188: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3184: 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);
3185: END IF;
3186: l_ctx_id := l_search_ctx_id;
3187: FORALL I in 1..H_PARTY_ID.COUNT
3188: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3189: l_search_ctx_id,H_PARTY_ID(I));
3190: l_party_id_idx := H_PARTY_ID.COUNT+1;
3191: ELSE
3192: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3807: set_person_party_type;
3808: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3809: l_ctx_id := l_search_ctx_id;
3810: FORALL I in 1..H_PARTY_ID.COUNT
3811: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3812: l_search_ctx_id,H_PARTY_ID(I));
3813: H_PARTY_ID.DELETE;
3814: H_PARTY_ID_LIST.DELETE;
3815: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3814: H_PARTY_ID_LIST.DELETE;
3815: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3816: l_ctx_id := l_search_ctx_id;
3817: FORALL I in 1..H_PARTY_ID.COUNT
3818: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3819: l_search_ctx_id,H_PARTY_ID(I));
3820: l_party_id_idx := H_PARTY_ID.COUNT+1;
3821: ELSE
3822: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3917: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX6, TX5
3918: FROM HZ_STAGED_CONTACTS stage
3919: WHERE contains( concat_col, p_contains_str)>0
3920: AND ORG_CONTACT_ID in (
3921: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3922: org_contact_id
3923: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3924: where d.party_id = r.subject_id
3925: and oc.party_relationship_id = r.relationship_id

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

3919: WHERE contains( concat_col, p_contains_str)>0
3920: AND ORG_CONTACT_ID in (
3921: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3922: org_contact_id
3923: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3924: where d.party_id = r.subject_id
3925: and oc.party_relationship_id = r.relationship_id
3926: and d.search_context_id = p_search_ctx_id);
3927: exception

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

3953: unset_person_party_type;
3954: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3955: l_ctx_id := l_search_ctx_id;
3956: FORALL I in 1..H_PARTY_ID.COUNT
3957: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3958: l_search_ctx_id,H_PARTY_ID(I));
3959: H_PARTY_ID.DELETE;
3960: H_PARTY_ID_LIST.DELETE;
3961: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3960: H_PARTY_ID_LIST.DELETE;
3961: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3962: l_ctx_id := l_search_ctx_id;
3963: FORALL I in 1..H_PARTY_ID.COUNT
3964: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3965: l_search_ctx_id,H_PARTY_ID(I));
3966: l_party_id_idx := H_PARTY_ID.COUNT+1;
3967: ELSE
3968: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

4051: SAVEPOINT eval_start;
4052: l_ctx_id := l_search_ctx_id;
4053: unset_person_party_type;
4054: FORALL I in 1..H_PARTY_ID.COUNT
4055: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4056: l_search_ctx_id,H_PARTY_ID(I));
4057: l_party_id_idx := H_PARTY_ID.COUNT+1;
4058: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
4059: LOOP

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

4118: unset_person_party_type;
4119: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
4120: l_ctx_id := l_search_ctx_id;
4121: FORALL I in 1..H_PARTY_ID.COUNT
4122: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4123: l_search_ctx_id,H_PARTY_ID(I));
4124: H_PARTY_ID.DELETE;
4125: H_PARTY_ID_LIST.DELETE;
4126: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

4124: H_PARTY_ID.DELETE;
4125: H_PARTY_ID_LIST.DELETE;
4126: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
4127: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4128: 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);
4129: END IF;
4130: l_ctx_id := l_search_ctx_id;
4131: FORALL I in 1..H_PARTY_ID.COUNT
4132: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

4128: 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);
4129: END IF;
4130: l_ctx_id := l_search_ctx_id;
4131: FORALL I in 1..H_PARTY_ID.COUNT
4132: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4133: l_search_ctx_id,H_PARTY_ID(I));
4134: l_party_id_idx := H_PARTY_ID.COUNT+1;
4135: ELSE
4136: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

4133: l_search_ctx_id,H_PARTY_ID(I));
4134: l_party_id_idx := H_PARTY_ID.COUNT+1;
4135: ELSE
4136: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4137: 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);
4138: END IF;
4139: l_ctx_id := NULL;
4140: l_party_id_idx := H_PARTY_ID.COUNT+1;
4141: END IF;

Line 5457: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

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

Line 5687: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5683: IF l_match_str = ' AND ' OR (
5684: ((l_cpt_max_score/l_entered_max_score)<(77/700))
5685: ) THEN
5686: FORALL I in 1..l_match_contact_list.COUNT
5687: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5688: values (l_search_ctx_id,l_match_contact_list(I));
5689: 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');
5690: ELSE
5691: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);