DBA Data[Home] [Help]

APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_TANGIBLE

Line 283: billeracct_in IN iby_tangible.acctno%type,

279: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
280: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
281: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
282: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
283: billeracct_in IN iby_tangible.acctno%type,
284: refinfo_in IN iby_tangible.refinfo%type,
285: memo_in IN iby_tangible.memo%type,
286: order_medium_in IN iby_tangible.order_medium%TYPE,
287: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

Line 284: refinfo_in IN iby_tangible.refinfo%type,

280: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
281: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
282: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
283: billeracct_in IN iby_tangible.acctno%type,
284: refinfo_in IN iby_tangible.refinfo%type,
285: memo_in IN iby_tangible.memo%type,
286: order_medium_in IN iby_tangible.order_medium%TYPE,
287: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
288: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

Line 285: memo_in IN iby_tangible.memo%type,

281: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
282: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
283: billeracct_in IN iby_tangible.acctno%type,
284: refinfo_in IN iby_tangible.refinfo%type,
285: memo_in IN iby_tangible.memo%type,
286: order_medium_in IN iby_tangible.order_medium%TYPE,
287: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
288: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
289: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

Line 286: order_medium_in IN iby_tangible.order_medium%TYPE,

282: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
283: billeracct_in IN iby_tangible.acctno%type,
284: refinfo_in IN iby_tangible.refinfo%type,
285: memo_in IN iby_tangible.memo%type,
286: order_medium_in IN iby_tangible.order_medium%TYPE,
287: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
288: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
289: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
290: payerid_in IN iby_trxn_summaries_all.payerid%type,

Line 287: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

283: billeracct_in IN iby_tangible.acctno%type,
284: refinfo_in IN iby_tangible.refinfo%type,
285: memo_in IN iby_tangible.memo%type,
286: order_medium_in IN iby_tangible.order_medium%TYPE,
287: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
288: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
289: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
290: payerid_in IN iby_trxn_summaries_all.payerid%type,
291: instrtype_in IN iby_trxn_summaries_all.instrType%type,

Line 381: billeracct_in IN iby_tangible.acctno%type,

377: vendor_message_in IN iby_transactions_v.vendor_message%TYPE DEFAULT NULL,
378: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
379: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
380: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
381: billeracct_in IN iby_tangible.acctno%type,
382: refinfo_in IN iby_tangible.refinfo%type,
383: memo_in IN iby_tangible.memo%type,
384: order_medium_in IN iby_tangible.order_medium%TYPE,
385: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

Line 382: refinfo_in IN iby_tangible.refinfo%type,

378: error_location_in IN iby_transactions_v.error_location%TYPE DEFAULT NULL,
379: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
380: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
381: billeracct_in IN iby_tangible.acctno%type,
382: refinfo_in IN iby_tangible.refinfo%type,
383: memo_in IN iby_tangible.memo%type,
384: order_medium_in IN iby_tangible.order_medium%TYPE,
385: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
386: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

Line 383: memo_in IN iby_tangible.memo%type,

379: trace_number_in IN iby_transactions_v.TraceNumber%TYPE DEFAULT NULL,
380: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
381: billeracct_in IN iby_tangible.acctno%type,
382: refinfo_in IN iby_tangible.refinfo%type,
383: memo_in IN iby_tangible.memo%type,
384: order_medium_in IN iby_tangible.order_medium%TYPE,
385: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
386: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
387: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

Line 384: order_medium_in IN iby_tangible.order_medium%TYPE,

380: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
381: billeracct_in IN iby_tangible.acctno%type,
382: refinfo_in IN iby_tangible.refinfo%type,
383: memo_in IN iby_tangible.memo%type,
384: order_medium_in IN iby_tangible.order_medium%TYPE,
385: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
386: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
387: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
388: payerid_in IN iby_trxn_summaries_all.payerid%type,

Line 385: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

381: billeracct_in IN iby_tangible.acctno%type,
382: refinfo_in IN iby_tangible.refinfo%type,
383: memo_in IN iby_tangible.memo%type,
384: order_medium_in IN iby_tangible.order_medium%TYPE,
385: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
386: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
387: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
388: payerid_in IN iby_trxn_summaries_all.payerid%type,
389: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

Line 432: amount_in IN iby_tangible.amount%type,

428: ecapp_id_in IN iby_trxn_summaries_all.ecappid%TYPE,
429: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
430: status_in IN iby_transactions_v.status%TYPE,
431: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
432: amount_in IN iby_tangible.amount%type,
433: currency_in IN iby_tangible.currencynamecode%type,
434: billeracct_in IN iby_tangible.acctno%type,
435: refinfo_in IN iby_tangible.refinfo%type,
436: memo_in IN iby_tangible.memo%type,

