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 DBMS_OBFUSCATION_TOOLKIT

Line 35: l_key_hash := DBMS_OBFUSCATION_TOOLKIT.MD5( INPUT => p_sys_key );

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
37: DBMS_OBFUSCATION_TOOLKIT.MD5
38: (INPUT => UTL_RAW.concat(l_key_hash,l_site_salt));
39: END get_key_hash;

Line 37: DBMS_OBFUSCATION_TOOLKIT.MD5

33: BEGIN
34: l_site_salt := get_site_salt();
35: l_key_hash := DBMS_OBFUSCATION_TOOLKIT.MD5( INPUT => p_sys_key );
36: RETURN
37: DBMS_OBFUSCATION_TOOLKIT.MD5
38: (INPUT => UTL_RAW.concat(l_key_hash,l_site_salt));
39: END get_key_hash;
40:
41: FUNCTION Recipher_Key

Line 47: dbms_obfuscation_toolkit.des3encrypt

43: RETURN RAW
44: IS
45: BEGIN
46: RETURN
47: dbms_obfuscation_toolkit.des3encrypt
48: ( input =>
49: dbms_obfuscation_toolkit.des3decrypt
50: ( input => p_data , key => p_oldkey,
51: which => dbms_obfuscation_toolkit.ThreeKeyMode

Line 49: dbms_obfuscation_toolkit.des3decrypt

45: BEGIN
46: RETURN
47: dbms_obfuscation_toolkit.des3encrypt
48: ( input =>
49: dbms_obfuscation_toolkit.des3decrypt
50: ( input => p_data , key => p_oldkey,
51: which => dbms_obfuscation_toolkit.ThreeKeyMode
52: ),
53: key => p_newkey,

Line 51: which => dbms_obfuscation_toolkit.ThreeKeyMode

47: dbms_obfuscation_toolkit.des3encrypt
48: ( input =>
49: dbms_obfuscation_toolkit.des3decrypt
50: ( input => p_data , key => p_oldkey,
51: which => dbms_obfuscation_toolkit.ThreeKeyMode
52: ),
53: key => p_newkey,
54: which => dbms_obfuscation_toolkit.ThreeKeyMode
55: );

Line 54: which => dbms_obfuscation_toolkit.ThreeKeyMode

50: ( input => p_data , key => p_oldkey,
51: which => dbms_obfuscation_toolkit.ThreeKeyMode
52: ),
53: key => p_newkey,
54: which => dbms_obfuscation_toolkit.ThreeKeyMode
55: );
56: END Recipher_Key;
57:
58: --

Line 249: dbms_obfuscation_toolkit.des3getkey

245: --
246: -- subkey within use limit not found; create new one
247: --
248: x_subkey :=
249: dbms_obfuscation_toolkit.des3getkey
250: (seed => Fnd_Crypto.randombytes(G_DES3_MAX_KEY_LEN * 8),
251: which => dbms_obfuscation_toolkit.ThreeKeyMode
252: );
253: l_subkey_ciphertxt :=

Line 251: which => dbms_obfuscation_toolkit.ThreeKeyMode

247: --
248: x_subkey :=
249: dbms_obfuscation_toolkit.des3getkey
250: (seed => Fnd_Crypto.randombytes(G_DES3_MAX_KEY_LEN * 8),
251: which => dbms_obfuscation_toolkit.ThreeKeyMode
252: );
253: l_subkey_ciphertxt :=
254: dbms_obfuscation_toolkit.des3encrypt
255: ( input => x_subkey, key => p_masterkey,

Line 254: dbms_obfuscation_toolkit.des3encrypt

250: (seed => Fnd_Crypto.randombytes(G_DES3_MAX_KEY_LEN * 8),
251: which => dbms_obfuscation_toolkit.ThreeKeyMode
252: );
253: l_subkey_ciphertxt :=
254: dbms_obfuscation_toolkit.des3encrypt
255: ( input => x_subkey, key => p_masterkey,
256: which => dbms_obfuscation_toolkit.ThreeKeyMode
257: );
258:

Line 256: which => dbms_obfuscation_toolkit.ThreeKeyMode

252: );
253: l_subkey_ciphertxt :=
254: dbms_obfuscation_toolkit.des3encrypt
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

Line 271: dbms_obfuscation_toolkit.des3decrypt

267: fnd_global.login_id, 1);
268: ELSE
269: -- valid subkey existing found
270: x_subkey :=
271: dbms_obfuscation_toolkit.des3decrypt
272: ( input => x_subkey , key => p_masterkey,
273: which => dbms_obfuscation_toolkit.ThreeKeyMode
274: );
275: --

Line 273: which => dbms_obfuscation_toolkit.ThreeKeyMode

269: -- valid subkey existing found
270: x_subkey :=
271: dbms_obfuscation_toolkit.des3decrypt
272: ( input => x_subkey , key => p_masterkey,
273: which => dbms_obfuscation_toolkit.ThreeKeyMode
274: );
275: --
276: -- if subkey will be used, increment its use count
277: --

Line 302: RETURN dbms_obfuscation_toolkit.des3decrypt

298: RETURN DES3_KEY_TYPE
299: IS
300: BEGIN
301: -- no des3 padding required for either key
302: RETURN dbms_obfuscation_toolkit.des3decrypt
303: ( input => p_subkey_cipher , key => p_sys_key,
304: which => dbms_obfuscation_toolkit.ThreeKeyMode
305: );
306: END Get_Sys_Subkey;

Line 304: which => dbms_obfuscation_toolkit.ThreeKeyMode

300: BEGIN
301: -- no des3 padding required for either key
302: RETURN dbms_obfuscation_toolkit.des3decrypt
303: ( input => p_subkey_cipher , key => p_sys_key,
304: which => dbms_obfuscation_toolkit.ThreeKeyMode
305: );
306: END Get_Sys_Subkey;
307:
308: PROCEDURE Get_Sys_Subkey_Hex

Line 393: RETURN dbms_obfuscation_toolkit.des3encrypt

389: RETURN VARCHAR2
390: IS
391: BEGIN
392: IF ( p_encrypt = 'Y' ) THEN
393: RETURN dbms_obfuscation_toolkit.des3encrypt
394: ( input_string => prepare_cleartxt(p_data,p_pad),
395: key_string => p_sec_key,
396: which => dbms_obfuscation_toolkit.ThreeKeyMode
397: );

Line 396: which => dbms_obfuscation_toolkit.ThreeKeyMode

392: IF ( p_encrypt = 'Y' ) THEN
393: RETURN dbms_obfuscation_toolkit.des3encrypt
394: ( input_string => prepare_cleartxt(p_data,p_pad),
395: key_string => p_sec_key,
396: which => dbms_obfuscation_toolkit.ThreeKeyMode
397: );
398: ELSE
399: RETURN p_data;
400: END IF;

Line 644: DBMS_OBFUSCATION_TOOLKIT.des3encrypt

640: IBY_SECURITY_PKG.Get_Sys_Subkey
641: (FND_API.G_FALSE,p_sys_key,'Y',lx_subkey_id,lx_subkey);
642:
643: l_segment_cipher :=
644: DBMS_OBFUSCATION_TOOLKIT.des3encrypt
645: (input => p_segment, key => lx_subkey,
646: which => dbms_obfuscation_toolkit.ThreeKeyMode
647: );
648:

Line 646: which => dbms_obfuscation_toolkit.ThreeKeyMode

642:
643: l_segment_cipher :=
644: DBMS_OBFUSCATION_TOOLKIT.des3encrypt
645: (input => p_segment, key => lx_subkey,
646: which => dbms_obfuscation_toolkit.ThreeKeyMode
647: );
648:
649: SELECT iby_security_segments_s.NEXTVAL INTO x_segment_id FROM DUAL;
650: INSERT INTO iby_security_segments

Line 679: DBMS_OBFUSCATION_TOOLKIT.des3decrypt

675: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
676: l_subkey DES3_KEY_TYPE;
677: BEGIN
678: l_subkey :=
679: DBMS_OBFUSCATION_TOOLKIT.des3decrypt
680: (input => p_subkey_cipher, key => p_sys_key,
681: which => dbms_obfuscation_toolkit.ThreeKeyMode
682: );
683: l_segment_cipher :=

Line 681: which => dbms_obfuscation_toolkit.ThreeKeyMode

677: BEGIN
678: l_subkey :=
679: DBMS_OBFUSCATION_TOOLKIT.des3decrypt
680: (input => p_subkey_cipher, key => p_sys_key,
681: which => dbms_obfuscation_toolkit.ThreeKeyMode
682: );
683: l_segment_cipher :=
684: DBMS_OBFUSCATION_TOOLKIT.des3encrypt
685: (input => p_segment, key => l_subkey,

Line 684: DBMS_OBFUSCATION_TOOLKIT.des3encrypt

680: (input => p_subkey_cipher, key => p_sys_key,
681: which => dbms_obfuscation_toolkit.ThreeKeyMode
682: );
683: l_segment_cipher :=
684: DBMS_OBFUSCATION_TOOLKIT.des3encrypt
685: (input => p_segment, key => l_subkey,
686: which => dbms_obfuscation_toolkit.ThreeKeyMode
687: );
688:

Line 686: which => dbms_obfuscation_toolkit.ThreeKeyMode

682: );
683: l_segment_cipher :=
684: DBMS_OBFUSCATION_TOOLKIT.des3encrypt
685: (input => p_segment, key => l_subkey,
686: which => dbms_obfuscation_toolkit.ThreeKeyMode
687: );
688:
689: UPDATE iby_security_segments
690: SET

Line 768: l_hash := dbms_obfuscation_toolkit.md5

764: -- !!! THIS WILL CORRUPT EVERY ENTITY THAT STORES !!!
765: -- !!! A SALTED HASH VALUE (HASH_VALUE_2) !!!
766: --
767: IF (FND_API.To_Boolean(p_salt)) THEN
768: l_hash := dbms_obfuscation_toolkit.md5
769: (input_string => p_text||SUBSTR(p_text,-1));
770: ELSE
771: l_hash := dbms_obfuscation_toolkit.md5(input_string => p_text);
772: END IF;

Line 771: l_hash := dbms_obfuscation_toolkit.md5(input_string => p_text);

767: IF (FND_API.To_Boolean(p_salt)) THEN
768: l_hash := dbms_obfuscation_toolkit.md5
769: (input_string => p_text||SUBSTR(p_text,-1));
770: ELSE
771: l_hash := dbms_obfuscation_toolkit.md5(input_string => p_text);
772: END IF;
773:
774: RETURN DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_STRING => (l_hash || l_site_salt));
775: END Get_Hash;

Line 774: RETURN DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_STRING => (l_hash || l_site_salt));

770: ELSE
771: l_hash := dbms_obfuscation_toolkit.md5(input_string => p_text);
772: END IF;
773:
774: RETURN DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_STRING => (l_hash || l_site_salt));
775: END Get_Hash;
776:
777: -- bug 7228583
778: FUNCTION Get_Hash( p_text IN VARCHAR2, p_salt IN VARCHAR2, p_site_salt IN VARCHAR2)

Line 788: l_hash := dbms_obfuscation_toolkit.md5

784: -- !!! THIS WILL CORRUPT EVERY ENTITY THAT STORES !!!
785: -- !!! A SALTED HASH VALUE (HASH_VALUE_2) !!!
786: --
787: IF (FND_API.To_Boolean(p_salt)) THEN
788: l_hash := dbms_obfuscation_toolkit.md5
789: (input_string => p_text||SUBSTR(p_text,-1));
790: ELSE
791: l_hash := dbms_obfuscation_toolkit.md5(input_string => p_text);
792: END IF;

Line 791: l_hash := dbms_obfuscation_toolkit.md5(input_string => p_text);

787: IF (FND_API.To_Boolean(p_salt)) THEN
788: l_hash := dbms_obfuscation_toolkit.md5
789: (input_string => p_text||SUBSTR(p_text,-1));
790: ELSE
791: l_hash := dbms_obfuscation_toolkit.md5(input_string => p_text);
792: END IF;
793:
794: RETURN DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_STRING => (l_hash || p_site_salt));
795: END Get_Hash;

