[Home] [Help]
790: FETCH vl_bal_retcur INTO vl_conc_seg , vl_acc_seg ,vl_bal_seg ,
791: vl_report_id ,vl_column_id , vl_amount ;
792: EXIT WHEN vl_bal_retcur%NOTFOUND ;
793:
794: -- Popualte Fund_value in the temp table Fv_Funds_Avail_Temp
795: Create_Transactions(vl_conc_seg,
796: vl_bal_seg ,
797: vl_report_id ,
798: vl_column_id ,
806:
807: FETCH vl_bal_retcur INTO vl_conc_seg , vl_acc_seg , vl_report_id ,
808: vl_column_id , vl_amount ;
809: EXIT WHEN vl_bal_retcur%NOTFOUND ;
810: -- Popualte Fund_value as NULL in the temp table Fv_Funds_Avail_Temp
811: Create_Transactions(vl_conc_seg,
812: NULL ,
813: vl_report_id ,
814: vl_column_id ,
848:
849: BEGIN
850: l_module_name := g_module_name || 'Submit_Reports';
851: SELECT COUNT(*) INTO vl_count FROM
852: Fv_Funds_Avail_Temp WHERE
853: report_id =vp_report_id ;
854: IF vl_count = 0 THEN
855: vp_retcode := 1 ;
856: IF vp_summary_type='T' THEN
871:
872: -- Check if available balances for all funds equal zero
873: -- If so, dont kick off reports.
874: SELECT COUNT(*) INTO vl_count FROM
875: Fv_Funds_Avail_Temp WHERE
876: report_id = vp_report_id AND
877: amount <> 0;
878:
879: IF vl_count = 0 THEN
917: -- ------------------------------------------------------------------
918: -- Procedure Create_Transactions
919: -- ------------------------------------------------------------------
920: -- Create_Transactions procedure is called from the populate_ccid procedure.
921: -- This procedure creates the data in the Fv_Funds_Avail_temp Table.
922: --
923: -- ------------------------------------------------------------------
924: PROCEDURE Create_Transactions
925: ( CONCAT_SEGMENTS VARCHAR2,
933: l_module_name VARCHAR2(200);
934: BEGIN
935: l_module_name := g_module_name || 'Create_Transactions';
936:
937: INSERT INTO Fv_Funds_Avail_temp (CONCAT_SEGMENTS,
938: FUND_VALUE ,
939: REPORT_ID ,
940: COLUMN_ID,
941: AMOUNT ,