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_HEADERS

Line 33: PA_PROJECT_ACCUM_HEADERS

29:
30: CURSOR Proj_Res_level_Cur IS
31: SELECT Project_Accum_Id
32: FROM
33: PA_PROJECT_ACCUM_HEADERS
34: WHERE Project_id = X_project_id
35: AND Task_Id = 0
36: AND Resource_list_Member_id = X_resource_list_member_id;
37:

Line 56: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but

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
59: -- would create it.
60:

Line 74: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but

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
77: -- would create it.
78:

Line 119: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

115: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
116: LAST_UPDATE_DATE = Trunc(Sysdate),
117: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
118: Where PAA.Project_Accum_id In
119: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
120: Where Pah.Project_id = x_project_id and
121: pah.Resource_list_member_id = x_resource_list_Member_id and
122: Pah.Task_id in ( select 0 from sys.dual union
123: Select Pt.Task_Id from PA_TASKS pt

Line 155: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those

151: -- 1.1.1, then the first time, Get_all_higher_tasks would return,
152: -- 1.1.1, 1.1, and 1. We create three header records and three detail records
153: -- in the Project_accum_commitments table. The next time , if the given task
154: -- is 1.1.2, the Get_all_higher_tasks would return only 1.1.2, since
155: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those
156: -- two records would have been processed by the Update statements.
157:
158: If v_noof_tasks > 0 Then
159: For i in 1..v_noof_tasks LOOP

Line 160: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval

156: -- two records would have been processed by the Update statements.
157:
158: If v_noof_tasks > 0 Then
159: For i in 1..v_noof_tasks LOOP
160: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval
161: into V_Accum_id
162: From Dual;
163: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
164: (X_project_id,

Line 203: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

199:
200: Open Proj_Res_level_Cur;
201: Fetch Proj_Res_level_Cur Into V_Accum_Id;
202: If Proj_Res_level_Cur%NOTFOUND Then
203: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
204: From Dual;
205: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
206: (X_project_id,
207: 0,

Line 277: PA_PROJECT_ACCUM_HEADERS

273:
274: CURSOR Proj_Res_level_Cur IS
275: SELECT Project_Accum_Id
276: FROM
277: PA_PROJECT_ACCUM_HEADERS
278: WHERE Project_id = X_project_id
279: AND Task_Id = 0
280: AND Resource_list_Member_id = X_resource_list_member_id;
281:

Line 299: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but

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
302: -- would create it.
303:

Line 317: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but

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
320: -- would create it.
321:

Line 362: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

358: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
359: LAST_UPDATE_DATE = Trunc(Sysdate),
360: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
361: Where PAA.Project_Accum_id In
362: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
363: Where Pah.Project_id = x_project_id and
364: pah.Resource_list_member_id = x_resource_list_Member_id and
365: Pah.Task_id in (select 0 from sys.dual union
366: Select Pt.Task_Id from PA_TASKS pt

Line 398: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those

394: -- 1.1.1, then the first time, Get_all_higher_tasks would return,
395: -- 1.1.1, 1.1, and 1. We create three header records and three detail records
396: -- in the Project_accum_commitments table. The next time , if the given task
397: -- is 1.1.2, the Get_all_higher_tasks would return only 1.1.2, since
398: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those
399: -- two records would have been processed by the Update statements.
400:
401: If v_noof_tasks > 0 Then
402: For i in 1..v_noof_tasks LOOP

Line 403: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

399: -- two records would have been processed by the Update statements.
400:
401: If v_noof_tasks > 0 Then
402: For i in 1..v_noof_tasks LOOP
403: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
404: From Dual;
405: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
406: (X_project_id,
407: v_task_array(i),

Line 445: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

441:
442: Open Proj_Res_level_Cur;
443: Fetch Proj_Res_level_Cur Into V_Accum_Id;
444: If Proj_Res_level_Cur%NOTFOUND Then
445: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
446: From Dual;
447: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
448: (X_project_id,
449: 0,

Line 522: PA_PROJECT_ACCUM_HEADERS

518:
519: CURSOR Proj_Res_level_Cur IS
520: SELECT Project_Accum_Id
521: FROM
522: PA_PROJECT_ACCUM_HEADERS
523: WHERE Project_id = X_project_id
524: AND Task_Id = 0
525: AND Resource_list_Member_id = X_resource_list_member_id;
526:

Line 544: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but

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
547: -- would create it.
548:

Line 562: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but

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
565: -- would create it.
566:

Line 606: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

602: LAST_UPDATE_DATE = Trunc(Sysdate),
603: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
604: Where PAA.Project_Accum_id In
605:
606: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
607: Where Pah.Project_id = x_project_id and
608: pah.Resource_list_member_id = x_resource_list_Member_id and
609: Pah.Task_id in (select 0 from sys.dual union
610: Select Pt.Task_Id from PA_TASKS pt

Line 642: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those

638: -- 1.1.1, then the first time, Get_all_higher_tasks would return,
639: -- 1.1.1, 1.1, and 1. We create three header records and three detail records
640: -- in the Project_accum_commitments table. The next time , if the given task
641: -- is 1.1.2, the Get_all_higher_tasks would return only 1.1.2, since
642: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those
643: -- two records would have been processed by the Update statements.
644:
645: If v_noof_tasks > 0 Then
646: For i in 1..v_noof_tasks LOOP

Line 647: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

643: -- two records would have been processed by the Update statements.
644:
645: If v_noof_tasks > 0 Then
646: For i in 1..v_noof_tasks LOOP
647: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
648: From Dual;
649: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
650: (X_project_id,
651: v_task_array(i),

Line 689: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

685:
686: Open Proj_Res_level_Cur;
687: Fetch Proj_Res_level_Cur Into V_Accum_Id;
688: If Proj_Res_level_Cur%NOTFOUND Then
689: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
690: From Dual;
691: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
692: (X_project_id,
693: 0,

Line 766: PA_PROJECT_ACCUM_HEADERS

762:
763: CURSOR Proj_Res_level_Cur IS
764: SELECT Project_Accum_Id
765: FROM
766: PA_PROJECT_ACCUM_HEADERS
767: WHERE Project_id = X_project_id
768: AND Task_Id = 0
769: AND Resource_list_Member_id = X_resource_list_member_id;
770:

Line 789: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but

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
792: -- would create it.
793:

Line 807: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but

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
810: -- would create it.
811:

Line 849: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

845: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
846: LAST_UPDATE_DATE = Trunc(Sysdate),
847: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
848: Where PAA.Project_Accum_id In
849: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
850: Where Pah.Project_id = x_project_id and
851: pah.Resource_list_member_id = x_resource_list_Member_id and
852: Pah.Task_id in (select 0 from sys.dual union
853: Select Pt.Task_Id from PA_TASKS pt

Line 885: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those

881: -- 1.1.1, then the first time, Get_all_higher_tasks would return,
882: -- 1.1.1, 1.1, and 1. We create three header records and three detail records
883: -- in the Project_accum_commitments table. The next time , if the given task
884: -- is 1.1.2, the Get_all_higher_tasks would return only 1.1.2, since
885: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those
886: -- two records would have been processed by the Update statements.
887:
888: If v_noof_tasks > 0 Then
889: For i in 1..v_noof_tasks LOOP

Line 890: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

886: -- two records would have been processed by the Update statements.
887:
888: If v_noof_tasks > 0 Then
889: For i in 1..v_noof_tasks LOOP
890: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
891: From Dual;
892: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
893: (X_project_id,
894: v_task_array(i),

Line 932: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

928:
929: Open Proj_Res_level_Cur;
930: Fetch Proj_Res_level_Cur Into V_Accum_Id;
931: If Proj_Res_level_Cur%NOTFOUND Then
932: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
933: From Dual;
934: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
935: (X_project_id,
936: 0,

Line 1007: PA_PROJECT_ACCUM_HEADERS

1003:
1004: CURSOR Proj_Res_level_Cur IS
1005: SELECT Project_Accum_Id
1006: FROM
1007: PA_PROJECT_ACCUM_HEADERS
1008: WHERE Project_id = X_project_id
1009: AND Task_Id = 0
1010: AND Resource_list_Member_id = X_resource_list_member_id;
1011:

Line 1030: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but

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
1033: -- would create it.
1034:

Line 1048: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but

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
1051: -- would create it.
1052:

Line 1086: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

1082: CMT_QUANTITY_ITD = CMT_QUANTITY_ITD + V_Qty,
1083: LAST_UPDATE_DATE = Trunc(Sysdate),
1084: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
1085: Where PAA.Project_Accum_id In
1086: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
1087: Where Pah.Project_id = x_project_id and
1088: pah.Resource_list_member_id = x_resource_list_Member_id and
1089: Pah.Task_id in (select 0 from sys.dual union
1090: Select Pt.Task_Id from PA_TASKS pt

Line 1122: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those

1118: -- 1.1.1, then the first time, Get_all_higher_tasks would return,
1119: -- 1.1.1, 1.1, and 1. We create three header records and three detail records
1120: -- in the Project_accum_commitments table. The next time , if the given task
1121: -- is 1.1.2, the Get_all_higher_tasks would return only 1.1.2, since
1122: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those
1123: -- two records would have been processed by the Update statements.
1124:
1125: If v_noof_tasks > 0 Then
1126: For i in 1..v_noof_tasks LOOP

Line 1127: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

1123: -- two records would have been processed by the Update statements.
1124:
1125: If v_noof_tasks > 0 Then
1126: For i in 1..v_noof_tasks LOOP
1127: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
1128: From Dual;
1129: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
1130: (X_project_id,
1131: v_task_array(i),

Line 1168: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

1164:
1165: Open Proj_Res_level_Cur;
1166: Fetch Proj_Res_level_Cur Into V_Accum_Id;
1167: If Proj_Res_level_Cur%NOTFOUND Then
1168: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
1169: From Dual;
1170: PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
1171: (X_project_id,
1172: 0,

Line 1223: -- task) which are not in PA_PROJECT_ACCUM_HEADERS

1219: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
1220:
1221: -- Get_all_higher_tasks_cmt_res - For the given Task Id returns all the
1222: -- higher level tasks in the WBS (including the given
1223: -- task) which are not in PA_PROJECT_ACCUM_HEADERS
1224: -- (Tasks with the given Resource )
1225:
1226: CURSOR Tasks_Cur IS
1227: SELECT task_id

Line 1233: pa_project_accum_headers pah

1229: WHERE project_id = x_project_id
1230: AND NOT EXISTS
1231: (SELECT 'x'
1232: FROM
1233: pa_project_accum_headers pah
1234: WHERE pah.project_id = x_project_id
1235: AND pah.task_id = pt.task_id
1236: AND pah.resource_list_member_id = x_resource_list_member_id)
1237: START WITH task_id = x_task_id