APPS.IGW_PROP_QUESTIONS_PVT SQL Statements

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

Line: 31

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

Line: 81

      SELECT
         explanation_for_yes_flag,
         explanation_for_no_flag,
         date_for_yes_flag,
         date_for_no_flag
      INTO
         l_explanation_for_yes_flag,
         l_explanation_for_no_flag,
         l_date_for_yes_flag,
         l_date_for_no_flag
      FROM
         igw_questions
      WHERE
         question_number = p_question_number;

Line: 149

      INSERT INTO igw_prop_questions
      (
         proposal_id,
         question_number,
         answer,
         last_update_date,
         last_updated_by,
         creation_date,
         created_by,
         last_update_login,
         record_version_number
      )
      SELECT
         p_proposal_id,
         question_number,
         '3',
         SYSDATE,
         Fnd_Global.User_Id,
         SYSDATE,
         Fnd_Global.User_Id,
         Fnd_Global.Login_Id,
         1
      FROM
         igw_questions
      WHERE
         applies_to = 'P' AND
         SYSDATE >= start_date_active AND
         (SYSDATE <= end_date_active OR end_date_active IS NULL) AND
         question_number NOT IN
            ( SELECT question_number
              FROM   igw_prop_questions
              WHERE  proposal_id = p_proposal_id );

Line: 188

   PROCEDURE Update_Prop_Question
   (
      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_record_version_number IN NUMBER,
      p_proposal_id           IN NUMBER,
      p_proposal_number       IN VARCHAR2,
      p_question_number       IN VARCHAR2,
      p_answer                IN VARCHAR2,
      p_explanation           IN VARCHAR2,
      p_review_date           IN DATE,
      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_Question';

Line: 218

      SAVEPOINT Update_Prop_Question_Pvt;

Line: 326

      **   Invoke Table Handler to Update data
      */

      Igw_Prop_Questions_Tbh.Update_Row
      (
         p_rowid                 => p_rowid,
         p_record_version_number => p_record_version_number,
         p_proposal_id           => l_proposal_id,
         p_question_number       => p_question_number,
         p_answer                => p_answer,
         p_explanation           => p_explanation,
         p_review_date           => p_review_date,
         x_return_status         => l_return_status
      );

Line: 357

         ROLLBACK TO Update_Prop_Question_Pvt;

Line: 369

         ROLLBACK TO Update_Prop_Question_Pvt;

Line: 381

         ROLLBACK TO Update_Prop_Question_Pvt;

Line: 397

   END Update_Prop_Question;