APPS.IBY_SECURITY_PKG dependencies on IBY_SECURITY_PKG

Line 1: PACKAGE BODY IBY_SECURITY_PKG AS

1: PACKAGE BODY IBY_SECURITY_PKG AS
2: /* $Header: ibysecb.pls 120.22.12010000.10 2008/11/20 02:12:50 jleybovi ship $ */
3:
4: -- Number to hex format string
5: NUMTOX CONSTANT VARCHAR2(34) := 'FMXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';

Line 20: p_module IN VARCHAR2 DEFAULT 'iby.plsql.IBY_SECURITY_PKG'

16: PROCEDURE print_debuginfo(
17: p_message IN VARCHAR2,
18: p_prefix IN VARCHAR2 DEFAULT 'DEBUG',
19: p_msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
20: p_module IN VARCHAR2 DEFAULT 'iby.plsql.IBY_SECURITY_PKG'
21: );
22:
23: FUNCTION get_site_salt RETURN RAW
24: IS

Line 385: p_sec_key IN IBY_SECURITY_PKG.DES3_KEY_TYPE,

381: END Unpack_Cleartxt;
382:
383: FUNCTION Cipher_Data
384: (p_data IN VARCHAR2,
385: p_sec_key IN IBY_SECURITY_PKG.DES3_KEY_TYPE,
386: p_pad IN VARCHAR2,
387: p_encrypt IN VARCHAR2
388: )
389: RETURN VARCHAR2

Line 640: IBY_SECURITY_PKG.Get_Sys_Subkey

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);
642:
643: l_segment_cipher :=
644: DBMS_OBFUSCATION_TOOLKIT.des3encrypt

Line 890: IF ( (p_mask_setting = iby_security_pkg.G_MASK_POSTFIX) )

886: x_compress_val := NULL;
887: RETURN;
888: END IF;
889:
890: IF ( (p_mask_setting = iby_security_pkg.G_MASK_POSTFIX) )
891: THEN
892: l_substr_start := l_unmask_len + 1;
893: ELSE
894: l_substr_start := 1;

Line 897: IF (p_mask_setting = iby_security_pkg.G_MASK_PREFIX)

893: ELSE
894: l_substr_start := 1;
895: END IF;
896:
897: IF (p_mask_setting = iby_security_pkg.G_MASK_PREFIX)
898: AND (p_unmask_len>0)
899: THEN
900: l_substr_stop := GREATEST(LENGTH(p_value)-p_unmask_len,0);
901: ELSE

Line 950: , p_mask_setting => iby_security_pkg.G_MASK_ALL

946: iby_debug_pub.add('encrypting field value',
947: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
948:
949: Compress_Value ( p_value => p_value
950: , p_mask_setting => iby_security_pkg.G_MASK_ALL
951: , p_unmask_len => 0
952: , x_compress_val => lx_compress_val
953: , x_unmask_digits => lx_unmask_digits);
954:

Line 962: , iby_security_pkg.G_ENCODING_UTF8_AL32

958:
959: IF (p_sec_segment_id IS NULL) THEN
960: Create_Segment ( FND_API.G_FALSE
961: , l_fv_segment
962: , iby_security_pkg.G_ENCODING_UTF8_AL32
963: , master_key_in
964: , x_sec_segment_id
965: );
966: ELSE

Line 978: , iby_security_pkg.G_ENCODING_UTF8_AL32

974: END;
975: Update_Segment ( FND_API.G_FALSE
976: , p_sec_segment_id
977: , l_fv_segment
978: , iby_security_pkg.G_ENCODING_UTF8_AL32
979: , master_key_in
980: , l_subkey_cipher
981: );
982:

Line 1084: l_fv_segment := IBY_SECURITY_PKG.PKCS5_UNPAD(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
1087: INTO l_db_characterset
1088: FROM v$nls_parameters

Line 1120: -- iby_security_pkg.Pad_Raw_Key( UTL_RAW.CAST_TO_RAW( p_sys_sec_key ) );

1116: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1117:
1118: IF (p_sec_segment_id IS NOT NULL) THEN
1119: --l_sys_key :=
1120: -- iby_security_pkg.Pad_Raw_Key( UTL_RAW.CAST_TO_RAW( p_sys_sec_key ) );
1121:
1122: iby_debug_pub.add('decrypting field value',
1123: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1124:

Line 1197: END IBY_SECURITY_PKG;

1193: /*
1194: * 6018583:FP: END
1195: */
1196:
1197: END IBY_SECURITY_PKG;