1 PACKAGE igs_fi_prc_refunds AS
2 /* $Header: IGSFI65S.pls 120.0 2005/06/02 00:32:03 appldev noship $ */
3 /***********************************************************************************************
4
5 Created By : Amit Gairola
6 Date Created By: 11-Mar-2002
7 Purpose : This package does the Refund Processing for Excess Unapplied Credits
8 Known limitations,enhancements,remarks:
9 Change History
10 Who When What
11 vvutukur 19-Nov-2002 Enh#2584986.Added p_d_gl_date IN parameter to the procedures process_plus,process_batch.
12 ********************************************************************************************** */
13
14 -- Procedure for creating the Refunds for the PLUS loans
15 PROCEDURE process_plus(p_credit_id IN NUMBER,
16 p_borrower_id IN NUMBER,
17 p_err_message OUT NOCOPY VARCHAR2,
18 p_status OUT NOCOPY BOOLEAN,
19 p_d_gl_date IN DATE DEFAULT NULL);
20
21 -- Procedure for creating the Refunds through a Concurrent Program
22 PROCEDURE process_batch(errbuf OUT NOCOPY VARCHAR2,
23 retcode OUT NOCOPY NUMBER,
24 p_person_id IN NUMBER,
25 p_person_id_grp IN NUMBER,
26 p_add_drop IN VARCHAR2,
27 p_test_run IN VARCHAR2,
28 p_d_gl_date IN VARCHAR2 DEFAULT NULL);
29
30 -- Log the message in a log file based based on the level passed
31 -- This procedure will write the line with 3*level no. of spaces
32 -- appended to the value
33 PROCEDURE log_message(p_lookup_type IN VARCHAR2,
34 p_lookup_code IN VARCHAR2,
35 p_value IN VARCHAR2,
36 p_level IN NUMBER);
37
38
39 END igs_fi_prc_refunds;