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

Line 1493: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1489: 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);
1490: END IF;
1491: OPEN x_cursor FOR
1492: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX4, TX8, TX19, TX34, TX36, TX46
1493: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1494: WHERE contains( concat_col, p_contains_str)>0
1495: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1496: AND d.party_id = stage.party_id
1497: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1654: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1650: END IF;
1651: IF p_person_api = 'Y' THEN
1652: OPEN x_cursor FOR
1653: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1654: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1655: WHERE contains( concat_col, p_contains_str)>0
1656: AND( (l_search_merged ='Y' )
1657: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1658: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1660: AND d.party_id = stage.party_id
1661: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1662: UNION
1663: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1664: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1665: WHERE contains( concat_col, p_contains_str)>0
1666: AND( (l_search_merged ='Y' )
1667: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1668: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1677: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1673: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1674: ELSE
1675: OPEN x_cursor FOR
1676: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX4, TX10, TX14, TX22
1677: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1678: WHERE contains( concat_col, p_contains_str)>0
1679: AND( (l_search_merged ='Y' )
1680: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1681: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1878: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1874: 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);
1875: END IF;
1876: OPEN x_cursor FOR
1877: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1878: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1879: WHERE contains( concat_col, p_contains_str)>0
1880: AND d.search_context_id = p_search_ctx_id
1881: AND d.party_id = stage.party_id
1882: AND( (l_search_merged ='Y' )

Line 1985: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1981: IF p_restrict_entity = 'CONTACTS'
1982: THEN
1983: OPEN x_cursor FOR
1984: 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
1985: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1986: WHERE contains( concat_col, p_contains_str)>0
1987: AND d.search_context_id = p_search_ctx_id
1988: AND( (l_search_merged ='Y' )
1989: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1997: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1993: IF p_restrict_entity = 'PARTY_SITES'
1994: THEN
1995: OPEN x_cursor FOR
1996: 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
1997: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1998: WHERE contains( concat_col, p_contains_str)>0
1999: AND d.search_context_id = p_search_ctx_id
2000: AND( (l_search_merged ='Y' )
2001: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2073: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2069: END IF;
2070: IF p_person_api = 'Y' THEN
2071: OPEN x_cursor FOR
2072: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2073: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2074: WHERE contains( concat_col, p_contains_str)>0
2075: AND d.search_context_id = p_search_ctx_id
2076: AND d.party_id = stage.party_id
2077: AND( (l_search_merged ='Y' )

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

2079: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2080: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2081: UNION
2082: 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
2083: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2084: WHERE contains( concat_col, p_contains_str)>0
2085: AND d.search_context_id = p_search_ctx_id
2086: AND d.party_id = r.subject_id
2087: AND r.relationship_id = oc.party_relationship_id

Line 2096: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2092: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2093: ELSE
2094: OPEN x_cursor FOR
2095: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
2096: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2097: WHERE contains( concat_col, p_contains_str)>0
2098: AND d.search_context_id = p_search_ctx_id
2099: AND d.party_id = stage.party_id
2100: AND( (l_search_merged ='Y' )

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

2429: SAVEPOINT eval_start;
2430: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2431: l_ctx_id := l_search_ctx_id;
2432: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2433: 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);
2434: END IF;
2435: FORALL I in 1..H_PARTY_ID.COUNT
2436: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2437: l_search_ctx_id,H_PARTY_ID(I));

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

2432: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2433: 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);
2434: END IF;
2435: FORALL I in 1..H_PARTY_ID.COUNT
2436: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2437: l_search_ctx_id,H_PARTY_ID(I));
2438: H_PARTY_ID.DELETE;
2439: H_PARTY_ID_LIST.DELETE;
2440: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2438: H_PARTY_ID.DELETE;
2439: H_PARTY_ID_LIST.DELETE;
2440: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2441: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2442: 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);
2443: END IF;
2444: l_ctx_id := l_search_ctx_id;
2445: FORALL I in 1..H_PARTY_ID.COUNT
2446: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2442: 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);
2443: END IF;
2444: l_ctx_id := l_search_ctx_id;
2445: FORALL I in 1..H_PARTY_ID.COUNT
2446: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2447: l_search_ctx_id,H_PARTY_ID(I));
2448: l_party_id_idx := H_PARTY_ID.COUNT+1;
2449: ELSE
2450: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2562: END IF;
2563: SAVEPOINT eval_start;
2564: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2565: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2566: 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);
2567: END IF;
2568: l_ctx_id := l_search_ctx_id;
2569: FORALL I in 1..H_PARTY_ID.COUNT
2570: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2566: 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);
2567: END IF;
2568: l_ctx_id := l_search_ctx_id;
2569: FORALL I in 1..H_PARTY_ID.COUNT
2570: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2571: l_search_ctx_id,H_PARTY_ID(I));
2572: H_PARTY_ID.DELETE;
2573: H_PARTY_ID_LIST.DELETE;
2574: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2572: H_PARTY_ID.DELETE;
2573: H_PARTY_ID_LIST.DELETE;
2574: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2575: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2576: 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);
2577: END IF;
2578: l_ctx_id := l_search_ctx_id;
2579: FORALL I in 1..H_PARTY_ID.COUNT
2580: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2576: 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);
2577: END IF;
2578: l_ctx_id := l_search_ctx_id;
2579: FORALL I in 1..H_PARTY_ID.COUNT
2580: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2581: l_search_ctx_id,H_PARTY_ID(I));
2582: l_party_id_idx := H_PARTY_ID.COUNT+1;
2583: ELSE
2584: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2674: END IF;
2675: SAVEPOINT eval_start;
2676: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2677: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2678: 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);
2679: END IF;
2680: l_ctx_id := l_search_ctx_id;
2681: FORALL I in 1..H_PARTY_ID.COUNT
2682: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2678: 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);
2679: END IF;
2680: l_ctx_id := l_search_ctx_id;
2681: FORALL I in 1..H_PARTY_ID.COUNT
2682: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2683: l_search_ctx_id,H_PARTY_ID(I));
2684: H_PARTY_ID.DELETE;
2685: H_PARTY_ID_LIST.DELETE;
2686: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2684: H_PARTY_ID.DELETE;
2685: H_PARTY_ID_LIST.DELETE;
2686: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2687: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2688: 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);
2689: END IF;
2690: l_ctx_id := l_search_ctx_id;
2691: FORALL I in 1..H_PARTY_ID.COUNT
2692: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2688: 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);
2689: END IF;
2690: l_ctx_id := l_search_ctx_id;
2691: FORALL I in 1..H_PARTY_ID.COUNT
2692: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2693: l_search_ctx_id,H_PARTY_ID(I));
2694: l_party_id_idx := H_PARTY_ID.COUNT+1;
2695: ELSE
2696: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2785: END IF;
2786: SAVEPOINT eval_start;
2787: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2788: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2789: 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);
2790: END IF;
2791: l_ctx_id := l_search_ctx_id;
2792: FORALL I in 1..H_PARTY_ID.COUNT
2793: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2789: 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);
2790: END IF;
2791: l_ctx_id := l_search_ctx_id;
2792: FORALL I in 1..H_PARTY_ID.COUNT
2793: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2794: l_search_ctx_id,H_PARTY_ID(I));
2795: H_PARTY_ID.DELETE;
2796: H_PARTY_ID_LIST.DELETE;
2797: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2795: H_PARTY_ID.DELETE;
2796: H_PARTY_ID_LIST.DELETE;
2797: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2798: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2799: 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);
2800: END IF;
2801: l_ctx_id := l_search_ctx_id;
2802: FORALL I in 1..H_PARTY_ID.COUNT
2803: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2799: 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);
2800: END IF;
2801: l_ctx_id := l_search_ctx_id;
2802: FORALL I in 1..H_PARTY_ID.COUNT
2803: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2804: l_search_ctx_id,H_PARTY_ID(I));
2805: l_party_id_idx := H_PARTY_ID.COUNT+1;
2806: ELSE
2807: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3375: set_person_party_type;
3376: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3377: l_ctx_id := l_search_ctx_id;
3378: FORALL I in 1..H_PARTY_ID.COUNT
3379: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3380: l_search_ctx_id,H_PARTY_ID(I));
3381: H_PARTY_ID.DELETE;
3382: H_PARTY_ID_LIST.DELETE;
3383: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3382: H_PARTY_ID_LIST.DELETE;
3383: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3384: l_ctx_id := l_search_ctx_id;
3385: FORALL I in 1..H_PARTY_ID.COUNT
3386: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3387: l_search_ctx_id,H_PARTY_ID(I));
3388: l_party_id_idx := H_PARTY_ID.COUNT+1;
3389: ELSE
3390: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3483: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3484: FROM HZ_STAGED_CONTACTS stage
3485: WHERE contains( concat_col, p_contains_str)>0
3486: AND ORG_CONTACT_ID in (
3487: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3488: org_contact_id
3489: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3490: where d.party_id = r.subject_id
3491: and oc.party_relationship_id = r.relationship_id

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

3485: WHERE contains( concat_col, p_contains_str)>0
3486: AND ORG_CONTACT_ID in (
3487: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3488: org_contact_id
3489: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3490: where d.party_id = r.subject_id
3491: and oc.party_relationship_id = r.relationship_id
3492: and d.search_context_id = p_search_ctx_id);
3493: exception

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

3519: unset_person_party_type;
3520: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3521: l_ctx_id := l_search_ctx_id;
3522: FORALL I in 1..H_PARTY_ID.COUNT
3523: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3524: l_search_ctx_id,H_PARTY_ID(I));
3525: H_PARTY_ID.DELETE;
3526: H_PARTY_ID_LIST.DELETE;
3527: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3526: H_PARTY_ID_LIST.DELETE;
3527: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3528: l_ctx_id := l_search_ctx_id;
3529: FORALL I in 1..H_PARTY_ID.COUNT
3530: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3531: l_search_ctx_id,H_PARTY_ID(I));
3532: l_party_id_idx := H_PARTY_ID.COUNT+1;
3533: ELSE
3534: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3617: SAVEPOINT eval_start;
3618: l_ctx_id := l_search_ctx_id;
3619: unset_person_party_type;
3620: FORALL I in 1..H_PARTY_ID.COUNT
3621: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3622: l_search_ctx_id,H_PARTY_ID(I));
3623: l_party_id_idx := H_PARTY_ID.COUNT+1;
3624: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3625: LOOP

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

