1 PACKAGE igf_sl_dl_orig_ack AUTHID CURRENT_USER AS
2 /* $Header: IGFSL04S.pls 115.6 2003/02/20 15:40:09 sjadhav ship $ */
3
4 -------------------------------------------------------------------------
5 --
6 -- Created By : venagara
7 -- Date Created On : 2000/11/22
8 -- Purpose : Direct Loan Acknowledgement Process
9 -- This sql*loader loads the data from the response file into the
10 -- temporary table.
11 --
12 -- This process can load and take in updates for 2 file types :
13 -- 1. Origination Response File
14 -- 2. Credit Response File (incase of PLUS)
15 --
16 -- This process
17 -- - Reads the header file to ensure correct input file.
18 -- - Parses the file as per the format and loads into response
19 -- interface tables.
20 -- - Every Loan ID in the transaction record is checked for few
21 -- conditions like acknowledgement date etc and Loan Origination
22 -- record to reflect the Status
23 --
24 -- Know limitations, enhancements or remarks
25 -------------------------------------------------------------------------
26 -- sjadhav 19-Feb-2003 Bug 2758812 - FA 117 Build
27 -- Added
28 -- dl_credit_ack to process
29 -- Credit Response File
30 -------------------------------------------------------------------------
31
32
33
34 PROCEDURE dl_orig_ack(errbuf OUT NOCOPY VARCHAR2,
35 retcode OUT NOCOPY NUMBER,
36 p_org_id IN NUMBER );
37
38 PROCEDURE dl_credit_ack(errbuf OUT NOCOPY VARCHAR2,
39 retcode OUT NOCOPY NUMBER);
40
41 END igf_sl_dl_orig_ack;