APPS.XDPSTATUS SQL Statements

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

Line: 59

Procedure UpdateFAStatus(faid in number, status in varchar2, provmode in varchar2);

Line: 1137

        UPDATE_XDP_ORDER_STATUS(l_status,l_orderID );

Line: 1143

           UPDATE_XDP_ORDER_LINE_STATUS(l_status,l_lineitemID);

Line: 1155

           UPDATE_XDP_WORKITEM_STATUS(l_status,l_WIInstanceID);

Line: 1157

           XDP_NOTIFICATIONS.Get_WI_Update_URL(l_WIInstanceID,
                                               l_OrderID,
                                               itemtype,
                                               itemKey,
                                               l_url);

Line: 1166

                                        aname => 'ERROR_WI_UPDATE_URL',
                                       avalue => l_url);

Line: 1175

           UPDATE_XDP_FA_STATUS(l_status,l_FAInstanceID);

Line: 1197

  SELECT status_code
  FROM xdp_order_line_items
  WHERE order_id = orderid ;

Line: 1237

        UPDATE_XDP_ORDER_STATUS('ERROR' , l_orderid );

Line: 1241

          UPDATE_XDP_ORDER_STATUS('SUCCESS_WITH_OVERRIDE' , l_orderid );

Line: 1245

          UPDATE_XDP_ORDER_STATUS('ABORTED' , l_orderid );

Line: 1248

        UPDATE_XDP_ORDER_STATUS('SUCCESS' , l_orderid );

Line: 1330

        SELECT STATUS_CODE,
               FA_INSTANCE_ID
          FROM XDP_FA_RUNTIME_LIST
         WHERE WORKITEM_INSTANCE_ID = WIInstanceID ;

Line: 1371

                UPDATE_XDP_WORKITEM_STATUS('ERROR' , l_WIInstanceid );

Line: 1375

                UPDATE_XDP_WORKITEM_STATUS('SUCCESS_WITH_OVERRIDE' , l_WIInstanceid );

Line: 1379

                UPDATE_XDP_WORKITEM_STATUS('ABORTED' , l_WIInstanceid );

Line: 1382

                UPDATE_XDP_WORKITEM_STATUS('SUCCESS' , l_WIInstanceid );

Line: 1403

 UPDATE_XDP_WORKITEM_STATUS('SUCCESS' , l_WIInstanceID );

Line: 1530

     UPDATE_XDP_FA_STATUS(l_FAStatus,l_FAInstanceID);

Line: 1538

     ** If the Processing of the FA is Order Resubmission Only the FA Status is to be updated
     ** The complete Order status/state logic is to be ignored
     */

     IF l_ResubmissionJobID <>0 THEN
        SetFActionStatus(l_OrderID, l_LineItemID, l_WIInstanceID, l_FAInstanceID, 'FA_RE_EXECUTION', l_Event, 'FA_'||l_FAStatus, SetFAStatus.itemtype,SetFAStatus.itemkey,ErrCode, ErrStr);

Line: 1604

 SELECT status_code
   FROM xdp_fa_runtime_list
  WHERE fa_instance_id = cp_FAInstanceID;

Line: 1637

     UPDATE_XDP_FA_STATUS(l_FeExecStatus,l_FAInstanceID);

Line: 1723

PROCEDURE UpdateFAStatus( faid     IN NUMBER,
                          status   IN VARCHAR2,
                          provmode IN VARCHAR2)
IS
l_status_code   VARCHAR2(30);

Line: 1740

       UPDATE_XDP_FA_STATUS('SUCCESS_WITH_OVERRIDE' , faid) ;

Line: 1742

       UPDATE_XDP_FA_STATUS('SUCCESS' , faid) ;

Line: 1746

       UPDATE_XDP_FA_STATUS('SUCCESS' , faid) ;

Line: 1752

          wf_core.context('XDPSTATUS', 'UpdateFAStatus', null, null, null,null);

Line: 1754

END UpdateFAStatus;

Line: 1803

        SELECT STATUS_CODE,
               WORKITEM_INSTANCE_ID
          FROM XDP_FULFILL_WORKLIST
         WHERE ORDER_ID     = OrderID
           AND LINE_ITEM_ID = LineItemID ;

Line: 1848

     UPDATE_XDP_ORDER_LINE_STATUS('ERROR' ,  l_lineitemid );

Line: 1851

     UPDATE_XDP_ORDER_LINE_STATUS('ABORTED' ,  l_lineitemid );

Line: 1854

     UPDATE_XDP_ORDER_LINE_STATUS('SUCCESS_WITH_OVERRIDE' , l_lineitemid );

Line: 1857

     UPDATE_XDP_ORDER_LINE_STATUS('SUCCESS' ,  l_lineitemid );

Line: 1903

  UPDATE_XDP_WORKITEM_STATUS(l_Status, l_WIINstanceID);

