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 1938: DELETE BNE_LAYOUT_BLOCKS_TL

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

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

1988: END IF;
1989:
1990: VN_ROW_COUNT:=0;
1991: BEGIN
1992: SELECT COUNT(*) INTO VN_ROW_COUNT FROM BNE_LAYOUT_BLOCKS_TL
1993: WHERE APPLICATION_ID = P_APPLICATION_ID
1994: AND LAYOUT_CODE = P_LAYOUT_CODE;
1995: EXCEPTION
1996: WHEN NO_DATA_FOUND THEN NULL;

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

1995: EXCEPTION
1996: WHEN NO_DATA_FOUND THEN NULL;
1997: END;
1998: IF VN_ROW_COUNT > 0 THEN
1999: 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.');
2000: END IF;
2001:
2002: VN_ROW_COUNT:=0;
2003: BEGIN

Line 4936: DELETE FROM BNE_LAYOUT_BLOCKS_TL

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