eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_DA_XML_PKG dependencies on IGS_AS_GRD_SCH_GRADE

Line 64: v_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;

60: v_init_msg_list VARCHAR2(20):= FND_API.G_TRUE;
61: v_return_status VARCHAR2(1);
62: v_msg_count NUMBER;
63: v_msg_data VARCHAR2(2000);
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;

Line 65: v_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;

61: v_return_status VARCHAR2(1);
62: v_msg_count NUMBER;
63: v_msg_data VARCHAR2(2000);
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;

Line 66: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;

62: v_msg_count NUMBER;
63: v_msg_data VARCHAR2(2000);
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;

Line 67: v_grade igs_as_grd_sch_grade.grade%TYPE;

63: v_msg_data VARCHAR2(2000);
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;

Line 88: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,

84: AND sua.course_cd = p_course_cd
85: AND sua.uoo_id = p_uoo_id;
86: --
87: CURSOR c_gsg (
88: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
89: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,
90: cp_grade igs_as_grd_sch_grade.grade%TYPE
91: ) IS
92: SELECT 'X'

Line 89: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,

85: AND sua.uoo_id = p_uoo_id;
86: --
87: CURSOR c_gsg (
88: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
89: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,
90: cp_grade igs_as_grd_sch_grade.grade%TYPE
91: ) IS
92: SELECT 'X'
93: FROM igs_as_grd_sch_grade gsg

Line 90: cp_grade igs_as_grd_sch_grade.grade%TYPE

86: --
87: CURSOR c_gsg (
88: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
89: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,
90: cp_grade igs_as_grd_sch_grade.grade%TYPE
91: ) IS
92: SELECT 'X'
93: FROM igs_as_grd_sch_grade gsg
94: WHERE cp_grading_schema_cd = gsg.grading_schema_cd

Line 93: FROM igs_as_grd_sch_grade gsg

89: cp_version_number igs_as_grd_sch_grade.version_number%TYPE,
90: cp_grade igs_as_grd_sch_grade.grade%TYPE
91: ) IS
92: SELECT 'X'
93: FROM igs_as_grd_sch_grade gsg
94: WHERE cp_grading_schema_cd = gsg.grading_schema_cd
95: AND cp_version_number = gsg.version_number
96: AND cp_grade = gsg.grade
97: AND gsg.show_on_official_ntfctn_ind = 'Y';

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 819: valid_grade igs_as_grd_sch_grade.grade%TYPE,

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;
823: suao_gsg_table t_suao_gsg_table;

Line 820: repeat_grade igs_as_grd_sch_grade.repeat_grade%TYPE

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;
823: suao_gsg_table t_suao_gsg_table;
824: --