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 48: p_person_id IN igs_en_su_attempt.person_id%TYPE,

44: --
45: g_pkg_name CONSTANT VARCHAR2(30) := 'IGS_DA_XML_PKG';
46: PROCEDURE populate_sua_table
47: (
48: p_person_id IN igs_en_su_attempt.person_id%TYPE,
49: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
50: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
51: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
52: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 49: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

45: g_pkg_name CONSTANT VARCHAR2(30) := 'IGS_DA_XML_PKG';
46: PROCEDURE populate_sua_table
47: (
48: p_person_id IN igs_en_su_attempt.person_id%TYPE,
49: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
50: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
51: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
52: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
53: ) AS

Line 50: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

46: PROCEDURE populate_sua_table
47: (
48: p_person_id IN igs_en_su_attempt.person_id%TYPE,
49: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
50: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
51: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
52: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
53: ) AS
54: --

Line 51: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

47: (
48: p_person_id IN igs_en_su_attempt.person_id%TYPE,
49: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
50: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
51: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
52: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
53: ) AS
54: --
55: v_gpa NUMBER;

Line 71: v_unit_cd igs_en_su_attempt.unit_cd%TYPE;

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

Line 72: v_unit_version_number igs_en_su_attempt.version_number%TYPE;

68: v_mark igs_as_su_stmptout.mark%TYPE;
69: v_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
70: v_origin_course_cd igs_as_su_stmptout.course_cd%TYPE;
71: v_unit_cd igs_en_su_attempt.unit_cd%TYPE;
72: v_unit_version_number igs_en_su_attempt.version_number%TYPE;
73: v_teach_cal_type igs_en_su_attempt.cal_type%TYPE;
74: v_teach_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE;
75: v_dummy VARCHAR2(1);
76: --

Line 73: v_teach_cal_type igs_en_su_attempt.cal_type%TYPE;

69: v_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
70: v_origin_course_cd igs_as_su_stmptout.course_cd%TYPE;
71: v_unit_cd igs_en_su_attempt.unit_cd%TYPE;
72: v_unit_version_number igs_en_su_attempt.version_number%TYPE;
73: v_teach_cal_type igs_en_su_attempt.cal_type%TYPE;
74: v_teach_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE;
75: v_dummy VARCHAR2(1);
76: --
77: CURSOR c_sua IS

Line 74: v_teach_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE;

70: v_origin_course_cd igs_as_su_stmptout.course_cd%TYPE;
71: v_unit_cd igs_en_su_attempt.unit_cd%TYPE;
72: v_unit_version_number igs_en_su_attempt.version_number%TYPE;
73: v_teach_cal_type igs_en_su_attempt.cal_type%TYPE;
74: v_teach_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE;
75: v_dummy VARCHAR2(1);
76: --
77: CURSOR c_sua IS
78: SELECT sua.unit_cd,

Line 82: FROM igs_en_su_attempt sua

78: SELECT sua.unit_cd,
79: sua.version_number,
80: sua.cal_type,
81: sua.ci_sequence_number
82: FROM igs_en_su_attempt sua
83: WHERE sua.person_id = p_person_id
84: AND sua.course_cd = p_course_cd
85: AND sua.uoo_id = p_uoo_id;
86: --

Line 181: p_person_id IN igs_en_su_attempt.person_id%TYPE,

177: --swaghmar 15-Sep-2005 Bug# 4491456
178: --
179: PROCEDURE populate_load_table
180: (
181: p_person_id IN igs_en_su_attempt.person_id%TYPE,
182: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
183: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
184: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
185: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 182: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

178: --
179: PROCEDURE populate_load_table
180: (
181: p_person_id IN igs_en_su_attempt.person_id%TYPE,
182: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
183: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
184: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
185: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
186: ) AS

Line 183: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

179: PROCEDURE populate_load_table
180: (
181: p_person_id IN igs_en_su_attempt.person_id%TYPE,
182: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
183: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
184: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
185: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
186: ) AS
187: --

Line 184: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

180: (
181: p_person_id IN igs_en_su_attempt.person_id%TYPE,
182: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
183: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
184: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
185: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
186: ) AS
187: --
188: v_cum_gpa NUMBER;

Line 243: p_person_id IN igs_en_su_attempt.person_id%TYPE,

239: --
240: --
241: FUNCTION get_sua_gpa_cp
242: (
243: p_person_id IN igs_en_su_attempt.person_id%TYPE,
244: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
245: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
246: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
247: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 244: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

240: --
241: FUNCTION get_sua_gpa_cp
242: (
243: p_person_id IN igs_en_su_attempt.person_id%TYPE,
244: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
245: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
246: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
247: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
248: ) RETURN NUMBER AS

Line 245: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

241: FUNCTION get_sua_gpa_cp
242: (
243: p_person_id IN igs_en_su_attempt.person_id%TYPE,
244: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
245: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
246: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
247: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
248: ) RETURN NUMBER AS
249: --

Line 246: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

242: (
243: p_person_id IN igs_en_su_attempt.person_id%TYPE,
244: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
245: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
246: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
247: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
248: ) RETURN NUMBER AS
249: --
250: BEGIN

Line 279: p_person_id IN igs_en_su_attempt.person_id%TYPE,

275: --
276: --
277: FUNCTION get_sua_gpa_qp
278: (
279: p_person_id IN igs_en_su_attempt.person_id%TYPE,
280: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
281: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
282: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
283: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 280: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

276: --
277: FUNCTION get_sua_gpa_qp
278: (
279: p_person_id IN igs_en_su_attempt.person_id%TYPE,
280: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
281: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
282: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
283: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
284: ) RETURN NUMBER AS

Line 281: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

277: FUNCTION get_sua_gpa_qp
278: (
279: p_person_id IN igs_en_su_attempt.person_id%TYPE,
280: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
281: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
282: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
283: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
284: ) RETURN NUMBER AS
285: --

Line 282: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

278: (
279: p_person_id IN igs_en_su_attempt.person_id%TYPE,
280: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
281: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
282: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
283: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
284: ) RETURN NUMBER AS
285: --
286: BEGIN

Line 315: p_person_id IN igs_en_su_attempt.person_id%TYPE,

311: --
312: --
313: FUNCTION get_sua_earned_cp
314: (
315: p_person_id IN igs_en_su_attempt.person_id%TYPE,
316: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
317: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
318: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
319: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 316: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

312: --
313: FUNCTION get_sua_earned_cp
314: (
315: p_person_id IN igs_en_su_attempt.person_id%TYPE,
316: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
317: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
318: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
319: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
320: ) RETURN NUMBER AS

Line 317: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

313: FUNCTION get_sua_earned_cp
314: (
315: p_person_id IN igs_en_su_attempt.person_id%TYPE,
316: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
317: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
318: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
319: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
320: ) RETURN NUMBER AS
321: --

Line 318: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

314: (
315: p_person_id IN igs_en_su_attempt.person_id%TYPE,
316: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
317: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
318: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
319: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
320: ) RETURN NUMBER AS
321: --
322: BEGIN

Line 351: p_person_id IN igs_en_su_attempt.person_id%TYPE,

347: --
348: --
349: FUNCTION get_sua_attempted_cp
350: (
351: p_person_id IN igs_en_su_attempt.person_id%TYPE,
352: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
353: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
354: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
355: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 352: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

348: --
349: FUNCTION get_sua_attempted_cp
350: (
351: p_person_id IN igs_en_su_attempt.person_id%TYPE,
352: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
353: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
354: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
355: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
356: ) RETURN NUMBER AS

Line 353: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

349: FUNCTION get_sua_attempted_cp
350: (
351: p_person_id IN igs_en_su_attempt.person_id%TYPE,
352: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
353: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
354: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
355: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
356: ) RETURN NUMBER AS
357: --

Line 354: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

350: (
351: p_person_id IN igs_en_su_attempt.person_id%TYPE,
352: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
353: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
354: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
355: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
356: ) RETURN NUMBER AS
357: --
358: BEGIN

Line 387: p_person_id IN igs_en_su_attempt.person_id%TYPE,

383: --
384: --
385: FUNCTION get_sua_grade
386: (
387: p_person_id IN igs_en_su_attempt.person_id%TYPE,
388: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
389: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
390: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
391: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 388: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

384: --
385: FUNCTION get_sua_grade
386: (
387: p_person_id IN igs_en_su_attempt.person_id%TYPE,
388: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
389: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
390: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
391: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
392: ) RETURN VARCHAR2 AS

Line 389: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

385: FUNCTION get_sua_grade
386: (
387: p_person_id IN igs_en_su_attempt.person_id%TYPE,
388: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
389: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
390: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
391: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
392: ) RETURN VARCHAR2 AS
393: --

Line 390: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

386: (
387: p_person_id IN igs_en_su_attempt.person_id%TYPE,
388: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
389: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
390: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
391: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
392: ) RETURN VARCHAR2 AS
393: --
394: BEGIN

Line 423: p_person_id IN igs_en_su_attempt.person_id%TYPE,

419: --
420: --
421: FUNCTION get_sua_mark
422: (
423: p_person_id IN igs_en_su_attempt.person_id%TYPE,
424: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
425: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
426: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
427: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 424: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

420: --
421: FUNCTION get_sua_mark
422: (
423: p_person_id IN igs_en_su_attempt.person_id%TYPE,
424: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
425: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
426: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
427: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
428: ) RETURN NUMBER AS

Line 425: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

421: FUNCTION get_sua_mark
422: (
423: p_person_id IN igs_en_su_attempt.person_id%TYPE,
424: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
425: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
426: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
427: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
428: ) RETURN NUMBER AS
429: --

Line 426: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

422: (
423: p_person_id IN igs_en_su_attempt.person_id%TYPE,
424: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
425: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
426: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
427: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
428: ) RETURN NUMBER AS
429: --
430: BEGIN

Line 459: p_person_id IN igs_en_su_attempt.person_id%TYPE,

455: --
456: --
457: FUNCTION get_sua_result_type
458: (
459: p_person_id IN igs_en_su_attempt.person_id%TYPE,
460: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
461: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
462: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
463: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 460: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

456: --
457: FUNCTION get_sua_result_type
458: (
459: p_person_id IN igs_en_su_attempt.person_id%TYPE,
460: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
461: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
462: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
463: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
464: ) RETURN VARCHAR2 AS

Line 461: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

457: FUNCTION get_sua_result_type
458: (
459: p_person_id IN igs_en_su_attempt.person_id%TYPE,
460: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
461: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
462: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
463: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
464: ) RETURN VARCHAR2 AS
465: --

Line 462: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

458: (
459: p_person_id IN igs_en_su_attempt.person_id%TYPE,
460: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
461: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
462: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
463: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
464: ) RETURN VARCHAR2 AS
465: --
466: BEGIN

Line 495: p_person_id IN igs_en_su_attempt.person_id%TYPE,

491: --
492: --
493: FUNCTION get_cum_gpa
494: (
495: p_person_id IN igs_en_su_attempt.person_id%TYPE,
496: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
497: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
498: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
499: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 496: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

492: --
493: FUNCTION get_cum_gpa
494: (
495: p_person_id IN igs_en_su_attempt.person_id%TYPE,
496: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
497: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
498: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
499: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
500: ) RETURN NUMBER AS

Line 497: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

493: FUNCTION get_cum_gpa
494: (
495: p_person_id IN igs_en_su_attempt.person_id%TYPE,
496: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
497: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
498: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
499: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
500: ) RETURN NUMBER AS
501: --

Line 498: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

494: (
495: p_person_id IN igs_en_su_attempt.person_id%TYPE,
496: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
497: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
498: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
499: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
500: ) RETURN NUMBER AS
501: --
502: BEGIN

Line 531: p_person_id IN igs_en_su_attempt.person_id%TYPE,

527: --
528: --
529: FUNCTION get_cum_gpa_cp
530: (
531: p_person_id IN igs_en_su_attempt.person_id%TYPE,
532: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
533: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
534: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
535: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 532: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

528: --
529: FUNCTION get_cum_gpa_cp
530: (
531: p_person_id IN igs_en_su_attempt.person_id%TYPE,
532: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
533: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
534: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
535: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
536: ) RETURN NUMBER AS

Line 533: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

529: FUNCTION get_cum_gpa_cp
530: (
531: p_person_id IN igs_en_su_attempt.person_id%TYPE,
532: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
533: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
534: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
535: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
536: ) RETURN NUMBER AS
537: --

Line 534: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

530: (
531: p_person_id IN igs_en_su_attempt.person_id%TYPE,
532: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
533: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
534: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
535: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
536: ) RETURN NUMBER AS
537: --
538: BEGIN

Line 567: p_person_id IN igs_en_su_attempt.person_id%TYPE,

563: --
564: --
565: FUNCTION get_cum_gpa_qp
566: (
567: p_person_id IN igs_en_su_attempt.person_id%TYPE,
568: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
569: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
570: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
571: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 568: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

564: --
565: FUNCTION get_cum_gpa_qp
566: (
567: p_person_id IN igs_en_su_attempt.person_id%TYPE,
568: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
569: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
570: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
571: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
572: ) RETURN NUMBER AS

Line 569: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

565: FUNCTION get_cum_gpa_qp
566: (
567: p_person_id IN igs_en_su_attempt.person_id%TYPE,
568: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
569: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
570: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
571: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
572: ) RETURN NUMBER AS
573: --

Line 570: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

566: (
567: p_person_id IN igs_en_su_attempt.person_id%TYPE,
568: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
569: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
570: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
571: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
572: ) RETURN NUMBER AS
573: --
574: BEGIN

Line 603: p_person_id IN igs_en_su_attempt.person_id%TYPE,

599: --
600: --
601: FUNCTION get_cum_earned_cp
602: (
603: p_person_id IN igs_en_su_attempt.person_id%TYPE,
604: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
605: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
606: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
607: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 604: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

600: --
601: FUNCTION get_cum_earned_cp
602: (
603: p_person_id IN igs_en_su_attempt.person_id%TYPE,
604: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
605: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
606: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
607: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
608: ) RETURN NUMBER AS

Line 605: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

601: FUNCTION get_cum_earned_cp
602: (
603: p_person_id IN igs_en_su_attempt.person_id%TYPE,
604: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
605: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
606: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
607: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
608: ) RETURN NUMBER AS
609: --

Line 606: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

602: (
603: p_person_id IN igs_en_su_attempt.person_id%TYPE,
604: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
605: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
606: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
607: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
608: ) RETURN NUMBER AS
609: --
610: BEGIN

Line 639: p_person_id IN igs_en_su_attempt.person_id%TYPE,

635: --
636: --
637: FUNCTION get_cum_attempted_cp
638: (
639: p_person_id IN igs_en_su_attempt.person_id%TYPE,
640: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
641: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
642: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
643: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 640: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

636: --
637: FUNCTION get_cum_attempted_cp
638: (
639: p_person_id IN igs_en_su_attempt.person_id%TYPE,
640: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
641: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
642: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
643: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
644: ) RETURN NUMBER AS

Line 641: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

637: FUNCTION get_cum_attempted_cp
638: (
639: p_person_id IN igs_en_su_attempt.person_id%TYPE,
640: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
641: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
642: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
643: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
644: ) RETURN NUMBER AS
645: --

Line 642: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

638: (
639: p_person_id IN igs_en_su_attempt.person_id%TYPE,
640: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
641: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
642: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
643: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
644: ) RETURN NUMBER AS
645: --
646: BEGIN

Line 679: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

675: --
676:
677: FUNCTION get_course_abbr_num
678: (
679: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
680: p_evaluation_type IN CHAR DEFAULT 'A'
681: ) RETURN VARCHAR2 AS
682: --
683: l_count NUMBER := 0;

Line 737: (p_person_id IN igs_en_su_attempt.person_id%TYPE

733: -- student_type_list combines the student type into a single list
734: -- of student type i.e. Student, Instructor, etc...
735: -- Default return is not student type...
736: FUNCTION student_type_list
737: (p_person_id IN igs_en_su_attempt.person_id%TYPE
738: ) RETURN VARCHAR2 AS
739:
740: l_count NUMBER := 0;
741: l_counter NUMBER := 0;

Line 791: p_person_id IN igs_en_su_attempt.person_id%TYPE,

787: --
788: --
789: FUNCTION get_unit_repeatable
790: (
791: p_person_id IN igs_en_su_attempt.person_id%TYPE,
792: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
793: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
794: p_version_number IN igs_en_su_attempt.version_number%TYPE,
795: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 792: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

788: --
789: FUNCTION get_unit_repeatable
790: (
791: p_person_id IN igs_en_su_attempt.person_id%TYPE,
792: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
793: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
794: p_version_number IN igs_en_su_attempt.version_number%TYPE,
795: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
796: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 793: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

789: FUNCTION get_unit_repeatable
790: (
791: p_person_id IN igs_en_su_attempt.person_id%TYPE,
792: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
793: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
794: p_version_number IN igs_en_su_attempt.version_number%TYPE,
795: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
796: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
797: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

Line 794: p_version_number IN igs_en_su_attempt.version_number%TYPE,

790: (
791: p_person_id IN igs_en_su_attempt.person_id%TYPE,
792: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
793: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
794: p_version_number IN igs_en_su_attempt.version_number%TYPE,
795: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
796: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
797: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
798: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

Line 795: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

791: p_person_id IN igs_en_su_attempt.person_id%TYPE,
792: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
793: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
794: p_version_number IN igs_en_su_attempt.version_number%TYPE,
795: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
796: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
797: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
798: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
799: ) RETURN VARCHAR2 AS

Line 796: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

792: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
793: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
794: p_version_number IN igs_en_su_attempt.version_number%TYPE,
795: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
796: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
797: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
798: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
799: ) RETURN VARCHAR2 AS
800: --

Line 797: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

793: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
794: p_version_number IN igs_en_su_attempt.version_number%TYPE,
795: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
796: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
797: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
798: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
799: ) RETURN VARCHAR2 AS
800: --
801: CURSOR suao_gsg_cur is

Line 828: igs_en_su_attempt sua, igs_ps_unit_ver uv, igs_ps_unit_ofr_opt uoo, IGS_PS_PRG_UNIT_REL pur,

824: --
825: CURSOR repeatable_cur is
826: SELECT uv.repeatable_ind
827: FROM hz_parties p, igs_en_stdnt_ps_att spa, igs_ps_ver crv, igs_ca_teach_to_load_v ttl,
828: igs_en_su_attempt sua, igs_ps_unit_ver uv, igs_ps_unit_ofr_opt uoo, IGS_PS_PRG_UNIT_REL pur,
829: igs_as_su_atmptout_h_all atm
830: WHERE p.party_id = sua.person_id
831: AND sua.person_id = p_person_id
832: AND sua.unit_cd = p_unit_cd