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 5001: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,

4997: FUNCTION Uncipher_Bank_Number
4998: (p_unmask_digits IN VARCHAR2,
4999: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
5000: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
5001: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
5002: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
5003: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
5004: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
5005: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE

Line 5009: l_sub_key iby_sys_security_subkeys.subkey_cipher_text%TYPE;

5005: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
5006: )
5007: RETURN VARCHAR2
5008: IS
5009: l_sub_key iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5010: l_bank_segment iby_security_segments.segment_cipher_text%TYPE;
5011: l_bank_num VARCHAR2(200);
5012: BEGIN
5013:

Line 5082: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,

5078: b.iban_sec_segment_id, ibk.subkey_cipher_text iban_subkey_cipher,
5079: ibs.segment_cipher_text iban_segment_cipher,
5080: ibs.encoding_scheme iban_encoding,
5081: b.ba_mask_setting, b.ba_unmask_length
5082: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
5083: iby_sys_security_subkeys ibk, iby_security_segments bas,
5084: iby_security_segments ibs
5085: WHERE
5086: ( (NVL(ba_unmask_length,-1) <> ci_unmask_len) OR

Line 5083: iby_sys_security_subkeys ibk, iby_security_segments bas,

5079: ibs.segment_cipher_text iban_segment_cipher,
5080: ibs.encoding_scheme iban_encoding,
5081: b.ba_mask_setting, b.ba_unmask_length
5082: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
5083: iby_sys_security_subkeys ibk, iby_security_segments bas,
5084: iby_security_segments ibs
5085: WHERE
5086: ( (NVL(ba_unmask_length,-1) <> ci_unmask_len) OR
5087: (NVL(ba_mask_setting,' ') <> ci_mask_option) )

Line 5391: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;

5387: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
5388: )
5389: IS
5390: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
5391: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5392: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
5393: l_iban iby_ext_bank_accounts.iban%TYPE;
5394: l_e_ba iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
5395:

Line 5413: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,

5409: ebk.subkey_cipher_text e_ba_subkey_cipher,
5410: ebs.segment_cipher_text e_ba_segment_cipher,
5411: ebs.encoding_scheme e_ba_encoding,
5412: b.ba_mask_setting, b.ba_unmask_length
5413: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
5414: iby_sys_security_subkeys ebk, iby_sys_security_subkeys ibk,
5415: iby_security_segments bas, iby_security_segments ibs,
5416: iby_security_segments ebs
5417: WHERE

Line 5414: iby_sys_security_subkeys ebk, iby_sys_security_subkeys ibk,

5410: ebs.segment_cipher_text e_ba_segment_cipher,
5411: ebs.encoding_scheme e_ba_encoding,
5412: b.ba_mask_setting, b.ba_unmask_length
5413: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
5414: iby_sys_security_subkeys ebk, iby_sys_security_subkeys ibk,
5415: iby_security_segments bas, iby_security_segments ibs,
5416: iby_security_segments ebs
5417: WHERE
5418: ((NOT ba_num_sec_segment_id IS NULL) OR (NOT iban_sec_segment_id IS NULL))

Line 5628: l_sub_key iby_sys_security_subkeys.subkey_cipher_text%TYPE;

5624: IS
5625: l_api_name CONSTANT VARCHAR2(30) := 'Uncipher_Bank_Acct_Number';
5626: l_api_version CONSTANT NUMBER := 1.0;
5627: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.' || l_api_name;
5628: l_sub_key iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5629: l_bank_segment iby_security_segments.segment_cipher_text%TYPE;
5630: l_bank_acct_num iby_ext_bank_accounts.bank_account_num%TYPE;
5631: l_segment_id iby_ext_bank_accounts.BA_NUM_SEC_SEGMENT_ID%type;
5632: l_sub_key_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;

Line 5632: l_sub_key_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;

5628: l_sub_key iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5629: l_bank_segment iby_security_segments.segment_cipher_text%TYPE;
5630: l_bank_acct_num iby_ext_bank_accounts.bank_account_num%TYPE;
5631: l_segment_id iby_ext_bank_accounts.BA_NUM_SEC_SEGMENT_ID%type;
5632: l_sub_key_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5633: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
5634: l_encoding iby_security_segments.encoding_scheme%TYPE;
5635: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
5636: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;

Line 5649: iby_sys_security_subkeys subkeys,

5645: segments.encoding_scheme,
5646: ba.ba_mask_setting,
5647: ba.ba_unmask_length
5648: FROM iby_ext_bank_accounts ba,
5649: iby_sys_security_subkeys subkeys,
5650: iby_security_segments segments
5651: WHERE ba.ext_bank_account_id = p_ext_bank_account_id
5652: AND ba.ba_num_sec_segment_id = segments.sec_segment_id (+)
5653: AND segments.sec_subkey_id = subkeys.sec_subkey_id(+);