DBA Data[Home] [Help]

APPS.HR_HRHD_INITIAL_LOAD dependencies on FND_CRYPTO

Line 1507: encryption_type PLS_INTEGER := FND_CRYPTO.DES3_CBC_PKCS5;

1503: /* Function for encrypting */
1504:
1505: function hr_hrhd_encrypt(p_data VARCHAR2 ) RETURN RAW is
1506: key_bytes_raw RAW (128); -- stores 256-bit encryption key
1507: encryption_type PLS_INTEGER := FND_CRYPTO.DES3_CBC_PKCS5;
1508: --DBMS_CRYPTO.HASH_MD5+ DBMS_CRYPTO.CHAIN_CBC + DBMS_CRYPTO.PAD_PKCS5; -- total encryption type
1509: BEGIN
1510:
1511: key_bytes_raw := UTL_I18N.STRING_TO_RAW(fnd_vault.get('HRHD','CRYPT_KEY'));

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

1509: BEGIN
1510:
1511: key_bytes_raw := UTL_I18N.STRING_TO_RAW(fnd_vault.get('HRHD','CRYPT_KEY'));
1512:
1513: RETURN(FND_CRYPTO.ENCRYPT(plaintext => utl_raw.cast_to_raw (p_data),
1514: crypto_type => encryption_type, key => key_bytes_raw ));
1515:
1516: END;
1517:

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

1518: /* Function for decrypting */
1519:
1520: function hr_hrhd_decrypt(p_data RAW ) RETURN VARCHAR2 is
1521: key_bytes_raw RAW (128); -- stores 256-bit encryption key
1522: encryption_type PLS_INTEGER := FND_CRYPTO.DES3_CBC_PKCS5 ; -- total encryption type
1523: --DBMS_CRYPTO.HASH_MD5+ DBMS_CRYPTO.CHAIN_CBC + DBMS_CRYPTO.PAD_PKCS5;
1524: BEGIN
1525:
1526: key_bytes_raw := UTL_I18N.STRING_TO_RAW(fnd_vault.get('HRHD','CRYPT_KEY'));

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

1524: BEGIN
1525:
1526: key_bytes_raw := UTL_I18N.STRING_TO_RAW(fnd_vault.get('HRHD','CRYPT_KEY'));
1527:
1528: RETURN(UTL_RAW.CAST_TO_VARCHAR2(FND_CRYPTO.DECRYPT(cryptext => p_data,
1529: crypto_type => encryption_type, key => key_bytes_raw )));
1530:
1531: END;
1532: