create or replace package cdwp_mde is function get_module_icon_name -- determine the correct icon for the type of module -- (menu, library, web, etc) ( p_candidate_flag in varchar2 , p_general_module_type in varchar2 , p_lan_name in varchar2 ) return varchar2 ; function get_mco_icon_name ( p_language_reference in number , p_module_component_type in varchar2 ) return varchar2 ; function exist_brdd ( p_mco_id in number default null ) return boolean ; procedure list_mti_definitions -- list the table usages of a module component ( p_mco_id in number ) ; procedure summary_brdd -- list the triggered business rule design definitions of this module ( p_mco_id in number := null ); procedure summary_items ( p_mco_id in number -- 3.6 added mco_ivid, so also reusable stuff is counted , p_mco_ivid in number , p_parent_ivid in number -- 3.8 issue 194 ) -- list the items of the indicated module component of this module ; -- load g_mti_tbl with all module detail table usages in this module procedure init_mti_table ( p_for_reusable boolean default false ); procedure init_br_table; procedure short_list_mde_definitions ( p_session_id in number ); procedure list_mde_definitions ( p_session_id in number , p_irid in number default null , p_ivid in number default null ); end; -- package specification /