Line 794: RETURN DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_STRING => (l_hash || p_site_salt));

790: ELSE
791: l_hash := dbms_obfuscation_toolkit.md5(input_string => p_text);
792: END IF;
793:
794: RETURN DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_STRING => (l_hash || p_site_salt));
795: END Get_Hash;
796:
797: FUNCTION Get_Raw_Hash( p_data IN RAW ) RETURN RAW
798: IS

Line 800: RETURN dbms_obfuscation_toolkit.md5(input => p_data);

796:
797: FUNCTION Get_Raw_Hash( p_data IN RAW ) RETURN RAW
798: IS
799: BEGIN
800: RETURN dbms_obfuscation_toolkit.md5(input => p_data);
801: END Get_Raw_Hash;
802:
803: FUNCTION Gen_Des3_Key( p_random_seed IN RAW ) RETURN RAW
804: IS

Line 807: dbms_obfuscation_toolkit.des3getkey

803: FUNCTION Gen_Des3_Key( p_random_seed IN RAW ) RETURN RAW
804: IS
805: BEGIN
806: RETURN
807: dbms_obfuscation_toolkit.des3getkey
808: (seed => p_random_seed,
809: which => dbms_obfuscation_toolkit.ThreeKeyMode
810: );
811: END;

Line 809: which => dbms_obfuscation_toolkit.ThreeKeyMode

805: BEGIN
806: RETURN
807: dbms_obfuscation_toolkit.des3getkey
808: (seed => p_random_seed,
809: which => dbms_obfuscation_toolkit.ThreeKeyMode
810: );
811: END;
812:
813: FUNCTION PKCS5_Pad(p_data IN RAW) RETURN RAW

Line 1080: dbms_obfuscation_toolkit.des3decrypt

1076: l_sub_key := get_sys_subkey(p_sys_key,p_sub_key_cipher);
1077:
1078: -- uncipher the segment
1079: l_fv_segment :=
1080: dbms_obfuscation_toolkit.des3decrypt
1081: ( input => p_segment_cipher, key => l_sub_key,
1082: which => dbms_obfuscation_toolkit.ThreeKeyMode
1083: );
1084: l_fv_segment := IBY_SECURITY_PKG.PKCS5_UNPAD(l_fv_segment);

Line 1082: which => dbms_obfuscation_toolkit.ThreeKeyMode

1078: -- uncipher the segment
1079: l_fv_segment :=
1080: dbms_obfuscation_toolkit.des3decrypt
1081: ( input => p_segment_cipher, key => l_sub_key,
1082: which => dbms_obfuscation_toolkit.ThreeKeyMode
1083: );
1084: l_fv_segment := IBY_SECURITY_PKG.PKCS5_UNPAD(l_fv_segment);
1085: BEGIN
1086: SELECT value