DBA Data[Home] [Help]

APPS.PA_PROCESS_ACCUM_BUDGETS_RES dependencies on PA_PROJECT_ACCUM_BUDGETS

Line 117: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

113: -- WBS hierarchy.It will update only the Project-task-resource combination
114: -- records and the Project-Resource level record(Task id = 0 and
115: -- Resourcelist member id <> 0)
116:
117: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
118: BASE_RAW_COST_ITD = NVL(BASE_RAW_COST_ITD,0) +
119: NVL(X_Base_Raw_Cost_itd,0),
120: BASE_RAW_COST_YTD = NVL(BASE_RAW_COST_YTD,0) +
121: NVL(X_Base_Raw_Cost_ytd,0),

Line 252: -- PA_PROJECT_ACCUM_BUDGETS table. For the

248: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
249:
250:
251: -- Process_it_yt_pt_res_bud - Processes ITD,YTD and PTD amounts in the
252: -- PA_PROJECT_ACCUM_BUDGETS table. For the
253: -- given Project-Task-Resource combination,records are
254: -- created/updated and rolled up to all the
255: -- higher level tasks. The Project-Resource records
256: -- are also created/updated.

Line 290: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

286: -- WBS hierarchy.It will update only the Project-task-resource combination
287: -- records and the Project-Resource level record(Task id = 0 and
288: -- Resourcelist member id <> 0)
289:
290: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
291: BASE_RAW_COST_ITD = BASE_RAW_COST_ITD + X_Base_Raw_Cost,
292: BASE_RAW_COST_YTD = BASE_RAW_COST_YTD + X_Base_Raw_Cost,
293: BASE_RAW_COST_PTD = BASE_RAW_COST_PTD + X_Base_Raw_Cost,
294: ORIG_RAW_COST_ITD = ORIG_RAW_COST_ITD + X_Orig_Raw_Cost,

Line 381: -- PA_PROJECT_ACCUM_BUDGETS table. For the

377: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
378:
379:
380: -- Process_it_yt_pp_res_bud - Processes ITD,YTD and PP amounts in the
381: -- PA_PROJECT_ACCUM_BUDGETS table. For the
382: -- given Project-Task-Resource combination,records are
383: -- created/updated and rolled up to all the
384: -- higher level tasks. The Project-Resource records
385: -- are also created/updated.

Line 418: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

414: -- WBS hierarchy.It will update only the Project-task-resource combination
415: -- records and the Project-Resource level record(Task id = 0 and
416: -- Resourcelist member id <> 0)
417:
418: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
419: BASE_RAW_COST_ITD = BASE_RAW_COST_ITD + X_Base_Raw_Cost,
420: BASE_RAW_COST_YTD = BASE_RAW_COST_YTD + X_Base_Raw_Cost,
421: BASE_RAW_COST_PP = BASE_RAW_COST_PP + X_Base_Raw_Cost,
422: ORIG_RAW_COST_ITD = ORIG_RAW_COST_ITD + X_Orig_Raw_Cost,

Line 510: -- PA_PROJECT_ACCUM_BUDGETS table. For the

506: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
507:
508:
509: -- Process_it_pp_res_bud - Processes ITD and PP amounts in the
510: -- PA_PROJECT_ACCUM_BUDGETS table. For the
511: -- given Project-Task-Resource combination,records are
512: -- created/updated and rolled up to all the
513: -- higher level tasks. The Project-Resource records
514: -- are also created/updated.

Line 548: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

544: -- WBS hierarchy.It will update only the Project-task-resource combination
545: -- records and the Project-Resource level record(Task id = 0 and
546: -- Resourcelist member id <> 0)
547:
548: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
549: BASE_RAW_COST_ITD = BASE_RAW_COST_ITD + X_Base_Raw_Cost,
550: BASE_RAW_COST_PP = BASE_RAW_COST_PP + X_Base_Raw_Cost,
551: ORIG_RAW_COST_ITD = ORIG_RAW_COST_ITD + X_Orig_Raw_Cost,
552: ORIG_RAW_COST_PP = ORIG_RAW_COST_PP + X_Orig_Raw_Cost,

Line 628: -- PA_PROJECT_ACCUM_BUDGETS table. For the

624: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
625:
626:
627: -- Process_it_yt_res_bud - Processes ITD and YTD amounts in the
628: -- PA_PROJECT_ACCUM_BUDGETS table. For the
629: -- given Project-Task-Resource combination,records are
630: -- created/updated and rolled up to all the
631: -- higher level tasks. The Project-Resource records
632: -- are also created/updated.

Line 665: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

661: -- WBS hierarchy.It will update only the Project-task-resource combination
662: -- records and the Project-Resource level record(Task id = 0 and
663: -- Resourcelist member id <> 0)
664:
665: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
666: BASE_RAW_COST_ITD = BASE_RAW_COST_ITD + X_Base_Raw_Cost,
667: BASE_RAW_COST_YTD = BASE_RAW_COST_YTD + X_Base_Raw_Cost,
668: ORIG_RAW_COST_ITD = ORIG_RAW_COST_ITD + X_Orig_Raw_Cost,
669: ORIG_RAW_COST_YTD = ORIG_RAW_COST_YTD + X_Orig_Raw_Cost,

Line 745: -- PA_PROJECT_ACCUM_BUDGETS table. For the

741: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
742:
743:
744: -- Process_it_res_bud - Processes ITD amounts in the
745: -- PA_PROJECT_ACCUM_BUDGETS table. For the
746: -- given Project-Task-Resource combination,records are
747: -- created/updated and rolled up to all the
748: -- higher level tasks. The Project-Resource records
749: -- are also created/updated.

Line 782: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

778: -- WBS hierarchy.It will update only the Project-task-resource combination
779: -- records and the Project-Resource level record(Task id = 0 and
780: -- Resourcelist member id <> 0)
781:
782: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
783: BASE_RAW_COST_ITD = BASE_RAW_COST_ITD + X_Base_Raw_Cost,
784: ORIG_RAW_COST_ITD = ORIG_RAW_COST_ITD + X_Orig_Raw_Cost,
785: BASE_BURDENED_COST_ITD = BASE_BURDENED_COST_ITD +
786: X_Base_Burdened_Cost,