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;
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);
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:
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,