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

Line 1441: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1437: 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);
1438: END IF;
1439: OPEN x_cursor FOR
1440: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX34, TX35, TX40, TX39, TX45
1441: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1442: WHERE contains( concat_col, p_contains_str)>0
1443: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1444: AND d.party_id = stage.party_id
1445: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1602: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1598: END IF;
1599: IF p_person_api = 'Y' THEN
1600: OPEN x_cursor FOR
1601: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1602: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1603: WHERE contains( concat_col, p_contains_str)>0
1604: AND( (l_search_merged ='Y' )
1605: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1606: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1608: AND d.party_id = stage.party_id
1609: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1610: UNION
1611: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1612: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1613: WHERE contains( concat_col, p_contains_str)>0
1614: AND( (l_search_merged ='Y' )
1615: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1616: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1625: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1621: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1622: ELSE
1623: OPEN x_cursor FOR
1624: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1625: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1626: WHERE contains( concat_col, p_contains_str)>0
1627: AND( (l_search_merged ='Y' )
1628: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1629: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1826: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1822: 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);
1823: END IF;
1824: OPEN x_cursor FOR
1825: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX22
1826: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1827: WHERE contains( concat_col, p_contains_str)>0
1828: AND d.search_context_id = p_search_ctx_id
1829: AND d.party_id = stage.party_id
1830: AND( (l_search_merged ='Y' )

Line 1933: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1929: IF p_restrict_entity = 'CONTACTS'
1930: THEN
1931: OPEN x_cursor FOR
1932: 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
1933: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1934: WHERE contains( concat_col, p_contains_str)>0
1935: AND d.search_context_id = p_search_ctx_id
1936: AND( (l_search_merged ='Y' )
1937: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1945: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1941: IF p_restrict_entity = 'PARTY_SITES'
1942: THEN
1943: OPEN x_cursor FOR
1944: 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
1945: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1946: WHERE contains( concat_col, p_contains_str)>0
1947: AND d.search_context_id = p_search_ctx_id
1948: AND( (l_search_merged ='Y' )
1949: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2021: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2017: END IF;
2018: IF p_person_api = 'Y' THEN
2019: OPEN x_cursor FOR
2020: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2021: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2022: WHERE contains( concat_col, p_contains_str)>0
2023: AND d.search_context_id = p_search_ctx_id
2024: AND d.party_id = stage.party_id
2025: AND( (l_search_merged ='Y' )

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

2027: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2028: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2029: UNION
2030: 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
2031: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2032: WHERE contains( concat_col, p_contains_str)>0
2033: AND d.search_context_id = p_search_ctx_id
2034: AND d.party_id = r.subject_id
2035: AND r.relationship_id = oc.party_relationship_id

Line 2044: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2040: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2041: ELSE
2042: OPEN x_cursor FOR
2043: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2044: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2045: WHERE contains( concat_col, p_contains_str)>0
2046: AND d.search_context_id = p_search_ctx_id
2047: AND d.party_id = stage.party_id
2048: AND( (l_search_merged ='Y' )

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

2377: SAVEPOINT eval_start;
2378: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2379: l_ctx_id := l_search_ctx_id;
2380: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2381: 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);
2382: END IF;
2383: FORALL I in 1..H_PARTY_ID.COUNT
2384: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2385: l_search_ctx_id,H_PARTY_ID(I));

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

2380: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2381: 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);
2382: END IF;
2383: FORALL I in 1..H_PARTY_ID.COUNT
2384: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2385: l_search_ctx_id,H_PARTY_ID(I));
2386: H_PARTY_ID.DELETE;
2387: H_PARTY_ID_LIST.DELETE;
2388: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2386: H_PARTY_ID.DELETE;
2387: H_PARTY_ID_LIST.DELETE;
2388: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2389: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2390: 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);
2391: END IF;
2392: l_ctx_id := l_search_ctx_id;
2393: FORALL I in 1..H_PARTY_ID.COUNT
2394: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2390: 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);
2391: END IF;
2392: l_ctx_id := l_search_ctx_id;
2393: FORALL I in 1..H_PARTY_ID.COUNT
2394: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2395: l_search_ctx_id,H_PARTY_ID(I));
2396: l_party_id_idx := H_PARTY_ID.COUNT+1;
2397: ELSE
2398: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2512: END IF;
2513: SAVEPOINT eval_start;
2514: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2515: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2516: 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);
2517: END IF;
2518: l_ctx_id := l_search_ctx_id;
2519: FORALL I in 1..H_PARTY_ID.COUNT
2520: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2516: 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);
2517: END IF;
2518: l_ctx_id := l_search_ctx_id;
2519: FORALL I in 1..H_PARTY_ID.COUNT
2520: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2521: l_search_ctx_id,H_PARTY_ID(I));
2522: H_PARTY_ID.DELETE;
2523: H_PARTY_ID_LIST.DELETE;
2524: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2522: H_PARTY_ID.DELETE;
2523: H_PARTY_ID_LIST.DELETE;
2524: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2525: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2526: 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);
2527: END IF;
2528: l_ctx_id := l_search_ctx_id;
2529: FORALL I in 1..H_PARTY_ID.COUNT
2530: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2526: 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);
2527: END IF;
2528: l_ctx_id := l_search_ctx_id;
2529: FORALL I in 1..H_PARTY_ID.COUNT
2530: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2531: l_search_ctx_id,H_PARTY_ID(I));
2532: l_party_id_idx := H_PARTY_ID.COUNT+1;
2533: ELSE
2534: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2624: END IF;
2625: SAVEPOINT eval_start;
2626: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2627: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2628: 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);
2629: END IF;
2630: l_ctx_id := l_search_ctx_id;
2631: FORALL I in 1..H_PARTY_ID.COUNT
2632: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2628: 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);
2629: END IF;
2630: l_ctx_id := l_search_ctx_id;
2631: FORALL I in 1..H_PARTY_ID.COUNT
2632: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2633: l_search_ctx_id,H_PARTY_ID(I));
2634: H_PARTY_ID.DELETE;
2635: H_PARTY_ID_LIST.DELETE;
2636: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2634: H_PARTY_ID.DELETE;
2635: H_PARTY_ID_LIST.DELETE;
2636: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2637: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2638: 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);
2639: END IF;
2640: l_ctx_id := l_search_ctx_id;
2641: FORALL I in 1..H_PARTY_ID.COUNT
2642: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2638: 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);
2639: END IF;
2640: l_ctx_id := l_search_ctx_id;
2641: FORALL I in 1..H_PARTY_ID.COUNT
2642: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2643: l_search_ctx_id,H_PARTY_ID(I));
2644: l_party_id_idx := H_PARTY_ID.COUNT+1;
2645: ELSE
2646: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2735: END IF;
2736: SAVEPOINT eval_start;
2737: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2738: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2739: 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: l_ctx_id := l_search_ctx_id;
2742: FORALL I in 1..H_PARTY_ID.COUNT
2743: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

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

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

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

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

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

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

