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_PR_ACAD_DETAILS dependencies on IGS_PR_ORG_STAT

Line 62: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

58: p_version_number IN igs_en_su_attempt.version_number%TYPE,
59: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
60: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
61: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
62: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
63: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
64: );
65:
66: PROCEDURE populate_load_table

Line 72: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

68: p_person_id IN igs_en_su_attempt.person_id%TYPE,
69: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
70: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
71: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
72: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
73: );
74: --
75: -- kdande; 23-Apr-2003; Bug# 2829262
76: -- Added p_uoo_id parameter to the FUNCTION get_sua_gpa

Line 87: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

83: p_version_number IN igs_en_su_attempt.version_number%TYPE,
84: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
85: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
86: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
87: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
88: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
89: ) RETURN NUMBER;
90: --
91: -- kdande; 23-Apr-2003; Bug# 2829262

Line 103: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

99: p_version_number IN igs_en_su_attempt.version_number%TYPE,
100: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
101: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
102: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
103: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
104: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
105: ) RETURN NUMBER;
106: --
107: -- kdande; 23-Apr-2003; Bug# 2829262

Line 119: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

115: p_version_number IN igs_en_su_attempt.version_number%TYPE,
116: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
117: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%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: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
121: ) RETURN NUMBER;
122: --
123: -- kdande; 23-Apr-2003; Bug# 2829262

Line 135: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

131: p_version_number IN igs_en_su_attempt.version_number%TYPE,
132: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
133: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
134: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
135: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
136: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
137: ) RETURN NUMBER;
138: --
139: -- kdande; 23-Apr-2003; Bug# 2829262

Line 151: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

147: p_version_number IN igs_en_su_attempt.version_number%TYPE,
148: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
149: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
150: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
151: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
152: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
153: ) RETURN NUMBER;
154: --
155: -- kdande; 23-Apr-2003; Bug# 2829262

Line 167: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

163: p_version_number IN igs_en_su_attempt.version_number%TYPE,
164: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
165: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
166: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
167: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
168: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
169: ) RETURN VARCHAR2;
170: --
171: -- kdande; 23-Apr-2003; Bug# 2829262

Line 183: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,

179: p_version_number IN igs_en_su_attempt.version_number%TYPE,
180: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
181: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
182: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
183: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL,
184: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE DEFAULT NULL
185: ) RETURN NUMBER;
186:
187: FUNCTION get_sua_yop

Line 201: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

197: p_person_id IN igs_en_su_attempt.person_id%TYPE,
198: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
199: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
200: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
201: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
202: ) RETURN NUMBER;
203:
204: FUNCTION get_load_gpa_cp
205: (

Line 210: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

206: p_person_id IN igs_en_su_attempt.person_id%TYPE,
207: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
208: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
209: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
210: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
211: ) RETURN NUMBER;
212:
213: FUNCTION get_load_gpa_qp
214: (

Line 219: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

215: p_person_id IN igs_en_su_attempt.person_id%TYPE,
216: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
217: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
218: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
219: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
220: ) RETURN NUMBER;
221:
222: FUNCTION get_load_earned_cp
223: (

Line 228: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

224: p_person_id IN igs_en_su_attempt.person_id%TYPE,
225: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
226: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
227: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
228: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
229: ) RETURN NUMBER;
230:
231: FUNCTION get_load_attempted_cp
232: (

Line 237: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

233: p_person_id IN igs_en_su_attempt.person_id%TYPE,
234: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
235: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
236: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
237: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
238: ) RETURN NUMBER;
239:
240: FUNCTION get_cum_gpa
241: (

Line 246: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

242: p_person_id IN igs_en_su_attempt.person_id%TYPE,
243: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
244: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
245: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
246: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
247: ) RETURN NUMBER;
248:
249: FUNCTION get_cum_gpa_cp
250: (

Line 255: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

251: p_person_id IN igs_en_su_attempt.person_id%TYPE,
252: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
253: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
254: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
255: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
256: ) RETURN NUMBER;
257:
258: FUNCTION get_cum_gpa_qp
259: (

Line 264: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

260: p_person_id IN igs_en_su_attempt.person_id%TYPE,
261: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
262: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
263: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
264: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
265: ) RETURN NUMBER;
266:
267: FUNCTION get_cum_earned_cp
268: (

Line 273: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

269: p_person_id IN igs_en_su_attempt.person_id%TYPE,
270: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
271: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
272: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
273: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
274: ) RETURN NUMBER;
275:
276: FUNCTION get_cum_attempted_cp
277: (

Line 282: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL

278: p_person_id IN igs_en_su_attempt.person_id%TYPE,
279: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
280: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
281: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
282: p_stat_type IN igs_pr_org_stat.stat_type%TYPE DEFAULT NULL
283: ) RETURN NUMBER;
284:
285: END IGS_PR_ACAD_DETAILS;