1 PACKAGE igs_fi_control_pkg AS
2 /* $Header: IGSSI78S.pls 120.2 2006/06/19 09:29:53 sapanigr ship $ */
3
4 /*******************************************************************************
5 Created by : Oracle IDC
6 Date created:
7
8 Purpose:
9 1. This function returns the status of a tracking group
10
11 Usage: (e.g. restricted, unrestricted, where to call from)
12 1. Called from IGSTR007.FMB
13
14 Known limitations/enhancements/remarks:
15 -
16
17 Change History: (who, when, what: NO CREATION RECORDS HERE!)
18 Who When What
19 svuppala 14-JUL-2005 Enh 3392095 - Tution Waivers build
20 Modified insert_row, lock_row, update_row and before_dml by adding two new columns
21 post_waiver_gl_flag, waiver_notify_finaid_flag
22 uudayapr 07-dec-2003 Enh#3167098 Modified the procedures BY removing the reference to prg_chg_dt_alias
23 and adding res_dt_alias.
24 shtatiko 27-MAY-2003 Enh# 2831582, Removed references to columns lockbox_context, lockbox_number_attribute
25 and ar_int_org_id.
26 vvutukur 16-May-2003 Enh#2831572.Financial Accounting Build. Added column acct_conv_flag.
27 pathipat 14-Apr-2003 Enh. 2831569 - Commercial Receivables build
28 Added col manage_accounts, removed cols interface_line_context, interface_line_attribute,
29 batch_source_id, cust_trx_type_id, term_id
30 smadathi 18-Feb-2002 Enh. Bug 2747329.Added new columns rfnd_destination, ap_org_id, dflt_supplier_site_name
31 smadathi 01-Nov-2002 Enh. Bug 2584986. Added new column currency_cd
32 pathipat 02-OCT-2002 Added column x_conv_process_run_ind, part of Enh Bug: 2562745
33 smvk 24-Sep-2002 Added the columns rec_gl_ccid, cash_gl_ccid, unapp_gl_ccid,
34 rec_account_cd, rev_account_cd, cash_account_cd and
35 unapp_account_cd. As a part of Bug # 2564643.
36 vchappid 01-Apr-2002 Bug# 2293676, Added column planned_credits_ind
37 smvk 13-Mar-2002 Added four columns refund_dr_gl_ccid, refund_cr_gl_ccid,
38 refund_dr_account_cd, refund_cr_account_cd, refund_dt_alias and
39 removed last_account_trans, last_payment_trans,
40 last_pay_term_trans w.r.t Bug # 2144600
41 msrinivi 17 Jul,2001 Added 1 new col : set_of_books_id
42 vvutukur 13-02-2002 Added new col : ar_int_org_id
43 *******************************************************************************/
44 PROCEDURE insert_row (
45 x_rowid IN OUT NOCOPY VARCHAR2,
46 x_rec_installed IN VARCHAR2,
47 x_mode IN VARCHAR2 DEFAULT 'R',
48 x_accounting_method IN VARCHAR2,
49 x_set_of_books_id IN NUMBER DEFAULT NULL,
50 x_refund_dr_gl_ccid IN NUMBER DEFAULT NULL,
51 x_refund_cr_gl_ccid IN NUMBER DEFAULT NULL,
52 x_refund_dr_account_cd IN VARCHAR2 DEFAULT NULL,
53 x_refund_cr_account_cd IN VARCHAR2 DEFAULT NULL,
54 x_refund_dt_alias IN VARCHAR2 DEFAULT NULL,
55 x_fee_calc_mthd_code IN VARCHAR2 DEFAULT NULL,
56 x_planned_credits_ind IN VARCHAR2 DEFAULT NULL,
57 x_rec_gl_ccid IN NUMBER DEFAULT NULL,
58 x_cash_gl_ccid IN NUMBER DEFAULT NULL,
59 x_unapp_gl_ccid IN NUMBER DEFAULT NULL,
60 x_rec_account_cd IN VARCHAR2 DEFAULT NULL,
61 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
62 x_cash_account_cd IN VARCHAR2 DEFAULT NULL,
63 x_unapp_account_cd IN VARCHAR2 DEFAULT NULL,
64 x_conv_process_run_ind IN NUMBER DEFAULT NULL,
65 x_currency_cd IN VARCHAR2 DEFAULT NULL,
66 x_rfnd_destination IN VARCHAR2 DEFAULT NULL,
67 x_ap_org_id IN NUMBER DEFAULT NULL,
68 x_dflt_supplier_site_name IN VARCHAR2 DEFAULT NULL,
69 x_manage_accounts IN VARCHAR2 DEFAULT NULL,
70 x_acct_conv_flag IN VARCHAR2 DEFAULT NULL,
71 x_post_waiver_gl_flag IN VARCHAR2 DEFAULT NULL,
72 x_waiver_notify_finaid_flag IN VARCHAR2 DEFAULT NULL
73 );
74
75
76 /*******************************************************************************
77 Created by : Oracle IDC
78 Date created:
79
80 Purpose:
81 1. This function returns the status of a tracking group
82
83 Usage: (e.g. restricted, unrestricted, where to call from)
84
85 Known limitations/enhancements/remarks:
86 -
87
88 Change History: (who, when, what: NO CREATION RECORDS HERE!)
89 Who When What
90 svuppala 14-JUL-2005 Enh 3392095 - Tution Waivers build
91 Modified by adding two new columns post_waiver_gl_flag, waiver_notify_finaid_flag
92 | uudayapr 07-dec-2003 Enh#3167098 Modified the procedures BY removing the reference to prg_chg_dt_alias
93 and adding res_dt_alias.
94 shtatiko 27-MAY-2003 Enh# 2831582, Removed references to columns lockbox_context, lockbox_number_attribute
95 and ar_int_org_id.
96 vvutukur 16-May-2003 Enh#2831572.Financial Accounting Build. Added column acct_conv_flag.
97 pathipat 14-Apr-2003 Enh. 2831569 - Commercial Receivables build
98 Added col manage_accounts, removed cols interface_line_context, interface_line_attribute,
99 batch_source_id, cust_trx_type_id, term_id
100 smadathi 18-Feb-2002 Enh. Bug 2747329.Added new columns rfnd_destination, ap_org_id, dflt_supplier_site_name
101 smadathi 01-Nov-2002 Enh. Bug 2584986. Added new column currency_cd
102 pathipat 02-OCT-2002 Added column x_conv_process_run_ind, part of Enh Bug: 2562745
103 smvk 24-Sep-2002 Added the columns rec_gl_ccid, cash_gl_ccid, unapp_gl_ccid,
104 rec_account_cd, rev_account_cd, cash_account_cd and
105 unapp_account_cd. As a part of Bug # 2564643.
106 vchappid 01-Apr-2002 Bug# 2293676, Added column planned_credits_ind
107 smvk 13-Mar-2002 Added four columns refund_dr_gl_ccid, refund_cr_gl_ccid,
108 refund_dr_account_cd, refund_cr_account_cd, refund_dt_alias and
109 removed last_account_trans, last_payment_trans,
110 last_pay_term_trans w.r.t Bug # 2144600
111 msrinivi 17 Jul,2001 Added 1 new col : set_of_books_id
112 vvutukur 13-02-2002 Added new col : ar_int_org_id
113 *******************************************************************************/
114 PROCEDURE lock_row (
115 x_rowid IN VARCHAR2,
116 x_rec_installed IN VARCHAR2,
117 x_accounting_method IN VARCHAR2,
118 x_set_of_books_id IN NUMBER DEFAULT NULL,
119 x_refund_dr_gl_ccid IN NUMBER DEFAULT NULL,
120 x_refund_cr_gl_ccid IN NUMBER DEFAULT NULL,
121 x_refund_dr_account_cd IN VARCHAR2 DEFAULT NULL,
122 x_refund_cr_account_cd IN VARCHAR2 DEFAULT NULL,
123 x_refund_dt_alias IN VARCHAR2 DEFAULT NULL,
124 x_fee_calc_mthd_code IN VARCHAR2 DEFAULT NULL,
125 x_planned_credits_ind IN VARCHAR2 DEFAULT NULL,
126 x_rec_gl_ccid IN NUMBER DEFAULT NULL,
127 x_cash_gl_ccid IN NUMBER DEFAULT NULL,
128 x_unapp_gl_ccid IN NUMBER DEFAULT NULL,
129 x_rec_account_cd IN VARCHAR2 DEFAULT NULL,
130 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
131 x_cash_account_cd IN VARCHAR2 DEFAULT NULL,
132 x_unapp_account_cd IN VARCHAR2 DEFAULT NULL,
133 x_conv_process_run_ind IN NUMBER DEFAULT NULL,
134 x_currency_cd IN VARCHAR2 DEFAULT NULL,
135 x_rfnd_destination IN VARCHAR2 DEFAULT NULL,
136 x_ap_org_id IN NUMBER DEFAULT NULL,
137 x_dflt_supplier_site_name IN VARCHAR2 DEFAULT NULL,
138 x_manage_accounts IN VARCHAR2 DEFAULT NULL,
139 x_acct_conv_flag IN VARCHAR2 DEFAULT NULL,
140 x_post_waiver_gl_flag IN VARCHAR2 DEFAULT NULL,
141 x_waiver_notify_finaid_flag IN VARCHAR2 DEFAULT NULL
142 );
143
144 /*******************************************************************************
145 Created by : Oracle IDC
146 Date created:
147
148 Purpose:
149 1. This function returns the status of a tracking group
150
151 Usage: (e.g. restricted, unrestricted, where to call from)
152
153 Known limitations/enhancements/remarks:
154 -
155
156 Change History: (who, when, what: NO CREATION RECORDS HERE!)
157 Who When What
158 svuppala 14-JUL-2005 Enh 3392095 - Tution Waivers build
159 Modified by adding two new columns post_waiver_gl_flag, waiver_notify_finaid_flag
160 uudayapr 07-dec-2003 Enh#3167098 Modified the procedures BY removing the reference to prg_chg_dt_alias
161 and adding res_dt_alias.
162 shtatiko 27-MAY-2003 Enh# 2831582, Removed references to columns lockbox_context, lockbox_number_attribute
163 and ar_int_org_id.
164 vvutukur 16-May-2003 Enh#2831572.Financial Accounting Build. Added column acct_conv_flag.
165 pathipat 14-Apr-2003 Enh. 2831569 - Commercial Receivables build
166 Added col manage_accounts, removed cols interface_line_context, interface_line_attribute,
167 batch_source_id, cust_trx_type_id, term_id
168 smadathi 18-Feb-2002 Enh. Bug 2747329.Added new columns rfnd_destination, ap_org_id, dflt_supplier_site_name
169 smadathi 01-Nov-2002 Enh. Bug 2584986. Added new column currency_cd
170 pathipat 02-OCT-2002 Added column x_conv_process_run_ind, part of Enh Bug: 2562745
171 smvk 24-Sep-2002 Added the columns rec_gl_ccid, cash_gl_ccid, unapp_gl_ccid,
172 rec_account_cd, rev_account_cd, cash_account_cd and
173 unapp_account_cd. As a part of Bug # 2564643.
174 vchappid 01-Apr-2002 Bug# 2293676, Added column planned_credits_ind
175 smvk 13-Mar-2002 Added four columns refund_dr_gl_ccid, refund_cr_gl_ccid,
176 refund_dr_account_cd, refund_cr_account_cd, refund_dt_alias and
177 removed last_account_trans, last_payment_trans,
178 last_pay_term_trans w.r.t Bug # 2144600
179 msrinivi 17 Jul,2001 Added 1 new col : set_of_books_id
180 vvutukur 13-02-2002 Added new col : ar_int_org_id
181 *******************************************************************************/
182 PROCEDURE update_row (
183 x_rowid IN VARCHAR2,
184 x_rec_installed IN VARCHAR2,
185 x_mode IN VARCHAR2 DEFAULT 'R',
186 x_accounting_method IN VARCHAR2,
187 x_set_of_books_id IN NUMBER DEFAULT NULL,
188 x_refund_dr_gl_ccid IN NUMBER DEFAULT NULL,
189 x_refund_cr_gl_ccid IN NUMBER DEFAULT NULL,
190 x_refund_dr_account_cd IN VARCHAR2 DEFAULT NULL,
191 x_refund_cr_account_cd IN VARCHAR2 DEFAULT NULL,
192 x_refund_dt_alias IN VARCHAR2 DEFAULT NULL,
193 x_fee_calc_mthd_code IN VARCHAR2 DEFAULT NULL,
194 x_planned_credits_ind IN VARCHAR2 DEFAULT NULL,
195 x_rec_gl_ccid IN NUMBER DEFAULT NULL,
196 x_cash_gl_ccid IN NUMBER DEFAULT NULL,
197 x_unapp_gl_ccid IN NUMBER DEFAULT NULL,
198 x_rec_account_cd IN VARCHAR2 DEFAULT NULL,
199 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
200 x_cash_account_cd IN VARCHAR2 DEFAULT NULL,
201 x_unapp_account_cd IN VARCHAR2 DEFAULT NULL,
202 x_conv_process_run_ind IN NUMBER DEFAULT NULL,
203 x_currency_cd IN VARCHAR2 DEFAULT NULL,
204 x_rfnd_destination IN VARCHAR2 DEFAULT NULL,
205 x_ap_org_id IN NUMBER DEFAULT NULL,
206 x_dflt_supplier_site_name IN VARCHAR2 DEFAULT NULL,
207 x_manage_accounts IN VARCHAR2 DEFAULT NULL,
208 x_acct_conv_flag IN VARCHAR2 DEFAULT NULL,
209 x_post_waiver_gl_flag IN VARCHAR2 DEFAULT NULL,
210 x_waiver_notify_finaid_flag IN VARCHAR2 DEFAULT NULL
211 );
212
213
214 /*******************************************************************************
215 Created by : Oracle IDC
216 Date created:
217
218 Purpose:
219 1. This function returns the status of a tracking group
220
221 Usage: (e.g. restricted, unrestricted, where to call from)
222
223 Known limitations/enhancements/remarks:
224 -
225
226 Change History: (who, when, what: NO CREATION RECORDS HERE!)
227 Who When What
228 *******************************************************************************/
229 PROCEDURE delete_row (
230 x_rowid IN VARCHAR2
231 ) ;
232
233 /*******************************************************************************
234 Created by : Oracle IDC
235 Date created:
236
237 Purpose:
238 1. This function returns the status of a tracking group
239
240 Usage: (e.g. restricted, unrestricted, where to call from)
241 1. Called from IGSTR007.FMB
242
243 Known limitations/enhancements/remarks:
244 -
245
246 Change History: (who, when, what: NO CREATION RECORDS HERE!)
247 Who When What
248 *******************************************************************************/
249
250
251 FUNCTION get_pk_for_validation (
252 x_rec_installed IN VARCHAR2
253 ) RETURN BOOLEAN ;
254
255 /*******************************************************************************
256 Created by : Oracle IDC
257 Date created:
258
259 Purpose:
260 1. This function returns the status of a tracking group
261
262 Usage: (e.g. restricted, unrestricted, where to call from)
263
264 Known limitations/enhancements/remarks:
265 -
266
267 Change History: (who, when, what: NO CREATION RECORDS HERE!)
268 Who When What
269 *******************************************************************************/
270
271 PROCEDURE get_fk_igs_ca_da (
272 x_dt_alias IN VARCHAR2
273 );
274 /*******************************************************************************
275 Created by : svuppala , Oracle IDC
276 Date created: 03-Apr-2006
277
278 Purpose:
279 This procedure is created as part of the bug 4025077 to add FK relation for refund_dt_alias
280 coulmn in IGS_FI_CONTROL table with dt_alias coulmn in IGS_CA_DA table.
281
282 Change History: (who, when, what: NO CREATION RECORDS HERE!)
283 Who When What
284 *******************************************************************************/
285
286 PROCEDURE check_constraints (
287 column_name IN VARCHAR2 DEFAULT NULL,
288 column_value IN VARCHAR2 DEFAULT NULL ) ;
289
290 /*******************************************************************************
291 Created by : Oracle IDC
292 Date created:
293
294 Purpose:
295 1. This function returns the status of a tracking group
296
297 Usage: (e.g. restricted, unrestricted, where to call from)
298
299 Known limitations/enhancements/remarks:
300 -
301
302 Change History: (who, when, what: NO CREATION RECORDS HERE!)
303 Who When What
304 svuppala 14-JUL-2005 Enh 3392095 - Tution Waivers build
305 Modified by adding two new columns post_waiver_gl_flag, waiver_notify_finaid_flag
306 uudayapr 07-dec-2003 Enh#3167098 Modified the procedures BY removing the reference to prg_chg_dt_alias
307 and adding res_dt_alias.
308 shtatiko 27-MAY-2003 Enh# 2831582, Removed references to columns lockbox_context, lockbox_number_attribute
309 and ar_int_org_id.
310 vvutukur 16-May-2003 Enh#2831572.Financial Accounting Build. Added column acct_conv_flag.
311 pathipat 14-Apr-2003 Enh. 2831569 - Commercial Receivables build
312 Added col manage_accounts, removed cols interface_line_context, interface_line_attribute,
313 batch_source_id, cust_trx_type_id, term_id
314 smadathi 18-Feb-2002 Enh. Bug 2747329.Added new columns rfnd_destination, ap_org_id, dflt_supplier_site_name
315 smadathi 01-Nov-2002 Enh. Bug 2584986. Added new column currency_cd
316 pathipat 02-OCT-2002 Added column x_conv_process_run_ind, part of Enh Bug: 2562745
317 smvk 24-Sep-2002 Added the columns rec_gl_ccid, cash_gl_ccid, unapp_gl_ccid,
318 rec_account_cd, rev_account_cd, cash_account_cd and
319 unapp_account_cd. As a part of Bug # 2564643.
320 vchappid 01-Apr-2002 Bug# 2293676, Added column planned_credits_ind
321 smvk 13-Mar-2002 Added four columns refund_dr_gl_ccid, refund_cr_gl_ccid,
322 refund_dr_account_cd, refund_cr_account_cd, refund_dt_alias and
323 removed last_account_trans, last_payment_trans,
324 last_pay_term_trans w.r.t Bug # 2144600
325 msrinivi 17 Jul,2001 Added 1 new col: set_of_books_id
326 vvutukur 13-02-2002 Added new col : ar_int_org_id
327 *******************************************************************************/
328
329 PROCEDURE before_dml (
330 p_action IN VARCHAR2,
331 x_rowid IN VARCHAR2 DEFAULT NULL,
332 x_rec_installed IN VARCHAR2 DEFAULT NULL,
333 x_creation_date IN DATE DEFAULT NULL,
334 x_created_by IN NUMBER DEFAULT NULL,
335 x_last_update_date IN DATE DEFAULT NULL,
336 x_last_updated_by IN NUMBER DEFAULT NULL,
337 x_last_update_login IN NUMBER DEFAULT NULL,
338 x_ACCOUNTING_METHOD IN VARCHAR2 DEFAULT NULL,
339 x_set_of_books_id IN NUMBER DEFAULT NULL,
340 x_refund_dr_gl_ccid IN NUMBER DEFAULT NULL,
341 x_refund_cr_gl_ccid IN NUMBER DEFAULT NULL,
342 x_refund_dr_account_cd IN VARCHAR2 DEFAULT NULL,
343 x_refund_cr_account_cd IN VARCHAR2 DEFAULT NULL,
344 x_refund_dt_alias IN VARCHAR2 DEFAULT NULL,
345 x_fee_calc_mthd_code IN VARCHAR2 DEFAULT NULL,
346 x_planned_credits_ind IN VARCHAR2 DEFAULT NULL,
347 x_rec_gl_ccid IN NUMBER DEFAULT NULL,
348 x_cash_gl_ccid IN NUMBER DEFAULT NULL,
349 x_unapp_gl_ccid IN NUMBER DEFAULT NULL,
350 x_rec_account_cd IN VARCHAR2 DEFAULT NULL,
351 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
352 x_cash_account_cd IN VARCHAR2 DEFAULT NULL,
353 x_unapp_account_cd IN VARCHAR2 DEFAULT NULL,
354 x_conv_process_run_ind IN NUMBER DEFAULT NULL,
355 x_currency_cd IN VARCHAR2 DEFAULT NULL,
356 x_rfnd_destination IN VARCHAR2 DEFAULT NULL,
357 x_ap_org_id IN NUMBER DEFAULT NULL,
358 x_dflt_supplier_site_name IN VARCHAR2 DEFAULT NULL,
359 x_manage_accounts IN VARCHAR2 DEFAULT NULL,
360 x_acct_conv_flag IN VARCHAR2 DEFAULT NULL,
361 x_post_waiver_gl_flag IN VARCHAR2 DEFAULT NULL,
362 x_waiver_notify_finaid_flag IN VARCHAR2 DEFAULT NULL
363 );
364
365 END igs_fi_control_pkg;