100: TableNotFound EXCEPTION;
101: PRAGMA EXCEPTION_INIT(TableNotFound, -942);
102: begin
103:
104: -- Delete info from FND_CONCURRENT_QUEUE_SIZE table
105: Delete From fnd_Concurrent_Queue_Size
106: where concurrent_queue_id in
107: (Select concurrent_queue_id
108: from fnd_concurrent_queues
101: PRAGMA EXCEPTION_INIT(TableNotFound, -942);
102: begin
103:
104: -- Delete info from FND_CONCURRENT_QUEUE_SIZE table
105: Delete From fnd_Concurrent_Queue_Size
106: where concurrent_queue_id in
107: (Select concurrent_queue_id
108: from fnd_concurrent_queues
109: where manager_type in (2,6));
107: (Select concurrent_queue_id
108: from fnd_concurrent_queues
109: where manager_type in (2,6));
110:
111: Delete from fnd_concurrent_queue_size
112: where concurrent_queue_id in
113: (select concurrent_queue_id
114: from fnd_concurrent_queues
115: where manager_type in
349: */
350:
351: procedure setup_clean is
352: begin
353: -- Delete info from FND_CONCURRENT_QUEUE_SIZE table
354:
355: Delete From fnd_Concurrent_Queue_Size
356: where concurrent_queue_id in
357: (Select concurrent_queue_id
351: procedure setup_clean is
352: begin
353: -- Delete info from FND_CONCURRENT_QUEUE_SIZE table
354:
355: Delete From fnd_Concurrent_Queue_Size
356: where concurrent_queue_id in
357: (Select concurrent_queue_id
358: from fnd_concurrent_queues
359: where manager_type in (2,6));
357: (Select concurrent_queue_id
358: from fnd_concurrent_queues
359: where manager_type in (2,6));
360:
361: Delete from fnd_concurrent_queue_size
362: where concurrent_queue_id in
363: (select concurrent_queue_id
364: from fnd_concurrent_queues
365: where manager_type in