Monday, 2 December 2019

Create Parameters To The Concurrent Program From Backend in oracle apps Or How to add a parameter in oracle custom report in oracle Apps EBS

-- Define Concurrent Parameters:
--  The parameters are the placeholders for the input values to a concurrent program.
--  If the execution method of a concurrent program is Oracle Reports then each parameter is linked to the actual report parameter via the "Token" field in the parameters window
--  For PL/SQL stored procedures these parameters are passed to the program by position.


/*=============================================
CREATE PARAMETERS TO THE CONCURRENT PROGRAM FROM BACKEND
==============================================*/
DECLARE
   v_cprogram   VARCHAR2 (50) := 'XX_APPS88_HRMS';
BEGIN
   fnd_global.apps_initialize (user_id           => 1318,
                               resp_id           => 21623,
                               resp_appl_id      => 660
                              );
   fnd_program.parameter (program_short_name                 => v_cprogram,
                          application                        => 'Human Resources',
                          SEQUENCE                           => 10,
                          parameter                          => 'Employee Number',
                          enabled                            => 'Y',
                          value_set                          => '240 char',
                          display_size                       => 50,
                          description_size                   => 20,
                          concatenated_description_size      => 20,
                          prompt                             => 'P_EMPLOYEE_NUM',
                          token                              => 'P_EMPLOYEE_NUM'
                         );
   COMMIT;
   DBMS_OUTPUT.put_line (' successfully created parameter for concurrent program ' || v_cprogram );
EXCEPTION
   WHEN OTHERS
        THEN DBMS_OUTPUT.put_line ('error out here' || SQLCODE || SQLERRM);
END;

No comments:

Post a Comment

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)

When attempting to apply for a job in iRecruitment, the following error occurs: ERROR: You must enter an Application Number. Solution: How t...