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 dependencies on PA_PROJ_ACCUM_MAIN

Line 75: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

71: BILLABLE_LABOR_HOURS_YTD = BILLABLE_LABOR_HOURS_YTD +
72: X_Billable_Labor_Hours,
73: BILLABLE_LABOR_HOURS_PTD = BILLABLE_LABOR_HOURS_PTD +
74: X_Billable_Labor_Hours,
75: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
76: LAST_UPDATE_DATE = Trunc(Sysdate),
77: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
78: Where PAA.Project_Accum_id In
79: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

Line 77: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

73: BILLABLE_LABOR_HOURS_PTD = BILLABLE_LABOR_HOURS_PTD +
74: X_Billable_Labor_Hours,
75: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
76: LAST_UPDATE_DATE = Trunc(Sysdate),
77: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
78: Where PAA.Project_Accum_id In
79: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
80: Where Pah.Project_id = x_project_id and
81: pah.Resource_list_member_id = 0 and

Line 96: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

92: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
93: REVENUE_ITD = REVENUE_ITD + X_Revenue,
94: REVENUE_YTD = REVENUE_YTD + X_Revenue,
95: REVENUE_PTD = REVENUE_PTD + X_Revenue,
96: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
97: LAST_UPDATE_DATE = Trunc(Sysdate),
98: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
99: Where PAA.Project_Accum_id In
100: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

Line 98: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

94: REVENUE_YTD = REVENUE_YTD + X_Revenue,
95: REVENUE_PTD = REVENUE_PTD + X_Revenue,
96: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
97: LAST_UPDATE_DATE = Trunc(Sysdate),
98: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
99: Where PAA.Project_Accum_id In
100: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
101: Where Pah.Project_id = x_project_id and
102: pah.Resource_list_member_id = 0 and

Line 188: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

184: BILLABLE_LABOR_HOURS_YTD = BILLABLE_LABOR_HOURS_YTD +
185: X_Billable_Labor_Hours,
186: BILLABLE_LABOR_HOURS_PP = BILLABLE_LABOR_HOURS_PP +
187: X_Billable_Labor_Hours,
188: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
189: LAST_UPDATE_DATE = Trunc(Sysdate),
190: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
191: Where PAA.Project_Accum_id In
192: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

Line 190: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

186: BILLABLE_LABOR_HOURS_PP = BILLABLE_LABOR_HOURS_PP +
187: X_Billable_Labor_Hours,
188: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
189: LAST_UPDATE_DATE = Trunc(Sysdate),
190: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
191: Where PAA.Project_Accum_id In
192: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
193: Where Pah.Project_id = x_project_id and
194: pah.Resource_list_member_id = 0 and

Line 208: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

204: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
205: REVENUE_ITD = REVENUE_ITD + X_Revenue,
206: REVENUE_YTD = REVENUE_YTD + X_Revenue,
207: REVENUE_PP = REVENUE_PP + X_Revenue,
208: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
209: LAST_UPDATE_DATE = Trunc(Sysdate),
210: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
211: Where PAA.Project_Accum_id In
212: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

Line 210: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

206: REVENUE_YTD = REVENUE_YTD + X_Revenue,
207: REVENUE_PP = REVENUE_PP + X_Revenue,
208: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
209: LAST_UPDATE_DATE = Trunc(Sysdate),
210: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
211: Where PAA.Project_Accum_id In
212: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
213: Where Pah.Project_id = x_project_id and
214: pah.Resource_list_member_id = 0 and

Line 292: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

288: BILLABLE_LABOR_HOURS_ITD = BILLABLE_LABOR_HOURS_ITD +
289: X_Billable_Labor_Hours,
290: BILLABLE_LABOR_HOURS_PP = BILLABLE_LABOR_HOURS_PP +
291: X_Billable_Labor_Hours,
292: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
293: LAST_UPDATE_DATE = Trunc(Sysdate),
294: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
295: Where PAA.Project_Accum_id In
296: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

Line 294: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

290: BILLABLE_LABOR_HOURS_PP = BILLABLE_LABOR_HOURS_PP +
291: X_Billable_Labor_Hours,
292: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
293: LAST_UPDATE_DATE = Trunc(Sysdate),
294: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
295: Where PAA.Project_Accum_id In
296: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
297: Where Pah.Project_id = x_project_id and
298: pah.Resource_list_member_id = 0 and

