APPS.ENG_CANCEL_ECO dependencies on BOM_REFERENCE_DESIGNATORS

Line 187: DELETE FROM BOM_REFERENCE_DESIGNATORS RD

183: /*
184: ** delete reference designators of all pending revised items on ECO
185: */
186: stmt_num := 30;
187: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
188: WHERE RD.COMPONENT_SEQUENCE_ID IN
189: (SELECT IC.COMPONENT_SEQUENCE_ID
190: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
191: WHERE RI.ORGANIZATION_ID = org_id

Line 884: DELETE FROM BOM_REFERENCE_DESIGNATORS RD

880: /*
881: ** delete reference designators of all pending revised items on ECO
882: */
883: stmt_num := 30;
884: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
885: WHERE RD.COMPONENT_SEQUENCE_ID IN
886: (SELECT IC.COMPONENT_SEQUENCE_ID
887: FROM BOM_INVENTORY_COMPONENTS IC
888: WHERE IC.REVISED_ITEM_SEQUENCE_ID = rev_item_seq);

Line 1291: DELETE FROM BOM_REFERENCE_DESIGNATORS RD

1287: /*
1288: ** delete reference designators of all pending revised items on ECO
1289: */
1290: stmt_num := 30;
1291: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
1292: WHERE RD.COMPONENT_SEQUENCE_ID = comp_seq_id;
1293: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from rfd');
1294:
1295: stmt_num := 40;

Line 1309: DELETE FROM BOM_REFERENCE_DESIGNATORS RD

1305: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
1306: WHERE SC.COMPONENT_SEQUENCE_ID = crc.COMPONENT_SEQUENCE_ID;
1307: /* Delete reference designators of all pending revised items on ECO */
1308: stmt_num := stmt_num+1;
1309: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
1310: WHERE RD.COMPONENT_SEQUENCE_ID = crc.COMPONENT_SEQUENCE_ID;
1311: END LOOP;
1312: EXCEPTION
1313: WHEN OTHERS THEN