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

Line 1358: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1354: 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);
1355: END IF;
1356: OPEN x_cursor FOR
1357: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX2, TX8, TX44
1358: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1359: WHERE contains( concat_col, p_contains_str)>0
1360: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1361: AND d.party_id = stage.party_id
1362: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1519: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1515: END IF;
1516: IF p_person_api = 'Y' THEN
1517: OPEN x_cursor FOR
1518: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1519: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1520: WHERE contains( concat_col, p_contains_str)>0
1521: AND( (l_search_merged ='Y' )
1522: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1523: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1525: AND d.party_id = stage.party_id
1526: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1527: UNION
1528: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1529: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, 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 1542: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1538: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1539: ELSE
1540: OPEN x_cursor FOR
1541: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX11
1542: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1543: WHERE contains( concat_col, p_contains_str)>0
1544: AND( (l_search_merged ='Y' )
1545: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1546: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1743: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1739: 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);
1740: END IF;
1741: OPEN x_cursor FOR
1742: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1743: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1744: WHERE contains( concat_col, p_contains_str)>0
1745: AND d.search_context_id = p_search_ctx_id
1746: AND d.party_id = stage.party_id
1747: AND( (l_search_merged ='Y' )

Line 1850: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1846: IF p_restrict_entity = 'CONTACTS'
1847: THEN
1848: OPEN x_cursor FOR
1849: 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
1850: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1851: WHERE contains( concat_col, p_contains_str)>0
1852: AND d.search_context_id = p_search_ctx_id
1853: AND( (l_search_merged ='Y' )
1854: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1862: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1858: IF p_restrict_entity = 'PARTY_SITES'
1859: THEN
1860: OPEN x_cursor FOR
1861: 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
1862: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1863: WHERE contains( concat_col, p_contains_str)>0
1864: AND d.search_context_id = p_search_ctx_id
1865: AND( (l_search_merged ='Y' )
1866: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1938: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1934: END IF;
1935: IF p_person_api = 'Y' THEN
1936: OPEN x_cursor FOR
1937: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1938: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1939: WHERE contains( concat_col, p_contains_str)>0
1940: AND d.search_context_id = p_search_ctx_id
1941: AND d.party_id = stage.party_id
1942: AND( (l_search_merged ='Y' )

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

1944: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1945: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1946: UNION
1947: 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
1948: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, 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 = r.subject_id
1952: AND r.relationship_id = oc.party_relationship_id

Line 1961: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1957: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1958: ELSE
1959: OPEN x_cursor FOR
1960: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1961: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1962: WHERE contains( concat_col, p_contains_str)>0
1963: AND d.search_context_id = p_search_ctx_id
1964: AND d.party_id = stage.party_id
1965: AND( (l_search_merged ='Y' )

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

2294: SAVEPOINT eval_start;
2295: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2296: l_ctx_id := l_search_ctx_id;
2297: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2298: 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);
2299: END IF;
2300: FORALL I in 1..H_PARTY_ID.COUNT
2301: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2302: l_search_ctx_id,H_PARTY_ID(I));

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

2297: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2298: 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);
2299: END IF;
2300: FORALL I in 1..H_PARTY_ID.COUNT
2301: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2302: l_search_ctx_id,H_PARTY_ID(I));
2303: H_PARTY_ID.DELETE;
2304: H_PARTY_ID_LIST.DELETE;
2305: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2303: H_PARTY_ID.DELETE;
2304: H_PARTY_ID_LIST.DELETE;
2305: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2306: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2307: 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);
2308: END IF;
2309: l_ctx_id := l_search_ctx_id;
2310: FORALL I in 1..H_PARTY_ID.COUNT
2311: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2307: 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);
2308: END IF;
2309: l_ctx_id := l_search_ctx_id;
2310: FORALL I in 1..H_PARTY_ID.COUNT
2311: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2312: l_search_ctx_id,H_PARTY_ID(I));
2313: l_party_id_idx := H_PARTY_ID.COUNT+1;
2314: ELSE
2315: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3278: set_person_party_type;
3279: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3280: l_ctx_id := l_search_ctx_id;
3281: FORALL I in 1..H_PARTY_ID.COUNT
3282: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3283: l_search_ctx_id,H_PARTY_ID(I));
3284: H_PARTY_ID.DELETE;
3285: H_PARTY_ID_LIST.DELETE;
3286: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3285: H_PARTY_ID_LIST.DELETE;
3286: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3287: l_ctx_id := l_search_ctx_id;
3288: FORALL I in 1..H_PARTY_ID.COUNT
3289: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3290: l_search_ctx_id,H_PARTY_ID(I));
3291: l_party_id_idx := H_PARTY_ID.COUNT+1;
3292: ELSE
3293: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3386: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3387: FROM HZ_STAGED_CONTACTS stage
3388: WHERE contains( concat_col, p_contains_str)>0
3389: AND ORG_CONTACT_ID in (
3390: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3391: org_contact_id
3392: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3393: where d.party_id = r.subject_id
3394: and oc.party_relationship_id = r.relationship_id

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

3388: WHERE contains( concat_col, p_contains_str)>0
3389: AND ORG_CONTACT_ID in (
3390: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3391: org_contact_id
3392: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3393: where d.party_id = r.subject_id
3394: and oc.party_relationship_id = r.relationship_id
3395: and d.search_context_id = p_search_ctx_id);
3396: exception

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

3422: unset_person_party_type;
3423: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3424: l_ctx_id := l_search_ctx_id;
3425: FORALL I in 1..H_PARTY_ID.COUNT
3426: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3427: l_search_ctx_id,H_PARTY_ID(I));
3428: H_PARTY_ID.DELETE;
3429: H_PARTY_ID_LIST.DELETE;
3430: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3429: H_PARTY_ID_LIST.DELETE;
3430: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3431: l_ctx_id := l_search_ctx_id;
3432: FORALL I in 1..H_PARTY_ID.COUNT
3433: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3434: l_search_ctx_id,H_PARTY_ID(I));
3435: l_party_id_idx := H_PARTY_ID.COUNT+1;
3436: ELSE
3437: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3520: SAVEPOINT eval_start;
3521: l_ctx_id := l_search_ctx_id;
3522: unset_person_party_type;
3523: FORALL I in 1..H_PARTY_ID.COUNT
3524: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3525: l_search_ctx_id,H_PARTY_ID(I));
3526: l_party_id_idx := H_PARTY_ID.COUNT+1;
3527: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3528: LOOP

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

3587: unset_person_party_type;
3588: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3589: l_ctx_id := l_search_ctx_id;
3590: FORALL I in 1..H_PARTY_ID.COUNT
3591: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3592: l_search_ctx_id,H_PARTY_ID(I));
3593: H_PARTY_ID.DELETE;
3594: H_PARTY_ID_LIST.DELETE;
3595: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3593: H_PARTY_ID.DELETE;
3594: H_PARTY_ID_LIST.DELETE;
3595: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3596: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3597: 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);
3598: END IF;
3599: l_ctx_id := l_search_ctx_id;
3600: FORALL I in 1..H_PARTY_ID.COUNT
3601: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3597: 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);
3598: END IF;
3599: l_ctx_id := l_search_ctx_id;
3600: FORALL I in 1..H_PARTY_ID.COUNT
3601: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3602: l_search_ctx_id,H_PARTY_ID(I));
3603: l_party_id_idx := H_PARTY_ID.COUNT+1;
3604: ELSE
3605: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3602: l_search_ctx_id,H_PARTY_ID(I));
3603: l_party_id_idx := H_PARTY_ID.COUNT+1;
3604: ELSE
3605: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3606: 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);
3607: END IF;
3608: l_ctx_id := NULL;
3609: l_party_id_idx := H_PARTY_ID.COUNT+1;
3610: END IF;

Line 4871: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4867: IF l_match_str = ' AND ' OR (
4868: ((l_cpt_max_score/l_entered_max_score)<(101/360))
4869: ) THEN
4870: FORALL I in 1..l_match_ps_list.COUNT
4871: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4872: values (l_search_ctx_id,l_match_ps_list(I));
4873: 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');
4874: ELSE
4875: 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 5101: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

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