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

Line 1398: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage

1394: 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);
1395: END IF;
1396: OPEN x_cursor FOR
1397: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , TX34, TX35, TX39, TX40, lpad(rtrim(TX41),9,chr(48)), TX45
1398: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage
1399: WHERE contains( concat_col, p_contains_str)>0
1400: AND d.SEARCH_CONTEXT_ID=p_search_ctx_id
1401: AND d.party_id = stage.party_id
1402: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = stage.TX36))

Line 1559: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1555: END IF;
1556: IF p_person_api = 'Y' THEN
1557: OPEN x_cursor FOR
1558: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1559: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1560: WHERE contains( concat_col, p_contains_str)>0
1561: AND( (l_search_merged ='Y' )
1562: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1563: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1565: AND d.party_id = stage.party_id
1566: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1567: UNION
1568: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1569: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1570: WHERE contains( concat_col, p_contains_str)>0
1571: AND( (l_search_merged ='Y' )
1572: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1573: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1582: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1578: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1579: ELSE
1580: OPEN x_cursor FOR
1581: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID
1582: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1583: WHERE contains( concat_col, p_contains_str)>0
1584: AND( (l_search_merged ='Y' )
1585: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1586: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1783: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

1779: 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);
1780: END IF;
1781: OPEN x_cursor FOR
1782: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
1783: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
1784: WHERE contains( concat_col, p_contains_str)>0
1785: AND d.search_context_id = p_search_ctx_id
1786: AND d.party_id = stage.party_id
1787: AND( (l_search_merged ='Y' )

Line 1890: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1886: IF p_restrict_entity = 'CONTACTS'
1887: THEN
1888: OPEN x_cursor FOR
1889: 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 , TX8, TX7
1890: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1891: WHERE contains( concat_col, p_contains_str)>0
1892: AND d.search_context_id = p_search_ctx_id
1893: AND( (l_search_merged ='Y' )
1894: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1902: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1898: IF p_restrict_entity = 'PARTY_SITES'
1899: THEN
1900: OPEN x_cursor FOR
1901: 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 , TX8, TX7
1902: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1903: WHERE contains( concat_col, p_contains_str)>0
1904: AND d.search_context_id = p_search_ctx_id
1905: AND( (l_search_merged ='Y' )
1906: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1978: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1974: END IF;
1975: IF p_person_api = 'Y' THEN
1976: OPEN x_cursor FOR
1977: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7
1978: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1979: WHERE contains( concat_col, p_contains_str)>0
1980: AND d.search_context_id = p_search_ctx_id
1981: AND d.party_id = stage.party_id
1982: AND( (l_search_merged ='Y' )

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

1984: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1985: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1986: UNION
1987: 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 , TX8, TX7
1988: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1989: WHERE contains( concat_col, p_contains_str)>0
1990: AND d.search_context_id = p_search_ctx_id
1991: AND d.party_id = r.subject_id
1992: AND r.relationship_id = oc.party_relationship_id

Line 2001: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1997: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1998: ELSE
1999: OPEN x_cursor FOR
2000: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX8, TX7
2001: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2002: WHERE contains( concat_col, p_contains_str)>0
2003: AND d.search_context_id = p_search_ctx_id
2004: AND d.party_id = stage.party_id
2005: AND( (l_search_merged ='Y' )

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

2333: SAVEPOINT eval_start;
2334: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2335: l_ctx_id := l_search_ctx_id;
2336: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2337: 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);
2338: END IF;
2339: FORALL I in 1..H_PARTY_ID.COUNT
2340: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2341: l_search_ctx_id,H_PARTY_ID(I));

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

2336: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2337: 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);
2338: END IF;
2339: FORALL I in 1..H_PARTY_ID.COUNT
2340: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2341: l_search_ctx_id,H_PARTY_ID(I));
2342: H_PARTY_ID.DELETE;
2343: H_PARTY_ID_LIST.DELETE;
2344: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2342: H_PARTY_ID.DELETE;
2343: H_PARTY_ID_LIST.DELETE;
2344: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2345: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2346: 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);
2347: END IF;
2348: l_ctx_id := l_search_ctx_id;
2349: FORALL I in 1..H_PARTY_ID.COUNT
2350: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2346: 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);
2347: END IF;
2348: l_ctx_id := l_search_ctx_id;
2349: FORALL I in 1..H_PARTY_ID.COUNT
2350: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2351: l_search_ctx_id,H_PARTY_ID(I));
2352: l_party_id_idx := H_PARTY_ID.COUNT+1;
2353: ELSE
2354: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2468: END IF;
2469: SAVEPOINT eval_start;
2470: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2471: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2472: 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);
2473: END IF;
2474: l_ctx_id := l_search_ctx_id;
2475: FORALL I in 1..H_PARTY_ID.COUNT
2476: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2472: 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);
2473: END IF;
2474: l_ctx_id := l_search_ctx_id;
2475: FORALL I in 1..H_PARTY_ID.COUNT
2476: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2477: l_search_ctx_id,H_PARTY_ID(I));
2478: H_PARTY_ID.DELETE;
2479: H_PARTY_ID_LIST.DELETE;
2480: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2478: H_PARTY_ID.DELETE;
2479: H_PARTY_ID_LIST.DELETE;
2480: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2481: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2482: 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);
2483: END IF;
2484: l_ctx_id := l_search_ctx_id;
2485: FORALL I in 1..H_PARTY_ID.COUNT
2486: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2482: 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);
2483: END IF;
2484: l_ctx_id := l_search_ctx_id;
2485: FORALL I in 1..H_PARTY_ID.COUNT
2486: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2487: l_search_ctx_id,H_PARTY_ID(I));
2488: l_party_id_idx := H_PARTY_ID.COUNT+1;
2489: ELSE
2490: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2580: END IF;
2581: SAVEPOINT eval_start;
2582: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2583: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2584: 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);
2585: END IF;
2586: l_ctx_id := l_search_ctx_id;
2587: FORALL I in 1..H_PARTY_ID.COUNT
2588: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2584: 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);
2585: END IF;
2586: l_ctx_id := l_search_ctx_id;
2587: FORALL I in 1..H_PARTY_ID.COUNT
2588: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2589: l_search_ctx_id,H_PARTY_ID(I));
2590: H_PARTY_ID.DELETE;
2591: H_PARTY_ID_LIST.DELETE;
2592: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2590: H_PARTY_ID.DELETE;
2591: H_PARTY_ID_LIST.DELETE;
2592: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2593: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2594: 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);
2595: END IF;
2596: l_ctx_id := l_search_ctx_id;
2597: FORALL I in 1..H_PARTY_ID.COUNT
2598: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2594: 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);
2595: END IF;
2596: l_ctx_id := l_search_ctx_id;
2597: FORALL I in 1..H_PARTY_ID.COUNT
2598: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2599: l_search_ctx_id,H_PARTY_ID(I));
2600: l_party_id_idx := H_PARTY_ID.COUNT+1;
2601: ELSE
2602: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

