APPS.BOM_BOM_COMPONENT_UTIL dependencies on BOM_REFERENCE_DESIGNATORS

Line 979: DELETE from bom_reference_designators

975: , p_message_type => 'W' -- Added by MK on 11/13/00
976: );
977: END IF;
978:
979: DELETE from bom_reference_designators
980: WHERE component_sequence_id = p_rev_comp_unexp_rec.component_sequence_id ;
981: -- p_component_sequence_id ;
982:
983: DELETE from bom_substitute_components

Line 1229: DELETE FROM BOM_REFERENCE_DESIGNATORS RD

1225: /*
1226: ** delete reference designators of all pending revised items on ECO
1227: */
1228: stmt_num := 30;
1229: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
1230: WHERE RD.COMPONENT_SEQUENCE_ID = comp_seq_id;
1231: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from rfd');
1232:
1233: EXCEPTION