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

Line 1668: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1664: 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);
1665: END IF;
1666: OPEN x_cursor FOR
1667: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX40, TX39
1668: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1669: WHERE contains( concat_col, p_contains_str)>0
1670: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1671: AND d.party_id = stage.party_id
1672: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1829: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1825: END IF;
1826: IF p_person_api = 'Y' THEN
1827: OPEN x_cursor FOR
1828: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
1829: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1830: WHERE contains( concat_col, p_contains_str)>0
1831: AND( (l_search_merged ='Y' )
1832: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1833: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1835: AND d.party_id = stage.party_id
1836: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1837: UNION
1838: 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, TX22
1839: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1840: WHERE contains( concat_col, p_contains_str)>0
1841: AND( (l_search_merged ='Y' )
1842: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1843: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1852: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1848: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1849: ELSE
1850: OPEN x_cursor FOR
1851: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
1852: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1853: WHERE contains( concat_col, p_contains_str)>0
1854: AND( (l_search_merged ='Y' )
1855: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1856: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2053: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2049: 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);
2050: END IF;
2051: OPEN x_cursor FOR
2052: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX22
2053: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2054: WHERE contains( concat_col, p_contains_str)>0
2055: AND d.search_context_id = p_search_ctx_id
2056: AND d.party_id = stage.party_id
2057: AND( (l_search_merged ='Y' )

Line 2160: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2156: IF p_restrict_entity = 'CONTACTS'
2157: THEN
2158: OPEN x_cursor FOR
2159: 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, TX6, TX5
2160: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2161: WHERE contains( concat_col, p_contains_str)>0
2162: AND d.search_context_id = p_search_ctx_id
2163: AND( (l_search_merged ='Y' )
2164: 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: IF p_restrict_entity = 'PARTY_SITES'
2169: THEN
2170: OPEN x_cursor FOR
2171: 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, TX6, TX5
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( (l_search_merged ='Y' )
2176: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2248: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2244: END IF;
2245: IF p_person_api = 'Y' THEN
2246: OPEN x_cursor FOR
2247: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2248: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2249: WHERE contains( concat_col, p_contains_str)>0
2250: AND d.search_context_id = p_search_ctx_id
2251: AND d.party_id = stage.party_id
2252: AND( (l_search_merged ='Y' )

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

2254: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2255: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2256: UNION
2257: 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, TX6, TX5
2258: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2259: WHERE contains( concat_col, p_contains_str)>0
2260: AND d.search_context_id = p_search_ctx_id
2261: AND d.party_id = r.subject_id
2262: AND r.relationship_id = oc.party_relationship_id

Line 2271: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2267: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2268: ELSE
2269: OPEN x_cursor FOR
2270: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2271: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2272: WHERE contains( concat_col, p_contains_str)>0
2273: AND d.search_context_id = p_search_ctx_id
2274: AND d.party_id = stage.party_id
2275: AND( (l_search_merged ='Y' )

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

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

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

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

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

2619: H_PARTY_ID.DELETE;
2620: H_PARTY_ID_LIST.DELETE;
2621: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2622: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2623: 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);
2624: END IF;
2625: l_ctx_id := l_search_ctx_id;
2626: FORALL I in 1..H_PARTY_ID.COUNT
2627: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2623: 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);
2624: END IF;
2625: l_ctx_id := l_search_ctx_id;
2626: FORALL I in 1..H_PARTY_ID.COUNT
2627: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2628: l_search_ctx_id,H_PARTY_ID(I));
2629: l_party_id_idx := H_PARTY_ID.COUNT+1;
2630: ELSE
2631: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2743: END IF;
2744: SAVEPOINT eval_start;
2745: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2746: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2747: 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);
2748: END IF;
2749: l_ctx_id := l_search_ctx_id;
2750: FORALL I in 1..H_PARTY_ID.COUNT
2751: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2747: 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);
2748: END IF;
2749: l_ctx_id := l_search_ctx_id;
2750: FORALL I in 1..H_PARTY_ID.COUNT
2751: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2752: l_search_ctx_id,H_PARTY_ID(I));
2753: H_PARTY_ID.DELETE;
2754: H_PARTY_ID_LIST.DELETE;
2755: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2753: H_PARTY_ID.DELETE;
2754: H_PARTY_ID_LIST.DELETE;
2755: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2756: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2757: 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);
2758: END IF;
2759: l_ctx_id := l_search_ctx_id;
2760: FORALL I in 1..H_PARTY_ID.COUNT
2761: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2757: 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);
2758: END IF;
2759: l_ctx_id := l_search_ctx_id;
2760: FORALL I in 1..H_PARTY_ID.COUNT
2761: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2762: l_search_ctx_id,H_PARTY_ID(I));
2763: l_party_id_idx := H_PARTY_ID.COUNT+1;
2764: ELSE
2765: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2855: END IF;
2856: SAVEPOINT eval_start;
2857: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2858: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2859: 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);
2860: END IF;
2861: l_ctx_id := l_search_ctx_id;
2862: FORALL I in 1..H_PARTY_ID.COUNT
2863: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2859: 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);
2860: END IF;
2861: l_ctx_id := l_search_ctx_id;
2862: FORALL I in 1..H_PARTY_ID.COUNT
2863: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2864: l_search_ctx_id,H_PARTY_ID(I));
2865: H_PARTY_ID.DELETE;
2866: H_PARTY_ID_LIST.DELETE;
2867: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2865: H_PARTY_ID.DELETE;
2866: H_PARTY_ID_LIST.DELETE;
2867: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2868: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2869: 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);
2870: END IF;
2871: l_ctx_id := l_search_ctx_id;
2872: FORALL I in 1..H_PARTY_ID.COUNT
2873: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2869: 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);
2870: END IF;
2871: l_ctx_id := l_search_ctx_id;
2872: FORALL I in 1..H_PARTY_ID.COUNT
2873: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2874: l_search_ctx_id,H_PARTY_ID(I));
2875: l_party_id_idx := H_PARTY_ID.COUNT+1;
2876: ELSE
2877: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2966: END IF;
2967: SAVEPOINT eval_start;
2968: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2969: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2970: 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);
2971: END IF;
2972: l_ctx_id := l_search_ctx_id;
2973: FORALL I in 1..H_PARTY_ID.COUNT
2974: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2970: 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);
2971: END IF;
2972: l_ctx_id := l_search_ctx_id;
2973: FORALL I in 1..H_PARTY_ID.COUNT
2974: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2975: l_search_ctx_id,H_PARTY_ID(I));
2976: H_PARTY_ID.DELETE;
2977: H_PARTY_ID_LIST.DELETE;
2978: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2976: H_PARTY_ID.DELETE;
2977: H_PARTY_ID_LIST.DELETE;
2978: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2979: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2980: 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);
2981: END IF;
2982: l_ctx_id := l_search_ctx_id;
2983: FORALL I in 1..H_PARTY_ID.COUNT
2984: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2980: 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);
2981: END IF;
2982: l_ctx_id := l_search_ctx_id;
2983: FORALL I in 1..H_PARTY_ID.COUNT
2984: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2985: l_search_ctx_id,H_PARTY_ID(I));
2986: l_party_id_idx := H_PARTY_ID.COUNT+1;
2987: ELSE
2988: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3600: set_person_party_type;
3601: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3602: l_ctx_id := l_search_ctx_id;
3603: FORALL I in 1..H_PARTY_ID.COUNT
3604: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3605: l_search_ctx_id,H_PARTY_ID(I));
3606: H_PARTY_ID.DELETE;
3607: H_PARTY_ID_LIST.DELETE;
3608: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3607: H_PARTY_ID_LIST.DELETE;
3608: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3609: l_ctx_id := l_search_ctx_id;
3610: FORALL I in 1..H_PARTY_ID.COUNT
3611: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3612: l_search_ctx_id,H_PARTY_ID(I));
3613: l_party_id_idx := H_PARTY_ID.COUNT+1;
3614: ELSE
3615: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3708: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX22
3709: FROM HZ_STAGED_CONTACTS stage
3710: WHERE contains( concat_col, p_contains_str)>0
3711: AND ORG_CONTACT_ID in (
3712: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3713: org_contact_id
3714: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3715: where d.party_id = r.subject_id
3716: and oc.party_relationship_id = r.relationship_id

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

3710: WHERE contains( concat_col, p_contains_str)>0
3711: AND ORG_CONTACT_ID in (
3712: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3713: org_contact_id
3714: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3715: where d.party_id = r.subject_id
3716: and oc.party_relationship_id = r.relationship_id
3717: and d.search_context_id = p_search_ctx_id);
3718: exception

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

3744: unset_person_party_type;
3745: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3746: l_ctx_id := l_search_ctx_id;
3747: FORALL I in 1..H_PARTY_ID.COUNT
3748: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3749: l_search_ctx_id,H_PARTY_ID(I));
3750: H_PARTY_ID.DELETE;
3751: H_PARTY_ID_LIST.DELETE;
3752: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3751: H_PARTY_ID_LIST.DELETE;
3752: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3753: l_ctx_id := l_search_ctx_id;
3754: FORALL I in 1..H_PARTY_ID.COUNT
3755: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3756: l_search_ctx_id,H_PARTY_ID(I));
3757: l_party_id_idx := H_PARTY_ID.COUNT+1;
3758: ELSE
3759: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3842: SAVEPOINT eval_start;
3843: l_ctx_id := l_search_ctx_id;
3844: unset_person_party_type;
3845: FORALL I in 1..H_PARTY_ID.COUNT
3846: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3847: l_search_ctx_id,H_PARTY_ID(I));
3848: l_party_id_idx := H_PARTY_ID.COUNT+1;
3849: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3850: LOOP

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

