g_sidhu

 Profile 

• Feb 14th, 2008

 

GET_LOV_PROPERTY: Returns information about a specified list of values (LOV). You must issue a call to the built-in once for each property value you want to retrieve.

/*
** Built-in: GET_LOV_PROPERTY **
Example: Can get the width/height of the LOV. */
DECLARE the_width NUMBER; the_height NUMBER; lov_id LOV;
BEGIN lov_id := Find_LOV('My_LOV_1');
the_width := Get_LOV_Property(lov_id, WIDTH);
the_height := Get_LOV_Property(lov_id,HEIGHT);
END;

SET_LOV_COLUMN_PROPERTY: Sets the given LOV property for the given LOV.

g_sidhu

 Profile 

• Feb 14th, 2008

 

/*
** 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;