eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.FND_CP_FNDSM dependencies on FND_CONCURRENT_QUEUES

Line 19: from FND_CONCURRENT_QUEUES

15: set PROCESS_STATUS_CODE = 'S',
16: LAST_UPDATE_DATE = sysdate
17: where CONCURRENT_QUEUE_ID =
18: ( select CONCURRENT_QUEUE_ID
19: from FND_CONCURRENT_QUEUES
20: where MANAGER_TYPE = '6'
21: and NODE_NAME = node)
22: and PROCESS_STATUS_CODE not in ('S', 'K');
23: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 29: update FND_CONCURRENT_QUEUES

25: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
26: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_processes rows updated');
27: end if;
28:
29: update FND_CONCURRENT_QUEUES
30: set running_processes = 0,
31: max_processes = 0,
32: control_code = null
33: where MANAGER_TYPE = '6'

Line 38: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_queues rows updated');

34: and NODE_NAME = node;
35: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
36: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
37: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
38: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_queues rows updated');
39: end if;
40:
41: commit;
42:

Line 64: from FND_CONCURRENT_QUEUES

60: set PROCESS_STATUS_CODE = 'K',
61: LAST_UPDATE_DATE = sysdate
62: where CONCURRENT_QUEUE_ID =
63: ( select CONCURRENT_QUEUE_ID
64: from FND_CONCURRENT_QUEUES
65: where MANAGER_TYPE = '6'
66: and NODE_NAME = node)
67: and PROCESS_STATUS_CODE not in ('S', 'K');
68: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 74: update FND_CONCURRENT_QUEUES

70: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
71: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_processes rows updated');
72: end if;
73:
74: update FND_CONCURRENT_QUEUES
75: set running_processes = 0,
76: max_processes = 0,
77: control_code = null
78: where MANAGER_TYPE = 6

Line 83: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_queues rows updated');

79: and NODE_NAME = node;
80: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
81: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
82: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
83: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_queues rows updated');
84: end if;
85:
86: commit;
87:

Line 104: update FND_CONCURRENT_QUEUES

100: LAST_UPDATE_DATE = sysdate
101: where MANAGER_TYPE = 6
102: and PROCESS_STATUS_CODE not in ('S', 'K');
103:
104: update FND_CONCURRENT_QUEUES
105: set running_processes = 0,
106: max_processes = 0,
107: control_code = null
108: where MANAGER_TYPE = '6';

Line 130: -- FND_CONCURRENT_QUEUES row from mark_shutdown_fndsm or mark_killed_fndsm.

126: begin
127:
128: -- Bugfix for 8724518
129: -- 14364164- In case of ICM migration, old ICM may have a lock on this
130: -- FND_CONCURRENT_QUEUES row from mark_shutdown_fndsm or mark_killed_fndsm.
131: -- Wait 5 seconds for old ICM to commmit when selecting fnd_concurrent_queue
132: -- row for update.
133: select 1 into dummy from fnd_concurrent_queues
134: where manager_type = 6 and node_name = node

Line 133: select 1 into dummy from fnd_concurrent_queues

129: -- 14364164- In case of ICM migration, old ICM may have a lock on this
130: -- FND_CONCURRENT_QUEUES row from mark_shutdown_fndsm or mark_killed_fndsm.
131: -- Wait 5 seconds for old ICM to commmit when selecting fnd_concurrent_queue
132: -- row for update.
133: select 1 into dummy from fnd_concurrent_queues
134: where manager_type = 6 and node_name = node
135: for update of running_processes ,max_processes , control_code
136: wait 5;
137:

Line 138: update FND_CONCURRENT_QUEUES

134: where manager_type = 6 and node_name = node
135: for update of running_processes ,max_processes , control_code
136: wait 5;
137:
138: update FND_CONCURRENT_QUEUES
139: set running_processes = 1,
140: max_processes = 1,
141: control_code = null
142: where MANAGER_TYPE = 6 and NODE_NAME = node;

Line 168: from FND_CONCURRENT_QUEUES Q

164: 6, ospid,
165: logfile,
166: node, twotask
167:
168: from FND_CONCURRENT_QUEUES Q
169: where Q.MANAGER_TYPE = 6
170: and Q.NODE_NAME = node
171: );
172: commit;

Line 197: from fnd_concurrent_queues

193: END IF;
194:
195: select count(*)
196: into qcount
197: from fnd_concurrent_queues
198: where node_name = node
199: and manager_type = '6';
200:
201:

Line 206: from fnd_concurrent_queues

202:
203: if (qcount = 0) then
204: select count(*)
205: into ncount
206: from fnd_concurrent_queues
207: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name);
208:
209: if (ncount <> 0) then
210: select fnd_concurrent_queues_s.nextval

Line 210: select fnd_concurrent_queues_s.nextval

206: from fnd_concurrent_queues
207: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name);
208:
209: if (ncount <> 0) then
210: select fnd_concurrent_queues_s.nextval
211: into dummy
212: from dual;
213:
214: mgr_name := substrb('FNDSM_'||dummy||'_'||node,

Line 223: delete from fnd_concurrent_queues_tl

219: if(sm_name = 'CONC-FNDSM NAME') then
220: sm_name := 'Service Manager';
221: end if;
222:
223: delete from fnd_concurrent_queues_tl
224: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name)
225: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'FND');
226:
227: begin

Line 253: from fnd_concurrent_queues

249: END IF;
250:
251: select count(*)
252: into qcount
253: from fnd_concurrent_queues
254: where manager_type = '2'
255: and node_name = node;
256:
257: if (qcount = 0) then

Line 260: from fnd_concurrent_queues

256:
257: if (qcount = 0) then
258: select count(*)
259: into ncount
260: from fnd_concurrent_queues
261: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name);
262:
263: if (ncount <> 0) then
264: select fnd_concurrent_queues_s.nextval

Line 264: select fnd_concurrent_queues_s.nextval

260: from fnd_concurrent_queues
261: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name);
262:
263: if (ncount <> 0) then
264: select fnd_concurrent_queues_s.nextval
265: into dummy
266: from dual;
267:
268: mgr_name := substrb('FNDIM_'||dummy||'_'||node,

Line 277: delete from fnd_concurrent_queues_tl

273: if(im_name = 'CONC-FNDIM NAME') then
274: im_name := 'Internal Monitor';
275: end if;
276:
277: delete from fnd_concurrent_queues_tl
278: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name)
279: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'FND');
280:
281: begin

Line 311: from fnd_concurrent_queues

307: END IF;
308:
309: select count(*)
310: into qcount
311: from fnd_concurrent_queues
312: where node_name = node
313: and TO_NUMBER(manager_type) = (select service_id
314: from fnd_cp_services where service_handle='OAMGCS');
315:

Line 319: from fnd_concurrent_queues

315:
316: if (qcount = 0) then
317: select count(*)
318: into ncount
319: from fnd_concurrent_queues
320: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name);
321:
322: if (ncount <> 0) then
323: select fnd_concurrent_queues_s.nextval

Line 323: select fnd_concurrent_queues_s.nextval

319: from fnd_concurrent_queues
320: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name);
321:
322: if (ncount <> 0) then
323: select fnd_concurrent_queues_s.nextval
324: into dummy
325: from dual;
326:
327: mgr_name := substrb('OAMGCS_'||dummy||'_'||node,

Line 337: delete from fnd_concurrent_queues_tl

333: if(name = 'CONC-OAMGCS NAME') then
334: name := 'OAM Generic Collection Service';
335: end if;
336:
337: delete from fnd_concurrent_queues_tl
338: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name)
339: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'FND');
340:
341: begin