APP_FIND: Query-Find Utilities
APP_FIND: Query-FindUtilitiesUse the following routines toimplement the Find Window functionality.
Related Essays: Query Find Windows (See page )
Summary
procedure APP_FIND.NEW(
block_name varchar2);Description
This routine is called by the "New" button in a Find Window toreturn the user to a new record in the block on which the find isbased.
Arguments (input)
block_name The name of the block the Find Windowis based onSummary
procedure APP_FIND.CLEAR;
Description
This routine is called by the "Clear" button in a Find Window toclear the Find Window.
Summary
procedure APP_FIND.CLEAR_DETAIL(
detail_block varchar2);Description
This routine clears the result block of a find block(not a Find window). This action can only be performed fromtriggers that allow navigation.
Arguments (input)
detail_block The name of the block to be clearedExample
APP_FIND.CLEAR_DETAIL('MYBLOCK');
Summary
procedure APP_FIND.FIND(
block_name varchar2);Description
This r outine is called by the "Find" button in a Find Window toexecute the Find.
Arguments (input)
block_name The name of the block the Find Windowis based onSummary
procedure APP_FIND.QUERY_RANGE(
low_value varchar2/date/number,high_value varchar2/date/number,
db_item_name varchar2);
Description
This utility constructs the query criteria for ranges in a FindWindow. Depending on the datatype of the low and high value, itcreates a range of characters, dates, or numbers.
Arguments (input)
low_value The low value of the rangehigh_value The high value of the rangedb_item_name The name of the item in the blockthat is being queriedSummary
procedure APP_FIND.QUERY_FIND(
lov_name varchar2);procedure APP_FIND.QUERY_FIND(
block_window varchar2,
find_window varchar2,
find_block varchar2);
Description
These routines invoke either the Row-LOV or the Find Window.Call them from a user-named trigger "QUERY_FIND."
Arguments (input)
lov_name The name of the Row-LOVblock_window The name of the window the FindWindow is invoked for find_window The name of theFind Window find_block The name of the block inthe Find Window