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_SECURITY_PKG dependencies on IBY_SYS_SECURITY_OPTIONS

Line 32: l_key_hash iby_sys_security_options.sys_key_hash%TYPE;

28:
29: FUNCTION get_key_hash(p_sys_key IN RAW) RETURN RAW
30: IS
31: l_site_salt RAW(128);
32: l_key_hash iby_sys_security_options.sys_key_hash%TYPE;
33: BEGIN
34: l_site_salt := get_site_salt();
35: l_key_hash := DBMS_OBFUSCATION_TOOLKIT.MD5( INPUT => p_sys_key );
36: RETURN

Line 63: RETURN iby_sys_security_options.sys_key_hash%TYPE

59: -- USE
60: -- Gets the hash value of the current system key
61: --
62: FUNCTION Get_SysKey_Hash
63: RETURN iby_sys_security_options.sys_key_hash%TYPE
64: IS
65: l_syskey_hash iby_sys_security_options.sys_key_hash%TYPE;
66:
67: CURSOR c_sys_key

Line 65: l_syskey_hash iby_sys_security_options.sys_key_hash%TYPE;

61: --
62: FUNCTION Get_SysKey_Hash
63: RETURN iby_sys_security_options.sys_key_hash%TYPE
64: IS
65: l_syskey_hash iby_sys_security_options.sys_key_hash%TYPE;
66:
67: CURSOR c_sys_key
68: IS
69: SELECT sys_key_hash

Line 70: FROM iby_sys_security_options;

66:
67: CURSOR c_sys_key
68: IS
69: SELECT sys_key_hash
70: FROM iby_sys_security_options;
71: BEGIN
72: IF (c_sys_key%ISOPEN) THEN CLOSE c_sys_key; END IF;
73:
74: OPEN c_sys_key;

Line 86: l_sys_key_hash iby_sys_security_options.sys_key_hash%TYPE;

82: (p_sys_sec_key IN DES3_KEY_TYPE,
83: x_err_code OUT NOCOPY VARCHAR2
84: )
85: IS
86: l_sys_key_hash iby_sys_security_options.sys_key_hash%TYPE;
87: l_test_hash iby_sys_security_options.sys_key_hash%TYPE;
88: BEGIN
89: IF (p_sys_sec_key IS NULL) THEN
90: x_err_code := 'IBY_10006';

Line 87: l_test_hash iby_sys_security_options.sys_key_hash%TYPE;

83: x_err_code OUT NOCOPY VARCHAR2
84: )
85: IS
86: l_sys_key_hash iby_sys_security_options.sys_key_hash%TYPE;
87: l_test_hash iby_sys_security_options.sys_key_hash%TYPE;
88: BEGIN
89: IF (p_sys_sec_key IS NULL) THEN
90: x_err_code := 'IBY_10006';
91: RETURN;

Line 114: l_sys_secure_hash iby_sys_security_options.sys_key_hash%TYPE;

110: p_sys_sec_key IN DES3_KEY_TYPE,
111: p_wallet_path IN VARCHAR2
112: )
113: IS
114: l_sys_secure_hash iby_sys_security_options.sys_key_hash%TYPE;
115: l_wallet_loc iby_sys_security_options.sys_key_file_location%TYPE;
116:
117: CURSOR c_wallet_loc IS
118: SELECT sys_key_file_location FROM iby_sys_security_options;

Line 115: l_wallet_loc iby_sys_security_options.sys_key_file_location%TYPE;

111: p_wallet_path IN VARCHAR2
112: )
113: IS
114: l_sys_secure_hash iby_sys_security_options.sys_key_hash%TYPE;
115: l_wallet_loc iby_sys_security_options.sys_key_file_location%TYPE;
116:
117: CURSOR c_wallet_loc IS
118: SELECT sys_key_file_location FROM iby_sys_security_options;
119:

Line 118: SELECT sys_key_file_location FROM iby_sys_security_options;

114: l_sys_secure_hash iby_sys_security_options.sys_key_hash%TYPE;
115: l_wallet_loc iby_sys_security_options.sys_key_file_location%TYPE;
116:
117: CURSOR c_wallet_loc IS
118: SELECT sys_key_file_location FROM iby_sys_security_options;
119:
120: BEGIN
121: IF (c_wallet_loc%ISOPEN) THEN CLOSE c_wallet_loc; END IF;
122:

Line 149: UPDATE iby_sys_security_options

145: IF (NOT l_sys_secure_hash IS NULL) AND (l_wallet_loc IS NULL) THEN
146: FND_VAULT.DEL('IBY','IBY_SYS_SECURITY_KEY');
147: END IF;
148:
149: UPDATE iby_sys_security_options
150: SET sys_key_hash = get_key_hash(p_sys_sec_key),
151: salt_version = get_salt_version,
152: sys_key_file_location = p_wallet_path,
153: object_version_number = object_version_number + 1,

Line 198: UPDATE iby_sys_security_options

194: last_updated_by = fnd_global.user_id,
195: last_update_login = fnd_global.login_id;
196:
197: -- update system key hash
198: UPDATE iby_sys_security_options
199: SET sys_key_hash = get_key_hash(p_sys_key_new),
200: salt_version = get_salt_version,
201: sys_key_file_location = p_wallet_path_new,
202: object_version_number = object_version_number + 1,

Line 227: FROM iby_sys_security_subkeys k, iby_sys_security_options o

223:
224: CURSOR c_subkey
225: IS
226: SELECT k.sec_subkey_id, k.subkey_cipher_text
227: FROM iby_sys_security_subkeys k, iby_sys_security_options o
228: WHERE ( ( k.use_count < o.subkey_use_maximum) )
229: AND ( (sysdate - k.creation_date) < NVL(o.subkey_age_maximum,30) )
230: ORDER BY sec_subkey_id ASC;
231: BEGIN