Procurement - EBS (MOSC)

MOSC Banner

how to insert/update allow for the current record when check the check box in custom forms?

edited Mar 3, 2023 12:51PM in Procurement - EBS (MOSC) 6 commentsAnswered

Hi All,

how to insert_allowed/update_allowed the current record when check the check box in custom forms?

In my custom form I am using below query on the 'WHEN-CHECKBOX-CHANGED' trigger in the check box item.

if 'block.item'='Y' then

SET_ITEM_PROPERTY('block.item1', insert_allowed, property_false);

SET_ITEM_PROPERTY('block.item1', update_allowed, property_false);

elsif 'block.item'='N' then

SET_ITEM_PROPERTY('block.item1', insert_allowed, property_true);

SET_ITEM_PROPERTY('block.item1', update_allowed, property_true);

end if;

Its fired but the above query worked for all rows. i need work for current record or selected record in the block.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center