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_TRANSACTIONSET_PKG dependencies on IBY_TANGIBLE

Line 26: billeracct_in IN iby_tangible.acctno%type,

22: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
23: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
24: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
25: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
26: billeracct_in IN iby_tangible.acctno%type,
27: refinfo_in IN iby_tangible.refinfo%type,
28: memo_in IN iby_tangible.memo%type,
29: order_medium_in IN iby_tangible.order_medium%TYPE,
30: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

Line 27: refinfo_in IN iby_tangible.refinfo%type,

23: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
24: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
25: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
26: billeracct_in IN iby_tangible.acctno%type,
27: refinfo_in IN iby_tangible.refinfo%type,
28: memo_in IN iby_tangible.memo%type,
29: order_medium_in IN iby_tangible.order_medium%TYPE,
30: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
31: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 28: memo_in IN iby_tangible.memo%type,

24: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
25: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
26: billeracct_in IN iby_tangible.acctno%type,
27: refinfo_in IN iby_tangible.refinfo%type,
28: memo_in IN iby_tangible.memo%type,
29: order_medium_in IN iby_tangible.order_medium%TYPE,
30: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
31: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
32: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

Line 29: order_medium_in IN iby_tangible.order_medium%TYPE,

25: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
26: billeracct_in IN iby_tangible.acctno%type,
27: refinfo_in IN iby_tangible.refinfo%type,
28: memo_in IN iby_tangible.memo%type,
29: order_medium_in IN iby_tangible.order_medium%TYPE,
30: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
31: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
32: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
33: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)

Line 30: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

26: billeracct_in IN iby_tangible.acctno%type,
27: refinfo_in IN iby_tangible.refinfo%type,
28: memo_in IN iby_tangible.memo%type,
29: order_medium_in IN iby_tangible.order_medium%TYPE,
30: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
31: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
32: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
33: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
34: IS

Line 78: -- Create a new entry in iby_tangible table

74:
75: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
76:
77:
78: -- Create a new entry in iby_tangible table
79: iby_bill_pkg.createBill(order_id_in,price_in,currency_in,
80: billeracct_in,refinfo_in, memo_in,
81: order_medium_in, eft_auth_method_in,
82: l_tmid);

Line 126: --Update iby_tangible table

122: WHERE TangibleID = order_id_in
123: AND UPPER(ReqType) = UPPER(req_type_in)
124: AND PayeeID = merchant_id_in;
125:
126: --Update iby_tangible table
127: iby_bill_pkg.modBill(l_tmid,order_id_in,price_in,currency_in,
128: billeracct_in,refinfo_in,memo_in,
129: order_medium_in, eft_auth_method_in);
130:

Line 207: billeracct_in IN iby_tangible.acctno%type ,

203: payment_method_in IN iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
204: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
205: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
206: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
207: billeracct_in IN iby_tangible.acctno%type ,
208: refinfo_in IN iby_tangible.refinfo%type,
209: memo_in IN iby_tangible.memo%type ,
210: order_medium_in IN iby_tangible.order_medium%TYPE,
211: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

Line 208: refinfo_in IN iby_tangible.refinfo%type,

204: vendor_code_in IN iby_trxn_summaries_all.BEPCode%TYPE,
205: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
206: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
207: billeracct_in IN iby_tangible.acctno%type ,
208: refinfo_in IN iby_tangible.refinfo%type,
209: memo_in IN iby_tangible.memo%type ,
210: order_medium_in IN iby_tangible.order_medium%TYPE,
211: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
212: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 209: memo_in IN iby_tangible.memo%type ,

205: vendor_message_in IN iby_trxn_summaries_all.BEPMessage%TYPE,
206: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
207: billeracct_in IN iby_tangible.acctno%type ,
208: refinfo_in IN iby_tangible.refinfo%type,
209: memo_in IN iby_tangible.memo%type ,
210: order_medium_in IN iby_tangible.order_medium%TYPE,
211: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
212: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
213: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

Line 210: order_medium_in IN iby_tangible.order_medium%TYPE,

206: error_location_in IN iby_trxn_summaries_all.ErrorLocation%TYPE,
207: billeracct_in IN iby_tangible.acctno%type ,
208: refinfo_in IN iby_tangible.refinfo%type,
209: memo_in IN iby_tangible.memo%type ,
210: order_medium_in IN iby_tangible.order_medium%TYPE,
211: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
212: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
213: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
214: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)

Line 211: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

207: billeracct_in IN iby_tangible.acctno%type ,
208: refinfo_in IN iby_tangible.refinfo%type,
209: memo_in IN iby_tangible.memo%type ,
210: order_medium_in IN iby_tangible.order_medium%TYPE,
211: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
212: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
213: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
214: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
215: IS

Line 401: -- Update iby_tangible table

397: l_mbatchid);
398:
399:
400: IF (UPPER(req_type_in) = 'ORAPMTCREDIT') THEN
401: -- Update iby_tangible table
402: iby_bill_pkg.modBill(l_tmid,order_id_in,price_in,currency_in,
403: billeracct_in,refinfo_in,memo_in,
404: order_medium_in, eft_auth_method_in);
405: END IF;

