eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_TEST_RESULTS_PKG SQL Statements

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

Line: 46


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL ,
    x_active_ind IN VARCHAR2 DEFAULT NULL

  ) AS

  /*************************************************************
  Created By :samaresh.in
  Date Created By : 15-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_AD_TEST_RESULTS
      WHERE    rowid = x_rowid;

Line: 70


    SELECT score_type
    FROM igs_ad_test_type
    WHERE admission_test_type = cp_admission_test_type;

Line: 83


    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      Close cur_old_ref_values;

Line: 85


      Fnd_Message.Set_Name ('IGS', 'FORM_RECORD_DELETED');

Line: 138


    IF (p_action = 'UPDATE') THEN
      new_references.creation_date := old_references.creation_date;

Line: 145


    new_references.last_update_date := x_last_update_date;

Line: 146


    new_references.last_updated_by := x_last_updated_by;

Line: 147


    new_references.last_update_login := x_last_update_login;

Line: 340


  PROCEDURE Check_Child_For_Update  AS

  /*************************************************************
  Created By : Adarsh Padegal
  Date Created By : 28 Dec 2004
  Purpose : To check if child records are available while updating
  the parent record.
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  pkpatel         21-Jul-2005     Bug 4327807 (Person SS Enhancement)
                                  Added the check that test date can't be a future date when child records exist
   (Reverse chronological order - newest change first)
  ***************************************************************/

    CURSOR cur_rowid(cp_test_results_id NUMBER) IS
      SELECT   rowid
      FROM     igs_ad_tst_rslt_dtls
      WHERE    test_results_id = cp_test_results_id;

Line: 390


  END  Check_Child_For_Update;

Line: 392


  PROCEDURE beforerowinsertupdate(p_inserting BOOLEAN,p_updating BOOLEAN) AS
  /*
  ||  Created By : pkpatel
  ||  Created On : 6-Jun-2005
  ||  Purpose : Handles the Unique Constraint logic defined for the columns.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */
  CURSOR get_dob_dt_cur(cp_person_id igs_pe_passport.person_id%TYPE)
  IS
  SELECT birth_date
  FROM  igs_pe_person_base_v
  WHERE person_id = cp_person_id;

Line: 410


    IF p_inserting or p_updating THEN
         OPEN get_dob_dt_cur(new_references.person_id);

Line: 423


  END beforerowinsertupdate;

Line: 441


      SELECT   rowid
      FROM     igs_ad_test_results
      WHERE    test_results_id = x_test_results_id
      FOR UPDATE NOWAIT;

Line: 477


      SELECT   rowid
      FROM     igs_ad_test_results
      WHERE    edu_level_id = x_code_id ;

Line: 482


      SELECT   rowid
      FROM     igs_ad_test_results
      WHERE    grade_id = x_code_id ;

Line: 487


      SELECT   rowid
      FROM     igs_ad_test_results
      WHERE    score_source_id = x_code_id ;

Line: 545


      SELECT   rowid
      FROM     igs_ad_test_results
      WHERE    admission_test_type = x_admission_test_type ;

Line: 583


      SELECT   rowid
      FROM     igs_ad_test_results
      WHERE    person_id = x_person_id ;

Line: 644


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    x_active_ind IN VARCHAR2 DEFAULT NULL
  ) AS
  /*************************************************************
  Created By :samaresh.in
  Date Created By : 15-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  APADEGAL    10-JAN-2005     To check if the child records exist
  before the update of parent record.

  (reverse chronological order - newest change first)
  ***************************************************************/
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_test_results_id,
      x_person_id,
      x_admission_test_type,
      x_test_date,
      x_score_report_date,
      x_edu_level_id,
      x_score_type,
      x_score_source_id,
      x_non_standard_admin,
      x_comp_test_score,
      x_special_code,
      x_registration_number,
      x_grade_id,
      x_attribute_category,
      x_attribute1,
      x_attribute2,
      x_attribute3,
      x_attribute4,
      x_attribute5,
      x_attribute6,
      x_attribute7,
      x_attribute8,
      x_attribute9,
      x_attribute10,
      x_attribute11,
      x_attribute12,
      x_attribute13,
      x_attribute14,
      x_attribute15,
      x_attribute16,
      x_attribute17,
      x_attribute18,
      x_attribute19,
      x_attribute20,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_active_ind
    );

Line: 709


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      beforerowinsertupdate(TRUE, FALSE);

