Index

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

A

APEX_APPLICATION
global variables, 1
HELP Procedure, 1
package, 1
Referencing Arrays
referencing, 1
APEX_APPLICATION_INSTALL, 2
CLEAR_ALL procedure, 2
examples
import application into different workspaces using different schema, 2
import application with generated application id, 2
import application with specified application id, 2
import application without modification, 2
import into training instance for three different workspaces, 2
GENERATE_APPLICATION_ID procedure, 2
GENERATE_OFFSET procedure, 2
GET_APPLICATION_ALIAS function, 2
GET_APPLICATION_ID function, 2
GET_APPLICATION_NAME function, 2
GET_IMAGE_PREFIX function, 2
GET_OFFSET function, 2
GET_PROXY function, 2
GET_SCHEMA function, 2
GET_WORKSPACE_ID function, 2
import script examples, 2
package overview, 2
SET_APPLICATION_ALIAS procedure, 2
SET_APPLICATION_ID procedure, 2
SET_APPLICATION_NAME procedure, 2
SET_IMAGE_PREFIX procedure, 2
SET_OFFSET procedure, 2
SET_PROXY procedure, 2
SET_SCHEMA procedure, 2
SET_WORKSPACE_ID procedure, 2
APEX_COLLECTION, 3
ADD_MEMBER function, 3
ADD_MEMBER procedure, 3
ADD_MEMBERS procedure, 3
COLLECTION_EXISTS function, 3
COLLECTION_HAS_CHANGED function, 3
COLLECTION_MEMBER_COUNT function, 3
CREATE_COLLECTION procedure, 3
CREATE_COLLECTION_FROM_QUERY, 3
CREATE_COLLECTION_FROM_QUERY_B procedure, 3
CREATE_COLLECTION_FROM_QUERY2 procedure, 3
CREATE_COLLECTION_FROM_QUERYB2 procedure, 3
CREATE_OR_TRUNCATE_COLLECTION, 3
CREATE_OR_TRUNCATE_COLLECTION procedure, 3
DELETE_ALL_COLLECTIONS procedure, 3
DELETE_ALL_COLLECTIONS_SESSION procedure, 3
DELETE_COLLECTION procedure, 3
DELETE_MEMBER procedure, 3
DELETE_MEMBERS procedure, 3
GET_MEMBER_MD5 function, 3
MERGE_MEMBERS procedure, 3
MOVE_MEMBER_DOWN procedure, 3
MOVE_MEMBER_UP procedure, 3
RESEQUENCE_COLLECTION procedure, 3
RESET_COLLECTION_CHANGED procedure, 3
RESET_COLLECTION_CHANGED_ALL procedure, 3
SORT_MEMBERS procedure, 3
TRUNCATE_COLLECTION procedure, 3
UPDATE_MEMBER procedure, 3
UPDATE_MEMBER_ATTRIBUTE procedure signature 1, 3
UPDATE_MEMBER_ATTRIBUTE procedure signature 2, 3
UPDATE_MEMBER_ATTRIBUTE procedure signature 3, 3
UPDATE_MEMBER_ATTRIBUTE procedure signature 4, 3
UPDATE_MEMBER_ATTRIBUTE procedure signature 5, 3
UPDATE_MEMBER_ATTRIBUTE procedure signature 6, 3
UPDATE_MEMBERS procedure, 3
APEX_CSS, Preface, Preface, Preface, Preface, Preface, 4
ADD_FILE procedure, 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_DEBUG_MESSAGE, 6
DISABLE_DEBUG_MESSAGES procedure, 6
ENABLE_DEBUG_MESSAGES procedure, 6
LOG_LONG_MESSAGE procedure, 6
LOG_MESSAGE procedure, 6
LOG_PAGE_SESSION_STATE procedure, 6
REMOVE_DEBUG_BY_AGE procedure, 6
REMOVE_DEBUG_BY_APP procedure, 6
REMOVE_DEBUG_BY_VIEW procedure, 6
REMOVE_SESSION_MESSAGES procedure, 6
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_REPORT procedure, 7
REMOVE_SAVED_REPORTS procedure, 7
REMOVE_SCHEMA procedure, 7
REMOVE_WORKSPACE procedure, 7
SET_PARAMETER procedure, 7
APEX_ITEM, 8
CHECKBOX function, 8
DATE_POPUP function, 8, 8
DISPLAY_AND_SAVE, 8
HIDDEN function, 8
MD5_CHECKSUM function, 8
MD5_HIDDEN function, 8
POPUP_FROM_LOV function, 8
POPUP_FROM_QUERY function, 8
POPUPKEY_FROM_LOV function, 8
POPUPKEY_FROM_QUERY function, 8
RADIOGROUP function, 8
SELECT_LIST function, 8
SELECT_LIST_FROM_LOV function, 8
SELECT_LIST_FROM_LOV_XL function, 8
SELECT_LIST_FROM_QUERY function, 8
SELECT_LIST_FROM_QUERY_XL function, 8
TEXT function, 8
TEXT_FROM_LOV function, 8
TEXT_FROM_LOV_QUERY function, 8
TEXTAREA function, 8
APEX_JAVASCRIPT, 9
ADD_ATTRIBUTE function signature 1, 9
ADD_ATTRIBUTE function signature 2, 9
ADD_ATTRIBUTE function signature 3, 9
ADD_ATTRIBUTE function signature 4, 9
ADD_INLINE_CODE procedure, 9
ADD_LIBRARY procedure, 9
ADD_ONLOAD_CODE procedure, 9
ADD_VALUE function signature 1, 9
ADD_VALUE function signature 2, 9
ADD_VALUE function signature 3, 9
ADD_VALUE function signature 4, 9
ESCAPE function, 9
APEX_LANG, 10
LANG function, 10
MESSAGE function, 10
APEX_LDAP, 11
AUTHENTICATE, 11
GET_ALL_USER_ATTRIBUTES, 11
GET_USER_ATTRIBUTES, 11
IS_MEMBER, 11
MEMBER_OF, 11
MEMBER_OF2 Function, 11
APEX_MAIL, 12
ADD_ATTACHMENT procedure, 12
PUSH_QUEUE procedure, 12
SEND procedure, 12
APEX_MAIL_QUEUE
sending email in queue, 12
APEX_PLSQL_JOB, 13
APEX_PLSQL_JOBS
JOBS_ARE_ENABLED Function, 13
PURGE_PROCESS Procedure, 13
SUBMIT_PROCESS Function, 13
TIME_ELAPSED Function, 13
UPDATE_JOB_STATUS Procedure, 13
APEX_PLUGIN, 14
data types, 14
GET_AJAX_IDENTIFIER function, 14
GET_INPUT_NAME_FOR_PAGE_ITEM function, 14
APEX_PLUGIN_UTIL, 15
DEBUG_DYNAMIC_ACTION procedure, 15
DEBUG_PAGE_ITEM procedure signature 1, 15
DEBUG_PAGE_ITEM procedure signature 2, 15
DEBUG_PROCESS procedure, 15
DEBUG_REGION procedure signature 1, 15
DEBUG_REGION procedure signature 2, 15
ESCAPE function, 15
EXECUTE_PLSQL_CODE procedure, 15
GET_DISPLAY_DATA function signature 1, 15
GET_DISPLAY_DATA function signature 2, 15
GET_PLSQL_EXPRESSION_RESULT function, 15
GET_PLSQL_FUNCTION_RESULT function, 15
GET_POSITION_IN_LIST function, 15
GET_SEARCH_STRING function, 15
IS_EQUAL function, 15
PAGE_ITEM_NAMES_TO_JQUERY function, 15
PRINT_DISPLAY_ONLY procedure, 15
PRINT_ESCAPED_VALUE procedure, 15
PRINT_HIDDEN_IF_READONLY procedure, 15
PRINT_JSON_HTTP_HEADER procedure, 15
PRINT_LOV_AS_JSON procedure, 15
PRINT_OPTION procedure, 15
APEX_UI_DEFAULT_UPDATE, 16
ADD_AD_COLUMN procedure, 16
ADD_AD_SYNONYM procedure, 16
DEL_AD_COLUMN procedure, 16
DEL_AD_SYNONYM procedure, 16
DEL_COLUMN procedure, 16
DEL_GROUP procedure, 16
DEL_TABLE procedure, 16
SYNCH_TABLE procedure, 16
UPD_AD_COLUMN procedure, 16
UPD_AD_SYNONYM procedure, 16
UPD_COLUMN procedure, 16
UPD_DISPLAY_IN_FORM procedure, 16
UPD_DISPLAY_IN_REPORT procedure, 16
UPD_FORM_REGION_TITLE procedure, 16
UPD_GROUP procedure, 16
UPD_ITEM_DISPLAY_HEIGHT procedure, 16
UPD_ITEM_DISPLAY_WIDTH procedure, 16
UPD_ITEM_FORMAT_MASK procedure, 16
UPD_ITEM_HELP procedure, 16
UPD_ITEM_LABEL procedure, 16
UPD_REPORT_ALIGNMENT procedure, 16
UPD_REPORT_FORMAT_MASK procedure, 16
UPD_REPORT_REGION_TITLE procedure, 16
UPD_TABLE procedure, 16
APEX_UTIL, 17
CACHE_GET_DATE_OF_PAGE_CACHE function, 17, 17
CACHE_PURGE_BY_APPLICATION procedure, 17
CACHE_PURGE_BY_PAGE procedure, 17
CACHE_PURGE_STALE procedure, 17
CHANGE_CURRENT_USER_PW procedure, 17
CHANGE_PASSWORD_ON_FIRST_USE function, 17
CLEAR_APP_CACHE procedure, 17
CLEAR_PAGE_CACHE procedure, 17
CLEAR_USER_CACHE procedure, 17
COUNT_CLICK procedure, 17
CREATE_USER procedure, 17
CREATE_USER_GROUP procedure, 17
CURRENT_USER_IN_GROUP function, 17
DOWNLOAD_PRINT_DOCUMENT procedure signature 1, 17
DOWNLOAD_PRINT_DOCUMENT procedure signature 2, 17
DOWNLOAD_PRINT_DOCUMENT procedure signature 3, 17
DOWNLOAD_PRINT_DOCUMENT procedure signature 4, 17
EDIT_USER procedure, 17
END_USER_ACCOUNT_DAYS_LEFT function, 17
EXPIRE_END_USER_ACCOUNT procedure, 17
EXPIRE_WORKSPACE_ACCOUNT procedure, 17
EXPORT_USERS procedure, 17
FETCH_APP_ITEM function, 17
FETCH_USER procedure signature 1, 17
FETCH_USER procedure signature 2, 17
FETCH_USER procedure signature 3, 17
FIND_SECURITY_GROUP_ID function, 17
FIND_WORKSPACE function, 17
GET_ACCOUNT_LOCKED_STATUS function, 17
GET_ATTRIBUTE function, 17
GET_AUTHENTICATION_RESULT function, 17
GET_BLOB_FILE_SRC function, 17
GET_CURRENT_USER_ID function, 17
GET_DEFAULT_SCHEMA function, 17
GET_EDITION function, 17
GET_EMAIL function, 17
GET_FEEDBACK_FOLLOW_UP function, 17
GET_FILE procedure, 17
GET_FILE_ID function, 17
GET_FIRST_NAME function, 17
GET_GROUP_ID function, 17
GET_GROUP_NAME function, 17
GET_GROUPS_USER_BELONGS_TO function, 17
GET_LAST_NAME function, 17
GET_NUMERIC_SESSION_STATE function, 17
GET_PREFERENCE function, 17
GET_PRINT_DOCUMENT function signature 1, 17
GET_PRINT_DOCUMENT function signature 2, 17
GET_PRINT_DOCUMENT function signature 3, 17
GET_PRINT_DOCUMENT function signature 4, 17
GET_SCREEN_READER_MODE_TOGGLE function, 17
GET_SESSION_LANG function, 17
GET_SESSION_STATE function, 17
GET_SESSION_TERRITORY function, 17
GET_SESSION_TIME_ZONEfunction, 17
GET_USER_ID function, 17
GET_USER_ROLES function, 17
GET_USERNAME function, 17
IR_CLEAR procedure, 17
IR_FILTER procedure, 17
IR_RESET procedure, 17
IS_LOGIN_PASSWORD_VALID function, 17
IS_SCREEN_READER_SESSION function, 17
IS_SCREEN_READER_SESSION_YN function, 17
IS_USERNAME_UNIQUE function, 17
KEYVAL_NUM function, 17
KEYVAL_VC2 function, 17
LOCK_ACCOUNT procedure, 17, 17
PASSWORD_FIRST_USE_OCCURRED function, 17
PREPARE_URL function, 17
PUBLIC_CHECK_AUTHORIZATION function, 17
PURGE_REGIONS_BY_APP procedure, 17
PURGE_REGIONS_BY_NAME procedure, 17
PURGE_REGIONS_BY_PAGE procedure, 17
REMOVE_PREFERENCE procedure, 17
REMOVE_SORT_PREFERENCES procedure, 17
REMOVE_USER procedure, 17
RESET_AUTHORIZATIONS procedure, 17
RESET_PW procedure, 17
SAVEKEY_NUM function, 17
SAVEKEY_VC2 function, 17
SET_ATTRIBUTE procedure, 17
SET_AUTHENTICATION_RESULT procedure, 17
SET_CUSTOM_AUTH_STATUS procedure, 17
SET_EDITION procedure, 17
SET_EMAIL procedure, 17
SET_FIRST_NAME procedure, 17
SET_LAST_NAME procedure, 17
SET_PREFERENCE procedure, 17
SET_SECURITY_GROUP_ID procedure, 17, 17
SET_SESSION_SCREEN_READER_OFF procedure, 17, 17
SET_SESSION_STATE procedure, 17, 17, 17
SET_SESSION_TERRITORY procedure, 17
SET_SESSION_TIME_ZONE procedure, 17
SET_USERNAME procedure, 17, 17
SHOW_SCREEN_READER_MODE_TOGGLE function, 17
STRING_TO_TABLE function, 17
STRONG_PASSWORD_CHECK procedure, 17
STRONG_PASSWORD_VALIDATION function, 17
SUBMIT_FEEDBACK procedure, 17
SUBMIT_FEEDBACK_FOLLOWUP procedure, 17
TABLE_TO_STRING function, 17
UNEXPIRE_END_USER_ACCOUNT procedure, 17
UNEXPIRE_WORKSPACE_ACCOUNT procedure, 17
URL_ENCODE function, 17
WORKSPACE_ACCOUNT_DAYS_LEFT function, 17
APEX_WEB_SERVICE, 18
About the APEX_WEB_SERVICE API, 18
BLOB2CLOBBASE64 function, 18
CLOBBASE642BLOB function, 18
Invoking a RESTful Style Web Service, 18
Invoking a SOAP Style Web Service, 18
MAKE_REQUEST function, 18
MAKE_REQUEST procedure, 18
MAKE_REST_REQUEST function, 18
PARSE_RESPONSE function, 18
PARSE_RESPONSE_CLOB function, 18
PARSE_XML function, 18
PARSE_XML_CLOB function, 18
Retrieving Cookies and HTTP HeadersI, 18
Setting Cookies and HTTP Headers, 18
APIs
APEX_APPLICATION, 1
APEX_APPLICATION_INSTALL, 2
APEX_COLLECTION, 3
APEX_CSS, Preface, Preface, Preface, Preface, Preface, 4
APEX_CUSTOM_AUTH, 5
APEX_DEBUG_MESSAGE, 6
APEX_INSTANCE_ADMIN, 7
APEX_ITEM, 8
APEX_JAVASCRIPT, 9
APEX_LANG, 10
APEX_LDAP, 11
APEX_MAIL, 12
APEX_PLSQL_JOB, 13
APEX_PLUGIN, 14
APEX_PLUGIN_UTIL, 15
APEX_UI_DEFAULT_UPDATE, 16
APEX_UTIL, 17
APEX_WEB_SERVICE, 18
JavaScript API, 19
application
sending messages in APEX_MAIL_QUEUE, 12
sending outbound email, 12
sending outbound email as attachment, 12
attribute values
setting, 17
authenticated user
create user group, 17
authentication
scheme session cookies, 5

C

check box
creating, 8
clicks
counting, 17
collections
accessing, 3
APEX_COLLECTION API, 3
clearing session state, 3
creating, 3
deleting members, 3
determining status, 3
managing, 3
merging, 3
truncating, 3
updating members, 3

E

email
sending as an attachment, 12
sending messages in APEX_MAIL_QUEUE, 12
sending outbound, 12
export file
of workspace, 17

F

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

J

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

L

LDAP attributes
obtaining, 5

P

password
changing, 17
resetting and emailing, 17

R

radio group
generate, 8

S

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

U

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

V

variables
global, 1

W

workspace
export file, 17
numeric security group ID, 17

 Previous
Previous