[Home] [Help]
2697: FUNCTION test_grade (cp_c_grade IN VARCHAR2) RETURN BINARY_INTEGER IS
2698: --Gets the grades assigned to the student (person_id) for the admission test (cp_c_grade)
2699: CURSOR c_tst_grade (cp_n_person_id IN NUMBER, cp_c_grade IN VARCHAR2) IS
2700: SELECT DISTINCT B.NAME GRADE
2701: FROM IGS_AD_TEST_RESULTS A,
2702: IGS_AD_CODE_CLASSES B
2703: WHERE A.PERSON_ID = cp_n_person_id
2704: AND A.ADMISSION_TEST_TYPE = cp_c_grade
2705: AND A.GRADE_ID IS NOT NULL
3076: SELECT d.unit_cd
3077: FROM igs_ad_up_detail d
3078: WHERE EXISTS (
3079: SELECT 'x'
3080: FROM igs_ad_test_results atr,
3081: igs_ad_up_header h
3082: WHERE atr.person_id = p_person_id
3083: AND atr.admission_test_type = h.admission_test_type
3084: AND h.up_header_id = d.up_header_id);
3103: CURSOR cur_test(cp_person_id igs_pe_person.person_id%TYPE,
3104: cp_admission_test_type igs_ad_up_header.admission_test_type%TYPE,
3105: cp_min_score igs_ad_up_header.min_score%TYPE,
3106: cp_max_score igs_ad_up_header.max_score%TYPE ) IS
3107: SELECT '1' FROM IGS_AD_TEST_RESULTS
3108: WHERE person_id = cp_person_id
3109: AND admission_test_type = cp_admission_test_type
3110: AND NVL(comp_test_score,0) BETWEEN cp_min_score AND cp_max_score;
3111: --
3113: cp_admission_test_type igs_ad_up_header.admission_test_type%TYPE,
3114: cp_test_segment_id igs_ad_up_header.test_segment_id%TYPE,
3115: cp_min_score igs_ad_up_header.min_score%TYPE,
3116: cp_max_score igs_ad_up_header.max_score%TYPE ) IS
3117: SELECT '1' FROM IGS_AD_TEST_RESULTS TST,
3118: IGS_AD_TST_RSLT_DTLS TDTL
3119: WHERE tst.person_id = cp_person_id
3120: AND tst.admission_test_type = cp_admission_test_type
3121: AND tst.test_results_id = tdtl.test_results_id