Line: 720


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      beforerowinsertupdate(FALSE, TRUE);

Line: 726


      Check_Child_For_Update;

Line: 728


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      Null;

Line: 732


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
     -- Call all the procedures related to Before Insert.
      IF Get_PK_For_Validation (
            new_references.test_results_id)  THEN
           Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 741


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Constraints;

Line: 743


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance;

Line: 768


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      --Raise the buisness event
      igs_ad_wf_001.TESTSCORE_CRT_EVENT
      (
        P_TEST_RESULTS_ID     =>   new_references.test_results_id,
        P_PERSON_ID           =>   new_references.person_id,
        P_ACTIVE_IND          =>   new_references.active_ind
      );

Line: 777


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to After Update.
      --Raise the buisness event
      igs_ad_wf_001.TESTSCORE_UPD_EVENT
      (
        P_TEST_RESULTS_ID            =>    new_references.test_results_id,
        P_PERSON_ID                  =>    new_references.person_id,
        P_ACTIVE_IND_NEW             =>    new_references.active_ind,
        P_ACTIVE_IND_OLD             =>    old_references.active_ind,
        P_ADMISSION_TEST_TYPE_NEW    =>    new_references.admission_test_type,
        P_ADMISSION_TEST_TYPE_OLD    =>    old_references.admission_test_type,
        P_GRADE_ID_NEW               =>    new_references.grade_id,
        P_GRADE_ID_OLD               =>    old_references.grade_id,
        P_COMP_TEST_SCORE_NEW        =>    new_references.comp_test_score,
        P_COMP_TEST_SCORE_OLD        =>    old_references.comp_test_score
      );

Line: 793


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to After Delete.
      Null;

Line: 800


 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_TEST_RESULTS_ID IN OUT NOCOPY NUMBER,
       x_PERSON_ID IN NUMBER,
       x_ADMISSION_TEST_TYPE IN VARCHAR2,
       x_TEST_DATE IN DATE,
       x_SCORE_REPORT_DATE IN DATE,
       x_EDU_LEVEL_ID IN NUMBER,
       x_SCORE_TYPE IN VARCHAR2,
       x_SCORE_SOURCE_ID IN NUMBER,
       x_NON_STANDARD_ADMIN IN VARCHAR2,
       x_COMP_TEST_SCORE IN NUMBER,
       x_SPECIAL_CODE IN VARCHAR2,
       x_REGISTRATION_NUMBER IN VARCHAR2,
       x_GRADE_ID IN NUMBER,
       x_ATTRIBUTE_CATEGORY IN VARCHAR2,
       x_ATTRIBUTE1 IN VARCHAR2,
       x_ATTRIBUTE2 IN VARCHAR2,
       x_ATTRIBUTE3 IN VARCHAR2,
       x_ATTRIBUTE4 IN VARCHAR2,
       x_ATTRIBUTE5 IN VARCHAR2,
       x_ATTRIBUTE6 IN VARCHAR2,
       x_ATTRIBUTE7 IN VARCHAR2,
       x_ATTRIBUTE8 IN VARCHAR2,
       x_ATTRIBUTE9 IN VARCHAR2,
       x_ATTRIBUTE10 IN VARCHAR2,
       x_ATTRIBUTE11 IN VARCHAR2,
       x_ATTRIBUTE12 IN VARCHAR2,
       x_ATTRIBUTE13 IN VARCHAR2,
       x_ATTRIBUTE14 IN VARCHAR2,
       x_ATTRIBUTE15 IN VARCHAR2,
       x_ATTRIBUTE16 IN VARCHAR2,
       x_ATTRIBUTE17 IN VARCHAR2,
       x_ATTRIBUTE18 IN VARCHAR2,
       x_ATTRIBUTE19 IN VARCHAR2,
       x_ATTRIBUTE20 IN VARCHAR2,
      X_MODE in VARCHAR2,
      x_ACTIVE_IND IN VARCHAR2 default  NULL
  ) AS
  /*************************************************************
  Created By :samaresh.in
  Date Created By : 15-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  RAVISHAR        Feb,25 2005     Removed the default value of X_MODE parameter from
                                  body of this package for bug 4163319
                  GSCC standard says that default value should be
                  present only in specification

  (reverse chronological order - newest change first)
  pbondugu     03-04-2003        For test_date and score_report_date  trunc of those fileds are inserted into tables.

  ***************************************************************/

    cursor C is select ROWID from IGS_AD_TEST_RESULTS
             where                 TEST_RESULTS_ID= X_TEST_RESULTS_ID;

