APPS.IGS_EN_GEN_001 dependencies on IGS_EN_STDNT_PS_ATT

Line 112: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

108: DECLARE
109: v_cal_type IGS_CA_INST.cal_type%TYPE;
110: v_sequence_number NUMBER(6);
111: CURSOR c_sca(
112: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
113: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
114: SELECT IGS_EN_STDNT_PS_ATT.cal_type
115: FROM IGS_EN_STDNT_PS_ATT
116: WHERE person_id = cp_person_id AND

Line 113: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

109: v_cal_type IGS_CA_INST.cal_type%TYPE;
110: v_sequence_number NUMBER(6);
111: CURSOR c_sca(
112: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
113: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
114: SELECT IGS_EN_STDNT_PS_ATT.cal_type
115: FROM IGS_EN_STDNT_PS_ATT
116: WHERE person_id = cp_person_id AND
117: course_cd = cp_course_cd;

Line 114: SELECT IGS_EN_STDNT_PS_ATT.cal_type

110: v_sequence_number NUMBER(6);
111: CURSOR c_sca(
112: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
113: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
114: SELECT IGS_EN_STDNT_PS_ATT.cal_type
115: FROM IGS_EN_STDNT_PS_ATT
116: WHERE person_id = cp_person_id AND
117: course_cd = cp_course_cd;
118: BEGIN

Line 115: FROM IGS_EN_STDNT_PS_ATT

111: CURSOR c_sca(
112: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
113: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
114: SELECT IGS_EN_STDNT_PS_ATT.cal_type
115: FROM IGS_EN_STDNT_PS_ATT
116: WHERE person_id = cp_person_id AND
117: course_cd = cp_course_cd;
118: BEGIN
119: -- calculates the current academic period in which the nominated student IGS_PS_COURSE

Line 121: -- from the IGS_EN_STDNT_PS_ATT and passed to the ENRP_CLC_CRRNT_ACAD

117: course_cd = cp_course_cd;
118: BEGIN
119: -- calculates the current academic period in which the nominated student IGS_PS_COURSE
120: -- attempt is enrolling as at the nominated date. The cal_type is selected
121: -- from the IGS_EN_STDNT_PS_ATT and passed to the ENRP_CLC_CRRNT_ACAD
122: -- routine to determine the appropriate instance of that cal_type.
123: OPEN c_sca(
124: p_person_id,
125: p_course_cd);

Line 192: v_origin_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;

188: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
189: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
190: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
191: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
192: v_origin_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
193:
194: CURSOR c_sua_uv IS
195: SELECT sua.person_id,
196: sua.course_cd,