Line 501: billeracct_in IN iby_tangible.acctno%type,

497: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
498: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
499: payment_method_in IN
500: iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
501: billeracct_in IN iby_tangible.acctno%type,
502: refinfo_in IN iby_tangible.refinfo%type,
503: memo_in IN iby_tangible.memo%type,
504: order_medium_in IN iby_tangible.order_medium%TYPE,
505: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

Line 502: refinfo_in IN iby_tangible.refinfo%type,

498: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
499: payment_method_in IN
500: iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
501: billeracct_in IN iby_tangible.acctno%type,
502: refinfo_in IN iby_tangible.refinfo%type,
503: memo_in IN iby_tangible.memo%type,
504: order_medium_in IN iby_tangible.order_medium%TYPE,
505: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
506: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 503: memo_in IN iby_tangible.memo%type,

499: payment_method_in IN
500: iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
501: billeracct_in IN iby_tangible.acctno%type,
502: refinfo_in IN iby_tangible.refinfo%type,
503: memo_in IN iby_tangible.memo%type,
504: order_medium_in IN iby_tangible.order_medium%TYPE,
505: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
506: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
507: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

Line 504: order_medium_in IN iby_tangible.order_medium%TYPE,

500: iby_trxn_summaries_all.PAYMENTMETHODNAME%TYPE,
501: billeracct_in IN iby_tangible.acctno%type,
502: refinfo_in IN iby_tangible.refinfo%type,
503: memo_in IN iby_tangible.memo%type,
504: order_medium_in IN iby_tangible.order_medium%TYPE,
505: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
506: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
507: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
508: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)

Line 505: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

501: billeracct_in IN iby_tangible.acctno%type,
502: refinfo_in IN iby_tangible.refinfo%type,
503: memo_in IN iby_tangible.memo%type,
504: order_medium_in IN iby_tangible.order_medium%TYPE,
505: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
506: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
507: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
508: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
509: IS

Line 596: ** Create an entry in iby_tangible table

592: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
593: iby_transactioncc_pkg.getMBatchID(batch_id_in, merchant_id_in,
594: l_mbatchid);
595: /*
596: ** Create an entry in iby_tangible table
597: */
598: iby_bill_pkg.createBill(order_id_in,price_in,currency_in,
599: billeracct_in,refinfo_in, memo_in,
600: order_medium_in, eft_auth_method_in,

Line 664: --Update iby_tangible table

660:
661: iby_transactioncc_pkg.getMBatchID(batch_id_in, merchant_id_in,
662: l_mbatchid);
663:
664: --Update iby_tangible table
665: iby_bill_pkg.modBill(l_tmid,order_id_in,price_in,currency_in,
666: billeracct_in,refinfo_in,memo_in,
667: order_medium_in, eft_auth_method_in);
668:

Line 755: billeracct_in IN iby_tangible.acctno%type,

751: vendor_code_in IN OUT NOCOPY iby_trxn_summaries_all.BEPCode%TYPE,
752: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
753: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
754: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
755: billeracct_in IN iby_tangible.acctno%type,
756: refinfo_in IN iby_tangible.refinfo%type,
757: memo_in IN iby_tangible.memo%type,
758: order_medium_in IN iby_tangible.order_medium%TYPE,
759: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

Line 756: refinfo_in IN iby_tangible.refinfo%type,

752: vendor_message_in IN OUT NOCOPY iby_trxn_summaries_all.BEPMessage%TYPE,
753: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
754: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
755: billeracct_in IN iby_tangible.acctno%type,
756: refinfo_in IN iby_tangible.refinfo%type,
757: memo_in IN iby_tangible.memo%type,
758: order_medium_in IN iby_tangible.order_medium%TYPE,
759: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
760: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 757: memo_in IN iby_tangible.memo%type,

753: error_location_in IN OUT NOCOPY iby_trxn_summaries_all.ErrorLocation%TYPE,
754: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
755: billeracct_in IN iby_tangible.acctno%type,
756: refinfo_in IN iby_tangible.refinfo%type,
757: memo_in IN iby_tangible.memo%type,
758: order_medium_in IN iby_tangible.order_medium%TYPE,
759: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
760: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
761: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

Line 758: order_medium_in IN iby_tangible.order_medium%TYPE,

754: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
755: billeracct_in IN iby_tangible.acctno%type,
756: refinfo_in IN iby_tangible.refinfo%type,
757: memo_in IN iby_tangible.memo%type,
758: order_medium_in IN iby_tangible.order_medium%TYPE,
759: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
760: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
761: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
762: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)

Line 759: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

755: billeracct_in IN iby_tangible.acctno%type,
756: refinfo_in IN iby_tangible.refinfo%type,
757: memo_in IN iby_tangible.memo%type,
758: order_medium_in IN iby_tangible.order_medium%TYPE,
759: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
760: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
761: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
762: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
763: IS

Line 840: --Create an entry in iby_tangible table

