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 17: p_stat_type IN igs_pr_org_stat.stat_type%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: --
21: v_gpa NUMBER;

Line 143: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

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;
147: v_load_gpa_cp igs_ps_unit_ver.achievable_credit_points%TYPE;

Line 253: p_stat_type IN igs_pr_org_stat.stat_type%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: --
257: BEGIN

Line 305: p_stat_type IN igs_pr_org_stat.stat_type%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: --
309: BEGIN

Line 357: p_stat_type IN igs_pr_org_stat.stat_type%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: --
361: BEGIN

Line 409: p_stat_type IN igs_pr_org_stat.stat_type%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: --
413: BEGIN

Line 461: p_stat_type IN igs_pr_org_stat.stat_type%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: --
465: BEGIN

Line 513: p_stat_type IN igs_pr_org_stat.stat_type%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: --
517: BEGIN

Line 565: p_stat_type IN igs_pr_org_stat.stat_type%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: --
569: BEGIN

Line 661: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

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
665: --

Line 698: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

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
702: --

Line 735: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

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
739: --

Line 771: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

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
775: --

Line 808: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

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
812: --

Line 844: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

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
848: --

Line 880: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

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
884: --

Line 916: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

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
920: --

Line 952: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

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
956: --

Line 988: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

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
992: --