• Preface
    • Topic Overview
    • Audience
    • Documentation Accessibility
    • Related Documents
    • Conventions
  • APEX_UTIL
    • 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
    • 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
    • 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_ATTRIBUTE Function
    • GET_AUTHENTICATION_RESULT Function
    • GET_BLOB_FILE_SRC Function
    • GET_CURRENT_USER_ID Function
    • GET_DEFAULT_SCHEMA Function
    • GET_EMAIL 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_LAST_NAME Function
    • GET_NUMERIC_SESSION_STATE Function
    • GET_PREFERENCE 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_SESSION_STATE Function
    • GET_USER_ID Function
    • GET_USER_ROLES Function
    • GET_USERNAME Function
    • IS_LOGIN_PASSWORD_VALID 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
    • PURGE_REGIONS_BY_APP Procedure
    • PURGE_REGIONS_BY_NAME Procedure
    • PURGE_REGIONS_BY_PAGE Procedure
    • REMOVE_PREFERENCE Procedure
    • REMOVE_SORT_PREFERENCES Procedure
    • REMOVE_USER Procedure
    • RESET_AUTHORIZATIONS Procedure
    • RESET_PW Procedure
    • SAVEKEY_NUM Function
    • SAVEKEY_VC2 Function
    • SET_ATTRIBUTE Procedure
    • SET_AUTHENTICATION_RESULT Procedure
    • SET_CUSTOM_AUTH_STATUS Procedure
    • SET_EMAIL Procedure
    • SET_FIRST_NAME Procedure
    • SET_LAST_NAME Procedure
    • SET_PREFERENCE Procedure
    • SET_SESSION_LIFETIME_SECONDS Procedure
    • SET_SESSION_MAX_IDLE_SECONDS Procedure
    • SET_SESSION_STATE Procedure
    • SET_USERNAME Procedure
    • STRONG_PASSWORD_CHECK Procedure
    • STRONG_PASSWORD_VALIDATION Function
    • STRING_TO_TABLE Function
    • TABLE_TO_STRING Function
    • UNEXPIRE_END_USER_ACCOUNT Procedure
    • UNEXPIRE_WORKSPACE_ACCOUNT Procedure
    • UNLOCK_ACCOUNT Procedure
    • URL_ENCODE Function
    • WORKSPACE_ACCOUNT_DAYS_LEFT Function
  • APEX_MAIL
    • ADD_ATTACHMENT Procedure
    • PUSH_QUEUE Procedure
    • SEND Procedure
  • APEX_ITEM
    • CHECKBOX Function
    • DATE_POPUP Function
    • DISPLAY_AND_SAVE Function
    • HIDDEN Function
    • MD5_CHECKSUM Function
    • MD5_HIDDEN Function
    • POPUP_FROM_LOV Function
    • POPUP_FROM_QUERY Function
    • POPUPKEY_FROM_LOV Function
    • POPUPKEY_FROM_QUERY Function
    • RADIOGROUP Function
    • SELECT_LIST Function
    • SELECT_LIST_FROM_LOV Function
    • SELECT_LIST_FROM_LOV_XL Function
    • SELECT_LIST_FROM_QUERY Function
    • SELECT_LIST_FROM_QUERY_XL Function
    • TEXT Function
    • TEXTAREA Function
    • TEXT_FROM_LOV Function
    • TEXT_FROM_LOV_QUERY Function
  • APEX_APPLICATION
    • Referencing Arrays
    • Referencing Values Within an On Submit Process
    • Converting an Array to a Single Value
    • HELP Procedure
  • APEX_CUSTOM_AUTH
    • APPLICATION_PAGE_ITEM_EXISTS Function
    • CURRENT_PAGE_IS_PUBLIC Function
    • DEFINE_USER_SESSION Procedure
    • GET_COOKIE_PROPS Procedure
    • GET_LDAP_PROPS Procedure
    • GET_NEXT_SESSION_ID Function
    • GET_SECURITY_GROUP_ID Function
    • GET_SESSION_ID Function
    • GET_SESSION_ID_FROM_COOKIE Function
    • GET_USER Function
    • GET_USERNAME Function
    • IS_SESSION_VALID Function
    • LOGIN Procedure
    • LOGOUT Procedure
    • POST_LOGIN Procedure
    • SESSION_ID_EXISTS Function
    • SET_SESSION_ID Procedure
    • SET_SESSION_ID_TO_NEXT_VALUE Procedure
    • SET_USER Procedure
  • APEX_LDAP
    • AUTHENTICATE Function
    • GET_ALL_USER_ATTRIBUTES Procedure
    • GET_USER_ATTRIBUTES Procedure
    • IS_MEMBER Function
    • MEMBER_OF Function
    • MEMBER_OF2 Function
  • APEX_INSTANCE_ADMIN
    • ADD_SCHEMA Procedure
    • ADD_WORKSPACE Procedure
    • GET_PARAMETER Function
    • GET_SCHEMAS Function
    • REMOVE_SAVED_REPORTS Procedure
    • REMOVE_SCHEMA Procedure
    • REMOVE_WORKSPACE Procedure
    • SET_PARAMETER Procedure
    • Available Parameter Values
  • APEX_UI_DEFAULT_UPDATE
    • UPD_DISPLAY_IN_FORM Procedure
    • UPD_DISPLAY_IN_REPORT Procedure
    • UPD_FORM_REGION_TITLE Procedure
    • UPD_ITEM_DISPLAY_HEIGHT Procedure
    • UPD_ITEM_DISPLAY_WIDTH Procedure
    • UPD_ITEM_FORMAT_MASK Procedure
    • UPD_ITEM_HELP Procedure
    • UPD_LABEL Procedure
    • UPD_REPORT_ALIGNMENT Procedure
    • UPD_REPORT_FORMAT_MASK Procedure
    • UPD_REPORT_REGION_TITLE Procedure
  • JavaScript APIs
    • $x(pNd)
    • $v(pNd)
    • $s(pNd, pValue)
    • $u_Carray(pNd)
    • $u_Narray(pNd)
    • $nvl(pTest, pDefault)
    • doSubmit(pRequest)
    • confirmDelete(pMessage, pRequest)
    • $x_Style(pNd, pStyle, pString)
    • $x_Hide(pNd)
    • $x_Show(pNd)
    • $x_Toggle(pNd)
    • $x_Remove(pNd)
    • $x_Value(pNd,pValue)
    • $x_UpTill(pNd, pToTag)
    • $x_ItemRow(pNd,pFunc)
    • $x_HideItemRow(pNd)
    • $x_ShowItemRow(pNd)
    • $x_ToggleItemRow(pNd)
    • $x_HideAllExcept(pNd,pNdArray)
    • $x_HideSiblings(pNd)
    • $x_ShowSiblings(pNd)
    • $x_Class(pNd,pClass)
    • $x_SetSiblingsClass(pNd, pClass, pNdClass)
    • $x_ByClass(pClass, pNd, pTag)
    • $x_ShowAllByClass(pNd, pClass, pTag)
    • $x_ShowChildren(pNd)
    • $x_HideChildren(pNd)
    • $x_disableItem(pNd, pTest)
    • $f_get_emptys(pNd, pClassFail, pClass)
    • $v_Array(pNd)
    • $f_ReturnChecked(pNd)
    • $d_ClearAndHide(pNd)
    • $f_SelectedOptions(pNd)
    • $f_SelectValue(pNd)
    • $u_ArrayToString(pArray, pDelim)
    • $x_CheckImageSrc(pId,pSearch)
    • $v_CheckValueAgainst(pThis, pValue)
    • $f_Hide_On_Value_Item(pThis, pThat, pValue)
    • $f_Show_On_Value_Item(pThis, pThat, pValue)
    • $f_Hide_On_Value_Item_Row(pThis, pThat, pValue)
    • $f_Show_On_Value_Item_Row(pThis, pThat, pValue)
    • $f_DisableOnValue(pThis, pValue, pThat)
    • $x_ClassByClass(pNd, pClass, pTag, pClass2)
    • $f_ValuesToArray(pThis, pClass, pTag)
    • $x_FormItems(pNd, pType)
    • $f_CheckAll(pThis, pCheck, pArray)
    • $f_CheckFirstColumn(pNd)
    • $v_PopupReturn(pValue, pThat)
    • $x_ToggleWithImage(pThis,pNd)
    • $x_SwitchImageSrc(pNd, pSearch, pReplace)
    • $x_CheckImageSrc(pNd, pSearch)
    • $u_SubString(pText,pMatch)
    • html_RemoveAllChildren(pNd)
    • $v_IsEmpty(pThis)
    • html_SetSelectValue(pId,pValue)
    • addLoadEvent(pFunction)
    • $f_Swap(pThis,pThat)
    • submitEnter(pNd,e)
    • $f_SetValueSequence(pArray,pMultiple)
    • $dom_AddTag(pThis, pTag, pText)
    • $tr_AddTD(pThis,pText)
    • $tr_AddTH(pThis,pText)
    • $dom_AddInput(pThis,pType,pId,pName,pValue)
    • $dom_MakeParent(p_Node,p_Parent)
    • $x_RowHighlight(pThis, pColor)
    • $x_RowHighlightOff(pThis)
    • $v_Upper(pNd)
    • $d_Find(pThis,pString,pTags,pClass)
    • returnInput(p_R, p_D)
    • setReturn(p_R,p_D)
    • $f_First_field(pNd)
    • GetCookie (pName)
    • SetCookie (pName,pValue)
  • APEX_PLSQL_JOB
    • JOBS_ARE_ENABLED Function
    • PURGE_PROCESS Procedure
    • SUBMIT_PROCESS Function
    • TIME_ELAPSED Function
    • UPDATE_JOB_STATUS Procedure
  • APEX_LANG
    • LANG Function
    • MESSAGE Function
  • Index