The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_last_update_date IN DATE,
x_last_updated_by IN NUMBER,
x_last_update_login IN NUMBER,
x_grading_period_cd IN VARCHAR2,
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_incomp_deadline_date IN DATE,
x_incomp_grading_schema_cd IN VARCHAR2,
x_incomp_version_number IN NUMBER,
x_incomp_default_grade IN VARCHAR2,
x_incomp_default_mark IN NUMBER,
x_comments IN VARCHAR2,
x_uoo_id IN NUMBER,
x_mark_capped_flag IN VARCHAR2,
x_release_date IN DATE,
x_manual_override_flag IN VARCHAR2,
x_show_on_academic_histry_flag IN VARCHAR2
) AS
CURSOR cur_old_ref_values IS
SELECT *
FROM igs_as_su_stmptout_all
WHERE ROWID = x_rowid;
SELECT 'X'
FROM igs_as_grd_sch_grade
WHERE grading_schema_cd = l_grading_schema_cd
AND version_number = l_version_number
and grade = l_grade
and s_result_type = 'INCOMP';
SELECT owner_org_unit_cd FROM igs_ps_unit_ofr_opt_all WHERE uoo_id = l_uoo_id;
SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
default_mark
FROM igs_as_inc_grd_cprof_v
WHERE incomplete_grade = l_incomplete_grade
AND org_unit_cd = l_org_unit_cd
AND grading_schema_cd = l_grading_schema_cd
AND version_number = l_version_number;
SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
default_mark
FROM igs_as_inc_grd_cprof_v
WHERE incomplete_grade = l_incomplete_grade
AND grading_schema_cd = l_grading_schema_cd
AND version_number = l_version_number;
SELECT max(IGS_CA_GEN_001.calp_get_alias_val(dt_alias, sequence_number, cal_type, ci_sequence_number))
FROM igs_ca_da_inst
WHERE dt_alias = l_dt_alias
AND cal_type = l_cal_type
AND ci_sequence_number = l_ci_sequence_number;
AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
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;
PROCEDURE beforerowinsertupdate1 (p_inserting IN BOOLEAN, p_updating IN BOOLEAN, p_deleting IN BOOLEAN) AS
v_sequence_number NUMBER;
IF (p_inserting
AND new_references.finalised_outcome_ind = 'Y'
)
OR (p_updating
AND (old_references.finalised_outcome_ind = 'Y'
OR new_references.finalised_outcome_ind = 'Y'
)
) THEN
IF p_inserting
OR p_updating THEN
IF new_references.s_grade_creation_method_type <> 'DISCONTIN' THEN
v_sequence_number := igs_ge_gen_003.genp_ins_stdnt_todo (new_references.person_id, 'UNIT-RULES', NULL, 'Y');
IF p_inserting THEN
igs_pr_gen_004.igs_pr_ins_suao_todo (
new_references.person_id,
new_references.course_cd,
NULL, --new_references.version_number,
new_references.unit_cd,
new_references.cal_type,
new_references.ci_sequence_number,
new_references.grading_schema_cd,
new_references.grading_schema_cd,
new_references.version_number,
new_references.version_number,
new_references.grade,
new_references.grade,
new_references.mark,
new_references.mark,
new_references.finalised_outcome_ind,
new_references.finalised_outcome_ind,
new_references.uoo_id
);
IF p_inserting THEN
igs_pr_gen_004.igs_pr_ins_suao_todo (
new_references.person_id,
new_references.course_cd,
NULL, --new_references.version_number,
old_references.unit_cd,
old_references.cal_type,
old_references.ci_sequence_number,
old_references.grading_schema_cd,
old_references.grading_schema_cd,
old_references.version_number,
old_references.version_number,
old_references.grade,
old_references.grade,
old_references.mark,
old_references.mark,
old_references.finalised_outcome_ind,
old_references.finalised_outcome_ind,
old_references.uoo_id
);
IF p_inserting THEN
-- Get the calendar start/end dates.
igs_ca_gen_001.calp_get_ci_dates (
new_references.cal_type,
new_references.ci_sequence_number,
new_references.ci_start_dt,
new_references.ci_end_dt
);
END beforerowinsertupdate1;
PROCEDURE afterrowinsertupdate2 (p_inserting IN BOOLEAN, p_updating IN BOOLEAN, p_deleting IN BOOLEAN) AS
v_message_name VARCHAR2 (30);
SELECT sua.*,
sua.ROWID
FROM igs_en_su_attempt sua
WHERE sua.person_id = cp_person_id
AND sua.course_cd = cp_course_cd
AND sua.uoo_id = cp_uoo_id;
SELECT 'Y' transfer_exists
FROM igs_ps_stdnt_unt_trn sut1
WHERE sut1.person_id = cp_person_id
AND sut1.transfer_course_cd = cp_course_cd
AND sut1.uoo_id = cp_uoo_id
AND EXISTS ( SELECT 'X'
FROM igs_en_su_attempt_all sua
WHERE sua.person_id = sut1.person_id
AND sua.course_cd = sut1.transfer_course_cd
AND sua.uoo_id = sut1.uoo_id
AND sua.unit_attempt_status IN ('COMPLETED', 'DISCONTIN')
AND EXISTS (SELECT 'X'
FROM igs_en_su_attempt_all sua
WHERE sua.person_id = sut1.person_id
AND sua.course_cd = sut1.course_cd
AND sua.uoo_id = sut1.uoo_id
AND sua.unit_attempt_status = 'DUPLICATE'))
AND sut1.transfer_dt = (SELECT MAX (sut2.transfer_dt)
FROM igs_ps_stdnt_unt_trn sut2
WHERE sut2.person_id = sut1.person_id
AND sut2.transfer_course_cd = sut1.transfer_course_cd
AND sut2.uoo_id = sut1.uoo_id)
AND sut1.transfer_dt > (SELECT NVL (MAX (sut3.transfer_dt),( sut1.transfer_dt - 1))
FROM igs_ps_stdnt_unt_trn sut3
WHERE sut3.person_id = sut1.person_id
AND sut3.course_cd = sut1.transfer_course_cd
AND sut3.uoo_id = sut1.uoo_id);
igs_en_sua_api.update_unit_attempt (
x_mode => 'R',
x_rowid => v_sua_rec.ROWID,
x_person_id => v_sua_rec.person_id,
x_course_cd => v_sua_rec.course_cd,
x_unit_cd => v_sua_rec.unit_cd,
x_cal_type => v_sua_rec.cal_type,
x_ci_sequence_number => v_sua_rec.ci_sequence_number,
x_version_number => v_sua_rec.version_number,
x_location_cd => v_sua_rec.location_cd,
x_unit_class => v_sua_rec.unit_class,
x_ci_start_dt => v_sua_rec.ci_start_dt,
x_ci_end_dt => v_sua_rec.ci_end_dt,
x_uoo_id => v_sua_rec.uoo_id,
x_enrolled_dt => v_sua_rec.enrolled_dt,
x_unit_attempt_status => v_sua_status,
x_administrative_unit_status => v_sua_rec.administrative_unit_status,
x_administrative_priority => v_sua_rec.administrative_priority,
x_discontinued_dt => v_sua_rec.discontinued_dt,
x_dcnt_reason_cd => v_sua_rec.dcnt_reason_cd,
x_rule_waived_dt => v_sua_rec.rule_waived_dt,
x_rule_waived_person_id => v_sua_rec.rule_waived_person_id,
x_no_assessment_ind => v_sua_rec.no_assessment_ind,
x_sup_unit_cd => v_sua_rec.sup_unit_cd,
x_sup_version_number => v_sua_rec.sup_version_number,
x_exam_location_cd => v_sua_rec.exam_location_cd,
x_alternative_title => v_sua_rec.alternative_title,
x_override_enrolled_cp => v_sua_rec.override_enrolled_cp,
x_override_eftsu => v_sua_rec.override_eftsu,
x_override_achievable_cp => v_sua_rec.override_achievable_cp,
x_override_outcome_due_dt => v_sua_rec.override_outcome_due_dt,
x_override_credit_reason => v_sua_rec.override_credit_reason,
x_waitlist_dt => v_sua_rec.waitlist_dt,
x_gs_version_number => v_sua_rec.gs_version_number,
x_enr_method_type => v_sua_rec.enr_method_type,
x_failed_unit_rule => v_sua_rec.failed_unit_rule,
x_cart => v_sua_rec.cart,
x_rsv_seat_ext_id => v_sua_rec.rsv_seat_ext_id,
x_org_unit_cd => v_sua_rec.org_unit_cd,
x_session_id => v_sua_rec.session_id,
x_grading_schema_code => v_sua_rec.grading_schema_code,
x_deg_aud_detail_id => v_sua_rec.deg_aud_detail_id,
x_subtitle => v_sua_rec.subtitle,
x_student_career_transcript => v_sua_rec.student_career_transcript,
x_student_career_statistics => v_sua_rec.student_career_statistics,
x_waitlist_manual_ind => v_sua_rec.waitlist_manual_ind,
x_attribute_category => v_sua_rec.attribute_category,
x_attribute1 => v_sua_rec.attribute1,
x_attribute2 => v_sua_rec.attribute2,
x_attribute3 => v_sua_rec.attribute3,
x_attribute4 => v_sua_rec.attribute4,
x_attribute5 => v_sua_rec.attribute5,
x_attribute6 => v_sua_rec.attribute6,
x_attribute7 => v_sua_rec.attribute7,
x_attribute8 => v_sua_rec.attribute8,
x_attribute9 => v_sua_rec.attribute9,
x_attribute10 => v_sua_rec.attribute10,
x_attribute11 => v_sua_rec.attribute11,
x_attribute12 => v_sua_rec.attribute12,
x_attribute13 => v_sua_rec.attribute13,
x_attribute14 => v_sua_rec.attribute14,
x_attribute15 => v_sua_rec.attribute15,
x_attribute16 => v_sua_rec.attribute16,
x_attribute17 => v_sua_rec.attribute17,
x_attribute18 => v_sua_rec.attribute18,
x_attribute19 => v_sua_rec.attribute19,
x_attribute20 => v_sua_rec.attribute20,
x_wlst_priority_weight_num => v_sua_rec.wlst_priority_weight_num,
x_wlst_preference_weight_num => v_sua_rec.wlst_preference_weight_num,
-- core_indicator_code added by rvangala 07-OCT-2003. Enh Bug# 3052432
x_core_indicator_code => v_sua_rec.core_indicator_code
);
UPDATE igs_as_su_stmptout_all
SET translated_grading_schema_cd = v_translated_grading_schema_cd,
translated_version_number = v_translated_version_number,
translated_grade = v_translated_grade,
translated_dt = v_translated_dt
WHERE person_id = new_references.person_id
AND course_cd = new_references.course_cd
AND outcome_dt = new_references.outcome_dt
AND grading_period_cd = new_references.grading_period_cd
AND uoo_id = new_references.uoo_id;
new_references.last_updated_by,
new_references.last_update_date,
old_references.grading_schema_cd,
old_references.version_number,
old_references.grade,
old_references.s_grade_creation_method_type,
old_references.finalised_outcome_ind,
old_references.mark,
old_references.number_times_keyed,
old_references.translated_grading_schema_cd,
old_references.translated_version_number,
old_references.translated_grade,
old_references.translated_dt,
old_references.last_updated_by,
old_references.last_update_date,
old_references.uoo_id
);
END afterrowinsertupdate2;
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
SELECT ROWID
FROM igs_as_su_stmptout_all
WHERE person_id = x_person_id
AND course_cd = x_course_cd
AND outcome_dt = x_outcome_dt
AND grading_period_cd = x_grading_period_cd
AND uoo_id = x_uoo_id
FOR UPDATE NOWAIT;
SELECT ROWID
FROM igs_as_su_stmptout_all
WHERE cal_type = x_cal_type
AND ci_sequence_number = x_sequence_number
AND ci_start_dt = x_start_dt
AND ci_end_dt = x_end_dt;
SELECT ROWID
FROM igs_as_su_stmptout_all
WHERE s_grade_creation_method_type = x_s_grade_creation_method_type;
SELECT ROWID
FROM igs_as_su_stmptout_all
WHERE person_id = x_person_id
AND course_cd = x_course_cd
AND uoo_id = x_uoo_id;
SELECT ROWID
FROM igs_as_su_stmptout_all
WHERE translated_grading_schema_cd = x_grading_schema_cd
AND translated_version_number = x_version_number
AND translated_grade = x_grade
OR (grading_schema_cd = x_grading_schema_cd
AND version_number = x_version_number
AND grade = x_grade
);
x_last_update_date IN DATE,
x_last_updated_by IN NUMBER,
x_last_update_login IN NUMBER,
x_grading_period_cd IN VARCHAR2,
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_incomp_deadline_date IN DATE,
x_incomp_grading_schema_cd IN VARCHAR2,
x_incomp_version_number IN NUMBER,
x_incomp_default_grade IN VARCHAR2,
x_incomp_default_mark IN NUMBER,
x_comments IN VARCHAR2,
x_uoo_id IN NUMBER,
x_mark_capped_flag IN VARCHAR2,
x_release_date IN DATE,
x_manual_override_flag IN VARCHAR2,
x_show_on_academic_histry_flag IN VARCHAR2
) AS
CURSOR c_sua_ass_ind IS
SELECT sua.no_assessment_ind
FROM igs_en_su_attempt sua
WHERE sua.person_id = x_person_id
AND sua.course_cd = x_course_cd
AND sua.uoo_id = x_uoo_id;
SELECT gsg.s_result_type
FROM igs_as_grd_sch_grade gsg
WHERE gsg.grading_schema_cd = x_grading_schema_cd
AND gsg.version_number = x_version_number
AND gsg.grade = x_grade;
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_grading_period_cd,
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_incomp_deadline_date,
x_incomp_grading_schema_cd,
x_incomp_version_number,
x_incomp_default_grade,
x_incomp_default_mark,
x_comments,
x_uoo_id,
x_mark_capped_flag,
x_release_date,
x_manual_override_flag,
x_show_on_academic_histry_flag
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
beforerowinsertupdate1 (p_inserting => TRUE, p_updating => FALSE, p_deleting => FALSE);
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to Before Update.
beforerowinsertupdate1 (p_inserting => FALSE, p_updating => TRUE, p_deleting => FALSE);
ELSIF (p_action = 'VALIDATE_INSERT') THEN
IF get_pk_for_validation (
new_references.person_id,
new_references.course_cd,
new_references.outcome_dt,
NVL (new_references.grading_period_cd, 'FINAL'),
new_references.uoo_id
) THEN
fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
ELSIF (p_action = 'VALIDATE_UPDATE') THEN
check_constraints;
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to After Insert.
afterrowinsertupdate2 (p_inserting => TRUE, p_updating => FALSE, p_deleting => FALSE);
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to After Update.
afterrowinsertupdate2 (p_inserting => FALSE, p_updating => TRUE, p_deleting => FALSE);
ELSIF (p_action = 'DELETE') THEN
-- Call all the procedures related to After Update.
afterrowinsertupdate2 (p_inserting => FALSE, p_updating => FALSE, p_deleting => TRUE);
PROCEDURE insert_row (
x_rowid IN OUT NOCOPY VARCHAR2,
x_org_id IN NUMBER,
x_person_id IN NUMBER,
x_course_cd IN VARCHAR2,
x_unit_cd IN VARCHAR2,
x_cal_type IN VARCHAR2,
x_ci_sequence_number IN NUMBER,
x_outcome_dt IN DATE,
x_ci_start_dt IN DATE,
x_ci_end_dt IN DATE,
x_grading_schema_cd IN VARCHAR2,
x_version_number IN NUMBER,
x_grade IN VARCHAR2,
x_s_grade_creation_method_type IN VARCHAR2,
x_finalised_outcome_ind IN VARCHAR2,
x_mark IN NUMBER,
x_number_times_keyed IN NUMBER,
x_translated_grading_schema_cd IN VARCHAR2,
x_translated_version_number IN NUMBER,
x_translated_grade IN VARCHAR2,
x_translated_dt IN DATE,
x_mode IN VARCHAR2,
x_grading_period_cd IN VARCHAR2,
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_incomp_deadline_date IN DATE,
x_incomp_grading_schema_cd IN VARCHAR2,
x_incomp_version_number IN NUMBER,
x_incomp_default_grade IN VARCHAR2,
x_incomp_default_mark IN NUMBER,
x_comments IN VARCHAR2,
x_uoo_id IN NUMBER,
x_mark_capped_flag IN VARCHAR2,
x_release_date IN DATE,
x_manual_override_flag IN VARCHAR2,
x_show_on_academic_histry_flag IN VARCHAR2
) AS
CURSOR c IS
SELECT ROWID
FROM igs_as_su_stmptout_all
WHERE person_id = x_person_id
AND course_cd = x_course_cd
AND outcome_dt = x_outcome_dt
AND grading_period_cd = x_grading_period_cd
AND uoo_id = x_uoo_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_org_id => igs_ge_gen_003.get_org_id,
x_cal_type => x_cal_type,
x_ci_end_dt => x_ci_end_dt,
x_ci_sequence_number => x_ci_sequence_number,
x_ci_start_dt => x_ci_start_dt,
x_course_cd => x_course_cd,
x_finalised_outcome_ind => NVL (x_finalised_outcome_ind, 'N'),
x_grade => x_grade,
x_grading_schema_cd => x_grading_schema_cd,
x_mark => x_mark,
x_number_times_keyed => x_number_times_keyed,
x_outcome_dt => x_outcome_dt,
x_person_id => x_person_id,
x_s_grade_creation_method_type => x_s_grade_creation_method_type,
x_translated_dt => x_translated_dt,
x_translated_grade => x_translated_grade,
x_translated_grading_schema_cd => x_translated_grading_schema_cd,
x_translated_version_number => x_translated_version_number,
x_unit_cd => x_unit_cd,
x_version_number => x_version_number,
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_grading_period_cd => x_grading_period_cd,
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_incomp_deadline_date => x_incomp_deadline_date,
x_incomp_grading_schema_cd => x_incomp_grading_schema_cd,
x_incomp_version_number => x_incomp_version_number,
x_incomp_default_grade => x_incomp_default_grade,
x_incomp_default_mark => x_incomp_default_mark,
x_comments => x_comments,
x_uoo_id => x_uoo_id,
x_mark_capped_flag => x_mark_capped_flag,
x_release_date => x_release_date,
x_manual_override_flag => x_manual_override_flag,
x_show_on_academic_histry_flag => x_show_on_academic_histry_flag
);
INSERT INTO igs_as_su_stmptout_all
(org_id, person_id, course_cd, unit_cd,
cal_type, ci_sequence_number, ci_start_dt,
ci_end_dt, outcome_dt, grading_schema_cd,
version_number, grade, s_grade_creation_method_type,
finalised_outcome_ind, mark, number_times_keyed,
translated_grading_schema_cd, translated_version_number,
translated_grade, translated_dt, creation_date, created_by,
last_update_date, last_updated_by, last_update_login, request_id, program_id,
program_application_id, program_update_date, grading_period_cd,
attribute_category, attribute1, attribute2,
attribute3, attribute4, attribute5,
attribute6, attribute7, attribute8,
attribute9, attribute10, attribute11,
attribute12, attribute13, attribute14,
attribute15, attribute16, attribute17,
attribute18, attribute19, attribute20,
incomp_deadline_date, incomp_grading_schema_cd,
incomp_version_number, incomp_default_grade,
incomp_default_mark, comments, uoo_id,
mark_capped_flag, release_date, manual_override_flag,
show_on_academic_histry_flag)
VALUES (new_references.org_id, new_references.person_id, new_references.course_cd, new_references.unit_cd,
new_references.cal_type, new_references.ci_sequence_number, new_references.ci_start_dt,
new_references.ci_end_dt, new_references.outcome_dt, new_references.grading_schema_cd,
new_references.version_number, new_references.grade, new_references.s_grade_creation_method_type,
new_references.finalised_outcome_ind, new_references.mark, new_references.number_times_keyed,
new_references.translated_grading_schema_cd, new_references.translated_version_number,
new_references.translated_grade, new_references.translated_dt, 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.grading_period_cd,
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,
new_references.incomp_deadline_date, new_references.incomp_grading_schema_cd,
new_references.incomp_version_number, new_references.incomp_default_grade,
new_references.incomp_default_mark, new_references.comments, new_references.uoo_id,
new_references.mark_capped_flag, new_references.release_date, new_references.manual_override_flag,
new_references.show_on_academic_histry_flag);
after_dml (p_action => 'INSERT', x_rowid => x_rowid);
END insert_row;
SELECT ci_start_dt,
ci_end_dt,
grading_schema_cd,
version_number,
grade,
s_grade_creation_method_type,
finalised_outcome_ind,
mark,
number_times_keyed,
translated_grading_schema_cd,
translated_version_number,
translated_grade,
translated_dt,
grading_period_cd,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
incomp_deadline_date,
incomp_grading_schema_cd,
incomp_version_number,
incomp_default_grade,
incomp_default_mark,
comments,
uoo_id,
mark_capped_flag,
release_date,
manual_override_flag,
show_on_academic_histry_flag
FROM igs_as_su_stmptout_all
WHERE ROWID = x_rowid
FOR UPDATE NOWAIT;
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
PROCEDURE update_row (
x_rowid IN VARCHAR2,
x_person_id IN NUMBER,
x_course_cd IN VARCHAR2,
x_unit_cd IN VARCHAR2,
x_cal_type IN VARCHAR2,
x_ci_sequence_number IN NUMBER,
x_outcome_dt IN DATE,
x_ci_start_dt IN DATE,
x_ci_end_dt IN DATE,
x_grading_schema_cd IN VARCHAR2,
x_version_number IN NUMBER,
x_grade IN VARCHAR2,
x_s_grade_creation_method_type IN VARCHAR2,
x_finalised_outcome_ind IN VARCHAR2,
x_mark IN NUMBER,
x_number_times_keyed IN NUMBER,
x_translated_grading_schema_cd IN VARCHAR2,
x_translated_version_number IN NUMBER,
x_translated_grade IN VARCHAR2,
x_translated_dt IN DATE,
x_mode IN VARCHAR2,
x_grading_period_cd IN VARCHAR2,
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_incomp_deadline_date IN DATE,
x_incomp_grading_schema_cd IN VARCHAR2,
x_incomp_version_number IN NUMBER,
x_incomp_default_grade IN VARCHAR2,
x_incomp_default_mark IN NUMBER,
x_comments IN VARCHAR2,
x_uoo_id IN NUMBER,
x_mark_capped_flag IN VARCHAR2,
x_release_date IN DATE,
x_manual_override_flag IN VARCHAR2,
x_show_on_academic_histry_flag IN VARCHAR2
) AS
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_cal_type => x_cal_type,
x_ci_end_dt => x_ci_end_dt,
x_ci_sequence_number => x_ci_sequence_number,
x_ci_start_dt => x_ci_start_dt,
x_course_cd => x_course_cd,
x_finalised_outcome_ind => x_finalised_outcome_ind,
x_grade => x_grade,
x_grading_schema_cd => x_grading_schema_cd,
x_mark => x_mark,
x_number_times_keyed => x_number_times_keyed,
x_outcome_dt => x_outcome_dt,
x_person_id => x_person_id,
x_s_grade_creation_method_type => x_s_grade_creation_method_type,
x_translated_dt => x_translated_dt,
x_translated_grade => x_translated_grade,
x_translated_grading_schema_cd => x_translated_grading_schema_cd,
x_translated_version_number => x_translated_version_number,
x_unit_cd => x_unit_cd,
x_version_number => x_version_number,
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_grading_period_cd => x_grading_period_cd,
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_incomp_deadline_date => x_incomp_deadline_date,
x_incomp_grading_schema_cd => x_incomp_grading_schema_cd,
x_incomp_version_number => x_incomp_version_number,
x_incomp_default_grade => x_incomp_default_grade,
x_incomp_default_mark => x_incomp_default_mark,
x_comments => x_comments,
x_uoo_id => x_uoo_id,
x_mark_capped_flag => x_mark_capped_flag,
x_release_date => x_release_date,
x_manual_override_flag => x_manual_override_flag,
x_show_on_academic_histry_flag => x_show_on_academic_histry_flag
);
x_program_update_date := old_references.program_update_date;
x_program_update_date := SYSDATE;
UPDATE igs_as_su_stmptout_all
SET ci_start_dt = new_references.ci_start_dt,
ci_end_dt = new_references.ci_end_dt,
grading_schema_cd = new_references.grading_schema_cd,
version_number = new_references.version_number,
grade = new_references.grade,
s_grade_creation_method_type = new_references.s_grade_creation_method_type,
finalised_outcome_ind = new_references.finalised_outcome_ind,
mark = new_references.mark,
number_times_keyed = new_references.number_times_keyed,
translated_grading_schema_cd = new_references.translated_grading_schema_cd,
translated_version_number = new_references.translated_version_number,
translated_grade = new_references.translated_grade,
translated_dt = new_references.translated_dt,
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 = x_program_application_id,
program_update_date = x_program_update_date,
grading_period_cd = x_grading_period_cd,
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,
incomp_deadline_date = new_references.incomp_deadline_date,
incomp_grading_schema_cd = new_references.incomp_grading_schema_cd,
incomp_version_number = new_references.incomp_version_number,
incomp_default_grade = new_references.incomp_default_grade,
incomp_default_mark = new_references.incomp_default_mark,
comments = new_references.comments,
mark_capped_flag = new_references.mark_capped_flag,
release_date = new_references.release_date,
manual_override_flag = new_references.manual_override_flag,
show_on_academic_histry_flag = new_references.show_on_academic_histry_flag
WHERE ROWID = x_rowid;
after_dml (p_action => 'UPDATE', x_rowid => x_rowid);
END update_row;
SELECT ROWID
FROM igs_as_su_stmptout_all
WHERE person_id = x_person_id
AND course_cd = x_course_cd
AND outcome_dt = x_outcome_dt
AND grading_period_cd = x_grading_period_cd
AND uoo_id = x_uoo_id;
insert_row (
x_rowid,
x_org_id,
x_person_id,
x_course_cd,
x_unit_cd,
x_cal_type,
x_ci_sequence_number,
x_outcome_dt,
x_ci_start_dt,
x_ci_end_dt,
x_grading_schema_cd,
x_version_number,
x_grade,
x_s_grade_creation_method_type,
x_finalised_outcome_ind,
x_mark,
x_number_times_keyed,
x_translated_grading_schema_cd,
x_translated_version_number,
x_translated_grade,
x_translated_dt,
x_mode,
x_grading_period_cd,
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_incomp_deadline_date,
x_incomp_grading_schema_cd,
x_incomp_version_number,
x_incomp_default_grade,
x_incomp_default_mark,
x_comments,
x_uoo_id,
x_mark_capped_flag,
x_release_date,
x_manual_override_flag,
x_show_on_academic_histry_flag
);
update_row (
x_rowid,
x_person_id,
x_course_cd,
x_unit_cd,
x_cal_type,
x_ci_sequence_number,
x_outcome_dt,
x_ci_start_dt,
x_ci_end_dt,
x_grading_schema_cd,
x_version_number,
x_grade,
x_s_grade_creation_method_type,
x_finalised_outcome_ind,
x_mark,
x_number_times_keyed,
x_translated_grading_schema_cd,
x_translated_version_number,
x_translated_grade,
x_translated_dt,
x_mode,
x_grading_period_cd,
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_incomp_deadline_date,
x_incomp_grading_schema_cd,
x_incomp_version_number,
x_incomp_default_grade,
x_incomp_default_mark,
x_comments,
x_uoo_id,
x_mark_capped_flag,
x_release_date,
x_manual_override_flag,
x_show_on_academic_histry_flag
);
PROCEDURE delete_row (x_rowid IN VARCHAR2,
x_mode IN VARCHAR2) AS
BEGIN
before_dml (p_action => 'DELETE', x_rowid => x_rowid);
DELETE FROM igs_as_su_stmptout_all
WHERE ROWID = x_rowid;
after_dml (p_action => 'DELETE', x_rowid => x_rowid);
END delete_row;