APPS.XDP_ADAPTER dependencies on XDP_ADAPTER_REG_V

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