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_HEADERS

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

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
45: -- would create it.
46:

Line 73: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

69: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
70: LAST_UPDATE_DATE = Trunc(Sysdate),
71: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
72: Where PAA.Project_Accum_id In
73: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
74: Where Pah.Project_id = x_project_id and
75: pah.Resource_list_member_id = 0 and
76: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
77: start with pt.task_id = x_task_id

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

103: -- 1.1.1, then the first time, Get_all_higher_tasks would return,
104: -- 1.1.1, 1.1, and 1. We create three header records and three detail records
105: -- in the Project_accum_commitments table. The next time , if the given task
106: -- is 1.1.2, the Get_all_higher_tasks would return only 1.1.2, since
107: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those
108: -- two records would have been processed by the Update statements.
109:
110: IF v_noof_tasks > 0 Then
111: For i in 1..v_noof_tasks LOOP

Line 112: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

108: -- two records would have been processed by the Update statements.
109:
110: IF v_noof_tasks > 0 Then
111: For i in 1..v_noof_tasks LOOP
112: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
113: From sys.Dual;
114: PA_MAINT_PROJECT_ACCUMS.Insert_Headers_tasks (X_project_id,
115: v_task_array(i),
116: x_current_period,

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

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
194: -- would create it.
195:

Line 222: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

218: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
219: LAST_UPDATE_DATE = Trunc(Sysdate),
220: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
221: Where PAA.Project_Accum_id In
222: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
223: Where Pah.Project_id = x_project_id and
224: pah.Resource_list_member_id = 0 and
225: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
226: start with pt.task_id = x_task_id

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

235: -- 1.1.1, then the first time, Get_all_higher_tasks would return,
236: -- 1.1.1, 1.1, and 1. We create three header records and three detail records
237: -- in the Project_accum_commitments table. The next time , if the given task
238: -- is 1.1.2, the Get_all_higher_tasks would return only 1.1.2, since
239: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those
240: -- two records would have been processed by the Update statements.
241:
242: Get_all_higher_tasks_cmt (
243: x_project_id ,

Line 253: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

249: x_err_code);
250:
251: If v_noof_tasks > 0 Then
252: For i in 1..v_noof_tasks LOOP
253: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
254: From sys.Dual;
255: PA_MAINT_PROJECT_ACCUMS.Insert_Headers_tasks (X_project_id,
256: v_task_array(i),
257: x_current_period,

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

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
336: -- would create it.
337:

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 = 0 and
365: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
366: start with pt.task_id = x_task_id

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

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

Line 402: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

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

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

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
482: -- would create it.
483:

Line 508: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

504: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
505: LAST_UPDATE_DATE = Trunc(Sysdate),
506: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
507: Where PAA.Project_Accum_id In
508: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
509: Where Pah.Project_id = x_project_id and
510: pah.Resource_list_member_id = 0 and
511: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
512: start with pt.task_id = x_task_id

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

539: -- 1.1.1, then the first time, Get_all_higher_tasks would return,
540: -- 1.1.1, 1.1, and 1. We create three header records and three detail records
541: -- in the Project_accum_commitments table. The next time , if the given task
542: -- is 1.1.2, the Get_all_higher_tasks would return only 1.1.2, since
543: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those
544: -- two records would have been processed by the Update statements.
545:
546: If v_noof_tasks > 0 Then
547: For i in 1..v_noof_tasks LOOP

Line 548: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

544: -- two records would have been processed by the Update statements.
545:
546: If v_noof_tasks > 0 Then
547: For i in 1..v_noof_tasks LOOP
548: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
549: From sys.Dual;
550: PA_MAINT_PROJECT_ACCUMS.Insert_Headers_tasks (X_project_id,
551: v_task_array(i),
552: x_current_period,

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

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
628: -- would create it.
629:

Line 652: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

648: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
649: LAST_UPDATE_DATE = Trunc(Sysdate),
650: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
651: Where PAA.Project_Accum_id In
652: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
653: Where Pah.Project_id = x_project_id and
654: pah.Resource_list_member_id = 0 and
655: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
656: start with pt.task_id = x_task_id

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

683: -- 1.1.1, then the first time, Get_all_higher_tasks would return,
684: -- 1.1.1, 1.1, and 1. We create three header records and three detail records
685: -- in the Project_accum_commitments table. The next time , if the given task
686: -- is 1.1.2, the Get_all_higher_tasks would return only 1.1.2, since
687: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those
688: -- two records would have been processed by the Update statements.
689:
690: If v_noof_tasks > 0 Then
691: For i in 1..v_noof_tasks LOOP

Line 692: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

688: -- two records would have been processed by the Update statements.
689:
690: If v_noof_tasks > 0 Then
691: For i in 1..v_noof_tasks LOOP
692: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
693: From sys.Dual;
694: PA_MAINT_PROJECT_ACCUMS.Insert_Headers_tasks (X_project_id,
695: v_task_array(i),
696: x_current_period,

Line 743: -- have a record in PA_PROJECT_ACCUM_HEADERS table, with Resource_List_member_id

739: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
740:
741:
742: -- This procedure returns all those tasks from PA_TASKS, which do not
743: -- have a record in PA_PROJECT_ACCUM_HEADERS table, with Resource_List_member_id
744: -- (Project-task level numbers without resources )
745:
746: CURSOR Tasks_Cur IS
747: SELECT task_id

Line 753: pa_project_accum_headers pah

749: WHERE project_id = x_project_id
750: AND NOT EXISTS
751: (SELECT 'x'
752: FROM
753: pa_project_accum_headers pah
754: WHERE pah.project_id = X_project_id
755: AND pah.task_id = pt.task_id
756: AND pah.resource_list_member_id = 0)
757: START WITH task_id = x_task_id