392: WHERE TangibleID = order_id_in
393: AND UPPER(ReqType) = UPPER(req_type_in)
394: AND PayeeID = merchant_id_in;
395:
396: iby_transactioncc_pkg.getMBatchID(batch_id_in, merchant_id_in,
397: l_mbatchid);
398:
399:
400: IF (UPPER(req_type_in) = 'ORAPMTCREDIT') THEN
589: transaction_id := transaction_id_in_out;
590: END IF;
591:
592: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
593: iby_transactioncc_pkg.getMBatchID(batch_id_in, merchant_id_in,
594: l_mbatchid);
595: /*
596: ** Create an entry in iby_tangible table
597: */
657: WHERE TangibleID = order_id_in
658: AND UPPER(ReqType) = UPPER(req_type_in)
659: AND PayeeID = merchant_id_in;
660:
661: iby_transactioncc_pkg.getMBatchID(batch_id_in, merchant_id_in,
662: l_mbatchid);
663:
664: --Update iby_tangible table
665: iby_bill_pkg.modBill(l_tmid,order_id_in,price_in,currency_in,
853:
854: transaction_id := transaction_id_in_out;
855: END IF;
856:
857: iby_transactioncc_pkg.getMBatchID(batch_id_in, merchant_id_in,
858: l_mbatchid);
859: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
860:
861:
922: AND extended.SplitID = split_id_in
923: AND UPPER(summary.ReqType) = UPPER(req_type_in)
924: AND summary.TrxnMID = extended.TrxnMID;
925:
926: iby_transactioncc_pkg.getMBatchID(batch_id_in, merchant_id_in,
927: l_mbatchid);
928:
929: IF (UPPER(req_type_in) = 'ORAPMTCREDIT') THEN
930: -- Update iby_tangible table
1328: END IF;
1329: -- Insert new row
1330: -- generate TransactionID
1331:
1332: iby_transactioncc_pkg.getMBatchID(batch_id_in, merchant_id_in,
1333: l_mbatchid);
1334: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
1335: INSERT INTO iby_trxn_summaries_all
1336: (TrxnMID, TangibleID,MPayeeID, PayeeID,BEPID,