APPS.PA_BILLING_CORE dependencies on PA_FUNDING_CORE

Line 139: AND PA_Funding_Core.G_Fund_Baseline_Flag = 'N')

135: select task_id, sum(nvl(projfunc_allocated_amount,0)) funding_total
136: from pa_project_fundings
137: where project_id = x_project_id
138: AND ( (budget_type_code IN ('DRAFT', 'BASELINE') AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N'
139: AND PA_Funding_Core.G_Fund_Baseline_Flag = 'N')
140: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y' AND (
141: ( (budget_type_code ='BASELINE') OR
142: (budget_type_code ='DRAFT' AND funding_category=
143: 'REVALUATION') )))

Line 144: OR (PA_Funding_Core.G_Fund_Baseline_Flag = 'Y' AND

140: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y' AND (
141: ( (budget_type_code ='BASELINE') OR
142: (budget_type_code ='DRAFT' AND funding_category=
143: 'REVALUATION') )))
144: OR (PA_Funding_Core.G_Fund_Baseline_Flag = 'Y' AND
145: ( Budget_Type_Code = 'BASELINE' ) OR -- Modified for bug 4057927
146: ( Budget_Type_Code = 'DRAFT' AND NVL(Submit_Baseline_Flag,'N') = 'Y') )
147: )
148: and task_id is not null

Line 229: AND PA_Funding_Core.G_Fund_Baseline_Flag = 'N')

225: into funding_total
226: from pa_project_fundings
227: where project_id = x_project_id
228: AND ( (budget_type_code IN ('DRAFT', 'BASELINE') AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N'
229: AND PA_Funding_Core.G_Fund_Baseline_Flag = 'N')
230: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y' AND (
231: ( (budget_type_code ='BASELINE') OR
232: (budget_type_code ='DRAFT' AND funding_category=
233: 'REVALUATION') )))

Line 234: OR (PA_Funding_Core.G_Fund_Baseline_Flag = 'Y' AND

230: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y' AND (
231: ( (budget_type_code ='BASELINE') OR
232: (budget_type_code ='DRAFT' AND funding_category=
233: 'REVALUATION') )))
234: OR (PA_Funding_Core.G_Fund_Baseline_Flag = 'Y' AND
235: ( Budget_Type_Code = 'BASELINE') OR -- Modified for bug 4057927
236: ( Budget_Type_Code = 'DRAFT' AND NVL(Submit_Baseline_Flag,'N') = 'Y') )
237: );
238:

Line 736: ELSIF PA_Funding_Core.G_FUND_BASELINE_FLAG = 'Y' THEN

732: -- FP_M Changes
733: -- Following IF clause is used only for baselining only required
734: -- Project's agreements funding lines
735: -----------------------------------------------------------------------
736: ELSIF PA_Funding_Core.G_FUND_BASELINE_FLAG = 'Y' THEN
737: -- update summary funding
738: x_err_stage := 'update summary funding <' || to_char(x_project_id) || '>';
739:
740: FOR Agreement_rec IN ( SELECT project_funding_id, agreement_id,

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

777: AND agreement_id = Agreement_rec.agreement_id
778: AND nvl(task_id,0) = nvl(Agreement_rec.task_id,0);
779:
780: -- Unset the global fund baseline flag back to 'N'
781: PA_Funding_Core.G_FUND_BASELINE_FLAG := 'N';
782:
783: END LOOP;
784:
785: END IF;

Line 1410: pa_funding_core.get_MCB2_attributes(

1406: EXIT when tmp_proj_funding%NOTFOUND or x_err_code <> 0;
1407:
1408: x_err_stage := 'Get values for MCB2 columns ';
1409:
1410: pa_funding_core.get_MCB2_attributes(
1411: p_project_id => proj_rec.project_id,
1412: p_agreement_id => proj_rec.agreement_id,
1413: p_date_allocated => proj_rec.date_allocated,
1414: p_allocated_amount => proj_rec.allocated_amount,

Line 1561: pa_funding_core.get_MCB2_attributes(

1557: EXIT when tmp_task_funding%NOTFOUND or x_err_code <> 0;
1558:
1559: x_err_stage := 'Get values for MCB2 columns ';
1560:
1561: pa_funding_core.get_MCB2_attributes(
1562: p_project_id => task_rec.project_id,
1563: p_agreement_id => task_rec.agreement_id,
1564: p_date_allocated => task_rec.date_allocated,
1565: p_allocated_amount => task_rec.allocated_amount,