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 AD_PATCH_IMPACT_API

Line 24: --buglist ad_patch_impact_api.t_rec_patch; --ang

20: END lastupdate;
21:
22: PROCEDURE makesingletons(request_id__ INTEGER) IS
23: snapshot_id__ NUMBER;
24: --buglist ad_patch_impact_api.t_rec_patch; --ang
25: patchlist ad_patch_impact_api.t_recomm_patch_tab; --ang
26: bug_no INTEGER;
27: --baseline VARCHAR2(150); --ang
28: patch_id NUMBER; --ang

Line 25: patchlist ad_patch_impact_api.t_recomm_patch_tab; --ang

21:
22: PROCEDURE makesingletons(request_id__ INTEGER) IS
23: snapshot_id__ NUMBER;
24: --buglist ad_patch_impact_api.t_rec_patch; --ang
25: patchlist ad_patch_impact_api.t_recomm_patch_tab; --ang
26: bug_no INTEGER;
27: --baseline VARCHAR2(150); --ang
28: patch_id NUMBER; --ang
29: i INTEGER;

Line 32: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);

28: patch_id NUMBER; --ang
29: i INTEGER;
30: BEGIN
31: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> reading patch list...');
32: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
33: --ad_patch_impact_api.get_recommend_patch_list(buglist);--ang
34: ad_patch_impact_api.get_recommend_patch_list(patchlist);--ang
35:
36: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> master patch list = '||patchlist.COUNT||' patches');

Line 33: --ad_patch_impact_api.get_recommend_patch_list(buglist);--ang

29: i INTEGER;
30: BEGIN
31: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> reading patch list...');
32: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
33: --ad_patch_impact_api.get_recommend_patch_list(buglist);--ang
34: ad_patch_impact_api.get_recommend_patch_list(patchlist);--ang
35:
36: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> master patch list = '||patchlist.COUNT||' patches');
37: for i in 1..patchlist.COUNT

Line 34: ad_patch_impact_api.get_recommend_patch_list(patchlist);--ang

30: BEGIN
31: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> reading patch list...');
32: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
33: --ad_patch_impact_api.get_recommend_patch_list(buglist);--ang
34: ad_patch_impact_api.get_recommend_patch_list(patchlist);--ang
35:
36: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> master patch list = '||patchlist.COUNT||' patches');
37: for i in 1..patchlist.COUNT
38: loop

Line 65: buglist ad_patch_impact_api.t_prereq_patch;

61:
62: --ang commenting out the below code as prereq analysis is, at the moment, not supported by AD
63: /*PROCEDURE makeprereqs(request_id__ INTEGER, bug_no__ INTEGER) IS
64: snapshot_id__ NUMBER;
65: buglist ad_patch_impact_api.t_prereq_patch;
66: prereq_bug_no INTEGER;
67: patch_order INTEGER;
68: BEGIN
69: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);

Line 69: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);

65: buglist ad_patch_impact_api.t_prereq_patch;
66: prereq_bug_no INTEGER;
67: patch_order INTEGER;
68: BEGIN
69: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
70: ad_patch_impact_api.get_prereq_list(bug_no__, buglist);
71:
72: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> '||bug_no__||' prereq list = '||buglist.COUNT||' patches');
73: for patch_order in 1..buglist.COUNT

Line 70: ad_patch_impact_api.get_prereq_list(bug_no__, buglist);

66: prereq_bug_no INTEGER;
67: patch_order INTEGER;
68: BEGIN
69: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
70: ad_patch_impact_api.get_prereq_list(bug_no__, buglist);
71:
72: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> '||bug_no__||' prereq list = '||buglist.COUNT||' patches');
73: for patch_order in 1..buglist.COUNT
74: loop

Line 372: patchlist__ ad_patch_impact_api.t_recomm_patch_tab; --todo

368: CLOSE bugsnaps2;
369: end rsync2;
370:
371: PROCEDURE refresh(request_id__ INTEGER, stage__ CHAR) IS
372: patchlist__ ad_patch_impact_api.t_recomm_patch_tab; --todo
373: BEGIN
374: -- dbms_output.put_line(to_char(sysdate,'HH24:MI:SS')||'> master running['||request_id__||' stage='||stage__||']...');
375: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> master running['||request_id__||' stage='||stage__||']...');
376:

Line 387: ad_patch_impact_api.get_recommend_patch_list(patchlist__);

383: end if;
384:
385: -- Aggregate Patch Impact for request_id -- all patches in request
386: if(stage__ = '3') then
387: ad_patch_impact_api.get_recommend_patch_list(patchlist__);
388: set_aggregate_list(request_id__, patchlist__);
389: aggregate_patches(request_id__);
390: end if;
391:

Line 400: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);

396: PROCEDURE aggregate_patches(request_id__ INTEGER) IS
397: snapshot_id__ NUMBER;
398: BEGIN
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'

Line 444: PROCEDURE set_aggregate_list(request_id INTEGER, buglist ad_patch_impact_api.t_rec_patch) IS

440: CLOSE agg_list;
441: return patchlist__;
442: END get_aggregate_list;
443:
444: PROCEDURE set_aggregate_list(request_id__ INTEGER, buglist__ ad_patch_impact_api.t_rec_patch) IS
445: i INTEGER;
446: snapshot_id__ NUMBER;
447: bug_no INTEGER;
448: BEGIN

Line 449: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);

445: i INTEGER;
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

Line 464: PROCEDURE set_aggregate_list(request_id INTEGER, patchlist ad_patch_impact_api.t_recomm_patch_tab) IS

460: end loop;
461: commit;
462: END set_aggregate_list;
463:
464: PROCEDURE set_aggregate_list(request_id__ INTEGER, patchlist__ ad_patch_impact_api.t_recomm_patch_tab) IS
465: i INTEGER;
466: snapshot_id__ NUMBER;
467: patch_id INTEGER;
468: BEGIN

Line 469: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);

465: i INTEGER;
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

Line 493: prereq_buglist__ ad_patch_impact_api.t_prereq_patch;

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;
493: prereq_buglist__ ad_patch_impact_api.t_prereq_patch;
494: tmp1 top_level_bug%ROWTYPE;
495: BEGIN
496: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
497: OPEN top_level_bug;

Line 496: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);

492: prereq_bug_no INTEGER;
493: prereq_buglist__ ad_patch_impact_api.t_prereq_patch;
494: tmp1 top_level_bug%ROWTYPE;
495: BEGIN
496: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
497: OPEN top_level_bug;
498: LOOP
499: FETCH top_level_bug into tmp1;
500: EXIT WHEN top_level_bug%NOTFOUND;

Line 501: ad_patch_impact_api.get_prereq_list(request_id__, tmp1.bug_no, prereq_buglist__);

497: OPEN top_level_bug;
498: LOOP
499: FETCH top_level_bug into tmp1;
500: EXIT WHEN top_level_bug%NOTFOUND;
501: ad_patch_impact_api.get_prereq_list(request_id__, tmp1.bug_no, prereq_buglist__);
502: for i in 1..prereq_buglist__.COUNT
503: loop
504: prereq_bug_no := prereq_buglist__(i);
505: -- for each pre-req patch in request, enter record in bugset

Line 711: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);

707: and snapshot_id = v_snapshot_id;
708: BEGIN
709: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> computing language impact['||request_id__||']...');
710:
711: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
712:
713: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> snapshot_id['||snapshot_id__||']...');
714:
715: -- Cleanup any records associated with this request_id