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_REGION_ITEMS

Line 31: l_attribute7 AK_REGION_ITEMS_VL.attribute7%TYPE;

27: (
28: p_format_Id IN VARCHAR2
29: ) RETURN VARCHAR2 IS
30:
31: l_attribute7 AK_REGION_ITEMS_VL.attribute7%TYPE;
32: l_number_format v$nls_parameters.value%TYPE;
33: l_replace_format VARCHAR2(10);
34: l_Sql VARCHAR2(32000);
35: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

Line 93: , p_attribute_code IN AK_REGION_ITEMS_VL.attribute_code%TYPE

89:
90: FUNCTION Get_dup_dataset_id
91: (
92: p_tarInd IN NUMBER
93: , p_attribute_code IN AK_REGION_ITEMS_VL.attribute_code%TYPE
94: )RETURN NUMBER IS
95:
96: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
97: l_region_Code AK_REGION_ITEMS_VL.region_code%TYPE;

Line 96: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;

92: p_tarInd IN NUMBER
93: , p_attribute_code IN AK_REGION_ITEMS_VL.attribute_code%TYPE
94: )RETURN NUMBER IS
95:
96: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
97: l_region_Code AK_REGION_ITEMS_VL.region_code%TYPE;
98: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
99: l_short_name AK_REGION_ITEMS_VL.attribute2%TYPE;
100: l_dataset_id BSC_SYS_DATASETS_VL.dataset_id%TYPE;

Line 97: l_region_Code AK_REGION_ITEMS_VL.region_code%TYPE;

93: , p_attribute_code IN AK_REGION_ITEMS_VL.attribute_code%TYPE
94: )RETURN NUMBER IS
95:
96: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
97: l_region_Code AK_REGION_ITEMS_VL.region_code%TYPE;
98: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
99: l_short_name AK_REGION_ITEMS_VL.attribute2%TYPE;
100: l_dataset_id BSC_SYS_DATASETS_VL.dataset_id%TYPE;
101: BEGIN

Line 99: l_short_name AK_REGION_ITEMS_VL.attribute2%TYPE;

95:
96: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
97: l_region_Code AK_REGION_ITEMS_VL.region_code%TYPE;
98: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
99: l_short_name AK_REGION_ITEMS_VL.attribute2%TYPE;
100: l_dataset_id BSC_SYS_DATASETS_VL.dataset_id%TYPE;
101: BEGIN
102: SELECT short_name
103: INTO l_region_Code

Line 110: FROM ak_region_items_vl ak

106: AND indicator = p_tarInd;
107:
108: SELECT dat.dataset_id
109: INTO l_dataset_id
110: FROM ak_region_items_vl ak
111: ,bis_indicators dat
112: WHERE dat.short_name = ak.attribute2
113: AND ak.region_code =l_region_Code
114: AND ak.attribute1 ='MEASURE_NOTARGET'

Line 199: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGION_ITEMS';

195: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
196:
197:
198: x_Table_Number := x_Table_Number + 1;
199: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGION_ITEMS';
200: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
201: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
202: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
203: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;

Line 207: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGION_ITEMS_TL';

203: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
204:
205:
206: x_Table_Number := x_Table_Number + 1;
207: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGION_ITEMS_TL';
208: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
209: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
210: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
211: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;

Line 581: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;

577: l_count NUMBER;
578: l_link_id NUMBER;
579: l_type BIS_INDICATORS.measure_type%TYPE;
580: l_short_name BIS_INDICATORS.short_name%TYPE;
581: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
582: l_region_Code AK_REGION_ITEMS_VL.region_code%TYPE;
583: l_Actual_Data_Source BIS_INDICATORS.actual_data_source%TYPE;
584: l_dataset_id BIS_INDICATORS.dataset_id%TYPE;
585: l_node_id BIS_INDICATORS.dataset_id%TYPE;

Line 582: l_region_Code AK_REGION_ITEMS_VL.region_code%TYPE;

578: l_link_id NUMBER;
579: l_type BIS_INDICATORS.measure_type%TYPE;
580: l_short_name BIS_INDICATORS.short_name%TYPE;
581: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
582: l_region_Code AK_REGION_ITEMS_VL.region_code%TYPE;
583: l_Actual_Data_Source BIS_INDICATORS.actual_data_source%TYPE;
584: l_dataset_id BIS_INDICATORS.dataset_id%TYPE;
585: l_node_id BIS_INDICATORS.dataset_id%TYPE;
586:

Line 1347: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;

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);
1351: l_attribute7 AK_REGION_ITEMS_VL.attribute7%TYPE;

Line 1351: l_attribute7 AK_REGION_ITEMS_VL.attribute7%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);
1351: l_attribute7 AK_REGION_ITEMS_VL.attribute7%TYPE;
1352:
1353: CURSOR c_ind IS
1354: SELECT short_name
1355: FROM bsc_kpis_vl

Line 1360: FROM ak_region_items_vl a,ak_region_items_vl b

1356: WHERE indicator =p_indicator;
1357:
1358: CURSOR c_ak_items IS
1359: SELECT a.attribute_code,b.attribute_code AS childAttrCode
1360: FROM ak_region_items_vl a,ak_region_items_vl b
1361: WHERE a.region_code =b.region_code
1362: AND b.attribute2(+)=a.attribute_code
1363: AND a.REGION_CODE = l_region_code
1364: AND a.attribute1=BSC_SIMULATION_VIEW_PVT.C_MEASURE_NOTARGET

Line 1384: UPDATE ak_region_items

1380: l_attribute7 := Get_Format(p_format_Id => p_format_Id);
1381:
1382: FOR cd_c IN c_ak_items LOOP
1383:
1384: UPDATE ak_region_items
1385: SET attribute7= l_attribute7
1386: WHERE region_code =l_region_code
1387: AND attribute_code= cd_c.attribute_code;
1388:

Line 1390: UPDATE ak_region_items

1386: WHERE region_code =l_region_code
1387: AND attribute_code= cd_c.attribute_code;
1388:
1389:
1390: UPDATE ak_region_items
1391: SET attribute7= l_attribute7
1392: WHERE region_code =l_region_code
1393: AND attribute_code= cd_c.childAttrCode;
1394:

Line 1777: l_attribute2 ak_region_items_vl.attribute2%TYPE;

1773:
1774: l_parameters FND_FORM_FUNCTIONS_VL.parameters%TYPE;
1775: l_dim_dimobjs_record BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
1776: l_non_time_counter NUMBER;
1777: l_attribute2 ak_region_items_vl.attribute2%TYPE;
1778: l_default_value NUMBER;
1779: l_dim_sht_name BSC_SYS_DIM_GROUPS_VL.short_name%TYPE;
1780: l_dim_obj_sht_name BSC_SYS_DIM_LEVELS_VL.short_name%TYPE;
1781: l_dim_set_id NUMBER :=0;