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 BSC_KPIS_VL

Line 188: , p_Kpi_Name OUT NOCOPY BSC_KPIS_VL.NAME%TYPE

184:
185: /*******************************************************************************/
186: FUNCTION is_custom_kpi
187: ( p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
188: , p_Kpi_Name OUT NOCOPY BSC_KPIS_VL.NAME%TYPE
189: ) RETURN BOOLEAN IS
190: l_Kpi_ShortName VARCHAR2(50);
191: l_Kpi_Name BSC_KPIS_VL.NAME%TYPE;
192:

Line 191: l_Kpi_Name BSC_KPIS_VL.NAME%TYPE;

187: ( p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
188: , p_Kpi_Name OUT NOCOPY BSC_KPIS_VL.NAME%TYPE
189: ) RETURN BOOLEAN IS
190: l_Kpi_ShortName VARCHAR2(50);
191: l_Kpi_Name BSC_KPIS_VL.NAME%TYPE;
192:
193: CURSOR c_kpis IS
194: SELECT name, short_name
195: FROM BSC_KPIS_VL WHERE Indicator = p_Kpi_id;

Line 195: FROM BSC_KPIS_VL WHERE Indicator = p_Kpi_id;

191: l_Kpi_Name BSC_KPIS_VL.NAME%TYPE;
192:
193: CURSOR c_kpis IS
194: SELECT name, short_name
195: FROM BSC_KPIS_VL WHERE Indicator = p_Kpi_id;
196: BEGIN
197: IF (c_kpis%ISOPEN) THEN
198: CLOSE c_kpis;
199: END IF;

Line 1320: l_Kpi_Name BSC_KPIS_VL.NAME%TYPE;

1316:
1317: l_Parent_Opt_Id NUMBER;
1318: l_Gra_Parent_Opt_Id NUMBER;
1319: l_default_value NUMBER;
1320: l_Kpi_Name BSC_KPIS_VL.NAME%TYPE;
1321:
1322: CURSOR c_kpi_ids IS
1323: SELECT indicator
1324: FROM BSC_KPIS_B

Line 3320: l_objective_name BSC_KPIS_VL.NAME%TYPE;

3316: l_dep_obj_message varchar2(1000);
3317: l_message varchar2(1000);
3318: l_AnaOpt_Name BSC_OAF_ANALYSYS_OPT_COMB_V.FULL_NAME%TYPE;
3319: l_kpi_name BSC_KPI_ANALYSIS_MEASURES_VL.NAME%TYPE;
3320: l_objective_name BSC_KPIS_VL.NAME%TYPE;
3321: l_objective BSC_KPIS_VL.NAME%TYPE;
3322:
3323: CURSOR c_Measure_ak IS
3324: SELECT c.actual_data_source actual_data_source , c.function_name function_name

Line 3321: l_objective BSC_KPIS_VL.NAME%TYPE;

3317: l_message varchar2(1000);
3318: l_AnaOpt_Name BSC_OAF_ANALYSYS_OPT_COMB_V.FULL_NAME%TYPE;
3319: l_kpi_name BSC_KPI_ANALYSIS_MEASURES_VL.NAME%TYPE;
3320: l_objective_name BSC_KPIS_VL.NAME%TYPE;
3321: l_objective BSC_KPIS_VL.NAME%TYPE;
3322:
3323: CURSOR c_Measure_ak IS
3324: SELECT c.actual_data_source actual_data_source , c.function_name function_name
3325: ,a.dataset_id dataset_id

Line 3340: FROM bsc_kpi_analysis_options_b a, bsc_kpis_vl b

3336: AND a.SERIES_ID = p_series_id;
3337:
3338: CURSOR c_AnaOpt_ak IS
3339: SELECT a.short_name , b.name
3340: FROM bsc_kpi_analysis_options_b a, bsc_kpis_vl b
3341: WHERE a.indicator = p_kpi_id
3342: AND a.option_id = p_option0
3343: AND a.parent_option_id = p_option1
3344: AND a.grandparent_option_id = p_option2

Line 3350: ,BSC_KPIS_VL b

3346:
3347: CURSOR c_KpiMeasure(p_dataset_id BSC_KPI_ANALYSIS_MEASURES_VL.dataset_id%TYPE) IS
3348: SELECT a.name KPI_NAME, b.name OBJECTVIE_NAME
3349: FROM BSC_KPI_ANALYSIS_MEASURES_VL a
3350: ,BSC_KPIS_VL b
3351: WHERE a.indicator = b.indicator
3352: AND a.dataset_id = p_dataset_id
3353: AND a.Indicator <> p_kpi_id
3354: AND a.Analysis_Option0 <> p_option0

Line 3361: FROM BSC_KPIS_VL

3357: AND a.SERIES_ID <> p_series_id;
3358:
3359: CURSOR c_KpiName(p_kpi_id BSC_KPIS_B.INDICATOR%TYPE) IS
3360: SELECT name
3361: FROM BSC_KPIS_VL
3362: WHERE indicator = p_kpi_id;
3363:
3364: BEGIN
3365: FND_MSG_PUB.Initialize;