1 PACKAGE igf_ap_oss_intrface AS
2 /* $Header: IGFAP09S.pls 120.1 2005/09/08 14:44:10 appldev noship $ */
3
4 /*
5 || Created By : Sridhar
6 || Created On : 16-JAN-2001
7 || Purpose : Functions and procedures in this pacakge fetch OSS related information.
8 || These functions and procedurse are designed with the assumption that student
9 || has only one program attempt per academic year that is eligible for Fin.Aid
10 || Known limitations, enhancements or remarks :
11 || Change History :
12 || Who When What
13 || (reverse chronological order - newest change first)
14 */
15
16 PROCEDURE get_acad_calendar(awd_caltype IN VARCHAR2,awd_Seqnum IN NUMBER,acad_caltype OUT NOCOPY VARCHAR2,
17 acad_seqnum OUT NOCOPY NUMBER,acad_altcode OUT NOCOPY VARCHAR2);
18
19 FUNCTION get_ssn(vperson_id IN NUMBER) RETURN VARCHAR2;
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
24 FUNCTION get_grade_level_code(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER)
25 RETURN VARCHAR2;
26
27 FUNCTION get_completion_date(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
28 VARCHAR2;
29
30
31 FUNCTION get_admission_index(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
32 VARCHAR2;
33
34 FUNCTION is_degree_stdnt(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
35 BOOLEAN;
36
37 FUNCTION get_attd_mode(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
38 VARCHAR2;
39
40 FUNCTION get_attd_type(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
41 VARCHAR2;
42
43 FUNCTION is_stdnt_discontd(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
44 BOOLEAN;
45
46 FUNCTION stdnt_intermission(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
47 BOOLEAN;
48
49 FUNCTION attends_other_inst(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN
50 BOOLEAN;
51
52 FUNCTION eligible_for_aid(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER,aid_type IN VARCHAR2) RETURN
53 BOOLEAN;
54
55 FUNCTION is_transferee(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN BOOLEAN;
56
57 FUNCTION get_adm_appl_status(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2;
58
59 FUNCTION get_adm_outcome_status(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2;
60
61 FUNCTION get_adm_offr_resp_status(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2;
62
63 FUNCTION get_adm_offr_accept_date(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN DATE;
64
65 FUNCTION get_adm_date(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN DATE;
66
67 FUNCTION get_adm_fee_status(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2;
68
69 FUNCTION get_adm_test_score(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2;
70
71 FUNCTION get_diploma_school(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2;
72
73 FUNCTION get_school_rank(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2;
74
75 FUNCTION get_school_gpa(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN NUMBER;
76
77 FUNCTION get_transfer_school(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2;
78
79 FUNCTION get_cumulative_tr_credits(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN NUMBER;
80
81 FUNCTION get_transfer_gpa(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN NUMBER;
82
83 FUNCTION get_athletic_sport(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2;
84
85 FUNCTION get_cumulative_cr_points(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN NUMBER;
86
87 FUNCTION get_cumulative_gpa(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN NUMBER;
88
89 FUNCTION get_term_gpa(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN NUMBER;
90
91 FUNCTION get_minor_unit_set(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2;
92
93 FUNCTION get_credit_points_enrol(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN NUMBER;
94
95 FUNCTION get_final_unit_set(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER) RETURN VARCHAR2;
96
97 PROCEDURE get_adm_data(vperson_id IN NUMBER,awdcal_type IN VARCHAR2,awdcal_seq IN NUMBER,
98 adm_status OUT NOCOPY VARCHAR2,adm_pro_dt OUT NOCOPY DATE,grade_level OUT NOCOPY VARCHAR2,
99 student_type OUT NOCOPY VARCHAR2,adm_pro_status OUT NOCOPY VARCHAR2,admission_index OUT NOCOPY VARCHAR2,
100 outcome_status OUT NOCOPY VARCHAR2,org_id OUT NOCOPY NUMBER,decision_date OUT NOCOPY DATE,
101 final_unit_set OUT NOCOPY VARCHAR2,program OUT NOCOPY VARCHAR2,term_start_date OUT NOCOPY DATE,
102 current_gpa OUT NOCOPY VARCHAR2,cumulative_gpa OUT NOCOPY VARCHAR2,curent_enrol_hrs OUT NOCOPY NUMBER,
103 acheived_cr_pts OUT NOCOPY NUMBER,enrolment_status OUT NOCOPY VARCHAR2,enrolment_status_date OUT NOCOPY DATE,
104 grade_level_type OUT NOCOPY VARCHAR2,grade_level_date OUT NOCOPY DATE,transfered OUT NOCOPY VARCHAR2);
105
106 END igf_ap_oss_intrface;