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

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

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

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

Line 1703: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 1904: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 2011: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2023: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2099: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 2122: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2816: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

2812: END IF;
2813: SAVEPOINT eval_start;
2814: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2815: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2816: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2817: END IF;
2818: l_ctx_id := l_search_ctx_id;
2819: FORALL I in 1..H_PARTY_ID.COUNT
2820: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2816: hz_utility_v2pub.debug(p_message=>'Match rule is AND and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2817: END IF;
2818: l_ctx_id := l_search_ctx_id;
2819: FORALL I in 1..H_PARTY_ID.COUNT
2820: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2821: l_search_ctx_id,H_PARTY_ID(I));
2822: H_PARTY_ID.DELETE;
2823: H_PARTY_ID_LIST.DELETE;
2824: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4922: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

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

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