DBA Data[Home] [Help]

APPS.FND_CONCURRENT dependencies on FND_CP_SERVICES

Line 493: from Fnd_Concurrent_Queues Q, Fnd_Cp_Services S

489: /* from FCQ */
490: select manager_type,
491: Running_processes, MAX_PROCESSES, Cartridge_Handle
492: into mtype, ActiveP, TargetP, CartType
493: from Fnd_Concurrent_Queues Q, Fnd_Cp_Services S
494: Where S.Service_ID = Q.Manager_Type
495: And (Q.Application_ID = applid
496: And Q.Concurrent_Queue_ID = managerid);
497:

Line 1609: FND_CP_SERVICES fcs,

1605: MAX_PROCESSES c_max_procs,
1606: CONTROL_CODE c_ctrl_code,
1607: ENABLED_FLAG c_enabled
1608: from FND_CONCURRENT_QUEUES fcq,
1609: FND_CP_SERVICES fcs,
1610: FND_APPLICATION fa
1611: where
1612: fcq.MANAGER_TYPE = to_char(fcs.SERVICE_id)
1613: and fcq.application_id = fa.application_id

Line 1626: from FND_CP_SERVICES

1622:
1623: begin
1624: select SERVICE_ID
1625: into svc_id
1626: from FND_CP_SERVICES
1627: where SERVICE_HANDLE = upper(svc_handle);
1628: exception
1629: when no_data_found then
1630: fnd_message.set_name('FND', 'CONC-SM INVALID SVC HANDLE');

Line 2372: from fnd_cp_services_vl

2368: elsif (Arg1 = -3) then
2369: begin
2370: select SERVICE_NAME
2371: into Detail
2372: from fnd_cp_services_vl
2373: where SERVICE_ID = Arg2;
2374: exception
2375: when others then
2376: Detail := 'SVCID = ' || to_char(Arg2);