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_TRANSACTIONSET_PKG dependencies on DUAL

Line 61: FROM dual;

57: THEN
58: -- Everything is fine, insert into table
59: SELECT iby_trxnsumm_mid_s.NEXTVAL
60: INTO trxn_mid
61: FROM dual;
62: IF ((transaction_id_in_out = '') OR
63: (transaction_id_in_out = -1) OR
64: (transaction_id_in_out IS NULL))
65: THEN

Line 68: FROM dual;

64: (transaction_id_in_out IS NULL))
65: THEN
66: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
67: INTO transaction_id
68: FROM dual;
69: transaction_id_in_out := transaction_id;
70: ELSE
71: transaction_id := transaction_id_in_out;
72: END IF;

Line 289: FROM dual;

285: -- No previous transaction, so insert new row
286: -- generate trxn_mid, TransactionID
287: SELECT iby_trxnsumm_mid_s.NEXTVAL
288: INTO trxn_mid
289: FROM dual;
290:
291:
292: IF ((transaction_id_in_out = '') OR
293: (transaction_id_in_out IS NULL) OR

Line 309: FROM dual;

305: THEN
306:
307: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
308: INTO transaction_id
309: FROM dual;
310:
311: ELSE
312: SELECT DISTINCT TransactionId
313: INTO transaction_id

Line 580: FROM dual;

576: -- No previous transaction, so insert new row
577: -- generate trxn_id and transaction_id
578: SELECT iby_trxnsumm_mid_s.NEXTVAL
579: INTO trxn_mid
580: FROM dual;
581: IF ((transaction_id_in_out = '') OR
582: (transaction_id_in_out IS NULL))
583: THEN
584: SELECT iby_trxnsumm_trxnid_s.NEXTVAL

Line 586: FROM dual;

582: (transaction_id_in_out IS NULL))
583: THEN
584: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
585: INTO transaction_id
586: FROM dual;
587: transaction_id_in_out := transaction_id;
588: ELSE
589: transaction_id := transaction_id_in_out;
590: END IF;

Line 811: FROM dual;

807: -- No previous transaction, so insert new row
808: -- generate trxn_id and transaction_id
809: SELECT iby_trxnsumm_mid_s.NEXTVAL
810: INTO trxn_mid
811: FROM dual;
812: IF ((transaction_id_in_out = '') OR
813: (transaction_id_in_out IS NULL))
814: THEN
815:

Line 827: FROM dual;

823: THEN
824:
825: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
826: INTO transaction_id
827: FROM dual;
828:
829: ELSE
830: SELECT DISTINCT TransactionId
831: INTO transaction_id

Line 1035: FROM dual;

1031: -- Insert transaction row
1032: -- generate trxn_id and transaction_id
1033: SELECT iby_trxnsumm_mid_s.NEXTVAL
1034: INTO trxn_mid
1035: FROM dual;
1036: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
1037: INTO transaction_id
1038: FROM dual;
1039: transaction_id_in_out := transaction_id;

Line 1038: FROM dual;

1034: INTO trxn_mid
1035: FROM dual;
1036: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
1037: INTO transaction_id
1038: FROM dual;
1039: transaction_id_in_out := transaction_id;
1040:
1041:
1042:

Line 1203: FROM dual;

1199: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
1200:
1201: SELECT iby_batches_s.NEXTVAL
1202: INTO l_mbatchid
1203: FROM dual;
1204:
1205: INSERT INTO iby_batches_all
1206: (MBatchID, BatchID, org_id, MPayeeID, PayeeID, /* BatchCloseStatus,*/
1207: CURRENCYNameCode, BatchSales, BatchCredit, BatchTotal,

Line 1312: FROM dual;

1308: THEN
1309: -- generate trxn_id and transaction_id
1310: SELECT iby_trxnsumm_mid_s.NEXTVAL
1311: INTO trxn_mid
1312: FROM dual;
1313: -- SELECT iby_trxnsumm_trxnid_s.NEXTVAL
1314: -- INTO transaction_id
1315: -- FROM dual;
1316: -- transaction_id_in_out := transaction_id;

Line 1315: -- FROM dual;

1311: INTO trxn_mid
1312: FROM dual;
1313: -- SELECT iby_trxnsumm_trxnid_s.NEXTVAL
1314: -- INTO transaction_id
1315: -- FROM dual;
1316: -- transaction_id_in_out := transaction_id;
1317: -- No previous transaction, so get parent split_id
1318: find_parent_splitid(order_id_in, merchant_id_in,
1319: vendor_id_in, trxn_type_in,

Line 1574: FROM dual;

1570: prev_set_trxn_id_in, split_id_in_out);
1571: -- generate trxn_id and transaction_id
1572: SELECT iby_trxnsumm_mid_s.NEXTVAL
1573: INTO trxn_mid
1574: FROM dual;
1575: --SELECT iby_trxnsumm_trxnid_s.NEXTVAL
1576: -- INTO transaction_id
1577: -- FROM dual;
1578: --transaction_id_in_out := transaction_id;

Line 1577: -- FROM dual;

1573: INTO trxn_mid
1574: FROM dual;
1575: --SELECT iby_trxnsumm_trxnid_s.NEXTVAL
1576: -- INTO transaction_id
1577: -- FROM dual;
1578: --transaction_id_in_out := transaction_id;
1579:
1580:
1581: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);