APPS.WMS_DB_OBJECT_REF_PKG SQL Statements

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

Line: 4

PROCEDURE INSERT_ROW (
   x_rowid                          IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
  ,x_db_object_reference_id         IN     NUMBER
  ,x_last_updated_by                IN     NUMBER
  ,x_last_update_date               IN     DATE
  ,x_created_by                     IN     NUMBER
  ,x_creation_date                  IN     DATE
  ,x_last_update_login              IN     NUMBER
  ,x_description                    IN     VARCHAR2
  ,x_user_defined_flag              IN     VARCHAR2
  ,x_attribute1                     IN     VARCHAR2
  ,x_attribute2                     IN     VARCHAR2
  ,x_attribute3                     IN     VARCHAR2
  ,x_attribute4                     IN     VARCHAR2
  ,x_attribute5                     IN     VARCHAR2
  ,x_attribute6                     IN     VARCHAR2
  ,x_attribute7                     IN     VARCHAR2
  ,x_attribute8                     IN     VARCHAR2
  ,x_attribute9                     IN     VARCHAR2
  ,x_attribute10                    IN     VARCHAR2
  ,x_attribute11                    IN     VARCHAR2
  ,x_attribute12                    IN     VARCHAR2
  ,x_attribute13                    IN     VARCHAR2
  ,x_attribute14                    IN     VARCHAR2
  ,x_attribute15                    IN     VARCHAR2
  ,x_attribute_category             IN     VARCHAR2
  )IS
    CURSOR C IS SELECT ROWID FROM WMS_DB_OBJECT_REFERENCES
      WHERE db_object_reference_id = x_db_object_reference_id;

Line: 35

   INSERT INTO WMS_DB_OBJECT_REFERENCES (
       db_object_reference_id
      ,last_updated_by
      ,last_update_date
      ,created_by
      ,creation_date
      ,last_update_login
      ,description
      ,user_defined_flag
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,attribute_category
    ) values (
       x_db_object_reference_id
      ,x_last_updated_by
      ,x_last_update_date
      ,x_created_by
      ,x_creation_date
      ,x_last_update_login
      ,x_description
      ,x_user_defined_flag
      ,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_attribute_category
   );

Line: 94

END INSERT_ROW;

Line: 118

    CURSOR C IS SELECT
       db_object_reference_id
      ,description
      ,user_defined_flag
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,attribute_category
     FROM WMS_DB_OBJECT_REFERENCES
     WHERE rowid = x_rowid
     FOR UPDATE OF db_object_reference_id NOWAIT;

Line: 148

      fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 213

PROCEDURE UPDATE_ROW (
   x_db_object_reference_id         IN     NUMBER
  ,x_last_updated_by                IN     NUMBER
  ,x_last_update_date               IN     DATE
  ,x_last_update_login              IN     NUMBER
  ,x_description                    IN     VARCHAR2
  ,x_user_defined_flag              IN     VARCHAR2
  ,x_attribute1                     IN     VARCHAR2
  ,x_attribute2                     IN     VARCHAR2
  ,x_attribute3                     IN     VARCHAR2
  ,x_attribute4                     IN     VARCHAR2
  ,x_attribute5                     IN     VARCHAR2
  ,x_attribute6                     IN     VARCHAR2
  ,x_attribute7                     IN     VARCHAR2
  ,x_attribute8                     IN     VARCHAR2
  ,x_attribute9                     IN     VARCHAR2
  ,x_attribute10                    IN     VARCHAR2
  ,x_attribute11                    IN     VARCHAR2
  ,x_attribute12                    IN     VARCHAR2
  ,x_attribute13                    IN     VARCHAR2
  ,x_attribute14                    IN     VARCHAR2
  ,x_attribute15                    IN     VARCHAR2
  ,x_attribute_category             IN     VARCHAR2
  )IS
BEGIN
   UPDATE WMS_DB_OBJECT_REFERENCES SET
      last_updated_by = x_last_updated_by
      ,last_update_date = x_last_update_date
      ,last_update_login = x_last_update_login
      ,description = x_description
      ,user_defined_flag = x_user_defined_flag
      ,attribute1 = x_attribute1
      ,attribute2 = x_attribute2
      ,attribute3 = x_attribute3
      ,attribute4 = x_attribute4
      ,attribute5 = x_attribute5
      ,attribute6 = x_attribute6
      ,attribute7 = x_attribute7
      ,attribute8 = x_attribute8
      ,attribute9 = x_attribute9
      ,attribute10 = x_attribute10
      ,attribute11 = x_attribute11
      ,attribute12 = x_attribute12
      ,attribute13 = x_attribute13
      ,attribute14 = x_attribute14
      ,attribute15 = x_attribute15
      ,attribute_category = x_attribute_category
   WHERE db_object_reference_id = x_db_object_reference_id;

Line: 265

END UPDATE_ROW;--

Line: 266

PROCEDURE DELETE_ROW (
   x_rowid IN VARCHAR2
  )IS
BEGIN

   DELETE FROM WMS_DB_OBJECT_REFERENCES
   WHERE rowid = x_rowid;

Line: 277

END DELETE_ROW;

Line: 312

      SELECT Sysdate INTO l_sysdate FROM dual ;

Line: 314

      wms_db_object_ref_pkg.update_row
	(
	  x_db_object_reference_id    => l_db_object_reference_id
	 ,x_last_updated_by           => l_user_id
	 ,x_last_update_date          => l_sysdate
	 ,x_last_update_login         => 0
	 ,x_description               => x_description
	 ,x_user_defined_flag         => x_user_defined_flag
	 ,x_attribute_category        => x_attribute_category
	 ,x_attribute1                => x_attribute1
	 ,x_attribute2                => x_attribute2
	 ,x_attribute3                => x_attribute3
	 ,x_attribute4                => x_attribute4
	 ,x_attribute5                => x_attribute5
	 ,x_attribute6                => x_attribute6
	 ,x_attribute7                => x_attribute7
	 ,x_attribute8                => x_attribute8
	 ,x_attribute9                => x_attribute9
	 ,x_attribute10               => x_attribute10
	 ,x_attribute11               => x_attribute11
	 ,x_attribute12               => x_attribute12
	 ,x_attribute13               => x_attribute13
	 ,x_attribute14               => x_attribute14
	 ,x_attribute15               => x_attribute15
	 );

Line: 341

	 wms_db_object_ref_pkg.insert_row
	   (
	     x_rowid                   => l_row_id
	    ,x_db_object_reference_id  => l_db_object_reference_id
	    ,x_last_updated_by         => l_user_id
	    ,x_last_update_date        => l_sysdate
	    ,x_created_by              => l_user_id
	    ,x_creation_date           => l_sysdate
	    ,x_last_update_login       => 0
	    ,x_description             => x_description
	    ,x_user_defined_flag       => x_user_defined_flag
	    ,x_attribute_category      => x_attribute_category
	    ,x_attribute1              => x_attribute1
	    ,x_attribute2              => x_attribute2
	    ,x_attribute3              => x_attribute3
	    ,x_attribute4              => x_attribute4
	    ,x_attribute5              => x_attribute5
	    ,x_attribute6              => x_attribute6
	    ,x_attribute7              => x_attribute7
	    ,x_attribute8              => x_attribute8
	    ,x_attribute9              => x_attribute9
	    ,x_attribute10             => x_attribute10
	    ,x_attribute11             => x_attribute11
	    ,x_attribute12             => x_attribute12
	    ,x_attribute13             => x_attribute13
	    ,x_attribute14             => x_attribute14
	    ,x_attribute15	       => x_attribute15
	   );