DBA Data[Home] [Help]

APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on WMS_DISPATCHED_TASKS_S

Line 5104: SELECT wms_dispatched_tasks_s.NEXTVAL

5100: END IF;
5101:
5102: CLOSE inbound_document_details;
5103:
5104: SELECT wms_dispatched_tasks_s.NEXTVAL
5105: INTO l_next_task_id
5106: FROM DUAL;
5107:
5108: IF (l_debug = 1) THEN

Line 5777: SELECT wms_dispatched_tasks_s.NEXTVAL

5773: LOOP
5774: FETCH wdth_cursor INTO l_task_id, l_old_temp_id;
5775: EXIT WHEN wdth_cursor%notfound;
5776:
5777: SELECT wms_dispatched_tasks_s.NEXTVAL
5778: INTO l_next_task_id
5779: FROM DUAL;
5780:
5781: SELECT mtl_material_transactions_s.NEXTVAL

Line 6097: SELECT wms_dispatched_tasks_s.NEXTVAL

6093: */
6094: IF (l_num_wdts_for_mmtt > 0) THEN
6095: -- TODO: how to duplicate WDT of original child MMTT (l_inbound_doc_child_rec)???
6096: --INSERT INTO wms_dispatched_tasks ???;
6097: SELECT wms_dispatched_tasks_s.NEXTVAL
6098: INTO l_next_task_id
6099: FROM DUAL;
6100:
6101: INSERT INTO wms_dispatched_tasks