2691: END IF;
2692: SAVEPOINT eval_start;
2693: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2694: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2695: 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);
2696: END IF;
2697: l_ctx_id := l_search_ctx_id;
2698: FORALL I in 1..H_PARTY_ID.COUNT
2699: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2695: 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);
2696: END IF;
2697: l_ctx_id := l_search_ctx_id;
2698: FORALL I in 1..H_PARTY_ID.COUNT
2699: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2700: l_search_ctx_id,H_PARTY_ID(I));
2701: H_PARTY_ID.DELETE;
2702: H_PARTY_ID_LIST.DELETE;
2703: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

2701: H_PARTY_ID.DELETE;
2702: H_PARTY_ID_LIST.DELETE;
2703: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
2704: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2705: 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);
2706: END IF;
2707: l_ctx_id := l_search_ctx_id;
2708: FORALL I in 1..H_PARTY_ID.COUNT
2709: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

2705: 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);
2706: END IF;
2707: l_ctx_id := l_search_ctx_id;
2708: FORALL I in 1..H_PARTY_ID.COUNT
2709: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2710: l_search_ctx_id,H_PARTY_ID(I));
2711: l_party_id_idx := H_PARTY_ID.COUNT+1;
2712: ELSE
2713: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3318: set_person_party_type;
3319: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3320: l_ctx_id := l_search_ctx_id;
3321: FORALL I in 1..H_PARTY_ID.COUNT
3322: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3323: l_search_ctx_id,H_PARTY_ID(I));
3324: H_PARTY_ID.DELETE;
3325: H_PARTY_ID_LIST.DELETE;
3326: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3325: H_PARTY_ID_LIST.DELETE;
3326: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3327: l_ctx_id := l_search_ctx_id;
3328: FORALL I in 1..H_PARTY_ID.COUNT
3329: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3330: l_search_ctx_id,H_PARTY_ID(I));
3331: l_party_id_idx := H_PARTY_ID.COUNT+1;
3332: ELSE
3333: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3428: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3429: FROM HZ_STAGED_CONTACTS stage
3430: WHERE contains( concat_col, p_contains_str)>0
3431: AND ORG_CONTACT_ID in (
3432: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3433: org_contact_id
3434: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3435: where d.party_id = r.subject_id
3436: and oc.party_relationship_id = r.relationship_id

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

3430: WHERE contains( concat_col, p_contains_str)>0
3431: AND ORG_CONTACT_ID in (
3432: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3433: org_contact_id
3434: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3435: where d.party_id = r.subject_id
3436: and oc.party_relationship_id = r.relationship_id
3437: and d.search_context_id = p_search_ctx_id);
3438: exception

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

3464: unset_person_party_type;
3465: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3466: l_ctx_id := l_search_ctx_id;
3467: FORALL I in 1..H_PARTY_ID.COUNT
3468: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3469: l_search_ctx_id,H_PARTY_ID(I));
3470: H_PARTY_ID.DELETE;
3471: H_PARTY_ID_LIST.DELETE;
3472: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3471: H_PARTY_ID_LIST.DELETE;
3472: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3473: l_ctx_id := l_search_ctx_id;
3474: FORALL I in 1..H_PARTY_ID.COUNT
3475: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3476: l_search_ctx_id,H_PARTY_ID(I));
3477: l_party_id_idx := H_PARTY_ID.COUNT+1;
3478: ELSE
3479: l_party_id_idx := H_PARTY_ID.COUNT+1;

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

