APPS.IGW_SPONSOR_ACTION_PVT SQL Statements

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

Line: 31

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

Line: 156

      **   Invoke Table Handler to insert data
      */

      Igw_Sponsor_Action_Tbh.Insert_Row
      (
         x_rowid                  => x_rowid,
         p_proposal_id            => l_proposal_id,
         p_comments               => p_comments,
         p_sponsor_action_code    => p_sponsor_action_code,
         p_sponsor_action_date    => p_sponsor_action_date,
         x_return_status          => l_return_status
      );

Line: 229

   PROCEDURE Update_Sponsor_Action
   (
      p_init_msg_list         IN VARCHAR2   := Fnd_Api.G_False,
      p_validate_only         IN VARCHAR2   := Fnd_Api.G_False,
      p_commit                IN VARCHAR2   := Fnd_Api.G_False,
      p_rowid                 IN VARCHAR2,
      p_proposal_id           IN NUMBER,
      p_proposal_number       IN VARCHAR2,
      p_comment_id            IN NUMBER,
      p_comments              IN VARCHAR2,
      p_sponsor_action_code    IN VARCHAR2,
      p_sponsor_action_date    IN DATE,
      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_Sponsor_Action';

Line: 259

      SAVEPOINT UPDATE_SPONSOR_ACTION_PVT;

Line: 372

      **   Invoke Table Handler to Update data
      */

      Igw_Sponsor_Action_Tbh.Update_Row
      (
         p_rowid                 => p_rowid,
         p_proposal_id           => l_proposal_id,
         p_comment_id            => p_comment_id,
         p_comments              => p_comments,
         p_sponsor_action_code   => p_sponsor_action_code,
         p_sponsor_action_date   => p_sponsor_action_date,
         p_record_version_number => p_record_version_number,
         x_return_status         => x_return_status
      );

Line: 403

         ROLLBACK TO UPDATE_SPONSOR_ACTION_PVT;

Line: 415

         ROLLBACK TO UPDATE_SPONSOR_ACTION_PVT;

Line: 427

         ROLLBACK TO UPDATE_SPONSOR_ACTION_PVT;

Line: 443

   END Update_Sponsor_Action;

Line: 447

   PROCEDURE Delete_Sponsor_Action
   (
      p_init_msg_list         IN VARCHAR2   := Fnd_Api.G_False,
      p_validate_only         IN VARCHAR2   := Fnd_Api.G_False,
      p_commit                IN VARCHAR2   := Fnd_Api.G_False,
      p_rowid                 IN VARCHAR2,
      p_proposal_id           IN NUMBER,
      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) := 'Delete_Sponsor_Action';

Line: 470

      SAVEPOINT DELETE_SPONSOR_ACTION_PVT;

Line: 542

      **   Invoke Table Handler to Delete data
      */

      Igw_Sponsor_Action_Tbh.Delete_Row
      (
         p_rowid                  => p_rowid,
         p_proposal_id            => p_proposal_id,
         p_record_version_number  => p_record_version_number,
         x_return_status          => x_return_status
      );

Line: 569

         ROLLBACK TO DELETE_SPONSOR_ACTION_PVT;

Line: 581

         ROLLBACK TO DELETE_SPONSOR_ACTION_PVT;

Line: 593

         ROLLBACK TO DELETE_SPONSOR_ACTION_PVT;

Line: 609

   END Delete_Sponsor_Action;