1 PACKAGE igf_sl_dl_print_manifest AUTHID CURRENT_USER AS
2 /* $Header: IGFSL17S.pls 115.5 2002/11/28 14:35:27 nsidana noship $ */
3 /***************************************************************
4 Created By : rboddu
5 Date Created By : 2001/05/15
6 Purpose : The Direct Loan Manifest Promissory Note Process
7 picks up the Loans which have their PNote Status in the Direct Loan Orignation
8 Screen as 'Signed' for different sets of user inputs like "for a particular loan
9 ID/Student for a particular Loan Category(Stafford/PLUS), for a particular Award
10 Year and inserts the data into Direct Loan Manifest table, and sets the Promissory
11 Note Status for these Direct Loans to Manifested.
12 Change History :2216956
13 Who When What
14 adhawan 21-feb-2002 changed student id to base id as parameter
15 ***************************************************************/
16
17
18 PROCEDURE process_manifest(
19 ERRBUF OUT NOCOPY VARCHAR2,
20 RETCODE OUT NOCOPY NUMBER,
21 p_award_year IN VARCHAR2,
22 p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
23 p_base_id IN igf_aw_award.base_id%TYPE,
24 p_loan_number IN igf_sl_loans_v.loan_number%TYPE,
25 p_org_id IN NUMBER
26 );
27
28
29 END igf_sl_dl_print_manifest;