FND_CONCURRENT_PROGRAMS

FND_CONCURRENT_PROGRAMS stores information about concurrent programs. Each row includes a name and description of the concurrent program. Each row also includes the execution methods for the program (EXECUTION_METHOD_CODE), the argument method (ARGUMENT_METHOD_CODE), and whether the program is constrained (QUEUE_METHOD_CODE). If the program is a special concurrent program that controls the concurrent managers, QUEUE_CONTROL_FLAG is set to Y. Each row also includes flags that indicate whether the program is enabled and defined as run-alone, as well as values that specify the print style the concurrent manager should use to print program output, if any. There are also values that identify the executable associated with the concurrent program and the application with which the executable is defined, and flags that specify whether the concurrent program is a parent of a report set, whether to save the output file, and whether a print style is required. Information such as printer name and number of rows and columns on each page of the output file for the concurrent program is also included in the table. You need one row for each concurrent program in each application. Oracle Application Object Library uses this information to run concurrent programs.

Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Application identifier
CONCURRENT_PROGRAM_ID NUMBER (15) Yes Concurrent program identifier
CONCURRENT_PROGRAM_NAME VARCHAR2 (30) Yes Internal name of the concurrent program
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
EXECUTABLE_APPLICATION_ID NUMBER (15) Yes Identifier of the application with which the executable is registered
EXECUTABLE_ID NUMBER (15) Yes Concurrent program executable identifier
EXECUTION_METHOD_CODE VARCHAR2 (1) Yes Execution method for the concurrent program
ARGUMENT_METHOD_CODE VARCHAR2 (1) Yes Code to indicate how program arguments are passed to the concurrent program
QUEUE_CONTROL_FLAG VARCHAR2 (1) Yes Flag to indicate if the concurrent program controls concurrent managers
QUEUE_METHOD_CODE VARCHAR2 (1) Yes Code to indicate whether the concurrent program is constrained
REQUEST_SET_FLAG VARCHAR2 (1) Yes Flag to indicate whether the concurrent program is a parent of a report set
ENABLED_FLAG VARCHAR2 (1) Yes Enabled flag
PRINT_FLAG VARCHAR2 (1) Yes Flag to indicate whether the concurrent manager should print output of the concurrent program
RUN_ALONE_FLAG VARCHAR2 (1) Yes Flag to indicate if this is a run alone concurrent program
SRS_FLAG VARCHAR2 (1) Yes Flag to indicate if a request can be submitted for this concurrent program from Standard Report Submission
CLASS_APPLICATION_ID NUMBER (15)
Identifier of application for with which the request type of this program is identified
CONCURRENT_CLASS_ID NUMBER (15)
Request type identifier
EXECUTION_OPTIONS VARCHAR2 (250)
SQL*Report or Oracle Report program running options
SAVE_OUTPUT_FLAG VARCHAR2 (1)
Flag to indicate whether to save output file for the concurrent program
REQUIRED_STYLE VARCHAR2 (1) Yes Flag to indicate if the print style associated with the concurrent program is mandatory
OUTPUT_PRINT_STYLE VARCHAR2 (30)
The print style for the concurrent program output
PRINTER_NAME VARCHAR2 (30)
Name of printer for printing the concurrent program output
MINIMUM_WIDTH NUMBER (4)
Minimum number of columns
MINIMUM_LENGTH NUMBER (4)
Minimum number of rows
REQUEST_PRIORITY NUMBER (15)
Program level priority assigned by the System Administrator to guarantee that programs run at the same level regardless of who submits them (REQUEST_PRIORITY assigned to concurrent programs overrides the user profile value)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
IPROG_ID NUMBER (4)
Conflict resolution manager internal information
OUTPUT_FILE_TYPE VARCHAR2 (4)
Format of output file
ENABLE_TRACE VARCHAR2 (1) Yes Turns on tracing for requests
RESTART VARCHAR2 (1) Yes Indicates program may be re-started
NLS_COMPLIANT VARCHAR2 (1) Yes Indicates if the program is NLS compliant. In particular, indicates if the program accepts date and number parameters in canonical format
ICON_NAME VARCHAR2 (30)
Reserved for future use
CD_PARAMETER VARCHAR2 (240)
Parameter used to identify conflict domains
INCREMENT_PROC VARCHAR2 (61)
Procedure name used to increment program parameters
MLS_EXECUTABLE_APP_ID NUMBER (15)
Application identifier for MLS language function
MLS_EXECUTABLE_ID NUMBER (15)
Identifier for MLS language function
ENABLE_TIME_STATISTICS VARCHAR2 (1) Yes Y or N. Timed statistics collection is turned on for the program's session when set to Y
SECURITY_GROUP_ID NUMBER

