Create or Replace Trigger "usremhr" .trg_sq_rule_insert before insert on sq_rule_base for each row
DECLARE TEMP_RULE_ID VARCHAR2 (10); Temp_rul_theme_id varchar2 (10); Begin
begin temp_rule_id: =: new.rule_id; temp_rul_theme_id: =: new.rul_theme_id; insert into sq_result_detail (result_id, result_rul_id, result_thedet_id, result_field_id) select to_char (sysdate, 'yy') || to_char (sysdate, 'mm') || trim (to_char (SEQ_SQ_RULE.nextval, '000000')), temp_rule_id, the_id, sq_id from sq_theme_detail, sq_table where the_tablename = sq_tablename and sq_fieldyon = 'Y' and theme_id = temp_rul_theme_id; end;
End TRG_SQ_Rule_Insert;
