APPS.AD_FILE_UTIL dependencies on AD_PREPMODE_CHECK_FILES

Line 2988: -- ad_prepmode_check_files, when applying a patch is "prepare" mode.

2984: -- load_prepmode_checkfile_info
2985: --
2986: -- Purpose
2987: -- Imports file information from ad_check_file_temp to
2988: -- ad_prepmode_check_files, when applying a patch is "prepare" mode.
2989: --
2990: -- Arguments
2991: -- none
2992: --

Line 3001: update ad_prepmode_check_files cf

2997: -- first update versions for existing rows
2998: -- (assume that the versions in temporary table are higher)
2999: --
3000:
3001: update ad_prepmode_check_files cf
3002: set version = (select t.manifest_vers
3003: from ad_check_file_temp t
3004: where t.app_short_name = cf.app_short_name
3005: and t.subdir = cf.subdir

Line 3016: insert into ad_prepmode_check_files cf

3012:
3013: --
3014: -- insert rows for new files
3015: --
3016: insert into ad_prepmode_check_files cf
3017: (
3018: app_short_name, subdir, filename, distinguisher,
3019: version
3020: )

Line 3028: from ad_prepmode_check_files cf2

3024: from ad_check_file_temp t
3025: where t.manifest_vers is not null
3026: and not exists (
3027: select null
3028: from ad_prepmode_check_files cf2
3029: where cf2.app_short_name = t.app_short_name
3030: and cf2.subdir = t.subdir
3031: and cf2.filename = t.filename
3032: and cf2.distinguisher = nvl(t.distinguisher, '~'));

Line 3050: delete from ad_prepmode_check_files;

3046: --
3047: procedure cln_prepmode_checkfile_info
3048: is
3049: begin
3050: delete from ad_prepmode_check_files;
3051: end cln_prepmode_checkfile_info;
3052:
3053: --
3054: -- Bug 4488796 - rahkumar