1 PACKAGE igf_ap_process_corrections AS
2 /* $Header: IGFAP02S.pls 120.0 2005/06/01 15:46:35 appldev noship $ */
3 /*
4 || Created By : Sridhar
5 || Created On : 25-NOV-2000
6 || Purpose : Package creates a flat file with header,corrected records and trailer
7 || to be sent to CPS. After the file is created igf_ap_isir_corr,
8 || igf_ap_fa_base_rec tables are updated to change the correction_status.
9 || Known limitations, enhancements or remarks :
10 || Change History :
11 || Who When What
12 || ugummall 30-OCT-2003 Bug 3102439. FA 126 - Multiple FA Offices.
13 || Added 5 new parameters to prepare_file procedure namely
14 || p_base_id, school_type, p_school_code, eti_dest_code, eti_dest_num
15 -- cdcruz 17-Sep-2003 # 3085558 FA121-Verification Worksheet.
16 -- New validation added which will skip the student if one
17 -- or more holds exists.
18 -- Sql spool scrapped, and conc Job is called directly
19
20 */
21
22 PROCEDURE prepare_file( errbuf OUT NOCOPY VARCHAR2,
23 retcode OUT NOCOPY NUMBER,
24 p_award_year IN VARCHAR2,
25 p_base_id IN NUMBER,
26 school_type IN VARCHAR2,
27 p_school_code IN VARCHAR2,
28 eti_dest_code IN VARCHAR2,
29 eti_dest_num IN VARCHAR2
30 );
31
32 END igf_ap_process_corrections;