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 IBY_TRXNSUMM_MID_S

Line 59: SELECT iby_trxnsumm_mid_s.NEXTVAL

55: AND PayeeID = merchant_id_in;
56: IF (num_trxns = 0)
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

Line 287: SELECT iby_trxnsumm_mid_s.NEXTVAL

283:
284:
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:

Line 578: SELECT iby_trxnsumm_mid_s.NEXTVAL

574: IF (num_trxns = 0)
575: THEN
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))

Line 809: SELECT iby_trxnsumm_mid_s.NEXTVAL

805: IF (num_trxns = 0)
806: THEN
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))

Line 1033: SELECT iby_trxnsumm_mid_s.NEXTVAL

1029: IF (num_trxns = 0)
1030: THEN
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

Line 1311: SELECT iby_trxnsumm_mid_s.NEXTVAL

1307: AND extended.TrxnMID = summary.TrxnMID;
1308: IF (num_trxns = 0)
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

Line 1573: SELECT iby_trxnsumm_mid_s.NEXTVAL

1569: find_parent_splitid(order_id_in, merchant_id_in,
1570: vendor_id_in, trxn_type_in,
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