9: function Delete_Children(Interface_id in number)
10: return number is
11: begin
12:
13: delete from mtl_transaction_lots_interface
14: where transaction_interface_id = Interface_Id ;
15:
16: delete from mtl_serial_numbers_interface
17: where transaction_interface_id = Interface_Id ;
18:
19: delete from mtl_serial_numbers_interface msni
20: where msni.transaction_interface_id in
21: (select serial_transaction_temp_id
22: from mtl_transaction_lots_interface mtli
23: where mtli.transaction_interface_id = Interface_Id);
24:
25: return 1;
26: