APPS.AD_FILE_SYS_SNAPSHOTS_PKG dependencies on AD_SNAPSHOT_FILES_TEMP

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

506: begin
507:
508: if p_wipe_out_temp_table_at_start then
509: execute immediate
510: 'truncate table ' || G_UN_FND || '.ad_snapshot_files_temp';
511: end if;
512:
513: if (p_is_run_flow = TRUE)
514: then

Line 566: 'insert into ad_snapshot_files_temp '||

562: end if;
563:
564:
565: l_str1 :=
566: 'insert into ad_snapshot_files_temp '||
567: '( '||
568: 'snapshot_file_id, file_id, update_source_id, update_type, '||
569: 'inconsistent_flag, containing_file_id, file_version_id, '||
570: 'dest_file_id, file_type_flag '||

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

633: commit;
634: end if;
635:
636: if p_gather_stats then
637: fnd_stats.gather_table_stats(G_UN_FND, 'ad_snapshot_files_temp');
638: end if;
639:
640: end get_max_fil_vers_over_appltops;
641:

Line 956: ad_snapshot_files_temp

952: max(dest_file_id) dest_file_id,
953: decode(max(decode(file_type_flag,'M',1,'N',0,2)),
954: 1,'M',0,'N',null) file_type_flag
955: from
956: ad_snapshot_files_temp
957: group by file_id) t
958: where not exists (select 'Already exists'
959: from ad_snapshot_files sf2
960: where sf2.snapshot_id = l_global_snapshot_id

Line 2110: from ad_snapshot_files_temp;

2106: cursor crec is
2107: select file_id, dest_file_id, file_type_flag,
2108: file_version_id, containing_file_id,
2109: inconsistent_flag
2110: from ad_snapshot_files_temp;
2111: begin
2112:
2113: open crec;
2114: