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_PROJ_ACCUM_MAIN

Line 89: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

85: QUANTITY_PTD = QUANTITY_PTD + X_Quantity,
86: BILLABLE_QUANTITY_ITD = BILLABLE_QUANTITY_ITD + X_Billable_Quantity,
87: BILLABLE_QUANTITY_YTD = BILLABLE_QUANTITY_YTD + X_Billable_Quantity,
88: BILLABLE_QUANTITY_PTD = BILLABLE_QUANTITY_PTD + X_Billable_Quantity,
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

Line 91: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

87: BILLABLE_QUANTITY_YTD = BILLABLE_QUANTITY_YTD + X_Billable_Quantity,
88: BILLABLE_QUANTITY_PTD = BILLABLE_QUANTITY_PTD + X_Billable_Quantity,
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

Line 107: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

103: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
104: REVENUE_ITD = REVENUE_ITD + X_Revenue,
105: REVENUE_YTD = REVENUE_YTD + X_Revenue,
106: REVENUE_PTD = REVENUE_PTD + X_Revenue,
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

Line 109: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

105: REVENUE_YTD = REVENUE_YTD + X_Revenue,
106: REVENUE_PTD = REVENUE_PTD + X_Revenue,
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

Line 217: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

213: BILLABLE_QUANTITY_YTD = BILLABLE_QUANTITY_YTD +
214: X_Billable_Quantity,
215: BILLABLE_QUANTITY_PP = BILLABLE_QUANTITY_PP +
216: X_Billable_Quantity,
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

Line 219: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

215: BILLABLE_QUANTITY_PP = BILLABLE_QUANTITY_PP +
216: X_Billable_Quantity,
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

Line 235: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

231: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
232: REVENUE_ITD = REVENUE_ITD + X_Revenue,
233: REVENUE_YTD = REVENUE_YTD + X_Revenue,
234: REVENUE_PP = REVENUE_PP + X_Revenue,
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

Line 237: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

233: REVENUE_YTD = REVENUE_YTD + X_Revenue,
234: REVENUE_PP = REVENUE_PP + X_Revenue,
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

Line 331: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

327: QUANTITY_ITD = QUANTITY_ITD + X_Quantity,
328: QUANTITY_PP = QUANTITY_PP + X_Quantity,
329: BILLABLE_QUANTITY_ITD = BILLABLE_QUANTITY_ITD + X_Billable_Quantity,
330: BILLABLE_QUANTITY_PP = BILLABLE_QUANTITY_PP + X_Billable_Quantity,
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

Line 333: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

329: BILLABLE_QUANTITY_ITD = BILLABLE_QUANTITY_ITD + X_Billable_Quantity,
330: BILLABLE_QUANTITY_PP = BILLABLE_QUANTITY_PP + X_Billable_Quantity,
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

Line 348: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

344: IF(x_revenue_flag = 'Y') THEN
345: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
346: REVENUE_ITD = REVENUE_ITD + X_Revenue,
347: REVENUE_PP = REVENUE_PP + X_Revenue,
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

Line 350: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

346: REVENUE_ITD = REVENUE_ITD + X_Revenue,
347: REVENUE_PP = REVENUE_PP + X_Revenue,
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

Line 442: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

438: QUANTITY_ITD = QUANTITY_ITD + X_Quantity,
439: QUANTITY_YTD = QUANTITY_YTD + X_Quantity,
440: BILLABLE_QUANTITY_ITD = BILLABLE_QUANTITY_ITD + X_Billable_Quantity,
441: BILLABLE_QUANTITY_YTD = BILLABLE_QUANTITY_YTD + X_Billable_Quantity,
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

Line 444: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

440: BILLABLE_QUANTITY_ITD = BILLABLE_QUANTITY_ITD + X_Billable_Quantity,
441: BILLABLE_QUANTITY_YTD = BILLABLE_QUANTITY_YTD + X_Billable_Quantity,
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

Line 459: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

455: IF(x_revenue_flag = 'Y') THEN
456: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
457: REVENUE_ITD = REVENUE_ITD + X_Revenue,
458: REVENUE_YTD = REVENUE_YTD + X_Revenue,
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

Line 461: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

457: REVENUE_ITD = REVENUE_ITD + X_Revenue,
458: REVENUE_YTD = REVENUE_YTD + X_Revenue,
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

Line 543: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

539: BILLABLE_LABOR_HOURS_ITD = BILLABLE_LABOR_HOURS_ITD +
540: X_Billable_Labor_Hours,
541: QUANTITY_ITD = QUANTITY_ITD + X_Quantity,
542: BILLABLE_QUANTITY_ITD = BILLABLE_QUANTITY_ITD + X_Billable_Quantity,
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

Line 545: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

541: QUANTITY_ITD = QUANTITY_ITD + X_Quantity,
542: BILLABLE_QUANTITY_ITD = BILLABLE_QUANTITY_ITD + X_Billable_Quantity,
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

Line 559: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

555: END IF;
556: IF(x_revenue_flag = 'Y') THEN
557: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
558: REVENUE_ITD = REVENUE_ITD + X_Revenue,
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

Line 561: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

557: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
558: REVENUE_ITD = REVENUE_ITD + X_Revenue,
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

Line 614: pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),pa_proj_accum_main.x_request_id,trunc(sysdate),

610: Values (x_Accum_id,X_project_id,x_task_id,
611: x_current_period,
612: x_resource_id,x_resource_list_id,
613: x_resource_list_assignment_id,x_resource_list_Member_id,
614: pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),pa_proj_accum_main.x_request_id,trunc(sysdate),
615: pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login );
616:
617: -- Restore the old x_err_stack;
618: x_err_stack := V_Old_Stack;

Line 615: pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login );

611: x_current_period,
612: x_resource_id,x_resource_list_id,
613: x_resource_list_assignment_id,x_resource_list_Member_id,
614: pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),pa_proj_accum_main.x_request_id,trunc(sysdate),
615: pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login );
616:
617: -- Restore the old x_err_stack;
618: x_err_stack := V_Old_Stack;
619: Exception when dup_val_on_index then