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 1626: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1649: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 1850: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 1957: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1969: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 2045: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 2068: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4975: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

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

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