DBA Data[Home] [Help]

APPS.IGS_AD_TST_RSLT_DTLS_PKG SQL Statements

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

Line: 44

    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL
  ) AS

  /*************************************************************
  Created By :
  Date Created By :
  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_TST_RSLT_DTLS
      WHERE    rowid = x_rowid;
Line: 73

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

      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 115

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

    new_references.last_update_date := x_last_update_date;
Line: 123

    new_references.last_updated_by := x_last_updated_by;
Line: 124

    new_references.last_update_login := x_last_update_login;
Line: 331

      SELECT   rowid
      FROM     igs_ad_tst_rslt_dtls
      WHERE    tst_rslt_dtls_id = x_tst_rslt_dtls_id
      FOR UPDATE NOWAIT;
Line: 368

      SELECT   rowid
      FROM     igs_ad_tst_rslt_dtls
      WHERE    test_results_id = x_test_results_id
      AND      test_segment_id = x_test_segment_id 	and      ((l_rowid is null) or (rowid <> l_rowid))

      ;
Line: 405

      SELECT   rowid
      FROM     igs_ad_tst_rslt_dtls
      WHERE    irregularity_code_id = x_code_id ;
Line: 442

      SELECT   rowid
      FROM     igs_ad_tst_rslt_dtls
      WHERE    test_results_id = x_test_results_id ;
Line: 479

      SELECT   rowid
      FROM     igs_ad_tst_rslt_dtls
      WHERE    test_segment_id = x_test_segment_id ;
Line: 513

PROCEDURE update_parent_composite_score(p_test_results_id IN NUMBER)
 AS

	 CURSOR c_calc_comp_score(cp_test_results_id IN NUMBER) IS
	 SELECT SUM(test_score)
	 FROM IGS_AD_TST_RSLT_DTLS A,
		  IGS_AD_TEST_SEGMENTS B
	 WHERE A.TEST_results_ID = cp_test_results_id
	 AND A.TEST_SEGMENT_ID =  B.test_segment_id
	 AND B.INCLUDE_IN_COMP_SCORE = 'Y';
Line: 528

	 SELECT rowid,A.*
	 FROM IGS_AD_TEST_RESULTS A
	 WHERE test_results_id = cp_test_results_id
	 FOR UPDATE NOWAIT;
Line: 547

Igs_Ad_Test_Results_Pkg.Update_Row (
     X_Mode                              => 'R',
     X_RowId                             => l_test_result.ROWID,
     X_Test_Results_Id                   => l_test_result.Test_Results_Id,
     X_Person_Id                         => l_test_result.Person_Id,
     X_Admission_Test_Type               => l_test_result.Admission_Test_Type,
     X_Test_Date                         => l_test_result.Test_Date,
     X_Score_Report_Date                 => l_test_result.Score_Report_Date,
     X_Edu_Level_Id                      => l_test_result.Edu_Level_Id,
     X_Score_Type                        => l_test_result.Score_Type,
     X_Score_Source_Id                   => l_test_result.Score_Source_Id,
     X_Non_Standard_Admin                => l_test_result.Non_Standard_Admin,
     X_Comp_Test_Score                   => l_comp_score,
     X_Special_Code                      => l_test_result.Special_Code,
     X_Registration_Number               => l_test_result.Registration_Number,
     X_Grade_Id                          => l_test_result.Grade_Id,
     X_Attribute_Category                => l_test_result.Attribute_Category,
     X_Attribute1                        => l_test_result.Attribute1,
     X_Attribute2                        => l_test_result.Attribute2,
     X_Attribute3                        => l_test_result.Attribute3,
     X_Attribute4                        => l_test_result.Attribute4,
     X_Attribute5                        => l_test_result.Attribute5,
     X_Attribute6                        => l_test_result.Attribute6,
     X_Attribute7                        => l_test_result.Attribute7,
     X_Attribute8                        => l_test_result.Attribute8,
     X_Attribute9                        => l_test_result.Attribute9,
     X_Attribute10                       => l_test_result.Attribute10,
     X_Attribute11                       => l_test_result.Attribute11,
     X_Attribute12                       => l_test_result.Attribute12,
     X_Attribute13                       => l_test_result.Attribute13,
     X_Attribute14                       => l_test_result.Attribute14,
     X_Attribute15                       => l_test_result.Attribute15,
     X_Attribute16                       => l_test_result.Attribute16,
     X_Attribute17                       => l_test_result.Attribute17,
     X_Attribute18                       => l_test_result.Attribute18,
     X_Attribute19                       => l_test_result.Attribute19,
     X_Attribute20                       => l_test_result.Attribute20,
     X_Active_Ind                        => l_test_result.Active_Ind
   );
Line: 595

 END update_parent_composite_score;
Line: 604

SELECT
  include_in_comp_score,
  score_ind,
  percentile_ind,
  irregularity_code_ind,
  percentile_year_rank_ind,
  national_percentile_ind,
  state_percentile_ind,
  score_band_upper_ind,
  score_band_lower_ind
FROM
  IGS_AD_TEST_SEGMENTS
WHERE
  test_segment_id = cp_test_segment_id ;
Line: 621

  SELECT admission_test_type
  FROM  igs_ad_test_results
  WHERE test_results_id = new_references.test_results_id;
Line: 626

  SELECT 'x'
  FROM
    igs_ad_test_segments
  WHERE
    test_segment_id  =  new_references.test_segment_id
    AND ADMISSION_TEST_TYPE = cp_admission_test_type
    AND closed_ind = 'N';
Line: 637

    SELECT
      min_score,
      max_score,
	  description
    FROM
      igs_ad_test_segments
    WHERE
      TEST_SEGMENT_ID = new_references.test_segment_id ;
Line: 831

    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/
  l_error BOOLEAN := FALSE;
Line: 890

      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );
Line: 900

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      Null;
Line: 930

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
     Null;
Line: 954

    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      Check_Child_Existance;
Line: 957

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

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN

      Check_Uniqueness;
Line: 972

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance;
Line: 1001

   SELECT person_id
   FROM IGS_AD_TEST_RESULTS
   WHERE TEST_RESULTS_ID = new_references.test_results_id;
Line: 1006

   SELECT include_in_comp_score
   FROM igs_ad_test_segments
   WHERE test_segment_id = cp_test_segment_id;
Line: 1020

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      OPEN test_comb_score_cur(new_references.test_segment_id);
Line: 1027

         update_parent_composite_score(new_references.test_results_id);
Line: 1038

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to After Update.

	  IF (NVL(new_references.test_score,-1) <> NVL(old_references.test_score,-1)) THEN
        update_parent_composite_score(new_references.test_results_id);
Line: 1056

    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to After Delete.
	  IF (old_references.test_score IS NOT NULL) THEN
         update_parent_composite_score(old_references.test_results_id);
Line: 1067

 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_TST_RSLT_DTLS_ID IN OUT NOCOPY NUMBER,
       x_TEST_RESULTS_ID IN NUMBER,
       x_TEST_SEGMENT_ID IN NUMBER,
       x_TEST_SCORE IN NUMBER,
       x_PERCENTILE IN NUMBER,
       x_NATIONAL_PERCENTILE IN NUMBER,
       x_STATE_PERCENTILE IN NUMBER,
       x_PERCENTILE_YEAR_RANK IN NUMBER,
       x_SCORE_BAND_LOWER IN NUMBER,
       x_SCORE_BAND_UPPER IN NUMBER,
       x_IRREGULARITY_CODE_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
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  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)
  ***************************************************************/

    cursor C is select ROWID from IGS_AD_TST_RSLT_DTLS
             where                 TST_RSLT_DTLS_ID= X_TST_RSLT_DTLS_ID
