APPS.IGW_PROP_ABSTRACTS_PVT SQL Statements

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

Line: 31

         SELECT 'N'
         INTO   l_locked
         FROM   igw_prop_abstracts
         WHERE  rowid = p_rowid
         AND    record_version_number  = p_record_version_number;

Line: 66

      INSERT INTO igw_prop_abstracts
      (
         proposal_id,
         abstract_type,
         abstract_type_code,
         last_update_date,
         last_updated_by,
         creation_date,
         created_by,
         last_update_login,
         record_version_number
      )
      SELECT
         p_proposal_id,
         lookup_type,
         lookup_code,
         null,
         null,
         SYSDATE,
         Fnd_Global.User_Id,
         Fnd_Global.Login_Id,
         1
      FROM
         fnd_lookups
      WHERE
         lookup_type in ('IGW_ABSTRACT_TYPES','IGW_RESOURCE_TYPES') AND
         (lookup_type,lookup_code) NOT IN
            ( SELECT abstract_type,
                     abstract_type_code
              FROM   igw_prop_abstracts
              WHERE  proposal_id = p_proposal_id );

Line: 104

   PROCEDURE Update_Prop_Abstract
   (
      p_init_msg_list         IN VARCHAR2,
      p_validate_only         IN VARCHAR2,
      p_commit                IN VARCHAR2,
      p_rowid                 IN VARCHAR2,
      p_proposal_id           IN NUMBER,
      p_proposal_number       IN VARCHAR2,
      p_abstract_type         IN VARCHAR2,
      p_abstract_type_code    IN VARCHAR2,
      p_abstract_type_desc    IN VARCHAR2,
      p_abstract              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_record_version_number IN NUMBER,
      x_return_status         OUT NOCOPY VARCHAR2,
      x_msg_count             OUT NOCOPY NUMBER,
      x_msg_data              OUT NOCOPY VARCHAR2
   ) IS

      l_api_name      CONSTANT VARCHAR2(30) := 'Update_Prop_Abstract';

Line: 151

      SAVEPOINT Update_Prop_Abstract_Pvt;

Line: 289

      **   Invoke Table Handler to Update data
      */

      Igw_Prop_Abstracts_Tbh.Update_Row
      (
         p_rowid                 => p_rowid,
         p_proposal_id           => l_proposal_id,
         p_abstract_type         => p_abstract_type,
         p_abstract_type_code    => l_abstract_type_code,
         p_abstract              => p_abstract,
         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_record_version_number => p_record_version_number,
         x_return_status         => l_return_status
      );

Line: 335

         ROLLBACK TO Update_Prop_Abstract_Pvt;

Line: 347

         ROLLBACK TO Update_Prop_Abstract_Pvt;

Line: 359

         ROLLBACK TO Update_Prop_Abstract_Pvt;

Line: 375

   END Update_Prop_Abstract;