1964: , REVISED_ITEM_SEQUENCE_ID
1965: , SYSDATE /* Cancellation Date */
1966: , p_cancel_comments /* Cancel Comments */
1967: , ORIGINAL_SYSTEM_REFERENCE
1968: FROM BOM_OPERATION_SEQUENCES
1969: WHERE operation_sequence_id = p_operation_sequence_id ;
1970:
1971:
1972: --
1971:
1972: --
1973: -- Delete Cancel Revisd Operation from operation table
1974: --
1975: DELETE FROM BOM_OPERATION_SEQUENCES
1976: WHERE operation_sequence_id = p_operation_sequence_id ;
1977:
1978: --
1979: -- Delete child Operation Resources