APPS.XDPCORE_PKG SQL Statements

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

Line: 34

PROCEDURE UPDATE_PACKAGESERVICE_STATUS (p_line_item_id IN NUMBER,
                                        p_status_code  IN VARCHAR2,
                                        p_itemtype     IN VARCHAR2,
                                        p_itemkey      IN VARCHAR2) ;

Line: 194

PROCEDURE UPDATE_PACKAGESERVICE_STATUS (p_line_item_id IN NUMBER,
                                        p_status_code  IN VARCHAR2,
                                        p_itemtype     IN VARCHAR2,
                                        p_itemkey      IN VARCHAR2) IS
PRAGMA AUTONOMOUS_TRANSACTION ;

Line: 203

      UPDATE xdp_order_line_items
         SET status_code       = p_status_code,
             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: 213

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

Line: 214

          wf_core.context('XDPCORE_PKG', 'UPDATE_PACKAGESERVICE_STATUS', p_itemtype, p_itemkey, null,null);

Line: 217

END UPDATE_PACKAGESERVICE_STATUS;

Line: 357

  SELECT XOL.LINE_ITEM_ID
    FROM XDP_LINE_RELATIONSHIPS XLR,
         XDP_ORDER_LINE_ITEMS XOL
   WHERE XLR.RELATED_LINE_ITEM_ID = LineItemID
     AND XLR.LINE_RELATIONSHIP    IN ('IS_PART_OF_PACKAGE','IS_PART_OF_IB_EXPLOSION')
     AND XOL.LINE_ITEM_ID         = XLR.LINE_ITEM_ID
     AND XOL.STATUS_CODE                = 'READY'
     AND XOL.IS_VIRTUAL_LINE_FLAG = 'Y'
     AND (SEQ_IN_PACKAGE IS NULL OR SEQ_IN_PACKAGE = 0);

Line: 368

  SELECT XOL.LINE_ITEM_ID
    FROM XDP_LINE_RELATIONSHIPS XLR, XDP_ORDER_LINE_ITEMS XOL
   WHERE XLR.RELATED_LINE_ITEM_ID = LineItemID
     AND XLR.LINE_RELATIONSHIP    IN ('IS_PART_OF_PACKAGE','IS_PART_OF_IB_EXPLOSION')
     AND XOL.LINE_ITEM_ID         = XLR.LINE_ITEM_ID
     AND XOL.STATUS_CODE                = 'READY'
     AND XOL.IS_VIRTUAL_LINE_FLAG = 'Y'
     AND SEQ_IN_PACKAGE > 0;

Line: 409

     SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) INTO l_tempKey FROM dual;

Line: 454

     SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) INTO l_tempKey FROM dual;

Line: 560

   SELECT XOl.LINE_ITEM_ID, XOL.SEQ_IN_PACKAGE
   FROM XDP_ORDER_LINE_ITEMS XOL, XDP_LINE_RELATIONSHIPS XLR
   WHERE XLR.RELATED_LINE_ITEM_ID = LineItemID
     AND XLR.LINE_RELATIONSHIP    = 'IS_PART_OF_PACKAGE'
     AND XOL.LINE_ITEM_ID         = XLR.LINE_ITEM_ID
     AND XOL.STATUS_CODE               = 'READY'
     AND XOL.IS_VIRTUAL_LINE_FLAG = 'Y'
     AND XOL.SEQ_IN_PACKAGE  = (
                            SELECT MIN(XOL1.SEQ_IN_PACKAGE)
                            FROM XDP_ORDER_LINE_ITEMS XOL1, XDP_LINE_RELATIONSHIPS XLR1
                            WHERE XLR1.RELATED_LINE_ITEM_ID   = LineItemID
                                AND XLR1.LINE_RELATIONSHIP    = 'IS_PART_OF_PACKAGE'
                                AND XOL1.LINE_ITEM_ID         = XLR1.LINE_ITEM_ID
                                AND XOL1.STATUS_CODE               = 'READY'
                                AND XOL1.IS_VIRTUAL_LINE_FLAG = 'Y'
                                AND XOL1.SEQ_IN_PACKAGE  > Seq);

Line: 652

   SELECT XOl.LINE_ITEM_ID, XOL.SEQ_IN_PACKAGE
     FROM XDP_ORDER_LINE_ITEMS XOL,
          XDP_LINE_RELATIONSHIPS XLR
    WHERE XLR.RELATED_LINE_ITEM_ID = LineItemID
      AND XLR.LINE_RELATIONSHIP    = 'IS_PART_OF_PACKAGE'
      AND XOL.LINE_ITEM_ID         = XLR.LINE_ITEM_ID
      AND XOL.STATUS_CODE               = 'READY'
      AND XOL.IS_VIRTUAL_LINE_FLAG = 'Y'
      AND XOL.SEQ_IN_PACKAGE       = (
                            SELECT MIN(XOL1.SEQ_IN_PACKAGE)
                              FROM XDP_ORDER_LINE_ITEMS XOL1,
                                   XDP_LINE_RELATIONSHIPS XLR1
                             WHERE XLR1.RELATED_LINE_ITEM_ID = LineItemID
                               AND XLR1.LINE_RELATIONSHIP    = 'IS_PART_OF_PACKAGE'
                               AND XOL1.LINE_ITEM_ID         = XLR1.LINE_ITEM_ID
                               AND XOL1.STATUS_CODE               = 'READY'
                               AND XOL1.IS_VIRTUAL_LINE_FLAG = 'Y'
                               AND XOL1.SEQ_IN_PACKAGE  > Seq);

Line: 713

    SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) INTO l_tempKey FROM dual;

Line: 822

    UPDATE_PACKAGESERVICE_STATUS (p_line_item_id => l_LineItemID,
                                  p_status_code  => 'IN PROGRESS',
                                  p_itemtype     => itemtype,
                                  p_itemkey      => itemkey);

Line: 845

  SELECT 'Y'
    FROM XDP_LINE_RELATIONSHIPS XLR,
         XDP_ORDER_LINE_ITEMS XOL
   WHERE XLR.RELATED_LINE_ITEM_ID = LineItemID
     AND XLR.LINE_RELATIONSHIP    IN ('IS_PART_OF_PACKAGE','IS_PART_OF_IB_EXPLOSION')
     AND XOL.LINE_ITEM_ID         = XLR.LINE_ITEM_ID
     AND XOL.STATUS_CODE                = 'READY'
     AND XOL.IS_VIRTUAL_LINE_FLAG = 'Y'
     AND (SEQ_IN_PACKAGE IS NULL OR SEQ_IN_PACKAGE = 0);

Line: 856

  SELECT 'Y'
    FROM XDP_LINE_RELATIONSHIPS XLR, XDP_ORDER_LINE_ITEMS XOL
   WHERE XLR.RELATED_LINE_ITEM_ID = LineItemID
     AND XLR.LINE_RELATIONSHIP    IN ('IS_PART_OF_PACKAGE','IS_PART_OF_IB_EXPLOSION')
     AND XOL.LINE_ITEM_ID         = XLR.LINE_ITEM_ID
     AND XOL.STATUS_CODE                = 'READY'
     AND XOL.IS_VIRTUAL_LINE_FLAG = 'Y'
     AND SEQ_IN_PACKAGE > 0;

Line: 914

  SELECT XOL.LINE_ITEM_ID
    FROM XDP_LINE_RELATIONSHIPS XLR,
         XDP_ORDER_LINE_ITEMS XOL
   WHERE XLR.RELATED_LINE_ITEM_ID = LineItemID
     AND XLR.LINE_RELATIONSHIP    IN ('IS_PART_OF_PACKAGE','IS_PART_OF_IB_EXPLOSION')
     AND XOL.LINE_ITEM_ID         = XLR.LINE_ITEM_ID
     AND XOL.STATUS_CODE                = 'READY'
     AND XOL.IS_VIRTUAL_LINE_FLAG = 'Y'
     AND (SEQ_IN_PACKAGE IS NULL OR SEQ_IN_PACKAGE = 0);

Line: 948

     SELECT to_char(XDP_WF_ITEMKEY_S.NEXTVAL) INTO l_tempKey FROM dual;