registering EXECUTABLE,CONCURRENT PROGRAM,REQUEST GROUP,submitting concurrent program from backend in ORACLE APPS

1)registering executable from backend

BEGIN
FND_PROGRAM.executable('custom_executable_name'--executable
                      ,'Inventory'--application
                      ,'custom_executable_name'--short_name
                      ,'its my custom executable creation'--description
                      ,'PL/SQL Stored Procedure'--execution_method
                      ,'package.procedure'--execution_file_name
                      ,''--subroutine_name
                      ,''--Execution File Path
                      ,'US'--language_code
                      ,'');
COMMIT;
END;

--to see whether created or not,check it from frontend

2)registering concurrent program from backend

BEGIN
FND_PROGRAM.register('CUSTOM_PROGRAM_NAME'--program
                     ,'Inventory'--application 
                     ,'Y'--enabled
                     ,'CUSTOM_PROGRAM_NAME'--short_name
                     ,'its my custom concurrent program creation'--description
                     ,'custom_executable_name'--executable_short_name
                     ,'Inventory'--executable_application
                     ,''--execution_options
                     ,''--priority
                     ,'Y'--save_output
                     ,'Y'--print
                     ,''--cols
                     ,''--rows
                     ,''--style
                     ,'N'--style_required
                     ,''--printer
                     ,''--request_type
                     ,''--request_type_application
                     ,'Y'--use_in_srs
                     ,'N'--allow_disabled_values
                     ,'N'--run_alone
                     ,'PDF'--output_type
                     ,'N'--enable_trace
                     ,'Y'--restart
                     ,'Y'--nls_compliant
                     ,''--icon_name
                     ,'US'--language_code
                    );
COMMIT;
END;


--to see whether created or not,check it from frontend

3) registering Request group from backend

BEGIN
FND_PROGRAM.add_to_group('CUSTOM_PROGRAM_NAME'--conc program short name
                        ,'Inventory'--application name
                        ,'All Reports'--Report Group Name
                        ,'Inventory'--Report Group Application name
                        );
COMMIT;
END;

--to see whether created or not,check it from frontend

4)submitting concurrent program from backend

fnd_global.apps_initialize(user_id
                          ,responsibility_id
                          ,application_responsibility_id
                          );
DECLARE
l_request_id NUMBER(30);
begin
FND_GLOBAL.APPS_INITIALIZE(user_id=>1
                          ,resp_id=>202
                          ,resp_appl_id=>430
                          );
l_request_id:=FND_REQUEST.SUBMIT_REQUEST('INV'--Application Short name
                                        
                                         ,'CUSTOM_PROGRAM_NAME'--conc prog short name
                                        );
DBMS_OUTPUT.PUT_LINE(l_request_id);
commit;
end;

note:to get user_id,resp_id,resp_appl_id,request_id use below queries i.e

SELECT APPLICATION_ID
              ,RESPONSIBILITY_ID
FROM   FND_RESPONSIBILITY_TL 
WHERE RESPONSIBILITY_NAME='place which responsibility we need';

SELECT USER_ID FROM FND_USER WHERE USER_NAME='RAM';

SELECT *FROM FND_CONCURRENT_REQUESTS WHERE REQUEST _ID=11111;