APPS.IBY_TRANSACTIONCC_PKG dependencies on DUAL

Line 203: FROM DUAL;

199: );
200:
201: SELECT iby_security_segments_s.NEXTVAL
202: INTO x_segment_id
203: FROM DUAL;
204:
205: INSERT INTO iby_security_segments
206: (sec_segment_id, segment_cipher_text, sec_subkey_id, encoding_scheme,
207: created_by, creation_date, last_updated_by, last_update_date,

Line 443: FROM dual;

439: IF (l_num_trxns = 0) THEN
440: -- new auth request, insert into table
441: SELECT iby_trxnsumm_mid_s.NEXTVAL
442: INTO l_trxn_mid
443: FROM dual;
444:
445: -- get the payer_party_id if exists
446: begin
447: if(payerid_in is not NULL) then

Line 798: FROM dual;

794: print_debuginfo(l_module_name, 'INSERTING TRANSACTION ROW');
795: -- Insert transaction row
796: SELECT iby_trxnsumm_mid_s.NEXTVAL
797: INTO l_trxn_mid
798: FROM dual;
799:
800: transaction_mid_out := l_trxn_mid;
801:
802: -- For OraPmtCredit we need to

Line 1145: FROM dual;

1141: THEN
1142: -- Everything is fine, insert into table
1143: SELECT iby_trxnsumm_mid_s.NEXTVAL
1144: INTO l_trxn_mid
1145: FROM dual;
1146:
1147: transaction_id := getTID(merchant_id_in, order_id_in);
1148:
1149: transaction_id_out := transaction_id;

Line 1338: FROM dual;

1334: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;
1335:
1336: SELECT iby_batches_s.NEXTVAL
1337: INTO l_mbatchid
1338: FROM dual;
1339:
1340: mbatchid_out := l_mbatchid;
1341:
1342: l_batchcurr := currency_in;

Line 1629: --FROM dual;

1625: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;
1626:
1627: --SELECT iby_batches_s.NEXTVAL
1628: -- INTO l_mbatchid
1629: --FROM dual;
1630:
1631: --mbatchid_out := l_mbatchid;
1632:
1633: l_batchcurr := currency_in;

Line 2269: --FROM dual;

2265: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;
2266:
2267: --SELECT iby_batches_s.NEXTVAL
2268: -- INTO l_mbatchid
2269: --FROM dual;
2270:
2271: --mbatchid_out := l_mbatchid;
2272:
2273: l_batchcurr := currency_in;-- should be made NULL

Line 5280: FROM DUAL;

5276:
5277: BEGIN
5278:
5279: SELECT IBY_BATCHID_S.NEXTVAL INTO x_batchID
5280: FROM DUAL;
5281:
5282: END getNextBatchId;
5283:
5284: -- Checks if a row already exists in transactions table

Line 5497: FROM dual;

5493: -- Get the master transaction id for this record
5494:
5495: SELECT iby_trxnsumm_mid_s.NEXTVAL
5496: INTO l_trxn_mid
5497: FROM dual;
5498:
5499: --dbms_output.put_line('position 5');
5500:
5501: getMBatchId(merch_batchid_in, merchant_id_in, l_mbatchid);

Line 5708: FROM dual;

5704: THEN
5705:
5706: SELECT iby_trxnsumm_mid_s.NEXTVAL
5707: INTO l_trxn_mid
5708: FROM dual;
5709:
5710: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
5711:
5712:

Line 6230: FROM dual;

6226: fetch c_tid into l_tid;
6227: if (c_tid%notfound) then
6228: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
6229: INTO l_tid
6230: FROM dual;
6231: end if;
6232:
6233: close c_tid;
6234:

Line 6276: FROM dual;

6272:
6273: if (c_tid%notfound) then
6274: SELECT iby_trxnsumm_trxnid_s.NEXTVAL
6275: INTO l_tid
6276: FROM dual;
6277: end if;
6278:
6279: close c_tid;
6280:

Line 6875: FROM dual;

6871: END IF;
6872:
6873: SELECT to_char(IBY_BATCHID_S.nextval)
6874: INTO batchid_out
6875: FROM dual;
6876: --
6877: -- define the batch; note that this method
6878: -- commits data, so no need for a commit
6879: -- statement to follow