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_PSMASTER2

Line 90: delete from FND_IMP_PSMaster2 where patch_id = patch_id__ and snapshot_id = snapshot_id__; --ang

86: BEGIN
87: patch_id__ := virtual_patch_id__; --ang
88: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> running-refresh1M['||patch_id__||','||snapshot_id__||']...'); --ang
89: delete from fnd_imp_bugset_temp;
90: delete from FND_IMP_PSMaster2 where patch_id = patch_id__ and snapshot_id = snapshot_id__; --ang
91: -- delete from FND_IMP_AffectedFiles where bug_no = bug_no__ and snapshot_id = snapshot_id__;
92: -- delete from FND_IMP_DiagMap where bug_no = bug_no__ and snapshot_id = snapshot_id__;
93: commit;
94: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> after delete');

Line 104: INSERT INTO FND_IMP_PSMASTER2(PATCH_ID, SNAPSHOT_ID, APP_SHORT_NAME,

100: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> after insert into fnd_imp_bugset_temp');
101: --
102: -- Tuned Performance Fix from Performance Team
103: --
104: INSERT INTO FND_IMP_PSMASTER2(PATCH_ID, SNAPSHOT_ID, APP_SHORT_NAME,
105: DIRECTORY, FILENAME, TYPEID, NEW_VERSION, OLD_VERSION, FILES_AFFECTED, TYPE_AFFECTED, FILE_TYPE, TRANS_NAME, IS_FLAGGED_FILE)
106: SELECT virtual_patch_id__ PATCH_ID, snapshot_id__ SNAPSHOT_ID, APP_SHORT_NAME,
107: DIRECTORY, FILENAME, MAX(TYPEID), MAX(NEW_VERSION), MAX(OLD_VERSION),
108: MAX(FILES_AFFECTED), MAX(TYPE_AFFECTED), MAX(FILE_TYPE), MAX(TRANS_NAME),MAX(IS_FLAGGED_FILE)

Line 110: FND_IMP_PSMASTER2 M

106: SELECT virtual_patch_id__ PATCH_ID, snapshot_id__ SNAPSHOT_ID, APP_SHORT_NAME,
107: DIRECTORY, FILENAME, MAX(TYPEID), MAX(NEW_VERSION), MAX(OLD_VERSION),
108: MAX(FILES_AFFECTED), MAX(TYPE_AFFECTED), MAX(FILE_TYPE), MAX(TRANS_NAME),MAX(IS_FLAGGED_FILE)
109: FROM
110: FND_IMP_PSMASTER2 M
111: WHERE
112: M.SNAPSHOT_ID = snapshot_id__
113: AND M.PATCH_ID IN ( SELECT PATCH_ID FROM FND_IMP_BUGSET_TEMP)
114: AND NOT EXISTS (

Line 115: SELECT /+ INDEX(X FND_IMP_PSMASTER2_N1) / 1

111: WHERE
112: M.SNAPSHOT_ID = snapshot_id__
113: AND M.PATCH_ID IN ( SELECT PATCH_ID FROM FND_IMP_BUGSET_TEMP)
114: AND NOT EXISTS (
115: SELECT /*+ INDEX(X FND_IMP_PSMASTER2_N1) */ 1
116: FROM FND_IMP_PSMASTER2 X
117: WHERE X.SNAPSHOT_ID = snapshot_id__
118: AND X.PATCH_ID IN (SELECT PATCH_ID FROM FND_IMP_BUGSET_TEMP where PATCH_ID <> M.PATCH_ID)
119: AND X.APP_SHORT_NAME = M.APP_SHORT_NAME

Line 116: FROM FND_IMP_PSMASTER2 X

112: M.SNAPSHOT_ID = snapshot_id__
113: AND M.PATCH_ID IN ( SELECT PATCH_ID FROM FND_IMP_BUGSET_TEMP)
114: AND NOT EXISTS (
115: SELECT /*+ INDEX(X FND_IMP_PSMASTER2_N1) */ 1
116: FROM FND_IMP_PSMASTER2 X
117: WHERE X.SNAPSHOT_ID = snapshot_id__
118: AND X.PATCH_ID IN (SELECT PATCH_ID FROM FND_IMP_BUGSET_TEMP where PATCH_ID <> M.PATCH_ID)
119: AND X.APP_SHORT_NAME = M.APP_SHORT_NAME
120: AND X.DIRECTORY = M.DIRECTORY

Line 127: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> after insert into fnd_imp_psmaster2');

123: AND ( ( M.NEW_VERSION IS NULL)
124: or ( M.NEW_VERSION IS NOT NULL AND FND_IMP_CONV_PKG.COMPARE_RCSID(M.NEW_VERSION, X.NEW_VERSION) IN (1, 2)) ) )
125: GROUP BY APP_SHORT_NAME, DIRECTORY,FILENAME;
126:
127: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> after insert into fnd_imp_psmaster2');
128: commit;
129: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> completed-refresh1M['||patch_id__||','||snapshot_id__||']...');
130: END refresh1M;
131:

Line 269: from fnd_imp_psmaster2

265: refresh1(virtual_patch_id__, snapshot_id__); --ang
266: end if;
267:
268: select count(*) into psmaster2_sz__
269: from fnd_imp_psmaster2
270: where snapshot_id = snapshot_id__
271: and patch_id = virtual_patch_id__;
272:
273: if psmaster2_sz__ = 0 then

Line 538: SELECT COUNT(*) INTO cnt from FND_IMP_PSMaster2 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__;
541: delete from FND_IMP_AffectedFiles where patch_id = patch_id__ and snapshot_id = snapshot_id__;
542: SELECT COUNT(*) INTO cnt from FND_IMP_DiagMap where patch_id = patch_id__ and snapshot_id = snapshot_id__;

Line 539: delete from FND_IMP_PSMaster2 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__;
541: delete from FND_IMP_AffectedFiles where patch_id = patch_id__ and snapshot_id = snapshot_id__;
542: SELECT COUNT(*) INTO cnt from FND_IMP_DiagMap where patch_id = patch_id__ and snapshot_id = snapshot_id__;
543: delete from FND_IMP_DiagMap where patch_id = patch_id__ and snapshot_id = snapshot_id__;

Line 563: delete from FND_IMP_PSMaster2 where patch_id = patch_id__ and snapshot_id = snapshot_id__;

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__;
565: -- delete from FND_IMP_DiagMap where bug_no = bug_no__ and snapshot_id = snapshot_id__;
566: commit;
567: insert into FND_IMP_PSMaster2 (select * from FND_IMP_PSMaster2_VL where patch_id = patch_id__ and snapshot_id = snapshot_id__);

Line 567: insert into FND_IMP_PSMaster2 (select * from FND_IMP_PSMaster2_VL where patch_id = patch_id__ and snapshot_id = snapshot_id__);

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__;
565: -- delete from FND_IMP_DiagMap where bug_no = bug_no__ and snapshot_id = snapshot_id__;
566: commit;
567: insert into FND_IMP_PSMaster2 (select * from FND_IMP_PSMaster2_VL where patch_id = patch_id__ 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__);

Line 606: update fnd_imp_psmaster2 p

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
607: set files_affected =
608: (
609: select count(*)
610: from fnd_imp_affectedfiles f

Line 622: update fnd_imp_psmaster2

618: and snapshot_id=snapshot_id__
619: and typeid <> 'not applied'
620: and file_type = 'jsp';
621:
622: update fnd_imp_psmaster2
623: set type_affected='jsp'
624: where patch_id=patch_id__
625: and snapshot_id=snapshot_id__
626: and typeid <> 'not applied'

Line 630: update fnd_imp_psmaster2 p

626: and typeid <> 'not applied'
627: and files_affected<>0
628: and file_type = 'jsp';
629:
630: update fnd_imp_psmaster2 p
631: set files_affected=(select count(*)
632: from fnd_imp_menu_dep_summary2 s
633: where p.patch_id=s.patch_id
634: and p.snapshot_id=s.snapshot_id

Line 641: update fnd_imp_psmaster2 p

637: and snapshot_id=snapshot_id__
638: and typeid <> 'not applied'
639: and file_type = 'fmb';
640:
641: update fnd_imp_psmaster2 p
642: set type_affected='menu'
643: where patch_id=patch_id__
644: and snapshot_id=snapshot_id__
645: and typeid <> 'not applied'

Line 649: update fnd_imp_psmaster2 p

645: and typeid <> 'not applied'
646: and file_type = 'fmb'
647: and files_affected <> 0;
648:
649: update fnd_imp_psmaster2 p
650: set files_affected=(select count(*)
651: from jtf_diagnostic_cmap s
652: where p.trans_name=s.classname)
653: where patch_id=patch_id__

Line 658: update fnd_imp_psmaster2 p

654: and snapshot_id=snapshot_id__
655: and typeid <> 'not applied'
656: and file_type = 'class';
657:
658: update fnd_imp_psmaster2 p
659: set type_affected='diag'
660: where patch_id=patch_id__
661: and snapshot_id=snapshot_id__
662: and typeid <> 'not applied'

Line 927: wipe('FND_IMP_PSMaster2');

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

Line 936: sync('FND_IMP_PSMaster2');

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');
940: commit;