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

Line 1218: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1214: 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);
1215: END IF;
1216: OPEN x_cursor FOR
1217: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX40, TX39
1218: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1219: WHERE contains( concat_col, p_contains_str)>0
1220: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1221: AND d.party_id = stage.party_id
1222: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1377: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1373: END IF;
1374: IF p_person_api = 'Y' THEN
1375: OPEN x_cursor FOR
1376: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1377: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1378: WHERE contains( concat_col, p_contains_str)>0
1379: AND( (l_search_merged ='Y' )
1380: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1381: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1383: AND d.party_id = stage.party_id
1384: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1385: UNION
1386: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1387: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1388: WHERE contains( concat_col, p_contains_str)>0
1389: AND( (l_search_merged ='Y' )
1390: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1391: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1400: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1396: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1397: ELSE
1398: OPEN x_cursor FOR
1399: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1400: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1401: WHERE contains( concat_col, p_contains_str)>0
1402: AND( (l_search_merged ='Y' )
1403: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1404: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1601: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1597: 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);
1598: END IF;
1599: OPEN x_cursor FOR
1600: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX22
1601: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1602: WHERE contains( concat_col, p_contains_str)>0
1603: AND d.search_context_id = p_search_ctx_id
1604: AND d.party_id = stage.party_id
1605: AND( (l_search_merged ='Y' )

Line 1708: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1704: IF p_restrict_entity = 'CONTACTS'
1705: THEN
1706: OPEN x_cursor FOR
1707: 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
1708: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1709: WHERE contains( concat_col, p_contains_str)>0
1710: AND d.search_context_id = p_search_ctx_id
1711: AND( (l_search_merged ='Y' )
1712: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1720: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1716: IF p_restrict_entity = 'PARTY_SITES'
1717: THEN
1718: OPEN x_cursor FOR
1719: 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
1720: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1721: WHERE contains( concat_col, p_contains_str)>0
1722: AND d.search_context_id = p_search_ctx_id
1723: AND( (l_search_merged ='Y' )
1724: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1796: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1792: END IF;
1793: IF p_person_api = 'Y' THEN
1794: OPEN x_cursor FOR
1795: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1796: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1797: WHERE contains( concat_col, p_contains_str)>0
1798: AND d.search_context_id = p_search_ctx_id
1799: AND d.party_id = stage.party_id
1800: AND( (l_search_merged ='Y' )

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

1802: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1803: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1804: UNION
1805: 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
1806: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1807: WHERE contains( concat_col, p_contains_str)>0
1808: AND d.search_context_id = p_search_ctx_id
1809: AND d.party_id = r.subject_id
1810: AND r.relationship_id = oc.party_relationship_id

Line 1819: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1815: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1816: ELSE
1817: OPEN x_cursor FOR
1818: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1819: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1820: WHERE contains( concat_col, p_contains_str)>0
1821: AND d.search_context_id = p_search_ctx_id
1822: AND d.party_id = stage.party_id
1823: AND( (l_search_merged ='Y' )

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

2148: SAVEPOINT eval_start;
2149: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2150: l_ctx_id := l_search_ctx_id;
2151: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2152: 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);
2153: END IF;
2154: FORALL I in 1..H_PARTY_ID.COUNT
2155: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2156: l_search_ctx_id,H_PARTY_ID(I));

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

2151: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2152: 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);
2153: END IF;
2154: FORALL I in 1..H_PARTY_ID.COUNT
2155: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2156: l_search_ctx_id,H_PARTY_ID(I));
2157: H_PARTY_ID.DELETE;
2158: H_PARTY_ID_LIST.DELETE;
2159: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2157: H_PARTY_ID.DELETE;
2158: H_PARTY_ID_LIST.DELETE;
2159: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2160: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2161: 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);
2162: END IF;
2163: l_ctx_id := l_search_ctx_id;
2164: FORALL I in 1..H_PARTY_ID.COUNT
2165: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2161: 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);
2162: END IF;
2163: l_ctx_id := l_search_ctx_id;
2164: FORALL I in 1..H_PARTY_ID.COUNT
2165: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2166: l_search_ctx_id,H_PARTY_ID(I));
2167: l_party_id_idx := H_PARTY_ID.COUNT+1;
2168: ELSE
2169: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

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

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

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

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

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

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

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

