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

2048: END IF;
2049: IF p_person_api = 'Y' THEN
2050: OPEN x_cursor FOR
2051: 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
2052: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2053: WHERE contains( concat_col, p_contains_str)>0
2054: AND( (l_search_merged ='Y' )
2055: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2056: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

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

Line 2075: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2071: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2072: ELSE
2073: OPEN x_cursor FOR
2074: 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
2075: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2076: WHERE contains( concat_col, p_contains_str)>0
2077: AND( (l_search_merged ='Y' )
2078: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2079: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2276: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 2383: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2395: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2471: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2467: END IF;
2468: IF p_person_api = 'Y' THEN
2469: OPEN x_cursor FOR
2470: 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, TX8, TX7
2471: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2472: WHERE contains( concat_col, p_contains_str)>0
2473: AND d.search_context_id = p_search_ctx_id
2474: AND d.party_id = stage.party_id
2475: AND( (l_search_merged ='Y' )

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

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

Line 2494: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2490: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2491: ELSE
2492: OPEN x_cursor FOR
2493: 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, TX8, TX7
2494: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2495: WHERE contains( concat_col, p_contains_str)>0
2496: AND d.search_context_id = p_search_ctx_id
2497: AND d.party_id = stage.party_id
2498: AND( (l_search_merged ='Y' )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3081: END IF;
3082: SAVEPOINT eval_start;
3083: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
3084: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3085: 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: l_ctx_id := l_search_ctx_id;
3088: FORALL I in 1..H_PARTY_ID.COUNT
3089: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

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

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

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

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

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

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

3192: END IF;
3193: SAVEPOINT eval_start;
3194: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3195: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3196: 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: l_ctx_id := l_search_ctx_id;
3199: FORALL I in 1..H_PARTY_ID.COUNT
3200: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

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

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

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

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

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

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

3829: set_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 3840: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

3836: H_PARTY_ID_LIST.DELETE;
3837: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3838: l_ctx_id := l_search_ctx_id;
3839: FORALL I in 1..H_PARTY_ID.COUNT
3840: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3841: l_search_ctx_id,H_PARTY_ID(I));
3842: l_party_id_idx := H_PARTY_ID.COUNT+1;
3843: ELSE
3844: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3937: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3938: FROM HZ_STAGED_CONTACTS stage
3939: WHERE contains( concat_col, p_contains_str)>0
3940: AND ORG_CONTACT_ID in (
3941: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3942: org_contact_id
3943: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3944: where d.party_id = r.subject_id
3945: and oc.party_relationship_id = r.relationship_id

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

3939: WHERE contains( concat_col, p_contains_str)>0
3940: AND ORG_CONTACT_ID in (
3941: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3942: org_contact_id
3943: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3944: where d.party_id = r.subject_id
3945: and oc.party_relationship_id = r.relationship_id
3946: and d.search_context_id = p_search_ctx_id);
3947: exception

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

3973: unset_person_party_type;
3974: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3975: l_ctx_id := l_search_ctx_id;
3976: FORALL I in 1..H_PARTY_ID.COUNT
3977: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3978: l_search_ctx_id,H_PARTY_ID(I));
3979: H_PARTY_ID.DELETE;
3980: H_PARTY_ID_LIST.DELETE;
3981: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

4071: SAVEPOINT eval_start;
4072: l_ctx_id := l_search_ctx_id;
4073: unset_person_party_type;
4074: FORALL I in 1..H_PARTY_ID.COUNT
4075: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4076: l_search_ctx_id,H_PARTY_ID(I));
4077: l_party_id_idx := H_PARTY_ID.COUNT+1;
4078: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
4079: LOOP

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

4138: unset_person_party_type;
4139: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
4140: l_ctx_id := l_search_ctx_id;
4141: FORALL I in 1..H_PARTY_ID.COUNT
4142: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4143: l_search_ctx_id,H_PARTY_ID(I));
4144: H_PARTY_ID.DELETE;
4145: H_PARTY_ID_LIST.DELETE;
4146: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

4144: H_PARTY_ID.DELETE;
4145: H_PARTY_ID_LIST.DELETE;
4146: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
4147: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4148: 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);
4149: END IF;
4150: l_ctx_id := l_search_ctx_id;
4151: FORALL I in 1..H_PARTY_ID.COUNT
4152: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

4148: 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);
4149: END IF;
4150: l_ctx_id := l_search_ctx_id;
4151: FORALL I in 1..H_PARTY_ID.COUNT
4152: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
4153: l_search_ctx_id,H_PARTY_ID(I));
4154: l_party_id_idx := H_PARTY_ID.COUNT+1;
4155: ELSE
4156: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

4153: l_search_ctx_id,H_PARTY_ID(I));
4154: l_party_id_idx := H_PARTY_ID.COUNT+1;
4155: ELSE
4156: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4157: 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);
4158: END IF;
4159: l_ctx_id := NULL;
4160: l_party_id_idx := H_PARTY_ID.COUNT+1;
4161: END IF;

Line 5478: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5474: IF l_match_str = ' AND ' OR (
5475: ((l_cpt_max_score/l_entered_max_score)<(448/560))
5476: ) THEN
5477: FORALL I in 1..l_match_ps_list.COUNT
5478: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5479: values (l_search_ctx_id,l_match_ps_list(I));
5480: 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');
5481: ELSE
5482: 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 5708: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5704: IF l_match_str = ' AND ' OR (
5705: ((l_cpt_max_score/l_entered_max_score)<(448/560))
5706: ) THEN
5707: FORALL I in 1..l_match_contact_list.COUNT
5708: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5709: values (l_search_ctx_id,l_match_contact_list(I));
5710: 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');
5711: ELSE
5712: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);