APPS.XDPCORE_BUNDLE SQL Statements

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

Line: 192

PROCEDURE UPDATE_BUNDLE_STATUS(p_bundle_id   IN NUMBER,
                               p_order_id    IN NUMBER,
                               p_status_code IN VARCHAR2,
                               p_itemtype    IN VARCHAR2,
                               p_itemkey     IN VARCHAR2) IS
PRAGMA AUTONOMOUS_TRANSACTION ;

Line: 201

      UPDATE xdp_order_bundles
         SET status            = p_status_code ,
             last_update_date  = sysdate ,
             last_updated_by   = fnd_global.user_id ,
             last_update_login = fnd_global.login_id
       WHERE order_id          = p_order_id
         AND bundle_id         = p_bundle_id ;

Line: 212

          x_Progress := 'XDPCORE_BUNDLE.UPDATE_BUNDLE_STATUS. Unhandled Exception: ' || SUBSTR(SQLERRM, 1, 2000);

Line: 213

          wf_core.context('XDPCORE_BUNDLE', 'UPDATE_BUNDLE_STATUS', p_itemtype, p_itemkey, null, x_Progress);

Line: 216

END UPDATE_BUNDLE_STATUS ;

Line: 443

  select BUNDLE_ID
   from XDP_ORDER_LINE_ITEMS
   where ORDER_ID = OrderID
    and STATUS_CODE    = 'READY'
    and BUNDLE_SEQUENCE = (select min(BUNDLE_SEQUENCE)
                     from XDP_ORDER_LINE_ITEMS
                     where ORDER_ID = OrderID
                       and STATUS_CODE    = 'READY'
                       and BUNDLE_SEQUENCE > BundleSeq);

Line: 530

  select distinct(NVL(BUNDLE_ID, -1))
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and STATUS_CODE   = 'READY'
    and (BUNDLE_SEQUENCE is null) OR (BUNDLE_SEQUENCE = 0);

Line: 537

  select BUNDLE_ID
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and STATUS_CODE   = 'READY'
   and BUNDLE_ID IS NOT NULL
   and BUNDLE_SEQUENCE > 0;

Line: 575

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

Line: 648

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

Line: 770

  select LINE_ITEM_ID, IS_PACKAGE_FLAG
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and IS_VIRTUAL_LINE_FLAG = 'N'
    and STATUS_CODE = 'READY'
    and BUNDLE_ID is null
    and LINE_SEQUENCE = 0;

Line: 779

  select LINE_ITEM_ID, IS_PACKAGE_FLAG
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and IS_VIRTUAL_LINE_FLAG = 'N'
    and STATUS_CODE = 'READY'
    and BUNDLE_ID is null
    and LINE_SEQUENCE > 0;

Line: 789

  select LINE_ITEM_ID, IS_PACKAGE_FLAG
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and IS_VIRTUAL_LINE_FLAG = 'N'
    and STATUS_CODE = 'READY'
    and BUNDLE_ID  = BundleID
    and LINE_SEQUENCE = 0;

Line: 798

  select LINE_ITEM_ID, IS_PACKAGE_FLAG
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and IS_VIRTUAL_LINE_FLAG = 'N'
    and STATUS_CODE = 'READY'
    and BUNDLE_ID  = BundleID
    and LINE_SEQUENCE > 0;

Line: 861

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

Line: 940

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

Line: 1038

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

Line: 1118

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

Line: 1233

  select DISTINCT(BUNDLE_ID), BUNDLE_SEQUENCE
   from XDP_ORDER_LINE_ITEMS
   where ORDER_ID = OrderID
    and STATUS_CODE = 'READY'
    and BUNDLE_ID >= 0
    and BUNDLE_SEQUENCE = (select min(BUNDLE_SEQUENCE)
                     from XDP_ORDER_LINE_ITEMS
                     where ORDER_ID = OrderID
                       and STATUS_CODE = 'READY'
                       and BUNDLE_ID >= 0
                       and BUNDLE_SEQUENCE > BundleSeq);

Line: 1256

  select LINE_ITEM_ID, IS_PACKAGE_FLAG
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and IS_VIRTUAL_LINE_FLAG = 'N'
    and STATUS_CODE = 'READY'
    and BUNDLE_ID  = BundleID
    and LINE_SEQUENCE = 0;

Line: 1265

  select LINE_ITEM_ID, IS_PACKAGE_FLAG
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and IS_VIRTUAL_LINE_FLAG = 'N'
    and STATUS_CODE = 'READY'
    and BUNDLE_ID  = BundleID
    and LINE_SEQUENCE > 0;

Line: 1312

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

Line: 1393

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

Line: 1529

           UPDATE_BUNDLE_STATUS(p_bundle_id   => l_BundleID,
                                p_order_id    => l_OrderID,
                                p_status_code => 'IN PROGRESS',
                                p_itemtype    => InitializeBundle.itemtype,
                                p_itemkey     => InitializeBundle.itemkey) ;

Line: 1563

  select 'Y'
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and STATUS_CODE   = 'READY'
    and ( (BUNDLE_SEQUENCE is null) OR (BUNDLE_SEQUENCE = 0));

Line: 1570

  select 'Y'
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and STATUS_CODE   = 'READY'
   and BUNDLE_ID IS NOT NULL
   and BUNDLE_SEQUENCE > 0;

Line: 1621

  select distinct(NVL(BUNDLE_ID, -1)) BUNDLE_ID
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and STATUS_CODE   = 'READY'
    and ((BUNDLE_SEQUENCE is null) OR (BUNDLE_SEQUENCE = 0));

Line: 1651

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

Line: 1746

  select DISTINCT(BUNDLE_ID) BUNDLE_ID, BUNDLE_SEQUENCE
   from XDP_ORDER_LINE_ITEMS
   where ORDER_ID = OrderID
    and STATUS_CODE = 'READY'
    and BUNDLE_ID >= 0
    and BUNDLE_SEQUENCE = (select min(BUNDLE_SEQUENCE)
                     from XDP_ORDER_LINE_ITEMS
                     where ORDER_ID = OrderID
                       and STATUS_CODE = 'READY'
                       and BUNDLE_ID >= 0
                       and BUNDLE_SEQUENCE > BundleSeq);

Line: 1783

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

Line: 1866

  select 'Y'
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and IS_VIRTUAL_LINE_FLAG = 'N'
    and STATUS_CODE = 'READY'
    and BUNDLE_ID is null
    and LINE_SEQUENCE = 0;

Line: 1876

  select 'Y'
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and IS_VIRTUAL_LINE_FLAG = 'N'
    and STATUS_CODE = 'READY'
    and BUNDLE_ID is null
    and LINE_SEQUENCE > 0;

Line: 1885

  select 'Y'
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and IS_VIRTUAL_LINE_FLAG = 'N'
    and STATUS_CODE = 'READY'
    and BUNDLE_ID  = BundleID
    and LINE_SEQUENCE = 0;

Line: 1895

  select 'Y'
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and IS_VIRTUAL_LINE_FLAG = 'N'
    and STATUS_CODE = 'READY'
    and BUNDLE_ID  = BundleID
    and LINE_SEQUENCE > 0;