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. |