eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_TRANSACTIONS_V

Line 262: order_id_in IN iby_transactions_v.order_id%TYPE,

258: PROCEDURE insert_auth_txn
259: (
260: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
261: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
262: order_id_in IN iby_transactions_v.order_id%TYPE,
263: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
264: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
265: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
266: amount_in IN iby_transactions_v.amount%TYPE,

Line 263: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

259: (
260: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
261: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
262: order_id_in IN iby_transactions_v.order_id%TYPE,
263: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
264: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
265: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
266: amount_in IN iby_transactions_v.amount%TYPE,
267: currency_in IN iby_transactions_v.currency%TYPE,

Line 264: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

260: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
261: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
262: order_id_in IN iby_transactions_v.order_id%TYPE,
263: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
264: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
265: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
266: amount_in IN iby_transactions_v.amount%TYPE,
267: currency_in IN iby_transactions_v.currency%TYPE,
268: status_in IN iby_transactions_v.status%TYPE,

Line 265: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

261: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
262: order_id_in IN iby_transactions_v.order_id%TYPE,
263: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
264: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
265: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
266: amount_in IN iby_transactions_v.amount%TYPE,
267: currency_in IN iby_transactions_v.currency%TYPE,
268: status_in IN iby_transactions_v.status%TYPE,
269: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,

Line 266: amount_in IN iby_transactions_v.amount%TYPE,

262: order_id_in IN iby_transactions_v.order_id%TYPE,
263: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
264: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
265: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
266: amount_in IN iby_transactions_v.amount%TYPE,
267: currency_in IN iby_transactions_v.currency%TYPE,
268: status_in IN iby_transactions_v.status%TYPE,
269: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
270: payment_name_in IN iby_transactions_v.payment_name%TYPE,

Line 267: currency_in IN iby_transactions_v.currency%TYPE,

263: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
264: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
265: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
266: amount_in IN iby_transactions_v.amount%TYPE,
267: currency_in IN iby_transactions_v.currency%TYPE,
268: status_in IN iby_transactions_v.status%TYPE,
269: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
270: payment_name_in IN iby_transactions_v.payment_name%TYPE,
271: payment_type_in IN iby_transactions_v.payment_type%TYPE,

Line 268: status_in IN iby_transactions_v.status%TYPE,

264: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
265: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
266: amount_in IN iby_transactions_v.amount%TYPE,
267: currency_in IN iby_transactions_v.currency%TYPE,
268: status_in IN iby_transactions_v.status%TYPE,
269: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
270: payment_name_in IN iby_transactions_v.payment_name%TYPE,
271: payment_type_in IN iby_transactions_v.payment_type%TYPE,
272: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,

Line 269: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,

265: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
266: amount_in IN iby_transactions_v.amount%TYPE,
267: currency_in IN iby_transactions_v.currency%TYPE,
268: status_in IN iby_transactions_v.status%TYPE,
269: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
270: payment_name_in IN iby_transactions_v.payment_name%TYPE,
271: payment_type_in IN iby_transactions_v.payment_type%TYPE,
272: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
273: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,

Line 270: payment_name_in IN iby_transactions_v.payment_name%TYPE,

266: amount_in IN iby_transactions_v.amount%TYPE,
267: currency_in IN iby_transactions_v.currency%TYPE,
268: status_in IN iby_transactions_v.status%TYPE,
269: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
270: payment_name_in IN iby_transactions_v.payment_name%TYPE,
271: payment_type_in IN iby_transactions_v.payment_type%TYPE,
272: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
273: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,

Line 271: payment_type_in IN iby_transactions_v.payment_type%TYPE,

267: currency_in IN iby_transactions_v.currency%TYPE,
268: status_in IN iby_transactions_v.status%TYPE,
269: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
270: payment_name_in IN iby_transactions_v.payment_name%TYPE,
271: payment_type_in IN iby_transactions_v.payment_type%TYPE,
272: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
273: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,

Line 272: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,

268: status_in IN iby_transactions_v.status%TYPE,
269: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
270: payment_name_in IN iby_transactions_v.payment_name%TYPE,
271: payment_type_in IN iby_transactions_v.payment_type%TYPE,
272: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
273: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
276: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,

Line 273: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,

269: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
270: payment_name_in IN iby_transactions_v.payment_name%TYPE,
271: payment_type_in IN iby_transactions_v.payment_type%TYPE,
272: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
273: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
276: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
277: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,

Line 274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,

270: payment_name_in IN iby_transactions_v.payment_name%TYPE,
271: payment_type_in IN iby_transactions_v.payment_type%TYPE,
272: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
273: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
276: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
277: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
278: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,

Line 275: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,

271: payment_type_in IN iby_transactions_v.payment_type%TYPE,
272: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
273: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
276: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
277: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
278: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
279: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,

Line 276: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,

272: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
273: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
276: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
277: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
278: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
279: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
280: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,

Line 277: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,

273: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
276: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
277: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
278: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
279: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
280: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
281: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,

Line 278: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,

274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
276: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
277: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
278: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
279: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
280: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
281: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
282: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,

Line 279: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,

275: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
276: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
277: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
278: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
279: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
280: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
281: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
282: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
283: billeracct_in IN iby_tangible.acctno%type,

Line 280: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,

276: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
277: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
278: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
279: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
280: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
281: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
282: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
283: billeracct_in IN iby_tangible.acctno%type,
284: refinfo_in IN iby_tangible.refinfo%type,

Line 281: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,

277: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
278: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
279: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
280: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
281: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
282: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
283: billeracct_in IN iby_tangible.acctno%type,
284: refinfo_in IN iby_tangible.refinfo%type,
285: memo_in IN iby_tangible.memo%type,

Line 340: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,

336: trxnid_in IN iby_trxn_summaries_all.transactionid%TYPE,
337: status_in IN iby_trxn_summaries_all.status%TYPE,
338: trxntype_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
339: revised_amt_in IN iby_trxn_summaries_all.amount%TYPE,
340: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
341: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
342: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
343: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
344: cvv2result_in IN iby_trxn_core.CVV2Result%type,

Line 341: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,

337: status_in IN iby_trxn_summaries_all.status%TYPE,
338: trxntype_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
339: revised_amt_in IN iby_trxn_summaries_all.amount%TYPE,
340: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
341: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
342: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
343: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
344: cvv2result_in IN iby_trxn_core.CVV2Result%type,
345: bepcode_in IN iby_trxn_summaries_all.bepcode%TYPE,

Line 342: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,

338: trxntype_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
339: revised_amt_in IN iby_trxn_summaries_all.amount%TYPE,
340: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
341: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
342: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
343: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
344: cvv2result_in IN iby_trxn_core.CVV2Result%type,
345: bepcode_in IN iby_trxn_summaries_all.bepcode%TYPE,
346: bepmessage_in IN iby_trxn_summaries_all.bepmessage%TYPE,

Line 343: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,

339: revised_amt_in IN iby_trxn_summaries_all.amount%TYPE,
340: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
341: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
342: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
343: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
344: cvv2result_in IN iby_trxn_core.CVV2Result%type,
345: bepcode_in IN iby_trxn_summaries_all.bepcode%TYPE,
346: bepmessage_in IN iby_trxn_summaries_all.bepmessage%TYPE,
347: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,

Line 364: order_id_in IN iby_transactions_v.order_id%TYPE,

360: PROCEDURE insert_other_txn
361: (
362: ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
363: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
364: order_id_in IN iby_transactions_v.order_id%TYPE,
365: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
366: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
367: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
368: status_in IN iby_transactions_v.status%TYPE,

Line 365: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

361: (
362: ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
363: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
364: order_id_in IN iby_transactions_v.order_id%TYPE,
365: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
366: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
367: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
368: status_in IN iby_transactions_v.status%TYPE,
369: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,

Line 366: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

362: ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
363: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
364: order_id_in IN iby_transactions_v.order_id%TYPE,
365: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
366: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
367: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
368: status_in IN iby_transactions_v.status%TYPE,
369: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
370: payment_type_in IN iby_transactions_v.payment_type%TYPE,

Line 367: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

363: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
364: order_id_in IN iby_transactions_v.order_id%TYPE,
365: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
366: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
367: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
368: status_in IN iby_transactions_v.status%TYPE,
369: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
370: payment_type_in IN iby_transactions_v.payment_type%TYPE,
371: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,

Line 368: status_in IN iby_transactions_v.status%TYPE,

364: order_id_in IN iby_transactions_v.order_id%TYPE,
365: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
366: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
367: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
368: status_in IN iby_transactions_v.status%TYPE,
369: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
370: payment_type_in IN iby_transactions_v.payment_type%TYPE,
371: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
372: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,

Line 369: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,

365: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
366: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
367: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
368: status_in IN iby_transactions_v.status%TYPE,
369: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
370: payment_type_in IN iby_transactions_v.payment_type%TYPE,
371: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
372: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
373: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,

Line 370: payment_type_in IN iby_transactions_v.payment_type%TYPE,

366: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
367: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
368: status_in IN iby_transactions_v.status%TYPE,
369: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
370: payment_type_in IN iby_transactions_v.payment_type%TYPE,
371: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
372: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
373: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
374: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,

Line 371: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,

367: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
368: status_in IN iby_transactions_v.status%TYPE,
369: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
370: payment_type_in IN iby_transactions_v.payment_type%TYPE,
371: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
372: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
373: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
374: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
375: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,

Line 372: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,

368: status_in IN iby_transactions_v.status%TYPE,
369: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
370: payment_type_in IN iby_transactions_v.payment_type%TYPE,
371: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
372: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
373: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
374: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
375: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
376: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,

Line 373: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,

369: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
370: payment_type_in IN iby_transactions_v.payment_type%TYPE,
371: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
372: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
373: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
374: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
375: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
376: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
377: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,

Line 374: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,

370: payment_type_in IN iby_transactions_v.payment_type%TYPE,
371: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
372: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
373: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
374: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
375: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
376: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
377: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
378: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,

Line 375: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,

371: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
372: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
373: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
374: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
375: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
376: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
377: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
378: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
379: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,

Line 376: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,

372: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
373: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
374: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
375: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
376: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
377: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
378: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
379: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
380: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,

Line 377: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,

373: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
374: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
375: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
376: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
377: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
378: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
379: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
380: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
381: billeracct_in IN iby_tangible.acctno%type,

Line 378: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,

374: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
375: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
376: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
377: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
378: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
379: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
380: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
381: billeracct_in IN iby_tangible.acctno%type,
382: refinfo_in IN iby_tangible.refinfo%type,

Line 379: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,

375: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
376: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
377: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
378: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
379: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
380: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
381: billeracct_in IN iby_tangible.acctno%type,
382: refinfo_in IN iby_tangible.refinfo%type,
383: memo_in IN iby_tangible.memo%type,

Line 424: order_id_in IN iby_transactions_v.order_id%TYPE,

420:
421: PROCEDURE insert_timeout_txn
422: (
423: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
424: order_id_in IN iby_transactions_v.order_id%TYPE,
425: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
426: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
427: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
428: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,

Line 425: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

421: PROCEDURE insert_timeout_txn
422: (
423: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
424: order_id_in IN iby_transactions_v.order_id%TYPE,
425: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
426: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
427: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
428: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
429: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,

Line 426: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

422: (
423: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
424: order_id_in IN iby_transactions_v.order_id%TYPE,
425: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
426: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
427: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
428: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
429: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
430: status_in IN iby_transactions_v.status%TYPE,

Line 427: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

423: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
424: order_id_in IN iby_transactions_v.order_id%TYPE,
425: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
426: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
427: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
428: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
429: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
430: status_in IN iby_transactions_v.status%TYPE,
431: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,

Line 429: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,

425: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
426: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
427: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
428: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
429: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
430: status_in IN iby_transactions_v.status%TYPE,
431: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
432: amount_in IN iby_tangible.amount%type,
433: currency_in IN iby_tangible.currencynamecode%type,

Line 430: status_in IN iby_transactions_v.status%TYPE,

426: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
427: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
428: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
429: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
430: status_in IN iby_transactions_v.status%TYPE,
431: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
432: amount_in IN iby_tangible.amount%type,
433: currency_in IN iby_tangible.currencynamecode%type,
434: billeracct_in IN iby_tangible.acctno%type,

Line 462: (order_id_in IN iby_transactions_v.order_id%TYPE,

458: /* procedures before inserting a new row into the transactions */
459: /* table */
460:
461: FUNCTION checkrows
462: (order_id_in IN iby_transactions_v.order_id%TYPE,
463: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
464: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
465: status_in IN iby_transactions_v.status%TYPE,
466: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)

Line 463: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

459: /* table */
460:
461: FUNCTION checkrows
462: (order_id_in IN iby_transactions_v.order_id%TYPE,
463: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
464: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
465: status_in IN iby_transactions_v.status%TYPE,
466: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)
467: RETURN number;

Line 464: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

460:
461: FUNCTION checkrows
462: (order_id_in IN iby_transactions_v.order_id%TYPE,
463: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
464: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
465: status_in IN iby_transactions_v.status%TYPE,
466: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)
467: RETURN number;
468:

Line 465: status_in IN iby_transactions_v.status%TYPE,

461: FUNCTION checkrows
462: (order_id_in IN iby_transactions_v.order_id%TYPE,
463: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
464: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
465: status_in IN iby_transactions_v.status%TYPE,
466: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)
467: RETURN number;
468:
469:

Line 466: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)

462: (order_id_in IN iby_transactions_v.order_id%TYPE,
463: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
464: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
465: status_in IN iby_transactions_v.status%TYPE,
466: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)
467: RETURN number;
468:
469:
470:

Line 608: order_id_in IN iby_transactions_v.order_id%TYPE,

604: /* Inserts the transaction record for the closebatch operation */
605:
606: PROCEDURE insert_batch_txn
607: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
608: order_id_in IN iby_transactions_v.order_id%TYPE,
609: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
610: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
611: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
612: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

Line 609: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

605:
606: PROCEDURE insert_batch_txn
607: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
608: order_id_in IN iby_transactions_v.order_id%TYPE,
609: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
610: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
611: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
612: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
613: status_in IN iby_transactions_v.status%TYPE,

Line 610: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,

606: PROCEDURE insert_batch_txn
607: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
608: order_id_in IN iby_transactions_v.order_id%TYPE,
609: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
610: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
611: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
612: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
613: status_in IN iby_transactions_v.status%TYPE,
614: time_in IN iby_transactions_v.time%TYPE

Line 611: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

607: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
608: order_id_in IN iby_transactions_v.order_id%TYPE,
609: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
610: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
611: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
612: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
613: status_in IN iby_transactions_v.status%TYPE,
614: time_in IN iby_transactions_v.time%TYPE
615: DEFAULT sysdate,

Line 612: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

608: order_id_in IN iby_transactions_v.order_id%TYPE,
609: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
610: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
611: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
612: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
613: status_in IN iby_transactions_v.status%TYPE,
614: time_in IN iby_transactions_v.time%TYPE
615: DEFAULT sysdate,
616: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

Line 613: status_in IN iby_transactions_v.status%TYPE,

609: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
610: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
611: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
612: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
613: status_in IN iby_transactions_v.status%TYPE,
614: time_in IN iby_transactions_v.time%TYPE
615: DEFAULT sysdate,
616: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
617: vendor_code_in IN iby_transactions_v.vendor_code%TYPE

Line 614: time_in IN iby_transactions_v.time%TYPE

610: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
611: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
612: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
613: status_in IN iby_transactions_v.status%TYPE,
614: time_in IN iby_transactions_v.time%TYPE
615: DEFAULT sysdate,
616: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
617: vendor_code_in IN iby_transactions_v.vendor_code%TYPE
618: DEFAULT NULL,

Line 616: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

612: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
613: status_in IN iby_transactions_v.status%TYPE,
614: time_in IN iby_transactions_v.time%TYPE
615: DEFAULT sysdate,
616: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
617: vendor_code_in IN iby_transactions_v.vendor_code%TYPE
618: DEFAULT NULL,
619: vendor_message_in IN iby_transactions_v.vendor_message%TYPE
620: DEFAULT NULL,

Line 617: vendor_code_in IN iby_transactions_v.vendor_code%TYPE

613: status_in IN iby_transactions_v.status%TYPE,
614: time_in IN iby_transactions_v.time%TYPE
615: DEFAULT sysdate,
616: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
617: vendor_code_in IN iby_transactions_v.vendor_code%TYPE
618: DEFAULT NULL,
619: vendor_message_in IN iby_transactions_v.vendor_message%TYPE
620: DEFAULT NULL,
621: error_location_in IN iby_transactions_v.error_location%TYPE

Line 619: vendor_message_in IN iby_transactions_v.vendor_message%TYPE

615: DEFAULT sysdate,
616: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
617: vendor_code_in IN iby_transactions_v.vendor_code%TYPE
618: DEFAULT NULL,
619: vendor_message_in IN iby_transactions_v.vendor_message%TYPE
620: DEFAULT NULL,
621: error_location_in IN iby_transactions_v.error_location%TYPE
622: DEFAULT NULL,
623: trace_number_in IN iby_transactions_v.TraceNumber%TYPE

Line 621: error_location_in IN iby_transactions_v.error_location%TYPE

617: vendor_code_in IN iby_transactions_v.vendor_code%TYPE
618: DEFAULT NULL,
619: vendor_message_in IN iby_transactions_v.vendor_message%TYPE
620: DEFAULT NULL,
621: error_location_in IN iby_transactions_v.error_location%TYPE
622: DEFAULT NULL,
623: trace_number_in IN iby_transactions_v.TraceNumber%TYPE
624: DEFAULT NULL,
625:

Line 623: trace_number_in IN iby_transactions_v.TraceNumber%TYPE

619: vendor_message_in IN iby_transactions_v.vendor_message%TYPE
620: DEFAULT NULL,
621: error_location_in IN iby_transactions_v.error_location%TYPE
622: DEFAULT NULL,
623: trace_number_in IN iby_transactions_v.TraceNumber%TYPE
624: DEFAULT NULL,
625:
626: org_id_in IN iby_trxn_summaries_all.org_id%type
627: DEFAULT NULL,

Line 636: order_id_in IN iby_transactions_v.order_id%TYPE,

632:
633:
634: PROCEDURE insert_query_txn
635: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
636: order_id_in IN iby_transactions_v.order_id%TYPE,
637: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
638: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
639: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
640: status_in IN iby_transactions_v.status%TYPE,

Line 637: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

633:
634: PROCEDURE insert_query_txn
635: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
636: order_id_in IN iby_transactions_v.order_id%TYPE,
637: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
638: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
639: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
640: status_in IN iby_transactions_v.status%TYPE,
641: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,

Line 638: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

634: PROCEDURE insert_query_txn
635: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
636: order_id_in IN iby_transactions_v.order_id%TYPE,
637: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
638: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
639: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
640: status_in IN iby_transactions_v.status%TYPE,
641: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
642: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

Line 639: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

635: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
636: order_id_in IN iby_transactions_v.order_id%TYPE,
637: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
638: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
639: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
640: status_in IN iby_transactions_v.status%TYPE,
641: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
642: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
643: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,

Line 640: status_in IN iby_transactions_v.status%TYPE,

636: order_id_in IN iby_transactions_v.order_id%TYPE,
637: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
638: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
639: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
640: status_in IN iby_transactions_v.status%TYPE,
641: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
642: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
643: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
644: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,

Line 641: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,

637: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
638: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
639: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
640: status_in IN iby_transactions_v.status%TYPE,
641: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
642: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
643: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
644: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
645: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,

Line 642: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

638: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
639: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
640: status_in IN iby_transactions_v.status%TYPE,
641: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
642: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
643: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
644: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
645: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
646: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,

Line 643: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,

639: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
640: status_in IN iby_transactions_v.status%TYPE,
641: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
642: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
643: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
644: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
645: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
646: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
647: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,

Line 644: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,

640: status_in IN iby_transactions_v.status%TYPE,
641: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
642: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
643: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
644: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
645: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
646: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
647: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
648: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,

Line 645: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,

641: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
642: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
643: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
644: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
645: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
646: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
647: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
648: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
649: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,

Line 646: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,

642: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
643: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
644: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
645: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
646: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
647: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
648: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
649: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
650: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,

Line 647: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,

643: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
644: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
645: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
646: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
647: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
648: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
649: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
650: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
651: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,

Line 648: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,

644: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
645: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
646: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
647: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
648: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
649: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
650: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
651: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
652: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,

Line 649: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,

645: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
646: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
647: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
648: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
649: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
650: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
651: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
652: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
653: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,

Line 650: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,

646: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
647: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
648: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
649: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
650: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
651: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
652: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
653: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
654: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,

Line 651: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,

647: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
648: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
649: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
650: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
651: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
652: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
653: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
654: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
655: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,

Line 652: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,

648: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
649: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
650: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
651: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
652: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
653: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
654: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
655: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
656: ecappid_in IN iby_ecapp.ecappid%type,

Line 653: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,

649: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
650: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
651: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
652: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
653: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
654: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
655: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
656: ecappid_in IN iby_ecapp.ecappid%type,
657: req_type_in IN iby_trxn_summaries_all.reqtype%type);

Line 654: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,

650: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
651: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
652: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
653: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
654: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
655: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
656: ecappid_in IN iby_ecapp.ecappid%type,
657: req_type_in IN iby_trxn_summaries_all.reqtype%type);
658: