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

Line 1465: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1461: 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);
1462: END IF;
1463: OPEN x_cursor FOR
1464: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX44
1465: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1466: WHERE contains( concat_col, p_contains_str)>0
1467: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1468: AND d.party_id = stage.party_id
1469: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1624: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1620: END IF;
1621: IF p_person_api = 'Y' THEN
1622: OPEN x_cursor FOR
1623: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1624: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1625: WHERE contains( concat_col, p_contains_str)>0
1626: AND( (l_search_merged ='Y' )
1627: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1628: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1630: AND d.party_id = stage.party_id
1631: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1632: UNION
1633: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1634: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1635: WHERE contains( concat_col, p_contains_str)>0
1636: AND( (l_search_merged ='Y' )
1637: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1638: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1647: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1643: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1644: ELSE
1645: OPEN x_cursor FOR
1646: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1647: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1648: WHERE contains( concat_col, p_contains_str)>0
1649: AND( (l_search_merged ='Y' )
1650: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1651: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1848: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1844: 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);
1845: END IF;
1846: OPEN x_cursor FOR
1847: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX5, TX2
1848: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1849: WHERE contains( concat_col, p_contains_str)>0
1850: AND d.search_context_id = p_search_ctx_id
1851: AND d.party_id = stage.party_id
1852: AND( (l_search_merged ='Y' )

Line 1955: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1951: IF p_restrict_entity = 'CONTACTS'
1952: THEN
1953: OPEN x_cursor FOR
1954: 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
1955: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1956: WHERE contains( concat_col, p_contains_str)>0
1957: AND d.search_context_id = p_search_ctx_id
1958: AND( (l_search_merged ='Y' )
1959: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1967: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1963: IF p_restrict_entity = 'PARTY_SITES'
1964: THEN
1965: OPEN x_cursor FOR
1966: 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
1967: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1968: WHERE contains( concat_col, p_contains_str)>0
1969: AND d.search_context_id = p_search_ctx_id
1970: AND( (l_search_merged ='Y' )
1971: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2043: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2039: END IF;
2040: IF p_person_api = 'Y' THEN
2041: OPEN x_cursor FOR
2042: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1
2043: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2044: WHERE contains( concat_col, p_contains_str)>0
2045: AND d.search_context_id = p_search_ctx_id
2046: AND d.party_id = stage.party_id
2047: AND( (l_search_merged ='Y' )

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

2049: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2050: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2051: UNION
2052: 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
2053: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2054: WHERE contains( concat_col, p_contains_str)>0
2055: AND d.search_context_id = p_search_ctx_id
2056: AND d.party_id = r.subject_id
2057: AND r.relationship_id = oc.party_relationship_id

Line 2066: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2062: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2063: ELSE
2064: OPEN x_cursor FOR
2065: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1
2066: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2067: WHERE contains( concat_col, p_contains_str)>0
2068: AND d.search_context_id = p_search_ctx_id
2069: AND d.party_id = stage.party_id
2070: AND( (l_search_merged ='Y' )

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

2399: SAVEPOINT eval_start;
2400: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2401: l_ctx_id := l_search_ctx_id;
2402: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2403: 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);
2404: END IF;
2405: FORALL I in 1..H_PARTY_ID.COUNT
2406: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2407: l_search_ctx_id,H_PARTY_ID(I));

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

2402: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2403: 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);
2404: END IF;
2405: FORALL I in 1..H_PARTY_ID.COUNT
2406: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2407: l_search_ctx_id,H_PARTY_ID(I));
2408: H_PARTY_ID.DELETE;
2409: H_PARTY_ID_LIST.DELETE;
2410: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2408: H_PARTY_ID.DELETE;
2409: H_PARTY_ID_LIST.DELETE;
2410: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2411: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2412: 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);
2413: END IF;
2414: l_ctx_id := l_search_ctx_id;
2415: FORALL I in 1..H_PARTY_ID.COUNT
2416: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2412: 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);
2413: END IF;
2414: l_ctx_id := l_search_ctx_id;
2415: FORALL I in 1..H_PARTY_ID.COUNT
2416: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2417: l_search_ctx_id,H_PARTY_ID(I));
2418: l_party_id_idx := H_PARTY_ID.COUNT+1;
2419: ELSE
2420: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2532: END IF;
2533: SAVEPOINT eval_start;
2534: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2535: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2536: 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);
2537: END IF;
2538: l_ctx_id := l_search_ctx_id;
2539: FORALL I in 1..H_PARTY_ID.COUNT
2540: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2536: 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);
2537: END IF;
2538: l_ctx_id := l_search_ctx_id;
2539: FORALL I in 1..H_PARTY_ID.COUNT
2540: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2541: l_search_ctx_id,H_PARTY_ID(I));
2542: H_PARTY_ID.DELETE;
2543: H_PARTY_ID_LIST.DELETE;
2544: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2542: H_PARTY_ID.DELETE;
2543: H_PARTY_ID_LIST.DELETE;
2544: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2545: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2546: 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);
2547: END IF;
2548: l_ctx_id := l_search_ctx_id;
2549: FORALL I in 1..H_PARTY_ID.COUNT
2550: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2546: 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);
2547: END IF;
2548: l_ctx_id := l_search_ctx_id;
2549: FORALL I in 1..H_PARTY_ID.COUNT
2550: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2551: l_search_ctx_id,H_PARTY_ID(I));
2552: l_party_id_idx := H_PARTY_ID.COUNT+1;
2553: ELSE
2554: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2644: END IF;
2645: SAVEPOINT eval_start;
2646: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2648: 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);
2649: END IF;
2650: l_ctx_id := l_search_ctx_id;
2651: FORALL I in 1..H_PARTY_ID.COUNT
2652: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2648: 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);
2649: END IF;
2650: l_ctx_id := l_search_ctx_id;
2651: FORALL I in 1..H_PARTY_ID.COUNT
2652: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2653: l_search_ctx_id,H_PARTY_ID(I));
2654: H_PARTY_ID.DELETE;
2655: H_PARTY_ID_LIST.DELETE;
2656: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2654: H_PARTY_ID.DELETE;
2655: H_PARTY_ID_LIST.DELETE;
2656: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2657: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2658: 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);
2659: END IF;
2660: l_ctx_id := l_search_ctx_id;
2661: FORALL I in 1..H_PARTY_ID.COUNT
2662: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2658: 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);
2659: END IF;
2660: l_ctx_id := l_search_ctx_id;
2661: FORALL I in 1..H_PARTY_ID.COUNT
2662: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2663: l_search_ctx_id,H_PARTY_ID(I));
2664: l_party_id_idx := H_PARTY_ID.COUNT+1;
2665: ELSE
2666: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2755: END IF;
2756: SAVEPOINT eval_start;
2757: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2758: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2759: 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);
2760: END IF;
2761: l_ctx_id := l_search_ctx_id;
2762: FORALL I in 1..H_PARTY_ID.COUNT
2763: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2759: 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);
2760: END IF;
2761: l_ctx_id := l_search_ctx_id;
2762: FORALL I in 1..H_PARTY_ID.COUNT
2763: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2764: l_search_ctx_id,H_PARTY_ID(I));
2765: H_PARTY_ID.DELETE;
2766: H_PARTY_ID_LIST.DELETE;
2767: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2765: H_PARTY_ID.DELETE;
2766: H_PARTY_ID_LIST.DELETE;
2767: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2768: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2769: 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);
2770: END IF;
2771: l_ctx_id := l_search_ctx_id;
2772: FORALL I in 1..H_PARTY_ID.COUNT
2773: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2769: 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);
2770: END IF;
2771: l_ctx_id := l_search_ctx_id;
2772: FORALL I in 1..H_PARTY_ID.COUNT
2773: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2774: l_search_ctx_id,H_PARTY_ID(I));
2775: l_party_id_idx := H_PARTY_ID.COUNT+1;
2776: ELSE
2777: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3383: set_person_party_type;
3384: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3385: l_ctx_id := l_search_ctx_id;
3386: FORALL I in 1..H_PARTY_ID.COUNT
3387: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3388: l_search_ctx_id,H_PARTY_ID(I));
3389: H_PARTY_ID.DELETE;
3390: H_PARTY_ID_LIST.DELETE;
3391: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3390: H_PARTY_ID_LIST.DELETE;
3391: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3392: l_ctx_id := l_search_ctx_id;
3393: FORALL I in 1..H_PARTY_ID.COUNT
3394: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3395: l_search_ctx_id,H_PARTY_ID(I));
3396: l_party_id_idx := H_PARTY_ID.COUNT+1;
3397: ELSE
3398: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3491: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX5, TX2
3492: FROM HZ_STAGED_CONTACTS stage
3493: WHERE contains( concat_col, p_contains_str)>0
3494: AND ORG_CONTACT_ID in (
3495: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3496: org_contact_id
3497: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3498: where d.party_id = r.subject_id
3499: and oc.party_relationship_id = r.relationship_id

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

3493: WHERE contains( concat_col, p_contains_str)>0
3494: AND ORG_CONTACT_ID in (
3495: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3496: org_contact_id
3497: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3498: where d.party_id = r.subject_id
3499: and oc.party_relationship_id = r.relationship_id
3500: and d.search_context_id = p_search_ctx_id);
3501: exception

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

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

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

3534: H_PARTY_ID_LIST.DELETE;
3535: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3536: l_ctx_id := l_search_ctx_id;
3537: FORALL I in 1..H_PARTY_ID.COUNT
3538: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3539: l_search_ctx_id,H_PARTY_ID(I));
3540: l_party_id_idx := H_PARTY_ID.COUNT+1;
3541: ELSE
3542: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3625: SAVEPOINT eval_start;
3626: l_ctx_id := l_search_ctx_id;
3627: unset_person_party_type;
3628: FORALL I in 1..H_PARTY_ID.COUNT
3629: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3630: l_search_ctx_id,H_PARTY_ID(I));
3631: l_party_id_idx := H_PARTY_ID.COUNT+1;
3632: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3633: LOOP

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

3692: unset_person_party_type;
3693: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3694: l_ctx_id := l_search_ctx_id;
3695: FORALL I in 1..H_PARTY_ID.COUNT
3696: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3697: l_search_ctx_id,H_PARTY_ID(I));
3698: H_PARTY_ID.DELETE;
3699: H_PARTY_ID_LIST.DELETE;
3700: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3698: H_PARTY_ID.DELETE;
3699: H_PARTY_ID_LIST.DELETE;
3700: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3701: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3702: 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);
3703: END IF;
3704: l_ctx_id := l_search_ctx_id;
3705: FORALL I in 1..H_PARTY_ID.COUNT
3706: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3702: 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);
3703: END IF;
3704: l_ctx_id := l_search_ctx_id;
3705: FORALL I in 1..H_PARTY_ID.COUNT
3706: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3707: l_search_ctx_id,H_PARTY_ID(I));
3708: l_party_id_idx := H_PARTY_ID.COUNT+1;
3709: ELSE
3710: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3707: l_search_ctx_id,H_PARTY_ID(I));
3708: l_party_id_idx := H_PARTY_ID.COUNT+1;
3709: ELSE
3710: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3711: 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);
3712: END IF;
3713: l_ctx_id := NULL;
3714: l_party_id_idx := H_PARTY_ID.COUNT+1;
3715: END IF;

Line 4971: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4967: IF l_match_str = ' AND ' OR (
4968: ((l_cpt_max_score/l_entered_max_score)<(80/365))
4969: ) THEN
4970: FORALL I in 1..l_match_ps_list.COUNT
4971: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4972: values (l_search_ctx_id,l_match_ps_list(I));
4973: 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');
4974: ELSE
4975: 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 5201: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5197: IF l_match_str = ' AND ' OR (
5198: ((l_cpt_max_score/l_entered_max_score)<(80/365))
5199: ) THEN
5200: FORALL I in 1..l_match_contact_list.COUNT
5201: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5202: values (l_search_ctx_id,l_match_contact_list(I));
5203: 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');
5204: ELSE
5205: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);