Friday, August 31, 2012

Adding concurrent program to a request group


Adding conc prog to a 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  := 'XXZP_INVOICE_SO_CREATION';
   v_program_application := 'XXZP project accouting';
   v_request_group       := 'OM Concurrent Programs';
   v_group_application   := 'Order Management';
   apps.fnd_program.add_group (program_short_name  => v_program_short_name,
                                  program_application => v_program_application,
                                  request_group       => v_request_group,
                                  group_application   => v_group_application
                                 );
  COMMIT;