313: END IF;
314:
315: -- Store the update period of input table and base table
316: IF NOT x_correction_flag THEN
317: update bsc_db_tables
318: set current_period = h_per_input_table
319: where table_name = x_input_table;
320:
321: update bsc_db_tables
317: update bsc_db_tables
318: set current_period = h_per_input_table
319: where table_name = x_input_table;
320:
321: update bsc_db_tables
322: set current_period = h_per_base_table
323: where table_name = x_base_table;
324:
325: commit;
446: -- Get the current period of the input table
447: BEGIN
448: SELECT NVL(current_period, 0)
449: INTO h_current_period
450: FROM bsc_db_tables
451: WHERE table_name = x_input_table;
452: EXCEPTION
453: WHEN NO_DATA_FOUND THEN
454: h_current_period := 0;
567: -- Get the current period of the base table
568: BEGIN
569: SELECT NVL(current_period, 0)
570: INTO h_current_period
571: FROM bsc_db_tables
572: WHERE table_name = x_base_table;
573: EXCEPTION
574: WHEN NO_DATA_FOUND THEN
575: h_current_period := 0;