Line 311: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

307:
308: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
309: REVENUE_ITD = REVENUE_ITD + X_Revenue,
310: REVENUE_PP = REVENUE_PP + X_Revenue,
311: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
312: LAST_UPDATE_DATE = Trunc(Sysdate),
313: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
314: Where PAA.Project_Accum_id In
315: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

Line 313: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

309: REVENUE_ITD = REVENUE_ITD + X_Revenue,
310: REVENUE_PP = REVENUE_PP + X_Revenue,
311: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
312: LAST_UPDATE_DATE = Trunc(Sysdate),
313: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
314: Where PAA.Project_Accum_id In
315: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
316: Where Pah.Project_id = x_project_id and
317: pah.Resource_list_member_id = 0 and

Line 395: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

391: BILLABLE_LABOR_HOURS_ITD = BILLABLE_LABOR_HOURS_ITD +
392: X_Billable_Labor_Hours,
393: BILLABLE_LABOR_HOURS_YTD = BILLABLE_LABOR_HOURS_YTD +
394: X_Billable_Labor_Hours,
395: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
396: LAST_UPDATE_DATE = Trunc(Sysdate),
397: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
398: Where PAA.Project_Accum_id In
399: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

Line 397: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

393: BILLABLE_LABOR_HOURS_YTD = BILLABLE_LABOR_HOURS_YTD +
394: X_Billable_Labor_Hours,
395: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
396: LAST_UPDATE_DATE = Trunc(Sysdate),
397: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
398: Where PAA.Project_Accum_id In
399: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
400: Where Pah.Project_id = x_project_id and
401: pah.Resource_list_member_id = 0 and

Line 413: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

409: IF(x_revenue_flag = 'Y') THEN
410: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
411: REVENUE_ITD = REVENUE_ITD + X_Revenue,
412: REVENUE_YTD = REVENUE_YTD + X_Revenue,
413: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
414: LAST_UPDATE_DATE = Trunc(Sysdate),
415: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
416: Where PAA.Project_Accum_id In
417: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

Line 415: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

411: REVENUE_ITD = REVENUE_ITD + X_Revenue,
412: REVENUE_YTD = REVENUE_YTD + X_Revenue,
413: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
414: LAST_UPDATE_DATE = Trunc(Sysdate),
415: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
416: Where PAA.Project_Accum_id In
417: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
418: Where Pah.Project_id = x_project_id and
419: pah.Resource_list_member_id = 0 and

Line 489: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

485: X_Billable_Burdened_Cost,
486: LABOR_HOURS_ITD = LABOR_HOURS_ITD + X_Labor_Hours,
487: BILLABLE_LABOR_HOURS_ITD = BILLABLE_LABOR_HOURS_ITD +
488: X_Billable_Labor_Hours,
489: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
490: LAST_UPDATE_DATE = Trunc(Sysdate),
491: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
492: Where PAA.Project_Accum_id In
493: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

Line 491: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

487: BILLABLE_LABOR_HOURS_ITD = BILLABLE_LABOR_HOURS_ITD +
488: X_Billable_Labor_Hours,
489: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
490: LAST_UPDATE_DATE = Trunc(Sysdate),
491: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
492: Where PAA.Project_Accum_id In
493: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
494: Where Pah.Project_id = x_project_id and
495: pah.Resource_list_member_id = 0 and

Line 507: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

503: IF(x_revenue_flag = 'Y') THEN
504:
505: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
506: REVENUE_ITD = REVENUE_ITD + X_Revenue,
507: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
508: LAST_UPDATE_DATE = Trunc(Sysdate),
509: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
510: Where PAA.Project_Accum_id In
511: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

Line 509: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

505: Update PA_PROJECT_ACCUM_ACTUALS PAA SET
506: REVENUE_ITD = REVENUE_ITD + X_Revenue,
507: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
508: LAST_UPDATE_DATE = Trunc(Sysdate),
509: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
510: Where PAA.Project_Accum_id In
511: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
512: Where Pah.Project_id = x_project_id and
513: pah.Resource_list_member_id = 0 and