APPS.CN_SYIN_ATTR_RULES_PKG SQL Statements

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

Line: 31

       SELECT name, user_name, dimension_id
          INTO x_column_name, x_user_column_name, x_dimension_id
          FROM cn_objects
         WHERE object_id = x_column_id and org_id=x_org_id;

Line: 50

        SELECT name
          INTO x_hier_name
          FROM cn_head_hierarchies
         WHERE head_hierarchy_id = x_dim_hier_id and org_id=x_org_id;

Line: 64

        SELECT max(hn.name) INTO x_hier_value
           FROM cn_hierarchy_nodes hn,
                cn_dim_hierarchies dh
          WHERE hn.value_id = to_number(x_value_id)
            AND hn.dim_hierarchy_id = dh.dim_hierarchy_id
            AND dh.header_dim_hierarchy_id = x_dim_hier_id
	    AND hn.org_id=dh.org_id
	    AND hn.org_id=x_org_id;

Line: 96

      SELECT cn_objects_s.nextval
        INTO X_rule_id
        FROM sys.dual;

Line: 111

 PROCEDURE Insert_Row(p_attribute_rule_id        NUMBER,
		     p_column_id                NUMBER,
		     p_column_value             VARCHAR2,
		     p_low_value                VARCHAR2,
		     p_high_value               VARCHAR2,
		     p_dimension_hierarchy_id   NUMBER,
		     p_not_flag                 VARCHAR2,
		     p_rule_id                  NUMBER,
		     p_ruleset_id               NUMBER,
		     p_last_update_date         DATE,
		     p_last_updated_by          NUMBER,
		     p_creation_date            DATE,
		     p_created_by               NUMBER,
		     p_last_update_login        NUMBER,
		     p_org_id NUMBER
		     )
  IS
BEGIN
   INSERT INTO cn_attribute_rules(object_version_number,
                                  attribute_rule_id, column_id,
				  column_value, low_value, high_value,
				  dimension_hierarchy_id, not_flag,
				  rule_id, ruleset_id, last_update_date, last_updated_by,
				  creation_date,created_by,
				  last_update_login,org_id)
     VALUES(1,
            p_attribute_rule_id, p_column_id,
	    p_column_value, p_low_value, p_high_value,
	    p_dimension_hierarchy_id, p_not_flag,
	    p_rule_id,p_ruleset_id, p_last_update_date, p_last_updated_by,
	    p_creation_date, p_created_by,
	    p_last_update_login,p_org_id);

Line: 143

END Insert_Row;

Line: 153

PROCEDURE Update_Row(p_attribute_rule_id        NUMBER,
                     x_object_version_number  in out NOCOPY  number,  --added rckalyan
		     p_column_id                NUMBER,
		     p_column_value             VARCHAR2,
		     p_low_value                VARCHAR2,
		     p_high_value               VARCHAR2,
		     p_dimension_hierarchy_id   NUMBER,
		     p_not_flag                 VARCHAR2,
		     p_last_update_date         DATE,
		     p_last_updated_by          NUMBER,
		     p_last_update_login        NUMBER,
		     p_org_id NUMBER
		     )
  IS
BEGIN
   x_object_version_number :=x_object_version_number+1;

Line: 169

   UPDATE cn_attribute_rules
     SET column_id = p_column_id,
     object_version_number = x_object_version_number,
     column_value = p_column_value,
     low_value = p_low_value,
     high_value = p_high_value,
     dimension_hierarchy_id = p_dimension_hierarchy_id,
     not_flag = p_not_flag,
     last_update_date = p_last_update_date,
     last_updated_by = p_last_updated_by,
     last_update_login = p_last_update_login
     WHERE attribute_rule_id = p_attribute_rule_id ;

Line: 181

END Update_Row;

Line: 191

PROCEDURE delete_row(p_attribute_rule_id        NUMBER )
  IS
BEGIN

   DELETE FROM cn_attribute_rules
     WHERE attribute_rule_id = p_attribute_rule_id;

Line: 198

END Delete_Row;