eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_IMP_PKG dependencies on FND_IMP_PISUMMARY

Line 535: SELECT COUNT(*) INTO cnt from FND_IMP_PISummary where patch_id = patch_id__ and snapshot_id = snapshot_id__;

531: SELECT COUNT(*) INTO cnt from fnd_imp_menu_dep_summary2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
532: delete from fnd_imp_menu_dep_summary2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
533: SELECT COUNT(*) INTO cnt from fnd_imp_menu_dep_summary3 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
534: delete from fnd_imp_menu_dep_summary3 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
535: SELECT COUNT(*) INTO cnt from FND_IMP_PISummary where patch_id = patch_id__ and snapshot_id = snapshot_id__;
536: delete from FND_IMP_PISummary where patch_id = patch_id__ and snapshot_id = snapshot_id__;
537: commit;
538: SELECT COUNT(*) INTO cnt from FND_IMP_PSMaster2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
539: delete from FND_IMP_PSMaster2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;

Line 536: delete from FND_IMP_PISummary where patch_id = patch_id__ and snapshot_id = snapshot_id__;

532: delete from fnd_imp_menu_dep_summary2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
533: SELECT COUNT(*) INTO cnt from fnd_imp_menu_dep_summary3 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
534: delete from fnd_imp_menu_dep_summary3 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
535: SELECT COUNT(*) INTO cnt from FND_IMP_PISummary where patch_id = patch_id__ and snapshot_id = snapshot_id__;
536: delete from FND_IMP_PISummary where patch_id = patch_id__ and snapshot_id = snapshot_id__;
537: commit;
538: SELECT COUNT(*) INTO cnt from FND_IMP_PSMaster2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
539: delete from FND_IMP_PSMaster2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
540: SELECT COUNT(*) INTO cnt from FND_IMP_AffectedFiles where patch_id = patch_id__ and snapshot_id = snapshot_id__;

Line 592: delete from FND_IMP_PISummary where patch_id = patch_id__ and snapshot_id = snapshot_id__;

588: delete from FND_IMP_DiagMap where patch_id = patch_id__ and snapshot_id = snapshot_id__;
589:
590: delete from fnd_imp_menu_dep_summary2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
591: delete from fnd_imp_menu_dep_summary3 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__);

Line 601: insert into FND_IMP_PISummary

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
602: (select * from FND_IMP_PISummary_VL
603: where patch_id = patch_id__ and snapshot_id = snapshot_id__);
604: commit;
605:

Line 602: (select * from FND_IMP_PISummary_VL

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
602: (select * from FND_IMP_PISummary_VL
603: where patch_id = patch_id__ and snapshot_id = snapshot_id__);
604: commit;
605:
606: update fnd_imp_psmaster2 p

Line 928: wipe('FND_IMP_PISummary');

924: wipe('FND_IMP_PFileInfo2');
925: wipe('FND_IMP_PSCommon');
926: wipe('FND_IMP_PSNew');
927: wipe('FND_IMP_PSMaster2');
928: wipe('FND_IMP_PISummary');
929: wipe('FND_IMP_AffectedFiles');
930: -- dbms_output.put_line(to_char(sysdate,'HH24:MI:SS')||'> cleaned data');
931:
932: sync('FND_IMP_PFileInfo'); commit;

Line 937: sync('FND_IMP_PISummary'); commit;

933: sync('FND_IMP_PFileInfo2'); commit;
934: sync('FND_IMP_PSCommon'); commit;
935: sync('FND_IMP_PSNew'); commit;
936: sync('FND_IMP_PSMaster2');
937: sync('FND_IMP_PISummary'); commit;
938: sync('FND_IMP_AffectedFiles'); commit;
939: -- dbms_output.put_line(to_char(sysdate,'HH24:MI:SS')||'> completed');
940: commit;
941: