DBA Data[Home] [Help]

APPS.BOM_BOM_COMPONENT_UTIL dependencies on BOM_REFERENCE_DESIGNATORS

Line 1081: DELETE from bom_reference_designators

1077: , p_message_type => 'W' -- Added by MK on 11/13/00
1078: );
1079: END IF;
1080:
1081: DELETE from bom_reference_designators
1082: WHERE component_sequence_id = p_rev_comp_unexp_rec.component_sequence_id ;
1083: -- p_component_sequence_id ;
1084:
1085: DELETE from bom_substitute_components

Line 1336: DELETE FROM BOM_REFERENCE_DESIGNATORS RD

1332: /*
1333: ** delete reference designators of all pending revised items on ECO
1334: */
1335: stmt_num := 30;
1336: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
1337: WHERE RD.COMPONENT_SEQUENCE_ID = comp_seq_id;
1338: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from rfd');
1339:
1340: EXCEPTION