APPS.AD_FILE_UTIL dependencies on AD_CHECK_FILES_S

Line 614: -- ad_check_files still have null values for check_file_id

610: -- Updates the check_file_id column of ad_check_file_temp so that any
611: -- rows that were already in ad_check_files point to the check_file_id
612: -- of the (file, distinguisher) referenced in the row. Rows in
613: -- ad_check_file_temp that did not already have corresponding rows in
614: -- ad_check_files still have null values for check_file_id
615: -- (assuming they started out as null)
616: --
617: -- Arguments
618: -- none

Line 704: 'select ad_check_files_s.nextval, '||

700: ad_file_util.error_buf := 'load_checkfile_info('||
701: 'insert into ad_check_files '||
702: '(check_file_id, file_id, distinguisher, '||
703: 'file_version_id, creation_date) '||
704: 'select ad_check_files_s.nextval, '||
705: 'temp.f_id, temp.dist, temp.fv_id, '||
706: 'temp.edate from (select distinct '||
707: 't.file_id f_id, t.distinguisher dist, '||
708: 't.file_version_id fv_id, '||

Line 718: select ad_check_files_s.nextval,

714: begin
715: insert into ad_check_files
716: (check_file_id, file_id, distinguisher,
717: file_version_id, creation_date)
718: select ad_check_files_s.nextval,
719: temp.f_id, temp.dist, temp.fv_id, temp.edate
720: from
721: (select distinct
722: t.file_id f_id,