Learn Oracle Database and Applications Here

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:

app_item_property.set_property(itemid, REQUIRED, PROPERTY_ON);

is equivalent to:

set_item_property(itemid, REQUIRED, PROPERTY_ON);

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.

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.

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.

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.

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.

Thanks for stopping by at OracleMine.com. Speaking about my brief introduction, I work for a multinational organisation in Oracle related technologies. Being an avid blogger, I would like to inform you about my productivity and motivational blog XpressPlanet.com. Speaking of OracleMine.com, I will try my best to share knowledge on technologies in as simple and understandable manner as possible. You can also contribute your knowledge on OracleMine by writing to us at hioraclemine@gmail.com. Again I appreciate your visit. Hope to see you again and again!