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

Line 1592: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1588: 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);
1589: END IF;
1590: OPEN x_cursor FOR
1591: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX34, TX39, TX40
1592: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1593: WHERE contains( concat_col, p_contains_str)>0
1594: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1595: AND d.party_id = stage.party_id
1596: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1753: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1749: END IF;
1750: IF p_person_api = 'Y' THEN
1751: OPEN x_cursor FOR
1752: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1753: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1754: WHERE contains( concat_col, p_contains_str)>0
1755: AND( (l_search_merged ='Y' )
1756: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1757: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1759: AND d.party_id = stage.party_id
1760: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1761: UNION
1762: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1763: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1764: WHERE contains( concat_col, p_contains_str)>0
1765: AND( (l_search_merged ='Y' )
1766: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1767: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1776: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1772: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1773: ELSE
1774: OPEN x_cursor FOR
1775: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1776: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1777: WHERE contains( concat_col, p_contains_str)>0
1778: AND( (l_search_merged ='Y' )
1779: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1780: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1977: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1973: 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);
1974: END IF;
1975: OPEN x_cursor FOR
1976: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1977: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1978: WHERE contains( concat_col, p_contains_str)>0
1979: AND d.search_context_id = p_search_ctx_id
1980: AND d.party_id = stage.party_id
1981: AND( (l_search_merged ='Y' )

Line 2084: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2080: IF p_restrict_entity = 'CONTACTS'
2081: THEN
2082: OPEN x_cursor FOR
2083: 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
2084: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2085: WHERE contains( concat_col, p_contains_str)>0
2086: AND d.search_context_id = p_search_ctx_id
2087: AND( (l_search_merged ='Y' )
2088: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2096: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2092: IF p_restrict_entity = 'PARTY_SITES'
2093: THEN
2094: OPEN x_cursor FOR
2095: 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
2096: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2097: WHERE contains( concat_col, p_contains_str)>0
2098: AND d.search_context_id = p_search_ctx_id
2099: AND( (l_search_merged ='Y' )
2100: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2172: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2168: END IF;
2169: IF p_person_api = 'Y' THEN
2170: OPEN x_cursor FOR
2171: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2172: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2173: WHERE contains( concat_col, p_contains_str)>0
2174: AND d.search_context_id = p_search_ctx_id
2175: AND d.party_id = stage.party_id
2176: AND( (l_search_merged ='Y' )

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

2178: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2179: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2180: UNION
2181: 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
2182: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2183: WHERE contains( concat_col, p_contains_str)>0
2184: AND d.search_context_id = p_search_ctx_id
2185: AND d.party_id = r.subject_id
2186: AND r.relationship_id = oc.party_relationship_id

Line 2195: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2191: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2192: ELSE
2193: OPEN x_cursor FOR
2194: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2195: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2196: WHERE contains( concat_col, p_contains_str)>0
2197: AND d.search_context_id = p_search_ctx_id
2198: AND d.party_id = stage.party_id
2199: AND( (l_search_merged ='Y' )

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

2534: SAVEPOINT eval_start;
2535: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2536: l_ctx_id := l_search_ctx_id;
2537: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2538: 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);
2539: END IF;
2540: FORALL I in 1..H_PARTY_ID.COUNT
2541: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2542: l_search_ctx_id,H_PARTY_ID(I));

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

2537: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2538: 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);
2539: END IF;
2540: FORALL I in 1..H_PARTY_ID.COUNT
2541: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2542: l_search_ctx_id,H_PARTY_ID(I));
2543: H_PARTY_ID.DELETE;
2544: H_PARTY_ID_LIST.DELETE;
2545: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2543: H_PARTY_ID.DELETE;
2544: H_PARTY_ID_LIST.DELETE;
2545: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2546: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2547: 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);
2548: END IF;
2549: l_ctx_id := l_search_ctx_id;
2550: FORALL I in 1..H_PARTY_ID.COUNT
2551: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2547: 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);
2548: END IF;
2549: l_ctx_id := l_search_ctx_id;
2550: FORALL I in 1..H_PARTY_ID.COUNT
2551: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2552: l_search_ctx_id,H_PARTY_ID(I));
2553: l_party_id_idx := H_PARTY_ID.COUNT+1;
2554: ELSE
2555: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2667: END IF;
2668: SAVEPOINT eval_start;
2669: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2670: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2671: 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);
2672: END IF;
2673: l_ctx_id := l_search_ctx_id;
2674: FORALL I in 1..H_PARTY_ID.COUNT
2675: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2671: 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);
2672: END IF;
2673: l_ctx_id := l_search_ctx_id;
2674: FORALL I in 1..H_PARTY_ID.COUNT
2675: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2676: l_search_ctx_id,H_PARTY_ID(I));
2677: H_PARTY_ID.DELETE;
2678: H_PARTY_ID_LIST.DELETE;
2679: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2677: H_PARTY_ID.DELETE;
2678: H_PARTY_ID_LIST.DELETE;
2679: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2680: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2681: 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);
2682: END IF;
2683: l_ctx_id := l_search_ctx_id;
2684: FORALL I in 1..H_PARTY_ID.COUNT
2685: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2681: 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);
2682: END IF;
2683: l_ctx_id := l_search_ctx_id;
2684: FORALL I in 1..H_PARTY_ID.COUNT
2685: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2686: l_search_ctx_id,H_PARTY_ID(I));
2687: l_party_id_idx := H_PARTY_ID.COUNT+1;
2688: ELSE
2689: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2779: END IF;
2780: SAVEPOINT eval_start;
2781: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2782: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2783: 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);
2784: END IF;
2785: l_ctx_id := l_search_ctx_id;
2786: FORALL I in 1..H_PARTY_ID.COUNT
2787: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2783: 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);
2784: END IF;
2785: l_ctx_id := l_search_ctx_id;
2786: FORALL I in 1..H_PARTY_ID.COUNT
2787: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2788: l_search_ctx_id,H_PARTY_ID(I));
2789: H_PARTY_ID.DELETE;
2790: H_PARTY_ID_LIST.DELETE;
2791: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2789: H_PARTY_ID.DELETE;
2790: H_PARTY_ID_LIST.DELETE;
2791: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2792: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2793: 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);
2794: END IF;
2795: l_ctx_id := l_search_ctx_id;
2796: FORALL I in 1..H_PARTY_ID.COUNT
2797: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2793: 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);
2794: END IF;
2795: l_ctx_id := l_search_ctx_id;
2796: FORALL I in 1..H_PARTY_ID.COUNT
2797: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2798: l_search_ctx_id,H_PARTY_ID(I));
2799: l_party_id_idx := H_PARTY_ID.COUNT+1;
2800: ELSE
2801: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2890: END IF;
2891: SAVEPOINT eval_start;
2892: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2893: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2894: 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);
2895: END IF;
2896: l_ctx_id := l_search_ctx_id;
2897: FORALL I in 1..H_PARTY_ID.COUNT
2898: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2894: 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);
2895: END IF;
2896: l_ctx_id := l_search_ctx_id;
2897: FORALL I in 1..H_PARTY_ID.COUNT
2898: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2899: l_search_ctx_id,H_PARTY_ID(I));
2900: H_PARTY_ID.DELETE;
2901: H_PARTY_ID_LIST.DELETE;
2902: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2900: H_PARTY_ID.DELETE;
2901: H_PARTY_ID_LIST.DELETE;
2902: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2903: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2904: 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);
2905: END IF;
2906: l_ctx_id := l_search_ctx_id;
2907: FORALL I in 1..H_PARTY_ID.COUNT
2908: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2904: 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);
2905: END IF;
2906: l_ctx_id := l_search_ctx_id;
2907: FORALL I in 1..H_PARTY_ID.COUNT
2908: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2909: l_search_ctx_id,H_PARTY_ID(I));
2910: l_party_id_idx := H_PARTY_ID.COUNT+1;
2911: ELSE
2912: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3524: set_person_party_type;
3525: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3526: l_ctx_id := l_search_ctx_id;
3527: FORALL I in 1..H_PARTY_ID.COUNT
3528: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3529: l_search_ctx_id,H_PARTY_ID(I));
3530: H_PARTY_ID.DELETE;
3531: H_PARTY_ID_LIST.DELETE;
3532: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3531: H_PARTY_ID_LIST.DELETE;
3532: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3533: l_ctx_id := l_search_ctx_id;
3534: FORALL I in 1..H_PARTY_ID.COUNT
3535: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3536: l_search_ctx_id,H_PARTY_ID(I));
3537: l_party_id_idx := H_PARTY_ID.COUNT+1;
3538: ELSE
3539: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3632: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3633: FROM HZ_STAGED_CONTACTS stage
3634: WHERE contains( concat_col, p_contains_str)>0
3635: AND ORG_CONTACT_ID in (
3636: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3637: org_contact_id
3638: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3639: where d.party_id = r.subject_id
3640: and oc.party_relationship_id = r.relationship_id

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

3634: WHERE contains( concat_col, p_contains_str)>0
3635: AND ORG_CONTACT_ID in (
3636: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3637: org_contact_id
3638: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3639: where d.party_id = r.subject_id
3640: and oc.party_relationship_id = r.relationship_id
3641: and d.search_context_id = p_search_ctx_id);
3642: exception

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

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

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

3675: H_PARTY_ID_LIST.DELETE;
3676: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3677: l_ctx_id := l_search_ctx_id;
3678: FORALL I in 1..H_PARTY_ID.COUNT
3679: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3680: l_search_ctx_id,H_PARTY_ID(I));
3681: l_party_id_idx := H_PARTY_ID.COUNT+1;
3682: ELSE
3683: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3766: SAVEPOINT eval_start;
3767: l_ctx_id := l_search_ctx_id;
3768: unset_person_party_type;
3769: FORALL I in 1..H_PARTY_ID.COUNT
3770: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3771: l_search_ctx_id,H_PARTY_ID(I));
3772: l_party_id_idx := H_PARTY_ID.COUNT+1;
3773: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3774: LOOP

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

