APPS.AD_PATCH dependencies on AD_FILE_VERSIONS

Line 308: from ad_file_versions v, ad_snapshot_files s

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
311: and s.snapshot_id = p_snapshot_id
312: and v.file_version_id = s.file_version_id;

Line 314: max_ver ad_file_versions.version%TYPE ;

310: and s.file_id = p_file_id
311: and s.snapshot_id = p_snapshot_id
312: and v.file_version_id = s.file_version_id;
313:
314: max_ver ad_file_versions.version%TYPE ;
315: old_ver ad_file_versions.version%TYPE ;
316: ret boolean := FALSE;
317: begin
318: max_ver := '0';

Line 315: old_ver ad_file_versions.version%TYPE ;

311: and s.snapshot_id = p_snapshot_id
312: and v.file_version_id = s.file_version_id;
313:
314: max_ver ad_file_versions.version%TYPE ;
315: old_ver ad_file_versions.version%TYPE ;
316: ret boolean := FALSE;
317: begin
318: max_ver := '0';
319: old_ver := '0';

Line 349: l_ver ad_file_versions.version%TYPE;

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;
352: ret boolean := FALSE;
353:

Line 350: l_dbver ad_file_versions.version%TYPE;

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;
352: ret boolean := FALSE;
353:
354: cursor FILE_VER_CUR(p_file_id in ad_files.file_id%TYPE) is

Line 351: max_ver_indb ad_file_versions.version%TYPE;

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;
352: ret boolean := FALSE;
353:
354: cursor FILE_VER_CUR(p_file_id in ad_files.file_id%TYPE) is
355: select executed_flag

Line 359: from ad_file_versions

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
359: from ad_file_versions
360: where file_id = p_file_id
361: and version = max_ver_indb);
362: begin
363: