PACKAGE: APPS.ISC_DBI_CHANGE_LOG_PKG

Source

1 PACKAGE ISC_DBI_CHANGE_LOG_PKG AS
2 /* $Header: ISCCHGLS.pls 120.0 2005/05/25 17:29:30 appldev noship $ */
3 
4   ----------------
5   --  PUBLIC TYPES
6   ----------------
7 
8   TYPE log_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
9 
10   -----------------------------------------------------------
11   --  PUBLIC PROCEDURES
12   --
13   --  P_DML_TYPE can be 'DELETE, 'INSERT' or 'UPDATE'
14   --
15   --  X_RETURN_STATUS will return one of the following values
16   -- 	Success: FND_API.G_RET_STS_SUCCESS
17   --    Error  : FND_API.G_RET_STS_ERROR
18   --    Unexpected error: FND_API.G_RET_STS_UNEXP_ERROR
19   -----------------------------------------------------------
20 
21   PROCEDURE Update_Del_Detail_Log(	p_detail_list		IN LOG_TAB_TYPE,
22 					p_dml_type		IN VARCHAR2,
23 					x_return_status		OUT NOCOPY VARCHAR2);
24 
25   PROCEDURE Update_Trip_Stop_Log(	p_stop_list		IN LOG_TAB_TYPE,
26 					p_dml_type		IN VARCHAR2,
27 					x_return_status		OUT NOCOPY VARCHAR2);
28 
29   PROCEDURE Update_Fte_Invoice_Log (	p_invoice_list		IN LOG_TAB_TYPE,
30 					p_dml_type		IN VARCHAR2,
31 					x_return_status		OUT NOCOPY VARCHAR2);
32 
33 
34 END ISC_DBI_CHANGE_LOG_PKG;