DBA Data[Home] [Help]

APPS.BSC_SIMULATION_VIEW_PVT dependencies on BSC_SYS_DATASETS_VL

Line 8: l_node_id BSC_SYS_DATASETS_VL.dataset_id%TYPE;

4: FUNCTION Get_Default_Node
5: (
6: p_indicator IN BSC_KPIS_B.indicator%TYPE
7: )RETURN NUMBER IS
8: l_node_id BSC_SYS_DATASETS_VL.dataset_id%TYPE;
9: BEGIN
10:
11: SELECT property_value
12: INTO l_node_id

Line 100: l_dataset_id BSC_SYS_DATASETS_VL.dataset_id%TYPE;

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
104: FROM bsc_kpis_b

Line 1340: ,p_dataset_Id IN BSC_SYS_DATASETS_VL.dataset_id%TYPE

1336:
1337: PROCEDURE Set_Ak_Format_Id
1338: (
1339: p_indicator IN BSC_KPIS_B.indicator%TYPE
1340: ,p_dataset_Id IN BSC_SYS_DATASETS_VL.dataset_id%TYPE
1341: ,p_format_Id IN BSC_KPI_TREE_NODES_VL.format_id%TYPE
1342: ,x_return_status OUT NOCOPY VARCHAR2
1343: ,x_msg_count OUT NOCOPY NUMBER
1344: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1463: l_default_node BSC_SYS_DATASETS_VL.dataset_id%TYPE;

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;
1464: l_count NUMBER;
1465: l_shared_Obj_Tbl BSC_SIMULATION_VIEW_PVT.Bsc_Shared_Obj_Tbl_Type ;
1466: l_function_name FND_FORM_FUNCTIONS.function_name%TYPE;
1467: