[Home] [Help]
563:
564:
565: -- Create temporary tables used for calculation and tranformations
566: -- Projection
567: h_b := BSC_UPDATE_CALC.Table_Has_Proj_Calc(x_base_table);
568: IF h_b IS NULL THEN
569: RAISE e_unexpected_error;
570: END IF;
571:
630:
631: IF h_project_flag = 1 THEN
632: -- Delete the projection from all the data columns in the table
633: --AW_INTEGRATION: Pass x_aw_flag and h_change_vector_value to Delete_Projection_Base_Table
634: IF NOT BSC_UPDATE_CALC.Delete_Projection_Base_Table(x_base_table,
635: h_periodicity_base_table,
636: h_current_per_base_table,
637: h_per_base_table,
638: h_data_columns,
650: -- AW_INTEGRATION: If the base table is for AW then there are not higher periodicities
651: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
652: FOR h_i IN 1..h_num_other_periodicities LOOP
653: --AW_INTEGRATION: Pass x_aw_flag to Delete_Projection_Base_Table and h_change_vector_value
654: IF NOT BSC_UPDATE_CALC.Delete_Projection_Base_Table(x_base_table,
655: h_arr_other_periodicities(h_i).periodicity_id,
656: h_arr_other_periodicities(h_i).current_period,
657: h_arr_other_periodicities(h_i).new_current_period,
658: h_data_columns,
733:
734: -- Calculate projection
735: IF h_projection_flag = 'YES' THEN
736: --ENH_PROJECTION_4235711: pass TRUE to x_trunc_proj_table parameter
737: IF NOT BSC_UPDATE_CALC.Create_Proj_Temps(h_periodicity_base_table,
738: h_current_fy,
739: h_num_of_years,
740: h_previous_years,
741: TRUE) THEN
742: RAISE e_unexpected_error;
743: END IF;
744:
745: -- AW_INTEGRATION: Pass x_aw_flag and h_change_vector_value to Calculate_Projection
746: IF NOT BSC_UPDATE_CALC.Calculate_Projection(x_base_table,
747: h_periodicity_base_table,
748: h_per_base_table,
749: h_key_columns,
750: h_num_key_columns,
779: -- We know that for Yearly periodicity we need to re-calculate projection.
780:
781: FOR h_i IN 1..h_num_other_periodicities LOOP
782: --ENH_PROJECTION_4235711: pass FALSE to x_trunc_proj_table parameter
783: IF NOT BSC_UPDATE_CALC.Create_Proj_Temps(h_arr_other_periodicities(h_i).periodicity_id,
784: h_current_fy,
785: h_num_of_years,
786: h_previous_years,
787: FALSE) THEN
791: IF h_arr_other_periodicities(h_i).yearly_flag = 1 THEN
792: -- We know that for yearly periodicity, we need to re-calculate
793: -- projection
794: -- AW_INTEGRATION: Pass x_aw_flag and change_vector value to Calculate_Projection
795: IF NOT BSC_UPDATE_CALC.Calculate_Projection(
796: x_base_table,
797: h_arr_other_periodicities(h_i).periodicity_id,
798: h_arr_other_periodicities(h_i).new_current_period,
799: h_key_columns,
813: ELSE
814: -- For other periodicites, the projection is calculated by rolling up the projection
815: -- already calculated for the base periodicity.
816: -- ENH_PROJECTION_4235711: no need to pass table name
817: IF NOT BSC_UPDATE_CALC.Rollup_Projection(
818: h_arr_other_periodicities(h_i).periodicity_id,
819: h_arr_other_periodicities(h_i).new_current_period,
820: h_periodicity_base_table,
821: h_per_base_table,
834: END LOOP;
835:
836: --ENH_PROJECTION_4235711: Projection for all the periodicities is already calculated in
837: -- BSC_TMP_PROC_CALC table. We can now merge the projection into the base table
838: IF NOT BSC_UPDATE_CALC.Merge_Projection(x_base_table,
839: h_key_columns,
840: h_num_key_columns,
841: h_data_columns,
842: h_num_data_columns,
854: -- Calculate Profit
855: -- BSC-MV Note: Only in this architecture the profit is calculated in the base table
856: -- AW_INTEGRATION: Profit needs to be calculated in this architecture too
857: IF BSC_APPS.bsc_mv THEN
858: h_b := BSC_UPDATE_CALC.Table_Has_Profit_Calc(x_base_table);
859: IF h_b IS NULL THEN
860: RAISE e_unexpected_error;
861: END IF;
862:
861: END IF;
862:
863: IF h_b THEN
864: -- AW_INTEGRATION: Pass x_aw_flag and change vector value to Calculate_Profit
865: IF NOT BSC_UPDATE_CALC.Calculate_Profit(x_base_table,
866: h_key_columns,
867: h_key_dim_tables,
868: h_num_key_columns,
869: h_data_columns,