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;

No comments:

Post a Comment