APPS.XDP_ADAPTER_CORE_DB dependencies on XDP_ADAPTER_REG

Line 23: from XDP_ADAPTER_REG a, XDP_ADAPTER_TYPES_B b

19: cursor G_Get_Running_Adapters (SvcInstID number) is
20: select CHANNEL_NAME, PROCESS_ID, ADAPTER_STATUS,
21: decode(ADAPTER_CLASS, 'NONE', 'N', 'Y') IS_IMPLEMENTED,
22: STATUS_ACTIVE_TIME
23: from XDP_ADAPTER_REG a, XDP_ADAPTER_TYPES_B b
24: where ADAPTER_STATUS not in (XDP_ADAPTER.pv_statusStopped,
25: XDP_ADAPTER.pv_statusStoppedError,
26: XDP_ADAPTER.pv_statusTerminated,
27: XDP_ADAPTER.pv_statusNotAvailable,

Line 38: from XDP_ADAPTER_REG a, FND_CONCURRENT_QUEUES_VL b

34: select distinct a.service_instance_id, b.CONCURRENT_QUEUE_NAME,
35: decode(b.USER_CONCURRENT_QUEUE_NAME,
36: null, b.CONCURRENT_QUEUE_NAME,
37: b.USER_CONCURRENT_QUEUE_NAME) USER_CONCURRENT_QUEUE_NAME
38: from XDP_ADAPTER_REG a, FND_CONCURRENT_QUEUES_VL b
39: where a.service_instance_id = b.CONCURRENT_QUEUE_ID and
40: b.APPLICATION_ID = XDP_ADAPTER.pv_AppID;
41:
42: -- DWI - Disconnect/Stop when idle

Line 45: from XDP_ADAPTER_REG

41:
42: -- DWI - Disconnect/Stop when idle
43: cursor G_Get_DWI_Adapters (SvcInstID number) is
44: select CHANNEL_NAME, STARTUP_MODE, CONNECT_ON_DEMAND_FLAG
45: from XDP_ADAPTER_REG
46: where ADAPTER_STATUS = XDP_ADAPTER.pv_statusRunning and
47: ((STARTUP_MODE = XDP_ADAPTER.pv_startOnDemand) OR
48: ((CONNECT_ON_DEMAND_FLAG is not null) and (CONNECT_ON_DEMAND_FLAG = 'Y'))) and
49: ((MAX_IDLE_TIME_MINUTES is not null) and

Line 56: from XDP_ADAPTER_REG a, XDP_FES f

52:
53: cursor G_Get_All_Adapters is
54: select a.CHANNEL_NAME, a.PROCESS_ID, a.ADAPTER_STATUS, a.FE_ID,
55: a.ADAPTER_TYPE, f.ROLE_NAME, a.ADAPTER_DISPLAY_NAME
56: from XDP_ADAPTER_REG a, XDP_FES f
57: where a.fe_id = f.fe_id;
58:
59: -- Gets all automatic (AUTO and SOD) adapters for a Controller instance that are/may
60: -- be required to be started. AUTO adapters are started whereas SOD adapters are checked if

Line 67: from XDP_ADAPTER_REG xar, XDP_ADAPTER_TYPES_B xat, XDP_FES xfe

63:
64: cursor G_Get_Automatic_Adapters (SvcInstID number) is
65: select CHANNEL_NAME, STARTUP_MODE, XAR.FE_ID, XFE.FULFILLMENT_ELEMENT_NAME,
66: decode(ADAPTER_CLASS, 'NONE', 'N', 'Y') IS_IMPLEMENTED, APPLICATION_MODE
67: from XDP_ADAPTER_REG xar, XDP_ADAPTER_TYPES_B xat, XDP_FES xfe
68: where ADAPTER_STATUS in (XDP_ADAPTER.pv_statusStopped,
69: XDP_ADAPTER.pv_statusStoppedError,
70: XDP_ADAPTER.pv_statusTerminated)
71: and STARTUP_MODE in (XDP_ADAPTER.pv_startAutomatic, XDP_ADAPTER.pv_startOnDemand)

Line 81: from XDP_ADAPTER_REG

77: -- required to be resetted when the Controller instance starts
78:
79: cursor G_Get_SysDeactivated_Adapters (SvcInstID number) is
80: select CHANNEL_NAME, adapter_status
81: from XDP_ADAPTER_REG
82: where STARTUP_MODE in (XDP_ADAPTER.pv_startAutomatic, XDP_ADAPTER.pv_startOnDemand)
83: and service_instance_id = SvcInstId;
84:
85: -- This creates an entry in the Adapter Registration table.