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.JTY_TRANS_USG_PGM_SQL_PKG dependencies on DBMS_LOB

Line 295: DBMS_LOB.OPEN(l_real_time_insert_clob, DBMS_LOB.LOB_READWRITE);

291: OPEN CUR_REAL_TIME_INSERT(l_trans_usg_pgm_sql_id);
292: LOOP
293: FETCH CUR_REAL_TIME_INSERT INTO l_real_time_insert_clob;
294: EXIT WHEN CUR_REAL_TIME_INSERT%NOTFOUND;
295: DBMS_LOB.OPEN(l_real_time_insert_clob, DBMS_LOB.LOB_READWRITE);
296: DBMS_LOB.WRITEAPPEND(l_real_time_insert_clob,LENGTH(l_real_time_insert),l_real_time_insert);
297: DBMS_LOB.CLOSE(l_real_time_insert_clob);
298: END LOOP;
299: CLOSE CUR_REAL_TIME_INSERT;

Line 296: DBMS_LOB.WRITEAPPEND(l_real_time_insert_clob,LENGTH(l_real_time_insert),l_real_time_insert);

292: LOOP
293: FETCH CUR_REAL_TIME_INSERT INTO l_real_time_insert_clob;
294: EXIT WHEN CUR_REAL_TIME_INSERT%NOTFOUND;
295: DBMS_LOB.OPEN(l_real_time_insert_clob, DBMS_LOB.LOB_READWRITE);
296: DBMS_LOB.WRITEAPPEND(l_real_time_insert_clob,LENGTH(l_real_time_insert),l_real_time_insert);
297: DBMS_LOB.CLOSE(l_real_time_insert_clob);
298: END LOOP;
299: CLOSE CUR_REAL_TIME_INSERT;
300:

Line 297: DBMS_LOB.CLOSE(l_real_time_insert_clob);

293: FETCH CUR_REAL_TIME_INSERT INTO l_real_time_insert_clob;
294: EXIT WHEN CUR_REAL_TIME_INSERT%NOTFOUND;
295: DBMS_LOB.OPEN(l_real_time_insert_clob, DBMS_LOB.LOB_READWRITE);
296: DBMS_LOB.WRITEAPPEND(l_real_time_insert_clob,LENGTH(l_real_time_insert),l_real_time_insert);
297: DBMS_LOB.CLOSE(l_real_time_insert_clob);
298: END LOOP;
299: CLOSE CUR_REAL_TIME_INSERT;
300:
301: OPEN CUR_REAL_TIME(l_trans_usg_pgm_sql_id);

Line 305: DBMS_LOB.OPEN(l_real_time_sql_clob, DBMS_LOB.LOB_READWRITE);

301: OPEN CUR_REAL_TIME(l_trans_usg_pgm_sql_id);
302: LOOP
303: FETCH CUR_REAL_TIME INTO l_real_time_sql_clob;
304: EXIT WHEN CUR_REAL_TIME%NOTFOUND;
305: DBMS_LOB.OPEN(l_real_time_sql_clob, DBMS_LOB.LOB_READWRITE);
306: DBMS_LOB.WRITEAPPEND(l_real_time_sql_clob,LENGTH(p_real_time_sql),p_real_time_sql);
307: DBMS_LOB.CLOSE(l_real_time_sql_clob);
308: END LOOP;
309: CLOSE CUR_REAL_TIME;

Line 306: DBMS_LOB.WRITEAPPEND(l_real_time_sql_clob,LENGTH(p_real_time_sql),p_real_time_sql);

302: LOOP
303: FETCH CUR_REAL_TIME INTO l_real_time_sql_clob;
304: EXIT WHEN CUR_REAL_TIME%NOTFOUND;
305: DBMS_LOB.OPEN(l_real_time_sql_clob, DBMS_LOB.LOB_READWRITE);
306: DBMS_LOB.WRITEAPPEND(l_real_time_sql_clob,LENGTH(p_real_time_sql),p_real_time_sql);
307: DBMS_LOB.CLOSE(l_real_time_sql_clob);
308: END LOOP;
309: CLOSE CUR_REAL_TIME;
310: EXCEPTION

Line 307: DBMS_LOB.CLOSE(l_real_time_sql_clob);

303: FETCH CUR_REAL_TIME INTO l_real_time_sql_clob;
304: EXIT WHEN CUR_REAL_TIME%NOTFOUND;
305: DBMS_LOB.OPEN(l_real_time_sql_clob, DBMS_LOB.LOB_READWRITE);
306: DBMS_LOB.WRITEAPPEND(l_real_time_sql_clob,LENGTH(p_real_time_sql),p_real_time_sql);
307: DBMS_LOB.CLOSE(l_real_time_sql_clob);
308: END LOOP;
309: CLOSE CUR_REAL_TIME;
310: EXCEPTION
311: when others then

