DBA Data[Home] [Help]

APPS.HR_HRHD_INITIAL_LOAD dependencies on FND_CRYPTO

Line 1109: encryption_type PLS_INTEGER := FND_CRYPTO.DES3_CBC_PKCS5;

1105: /* Function for encrypting */
1106:
1107: function hr_hrhd_encrypt(p_data VARCHAR2 ) RETURN RAW is
1108: key_bytes_raw RAW (128); -- stores 256-bit encryption key
1109: encryption_type PLS_INTEGER := FND_CRYPTO.DES3_CBC_PKCS5;
1110: --DBMS_CRYPTO.HASH_MD5+ DBMS_CRYPTO.CHAIN_CBC + DBMS_CRYPTO.PAD_PKCS5; -- total encryption type
1111: BEGIN
1112:
1113: key_bytes_raw := UTL_I18N.STRING_TO_RAW(fnd_vault.get('HRHD','CRYPT_KEY'));

Line 1115: RETURN(FND_CRYPTO.ENCRYPT(plaintext => utl_raw.cast_to_raw (p_data),

1111: BEGIN
1112:
1113: key_bytes_raw := UTL_I18N.STRING_TO_RAW(fnd_vault.get('HRHD','CRYPT_KEY'));
1114:
1115: RETURN(FND_CRYPTO.ENCRYPT(plaintext => utl_raw.cast_to_raw (p_data),
1116: crypto_type => encryption_type, key => key_bytes_raw ));
1117:
1118: END;
1119:

Line 1124: encryption_type PLS_INTEGER := FND_CRYPTO.DES3_CBC_PKCS5 ; -- total encryption type

1120: /* Function for decrypting */
1121:
1122: function hr_hrhd_decrypt(p_data RAW ) RETURN VARCHAR2 is
1123: key_bytes_raw RAW (128); -- stores 256-bit encryption key
1124: encryption_type PLS_INTEGER := FND_CRYPTO.DES3_CBC_PKCS5 ; -- total encryption type
1125: --DBMS_CRYPTO.HASH_MD5+ DBMS_CRYPTO.CHAIN_CBC + DBMS_CRYPTO.PAD_PKCS5;
1126: BEGIN
1127:
1128: key_bytes_raw := UTL_I18N.STRING_TO_RAW(fnd_vault.get('HRHD','CRYPT_KEY'));

Line 1130: RETURN(UTL_RAW.CAST_TO_VARCHAR2(FND_CRYPTO.DECRYPT(cryptext => p_data,

1126: BEGIN
1127:
1128: key_bytes_raw := UTL_I18N.STRING_TO_RAW(fnd_vault.get('HRHD','CRYPT_KEY'));
1129:
1130: RETURN(UTL_RAW.CAST_TO_VARCHAR2(FND_CRYPTO.DECRYPT(cryptext => p_data,
1131: crypto_type => encryption_type, key => key_bytes_raw )));
1132:
1133: END;
1134: