APPS.PA_BILLING_CORE dependencies on PA_FUND_REVAL_PVT

Line 138: AND ( (budget_type_code IN ('DRAFT', 'BASELINE') AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N'

134: cursor funding_task is
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=

Line 140: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y' AND (

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') )))
144: OR (PA_Funding_Core.G_Fund_Baseline_Flag = 'Y' AND

Line 228: AND ( (budget_type_code IN ('DRAFT', 'BASELINE') AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N'

224: select sum(nvl(projfunc_allocated_amount,0))
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=

Line 230: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y' AND (

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') )))
234: OR (PA_Funding_Core.G_Fund_Baseline_Flag = 'Y' AND

Line 611: IF PA_FUND_REVAL_PVT.G_REVAL_FLAG='N' THEN

607: -- update only the projfunc, revproc and invproc columns
608: -- End if
609: --------------------------------------------------------*/
610:
611: IF PA_FUND_REVAL_PVT.G_REVAL_FLAG='N' THEN
612:
613: x_err_stage := 'Not Revaluation: change draft to baseline <' || to_char(x_project_id)
614: || '>';
615:

Line 654: ELSIF PA_FUND_REVAL_PVT.G_REVAL_FLAG='Y' THEN

650: last_updated_by = x_created_by,
651: last_update_login = x_last_update_login
652: where project_id = x_project_id;
653:
654: ELSIF PA_FUND_REVAL_PVT.G_REVAL_FLAG='Y' THEN
655:
656:
657: -- update summary funding
658: x_err_stage := 'update summary funding <' || to_char(x_project_id)