DBA Data[Home] [Help]

APPS.PA_PROCESS_ACCUM_BUDGETS dependencies on PA_PROJECT_ACCUM_BUDGETS

Line 78: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

74: -- WBS hierarchy.It will update only the Project-task combination records
75: -- and the Project level record (Task id = 0 and
76: -- Resourcelist member id = 0)
77:
78: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
79: BASE_RAW_COST_ITD = NVL(BASE_RAW_COST_ITD,0)+
80: NVL(X_Base_Raw_Cost_itd,0),
81: BASE_RAW_COST_YTD = NVL(BASE_RAW_COST_YTD,0)+
82: NVL(X_Base_Raw_Cost_ytd,0),

Line 211: -- PA_PROJECT_ACCUM_BUDGETS table. For the

207: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
208:
209:
210: -- Process_it_yt_pt_tasks_bud - Processes ITD,YTD and PTD amounts in the
211: -- PA_PROJECT_ACCUM_BUDGETS table. For the
212: -- given Project-Task combination,records are
213: -- created/updated and rolled up to all the
214: -- higher level tasks.
215:

Line 232: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

228: -- The follwing Update statement updates all records in the given task
229: -- WBS hierarchy.It will update only the Project-task combination records
230: -- and the Project level record (Task id = 0 and Resourcelist member id = 0)
231:
232: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
233: BASE_RAW_COST_ITD = NVL(BASE_RAW_COST_ITD,0) + X_Base_Raw_Cost,
234: BASE_RAW_COST_YTD = NVL(BASE_RAW_COST_YTD,0) + X_Base_Raw_Cost,
235: BASE_RAW_COST_PTD = NVL(BASE_RAW_COST_PTD,0) + X_Base_Raw_Cost,
236: ORIG_RAW_COST_ITD = ORIG_RAW_COST_ITD + X_Orig_Raw_Cost,

Line 321: -- PA_PROJECT_ACCUM_BUDGETS table. For the

317: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
318:
319:
320: -- Process_it_yt_pp_tasks_bud - Processes ITD,YTD and PP amounts in the
321: -- PA_PROJECT_ACCUM_BUDGETS table. For the
322: -- given Project-Task combination,records are
323: -- created/updated and rolled up to all the
324: -- higher level tasks.
325:

Line 341: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

337:
338: -- The follwing Update statement updates all records in the given task
339: -- WBS hierarchy.It will update only the Project-task combination records
340: -- and the Project level record (Task id = 0 and Resourcelist member id = 0)
341: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
342: BASE_RAW_COST_ITD = NVL(BASE_RAW_COST_ITD,0) + X_Base_Raw_Cost,
343: BASE_RAW_COST_YTD = NVL(BASE_RAW_COST_YTD,0) + X_Base_Raw_Cost,
344: BASE_RAW_COST_PP = NVL(BASE_RAW_COST_PP,0) + X_Base_Raw_Cost,
345: ORIG_RAW_COST_ITD = ORIG_RAW_COST_ITD + X_Orig_Raw_Cost,

Line 430: -- PA_PROJECT_ACCUM_BUDGETS table. For the

426: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
427:
428:
429: -- Process_it_pp_tasks_bud - Processes ITD and PP amounts in the
430: -- PA_PROJECT_ACCUM_BUDGETS table. For the
431: -- given Project-Task combination,records are
432: -- created/updated and rolled up to all the
433: -- higher level tasks.
434:

Line 451: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

447:
448: -- The follwing Update statement updates all records in the given task
449: -- WBS hierarchy.It will update only the Project-task combination records
450: -- and the Project level record (Task id = 0 and Resourcelist member id = 0)
451: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
452: BASE_RAW_COST_ITD = NVL(BASE_RAW_COST_ITD,0) + X_Base_Raw_Cost,
453: BASE_RAW_COST_PP = NVL(BASE_RAW_COST_PP,0) + X_Base_Raw_Cost,
454: ORIG_RAW_COST_ITD = ORIG_RAW_COST_ITD + X_Orig_Raw_Cost,
455: ORIG_RAW_COST_PP = ORIG_RAW_COST_PP + X_Orig_Raw_Cost,

Line 528: -- PA_PROJECT_ACCUM_BUDGETS table. For the

524: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
525:
526:
527: -- Process_it_yt_tasks_bud - Processes ITD and YTD amounts in the
528: -- PA_PROJECT_ACCUM_BUDGETS table. For the
529: -- given Project-Task combination,records are
530: -- created/updated and rolled up to all the
531: -- higher level tasks.
532:

Line 549: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

545:
546: -- The follwing Update statement updates all records in the given task
547: -- WBS hierarchy.It will update only the Project-task combination records
548: -- and the Project level record (Task id = 0 and Resourcelist member id = 0)
549: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
550: BASE_RAW_COST_ITD = NVL(BASE_RAW_COST_ITD,0) + X_Base_Raw_Cost,
551: BASE_RAW_COST_YTD = NVL(BASE_RAW_COST_YTD,0) + X_Base_Raw_Cost,
552: ORIG_RAW_COST_ITD = ORIG_RAW_COST_ITD + X_Orig_Raw_Cost,
553: ORIG_RAW_COST_YTD = ORIG_RAW_COST_YTD + X_Orig_Raw_Cost,

Line 625: -- PA_PROJECT_ACCUM_BUDGETS table. For the

621: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
622:
623:
624: -- Process_it_tasks_bud - Processes ITD amounts in the
625: -- PA_PROJECT_ACCUM_BUDGETS table. For the
626: -- given Project-Task combination,records are
627: -- created/updated and rolled up to all the
628: -- higher level tasks.
629:

Line 646: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

642:
643: -- The follwing Update statement updates all records in the given task
644: -- WBS hierarchy.It will update only the Project-task combination records
645: -- and the Project level record (Task id = 0 and Resourcelist member id = 0)
646: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
647: BASE_RAW_COST_ITD = NVL(BASE_RAW_COST_ITD,0) + X_Base_Raw_Cost,
648: ORIG_RAW_COST_ITD = ORIG_RAW_COST_ITD + X_Orig_Raw_Cost,
649: BASE_BURDENED_COST_ITD = BASE_BURDENED_COST_ITD +
650: X_Base_Burdened_Cost,