3909: unset_person_party_type;
3910: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3911: l_ctx_id := l_search_ctx_id;
3912: FORALL I in 1..H_PARTY_ID.COUNT
3913: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3914: l_search_ctx_id,H_PARTY_ID(I));
3915: H_PARTY_ID.DELETE;
3916: H_PARTY_ID_LIST.DELETE;
3917: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3915: H_PARTY_ID.DELETE;
3916: H_PARTY_ID_LIST.DELETE;
3917: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3918: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3919: 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);
3920: END IF;
3921: l_ctx_id := l_search_ctx_id;
3922: FORALL I in 1..H_PARTY_ID.COUNT
3923: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3919: 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);
3920: END IF;
3921: l_ctx_id := l_search_ctx_id;
3922: FORALL I in 1..H_PARTY_ID.COUNT
3923: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3924: l_search_ctx_id,H_PARTY_ID(I));
3925: l_party_id_idx := H_PARTY_ID.COUNT+1;
3926: ELSE
3927: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3924: l_search_ctx_id,H_PARTY_ID(I));
3925: l_party_id_idx := H_PARTY_ID.COUNT+1;
3926: ELSE
3927: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3928: 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);
3929: END IF;
3930: l_ctx_id := NULL;
3931: l_party_id_idx := H_PARTY_ID.COUNT+1;
3932: END IF;

Line 5228: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5224: IF l_match_str = ' AND ' OR (
5225: ((l_cpt_max_score/l_entered_max_score)<(269/340))
5226: ) THEN
5227: FORALL I in 1..l_match_ps_list.COUNT
5228: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5229: values (l_search_ctx_id,l_match_ps_list(I));
5230: 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');
5231: ELSE
5232: 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 5459: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5455: IF l_match_str = ' AND ' OR (
5456: ((l_cpt_max_score/l_entered_max_score)<(269/340))
5457: ) THEN
5458: FORALL I in 1..l_match_contact_list.COUNT
5459: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5460: values (l_search_ctx_id,l_match_contact_list(I));
5461: 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');
5462: ELSE
5463: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);