1 PACKAGE igf_db_dl_reconc AUTHID CURRENT_USER AS
2 /* $Header: IGFDB07S.pls 115.3 2003/10/16 15:21:37 ugummall noship $ */
3 /***************************************************************
4 Created By : adhawan
5 Date Created By : 22-jan-2002
6 Purpose : To load the
7 Known Limitations,Enhancements or Remarks:
8 Change History :2154941
9 Who When What
10 ugummall 15-OCT-2003 Bug # 3102439. FA 126 Multiple FA Offices.
11 added two new parameters school_type and p_school_code to
12 main_smr and main_dtl procedures.
13 adhawan 22-jan-2002 Disbursements build
14 ***************************************************************/
15 PROCEDURE main_smr (errbuf OUT NOCOPY VARCHAR2,
16 retcode OUT NOCOPY NUMBER,
17 p_award_year IN VARCHAR2,
18 SCHOOL_TYPE IN VARCHAR2,
19 P_SCHOOL_CODE IN VARCHAR2
20 ) ;
21
22 PROCEDURE main_dtl (errbuf OUT NOCOPY VARCHAR2,
23 retcode OUT NOCOPY NUMBER,
24 p_award_year IN VARCHAR2,
25 SCHOOL_TYPE IN VARCHAR2,
26 P_SCHOOL_CODE IN VARCHAR2
27 );
28
29 END igf_db_dl_reconc;