The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rowid, da.*
FROM IGS_DA_RQST da
WHERE BATCH_ID = p_batch_id;
IGS_DA_RQST_PKG.UPDATE_ROW(
X_ROWID => v_da_rqst.ROWID ,
X_BATCH_ID => v_da_rqst.BATCH_ID ,
X_REQUEST_TYPE_ID => v_da_rqst.REQUEST_TYPE_ID ,
X_REQUEST_MODE => v_da_rqst.REQUEST_MODE ,
X_PROGRAM_COMPARISON_TYPE => v_da_rqst.PROGRAM_COMPARISON_TYPE ,
X_REQUEST_STATUS => v_da_rqst.REQUEST_STATUS ,
X_PERSON_ID_GROUP_ID => v_da_rqst.PERSON_ID_GROUP_ID ,
X_PERSON_ID => v_da_rqst.PERSON_ID ,
X_REQUESTOR_ID => v_da_rqst.REQUESTOR_ID ,
X_STUDENT_RELEASE_IND => 'Y' ,
X_SPECIAL_PROGRAM => v_da_rqst.SPECIAL_PROGRAM ,
X_SPECIAL_PROGRAM_CATALOG => v_da_rqst.SPECIAL_PROGRAM_CATALOG ,
X_ATTRIBUTE_CATEGORY => v_da_rqst.ATTRIBUTE_CATEGORY ,
X_ATTRIBUTE1 => v_da_rqst.ATTRIBUTE1 ,
X_ATTRIBUTE2 => v_da_rqst.ATTRIBUTE2 ,
X_ATTRIBUTE3 => v_da_rqst.ATTRIBUTE3 ,
X_ATTRIBUTE4 => v_da_rqst.ATTRIBUTE4 ,
X_ATTRIBUTE5 => v_da_rqst.ATTRIBUTE5 ,
X_ATTRIBUTE6 => v_da_rqst.ATTRIBUTE6 ,
X_ATTRIBUTE7 => v_da_rqst.ATTRIBUTE7 ,
X_ATTRIBUTE8 => v_da_rqst.ATTRIBUTE8 ,
X_ATTRIBUTE9 => v_da_rqst.ATTRIBUTE9 ,
X_ATTRIBUTE10 => v_da_rqst.ATTRIBUTE10 ,
X_ATTRIBUTE11 => v_da_rqst.ATTRIBUTE11 ,
X_ATTRIBUTE12 => v_da_rqst.ATTRIBUTE12 ,
X_ATTRIBUTE13 => v_da_rqst.ATTRIBUTE13 ,
X_ATTRIBUTE14 => v_da_rqst.ATTRIBUTE14 ,
X_ATTRIBUTE15 => v_da_rqst.ATTRIBUTE15 ,
X_ATTRIBUTE16 => v_da_rqst.ATTRIBUTE16 ,
X_ATTRIBUTE17 => v_da_rqst.ATTRIBUTE17 ,
X_ATTRIBUTE18 => v_da_rqst.ATTRIBUTE18 ,
X_ATTRIBUTE19 => v_da_rqst.ATTRIBUTE19 ,
X_ATTRIBUTE20 => v_da_rqst.ATTRIBUTE20 ,
X_MODE => 'R' ,
X_RETURN_STATUS => v_RETURN_STATUS ,
X_MSG_DATA => v_MSG_DATA ,
X_MSG_COUNT => v_MSG_COUNT
);
SELECT 'Y' FROM igs_pe_persid_group_all WHERE group_id = cp_group_id AND file_name IS NULL;
SELECT dr.rowid, dr.*
FROM igs_da_rqst dr
WHERE batch_id = cp_batch_id;
l_stc_stud_grp_mem VARCHAR2(2000) := ' SELECT person_id FROM igs_pe_prsid_grp_mem WHERE group_id = :1 ';
SELECT *
FROM igs_da_req_wif
WHERE batch_id = cp_batch_id;
SELECT course_cd
FROM igs_en_stdnt_ps_att
WHERE person_id = cp_person_id
AND course_attempt_status NOT IN ('DISCONTIN','UNCONFIRM');
SELECT crt.*
FROM igs_da_cnfg_req_typ crt,
igs_da_rqst dr
WHERE crt.request_type_id = dr.request_type_id
AND dr.batch_id = cp_batch_id;
SELECT cf.feature_code,
cf.feature_value
FROM igs_da_cnfg_ftr cf,
igs_da_rqst dr
WHERE dr.request_type_id = cf.request_type_id
AND dr.batch_id = cp_batch_id
AND cf.feature_code IN (SELECT feature_code
FROM igs_da_cnfg_ftr cf_in
WHERE cf_in.request_type_id = dr.request_type_id
MINUS
SELECT feature_code
FROM igs_da_req_ftrs rf_in
WHERE rf_in.batch_id = dr.batch_id);
igs_da_req_stdnts_pkg.insert_row (
X_ROWID => l_rowid,
X_BATCH_ID => rec_igs_da_rqst.batch_id,
X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
X_PERSON_ID => rec_igs_da_rqst.person_id,
X_PROGRAM_CODE => NULL,
X_WIF_PROGRAM_CODE => NULL,
X_SPECIAL_PROGRAM_CODE => rec_igs_da_rqst.special_program,
X_MAJOR_UNIT_SET_CD => NULL,
X_PROGRAM_MAJOR_CODE => NULL,
X_REPORT_TEXT => NULL,
X_WIF_ID => NULL,
X_MODE => 'R',
x_error_code => NULL
);
igs_da_req_stdnts_pkg.insert_row (
X_ROWID => l_rowid,
X_BATCH_ID => rec_igs_da_rqst.batch_id,
X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
X_PERSON_ID => l_person_id,
X_PROGRAM_CODE => NULL,
X_WIF_PROGRAM_CODE => NULL,
X_SPECIAL_PROGRAM_CODE => rec_igs_da_rqst.special_program,
X_MAJOR_UNIT_SET_CD => NULL,
X_PROGRAM_MAJOR_CODE => NULL,
X_REPORT_TEXT => NULL,
X_WIF_ID => NULL,
X_MODE => 'R',
x_error_code => NULL
);
igs_da_req_stdnts_pkg.insert_row (
X_ROWID => l_rowid,
X_BATCH_ID => rec_igs_da_rqst.batch_id,
X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
X_PERSON_ID => rec_igs_da_rqst.person_id,
X_PROGRAM_CODE => NULL,
X_WIF_PROGRAM_CODE => rec_igs_da_rec_wif.program_code,
X_SPECIAL_PROGRAM_CODE => NULL,
X_MAJOR_UNIT_SET_CD => rec_igs_da_rec_wif.major_unit_set_cd1,
X_PROGRAM_MAJOR_CODE => NULL,
X_REPORT_TEXT => NULL,
X_WIF_ID => rec_igs_da_rec_wif.wif_id,
X_MODE => 'R',
x_error_code => NULL
);
igs_da_req_stdnts_pkg.insert_row (
X_ROWID => l_rowid,
X_BATCH_ID => rec_igs_da_rqst.batch_id,
X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
X_PERSON_ID => l_person_id,
X_PROGRAM_CODE => NULL,
X_WIF_PROGRAM_CODE => rec_igs_da_rec_wif.program_code,
X_SPECIAL_PROGRAM_CODE => NULL,
X_MAJOR_UNIT_SET_CD => rec_igs_da_rec_wif.major_unit_set_cd1,
X_PROGRAM_MAJOR_CODE => NULL,
X_REPORT_TEXT => NULL,
X_WIF_ID => rec_igs_da_rec_wif.wif_id,
X_MODE => 'R',
x_error_code => NULL
);
igs_da_req_stdnts_pkg.insert_row (
X_ROWID => l_rowid,
X_BATCH_ID => rec_igs_da_rqst.batch_id,
X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
X_PERSON_ID => rec_igs_da_rqst.person_id,
X_PROGRAM_CODE => rec_prog_attempt.course_cd,
X_WIF_PROGRAM_CODE => NULL,
X_SPECIAL_PROGRAM_CODE => NULL,
X_MAJOR_UNIT_SET_CD => NULL,
X_PROGRAM_MAJOR_CODE => NULL,
X_REPORT_TEXT => NULL,
X_WIF_ID => NULL,
X_MODE => 'R',
x_error_code => NULL
);
igs_da_req_stdnts_pkg.insert_row (
X_ROWID => l_rowid,
X_BATCH_ID => rec_igs_da_rqst.batch_id,
X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
X_PERSON_ID => l_person_id,
X_PROGRAM_CODE => rec_prog_attempt.course_cd,
X_WIF_PROGRAM_CODE => NULL,
X_SPECIAL_PROGRAM_CODE => NULL,
X_MAJOR_UNIT_SET_CD => NULL,
X_PROGRAM_MAJOR_CODE => NULL,
X_REPORT_TEXT => NULL,
X_WIF_ID => NULL,
X_MODE => 'R',
x_error_code => NULL
);
igs_da_rqst_pkg.update_row
(
X_ROWID => rec_igs_da_rqst.rowid ,
X_BATCH_ID => rec_igs_da_rqst.batch_id ,
X_REQUEST_TYPE_ID => rec_igs_da_rqst.request_type_id ,
X_REQUEST_MODE => rec_igs_da_rqst.request_mode ,
X_PROGRAM_COMPARISON_TYPE => rec_igs_da_rqst.program_comparison_type ,
X_REQUEST_STATUS => rec_igs_da_rqst.request_status ,
X_PERSON_ID_GROUP_ID => rec_igs_da_rqst.person_id_group_id ,
X_PERSON_ID => rec_igs_da_rqst.person_id ,
X_REQUESTOR_ID => rec_igs_da_rqst.requestor_id ,
X_STUDENT_RELEASE_IND => rec_igs_da_rqst.student_release_ind ,
X_SPECIAL_PROGRAM => rec_igs_da_rqst.special_program ,
X_SPECIAL_PROGRAM_CATALOG => rec_igs_da_rqst.special_program_catalog ,
X_ATTRIBUTE_CATEGORY => rec_dff.attribute_category ,
X_ATTRIBUTE1 => rec_dff.attribute1 ,
X_ATTRIBUTE2 => rec_dff.attribute2 ,
X_ATTRIBUTE3 => rec_dff.attribute3 ,
X_ATTRIBUTE4 => rec_dff.attribute4 ,
X_ATTRIBUTE5 => rec_dff.attribute5 ,
X_ATTRIBUTE6 => rec_dff.attribute6 ,
X_ATTRIBUTE7 => rec_dff.attribute7 ,
X_ATTRIBUTE8 => rec_dff.attribute8 ,
X_ATTRIBUTE9 => rec_dff.attribute9 ,
X_ATTRIBUTE10 => rec_dff.attribute10 ,
X_ATTRIBUTE11 => rec_dff.attribute11 ,
X_ATTRIBUTE12 => rec_dff.attribute12 ,
X_ATTRIBUTE13 => rec_dff.attribute13 ,
X_ATTRIBUTE14 => rec_dff.attribute14 ,
X_ATTRIBUTE15 => rec_dff.attribute15 ,
X_ATTRIBUTE16 => rec_dff.attribute16 ,
X_ATTRIBUTE17 => rec_dff.attribute17 ,
X_ATTRIBUTE18 => rec_dff.attribute18 ,
X_ATTRIBUTE19 => rec_dff.attribute19 ,
X_ATTRIBUTE20 => rec_dff.attribute20 ,
X_MODE => 'R' ,
X_RETURN_STATUS => l_return_status ,
X_MSG_DATA => l_msg_data ,
X_MSG_COUNT => l_msg_count
);
now insert the records (IGS_DA_CNFG_FTR) not shown to the user
in the table IGS_DA_REQ_FTRS
*/
FOR rec_req_ftrs IN c_req_ftrs(p_batch_id)
LOOP
l_rowid := null;
igs_da_req_ftrs_pkg.insert_row
(
X_ROWID => l_rowid ,
X_BATCH_ID => p_batch_id ,
X_FEATURE_CODE => rec_req_ftrs.feature_code ,
X_FEATURE_VALUE => rec_req_ftrs.feature_value,
X_MODE => 'R' ,
X_RETURN_STATUS => l_return_status,
X_MSG_DATA => l_msg_data ,
X_MSG_COUNT => l_msg_count
);