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 342: l_mpayeeid iby_payee.mpayeeid%type;

338: l_num_trxns NUMBER := 0;
339: l_trxn_mid NUMBER;
340: l_transaction_id NUMBER;
341: l_tmid iby_trxn_summaries_all.mtangibleid%type;
342: l_mpayeeid iby_payee.mpayeeid%type;
343:
344: l_return_status VARCHAR2(1);
345: l_msg_count NUMBER;
346: l_msg_data VARCHAR2(200);

Line 740: l_mpayeeid iby_payee.mpayeeid%type;

736: l_trxn_mid NUMBER;
737: transaction_id NUMBER;
738: l_tmid iby_trxn_summaries_all.mtangibleid%type;
739: l_order_id iby_trxn_summaries_all.tangibleid%type;
740: l_mpayeeid iby_payee.mpayeeid%type;
741: l_org_id NUMBER;
742: l_target_trxn_type iby_trxn_summaries_all.trxntypeid%TYPE := -1;
743: l_instrtype iby_trxn_summaries_all.instrtype%type;
744: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;

Line 1120: l_mpayeeid iby_payee.mpayeeid%type;

1116: l_trxn_mid NUMBER;
1117: transaction_id NUMBER;
1118: l_tmid iby_trxn_summaries_all.mtangibleid%type;
1119: l_order_id iby_trxn_summaries_all.tangibleid%type;
1120: l_mpayeeid iby_payee.mpayeeid%type;
1121: l_org_id NUMBER;
1122: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
1123:
1124: l_return_status VARCHAR2(1);

Line 1131: l_subkey_id iby_payee_subkeys.payee_subkey_id%TYPE;

1127: l_checksum_valid BOOLEAN := FALSE; -- To check whether the card number is valid.
1128: l_cc_type VARCHAR2(80);
1129:
1130: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
1131: l_subkey_id iby_payee_subkeys.payee_subkey_id%TYPE;
1132:
1133: BEGIN
1134:
1135: -- Count number of previous PENDING transactions

Line 1305: l_mpayeeid iby_payee.mpayeeid%type;

1301: )
1302: IS
1303:
1304: numrows NUMBER;
1305: l_mpayeeid iby_payee.mpayeeid%type;
1306: l_mbatchid iby_batches_all.mbatchid%type;
1307: l_beptype iby_bepinfo.bep_type%TYPE;
1308: l_trxncount iby_batches_all.numtrxns%TYPE;
1309: l_batchcurr iby_batches_all.currencynamecode%TYPE;

Line 1554: l_mpayeeid iby_payee.mpayeeid%type;

1550: IS
1551:
1552: numrows NUMBER;
1553:
1554: l_mpayeeid iby_payee.mpayeeid%type;
1555: l_mbatchid iby_batches_all.mbatchid%type;
1556: l_beptype iby_bepinfo.bep_type%TYPE;
1557: l_trxncount iby_batches_all.numtrxns%TYPE;
1558: l_batchcurr iby_batches_all.currencynamecode%TYPE;

Line 2165: l_mpayeeid iby_payee.mpayeeid%type;

2161: IS
2162:
2163: numrows NUMBER;
2164:
2165: l_mpayeeid iby_payee.mpayeeid%type;
2166: l_mbatchid iby_batches_all.mbatchid%type;
2167: l_beptype iby_bepinfo.bep_type%TYPE;
2168: l_trxncount iby_batches_all.numtrxns%TYPE;
2169: l_batchcurr iby_batches_all.currencynamecode%TYPE;

Line 5404: l_mpayeeid iby_payee.mpayeeid%type;

5400: num_rows NUMBER;
5401: l_trxn_mid NUMBER;
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;

Line 5583: l_mpayeeid iby_payee.mpayeeid%type;

5579: IS
5580:
5581: num_rows NUMBER;
5582: l_trxn_mid NUMBER;
5583: l_mpayeeid iby_payee.mpayeeid%type;
5584: l_mtangibleid iby_trxn_summaries_all.mtangibleid%type;
5585: l_cnt number;
5586: l_instrtype iby_trxn_summaries_all.instrtype%type;
5587: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;

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

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

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

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

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

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

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

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

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

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

Line 6288: p_payee_subkey_cipher IN iby_payee_subkeys.subkey_cipher_text%TYPE,

6284:
6285: FUNCTION unencrypt_instr_num
6286: (p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
6287: p_payee_key IN iby_security_pkg.des3_key_type,
6288: p_payee_subkey_cipher IN iby_payee_subkeys.subkey_cipher_text%TYPE,
6289: p_sys_key IN RAW,
6290: p_sys_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
6291: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
6292: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,

Line 6350: l_subkey_cipher iby_payee_subkeys.subkey_cipher_text%TYPE;

6346: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
6347: instr_num_out OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE
6348: )
6349: IS
6350: l_subkey_cipher iby_payee_subkeys.subkey_cipher_text%TYPE;
6351: l_cipher_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
6352: l_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
6353: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
6354: l_sys_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;