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_SUBKEYS

Line 189: UPDATE iby_sys_security_subkeys

185: raise_application_error(-20000,l_err_code, FALSE);
186: END IF;
187:
188: -- recipher all subkeys
189: UPDATE iby_sys_security_subkeys
190: SET subkey_cipher_text =
191: Recipher_Key(subkey_cipher_text,p_sys_key_old,p_sys_key_new),
192: object_version_number = object_version_number + 1,
193: last_update_date = sysdate,

Line 217: x_subkey_id OUT NOCOPY iby_sys_security_subkeys.sec_subkey_id%TYPE,

213: PROCEDURE Get_Sys_Subkey
214: (p_commit IN VARCHAR2,
215: p_masterkey IN DES3_KEY_TYPE,
216: p_inc_use_flag IN VARCHAR2,
217: x_subkey_id OUT NOCOPY iby_sys_security_subkeys.sec_subkey_id%TYPE,
218: x_subkey OUT NOCOPY DES3_KEY_TYPE
219: )
220: IS
221: l_err_code VARCHAR2(100);

Line 222: l_subkey_ciphertxt iby_sys_security_subkeys.subkey_cipher_text%TYPE;

218: x_subkey OUT NOCOPY DES3_KEY_TYPE
219: )
220: IS
221: l_err_code VARCHAR2(100);
222: l_subkey_ciphertxt iby_sys_security_subkeys.subkey_cipher_text%TYPE;
223:
224: CURSOR c_subkey
225: IS
226: SELECT k.sec_subkey_id, k.subkey_cipher_text

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

Line 259: SELECT iby_sys_security_subkeys_s.NEXTVAL INTO x_subkey_id FROM dual;

255: ( input => x_subkey, key => p_masterkey,
256: which => dbms_obfuscation_toolkit.ThreeKeyMode
257: );
258:
259: SELECT iby_sys_security_subkeys_s.NEXTVAL INTO x_subkey_id FROM dual;
260: INSERT INTO iby_sys_security_subkeys
261: (sec_subkey_id, subkey_cipher_text, use_count,
262: created_by, creation_date, last_updated_by, last_update_date,
263: last_update_login, object_version_number)

Line 260: INSERT INTO iby_sys_security_subkeys

256: which => dbms_obfuscation_toolkit.ThreeKeyMode
257: );
258:
259: SELECT iby_sys_security_subkeys_s.NEXTVAL INTO x_subkey_id FROM dual;
260: INSERT INTO iby_sys_security_subkeys
261: (sec_subkey_id, subkey_cipher_text, use_count,
262: created_by, creation_date, last_updated_by, last_update_date,
263: last_update_login, object_version_number)
264: VALUES

Line 279: UPDATE iby_sys_security_subkeys

275: --
276: -- if subkey will be used, increment its use count
277: --
278: IF (p_inc_use_flag = 'Y') THEN
279: UPDATE iby_sys_security_subkeys
280: SET use_count = use_count + 1,
281: object_version_number = object_version_number + 1,
282: last_update_date = sysdate,
283: last_updated_by = fnd_global.user_id,

Line 296: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE

292: END Get_Sys_Subkey;
293:
294: FUNCTION Get_Sys_Subkey
295: (p_sys_key IN DES3_KEY_TYPE,
296: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE
297: )
298: RETURN DES3_KEY_TYPE
299: IS
300: BEGIN

Line 312: x_subkey_id OUT NOCOPY iby_sys_security_subkeys.sec_subkey_id%TYPE,

308: PROCEDURE Get_Sys_Subkey_Hex
309: (p_commit IN VARCHAR2 := FND_API.G_FALSE,
310: p_sys_key IN DES3_KEY_TYPE,
311: p_inc_use_flag IN VARCHAR2,
312: x_subkey_id OUT NOCOPY iby_sys_security_subkeys.sec_subkey_id%TYPE,
313: x_subkey_Hex OUT NOCOPY VARCHAR2
314: ) IS
315: l_subkey_raw RAW(24);
316: BEGIN

