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_PR_ORG_STAT

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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