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

Line 187: FND_GLOBAL.USER_ID CREATED_BY,

183: STATUS_DAYS,
184: CURRENT_STATUS
185: )
186: SELECT SYSDATE CREATION_DATE,
187: FND_GLOBAL.USER_ID CREATED_BY,
188: SYSDATE LAST_UPDATE_DATE,
189: FND_GLOBAL.USER_ID LAST_UPDATED_BY,
190: FND_GLOBAL.CONC_LOGIN_ID LAST_UPDATE_LOGIN,
191: FND_GLOBAL.Conc_Request_Id REQUEST_ID,

Line 189: FND_GLOBAL.USER_ID LAST_UPDATED_BY,

185: )
186: SELECT SYSDATE CREATION_DATE,
187: FND_GLOBAL.USER_ID CREATED_BY,
188: SYSDATE LAST_UPDATE_DATE,
189: FND_GLOBAL.USER_ID LAST_UPDATED_BY,
190: FND_GLOBAL.CONC_LOGIN_ID LAST_UPDATE_LOGIN,
191: FND_GLOBAL.Conc_Request_Id REQUEST_ID,
192: FND_GLOBAL.Conc_Program_Id PROGRAM_ID,
193: FND_GLOBAL.Prog_Appl_Id PROGRAM_APPLICATION_ID,

Line 190: FND_GLOBAL.CONC_LOGIN_ID LAST_UPDATE_LOGIN,

186: SELECT SYSDATE CREATION_DATE,
187: FND_GLOBAL.USER_ID CREATED_BY,
188: SYSDATE LAST_UPDATE_DATE,
189: FND_GLOBAL.USER_ID LAST_UPDATED_BY,
190: FND_GLOBAL.CONC_LOGIN_ID LAST_UPDATE_LOGIN,
191: FND_GLOBAL.Conc_Request_Id REQUEST_ID,
192: FND_GLOBAL.Conc_Program_Id PROGRAM_ID,
193: FND_GLOBAL.Prog_Appl_Id PROGRAM_APPLICATION_ID,
194: SYSDATE PROGRAM_UPDATE_DATE,

Line 191: FND_GLOBAL.Conc_Request_Id REQUEST_ID,

187: FND_GLOBAL.USER_ID CREATED_BY,
188: SYSDATE LAST_UPDATE_DATE,
189: FND_GLOBAL.USER_ID LAST_UPDATED_BY,
190: FND_GLOBAL.CONC_LOGIN_ID LAST_UPDATE_LOGIN,
191: FND_GLOBAL.Conc_Request_Id REQUEST_ID,
192: FND_GLOBAL.Conc_Program_Id PROGRAM_ID,
193: FND_GLOBAL.Prog_Appl_Id PROGRAM_APPLICATION_ID,
194: SYSDATE PROGRAM_UPDATE_DATE,
195: log.LEAD_ID LEAD_ID,

Line 192: FND_GLOBAL.Conc_Program_Id PROGRAM_ID,

188: SYSDATE LAST_UPDATE_DATE,
189: FND_GLOBAL.USER_ID LAST_UPDATED_BY,
190: FND_GLOBAL.CONC_LOGIN_ID LAST_UPDATE_LOGIN,
191: FND_GLOBAL.Conc_Request_Id REQUEST_ID,
192: FND_GLOBAL.Conc_Program_Id PROGRAM_ID,
193: FND_GLOBAL.Prog_Appl_Id PROGRAM_APPLICATION_ID,
194: SYSDATE PROGRAM_UPDATE_DATE,
195: log.LEAD_ID LEAD_ID,
196: ld.DECISION_DATE DECISION_DATE,

Line 193: FND_GLOBAL.Prog_Appl_Id PROGRAM_APPLICATION_ID,

189: FND_GLOBAL.USER_ID LAST_UPDATED_BY,
190: FND_GLOBAL.CONC_LOGIN_ID LAST_UPDATE_LOGIN,
191: FND_GLOBAL.Conc_Request_Id REQUEST_ID,
192: FND_GLOBAL.Conc_Program_Id PROGRAM_ID,
193: FND_GLOBAL.Prog_Appl_Id PROGRAM_APPLICATION_ID,
194: SYSDATE PROGRAM_UPDATE_DATE,
195: log.LEAD_ID LEAD_ID,
196: ld.DECISION_DATE DECISION_DATE,
197: log.STATUS_CODE STATUS_CODE,

Line 216: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

212: -- Update as_last_run_dates
213: UPDATE AS_LAST_RUN_DATES
214: SET PROGRAM_UPDATE_DATE = l_this_refresh_date,
215: LAST_UPDATE_DATE = sysdate,
216: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
217: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
218: REQUEST_ID = FND_GLOBAL.Conc_Request_Id,
219: PROGRAM_APPLICATION_ID = FND_GLOBAL.Prog_Appl_Id,
220: PROGRAM_ID = FND_GLOBAL.Conc_Program_Id

Line 217: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