3684: unset_person_party_type;
3685: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
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: H_PARTY_ID.DELETE;
3691: H_PARTY_ID_LIST.DELETE;
3692: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3690: H_PARTY_ID.DELETE;
3691: H_PARTY_ID_LIST.DELETE;
3692: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3693: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3694: 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);
3695: END IF;
3696: l_ctx_id := l_search_ctx_id;
3697: FORALL I in 1..H_PARTY_ID.COUNT
3698: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3694: 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);
3695: END IF;
3696: l_ctx_id := l_search_ctx_id;
3697: FORALL I in 1..H_PARTY_ID.COUNT
3698: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3699: l_search_ctx_id,H_PARTY_ID(I));
3700: l_party_id_idx := H_PARTY_ID.COUNT+1;
3701: ELSE
3702: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3699: l_search_ctx_id,H_PARTY_ID(I));
3700: l_party_id_idx := H_PARTY_ID.COUNT+1;
3701: ELSE
3702: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3703: 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);
3704: END IF;
3705: l_ctx_id := NULL;
3706: l_party_id_idx := H_PARTY_ID.COUNT+1;
3707: END IF;

Line 4877: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4873: IF l_match_str = ' AND ' OR (
4874: ((l_cpt_max_score/l_entered_max_score)<(100/275))
4875: ) THEN
4876: FORALL I in 1..l_match_ps_list.COUNT
4877: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4878: values (l_search_ctx_id,l_match_ps_list(I));
4879: 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');
4880: ELSE
4881: 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 5104: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5100: IF l_match_str = ' AND ' OR (
5101: ((l_cpt_max_score/l_entered_max_score)<(100/275))
5102: ) THEN
5103: FORALL I in 1..l_match_contact_list.COUNT
5104: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5105: values (l_search_ctx_id,l_match_contact_list(I));
5106: 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');
5107: ELSE
5108: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);