Line 387: DBMS_LOB.OPEN(l_batch_total_sql_clob, DBMS_LOB.LOB_READWRITE);

383: OPEN CUR_BATCH_TOTAL(l_trans_usg_pgm_sql_id);
384: LOOP
385: FETCH CUR_BATCH_TOTAL INTO l_batch_total_sql_clob;
386: EXIT WHEN CUR_BATCH_TOTAL%NOTFOUND;
387: DBMS_LOB.OPEN(l_batch_total_sql_clob, DBMS_LOB.LOB_READWRITE);
388: DBMS_LOB.WRITEAPPEND(l_batch_total_sql_clob,LENGTH(p_batch_total_sql),p_batch_total_sql);
389: DBMS_LOB.CLOSE(l_batch_total_sql_clob);
390: END LOOP;
391: CLOSE CUR_BATCH_TOTAL;

Line 388: DBMS_LOB.WRITEAPPEND(l_batch_total_sql_clob,LENGTH(p_batch_total_sql),p_batch_total_sql);

384: LOOP
385: FETCH CUR_BATCH_TOTAL INTO l_batch_total_sql_clob;
386: EXIT WHEN CUR_BATCH_TOTAL%NOTFOUND;
387: DBMS_LOB.OPEN(l_batch_total_sql_clob, DBMS_LOB.LOB_READWRITE);
388: DBMS_LOB.WRITEAPPEND(l_batch_total_sql_clob,LENGTH(p_batch_total_sql),p_batch_total_sql);
389: DBMS_LOB.CLOSE(l_batch_total_sql_clob);
390: END LOOP;
391: CLOSE CUR_BATCH_TOTAL;
392: EXCEPTION

Line 389: DBMS_LOB.CLOSE(l_batch_total_sql_clob);

385: FETCH CUR_BATCH_TOTAL INTO l_batch_total_sql_clob;
386: EXIT WHEN CUR_BATCH_TOTAL%NOTFOUND;
387: DBMS_LOB.OPEN(l_batch_total_sql_clob, DBMS_LOB.LOB_READWRITE);
388: DBMS_LOB.WRITEAPPEND(l_batch_total_sql_clob,LENGTH(p_batch_total_sql),p_batch_total_sql);
389: DBMS_LOB.CLOSE(l_batch_total_sql_clob);
390: END LOOP;
391: CLOSE CUR_BATCH_TOTAL;
392: EXCEPTION
393: when others then

Line 454: DBMS_LOB.OPEN(l_batch_incr_sql_clob, DBMS_LOB.LOB_READWRITE);

450: OPEN CUR_BATCH_INCR(l_trans_usg_pgm_sql_id);
451: LOOP
452: FETCH CUR_BATCH_INCR INTO l_batch_incr_sql_clob;
453: EXIT WHEN CUR_BATCH_INCR%NOTFOUND;
454: DBMS_LOB.OPEN(l_batch_incr_sql_clob, DBMS_LOB.LOB_READWRITE);
455: DBMS_LOB.WRITEAPPEND(l_batch_incr_sql_clob,LENGTH(p_batch_incr_sql),p_batch_incr_sql);
456: DBMS_LOB.CLOSE(l_batch_incr_sql_clob);
457: END LOOP;
458: CLOSE CUR_BATCH_INCR;

Line 455: DBMS_LOB.WRITEAPPEND(l_batch_incr_sql_clob,LENGTH(p_batch_incr_sql),p_batch_incr_sql);

451: LOOP
452: FETCH CUR_BATCH_INCR INTO l_batch_incr_sql_clob;
453: EXIT WHEN CUR_BATCH_INCR%NOTFOUND;
454: DBMS_LOB.OPEN(l_batch_incr_sql_clob, DBMS_LOB.LOB_READWRITE);
455: DBMS_LOB.WRITEAPPEND(l_batch_incr_sql_clob,LENGTH(p_batch_incr_sql),p_batch_incr_sql);
456: DBMS_LOB.CLOSE(l_batch_incr_sql_clob);
457: END LOOP;
458: CLOSE CUR_BATCH_INCR;
459: EXCEPTION

Line 456: DBMS_LOB.CLOSE(l_batch_incr_sql_clob);

452: FETCH CUR_BATCH_INCR INTO l_batch_incr_sql_clob;
453: EXIT WHEN CUR_BATCH_INCR%NOTFOUND;
454: DBMS_LOB.OPEN(l_batch_incr_sql_clob, DBMS_LOB.LOB_READWRITE);
455: DBMS_LOB.WRITEAPPEND(l_batch_incr_sql_clob,LENGTH(p_batch_incr_sql),p_batch_incr_sql);
456: DBMS_LOB.CLOSE(l_batch_incr_sql_clob);
457: END LOOP;
458: CLOSE CUR_BATCH_INCR;
459: EXCEPTION
460: when others then

Line 531: DBMS_LOB.OPEN(l_batch_dea_sql_clob, DBMS_LOB.LOB_READWRITE);

