APPS.AD_PATCH dependencies on AD_FILES

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

302: function find_max_applied_version_indb(p_file_id in number,
303: p_snapshot_id in number)
304: return varchar2
305: is
306: cursor MAX_VER_CUR(p_file_id in ad_files.file_id%TYPE) is
307: select v.version
308: from ad_file_versions v, ad_snapshot_files s
309: where s.file_id = v.file_id
310: and s.file_id = p_file_id

Line 347: l_file_id ad_files.file_id%TYPE;

343: p_object_name in varchar2,
344: p_object_version in varchar2)
345: return varchar2
346: is
347: l_file_id ad_files.file_id%TYPE;
348: l_snapshot_id ad_snapshots.snapshot_id%TYPE;
349: l_ver ad_file_versions.version%TYPE;
350: l_dbver ad_file_versions.version%TYPE;
351: max_ver_indb ad_file_versions.version%TYPE;

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

350: l_dbver ad_file_versions.version%TYPE;
351: max_ver_indb ad_file_versions.version%TYPE;
352: ret boolean := FALSE;
353:
354: cursor FILE_VER_CUR(p_file_id in ad_files.file_id%TYPE) is
355: select executed_flag
356: from ad_patch_run_bug_actions
357: where file_id = p_file_id
358: and patch_file_version_id in (select file_version_id

Line 401: from ad_files

397: end if;
398:
399: begin
400: select file_id into l_file_id
401: from ad_files
402: where app_short_name = p_application_short_name
403: and subdir = p_object_location
404: and filename = p_object_name;
405: exception