APPS.PA_PROCESS_ACCUM_ACTUALS dependencies on PA_PROJECT_ACCUM_ACTUALS

Line 47: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

43: -- and the Project level record (Task id = 0 and Resourcelist member id = 0)
44:
45: IF ( x_actual_cost_flag = 'Y' ) THEN
46:
47: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
48: RAW_COST_ITD = RAW_COST_ITD + X_Raw_Cost,
49: RAW_COST_YTD = RAW_COST_YTD + X_Raw_Cost,
50: RAW_COST_PTD = RAW_COST_PTD + X_Raw_Cost,
51: BILLABLE_RAW_COST_ITD = BILLABLE_RAW_COST_ITD +

Line 92: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

88:
89: END IF;
90: IF ( x_revenue_flag = 'Y' ) THEN
91:
92: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
93: REVENUE_ITD = REVENUE_ITD + X_Revenue,
94: REVENUE_YTD = REVENUE_YTD + X_Revenue,
95: REVENUE_PTD = REVENUE_PTD + X_Revenue,
96: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

Line 160: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

156: pa_debug.debug(x_err_stack);
157:
158: IF(x_actual_cost_flag = 'Y') THEN
159:
160: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
161: RAW_COST_ITD = RAW_COST_ITD + X_Raw_Cost,
162: RAW_COST_YTD = RAW_COST_YTD + X_Raw_Cost,
163: RAW_COST_PP = RAW_COST_PP + X_Raw_Cost,
164: BILLABLE_RAW_COST_ITD = BILLABLE_RAW_COST_ITD +

Line 204: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

200: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
201: END IF;
202: IF(x_revenue_flag = 'Y') THEN
203:
204: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
205: REVENUE_ITD = REVENUE_ITD + X_Revenue,
206: REVENUE_YTD = REVENUE_YTD + X_Revenue,
207: REVENUE_PP = REVENUE_PP + X_Revenue,
208: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

Line 273: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

269: -- WBS hierarchy.It will update only the Project-task combination records
270: -- and the Project level record (Task id = 0 and Resourcelist member id = 0)
271: IF(x_actual_cost_flag = 'Y') THEN
272:
273: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
274: RAW_COST_ITD = RAW_COST_ITD + X_Raw_Cost,
275: RAW_COST_PP = RAW_COST_PP + X_Raw_Cost,
276: BILLABLE_RAW_COST_ITD = BILLABLE_RAW_COST_ITD +
277: X_Billable_Raw_Cost,

Line 308: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

304: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
305: END IF;
306: IF(x_revenue_flag = 'Y') THEN
307:
308: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
309: REVENUE_ITD = REVENUE_ITD + X_Revenue,
310: REVENUE_PP = REVENUE_PP + X_Revenue,
311: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
312: LAST_UPDATE_DATE = Trunc(Sysdate),

Line 376: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

372: -- The follwing Update statement updates all records in the given task
373: -- WBS hierarchy.It will update only the Project-task combination records
374: -- and the Project level record (Task id = 0 and Resourcelist member id = 0)
375: IF(x_actual_cost_flag = 'Y') THEN
376: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
377: RAW_COST_ITD = RAW_COST_ITD + X_Raw_Cost,
378: RAW_COST_YTD = RAW_COST_YTD + X_Raw_Cost,
379: BILLABLE_RAW_COST_ITD = BILLABLE_RAW_COST_ITD +
380: X_Billable_Raw_Cost,

Line 410: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

406:
407: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
408: END IF;
409: IF(x_revenue_flag = 'Y') THEN
410: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
411: REVENUE_ITD = REVENUE_ITD + X_Revenue,
412: REVENUE_YTD = REVENUE_YTD + X_Revenue,
413: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
414: LAST_UPDATE_DATE = Trunc(Sysdate),

Line 479: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

475: -- WBS hierarchy.It will update only the Project-task combination records
476: -- and the Project level record (Task id = 0 and Resourcelist member id = 0)
477: IF(x_actual_cost_flag = 'Y') THEN
478:
479: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
480: RAW_COST_ITD = RAW_COST_ITD + X_Raw_Cost,
481: BILLABLE_RAW_COST_ITD = BILLABLE_RAW_COST_ITD +
482: X_Billable_Raw_Cost,
483: BURDENED_COST_ITD = BURDENED_COST_ITD + X_Burdened_Cost,

Line 505: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

501: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
502: END IF;
503: IF(x_revenue_flag = 'Y') THEN
504:
505: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
506: REVENUE_ITD = REVENUE_ITD + X_Revenue,
507: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
508: LAST_UPDATE_DATE = Trunc(Sysdate),
509: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login