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_OAF_VIEWS_PVT dependencies on BSC_KPIS_B

Line 62: FROM BSC_KPIS_B

58:
59: h_err NUMBER;
60: CURSOR c_kpi IS
61: SELECT INDICATOR_TYPE,CONFIG_TYPE
62: FROM BSC_KPIS_B
63: WHERE INDICATOR=X_INDICATOR;
64:
65: h_kpi_type NUMBER;
66: h_kpi_config NUMBER;

Line 316: h_color bsc_kpis_b.prototype_color%TYPE;

312:
313: h_kpi_prototype VARCHAR2(10);
314: h_kpi_measure_source bsc_kpi_defaults_b.measure_source%TYPE;
315: h_measure_source BSC_SYS_DATASETS_B.source%type;
316: h_color bsc_kpis_b.prototype_color%TYPE;
317: h_RED bsc_kpis_b.prototype_color%TYPE;
318: h_GREEN bsc_kpis_b.prototype_color%TYPE;
319: h_YELLOW bsc_kpis_b.prototype_color%TYPE;
320: h_GRAY bsc_kpis_b.prototype_color%TYPE;

Line 317: h_RED bsc_kpis_b.prototype_color%TYPE;

313: h_kpi_prototype VARCHAR2(10);
314: h_kpi_measure_source bsc_kpi_defaults_b.measure_source%TYPE;
315: h_measure_source BSC_SYS_DATASETS_B.source%type;
316: h_color bsc_kpis_b.prototype_color%TYPE;
317: h_RED bsc_kpis_b.prototype_color%TYPE;
318: h_GREEN bsc_kpis_b.prototype_color%TYPE;
319: h_YELLOW bsc_kpis_b.prototype_color%TYPE;
320: h_GRAY bsc_kpis_b.prototype_color%TYPE;
321: h_LIGHTGRAY bsc_kpis_b.prototype_color%TYPE;

Line 318: h_GREEN bsc_kpis_b.prototype_color%TYPE;

314: h_kpi_measure_source bsc_kpi_defaults_b.measure_source%TYPE;
315: h_measure_source BSC_SYS_DATASETS_B.source%type;
316: h_color bsc_kpis_b.prototype_color%TYPE;
317: h_RED bsc_kpis_b.prototype_color%TYPE;
318: h_GREEN bsc_kpis_b.prototype_color%TYPE;
319: h_YELLOW bsc_kpis_b.prototype_color%TYPE;
320: h_GRAY bsc_kpis_b.prototype_color%TYPE;
321: h_LIGHTGRAY bsc_kpis_b.prototype_color%TYPE;
322: h_WHITE bsc_kpis_b.prototype_color%TYPE;

Line 319: h_YELLOW bsc_kpis_b.prototype_color%TYPE;

315: h_measure_source BSC_SYS_DATASETS_B.source%type;
316: h_color bsc_kpis_b.prototype_color%TYPE;
317: h_RED bsc_kpis_b.prototype_color%TYPE;
318: h_GREEN bsc_kpis_b.prototype_color%TYPE;
319: h_YELLOW bsc_kpis_b.prototype_color%TYPE;
320: h_GRAY bsc_kpis_b.prototype_color%TYPE;
321: h_LIGHTGRAY bsc_kpis_b.prototype_color%TYPE;
322: h_WHITE bsc_kpis_b.prototype_color%TYPE;
323:

Line 320: h_GRAY bsc_kpis_b.prototype_color%TYPE;

316: h_color bsc_kpis_b.prototype_color%TYPE;
317: h_RED bsc_kpis_b.prototype_color%TYPE;
318: h_GREEN bsc_kpis_b.prototype_color%TYPE;
319: h_YELLOW bsc_kpis_b.prototype_color%TYPE;
320: h_GRAY bsc_kpis_b.prototype_color%TYPE;
321: h_LIGHTGRAY bsc_kpis_b.prototype_color%TYPE;
322: h_WHITE bsc_kpis_b.prototype_color%TYPE;
323:
324: d_A0 NUMBER;

Line 321: h_LIGHTGRAY bsc_kpis_b.prototype_color%TYPE;

317: h_RED bsc_kpis_b.prototype_color%TYPE;
318: h_GREEN bsc_kpis_b.prototype_color%TYPE;
319: h_YELLOW bsc_kpis_b.prototype_color%TYPE;
320: h_GRAY bsc_kpis_b.prototype_color%TYPE;
321: h_LIGHTGRAY bsc_kpis_b.prototype_color%TYPE;
322: h_WHITE bsc_kpis_b.prototype_color%TYPE;
323:
324: d_A0 NUMBER;
325: d_A1 NUMBER;

Line 322: h_WHITE bsc_kpis_b.prototype_color%TYPE;

318: h_GREEN bsc_kpis_b.prototype_color%TYPE;
319: h_YELLOW bsc_kpis_b.prototype_color%TYPE;
320: h_GRAY bsc_kpis_b.prototype_color%TYPE;
321: h_LIGHTGRAY bsc_kpis_b.prototype_color%TYPE;
322: h_WHITE bsc_kpis_b.prototype_color%TYPE;
323:
324: d_A0 NUMBER;
325: d_A1 NUMBER;
326: d_A2 NUMBER;

Line 377: FROM BSC_KPIS_B

373: 5,'FALSE',
374: 6,'FALSE',
375: 'TRUE') PROTOTYPE
376: INTO h_kpi_prototype
377: FROM BSC_KPIS_B
378: WHERE INDICATOR =X_INDICATOR;
379: -- Calculate the Color
380: IF h_measure_source ='BSC' THEN
381: IF h_com_default = 1 THEN

Line 417: from BSC_KPIS_B

413: -- else it returns either 1 (default) or 2 (non-default).
414:
415: cursor c_kpi is
416: select indicator_type,config_type
417: from BSC_KPIS_B
418: where indicator = x_indicator;
419:
420: h_ag_count number;
421: h_ag1_depend number;

Line 611: from BSC_KPIS_B

607:
608: -- determine if this is a simulation tree indicator.
609: select count(indicator)
610: into l_simul_tree
611: from BSC_KPIS_B
612: where indicator = x_indicator
613: and indicator_type = 1
614: and config_type = 7;
615: