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;