42 APEX_UTIL

The APEX_UTIL package provides utilities you can use when programming in the Oracle Application Express environment. You can use the APEX_UTIL package to get and set session state, get files, check authorizations for users, reset different states for users, get and purge cache information and also to get and set preferences for users.

• CACHE_GET_DATE_OF_PAGE_CACHE Function
  
• CACHE_GET_DATE_OF_REGION_CACHE Function
  
• CACHE_PURGE_BY_APPLICATION Procedure
  
• CACHE_PURGE_BY_PAGE Procedure
  
• CACHE_PURGE_STALE Procedure
  
• CHANGE_CURRENT_USER_PW Procedure
  
• CHANGE_PASSWORD_ON_FIRST_USE Function
  
• CLOSE_OPEN_DB_LINKS Procedure
  
• CLEAR_APP_CACHE Procedure
  
• CLEAR_PAGE_CACHE Procedure
  
• CLEAR_USER_CACHE Procedure
  
• COUNT_CLICK Procedure
  
• CREATE_USER Procedure
  
• CREATE_USER_GROUP Procedure
  
• CURRENT_USER_IN_GROUP Function
  
• CUSTOM_CALENDAR Procedure
  
• DELETE_USER_GROUP Procedure Signature 1
  
• DELETE_USER_GROUP Procedure Signature 2
  
• DOWNLOAD_PRINT_DOCUMENT Procedure Signature 1
  
• DOWNLOAD_PRINT_DOCUMENT Procedure Signature 2
  
• DOWNLOAD_PRINT_DOCUMENT Procedure Signature 3
  
• DOWNLOAD_PRINT_DOCUMENT Procedure Signature 4
  
• EDIT_USER Procedure
  
• END_USER_ACCOUNT_DAYS_LEFT Function
  
• EXPIRE_END_USER_ACCOUNT Procedure
  
• EXPIRE_WORKSPACE_ACCOUNT Procedure
  
• EXPORT_USERS Procedure
  
• FETCH_APP_ITEM Function
  
• FETCH_USER Procedure Signature 1
  
• FETCH_USER Procedure Signature 2
  
• FETCH_USER Procedure Signature 3
  
• FIND_SECURITY_GROUP_ID Function
  
• FIND_WORKSPACE Function
  
• GET_ACCOUNT_LOCKED_STATUS Function
  
• GET_APPLICATION_STATUS Function
  
• GET_ATTRIBUTE Function
  
• GET_AUTHENTICATION_RESULT Function
  
• GET_BLOB_FILE_SRC Function
  
• GET_BUILD_OPTION_STATUS Function Signature 1
  
• GET_BUILD_OPTION_STATUS Function Signature 2
  
• GET_CURRENT_USER_ID Function
  
• GET_DEFAULT_SCHEMA Function
  
• GET_EDITION Function
  
• GET_EMAIL Function
  
• GET_FEEDBACK_FOLLOW_UP Function
  
• GET_FILE Procedure
  
• GET_FILE_ID Function
  
• GET_FIRST_NAME Function
  
• GET_GROUPS_USER_BELONGS_TO Function
  
• GET_GROUP_ID Function
  
• GET_GROUP_NAME Function
  
• GET_HASH Function
  
• GET_HIGH_CONTRAST_MODE_TOGGLE Function
  
• GET_LAST_NAME Function
  
• GET_NUMERIC_SESSION_STATE Function
  
• GET_PREFERENCE Function
  
• GET_GLOBAL_NOTIFICATION Function
  
• GET_PRINT_DOCUMENT Function Signature 1
  
• GET_PRINT_DOCUMENT Function Signature 2
  
• GET_PRINT_DOCUMENT Function Signature 3
  
• GET_PRINT_DOCUMENT Function Signature 4
  
• GET_SCREEN_READER_MODE_TOGGLE Function
  
• GET_SESSION_LANG Function
  
• GET_SESSION_STATE Function
  
• GET_SESSION_TERRITORY Function
  
• GET_SESSION_TIME_ZONE Function
  
• GET_SINCE Function
  
• GET_SUPPORTING_OBJECT_SCRIPT Function
  
• GET_SUPPORTING_OBJECT_SCRIPT Procedure
  
• GET_USER_ID Function
  
• GET_USER_ROLES Function
  
• GET_USERNAME Function
  
• HOST_URL Function
  
• HTML_PCT_GRAPH_MASK Function
  
• INCREMENT_CALENDAR Procedure
  
• IR_CLEAR Procedure [DEPRECATED]
  
• IR_DELETE_REPORT Procedure [DEPRECATED]
  
• IR_DELETE_SUBSCRIPTION Procedure [DEPRECATED]
  
• IR_FILTER Procedure [DEPRECATED]
  
• IR_RESET Procedure [DEPRECATED]
  
• IS_HIGH_CONTRAST_SESSION Function
  
• IS_HIGH_CONTRAST_SESSION_YN Function
  
• IS_LOGIN_PASSWORD_VALID Function
  
• IS_SCREEN_READER_SESSION Function
  
• IS_SCREEN_READER_SESSION_YN Function
  
• IS_USERNAME_UNIQUE Function
  
• KEYVAL_NUM Function
  
• KEYVAL_VC2 Function
  
• LOCK_ACCOUNT Procedure
  
• PASSWORD_FIRST_USE_OCCURRED Function
  
• PREPARE_URL Function
  
• PUBLIC_CHECK_AUTHORIZATION Function [DEPRECATED]
  
• PURGE_REGIONS_BY_APP Procedure
  
• PURGE_REGIONS_BY_NAME Procedure
  
• PURGE_REGIONS_BY_PAGE Procedure
  
• REDIRECT_URL Procedure
  
• REMOVE_PREFERENCE Procedure
  
• REMOVE_SORT_PREFERENCES Procedure
  
• REMOVE_USER Procedure Signature 1
  
• REMOVE_USER Procedure Signature 2
  
• RESET_AUTHORIZATIONS Procedure [DEPRECATED]
  
• RESET_PASSWORD Procedure
  
• RESET_PW Procedure
  
• SAVEKEY_NUM Function
  
• SAVEKEY_VC2 Function
  
• SET_APP_BUILD_STATUS Procedure
  
• SET_APPLICATION_STATUS Procedure
  
• SET_ATTRIBUTE Procedure
  
• SET_AUTHENTICATION_RESULT Procedure
  
• SET_BUILD_OPTION_STATUS Procedure
  
• SET_CURRENT_THEME_STYLE Procedure [DEPRECATED]
  
• SET_CUSTOM_AUTH_STATUS Procedure
  
• SET_EDITION Procedure
  
• SET_EMAIL Procedure
  
• SET_FIRST_NAME Procedure
  
• SET_GLOBAL_NOTIFICATION Procedure
  
• SET_GROUP_GROUP_GRANTS Procedure
  
• SET_GROUP_USER_GRANTS Procedure
  
• SET_LAST_NAME Procedure
  
• SET_PARSING_SCHEMA_FOR _REQUEST Procedure
  
• SET_PREFERENCE Procedure
  
• SET_SECURITY_GROUP_ID Procedure
  
• SET_SESSION_HIGH_CONTRAST_OFF Procedure
  
• SET_SESSION_HIGH_CONTRAST_ON Procedure
  
• SET_SESSION_LANG Procedure
  
• SET_SESSION_LIFETIME_SECONDS Procedure
  
• SET_SESSION_MAX_IDLE_SECONDS Procedure
  
• SET_SESSION_SCREEN_READER_OFF Procedure
  
• SET_SESSION_SCREEN_READER_ON Procedure
  
• SET_SESSION_STATE Procedure
  
• SET_SESSION_TERRITORY Procedure
  
• SET_SESSION_TIME_ZONE Procedure
  
• SET_USERNAME Procedure
  
• SET_WORKSPACE Procedure
  
• SHOW_HIGH_CONTRAST_MODE_TOGGLE Procedure
  
• SHOW_SCREEN_READER_MODE_TOGGLE Procedure
  
• STRING_TO_TABLE Function [DEPRECATED]
  
• STRONG_PASSWORD_CHECK Procedure
  
• STRONG_PASSWORD_VALIDATION Function
  
• SUBMIT_FEEDBACK Procedure
  
• SUBMIT_FEEDBACK_FOLLOWUP Procedure
  
• TABLE_TO_STRING Function [DEPRECATED]
  
• UNEXPIRE_END_USER_ACCOUNT Procedure
  
• UNEXPIRE_WORKSPACE_ACCOUNT Procedure
  
• UNLOCK_ACCOUNT Procedure
  
• URL_ENCODE Function
  
• WORKSPACE_ACCOUNT_DAYS_LEFT Function