APPS.XDPCORE_WI SQL Statements

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

Line: 72

PROCEDURE UPDATE_WORKITEM_STATUS(p_workitem_instance_id IN NUMBER,
                                 p_status_code          IN VARCHAR2,
                                 p_itemtype             IN VARCHAR2,
                                 p_itemkey              IN VARCHAR2) ;

Line: 624

        SELECT workitem_id INTO l_workitemID FROM xdp_fulfill_worklist WHERE workitem_instance_id = l_WIInstanceID;

Line: 625

        SELECT workitem_name INTO l_WorkItemName from xdp_workitems WHERE workitem_id = l_workitemID;

Line: 661

   select WORKITEM_INSTANCE_ID
   from XDP_FULFILL_WORKLIST
   where ORDER_ID = Order_ID
    and LINE_ITEM_ID = LineItemID
    and status_code = 'STANDBY'
    ORDER BY WI_SEQUENCE;

Line: 676

 select parameter_name, parameter_value
  From xdp_worklist_details
  where workitem_instance_id =  cv_wiid;

Line: 965

               update XDP_FULFILL_WORKLIST
                   set WF_ITEM_TYPE = l_WFItemType,
                       WF_ITEM_KEY = l_WFItemKey,
                       LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
                       LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
               where   WORKITEM_INSTANCE_ID = l_WIInstanceID;

Line: 1000

               update XDP_FULFILL_WORKLIST
                   set WF_ITEM_TYPE = l_WFItemType,
                       WF_ITEM_KEY = l_WFItemKey,
                       LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
                       LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
               where   WORKITEM_INSTANCE_ID = l_WIInstanceID;

Line: 1050

/* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */

               update XDP_FULFILL_WORKLIST
                   set WF_ITEM_TYPE = l_WFItemType,
                       WF_ITEM_KEY = l_WFItemKey,
                       LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
                       LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
               where   WORKITEM_INSTANCE_ID = l_WIInstanceID;

Line: 1131

   select WORKITEM_INSTANCE_ID, WORKITEM_ID, PRIORITY
   from XDP_FULFILL_WORKLIST
   where ORDER_ID = Order_ID
    and LINE_ITEM_ID = LineItemID
    and status_code = 'STANDBY'
    and WI_SEQUENCE = 0;

Line: 1311

               update XDP_FULFILL_WORKLIST
                   set WF_ITEM_TYPE = l_WFItemType,
                       WF_ITEM_KEY = l_WFItemKey,
                       LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
                       LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
               where   WORKITEM_INSTANCE_ID = p_WIInstanceID;

Line: 1348

               update XDP_FULFILL_WORKLIST
                   set WF_ITEM_TYPE = l_WFItemType,
                       WF_ITEM_KEY = l_WFItemKey,
                       LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
                       LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
               where   WORKITEM_INSTANCE_ID = p_WIInstanceID;

Line: 1398

          /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */

               update XDP_FULFILL_WORKLIST
                   set WF_ITEM_TYPE = l_WFItemType,
                       WF_ITEM_KEY = l_WFItemKey,
                       LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
                       LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
               where   WORKITEM_INSTANCE_ID = p_WIInstanceID;

Line: 1443

   select WI_TYPE_CODE, NVL(USER_WF_ITEM_TYPE,null) ITEM_TYPE,
	  NVL(USER_WF_ITEM_KEY_PREFIX, null) ITEM_KEY_PREFIX ,
          NVL(USER_WF_PROCESS_NAME, null) PROCESS_NAME,
	  NVL(WF_EXEC_PROC, null) WF_EXEC_PROC,
          NVL(FA_EXEC_MAP_PROC, null) FA_EXEC_MAP_PROC
   from XDP_WORKITEMS
    where WORKITEM_ID = CheckIfWorkItemIsaWorkflow.workitem_ID;

Line: 1479

     select 'Y' yahoo
      from dual
      where exists (select WORKITEM_INSTANCE_ID
                    from XDP_FULFILL_WORKLIST
                    where ORDER_ID = p_OrderID
                      and status_code   in ('READY','IN PROGRESS') );

Line: 1496

     select 'Y' into l_Continue from dual
      where exists (select WORKITEM_INSTANCE_ID
                    from XDP_FULFILL_WORKLIST
                    where ORDER_ID = l_OrderID
                      and status_code   = 'READY' );

Line: 1536

    /* Update the STATUS of the Workitems to be processed */

       UPDATE_WORKITEM_STATUS(p_workitem_instance_id => l_WIInstanceID,
                              p_status_code          => 'IN PROGRESS',
                              p_itemtype             => InitializeWorkitemProcess.itemtype,
                              p_itemkey              => InitializeWorkitemProcess.itemkey );

Line: 1576

    SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;

Line: 1679

   select WORKITEM_INSTANCE_ID, WORKITEM_ID, PRIORITY
   from XDP_FULFILL_WORKLIST
   where ORDER_ID = Order_ID
    and LINE_ITEM_ID = LineItemID
    and status_code = 'STANDBY'
    and WI_SEQUENCE = 0;

