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

208: PROCEDURE insert_auth_txn
209: (
210: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
211: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
212: order_id_in IN iby_transactions_v.order_id%TYPE,
213: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
214: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
215: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
216: amount_in IN iby_transactions_v.amount%TYPE,

Line 213: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

209: (
210: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
211: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
212: order_id_in IN iby_transactions_v.order_id%TYPE,
213: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
214: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
215: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
216: amount_in IN iby_transactions_v.amount%TYPE,
217: currency_in IN iby_transactions_v.currency%TYPE,

Line 214: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

210: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
211: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
212: order_id_in IN iby_transactions_v.order_id%TYPE,
213: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
214: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
215: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
216: amount_in IN iby_transactions_v.amount%TYPE,
217: currency_in IN iby_transactions_v.currency%TYPE,
218: status_in IN iby_transactions_v.status%TYPE,

Line 215: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

211: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
212: order_id_in IN iby_transactions_v.order_id%TYPE,
213: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
214: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
215: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
216: amount_in IN iby_transactions_v.amount%TYPE,
217: currency_in IN iby_transactions_v.currency%TYPE,
218: status_in IN iby_transactions_v.status%TYPE,
219: time_in IN iby_transactions_v.time%TYPE,

Line 216: amount_in IN iby_transactions_v.amount%TYPE,

212: order_id_in IN iby_transactions_v.order_id%TYPE,
213: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
214: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
215: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
216: amount_in IN iby_transactions_v.amount%TYPE,
217: currency_in IN iby_transactions_v.currency%TYPE,
218: status_in IN iby_transactions_v.status%TYPE,
219: time_in IN iby_transactions_v.time%TYPE,
220: payment_name_in IN iby_transactions_v.payment_name%TYPE,

Line 217: currency_in IN iby_transactions_v.currency%TYPE,

213: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
214: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
215: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
216: amount_in IN iby_transactions_v.amount%TYPE,
217: currency_in IN iby_transactions_v.currency%TYPE,
218: status_in IN iby_transactions_v.status%TYPE,
219: time_in IN iby_transactions_v.time%TYPE,
220: payment_name_in IN iby_transactions_v.payment_name%TYPE,
221: payment_type_in IN iby_transactions_v.payment_type%TYPE,

Line 218: status_in IN iby_transactions_v.status%TYPE,

214: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
215: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
216: amount_in IN iby_transactions_v.amount%TYPE,
217: currency_in IN iby_transactions_v.currency%TYPE,
218: status_in IN iby_transactions_v.status%TYPE,
219: time_in IN iby_transactions_v.time%TYPE,
220: payment_name_in IN iby_transactions_v.payment_name%TYPE,
221: payment_type_in IN iby_transactions_v.payment_type%TYPE,
222: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

Line 219: time_in IN iby_transactions_v.time%TYPE,

215: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
216: amount_in IN iby_transactions_v.amount%TYPE,
217: currency_in IN iby_transactions_v.currency%TYPE,
218: status_in IN iby_transactions_v.status%TYPE,
219: time_in IN iby_transactions_v.time%TYPE,
220: payment_name_in IN iby_transactions_v.payment_name%TYPE,
221: payment_type_in IN iby_transactions_v.payment_type%TYPE,
222: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
223: authcode_in IN iby_transactions_v.authcode%TYPE,

Line 220: payment_name_in IN iby_transactions_v.payment_name%TYPE,

216: amount_in IN iby_transactions_v.amount%TYPE,
217: currency_in IN iby_transactions_v.currency%TYPE,
218: status_in IN iby_transactions_v.status%TYPE,
219: time_in IN iby_transactions_v.time%TYPE,
220: payment_name_in IN iby_transactions_v.payment_name%TYPE,
221: payment_type_in IN iby_transactions_v.payment_type%TYPE,
222: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
223: authcode_in IN iby_transactions_v.authcode%TYPE,
224: referencecode_in IN iby_transactions_v.referencecode%TYPE,

Line 221: payment_type_in IN iby_transactions_v.payment_type%TYPE,

217: currency_in IN iby_transactions_v.currency%TYPE,
218: status_in IN iby_transactions_v.status%TYPE,
219: time_in IN iby_transactions_v.time%TYPE,
220: payment_name_in IN iby_transactions_v.payment_name%TYPE,
221: payment_type_in IN iby_transactions_v.payment_type%TYPE,
222: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
223: authcode_in IN iby_transactions_v.authcode%TYPE,
224: referencecode_in IN iby_transactions_v.referencecode%TYPE,
225: AVScode_in IN iby_transactions_v.AVScode%TYPE,

Line 222: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

218: status_in IN iby_transactions_v.status%TYPE,
219: time_in IN iby_transactions_v.time%TYPE,
220: payment_name_in IN iby_transactions_v.payment_name%TYPE,
221: payment_type_in IN iby_transactions_v.payment_type%TYPE,
222: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
223: authcode_in IN iby_transactions_v.authcode%TYPE,
224: referencecode_in IN iby_transactions_v.referencecode%TYPE,
225: AVScode_in IN iby_transactions_v.AVScode%TYPE,
226: acquirer_in IN iby_transactions_v.acquirer%TYPE,

Line 223: authcode_in IN iby_transactions_v.authcode%TYPE,

219: time_in IN iby_transactions_v.time%TYPE,
220: payment_name_in IN iby_transactions_v.payment_name%TYPE,
221: payment_type_in IN iby_transactions_v.payment_type%TYPE,
222: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
223: authcode_in IN iby_transactions_v.authcode%TYPE,
224: referencecode_in IN iby_transactions_v.referencecode%TYPE,
225: AVScode_in IN iby_transactions_v.AVScode%TYPE,
226: acquirer_in IN iby_transactions_v.acquirer%TYPE,
227: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,

Line 224: referencecode_in IN iby_transactions_v.referencecode%TYPE,

220: payment_name_in IN iby_transactions_v.payment_name%TYPE,
221: payment_type_in IN iby_transactions_v.payment_type%TYPE,
222: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
223: authcode_in IN iby_transactions_v.authcode%TYPE,
224: referencecode_in IN iby_transactions_v.referencecode%TYPE,
225: AVScode_in IN iby_transactions_v.AVScode%TYPE,
226: acquirer_in IN iby_transactions_v.acquirer%TYPE,
227: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
228: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,

Line 225: AVScode_in IN iby_transactions_v.AVScode%TYPE,

221: payment_type_in IN iby_transactions_v.payment_type%TYPE,
222: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
223: authcode_in IN iby_transactions_v.authcode%TYPE,
224: referencecode_in IN iby_transactions_v.referencecode%TYPE,
225: AVScode_in IN iby_transactions_v.AVScode%TYPE,
226: acquirer_in IN iby_transactions_v.acquirer%TYPE,
227: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
228: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
229: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,

Line 226: acquirer_in IN iby_transactions_v.acquirer%TYPE,

222: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
223: authcode_in IN iby_transactions_v.authcode%TYPE,
224: referencecode_in IN iby_transactions_v.referencecode%TYPE,
225: AVScode_in IN iby_transactions_v.AVScode%TYPE,
226: acquirer_in IN iby_transactions_v.acquirer%TYPE,
227: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
228: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
229: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
230: error_location_in IN iby_transactions_v.error_location%TYPE,

Line 227: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,

223: authcode_in IN iby_transactions_v.authcode%TYPE,
224: referencecode_in IN iby_transactions_v.referencecode%TYPE,
225: AVScode_in IN iby_transactions_v.AVScode%TYPE,
226: acquirer_in IN iby_transactions_v.acquirer%TYPE,
227: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
228: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
229: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
230: error_location_in IN iby_transactions_v.error_location%TYPE,
231: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,

Line 228: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,

224: referencecode_in IN iby_transactions_v.referencecode%TYPE,
225: AVScode_in IN iby_transactions_v.AVScode%TYPE,
226: acquirer_in IN iby_transactions_v.acquirer%TYPE,
227: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
228: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
229: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
230: error_location_in IN iby_transactions_v.error_location%TYPE,
231: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
232: org_id_in IN iby_trxn_summaries_all.org_id%type,

Line 229: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,

225: AVScode_in IN iby_transactions_v.AVScode%TYPE,
226: acquirer_in IN iby_transactions_v.acquirer%TYPE,
227: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
228: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
229: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
230: error_location_in IN iby_transactions_v.error_location%TYPE,
231: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
232: org_id_in IN iby_trxn_summaries_all.org_id%type,
233: billeracct_in IN iby_tangible.acctno%type,

Line 230: error_location_in IN iby_transactions_v.error_location%TYPE,

226: acquirer_in IN iby_transactions_v.acquirer%TYPE,
227: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
228: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
229: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
230: error_location_in IN iby_transactions_v.error_location%TYPE,
231: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
232: org_id_in IN iby_trxn_summaries_all.org_id%type,
233: billeracct_in IN iby_tangible.acctno%type,
234: refinfo_in IN iby_tangible.refinfo%type,

Line 231: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,

227: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE,
228: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
229: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
230: error_location_in IN iby_transactions_v.error_location%TYPE,
231: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
232: org_id_in IN iby_trxn_summaries_all.org_id%type,
233: billeracct_in IN iby_tangible.acctno%type,
234: refinfo_in IN iby_tangible.refinfo%type,
235: memo_in IN iby_tangible.memo%type,

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

627: trxnid_in IN iby_trxn_summaries_all.transactionid%TYPE,
628: status_in IN iby_trxn_summaries_all.status%TYPE,
629: trxntype_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
630: revised_amt_in IN iby_trxn_summaries_all.amount%TYPE,
631: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
632: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
633: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
634: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
635: cvv2result_in IN iby_trxn_core.CVV2Result%type,

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

628: status_in IN iby_trxn_summaries_all.status%TYPE,
629: trxntype_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
630: revised_amt_in IN iby_trxn_summaries_all.amount%TYPE,
631: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
632: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
633: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
634: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
635: cvv2result_in IN iby_trxn_core.CVV2Result%type,
636: bepcode_in IN iby_trxn_summaries_all.bepcode%TYPE,

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

629: trxntype_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
630: revised_amt_in IN iby_trxn_summaries_all.amount%TYPE,
631: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
632: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
633: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
634: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
635: cvv2result_in IN iby_trxn_core.CVV2Result%type,
636: bepcode_in IN iby_trxn_summaries_all.bepcode%TYPE,
637: bepmessage_in IN iby_trxn_summaries_all.bepmessage%TYPE,

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

630: revised_amt_in IN iby_trxn_summaries_all.amount%TYPE,
631: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
632: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
633: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
634: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
635: cvv2result_in IN iby_trxn_core.CVV2Result%type,
636: bepcode_in IN iby_trxn_summaries_all.bepcode%TYPE,
637: bepmessage_in IN iby_trxn_summaries_all.bepmessage%TYPE,
638: error_loc_in IN iby_trxn_summaries_all.errorlocation%TYPE,

Line 824: order_id_in IN iby_transactions_v.order_id%TYPE,

820:
821: PROCEDURE insert_other_txn
822: ( ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
823: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
824: order_id_in IN iby_transactions_v.order_id%TYPE,
825: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
826: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
827: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
828: status_in IN iby_transactions_v.status%TYPE,

Line 825: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

821: PROCEDURE insert_other_txn
822: ( ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
823: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
824: order_id_in IN iby_transactions_v.order_id%TYPE,
825: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
826: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
827: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
828: status_in IN iby_transactions_v.status%TYPE,
829: time_in IN iby_transactions_v.time%TYPE,

Line 826: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

822: ( ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
823: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
824: order_id_in IN iby_transactions_v.order_id%TYPE,
825: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
826: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
827: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
828: status_in IN iby_transactions_v.status%TYPE,
829: time_in IN iby_transactions_v.time%TYPE,
830: payment_type_in IN iby_transactions_v.payment_type%TYPE,

Line 827: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

823: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
824: order_id_in IN iby_transactions_v.order_id%TYPE,
825: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
826: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
827: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
828: status_in IN iby_transactions_v.status%TYPE,
829: time_in IN iby_transactions_v.time%TYPE,
830: payment_type_in IN iby_transactions_v.payment_type%TYPE,
831: payment_name_in IN iby_transactions_v.payment_name%TYPE,

Line 828: status_in IN iby_transactions_v.status%TYPE,

824: order_id_in IN iby_transactions_v.order_id%TYPE,
825: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
826: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
827: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
828: status_in IN iby_transactions_v.status%TYPE,
829: time_in IN iby_transactions_v.time%TYPE,
830: payment_type_in IN iby_transactions_v.payment_type%TYPE,
831: payment_name_in IN iby_transactions_v.payment_name%TYPE,
832: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

Line 829: time_in IN iby_transactions_v.time%TYPE,

825: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
826: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
827: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
828: status_in IN iby_transactions_v.status%TYPE,
829: time_in IN iby_transactions_v.time%TYPE,
830: payment_type_in IN iby_transactions_v.payment_type%TYPE,
831: payment_name_in IN iby_transactions_v.payment_name%TYPE,
832: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
833: amount_in IN iby_transactions_v.amount%TYPE,

Line 830: payment_type_in IN iby_transactions_v.payment_type%TYPE,

826: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
827: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
828: status_in IN iby_transactions_v.status%TYPE,
829: time_in IN iby_transactions_v.time%TYPE,
830: payment_type_in IN iby_transactions_v.payment_type%TYPE,
831: payment_name_in IN iby_transactions_v.payment_name%TYPE,
832: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
833: amount_in IN iby_transactions_v.amount%TYPE,
834: currency_in IN iby_transactions_v.currency%TYPE,

Line 831: payment_name_in IN iby_transactions_v.payment_name%TYPE,

827: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
828: status_in IN iby_transactions_v.status%TYPE,
829: time_in IN iby_transactions_v.time%TYPE,
830: payment_type_in IN iby_transactions_v.payment_type%TYPE,
831: payment_name_in IN iby_transactions_v.payment_name%TYPE,
832: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
833: amount_in IN iby_transactions_v.amount%TYPE,
834: currency_in IN iby_transactions_v.currency%TYPE,
835: referencecode_in IN iby_transactions_v.referencecode%TYPE,

Line 832: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

828: status_in IN iby_transactions_v.status%TYPE,
829: time_in IN iby_transactions_v.time%TYPE,
830: payment_type_in IN iby_transactions_v.payment_type%TYPE,
831: payment_name_in IN iby_transactions_v.payment_name%TYPE,
832: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
833: amount_in IN iby_transactions_v.amount%TYPE,
834: currency_in IN iby_transactions_v.currency%TYPE,
835: referencecode_in IN iby_transactions_v.referencecode%TYPE,
836: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,

Line 833: amount_in IN iby_transactions_v.amount%TYPE,

829: time_in IN iby_transactions_v.time%TYPE,
830: payment_type_in IN iby_transactions_v.payment_type%TYPE,
831: payment_name_in IN iby_transactions_v.payment_name%TYPE,
832: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
833: amount_in IN iby_transactions_v.amount%TYPE,
834: currency_in IN iby_transactions_v.currency%TYPE,
835: referencecode_in IN iby_transactions_v.referencecode%TYPE,
836: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
837: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,

Line 834: currency_in IN iby_transactions_v.currency%TYPE,

830: payment_type_in IN iby_transactions_v.payment_type%TYPE,
831: payment_name_in IN iby_transactions_v.payment_name%TYPE,
832: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
833: amount_in IN iby_transactions_v.amount%TYPE,
834: currency_in IN iby_transactions_v.currency%TYPE,
835: referencecode_in IN iby_transactions_v.referencecode%TYPE,
836: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
837: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
838: error_location_in IN iby_transactions_v.error_location%TYPE,

Line 835: referencecode_in IN iby_transactions_v.referencecode%TYPE,

831: payment_name_in IN iby_transactions_v.payment_name%TYPE,
832: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
833: amount_in IN iby_transactions_v.amount%TYPE,
834: currency_in IN iby_transactions_v.currency%TYPE,
835: referencecode_in IN iby_transactions_v.referencecode%TYPE,
836: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
837: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
838: error_location_in IN iby_transactions_v.error_location%TYPE,
839: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,

Line 836: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,

832: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
833: amount_in IN iby_transactions_v.amount%TYPE,
834: currency_in IN iby_transactions_v.currency%TYPE,
835: referencecode_in IN iby_transactions_v.referencecode%TYPE,
836: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
837: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
838: error_location_in IN iby_transactions_v.error_location%TYPE,
839: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
840: org_id_in IN iby_trxn_summaries_all.org_id%type,

Line 837: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,

833: amount_in IN iby_transactions_v.amount%TYPE,
834: currency_in IN iby_transactions_v.currency%TYPE,
835: referencecode_in IN iby_transactions_v.referencecode%TYPE,
836: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
837: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
838: error_location_in IN iby_transactions_v.error_location%TYPE,
839: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
840: org_id_in IN iby_trxn_summaries_all.org_id%type,
841: billeracct_in IN iby_tangible.acctno%type,

Line 838: error_location_in IN iby_transactions_v.error_location%TYPE,

834: currency_in IN iby_transactions_v.currency%TYPE,
835: referencecode_in IN iby_transactions_v.referencecode%TYPE,
836: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
837: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
838: error_location_in IN iby_transactions_v.error_location%TYPE,
839: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
840: org_id_in IN iby_trxn_summaries_all.org_id%type,
841: billeracct_in IN iby_tangible.acctno%type,
842: refinfo_in IN iby_tangible.refinfo%type,

Line 839: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,

835: referencecode_in IN iby_transactions_v.referencecode%TYPE,
836: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
837: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
838: error_location_in IN iby_transactions_v.error_location%TYPE,
839: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
840: org_id_in IN iby_trxn_summaries_all.org_id%type,
841: billeracct_in IN iby_tangible.acctno%type,
842: refinfo_in IN iby_tangible.refinfo%type,
843: memo_in IN iby_tangible.memo%type,

Line 905: l_currency iby_transactions_v.currency%TYPE;

901: l_pmt_chnl_code iby_trxn_summaries_all.payment_channel_code%TYPE;
902: l_module_name CONSTANT VARCHAR2(200) := 'IBY_TRANSACTIONCC_PKG.insert_other_txn';
903: l_subtype iby_trxn_summaries_all.instrsubtype%type;
904:
905: l_currency iby_transactions_v.currency%TYPE;
906: l_payerid iby_trxn_summaries_all.payerid%TYPE;
907: l_payerinstrid iby_trxn_summaries_all.payerinstrid%TYPE;
908:
909: CURSOR c_followon_info(ci_trxnid iby_trxn_summaries_all.transactionid%TYPE)

Line 1282: order_id_in IN iby_transactions_v.order_id%TYPE,

1278: /* return, credit, and void timeout */
1279:
1280: PROCEDURE insert_timeout_txn
1281: (req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
1282: order_id_in IN iby_transactions_v.order_id%TYPE,
1283:
1284: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
1285: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
1286: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

Line 1284: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

1280: PROCEDURE insert_timeout_txn
1281: (req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
1282: order_id_in IN iby_transactions_v.order_id%TYPE,
1283:
1284: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
1285: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
1286: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
1287: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
1288: time_in IN iby_transactions_v.time%TYPE,

Line 1285: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

1281: (req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
1282: order_id_in IN iby_transactions_v.order_id%TYPE,
1283:
1284: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
1285: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
1286: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
1287: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
1288: time_in IN iby_transactions_v.time%TYPE,
1289:

Line 1286: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

1282: order_id_in IN iby_transactions_v.order_id%TYPE,
1283:
1284: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
1285: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
1286: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
1287: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
1288: time_in IN iby_transactions_v.time%TYPE,
1289:
1290:

Line 1288: time_in IN iby_transactions_v.time%TYPE,

1284: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
1285: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
1286: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
1287: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
1288: time_in IN iby_transactions_v.time%TYPE,
1289:
1290:
1291: status_in IN iby_transactions_v.status%TYPE,
1292: org_id_in IN iby_trxn_summaries_all.org_id%type,

Line 1291: status_in IN iby_transactions_v.status%TYPE,

1287: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
1288: time_in IN iby_transactions_v.time%TYPE,
1289:
1290:
1291: status_in IN iby_transactions_v.status%TYPE,
1292: org_id_in IN iby_trxn_summaries_all.org_id%type,
1293: amount_in IN iby_tangible.amount%type,
1294: currency_in IN iby_tangible.currencynamecode%type,
1295: billeracct_in IN iby_tangible.acctno%type,

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

5788: -- for query batch and query transaction operations to check
5789: -- before inserting a row.
5790:
5791: FUNCTION checkrows
5792: (order_id_in IN iby_transactions_v.order_id%TYPE,
5793: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5794: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5795:
5796: status_in IN iby_transactions_v.status%TYPE,

Line 5793: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

5789: -- before inserting a row.
5790:
5791: FUNCTION checkrows
5792: (order_id_in IN iby_transactions_v.order_id%TYPE,
5793: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5794: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5795:
5796: status_in IN iby_transactions_v.status%TYPE,
5797: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)

Line 5794: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

5790:
5791: FUNCTION checkrows
5792: (order_id_in IN iby_transactions_v.order_id%TYPE,
5793: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5794: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5795:
5796: status_in IN iby_transactions_v.status%TYPE,
5797: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)
5798: RETURN number

Line 5796: status_in IN iby_transactions_v.status%TYPE,

5792: (order_id_in IN iby_transactions_v.order_id%TYPE,
5793: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5794: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5795:
5796: status_in IN iby_transactions_v.status%TYPE,
5797: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)
5798: RETURN number
5799:
5800: IS

Line 5797: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)

5793: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5794: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5795:
5796: status_in IN iby_transactions_v.status%TYPE,
5797: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)
5798: RETURN number
5799:
5800: IS
5801:

Line 5804: l_tx1 iby_transactions_v.trxn_type%TYPE;

5800: IS
5801:
5802: l_numrows NUMBER := 0;
5803: l_needupdate boolean;
5804: l_tx1 iby_transactions_v.trxn_type%TYPE;
5805: l_tx2 iby_transactions_v.trxn_type%TYPE;
5806:
5807: CURSOR c_getNumTrxns(tx1 NUMBER,
5808: tx2 NUMBER DEFAULT NULL)

Line 5805: l_tx2 iby_transactions_v.trxn_type%TYPE;

5801:
5802: l_numrows NUMBER := 0;
5803: l_needupdate boolean;
5804: l_tx1 iby_transactions_v.trxn_type%TYPE;
5805: l_tx2 iby_transactions_v.trxn_type%TYPE;
5806:
5807: CURSOR c_getNumTrxns(tx1 NUMBER,
5808: tx2 NUMBER DEFAULT NULL)
5809: IS

Line 5811: FROM iby_transactions_v

5807: CURSOR c_getNumTrxns(tx1 NUMBER,
5808: tx2 NUMBER DEFAULT NULL)
5809: IS
5810: SELECT count(*)
5811: FROM iby_transactions_v
5812: WHERE order_Id = order_id_in
5813: AND merchant_id = merchant_id_in
5814: AND vendor_id = vendor_id_in
5815: AND status = status_in

Line 5884: order_id_in IN iby_transactions_v.order_id%TYPE,

5880:
5881: PROCEDURE insert_batch_txn
5882: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
5883:
5884: order_id_in IN iby_transactions_v.order_id%TYPE,
5885: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5886: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
5887: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5888: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

Line 5885: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

5881: PROCEDURE insert_batch_txn
5882: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
5883:
5884: order_id_in IN iby_transactions_v.order_id%TYPE,
5885: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5886: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
5887: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5888: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5889: status_in IN iby_transactions_v.status%TYPE,

Line 5886: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,

5882: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
5883:
5884: order_id_in IN iby_transactions_v.order_id%TYPE,
5885: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5886: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
5887: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5888: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5889: status_in IN iby_transactions_v.status%TYPE,
5890: time_in IN iby_transactions_v.time%TYPE,

Line 5887: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

5883:
5884: order_id_in IN iby_transactions_v.order_id%TYPE,
5885: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5886: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
5887: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5888: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5889: status_in IN iby_transactions_v.status%TYPE,
5890: time_in IN iby_transactions_v.time%TYPE,
5891: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

Line 5888: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

5884: order_id_in IN iby_transactions_v.order_id%TYPE,
5885: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5886: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
5887: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5888: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5889: status_in IN iby_transactions_v.status%TYPE,
5890: time_in IN iby_transactions_v.time%TYPE,
5891: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5892: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,

Line 5889: status_in IN iby_transactions_v.status%TYPE,

5885: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
5886: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
5887: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5888: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5889: status_in IN iby_transactions_v.status%TYPE,
5890: time_in IN iby_transactions_v.time%TYPE,
5891: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5892: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
5893: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,

Line 5890: time_in IN iby_transactions_v.time%TYPE,

5886: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
5887: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5888: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5889: status_in IN iby_transactions_v.status%TYPE,
5890: time_in IN iby_transactions_v.time%TYPE,
5891: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5892: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
5893: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
5894: error_location_in IN iby_transactions_v.error_location%TYPE,

Line 5891: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

5887: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
5888: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5889: status_in IN iby_transactions_v.status%TYPE,
5890: time_in IN iby_transactions_v.time%TYPE,
5891: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5892: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
5893: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
5894: error_location_in IN iby_transactions_v.error_location%TYPE,
5895:

Line 5892: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,

5888: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
5889: status_in IN iby_transactions_v.status%TYPE,
5890: time_in IN iby_transactions_v.time%TYPE,
5891: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5892: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
5893: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
5894: error_location_in IN iby_transactions_v.error_location%TYPE,
5895:
5896: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,

Line 5893: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,

5889: status_in IN iby_transactions_v.status%TYPE,
5890: time_in IN iby_transactions_v.time%TYPE,
5891: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5892: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
5893: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
5894: error_location_in IN iby_transactions_v.error_location%TYPE,
5895:
5896: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
5897: org_id_in IN iby_trxn_summaries_all.org_id%type,

Line 5894: error_location_in IN iby_transactions_v.error_location%TYPE,

5890: time_in IN iby_transactions_v.time%TYPE,
5891: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
5892: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
5893: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
5894: error_location_in IN iby_transactions_v.error_location%TYPE,
5895:
5896: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
5897: org_id_in IN iby_trxn_summaries_all.org_id%type,
5898: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE)

Line 5896: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,

5892: vendor_code_in IN iby_transactions_v.vendor_code%TYPE,
5893: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
5894: error_location_in IN iby_transactions_v.error_location%TYPE,
5895:
5896: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
5897: org_id_in IN iby_trxn_summaries_all.org_id%type,
5898: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE)
5899:
5900: IS

Line 6059: order_id_in IN iby_transactions_v.order_id%TYPE,

6055: /* Inserts transaction record for transaction query operation */
6056:
6057: PROCEDURE insert_query_txn
6058: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
6059: order_id_in IN iby_transactions_v.order_id%TYPE,
6060: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
6061: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
6062: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
6063: status_in IN iby_transactions_v.status%TYPE,

Line 6060: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

6056:
6057: PROCEDURE insert_query_txn
6058: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
6059: order_id_in IN iby_transactions_v.order_id%TYPE,
6060: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
6061: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
6062: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
6063: status_in IN iby_transactions_v.status%TYPE,
6064: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,

Line 6061: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

6057: PROCEDURE insert_query_txn
6058: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
6059: order_id_in IN iby_transactions_v.order_id%TYPE,
6060: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
6061: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
6062: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
6063: status_in IN iby_transactions_v.status%TYPE,
6064: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
6065: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

Line 6062: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

6058: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
6059: order_id_in IN iby_transactions_v.order_id%TYPE,
6060: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
6061: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
6062: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
6063: status_in IN iby_transactions_v.status%TYPE,
6064: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
6065: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
6066: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,

Line 6063: status_in IN iby_transactions_v.status%TYPE,

6059: order_id_in IN iby_transactions_v.order_id%TYPE,
6060: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
6061: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
6062: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
6063: status_in IN iby_transactions_v.status%TYPE,
6064: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
6065: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
6066: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
6067: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,

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

6060: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
6061: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
6062: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
6063: status_in IN iby_transactions_v.status%TYPE,
6064: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
6065: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
6066: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
6067: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
6068: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,

Line 6065: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

6061: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
6062: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
6063: status_in IN iby_transactions_v.status%TYPE,
6064: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
6065: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
6066: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
6067: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
6068: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
6069: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,

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

6062: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
6063: status_in IN iby_transactions_v.status%TYPE,
6064: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
6065: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
6066: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
6067: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
6068: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
6069: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
6070: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,

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

6063: status_in IN iby_transactions_v.status%TYPE,
6064: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
6065: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
6066: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
6067: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
6068: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
6069: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
6070: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
6071: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,

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

6064: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
6065: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
6066: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
6067: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
6068: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
6069: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
6070: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
6071: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
6072: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,

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

6065: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
6066: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
6067: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
6068: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
6069: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
6070: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
6071: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
6072: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
6073: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,

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

6066: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
6067: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
6068: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
6069: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
6070: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
6071: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
6072: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
6073: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
6074: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,

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

6067: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
6068: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
6069: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
6070: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
6071: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
6072: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
6073: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
6074: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
6075: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,

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

6068: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
6069: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
6070: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
6071: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
6072: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
6073: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
6074: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
6075: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
6076: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,

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

6069: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
6070: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
6071: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
6072: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
6073: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
6074: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
6075: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
6076: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
6077: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,

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

6070: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
6071: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
6072: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
6073: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
6074: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
6075: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
6076: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
6077: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
6078: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,

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

6071: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
6072: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
6073: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
6074: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
6075: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
6076: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
6077: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
6078: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
6079: ecappid_in IN iby_ecapp.ecappid%type,

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

6072: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
6073: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
6074: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
6075: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
6076: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
6077: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
6078: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
6079: ecappid_in IN iby_ecapp.ecappid%type,
6080: req_type_in IN iby_trxn_summaries_all.reqtype%type)

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

6073: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
6074: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
6075: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
6076: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
6077: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
6078: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
6079: ecappid_in IN iby_ecapp.ecappid%type,
6080: req_type_in IN iby_trxn_summaries_all.reqtype%type)
6081: IS

Line 6109: ci_orderid iby_transactions_v.order_id%TYPE,

6105: AND (reqtype = ci_reqtype);
6106:
6107: CURSOR c_order_info
6108: (
6109: ci_orderid iby_transactions_v.order_id%TYPE,
6110: ci_merchid iby_transactions_v.merchant_id%TYPE
6111: )
6112: IS
6113: SELECT mtangibleid, instrtype, instrsubtype, trxnref

Line 6110: ci_merchid iby_transactions_v.merchant_id%TYPE

6106:
6107: CURSOR c_order_info
6108: (
6109: ci_orderid iby_transactions_v.order_id%TYPE,
6110: ci_merchid iby_transactions_v.merchant_id%TYPE
6111: )
6112: IS
6113: SELECT mtangibleid, instrtype, instrsubtype, trxnref
6114: FROM iby_trxn_summaries_all