APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_LAYOUT_LOBS

Line 2021: DELETE BNE_LAYOUT_LOBS

2017: -- REMOVE EXISTING DATA WHERE FORCE IS SPECIFIED
2018: BEGIN
2019: BNE_LAYOUTS_PKG.DELETE_ROW(P_APPLICATION_ID,P_LAYOUT_CODE);
2020:
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

Line 2037: DELETE BNE_LAYOUT_LOBS

2033: DELETE BNE_LAYOUT_COLS
2034: WHERE APPLICATION_ID = P_APPLICATION_ID
2035: AND LAYOUT_CODE = P_LAYOUT_CODE;
2036:
2037: DELETE BNE_LAYOUT_LOBS
2038: WHERE APPLICATION_ID = P_APPLICATION_ID
2039: AND LAYOUT_CODE = P_LAYOUT_CODE;
2040:
2041: END;

Line 2059: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_LOBS

2055: END IF;
2056:
2057: VN_ROW_COUNT:=0;
2058: BEGIN
2059: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_LOBS
2060: WHERE APPLICATION_ID = P_APPLICATION_ID
2061: AND LAYOUT_CODE = P_LAYOUT_CODE;
2062: EXCEPTION
2063: WHEN NO_DATA_FOUND THEN NULL;

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

2062: EXCEPTION
2063: WHEN NO_DATA_FOUND THEN NULL;
2064: END;
2065: IF VN_ROW_COUNT > 0 THEN
2066: RAISE_APPLICATION_ERROR(-20000,'Rows already exist in BNE_LAYOUT_LOBS for layout:' || P_APPLICATION_ID || ':' || P_LAYOUT_CODE || '. Use the FORCE flag to overide.');
2067: END IF;
2068:
2069: VN_ROW_COUNT:=0;
2070: BEGIN

Line 2107: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_LOBS

2103: END IF;
2104:
2105: VN_ROW_COUNT:=0;
2106: BEGIN
2107: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_LOBS
2108: WHERE APPLICATION_ID = P_APPLICATION_ID
2109: AND LAYOUT_CODE = P_LAYOUT_CODE;
2110: EXCEPTION
2111: WHEN NO_DATA_FOUND THEN NULL;

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

2110: EXCEPTION
2111: WHEN NO_DATA_FOUND THEN NULL;
2112: END;
2113: IF VN_ROW_COUNT > 0 THEN
2114: RAISE_APPLICATION_ERROR(-20000,'Rows already exist in BNE_LAYOUT_LOBS for layout:' || P_APPLICATION_ID || ':' || P_LAYOUT_CODE || '. Use the FORCE flag to overide.');
2115: END IF;
2116:
2117: end if;
2118:

Line 5035: DELETE FROM BNE_LAYOUT_LOBS

5031: DELETE FROM BNE_LAYOUT_COLS
5032: WHERE APPLICATION_ID = P_APPLICATION_ID
5033: AND LAYOUT_CODE = P_LAYOUT_CODE;
5034:
5035: DELETE FROM BNE_LAYOUT_LOBS
5036: WHERE APPLICATION_ID = P_APPLICATION_ID
5037: AND LAYOUT_CODE = P_LAYOUT_CODE;
5038:
5039: -- Graphs referenced from this layout only.