DBA Data[Home] [Help]

APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_TANGIBLE

Line 205: billeracct_in IN iby_tangible.acctno%type,

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,

Line 206: refinfo_in IN iby_tangible.refinfo%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,

Line 207: memo_in IN iby_tangible.memo%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,

Line 208: order_medium_in IN iby_tangible.order_medium%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,

Line 209: eft_auth_method_in IN iby_tangible.eft_auth_method%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,

Line 280: billeracct_in IN iby_tangible.acctno%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,

Line 281: refinfo_in IN iby_tangible.refinfo%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,

Line 282: memo_in IN iby_tangible.memo%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,

Line 283: order_medium_in IN iby_tangible.order_medium%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,

Line 284: eft_auth_method_in IN iby_tangible.eft_auth_method%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,

Line 329: amount_in IN iby_tangible.amount%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,

Line 330: currency_in IN iby_tangible.currencynamecode%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,

Line 331: billeracct_in IN iby_tangible.acctno%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,

Line 332: refinfo_in IN iby_tangible.refinfo%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,

Line 333: memo_in IN iby_tangible.memo%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,

Line 334: order_medium_in IN iby_tangible.order_medium%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,

Line 335: eft_auth_method_in IN iby_tangible.eft_auth_method%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,

Line 571: i_tangibleid in iby_tangible.tangibleid%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: /*

Line 582: i_tangibleid in iby_tangible.tangibleid%type)

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,

Line 587: i_tangibleid in iby_tangible.tangibleid%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)