create or replace package body wmp_favorites_pages wrapped 0 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 3 b 8106000 1 4 0 1b0 2 :e: 1PACKAGE: 1BODY: 1WMP_FAVORITES_PAGES: 1ACCESS_DENIED: 1PRAGMA: 1EXCEPTION_INIT: 1-: 120001: 1LP_RESET_NAVIGATION_COUNTERS: 1P_IS_PORTLET: 1VARCHAR2: 1P_REFERENCE_PATH: 1L_SESSION: 1100: 1L_DISPLAY_COUNT: 1WMP_API_SESSION: 1=: 1YES: 1IS NOT NULL: 1FAVORITESPORTLETPATH: 1FAVORITESDISPLAYPATH: 1WMP_API_PREFERENCE: 1GET_VALUE: 1P_NAME: 1WMP_PORTAL: 1GET_USER: 1||: 1_: 1DISPLAYCOUNT: 1P_PATH: 1LIMIT: 1SET_VALUE: 1NAVIGATIONSTART: 1P_VALUE: 1NAVIGATIONSTART_DEFAULT: 1REPORTSTART: 1REPORTSTART_DEFAULT: 1DELETE_VALUE: 1FUNCTION: 1LP_GET_PREFERENCE: 1RETURN: 1LP_SET_PREFERENCE: 1REDIRECT: 1P_GROUP_ID: 1P_ACTION: 1P_BACK_URL: 1L_REFERENCE_PATH: 14000: 1L_GROUP_ID: 1L_ACTION: 1L_BACK_URL: 1IS_LOGGED_ON: 1TRUE: 1!=: 1GROUPID: 1ACTION: 1OWA_UTIL: 1REDIRECT_URL: 1WMP_API_UTIL: 1UNESCAPE_URL: 1LP_LABLEPRINT: 1FORTEXT: 1EMBEDTEXT: 1HTP: 1P: 1: 1: 1LP_CHECK_ACCESS: 1P_REQUESTED_URL: 1BOOLEAN: 1L_RESULT: 1CHECK_IF_LOGGED_ON: 1OTHERS: 1WMP_API_ERROR: 1RENDER_ERROR: 140011: 1RAISE: 1PATH: 1P_REPOSITORY_ID: 1NUMBER: 1P_ROLE: 1P_TYPE_NAME: 1P_ID: 1L_PATH: 1WMP_API_PATH: 12: 1CHR: 138: 1nbsp;: 1NAVIGATION_HLINK: 1WMP_API_HLINK: 1WMP_API_FAVORITES: 1GET_OBJECT_NAME: 1LP_RENDER_NAVIGATION_FAVORITES: 1P_PAGE: 1P_REPOSITORY: 1P_ROLE_NAME: 1VARCHAR: 1P_TYPE: 1P_SEARCH: 1P_PREFERENCE_PATH: 1L_USER_ID: 1L_CURSOR_ID: 1L_QUERY_TEXT: 110000: 120: 1L_DISPLAY_LIMIT: 1L_DISPLAY_DESC: 1L_DISPLAY_PATH: 1L_NAVIGATION_START: 1L_REPORT_START: 1L_MINIMIZE_NAVIGATION: 1L_MINIMIZE_REPORT: 1L_REPOSITORY: 1WMP_REPOSITORIES: 1NAME: 1TYPE: 1L_ROLE: 1WMP_ROLES: 1DISPLAY_NAME: 1L_TYPE: 1WMP_TYPES: 1TYPE_NAME: 1L_SEARCH: 1200: 1L_DISPLAY_HELPER: 1EDIT: 1wmp_favorites_pages.show_edit_page: 163: 1p_group_id=: 1NAVIGATION: 1p_is_portlet=: 1p_back_url=: 1ESCAPE_URL: 1p_reference_path=: 1p_preference_path=: 1p_action=: 1wmp_favorites_pages.redirect: 1wmp_favorites_pages.show: 1p_page=: 1PORTLET_HEADING: 1WMP_API_NLS: 1GET_STRING: 110269: 1BR: 1from wmp_navigation_favorites f, wmp_repositories r, wmp_roles ro, wmp_types + 1t where user_id = ::user_id : 1and f.repository_id = r.repository_id : 1and f.role_name = ro.role_name : 1and f.type_name = t.type_name : 1ALLOPTS: 1 and r.repository_id = ': 1' : 1 and ro.role_name = ': 1 and f.type_name = ': 1GET_DISPLAY_OPTIONS: 1 , f.description "10228" : 1FAVORITES: 1wmp_ui.render_content_actions(': 110334: 1', f.repository_id, f.role_name, f.type_name, f.object_id) as "10208": 1wmp_favorites_pages.path(f.repository_id, f.role_name, f.type_name, f.object_+ 1id) as "10280", : 1select : 1wmp_api_ui.image(f.type_name,'S') || ' ' || wmp_api_nls.get_string(t.display_+ 1name) as "10312", : 1wmp_favorites_pages.navigation_hlink(f.repository_id, f.role_name, f.type_nam+ 1e, f.object_id) as "10267", : 1ELSIF: 1UPPER: 1wmp_api_favorites.edit_navigation_favorite_hlink(': 110234: 1', f.favorite_id, wmp_api_favorites.favorites_url,': 1',': 1') || ' ' || : 1wmp_api_favorites.del_navigation_favorite_hlink(': 110227: 1', f.favorite_id, ': 1GET_PROC_PATH: 1' , ': 1WMP_CONSTANTS: 1USER_SCHEMA: 1') as "10208": 1 : 1order by wmp_api_nls.get_string(t.display_name) asc, : 1wmp_api_favorites.get_object_name(f.repository_id, f.role_name, f.type_name, + 1f.object_id) asc: 1ID: 1DBMS_SQL: 1OPEN_CURSOR: 1PARSE: 1NATIVE: 1BIND_VARIABLE: 1::user_id: 1WMP_API_UI: 1RENDER_TABLE: 1P_CURSOR_ID: 1P_SESSION: 1P_DISPLAY_COUNT: 1P_DISPLAY_START: 1P_DISPLAY_LIMIT: 1P_DISPLAY_HELPER: 1P_TRANSLATE_HEADER: 1CLOSE_CURSOR: 1REPORT_HLINK: 1P_REPORT_HELPER: 1P_REPORT_CATEGORY: 1P_REPORT_NAME: 1P_NLS_FLAG: 1L_VERSION: 1WMP_API_CONTEXT: 1REPOSITORY_VERSION: 1Repository: 1IS NULL: 140007: 140000: 1REPORT_VERSION: 140070: 14: 1LP_RENDER_REPORT_FAVORITES: 1REPORT: 110296: 1from wmp_report_favorites f, wmp_reports r, wmp_repositories repos, wmp_roles+ 1 ro, wmp_types t : 1where r.report_id = f.report_id and f.user_id = ::user_id and f.repository_id+ 1 = repos.repository_id : 1and r.type_name = t.type_name : 1 and repos.repository_id = ': 1 and r.type_name = ': 1, wmp_favorites_pages.path(f.repository_id, f.role_name, r.type_name, f.objec+ 1t_id) as "10280" : 1wmp_api_ui.image(r.type_name,'S') || ' ' || wmp_api_nls.get_string(t.display_+ 1name) as "10312", : 1wmp_api_hlink.navigation_hlink(wmp_api_favorites.get_object_name(f.repository+ 1_id, f.role_name, r.type_name, f.object_id), f.repository_id, f.role_name, 4,+ 1 r.type_name, f.object_id) as "10267", : 1wmp_favorites_pages.report_hlink(f.repository_id, f.role_name, r.type_name, f+ 1.object_id, r.report_helper, r.report_category, decode(r.ALT_DISPATCH, null, + 1wmp_api_nls.get_string(r.report_display_name), r.report_display_name), null) + 1as "10295" : 1, wmp_api_favorites.edit_report_favorite_hlink(': 1', favorite_id, wmp_api_favorites.favorites_url, ': 1wmp_api_favorites.del_report_favorite_hlink(': 1', favorite_id, ': 1order by 1 asc, : 12 asc,: 13 asc: 1LP_RENDER_SEARCH: 1L_REPOS_NAME: 130: 1L_ROLE_NAME: 1CUSTOMIZE: 150017: 150000: 11: 1PORTLET_TEXT: 150018: 1CENTEROPEN: 1TABLEOPEN: 1CATTRIBUTES: 1 border="0" cellpadding="0" cellspacing="10" width="60%": 1TABLEROWOPEN: 1TABLEDATA: 110300: 1: 1FONTOPEN: 1class=": 1WMP_API_STYLE: 1GET_CLASS: 1PortletText2: 1": 1WMP_UI: 1RENDER_REPOSITORY_SELECT_LIST: 1P_SELECT_NAME: 1p_repository: 1P_SELECTED_REPOSITORY_ID: 1P_ACCESIBLE: 1P_DEFAULT_ALL: 1FONTCLOSE: 1: 1TABLEROWCLOSE: 110303: 1RENDER_ROLE_SELECT_LIST: 1p_role_name: 1P_SELECTED_ROLE: 110312: 1RENDER_TYPE_SELECT_LIST: 1p_type: 1P_SELECTED_TYPE: 1TABLECLOSE: 1CENTERCLOSE: 1FORMOPEN: 1CURL: 1CMETHOD: 1POST: 1NAME="fav_search_form": 1: 110: 1: 1HTF: 1FORMSUBMIT: 1CNAME: 1p_find_button: 1CVALUE: 110159: 110153: 1FORMCLOSE: 1LP_RESET_SEARCH_OPTIONS: 1SAVE_DISPLAY_OPTIONS: 1SEARCH_REPOSITORY_DEFAULT: 1SEARCH_ROLE_DEFAULT: 1SEARCH_OBJECTTYPE_DEFAULT: 1SEARCH_DEFAULT: 1FAVORITE_CUSTOMIZE: 1P_REQUEST: 1P_DISPLAY_DESC: 1P_DISPLAY_PATH: 1L_PREFERENCE_PATH: 1L_CURRENT_DISPLAYCOUNT: 1L_CURRENT_DISPLAYLIMIT: 1L_CURRENT_REPOSITORY: 1400: 1L_CURRENT_ROLE: 1L_CURRENT_TYPE: 1DISPLAYLIMIT: 1OK: 1DISPLAYDESC: 1DISPLAYPATH: 1REPOSITORY: 1ROLE: 1OBJECTTYPE: 1FAVORITES_URL: 1SHOW: 1P_FIND_BUTTON: 1L_SHOW_FULL_PAGE: 1FALSE: 1L_SHOW_FULL_PAGE_URL: 1L_FAVORITES_CLOSE_URL: 1BACKURL: 1RENDER_PAGE_HEADER: 1P_TITLE: 150009: 1P_STYLE_FILE: 1favorites_style.css: 1P_SHOW_DATE: 1P_SHOW_LOGOUT_HLINK: 1P_SHOW_FAVORITES_CUSTOMIZE: 1P_SHOW_FULL_PAGE: 1P_SHOW_FULL_PAGE_URL: 1P_HELP_HTML: 1fav_main.html: 1NEW_LINE: 1RENDER_PAGE_FOOTER: 1SHOW_CUSTOMIZE: 1SHOW_EDIT_FAVORITE: 1P_FAVORITE_ID: 1L_DESCRIPTION: 1L_FAVORITE_TYPE: 1wmp_favorites_pages.show_edit_favorite: 1p_favorite_id=: 1PORTAL_SCHEMA: 150010: 1GET_FAVORITE_TYPE: 1F: 1DESCRIPTION: 1WMP_NAVIGATION_FAVORITES: 1FAVORITE_ID: 1WMP_REPORT_FAVORITES: 1RENDER_WIZARD_HEADER: 150014: 1wmp_api_favorites.edit_favorite: 1P_APPLY: 1P_OK: 1P_CANCEL: 1FORMHIDDEN: 1p_favorite_id: 1TO_CHAR: 1 WIDTH="90%" BORDER="0" CELLPADDING="0" CELLSPACING="0": 1BLOCKQUOTEOPEN: 1BOLD: 1CTEXT: 150013: 150002: 1border="0" cellpadding="0" cellspacing="0": 110228: 1: 1BLOCKQUOTECLOSE: 1RENDER_WIZARD_FOOTER: 1P_MINIMIZE_NAVIGATION: 1P_MINIMIZE_REPORT: 1APPLY: 1CANCEL: 1LP_SHOW_DISPLAY_OPTIONS: 1L_NAME: 140: 1L_REPORT_TYPE: 1L_TYPE_NAME: 150011: 150001: 1 border="0" cellpadding="0" cellspacing="10" width="50%": 1: 1: 110230: 1: 1