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 dependencies on XDP_ADAPTER_TYPES_B

Line 39: l_ApplicationMode xdp_adapter_types_b.application_mode%TYPE;

35: )
36: is
37: l_ChannelName varchar2(40);
38: l_AdapterName varchar2(40);
39: l_ApplicationMode xdp_adapter_types_b.application_mode%TYPE;
40: l_AdapterClass xdp_adapter_types_b.adapter_class%TYPE;
41: l_ConnReqFlag xdp_adapter_types_b.connection_required_flag%TYPE;
42: l_InboundReqFlag xdp_adapter_types_b.inbound_required_flag%TYPE;
43: l_LogFileName xdp_adapter_reg.log_file_name%TYPE;

Line 40: l_AdapterClass xdp_adapter_types_b.adapter_class%TYPE;

36: is
37: l_ChannelName varchar2(40);
38: l_AdapterName varchar2(40);
39: l_ApplicationMode xdp_adapter_types_b.application_mode%TYPE;
40: l_AdapterClass xdp_adapter_types_b.adapter_class%TYPE;
41: l_ConnReqFlag xdp_adapter_types_b.connection_required_flag%TYPE;
42: l_InboundReqFlag xdp_adapter_types_b.inbound_required_flag%TYPE;
43: l_LogFileName xdp_adapter_reg.log_file_name%TYPE;
44: l_FeID number := -1;

Line 41: l_ConnReqFlag xdp_adapter_types_b.connection_required_flag%TYPE;

37: l_ChannelName varchar2(40);
38: l_AdapterName varchar2(40);
39: l_ApplicationMode xdp_adapter_types_b.application_mode%TYPE;
40: l_AdapterClass xdp_adapter_types_b.adapter_class%TYPE;
41: l_ConnReqFlag xdp_adapter_types_b.connection_required_flag%TYPE;
42: l_InboundReqFlag xdp_adapter_types_b.inbound_required_flag%TYPE;
43: l_LogFileName xdp_adapter_reg.log_file_name%TYPE;
44: l_FeID number := -1;
45:

Line 42: l_InboundReqFlag xdp_adapter_types_b.inbound_required_flag%TYPE;

38: l_AdapterName varchar2(40);
39: l_ApplicationMode xdp_adapter_types_b.application_mode%TYPE;
40: l_AdapterClass xdp_adapter_types_b.adapter_class%TYPE;
41: l_ConnReqFlag xdp_adapter_types_b.connection_required_flag%TYPE;
42: l_InboundReqFlag xdp_adapter_types_b.inbound_required_flag%TYPE;
43: l_LogFileName xdp_adapter_reg.log_file_name%TYPE;
44: l_FeID number := -1;
45:
46: l_GenCountActive NUMBER := 0;

Line 101: from xdp_adapter_types_b

97: l_FeID := XDP_ADAPTER_CORE_DB.Get_Fe_Id_For_Name (p_FeName);
98:
99: select application_mode, adapter_class, connection_required_flag, inbound_required_flag
100: into l_ApplicationMode, l_AdapterClass, l_ConnReqFlag, l_InboundReqFlag
101: from xdp_adapter_types_b
102: where adapter_type = p_AdapterType;
103:
104: --
105: -- Validate parameters for non-implemented adapters

Line 300: l_ApplicationMode xdp_adapter_types_b.application_mode%TYPE;

296: )
297: is
298: l_AdapterLocked varchar2(1) := 'N';
299: l_CurrentStatus varchar2(30);
300: l_ApplicationMode xdp_adapter_types_b.application_mode%TYPE;
301: l_AdapterClass xdp_adapter_types_b.adapter_class%TYPE;
302: l_ConnReqFlag xdp_adapter_types_b.connection_required_flag%TYPE;
303: l_InboundReqFlag xdp_adapter_types_b.inbound_required_flag%TYPE;
304: lv_mode VARCHAR2(8); -- maintenance mode profile

Line 301: l_AdapterClass xdp_adapter_types_b.adapter_class%TYPE;

