Contents

Title and Copyright Information

Preface

• Topic Overview
• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 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

2 APEX_MAIL

• ADD_ATTACHMENT Procedure
• PUSH_QUEUE Procedure
• SEND Procedure

3 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

4 APEX_APPLICATION

• Referencing Arrays
• Referencing Values Within an On Submit Process
• Converting an Array to a Single Value
• HELP Procedure

5 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

6 APEX_LDAP

• AUTHENTICATE Function
• GET_ALL_USER_ATTRIBUTES Procedure
• GET_USER_ATTRIBUTES Procedure
• IS_MEMBER Function
• MEMBER_OF Function
• MEMBER_OF2 Function

7 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

8 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

9 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)

10 APEX_PLSQL_JOB

• JOBS_ARE_ENABLED Function
• PURGE_PROCESS Procedure
• SUBMIT_PROCESS Function
• TIME_ELAPSED Function
• UPDATE_JOB_STATUS Procedure

11 APEX_LANG

• LANG Function
• MESSAGE Function