APPS.IGS_PR_GEN_005 dependencies on IGS_PR_SDT_PR_RU_CK

Line 577: v_passed_ind igs_pr_sdt_pr_ru_ck.passed_ind%TYPE;

573: -- calculating the number of fails.
574: DECLARE
575: cst_consecrpt CONSTANT VARCHAR2 (10) := 'CONSECRPT';
576: v_number_of_failures NUMBER DEFAULT 0;
577: v_passed_ind igs_pr_sdt_pr_ru_ck.passed_ind%TYPE;
578:
579: CURSOR c_spc IS
580: SELECT DISTINCT spc.prg_cal_type,
581: spc.prg_ci_sequence_number,

Line 601: cp_prg_cal_type igs_pr_sdt_pr_ru_ck.prg_cal_type%TYPE,

597: WHERE ci2.cal_type = p_prg_cal_type
598: AND ci2.sequence_number = p_prg_sequence_number)
599: ORDER BY ci1.start_dt DESC;
600: CURSOR c_sprc (
601: cp_prg_cal_type igs_pr_sdt_pr_ru_ck.prg_cal_type%TYPE,
602: cp_prg_ci_sequence_number igs_pr_sdt_pr_ru_ck.prg_ci_sequence_number%TYPE
603: ) IS
604: SELECT sprc.passed_ind
605: FROM igs_pr_sdt_pr_ru_ck sprc

Line 602: cp_prg_ci_sequence_number igs_pr_sdt_pr_ru_ck.prg_ci_sequence_number%TYPE

598: AND ci2.sequence_number = p_prg_sequence_number)
599: ORDER BY ci1.start_dt DESC;
600: CURSOR c_sprc (
601: cp_prg_cal_type igs_pr_sdt_pr_ru_ck.prg_cal_type%TYPE,
602: cp_prg_ci_sequence_number igs_pr_sdt_pr_ru_ck.prg_ci_sequence_number%TYPE
603: ) IS
604: SELECT sprc.passed_ind
605: FROM igs_pr_sdt_pr_ru_ck sprc
606: WHERE sprc.person_id = p_person_id

Line 605: FROM igs_pr_sdt_pr_ru_ck sprc

601: cp_prg_cal_type igs_pr_sdt_pr_ru_ck.prg_cal_type%TYPE,
602: cp_prg_ci_sequence_number igs_pr_sdt_pr_ru_ck.prg_ci_sequence_number%TYPE
603: ) IS
604: SELECT sprc.passed_ind
605: FROM igs_pr_sdt_pr_ru_ck sprc
606: WHERE sprc.person_id = p_person_id
607: AND sprc.course_cd = p_course_cd
608: AND sprc.prg_cal_type = cp_prg_cal_type
609: AND sprc.prg_ci_sequence_number = cp_prg_ci_sequence_number

Line 1246: FROM igs_pr_sdt_pr_ru_ck sprc,

1242: v_count_of_records INTEGER DEFAULT 0;
1243: CURSOR c_sprc IS
1244: SELECT DISTINCT sprc.prg_cal_type,
1245: sprc.prg_ci_sequence_number
1246: FROM igs_pr_sdt_pr_ru_ck sprc,
1247: igs_ca_inst ci1
1248: WHERE sprc.person_id = p_person_id
1249: AND sprc.course_cd = p_course_cd
1250: AND sprc.progression_rule_cat = p_progression_rule_cat