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.

[Home] [Help]

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: --Bug:8363526
1205: --Inserting new column settledate VALUE:sysdate
1206: INSERT INTO iby_batches_all
1207: (MBatchID, BatchID, org_id, MPayeeID, PayeeID, /* BatchCloseStatus,*/

Line 1313: FROM dual;

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

Line 1316: -- FROM dual;

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

Line 1575: FROM dual;

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

Line 1578: -- FROM dual;

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