[Home] [Help]
5168:
5169: CURSOR l_invalid_funding_level_csr IS
5170: SELECT 'X'
5171: FROM gms_installments i,
5172: gms_summary_project_fundings f
5173: WHERE i.award_id = p_award_id
5174: AND f.installment_id = i.installment_id
5175: AND project_id = p_project_id
5176: AND ((task_id is null and p_task_id is not null) OR
5177: (task_id is not null and p_task_id is null));
5178:
5179: CURSOR l_existing_funding_amount_csr IS
5180: SELECT task_id,total_funding_amount
5181: FROM gms_summary_project_fundings gspf
5182: WHERE installment_id = P_installment_id
5183: AND project_id = P_project_id
5184: AND NVL(task_id,-99) = NVL(P_task_id,-99);
5185:
5419:
5420:
5421: -- ==============================================================================
5422: -- Determining the Funding Level
5423: -- We select task id, funding amount from gms_summary_project_fundings table
5424: -- We default the Project Funding Level to 'P' means Project Level.
5425: -- If the cursor did not find any record, then it would be 'F' meaning First Time
5426: -- time funding. If the select returns a Task Id then it would be Task Level
5427: -- Funding.
5569: X_MODE => 'R'
5570: );
5571:
5572: -- ================================================================
5573: -- GMS_SUMMARY_PROJECT_FUNDINGS need to be updated with this amount
5574: -- if this project and task and installment combination exists or
5575: -- this need to be inserted.
5576: -- ================================================================
5577:
5574: -- if this project and task and installment combination exists or
5575: -- this need to be inserted.
5576: -- ================================================================
5577:
5578: G_stage := 'gms_summary_project_fundings.create_funding' ;
5579:
5580: GMS_SUMM_FUNDING_PKG.CREATE_GMS_SUMMARY_FUNDING(
5581: X_INSTALLMENT_ID => P_installment_id,
5582: X_PROJECT_ID => P_project_id,