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.AD_PATCH dependencies on AD_FILES

Line 315: cursor MAX_VER_CUR(p_file_id in ad_files.file_id%TYPE) is

311: function find_max_applied_version_indb(p_file_id in number,
312: p_snapshot_id in number)
313: return varchar2
314: is
315: cursor MAX_VER_CUR(p_file_id in ad_files.file_id%TYPE) is
316: select v.version
317: from ad_file_versions v, ad_snapshot_files s
318: where s.file_id = v.file_id
319: and s.file_id = p_file_id

Line 356: l_file_id ad_files.file_id%TYPE;

352: p_object_name in varchar2,
353: p_object_version in varchar2)
354: return varchar2
355: is
356: l_file_id ad_files.file_id%TYPE;
357: l_snapshot_id ad_snapshots.snapshot_id%TYPE;
358: l_ver ad_file_versions.version%TYPE;
359: l_dbver ad_file_versions.version%TYPE;
360: max_ver_indb ad_file_versions.version%TYPE;

Line 363: cursor FILE_VER_CUR(p_file_id in ad_files.file_id%TYPE) is

359: l_dbver ad_file_versions.version%TYPE;
360: max_ver_indb ad_file_versions.version%TYPE;
361: ret boolean := FALSE;
362:
363: cursor FILE_VER_CUR(p_file_id in ad_files.file_id%TYPE) is
364: select executed_flag
365: from ad_patch_run_bug_actions
366: where file_id = p_file_id
367: and patch_file_version_id in (select file_version_id

Line 412: from ad_files

408: end if;
409:
410: begin
411: select file_id into l_file_id
412: from ad_files
413: where app_short_name = p_application_short_name
414: and subdir = p_object_location
415: and filename = p_object_name;
416: exception