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

Line 1441: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1437: 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);
1438: END IF;
1439: OPEN x_cursor FOR
1440: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX34, TX35, TX40, TX39, TX45
1441: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1442: WHERE contains( concat_col, p_contains_str)>0
1443: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1444: AND d.party_id = stage.party_id
1445: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1600: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1596: END IF;
1597: IF p_person_api = 'Y' THEN
1598: OPEN x_cursor FOR
1599: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1600: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1601: WHERE contains( concat_col, p_contains_str)>0
1602: AND( (l_search_merged ='Y' )
1603: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1604: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1606: AND d.party_id = stage.party_id
1607: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1608: UNION
1609: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1610: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1611: WHERE contains( concat_col, p_contains_str)>0
1612: AND( (l_search_merged ='Y' )
1613: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1614: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1623: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1619: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1620: ELSE
1621: OPEN x_cursor FOR
1622: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1623: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1624: WHERE contains( concat_col, p_contains_str)>0
1625: AND( (l_search_merged ='Y' )
1626: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1627: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1824: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1820: 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);
1821: END IF;
1822: OPEN x_cursor FOR
1823: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX22
1824: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1825: WHERE contains( concat_col, p_contains_str)>0
1826: AND d.search_context_id = p_search_ctx_id
1827: AND d.party_id = stage.party_id
1828: AND( (l_search_merged ='Y' )

Line 1931: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1927: IF p_restrict_entity = 'CONTACTS'
1928: THEN
1929: OPEN x_cursor FOR
1930: 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
1931: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1932: WHERE contains( concat_col, p_contains_str)>0
1933: AND d.search_context_id = p_search_ctx_id
1934: AND( (l_search_merged ='Y' )
1935: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1943: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1939: IF p_restrict_entity = 'PARTY_SITES'
1940: THEN
1941: OPEN x_cursor FOR
1942: 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
1943: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1944: WHERE contains( concat_col, p_contains_str)>0
1945: AND d.search_context_id = p_search_ctx_id
1946: AND( (l_search_merged ='Y' )
1947: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2019: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2015: END IF;
2016: IF p_person_api = 'Y' THEN
2017: OPEN x_cursor FOR
2018: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2019: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2020: WHERE contains( concat_col, p_contains_str)>0
2021: AND d.search_context_id = p_search_ctx_id
2022: AND d.party_id = stage.party_id
2023: AND( (l_search_merged ='Y' )

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

2025: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2026: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2027: UNION
2028: 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
2029: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2030: WHERE contains( concat_col, p_contains_str)>0
2031: AND d.search_context_id = p_search_ctx_id
2032: AND d.party_id = r.subject_id
2033: AND r.relationship_id = oc.party_relationship_id

Line 2042: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2038: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2039: ELSE
2040: OPEN x_cursor FOR
2041: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2042: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2043: WHERE contains( concat_col, p_contains_str)>0
2044: AND d.search_context_id = p_search_ctx_id
2045: AND d.party_id = stage.party_id
2046: AND( (l_search_merged ='Y' )

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

2374: SAVEPOINT eval_start;
2375: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2376: l_ctx_id := l_search_ctx_id;
2377: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2378: 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);
2379: END IF;
2380: FORALL I in 1..H_PARTY_ID.COUNT
2381: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2382: l_search_ctx_id,H_PARTY_ID(I));

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

2377: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2378: 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);
2379: END IF;
2380: FORALL I in 1..H_PARTY_ID.COUNT
2381: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2382: l_search_ctx_id,H_PARTY_ID(I));
2383: H_PARTY_ID.DELETE;
2384: H_PARTY_ID_LIST.DELETE;
2385: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2383: H_PARTY_ID.DELETE;
2384: H_PARTY_ID_LIST.DELETE;
2385: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2386: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2387: 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);
2388: END IF;
2389: l_ctx_id := l_search_ctx_id;
2390: FORALL I in 1..H_PARTY_ID.COUNT
2391: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2387: 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);
2388: END IF;
2389: l_ctx_id := l_search_ctx_id;
2390: FORALL I in 1..H_PARTY_ID.COUNT
2391: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2392: l_search_ctx_id,H_PARTY_ID(I));
2393: l_party_id_idx := H_PARTY_ID.COUNT+1;
2394: ELSE
2395: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2507: END IF;
2508: SAVEPOINT eval_start;
2509: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2510: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2511: 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);
2512: END IF;
2513: l_ctx_id := l_search_ctx_id;
2514: FORALL I in 1..H_PARTY_ID.COUNT
2515: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2511: 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);
2512: END IF;
2513: l_ctx_id := l_search_ctx_id;
2514: FORALL I in 1..H_PARTY_ID.COUNT
2515: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2516: l_search_ctx_id,H_PARTY_ID(I));
2517: H_PARTY_ID.DELETE;
2518: H_PARTY_ID_LIST.DELETE;
2519: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2517: H_PARTY_ID.DELETE;
2518: H_PARTY_ID_LIST.DELETE;
2519: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2520: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2521: 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);
2522: END IF;
2523: l_ctx_id := l_search_ctx_id;
2524: FORALL I in 1..H_PARTY_ID.COUNT
2525: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2521: 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);
2522: END IF;
2523: l_ctx_id := l_search_ctx_id;
2524: FORALL I in 1..H_PARTY_ID.COUNT
2525: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2526: l_search_ctx_id,H_PARTY_ID(I));
2527: l_party_id_idx := H_PARTY_ID.COUNT+1;
2528: ELSE
2529: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2619: END IF;
2620: SAVEPOINT eval_start;
2621: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2622: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2623: 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);
2624: END IF;
2625: l_ctx_id := l_search_ctx_id;
2626: FORALL I in 1..H_PARTY_ID.COUNT
2627: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2623: 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);
2624: END IF;
2625: l_ctx_id := l_search_ctx_id;
2626: FORALL I in 1..H_PARTY_ID.COUNT
2627: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2628: l_search_ctx_id,H_PARTY_ID(I));
2629: H_PARTY_ID.DELETE;
2630: H_PARTY_ID_LIST.DELETE;
2631: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2629: H_PARTY_ID.DELETE;
2630: H_PARTY_ID_LIST.DELETE;
2631: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2632: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2633: 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);
2634: END IF;
2635: l_ctx_id := l_search_ctx_id;
2636: FORALL I in 1..H_PARTY_ID.COUNT
2637: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2633: 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);
2634: END IF;
2635: l_ctx_id := l_search_ctx_id;
2636: FORALL I in 1..H_PARTY_ID.COUNT
2637: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2638: l_search_ctx_id,H_PARTY_ID(I));
2639: l_party_id_idx := H_PARTY_ID.COUNT+1;
2640: ELSE
2641: 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 3361: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3357: set_person_party_type;
3358: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3359: l_ctx_id := l_search_ctx_id;
3360: FORALL I in 1..H_PARTY_ID.COUNT
3361: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3362: l_search_ctx_id,H_PARTY_ID(I));
3363: H_PARTY_ID.DELETE;
3364: H_PARTY_ID_LIST.DELETE;
3365: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3364: H_PARTY_ID_LIST.DELETE;
3365: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3366: l_ctx_id := l_search_ctx_id;
3367: FORALL I in 1..H_PARTY_ID.COUNT
3368: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3369: l_search_ctx_id,H_PARTY_ID(I));
3370: l_party_id_idx := H_PARTY_ID.COUNT+1;
3371: ELSE
3372: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3465: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX22
3466: FROM HZ_STAGED_CONTACTS stage
3467: WHERE contains( concat_col, p_contains_str)>0
3468: AND ORG_CONTACT_ID in (
3469: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3470: org_contact_id
3471: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3472: where d.party_id = r.subject_id
3473: and oc.party_relationship_id = r.relationship_id

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

3467: WHERE contains( concat_col, p_contains_str)>0
3468: AND ORG_CONTACT_ID in (
3469: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3470: org_contact_id
3471: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3472: where d.party_id = r.subject_id
3473: and oc.party_relationship_id = r.relationship_id
3474: and d.search_context_id = p_search_ctx_id);
3475: exception

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

3501: unset_person_party_type;
3502: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3503: l_ctx_id := l_search_ctx_id;
3504: FORALL I in 1..H_PARTY_ID.COUNT
3505: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3506: l_search_ctx_id,H_PARTY_ID(I));
3507: H_PARTY_ID.DELETE;
3508: H_PARTY_ID_LIST.DELETE;
3509: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3508: H_PARTY_ID_LIST.DELETE;
3509: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3510: l_ctx_id := l_search_ctx_id;
3511: FORALL I in 1..H_PARTY_ID.COUNT
3512: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3513: l_search_ctx_id,H_PARTY_ID(I));
3514: l_party_id_idx := H_PARTY_ID.COUNT+1;
3515: ELSE
3516: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3599: SAVEPOINT eval_start;
3600: l_ctx_id := l_search_ctx_id;
3601: unset_person_party_type;
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: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3607: LOOP

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

