APPS.IGS_AS_FINALIZE_GRADE dependencies on IGS_PS_OFR_PAT

Line 1154: v_pop_grading_schema_cd igs_ps_ofr_pat.grading_schema_cd%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;
1158: CURSOR c_sua_sca_uoo_pop (

Line 1155: v_pop_gs_version_number igs_ps_ofr_pat.gs_version_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;
1158: CURSOR c_sua_sca_uoo_pop (
1159: cp_acad_cal_type igs_ca_inst.cal_type%TYPE,

Line 1181: FROM igs_ps_ofr_pat pop

1177: AND sua.uoo_id = p_uoo_id
1178: AND spa.person_id = sua.person_id
1179: AND spa.course_cd = sua.course_cd
1180: AND (EXISTS ( SELECT 'X'
1181: FROM igs_ps_ofr_pat pop
1182: WHERE pop.coo_id = spa.coo_id
1183: AND pop.cal_type = cp_acad_cal_type
1184: AND pop.ci_sequence_number = cp_acad_ci_sequence_number
1185: AND uoo.grading_schema_prcdnce_ind = 'N'

Line 1201: cp_pop_grading_schema_cd igs_ps_ofr_pat.grading_schema_cd%TYPE,

1197: --
1198: --
1199: --
1200: CURSOR c_gsgt (
1201: cp_pop_grading_schema_cd igs_ps_ofr_pat.grading_schema_cd%TYPE,
1202: cp_pop_gs_version_number igs_ps_ofr_pat.gs_version_number%TYPE
1203: ) IS
1204: SELECT gsgt.to_grade
1205: FROM igs_as_grd_sch_trn gsgt

Line 1202: cp_pop_gs_version_number igs_ps_ofr_pat.gs_version_number%TYPE

1198: --
1199: --
1200: CURSOR c_gsgt (
1201: cp_pop_grading_schema_cd igs_ps_ofr_pat.grading_schema_cd%TYPE,
1202: cp_pop_gs_version_number igs_ps_ofr_pat.gs_version_number%TYPE
1203: ) IS
1204: SELECT gsgt.to_grade
1205: FROM igs_as_grd_sch_trn gsgt
1206: WHERE gsgt.grading_schema_cd = p_grading_schema_cd

Line 1215: -- that IGS_PS_OFR_PAT.grading_schema_cd is not null for the student

1211: BEGIN
1212: --
1213: -- Translation
1214: -- Verify that the IGS_PS_UNIT_OFR_OPT.grading_schema_prcdnce_ind = 'N' and
1215: -- that IGS_PS_OFR_PAT.grading_schema_cd is not null for the student
1216: -- unit attempt and get the IGS_PS_COURSE offering pattern grading schema that will
1217: -- be used in the translation. Otherwise return NULL as no translation possible.
1218: --
1219: p_translated_dt := SYSDATE;