APPS.WMS_TASK_SKIPPED SQL Statements

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

Line: 11

   select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;

Line: 45

     l_last_updated_by   wms_dispatched_tasks.last_updated_by%TYPE;

Line: 56

   l_last_updated_by := FND_GLOBAL.user_id; ---*************** AFSCGBLS.pls

Line: 62

      mydebug('WMSSKIPB: value of last_ypdated_by '||  l_last_updated_by );

Line: 67

   SELECT wms_exceptions_s.NEXTVAL INTO l_sequence from dual;

Line: 75

        SELECT t.inventory_item_id, w.created_by
	INTO l_inventory_item_id, l_created_by
	FROM wms_dispatched_tasks w ,
           (SELECT mmtt.transaction_temp_id task_id,  mmtt.wms_task_type wms_task_type_id,
	           mmtt.inventory_item_id
	    FROM mtl_material_transactions_temp mmtt
            WHERE mmtt.transaction_temp_id =  l_task_id
	    AND mmtt.wms_task_type IS NOT NULL AND mmtt.transaction_status = 2
            UNION ALL
            SELECT mcce.cycle_count_entry_id task_id, 3 wms_task_type_id,mcce.inventory_item_id
            FROM mtl_cycle_count_entries mcce
	    WHERE mcce.cycle_count_entry_id=l_task_id
	    AND entry_status_code IN (1,3)  AND NVL(export_flag, 2) = 2 ) t
	WHERE t.task_id =  l_task_id
	AND t.wms_task_type_id = p_wms_task_type
	AND t.task_id = w.transaction_temp_id
	AND t.wms_task_type_id = w.task_type;

Line: 103

      mydebug('Before inserting into WMS_exception');

Line: 106

   INSERT INTO wms_exceptions(
         TASK_ID,
         SEQUENCE_NUMBER,
         ORGANIZATION_ID,
         INVENTORY_ITEM_ID,
         PERSON_ID,
         EFFECTIVE_START_DATE,
         EFFECTIVE_END_DATE  ,
         DISCREPANCY_TYPE,
         LOT_NUMBER,
         LAST_UPDATE_DATE,
         LAST_UPDATED_BY,
         CREATION_DATE,
         created_by,
         wms_task_type
         )
     VALUES( l_task_id,
      l_sequence,
      l_org_id,
      l_inventory_item_id,
      l_emp_id,
      Sysdate,
      Sysdate,
      1,
      -999,
      Sysdate,
      l_last_updated_by,
      Sysdate,
      l_created_by,
      p_wms_task_type
      );

Line: 139

      mydebug('After inserting into WMS_exception');

Line: 144

      mydebug('Before  inserting into WMS_skip_task_exceptions');

Line: 147

   INSERT INTO wms_skip_task_exceptions(
     TASK_ID,
     SEQUENCE_NUMBER,
     ORGANIZATION_ID,
     INVENTORY_ITEM_ID,
     PERSON_ID,
     EFFECTIVE_START_DATE,
     EFFECTIVE_END_DATE  ,
     DISCREPANCY_TYPE,
     LOT_NUMBER,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     CREATION_DATE,
     created_by,
     wms_task_type
     )
     VALUES( l_task_id,
      l_sequence,
      l_org_id,
      l_inventory_item_id,
      l_emp_id,
      Sysdate,
      Sysdate,
      3,
      -999,
      Sysdate,
      l_last_updated_by,
      Sysdate,
      l_created_by,
      p_wms_task_type
      );

Line: 180

      mydebug('After  inserting into WMS_skip_task_exceptions');

Line: 185

   DELETE FROM wms_dispatched_tasks
     WHERE transaction_temp_id = l_task_id AND
     task_type = p_wms_task_type;