Line: 1943

          /* User selected Abort FA Processing from FMC */
          SetStatusForFA(FAInstanceID, 'ABORTED', 'STOP_FA_PROCESSING');

Line: 1966

          /* User selected Abort FA Processing from FMC */
          SetStatusForFA(FAInstanceID, 'ABORTED', 'STOP_FA_PROCESSING');

Line: 2004

        SELECT Status_code
          FROM XDP_FA_RUNTIME_LIST
         WHERE FA_INSTANCE_ID = FAInstanceID;

Line: 2024

      UPDATE_XDP_FA_STATUS(status , FAInstanceId );

Line: 2029

        UPDATE_XDP_FA_STATUS('SUCCESS_WITH_OVERRIDE' , FAInstanceId );

Line: 2032

      UPDATE_XDP_FA_STATUS('SUCCESS' , FAInstanceId );

Line: 2037

      UPDATE_XDP_FA_STATUS(status , FAInstanceId );

Line: 2040

      UPDATE_XDP_FA_STATUS(status , FAInstanceId );

Line: 2042

      UPDATE_XDP_FA_STATUS('IN PROGRESS' , FAInstanceId );

Line: 2044

      UPDATE_XDP_FA_STATUS('SYSTEM_HOLD' , FAInstanceId );

Line: 2062

        SELECT Status_code
          FROM XDP_FULFILL_WORKLIST
         WHERE WORKITEM_INSTANCE_ID = WorkitemInstanceID;

Line: 2068

        SELECT 1
          FROM XDP_FA_RUNTIME_LIST
         WHERE WORKITEM_INSTANCE_ID = WorkitemInstanceID
           AND STATUS_CODE          = 'ERROR' ;

Line: 2097

      UPDATE_XDP_WORKITEM_STATUS(Status,WorkitemInstanceID);

Line: 2108

         UPDATE_XDP_WORKITEM_STATUS('IN PROGRESS',workiteminstanceid);

Line: 2134

        SELECT Status_code,
               IS_VIRTUAL_LINE_FLAG,
               NVL(BUNDLE_ID,-999)
          FROM XDP_ORDER_LINE_ITEMS
          WHERE LINE_ITEM_ID = LineID;

Line: 2142

   SELECT line_item_id
     FROM XDP_FULFILL_WORKLIST
    WHERE WOrkitem_instance_id = WorkitemInstanceID;

Line: 2147

        SELECT STATUS_CODE,
               WORKITEM_INSTANCE_ID
          FROM XDP_FULFILL_WORKLIST
         WHERE LINE_ITEM_ID = LineID
           AND STATUS_CODE  = 'ERROR';

Line: 2154

        SELECT RELATED_LINE_ITEM_ID
          FROM XDP_LINE_RELATIONSHIPS
         WHERE LINE_ITEM_ID = VirtualLine
           AND LINE_RELATIONSHIP = 'IS_PART_OF_PACKAGE';

Line: 2159

 CURSOR c_UpdatePackage(PackageLineID number) IS
       SELECT 1
         FROM XDP_ORDER_LINE_ITEMS
        WHERE LINE_ITEM_ID  = PackageLineID;

Line: 2166

        SELECT XLR.RELATED_LINE_ITEM_ID,
               XOL.STATUS_CODE
          FROM XDP_LINE_RELATIONSHIPS XLR,
               XDP_ORDER_LINE_ITEMS XOL
         WHERE XLR.RELATED_LINE_ITEM_ID = (
                                    SELECT RELATED_LINE_ITEM_ID
                                      FROM XDP_LINE_RELATIONSHIPS
                                     WHERE LINE_ITEM_ID = VirtualLine)
           AND XLR.LINE_ITEM_ID = XOL.LINE_ITEM_ID
           AND XOL.IS_VIRTUAL_LINE_FLAG = 'Y';

Line: 2178

  SELECT LINE_ITEM_ID
   FROM XDP_ORDER_LINE_ITEMS
  WHERE LINE_ITEM_ID = LineItemID
    AND BUNDLE_ID = BundleID
    AND STATUS_CODE = 'ERROR';

Line: 2184

 CURSOR C_UpdateBundleStatus(BundleID number) IS
        SELECT 1
          FROM XDP_ORDER_BUNDLES
         WHERE ORDER_ID = OrderID
           AND BUNDLE_ID = BundleID;

Line: 2229

      UPDATE_XDP_ORDER_LINE_STATUS(Status,l_LineItemID);

Line: 2234

             FOR v_UpdatePackageLine in c_UpdatePackage(v_GetPackagedLine.RELATED_LINE_ITEM_ID) LOOP

                 UPDATE_XDP_ORDER_LINE_STATUS(Status,v_GetPackagedLine.RELATED_LINE_ITEM_ID);

