1 PACKAGE igf_ap_efc_subf AUTHID CURRENT_USER AS
2 /* $Header: IGFAP32S.pls 115.3 2003/03/09 13:50:50 gmuralid noship $ */
3 /*
4 || Created By : gmuralid
5 || Created On : 12- Feb- 2003
6 || Purpose : Bug# 2758804 - EFC TD
7 ||
8 || Known limitations, enhancements or remarks :
9 || Change History :
10 || Who When What
11 || gmuralid 9-03-2003 Added a extra parameter l_call_type to procedure c_efc
12 || gmuralid 7-03-2003 Added a new procedure to compute auto zero efc
13 || (reverse chronological order - newest change first)
14 */
15 -- Exception to be raised while Error in Set up is Found.
16 exception_in_setup EXCEPTION;
17
18 -- SUB FUNCTIONS for calculating EFC with FORMULA A
19
20 -- Get the Parents' Income in 2000
21 PROCEDURE a_p_inc ( p_p_inc OUT NOCOPY NUMBER); -- Parents' Income
22
23 -- Get Allowances against Parents' Income
24 PROCEDURE a_allow_ag_p_inc ( p_p_inc IN NUMBER, -- Parents' Income
25 p_allow_ag_p_inc OUT NOCOPY NUMBER); -- Allowances against Parents' Income
26
27 -- Get the Parents' Available Income
28 PROCEDURE a_available_inc ( p_p_inc IN NUMBER, -- Parents' Income
29 p_allow_ag_p_inc IN NUMBER, -- Allowances against Parents' Income
30 p_available_income OUT NOCOPY NUMBER); -- Available Income
31
32 -- Get Parents' contribution from Assets
33 PROCEDURE a_p_cont_assets ( p_p_cont_assets OUT NOCOPY NUMBER); -- Parents' contribution from Assets
34
35 -- Get Parents' Contribution
36 PROCEDURE a_p_cont ( p_available_income IN NUMBER, -- Available Income
37 p_p_cont_assets IN NUMBER, -- Parents' contribution from Assets
38 p_p_aai OUT NOCOPY NUMBER, -- Parents' Adjustable Available Income
39 p_p_cont OUT NOCOPY NUMBER);-- Parents' Contribution from Income
40
41 -- Get student's income in 2000
42 PROCEDURE a_s_inc ( p_s_inc OUT NOCOPY NUMBER);-- Student's Income
43
44 -- Get Allowances against Student's income
45 PROCEDURE a_allow_ag_s_inc ( p_s_inc IN NUMBER, -- Student's Income
46 p_p_aai IN NUMBER, -- Parents' Adjustable Available Income
47 p_allow_ag_s_inc OUT NOCOPY NUMBER);-- Allowances against Student's Income
48
49 -- Get Student's contribution from income
50 PROCEDURE a_s_cont ( p_s_inc IN NUMBER, -- Student's Income
51 p_allow_ag_s_inc IN NUMBER, -- Allowances against Student's Income
52 p_s_cont OUT NOCOPY NUMBER);-- Student's Contribution from Income
53
54 -- Get Student's contribution from Assets
55 PROCEDURE a_s_cont_assets ( p_s_cont_assets OUT NOCOPY NUMBER);-- Student's contribution from Assets
56
57 -- Get Expected Family Contribtion
58 PROCEDURE a_efc ( p_p_cont IN NUMBER, -- Parents' Contribution from Income
59 p_s_cont IN NUMBER, -- Student's Contribution from Income
60 p_s_cont_assets IN NUMBER, -- Student's contribution from Assets
61 p_efc OUT NOCOPY NUMBER);-- EFC of the Student
62
63 -- Get Parents' contribution for < 9 months
64 PROCEDURE a_p_cont_less_9 ( p_p_cont IN NUMBER, -- Parents' Contribution from Income
65 p_no_of_months IN NUMBER, -- Number of months of enrollment of student
66 p_p_cont_less_9 OUT NOCOPY NUMBER);-- Parents' Contribution from Income for less than 9 months
67
68 -- Get Student's contribution from Available Income for < 9 months
69 PROCEDURE a_s_cont_less_9 ( p_s_cont IN NUMBER, -- Student's Contribution from Income
70 p_no_of_months IN NUMBER, -- Number of months of enrollment of student
71 p_s_cont_less_9 OUT NOCOPY NUMBER);-- Student's Contribution from Income for less than 9 months
72
73 -- Get Student's EFC for <> 9 months
74 PROCEDURE a_efc_not_9 ( p_p_cont_not_9 IN NUMBER, -- Parents' Contribution from Income for not equal to 9 months
75 p_s_cont_not_9 IN NUMBER, -- Student's Contribution from Income for not equal to 9 months
76 p_s_cont_assets IN NUMBER, -- Student's contribution from Assets
77 p_efc OUT NOCOPY NUMBER);-- EFC of the Student for No. of Months <> 9
78
79 -- Get Parents contribution for > 9 months
80 PROCEDURE a_p_cont_more_9 ( p_p_aai IN NUMBER, -- Parents' Adjustable Available Income
81 p_p_cont IN NUMBER, -- Parents' Contribution from Income
82 p_no_of_months IN NUMBER, -- Number of months of enrollment of student
83 p_p_cont_more_9 OUT NOCOPY NUMBER);-- Parents' Contribution from Income for more than 9 months
84
85
86 -- SUB FUNCTIONS for calculating EFC with FORMULA B
87 -- Get Student/Spouse income in 2000
88 PROCEDURE b_s_inc ( p_s_inc OUT NOCOPY NUMBER);-- Student/Spouse Income
89
90 -- Get Allowance against Student/Spouse income
91 PROCEDURE b_allow_ag_s_inc ( p_s_inc IN NUMBER, -- Student/Spouse Income
92 p_allow_ag_s_inc OUT NOCOPY NUMBER);-- Allowance against Student/Spouse income
93
94 -- Get contribution from Available Income
95 PROCEDURE b_s_cont ( p_s_inc IN NUMBER, -- Student/Spouse Income
96 p_allow_ag_s_inc IN NUMBER, -- Allowance against Student/Spouse income
97 p_s_cont OUT NOCOPY NUMBER);-- Contribution from Available Income
98
99 -- Get Student/Spouse contribution from Assets
100 PROCEDURE b_s_cont_assets ( p_s_cont_assets OUT NOCOPY NUMBER);-- Student/Spouse contribution from Assets
101
102 -- Get Expected Family Contribution for 9 months
103 PROCEDURE b_efc ( p_s_cont IN NUMBER, -- Contribution from Available Income
104 p_s_cont_assets IN NUMBER, -- Student/Spouse contribution from Assets
105 p_efc OUT NOCOPY NUMBER);-- EFC of the Student
106
107 -- Get Expected Family Contribution for less than 9 months
108 PROCEDURE b_efc_less_9 ( p_no_of_months IN NUMBER, -- Number of months of enrollment of student
109 p_efc IN OUT NOCOPY NUMBER);-- EFC of the Student for No. of Months < 9
110
111
112 -- SUB FUNCTIONS for calculating EFC with FORMULA C
113
114 -- Get Student/Spouse Income in 2000.
115 PROCEDURE c_s_inc ( p_s_inc OUT NOCOPY NUMBER);-- Student/Spouse Income
116
117 -- Get Allowances against Student/Spouse Income
118 PROCEDURE c_allow_ag_s_inc ( p_s_inc IN NUMBER, -- Student/Spouse Income
119 p_allow_ag_s_inc OUT NOCOPY NUMBER);-- Allowance against Student/Spouse Income
120
121 -- Get Available Income
122 PROCEDURE c_available_inc ( p_s_inc IN NUMBER, -- Student/Spouse Income
123 p_allow_ag_s_inc IN NUMBER, -- Allowance against Student/Spouse Income
124 p_available_income OUT NOCOPY NUMBER);-- Available Income
125
126 -- Get Student/Spouse contribution from Assets
127 PROCEDURE c_s_cont_assets ( p_s_cont_assets OUT NOCOPY NUMBER);-- Student/Spouse contribution from Assets
128
129 -- Get Expected Family Contribution for 9 months
130 PROCEDURE c_efc ( p_available_income IN NUMBER, -- Available Income
131 p_s_cont_assets IN NUMBER, -- Student/Spouse contribution from Assets
132 p_efc OUT NOCOPY NUMBER,
133 l_call_type IN VARCHAR2 );-- EFC of the Student
134
135 -- Get Expected Family Contribution for less than 9 months
136 PROCEDURE c_efc_less_9 ( p_no_of_months IN NUMBER, -- Number of months of enrollment of student
137 p_efc IN OUT NOCOPY NUMBER);-- EFC of the Student for No. of Months < 9
138
139 FUNCTION efc_cutoff_date ( p_sys_award_year IN VARCHAR2 )
140 RETURN DATE;
141
142 PROCEDURE get_par_stud_cont( p_sys_award_year IN VARCHAR2,
143 p_parent_cont OUT NOCOPY NUMBER,
144 p_student_cont OUT NOCOPY NUMBER);
145
146 PROCEDURE auto_zero_efc ( p_primary_efc_type IN VARCHAR2);
147
148 END igf_ap_efc_subf;