APPS.AD_FILE_UTIL dependencies on AD_PREPMODE_CHECK_FILES

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

2870: -- load_prepmode_checkfile_info
2871: --
2872: -- Purpose
2873: -- Imports file information from ad_check_file_temp to
2874: -- ad_prepmode_check_files, when applying a patch is "prepare" mode.
2875: --
2876: -- Arguments
2877: -- none
2878: --

Line 2887: update ad_prepmode_check_files cf

2883: -- first update versions for existing rows
2884: -- (assume that the versions in temporary table are higher)
2885: --
2886:
2887: update ad_prepmode_check_files cf
2888: set version = (select t.manifest_vers
2889: from ad_check_file_temp t
2890: where t.app_short_name = cf.app_short_name
2891: and t.subdir = cf.subdir

Line 2902: insert into ad_prepmode_check_files cf

2898:
2899: --
2900: -- insert rows for new files
2901: --
2902: insert into ad_prepmode_check_files cf
2903: (
2904: app_short_name, subdir, filename, distinguisher,
2905: version
2906: )

Line 2914: from ad_prepmode_check_files cf2

2910: from ad_check_file_temp t
2911: where t.manifest_vers is not null
2912: and not exists (
2913: select null
2914: from ad_prepmode_check_files cf2
2915: where cf2.app_short_name = t.app_short_name
2916: and cf2.subdir = t.subdir
2917: and cf2.filename = t.filename
2918: and cf2.distinguisher = nvl(t.distinguisher, '~'));

Line 2936: delete from ad_prepmode_check_files;

2932: --
2933: procedure cln_prepmode_checkfile_info
2934: is
2935: begin
2936: delete from ad_prepmode_check_files;
2937: end cln_prepmode_checkfile_info;
2938:
2939: --
2940: -- Bug 4488796 - rahkumar