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

229: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
230: error_location_in IN iby_transactions_v.error_location%TYPE,
231: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
232: org_id_in IN iby_trxn_summaries_all.org_id%type,
233: billeracct_in IN iby_tangible.acctno%type,
234: refinfo_in IN iby_tangible.refinfo%type,
235: memo_in IN iby_tangible.memo%type,
236: order_medium_in IN iby_tangible.order_medium%TYPE,
237: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

Line 234: refinfo_in IN iby_tangible.refinfo%type,

230: error_location_in IN iby_transactions_v.error_location%TYPE,
231: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
232: org_id_in IN iby_trxn_summaries_all.org_id%type,
233: billeracct_in IN iby_tangible.acctno%type,
234: refinfo_in IN iby_tangible.refinfo%type,
235: memo_in IN iby_tangible.memo%type,
236: order_medium_in IN iby_tangible.order_medium%TYPE,
237: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
238: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

Line 235: memo_in IN iby_tangible.memo%type,

231: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
232: org_id_in IN iby_trxn_summaries_all.org_id%type,
233: billeracct_in IN iby_tangible.acctno%type,
234: refinfo_in IN iby_tangible.refinfo%type,
235: memo_in IN iby_tangible.memo%type,
236: order_medium_in IN iby_tangible.order_medium%TYPE,
237: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
238: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
239: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

Line 236: order_medium_in IN iby_tangible.order_medium%TYPE,

232: org_id_in IN iby_trxn_summaries_all.org_id%type,
233: billeracct_in IN iby_tangible.acctno%type,
234: refinfo_in IN iby_tangible.refinfo%type,
235: memo_in IN iby_tangible.memo%type,
236: order_medium_in IN iby_tangible.order_medium%TYPE,
237: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
238: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
239: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
240: payerid_in IN iby_trxn_summaries_all.payerid%type,

Line 237: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

233: billeracct_in IN iby_tangible.acctno%type,
234: refinfo_in IN iby_tangible.refinfo%type,
235: memo_in IN iby_tangible.memo%type,
236: order_medium_in IN iby_tangible.order_medium%TYPE,
237: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
238: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
239: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
240: payerid_in IN iby_trxn_summaries_all.payerid%type,
241: instrtype_in IN iby_trxn_summaries_all.instrType%type,

Line 415: --Create an entry in iby_tangible table

411: transaction_mid_out := l_trxn_mid;
412:
413: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
414:
415: --Create an entry in iby_tangible table
416: iby_bill_pkg.createBill(order_id_in,amount_in,currency_in,
417: billeracct_in,refinfo_in, memo_in,
418: order_medium_in, eft_auth_method_in, l_tmid);
419: --test_debug('subkeyid passed as: '|| sub_key_id_in);

Line 522: -- Update iby_tangible table

518:
519: --Re-use the previous subkey for a retry case
520: -- sub_key_id_in := l_sub_key_id;
521:
522: -- Update iby_tangible table
523: iby_bill_pkg.modBill(l_tmid,order_id_in,amount_in,currency_in,
524: billeracct_in,refinfo_in,memo_in,
525: order_medium_in, eft_auth_method_in);
526:

Line 841: billeracct_in IN iby_tangible.acctno%type,

837: vendor_message_in IN iby_transactions_v.vendor_message%TYPE,
838: error_location_in IN iby_transactions_v.error_location%TYPE,
839: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
840: org_id_in IN iby_trxn_summaries_all.org_id%type,
841: billeracct_in IN iby_tangible.acctno%type,
842: refinfo_in IN iby_tangible.refinfo%type,
843: memo_in IN iby_tangible.memo%type,
844: order_medium_in IN iby_tangible.order_medium%TYPE,
845: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

Line 842: refinfo_in IN iby_tangible.refinfo%type,

838: error_location_in IN iby_transactions_v.error_location%TYPE,
839: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
840: org_id_in IN iby_trxn_summaries_all.org_id%type,
841: billeracct_in IN iby_tangible.acctno%type,
842: refinfo_in IN iby_tangible.refinfo%type,
843: memo_in IN iby_tangible.memo%type,
844: order_medium_in IN iby_tangible.order_medium%TYPE,
845: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
846: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

Line 843: memo_in IN iby_tangible.memo%type,

839: trace_number_in IN iby_transactions_v.TraceNumber%TYPE,
840: org_id_in IN iby_trxn_summaries_all.org_id%type,
841: billeracct_in IN iby_tangible.acctno%type,
842: refinfo_in IN iby_tangible.refinfo%type,
843: memo_in IN iby_tangible.memo%type,
844: order_medium_in IN iby_tangible.order_medium%TYPE,
845: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
846: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
847: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

Line 844: order_medium_in IN iby_tangible.order_medium%TYPE,

