CW_DEL_PROCESSED_ORDER
Create Or Replace Procedure Delete_Processed_Record (POrder_Number Number)
IS
BEGIN
Delete
From Oe_Headers_Iface_All
Where Orig_Sys_Document_Ref=pOrder_Number;
Delete
From Oe_Price_Adjs_Iface_all
Where Orig_Sys_Document_Ref=pOrder_Number;
Delete
From Oe_Price_Atts_Iface_All
Where Orig_Sys_Document_Ref=pOrder_Number;
Delete
From Oe_Lines_Iface_All
Where Orig_Sys_Document_Ref=pOrder_Number;
Delete
From Oe_LotSerials_Iface_All
Where Orig_Sys_Document_Ref=pOrder_Number;
Delete
From Oe_Credits_Iface_All
Where Orig_Sys_Document_Ref=pOrder_Number;
Commit;
END;
/
show errors;
