Header Ads

ad728
  • Breaking News

    Adding Report to Request Group using API



    /**********************************************************************
    *PURPOSE: To Add a Concurrent Program to a Request Group from backend *                                 
    **********************************************************************/
    --

    DECLARE
        l_program_short_name    VARCHAR2 (200);
        l_program_application   VARCHAR2 (200);
        l_request_group         VARCHAR2 (200);
        l_group_application     VARCHAR2 (200);
        l_check                 VARCHAR2 (2);
    --
    BEGIN
        --
        l_program_short_name := 'XXINVNLCDNT';
        l_program_application := 'Inventory';
        l_request_group := 'OM Concurrent Programs';
        l_group_application := 'Order Management';
        --
        --Calling API to assign concurrent program to a reqest group
        --
        apps.fnd_program.add_to_group (
            program_short_name    => l_program_short_name,
            program_application   => l_program_application,
            request_group         => l_request_group,
            group_application     => l_group_application);
        --
        COMMIT;

        --
        BEGIN
            --
            --To check whether a paramter is assigned to a Concurrent Program or not
            --
            SELECT 'Y'
              INTO l_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 = 'XXINVNLCDNT';

            --
            DBMS_OUTPUT.put_line (
                'Adding Concurrent Program to Request Group Succeeded');
        --
        EXCEPTION
            WHEN NO_DATA_FOUND
            THEN
                DBMS_OUTPUT.put_line (
                    'Adding Concurrent Program to Request Group Failed');
        END;
    END;

    No comments

    Note: Only a member of this blog may post a comment.