Friday, 18 November 2016

Add Concurrent Program to Request Group Using api fnd_program.add_to_group


Use the below PLSQL for  Adding Concurrent Program to Request Group Using api fnd_program.add_to_group

BEGIN
BEGIN
BEGIN
apps.fnd_program.remove_from_group
  (PROGRAM_SHORT_NAME  => 'XXCUST_CP',
PROGRAM_APPLICATION => 'XXCUST',
REQUEST_GROUP       => 'XXCUST Request Group',
GROUP_APPLICATION   => 'XXCUST'
 ); 
commit;
EXCEPTION WHEN OTHERS
THEN
NULL;
END;

fnd_program.add_to_group(
PROGRAM_SHORT_NAME  =>  'XXCUST_CP',
PROGRAM_APPLICATION =>  'XXCUST',
REQUEST_GROUP       =>'XXCUST Request Group',
GROUP_APPLICATION   =>  'XXCUST'
 );     
commit; 
END;
END;
/

No comments:

Post a Comment