APPS how to create PL/SQL concurrent program executable

APPS how to create PL/SQL concurrent program executable

First create pl/sql package.procedure we'll call it apps_plsql.demo:

NOTE:
   errbuf and retcode are required parameters that will be passed from/to
   concurrent manager - you must have them.

- - - - - - - - - - - - - - CUT - - - - - - - - - - - - -

CREATE OR REPLACE PACKAGE apps_plsql AS

procedure demo(errbuf out NOCOPY varchar2,
               retcode out NOCOPY varchar2);

END apps_plsql;
/


CREATE OR REPLACE PACKAGE BODY apps_plsql AS

procedure demo(errbuf out NOCOPY varchar2,
               retcode out NOCOPY varchar2)
is
begin
   --
   -- If you want to write some output call:
   --
   FND_FILE.put_line(FND_FILE.output,'Starting processing:');
   --
   -- NOTE:
   --    to write to log use FND_FILE.log instead of FND_FILE.output
   --

   -- <your code here>

   FND_FILE.put_line(FND_FILE.output,'Done!');

   commit;

   -- Return 0 for successful completion.
   errbuf := '';
   retcode := '0';

exception
   when others then
      errbuf := sqlerrm;
      retcode := '2';
end demo;

END apps_plsql;
/

- - - - - - - - - - - - - - CUT - - - - - - - - - - - - -

Next we register this package with APPS:

Login to SYSADMIN, then

1. Define Executable
=====================
NAVIGATE:
Concurrent ->
   Program ->
      Executable:

   Executable: apps_plsql_demo
   Short name: apps_plsql_demo
  Application: Application Object Library
  Description: Demonstration of APPS pl/sql concurrent program
   Exe Method: PL/SQL Procedure
Exe File Name: apps_plsql.demo


2. Define Program
==================
NAVIGATE:
Concurrent ->
  Program ->
     Define:

    Program: Demonstration of APPS pl/sql concurrent program
 Short Name: PACKAGE_PROCEDURE
Application: Application Object Library

   Executable: apps_plsql_demo


3. Add Program to the SYSADMIN Responsibility REPORT Group
===========================================================
NAVIGATE:
Security ->
   Responsibility ->
      Requests

Query for "System Administrator Reports" Group

In the Requests detail-form add the following row:

   Type: Program
   Name: Demonstration of APPS pl/sql concurrent program

You can now run this pl/sql package.procedure through APPS Concurrent Manager.