APPS.FND_CP_GSM_IPC dependencies on FND_CONCURRENT_PROCESSES

Line 247: from fnd_concurrent_processes

243:
244: Begin
245: Select GSM_INTERNAL_STATUS
246: into Status_code
247: from fnd_concurrent_processes
248: where concurrent_process_id = handle;
249:
250: return (Status_code);
251: End;

Line 443: FROM FND_CONCURRENT_PROCESSES

439: */
440:
441: select decode(sign(length(sqlnet_string) - 17), -1, sqlnet_string, null)
442: INTO sqlnet_str
443: FROM FND_CONCURRENT_PROCESSES
444: WHERE MANAGER_TYPE = 6
445: AND UPPER(NODE_NAME) = (select upper(node_name)
446: from fnd_concurrent_processes
447: where concurrent_process_id = Handle)

Line 446: from fnd_concurrent_processes

442: INTO sqlnet_str
443: FROM FND_CONCURRENT_PROCESSES
444: WHERE MANAGER_TYPE = 6
445: AND UPPER(NODE_NAME) = (select upper(node_name)
446: from fnd_concurrent_processes
447: where concurrent_process_id = Handle)
448: AND PROCESS_STATUS_CODE = 'A';
449:
450: /* 5867853- Update DB_INSTANCE and SQLNET_STRING for services */

Line 451: UPDATE FND_CONCURRENT_PROCESSES

447: where concurrent_process_id = Handle)
448: AND PROCESS_STATUS_CODE = 'A';
449:
450: /* 5867853- Update DB_INSTANCE and SQLNET_STRING for services */
451: UPDATE FND_CONCURRENT_PROCESSES
452: set SESSION_ID = s_id,
453: ORACLE_PROCESS_ID = p_id,
454: OS_PROCESS_ID = osp_id,
455: INSTANCE_NUMBER = (Select instance_number from v$instance),

Line 464: from Fnd_Concurrent_Queues Q, Fnd_Concurrent_processes P

460: where CONCURRENT_PROCESS_ID = Handle;
461:
462: select Concurrent_Queue_Name, Resource_Consumer_Group, Diagnostic_level
463: into service_name, que_rcg, diag_level
464: from Fnd_Concurrent_Queues Q, Fnd_Concurrent_processes P
465: WHERE Q.Application_ID = P.Queue_Application_ID
466: And Q.Concurrent_queue_ID = P.Concurrent_Queue_ID
467: And P.Concurrent_Process_Id = Handle;
468:

Line 657: Update FND_CONCURRENT_PROCESSES

653: else -- No Perfect answer, best to assume its Running
654: Status_Code := 'A';
655: end if;
656:
657: Update FND_CONCURRENT_PROCESSES
658: Set GSM_INTERNAL_STATUS = Status_Code
659: where CONCURRENT_PROCESS_ID = Handle;
660:
661: commit;

Line 699: Update FND_CONCURRENT_PROCESSES

695: else -- No Perfect answer, best to assume its Running
696: Status_Code := 'A';
697: end if;
698:
699: Update FND_CONCURRENT_PROCESSES
700: Set GSM_INTERNAL_STATUS = Status_Code,
701: GSM_INTERNAL_INFO = Info
702: where CONCURRENT_PROCESS_ID = Handle;
703: