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