create or replace package pkg_nkw_usr
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_session is record(username	    dba_users.username%TYPE,
			      session_flag  varchar2(1));
   type tab_session is table of rec_session index by binary_integer;
   gt_session tab_session;
   gr_prefs   nkw_usr_prefs%ROWTYPE;
   ------------------------------------------------------------------
   -- CREATE_USER
   ------------------------------------------------------------------
   procedure create_user(fv_username in dba_users.username%TYPE,
			 fv_password in varchar2);
   ------------------------------------------------------------------
   -- DROP_USER
   ------------------------------------------------------------------
   procedure drop_user(fv_username in dba_users.username%TYPE);
   ------------------------------------------------------------------
   -- GRANT_SESSION
   ------------------------------------------------------------------
   procedure grant_session(fv_username in dba_users.username%TYPE);
   ------------------------------------------------------------------
   -- REVOKE_SESSION
   ------------------------------------------------------------------
   procedure revoke_session(fv_username in dba_users.username%TYPE);
   ------------------------------------------------------------------
   -- SET_SESSION
   ------------------------------------------------------------------
   procedure set_session(ft_session in gt_session%TYPE);
   ------------------------------------------------------------------
   -- SET_PASSWORD
   ------------------------------------------------------------------
   procedure set_password(fv_username  in dba_users.username%TYPE,
			  fv_password  in varchar2);
   ------------------------------------------------------------------
   procedure set_password(fv_password  in varchar2);
   ------------------------------------------------------------------
   -- RESET_PASSWORD
   ------------------------------------------------------------------
   procedure reset_password(fv_username in dba_users.username%TYPE);
   ------------------------------------------------------------------
   -- SET_PREFERENCES
   ------------------------------------------------------------------
   procedure set_preferences(fr_prefs in gr_prefs%TYPE);
   ------------------------------------------------------------------
   -- GET_PREFERENCES
   ------------------------------------------------------------------
   function get_preferences return gr_prefs%TYPE;
end pkg_nkw_usr;