APPS.AD_FILE_SYS_SNAPSHOTS_PKG dependencies on AD_SNAPSHOT_BUGFIXES_TEMP

Line 856: 'truncate table ' || G_UN_FND || '.ad_snapshot_bugfixes_temp';

852:
853: -- Wipe out temp table
854:
855: execute immediate
856: 'truncate table ' || G_UN_FND || '.ad_snapshot_bugfixes_temp';
857:
858: --
859: -- Insert candidate bugs into temp table.
860: -- Rules:

Line 865: insert into ad_snapshot_bugfixes_temp

861: -- If explicit in any appltop, insert it as explicit
862: -- If success-flag=N in any appltop, insert it as N
863: --
864:
865: insert into ad_snapshot_bugfixes_temp
866: (
867: bugfix_id,
868: bug_status,
869: success_flag

Line 919: from ad_snapshot_bugfixes_temp t

915: ad_snapshot_bugfixes_s.nextval, l_global_snapshot_id,
916: t.bugfix_id, t.bug_status, t.success_flag,
917: decode(l_count_appltops, 1, 'N', null),
918: sysdate, sysdate, 5, 5
919: from ad_snapshot_bugfixes_temp t
920: where not exists (select 'Already exists'
921: from ad_snapshot_bugfixes sb2
922: where sb2.snapshot_id = l_global_snapshot_id
923: and sb2.bugfix_id = t.bugfix_id);