eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROCESS_ACCUM_ACTUALS_RES dependencies on PA_PROJECT_ACCUM_ACTUALS

Line 5: -- PA_PROJECT_ACCUM_ACTUALS table. For the

1: PACKAGE BODY PA_PROCESS_ACCUM_ACTUALS_RES AS
2: /* $Header: PAACRESB.pls 120.2 2005/08/31 11:08:00 vmangulu noship $ */
3:
4: -- This Procedure - Processes ITD,YTD and PTD amounts in the
5: -- PA_PROJECT_ACCUM_ACTUALS table. For the
6: -- given Project-Task-Resource combination,records are
7: -- created/updated and rolled up to all the
8: -- higher level tasks. The Project-Resource records
9: -- are also created/updated.

Line 55: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

51: -- records and the Project-Resource level record(Task id = 0 and
52: -- Resourcelist member id <> 0)
53:
54: IF(x_actual_cost_flag = 'Y') THEN
55: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
56: RAW_COST_ITD = RAW_COST_ITD + X_Raw_Cost,
57: RAW_COST_YTD = RAW_COST_YTD + X_Raw_Cost,
58: RAW_COST_PTD = RAW_COST_PTD + X_Raw_Cost,
59: BILLABLE_RAW_COST_ITD = BILLABLE_RAW_COST_ITD +

Line 103: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

99: connect by prior pt.parent_task_id = pt.task_id));
100: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
101: END IF;
102: IF(x_revenue_flag = 'Y') THEN
103: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
104: REVENUE_ITD = REVENUE_ITD + X_Revenue,
105: REVENUE_YTD = REVENUE_YTD + X_Revenue,
106: REVENUE_PTD = REVENUE_PTD + X_Revenue,
107: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

Line 130: -- PA_PROJECT_ACCUM_ACTUALS table. For the

126: RAISE;
127: End Process_it_yt_pt_res;
128:
129: -- This procedure - Processes ITD,YTD and PP amounts in the
130: -- PA_PROJECT_ACCUM_ACTUALS table. For the
131: -- given Project-Task-Resource combination,records are
132: -- created/updated and rolled up to all the
133: -- higher level tasks. The Project-Resource records
134: -- are also created/updated.

Line 180: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

176: -- WBS hierarchy.It will update only the Project-task-resource combination
177: -- records and the Project-Resource level record(Task id = 0 and
178: -- Resourcelist member id <> 0)
179: IF(x_actual_cost_flag = 'Y') THEN
180: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
181: RAW_COST_ITD = RAW_COST_ITD + X_Raw_Cost,
182: RAW_COST_YTD = RAW_COST_YTD + X_Raw_Cost,
183: RAW_COST_PP = RAW_COST_PP + X_Raw_Cost,
184: BILLABLE_RAW_COST_ITD = BILLABLE_RAW_COST_ITD +

Line 231: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

227: connect by prior pt.parent_task_id = pt.task_id));
228: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
229: END IF;
230: IF(x_revenue_flag = 'Y') THEN
231: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
232: REVENUE_ITD = REVENUE_ITD + X_Revenue,
233: REVENUE_YTD = REVENUE_YTD + X_Revenue,
234: REVENUE_PP = REVENUE_PP + X_Revenue,
235: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

Line 259: -- PA_PROJECT_ACCUM_ACTUALS table. For the

255:
256: End Process_it_yt_pp_res;
257:
258: -- Process_it_pp_res - Processes ITD and PP amounts in the
259: -- PA_PROJECT_ACCUM_ACTUALS table. For the
260: -- given Project-Task-Resource combination,records are
261: -- created/updated and rolled up to all the
262: -- higher level tasks. The Project-Resource records
263: -- are also created/updated.

Line 308: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

304: -- WBS hierarchy.It will update only the Project-task-resource combination
305: -- records and the Project-Resource level record(Task id = 0 and
306: -- Resourcelist member id <> 0)
307: IF(x_actual_cost_flag = 'Y') THEN
308: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
309: RAW_COST_ITD = RAW_COST_ITD + X_Raw_Cost,
310: RAW_COST_PP = RAW_COST_PP + X_Raw_Cost,
311: BILLABLE_RAW_COST_ITD = BILLABLE_RAW_COST_ITD +
312: X_Billable_Raw_Cost,

Line 345: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

341: connect by prior pt.parent_task_id = pt.task_id));
342: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
343: END IF;
344: IF(x_revenue_flag = 'Y') THEN
345: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
346: REVENUE_ITD = REVENUE_ITD + X_Revenue,
347: REVENUE_PP = REVENUE_PP + X_Revenue,
348: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
349: LAST_UPDATE_DATE = Trunc(Sysdate),

Line 371: -- PA_PROJECT_ACCUM_ACTUALS table. For the

367: RAISE ;
368: End Process_it_pp_res;
369:
370: -- This procedure - Processes ITD and YTD amounts in the
371: -- PA_PROJECT_ACCUM_ACTUALS table. For the
372: -- given Project-Task-Resource combination,records are
373: -- created/updated and rolled up to all the
374: -- higher level tasks. The Project-Resource records
375: -- are also created/updated.

Line 419: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

415: -- WBS hierarchy.It will update only the Project-task-resource combination
416: -- records and the Project-Resource level record(Task id = 0 and
417: -- Resourcelist member id <> 0)
418: IF(x_actual_cost_flag = 'Y') THEN
419: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
420: RAW_COST_ITD = RAW_COST_ITD + X_Raw_Cost,
421: RAW_COST_YTD = RAW_COST_YTD + X_Raw_Cost,
422: BILLABLE_RAW_COST_ITD = BILLABLE_RAW_COST_ITD +
423: X_Billable_Raw_Cost,

Line 456: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

452: connect by prior pt.parent_task_id = pt.task_id));
453: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
454: END IF;
455: IF(x_revenue_flag = 'Y') THEN
456: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
457: REVENUE_ITD = REVENUE_ITD + X_Revenue,
458: REVENUE_YTD = REVENUE_YTD + X_Revenue,
459: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
460: LAST_UPDATE_DATE = Trunc(Sysdate),

Line 483: -- PA_PROJECT_ACCUM_ACTUALS table. For the

479: RAISE ;
480: End Process_it_yt_res;
481:
482: -- This procedure - Processes ITD amounts in the
483: -- PA_PROJECT_ACCUM_ACTUALS table. For the
484: -- given Project-Task-Resource combination,records are
485: -- created/updated and rolled up to all the
486: -- higher level tasks. The Project-Resource records
487: -- are also created/updated.

Line 531: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

527: -- WBS hierarchy.It will update only the Project-task-resource combination
528: -- records and the Project-Resource level record(Task id = 0 and
529: -- Resourcelist member id <> 0)
530: IF(x_actual_cost_flag = 'Y') THEN
531: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
532: RAW_COST_ITD = RAW_COST_ITD + X_Raw_Cost,
533: BILLABLE_RAW_COST_ITD = BILLABLE_RAW_COST_ITD +
534: X_Billable_Raw_Cost,
535: BURDENED_COST_ITD = BURDENED_COST_ITD + X_Burdened_Cost,

Line 557: Update PA_PROJECT_ACCUM_ACTUALS PAA SET

553: connect by prior pt.parent_task_id = pt.task_id));
554: x_recs_processed := Recs_processed + SQL%ROWCOUNT;
555: END IF;
556: IF(x_revenue_flag = 'Y') THEN
557: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
558: REVENUE_ITD = REVENUE_ITD + X_Revenue,
559: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
560: LAST_UPDATE_DATE = Trunc(Sysdate),
561: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login