Line: 860


     X_LAST_UPDATE_DATE DATE ;

Line: 861


     X_LAST_UPDATED_BY NUMBER ;

Line: 862


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 866


     X_PROGRAM_UPDATE_DATE DATE;

Line: 870


    X_LAST_UPDATE_DATE := SYSDATE;

Line: 872


      X_LAST_UPDATED_BY := 1;

Line: 873


      X_LAST_UPDATE_LOGIN := 0;

Line: 875


      X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 876


      if X_LAST_UPDATED_BY is NULL then
        X_LAST_UPDATED_BY := -1;

Line: 879


      X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 880


      if X_LAST_UPDATE_LOGIN is NULL then
        X_LAST_UPDATE_LOGIN := -1;

Line: 890


        X_PROGRAM_UPDATE_DATE := NULL;

Line: 892


        X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 902


        p_action=>'INSERT',
        x_rowid=>X_ROWID,
           x_test_results_id=>X_TEST_RESULTS_ID,
           x_person_id=>X_PERSON_ID,
           x_admission_test_type=>X_ADMISSION_TEST_TYPE,
           x_test_date=>X_TEST_DATE,
           x_score_report_date=>X_SCORE_REPORT_DATE,
           x_edu_level_id=>X_EDU_LEVEL_ID,
           x_score_type=>X_SCORE_TYPE,
           x_score_source_id=>X_SCORE_SOURCE_ID,
           x_non_standard_admin=>X_NON_STANDARD_ADMIN,
           x_comp_test_score=>X_COMP_TEST_SCORE,
           x_special_code=>X_SPECIAL_CODE,
           x_registration_number=>X_REGISTRATION_NUMBER,
           x_grade_id=>X_GRADE_ID,
           x_attribute_category=>X_ATTRIBUTE_CATEGORY,
           x_attribute1=>X_ATTRIBUTE1,
           x_attribute2=>X_ATTRIBUTE2,
           x_attribute3=>X_ATTRIBUTE3,
           x_attribute4=>X_ATTRIBUTE4,
           x_attribute5=>X_ATTRIBUTE5,
           x_attribute6=>X_ATTRIBUTE6,
           x_attribute7=>X_ATTRIBUTE7,
           x_attribute8=>X_ATTRIBUTE8,
           x_attribute9=>X_ATTRIBUTE9,
           x_attribute10=>X_ATTRIBUTE10,
           x_attribute11=>X_ATTRIBUTE11,
           x_attribute12=>X_ATTRIBUTE12,
           x_attribute13=>X_ATTRIBUTE13,
           x_attribute14=>X_ATTRIBUTE14,
           x_attribute15=>X_ATTRIBUTE15,
           x_attribute16=>X_ATTRIBUTE16,
           x_attribute17=>X_ATTRIBUTE17,
           x_attribute18=>X_ATTRIBUTE18,
           x_attribute19=>X_ATTRIBUTE19,
           x_attribute20=>X_ATTRIBUTE20,
           x_creation_date=>X_LAST_UPDATE_DATE,
           x_created_by=>X_LAST_UPDATED_BY,
           x_last_update_date=>X_LAST_UPDATE_DATE,
           x_last_updated_by=>X_LAST_UPDATED_BY,
           x_last_update_login=>X_LAST_UPDATE_LOGIN,
           x_active_ind => X_ACTIVE_IND );