3833: unset_person_party_type;
3834: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3835: l_ctx_id := l_search_ctx_id;
3836: FORALL I in 1..H_PARTY_ID.COUNT
3837: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3838: l_search_ctx_id,H_PARTY_ID(I));
3839: H_PARTY_ID.DELETE;
3840: H_PARTY_ID_LIST.DELETE;
3841: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3839: H_PARTY_ID.DELETE;
3840: H_PARTY_ID_LIST.DELETE;
3841: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3842: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3843: 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);
3844: END IF;
3845: l_ctx_id := l_search_ctx_id;
3846: FORALL I in 1..H_PARTY_ID.COUNT
3847: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3843: 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);
3844: END IF;
3845: l_ctx_id := l_search_ctx_id;
3846: FORALL I in 1..H_PARTY_ID.COUNT
3847: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3848: l_search_ctx_id,H_PARTY_ID(I));
3849: l_party_id_idx := H_PARTY_ID.COUNT+1;
3850: ELSE
3851: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3848: l_search_ctx_id,H_PARTY_ID(I));
3849: l_party_id_idx := H_PARTY_ID.COUNT+1;
3850: ELSE
3851: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3852: 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);
3853: END IF;
3854: l_ctx_id := NULL;
3855: l_party_id_idx := H_PARTY_ID.COUNT+1;
3856: END IF;

Line 5117: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5113: IF l_match_str = ' AND ' OR (
5114: ((l_cpt_max_score/l_entered_max_score)<(81/300))
5115: ) THEN
5116: FORALL I in 1..l_match_ps_list.COUNT
5117: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5118: values (l_search_ctx_id,l_match_ps_list(I));
5119: 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');
5120: ELSE
5121: 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 5344: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5340: IF l_match_str = ' AND ' OR (
5341: ((l_cpt_max_score/l_entered_max_score)<(81/300))
5342: ) THEN
5343: FORALL I in 1..l_match_contact_list.COUNT
5344: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5345: values (l_search_ctx_id,l_match_contact_list(I));
5346: 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');
5347: ELSE
5348: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);