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

Line 1419: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1415: 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);
1416: END IF;
1417: OPEN x_cursor FOR
1418: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID
1419: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1420: WHERE contains( concat_col, p_contains_str)>0
1421: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1422: AND d.party_id = stage.party_id
1423: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1580: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1576: END IF;
1577: IF p_person_api = 'Y' THEN
1578: OPEN x_cursor FOR
1579: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1580: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1581: WHERE contains( concat_col, p_contains_str)>0
1582: AND( (l_search_merged ='Y' )
1583: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1584: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1586: AND d.party_id = stage.party_id
1587: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1588: UNION
1589: 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, TX20, TX21, TX22
1590: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1591: WHERE contains( concat_col, p_contains_str)>0
1592: AND( (l_search_merged ='Y' )
1593: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1594: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1603: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1599: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1600: ELSE
1601: OPEN x_cursor FOR
1602: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1603: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1604: WHERE contains( concat_col, p_contains_str)>0
1605: AND( (l_search_merged ='Y' )
1606: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1607: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1804: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1800: 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);
1801: END IF;
1802: OPEN x_cursor FOR
1803: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1804: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1805: WHERE contains( concat_col, p_contains_str)>0
1806: AND d.search_context_id = p_search_ctx_id
1807: AND d.party_id = stage.party_id
1808: AND( (l_search_merged ='Y' )

Line 1911: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1907: IF p_restrict_entity = 'CONTACTS'
1908: THEN
1909: OPEN x_cursor FOR
1910: 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
1911: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1912: WHERE contains( concat_col, p_contains_str)>0
1913: AND d.search_context_id = p_search_ctx_id
1914: AND( (l_search_merged ='Y' )
1915: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1923: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1919: IF p_restrict_entity = 'PARTY_SITES'
1920: THEN
1921: OPEN x_cursor FOR
1922: 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
1923: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1924: WHERE contains( concat_col, p_contains_str)>0
1925: AND d.search_context_id = p_search_ctx_id
1926: AND( (l_search_merged ='Y' )
1927: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1999: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1995: END IF;
1996: IF p_person_api = 'Y' THEN
1997: OPEN x_cursor FOR
1998: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1999: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2000: WHERE contains( concat_col, p_contains_str)>0
2001: AND d.search_context_id = p_search_ctx_id
2002: AND d.party_id = stage.party_id
2003: AND( (l_search_merged ='Y' )

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

2005: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2006: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2007: UNION
2008: 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
2009: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2010: WHERE contains( concat_col, p_contains_str)>0
2011: AND d.search_context_id = p_search_ctx_id
2012: AND d.party_id = r.subject_id
2013: AND r.relationship_id = oc.party_relationship_id

Line 2022: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2018: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2019: ELSE
2020: OPEN x_cursor FOR
2021: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2022: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2023: WHERE contains( concat_col, p_contains_str)>0
2024: AND d.search_context_id = p_search_ctx_id
2025: AND d.party_id = stage.party_id
2026: AND( (l_search_merged ='Y' )

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

2358: SAVEPOINT eval_start;
2359: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2360: l_ctx_id := l_search_ctx_id;
2361: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2362: 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);
2363: END IF;
2364: FORALL I in 1..H_PARTY_ID.COUNT
2365: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2366: l_search_ctx_id,H_PARTY_ID(I));

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

2361: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2362: 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);
2363: END IF;
2364: FORALL I in 1..H_PARTY_ID.COUNT
2365: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2366: l_search_ctx_id,H_PARTY_ID(I));
2367: H_PARTY_ID.DELETE;
2368: H_PARTY_ID_LIST.DELETE;
2369: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2367: H_PARTY_ID.DELETE;
2368: H_PARTY_ID_LIST.DELETE;
2369: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2370: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2371: 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);
2372: END IF;
2373: l_ctx_id := l_search_ctx_id;
2374: FORALL I in 1..H_PARTY_ID.COUNT
2375: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2371: 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);
2372: END IF;
2373: l_ctx_id := l_search_ctx_id;
2374: FORALL I in 1..H_PARTY_ID.COUNT
2375: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2376: l_search_ctx_id,H_PARTY_ID(I));
2377: l_party_id_idx := H_PARTY_ID.COUNT+1;
2378: ELSE
2379: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2491: END IF;
2492: SAVEPOINT eval_start;
2493: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2494: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2495: 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);
2496: END IF;
2497: l_ctx_id := l_search_ctx_id;
2498: FORALL I in 1..H_PARTY_ID.COUNT
2499: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2495: 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);
2496: END IF;
2497: l_ctx_id := l_search_ctx_id;
2498: FORALL I in 1..H_PARTY_ID.COUNT
2499: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2500: l_search_ctx_id,H_PARTY_ID(I));
2501: H_PARTY_ID.DELETE;
2502: H_PARTY_ID_LIST.DELETE;
2503: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2501: H_PARTY_ID.DELETE;
2502: H_PARTY_ID_LIST.DELETE;
2503: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2504: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2505: 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);
2506: END IF;
2507: l_ctx_id := l_search_ctx_id;
2508: FORALL I in 1..H_PARTY_ID.COUNT
2509: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2505: 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);
2506: END IF;
2507: l_ctx_id := l_search_ctx_id;
2508: FORALL I in 1..H_PARTY_ID.COUNT
2509: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2510: l_search_ctx_id,H_PARTY_ID(I));
2511: l_party_id_idx := H_PARTY_ID.COUNT+1;
2512: ELSE
2513: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

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

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

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

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