Line: 947


 insert into IGS_AD_TEST_RESULTS (
        TEST_RESULTS_ID
        ,PERSON_ID
        ,ADMISSION_TEST_TYPE
        ,TEST_DATE
        ,SCORE_REPORT_DATE
        ,EDU_LEVEL_ID
        ,SCORE_TYPE
        ,SCORE_SOURCE_ID
        ,NON_STANDARD_ADMIN
        ,COMP_TEST_SCORE
        ,SPECIAL_CODE
        ,REGISTRATION_NUMBER
        ,GRADE_ID
        ,ATTRIBUTE_CATEGORY
        ,ATTRIBUTE1
        ,ATTRIBUTE2
        ,ATTRIBUTE3
        ,ATTRIBUTE4
        ,ATTRIBUTE5
        ,ATTRIBUTE6
        ,ATTRIBUTE7
        ,ATTRIBUTE8
        ,ATTRIBUTE9
        ,ATTRIBUTE10
        ,ATTRIBUTE11
        ,ATTRIBUTE12
        ,ATTRIBUTE13
        ,ATTRIBUTE14
        ,ATTRIBUTE15
        ,ATTRIBUTE16
        ,ATTRIBUTE17
        ,ATTRIBUTE18
        ,ATTRIBUTE19
        ,ATTRIBUTE20
            ,CREATION_DATE
        ,CREATED_BY
        ,LAST_UPDATE_DATE
        ,LAST_UPDATED_BY
        ,LAST_UPDATE_LOGIN
        ,REQUEST_ID
        ,PROGRAM_ID
        ,PROGRAM_APPLICATION_ID
        ,PROGRAM_UPDATE_DATE
        ,ACTIVE_IND
        ) values  (
             IGS_AD_TEST_RESULTS_S.NEXTVAL
            ,NEW_REFERENCES.PERSON_ID
            ,NEW_REFERENCES.ADMISSION_TEST_TYPE
            ,NEW_REFERENCES.TEST_DATE
            ,NEW_REFERENCES.SCORE_REPORT_DATE
            ,NEW_REFERENCES.EDU_LEVEL_ID
            ,NEW_REFERENCES.SCORE_TYPE
            ,NEW_REFERENCES.SCORE_SOURCE_ID
            ,NEW_REFERENCES.NON_STANDARD_ADMIN
            ,NEW_REFERENCES.COMP_TEST_SCORE
            ,NEW_REFERENCES.SPECIAL_CODE
            ,NEW_REFERENCES.REGISTRATION_NUMBER
            ,NEW_REFERENCES.GRADE_ID
            ,NEW_REFERENCES.ATTRIBUTE_CATEGORY
            ,NEW_REFERENCES.ATTRIBUTE1
            ,NEW_REFERENCES.ATTRIBUTE2
            ,NEW_REFERENCES.ATTRIBUTE3
            ,NEW_REFERENCES.ATTRIBUTE4
            ,NEW_REFERENCES.ATTRIBUTE5
            ,NEW_REFERENCES.ATTRIBUTE6
            ,NEW_REFERENCES.ATTRIBUTE7
            ,NEW_REFERENCES.ATTRIBUTE8
            ,NEW_REFERENCES.ATTRIBUTE9
            ,NEW_REFERENCES.ATTRIBUTE10
            ,NEW_REFERENCES.ATTRIBUTE11
            ,NEW_REFERENCES.ATTRIBUTE12
            ,NEW_REFERENCES.ATTRIBUTE13
            ,NEW_REFERENCES.ATTRIBUTE14
            ,NEW_REFERENCES.ATTRIBUTE15
            ,NEW_REFERENCES.ATTRIBUTE16
            ,NEW_REFERENCES.ATTRIBUTE17
            ,NEW_REFERENCES.ATTRIBUTE18
            ,NEW_REFERENCES.ATTRIBUTE19
            ,NEW_REFERENCES.ATTRIBUTE20
            ,X_LAST_UPDATE_DATE
        ,X_LAST_UPDATED_BY
        ,X_LAST_UPDATE_DATE
        ,X_LAST_UPDATED_BY
        ,X_LAST_UPDATE_LOGIN
        ,X_REQUEST_ID
        ,X_PROGRAM_ID
        ,X_PROGRAM_APPLICATION_ID
        ,X_PROGRAM_UPDATE_DATE
        ,NEW_REFERENCES.ACTIVE_IND
)RETURNING TEST_RESULTS_ID INTO X_TEST_RESULTS_ID;

Line: 1052


        p_action => 'INSERT' ,
        x_rowid => X_ROWID );

Line: 1067


end INSERT_ROW;

Line: 1117


   cursor c1 is select
      PERSON_ID
,      ADMISSION_TEST_TYPE
,      TEST_DATE
,      SCORE_REPORT_DATE
,      EDU_LEVEL_ID
,      SCORE_TYPE
,      SCORE_SOURCE_ID
,      NON_STANDARD_ADMIN
,      COMP_TEST_SCORE
,      SPECIAL_CODE
,      REGISTRATION_NUMBER
,      GRADE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ACTIVE_IND
    from IGS_AD_TEST_RESULTS
    where ROWID = X_ROWID
    for update nowait;

Line: 1160


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 1272


 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_TEST_RESULTS_ID IN NUMBER,
       x_PERSON_ID IN NUMBER,
       x_ADMISSION_TEST_TYPE IN VARCHAR2,
       x_TEST_DATE IN DATE,
       x_SCORE_REPORT_DATE IN DATE,
       x_EDU_LEVEL_ID IN NUMBER,
       x_SCORE_TYPE IN VARCHAR2,
       x_SCORE_SOURCE_ID IN NUMBER,
       x_NON_STANDARD_ADMIN IN VARCHAR2,
       x_COMP_TEST_SCORE IN NUMBER,
       x_SPECIAL_CODE IN VARCHAR2,
       x_REGISTRATION_NUMBER IN VARCHAR2,
       x_GRADE_ID IN NUMBER,
       x_ATTRIBUTE_CATEGORY IN VARCHAR2,
       x_ATTRIBUTE1 IN VARCHAR2,
       x_ATTRIBUTE2 IN VARCHAR2,
       x_ATTRIBUTE3 IN VARCHAR2,
       x_ATTRIBUTE4 IN VARCHAR2,
       x_ATTRIBUTE5 IN VARCHAR2,
       x_ATTRIBUTE6 IN VARCHAR2,
       x_ATTRIBUTE7 IN VARCHAR2,
       x_ATTRIBUTE8 IN VARCHAR2,
       x_ATTRIBUTE9 IN VARCHAR2,
       x_ATTRIBUTE10 IN VARCHAR2,
       x_ATTRIBUTE11 IN VARCHAR2,
       x_ATTRIBUTE12 IN VARCHAR2,
       x_ATTRIBUTE13 IN VARCHAR2,
       x_ATTRIBUTE14 IN VARCHAR2,
       x_ATTRIBUTE15 IN VARCHAR2,
       x_ATTRIBUTE16 IN VARCHAR2,
       x_ATTRIBUTE17 IN VARCHAR2,
       x_ATTRIBUTE18 IN VARCHAR2,
       x_ATTRIBUTE19 IN VARCHAR2,
       x_ATTRIBUTE20 IN VARCHAR2,
       X_MODE in VARCHAR2,
       x_ACTIVE_IND IN VARCHAR2 DEFAULT NULL
  ) AS
  /*************************************************************
  Created By :samaresh.in
  Date Created By : 15-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  RAVISHAR        Feb,25 2005     Removed the default value of X_MODE parameter from
                                  body of this package for bug 4163319
                  GSCC standard says that default value should be
                  present only in specification

  pbondugu     03-04-2003        For test_date and score_report_date  trunc of those fileds are updated into table.

  ***************************************************************/

     X_LAST_UPDATE_DATE DATE ;

Line: 1330


     X_LAST_UPDATED_BY NUMBER ;

Line: 1331


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 1335


     X_PROGRAM_UPDATE_DATE DATE;

Line: 1339


    X_LAST_UPDATE_DATE := SYSDATE;

Line: 1341


      X_LAST_UPDATED_BY := 1;

Line: 1342


      X_LAST_UPDATE_LOGIN := 0;

Line: 1344


      X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1345


      if X_LAST_UPDATED_BY is NULL then
        X_LAST_UPDATED_BY := -1;

Line: 1348


      X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 1349


      if X_LAST_UPDATE_LOGIN is NULL then
        X_LAST_UPDATE_LOGIN := -1;

