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_RULE_FORM_PKG SQL Statements

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

Line: 12


      CURSOR c IS SELECT rule_id FROM wms_rules_b
	WHERE rule_id = p_rule_id;

Line: 59


   IF p_action NOT IN ('INSERT', 'UPDATE', 'LOCK', 'DELETE') THEN
      -- unknown exception
      RAISE fnd_api.g_exc_unexpected_error;

Line: 65


   IF p_action IN ('DELETE','LOCK','UPDATE') THEN
      IF check_existence(p_rule_id) THEN
	 fnd_message.set_name('WMS', 'WMS_RULE_NOT_FOUND');

Line: 73


   /* more input validation update and insert */
   IF p_action IN ('UPDATE', 'INSERT') THEN
      /* check foreign keys */
      /* check organization id here by calling api */

      /* validate enabled_flag */
      IF p_enabled_flag NOT IN ('Y', 'N') THEN
	 fnd_message.set_name('WMS', 'WMS_INVALID_ENABLED_FLAG');

Line: 111


   /* delete is not allowed */
--    IF p_action = 'DELETE' THEN
--       IF wms_strategy_form_pkg.rule_in_used(rule_id) THEN
-- 	 fnd_message.set_name('WMS','WMS_RULE_IN_USE');

Line: 133


procedure insert_rule
  (
    x_return_status       	out NOCOPY varchar2
   ,x_msg_count           	out NOCOPY number
   ,x_msg_data            	out NOCOPY varchar2
   ,x_rule_id 			out NOCOPY NUMBER
   , p_api_version         	in  number
   ,p_organization_id 		in  NUMBER
   ,p_type_code 		in  NUMBER
   ,p_qty_function_parameter_id in  NUMBER
   ,p_enabled_flag 		in  VARCHAR2
   ,p_user_defined_flag 	in  VARCHAR2
   ,p_min_pick_tasks_flag       in  VARCHAR2
   ,p_attribute_category 	in  VARCHAR2
   ,p_attribute1 		in  VARCHAR2
   ,p_attribute2  		in  VARCHAR2
   ,p_attribute3 		in  VARCHAR2
   ,p_attribute4 		in  VARCHAR2
   ,p_attribute5 		in  VARCHAR2
   ,p_attribute6 		in  VARCHAR2
   ,p_attribute7 		in  VARCHAR2
   ,p_attribute8 		in  VARCHAR2
   ,p_attribute9 		in  VARCHAR2
   ,p_attribute10 		in  VARCHAR2
   ,p_attribute11 		in  VARCHAR2
   ,p_attribute12 		in  VARCHAR2
   ,p_attribute13 		in  VARCHAR2
   ,p_attribute14 		in  VARCHAR2
   ,p_attribute15 		in  VARCHAR2
   ,p_name 		        in  VARCHAR2
   ,p_description 		in  VARCHAR2
   ,p_type_header_id            in  NUMBER
   ,p_rule_weight               in  NUMBER
   ,p_init_msg_list       	in  varchar2 DEFAULT fnd_api.g_false
   ,p_validation_level    	in  number   DEFAULT fnd_api.g_valid_level_full
   ,p_allocation_mode_id    in number
  ) IS
     -- API standard variables
     l_api_version         constant number       := 1.0;

Line: 172


     l_api_name            constant varchar2(30) := 'Insert_Rule';

Line: 195


  SELECT wms_rules_s.NEXTVAL INTO l_rule_id FROM dual;

Line: 200


   ,p_action                    => 'INSERT'
   ,p_rule_id 			=> l_rule_id
   ,p_organization_id 		=> p_organization_id
   ,p_type_code 		=> p_type_code
   ,p_qty_function_parameter_id => p_qty_function_parameter_id
   ,p_enabled_flag 		=> p_enabled_flag
   ,p_user_defined_flag 	=> p_user_defined_flag
   ,p_attribute_category 	=> p_attribute_category
   ,p_attribute1 		=> p_attribute1
   ,p_attribute2  		=> p_attribute2
   ,p_attribute3 		=> p_attribute3
   ,p_attribute4 		=> p_attribute4
   ,p_attribute5 		=> p_attribute5
   ,p_attribute6 		=> p_attribute6
   ,p_attribute7 		=> p_attribute7
   ,p_attribute8 		=> p_attribute8
   ,p_attribute9 		=> p_attribute9
   ,p_attribute10 		=> p_attribute10
   ,p_attribute11 		=> p_attribute11
   ,p_attribute12 		=> p_attribute12
   ,p_attribute13 		=> p_attribute13
   ,p_attribute14 		=> p_attribute14
   ,p_attribute15 		=> p_attribute15
   ,p_name 		        => p_name
   ,p_description 		=> p_description
    ,p_allocation_mode_id => p_allocation_mode_id
    );

