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 22: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,

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

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

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

Line 25: x_batch_currency OUT NOCOPY iby_batches_all.currencynamecode%TYPE

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

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

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

Line 40: FROM iby_batches_all ba, iby_trxn_summaries_all ts

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

Line 72: FROM iby_batches_all ba, iby_trxn_summaries_all ts

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

Line 89: FROM iby_batches_all ba, iby_trxn_summaries_all ts

85:
86: END IF;
87: SELECT COUNT(transactionid)
88: INTO x_trxn_count
89: FROM iby_batches_all ba, iby_trxn_summaries_all ts
90: WHERE (ba.mbatchid = p_mbatch_id)
91: AND (ba.payeeid = ts.payeeid)
92: AND (ba.batchid = ts.batchid);
93: --

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

1476:
1477: END insert_timeout_txn;
1478:
1479:
1480: /* Inserts a row about batch status into iby_batches_all. This will */
1481: /* be called for link error, timeout error or other batch status */
1482:
1483: PROCEDURE insert_batch_status
1484: (merch_batchid_in IN iby_batches_all.batchid%TYPE,

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

1480: /* Inserts a row about batch status into iby_batches_all. This will */
1481: /* be called for link error, timeout error or other batch status */
1482:
1483: PROCEDURE insert_batch_status
1484: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
1485: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1486: vendor_id_in IN iby_batches_all.bepid%TYPE,
1487: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1488: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

Line 1485: merchant_id_in IN iby_batches_all.payeeid%TYPE,

1481: /* be called for link error, timeout error or other batch status */
1482:
1483: PROCEDURE insert_batch_status
1484: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
1485: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1486: vendor_id_in IN iby_batches_all.bepid%TYPE,
1487: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1488: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1489: status_in IN iby_batches_all.batchstatus%TYPE,

Line 1486: vendor_id_in IN iby_batches_all.bepid%TYPE,

1482:
1483: PROCEDURE insert_batch_status
1484: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
1485: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1486: vendor_id_in IN iby_batches_all.bepid%TYPE,
1487: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1488: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1489: status_in IN iby_batches_all.batchstatus%TYPE,
1490: time_in IN iby_batches_all.batchclosedate%TYPE,

Line 1487: vendor_key_in IN iby_batches_all.bepkey%TYPE,

1483: PROCEDURE insert_batch_status
1484: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
1485: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1486: vendor_id_in IN iby_batches_all.bepid%TYPE,
1487: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1488: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1489: status_in IN iby_batches_all.batchstatus%TYPE,
1490: time_in IN iby_batches_all.batchclosedate%TYPE,
1491: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

Line 1488: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

1484: (merch_batchid_in IN iby_batches_all.batchid%TYPE,
1485: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1486: vendor_id_in IN iby_batches_all.bepid%TYPE,
1487: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1488: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1489: status_in IN iby_batches_all.batchstatus%TYPE,
1490: time_in IN iby_batches_all.batchclosedate%TYPE,
1491: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1492: currency_in IN iby_batches_all.currencynamecode%TYPE,

Line 1489: status_in IN iby_batches_all.batchstatus%TYPE,

1485: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1486: vendor_id_in IN iby_batches_all.bepid%TYPE,
1487: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1488: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1489: status_in IN iby_batches_all.batchstatus%TYPE,
1490: time_in IN iby_batches_all.batchclosedate%TYPE,
1491: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1492: currency_in IN iby_batches_all.currencynamecode%TYPE,
1493: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

Line 1490: time_in IN iby_batches_all.batchclosedate%TYPE,

1486: vendor_id_in IN iby_batches_all.bepid%TYPE,
1487: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1488: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1489: status_in IN iby_batches_all.batchstatus%TYPE,
1490: time_in IN iby_batches_all.batchclosedate%TYPE,
1491: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1492: currency_in IN iby_batches_all.currencynamecode%TYPE,
1493: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1494: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

Line 1491: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

1487: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1488: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1489: status_in IN iby_batches_all.batchstatus%TYPE,
1490: time_in IN iby_batches_all.batchclosedate%TYPE,
1491: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1492: currency_in IN iby_batches_all.currencynamecode%TYPE,
1493: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1494: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1495: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

Line 1492: currency_in IN iby_batches_all.currencynamecode%TYPE,

1488: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1489: status_in IN iby_batches_all.batchstatus%TYPE,
1490: time_in IN iby_batches_all.batchclosedate%TYPE,
1491: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1492: currency_in IN iby_batches_all.currencynamecode%TYPE,
1493: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1494: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1495: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1496: saleamount_in IN iby_batches_all.BatchSales%TYPE,

Line 1493: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

1489: status_in IN iby_batches_all.batchstatus%TYPE,
1490: time_in IN iby_batches_all.batchclosedate%TYPE,
1491: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1492: currency_in IN iby_batches_all.currencynamecode%TYPE,
1493: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1494: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1495: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1496: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1497: cramount_in IN iby_batches_all.BatchCredit%TYPE,

Line 1494: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

1490: time_in IN iby_batches_all.batchclosedate%TYPE,
1491: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1492: currency_in IN iby_batches_all.currencynamecode%TYPE,
1493: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1494: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1495: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1496: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1497: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1498: gwid_in IN iby_batches_all.GWBatchID%TYPE,

Line 1495: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

1491: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1492: currency_in IN iby_batches_all.currencynamecode%TYPE,
1493: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1494: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1495: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1496: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1497: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1498: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1499: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

Line 1496: saleamount_in IN iby_batches_all.BatchSales%TYPE,

1492: currency_in IN iby_batches_all.currencynamecode%TYPE,
1493: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1494: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1495: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1496: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1497: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1498: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1499: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1500: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

Line 1497: cramount_in IN iby_batches_all.BatchCredit%TYPE,

1493: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1494: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1495: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1496: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1497: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1498: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1499: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1500: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1501: error_location_in IN iby_batches_all.errorlocation%TYPE,

Line 1498: gwid_in IN iby_batches_all.GWBatchID%TYPE,

1494: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1495: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1496: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1497: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1498: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1499: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1500: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1501: error_location_in IN iby_batches_all.errorlocation%TYPE,
1502: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

Line 1499: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

1495: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1496: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1497: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1498: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1499: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1500: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1501: error_location_in IN iby_batches_all.errorlocation%TYPE,
1502: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1503: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

Line 1500: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

1496: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1497: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1498: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1499: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1500: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1501: error_location_in IN iby_batches_all.errorlocation%TYPE,
1502: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1503: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1504: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 1501: error_location_in IN iby_batches_all.errorlocation%TYPE,

1497: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1498: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1499: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1500: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1501: error_location_in IN iby_batches_all.errorlocation%TYPE,
1502: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1503: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1504: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1505: req_type_in IN iby_batches_all.reqtype%TYPE,

Line 1502: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

1498: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1499: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1500: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1501: error_location_in IN iby_batches_all.errorlocation%TYPE,
1502: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1503: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1504: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1505: req_type_in IN iby_batches_all.reqtype%TYPE,
1506: sec_key_present_in IN VARCHAR2,

Line 1503: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

1499: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1500: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1501: error_location_in IN iby_batches_all.errorlocation%TYPE,
1502: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1503: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1504: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1505: req_type_in IN iby_batches_all.reqtype%TYPE,
1506: sec_key_present_in IN VARCHAR2,
1507: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type

Line 1505: req_type_in IN iby_batches_all.reqtype%TYPE,

1501: error_location_in IN iby_batches_all.errorlocation%TYPE,
1502: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1503: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1504: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1505: req_type_in IN iby_batches_all.reqtype%TYPE,
1506: sec_key_present_in IN VARCHAR2,
1507: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type
1508: )
1509: IS

Line 1507: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type

1503: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1504: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1505: req_type_in IN iby_batches_all.reqtype%TYPE,
1506: sec_key_present_in IN VARCHAR2,
1507: mbatchid_out OUT NOCOPY iby_batches_all.mbatchid%type
1508: )
1509: IS
1510:
1511: numrows NUMBER;

Line 1513: l_mbatchid iby_batches_all.mbatchid%type;

1509: IS
1510:
1511: numrows NUMBER;
1512: l_mpayeeid iby_payee.mpayeeid%type;
1513: l_mbatchid iby_batches_all.mbatchid%type;
1514: l_beptype iby_bepinfo.bep_type%TYPE;
1515: l_trxncount iby_batches_all.numtrxns%TYPE;
1516: l_batchcurr iby_batches_all.currencynamecode%TYPE;
1517: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';

