APPS.AD_FILE_SYS_SNAPSHOTS_PKG dependencies on AD_SNAPSHOT_BUGFIXES_TEMP

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

793:
794: -- Wipe out temp table
795:
796: execute immediate
797: 'truncate table ' || G_UN_FND || '.ad_snapshot_bugfixes_temp';
798:
799: --
800: -- Insert candidate bugs into temp table.
801: -- Rules:

Line 806: insert into ad_snapshot_bugfixes_temp

802: -- If explicit in any appltop, insert it as explicit
803: -- If success-flag=N in any appltop, insert it as N
804: --
805:
806: insert into ad_snapshot_bugfixes_temp
807: (
808: bugfix_id,
809: bug_status,
810: success_flag

Line 858: from ad_snapshot_bugfixes_temp t

854: ad_snapshot_bugfixes_s.nextval, l_global_snapshot_id,
855: t.bugfix_id, t.bug_status, t.success_flag,
856: decode(l_count_appltops, 1, 'N', null),
857: sysdate, sysdate, 5, 5
858: from ad_snapshot_bugfixes_temp t
859: where not exists (select 'Already exists'
860: from ad_snapshot_bugfixes sb2
861: where sb2.snapshot_id = l_global_snapshot_id
862: and sb2.bugfix_id = t.bugfix_id);