DBA Data[Home] [Help]

APPS.CN_RULE_ATTR_EXPR SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

  PROCEDURE delete_expr
               (x_rule_id IN cn_rule_attr_expression.rule_id%TYPE) IS
  BEGIN

    UPDATE cn_attribute_rules
    SET expression = ''
    WHERE rule_id = x_rule_id;
Line: 15

    DELETE FROM cn_rule_attr_expression
    WHERE  rule_id = x_rule_id;