APPS.OE_PC_VTMPLT_COLS_PKG SQL Statements

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

Line: 5

   PROCEDURE Insert_Row(
      x_rowid    				in out NOCOPY /* file.sql.39 change */  varchar2
	 ,x_validation_tmplt_col_id	in out NOCOPY /* file.sql.39 change */ number
      ,x_validation_tmplt_id 		in      number
      ,x_column_name                in      varchar2
      ,x_validation_op              in      varchar2
      ,x_value_string          	in      varchar2
      ,x_created_by       	 	in      number
      ,x_creation_date       		in      date
      ,x_last_updated_by 	    	in      number
      ,x_last_update_date        	in      date
      ,x_last_update_login       	in      number
   )
   Is
	 CURSOR C IS SELECT oe_pc_vtmplt_cols_s.nextval FROM dual;

Line: 20

      CURSOR CROWID IS SELECT rowid FROM oe_pc_vtmplt_cols
                       WHERE validation_tmplt_id = x_validation_tmplt_id
                       AND   column_name         = x_column_name;

Line: 34

      INSERT INTO oe_pc_vtmplt_cols (
	    validation_tmplt_col_id
         ,validation_tmplt_id
         ,column_name
         ,validation_op
         ,value_string
         ,created_by
         ,creation_date
         ,last_updated_by
         ,last_update_date
         ,last_update_login
      )
      Values
      (
	    x_validation_tmplt_col_id
         ,x_validation_tmplt_id
         ,x_column_name
         ,x_validation_op
         ,x_value_string
         ,x_created_by
         ,x_creation_date
         ,x_last_updated_by
         ,x_last_update_date
         ,x_last_update_login
      );

Line: 68

      UPDATE oe_pc_vtmplts
      SET
         last_updated_by    	 = x_last_updated_by
         ,last_update_date     = x_last_update_date
         ,last_update_login     = x_last_update_login
      WHERE validation_tmplt_id = x_validation_tmplt_id;

Line: 75

   End Insert_Row;

Line: 88

      ,x_last_updated_by 	    	in      number
      ,x_last_update_date        	in      date
      ,x_last_update_login       	in      number
   )
   Is
      CURSOR C IS
         SELECT *
         FROM oe_pc_vtmplt_cols
         WHERE rowid = x_rowid
         FOR UPDATE OF value_string NOWAIT;

Line: 105

         FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 116

           AND (Recinfo.last_updated_by    = x_last_updated_by)
           AND (Recinfo.last_update_date   = x_last_update_date)
           AND (    (Recinfo.last_update_login = x_last_update_login)
                 OR (    (recinfo.last_update_login IS NULL)
                      AND(x_last_update_login IS NULL)))
           AND (    (Recinfo.value_string = x_value_string)
                 OR (    (recinfo.value_string IS NULL)
                      AND(x_value_string IS NULL)))
         ) then
         return;

Line: 133

   PROCEDURE Update_Row(
      x_rowid    				in      varchar2
	 ,x_validation_tmplt_col_id   in	   number
      ,x_validation_tmplt_id 		in      number
      ,x_column_name                in      varchar2
      ,x_validation_op              in      varchar2
      ,x_value_string          	in      varchar2
      ,x_created_by       	 	in      number
      ,x_creation_date       		in      date
      ,x_last_updated_by 	    	in      number
      ,x_last_update_date        	in      date
      ,x_last_update_login       	in      number
   )
   Is
   Begin

      UPDATE oe_pc_vtmplt_cols
      SET
	 column_name 		= x_column_name
         ,validation_op        = x_validation_op
         ,value_string         = x_value_string
         ,last_updated_by    	 = x_last_updated_by
         ,last_update_date     = x_last_update_date
         ,last_update_login     = x_last_update_login
      WHERE rowid = x_rowid;

Line: 159

      UPDATE oe_pc_vtmplts
      SET
         last_updated_by    	 = x_last_updated_by
         ,last_update_date     = x_last_update_date
         ,last_update_login     = x_last_update_login
      WHERE validation_tmplt_id = x_validation_tmplt_id;

Line: 166

   End Update_Row;

Line: 170

   PROCEDURE Delete_Row(
      x_rowid    			in      varchar2
   )
   Is
   Begin

      DELETE FROM OE_PC_VTMPLT_COLS
      WHERE  rowid = x_rowid;

Line: 182

   End Delete_Row;

Line: 201

      SELECT count(1)
      INTO   dummy
      FROM   oe_pc_vtmplt_cols
      WHERE  validation_tmplt_id = x_validation_tmplt_id
      AND    column_name = x_column_name
      AND    validation_op = x_validation_op
      AND    value_string  = x_value_string
      AND    ((x_rowid IS null) OR (rowid <> x_rowid));