[Home] [Help]
499: END IF;/*Activity Inbound*/
500:
501: SELECT WMS_OP_INSTANCE_S.NEXTVAL
502: INTO l_op_plan_instance_rec.op_plan_instance_id
503: FROM dual;
504:
505: l_op_plan_instance_rec.operation_plan_id := l_operation_plan_id;
506: l_op_plan_instance_rec.activity_type_id := p_activity_id;
507: l_op_plan_instance_rec.plan_type_id := l_operation_plan_rec.plan_type_id;
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
5221: print_debug('Inserting Duplicate WDT records using ID:'||l_next_task_id,l_module_name,3);
5222: END IF;
5859: l_progress := 160;
5860: --use sequence to generate op_plan_instance_id
5861: SELECT WMS_OP_INSTANCE_S.NEXTVAL
5862: INTO l_wopi_split_rec.op_plan_instance_id
5863: FROM dual;
5864: l_progress := 170;
5865: --call wms_op_plan_instance table handler to insert l_wopi_split_rec INTO the table
5866:
5867: l_progress := 180;
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
5908: INTO l_new_temp_id
5909: FROM dual;
5905: FROM DUAL;
5906:
5907: SELECT mtl_material_transactions_s.NEXTVAL
5908: INTO l_new_temp_id
5909: FROM dual;
5910: -- TODO: how to construct new WDTHs from those linked to orig WOPI
5911: --INSERT INTO wms_dispatched_tasks_history ???;
5912: INSERT INTO wms_dispatched_tasks_history
5913: (
6191: l_progress := 210;
6192: --Call wms_op_operation_instances table handler to insert the record
6193: SELECT wms_op_instance_s.NEXTVAL
6194: INTO l_wooi_new_rec.operation_instance_id
6195: FROM dual;
6196: l_progress := 220;
6197:
6198: l_progress := 230;
6199: WMS_OP_RUNTIME_PVT_APIS.insert_operation_instance
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
6232: (
6233: task_id