APPS.BSC_TAB_TPLATE dependencies on BSC_KPI_ANALYSIS_OPTIONS_TL

Line 85: l_opt_caption BSC_KPI_ANALYSIS_OPTIONS_TL.name%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;
89: l_ignore number;

Line 1603: l_debug_stmt := 'Inserting BSC_KPI_ANALYSIS_OPTIONS_TL' ||

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;
1602:
1603: l_debug_stmt := 'Inserting BSC_KPI_ANALYSIS_OPTIONS_TL' ||
1604: ', k_indicator=' || to_char(k_indicator) ||
1605: ', Indicator= ' || to_char(G_Ind_Tbl(k_indicator).Indicator);
1606: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1607:

Line 1608: l_sql_stmt := 'INSERT INTO BSC_KPI_ANALYSIS_OPTIONS_TL

1604: ', k_indicator=' || to_char(k_indicator) ||
1605: ', Indicator= ' || to_char(G_Ind_Tbl(k_indicator).Indicator);
1606: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1607:
1608: l_sql_stmt := 'INSERT INTO BSC_KPI_ANALYSIS_OPTIONS_TL
1609: (INDICATOR,ANALYSIS_GROUP_ID,OPTION_ID,PARENT_OPTION_ID,GRANDPARENT_OPTION_ID,
1610: LANGUAGE,SOURCE_LANG,NAME,HELP)
1611: SELECT '
1612: ||G_Ind_Tbl(k_indicator).Indicator||' AS INDICATOR,