APPS.PA_BASELINE_FUNDING_PKG dependencies on PA_FUNDING_CORE

Line 441: AND nvl(PA_Funding_Core.G_FUND_BASELINE_FLAG,'N') ='N'

437: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y'
438: AND (((budget_type_code ='BASELINE')
439: OR (budget_type_code ='DRAFT'
440: AND funding_category= 'REVALUATION')))))
441: AND nvl(PA_Funding_Core.G_FUND_BASELINE_FLAG,'N') ='N'
442: -- FP_M changes: Added UNION clause for Change Management enhancements
443: -- This cursor is modified to fetch only from the selected
444: -- funding lines that needs to be baselined ONLY when
445: -- a global value PA_Funding_Core.G_FUND_BASELINE_FLAG is enabled

Line 445: -- a global value PA_Funding_Core.G_FUND_BASELINE_FLAG is enabled

441: AND nvl(PA_Funding_Core.G_FUND_BASELINE_FLAG,'N') ='N'
442: -- FP_M changes: Added UNION clause for Change Management enhancements
443: -- This cursor is modified to fetch only from the selected
444: -- funding lines that needs to be baselined ONLY when
445: -- a global value PA_Funding_Core.G_FUND_BASELINE_FLAG is enabled
446: group by task_id
447: UNION
448: SELECT task_id,
449: sum(nvl(projfunc_allocated_amount,0)) pf_fund_amt,

Line 453: AND PA_Funding_Core.G_FUND_BASELINE_FLAG = 'Y'

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' )
456: group by task_id;
457:

Line 840: PA_Funding_Core.G_FUND_BASELINE_FLAG := 'Y';

836: ) IS
837: BEGIN
838:
839: -- Set the global value
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

Line 860: PA_Funding_Core.G_FUND_BASELINE_FLAG := 'N';

856: x_status => X_Status
857: );
858:
859: -- Unset the global value back to 'N'
860: PA_Funding_Core.G_FUND_BASELINE_FLAG := 'N';
861:
862: END Proj_Agreement_Baseline;
863:
864: -- FP_M changes:

Line 876: PA_Funding_Core.G_FUND_BASELINE_FLAG := 'Y';

872: ) IS
873: BEGIN
874:
875: -- Set the global value
876: PA_Funding_Core.G_FUND_BASELINE_FLAG := 'Y';
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

Line 896: PA_Funding_Core.G_FUND_BASELINE_FLAG := 'N';

892: x_status => X_Status
893: );
894:
895: -- Unset the global value back to 'N'
896: PA_Funding_Core.G_FUND_BASELINE_FLAG := 'N';
897:
898: END Change_Management_Baseline;
899:
900: END PA_BASELINE_FUNDING_PKG;