[Home] [Help]
71: transaction_id := transaction_id_in_out;
72: END IF;
73:
74:
75: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
76:
77:
78: -- Create a new entry in iby_tangible table
79: iby_bill_pkg.createBill(order_id_in,price_in,currency_in,
335: WHERE transactionid = transaction_id_in_out;
336:
337: transaction_id := transaction_id_in_out;
338: END IF;
339: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
340:
341: INSERT INTO iby_trxn_summaries_all
342: (TrxnMID, TransactionID,TrxntypeID,
343: ECAPPID, org_id, ReqType, ReqDate, MtangibleId,
588: ELSE
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
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:
862:
863: INSERT INTO iby_trxn_summaries_all
1039: transaction_id_in_out := transaction_id;
1040:
1041:
1042:
1043: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
1044:
1045: IF (UPPER(req_type_in) = 'ORAPMTREQ' or
1046: UPPER(req_type_in) = 'ORAPMTCREDIT') THEN
1047: -- Create an entry in iby_tangible table
1195: IF (num_trxns = 0)
1196: THEN
1197: -- Insert new batch status row
1198:
1199: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
1200:
1201: SELECT iby_batches_s.NEXTVAL
1202: INTO l_mbatchid
1203: FROM dual;
1331: -- generate TransactionID
1332:
1333: iby_transactioncc_pkg.getMBatchID(batch_id_in, merchant_id_in,
1334: l_mbatchid);
1335: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
1336: INSERT INTO iby_trxn_summaries_all
1337: (TrxnMID, TangibleID,MPayeeID, PayeeID,BEPID,
1338: TrxntypeID, ECAPPID, org_id,
1339: Amount,CurrencyNameCode, UpdateDate,Status,MBatchID, BatchID,
1578: -- FROM dual;
1579: --transaction_id_in_out := transaction_id;
1580:
1581:
1582: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
1583: INSERT INTO iby_trxn_summaries_all
1584: (TrxnMID, TransactionID, paymentMethodName,
1585: TangibleID,MPayeeID, PayeeID,BEPID,
1586: TrxntypeID, ECAPPID, org_id, ReqDate, ReqType,