APPS.WMS_DB_OBJ_PARENTS_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_id                   IN     NUMBER
  ,x_type_code                      IN     NUMBER
  ,x_parent_db_object_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_attribute_category             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
  )IS
    CURSOR C IS SELECT ROWID FROM WMS_DB_OBJECTS_PARENTS
      WHERE db_object_id = x_db_object_id
        AND type_code = x_type_code;

Line: 36

   INSERT INTO WMS_DB_OBJECTS_PARENTS (
       db_object_id
      ,type_code
      ,parent_db_object_id
      ,last_updated_by
      ,last_update_date
      ,created_by
      ,creation_date
      ,last_update_login
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
    ) values (
       x_db_object_id
      ,x_type_code
      ,x_parent_db_object_id
      ,x_last_updated_by
      ,x_last_update_date
      ,x_created_by
      ,x_creation_date
      ,x_last_update_login
      ,x_attribute_category
      ,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
   );

Line: 95

END INSERT_ROW;

Line: 119

    CURSOR C IS SELECT
       db_object_id
      ,type_code
      ,parent_db_object_id
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
     FROM WMS_DB_OBJECTS_PARENTS
     WHERE rowid = x_rowid
     FOR UPDATE OF db_object_id, type_code NOWAIT;

Line: 149

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

Line: 212

PROCEDURE UPDATE_ROW (
   x_db_object_id                   IN     NUMBER
  ,x_type_code                      IN     NUMBER
  ,x_parent_db_object_id            IN     NUMBER
  ,x_last_updated_by                IN     NUMBER
  ,x_last_update_date               IN     DATE
  ,x_last_update_login              IN     NUMBER
  ,x_attribute_category             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
  )IS

BEGIN
   UPDATE WMS_DB_OBJECTS_PARENTS
     SET last_updated_by = x_last_updated_by
      ,last_update_date    = x_last_update_date
      ,last_update_login   = x_last_update_login
      ,parent_db_object_id = x_parent_db_object_id
      ,attribute_category  = x_attribute_category
      ,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
   WHERE db_object_id = x_db_object_id
   AND    type_code = x_type_code;

Line: 265

END UPDATE_ROW;--

Line: 266

PROCEDURE DELETE_ROW (
   x_rowid IN VARCHAR2
  )IS
BEGIN

   DELETE FROM WMS_DB_OBJECTS_PARENTS
   WHERE rowid = x_rowid;

Line: 277

END DELETE_ROW;

Line: 315

      SELECT Sysdate INTO l_sysdate FROM dual;

Line: 321

      wms_db_obj_parents_pkg.update_row
	(
	  x_db_object_id              => l_db_object_id
	 ,x_type_code                 => l_type_code
	 ,x_last_updated_by           => l_user_id
	 ,x_last_update_date          => l_sysdate
	 ,x_last_update_login         => 0
	 ,x_parent_db_object_id       => l_parent_db_object_id
	 ,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: 348

	 wms_db_obj_parents_pkg.insert_row
	   (
	     x_rowid                   => l_row_id
	    ,x_db_object_id            => l_db_object_id
	    ,x_type_code               => l_type_code
	    ,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_parent_db_object_id     => l_parent_db_object_id
	    ,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
	   );