DBA Data[Home] [Help]

APPS.BSC_TAB_TPLATE dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 84: l_data_code BSC_KPI_ANALYSIS_MEASURES_B.dataset_id%type;

80: l_gl_left_r BSC_SYS_LINES.left_position%type;
81: l_gl_length BSC_SYS_LINES.length%type;
82: l_gl_arrow BSC_SYS_LINES.arrow%type;
83:
84: l_data_code BSC_KPI_ANALYSIS_MEASURES_B.dataset_id%type;
85: l_opt_caption BSC_KPI_ANALYSIS_OPTIONS_TL.name%type;
86: l_opt_lookup BSC_KPI_ANALYSIS_OPTIONS_B.option_id%type;
87:
88: l_cursor number;

Line 1246: l_debug_stmt := 'Inserting BSC_KPI_ANALYSIS_MEASURES_B' ||

1242: end if;
1243:
1244: SELECT bsc_kpi_measure_s.NEXTVAL INTO l_kpi_measure_id from dual;
1245:
1246: l_debug_stmt := 'Inserting BSC_KPI_ANALYSIS_MEASURES_B' ||
1247: ', k_indicator=' || to_char(k_indicator) ||
1248: ', Indicator= ' || to_char(G_Ind_Tbl(k_indicator).Indicator);
1249: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1250:

Line 1251: Insert Into BSC_KPI_ANALYSIS_MEASURES_B (

1247: ', k_indicator=' || to_char(k_indicator) ||
1248: ', Indicator= ' || to_char(G_Ind_Tbl(k_indicator).Indicator);
1249: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1250:
1251: Insert Into BSC_KPI_ANALYSIS_MEASURES_B (
1252: INDICATOR,
1253: ANALYSIS_OPTION0,
1254: ANALYSIS_OPTION1,
1255: ANALYSIS_OPTION2,