DBA Data[Home] [Help]

APPS.FND_CONCURRENT dependencies on FND_CP_SERVICES

Line 495: from Fnd_Concurrent_Queues Q, Fnd_Cp_Services S

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

Line 1718: FND_CP_SERVICES fcs,

1714: MAX_PROCESSES c_max_procs,
1715: CONTROL_CODE c_ctrl_code,
1716: ENABLED_FLAG c_enabled
1717: from FND_CONCURRENT_QUEUES fcq,
1718: FND_CP_SERVICES fcs,
1719: FND_APPLICATION fa
1720: where
1721: fcq.MANAGER_TYPE = to_char(fcs.SERVICE_id)
1722: and fcq.application_id = fa.application_id

Line 1735: from FND_CP_SERVICES

1731:
1732: begin
1733: select SERVICE_ID
1734: into svc_id
1735: from FND_CP_SERVICES
1736: where SERVICE_HANDLE = upper(svc_handle);
1737: exception
1738: when no_data_found then
1739: fnd_message.set_name('FND', 'CONC-SM INVALID SVC HANDLE');

Line 2481: from fnd_cp_services_vl

2477: elsif (Arg1 = -3) then
2478: begin
2479: select SERVICE_NAME
2480: into Detail
2481: from fnd_cp_services_vl
2482: where SERVICE_ID = Arg2;
2483: exception
2484: when others then
2485: Detail := 'SVCID = ' || to_char(Arg2);