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_PROJ_ACCUM_MAIN

Line 69: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

65: CMT_RAW_COST_PTD = CMT_RAW_COST_PTD + X_Raw_Cost,
66: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
67: CMT_BURDENED_COST_YTD = CMT_BURDENED_COST_YTD + X_Burdened_Cost,
68: CMT_BURDENED_COST_PTD = CMT_BURDENED_COST_PTD + X_Burdened_Cost,
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

Line 71: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

67: CMT_BURDENED_COST_YTD = CMT_BURDENED_COST_YTD + X_Burdened_Cost,
68: CMT_BURDENED_COST_PTD = CMT_BURDENED_COST_PTD + X_Burdened_Cost,
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

Line 136: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

132: LAST_UPDATE_LOGIN) Values
133: (V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,X_Raw_Cost,
134: X_Burdened_Cost,X_Burdened_Cost,0,X_Burdened_Cost,
135: 0,0,0,0,
136: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
137: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
138: Recs_processed := Recs_processed + 1;
139: END LOOP;
140:

Line 137: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

133: (V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,X_Raw_Cost,
134: X_Burdened_Cost,X_Burdened_Cost,0,X_Burdened_Cost,
135: 0,0,0,0,
136: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
137: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
138: Recs_processed := Recs_processed + 1;
139: END LOOP;
140:
141: END IF;

Line 218: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

214: CMT_RAW_COST_PP = CMT_RAW_COST_PP + X_Raw_Cost,
215: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
216: CMT_BURDENED_COST_YTD = CMT_BURDENED_COST_YTD + X_Burdened_Cost,
217: CMT_BURDENED_COST_PP = CMT_BURDENED_COST_PP + X_Burdened_Cost,
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

Line 220: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

216: CMT_BURDENED_COST_YTD = CMT_BURDENED_COST_YTD + X_Burdened_Cost,
217: CMT_BURDENED_COST_PP = CMT_BURDENED_COST_PP + X_Burdened_Cost,
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

Line 279: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

275: X_Burdened_Cost,X_Burdened_Cost,
276: X_Burdened_Cost,0,
277: 0,0,
278: 0,0,
279: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
280: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
281: Recs_processed := Recs_processed + 1;
282: END LOOP;
283:

Line 280: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

276: X_Burdened_Cost,0,
277: 0,0,
278: 0,0,
279: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
280: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
281: Recs_processed := Recs_processed + 1;
282: END LOOP;
283:
284: End If;

Line 358: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

354: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
355: CMT_RAW_COST_PP = CMT_RAW_COST_PP + X_Raw_Cost,
356: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
357: CMT_BURDENED_COST_PP = CMT_BURDENED_COST_PP + X_Burdened_Cost,
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

Line 360: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

356: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
357: CMT_BURDENED_COST_PP = CMT_BURDENED_COST_PP + X_Burdened_Cost,
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

Line 426: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

422: LAST_UPDATE_LOGIN) Values
423: (V_Accum_id,X_Raw_Cost,0,X_Raw_Cost,0,
424: X_Burdened_Cost,0,X_Burdened_Cost,0,
425: 0,0,0,0,
426: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
427: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
428: Recs_processed := Recs_processed + 1;
429: END LOOP;
430: End If;

Line 427: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

423: (V_Accum_id,X_Raw_Cost,0,X_Raw_Cost,0,
424: X_Burdened_Cost,0,X_Burdened_Cost,0,
425: 0,0,0,0,
426: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
427: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
428: Recs_processed := Recs_processed + 1;
429: END LOOP;
430: End If;
431: -- Restore the old x_err_stack;

Line 504: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

500: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
501: CMT_RAW_COST_YTD = CMT_RAW_COST_YTD + X_Raw_Cost,
502: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
503: CMT_BURDENED_COST_YTD = CMT_BURDENED_COST_YTD + X_Burdened_Cost,
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

Line 506: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

502: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
503: CMT_BURDENED_COST_YTD = CMT_BURDENED_COST_YTD + X_Burdened_Cost,
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

Line 572: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

568: LAST_UPDATE_LOGIN) Values
569: (V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,0,
570: X_Burdened_Cost,X_Burdened_Cost,0,0,
571: 0,0,0,0,
572: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
573: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
574: Recs_processed := Recs_processed + 1;
575: END LOOP;
576:

Line 573: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

569: (V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,0,
570: X_Burdened_Cost,X_Burdened_Cost,0,0,
571: 0,0,0,0,
572: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
573: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
574: Recs_processed := Recs_processed + 1;
575: END LOOP;
576:
577: End If;

Line 648: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

644:
645: Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
646: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
647: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
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

Line 650: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

646: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
647: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
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

Line 716: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

712: LAST_UPDATE_LOGIN) Values
713: (V_Accum_id,X_Raw_Cost,0,0,0,
714: X_Burdened_Cost,0,0,0,
715: 0,0,0,0,
716: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
717: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
718: Recs_processed := Recs_processed + 1;
719: END LOOP;
720:

Line 717: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

713: (V_Accum_id,X_Raw_Cost,0,0,0,
714: X_Burdened_Cost,0,0,0,
715: 0,0,0,0,
716: X_Unit_Of_Measure,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
717: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
718: Recs_processed := Recs_processed + 1;
719: END LOOP;
720:
721: End If;