DBA Data[Home] [Help]

APPS.FND_IMP_PKG dependencies on FND_IMP_AFFECTEDFILES_VL

Line 571: insert into FND_IMP_AffectedFiles (select * from FND_IMP_AffectedFiles_VL where bug_no = bug_no__ and snapshot_id = snapshot_id__);

567: insert into FND_IMP_PSMaster2 (select * from FND_IMP_PSMaster2_VL where patch_id = patch_id__ and snapshot_id = snapshot_id__);
568:
569: -- Moving this logic to Analyze Impact 2 (i.e. refresh2)
570: /*
571: insert into FND_IMP_AffectedFiles (select * from FND_IMP_AffectedFiles_VL where bug_no = bug_no__ and snapshot_id = snapshot_id__);
572: insert into FND_IMP_DiagMap (select * from FND_IMP_DiagMap_VL where bug_no = bug_no__ and snapshot_id = snapshot_id__);
573: */
574: commit;
575: end;

Line 596: insert into FND_IMP_AffectedFiles (select * from FND_IMP_AffectedFiles_VL where patch_id = patch_id__ and snapshot_id = snapshot_id__);

592: delete from FND_IMP_PISummary where patch_id = patch_id__ and snapshot_id = snapshot_id__;
593:
594: -- Adding this from refresh1/refresh1M - Moved it to this stage from
595: -- first stage
596: insert into FND_IMP_AffectedFiles (select * from FND_IMP_AffectedFiles_VL where patch_id = patch_id__ and snapshot_id = snapshot_id__);
597: insert into FND_IMP_DiagMap (select * from FND_IMP_DiagMap_VL where patch_id = patch_id__ and snapshot_id = snapshot_id__);
598:
599: insert into fnd_imp_menu_dep_summary2 (select * from fnd_imp_menu_dep_summary2_vl where patch_id = patch_id__ and snapshot_id = snapshot_id__);
600: insert into fnd_imp_menu_dep_summary3 (select * from fnd_imp_menu_dep_summary3_vl where patch_id = patch_id__ and snapshot_id = snapshot_id__);