DBA Data[Home] [Help]

APPS.IBY_OFFLINEDB_PKG dependencies on IBY_TRANSACTIONCC_PKG

Line 104: io_transactionid := iby_transactioncc_pkg.getTID(

100: raise_application_error(-20000, 'IBY_20512#', FALSE);
101: END IF;
102:
103: -- Get new transaction id
104: io_transactionid := iby_transactioncc_pkg.getTID(
105: i_payeeid, i_tangibleid);
106:
107: iby_bill_pkg.createBill(i_tangibleid, i_amount, i_currency,
108: i_billeracct, i_refinfo, i_memo,

Line 121: l_org_id := iby_transactioncc_pkg.getOrgId(io_transactionid);

117: --and status <> -99 and status <> 14;
118: and (status = 11 or status = 0);
119:
120: -- getOrgId
121: l_org_id := iby_transactioncc_pkg.getOrgId(io_transactionid);
122: END IF;
123:
124: -- Get the master transaction id sequence for all requests
125: SELECT iby_trxnsumm_mid_s.NEXTVAL

Line 421: l_tid := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid);

417: END IF;
418:
419: -- Get the transaction id sequence also
420:
421: l_tid := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid);
422: --SELECT iby_trxnsumm_trxnid_s.NEXTVAL
423: --INTO l_tid
424: --FROM dual;
425: io_transactionid := l_tid;

Line 435: iby_transactioncc_pkg.getMBatchId(batchid, i_payeeid, l_mbatchid);

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,
439: PayerID, PayerInstrID, Amount,CurrencyNameCode,

Line 595: l_tid := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid);

591:
592:
593: -- Get the transaction id sequence also
594:
595: l_tid := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid);
596: --SELECT iby_trxnsumm_trxnid_s.NEXTVAL
597: --INTO l_tid
598: --FROM dual;
599: io_transactionid := l_tid;

Line 607: iby_transactioncc_pkg.getMBatchId(batchid, i_payeeid, l_mbatchid);

603: SELECT iby_trxnsumm_mid_s.NEXTVAL
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,