DBA Data[Home] [Help]

APPS.XDPCORE_FA dependencies on XDP_ADAPTER_ADMIN_REQS

Line 4366: from XDP_ADAPTER_ADMIN_REQS

4362:
4363: is
4364: cursor c_AdapterAdmin(ChannelName varchar2) is
4365: select REQUEST_ID, REQUEST_TYPE
4366: from XDP_ADAPTER_ADMIN_REQS
4367: where CHANNEL_NAME = ChannelName and
4368: REQUEST_STATUS = 'PENDING' and
4369: REQUEST_TYPE IN ('SUSPEND', 'DISCONNECT', 'SHUTDOWN') and
4370: REQUEST_DATE = (

Line 4372: from XDP_ADAPTER_ADMIN_REQS

4368: REQUEST_STATUS = 'PENDING' and
4369: REQUEST_TYPE IN ('SUSPEND', 'DISCONNECT', 'SHUTDOWN') and
4370: REQUEST_DATE = (
4371: select MIN(REQUEST_DATE)
4372: from XDP_ADAPTER_ADMIN_REQS
4373: where CHANNEL_NAME = ChannelName and
4374: REQUEST_STATUS = 'PENDING' and
4375: REQUEST_TYPE IN ('SUSPEND', 'DISCONNECT', 'SHUTDOWN') and
4376: REQUEST_DATE <= SYSDATE );