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_EXT_BANKACCT_PUB dependencies on IBY_SYS_SECURITY_SUBKEYS

Line 4169: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,

4165: FUNCTION Uncipher_Bank_Number
4166: (p_unmask_digits IN VARCHAR2,
4167: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
4168: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
4169: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
4170: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
4171: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
4172: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
4173: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE

Line 4177: l_sub_key iby_sys_security_subkeys.subkey_cipher_text%TYPE;

4173: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
4174: )
4175: RETURN VARCHAR2
4176: IS
4177: l_sub_key iby_sys_security_subkeys.subkey_cipher_text%TYPE;
4178: l_bank_segment iby_security_segments.segment_cipher_text%TYPE;
4179: l_bank_num VARCHAR2(200);
4180: BEGIN
4181:

Line 4244: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,

4240: b.iban_sec_segment_id, ibk.subkey_cipher_text iban_subkey_cipher,
4241: ibs.segment_cipher_text iban_segment_cipher,
4242: ibs.encoding_scheme iban_encoding,
4243: b.ba_mask_setting, b.ba_unmask_length
4244: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
4245: iby_sys_security_subkeys ibk, iby_security_segments bas,
4246: iby_security_segments ibs
4247: WHERE
4248: ( (NVL(ba_unmask_length,-1) <> ci_unmask_len) OR

Line 4245: iby_sys_security_subkeys ibk, iby_security_segments bas,

4241: ibs.segment_cipher_text iban_segment_cipher,
4242: ibs.encoding_scheme iban_encoding,
4243: b.ba_mask_setting, b.ba_unmask_length
4244: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
4245: iby_sys_security_subkeys ibk, iby_security_segments bas,
4246: iby_security_segments ibs
4247: WHERE
4248: ( (NVL(ba_unmask_length,-1) <> ci_unmask_len) OR
4249: (NVL(ba_mask_setting,' ') <> ci_mask_option) )

Line 4553: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;

4549: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
4550: )
4551: IS
4552: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
4553: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
4554: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
4555: l_iban iby_ext_bank_accounts.iban%TYPE;
4556: l_e_ba iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
4557:

Line 4575: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,

4571: ebk.subkey_cipher_text e_ba_subkey_cipher,
4572: ebs.segment_cipher_text e_ba_segment_cipher,
4573: ebs.encoding_scheme e_ba_encoding,
4574: b.ba_mask_setting, b.ba_unmask_length
4575: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
4576: iby_sys_security_subkeys ebk, iby_sys_security_subkeys ibk,
4577: iby_security_segments bas, iby_security_segments ibs,
4578: iby_security_segments ebs
4579: WHERE

Line 4576: iby_sys_security_subkeys ebk, iby_sys_security_subkeys ibk,

4572: ebs.segment_cipher_text e_ba_segment_cipher,
4573: ebs.encoding_scheme e_ba_encoding,
4574: b.ba_mask_setting, b.ba_unmask_length
4575: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
4576: iby_sys_security_subkeys ebk, iby_sys_security_subkeys ibk,
4577: iby_security_segments bas, iby_security_segments ibs,
4578: iby_security_segments ebs
4579: WHERE
4580: ((NOT ba_num_sec_segment_id IS NULL) OR (NOT iban_sec_segment_id IS NULL))