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 459: FROM FND_CONCURRENT_PROCESSES

455: */
456:
457: select decode(sign(length(sqlnet_string) - 17), -1, sqlnet_string, null)
458: INTO sqlnet_str
459: FROM FND_CONCURRENT_PROCESSES
460: WHERE MANAGER_TYPE = 6
461: AND UPPER(NODE_NAME) = (select upper(node_name)
462: from fnd_concurrent_processes
463: where concurrent_process_id = Handle)

Line 462: from fnd_concurrent_processes

458: INTO sqlnet_str
459: FROM FND_CONCURRENT_PROCESSES
460: WHERE MANAGER_TYPE = 6
461: AND UPPER(NODE_NAME) = (select upper(node_name)
462: from fnd_concurrent_processes
463: where concurrent_process_id = Handle)
464: AND PROCESS_STATUS_CODE = 'A';
465:
466: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 473: UPDATE FND_CONCURRENT_PROCESSES

469: 'Handle ' ||to_char(Handle)||': sqlnet_string='|| sqlnet_str);
470: end if;
471:
472: /* 5867853- Update DB_INSTANCE and SQLNET_STRING for services */
473: UPDATE FND_CONCURRENT_PROCESSES
474: set SESSION_ID = s_id,
475: ORACLE_PROCESS_ID = p_id,
476: OS_PROCESS_ID = osp_id,
477: INSTANCE_NUMBER = (Select instance_number from v$instance),

Line 487: 'Handle ' ||to_char(Handle)||': fnd_concurrent_processes updated');

483:
484: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
485: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
486: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
487: 'Handle ' ||to_char(Handle)||': fnd_concurrent_processes updated');
488: end if;
489:
490: select Concurrent_Queue_Name, Resource_Consumer_Group, Diagnostic_level
491: into service_name, que_rcg, diag_level

Line 492: from Fnd_Concurrent_Queues Q, Fnd_Concurrent_processes P

488: end if;
489:
490: select Concurrent_Queue_Name, Resource_Consumer_Group, Diagnostic_level
491: into service_name, que_rcg, diag_level
492: from Fnd_Concurrent_Queues Q, Fnd_Concurrent_processes P
493: WHERE Q.Application_ID = P.Queue_Application_ID
494: And Q.Concurrent_queue_ID = P.Concurrent_Queue_ID
495: And P.Concurrent_Process_Id = Handle;
496:

Line 697: Update FND_CONCURRENT_PROCESSES

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

Line 739: Update FND_CONCURRENT_PROCESSES

735: else -- No Perfect answer, best to assume its Running
736: Status_Code := 'A';
737: end if;
738:
739: Update FND_CONCURRENT_PROCESSES
740: Set GSM_INTERNAL_STATUS = Status_Code,
741: GSM_INTERNAL_INFO = Info
742: where CONCURRENT_PROCESS_ID = Handle;
743: