APPS.IGW_PROP_ABSTRACTS_TBH SQL Statements

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

Line: 10

   PROCEDURE Insert_Row
   (
      x_rowid              OUT NOCOPY VARCHAR2,
      p_proposal_id        IN NUMBER,
      p_abstract_type      IN VARCHAR2,
      p_abstract_type_code 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,
      x_return_status      OUT NOCOPY VARCHAR2,
      p_mode               IN VARCHAR2 default 'R'
   ) IS

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

Line: 39

      l_last_update_date  DATE         := SYSDATE;

Line: 40

      l_last_updated_by   NUMBER       := Nvl(Fnd_Global.User_Id,-1);

Line: 41

      l_last_update_login NUMBER       := Nvl(Fnd_Global.Login_Id,-1);

Line: 44

      SELECT rowid
      FROM   igw_prop_abstracts
      WHERE  proposal_id = p_proposal_id AND
             abstract_type = p_abstract_type AND
             abstract_type_code = p_abstract_type_code;

Line: 56

         l_last_updated_by := 1;

Line: 57

         l_last_update_login := 0;

Line: 66

      INSERT INTO igw_prop_abstracts
      (
         proposal_id,
         abstract_type,
         abstract_type_code,
         abstract,
         attribute_category,
         attribute1,
         attribute2,
         attribute3,
         attribute4,
         attribute5,
         attribute6,
         attribute7,
         attribute8,
         attribute9,
         attribute10,
         attribute11,
         attribute12,
         attribute13,
         attribute14,
         attribute15,
         record_version_number,
         creation_date,
         created_by,
         last_update_date,
         last_updated_by,
         last_update_login
      )
      VALUES
      (
         p_proposal_id,                             /* proposal_id */
         p_abstract_type,                         /* abstract_type */
         p_abstract_type_code,               /* abstract_type_code */
         p_abstract,                                   /* abstract */
         p_attribute_category,               /* attribute_category */
         p_attribute1,                               /* attribute1 */
         p_attribute2,                               /* attribute2 */
         p_attribute3,                               /* attribute3 */
         p_attribute4,                               /* attribute4 */
         p_attribute5,                               /* attribute5 */
         p_attribute6,                               /* attribute6 */
         p_attribute7,                               /* attribute7 */
         p_attribute8,                               /* attribute8 */
         p_attribute9,                               /* attribute9 */
         p_attribute10,                             /* attribute10 */
         p_attribute11,                             /* attribute11 */
         p_attribute12,                             /* attribute12 */
         p_attribute13,                             /* attribute13 */
         p_attribute14,                             /* attribute14 */
         p_attribute15,                             /* attribute15 */
         1,                               /* record_version_number */
         l_last_update_date,                      /* creation_date */
         l_last_updated_by,                          /* created_by */
         l_last_update_date,                   /* last_update_date */
         l_last_updated_by,                     /* last_updated_by */
         l_last_update_login                  /* last_update_login */
      );

Line: 151

   END Insert_Row;

Line: 155

   PROCEDURE Update_Row
   (
      p_rowid                 IN VARCHAR2,
      p_proposal_id           IN NUMBER,
      p_abstract_type         IN VARCHAR2,
      p_abstract_type_code    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,
      p_mode                  IN VARCHAR2 default 'R'
   ) IS

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

Line: 185

      l_last_update_date  DATE         := SYSDATE;

Line: 186

      l_last_updated_by   NUMBER       := Nvl(Fnd_Global.User_Id,-1);

Line: 187

      l_last_update_login NUMBER       := Nvl(Fnd_Global.Login_Id,-1);

Line: 195

         l_last_updated_by := 1;

Line: 196

         l_last_update_login := 0;

Line: 206

      UPDATE igw_prop_abstracts
      SET    proposal_id = p_proposal_id,
             abstract_type = p_abstract_type,
             abstract_type_code = p_abstract_type_code,
             abstract = p_abstract,
             attribute_category = p_attribute_category,
             attribute1 = p_attribute1,
             attribute2 = p_attribute2,
             attribute3 = p_attribute3,
             attribute4 = p_attribute4,
             attribute5 = p_attribute5,
             attribute6 = p_attribute6,
             attribute7 = p_attribute7,
             attribute8 = p_attribute8,
             attribute9 = p_attribute9,
             attribute10 = p_attribute10,
             attribute11 = p_attribute11,
             attribute12 = p_attribute12,
             attribute13 = p_attribute13,
             attribute14 = p_attribute14,
             attribute15 = p_attribute15,
             record_version_number = record_version_number + 1,
             last_update_date = l_last_update_date,
             last_updated_by = l_last_updated_by,
             last_update_login = l_last_update_login
      WHERE  rowid = p_rowid
      AND    record_version_number = p_record_version_number;

Line: 256

   END Update_Row;