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

Line 24: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the

20: x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
21: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
22:
23: -- Process_it_yt_pt_cmt_res - Processes ITD,YTD and PTD amounts in the
24: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the
25: -- given Project-Task-Resource combination,records are
26: -- created/updated and rolled up to all the
27: -- higher level tasks. The Project-Resource records
28: -- are also created/updated.

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

50: x_err_stack ||'->PA_PROCESS_ACCUM_CMT_RES.Process_it_yt_pt_cmt_res';
51:
52: pa_debug.debug(x_err_stack);
53:
54: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
55: -- project,task and resource combination.It is possible that there might be a
56: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
57: -- no corresponding detail record. The procedure called below,will
58: -- check for the existence of the detail records and if not available

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

68: x_err_code);
69:
70: Recs_processed := Recs_processed + Res_recs_processed;
71:
72: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
73: -- project and Resource combination. It is possible that there might be a
74: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
75: -- no corresponding detail record. The procedure called below,will
76: -- check for the existence of the detail records and if not available

Line 105: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET

101: -- WBS hierarchy.It will update only the Project-task-resource combination
102: -- records and the Project-Resource level record(Task id = 0 and
103: -- Resourcelist member id <> 0)
104:
105: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
106: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
107: CMT_RAW_COST_YTD = CMT_RAW_COST_YTD + X_Raw_Cost,
108: CMT_RAW_COST_PTD = CMT_RAW_COST_PTD + X_Raw_Cost,
109: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,

Line 177: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

173: x_err_stage,
174: x_err_code);
175:
176: Recs_processed := Recs_processed + 1;
177: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
178: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
179: CMT_RAW_COST_PTD,
180: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
181: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 219: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

215: x_err_stage,
216: x_err_code);
217:
218: Recs_processed := Recs_processed + 1;
219: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
220: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
221: CMT_RAW_COST_PTD,
222: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
223: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 268: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the

264: x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
265: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
266:
267: -- Process_it_yt_pp_cmt_res - Processes ITD,YTD and PP amounts in the
268: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the
269: -- given Project-Task-Resource combination,records are
270: -- created/updated and rolled up to all the
271: -- higher level tasks. The Project-Resource records
272: -- are also created/updated.

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

293: x_err_stack ||'->PA_PROCESS_ACCUM_CMT_RES.Process_it_yt_pp_cmt_res';
294:
295: pa_debug.debug(x_err_stack);
296:
297: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
298: -- project,task and resource combination.It is possible that there might be a
299: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
300: -- no corresponding detail record. The procedure called below,will
301: -- check for the existence of the detail records and if not available

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

311: x_err_code);
312:
313: Recs_processed := Recs_processed + Res_recs_processed;
314:
315: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
316: -- project and Resource combination. It is possible that there might be a
317: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
318: -- no corresponding detail record. The procedure called below,will
319: -- check for the existence of the detail records and if not available

Line 348: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET

344: -- WBS hierarchy.It will update only the Project-task-resource combination
345: -- records and the Project-Resource level record(Task id = 0 and
346: -- Resourcelist member id <> 0)
347:
348: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
349: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
350: CMT_RAW_COST_YTD = CMT_RAW_COST_YTD + X_Raw_Cost,
351: CMT_RAW_COST_PP = CMT_RAW_COST_PP + X_Raw_Cost,
352: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,

Line 419: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

415: x_err_stage,
416: x_err_code);
417:
418: Recs_processed := Recs_processed + 1;
419: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
420: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
421: CMT_RAW_COST_PTD,
422: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
423: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 462: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

458: x_err_code);
459:
460: Recs_processed := Recs_processed + 1;
461:
462: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
463: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
464: CMT_RAW_COST_PTD,
465: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
466: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 513: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the

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

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

538: x_err_stack ||'->PA_PROCESS_ACCUM_CMT_RES.Process_it_pp_cmt_res';
539:
540: pa_debug.debug(x_err_stack);
541:
542: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
543: -- project,task and resource combination.It is possible that there might be a
544: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
545: -- no corresponding detail record. The procedure called below,will
546: -- check for the existence of the detail records and if not available

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

556: x_err_code);
557:
558: Recs_processed := Recs_processed + Res_recs_processed;
559:
560: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
561: -- project and Resource combination. It is possible that there might be a
562: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
563: -- no corresponding detail record. The procedure called below,will
564: -- check for the existence of the detail records and if not available

Line 594: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET

