DBA Data[Home] [Help]

APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on WMS_DISPATCHED_TASKS_S

Line 5216: SELECT wms_dispatched_tasks_s.NEXTVAL

5212: END IF;
5213:
5214: CLOSE inbound_document_details;
5215:
5216: SELECT wms_dispatched_tasks_s.NEXTVAL
5217: INTO l_next_task_id
5218: FROM DUAL;
5219:
5220: IF (l_debug = 1) THEN

Line 5903: SELECT wms_dispatched_tasks_s.NEXTVAL

5899: LOOP
5900: FETCH wdth_cursor INTO l_task_id, l_old_temp_id;
5901: EXIT WHEN wdth_cursor%notfound;
5902:
5903: SELECT wms_dispatched_tasks_s.NEXTVAL
5904: INTO l_next_task_id
5905: FROM DUAL;
5906:
5907: SELECT mtl_material_transactions_s.NEXTVAL

Line 6227: SELECT wms_dispatched_tasks_s.NEXTVAL

6223: */
6224: IF (l_num_wdts_for_mmtt > 0) THEN
6225: -- TODO: how to duplicate WDT of original child MMTT (l_inbound_doc_child_rec)???
6226: --INSERT INTO wms_dispatched_tasks ???;
6227: SELECT wms_dispatched_tasks_s.NEXTVAL
6228: INTO l_next_task_id
6229: FROM DUAL;
6230:
6231: INSERT INTO wms_dispatched_tasks