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

Line 1521: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1517: 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);
1518: END IF;
1519: OPEN x_cursor FOR
1520: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX2, TX8, TX4, lpad(rtrim(TX41),9,chr(48)), TX44, TX46
1521: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1522: WHERE contains( concat_col, p_contains_str)>0
1523: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1524: AND d.party_id = stage.party_id
1525: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1682: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1678: END IF;
1679: IF p_person_api = 'Y' THEN
1680: OPEN x_cursor FOR
1681: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1682: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1683: WHERE contains( concat_col, p_contains_str)>0
1684: AND( (l_search_merged ='Y' )
1685: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1686: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

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

Line 1705: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1701: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1702: ELSE
1703: OPEN x_cursor FOR
1704: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1705: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1706: WHERE contains( concat_col, p_contains_str)>0
1707: AND( (l_search_merged ='Y' )
1708: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1709: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1906: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 2013: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2025: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2101: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2097: END IF;
2098: IF p_person_api = 'Y' THEN
2099: OPEN x_cursor FOR
2100: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1
2101: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2102: WHERE contains( concat_col, p_contains_str)>0
2103: AND d.search_context_id = p_search_ctx_id
2104: AND d.party_id = stage.party_id
2105: AND( (l_search_merged ='Y' )

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

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

Line 2124: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3407: set_person_party_type;
3408: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3409: l_ctx_id := l_search_ctx_id;
3410: FORALL I in 1..H_PARTY_ID.COUNT
3411: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3412: l_search_ctx_id,H_PARTY_ID(I));
3413: H_PARTY_ID.DELETE;
3414: H_PARTY_ID_LIST.DELETE;
3415: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3414: H_PARTY_ID_LIST.DELETE;
3415: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3416: l_ctx_id := l_search_ctx_id;
3417: FORALL I in 1..H_PARTY_ID.COUNT
3418: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3419: l_search_ctx_id,H_PARTY_ID(I));
3420: l_party_id_idx := H_PARTY_ID.COUNT+1;
3421: ELSE
3422: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3515: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX6, TX5
3516: FROM HZ_STAGED_CONTACTS stage
3517: WHERE contains( concat_col, p_contains_str)>0
3518: AND ORG_CONTACT_ID in (
3519: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3520: org_contact_id
3521: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3522: where d.party_id = r.subject_id
3523: and oc.party_relationship_id = r.relationship_id

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

3517: WHERE contains( concat_col, p_contains_str)>0
3518: AND ORG_CONTACT_ID in (
3519: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3520: org_contact_id
3521: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3522: where d.party_id = r.subject_id
3523: and oc.party_relationship_id = r.relationship_id
3524: and d.search_context_id = p_search_ctx_id);
3525: exception

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

3551: unset_person_party_type;
3552: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3553: l_ctx_id := l_search_ctx_id;
3554: FORALL I in 1..H_PARTY_ID.COUNT
3555: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3556: l_search_ctx_id,H_PARTY_ID(I));
3557: H_PARTY_ID.DELETE;
3558: H_PARTY_ID_LIST.DELETE;
3559: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3558: H_PARTY_ID_LIST.DELETE;
3559: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3560: l_ctx_id := l_search_ctx_id;
3561: FORALL I in 1..H_PARTY_ID.COUNT
3562: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3563: l_search_ctx_id,H_PARTY_ID(I));
3564: l_party_id_idx := H_PARTY_ID.COUNT+1;
3565: ELSE
3566: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3649: SAVEPOINT eval_start;
3650: l_ctx_id := l_search_ctx_id;
3651: unset_person_party_type;
3652: FORALL I in 1..H_PARTY_ID.COUNT
3653: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3654: l_search_ctx_id,H_PARTY_ID(I));
3655: l_party_id_idx := H_PARTY_ID.COUNT+1;
3656: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3657: LOOP

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

3716: unset_person_party_type;
3717: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3718: l_ctx_id := l_search_ctx_id;
3719: FORALL I in 1..H_PARTY_ID.COUNT
3720: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3721: l_search_ctx_id,H_PARTY_ID(I));
3722: H_PARTY_ID.DELETE;
3723: H_PARTY_ID_LIST.DELETE;
3724: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3722: H_PARTY_ID.DELETE;
3723: H_PARTY_ID_LIST.DELETE;
3724: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3725: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3726: 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);
3727: END IF;
3728: l_ctx_id := l_search_ctx_id;
3729: FORALL I in 1..H_PARTY_ID.COUNT
3730: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3726: 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);
3727: END IF;
3728: l_ctx_id := l_search_ctx_id;
3729: FORALL I in 1..H_PARTY_ID.COUNT
3730: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3731: l_search_ctx_id,H_PARTY_ID(I));
3732: l_party_id_idx := H_PARTY_ID.COUNT+1;
3733: ELSE
3734: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3731: l_search_ctx_id,H_PARTY_ID(I));
3732: l_party_id_idx := H_PARTY_ID.COUNT+1;
3733: ELSE
3734: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3735: 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);
3736: END IF;
3737: l_ctx_id := NULL;
3738: l_party_id_idx := H_PARTY_ID.COUNT+1;
3739: END IF;

Line 4926: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4922: IF l_match_str = ' AND ' OR (
4923: ((l_cpt_max_score/l_entered_max_score)<(100/445))
4924: ) THEN
4925: FORALL I in 1..l_match_ps_list.COUNT
4926: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4927: values (l_search_ctx_id,l_match_ps_list(I));
4928: 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');
4929: ELSE
4930: 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 5157: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5153: IF l_match_str = ' AND ' OR (
5154: ((l_cpt_max_score/l_entered_max_score)<(100/445))
5155: ) THEN
5156: FORALL I in 1..l_match_contact_list.COUNT
5157: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5158: values (l_search_ctx_id,l_match_contact_list(I));
5159: 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');
5160: ELSE
5161: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);