1 PACKAGE igf_sl_cl_orig AUTHID CURRENT_USER AS
2 /* $Header: IGFSL08S.pls 115.16 2003/10/30 07:17:00 ugummall ship $ */
3
4 /***************************************************************
5 Created By : mesriniv
6 Date Created By : 2000/11/13
7 Purpose : To Originate Common Line Loan Records and Create
8 Output File
9 Known Limitations,Enhancements or Remarks
10 Change History :
11 Who When What
12 ugummall 29-OCT-2003 Bug 3102439. FA 126 - Multiple FA Offices.
13 Added 4 new parameters to cl_originate and 3 to sub_cl_originate.
14 sjadhav 7-Oct-2003 Bug 3104228 Fa 122 Build
15 Added media type and recipient id
16 and relationship cd parameters
17 ***************************************************************/
18 PROCEDURE cl_originate(
19 errbuf OUT NOCOPY VARCHAR2,
20 retcode OUT NOCOPY NUMBER,
21 p_award_year IN VARCHAR2,
22 p_base_id IN VARCHAR2,
23 p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
24 p_loan_number IN igf_sl_loans_all.loan_number%TYPE,
25 p_org_id IN NUMBER,
26 p_media_type IN VARCHAR2,
27 p_recipient_id IN VARCHAR2,
28 p_school_id IN VARCHAR2,
29 non_ed_branch IN VARCHAR2,
30 sch_non_ed_branch IN VARCHAR2
31 );
32
33 PROCEDURE sub_cl_originate(
34 errbuf OUT NOCOPY VARCHAR2,
35 retcode OUT NOCOPY NUMBER,
36 p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
37 p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
38 p_loan_number IN igf_sl_loans_all.loan_number%TYPE,
39 p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
40 p_org_id IN NUMBER,
41 p_relationship_cd IN VARCHAR2,
42 p_media_type IN VARCHAR2,
43 p_base_id IN VARCHAR2,
44 p_school_id IN VARCHAR2,
45 sch_non_ed_branch IN VARCHAR2
46 );
47
48 END igf_sl_cl_orig;