Skip Headers
Oracle® Application Express API Reference
Release 3.1.2

Part Number E12855-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

A  C  E  F  J  L  P  R  S  U  V  W 

A

APEX_APPLICATION
global variables, 4
package, 4
APEX_APPLICATION.G_F01
referencing, 4
APEX_CUSTOM_AUTH, 5
APPLICATION_PAGE_ITEM_EXISTS function, 5
CURRENT_PAGE_IS_PUBLIC function, 5
DEFINE_USER_SESSION procedure, 5
GET_COOKIE_PROPS, 5
GET_LDAP_PROPS, 5
GET_NEXT_SESSION_ID function, 5
GET_SECURITY_GROUP_ID function, 5
GET_SESSION_ID function, 5
GET_SESSION_ID_FROM_COOKIE, 5
GET_USER function, 5
GET_USERNAME, 5
IS_SESSION_VALID, 5
LOGIN
Login API, 5
LOGOUT, 5
POST_LOGIN, 5
SESSION_ID_EXISTS function, 5
SET_SESSION_ID procedure, 5
SET_SESSION_ID_TO_NEXT_VALUE procedure, 5
SET_USER procedure, 5
APEX_INSTANCE_ADMIN, 7
ADD_SCHEMA procedure, 7
ADD_WORKSPACE procedure, 7
GET_PARAMETER function, 7
GET_SCHEMAS function, 7
parameter values, 7
REMOVE_SCHEMA procedure, 7
REMOVE_WORKSPACE procedure, 7
SET_PARAMETER procedure, 7
APEX_ITEM, 3
CHECKBOX function, 3
DATE_POPUP function, 3
DISPLAY_AND_SAVE, 3
HIDDEN function, 3
MD5_CHECKSUM function, 3
MD5_HIDDEN function, 3
MULTI_ROW_UPDATE procedure, 3
POPUP_FROM_LOV function, 3
POPUP_FROM_QUERY function, 3
POPUPKEY_FROM_LOV function, 3
POPUPKEY_FROM_QUERY function, 3
RADIOGROUP function, 3
SELECT_LIST function, 3
SELECT_LIST_FROM_LOV function, 3
SELECT_LIST_FROM_LOV_XL function, 3
SELECT_LIST_FROM_QUERY function, 3
SELECT_LIST_FROM_QUERY_XL function, 3
TEXT function, 3
TEXT_FROM_LOV function, 3
TEXT_FROM_LOV_QUERY function, 3
TEXTAREA function, 3
APEX_LDAP
AUTHENTICATE, 6
GET_ALL_USER_ATTRIBUTES, 6
GET_USER_ATTRIBUTES, 6
IS_MEMBER, 6
MEMBER_OF, 6
MEMBER_OF2 Function, 6
APEX_LDAP APIs
APEX_LDAP, 6
APEX_MAIL, 2
APEX_MAIL_ATTACHMENTS
accessing email attachments, 2
APEX_MAIL_QUEUE
sending email in queue, 2
APEX_MAIL.ADD_ATTACHMENT, 2
APEX_MAIL.PUSH_QUEUE, 2
APEX_MAIL.SEND, 2
APEX_UI_DEFAULT_UPDATE, 8
UPD_DISPLAY_IN_FORM procedure, 8
UPD_DISPLAY_IN_REPORT procedure, 8
UPD_FORM_REGION_TITLE procedure, 8
UPD_ITEM_DISPLAY_HEIGHT procedure, 8
UPD_ITEM_DISPLAY_WIDTH procedure, 8
UPD_ITEM_FORMAT_MASK procedure, 8
UPD_ITEM_HELP procedure, 8
UPD_ITEM_LABEL procedure, 8
UPD_REPORT_ALIGNMENT procedure, 8
UPD_REPORT_FORMAT_MASK procedure, 8
UPD_REPORT_REGION_TITLE procedure, 8
APEX_UTIL, 1
CACHE_GET_DATE_OF_PAGE_CACHE procedure, 1, 1
CACHE_PURGE_BY_APPLICATION procedure, 1
CACHE_PURGE_BY_PAGE procedure, 1
CACHE_PURGE_STALE procedure, 1
CHANGE_CURRENT_USER_PW procedure, 1
CHANGE_PASSWORD_ON_FIRST_USE, 1
CLEAR_APP_CACHE procedure, 1
CLEAR_PAGE_CACHE procedure, 1
CLEAR_USER_CACHE procedure, 1
COUNT_CLICK procedure, 1
COUNT_STALE_REGIONS function, 1
CREATE_USER procedure, 1
CREATE_USER_GROUP procedure, 1
CURRENT_USER_IN_GROUP function, 1
DOWNLOAD_PRINT_DOCUMENT procedure, 1, 1, 1, 1
EDIT_USER procedure, 1
END_USER_ACCOUNT_DAYS_LEFT, 1
EXPIRE_END_USER_ACCOUNT, 1
EXPIRE_WORKSPACE_ACCOUNT, 1
EXPORT_USERS procedure, 1
FETCH_APP_ITEM function, 1
FETCH_USER procedure, 1
FIND_SECURITY_GROUP_ID function, 1
FIND_WORKSPACE function, 1
GET_ACCOUNT, 1
GET_ATTRIBUTE function, 1
GET_AUTHENTICATION_RESULT, 1
GET_BLOB_FILE_SRC function, 1
GET_CURRENT_USER_ID function, 1
GET_DEFAULT_SCHEMA, 1
GET_EMAIL, 1
GET_FILE procedure, 1
GET_FILE_ID function, 1
GET_FIRST_NAME, 1
GET_GROUP_ID, 1
GET_GROUP_NAME, 1
GET_GROUPS_USER_BELONGS_TO, 1
GET_LAST_NAME, 1
GET_NUMERIC_SESSION_STATE function, 1
GET_PREFERENCE function, 1
GET_PRINT_DOCUMENT function, 1, 1, 1, 1
GET_SESSION_STATE function, 1
GET_USER_ID, 1
GET_USER_ROLES, 1
GET_USERNAME, 1
IS_LOGIN_PASSWORD_VALID, 1
IS_USERNAME_UNIQUE, 1
KEYVAL_NUM, 1
KEYVAL_VC2, 1
LOCK_ACCOUNT, 1, 1
PASSWORD_FIRST_USE_OCCURRED, 1
PREPARE_URL, 1
PUBLIC_CHECK_AUTHORIZATION function, 1
PURGE_REGIONS_BY_APP procedure, 1
PURGE_REGIONS_BY_ID procedure, 1, 1
PURGE_REGIONS_BY_NAME procedure, 1
PURGE_STALE_REGIONS procedure, 1
REMOVE_PREFERENCE procedure, 1
REMOVE_SORT_PREFERENCES procedure, 1
REMOVE_USER, 1
RESET_AUTHORIZATIONS procedure, 1
RESET_PW, 1
SAVEKEY_NUM, 1
SAVEKEY_VC2, 1
SET_ATTRIBUTE, 1
SET_AUTHENTICATION_RESULT, 1
SET_CUSTOM_AUTH_STATUS, 1
SET_EMAIL, 1
SET_FIRST_NAME, 1
SET_LAST_NAME, 1
SET_PREFERENCE procedure, 1
SET_SESSION_STATE procedure, 1
SET_USERNAME, 1
SET_USERNAME procedure, 1
STRING_TO_TABLE function, 1
STRONG_PASSWORD_CHECK, 1
STRONG_PASSWORD_CHECK procedure, 1
STRONG_PASSWORD_VALIDATION function, 1
TABLE_TO_STRING function, 1
UNEXPIRE_END_USER_ACCOUNT, 1
UNEXPIRE_WORKSPACE_ACCOUNT, 1
URL_ENCODE function, 1
WORKSPACE_ACCOUNT_DAYS_LEFT, 1
APIs
APEX_APPLICATION, 4
APEX_CUSTOM_AUTH, 5
APEX_ITEM, 3
APEX_MAIL, 2
APEX_UTIL, 1
application
sending messages in APEX_MAIL_QUEUE, 2
sending outbound email, 2
sending outbound email as attachment, 2
attribute values
setting, 1
authenticated user
create user group, 1
authentication
scheme session cookies, 5

