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

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

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

1693: AND d.party_id = stage.party_id
1694: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1695: UNION
1696: 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
1697: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1698: WHERE contains( concat_col, p_contains_str)>0
1699: AND( (l_search_merged ='Y' )
1700: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1701: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1710: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 1911: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 2018: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2030: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2106: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2102: END IF;
2103: IF p_person_api = 'Y' THEN
2104: OPEN x_cursor FOR
2105: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2106: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2107: WHERE contains( concat_col, p_contains_str)>0
2108: AND d.search_context_id = p_search_ctx_id
2109: AND d.party_id = stage.party_id
2110: AND( (l_search_merged ='Y' )

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

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

Line 2129: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2125: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2126: ELSE
2127: OPEN x_cursor FOR
2128: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2129: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2130: WHERE contains( concat_col, p_contains_str)>0
2131: AND d.search_context_id = p_search_ctx_id
2132: AND d.party_id = stage.party_id
2133: AND( (l_search_merged ='Y' )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2821: END IF;
2822: SAVEPOINT eval_start;
2823: IF l_match_str = ' AND ' 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 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);
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 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);
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: H_PARTY_ID.DELETE;
2832: H_PARTY_ID_LIST.DELETE;
2833: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

3596: unset_person_party_type;
3597: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3598: l_ctx_id := l_search_ctx_id;
3599: FORALL I in 1..H_PARTY_ID.COUNT
3600: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3601: l_search_ctx_id,H_PARTY_ID(I));
3602: H_PARTY_ID.DELETE;
3603: H_PARTY_ID_LIST.DELETE;
3604: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3603: H_PARTY_ID_LIST.DELETE;
3604: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3605: l_ctx_id := l_search_ctx_id;
3606: FORALL I in 1..H_PARTY_ID.COUNT
3607: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3608: l_search_ctx_id,H_PARTY_ID(I));
3609: l_party_id_idx := H_PARTY_ID.COUNT+1;
3610: ELSE
3611: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

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

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

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

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

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

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

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

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

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

Line 5025: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

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

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