590: -- WBS hierarchy.It will update only the Project-task-resource combination
591: -- records and the Project-Resource level record(Task id = 0 and
592: -- Resourcelist member id <> 0)
593:
594: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
595: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
596: CMT_RAW_COST_PP = CMT_RAW_COST_PP + X_Raw_Cost,
597: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
598: CMT_BURDENED_COST_PP = CMT_BURDENED_COST_PP + X_Burdened_Cost,

Line 663: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

659: x_err_stage,
660: x_err_code);
661:
662: Recs_processed := Recs_processed + 1;
663: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
664: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
665: CMT_RAW_COST_PTD,
666: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
667: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 705: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

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

Line 757: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the

753: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
754:
755:
756: -- Process_it_yt_cmt_res - Processes ITD and YTD amounts in the
757: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the
758: -- given Project-Task-Resource combination,records are
759: -- created/updated and rolled up to all the
760: -- higher level tasks. The Project-Resource records
761: -- are also created/updated.

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

783: x_err_stack ||'->PA_PROCESS_ACCUM_CMT_RES.Process_it_yt_cmt_res';
784:
785: pa_debug.debug(x_err_stack);
786:
787: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
788: -- project,task and resource combination.It is possible that there might be a
789: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
790: -- no corresponding detail record. The procedure called below,will
791: -- check for the existence of the detail records and if not available

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

801: x_err_code);
802:
803: Recs_processed := Recs_processed + Res_recs_processed;
804:
805: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
806: -- project and Resource combination. It is possible that there might be a
807: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
808: -- no corresponding detail record. The procedure called below,will
809: -- check for the existence of the detail records and if not available

Line 838: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET

834: -- WBS hierarchy.It will update only the Project-task-resource combination
835: -- records and the Project-Resource level record(Task id = 0 and
836: -- Resourcelist member id <> 0)
837:
838: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
839: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
840: CMT_RAW_COST_YTD = CMT_RAW_COST_YTD + X_Raw_Cost,
841: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
842: CMT_BURDENED_COST_YTD = CMT_BURDENED_COST_YTD + X_Burdened_Cost,

Line 906: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

902: x_err_stage,
903: x_err_code);
904:
905: Recs_processed := Recs_processed + 1;
906: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
907: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
908: CMT_RAW_COST_PTD,
909: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
910: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 948: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

944: x_err_stage,
945: x_err_code);
946:
947: Recs_processed := Recs_processed + 1;
948: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
949: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
950: CMT_RAW_COST_PTD,
951: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
952: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 998: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the

994: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
995:
996:
997: -- Process_it_cmt_res - Processes ITD amounts in the
998: -- PA_PROJECT_ACCUM_COMMITMENTS table. For the
999: -- given Project-Task-Resource combination,records are
1000: -- created/updated and rolled up to all the
1001: -- higher level tasks. The Project-Resource records
1002: -- are also created/updated.

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

1024: x_err_stack ||'->PA_PROCESS_ACCUM_CMT_RES.Process_it_cmt_res';
1025:
1026: pa_debug.debug(x_err_stack);
1027:
1028: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
1029: -- project,task and resource combination.It is possible that there might be a
1030: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
1031: -- no corresponding detail record. The procedure called below,will
1032: -- check for the existence of the detail records and if not available

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

1042: x_err_code);
1043:
1044: Recs_processed := Recs_processed + Res_recs_processed;
1045:
1046: -- This checks for Commitments record in PA_PROJECT_ACCUM_COMMITMENTS for this
1047: -- project and Resource combination. It is possible that there might be a
1048: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
1049: -- no corresponding detail record. The procedure called below,will
1050: -- check for the existence of the detail records and if not available

Line 1079: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET

1075: -- WBS hierarchy.It will update only the Project-task-resource combination
1076: -- records and the Project-Resource level record(Task id = 0 and
1077: -- Resourcelist member id <> 0)
1078:
1079: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
1080: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
1081: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
1082: CMT_QUANTITY_ITD = CMT_QUANTITY_ITD + V_Qty,
1083: LAST_UPDATE_DATE = Trunc(Sysdate),

Line 1143: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

1139: x_err_stage,
1140: x_err_code);
1141:
1142: Recs_processed := Recs_processed + 1;
1143: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
1144: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
1145: CMT_RAW_COST_PTD,
1146: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
1147: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 1184: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

1180: x_err_stage,
1181: x_err_code);
1182:
1183: Recs_processed := Recs_processed + 1;
1184: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
1185: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
1186: CMT_RAW_COST_PTD,
1187: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
1188: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,