PACKAGE: APPS.FUN_OPEN_INTERFACE_PKG

Source

1 PACKAGE FUN_OPEN_INTERFACE_PKG AUTHID CURRENT_USER AS
2 /* $Header: funximps.pls 120.7 2010/09/02 17:09:14 abhaktha ship $ */
3 
4 
5 /***********************************************
6 * Procedure Main :
7 *                        This Procedure Validates the Interface Table Data and       *
8 *		on success Inserts into FUN Final Tables			*
9 *										*
10 ***************************************************/
11 
12 PROCEDURE MAIN(
13     p_errbuff  OUT NOCOPY VARCHAR2,
14     p_retcode OUT NOCOPY NUMBER,
15     p_source IN VARCHAR2,
16     p_group_id IN NUMBER,
17     p_batch_id IN NUMBER,
18     p_import_transaction_as_sent IN VARCHAR2  default null,
19    p_rejected_only IN VARCHAR2  default null,
20    p_debug IN VARCHAR2
21 );
22 
23 /***********************************************
24 *   Procedure Purge_Interface_Table :					*
25 	*                        Procedure to Purge Accepted Records from the Interface Tables		*
26 *										*
27 ***************************************************/
28 
29 PROCEDURE Purge_Interface_Table
30         (
31                p_source               IN      VARCHAR2,
32                p_group_id	        IN     VARCHAR2
33         );
34 
35 	/*****************************************************
36 	*Procedure to purge the Rejected Transactions from interface tables.
37 	*
38 	********************************************************/
39 PROCEDURE Import_data_purge
40         (
41                errbuf             OUT NOCOPY VARCHAR2,
42                retcode            OUT NOCOPY NUMBER,
43                p_source           IN  VARCHAR2,
44                p_group_id         IN  NUMBER DEFAULT NULL,
45 	       p_review_required  IN  VARCHAR2
46         );
47 
48 END FUN_OPEN_INTERFACE_PKG;