1 PACKAGE igf_sl_dl_chg_ack AUTHID CURRENT_USER AS
2 /* $Header: IGFSL06S.pls 115.5 2002/11/28 14:33:19 nsidana ship $ */
3
4 /*************************************************************
5 Created By : venagara
6 Date Created On : 2000/11/29
7 Purpose : Direct Loan Change Acknowledgement Process
8 This sql*loader loads the data from the response file into the
9 temporary table.
10 This process can load the file type :
11 1. Change Response File
12 This process
13 - Reads the header file to ensure correct input file.
14 - Parses the file as per the format and loads into response
15 interface tables.
16 - Every Loan Number in the transaction record is checked for few
17 conditions like Batch ID in the header File and File creation Date.
18 If already not loaded, then loads the results.
19
20 Know limitations, enhancements or remarks
21 Change History
22 Who When What
23
24 (reverse chronological order - newest change first)
25 ***************************************************************/
26
27
28 PROCEDURE dl_chg_ack(errbuf OUT NOCOPY VARCHAR2,
29 retcode OUT NOCOPY NUMBER,
30 p_org_id IN NUMBER );
31
32
33 END igf_sl_dl_chg_ack;