Line: 235


   SELECT Sysdate INTO l_date FROM dual;

Line: 239


   /* call the table handler to do the insert */
   wms_rules_pkg.insert_row
     (
       x_rowid 			      => l_row_id
      ,x_rule_id 		      => l_rule_id
      ,x_organization_id 	      => p_organization_id
      ,x_type_code 		      => p_type_code
      ,x_qty_function_parameter_id    => p_qty_function_parameter_id
      ,x_enabled_flag 		      => p_enabled_flag
      ,x_user_defined_flag 	      => p_user_defined_flag
      ,x_min_pick_tasks_flag 	      => p_min_pick_tasks_flag
      ,x_attribute_category 	      => p_attribute_category
      ,x_attribute1 		      => p_attribute1
      ,x_attribute2 		      => p_attribute2
      ,x_attribute3 		      => p_attribute3
      ,x_attribute4 		      => p_attribute4
      ,x_attribute5 		      => p_attribute5
      ,x_attribute6 		      => p_attribute6
      ,x_attribute7 		      => p_attribute7
      ,x_attribute8 		      => p_attribute8
      ,x_attribute9 		      => p_attribute9
      ,x_attribute10 		      => p_attribute10
      ,x_attribute11 		      => p_attribute11
      ,x_attribute12 		      => p_attribute12
      ,x_attribute13 		      => p_attribute13
      ,x_attribute14 		      => p_attribute14
      ,x_attribute15 		      => p_attribute15
      ,x_name 		              => p_name
      ,x_description 		      => p_description
      ,x_creation_date 		      => l_date
      ,x_created_by 		      => l_user_id
      ,x_last_update_date 	      => l_date
      ,x_last_updated_by 	      => l_user_id
      ,x_last_update_login 	      => l_login_id
      ,x_type_header_id               => p_type_header_id
      ,x_rule_weight                  => p_rule_weight
      ,x_allocation_mode_id       => p_allocation_mode_id
      );

Line: 300


end insert_rule;

Line: 443


procedure update_rule (
  x_return_status             out NOCOPY VARCHAR2,
  x_msg_count                 out NOCOPY NUMBER,
  x_msg_data                  out NOCOPY VARCHAR2,
  p_api_version               in  NUMBER,
  p_rule_id           	      in NUMBER,
  p_organization_id   	      in NUMBER,
  p_type_code         	      in NUMBER,
  p_qty_function_parameter_id in NUMBER,
  p_enabled_flag              in VARCHAR2,
  p_user_defined_flag         in VARCHAR2,
  p_min_pick_tasks_flag       in VARCHAR2,
  p_attribute_category        in VARCHAR2,
  p_attribute1 		      in VARCHAR2,
  p_attribute2 		      in VARCHAR2,
  p_attribute3  	      in VARCHAR2,
  p_attribute4 		      in VARCHAR2,
  p_attribute5 		      in VARCHAR2,
  p_attribute6 		      in VARCHAR2,
  p_attribute7 		      in VARCHAR2,
  p_attribute8 		      in VARCHAR2,
  p_attribute9 		      in VARCHAR2,
  p_attribute10 	      in VARCHAR2,
  p_attribute11       	      in VARCHAR2,
  p_attribute12       	      in VARCHAR2,
  p_attribute13 	      in VARCHAR2,
  p_attribute14 	      in VARCHAR2,
  p_attribute15 	      in VARCHAR2,
  p_name                      in VARCHAR2,
  p_description               in VARCHAR2,
  p_type_header_id            in  NUMBER,
  p_rule_weight               in  NUMBER,
  p_last_update_date          in DATE,
  p_last_updated_by           in NUMBER,
  p_last_update_login         in NUMBER,
  p_init_msg_list             in  varchar2 DEFAULT fnd_api.g_false,
  p_validation_level          in  number   DEFAULT fnd_api.g_valid_level_full
 ,p_allocation_mode_id    in number
) is
     -- API standard variables
     l_api_version         constant number       := 1.0;

