APPS.AD_PATCH dependencies on AD_FILE_VERSIONS

Line 317: from ad_file_versions v, ad_snapshot_files s

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

Line 323: max_ver ad_file_versions.version%TYPE ;

319: and s.file_id = p_file_id
320: and s.snapshot_id = p_snapshot_id
321: and v.file_version_id = s.file_version_id;
322:
323: max_ver ad_file_versions.version%TYPE ;
324: old_ver ad_file_versions.version%TYPE ;
325: ret boolean := FALSE;
326: begin
327: max_ver := '0';

Line 324: old_ver ad_file_versions.version%TYPE ;

320: and s.snapshot_id = p_snapshot_id
321: and v.file_version_id = s.file_version_id;
322:
323: max_ver ad_file_versions.version%TYPE ;
324: old_ver ad_file_versions.version%TYPE ;
325: ret boolean := FALSE;
326: begin
327: max_ver := '0';
328: old_ver := '0';

Line 358: l_ver ad_file_versions.version%TYPE;

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;
361: ret boolean := FALSE;
362:

Line 359: l_dbver ad_file_versions.version%TYPE;

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

Line 360: max_ver_indb ad_file_versions.version%TYPE;

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;
361: ret boolean := FALSE;
362:
363: cursor FILE_VER_CUR(p_file_id in ad_files.file_id%TYPE) is
364: select executed_flag

Line 368: from ad_file_versions

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
368: from ad_file_versions
369: where file_id = p_file_id
370: and version = max_ver_indb);
371: begin
372: