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 |