PL/SQL Script to Create a Concurrent Program Parameter from backend

We need to use FND_PROGRAM.PARAMETER api to create an concurrent program parameter from backend database, below is the sample script.

Creating the Concurrent Program Parameter from backend:

/****************************************************************
*PURPOSE: To Create a Concurrent Program Parameter from backend *
*AUTHOR: Shailender Thallam                                     *
*****************************************************************/
--
DECLARE
  --
  l_program_short_name      VARCHAR2 (200);
  l_application             VARCHAR2 (200);
  l_sequence                NUMBER;
  l_parameter               VARCHAR2 (200);
  l_description             VARCHAR2 (200);
  l_enabled                 VARCHAR2 (200);
  l_value_set               VARCHAR2 (200);
  l_default_type            VARCHAR2 (200);
  l_default_value           VARCHAR2 (200);
  l_required                VARCHAR2 (200);
  l_enable_security         VARCHAR2 (200);
  l_range                   VARCHAR2 (200);
  l_display                 VARCHAR2 (200);
  l_display_size            NUMBER;
  l_description_size        NUMBER;
  l_concatenated_descr_size NUMBER;
  l_prompt                  VARCHAR2 (200);
  l_token                   VARCHAR2 (200);
  l_cd_parameter            VARCHAR2 (200);
  l_check                   VARCHAR2 (2);
  --
BEGIN
  --
  l_program_short_name      := 'XX_ORACLEAPPSDNA_CP';
  l_application             := 'CUSTOM Custom';
  l_sequence                := 10;
  l_parameter               := 'Employee Name';
  l_description             := 'Employee Name';
  l_enabled                 := 'Y';
  l_value_set               := '240 Characters';
  l_default_type            := NULL;
  l_default_value           := NULL;
  l_required                := 'N';
  l_enable_security         := 'N';
  l_range                   := NULL;
  l_display                 := 'Y';
  l_display_size            := 50;
  l_description_size        := 50;
  l_concatenated_descr_size := 50;
  l_prompt                  := 'Employee Name';
  l_token                   := NULL;
  l_cd_parameter            := NULL;
  --
  --Calling API to create a Parameter for a concurrent program definition
  --
   apps.fnd_program.parameter
           (program_short_name                 => l_program_short_name,
            application                        => l_application,
            SEQUENCE                           => l_sequence,
            parameter                          => l_parameter,
            description                        => l_description,
            enabled                            => l_enabled,
            value_set                          => l_value_set,
            default_type                       => l_default_type,
            DEFAULT_VALUE                      => l_default_value,
            required                           => l_required,
            enable_security                    => l_enable_security,
            RANGE                              => l_range,
            display                            => l_display,
            display_size                       => l_display_size,
            description_size                   => l_description_size,
            concatenated_description_size      => l_concatenated_descr_size,
            prompt                             => l_prompt,
            token                              => l_token,
            cd_parameter                       => l_cd_parameter
           );  
  --
  COMMIT;
  --
  BEGIN
    --
    --To check whether a parameter is assigned to a Concurrent Program or not
    --
     SELECT 'Y'
       INTO l_check
       FROM fnd_descr_flex_column_usages
      WHERE descriptive_flexfield_name = '$SRS$.'
      || 'XX_ORACLEAPPSDNA_CP'
    AND end_user_column_name = 'Employee Name';
    --
    dbms_output.put_line ('Concurrent Program Parameter registered Successfully');
    --
  EXCEPTION
  WHEN no_data_found THEN
    dbms_output.put_line ('Concurrent Program Parameter Registration Failed');
  END;
  --
END;

View from front end application:

ConcurrentProgram_Paramter_from_Application

  1. The above script inserts data into FND_DESCR_FLEX_COL_USAGE_TL and FND_DESCR_FLEX_COLUMN_USAGES tables