Line: 484


     l_api_name            constant varchar2(30) := 'Update_Rule';

Line: 508


   ,p_action                    => 'UPDATE'
   ,p_rule_id 			=> p_rule_id
   ,p_organization_id 		=> p_organization_id
   ,p_type_code 		=> p_type_code
   ,p_qty_function_parameter_id => p_qty_function_parameter_id
   ,p_enabled_flag 		=> p_enabled_flag
   ,p_user_defined_flag 	=> p_user_defined_flag
   ,p_attribute_category 	=> p_attribute_category
   ,p_attribute1 		=> p_attribute1
   ,p_attribute2  		=> p_attribute2
   ,p_attribute3 		=> p_attribute3
   ,p_attribute4 		=> p_attribute4
   ,p_attribute5 		=> p_attribute5
   ,p_attribute6 		=> p_attribute6
   ,p_attribute7 		=> p_attribute7
   ,p_attribute8 		=> p_attribute8
   ,p_attribute9 		=> p_attribute9
   ,p_attribute10 		=> p_attribute10
   ,p_attribute11 		=> p_attribute11
   ,p_attribute12 		=> p_attribute12
   ,p_attribute13 		=> p_attribute13
   ,p_attribute14 		=> p_attribute14
   ,p_attribute15 		=> p_attribute15
   ,p_name 		        => p_name
   ,p_description 		=> p_description
   ,p_allocation_mode_id => p_allocation_mode_id
    );

Line: 543


   SELECT Sysdate INTO l_date FROM dual;

Line: 547


   /* call the table handler to do the update */
   wms_rules_pkg.update_row
     (
       x_rule_id 		      => p_rule_id
      ,x_organization_id 	      => p_organization_id
      ,x_type_code 		      => p_type_code
      ,x_qty_function_parameter_id    => p_qty_function_parameter_id
      ,x_enabled_flag 		      => p_enabled_flag
      ,x_user_defined_flag 	      => p_user_defined_flag
      ,x_min_pick_tasks_flag 	      => p_min_pick_tasks_flag
      ,x_attribute_category 	      => p_attribute_category
      ,x_attribute1 		      => p_attribute1
      ,x_attribute2 		      => p_attribute2
      ,x_attribute3 		      => p_attribute3
      ,x_attribute4 		      => p_attribute4
      ,x_attribute5 		      => p_attribute5
      ,x_attribute6 		      => p_attribute6
      ,x_attribute7 		      => p_attribute7
      ,x_attribute8 		      => p_attribute8
      ,x_attribute9 		      => p_attribute9
      ,x_attribute10 		      => p_attribute10
      ,x_attribute11 		      => p_attribute11
      ,x_attribute12 		      => p_attribute12
      ,x_attribute13 		      => p_attribute13
      ,x_attribute14 		      => p_attribute14
      ,x_attribute15 		      => p_attribute15
      ,x_name 		              => p_name
      ,x_description 		      => p_description
      ,x_last_update_date 	      => l_date
      ,x_last_updated_by 	      => l_user_id
      ,x_last_update_login 	      => l_login_id
      ,x_type_header_id               => p_type_header_id
      ,x_rule_weight                  => p_rule_weight
      ,x_allocation_mode_id       => p_allocation_mode_id
      );

Line: 604


end update_rule ;

Line: 621


     SELECT	'Y'
       FROM wms_rules_b
       WHERE rule_id = p_rule_id;

Line: 671


procedure delete_rule (
  x_return_status             out NOCOPY VARCHAR2,
  x_msg_count                 out NOCOPY NUMBER,
  x_msg_data                  out NOCOPY VARCHAR2,
  p_rule_id                   IN  NUMBER,
  p_api_version               in  NUMBER,
  p_init_msg_list             in  varchar2 DEFAULT fnd_api.g_false,
  p_validation_level          in  number   DEFAULT fnd_api.g_valid_level_full
) is
     -- API standard variables
     l_api_version         constant number       := 1.0;

Line: 682


     l_api_name            constant varchar2(30) := 'Delete_Rule';

Line: 699


   SAVEPOINT delete_rule_sa;

