APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_LAYOUT_LOBS

Line 1930: DELETE BNE_LAYOUT_LOBS

1926: -- REMOVE EXISTING DATA WHERE FORCE IS SPECIFIED
1927: BEGIN
1928: BNE_LAYOUTS_PKG.DELETE_ROW(P_APPLICATION_ID,P_LAYOUT_CODE);
1929:
1930: DELETE BNE_LAYOUT_LOBS
1931: WHERE APPLICATION_ID = P_APPLICATION_ID
1932: AND LAYOUT_CODE = P_LAYOUT_CODE;
1933:
1934: DELETE BNE_LAYOUT_BLOCKS_B

Line 1946: DELETE BNE_LAYOUT_LOBS

1942: DELETE BNE_LAYOUT_COLS
1943: WHERE APPLICATION_ID = P_APPLICATION_ID
1944: AND LAYOUT_CODE = P_LAYOUT_CODE;
1945:
1946: DELETE BNE_LAYOUT_LOBS
1947: WHERE APPLICATION_ID = P_APPLICATION_ID
1948: AND LAYOUT_CODE = P_LAYOUT_CODE;
1949:
1950: END;

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

1964: END IF;
1965:
1966: VN_ROW_COUNT:=0;
1967: BEGIN
1968: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_LOBS
1969: WHERE APPLICATION_ID = P_APPLICATION_ID
1970: AND LAYOUT_CODE = P_LAYOUT_CODE;
1971: EXCEPTION
1972: WHEN NO_DATA_FOUND THEN NULL;

Line 1975: 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.');

1971: EXCEPTION
1972: WHEN NO_DATA_FOUND THEN NULL;
1973: END;
1974: IF VN_ROW_COUNT > 0 THEN
1975: 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.');
1976: END IF;
1977:
1978: VN_ROW_COUNT:=0;
1979: BEGIN

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

2012: END IF;
2013:
2014: VN_ROW_COUNT:=0;
2015: BEGIN
2016: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_LOBS
2017: WHERE APPLICATION_ID = P_APPLICATION_ID
2018: AND LAYOUT_CODE = P_LAYOUT_CODE;
2019: EXCEPTION
2020: WHEN NO_DATA_FOUND THEN NULL;

Line 2023: 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.');

2019: EXCEPTION
2020: WHEN NO_DATA_FOUND THEN NULL;
2021: END;
2022: IF VN_ROW_COUNT > 0 THEN
2023: 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.');
2024: END IF;
2025:
2026: end if;
2027:

Line 4944: DELETE FROM BNE_LAYOUT_LOBS

4940: DELETE FROM BNE_LAYOUT_COLS
4941: WHERE APPLICATION_ID = P_APPLICATION_ID
4942: AND LAYOUT_CODE = P_LAYOUT_CODE;
4943:
4944: DELETE FROM BNE_LAYOUT_LOBS
4945: WHERE APPLICATION_ID = P_APPLICATION_ID
4946: AND LAYOUT_CODE = P_LAYOUT_CODE;
4947:
4948: -- Graphs referenced from this layout only.