APPS.FND_REQUEST dependencies on FND_CONCURRENT_QUEUES

Line 3137: From Fnd_Concurrent_queues

3133:
3134: begin -- Is the svc inst short name correct?
3135: Select Concurrent_queue_id
3136: Into mgr_id
3137: From Fnd_Concurrent_queues
3138: Where Application_id = mgr_app_id
3139: and Concurrent_queue_name = service;
3140: exception
3141: when no_data_found then

Line 3169: update fnd_concurrent_queues

3165: return(0);
3166: end if;
3167:
3168: begin -- Update queue cntrl code
3169: update fnd_concurrent_queues
3170: set CONTROL_CODE = decode(prog_id, 0, 'A', 1, 'D', 2, 'V', 3, 'R',
3171: 4, 'T', 5, 'D', 6, 'A', 7, 'O', 8, 'Q', null)
3172: where concurrent_queue_id = mgr_id
3173: and application_id = mgr_app_id;

Line 3261: update fnd_concurrent_queues

3257: return(0);
3258: end if;
3259:
3260: begin -- Update queue cntrl code
3261: update fnd_concurrent_queues
3262: set CONTROL_CODE = decode(prog_id, 0, 'A', 1, 'D', 2, 'V', 3, 'R',
3263: 4, 'T', 5, 'D', 6, 'A', 7, 'O', 8, 'Q', null)
3264: where
3265: /* either CM or TM and request is for mgrs (or both) */

Line 3367: update fnd_concurrent_queues

3363: return(0);
3364: end if;
3365:
3366: begin -- Update queue cntrl code
3367: update fnd_concurrent_queues
3368: set CONTROL_CODE = decode(prog_id, 0, 'A', 1, 'D', 2, 'V', 3, 'R',
3369: 4, 'T', 5, 'D', 6, 'A', 7, 'O', 8, 'Q', null)
3370: where manager_type = to_char(svc_id);
3371: exception

Line 3445: update fnd_concurrent_queues

3441: return(0);
3442: end if;
3443:
3444: begin -- Update queue cntrl code
3445: update fnd_concurrent_queues
3446: set CONTROL_CODE = decode(prog_id, 0, 'A', 1, 'D', 2, 'V', 3, 'R',
3447: 4, 'T', 5, 'D', 6, 'A', 7, 'O', 8, 'Q', null)
3448: where manager_type in ('1','3','4','5');
3449: exception