[Home] [Help]
551:
552:
553: /*
554: * Switch a manager's resource consumer group to the group it is assigned to
555: * in FND_CONCURRENT_QUEUES, or the default group if one is not assigned.
556: */
557: procedure set_mgr_rcg(qaid in number, qid in number) is
558:
559: que_rcg varchar2(32);
567:
568: begin
569: select nvl(RESOURCE_CONSUMER_GROUP, 'DEFAULT_CONSUMER_GROUP')
570: into que_rcg
571: from fnd_concurrent_queues
572: where CONCURRENT_QUEUE_ID = qid
573: and APPLICATION_ID = qaid;
574: exception
575: when others then