APPS.IGW_SUBJECT_INFORMATION_PVT SQL Statements

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

Line: 37

      IGW_SUBJECT_INFORMATION_TBH.INSERT_ROW (
       X_ROWID => x_rowid,
       X_STUDY_TITLE_ID => p_study_title_id,
       X_SUBJECT_TYPE_CODE => p_subject_type_code,
       X_SUBJECT_RACE_CODE => p_subject_race_code,
       X_SUBJECT_ETHNICITY_CODE => p_subject_ethnicity_code,
       X_NO_OF_SUBJECTS => p_no_of_subjects,
       X_RETURN_STATUS => l_return_status);

Line: 101

PROCEDURE UPDATE_SUBJECT_INFORMATION
(p_init_msg_list                  IN VARCHAR2   := FND_API.G_TRUE
 , p_commit                       IN VARCHAR2   := FND_API.G_FALSE
 , p_validate_only                IN VARCHAR2   := FND_API.G_TRUE
 , p_study_title_id               IN NUMBER
 , p_subject_type_code            IN VARCHAR2
 , p_subject_race_code            IN VARCHAR2
 , p_subject_ethnicity_code       IN VARCHAR2
 , p_no_of_subjects               IN NUMBER
 , p_rowid                        IN ROWID
 , 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_msg_data                 VARCHAR2(250);

Line: 127

      SAVEPOINT update_study_title;

Line: 155

      IGW_SUBJECT_INFORMATION_TBH.UPDATE_ROW (
       X_ROWID => p_rowid,
       X_STUDY_TITLE_ID => p_study_title_id,
       X_SUBJECT_TYPE_CODE => p_subject_type_code,
       X_SUBJECT_RACE_CODE => p_subject_race_code,
       X_SUBJECT_ETHNICITY_CODE => p_subject_ethnicity_code,
       X_NO_OF_SUBJECTS => p_no_of_subjects,
       X_RECORD_VERSION_NUMBER => p_record_version_number,
       X_RETURN_STATUS => l_return_status);

Line: 194

       ROLLBACK TO update_study_title;

Line: 203

       ROLLBACK TO update_study_title;

Line: 212

       ROLLBACK TO update_study_title;

Line: 216

                            p_procedure_name => 'UPDATE_SUBJECT_INFORMATION');

Line: 221

  END UPDATE_SUBJECT_INFORMATION;

Line: 223

PROCEDURE DELETE_SUBJECT_INFORMATION (
  p_init_msg_list                IN             VARCHAR2   := FND_API.G_FALSE
 ,p_commit                       IN             VARCHAR2   := FND_API.G_FALSE
 ,p_validate_only                IN             VARCHAR2   := FND_API.G_FALSE
 ,x_rowid                        IN             VARCHAR2
 ,p_study_title_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_msg_count NUMBER;

Line: 243

       SAVEPOINT delete_study_title;

Line: 272

     IGW_SUBJECT_INFORMATION_TBH.DELETE_ROW(
             x_rowid                    =>      x_rowid,
             x_record_version_number    =>      p_record_version_number,
             x_return_status            =>      x_return_status);

Line: 305

       ROLLBACK TO delete_study_title;

Line: 314

       ROLLBACK TO update_study_title;

Line: 323

       ROLLBACK TO update_study_title;

Line: 327

                            p_procedure_name => 'DELETE_SUBJECT_INFORMATION');

Line: 341

   select 1
   into l_dummy
   from igw_subject_information
   where rowid = x_rowid
   and record_version_number = p_record_version_number;