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.AD_FILE_UTIL dependencies on AD_SNAPSHOT_BUGFIXES

Line 1480: -- Inserts those BUG_IDs into AD_SNAPSHOT_BUGFIXES

1476: -- Creates new rows in the AD_BUGS for the new bugnumbers
1477: -- and gets the bug_id for those bugnumbers and stores them
1478: -- ad_check_file_temp table .
1479: --
1480: -- Inserts those BUG_IDs into AD_SNAPSHOT_BUGFIXES
1481: --
1482: --
1483: -- Arguments
1484: -- None

Line 1623: 'INSERT into ad_snapshot_bugfixes( '||

1619: -- store the pre-seed the list of bug fixes included
1620: -- in that Maintenance Pack.
1621: --
1622: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1623: 'INSERT into ad_snapshot_bugfixes( '||
1624: 'snapshot_bug_id,snapshot_id, '||
1625: 'bugfix_id,bug_status,success_flag, '||
1626: 'creation_date,last_update_date, '||
1627: 'last_updated_by,created_by) '||

Line 1628: 'SELECT ad_snapshot_bugfixes_s.nextval,'||

1624: 'snapshot_bug_id,snapshot_id, '||
1625: 'bugfix_id,bug_status,success_flag, '||
1626: 'creation_date,last_update_date, '||
1627: 'last_updated_by,created_by) '||
1628: 'SELECT ad_snapshot_bugfixes_s.nextval,'||
1629: 'file_version_id_2, file_id,''EXPLICIT'',''Y'','||
1630: 'sysdate, sysdate,5,5 FROM ad_check_file_temp t '||
1631: 'where not exists (select ''already present'' '||
1632: 'from ad_snapshot_bugfixes b '||

Line 1632: 'from ad_snapshot_bugfixes b '||

1628: 'SELECT ad_snapshot_bugfixes_s.nextval,'||
1629: 'file_version_id_2, file_id,''EXPLICIT'',''Y'','||
1630: 'sysdate, sysdate,5,5 FROM ad_check_file_temp t '||
1631: 'where not exists (select ''already present'' '||
1632: 'from ad_snapshot_bugfixes b '||
1633: 'where b.BUGFIX_ID=t.file_id and '||
1634: 'b.SNAPSHOT_ID=t.file_version_id_2):(';
1635:
1636:

Line 1638: INSERT into ad_snapshot_bugfixes(

1634: 'b.SNAPSHOT_ID=t.file_version_id_2):(';
1635:
1636:
1637: begin
1638: INSERT into ad_snapshot_bugfixes(
1639: snapshot_bug_id,snapshot_id,
1640: bugfix_id,bug_status,success_flag,creation_date,
1641: last_update_date,last_updated_by,created_by)
1642: SELECT ad_snapshot_bugfixes_s.nextval,file_version_id_2,

Line 1642: SELECT ad_snapshot_bugfixes_s.nextval,file_version_id_2,

1638: INSERT into ad_snapshot_bugfixes(
1639: snapshot_bug_id,snapshot_id,
1640: bugfix_id,bug_status,success_flag,creation_date,
1641: last_update_date,last_updated_by,created_by)
1642: SELECT ad_snapshot_bugfixes_s.nextval,file_version_id_2,
1643: file_id,'EXPLICIT','Y',sysdate,
1644: sysdate,5,5
1645: FROM
1646: ad_check_file_temp t

Line 1648: (select /+ INDEX(B AD_SNAPSHOT_BUGFIXES_U2) / 'already present'

1644: sysdate,5,5
1645: FROM
1646: ad_check_file_temp t
1647: where not exists
1648: (select /*+ INDEX(B AD_SNAPSHOT_BUGFIXES_U2) */ 'already present'
1649: from ad_snapshot_bugfixes b
1650: where b.BUGFIX_ID=t.file_id and
1651: b.SNAPSHOT_ID=t.file_version_id_2);
1652: exception

Line 1649: from ad_snapshot_bugfixes b

1645: FROM
1646: ad_check_file_temp t
1647: where not exists
1648: (select /*+ INDEX(B AD_SNAPSHOT_BUGFIXES_U2) */ 'already present'
1649: from ad_snapshot_bugfixes b
1650: where b.BUGFIX_ID=t.file_id and
1651: b.SNAPSHOT_ID=t.file_version_id_2);
1652: exception
1653: when others then

Line 2716: -- processes the data and updates the ad_snapshot_bugfixes with negative

2712: --
2713: -- p_iteration - which iteration (1,2,etc)
2714: -- Purpose
2715: -- This procedure populates temp table with a range of bugfix_id
2716: -- processes the data and updates the ad_snapshot_bugfixes with negative
2717: -- global snapshot_id
2718: -- Notes
2719: --
2720: procedure populate_snapshot_bugs_temp(p_applications_sys_name varchar2,p_min_bug_id number,

Line 2755: insert into ad_snapshot_bugfixes

2751: end if;
2752: v_global_snapshot_id:=(-1 *p_global_snapshot_id);
2753: --
2754: --
2755: insert into ad_snapshot_bugfixes
2756: (
2757: SNAPSHOT_BUG_ID,
2758: snapshot_id, bugfix_id,
2759: inconsistent_flag,

Line 2765: ad_snapshot_bugfixes_s.nextval,v_global_snapshot_id,

2761: creation_date,last_update_date,last_updated_by,
2762: created_by
2763: )
2764: select
2765: ad_snapshot_bugfixes_s.nextval,v_global_snapshot_id,
2766: bugfix_id,
2767: 'N',
2768: bug_status,success_flag,
2769: sysdate,sysdate,5,5

Line 2779: ad_snapshot_bugfixes

2775: 2, 'Y', 'N') success_flag,
2776: decode(max(decode(bug_status, 'EXPLICIT', 2, 1)),
2777: 2, 'EXPLICIT', 'IMPLICIT') bug_status
2778: from
2779: ad_snapshot_bugfixes
2780: where
2781: bugfix_id >= p_min_bug_id and
2782: bugfix_id < p_max_bug_id and
2783: snapshot_id in (select patch_run_id from ad_patch_hist_temp)

Line 2810: ad_snapshot_bugfixes

2806: 2, 'Y', 'N') success_flag,
2807: decode(max(decode(bug_status, 'EXPLICIT', 2, 1)),
2808: 2, 'EXPLICIT', 'IMPLICIT') bug_status
2809: from
2810: ad_snapshot_bugfixes
2811: where
2812: bugfix_id >= p_min_bug_id and
2813: bugfix_id < p_max_bug_id and
2814: snapshot_id in (select patch_run_id from ad_patch_hist_temp)

Line 2819: execute immediate 'insert into ad_snapshot_bugfixes

2815: group by bugfix_id
2816: having count(distinct decode(success_flag, 'Y', 2, 1)) >1);
2817: --
2818: --
2819: execute immediate 'insert into ad_snapshot_bugfixes
2820: (
2821: SNAPSHOT_BUG_ID,
2822: snapshot_id, bugfix_id,
2823: inconsistent_flag,

Line 2829: ad_snapshot_bugfixes_s.nextval,:snp_id,

2825: creation_date,last_update_date,last_updated_by,
2826: created_by
2827: )
2828: select
2829: ad_snapshot_bugfixes_s.nextval,:snp_id,
2830: file_version_id,
2831: ''Y'',
2832: app_short_name , active_flag,
2833: sysdate,sysdate,5,5