[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.
1057: Debug('Partner ID' || ' ' || 'Partner Name');
1058: Debug('----------' || ' ' || '-------------------------------');
1059:
1060: For x IN (SELECT a.partner_id, c.party_name
1061: FROM pv_partner_id_session a,
1062: pv_partner_profiles b,
1063: hz_parties c
1064: WHERE a.partner_id = b.partner_id AND
1065: b.partner_party_id = c.party_id)
1512: -- inserting the records.
1513: -- ----------------------------------------------------------------
1514: DELETE FROM pv_search_attr_values
1515: WHERE attribute_id = 1 AND
1516: party_id IN (SELECT partner_id FROM pv_partner_id_session);
1517:
1518:
1519: INSERT
1520: INTO pv_search_attr_values (
1543: SELECT DISTINCT
1544: a.entity_id,
1545: DENORM.child_id attr_value
1546: FROM pv_enty_attr_values a,
1547: pv_partner_id_session b,
1548: eni_prod_denorm_hrchy_v DENORM
1549: WHERE a.attribute_id = 1 AND
1550: a.latest_flag = 'Y' AND
1551: a.entity = 'PARTNER' AND
1727: -- inserting the records.
1728: -- ----------------------------------------------------------------
1729: DELETE FROM pv_search_attr_values
1730: WHERE attribute_id = x.attribute_id AND
1731: party_id IN (SELECT partner_id FROM pv_partner_id_session);
1732:
1733:
1734: INSERT
1735: INTO pv_search_attr_values (
1760: a.attr_value attr_text,
1761: pv_check_match_pub.Currency_Conversion(
1762: a.attr_value, g_common_currency) attr_value
1763: FROM pv_enty_attr_values a,
1764: pv_partner_id_session b
1765: WHERE a.entity = 'PARTNER' AND
1766: a.latest_flag = 'Y' AND
1767: a.attr_value IS NOT NULL AND
1768: a.entity_id = b.partner_id AND
2111: -- sure the records are not already in the search table before
2112: -- inserting the records.
2113: -- ----------------------------------------------------------------
2114: DELETE FROM pv_search_attr_values
2115: WHERE party_id IN (SELECT partner_id FROM pv_partner_id_session) AND
2116: attribute_id IN (
2117: SELECT a.attribute_id
2118: FROM pv_entity_attrs a,
2119: pv_attributes_b b
2152: 1.0
2153: FROM (
2154: SELECT DISTINCT a.entity_id, attr_value attr_value, attribute_id
2155: FROM pv_enty_attr_values a,
2156: pv_partner_id_session b
2157: WHERE a.entity = 'PARTNER' AND
2158: a.entity_id = b.partner_id AND
2159: latest_flag = 'Y' AND
2160: attr_value IS NOT NULL AND
2195: -- sure the records are not already in the search table before
2196: -- inserting the records.
2197: -- ----------------------------------------------------------------
2198: DELETE FROM pv_search_attr_values
2199: WHERE party_id IN (SELECT partner_id FROM pv_partner_id_session) AND
2200: attribute_id IN (
2201: SELECT a.attribute_id
2202: FROM pv_entity_attrs a,
2203: pv_attributes_b b
2242: 1.0
2243: FROM (
2244: SELECT DISTINCT a.entity_id, attr_value attr_value, attribute_id
2245: FROM pv_enty_attr_values a,
2246: pv_partner_id_session b
2247: WHERE a.entity = 'PARTNER' AND
2248: a.entity_id = b.partner_id AND
2249: latest_flag = 'Y' AND
2250: attr_value IS NOT NULL AND
2545: -- inserting the records.
2546: -- ----------------------------------------------------------------
2547: DELETE FROM pv_search_attr_values
2548: WHERE attribute_id = x.attribute_id AND
2549: party_id IN (SELECT partner_id FROM pv_partner_id_session);
2550:
2551: -- -------------------------------------------------------------
2552: -- Include the new partners only clause in the batch_sql_text.
2553: -- -------------------------------------------------------------
2800: -- inserting the records.
2801: -- ----------------------------------------------------------------
2802: DELETE FROM pv_search_attr_values
2803: WHERE attribute_id = x.attribute_id AND
2804: party_id IN (SELECT partner_id FROM pv_partner_id_session);
2805:
2806: -- -------------------------------------------------------------
2807: -- Include the new partners only clause in the batch_sql_text.
2808: -- -------------------------------------------------------------