Index

A

APEX_APPLICATION

global variables, 4

HELP Procedure, 4

package, 4

Referencing Arrays

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_SAVED_REPORTS procedure, 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

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_LANG

LANG Function, 11, 11

APEX_LANG APIs

APEX_LANG, 11

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

ADD_ATTACHMENT procedure, 2

PUSH_QUEUE procedure, 2

SEND procedure, 2

APEX_MAIL_QUEUE

sending email in queue, 2

APEX_PLSQL_JOB APIs

APEX_PLSQL_JOB, 10

APEX_PLSQL_JOBS

JOBS_ARE_ENABLED Function, 10

PURGE_PROCESS Procedure, 10

SUBMIT_PROCESS Function, 10

TIME_ELAPSED Function, 10

UPDATE_JOB_STATUS Procedure, 10

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 function, 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 function, 1

CLEAR_APP_CACHE procedure, 1

CLEAR_PAGE_CACHE procedure, 1

CLEAR_USER_CACHE procedure, 1

COUNT_CLICK procedure, 1

CREATE_USER procedure, 1

CREATE_USER_GROUP procedure, 1

CURRENT_USER_IN_GROUP function, 1

DOWNLOAD_PRINT_DOCUMENT procedure signature 1, 1

DOWNLOAD_PRINT_DOCUMENT procedure signature 2, 1

DOWNLOAD_PRINT_DOCUMENT procedure signature 3, 1

DOWNLOAD_PRINT_DOCUMENT procedure signature 4, 1

EDIT_USER procedure, 1

END_USER_ACCOUNT_DAYS_LEFT function, 1

EXPIRE_END_USER_ACCOUNT procedure, 1

EXPIRE_WORKSPACE_ACCOUNT procedure, 1

EXPORT_USERS procedure, 1

FETCH_APP_ITEM function, 1

FETCH_USER procedure signature 1, 1

FETCH_USER procedure signature 2, 1

FETCH_USER procedure signature 3, 1

FIND_SECURITY_GROUP_ID function, 1

FIND_WORKSPACE function, 1

GET_ACCOUNT_LOCKED_STATUS function, 1

GET_ATTRIBUTE function, 1

GET_AUTHENTICATION_RESULT function, 1

GET_BLOB_FILE_SRC function, 1

GET_CURRENT_USER_ID function, 1

GET_DEFAULT_SCHEMA function, 1

GET_EMAIL function, 1

GET_FILE procedure, 1

GET_FILE_ID function, 1

GET_FIRST_NAME function, 1

GET_GROUP_ID function, 1

GET_GROUP_NAME function, 1

GET_GROUPS_USER_BELONGS_TO function, 1

GET_LAST_NAME function, 1

GET_NUMERIC_SESSION_STATE function, 1

GET_PREFERENCE function, 1

GET_PRINT_DOCUMENT function signature 1, 1

GET_PRINT_DOCUMENT function signature 2, 1

GET_PRINT_DOCUMENT function signature 3, 1

GET_PRINT_DOCUMENT function signature 4, 1

GET_SESSION_STATE function, 1

GET_USER_ID function, 1

GET_USER_ROLES function, 1

GET_USERNAME function, 1

IS_LOGIN_PASSWORD_VALID function, 1

IS_USERNAME_UNIQUE function, 1

KEYVAL_NUM function, 1

KEYVAL_VC2 function, 1

LOCK_ACCOUNT procedure, 1, 1

PASSWORD_FIRST_USE_OCCURRED function, 1

PREPARE_URL function, 1

PUBLIC_CHECK_AUTHORIZATION function, 1

PURGE_REGIONS_BY_APP procedure, 1

PURGE_REGIONS_BY_NAME procedure, 1

PURGE_REGIONS_BY_PAGE procedure, 1

REMOVE_PREFERENCE procedure, 1

REMOVE_SORT_PREFERENCES procedure, 1

REMOVE_USER procedure, 1

RESET_AUTHORIZATIONS procedure, 1

RESET_PW procedure, 1

SAVEKEY_NUM function, 1

SAVEKEY_VC2 function, 1

SET_ATTRIBUTE procedure, 1

SET_AUTHENTICATION_RESULT procedure, 1

SET_CUSTOM_AUTH_STATUS procedure, 1

SET_EMAIL procedure, 1

SET_FIRST_NAME procedure, 1

SET_LAST_NAME procedure, 1

SET_PREFERENCE procedure, 1

SET_SESSION_STATE procedure, 1, 1, 1

SET_USERNAME procedure, 1, 1

STRING_TO_TABLE function, 1

STRONG_PASSWORD_CHECK procedure, 1

STRONG_PASSWORD_VALIDATION function, 1

TABLE_TO_STRING function, 1

UNEXPIRE_END_USER_ACCOUNT procedure, 1

UNEXPIRE_WORKSPACE_ACCOUNT procedure, 1

URL_ENCODE function, 1

WORKSPACE_ACCOUNT_DAYS_LEFT function, 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, 1, 1

special characters

encoding, 1

U

user

get e-mail address, 1

remove preference, 1

user account

altering, 1

creating new, 1

fetching, 1, 1, 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

Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices

Previous