APPS.WMS_RESTRICTIONS_PKG SQL Statements

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

Line: 4

PROCEDURE INSERT_ROW (
   x_rowid                          IN OUT NOCOPY VARCHAR2
  ,x_rule_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_parameter_id                   IN     NUMBER
  ,x_operator_code                  IN     NUMBER
  ,x_operand_type_code              IN     NUMBER
  ,x_operand_constant_number        IN     NUMBER
  ,x_operand_constant_character     IN     VARCHAR2
  ,x_operand_constant_date          IN     DATE
  ,x_operand_parameter_id           IN     NUMBER
  ,x_operand_expression             IN     VARCHAR2
  ,x_operand_flex_value_set_id      IN     NUMBER
  ,x_logical_operator_code          IN     NUMBER
  ,x_bracket_open                   IN     VARCHAR2
  ,x_bracket_close                  IN     VARCHAR2
  ,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_RESTRICTIONS
      WHERE rule_id = x_rule_id
        AND sequence_number = x_sequence_number;

Line: 47

   INSERT INTO WMS_RESTRICTIONS (
       rule_id
      ,sequence_number
      ,last_updated_by
      ,last_update_date
      ,created_by
      ,creation_date
      ,last_update_login
      ,parameter_id
      ,operator_code
      ,operand_type_code
      ,operand_constant_number
      ,operand_constant_character
      ,operand_constant_date
      ,operand_parameter_id
      ,operand_expression
      ,operand_flex_value_set_id
      ,logical_operator_code
      ,bracket_open
      ,bracket_close
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
    ) values (
       x_rule_id
      ,x_sequence_number
      ,x_last_updated_by
      ,x_last_update_date
      ,x_created_by
      ,x_creation_date
      ,x_last_update_login
      ,x_parameter_id
      ,x_operator_code
      ,x_operand_type_code
      ,x_operand_constant_number
      ,x_operand_constant_character
      ,x_operand_constant_date
      ,x_operand_parameter_id
      ,x_operand_expression
      ,x_operand_flex_value_set_id
      ,x_logical_operator_code
      ,x_bracket_open
      ,x_bracket_close
      ,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: 128

END INSERT_ROW;

Line: 163

    CURSOR C IS SELECT
       rule_id
      ,sequence_number
      ,parameter_id
      ,operator_code
      ,operand_type_code
      ,operand_constant_number
      ,operand_constant_character
      ,operand_constant_date
      ,operand_parameter_id
      ,operand_expression
      ,operand_flex_value_set_id
      ,logical_operator_code
      ,bracket_open
      ,bracket_close
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
     FROM WMS_RESTRICTIONS
     WHERE rowid = x_rowid
     FOR UPDATE OF rule_id NOWAIT;

Line: 204

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

Line: 297

PROCEDURE UPDATE_ROW (
   x_rowid                          IN     VARCHAR2
  ,x_rule_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_parameter_id                   IN     NUMBER
  ,x_operator_code                  IN     NUMBER
  ,x_operand_type_code              IN     NUMBER
  ,x_operand_constant_number        IN     NUMBER
  ,x_operand_constant_character     IN     VARCHAR2
  ,x_operand_constant_date          IN     DATE
  ,x_operand_parameter_id           IN     NUMBER
  ,x_operand_expression             IN     VARCHAR2
  ,x_operand_flex_value_set_id      IN     NUMBER
  ,x_logical_operator_code          IN     NUMBER
  ,x_bracket_open                   IN     VARCHAR2
  ,x_bracket_close                  IN     VARCHAR2
  ,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
   IF (x_rowid IS NOT NULL) THEN
      UPDATE WMS_RESTRICTIONS SET
       rule_id = x_rule_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
      ,parameter_id = x_parameter_id
      ,operator_code = x_operator_code
      ,operand_type_code = x_operand_type_code
      ,operand_constant_number = x_operand_constant_number
      ,operand_constant_character = x_operand_constant_character
      ,operand_constant_date = x_operand_constant_date
      ,operand_parameter_id = x_operand_parameter_id
      ,operand_expression = x_operand_expression
      ,operand_flex_value_set_id = x_operand_flex_value_set_id
      ,logical_operator_code = x_logical_operator_code
      ,bracket_open = x_bracket_open
      ,bracket_close = x_bracket_close
      ,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 rowid = x_rowid;

Line: 371

      UPDATE WMS_RESTRICTIONS SET
       rule_id = x_rule_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
      ,parameter_id = x_parameter_id
      ,operator_code = x_operator_code
      ,operand_type_code = x_operand_type_code
      ,operand_constant_number = x_operand_constant_number
      ,operand_constant_character = x_operand_constant_character
      ,operand_constant_date = x_operand_constant_date
      ,operand_parameter_id = x_operand_parameter_id
      ,operand_expression = x_operand_expression
      ,operand_flex_value_set_id = x_operand_flex_value_set_id
      ,logical_operator_code = x_logical_operator_code
      ,bracket_open = x_bracket_open
      ,bracket_close = x_bracket_close
      ,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 rule_id         = x_rule_id
   AND   sequence_number = x_sequence_number;

Line: 412

END UPDATE_ROW;

Line: 414

PROCEDURE DELETE_ROW (
	x_rowid	IN 	VARCHAR2
  )IS
BEGIN

   DELETE FROM WMS_RESTRICTIONS
   WHERE rowid = x_rowid;

Line: 425

END DELETE_ROW;

Line: 483

      SELECT Sysdate INTO l_sysdate FROM dual;

Line: 503

      wms_restrictions_pkg.update_row
	(
	  x_rowid                       => NULL
	 ,x_rule_id                     => l_rule_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_parameter_id               => l_parameter_id
	 ,x_operator_code              => l_operator_code
	 ,x_operand_type_code          => l_operand_type_code
	 ,x_operand_constant_number    => l_operand_constant_number
	 ,x_operand_constant_character  => x_operand_constant_character
	 ,x_operand_constant_date      => x_operand_constant_date
	 ,x_operand_parameter_id       => l_operand_parameter_id
	 ,x_operand_expression         => x_operand_expression
	 ,x_operand_flex_value_set_id  => l_operand_flex_value_set_id
	 ,x_logical_operator_code      => l_logical_operator_code
	 ,x_bracket_open               => x_bracket_open
	 ,x_bracket_close              => x_bracket_close
	 ,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: 542

      wms_restrictions_pkg.insert_row
	(
          x_rowid                      => l_row_id
	 ,x_rule_id                    => l_rule_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_parameter_id               => l_parameter_id
	 ,x_operator_code              => l_operator_code
	 ,x_operand_type_code          => l_operand_type_code
	 ,x_operand_constant_number    => l_operand_constant_number
	 ,x_operand_constant_character  => x_operand_constant_character
	 ,x_operand_constant_date      => x_operand_constant_date
	 ,x_operand_parameter_id       => x_operand_parameter_id
	 ,x_operand_expression         => x_operand_expression
	 ,x_operand_flex_value_set_id  => l_operand_flex_value_set_id
	 ,x_logical_operator_code      => l_logical_operator_code
	 ,x_bracket_open               => x_bracket_open
	 ,x_bracket_close              => x_bracket_close
	 ,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
	 );