APPS.FND_CP_FNDSM dependencies on FND_CONCURRENT_PROCESSES

Line 14: update FND_CONCURRENT_PROCESSES

10: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
11: 'mark_shutdown_fndsm called for node'||node);
12: end if;
13:
14: update FND_CONCURRENT_PROCESSES
15: set PROCESS_STATUS_CODE = 'S',
16: LAST_UPDATE_DATE = sysdate
17: where CONCURRENT_QUEUE_ID =
18: ( select CONCURRENT_QUEUE_ID

Line 26: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_processes rows updated');

22: and PROCESS_STATUS_CODE not in ('S', 'K');
23: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
24: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
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,

Line 59: update FND_CONCURRENT_PROCESSES

55: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
56: 'fnd.plsql.FND_CP_FNDSM.MARK_KILLED_FNDSM',
57: 'mark_shutdown_fndsm called for node'||node);
58: end if;
59: update FND_CONCURRENT_PROCESSES
60: set PROCESS_STATUS_CODE = 'K',
61: LAST_UPDATE_DATE = sysdate
62: where CONCURRENT_QUEUE_ID =
63: ( select CONCURRENT_QUEUE_ID

Line 71: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_processes rows updated');

67: and PROCESS_STATUS_CODE not in ('S', 'K');
68: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
69: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
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,

Line 98: update FND_CONCURRENT_PROCESSES

94:
95: procedure shutdown_all_fndsm
96: is
97: begin
98: update FND_CONCURRENT_PROCESSES
99: set PROCESS_STATUS_CODE = 'S',
100: LAST_UPDATE_DATE = sysdate
101: where MANAGER_TYPE = 6
102: and PROCESS_STATUS_CODE not in ('S', 'K');

Line 144: INSERT INTO FND_CONCURRENT_PROCESSES

140: max_processes = 1,
141: control_code = null
142: where MANAGER_TYPE = 6 and NODE_NAME = node;
143:
144: INSERT INTO FND_CONCURRENT_PROCESSES
145: (CONCURRENT_PROCESS_ID, ORACLE_PROCESS_ID,
146: QUEUE_APPLICATION_ID, CONCURRENT_QUEUE_ID,
147: SESSION_ID,
148: Creation_Date, Created_By,

Line 409: from fnd_concurrent_processes

405: and p.addr = s.paddr;
406:
407: select node_name
408: into nodename
409: from fnd_concurrent_processes
410: where concurrent_process_id = cpid;
411:
412: update fnd_concurrent_processes
413: set oracle_process_id = opid,

Line 412: update fnd_concurrent_processes

408: into nodename
409: from fnd_concurrent_processes
410: where concurrent_process_id = cpid;
411:
412: update fnd_concurrent_processes
413: set oracle_process_id = opid,
414: session_id = audsid,
415: db_name = dbname,
416: db_domain = dbdomain,

Line 441: INSERT INTO FND_CONCURRENT_PROCESSES

437: node IN varchar2)
438: is
439: PRAGMA AUTONOMOUS_TRANSACTION;
440: begin
441: INSERT INTO FND_CONCURRENT_PROCESSES
442: (CONCURRENT_PROCESS_ID, ORACLE_PROCESS_ID,
443: QUEUE_APPLICATION_ID, CONCURRENT_QUEUE_ID,
444: OS_PROCESS_ID, SESSION_ID,
445: Creation_Date, Created_By,