APP_FIND: Query-Find Utilities
Use the following routines to implement 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 to return the user to a new record in the block on which the find is based.
Arguments (input)
block_name The name of the block the Find Window is based on
Summary
procedure APP_FIND.CLEAR;
Description
This routine is called by the “Clear” button in a Find Window to clear 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 from triggers that allow navigation.
Arguments (input)
detail_block The name of the block to be cleared
Example
APP_FIND.CLEAR_DETAIL(‘MYBLOCK’);
Summary
procedure APP_FIND.FIND(
block_name varchar2);
Description
This routine is called by the “Find” button in a Find Window to execute the Find.
Arguments (input)
block_name The name of the block the Find Window is based on
Summary
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 Find Window. Depending on the datatype of the low and high value, it creates a range of characters, dates, or numbers.
Arguments (input)
low_value The low value of the range high_value The high value of the range db_item_name The name of the item in the block that is being queried
Summary
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-LOV block_window The name of the window the Find Window is invoked for find_window The name of the Find Window find_block The name of the block in the Find Window