APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_LAYOUT_BLOCKS_B

Line 2025: DELETE BNE_LAYOUT_BLOCKS_B

2021: DELETE BNE_LAYOUT_LOBS
2022: WHERE APPLICATION_ID = P_APPLICATION_ID
2023: AND LAYOUT_CODE = P_LAYOUT_CODE;
2024:
2025: DELETE BNE_LAYOUT_BLOCKS_B
2026: WHERE APPLICATION_ID = P_APPLICATION_ID
2027: AND LAYOUT_CODE = P_LAYOUT_CODE;
2028:
2029: DELETE BNE_LAYOUT_BLOCKS_TL

Line 2071: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_BLOCKS_B

2067: END IF;
2068:
2069: VN_ROW_COUNT:=0;
2070: BEGIN
2071: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_BLOCKS_B
2072: WHERE APPLICATION_ID = P_APPLICATION_ID
2073: AND LAYOUT_CODE = P_LAYOUT_CODE;
2074: EXCEPTION
2075: WHEN NO_DATA_FOUND THEN NULL;

Line 2078: RAISE_APPLICATION_ERROR(-20000,'Rows already exist in BNE_LAYOUT_BLOCKS_B for layout:' || P_APPLICATION_ID || ':' || P_LAYOUT_CODE || '. Use the FORCE flag to overide.');

2074: EXCEPTION
2075: WHEN NO_DATA_FOUND THEN NULL;
2076: END;
2077: IF VN_ROW_COUNT > 0 THEN
2078: RAISE_APPLICATION_ERROR(-20000,'Rows already exist in BNE_LAYOUT_BLOCKS_B for layout:' || P_APPLICATION_ID || ':' || P_LAYOUT_CODE || '. Use the FORCE flag to overide.');
2079: END IF;
2080:
2081: VN_ROW_COUNT:=0;
2082: BEGIN

Line 5023: DELETE FROM BNE_LAYOUT_BLOCKS_B

5019: DELETE FROM BNE_LAYOUTS_TL
5020: WHERE APPLICATION_ID = P_APPLICATION_ID
5021: AND LAYOUT_CODE = P_LAYOUT_CODE;
5022:
5023: DELETE FROM BNE_LAYOUT_BLOCKS_B
5024: WHERE APPLICATION_ID = P_APPLICATION_ID
5025: AND LAYOUT_CODE = P_LAYOUT_CODE;
5026:
5027: DELETE FROM BNE_LAYOUT_BLOCKS_TL