APPS.OE_PC_RSET_SEL_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_record_set_id 			in      number
      ,x_column_name                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 CROWID IS SELECT rowid FROM oe_pc_rset_sel_cols
                       WHERE record_set_id = x_record_set_id
                       AND   column_name   = x_column_name;

Line: 22

      INSERT INTO oe_pc_rset_sel_cols (
         record_set_id
         ,column_name
         ,created_by
         ,creation_date
         ,last_updated_by
         ,last_update_date
         ,last_update_login
      )
      Values
      (
         x_record_set_id
         ,x_column_name
         ,x_created_by
         ,x_creation_date
         ,x_last_updated_by
         ,x_last_update_date
         ,x_last_update_login
      );

Line: 50

      UPDATE oe_pc_rsets
      SET
         last_updated_by    	 = x_last_updated_by
         ,last_update_date     = x_last_update_date
         ,last_update_login     = x_last_update_login
      WHERE record_set_id = x_record_set_id ;

Line: 58

   End Insert_Row;

Line: 66

      ,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_rset_sel_cols
         WHERE rowid = x_rowid
         FOR UPDATE OF column_name NOWAIT;

Line: 83

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

Line: 92

           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)))
         ) then
         return;

Line: 106

   PROCEDURE Update_Row(
      x_rowid    				in      varchar2
      ,x_record_set_id 			in      number
      ,x_column_name                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_rset_sel_cols
      SET
         column_name 		 = x_column_name
         ,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: 127

     UPDATE oe_pc_rsets
     SET
         last_updated_by    	 = x_last_updated_by
         ,last_update_date     = x_last_update_date
         ,last_update_login     = x_last_update_login
     WHERE record_set_id = x_record_set_id ;

Line: 134

   End Update_Row;

Line: 137

   PROCEDURE Delete_Row(
      x_rowid    			in      varchar2
   )
   Is
   Begin

      DELETE FROM oe_pc_rset_sel_cols
      WHERE  rowid = x_rowid;

Line: 149

   End Delete_Row;

Line: 160

       SELECT count(1)
       INTO   dummy
       FROM   oe_pc_rset_sel_cols
       WHERE  record_set_id = x_record_set_id
       AND    column_name   = x_column_name
       AND    ((x_rowid IS null) OR (rowid <> x_rowid));