1 PACKAGE BODY igf_ap_oss_intrface AS
2 /* $Header: IGFAP09B.pls 120.1 2005/09/08 14:44:28 appldev noship $ */
3
4
5 PROCEDURE get_acad_calendar(awd_caltype IN VARCHAR2,awd_Seqnum IN NUMBER,acad_caltype OUT NOCOPY VARCHAR2,
6 acad_seqnum OUT NOCOPY NUMBER,acad_altcode OUT NOCOPY VARCHAR2)
7
8 IS
9 BEGIN
10 NULL;
11 END;
12
13
14 FUNCTION get_ssn(vperson_id IN NUMBER) RETURN VARCHAR2
15 IS
16 BEGIN
17 RETURN NULL;
18 END;
19
20
21 PROCEDURE get_program_code(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER,
22 vcourse_cd OUT NOCOPY VARCHAR2,vversion_number OUT NOCOPY NUMBER)
23 IS
24 BEGIN
25 NULL;
26 END;
27
28
29 FUNCTION get_grade_level_code(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER)
30 RETURN VARCHAR2
31 IS
32 BEGIN
33 RETURN NULL;
34 END;
35
36
37 FUNCTION get_completion_date(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
38 VARCHAR2
39 IS
40 BEGIN
41 RETURN NULL;
42 END;
43
44
45
46 FUNCTION get_admission_index(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
47 VARCHAR2
48 IS
49 BEGIN
50 RETURN NULL;
51 END;
52
53
54 FUNCTION is_degree_stdnt(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
55 BOOLEAN
56 IS
57 BEGIN
58 RETURN FALSE;
59 END;
60
61
62 FUNCTION get_attd_mode(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
63 VARCHAR2
64 IS
65 BEGIN
66 RETURN NULL;
67 END;
68
69
70 FUNCTION get_attd_type(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
71 VARCHAR2
72 IS
73 BEGIN
74 RETURN NULL;
75 END;
76
77
78 FUNCTION is_stdnt_discontd(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
79 BOOLEAN
80 IS
81 BEGIN
82 RETURN FALSE;
83 END;
84
85
86 FUNCTION stdnt_intermission(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
87 BOOLEAN
88 IS
89 BEGIN
90 RETURN FALSE;
91 END;
92
93
94 FUNCTION attends_other_inst(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
95 BOOLEAN
96 IS
97 BEGIN
98 RETURN FALSE;
99 END;
100
101
102 FUNCTION eligible_for_aid(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER,aid_type IN VARCHAR2) RETURN
103 BOOLEAN
104 IS
105 BEGIN
106 RETURN FALSE;
107 END;
108
109
110 FUNCTION is_transferee(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN BOOLEAN
111 IS
112 BEGIN
113 RETURN FALSE;
114 END;
115
116
117 FUNCTION get_adm_appl_status(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2
118 IS
119 BEGIN
120 RETURN NULL;
121 END;
122
123
124 FUNCTION get_adm_outcome_status(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2
125 IS
126 BEGIN
127 RETURN NULL;
128 END;
129
130
131 FUNCTION get_adm_offr_resp_status(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2
132 IS
133 BEGIN
134 RETURN NULL;
135 END;
136
137
138 FUNCTION get_adm_offr_accept_date(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN DATE
139 IS
140 BEGIN
141 RETURN NULL;
142 END;
143
144
145 FUNCTION get_adm_date(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN DATE
146 IS
147 BEGIN
148 RETURN NULL;
149 END;
150
151
152 FUNCTION get_adm_fee_status(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2
153 IS
154 BEGIN
155 RETURN NULL;
156 END;
157
158
159 FUNCTION get_adm_test_score(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2
160 IS
161 BEGIN
162 RETURN NULL;
163 END;
164
165
166 FUNCTION get_diploma_school(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2
167 IS
168 BEGIN
169 RETURN NULL;
170 END;
171
172
173 FUNCTION get_school_rank(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2
174 IS
175 BEGIN
176 RETURN NULL;
177 END;
178
179
180 FUNCTION get_school_gpa(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN NUMBER
181 IS
182 BEGIN
183 RETURN NULL;
184 END;
185
186
187 FUNCTION get_transfer_school(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2
188 IS
189 BEGIN
190 RETURN NULL;
191 END;
192
193
194 FUNCTION get_cumulative_tr_credits(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN NUMBER
195 IS
196 BEGIN
197 RETURN NULL;
198 END;
199
200
201 FUNCTION get_transfer_gpa(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN NUMBER
202 IS
203 BEGIN
204 RETURN NULL;
205 END;
206
207
208 FUNCTION get_athletic_sport(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2
209 IS
210 BEGIN
211 RETURN NULL;
212 END;
213
214
215 FUNCTION get_cumulative_cr_points(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN NUMBER
216 IS
217 BEGIN
218 RETURN NULL;
219 END;
220
221
222 FUNCTION get_cumulative_gpa(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN NUMBER
223 IS
224 BEGIN
225 RETURN NULL;
226 END;
227
228
229 FUNCTION get_term_gpa(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN NUMBER
230 IS
231 BEGIN
232 RETURN NULL;
233 END;
234
235
236 FUNCTION get_minor_unit_set(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2
237 IS
238 BEGIN
239 RETURN NULL;
240 END;
241
242
243 FUNCTION get_credit_points_enrol(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN NUMBER
244 IS
245 BEGIN
246 RETURN NULL;
247 END;
248
249
250 FUNCTION get_final_unit_set(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2
251 IS
252 BEGIN
253 RETURN NULL;
254 END;
255
256
257 PROCEDURE get_adm_data(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER,
258 adm_status OUT NOCOPY VARCHAR2,adm_pro_dt OUT NOCOPY DATE,grade_level OUT NOCOPY VARCHAR2,
259 student_type OUT NOCOPY VARCHAR2,adm_pro_status OUT NOCOPY VARCHAR2,admission_index OUT NOCOPY VARCHAR2,
260 outcome_status OUT NOCOPY VARCHAR2,org_id OUT NOCOPY NUMBER,decision_date OUT NOCOPY DATE,
261 final_unit_set OUT NOCOPY VARCHAR2,program OUT NOCOPY VARCHAR2,term_start_date OUT NOCOPY DATE,
262 current_gpa OUT NOCOPY VARCHAR2,cumulative_gpa OUT NOCOPY VARCHAR2,curent_enrol_hrs OUT NOCOPY NUMBER,
263 acheived_cr_pts OUT NOCOPY NUMBER,enrolment_status OUT NOCOPY VARCHAR2,enrolment_status_date OUT NOCOPY DATE,
264 grade_level_type OUT NOCOPY VARCHAR2,grade_level_date OUT NOCOPY DATE,transfered OUT NOCOPY VARCHAR2)
265 IS
266 BEGIN
267 NULL;
268 END;
269
270
271
272
273 END igf_ap_oss_intrface;