Trigger on pay_element_entries_f
I am using a trigger to insert data from pay_element_entries_f for a specific element_type_id i.e. 298 .....
CREATE OR REPLACE TRIGGER JSAI_COFF_TRIG
after insert on pay_element_entries_f for each row--pay_element_entries_f
declare
pragma autonomous_transaction;
p_nod number;
begin
if :new.element_type_id=298 then
JSAI_COFF_PROC_1(:new.element_entry_id,:new.element_type_id);
commit;
end if;
exception
when others then
dbms_output.put_line(sysdate||': SQLERRM:'||SQLERRM);
end;
This trigger is calling procedure below -
CREATE OR REPLACE PROCEDURE JSAI_COFF_PROC_1(P_ELEMENT_ENTRY_ID IN NUMBER,