APPS.BSC_TAB_TPLATE dependencies on BSC_KPI_CALCULATIONS

Line 1199: l_sql := 'Insert Into BSC_KPI_CALCULATIONS '||

1195: NULL, -- changes_drill
1196: 0 -- default_value
1197: );
1198:
1199: l_sql := 'Insert Into BSC_KPI_CALCULATIONS '||
1200: '(INDICATOR, CALCULATION_ID, USER_LEVEL0,'||
1201: 'USER_LEVEL1,USER_LEVEL1_DEFAULT, USER_LEVEL2,'||
1202: 'USER_LEVEL2_DEFAULT, DEFAULT_VALUE ) values('||
1203: ':1,:2,:3,:4,null,null,null,0 )';

Line 1207: l_debug_stmt := 'Inserting BSC_KPI_CALCULATIONS' ||

1203: ':1,:2,:3,:4,null,null,null,0 )';
1204:
1205: For m_calculation In 0 .. (G_num_of_calculations - 1) Loop
1206:
1207: l_debug_stmt := 'Inserting BSC_KPI_CALCULATIONS' ||
1208: ', k_indicator=' || to_char(k_indicator) ||
1209: ', m_calculation=' || to_char(m_calculation) ||
1210: ', Indicator= ' || to_char(G_Ind_Tbl(k_indicator).Indicator);
1211: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);

Line 1217: Insert Into BSC_KPI_CALCULATIONS (

1213:
1214: End loop; -- calculation loop
1215: -- Vertical Analysis for PL
1216: if (G_Ind_Tbl(k_indicator).Indicator = 3013) then
1217: Insert Into BSC_KPI_CALCULATIONS (
1218: INDICATOR,
1219: CALCULATION_ID,
1220: USER_LEVEL0,
1221: USER_LEVEL1,