create or replace package pkg_nkw_obj
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_data is record(table_name	   varchar2(30),
			   column_id	   number(4),
			   column_name	   varchar2(30),
			   data_type	   varchar2(10),
			   data_length	   number(6),
			   date_value	   date,
			   number_value    number,
			   varchar2_value  pkg_nkw_env.gv_char%TYPE);
   type tab_data is table of rec_data index by binary_integer;
   gt_data  tab_data;
   ------------------------------------------------------------------
   -- GET_SEQUENCE
   ------------------------------------------------------------------
   function get_sequence(fv_name in varchar2)
      return integer;
   ------------------------------------------------------------------
   -- GET_COLUMNS
   ------------------------------------------------------------------
   function get_columns(fv_table in varchar2)
      return gt_data%TYPE;
   ------------------------------------------------------------------
   -- INDEX_OF
   ------------------------------------------------------------------
   function index_of(ft_table  in gt_data%TYPE,
		     fv_column in varchar2)
      return binary_integer;
   ------------------------------------------------------------------
   -- CONTENTS_OF
   ------------------------------------------------------------------
   procedure contents_of(ft_data in  gt_data%TYPE,
			 fv_data out varchar2);
end pkg_nkw_obj;