APPS.PA_BASELINE_FUNDING_PKG dependencies on PA_FUNDING_CORE

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

450: OR (budget_type_code ='DRAFT'
451: AND funding_category= 'REVALUATION')))))
452: AND ((x_funding_level = 'T' and task_id is not null)
453: or (x_funding_level = 'P' and task_id is null))
454: AND nvl(PA_Funding_Core.G_FUND_BASELINE_FLAG,'N') ='N'
455: -- FP_M changes: Added UNION clause for Change Management enhancements
456: -- This cursor is modified to fetch only from the selected
457: -- funding lines that needs to be baselined ONLY when
458: -- a global value PA_Funding_Core.G_FUND_BASELINE_FLAG is enabled

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

454: AND nvl(PA_Funding_Core.G_FUND_BASELINE_FLAG,'N') ='N'
455: -- FP_M changes: Added UNION clause for Change Management enhancements
456: -- This cursor is modified to fetch only from the selected
457: -- funding lines that needs to be baselined ONLY when
458: -- a global value PA_Funding_Core.G_FUND_BASELINE_FLAG is enabled
459: group by task_id
460: UNION
461: SELECT task_id,
462: sum(nvl(projfunc_allocated_amount,0)) pf_fund_amt,

Line 466: AND PA_Funding_Core.G_FUND_BASELINE_FLAG = 'Y'

462: sum(nvl(projfunc_allocated_amount,0)) pf_fund_amt,
463: sum(nvl(project_allocated_amount,0)) proj_fund_amt
464: FROM pa_project_fundings
465: WHERE project_id = p_project_id
466: AND PA_Funding_Core.G_FUND_BASELINE_FLAG = 'Y'
467: AND (NVL(Submit_Baseline_Flag,'N') = 'Y' OR
468: budget_type_code = 'BASELINE' )
469: AND ((x_funding_level = 'T' and task_id is not null)
470: or ( x_funding_level = 'P' and task_id is null))

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

871: ) IS
872: BEGIN
873:
874: -- Set the global value
875: PA_Funding_Core.G_FUND_BASELINE_FLAG := 'Y';
876:
877: -- First update the submit_Baseline_Flag as 'Y' and then proceed for
878: -- further baselining of the funding lines
879: Update PA_Project_Fundings

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

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

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

907: ) IS
908: BEGIN
909:
910: -- Set the global value
911: PA_Funding_Core.G_FUND_BASELINE_FLAG := 'Y';
912:
913: -- First update the submit_Baseline_Flag as 'Y' and then proceed for
914: -- further baselining of the funding lines
915: FORALL ci_rec in P_CI_ID_Tab.FIRST..P_CI_ID_Tab.LAST

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

927: x_status => X_Status
928: );
929:
930: -- Unset the global value back to 'N'
931: PA_Funding_Core.G_FUND_BASELINE_FLAG := 'N';
932:
933: END Change_Management_Baseline;
934:
935: END PA_BASELINE_FUNDING_PKG;