Showing posts with label How to Rigister Concurrent program from Backend. Show all posts
Showing posts with label How to Rigister Concurrent program from Backend. Show all posts

Saturday, August 18, 2012

How to Rigister Concurrent program from Backend

--- Creating Excecutables
Begin
      FND_PROGRAM.EXECUTABLE
      (executable           => 'XXHFTUPGITEMLDR'
      ,application          => 'Harbor Freight Custom Application'
      ,short_name           => 'XXHFTUPGITEMLDR'
      ,description          => 'SQLLOADER Item Program from 11i to R12'
      ,execution_method     => 'SQL*Loader'
      ,execution_file_name  => 'XXHFTUPGITEMLDR'
      ,subroutine_name      => ''
      ,icon_name            => ''
      ,language_code        => 'US'
      ,execution_file_path  => '');
end;
---- Creating Concurrent Programs ----
Begin

 FND_PROGRAM.REGISTER
       (program                  => 'HFT Item Conversion loader'                ---  Concurrent Program Name
       ,application              => 'Harbor Freight Custom Application'       ---  Application Name
       ,enabled                  => 'Y'                                                           ---  Enabled Flag
       ,short_name               => 'XXHFTUPGITEMLDR'                      ---  Short Name of Conc Program
       ,description              => ''                                                             ---  Description
       ,executable_short_name    => 'XXHFTUPGITEMLDR'               ---  Executable of the Conc Program
       ,executable_application   => 'Harbor Freight Custom Application'       ---  Executable application
       ,execution_options        => ''
       ,priority                 => ''
       ,save_output              => 'Y'
       ,print                    => 'Y'
       ,cols                     => ''
       ,rows                     => ''
       ,style                    => ''
       ,style_required           => 'N'
       ,printer                  => ''
       ,request_type             => ''
       ,request_type_application => ''
       ,use_in_srs               => 'Y'
       ,allow_disabled_values    => 'N'
       ,run_alone                => 'N'
       ,output_type              => 'Text'                                    ----  Out put format
       ,enable_trace             => 'N'
       ,restart                  => 'Y'
       ,nls_compliant            => 'Y'
       ,icon_name                => ''
       ,language_code            => 'US'
       ,mls_function_short_name  => ''
       ,mls_function_application => ''
       ,incrementor              => '');
end;

How to add Parameters to Concurrent Program
 Begin
 fnd_program.parameter
 (program_short_name =>  'xxhftupgitemldr'                 ---  Short Name of Conc Program 
 ,application => 'harbor freight custom application'         ---  Application Name
 ,sequence => '1'                                                           ---  Sequnce Number
 ,parameter => 'path'                                                      ---  Parameter Name
 ,description => 'path of data file.'                                   ---  Paramter Description
 ,enabled => 'y'                                                              ---  Enabled Flag
 ,value_set => 'ar_varchar_150'                                      ---  Value Set Name
 ,default_type => ''
 ,default_value => ''
 ,required => 'y'                                                                 ---  Required flag ( Mandatory or not)
 ,enable_security => 'n'
 ,range => ''
 ,display => 'y'
 ,display_size => '15'
 ,description_size => '50'
 ,concatenated_description_size=> '25'
 ,prompt => 'path '
 ,token => '');
end;

How to add Concurrent program to request group
Begin
 FND_PROGRAM.ADD_TO_GROUP
           (program_short_name  => 'XXHFTUPGITEMLDR'                 ---  Short Name of Conc Program 
           ,program_application =>  'Harbor Freight Custom Application'   ---  Application Name
           ,request_group       => 'All Inclusive GUI'                                   ---  Request group name
           ,group_application   => 'Inventory');                                         ---  Requst group Application Name
end;

How to delete Concurrent program & Executable
 IF (FND_PROGRAM.PROGRAM_EXISTS
             (program                  => 'XXHFTUPGITEMLDR'
             ,application              => 'Harbor Freight Custom Application'))
         THEN
              FND_PROGRAM.DELETE_PROGRAM('XXHFTUPGITEMLDR', 'HFT'); 
                                                                   ---  Short Name of Conc Program  , ---  Application Name
              FND_PROGRAM.DELETE_EXECUTABLE('XXHFTITEMLDR', 'HFT');   
                                                       ----  Short Name of Excutable Program  , ---  Application Name
   END IF;