Line: 704


      ,p_action                    => 'DELETE'
      ,p_rule_id 		           => p_rule_id
      ,p_organization_id           => fnd_api.g_miss_num
      ,p_type_code                 => fnd_api.g_miss_num
      ,p_qty_function_parameter_id => fnd_api.g_miss_num
      ,p_enabled_flag              => fnd_api.g_miss_char
      ,p_user_defined_flag         => fnd_api.g_miss_char
      ,p_attribute_category        => fnd_api.g_miss_char
      ,p_attribute1                => fnd_api.g_miss_char
      ,p_attribute2                => fnd_api.g_miss_char
      ,p_attribute3                => fnd_api.g_miss_char
      ,p_attribute4                => fnd_api.g_miss_char
      ,p_attribute5                => fnd_api.g_miss_char
      ,p_attribute6                => fnd_api.g_miss_char
      ,p_attribute7                => fnd_api.g_miss_char
      ,p_attribute8                => fnd_api.g_miss_char
      ,p_attribute9                => fnd_api.g_miss_char
      ,p_attribute10               => fnd_api.g_miss_char
      ,p_attribute11               => fnd_api.g_miss_char
      ,p_attribute12               => fnd_api.g_miss_char
      ,p_attribute13               => fnd_api.g_miss_char
      ,p_attribute14               => fnd_api.g_miss_char
      ,p_attribute15               => fnd_api.g_miss_char
      ,p_name                      => fnd_api.g_miss_char
      ,p_description               => fnd_api.g_miss_char
      ,p_allocation_mode_id        => fnd_api.g_miss_num
      );

Line: 739


   /* we want to delete all restrictions and sort criteria records that tie to */
   /* this rule */
   wms_restriction_form_pkg.delete_restrictions(p_rule_id);

Line: 742


   /* wms_sort_criteria_form_pkg.delete_sort_criteria(p_rule_id); */

Line: 743


   wms_rules_pkg.delete_row(p_rule_id);

Line: 749


      ROLLBACK TO delete_rule_sa;

Line: 755


      ROLLBACK TO delete_rule_sa;

Line: 761


      ROLLBACK TO delete_rule_sa;

Line: 769


end delete_rule ;

Line: 799


     SELECT
        organization_id
       ,rule_id
       ,type_code
       ,qty_function_parameter_id
       ,enabled_flag
       ,user_defined_flag
       ,min_pick_tasks_flag
       ,attribute_category
       ,attribute1
       ,attribute2
       ,attribute3
       ,attribute4
       ,attribute5
       ,attribute6
       ,attribute7
       ,attribute8
       ,attribute9
       ,attribute10
       ,attribute11
       ,attribute12
       ,attribute13
       ,attribute14
       ,attribute15
       ,name
       ,description
       ,TYPE_HDR_ID
       ,RULE_WEIGHT
       ,allocation_mode_id
       FROM  wms_rules
       WHERE rule_id         = p_orig_rule_id;

Line: 834


	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 rule_id         = p_orig_rule_id;

Line: 871


	SELECT
	  rule_id
	  ,sequence_number
	  ,parameter_id
	  ,order_code
	  ,attribute_category
	  ,attribute1
	  ,attribute2
	  ,attribute3
	  ,attribute4
	  ,attribute5
	  ,attribute6
	  ,attribute7
	  ,attribute8
	  ,attribute9
	  ,attribute10
	  ,attribute11
	  ,attribute12
	  ,attribute13
	  ,attribute14
	  ,attribute15
	  FROM  wms_sort_criteria
	  WHERE rule_id         = p_orig_rule_id;

Line: 899


	SELECT
	  rule_id
	  ,consistency_id
     ,parameter_id
	  ,attribute_category
	  ,attribute1
	  ,attribute2
	  ,attribute3
	  ,attribute4
	  ,attribute5
	  ,attribute6
	  ,attribute7
	  ,attribute8
	  ,attribute9
	  ,attribute10
	  ,attribute11
	  ,attribute12
	  ,attribute13
	  ,attribute14
	  ,attribute15
	  FROM  wms_rule_consistencies
	  WHERE rule_id         = p_orig_rule_id;

