APPS.CZ_DEBUG_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 27

PROCEDURE insert_into_logs(p_msg_tbl IN OUT NOCOPY msg_text_list)
AS
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 37

	SELECT cz_xfr_run_infos_s.nextval INTO l_run_id FROM dual;

Line: 45

			INSERT INTO cz_db_logs(logtime,
						     loguser,
						     caller,
						     statuscode,
						     message,
						     creation_date,
						     run_id)
					 values (sysdate,
						   l_loguser,
						   p_msg_tbl(i).called_proc,
						   p_msg_tbl(i).sql_code,
						   SUBSTR(p_msg_tbl(i).msg_text,1,2000),
						   sysdate,
						   l_run_id);

Line: 61

	p_msg_tbl.DELETE;

Line: 65

   v_msg_tbl.DELETE;

Line: 68

END insert_into_logs;