840: org_id_in IN iby_trxn_summaries_all.org_id%type,
841: billeracct_in IN iby_tangible.acctno%type,
842: refinfo_in IN iby_tangible.refinfo%type,
843: memo_in IN iby_tangible.memo%type,
844: order_medium_in IN iby_tangible.order_medium%TYPE,
845: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
846: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
847: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
848: payerid_in IN iby_trxn_summaries_all.payerid%type,

Line 845: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

841: billeracct_in IN iby_tangible.acctno%type,
842: refinfo_in IN iby_tangible.refinfo%type,
843: memo_in IN iby_tangible.memo%type,
844: order_medium_in IN iby_tangible.order_medium%TYPE,
845: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
846: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
847: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
848: payerid_in IN iby_trxn_summaries_all.payerid%type,
849: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

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

958:
959: -- For OraPmtCredit we need to
960:
961: -- 1) return transactionid
962: -- 2) Create an entry in iby_tangible table
963: IF UPPER(req_type_in) = 'ORAPMTCREDIT'
964: THEN
965:
966: transaction_id := getTID(merchant_id_in, order_id_in);

Line 1129: --Update iby_tangible table

1125:
1126: transaction_mid_out := l_trxn_mid;
1127:
1128: IF (UPPER(req_type_in) = 'ORAPMTCREDIT') THEN
1129: --Update iby_tangible table
1130: iby_bill_pkg.modBill(l_tmid,order_id_in,amount_in,currency_in,
1131: billeracct_in,refinfo_in,memo_in,
1132: order_medium_in, eft_auth_method_in);
1133:

Line 1293: amount_in IN iby_tangible.amount%type,

1289:
1290:
1291: status_in IN iby_transactions_v.status%TYPE,
1292: org_id_in IN iby_trxn_summaries_all.org_id%type,
1293: amount_in IN iby_tangible.amount%type,
1294: currency_in IN iby_tangible.currencynamecode%type,
1295: billeracct_in IN iby_tangible.acctno%type,
1296: refinfo_in IN iby_tangible.refinfo%type,
1297: memo_in IN iby_tangible.memo%type,

Line 1294: currency_in IN iby_tangible.currencynamecode%type,

1290:
1291: status_in IN iby_transactions_v.status%TYPE,
1292: org_id_in IN iby_trxn_summaries_all.org_id%type,
1293: amount_in IN iby_tangible.amount%type,
1294: currency_in IN iby_tangible.currencynamecode%type,
1295: billeracct_in IN iby_tangible.acctno%type,
1296: refinfo_in IN iby_tangible.refinfo%type,
1297: memo_in IN iby_tangible.memo%type,
1298: order_medium_in IN iby_tangible.order_medium%TYPE,

Line 1295: billeracct_in IN iby_tangible.acctno%type,

1291: status_in IN iby_transactions_v.status%TYPE,
1292: org_id_in IN iby_trxn_summaries_all.org_id%type,
1293: amount_in IN iby_tangible.amount%type,
1294: currency_in IN iby_tangible.currencynamecode%type,
1295: billeracct_in IN iby_tangible.acctno%type,
1296: refinfo_in IN iby_tangible.refinfo%type,
1297: memo_in IN iby_tangible.memo%type,
1298: order_medium_in IN iby_tangible.order_medium%TYPE,
1299: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

Line 1296: refinfo_in IN iby_tangible.refinfo%type,

1292: org_id_in IN iby_trxn_summaries_all.org_id%type,
1293: amount_in IN iby_tangible.amount%type,
1294: currency_in IN iby_tangible.currencynamecode%type,
1295: billeracct_in IN iby_tangible.acctno%type,
1296: refinfo_in IN iby_tangible.refinfo%type,
1297: memo_in IN iby_tangible.memo%type,
1298: order_medium_in IN iby_tangible.order_medium%TYPE,
1299: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1300: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,

Line 1297: memo_in IN iby_tangible.memo%type,

1293: amount_in IN iby_tangible.amount%type,
1294: currency_in IN iby_tangible.currencynamecode%type,
1295: billeracct_in IN iby_tangible.acctno%type,
1296: refinfo_in IN iby_tangible.refinfo%type,
1297: memo_in IN iby_tangible.memo%type,
1298: order_medium_in IN iby_tangible.order_medium%TYPE,
1299: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1300: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1301: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,

Line 1298: order_medium_in IN iby_tangible.order_medium%TYPE,

1294: currency_in IN iby_tangible.currencynamecode%type,
1295: billeracct_in IN iby_tangible.acctno%type,
1296: refinfo_in IN iby_tangible.refinfo%type,
1297: memo_in IN iby_tangible.memo%type,
1298: order_medium_in IN iby_tangible.order_medium%TYPE,
1299: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1300: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1301: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
1302: payerid_in IN iby_trxn_summaries_all.payerid%type,

Line 1299: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,

