APPS.PA_FUND_REVAL_PVT dependencies on PA_PROJECT_FUNDINGS

Line 1021: FROM pa_project_fundings

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

Line 1068: FROM pa_project_fundings

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

Line 1129: DELETE FROM pa_project_fundings

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

Line 9163: FROM pa_project_fundings

9159: CURSOR check_all_non_zero_amt(l_project_funding_id NUMBER) IS
9160: SELECT 'Y' non_zero_amt
9161: FROM DUAL
9162: WHERE EXISTS ( SELECT NULL
9163: FROM pa_project_fundings
9164: WHERE project_funding_id = l_project_funding_id
9165: AND ( projfunc_allocated_amount <> 0
9166: OR projfunc_realized_gains_amt <> 0
9167: OR projfunc_realized_losses_amt <> 0

Line 9193: /* Insert into table pa_project_fundings */

9189: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9190:
9191: END IF;
9192:
9193: /* Insert into table pa_project_fundings */
9194: l_SobId := G_SET_OF_BOOKS_ID;
9195:
9196: IF G_DEBUG_MODE = 'Y' THEN
9197:

Line 9215: PA_PROJECT_FUNDINGS_PKG. Insert_Row (

9211: OR (G_RevalCompTab(l_SobId).invproc_allocated_amount <> 0)
9212: OR (G_RevalCompTab(l_SobId).projfunc_realized_gains_amt <> 0)
9213: OR (G_RevalCompTab(l_SobId).projfunc_realized_losses_amt <> 0)) THEN
9214:
9215: PA_PROJECT_FUNDINGS_PKG. Insert_Row (
9216: X_Rowid => l_RowId ,
9217: X_Project_Funding_Id => l_ProjectFundingId ,
9218: X_Last_Update_Date => SYSDATE,
9219: X_Last_Updated_By => G_LAST_UPDATED_BY ,

Line 9447: DELETE FROM pa_project_fundings

9443: PA_FUND_REVAL_UTIL.Log_Message(l_LogMsg);
9444:
9445: END IF;
9446:
9447: DELETE FROM pa_project_fundings
9448: WHERE project_funding_id = l_ProjectFundingId;
9449:
9450: END IF; /* l_NonZeroExists = 'Y' */
9451:

Line 10170: FROM pa_project_fundings

10166: AND T.PROJECT_TYPE_ID = NVL(P_PROJECT_TYPE_ID ,T.project_type_id)
10167: AND NVL(P.revaluate_funding_flag, 'N') = 'Y'
10168: AND NVL(P.template_flag, 'N') = 'N'
10169: AND exists ( SELECT NULL
10170: FROM pa_project_fundings
10171: WHERE project_id = P.project_id
10172: AND funding_category = 'REVALUATION'
10173: AND budget_type_code = 'DRAFT')
10174: ORDER BY segment1 ;