concurrent program in sysadmin using backend

select * from fnd_concurrent_programs_vl where user_concurrent_program_name like 'Receipt%Register%Report%'

select * from fnd_application where application_id = 20003

select * from fnd_application_vl where basepath like 'XX%'

select * from fnd_application_vl where basepath like 'Re%'

select * from FND_REQUEST_GROUPs where application_id = 275

select * from fnd_responsibility_vl where responsibility_name like 'NSORO_Project IT Supreme User%'

select * from fnd_request_groups where request_group_id =263

select * from fnd_menus_vl where menu_id = 68262





Declare

BEGIN

 -- Arguments
--   program_short_name  - Short name of the program. (e.g. FNDSCRMT)
--   program_application - Application of the program.
--                         (e.g. 'Application Object Library')
--   request_group       - Name of request group.
--   group_application   - Application of the request group.
--

 /*PROCEDURE add_to_group(program_short_name            IN VARCHAR2,
                         program_application         IN VARCHAR2,
                        request_group                 IN VARCHAR2,
                          group_application             IN VARCHAR2) */
                         
  fnd_program.add_to_group ('MAS_NS_REFRESH_PSI_MV' -- Concurrent Program Short Name
                            ,'NSORO Custom Application'                 -- Application Name
                           ,'All Project Billing Programs'                -- Request Group Name
                           ,'Projects'); -- Request Group Application Name

--  fnd_set.add_set_to_group (request_set       => 'NSTMPRJCRT',
--                            set_application   => 'NSORO Custom Application', --REQUEST SET APPLICATION SHORT NAME
--                            request_group     => 'All Project Billing Programs',---REQUEST GROUP NAME
--                            group_application => 'Projects'--REQUEST GROUP APPLICATION SHORT NAME
--                            );
 COMMIT;

  DBMS_OUTPUT.put_line('Concurrent Program registered successfully');

EXCEPTION

  WHEN OTHERS THEN
 
    DBMS_OUTPUT.put_line('Concurrent Program already exists' || SQLERRM);
 
END;

    Final Coding :
==============

Declare

BEGIN

                         
  fnd_program.add_to_group ('MAS_AR_RCPT_RGTR_RPT' -- Concurrent Program Short Name
                            ,'MASAPP'           -- Application Short Name
                           ,'Receivables All'                -- Request Group Name
                           ,'AR'); -- Request Group Application Short Name
 COMMIT;

  DBMS_OUTPUT.put_line('Concurrent Program registered successfully');

EXCEPTION

  WHEN OTHERS THEN

    DBMS_OUTPUT.put_line('Concurrent Program already exists' || SQLERRM);

END;


=======================================

BEGIN
fnd_program.add_to_group ('MASPAWOHIST'
,' Custom Application Name'
,'All Project Billing Programs'
,'Projects');
COMMIT;
DBMS_OUTPUT.put_line ('Done');
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line ('Object already exists' || SQLERRM);
END;