5135: FROM IGS_PR_RULE pr
5136: WHERE pr.progression_rule_cat = cp_progression_rule_cat AND
5137: pr.progression_rule_cd = cp_progression_rule_cd;
5138: CURSOR c_sprc (
5139: cp_progression_rule_cat IGS_PR_SDT_PR_RU_CK.progression_rule_cat%TYPE,
5140: cp_pra_sequence_number IGS_PR_SDT_PR_RU_CK.pra_sequence_number%TYPE) IS
5141: SELECT sprc.passed_ind
5142: FROM IGS_PR_SDT_PR_RU_CK sprc
5143: WHERE sprc.person_id = p_person_id AND
5136: WHERE pr.progression_rule_cat = cp_progression_rule_cat AND
5137: pr.progression_rule_cd = cp_progression_rule_cd;
5138: CURSOR c_sprc (
5139: cp_progression_rule_cat IGS_PR_SDT_PR_RU_CK.progression_rule_cat%TYPE,
5140: cp_pra_sequence_number IGS_PR_SDT_PR_RU_CK.pra_sequence_number%TYPE) IS
5141: SELECT sprc.passed_ind
5142: FROM IGS_PR_SDT_PR_RU_CK sprc
5143: WHERE sprc.person_id = p_person_id AND
5144: sprc.course_cd = p_course_cd AND
5138: CURSOR c_sprc (
5139: cp_progression_rule_cat IGS_PR_SDT_PR_RU_CK.progression_rule_cat%TYPE,
5140: cp_pra_sequence_number IGS_PR_SDT_PR_RU_CK.pra_sequence_number%TYPE) IS
5141: SELECT sprc.passed_ind
5142: FROM IGS_PR_SDT_PR_RU_CK sprc
5143: WHERE sprc.person_id = p_person_id AND
5144: sprc.course_cd = p_course_cd AND
5145: sprc.prg_cal_type = p_prg_cal_type AND
5146: sprc.prg_ci_sequence_number = p_prg_sequence_number AND
5289: OPEN c_decode2;
5290: FETCH c_decode2 INTO v_decode_val1;
5291: CLOSE c_decode2;
5292: l_org_id := igs_ge_gen_003.get_org_id;
5293: IGS_PR_SDT_PR_RU_CK_PKG.INSERT_ROW (
5294: X_ROWID => lv_rowid,
5295: x_PERSON_ID =>p_person_id,
5296: x_COURSE_CD =>p_course_cd,
5297: x_PRG_CAL_TYPE =>p_prg_cal_type,