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.CSFW_SETUP_PKG dependencies on CSFW_MSESSION_URL

Line 189: WHERE sequence_name LIKE 'CSFW_MSESSION_URLID_S%'

185:
186: cursor get_old_seq_name is
187: SELECT sequence_name
188: FROM all_sequences
189: WHERE sequence_name LIKE 'CSFW_MSESSION_URLID_S%'
190: AND sequence_owner = USER;
191:
192: l_seq_ddl_str varchar2(100);
193: BEGIN

Line 250: -- block for CSFW_MSESSION_URL

246: return;
247: end;
248: -- end block for CSFW_MSESSION_COOKIE
249:
250: -- block for CSFW_MSESSION_URL
251: begin
252: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
253: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
254: 'Start deleting CSFW_MSESSION_URL ...');

Line 254: 'Start deleting CSFW_MSESSION_URL ...');

250: -- block for CSFW_MSESSION_URL
251: begin
252: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
253: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
254: 'Start deleting CSFW_MSESSION_URL ...');
255: end if;
256:
257: DELETE FROM CSFW_MSESSION_URL
258: WHERE session_id IN

Line 257: DELETE FROM CSFW_MSESSION_URL

253: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
254: 'Start deleting CSFW_MSESSION_URL ...');
255: end if;
256:
257: DELETE FROM CSFW_MSESSION_URL
258: WHERE session_id IN
259: (SELECT session_id
260: FROM CSFW_MSESSION
261: WHERE last_access_date <= l_end_date

Line 266: 'Deleted records for CSFW_MSESSION_URL = ' || l_deleted_records);

262: ) RETURNING count(*) INTO l_deleted_records;
263:
264: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
265: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
266: 'Deleted records for CSFW_MSESSION_URL = ' || l_deleted_records);
267: end if;
268: exception
269: when others then
270: rollback to csfw_purge;

Line 273: 'Exception occured while deleting CSFW_MSESSION_URL sqlerrm = ' || sqlerrm);

269: when others then
270: rollback to csfw_purge;
271: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
273: 'Exception occured while deleting CSFW_MSESSION_URL sqlerrm = ' || sqlerrm);
274: end if;
275: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');
276: errbuf := fnd_message.get;
277: retcode := 2;

Line 280: -- end block for CSFW_MSESSION_URL

276: errbuf := fnd_message.get;
277: retcode := 2;
278: return;
279: end;
280: -- end block for CSFW_MSESSION_URL
281:
282: -- block for CSFW_MSESSION
283: begin
284: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 314: -- need to clear old CSFW_MSESSION_URLID_S% sequences as well if it is there

310:
311: -- now we can commit
312: commit;
313:
314: -- need to clear old CSFW_MSESSION_URLID_S% sequences as well if it is there
315: begin
316: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
317: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
318: 'Start clearing old CSFW_MSESSION_URLID_S% sequences ...');

Line 318: 'Start clearing old CSFW_MSESSION_URLID_S% sequences ...');

314: -- need to clear old CSFW_MSESSION_URLID_S% sequences as well if it is there
315: begin
316: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
317: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
318: 'Start clearing old CSFW_MSESSION_URLID_S% sequences ...');
319: end if;
320:
321: for l_old_seq_name in get_old_seq_name
322: loop

Line 331: 'Exception occured while deleting CSFW_MSESSION_URLID_S% sequences sqlerrm = ' || sqlerrm);

327: exception
328: when others then
329: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
330: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
331: 'Exception occured while deleting CSFW_MSESSION_URLID_S% sequences sqlerrm = ' || sqlerrm);
332: end if;
333: end;
334:
335: -- now we can commit