Line: 1687

   select WORKITEM_INSTANCE_ID
   from XDP_FULFILL_WORKLIST
   where ORDER_ID = Order_ID
    and LINE_ITEM_ID = LineItemID
    and status_code = 'STANDBY'
    and WI_SEQUENCE > 0;

Line: 1732

     select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;

Line: 1793

     select to_char(XDP_WF_ITEMKEY_S.NEXTVAL) into l_tempKey from dual;

Line: 2070

               update XDP_FULFILL_WORKLIST
                   set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
                       WF_ITEM_KEY = t_ChildKeys(l_Counter),
                       LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
                       LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
               where   WORKITEM_INSTANCE_ID = l_WIInstanceID;

Line: 2115

               update XDP_FULFILL_WORKLIST
                   set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
                       WF_ITEM_KEY = t_ChildKeys(l_Counter),
                       LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
                       LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
               where   WORKITEM_INSTANCE_ID = l_WIInstanceID;

Line: 2191

          /* Update the XDP_FULFILL_WORKLIST table with the User defined Workitem Item Type and Item Key */

               update XDP_FULFILL_WORKLIST
                   set WF_ITEM_TYPE = t_ChildTypes(l_Counter),
                       WF_ITEM_KEY = t_ChildKeys(l_Counter),
                       LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
                       LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
               where   WORKITEM_INSTANCE_ID = l_WIInstanceID;

Line: 2356

  select status_code, line_item_id from
  XDP_FULFILL_WORKLIST
  where workitem_instance_id = p_WIInstanceID
  for update;

Line: 2362

  select status_code from
  xdp_order_line_items
  where line_item_id  = p_LineItemID
  for update;

Line: 2431

PROCEDURE UPDATE_WORKITEM_STATUS(p_workitem_instance_id IN NUMBER,
                                 p_status_code          IN VARCHAR2,
                                 p_itemtype             IN VARCHAR2,
                                 p_itemkey              IN VARCHAR2) IS
 PRAGMA AUTONOMOUS_TRANSACTION ;

Line: 2439

    UPDATE xdp_fulfill_worklist
       SET status_code          = p_status_code ,
           wf_item_type         = p_itemtype ,
           wf_item_key          = p_itemkey ,
           last_update_date     = sysdate,
           last_updated_by      = fnd_global.user_id,
           last_update_login    = fnd_global.login_id
     WHERE workitem_instance_id = p_workitem_instance_id;

Line: 2452

          x_Progress := 'XDPCORE_WI.UPDATE_WORKITEM_STATUS. Unhandled Exception: ' || SUBSTR(SQLERRM, 1,1500);

Line: 2453

          wf_core.context('XDPCORE_WI', 'UPDATE_WORKITEM_STATUS', p_itemtype, p_itemkey, null, x_Progress);

Line: 2457

END UPDATE_WORKITEM_STATUS ;

Line: 2466

     SELECT provisioning_date
       INTO l_prov_date
       FROM xdp_fulfill_worklist
      WHERE workitem_instance_id = p_workitem_instance_id ;

Line: 2494

   SELECT wis.role_name  INTO l_wi_responsiblilty
   FROM  xdp_workitems wis
   WHERE  wis.workitem_id in ( select lst.workitem_id
                             from  xdp_fulfill_worklist lst
                             WHERE  lst.workitem_instance_id = l_WIInstanceID);

Line: 2526

   select 'Y'
   from XDP_FULFILL_WORKLIST
   where ORDER_ID = Order_ID
    and LINE_ITEM_ID = LineItemID
    and status_code = 'STANDBY'
    and WI_SEQUENCE = 0;

Line: 2534

   select 'Y'
   from XDP_FULFILL_WORKLIST
   where ORDER_ID = Order_ID
    and LINE_ITEM_ID = LineItemID
    and status_code = 'STANDBY'
    and WI_SEQUENCE > 0;

Line: 2591

 SELECT display_name into l_display_name
 FROM XDP_WORKITEMS_VL wis
 WHERE wis.workitem_id IN ( SELECT lst.workitem_id
                          FROM xdp_fulfill_worklist lst
                        WHERE  workitem_instance_id = p_WIInstanceID );

Line: 2613

    UPDATE xdp_worklist_details
       SET parameter_value = p_newParamValue,
           is_value_evaluated = 'Y',
           modified_flag = 'Y',
           last_updated_by = FND_GLOBAL.USER_ID,
           last_update_date = sysdate,
           last_update_login = FND_GLOBAL.LOGIN_ID
     WHERE workitem_instance_id = p_WIInstanceID
       AND parameter_name = p_parameterName;

Line: 2623

    UPDATE xdp_worklist_details
       SET parameter_value = p_newParamValue,
           modified_flag = 'Y',
           last_updated_by = FND_GLOBAL.USER_ID,
           last_update_date = sysdate,
           last_update_login = FND_GLOBAL.LOGIN_ID
     WHERE workitem_instance_id = p_WIInstanceID
       AND parameter_name = p_parameterName;