FND_REQUEST_SET_PROGRAMS

FND_REQUEST_SET_PROGRAMS stores information about reports within report sets. Each row includes the report set program identifier, the order the report is run within the report set, the report set itself, values identifying the report and application, and the printer the report goes to. Each row also includes the print style to print the report, the number copies to print, and the date the report is last submitted. You need one row for each report within a report set.

Name Datatype Length Mandatory Comments
SET_APPLICATION_ID NUMBER (15) Yes Set application identifier
REQUEST_SET_ID NUMBER (15) Yes Request Set identifier
REQUEST_SET_STAGE_ID NUMBER (15) Yes Stage identifier for the request set
REQUEST_SET_PROGRAM_ID NUMBER (15) Yes FND_REQUEST_SET_PROGRAMS_S.NEXTVAL
SEQUENCE NUMBER (15) Yes The sequence of the report in the report set
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
PROGRAM_APPLICATION_ID NUMBER (15) Yes The application identifier of the report in the report set
CONCURRENT_PROGRAM_ID NUMBER (15) Yes ID of program for incompatibilities
NLS_LANGUAGE VARCHAR2 (30)
Language
NLS_TERRITORY VARCHAR2 (30)
The territory using the language
CRITICAL VARCHAR2 (1) Yes Is this a critical stage
NUMBER_OF_COPIES NUMBER (15)
The number of copies to print for the report output
PRINTER VARCHAR2 (30)
Printer assinged to the set
PRINT_STYLE VARCHAR2 (30)
Print style assinged to the set
SAVE_OUTPUT_FLAG VARCHAR2 (1)
Flag to indicate whether to save the report output or not

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;