APPS.IGW_PROP_QUESTIONS_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_question_number    IN VARCHAR2,
      p_answer             IN VARCHAR2,
      p_explanation        IN VARCHAR2,
      p_review_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: 24

      l_last_update_date  DATE         := SYSDATE;

Line: 25

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

Line: 26

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

Line: 29

      SELECT rowid
      FROM   igw_prop_questions
      WHERE  proposal_id = p_proposal_id AND
             question_number = p_question_number;

Line: 40

         l_last_updated_by := 1;

Line: 41

         l_last_update_login := 0;

Line: 50

      INSERT INTO igw_prop_questions
      (
         proposal_id,
         question_number,
         answer,
         explanation,
         review_date,
         record_version_number,
         creation_date,
         created_by,
         last_update_date,
         last_updated_by,
         last_update_login
      )
      VALUES
      (
         p_proposal_id,                             /* proposal_id */
         p_question_number,                     /* question_number */
         p_answer,                                       /* answer */
         p_explanation,                             /* explanation */
         p_review_date,                             /* review_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: 105

   END Insert_Row;

Line: 109

   PROCEDURE Update_Row
   (
      p_rowid                 IN VARCHAR2,
      p_record_version_number IN NUMBER,
      p_proposal_id           IN NUMBER,
      p_question_number       IN VARCHAR2,
      p_answer                IN VARCHAR2,
      p_explanation           IN VARCHAR2,
      p_review_date           IN DATE,
      x_return_status         OUT NOCOPY VARCHAR2,
      p_mode                  IN VARCHAR2 default 'R'
   ) IS

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

Line: 124

      l_last_update_date  DATE         := SYSDATE;

Line: 125

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

Line: 126

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

Line: 134

         l_last_updated_by := 1;

Line: 135

         l_last_update_login := 0;

Line: 145

      UPDATE igw_prop_questions
      SET    question_number = p_question_number,
             answer = p_answer,
             explanation = p_explanation,
             review_date = p_review_date,
             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: 179

   END Update_Row;