Loading

Thursday, May 5, 2011

FND_PROGRAM : Register Concurrent Program via API


Test Instance: R12.1.1
Script:
/* Formatted on 2011/05/05 11:38 (Formatter Plus v4.8.5) */
DECLARE
   v_program                    VARCHAR2 (200);
   v_application                VARCHAR2 (200);
   v_enabled                    VARCHAR2 (200);
   v_short_name                 VARCHAR2 (200);
   v_description                VARCHAR2 (200);
   v_executable_short_name      VARCHAR2 (200);
   v_executable_application     VARCHAR2 (200);
   v_execution_options          VARCHAR2 (200);
   v_priority                   NUMBER;
   v_save_output                VARCHAR2 (200);
   v_print                      VARCHAR2 (200);
   v_cols                       NUMBER;
   v_rows                       NUMBER;
   v_style                      VARCHAR2 (200);
   v_style_required             VARCHAR2 (200);
   v_printer                    VARCHAR2 (200);
   v_request_type               VARCHAR2 (200);
   v_request_type_application   VARCHAR2 (200);
   v_use_in_srs                 VARCHAR2 (200);
   v_allow_disabled_values      VARCHAR2 (200);
   v_run_alone                  VARCHAR2 (200);
   v_output_type                VARCHAR2 (200);
   v_enable_trace               VARCHAR2 (200);
   v_restart                    VARCHAR2 (200);
   v_nls_compliant              VARCHAR2 (200);
   v_icon_name                  VARCHAR2 (200);
   v_language_code              VARCHAR2 (200);
   v_mls_function_short_name    VARCHAR2 (200);
   v_mls_function_application   VARCHAR2 (200);
   v_incrementor                VARCHAR2 (200);
   v_refresh_portlet            VARCHAR2 (200);
   v_check                      VARCHAR2 (2);
BEGIN
   v_program                  := 'Concurrent program for testing SHAREORACLEAPPS';
   v_application              := 'Payables';
   v_enabled                  := 'Y';
   v_short_name               := 'XX_SHAREORACLEAPPS';
   v_description              := 'Shareoracleapps Test Program';
   v_executable_short_name    := 'XX_SHAREORACLEAPPS';
   v_executable_application   := 'Msisol Payables';
   v_execution_options        := NULL;
   v_priority                 := NULL;
   v_save_output              := 'Y';
   v_print                    := 'Y';
   v_cols                     := NULL;
   v_rows                     := NULL;
   v_style                    := NULL;
   v_style_required           := 'N';
   v_printer                  := NULL;
   v_request_type             := NULL;
   v_request_type_application := NULL;
   v_use_in_srs               := 'Y';
   v_allow_disabled_values    := 'N';
   v_run_alone                := 'N';
   v_output_type              := 'TEXT';
   v_enable_trace             := 'N';
   v_restart                    := 'Y';
   v_nls_compliant            := 'Y';
   v_icon_name                := NULL;
   v_language_code            := 'US';
   v_mls_function_short_name  := NULL;
   v_mls_function_application := NULL;
   v_incrementor              := NULL;
   v_refresh_portlet          := NULL;
   apps.fnd_program.REGISTER
        (program                       => v_program,
         application                   => v_application,
         enabled                       => v_enabled,
         short_name                    => v_short_name,
         description                   => v_description,
         executable_short_name         => v_executable_short_name,
         executable_application        => v_executable_application,
         execution_options             => v_execution_options,
         priority                      => v_priority,
         save_output                   => v_save_output,
         PRINT                         => v_print,
         cols                          => v_cols,
         ROWS                          => v_rows,
         style                         => v_style,
         style_required                => v_style_required,
         printer                       => v_printer,
         request_type                  => v_request_type,
         request_type_application      => v_request_type_application,
         use_in_srs                    => v_use_in_srs,
         allow_disabled_values         => v_allow_disabled_values,
         run_alone                     => v_run_alone,
         output_type                   => v_output_type,
         enable_trace                  => v_enable_trace,
         restart                       => v_restart,
         nls_compliant                 => v_nls_compliant,
         icon_name                     => v_icon_name,
         language_code                 => v_language_code,
         mls_function_short_name       => v_mls_function_short_name,
         mls_function_application      => v_mls_function_application,
         incrementor                   => v_incrementor,
         refresh_portlet               => v_refresh_portlet
         );
  
   COMMIT;
   BEGIN
      SELECT 'Y'
        INTO v_check
        FROM fnd_concurrent_programs
       WHERE concurrent_program_name = 'XX_SHAREORACLEAPPS';
   EXCEPTION
      WHEN NO_DATA_FOUND
      THEN
         DBMS_OUTPUT.put_line ('Concurrent Program Registration Failed');
   END;
END;

1 Responses to “FND_PROGRAM : Register Concurrent Program via API”

Roopesh Ranchod said...
July 3, 2014 at 3:54 AM

Do you have one that registers it with parameters (value sets and default values etc)


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.