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

Line 1893: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1889: 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);
1890: END IF;
1891: OPEN x_cursor FOR
1892: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX34, TX35, TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX45
1893: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1894: WHERE contains( concat_col, p_contains_str)>0
1895: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1896: AND d.party_id = stage.party_id
1897: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 2054: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2050: END IF;
2051: IF p_person_api = 'Y' THEN
2052: OPEN x_cursor FOR
2053: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
2054: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2055: WHERE contains( concat_col, p_contains_str)>0
2056: AND( (l_search_merged ='Y' )
2057: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2058: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2060: AND d.party_id = stage.party_id
2061: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2062: UNION
2063: 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
2064: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2065: WHERE contains( concat_col, p_contains_str)>0
2066: AND( (l_search_merged ='Y' )
2067: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2068: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2077: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2073: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2074: ELSE
2075: OPEN x_cursor FOR
2076: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
2077: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2078: WHERE contains( concat_col, p_contains_str)>0
2079: AND( (l_search_merged ='Y' )
2080: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2081: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2278: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2274: 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);
2275: END IF;
2276: OPEN x_cursor FOR
2277: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
2278: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2279: WHERE contains( concat_col, p_contains_str)>0
2280: AND d.search_context_id = p_search_ctx_id
2281: AND d.party_id = stage.party_id
2282: AND( (l_search_merged ='Y' )

Line 2385: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2381: IF p_restrict_entity = 'CONTACTS'
2382: THEN
2383: OPEN x_cursor FOR
2384: 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, TX8, TX7
2385: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2386: WHERE contains( concat_col, p_contains_str)>0
2387: AND d.search_context_id = p_search_ctx_id
2388: AND( (l_search_merged ='Y' )
2389: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2397: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2393: IF p_restrict_entity = 'PARTY_SITES'
2394: THEN
2395: OPEN x_cursor FOR
2396: 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, TX8, TX7
2397: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2398: WHERE contains( concat_col, p_contains_str)>0
2399: AND d.search_context_id = p_search_ctx_id
2400: AND( (l_search_merged ='Y' )
2401: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2473: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2469: END IF;
2470: IF p_person_api = 'Y' THEN
2471: OPEN x_cursor FOR
2472: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX8, TX7
2473: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2474: WHERE contains( concat_col, p_contains_str)>0
2475: AND d.search_context_id = p_search_ctx_id
2476: AND d.party_id = stage.party_id
2477: AND( (l_search_merged ='Y' )

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

2479: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2480: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2481: UNION
2482: 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, TX8, TX7
2483: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2484: WHERE contains( concat_col, p_contains_str)>0
2485: AND d.search_context_id = p_search_ctx_id
2486: AND d.party_id = r.subject_id
2487: AND r.relationship_id = oc.party_relationship_id

Line 2496: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2492: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2493: ELSE
2494: OPEN x_cursor FOR
2495: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX8, TX7
2496: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2497: WHERE contains( concat_col, p_contains_str)>0
2498: AND d.search_context_id = p_search_ctx_id
2499: AND d.party_id = stage.party_id
2500: AND( (l_search_merged ='Y' )

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

2839: SAVEPOINT eval_start;
2840: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2841: l_ctx_id := l_search_ctx_id;
2842: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2843: 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);
2844: END IF;
2845: FORALL I in 1..H_PARTY_ID.COUNT
2846: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2847: l_search_ctx_id,H_PARTY_ID(I));

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

2842: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2843: 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);
2844: END IF;
2845: FORALL I in 1..H_PARTY_ID.COUNT
2846: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2847: l_search_ctx_id,H_PARTY_ID(I));
2848: H_PARTY_ID.DELETE;
2849: H_PARTY_ID_LIST.DELETE;
2850: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2848: H_PARTY_ID.DELETE;
2849: H_PARTY_ID_LIST.DELETE;
2850: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2851: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2852: 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);
2853: END IF;
2854: l_ctx_id := l_search_ctx_id;
2855: FORALL I in 1..H_PARTY_ID.COUNT
2856: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2852: 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);
2853: END IF;
2854: l_ctx_id := l_search_ctx_id;
2855: FORALL I in 1..H_PARTY_ID.COUNT
2856: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2857: l_search_ctx_id,H_PARTY_ID(I));
2858: l_party_id_idx := H_PARTY_ID.COUNT+1;
2859: ELSE
2860: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

2984: H_PARTY_ID.DELETE;
2985: H_PARTY_ID_LIST.DELETE;
2986: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2987: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2988: 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);
2989: END IF;
2990: l_ctx_id := l_search_ctx_id;
2991: FORALL I in 1..H_PARTY_ID.COUNT
2992: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2988: 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);
2989: END IF;
2990: l_ctx_id := l_search_ctx_id;
2991: FORALL I in 1..H_PARTY_ID.COUNT
2992: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2993: l_search_ctx_id,H_PARTY_ID(I));
2994: l_party_id_idx := H_PARTY_ID.COUNT+1;
2995: ELSE
2996: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3086: END IF;
3087: SAVEPOINT eval_start;
3088: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
3089: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3090: 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);
3091: END IF;
3092: l_ctx_id := l_search_ctx_id;
3093: FORALL I in 1..H_PARTY_ID.COUNT
3094: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3090: 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);
3091: END IF;
3092: l_ctx_id := l_search_ctx_id;
3093: FORALL I in 1..H_PARTY_ID.COUNT
3094: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3095: l_search_ctx_id,H_PARTY_ID(I));
3096: H_PARTY_ID.DELETE;
3097: H_PARTY_ID_LIST.DELETE;
3098: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3096: H_PARTY_ID.DELETE;
3097: H_PARTY_ID_LIST.DELETE;
3098: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3099: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3100: 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);
3101: END IF;
3102: l_ctx_id := l_search_ctx_id;
3103: FORALL I in 1..H_PARTY_ID.COUNT
3104: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3100: 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);
3101: END IF;
3102: l_ctx_id := l_search_ctx_id;
3103: FORALL I in 1..H_PARTY_ID.COUNT
3104: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3105: l_search_ctx_id,H_PARTY_ID(I));
3106: l_party_id_idx := H_PARTY_ID.COUNT+1;
3107: ELSE
3108: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3197: END IF;
3198: SAVEPOINT eval_start;
3199: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3200: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3201: 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);
3202: END IF;
3203: l_ctx_id := l_search_ctx_id;
3204: FORALL I in 1..H_PARTY_ID.COUNT
3205: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3201: 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);
3202: END IF;
3203: l_ctx_id := l_search_ctx_id;
3204: FORALL I in 1..H_PARTY_ID.COUNT
3205: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3206: l_search_ctx_id,H_PARTY_ID(I));
3207: H_PARTY_ID.DELETE;
3208: H_PARTY_ID_LIST.DELETE;
3209: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3207: H_PARTY_ID.DELETE;
3208: H_PARTY_ID_LIST.DELETE;
3209: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3210: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3211: 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);
3212: END IF;
3213: l_ctx_id := l_search_ctx_id;
3214: FORALL I in 1..H_PARTY_ID.COUNT
3215: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3211: 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);
3212: END IF;
3213: l_ctx_id := l_search_ctx_id;
3214: FORALL I in 1..H_PARTY_ID.COUNT
3215: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3216: l_search_ctx_id,H_PARTY_ID(I));
3217: l_party_id_idx := H_PARTY_ID.COUNT+1;
3218: ELSE
3219: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

3842: H_PARTY_ID_LIST.DELETE;
3843: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3844: l_ctx_id := l_search_ctx_id;
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: ELSE
3850: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3945: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3946: FROM HZ_STAGED_CONTACTS stage
3947: WHERE contains( concat_col, p_contains_str)>0
3948: AND ORG_CONTACT_ID in (
3949: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3950: org_contact_id
3951: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3952: where d.party_id = r.subject_id
3953: and oc.party_relationship_id = r.relationship_id

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

3947: WHERE contains( concat_col, p_contains_str)>0
3948: AND ORG_CONTACT_ID in (
3949: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3950: org_contact_id
3951: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3952: where d.party_id = r.subject_id
3953: and oc.party_relationship_id = r.relationship_id
3954: and d.search_context_id = p_search_ctx_id);
3955: exception

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

3981: unset_person_party_type;
3982: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3983: l_ctx_id := l_search_ctx_id;
3984: FORALL I in 1..H_PARTY_ID.COUNT
3985: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3986: l_search_ctx_id,H_PARTY_ID(I));
3987: H_PARTY_ID.DELETE;
3988: H_PARTY_ID_LIST.DELETE;
3989: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3988: H_PARTY_ID_LIST.DELETE;
3989: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3990: l_ctx_id := l_search_ctx_id;
3991: FORALL I in 1..H_PARTY_ID.COUNT
3992: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3993: l_search_ctx_id,H_PARTY_ID(I));
3994: l_party_id_idx := H_PARTY_ID.COUNT+1;
3995: ELSE
3996: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

4079: SAVEPOINT eval_start;
4080: l_ctx_id := l_search_ctx_id;
4081: unset_person_party_type;
4082: FORALL I in 1..H_PARTY_ID.COUNT
4083: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4084: l_search_ctx_id,H_PARTY_ID(I));
4085: l_party_id_idx := H_PARTY_ID.COUNT+1;
4086: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
4087: LOOP

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

4146: unset_person_party_type;
4147: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
4148: l_ctx_id := l_search_ctx_id;
4149: FORALL I in 1..H_PARTY_ID.COUNT
4150: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4151: l_search_ctx_id,H_PARTY_ID(I));
4152: H_PARTY_ID.DELETE;
4153: H_PARTY_ID_LIST.DELETE;
4154: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

4152: H_PARTY_ID.DELETE;
4153: H_PARTY_ID_LIST.DELETE;
4154: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
4155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4156: 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);
4157: END IF;
4158: l_ctx_id := l_search_ctx_id;
4159: FORALL I in 1..H_PARTY_ID.COUNT
4160: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

4156: 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);
4157: END IF;
4158: l_ctx_id := l_search_ctx_id;
4159: FORALL I in 1..H_PARTY_ID.COUNT
4160: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4161: l_search_ctx_id,H_PARTY_ID(I));
4162: l_party_id_idx := H_PARTY_ID.COUNT+1;
4163: ELSE
4164: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

4161: l_search_ctx_id,H_PARTY_ID(I));
4162: l_party_id_idx := H_PARTY_ID.COUNT+1;
4163: ELSE
4164: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4165: 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);
4166: END IF;
4167: l_ctx_id := NULL;
4168: l_party_id_idx := H_PARTY_ID.COUNT+1;
4169: END IF;

Line 5486: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5482: IF l_match_str = ' AND ' OR (
5483: ((l_cpt_max_score/l_entered_max_score)<(448/560))
5484: ) THEN
5485: FORALL I in 1..l_match_ps_list.COUNT
5486: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5487: values (l_search_ctx_id,l_match_ps_list(I));
5488: 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');
5489: ELSE
5490: 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 5716: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5712: IF l_match_str = ' AND ' OR (
5713: ((l_cpt_max_score/l_entered_max_score)<(448/560))
5714: ) THEN
5715: FORALL I in 1..l_match_contact_list.COUNT
5716: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5717: values (l_search_ctx_id,l_match_contact_list(I));
5718: 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');
5719: ELSE
5720: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);