APPS.IGS_AS_ADI_UPLD_AIO_PKG dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 621: CURSOR c_assessment_id (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

617: WHERE hzp.party_number = p_person_number;
618: --
619: --
620: --
621: CURSOR c_assessment_id (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
622: SELECT ai.ass_id,
623: gs.grading_schema_cd,
624: gs.version_number
625: FROM igs_as_assessmnt_itm ai,

Line 669: cp_cal_type igs_en_su_attempt_all.cal_type%TYPE,

665: --
666: --
667: --
668: CURSOR c_uoo_id (
669: cp_cal_type igs_en_su_attempt_all.cal_type%TYPE,
670: cp_ci_sequence_number igs_en_su_attempt_all.ci_sequence_number%TYPE,
671: cp_person_id hz_parties.party_id%TYPE
672: ) IS
673: SELECT uoo_id

Line 670: cp_ci_sequence_number igs_en_su_attempt_all.ci_sequence_number%TYPE,

666: --
667: --
668: CURSOR c_uoo_id (
669: cp_cal_type igs_en_su_attempt_all.cal_type%TYPE,
670: cp_ci_sequence_number igs_en_su_attempt_all.ci_sequence_number%TYPE,
671: cp_person_id hz_parties.party_id%TYPE
672: ) IS
673: SELECT uoo_id
674: FROM igs_en_su_attempt_all

Line 674: FROM igs_en_su_attempt_all

670: cp_ci_sequence_number igs_en_su_attempt_all.ci_sequence_number%TYPE,
671: cp_person_id hz_parties.party_id%TYPE
672: ) IS
673: SELECT uoo_id
674: FROM igs_en_su_attempt_all
675: WHERE unit_cd = p_unit_cd
676: AND cal_type = cp_cal_type
677: AND ci_sequence_number = cp_ci_sequence_number
678: AND person_id = cp_person_id

Line 694: cp_person_id igs_en_su_attempt_all.person_id%TYPE,

690: --
691: --
692: --
693: CURSOR c_unit_enroll_status (
694: cp_person_id igs_en_su_attempt_all.person_id%TYPE,
695: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
696: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE
697: ) IS
698: SELECT unit_attempt_status

Line 695: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,

691: --
692: --
693: CURSOR c_unit_enroll_status (
694: cp_person_id igs_en_su_attempt_all.person_id%TYPE,
695: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
696: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE
697: ) IS
698: SELECT unit_attempt_status
699: FROM igs_en_su_attempt_all

Line 696: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE

692: --
693: CURSOR c_unit_enroll_status (
694: cp_person_id igs_en_su_attempt_all.person_id%TYPE,
695: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
696: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE
697: ) IS
698: SELECT unit_attempt_status
699: FROM igs_en_su_attempt_all
700: WHERE person_id = cp_person_id

Line 699: FROM igs_en_su_attempt_all

695: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
696: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE
697: ) IS
698: SELECT unit_attempt_status
699: FROM igs_en_su_attempt_all
700: WHERE person_id = cp_person_id
701: AND course_cd = cp_course_cd
702: AND uoo_id = cp_uoo_id;
703: --

Line 707: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,

703: --
704: --
705: --
706: CURSOR c_ass_item_exist (
707: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
708: cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE,
709: cp_person_id hz_parties.party_id%TYPE,
710: cp_reference VARCHAR2
711: ) IS

Line 724: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,

720: --
721: --
722: --
723: CURSOR c_ass_item_grade_exist (
724: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
725: cp_person_id hz_parties.party_id%TYPE,
726: cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE,
727: cp_reference VARCHAR2
728: ) IS