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 4693: FROM BNE_STORED_SQL C

4689: -- Reference all queries in the content.
4690: SELECT QUERY_APP_ID, QUERY_CODE
4691: BULK COLLECT
4692: INTO VV_QUERY_KEYS
4693: FROM BNE_STORED_SQL C
4694: WHERE APPLICATION_ID = P_APPLICATION_ID
4695: AND CONTENT_CODE = P_CONTENT_CODE
4696: AND QUERY_APP_ID IS NOT NULL
4697: AND QUERY_CODE IS NOT NULL;

Line 4707: DELETE FROM BNE_STORED_SQL

4703: DELETE FROM BNE_CONTENTS_TL
4704: WHERE APPLICATION_ID = P_APPLICATION_ID
4705: AND CONTENT_CODE = P_CONTENT_CODE;
4706:
4707: DELETE FROM BNE_STORED_SQL
4708: WHERE APPLICATION_ID = P_APPLICATION_ID
4709: AND CONTENT_CODE = P_CONTENT_CODE;
4710:
4711: DELETE FROM BNE_CONTENT_COLS_B

Line 5384: FROM BNE_STORED_SQL

5380: END IF;
5381:
5382: SELECT COUNT(*)
5383: INTO VV_DUMMY
5384: FROM BNE_STORED_SQL
5385: WHERE QUERY_APP_ID = P_APPLICATION_ID
5386: AND QUERY_CODE = P_QUERY_CODE;
5387:
5388: IF VV_DUMMY > 0