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 1546: -- Inserts those BUG_IDs into AD_SNAPSHOT_BUGFIXES

1542: -- Creates new rows in the AD_BUGS for the new bugnumbers
1543: -- and gets the bug_id for those bugnumbers and stores them
1544: -- ad_check_file_temp table .
1545: --
1546: -- Inserts those BUG_IDs into AD_SNAPSHOT_BUGFIXES
1547: --
1548: --
1549: -- Arguments
1550: -- None

Line 1689: 'INSERT into ad_snapshot_bugfixes( '||

1685: -- store the pre-seed the list of bug fixes included
1686: -- in that Maintenance Pack.
1687: --
1688: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1689: 'INSERT into ad_snapshot_bugfixes( '||
1690: 'snapshot_bug_id,snapshot_id, '||
1691: 'bugfix_id,bug_status,success_flag, '||
1692: 'creation_date,last_update_date, '||
1693: 'last_updated_by,created_by) '||

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

1690: 'snapshot_bug_id,snapshot_id, '||
1691: 'bugfix_id,bug_status,success_flag, '||
1692: 'creation_date,last_update_date, '||
1693: 'last_updated_by,created_by) '||
1694: 'SELECT ad_snapshot_bugfixes_s.nextval,'||
1695: 'file_version_id_2, file_id,''EXPLICIT'',''Y'','||
1696: 'sysdate, sysdate,5,5 FROM ad_check_file_temp t '||
1697: 'where not exists (select ''already present'' '||
1698: 'from ad_snapshot_bugfixes b '||

Line 1698: 'from ad_snapshot_bugfixes b '||

1694: 'SELECT ad_snapshot_bugfixes_s.nextval,'||
1695: 'file_version_id_2, file_id,''EXPLICIT'',''Y'','||
1696: 'sysdate, sysdate,5,5 FROM ad_check_file_temp t '||
1697: 'where not exists (select ''already present'' '||
1698: 'from ad_snapshot_bugfixes b '||
1699: 'where b.BUGFIX_ID=t.file_id and '||
1700: 'b.SNAPSHOT_ID=t.file_version_id_2):(';
1701:
1702:

Line 1704: INSERT into ad_snapshot_bugfixes(

1700: 'b.SNAPSHOT_ID=t.file_version_id_2):(';
1701:
1702:
1703: begin
1704: INSERT into ad_snapshot_bugfixes(
1705: snapshot_bug_id,snapshot_id,
1706: bugfix_id,bug_status,success_flag,creation_date,
1707: last_update_date,last_updated_by,created_by)
1708: SELECT ad_snapshot_bugfixes_s.nextval,file_version_id_2,

Line 1708: SELECT ad_snapshot_bugfixes_s.nextval,file_version_id_2,

1704: INSERT into ad_snapshot_bugfixes(
1705: snapshot_bug_id,snapshot_id,
1706: bugfix_id,bug_status,success_flag,creation_date,
1707: last_update_date,last_updated_by,created_by)
1708: SELECT ad_snapshot_bugfixes_s.nextval,file_version_id_2,
1709: file_id,'EXPLICIT','Y',sysdate,
1710: sysdate,5,5
1711: FROM
1712: ad_check_file_temp t

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

1710: sysdate,5,5
1711: FROM
1712: ad_check_file_temp t
1713: where not exists
1714: (select /*+ INDEX(B AD_SNAPSHOT_BUGFIXES_U2) */ 'already present'
1715: from ad_snapshot_bugfixes b
1716: where b.BUGFIX_ID=t.file_id and
1717: b.SNAPSHOT_ID=t.file_version_id_2);
1718: exception

Line 1715: from ad_snapshot_bugfixes b

1711: FROM
1712: ad_check_file_temp t
1713: where not exists
1714: (select /*+ INDEX(B AD_SNAPSHOT_BUGFIXES_U2) */ 'already present'
1715: from ad_snapshot_bugfixes b
1716: where b.BUGFIX_ID=t.file_id and
1717: b.SNAPSHOT_ID=t.file_version_id_2);
1718: exception
1719: when others then

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

2809: --
2810: -- p_iteration - which iteration (1,2,etc)
2811: -- Purpose
2812: -- This procedure populates temp table with a range of bugfix_id
2813: -- processes the data and updates the ad_snapshot_bugfixes with negative
2814: -- global snapshot_id
2815: -- Notes
2816: --
2817: procedure populate_snapshot_bugs_temp(p_applications_sys_name varchar2,p_min_bug_id number,

Line 2869: insert into ad_snapshot_bugfixes

2865: end if;
2866: v_global_snapshot_id:=(-1 *p_global_snapshot_id);
2867: --
2868: --
2869: insert into ad_snapshot_bugfixes
2870: (
2871: SNAPSHOT_BUG_ID,
2872: snapshot_id, bugfix_id,
2873: inconsistent_flag,

Line 2879: ad_snapshot_bugfixes_s.nextval,v_global_snapshot_id,

2875: creation_date,last_update_date,last_updated_by,
2876: created_by
2877: )
2878: select
2879: ad_snapshot_bugfixes_s.nextval,v_global_snapshot_id,
2880: bugfix_id,
2881: 'N',
2882: bug_status,success_flag,
2883: sysdate,sysdate,5,5

Line 2893: ad_snapshot_bugfixes

2889: 2, 'Y', 'N') success_flag,
2890: decode(max(decode(bug_status, 'EXPLICIT', 2, 1)),
2891: 2, 'EXPLICIT', 'IMPLICIT') bug_status
2892: from
2893: ad_snapshot_bugfixes
2894: where
2895: bugfix_id >= p_min_bug_id and
2896: bugfix_id < p_max_bug_id and
2897: snapshot_id in (select patch_run_id from ad_patch_hist_temp)

Line 2924: ad_snapshot_bugfixes

2920: 2, 'Y', 'N') success_flag,
2921: decode(max(decode(bug_status, 'EXPLICIT', 2, 1)),
2922: 2, 'EXPLICIT', 'IMPLICIT') bug_status
2923: from
2924: ad_snapshot_bugfixes
2925: where
2926: bugfix_id >= p_min_bug_id and
2927: bugfix_id < p_max_bug_id and
2928: snapshot_id in (select patch_run_id from ad_patch_hist_temp)

Line 2933: execute immediate 'insert into ad_snapshot_bugfixes

2929: group by bugfix_id
2930: having count(distinct decode(success_flag, 'Y', 2, 1)) >1);
2931: --
2932: --
2933: execute immediate 'insert into ad_snapshot_bugfixes
2934: (
2935: SNAPSHOT_BUG_ID,
2936: snapshot_id, bugfix_id,
2937: inconsistent_flag,

Line 2943: ad_snapshot_bugfixes_s.nextval,:snp_id,

2939: creation_date,last_update_date,last_updated_by,
2940: created_by
2941: )
2942: select
2943: ad_snapshot_bugfixes_s.nextval,:snp_id,
2944: file_version_id,
2945: ''Y'',
2946: app_short_name , active_flag,
2947: sysdate,sysdate,5,5