APPS.IGW_SPONSOR_ACTION_TBH SQL Statements

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

Line: 10

   PROCEDURE Update_Prop_Sponsor_Action(p_proposal_id NUMBER) IS

      CURSOR cur_latest_action IS
      SELECT sponsor_action_code,
             sponsor_action_date,
             comments
      FROM   igw_prop_comments
      WHERE  proposal_id = p_proposal_id
      AND    sponsor_action_code IS NOT NULL
      ORDER BY sponsor_action_date desc, creation_date desc;

Line: 32

         UPDATE igw_proposals_all
         SET    sponsor_action_code = l_sponsor_action_code,
                sponsor_action_date = l_sponsor_action_date,
                sponsor_action_comments = l_comments
         WHERE  proposal_id = p_proposal_id;

Line: 46

   PROCEDURE Insert_Row
   (
      x_rowid              OUT NOCOPY VARCHAR2,
      p_proposal_id        IN NUMBER,
      p_comments           IN VARCHAR2,
      p_sponsor_action_code in varchar2,
      p_sponsor_action_date in date,
      x_return_status      OUT NOCOPY VARCHAR2,
      p_mode               IN VARCHAR2 default 'R'
   ) IS

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

Line: 59

      l_last_update_date  DATE         := SYSDATE;

Line: 60

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

Line: 61

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

Line: 64

      SELECT rowid
      FROM   igw_prop_comments
      WHERE  proposal_id = p_proposal_id AND
             trunc(last_update_date) = trunc(SYSDATE);

Line: 75

         l_last_updated_by := 1;

Line: 76

         l_last_update_login := 0;

Line: 85

      INSERT INTO igw_prop_comments
      (
         proposal_id,
         comment_id,
         comments,
         sponsor_action_code,
         sponsor_action_date,
         record_version_number,
         creation_date,
         created_by,
         last_update_date,
         last_updated_by,
         last_update_login
      )
      VALUES
      (
         p_proposal_id,                             /* proposal_id */
         igw_prop_comments_s.nextval,                /* comment_id */
         p_comments,                                   /* comments */
         p_sponsor_action_code,
         p_sponsor_action_date,
         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: 126

      Update_Prop_Sponsor_Action(p_proposal_id);

Line: 142

   END Insert_Row;

Line: 146

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

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

Line: 161

      l_last_update_date  DATE         := SYSDATE;

Line: 162

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

Line: 163

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

Line: 171

         l_last_updated_by := 1;

Line: 172

         l_last_update_login := 0;

Line: 182

      UPDATE igw_prop_comments
      SET    sponsor_action_code = p_sponsor_action_code,
             sponsor_action_date = p_sponsor_action_date,
             comments = p_comments,
             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) OR
              (proposal_id = p_proposal_id AND comment_id = p_comment_id))
      AND    record_version_number = p_record_version_number;

Line: 202

      Update_Prop_Sponsor_Action(p_proposal_id);

Line: 218

   END Update_Row;

Line: 222

   PROCEDURE Delete_Row
   (
      p_rowid                  IN VARCHAR2,
      p_proposal_id            IN NUMBER,
      p_record_version_number  IN NUMBER,
      x_return_status          OUT NOCOPY VARCHAR2
   ) IS

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

Line: 236

      DELETE igw_prop_comments
      WHERE  rowid = p_rowid
      AND    record_version_number = p_record_version_number;

Line: 248

      Update_Prop_Sponsor_Action(p_proposal_id);

Line: 264

   END Delete_Row;