Line: 2244

         UPDATE_XDP_ORDER_BUNDLE_STATUS('ERROR',OrderID,l_BundleID);

Line: 2256

         UPDATE_XDP_ORDER_LINE_STATUS('IN PROGRESS',l_LineItemID);

Line: 2270

            UPDATE_XDP_ORDER_LINE_STATUS('IN PROGRESS',l_RelatedLineID);

Line: 2279

               UPDATE_XDP_ORDER_BUNDLE_STATUS('IN PROGRESS',OrderID,l_BundleID);

Line: 2309

  select Status_code
   from XDP_ORDER_HEADERS
   where ORDER_ID = OrderID;

Line: 2315

  select 1
  from XDP_ORDER_LINE_ITEMS
  where ORDER_ID = OrderID
    and STATUS_CODE = 'ERROR';

Line: 2339

      UPDATE_XDP_ORDER_STATUS(Status,orderID) ;

Line: 2348

         UPDATE_XDP_ORDER_STATUS('IN PROGRESS',orderID) ;

Line: 2365

PROCEDURE UPDATE_XDP_ORDER_BUNDLE_STATUS(p_status    IN VARCHAR2,
                                         p_order_id  IN NUMBER,
                                         p_bundle_id IN NUMBER) IS
PRAGMA AUTONOMOUS_TRANSACTION ;

Line: 2372

         UPDATE xdp_order_bundles
            SET status            = p_status,
                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: 2383

          wf_core.context('XDPSTATUS', 'UPDATE_XDP_ORDER_STATUS', null, null, null, x_progress);

Line: 2387

END UPDATE_XDP_ORDER_BUNDLE_STATUS ;

Line: 2391

PROCEDURE UPDATE_XDP_ORDER_STATUS(p_status   IN VARCHAR2,
                                  p_order_id IN NUMBER) IS
PRAGMA AUTONOMOUS_TRANSACTION ;

Line: 2399

     UPDATE xdp_order_headers
        SET status_code       = p_status ,
            completion_date   = sysdate ,
            last_update_date  = sysdate,
            last_updated_by   = fnd_global.user_id,
            last_update_login = fnd_global.login_id
      WHERE order_id          = p_order_id ;

Line: 2407

     UPDATE xdp_order_headers
        SET status_code       = p_status ,
            last_update_date  = sysdate,
            last_updated_by   = fnd_global.user_id,
            last_update_login = fnd_global.login_id
      WHERE order_id          = p_order_id ;

Line: 2420

          wf_core.context('XDPSTATUS', 'UPDATE_XDP_ORDER_STATUS', null, null, null, x_progress);

Line: 2423

END UPDATE_XDP_ORDER_STATUS;

Line: 2427

PROCEDURE UPDATE_XDP_ORDER_LINE_STATUS(p_status   IN VARCHAR2,
                                       p_line_item_id IN NUMBER)IS
PRAGMA AUTONOMOUS_TRANSACTION ;

Line: 2436

     UPDATE xdp_order_line_items
        SET status_code       = p_status ,
            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: 2443

     UPDATE xdp_order_line_items
        SET status_code       = p_status ,
            completion_date   = sysdate ,
            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: 2456

          wf_core.context('XDPSTATUS', 'UPDATE_XDP_ORDER_LINE_STATUS', null, null, null, x_progress);

Line: 2459

END UPDATE_XDP_ORDER_LINE_STATUS;

Line: 2463

PROCEDURE UPDATE_XDP_WORKITEM_STATUS(p_status               IN VARCHAR2,
                                     p_workitem_instance_id IN NUMBER)IS
PRAGMA AUTONOMOUS_TRANSACTION ;

Line: 2472

     UPDATE xdp_fulfill_worklist
        SET status_code       = p_status ,
            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: 2479

     UPDATE xdp_fulfill_worklist
        SET status_code       = p_status ,
            completion_date   = sysdate ,
            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: 2492

          wf_core.context('XDPSTATUS', 'UPDATE_XDP_WORKITEM_STATUS', null, null, null, x_progress);

Line: 2495

END UPDATE_XDP_WORKITEM_STATUS;

Line: 2499

PROCEDURE UPDATE_XDP_FA_STATUS(p_status         IN VARCHAR2,
                               p_fa_instance_id IN NUMBER)IS
PRAGMA AUTONOMOUS_TRANSACTION ;

Line: 2508

     UPDATE xdp_fa_runtime_list
        SET status_code       = p_status ,
            last_update_date  = sysdate,
            last_updated_by   = fnd_global.user_id,
            last_update_login = fnd_global.login_id
      WHERE fa_instance_id = p_fa_instance_id ;

Line: 2515

    UPDATE xdp_fa_runtime_list
        SET status_code       = p_status ,
            completion_date   = sysdate ,
            last_update_date  = sysdate,
            last_updated_by   = fnd_global.user_id,
            last_update_login = fnd_global.login_id
      WHERE fa_instance_id = p_fa_instance_id ;

