APPS.AD_FILE_SYS_SNAPSHOTS_PKG dependencies on AD_SNAPSHOT_FILES_TEMP

Line 472: 'truncate table ' || G_UN_FND || '.ad_snapshot_files_temp';

468: begin
469:
470: if p_wipe_out_temp_table_at_start then
471: execute immediate
472: 'truncate table ' || G_UN_FND || '.ad_snapshot_files_temp';
473: end if;
474:
475: select snapshot_id
476: bulk collect into l_cv_ids

Line 521: 'insert into ad_snapshot_files_temp '||

517: end if;
518:
519:
520: l_str1 :=
521: 'insert into ad_snapshot_files_temp '||
522: '( '||
523: 'snapshot_file_id, file_id, update_source_id, update_type, '||
524: 'inconsistent_flag, containing_file_id, file_version_id, '||
525: 'dest_file_id, file_type_flag '||

Line 592: fnd_stats.gather_table_stats(G_UN_FND, 'ad_snapshot_files_temp');

588: commit;
589: end if;
590:
591: if p_gather_stats then
592: fnd_stats.gather_table_stats(G_UN_FND, 'ad_snapshot_files_temp');
593: end if;
594:
595: end get_max_fil_vers_over_appltops;
596:

Line 895: ad_snapshot_files_temp

891: max(dest_file_id) dest_file_id,
892: decode(max(decode(file_type_flag,'M',1,'N',0,2)),
893: 1,'M',0,'N',null) file_type_flag
894: from
895: ad_snapshot_files_temp
896: group by file_id) t
897: where not exists (select 'Already exists'
898: from ad_snapshot_files sf2
899: where sf2.snapshot_id = l_global_snapshot_id

Line 2032: from ad_snapshot_files_temp;

2028: cursor crec is
2029: select file_id, dest_file_id, file_type_flag,
2030: file_version_id, containing_file_id,
2031: inconsistent_flag
2032: from ad_snapshot_files_temp;
2033: begin
2034:
2035: open crec;
2036: