[Home] [Help]
PACKAGE: APPS.IGF_AW_PACKAGING
Source
1 PACKAGE IGF_AW_PACKAGING AS
2 /* $Header: IGFAW03S.pls 120.3 2006/08/04 07:37:39 veramach ship $ */
3
4 /*
5 || Created By : cdcruz
6 || Created On : 14-NOV-2000
7 || Purpose : Does the main packaging in awards
8 || Known limitations, enhancements or remarks :
9 || who when what
10 || museshad 29-Jun-2005 Build# FA157 - Bug# 4382371.
11 || Added the functions 'get_term_start_date()' and
12 || 'get_disb_round_factor()'
13 || veramach 30-Jun-2004 bug 3709109 - Added function check_disb
14 || cdcruz 03-Dec-2003 FA 131 COD Updates
15 || The Type disb_dt_rec had a typo in the column name
16 || base_attendance_type changed to base_attendance_type_code
17 || veramach 03-Dec-2003 FA 131 COD Updates
18 || Adds base_attendance_type to disb_dt_rec
19 || veramach 20-NOV-2003 FA 125 Multiple Distribution method
20 || 1.Added g_plan_id,g_plan_cd global variables
21 || 2.Changed TYPE disb_dt_rec to have attendance_type_code
22 || 3.Added p_dist_id as parameter to pkg_single_fund
23 || veramach 13-OCT-2003 FA 124 Remove ISIR Requirement for Awarding
24 || 1.Removed obsoleted parameters of procedure run from the spec
25 || 2.Removed parameter p_grp_code from pkg_single_fund and added parameters p_sf_min_amount,
26 || p_sf_max_amount,p_allow_to_exceed
27 || rasahoo 23-Apl-2003 Bug # 2860836 a parmeter added in the post_award procedure
28 || brajendr 24-Oct-2002 FA105 / FA108 Builds
29 || Refer TDs for the changes
30 ||
31 || sjadhav 24-jul-2001 Bug ID : 1818617
32 || added parameter p_get_recent_info
33 ||
34 || sjadhav 21-May-2001 Bug ID : 1747948
35 || Added one more parameter Group Code
36 ||
37 || pmarada 14-feb-2002 Added p_upd_awd_notif_status parameter.
38 */
39
40 PROCEDURE clear_simulation( l_base_id IN NUMBER );
41
42 PROCEDURE run(
43 errbuf OUT NOCOPY VARCHAR2,
44 retcode OUT NOCOPY NUMBER,
45 l_award_year IN VARCHAR2 DEFAULT NULL, -- 10
46 p_awd_prd_code IN VARCHAR2 DEFAULT NULL,
47 l_grp_code IN VARCHAR2 DEFAULT NULL, -- 20
48 l_base_id IN NUMBER DEFAULT NULL, -- 30
49 l_sim_mode IN VARCHAR2 DEFAULT NULL, -- 40
50 p_upd_awd_notif_status IN VARCHAR2 DEFAULT NULL, -- 50
51 l_run_mode IN VARCHAR2 DEFAULT NULL, -- 60
52 p_fund_id IN NUMBER DEFAULT NULL, -- 70
53 l_run_type IN VARCHAR2 DEFAULT NULL, -- 80 Obsoleted parameter, retaining for backward COMPATIBILITY
54 p_publish_in_ss_flag IN VARCHAR2 DEFAULT NULL,
55 l_run_code IN VARCHAR2 DEFAULT NULL, -- 90 Obsoleted parameter, retaining for backward compatibility
56 l_individual_pkg IN VARCHAR2 DEFAULT NULL -- 100 Obsoleted parameter, retaining for backward COMPATIBILITY
57 );
58
59 /*
60 l_ci_cal_type --> Calendar Type
61 l_ci_sequence_number --> Calendar Sequence Number
62 l_grp_code --> Target Groups defiend in the system
63 l_base_id --> Student Base ID
64 l_run_mode --> D Detail Model in which all comments printed in the log file
65 S Summary Mode in which no comments are printed ) ;
66 p_over_awd --> NA No Award
67 --> CH Create Hold
68 --> NH No Hold
69 */
70
71 PROCEDURE post_award(
72 l_base_id IN NUMBER,
73 l_process_id IN NUMBER,
74 l_post IN VARCHAR2,
75 l_called_from IN VARCHAR2,
76 l_upd_awd_notif_status IN VARCHAR2 DEFAULT NULL,
77 l_ret_status OUT NOCOPY VARCHAR2 -- Bug # 2860836 parameter added
78 );
79
80 PROCEDURE group_run(
81 l_group_code IN VARCHAR2,
82 l_ci_cal_type IN VARCHAR2 ,
83 l_ci_sequence_number IN NUMBER,
84 l_post IN VARCHAR2,
85 l_run_mode IN VARCHAR2
86 ) ;
87
88 PROCEDURE stud_run(
89 l_base_id IN NUMBER,
90 l_post IN VARCHAR2,
91 l_run_mode IN VARCHAR2
92 ) ;
93
94 PROCEDURE process_stud(
95 l_fabase IN igf_ap_fa_base_rec%ROWTYPE,
96 l_use_fixed_costs IN VARCHAR2,
97 l_post IN VARCHAR2,
98 l_run_mode IN VARCHAR2,
99 l_fund_id OUT NOCOPY NUMBER,
100 l_seq_no OUT NOCOPY NUMBER,
101 l_award_id OUT NOCOPY NUMBER,
102 l_fund_fail OUT NOCOPY BOOLEAN
103 ) ;
104
105 PROCEDURE update_fund(
106 l_fund_id IN NUMBER,
107 l_seq_no IN NUMBER,
108 l_process_id IN NUMBER,
109 l_base_id IN NUMBER,
110 l_award_id IN NUMBER
111 );
112
113
114 PROCEDURE get_process_id ;
115
116 FUNCTION get_perct_amt(
117 l_perct_fact IN VARCHAR2,
118 l_perct_val IN NUMBER ,
119 l_base_id IN NUMBER,
120 l_efc_f IN NUMBER,
121 p_awd_prd_code IN VARCHAR2
122 ) RETURN NUMBER;
123
124 TYPE disb_dt_rec IS RECORD(
125 process_id NUMBER,
126 sl_no NUMBER,
127 disb_num NUMBER,
128 nslds_disb_date DATE,
129 disb_verf_dt DATE,
130 disb_exp_dt DATE,
131 min_credit_pts NUMBER,
132 attendance_type_code igf_aw_awd_disb_all.attendance_type_code%TYPE,
133 base_attendance_type_code igf_aw_awd_disb_all.base_attendance_type_code%TYPE
134 );
135
136 TYPE disb_dt_tab IS TABLE OF disb_dt_rec;
137
138 PROCEDURE get_disbursements(
139 l_fund_id IN NUMBER,
140 l_offered_amt IN NUMBER,
141 l_base_id IN NUMBER,
142 l_process_id IN NUMBER,
143 l_accepted_amt IN NUMBER,
144 l_called_from IN VARCHAR2,
145 l_nslds_da IN VARCHAR2,
146 l_exp_da IN VARCHAR2,
147 l_verf_da IN VARCHAR2,
148 l_disb_dt IN OUT NOCOPY disb_dt_tab,
149 l_adplans_id IN NUMBER,
150 l_award_id IN NUMBER
151 );
152
153 PROCEDURE add_todo(
154 p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
155 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
156 );
157
158 FUNCTION get_date_instance(
159 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
160 p_dt_alias IN igs_ca_da.dt_alias%TYPE,
161 p_cal_type IN igs_ca_inst.cal_type%TYPE,
162 p_cal_sequence IN igs_ca_inst.sequence_number%TYPE
163 ) RETURN DATE;
164
165 PROCEDURE process_single_fund(
166 p_grp_code IN VARCHAR2,
167 p_ci_cal_type IN VARCHAR2,
168 p_ci_sequence_number IN NUMBER,
169 p_base_id IN NUMBER,
170 p_persid_grp IN NUMBER DEFAULT NULL
171 );
172
173
174 PROCEDURE pkg_single_fund(
175 errbuf OUT NOCOPY VARCHAR2,
176 retcode OUT NOCOPY NUMBER,
177 p_award_year IN VARCHAR2 DEFAULT NULL,
178 p_awd_prd_code IN VARCHAR2 DEFAULT NULL,
179 p_fund_id IN NUMBER DEFAULT NULL,
180 p_dist_id IN NUMBER DEFAULT NULL,
181 p_base_id IN NUMBER DEFAULT NULL,
182 p_persid_grp IN NUMBER DEFAULT NULL,
183 p_sf_min_amount IN NUMBER DEFAULT NULL,
184 p_sf_max_amount IN NUMBER DEFAULT NULL,
185 p_allow_to_exceed IN VARCHAR2 DEFAULT NULL,
186 p_upd_awd_notif_status IN VARCHAR2 DEFAULT NULL,
187 p_lock_award IN VARCHAR2 DEFAULT NULL,
188 p_publish_in_ss_flag IN VARCHAR2 DEFAULT NULL
189 );
190
191 FUNCTION check_disb(
192 p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
193 p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
194 p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
195 ) RETURN BOOLEAN;
196
197 FUNCTION get_term_start_date(
198 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
199 p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
200 p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE
201 )RETURN DATE;
202 FUNCTION get_disb_round_factor(
203 p_fund_id IN igf_aw_fund_mast.fund_id%TYPE
204 )RETURN VARCHAR2;
205
206 FUNCTION chk_gplus_loan_limits (
207 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
208 p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
209 p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
210 p_aid IN NUMBER,
211 p_std_loan_tab IN igf_aw_packng_subfns.std_loan_tab,
212 p_msg_name OUT NOCOPY fnd_new_messages.message_name%TYPE
213 ) RETURN BOOLEAN;
214
215 FUNCTION get_fed_fund_code(p_fund_id IN NUMBER) RETURN VARCHAR2;
216
217 l_process_id NUMBER(15);
218 l_actual_grant_amt NUMBER(12,3);
219 l_actual_loan_amt NUMBER(12,3);
220 l_actual_work_amt NUMBER(12,3);
221 l_actual_shelp_amt NUMBER(12,3);
222 l_actual_gift_amt NUMBER(12,3);
223 l_actual_schlp_amt NUMBER(12,3);
224 l_max_aid_pkg NUMBER(12,3);
225 l_grant_amt NUMBER(12,3);
226 l_loan_amt NUMBER(12,3);
227 l_work_amt NUMBER(12,3);
228 l_shelp_amt NUMBER(12,3);
229 l_gift_amt NUMBER(12,3);
230 l_schlp_amt NUMBER(12,3);
231 l_gap_amt NUMBER(12,3);
232 l_efc_f NUMBER(12,3);
233 l_efc_i NUMBER(12,3);
234 l_pell_efc NUMBER(12,3);
235 gn_fund_awd_cnt NUMBER;
236 g_alt_pell_schedule igf_aw_award_all.alt_pell_schedule%TYPE;
237
238 g_plan_id NUMBER := -1;
239 g_method_cd VARCHAR2(80) ;
240 g_lock_award igf_aw_fund_mast_all.lock_award_flag%TYPE;
241 g_awd_prd igf_aw_awd_prd_term.award_prd_cd%TYPE;
242 g_publish_in_ss_flag igf_aw_award_all.publish_in_ss_flag%TYPE;
243
244 g_phasein_participant BOOLEAN;
245 g_req_id NUMBER;
246 END IGF_AW_PACKAGING;