Line: 2529

          wf_core.context('XDPSTATUS', 'UPDATE_XDP_FA_STATUS', null, null, null, x_progress);

Line: 2532

END UPDATE_XDP_FA_STATUS;

Line: 2541

     SELECT 'Y'
       FROM xdp_order_headers oh
      WHERE order_id = p_order_id
        AND (EXISTS  (SELECT 'Y'
                       FROM xdp_order_line_items oli
                      WHERE oli.order_id = oh.ordeR_id
                        AND oli.status_code = 'ERROR' ) OR
             EXISTS  (SELECT 'Y'
                       FROM xdp_fulfill_worklist fw
                      WHERE fw.order_id = oh.order_id
                        AND fw.status_code = 'ERROR') OR
             EXISTS  (SELECT 'Y'
                       FROM xdp_fulfill_worklist fw,
                            xdp_fa_runtime_list fr
                      WHERE fw.workitem_instance_id = fr.workitem_instance_id
                        AND fw.order_id = oh.order_id
                        AND fr.status_code = 'ERROR')) ;

Line: 2576

       SELECT 'Y' ,
              is_package_flag ,
              is_virtual_line_flag,
              line_item_id,
              ib_source,
              ib_source_id
         FROM xdp_order_line_items
        WHERE line_item_id = p_lineitem_id ;

Line: 2586

     SELECT 'Y'
       FROM xdp_order_line_items  oli
      WHERE line_item_id = p_lineitem_id
        AND ( EXISTS (SELECT 'Y'
                      FROM xdp_fulfill_worklist fw
                     WHERE fw.line_item_id  = oli.line_item_id
                       AND fw.status_code   = 'ERROR') OR
              EXISTS (SELECT 'Y'
                      FROM xdp_fulfill_worklist fw,
                           xdp_fa_runtime_list fr
                     WHERE fw.workitem_instance_id = fr.workitem_instance_id
                       AND fw.line_item_id         = oli.line_item_id
                       AND fr.status_code          = 'ERROR')) ;

Line: 2601

       SELECT 'Y'
         FROM xdp_line_relationships lr
        WHERE lr.related_line_item_id = lv_line_item_id
          AND (EXISTS (SELECT 'Y'
                         FROM xdp_fulfill_worklist fw
                        WHERE fw.line_item_id  = lr.line_item_id
                          AND fw.status_code   = 'ERROR') OR
               EXISTS (SELECT 'Y'
                         FROM xdp_fulfill_worklist fw,
                              xdp_fa_runtime_list fr
                        WHERE fw.workitem_instance_id = fr.workitem_instance_id
                          AND fw.line_item_id         = lr.line_item_id
                          AND fr.status_code          = 'ERROR')) ;

Line: 2646

     SELECT 'Y'
       FROM xdp_fulfill_worklist fw
      WHERE workitem_instance_id  = p_WIInstance_id
        AND EXISTS (SELECT 'Y'
                      FROM xdp_fa_runtime_list fr
                     WHERE fr.workitem_instance_id = fw.workitem_instance_id
                       AND fr.status_code          = 'ERROR') ;

Line: 2671

     SELECT 'Y'
       FROM xdp_fa_runtime_list fr
      WHERE fr.fa_instance_id = p_FAInstance_id
        AND fr.status_code     = 'ERROR' ;

Line: 2703

           UPDATE_XDP_WORKITEM_STATUS(l_status,l_WIInstanceID);

Line: 2731

 UPDATE_XDP_ORDER_LINE_STATUS(l_status ,  l_LineItemID );

Line: 2745

 SELECT status_code
   FROM xdp_fulfill_worklist
  WHERE workitem_instance_id  = p_WIInstance_id;

Line: 2750

 SELECT status_code
   FROM xdp_fa_runtime_list
  WHERE workitem_instance_id  = p_WIInstance_id;

Line: 2794

 SELECT is_package_flag , is_virtual_line_flag,
        line_item_id, status_code,
        ib_source, ib_source_id
   FROM xdp_order_line_items
  WHERE line_item_id = p_line_item_id;

Line: 2801

 SELECT xoli.line_item_id, xoli.status_code
   FROM xdp_line_relationships lr, xdp_order_line_items xoli
  WHERE lr.related_line_item_id = cv_line_item_id
    AND lr.line_item_id  = xoli.line_item_id;

Line: 2807

 SELECT workitem_instance_id
   FROM xdp_fulfill_worklist
  WHERE line_item_id  = cv_line_item_id;

Line: 2885

 SELECT status_code
   FROM xdp_order_headers
  WHERE order_id =  p_order_id;

Line: 2890

 SELECT status_code, line_item_id
   FROM xdp_order_line_items
  WHERE order_id =  p_order_id;