APPS.XDPCORE_FA dependencies on XDP_ADAPTER_REG

Line 2124: from XDP_ADAPTER_REG

2120: l_channelstatus varchar2(1) ;
2121:
2122: cursor c_CheckChannel(ChannelName varchar2) is
2123: select adapter_status
2124: from XDP_ADAPTER_REG
2125: where channel_name = ChannelName;
2126:
2127: resource_busy exception;
2128: pragma exception_init(resource_busy, -00054);

Line 2417: from XDP_ADAPTER_REG

2413: P_RETURN_CODE => l_ErrCode,
2414: P_ERROR_DESCRIPTION => l_ErrStr);
2415:
2416: select adapter_status into l_AdapterStatus
2417: from XDP_ADAPTER_REG
2418: where channel_name = l_ChannelName;
2419:
2420:
2421: --skilaru 05/19/2002

Line 3710: from xdp_adapter_reg

3706: where fulfillment_element_name = p_FeName;
3707:
3708: cursor c_GetUsageCode is
3709: select USAGE_CODE
3710: from xdp_adapter_reg
3711: where channel_name = p_ChannelName;
3712:
3713: BEGIN
3714:

Line 4090: from XDP_ADAPTER_REG

4086:
4087: if FeID = 0 then
4088: select fe_id, usage_code
4089: into l_FeID, l_ChannelUsageCode
4090: from XDP_ADAPTER_REG
4091: where channel_name = ChannelName;
4092: else
4093: l_FeID := FeID;
4094: l_ChannelUsageCode := ChannelUsageCode;

Line 4649: from XDP_ADAPTER_REG

4645:
4646: cursor c_GetChannel(feid number, ChannelUsageCode varchar2,
4647: AdapterStatus varchar2) is
4648: select ROWID, channel_name
4649: from XDP_ADAPTER_REG
4650: where FE_ID = feid
4651: and ADAPTER_STATUS = AdapterStatus
4652: and USAGE_CODE = ChannelUsageCode
4653: order by NVL(SEQ_IN_FE, 10);

Line 4658: from XDP_ADAPTER_REG

4654:
4655: cursor c_GetCODChannel(feid number, ChannelUsageCode varchar2,
4656: AdapterStatus varchar2, CODFlag varchar2) is
4657: select ROWID, channel_name
4658: from XDP_ADAPTER_REG
4659: where FE_ID = feid
4660: and ADAPTER_STATUS = AdapterStatus
4661: and NVL(CONNECT_ON_DEMAND_FLAG, 'N') = CODFlag
4662: and USAGE_CODE = ChannelUsageCode