1 PACKAGE JTM_MESSAGE_LOG_PKG AS
2 /* $Header: jtmmlps.pls 120.2 2005/08/30 00:23:53 utekumal noship $ */
3
4 G_EXC_ERROR EXCEPTION;
5
6 --Bug 4496299
7 PROCEDURE LOG_MSG( v_object_id IN VARCHAR2
8 , v_object_name IN VARCHAR2
9 , v_message IN VARCHAR2
10 , v_level_id IN NUMBER DEFAULT JTM_HOOK_UTIL_PKG.g_debug_level_full
11 , v_module IN VARCHAR2 DEFAULT 'jtm_message_log_pkg');
12 /* PWU: the queries n procedure PURGE are costly and there are issues with
13 performance we take them out since we only provide for developer
14 to conveniently remove the log records. */
15 /*
16 PROCEDURE PURGE;
17 */
18
19 PROCEDURE INSERT_CONC_STATUS_LOG(v_package_name IN VARCHAR2
20 ,v_procedure_name IN VARCHAR2
21 ,v_con_query_id IN NUMBER
22 ,v_query_stmt IN VARCHAR2
23 ,v_start_time IN DATE
24 ,v_end_time IN DATE
25 ,v_status VARCHAR2
26 ,v_message IN VARCHAR2
27 ,x_log_id OUT NOCOPY NUMBER
28 ,x_status OUT NOCOPY VARCHAR2
29 ,x_msg_data OUT NOCOPY VARCHAR2);
30
31 PROCEDURE UPDATE_CONC_STATUS_LOG(v_log_id IN NUMBER
32 ,v_query_stmt IN VARCHAR2
33 ,v_start_time IN DATE
34 ,v_end_time IN DATE
35 ,v_status VARCHAR2
36 ,v_message IN VARCHAR2
37 ,x_status OUT NOCOPY VARCHAR2
38 ,x_msg_data OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE DELETE_CONC_STATUS_LOG(v_log_id IN NUMBER);
42
43 END JTM_MESSAGE_LOG_PKG;