APPS.PA_BASELINE_FUNDING_PKG dependencies on PA_PROJECT_FUNDINGS

Line 221: FROM pa_project_fundings

217: IS
218:
219: CURSOR funding_amount is
220: SELECT task_id, sum(nvl(projfunc_allocated_amount,0)) fund_amt
221: FROM pa_project_fundings
222: WHERE project_id = p_project_id
223: AND ( (budget_type_code IN ('DRAFT', 'BASELINE') AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N')
224: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y' AND (
225: ( (budget_type_code ='BASELINE') OR

Line 433: FROM pa_project_fundings

429: /* Added for fp */
430: CURSOR funding_amount is
431: SELECT task_id, sum(nvl(projfunc_allocated_amount,0)) pf_fund_amt,
432: sum(nvl(project_allocated_amount,0)) proj_fund_amt
433: FROM pa_project_fundings
434: WHERE project_id = p_project_id
435: AND ((budget_type_code IN ('DRAFT', 'BASELINE')
436: AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N')
437: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y'

Line 451: FROM pa_project_fundings

447: UNION
448: SELECT task_id,
449: sum(nvl(projfunc_allocated_amount,0)) pf_fund_amt,
450: sum(nvl(project_allocated_amount,0)) proj_fund_amt
451: FROM pa_project_fundings
452: WHERE project_id = p_project_id
453: AND PA_Funding_Core.G_FUND_BASELINE_FLAG = 'Y'
454: AND (NVL(Submit_Baseline_Flag,'N') = 'Y' OR
455: budget_type_code = 'BASELINE' )

Line 844: Update PA_Project_Fundings

840: PA_Funding_Core.G_FUND_BASELINE_FLAG := 'Y';
841:
842: -- First update the submit_Baseline_Flag as 'Y' and then proceed for
843: -- further baselining of the funding lines
844: Update PA_Project_Fundings
845: SET Submit_Baseline_Flag = 'Y'
846: Where Project_ID = P_Project_ID
847: AND Agreement_ID = P_Agreement_ID
848: AND CI_ID is null

Line 881: Update PA_Project_Fundings

877:
878: -- First update the submit_Baseline_Flag as 'Y' and then proceed for
879: -- further baselining of the funding lines
880: FORALL ci_rec in P_CI_ID_Tab.FIRST..P_CI_ID_Tab.LAST
881: Update PA_Project_Fundings
882: SET Submit_Baseline_Flag = 'Y'
883: Where Project_ID = P_Project_ID
884: AND CI_ID = P_CI_ID_Tab(ci_rec)
885: AND Budget_Type_Code = 'DRAFT'