836: END IF;
837:
838: transaction_id_in_out := transaction_id;
839: -- I suppose we need a new transactionid only for ORAPMTCREDIT
840: --Create an entry in iby_tangible table
841: iby_bill_pkg.createBill(order_id_in,price_in,currency_in,
842: billeracct_in,refinfo_in, memo_in,
843: order_medium_in, eft_auth_method_in,
844: l_tmid);

Line 930: -- Update iby_tangible table

926: iby_transactioncc_pkg.getMBatchID(batch_id_in, merchant_id_in,
927: l_mbatchid);
928:
929: IF (UPPER(req_type_in) = 'ORAPMTCREDIT') THEN
930: -- Update iby_tangible table
931: iby_bill_pkg.modBill(l_tmid,order_id_in,price_in,currency_in,
932: billeracct_in,refinfo_in,memo_in,
933: order_medium_in, eft_auth_method_in);
934: END IF;

Line 1003: currency_in IN iby_tangible.currencynamecode%type,

999: payment_name_in IN iby_trxn_core.InstrName%TYPE,
1000: time_in IN iby_trxn_summaries_all.UpdateDate%TYPE,
1001: status_in IN iby_trxn_summaries_all.Status%TYPE,
1002: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
1003: currency_in IN iby_tangible.currencynamecode%type,
1004: amount_in IN iby_transactions_v.amount%TYPE,
1005: billeracct_in IN iby_tangible.acctno%type,
1006: refinfo_in IN iby_tangible.refinfo%type,
1007: memo_in IN iby_tangible.memo%type,

Line 1005: billeracct_in IN iby_tangible.acctno%type,

1001: status_in IN iby_trxn_summaries_all.Status%TYPE,
1002: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
1003: currency_in IN iby_tangible.currencynamecode%type,
1004: amount_in IN iby_transactions_v.amount%TYPE,
1005: billeracct_in IN iby_tangible.acctno%type,
1006: refinfo_in IN iby_tangible.refinfo%type,
1007: memo_in IN iby_tangible.memo%type,
1008: order_medium_in IN iby_tangible.order_medium%TYPE,
1009: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

Line 1006: refinfo_in IN iby_tangible.refinfo%type,

1002: transaction_id_in_out IN OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
1003: currency_in IN iby_tangible.currencynamecode%type,
1004: amount_in IN iby_transactions_v.amount%TYPE,
1005: billeracct_in IN iby_tangible.acctno%type,
1006: refinfo_in IN iby_tangible.refinfo%type,
1007: memo_in IN iby_tangible.memo%type,
1008: order_medium_in IN iby_tangible.order_medium%TYPE,
1009: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1010: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,

Line 1007: memo_in IN iby_tangible.memo%type,

1003: currency_in IN iby_tangible.currencynamecode%type,
1004: amount_in IN iby_transactions_v.amount%TYPE,
1005: billeracct_in IN iby_tangible.acctno%type,
1006: refinfo_in IN iby_tangible.refinfo%type,
1007: memo_in IN iby_tangible.memo%type,
1008: order_medium_in IN iby_tangible.order_medium%TYPE,
1009: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1010: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1011: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

Line 1008: order_medium_in IN iby_tangible.order_medium%TYPE,

1004: amount_in IN iby_transactions_v.amount%TYPE,
1005: billeracct_in IN iby_tangible.acctno%type,
1006: refinfo_in IN iby_tangible.refinfo%type,
1007: memo_in IN iby_tangible.memo%type,
1008: order_medium_in IN iby_tangible.order_medium%TYPE,
1009: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1010: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1011: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1012: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)

Line 1009: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

1005: billeracct_in IN iby_tangible.acctno%type,
1006: refinfo_in IN iby_tangible.refinfo%type,
1007: memo_in IN iby_tangible.memo%type,
1008: order_medium_in IN iby_tangible.order_medium%TYPE,
1009: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1010: org_id_in IN iby_trxn_summaries_all.org_id%TYPE,
1011: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1012: instrnum_in IN iby_trxn_summaries_all.instrnumber%type)
1013: IS

Line 1047: -- Create an entry in iby_tangible table

1043: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
1044:
1045: IF (UPPER(req_type_in) = 'ORAPMTREQ' or
1046: UPPER(req_type_in) = 'ORAPMTCREDIT') THEN
1047: -- Create an entry in iby_tangible table
1048: iby_bill_pkg.createBill(order_id_in,amount_in,currency_in,
1049: billeracct_in,refinfo_in, memo_in,
1050: order_medium_in, eft_auth_method_in,
1051: l_tmid);

Line 1115: -- Update iby_tangible table

1111: AND PayeeID = merchant_id_in;
1112:
1113: IF (UPPER(req_type_in) = 'ORAPMTREQ' or
1114: UPPER(req_type_in) = 'ORAPMTCREDIT') THEN
1115: -- Update iby_tangible table
1116: iby_bill_pkg.modBill(l_tmid,order_id_in,amount_in,currency_in,
1117: billeracct_in,refinfo_in,memo_in,
1118: order_medium_in, eft_auth_method_in);
1119: END IF;