1 PACKAGE igf_sl_cl_create_chg AS
2 /* $Header: IGFSL22S.pls 120.0 2005/06/01 13:54:38 appldev noship $ */
3
4 ------------------------------------------------------------------
5 --Created by : Sanil Madathil, Oracle IDC
6 --Date created: 10 October 2004
7 --
8 --Purpose:
9 -- Invoked : Through Table Handlers of Disbursement and Loans table
10 -- Function : To create Change Records for CommonLine Release 4 version Loans.
11 -- Four routines defined in this package would be invoked for changes
12 -- IN award or loan information for CommonLine Release 4 version Loans
13 -- that are "Accepted"
14 --
15 --Known limitations/enhancements and/or remarks:
16 --
17 --Change History:
18 --Who When What
19 ------------------------------------------------------------------
20
21 PROCEDURE create_loan_chg_rec( p_new_loan_rec IN igf_sl_loans_all%ROWTYPE,
22 p_b_return_status OUT NOCOPY BOOLEAN,
23 p_v_message_name OUT NOCOPY VARCHAR2
24 );
25
26 PROCEDURE create_lor_chg_rec ( p_new_lor_rec IN igf_sl_lor_all%ROWTYPE,
27 p_b_return_status OUT NOCOPY BOOLEAN,
28 p_v_message_name OUT NOCOPY VARCHAR2
29 );
30
31 PROCEDURE create_awd_chg_rec ( p_n_award_id IN igf_aw_award_all.award_id%TYPE,
32 p_n_old_amount IN NUMBER,
33 p_n_new_amount IN NUMBER,
34 p_v_chg_type IN VARCHAR2,
35 p_b_return_status OUT NOCOPY BOOLEAN,
36 p_v_message_name OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE create_disb_chg_rec ( p_new_disb_rec IN igf_aw_awd_disb_all%ROWTYPE,
40 p_old_disb_rec IN igf_aw_awd_disb_all%ROWTYPE,
41 p_b_return_status OUT NOCOPY BOOLEAN,
42 p_v_message_name OUT NOCOPY VARCHAR2
43 );
44
45 END igf_sl_cl_create_chg;