DBA Data[Home] [Help]

APPS.FND_IMP_PKG dependencies on FND_IMP_DIAGMAP_VL

Line 572: insert into FND_IMP_DiagMap (select * from FND_IMP_DiagMap_VL where bug_no = bug_no__ 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;
576: -- dbms_output.put_line(to_char(sysdate,'HH24:MI:SS')||'> completed');

Line 597: insert into FND_IMP_DiagMap (select * from FND_IMP_DiagMap_VL 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__);
601: insert into FND_IMP_PISummary