PACKAGE BODY: APPS.CN_RULE_ATTR_EXPR

Source

1 PACKAGE BODY cn_rule_attr_expr AS
2 -- $Header: cnraethb.pls 115.1 99/07/16 07:13:07 porting shi $
3   --------------------------------------------------------------------------
4   -- Procedure Name:    delete_expr				        --
5   -- Purpose								--
6   --------------------------------------------------------------------------
7   PROCEDURE delete_expr
8                (x_rule_id IN cn_rule_attr_expression.rule_id%TYPE) IS
9   BEGIN
10 
11     UPDATE cn_attribute_rules
12     SET expression = ''
13     WHERE rule_id = x_rule_id;
14 
15     DELETE FROM cn_rule_attr_expression
16     WHERE  rule_id = x_rule_id;
17 
18     commit;
19 
20   END;
21 
22 
23 END cn_rule_attr_expr;