[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;
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
5109: print_debug('Inserting Duplicate WDT records using ID:'||l_next_task_id,l_module_name,3);
5110: END IF;
5734: l_progress := 160;
5735: --use sequence to generate op_plan_instance_id
5736: SELECT WMS_OP_INSTANCE_S.NEXTVAL
5737: INTO l_wopi_split_rec.op_plan_instance_id
5738: FROM dual;
5739: l_progress := 170;
5740: --call wms_op_plan_instance table handler to insert l_wopi_split_rec INTO the table
5741:
5742: l_progress := 180;
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
5782: INTO l_new_temp_id
5783: FROM dual;
5779: FROM DUAL;
5780:
5781: SELECT mtl_material_transactions_s.NEXTVAL
5782: INTO l_new_temp_id
5783: FROM dual;
5784: -- TODO: how to construct new WDTHs from those linked to orig WOPI
5785: --INSERT INTO wms_dispatched_tasks_history ???;
5786: INSERT INTO wms_dispatched_tasks_history
5787: (
6061: l_progress := 210;
6062: --Call wms_op_operation_instances table handler to insert the record
6063: SELECT wms_op_instance_s.NEXTVAL
6064: INTO l_wooi_new_rec.operation_instance_id
6065: FROM dual;
6066: l_progress := 220;
6067:
6068: l_progress := 230;
6069: WMS_OP_RUNTIME_PVT_APIS.insert_operation_instance
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
6102: (
6103: task_id