create or replace package odwaxist is

g_exist boolean;

-- this function tells whether or not elements of the specified type exist
-- as details for the p_pac_irid PAC
function exists_detail
( p_pac_irid   in number
, p_pac_ivid   in number   default null
, p_el_type_of in varchar2 default null
, p_el_type_id in varchar2 default null
, p_ref_column in varchar2 default 'PAC_REFERENCE'
, p_extra_where in varchar2 default null  -- AND is added by this function at the front
                                          -- the extra_where may refer to columns in the CI-view
                                          -- for p_el_type_of
) return boolean;


end; -- package body odwaxist
/