[Home] [Help]
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:
546: return;
547: end if;
548: end if;
549:
550: Select Max_Processes Into TargetP From Fnd_Concurrent_Queues
551: Where Concurrent_Queue_ID = ManagerID
552: And Application_ID = ApplID;
553:
554:
834: if (C_SessionID is NULL ) then
835: Select Session_ID
836: into C_SessionID
837: from fnd_concurrent_processes cp,
838: fnd_concurrent_queues cq
839: where process_status_code = 'A'
840: and cp.Queue_Application_ID = cq.application_ID
841: and cp.concurrent_queue_id = cq.concurrent_queue_id
842: and cq.concurrent_queue_name = Queue_Name;
1051: select Q.RESOURCE_CONSUMER_GROUP
1052: into que_rcg
1053: from fnd_concurrent_requests r,
1054: fnd_concurrent_processes p,
1055: fnd_concurrent_queues q
1056: where R.request_id = fnd_global.conc_request_id
1057: and R.controlling_manager = P.concurrent_process_id
1058: and Q.CONCURRENT_QUEUE_ID= P.CONCURRENT_QUEUE_ID
1059: and Q.APPLICATION_ID = P.QUEUE_APPLICATION_ID;
1604: RUNNING_PROCESSES c_run_procs,
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)
1684: select CONCURRENT_PROCESS_ID c_cpid,
1685: MEANING c_state,
1686: fcp.NODE_NAME c_node,
1687: fcp.SERVICE_PARAMETERS c_parameters
1688: from FND_CONCURRENT_QUEUES fcq,
1689: FND_CONCURRENT_PROCESSES fcp,
1690: FND_APPLICATION fa,
1691: FND_LOOKUP_VALUES_VL flv
1692: where
1716: -- Validate service application and name
1717: begin
1718: select 0
1719: into i
1720: from FND_CONCURRENT_QUEUES fcq,
1721: FND_APPLICATION fa
1722: where fcq.APPLICATION_ID = fa.APPLICATION_ID
1723: and APPLICATION_SHORT_NAME = upper(appl_short_name)
1724: and upper(CONCURRENT_QUEUE_NAME) = upper(svc_instance_name);
1771: if (rarg1 >= 0) then
1772:
1773: select count(concurrent_queue_id)
1774: into kount
1775: from fnd_concurrent_queues
1776: where concurrent_queue_id = rarg1
1777: and application_id = rarg2
1778: and manager_type = mtype;
1779:
1792:
1793:
1794: select count(concurrent_queue_id)
1795: into kount
1796: from fnd_concurrent_queues
1797: where application_id = rarg2
1798: and manager_type = mtype;
1799:
1800: if (kount > 0) then return 1;
1944: elsif (service_id is null) then
1945: /* populate app and service id */
1946: select manager_type, application_id
1947: into my_service_id, app_id
1948: from fnd_concurrent_queues
1949: where concurrent_queue_id = service_inst_id;
1950: end if;
1951:
1952: /* find results */
1985: from fnd_concurrent_requests R1,
1986: fnd_concurrent_requests R2,
1987: fnd_concurrent_programs P1,
1988: fnd_concurrent_programs P2,
1989: fnd_concurrent_queues Q,
1990: fnd_application A
1991: where r1.request_id = reqid
1992: and P1.APPLICATION_ID = R1.PROGRAM_APPLICATION_ID
1993: and P1.concurrent_program_id = R1.concurrent_program_id
2024: /* CASE positive : old style requests */
2025: if (rarg1 >= 0) then
2026: select count(concurrent_queue_id)
2027: into kount
2028: from fnd_concurrent_queues
2029: where concurrent_queue_id = rarg1
2030: and application_id = rarg2
2031: and ((Running_processes <> MAX_PROCESSES)
2032: or ((goal_state is not null) and
2037: /* CASE -1 : By app id */
2038: elsif (rarg1 = -1) then
2039: select count(concurrent_queue_id)
2040: into kount
2041: from fnd_concurrent_queues
2042: where application_id = rarg2
2043: and (
2044: /* either CM or TM and request is for mgrs (or both) */
2045: (((manager_type = 1) or (manager_type = 3))
2054: /* CASE -2 : cp fun pak */
2055: elsif (rarg1 = -2) then
2056: select count(concurrent_queue_id)
2057: into kount
2058: from fnd_concurrent_queues
2059: where manager_type IN ('1', '3', '4', '5')
2060: and ((Running_processes <> MAX_PROCESSES)
2061: or ((goal_state is not null) and
2062: ((CONTROL_CODE <> goal_state) or (CONTROL_CODE is null)))
2066: /* CASE -3 : By service type */
2067: elsif (rarg1 = -3) then
2068: select count(concurrent_queue_id)
2069: into kount
2070: from fnd_concurrent_queues
2071: where manager_type = to_char(rarg2)
2072: and ((Running_processes <> MAX_PROCESSES)
2073: or ((goal_state is not null) and
2074: ((CONTROL_CODE <> goal_state) or (CONTROL_CODE is null)))
2077: /* CASE -4 : cp all */
2078: elsif (rarg1 = -4) then
2079: select count(concurrent_queue_id)
2080: into kount
2081: from fnd_concurrent_queues
2082: where manager_type < 1000
2083: and ((Running_processes <> MAX_PROCESSES)
2084: or ((goal_state is not null) and
2085: ((CONTROL_CODE <> goal_state) or (CONTROL_CODE is null)))
2323:
2324: begin
2325: select USER_CONCURRENT_QUEUE_NAME
2326: into Detail
2327: from fnd_concurrent_queues_vl
2328: where APPLICATION_ID = Arg2
2329: and concurrent_queue_id = Arg1;
2330: exception
2331: when others then