create or replace package body wmp_ui wrapped 0 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 3 b 8106000 1 4 0 149 2 :e: 1PACKAGE: 1BODY: 1WMP_UI: 1LP_GET_SHEET_OPTIONS: 1P_TYPE_NAME: 1VARCHAR2: 1P_REPOSITORY_ID: 1NUMBER: 1P_ROLE: 1P_SESSION: 1P_SHEET: 1P_DISPLAY_LIMIT: 1P_NAVIGATION_START: 1OUT: 1P_IS_PORTLET: 1P_BACK_URL: 1P_REFERENCE_PATH: 1L_DISPLAY_LIMIT: 120: 1L_NAVIGATION_START: 1100: 1L_TYPE_NAME: 1L_TYPE_NAME_TMP: 1L_ROLE: 1=: 1Repository: 10: 1root: 1WMP_API_PREFERENCE: 1GET_VALUE: 1P_NAME: 1WMP_PORTAL: 1GET_USER: 1||: 1_: 1WMP_API_SESSION: 1OBJECTTYPE: 1P_PATH: 1TO_CHAR: 1ROLE: 1IS NULL: 1!=: 1SET_VALUE: 1P_VALUE: 1DISPLAYLIMIT: 1NAVIGATIONSTART_DEFAULT: 1NAVIGATIONSTART: 1LP_RENDER_PATH: 1P_CURSOR_ID: 1L_ETAG: 14000: 1OWA_CACHE: 1GET_ETAG: 1L_LEVEL: 1GET_LEVEL: 1L_ROW_COUNT: 1L_PATH: 1L_PATH_END: 11000: 1L_DESC_TAB: 1DBMS_SQL: 1DESC_TAB: 1L_DESC_REC: 1DESC_REC: 1L_COL_COUNT: 1INTEGER: 1L_COL_VALUE: 1L_DISPLAY_NAME: 1400: 1L_ROLE_NAME: 1L_START: 1WMP_API_CONTEXT: 1ROLE_NAME: 1REPOSITORY_ID: 1>: 1YES: 1*: 1nbsp; >: 1wmp_pages.show_navigation_page: 1p_role=: 1p_repository_id=0: 1p_sheet=2: 1nbsp;: 1DESCRIBE_COLUMNS: 1C: 11: 1LOOP: 1DEFINE_COLUMN: 1EXECUTE_AND_FETCH: 1TRUE: 1-: 1COLUMN_VALUE: 1IS NOT NULL: 1LENGTH: 1HTF: 1NOBR: 1 : 1OTHERS: 1HTP: 1TABLEOPEN: 1CBORDER: 1border=0: 1CATTRIBUTES: 1cellspacing=0 cellpadding=2 width="100%": 1TABLEDATA: 1CALIGN: 1LEFT: 1CLASS=": 1WMP_API_STYLE: 1GET_CLASS: 1PortletSubheaderColor: 1": 1CVALUE: 1FONTOPEN: 1PortletSubheaderText: 1WMP_API_NLS: 1GET_STRING: 110280: 1::: 1FONTCLOSE: 1PortletHeading2: 1 CLASS=": 1DISPLAY_NAME: 1WMP_ROLES: 1RIGHT: 1TABLECLOSE: 1WMP_API_ERROR: 1LOG_ERROR: 1wmp_ui.lp_render_path: 1RENDER_ERROR: 140026: 1RAISE: 1LP_RENDER_TITLE: 1L_NAME: 1100003: 1100000: 1cellspacing=0 cellpadding=2 width="100%": 1CNOWRAP: 1NOWRAP: 1WMP_API_UI: 1ITALIC: 1WMP_API_HLINK: 1CONTEXT_HELP_HLINK: 1nav_main.html: 1wmp_ui.lp_render_title: 1LP_RENDER_DESCRIPTION: 1L_TEXT: 132767: 1100002: 1PortletText2: 1wmp_ui.lp_render_description: 1LP_RENDER_TEXT: 1P_TEXT: 1PortletText1: 1" : 1RENDER_NEW_LINE: 1P_NUMBER: 1L: 1BR: 1RENDER_CONTENTS_TABLE: 1P_ID: 1P_ACTION: 1L_CURSOR_ID: 1L_DISPLAY_COUNT: 1L_DISPLAY_DESC: 1L_DISPLAY_PATH: 1L_REPORT_START: 1L_MINIMIZE_NAVIGATION: 1L_MINIMIZE_REPORT: 1L_REPOSITORY: 1WMP_REPOSITORIES: 1NAME: 1TYPE: 1L_TYPE: 1WMP_TYPES: 1TYPE_NAME: 1L_SEARCH: 1200: 1L_PREFERENCE_PATH: 1L_DISPLAY_HELPER: 1NAVIGATIONPORTLETPATH: 1p_type_name=: 1p_id=: 1p_sheet=: 1p_action=: 1NAVIGATIONDISPLAYPATH: 1p_repository_id=: 1GET_DISPLAY_OPTIONS: 1LIMIT: 1WMP_API_QUERY: 1CONTENT_OBJECTS: 1RENDER_TABLE: 1P_HIDDEN_COLUMN_CHAR: 1^: 1P_HELP_FILE: 1nav_cnts.html: 1P_DISPLAY_COUNT: 1P_DISPLAY_START: 1P_DISPLAY_HELPER: 1P_TRANSLATE_HEADER: 1CLOSE_CURSOR: 1100001: 1RENDER_RELATED_OBJECTS_TABLE: 1RELATED_OBJECTS: 1nav_rltd.html: 1100005: 1RENDER_PATH: 1PATH: 1RENDER_PROPERTIES_ROW: 1PROPERTIES: 1RENDER_ROW: 1nav_prpts.html: 1100004: 1RENDER_EXTENDED_PROPERTIES_ROW: 1EXTENDED_PROPERTIES: 1RENDER_EXTENDED_PROPERTIES: 1100008: 1RENDER_TITLE: 1RENDER_DESCRIPTION: 1DESCRIPTION: 1RENDER_REPORTS_LIST: 1REPORTS_LIST: 1nav_rpts.html: 1100006: 1RENDER_LINKS_LIST: 1LINKS_LIST: 1nav_lnks.html: 1100007: 1RENDER_TYPE_SELECT_LIST: 1P_SELECT_NAME: 1P_SELECTED_TYPE: 1P_DEFAULT_ALL: 1BOOLEAN: 1FALSE: 1FORMSELECTOPEN: 1CNAME: 1NSIZE: 1ALLOPTS: 1P: 1