APPS.XDP_AQ_UTILITIES SQL Statements

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

Line: 35

  select
    internal_q_name,
    queue_table_name,
    payload_type,
    exception_queue_name,
    NVL(max_retries,0) max_retries,
    is_aq_flag
  from
   xdp_dq_configuration;

Line: 165

  select
    internal_q_name
  from
   xdp_dq_configuration
  where
   is_aq_flag = 'Y';

Line: 192

  select
    distinct queue_table_name
  from
   xdp_dq_configuration
  where
   is_aq_flag = 'Y';

Line: 264

	update XDP_ORDER_HEADERS
	set
      last_updated_by = FND_GLOBAL.USER_ID,
      last_update_date = sysdate,
      last_update_login = FND_GLOBAL.LOGIN_ID,
	  STATE = 'WAIT',
	  MSGID = lv_MsgID
	where
		order_id = p_order_id;

Line: 274

	update XDP_ORDER_LINE_ITEMS
	set
      last_updated_by = FND_GLOBAL.USER_ID,
      last_update_date = sysdate,
      last_update_login = FND_GLOBAL.LOGIN_ID,
	  STATE = 'WAIT'
	where
		order_id = p_order_id and
		state = 'PREPROCESS';

Line: 317

	select msgid
 	 from xdp_pending_order_qtab;

Line: 361

	  select state,previous_order_id,priority, provisioning_date
	  into lv_state,lv_order_id,lv_priority, lv_prov_date
	  from xdp_order_headers
	  where
	    order_id = lv_wf_object.order_id;

Line: 368

	  -- Update the msg delay to new high number
	    null;

Line: 374

		  select state into lv_state2
		  from xdp_order_headers
		  where order_id = lv_order_id;

Line: 526

	  select state,previous_order_id,priority, provisioning_date
	  into lv_state,lv_order_id,lv_priority,lv_prov_date
	  from xdp_order_headers
	  where
	    order_id = lv_wf_object.order_id;

Line: 533

	   ---  Update the msg delay to new high number
	    null;

Line: 539

		  select state into lv_state2
		  from xdp_order_headers
		  where order_id = lv_order_id;

Line: 668

	update XDP_ORDER_HEADERS
	   set last_updated_by   = FND_GLOBAL.USER_ID,
               last_update_date  = sysdate,
               last_update_login = FND_GLOBAL.LOGIN_ID,
               status_code            = 'READY',
	       MSGID             = lv_MsgID
	 where order_id          = p_order_id;

Line: 676

	update XDP_ORDER_LINE_ITEMS
	   set last_updated_by   = FND_GLOBAL.USER_ID,
               last_update_date  = sysdate,
               last_update_login = FND_GLOBAL.LOGIN_ID,
               status_code            = 'READY'
	 where order_id = p_order_id
           and status_code = 'STANDBY';

Line: 751

	  SELECT status_code
	    INTO lv_state
	    FROM xdp_order_headers
	   WHERE order_id = lv_wf_object.order_id;

Line: 924

   select  xw.workitem_name workitem_name
    from xdp_workitems xw,
	 xdp_fulfill_worklist xfw
    where xfw.workitem_instance_id = p_wi_instance_id
      and xfw.workitem_id = xw.workitem_id;

Line: 968

	update XDP_FULFILL_WORKLIST
	   set last_updated_by      = FND_GLOBAL.USER_ID,
               last_update_date     = sysdate,
               last_update_login    = FND_GLOBAL.LOGIN_ID,
	       STATUS_CODE          = 'READY',
	       MSGID                = lv_MsgID
	 where workitem_instance_id = p_wi_instance_id;

Line: 1037

	  select status_code
	  into lv_state
	  from xdp_fulfill_worklist
	  where
	    workitem_instance_id = lv_wf_object.workitem_instance_id;

Line: 1058

			update XDP_FULFILL_WORKLIST
			   set last_updated_by      = FND_GLOBAL.USER_ID,
      			       last_update_date     = sysdate,
      			       last_update_login    = FND_GLOBAL.LOGIN_ID,
	  		       STATUS_CODE          = 'IN PROGRESS'
			 where workitem_instance_id = lv_wf_object.workitem_instance_id;

Line: 1164

			XDPSTATUS.UPDATE_XDP_WORKITEM_STATUS(
				p_status => 'IN PROGRESS',
				p_workitem_instance_id => lv_wf_object.workitem_instance_id);

