APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_BEPINFO

Line 1514: l_beptype iby_bepinfo.bep_type%TYPE;

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

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

1548:
1549: l_batchcurr := currency_in;
1550: l_trxncount := numtrxns_in;
1551:
1552: SELECT NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)
1553: INTO l_beptype
1554: FROM iby_bepinfo
1555: WHERE (bepid=vendor_id_in);
1556:

Line 1554: FROM iby_bepinfo

1550: l_trxncount := numtrxns_in;
1551:
1552: SELECT NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)
1553: INTO l_beptype
1554: FROM iby_bepinfo
1555: WHERE (bepid=vendor_id_in);
1556:
1557: --
1558: -- if the bep is a processor, then we create a batch

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

1556:
1557: --
1558: -- if the bep is a processor, then we create a batch
1559: --
1560: IF ( (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND
1561: ((req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR
1562: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)))
1563: THEN
1564:

Line 1764: l_beptype iby_bepinfo.bep_type%TYPE;

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

Line 1849: NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)

1845: l_batchcurr := currency_in;
1846: l_trxncount := numtrxns_in;
1847:
1848: SELECT
1849: NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)
1850: INTO
1851: l_beptype
1852: FROM
1853: IBY_BEPINFO

Line 1853: IBY_BEPINFO

1849: NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)
1850: INTO
1851: l_beptype
1852: FROM
1853: IBY_BEPINFO
1854: WHERE
1855: (bepid=vendor_id_in)
1856: ;
1857:

Line 1866: (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND

1862: --
1863: -- if the bep is a processor, then we create a batch
1864: --
1865: IF (
1866: (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND
1867: (
1868: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR
1869: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)
1870: )

Line 2397: l_beptype iby_bepinfo.bep_type%TYPE;

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

Line 2513: NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)

2509: l_batchcurr := currency_in;-- should be made NULL
2510: l_trxncount := numtrxns_in;
2511:
2512: SELECT
2513: NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)
2514: INTO
2515: l_beptype
2516: FROM
2517: IBY_BEPINFO

Line 2517: IBY_BEPINFO

2513: NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)
2514: INTO
2515: l_beptype
2516: FROM
2517: IBY_BEPINFO
2518: WHERE
2519: (bepid=vendor_id_in)
2520: ;
2521:

Line 2530: (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND

2526: --
2527: -- if the bep is a processor, then we create a batch
2528: --
2529: IF (
2530: (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND
2531: (
2532: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR
2533: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)
2534: )

Line 7277: l_max_batch_size iby_bepinfo.max_batch_size%TYPE;

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;
7278: l_mbatch_id iby_batches_all.mbatchid%TYPE;
7279:
7280: CURSOR c_trxn_count
7281: (

Line 7307: FROM iby_bepinfo

7303: OR instrtype IS NULL);
7304:
7305: CURSOR c_max_bsize(ci_bepid iby_trxn_summaries_all.bepid%TYPE) IS
7306: SELECT NVL(max_batch_size,-1)
7307: FROM iby_bepinfo
7308: WHERE (ci_bepid=bepid);
7309:
7310: BEGIN
7311: IF (c_trxn_count%ISOPEN) THEN