Line: 1358


        p_action=>'UPDATE',
        x_rowid=>X_ROWID,
           x_test_results_id=>X_TEST_RESULTS_ID,
           x_person_id=>X_PERSON_ID,
           x_admission_test_type=>X_ADMISSION_TEST_TYPE,
           x_test_date=>X_TEST_DATE,
           x_score_report_date=>X_SCORE_REPORT_DATE,
           x_edu_level_id=>X_EDU_LEVEL_ID,
           x_score_type=>X_SCORE_TYPE,
           x_score_source_id=>X_SCORE_SOURCE_ID,
           x_non_standard_admin=>X_NON_STANDARD_ADMIN,
           x_comp_test_score=>X_COMP_TEST_SCORE,
           x_special_code=>X_SPECIAL_CODE,
           x_registration_number=>X_REGISTRATION_NUMBER,
           x_grade_id=>X_GRADE_ID,
           x_attribute_category=>X_ATTRIBUTE_CATEGORY,
           x_attribute1=>X_ATTRIBUTE1,
           x_attribute2=>X_ATTRIBUTE2,
           x_attribute3=>X_ATTRIBUTE3,
           x_attribute4=>X_ATTRIBUTE4,
           x_attribute5=>X_ATTRIBUTE5,
           x_attribute6=>X_ATTRIBUTE6,
           x_attribute7=>X_ATTRIBUTE7,
           x_attribute8=>X_ATTRIBUTE8,
           x_attribute9=>X_ATTRIBUTE9,
           x_attribute10=>X_ATTRIBUTE10,
           x_attribute11=>X_ATTRIBUTE11,
           x_attribute12=>X_ATTRIBUTE12,
           x_attribute13=>X_ATTRIBUTE13,
           x_attribute14=>X_ATTRIBUTE14,
           x_attribute15=>X_ATTRIBUTE15,
           x_attribute16=>X_ATTRIBUTE16,
           x_attribute17=>X_ATTRIBUTE17,
           x_attribute18=>X_ATTRIBUTE18,
           x_attribute19=>X_ATTRIBUTE19,
           x_attribute20=>X_ATTRIBUTE20,
           x_creation_date=>X_LAST_UPDATE_DATE,
           x_created_by=>X_LAST_UPDATED_BY,
           x_last_update_date=>X_LAST_UPDATE_DATE,
           x_last_updated_by=>X_LAST_UPDATED_BY,
           x_last_update_login=>X_LAST_UPDATE_LOGIN,
           x_active_ind => X_ACTIVE_IND);

Line: 1409


        X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 1411


        X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 1418


 update IGS_AD_TEST_RESULTS set
      PERSON_ID =  NEW_REFERENCES.PERSON_ID,
      ADMISSION_TEST_TYPE =  NEW_REFERENCES.ADMISSION_TEST_TYPE,
      TEST_DATE =  NEW_REFERENCES.TEST_DATE,
      SCORE_REPORT_DATE =  NEW_REFERENCES.SCORE_REPORT_DATE,
      EDU_LEVEL_ID =  NEW_REFERENCES.EDU_LEVEL_ID,
      SCORE_TYPE =  NEW_REFERENCES.SCORE_TYPE,
      SCORE_SOURCE_ID =  NEW_REFERENCES.SCORE_SOURCE_ID,
      NON_STANDARD_ADMIN =  NEW_REFERENCES.NON_STANDARD_ADMIN,
      COMP_TEST_SCORE =  NEW_REFERENCES.COMP_TEST_SCORE,
      SPECIAL_CODE =  NEW_REFERENCES.SPECIAL_CODE,
      REGISTRATION_NUMBER =  NEW_REFERENCES.REGISTRATION_NUMBER,
      GRADE_ID =  NEW_REFERENCES.GRADE_ID,
      ATTRIBUTE_CATEGORY =  NEW_REFERENCES.ATTRIBUTE_CATEGORY,
      ATTRIBUTE1 =  NEW_REFERENCES.ATTRIBUTE1,
      ATTRIBUTE2 =  NEW_REFERENCES.ATTRIBUTE2,
      ATTRIBUTE3 =  NEW_REFERENCES.ATTRIBUTE3,
      ATTRIBUTE4 =  NEW_REFERENCES.ATTRIBUTE4,
      ATTRIBUTE5 =  NEW_REFERENCES.ATTRIBUTE5,
      ATTRIBUTE6 =  NEW_REFERENCES.ATTRIBUTE6,
      ATTRIBUTE7 =  NEW_REFERENCES.ATTRIBUTE7,
      ATTRIBUTE8 =  NEW_REFERENCES.ATTRIBUTE8,
      ATTRIBUTE9 =  NEW_REFERENCES.ATTRIBUTE9,
      ATTRIBUTE10 =  NEW_REFERENCES.ATTRIBUTE10,
      ATTRIBUTE11 =  NEW_REFERENCES.ATTRIBUTE11,
      ATTRIBUTE12 =  NEW_REFERENCES.ATTRIBUTE12,
      ATTRIBUTE13 =  NEW_REFERENCES.ATTRIBUTE13,
      ATTRIBUTE14 =  NEW_REFERENCES.ATTRIBUTE14,
      ATTRIBUTE15 =  NEW_REFERENCES.ATTRIBUTE15,
      ATTRIBUTE16 =  NEW_REFERENCES.ATTRIBUTE16,
      ATTRIBUTE17 =  NEW_REFERENCES.ATTRIBUTE17,
      ATTRIBUTE18 =  NEW_REFERENCES.ATTRIBUTE18,
      ATTRIBUTE19 =  NEW_REFERENCES.ATTRIBUTE19,
      ATTRIBUTE20 =  NEW_REFERENCES.ATTRIBUTE20,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    REQUEST_ID = X_REQUEST_ID,
    PROGRAM_ID = X_PROGRAM_ID,
    PROGRAM_APPLICATION_ID = PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE,
    ACTIVE_IND = NEW_REFERENCES.ACTIVE_IND
      where ROWID = X_ROWID;