Line: 1229

         select  xf.fulfillment_action fulfillment_action
           from xdp_fulfill_actions xf,
	        xdp_fa_runtime_list xfr
          where xfr.fa_instance_id = p_fa_instance_id
           and xfr.fulfillment_action_id = xf.fulfillment_action_id;

Line: 1267

	update XDP_FA_RUNTIME_LIST
	   set last_updated_by   = FND_GLOBAL.USER_ID,
               last_update_date  = sysdate,
               last_update_login = FND_GLOBAL.LOGIN_ID,
	       STATUS_CODE       = 'READY',
	       MSGID             = lv_MsgID
	where fa_instance_id     = p_fa_instance_id;

Line: 1339

          SELECT status_code
	    INTO lv_state
	    FROM xdp_fa_runtime_list
	   WHERE fa_instance_id = lv_wf_object.fa_instance_id;

Line: 1535

   UPDATE xdp_fa_runtime_list
      SET status_code = 'READY_FOR_RESOURCE' ,
	  msgid = lv_MsgID
    WHERE fa_instance_id = p_fa_instance_id ;

Line: 1615

      SELECT frt.status_code,
             fwt.status_code
        INTO lv_fa_state,
             lv_wi_state
        FROM xdp_fa_runtime_list frt,
             xdp_fulfill_worklist fwt
       WHERE fa_instance_id           = lv_wf_object.fa_instance_id
         AND frt.workitem_instance_id = fwt.workitem_instance_id;

Line: 1746

	SELECT frt.status_code
	INTO lv_fa_state
	FROM xdp_fa_runtime_list frt
	WHERE fa_instance_id = lv_wf_object.fa_instance_id;

Line: 2060

  SELECT state
    INTO lv_q_state
    FROM XDP_dq_configuration
   WHERE internal_q_name = p_queue_name;

Line: 2090

   select rowid
   from xdp_dq_configuration;

Line: 2097

      update XDP_dq_configuration
      set last_updated_by = FND_GLOBAL.USER_ID,
      last_update_date = sysdate,
      last_update_login = FND_GLOBAL.LOGIN_ID,
      state = 'DISABLED'
      where internal_q_name = UPPER(p_queue_name);

Line: 2105

        update XDP_dq_configuration
        set state = 'DISABLED',
      	last_updated_by = FND_GLOBAL.USER_ID,
      	last_update_date = sysdate,
      	last_update_login = FND_GLOBAL.LOGIN_ID
	  where rowid = lv_rec.rowid;

Line: 2133

   select rowid
   from xdp_dq_configuration;

Line: 2140

      update XDP_dq_configuration
      set state = 'ENABLED',
      last_updated_by = FND_GLOBAL.USER_ID,
      last_update_date = sysdate,
      last_update_login = FND_GLOBAL.LOGIN_ID
      where internal_q_name = UPPER(p_queue_name);

Line: 2148

        update XDP_dq_configuration
        set state = 'ENABLED',
      last_updated_by = FND_GLOBAL.USER_ID,
      last_update_date = sysdate,
      last_update_login = FND_GLOBAL.LOGIN_ID
	  where rowid = lv_rec.rowid;

Line: 2175

   select rowid
   from xdp_dq_configuration;

Line: 2181

      update XDP_dq_configuration
      set state = 'SHUTDOWN',
      last_updated_by = FND_GLOBAL.USER_ID,
      last_update_date = sysdate,
      last_update_login = FND_GLOBAL.LOGIN_ID
      where internal_q_name = UPPER(p_queue_name);

Line: 2189

        update XDP_dq_configuration
        set state = 'SHUTDOWN',
      last_updated_by = FND_GLOBAL.USER_ID,
      last_update_date = sysdate,
      last_update_login = FND_GLOBAL.LOGIN_ID
	  where rowid = lv_rec.rowid;

Line: 2344

  * Insert into the audit trail table.
  */
 INSERT INTO XDP_FE_CMD_AUD_TRAILS (
               created_by,
               creation_date,
               last_updated_by,
               last_update_date,
               last_update_login,
               fa_instance_id,
               fe_command_seq,
               fulfillment_element_name,
               fulfillment_element_type,
               sw_generic,
               command_sent,
               command_sent_date,
               response,
	       response_long,
               response_date,
               provisioning_procedure)
              VALUES (
	       FND_GLOBAL.USER_ID,
	       sysdate,
	       FND_GLOBAL.USER_ID,
	       sysdate,
	       FND_GLOBAL.LOGIN_ID,
               FAInstanceID,
               XDP_FE_CMD_AUD_TRAILS_S.NEXTVAL,
               l_FeName,
               l_FeType,
               l_Sw_Generic,
               l_CommandSent,
               SentDate,
               l_Response,
               ResponseLong,
               RespDate,
               ProcName);