Line: 961


   wms_rule_form_pkg.insert_rule
     (
       x_return_status       	    => l_return_status
      ,x_msg_count           	    => x_msg_count
      ,x_msg_data            	    => x_msg_data
      ,x_rule_id 		    => l_rule_id
      , p_api_version         	    => 1.0
      ,p_organization_id 	    => l_rule_rec.organization_id
      ,p_type_code 		    => l_rule_rec.type_code
      ,p_qty_function_parameter_id  => l_rule_rec.qty_function_parameter_id
      ,p_enabled_flag 		    => l_rule_rec.enabled_flag
      ,p_user_defined_flag 	    => l_rule_rec.user_defined_flag
      ,p_min_pick_tasks_flag 	    => l_rule_rec.min_pick_tasks_flag
      ,p_attribute_category 	    => l_rule_rec.attribute_category
      ,p_attribute1 		    => l_rule_rec.attribute1
      ,p_attribute2  		    => l_rule_rec.attribute2
      ,p_attribute3 		    => l_rule_rec.attribute3
      ,p_attribute4 		    => l_rule_rec.attribute4
      ,p_attribute5 		    => l_rule_rec.attribute5
      ,p_attribute6 		    => l_rule_rec.attribute6
      ,p_attribute7 		    => l_rule_rec.attribute7
      ,p_attribute8 		    => l_rule_rec.attribute8
      ,p_attribute9 		    => l_rule_rec.attribute9
      ,p_attribute10 		    => l_rule_rec.attribute10
      ,p_attribute11 		    => l_rule_rec.attribute11
      ,p_attribute12 		    => l_rule_rec.attribute12
      ,p_attribute13 		    => l_rule_rec.attribute13
      ,p_attribute14 		    => l_rule_rec.attribute14
      ,p_attribute15 		    => l_rule_rec.attribute15
      ,p_name 		            => l_rule_rec.name
      ,p_description 		    => l_rule_rec.description
      ,p_type_header_id            =>  l_rule_rec.type_hdr_id
      ,p_rule_weight               =>  l_rule_rec.rule_weight
      ,p_init_msg_list       	    => fnd_api.g_false
      ,p_validation_level    	    => fnd_api.g_valid_level_full
      ,p_allocation_mode_id         => l_rule_rec.allocation_mode_id
      );

Line: 1016


	 wms_restriction_form_pkg.insert_restriction
	   (
      	      p_api_version         	   => 1.0
      	     ,p_init_msg_list       	   => fnd_api.g_false
      	     ,p_validation_level    	   => fnd_api.g_valid_level_full
      	     ,x_return_status       	   => l_return_status
      	     ,x_msg_count           	   => x_msg_count
      	     ,x_msg_data            	   => x_msg_data
             ,p_rowid                      => l_rowid
      	     ,p_rule_id                    => l_restriction_rec.rule_id
      	     ,p_sequence_number            => l_restriction_rec.sequence_number
      	     ,p_parameter_id               => l_restriction_rec.parameter_id
      	     ,p_operator_code              => l_restriction_rec.operator_code
      	     ,p_operand_type_code          => l_restriction_rec.operand_type_code
      	     ,p_operand_constant_number    => l_restriction_rec.operand_constant_number
      	     ,p_operand_constant_character => l_restriction_rec.operand_constant_character
      	     ,p_operand_constant_date      => l_restriction_rec.operand_constant_date
      	     ,p_operand_parameter_id       => l_restriction_rec.operand_parameter_id
      	     ,p_operand_expression         => l_restriction_rec.operand_expression
      	     ,p_operand_flex_value_set_id  => l_restriction_rec.operand_flex_value_set_id
      	     ,p_logical_operator_code      => l_restriction_rec.logical_operator_code
      	     ,p_bracket_open               => l_restriction_rec.bracket_open
      	     ,p_bracket_close              => l_restriction_rec.bracket_close
      	     ,p_attribute_category         => l_restriction_rec.attribute_category
      	     ,p_attribute1                 => l_restriction_rec.attribute1
      	     ,p_attribute2                 => l_restriction_rec.attribute2
      	     ,p_attribute3                 => l_restriction_rec.attribute3
      	     ,p_attribute4                 => l_restriction_rec.attribute4
      	     ,p_attribute5                 => l_restriction_rec.attribute5
      	     ,p_attribute6                 => l_restriction_rec.attribute6
      	     ,p_attribute7                 => l_restriction_rec.attribute7
      	     ,p_attribute8                 => l_restriction_rec.attribute8
      	     ,p_attribute9                 => l_restriction_rec.attribute9
      	     ,p_attribute10                => l_restriction_rec.attribute10
      	     ,p_attribute11                => l_restriction_rec.attribute11
      	     ,p_attribute12                => l_restriction_rec.attribute12
      	     ,p_attribute13                => l_restriction_rec.attribute13
      	     ,p_attribute14                => l_restriction_rec.attribute14
      	     ,p_attribute15                => l_restriction_rec.attribute15
	   );

