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_EN_SU_ATTEMPT

Line 10: p_person_id IN igs_en_su_attempt.person_id%TYPE,

6: -- swaghmar 15-Sep-2005 Bug# 4491456
7: --
8: PROCEDURE populate_sua_table
9: (
10: p_person_id IN igs_en_su_attempt.person_id%TYPE,
11: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
12: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
13: p_version_number IN igs_en_su_attempt.version_number%TYPE,
14: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 11: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

7: --
8: PROCEDURE populate_sua_table
9: (
10: p_person_id IN igs_en_su_attempt.person_id%TYPE,
11: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
12: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
13: p_version_number IN igs_en_su_attempt.version_number%TYPE,
14: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
15: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 12: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

8: PROCEDURE populate_sua_table
9: (
10: p_person_id IN igs_en_su_attempt.person_id%TYPE,
11: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
12: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
13: p_version_number IN igs_en_su_attempt.version_number%TYPE,
14: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
15: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
16: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 13: p_version_number IN igs_en_su_attempt.version_number%TYPE,

9: (
10: p_person_id IN igs_en_su_attempt.person_id%TYPE,
11: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
12: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
13: p_version_number IN igs_en_su_attempt.version_number%TYPE,
14: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
15: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
16: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
17: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,

Line 14: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

10: p_person_id IN igs_en_su_attempt.person_id%TYPE,
11: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
12: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
13: p_version_number IN igs_en_su_attempt.version_number%TYPE,
14: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
15: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
16: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
17: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
18: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

Line 15: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

11: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
12: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
13: p_version_number IN igs_en_su_attempt.version_number%TYPE,
14: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
15: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
16: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
17: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
18: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
19: ) AS

Line 16: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

12: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
13: p_version_number IN igs_en_su_attempt.version_number%TYPE,
14: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
15: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
16: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
17: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
18: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
19: ) AS
20: --

Line 18: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

14: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
15: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
16: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
17: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
18: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
19: ) AS
20: --
21: v_gpa NUMBER;
22: v_gpa_cp NUMBER;

Line 139: p_person_id IN igs_en_su_attempt.person_id%TYPE,

135: --swaghmar 15-Sep-2005 Bug# 4491456
136: --
137: PROCEDURE populate_load_table
138: (
139: p_person_id IN igs_en_su_attempt.person_id%TYPE,
140: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
141: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
142: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
143: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 140: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

136: --
137: PROCEDURE populate_load_table
138: (
139: p_person_id IN igs_en_su_attempt.person_id%TYPE,
140: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
141: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
142: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
143: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
144: ) AS

Line 141: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

137: PROCEDURE populate_load_table
138: (
139: p_person_id IN igs_en_su_attempt.person_id%TYPE,
140: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
141: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
142: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
143: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
144: ) AS
145: --

Line 142: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

138: (
139: p_person_id IN igs_en_su_attempt.person_id%TYPE,
140: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
141: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
142: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
143: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
144: ) AS
145: --
146: v_load_gpa igs_as_grd_sch_grade.gpa_val%TYPE;

Line 246: p_person_id IN igs_en_su_attempt.person_id%TYPE,

242: -- Added p_uoo_id parameter to the FUNCTION get_sua_gpa
243: --
244: FUNCTION get_sua_gpa
245: (
246: p_person_id IN igs_en_su_attempt.person_id%TYPE,
247: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
248: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
249: p_version_number IN igs_en_su_attempt.version_number%TYPE,
250: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 247: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

243: --
244: FUNCTION get_sua_gpa
245: (
246: p_person_id IN igs_en_su_attempt.person_id%TYPE,
247: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
248: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
249: p_version_number IN igs_en_su_attempt.version_number%TYPE,
250: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
251: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 248: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

244: FUNCTION get_sua_gpa
245: (
246: p_person_id IN igs_en_su_attempt.person_id%TYPE,
247: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
248: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
249: p_version_number IN igs_en_su_attempt.version_number%TYPE,
250: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
251: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
252: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 249: p_version_number IN igs_en_su_attempt.version_number%TYPE,

245: (
246: p_person_id IN igs_en_su_attempt.person_id%TYPE,
247: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
248: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
249: p_version_number IN igs_en_su_attempt.version_number%TYPE,
250: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
251: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
252: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
253: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,

Line 250: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

246: p_person_id IN igs_en_su_attempt.person_id%TYPE,
247: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
248: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
249: p_version_number IN igs_en_su_attempt.version_number%TYPE,
250: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
251: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
252: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
253: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
254: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

Line 251: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

247: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
248: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
249: p_version_number IN igs_en_su_attempt.version_number%TYPE,
250: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
251: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
252: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
253: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
254: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
255: ) RETURN NUMBER AS

Line 252: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

248: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
249: p_version_number IN igs_en_su_attempt.version_number%TYPE,
250: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
251: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
252: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
253: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
254: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
255: ) RETURN NUMBER AS
256: --

Line 254: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

250: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
251: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
252: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
253: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
254: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
255: ) RETURN NUMBER AS
256: --
257: BEGIN
258: --

Line 298: p_person_id IN igs_en_su_attempt.person_id%TYPE,

294: -- Added p_uoo_id parameter to the FUNCTION get_sua_gpa_cp
295: --
296: FUNCTION get_sua_gpa_cp
297: (
298: p_person_id IN igs_en_su_attempt.person_id%TYPE,
299: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
300: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
301: p_version_number IN igs_en_su_attempt.version_number%TYPE,
302: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 299: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

295: --
296: FUNCTION get_sua_gpa_cp
297: (
298: p_person_id IN igs_en_su_attempt.person_id%TYPE,
299: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
300: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
301: p_version_number IN igs_en_su_attempt.version_number%TYPE,
302: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
303: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 300: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

296: FUNCTION get_sua_gpa_cp
297: (
298: p_person_id IN igs_en_su_attempt.person_id%TYPE,
299: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
300: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
301: p_version_number IN igs_en_su_attempt.version_number%TYPE,
302: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
303: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
304: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 301: p_version_number IN igs_en_su_attempt.version_number%TYPE,

297: (
298: p_person_id IN igs_en_su_attempt.person_id%TYPE,
299: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
300: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
301: p_version_number IN igs_en_su_attempt.version_number%TYPE,
302: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
303: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
304: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
305: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,

Line 302: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

298: p_person_id IN igs_en_su_attempt.person_id%TYPE,
299: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
300: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
301: p_version_number IN igs_en_su_attempt.version_number%TYPE,
302: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
303: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
304: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
305: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
306: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

Line 303: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

299: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
300: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
301: p_version_number IN igs_en_su_attempt.version_number%TYPE,
302: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
303: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
304: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
305: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
306: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
307: ) RETURN NUMBER AS

Line 304: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

300: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
301: p_version_number IN igs_en_su_attempt.version_number%TYPE,
302: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
303: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
304: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
305: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
306: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
307: ) RETURN NUMBER AS
308: --

Line 306: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

302: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
303: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
304: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
305: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
306: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
307: ) RETURN NUMBER AS
308: --
309: BEGIN
310: --

Line 350: p_person_id IN igs_en_su_attempt.person_id%TYPE,

346: -- Added p_uoo_id parameter to the FUNCTION get_sua_gpa_qp
347: --
348: FUNCTION get_sua_gpa_qp
349: (
350: p_person_id IN igs_en_su_attempt.person_id%TYPE,
351: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
352: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
353: p_version_number IN igs_en_su_attempt.version_number%TYPE,
354: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 351: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

347: --
348: FUNCTION get_sua_gpa_qp
349: (
350: p_person_id IN igs_en_su_attempt.person_id%TYPE,
351: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
352: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
353: p_version_number IN igs_en_su_attempt.version_number%TYPE,
354: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
355: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 352: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

348: FUNCTION get_sua_gpa_qp
349: (
350: p_person_id IN igs_en_su_attempt.person_id%TYPE,
351: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
352: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
353: p_version_number IN igs_en_su_attempt.version_number%TYPE,
354: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
355: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
356: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 353: p_version_number IN igs_en_su_attempt.version_number%TYPE,

349: (
350: p_person_id IN igs_en_su_attempt.person_id%TYPE,
351: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
352: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
353: p_version_number IN igs_en_su_attempt.version_number%TYPE,
354: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
355: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
356: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
357: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,

Line 354: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

350: p_person_id IN igs_en_su_attempt.person_id%TYPE,
351: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
352: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
353: p_version_number IN igs_en_su_attempt.version_number%TYPE,
354: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
355: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
356: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
357: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
358: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

Line 355: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

351: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
352: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
353: p_version_number IN igs_en_su_attempt.version_number%TYPE,
354: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
355: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
356: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
357: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
358: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
359: ) RETURN NUMBER AS

Line 356: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

352: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
353: p_version_number IN igs_en_su_attempt.version_number%TYPE,
354: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
355: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
356: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
357: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
358: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
359: ) RETURN NUMBER AS
360: --

Line 358: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

354: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
355: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
356: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
357: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
358: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
359: ) RETURN NUMBER AS
360: --
361: BEGIN
362: --

Line 402: p_person_id IN igs_en_su_attempt.person_id%TYPE,

398: -- Added p_uoo_id parameter to the FUNCTION get_sua_earned_cp
399: --
400: FUNCTION get_sua_earned_cp
401: (
402: p_person_id IN igs_en_su_attempt.person_id%TYPE,
403: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
404: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
405: p_version_number IN igs_en_su_attempt.version_number%TYPE,
406: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 403: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

399: --
400: FUNCTION get_sua_earned_cp
401: (
402: p_person_id IN igs_en_su_attempt.person_id%TYPE,
403: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
404: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
405: p_version_number IN igs_en_su_attempt.version_number%TYPE,
406: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
407: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 404: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

400: FUNCTION get_sua_earned_cp
401: (
402: p_person_id IN igs_en_su_attempt.person_id%TYPE,
403: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
404: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
405: p_version_number IN igs_en_su_attempt.version_number%TYPE,
406: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
407: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
408: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 405: p_version_number IN igs_en_su_attempt.version_number%TYPE,

401: (
402: p_person_id IN igs_en_su_attempt.person_id%TYPE,
403: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
404: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
405: p_version_number IN igs_en_su_attempt.version_number%TYPE,
406: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
407: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
408: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
409: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,

Line 406: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

402: p_person_id IN igs_en_su_attempt.person_id%TYPE,
403: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
404: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
405: p_version_number IN igs_en_su_attempt.version_number%TYPE,
406: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
407: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
408: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
409: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
410: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

Line 407: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

403: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
404: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
405: p_version_number IN igs_en_su_attempt.version_number%TYPE,
406: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
407: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
408: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
409: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
410: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
411: ) RETURN NUMBER AS

Line 408: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

404: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
405: p_version_number IN igs_en_su_attempt.version_number%TYPE,
406: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
407: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
408: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
409: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
410: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
411: ) RETURN NUMBER AS
412: --

Line 410: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

406: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
407: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
408: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
409: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
410: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
411: ) RETURN NUMBER AS
412: --
413: BEGIN
414: --

Line 454: p_person_id IN igs_en_su_attempt.person_id%TYPE,

450: -- Added p_uoo_id parameter to the FUNCTION get_sua_attempted_cp
451: --
452: FUNCTION get_sua_attempted_cp
453: (
454: p_person_id IN igs_en_su_attempt.person_id%TYPE,
455: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
456: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
457: p_version_number IN igs_en_su_attempt.version_number%TYPE,
458: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 455: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

451: --
452: FUNCTION get_sua_attempted_cp
453: (
454: p_person_id IN igs_en_su_attempt.person_id%TYPE,
455: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
456: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
457: p_version_number IN igs_en_su_attempt.version_number%TYPE,
458: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
459: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 456: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

452: FUNCTION get_sua_attempted_cp
453: (
454: p_person_id IN igs_en_su_attempt.person_id%TYPE,
455: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
456: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
457: p_version_number IN igs_en_su_attempt.version_number%TYPE,
458: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
459: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
460: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 457: p_version_number IN igs_en_su_attempt.version_number%TYPE,

453: (
454: p_person_id IN igs_en_su_attempt.person_id%TYPE,
455: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
456: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
457: p_version_number IN igs_en_su_attempt.version_number%TYPE,
458: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
459: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
460: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
461: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,

Line 458: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

454: p_person_id IN igs_en_su_attempt.person_id%TYPE,
455: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
456: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
457: p_version_number IN igs_en_su_attempt.version_number%TYPE,
458: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
459: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
460: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
461: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
462: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

Line 459: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

455: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
456: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
457: p_version_number IN igs_en_su_attempt.version_number%TYPE,
458: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
459: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
460: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
461: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
462: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
463: ) RETURN NUMBER AS

Line 460: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

456: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
457: p_version_number IN igs_en_su_attempt.version_number%TYPE,
458: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
459: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
460: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
461: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
462: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
463: ) RETURN NUMBER AS
464: --

Line 462: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

458: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
459: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
460: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
461: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
462: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
463: ) RETURN NUMBER AS
464: --
465: BEGIN
466: --

Line 506: p_person_id IN igs_en_su_attempt.person_id%TYPE,

502: -- Added p_uoo_id parameter to the FUNCTION get_sua_grade
503: --
504: FUNCTION get_sua_grade
505: (
506: p_person_id IN igs_en_su_attempt.person_id%TYPE,
507: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
508: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
509: p_version_number IN igs_en_su_attempt.version_number%TYPE,
510: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 507: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

503: --
504: FUNCTION get_sua_grade
505: (
506: p_person_id IN igs_en_su_attempt.person_id%TYPE,
507: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
508: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
509: p_version_number IN igs_en_su_attempt.version_number%TYPE,
510: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
511: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 508: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

504: FUNCTION get_sua_grade
505: (
506: p_person_id IN igs_en_su_attempt.person_id%TYPE,
507: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
508: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
509: p_version_number IN igs_en_su_attempt.version_number%TYPE,
510: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
511: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
512: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 509: p_version_number IN igs_en_su_attempt.version_number%TYPE,

505: (
506: p_person_id IN igs_en_su_attempt.person_id%TYPE,
507: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
508: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
509: p_version_number IN igs_en_su_attempt.version_number%TYPE,
510: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
511: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
512: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
513: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,

Line 510: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

506: p_person_id IN igs_en_su_attempt.person_id%TYPE,
507: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
508: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
509: p_version_number IN igs_en_su_attempt.version_number%TYPE,
510: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
511: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
512: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
513: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
514: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

Line 511: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

507: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
508: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
509: p_version_number IN igs_en_su_attempt.version_number%TYPE,
510: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
511: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
512: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
513: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
514: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
515: ) RETURN VARCHAR2 AS

Line 512: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

508: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
509: p_version_number IN igs_en_su_attempt.version_number%TYPE,
510: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
511: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
512: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
513: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
514: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
515: ) RETURN VARCHAR2 AS
516: --

Line 514: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

510: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
511: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
512: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
513: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
514: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
515: ) RETURN VARCHAR2 AS
516: --
517: BEGIN
518: --

Line 558: p_person_id IN igs_en_su_attempt.person_id%TYPE,

554: -- Added p_uoo_id parameter to the FUNCTION get_sua_mark
555: --
556: FUNCTION get_sua_mark
557: (
558: p_person_id IN igs_en_su_attempt.person_id%TYPE,
559: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
560: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
561: p_version_number IN igs_en_su_attempt.version_number%TYPE,
562: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 559: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

555: --
556: FUNCTION get_sua_mark
557: (
558: p_person_id IN igs_en_su_attempt.person_id%TYPE,
559: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
560: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
561: p_version_number IN igs_en_su_attempt.version_number%TYPE,
562: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
563: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 560: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

556: FUNCTION get_sua_mark
557: (
558: p_person_id IN igs_en_su_attempt.person_id%TYPE,
559: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
560: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
561: p_version_number IN igs_en_su_attempt.version_number%TYPE,
562: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
563: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
564: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 561: p_version_number IN igs_en_su_attempt.version_number%TYPE,

557: (
558: p_person_id IN igs_en_su_attempt.person_id%TYPE,
559: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
560: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
561: p_version_number IN igs_en_su_attempt.version_number%TYPE,
562: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
563: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
564: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
565: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,

Line 562: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

558: p_person_id IN igs_en_su_attempt.person_id%TYPE,
559: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
560: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
561: p_version_number IN igs_en_su_attempt.version_number%TYPE,
562: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
563: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
564: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
565: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
566: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

Line 563: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

559: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
560: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
561: p_version_number IN igs_en_su_attempt.version_number%TYPE,
562: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
563: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
564: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
565: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
566: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
567: ) RETURN NUMBER AS

Line 564: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

560: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
561: p_version_number IN igs_en_su_attempt.version_number%TYPE,
562: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
563: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
564: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
565: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
566: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
567: ) RETURN NUMBER AS
568: --

Line 566: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

562: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
563: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
564: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
565: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
566: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
567: ) RETURN NUMBER AS
568: --
569: BEGIN
570: --

Line 609: p_person_id IN igs_en_su_attempt.person_id%TYPE,

605: --
606: --
607: FUNCTION get_sua_yop
608: (
609: p_person_id IN igs_en_su_attempt.person_id%TYPE,
610: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
611: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
612: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
613: ) RETURN VARCHAR2 AS

Line 610: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

606: --
607: FUNCTION get_sua_yop
608: (
609: p_person_id IN igs_en_su_attempt.person_id%TYPE,
610: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
611: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
612: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
613: ) RETURN VARCHAR2 AS
614: --

Line 611: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

607: FUNCTION get_sua_yop
608: (
609: p_person_id IN igs_en_su_attempt.person_id%TYPE,
610: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
611: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
612: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
613: ) RETURN VARCHAR2 AS
614: --
615: -- This function returns the Unit Set Code of any YOP specific Student Unit

Line 612: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE

608: (
609: p_person_id IN igs_en_su_attempt.person_id%TYPE,
610: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
611: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
612: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
613: ) RETURN VARCHAR2 AS
614: --
615: -- This function returns the Unit Set Code of any YOP specific Student Unit
616: -- Set Attempts which have Selection and Requirements Complete/End Dates

Line 657: p_person_id IN igs_en_su_attempt.person_id%TYPE,

653: --
654: --
655: FUNCTION get_load_gpa
656: (
657: p_person_id IN igs_en_su_attempt.person_id%TYPE,
658: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
659: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
660: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
661: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 658: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

654: --
655: FUNCTION get_load_gpa
656: (
657: p_person_id IN igs_en_su_attempt.person_id%TYPE,
658: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
659: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
660: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
661: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
662: ) RETURN NUMBER AS

Line 659: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

655: FUNCTION get_load_gpa
656: (
657: p_person_id IN igs_en_su_attempt.person_id%TYPE,
658: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
659: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
660: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
661: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
662: ) RETURN NUMBER AS
663: --

Line 660: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

656: (
657: p_person_id IN igs_en_su_attempt.person_id%TYPE,
658: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
659: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
660: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
661: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
662: ) RETURN NUMBER AS
663: --
664: BEGIN

Line 694: p_person_id IN igs_en_su_attempt.person_id%TYPE,

690: --
691: --
692: FUNCTION get_load_gpa_cp
693: (
694: p_person_id IN igs_en_su_attempt.person_id%TYPE,
695: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
696: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
697: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
698: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 695: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

691: --
692: FUNCTION get_load_gpa_cp
693: (
694: p_person_id IN igs_en_su_attempt.person_id%TYPE,
695: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
696: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
697: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
698: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
699: ) RETURN NUMBER AS

Line 696: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

692: FUNCTION get_load_gpa_cp
693: (
694: p_person_id IN igs_en_su_attempt.person_id%TYPE,
695: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
696: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
697: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
698: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
699: ) RETURN NUMBER AS
700: --

Line 697: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

693: (
694: p_person_id IN igs_en_su_attempt.person_id%TYPE,
695: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
696: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
697: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
698: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
699: ) RETURN NUMBER AS
700: --
701: BEGIN

Line 731: p_person_id IN igs_en_su_attempt.person_id%TYPE,

727: --
728: --
729: FUNCTION get_load_gpa_qp
730: (
731: p_person_id IN igs_en_su_attempt.person_id%TYPE,
732: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
733: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
734: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
735: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 732: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

728: --
729: FUNCTION get_load_gpa_qp
730: (
731: p_person_id IN igs_en_su_attempt.person_id%TYPE,
732: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
733: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
734: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
735: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
736: ) RETURN NUMBER AS

Line 733: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

729: FUNCTION get_load_gpa_qp
730: (
731: p_person_id IN igs_en_su_attempt.person_id%TYPE,
732: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
733: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
734: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
735: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
736: ) RETURN NUMBER AS
737: --

Line 734: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

730: (
731: p_person_id IN igs_en_su_attempt.person_id%TYPE,
732: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
733: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
734: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
735: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
736: ) RETURN NUMBER AS
737: --
738: BEGIN

Line 767: p_person_id IN igs_en_su_attempt.person_id%TYPE,

763: --
764: --
765: FUNCTION get_load_earned_cp
766: (
767: p_person_id IN igs_en_su_attempt.person_id%TYPE,
768: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
769: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
770: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
771: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 768: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

764: --
765: FUNCTION get_load_earned_cp
766: (
767: p_person_id IN igs_en_su_attempt.person_id%TYPE,
768: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
769: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
770: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
771: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
772: ) RETURN NUMBER AS

Line 769: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

765: FUNCTION get_load_earned_cp
766: (
767: p_person_id IN igs_en_su_attempt.person_id%TYPE,
768: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
769: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
770: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
771: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
772: ) RETURN NUMBER AS
773: --

Line 770: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

766: (
767: p_person_id IN igs_en_su_attempt.person_id%TYPE,
768: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
769: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
770: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
771: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
772: ) RETURN NUMBER AS
773: --
774: BEGIN

Line 804: p_person_id IN igs_en_su_attempt.person_id%TYPE,

800: --
801: --
802: FUNCTION get_load_attempted_cp
803: (
804: p_person_id IN igs_en_su_attempt.person_id%TYPE,
805: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
806: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
807: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
808: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 805: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

801: --
802: FUNCTION get_load_attempted_cp
803: (
804: p_person_id IN igs_en_su_attempt.person_id%TYPE,
805: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
806: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
807: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
808: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
809: ) RETURN NUMBER AS

Line 806: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

802: FUNCTION get_load_attempted_cp
803: (
804: p_person_id IN igs_en_su_attempt.person_id%TYPE,
805: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
806: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
807: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
808: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
809: ) RETURN NUMBER AS
810: --

Line 807: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

803: (
804: p_person_id IN igs_en_su_attempt.person_id%TYPE,
805: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
806: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
807: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
808: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
809: ) RETURN NUMBER AS
810: --
811: BEGIN

Line 840: p_person_id IN igs_en_su_attempt.person_id%TYPE,

836: --
837: --
838: FUNCTION get_cum_gpa
839: (
840: p_person_id IN igs_en_su_attempt.person_id%TYPE,
841: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
842: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
843: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
844: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 841: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

837: --
838: FUNCTION get_cum_gpa
839: (
840: p_person_id IN igs_en_su_attempt.person_id%TYPE,
841: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
842: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
843: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
844: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
845: ) RETURN NUMBER AS

Line 842: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

838: FUNCTION get_cum_gpa
839: (
840: p_person_id IN igs_en_su_attempt.person_id%TYPE,
841: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
842: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
843: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
844: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
845: ) RETURN NUMBER AS
846: --

Line 843: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

839: (
840: p_person_id IN igs_en_su_attempt.person_id%TYPE,
841: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
842: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
843: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
844: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
845: ) RETURN NUMBER AS
846: --
847: BEGIN

Line 876: p_person_id IN igs_en_su_attempt.person_id%TYPE,

872: --
873: --
874: FUNCTION get_cum_gpa_cp
875: (
876: p_person_id IN igs_en_su_attempt.person_id%TYPE,
877: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
878: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
879: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
880: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 877: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

873: --
874: FUNCTION get_cum_gpa_cp
875: (
876: p_person_id IN igs_en_su_attempt.person_id%TYPE,
877: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
878: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
879: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
880: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
881: ) RETURN NUMBER AS

Line 878: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

874: FUNCTION get_cum_gpa_cp
875: (
876: p_person_id IN igs_en_su_attempt.person_id%TYPE,
877: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
878: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
879: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
880: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
881: ) RETURN NUMBER AS
882: --

Line 879: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

875: (
876: p_person_id IN igs_en_su_attempt.person_id%TYPE,
877: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
878: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
879: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
880: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
881: ) RETURN NUMBER AS
882: --
883: BEGIN

Line 912: p_person_id IN igs_en_su_attempt.person_id%TYPE,

908: --
909: --
910: FUNCTION get_cum_gpa_qp
911: (
912: p_person_id IN igs_en_su_attempt.person_id%TYPE,
913: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
914: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
915: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
916: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 913: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

909: --
910: FUNCTION get_cum_gpa_qp
911: (
912: p_person_id IN igs_en_su_attempt.person_id%TYPE,
913: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
914: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
915: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
916: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
917: ) RETURN NUMBER AS

Line 914: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

910: FUNCTION get_cum_gpa_qp
911: (
912: p_person_id IN igs_en_su_attempt.person_id%TYPE,
913: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
914: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
915: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
916: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
917: ) RETURN NUMBER AS
918: --

Line 915: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

911: (
912: p_person_id IN igs_en_su_attempt.person_id%TYPE,
913: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
914: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
915: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
916: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
917: ) RETURN NUMBER AS
918: --
919: BEGIN

Line 948: p_person_id IN igs_en_su_attempt.person_id%TYPE,

944: --
945: --
946: FUNCTION get_cum_earned_cp
947: (
948: p_person_id IN igs_en_su_attempt.person_id%TYPE,
949: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
950: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
951: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
952: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 949: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

945: --
946: FUNCTION get_cum_earned_cp
947: (
948: p_person_id IN igs_en_su_attempt.person_id%TYPE,
949: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
950: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
951: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
952: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
953: ) RETURN NUMBER AS

Line 950: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

946: FUNCTION get_cum_earned_cp
947: (
948: p_person_id IN igs_en_su_attempt.person_id%TYPE,
949: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
950: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
951: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
952: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
953: ) RETURN NUMBER AS
954: --

Line 951: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

947: (
948: p_person_id IN igs_en_su_attempt.person_id%TYPE,
949: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
950: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
951: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
952: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
953: ) RETURN NUMBER AS
954: --
955: BEGIN

Line 984: p_person_id IN igs_en_su_attempt.person_id%TYPE,

980: --
981: --
982: FUNCTION get_cum_attempted_cp
983: (
984: p_person_id IN igs_en_su_attempt.person_id%TYPE,
985: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
986: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
987: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
988: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 985: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

981: --
982: FUNCTION get_cum_attempted_cp
983: (
984: p_person_id IN igs_en_su_attempt.person_id%TYPE,
985: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
986: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
987: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
988: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
989: ) RETURN NUMBER AS

Line 986: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

982: FUNCTION get_cum_attempted_cp
983: (
984: p_person_id IN igs_en_su_attempt.person_id%TYPE,
985: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
986: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
987: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
988: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
989: ) RETURN NUMBER AS
990: --

Line 987: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

983: (
984: p_person_id IN igs_en_su_attempt.person_id%TYPE,
985: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
986: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
987: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
988: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
989: ) RETURN NUMBER AS
990: --
991: BEGIN