APPS.IBY_TRANSACTIONCC_PKG dependencies on DUAL

Line 389: FROM dual;

385: IF (l_num_trxns = 0) THEN
386: -- new auth request, insert into table
387: SELECT iby_trxnsumm_mid_s.NEXTVAL
388: INTO l_trxn_mid
389: FROM dual;
390:
391: -- get the payer_party_id if exists
392: begin
393: if(payerid_in is not NULL) then

Line 728: FROM dual;

724: iby_debug_pub.add('Partial reversal. Cloning auth record.',IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
725:
726: SELECT iby_trxnsumm_mid_s.NEXTVAL
727: INTO l_new_auth_trxnmid
728: FROM dual;
729:
730: INSERT INTO iby_trxn_summaries_all
731: (TrxnMID, TransactionID,TrxntypeID, ReqType, ReqDate,
732: Amount,CurrencyNameCode, UpdateDate,Status, PaymentMethodName,

Line 955: FROM dual;

951: END IF;
952: -- Insert transaction row
953: SELECT iby_trxnsumm_mid_s.NEXTVAL
954: INTO l_trxn_mid
955: FROM dual;
956:
957: transaction_mid_out := l_trxn_mid;
958:
959: -- For OraPmtCredit we need to

Line 1348: FROM dual;

1344: THEN
1345: -- Everything is fine, insert into table
1346: SELECT iby_trxnsumm_mid_s.NEXTVAL
1347: INTO l_trxn_mid
1348: FROM dual;
1349: IF(reauth_transaction_id > 0)THEN
1350: transaction_id := reauth_transaction_id;
1351: ELSE
1352: transaction_id := getTID(merchant_id_in, order_id_in);

Line 1545: FROM dual;

1541: --LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;
1542:
1543: SELECT iby_batches_s.NEXTVAL
1544: INTO l_mbatchid
1545: FROM dual;
1546:
1547: mbatchid_out := l_mbatchid;
1548:
1549: l_batchcurr := currency_in;

Line 1841: --FROM dual;

1837: --LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;
1838:
1839: --SELECT iby_batches_s.NEXTVAL
1840: -- INTO l_mbatchid
1841: --FROM dual;
1842:
1843: --mbatchid_out := l_mbatchid;
1844:
1845: l_batchcurr := currency_in;

Line 2505: --FROM dual;

2501: --LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;
2502:
2503: --SELECT iby_batches_s.NEXTVAL
2504: -- INTO l_mbatchid
2505: --FROM dual;
2506:
2507: --mbatchid_out := l_mbatchid;
2508:
2509: l_batchcurr := currency_in;-- should be made NULL

Line 5782: FROM DUAL;

5778:
5779: BEGIN
5780:
5781: SELECT IBY_BATCHID_S.NEXTVAL INTO x_batchID
5782: FROM DUAL;
5783:
5784: END getNextBatchId;
5785:
5786: -- Checks if a row already exists in transactions table

Line 5999: FROM dual;

5995: -- Get the master transaction id for this record
5996:
5997: SELECT iby_trxnsumm_mid_s.NEXTVAL
5998: INTO l_trxn_mid
5999: FROM dual;
6000:
6001: --dbms_output.put_line('position 5');
6002:
6003: getMBatchId(merch_batchid_in, merchant_id_in, l_mbatchid);

Line 6210: FROM dual;

6206: THEN
6207:
6208: SELECT iby_trxnsumm_mid_s.NEXTVAL
6209: INTO l_trxn_mid
6210: FROM dual;
6211:
6212: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
6213:
6214:

Line 6787: FROM dual;

6783: fetch c_tid into l_tid;
6784: if (c_tid%notfound) then
6785: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
6786: INTO l_tid
6787: FROM dual;
6788: end if;
6789:
6790: close c_tid;
6791:

Line 6833: FROM dual;

6829:
6830: if (c_tid%notfound) then
6831: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
6832: INTO l_tid
6833: FROM dual;
6834: end if;
6835:
6836: close c_tid;
6837:

Line 7372: FROM dual;

7368: END IF;
7369:
7370: SELECT to_char(IBY_BATCHID_S.nextval)
7371: INTO batchid_out
7372: FROM dual;
7373: --
7374: -- define the batch; note that this method
7375: -- commits data, so no need for a commit
7376: -- statement to follow