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.AMS_LIST_QUERIES_NEW_PKG dependencies on AMS_LIST_QUERIES_ALL_S

Line 298: update AMS_LIST_QUERIES_ALL set

294: X_LAST_UPDATED_BY in NUMBER,
295: X_LAST_UPDATE_LOGIN in NUMBER
296: ) is
297: begin
298: update AMS_LIST_QUERIES_ALL set
299: QUERY_TEMPLATE_ID = X_QUERY_TEMPLATE_ID,
300: OWNER_USER_ID = X_OWNER_USER_ID,
301: QUERY_TYPE = X_QUERY_TYPE,
302: ACT_LIST_QUERY_USED_BY_ID = X_ACT_LIST_QUERY_USED_BY_ID,

Line 410: SELECT AMS_LIST_QUERIES_ALL_S.NEXTVAL

406: FROM AMS_LIST_QUERIES_ALL
407: WHERE LIST_QUERY_ID = X_LIST_QUERY_ID;
408:
409: CURSOR c_get_id is
410: SELECT AMS_LIST_QUERIES_ALL_S.NEXTVAL
411: FROM DUAL;
412: BEGIN
413: if X_OWNER = 'SEED' then
414: l_user_id := 1;