DECLARE
i_rule_key varchar2(30);
i_rule_type varchar2(30);
i_function_name varchar2(30);
i_form_name varchar2(30);
cursor c1
is
select * from fnd_form_custom_rules
where id = '2222';
BEGIN
fnd_form_custom_rules_pkg.
delete_set (x_rule_key => i_rule_key,
x_rule_type => i_rule_type,
x_function_name => i_function_name,
x_form_name => i_form_name);
DBMS_OUTPUT. put_line (' Personalization has been Successfully Completed');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('Error: ' || SQLERRM);
END;
i_rule_key varchar2(30);
i_rule_type varchar2(30);
i_function_name varchar2(30);
i_form_name varchar2(30);
cursor c1
is
select * from fnd_form_custom_rules
where id = '2222';
BEGIN
fnd_form_custom_rules_pkg.
delete_set (x_rule_key => i_rule_key,
x_rule_type => i_rule_type,
x_function_name => i_function_name,
x_form_name => i_form_name);
DBMS_OUTPUT. put_line (' Personalization has been Successfully Completed');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('Error: ' || SQLERRM);
END;
No comments:
Post a Comment