eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_STRATEGY_MEMBERS_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_strategy_id                    IN     NUMBER
  ,x_sequence_number                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_rule_id                        IN     NUMBER
  ,x_partial_success_allowed_flag   IN     VARCHAR2
  ,x_effective_from                 IN     DATE
  ,x_effective_to                   IN     DATE
  ,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
  ,x_date_type_code                 IN     VARCHAR2
  ,x_date_type_lookup_type          IN     VARCHAR2
  ,x_date_type_from                 IN     NUMBER
  ,x_date_type_to                   IN     NUMBER
  )IS
    CURSOR C IS SELECT ROWID FROM WMS_STRATEGY_MEMBERS
      WHERE strategy_id = x_strategy_id
        AND sequence_number = x_sequence_number;

Line: 43


   INSERT INTO WMS_STRATEGY_MEMBERS (
       strategy_id
      ,sequence_number
      ,last_updated_by
      ,last_update_date
      ,created_by
      ,creation_date
      ,last_update_login
      ,rule_id
      ,partial_success_allowed_flag
      ,effective_from
      ,effective_to
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,date_type_code
      ,date_type_lookup_type
      ,date_type_from
      ,date_type_to
    ) values (
       x_strategy_id
      ,x_sequence_number
      ,x_last_updated_by
      ,x_last_update_date
      ,x_created_by
      ,x_creation_date
      ,x_last_update_login
      ,x_rule_id
      ,x_partial_success_allowed_flag
      ,x_effective_from
      ,x_effective_to
      ,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
      ,x_date_type_code
      ,x_date_type_lookup_type
      ,x_date_type_from
      ,x_date_type_to
   );

Line: 116


END INSERT_ROW;

Line: 147


    CURSOR C IS SELECT
       strategy_id
      ,sequence_number
      ,rule_id
      ,partial_success_allowed_flag
      ,effective_from
      ,effective_to
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,date_type_code
      ,date_type_lookup_type
      ,date_type_from
      ,date_type_to
     FROM WMS_STRATEGY_MEMBERS
     WHERE rowid = x_rowid
     FOR UPDATE OF strategy_id NOWAIT;

Line: 184


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

Line: 267


PROCEDURE UPDATE_ROW (
   x_rowid                          IN     VARCHAR2
  ,x_strategy_id                    IN     NUMBER
  ,x_sequence_number                IN     NUMBER
  ,x_last_updated_by                IN     NUMBER
  ,x_last_update_date               IN     DATE
  ,x_last_update_login              IN     NUMBER
  ,x_rule_id                        IN     NUMBER
  ,x_partial_success_allowed_flag   IN     VARCHAR2
  ,x_effective_from                 IN     DATE
  ,x_effective_to                   IN     DATE
  ,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
  ,x_date_type_code                 IN     VARCHAR2
  ,x_date_type_lookup_type          IN     VARCHAR2
  ,x_date_type_from                 IN     NUMBER
  ,x_date_type_to                   IN     NUMBER
  )IS
BEGIN
   IF (x_rowid IS NOT NULL) THEN
      UPDATE WMS_STRATEGY_MEMBERS SET
          strategy_id = x_strategy_id
         ,sequence_number = x_sequence_number
         ,last_updated_by = x_last_updated_by
         ,last_update_date = x_last_update_date
         ,last_update_login = x_last_update_login
         ,rule_id = x_rule_id
         ,partial_success_allowed_flag = x_partial_success_allowed_flag
         ,effective_from = x_effective_from
         ,effective_to = x_effective_to
         ,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
         ,date_type_code = x_date_type_code
         ,date_type_lookup_type = x_date_type_lookup_type
         ,date_type_from = x_date_type_from
         ,date_type_to = x_date_type_to
      WHERE rowid     = x_rowid;

Line: 333


      UPDATE WMS_STRATEGY_MEMBERS SET
          strategy_id = x_strategy_id
         ,sequence_number = x_sequence_number
         ,last_updated_by = x_last_updated_by
         ,last_update_date = x_last_update_date
         ,last_update_login = x_last_update_login
         ,rule_id = x_rule_id
         ,partial_success_allowed_flag = x_partial_success_allowed_flag
         ,effective_from = x_effective_from
         ,effective_to = x_effective_to
         ,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
         ,date_type_code = x_date_type_code
         ,date_type_lookup_type = x_date_type_lookup_type
         ,date_type_from = x_date_type_from
         ,date_type_to = x_date_type_to
      WHERE strategy_id     = x_strategy_id
      AND   sequence_number = x_sequence_number;

Line: 370


END UPDATE_ROW;--

Line: 371


PROCEDURE DELETE_ROW (
   x_rowid IN VARCHAR2
  )IS
BEGIN

   DELETE FROM WMS_STRATEGY_MEMBERS
   WHERE rowid = x_rowid;

Line: 382


END DELETE_ROW;

Line: 429


      SELECT Sysdate INTO l_sysdate FROM dual;

Line: 439


      wms_strategy_members_pkg.update_row
	(
	  x_rowid                     => NULL
	 ,x_strategy_id               => l_strategy_id
	 ,x_sequence_number           => l_sequence_number
	 ,x_last_updated_by           => l_user_id
	 ,x_last_update_date          => l_sysdate
	 ,x_last_update_login         => 0
	 ,x_rule_id                   => l_rule_id
	,x_partial_success_allowed_flag => x_partial_success_allowed_flag
	 ,x_effective_from            => x_effective_from
	 ,x_effective_to              => x_effective_to
	 ,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
	 ,x_date_type_code            => x_date_type_code
	 ,x_date_type_lookup_type     => x_date_type_lookup_type
	 ,x_date_type_from            => l_date_type_from
	 ,x_date_type_to              => l_date_type_to
	 );

Line: 474


        wms_strategy_members_pkg.insert_row
	(
          x_rowid                     => l_row_id
	 ,x_strategy_id               => l_strategy_id
	 ,x_sequence_number           => l_sequence_number
	 ,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_rule_id                   => l_rule_id
	,x_partial_success_allowed_flag => x_partial_success_allowed_flag
	 ,x_effective_from            => x_effective_from
	 ,x_effective_to              => x_effective_to
	 ,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
	 ,x_date_type_code            => x_date_type_code
	 ,x_date_type_lookup_type     => x_date_type_lookup_type
	 ,x_date_type_from            => l_date_type_from
	 ,x_date_type_to              => l_date_type_to
	 );