1 PACKAGE igs_fi_imp_lockbox_txns AUTHID CURRENT_USER AS
2 /* $Header: IGSFI58S.pls 115.7 2002/11/29 00:26:39 nsidana ship $ */
3 /******************************************************************
4 Created By :Sanjeeb Rakshit
5 Date Created By :25-APR-2001
6 Purpose :This package implements one procedure which insert rows to credits table
7 from interface table if everything is fine else updates the interface table
8 and writes appropriate message in the log file.
9
10 remarks :
11 Change History
12 Who When What
13 agairola 24-Apr-2002 for the bug fix 2336504, removed the parameter p_credit_class
14 sykrishn 05-FEB-2002 --- Removed parameter credit source from this package
15 sarakshi 25-APR-2001 implementation of the package from scratch.
16 ******************************************************************/
17
18 PROCEDURE import_lockbox( errbuf OUT NOCOPY VARCHAR2,
19 retcode OUT NOCOPY NUMBER,
20 p_receipt_lockbox_number igs_fi_crd_int_all.receipt_lockbox_number%TYPE DEFAULT NULL,
21 p_credit_instrument igs_fi_crd_int_all.credit_instrument%TYPE ,
22 p_credit_type_id igs_fi_crd_int_all.credit_type_id%TYPE ,
23 p_org_id NUMBER
24 );
25
26 END igs_fi_imp_lockbox_txns;