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_PSCOMMON

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

522: SELECT COUNT(*) INTO cnt from FND_IMP_PFileInfo where patch_id = patch_id__;
523: delete from FND_IMP_PFileInfo where patch_id = patch_id__; commit;
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

Line 527: delete from FND_IMP_PSCommon where patch_id = patch_id__ and snapshot_id = snapshot_id__; commit;

523: delete from FND_IMP_PFileInfo where patch_id = patch_id__; commit;
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__;

Line 554: delete from FND_IMP_PSCommon where patch_id = patch_id__ and snapshot_id = snapshot_id__; commit;

550: -- dbms_output.put_line(to_char(sysdate,'HH24:MI:SS')||'> running['||bug_no__||','||snapshot_id__||']...');
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;

Line 559: insert into FND_IMP_PSCommon (select * from FND_IMP_PSCommon_VL 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;
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__;

Line 925: wipe('FND_IMP_PSCommon');

921: BEGIN
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');

Line 934: sync('FND_IMP_PSCommon'); commit;

930: -- dbms_output.put_line(to_char(sysdate,'HH24:MI:SS')||'> cleaned data');
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;