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 419: l_tid := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid);

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

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

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

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

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

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

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