APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_SYS_SECURITY_SUBKEYS

Line 6716: iby_sys_security_subkeys k

6712: SELECT x.trxn_extension_id, x.instr_sec_code_length,
6713: NVL(x.encrypted,'N'), s.segment_cipher_text, k.subkey_cipher_text,
6714: s.sec_segment_id
6715: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,
6716: iby_sys_security_subkeys k
6717: WHERE (NVL(x.encrypted,'N') = 'Y')
6718: AND (NOT instrument_security_code IS NULL)
6719: AND (x.instr_code_sec_segment_id = s.sec_segment_id(+))
6720: AND (s.sec_subkey_id = k.sec_subkey_id(+));

Line 6768: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,

6764: END Decrypt_Extensions;
6765:
6766: FUNCTION Get_Security_Code
6767: (p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
6768: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
6769: p_sec_code_cipher IN iby_security_segments.segment_cipher_text%TYPE,
6770: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE
6771: )
6772: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE

Line 6813: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;

6809: IS
6810: l_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
6811: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
6812: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
6813: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
6814: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
6815: lx_err_code VARCHAR2(100);
6816: l_module CONSTANT VARCHAR2(30) := 'Get_Security_Code(2)';
6817: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;

Line 6825: iby_sys_security_subkeys k

6821: IS
6822: SELECT x.instrument_security_code, x.instr_sec_code_length,
6823: NVL(x.encrypted,'N'), s.segment_cipher_text, k.subkey_cipher_text
6824: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,
6825: iby_sys_security_subkeys k
6826: WHERE (trxn_extension_id = ci_extension_id)
6827: AND (x.instr_code_sec_segment_id = s.sec_segment_id(+))
6828: AND (s.sec_subkey_id = k.sec_subkey_id(+));
6829:

Line 6869: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;

6865: )
6866: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE
6867: IS
6868: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
6869: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
6870: lx_err_code VARCHAR2(100);
6871: l_module CONSTANT VARCHAR2(30) := 'Get_Security_Code(3)';
6872: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
6873:

Line 6878: FROM iby_security_segments s, iby_sys_security_subkeys k

6874: CURSOR c_segment
6875: (ci_segment_id IN iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE)
6876: IS
6877: SELECT s.segment_cipher_text, k.subkey_cipher_text
6878: FROM iby_security_segments s, iby_sys_security_subkeys k
6879: WHERE (s.sec_segment_id = ci_segment_id)
6880: AND (s.sec_subkey_id = k.sec_subkey_id);
6881:
6882: BEGIN