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_PAYEE

Line 287: l_mpayeeid iby_payee.mpayeeid%type;

283: l_num_trxns NUMBER := 0;
284: l_trxn_mid NUMBER;
285: l_transaction_id NUMBER;
286: l_tmid iby_trxn_summaries_all.mtangibleid%type;
287: l_mpayeeid iby_payee.mpayeeid%type;
288:
289: l_return_status VARCHAR2(1);
290: l_msg_count NUMBER;
291: l_msg_data VARCHAR2(200);

Line 883: l_mpayeeid iby_payee.mpayeeid%type;

879: l_trxn_mid NUMBER;
880: transaction_id NUMBER;
881: l_tmid iby_trxn_summaries_all.mtangibleid%type;
882: l_order_id iby_trxn_summaries_all.tangibleid%type;
883: l_mpayeeid iby_payee.mpayeeid%type;
884: l_org_id NUMBER;
885: l_target_trxn_type iby_trxn_summaries_all.trxntypeid%TYPE := -1;
886: l_instrtype iby_trxn_summaries_all.instrtype%type;
887: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;

Line 1323: l_mpayeeid iby_payee.mpayeeid%type;

1319: l_trxn_mid NUMBER;
1320: transaction_id NUMBER;
1321: l_tmid iby_trxn_summaries_all.mtangibleid%type;
1322: l_order_id iby_trxn_summaries_all.tangibleid%type;
1323: l_mpayeeid iby_payee.mpayeeid%type;
1324: l_org_id NUMBER;
1325: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
1326:
1327: l_return_status VARCHAR2(1);

Line 1334: l_subkey_id iby_payee_subkeys.payee_subkey_id%TYPE;

1330: l_checksum_valid BOOLEAN := FALSE; -- To check whether the card number is valid.
1331: l_cc_type VARCHAR2(80);
1332:
1333: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
1334: l_subkey_id iby_payee_subkeys.payee_subkey_id%TYPE;
1335:
1336: BEGIN
1337:
1338: -- Count number of previous PENDING transactions

Line 1512: l_mpayeeid iby_payee.mpayeeid%type;

1508: )
1509: IS
1510:
1511: numrows NUMBER;
1512: l_mpayeeid iby_payee.mpayeeid%type;
1513: l_mbatchid iby_batches_all.mbatchid%type;
1514: l_beptype iby_bepinfo.bep_type%TYPE;
1515: l_trxncount iby_batches_all.numtrxns%TYPE;
1516: l_batchcurr iby_batches_all.currencynamecode%TYPE;

Line 1762: l_mpayeeid iby_payee.mpayeeid%type;

1758: IS
1759:
1760: numrows NUMBER;
1761:
1762: l_mpayeeid iby_payee.mpayeeid%type;
1763: l_mbatchid iby_batches_all.mbatchid%type;
1764: l_beptype iby_bepinfo.bep_type%TYPE;
1765: l_trxncount iby_batches_all.numtrxns%TYPE;
1766: l_batchcurr iby_batches_all.currencynamecode%TYPE;

Line 2395: l_mpayeeid iby_payee.mpayeeid%type;

2391: IS
2392:
2393: numrows NUMBER;
2394:
2395: l_mpayeeid iby_payee.mpayeeid%type;
2396: l_mbatchid iby_batches_all.mbatchid%type;
2397: l_beptype iby_bepinfo.bep_type%TYPE;
2398: l_trxncount iby_batches_all.numtrxns%TYPE;
2399: l_batchcurr iby_batches_all.currencynamecode%TYPE;

Line 5906: l_mpayeeid iby_payee.mpayeeid%type;

5902: num_rows NUMBER;
5903: l_trxn_mid NUMBER;
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;

Line 6085: l_mpayeeid iby_payee.mpayeeid%type;

6081: IS
6082:
6083: num_rows NUMBER;
6084: l_trxn_mid NUMBER;
6085: l_mpayeeid iby_payee.mpayeeid%type;
6086: l_mtangibleid iby_trxn_summaries_all.mtangibleid%type;
6087: l_cnt number;
6088: l_instrtype iby_trxn_summaries_all.instrtype%type;
6089: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;

Line 6733: Function getNumPendingTrxns(i_payeeid in iby_payee.payeeid%type,

6729: /* Count number of previous PENDING transactions, ignoring the
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:

Line 6762: Function getTID(i_payeeid in iby_payee.payeeid%type,

6758: END;
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

Line 6769: cursor c_tid(ci_payeeid in iby_payee.payeeid%type,

6765:
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

Line 6798: Function getTIDUniqueCheck(i_payeeid in iby_payee.payeeid%type,

6794: END getTID;
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

Line 6805: cursor c_tid(ci_payeeid in iby_payee.payeeid%type,

6801:
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

Line 6845: p_payee_subkey_cipher IN iby_payee_subkeys.subkey_cipher_text%TYPE,

6841:
6842: FUNCTION unencrypt_instr_num
6843: (p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
6844: p_payee_key IN iby_security_pkg.des3_key_type,
6845: p_payee_subkey_cipher IN iby_payee_subkeys.subkey_cipher_text%TYPE,
6846: p_sys_key IN RAW,
6847: p_sys_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
6848: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
6849: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,