Line: 1074


	 wms_sort_criteria_form_pkg.insert_sort_criteria
	   (
      	      p_api_version         	   => 1.0
      	     ,p_init_msg_list       	   => fnd_api.g_false
      	     ,p_validation_level    	   => fnd_api.g_valid_level_full
      	     ,x_return_status       	   => l_return_status
      	     ,x_msg_count           	   => x_msg_count
      	     ,x_msg_data            	   => x_msg_data
             ,p_rowid                      => l_rowid
      	     ,p_rule_id                    => l_sort_rec.rule_id
      	     ,p_sequence_number            => l_sort_rec.sequence_number
	     ,p_parameter_id               => l_sort_rec.parameter_id
	     ,p_order_code                 => l_sort_rec.order_code
      	     ,p_attribute_category         => l_sort_rec.attribute_category
      	     ,p_attribute1                 => l_sort_rec.attribute1
      	     ,p_attribute2                 => l_sort_rec.attribute2
      	     ,p_attribute3                 => l_sort_rec.attribute3
      	     ,p_attribute4                 => l_sort_rec.attribute4
      	     ,p_attribute5                 => l_sort_rec.attribute5
      	     ,p_attribute6                 => l_sort_rec.attribute6
      	     ,p_attribute7                 => l_sort_rec.attribute7
      	     ,p_attribute8                 => l_sort_rec.attribute8
      	     ,p_attribute9                 => l_sort_rec.attribute9
      	     ,p_attribute10                => l_sort_rec.attribute10
      	     ,p_attribute11                => l_sort_rec.attribute11
      	     ,p_attribute12                => l_sort_rec.attribute12
      	     ,p_attribute13                => l_sort_rec.attribute13
      	     ,p_attribute14                => l_sort_rec.attribute14
      	     ,p_attribute15                => l_sort_rec.attribute15
	   );

Line: 1117


      SELECT SYSDATE INTO l_date FROM dual;

Line: 1124


    SELECT wms_rule_consistencies_s.NEXTVAL INTO l_consistency_id FROM dual;

Line: 1125


	 wms_rule_consistencies_pkg.insert_row
	   (
               x_rowid                      => l_rowid
              ,x_consistency_id             => l_consistency_id
      	     ,x_rule_id                    => l_consistency_rec.rule_id
              ,x_parameter_id               => l_consistency_rec.parameter_id
              ,x_creation_date              => l_date
              ,x_created_by                 => fnd_global.user_id
              ,x_last_update_date           => l_date
              ,x_last_updated_by            => fnd_global.user_id
              ,x_last_update_login          => fnd_global.login_id
      	     ,x_attribute_category         => l_consistency_rec.attribute_category
      	     ,x_attribute1                 => l_consistency_rec.attribute1
      	     ,x_attribute2                 => l_consistency_rec.attribute2
      	     ,x_attribute3                 => l_consistency_rec.attribute3
      	     ,x_attribute4                 => l_consistency_rec.attribute4
      	     ,x_attribute5                 => l_consistency_rec.attribute5
      	     ,x_attribute6                 => l_consistency_rec.attribute6
      	     ,x_attribute7                 => l_consistency_rec.attribute7
      	     ,x_attribute8                 => l_consistency_rec.attribute8
      	     ,x_attribute9                 => l_consistency_rec.attribute9
      	     ,x_attribute10                => l_consistency_rec.attribute10
      	     ,x_attribute11                => l_consistency_rec.attribute11
      	     ,x_attribute12                => l_consistency_rec.attribute12
      	     ,x_attribute13                => l_consistency_rec.attribute13
      	     ,x_attribute14                => l_consistency_rec.attribute14
      	     ,x_attribute15                => l_consistency_rec.attribute15
	   );

Line: 1232


    select 1
     into  l_exist
      from wms_rules_b
     where type_hdr_id = p_std_operation_id
       and type_code = 3
       and rownum < 2 ;