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_B

Line 1934: DELETE BNE_LAYOUT_BLOCKS_B

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
1935: WHERE APPLICATION_ID = P_APPLICATION_ID
1936: AND LAYOUT_CODE = P_LAYOUT_CODE;
1937:
1938: DELETE BNE_LAYOUT_BLOCKS_TL

Line 1980: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_BLOCKS_B

1976: END IF;
1977:
1978: VN_ROW_COUNT:=0;
1979: BEGIN
1980: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_BLOCKS_B
1981: WHERE APPLICATION_ID = P_APPLICATION_ID
1982: AND LAYOUT_CODE = P_LAYOUT_CODE;
1983: EXCEPTION
1984: WHEN NO_DATA_FOUND THEN NULL;

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

1983: EXCEPTION
1984: WHEN NO_DATA_FOUND THEN NULL;
1985: END;
1986: IF VN_ROW_COUNT > 0 THEN
1987: RAISE_APPLICATION_ERROR(-20000,'Rows already exist in BNE_LAYOUT_BLOCKS_B for layout:' || P_APPLICATION_ID || ':' || P_LAYOUT_CODE || '. Use the FORCE flag to overide.');
1988: END IF;
1989:
1990: VN_ROW_COUNT:=0;
1991: BEGIN

Line 4932: DELETE FROM BNE_LAYOUT_BLOCKS_B

4928: DELETE FROM BNE_LAYOUTS_TL
4929: WHERE APPLICATION_ID = P_APPLICATION_ID
4930: AND LAYOUT_CODE = P_LAYOUT_CODE;
4931:
4932: DELETE FROM BNE_LAYOUT_BLOCKS_B
4933: WHERE APPLICATION_ID = P_APPLICATION_ID
4934: AND LAYOUT_CODE = P_LAYOUT_CODE;
4935:
4936: DELETE FROM BNE_LAYOUT_BLOCKS_TL