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_HEADERS

Line 93: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

89: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
90: LAST_UPDATE_DATE = Trunc(Sysdate),
91: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
92: Where PAA.Project_Accum_id In
93: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
94: Where Pah.Project_id = x_project_id and
95: pah.Resource_list_member_id = x_resource_list_Member_id and
96: Pah.Task_id in (select 0 from sys.dual union
97: Select Pt.Task_Id from PA_TASKS pt

Line 111: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

107: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
108: LAST_UPDATE_DATE = Trunc(Sysdate),
109: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
110: Where PAA.Project_Accum_id In
111: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
112: Where Pah.Project_id = x_project_id and
113: pah.Resource_list_member_id = x_resource_list_Member_id and
114: Pah.Task_id in (select 0 from sys.dual union
115: Select Pt.Task_Id from PA_TASKS pt

Line 221: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

217: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
218: LAST_UPDATE_DATE = Trunc(Sysdate),
219: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
220: Where PAA.Project_Accum_id In
221: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
222: Where Pah.Project_id = x_project_id and
223: pah.Resource_list_member_id = x_resource_list_Member_id and
224: Pah.Task_id in (select 0 from sys.dual union
225: Select Pt.Task_Id from PA_TASKS pt

Line 239: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

235: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
236: LAST_UPDATE_DATE = Trunc(Sysdate),
237: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
238: Where PAA.Project_Accum_id In
239: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
240: Where Pah.Project_id = x_project_id and
241: pah.Resource_list_member_id = x_resource_list_Member_id and
242: Pah.Task_id in (select 0 from sys.dual
243: union Select Pt.Task_Id from PA_TASKS pt

Line 335: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

331: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
332: LAST_UPDATE_DATE = Trunc(Sysdate),
333: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
334: Where PAA.Project_Accum_id In
335: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
336: Where Pah.Project_id = x_project_id and
337: pah.Resource_list_member_id = x_resource_list_Member_id and
338: Pah.Task_id in (select 0 from sys.dual union
339: Select Pt.Task_Id from PA_TASKS pt

Line 352: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

348: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
349: LAST_UPDATE_DATE = Trunc(Sysdate),
350: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
351: Where PAA.Project_Accum_id In
352: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
353: Where Pah.Project_id = x_project_id and
354: pah.Resource_list_member_id = x_resource_list_Member_id and
355: Pah.Task_id in (select 0 from sys.dual union
356: Select Pt.Task_Id from PA_TASKS pt

Line 446: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

442: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
443: LAST_UPDATE_DATE = Trunc(Sysdate),
444: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
445: Where PAA.Project_Accum_id In
446: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
447: Where Pah.Project_id = x_project_id and
448: pah.Resource_list_member_id = x_resource_list_Member_id and
449: Pah.Task_id in (select 0 from sys.dual union
450: Select Pt.Task_Id from PA_TASKS pt

Line 463: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

459: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
460: LAST_UPDATE_DATE = Trunc(Sysdate),
461: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
462: Where PAA.Project_Accum_id In
463: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
464: Where Pah.Project_id = x_project_id and
465: pah.Resource_list_member_id = x_resource_list_Member_id and
466: Pah.Task_id in (select 0 from sys.dual union
467: Select Pt.Task_Id from PA_TASKS pt

Line 547: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

543: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
544: LAST_UPDATE_DATE = Trunc(Sysdate),
545: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
546: Where PAA.Project_Accum_id In
547: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
548: Where Pah.Project_id = x_project_id and
549: pah.Resource_list_member_id = x_resource_list_Member_id and
550: Pah.Task_id in (select 0 from sys.dual union
551: Select Pt.Task_Id from PA_TASKS pt

Line 563: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

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
562: Where PAA.Project_Accum_id In
563: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
564: Where Pah.Project_id = x_project_id and
565: pah.Resource_list_member_id = x_resource_list_Member_id and
566: Pah.Task_id in (select 0 from sys.dual union
567: Select Pt.Task_Id from PA_TASKS pt

Line 594: -- PA_PROJECT_ACCUM_HEADERS table for the given

590: x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
591: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
592:
593: -- Insert_Headers_res - Inserts Header records in the
594: -- PA_PROJECT_ACCUM_HEADERS table for the given
595: -- Project-Task-Resource combination
596:
597: V_Old_Stack Varchar2(630);
598: Begin

Line 605: Insert into PA_PROJECT_ACCUM_HEADERS

601: x_err_stack :=
602: x_err_stack||'->PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res';
603: pa_debug.debug(x_err_stack);
604:
605: Insert into PA_PROJECT_ACCUM_HEADERS
606: (PROJECT_ACCUM_ID,PROJECT_ID,TASK_ID,ACCUM_PERIOD,RESOURCE_ID,
607: RESOURCE_LIST_ID,RESOURCE_LIST_ASSIGNMENT_ID,
608: RESOURCE_LIST_MEMBER_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,
609: REQUEST_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN )