APPS.CN_RULE_ATTR_EXPRESSION_PKG SQL Statements

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

Line: 33

PROCEDURE insert_row
   (p_rule_attr_expression_id   IN OUT NOCOPY NUMBER
    ,p_operand1                   NUMBER
    ,p_operand2                   NUMBER
    ,p_operator                   NUMBER          := NULL
    ,p_rule_id                    NUMBER          := NULL
    ,p_operand_expression_id	NUMBER		:= NULL
    ,p_operand1_ra_rae_flag       VARCHAR2        := NULL
    ,p_operand2_ra_rae_flag       VARCHAR2        := NULL
    ,p_Created_By               NUMBER
    ,p_Creation_Date            DATE
    ,p_Last_Updated_By          NUMBER
    ,p_Last_Update_Date         DATE
    ,p_Last_Update_Login        NUMBER
  )  IS
      l_dummy NUMBER;

Line: 52

     INSERT INTO cn_rule_attr_expression
   (	rule_attr_expression_id
    	,operand1
    	,operand2
    	,operator
    	,rule_id
    	,operand_expression_id
    	,operand1_ra_rae_flag
    	,operand2_ra_rae_flag
    	,Created_By
    	,Creation_Date
    	,Last_Updated_By
    	,Last_Update_Date
    	,Last_Update_Login)
   VALUES
    (	p_rule_attr_expression_id
     	,p_operand1
     	,p_operand2
     	,p_operator
     	,p_rule_id
    	,p_operand_expression_id
     	,p_operand1_ra_rae_flag
     	,p_operand2_ra_rae_flag
     	,p_Created_By
     	,p_Creation_Date
	,p_Last_Updated_By
	,p_Last_Update_Date
	,p_Last_Update_Login
	);

Line: 82

   END Insert_row;

Line: 91

  PROCEDURE Delete_row( p_rule_id     NUMBER ) IS
  BEGIN

     DELETE FROM cn_rule_attr_expression
       WHERE  rule_id = p_rule_id;

Line: 97

  END Delete_row;