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_PSNEW

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

524: SELECT COUNT(*) INTO cnt from FND_IMP_PFileInfo2 where patch_id = patch_id__;
525: delete from FND_IMP_PFileInfo2 where patch_id = patch_id__; commit;
526: SELECT COUNT(*) INTO cnt from FND_IMP_PSCommon where patch_id = patch_id__ and snapshot_id = snapshot_id__;
527: delete from FND_IMP_PSCommon where patch_id = patch_id__ and snapshot_id = snapshot_id__; commit;
528: SELECT COUNT(*) INTO cnt from FND_IMP_PSNew where patch_id = patch_id__ and snapshot_id = snapshot_id__;
529: delete from FND_IMP_PSNew where patch_id = patch_id__ and snapshot_id = snapshot_id__; commit;
530: BEGIN
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__;

Line 529: delete from FND_IMP_PSNew where patch_id = patch_id__ and snapshot_id = snapshot_id__; commit;

525: delete from FND_IMP_PFileInfo2 where patch_id = patch_id__; commit;
526: SELECT COUNT(*) INTO cnt from FND_IMP_PSCommon where patch_id = patch_id__ and snapshot_id = snapshot_id__;
527: delete from FND_IMP_PSCommon where patch_id = patch_id__ and snapshot_id = snapshot_id__; commit;
528: SELECT COUNT(*) INTO cnt from FND_IMP_PSNew where patch_id = patch_id__ and snapshot_id = snapshot_id__;
529: delete from FND_IMP_PSNew where patch_id = patch_id__ and snapshot_id = snapshot_id__; commit;
530: BEGIN
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__;

Line 555: delete from FND_IMP_PSNew where patch_id = patch_id__ and snapshot_id = snapshot_id__; commit;

551: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> running['||patch_id__||','||snapshot_id__||']...');
552: delete from FND_IMP_PFileInfo where patch_id = patch_id__; commit; --ang
553: delete from FND_IMP_PFileInfo2 where patch_id = patch_id__; commit;
554: delete from FND_IMP_PSCommon where patch_id = patch_id__ and snapshot_id = snapshot_id__; commit;
555: delete from FND_IMP_PSNew where patch_id = patch_id__ and snapshot_id = snapshot_id__; commit;
556:
557: insert into FND_IMP_PFileInfo (select * from FND_IMP_PFileInfo_VL where patch_id = patch_id__); commit;
558: insert into FND_IMP_PFileInfo2 (select * from FND_IMP_PFileInfo2_VL where patch_id = patch_id__); commit;
559: insert into FND_IMP_PSCommon (select * from FND_IMP_PSCommon_VL where patch_id = patch_id__ and snapshot_id = snapshot_id__); commit;

Line 560: insert into FND_IMP_PSNew (select * from FND_IMP_PSNew_VL where patch_id = patch_id__ and snapshot_id = snapshot_id__); commit;

556:
557: insert into FND_IMP_PFileInfo (select * from FND_IMP_PFileInfo_VL where patch_id = patch_id__); commit;
558: insert into FND_IMP_PFileInfo2 (select * from FND_IMP_PFileInfo2_VL where patch_id = patch_id__); commit;
559: insert into FND_IMP_PSCommon (select * from FND_IMP_PSCommon_VL where patch_id = patch_id__ and snapshot_id = snapshot_id__); commit;
560: insert into FND_IMP_PSNew (select * from FND_IMP_PSNew_VL where patch_id = patch_id__ and snapshot_id = snapshot_id__); commit;
561:
562: begin
563: delete from FND_IMP_PSMaster2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;
564: -- delete from FND_IMP_AffectedFiles where bug_no = bug_no__ and snapshot_id = snapshot_id__;

Line 926: wipe('FND_IMP_PSNew');

922: -- dbms_output.put_line(to_char(sysdate,'HH24:MI:SS')||'> running...');
923: wipe('FND_IMP_PFileInfo');
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');

Line 935: sync('FND_IMP_PSNew'); commit;

931:
932: sync('FND_IMP_PFileInfo'); 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');