A script-enabled browser is required for this page to function properly.

SET_GROUP_DATE_CELL Built-in

Description

Sets the value for the record group cell identified by the given row and column.

Syntax

SET_GROUP_DATE_CELL
(groupcolumn_id GroupColumn,
row_number
NUMBER,
cell_value
DATE);

SET_GROUP_DATE_CELL
(groupcolumn_name VARCHAR2,
row_number
NUMBER,
cell_value
DATE);

Built-in Type unrestricted procedure

Enter Query Mode yes

Parameters

groupcolumn_id 
 
The unique ID that Oracle Forms assigns when it creates the column for the record group. Use the FIND_COLUMN Built-in to return the ID to an appropriately typed variable. The data type of the ID is GroupColumn.
 
groupcolumn_name 
 
The name you gave to the column when you created it, preceded by the record group name and a dot, as in recordgroup_name.groupcolumn_name. The data type of the name is VARCHAR2.
 
row_number 
 
Specifies the row number that contains the cell whose value you intend to set. Specify as a whole NUMBER.
 
cell_value 
 
Specifies the DATE value you intend to enter into a cell.

SET_GROUP_DATE_CELL Restrictions

SET_GROUP_DATE_CELL Examples

/*

** Built-in: SET_GROUP_DATE_CELL
** Example: Lookup a row in a record group, and set the
** minimum order date associated with that row in
** the record group. Uses the 'is_value_in_list'
** function from the GET_GROUP_CHAR_CELL example.
*/
PROCEDURE Set_Max_Order_Date_Of( part_no VARCHAR2,
new_date DATE ) IS
fnd_row NUMBER;
BEGIN
/*
** Try to lookup the part number among the temporary part list
** record group named 'TMPPART' in its 'PARTNO' column.
*/
fnd_row := Is_Value_In_List( part_no, 'TMPPART', 'PARTNO');

IF fnd_row = 0 THEN
Message('Part Number '||part_no||' not found.');
RETURN;
ELSE
/*
** Set the corresponding Date cell value from the
** matching row.
*/
Set_Group_Date_Cell('TMPPART.MAXORDDATE',fnd_row,new_date );
END IF;
END;