add

About Me

My photo
Oracle Apps - Techno Functional consultant

Thursday, August 11

Forms Built-in Routines

Forms Developer provides several client-side built-in packages that contain many PL/SQL constructs you can reference while building applications or debugging your application code viz:
  • Item Built-ins
  • Record Built-ins
  • Block Built-ins
  • Form Built-ins
  • Canvas Built-ins
  • Window Built-ins
  • Alert Built-ins
  • Application Built-ins
  • Query Built-ins
  • Record Group Built-ins
  • List Item Built-ins
  • Parameter Built-ins

Item Built-ins

  • FIND_ITEM
  • ID_NULL
  • GET_ITEM_PROPERTY
  • SET_ITEM_PROPERTY
  • GO_ITEM
  • NEXT_ITEM
  • PREVIOUS_ITEM
  • CLEAR_ITEM
  • NAME_IN
  • CHECKBOX_CHECKED
  • GET_RADIO_BUTTON_PROPERTY
  • SET_RADIO_BUTTON_PROPERTY

Record Built-ins

  • GET_RECORD_PROPERTY
  • SET_RECORD_PROPERTY
  • GO_RECORD
  • FIRST_RECORD
  • LAST_RECORD
  • NEXT_RECORD
  • PREVIOUS_RECORD
  • CLEAR_RECORD
  • CREATE_RECORD

Block Built-ins

  • FIND_BLOCK
  • ID_NULL
  • GET_BLOCK_PROPERTY
  • SET_BLOCK_PROPERTY
  • GO_BLOCK
  • NEXT_BLOCK
  • PREVIOUS_BLOCK
  • CLEAR_BLOCK

Form Built-ins

  • FIND_FORM
  • ID_NULL
  • GET_FORM_PROPERTY
  • SET_FORM_PROPERTY
  • CALL_FORM
  • SYNCHRONIZE
  • CLEAR_FORM
  • COMMIT_FORM
  • EXIT_FORM
  • FORM_FAILURE
  • FORM_SUCCESS

Canvas Built-ins

  • FIND_CANVAS
  • FIND_VIEW
  • ID_NULL
  • GET_CANVAS_PROPERTY
  • GET_VIEW_PROPERTY
  • SET_CANVAS_PROPERTY
  • SET_VIEW_PROPERTY
  • HIDE_VIEW
  • SHOW_VIEW
  • SCROLL_VIEW

Window Built-ins

  • FIND_WINDOW
  • ID_NULL
  • GET_WINDOW_PROPERTY
  • SET_WINDOW_PROPERTY
  • SHOW_WINDOW
  • HIDE_WINDOW

Alter Built-ins

  • FIND_ALERT
  • ID_NULL
  • SET_ALERT_BUTTON_PROPERTY
  • SET_ALERT_PROPERTY
  • SHOW_ALERT

Application Built-ins

  • DO_KEY
  • GET_APPLICATION_PROPERTY
  • SET_APPLICATION_PROPERTY
  • HOST
  • PAUSE

Query Built-ins

  • ABORT_QUERY
  • COUNT_QUERY
  • ENTER_QUERY
  • EXECUTE_QUERY

Record Group Built-ins

  • FIND_GROUP
  • FIND_COLUMN
  • ID_NULL
  • CREATE_GROUP_FROM_QUERY
  • POPULATE_GROUP
  • GET_GROUP_ROW_COUNT
  • DELETE_GROUP_ROW
  • DELETE_GROUP
  • CREATE_GROUP
  • ADD_GROUP_COLUMN
  • ADD_GROUP_ROW
  • SET_GROUP_CHAR_CELL
  • GET_GROUP_CHAR_CELL

List Item Built-ins

  • GET_LIST_ELEMENT_COUNT
  • ADD_LIST_ELEMENT
  • DELETE_LIST_ELEMENT
  • GET_LIST_ELEMENT_LABEL
  • GET_LIST_ELEMENT_VALUE
  • POPULATE_LIST

Parameter List Built-ins

  • Get_Parameter_List
  • ID_NULL
  • CREATE_PARAMETER_LIST
  • ADD_PARAMETER
  • GET_PARAMETER_ATTR
  • SET_PARAMETER_ATTR
  • DELETE_PARAMETER
  • DESTROY_PARAMETER_LIST

No comments: