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

180: PROCEDURE insert_auth_txn
181: (
182: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
183: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
184: order_id_in IN iby_transactions_v.order_id%TYPE,
185: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
186: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
187: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
188: amount_in IN iby_transactions_v.amount%TYPE,

Line 185: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

181: (
182: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
183: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
184: order_id_in IN iby_transactions_v.order_id%TYPE,
185: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
186: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
187: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
188: amount_in IN iby_transactions_v.amount%TYPE,
189: currency_in IN iby_transactions_v.currency%TYPE,

Line 186: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

182: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
183: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
184: order_id_in IN iby_transactions_v.order_id%TYPE,
185: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
186: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
187: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
188: amount_in IN iby_transactions_v.amount%TYPE,
189: currency_in IN iby_transactions_v.currency%TYPE,
190: status_in IN iby_transactions_v.status%TYPE,

Line 187: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

183: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
184: order_id_in IN iby_transactions_v.order_id%TYPE,
185: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
186: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
187: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
188: amount_in IN iby_transactions_v.amount%TYPE,
189: currency_in IN iby_transactions_v.currency%TYPE,
190: status_in IN iby_transactions_v.status%TYPE,
191: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,

Line 188: amount_in IN iby_transactions_v.amount%TYPE,

184: order_id_in IN iby_transactions_v.order_id%TYPE,
185: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
186: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
187: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
188: amount_in IN iby_transactions_v.amount%TYPE,
189: currency_in IN iby_transactions_v.currency%TYPE,
190: status_in IN iby_transactions_v.status%TYPE,
191: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
192: payment_name_in IN iby_transactions_v.payment_name%TYPE,

Line 189: currency_in IN iby_transactions_v.currency%TYPE,

185: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
186: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
187: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
188: amount_in IN iby_transactions_v.amount%TYPE,
189: currency_in IN iby_transactions_v.currency%TYPE,
190: status_in IN iby_transactions_v.status%TYPE,
191: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
192: payment_name_in IN iby_transactions_v.payment_name%TYPE,
193: payment_type_in IN iby_transactions_v.payment_type%TYPE,

Line 190: status_in IN iby_transactions_v.status%TYPE,

186: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
187: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
188: amount_in IN iby_transactions_v.amount%TYPE,
189: currency_in IN iby_transactions_v.currency%TYPE,
190: status_in IN iby_transactions_v.status%TYPE,
191: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
192: payment_name_in IN iby_transactions_v.payment_name%TYPE,
193: payment_type_in IN iby_transactions_v.payment_type%TYPE,
194: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,

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

187: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
188: amount_in IN iby_transactions_v.amount%TYPE,
189: currency_in IN iby_transactions_v.currency%TYPE,
190: status_in IN iby_transactions_v.status%TYPE,
191: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
192: payment_name_in IN iby_transactions_v.payment_name%TYPE,
193: payment_type_in IN iby_transactions_v.payment_type%TYPE,
194: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
195: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,

Line 192: payment_name_in IN iby_transactions_v.payment_name%TYPE,

188: amount_in IN iby_transactions_v.amount%TYPE,
189: currency_in IN iby_transactions_v.currency%TYPE,
190: status_in IN iby_transactions_v.status%TYPE,
191: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
192: payment_name_in IN iby_transactions_v.payment_name%TYPE,
193: payment_type_in IN iby_transactions_v.payment_type%TYPE,
194: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
195: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
196: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,

Line 193: payment_type_in IN iby_transactions_v.payment_type%TYPE,

189: currency_in IN iby_transactions_v.currency%TYPE,
190: status_in IN iby_transactions_v.status%TYPE,
191: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
192: payment_name_in IN iby_transactions_v.payment_name%TYPE,
193: payment_type_in IN iby_transactions_v.payment_type%TYPE,
194: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
195: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
196: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
197: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,

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

190: status_in IN iby_transactions_v.status%TYPE,
191: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
192: payment_name_in IN iby_transactions_v.payment_name%TYPE,
193: payment_type_in IN iby_transactions_v.payment_type%TYPE,
194: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
195: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
196: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
197: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
198: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,

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

191: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
192: payment_name_in IN iby_transactions_v.payment_name%TYPE,
193: payment_type_in IN iby_transactions_v.payment_type%TYPE,
194: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
195: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
196: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
197: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
198: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
199: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,

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

192: payment_name_in IN iby_transactions_v.payment_name%TYPE,
193: payment_type_in IN iby_transactions_v.payment_type%TYPE,
194: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
195: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
196: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
197: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
198: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
199: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
200: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,

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

193: payment_type_in IN iby_transactions_v.payment_type%TYPE,
194: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
195: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
196: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
197: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
198: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
199: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
200: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
201: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,

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

194: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
195: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
196: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
197: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
198: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
199: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
200: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
201: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
202: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,

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

195: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
196: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
197: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
198: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
199: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
200: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
201: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
202: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
203: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,

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

196: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
197: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
198: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
199: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
200: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
201: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
202: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
203: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
204: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,

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

197: AVScode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
198: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
199: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
200: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
201: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
202: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
203: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
204: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
205: billeracct_in IN iby_tangible.acctno%type,

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

198: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
199: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
200: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
201: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
202: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
203: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
204: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
205: billeracct_in IN iby_tangible.acctno%type,
206: refinfo_in IN iby_tangible.refinfo%type,

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

199: Auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
200: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
201: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
202: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
203: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
204: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
205: billeracct_in IN iby_tangible.acctno%type,
206: refinfo_in IN iby_tangible.refinfo%type,
207: memo_in IN iby_tangible.memo%type,

Line 263: order_id_in IN iby_transactions_v.order_id%TYPE,

259: PROCEDURE insert_other_txn
260: (
261: ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
262: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
263: order_id_in IN iby_transactions_v.order_id%TYPE,
264: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
265: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
266: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
267: status_in IN iby_transactions_v.status%TYPE,

Line 264: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

260: (
261: ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
262: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
263: order_id_in IN iby_transactions_v.order_id%TYPE,
264: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
265: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
266: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
267: status_in IN iby_transactions_v.status%TYPE,
268: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,

Line 265: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

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

Line 266: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

262: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
263: order_id_in IN iby_transactions_v.order_id%TYPE,
264: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
265: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
266: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
267: status_in IN iby_transactions_v.status%TYPE,
268: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
269: payment_type_in IN iby_transactions_v.payment_type%TYPE,
270: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,

Line 267: status_in IN iby_transactions_v.status%TYPE,

263: order_id_in IN iby_transactions_v.order_id%TYPE,
264: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
265: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
266: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
267: status_in IN iby_transactions_v.status%TYPE,
268: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
269: payment_type_in IN iby_transactions_v.payment_type%TYPE,
270: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
271: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,

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

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

Line 269: payment_type_in IN iby_transactions_v.payment_type%TYPE,

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

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

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

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

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

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

268: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
269: payment_type_in IN iby_transactions_v.payment_type%TYPE,
270: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
271: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
272: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
273: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
276: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,

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

269: payment_type_in IN iby_transactions_v.payment_type%TYPE,
270: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
271: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
272: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
273: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
276: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
277: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,

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

270: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
271: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
272: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
273: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
276: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
277: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
278: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,

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

271: trxn_type_in IN iby_transactions_v.trxn_type%TYPE DEFAULT NULL,
272: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
273: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
276: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
277: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
278: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
279: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,

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

272: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
273: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
276: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
277: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
278: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
279: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
280: billeracct_in IN iby_tangible.acctno%type,

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

273: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
276: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
277: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
278: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
279: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
280: billeracct_in IN iby_tangible.acctno%type,
281: refinfo_in IN iby_tangible.refinfo%type,

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

274: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
275: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
276: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
277: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
278: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
279: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
280: billeracct_in IN iby_tangible.acctno%type,
281: refinfo_in IN iby_tangible.refinfo%type,
282: memo_in IN iby_tangible.memo%type,

Line 321: order_id_in IN iby_transactions_v.order_id%TYPE,

317:
318: PROCEDURE insert_timeout_txn
319: (
320: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
321: order_id_in IN iby_transactions_v.order_id%TYPE,
322: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
323: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
324: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
325: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,

Line 322: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

318: PROCEDURE insert_timeout_txn
319: (
320: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
321: order_id_in IN iby_transactions_v.order_id%TYPE,
322: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
323: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
324: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
325: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
326: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,

Line 323: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

319: (
320: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
321: order_id_in IN iby_transactions_v.order_id%TYPE,
322: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
323: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
324: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
325: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
326: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
327: status_in IN iby_transactions_v.status%TYPE,

Line 324: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

320: req_type_in IN iby_trxn_summaries_all.ReqType%TYPE,
321: order_id_in IN iby_transactions_v.order_id%TYPE,
322: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
323: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
324: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
325: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
326: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
327: status_in IN iby_transactions_v.status%TYPE,
328: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,

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

322: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
323: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
324: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
325: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
326: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
327: status_in IN iby_transactions_v.status%TYPE,
328: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
329: amount_in IN iby_tangible.amount%type,
330: currency_in IN iby_tangible.currencynamecode%type,

Line 327: status_in IN iby_transactions_v.status%TYPE,

323: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
324: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
325: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
326: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
327: status_in IN iby_transactions_v.status%TYPE,
328: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
329: amount_in IN iby_tangible.amount%type,
330: currency_in IN iby_tangible.currencynamecode%type,
331: billeracct_in IN iby_tangible.acctno%type,

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

354: /* procedures before inserting a new row into the transactions */
355: /* table */
356:
357: FUNCTION checkrows
358: (order_id_in IN iby_transactions_v.order_id%TYPE,
359: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
360: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
361: status_in IN iby_transactions_v.status%TYPE,
362: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)

Line 359: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

355: /* table */
356:
357: FUNCTION checkrows
358: (order_id_in IN iby_transactions_v.order_id%TYPE,
359: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
360: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
361: status_in IN iby_transactions_v.status%TYPE,
362: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)
363: RETURN number;

Line 360: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

356:
357: FUNCTION checkrows
358: (order_id_in IN iby_transactions_v.order_id%TYPE,
359: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
360: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
361: status_in IN iby_transactions_v.status%TYPE,
362: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)
363: RETURN number;
364:

Line 361: status_in IN iby_transactions_v.status%TYPE,

357: FUNCTION checkrows
358: (order_id_in IN iby_transactions_v.order_id%TYPE,
359: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
360: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
361: status_in IN iby_transactions_v.status%TYPE,
362: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)
363: RETURN number;
364:
365:

Line 362: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)

358: (order_id_in IN iby_transactions_v.order_id%TYPE,
359: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
360: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
361: status_in IN iby_transactions_v.status%TYPE,
362: trxn_type_in IN iby_transactions_v.trxn_type%TYPE)
363: RETURN number;
364:
365:
366:

Line 504: order_id_in IN iby_transactions_v.order_id%TYPE,

500: /* Inserts the transaction record for the closebatch operation */
501:
502: PROCEDURE insert_batch_txn
503: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
504: order_id_in IN iby_transactions_v.order_id%TYPE,
505: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
506: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
507: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
508: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

Line 505: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

501:
502: PROCEDURE insert_batch_txn
503: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
504: order_id_in IN iby_transactions_v.order_id%TYPE,
505: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
506: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
507: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
508: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
509: status_in IN iby_transactions_v.status%TYPE,

Line 506: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,

502: PROCEDURE insert_batch_txn
503: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
504: order_id_in IN iby_transactions_v.order_id%TYPE,
505: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
506: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
507: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
508: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
509: status_in IN iby_transactions_v.status%TYPE,
510: time_in IN iby_transactions_v.time%TYPE

Line 507: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

503: (ecapp_id_in IN iby_trxn_summaries_all.ECAPPID%TYPE,
504: order_id_in IN iby_transactions_v.order_id%TYPE,
505: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
506: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
507: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
508: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
509: status_in IN iby_transactions_v.status%TYPE,
510: time_in IN iby_transactions_v.time%TYPE
511: DEFAULT sysdate,

Line 508: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

504: order_id_in IN iby_transactions_v.order_id%TYPE,
505: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
506: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
507: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
508: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
509: status_in IN iby_transactions_v.status%TYPE,
510: time_in IN iby_transactions_v.time%TYPE
511: DEFAULT sysdate,
512: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

Line 509: status_in IN iby_transactions_v.status%TYPE,

505: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
506: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
507: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
508: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
509: status_in IN iby_transactions_v.status%TYPE,
510: time_in IN iby_transactions_v.time%TYPE
511: DEFAULT sysdate,
512: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
513: vendor_code_in IN iby_transactions_v.vendor_code%TYPE

Line 510: time_in IN iby_transactions_v.time%TYPE

506: merch_batchid_in IN iby_transactions_v.MerchBatchID%TYPE,
507: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
508: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
509: status_in IN iby_transactions_v.status%TYPE,
510: time_in IN iby_transactions_v.time%TYPE
511: DEFAULT sysdate,
512: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
513: vendor_code_in IN iby_transactions_v.vendor_code%TYPE
514: DEFAULT NULL,

Line 512: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

508: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
509: status_in IN iby_transactions_v.status%TYPE,
510: time_in IN iby_transactions_v.time%TYPE
511: DEFAULT sysdate,
512: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
513: vendor_code_in IN iby_transactions_v.vendor_code%TYPE
514: DEFAULT NULL,
515: vendor_message_in IN iby_transactions_v.vendor_message%TYPE
516: DEFAULT NULL,

Line 513: vendor_code_in IN iby_transactions_v.vendor_code%TYPE

509: status_in IN iby_transactions_v.status%TYPE,
510: time_in IN iby_transactions_v.time%TYPE
511: DEFAULT sysdate,
512: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
513: vendor_code_in IN iby_transactions_v.vendor_code%TYPE
514: DEFAULT NULL,
515: vendor_message_in IN iby_transactions_v.vendor_message%TYPE
516: DEFAULT NULL,
517: error_location_in IN iby_transactions_v.error_location%TYPE

Line 515: vendor_message_in IN iby_transactions_v.vendor_message%TYPE

511: DEFAULT sysdate,
512: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
513: vendor_code_in IN iby_transactions_v.vendor_code%TYPE
514: DEFAULT NULL,
515: vendor_message_in IN iby_transactions_v.vendor_message%TYPE
516: DEFAULT NULL,
517: error_location_in IN iby_transactions_v.error_location%TYPE
518: DEFAULT NULL,
519: trace_number_in IN iby_transactions_v.TraceNumber%TYPE

Line 517: error_location_in IN iby_transactions_v.error_location%TYPE

513: vendor_code_in IN iby_transactions_v.vendor_code%TYPE
514: DEFAULT NULL,
515: vendor_message_in IN iby_transactions_v.vendor_message%TYPE
516: DEFAULT NULL,
517: error_location_in IN iby_transactions_v.error_location%TYPE
518: DEFAULT NULL,
519: trace_number_in IN iby_transactions_v.TraceNumber%TYPE
520: DEFAULT NULL,
521:

Line 519: trace_number_in IN iby_transactions_v.TraceNumber%TYPE

515: vendor_message_in IN iby_transactions_v.vendor_message%TYPE
516: DEFAULT NULL,
517: error_location_in IN iby_transactions_v.error_location%TYPE
518: DEFAULT NULL,
519: trace_number_in IN iby_transactions_v.TraceNumber%TYPE
520: DEFAULT NULL,
521:
522: org_id_in IN iby_trxn_summaries_all.org_id%type
523: DEFAULT NULL,

Line 532: order_id_in IN iby_transactions_v.order_id%TYPE,

528:
529:
530: PROCEDURE insert_query_txn
531: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
532: order_id_in IN iby_transactions_v.order_id%TYPE,
533: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
534: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
535: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
536: status_in IN iby_transactions_v.status%TYPE,

Line 533: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,

529:
530: PROCEDURE insert_query_txn
531: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
532: order_id_in IN iby_transactions_v.order_id%TYPE,
533: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
534: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
535: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
536: status_in IN iby_transactions_v.status%TYPE,
537: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,

Line 534: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,

530: PROCEDURE insert_query_txn
531: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
532: order_id_in IN iby_transactions_v.order_id%TYPE,
533: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
534: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
535: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
536: status_in IN iby_transactions_v.status%TYPE,
537: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
538: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

Line 535: vendor_key_in IN iby_transactions_v.bepkey%TYPE,

531: (transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
532: order_id_in IN iby_transactions_v.order_id%TYPE,
533: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
534: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
535: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
536: status_in IN iby_transactions_v.status%TYPE,
537: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
538: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
539: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,

Line 536: status_in IN iby_transactions_v.status%TYPE,

532: order_id_in IN iby_transactions_v.order_id%TYPE,
533: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
534: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
535: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
536: status_in IN iby_transactions_v.status%TYPE,
537: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
538: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
539: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
540: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,

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

533: merchant_id_in IN iby_transactions_v.merchant_id%TYPE,
534: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
535: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
536: status_in IN iby_transactions_v.status%TYPE,
537: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
538: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
539: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
540: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
541: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,

Line 538: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,

534: vendor_id_in IN iby_transactions_v.vendor_id%TYPE,
535: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
536: status_in IN iby_transactions_v.status%TYPE,
537: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
538: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
539: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
540: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
541: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
542: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,

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

535: vendor_key_in IN iby_transactions_v.bepkey%TYPE,
536: status_in IN iby_transactions_v.status%TYPE,
537: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
538: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
539: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
540: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
541: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
542: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
543: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,

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

536: status_in IN iby_transactions_v.status%TYPE,
537: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
538: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
539: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
540: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
541: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
542: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
543: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
544: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,

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

537: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
538: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
539: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
540: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
541: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
542: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
543: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
544: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
545: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,

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

538: trxn_type_in IN iby_transactions_v.trxn_type%TYPE,
539: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
540: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
541: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
542: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
543: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
544: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
545: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
546: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,

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

539: amount_in IN iby_transactions_v.amount%TYPE DEFAULT NULL,
540: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
541: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
542: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
543: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
544: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
545: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
546: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
547: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,

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

540: currency_in IN iby_transactions_v.currency%TYPE DEFAULT NULL,
541: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
542: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
543: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
544: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
545: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
546: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
547: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
548: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,

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

541: payment_name_in IN iby_transactions_v.payment_name%TYPE DEFAULT NULL,
542: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
543: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
544: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
545: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
546: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
547: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
548: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
549: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,

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

542: authcode_in IN iby_transactions_v.authcode%TYPE DEFAULT NULL,
543: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
544: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
545: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
546: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
547: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
548: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
549: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
550: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,

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

543: referencecode_in IN iby_transactions_v.referencecode%TYPE DEFAULT NULL,
544: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
545: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
546: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
547: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
548: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
549: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
550: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
551: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,

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

544: avscode_in IN iby_transactions_v.AVScode%TYPE DEFAULT NULL,
545: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
546: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
547: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
548: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
549: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
550: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
551: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
552: ecappid_in IN iby_ecapp.ecappid%type,

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

545: acquirer_in IN iby_transactions_v.acquirer%TYPE DEFAULT NULL,
546: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
547: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
548: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
549: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
550: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
551: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
552: ecappid_in IN iby_ecapp.ecappid%type,
553: req_type_in IN iby_trxn_summaries_all.reqtype%type);

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

546: auxmsg_in IN iby_transactions_v.Auxmsg%TYPE DEFAULT NULL,
547: vendor_code_in IN iby_transactions_v.vendor_code%TYPE DEFAULT NULL,
548: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
549: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
550: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
551: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
552: ecappid_in IN iby_ecapp.ecappid%type,
553: req_type_in IN iby_trxn_summaries_all.reqtype%type);
554: