APPS.XDPCORE_LINE SQL Statements

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

Line: 61

Procedure UpdateInstallBase(itemtype in varchar2,
                            itemkey  in varchar2
                            );

Line: 311

Procedure UPDATE_INSTALL_BASE (itemtype        in varchar2,
                               itemkey         in varchar2,
                               actid           in number,
                               funcmode        in varchar2,
                               resultout       OUT NOCOPY varchar2) IS

l_result varchar2(10);

Line: 324

                UpdateInstallBase(itemtype, itemkey);

Line: 334

 wf_core.context('XDPCORE_LINE', 'UPDATE_INSTALL_BASE', itemtype, itemkey, to_char(actid), funcmode);

Line: 336

END UPDATE_INSTALL_BASE;

Line: 843

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

Line: 930

       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: 1262

  select LINE_ITEM_ID, IS_PACKAGE_FLAG, PRIORITY ,IB_SOURCE, NVL(IB_SOURCE_ID,-999) IB_SOURCE_ID
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and IS_VIRTUAL_LINE_FLAG = 'N'
    and STATUS_CODE = 'READY'
    and LINE_SEQUENCE = 0;

Line: 1270

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

Line: 1312

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

Line: 1364

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

Line: 1499

  select LINE_ITEM_ID, IS_PACKAGE_FLAG, PRIORITY ,IB_SOURCE, NVL(IB_SOURCE_ID,-999) IB_SOURCE_ID
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and IS_VIRTUAL_LINE_FLAG = 'N'
    and STATUS_CODE = 'READY'
    and LINE_SEQUENCE = 0;

Line: 1533

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

Line: 1623

  select LINE_ITEM_ID, IS_PACKAGE_FLAG, PRIORITY ,IB_SOURCE, NVL(IB_SOURCE_ID,-999) IB_SOURCE_ID
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and IS_VIRTUAL_LINE_FLAG = 'N'
    and STATUS_CODE = 'READY'
    and LINE_SEQUENCE = 0
    and BUNDLE_ID = BundleID;

Line: 1632

  select  LINE_ITEM_ID, IS_PACKAGE_FLAG, PRIORITY ,IB_SOURCE, NVL(IB_SOURCE_ID,-999) IB_SOURCE_ID
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and IS_VIRTUAL_LINE_FLAG = 'N'
    and STATUS_CODE = 'READY'
    and LINE_SEQUENCE = 0
    and ((BUNDLE_ID is null) or (BUNDLE_ID = 0 ) );

Line: 1673

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

Line: 1724

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

Line: 1862

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

Line: 1940

     UPDATE xdp_order_line_items
        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 line_item_id      = p_line_item_id ;

Line: 2059

Procedure UpdateInstallBase(itemtype in varchar2,
                            itemkey in varchar2)
is
 l_OrderID number;

Line: 2071

 l_OrderID := wf_engine.GetItemAttrNumber(itemtype => UpdateInstallBase.itemtype,
                                          itemkey => UpdateInstallBase.itemkey,
                                          aname => 'ORDER_ID');

Line: 2075

 l_LineItemID := wf_engine.GetItemAttrNumber(itemtype => UpdateInstallBase.itemtype,
                                             itemkey => UpdateInstallBase.itemkey,
                                             aname => 'LINE_ITEM_ID');

Line: 2082

      XDP_INSTALL_BASE.UPDATE_IB(p_order_id => l_OrderID,
                                 p_line_id  => l_LineItemID,
                                 p_error_code   => l_errcode,
                                 p_error_description => l_error_description);

Line: 2090

			'UpdateInstallBase. Error: ' || substr(l_error_description,1,1500);

Line: 2094

 END UpdateInstallBase;

Line: 2141

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

Line: 2149

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

Line: 2202

  SELECT is_virtual_line_flag INTO l_flag
    FROM xdp_order_line_items
   WHERE line_item_id = l_LineItemID;

Line: 2244

    SELECT line_number
      INTO l_line_number
      FROM xdp_order_line_items
     WHERE line_item_id  = l_line_item_id ;