APPS.IGS_EN_SPAA_LGCY_PUB SQL Statements

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

Line: 89

  ||               check before insertion of a Award Aims record.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */
  CURSOR cur_awd_grd_sch(
               cp_award_cd igs_ps_awd.award_cd%TYPE,
               cp_grading_schema_cd igs_ps_awd.grading_schema_cd%TYPE,
               cp_gs_version_number igs_ps_awd.gs_version_number%TYPE ) IS
        SELECT 'X'
          FROM igs_ps_awd
         WHERE award_cd = cp_award_cd
	   AND grading_schema_cd = cp_grading_schema_cd
	   AND gs_version_number = cp_gs_version_number;

Line: 186

  ||               inserting a Award Aims record.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */
l_val_awd_aim  VARCHAR2(10) := 'VALID';

Line: 236

  ||  Purpose    : This procedure inserts records into the Award Aims table after
  ||               checking all the validations sequencially as below:
  ||               1. Validation of the parameters.
  ||               2. Deriving values for other parameters
  ||               3. Checking DB Constraints
  ||               4. Checking for other validations
  ||               5. Inserting the record into the table
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */

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

Line: 253

l_last_update_date       igs_en_spa_awd_aim.creation_date%TYPE;

Line: 254

l_last_updated_by        igs_en_spa_awd_aim.last_updated_by%TYPE;

Line: 255

l_last_update_login      igs_en_spa_awd_aim.last_update_login%TYPE;

Line: 308

    /****** Insert data into Award Aims table ******/
    IF l_stdnt_awd_aim_status <> 'INVALID' THEN
         --Deriving values for the WHO Columns
         l_last_update_date := SYSDATE;

Line: 313

         l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 314

         IF l_last_updated_by IS NULL THEN
              l_last_updated_by := -1;

Line: 318

         l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 319

         IF l_last_update_login IS NULL THEN
              l_last_update_login := -1;

Line: 324

         INSERT INTO igs_en_spa_awd_aim (
              person_id,
              course_cd,
              award_cd,
              start_dt,
              end_dt,
              complete_ind,
              created_by,
              creation_date,
              last_updated_by,
              last_update_date,
              last_update_login,
	      conferral_date,
              award_mark       ,
              award_grade      ,
              grading_schema_cd,
              gs_version_number )
         VALUES (
              l_person_id,
              p_awd_aim_rec.program_cd,
              p_awd_aim_rec.award_cd,
              TRUNC(p_awd_aim_rec.start_dt),
              p_awd_aim_rec.end_dt,
              NVL( p_awd_aim_rec.complete_ind, 'N' ),
              l_last_updated_by,
              l_last_update_date,
              l_last_updated_by,
              l_last_update_date,
              l_last_update_login,
              p_awd_aim_rec.conferral_dt,
              p_awd_aim_rec.award_mark,
              p_awd_aim_rec.award_grade,
              p_awd_aim_rec.grading_schema_cd,
              p_awd_aim_rec.gs_version_number );