APPS.FND_REQUEST dependencies on FND_CONCURRENT_QUEUES

Line 3824: From Fnd_Concurrent_queues

3820:
3821: begin -- Is the svc inst short name correct?
3822: Select Concurrent_queue_id
3823: Into mgr_id
3824: From Fnd_Concurrent_queues
3825: Where Application_id = mgr_app_id
3826: and Concurrent_queue_name = service;
3827: exception
3828: when no_data_found then

Line 3856: update fnd_concurrent_queues

3852: return(0);
3853: end if;
3854:
3855: begin -- Update queue cntrl code
3856: update fnd_concurrent_queues
3857: set CONTROL_CODE = decode(prog_id, 0, 'A', 1, 'D', 2, 'V', 3, 'R',
3858: 4, 'T', 5, 'D', 6, 'A', 7, 'O', 8, 'Q', null)
3859: where concurrent_queue_id = mgr_id
3860: and application_id = mgr_app_id;

Line 3948: update fnd_concurrent_queues

3944: return(0);
3945: end if;
3946:
3947: begin -- Update queue cntrl code
3948: update fnd_concurrent_queues
3949: set CONTROL_CODE = decode(prog_id, 0, 'A', 1, 'D', 2, 'V', 3, 'R',
3950: 4, 'T', 5, 'D', 6, 'A', 7, 'O', 8, 'Q', null)
3951: where
3952: /* either CM or TM and request is for mgrs (or both) */

Line 4054: update fnd_concurrent_queues

4050: return(0);
4051: end if;
4052:
4053: begin -- Update queue cntrl code
4054: update fnd_concurrent_queues
4055: set CONTROL_CODE = decode(prog_id, 0, 'A', 1, 'D', 2, 'V', 3, 'R',
4056: 4, 'T', 5, 'D', 6, 'A', 7, 'O', 8, 'Q', null)
4057: where manager_type = to_char(svc_id);
4058: exception

Line 4132: update fnd_concurrent_queues

4128: return(0);
4129: end if;
4130:
4131: begin -- Update queue cntrl code
4132: update fnd_concurrent_queues
4133: set CONTROL_CODE = decode(prog_id, 0, 'A', 1, 'D', 2, 'V', 3, 'R',
4134: 4, 'T', 5, 'D', 6, 'A', 7, 'O', 8, 'Q', null)
4135: where manager_type in ('1','3','4','5');
4136: exception