APPS.BSC_MIGRATION dependencies on BSC_KPI_PROPERTIES

Line 3314: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_KPI_PROPERTIES';

3310: g_metadata_tables(g_num_metadata_tables).copy_flag := FALSE;
3311: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3312:
3313: g_num_metadata_tables := g_num_metadata_tables + 1;
3314: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_KPI_PROPERTIES';
3315: g_metadata_tables(g_num_metadata_tables).level := 2;
3316: g_metadata_tables(g_num_metadata_tables).level_column := 'INDICATOR';
3317: g_metadata_tables(g_num_metadata_tables).level_condition := NULL;
3318: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 5390: FROM bsc_kpi_properties

5386: h_message VARCHAR2(4000);
5387:
5388: CURSOR c_indic_sum_level (pIndicator NUMBER, pPropertyCode VARCHAR2) IS
5389: SELECT property_value
5390: FROM bsc_kpi_properties
5391: WHERE indicator = pIndicator
5392: AND property_code = pPropertyCode;
5393:
5394: h_sum_level_prop_code VARCHAR2(20) := 'ADV_SUM_LEVEL';

Line 5909: ' from bsc_kpi_dim_levels_vl kd, bsc_kpi_properties kp, bsc_kpis_b k'||

5905: END IF;
5906:
5907: --AW_INTEGRATION: Load all the BSC dimensions used in AW indicators into AW
5908: h_sql := 'select distinct level_table_name'||
5909: ' from bsc_kpi_dim_levels_vl kd, bsc_kpi_properties kp, bsc_kpis_b k'||
5910: ' where kd.indicator = kp.indicator and'||
5911: ' kd.indicator = k.indicator and'||
5912: ' k.prototype_flag IN (0,6,7) and'||
5913: ' kp.property_code = :1 and kp.property_value = :2 and'||

Line 5945: ' from bsc_kpis_b k, bsc_kpi_properties kp'||

5941: CLOSE h_cursor;
5942:
5943: --AW_INTEGRATION: Load calendars used by AW indicators into AW
5944: h_sql := 'select distinct calendar_id'||
5945: ' from bsc_kpis_b k, bsc_kpi_properties kp'||
5946: ' where k.indicator = kp.indicator and'||
5947: ' k.prototype_flag IN (0,6,7) and'||
5948: ' kp.property_code = :1 and kp.property_value = :2';
5949: OPEN h_cursor FOR h_sql USING 'IMPLEMENTATION_TYPE', 2;

Line 5993: ' from bsc_kpis_b k, bsc_kpi_properties kp'||

5989: END IF;
5990:
5991: --AW_INTEGRATION: Now refresh the AW indicators
5992: h_sql := 'select k.indicator'||
5993: ' from bsc_kpis_b k, bsc_kpi_properties kp'||
5994: ' where k.indicator = kp.indicator and'||
5995: ' k.prototype_flag IN (0,6,7) and'||
5996: ' kp.property_code = :1 and kp.property_value = :2';
5997: OPEN h_cursor FOR h_sql USING 'IMPLEMENTATION_TYPE', 2;

Line 8955: l_Old_Default_Node bsc_kpi_properties.property_value%TYPE ;

8951: l_Calendar_Sht_Name bsc_sys_calendars_b.short_name%TYPE;
8952: l_Dim_Group_Id bsc_sys_dim_groups_vl.dim_group_Id%TYPE;
8953: l_Dim_Lev_Sht_Name bsc_sys_dim_levels_vl.short_name%TYPE;
8954: l_Dim_Short_Name bsc_sys_dim_groups_vl.short_name%TYPE;
8955: l_Old_Default_Node bsc_kpi_properties.property_value%TYPE ;
8956:
8957: l_Attribute2 ak_region_items.attribute2%TYPE;
8958: l_Item_Att_App_Id ak_region_items.attribute_application_id%TYPE;
8959: l_Item_Att_Code ak_region_items.attribute_code%TYPE;

Line 8978: bsc_kpi_properties

8974: CURSOR c_Default_Node IS
8975: SELECT
8976: property_value
8977: FROM
8978: bsc_kpi_properties
8979: WHERE
8980: indicator = p_Trg_indicator AND
8981: property_code = 'S_NODE_ID';
8982:

Line 9104: bsc_kpi_properties

9100: link_id = p_Old_DataSet_Map(i);
9101:
9102: IF l_Old_Default_Node IS NOT NULL AND l_Old_Default_Node = p_Old_DataSet_Map(i) THEN
9103: UPDATE
9104: bsc_kpi_properties
9105: SET
9106: property_value = p_New_DataSet_Map(i)
9107: WHERE
9108: indicator = p_Trg_indicator AND