CODE EXAMPLE FOR SQL

save_details_inrichting

api_inrichting_pck.save_details_inrichting
  (i_dygp_naam           => :P5005_DYGP_NAAM
  ,i_id                  => :P5005_ID
  ,i_irtg_id             => :P5005_IRTG_ID
  ,i_parent_id           => :P5005_PARENT_ID
  ,i_actie_ind           => case when :P5005_ID is null then 'I' else 'U' end
  ,i_datum_registratie   => :P5005_DATUM_REGISTRATIE
  ,i_datum_oprichting    => :P5005_DATUM_OPRICHTING
  ,i_lcte_id_new         => case when nvl(:P5005_IGDR_LCTE_ID,-1) = nvl(:P5005_IGDR_LCTE_ID_NEW,-1) then null else :P5005_IGDR_LCTE_ID_NEW end -- drijver locatie omhangen?
  ,i_lcte_id_vestiging   => :P5005_LCTE_ID_VESTIGING
  ,i_tele_code_vestiging => :P5005_TELE_CODE_VESTIGING
  ,i_locatieomschrijving => :P5005_LOCATIEOMSCHRIJVING
  ,i_roll_id_contact2    => :P5005_ROLL_ID_CONTACT2
  ,i_prsn_id_contact2    => :P5005_PRSN_ID_CONTACT2
  ,i_terl_code_contact2  => :P5005_TERL_CODE_CONTACT2
  ,i_tekk_code           => :P5005_CATEGORIE
  ,i_ind_veeteelt        => :P5005_IND_VEETEELT
  ,i_filename            => :P5005_FILENAME
  );

exception
  when others then
    logger.log_error('Fout bij opslaan details');
    raise;