3666: unset_person_party_type;
3667: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3668: l_ctx_id := l_search_ctx_id;
3669: FORALL I in 1..H_PARTY_ID.COUNT
3670: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3671: l_search_ctx_id,H_PARTY_ID(I));
3672: H_PARTY_ID.DELETE;
3673: H_PARTY_ID_LIST.DELETE;
3674: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3672: H_PARTY_ID.DELETE;
3673: H_PARTY_ID_LIST.DELETE;
3674: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3675: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3676: 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);
3677: END IF;
3678: l_ctx_id := l_search_ctx_id;
3679: FORALL I in 1..H_PARTY_ID.COUNT
3680: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3676: 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);
3677: END IF;
3678: l_ctx_id := l_search_ctx_id;
3679: FORALL I in 1..H_PARTY_ID.COUNT
3680: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3681: l_search_ctx_id,H_PARTY_ID(I));
3682: l_party_id_idx := H_PARTY_ID.COUNT+1;
3683: ELSE
3684: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3681: l_search_ctx_id,H_PARTY_ID(I));
3682: l_party_id_idx := H_PARTY_ID.COUNT+1;
3683: ELSE
3684: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3685: 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);
3686: END IF;
3687: l_ctx_id := NULL;
3688: l_party_id_idx := H_PARTY_ID.COUNT+1;
3689: END IF;

Line 4954: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4950: IF l_match_str = ' AND ' OR (
4951: ((l_cpt_max_score/l_entered_max_score)<(284/360))
4952: ) THEN
4953: FORALL I in 1..l_match_ps_list.COUNT
4954: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4955: values (l_search_ctx_id,l_match_ps_list(I));
4956: 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');
4957: ELSE
4958: 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 5185: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5181: IF l_match_str = ' AND ' OR (
5182: ((l_cpt_max_score/l_entered_max_score)<(284/360))
5183: ) THEN
5184: FORALL I in 1..l_match_contact_list.COUNT
5185: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5186: values (l_search_ctx_id,l_match_contact_list(I));
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,'CONTACTS');
5188: ELSE
5189: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);