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_TANGIBLE

Line 289: billeracct_in IN iby_tangible.acctno%type,

285: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
286: error_location_in IN iby_transactions_v.error_location%TYPE,
287: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
288: org_id_in IN iby_trxn_summaries_all.org_id%type,
289: billeracct_in IN iby_tangible.acctno%type,
290: refinfo_in IN iby_tangible.refinfo%type,
291: memo_in IN iby_tangible.memo%type,
292: order_medium_in IN iby_tangible.order_medium%TYPE,
293: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

Line 290: refinfo_in IN iby_tangible.refinfo%type,

286: error_location_in IN iby_transactions_v.error_location%TYPE,
287: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
288: org_id_in IN iby_trxn_summaries_all.org_id%type,
289: billeracct_in IN iby_tangible.acctno%type,
290: refinfo_in IN iby_tangible.refinfo%type,
291: memo_in IN iby_tangible.memo%type,
292: order_medium_in IN iby_tangible.order_medium%TYPE,
293: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
294: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

Line 291: memo_in IN iby_tangible.memo%type,

287: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
288: org_id_in IN iby_trxn_summaries_all.org_id%type,
289: billeracct_in IN iby_tangible.acctno%type,
290: refinfo_in IN iby_tangible.refinfo%type,
291: memo_in IN iby_tangible.memo%type,
292: order_medium_in IN iby_tangible.order_medium%TYPE,
293: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
294: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
295: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

Line 292: order_medium_in IN iby_tangible.order_medium%TYPE,

288: org_id_in IN iby_trxn_summaries_all.org_id%type,
289: billeracct_in IN iby_tangible.acctno%type,
290: refinfo_in IN iby_tangible.refinfo%type,
291: memo_in IN iby_tangible.memo%type,
292: order_medium_in IN iby_tangible.order_medium%TYPE,
293: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
294: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
295: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
296: payerid_in IN iby_trxn_summaries_all.payerid%type,

Line 293: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

289: billeracct_in IN iby_tangible.acctno%type,
290: refinfo_in IN iby_tangible.refinfo%type,
291: memo_in IN iby_tangible.memo%type,
292: order_medium_in IN iby_tangible.order_medium%TYPE,
293: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
294: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
295: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
296: payerid_in IN iby_trxn_summaries_all.payerid%type,
297: instrtype_in IN iby_trxn_summaries_all.instrType%type,

Line 465: --Create an entry in iby_tangible table

461: transaction_mid_out := l_trxn_mid;
462:
463: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
464:
465: --Create an entry in iby_tangible table
466: iby_bill_pkg.createBill(order_id_in,amount_in,currency_in,
467: billeracct_in,refinfo_in, memo_in,
468: order_medium_in, eft_auth_method_in, l_tmid);
469: --test_debug('subkeyid passed as: '|| sub_key_id_in);

Line 572: -- Update iby_tangible table

568:
569: --Re-use the previous subkey for a retry case
570: -- sub_key_id_in := l_sub_key_id;
571:
572: -- Update iby_tangible table
573: iby_bill_pkg.modBill(l_tmid,order_id_in,amount_in,currency_in,
574: billeracct_in,refinfo_in,memo_in,
575: order_medium_in, eft_auth_method_in);
576:

Line 700: billeracct_in IN iby_tangible.acctno%type,

696: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
697: error_location_in IN iby_transactions_v.error_location%TYPE,
698: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
699: org_id_in IN iby_trxn_summaries_all.org_id%type,
700: billeracct_in IN iby_tangible.acctno%type,
701: refinfo_in IN iby_tangible.refinfo%type,
702: memo_in IN iby_tangible.memo%type,
703: order_medium_in IN iby_tangible.order_medium%TYPE,
704: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

Line 701: refinfo_in IN iby_tangible.refinfo%type,

697: error_location_in IN iby_transactions_v.error_location%TYPE,
698: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
699: org_id_in IN iby_trxn_summaries_all.org_id%type,
700: billeracct_in IN iby_tangible.acctno%type,
701: refinfo_in IN iby_tangible.refinfo%type,
702: memo_in IN iby_tangible.memo%type,
703: order_medium_in IN iby_tangible.order_medium%TYPE,
704: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
705: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

Line 702: memo_in IN iby_tangible.memo%type,

698: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
699: org_id_in IN iby_trxn_summaries_all.org_id%type,
700: billeracct_in IN iby_tangible.acctno%type,
701: refinfo_in IN iby_tangible.refinfo%type,
702: memo_in IN iby_tangible.memo%type,
703: order_medium_in IN iby_tangible.order_medium%TYPE,
704: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
705: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
706: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

Line 703: order_medium_in IN iby_tangible.order_medium%TYPE,

