[Home] [Help]
16: g_common_currency VARCHAR2(15);
17: g_module_name VARCHAR2(48);
18: g_batch_insert_count NUMBER;
19: g_non_batch_insert_count NUMBER;
20: g_partner_temp_table VARCHAR2(30) := 'PV_PARTNER_ID_SESSION';
21: g_log_to_file VARCHAR2(5) := 'Y';
22:
23: g_apps_schema VARCHAR2(30);
24:
408: pv_check_match_pub.g_display_message := FALSE;
409: pv_check_match_pub.g_period_set_name := FND_PROFILE.Value('AS_FORECAST_CALENDAR');
410: pv_check_match_pub.g_period_type := FND_PROFILE.Value('AS_DEFAULT_PERIOD_TYPE');
411:
412: g_partner_temp_table := 'PV_PARTNER_ID_SESSION';
413:
414:
415: -- -----------------------------------------------------------------------
416: -- Pre-processing steps including synonym recovery, retrieving PV schema,
429: p_refresh_type => l_refresh_type,
430: p_synonym_name => 'PV_SEARCH_ATTR_VALUES',
431: p_mirror_synonym_name => 'PV_SEARCH_ATTR_MIRROR',
432: p_temp_synonym_name => 'PV_SEARCH_ATTR_VALUES_TMP',
433: p_partner_id_temp_table => 'PV_PARTNER_ID_SESSION',
434: p_temp_table_processed => TRUE,
435: p_last_incr_refresh_str => l_last_incr_refresh_str,
436: p_log_to_file => g_log_to_file,
437: p_module_name => g_module_name,
650: IF (l_num_temp > 0 OR l_refresh_type = g_incr_refresh) THEN
651: IF (l_refresh_type = g_incr_refresh AND l_last_incr_refresh_date IS NOT NULL) THEN
652: OPEN lc_get_partners FOR
653: SELECT partner_id
654: FROM pv_partner_id_session;
655:
656: ELSE
657: -- -----------------------------------------------------------------------------
658: -- Obsolete the use of sales_partner_flag.
1035: Debug('Partner ID' || ' ' || 'Partner Name');
1036: Debug('----------' || ' ' || '-------------------------------');
1037:
1038: For x IN (SELECT a.partner_id, c.party_name
1039: FROM pv_partner_id_session a,
1040: pv_partner_profiles b,
1041: hz_parties c
1042: WHERE a.partner_id = b.partner_id AND
1043: b.partner_party_id = c.party_id)
1490: -- inserting the records.
1491: -- ----------------------------------------------------------------
1492: DELETE FROM pv_search_attr_values
1493: WHERE attribute_id = 1 AND
1494: party_id IN (SELECT partner_id FROM pv_partner_id_session);
1495:
1496:
1497: INSERT
1498: INTO pv_search_attr_values (
1521: SELECT DISTINCT
1522: a.entity_id,
1523: DENORM.child_id attr_value
1524: FROM pv_enty_attr_values a,
1525: pv_partner_id_session b,
1526: eni_prod_denorm_hrchy_v DENORM
1527: WHERE a.attribute_id = 1 AND
1528: a.latest_flag = 'Y' AND
1529: a.entity = 'PARTNER' AND
1705: -- inserting the records.
1706: -- ----------------------------------------------------------------
1707: DELETE FROM pv_search_attr_values
1708: WHERE attribute_id = x.attribute_id AND
1709: party_id IN (SELECT partner_id FROM pv_partner_id_session);
1710:
1711:
1712: INSERT
1713: INTO pv_search_attr_values (
1738: a.attr_value attr_text,
1739: pv_check_match_pub.Currency_Conversion(
1740: a.attr_value, g_common_currency) attr_value
1741: FROM pv_enty_attr_values a,
1742: pv_partner_id_session b
1743: WHERE a.entity = 'PARTNER' AND
1744: a.latest_flag = 'Y' AND
1745: a.attr_value IS NOT NULL AND
1746: a.entity_id = b.partner_id AND
2089: -- sure the records are not already in the search table before
2090: -- inserting the records.
2091: -- ----------------------------------------------------------------
2092: DELETE FROM pv_search_attr_values
2093: WHERE party_id IN (SELECT partner_id FROM pv_partner_id_session) AND
2094: attribute_id IN (
2095: SELECT a.attribute_id
2096: FROM pv_entity_attrs a,
2097: pv_attributes_b b
2130: 1.0
2131: FROM (
2132: SELECT DISTINCT a.entity_id, attr_value attr_value, attribute_id
2133: FROM pv_enty_attr_values a,
2134: pv_partner_id_session b
2135: WHERE a.entity = 'PARTNER' AND
2136: a.entity_id = b.partner_id AND
2137: latest_flag = 'Y' AND
2138: attr_value IS NOT NULL AND
2173: -- sure the records are not already in the search table before
2174: -- inserting the records.
2175: -- ----------------------------------------------------------------
2176: DELETE FROM pv_search_attr_values
2177: WHERE party_id IN (SELECT partner_id FROM pv_partner_id_session) AND
2178: attribute_id IN (
2179: SELECT a.attribute_id
2180: FROM pv_entity_attrs a,
2181: pv_attributes_b b
2220: 1.0
2221: FROM (
2222: SELECT DISTINCT a.entity_id, attr_value attr_value, attribute_id
2223: FROM pv_enty_attr_values a,
2224: pv_partner_id_session b
2225: WHERE a.entity = 'PARTNER' AND
2226: a.entity_id = b.partner_id AND
2227: latest_flag = 'Y' AND
2228: attr_value IS NOT NULL AND
2523: -- inserting the records.
2524: -- ----------------------------------------------------------------
2525: DELETE FROM pv_search_attr_values
2526: WHERE attribute_id = x.attribute_id AND
2527: party_id IN (SELECT partner_id FROM pv_partner_id_session);
2528:
2529: -- -------------------------------------------------------------
2530: -- Include the new partners only clause in the batch_sql_text.
2531: -- -------------------------------------------------------------
2778: -- inserting the records.
2779: -- ----------------------------------------------------------------
2780: DELETE FROM pv_search_attr_values
2781: WHERE attribute_id = x.attribute_id AND
2782: party_id IN (SELECT partner_id FROM pv_partner_id_session);
2783:
2784: -- -------------------------------------------------------------
2785: -- Include the new partners only clause in the batch_sql_text.
2786: -- -------------------------------------------------------------