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,
208: order_medium_in IN iby_tangible.order_medium%TYPE,
209: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
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,
208: order_medium_in IN iby_tangible.order_medium%TYPE,
209: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
210: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
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,
208: order_medium_in IN iby_tangible.order_medium%TYPE,
209: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
210: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
211: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
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,
208: order_medium_in IN iby_tangible.order_medium%TYPE,
209: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
210: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
211: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
212: payerid_in IN iby_trxn_summaries_all.payerid%type,
205: billeracct_in IN iby_tangible.acctno%type,
206: refinfo_in IN iby_tangible.refinfo%type,
207: memo_in IN iby_tangible.memo%type,
208: order_medium_in IN iby_tangible.order_medium%TYPE,
209: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
210: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
211: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
212: payerid_in IN iby_trxn_summaries_all.payerid%type,
213: instrtype_in IN iby_trxn_summaries_all.instrType%type,
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,
283: order_medium_in IN iby_tangible.order_medium%TYPE,
284: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
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,
283: order_medium_in IN iby_tangible.order_medium%TYPE,
284: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
285: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
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,
283: order_medium_in IN iby_tangible.order_medium%TYPE,
284: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
285: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
286: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
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,
283: order_medium_in IN iby_tangible.order_medium%TYPE,
284: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
285: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
286: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
287: payerid_in IN iby_trxn_summaries_all.payerid%type,
280: billeracct_in IN iby_tangible.acctno%type,
281: refinfo_in IN iby_tangible.refinfo%type,
282: memo_in IN iby_tangible.memo%type,
283: order_medium_in IN iby_tangible.order_medium%TYPE,
284: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
285: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
286: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
287: payerid_in IN iby_trxn_summaries_all.payerid%type,
288: master_key_in IN iby_security_pkg.DES3_KEY_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,
332: refinfo_in IN iby_tangible.refinfo%type,
333: memo_in IN iby_tangible.memo%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,
332: refinfo_in IN iby_tangible.refinfo%type,
333: memo_in IN iby_tangible.memo%type,
334: order_medium_in IN iby_tangible.order_medium%TYPE,
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,
332: refinfo_in IN iby_tangible.refinfo%type,
333: memo_in IN iby_tangible.memo%type,
334: order_medium_in IN iby_tangible.order_medium%TYPE,
335: eft_auth_method_in IN iby_tangible.eft_auth_method%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,
332: refinfo_in IN iby_tangible.refinfo%type,
333: memo_in IN iby_tangible.memo%type,
334: order_medium_in IN iby_tangible.order_medium%TYPE,
335: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
336: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
329: amount_in IN iby_tangible.amount%type,
330: currency_in IN iby_tangible.currencynamecode%type,
331: billeracct_in IN iby_tangible.acctno%type,
332: refinfo_in IN iby_tangible.refinfo%type,
333: memo_in IN iby_tangible.memo%type,
334: order_medium_in IN iby_tangible.order_medium%TYPE,
335: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
336: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
337: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
330: currency_in IN iby_tangible.currencynamecode%type,
331: billeracct_in IN iby_tangible.acctno%type,
332: refinfo_in IN iby_tangible.refinfo%type,
333: memo_in IN iby_tangible.memo%type,
334: order_medium_in IN iby_tangible.order_medium%TYPE,
335: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
336: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
337: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
338: payerid_in IN iby_trxn_summaries_all.payerid%type,
331: billeracct_in IN iby_tangible.acctno%type,
332: refinfo_in IN iby_tangible.refinfo%type,
333: memo_in IN iby_tangible.memo%type,
334: order_medium_in IN iby_tangible.order_medium%TYPE,
335: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
336: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
337: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
338: payerid_in IN iby_trxn_summaries_all.payerid%type,
339: instrtype_in IN iby_trxn_summaries_all.instrType%type,
567: ** Purpose: get the next trxnid availabe, make sure there is only one TID
568: ** per tangibleid, payeeid combination
569: */
570: Function getTID(i_payeeid in iby_payee.payeeid%type,
571: i_tangibleid in iby_tangible.tangibleid%type)
572: return number;
573:
574:
575: /*
578: ** tangibleid, payeeid combination this method
579: ** returns -1, else it returns a unique trxnid.
580: */
581: Function getTIDUniqueCheck(i_payeeid in iby_payee.payeeid%type,
582: i_tangibleid in iby_tangible.tangibleid%type)
583: return number;
584:
585:
586: Function getNumPendingTrxns(i_payeeid in iby_payee.payeeid%type,
583: return number;
584:
585:
586: Function getNumPendingTrxns(i_payeeid in iby_payee.payeeid%type,
587: i_tangibleid in iby_tangible.tangibleid%type,
588: i_reqtype in iby_trxn_summaries_all.reqtype%type)
589: return number;
590:
591: Function getOrgId(i_tid in iby_trxn_summaries_all.transactionid%type)