eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDP_ADAPTER_CORE_DB dependencies on XDP_ADAPTER

Line 1: PACKAGE XDP_ADAPTER_CORE_DB AUTHID CURRENT_USER AS

1: PACKAGE XDP_ADAPTER_CORE_DB AUTHID CURRENT_USER AS
2: /* $Header: XDPACODS.pls 120.1 2005/06/08 23:33:33 appldev $ */
3:
4: e_SendPipedMsgException exception;
5: e_ReceivePipedMsgException exception;

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 24: where ADAPTER_STATUS not in (XDP_ADAPTER.pv_statusStopped,

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,
28: XDP_ADAPTER.pv_statusDeactivated,

Line 25: XDP_ADAPTER.pv_statusStoppedError,

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,
28: XDP_ADAPTER.pv_statusDeactivated,
29: XDP_ADAPTER.pv_statusDeactivatedSystem)

Line 26: XDP_ADAPTER.pv_statusTerminated,

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,
28: XDP_ADAPTER.pv_statusDeactivated,
29: XDP_ADAPTER.pv_statusDeactivatedSystem)
30: and a.adapter_type = b.adapter_type

Line 27: XDP_ADAPTER.pv_statusNotAvailable,

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,
28: XDP_ADAPTER.pv_statusDeactivated,
29: XDP_ADAPTER.pv_statusDeactivatedSystem)
30: and a.adapter_type = b.adapter_type
31: and service_instance_id = SvcInstId;

Line 28: XDP_ADAPTER.pv_statusDeactivated,

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,
28: XDP_ADAPTER.pv_statusDeactivated,
29: XDP_ADAPTER.pv_statusDeactivatedSystem)
30: and a.adapter_type = b.adapter_type
31: and service_instance_id = SvcInstId;
32:

Line 29: XDP_ADAPTER.pv_statusDeactivatedSystem)

25: XDP_ADAPTER.pv_statusStoppedError,
26: XDP_ADAPTER.pv_statusTerminated,
27: XDP_ADAPTER.pv_statusNotAvailable,
28: XDP_ADAPTER.pv_statusDeactivated,
29: XDP_ADAPTER.pv_statusDeactivatedSystem)
30: and a.adapter_type = b.adapter_type
31: and service_instance_id = SvcInstId;
32:
33: cursor G_Get_Controller_Instances is

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 40: b.APPLICATION_ID = XDP_ADAPTER.pv_AppID;

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
43: cursor G_Get_DWI_Adapters (SvcInstID number) is
44: select CHANNEL_NAME, STARTUP_MODE, CONNECT_ON_DEMAND_FLAG

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 46: where ADAPTER_STATUS = XDP_ADAPTER.pv_statusRunning and

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
50: ((STATUS_ACTIVE_TIME + (MAX_IDLE_TIME_MINUTES/(60*24))) < SYSDATE)) and

Line 47: ((STARTUP_MODE = XDP_ADAPTER.pv_startOnDemand) OR

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
50: ((STATUS_ACTIVE_TIME + (MAX_IDLE_TIME_MINUTES/(60*24))) < SYSDATE)) and
51: service_instance_id = SvcInstId;

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 68: where ADAPTER_STATUS in (XDP_ADAPTER.pv_statusStopped,

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)
72: and xat.adapter_type = xar.adapter_type

Line 69: XDP_ADAPTER.pv_statusStoppedError,

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)
72: and xat.adapter_type = xar.adapter_type
73: and xar.fe_id = xfe.fe_id

Line 70: XDP_ADAPTER.pv_statusTerminated)

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)
72: and xat.adapter_type = xar.adapter_type
73: and xar.fe_id = xfe.fe_id
74: and service_instance_id = SvcInstId;

Line 71: and STARTUP_MODE in (XDP_ADAPTER.pv_startAutomatic, XDP_ADAPTER.pv_startOnDemand)

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)
72: and xat.adapter_type = xar.adapter_type
73: and xar.fe_id = xfe.fe_id
74: and service_instance_id = SvcInstId;
75:

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.

Line 82: where STARTUP_MODE in (XDP_ADAPTER.pv_startAutomatic, XDP_ADAPTER.pv_startOnDemand)

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.
86: -- Once the adapter is created it can be started

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,

Line 381: END XDP_ADAPTER_CORE_DB;

377: x_errbuf OUT NOCOPY VARCHAR2);
378:
379:
380:
381: END XDP_ADAPTER_CORE_DB;