297: is
298: l_AdapterLocked varchar2(1) := 'N';
299: l_CurrentStatus varchar2(30);
300: l_ApplicationMode xdp_adapter_types_b.application_mode%TYPE;
301: l_AdapterClass xdp_adapter_types_b.adapter_class%TYPE;
302: l_ConnReqFlag xdp_adapter_types_b.connection_required_flag%TYPE;
303: l_InboundReqFlag xdp_adapter_types_b.inbound_required_flag%TYPE;
304: lv_mode VARCHAR2(8); -- maintenance mode profile
305:

Line 302: l_ConnReqFlag xdp_adapter_types_b.connection_required_flag%TYPE;

298: l_AdapterLocked varchar2(1) := 'N';
299: l_CurrentStatus varchar2(30);
300: l_ApplicationMode xdp_adapter_types_b.application_mode%TYPE;
301: l_AdapterClass xdp_adapter_types_b.adapter_class%TYPE;
302: l_ConnReqFlag xdp_adapter_types_b.connection_required_flag%TYPE;
303: l_InboundReqFlag xdp_adapter_types_b.inbound_required_flag%TYPE;
304: lv_mode VARCHAR2(8); -- maintenance mode profile
305:
306: l_LogFileName xdp_adapter_reg.log_file_name%TYPE;

Line 303: l_InboundReqFlag xdp_adapter_types_b.inbound_required_flag%TYPE;

299: l_CurrentStatus varchar2(30);
300: l_ApplicationMode xdp_adapter_types_b.application_mode%TYPE;
301: l_AdapterClass xdp_adapter_types_b.adapter_class%TYPE;
302: l_ConnReqFlag xdp_adapter_types_b.connection_required_flag%TYPE;
303: l_InboundReqFlag xdp_adapter_types_b.inbound_required_flag%TYPE;
304: lv_mode VARCHAR2(8); -- maintenance mode profile
305:
306: l_LogFileName xdp_adapter_reg.log_file_name%TYPE;
307:

Line 361: from xdp_adapter_types_b xat, xdp_adapter_reg xar

357: end if;
358:
359: select xat.application_mode, xat.adapter_class, xat.connection_required_flag, xat.inbound_required_flag
360: into l_ApplicationMode, l_AdapterClass, l_ConnReqFlag, l_InboundReqFlag
361: from xdp_adapter_types_b xat, xdp_adapter_reg xar
362: where xat.adapter_type = xar.adapter_type
363: and xar.channel_name = p_ChannelName;
364:
365: --

Line 2092: sql_stmt := 'select CHANNEL_NAME, PROCESS_ID, ADAPTER_STATUS, STATUS_ACTIVE_TIME from XDP_ADAPTER_REG_V a, XDP_ADAPTER_TYPES_B b where ADAPTER_STATUS not in ';

2088: Verify_All_Adapters ( p_retcode => p_retcode,
2089: p_errbuf => p_errbuf);
2090: else
2091:
2092: sql_stmt := 'select CHANNEL_NAME, PROCESS_ID, ADAPTER_STATUS, STATUS_ACTIVE_TIME from XDP_ADAPTER_REG_V a, XDP_ADAPTER_TYPES_B b where ADAPTER_STATUS not in ';
2093: sql_stmt := sql_stmt||'('''||XDP_ADAPTER.pv_statusStopped||''','''||XDP_ADAPTER.pv_statusStoppedError||''','''||XDP_ADAPTER.pv_statusTerminated||''','''||XDP_ADAPTER.pv_statusNotAvailable||''',''';
2094: sql_stmt := sql_stmt||XDP_ADAPTER.pv_statusDeactivated||''','''||XDP_ADAPTER.pv_statusDeactivatedSystem||''')';
2095: sql_stmt := sql_stmt||' and a.adapter_type = b.adapter_type and b.adapter_class <> ''NONE'' and UPPER('||p_FilterType||') like UPPER('''||p_FilterKey||''')';
2096: