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.ICX_CAT_SQE_PVT dependencies on ICX_CAT_DELETED_SQES

Line 98: INSERT INTO icx_cat_deleted_sqes (sqe_sequence, created_by, creation_date,

94: l_err_loc := 800;
95: -- now if the original content zone had an sqe_sequence, store it in deleted sqes
96: IF (x_sqe_sequence IS NOT NULL) THEN
97: l_err_loc := 850;
98: INSERT INTO icx_cat_deleted_sqes (sqe_sequence, created_by, creation_date,
99: last_updated_by, last_update_date, last_update_login)
100: VALUES (x_sqe_sequence, fnd_global.user_id, sysdate, fnd_global.user_id,
101: sysdate, fnd_global.login_id);
102:

Line 724: FROM icx_cat_deleted_sqes

720: -- first select all the sqe sequences that have been deleted more
721: -- than a day ago
722: SELECT sqe_sequence
723: BULK COLLECT INTO l_sqe_sequences
724: FROM icx_cat_deleted_sqes
725: WHERE creation_date < sysdate - 1;
726:
727: l_err_loc := 200;
728:

Line 756: DELETE FROM icx_cat_deleted_sqes

752:
753: l_err_loc := 400;
754: -- now remove the sqe sequences from the table
755: FORALL i in 1..l_sqe_sequences.COUNT
756: DELETE FROM icx_cat_deleted_sqes
757: WHERE sqe_sequence = l_sqe_sequences(i);
758:
759: l_err_loc := 500;
760: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN