--以下脚本于20171211在TONY虚拟机中实现
DECLARE
l_iface_rec bom.bom_op_routings_interface%ROWTYPE;
l_iface_seq_rec bom.bom_op_sequences_interface%ROWTYPE;
l_iface_res_rec bom.bom_op_resources_interface%ROWTYPE;
l_cur_mfg_org_id NUMBER := 81;--207; --Current Inv Organization
l_user_id NUMBER := 1110; --User ID, Sysadmin here
BEGIN
l_iface_rec.last_update_date := SYSDATE;
l_iface_rec.last_updated_by := l_user_id;
l_iface_rec.creation_date := SYSDATE;
l_iface_rec.created_by := l_user_id;
l_iface_rec.last_update_login := -1;
l_iface_seq_rec.last_update_date := SYSDATE;
l_iface_seq_rec.last_updated_by := l_user_id;
l_iface_seq_rec.creation_date := SYSDATE;
l_iface_seq_rec.created_by := l_user_id;
l_iface_seq_rec.last_upda