347: l_mbatchid
348: FROM
349: DUAL;
350:
351: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
352: -- Bug:8363526 : Inserting new column settledate VALUE:sysdate
353: INSERT INTO iby_batches_all
354: (MBATCHID,
355: BATCHID,
650: FROM
651: DUAL;
652: */
653:
654: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
655:
656: IF (l_batches_tab.COUNT <> 0) THEN
657:
658: FOR i IN l_batches_tab.FIRST .. l_batches_tab.LAST LOOP
1105: FROM
1106: DUAL;
1107: */
1108:
1109: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
1110:
1111: IF (l_batches_tab.COUNT <> 0) THEN
1112:
1113: FOR i IN l_batches_tab.FIRST .. l_batches_tab.LAST LOOP
1517:
1518: /**
1519: * Obtain the master payeeid for the given payee.
1520: */
1521: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
1522:
1523: FOR j IN i_tangibleid.FIRST..i_tangibleid.LAST
1524: LOOP
1525: /**
1767: iby_fipayments_pkg.checkInstrId(i_payerinstrid);
1768: END IF;
1769:
1770: -- Get the master payeeid for the given payee
1771: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
1772:
1773: -- this function returns the existing transactionid from the iby_trxn_summaries_all
1774: -- table if one exist for the payeeid and tangibleid, or a new one from the DB
1775: -- sequence if none exists.