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.BSC_SIMULATION_VIEW_PVT dependencies on AK_REGIONS

Line 183: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGIONS';

179:
180: IF(p_copy_Ak_Tables=FND_API.G_TRUE)THEN
181:
182: x_Table_Number := x_Table_Number + 1;
183: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGIONS';
184: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
185: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
186: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
187: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;

Line 191: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGIONS_TL';

187: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
188:
189:
190: x_Table_Number := x_Table_Number + 1;
191: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGIONS_TL';
192: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
193: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
194: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
195: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;

Line 329: l_new_region_code AK_REGIONS.region_code%TYPE;

325: h_condition VARCHAR2(1000);
326: h_sql VARCHAR2(32000);
327: x_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
328: x_num_columns NUMBER;
329: l_new_region_code AK_REGIONS.region_code%TYPE;
330: l_region_code AK_REGIONS.region_code%TYPE;
331: l_count NUMBER;
332: l_owner all_tab_columns.owner%TYPE;
333: l_new_function_id FND_FORM_FUNCTIONS.function_id%TYPE;

Line 330: l_region_code AK_REGIONS.region_code%TYPE;

326: h_sql VARCHAR2(32000);
327: x_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
328: x_num_columns NUMBER;
329: l_new_region_code AK_REGIONS.region_code%TYPE;
330: l_region_code AK_REGIONS.region_code%TYPE;
331: l_count NUMBER;
332: l_owner all_tab_columns.owner%TYPE;
333: l_new_function_id FND_FORM_FUNCTIONS.function_id%TYPE;
334: l_old_function_id FND_FORM_FUNCTIONS.function_id%TYPE;

Line 776: l_region_code ak_regions.region_code%TYPE;

772: ,x_msg_count OUT NOCOPY NUMBER
773: ,x_msg_data OUT NOCOPY VARCHAR2
774: )IS
775: l_count NUMBER;
776: l_region_code ak_regions.region_code%TYPE;
777: l_region_app_id ak_regions.region_application_id%TYPE;
778: l_YTD bis_ak_region_extension.attribute21%TYPE;
779:
780: l_attribute21 bis_ak_region_extension.attribute21%TYPE;

Line 777: l_region_app_id ak_regions.region_application_id%TYPE;

773: ,x_msg_data OUT NOCOPY VARCHAR2
774: )IS
775: l_count NUMBER;
776: l_region_code ak_regions.region_code%TYPE;
777: l_region_app_id ak_regions.region_application_id%TYPE;
778: l_YTD bis_ak_region_extension.attribute21%TYPE;
779:
780: l_attribute21 bis_ak_region_extension.attribute21%TYPE;
781:

Line 785: ak_regions A

781:
782: CURSOR c_kpi IS
783: SELECT A.region_code,A.region_application_id
784: FROM bsc_kpis_b B,
785: ak_regions A
786: WHERE A.region_code =B.short_name
787: AND B.indicator = p_indicator
788: AND B.config_type = BSC_SIMULATION_VIEW_PUB.c_TYPE;
789:

Line 1271: l_new_region_code AK_REGIONS.region_code%TYPE;

1267: )IS
1268:
1269: l_Table_Number NUMBER;
1270: l_kpi_metadata_tables BSC_DESIGNER_PVT.t_kpi_metadata_tables;
1271: l_new_region_code AK_REGIONS.region_code%TYPE;
1272: l_count NUMBER;
1273:
1274: CURSOR c_sim_nodes IS
1275: SELECT node_id

Line 1326: UPDATE ak_regions

1322: UPDATE bsc_kpis_b
1323: SET short_name =l_new_region_code
1324: WHERE indicator =p_target_kpi;
1325:
1326: UPDATE ak_regions
1327: SET attribute8 = p_target_kpi || '.'||BSC_SIMULATION_VIEW_PVT.C_DEFAULT_ANA_OPTION
1328: WHERE region_code =l_new_region_code;
1329:
1330: UPDATE bsc_kpi_analysis_options_b

Line 1346: l_region_code AK_REGIONS.region_code%TYPE;

1342: ,x_return_status OUT NOCOPY VARCHAR2
1343: ,x_msg_count OUT NOCOPY NUMBER
1344: ,x_msg_data OUT NOCOPY VARCHAR2
1345: ) IS
1346: l_region_code AK_REGIONS.region_code%TYPE;
1347: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
1348: l_meas_short_name BIS_INDICATORS.short_name%TYPE;
1349: l_number_format v$nls_parameters.value%TYPE;
1350: l_replace_format VARCHAR2(10);

Line 1459: l_region_code AK_REGIONS.region_code%TYPE;

1455:
1456: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
1457: l_Table_Number NUMBER;
1458: l_kpi_metadata_tables BSC_DESIGNER_PVT.t_kpi_metadata_tables;
1459: l_region_code AK_REGIONS.region_code%TYPE;
1460: l_function_id FND_FORM_FUNCTIONS.function_id%TYPE;
1461: l_source_kpi BSC_KPIS_B.indicator%TYPE;
1462: l_target_kpi BSC_KPIS_B.indicator%TYPE;
1463: l_default_node BSC_SYS_DATASETS_VL.dataset_id%TYPE;

Line 1538: UPDATE ak_regions

1534: Copy_Ak_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, l_source_kpi, l_target_kpi,l_region_code,l_function_id);
1535: END IF;
1536: END LOOP;
1537:
1538: UPDATE ak_regions
1539: SET attribute8 = l_target_kpi || '.'||BSC_SIMULATION_VIEW_PVT.C_DEFAULT_ANA_OPTION
1540: WHERE region_code =l_region_code;
1541:
1542: IF(l_default_node IS NOT NULL) THEN