755: -- Purpose : Unciphers a bank account/IBAN number
756: --
757: FUNCTION Uncipher_Bank_Number
758: (p_unmask_digits IN VARCHAR2,
759: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
760: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
761: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
762: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
763: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
758: (p_unmask_digits IN VARCHAR2,
759: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
760: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
761: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
762: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
763: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
764: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
765: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
766: )
759: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
760: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
761: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
762: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
763: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
764: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
765: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
766: )
767: RETURN VARCHAR2;