1 PACKAGE igf_gr_ytd_orig_pkg AS
2 /* $Header: IGFGI13S.pls 120.1 2006/04/06 06:08:40 veramach noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_ytdor_id IN OUT NOCOPY NUMBER,
7 x_origination_id IN VARCHAR2,
8 x_original_ssn IN VARCHAR2,
9 x_original_name_cd IN VARCHAR2,
10 x_attend_pell_id IN VARCHAR2,
11 x_ed_use IN VARCHAR2,
12 x_inst_cross_ref_code IN VARCHAR2,
13 x_action_code IN VARCHAR2,
14 x_accpt_awd_amt IN NUMBER,
15 x_accpt_disb_dt1 IN DATE,
16 x_accpt_disb_dt2 IN DATE,
17 x_accpt_disb_dt3 IN DATE,
18 x_accpt_disb_dt4 IN DATE,
19 x_accpt_disb_dt5 IN DATE,
20 x_accpt_disb_dt6 IN DATE,
21 x_accpt_disb_dt7 IN DATE,
22 x_accpt_disb_dt8 IN DATE,
23 x_accpt_disb_dt9 IN DATE,
24 x_accpt_disb_dt10 IN DATE,
25 x_accpt_disb_dt11 IN DATE,
26 x_accpt_disb_dt12 IN DATE,
27 x_accpt_disb_dt13 IN DATE,
28 x_accpt_disb_dt14 IN DATE,
29 x_accpt_disb_dt15 IN DATE,
30 x_accpt_enrl_dt IN DATE,
31 x_accpt_low_tut_flg IN VARCHAR2,
32 x_accpt_ver_stat_flg IN VARCHAR2,
33 x_accpt_incr_pell_cd IN VARCHAR2,
34 x_accpt_tran_num IN VARCHAR2,
35 x_accpt_efc IN NUMBER,
36 x_accpt_sec_efc IN VARCHAR2,
37 x_accpt_acad_cal IN VARCHAR2,
38 x_accpt_pymt_method IN VARCHAR2,
39 x_accpt_coa IN NUMBER,
40 x_accpt_enrl_stat IN VARCHAR2,
41 x_accpt_wks_inst_pymt IN VARCHAR2,
42 x_wk_inst_time_calc_pymt IN NUMBER,
43 x_accpt_wks_acad IN VARCHAR2,
44 x_accpt_cr_acad_yr IN VARCHAR2,
45 x_inst_seq_num IN VARCHAR2,
46 x_sch_full_time_pell IN NUMBER,
47 x_stud_name IN VARCHAR2,
48 x_ssn IN VARCHAR2,
49 x_stud_dob IN DATE,
50 x_cps_ver_sel_cd IN VARCHAR2,
51 x_ytd_disb_amt IN NUMBER,
52 x_batch_id IN VARCHAR2,
53 x_process_date IN DATE,
54 x_mode IN VARCHAR2 DEFAULT 'R',
55 x_ci_cal_type IN VARCHAR2 DEFAULT NULL,
56 x_ci_sequence_number IN NUMBER DEFAULT NULL
57 );
58
59 PROCEDURE lock_row (
60 x_rowid IN VARCHAR2,
61 x_ytdor_id IN NUMBER,
62 x_origination_id IN VARCHAR2,
63 x_original_ssn IN VARCHAR2,
64 x_original_name_cd IN VARCHAR2,
65 x_attend_pell_id IN VARCHAR2,
66 x_ed_use IN VARCHAR2,
67 x_inst_cross_ref_code IN VARCHAR2,
68 x_action_code IN VARCHAR2,
69 x_accpt_awd_amt IN NUMBER,
70 x_accpt_disb_dt1 IN DATE,
71 x_accpt_disb_dt2 IN DATE,
72 x_accpt_disb_dt3 IN DATE,
73 x_accpt_disb_dt4 IN DATE,
74 x_accpt_disb_dt5 IN DATE,
75 x_accpt_disb_dt6 IN DATE,
76 x_accpt_disb_dt7 IN DATE,
77 x_accpt_disb_dt8 IN DATE,
78 x_accpt_disb_dt9 IN DATE,
79 x_accpt_disb_dt10 IN DATE,
80 x_accpt_disb_dt11 IN DATE,
81 x_accpt_disb_dt12 IN DATE,
82 x_accpt_disb_dt13 IN DATE,
83 x_accpt_disb_dt14 IN DATE,
84 x_accpt_disb_dt15 IN DATE,
85 x_accpt_enrl_dt IN DATE,
86 x_accpt_low_tut_flg IN VARCHAR2,
87 x_accpt_ver_stat_flg IN VARCHAR2,
88 x_accpt_incr_pell_cd IN VARCHAR2,
89 x_accpt_tran_num IN VARCHAR2,
90 x_accpt_efc IN NUMBER,
91 x_accpt_sec_efc IN VARCHAR2,
92 x_accpt_acad_cal IN VARCHAR2,
93 x_accpt_pymt_method IN VARCHAR2,
94 x_accpt_coa IN NUMBER,
95 x_accpt_enrl_stat IN VARCHAR2,
96 x_accpt_wks_inst_pymt IN VARCHAR2,
97 x_wk_inst_time_calc_pymt IN NUMBER,
98 x_accpt_wks_acad IN VARCHAR2,
99 x_accpt_cr_acad_yr IN VARCHAR2,
100 x_inst_seq_num IN VARCHAR2,
101 x_sch_full_time_pell IN NUMBER,
102 x_stud_name IN VARCHAR2,
103 x_ssn IN VARCHAR2,
104 x_stud_dob IN DATE,
105 x_cps_ver_sel_cd IN VARCHAR2,
106 x_ytd_disb_amt IN NUMBER,
107 x_batch_id IN VARCHAR2,
108 x_process_date IN DATE,
109 x_ci_cal_type IN VARCHAR2 DEFAULT NULL,
110 x_ci_sequence_number IN NUMBER DEFAULT NULL
111 );
112
113 PROCEDURE update_row (
114 x_rowid IN VARCHAR2,
115 x_ytdor_id IN NUMBER,
116 x_origination_id IN VARCHAR2,
117 x_original_ssn IN VARCHAR2,
118 x_original_name_cd IN VARCHAR2,
119 x_attend_pell_id IN VARCHAR2,
120 x_ed_use IN VARCHAR2,
121 x_inst_cross_ref_code IN VARCHAR2,
122 x_action_code IN VARCHAR2,
123 x_accpt_awd_amt IN NUMBER,
124 x_accpt_disb_dt1 IN DATE,
125 x_accpt_disb_dt2 IN DATE,
126 x_accpt_disb_dt3 IN DATE,
127 x_accpt_disb_dt4 IN DATE,
128 x_accpt_disb_dt5 IN DATE,
129 x_accpt_disb_dt6 IN DATE,
130 x_accpt_disb_dt7 IN DATE,
131 x_accpt_disb_dt8 IN DATE,
132 x_accpt_disb_dt9 IN DATE,
133 x_accpt_disb_dt10 IN DATE,
134 x_accpt_disb_dt11 IN DATE,
135 x_accpt_disb_dt12 IN DATE,
136 x_accpt_disb_dt13 IN DATE,
137 x_accpt_disb_dt14 IN DATE,
138 x_accpt_disb_dt15 IN DATE,
139 x_accpt_enrl_dt IN DATE,
140 x_accpt_low_tut_flg IN VARCHAR2,
141 x_accpt_ver_stat_flg IN VARCHAR2,
142 x_accpt_incr_pell_cd IN VARCHAR2,
143 x_accpt_tran_num IN VARCHAR2,
144 x_accpt_efc IN NUMBER,
145 x_accpt_sec_efc IN VARCHAR2,
146 x_accpt_acad_cal IN VARCHAR2,
147 x_accpt_pymt_method IN VARCHAR2,
148 x_accpt_coa IN NUMBER,
149 x_accpt_enrl_stat IN VARCHAR2,
150 x_accpt_wks_inst_pymt IN VARCHAR2,
151 x_wk_inst_time_calc_pymt IN NUMBER,
152 x_accpt_wks_acad IN VARCHAR2,
153 x_accpt_cr_acad_yr IN VARCHAR2,
154 x_inst_seq_num IN VARCHAR2,
155 x_sch_full_time_pell IN NUMBER,
156 x_stud_name IN VARCHAR2,
157 x_ssn IN VARCHAR2,
158 x_stud_dob IN DATE,
159 x_cps_ver_sel_cd IN VARCHAR2,
160 x_ytd_disb_amt IN NUMBER,
161 x_batch_id IN VARCHAR2,
162 x_process_date IN DATE,
163 x_mode IN VARCHAR2 DEFAULT 'R',
164 x_ci_cal_type IN VARCHAR2 DEFAULT NULL,
165 x_ci_sequence_number IN NUMBER DEFAULT NULL
166 );
167
168 PROCEDURE add_row (
169 x_rowid IN OUT NOCOPY VARCHAR2,
170 x_ytdor_id IN OUT NOCOPY NUMBER,
171 x_origination_id IN VARCHAR2,
172 x_original_ssn IN VARCHAR2,
173 x_original_name_cd IN VARCHAR2,
174 x_attend_pell_id IN VARCHAR2,
175 x_ed_use IN VARCHAR2,
176 x_inst_cross_ref_code IN VARCHAR2,
177 x_action_code IN VARCHAR2,
178 x_accpt_awd_amt IN NUMBER,
179 x_accpt_disb_dt1 IN DATE,
180 x_accpt_disb_dt2 IN DATE,
181 x_accpt_disb_dt3 IN DATE,
182 x_accpt_disb_dt4 IN DATE,
183 x_accpt_disb_dt5 IN DATE,
184 x_accpt_disb_dt6 IN DATE,
185 x_accpt_disb_dt7 IN DATE,
186 x_accpt_disb_dt8 IN DATE,
187 x_accpt_disb_dt9 IN DATE,
188 x_accpt_disb_dt10 IN DATE,
189 x_accpt_disb_dt11 IN DATE,
190 x_accpt_disb_dt12 IN DATE,
191 x_accpt_disb_dt13 IN DATE,
192 x_accpt_disb_dt14 IN DATE,
193 x_accpt_disb_dt15 IN DATE,
194 x_accpt_enrl_dt IN DATE,
195 x_accpt_low_tut_flg IN VARCHAR2,
196 x_accpt_ver_stat_flg IN VARCHAR2,
197 x_accpt_incr_pell_cd IN VARCHAR2,
198 x_accpt_tran_num IN VARCHAR2,
199 x_accpt_efc IN NUMBER,
200 x_accpt_sec_efc IN VARCHAR2,
201 x_accpt_acad_cal IN VARCHAR2,
202 x_accpt_pymt_method IN VARCHAR2,
203 x_accpt_coa IN NUMBER,
204 x_accpt_enrl_stat IN VARCHAR2,
205 x_accpt_wks_inst_pymt IN VARCHAR2,
206 x_wk_inst_time_calc_pymt IN NUMBER,
207 x_accpt_wks_acad IN VARCHAR2,
208 x_accpt_cr_acad_yr IN VARCHAR2,
209 x_inst_seq_num IN VARCHAR2,
210 x_sch_full_time_pell IN NUMBER,
211 x_stud_name IN VARCHAR2,
212 x_ssn IN VARCHAR2,
213 x_stud_dob IN DATE,
214 x_cps_ver_sel_cd IN VARCHAR2,
215 x_ytd_disb_amt IN NUMBER,
216 x_batch_id IN VARCHAR2,
217 x_process_date IN DATE,
218 x_mode IN VARCHAR2 DEFAULT 'R',
219 x_ci_cal_type IN VARCHAR2 DEFAULT NULL,
220 x_ci_sequence_number IN NUMBER DEFAULT NULL
221 );
222
223 PROCEDURE delete_row (
224 x_rowid IN VARCHAR2
225 );
226
227 FUNCTION get_pk_for_validation (
228 x_ytdor_id IN NUMBER
229 ) RETURN BOOLEAN;
230
231 PROCEDURE before_dml (
232 p_action IN VARCHAR2,
233 x_rowid IN VARCHAR2 DEFAULT NULL,
234 x_ytdor_id IN NUMBER DEFAULT NULL,
235 x_origination_id IN VARCHAR2 DEFAULT NULL,
236 x_original_ssn IN VARCHAR2 DEFAULT NULL,
237 x_original_name_cd IN VARCHAR2 DEFAULT NULL,
238 x_attend_pell_id IN VARCHAR2 DEFAULT NULL,
239 x_ed_use IN VARCHAR2 DEFAULT NULL,
240 x_inst_cross_ref_code IN VARCHAR2 DEFAULT NULL,
241 x_action_code IN VARCHAR2 DEFAULT NULL,
242 x_accpt_awd_amt IN NUMBER DEFAULT NULL,
243 x_accpt_disb_dt1 IN DATE DEFAULT NULL,
244 x_accpt_disb_dt2 IN DATE DEFAULT NULL,
245 x_accpt_disb_dt3 IN DATE DEFAULT NULL,
246 x_accpt_disb_dt4 IN DATE DEFAULT NULL,
247 x_accpt_disb_dt5 IN DATE DEFAULT NULL,
248 x_accpt_disb_dt6 IN DATE DEFAULT NULL,
249 x_accpt_disb_dt7 IN DATE DEFAULT NULL,
250 x_accpt_disb_dt8 IN DATE DEFAULT NULL,
251 x_accpt_disb_dt9 IN DATE DEFAULT NULL,
252 x_accpt_disb_dt10 IN DATE DEFAULT NULL,
253 x_accpt_disb_dt11 IN DATE DEFAULT NULL,
254 x_accpt_disb_dt12 IN DATE DEFAULT NULL,
255 x_accpt_disb_dt13 IN DATE DEFAULT NULL,
256 x_accpt_disb_dt14 IN DATE DEFAULT NULL,
257 x_accpt_disb_dt15 IN DATE DEFAULT NULL,
258 x_accpt_enrl_dt IN DATE DEFAULT NULL,
259 x_accpt_low_tut_flg IN VARCHAR2 DEFAULT NULL,
260 x_accpt_ver_stat_flg IN VARCHAR2 DEFAULT NULL,
261 x_accpt_incr_pell_cd IN VARCHAR2 DEFAULT NULL,
262 x_accpt_tran_num IN VARCHAR2 DEFAULT NULL,
263 x_accpt_efc IN NUMBER DEFAULT NULL,
264 x_accpt_sec_efc IN VARCHAR2 DEFAULT NULL,
265 x_accpt_acad_cal IN VARCHAR2 DEFAULT NULL,
266 x_accpt_pymt_method IN VARCHAR2 DEFAULT NULL,
267 x_accpt_coa IN NUMBER DEFAULT NULL,
268 x_accpt_enrl_stat IN VARCHAR2 DEFAULT NULL,
269 x_accpt_wks_inst_pymt IN VARCHAR2 DEFAULT NULL,
270 x_wk_inst_time_calc_pymt IN NUMBER DEFAULT NULL,
271 x_accpt_wks_acad IN VARCHAR2 DEFAULT NULL,
272 x_accpt_cr_acad_yr IN VARCHAR2 DEFAULT NULL,
273 x_inst_seq_num IN VARCHAR2 DEFAULT NULL,
274 x_sch_full_time_pell IN NUMBER DEFAULT NULL,
275 x_stud_name IN VARCHAR2 DEFAULT NULL,
276 x_ssn IN VARCHAR2 DEFAULT NULL,
277 x_stud_dob IN DATE DEFAULT NULL,
278 x_cps_ver_sel_cd IN VARCHAR2 DEFAULT NULL,
279 x_ytd_disb_amt IN NUMBER DEFAULT NULL,
280 x_batch_id IN VARCHAR2 DEFAULT NULL,
281 x_process_date IN DATE DEFAULT NULL,
282 x_creation_date IN DATE DEFAULT NULL,
283 x_created_by IN NUMBER DEFAULT NULL,
284 x_last_update_date IN DATE DEFAULT NULL,
285 x_last_updated_by IN NUMBER DEFAULT NULL,
286 x_last_update_login IN NUMBER DEFAULT NULL,
287 x_ci_cal_type IN VARCHAR2 DEFAULT NULL,
288 x_ci_sequence_number IN NUMBER DEFAULT NULL
289 );
290
291 END igf_gr_ytd_orig_pkg;