;
Line: 1121

     X_LAST_UPDATE_DATE DATE ;
Line: 1122

     X_LAST_UPDATED_BY NUMBER ;
Line: 1123

     X_LAST_UPDATE_LOGIN NUMBER ;
Line: 1127

     X_PROGRAM_UPDATE_DATE DATE;
Line: 1131

    X_LAST_UPDATE_DATE := SYSDATE;
Line: 1133

      X_LAST_UPDATED_BY := 1;
Line: 1134

      X_LAST_UPDATE_LOGIN := 0;
Line: 1136

      X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1137

      if X_LAST_UPDATED_BY is NULL then
        X_LAST_UPDATED_BY := -1;
Line: 1140

      X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 1141

      if X_LAST_UPDATE_LOGIN is NULL then
        X_LAST_UPDATE_LOGIN := -1;
Line: 1151

        X_PROGRAM_UPDATE_DATE := NULL;
Line: 1153

        X_PROGRAM_UPDATE_DATE := SYSDATE;
Line: 1163

 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_tst_rslt_dtls_id=>X_TST_RSLT_DTLS_ID,
 	       x_test_results_id=>X_TEST_RESULTS_ID,
 	       x_test_segment_id=>X_TEST_SEGMENT_ID,
 	       x_test_score=>X_TEST_SCORE,
 	       x_percentile=>X_PERCENTILE,
 	       x_national_percentile=>X_NATIONAL_PERCENTILE,
 	       x_state_percentile=>X_STATE_PERCENTILE,
 	       x_percentile_year_rank=>X_PERCENTILE_YEAR_RANK,
 	       x_score_band_lower=>X_SCORE_BAND_LOWER,
 	       x_score_band_upper=>X_SCORE_BAND_UPPER,
 	       x_irregularity_code_id=>X_IRREGULARITY_CODE_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);
