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

Line 1345: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1341: 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);
1342: END IF;
1343: OPEN x_cursor FOR
1344: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX2, TX8, TX4, TX44
1345: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1346: WHERE contains( concat_col, p_contains_str)>0
1347: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1348: AND d.party_id = stage.party_id
1349: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1506: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1502: END IF;
1503: IF p_person_api = 'Y' THEN
1504: OPEN x_cursor FOR
1505: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1506: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1507: WHERE contains( concat_col, p_contains_str)>0
1508: AND( (l_search_merged ='Y' )
1509: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1510: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1512: AND d.party_id = stage.party_id
1513: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1514: UNION
1515: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1516: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1517: WHERE contains( concat_col, p_contains_str)>0
1518: AND( (l_search_merged ='Y' )
1519: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1520: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1529: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1525: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1526: ELSE
1527: OPEN x_cursor FOR
1528: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1529: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1530: WHERE contains( concat_col, p_contains_str)>0
1531: AND( (l_search_merged ='Y' )
1532: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1533: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1730: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1726: 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);
1727: END IF;
1728: OPEN x_cursor FOR
1729: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1730: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1731: WHERE contains( concat_col, p_contains_str)>0
1732: AND d.search_context_id = p_search_ctx_id
1733: AND d.party_id = stage.party_id
1734: AND( (l_search_merged ='Y' )

Line 1837: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1833: IF p_restrict_entity = 'CONTACTS'
1834: THEN
1835: OPEN x_cursor FOR
1836: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1837: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1838: WHERE contains( concat_col, p_contains_str)>0
1839: AND d.search_context_id = p_search_ctx_id
1840: AND( (l_search_merged ='Y' )
1841: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1849: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1845: IF p_restrict_entity = 'PARTY_SITES'
1846: THEN
1847: OPEN x_cursor FOR
1848: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1849: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1850: WHERE contains( concat_col, p_contains_str)>0
1851: AND d.search_context_id = p_search_ctx_id
1852: AND( (l_search_merged ='Y' )
1853: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1925: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1921: END IF;
1922: IF p_person_api = 'Y' THEN
1923: OPEN x_cursor FOR
1924: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1925: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1926: WHERE contains( concat_col, p_contains_str)>0
1927: AND d.search_context_id = p_search_ctx_id
1928: AND d.party_id = stage.party_id
1929: AND( (l_search_merged ='Y' )

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

1931: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1932: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1933: UNION
1934: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
1935: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1936: WHERE contains( concat_col, p_contains_str)>0
1937: AND d.search_context_id = p_search_ctx_id
1938: AND d.party_id = r.subject_id
1939: AND r.relationship_id = oc.party_relationship_id

Line 1948: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1944: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1945: ELSE
1946: OPEN x_cursor FOR
1947: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1948: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1949: WHERE contains( concat_col, p_contains_str)>0
1950: AND d.search_context_id = p_search_ctx_id
1951: AND d.party_id = stage.party_id
1952: AND( (l_search_merged ='Y' )

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

2281: SAVEPOINT eval_start;
2282: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2283: l_ctx_id := l_search_ctx_id;
2284: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2285: 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);
2286: END IF;
2287: FORALL I in 1..H_PARTY_ID.COUNT
2288: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2289: l_search_ctx_id,H_PARTY_ID(I));

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

2284: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2285: 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);
2286: END IF;
2287: FORALL I in 1..H_PARTY_ID.COUNT
2288: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2289: l_search_ctx_id,H_PARTY_ID(I));
2290: H_PARTY_ID.DELETE;
2291: H_PARTY_ID_LIST.DELETE;
2292: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2290: H_PARTY_ID.DELETE;
2291: H_PARTY_ID_LIST.DELETE;
2292: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2293: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2294: 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);
2295: END IF;
2296: l_ctx_id := l_search_ctx_id;
2297: FORALL I in 1..H_PARTY_ID.COUNT
2298: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2294: 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);
2295: END IF;
2296: l_ctx_id := l_search_ctx_id;
2297: FORALL I in 1..H_PARTY_ID.COUNT
2298: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2299: l_search_ctx_id,H_PARTY_ID(I));
2300: l_party_id_idx := H_PARTY_ID.COUNT+1;
2301: ELSE
2302: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2414: END IF;
2415: SAVEPOINT eval_start;
2416: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2417: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2418: 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);
2419: END IF;
2420: l_ctx_id := l_search_ctx_id;
2421: FORALL I in 1..H_PARTY_ID.COUNT
2422: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2418: 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);
2419: END IF;
2420: l_ctx_id := l_search_ctx_id;
2421: FORALL I in 1..H_PARTY_ID.COUNT
2422: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2423: l_search_ctx_id,H_PARTY_ID(I));
2424: H_PARTY_ID.DELETE;
2425: H_PARTY_ID_LIST.DELETE;
2426: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2424: H_PARTY_ID.DELETE;
2425: H_PARTY_ID_LIST.DELETE;
2426: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2427: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2428: 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);
2429: END IF;
2430: l_ctx_id := l_search_ctx_id;
2431: FORALL I in 1..H_PARTY_ID.COUNT
2432: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2428: 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);
2429: END IF;
2430: l_ctx_id := l_search_ctx_id;
2431: FORALL I in 1..H_PARTY_ID.COUNT
2432: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2433: l_search_ctx_id,H_PARTY_ID(I));
2434: l_party_id_idx := H_PARTY_ID.COUNT+1;
2435: ELSE
2436: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2526: END IF;
2527: SAVEPOINT eval_start;
2528: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2529: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2530: 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);
2531: END IF;
2532: l_ctx_id := l_search_ctx_id;
2533: FORALL I in 1..H_PARTY_ID.COUNT
2534: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2530: 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);
2531: END IF;
2532: l_ctx_id := l_search_ctx_id;
2533: FORALL I in 1..H_PARTY_ID.COUNT
2534: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2535: l_search_ctx_id,H_PARTY_ID(I));
2536: H_PARTY_ID.DELETE;
2537: H_PARTY_ID_LIST.DELETE;
2538: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

