Sets the given LOV property for the given LOV.
SET_LOV_PROPERTY
(lov_id LOV,
property NUMBER,
value NUMBER);
SET_LOV_PROPERTY
(lov_name VARCHAR2,
property NUMBER,
value NUMBER);
SET_LOV_PROPERTY
(lov_id LOV,
property NUMBER,
x NUMBER,
y NUMBER);
SET_LOV_PROPERTY
(lov_name VARCHAR2,
property NUMBER,
x NUMBER,
y NUMBER);
Built-in Type unrestricted procedure
Enter Query Mode yes
AUTO_REFRESH Specifies whether Oracle Forms re-executes the query each time the LOV is invoked.
GROUP_NAME Specifies the record group with which the LOV is associated.
LOV_SIZE Specifies a width, height pair indicating the size of the LOV.
POSITION Specifies an x, y pair indicating the position of the LOV.
TITLE Specifies the title of the LOV. Overrides the value specified in Oracle Forms unless the property value is NULL.
PROPERTY_TRUE Specifies that the property is to be set to the TRUE state.
PROPERTY_FALSE Specifies that the property is to be set to the FALSE state.
/*
** Built-in: SET_LOV_PROPERTY
** Example: if LOV is currently base on GROUP1,
** make LOV use GROUP2
*/
DECLARE
lov_id LOV;
BEGIN
lov_id := Find_LOV('My_LOV_1');
IF Get_LOV_Property(lov_id,GROUP_NAME) = 'GROUP1' THEN
Set_LOV_Property(lov_id,GROUP_NAME,'GROUP2');
ENDIF;
END;