Line: 1473


    p_action => 'UPDATE' ,
    x_rowid => X_ROWID
    );

Line: 1489


end UPDATE_ROW;

Line: 1543


    cursor c1 is select ROWID from IGS_AD_TEST_RESULTS
             where     TEST_RESULTS_ID= X_TEST_RESULTS_ID
;

Line: 1553


    INSERT_ROW (
      X_ROWID,
       X_TEST_RESULTS_ID,
       X_PERSON_ID,
       X_ADMISSION_TEST_TYPE,
       X_TEST_DATE,
       X_SCORE_REPORT_DATE,
       X_EDU_LEVEL_ID,
       X_SCORE_TYPE,
       X_SCORE_SOURCE_ID,
       X_NON_STANDARD_ADMIN,
       X_COMP_TEST_SCORE,
       X_SPECIAL_CODE,
       X_REGISTRATION_NUMBER,
       X_GRADE_ID,
       X_ATTRIBUTE_CATEGORY,
       X_ATTRIBUTE1,
       X_ATTRIBUTE2,
       X_ATTRIBUTE3,
       X_ATTRIBUTE4,
       X_ATTRIBUTE5,
       X_ATTRIBUTE6,
       X_ATTRIBUTE7,
       X_ATTRIBUTE8,
       X_ATTRIBUTE9,
       X_ATTRIBUTE10,
       X_ATTRIBUTE11,
       X_ATTRIBUTE12,
       X_ATTRIBUTE13,
       X_ATTRIBUTE14,
       X_ATTRIBUTE15,
       X_ATTRIBUTE16,
       X_ATTRIBUTE17,
       X_ATTRIBUTE18,
       X_ATTRIBUTE19,
       X_ATTRIBUTE20,
      L_MODE,
      X_ACTIVE_IND);

Line: 1594


UPDATE_ROW (
      X_ROWID,
       X_TEST_RESULTS_ID,
       X_PERSON_ID,
       X_ADMISSION_TEST_TYPE,
       X_TEST_DATE,
       X_SCORE_REPORT_DATE,
       X_EDU_LEVEL_ID,
       X_SCORE_TYPE,
       X_SCORE_SOURCE_ID,
       X_NON_STANDARD_ADMIN,
       X_COMP_TEST_SCORE,
       X_SPECIAL_CODE,
       X_REGISTRATION_NUMBER,
       X_GRADE_ID,
       X_ATTRIBUTE_CATEGORY,
       X_ATTRIBUTE1,
       X_ATTRIBUTE2,
       X_ATTRIBUTE3,
       X_ATTRIBUTE4,
       X_ATTRIBUTE5,
       X_ATTRIBUTE6,
       X_ATTRIBUTE7,
       X_ATTRIBUTE8,
       X_ATTRIBUTE9,
       X_ATTRIBUTE10,
       X_ATTRIBUTE11,
       X_ATTRIBUTE12,
       X_ATTRIBUTE13,
       X_ATTRIBUTE14,
       X_ATTRIBUTE15,
       X_ATTRIBUTE16,
       X_ATTRIBUTE17,
       X_ATTRIBUTE18,
       X_ATTRIBUTE19,
       X_ATTRIBUTE20,
      L_MODE,
      X_ACTIVE_IND );

Line: 1633


procedure DELETE_ROW (
  X_ROWID in VARCHAR2,
  x_mode IN VARCHAR2
) AS
  /*************************************************************
  Created By :samaresh.in
  Date Created By : 15-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

begin
Before_DML (
p_action => 'DELETE',
x_rowid => X_ROWID
);

Line: 1656


 delete from IGS_AD_TEST_RESULTS
 where ROWID = X_ROWID;

Line: 1669


 p_action => 'DELETE',
 x_rowid => X_ROWID
);

Line: 1672


end DELETE_ROW;