Copying one request group to another new request group.

1. Create new Request group  : 'XX AR  Accountant2' and save it.


 Copying from existing Request Group: ''XX AR  Accountant'


declare
cursor z is

select b.CONCURRENT_PROGRAM_NAME PROGRAMNAME,c.APPLICATION_NAME APPNAME
 from FND_REQUEST_GROUP_UNITS a
,fnd_concurrent_programs b
,fnd_application_tl c
,FND_REQUEST_GROUPS d
where a.request_Group_id=d.request_Group_id and a.REQUEST_UNIT_ID=b.CONCURRENT_PROGRAM_ID
and b.APPLICATION_ID=c.APPLICATION_ID
and d.request_Group_name='XX AR  Accountant'
and c.language = 'US'
--and REQUEST_UNIT_ID = 52331
;

begin
FOR REC IN Z LOOP
FND_PROGRAM.ADD_TO_GROUP(program_short_name =>REC.PROGRAMNAME
,program_application=>REC.APPNAME
,request_group=>'XX AR  Accountant2'
, group_application=>'Receivables');
END LOOP;
END;