APPS.IGW_PROP_SCIENCE_CODES_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_science_code   IN VARCHAR2,
      x_return_status  OUT NOCOPY VARCHAR2,
      p_mode           IN  VARCHAR2
   ) IS

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

Line: 21

      l_last_update_date  DATE         := SYSDATE;

Line: 22

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

Line: 23

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

Line: 26

      SELECT rowid
      FROM   igw_prop_science_codes
      WHERE  proposal_id = p_proposal_id AND
             science_code = p_science_code;

Line: 37

         l_last_updated_by := 1;

Line: 38

         l_last_update_login := 0;

Line: 47

      INSERT INTO igw_prop_science_codes
      (
         proposal_id,
         science_code,
         record_version_number,
         creation_date,
         created_by,
         last_update_date,
         last_updated_by,
         last_update_login
      )
      VALUES
      (
         p_proposal_id,                             /* proposal_id */
         p_science_code,                           /* science_code */
         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: 96

   END Insert_Row;

Line: 100

   PROCEDURE Update_Row
   (
      p_rowid                 IN VARCHAR2,
      p_proposal_id           IN NUMBER,
      p_science_code          IN VARCHAR2,
      p_record_version_number IN NUMBER,
      x_return_status         OUT NOCOPY VARCHAR2,
      p_mode                  IN  VARCHAR2
   ) IS

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

Line: 112

      l_last_update_date  DATE         := SYSDATE;

Line: 113

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

Line: 114

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

Line: 122

         l_last_updated_by := 1;

Line: 123

         l_last_update_login := 0;

Line: 133

      UPDATE igw_prop_science_codes
      SET    science_code = p_science_code,
             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: 164

   END Update_Row;

Line: 168

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

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

Line: 181

      DELETE igw_prop_science_codes
      WHERE  rowid = p_rowid
      AND    record_version_number = p_record_version_number;

Line: 207

   END Delete_Row;