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;

Copyright IBM Corp. 2004, 2005