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

GET_GROUP_NUMBER_CELL Built-in

Description

Returns the NUMBER value for a record group cell identified by the given row and column. A cell is an intersection of a row and column.

Syntax

FUNCTION GET_GROUP_NUMBER_CELL
(groupcolumn_id GroupColumn,
row_number
NUMBER);

FUNCTION GET_GROUP_NUMBER_CELL
(groupcolumn_name VARCHAR2,
row_number
NUMBER);

Built-in Type unrestricted function

Returns NUMBER

Enter Query Mode yes

Parameters

groupcolumn_id 
 
Specifies the unique ID that Oracle Forms assigns when it creates the record group column. 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 
 
Specifies the fully qualified VARCHAR2 record group column name you gave the column when you defined it, preceded by the record group name and a dot, as in recordgroup_name.groupcolumn_name. If the column was defined as a result of a query, its name is the same as its corresponding database column.
 
row_number 
 
Specifies the row from which to retrieve the value of the cell.

GET_GROUP_NUMBER_CELL Restrictions

The row_number specified must be within the bounds implied by the number of rows in the record group. A non-existent row_number results in an index out of bounds error.

GET_GROUP_NUMBER_CELL Examples

/*

** Built-in: GET_GROUP_NUMBER_CELL
** Example: Lookup a row in a record group, and return the
** minimum order quantity associated with that row
** in the record group. Uses the
** 'is_value_in_list' function from the
** GET_GROUP_CHAR_CELL example.
*/
FUNCTION Min_Order_Qty_Of( part_no VARCHAR2 )
RETURN NUMBER 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 NULL;
ELSE
/*
** Get the corresponding Number cell value from the
** matching row.
*/
RETURN Get_Group_Number_Cell( 'TMPPART.MINQTY', fnd_row );
END IF;
END;