2393: END IF;
2394: SAVEPOINT eval_start;
2395: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2396: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2397: 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);
2398: END IF;
2399: l_ctx_id := l_search_ctx_id;
2400: FORALL I in 1..H_PARTY_ID.COUNT
2401: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2397: 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);
2398: END IF;
2399: l_ctx_id := l_search_ctx_id;
2400: FORALL I in 1..H_PARTY_ID.COUNT
2401: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2402: l_search_ctx_id,H_PARTY_ID(I));
2403: H_PARTY_ID.DELETE;
2404: H_PARTY_ID_LIST.DELETE;
2405: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2403: H_PARTY_ID.DELETE;
2404: H_PARTY_ID_LIST.DELETE;
2405: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2406: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2407: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2408: END IF;
2409: l_ctx_id := l_search_ctx_id;
2410: FORALL I in 1..H_PARTY_ID.COUNT
2411: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2407: hz_utility_v2pub.debug(p_message=>'Match rule is OR and call type is AND. Inserting into HZ_DQM_PARTIES_GT, from the H_PARTY_ID list',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2408: END IF;
2409: l_ctx_id := l_search_ctx_id;
2410: FORALL I in 1..H_PARTY_ID.COUNT
2411: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2412: l_search_ctx_id,H_PARTY_ID(I));
2413: l_party_id_idx := H_PARTY_ID.COUNT+1;
2414: ELSE
2415: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2504: END IF;
2505: SAVEPOINT eval_start;
2506: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2507: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2508: 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);
2509: END IF;
2510: l_ctx_id := l_search_ctx_id;
2511: FORALL I in 1..H_PARTY_ID.COUNT
2512: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2508: 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);
2509: END IF;
2510: l_ctx_id := l_search_ctx_id;
2511: FORALL I in 1..H_PARTY_ID.COUNT
2512: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2513: l_search_ctx_id,H_PARTY_ID(I));
2514: H_PARTY_ID.DELETE;
2515: H_PARTY_ID_LIST.DELETE;
2516: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2514: H_PARTY_ID.DELETE;
2515: H_PARTY_ID_LIST.DELETE;
2516: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2517: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2518: 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);
2519: END IF;
2520: l_ctx_id := l_search_ctx_id;
2521: FORALL I in 1..H_PARTY_ID.COUNT
2522: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2518: 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);
2519: END IF;
2520: l_ctx_id := l_search_ctx_id;
2521: FORALL I in 1..H_PARTY_ID.COUNT
2522: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2523: l_search_ctx_id,H_PARTY_ID(I));
2524: l_party_id_idx := H_PARTY_ID.COUNT+1;
2525: ELSE
2526: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3128: set_person_party_type;
3129: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3130: l_ctx_id := l_search_ctx_id;
3131: FORALL I in 1..H_PARTY_ID.COUNT
3132: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3133: l_search_ctx_id,H_PARTY_ID(I));
3134: H_PARTY_ID.DELETE;
3135: H_PARTY_ID_LIST.DELETE;
3136: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3135: H_PARTY_ID_LIST.DELETE;
3136: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3137: l_ctx_id := l_search_ctx_id;
3138: FORALL I in 1..H_PARTY_ID.COUNT
3139: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3140: l_search_ctx_id,H_PARTY_ID(I));
3141: l_party_id_idx := H_PARTY_ID.COUNT+1;
3142: ELSE
3143: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3236: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX22
3237: FROM HZ_STAGED_CONTACTS stage
3238: WHERE contains( concat_col, p_contains_str)>0
3239: AND ORG_CONTACT_ID in (
3240: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3241: org_contact_id
3242: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3243: where d.party_id = r.subject_id
3244: and oc.party_relationship_id = r.relationship_id

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

3238: WHERE contains( concat_col, p_contains_str)>0
3239: AND ORG_CONTACT_ID in (
3240: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3241: org_contact_id
3242: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3243: where d.party_id = r.subject_id
3244: and oc.party_relationship_id = r.relationship_id
3245: and d.search_context_id = p_search_ctx_id);
3246: exception

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

3272: unset_person_party_type;
3273: IF l_match_str = ' AND ' 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: H_PARTY_ID.DELETE;
3279: H_PARTY_ID_LIST.DELETE;
3280: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

3370: SAVEPOINT eval_start;
3371: l_ctx_id := l_search_ctx_id;
3372: unset_person_party_type;
3373: FORALL I in 1..H_PARTY_ID.COUNT
3374: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3375: l_search_ctx_id,H_PARTY_ID(I));
3376: l_party_id_idx := H_PARTY_ID.COUNT+1;
3377: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3378: LOOP

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

3437: unset_person_party_type;
3438: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3439: l_ctx_id := l_search_ctx_id;
3440: FORALL I in 1..H_PARTY_ID.COUNT
3441: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3442: l_search_ctx_id,H_PARTY_ID(I));
3443: H_PARTY_ID.DELETE;
3444: H_PARTY_ID_LIST.DELETE;
3445: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3443: H_PARTY_ID.DELETE;
3444: H_PARTY_ID_LIST.DELETE;
3445: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3446: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3447: 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);
3448: END IF;
3449: l_ctx_id := l_search_ctx_id;
3450: FORALL I in 1..H_PARTY_ID.COUNT
3451: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3447: 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);
3448: END IF;
3449: l_ctx_id := l_search_ctx_id;
3450: FORALL I in 1..H_PARTY_ID.COUNT
3451: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3452: l_search_ctx_id,H_PARTY_ID(I));
3453: l_party_id_idx := H_PARTY_ID.COUNT+1;
3454: ELSE
3455: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3452: l_search_ctx_id,H_PARTY_ID(I));
3453: l_party_id_idx := H_PARTY_ID.COUNT+1;
3454: ELSE
3455: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3456: 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);
3457: END IF;
3458: l_ctx_id := NULL;
3459: l_party_id_idx := H_PARTY_ID.COUNT+1;
3460: END IF;

Line 4704: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4700: IF l_match_str = ' AND ' OR (
4701: ((l_cpt_max_score/l_entered_max_score)<(144/180))
4702: ) THEN
4703: FORALL I in 1..l_match_ps_list.COUNT
4704: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4705: values (l_search_ctx_id,l_match_ps_list(I));
4706: 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');
4707: ELSE
4708: 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 4935: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4931: IF l_match_str = ' AND ' OR (
4932: ((l_cpt_max_score/l_entered_max_score)<(144/180))
4933: ) THEN
4934: FORALL I in 1..l_match_contact_list.COUNT
4935: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4936: values (l_search_ctx_id,l_match_contact_list(I));
4937: 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');
4938: ELSE
4939: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);