C

check box
creating, 3
clicks
counting, 1

E

email
sending as an attachment, 2
sending messages in APEX_MAIL_QUEUE, 2
sending outbound, 2
export file
of workspace, 1

F

F01, 4
file repository
downloading files, 1
obtaining primary key, 1

J

JavaScript API
$d_ClearAndHide(pNd), 9
$d_Find(pThis,pString,pTags,pClass), 9
$dom_AddInput(pThis,pType,pId,pName,pValue), 9
$dom_AddTag(pThis, pTag, pText), 9
$dom_MakeParent(p_Node,p_Parent), 9
$f_CheckAll(pThis, pCheck, pArray), 9
$f_CheckFirstColumn(pNd), 9
$f_DisableOnValue(pThis, pValue, pThat), 9
$f_First_field(pNd), 9
$f_get_emptys(pNd, pClassFail, pClass), 9
$f_Hide_On_Value_Item(pThis, pThat, pValue), 9
$f_Hide_On_Value_Item_Row(pThis, pThat, pValue), 9
$f_ReturnChecked(pNd), 9
$f_SelectedOptions(pNd), 9
$f_SelectValue(pNd), 9
$f_SetValueSequence(pArray,pMultiple), 9
$f_Show_On_Value_Item(pThis, pThat, pValue), 9
$f_Show_On_Value_Item_Row(pThis, pThat, pValue), 9
$f_Swap(pThis,pThat), 9
$f_ValuesToArray(pThis, pClass, pTag), 9
$nvl(pTest, pDefault), 9
$s(pNd, pValue), 9
$tr_AddTD(pThis,pText), 9
$tr_AddTH(pThis,pText), 9
$u_ArrayToString(pArray, pDelim), 9
$u_Carray(pNd), 9
$u_Narray(pNd), 9
$u_SubString(pText,pMatch), 9
$v(pNd), 9
$v_Array(pNd), 9
$v_CheckValueAgainst(pThis, pValue), 9
$v_IsEmpty(pThis), 9
$v_PopupReturn(pValue, pThat), 9
$v_Upper(pNd), 9
$x(pNd), 9
$x_ByClass(pClass, pNd, pTag), 9
$x_CheckImageSrc(pId,pSearch), 9
$x_CheckImageSrc(pNd, pSearch), 9
$x_Class(pNd,pClass), 9
$x_ClassByClass(pNd, pClass, pTag, pClass2), 9
$x_disableItem(pNd,a), 9
$x_FormItems(pNd, pType), 9
$x_Hide(pNd), 9
$x_HideAllExcept(pNd,pNdArray), 9
$x_HideItemRow(pNd), 9
$x_HideSiblings(pNd), 9
$x_ItemRow(pNd,pFunc), 9
$x_Remove(pNd), 9
$x_RowHighlight(pThis,pColor), 9
$x_RowHighlightOff(pThis), 9
$x_SetSiblingsClass(pNd, pClass, pNdClass), 9
$x_Show(pNd), 9
$x_ShowAllByClass(pNd, pClass, pTag), 9
$x_ShowChildren(pThis), 9, 9
$x_ShowItemRow(pNd), 9
$x_ShowSiblings(pNd), 9
$x_Style(pNd, pStyle, pString), 9
$x_SwitchImageSrc(pNd, pSearch, pReplace), 9
$x_Toggle(pNd), 9
$x_ToggleItemRow(pNd), 9
$x_ToggleWithImage(pThis,pNd), 9
$x_UpTill(pNd, pToTag), 9
$x_Value(pNd,pValue), 9
addLoadEvent(pFunction), 9
confirmDelete(pMessage, pRequest), 9
doSubmit(pRequest), 9
GetCookie (pName), 9
html_RemoveAllChildren(pNd), 9
html_SetSelectValue(pId,pValue), 9
returnInput(p_R, p_D), 9
SetCookie (pName,pValue), 9
setReturn(p_R,p_D), 9
submitEnter(pNd,e), 9

L

LDAP attributes
obtaining, 5

P

password
changing, 1
resetting and emailing, 1

R

radio group
generate, 3

S

session
cookies, 5
session state
fetching for current application, 1
removing for current page, 1
removing for current session, 1
setting, 1
special characters
encoding, 1

U

user
get e-mail address, 1
remove preference, 1
user account
altering, 1
creating new, 1
fetching, 1
removing, 1
update email address, 1
updating FIRST_NAME, 1
updating LAST_NAME value, 1
updating USER_NAME value, 1

V

variables
global, 4

W

workspace
export file, 1
numeric security group ID, 1