eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_LAYOUT_BLOCKS_TL

Line 2029: DELETE BNE_LAYOUT_BLOCKS_TL

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
2030: WHERE APPLICATION_ID = P_APPLICATION_ID
2031: AND LAYOUT_CODE = P_LAYOUT_CODE;
2032:
2033: DELETE BNE_LAYOUT_COLS

Line 2083: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_BLOCKS_TL

2079: END IF;
2080:
2081: VN_ROW_COUNT:=0;
2082: BEGIN
2083: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_BLOCKS_TL
2084: WHERE APPLICATION_ID = P_APPLICATION_ID
2085: AND LAYOUT_CODE = P_LAYOUT_CODE;
2086: EXCEPTION
2087: WHEN NO_DATA_FOUND THEN NULL;

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

2086: EXCEPTION
2087: WHEN NO_DATA_FOUND THEN NULL;
2088: END;
2089: IF VN_ROW_COUNT > 0 THEN
2090: RAISE_APPLICATION_ERROR(-20000,'Rows already exist in BNE_LAYOUT_BLOCKS_TL for layout:' || P_APPLICATION_ID || ':' || P_LAYOUT_CODE || '. Use the FORCE flag to overide.');
2091: END IF;
2092:
2093: VN_ROW_COUNT:=0;
2094: BEGIN

Line 5027: DELETE FROM BNE_LAYOUT_BLOCKS_TL

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
5028: WHERE APPLICATION_ID = P_APPLICATION_ID
5029: AND LAYOUT_CODE = P_LAYOUT_CODE;
5030:
5031: DELETE FROM BNE_LAYOUT_COLS