APPS.IGW_PROP_ABSTRACTS_PUB SQL Statements

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

Line: 116

      SELECT rowid,
             record_version_number
      INTO   l_rowid,
             l_record_version_number
      FROM   igw_prop_abstracts
      WHERE  proposal_id = l_proposal_id
      AND    abstract_type = 'IGW_ABSTRACT_TYPES'
      AND    abstract_type_code = l_abstract_type_code;

Line: 125

      Igw_Prop_Abstracts_Pvt.Update_Prop_Abstract
      (
         p_init_msg_list         => Fnd_Api.G_True,
         p_validate_only         => p_validate_only,
         p_commit                => Fnd_Api.G_False,
         p_rowid                 => l_rowid,
         p_proposal_id           => l_proposal_id,
         p_proposal_number       => null,
         p_abstract_type         => 'IGW_ABSTRACT_TYPES',
         p_abstract_type_code    => l_abstract_type_code,
         p_abstract_type_desc    => p_abstract_type_desc,
         p_abstract              => p_abstract,
         p_attribute_category    => null,
         p_attribute1            => null,
         p_attribute2            => null,
         p_attribute3            => null,
         p_attribute4            => null,
         p_attribute5            => null,
         p_attribute6            => null,
         p_attribute7            => null,
         p_attribute8            => null,
         p_attribute9            => null,
         p_attribute10           => null,
         p_attribute11           => null,
         p_attribute12           => null,
         p_attribute13           => null,
         p_attribute14           => null,
         p_attribute15           => null,
         p_record_version_number => l_record_version_number,
         x_return_status         => x_return_status,
         x_msg_count             => x_msg_count,
         x_msg_data              => x_msg_data
      );