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_REG

Line 43: l_LogFileName xdp_adapter_reg.log_file_name%TYPE;

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;
47: l_GenCountFuture NUMBER := 0;

Line 91: select count(*) into l_count from xdp_adapter_reg

87:
88: --
89: -- Validate unique display name
90: --
91: select count(*) into l_count from xdp_adapter_reg
92: where adapter_display_name = p_AdapterDispName;
93: if l_count > 0 then
94: raise e_DisplayNameNotUnique;
95: end if;

Line 306: l_LogFileName xdp_adapter_reg.log_file_name%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:
308: e_AdapterConfigNA EXCEPTION;
309:
310: l_count number := 0;

Line 352: select count(*) into l_count from xdp_adapter_reg

348:
349: --
350: -- Validate unique display name
351: --
352: select count(*) into l_count from xdp_adapter_reg
353: where adapter_display_name = p_AdapterDispName and
354: channel_name <> p_ChannelName;
355: if l_count > 0 then
356: raise e_DisplayNameNotUnique;

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 1703: xdp_adapter_reg

1699:
1700: CURSOR c1 IS
1701: SELECT 'x' FROM
1702: xdp_fes,
1703: xdp_adapter_reg
1704: WHERE xdp_fes.fe_id = p_fe_id
1705: AND xdp_fes.fe_id = xdp_adapter_reg.fe_id;
1706:
1707: BEGIN

Line 1705: AND xdp_fes.fe_id = xdp_adapter_reg.fe_id;

1701: SELECT 'x' FROM
1702: xdp_fes,
1703: xdp_adapter_reg
1704: WHERE xdp_fes.fe_id = p_fe_id
1705: AND xdp_fes.fe_id = xdp_adapter_reg.fe_id;
1706:
1707: BEGIN
1708: lv_result:=FALSE;
1709:

Line 1729: l_log_file_name xdp_adapter_reg_v.log_file_name%TYPE;

1725: p_gwyuid in VARCHAR2,
1726: p_two_task in VARCHAR2) return VARCHAR2
1727:
1728: AS
1729: l_log_file_name xdp_adapter_reg_v.log_file_name%TYPE;
1730: l_target_node xdp_adapter_reg_v.target_node%TYPE;
1731: l_file_id fnd_file_temp.file_id%TYPE;
1732: l_url VARCHAR2(2000);
1733:

Line 1730: l_target_node xdp_adapter_reg_v.target_node%TYPE;

1726: p_two_task in VARCHAR2) return VARCHAR2
1727:
1728: AS
1729: l_log_file_name xdp_adapter_reg_v.log_file_name%TYPE;
1730: l_target_node xdp_adapter_reg_v.target_node%TYPE;
1731: l_file_id fnd_file_temp.file_id%TYPE;
1732: l_url VARCHAR2(2000);
1733:
1734: BEGIN

Line 1738: FROM xdp_adapter_reg_v

1734: BEGIN
1735:
1736: SELECT log_file_name, target_node
1737: INTO l_log_file_name, l_target_node
1738: FROM xdp_adapter_reg_v
1739: WHERE channel_name = p_channel_name;
1740:
1741: -- Comment back in the below two lines when FND provides the API
1742: l_file_id := Fnd_Webfile.create_id(l_log_file_name, l_target_node);

Line 2079: l_ChannelName XDP_ADAPTER_REG.CHANNEL_NAME%TYPE;

2075: TYPE t_FlexibleRef IS REF CURSOR;
2076: cv_Channelname t_FlexibleRef;
2077: sql_stmt VARCHAR2(4000);
2078:
2079: l_ChannelName XDP_ADAPTER_REG.CHANNEL_NAME%TYPE;
2080: l_ProcessID XDP_ADAPTER_REG.PROCESS_ID%TYPE;
2081: l_AdapterStatus XDP_ADAPTER_REG.ADAPTER_STATUS%TYPE;
2082: l_StatusActiveTime XDP_ADAPTER_REG.STATUS_ACTIVE_TIME%TYPE;
2083:

Line 2080: l_ProcessID XDP_ADAPTER_REG.PROCESS_ID%TYPE;

2076: cv_Channelname t_FlexibleRef;
2077: sql_stmt VARCHAR2(4000);
2078:
2079: l_ChannelName XDP_ADAPTER_REG.CHANNEL_NAME%TYPE;
2080: l_ProcessID XDP_ADAPTER_REG.PROCESS_ID%TYPE;
2081: l_AdapterStatus XDP_ADAPTER_REG.ADAPTER_STATUS%TYPE;
2082: l_StatusActiveTime XDP_ADAPTER_REG.STATUS_ACTIVE_TIME%TYPE;
2083:
2084: BEGIN

Line 2081: l_AdapterStatus XDP_ADAPTER_REG.ADAPTER_STATUS%TYPE;

2077: sql_stmt VARCHAR2(4000);
2078:
2079: l_ChannelName XDP_ADAPTER_REG.CHANNEL_NAME%TYPE;
2080: l_ProcessID XDP_ADAPTER_REG.PROCESS_ID%TYPE;
2081: l_AdapterStatus XDP_ADAPTER_REG.ADAPTER_STATUS%TYPE;
2082: l_StatusActiveTime XDP_ADAPTER_REG.STATUS_ACTIVE_TIME%TYPE;
2083:
2084: BEGIN
2085: p_retcode := 0;

Line 2082: l_StatusActiveTime XDP_ADAPTER_REG.STATUS_ACTIVE_TIME%TYPE;

2078:
2079: l_ChannelName XDP_ADAPTER_REG.CHANNEL_NAME%TYPE;
2080: l_ProcessID XDP_ADAPTER_REG.PROCESS_ID%TYPE;
2081: l_AdapterStatus XDP_ADAPTER_REG.ADAPTER_STATUS%TYPE;
2082: l_StatusActiveTime XDP_ADAPTER_REG.STATUS_ACTIVE_TIME%TYPE;
2083:
2084: BEGIN
2085: p_retcode := 0;
2086:

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: