API to add concurrent program to a request group
Here is the way to add a concurrent program to a request group from back end.
DECLARE
v_program_short_name VARCHAR2 (200);
v_program_application VARCHAR2 (200);
v_request_group VARCHAR2 (200);
v_group_application VARCHAR2 (200);
v_check VARCHAR2 (2);
BEGIN
v_program_short_name := 'XX_CONC_PROG_SHORT_NAME';
v_program_application := 'XX Order Management';
v_request_group := 'XX Request Group';
v_group_application := 'XXFND';
apps.fnd_program.add_to_group
(program_short_name => v_program_short_name,
program_application => v_program_application,
request_group => v_request_group,
group_application => v_group_application
);
--COMMIT;
END;
SELECT 'Y'
INTO v_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 fcp.CONCURRENT_PROGRAM_NAME='XX_CONC_PROG_SHORT_NAME'
