DBA Data[Home] [Help]

APPS.IBY_OFFLINEDB_PKG dependencies on IBY_ACCPPMTMTHD_PKG

Line 130: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);

126: INTO l_mid
127: FROM dual;
128:
129: -- insert the scheduled request in the summary and core tables
130: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
131: INSERT INTO iby_trxn_summaries_all
132: (TrxnMID, TransactionID, TangibleID,
133: MPayeeID, PayeeID,BEPID, bepkey, ECAppID, PaymentMethodName,
134: PayerID, PayerInstrID, Amount,CurrencyNameCode,

Line 247: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);

243: where transactionid = i_transactionid
244: and reqtype = i_reqtype_tocancel
245: and rownum < 2;
246:
247: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
248:
249: INSERT INTO iby_trxn_summaries_all
250: (TrxnMID, TransactionID, TangibleID,
251: MPayeeID, PayeeID,BEPID, bepkey, ECAppID, PaymentMethodName,

Line 316: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);

312: SELECT iby_batches_s.NEXTVAL
313: INTO l_mbatchid
314: FROM dual;
315:
316: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
317: -- Bug:8363526. : Inserting value for new column iby_batches_all
318: -- Inserted column settledate value will be sysdate.
319: INSERT INTO iby_batches_all
320: (MBatchID, BatchID, MPayeeID, PayeeID, BEPID, bepkey, ECAppID,

Line 434: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);

430: INTO l_mid
431: FROM dual;
432:
433: -- insert the scheduled request in the summary and core tables
434: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
435: iby_transactioncc_pkg.getMBatchId(batchid, i_payeeid, l_mbatchid);
436: INSERT INTO iby_trxn_summaries_all
437: (TrxnMID, TransactionID, TangibleID,
438: MPayeeID, PayeeID,BEPID, ECAppID, PaymentMethodName,

Line 510: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);

506: SELECT iby_trxnsumm_mid_s.NEXTVAL
507: INTO l_mid
508: FROM dual;
509:
510: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
511: INSERT INTO iby_trxn_summaries_all
512: (TrxnMID, TransactionID, TangibleID,
513: MPayeeID, PayeeID,BEPID, ECAppID, PaymentMethodName, status,
514: last_update_date, updatedate, last_updated_by, creation_date, created_by,

Line 608: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);

604: INTO l_mid
605: FROM dual;
606: -- insert the scheduled request in the summary and core tables
607: iby_transactioncc_pkg.getMBatchId(batchid, i_payeeid, l_mbatchid);
608: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
609: INSERT INTO iby_trxn_summaries_all
610: (TrxnMID, TransactionID, TangibleID,
611: MPayeeID, PayeeID,BEPID, ECAppID, PaymentMethodName,
612: PayerID, PayerInstrID, Amount,CurrencyNameCode,

Line 687: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);

683: -- insert the request into the batch table
684: SELECT iby_batches_s.NEXTVAL
685: INTO l_mbatchid
686: FROM dual;
687: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
688: -- Bug: 8363526: Inserted new column settledate for tableiby_batches_all
689: INSERT INTO iby_batches_all
690: (MBatchID, BatchID, MPayeeID, PayeeID, BEPID, ECAppID,
691: ReqType, ReqDate, DestUrl, PaymentMethodName,