eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_ANALYSIS_OPTION_PVT dependencies on BIS_INDICATORS

Line 3304: l_Measure_AKRegion BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;

3300: , x_return_status OUT NOCOPY VARCHAR2
3301: , x_msg_count OUT NOCOPY NUMBER
3302: , x_msg_data OUT NOCOPY VARCHAR2
3303: ) IS
3304: l_Measure_AKRegion BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
3305: l_Measure_Function BIS_INDICATORS.FUNCTION_NAME%TYPE;
3306: l_Measure_DatasetId BSC_OAF_ANALYSYS_OPT_COMB_V.DATASET_ID%TYPE;
3307: l_AnaOpt_AKRegion varchar2(50);
3308: l_position NUMBER;

Line 3305: l_Measure_Function BIS_INDICATORS.FUNCTION_NAME%TYPE;

3301: , x_msg_count OUT NOCOPY NUMBER
3302: , x_msg_data OUT NOCOPY VARCHAR2
3303: ) IS
3304: l_Measure_AKRegion BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
3305: l_Measure_Function BIS_INDICATORS.FUNCTION_NAME%TYPE;
3306: l_Measure_DatasetId BSC_OAF_ANALYSYS_OPT_COMB_V.DATASET_ID%TYPE;
3307: l_AnaOpt_AKRegion varchar2(50);
3308: l_position NUMBER;
3309: l_index integer;

Line 3329: bis_indicators c

3325: ,a.dataset_id dataset_id
3326: ,a.full_name name
3327: FROM bsc_oaf_analysys_opt_comb_v a,
3328: bsc_sys_datasets_b b,
3329: bis_indicators c
3330: WHERE a.dataset_id = b.dataset_id
3331: AND b.dataset_id = c.dataset_id
3332: AND a.Indicator = p_kpi_id
3333: AND a.Analysis_Option0 = p_option0

Line 4146: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;

4142: , x_Return_Status OUT NOCOPY VARCHAR2
4143: , x_Msg_Count OUT NOCOPY NUMBER
4144: , x_Msg_Data OUT NOCOPY VARCHAR2
4145: ) IS
4146: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
4147: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
4148: l_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
4149: l_Enable_Link BIS_INDICATORS.ENABLE_LINK%TYPE;
4150: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;

Line 4147: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;

4143: , x_Msg_Count OUT NOCOPY NUMBER
4144: , x_Msg_Data OUT NOCOPY VARCHAR2
4145: ) IS
4146: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
4147: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
4148: l_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
4149: l_Enable_Link BIS_INDICATORS.ENABLE_LINK%TYPE;
4150: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
4151:

Line 4148: l_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;

4144: , x_Msg_Data OUT NOCOPY VARCHAR2
4145: ) IS
4146: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
4147: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
4148: l_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
4149: l_Enable_Link BIS_INDICATORS.ENABLE_LINK%TYPE;
4150: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
4151:
4152: BEGIN

Line 4149: l_Enable_Link BIS_INDICATORS.ENABLE_LINK%TYPE;

4145: ) IS
4146: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
4147: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
4148: l_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
4149: l_Enable_Link BIS_INDICATORS.ENABLE_LINK%TYPE;
4150: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
4151:
4152: BEGIN
4153: FND_MSG_PUB.Initialize;

Line 4150: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;

4146: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
4147: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
4148: l_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
4149: l_Enable_Link BIS_INDICATORS.ENABLE_LINK%TYPE;
4150: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
4151:
4152: BEGIN
4153: FND_MSG_PUB.Initialize;
4154: SAVEPOINT CascadedDataSrcPVT;

Line 4177: -- This API expects BIS_INDICATORS to be syncronized correctly with BSC_SYS_DATASETS_VL

4173: l_Enable_Link := p_Enable_Link;
4174: l_Comparison_Source := p_Comparison_Source;
4175: END IF;
4176:
4177: -- This API expects BIS_INDICATORS to be syncronized correctly with BSC_SYS_DATASETS_VL
4178: UPDATE BIS_INDICATORS I
4179: SET I.ACTUAL_DATA_SOURCE_TYPE = l_Actual_Data_Source_Type
4180: , I.ACTUAL_DATA_SOURCE = l_Actual_Data_Source
4181: , I.FUNCTION_NAME = l_Function_Name

Line 4178: UPDATE BIS_INDICATORS I

4174: l_Comparison_Source := p_Comparison_Source;
4175: END IF;
4176:
4177: -- This API expects BIS_INDICATORS to be syncronized correctly with BSC_SYS_DATASETS_VL
4178: UPDATE BIS_INDICATORS I
4179: SET I.ACTUAL_DATA_SOURCE_TYPE = l_Actual_Data_Source_Type
4180: , I.ACTUAL_DATA_SOURCE = l_Actual_Data_Source
4181: , I.FUNCTION_NAME = l_Function_Name
4182: , I.ENABLE_LINK = l_Enable_Link