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.PO_PALT_MS_COMPLETION dependencies on FND_GLOBAL

Line 187: last_updated_by = fnd_global.user_id ,

183: IF (L_Solicit_Creation_Dt IS NOT NULL) THEN
184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Solicitation Creation for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Solicit_Creation_Dt,'DD-MON-YYYY HH24:MI:SS'));
185: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
186: SET ACTUAL_COMPLETION_DATE = L_Solicit_Creation_Dt,
187: last_updated_by = fnd_global.user_id ,
188: last_update_date = SYSDATE ,
189: last_update_login = fnd_global.login_id
190: WHERE ASSIGNMENT_ID = l_Assignment_Id
191: and MILESTONE_CODE = 'SOCREATE' ;

Line 189: last_update_login = fnd_global.login_id

185: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
186: SET ACTUAL_COMPLETION_DATE = L_Solicit_Creation_Dt,
187: last_updated_by = fnd_global.user_id ,
188: last_update_date = SYSDATE ,
189: last_update_login = fnd_global.login_id
190: WHERE ASSIGNMENT_ID = l_Assignment_Id
191: and MILESTONE_CODE = 'SOCREATE' ;
192: ELSE
193: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Solicitation Creation for Assignment'||l_Assignment_Number||' is not Completed');

Line 207: last_updated_by = fnd_global.user_id ,

203: IF (L_Solicit_Publish_Dt IS NOT NULL) THEN
204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Publish Solicitation for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Solicit_Publish_Dt,'DD-MON-YYYY HH24:MI:SS'));
205: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
206: SET ACTUAL_COMPLETION_DATE = L_Solicit_Publish_Dt,
207: last_updated_by = fnd_global.user_id ,
208: last_update_date = SYSDATE ,
209: last_update_login = fnd_global.login_id
210: WHERE ASSIGNMENT_ID = l_Assignment_Id
211: and MILESTONE_CODE = 'SOPUBLIS' ;

Line 209: last_update_login = fnd_global.login_id

205: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
206: SET ACTUAL_COMPLETION_DATE = L_Solicit_Publish_Dt,
207: last_updated_by = fnd_global.user_id ,
208: last_update_date = SYSDATE ,
209: last_update_login = fnd_global.login_id
210: WHERE ASSIGNMENT_ID = l_Assignment_Id
211: and MILESTONE_CODE = 'SOPUBLIS' ;
212: ELSE
213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Publish Solicitation for Assignment'||l_Assignment_Number||' is not Completed');

Line 227: last_updated_by = fnd_global.user_id ,

223: IF (L_Award_Creation_Dt IS NOT NULL) THEN
224: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Award Creation for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Award_Creation_Dt,'DD-MON-YYYY HH24:MI:SS'));
225: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
226: SET ACTUAL_COMPLETION_DATE = L_Award_Creation_Dt,
227: last_updated_by = fnd_global.user_id ,
228: last_update_date = SYSDATE ,
229: last_update_login = fnd_global.login_id
230: WHERE ASSIGNMENT_ID = l_Assignment_Id
231: and MILESTONE_CODE = 'AWCREATE' ;

Line 229: last_update_login = fnd_global.login_id

225: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
226: SET ACTUAL_COMPLETION_DATE = L_Award_Creation_Dt,
227: last_updated_by = fnd_global.user_id ,
228: last_update_date = SYSDATE ,
229: last_update_login = fnd_global.login_id
230: WHERE ASSIGNMENT_ID = l_Assignment_Id
231: and MILESTONE_CODE = 'AWCREATE' ;
232:
233: ELSE

Line 249: last_updated_by = fnd_global.user_id ,

245: IF (L_Award_Approval_Dt IS NOT NULL) THEN
246: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Award Approval for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Award_Approval_Dt,'DD-MON-YYYY HH24:MI:SS'));
247: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
248: SET ACTUAL_COMPLETION_DATE = L_Award_Approval_Dt,
249: last_updated_by = fnd_global.user_id ,
250: last_update_date = SYSDATE ,
251: last_update_login = fnd_global.login_id
252: WHERE ASSIGNMENT_ID = l_Assignment_Id
253: and MILESTONE_CODE = 'AWAPPROV' ;

Line 251: last_update_login = fnd_global.login_id

247: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
248: SET ACTUAL_COMPLETION_DATE = L_Award_Approval_Dt,
249: last_updated_by = fnd_global.user_id ,
250: last_update_date = SYSDATE ,
251: last_update_login = fnd_global.login_id
252: WHERE ASSIGNMENT_ID = l_Assignment_Id
253: and MILESTONE_CODE = 'AWAPPROV' ;
254: ELSE
255: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Award Approval for Assignment'||l_Assignment_Number||' is not Completed');

Line 292: last_updated_by = fnd_global.user_id ,

288: SET ACTUAL_COMPLETION_DATE = (SELECT Max(ACTUAL_COMPLETION_DATE)
289: FROM PO_CLM_ASSGNMT_MILESTONE_DTLS
290: WHERE ASSIGNMENT_ID = l_Assignment_Id) ,
291: ASSIGNMENT_STATUS = 4,
292: last_updated_by = fnd_global.user_id ,
293: last_update_date = SYSDATE ,
294: last_update_login = fnd_global.login_id
295: WHERE ASSIGNMENT_ID = l_Assignment_Id;
296:

Line 294: last_update_login = fnd_global.login_id

290: WHERE ASSIGNMENT_ID = l_Assignment_Id) ,
291: ASSIGNMENT_STATUS = 4,
292: last_updated_by = fnd_global.user_id ,
293: last_update_date = SYSDATE ,
294: last_update_login = fnd_global.login_id
295: WHERE ASSIGNMENT_ID = l_Assignment_Id;
296:
297: END IF;
298: END LOOP;