REM *************************************************************************** REM Hand-carved package body for BATCHLINE created on 23-FEB-99 REM *************************************************************************** CREATE OR REPLACE PACKAGE BODY cihbli IS -- Generic post-process routines PROCEDURE check_delete(id number); sac_type constant varchar2(6) := 'BLI'; pac_type constant varchar2(6) := 'BAT'; --======================== PRE-PROCESS (INS,UPD) ============================-- PROCEDURE pre_process(operation varchar2,id number, pl in out NOCOPY ciobatchline.data) IS BEGIN -- Access rights for batchline derive from the batch -- Access rights checking performed by triggers in config 4.0.9 -- ciiacc.check_access_rights(pl.v.batch_reference,pac_type, -- 'UPD','SHR'); -- Initialize unassigned properties with default values on INSERT if operation = 'INS' then pl.v.element_type_name := sac_type; pl.i.element_type_name := true; end if; END; --======================== PRE-PROCESS (DEL,SEL) ============================-- PROCEDURE pre_process(operation varchar2,id number) IS BEGIN -- Access rights for batchline derive from the batch -- Access rights checking performed by triggers in config 4.0.9 -- ciiacc.check_access_rights(id,sac_type,operation,'SAC'); -- if operation is 'DELETE', make sure no non-cascading references exist if operation = 'DEL' then check_delete(id); end if; END; --===================== POST-PROCESS (INS,UPD,SEL) ==========================-- PROCEDURE post_process(operation varchar2,id number, pl ciobatchline.data) IS BEGIN null; END; --========================= POST PROCESS (DEL) ==============================-- PROCEDURE post_process(operation varchar2,id number) IS BEGIN null; END; --============================= CHECK DELETE ================================-- PROCEDURE check_delete(id number) IS dummy number; error_count number := 0; BEGIN null; END; --================================== END ====================================-- -- -- Package instantiation block -- BEGIN is_installed := true; END; /