1 PACKAGE igf_sl_rel_disb AS
2 /* $Header: IGFSL27S.pls 120.1 2006/04/05 00:22:45 veramach noship $ */
3
4 -----------------------------------------------------------------------------------
5 --
6 -- Created By : pssahni
7 -- Date Created By : 2004/09/24
8 -- Purpose :
9 -----------------------------------------------------------------------------------
10
11 -- This is the callable from Concurrent Manager
12
13 PROCEDURE rel_disb_process_dl(errbuf OUT NOCOPY VARCHAR2,
14 retcode OUT NOCOPY NUMBER,
15 p_award_year IN VARCHAR2,
16 p_pell_dummy IN VARCHAR2,
17 p_dl_dummy IN VARCHAR2,
18 p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
19 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
20 p_per_dummy IN NUMBER,
21 p_loan_id IN NUMBER,
22 p_loan_dummy IN NUMBER,
23 p_per_grp_id IN NUMBER,
24 p_trans_type IN igf_aw_awd_disb_all.trans_type%TYPE
25 );
26
27
28 PROCEDURE rel_disb_process_fed(errbuf OUT NOCOPY VARCHAR2,
29 retcode OUT NOCOPY NUMBER,
30 p_award_year IN VARCHAR2,
31 p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
32 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
33 p_per_dummy IN NUMBER,
34 p_loan_id IN NUMBER,
35 p_loan_dummy IN NUMBER,
36 p_trans_type IN VARCHAR2,
37 p_per_grp_id IN NUMBER
38
39 );
40
41 -- Parameters
42 --
43 -- p_award_year Award Year
44 -- p_fund_id Fund ID
45 -- p_base_id Base ID
46 -- p_loan_id Loan ID
47 -- p_per_grp_id Person Group ID
48
49 PROCEDURE rel_disb_process(p_errbuf OUT NOCOPY VARCHAR2,
50 p_retcode OUT NOCOPY NUMBER,
51 p_award_year IN VARCHAR2,
52 p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
53 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
54 p_loan_id IN NUMBER,
55 p_trans_type IN VARCHAR2,
56 p_per_grp_id IN NUMBER
57 );
58
59
60 PROCEDURE process_student( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
61 p_result IN OUT NOCOPY VARCHAR2,
62 p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
63 p_award_id igf_aw_award_all.award_id%TYPE,
64 p_loan_id igf_sl_loans_all.loan_id%TYPE,
65 p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,
66 p_trans_type VARCHAR2
67 );
68
69 END igf_sl_rel_disb;