FND_REQUEST_SET_PROGRAM_ARGS
FND_REQUEST_SET_PROGRAM_ARGS stores information about arguments in every report set defined with Oracle Application Object Library. Each row includes values that identify an application that owns the report set, a report set, a program or report belonging to the report set, and an application that owns the descriptive flexfield which is used for popping up the report argument window. Each row also includes the name of the descriptive flexfield, the argument for the program or report, the default value for the argument, the type of the default value, the shared parameter name for the argument used among the report, and flags to specify whether users can update or see the argument. Oracle Application Object Library uses this information to display each argument in the report argument window.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Application identifier |
REQUEST_SET_ID | NUMBER | (15) | Yes | Request Set identifier |
REQUEST_SET_PROGRAM_ID | NUMBER | (15) | Yes | Report set program identifier |
DESCRIPTIVE_FLEX_APPL_ID | NUMBER | (15) | Yes | Identifier of the application with which the descriptive flexfield is defined |
DESCRIPTIVE_FLEXFIELD_NAME | VARCHAR2 | (40) | Yes | Descriptive flexfield name |
APPLICATION_COLUMN_NAME | VARCHAR2 | (30) | Yes | Column name |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
DISPLAY_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether to display the argument |
INSERT_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether a value can be entered for the argument |
UPDATE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the argument can be updated |
DEFAULT_TYPE | VARCHAR2 | (1) | Type of default value | |
DEFAULT_VALUE | VARCHAR2 | (2000) | Default value | |
SHARED_PARAMETER_NAME | VARCHAR2 | (30) | Name of the shared parameter |
Usage:
cursor cur_args(n_progid in number
, n_appid in number) is
SELECT a.DESCRIPTIVE_FLEX_APPL_ID
, a.DESCRIPTIVE_FLEXFIELD_NAME
, a.APPLICATION_COLUMN_NAME
, a.DISPLAY_FLAG
, a.INSERT_FLAG
, a.UPDATE_FLAG
, a.DEFAULT_TYPE
, a.DEFAULT_VALUE
, a.SHARED_PARAMETER_NAME
FROM APPLSYS.FND_REQUEST_SET_PROGRAMS p
, APPLSYS.FND_REQUEST_SET_PROGRAM_ARGS a
where p.PROGRAM_APPLICATION_ID = n_appid
and p.CONCURRENT_PROGRAM_ID = n_progid
and a.APPLICATION_ID = p.SET_APPLICATION_ID
and a.REQUEST_SET_ID = p.REQUEST_SET_ID
and a.REQUEST_SET_PROGRAM_ID = p.REQUEST_SET_PROGRAM_ID
order by application_column_name;