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

Line 77: insert into fnd_imp_bugset(request_id, snapshot_id, set_type, virtual_bug_no, bug_no, patch_order,

73: for patch_order in 1..buglist.COUNT
74: loop
75: prereq_bug_no := buglist(patch_order);
76: -- BUGSET: for every prereq for patches in the request, create a local prereq record ('m')
77: insert into fnd_imp_bugset(request_id, snapshot_id, set_type, virtual_bug_no, bug_no, patch_order,
78: creation_date, last_update_date, last_updated_by, created_by)
79: values(request_id__, snapshot_id__, 'm', 0-bug_no__, prereq_bug_no,
80: patch_order, sysdate, sysdate, -1, -1);
81: end loop;

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 97: (select q1.patch_id from fnd_imp_bugset q1

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

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

Line 190: delete from fnd_imp_bugset where request_id = request_id__ and set_type <> 'A';

186: BEGIN
187: -- MONITOR/BUGSET: clean local records
188: delete from fnd_imp_monitor where request_id = request_id__;
189: -- todo: would this clear what PW sets!?
190: delete from fnd_imp_bugset where request_id = request_id__ and set_type <> 'A';
191:
192: makesingletons(request_id__);
193: -- BUGSET/MONITOR: for every patch with prereq record(s), create a local multiset record ('M')
194: /* ang - not applicable as AD Team, for now, isn't doing prereq analysis

Line 195: insert into fnd_imp_bugset(request_id, snapshot_id, set_type, virtual_bug_no, bug_no,

191:
192: makesingletons(request_id__);
193: -- BUGSET/MONITOR: for every patch with prereq record(s), create a local multiset record ('M')
194: /* ang - not applicable as AD Team, for now, isn't doing prereq analysis
195: insert into fnd_imp_bugset(request_id, snapshot_id, set_type, virtual_bug_no, bug_no,
196: creation_date, last_update_date, last_updated_by, created_by)
197: select request_id__, s.snapshot_id, 'M', s.virtual_bug_no, 0-s.virtual_bug_no, sysdate, sysdate, -1, -1
198: from fnd_imp_bugset s
199: where s.request_id = request_id__

Line 198: from fnd_imp_bugset s

194: /* ang - not applicable as AD Team, for now, isn't doing prereq analysis
195: insert into fnd_imp_bugset(request_id, snapshot_id, set_type, virtual_bug_no, bug_no,
196: creation_date, last_update_date, last_updated_by, created_by)
197: select request_id__, s.snapshot_id, 'M', s.virtual_bug_no, 0-s.virtual_bug_no, sysdate, sysdate, -1, -1
198: from fnd_imp_bugset s
199: where s.request_id = request_id__
200: group by s.snapshot_id, s.virtual_bug_no;
201: insert into fnd_imp_monitor(request_id, snapshot_id, set_type, virtual_bug_no,
202: r1_requestor, r1_sync_date, r2_requestor, r2_sync_date,

Line 206: from fnd_imp_bugset s

202: r1_requestor, r1_sync_date, r2_requestor, r2_sync_date,
203: creation_date, last_update_date, last_updated_by, created_by)
204: select request_id__, s.snapshot_id, 'M' set_type, s.virtual_bug_no,
205: request_id__, null, request_id__, null, sysdate, sysdate, -1, -1
206: from fnd_imp_bugset s
207: where s.request_id = request_id__ and set_type = 'M';
208: */
209: -- MONITOR: for all prereqs, create a local servant singleton record ('s')
210: /* ang - not applicable as AD Team, for now, isn't doing prereq analysis

Line 216: from fnd_imp_bugset s

212: r1_requestor, r1_sync_date, r2_requestor, r2_sync_date,
213: creation_date, last_update_date, last_updated_by, created_by)
214: select request_id__, s.snapshot_id, 's' set_type, s.bug_no virtual_bug_no,
215: request_id__, null, request_id__, null, sysdate, sysdate, -1, -1
216: from fnd_imp_bugset s
217: where s.request_id = request_id__
218: and s.set_type = 'm'
219: and s.bug_no NOT IN(select m.virtual_bug_no from fnd_imp_monitor m where m.request_id = request_id__)
220: group by s.snapshot_id, s.bug_no;

Line 403: update fnd_imp_bugset

399: --compute_prereqs(request_id__); --ang we donot deal w/ prereqs as AD is not supporting prereq analysis at the moment
400: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
401: refresh1M(request_id__, 0-request_id__, snapshot_id__);
402: refresh2(0-request_id__, snapshot_id__);
403: update fnd_imp_bugset
404: set set_type = 'a'
405: where request_id = request_id__
406: and virtual_patch_id = 0-request_id__;
407: commit;

Line 415: from fnd_imp_bugset

411: RETURN VARCHAR2 IS
412: is_running__ VARCHAR2(1);
413: BEGIN
414: select 'Y' into is_running__
415: from fnd_imp_bugset
416: where request_id = request_id__
417: and virtual_bug_no = 0-request_id__
418: and set_type = 'A'
419: and rownum = 1;

Line 427: from fnd_imp_bugset

423: FUNCTION get_aggregate_list(request_id__ INTEGER)
424: RETURN VARCHAR2 IS
425: CURSOR agg_list IS
426: select patch_id
427: from fnd_imp_bugset
428: where virtual_patch_id = 0-request_id__ and request_id = request_id__
429: and set_type = 'a' and patch_order = 1;
430: tmp1 agg_list%ROWTYPE;
431: --buglist__ VARCHAR2(4000);

Line 450: delete from fnd_imp_bugset

446: snapshot_id__ NUMBER;
447: bug_no INTEGER;
448: BEGIN
449: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
450: delete from fnd_imp_bugset
451: where request_id = request_id__ and (set_type = 'A' or set_type = 'a') and snapshot_id = snapshot_id__;
452: for i in 1..buglist__.COUNT
453: loop
454: bug_no := buglist__(i);

Line 456: insert into fnd_imp_bugset(request_id, snapshot_id, set_type, virtual_bug_no, bug_no, patch_order,

452: for i in 1..buglist__.COUNT
453: loop
454: bug_no := buglist__(i);
455: -- for each top-level patch in request, enter record in bugset
456: insert into fnd_imp_bugset(request_id, snapshot_id, set_type, virtual_bug_no, bug_no, patch_order,
457: creation_date, last_update_date, last_updated_by, created_by)
458: values(request_id__, snapshot_id__, 'A', 0-request_id__, bug_no,
459: 1, sysdate, sysdate, -1, -1);
460: end loop;

Line 470: delete from fnd_imp_bugset

466: snapshot_id__ NUMBER;
467: patch_id INTEGER;
468: BEGIN
469: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
470: delete from fnd_imp_bugset
471: where request_id = request_id__ and (set_type = 'A' or set_type = 'a') and snapshot_id = snapshot_id__;
472: for i in 1..patchlist__.COUNT
473: loop
474: patch_id := patchlist__(i).patch_id;

Line 476: insert into fnd_imp_bugset(request_id, snapshot_id, set_type, virtual_patch_id, patch_id, patch_order,

472: for i in 1..patchlist__.COUNT
473: loop
474: patch_id := patchlist__(i).patch_id;
475: -- for each top-level patch in request, enter record in bugset
476: insert into fnd_imp_bugset(request_id, snapshot_id, set_type, virtual_patch_id, patch_id, patch_order,
477: creation_date, last_update_date, last_updated_by, created_by)
478: values(request_id__, snapshot_id__, 'A', 0-request_id__, patch_id,
479: 1, sysdate, sysdate, -1, -1);
480: end loop;

Line 488: from fnd_imp_bugset

484: --ang commenting out the below method as prereq analysis is currently not supported by AD team
485: /*PROCEDURE compute_prereqs(request_id__ INTEGER) IS
486: CURSOR top_level_bug IS
487: select bug_no
488: from fnd_imp_bugset
489: where set_type = 'A' and patch_order = 1 and request_id = request_id__;
490: i INTEGER;
491: snapshot_id__ NUMBER;
492: prereq_bug_no INTEGER;

Line 507: insert into fnd_imp_bugset(request_id, snapshot_id, set_type, virtual_bug_no, bug_no, patch_order,

503: loop
504: prereq_bug_no := prereq_buglist__(i);
505: -- for each pre-req patch in request, enter record in bugset
506: -- todo: avoid duplicates
507: insert into fnd_imp_bugset(request_id, snapshot_id, set_type, virtual_bug_no, bug_no, patch_order,
508: creation_date, last_update_date, last_updated_by, created_by)
509: values(request_id__, snapshot_id__, 'A', 0-request_id__, prereq_bug_no,
510: 2, sysdate, sysdate, -1, -1);
511: end loop;

Line 765: from fnd_imp_bugset b, fnd_imp_lang_summary ls

761: begin
762: select sum(req_trans_cnt) into v_req_trans from
763: ( -- get all the prequisites
764: select ls.req_trans_cnt req_trans_cnt
765: from fnd_imp_bugset b, fnd_imp_lang_summary ls
766: where ls.patch_id = b.patch_id
767: and ls.snapshot_id = b.snapshot_id
768: and b.virtual_patch_id = v_bug.virtual_patch_id
769: and b.set_type = 'm'

Line 796: from fnd_imp_bugset b, fnd_imp_lang_summary ls

792: declare
793: v_req_trans number := 0;
794: begin
795: select sum(ls.req_trans_cnt) into v_req_trans
796: from fnd_imp_bugset b, fnd_imp_lang_summary ls
797: where ls.patch_id = b.patch_id
798: and ls.snapshot_id = b.snapshot_id
799: and b.virtual_patch_id = (0-request_id__)
800: and b.set_type = 'a'