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 268: order_id_in IN iby_transactions_v.order_id%TYPE,

264: PROCEDURE insert_auth_txn
265: (
266: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
267: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
268: order_id_in IN iby_transactions_v.order_id%TYPE,
269: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
270: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
271: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
272: amount_in IN iby_transactions_v.amount%TYPE,

Line 269: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

265: (
266: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
267: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
268: order_id_in IN iby_transactions_v.order_id%TYPE,
269: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
270: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
271: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
272: amount_in IN iby_transactions_v.amount%TYPE,
273: currency_in IN iby_transactions_v.currency%TYPE,

Line 270: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

266: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
267: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
268: order_id_in IN iby_transactions_v.order_id%TYPE,
269: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
270: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
271: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
272: amount_in IN iby_transactions_v.amount%TYPE,
273: currency_in IN iby_transactions_v.currency%TYPE,
274: status_in IN iby_transactions_v.status%TYPE,

Line 271: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

267: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
268: order_id_in IN iby_transactions_v.order_id%TYPE,
269: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
270: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
271: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
272: amount_in IN iby_transactions_v.amount%TYPE,
273: currency_in IN iby_transactions_v.currency%TYPE,
274: status_in IN iby_transactions_v.status%TYPE,
275: time_in IN iby_transactions_v.time%TYPE,

Line 272: amount_in IN iby_transactions_v.amount%TYPE,

268: order_id_in IN iby_transactions_v.order_id%TYPE,
269: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
270: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
271: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
272: amount_in IN iby_transactions_v.amount%TYPE,
273: currency_in IN iby_transactions_v.currency%TYPE,
274: status_in IN iby_transactions_v.status%TYPE,
275: time_in IN iby_transactions_v.time%TYPE,
276: payment_name_in IN iby_transactions_v.payment_name%TYPE,

Line 273: currency_in IN iby_transactions_v.currency%TYPE,

269: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
270: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
271: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
272: amount_in IN iby_transactions_v.amount%TYPE,
273: currency_in IN iby_transactions_v.currency%TYPE,
274: status_in IN iby_transactions_v.status%TYPE,
275: time_in IN iby_transactions_v.time%TYPE,
276: payment_name_in IN iby_transactions_v.payment_name%TYPE,
277: payment_type_in IN iby_transactions_v.payment_type%TYPE,

Line 274: status_in IN iby_transactions_v.status%TYPE,

270: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
271: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
272: amount_in IN iby_transactions_v.amount%TYPE,
273: currency_in IN iby_transactions_v.currency%TYPE,
274: status_in IN iby_transactions_v.status%TYPE,
275: time_in IN iby_transactions_v.time%TYPE,
276: payment_name_in IN iby_transactions_v.payment_name%TYPE,
277: payment_type_in IN iby_transactions_v.payment_type%TYPE,
278: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

Line 275: time_in IN iby_transactions_v.time%TYPE,

271: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
272: amount_in IN iby_transactions_v.amount%TYPE,
273: currency_in IN iby_transactions_v.currency%TYPE,
274: status_in IN iby_transactions_v.status%TYPE,
275: time_in IN iby_transactions_v.time%TYPE,
276: payment_name_in IN iby_transactions_v.payment_name%TYPE,
277: payment_type_in IN iby_transactions_v.payment_type%TYPE,
278: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
279: authcode_in IN iby_transactions_v.authcode%TYPE,

Line 276: payment_name_in IN iby_transactions_v.payment_name%TYPE,

272: amount_in IN iby_transactions_v.amount%TYPE,
273: currency_in IN iby_transactions_v.currency%TYPE,
274: status_in IN iby_transactions_v.status%TYPE,
275: time_in IN iby_transactions_v.time%TYPE,
276: payment_name_in IN iby_transactions_v.payment_name%TYPE,
277: payment_type_in IN iby_transactions_v.payment_type%TYPE,
278: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
279: authcode_in IN iby_transactions_v.authcode%TYPE,
280: referencecode_in IN iby_transactions_v.referencecode%TYPE,

Line 277: payment_type_in IN iby_transactions_v.payment_type%TYPE,

273: currency_in IN iby_transactions_v.currency%TYPE,
274: status_in IN iby_transactions_v.status%TYPE,
275: time_in IN iby_transactions_v.time%TYPE,
276: payment_name_in IN iby_transactions_v.payment_name%TYPE,
277: payment_type_in IN iby_transactions_v.payment_type%TYPE,
278: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
279: authcode_in IN iby_transactions_v.authcode%TYPE,
280: referencecode_in IN iby_transactions_v.referencecode%TYPE,
281: AVScode_in IN iby_transactions_v.AVScode%TYPE,

Line 278: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

274: status_in IN iby_transactions_v.status%TYPE,
275: time_in IN iby_transactions_v.time%TYPE,
276: payment_name_in IN iby_transactions_v.payment_name%TYPE,
277: payment_type_in IN iby_transactions_v.payment_type%TYPE,
278: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
279: authcode_in IN iby_transactions_v.authcode%TYPE,
280: referencecode_in IN iby_transactions_v.referencecode%TYPE,
281: AVScode_in IN iby_transactions_v.AVScode%TYPE,
282: acquirer_in IN iby_transactions_v.acquirer%TYPE,

Line 279: authcode_in IN iby_transactions_v.authcode%TYPE,

275: time_in IN iby_transactions_v.time%TYPE,
276: payment_name_in IN iby_transactions_v.payment_name%TYPE,
277: payment_type_in IN iby_transactions_v.payment_type%TYPE,
278: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
279: authcode_in IN iby_transactions_v.authcode%TYPE,
280: referencecode_in IN iby_transactions_v.referencecode%TYPE,
281: AVScode_in IN iby_transactions_v.AVScode%TYPE,
282: acquirer_in IN iby_transactions_v.acquirer%TYPE,
283: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,

Line 280: referencecode_in IN iby_transactions_v.referencecode%TYPE,

276: payment_name_in IN iby_transactions_v.payment_name%TYPE,
277: payment_type_in IN iby_transactions_v.payment_type%TYPE,
278: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
279: authcode_in IN iby_transactions_v.authcode%TYPE,
280: referencecode_in IN iby_transactions_v.referencecode%TYPE,
281: AVScode_in IN iby_transactions_v.AVScode%TYPE,
282: acquirer_in IN iby_transactions_v.acquirer%TYPE,
283: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
284: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,

Line 281: AVScode_in IN iby_transactions_v.AVScode%TYPE,

277: payment_type_in IN iby_transactions_v.payment_type%TYPE,
278: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
279: authcode_in IN iby_transactions_v.authcode%TYPE,
280: referencecode_in IN iby_transactions_v.referencecode%TYPE,
281: AVScode_in IN iby_transactions_v.AVScode%TYPE,
282: acquirer_in IN iby_transactions_v.acquirer%TYPE,
283: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
284: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
285: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,

Line 282: acquirer_in IN iby_transactions_v.acquirer%TYPE,

278: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
279: authcode_in IN iby_transactions_v.authcode%TYPE,
280: referencecode_in IN iby_transactions_v.referencecode%TYPE,
281: AVScode_in IN iby_transactions_v.AVScode%TYPE,
282: acquirer_in IN iby_transactions_v.acquirer%TYPE,
283: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
284: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
285: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
286: error_location_in IN iby_transactions_v.error_location%TYPE,

Line 283: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,

279: authcode_in IN iby_transactions_v.authcode%TYPE,
280: referencecode_in IN iby_transactions_v.referencecode%TYPE,
281: AVScode_in IN iby_transactions_v.AVScode%TYPE,
282: acquirer_in IN iby_transactions_v.acquirer%TYPE,
283: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
284: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
285: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
286: error_location_in IN iby_transactions_v.error_location%TYPE,
287: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,

Line 284: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,

280: referencecode_in IN iby_transactions_v.referencecode%TYPE,
281: AVScode_in IN iby_transactions_v.AVScode%TYPE,
282: acquirer_in IN iby_transactions_v.acquirer%TYPE,
283: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
284: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
285: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
286: error_location_in IN iby_transactions_v.error_location%TYPE,
287: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
288: org_id_in IN iby_trxn_summaries_all.org_id%type,

Line 285: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,

281: AVScode_in IN iby_transactions_v.AVScode%TYPE,
282: acquirer_in IN iby_transactions_v.acquirer%TYPE,
283: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
284: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
285: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
286: error_location_in IN iby_transactions_v.error_location%TYPE,
287: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
288: org_id_in IN iby_trxn_summaries_all.org_id%type,
289: billeracct_in IN iby_tangible.acctno%type,

Line 286: error_location_in IN iby_transactions_v.error_location%TYPE,

282: acquirer_in IN iby_transactions_v.acquirer%TYPE,
283: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
284: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
285: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
286: error_location_in IN iby_transactions_v.error_location%TYPE,
287: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
288: org_id_in IN iby_trxn_summaries_all.org_id%type,
289: billeracct_in IN iby_tangible.acctno%type,
290: refinfo_in IN iby_tangible.refinfo%type,

Line 287: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,

283: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
284: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
285: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
286: error_location_in IN iby_transactions_v.error_location%TYPE,
287: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
288: org_id_in IN iby_trxn_summaries_all.org_id%type,
289: billeracct_in IN iby_tangible.acctno%type,
290: refinfo_in IN iby_tangible.refinfo%type,
291: memo_in IN iby_tangible.memo%type,

Line 683: order_id_in IN iby_transactions_v.order_id%TYPE,

679:
680: PROCEDURE insert_other_txn
681: ( ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
682: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
683: order_id_in IN iby_transactions_v.order_id%TYPE,
684: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
685: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
686: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
687: status_in IN iby_transactions_v.status%TYPE,

Line 684: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

680: PROCEDURE insert_other_txn
681: ( ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
682: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
683: order_id_in IN iby_transactions_v.order_id%TYPE,
684: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
685: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
686: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
687: status_in IN iby_transactions_v.status%TYPE,
688: time_in IN iby_transactions_v.time%TYPE,

Line 685: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

681: ( ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
682: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
683: order_id_in IN iby_transactions_v.order_id%TYPE,
684: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
685: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
686: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
687: status_in IN iby_transactions_v.status%TYPE,
688: time_in IN iby_transactions_v.time%TYPE,
689: payment_type_in IN iby_transactions_v.payment_type%TYPE,

Line 686: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

682: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
683: order_id_in IN iby_transactions_v.order_id%TYPE,
684: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
685: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
686: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
687: status_in IN iby_transactions_v.status%TYPE,
688: time_in IN iby_transactions_v.time%TYPE,
689: payment_type_in IN iby_transactions_v.payment_type%TYPE,
690: payment_name_in IN iby_transactions_v.payment_name%TYPE,

Line 687: status_in IN iby_transactions_v.status%TYPE,

683: order_id_in IN iby_transactions_v.order_id%TYPE,
684: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
685: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
686: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
687: status_in IN iby_transactions_v.status%TYPE,
688: time_in IN iby_transactions_v.time%TYPE,
689: payment_type_in IN iby_transactions_v.payment_type%TYPE,
690: payment_name_in IN iby_transactions_v.payment_name%TYPE,
691: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

Line 688: time_in IN iby_transactions_v.time%TYPE,

684: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
685: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
686: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
687: status_in IN iby_transactions_v.status%TYPE,
688: time_in IN iby_transactions_v.time%TYPE,
689: payment_type_in IN iby_transactions_v.payment_type%TYPE,
690: payment_name_in IN iby_transactions_v.payment_name%TYPE,
691: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
692: amount_in IN iby_transactions_v.amount%TYPE,

Line 689: payment_type_in IN iby_transactions_v.payment_type%TYPE,

685: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
686: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
687: status_in IN iby_transactions_v.status%TYPE,
688: time_in IN iby_transactions_v.time%TYPE,
689: payment_type_in IN iby_transactions_v.payment_type%TYPE,
690: payment_name_in IN iby_transactions_v.payment_name%TYPE,
691: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
692: amount_in IN iby_transactions_v.amount%TYPE,
693: currency_in IN iby_transactions_v.currency%TYPE,

Line 690: payment_name_in IN iby_transactions_v.payment_name%TYPE,

686: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
687: status_in IN iby_transactions_v.status%TYPE,
688: time_in IN iby_transactions_v.time%TYPE,
689: payment_type_in IN iby_transactions_v.payment_type%TYPE,
690: payment_name_in IN iby_transactions_v.payment_name%TYPE,
691: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
692: amount_in IN iby_transactions_v.amount%TYPE,
693: currency_in IN iby_transactions_v.currency%TYPE,
694: referencecode_in IN iby_transactions_v.referencecode%TYPE,

Line 691: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

687: status_in IN iby_transactions_v.status%TYPE,
688: time_in IN iby_transactions_v.time%TYPE,
689: payment_type_in IN iby_transactions_v.payment_type%TYPE,
690: payment_name_in IN iby_transactions_v.payment_name%TYPE,
691: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
692: amount_in IN iby_transactions_v.amount%TYPE,
693: currency_in IN iby_transactions_v.currency%TYPE,
694: referencecode_in IN iby_transactions_v.referencecode%TYPE,
695: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,

Line 692: amount_in IN iby_transactions_v.amount%TYPE,

688: time_in IN iby_transactions_v.time%TYPE,
689: payment_type_in IN iby_transactions_v.payment_type%TYPE,
690: payment_name_in IN iby_transactions_v.payment_name%TYPE,
691: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
692: amount_in IN iby_transactions_v.amount%TYPE,
693: currency_in IN iby_transactions_v.currency%TYPE,
694: referencecode_in IN iby_transactions_v.referencecode%TYPE,
695: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
696: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,

Line 693: currency_in IN iby_transactions_v.currency%TYPE,

689: payment_type_in IN iby_transactions_v.payment_type%TYPE,
690: payment_name_in IN iby_transactions_v.payment_name%TYPE,
691: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
692: amount_in IN iby_transactions_v.amount%TYPE,
693: currency_in IN iby_transactions_v.currency%TYPE,
694: referencecode_in IN iby_transactions_v.referencecode%TYPE,
695: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
696: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
697: error_location_in IN iby_transactions_v.error_location%TYPE,

Line 694: referencecode_in IN iby_transactions_v.referencecode%TYPE,

690: payment_name_in IN iby_transactions_v.payment_name%TYPE,
691: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
692: amount_in IN iby_transactions_v.amount%TYPE,
693: currency_in IN iby_transactions_v.currency%TYPE,
694: referencecode_in IN iby_transactions_v.referencecode%TYPE,
695: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
696: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
697: error_location_in IN iby_transactions_v.error_location%TYPE,
698: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,

Line 695: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,

691: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
692: amount_in IN iby_transactions_v.amount%TYPE,
693: currency_in IN iby_transactions_v.currency%TYPE,
694: referencecode_in IN iby_transactions_v.referencecode%TYPE,
695: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
696: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
697: error_location_in IN iby_transactions_v.error_location%TYPE,
698: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
699: org_id_in IN iby_trxn_summaries_all.org_id%type,

Line 696: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,

692: amount_in IN iby_transactions_v.amount%TYPE,
693: currency_in IN iby_transactions_v.currency%TYPE,
694: referencecode_in IN iby_transactions_v.referencecode%TYPE,
695: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
696: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
697: error_location_in IN iby_transactions_v.error_location%TYPE,
698: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
699: org_id_in IN iby_trxn_summaries_all.org_id%type,
700: billeracct_in IN iby_tangible.acctno%type,

Line 697: error_location_in IN iby_transactions_v.error_location%TYPE,

693: currency_in IN iby_transactions_v.currency%TYPE,
694: referencecode_in IN iby_transactions_v.referencecode%TYPE,
695: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
696: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
697: error_location_in IN iby_transactions_v.error_location%TYPE,
698: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
699: org_id_in IN iby_trxn_summaries_all.org_id%type,
700: billeracct_in IN iby_tangible.acctno%type,
701: refinfo_in IN iby_tangible.refinfo%type,

Line 698: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,

694: referencecode_in IN iby_transactions_v.referencecode%TYPE,
695: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
696: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
697: error_location_in IN iby_transactions_v.error_location%TYPE,
698: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
699: org_id_in IN iby_trxn_summaries_all.org_id%type,
700: billeracct_in IN iby_tangible.acctno%type,
701: refinfo_in IN iby_tangible.refinfo%type,
702: memo_in IN iby_tangible.memo%type,

Line 1080: order_id_in IN iby_transactions_v.order_id%TYPE,

1076: /* return, credit, and void timeout */
1077:
1078: PROCEDURE insert_timeout_txn
1079: (req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
1080: order_id_in IN iby_transactions_v.order_id%TYPE,
1081:
1082: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
1083: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
1084: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

Line 1082: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

1078: PROCEDURE insert_timeout_txn
1079: (req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
1080: order_id_in IN iby_transactions_v.order_id%TYPE,
1081:
1082: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
1083: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
1084: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
1085: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
1086: time_in IN iby_transactions_v.time%TYPE,

Line 1083: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

1079: (req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
1080: order_id_in IN iby_transactions_v.order_id%TYPE,
1081:
1082: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
1083: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
1084: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
1085: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
1086: time_in IN iby_transactions_v.time%TYPE,
1087:

Line 1084: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

1080: order_id_in IN iby_transactions_v.order_id%TYPE,
1081:
1082: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
1083: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
1084: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
1085: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
1086: time_in IN iby_transactions_v.time%TYPE,
1087:
1088:

Line 1086: time_in IN iby_transactions_v.time%TYPE,

1082: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
1083: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
1084: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
1085: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
1086: time_in IN iby_transactions_v.time%TYPE,
1087:
1088:
1089: status_in IN iby_transactions_v.status%TYPE,
1090: org_id_in IN iby_trxn_summaries_all.org_id%type,

Line 1089: status_in IN iby_transactions_v.status%TYPE,

1085: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
1086: time_in IN iby_transactions_v.time%TYPE,
1087:
1088:
1089: status_in IN iby_transactions_v.status%TYPE,
1090: org_id_in IN iby_trxn_summaries_all.org_id%type,
1091: amount_in IN iby_tangible.amount%type,
1092: currency_in IN iby_tangible.currencynamecode%type,
1093: billeracct_in IN iby_tangible.acctno%type,

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

5286: -- for query batch and query transaction operations to check
5287: -- before inserting a row.
5288:
5289: FUNCTION checkrows
5290: (order_id_in IN iby_transactions_v.order_id%TYPE,
5291: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5292: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5293:
5294: status_in IN iby_transactions_v.status%TYPE,

Line 5291: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

5287: -- before inserting a row.
5288:
5289: FUNCTION checkrows
5290: (order_id_in IN iby_transactions_v.order_id%TYPE,
5291: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5292: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5293:
5294: status_in IN iby_transactions_v.status%TYPE,
5295: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)

Line 5292: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

5288:
5289: FUNCTION checkrows
5290: (order_id_in IN iby_transactions_v.order_id%TYPE,
5291: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5292: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5293:
5294: status_in IN iby_transactions_v.status%TYPE,
5295: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)
5296: RETURN number

Line 5294: status_in IN iby_transactions_v.status%TYPE,

5290: (order_id_in IN iby_transactions_v.order_id%TYPE,
5291: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5292: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5293:
5294: status_in IN iby_transactions_v.status%TYPE,
5295: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)
5296: RETURN number
5297:
5298: IS

Line 5295: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)

5291: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5292: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5293:
5294: status_in IN iby_transactions_v.status%TYPE,
5295: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)
5296: RETURN number
5297:
5298: IS
5299:

Line 5302: l_tx1 iby_transactions_v.trxn_type%TYPE;

5298: IS
5299:
5300: l_numrows NUMBER := 0;
5301: l_needupdate boolean;
5302: l_tx1 iby_transactions_v.trxn_type%TYPE;
5303: l_tx2 iby_transactions_v.trxn_type%TYPE;
5304:
5305: CURSOR c_getNumTrxns(tx1 NUMBER,
5306: tx2 NUMBER DEFAULT NULL)

Line 5303: l_tx2 iby_transactions_v.trxn_type%TYPE;

5299:
5300: l_numrows NUMBER := 0;
5301: l_needupdate boolean;
5302: l_tx1 iby_transactions_v.trxn_type%TYPE;
5303: l_tx2 iby_transactions_v.trxn_type%TYPE;
5304:
5305: CURSOR c_getNumTrxns(tx1 NUMBER,
5306: tx2 NUMBER DEFAULT NULL)
5307: IS

Line 5309: FROM iby_transactions_v

5305: CURSOR c_getNumTrxns(tx1 NUMBER,
5306: tx2 NUMBER DEFAULT NULL)
5307: IS
5308: SELECT count(*)
5309: FROM iby_transactions_v
5310: WHERE order_Id = order_id_in
5311: AND merchant_id = merchant_id_in
5312: AND vendor_id = vendor_id_in
5313: AND status = status_in

Line 5382: order_id_in IN iby_transactions_v.order_id%TYPE,

5378:
5379: PROCEDURE insert_batch_txn
5380: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
5381:
5382: order_id_in IN iby_transactions_v.order_id%TYPE,
5383: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5384: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
5385: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5386: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

Line 5383: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

5379: PROCEDURE insert_batch_txn
5380: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
5381:
5382: order_id_in IN iby_transactions_v.order_id%TYPE,
5383: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5384: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
5385: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5386: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5387: status_in IN iby_transactions_v.status%TYPE,

Line 5384: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,

5380: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
5381:
5382: order_id_in IN iby_transactions_v.order_id%TYPE,
5383: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5384: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
5385: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5386: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5387: status_in IN iby_transactions_v.status%TYPE,
5388: time_in IN iby_transactions_v.time%TYPE,

Line 5385: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

5381:
5382: order_id_in IN iby_transactions_v.order_id%TYPE,
5383: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5384: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
5385: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5386: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5387: status_in IN iby_transactions_v.status%TYPE,
5388: time_in IN iby_transactions_v.time%TYPE,
5389: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

Line 5386: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

5382: order_id_in IN iby_transactions_v.order_id%TYPE,
5383: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5384: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
5385: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5386: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5387: status_in IN iby_transactions_v.status%TYPE,
5388: time_in IN iby_transactions_v.time%TYPE,
5389: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5390: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,

Line 5387: status_in IN iby_transactions_v.status%TYPE,

5383: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5384: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
5385: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5386: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5387: status_in IN iby_transactions_v.status%TYPE,
5388: time_in IN iby_transactions_v.time%TYPE,
5389: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5390: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
5391: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,

Line 5388: time_in IN iby_transactions_v.time%TYPE,

5384: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
5385: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5386: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5387: status_in IN iby_transactions_v.status%TYPE,
5388: time_in IN iby_transactions_v.time%TYPE,
5389: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5390: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
5391: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
5392: error_location_in IN iby_transactions_v.error_location%TYPE,

Line 5389: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

5385: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5386: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5387: status_in IN iby_transactions_v.status%TYPE,
5388: time_in IN iby_transactions_v.time%TYPE,
5389: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5390: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
5391: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
5392: error_location_in IN iby_transactions_v.error_location%TYPE,
5393:

Line 5390: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,

5386: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5387: status_in IN iby_transactions_v.status%TYPE,
5388: time_in IN iby_transactions_v.time%TYPE,
5389: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5390: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
5391: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
5392: error_location_in IN iby_transactions_v.error_location%TYPE,
5393:
5394: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,

Line 5391: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,

5387: status_in IN iby_transactions_v.status%TYPE,
5388: time_in IN iby_transactions_v.time%TYPE,
5389: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5390: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
5391: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
5392: error_location_in IN iby_transactions_v.error_location%TYPE,
5393:
5394: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
5395: org_id_in IN iby_trxn_summaries_all.org_id%type,

Line 5392: error_location_in IN iby_transactions_v.error_location%TYPE,

5388: time_in IN iby_transactions_v.time%TYPE,
5389: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5390: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
5391: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
5392: error_location_in IN iby_transactions_v.error_location%TYPE,
5393:
5394: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
5395: org_id_in IN iby_trxn_summaries_all.org_id%type,
5396: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE)

Line 5394: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,

5390: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
5391: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
5392: error_location_in IN iby_transactions_v.error_location%TYPE,
5393:
5394: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
5395: org_id_in IN iby_trxn_summaries_all.org_id%type,
5396: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE)
5397:
5398: IS

Line 5557: order_id_in IN iby_transactions_v.order_id%TYPE,

5553: /* Inserts transaction record for transaction query operation */
5554:
5555: PROCEDURE insert_query_txn
5556: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
5557: order_id_in IN iby_transactions_v.order_id%TYPE,
5558: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5559: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5560: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5561: status_in IN iby_transactions_v.status%TYPE,

Line 5558: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

5554:
5555: PROCEDURE insert_query_txn
5556: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
5557: order_id_in IN iby_transactions_v.order_id%TYPE,
5558: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5559: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5560: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5561: status_in IN iby_transactions_v.status%TYPE,
5562: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,

Line 5559: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

5555: PROCEDURE insert_query_txn
5556: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
5557: order_id_in IN iby_transactions_v.order_id%TYPE,
5558: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5559: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5560: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5561: status_in IN iby_transactions_v.status%TYPE,
5562: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
5563: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

Line 5560: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

5556: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
5557: order_id_in IN iby_transactions_v.order_id%TYPE,
5558: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5559: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5560: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5561: status_in IN iby_transactions_v.status%TYPE,
5562: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
5563: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5564: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,

Line 5561: status_in IN iby_transactions_v.status%TYPE,

5557: order_id_in IN iby_transactions_v.order_id%TYPE,
5558: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5559: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5560: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5561: status_in IN iby_transactions_v.status%TYPE,
5562: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
5563: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5564: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
5565: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,

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

5558: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5559: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5560: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5561: status_in IN iby_transactions_v.status%TYPE,
5562: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
5563: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5564: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
5565: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
5566: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,

Line 5563: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

5559: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5560: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5561: status_in IN iby_transactions_v.status%TYPE,
5562: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
5563: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5564: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
5565: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
5566: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
5567: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,

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

5560: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5561: status_in IN iby_transactions_v.status%TYPE,
5562: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
5563: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5564: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
5565: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
5566: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
5567: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
5568: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,

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

5561: status_in IN iby_transactions_v.status%TYPE,
5562: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
5563: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5564: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
5565: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
5566: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
5567: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
5568: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
5569: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,

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

5562: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
5563: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5564: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
5565: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
5566: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
5567: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
5568: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
5569: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
5570: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,

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

5563: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5564: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
5565: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
5566: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
5567: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
5568: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
5569: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
5570: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
5571: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,

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

5564: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
5565: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
5566: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
5567: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
5568: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
5569: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
5570: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
5571: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
5572: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,

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

5565: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
5566: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
5567: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
5568: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
5569: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
5570: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
5571: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
5572: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
5573: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,

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

5566: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
5567: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
5568: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
5569: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
5570: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
5571: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
5572: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
5573: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
5574: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,

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

5567: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
5568: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
5569: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
5570: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
5571: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
5572: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
5573: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
5574: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
5575: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,

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

5568: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
5569: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
5570: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
5571: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
5572: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
5573: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
5574: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
5575: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
5576: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,

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

5569: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
5570: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
5571: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
5572: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
5573: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
5574: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
5575: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
5576: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
5577: ecappid_in IN iby_ecapp.ecappid%type,

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

5570: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
5571: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
5572: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
5573: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
5574: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
5575: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
5576: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
5577: ecappid_in IN iby_ecapp.ecappid%type,
5578: req_type_in IN iby_trxn_summaries_all.reqtype%type)

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

5571: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
5572: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
5573: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
5574: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
5575: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
5576: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
5577: ecappid_in IN iby_ecapp.ecappid%type,
5578: req_type_in IN iby_trxn_summaries_all.reqtype%type)
5579: IS

Line 5607: ci_orderid iby_transactions_v.order_id%TYPE,

5603: AND (reqtype = ci_reqtype);
5604:
5605: CURSOR c_order_info
5606: (
5607: ci_orderid iby_transactions_v.order_id%TYPE,
5608: ci_merchid iby_transactions_v.merchant_id%TYPE
5609: )
5610: IS
5611: SELECT mtangibleid, instrtype, instrsubtype, trxnref

Line 5608: ci_merchid iby_transactions_v.merchant_id%TYPE

5604:
5605: CURSOR c_order_info
5606: (
5607: ci_orderid iby_transactions_v.order_id%TYPE,
5608: ci_merchid iby_transactions_v.merchant_id%TYPE
5609: )
5610: IS
5611: SELECT mtangibleid, instrtype, instrsubtype, trxnref
5612: FROM iby_trxn_summaries_all