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_TRANSACTIONCC_PKG dependencies on IBY_BATCHES_ALL

Line 19: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,

15: --
16: PROCEDURE validate_open_batch
17: (
18: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,
19: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,
20: p_sec_key_on IN VARCHAR2,
21: x_trxn_count OUT NOCOPY iby_batches_all.numtrxns%TYPE,
22: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE
23: )

Line 21: x_trxn_count OUT NOCOPY iby_batches_all.numtrxns%TYPE,

17: (
18: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,
19: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,
20: p_sec_key_on IN VARCHAR2,
21: x_trxn_count OUT NOCOPY iby_batches_all.numtrxns%TYPE,
22: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE
23: )
24: IS
25: l_sec_trxn_count NUMBER;

Line 22: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE

18: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,
19: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,
20: p_sec_key_on IN VARCHAR2,
21: x_trxn_count OUT NOCOPY iby_batches_all.numtrxns%TYPE,
22: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE
23: )
24: IS
25: l_sec_trxn_count NUMBER;
26: l_batch_currency iby_trxn_summaries_all.currencynamecode%TYPE;

Line 34: CURSOR c_currencycodes(ci_mbatch_id IN iby_batches_all.mbatchid%TYPE)

30: l_return_status VARCHAR2(10);
31: l_msg_count NUMBER;
32: l_msg_data VARCHAR2(5000);
33:
34: CURSOR c_currencycodes(ci_mbatch_id IN iby_batches_all.mbatchid%TYPE)
35: IS
36: SELECT ts.currencynamecode
37: FROM iby_batches_all ba, iby_trxn_summaries_all ts
38: WHERE (ba.mbatchid = ci_mbatch_id)

Line 37: FROM iby_batches_all ba, iby_trxn_summaries_all ts

33:
34: CURSOR c_currencycodes(ci_mbatch_id IN iby_batches_all.mbatchid%TYPE)
35: IS
36: SELECT ts.currencynamecode
37: FROM iby_batches_all ba, iby_trxn_summaries_all ts
38: WHERE (ba.mbatchid = ci_mbatch_id)
39: AND (ba.payeeid = ts.payeeid)
40: AND (ba.batchid = ts.batchid)
41: GROUP BY ts.currencynamecode;

Line 69: FROM iby_batches_all ba, iby_trxn_summaries_all ts

65: -- close to continue
66: --
67: SELECT COUNT(transactionid)
68: INTO l_sec_trxn_count
69: FROM iby_batches_all ba, iby_trxn_summaries_all ts
70: WHERE (ba.mbatchid = p_mbatch_id)
71: AND (ba.payeeid = ts.payeeid)
72: AND (ba.batchid = ts.batchid)
73: AND (NOT sub_key_id IS NULL);

Line 84: FROM iby_batches_all ba, iby_trxn_summaries_all ts

80: print_debuginfo('validate_ob', 'p_mbatch_id = ' || p_mbatch_id);
81:
82: SELECT COUNT(transactionid)
83: INTO x_trxn_count
84: FROM iby_batches_all ba, iby_trxn_summaries_all ts
85: WHERE (ba.mbatchid = p_mbatch_id)
86: AND (ba.payeeid = ts.payeeid)
87: AND (ba.batchid = ts.batchid);
88: --

Line 1273: /* Inserts a row about batch status into iby_batches_all. This will */

1269:
1270: END insert_timeout_txn;
1271:
1272:
1273: /* Inserts a row about batch status into iby_batches_all. This will */
1274: /* be called for link error, timeout error or other batch status */
1275:
1276: PROCEDURE insert_batch_status
1277: (merch_batchid_in IN iby_batches_all.batchid%TYPE,

Line 1277: (merch_batchid_in IN iby_batches_all.batchid%TYPE,

1273: /* Inserts a row about batch status into iby_batches_all. This will */
1274: /* be called for link error, timeout error or other batch status */
1275:
1276: PROCEDURE insert_batch_status
1277: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
1278: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1279: vendor_id_in IN iby_batches_all.bepid%TYPE,
1280: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1281: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

Line 1278: merchant_id_in IN iby_batches_all.payeeid%TYPE,

1274: /* be called for link error, timeout error or other batch status */
1275:
1276: PROCEDURE insert_batch_status
1277: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
1278: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1279: vendor_id_in IN iby_batches_all.bepid%TYPE,
1280: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1281: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1282: status_in IN iby_batches_all.batchstatus%TYPE,

Line 1279: vendor_id_in IN iby_batches_all.bepid%TYPE,

1275:
1276: PROCEDURE insert_batch_status
1277: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
1278: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1279: vendor_id_in IN iby_batches_all.bepid%TYPE,
1280: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1281: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1282: status_in IN iby_batches_all.batchstatus%TYPE,
1283: time_in IN iby_batches_all.batchclosedate%TYPE,

Line 1280: vendor_key_in IN iby_batches_all.bepkey%TYPE,

1276: PROCEDURE insert_batch_status
1277: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
1278: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1279: vendor_id_in IN iby_batches_all.bepid%TYPE,
1280: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1281: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1282: status_in IN iby_batches_all.batchstatus%TYPE,
1283: time_in IN iby_batches_all.batchclosedate%TYPE,
1284: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

Line 1281: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

1277: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
1278: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1279: vendor_id_in IN iby_batches_all.bepid%TYPE,
1280: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1281: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1282: status_in IN iby_batches_all.batchstatus%TYPE,
1283: time_in IN iby_batches_all.batchclosedate%TYPE,
1284: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1285: currency_in IN iby_batches_all.currencynamecode%TYPE,

Line 1282: status_in IN iby_batches_all.batchstatus%TYPE,

1278: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1279: vendor_id_in IN iby_batches_all.bepid%TYPE,
1280: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1281: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1282: status_in IN iby_batches_all.batchstatus%TYPE,
1283: time_in IN iby_batches_all.batchclosedate%TYPE,
1284: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1285: currency_in IN iby_batches_all.currencynamecode%TYPE,
1286: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

Line 1283: time_in IN iby_batches_all.batchclosedate%TYPE,

1279: vendor_id_in IN iby_batches_all.bepid%TYPE,
1280: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1281: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1282: status_in IN iby_batches_all.batchstatus%TYPE,
1283: time_in IN iby_batches_all.batchclosedate%TYPE,
1284: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1285: currency_in IN iby_batches_all.currencynamecode%TYPE,
1286: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1287: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

Line 1284: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

1280: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1281: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1282: status_in IN iby_batches_all.batchstatus%TYPE,
1283: time_in IN iby_batches_all.batchclosedate%TYPE,
1284: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1285: currency_in IN iby_batches_all.currencynamecode%TYPE,
1286: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1287: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1288: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

Line 1285: currency_in IN iby_batches_all.currencynamecode%TYPE,

1281: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1282: status_in IN iby_batches_all.batchstatus%TYPE,
1283: time_in IN iby_batches_all.batchclosedate%TYPE,
1284: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1285: currency_in IN iby_batches_all.currencynamecode%TYPE,
1286: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1287: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1288: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1289: saleamount_in IN iby_batches_all.BatchSales%TYPE,

Line 1286: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

1282: status_in IN iby_batches_all.batchstatus%TYPE,
1283: time_in IN iby_batches_all.batchclosedate%TYPE,
1284: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1285: currency_in IN iby_batches_all.currencynamecode%TYPE,
1286: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1287: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1288: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1289: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1290: cramount_in IN iby_batches_all.BatchCredit%TYPE,

Line 1287: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

1283: time_in IN iby_batches_all.batchclosedate%TYPE,
1284: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1285: currency_in IN iby_batches_all.currencynamecode%TYPE,
1286: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1287: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1288: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1289: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1290: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1291: gwid_in IN iby_batches_all.GWBatchID%TYPE,

Line 1288: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

1284: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1285: currency_in IN iby_batches_all.currencynamecode%TYPE,
1286: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1287: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1288: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1289: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1290: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1291: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1292: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

Line 1289: saleamount_in IN iby_batches_all.BatchSales%TYPE,

1285: currency_in IN iby_batches_all.currencynamecode%TYPE,
1286: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1287: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1288: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1289: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1290: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1291: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1292: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1293: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

Line 1290: cramount_in IN iby_batches_all.BatchCredit%TYPE,

1286: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1287: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1288: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1289: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1290: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1291: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1292: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1293: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1294: error_location_in IN iby_batches_all.errorlocation%TYPE,

Line 1291: gwid_in IN iby_batches_all.GWBatchID%TYPE,

1287: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1288: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1289: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1290: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1291: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1292: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1293: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1294: error_location_in IN iby_batches_all.errorlocation%TYPE,
1295: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

Line 1292: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

1288: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1289: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1290: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1291: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1292: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1293: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1294: error_location_in IN iby_batches_all.errorlocation%TYPE,
1295: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1296: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

Line 1293: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

1289: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1290: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1291: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1292: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1293: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1294: error_location_in IN iby_batches_all.errorlocation%TYPE,
1295: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1296: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1297: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 1294: error_location_in IN iby_batches_all.errorlocation%TYPE,

1290: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1291: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1292: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1293: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1294: error_location_in IN iby_batches_all.errorlocation%TYPE,
1295: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1296: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1297: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1298: req_type_in IN iby_batches_all.reqtype%TYPE,

Line 1295: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

1291: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1292: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1293: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1294: error_location_in IN iby_batches_all.errorlocation%TYPE,
1295: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1296: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1297: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1298: req_type_in IN iby_batches_all.reqtype%TYPE,
1299: sec_key_present_in IN VARCHAR2,

Line 1296: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

1292: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1293: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1294: error_location_in IN iby_batches_all.errorlocation%TYPE,
1295: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1296: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1297: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1298: req_type_in IN iby_batches_all.reqtype%TYPE,
1299: sec_key_present_in IN VARCHAR2,
1300: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type

Line 1298: req_type_in IN iby_batches_all.reqtype%TYPE,

1294: error_location_in IN iby_batches_all.errorlocation%TYPE,
1295: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1296: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1297: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1298: req_type_in IN iby_batches_all.reqtype%TYPE,
1299: sec_key_present_in IN VARCHAR2,
1300: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type
1301: )
1302: IS

Line 1300: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type

1296: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1297: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1298: req_type_in IN iby_batches_all.reqtype%TYPE,
1299: sec_key_present_in IN VARCHAR2,
1300: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type
1301: )
1302: IS
1303:
1304: numrows NUMBER;

Line 1306: l_mbatchid iby_batches_all.mbatchid%type;

1302: IS
1303:
1304: numrows NUMBER;
1305: l_mpayeeid iby_payee.mpayeeid%type;
1306: l_mbatchid iby_batches_all.mbatchid%type;
1307: l_beptype iby_bepinfo.bep_type%TYPE;
1308: l_trxncount iby_batches_all.numtrxns%TYPE;
1309: l_batchcurr iby_batches_all.currencynamecode%TYPE;
1310: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';

Line 1308: l_trxncount iby_batches_all.numtrxns%TYPE;

1304: numrows NUMBER;
1305: l_mpayeeid iby_payee.mpayeeid%type;
1306: l_mbatchid iby_batches_all.mbatchid%type;
1307: l_beptype iby_bepinfo.bep_type%TYPE;
1308: l_trxncount iby_batches_all.numtrxns%TYPE;
1309: l_batchcurr iby_batches_all.currencynamecode%TYPE;
1310: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';
1311: BEGIN
1312:

Line 1309: l_batchcurr iby_batches_all.currencynamecode%TYPE;

1305: l_mpayeeid iby_payee.mpayeeid%type;
1306: l_mbatchid iby_batches_all.mbatchid%type;
1307: l_beptype iby_bepinfo.bep_type%TYPE;
1308: l_trxncount iby_batches_all.numtrxns%TYPE;
1309: l_batchcurr iby_batches_all.currencynamecode%TYPE;
1310: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';
1311: BEGIN
1312:
1313: -- First check if a row already exists for this batch status

Line 1317: FROM iby_batches_all

1313: -- First check if a row already exists for this batch status
1314:
1315: SELECT COUNT(*)
1316: INTO numrows
1317: FROM iby_batches_all
1318: WHERE batchid = merch_batchid_in
1319: AND payeeid = merchant_id_in;
1320:
1321: -- insert batch status into iby_batches_all

Line 1321: -- insert batch status into iby_batches_all

1317: FROM iby_batches_all
1318: WHERE batchid = merch_batchid_in
1319: AND payeeid = merchant_id_in;
1320:
1321: -- insert batch status into iby_batches_all
1322:
1323: IF numrows = 0
1324:
1325: THEN

Line 1334: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;

1330: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown
1331: -- to be vulnerable to race conditions even under moderate
1332: -- concurrency loads
1333: --
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;

Line 1391: INSERT INTO iby_batches_all

1387: END IF;
1388:
1389: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
1390:
1391: INSERT INTO iby_batches_all
1392: (MBATCHID, BATCHID, MPAYEEID, PAYEEID, BEPID, BEPKEY, PAYMENTMETHODNAME,
1393: BATCHSTATUS, BATCHCLOSEDATE, VPSBATCHID, CURRENCYNAMECODE,
1394: NUMTRXNS, BATCHSTATEID, BATCHTOTAL, BATCHSALES, BATCHCREDIT,
1395: GWBATCHID, BEPCODE, BEPMESSAGE, ERRORLOCATION,

Line 1411: UPDATE iby_batches_all

1407:
1408: validate_open_batch(vendor_id_in, l_mbatchid, sec_key_present_in,
1409: l_trxncount, l_batchcurr);
1410:
1411: UPDATE iby_batches_all
1412: SET CURRENCYNAMECODE = l_batchcurr,
1413: NUMTRXNS = l_trxncount
1414: WHERE mbatchid = l_mbatchid;
1415:

Line 1423: UPDATE iby_batches_all

1419: IF (l_trxncount<1) THEN
1420: l_trxncount := NULL;
1421: END IF;
1422: -- One previous transaction, so update previous row
1423: UPDATE iby_batches_all
1424: SET PAYMENTMETHODNAME = pmt_type_in,
1425: BATCHSTATUS = status_in,
1426: BATCHCLOSEDATE = time_in,
1427: CURRENCYNAMECODE = NVL(currency_in,CURRENCYNAMECODE),

Line 1453: UPDATE iby_batches_all

1449:
1450: IF ((req_type_in = 'ORAPMTCLOSEBATCH') OR
1451: (req_type_in = 'ORAPMTPDCCLOSEBATCH') ) THEN
1452: -- we don't update the following for querybatch
1453: UPDATE iby_batches_all
1454: SET VPSBATCHID = viby_batchid_in,
1455: reqtype = req_type_in,
1456: reqdate = sysdate
1457: WHERE batchid = merch_batchid_in

Line 1463: FROM iby_batches_all

1459: END IF;
1460:
1461: SELECT mbatchid
1462: INTO mbatchid_out
1463: FROM iby_batches_all
1464: WHERE batchid = merch_batchid_in
1465: AND payeeid = merchant_id_in;
1466:
1467: ELSE

Line 1508: merch_batchid_in IN iby_batches_all.batchid%TYPE,

1504: |
1505: *---------------------------------------------------------------------*/
1506: PROCEDURE insert_batch_status_new
1507: (
1508: merch_batchid_in IN iby_batches_all.batchid%TYPE,
1509: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
1510: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1511: vendor_id_in IN iby_batches_all.bepid%TYPE,
1512: vendor_key_in IN iby_batches_all.bepkey%TYPE,

Line 1509: profile_code_in IN iby_batches_all.process_profile_code%TYPE,

1505: *---------------------------------------------------------------------*/
1506: PROCEDURE insert_batch_status_new
1507: (
1508: merch_batchid_in IN iby_batches_all.batchid%TYPE,
1509: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
1510: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1511: vendor_id_in IN iby_batches_all.bepid%TYPE,
1512: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1513: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

Line 1510: merchant_id_in IN iby_batches_all.payeeid%TYPE,

1506: PROCEDURE insert_batch_status_new
1507: (
1508: merch_batchid_in IN iby_batches_all.batchid%TYPE,
1509: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
1510: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1511: vendor_id_in IN iby_batches_all.bepid%TYPE,
1512: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1513: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1514: status_in IN iby_batches_all.batchstatus%TYPE,

Line 1511: vendor_id_in IN iby_batches_all.bepid%TYPE,

1507: (
1508: merch_batchid_in IN iby_batches_all.batchid%TYPE,
1509: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
1510: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1511: vendor_id_in IN iby_batches_all.bepid%TYPE,
1512: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1513: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1514: status_in IN iby_batches_all.batchstatus%TYPE,
1515: time_in IN iby_batches_all.batchclosedate%TYPE,

Line 1512: vendor_key_in IN iby_batches_all.bepkey%TYPE,

1508: merch_batchid_in IN iby_batches_all.batchid%TYPE,
1509: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
1510: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1511: vendor_id_in IN iby_batches_all.bepid%TYPE,
1512: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1513: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1514: status_in IN iby_batches_all.batchstatus%TYPE,
1515: time_in IN iby_batches_all.batchclosedate%TYPE,
1516: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

Line 1513: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

1509: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
1510: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1511: vendor_id_in IN iby_batches_all.bepid%TYPE,
1512: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1513: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1514: status_in IN iby_batches_all.batchstatus%TYPE,
1515: time_in IN iby_batches_all.batchclosedate%TYPE,
1516: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1517: currency_in IN iby_batches_all.currencynamecode%TYPE,

Line 1514: status_in IN iby_batches_all.batchstatus%TYPE,

1510: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1511: vendor_id_in IN iby_batches_all.bepid%TYPE,
1512: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1513: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1514: status_in IN iby_batches_all.batchstatus%TYPE,
1515: time_in IN iby_batches_all.batchclosedate%TYPE,
1516: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1517: currency_in IN iby_batches_all.currencynamecode%TYPE,
1518: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

Line 1515: time_in IN iby_batches_all.batchclosedate%TYPE,

1511: vendor_id_in IN iby_batches_all.bepid%TYPE,
1512: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1513: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1514: status_in IN iby_batches_all.batchstatus%TYPE,
1515: time_in IN iby_batches_all.batchclosedate%TYPE,
1516: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1517: currency_in IN iby_batches_all.currencynamecode%TYPE,
1518: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1519: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

Line 1516: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

1512: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1513: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1514: status_in IN iby_batches_all.batchstatus%TYPE,
1515: time_in IN iby_batches_all.batchclosedate%TYPE,
1516: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1517: currency_in IN iby_batches_all.currencynamecode%TYPE,
1518: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1519: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1520: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

Line 1517: currency_in IN iby_batches_all.currencynamecode%TYPE,

1513: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1514: status_in IN iby_batches_all.batchstatus%TYPE,
1515: time_in IN iby_batches_all.batchclosedate%TYPE,
1516: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1517: currency_in IN iby_batches_all.currencynamecode%TYPE,
1518: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1519: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1520: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1521: saleamount_in IN iby_batches_all.BatchSales%TYPE,

Line 1518: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

1514: status_in IN iby_batches_all.batchstatus%TYPE,
1515: time_in IN iby_batches_all.batchclosedate%TYPE,
1516: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1517: currency_in IN iby_batches_all.currencynamecode%TYPE,
1518: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1519: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1520: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1521: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1522: cramount_in IN iby_batches_all.BatchCredit%TYPE,

Line 1519: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

1515: time_in IN iby_batches_all.batchclosedate%TYPE,
1516: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1517: currency_in IN iby_batches_all.currencynamecode%TYPE,
1518: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1519: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1520: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1521: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1522: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1523: gwid_in IN iby_batches_all.GWBatchID%TYPE,

Line 1520: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

1516: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1517: currency_in IN iby_batches_all.currencynamecode%TYPE,
1518: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1519: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1520: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1521: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1522: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1523: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1524: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

Line 1521: saleamount_in IN iby_batches_all.BatchSales%TYPE,

1517: currency_in IN iby_batches_all.currencynamecode%TYPE,
1518: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1519: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1520: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1521: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1522: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1523: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1524: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1525: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

Line 1522: cramount_in IN iby_batches_all.BatchCredit%TYPE,

1518: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1519: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1520: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1521: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1522: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1523: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1524: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1525: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1526: error_location_in IN iby_batches_all.errorlocation%TYPE,

Line 1523: gwid_in IN iby_batches_all.GWBatchID%TYPE,

1519: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1520: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1521: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1522: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1523: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1524: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1525: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1526: error_location_in IN iby_batches_all.errorlocation%TYPE,
1527: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

Line 1524: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

1520: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1521: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1522: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1523: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1524: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1525: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1526: error_location_in IN iby_batches_all.errorlocation%TYPE,
1527: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1528: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

Line 1525: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

1521: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1522: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1523: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1524: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1525: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1526: error_location_in IN iby_batches_all.errorlocation%TYPE,
1527: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1528: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1529: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 1526: error_location_in IN iby_batches_all.errorlocation%TYPE,

1522: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1523: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1524: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1525: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1526: error_location_in IN iby_batches_all.errorlocation%TYPE,
1527: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1528: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1529: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1530: req_type_in IN iby_batches_all.reqtype%TYPE,

Line 1527: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

1523: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1524: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1525: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1526: error_location_in IN iby_batches_all.errorlocation%TYPE,
1527: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1528: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1529: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1530: req_type_in IN iby_batches_all.reqtype%TYPE,
1531: sec_key_present_in IN VARCHAR2,

Line 1528: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

1524: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1525: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1526: error_location_in IN iby_batches_all.errorlocation%TYPE,
1527: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1528: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1529: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1530: req_type_in IN iby_batches_all.reqtype%TYPE,
1531: sec_key_present_in IN VARCHAR2,
1532: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

Line 1530: req_type_in IN iby_batches_all.reqtype%TYPE,

1526: error_location_in IN iby_batches_all.errorlocation%TYPE,
1527: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1528: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1529: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1530: req_type_in IN iby_batches_all.reqtype%TYPE,
1531: sec_key_present_in IN VARCHAR2,
1532: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
1533: instr_type_in IN iby_batches_all.instrument_type%TYPE,
1534: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

Line 1532: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

1528: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1529: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1530: req_type_in IN iby_batches_all.reqtype%TYPE,
1531: sec_key_present_in IN VARCHAR2,
1532: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
1533: instr_type_in IN iby_batches_all.instrument_type%TYPE,
1534: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
1535: f_pmt_channel_in IN iby_trxn_summaries_all.
1536: payment_channel_code%TYPE,

Line 1533: instr_type_in IN iby_batches_all.instrument_type%TYPE,

1529: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1530: req_type_in IN iby_batches_all.reqtype%TYPE,
1531: sec_key_present_in IN VARCHAR2,
1532: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
1533: instr_type_in IN iby_batches_all.instrument_type%TYPE,
1534: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
1535: f_pmt_channel_in IN iby_trxn_summaries_all.
1536: payment_channel_code%TYPE,
1537: f_curr_in IN iby_trxn_summaries_all.

Line 1534: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

1530: req_type_in IN iby_batches_all.reqtype%TYPE,
1531: sec_key_present_in IN VARCHAR2,
1532: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
1533: instr_type_in IN iby_batches_all.instrument_type%TYPE,
1534: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
1535: f_pmt_channel_in IN iby_trxn_summaries_all.
1536: payment_channel_code%TYPE,
1537: f_curr_in IN iby_trxn_summaries_all.
1538: currencynamecode%TYPE,

Line 1555: l_mbatchid iby_batches_all.mbatchid%type;

1551:
1552: numrows NUMBER;
1553:
1554: l_mpayeeid iby_payee.mpayeeid%type;
1555: l_mbatchid iby_batches_all.mbatchid%type;
1556: l_beptype iby_bepinfo.bep_type%TYPE;
1557: l_trxncount iby_batches_all.numtrxns%TYPE;
1558: l_batchcurr iby_batches_all.currencynamecode%TYPE;
1559:

Line 1557: l_trxncount iby_batches_all.numtrxns%TYPE;

1553:
1554: l_mpayeeid iby_payee.mpayeeid%type;
1555: l_mbatchid iby_batches_all.mbatchid%type;
1556: l_beptype iby_bepinfo.bep_type%TYPE;
1557: l_trxncount iby_batches_all.numtrxns%TYPE;
1558: l_batchcurr iby_batches_all.currencynamecode%TYPE;
1559:
1560: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';
1561:

Line 1558: l_batchcurr iby_batches_all.currencynamecode%TYPE;

1554: l_mpayeeid iby_payee.mpayeeid%type;
1555: l_mbatchid iby_batches_all.mbatchid%type;
1556: l_beptype iby_bepinfo.bep_type%TYPE;
1557: l_trxncount iby_batches_all.numtrxns%TYPE;
1558: l_batchcurr iby_batches_all.currencynamecode%TYPE;
1559:
1560: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';
1561:
1562: l_batches_tab batchAttrTabType;

Line 1576: CURSOR c_mbatch_ids (batch_id IBY_BATCHES_ALL.batchid%TYPE,

1572: * Cursor to pick up all existing mbatchids for
1573: * a given (batch id, payee id, profile code)
1574: * combination.
1575: */
1576: CURSOR c_mbatch_ids (batch_id IBY_BATCHES_ALL.batchid%TYPE,
1577: payee_id IBY_BATCHES_ALL.payeeid%TYPE,
1578: profile_cd IBY_BATCHES_ALL.process_profile_code%TYPE
1579: )
1580: IS

Line 1577: payee_id IBY_BATCHES_ALL.payeeid%TYPE,

1573: * a given (batch id, payee id, profile code)
1574: * combination.
1575: */
1576: CURSOR c_mbatch_ids (batch_id IBY_BATCHES_ALL.batchid%TYPE,
1577: payee_id IBY_BATCHES_ALL.payeeid%TYPE,
1578: profile_cd IBY_BATCHES_ALL.process_profile_code%TYPE
1579: )
1580: IS
1581: SELECT

Line 1578: profile_cd IBY_BATCHES_ALL.process_profile_code%TYPE

1574: * combination.
1575: */
1576: CURSOR c_mbatch_ids (batch_id IBY_BATCHES_ALL.batchid%TYPE,
1577: payee_id IBY_BATCHES_ALL.payeeid%TYPE,
1578: profile_cd IBY_BATCHES_ALL.process_profile_code%TYPE
1579: )
1580: IS
1581: SELECT
1582: mbatchid

Line 1584: IBY_BATCHES_ALL

1580: IS
1581: SELECT
1582: mbatchid
1583: FROM
1584: IBY_BATCHES_ALL
1585: WHERE
1586: batchid = batch_id AND
1587: payeeid = payee_id AND
1588: process_profile_code = profile_cd

Line 1604: IBY_BATCHES_ALL

1600: COUNT(*)
1601: INTO
1602: numrows
1603: FROM
1604: IBY_BATCHES_ALL
1605: WHERE
1606: batchid = merch_batchid_in AND
1607: payeeid = merchant_id_in
1608: ;

Line 1611: * If row does not exist, then insert batch status into iby_batches_all

1607: payeeid = merchant_id_in
1608: ;
1609:
1610: /*
1611: * If row does not exist, then insert batch status into iby_batches_all
1612: */
1613: IF numrows = 0 THEN
1614:
1615: print_debuginfo(l_module_name, 'num rows is zero');

Line 1625: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;

1621: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown
1622: -- to be vulnerable to race conditions even under moderate
1623: -- concurrency loads
1624: --
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;

Line 1688: * IBY_BATCHES_ALL table with a unique mbatchid.

1684:
1685: /*
1686: * After grouping it is possible that multiple batches were
1687: * created. Each batch will be a separate row in the
1688: * IBY_BATCHES_ALL table with a unique mbatchid.
1689: *
1690: * The user may have provided a batch id (batch prefix), we will
1691: * have to assign that batch id to each of the created batches.
1692: *

Line 1852: iby_batches_all

1848: print_debuginfo(l_module_name, 'Going to insert batch '
1849: || l_batches_tab(i).mbatch_id);
1850:
1851: INSERT INTO
1852: iby_batches_all
1853: (
1854: MBATCHID,
1855: BATCHID,
1856: MPAYEEID,

Line 1948: IBY_BATCHES_ALL

1944: l_trxncount,
1945: l_batchcurr);
1946:
1947: UPDATE
1948: IBY_BATCHES_ALL
1949: SET
1950: currencynamecode = l_batchcurr,
1951: numtrxns = l_trxncount
1952: WHERE

Line 1984: IBY_BATCHES_ALL

1980: END IF;
1981:
1982: /* One previous transaction, so update previous row */
1983: UPDATE
1984: IBY_BATCHES_ALL
1985: SET
1986: PAYMENTMETHODNAME = pmt_type_in,
1987: BATCHSTATUS = status_in,
1988: BATCHCLOSEDATE = time_in,

Line 2018: iby_batches_all

2014: (req_type_in = 'ORAPMTPDCCLOSEBATCH') ) THEN
2015:
2016: -- we don't update the following for querybatch
2017: UPDATE
2018: iby_batches_all
2019: SET
2020: VPSBATCHID = viby_batchid_in,
2021: reqtype = req_type_in,
2022: reqdate = sysdate

Line 2031: --FROM iby_batches_all

2027: END IF;
2028:
2029: --SELECT mbatchid
2030: --INTO mbatchid_out
2031: --FROM iby_batches_all
2032: --WHERE batchid = merch_batchid_in
2033: --AND payeeid = merchant_id_in;
2034:
2035: /*

Line 2119: merch_batchid_in IN iby_batches_all.batchid%TYPE,

2115: |
2116: *---------------------------------------------------------------------*/
2117: PROCEDURE insert_batch_status_new
2118: (
2119: merch_batchid_in IN iby_batches_all.batchid%TYPE,
2120: profile_code_array IN JTF_VARCHAR2_TABLE_100,
2121: merchant_id_in IN iby_batches_all.payeeid%TYPE,
2122: vendor_id_in IN iby_batches_all.bepid%TYPE,
2123: vendor_key_in IN iby_batches_all.bepkey%TYPE,

Line 2121: merchant_id_in IN iby_batches_all.payeeid%TYPE,

2117: PROCEDURE insert_batch_status_new
2118: (
2119: merch_batchid_in IN iby_batches_all.batchid%TYPE,
2120: profile_code_array IN JTF_VARCHAR2_TABLE_100,
2121: merchant_id_in IN iby_batches_all.payeeid%TYPE,
2122: vendor_id_in IN iby_batches_all.bepid%TYPE,
2123: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2124: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2125: status_in IN iby_batches_all.batchstatus%TYPE,

Line 2122: vendor_id_in IN iby_batches_all.bepid%TYPE,

2118: (
2119: merch_batchid_in IN iby_batches_all.batchid%TYPE,
2120: profile_code_array IN JTF_VARCHAR2_TABLE_100,
2121: merchant_id_in IN iby_batches_all.payeeid%TYPE,
2122: vendor_id_in IN iby_batches_all.bepid%TYPE,
2123: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2124: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2125: status_in IN iby_batches_all.batchstatus%TYPE,
2126: time_in IN iby_batches_all.batchclosedate%TYPE,

Line 2123: vendor_key_in IN iby_batches_all.bepkey%TYPE,

2119: merch_batchid_in IN iby_batches_all.batchid%TYPE,
2120: profile_code_array IN JTF_VARCHAR2_TABLE_100,
2121: merchant_id_in IN iby_batches_all.payeeid%TYPE,
2122: vendor_id_in IN iby_batches_all.bepid%TYPE,
2123: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2124: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2125: status_in IN iby_batches_all.batchstatus%TYPE,
2126: time_in IN iby_batches_all.batchclosedate%TYPE,
2127: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

Line 2124: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

2120: profile_code_array IN JTF_VARCHAR2_TABLE_100,
2121: merchant_id_in IN iby_batches_all.payeeid%TYPE,
2122: vendor_id_in IN iby_batches_all.bepid%TYPE,
2123: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2124: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2125: status_in IN iby_batches_all.batchstatus%TYPE,
2126: time_in IN iby_batches_all.batchclosedate%TYPE,
2127: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2128: currency_in IN iby_batches_all.currencynamecode%TYPE,

Line 2125: status_in IN iby_batches_all.batchstatus%TYPE,

2121: merchant_id_in IN iby_batches_all.payeeid%TYPE,
2122: vendor_id_in IN iby_batches_all.bepid%TYPE,
2123: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2124: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2125: status_in IN iby_batches_all.batchstatus%TYPE,
2126: time_in IN iby_batches_all.batchclosedate%TYPE,
2127: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2128: currency_in IN iby_batches_all.currencynamecode%TYPE,
2129: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

Line 2126: time_in IN iby_batches_all.batchclosedate%TYPE,

2122: vendor_id_in IN iby_batches_all.bepid%TYPE,
2123: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2124: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2125: status_in IN iby_batches_all.batchstatus%TYPE,
2126: time_in IN iby_batches_all.batchclosedate%TYPE,
2127: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2128: currency_in IN iby_batches_all.currencynamecode%TYPE,
2129: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2130: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

Line 2127: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

2123: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2124: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2125: status_in IN iby_batches_all.batchstatus%TYPE,
2126: time_in IN iby_batches_all.batchclosedate%TYPE,
2127: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2128: currency_in IN iby_batches_all.currencynamecode%TYPE,
2129: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2130: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2131: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

Line 2128: currency_in IN iby_batches_all.currencynamecode%TYPE,

2124: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2125: status_in IN iby_batches_all.batchstatus%TYPE,
2126: time_in IN iby_batches_all.batchclosedate%TYPE,
2127: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2128: currency_in IN iby_batches_all.currencynamecode%TYPE,
2129: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2130: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2131: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2132: saleamount_in IN iby_batches_all.BatchSales%TYPE,

Line 2129: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

2125: status_in IN iby_batches_all.batchstatus%TYPE,
2126: time_in IN iby_batches_all.batchclosedate%TYPE,
2127: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2128: currency_in IN iby_batches_all.currencynamecode%TYPE,
2129: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2130: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2131: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2132: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2133: cramount_in IN iby_batches_all.BatchCredit%TYPE,

Line 2130: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

2126: time_in IN iby_batches_all.batchclosedate%TYPE,
2127: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2128: currency_in IN iby_batches_all.currencynamecode%TYPE,
2129: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2130: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2131: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2132: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2133: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2134: gwid_in IN iby_batches_all.GWBatchID%TYPE,

Line 2131: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

2127: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2128: currency_in IN iby_batches_all.currencynamecode%TYPE,
2129: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2130: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2131: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2132: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2133: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2134: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2135: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

Line 2132: saleamount_in IN iby_batches_all.BatchSales%TYPE,

2128: currency_in IN iby_batches_all.currencynamecode%TYPE,
2129: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2130: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2131: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2132: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2133: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2134: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2135: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2136: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

Line 2133: cramount_in IN iby_batches_all.BatchCredit%TYPE,

2129: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2130: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2131: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2132: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2133: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2134: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2135: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2136: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2137: error_location_in IN iby_batches_all.errorlocation%TYPE,

Line 2134: gwid_in IN iby_batches_all.GWBatchID%TYPE,

2130: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2131: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2132: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2133: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2134: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2135: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2136: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2137: error_location_in IN iby_batches_all.errorlocation%TYPE,
2138: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

Line 2135: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

2131: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2132: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2133: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2134: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2135: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2136: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2137: error_location_in IN iby_batches_all.errorlocation%TYPE,
2138: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
2139: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

Line 2136: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

2132: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2133: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2134: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2135: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2136: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2137: error_location_in IN iby_batches_all.errorlocation%TYPE,
2138: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
2139: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
2140: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 2137: error_location_in IN iby_batches_all.errorlocation%TYPE,

2133: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2134: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2135: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2136: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2137: error_location_in IN iby_batches_all.errorlocation%TYPE,
2138: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
2139: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
2140: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
2141: req_type_in IN iby_batches_all.reqtype%TYPE,

Line 2138: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

2134: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2135: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2136: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2137: error_location_in IN iby_batches_all.errorlocation%TYPE,
2138: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
2139: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
2140: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
2141: req_type_in IN iby_batches_all.reqtype%TYPE,
2142: sec_key_present_in IN VARCHAR2,

Line 2139: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

2135: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2136: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2137: error_location_in IN iby_batches_all.errorlocation%TYPE,
2138: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
2139: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
2140: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
2141: req_type_in IN iby_batches_all.reqtype%TYPE,
2142: sec_key_present_in IN VARCHAR2,
2143: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

Line 2141: req_type_in IN iby_batches_all.reqtype%TYPE,

2137: error_location_in IN iby_batches_all.errorlocation%TYPE,
2138: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
2139: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
2140: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
2141: req_type_in IN iby_batches_all.reqtype%TYPE,
2142: sec_key_present_in IN VARCHAR2,
2143: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
2144: instr_type_in IN iby_batches_all.instrument_type%TYPE,
2145: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

Line 2143: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

2139: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
2140: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
2141: req_type_in IN iby_batches_all.reqtype%TYPE,
2142: sec_key_present_in IN VARCHAR2,
2143: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
2144: instr_type_in IN iby_batches_all.instrument_type%TYPE,
2145: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
2146: f_pmt_channel_in IN iby_trxn_summaries_all.
2147: payment_channel_code%TYPE,

Line 2144: instr_type_in IN iby_batches_all.instrument_type%TYPE,

2140: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
2141: req_type_in IN iby_batches_all.reqtype%TYPE,
2142: sec_key_present_in IN VARCHAR2,
2143: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
2144: instr_type_in IN iby_batches_all.instrument_type%TYPE,
2145: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
2146: f_pmt_channel_in IN iby_trxn_summaries_all.
2147: payment_channel_code%TYPE,
2148: f_curr_in IN iby_trxn_summaries_all.

Line 2145: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

2141: req_type_in IN iby_batches_all.reqtype%TYPE,
2142: sec_key_present_in IN VARCHAR2,
2143: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
2144: instr_type_in IN iby_batches_all.instrument_type%TYPE,
2145: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
2146: f_pmt_channel_in IN iby_trxn_summaries_all.
2147: payment_channel_code%TYPE,
2148: f_curr_in IN iby_trxn_summaries_all.
2149: currencynamecode%TYPE,

Line 2166: l_mbatchid iby_batches_all.mbatchid%type;

2162:
2163: numrows NUMBER;
2164:
2165: l_mpayeeid iby_payee.mpayeeid%type;
2166: l_mbatchid iby_batches_all.mbatchid%type;
2167: l_beptype iby_bepinfo.bep_type%TYPE;
2168: l_trxncount iby_batches_all.numtrxns%TYPE;
2169: l_batchcurr iby_batches_all.currencynamecode%TYPE;
2170: -- profile_code_in iby_batches_all.process_profile_code%TYPE;

Line 2168: l_trxncount iby_batches_all.numtrxns%TYPE;

2164:
2165: l_mpayeeid iby_payee.mpayeeid%type;
2166: l_mbatchid iby_batches_all.mbatchid%type;
2167: l_beptype iby_bepinfo.bep_type%TYPE;
2168: l_trxncount iby_batches_all.numtrxns%TYPE;
2169: l_batchcurr iby_batches_all.currencynamecode%TYPE;
2170: -- profile_code_in iby_batches_all.process_profile_code%TYPE;
2171: numProfiles NUMBER;
2172: strProfCodes VARCHAR2(200);

Line 2169: l_batchcurr iby_batches_all.currencynamecode%TYPE;

2165: l_mpayeeid iby_payee.mpayeeid%type;
2166: l_mbatchid iby_batches_all.mbatchid%type;
2167: l_beptype iby_bepinfo.bep_type%TYPE;
2168: l_trxncount iby_batches_all.numtrxns%TYPE;
2169: l_batchcurr iby_batches_all.currencynamecode%TYPE;
2170: -- profile_code_in iby_batches_all.process_profile_code%TYPE;
2171: numProfiles NUMBER;
2172: strProfCodes VARCHAR2(200);
2173:

Line 2170: -- profile_code_in iby_batches_all.process_profile_code%TYPE;

2166: l_mbatchid iby_batches_all.mbatchid%type;
2167: l_beptype iby_bepinfo.bep_type%TYPE;
2168: l_trxncount iby_batches_all.numtrxns%TYPE;
2169: l_batchcurr iby_batches_all.currencynamecode%TYPE;
2170: -- profile_code_in iby_batches_all.process_profile_code%TYPE;
2171: numProfiles NUMBER;
2172: strProfCodes VARCHAR2(200);
2173:
2174: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';

Line 2194: -- CURSOR c_mbatch_ids (batch_id IBY_BATCHES_ALL.batchid%TYPE,

2190: * Cursor to pick up all existing mbatchids for
2191: * a given (batch id, payee id, profile code)
2192: * combination.
2193: */
2194: -- CURSOR c_mbatch_ids (batch_id IBY_BATCHES_ALL.batchid%TYPE,
2195: -- payee_id IBY_BATCHES_ALL.payeeid%TYPE,
2196: -- strProfiles VARCHAR2
2197: -- )
2198: -- IS

Line 2195: -- payee_id IBY_BATCHES_ALL.payeeid%TYPE,

2191: * a given (batch id, payee id, profile code)
2192: * combination.
2193: */
2194: -- CURSOR c_mbatch_ids (batch_id IBY_BATCHES_ALL.batchid%TYPE,
2195: -- payee_id IBY_BATCHES_ALL.payeeid%TYPE,
2196: -- strProfiles VARCHAR2
2197: -- )
2198: -- IS
2199: -- SELECT

Line 2202: -- IBY_BATCHES_ALL

2198: -- IS
2199: -- SELECT
2200: -- mbatchid
2201: -- FROM
2202: -- IBY_BATCHES_ALL
2203: -- WHERE
2204: -- batchid = batch_id AND
2205: -- payeeid = payee_id AND
2206: -- process_profile_code IN (strProfiles)

Line 2231: ' IBY_BATCHES_ALL WHERE '||

2227: * all existing mbatchids for a given (batchid,payeeid and
2228: * a string of profile codes)
2229: */
2230: l_cursor_stmt := ' SELECT mbatchid FROM '||
2231: ' IBY_BATCHES_ALL WHERE '||
2232: ' batchid = '''||merch_batchid_in||''' AND '||
2233: ' payeeid = '''||merchant_id_in||''' AND '||
2234: ' process_profile_code IN ('||strProfCodes||') '
2235: ;

Line 2244: IBY_BATCHES_ALL

2240: COUNT(*)
2241: INTO
2242: numrows
2243: FROM
2244: IBY_BATCHES_ALL
2245: WHERE
2246: batchid = merch_batchid_in AND
2247: payeeid = merchant_id_in
2248: ;

Line 2251: * If row does not exist, then insert batch status into iby_batches_all

2247: payeeid = merchant_id_in
2248: ;
2249:
2250: /*
2251: * If row does not exist, then insert batch status into iby_batches_all
2252: */
2253: IF numrows = 0 THEN
2254:
2255: print_debuginfo(l_module_name, 'num rows is zero');

Line 2265: LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;

2261: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown
2262: -- to be vulnerable to race conditions even under moderate
2263: -- concurrency loads
2264: --
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;

Line 2328: * IBY_BATCHES_ALL table with a unique mbatchid.

2324:
2325: /*
2326: * After grouping it is possible that multiple batches were
2327: * created. Each batch will be a separate row in the
2328: * IBY_BATCHES_ALL table with a unique mbatchid.
2329: *
2330: * The user may have provided a batch id (batch prefix), we will
2331: * have to assign that batch id to each of the created batches.
2332: *

Line 2493: iby_batches_all

2489: print_debuginfo(l_module_name, 'Going to insert batch '
2490: || l_batches_tab(i).mbatch_id);
2491:
2492: INSERT INTO
2493: iby_batches_all
2494: (
2495: MBATCHID,
2496: BATCHID,
2497: MPAYEEID,

Line 2590: IBY_BATCHES_ALL

2586: l_trxncount,
2587: l_batchcurr);
2588:
2589: UPDATE
2590: IBY_BATCHES_ALL
2591: SET
2592: currencynamecode = l_batchcurr,-- should be made NULL
2593: numtrxns = l_trxncount
2594: WHERE

Line 2626: IBY_BATCHES_ALL

2622: END IF;
2623:
2624: /* One previous transaction, so update previous row */
2625: UPDATE
2626: IBY_BATCHES_ALL
2627: SET
2628: PAYMENTMETHODNAME = pmt_type_in,
2629: BATCHSTATUS = status_in,
2630: BATCHCLOSEDATE = time_in,

Line 2660: iby_batches_all

2656: (req_type_in = 'ORAPMTPDCCLOSEBATCH') ) THEN
2657:
2658: -- we don't update the following for querybatch
2659: UPDATE
2660: iby_batches_all
2661: SET
2662: VPSBATCHID = viby_batchid_in,
2663: reqtype = req_type_in,
2664: reqdate = sysdate

Line 2673: --FROM iby_batches_all

2669: END IF;
2670:
2671: --SELECT mbatchid
2672: --INTO mbatchid_out
2673: --FROM iby_batches_all
2674: --WHERE batchid = merch_batchid_in
2675: --AND payeeid = merchant_id_in;
2676:
2677: /*

Line 2766: req_type IN IBY_BATCHES_ALL.

2762: p_profile_code IN IBY_FNDCPT_USER_CC_PF_B.
2763: user_cc_profile_code%TYPE,
2764: instr_type IN IBY_TRXN_SUMMARIES_ALL.
2765: instrtype%TYPE,
2766: req_type IN IBY_BATCHES_ALL.
2767: reqtype%TYPE,
2768: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
2769: payment_channel_code%TYPE,
2770: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.

Line 2810: * IBY_BATCHES_ALL.batchid = user generated batch id

2806:
2807: /*
2808: * NOTE:
2809: *
2810: * IBY_BATCHES_ALL.batchid = user generated batch id
2811: * IBY_BATCHES_ALL.mbatchid = system generated batch id
2812: *
2813: * If batch close is invoked by the user, the batchid will
2814: * be a user defined string (should be unique).

Line 2811: * IBY_BATCHES_ALL.mbatchid = system generated batch id

2807: /*
2808: * NOTE:
2809: *
2810: * IBY_BATCHES_ALL.batchid = user generated batch id
2811: * IBY_BATCHES_ALL.mbatchid = system generated batch id
2812: *
2813: * If batch close is invoked by the user, the batchid will
2814: * be a user defined string (should be unique).
2815: *

Line 2824: l_mbatch_id IBY_BATCHES_ALL.mbatchid%TYPE;

2820: *
2821: * In the new architecture, multiple mbatchids can be generated
2822: * for a single batchid (based on user defined grouping rules).
2823: */
2824: l_mbatch_id IBY_BATCHES_ALL.mbatchid%TYPE;
2825: l_batch_total NUMBER(15) := 0;
2826: l_trxns_in_batch_count NUMBER(15) := 0;
2827:
2828: l_trx_fx_amount NUMBER(15) := 0;

Line 2840: * PLSQL table is used in inserting a row into the IBY_BATCHES_ALL

2836: 'MM/DD/YYYY HH24:MI:SS');
2837:
2838: /*
2839: * These two are related data structures. Each row in batchAttrTabType
2840: * PLSQL table is used in inserting a row into the IBY_BATCHES_ALL
2841: * table.
2842: *
2843: * A separate data structure is needed to keep track of the transactions
2844: * that are part of a batch. This information is tracked in the

Line 2850: * (insert into IBY_BATCHES_ALL) (update IBY_TRXN_SUMMARIES_ALL)

2846: * used to update the rows in IBY_TRXN_SUMMARIES_ALL table with
2847: * batch ids.
2848: *
2849: * l_batchTab l_trxnsInBatchTab
2850: * (insert into IBY_BATCHES_ALL) (update IBY_TRXN_SUMMARIES_ALL)
2851: * /-------------------------------------\ /------------\
2852: * |MBatch |Profile|..|Curr |Org |..| |MBatch |Trx |
2853: * |Id |Code |..|Code |Id |..| |Id |Id |
2854: * | | |..| | |..| | | |

Line 3881: req_type IN IBY_BATCHES_ALL.

3877: PROCEDURE performTransactionGrouping(
3878: profile_code_array IN JTF_VARCHAR2_TABLE_100,
3879: instr_type IN IBY_TRXN_SUMMARIES_ALL.
3880: instrtype%TYPE,
3881: req_type IN IBY_BATCHES_ALL.
3882: reqtype%TYPE,
3883: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
3884: payment_channel_code%TYPE,
3885: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.

Line 3925: * IBY_BATCHES_ALL.batchid = user generated batch id

3921:
3922: /*
3923: * NOTE:
3924: *
3925: * IBY_BATCHES_ALL.batchid = user generated batch id
3926: * IBY_BATCHES_ALL.mbatchid = system generated batch id
3927: *
3928: * If batch close is invoked by the user, the batchid will
3929: * be a user defined string (should be unique).

Line 3926: * IBY_BATCHES_ALL.mbatchid = system generated batch id

3922: /*
3923: * NOTE:
3924: *
3925: * IBY_BATCHES_ALL.batchid = user generated batch id
3926: * IBY_BATCHES_ALL.mbatchid = system generated batch id
3927: *
3928: * If batch close is invoked by the user, the batchid will
3929: * be a user defined string (should be unique).
3930: *

Line 3939: l_mbatch_id IBY_BATCHES_ALL.mbatchid%TYPE;

3935: *
3936: * In the new architecture, multiple mbatchids can be generated
3937: * for a single batchid (based on user defined grouping rules).
3938: */
3939: l_mbatch_id IBY_BATCHES_ALL.mbatchid%TYPE;
3940: l_batch_total NUMBER(15) := 0;
3941: l_trxns_in_batch_count NUMBER(15) := 0;
3942:
3943: l_trx_fx_amount NUMBER(15) := 0;

Line 3955: * PLSQL table is used in inserting a row into the IBY_BATCHES_ALL

3951: 'MM/DD/YYYY HH24:MI:SS');
3952:
3953: /*
3954: * These two are related data structures. Each row in batchAttrTabType
3955: * PLSQL table is used in inserting a row into the IBY_BATCHES_ALL
3956: * table.
3957: *
3958: * A separate data structure is needed to keep track of the transactions
3959: * that are part of a batch. This information is tracked in the

Line 3965: * (insert into IBY_BATCHES_ALL) (update IBY_TRXN_SUMMARIES_ALL)

3961: * used to update the rows in IBY_TRXN_SUMMARIES_ALL table with
3962: * batch ids.
3963: *
3964: * l_batchTab l_trxnsInBatchTab
3965: * (insert into IBY_BATCHES_ALL) (update IBY_TRXN_SUMMARIES_ALL)
3966: * /-------------------------------------\ /------------\
3967: * |MBatch |Profile|..|Curr |Org |..| |MBatch |Trx |
3968: * |Id |Code |..|Code |Id |..| |Id |Id |
3969: * | | |..| | |..| | | |

Line 5023: x_currentBatchId IN OUT NOCOPY IBY_BATCHES_ALL.batchid%TYPE,

5019: PROCEDURE insertTrxnIntoBatch(
5020: x_batchRec IN OUT NOCOPY batchAttrRecType,
5021: x_batchTab IN OUT NOCOPY batchAttrTabType,
5022: p_newBatchFlag IN BOOLEAN,
5023: x_currentBatchId IN OUT NOCOPY IBY_BATCHES_ALL.batchid%TYPE,
5024: x_trxnsInBatchTab IN OUT NOCOPY trxnsInBatchTabType,
5025: x_trxnsInBatchRec IN OUT NOCOPY trxnsInBatchRecType,
5026: x_trxnsInBatchCount IN OUT NOCOPY NUMBER
5027: )

Line 5273: x_batchID IN OUT NOCOPY IBY_BATCHES_ALL.batchid%TYPE

5269: | NOTES:
5270: |
5271: *---------------------------------------------------------------------*/
5272: PROCEDURE getNextBatchId(
5273: x_batchID IN OUT NOCOPY IBY_BATCHES_ALL.batchid%TYPE
5274: )
5275: IS
5276:
5277: BEGIN

Line 5405: l_mbatchid iby_batches_all.mbatchid%type;

5401: l_trxn_mid NUMBER;
5402: transaction_id NUMBER;
5403:
5404: l_mpayeeid iby_payee.mpayeeid%type;
5405: l_mbatchid iby_batches_all.mbatchid%type;
5406: l_mtangibleid iby_tangible.mtangibleid%type;
5407:
5408: l_prev_trxn_count number;
5409: l_reqtype iby_trxn_summaries_all.reqtype%type;

Line 5789: -- stored yet in IBY_BATCHES_ALL ; this can happen when we

5785: BEGIN
5786: getMBatchId(oldbatchid_in, payeeid_in, l_mbatchid);
5787: --
5788: -- catch exception in the case where the batch id has not been
5789: -- stored yet in IBY_BATCHES_ALL ; this can happen when we
5790: -- want to change the status of transitional trxns
5791: --
5792: EXCEPTION WHEN others THEN
5793: l_mbatchid := NULL;

Line 5941: ecapp_id_in IN iby_batches_all.ecappid%TYPE,

5937: END updateBatchQueryTrxn;
5938:
5939: PROCEDURE Update_Batch
5940: (
5941: ecapp_id_in IN iby_batches_all.ecappid%TYPE,
5942: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5943: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5944: batch_status_in IN iby_batches_all.batchstatus%TYPE,
5945: batch_total_in IN iby_batches_all.batchtotal%TYPE,

Line 5944: batch_status_in IN iby_batches_all.batchstatus%TYPE,

5940: (
5941: ecapp_id_in IN iby_batches_all.ecappid%TYPE,
5942: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5943: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5944: batch_status_in IN iby_batches_all.batchstatus%TYPE,
5945: batch_total_in IN iby_batches_all.batchtotal%TYPE,
5946: sale_amount_in IN iby_batches_all.batchsales%TYPE,
5947: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
5948: bep_code_in IN iby_batches_all.bepcode%TYPE,

Line 5945: batch_total_in IN iby_batches_all.batchtotal%TYPE,

5941: ecapp_id_in IN iby_batches_all.ecappid%TYPE,
5942: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5943: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5944: batch_status_in IN iby_batches_all.batchstatus%TYPE,
5945: batch_total_in IN iby_batches_all.batchtotal%TYPE,
5946: sale_amount_in IN iby_batches_all.batchsales%TYPE,
5947: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
5948: bep_code_in IN iby_batches_all.bepcode%TYPE,
5949: bep_message_in IN iby_batches_all.bepmessage%TYPE,

Line 5946: sale_amount_in IN iby_batches_all.batchsales%TYPE,

5942: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
5943: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5944: batch_status_in IN iby_batches_all.batchstatus%TYPE,
5945: batch_total_in IN iby_batches_all.batchtotal%TYPE,
5946: sale_amount_in IN iby_batches_all.batchsales%TYPE,
5947: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
5948: bep_code_in IN iby_batches_all.bepcode%TYPE,
5949: bep_message_in IN iby_batches_all.bepmessage%TYPE,
5950: error_location_in IN iby_batches_all.errorlocation%TYPE,

Line 5947: credit_amount_in IN iby_batches_all.batchcredit%TYPE,

5943: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
5944: batch_status_in IN iby_batches_all.batchstatus%TYPE,
5945: batch_total_in IN iby_batches_all.batchtotal%TYPE,
5946: sale_amount_in IN iby_batches_all.batchsales%TYPE,
5947: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
5948: bep_code_in IN iby_batches_all.bepcode%TYPE,
5949: bep_message_in IN iby_batches_all.bepmessage%TYPE,
5950: error_location_in IN iby_batches_all.errorlocation%TYPE,
5951: ack_type_in IN VARCHAR2,

Line 5948: bep_code_in IN iby_batches_all.bepcode%TYPE,

5944: batch_status_in IN iby_batches_all.batchstatus%TYPE,
5945: batch_total_in IN iby_batches_all.batchtotal%TYPE,
5946: sale_amount_in IN iby_batches_all.batchsales%TYPE,
5947: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
5948: bep_code_in IN iby_batches_all.bepcode%TYPE,
5949: bep_message_in IN iby_batches_all.bepmessage%TYPE,
5950: error_location_in IN iby_batches_all.errorlocation%TYPE,
5951: ack_type_in IN VARCHAR2,
5952: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,

Line 5949: bep_message_in IN iby_batches_all.bepmessage%TYPE,

5945: batch_total_in IN iby_batches_all.batchtotal%TYPE,
5946: sale_amount_in IN iby_batches_all.batchsales%TYPE,
5947: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
5948: bep_code_in IN iby_batches_all.bepcode%TYPE,
5949: bep_message_in IN iby_batches_all.bepmessage%TYPE,
5950: error_location_in IN iby_batches_all.errorlocation%TYPE,
5951: ack_type_in IN VARCHAR2,
5952: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
5953: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,

Line 5950: error_location_in IN iby_batches_all.errorlocation%TYPE,

5946: sale_amount_in IN iby_batches_all.batchsales%TYPE,
5947: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
5948: bep_code_in IN iby_batches_all.bepcode%TYPE,
5949: bep_message_in IN iby_batches_all.bepmessage%TYPE,
5950: error_location_in IN iby_batches_all.errorlocation%TYPE,
5951: ack_type_in IN VARCHAR2,
5952: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
5953: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
5954: trxn_status_in IN JTF_VARCHAR2_TABLE_100,

Line 6000: UPDATE iby_batches_all

5996:
5997: IF (c_tmid%ISOPEN) THEN CLOSE c_tmid; END IF;
5998: IF (c_tracenumber%ISOPEN) THEN CLOSE c_tracenumber; END IF;
5999:
6000: UPDATE iby_batches_all
6001: SET batchstatus = batch_status_in,
6002: batchtotal = batch_total_in,
6003: batchsales = sale_amount_in,
6004: batchcredit = credit_amount_in,

Line 6108: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,

6104: ** Purpose: retrieve mBatchid from iby_Batch table based on Batchid
6105: */
6106:
6107:
6108: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,
6109: i_Payeeid in iby_Batches_all.Payeeid%type,
6110: o_mBatchid out nocopy iby_Batches_all.mBatchid%type)
6111: is
6112: cursor c_get_mBatchid(ci_Batchid iby_Batches_All.Batchid%type,

Line 6109: i_Payeeid in iby_Batches_all.Payeeid%type,

6105: */
6106:
6107:
6108: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,
6109: i_Payeeid in iby_Batches_all.Payeeid%type,
6110: o_mBatchid out nocopy iby_Batches_all.mBatchid%type)
6111: is
6112: cursor c_get_mBatchid(ci_Batchid iby_Batches_All.Batchid%type,
6113: ci_PayeeId iby_batches_all.PayeeID%type)

Line 6110: o_mBatchid out nocopy iby_Batches_all.mBatchid%type)

6106:
6107:
6108: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,
6109: i_Payeeid in iby_Batches_all.Payeeid%type,
6110: o_mBatchid out nocopy iby_Batches_all.mBatchid%type)
6111: is
6112: cursor c_get_mBatchid(ci_Batchid iby_Batches_All.Batchid%type,
6113: ci_PayeeId iby_batches_all.PayeeID%type)
6114: is

Line 6112: cursor c_get_mBatchid(ci_Batchid iby_Batches_All.Batchid%type,

6108: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,
6109: i_Payeeid in iby_Batches_all.Payeeid%type,
6110: o_mBatchid out nocopy iby_Batches_all.mBatchid%type)
6111: is
6112: cursor c_get_mBatchid(ci_Batchid iby_Batches_All.Batchid%type,
6113: ci_PayeeId iby_batches_all.PayeeID%type)
6114: is
6115: SELECT mBatchid from iby_Batches_All
6116: WHERE Batchid = ci_Batchid

Line 6113: ci_PayeeId iby_batches_all.PayeeID%type)

6109: i_Payeeid in iby_Batches_all.Payeeid%type,
6110: o_mBatchid out nocopy iby_Batches_all.mBatchid%type)
6111: is
6112: cursor c_get_mBatchid(ci_Batchid iby_Batches_All.Batchid%type,
6113: ci_PayeeId iby_batches_all.PayeeID%type)
6114: is
6115: SELECT mBatchid from iby_Batches_All
6116: WHERE Batchid = ci_Batchid
6117: AND PayeeID = ci_PayeeID;

Line 6115: SELECT mBatchid from iby_Batches_All

6111: is
6112: cursor c_get_mBatchid(ci_Batchid iby_Batches_All.Batchid%type,
6113: ci_PayeeId iby_batches_all.PayeeID%type)
6114: is
6115: SELECT mBatchid from iby_Batches_All
6116: WHERE Batchid = ci_Batchid
6117: AND PayeeID = ci_PayeeID;
6118: BEGIN
6119:

Line 6773: orgid_in IN iby_batches_all.org_id%TYPE,

6769: ecappid_in IN iby_trxn_summaries_all.ecappid%TYPE,
6770: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
6771: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
6772: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
6773: orgid_in IN iby_batches_all.org_id%TYPE,
6774: seckey_present_in IN VARCHAR2,
6775: trxncount_out OUT NOCOPY NUMBER,
6776: batchid_out OUT NOCOPY iby_batches_all.batchid%TYPE
6777: )

Line 6776: batchid_out OUT NOCOPY iby_batches_all.batchid%TYPE

6772: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
6773: orgid_in IN iby_batches_all.org_id%TYPE,
6774: seckey_present_in IN VARCHAR2,
6775: trxncount_out OUT NOCOPY NUMBER,
6776: batchid_out OUT NOCOPY iby_batches_all.batchid%TYPE
6777: )
6778: IS
6779:
6780: l_max_batch_size iby_bepinfo.max_batch_size%TYPE;

Line 6781: l_mbatch_id iby_batches_all.mbatchid%TYPE;

6777: )
6778: IS
6779:
6780: l_max_batch_size iby_bepinfo.max_batch_size%TYPE;
6781: l_mbatch_id iby_batches_all.mbatchid%TYPE;
6782:
6783: CURSOR c_trxn_count
6784: (
6785: ci_ecappid iby_trxn_summaries_all.ecappid%TYPE,

Line 6848: -- threads; lock both tables (even though iby_batches_all

6844: IF (l_max_batch_size<=trxncount_out) THEN
6845: --
6846: -- lock required to ensure only 1 batch close occurs after
6847: -- the maximum size is surpassed among all competing concurrent
6848: -- threads; lock both tables (even though iby_batches_all
6849: -- is sufficient) so as to ensure no deadlock can happen
6850: -- later
6851: --
6852: LOCK TABLE iby_batches_all, iby_trxn_summaries_all

Line 6852: LOCK TABLE iby_batches_all, iby_trxn_summaries_all

6848: -- threads; lock both tables (even though iby_batches_all
6849: -- is sufficient) so as to ensure no deadlock can happen
6850: -- later
6851: --
6852: LOCK TABLE iby_batches_all, iby_trxn_summaries_all
6853: IN EXCLUSIVE MODE;
6854:
6855: -- check batch size once more to ensure another thread has
6856: -- not closed it between the last check and possession of

Line 6944: mbatchid_in IN iby_batches_all.mbatchid%TYPE

6940: | NOTES:
6941: |
6942: *---------------------------------------------------------------------*/
6943: PROCEDURE Update_Payer_Notif_Batch(
6944: mbatchid_in IN iby_batches_all.mbatchid%TYPE
6945: ) IS
6946:
6947: l_process_profile iby_batches_all.process_profile_code%TYPE;
6948: l_payer_notif_flag VARCHAR2(1);

Line 6947: l_process_profile iby_batches_all.process_profile_code%TYPE;

6943: PROCEDURE Update_Payer_Notif_Batch(
6944: mbatchid_in IN iby_batches_all.mbatchid%TYPE
6945: ) IS
6946:
6947: l_process_profile iby_batches_all.process_profile_code%TYPE;
6948: l_payer_notif_flag VARCHAR2(1);
6949: l_instrument_type iby_batches_all.instrument_type%TYPE;
6950:
6951:

Line 6949: l_instrument_type iby_batches_all.instrument_type%TYPE;

6945: ) IS
6946:
6947: l_process_profile iby_batches_all.process_profile_code%TYPE;
6948: l_payer_notif_flag VARCHAR2(1);
6949: l_instrument_type iby_batches_all.instrument_type%TYPE;
6950:
6951:
6952: CURSOR c_payer_notif_cc (c_user_profile iby_fndcpt_user_cc_pf_b.user_cc_profile_code%TYPE) IS
6953: SELECT DECODE(payer_notification_format, null, 'N', 'Y')

Line 6961: iby_batches_all b

6957:
6958: CURSOR c_payer_notif_dc (c_user_profile iby_fndcpt_user_dc_pf_b.user_dc_profile_code%TYPE) IS
6959: SELECT DECODE(payer_notification_format, null, 'N', 'Y')
6960: FROM iby_fndcpt_user_dc_pf_b up, iby_fndcpt_sys_dc_pf_b sp,
6961: iby_batches_all b
6962: WHERE up.sys_dc_profile_code = sp.sys_dc_profile_code
6963: AND up.user_dc_profile_code =c_user_profile;
6964:
6965: CURSOR c_payer_notif_eft (c_user_profile iby_fndcpt_user_eft_pf_b.user_eft_profile_code%TYPE) IS

Line 6968: iby_batches_all b

6964:
6965: CURSOR c_payer_notif_eft (c_user_profile iby_fndcpt_user_eft_pf_b.user_eft_profile_code%TYPE) IS
6966: SELECT DECODE(payer_notification_format, null, 'N', 'Y')
6967: FROM iby_fndcpt_user_eft_pf_b up, iby_fndcpt_sys_eft_pf_b sp,
6968: iby_batches_all b
6969: WHERE up.sys_eft_profile_code = sp.sys_eft_profile_code
6970: AND up.user_eft_profile_code = c_user_profile;
6971:
6972: CURSOR c_instr_type(i_mbatchid iby_batches_all.mbatchid%TYPE) IS

Line 6972: CURSOR c_instr_type(i_mbatchid iby_batches_all.mbatchid%TYPE) IS

6968: iby_batches_all b
6969: WHERE up.sys_eft_profile_code = sp.sys_eft_profile_code
6970: AND up.user_eft_profile_code = c_user_profile;
6971:
6972: CURSOR c_instr_type(i_mbatchid iby_batches_all.mbatchid%TYPE) IS
6973: SELECT instrument_type, process_profile_code
6974: FROM iby_batches_all
6975: WHERE mbatchid = i_mbatchid;
6976:

Line 6974: FROM iby_batches_all

6970: AND up.user_eft_profile_code = c_user_profile;
6971:
6972: CURSOR c_instr_type(i_mbatchid iby_batches_all.mbatchid%TYPE) IS
6973: SELECT instrument_type, process_profile_code
6974: FROM iby_batches_all
6975: WHERE mbatchid = i_mbatchid;
6976:
6977: BEGIN
6978:

Line 7011: UPDATE iby_batches_all

7007: -- set the payer_notification_required flag to yes
7008: -- if the payer_notification_format is defined for the FCPP
7009: -- at batch and trxn level and if the batch is successfull.
7010: -- Only for settlement trxn
7011: UPDATE iby_batches_all
7012: SET
7013: last_update_date = sysdate,
7014: last_updated_by = fnd_global.user_id,
7015: object_version_number = object_version_number + 1,