Following piece of code is used for adding Concurrent program to any request group from Pl/SQL
DECLARE
BEGIN
FND_PROGRAM.add_to_group
(
PROGRAM_SHORT_NAME =>'XX_CONC_PROG'
,PROGRAM_APPLICATION =>'AR'
,REQUEST_GROUP => 'All Reports'
,GROUP_APPLICATION =>'SQLAP'
) ;
commit;
exception
when others then
dbms_output.put_line('Request Already exixts in this request group');
END ;
/
DECLARE
BEGIN
FND_PROGRAM.add_to_group
(
PROGRAM_SHORT_NAME =>'XX_CONC_PROG'
,PROGRAM_APPLICATION =>'AR'
,REQUEST_GROUP => 'All Reports'
,GROUP_APPLICATION =>'SQLAP'
) ;
commit;
exception
when others then
dbms_output.put_line('Request Already exixts in this request group');
END ;
/
No comments:
Post a Comment