create or replace package odwactxt is function get_session_id return number ; function get_workarea_irid return number ; function get_folder_irid return number ; function get_folder_ivid return number ; function get_cfg_id return number ; function get_pac_irid return number ; function get_pac_ivid return number ; function get_pac_type_id return number ; -- returns string indicating the current context. Something like: -- or function get_context_label ( p_include_icons in boolean default true , p_include_links in boolean default false -- links to Launchpad for context components , p_workarea_irid in number default odwactxt.get_workarea_irid , p_folder_irid in number default odwactxt.get_folder_irid , p_folder_ivid in number default odwactxt.get_folder_ivid , p_cfg_id in number default odwactxt.get_cfg_id , p_include_folder_versions in boolean default true , p_include_folder in boolean default true , p_include_workarea in boolean default true , p_include_config in boolean default true ) return varchar2 ; -- returns the context type; values are: -- FOL, WA, CFG, FOL_IN_WA, FOL_IN_CFG, function get_conxtext_type return varchar2 ; procedure set_static ; procedure reset_static ; procedure set_one_file ; procedure set_multiple_file ; function get_static return boolean ; function get_one_file return varchar2 ; procedure update_context ( p_session_id in number default odwactxt.get_session_id -- when p_session_id = -1, a new session is created , p_workarea_irid in number default -1 -- if p_workarea_irid <> -1 AND <> current context workarea irid, a new session is opened , p_pac_irid in number default -1 -- the irid of the current PAC context , p_pac_ivid in number default -1 -- the ivid of the current PAC context , p_pac_type_id in number default -1 -- the element_type_id of the current PAC context (corresponds with RM_ELEMENT_TYPES.id) , p_folder_irid in number default -1 -- the irid of the current Folder context , p_folder_ivid in number default -1 -- the ivid of the current Folder context , p_cfg_irid in number default -1 -- the irid of the current Configuration context , p_cfg_ivid in number default -1 -- the ivid of the current Configuration context , p_new_request in boolean default true -- if true, the number_of_requests is increased by one , p_package_name in varchar2 default -1 -- the name of the calling package , p_procedure_name in varchar2 default -1 -- the name of the calling procedure ); function check_in_wa ( p_irid in number default null , p_ivid in number , p_wa_irid in number ) return boolean ; function check_in_cfg ( p_irid in number default null , p_ivid in number , p_cfg_id in number ) return boolean ; end; -- odwactxt /