APPS.IGS_DA_XML_PKG dependencies on IGS_AS_SU_STMPTOUT

Line 68: v_mark igs_as_su_stmptout.mark%TYPE;

64: v_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
65: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
66: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
67: v_grade igs_as_grd_sch_grade.grade%TYPE;
68: v_mark igs_as_su_stmptout.mark%TYPE;
69: v_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
70: v_origin_course_cd igs_as_su_stmptout.course_cd%TYPE;
71: v_unit_cd igs_en_su_attempt.unit_cd%TYPE;
72: v_unit_version_number igs_en_su_attempt.version_number%TYPE;

Line 69: v_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;

65: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
66: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
67: v_grade igs_as_grd_sch_grade.grade%TYPE;
68: v_mark igs_as_su_stmptout.mark%TYPE;
69: v_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
70: v_origin_course_cd igs_as_su_stmptout.course_cd%TYPE;
71: v_unit_cd igs_en_su_attempt.unit_cd%TYPE;
72: v_unit_version_number igs_en_su_attempt.version_number%TYPE;
73: v_teach_cal_type igs_en_su_attempt.cal_type%TYPE;

Line 70: v_origin_course_cd igs_as_su_stmptout.course_cd%TYPE;

66: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
67: v_grade igs_as_grd_sch_grade.grade%TYPE;
68: v_mark igs_as_su_stmptout.mark%TYPE;
69: v_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
70: v_origin_course_cd igs_as_su_stmptout.course_cd%TYPE;
71: v_unit_cd igs_en_su_attempt.unit_cd%TYPE;
72: v_unit_version_number igs_en_su_attempt.version_number%TYPE;
73: v_teach_cal_type igs_en_su_attempt.cal_type%TYPE;
74: v_teach_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE;

Line 803: FROM igs_as_grd_sch_grade gsg, igs_as_su_stmptout_all suao

799: ) RETURN VARCHAR2 AS
800: --
801: CURSOR suao_gsg_cur is
802: SELECT suao.grade, gsg.grade valid_grade, gsg.repeat_grade
803: FROM igs_as_grd_sch_grade gsg, igs_as_su_stmptout_all suao
804: WHERE
805: suao.unit_cd = p_unit_cd
806: AND suao.finalised_outcome_ind = 'Y'
807: AND suao.grade = gsg.grade

Line 818: grade igs_as_su_stmptout_all.grade%TYPE,

814: AND suao.ci_sequence_number = p_teach_ci_sequence_number;
815:
816: l_suao_gsg_rec suao_gsg_cur%ROWTYPE;
817: TYPE r_suao_gsg_rec IS RECORD (
818: grade igs_as_su_stmptout_all.grade%TYPE,
819: valid_grade igs_as_grd_sch_grade.grade%TYPE,
820: repeat_grade igs_as_grd_sch_grade.repeat_grade%TYPE
821: );
822: TYPE t_suao_gsg_table IS TABLE OF r_suao_gsg_rec INDEX BY BINARY_INTEGER;