Line: 1205

 insert into IGS_AD_TST_RSLT_DTLS (
		TST_RSLT_DTLS_ID
		,TEST_RESULTS_ID
		,TEST_SEGMENT_ID
		,TEST_SCORE
		,PERCENTILE
		,NATIONAL_PERCENTILE
		,STATE_PERCENTILE
		,PERCENTILE_YEAR_RANK
		,SCORE_BAND_LOWER
		,SCORE_BAND_UPPER
		,IRREGULARITY_CODE_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
        ) values  (
	        IGS_AD_TST_RSLT_DTLS_S.NEXTVAL
	        ,NEW_REFERENCES.TEST_RESULTS_ID
	        ,NEW_REFERENCES.TEST_SEGMENT_ID
	        ,NEW_REFERENCES.TEST_SCORE
	        ,NEW_REFERENCES.PERCENTILE
	        ,NEW_REFERENCES.NATIONAL_PERCENTILE
	        ,NEW_REFERENCES.STATE_PERCENTILE
	        ,NEW_REFERENCES.PERCENTILE_YEAR_RANK
	        ,NEW_REFERENCES.SCORE_BAND_LOWER
	        ,NEW_REFERENCES.SCORE_BAND_UPPER
	        ,NEW_REFERENCES.IRREGULARITY_CODE_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
)RETURNING TST_RSLT_DTLS_ID INTO X_TST_RSLT_DTLS_ID ;
Line: 1305

		p_action            => 'INSERT' ,
		x_rowid             => X_ROWID
                );
Line: 1321

end INSERT_ROW;
Line: 1367

   cursor c1 is select
      TEST_RESULTS_ID
,      TEST_SEGMENT_ID
,      TEST_SCORE
,      PERCENTILE
,      NATIONAL_PERCENTILE
,      STATE_PERCENTILE
,      PERCENTILE_YEAR_RANK
,      SCORE_BAND_LOWER
,      SCORE_BAND_UPPER
,      IRREGULARITY_CODE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
    from IGS_AD_TST_RSLT_DTLS
    where ROWID = X_ROWID
    for update nowait;
Line: 1407

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
Line: 1512

 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_TST_RSLT_DTLS_ID IN NUMBER,
       x_TEST_RESULTS_ID IN NUMBER,
       x_TEST_SEGMENT_ID IN NUMBER,
       x_TEST_SCORE IN NUMBER,
       x_PERCENTILE IN NUMBER,
       x_NATIONAL_PERCENTILE IN NUMBER,
       x_STATE_PERCENTILE IN NUMBER,
       x_PERCENTILE_YEAR_RANK IN NUMBER,
       x_SCORE_BAND_LOWER IN NUMBER,
       x_SCORE_BAND_UPPER IN NUMBER,
       x_IRREGULARITY_CODE_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
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  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)
  ***************************************************************/

     X_LAST_UPDATE_DATE DATE ;
Line: 1564

     X_LAST_UPDATED_BY NUMBER ;
Line: 1565

     X_LAST_UPDATE_LOGIN NUMBER ;
Line: 1569

     X_PROGRAM_UPDATE_DATE DATE;
Line: 1573

    X_LAST_UPDATE_DATE := SYSDATE;
Line: 1575

      X_LAST_UPDATED_BY := 1;
Line: 1576

      X_LAST_UPDATE_LOGIN := 0;