699: org_id_in IN iby_trxn_summaries_all.org_id%type,
700: billeracct_in IN iby_tangible.acctno%type,
701: refinfo_in IN iby_tangible.refinfo%type,
702: memo_in IN iby_tangible.memo%type,
703: order_medium_in IN iby_tangible.order_medium%TYPE,
704: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
705: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
706: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
707: payerid_in IN iby_trxn_summaries_all.payerid%type,

Line 704: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

700: billeracct_in IN iby_tangible.acctno%type,
701: refinfo_in IN iby_tangible.refinfo%type,
702: memo_in IN iby_tangible.memo%type,
703: order_medium_in IN iby_tangible.order_medium%TYPE,
704: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
705: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
706: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
707: payerid_in IN iby_trxn_summaries_all.payerid%type,
708: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

Line 805: -- 2) Create an entry in iby_tangible table

801:
802: -- For OraPmtCredit we need to
803:
804: -- 1) return transactionid
805: -- 2) Create an entry in iby_tangible table
806: IF UPPER(req_type_in) = 'ORAPMTCREDIT'
807: THEN
808:
809: transaction_id := getTID(merchant_id_in, order_id_in);

Line 929: --Update iby_tangible table

925:
926: transaction_mid_out := l_trxn_mid;
927:
928: IF (UPPER(req_type_in) = 'ORAPMTCREDIT') THEN
929: --Update iby_tangible table
930: iby_bill_pkg.modBill(l_tmid,order_id_in,amount_in,currency_in,
931: billeracct_in,refinfo_in,memo_in,
932: order_medium_in, eft_auth_method_in);
933:

Line 1091: amount_in IN iby_tangible.amount%type,

1087:
1088:
1089: status_in IN iby_transactions_v.status%TYPE,
1090: org_id_in IN iby_trxn_summaries_all.org_id%type,
1091: amount_in IN iby_tangible.amount%type,
1092: currency_in IN iby_tangible.currencynamecode%type,
1093: billeracct_in IN iby_tangible.acctno%type,
1094: refinfo_in IN iby_tangible.refinfo%type,
1095: memo_in IN iby_tangible.memo%type,

Line 1092: currency_in IN iby_tangible.currencynamecode%type,

1088:
1089: status_in IN iby_transactions_v.status%TYPE,
1090: org_id_in IN iby_trxn_summaries_all.org_id%type,
1091: amount_in IN iby_tangible.amount%type,
1092: currency_in IN iby_tangible.currencynamecode%type,
1093: billeracct_in IN iby_tangible.acctno%type,
1094: refinfo_in IN iby_tangible.refinfo%type,
1095: memo_in IN iby_tangible.memo%type,
1096: order_medium_in IN iby_tangible.order_medium%TYPE,

Line 1093: billeracct_in IN iby_tangible.acctno%type,

1089: status_in IN iby_transactions_v.status%TYPE,
1090: org_id_in IN iby_trxn_summaries_all.org_id%type,
1091: amount_in IN iby_tangible.amount%type,
1092: currency_in IN iby_tangible.currencynamecode%type,
1093: billeracct_in IN iby_tangible.acctno%type,
1094: refinfo_in IN iby_tangible.refinfo%type,
1095: memo_in IN iby_tangible.memo%type,
1096: order_medium_in IN iby_tangible.order_medium%TYPE,
1097: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

Line 1094: refinfo_in IN iby_tangible.refinfo%type,

1090: org_id_in IN iby_trxn_summaries_all.org_id%type,
1091: amount_in IN iby_tangible.amount%type,
1092: currency_in IN iby_tangible.currencynamecode%type,
1093: billeracct_in IN iby_tangible.acctno%type,
1094: refinfo_in IN iby_tangible.refinfo%type,
1095: memo_in IN iby_tangible.memo%type,
1096: order_medium_in IN iby_tangible.order_medium%TYPE,
1097: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1098: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

Line 1095: memo_in IN iby_tangible.memo%type,

1091: amount_in IN iby_tangible.amount%type,
1092: currency_in IN iby_tangible.currencynamecode%type,
1093: billeracct_in IN iby_tangible.acctno%type,
1094: refinfo_in IN iby_tangible.refinfo%type,
1095: memo_in IN iby_tangible.memo%type,
1096: order_medium_in IN iby_tangible.order_medium%TYPE,
1097: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1098: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1099: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

Line 1096: order_medium_in IN iby_tangible.order_medium%TYPE,

1092: currency_in IN iby_tangible.currencynamecode%type,
1093: billeracct_in IN iby_tangible.acctno%type,
1094: refinfo_in IN iby_tangible.refinfo%type,
1095: memo_in IN iby_tangible.memo%type,
1096: order_medium_in IN iby_tangible.order_medium%TYPE,
1097: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1098: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1099: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
1100: payerid_in IN iby_trxn_summaries_all.payerid%type,

Line 1097: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

1093: billeracct_in IN iby_tangible.acctno%type,
1094: refinfo_in IN iby_tangible.refinfo%type,
1095: memo_in IN iby_tangible.memo%type,
1096: order_medium_in IN iby_tangible.order_medium%TYPE,
1097: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1098: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1099: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
1100: payerid_in IN iby_trxn_summaries_all.payerid%type,
1101: instrtype_in IN iby_trxn_summaries_all.instrType%type,

Line 1154: -- Create an entry in iby_tangible table

1150: transaction_mid_out := l_trxn_mid;
1151:
1152: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
1153:
1154: -- Create an entry in iby_tangible table
1155: IF ((UPPER(req_type_in) = 'ORAPMTCREDIT') OR
1156:
1157: (UPPER(req_type_in) = 'ORAPMTREQ')) THEN
1158: iby_bill_pkg.createBill(order_id_in,amount_in,currency_in,

Line 1229: -- Update iby_tangible table

1225: transaction_mid_out := l_trxn_mid;
1226:
1227: IF ((UPPER(req_type_in) = 'ORAPMTCREDIT') OR
1228: (UPPER(req_type_in) = 'ORAPMTREQ')) THEN
1229: -- Update iby_tangible table
1230: iby_bill_pkg.modBill(l_tmid,order_id_in,amount_in,currency_in,
1231: billeracct_in,refinfo_in,memo_in,
1232: order_medium_in, eft_auth_method_in);
1233:

Line 5406: l_mtangibleid iby_tangible.mtangibleid%type;

5402: transaction_id NUMBER;
5403:
5404: l_mpayeeid iby_payee.mpayeeid%type;
5405: l_mbatchid iby_batches_all.mbatchid%type;
5406: l_mtangibleid iby_tangible.mtangibleid%type;
5407:
5408: l_prev_trxn_count number;
5409: l_reqtype iby_trxn_summaries_all.reqtype%type;
5410: l_instrtype iby_trxn_summaries_all.instrtype%type;

Line 5508: -- an entry in iby_tangible table

5504:
5505: -- this insertion from close/query batch is problematic
5506: -- 1) there is no corresponding entry in ibY_trxn_core table
5507: -- 2) mtangible id might not be correct, there might not be
5508: -- an entry in iby_tangible table
5509: -- 3) currency, amount is missing
5510: -- regardless, this should be a rare case, it exists because
5511: -- 1) Cybercash doesn't return 'trxntypeid' for capture/return
5512: -- accurately

Line 5730: -- I can not get mtangibleid from the iby_tangible table

5726: FETCH c_order_info INTO l_mtangibleid, l_instrtype, l_instrsubtype,
5727: l_trxnref;
5728: CLOSE c_order_info;
5729: else
5730: -- I can not get mtangibleid from the iby_tangible table
5731: -- because it is missing the payee info
5732: l_mtangibleid := -1;
5733: end if;
5734:

Line 6177: i_tangibleid in iby_tangible.tangibleid%type,

6173: cancelled ones
6174: */
6175:
6176: Function getNumPendingTrxns(i_payeeid in iby_payee.payeeid%type,
6177: i_tangibleid in iby_tangible.tangibleid%type,
6178: i_reqtype in iby_trxn_summaries_all.reqtype%type)
6179: return number
6180:
6181: IS

Line 6206: i_tangibleid in iby_tangible.tangibleid%type)

6202:
6203:
6204: /* get TID based on orderid */
6205: Function getTID(i_payeeid in iby_payee.payeeid%type,
6206: i_tangibleid in iby_tangible.tangibleid%type)
6207: return number
6208:
6209: IS
6210:

Line 6213: ci_tangibleid in iby_tangible.tangibleid%type)

6209: IS
6210:
6211: l_tid number;
6212: cursor c_tid(ci_payeeid in iby_payee.payeeid%type,
6213: ci_tangibleid in iby_tangible.tangibleid%type)
6214: is
6215: SELECT distinct transactionid
6216: FROM iby_trxn_summaries_all
6217: WHERE tangibleid = ci_tangibleid

Line 6242: i_tangibleid in iby_tangible.tangibleid%type)

6238:
6239:
6240: /* get TID based on orderid, payeeid (if unique) */
6241: Function getTIDUniqueCheck(i_payeeid in iby_payee.payeeid%type,
6242: i_tangibleid in iby_tangible.tangibleid%type)
6243: return number
6244:
6245: IS
6246:

Line 6249: ci_tangibleid in iby_tangible.tangibleid%type)

6245: IS
6246:
6247: l_tid number;
6248: cursor c_tid(ci_payeeid in iby_payee.payeeid%type,
6249: ci_tangibleid in iby_tangible.tangibleid%type)
6250: is
6251: SELECT distinct transactionid
6252: FROM iby_trxn_summaries_all
6253: WHERE tangibleid = ci_tangibleid