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

1823: END IF;
1824: IF p_person_api = 'Y' THEN
1825: OPEN x_cursor FOR
1826: 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, TX22
1827: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1828: WHERE contains( concat_col, p_contains_str)>0
1829: AND( (l_search_merged ='Y' )
1830: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1831: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

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

Line 1850: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1846: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1847: ELSE
1848: OPEN x_cursor FOR
1849: 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, TX22
1850: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1851: WHERE contains( concat_col, p_contains_str)>0
1852: AND( (l_search_merged ='Y' )
1853: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1854: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2051: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 2158: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2246: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2242: END IF;
2243: IF p_person_api = 'Y' THEN
2244: OPEN x_cursor FOR
2245: 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, TX6, TX5
2246: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2247: WHERE contains( concat_col, p_contains_str)>0
2248: AND d.search_context_id = p_search_ctx_id
2249: AND d.party_id = stage.party_id
2250: AND( (l_search_merged ='Y' )

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

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

Line 2269: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2265: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2266: ELSE
2267: OPEN x_cursor FOR
2268: 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, TX6, TX5
2269: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2270: WHERE contains( concat_col, p_contains_str)>0
2271: AND d.search_context_id = p_search_ctx_id
2272: AND d.party_id = stage.party_id
2273: AND( (l_search_merged ='Y' )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5224: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

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

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