[Home] [Help]
PACKAGE: APPS.IGF_SL_CL_CHG_FILE
Source
1 PACKAGE igf_sl_cl_chg_file AS
2 /* $Header: IGFSL24S.pls 120.0 2005/06/01 13:42:41 appldev noship $ */
3
4 ------------------------------------------------------------------
5 --Created by : Sanil Madathil, Oracle IDC
6 --Date created: 10 October 2004
7 --
8 --Purpose:
9 -- Invoked : From concurrent manager
10 -- Function : FFELP Change Send File Creation
11 --
12 --Known limitations/enhancements and/or remarks:
13 --
14 --Change History:
15 --Who When What
16 ------------------------------------------------------------------
17
18 PROCEDURE create_file (
19 errbuf OUT NOCOPY VARCHAR2,
20 retcode OUT NOCOPY NUMBER,
21 p_v_award_year IN VARCHAR2,
22 p_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
23 p_n_dummy_1 IN NUMBER,
24 p_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
25 p_n_dummy_2 IN NUMBER,
26 p_n_loan_id IN igf_sl_loans_all.loan_id%TYPE,
27 p_n_dummy_3 IN NUMBER,
28 p_n_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,
29 p_v_media_type IN igf_lookups_view.lookup_code%TYPE,
30 p_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE,
31 p_v_non_ed_branch IN igf_sl_school_codes_v.system_id_type%TYPE,
32 p_v_sch_non_ed_branch IN igf_sl_school_codes_v.alternate_identifier%TYPE
33 );
34
35 PROCEDURE sub_create_file(
36 errbuf OUT NOCOPY VARCHAR2,
37 retcode OUT NOCOPY NUMBER,
38 p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
39 p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
40 p_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
41 p_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
42 p_n_loan_id IN igf_sl_loans_all.loan_id%TYPE,
43 p_v_relationship_cd IN igf_sl_cl_recipient.relationship_cd%TYPE,
44 p_v_media_type IN igf_lookups_view.lookup_code%TYPE,
45 p_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE,
46 p_v_sch_non_ed_branch IN igf_sl_school_codes_v.alternate_identifier%TYPE
47 );
48
49 END igf_sl_cl_chg_file;