DBA Data[Home] [Help]

APPS.BSC_SIMULATION_VIEW_PVT dependencies on BSC_DESIGNER_PVT

Line 129: ,x_kpi_metadata_tables OUT NOCOPY BSC_DESIGNER_PVT.t_kpi_metadata_tables

125: PROCEDURE Init_Sim_Tables_Array
126: (
127: p_copy_Ak_Tables IN VARCHAR
128: ,x_Table_Number OUT NOCOPY NUMBER
129: ,x_kpi_metadata_tables OUT NOCOPY BSC_DESIGNER_PVT.t_kpi_metadata_tables
130: )
131: IS
132: BEGIN
133: x_Table_Number := 0;

Line 576: l_kpi_metadata_tables BSC_DESIGNER_PVT.t_kpi_metadata_tables;

572: ,x_msg_data OUT NOCOPY VARCHAR2
573: )IS
574:
575: l_Table_Number NUMBER;
576: l_kpi_metadata_tables BSC_DESIGNER_PVT.t_kpi_metadata_tables;
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;

Line 885: BSC_DESIGNER_PVT.ActionFlag_Change(p_indicator, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);

881: --Changing the YTD will set the prototype_flag to 7 for both production mode
882: --objectives and kpis
883:
884: IF(l_count=0 AND NOT (l_YTD = BSC_SIMULATION_VIEW_PUB.c_YEAR_TO_DATE_DISABLED))THEN
885: BSC_DESIGNER_PVT.ActionFlag_Change(p_indicator, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);
886: ELSIF(l_count>0 AND p_prev_YTD <> l_YTD) THEN
887: BSC_DESIGNER_PVT.ActionFlag_Change(p_indicator, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);
888: END IF;
889: --For simulation only 1 calculation is enabled and that is

Line 887: BSC_DESIGNER_PVT.ActionFlag_Change(p_indicator, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);

883:
884: IF(l_count=0 AND NOT (l_YTD = BSC_SIMULATION_VIEW_PUB.c_YEAR_TO_DATE_DISABLED))THEN
885: BSC_DESIGNER_PVT.ActionFlag_Change(p_indicator, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);
886: ELSIF(l_count>0 AND p_prev_YTD <> l_YTD) THEN
887: BSC_DESIGNER_PVT.ActionFlag_Change(p_indicator, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);
888: END IF;
889: --For simulation only 1 calculation is enabled and that is
890: --Year To Date
891:

Line 1089: , p_prototype_flag => BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color

1085: BSC_KPI_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change
1086: (
1087: p_objective_id => p_indicator
1088: , p_kpi_measure_id => l_kpi_measure_id
1089: , p_prototype_flag => BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color
1090: , x_return_status => x_return_status
1091: , x_msg_count => x_msg_count
1092: , x_msg_data => x_msg_data
1093: );

Line 1103: , p_prototype_flag => BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color

1099: IF(cd.property_value =p_dataset_id) THEN
1100: BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change
1101: (
1102: p_objective_id => p_indicator
1103: , p_prototype_flag => BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color
1104: , x_return_status => x_return_status
1105: , x_msg_count => x_msg_count
1106: , x_msg_data => x_msg_data
1107: );

Line 1203: --BSC_DESIGNER_PVT.ActionFlag_Change(p_indicator, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);

1199: SET property_value = p_dataset_id
1200: WHERE indicator =p_indicator
1201: AND property_code =BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;
1202:
1203: --BSC_DESIGNER_PVT.ActionFlag_Change(p_indicator, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);
1204: --Changing the default node should only set the prototype_flag of the objective
1205: -- and not of the kpis.
1206:
1207: BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change

Line 1210: , p_prototype_flag => BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color

1206:
1207: BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change
1208: (
1209: p_objective_id => p_indicator
1210: , p_prototype_flag => BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color
1211: , x_return_status => x_return_status
1212: , x_msg_count => x_msg_count
1213: , x_msg_data => x_msg_data
1214: );

Line 1270: l_kpi_metadata_tables BSC_DESIGNER_PVT.t_kpi_metadata_tables;

1266: ,x_msg_data OUT NOCOPY VARCHAR2
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

Line 1458: l_kpi_metadata_tables BSC_DESIGNER_PVT.t_kpi_metadata_tables;

1454: AND Prototype_Flag <> 2;
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;

Line 1633: l_kpi_metadata_tables BSC_DESIGNER_PVT.t_kpi_metadata_tables;

1629: l_sql VARCHAR2(32000);
1630: TYPE c_cur_type IS REF CURSOR;
1631: c_cursor c_cur_type;
1632: l_DimObj_Sht_Names VARCHAR2(32000);
1633: l_kpi_metadata_tables BSC_DESIGNER_PVT.t_kpi_metadata_tables;
1634: l_Bsc_Group_Id bsc_sys_dim_groups_tl.dim_group_id%TYPE;
1635: l_Bis_Group_Id bis_dimensions.dimension_id%TYPE;
1636:
1637: