DBA Data[Home] [Help]

APPS.XDP_ADAPTER_CORE_DB dependencies on XDP_ADAPTER_TYPES_B

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 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 307: -- This loads the adapter type information into the XDP_ADAPTER_TYPES_B table

303:
304: /********* Commented out - START - sacsharm ************************
305:
306: -- Create a New Adaptr Type
307: -- This loads the adapter type information into the XDP_ADAPTER_TYPES_B table
308:
309: Procedure LoadNewAdapterType ( p_AdapterType in varchar2,
310: p_AdapterClass in varchar2,
311: p_ApplicationMode in varchar2,