4321: DELETE FROM BNE_INTEGRATORS_TL
4322: WHERE APPLICATION_ID = P_APPLICATION_ID
4323: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;
4324:
4325: DELETE FROM BNE_GRAPHS_B
4326: WHERE APPLICATION_ID = P_APPLICATION_ID
4327: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;
4328:
4329: DELETE FROM BNE_GRAPHS_TL
5037: AND LAYOUT_CODE = P_LAYOUT_CODE;
5038:
5039: -- Graphs referenced from this layout only.
5040: FOR I IN (SELECT APPLICATION_ID, INTEGRATOR_CODE, SEQUENCE_NUM
5041: FROM BNE_GRAPHS_B
5042: WHERE LAYOUT_APP_ID = P_APPLICATION_ID
5043: AND LAYOUT_CODE = P_LAYOUT_CODE)
5044: LOOP
5045: DELETE FROM BNE_GRAPHS_B
5041: FROM BNE_GRAPHS_B
5042: WHERE LAYOUT_APP_ID = P_APPLICATION_ID
5043: AND LAYOUT_CODE = P_LAYOUT_CODE)
5044: LOOP
5045: DELETE FROM BNE_GRAPHS_B
5046: WHERE APPLICATION_ID = I.APPLICATION_ID
5047: AND INTEGRATOR_CODE = I.INTEGRATOR_CODE
5048: AND SEQUENCE_NUM = I.SEQUENCE_NUM;
5049: