DBA Data[Home] [Help]

APPS.BIS_COMPUTED_ACTUAL_PVT dependencies on BISBV_PERFORMANCE_MEASURES

Line 250: l_measure_short_name bisbv_performance_measures.measure_short_name%type;

246: )
247: IS
248:
249: l_Measure_Inst_DB_Obj_tbl Measure_Instance_DB_Obj_Tbl;
250: l_measure_short_name bisbv_performance_measures.measure_short_name%type;
251: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
252: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
253: l_Measure_Instance BIS_MEASURE_PUB.Measure_Instance_type;
254:

Line 297: FROM bisbv_performance_measures

293: l_time_parameter_rec_type_p BIS_PMV_ACTUAL_PVT.time_parameter_rec_type;
294:
295: CURSOR cr_performance_measures(pi_measure_short_name VARCHAR2) IS
296: SELECT comparison_source, ACTUAL_DATA_SOURCE
297: FROM bisbv_performance_measures
298: WHERE measure_short_name = pi_measure_short_name;
299:
300: l_msg_count NUMBER;
301: l_msg_data VARCHAR2(32000);

Line 587: l_measure_short_name bisbv_performance_measures.measure_short_name%type;

583: l_object_attribute_tbl object_attribute_tbl_type ;
584: l_Measure_Inst_DB_Obj_tbl Measure_Instance_DB_Obj_Tbl;
585: l_measure_inst_db_obj_tbl_p Measure_Instance_DB_Obj_Tbl;
586: l_database_object_name ak_regions.DATABASE_OBJECT_NAME%TYPE;
587: l_measure_short_name bisbv_performance_measures.measure_short_name%type;
588: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
589: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
590: l_Measure_Instance BIS_MEASURE_PUB.Measure_Instance_type;
591: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;

Line 609: FROM bisbv_performance_measures

605:
606:
607: CURSOR cr_performance_measures(pi_measure_short_name VARCHAR2) IS
608: SELECT comparison_source
609: FROM bisbv_performance_measures
610: WHERE measure_short_name = pi_measure_short_name;
611:
612:
613: BEGIN

Line 801: FROM bisbv_performance_measures

797: l_actual_region_item ak_region_items.item_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
798:
799: CURSOR cr_performance_measures(pi_measure_short_name VARCHAR2) IS
800: SELECT actual_data_source
801: FROM bisbv_performance_measures
802: WHERE measure_short_name = pi_measure_short_name;
803:
804: CURSOR cr_region_items(pi_actual_region_item ak_region_items.item_name%TYPE
805: ,pi_actual_region_code ak_region_items.region_code%TYPE) IS