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

Line 115: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

111: CMT_BURDENED_COST_PTD = CMT_BURDENED_COST_PTD + X_Burdened_Cost,
112: CMT_QUANTITY_ITD = CMT_QUANTITY_ITD + V_Qty,
113: CMT_QUANTITY_YTD = CMT_QUANTITY_YTD + V_Qty,
114: CMT_QUANTITY_PTD = CMT_QUANTITY_PTD + V_Qty,
115: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
116: LAST_UPDATE_DATE = Trunc(Sysdate),
117: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
118: Where PAA.Project_Accum_id In
119: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

Line 117: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

113: CMT_QUANTITY_YTD = CMT_QUANTITY_YTD + V_Qty,
114: CMT_QUANTITY_PTD = CMT_QUANTITY_PTD + V_Qty,
115: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
116: LAST_UPDATE_DATE = Trunc(Sysdate),
117: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
118: Where PAA.Project_Accum_id In
119: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
120: Where Pah.Project_id = x_project_id and
121: pah.Resource_list_member_id = x_resource_list_Member_id and

Line 191: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

187: (V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,X_Raw_Cost,
188: X_Burdened_Cost,X_Burdened_Cost,
189: 0,X_Burdened_Cost,
190: V_Qty,V_Qty,0,V_Qty,
191: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
192: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
193: Recs_processed := Recs_processed + 1;
194: END LOOP;
195: End If;

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

188: X_Burdened_Cost,X_Burdened_Cost,
189: 0,X_Burdened_Cost,
190: V_Qty,V_Qty,0,V_Qty,
191: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
192: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
193: Recs_processed := Recs_processed + 1;
194: END LOOP;
195: End If;
196:

Line 233: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

229: (V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,X_Raw_Cost,
230: X_Burdened_Cost,X_Burdened_Cost,
231: 0,X_Burdened_Cost,
232: V_Qty,V_Qty,0,V_Qty,
233: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
234: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
235: Recs_processed := Recs_processed + 1;
236: End If;
237: Close Proj_Res_level_Cur;

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

230: X_Burdened_Cost,X_Burdened_Cost,
231: 0,X_Burdened_Cost,
232: V_Qty,V_Qty,0,V_Qty,
233: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
234: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
235: Recs_processed := Recs_processed + 1;
236: End If;
237: Close Proj_Res_level_Cur;
238: x_recs_processed := Recs_processed;

Line 358: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

354: CMT_BURDENED_COST_PP = CMT_BURDENED_COST_PP + X_Burdened_Cost,
355: CMT_QUANTITY_ITD = CMT_QUANTITY_ITD + V_Qty,
356: CMT_QUANTITY_YTD = CMT_QUANTITY_YTD + V_Qty,
357: CMT_QUANTITY_PP = CMT_QUANTITY_PP + V_Qty,
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_QUANTITY_YTD = CMT_QUANTITY_YTD + V_Qty,
357: CMT_QUANTITY_PP = CMT_QUANTITY_PP + V_Qty,
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 = x_resource_list_Member_id and

Line 433: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

429: (V_Accum_id,X_Raw_Cost,X_Raw_Cost,X_Raw_Cost,0,
430: X_Burdened_Cost,X_Burdened_Cost,
431: X_Burdened_Cost,0,
432: V_Qty,V_Qty,V_Qty,0,
433: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
434: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
435: Recs_processed := Recs_processed + 1;
436: END LOOP;
437: End If;

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

430: X_Burdened_Cost,X_Burdened_Cost,
431: X_Burdened_Cost,0,
432: V_Qty,V_Qty,V_Qty,0,
433: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
434: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
435: Recs_processed := Recs_processed + 1;
436: END LOOP;
437: End If;
438:

Line 476: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

472: (V_Accum_id,X_Raw_Cost,X_Raw_Cost,X_Raw_Cost,0,
473: X_Burdened_Cost,X_Burdened_Cost,
474: X_Burdened_Cost,0,
475: V_Qty,V_Qty,V_Qty,0,
476: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
477: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
478: Recs_processed := Recs_processed + 1;
479: End If;
480: Close Proj_Res_level_Cur;

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

473: X_Burdened_Cost,X_Burdened_Cost,
474: X_Burdened_Cost,0,
475: V_Qty,V_Qty,V_Qty,0,
476: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
477: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
478: Recs_processed := Recs_processed + 1;
479: End If;
480: Close Proj_Res_level_Cur;
481: x_recs_processed := Recs_processed;

Line 601: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

597: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
598: CMT_BURDENED_COST_PP = CMT_BURDENED_COST_PP + X_Burdened_Cost,
599: CMT_QUANTITY_ITD = CMT_QUANTITY_ITD + V_Qty,
600: CMT_QUANTITY_PP = CMT_QUANTITY_PP + V_Qty,
601: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
602: LAST_UPDATE_DATE = Trunc(Sysdate),
603: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
604: Where PAA.Project_Accum_id In
605:

Line 603: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

599: CMT_QUANTITY_ITD = CMT_QUANTITY_ITD + V_Qty,
600: CMT_QUANTITY_PP = CMT_QUANTITY_PP + V_Qty,
601: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
602: LAST_UPDATE_DATE = Trunc(Sysdate),
603: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
604: Where PAA.Project_Accum_id In
605:
606: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
607: Where Pah.Project_id = x_project_id and

Line 677: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

673: (V_Accum_id,X_Raw_Cost,0,X_Raw_Cost,0,
674: X_Burdened_Cost,0,
675: X_Burdened_Cost,0,
676: V_Qty,0,V_Qty,0,
677: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
678: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
679: Recs_processed := Recs_processed + 1;
680: END LOOP;
681: End If;

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

674: X_Burdened_Cost,0,
675: X_Burdened_Cost,0,
676: V_Qty,0,V_Qty,0,
677: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
678: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
679: Recs_processed := Recs_processed + 1;
680: END LOOP;
681: End If;
682:

Line 719: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

715: (V_Accum_id,X_Raw_Cost,0,X_Raw_Cost,0,
716: X_Burdened_Cost,0,
717: X_Burdened_Cost,0,
718: V_Qty,0,V_Qty,0,
719: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
720: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
721: Recs_processed := Recs_processed + 1;
722: End If;
723:

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

716: X_Burdened_Cost,0,
717: X_Burdened_Cost,0,
718: V_Qty,0,V_Qty,0,
719: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
720: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
721: Recs_processed := Recs_processed + 1;
722: End If;
723:
724: Close Proj_Res_level_Cur;

Line 845: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

841: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
842: CMT_BURDENED_COST_YTD = CMT_BURDENED_COST_YTD + X_Burdened_Cost,
843: CMT_QUANTITY_ITD = CMT_QUANTITY_ITD + V_Qty,
844: CMT_QUANTITY_YTD = CMT_QUANTITY_YTD + V_Qty,
845: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
846: LAST_UPDATE_DATE = Trunc(Sysdate),
847: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
848: Where PAA.Project_Accum_id In
849: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

Line 847: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

843: CMT_QUANTITY_ITD = CMT_QUANTITY_ITD + V_Qty,
844: CMT_QUANTITY_YTD = CMT_QUANTITY_YTD + V_Qty,
845: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
846: LAST_UPDATE_DATE = Trunc(Sysdate),
847: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
848: Where PAA.Project_Accum_id In
849: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
850: Where Pah.Project_id = x_project_id and
851: pah.Resource_list_member_id = x_resource_list_Member_id and

Line 920: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

916: (V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,0,
917: X_Burdened_Cost,X_Burdened_Cost,
918: 0,0,
919: V_Qty,V_Qty,0,0,
920: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
921: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
922: Recs_processed := Recs_processed + 1;
923: END LOOP;
924: End If;

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

917: X_Burdened_Cost,X_Burdened_Cost,
918: 0,0,
919: V_Qty,V_Qty,0,0,
920: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
921: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
922: Recs_processed := Recs_processed + 1;
923: END LOOP;
924: End If;
925:

Line 962: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

958: (V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,0,
959: X_Burdened_Cost,X_Burdened_Cost,
960: 0,0,
961: V_Qty,V_Qty,0,0,
962: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
963: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
964: Recs_processed := Recs_processed + 1;
965: End If;
966: Close Proj_Res_level_Cur;

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

959: X_Burdened_Cost,X_Burdened_Cost,
960: 0,0,
961: V_Qty,V_Qty,0,0,
962: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
963: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
964: Recs_processed := Recs_processed + 1;
965: End If;
966: Close Proj_Res_level_Cur;
967: x_recs_processed := Recs_processed;

Line 1084: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

1080: CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
1081: CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
1082: CMT_QUANTITY_ITD = CMT_QUANTITY_ITD + V_Qty,
1083: LAST_UPDATE_DATE = Trunc(Sysdate),
1084: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
1085: Where PAA.Project_Accum_id In
1086: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
1087: Where Pah.Project_id = x_project_id and
1088: pah.Resource_list_member_id = x_resource_list_Member_id and

Line 1156: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

1152: LAST_UPDATE_LOGIN) Values
1153: (V_Accum_id,X_Raw_Cost,0,0,0,
1154: X_Burdened_Cost,0,0,0,
1155: V_Qty,0,0,0,
1156: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
1157: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
1158: Recs_processed := Recs_processed + 1;
1159: END LOOP;
1160: End If;

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

1153: (V_Accum_id,X_Raw_Cost,0,0,0,
1154: X_Burdened_Cost,0,0,0,
1155: V_Qty,0,0,0,
1156: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
1157: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
1158: Recs_processed := Recs_processed + 1;
1159: END LOOP;
1160: End If;
1161:

Line 1197: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

1193: LAST_UPDATE_LOGIN) Values
1194: (V_Accum_id,X_Raw_Cost,0,0,0,
1195: X_Burdened_Cost,0,0,0,
1196: V_Qty,0,0,0,
1197: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
1198: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
1199: Recs_processed := Recs_processed + 1;
1200: End If;
1201: Close Proj_Res_level_Cur;

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

1194: (V_Accum_id,X_Raw_Cost,0,0,0,
1195: X_Burdened_Cost,0,0,0,
1196: V_Qty,0,0,0,
1197: X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
1198: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
1199: Recs_processed := Recs_processed + 1;
1200: End If;
1201: Close Proj_Res_level_Cur;
1202: x_recs_processed := Recs_processed;