Loading

Thursday, May 5, 2011

FND_PROGRAM : Add Concurrent Program to Request Group via API


Test Instance: R12.1.1
Script:
/* Formatted on 2011/05/05 12:38 (Formatter Plus v4.8.5) */
DECLARE
   v_program_short_name    VARCHAR2 (200);
   v_program_application   VARCHAR2 (200);
   v_request_group         VARCHAR2 (200);
   v_group_application     VARCHAR2 (200);
   v_check                 VARCHAR2 (2);
BEGIN
   v_program_short_name  := 'XX_SHAREORACLEAPPS';
   v_program_application := 'Payables';
   v_request_group       := 'All Reports';
   v_group_application   := 'Assets';
   apps.fnd_program.add_to_group (program_short_name  => v_program_short_name,
                                  program_application => v_program_application,
                                  request_group       => v_request_group,
                                  group_application   => v_group_application
                                 );
  COMMIT;
  BEGIN
  SELECT 'Y'
  INTO   v_check
  FROM   FND_REQUEST_GROUPS FRG,
         FND_REQUEST_GROUP_UNITS FRGU,
           FND_CONCURRENT_PROGRAMS FCP
  WHERE  FRG.request_group_id       = FRGU.REQUEST_GROUP_ID
  AND    FRG.application_id         = FRGU.application_id
  AND    FRGU.request_unit_id       = FCP.concurrent_program_ID
  AND    FRGU.unit_application_id   = FCP.application_id      
  AND    FCP.concurrent_program_name = 'XX_SHAREORACLEAPPS';
  EXCEPTION
      WHEN NO_DATA_FOUND
      THEN
         DBMS_OUTPUT.put_line ('Adding Concurrent Program to Request Group Failed');
  END;

END;



0 Responses to “FND_PROGRAM : Add Concurrent Program to Request Group via API”

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.