APPS.PA_FUND_REVAL_PVT dependencies on PA_PROJECT_FUNDINGS

Line 1023: FROM pa_project_fundings

1019:
1020: SELECT 'T' INTO l_ExistFlag
1021: FROM DUAL
1022: WHERE EXISTS (SELECT NULL
1023: FROM pa_project_fundings
1024: WHERE project_id = p_project_id
1025: AND funding_category = 'REVALUATION'
1026: AND budget_type_code = 'DRAFT');
1027:

Line 1070: FROM pa_project_fundings

1066: CURSOR fund_recs is
1067: SELECT project_funding_id, agreement_id, project_id, task_id, projfunc_allocated_amount,
1068: projfunc_realized_gains_amt, projfunc_realized_losses_amt, invproc_allocated_amount,
1069: revproc_allocated_amount
1070: FROM pa_project_fundings
1071: WHERE project_id = p_project_id
1072: AND funding_category = 'REVALUATION'
1073: AND budget_type_code = 'DRAFT';
1074:

Line 1131: DELETE FROM pa_project_fundings

1127: WHERE project_funding_id = l_FundingIdTab(i)
1128: AND Project_ID = l_ProjectIdTab(i);
1129:
1130: FORALL i IN l_FundingIdTab.FIRST..l_FundingIdTab.LAST
1131: DELETE FROM pa_project_fundings
1132: WHERE project_funding_id = l_FundingIdTab(i);
1133:
1134: FORALL i IN l_ProjfuncAllocTab.FIRST..l_ProjfuncAllocTab.LAST
1135: UPDATE pa_summary_project_fundings

Line 9196: FROM pa_project_fundings

9192: CURSOR check_all_non_zero_amt(l_project_funding_id NUMBER) IS
9193: SELECT 'Y' non_zero_amt
9194: FROM DUAL
9195: WHERE EXISTS ( SELECT NULL
9196: FROM pa_project_fundings
9197: WHERE project_funding_id = l_project_funding_id
9198: AND ( projfunc_allocated_amount <> 0
9199: OR projfunc_realized_gains_amt <> 0
9200: OR projfunc_realized_losses_amt <> 0

Line 9226: /* Insert into table pa_project_fundings */

9222: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9223:
9224: END IF;
9225:
9226: /* Insert into table pa_project_fundings */
9227: l_SobId := G_SET_OF_BOOKS_ID;
9228:
9229: IF G_DEBUG_MODE = 'Y' THEN
9230:

Line 9248: PA_PROJECT_FUNDINGS_PKG. Insert_Row (

9244: OR (G_RevalCompTab(l_SobId).invproc_allocated_amount <> 0)
9245: OR (G_RevalCompTab(l_SobId).projfunc_realized_gains_amt <> 0)
9246: OR (G_RevalCompTab(l_SobId).projfunc_realized_losses_amt <> 0)) THEN
9247:
9248: PA_PROJECT_FUNDINGS_PKG. Insert_Row (
9249: X_Rowid => l_RowId ,
9250: X_Project_Funding_Id => l_ProjectFundingId ,
9251: X_Last_Update_Date => SYSDATE,
9252: X_Last_Updated_By => G_LAST_UPDATED_BY ,

Line 9480: DELETE FROM pa_project_fundings

9476: PA_FUND_REVAL_UTIL.Log_Message(l_LogMsg);
9477:
9478: END IF;
9479:
9480: DELETE FROM pa_project_fundings
9481: WHERE project_funding_id = l_ProjectFundingId;
9482:
9483: END IF; /* l_NonZeroExists = 'Y' */
9484:

Line 10203: FROM pa_project_fundings

10199: AND T.PROJECT_TYPE_ID = NVL(P_PROJECT_TYPE_ID ,T.project_type_id)
10200: AND NVL(P.revaluate_funding_flag, 'N') = 'Y'
10201: AND NVL(P.template_flag, 'N') = 'N'
10202: AND exists ( SELECT NULL
10203: FROM pa_project_fundings
10204: WHERE project_id = P.project_id
10205: AND funding_category = 'REVALUATION'
10206: AND budget_type_code = 'DRAFT')
10207: ORDER BY segment1 ;