213: UPDATE AS_LAST_RUN_DATES
214: SET PROGRAM_UPDATE_DATE = l_this_refresh_date,
215: LAST_UPDATE_DATE = sysdate,
216: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
217: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
218: REQUEST_ID = FND_GLOBAL.Conc_Request_Id,
219: PROGRAM_APPLICATION_ID = FND_GLOBAL.Prog_Appl_Id,
220: PROGRAM_ID = FND_GLOBAL.Conc_Program_Id
221: WHERE PROGRAM_NAME = 'ASXRSSM';

Line 218: REQUEST_ID = FND_GLOBAL.Conc_Request_Id,

214: SET PROGRAM_UPDATE_DATE = l_this_refresh_date,
215: LAST_UPDATE_DATE = sysdate,
216: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
217: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
218: REQUEST_ID = FND_GLOBAL.Conc_Request_Id,
219: PROGRAM_APPLICATION_ID = FND_GLOBAL.Prog_Appl_Id,
220: PROGRAM_ID = FND_GLOBAL.Conc_Program_Id
221: WHERE PROGRAM_NAME = 'ASXRSSM';
222: IF (SQL%NOTFOUND) THEN

Line 219: PROGRAM_APPLICATION_ID = FND_GLOBAL.Prog_Appl_Id,

215: LAST_UPDATE_DATE = sysdate,
216: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
217: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
218: REQUEST_ID = FND_GLOBAL.Conc_Request_Id,
219: PROGRAM_APPLICATION_ID = FND_GLOBAL.Prog_Appl_Id,
220: PROGRAM_ID = FND_GLOBAL.Conc_Program_Id
221: WHERE PROGRAM_NAME = 'ASXRSSM';
222: IF (SQL%NOTFOUND) THEN
223: INSERT INTO AS_LAST_RUN_DATES

Line 220: PROGRAM_ID = FND_GLOBAL.Conc_Program_Id

216: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
217: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
218: REQUEST_ID = FND_GLOBAL.Conc_Request_Id,
219: PROGRAM_APPLICATION_ID = FND_GLOBAL.Prog_Appl_Id,
220: PROGRAM_ID = FND_GLOBAL.Conc_Program_Id
221: WHERE PROGRAM_NAME = 'ASXRSSM';
222: IF (SQL%NOTFOUND) THEN
223: INSERT INTO AS_LAST_RUN_DATES
224: ( LAST_UPDATE_DATE,

Line 237: FND_GLOBAL.USER_ID,

233: PROGRAM_NAME
234: )
235: VALUES
236: ( sysdate,
237: FND_GLOBAL.USER_ID,
238: sysdate,
239: FND_GLOBAL.USER_ID,
240: FND_GLOBAL.CONC_LOGIN_ID,
241: FND_GLOBAL.Conc_Request_Id,

Line 239: FND_GLOBAL.USER_ID,

235: VALUES
236: ( sysdate,
237: FND_GLOBAL.USER_ID,
238: sysdate,
239: FND_GLOBAL.USER_ID,
240: FND_GLOBAL.CONC_LOGIN_ID,
241: FND_GLOBAL.Conc_Request_Id,
242: FND_GLOBAL.Prog_Appl_Id,
243: FND_GLOBAL.Conc_Program_Id,

Line 240: FND_GLOBAL.CONC_LOGIN_ID,

236: ( sysdate,
237: FND_GLOBAL.USER_ID,
238: sysdate,
239: FND_GLOBAL.USER_ID,
240: FND_GLOBAL.CONC_LOGIN_ID,
241: FND_GLOBAL.Conc_Request_Id,
242: FND_GLOBAL.Prog_Appl_Id,
243: FND_GLOBAL.Conc_Program_Id,
244: l_this_refresh_date,

Line 241: FND_GLOBAL.Conc_Request_Id,

237: FND_GLOBAL.USER_ID,
238: sysdate,
239: FND_GLOBAL.USER_ID,
240: FND_GLOBAL.CONC_LOGIN_ID,
241: FND_GLOBAL.Conc_Request_Id,
242: FND_GLOBAL.Prog_Appl_Id,
243: FND_GLOBAL.Conc_Program_Id,
244: l_this_refresh_date,
245: 'ASXRSSM'

Line 242: FND_GLOBAL.Prog_Appl_Id,

238: sysdate,
239: FND_GLOBAL.USER_ID,
240: FND_GLOBAL.CONC_LOGIN_ID,
241: FND_GLOBAL.Conc_Request_Id,
242: FND_GLOBAL.Prog_Appl_Id,
243: FND_GLOBAL.Conc_Program_Id,
244: l_this_refresh_date,
245: 'ASXRSSM'
246: );

Line 243: FND_GLOBAL.Conc_Program_Id,

239: FND_GLOBAL.USER_ID,
240: FND_GLOBAL.CONC_LOGIN_ID,
241: FND_GLOBAL.Conc_Request_Id,
242: FND_GLOBAL.Prog_Appl_Id,
243: FND_GLOBAL.Conc_Program_Id,
244: l_this_refresh_date,
245: 'ASXRSSM'
246: );
247: END IF;