DBA Data[Home] [Help]

APPS.BIS_INDICATOR_REGION_UI_PVT dependencies on BIS_INDICATORS

Line 675: FROM bis_indicators i, bis_target_levels t

671: ) RETURN VARCHAR2 IS
672:
673: CURSOR c_measure IS
674: SELECT i.short_name
675: FROM bis_indicators i, bis_target_levels t
676: WHERE i.indicator_id = t.indicator_id AND
677: t.target_level_id = p_target_level_id;
678:
679: CURSOR c_dim_level(dimension_index NUMBER) IS

Line 869: ,bis_indicators c

865: ,c.comparison_source
866: ,c.indicator_id
867: FROM bis_user_ind_selections a
868: ,fnd_user_resp_groups b
869: ,bis_indicators c
870: ,bisbv_target_levels d
871: WHERE a.user_id = g_user_id
872: AND a.plug_id = p_plug_id
873: AND a.user_id = b.user_id

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 ;