APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_BEPINFO

Line 1307: l_beptype iby_bepinfo.bep_type%TYPE;

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';
1311: BEGIN

Line 1345: SELECT NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)

1341:
1342: l_batchcurr := currency_in;
1343: l_trxncount := numtrxns_in;
1344:
1345: SELECT NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)
1346: INTO l_beptype
1347: FROM iby_bepinfo
1348: WHERE (bepid=vendor_id_in);
1349:

Line 1347: FROM iby_bepinfo

1343: l_trxncount := numtrxns_in;
1344:
1345: SELECT NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)
1346: INTO l_beptype
1347: FROM iby_bepinfo
1348: WHERE (bepid=vendor_id_in);
1349:
1350: --
1351: -- if the bep is a processor, then we create a batch

Line 1353: IF ( (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND

1349:
1350: --
1351: -- if the bep is a processor, then we create a batch
1352: --
1353: IF ( (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND
1354: ((req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR
1355: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)))
1356: THEN
1357:

Line 1556: l_beptype iby_bepinfo.bep_type%TYPE;

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:
1560: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';

Line 1637: NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)

1633: l_batchcurr := currency_in;
1634: l_trxncount := numtrxns_in;
1635:
1636: SELECT
1637: NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)
1638: INTO
1639: l_beptype
1640: FROM
1641: IBY_BEPINFO

Line 1641: IBY_BEPINFO

1637: NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)
1638: INTO
1639: l_beptype
1640: FROM
1641: IBY_BEPINFO
1642: WHERE
1643: (bepid=vendor_id_in)
1644: ;
1645:

Line 1652: (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND

1648: --
1649: -- if the bep is a processor, then we create a batch
1650: --
1651: IF (
1652: (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND
1653: (
1654: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR
1655: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)
1656: )

Line 2167: l_beptype iby_bepinfo.bep_type%TYPE;

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;
2171: numProfiles NUMBER;

Line 2277: NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)

2273: l_batchcurr := currency_in;-- should be made NULL
2274: l_trxncount := numtrxns_in;
2275:
2276: SELECT
2277: NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)
2278: INTO
2279: l_beptype
2280: FROM
2281: IBY_BEPINFO

Line 2281: IBY_BEPINFO

2277: NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)
2278: INTO
2279: l_beptype
2280: FROM
2281: IBY_BEPINFO
2282: WHERE
2283: (bepid=vendor_id_in)
2284: ;
2285:

Line 2292: (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND

2288: --
2289: -- if the bep is a processor, then we create a batch
2290: --
2291: IF (
2292: (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND
2293: (
2294: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR
2295: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)
2296: )

Line 6780: l_max_batch_size iby_bepinfo.max_batch_size%TYPE;

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;
6781: l_mbatch_id iby_batches_all.mbatchid%TYPE;
6782:
6783: CURSOR c_trxn_count
6784: (

Line 6810: FROM iby_bepinfo

6806: OR instrtype IS NULL);
6807:
6808: CURSOR c_max_bsize(ci_bepid iby_trxn_summaries_all.bepid%TYPE) IS
6809: SELECT NVL(max_batch_size,-1)
6810: FROM iby_bepinfo
6811: WHERE (ci_bepid=bepid);
6812:
6813: BEGIN
6814: IF (c_trxn_count%ISOPEN) THEN