create or replace package pkg_nkw_srw timestamp '2006-07-07:10:10:10' is ------------------------------------------------------------------ -- 2006 DataPRO Developers - m@urelio ------------------------------------------------------------------ -- Version: 2.0.2 ------------------------------------------------------------------ -- Collections, Records, Variables, Constants, Exceptions, Cursors ------------------------------------------------------------------ type rec_wcies is record(srw_name nkw_srw.srw_name%TYPE, srw_view nkw_srw.srw_view%TYPE, srw_item nkw_srwcies.srw_item%TYPE, srw_column nkw_srwcies.srw_column%TYPE, srw_datatype nkw_srwcies.srw_datatype%TYPE, srw_label nkw_srwcies.srw_label%TYPE); type tab_wcies is table of rec_wcies index by binary_integer; gt_wcies tab_wcies; ------------------------------------------------------------------ -- HAS_WCIES ------------------------------------------------------------------ function has_wcies(fv_name in nkw_frmsrw.frm_name%TYPE) return boolean; ------------------------------------------------------------------ -- GET_WCIES ------------------------------------------------------------------ function get_wcies(fv_name in nkw_srw.srw_name%TYPE) return gt_wcies%TYPE; end pkg_nkw_srw; / show errors