ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Undocumented in the Types and Packages
documentation this package contains supporting utilities for Application Express (APEX)
AUTHID
DEFINER
Constants
Name
Data Type
Value
c_must_not_be_public_user
VARCHAR2(30)
'MUST_NOT_BE_PUBLIC_USER'
Dependencies
APEX_UTIL
WWV_FLOW_DEBUG_API
WWV_FLOW_SECURITY
DBA_USERS
WWV_FLOW_DML
WWV_FLOW_SESSION
DBMS_LOB
WWV_FLOW_ERROR
WWV_FLOW_SESSIONS$
DBMS_OUTPUT
WWV_FLOW_ESCAPE
WWV_FLOW_SESSION_STATE
DBMS_RANDOM
WWV_FLOW_F4000_PLUGINS
WWV_FLOW_STEPS
DBMS_STANDARD
WWV_FLOW_F4000_UTIL
WWV_FLOW_STEP_ITEMS
F
WWV_FLOW_FEEDBACK
WWV_FLOW_STEP_PROCESSING
HTP
WWV_FLOW_FEEDBACK_FOLLOWUP
WWV_FLOW_TEAM_FILE
NV
WWV_FLOW_FILE_MGR
WWV_FLOW_TEMPLATES_UTIL
OWA_UTIL
WWV_FLOW_FILE_OBJECTS$
WWV_FLOW_USER_API
PLITBLM
WWV_FLOW_FLASH_CHART5
WWV_FLOW_UTILITIES
UTL_HTTP
WWV_FLOW_FND_USER_API
WWV_FLOW_WORKSHEET
V
WWV_FLOW_GEN_API2
WWV_FLOW_WORKSHEET_API
V_$DBLINK
WWV_FLOW_GLOBAL
WWV_FLOW_WORKSHEET_DIALOGUE
WWV_DBMS_SQL
WWV_FLOW_GRID_LAYOUT_DEV
WWV_FLOW_WORKSHEET_FORM
WWV_FLOW
WWV_FLOW_ID
WWV_FLOW_WORKSHEET_STANDARD
WWV_FLOWS
WWV_FLOW_LANG
WWV_FLOW_WORKSHEET_UTIL
WWV_FLOW_4000_UI
WWV_FLOW_LANGUAGES
WWV_FLOW_WS_ATTACHMENT
WWV_FLOW_AJAX
WWV_FLOW_LANGUAGE_MAP
WWV_FLOW_WS_DIALOG
WWV_FLOW_API
WWV_FLOW_NATIVE_ITEM
WWV_FLOW_WS_FLASH_CHART
WWV_FLOW_AUTHORIZATION
WWV_FLOW_PAGE
WWV_FLOW_WS_FORM
WWV_FLOW_CGI
WWV_FLOW_PATCHES
WWV_FLOW_WS_STICKIES
WWV_FLOW_COMPANY_SCHEMAS
WWV_FLOW_PKG_APP_INSTALL
WWV_FLOW_WS_UI
WWV_FLOW_CSS
WWV_FLOW_PLUGIN_DEV
WWV_FLOW_WS_WEBPAGE
WWV_FLOW_DATA
WWV_FLOW_PREFERENCES
WWV_RENDER_REPORT3
WWV_FLOW_DATA_UPLOAD
WWV_FLOW_PROCESS
Z
WWV_FLOW_DEBUG
WWV_FLOW_PROCESS_NATIVE
Documented
No
First Available
12.1
Security Model
Owned by the APEX owner with EXECUTE granted to
PUBLIC
Returns the date and time the specified application page was cached either for the user issuing the call or for all users if the page was not set to be cached by user
htmldb_util.cache_get_date_of_page_cache(
p_application IN NUMBER,
p_page IN NUMBER)
RETURN DATE;
Purges all cached pages and regions for a given application and page.
If p_user_name is supplied, only that user's cached pages and regions will be purged
htmldb_util.cache_purge_by_page(
p_application IN NUMBER,
p_page IN NUMBER,
p_user_name IN VARCHAR2 DEFAULT NULL);
Edit user information in wwv_flow_fnd_user, wwv_flow_fnd_group_users and wwv_flow_developers tables
htmldb_util.edit_user(
p_user_id IN NUMBER,
p_user_name IN VARCHAR2,
p_first_name IN VARCHAR2 DEFAULT NULL,
p_last_name IN VARCHAR2 DEFAULT NULL,
p_web_password IN VARCHAR2 DEFAULT NULL,
p_new_password IN VARCHAR2 DEFAULT NULL,
p_email_address IN VARCHAR2 DEFAULT NULL,
p_start_date IN VARCHAR2 DEFAULT NULL,
p_end_date IN VARCHAR2 DEFAULT NULL,
p_employee_id IN VARCHAR2 DEFAULT NULL,
p_allow_access_to_schemas IN VARCHAR2 DEFAULT NULL,
p_person_type IN VARCHAR2 DEFAULT NULL,
p_default_schema IN VARCHAR2 DEFAULT NULL,
p_default_date_format IN VARCHAR2 DEFAULT NULL,
p_group_ids IN VARCHAR2 DEFAULT NULL,
p_developer_roles IN VARCHAR2 DEFAULT NULL,
p_description IN VARCHAR2 DEFAULT NULL,
p_account_expiry IN DATE DEFAULT NULL,
p_account_locked IN VARCHAR2 DEFAULT 'N',
p_failed_access_attempts IN NUMBER DEFAULT 0,
p_change_password_on_first_use IN VARCHAR2 DEFAULT 'Y',
p_first_password_use_occurred IN VARCHAR2 DEFAULT 'N');
For use from SQL prompt: Application component export generated to HTP buffer
htmldb_util.export_application_component(
p_workspace_id IN NUMBER,
p_application_id IN NUMBER,
p_component_id IN NUMBER,
p_component_type IN VARCHAR2);
Fetch user information from wwv_flow_fnd_user, wwv_flow_fnd_group_users and wwv_flow_developers table
Overload 1
htmldb_util.fetch_user(
p_user_id IN NUMBER,
p_workspace OUT VARCHAR2,
p_user_name OUT VARCHAR2,
p_first_name OUT VARCHAR2,
p_last_name OUT VARCHAR2,
p_web_password OUT VARCHAR2,
p_email_address OUT VARCHAR2,
p_start_date OUT VARCHAR2,
p_end_date OUT VARCHAR2,
p_employee_id OUT VARCHAR2,
p_allow_access_to_schemas OUT VARCHAR2,
p_person_type OUT VARCHAR2,
p_default_schema OUT VARCHAR2,
p_groups OUT VARCHAR2,
p_developer_role OUT VARCHAR2,
p_description OUT VARCHAR2);
TBD
Overload 2
htmldb_util.fetch_user(
p_user_id IN NUMBER,
p_user_name OUT VARCHAR2,
p_first_name OUT VARCHAR2,
p_last_name OUT VARCHAR2,
p_email_address OUT VARCHAR2,
p_groups OUT VARCHAR2,
p_developer_role OUT VARCHAR2,
p_description OUT VARCHAR2);
htmldb_util.fetch_user(
p_user_id IN NUMBER,
p_workspace OUT VARCHAR2,
p_user_name OUT VARCHAR2,
p_first_name OUT VARCHAR2,
p_last_name OUT VARCHAR2,
p_web_password OUT VARCHAR2,
p_email_address OUT VARCHAR2,
p_start_date OUT VARCHAR2,
p_end_date OUT VARCHAR2,
p_employee_id OUT VARCHAR2,
p_allow_access_to_schemas OUT VARCHAR2,
p_person_type OUT VARCHAR2,
p_default_schema OUT VARCHAR2,
p_groups OUT VARCHAR2,
p_developer_role OUT VARCHAR2,
p_description OUT VARCHAR2,
p_account_expiry OUT DATE,
p_account_locked OUT VARCHAR2,
p_failed_access_attempts OUT NUMBER,
p_change_password_on_first_use OUT VARCHAR2,
p_first_password_use_occurred OUT VARCHAR2);