Line 1515: l_trxncount iby_batches_all.numtrxns%TYPE;

1511: numrows NUMBER;
1512: l_mpayeeid iby_payee.mpayeeid%type;
1513: l_mbatchid iby_batches_all.mbatchid%type;
1514: l_beptype iby_bepinfo.bep_type%TYPE;
1515: l_trxncount iby_batches_all.numtrxns%TYPE;
1516: l_batchcurr iby_batches_all.currencynamecode%TYPE;
1517: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';
1518: BEGIN
1519:

Line 1516: l_batchcurr iby_batches_all.currencynamecode%TYPE;

1512: l_mpayeeid iby_payee.mpayeeid%type;
1513: l_mbatchid iby_batches_all.mbatchid%type;
1514: l_beptype iby_bepinfo.bep_type%TYPE;
1515: l_trxncount iby_batches_all.numtrxns%TYPE;
1516: l_batchcurr iby_batches_all.currencynamecode%TYPE;
1517: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';
1518: BEGIN
1519:
1520: -- First check if a row already exists for this batch status

Line 1524: FROM iby_batches_all

1520: -- First check if a row already exists for this batch status
1521:
1522: SELECT COUNT(*)
1523: INTO numrows
1524: FROM iby_batches_all
1525: WHERE batchid = merch_batchid_in
1526: AND payeeid = merchant_id_in;
1527:
1528: -- insert batch status into iby_batches_all

Line 1528: -- insert batch status into iby_batches_all

1524: FROM iby_batches_all
1525: WHERE batchid = merch_batchid_in
1526: AND payeeid = merchant_id_in;
1527:
1528: -- insert batch status into iby_batches_all
1529:
1530: IF numrows = 0
1531:
1532: THEN

Line 1541: --LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;

1537: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown
1538: -- to be vulnerable to race conditions even under moderate
1539: -- concurrency loads
1540: --
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;

Line 1599: INSERT INTO iby_batches_all

