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.IBY_OFFLINEDB_PKG dependencies on DUAL

Line 127: FROM dual;

123:
124: -- Get the master transaction id sequence for all requests
125: SELECT iby_trxnsumm_mid_s.NEXTVAL
126: INTO l_mid
127: FROM dual;
128:
129: -- insert the scheduled request in the summary and core tables
130: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
131: INSERT INTO iby_trxn_summaries_all

Line 239: FROM dual;

235: -- Get the master transaction id sequence for all requests
236:
237: SELECT iby_trxnsumm_mid_s.NEXTVAL
238: INTO l_mid
239: FROM dual;
240:
241: select mtangibleid, payerinstrid into l_tmid, l_instrid
242: from iby_trxn_summaries_all
243: where transactionid = i_transactionid

Line 314: FROM dual;

310: -- insert the request into the batch table
311:
312: SELECT iby_batches_s.NEXTVAL
313: INTO l_mbatchid
314: FROM dual;
315:
316: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
317: INSERT INTO iby_batches_all
318: (MBatchID, BatchID, MPayeeID, PayeeID, BEPID, bepkey, ECAppID,

Line 422: --FROM dual;

418:
419: l_tid := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid);
420: --SELECT iby_trxnsumm_trxnid_s.NEXTVAL
421: --INTO l_tid
422: --FROM dual;
423: io_transactionid := l_tid;
424: END IF;
425: -- Get the master transaction id sequence for all requests
426:

Line 429: FROM dual;

425: -- Get the master transaction id sequence for all requests
426:
427: SELECT iby_trxnsumm_mid_s.NEXTVAL
428: INTO l_mid
429: FROM dual;
430:
431: -- insert the scheduled request in the summary and core tables
432: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
433: iby_transactioncc_pkg.getMBatchId(batchid, i_payeeid, l_mbatchid);

Line 506: FROM dual;

502: -- Get the master transaction id sequence for all requests
503:
504: SELECT iby_trxnsumm_mid_s.NEXTVAL
505: INTO l_mid
506: FROM dual;
507:
508: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
509: INSERT INTO iby_trxn_summaries_all
510: (TrxnMID, TransactionID, TangibleID,

Line 596: --FROM dual;

592:
593: l_tid := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid);
594: --SELECT iby_trxnsumm_trxnid_s.NEXTVAL
595: --INTO l_tid
596: --FROM dual;
597: io_transactionid := l_tid;
598: END IF;
599: -- Get the master transaction id sequence for all requests
600:

Line 603: FROM dual;

599: -- Get the master transaction id sequence for all requests
600:
601: SELECT iby_trxnsumm_mid_s.NEXTVAL
602: INTO l_mid
603: FROM dual;
604: -- insert the scheduled request in the summary and core tables
605: iby_transactioncc_pkg.getMBatchId(batchid, i_payeeid, l_mbatchid);
606: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
607: INSERT INTO iby_trxn_summaries_all

Line 684: FROM dual;

680:
681: -- insert the request into the batch table
682: SELECT iby_batches_s.NEXTVAL
683: INTO l_mbatchid
684: FROM dual;
685: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
686: INSERT INTO iby_batches_all
687: (MBatchID, BatchID, MPayeeID, PayeeID, BEPID, ECAppID,
688: ReqType, ReqDate, DestUrl, PaymentMethodName,