3363: set_person_party_type;
3364: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3365: l_ctx_id := l_search_ctx_id;
3366: FORALL I in 1..H_PARTY_ID.COUNT
3367: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3368: l_search_ctx_id,H_PARTY_ID(I));
3369: H_PARTY_ID.DELETE;
3370: H_PARTY_ID_LIST.DELETE;
3371: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3370: H_PARTY_ID_LIST.DELETE;
3371: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3372: l_ctx_id := l_search_ctx_id;
3373: FORALL I in 1..H_PARTY_ID.COUNT
3374: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3375: l_search_ctx_id,H_PARTY_ID(I));
3376: l_party_id_idx := H_PARTY_ID.COUNT+1;
3377: ELSE
3378: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3473: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX22
3474: FROM HZ_STAGED_CONTACTS stage
3475: WHERE contains( concat_col, p_contains_str)>0
3476: AND ORG_CONTACT_ID in (
3477: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3478: org_contact_id
3479: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3480: where d.party_id = r.subject_id
3481: and oc.party_relationship_id = r.relationship_id

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

3475: WHERE contains( concat_col, p_contains_str)>0
3476: AND ORG_CONTACT_ID in (
3477: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3478: org_contact_id
3479: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3480: where d.party_id = r.subject_id
3481: and oc.party_relationship_id = r.relationship_id
3482: and d.search_context_id = p_search_ctx_id);
3483: exception

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

3509: unset_person_party_type;
3510: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3511: l_ctx_id := l_search_ctx_id;
3512: FORALL I in 1..H_PARTY_ID.COUNT
3513: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3514: l_search_ctx_id,H_PARTY_ID(I));
3515: H_PARTY_ID.DELETE;
3516: H_PARTY_ID_LIST.DELETE;
3517: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3516: H_PARTY_ID_LIST.DELETE;
3517: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3518: l_ctx_id := l_search_ctx_id;
3519: FORALL I in 1..H_PARTY_ID.COUNT
3520: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3521: l_search_ctx_id,H_PARTY_ID(I));
3522: l_party_id_idx := H_PARTY_ID.COUNT+1;
3523: ELSE
3524: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3607: SAVEPOINT eval_start;
3608: l_ctx_id := l_search_ctx_id;
3609: unset_person_party_type;
3610: FORALL I in 1..H_PARTY_ID.COUNT
3611: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3612: l_search_ctx_id,H_PARTY_ID(I));
3613: l_party_id_idx := H_PARTY_ID.COUNT+1;
3614: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3615: LOOP

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

