Tuesday, 8 March 2011

To add a program in a request group

SET SERVEROUTPUT ON SIZE 100000

begin

  IF fnd_program.PROGRAM_in_group
                    (program_short_name   => 'C3_OEQUOTE'
                     ,program_application => 'ONT'
                     ,request_group       => 'OM Concurrent Programs'
                     ,group_application   => 'ONT'
                    ) THEN

       fnd_program.remove_from_group
                    (program_short_name   => 'C3_OEQUOTE'
                     ,program_application => 'ONT'
                     ,request_group       => 'OM Concurrent Programs'
                     ,group_application   => 'ONT'
                    );
  END IF;

       fnd_program.add_to_group
                    (program_short_name   => 'C3_OEQUOTE'
                     ,program_application => 'ONT'
                     ,request_group       => 'OM Concurrent Programs'
                     ,group_application   => 'ONT'
                    );

end;
/

commit;

exit;

No comments:

Post a Comment