Security group identifier
STAT_COLLECT VARCHAR2 (1)
Reserved for future use
RESOURCE_CONSUMER_GROUP VARCHAR2 (30)
Resource consumer group
ROLLBACK_SEGMENT VARCHAR2 (30)
Rollback segment for a transaction
OPTIMIZER_MODE VARCHAR2 (30)
Optimization mode, such as RULE, FIRST_ROW, etc.
INSTANCE_ID NUMBER (15)
OPS Instance number
REFRESH_PORTLET VARCHAR2 (1)
refresh portlet based on program outcome. Possible values 'N'ever/'S'uccess/'A'lways/'W'arning.(lookup type CONC_REFRESH_PORTLET)
PROGRAM_TYPE VARCHAR2 (1)
Concurrent Program Type. Possible values( 'O'(ther), 'P'(urge) ) Lookup type CONC_PROGRAM_TYPE
ACTIVITY_SUMMARIZER VARCHAR2 (51)
PLSQL procedure that developers can register to provide summary information what the programcan do.
REQUEST_SCH_INTERVAL NUMBER

Oracle suggested request schedule repeat interval value in days

Usage:


  cursor cur_concurrent(c_name   in dba_objects.object_name%type := '%'
                      , n_appid  in number) is
  select c.concurrent_program_id   id
  ,      c.concurrent_program_name name
  from fnd_concurrent_programs c
  where c.application_id = n_appid
  and   c.concurrent_program_name like c_name ESCAPE '\'
  order by c.concurrent_program_name;

  cursor cur_concurrent(n_tabid in number
                      , n_appid in number) is
  select t.user_concurrent_program_name long_name
  ,      t.description
  ,      c.concurrent_program_name name
  ,      c.execution_method_code
  ,      c.argument_method_code
  ,      c.queue_control_flag
  ,      c.queue_method_code
  ,      c.request_set_flag
  ,      c.enabled_flag
  ,      c.print_flag
  ,      c.run_alone_flag
  ,      c.srs_flag
  ,      c.save_output_flag
  ,      c.required_style
  from fnd_concurrent_programs_tl t
  ,    fnd_concurrent_programs c
  where c.application_id = n_appid
  and   c.concurrent_program_id = n_tabid
  and c.concurrent_program_id = t.concurrent_program_id
  and c.application_id = t.application_id

FND_CONCURRENT_PROGRAMS_TL

FND_CONCURRENT_PROGRAMS_TL stores translated information about concurrent programs in each of the installed languages. Each row includes the language the row is translated to. Each row also includes identifiers which identify the concurrent program and the application the concurrent program is registered with, and the description and title of the concurrent program. You need one row for each concurrent program in each of the installed languages.

Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER
Yes Application identifier
CONCURRENT_PROGRAM_ID NUMBER
Yes Concurrent program identifier
LANGUAGE VARCHAR2 (4) Yes Language
USER_CONCURRENT_PROGRAM_NAME VARCHAR2 (240) Yes Concurrent program title
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
DESCRIPTION VARCHAR2 (240)
Description
SOURCE_LANG VARCHAR2 (4) Yes The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.