output from query script:
send_email_yvs_kj_
create or replace procedure send_email (in node character(1), in severity integer, in subject character(1), in email character(1), in summary character(1), in hostname character(1)) executable '$OMNIHOME/utils/nco_mail' host hostname user 0 group 0 arguments '\''+node+'\'', severity,'\''+subject+'\'','\''+email+'\'','\''+summary+'\'';_yvs_kj_
jinsert_yvs_kj_
create or replace procedure jinsert( in serial int,  in uid int,  in tstamp utc,  in msg char(4080) )begin---- Procedure inserts a record into the alerts.journal table. Automations that -- require journal entries should execute this procedure.---- Usage:  --  call procedure jinsert( old.Serial, %user.user_id, getdate, 'This is my journal entry');--        insert into alerts.journal values (		journal_keyfield( to_int( serial ), to_int( uid ), tstamp ), -- KeyField                serial,                         -- Serial                uid,                            -- UID                tstamp,                         -- Chrono                split_multibyte(msg, 1, 255),   -- Text1                split_multibyte(msg, 2, 255),   -- Text2                split_multibyte(msg, 3, 255),   -- Text3                split_multibyte(msg, 4, 255),   -- Text4                split_multibyte(msg, 5, 255),   -- Text5                split_multibyte(msg, 6, 255),   -- Text6                split_multibyte(msg, 7, 255),   -- Text7                split_multibyte(msg, 8, 255),   -- Text8                 split_multibyte(msg, 9, 255),   -- Text9                 split_multibyte(msg, 10, 255),  -- Text10                split_multibyte(msg, 11, 255),  -- Text11                split_multibyte(msg, 12, 255),  -- Text12                split_multibyte(msg, 13, 255),  -- Text13                split_multibyte(msg, 14, 255),  -- Text14                split_multibyte(msg, 15, 255),  -- Text15                split_multibyte(msg, 16, 255)   -- Text16	);end_yvs_kj_
convert_severity_yvs_kj_
create or replace procedure convert_severity 
(IN omnibus_severity INTEGER, OUT tec_severity INTEGER) 
BEGIN
	if (omnibus_severity = 5)
	then
		set tec_severity = 50
	elseif (omnibus_severity = 4)
	then
		set tec_severity = 40	
	elseif (omnibus_severity = 3)
	then
		set tec_severity = 40	
	elseif (omnibus_severity = 2)
	then
		set tec_severity = 30	
	elseif (omnibus_severity = 1)
	then
		set tec_severity = 10	
	else
		set tec_severity = 10	
	end if;
END_yvs_kj_