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

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

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

1757: AND d.party_id = stage.party_id
1758: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1759: UNION
1760: 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
1761: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1762: WHERE contains( concat_col, p_contains_str)>0
1763: AND( (l_search_merged ='Y' )
1764: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1765: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1774: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 1975: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 2082: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2094: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2170: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2166: END IF;
2167: IF p_person_api = 'Y' THEN
2168: OPEN x_cursor FOR
2169: 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
2170: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2171: WHERE contains( concat_col, p_contains_str)>0
2172: AND d.search_context_id = p_search_ctx_id
2173: AND d.party_id = stage.party_id
2174: AND( (l_search_merged ='Y' )

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

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

Line 2193: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2189: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2190: ELSE
2191: OPEN x_cursor FOR
2192: 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
2193: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2194: WHERE contains( concat_col, p_contains_str)>0
2195: AND d.search_context_id = p_search_ctx_id
2196: AND d.party_id = stage.party_id
2197: AND( (l_search_merged ='Y' )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5113: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

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

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