begin
  :new.pl_id := ppe_seq_pl_id.nextval;
end;
/

INSERT INTO TableRows (R_ID, Field1, Field2, Field3, Field4, Field5, Field6, Field7, Total1, Total2, Field8)
SELECT R_ID, FIEDL1, scen, dat, dat, '-','','Actual',case when 0.8*CALC_TOTAL_ACC(idinput,'Budget',field1)/CALC_MONTH_LENGTH(idinput) < 0 then 
		0 else 0.8*CALC_TOTAL_ACC(idinput,'Budget',field1)/CALC_MONTH_LENGTH(idinput) end,
		case when 0.8*CALC_TOTAL_ACC(idinput,'Budget',field1)/CALC_MONTH_LENGTH(idinput) < 0 
		then 0.8*CALC_TOTAL_ACC(idinput,'Budget',field1)/CALC_MONTH_LENGTH(idinput) else 0 end
		, descr FROM TableRows WHERE R_ID=idinput GROUP BY Field1, R_ID;

CREATE OR REPLACE TRIGGER TRIGGERNAME BEFORE INSERT ON TableRows REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW
begin
  :new.id := seq_id.nextval;
end;
/

CREATE SEQUENCE SEQ_ID
  START WITH 2155430
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 20
  ORDER;

CREATE OR REPLACE FUNCTION CALC_TOTAL_ACC(
    idinput IN       VARCHAR2,
    param1 IN VARCHAR2,
    param2 IN VARCHAR2    
) RETURN number
IS

tot number;

BEGIN

  SELECT  nvl(SUM(total1),0) - nvl(SUM(total2),0) into tot FROM TableRows WHERE r_id= idinput and lower(field2)=lower(param1)
  and lower(field1)=lower(param2);
  return tot;

end;
/