create or replace package body pk_srv_mem_audit as

  procedure of_post_tgmodtb (avc_coop varchar2,avc_docno varchar2,avc_code varchar2,avc_tbname varchar2 , avc_clmkeynm varchar2 , avc_clmkeydsc varchar2 ,avc_entryid varchar2,avc_entryip varchar2 ) as
  begin
    insert into sys_logmodtb
    ( coop_id , modtbdoc_no , modtb_code , modtb_tbname , clmkey_name , clmkey_desc ,entry_id , entry_date ,entry_ip)
    values
    ( avc_coop , avc_docno , avc_code , avc_tbname , avc_clmkeynm , avc_clmkeydsc , avc_entryid , sysdate , avc_entryip )
    ;
  end of_post_tgmodtb;

  procedure of_post_tgmodtbdet (avc_coop varchar2,avc_docno varchar2,an_seqno number,avc_clmname varchar2,avc_clmold varchar2,avc_clmnew varchar2,avc_clmtyp varchar2 ) as
  begin
    insert into sys_logmodtbdet
    ( coop_id , modtbdoc_no , seq_no , clm_name , clmold_desc , clmnew_desc , clmtype_desc )
    values
    ( avc_coop , avc_docno , an_seqno , avc_clmname , avc_clmold , avc_clmnew , avc_clmtyp )
    ;
  end of_post_tgmodtbdet;

end pk_srv_mem_audit;