APPS.GL_AUTOREV_CRITERIA_SETS_PKG SQL Statements

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

Line: 10

  PROCEDURE insert_row(X_Criteria_Set_Id                NUMBER,
                       X_Criteria_Set_Name              VARCHAR2,
                       X_Criteria_Set_Desc              VARCHAR2,
		       X_Creation_Date                  DATE,
                       X_Last_Update_Date               DATE,
		       X_Created_By                     NUMBER,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER,
                       X_Attribute1                     VARCHAR2,
                       X_Attribute2                     VARCHAR2,
                       X_Attribute3                     VARCHAR2,
                       X_Attribute4                     VARCHAR2,
                       X_Attribute5                     VARCHAR2,
                       X_Attribute6                     VARCHAR2,
                       X_Attribute7                     VARCHAR2,
                       X_Attribute8                     VARCHAR2,
                       X_Attribute9                     VARCHAR2,
                       X_Attribute10                    VARCHAR2,
                       X_Attribute11                    VARCHAR2,
                       X_Attribute12                    VARCHAR2,
                       X_Attribute13                    VARCHAR2,
                       X_Attribute14                    VARCHAR2,
                       X_Attribute15                    VARCHAR2,
                       X_Context                        VARCHAR2,
	               X_Security_Flag                  VARCHAR2
                      )  IS


  BEGIN


     INSERT INTO gl_autorev_criteria_sets(
      			criteria_set_id,
       			criteria_set_name,
       			criteria_set_desc,
			creation_date,
       			last_update_date,
			created_by,
       			last_updated_by,
       			last_update_login,
       			attribute1,
       			attribute2,
       			attribute3,
       			attribute4,
       			attribute5,
       			attribute6,
       			attribute7,
       			attribute8,
       			attribute9,
       			attribute10,
       			attribute11,
       			attribute12 ,
       			attribute13,
       			attribute14 ,
       			attribute15 ,
       			context,
       			security_flag)
     		VALUES(x_Criteria_Set_id,
                       X_Criteria_Set_Name,
                       X_Criteria_Set_Desc,
		       X_Creation_Date,
                       X_Last_Update_Date,
		       X_Created_By,
                       X_Last_Updated_By,
                       X_Last_Update_Login,
                       X_Attribute1,
                       X_Attribute2,
                       X_Attribute3,
                       X_Attribute4,
                       X_Attribute5,
                       X_Attribute6,
                       X_Attribute7,
                       X_Attribute8,
                       X_Attribute9,
                       X_Attribute10,
                       X_Attribute11,
                       X_Attribute12,
                       X_Attribute13,
                       X_Attribute14,
                       X_Attribute15,
                       X_Context,
	               X_Security_Flag);

Line: 93

  	-- Insert Detail values also into GL_AUTOREVERS_OPTIONS

	    GL_AUTOREVERSE_OPTIONS_PKG.Insert_Criteria_Reversal_Cat(
		x_criteria_set_id   => X_Criteria_Set_id,
		x_created_by        => X_Created_By,
		x_last_updated_by   => X_Last_Updated_By,
		x_last_update_login => X_Last_Update_Login);

Line: 107

  END insert_row;

Line: 119

     SELECT GL_AUTOREV_CRITERIA_SETS_S.Nextval INTO l_criteria_set_id
		FROM DUAL;

Line: 138

   Procedure Delete_row( X_Criteria_set_Id      NUMBER)  IS

	l_ledger_id 	NUMBER := 0;

Line: 142

        DELETE FROM GL_AUTOREVERSE_OPTIONS G
        WHERE G.CRITERIA_SET_ID = x_criteria_set_id;

Line: 149

        'GL_AUTOREV_CRITERIA_SETS.Delete_Row');

Line: 151

   END Delete_Row;

Line: 162

      SELECT 1 into x_ledger_id FROM DUAL
      WHERE EXISTS (SELECT ledger_id FROM GL_LEDGERS
                    where  criteria_set_id = x_criteria_set_id);