PACKAGE: APPS.CZ_DEBUG_PUB

Source

1 PACKAGE CZ_DEBUG_PUB AUTHID CURRENT_USER AS
2 /*	$Header: czdbpubs.pls 115.4 2002/11/27 16:58:00 askhacha ship $		*/
3 
4 ----------------------declarations
5 TYPE  t_messageRecord IS RECORD (
6 				msg_text	cz_db_logs.message%TYPE,
7 				called_proc cz_db_logs.caller%TYPE,
8 				sql_code	cz_db_logs.statuscode%TYPE
9    					  );
10 TYPE msg_text_list IS TABLE OF t_messageRecord INDEX BY BINARY_INTEGER;
11 type VARCHAR_TBL_TYPE is table of VARCHAR2(2000);
12 
13 --------------------
14 ----procedure that populates debug messages
15 PROCEDURE populate_debug_message(p_msg     VARCHAR2,
16 				         p_caller  VARCHAR2,
17 				         p_code    NUMBER,
18 					   v_msg_tbl IN OUT NOCOPY msg_text_list);
19 
20 -------------------
21 -----procedure that logs debug messages to cz_db_logs
22 PROCEDURE insert_into_logs(p_msg_tbl IN OUT NOCOPY msg_text_list);
23 
24 ----procedure that decodes the messages from batch validate
25 PROCEDURE get_batch_validate_message (msg_status IN  NUMBER,
26 						  msg_text   OUT NOCOPY VARCHAR2);
27 
28 ------------------------
29 
30 END CZ_DEBUG_PUB;