Line: 1578

      X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1579

      if X_LAST_UPDATED_BY is NULL then
        X_LAST_UPDATED_BY := -1;
Line: 1582

      X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 1583

      if X_LAST_UPDATE_LOGIN is NULL then
        X_LAST_UPDATE_LOGIN := -1;
Line: 1592

 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_tst_rslt_dtls_id=>X_TST_RSLT_DTLS_ID,
 	       x_test_results_id=>X_TEST_RESULTS_ID,
 	       x_test_segment_id=>X_TEST_SEGMENT_ID,
 	       x_test_score=>X_TEST_SCORE,
 	       x_percentile=>X_PERCENTILE,
 	       x_national_percentile=>X_NATIONAL_PERCENTILE,
 	       x_state_percentile=>X_STATE_PERCENTILE,
 	       x_percentile_year_rank=>X_PERCENTILE_YEAR_RANK,
 	       x_score_band_lower=>X_SCORE_BAND_LOWER,
 	       x_score_band_upper=>X_SCORE_BAND_UPPER,
 	       x_irregularity_code_id=>X_IRREGULARITY_CODE_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);
Line: 1640

        X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;
Line: 1642

        X_PROGRAM_UPDATE_DATE := SYSDATE;
Line: 1649

 update IGS_AD_TST_RSLT_DTLS set
      TEST_RESULTS_ID =  NEW_REFERENCES.TEST_RESULTS_ID,
      TEST_SEGMENT_ID =  NEW_REFERENCES.TEST_SEGMENT_ID,
      TEST_SCORE =  NEW_REFERENCES.TEST_SCORE,
      PERCENTILE =  NEW_REFERENCES.PERCENTILE,
      NATIONAL_PERCENTILE =  NEW_REFERENCES.NATIONAL_PERCENTILE,
      STATE_PERCENTILE =  NEW_REFERENCES.STATE_PERCENTILE,
      PERCENTILE_YEAR_RANK =  NEW_REFERENCES.PERCENTILE_YEAR_RANK,
      SCORE_BAND_LOWER =  NEW_REFERENCES.SCORE_BAND_LOWER,
      SCORE_BAND_UPPER =  NEW_REFERENCES.SCORE_BAND_UPPER,
      IRREGULARITY_CODE_ID =  NEW_REFERENCES.IRREGULARITY_CODE_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
	  where ROWID = X_ROWID;
Line: 1701

        	p_action            => 'UPDATE',
	        x_rowid             => X_ROWID

	);
Line: 1718

end UPDATE_ROW;
Line: 1770

    cursor c1 is select ROWID from IGS_AD_TST_RSLT_DTLS
             where     TST_RSLT_DTLS_ID= X_TST_RSLT_DTLS_ID
;
Line: 1780

    INSERT_ROW (
      X_ROWID,
       X_TST_RSLT_DTLS_ID,
       X_TEST_RESULTS_ID,
       X_TEST_SEGMENT_ID,
       X_TEST_SCORE,
       X_PERCENTILE,
       X_NATIONAL_PERCENTILE,
       X_STATE_PERCENTILE,
       X_PERCENTILE_YEAR_RANK,
       X_SCORE_BAND_LOWER,
       X_SCORE_BAND_UPPER,
       X_IRREGULARITY_CODE_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 );
Line: 1818

UPDATE_ROW (
      X_ROWID,
       X_TST_RSLT_DTLS_ID,
       X_TEST_RESULTS_ID,
       X_TEST_SEGMENT_ID,
       X_TEST_SCORE,
       X_PERCENTILE,
       X_NATIONAL_PERCENTILE,
       X_STATE_PERCENTILE,
       X_PERCENTILE_YEAR_RANK,
       X_SCORE_BAND_LOWER,
       X_SCORE_BAND_UPPER,
       X_IRREGULARITY_CODE_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 );
Line: 1854

procedure DELETE_ROW (
  X_ROWID in VARCHAR2,
  x_mode IN VARCHAR2
) AS
  /*************************************************************
  Created By :
  Date Created By :
  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: 1877

 delete from IGS_AD_TST_RSLT_DTLS
 where ROWID = X_ROWID;
Line: 1890

                p_action            => 'DELETE',
                x_rowid             => X_ROWID
);
Line: 1894

END DELETE_ROW;