APPS.IGS_AS_FINALIZE_GRADE dependencies on IGS_CA_INST

Line 1149: v_acad_cal_type igs_ca_inst.cal_type%TYPE;

1145: -- for a given Student Unit Attempt Outcome
1146: --
1147: DECLARE
1148: v_message_name VARCHAR2 (30) DEFAULT NULL;
1149: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
1150: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1151: v_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1152: v_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1153: v_alt_cd igs_ca_inst.alternate_code%TYPE;

Line 1150: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1146: --
1147: DECLARE
1148: v_message_name VARCHAR2 (30) DEFAULT NULL;
1149: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
1150: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1151: v_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1152: v_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1153: v_alt_cd igs_ca_inst.alternate_code%TYPE;
1154: v_pop_grading_schema_cd igs_ps_ofr_pat.grading_schema_cd%TYPE;

Line 1151: v_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;

1147: DECLARE
1148: v_message_name VARCHAR2 (30) DEFAULT NULL;
1149: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
1150: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1151: v_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1152: v_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1153: v_alt_cd igs_ca_inst.alternate_code%TYPE;
1154: v_pop_grading_schema_cd igs_ps_ofr_pat.grading_schema_cd%TYPE;
1155: v_pop_gs_version_number igs_ps_ofr_pat.gs_version_number%TYPE;

Line 1152: v_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;

1148: v_message_name VARCHAR2 (30) DEFAULT NULL;
1149: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
1150: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1151: v_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1152: v_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1153: v_alt_cd igs_ca_inst.alternate_code%TYPE;
1154: v_pop_grading_schema_cd igs_ps_ofr_pat.grading_schema_cd%TYPE;
1155: v_pop_gs_version_number igs_ps_ofr_pat.gs_version_number%TYPE;
1156: v_gsgt_to_grade igs_as_grd_sch_trn.to_grade%TYPE;

Line 1153: v_alt_cd igs_ca_inst.alternate_code%TYPE;

1149: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
1150: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1151: v_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1152: v_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1153: v_alt_cd igs_ca_inst.alternate_code%TYPE;
1154: v_pop_grading_schema_cd igs_ps_ofr_pat.grading_schema_cd%TYPE;
1155: v_pop_gs_version_number igs_ps_ofr_pat.gs_version_number%TYPE;
1156: v_gsgt_to_grade igs_as_grd_sch_trn.to_grade%TYPE;
1157: v_key_allow_invalid_ind igs_as_entry_conf.key_allow_invalid_ind%TYPE;

Line 1159: cp_acad_cal_type igs_ca_inst.cal_type%TYPE,

1155: v_pop_gs_version_number igs_ps_ofr_pat.gs_version_number%TYPE;
1156: v_gsgt_to_grade igs_as_grd_sch_trn.to_grade%TYPE;
1157: v_key_allow_invalid_ind igs_as_entry_conf.key_allow_invalid_ind%TYPE;
1158: CURSOR c_sua_sca_uoo_pop (
1159: cp_acad_cal_type igs_ca_inst.cal_type%TYPE,
1160: cp_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE
1161: ) IS
1162: SELECT gs.grading_schema_cd,
1163: gs.version_number,

Line 1160: cp_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE

1156: v_gsgt_to_grade igs_as_grd_sch_trn.to_grade%TYPE;
1157: v_key_allow_invalid_ind igs_as_entry_conf.key_allow_invalid_ind%TYPE;
1158: CURSOR c_sua_sca_uoo_pop (
1159: cp_acad_cal_type igs_ca_inst.cal_type%TYPE,
1160: cp_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE
1161: ) IS
1162: SELECT gs.grading_schema_cd,
1163: gs.version_number,
1164: ec.key_allow_invalid_ind