create or replace package odwapriv
is

type t_string_table is
table of varchar2(200)
index by binary_integer
;

g_empty_table t_string_table;

-- public procedures and functions
--

-- this function returns the string that is derived from the input string
-- by taking uppercase, translating spaces to underscores and limiting the length to 30 characters
function proper
( p_string in varchar2
) return varchar2
;
function get_versioned_repository
return boolean
;
-- this function returns the irid of a Role given its Role Name
function get_role_irid
( p_role_name in varchar2
) return number
;
-- gets owner of any object
function get_governor
( object_irid in number
) return varchar2
;

-- this function returns the creator of a Role given its Role Name
function get_role_creator
( p_role_name in varchar2
) return varchar2
;
function get_role_owner
( p_role_name in varchar2
) return varchar2
;
-- this function returns the type - R(ole) or U(ser) of a grantee
function get_grantee_type
( p_grantee in varchar2
) return varchar2
;
function get_object_type
( p_irid in number
) return varchar2
;

function get_object_label
( p_irid in number
, p_include_gif in boolean default true
) return varchar2
;
procedure navigatorTree
( p_session_id    in   number
);

procedure paletteFrame
( p_session_id    in   number
, p_initial_context in varchar2 default null
);


procedure dataXchange
( p_session_id    in   number
);

procedure topSide 
( p_session_id    in   number
)
;
procedure rightSide
( p_session_id    in   number
, p_initial_context in varchar2 default null
);

procedure inflate_Node
( p_node_index             in number
, p_node_level             in number  -- level of node-to-be-inflated (all its children will have p_node_level + 1 or higher)
, p_num_of_nodes           in number
, p_node_value             in varchar2 default null
, p_node_type              in varchar2 default null
, p_entry_point            in number   default null
, p_session_id             in number
, p_root_value             in varchar2
, p_root_classification    in varchar2 default null
);

procedure list_users_and_roles
( p_session_id    in   number
, p_initial_context in varchar2 default null
);

end; -- odwapriv
/