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 2033: DELETE BNE_LAYOUT_COLS

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
2034: WHERE APPLICATION_ID = P_APPLICATION_ID
2035: AND LAYOUT_CODE = P_LAYOUT_CODE;
2036:
2037: DELETE BNE_LAYOUT_LOBS

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

2091: END IF;
2092:
2093: VN_ROW_COUNT:=0;
2094: BEGIN
2095: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_COLS
2096: WHERE APPLICATION_ID = P_APPLICATION_ID
2097: AND LAYOUT_CODE = P_LAYOUT_CODE;
2098: EXCEPTION
2099: WHEN NO_DATA_FOUND THEN NULL;

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

2098: EXCEPTION
2099: WHEN NO_DATA_FOUND THEN NULL;
2100: END;
2101: IF VN_ROW_COUNT > 0 THEN
2102: 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.');
2103: END IF;
2104:
2105: VN_ROW_COUNT:=0;
2106: BEGIN

Line 2195: BNE_LAYOUT_COLS_PKG.Insert_Row(

2191: VN_COLS_INSERTED:=0;
2192: FOR INTERFACE_COLS_REC IN INTERFACE_COLS_C(P_APPLICATION_ID,
2193: P_INTERFACE_CODE,
2194: 'Y') LOOP
2195: BNE_LAYOUT_COLS_PKG.Insert_Row(
2196: VR_ROW_ID,
2197: P_APPLICATION_ID, --APPLICATION_ID
2198: P_LAYOUT_CODE, --LAYOUT_CODE
2199: 3, --BLOCK_ID

Line 2229: BNE_LAYOUT_COLS_PKG.Insert_Row(

2225: if (VN_COLS_INSERTED = 0 or P_ALL_COLUMNS) then
2226: FOR INTERFACE_COLS_REC IN INTERFACE_COLS_C(P_APPLICATION_ID,
2227: P_INTERFACE_CODE,
2228: 'N') LOOP
2229: BNE_LAYOUT_COLS_PKG.Insert_Row(
2230: VR_ROW_ID,
2231: P_APPLICATION_ID, --APPLICATION_ID
2232: P_LAYOUT_CODE, --LAYOUT_CODE
2233: 3, --BLOCK_ID

Line 5031: DELETE FROM BNE_LAYOUT_COLS

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
5032: WHERE APPLICATION_ID = P_APPLICATION_ID
5033: AND LAYOUT_CODE = P_LAYOUT_CODE;
5034:
5035: DELETE FROM BNE_LAYOUT_LOBS