Wednesday, July 18, 2012

Add Concurrent program to request set from backend

FND_PROGRAM.ADD_TO_GROUP: The procedure is used to add a concurrent program to a request group. This procedure corresponds to the "Requests" region in the "Request Groups" window in System Administration.


Syntax:
procedure FND_PROGRAM.ADD_TO_GROUP
(program_short_name IN VARCHAR2,
program_application IN VARCHAR2,
request_group IN VARCHAR2,
group_application IN VARCHAR2);


Arguments (input):
program_short_ name The short name used as the developer name of the
concurrent program.

program_ application The application that owns the concurrent program.

request_group The request group to which to add the concurrent program.

group_ application The application that owns the request group.

DECLARE
   v_program_short_name    VARCHAR2 (200);
   v_program_application   VARCHAR2 (200);
   v_request_group         VARCHAR2 (200);
   v_group_application     VARCHAR2 (200);
   v_check                 VARCHAR2 (2);
BEGIN
   v_program_short_name := 'MRK_OM_INV_CRT';
   v_program_application := 'Order Management';
   v_request_group := 'Concurrent Programs';
   v_group_application := 'Order Management';

   apps.fnd_program.add_to_group (
      program_short_name    => v_program_short_name,
      program_application   => v_program_application,
      request_group         => v_request_group,
      group_application     => v_group_application);

COMMIT;

END;