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_SYS_SNAPSHOTS_PKG dependencies on AD_SNAPSHOT_BUGFIXES_S

Line 121: ad_snapshot_bugfixes_s.nextval,

117: success_flag,
118: creation_date, last_update_date, last_updated_by, created_by
119: )
120: select
121: ad_snapshot_bugfixes_s.nextval,
122: p_snapshot_id,
123: t.bug_id,
124: 'EXPLICIT',
125: 'Y',

Line 130: from ad_snapshot_bugfixes sb2

126: sysdate, sysdate, 5, 5
127: from ad_patch_hist_snaps_temp t
128: where t.action_code = L_BUGSTAT_EXPL_ACT_CD
129: and not exists (select 'Bug not yet recorded in the curr-vw'
130: from ad_snapshot_bugfixes sb2
131: where sb2.snapshot_id = p_snapshot_id
132: and sb2.bugfix_id = t.bug_id);
133:
134: l_snapshot_bugs_inserted := sql%rowcount;

Line 149: update ad_snapshot_bugfixes sb

145: end if;
146:
147: -- update the status of existing ones, if they dont already say EXPLICIT, Y
148:
149: update ad_snapshot_bugfixes sb
150: set sb.bug_status = 'EXPLICIT',
151: sb.success_flag = 'Y',
152: sb.last_update_date = sysdate,
153: sb.last_updated_by = 5

Line 185: ad_snapshot_bugfixes_s.nextval,

181: bug_status, success_flag,
182: creation_date, last_update_date, last_updated_by, created_by
183: )
184: select
185: ad_snapshot_bugfixes_s.nextval,
186: p_global_snapshot_id, t.bug_id,
187: 'EXPLICIT', 'Y',
188: sysdate, sysdate, 5, 5
189: from ad_patch_hist_snaps_temp t

Line 192: from ad_snapshot_bugfixes sb2

188: sysdate, sysdate, 5, 5
189: from ad_patch_hist_snaps_temp t
190: where t.action_code = L_BUGSTAT_EXPL_ACT_CD
191: and not exists (select 'Bug not yet recorded in the curr-vw'
192: from ad_snapshot_bugfixes sb2
193: where sb2.snapshot_id = p_global_snapshot_id
194: and sb2.bugfix_id = t.bug_id);
195:
196: l_snapshot_bugs_inserted := l_snapshot_bugs_inserted + sql%rowcount;

Line 210: update ad_snapshot_bugfixes sb

206: end if;
207:
208: -- update the status of existing ones, if they dont already say EXPLICIT, Y
209:
210: update ad_snapshot_bugfixes sb
211: set sb.bug_status = 'EXPLICIT',
212: sb.success_flag = 'Y',
213: sb.last_update_date = sysdate,
214: sb.last_updated_by = 5,

Line 703: ad_snapshot_bugfixes_s.nextval,

699: creation_date, last_update_date, last_updated_by, created_by,
700: inconsistent_flag
701: )
702: select
703: ad_snapshot_bugfixes_s.nextval,
704: l_global_snapshot_id,
705: sbs.bugfix_id,
706: sbs.bug_status,
707: sbs.success_flag,

Line 710: from ad_snapshot_bugfixes sbs -- seeded

706: sbs.bug_status,
707: sbs.success_flag,
708: sysdate, sysdate, 5, 5,
709: 'N' /* inconsistent_flag: set to 'N' */
710: from ad_snapshot_bugfixes sbs -- seeded
711: where sbs.snapshot_id = l_preseeded_snapshot_id
712: and not exists (select /*+ INDEX(SB2 AD_SNAPSHOT_BUGFIXES_U2) */
713: 'Already exists'
714: from ad_snapshot_bugfixes sb2

Line 714: from ad_snapshot_bugfixes sb2

710: from ad_snapshot_bugfixes sbs -- seeded
711: where sbs.snapshot_id = l_preseeded_snapshot_id
712: and not exists (select /*+ INDEX(SB2 AD_SNAPSHOT_BUGFIXES_U2) */
713: 'Already exists'
714: from ad_snapshot_bugfixes sb2
715: where sb2.snapshot_id = l_global_snapshot_id
716: and sb2.bugfix_id = sbs.bugfix_id);
717:
718:

Line 854: ad_snapshot_bugfixes_s.nextval, l_global_snapshot_id,

850: inconsistent_flag,
851: creation_date, last_update_date, last_updated_by, created_by
852: )
853: select
854: ad_snapshot_bugfixes_s.nextval, l_global_snapshot_id,
855: t.bugfix_id, t.bug_status, t.success_flag,
856: decode(l_count_appltops, 1, 'N', null),
857: sysdate, sysdate, 5, 5
858: from ad_snapshot_bugfixes_temp t

Line 860: from ad_snapshot_bugfixes sb2

856: decode(l_count_appltops, 1, 'N', null),
857: sysdate, sysdate, 5, 5
858: from ad_snapshot_bugfixes_temp t
859: where not exists (select 'Already exists'
860: from ad_snapshot_bugfixes sb2
861: where sb2.snapshot_id = l_global_snapshot_id
862: and sb2.bugfix_id = t.bugfix_id);
863:
864: -- Now insert files into actual table

Line 2357: ad_snapshot_bugfixes_s.nextval,

2353: bug_status, success_flag,
2354: creation_date, last_update_date, last_updated_by, created_by
2355: )
2356: select
2357: ad_snapshot_bugfixes_s.nextval,
2358: l_curr_vw_snapshot_id, sbs.bugfix_id,
2359: sbs.bug_status, sbs.success_flag,
2360: sysdate, sysdate, 5, 5
2361: from ad_snapshot_bugfixes sbs -- seeded

Line 2361: from ad_snapshot_bugfixes sbs -- seeded

2357: ad_snapshot_bugfixes_s.nextval,
2358: l_curr_vw_snapshot_id, sbs.bugfix_id,
2359: sbs.bug_status, sbs.success_flag,
2360: sysdate, sysdate, 5, 5
2361: from ad_snapshot_bugfixes sbs -- seeded
2362: where sbs.snapshot_id = l_preseeded_snapshot_id
2363: and not exists (select /*+ INDEX(SB2 AD_SNAPSHOT_BUGFIXES_U2) */
2364: 'Already exists'
2365: from ad_snapshot_bugfixes sb2

Line 2365: from ad_snapshot_bugfixes sb2

2361: from ad_snapshot_bugfixes sbs -- seeded
2362: where sbs.snapshot_id = l_preseeded_snapshot_id
2363: and not exists (select /*+ INDEX(SB2 AD_SNAPSHOT_BUGFIXES_U2) */
2364: 'Already exists'
2365: from ad_snapshot_bugfixes sb2
2366: where sb2.snapshot_id = l_curr_vw_snapshot_id
2367: and sb2.bugfix_id = sbs.bugfix_id);
2368:
2369: l_snapshot_bugs_inserted := sql%rowcount;