DBA Data[Home] [Help]

APPS.BIS_INDICATOR_REGION_UI_PVT dependencies on BIS_INDICATORS_TL

Line 5238: l_perf_meas_name bis_indicators_tl.name%TYPE;

5234: -- mdamle 01/12/2001 Get Performance Measure + Dim Level info
5235: function getPerformanceMeasureName(
5236: p_target_level_id IN number
5237: ) return varchar2 IS
5238: l_perf_meas_name bis_indicators_tl.name%TYPE;
5239: Begin
5240: begin
5241: select measure_name || ' (' || DIMENSION1_LEVEL_NAME || decode(DIMENSION2_LEVEL_NAME, '', '', ' - ' || DIMENSION2_LEVEL_NAME)
5242: || decode(DIMENSION3_LEVEL_NAME, '', '', ' - ' || DIMENSION3_LEVEL_NAME) || decode(DIMENSION4_LEVEL_NAME, '', '', ' - ' || DIMENSION4_LEVEL_NAME)

Line 6656: l_Measure_Name bis_indicators_tl.name%TYPE ;

6652: l_msg_count VARCHAR2(32000);
6653: l_msg_data VARCHAR2(32000);
6654: l_Measure_ID NUMBER ;
6655: l_Measure_Short_Name VARCHAR2(30);
6656: l_Measure_Name bis_indicators_tl.name%TYPE ;
6657: l_Description bis_indicators_tl.DESCRIPTION%TYPE ;
6658: l_Dimension1_ID NUMBER ;
6659: l_Dimension2_ID NUMBER ;
6660: l_Dimension3_ID NUMBER ;

Line 6657: l_Description bis_indicators_tl.DESCRIPTION%TYPE ;

6653: l_msg_data VARCHAR2(32000);
6654: l_Measure_ID NUMBER ;
6655: l_Measure_Short_Name VARCHAR2(30);
6656: l_Measure_Name bis_indicators_tl.name%TYPE ;
6657: l_Description bis_indicators_tl.DESCRIPTION%TYPE ;
6658: l_Dimension1_ID NUMBER ;
6659: l_Dimension2_ID NUMBER ;
6660: l_Dimension3_ID NUMBER ;
6661: l_Dimension4_ID NUMBER ;