APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_PAYEE_SUBKEYS

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 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;