How to set Item property in oracle forms builder?

You can easily set Item’s property of different items in form builder.

For restrict Insert/Update in item:

SET_ITEM_PROPERTY(‘TRANS_ID’,INSERT_ALLOWED,PROPERTY_FALSE);
SET_ITEM_PROPERTY(‘TRANS_ID’,UPDATE_ALLOWED,PROPERTY_FALSE);

For set required property No in item:

SET_ITEM_PROPERTY(‘TRANS_ID’,REQUIRED,PROPERTY_FALSE);

For set Enabled/Disabled item:

SET_ITEM_PROPERTY(‘TRANS_ID’,ENABLED,PROPERTY_FALSE);

For any color to Item:

Set_Item_Instance_Property( ‘TRANS_ID’, CURRENT_RECORD,VISUAL_ATTRIBUTE,’VISUAL_ATTRIBUTE_NAME’);