Line 433: currency_in IN iby_tangible.currencynamecode%type,

429: time_in IN iby_transactions_v.time%TYPE DEFAULT sysdate,
430: status_in IN iby_transactions_v.status%TYPE,
431: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
432: amount_in IN iby_tangible.amount%type,
433: currency_in IN iby_tangible.currencynamecode%type,
434: billeracct_in IN iby_tangible.acctno%type,
435: refinfo_in IN iby_tangible.refinfo%type,
436: memo_in IN iby_tangible.memo%type,
437: order_medium_in IN iby_tangible.order_medium%TYPE,

Line 434: billeracct_in IN iby_tangible.acctno%type,

430: status_in IN iby_transactions_v.status%TYPE,
431: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
432: amount_in IN iby_tangible.amount%type,
433: currency_in IN iby_tangible.currencynamecode%type,
434: billeracct_in IN iby_tangible.acctno%type,
435: refinfo_in IN iby_tangible.refinfo%type,
436: memo_in IN iby_tangible.memo%type,
437: order_medium_in IN iby_tangible.order_medium%TYPE,
438: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

Line 435: refinfo_in IN iby_tangible.refinfo%type,

431: org_id_in IN iby_trxn_summaries_all.org_id%type DEFAULT NULL,
432: amount_in IN iby_tangible.amount%type,
433: currency_in IN iby_tangible.currencynamecode%type,
434: billeracct_in IN iby_tangible.acctno%type,
435: refinfo_in IN iby_tangible.refinfo%type,
436: memo_in IN iby_tangible.memo%type,
437: order_medium_in IN iby_tangible.order_medium%TYPE,
438: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
439: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

Line 436: memo_in IN iby_tangible.memo%type,

432: amount_in IN iby_tangible.amount%type,
433: currency_in IN iby_tangible.currencynamecode%type,
434: billeracct_in IN iby_tangible.acctno%type,
435: refinfo_in IN iby_tangible.refinfo%type,
436: memo_in IN iby_tangible.memo%type,
437: order_medium_in IN iby_tangible.order_medium%TYPE,
438: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
439: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
440: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

Line 437: order_medium_in IN iby_tangible.order_medium%TYPE,

433: currency_in IN iby_tangible.currencynamecode%type,
434: billeracct_in IN iby_tangible.acctno%type,
435: refinfo_in IN iby_tangible.refinfo%type,
436: memo_in IN iby_tangible.memo%type,
437: order_medium_in IN iby_tangible.order_medium%TYPE,
438: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
439: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
440: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
441: payerid_in IN iby_trxn_summaries_all.payerid%type,

Line 438: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

434: billeracct_in IN iby_tangible.acctno%type,
435: refinfo_in IN iby_tangible.refinfo%type,
436: memo_in IN iby_tangible.memo%type,
437: order_medium_in IN iby_tangible.order_medium%TYPE,
438: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
439: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
440: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
441: payerid_in IN iby_trxn_summaries_all.payerid%type,
442: instrtype_in IN iby_trxn_summaries_all.instrType%type,

Line 675: i_tangibleid in iby_tangible.tangibleid%type)

671: ** Purpose: get the next trxnid availabe, make sure there is only one TID
672: ** per tangibleid, payeeid combination
673: */
674: Function getTID(i_payeeid in iby_payee.payeeid%type,
675: i_tangibleid in iby_tangible.tangibleid%type)
676: return number;
677:
678:
679: /*

Line 686: i_tangibleid in iby_tangible.tangibleid%type)

682: ** tangibleid, payeeid combination this method
683: ** returns -1, else it returns a unique trxnid.
684: */
685: Function getTIDUniqueCheck(i_payeeid in iby_payee.payeeid%type,
686: i_tangibleid in iby_tangible.tangibleid%type)
687: return number;
688:
689:
690: Function getNumPendingTrxns(i_payeeid in iby_payee.payeeid%type,

Line 691: i_tangibleid in iby_tangible.tangibleid%type,

687: return number;
688:
689:
690: Function getNumPendingTrxns(i_payeeid in iby_payee.payeeid%type,
691: i_tangibleid in iby_tangible.tangibleid%type,
692: i_reqtype in iby_trxn_summaries_all.reqtype%type)
693: return number;
694:
695: Function getOrgId(i_tid in iby_trxn_summaries_all.transactionid%type)