Concurrent Program Execution Methods

• Oracle Reports – Used for the Oracle RDF reports.
• Host – Used for shell scripts, basically the language of the host operating system.
• PL/SQL Stored procedure – Used to run the stored procedure through oracle applications
• SQL*Loader – Used to run the sql loader programs
• SQL*Plus - Used to run the anonymous PL/SQL blocks. It will get executed in the same fashion as you are running on SQL Plus.
• Java Stored Procedure – The execution file is a Java stored procedure.
• Java Concurrent Program – Used for programs written in Java.
• Spawned – Used for c or pro*c Program. Mainly used by standard oracle interfaces.
• Perl Concurrent Program – Used for programs written in CGI Perl.
• Request Set Stage Function – PL/SQL stored function that can be used to calculate the completion statuses of request set stages.
• Immediate – Execution file is a program written to run as subroutine of the concurrent manager. 
• Multi-Language function – Execution file is an MLS function that supports running concurrent program in multiple languages.

Below Query will give you the Concurrent Program/Execution Method


select b.concurrent_program_name||' - '||a.user_concurrent_program_name, a.description,
decode(b.execution_method_code,
'P', 'Oracle Reports',
'E' ,'Perl Concurrent Program',
'Q' ,'SQL*Plus',
'L' ,'SQL*Loader',
'A' ,'Spawned',
'B' ,'Request Set Stage Function',
'I' ,'PL/SQL Stored Procedure',
'K' ,'Java Concurrent Program',
'J' ,'Java Stored Procedure',
'S' ,'Immediate',
'H' ,'Host'
) Execution_Method
 from fnd_concurrent_programs_tl a, fnd_concurrent_programs b where
a.concurrent_program_id = b.concurrent_program_id
and b.enabled_flag = 'Y';