Line 322: (p_subkey_id IN iby_sys_security_subkeys.sec_subkey_id%TYPE,

318: x_subkey_Hex := RAWTOHEX(l_subkey_raw);
319: END Get_Sys_Subkey_Hex;
320:
321: FUNCTION Get_Sys_Subkey_Hex
322: (p_subkey_id IN iby_sys_security_subkeys.sec_subkey_id%TYPE,
323: p_sys_key IN DES3_KEY_TYPE
324: )
325: RETURN VARCHAR2
326: IS

Line 333: SELECT subkey_cipher_text INTO l_subkey_cipher FROM iby_sys_security_subkeys

329: l_subkey_Hex VARCHAR2(100);
330:
331: BEGIN
332:
333: SELECT subkey_cipher_text INTO l_subkey_cipher FROM iby_sys_security_subkeys
334: WHERE sec_subkey_id = p_subkey_id;
335:
336: l_subkey_clear := Get_Sys_Subkey(p_sys_key, l_subkey_cipher);
337: l_subkey_Hex := RAWTOHEX(l_subkey_clear);

Line 636: lx_subkey_id iby_sys_security_subkeys.sec_subkey_id%TYPE;

632: x_segment_id OUT NOCOPY iby_security_segments.sec_segment_id%TYPE
633: )
634: IS
635: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
636: lx_subkey_id iby_sys_security_subkeys.sec_subkey_id%TYPE;
637: lx_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
638: BEGIN
639:
640: IBY_SECURITY_PKG.Get_Sys_Subkey

Line 637: lx_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;

633: )
634: IS
635: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
636: lx_subkey_id iby_sys_security_subkeys.sec_subkey_id%TYPE;
637: lx_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
638: BEGIN
639:
640: IBY_SECURITY_PKG.Get_Sys_Subkey
641: (FND_API.G_FALSE,p_sys_key,'Y',lx_subkey_id,lx_subkey);

Line 931: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;

927: lx_unmask_digits VARCHAR2(2000);
928: l_sys_key RAW(24);
929: x_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
930: l_fv_segment iby_security_segments.segment_cipher_text%TYPE;
931: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
932:
933: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.encrypt_field_vals';
934:
935: BEGIN

Line 970: FROM iby_sys_security_subkeys sk

966: ELSE
967: BEGIN
968: SELECT sk.subkey_cipher_text
969: INTO l_subkey_cipher
970: FROM iby_sys_security_subkeys sk
971: , iby_security_segments ss
972: WHERE sk.sec_subkey_id = ss.sec_subkey_id
973: AND ss.sec_segment_id = p_sec_segment_id;
974: END;

Line 1063: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,

1059:
1060: FUNCTION Uncipher_Field_Value
1061: (p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
1062: p_sys_key IN DES3_KEY_TYPE,
1063: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
1064: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
1065: p_encoding IN iby_security_segments.encoding_scheme%TYPE
1066: )
1067: RETURN VARCHAR2

Line 1108: l_subkey_ciphertxt iby_sys_security_subkeys.subkey_cipher_text%TYPE;

1104: IS
1105:
1106: lx_key_error VARCHAR2(300);
1107: l_sys_key RAW(24);
1108: l_subkey_ciphertxt iby_sys_security_subkeys.subkey_cipher_text%TYPE;
1109: l_fv_segment iby_security_segments.segment_cipher_text%TYPE;
1110: l_encoding iby_security_segments.encoding_scheme%TYPE;
1111:
1112: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.decrypt_field_vals';

Line 1132: FROM iby_sys_security_subkeys bak

1128: , bas.encoding_scheme
1129: INTO l_subkey_ciphertxt
1130: , l_fv_segment
1131: , l_encoding
1132: FROM iby_sys_security_subkeys bak
1133: , iby_security_segments bas
1134: WHERE bas.sec_subkey_id = bak.sec_subkey_id
1135: AND bas.sec_segment_id = p_sec_segment_id;
1136: END;