1 PACKAGE igf_gr_rfms_pkg AS
2 /* $Header: IGFGI05S.pls 120.0 2005/06/01 13:01:06 appldev noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_origination_id IN VARCHAR2,
7 x_ci_cal_type IN VARCHAR2,
8 x_ci_sequence_number IN NUMBER,
9 x_base_id IN NUMBER,
10 x_award_id IN NUMBER,
11 x_rfmb_id IN NUMBER,
12 x_sys_orig_ssn IN VARCHAR2,
13 x_sys_orig_name_cd IN VARCHAR2,
14 x_transaction_num IN VARCHAR2,
15 x_efc IN NUMBER,
16 x_ver_status_code IN VARCHAR2,
17 x_secondary_efc IN NUMBER,
18 x_secondary_efc_cd IN VARCHAR2,
19 x_pell_amount IN NUMBER,
20 x_pell_profile IN VARCHAR2 DEFAULT NULL,
21 x_enrollment_status IN VARCHAR2,
22 x_enrollment_dt IN DATE,
23 x_coa_amount IN NUMBER,
24 x_academic_calendar IN VARCHAR2,
25 x_payment_method IN VARCHAR2,
26 x_total_pymt_prds IN NUMBER,
27 x_incrcd_fed_pell_rcp_cd IN VARCHAR2,
28 x_attending_campus_id IN VARCHAR2,
29 x_est_disb_dt1 IN DATE,
30 x_orig_action_code IN VARCHAR2,
31 x_orig_status_dt IN DATE,
32 x_orig_ed_use_flags IN VARCHAR2,
33 x_ft_pell_amount IN NUMBER,
34 x_prev_accpt_efc IN NUMBER,
35 x_prev_accpt_tran_no IN VARCHAR2,
36 x_prev_accpt_sec_efc_cd IN VARCHAR2,
37 x_prev_accpt_coa IN NUMBER,
38 x_orig_reject_code IN VARCHAR2,
39 x_wk_inst_time_calc_pymt IN NUMBER,
40 x_wk_int_time_prg_def_yr IN NUMBER,
41 x_cr_clk_hrs_prds_sch_yr IN NUMBER,
42 x_cr_clk_hrs_acad_yr IN NUMBER,
43 x_inst_cross_ref_cd IN VARCHAR2,
44 x_low_tution_fee IN VARCHAR2,
45 x_rec_source IN VARCHAR2,
46 x_pending_amount IN NUMBER,
47 x_mode IN VARCHAR2 DEFAULT 'R',
48 x_birth_dt IN DATE,
49 x_last_name IN VARCHAR2,
50 x_first_name IN VARCHAR2,
51 x_middle_name IN VARCHAR2,
52 x_current_ssn IN VARCHAR2,
53 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
54 x_reporting_pell_cd IN VARCHAR2 DEFAULT NULL,
55 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
56 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
57 x_note_message IN VARCHAR2 DEFAULT NULL,
58 x_full_resp_code IN VARCHAR2 DEFAULT NULL,
59 x_document_id_txt IN VARCHAR2 DEFAULT NULL
60 );
61
62 PROCEDURE lock_row (
63 x_rowid IN VARCHAR2,
64 x_origination_id IN VARCHAR2,
65 x_ci_cal_type IN VARCHAR2,
66 x_ci_sequence_number IN NUMBER,
67 x_base_id IN NUMBER,
68 x_award_id IN NUMBER,
69 x_rfmb_id IN NUMBER,
70 x_sys_orig_ssn IN VARCHAR2,
71 x_sys_orig_name_cd IN VARCHAR2,
72 x_transaction_num IN VARCHAR2,
73 x_efc IN NUMBER,
74 x_ver_status_code IN VARCHAR2,
75 x_secondary_efc IN NUMBER,
76 x_secondary_efc_cd IN VARCHAR2,
77 x_pell_amount IN NUMBER,
78 x_pell_profile IN VARCHAR2 DEFAULT NULL,
79 x_enrollment_status IN VARCHAR2,
80 x_enrollment_dt IN DATE,
81 x_coa_amount IN NUMBER,
82 x_academic_calendar IN VARCHAR2,
83 x_payment_method IN VARCHAR2,
84 x_total_pymt_prds IN NUMBER,
85 x_incrcd_fed_pell_rcp_cd IN VARCHAR2,
86 x_attending_campus_id IN VARCHAR2,
87 x_est_disb_dt1 IN DATE,
88 x_orig_action_code IN VARCHAR2,
89 x_orig_status_dt IN DATE,
90 x_orig_ed_use_flags IN VARCHAR2,
91 x_ft_pell_amount IN NUMBER,
92 x_prev_accpt_efc IN NUMBER,
93 x_prev_accpt_tran_no IN VARCHAR2,
94 x_prev_accpt_sec_efc_cd IN VARCHAR2,
95 x_prev_accpt_coa IN NUMBER,
96 x_orig_reject_code IN VARCHAR2,
97 x_wk_inst_time_calc_pymt IN NUMBER,
98 x_wk_int_time_prg_def_yr IN NUMBER,
99 x_cr_clk_hrs_prds_sch_yr IN NUMBER,
100 x_cr_clk_hrs_acad_yr IN NUMBER,
101 x_inst_cross_ref_cd IN VARCHAR2,
102 x_low_tution_fee IN VARCHAR2,
103 x_rec_source IN VARCHAR2,
104 x_pending_amount IN NUMBER,
105 x_birth_dt IN DATE,
106 x_last_name IN VARCHAR2,
107 x_first_name IN VARCHAR2,
108 x_middle_name IN VARCHAR2,
109 x_current_ssn IN VARCHAR2,
110 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
111 x_reporting_pell_cd IN VARCHAR2 DEFAULT NULL,
112 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
113 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
114 x_note_message IN VARCHAR2 DEFAULT NULL,
115 x_full_resp_code IN VARCHAR2 DEFAULT NULL,
116 x_document_id_txt IN VARCHAR2 DEFAULT NULL
117
118 );
119
120 PROCEDURE update_row (
121 x_rowid IN VARCHAR2,
122 x_origination_id IN VARCHAR2,
123 x_ci_cal_type IN VARCHAR2,
124 x_ci_sequence_number IN NUMBER,
125 x_base_id IN NUMBER,
126 x_award_id IN NUMBER,
127 x_rfmb_id IN NUMBER,
128 x_sys_orig_ssn IN VARCHAR2,
129 x_sys_orig_name_cd IN VARCHAR2,
130 x_transaction_num IN VARCHAR2,
131 x_efc IN NUMBER,
132 x_ver_status_code IN VARCHAR2,
133 x_secondary_efc IN NUMBER,
134 x_secondary_efc_cd IN VARCHAR2,
135 x_pell_amount IN NUMBER,
136 x_pell_profile IN VARCHAR2 DEFAULT NULL,
137 x_enrollment_status IN VARCHAR2,
138 x_enrollment_dt IN DATE,
139 x_coa_amount IN NUMBER,
140 x_academic_calendar IN VARCHAR2,
141 x_payment_method IN VARCHAR2,
142 x_total_pymt_prds IN NUMBER,
143 x_incrcd_fed_pell_rcp_cd IN VARCHAR2,
144 x_attending_campus_id IN VARCHAR2,
145 x_est_disb_dt1 IN DATE,
146 x_orig_action_code IN VARCHAR2,
147 x_orig_status_dt IN DATE,
148 x_orig_ed_use_flags IN VARCHAR2,
149 x_ft_pell_amount IN NUMBER,
150 x_prev_accpt_efc IN NUMBER,
151 x_prev_accpt_tran_no IN VARCHAR2,
152 x_prev_accpt_sec_efc_cd IN VARCHAR2,
153 x_prev_accpt_coa IN NUMBER,
154 x_orig_reject_code IN VARCHAR2,
155 x_wk_inst_time_calc_pymt IN NUMBER,
156 x_wk_int_time_prg_def_yr IN NUMBER,
157 x_cr_clk_hrs_prds_sch_yr IN NUMBER,
158 x_cr_clk_hrs_acad_yr IN NUMBER,
159 x_inst_cross_ref_cd IN VARCHAR2,
160 x_low_tution_fee IN VARCHAR2,
161 x_rec_source IN VARCHAR2,
162 x_pending_amount IN NUMBER,
163 x_mode IN VARCHAR2 DEFAULT 'R',
164 x_birth_dt IN DATE,
165 x_last_name IN VARCHAR2,
166 x_first_name IN VARCHAR2,
167 x_middle_name IN VARCHAR2,
168 x_current_ssn IN VARCHAR2,
169 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
170 x_reporting_pell_cd IN VARCHAR2 DEFAULT NULL,
171 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
172 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
173 x_note_message IN VARCHAR2 DEFAULT NULL,
174 x_full_resp_code IN VARCHAR2 DEFAULT NULL,
175 x_document_id_txt IN VARCHAR2 DEFAULT NULL
176
177 );
178
179 PROCEDURE add_row (
180 x_rowid IN OUT NOCOPY VARCHAR2,
181 x_origination_id IN VARCHAR2,
182 x_ci_cal_type IN VARCHAR2,
183 x_ci_sequence_number IN NUMBER,
184 x_base_id IN NUMBER,
185 x_award_id IN NUMBER,
186 x_rfmb_id IN NUMBER,
187 x_sys_orig_ssn IN VARCHAR2,
188 x_sys_orig_name_cd IN VARCHAR2,
189 x_transaction_num IN VARCHAR2,
190 x_efc IN NUMBER,
191 x_ver_status_code IN VARCHAR2,
192 x_secondary_efc IN NUMBER,
193 x_secondary_efc_cd IN VARCHAR2,
194 x_pell_amount IN NUMBER,
195 x_pell_profile IN VARCHAR2 DEFAULT NULL,
196 x_enrollment_status IN VARCHAR2,
197 x_enrollment_dt IN DATE,
198 x_coa_amount IN NUMBER,
199 x_academic_calendar IN VARCHAR2,
200 x_payment_method IN VARCHAR2,
201 x_total_pymt_prds IN NUMBER,
202 x_incrcd_fed_pell_rcp_cd IN VARCHAR2,
203 x_attending_campus_id IN VARCHAR2,
204 x_est_disb_dt1 IN DATE,
205 x_orig_action_code IN VARCHAR2,
206 x_orig_status_dt IN DATE,
207 x_orig_ed_use_flags IN VARCHAR2,
208 x_ft_pell_amount IN NUMBER,
209 x_prev_accpt_efc IN NUMBER,
210 x_prev_accpt_tran_no IN VARCHAR2,
211 x_prev_accpt_sec_efc_cd IN VARCHAR2,
212 x_prev_accpt_coa IN NUMBER,
213 x_orig_reject_code IN VARCHAR2,
214 x_wk_inst_time_calc_pymt IN NUMBER,
215 x_wk_int_time_prg_def_yr IN NUMBER,
216 x_cr_clk_hrs_prds_sch_yr IN NUMBER,
217 x_cr_clk_hrs_acad_yr IN NUMBER,
218 x_inst_cross_ref_cd IN VARCHAR2,
219 x_low_tution_fee IN VARCHAR2,
220 x_rec_source IN VARCHAR2,
221 x_pending_amount IN NUMBER,
222 x_mode IN VARCHAR2 DEFAULT 'R',
223 x_birth_dt IN DATE,
224 x_last_name IN VARCHAR2,
225 x_first_name IN VARCHAR2,
226 x_middle_name IN VARCHAR2,
227 x_current_ssn IN VARCHAR2,
228 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
229 x_reporting_pell_cd IN VARCHAR2 DEFAULT NULL,
230 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
231 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
232 x_note_message IN VARCHAR2 DEFAULT NULL,
233 x_full_resp_code IN VARCHAR2 DEFAULT NULL,
234 x_document_id_txt IN VARCHAR2 DEFAULT NULL
235
236 );
237
238 PROCEDURE delete_row (
239 x_rowid IN VARCHAR2
240 );
241
242 FUNCTION get_pk_for_validation (
243 x_origination_id IN VARCHAR2
244 ) RETURN BOOLEAN;
245
246 PROCEDURE get_fk_igf_gr_rfms_batch (
247 x_rfmb_id IN NUMBER
248 );
249
250 PROCEDURE get_fk_igs_ca_inst (
251 x_cal_type IN VARCHAR2,
252 x_sequence_number IN NUMBER
253 );
254
255 PROCEDURE get_fk_igf_aw_award (
256 x_award_id IN NUMBER
257 );
258
259 PROCEDURE get_fk_igf_ap_fa_base_rec (
260 x_base_id IN NUMBER
261 );
262
263 PROCEDURE before_dml (
264 p_action IN VARCHAR2,
265 x_rowid IN VARCHAR2 DEFAULT NULL,
266 x_origination_id IN VARCHAR2 DEFAULT NULL,
267 x_ci_cal_type IN VARCHAR2 DEFAULT NULL,
268 x_ci_sequence_number IN NUMBER DEFAULT NULL,
269 x_base_id IN NUMBER DEFAULT NULL,
270 x_award_id IN NUMBER DEFAULT NULL,
271 x_rfmb_id IN NUMBER DEFAULT NULL,
272 x_sys_orig_ssn IN VARCHAR2 DEFAULT NULL,
273 x_sys_orig_name_cd IN VARCHAR2 DEFAULT NULL,
274 x_transaction_num IN VARCHAR2 DEFAULT NULL,
275 x_efc IN NUMBER DEFAULT NULL,
276 x_ver_status_code IN VARCHAR2 DEFAULT NULL,
277 x_secondary_efc IN NUMBER DEFAULT NULL,
278 x_secondary_efc_cd IN VARCHAR2 DEFAULT NULL,
279 x_pell_amount IN NUMBER DEFAULT NULL,
280 x_pell_profile IN VARCHAR2 DEFAULT NULL,
281 x_enrollment_status IN VARCHAR2 DEFAULT NULL,
282 x_enrollment_dt IN DATE DEFAULT NULL,
283 x_coa_amount IN NUMBER DEFAULT NULL,
284 x_academic_calendar IN VARCHAR2 DEFAULT NULL,
285 x_payment_method IN VARCHAR2 DEFAULT NULL,
286 x_total_pymt_prds IN NUMBER DEFAULT NULL,
287 x_incrcd_fed_pell_rcp_cd IN VARCHAR2 DEFAULT NULL,
288 x_attending_campus_id IN VARCHAR2 DEFAULT NULL,
289 x_est_disb_dt1 IN DATE DEFAULT NULL,
290 x_orig_action_code IN VARCHAR2 DEFAULT NULL,
291 x_orig_status_dt IN DATE DEFAULT NULL,
292 x_orig_ed_use_flags IN VARCHAR2 DEFAULT NULL,
293 x_ft_pell_amount IN NUMBER DEFAULT NULL,
294 x_prev_accpt_efc IN NUMBER DEFAULT NULL,
295 x_prev_accpt_tran_no IN VARCHAR2 DEFAULT NULL,
296 x_prev_accpt_sec_efc_cd IN VARCHAR2 DEFAULT NULL,
297 x_prev_accpt_coa IN NUMBER DEFAULT NULL,
298 x_orig_reject_code IN VARCHAR2 DEFAULT NULL,
299 x_wk_inst_time_calc_pymt IN NUMBER DEFAULT NULL,
300 x_wk_int_time_prg_def_yr IN NUMBER DEFAULT NULL,
301 x_cr_clk_hrs_prds_sch_yr IN NUMBER DEFAULT NULL,
302 x_cr_clk_hrs_acad_yr IN NUMBER DEFAULT NULL,
303 x_inst_cross_ref_cd IN VARCHAR2 DEFAULT NULL,
304 x_low_tution_fee IN VARCHAR2 DEFAULT NULL,
305 x_rec_source IN VARCHAR2 DEFAULT NULL,
306 x_pending_amount IN NUMBER DEFAULT NULL,
307 x_creation_date IN DATE DEFAULT NULL,
308 x_created_by IN NUMBER DEFAULT NULL,
309 x_last_update_date IN DATE DEFAULT NULL,
310 x_last_updated_by IN NUMBER DEFAULT NULL,
311 x_last_update_login IN NUMBER DEFAULT NULL,
312 x_birth_dt IN DATE DEFAULT NULL,
313 x_last_name IN VARCHAR2 DEFAULT NULL,
314 x_first_name IN VARCHAR2 DEFAULT NULL,
315 x_middle_name IN VARCHAR2 DEFAULT NULL,
316 x_current_ssn IN VARCHAR2 DEFAULT NULL,
317 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
318 x_reporting_pell_cd IN VARCHAR2 DEFAULT NULL,
319 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
320 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
321 x_note_message IN VARCHAR2 DEFAULT NULL,
322 x_full_resp_code IN VARCHAR2 DEFAULT NULL,
323 x_document_id_txt IN VARCHAR2 DEFAULT NULL
324
325 );
326
327 END igf_gr_rfms_pkg;