1295: billeracct_in IN iby_tangible.acctno%type,
1296: refinfo_in IN iby_tangible.refinfo%type,
1297: memo_in IN iby_tangible.memo%type,
1298: order_medium_in IN iby_tangible.order_medium%TYPE,
1299: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
1300: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1301: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
1302: payerid_in IN iby_trxn_summaries_all.payerid%type,
1303: instrtype_in IN iby_trxn_summaries_all.instrType%type,

Line 1360: -- Create an entry in iby_tangible table

1356: transaction_mid_out := l_trxn_mid;
1357:
1358: iby_accppmtmthd_pkg.getMPayeeId(merchant_id_in, l_mpayeeid);
1359:
1360: -- Create an entry in iby_tangible table
1361: IF ((UPPER(req_type_in) = 'ORAPMTCREDIT') OR
1362:
1363: (UPPER(req_type_in) = 'ORAPMTREQ')) THEN
1364: iby_bill_pkg.createBill(order_id_in,amount_in,currency_in,

Line 1436: -- Update iby_tangible table

1432: transaction_mid_out := l_trxn_mid;
1433:
1434: IF ((UPPER(req_type_in) = 'ORAPMTCREDIT') OR
1435: (UPPER(req_type_in) = 'ORAPMTREQ')) THEN
1436: -- Update iby_tangible table
1437: iby_bill_pkg.modBill(l_tmid,order_id_in,amount_in,currency_in,
1438: billeracct_in,refinfo_in,memo_in,
1439: order_medium_in, eft_auth_method_in);
1440:

Line 5908: l_mtangibleid iby_tangible.mtangibleid%type;

5904: transaction_id NUMBER;
5905:
5906: l_mpayeeid iby_payee.mpayeeid%type;
5907: l_mbatchid iby_batches_all.mbatchid%type;
5908: l_mtangibleid iby_tangible.mtangibleid%type;
5909:
5910: l_prev_trxn_count number;
5911: l_reqtype iby_trxn_summaries_all.reqtype%type;
5912: l_instrtype iby_trxn_summaries_all.instrtype%type;

Line 6010: -- an entry in iby_tangible table

6006:
6007: -- this insertion from close/query batch is problematic
6008: -- 1) there is no corresponding entry in ibY_trxn_core table
6009: -- 2) mtangible id might not be correct, there might not be
6010: -- an entry in iby_tangible table
6011: -- 3) currency, amount is missing
6012: -- regardless, this should be a rare case, it exists because
6013: -- 1) Cybercash doesn't return 'trxntypeid' for capture/return
6014: -- accurately

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

6228: FETCH c_order_info INTO l_mtangibleid, l_instrtype, l_instrsubtype,
6229: l_trxnref;
6230: CLOSE c_order_info;
6231: else
6232: -- I can not get mtangibleid from the iby_tangible table
6233: -- because it is missing the payee info
6234: l_mtangibleid := -1;
6235: end if;
6236:

Line 6734: i_tangibleid in iby_tangible.tangibleid%type,

6730: cancelled ones
6731: */
6732:
6733: Function getNumPendingTrxns(i_payeeid in iby_payee.payeeid%type,
6734: i_tangibleid in iby_tangible.tangibleid%type,
6735: i_reqtype in iby_trxn_summaries_all.reqtype%type)
6736: return number
6737:
6738: IS

Line 6763: i_tangibleid in iby_tangible.tangibleid%type)

6759:
6760:
6761: /* get TID based on orderid */
6762: Function getTID(i_payeeid in iby_payee.payeeid%type,
6763: i_tangibleid in iby_tangible.tangibleid%type)
6764: return number
6765:
6766: IS
6767:

Line 6770: ci_tangibleid in iby_tangible.tangibleid%type)

6766: IS
6767:
6768: l_tid number;
6769: cursor c_tid(ci_payeeid in iby_payee.payeeid%type,
6770: ci_tangibleid in iby_tangible.tangibleid%type)
6771: is
6772: SELECT distinct transactionid
6773: FROM iby_trxn_summaries_all
6774: WHERE tangibleid = ci_tangibleid

Line 6799: i_tangibleid in iby_tangible.tangibleid%type)

6795:
6796:
6797: /* get TID based on orderid, payeeid (if unique) */
6798: Function getTIDUniqueCheck(i_payeeid in iby_payee.payeeid%type,
6799: i_tangibleid in iby_tangible.tangibleid%type)
6800: return number
6801:
6802: IS
6803:

Line 6806: ci_tangibleid in iby_tangible.tangibleid%type)

6802: IS
6803:
6804: l_tid number;
6805: cursor c_tid(ci_payeeid in iby_payee.payeeid%type,
6806: ci_tangibleid in iby_tangible.tangibleid%type)
6807: is
6808: SELECT distinct transactionid
6809: FROM iby_trxn_summaries_all
6810: WHERE tangibleid = ci_tangibleid