[Home] [Help]
523: END IF;
524: RAISE;
525: END drop_user;
526:
527: -- Used to update a parameter in asg_config
528: PROCEDURE set_config_param(p_param_name IN VARCHAR2,
529: p_param_value IN VARCHAR2,
530: p_param_description IN VARCHAR2 := NULL)
531: IS
530: p_param_description IN VARCHAR2 := NULL)
531: IS
532: BEGIN
533:
534: asg_config_pkg.load_row(p_param_name, p_param_value,
535: p_param_description,
536: sysdate, 1,
537: sysdate, 1,
538: FND_API.G_MISS_CHAR);
539: COMMIT;
540:
541: END set_config_param;
542:
543: -- Returns the value column in asg_config table based on the
544: -- specified parameter name
545: FUNCTION get_param_value(p_param_name IN VARCHAR2)
546: return VARCHAR2 IS
547: CURSOR C_PARAM_VALUE(p_param_name varchar2) IS
545: FUNCTION get_param_value(p_param_name IN VARCHAR2)
546: return VARCHAR2 IS
547: CURSOR C_PARAM_VALUE(p_param_name varchar2) IS
548: SELECT value
549: FROM asg_config
550: WHERE name = p_param_name;
551: l_param_value VARCHAR2(2000);
552: BEGIN
553:
1233: end encrypt;
1234:
1235:
1236: --This procedure encrypts p_input_string using the key p_key.
1237: --It then updates the asg_config param p_param_name
1238: procedure encrypt_and_copy(p_param_name varchar2,p_input_string varchar2,
1239: p_key varchar2,p_param_desc varchar2)
1240: is
1241: begin
1276: which => 0);
1277: return l_decrypted_string;
1278: end decrypt;
1279:
1280: --This function reads the value of the asg_config param p_param_name
1281: --The value is decrypted using p_key and the decrypted string is returned.
1282: function decrypt_and_return(p_param_name varchar2,p_key varchar2)
1283: return varchar2
1284: is
1293: is
1294: l_decrypted_string varchar2(1024):= null;
1295: l_dec_str varchar2(1024);
1296: begin
1297: select value into l_dec_str from asg_config
1298: where name = p_param_name;
1299:
1300: DBMS_OBFUSCATION_toolkit.DES3Decrypt(input_string => l_dec_str,
1301: key_string => p_key,decrypted_string => l_decrypted_string,