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 1557: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1580: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 1781: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

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

Line 1888: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1900: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

Line 1976: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1972: END IF;
1973: IF p_person_api = 'Y' THEN
1974: OPEN x_cursor FOR
1975: 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 , TX8, TX7
1976: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1977: WHERE contains( concat_col, p_contains_str)>0
1978: AND d.search_context_id = p_search_ctx_id
1979: AND d.party_id = stage.party_id
1980: AND( (l_search_merged ='Y' )

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

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

Line 1999: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1995: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1996: ELSE
1997: OPEN x_cursor FOR
1998: 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 , TX8, TX7
1999: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2000: WHERE contains( concat_col, p_contains_str)>0
2001: AND d.search_context_id = p_search_ctx_id
2002: AND d.party_id = stage.party_id
2003: AND( (l_search_merged ='Y' )

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

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

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

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

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

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

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

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

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

2463: END IF;
2464: SAVEPOINT eval_start;
2465: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2466: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2467: 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: l_ctx_id := l_search_ctx_id;
2470: FORALL I in 1..H_PARTY_ID.COUNT
2471: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

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

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

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

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

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

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

2575: END IF;
2576: SAVEPOINT eval_start;
2577: IF l_match_str = ' AND ' AND p_call_type='AND' THEN
2578: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2579: 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: l_ctx_id := l_search_ctx_id;
2582: FORALL I in 1..H_PARTY_ID.COUNT
2583: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

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

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

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

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

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

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

2686: END IF;
2687: SAVEPOINT eval_start;
2688: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
2689: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2690: 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: l_ctx_id := l_search_ctx_id;
2693: FORALL I in 1..H_PARTY_ID.COUNT
2694: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

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

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

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

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

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

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

3312: set_person_party_type;
3313: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3314: l_ctx_id := l_search_ctx_id;
3315: FORALL I in 1..H_PARTY_ID.COUNT
3316: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3317: l_search_ctx_id,H_PARTY_ID(I));
3318: H_PARTY_ID.DELETE;
3319: H_PARTY_ID_LIST.DELETE;
3320: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3319: H_PARTY_ID_LIST.DELETE;
3320: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3321: l_ctx_id := l_search_ctx_id;
3322: FORALL I in 1..H_PARTY_ID.COUNT
3323: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3324: l_search_ctx_id,H_PARTY_ID(I));
3325: l_party_id_idx := H_PARTY_ID.COUNT+1;
3326: ELSE
3327: IF (p_restrict_sql IS NULL OR instrb(p_restrict_sql, 'SELECTIVE')=0)

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

3420: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3421: FROM HZ_STAGED_CONTACTS stage
3422: WHERE contains( concat_col, p_contains_str)>0
3423: AND ORG_CONTACT_ID in (
3424: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3425: org_contact_id
3426: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3427: where d.party_id = r.subject_id
3428: and oc.party_relationship_id = r.relationship_id

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

3422: WHERE contains( concat_col, p_contains_str)>0
3423: AND ORG_CONTACT_ID in (
3424: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3425: org_contact_id
3426: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3427: where d.party_id = r.subject_id
3428: and oc.party_relationship_id = r.relationship_id
3429: and d.search_context_id = p_search_ctx_id);
3430: exception

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

3456: unset_person_party_type;
3457: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3458: l_ctx_id := l_search_ctx_id;
3459: FORALL I in 1..H_PARTY_ID.COUNT
3460: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3461: l_search_ctx_id,H_PARTY_ID(I));
3462: H_PARTY_ID.DELETE;
3463: H_PARTY_ID_LIST.DELETE;
3464: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

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

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

3554: SAVEPOINT eval_start;
3555: l_ctx_id := l_search_ctx_id;
3556: unset_person_party_type;
3557: FORALL I in 1..H_PARTY_ID.COUNT
3558: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3559: l_search_ctx_id,H_PARTY_ID(I));
3560: l_party_id_idx := H_PARTY_ID.COUNT+1;
3561: open_person_contact_cursor(p_contact_contains_str,l_ctx_id, l_contact_cur);
3562: LOOP

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

3621: unset_person_party_type;
3622: IF l_match_str = ' AND ' AND p_call_type = 'AND' THEN
3623: l_ctx_id := l_search_ctx_id;
3624: FORALL I in 1..H_PARTY_ID.COUNT
3625: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3626: l_search_ctx_id,H_PARTY_ID(I));
3627: H_PARTY_ID.DELETE;
3628: H_PARTY_ID_LIST.DELETE;
3629: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN

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

3627: H_PARTY_ID.DELETE;
3628: H_PARTY_ID_LIST.DELETE;
3629: ELSIF l_match_str = ' OR ' AND p_call_type = 'AND' THEN
3630: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3631: 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);
3632: END IF;
3633: l_ctx_id := l_search_ctx_id;
3634: FORALL I in 1..H_PARTY_ID.COUNT
3635: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (

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

3631: 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);
3632: END IF;
3633: l_ctx_id := l_search_ctx_id;
3634: FORALL I in 1..H_PARTY_ID.COUNT
3635: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
3636: l_search_ctx_id,H_PARTY_ID(I));
3637: l_party_id_idx := H_PARTY_ID.COUNT+1;
3638: ELSE
3639: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3636: l_search_ctx_id,H_PARTY_ID(I));
3637: l_party_id_idx := H_PARTY_ID.COUNT+1;
3638: ELSE
3639: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3640: 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);
3641: END IF;
3642: l_ctx_id := NULL;
3643: l_party_id_idx := H_PARTY_ID.COUNT+1;
3644: END IF;

Line 4884: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

4880: IF l_match_str = ' AND ' OR (
4881: ((l_cpt_max_score/l_entered_max_score)<(255/340))
4882: ) THEN
4883: FORALL I in 1..l_match_ps_list.COUNT
4884: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
4885: values (l_search_ctx_id,l_match_ps_list(I));
4886: 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');
4887: ELSE
4888: 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 5113: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)

5109: IF l_match_str = ' AND ' OR (
5110: ((l_cpt_max_score/l_entered_max_score)<(255/340))
5111: ) THEN
5112: FORALL I in 1..l_match_contact_list.COUNT
5113: INSERT INTO HZ_DQM_PARTIES_GT (search_context_id, party_id)
5114: values (l_search_ctx_id,l_match_contact_list(I));
5115: 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');
5116: ELSE
5117: open_contact_pt_cursor(NULL, P_PARTY_ID, p_restrict_sql, l_contact_pt_contains_str,NULL, null,'N', 'N',l_contact_pt_cur);