Tuesday, 1 March 2016

custom procedure to submit concurrent program from backend



CREATE OR REPLACE PROCEDURE APPS.xxsubmit_xml_cp_4m_bkend (
   v_template_appl_name    VARCHAR2,
   v_template_code         VARCHAR2,
   v_template_language     VARCHAR2,
   v_template_territory    VARCHAR2,
   v_output_format         VARCHAR2,
   v_application           VARCHAR2,
   v_program               VARCHAR2,
   v_description           VARCHAR2,
   v_start_time            VARCHAR2,
   v_sub_request           BOOLEAN := FALSE,
   v_argument1             VARCHAR2 DEFAULT CHR (0),
   v_argument2             VARCHAR2 DEFAULT CHR (0),
   v_argument3             VARCHAR2 DEFAULT CHR (0),
   v_argument4             VARCHAR2 DEFAULT CHR (0),
   v_argument5             VARCHAR2 DEFAULT CHR (0))
IS
   V_RETURN    BOOLEAN;
   V_REQUEST   NUMBER;
BEGIN
   fnd_global.apps_initialize (user_id        => 2836,
                               resp_id        => 20434,
                               resp_appl_id   => 101); --mpf santosh userid,responcibility,application detail
   V_RETURN :=
      fnd_request.add_layout (template_appl_name   => v_template_appl_name,
                              template_code        => v_template_code,
                              template_language    => v_template_language,
                              template_territory   => v_template_territory,
                              output_format        => v_output_format);
   V_REQUEST :=
      fnd_request.submit_request (application   => v_application,
                                  program       => v_program,
                                  description   => v_description,
                                  start_time    => v_start_time,
                                  sub_request   => v_sub_request,
                                  argument1     => v_argument1,
                                  argument2     => v_argument2,
                                  argument3     => v_argument3,
                                  argument4     => v_argument4,
                                  argument5     => v_argument5);
   DBMS_OUTPUT.PUT_LINE ('Request Number' || V_REQUEST);
END;

/

No comments:

Post a Comment