The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
Close cur_old_ref_values;
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
IF (p_action = 'UPDATE') THEN
new_references.creation_date := old_references.creation_date;
new_references.last_update_date := x_last_update_date;
new_references.last_updated_by := x_last_updated_by;
new_references.last_update_login := x_last_update_login;
SELECT rowid
FROM igs_ad_tst_rslt_dtls
WHERE tst_rslt_dtls_id = x_tst_rslt_dtls_id
FOR UPDATE NOWAIT;
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))
;
SELECT rowid
FROM igs_ad_tst_rslt_dtls
WHERE irregularity_code_id = x_code_id ;
SELECT rowid
FROM igs_ad_tst_rslt_dtls
WHERE test_results_id = x_test_results_id ;
SELECT rowid
FROM igs_ad_tst_rslt_dtls
WHERE test_segment_id = x_test_segment_id ;
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';
SELECT rowid,A.*
FROM IGS_AD_TEST_RESULTS A
WHERE test_results_id = cp_test_results_id
FOR UPDATE NOWAIT;
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
);
END update_parent_composite_score;
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 ;
SELECT admission_test_type
FROM igs_ad_test_results
WHERE test_results_id = new_references.test_results_id;
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';
SELECT
min_score,
max_score,
description
FROM
igs_ad_test_segments
WHERE
TEST_SEGMENT_ID = new_references.test_segment_id ;
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;
x_last_update_date,
x_last_updated_by,
x_last_update_login
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
Null;
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to Before Update.
Null;
ELSIF (p_action = 'DELETE') THEN
-- Call all the procedures related to Before Delete.
Check_Child_Existance;
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');
ELSIF (p_action = 'VALIDATE_UPDATE') THEN
Check_Uniqueness;
ELSIF (p_action = 'VALIDATE_DELETE') THEN
Check_Child_Existance;
SELECT person_id
FROM IGS_AD_TEST_RESULTS
WHERE TEST_RESULTS_ID = new_references.test_results_id;
SELECT include_in_comp_score
FROM igs_ad_test_segments
WHERE test_segment_id = cp_test_segment_id;
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to After Insert.
OPEN test_comb_score_cur(new_references.test_segment_id);
update_parent_composite_score(new_references.test_results_id);
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);
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);
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
;
X_LAST_UPDATE_DATE DATE ;
X_LAST_UPDATED_BY NUMBER ;
X_LAST_UPDATE_LOGIN NUMBER ;
X_PROGRAM_UPDATE_DATE DATE;
X_LAST_UPDATE_DATE := SYSDATE;
X_LAST_UPDATED_BY := 1;
X_LAST_UPDATE_LOGIN := 0;
X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
if X_LAST_UPDATED_BY is NULL then
X_LAST_UPDATED_BY := -1;
X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
if X_LAST_UPDATE_LOGIN is NULL then
X_LAST_UPDATE_LOGIN := -1;
X_PROGRAM_UPDATE_DATE := NULL;
X_PROGRAM_UPDATE_DATE := SYSDATE;
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);
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 ;
p_action => 'INSERT' ,
x_rowid => X_ROWID
);
end INSERT_ROW;
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;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
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 ;
X_LAST_UPDATED_BY NUMBER ;
X_LAST_UPDATE_LOGIN NUMBER ;
X_PROGRAM_UPDATE_DATE DATE;
X_LAST_UPDATE_DATE := SYSDATE;
X_LAST_UPDATED_BY := 1;
X_LAST_UPDATE_LOGIN := 0;
X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
if X_LAST_UPDATED_BY is NULL then
X_LAST_UPDATED_BY := -1;
X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
if X_LAST_UPDATE_LOGIN is NULL then
X_LAST_UPDATE_LOGIN := -1;
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);
X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;
X_PROGRAM_UPDATE_DATE := SYSDATE;
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;
p_action => 'UPDATE',
x_rowid => X_ROWID
);
end UPDATE_ROW;
cursor c1 is select ROWID from IGS_AD_TST_RSLT_DTLS
where TST_RSLT_DTLS_ID= X_TST_RSLT_DTLS_ID
;
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 );
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 );
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
);
delete from IGS_AD_TST_RSLT_DTLS
where ROWID = X_ROWID;
p_action => 'DELETE',
x_rowid => X_ROWID
);
END DELETE_ROW;