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.

APPS.FND_CP_FNDSM dependencies on FND_CONCURRENT_QUEUES

Line 12: from FND_CONCURRENT_QUEUES

8: set PROCESS_STATUS_CODE = 'S',
9: LAST_UPDATE_DATE = sysdate
10: where CONCURRENT_QUEUE_ID =
11: ( select CONCURRENT_QUEUE_ID
12: from FND_CONCURRENT_QUEUES
13: where MANAGER_TYPE = '6'
14: and NODE_NAME = node)
15: and PROCESS_STATUS_CODE not in ('S', 'K');
16:

Line 17: update FND_CONCURRENT_QUEUES

13: where MANAGER_TYPE = '6'
14: and NODE_NAME = node)
15: and PROCESS_STATUS_CODE not in ('S', 'K');
16:
17: update FND_CONCURRENT_QUEUES
18: set running_processes = 0,
19: max_processes = 0,
20: control_code = null
21: where MANAGER_TYPE = '6'

Line 34: from FND_CONCURRENT_QUEUES

30: set PROCESS_STATUS_CODE = 'K',
31: LAST_UPDATE_DATE = sysdate
32: where CONCURRENT_QUEUE_ID =
33: ( select CONCURRENT_QUEUE_ID
34: from FND_CONCURRENT_QUEUES
35: where MANAGER_TYPE = '6'
36: and NODE_NAME = node)
37: and PROCESS_STATUS_CODE not in ('S', 'K');
38:

Line 39: update FND_CONCURRENT_QUEUES

35: where MANAGER_TYPE = '6'
36: and NODE_NAME = node)
37: and PROCESS_STATUS_CODE not in ('S', 'K');
38:
39: update FND_CONCURRENT_QUEUES
40: set running_processes = 0,
41: max_processes = 0,
42: control_code = null
43: where MANAGER_TYPE = 6

Line 57: update FND_CONCURRENT_QUEUES

53: LAST_UPDATE_DATE = sysdate
54: where MANAGER_TYPE = 6
55: and PROCESS_STATUS_CODE not in ('S', 'K');
56:
57: update FND_CONCURRENT_QUEUES
58: set running_processes = 0,
59: max_processes = 0,
60: control_code = null
61: where MANAGER_TYPE = '6';

Line 88: update FND_CONCURRENT_QUEUES

84: where PROCESS_STATUS_CODE not in ('S','K')
85: and MANAGER_TYPE = 6
86: and NODE_NAME = node;
87:
88: update FND_CONCURRENT_QUEUES
89: set running_processes = 1,
90: max_processes = 1,
91: control_code = null
92: where MANAGER_TYPE = 6 and NODE_NAME = node;

Line 118: from FND_CONCURRENT_QUEUES Q

114: 6, ospid,
115: logfile,
116: node, twotask
117:
118: from FND_CONCURRENT_QUEUES Q
119: where Q.MANAGER_TYPE = 6
120: and Q.NODE_NAME = node
121: );
122: commit;

Line 147: from fnd_concurrent_queues

143: END IF;
144:
145: select count(*)
146: into qcount
147: from fnd_concurrent_queues
148: where node_name = node
149: and manager_type = '6';
150:
151:

Line 156: from fnd_concurrent_queues

152:
153: if (qcount = 0) then
154: select count(*)
155: into ncount
156: from fnd_concurrent_queues
157: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name);
158:
159: if (ncount <> 0) then
160: select fnd_concurrent_queues_s.nextval

Line 160: select fnd_concurrent_queues_s.nextval

156: from fnd_concurrent_queues
157: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name);
158:
159: if (ncount <> 0) then
160: select fnd_concurrent_queues_s.nextval
161: into dummy
162: from dual;
163:
164: mgr_name := substrb('FNDSM_'||dummy||'_'||node,

Line 173: delete from fnd_concurrent_queues_tl

169: if(sm_name = 'CONC-FNDSM NAME') then
170: sm_name := 'Service Manager';
171: end if;
172:
173: delete from fnd_concurrent_queues_tl
174: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name)
175: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'FND');
176:
177: begin

Line 203: from fnd_concurrent_queues

199: END IF;
200:
201: select count(*)
202: into qcount
203: from fnd_concurrent_queues
204: where manager_type = '2'
205: and node_name = node;
206:
207: if (qcount = 0) then

Line 210: from fnd_concurrent_queues

206:
207: if (qcount = 0) then
208: select count(*)
209: into ncount
210: from fnd_concurrent_queues
211: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name);
212:
213: if (ncount <> 0) then
214: select fnd_concurrent_queues_s.nextval

Line 214: select fnd_concurrent_queues_s.nextval

210: from fnd_concurrent_queues
211: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name);
212:
213: if (ncount <> 0) then
214: select fnd_concurrent_queues_s.nextval
215: into dummy
216: from dual;
217:
218: mgr_name := substrb('FNDIM_'||dummy||'_'||node,

Line 227: delete from fnd_concurrent_queues_tl

223: if(im_name = 'CONC-FNDIM NAME') then
224: im_name := 'Internal Monitor';
225: end if;
226:
227: delete from fnd_concurrent_queues_tl
228: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name)
229: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'FND');
230:
231: begin

Line 261: from fnd_concurrent_queues

257: END IF;
258:
259: select count(*)
260: into qcount
261: from fnd_concurrent_queues
262: where node_name = node
263: and TO_NUMBER(manager_type) = (select service_id
264: from fnd_cp_services where service_handle='OAMGCS');
265:

Line 269: from fnd_concurrent_queues

265:
266: if (qcount = 0) then
267: select count(*)
268: into ncount
269: from fnd_concurrent_queues
270: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name);
271:
272: if (ncount <> 0) then
273: select fnd_concurrent_queues_s.nextval

Line 273: select fnd_concurrent_queues_s.nextval

269: from fnd_concurrent_queues
270: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name);
271:
272: if (ncount <> 0) then
273: select fnd_concurrent_queues_s.nextval
274: into dummy
275: from dual;
276:
277: mgr_name := substrb('OAMGCS_'||dummy||'_'||node,

Line 287: delete from fnd_concurrent_queues_tl

283: if(name = 'CONC-OAMGCS NAME') then
284: name := 'OAM Generic Collection Service';
285: end if;
286:
287: delete from fnd_concurrent_queues_tl
288: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name)
289: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'FND');
290:
291: begin