APPS.HZ_MATCH_RULE_238 dependencies on HZ_DQM_PARTIES_GT

Line 1353: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1349: 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);
1350: END IF;
1351: OPEN x_cursor FOR
1352: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX4, TX45, TX46
1353: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1354: WHERE contains( concat_col, p_contains_str)>0
1355: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1356: AND d.party_id = stage.party_id
1357: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1514: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

1520: AND d.party_id = stage.party_id
1521: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1522: UNION
1523: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX4, TX11
1524: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1525: WHERE contains( concat_col, p_contains_str)>0
1526: AND( (l_search_merged ='Y' )
1527: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1528: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1537: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 1738: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 1845: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1857: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1933: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1929: END IF;
1930: IF p_person_api = 'Y' THEN
1931: OPEN x_cursor FOR
1932: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2
1933: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1934: WHERE contains( concat_col, p_contains_str)>0
1935: AND d.search_context_id = p_search_ctx_id
1936: AND d.party_id = stage.party_id
1937: AND( (l_search_merged ='Y' )

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

1939: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1940: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1941: UNION
1942: 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 , TX2
1943: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1944: WHERE contains( concat_col, p_contains_str)>0
1945: AND d.search_context_id = p_search_ctx_id
1946: AND d.party_id = r.subject_id
1947: AND r.relationship_id = oc.party_relationship_id

Line 1956: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1952: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1953: ELSE
1954: OPEN x_cursor FOR
1955: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX2
1956: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1957: WHERE contains( concat_col, p_contains_str)>0
1958: AND d.search_context_id = p_search_ctx_id
1959: AND d.party_id = stage.party_id
1960: AND( (l_search_merged ='Y' )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3265: set_person_party_type;
3266: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3267: l_ctx_id := l_search_ctx_id;
3268: FORALL I in 1..H_PARTY_ID.COUNT
3269: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3270: l_search_ctx_id,H_PARTY_ID(I));
3271: H_PARTY_ID.DELETE;
3272: H_PARTY_ID_LIST.DELETE;
3273: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3272: H_PARTY_ID_LIST.DELETE;
3273: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3274: l_ctx_id := l_search_ctx_id;
3275: FORALL I in 1..H_PARTY_ID.COUNT
3276: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3277: l_search_ctx_id,H_PARTY_ID(I));
3278: l_party_id_idx := H_PARTY_ID.COUNT+1;
3279: ELSE
3280: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3373: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3374: FROM HZ_STAGED_CONTACTS stage
3375: WHERE contains( concat_col, p_contains_str)>0
3376: AND ORG_CONTACT_ID in (
3377: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3378: org_contact_id
3379: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3380: where d.party_id = r.subject_id
3381: and oc.party_relationship_id = r.relationship_id

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

3375: WHERE contains( concat_col, p_contains_str)>0
3376: AND ORG_CONTACT_ID in (
3377: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3378: org_contact_id
3379: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3380: where d.party_id = r.subject_id
3381: and oc.party_relationship_id = r.relationship_id
3382: and d.search_context_id = p_search_ctx_id);
3383: exception

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

3409: unset_person_party_type;
3410: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3411: l_ctx_id := l_search_ctx_id;
3412: FORALL I in 1..H_PARTY_ID.COUNT
3413: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3414: l_search_ctx_id,H_PARTY_ID(I));
3415: H_PARTY_ID.DELETE;
3416: H_PARTY_ID_LIST.DELETE;
3417: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3416: H_PARTY_ID_LIST.DELETE;
3417: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3418: l_ctx_id := l_search_ctx_id;
3419: FORALL I in 1..H_PARTY_ID.COUNT
3420: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3421: l_search_ctx_id,H_PARTY_ID(I));
3422: l_party_id_idx := H_PARTY_ID.COUNT+1;
3423: ELSE
3424: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3507: SAVEPOINT eval_start;
3508: l_ctx_id := l_search_ctx_id;
3509: unset_person_party_type;
3510: FORALL I in 1..H_PARTY_ID.COUNT
3511: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3512: l_search_ctx_id,H_PARTY_ID(I));
3513: l_party_id_idx := H_PARTY_ID.COUNT+1;
3514: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3515: LOOP

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

3574: unset_person_party_type;
3575: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3576: l_ctx_id := l_search_ctx_id;
3577: FORALL I in 1..H_PARTY_ID.COUNT
3578: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3579: l_search_ctx_id,H_PARTY_ID(I));
3580: H_PARTY_ID.DELETE;
3581: H_PARTY_ID_LIST.DELETE;
3582: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3580: H_PARTY_ID.DELETE;
3581: H_PARTY_ID_LIST.DELETE;
3582: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3583: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3584: 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);
3585: END IF;
3586: l_ctx_id := l_search_ctx_id;
3587: FORALL I in 1..H_PARTY_ID.COUNT
3588: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3584: 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);
3585: END IF;
3586: l_ctx_id := l_search_ctx_id;
3587: FORALL I in 1..H_PARTY_ID.COUNT
3588: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3589: l_search_ctx_id,H_PARTY_ID(I));
3590: l_party_id_idx := H_PARTY_ID.COUNT+1;
3591: ELSE
3592: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3589: l_search_ctx_id,H_PARTY_ID(I));
3590: l_party_id_idx := H_PARTY_ID.COUNT+1;
3591: ELSE
3592: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3593: 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);
3594: END IF;
3595: l_ctx_id := NULL;
3596: l_party_id_idx := H_PARTY_ID.COUNT+1;
3597: END IF;

Line 4838: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4834: IF l_match_str = ' AND ' OR (
4835: ((l_cpt_max_score/l_entered_max_score)<(474/790))
4836: ) THEN
4837: FORALL I in 1..l_match_ps_list.COUNT
4838: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4839: values (l_search_ctx_id,l_match_ps_list(I));
4840: 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');
4841: ELSE
4842: 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 5066: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5062: IF l_match_str = ' AND ' OR (
5063: ((l_cpt_max_score/l_entered_max_score)<(474/790))
5064: ) THEN
5065: FORALL I in 1..l_match_contact_list.COUNT
5066: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5067: values (l_search_ctx_id,l_match_contact_list(I));
5068: 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');
5069: ELSE
5070: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);