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_PFILEINFO2

Line 524: SELECT COUNT(*) INTO cnt from FND_IMP_PFileInfo2 where patch_id = patch_id__;

520: SELECT COUNT(*) INTO cnt FROM fnd_imp_monitor where request_id IS NULL and snapshot_id = snapshot_id__ and virtual_patch_id = patch_id__;
521: delete from fnd_imp_monitor where request_id IS NULL and snapshot_id = snapshot_id__ and virtual_patch_id = patch_id__; commit;
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__;

Line 525: delete from FND_IMP_PFileInfo2 where patch_id = patch_id__; commit;

521: delete from fnd_imp_monitor where request_id IS NULL and snapshot_id = snapshot_id__ and virtual_patch_id = patch_id__; commit;
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;

Line 553: delete from FND_IMP_PFileInfo2 where patch_id = patch_id__; commit;

549: BEGIN
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;

Line 558: insert into FND_IMP_PFileInfo2 (select * from FND_IMP_PFileInfo2_VL 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;
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

Line 924: wipe('FND_IMP_PFileInfo2');

920: PROCEDURE refreshAll IS
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');

Line 933: sync('FND_IMP_PFileInfo2'); commit;

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;
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;