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_COMMITMENTS dependencies on PA_PROJECT_ACCUM_COMMITMENTS

Line 23: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the

19: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
20:
21:
22: -- Process_it_yt_pt_tasks_cmt - Processes ITD,YTD and PTD amounts in the
23: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the
24: -- given Project-Task combination,records are
25: -- created/updated and rolled up to all the
26: -- higher level tasks.
27: Recs_processed Number := 0;

Line 40: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this

36: x_err_stack ||'->PA_PROCESS_ACCUM_COMMITMENTS.Process_it_yt_pt_tasks_cmt';
37:
38: pa_debug.debug(x_err_stack);
39:
40: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
41: -- project and task combination. It is possible that there might be a
42: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
43: -- no corresponding detail record. The procedure called below,will
44: -- check for the existence of the detail records and if not available

Line 62: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET

58: -- The follwing Update statement updates all records in the given task
59: -- WBS hierarchy.It will update only the Project-task combination records
60: -- and the Project level record (Task id = 0 and Resourcelist member id = 0)
61:
62: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
63: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
64: CMT_RAW_COST_YTD = CMT_RAW_COST_YTD + X_Raw_Cost,
65: CMT_RAW_COST_PTD = CMT_RAW_COST_PTD + X_Raw_Cost,
66: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,

Line 123: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

119: x_err_stage,
120: x_err_code);
121:
122: Recs_processed := Recs_processed + 1;
123: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
124: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
125: CMT_RAW_COST_PTD,
126: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
127: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 169: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the

165: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
166:
167:
168: -- Process_it_yt_pp_tasks_cmt - Processes ITD,YTD and PP amounts in the
169: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the
170: -- given Project-Task combination,records are
171: -- created/updated and rolled up to all the
172: -- higher level tasks.
173:

Line 189: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this

185:
186:
187: pa_debug.debug(x_err_stack);
188:
189: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
190: -- project and task combination. It is possible that there might be a
191: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
192: -- no corresponding detail record. The procedure called below,will
193: -- check for the existence of the detail records and if not available

Line 211: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET

207: -- The follwing Update statement updates all records in the given task
208: -- WBS hierarchy.It will update only the Project-task combination records
209: -- and the Project level record (Task id = 0 and Resourcelist member id = 0)
210:
211: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
212: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
213: CMT_RAW_COST_YTD = CMT_RAW_COST_YTD + X_Raw_Cost,
214: CMT_RAW_COST_PP = CMT_RAW_COST_PP + X_Raw_Cost,
215: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,

Line 264: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

260: x_err_stage,
261: x_err_code);
262:
263: Recs_processed := Recs_processed + 1;
264: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
265: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
266: CMT_RAW_COST_PTD,
267: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
268: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 311: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the

307: x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
308: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
309:
310: -- Process_it_pp_tasks_cmt - Processes ITD and PP amounts in the
311: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the
312: -- given Project-Task combination,records are
313: -- created/updated and rolled up to all the
314: -- higher level tasks.
315:

Line 331: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this

327: x_err_stack ||'->PA_PROCESS_ACCUM_COMMITMENTS.Process_it_pp_tasks_cmt';
328:
329: pa_debug.debug(x_err_stack);
330:
331: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
332: -- project and task combination. It is possible that there might be a
333: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
334: -- no corresponding detail record. The procedure called below,will
335: -- check for the existence of the detail records and if not available

Line 353: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET

349: -- The follwing Update statement updates all records in the given task
350: -- WBS hierarchy.It will update only the Project-task combination records
351: -- and the Project level record (Task id = 0 and Resourcelist member id = 0)
352:
353: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
354: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
355: CMT_RAW_COST_PP = CMT_RAW_COST_PP + X_Raw_Cost,
356: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
357: CMT_BURDENED_COST_PP = CMT_BURDENED_COST_PP + X_Burdened_Cost,

Line 413: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

409: x_err_stage,
410: x_err_code);
411:
412: Recs_processed := Recs_processed + 1;
413: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
414: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
415: CMT_RAW_COST_PTD,
416: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
417: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 458: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the

454: x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
455: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
456:
457: -- Process_it_yt_tasks_cmt - Processes ITD and YTD amounts in the
458: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the
459: -- given Project-Task combination,records are
460: -- created/updated and rolled up to all the
461: -- higher level tasks.
462:

Line 477: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this

473: x_err_stack ||'->PA_PROCESS_ACCUM_COMMITMENTS.Process_it_yt_tasks_cmt';
474:
475: pa_debug.debug(x_err_stack);
476:
477: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
478: -- project and task combination. It is possible that there might be a
479: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
480: -- no corresponding detail record. The procedure called below,will
481: -- check for the existence of the detail records and if not available

Line 499: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET

495: -- The follwing Update statement updates all records in the given task
496: -- WBS hierarchy.It will update only the Project-task combination records
497: -- and the Project level record (Task id = 0 and Resourcelist member id = 0)
498:
499: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
500: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
501: CMT_RAW_COST_YTD = CMT_RAW_COST_YTD + X_Raw_Cost,
502: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
503: CMT_BURDENED_COST_YTD = CMT_BURDENED_COST_YTD + X_Burdened_Cost,

Line 559: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

555: x_err_stage,
556: x_err_code);
557:
558: Recs_processed := Recs_processed + 1;
559: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
560: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
561: CMT_RAW_COST_PTD,
562: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
563: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 604: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the

600: x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
601: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
602:
603: -- Process_it_tasks_cmt - Processes ITD amounts in the
604: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the
605: -- given Project-Task combination,records are
606: -- created/updated and rolled up to all the
607: -- higher level tasks.
608: Recs_processed Number := 0;

Line 623: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this

619: x_err_stack ||'->PA_PROCESS_ACCUM_COMMITMENTS.Process_it_tasks_cmt';
620:
621: pa_debug.debug(x_err_stack);
622:
623: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
624: -- project and task combination. It is possible that there might be a
625: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
626: -- no corresponding detail record. The procedure called below,will
627: -- check for the existence of the detail records and if not available

Line 645: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET

641: -- The follwing Update statement updates all records in the given task
642: -- WBS hierarchy.It will update only the Project-task combination records
643: -- and the Project level record (Task id = 0 and Resourcelist member id = 0)
644:
645: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
646: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
647: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
648: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
649: LAST_UPDATE_DATE = Trunc(Sysdate),

Line 703: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

699: x_err_stage,
700: x_err_code);
701:
702: Recs_processed := Recs_processed + 1;
703: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
704: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
705: CMT_RAW_COST_PTD,
706: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
707: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,