APPS.BSC_TAB_TPLATE dependencies on BSC_KPI_ANALYSIS_OPTIONS_B

Line 86: l_opt_lookup BSC_KPI_ANALYSIS_OPTIONS_B.option_id%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;
89: l_ignore number;
90: l_sql_stmt varchar2(32700);

Line 1592: l_debug_stmt := 'Inserting BSC_KPI_ANALYSIS_OPTIONS_B' ||

1588: l_opt_caption := 'Option 0';
1589: l_opt_lookup := 0;
1590: end if;
1591:
1592: l_debug_stmt := 'Inserting BSC_KPI_ANALYSIS_OPTIONS_B' ||
1593: ', k_indicator=' || to_char(k_indicator) ||
1594: ', Indicator= ' || to_char(G_Ind_Tbl(k_indicator).Indicator);
1595: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1596:

Line 1597: l_sql_defaults_b := 'Insert Into BSC_KPI_ANALYSIS_OPTIONS_B (INDICATOR,'||

1593: ', k_indicator=' || to_char(k_indicator) ||
1594: ', Indicator= ' || to_char(G_Ind_Tbl(k_indicator).Indicator);
1595: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1596:
1597: l_sql_defaults_b := 'Insert Into BSC_KPI_ANALYSIS_OPTIONS_B (INDICATOR,'||
1598: 'ANALYSIS_GROUP_ID,OPTION_ID,PARENT_OPTION_ID,GRANDPARENT_OPTION_ID,'||
1599: 'DIM_SET_ID,USER_LEVEL0,USER_LEVEL1,USER_LEVEL1_DEFAULT,USER_LEVEL2,'||
1600: 'USER_LEVEL2_DEFAULT )Values (:1,0,0,0,0,0,1,1,NULL,NULL,NULL)';
1601: EXECUTE IMMEDIATE l_sql_defaults_b USING G_Ind_Tbl(k_indicator).Indicator;