3674: unset_person_party_type;
3675: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3676: l_ctx_id := l_search_ctx_id;
3677: FORALL I in 1..H_PARTY_ID.COUNT
3678: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3679: l_search_ctx_id,H_PARTY_ID(I));
3680: H_PARTY_ID.DELETE;
3681: H_PARTY_ID_LIST.DELETE;
3682: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3680: H_PARTY_ID.DELETE;
3681: H_PARTY_ID_LIST.DELETE;
3682: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3683: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3684: 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);
3685: END IF;
3686: l_ctx_id := l_search_ctx_id;
3687: FORALL I in 1..H_PARTY_ID.COUNT
3688: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3684: 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);
3685: END IF;
3686: l_ctx_id := l_search_ctx_id;
3687: FORALL I in 1..H_PARTY_ID.COUNT
3688: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3689: l_search_ctx_id,H_PARTY_ID(I));
3690: l_party_id_idx := H_PARTY_ID.COUNT+1;
3691: ELSE
3692: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3689: l_search_ctx_id,H_PARTY_ID(I));
3690: l_party_id_idx := H_PARTY_ID.COUNT+1;
3691: ELSE
3692: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3693: 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);
3694: END IF;
3695: l_ctx_id := NULL;
3696: l_party_id_idx := H_PARTY_ID.COUNT+1;
3697: END IF;

Line 4962: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4958: IF l_match_str = ' AND ' OR (
4959: ((l_cpt_max_score/l_entered_max_score)<(284/360))
4960: ) THEN
4961: FORALL I in 1..l_match_ps_list.COUNT
4962: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4963: values (l_search_ctx_id,l_match_ps_list(I));
4964: 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');
4965: ELSE
4966: 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 5193: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5189: IF l_match_str = ' AND ' OR (
5190: ((l_cpt_max_score/l_entered_max_score)<(284/360))
5191: ) THEN
5192: FORALL I in 1..l_match_contact_list.COUNT
5193: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5194: values (l_search_ctx_id,l_match_contact_list(I));
5195: 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');
5196: ELSE
5197: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);