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

Line 1898: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1894: 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);
1895: END IF;
1896: OPEN x_cursor FOR
1897: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX34, TX35, TX40, TX39, TX45
1898: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1899: WHERE contains( concat_col, p_contains_str)>0
1900: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1901: AND d.party_id = stage.party_id
1902: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 2059: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

Line 2082: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 2283: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 2390: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2386: IF p_restrict_entity = 'CONTACTS'
2387: THEN
2388: OPEN x_cursor FOR
2389: 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
2390: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2391: WHERE contains( concat_col, p_contains_str)>0
2392: AND d.search_context_id = p_search_ctx_id
2393: AND( (l_search_merged ='Y' )
2394: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2402: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2398: IF p_restrict_entity = 'PARTY_SITES'
2399: THEN
2400: OPEN x_cursor FOR
2401: 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
2402: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2403: WHERE contains( concat_col, p_contains_str)>0
2404: AND d.search_context_id = p_search_ctx_id
2405: AND( (l_search_merged ='Y' )
2406: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2478: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2474: END IF;
2475: IF p_person_api = 'Y' THEN
2476: OPEN x_cursor FOR
2477: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2478: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2479: WHERE contains( concat_col, p_contains_str)>0
2480: AND d.search_context_id = p_search_ctx_id
2481: AND d.party_id = stage.party_id
2482: AND( (l_search_merged ='Y' )

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

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

Line 2501: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2497: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2498: ELSE
2499: OPEN x_cursor FOR
2500: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2501: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2502: WHERE contains( concat_col, p_contains_str)>0
2503: AND d.search_context_id = p_search_ctx_id
2504: AND d.party_id = stage.party_id
2505: AND( (l_search_merged ='Y' )

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

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

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

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

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

2852: H_PARTY_ID.DELETE;
2853: H_PARTY_ID_LIST.DELETE;
2854: ELSIF l_match_str = ' OR ' 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 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);
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 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);
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: l_party_id_idx := H_PARTY_ID.COUNT+1;
2863: ELSE
2864: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3838: set_person_party_type;
3839: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3840: l_ctx_id := l_search_ctx_id;
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: H_PARTY_ID.DELETE;
3845: H_PARTY_ID_LIST.DELETE;
3846: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3845: H_PARTY_ID_LIST.DELETE;
3846: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3847: l_ctx_id := l_search_ctx_id;
3848: FORALL I in 1..H_PARTY_ID.COUNT
3849: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3850: l_search_ctx_id,H_PARTY_ID(I));
3851: l_party_id_idx := H_PARTY_ID.COUNT+1;
3852: ELSE
3853: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5489: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5485: IF l_match_str = ' AND ' OR (
5486: ((l_cpt_max_score/l_entered_max_score)<(416/520))
5487: ) THEN
5488: FORALL I in 1..l_match_ps_list.COUNT
5489: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5490: values (l_search_ctx_id,l_match_ps_list(I));
5491: 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');
5492: ELSE
5493: 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 5720: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

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