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.

APPS.IGS_DA_XML_PKG dependencies on IGS_EN_SU_ATTEMPT

Line 5: person_id igs_en_su_attempt.person_id%TYPE,

1: PACKAGE IGS_DA_XML_PKG AS
2: /* $Header: IGSDA10S.pls 120.0 2005/07/05 11:41:31 appldev noship $ */
3:
4: TYPE r_sua_record IS RECORD (
5: person_id igs_en_su_attempt.person_id%TYPE,
6: course_cd igs_en_su_attempt.course_cd%TYPE,
7: uoo_id igs_en_su_attempt.uoo_id%TYPE,
8: grade igs_as_su_stmptout.grade%TYPE,
9: mark igs_as_su_stmptout.mark%TYPE,

Line 6: course_cd igs_en_su_attempt.course_cd%TYPE,

2: /* $Header: IGSDA10S.pls 120.0 2005/07/05 11:41:31 appldev noship $ */
3:
4: TYPE r_sua_record IS RECORD (
5: person_id igs_en_su_attempt.person_id%TYPE,
6: course_cd igs_en_su_attempt.course_cd%TYPE,
7: uoo_id igs_en_su_attempt.uoo_id%TYPE,
8: grade igs_as_su_stmptout.grade%TYPE,
9: mark igs_as_su_stmptout.mark%TYPE,
10: s_result_type igs_as_grd_sch_grade.s_result_type%TYPE,

Line 7: uoo_id igs_en_su_attempt.uoo_id%TYPE,

3:
4: TYPE r_sua_record IS RECORD (
5: person_id igs_en_su_attempt.person_id%TYPE,
6: course_cd igs_en_su_attempt.course_cd%TYPE,
7: uoo_id igs_en_su_attempt.uoo_id%TYPE,
8: grade igs_as_su_stmptout.grade%TYPE,
9: mark igs_as_su_stmptout.mark%TYPE,
10: s_result_type igs_as_grd_sch_grade.s_result_type%TYPE,
11: gpa igs_as_grd_sch_grade.gpa_val%TYPE,

Line 23: person_id igs_en_su_attempt.person_id%TYPE,

19:
20: sua_table t_sua_table;
21:
22: TYPE r_load_record IS RECORD (
23: person_id igs_en_su_attempt.person_id%TYPE,
24: course_cd igs_en_su_attempt.course_cd%TYPE,
25: load_cal_type igs_en_su_attempt.cal_type%TYPE,
26: load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
27: cum_gpa igs_as_grd_sch_grade.gpa_val%TYPE,

Line 24: course_cd igs_en_su_attempt.course_cd%TYPE,

20: sua_table t_sua_table;
21:
22: TYPE r_load_record IS RECORD (
23: person_id igs_en_su_attempt.person_id%TYPE,
24: course_cd igs_en_su_attempt.course_cd%TYPE,
25: load_cal_type igs_en_su_attempt.cal_type%TYPE,
26: load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
27: cum_gpa igs_as_grd_sch_grade.gpa_val%TYPE,
28: cum_gpa_cp igs_ps_unit_ver.achievable_credit_points%TYPE,

Line 25: load_cal_type igs_en_su_attempt.cal_type%TYPE,

21:
22: TYPE r_load_record IS RECORD (
23: person_id igs_en_su_attempt.person_id%TYPE,
24: course_cd igs_en_su_attempt.course_cd%TYPE,
25: load_cal_type igs_en_su_attempt.cal_type%TYPE,
26: load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
27: cum_gpa igs_as_grd_sch_grade.gpa_val%TYPE,
28: cum_gpa_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
29: cum_gpa_qp igs_ps_unit_ver.achievable_credit_points%TYPE,

Line 26: load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

22: TYPE r_load_record IS RECORD (
23: person_id igs_en_su_attempt.person_id%TYPE,
24: course_cd igs_en_su_attempt.course_cd%TYPE,
25: load_cal_type igs_en_su_attempt.cal_type%TYPE,
26: load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
27: cum_gpa igs_as_grd_sch_grade.gpa_val%TYPE,
28: cum_gpa_cp igs_ps_unit_ver.achievable_credit_points%TYPE,
29: cum_gpa_qp igs_ps_unit_ver.achievable_credit_points%TYPE,
30: cum_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE,

Line 52: p_person_id IN igs_en_su_attempt.person_id%TYPE,

48: -----------------------------------------------------------------------------
49:
50: PROCEDURE populate_sua_table
51: (
52: p_person_id IN igs_en_su_attempt.person_id%TYPE,
53: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
54: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
55: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
56: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 53: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

49:
50: PROCEDURE populate_sua_table
51: (
52: p_person_id IN igs_en_su_attempt.person_id%TYPE,
53: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
54: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
55: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
56: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
57: );

Line 54: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

50: PROCEDURE populate_sua_table
51: (
52: p_person_id IN igs_en_su_attempt.person_id%TYPE,
53: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
54: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
55: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
56: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
57: );
58:

Line 55: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

51: (
52: p_person_id IN igs_en_su_attempt.person_id%TYPE,
53: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
54: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
55: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
56: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
57: );
58:
59: PROCEDURE populate_load_table

Line 61: p_person_id IN igs_en_su_attempt.person_id%TYPE,

57: );
58:
59: PROCEDURE populate_load_table
60: (
61: p_person_id IN igs_en_su_attempt.person_id%TYPE,
62: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
63: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
64: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
65: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 62: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

58:
59: PROCEDURE populate_load_table
60: (
61: p_person_id IN igs_en_su_attempt.person_id%TYPE,
62: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
63: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
64: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
65: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
66: );

Line 63: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

59: PROCEDURE populate_load_table
60: (
61: p_person_id IN igs_en_su_attempt.person_id%TYPE,
62: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
63: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
64: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
65: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
66: );
67:

Line 64: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

60: (
61: p_person_id IN igs_en_su_attempt.person_id%TYPE,
62: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
63: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
64: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
65: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
66: );
67:
68: FUNCTION get_sua_gpa_cp

Line 70: p_person_id IN igs_en_su_attempt.person_id%TYPE,

66: );
67:
68: FUNCTION get_sua_gpa_cp
69: (
70: p_person_id IN igs_en_su_attempt.person_id%TYPE,
71: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
72: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
73: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
74: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 71: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

67:
68: FUNCTION get_sua_gpa_cp
69: (
70: p_person_id IN igs_en_su_attempt.person_id%TYPE,
71: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
72: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
73: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
74: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
75: ) RETURN NUMBER;

Line 72: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

68: FUNCTION get_sua_gpa_cp
69: (
70: p_person_id IN igs_en_su_attempt.person_id%TYPE,
71: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
72: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
73: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
74: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
75: ) RETURN NUMBER;
76:

Line 73: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

69: (
70: p_person_id IN igs_en_su_attempt.person_id%TYPE,
71: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
72: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
73: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
74: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
75: ) RETURN NUMBER;
76:
77: FUNCTION get_sua_gpa_qp

Line 79: p_person_id IN igs_en_su_attempt.person_id%TYPE,

75: ) RETURN NUMBER;
76:
77: FUNCTION get_sua_gpa_qp
78: (
79: p_person_id IN igs_en_su_attempt.person_id%TYPE,
80: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
81: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
82: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
83: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 80: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

76:
77: FUNCTION get_sua_gpa_qp
78: (
79: p_person_id IN igs_en_su_attempt.person_id%TYPE,
80: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
81: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
82: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
83: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
84: ) RETURN NUMBER;

Line 81: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

77: FUNCTION get_sua_gpa_qp
78: (
79: p_person_id IN igs_en_su_attempt.person_id%TYPE,
80: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
81: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
82: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
83: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
84: ) RETURN NUMBER;
85:

Line 82: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

78: (
79: p_person_id IN igs_en_su_attempt.person_id%TYPE,
80: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
81: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
82: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
83: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
84: ) RETURN NUMBER;
85:
86: FUNCTION get_sua_earned_cp

Line 88: p_person_id IN igs_en_su_attempt.person_id%TYPE,

84: ) RETURN NUMBER;
85:
86: FUNCTION get_sua_earned_cp
87: (
88: p_person_id IN igs_en_su_attempt.person_id%TYPE,
89: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
90: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
91: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
92: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 89: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

85:
86: FUNCTION get_sua_earned_cp
87: (
88: p_person_id IN igs_en_su_attempt.person_id%TYPE,
89: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
90: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
91: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
92: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
93: ) RETURN NUMBER;

Line 90: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

86: FUNCTION get_sua_earned_cp
87: (
88: p_person_id IN igs_en_su_attempt.person_id%TYPE,
89: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
90: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
91: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
92: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
93: ) RETURN NUMBER;
94:

Line 91: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

87: (
88: p_person_id IN igs_en_su_attempt.person_id%TYPE,
89: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
90: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
91: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
92: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
93: ) RETURN NUMBER;
94:
95: FUNCTION get_sua_attempted_cp

Line 97: p_person_id IN igs_en_su_attempt.person_id%TYPE,

93: ) RETURN NUMBER;
94:
95: FUNCTION get_sua_attempted_cp
96: (
97: p_person_id IN igs_en_su_attempt.person_id%TYPE,
98: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
99: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
100: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
101: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 98: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

94:
95: FUNCTION get_sua_attempted_cp
96: (
97: p_person_id IN igs_en_su_attempt.person_id%TYPE,
98: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
99: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
100: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
101: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
102: ) RETURN NUMBER;

Line 99: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

95: FUNCTION get_sua_attempted_cp
96: (
97: p_person_id IN igs_en_su_attempt.person_id%TYPE,
98: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
99: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
100: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
101: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
102: ) RETURN NUMBER;
103:

Line 100: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

96: (
97: p_person_id IN igs_en_su_attempt.person_id%TYPE,
98: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
99: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
100: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
101: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
102: ) RETURN NUMBER;
103:
104: FUNCTION get_sua_grade

Line 106: p_person_id IN igs_en_su_attempt.person_id%TYPE,

102: ) RETURN NUMBER;
103:
104: FUNCTION get_sua_grade
105: (
106: p_person_id IN igs_en_su_attempt.person_id%TYPE,
107: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
108: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
109: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
110: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 107: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

103:
104: FUNCTION get_sua_grade
105: (
106: p_person_id IN igs_en_su_attempt.person_id%TYPE,
107: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
108: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
109: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
110: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
111: ) RETURN VARCHAR2;

Line 108: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

104: FUNCTION get_sua_grade
105: (
106: p_person_id IN igs_en_su_attempt.person_id%TYPE,
107: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
108: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
109: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
110: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
111: ) RETURN VARCHAR2;
112:

Line 109: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

105: (
106: p_person_id IN igs_en_su_attempt.person_id%TYPE,
107: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
108: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
109: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
110: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
111: ) RETURN VARCHAR2;
112:
113: FUNCTION get_sua_mark

Line 115: p_person_id IN igs_en_su_attempt.person_id%TYPE,

111: ) RETURN VARCHAR2;
112:
113: FUNCTION get_sua_mark
114: (
115: p_person_id IN igs_en_su_attempt.person_id%TYPE,
116: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
117: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
118: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
119: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 116: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

112:
113: FUNCTION get_sua_mark
114: (
115: p_person_id IN igs_en_su_attempt.person_id%TYPE,
116: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
117: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
118: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
119: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
120: ) RETURN NUMBER;

Line 117: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

113: FUNCTION get_sua_mark
114: (
115: p_person_id IN igs_en_su_attempt.person_id%TYPE,
116: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
117: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
118: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
119: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
120: ) RETURN NUMBER;
121:

Line 118: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

114: (
115: p_person_id IN igs_en_su_attempt.person_id%TYPE,
116: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
117: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
118: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
119: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
120: ) RETURN NUMBER;
121:
122: FUNCTION get_sua_result_type

Line 124: p_person_id IN igs_en_su_attempt.person_id%TYPE,

120: ) RETURN NUMBER;
121:
122: FUNCTION get_sua_result_type
123: (
124: p_person_id IN igs_en_su_attempt.person_id%TYPE,
125: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
126: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
127: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
128: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 125: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

121:
122: FUNCTION get_sua_result_type
123: (
124: p_person_id IN igs_en_su_attempt.person_id%TYPE,
125: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
126: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
127: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
128: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
129: ) RETURN VARCHAR2;

Line 126: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

122: FUNCTION get_sua_result_type
123: (
124: p_person_id IN igs_en_su_attempt.person_id%TYPE,
125: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
126: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
127: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
128: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
129: ) RETURN VARCHAR2;
130:

Line 127: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

123: (
124: p_person_id IN igs_en_su_attempt.person_id%TYPE,
125: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
126: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
127: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
128: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
129: ) RETURN VARCHAR2;
130:
131: FUNCTION get_cum_gpa

Line 133: p_person_id IN igs_en_su_attempt.person_id%TYPE,

129: ) RETURN VARCHAR2;
130:
131: FUNCTION get_cum_gpa
132: (
133: p_person_id IN igs_en_su_attempt.person_id%TYPE,
134: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
135: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
136: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
137: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 134: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

130:
131: FUNCTION get_cum_gpa
132: (
133: p_person_id IN igs_en_su_attempt.person_id%TYPE,
134: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
135: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
136: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
137: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
138: ) RETURN NUMBER;

Line 135: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

131: FUNCTION get_cum_gpa
132: (
133: p_person_id IN igs_en_su_attempt.person_id%TYPE,
134: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
135: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
136: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
137: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
138: ) RETURN NUMBER;
139:

Line 136: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

132: (
133: p_person_id IN igs_en_su_attempt.person_id%TYPE,
134: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
135: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
136: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
137: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
138: ) RETURN NUMBER;
139:
140: FUNCTION get_cum_gpa_cp

Line 142: p_person_id IN igs_en_su_attempt.person_id%TYPE,

138: ) RETURN NUMBER;
139:
140: FUNCTION get_cum_gpa_cp
141: (
142: p_person_id IN igs_en_su_attempt.person_id%TYPE,
143: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
144: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
145: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
146: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 143: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

139:
140: FUNCTION get_cum_gpa_cp
141: (
142: p_person_id IN igs_en_su_attempt.person_id%TYPE,
143: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
144: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
145: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
146: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
147: ) RETURN NUMBER;

Line 144: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

140: FUNCTION get_cum_gpa_cp
141: (
142: p_person_id IN igs_en_su_attempt.person_id%TYPE,
143: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
144: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
145: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
146: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
147: ) RETURN NUMBER;
148:

Line 145: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

141: (
142: p_person_id IN igs_en_su_attempt.person_id%TYPE,
143: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
144: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
145: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
146: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
147: ) RETURN NUMBER;
148:
149: FUNCTION get_cum_gpa_qp

Line 151: p_person_id IN igs_en_su_attempt.person_id%TYPE,

147: ) RETURN NUMBER;
148:
149: FUNCTION get_cum_gpa_qp
150: (
151: p_person_id IN igs_en_su_attempt.person_id%TYPE,
152: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
153: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
154: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
155: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 152: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

148:
149: FUNCTION get_cum_gpa_qp
150: (
151: p_person_id IN igs_en_su_attempt.person_id%TYPE,
152: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
153: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
154: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
155: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
156: ) RETURN NUMBER;

Line 153: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

149: FUNCTION get_cum_gpa_qp
150: (
151: p_person_id IN igs_en_su_attempt.person_id%TYPE,
152: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
153: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
154: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
155: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
156: ) RETURN NUMBER;
157:

Line 154: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

150: (
151: p_person_id IN igs_en_su_attempt.person_id%TYPE,
152: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
153: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
154: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
155: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
156: ) RETURN NUMBER;
157:
158: FUNCTION get_cum_earned_cp

Line 160: p_person_id IN igs_en_su_attempt.person_id%TYPE,

156: ) RETURN NUMBER;
157:
158: FUNCTION get_cum_earned_cp
159: (
160: p_person_id IN igs_en_su_attempt.person_id%TYPE,
161: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
162: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
163: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
164: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 161: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

157:
158: FUNCTION get_cum_earned_cp
159: (
160: p_person_id IN igs_en_su_attempt.person_id%TYPE,
161: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
162: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
163: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
164: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
165: ) RETURN NUMBER;

Line 162: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

158: FUNCTION get_cum_earned_cp
159: (
160: p_person_id IN igs_en_su_attempt.person_id%TYPE,
161: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
162: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
163: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
164: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
165: ) RETURN NUMBER;
166:

Line 163: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

159: (
160: p_person_id IN igs_en_su_attempt.person_id%TYPE,
161: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
162: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
163: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
164: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
165: ) RETURN NUMBER;
166:
167: FUNCTION get_cum_attempted_cp

Line 169: p_person_id IN igs_en_su_attempt.person_id%TYPE,

165: ) RETURN NUMBER;
166:
167: FUNCTION get_cum_attempted_cp
168: (
169: p_person_id IN igs_en_su_attempt.person_id%TYPE,
170: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
171: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
172: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
173: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 170: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

166:
167: FUNCTION get_cum_attempted_cp
168: (
169: p_person_id IN igs_en_su_attempt.person_id%TYPE,
170: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
171: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
172: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
173: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
174: ) RETURN NUMBER;

Line 171: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

167: FUNCTION get_cum_attempted_cp
168: (
169: p_person_id IN igs_en_su_attempt.person_id%TYPE,
170: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
171: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
172: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
173: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
174: ) RETURN NUMBER;
175:

Line 172: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

168: (
169: p_person_id IN igs_en_su_attempt.person_id%TYPE,
170: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
171: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
172: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
173: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
174: ) RETURN NUMBER;
175:
176: -- ====================================================================================

Line 180: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

176: -- ====================================================================================
177:
178: FUNCTION get_course_abbr_num
179: (
180: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
181: p_evaluation_type IN CHAR DEFAULT 'A'
182: ) RETURN VARCHAR2;
183:
184: FUNCTION student_type_list

Line 186: p_person_id IN igs_en_su_attempt.person_id%TYPE

182: ) RETURN VARCHAR2;
183:
184: FUNCTION student_type_list
185: (
186: p_person_id IN igs_en_su_attempt.person_id%TYPE
187: ) RETURN VARCHAR2;
188:
189:
190: FUNCTION get_unit_repeatable

Line 192: p_person_id IN igs_en_su_attempt.person_id%TYPE,

188:
189:
190: FUNCTION get_unit_repeatable
191: (
192: p_person_id IN igs_en_su_attempt.person_id%TYPE,
193: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
194: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
195: p_version_number IN igs_en_su_attempt.version_number%TYPE,
196: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 193: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

189:
190: FUNCTION get_unit_repeatable
191: (
192: p_person_id IN igs_en_su_attempt.person_id%TYPE,
193: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
194: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
195: p_version_number IN igs_en_su_attempt.version_number%TYPE,
196: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
197: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 194: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

190: FUNCTION get_unit_repeatable
191: (
192: p_person_id IN igs_en_su_attempt.person_id%TYPE,
193: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
194: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
195: p_version_number IN igs_en_su_attempt.version_number%TYPE,
196: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
197: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
198: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 195: p_version_number IN igs_en_su_attempt.version_number%TYPE,

191: (
192: p_person_id IN igs_en_su_attempt.person_id%TYPE,
193: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
194: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
195: p_version_number IN igs_en_su_attempt.version_number%TYPE,
196: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
197: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
198: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
199: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

Line 196: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

192: p_person_id IN igs_en_su_attempt.person_id%TYPE,
193: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
194: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
195: p_version_number IN igs_en_su_attempt.version_number%TYPE,
196: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
197: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
198: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
199: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
200: ) RETURN VARCHAR2;

Line 197: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

193: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
194: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
195: p_version_number IN igs_en_su_attempt.version_number%TYPE,
196: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
197: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
198: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
199: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
200: ) RETURN VARCHAR2;
201:

Line 198: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

194: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
195: p_version_number IN igs_en_su_attempt.version_number%TYPE,
196: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
197: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
198: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
199: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
200: ) RETURN VARCHAR2;
201:
202: PROCEDURE get_person_details