APP_ITEM_PROPERTY in Oracle E-Business Suite

APP_ITEM_PROPERTY is one of the very good routine provided by Oracle E-Business Suite to change behavior of items in native Oracle Forms that we develop for clients. Generally in standalone oracle form development we use built-in routine SET_ITEM_PROPERTY to control the interaction of user with items and alter properties or items but in order to remain adhered to Oracle E-Business Suite standards APP_ITEM_PROPERTY.SET_PROPERTY is the best option. Also, it simplifies our coding up to some extent.

APP_ITEM_PROPERTY.SET PROPERTY cover routine changes below properties

  • REQUIRED
  • DISPLAYED
  • ALTERABLE and ALTERABLE_PLUS
  • ENTERABLE
  • ENABLED

REQUIRED

REQUIRED property makes item mandatory or non-mandatory. If the item is mandatory for user to enter then REQUIRED property must be set to TRUE or if the item is non-mandatory REQUIRED property must be set to FALSE. APP_ITEM_PROPERTY.SET_PROPERTY can set REQURED property at item level only. In order to set this property at record level you need to reset it on every record. You can also use built-in routine SET_ITEM_INSTANCE_PROPERTY to set REQUIRED property at record level.

  • PROPERTY_ON attribute sets REQUIRED property to TRUE
  • PROPERTY_OFF attribute sets REQUIRED property to FALSE

The following code:

is equivalent to:

If the item is currently hidden, no action is taken.

DISPLAYED

With DISPLAYED property we can set whether the item needs to be displayed or hidden. It also resets the default property of an item that is set during initial form loading.

  • PROPERTY_ON attribute sets DISPLAYED property to TRUE
  • PROPERTY_OFF attribute sets DISPLAYED property to FALSE

The following code:

is equivalent to:

If the item is not a display item then also set:

If the item is neither a display item nor a button then also set:

ALTERABLE and ALTERABLE_PLUS

ALTERABLE

ALTERABLE property is set to allow or disallow changes to a specific instance (single row) of an item regardless of whether the record is new or queried. The item remains keyboard navigable even if ALTERABLE property is set to FALSE.

  • PROPERTY_ON attribute sets ALTERABLE property to TRUE
  • PROPERTY_OFF attribute sets ALTERABLE property to FALSE

The following code:

is equivalent to:

At Item Instance level

At Item Level

ALTERABLE_PLUS

ALTERABLE_PLUS property is set to allow or disallow changes to all instances (all rows in block) of an item regardless of whether the record is new or queried. The item remains keyboard navigable even if ALTERABLE_PLUS property is set to FALSE.

  • PROPERTY_ON attribute sets ALTERABLE_PLUS property to TRUE
  • PROPERTY_OFF attribute sets ALTERABLE_PLUS property to FALSE

The following code:

is equivalent to:

ENABLED

ENABLED property is intended to disable an item during the entire session of the form till it is re-enabled. Benefit of using APP_ITEM_PROPERTY.SET_PROPERTY instead of SET_ITEM_PROPERTY is when you re-enable the item certain other properties are reset automatically.

  • PROPERTY_ON attribute sets ENABLED property to TRUE
  • PROPERTY_OFF attribute sets ENABLED property to FALSE

The following code:

is equivalent to (for a text item or a list item):

If the item is a button, then the APP_ITEM_PROPERTY.SET_PROPERTY call is equivalent to:

If the item is not a text item, list, or button, then the APP_ITEM_PROPERTY.SET_PROPERTY call is equivalent to:

If the item is a display item or is currently hidden, then no action is taken.

ENTERABLE

The ENTERABLE property is used to simulate disabling a particular instance of an item (single row). It is same as that of ALTERABLE property except that it also controls NAVIGABLE property of an item. The user can however click into the item even if ENTERABLE property is set to FALSE.

Item and item-instance values are both set to make sure the effect of both of them produces the desired result.

  • PROPERTY_ON attribute sets ENTERABLE property to TRUE
  • PROPERTY_OFF attribute sets ENTERABLE property to FALSE

The following code:

is equivalent to:

At Item Instance Level

At Item Level

If the item is currently hidden, no action is taken.

Read here the official Oracle Documentation for APP_ITEM_PROPERTY.

Find this article useful? Subscribe here to stay updated on latest posts of OracleMine.com.

Leave a Reply

Your email address will not be published. Required fields are marked *