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

Line 1526: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1522: 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);
1523: END IF;
1524: OPEN x_cursor FOR
1525: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX34, TX36, TX40, TX158, TX39, TX46
1526: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1527: WHERE contains( concat_col, p_contains_str)>0
1528: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1529: AND d.party_id = stage.party_id
1530: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1685: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1681: END IF;
1682: IF p_person_api = 'Y' THEN
1683: OPEN x_cursor FOR
1684: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1685: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1686: WHERE contains( concat_col, p_contains_str)>0
1687: AND( (l_search_merged ='Y' )
1688: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1689: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1691: AND d.party_id = stage.party_id
1692: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1693: UNION
1694: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1695: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1696: WHERE contains( concat_col, p_contains_str)>0
1697: AND( (l_search_merged ='Y' )
1698: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1699: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1708: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1704: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1705: ELSE
1706: OPEN x_cursor FOR
1707: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX14, TX22
1708: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1709: WHERE contains( concat_col, p_contains_str)>0
1710: AND( (l_search_merged ='Y' )
1711: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1712: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1909: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1905: 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);
1906: END IF;
1907: OPEN x_cursor FOR
1908: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1909: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1910: WHERE contains( concat_col, p_contains_str)>0
1911: AND d.search_context_id = p_search_ctx_id
1912: AND d.party_id = stage.party_id
1913: AND( (l_search_merged ='Y' )

Line 2016: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2012: IF p_restrict_entity = 'CONTACTS'
2013: THEN
2014: OPEN x_cursor FOR
2015: 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
2016: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2017: WHERE contains( concat_col, p_contains_str)>0
2018: AND d.search_context_id = p_search_ctx_id
2019: AND( (l_search_merged ='Y' )
2020: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2028: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2024: IF p_restrict_entity = 'PARTY_SITES'
2025: THEN
2026: OPEN x_cursor FOR
2027: 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
2028: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2029: WHERE contains( concat_col, p_contains_str)>0
2030: AND d.search_context_id = p_search_ctx_id
2031: AND( (l_search_merged ='Y' )
2032: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2104: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2100: END IF;
2101: IF p_person_api = 'Y' THEN
2102: OPEN x_cursor FOR
2103: 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
2104: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2105: WHERE contains( concat_col, p_contains_str)>0
2106: AND d.search_context_id = p_search_ctx_id
2107: AND d.party_id = stage.party_id
2108: AND( (l_search_merged ='Y' )

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

2110: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2111: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2112: UNION
2113: 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
2114: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2115: WHERE contains( concat_col, p_contains_str)>0
2116: AND d.search_context_id = p_search_ctx_id
2117: AND d.party_id = r.subject_id
2118: AND r.relationship_id = oc.party_relationship_id

Line 2127: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2123: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2124: ELSE
2125: OPEN x_cursor FOR
2126: 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
2127: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2128: WHERE contains( concat_col, p_contains_str)>0
2129: AND d.search_context_id = p_search_ctx_id
2130: AND d.party_id = stage.party_id
2131: AND( (l_search_merged ='Y' )

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

2462: SAVEPOINT eval_start;
2463: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2464: l_ctx_id := l_search_ctx_id;
2465: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2466: 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);
2467: END IF;
2468: FORALL I in 1..H_PARTY_ID.COUNT
2469: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2470: l_search_ctx_id,H_PARTY_ID(I));

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

2465: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2466: 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);
2467: END IF;
2468: FORALL I in 1..H_PARTY_ID.COUNT
2469: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2470: l_search_ctx_id,H_PARTY_ID(I));
2471: H_PARTY_ID.DELETE;
2472: H_PARTY_ID_LIST.DELETE;
2473: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2471: H_PARTY_ID.DELETE;
2472: H_PARTY_ID_LIST.DELETE;
2473: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2474: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2475: 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);
2476: END IF;
2477: l_ctx_id := l_search_ctx_id;
2478: FORALL I in 1..H_PARTY_ID.COUNT
2479: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2475: 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);
2476: END IF;
2477: l_ctx_id := l_search_ctx_id;
2478: FORALL I in 1..H_PARTY_ID.COUNT
2479: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2480: l_search_ctx_id,H_PARTY_ID(I));
2481: l_party_id_idx := H_PARTY_ID.COUNT+1;
2482: ELSE
2483: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

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

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

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

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

2707: END IF;
2708: SAVEPOINT eval_start;
2709: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2710: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2711: 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);
2712: END IF;
2713: l_ctx_id := l_search_ctx_id;
2714: FORALL I in 1..H_PARTY_ID.COUNT
2715: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2711: 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);
2712: END IF;
2713: l_ctx_id := l_search_ctx_id;
2714: FORALL I in 1..H_PARTY_ID.COUNT
2715: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2716: l_search_ctx_id,H_PARTY_ID(I));
2717: H_PARTY_ID.DELETE;
2718: H_PARTY_ID_LIST.DELETE;
2719: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2717: H_PARTY_ID.DELETE;
2718: H_PARTY_ID_LIST.DELETE;
2719: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2720: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2721: 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);
2722: END IF;
2723: l_ctx_id := l_search_ctx_id;
2724: FORALL I in 1..H_PARTY_ID.COUNT
2725: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2721: 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);
2722: END IF;
2723: l_ctx_id := l_search_ctx_id;
2724: FORALL I in 1..H_PARTY_ID.COUNT
2725: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2726: l_search_ctx_id,H_PARTY_ID(I));
2727: l_party_id_idx := H_PARTY_ID.COUNT+1;
2728: ELSE
2729: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2818: END IF;
2819: SAVEPOINT eval_start;
2820: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2821: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2822: 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);
2823: END IF;
2824: l_ctx_id := l_search_ctx_id;
2825: FORALL I in 1..H_PARTY_ID.COUNT
2826: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

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

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

