APPS.OE_PURGE_WF SQL Statements

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

Line: 22

    SELECT e.item_type,
      e.item_key
    FROM wf_items e
    WHERE ((e.item_type     = 'WFERROR'
    AND e.parent_item_type IN ('OEOH','OEOL','OENH','OEBH'))
    OR e.item_type          ='OMERROR')
    AND e.end_date         IS NULL
    AND NOT EXISTS
      (SELECT 1
      FROM wf_item_activity_statuses s
      WHERE s.item_type     = e.parent_item_type
      AND s.item_key        = e.parent_item_key
      AND s.activity_status = 'ERROR'
      );

Line: 38

    SELECT e.item_type,
      e.item_key
    FROM wf_items e
    WHERE e.item_type='OMERROR'
    AND e.end_date  IS NULL
    AND e.item_key   =c_item_key
    AND NOT EXISTS
      (SELECT 1
      FROM wf_item_activity_statuses s
      WHERE s.item_type     = e.parent_item_type
      AND s.item_key        = e.parent_item_key
      AND s.activity_status = 'ERROR'
      );

Line: 76

            UPDATE wf_items
            SET end_date   = sysdate
            WHERE item_type=l_errors_tbl(i).ITEM_TYPE
            AND item_key   =l_errors_tbl(i).item_key;

Line: 88

      l_errors_tbl.DELETE ;

Line: 112

            UPDATE wf_items
            SET end_date   = sysdate
            WHERE item_type=l_errors_tbl(i).ITEM_TYPE
            AND item_key   =l_errors_tbl(i).item_key;

Line: 124

      l_errors_tbl.DELETE ;

Line: 139

  l_errors_tbl.DELETE ;

Line: 165

    SELECT P.INSTANCE_LABEL,
      WAS.ITEM_KEY,
      H.ORDER_NUMBER,
      H.ORG_ID
    FROM WF_ITEM_ACTIVITY_STATUSES WAS,
      WF_PROCESS_ACTIVITIES P,
      OE_ORDER_HEADERS_ALL H
    WHERE TO_NUMBER(WAS.ITEM_KEY) = H.HEADER_ID
    AND WAS.PROCESS_ACTIVITY      = P.INSTANCE_ID
    AND P.ACTIVITY_ITEM_TYPE      = 'OEOH'
    AND P.ACTIVITY_NAME           = 'CLOSE_WAIT_FOR_L'
    AND WAS.ACTIVITY_STATUS       = 'NOTIFIED'
    AND WAS.ITEM_TYPE             = 'OEOH'
    AND NOT EXISTS
      (SELECT 1
      FROM OE_ORDER_LINES_ALL
      WHERE HEADER_ID = H.HEADER_ID
      AND OPEN_FLAG   = 'Y'
      );

Line: 186

    SELECT P.INSTANCE_LABEL,
      WAS.ITEM_KEY,
      H.ORDER_NUMBER,
      H.ORG_ID
    FROM WF_ITEM_ACTIVITY_STATUSES WAS,
      WF_PROCESS_ACTIVITIES P,
      OE_ORDER_HEADERS_ALL H
    WHERE TO_NUMBER(WAS.ITEM_KEY) = H.HEADER_ID
    AND WAS.PROCESS_ACTIVITY      = P.INSTANCE_ID
    AND P.ACTIVITY_ITEM_TYPE      = 'OEOH'
    AND P.ACTIVITY_NAME           = 'CLOSE_WAIT_FOR_L'
    AND WAS.ACTIVITY_STATUS       = 'NOTIFIED'
    AND WAS.item_key              = c_item_key
    AND WAS.ITEM_TYPE             = 'OEOH'
    AND NOT EXISTS
      (SELECT 1
      FROM OE_ORDER_LINES_ALL
      WHERE HEADER_ID = H.HEADER_ID
      AND OPEN_FLAG   = 'Y'
      );

Line: 208

    SELECT I.ITEM_TYPE,
      I.ITEM_KEY
    FROM WF_ITEMS I
    WHERE I.ITEM_TYPE     IN ('OMERROR','WFERROR')
    AND I.PARENT_ITEM_TYPE = 'OEOH'
    AND I.PARENT_ITEM_KEY  = TO_CHAR(c_header_id)
    AND I.END_DATE        IS NULL FOR UPDATE NOWAIT;

Line: 250

                    UPDATE WF_ITEMS
                    SET END_DATE   = SYSDATE
                    WHERE item_type=l_error_tbl(j).ITEM_TYPE
                    AND item_key   =l_error_tbl(j).ITEM_KEY;

Line: 261

                l_error_tbl.DELETE ;

Line: 271

              OE_Standard_WF.OEOH_SELECTOR (p_itemtype => 'OEOH' ,p_itemkey => l_wf_details_tbl(i).item_key ,p_actid => 12345 ,p_funcmode => 'SET_CTX' ,p_result => l_result );

Line: 286

        l_wf_details_tbl.DELETE ;

Line: 323

                    UPDATE WF_ITEMS
                    SET END_DATE   = SYSDATE
                    WHERE item_type=l_error_tbl(j).ITEM_TYPE
                    AND item_key   =l_error_tbl(j).ITEM_KEY;

Line: 334

                l_error_tbl.DELETE ;

Line: 344

              OE_Standard_WF.OEOH_SELECTOR (p_itemtype => 'OEOH' ,p_itemkey => l_wf_details_tbl(i).item_key ,p_actid => 12345 ,p_funcmode => 'SET_CTX' ,p_result => l_result );

Line: 359

        l_wf_details_tbl.DELETE ;

Line: 371

  l_wf_details_tbl.DELETE ;

Line: 372

  l_error_tbl.DELETE ;

Line: 399

    SELECT item_type,
      item_key
    FROM wf_items
    WHERE item_type=p_item_type
    AND end_date  <= (SYSDATE-g_age);

Line: 429

    l_purge_tbl.DELETE ;

Line: 440

  l_purge_tbl.DELETE ;

Line: 465

    SELECT item_type,
      item_key
    FROM wf_items
    WHERE end_date <= (SYSDATE-g_age)
    AND item_type            IN ('OEOH','OEOL','OENH','OEBH','OMERROR','OEAME'); -- AME ER 16084377

Line: 490

        SELECT end_date
        INTO l_end_date
        FROM wf_items
        WHERE item_type=l_item_type
        AND item_key   =p_item_key;

Line: 524

            SELECT end_date
            INTO l_end_date
            FROM wf_items
            WHERE item_type=l_item_type
            AND item_key   =p_item_key;

Line: 607

          l_purge_tbl.DELETE ;

Line: 627

  l_purge_tbl.DELETE ;