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_COLS

Line 1942: DELETE BNE_LAYOUT_COLS

1938: DELETE BNE_LAYOUT_BLOCKS_TL
1939: WHERE APPLICATION_ID = P_APPLICATION_ID
1940: AND LAYOUT_CODE = P_LAYOUT_CODE;
1941:
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

Line 2004: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_COLS

2000: END IF;
2001:
2002: VN_ROW_COUNT:=0;
2003: BEGIN
2004: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_COLS
2005: WHERE APPLICATION_ID = P_APPLICATION_ID
2006: AND LAYOUT_CODE = P_LAYOUT_CODE;
2007: EXCEPTION
2008: WHEN NO_DATA_FOUND THEN NULL;

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

2007: EXCEPTION
2008: WHEN NO_DATA_FOUND THEN NULL;
2009: END;
2010: IF VN_ROW_COUNT > 0 THEN
2011: RAISE_APPLICATION_ERROR(-20000,'Rows already exist in BNE_LAYOUT_COLS for layout:' || P_APPLICATION_ID || ':' || P_LAYOUT_CODE || '. Use the FORCE flag to overide.');
2012: END IF;
2013:
2014: VN_ROW_COUNT:=0;
2015: BEGIN

Line 2104: BNE_LAYOUT_COLS_PKG.Insert_Row(

2100: VN_COLS_INSERTED:=0;
2101: FOR INTERFACE_COLS_REC IN INTERFACE_COLS_C(P_APPLICATION_ID,
2102: P_INTERFACE_CODE,
2103: 'Y') LOOP
2104: BNE_LAYOUT_COLS_PKG.Insert_Row(
2105: VR_ROW_ID,
2106: P_APPLICATION_ID, --APPLICATION_ID
2107: P_LAYOUT_CODE, --LAYOUT_CODE
2108: 3, --BLOCK_ID

Line 2138: BNE_LAYOUT_COLS_PKG.Insert_Row(

2134: if (VN_COLS_INSERTED = 0 or P_ALL_COLUMNS) then
2135: FOR INTERFACE_COLS_REC IN INTERFACE_COLS_C(P_APPLICATION_ID,
2136: P_INTERFACE_CODE,
2137: 'N') LOOP
2138: BNE_LAYOUT_COLS_PKG.Insert_Row(
2139: VR_ROW_ID,
2140: P_APPLICATION_ID, --APPLICATION_ID
2141: P_LAYOUT_CODE, --LAYOUT_CODE
2142: 3, --BLOCK_ID

Line 4940: DELETE FROM BNE_LAYOUT_COLS

4936: DELETE FROM BNE_LAYOUT_BLOCKS_TL
4937: WHERE APPLICATION_ID = P_APPLICATION_ID
4938: AND LAYOUT_CODE = P_LAYOUT_CODE;
4939:
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