Application items
Application items are defined in the Shared Components module as part of the Logic section. As such, they are available to us throughout the application, like global variables.
Application items are not rendered on the application page and they don't have a specific data type. We are usually using them as part of SQL or PL/SQL code, and they can hold any type of data we choose to store in them. Being used very often in SQL and PL/SQL code, they should adhere with the Oracle identifiers name rules as we specified them earlier in this chapter.
The APEX naming convention recommends us to prefix the application item name with the letter 'F' and the application ID. In the following screenshot, we can see the Create/Edit Application Item screen of application 250. Hence, the application items will be prefixed, by default, with F250_, e.g. F250_APP_ITEM1
. We, of course, can choose any other naming convention or any specific name that we want. Taking into account that changing...