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_UPDATE dependencies on BSC_DB_CALCULATIONS

Line 175: DELETE FROM bsc_db_calculations

171: c_calculation_type := 6;
172: h_num_system_tables := 0;
173:
174: -- Delete current configuration
175: DELETE FROM bsc_db_calculations
176: WHERE table_name = p_base_table AND calculation_type = c_calculation_type;
177:
178: -- Get base table periodicity
179: h_base_table_periodicity := BSC_UPDATE_UTIL.Get_Table_Periodicity(p_base_table);

Line 207: INSERT INTO bsc_db_calculations (table_name, calculation_type, parameter1)

203: OPEN h_cursor FOR h_sql;
204: FETCH h_cursor INTO h_periodicity_id;
205: WHILE h_cursor%FOUND LOOP
206: IF h_periodicity_id <> h_base_table_periodicity THEN
207: INSERT INTO bsc_db_calculations (table_name, calculation_type, parameter1)
208: VALUES (p_base_table, c_calculation_type, h_periodicity_id);
209: END IF;
210:
211: FETCH h_cursor INTO h_periodicity_id;

Line 306: -- Fix bug#3796202,we need to delete all the profit calculations from bsc_db_calculations

302:
303: h_column_type_p := 'P';
304: h_calculation_type := 1;
305:
306: -- Fix bug#3796202,we need to delete all the profit calculations from bsc_db_calculations
307: DELETE FROM bsc_db_calculations WHERE calculation_type = h_calculation_type;
308:
309: -- Next query find all the base tables using any sub-account dimension.
310: -- It looks in all the PL indicators to know what are the different sub-account

Line 307: DELETE FROM bsc_db_calculations WHERE calculation_type = h_calculation_type;

303: h_column_type_p := 'P';
304: h_calculation_type := 1;
305:
306: -- Fix bug#3796202,we need to delete all the profit calculations from bsc_db_calculations
307: DELETE FROM bsc_db_calculations WHERE calculation_type = h_calculation_type;
308:
309: -- Next query find all the base tables using any sub-account dimension.
310: -- It looks in all the PL indicators to know what are the different sub-account
311: -- dimensions.

Line 317: INSERT INTO bsc_db_calculations (table_name, calculation_type, parameter1)

313: LOOP
314: FETCH h_cursor INTO h_base_table, h_pk_level_subaccount;
315: EXIT WHEN h_cursor%NOTFOUND;
316:
317: INSERT INTO bsc_db_calculations (table_name, calculation_type, parameter1)
318: VALUES(h_base_table, h_calculation_type, h_pk_level_subaccount);
319: END LOOP;
320: CLOSE h_cursor;
321:

Line 1062: FROM bsc_db_calculations c, bsc_sys_periodicities p

1058:
1059:
1060: CURSOR c_other_periodicities (p_table_name VARCHAR2, p_calc_type NUMBER) IS
1061: SELECT c.parameter1, p.yearly_flag
1062: FROM bsc_db_calculations c, bsc_sys_periodicities p
1063: WHERE c.table_name = p_table_name AND c.calculation_type = p_calc_type AND
1064: c.parameter1 = p.periodicity_id;
1065:
1066: TYPE t_tables IS RECORD (