APPS.FND_CP_FNDSM dependencies on FND_CONCURRENT_PROCESSES

Line 7: update FND_CONCURRENT_PROCESSES

3:
4: procedure mark_shutdown_fndsm( node IN varchar2)
5: is
6: begin
7: update FND_CONCURRENT_PROCESSES
8: set PROCESS_STATUS_CODE = 'S',
9: LAST_UPDATE_DATE = sysdate
10: where CONCURRENT_QUEUE_ID =
11: ( select CONCURRENT_QUEUE_ID

Line 29: update FND_CONCURRENT_PROCESSES

25:
26: procedure mark_killed_fndsm( node IN varchar2)
27: is
28: begin
29: update FND_CONCURRENT_PROCESSES
30: set PROCESS_STATUS_CODE = 'K',
31: LAST_UPDATE_DATE = sysdate
32: where CONCURRENT_QUEUE_ID =
33: ( select CONCURRENT_QUEUE_ID

Line 51: update FND_CONCURRENT_PROCESSES

47:
48: procedure shutdown_all_fndsm
49: is
50: begin
51: update FND_CONCURRENT_PROCESSES
52: set PROCESS_STATUS_CODE = 'S',
53: LAST_UPDATE_DATE = sysdate
54: where MANAGER_TYPE = 6
55: and PROCESS_STATUS_CODE not in ('S', 'K');

Line 80: update FND_CONCURRENT_PROCESSES

76: is
77: PRAGMA AUTONOMOUS_TRANSACTION;
78: begin
79:
80: update FND_CONCURRENT_PROCESSES
81: set PROCESS_STATUS_CODE = 'K',
82: LAST_UPDATE_DATE = sysdate,
83: LAST_UPDATED_BY = mgrusrid
84: where PROCESS_STATUS_CODE not in ('S','K')

Line 94: INSERT INTO FND_CONCURRENT_PROCESSES

90: max_processes = 1,
91: control_code = null
92: where MANAGER_TYPE = 6 and NODE_NAME = node;
93:
94: INSERT INTO FND_CONCURRENT_PROCESSES
95: (CONCURRENT_PROCESS_ID, ORACLE_PROCESS_ID,
96: QUEUE_APPLICATION_ID, CONCURRENT_QUEUE_ID,
97: SESSION_ID,
98: Creation_Date, Created_By,

Line 359: from fnd_concurrent_processes

355: and p.addr = s.paddr;
356:
357: select node_name
358: into nodename
359: from fnd_concurrent_processes
360: where concurrent_process_id = cpid;
361:
362: update fnd_concurrent_processes
363: set oracle_process_id = opid,

Line 362: update fnd_concurrent_processes

358: into nodename
359: from fnd_concurrent_processes
360: where concurrent_process_id = cpid;
361:
362: update fnd_concurrent_processes
363: set oracle_process_id = opid,
364: session_id = audsid,
365: db_name = dbname,
366: db_domain = dbdomain,

Line 391: INSERT INTO FND_CONCURRENT_PROCESSES

387: node IN varchar2)
388: is
389: PRAGMA AUTONOMOUS_TRANSACTION;
390: begin
391: INSERT INTO FND_CONCURRENT_PROCESSES
392: (CONCURRENT_PROCESS_ID, ORACLE_PROCESS_ID,
393: QUEUE_APPLICATION_ID, CONCURRENT_QUEUE_ID,
394: OS_PROCESS_ID, SESSION_ID,
395: Creation_Date, Created_By,