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_BUGSET_TEMP

Line 89: delete from fnd_imp_bugset_temp;

85: patch_id__ INTEGER; --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;

Line 96: insert into fnd_imp_bugset_temp(patch_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');
95:
96: insert into fnd_imp_bugset_temp(patch_id)
97: (select q1.patch_id from fnd_imp_bugset q1
98: where q1.request_id = request_id__ and q1.snapshot_id = snapshot_id__
99: and q1.virtual_patch_id = virtual_patch_id__ and q1.set_type IN ('M','m','A'));
100: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> after insert into fnd_imp_bugset_temp');

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

96: insert into fnd_imp_bugset_temp(patch_id)
97: (select q1.patch_id from fnd_imp_bugset q1
98: where q1.request_id = request_id__ and q1.snapshot_id = snapshot_id__
99: and q1.virtual_patch_id = virtual_patch_id__ and q1.set_type IN ('M','m','A'));
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,

Line 113: AND M.PATCH_ID IN ( SELECT PATCH_ID FROM FND_IMP_BUGSET_TEMP)

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 (
115: SELECT /*+ INDEX(X FND_IMP_PSMASTER2_N1) */ 1
116: FROM FND_IMP_PSMASTER2 X
117: WHERE X.SNAPSHOT_ID = snapshot_id__

Line 118: AND X.PATCH_ID IN (SELECT PATCH_ID FROM FND_IMP_BUGSET_TEMP where PATCH_ID <> M.PATCH_ID)

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
121: AND X.FILENAME = M.FILENAME
122: and X.NEW_VERSION IS NOT NULL