1595:
1596: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
1597: -- Making Changes for bug:8363526
1598: -- Will insert value for settledate as SYSDATE.
1599: INSERT INTO iby_batches_all
1600: (MBATCHID, BATCHID, MPAYEEID, PAYEEID, BEPID, BEPKEY, PAYMENTMETHODNAME,
1601: BATCHSTATUS, BATCHCLOSEDATE, VPSBATCHID, CURRENCYNAMECODE,
1602: NUMTRXNS, BATCHSTATEID, BATCHTOTAL, BATCHSALES, BATCHCREDIT,
1603: GWBATCHID, BEPCODE, BEPMESSAGE, ERRORLOCATION,

Line 1619: UPDATE iby_batches_all

1615:
1616: validate_open_batch(vendor_id_in, l_mbatchid, sec_key_present_in,
1617: l_trxncount, l_batchcurr);
1618:
1619: UPDATE iby_batches_all
1620: SET CURRENCYNAMECODE = l_batchcurr,
1621: NUMTRXNS = l_trxncount
1622: WHERE mbatchid = l_mbatchid;
1623:

Line 1631: UPDATE iby_batches_all

1627: IF (l_trxncount<1) THEN
1628: l_trxncount := NULL;
1629: END IF;
1630: -- One previous transaction, so update previous row
1631: UPDATE iby_batches_all
1632: SET PAYMENTMETHODNAME = pmt_type_in,
1633: BATCHSTATUS = status_in,
1634: BATCHCLOSEDATE = time_in,
1635: CURRENCYNAMECODE = NVL(currency_in,CURRENCYNAMECODE),

Line 1661: UPDATE iby_batches_all

1657:
1658: IF ((req_type_in = 'ORAPMTCLOSEBATCH') OR
1659: (req_type_in = 'ORAPMTPDCCLOSEBATCH') ) THEN
1660: -- we don't update the following for querybatch
1661: UPDATE iby_batches_all
1662: SET VPSBATCHID = viby_batchid_in,
1663: reqtype = req_type_in,
1664: reqdate = sysdate
1665: WHERE batchid = merch_batchid_in

Line 1671: FROM iby_batches_all

1667: END IF;
1668:
1669: SELECT mbatchid
1670: INTO mbatchid_out
1671: FROM iby_batches_all
1672: WHERE batchid = merch_batchid_in
1673: AND payeeid = merchant_id_in;
1674:
1675: ELSE

Line 1716: merch_batchid_in IN iby_batches_all.batchid%TYPE,

1712: |
1713: *---------------------------------------------------------------------*/
1714: PROCEDURE insert_batch_status_new
1715: (
1716: merch_batchid_in IN iby_batches_all.batchid%TYPE,
1717: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
1718: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1719: vendor_id_in IN iby_batches_all.bepid%TYPE,
1720: vendor_key_in IN iby_batches_all.bepkey%TYPE,

Line 1717: profile_code_in IN iby_batches_all.process_profile_code%TYPE,

1713: *---------------------------------------------------------------------*/
1714: PROCEDURE insert_batch_status_new
1715: (
1716: merch_batchid_in IN iby_batches_all.batchid%TYPE,
1717: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
1718: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1719: vendor_id_in IN iby_batches_all.bepid%TYPE,
1720: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1721: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

Line 1718: merchant_id_in IN iby_batches_all.payeeid%TYPE,

1714: PROCEDURE insert_batch_status_new
1715: (
1716: merch_batchid_in IN iby_batches_all.batchid%TYPE,
1717: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
1718: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1719: vendor_id_in IN iby_batches_all.bepid%TYPE,
1720: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1721: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1722: status_in IN iby_batches_all.batchstatus%TYPE,

Line 1719: vendor_id_in IN iby_batches_all.bepid%TYPE,

1715: (
1716: merch_batchid_in IN iby_batches_all.batchid%TYPE,
1717: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
1718: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1719: vendor_id_in IN iby_batches_all.bepid%TYPE,
1720: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1721: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1722: status_in IN iby_batches_all.batchstatus%TYPE,
1723: time_in IN iby_batches_all.batchclosedate%TYPE,

Line 1720: vendor_key_in IN iby_batches_all.bepkey%TYPE,

1716: merch_batchid_in IN iby_batches_all.batchid%TYPE,
1717: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
1718: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1719: vendor_id_in IN iby_batches_all.bepid%TYPE,
1720: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1721: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1722: status_in IN iby_batches_all.batchstatus%TYPE,
1723: time_in IN iby_batches_all.batchclosedate%TYPE,
1724: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

Line 1721: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

1717: profile_code_in IN iby_batches_all.process_profile_code%TYPE,
1718: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1719: vendor_id_in IN iby_batches_all.bepid%TYPE,
1720: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1721: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1722: status_in IN iby_batches_all.batchstatus%TYPE,
1723: time_in IN iby_batches_all.batchclosedate%TYPE,
1724: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1725: currency_in IN iby_batches_all.currencynamecode%TYPE,

Line 1722: status_in IN iby_batches_all.batchstatus%TYPE,

1718: merchant_id_in IN iby_batches_all.payeeid%TYPE,
1719: vendor_id_in IN iby_batches_all.bepid%TYPE,
1720: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1721: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1722: status_in IN iby_batches_all.batchstatus%TYPE,
1723: time_in IN iby_batches_all.batchclosedate%TYPE,
1724: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1725: currency_in IN iby_batches_all.currencynamecode%TYPE,
1726: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

Line 1723: time_in IN iby_batches_all.batchclosedate%TYPE,

1719: vendor_id_in IN iby_batches_all.bepid%TYPE,
1720: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1721: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1722: status_in IN iby_batches_all.batchstatus%TYPE,
1723: time_in IN iby_batches_all.batchclosedate%TYPE,
1724: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1725: currency_in IN iby_batches_all.currencynamecode%TYPE,
1726: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1727: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

Line 1724: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

1720: vendor_key_in IN iby_batches_all.bepkey%TYPE,
1721: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1722: status_in IN iby_batches_all.batchstatus%TYPE,
1723: time_in IN iby_batches_all.batchclosedate%TYPE,
1724: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1725: currency_in IN iby_batches_all.currencynamecode%TYPE,
1726: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1727: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1728: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

Line 1725: currency_in IN iby_batches_all.currencynamecode%TYPE,

1721: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
1722: status_in IN iby_batches_all.batchstatus%TYPE,
1723: time_in IN iby_batches_all.batchclosedate%TYPE,
1724: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1725: currency_in IN iby_batches_all.currencynamecode%TYPE,
1726: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1727: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1728: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1729: saleamount_in IN iby_batches_all.BatchSales%TYPE,

Line 1726: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

1722: status_in IN iby_batches_all.batchstatus%TYPE,
1723: time_in IN iby_batches_all.batchclosedate%TYPE,
1724: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1725: currency_in IN iby_batches_all.currencynamecode%TYPE,
1726: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1727: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1728: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1729: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1730: cramount_in IN iby_batches_all.BatchCredit%TYPE,

Line 1727: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

1723: time_in IN iby_batches_all.batchclosedate%TYPE,
1724: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1725: currency_in IN iby_batches_all.currencynamecode%TYPE,
1726: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1727: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1728: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1729: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1730: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1731: gwid_in IN iby_batches_all.GWBatchID%TYPE,

Line 1728: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

1724: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
1725: currency_in IN iby_batches_all.currencynamecode%TYPE,
1726: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1727: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1728: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1729: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1730: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1731: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1732: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

Line 1729: saleamount_in IN iby_batches_all.BatchSales%TYPE,

1725: currency_in IN iby_batches_all.currencynamecode%TYPE,
1726: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1727: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1728: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1729: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1730: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1731: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1732: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1733: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

Line 1730: cramount_in IN iby_batches_all.BatchCredit%TYPE,

1726: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
1727: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1728: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1729: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1730: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1731: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1732: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1733: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1734: error_location_in IN iby_batches_all.errorlocation%TYPE,

Line 1731: gwid_in IN iby_batches_all.GWBatchID%TYPE,

1727: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
1728: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1729: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1730: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1731: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1732: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1733: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1734: error_location_in IN iby_batches_all.errorlocation%TYPE,
1735: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

Line 1732: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

1728: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
1729: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1730: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1731: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1732: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1733: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1734: error_location_in IN iby_batches_all.errorlocation%TYPE,
1735: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1736: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

Line 1733: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

1729: saleamount_in IN iby_batches_all.BatchSales%TYPE,
1730: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1731: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1732: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1733: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1734: error_location_in IN iby_batches_all.errorlocation%TYPE,
1735: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1736: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1737: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 1734: error_location_in IN iby_batches_all.errorlocation%TYPE,

1730: cramount_in IN iby_batches_all.BatchCredit%TYPE,
1731: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1732: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1733: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1734: error_location_in IN iby_batches_all.errorlocation%TYPE,
1735: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1736: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1737: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1738: req_type_in IN iby_batches_all.reqtype%TYPE,

Line 1735: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

1731: gwid_in IN iby_batches_all.GWBatchID%TYPE,
1732: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1733: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1734: error_location_in IN iby_batches_all.errorlocation%TYPE,
1735: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1736: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1737: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1738: req_type_in IN iby_batches_all.reqtype%TYPE,
1739: sec_key_present_in IN VARCHAR2,

Line 1736: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

1732: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
1733: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
1734: error_location_in IN iby_batches_all.errorlocation%TYPE,
1735: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1736: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1737: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1738: req_type_in IN iby_batches_all.reqtype%TYPE,
1739: sec_key_present_in IN VARCHAR2,
1740: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

Line 1738: req_type_in IN iby_batches_all.reqtype%TYPE,

1734: error_location_in IN iby_batches_all.errorlocation%TYPE,
1735: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
1736: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1737: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1738: req_type_in IN iby_batches_all.reqtype%TYPE,
1739: sec_key_present_in IN VARCHAR2,
1740: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
1741: instr_type_in IN iby_batches_all.instrument_type%TYPE,
1742: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

Line 1740: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

1736: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
1737: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1738: req_type_in IN iby_batches_all.reqtype%TYPE,
1739: sec_key_present_in IN VARCHAR2,
1740: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
1741: instr_type_in IN iby_batches_all.instrument_type%TYPE,
1742: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
1743: f_pmt_channel_in IN iby_trxn_summaries_all.
1744: payment_channel_code%TYPE,

Line 1741: instr_type_in IN iby_batches_all.instrument_type%TYPE,

1737: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1738: req_type_in IN iby_batches_all.reqtype%TYPE,
1739: sec_key_present_in IN VARCHAR2,
1740: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
1741: instr_type_in IN iby_batches_all.instrument_type%TYPE,
1742: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
1743: f_pmt_channel_in IN iby_trxn_summaries_all.
1744: payment_channel_code%TYPE,
1745: f_curr_in IN iby_trxn_summaries_all.

Line 1742: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

1738: req_type_in IN iby_batches_all.reqtype%TYPE,
1739: sec_key_present_in IN VARCHAR2,
1740: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
1741: instr_type_in IN iby_batches_all.instrument_type%TYPE,
1742: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
1743: f_pmt_channel_in IN iby_trxn_summaries_all.
1744: payment_channel_code%TYPE,
1745: f_curr_in IN iby_trxn_summaries_all.
1746: currencynamecode%TYPE,

Line 1763: l_mbatchid iby_batches_all.mbatchid%type;

1759:
1760: numrows NUMBER;
1761:
1762: l_mpayeeid iby_payee.mpayeeid%type;
1763: l_mbatchid iby_batches_all.mbatchid%type;
1764: l_beptype iby_bepinfo.bep_type%TYPE;
1765: l_trxncount iby_batches_all.numtrxns%TYPE;
1766: l_batchcurr iby_batches_all.currencynamecode%TYPE;
1767:

Line 1765: l_trxncount iby_batches_all.numtrxns%TYPE;

1761:
1762: l_mpayeeid iby_payee.mpayeeid%type;
1763: l_mbatchid iby_batches_all.mbatchid%type;
1764: l_beptype iby_bepinfo.bep_type%TYPE;
1765: l_trxncount iby_batches_all.numtrxns%TYPE;
1766: l_batchcurr iby_batches_all.currencynamecode%TYPE;
1767:
1768: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';
1769:

Line 1766: l_batchcurr iby_batches_all.currencynamecode%TYPE;

1762: l_mpayeeid iby_payee.mpayeeid%type;
1763: l_mbatchid iby_batches_all.mbatchid%type;
1764: l_beptype iby_bepinfo.bep_type%TYPE;
1765: l_trxncount iby_batches_all.numtrxns%TYPE;
1766: l_batchcurr iby_batches_all.currencynamecode%TYPE;
1767:
1768: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';
1769:
1770: l_batches_tab batchAttrTabType;

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

1780: * Cursor to pick up all existing mbatchids for
1781: * a given (batch id, payee id, profile code)
1782: * combination.
1783: */
1784: CURSOR c_mbatch_ids (batch_id IBY_BATCHES_ALL.batchid%TYPE,
1785: payee_id IBY_BATCHES_ALL.payeeid%TYPE,
1786: profile_cd IBY_BATCHES_ALL.process_profile_code%TYPE
1787: )
1788: IS

Line 1785: payee_id IBY_BATCHES_ALL.payeeid%TYPE,

1781: * a given (batch id, payee id, profile code)
1782: * combination.
1783: */
1784: CURSOR c_mbatch_ids (batch_id IBY_BATCHES_ALL.batchid%TYPE,
1785: payee_id IBY_BATCHES_ALL.payeeid%TYPE,
1786: profile_cd IBY_BATCHES_ALL.process_profile_code%TYPE
1787: )
1788: IS
1789: SELECT

Line 1786: profile_cd IBY_BATCHES_ALL.process_profile_code%TYPE

1782: * combination.
1783: */
1784: CURSOR c_mbatch_ids (batch_id IBY_BATCHES_ALL.batchid%TYPE,
1785: payee_id IBY_BATCHES_ALL.payeeid%TYPE,
1786: profile_cd IBY_BATCHES_ALL.process_profile_code%TYPE
1787: )
1788: IS
1789: SELECT
1790: mbatchid

Line 1792: IBY_BATCHES_ALL

1788: IS
1789: SELECT
1790: mbatchid
1791: FROM
1792: IBY_BATCHES_ALL
1793: WHERE
1794: batchid = batch_id AND
1795: payeeid = payee_id AND
1796: process_profile_code = profile_cd

Line 1814: IBY_BATCHES_ALL

1810: COUNT(*)
1811: INTO
1812: numrows
1813: FROM
1814: IBY_BATCHES_ALL
1815: WHERE
1816: batchid = merch_batchid_in AND
1817: payeeid = merchant_id_in
1818: ;

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

1817: payeeid = merchant_id_in
1818: ;
1819:
1820: /*
1821: * If row does not exist, then insert batch status into iby_batches_all
1822: */
1823: IF numrows = 0 THEN
1824:
1825: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1837: --LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;

1833: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown
1834: -- to be vulnerable to race conditions even under moderate
1835: -- concurrency loads
1836: --
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;

Line 1906: * IBY_BATCHES_ALL table with a unique mbatchid.

1902: END IF;
1903: /*
1904: * After grouping it is possible that multiple batches were
1905: * created. Each batch will be a separate row in the
1906: * IBY_BATCHES_ALL table with a unique mbatchid.
1907: *
1908: * The user may have provided a batch id (batch prefix), we will
1909: * have to assign that batch id to each of the created batches.
1910: *

Line 2078: iby_batches_all

2074:
2075: END IF;
2076:
2077: INSERT INTO
2078: iby_batches_all
2079: (
2080: MBATCHID,
2081: BATCHID,
2082: MPAYEEID,

Line 2176: IBY_BATCHES_ALL

2172: l_trxncount,
2173: l_batchcurr);
2174:
2175: UPDATE
2176: IBY_BATCHES_ALL
2177: SET
2178: currencynamecode = l_batchcurr,
2179: numtrxns = l_trxncount
2180: WHERE

Line 2212: IBY_BATCHES_ALL

2208: END IF;
2209:
2210: /* One previous transaction, so update previous row */
2211: UPDATE
2212: IBY_BATCHES_ALL
2213: SET
2214: PAYMENTMETHODNAME = pmt_type_in,
2215: BATCHSTATUS = status_in,
2216: BATCHCLOSEDATE = time_in,

Line 2246: iby_batches_all

2242: (req_type_in = 'ORAPMTPDCCLOSEBATCH') ) THEN
2243:
2244: -- we don't update the following for querybatch
2245: UPDATE
2246: iby_batches_all
2247: SET
2248: VPSBATCHID = viby_batchid_in,
2249: reqtype = req_type_in,
2250: reqdate = sysdate

Line 2259: --FROM iby_batches_all

2255: END IF;
2256:
2257: --SELECT mbatchid
2258: --INTO mbatchid_out
2259: --FROM iby_batches_all
2260: --WHERE batchid = merch_batchid_in
2261: --AND payeeid = merchant_id_in;
2262:
2263: /*

Line 2349: merch_batchid_in IN iby_batches_all.batchid%TYPE,

2345: |
2346: *---------------------------------------------------------------------*/
2347: PROCEDURE insert_batch_status_new
2348: (
2349: merch_batchid_in IN iby_batches_all.batchid%TYPE,
2350: profile_code_array IN JTF_VARCHAR2_TABLE_100,
2351: merchant_id_in IN iby_batches_all.payeeid%TYPE,
2352: vendor_id_in IN iby_batches_all.bepid%TYPE,
2353: vendor_key_in IN iby_batches_all.bepkey%TYPE,

Line 2351: merchant_id_in IN iby_batches_all.payeeid%TYPE,

2347: PROCEDURE insert_batch_status_new
2348: (
2349: merch_batchid_in IN iby_batches_all.batchid%TYPE,
2350: profile_code_array IN JTF_VARCHAR2_TABLE_100,
2351: merchant_id_in IN iby_batches_all.payeeid%TYPE,
2352: vendor_id_in IN iby_batches_all.bepid%TYPE,
2353: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2354: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2355: status_in IN iby_batches_all.batchstatus%TYPE,

Line 2352: vendor_id_in IN iby_batches_all.bepid%TYPE,

2348: (
2349: merch_batchid_in IN iby_batches_all.batchid%TYPE,
2350: profile_code_array IN JTF_VARCHAR2_TABLE_100,
2351: merchant_id_in IN iby_batches_all.payeeid%TYPE,
2352: vendor_id_in IN iby_batches_all.bepid%TYPE,
2353: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2354: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2355: status_in IN iby_batches_all.batchstatus%TYPE,
2356: time_in IN iby_batches_all.batchclosedate%TYPE,

Line 2353: vendor_key_in IN iby_batches_all.bepkey%TYPE,

2349: merch_batchid_in IN iby_batches_all.batchid%TYPE,
2350: profile_code_array IN JTF_VARCHAR2_TABLE_100,
2351: merchant_id_in IN iby_batches_all.payeeid%TYPE,
2352: vendor_id_in IN iby_batches_all.bepid%TYPE,
2353: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2354: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2355: status_in IN iby_batches_all.batchstatus%TYPE,
2356: time_in IN iby_batches_all.batchclosedate%TYPE,
2357: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

Line 2354: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,

2350: profile_code_array IN JTF_VARCHAR2_TABLE_100,
2351: merchant_id_in IN iby_batches_all.payeeid%TYPE,
2352: vendor_id_in IN iby_batches_all.bepid%TYPE,
2353: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2354: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2355: status_in IN iby_batches_all.batchstatus%TYPE,
2356: time_in IN iby_batches_all.batchclosedate%TYPE,
2357: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2358: currency_in IN iby_batches_all.currencynamecode%TYPE,

Line 2355: status_in IN iby_batches_all.batchstatus%TYPE,

2351: merchant_id_in IN iby_batches_all.payeeid%TYPE,
2352: vendor_id_in IN iby_batches_all.bepid%TYPE,
2353: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2354: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2355: status_in IN iby_batches_all.batchstatus%TYPE,
2356: time_in IN iby_batches_all.batchclosedate%TYPE,
2357: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2358: currency_in IN iby_batches_all.currencynamecode%TYPE,
2359: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

Line 2356: time_in IN iby_batches_all.batchclosedate%TYPE,

2352: vendor_id_in IN iby_batches_all.bepid%TYPE,
2353: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2354: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2355: status_in IN iby_batches_all.batchstatus%TYPE,
2356: time_in IN iby_batches_all.batchclosedate%TYPE,
2357: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2358: currency_in IN iby_batches_all.currencynamecode%TYPE,
2359: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2360: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

Line 2357: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,

2353: vendor_key_in IN iby_batches_all.bepkey%TYPE,
2354: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2355: status_in IN iby_batches_all.batchstatus%TYPE,
2356: time_in IN iby_batches_all.batchclosedate%TYPE,
2357: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2358: currency_in IN iby_batches_all.currencynamecode%TYPE,
2359: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2360: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2361: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

Line 2358: currency_in IN iby_batches_all.currencynamecode%TYPE,

2354: pmt_type_in IN iby_batches_all.paymentmethodname%TYPE,
2355: status_in IN iby_batches_all.batchstatus%TYPE,
2356: time_in IN iby_batches_all.batchclosedate%TYPE,
2357: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2358: currency_in IN iby_batches_all.currencynamecode%TYPE,
2359: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2360: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2361: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2362: saleamount_in IN iby_batches_all.BatchSales%TYPE,

Line 2359: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,

2355: status_in IN iby_batches_all.batchstatus%TYPE,
2356: time_in IN iby_batches_all.batchclosedate%TYPE,
2357: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2358: currency_in IN iby_batches_all.currencynamecode%TYPE,
2359: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2360: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2361: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2362: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2363: cramount_in IN iby_batches_all.BatchCredit%TYPE,

Line 2360: batchstate_in IN iby_batches_all.BatchStateid%TYPE,

2356: time_in IN iby_batches_all.batchclosedate%TYPE,
2357: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2358: currency_in IN iby_batches_all.currencynamecode%TYPE,
2359: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2360: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2361: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2362: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2363: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2364: gwid_in IN iby_batches_all.GWBatchID%TYPE,

Line 2361: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,

2357: viby_batchid_in IN iby_batches_all.vpsbatchid%TYPE ,
2358: currency_in IN iby_batches_all.currencynamecode%TYPE,
2359: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2360: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2361: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2362: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2363: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2364: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2365: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

Line 2362: saleamount_in IN iby_batches_all.BatchSales%TYPE,

2358: currency_in IN iby_batches_all.currencynamecode%TYPE,
2359: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2360: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2361: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2362: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2363: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2364: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2365: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2366: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

Line 2363: cramount_in IN iby_batches_all.BatchCredit%TYPE,

2359: numtrxns_in IN iby_batches_all.NumTrxns%TYPE,
2360: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2361: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2362: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2363: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2364: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2365: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2366: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2367: error_location_in IN iby_batches_all.errorlocation%TYPE,

Line 2364: gwid_in IN iby_batches_all.GWBatchID%TYPE,

2360: batchstate_in IN iby_batches_all.BatchStateid%TYPE,
2361: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2362: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2363: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2364: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2365: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2366: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2367: error_location_in IN iby_batches_all.errorlocation%TYPE,
2368: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

Line 2365: vendor_code_in IN iby_batches_all.BEPcode%TYPE,

2361: batchtotal_in IN iby_batches_all.BatchTotal%TYPE,
2362: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2363: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2364: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2365: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2366: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2367: error_location_in IN iby_batches_all.errorlocation%TYPE,
2368: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
2369: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

Line 2366: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,

2362: saleamount_in IN iby_batches_all.BatchSales%TYPE,
2363: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2364: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2365: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2366: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2367: error_location_in IN iby_batches_all.errorlocation%TYPE,
2368: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
2369: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
2370: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 2367: error_location_in IN iby_batches_all.errorlocation%TYPE,

2363: cramount_in IN iby_batches_all.BatchCredit%TYPE,
2364: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2365: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2366: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2367: error_location_in IN iby_batches_all.errorlocation%TYPE,
2368: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
2369: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
2370: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
2371: req_type_in IN iby_batches_all.reqtype%TYPE,

Line 2368: terminal_id_in IN iby_batches_all.TerminalId%TYPE,

2364: gwid_in IN iby_batches_all.GWBatchID%TYPE,
2365: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2366: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2367: error_location_in IN iby_batches_all.errorlocation%TYPE,
2368: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
2369: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
2370: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
2371: req_type_in IN iby_batches_all.reqtype%TYPE,
2372: sec_key_present_in IN VARCHAR2,

Line 2369: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,

2365: vendor_code_in IN iby_batches_all.BEPcode%TYPE,
2366: vendor_message_in IN iby_batches_all.BEPmessage%TYPE,
2367: error_location_in IN iby_batches_all.errorlocation%TYPE,
2368: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
2369: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
2370: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
2371: req_type_in IN iby_batches_all.reqtype%TYPE,
2372: sec_key_present_in IN VARCHAR2,
2373: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

Line 2371: req_type_in IN iby_batches_all.reqtype%TYPE,

2367: error_location_in IN iby_batches_all.errorlocation%TYPE,
2368: terminal_id_in IN iby_batches_all.TerminalId%TYPE,
2369: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
2370: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
2371: req_type_in IN iby_batches_all.reqtype%TYPE,
2372: sec_key_present_in IN VARCHAR2,
2373: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
2374: instr_type_in IN iby_batches_all.instrument_type%TYPE,
2375: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

Line 2373: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,

2369: acquirer_id_in IN iby_batches_all.Acquirer%TYPE,
2370: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
2371: req_type_in IN iby_batches_all.reqtype%TYPE,
2372: sec_key_present_in IN VARCHAR2,
2373: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
2374: instr_type_in IN iby_batches_all.instrument_type%TYPE,
2375: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
2376: f_pmt_channel_in IN iby_trxn_summaries_all.
2377: payment_channel_code%TYPE,

Line 2374: instr_type_in IN iby_batches_all.instrument_type%TYPE,

2370: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
2371: req_type_in IN iby_batches_all.reqtype%TYPE,
2372: sec_key_present_in IN VARCHAR2,
2373: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
2374: instr_type_in IN iby_batches_all.instrument_type%TYPE,
2375: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
2376: f_pmt_channel_in IN iby_trxn_summaries_all.
2377: payment_channel_code%TYPE,
2378: f_curr_in IN iby_trxn_summaries_all.

Line 2375: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,

2371: req_type_in IN iby_batches_all.reqtype%TYPE,
2372: sec_key_present_in IN VARCHAR2,
2373: acct_profile_in IN iby_batches_all.process_profile_code%TYPE,
2374: instr_type_in IN iby_batches_all.instrument_type%TYPE,
2375: br_disputed_flag_in IN iby_batches_all.br_disputed_flag%TYPE,
2376: f_pmt_channel_in IN iby_trxn_summaries_all.
2377: payment_channel_code%TYPE,
2378: f_curr_in IN iby_trxn_summaries_all.
2379: currencynamecode%TYPE,

Line 2396: l_mbatchid iby_batches_all.mbatchid%type;

2392:
2393: numrows NUMBER;
2394:
2395: l_mpayeeid iby_payee.mpayeeid%type;
2396: l_mbatchid iby_batches_all.mbatchid%type;
2397: l_beptype iby_bepinfo.bep_type%TYPE;
2398: l_trxncount iby_batches_all.numtrxns%TYPE;
2399: l_batchcurr iby_batches_all.currencynamecode%TYPE;
2400: -- profile_code_in iby_batches_all.process_profile_code%TYPE;

Line 2398: l_trxncount iby_batches_all.numtrxns%TYPE;

2394:
2395: l_mpayeeid iby_payee.mpayeeid%type;
2396: l_mbatchid iby_batches_all.mbatchid%type;
2397: l_beptype iby_bepinfo.bep_type%TYPE;
2398: l_trxncount iby_batches_all.numtrxns%TYPE;
2399: l_batchcurr iby_batches_all.currencynamecode%TYPE;
2400: -- profile_code_in iby_batches_all.process_profile_code%TYPE;
2401: numProfiles NUMBER;
2402: strProfCodes VARCHAR2(4000);

Line 2399: l_batchcurr iby_batches_all.currencynamecode%TYPE;

2395: l_mpayeeid iby_payee.mpayeeid%type;
2396: l_mbatchid iby_batches_all.mbatchid%type;
2397: l_beptype iby_bepinfo.bep_type%TYPE;
2398: l_trxncount iby_batches_all.numtrxns%TYPE;
2399: l_batchcurr iby_batches_all.currencynamecode%TYPE;
2400: -- profile_code_in iby_batches_all.process_profile_code%TYPE;
2401: numProfiles NUMBER;
2402: strProfCodes VARCHAR2(4000);
2403:

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

2396: l_mbatchid iby_batches_all.mbatchid%type;
2397: l_beptype iby_bepinfo.bep_type%TYPE;
2398: l_trxncount iby_batches_all.numtrxns%TYPE;
2399: l_batchcurr iby_batches_all.currencynamecode%TYPE;
2400: -- profile_code_in iby_batches_all.process_profile_code%TYPE;
2401: numProfiles NUMBER;
2402: strProfCodes VARCHAR2(4000);
2403:
2404: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';

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

2420: * Cursor to pick up all existing mbatchids for
2421: * a given (batch id, payee id, profile code)
2422: * combination.
2423: */
2424: -- CURSOR c_mbatch_ids (batch_id IBY_BATCHES_ALL.batchid%TYPE,
2425: -- payee_id IBY_BATCHES_ALL.payeeid%TYPE,
2426: -- strProfiles VARCHAR2
2427: -- )
2428: -- IS

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

2421: * a given (batch id, payee id, profile code)
2422: * combination.
2423: */
2424: -- CURSOR c_mbatch_ids (batch_id IBY_BATCHES_ALL.batchid%TYPE,
2425: -- payee_id IBY_BATCHES_ALL.payeeid%TYPE,
2426: -- strProfiles VARCHAR2
2427: -- )
2428: -- IS
2429: -- SELECT

Line 2432: -- IBY_BATCHES_ALL

2428: -- IS
2429: -- SELECT
2430: -- mbatchid
2431: -- FROM
2432: -- IBY_BATCHES_ALL
2433: -- WHERE
2434: -- batchid = batch_id AND
2435: -- payeeid = payee_id AND
2436: -- process_profile_code IN (strProfiles)

Line 2465: ' IBY_BATCHES_ALL WHERE '||

2461: * all existing mbatchids for a given (batchid,payeeid and
2462: * a string of profile codes)
2463: */
2464: l_cursor_stmt := ' SELECT mbatchid FROM '||
2465: ' IBY_BATCHES_ALL WHERE '||
2466: ' batchid = '''||merch_batchid_in||''' AND '||
2467: ' payeeid = '''||merchant_id_in||''' AND '||
2468: ' process_profile_code IN ('||strProfCodes||') '
2469: ;

Line 2478: IBY_BATCHES_ALL

2474: COUNT(*)
2475: INTO
2476: numrows
2477: FROM
2478: IBY_BATCHES_ALL
2479: WHERE
2480: batchid = merch_batchid_in AND
2481: payeeid = merchant_id_in
2482: ;

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

2481: payeeid = merchant_id_in
2482: ;
2483:
2484: /*
2485: * If row does not exist, then insert batch status into iby_batches_all
2486: */
2487: IF numrows = 0 THEN
2488:
2489: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2501: --LOCK TABLE iby_batches_all, iby_trxn_summaries_all IN EXCLUSIVE MODE;

2497: -- and update of IBY_TRXN_SUMMARIES_ALL has been shown
2498: -- to be vulnerable to race conditions even under moderate
2499: -- concurrency loads
2500: --
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;

Line 2571: * IBY_BATCHES_ALL table with a unique mbatchid.

2567: END IF;
2568: /*
2569: * After grouping it is possible that multiple batches were
2570: * created. Each batch will be a separate row in the
2571: * IBY_BATCHES_ALL table with a unique mbatchid.
2572: *
2573: * The user may have provided a batch id (batch prefix), we will
2574: * have to assign that batch id to each of the created batches.
2575: *

Line 2748: iby_batches_all

2744:
2745: END IF;
2746:
2747: INSERT INTO
2748: iby_batches_all
2749: (
2750: MBATCHID,
2751: BATCHID,
2752: MPAYEEID,

Line 2847: IBY_BATCHES_ALL

2843: l_trxncount,
2844: l_batchcurr);
2845:
2846: UPDATE
2847: IBY_BATCHES_ALL
2848: SET
2849: currencynamecode = l_batchcurr,-- should be made NULL
2850: numtrxns = l_trxncount
2851: WHERE

Line 2888: IBY_BATCHES_ALL

2884: END IF;
2885:
2886: /* One previous transaction, so update previous row */
2887: UPDATE
2888: IBY_BATCHES_ALL
2889: SET
2890: PAYMENTMETHODNAME = pmt_type_in,
2891: BATCHSTATUS = status_in,
2892: BATCHCLOSEDATE = time_in,

Line 2922: iby_batches_all

2918: (req_type_in = 'ORAPMTPDCCLOSEBATCH') ) THEN
2919:
2920: -- we don't update the following for querybatch
2921: UPDATE
2922: iby_batches_all
2923: SET
2924: VPSBATCHID = viby_batchid_in,
2925: reqtype = req_type_in,
2926: reqdate = sysdate

Line 2935: --FROM iby_batches_all

2931: END IF;
2932:
2933: --SELECT mbatchid
2934: --INTO mbatchid_out
2935: --FROM iby_batches_all
2936: --WHERE batchid = merch_batchid_in
2937: --AND payeeid = merchant_id_in;
2938:
2939: /*

Line 3032: req_type IN IBY_BATCHES_ALL.

3028: p_profile_code IN IBY_FNDCPT_USER_CC_PF_B.
3029: user_cc_profile_code%TYPE,
3030: instr_type IN IBY_TRXN_SUMMARIES_ALL.
3031: instrtype%TYPE,
3032: req_type IN IBY_BATCHES_ALL.
3033: reqtype%TYPE,
3034: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
3035: payment_channel_code%TYPE,
3036: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.

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

3072:
3073: /*
3074: * NOTE:
3075: *
3076: * IBY_BATCHES_ALL.batchid = user generated batch id
3077: * IBY_BATCHES_ALL.mbatchid = system generated batch id
3078: *
3079: * If batch close is invoked by the user, the batchid will
3080: * be a user defined string (should be unique).

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

3073: /*
3074: * NOTE:
3075: *
3076: * IBY_BATCHES_ALL.batchid = user generated batch id
3077: * IBY_BATCHES_ALL.mbatchid = system generated batch id
3078: *
3079: * If batch close is invoked by the user, the batchid will
3080: * be a user defined string (should be unique).
3081: *

Line 3090: l_mbatch_id IBY_BATCHES_ALL.mbatchid%TYPE;

3086: *
3087: * In the new architecture, multiple mbatchids can be generated
3088: * for a single batchid (based on user defined grouping rules).
3089: */
3090: l_mbatch_id IBY_BATCHES_ALL.mbatchid%TYPE;
3091: l_batch_total NUMBER(15) := 0;
3092: l_trxns_in_batch_count NUMBER(15) := 0;
3093:
3094: l_trx_fx_amount NUMBER(15) := 0;

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

3102: 'MM/DD/YYYY HH24:MI:SS');
3103:
3104: /*
3105: * These two are related data structures. Each row in batchAttrTabType
3106: * PLSQL table is used in inserting a row into the IBY_BATCHES_ALL
3107: * table.
3108: *
3109: * A separate data structure is needed to keep track of the transactions
3110: * that are part of a batch. This information is tracked in the

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

3112: * used to update the rows in IBY_TRXN_SUMMARIES_ALL table with
3113: * batch ids.
3114: *
3115: * l_batchTab l_trxnsInBatchTab
3116: * (insert into IBY_BATCHES_ALL) (update IBY_TRXN_SUMMARIES_ALL)
3117: * /-------------------------------------\ /------------\
3118: * |MBatch |Profile|..|Curr |Org |..| |MBatch |Trx |
3119: * |Id |Code |..|Code |Id |..| |Id |Id |
3120: * | | |..| | |..| | | |

Line 4195: req_type IN IBY_BATCHES_ALL.

4191: PROCEDURE performTransactionGrouping(
4192: profile_code_array IN JTF_VARCHAR2_TABLE_100,
4193: instr_type IN IBY_TRXN_SUMMARIES_ALL.
4194: instrtype%TYPE,
4195: req_type IN IBY_BATCHES_ALL.
4196: reqtype%TYPE,
4197: f_pmt_channel_in IN IBY_TRXN_SUMMARIES_ALL.
4198: payment_channel_code%TYPE,
4199: f_curr_in IN IBY_TRXN_SUMMARIES_ALL.

Line 4209: merch_batchid_in IN iby_batches_all.batchid%TYPE,

4205: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
4206: br_maturity_date%TYPE,
4207: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.
4208: instrtype%TYPE,
4209: merch_batchid_in IN iby_batches_all.batchid%TYPE,
4210:
4211: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.
4212: batchAttrTabType,
4213: x_trxnsInBatchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.

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

4237:
4238: /*
4239: * NOTE:
4240: *
4241: * IBY_BATCHES_ALL.batchid = user generated batch id
4242: * IBY_BATCHES_ALL.mbatchid = system generated batch id
4243: *
4244: * If batch close is invoked by the user, the batchid will
4245: * be a user defined string (should be unique).

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

4238: /*
4239: * NOTE:
4240: *
4241: * IBY_BATCHES_ALL.batchid = user generated batch id
4242: * IBY_BATCHES_ALL.mbatchid = system generated batch id
4243: *
4244: * If batch close is invoked by the user, the batchid will
4245: * be a user defined string (should be unique).
4246: *

Line 4255: l_mbatch_id IBY_BATCHES_ALL.mbatchid%TYPE;

4251: *
4252: * In the new architecture, multiple mbatchids can be generated
4253: * for a single batchid (based on user defined grouping rules).
4254: */
4255: l_mbatch_id IBY_BATCHES_ALL.mbatchid%TYPE;
4256: l_batch_total NUMBER(15) := 0;
4257: l_trxns_in_batch_count NUMBER(15) := 0;
4258:
4259: l_trx_fx_amount NUMBER(15) := 0;

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

4267: 'MM/DD/YYYY HH24:MI:SS');
4268:
4269: /*
4270: * These two are related data structures. Each row in batchAttrTabType
4271: * PLSQL table is used in inserting a row into the IBY_BATCHES_ALL
4272: * table.
4273: *
4274: * A separate data structure is needed to keep track of the transactions
4275: * that are part of a batch. This information is tracked in the

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

4277: * used to update the rows in IBY_TRXN_SUMMARIES_ALL table with
4278: * batch ids.
4279: *
4280: * l_batchTab l_trxnsInBatchTab
4281: * (insert into IBY_BATCHES_ALL) (update IBY_TRXN_SUMMARIES_ALL)
4282: * /-------------------------------------\ /------------\
4283: * |MBatch |Profile|..|Curr |Org |..| |MBatch |Trx |
4284: * |Id |Code |..|Code |Id |..| |Id |Id |
4285: * | | |..| | |..| | | |

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

5499: PROCEDURE insertTrxnIntoBatch(
5500: x_batchRec IN OUT NOCOPY batchAttrRecType,
5501: x_batchTab IN OUT NOCOPY batchAttrTabType,
5502: p_newBatchFlag IN BOOLEAN,
5503: x_currentBatchId IN OUT NOCOPY IBY_BATCHES_ALL.batchid%TYPE,
5504: x_trxnsInBatchTab IN OUT NOCOPY trxnsInBatchTabType,
5505: x_trxnsInBatchRec IN OUT NOCOPY trxnsInBatchRecType,
5506: x_trxnsInBatchCount IN OUT NOCOPY NUMBER
5507: )

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

5771: | NOTES:
5772: |
5773: *---------------------------------------------------------------------*/
5774: PROCEDURE getNextBatchId(
5775: x_batchID IN OUT NOCOPY IBY_BATCHES_ALL.batchid%TYPE
5776: )
5777: IS
5778:
5779: BEGIN

Line 5907: l_mbatchid iby_batches_all.mbatchid%type;

5903: l_trxn_mid NUMBER;
5904: transaction_id NUMBER;
5905:
5906: l_mpayeeid iby_payee.mpayeeid%type;
5907: l_mbatchid iby_batches_all.mbatchid%type;
5908: l_mtangibleid iby_tangible.mtangibleid%type;
5909:
5910: l_prev_trxn_count number;
5911: l_reqtype iby_trxn_summaries_all.reqtype%type;

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

6287: BEGIN
6288: getMBatchId(oldbatchid_in, payeeid_in, l_mbatchid);
6289: --
6290: -- catch exception in the case where the batch id has not been
6291: -- stored yet in IBY_BATCHES_ALL ; this can happen when we
6292: -- want to change the status of transitional trxns
6293: --
6294: EXCEPTION WHEN others THEN
6295: l_mbatchid := NULL;

Line 6443: ecapp_id_in IN iby_batches_all.ecappid%TYPE,

6439: END updateBatchQueryTrxn;
6440:
6441: PROCEDURE Update_Batch
6442: (
6443: ecapp_id_in IN iby_batches_all.ecappid%TYPE,
6444: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
6445: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
6446: batch_status_in IN iby_batches_all.batchstatus%TYPE,
6447: batch_total_in IN iby_batches_all.batchtotal%TYPE,

Line 6446: batch_status_in IN iby_batches_all.batchstatus%TYPE,

6442: (
6443: ecapp_id_in IN iby_batches_all.ecappid%TYPE,
6444: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
6445: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
6446: batch_status_in IN iby_batches_all.batchstatus%TYPE,
6447: batch_total_in IN iby_batches_all.batchtotal%TYPE,
6448: sale_amount_in IN iby_batches_all.batchsales%TYPE,
6449: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
6450: bep_code_in IN iby_batches_all.bepcode%TYPE,

Line 6447: batch_total_in IN iby_batches_all.batchtotal%TYPE,

6443: ecapp_id_in IN iby_batches_all.ecappid%TYPE,
6444: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
6445: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
6446: batch_status_in IN iby_batches_all.batchstatus%TYPE,
6447: batch_total_in IN iby_batches_all.batchtotal%TYPE,
6448: sale_amount_in IN iby_batches_all.batchsales%TYPE,
6449: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
6450: bep_code_in IN iby_batches_all.bepcode%TYPE,
6451: bep_message_in IN iby_batches_all.bepmessage%TYPE,

Line 6448: sale_amount_in IN iby_batches_all.batchsales%TYPE,

6444: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
6445: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
6446: batch_status_in IN iby_batches_all.batchstatus%TYPE,
6447: batch_total_in IN iby_batches_all.batchtotal%TYPE,
6448: sale_amount_in IN iby_batches_all.batchsales%TYPE,
6449: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
6450: bep_code_in IN iby_batches_all.bepcode%TYPE,
6451: bep_message_in IN iby_batches_all.bepmessage%TYPE,
6452: error_location_in IN iby_batches_all.errorlocation%TYPE,

Line 6449: credit_amount_in IN iby_batches_all.batchcredit%TYPE,

6445: batchid_in IN iby_trxn_summaries_all.batchid%TYPE,
6446: batch_status_in IN iby_batches_all.batchstatus%TYPE,
6447: batch_total_in IN iby_batches_all.batchtotal%TYPE,
6448: sale_amount_in IN iby_batches_all.batchsales%TYPE,
6449: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
6450: bep_code_in IN iby_batches_all.bepcode%TYPE,
6451: bep_message_in IN iby_batches_all.bepmessage%TYPE,
6452: error_location_in IN iby_batches_all.errorlocation%TYPE,
6453: ack_type_in IN VARCHAR2,

Line 6450: bep_code_in IN iby_batches_all.bepcode%TYPE,

6446: batch_status_in IN iby_batches_all.batchstatus%TYPE,
6447: batch_total_in IN iby_batches_all.batchtotal%TYPE,
6448: sale_amount_in IN iby_batches_all.batchsales%TYPE,
6449: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
6450: bep_code_in IN iby_batches_all.bepcode%TYPE,
6451: bep_message_in IN iby_batches_all.bepmessage%TYPE,
6452: error_location_in IN iby_batches_all.errorlocation%TYPE,
6453: ack_type_in IN VARCHAR2,
6454: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,

Line 6451: bep_message_in IN iby_batches_all.bepmessage%TYPE,

6447: batch_total_in IN iby_batches_all.batchtotal%TYPE,
6448: sale_amount_in IN iby_batches_all.batchsales%TYPE,
6449: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
6450: bep_code_in IN iby_batches_all.bepcode%TYPE,
6451: bep_message_in IN iby_batches_all.bepmessage%TYPE,
6452: error_location_in IN iby_batches_all.errorlocation%TYPE,
6453: ack_type_in IN VARCHAR2,
6454: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
6455: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,

Line 6452: error_location_in IN iby_batches_all.errorlocation%TYPE,

6448: sale_amount_in IN iby_batches_all.batchsales%TYPE,
6449: credit_amount_in IN iby_batches_all.batchcredit%TYPE,
6450: bep_code_in IN iby_batches_all.bepcode%TYPE,
6451: bep_message_in IN iby_batches_all.bepmessage%TYPE,
6452: error_location_in IN iby_batches_all.errorlocation%TYPE,
6453: ack_type_in IN VARCHAR2,
6454: trxn_orderid_in IN JTF_VARCHAR2_TABLE_100,
6455: trxn_reqtype_in IN JTF_VARCHAR2_TABLE_100,
6456: trxn_status_in IN JTF_VARCHAR2_TABLE_100,

Line 6532: UPDATE iby_batches_all

6528: print_debuginfo(l_module,'bep_code_in:'|| bep_code_in);
6529: print_debuginfo(l_module,'bep_message_in:'|| bep_message_in);
6530: END IF;
6531:
6532: UPDATE iby_batches_all
6533: SET batchstatus = batch_status_in,
6534: batchtotal = batch_total_in,
6535: batchsales = sale_amount_in,
6536: batchcredit = credit_amount_in,

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

6661: ** Purpose: retrieve mBatchid from iby_Batch table based on Batchid
6662: */
6663:
6664:
6665: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,
6666: i_Payeeid in iby_Batches_all.Payeeid%type,
6667: o_mBatchid out nocopy iby_Batches_all.mBatchid%type)
6668: is
6669: cursor c_get_mBatchid(ci_Batchid iby_Batches_All.Batchid%type,

Line 6666: i_Payeeid in iby_Batches_all.Payeeid%type,

6662: */
6663:
6664:
6665: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,
6666: i_Payeeid in iby_Batches_all.Payeeid%type,
6667: o_mBatchid out nocopy iby_Batches_all.mBatchid%type)
6668: is
6669: cursor c_get_mBatchid(ci_Batchid iby_Batches_All.Batchid%type,
6670: ci_PayeeId iby_batches_all.PayeeID%type)

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

6663:
6664:
6665: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,
6666: i_Payeeid in iby_Batches_all.Payeeid%type,
6667: o_mBatchid out nocopy iby_Batches_all.mBatchid%type)
6668: is
6669: cursor c_get_mBatchid(ci_Batchid iby_Batches_All.Batchid%type,
6670: ci_PayeeId iby_batches_all.PayeeID%type)
6671: is

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

6665: Procedure getMBatchId(i_Batchid in iby_Batches_all.Batchid%type,
6666: i_Payeeid in iby_Batches_all.Payeeid%type,
6667: o_mBatchid out nocopy iby_Batches_all.mBatchid%type)
6668: is
6669: cursor c_get_mBatchid(ci_Batchid iby_Batches_All.Batchid%type,
6670: ci_PayeeId iby_batches_all.PayeeID%type)
6671: is
6672: SELECT mBatchid from iby_Batches_All
6673: WHERE Batchid = ci_Batchid

Line 6670: ci_PayeeId iby_batches_all.PayeeID%type)

6666: i_Payeeid in iby_Batches_all.Payeeid%type,
6667: o_mBatchid out nocopy iby_Batches_all.mBatchid%type)
6668: is
6669: cursor c_get_mBatchid(ci_Batchid iby_Batches_All.Batchid%type,
6670: ci_PayeeId iby_batches_all.PayeeID%type)
6671: is
6672: SELECT mBatchid from iby_Batches_All
6673: WHERE Batchid = ci_Batchid
6674: AND PayeeID = ci_PayeeID;

Line 6672: SELECT mBatchid from iby_Batches_All

6668: is
6669: cursor c_get_mBatchid(ci_Batchid iby_Batches_All.Batchid%type,
6670: ci_PayeeId iby_batches_all.PayeeID%type)
6671: is
6672: SELECT mBatchid from iby_Batches_All
6673: WHERE Batchid = ci_Batchid
6674: AND PayeeID = ci_PayeeID;
6675: BEGIN
6676:

Line 7270: orgid_in IN iby_batches_all.org_id%TYPE,

7266: ecappid_in IN iby_trxn_summaries_all.ecappid%TYPE,
7267: payeeid_in IN iby_trxn_summaries_all.payeeid%TYPE,
7268: bepid_in IN iby_trxn_summaries_all.bepid%TYPE,
7269: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
7270: orgid_in IN iby_batches_all.org_id%TYPE,
7271: seckey_present_in IN VARCHAR2,
7272: trxncount_out OUT NOCOPY NUMBER,
7273: batchid_out OUT NOCOPY iby_batches_all.batchid%TYPE
7274: )

Line 7273: batchid_out OUT NOCOPY iby_batches_all.batchid%TYPE

7269: bepkey_in IN iby_trxn_summaries_all.bepkey%TYPE,
7270: orgid_in IN iby_batches_all.org_id%TYPE,
7271: seckey_present_in IN VARCHAR2,
7272: trxncount_out OUT NOCOPY NUMBER,
7273: batchid_out OUT NOCOPY iby_batches_all.batchid%TYPE
7274: )
7275: IS
7276:
7277: l_max_batch_size iby_bepinfo.max_batch_size%TYPE;

Line 7278: l_mbatch_id iby_batches_all.mbatchid%TYPE;

7274: )
7275: IS
7276:
7277: l_max_batch_size iby_bepinfo.max_batch_size%TYPE;
7278: l_mbatch_id iby_batches_all.mbatchid%TYPE;
7279:
7280: CURSOR c_trxn_count
7281: (
7282: ci_ecappid iby_trxn_summaries_all.ecappid%TYPE,

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

7341: IF (l_max_batch_size<=trxncount_out) THEN
7342: --
7343: -- lock required to ensure only 1 batch close occurs after
7344: -- the maximum size is surpassed among all competing concurrent
7345: -- threads; lock both tables (even though iby_batches_all
7346: -- is sufficient) so as to ensure no deadlock can happen
7347: -- later
7348: --
7349: --LOCK TABLE iby_batches_all, iby_trxn_summaries_all

Line 7349: --LOCK TABLE iby_batches_all, iby_trxn_summaries_all

7345: -- threads; lock both tables (even though iby_batches_all
7346: -- is sufficient) so as to ensure no deadlock can happen
7347: -- later
7348: --
7349: --LOCK TABLE iby_batches_all, iby_trxn_summaries_all
7350: --IN EXCLUSIVE MODE;
7351:
7352: -- check batch size once more to ensure another thread has
7353: -- not closed it between the last check and possession of

Line 7441: mbatchid_in IN iby_batches_all.mbatchid%TYPE

7437: | NOTES:
7438: |
7439: *---------------------------------------------------------------------*/
7440: PROCEDURE Update_Payer_Notif_Batch(
7441: mbatchid_in IN iby_batches_all.mbatchid%TYPE
7442: ) IS
7443:
7444: l_process_profile iby_batches_all.process_profile_code%TYPE;
7445: l_payer_notif_flag VARCHAR2(1);

Line 7444: l_process_profile iby_batches_all.process_profile_code%TYPE;

7440: PROCEDURE Update_Payer_Notif_Batch(
7441: mbatchid_in IN iby_batches_all.mbatchid%TYPE
7442: ) IS
7443:
7444: l_process_profile iby_batches_all.process_profile_code%TYPE;
7445: l_payer_notif_flag VARCHAR2(1);
7446: l_instrument_type iby_batches_all.instrument_type%TYPE;
7447:
7448:

Line 7446: l_instrument_type iby_batches_all.instrument_type%TYPE;

7442: ) IS
7443:
7444: l_process_profile iby_batches_all.process_profile_code%TYPE;
7445: l_payer_notif_flag VARCHAR2(1);
7446: l_instrument_type iby_batches_all.instrument_type%TYPE;
7447:
7448:
7449: CURSOR c_payer_notif_cc (c_user_profile iby_fndcpt_user_cc_pf_b.user_cc_profile_code%TYPE) IS
7450: SELECT DECODE(payer_notification_format, null, 'N', 'Y')

Line 7458: iby_batches_all b

7454:
7455: CURSOR c_payer_notif_dc (c_user_profile iby_fndcpt_user_dc_pf_b.user_dc_profile_code%TYPE) IS
7456: SELECT DECODE(payer_notification_format, null, 'N', 'Y')
7457: FROM iby_fndcpt_user_dc_pf_b up, iby_fndcpt_sys_dc_pf_b sp,
7458: iby_batches_all b
7459: WHERE up.sys_dc_profile_code = sp.sys_dc_profile_code
7460: AND up.user_dc_profile_code =c_user_profile;
7461:
7462: CURSOR c_payer_notif_eft (c_user_profile iby_fndcpt_user_eft_pf_b.user_eft_profile_code%TYPE) IS

Line 7465: iby_batches_all b

7461:
7462: CURSOR c_payer_notif_eft (c_user_profile iby_fndcpt_user_eft_pf_b.user_eft_profile_code%TYPE) IS
7463: SELECT DECODE(payer_notification_format, null, 'N', 'Y')
7464: FROM iby_fndcpt_user_eft_pf_b up, iby_fndcpt_sys_eft_pf_b sp,
7465: iby_batches_all b
7466: WHERE up.sys_eft_profile_code = sp.sys_eft_profile_code
7467: AND up.user_eft_profile_code = c_user_profile;
7468:
7469: CURSOR c_instr_type(i_mbatchid iby_batches_all.mbatchid%TYPE) IS

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

7465: iby_batches_all b
7466: WHERE up.sys_eft_profile_code = sp.sys_eft_profile_code
7467: AND up.user_eft_profile_code = c_user_profile;
7468:
7469: CURSOR c_instr_type(i_mbatchid iby_batches_all.mbatchid%TYPE) IS
7470: SELECT instrument_type, process_profile_code
7471: FROM iby_batches_all
7472: WHERE mbatchid = i_mbatchid;
7473:

Line 7471: FROM iby_batches_all

7467: AND up.user_eft_profile_code = c_user_profile;
7468:
7469: CURSOR c_instr_type(i_mbatchid iby_batches_all.mbatchid%TYPE) IS
7470: SELECT instrument_type, process_profile_code
7471: FROM iby_batches_all
7472: WHERE mbatchid = i_mbatchid;
7473:
7474: BEGIN
7475:

Line 7508: UPDATE iby_batches_all

7504: -- set the payer_notification_required flag to yes
7505: -- if the payer_notification_format is defined for the FCPP
7506: -- at batch and trxn level and if the batch is successfull.
7507: -- Only for settlement trxn
7508: UPDATE iby_batches_all
7509: SET
7510: last_update_date = sysdate,
7511: last_updated_by = fnd_global.user_id,
7512: object_version_number = object_version_number + 1,