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: INSERT INTO iby_batches_all
318: (MBatchID, BatchID, MPayeeID, PayeeID, BEPID, bepkey, ECAppID,
319: PaymentMethodName, BatchStatus,
320: ReqType, ReqDate, DestUrl,

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

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

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

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

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

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

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

681: -- insert the request into the batch table
682: SELECT iby_batches_s.NEXTVAL
683: INTO l_mbatchid
684: FROM dual;
685: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
686: INSERT INTO iby_batches_all
687: (MBatchID, BatchID, MPayeeID, PayeeID, BEPID, ECAppID,
688: ReqType, ReqDate, DestUrl, PaymentMethodName,
689: Nlslang, TerminalID,