527: OPEN CUR_BATCH_DEA(l_trans_usg_pgm_sql_id);
528: LOOP
529: FETCH CUR_BATCH_DEA INTO l_batch_dea_sql_clob;
530: EXIT WHEN CUR_BATCH_DEA%NOTFOUND;
531: DBMS_LOB.OPEN(l_batch_dea_sql_clob, DBMS_LOB.LOB_READWRITE);
532: DBMS_LOB.WRITEAPPEND(l_batch_dea_sql_clob,LENGTH(p_batch_dea_sql),p_batch_dea_sql);
533: DBMS_LOB.CLOSE(l_batch_dea_sql_clob);
534: END LOOP;
535: CLOSE CUR_BATCH_DEA;

Line 532: DBMS_LOB.WRITEAPPEND(l_batch_dea_sql_clob,LENGTH(p_batch_dea_sql),p_batch_dea_sql);

528: LOOP
529: FETCH CUR_BATCH_DEA INTO l_batch_dea_sql_clob;
530: EXIT WHEN CUR_BATCH_DEA%NOTFOUND;
531: DBMS_LOB.OPEN(l_batch_dea_sql_clob, DBMS_LOB.LOB_READWRITE);
532: DBMS_LOB.WRITEAPPEND(l_batch_dea_sql_clob,LENGTH(p_batch_dea_sql),p_batch_dea_sql);
533: DBMS_LOB.CLOSE(l_batch_dea_sql_clob);
534: END LOOP;
535: CLOSE CUR_BATCH_DEA;
536: EXCEPTION

Line 533: DBMS_LOB.CLOSE(l_batch_dea_sql_clob);

529: FETCH CUR_BATCH_DEA INTO l_batch_dea_sql_clob;
530: EXIT WHEN CUR_BATCH_DEA%NOTFOUND;
531: DBMS_LOB.OPEN(l_batch_dea_sql_clob, DBMS_LOB.LOB_READWRITE);
532: DBMS_LOB.WRITEAPPEND(l_batch_dea_sql_clob,LENGTH(p_batch_dea_sql),p_batch_dea_sql);
533: DBMS_LOB.CLOSE(l_batch_dea_sql_clob);
534: END LOOP;
535: CLOSE CUR_BATCH_DEA;
536: EXCEPTION
537: when others then

Line 551: DBMS_LOB.OPEN(l_incr_reassign_sql_clob, DBMS_LOB.LOB_READWRITE);

547: OPEN CUR_INCR_REASSIGN(l_trans_usg_pgm_sql_id);
548: LOOP
549: FETCH CUR_INCR_REASSIGN INTO l_incr_reassign_sql_clob;
550: EXIT WHEN CUR_INCR_REASSIGN%NOTFOUND;
551: DBMS_LOB.OPEN(l_incr_reassign_sql_clob, DBMS_LOB.LOB_READWRITE);
552: DBMS_LOB.WRITEAPPEND(l_incr_reassign_sql_clob,LENGTH(p_incr_reassign_sql),p_incr_reassign_sql);
553: DBMS_LOB.CLOSE(l_incr_reassign_sql_clob);
554: END LOOP;
555: CLOSE CUR_INCR_REASSIGN;

Line 552: DBMS_LOB.WRITEAPPEND(l_incr_reassign_sql_clob,LENGTH(p_incr_reassign_sql),p_incr_reassign_sql);

548: LOOP
549: FETCH CUR_INCR_REASSIGN INTO l_incr_reassign_sql_clob;
550: EXIT WHEN CUR_INCR_REASSIGN%NOTFOUND;
551: DBMS_LOB.OPEN(l_incr_reassign_sql_clob, DBMS_LOB.LOB_READWRITE);
552: DBMS_LOB.WRITEAPPEND(l_incr_reassign_sql_clob,LENGTH(p_incr_reassign_sql),p_incr_reassign_sql);
553: DBMS_LOB.CLOSE(l_incr_reassign_sql_clob);
554: END LOOP;
555: CLOSE CUR_INCR_REASSIGN;
556: EXCEPTION

Line 553: DBMS_LOB.CLOSE(l_incr_reassign_sql_clob);

549: FETCH CUR_INCR_REASSIGN INTO l_incr_reassign_sql_clob;
550: EXIT WHEN CUR_INCR_REASSIGN%NOTFOUND;
551: DBMS_LOB.OPEN(l_incr_reassign_sql_clob, DBMS_LOB.LOB_READWRITE);
552: DBMS_LOB.WRITEAPPEND(l_incr_reassign_sql_clob,LENGTH(p_incr_reassign_sql),p_incr_reassign_sql);
553: DBMS_LOB.CLOSE(l_incr_reassign_sql_clob);
554: END LOOP;
555: CLOSE CUR_INCR_REASSIGN;
556: EXCEPTION
557: when others then