APPS.CN_CLRL_API_PKG SQL Statements

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

Line: 17

   SELECT cn_clrl_api_s.NEXTVAL
     INTO x_api_id
     FROM dual;

Line: 44

PROCEDURE Insert_Row(p_api_id                IN   NUMBER,
		     p_ruleset_name          IN   VARCHAR2,
		     p_parent_rule_name      IN   VARCHAR2,
		     p_rule_name             IN   VARCHAR2,
		     p_revenue_class_name    IN   VARCHAR2,
		     p_attribute_rule_name   IN   VARCHAR2,
		     p_not_flag              IN   VARCHAR2,
		     p_value_1               IN   VARCHAR2,
		     p_value_2               IN   VARCHAR2,
		     p_data_flag             IN   VARCHAR2,
		     p_loading_status        IN   VARCHAR2,
		     p_object_name           IN   VARCHAR2,
		     p_message_text          IN   VARCHAR2,
		     p_return_status         IN   VARCHAR2)
  IS
BEGIN
   INSERT INTO cn_clrl_api
     (clrl_api_id,
      ruleset_name, parent_rule_name,
      rule_name, revenue_class_name,
      attribute_rule_name, not_flag, value_1,
      value_2, data_flag, loading_status, object_name,
      message_text, return_status)
     VALUES(p_api_id, p_ruleset_name, p_parent_rule_name,
	    p_rule_name, p_revenue_class_name,
	    p_attribute_rule_name, p_not_flag, p_value_1,
	    p_value_2, p_data_flag, p_loading_status, p_object_name,
	    p_message_text, p_return_status);

Line: 73

END Insert_Row;

Line: 84

PROCEDURE Delete_Row(p_api_id       IN        NUMBER)
  IS
BEGIN
   DELETE FROM cn_clrl_api
     WHERE clrl_api_id = p_api_id;

Line: 89

END Delete_Row;

Line: 103

PROCEDURE Update_Row(p_api_id         IN        NUMBER,
		     p_loading_status IN        VARCHAR2,
		     p_message_text   IN        VARCHAR2,
		     p_return_status  IN        VARCHAR2)
  IS
BEGIN
   UPDATE cn_clrl_api
     SET loading_status = p_loading_status,
         message_text = p_message_text,
         return_status = p_return_status
     WHERE clrl_api_id = p_api_id;

Line: 114

END Update_Row;