2540: 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);
2541: END IF;
2542: l_ctx_id := l_search_ctx_id;
2543: FORALL I in 1..H_PARTY_ID.COUNT
2544: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2545: l_search_ctx_id,H_PARTY_ID(I));
2546: l_party_id_idx := H_PARTY_ID.COUNT+1;
2547: ELSE
2548: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2637: END IF;
2638: SAVEPOINT eval_start;
2639: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2641: 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);
2642: END IF;
2643: l_ctx_id := l_search_ctx_id;
2644: FORALL I in 1..H_PARTY_ID.COUNT
2645: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2641: 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);
2642: END IF;
2643: l_ctx_id := l_search_ctx_id;
2644: FORALL I in 1..H_PARTY_ID.COUNT
2645: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2646: l_search_ctx_id,H_PARTY_ID(I));
2647: H_PARTY_ID.DELETE;
2648: H_PARTY_ID_LIST.DELETE;
2649: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2647: H_PARTY_ID.DELETE;
2648: H_PARTY_ID_LIST.DELETE;
2649: ELSIF l_match_str = ' OR ' 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 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);
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 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);
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: l_party_id_idx := H_PARTY_ID.COUNT+1;
2658: ELSE
2659: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3227: set_person_party_type;
3228: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3229: l_ctx_id := l_search_ctx_id;
3230: FORALL I in 1..H_PARTY_ID.COUNT
3231: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3232: l_search_ctx_id,H_PARTY_ID(I));
3233: H_PARTY_ID.DELETE;
3234: H_PARTY_ID_LIST.DELETE;
3235: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3234: H_PARTY_ID_LIST.DELETE;
3235: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3236: l_ctx_id := l_search_ctx_id;
3237: FORALL I in 1..H_PARTY_ID.COUNT
3238: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3239: l_search_ctx_id,H_PARTY_ID(I));
3240: l_party_id_idx := H_PARTY_ID.COUNT+1;
3241: ELSE
3242: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3335: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3336: FROM HZ_STAGED_CONTACTS stage
3337: WHERE contains( concat_col, p_contains_str)>0
3338: AND ORG_CONTACT_ID in (
3339: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3340: org_contact_id
3341: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3342: where d.party_id = r.subject_id
3343: and oc.party_relationship_id = r.relationship_id

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

3337: WHERE contains( concat_col, p_contains_str)>0
3338: AND ORG_CONTACT_ID in (
3339: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3340: org_contact_id
3341: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3342: where d.party_id = r.subject_id
3343: and oc.party_relationship_id = r.relationship_id
3344: and d.search_context_id = p_search_ctx_id);
3345: exception

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

3371: unset_person_party_type;
3372: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3373: l_ctx_id := l_search_ctx_id;
3374: FORALL I in 1..H_PARTY_ID.COUNT
3375: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3376: l_search_ctx_id,H_PARTY_ID(I));
3377: H_PARTY_ID.DELETE;
3378: H_PARTY_ID_LIST.DELETE;
3379: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3378: H_PARTY_ID_LIST.DELETE;
3379: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3380: l_ctx_id := l_search_ctx_id;
3381: FORALL I in 1..H_PARTY_ID.COUNT
3382: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3383: l_search_ctx_id,H_PARTY_ID(I));
3384: l_party_id_idx := H_PARTY_ID.COUNT+1;
3385: ELSE
3386: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3469: SAVEPOINT eval_start;
3470: l_ctx_id := l_search_ctx_id;
3471: unset_person_party_type;
3472: FORALL I in 1..H_PARTY_ID.COUNT
3473: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3474: l_search_ctx_id,H_PARTY_ID(I));
3475: l_party_id_idx := H_PARTY_ID.COUNT+1;
3476: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3477: LOOP

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

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

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

3542: H_PARTY_ID.DELETE;
3543: H_PARTY_ID_LIST.DELETE;
3544: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3545: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3546: 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);
3547: END IF;
3548: l_ctx_id := l_search_ctx_id;
3549: FORALL I in 1..H_PARTY_ID.COUNT
3550: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3546: 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);
3547: END IF;
3548: l_ctx_id := l_search_ctx_id;
3549: FORALL I in 1..H_PARTY_ID.COUNT
3550: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3551: l_search_ctx_id,H_PARTY_ID(I));
3552: l_party_id_idx := H_PARTY_ID.COUNT+1;
3553: ELSE
3554: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3551: l_search_ctx_id,H_PARTY_ID(I));
3552: l_party_id_idx := H_PARTY_ID.COUNT+1;
3553: ELSE
3554: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3555: 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);
3556: END IF;
3557: l_ctx_id := NULL;
3558: l_party_id_idx := H_PARTY_ID.COUNT+1;
3559: END IF;

Line 4751: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4747: IF l_match_str = ' AND ' OR (
4748: ((l_cpt_max_score/l_entered_max_score)<(100/360))
4749: ) THEN
4750: FORALL I in 1..l_match_ps_list.COUNT
4751: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4752: values (l_search_ctx_id,l_match_ps_list(I));
4753: 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');
4754: ELSE
4755: 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 4981: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4977: IF l_match_str = ' AND ' OR (
4978: ((l_cpt_max_score/l_entered_max_score)<(100/360))
4979: ) THEN
4980: FORALL I in 1..l_match_contact_list.COUNT
4981: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4982: values (l_search_ctx_id,l_match_contact_list(I));
4983: 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');
4984: ELSE
4985: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);