2714: END IF;
2715: SAVEPOINT eval_start;
2716: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2717: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2718: 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);
2719: END IF;
2720: l_ctx_id := l_search_ctx_id;
2721: FORALL I in 1..H_PARTY_ID.COUNT
2722: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2718: 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);
2719: END IF;
2720: l_ctx_id := l_search_ctx_id;
2721: FORALL I in 1..H_PARTY_ID.COUNT
2722: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2723: l_search_ctx_id,H_PARTY_ID(I));
2724: H_PARTY_ID.DELETE;
2725: H_PARTY_ID_LIST.DELETE;
2726: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2724: H_PARTY_ID.DELETE;
2725: H_PARTY_ID_LIST.DELETE;
2726: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2727: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2728: 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);
2729: END IF;
2730: l_ctx_id := l_search_ctx_id;
2731: FORALL I in 1..H_PARTY_ID.COUNT
2732: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2728: 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);
2729: END IF;
2730: l_ctx_id := l_search_ctx_id;
2731: FORALL I in 1..H_PARTY_ID.COUNT
2732: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2733: l_search_ctx_id,H_PARTY_ID(I));
2734: l_party_id_idx := H_PARTY_ID.COUNT+1;
2735: ELSE
2736: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3307: set_person_party_type;
3308: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3309: l_ctx_id := l_search_ctx_id;
3310: FORALL I in 1..H_PARTY_ID.COUNT
3311: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3312: l_search_ctx_id,H_PARTY_ID(I));
3313: H_PARTY_ID.DELETE;
3314: H_PARTY_ID_LIST.DELETE;
3315: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3314: H_PARTY_ID_LIST.DELETE;
3315: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3316: l_ctx_id := l_search_ctx_id;
3317: FORALL I in 1..H_PARTY_ID.COUNT
3318: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3319: l_search_ctx_id,H_PARTY_ID(I));
3320: l_party_id_idx := H_PARTY_ID.COUNT+1;
3321: ELSE
3322: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3415: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3416: FROM HZ_STAGED_CONTACTS stage
3417: WHERE contains( concat_col, p_contains_str)>0
3418: AND ORG_CONTACT_ID in (
3419: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3420: org_contact_id
3421: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3422: where d.party_id = r.subject_id
3423: and oc.party_relationship_id = r.relationship_id

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

3417: WHERE contains( concat_col, p_contains_str)>0
3418: AND ORG_CONTACT_ID in (
3419: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3420: org_contact_id
3421: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3422: where d.party_id = r.subject_id
3423: and oc.party_relationship_id = r.relationship_id
3424: and d.search_context_id = p_search_ctx_id);
3425: exception

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

3451: unset_person_party_type;
3452: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3453: l_ctx_id := l_search_ctx_id;
3454: FORALL I in 1..H_PARTY_ID.COUNT
3455: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3456: l_search_ctx_id,H_PARTY_ID(I));
3457: H_PARTY_ID.DELETE;
3458: H_PARTY_ID_LIST.DELETE;
3459: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3458: H_PARTY_ID_LIST.DELETE;
3459: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3460: l_ctx_id := l_search_ctx_id;
3461: FORALL I in 1..H_PARTY_ID.COUNT
3462: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3463: l_search_ctx_id,H_PARTY_ID(I));
3464: l_party_id_idx := H_PARTY_ID.COUNT+1;
3465: ELSE
3466: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3549: SAVEPOINT eval_start;
3550: l_ctx_id := l_search_ctx_id;
3551: unset_person_party_type;
3552: FORALL I in 1..H_PARTY_ID.COUNT
3553: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3554: l_search_ctx_id,H_PARTY_ID(I));
3555: l_party_id_idx := H_PARTY_ID.COUNT+1;
3556: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3557: LOOP

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

3616: unset_person_party_type;
3617: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3618: l_ctx_id := l_search_ctx_id;
3619: FORALL I in 1..H_PARTY_ID.COUNT
3620: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3621: l_search_ctx_id,H_PARTY_ID(I));
3622: H_PARTY_ID.DELETE;
3623: H_PARTY_ID_LIST.DELETE;
3624: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3622: H_PARTY_ID.DELETE;
3623: H_PARTY_ID_LIST.DELETE;
3624: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3625: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3626: 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);
3627: END IF;
3628: l_ctx_id := l_search_ctx_id;
3629: FORALL I in 1..H_PARTY_ID.COUNT
3630: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3626: 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);
3627: END IF;
3628: l_ctx_id := l_search_ctx_id;
3629: FORALL I in 1..H_PARTY_ID.COUNT
3630: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3631: l_search_ctx_id,H_PARTY_ID(I));
3632: l_party_id_idx := H_PARTY_ID.COUNT+1;
3633: ELSE
3634: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3631: l_search_ctx_id,H_PARTY_ID(I));
3632: l_party_id_idx := H_PARTY_ID.COUNT+1;
3633: ELSE
3634: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3635: 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);
3636: END IF;
3637: l_ctx_id := NULL;
3638: l_party_id_idx := H_PARTY_ID.COUNT+1;
3639: END IF;

Line 4810: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4806: IF l_match_str = ' AND ' OR (
4807: ((l_cpt_max_score/l_entered_max_score)<(85/145))
4808: ) THEN
4809: FORALL I in 1..l_match_ps_list.COUNT
4810: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4811: values (l_search_ctx_id,l_match_ps_list(I));
4812: 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');
4813: ELSE
4814: 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 5037: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5033: IF l_match_str = ' AND ' OR (
5034: ((l_cpt_max_score/l_entered_max_score)<(85/145))
5035: ) THEN
5036: FORALL I in 1..l_match_contact_list.COUNT
5037: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5038: values (l_search_ctx_id,l_match_contact_list(I));
5039: 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');
5040: ELSE
5041: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);