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_STORED_SQL

Line 4784: FROM BNE_STORED_SQL C

4780: -- Reference all queries in the content.
4781: SELECT QUERY_APP_ID, QUERY_CODE
4782: BULK COLLECT
4783: INTO VV_QUERY_KEYS
4784: FROM BNE_STORED_SQL C
4785: WHERE APPLICATION_ID = P_APPLICATION_ID
4786: AND CONTENT_CODE = P_CONTENT_CODE
4787: AND QUERY_APP_ID IS NOT NULL
4788: AND QUERY_CODE IS NOT NULL;

Line 4798: DELETE FROM BNE_STORED_SQL

4794: DELETE FROM BNE_CONTENTS_TL
4795: WHERE APPLICATION_ID = P_APPLICATION_ID
4796: AND CONTENT_CODE = P_CONTENT_CODE;
4797:
4798: DELETE FROM BNE_STORED_SQL
4799: WHERE APPLICATION_ID = P_APPLICATION_ID
4800: AND CONTENT_CODE = P_CONTENT_CODE;
4801:
4802: DELETE FROM BNE_CONTENT_COLS_B

Line 5475: FROM BNE_STORED_SQL

5471: END IF;
5472:
5473: SELECT COUNT(*)
5474: INTO VV_DUMMY
5475: FROM BNE_STORED_SQL
5476: WHERE QUERY_APP_ID = P_APPLICATION_ID
5477: AND QUERY_CODE = P_QUERY_CODE;
5478:
5479: IF VV_DUMMY > 0