DBA Data[Home] [Help]

APPS.WMS_TASK_SKIPPED dependencies on WMS_EXCEPTIONS

Line 67: SELECT wms_exceptions_s.NEXTVAL INTO l_sequence from dual;

63: END IF;
64:
65: l_progress := '20';
66:
67: SELECT wms_exceptions_s.NEXTVAL INTO l_sequence from dual;
68:
69: IF (l_debug = 1) THEN
70: mydebug('l_sequence: ' || l_sequence);
71: END IF;

Line 106: INSERT INTO wms_exceptions(

102: mydebug('WMSSKIPB: value of l_inventory_item_id ' || l_inventory_item_id);
103: mydebug('Before inserting into WMS_exception');
104: END IF;
105:
106: INSERT INTO wms_exceptions(
107: TASK_ID,
108: SEQUENCE_NUMBER,
109: ORGANIZATION_ID,
110: INVENTORY_ITEM_ID,