2828: H_PARTY_ID.DELETE;
2829: H_PARTY_ID_LIST.DELETE;
2830: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2831: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2832: 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);
2833: END IF;
2834: l_ctx_id := l_search_ctx_id;
2835: FORALL I in 1..H_PARTY_ID.COUNT
2836: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2832: 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);
2833: END IF;
2834: l_ctx_id := l_search_ctx_id;
2835: FORALL I in 1..H_PARTY_ID.COUNT
2836: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2837: l_search_ctx_id,H_PARTY_ID(I));
2838: l_party_id_idx := H_PARTY_ID.COUNT+1;
2839: ELSE
2840: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3448: set_person_party_type;
3449: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3450: l_ctx_id := l_search_ctx_id;
3451: FORALL I in 1..H_PARTY_ID.COUNT
3452: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3453: l_search_ctx_id,H_PARTY_ID(I));
3454: H_PARTY_ID.DELETE;
3455: H_PARTY_ID_LIST.DELETE;
3456: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3455: H_PARTY_ID_LIST.DELETE;
3456: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3457: l_ctx_id := l_search_ctx_id;
3458: FORALL I in 1..H_PARTY_ID.COUNT
3459: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3460: l_search_ctx_id,H_PARTY_ID(I));
3461: l_party_id_idx := H_PARTY_ID.COUNT+1;
3462: ELSE
3463: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3556: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3557: FROM HZ_STAGED_CONTACTS stage
3558: WHERE contains( concat_col, p_contains_str)>0
3559: AND ORG_CONTACT_ID in (
3560: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3561: org_contact_id
3562: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3563: where d.party_id = r.subject_id
3564: and oc.party_relationship_id = r.relationship_id

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

3558: WHERE contains( concat_col, p_contains_str)>0
3559: AND ORG_CONTACT_ID in (
3560: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3561: org_contact_id
3562: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3563: where d.party_id = r.subject_id
3564: and oc.party_relationship_id = r.relationship_id
3565: and d.search_context_id = p_search_ctx_id);
3566: exception

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

3592: unset_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: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3690: SAVEPOINT eval_start;
3691: l_ctx_id := l_search_ctx_id;
3692: unset_person_party_type;
3693: FORALL I in 1..H_PARTY_ID.COUNT
3694: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3695: l_search_ctx_id,H_PARTY_ID(I));
3696: l_party_id_idx := H_PARTY_ID.COUNT+1;
3697: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3698: LOOP

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

3757: unset_person_party_type;
3758: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3759: l_ctx_id := l_search_ctx_id;
3760: FORALL I in 1..H_PARTY_ID.COUNT
3761: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3762: l_search_ctx_id,H_PARTY_ID(I));
3763: H_PARTY_ID.DELETE;
3764: H_PARTY_ID_LIST.DELETE;
3765: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3763: H_PARTY_ID.DELETE;
3764: H_PARTY_ID_LIST.DELETE;
3765: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3766: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3767: 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);
3768: END IF;
3769: l_ctx_id := l_search_ctx_id;
3770: FORALL I in 1..H_PARTY_ID.COUNT
3771: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3767: 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);
3768: END IF;
3769: l_ctx_id := l_search_ctx_id;
3770: FORALL I in 1..H_PARTY_ID.COUNT
3771: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3772: l_search_ctx_id,H_PARTY_ID(I));
3773: l_party_id_idx := H_PARTY_ID.COUNT+1;
3774: ELSE
3775: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3772: l_search_ctx_id,H_PARTY_ID(I));
3773: l_party_id_idx := H_PARTY_ID.COUNT+1;
3774: ELSE
3775: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3776: 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);
3777: END IF;
3778: l_ctx_id := NULL;
3779: l_party_id_idx := H_PARTY_ID.COUNT+1;
3780: END IF;

Line 5021: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5017: IF l_match_str = ' AND ' OR (
5018: ((l_cpt_max_score/l_entered_max_score)<(71/215))
5019: ) THEN
5020: FORALL I in 1..l_match_ps_list.COUNT
5021: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5022: values (l_search_ctx_id,l_match_ps_list(I));
5023: 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');
5024: ELSE
5025: 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 5248: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5244: IF l_match_str = ' AND ' OR (
5245: ((l_cpt_max_score/l_entered_max_score)<(71/215))
5246: ) THEN
5247: FORALL I in 1..l_match_contact_list.COUNT
5248: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5249: values (l_search_ctx_id,l_match_contact_list(I));
5250: 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');
5251: ELSE
5252: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);