3562: SAVEPOINT eval_start;
3563: l_ctx_id := l_search_ctx_id;
3564: unset_person_party_type;
3565: FORALL I in 1..H_PARTY_ID.COUNT
3566: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3567: l_search_ctx_id,H_PARTY_ID(I));
3568: l_party_id_idx := H_PARTY_ID.COUNT+1;
3569: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3570: LOOP

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

3629: unset_person_party_type;
3630: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3631: l_ctx_id := l_search_ctx_id;
3632: FORALL I in 1..H_PARTY_ID.COUNT
3633: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3634: l_search_ctx_id,H_PARTY_ID(I));
3635: H_PARTY_ID.DELETE;
3636: H_PARTY_ID_LIST.DELETE;
3637: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3635: H_PARTY_ID.DELETE;
3636: H_PARTY_ID_LIST.DELETE;
3637: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3638: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3639: 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);
3640: END IF;
3641: l_ctx_id := l_search_ctx_id;
3642: FORALL I in 1..H_PARTY_ID.COUNT
3643: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3639: 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);
3640: END IF;
3641: l_ctx_id := l_search_ctx_id;
3642: FORALL I in 1..H_PARTY_ID.COUNT
3643: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3644: l_search_ctx_id,H_PARTY_ID(I));
3645: l_party_id_idx := H_PARTY_ID.COUNT+1;
3646: ELSE
3647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3644: l_search_ctx_id,H_PARTY_ID(I));
3645: l_party_id_idx := H_PARTY_ID.COUNT+1;
3646: ELSE
3647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3648: 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);
3649: END IF;
3650: l_ctx_id := NULL;
3651: l_party_id_idx := H_PARTY_ID.COUNT+1;
3652: END IF;

Line 4892: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4888: IF l_match_str = ' AND ' OR (
4889: ((l_cpt_max_score/l_entered_max_score)<(255/340))
4890: ) THEN
4891: FORALL I in 1..l_match_ps_list.COUNT
4892: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4893: values (l_search_ctx_id,l_match_ps_list(I));
4894: 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');
4895: ELSE
4896: 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 5121: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5117: IF l_match_str = ' AND ' OR (
5118: ((l_cpt_max_score/l_entered_max_score)<(255/340))
5119: ) THEN
5120: FORALL I in 1..l_match_contact_list.COUNT
5121: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5122: values (l_search_ctx_id,l_match_contact_list(I));
5123: 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');
5124: ELSE
5125: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);