APPS.FND_CONCURRENT dependencies on FND_CONCURRENT_QUEUES

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 552: Select Max_Processes Into TargetP From Fnd_Concurrent_Queues

548: return;
549: end if;
550: end if;
551:
552: Select Max_Processes Into TargetP From Fnd_Concurrent_Queues
553: Where Concurrent_Queue_ID = ManagerID
554: And Application_ID = ApplID;
555:
556:

Line 907: fnd_concurrent_queues cq

903: if (C_SessionID is NULL ) then
904: Select Session_ID
905: into C_SessionID
906: from fnd_concurrent_processes cp,
907: fnd_concurrent_queues cq
908: where process_status_code = 'A'
909: and cp.Queue_Application_ID = cq.application_ID
910: and cp.concurrent_queue_id = cq.concurrent_queue_id
911: and cq.concurrent_queue_name = Queue_Name;

Line 1160: fnd_concurrent_queues q

1156: select Q.RESOURCE_CONSUMER_GROUP
1157: into que_rcg
1158: from fnd_concurrent_requests r,
1159: fnd_concurrent_processes p,
1160: fnd_concurrent_queues q
1161: where R.request_id = fnd_global.conc_request_id
1162: and R.controlling_manager = P.concurrent_process_id
1163: and Q.CONCURRENT_QUEUE_ID= P.CONCURRENT_QUEUE_ID
1164: and Q.APPLICATION_ID = P.QUEUE_APPLICATION_ID;

Line 1717: from FND_CONCURRENT_QUEUES fcq,

1713: RUNNING_PROCESSES c_run_procs,
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)

Line 1797: from FND_CONCURRENT_QUEUES fcq,

1793: select CONCURRENT_PROCESS_ID c_cpid,
1794: MEANING c_state,
1795: fcp.NODE_NAME c_node,
1796: fcp.SERVICE_PARAMETERS c_parameters
1797: from FND_CONCURRENT_QUEUES fcq,
1798: FND_CONCURRENT_PROCESSES fcp,
1799: FND_APPLICATION fa,
1800: FND_LOOKUP_VALUES_VL flv
1801: where

Line 1829: from FND_CONCURRENT_QUEUES fcq,

1825: -- Validate service application and name
1826: begin
1827: select 0
1828: into i
1829: from FND_CONCURRENT_QUEUES fcq,
1830: FND_APPLICATION fa
1831: where fcq.APPLICATION_ID = fa.APPLICATION_ID
1832: and APPLICATION_SHORT_NAME = upper(appl_short_name)
1833: and upper(CONCURRENT_QUEUE_NAME) = upper(svc_instance_name);

Line 1884: from fnd_concurrent_queues

1880: if (rarg1 >= 0) then
1881:
1882: select count(concurrent_queue_id)
1883: into kount
1884: from fnd_concurrent_queues
1885: where concurrent_queue_id = rarg1
1886: and application_id = rarg2
1887: and manager_type = mtype;
1888:

Line 1905: from fnd_concurrent_queues

1901:
1902:
1903: select count(concurrent_queue_id)
1904: into kount
1905: from fnd_concurrent_queues
1906: where application_id = rarg2
1907: and manager_type = mtype;
1908:
1909: if (kount > 0) then return 1;

Line 2057: from fnd_concurrent_queues

2053: elsif (service_id is null) then
2054: /* populate app and service id */
2055: select manager_type, application_id
2056: into my_service_id, app_id
2057: from fnd_concurrent_queues
2058: where concurrent_queue_id = service_inst_id;
2059: end if;
2060:
2061: /* find results */

Line 2098: fnd_concurrent_queues Q,

2094: from fnd_concurrent_requests R1,
2095: fnd_concurrent_requests R2,
2096: fnd_concurrent_programs P1,
2097: fnd_concurrent_programs P2,
2098: fnd_concurrent_queues Q,
2099: fnd_application A
2100: where r1.request_id = reqid
2101: and P1.APPLICATION_ID = R1.PROGRAM_APPLICATION_ID
2102: and P1.concurrent_program_id = R1.concurrent_program_id

Line 2137: from fnd_concurrent_queues

2133: /* CASE positive : old style requests */
2134: if (rarg1 >= 0) then
2135: select count(concurrent_queue_id)
2136: into kount
2137: from fnd_concurrent_queues
2138: where concurrent_queue_id = rarg1
2139: and application_id = rarg2
2140: and ((Running_processes <> MAX_PROCESSES)
2141: or ((goal_state is not null) and

Line 2150: from fnd_concurrent_queues

2146: /* CASE -1 : By app id */
2147: elsif (rarg1 = -1) then
2148: select count(concurrent_queue_id)
2149: into kount
2150: from fnd_concurrent_queues
2151: where application_id = rarg2
2152: and (
2153: /* either CM or TM and request is for mgrs (or both) */
2154: (((manager_type = 1) or (manager_type = 3))

Line 2167: from fnd_concurrent_queues

2163: /* CASE -2 : cp fun pak */
2164: elsif (rarg1 = -2) then
2165: select count(concurrent_queue_id)
2166: into kount
2167: from fnd_concurrent_queues
2168: where manager_type IN ('1', '3', '4', '5')
2169: and ((Running_processes <> MAX_PROCESSES)
2170: or ((goal_state is not null) and
2171: ((CONTROL_CODE <> goal_state) or (CONTROL_CODE is null)))

Line 2179: from fnd_concurrent_queues

2175: /* CASE -3 : By service type */
2176: elsif (rarg1 = -3) then
2177: select count(concurrent_queue_id)
2178: into kount
2179: from fnd_concurrent_queues
2180: where manager_type = to_char(rarg2)
2181: and ((Running_processes <> MAX_PROCESSES)
2182: or ((goal_state is not null) and
2183: ((CONTROL_CODE <> goal_state) or (CONTROL_CODE is null)))

Line 2190: from fnd_concurrent_queues

2186: /* CASE -4 : cp all */
2187: elsif (rarg1 = -4) then
2188: select count(concurrent_queue_id)
2189: into kount
2190: from fnd_concurrent_queues
2191: where manager_type < 1000
2192: and ((Running_processes <> MAX_PROCESSES)
2193: or ((goal_state is not null) and
2194: ((CONTROL_CODE <> goal_state) or (CONTROL_CODE is null)))

Line 2436: from fnd_concurrent_queues_vl

2432:
2433: begin
2434: select USER_CONCURRENT_QUEUE_NAME
2435: into Detail
2436: from fnd_concurrent_queues_vl
2437: where APPLICATION_ID = Arg2
2438: and concurrent_queue_id = Arg1;
2439: exception
2440: when others then