[Home] [Help]
542: END IF;
543: RAISE;
544: END drop_user;
545:
546: -- Used to update a parameter in asg_config
547: PROCEDURE set_config_param(p_param_name IN VARCHAR2,
548: p_param_value IN VARCHAR2,
549: p_param_description IN VARCHAR2 := NULL)
550: IS
549: p_param_description IN VARCHAR2 := NULL)
550: IS
551: BEGIN
552:
553: asg_config_pkg.load_row(p_param_name, p_param_value,
554: p_param_description,
555: sysdate, 1,
556: sysdate, 1,
557: FND_API.G_MISS_CHAR);
558: COMMIT;
559:
560: END set_config_param;
561:
562: -- Returns the value column in asg_config table based on the
563: -- specified parameter name
564: FUNCTION get_param_value(p_param_name IN VARCHAR2)
565: return VARCHAR2 IS
566: CURSOR C_PARAM_VALUE(p_param_name varchar2) IS
564: FUNCTION get_param_value(p_param_name IN VARCHAR2)
565: return VARCHAR2 IS
566: CURSOR C_PARAM_VALUE(p_param_name varchar2) IS
567: SELECT value
568: FROM asg_config
569: WHERE name = p_param_name;
570: l_param_value VARCHAR2(2000);
571: BEGIN
572:
1296: end encrypt;
1297:
1298:
1299: --This procedure encrypts p_input_string using the key p_key.
1300: --It then updates the asg_config param p_param_name
1301: procedure encrypt_and_copy(p_param_name varchar2,p_input_string varchar2,
1302: p_key varchar2,p_param_desc varchar2)
1303: is
1304: begin
1339: which => 0);
1340: return l_decrypted_string;
1341: end decrypt;
1342:
1343: --This function reads the value of the asg_config param p_param_name
1344: --The value is decrypted using p_key and the decrypted string is returned.
1345: function decrypt_and_return(p_param_name varchar2,p_key varchar2)
1346: return varchar2
1347: is
1356: is
1357: l_decrypted_string varchar2(1024):= null;
1358: l_dec_str varchar2(1024);
1359: begin
1360: select value into l_dec_str from asg_config
1361: where name = p_param_name;
1362:
1363: DBMS_OBFUSCATION_toolkit.DES3Decrypt(input_string => l_dec_str,
1364: key_string => p_key,decrypted_string => l_decrypted_string,