Line: 2448

  * Insert into the audit trail table.
  */
 INSERT INTO XDP_FE_CMD_AUD_TRAILS (
               created_by,
               creation_date,
               last_updated_by,
               last_update_date,
               last_update_login,
               fa_instance_id,
               fe_command_seq,
               fulfillment_element_name,
               fulfillment_element_type,
               sw_generic,
               command_sent,
               command_sent_date,
               response,
	       response_long,
               response_date,
               provisioning_procedure)
              VALUES (
	       FND_GLOBAL.USER_ID,
	       sysdate,
	       FND_GLOBAL.USER_ID,
	       sysdate,
	       FND_GLOBAL.LOGIN_ID,
               FAInstanceID,
               XDP_FE_CMD_AUD_TRAILS_S.NEXTVAL,
               l_FeName,
               l_FeType,
               l_Sw_Generic,
               l_CommandSent,
               SentDate,
               l_Response,
               l_ResponseLong,
               RespDate,
               ProcName);

Line: 3195

        SELECT provisioning_date
          INTO l_prov_date
        FROM xdp_fulfill_worklist
        WHERE workitem_instance_id = p_workitem_instance_id ;

Line: 3602

        SELECT consumer_name
        FROM AQ$XNP_OUT_MSG_QTAB a
        WHERE a.user_data = l_msg
	  AND a.queue = 'XNP_OUT_MSG_EXCEPTION_Q';

Line: 3612

    UPDATE xnp_msgs
    SET msg_status = 'READY',
        last_update_date = SYSDATE
    WHERE msg_id = l_msg_header.message_id;

Line: 3733

			SELECT order_id
		         INTO l_order_id
			FROM xnp_msgs
			WHERE msg_id = object_id;

Line: 3744

	SELECT count(*)
         INTO l_count
        FROM fnd_lookup_values
        WHERE UPPER(lookup_code) = ( SELECT UPPER(order_type)
	                	     FROM xdp_order_headers
				     WHERE order_id = l_order_id )
        AND lookup_type = 'XDP_HA_ORDER_TYPES';

Line: 3787

  select nvl(min(queued_on), sysdate)-1 into l_ReProcessEnqTime from xdp_adapter_job_queue;

Line: 3808

                select FE_ID into l_FeID from xdp_fes
                               where fulfillment_element_name = lv_wf_object.FE_NAME;

Line: 3811

		insert into XDP_ADAPTER_JOB_QUEUE (
                                   JOB_ID,
                                   FE_ID,
                                   ORDER_ID,
                                   WORKITEM_INSTANCE_ID,
                                   FA_INSTANCE_ID,
                                   QUEUED_ON,
                                   WF_ITEM_TYPE,
                                   CHANNEL_USAGE_CODE,
                                   WF_ITEM_KEY,
                                   SYSTEM_HOLD,
                                   created_by,
                                   creation_date,
                                   last_updated_by,
                                   last_update_date,
                                   last_update_login
                                   )
                           values (XDP_ADAPTER_JOB_QUEUE_S.NEXTVAL,
                                   l_FeID,
                                   lv_wf_object.ORDER_ID,
                                   lv_wf_object.WORKITEM_INSTANCE_ID,
                                   lv_wf_object.FA_INSTANCE_ID,
                                   l_ReProcessEnqTime,
                                   lv_wf_object.WF_ITEM_TYPE,
                                   'NORMAL',
                                   lv_wf_object.WF_ITEM_KEY,
                                   'N',
                                   FND_GLOBAL.USER_ID,
                                   sysdate,
                                   FND_GLOBAL.USER_ID,
                                   sysdate,
                                   FND_GLOBAL.LOGIN_ID);

Line: 3862

            SELECT nvl(substr(value,1,instr(value,',')-1),value)
              INTO g_logdir
            FROM v$parameter
            WHERE name = 'utl_file_dir';

Line: 3867

            select sysdate into g_logdate from dual;