APPS.XDP_APPLICATION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

	select SERVICE_ID, SERVICE_HANDLE, SERVICE_NAME
	from fnd_cp_services_VL
	where
		((service_handle like 'XDPA%') or (service_handle like 'XDPQ%')) and
		ENABLED = 'Y' and
		service_handle <> 'XDPCTRLS'
	order by service_handle;

Line: 125

 SELECT xar.channel_name, fe.fulfillment_element_name, xar.adapter_display_name,
	xar.fe_id, xar.adapter_status, xar.process_id
 FROM xdp_adapter_reg xar, xdp_fes fe
 WHERE xar.adapter_status not in (XDP_ADAPTER.pv_statusStopped,
				XDP_ADAPTER.pv_statusStoppedError,
				XDP_ADAPTER.pv_statusTerminated,
				XDP_ADAPTER.pv_statusNotAvailable,
				XDP_ADAPTER.pv_statusDeactivated,
				XDP_ADAPTER.pv_statusDeactivatedSystem)
   -- and xar.startup_mode = XDP_ADAPTER.pv_startAutomatic
       and xar.fe_id = fe.fe_id
 order by fe.fulfillment_element_name;

Line: 207

				-- Following package with also update the adapter instance entry
				-- in XDP_ADAPTER_REG table accordingly
				-- and will submit a admin request if required i.e. if the
				-- Adapter cannot be locked

				FND_FILE.put_line(FND_FILE.log,'Attempting to stop adapter '||
						v_AdapterData.adapter_display_name);

Line: 244

				-- and also update the adapter instance entry
				-- in XDP_ADAPTER_REG table accordingly

				FND_FILE.put_line(FND_FILE.log,'Attempting to stop adapter '||
						v_AdapterData.adapter_display_name||
						' in abort mode');

Line: 318

	l_ServiceInstanceList.delete;

Line: 833

	l_ServiceInstanceStarted.delete;

Line: 834

	l_ServiceInstanceList.delete;

Line: 961

 SELECT xar.channel_name, xfe.fulfillment_element_name,
	xar.adapter_display_name, xar.startup_mode, xar.fe_id, xar.adapter_status
 FROM xdp_adapter_reg xar, xdp_fes xfe
 WHERE xar.adapter_status in (XDP_ADAPTER.pv_statusStopped,
				XDP_ADAPTER.pv_statusStoppedError,
				XDP_ADAPTER.pv_statusTerminated,
				XDP_ADAPTER.pv_statusDeactivated,
				XDP_ADAPTER.pv_statusDeactivatedSystem)
   and xar.startup_mode in (XDP_ADAPTER.pv_startAutomatic,
				XDP_ADAPTER.pv_startGroup,
				XDP_ADAPTER.pv_startOnDemand)
   and xfe.fe_id = xar.fe_id
 order by xfe.fulfillment_element_name;

Line: 1282

	l_SIProcessList.delete;

Line: 1397

	select a.concurrent_queue_id, b.concurrent_queue_name
	from fnd_concurrent_processes a, fnd_concurrent_queues b
	where a.concurrent_process_id = CPID and
		a.concurrent_queue_id = b.concurrent_queue_id and
		a.queue_application_id = b.application_id;

Line: 1614

	select a.concurrent_queue_name
	from fnd_concurrent_queues a
	where a.concurrent_queue_id = ConcQID and
		a.application_id = 535;

Line: 1647

	select a.concurrent_queue_id
	from fnd_concurrent_queues a
	where upper(a.concurrent_queue_name) = upper(ConcQName);

Line: 1791

      select count(*)count, msg_state
      from AQ$XDP_ORDER_PROCESSOR_QTAB
      group by msg_state;

Line: 1797

    select count(*)count, status_code
    from xdp_order_headers
    group by status_code;

Line: 1803

      select count(*)count, msg_state
      from AQ$XDP_WORKITEM_QTAB
      group by msg_state;

Line: 1809

    select count(*)count, status_code
    from XDP_FULFILL_WORKLIST
    group by status_code;

Line: 1815

     select count(*)count, msg_state
     from AQ$XDP_FA_QTAB
     group by msg_state;

Line: 1821

    select count(*)count, status_code
    from XDP_FA_RUNTIME_LIST
    group by status_code;

Line: 1827

     select count(*)count,msg_state
     from AQ$XDP_WF_CHANNEL_QTAB
     group by msg_state;

Line: 1833

     select count(*)count, msg_state
     from AQ$XNP_IN_TMR_QTAB
     group by msg_state;

Line: 1839

     select count(*)count, status
     FROM XNP_TIMER_REGISTRY
     group by status;

Line: 1845

     select count(*)count, msg_state
     from AQ$XNP_IN_EVT_QTAB
     group by msg_state;

Line: 1851

     select count(*)count,msg_state
     from AQ$XNP_IN_MSG_QTAB
     group by msg_state;

Line: 1857

     select count(*)count, msg_state
     from AQ$XNP_OUT_MSG_QTAB
     group by msg_state;

Line: 1863

     select count(*)count, msg_status, direction_indicator
     from XNP_MSGS
     group by msg_status,  direction_indicator;

Line: 2007

   select count(*)
   into l_fa_ready_future
   from XDP_FA_RUNTIME_LIST
   where status_code = 'WAITING_FOR_RESOURCE';

Line: 2034

   select count(*)
   into l_timer_future
   from XNP_IN_TMR_QTAB
   where nvl(time_manager_info,SYSDATE) > SYSDATE;

Line: 2073

   select count(*)
   into l_event_future
   from xnp_callback_events xce,
   xnp_msg_types_b xmt
   where xce.msg_code = xmt.msg_code and
   xce.status = 'WAITING' and
   xmt.msg_type IN ('EVENT', 'EVT_NOHEAD');

Line: 2103

   select count(*)
   into l_in_future
   from xnp_callback_events xce,
   xnp_msg_types_b xmt
   where xce.msg_code = xmt.msg_code and
   xce.status = 'WAITING' and
   xmt.msg_type = 'MSG' and
   xmt.queue_name = 'XNP_IN_MSG_Q';