APPS.AD_FILE_UTIL dependencies on AD_CHECK_FILE_HISTORY

Line 743: 'insert into ad_check_file_history ' ||

739: -- Insert new records. Insert all the records with patch_run_id -1
740: -- Later while updating patch history update patch_run_id
741:
742: ad_file_util.error_buf := 'load_checkfile_info('||
743: 'insert into ad_check_file_history ' ||
744: '(CHECK_FILE_ID, FILE_VERSION_ID, PATCH_RUN_ID, CREATION_DATE) ' ||
745: 'select distinct acf.check_file_id, acf.file_version_id, -1, sysdate ' ||
746: 'from ad_check_files acf, ad_check_file_temp acft ' ||
747: ' where acft.check_file_id is null ' ||

Line 753: insert into ad_check_file_history

749: ' and acf.file_id=acft.file_id ' ||
750: ' and nvl(acf.distinguisher, ''x'')=nvl(acft.distinguisher, ''x''))';
751:
752: begin
753: insert into ad_check_file_history
754: (CHECK_FILE_ID, FILE_VERSION_ID, PATCH_RUN_ID, CREATION_DATE)
755: select distinct acf.check_file_id, acf.file_version_id, -1, sysdate
756: from ad_check_files acf, ad_check_file_temp acft
757: where acft.check_file_id is null

Line 840: 'insert into ad_check_file_history ' ||

836: -- Insert new records. Insert all the records with patch_run_id -1
837: -- Later while updating patch history update patch_run_id
838:
839: ad_file_util.error_buf := 'load_checkfile_info('||
840: 'insert into ad_check_file_history ' ||
841: ' (CHECK_FILE_ID, FILE_VERSION_ID, PATCH_RUN_ID, CREATION_DATE) ' ||
842: 'select distinct acf.check_file_id, acf.file_version_id, -1, sysdate ' ||
843: ' from ad_check_files acf, ad_check_file_temp acft ' ||
844: ' where acft.manifest_vers_higher = ''Y'' ' ||

Line 850: insert into ad_check_file_history

846: ' and acf.file_id=acft.file_id ' ||
847: ' and acf.distinguisher=acft.distinguisher)';
848:
849: begin
850: insert into ad_check_file_history
851: (CHECK_FILE_ID, FILE_VERSION_ID, PATCH_RUN_ID, CREATION_DATE)
852: select distinct acf.check_file_id, acf.file_version_id, -1, sysdate
853: from ad_check_files acf, ad_check_file_temp acft
854: where acft.manifest_vers_higher = 'Y'