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 148: ad_snapshot_bugfixes_s.nextval,

144: success_flag,
145: creation_date, last_update_date, last_updated_by, created_by
146: )
147: select
148: ad_snapshot_bugfixes_s.nextval,
149: p_snapshot_id,
150: t.bug_id,
151: 'EXPLICIT',
152: 'Y',

Line 157: from ad_snapshot_bugfixes sb2

153: sysdate, sysdate, 5, 5
154: from ad_patch_hist_snaps_temp t
155: where t.action_code = L_BUGSTAT_EXPL_ACT_CD
156: and not exists (select 'Bug not yet recorded in the curr-vw'
157: from ad_snapshot_bugfixes sb2
158: where sb2.snapshot_id = p_snapshot_id
159: and sb2.bugfix_id = t.bug_id);
160:
161: l_snapshot_bugs_inserted := sql%rowcount;

Line 176: update ad_snapshot_bugfixes sb

172: end if;
173:
174: -- update the status of existing ones, if they dont already say EXPLICIT, Y
175:
176: update ad_snapshot_bugfixes sb
177: set sb.bug_status = 'EXPLICIT',
178: sb.success_flag = 'Y',
179: sb.last_update_date = sysdate,
180: sb.last_updated_by = 5

Line 212: ad_snapshot_bugfixes_s.nextval,

208: bug_status, success_flag,
209: creation_date, last_update_date, last_updated_by, created_by
210: )
211: select
212: ad_snapshot_bugfixes_s.nextval,
213: p_global_snapshot_id, t.bug_id,
214: 'EXPLICIT', 'Y',
215: sysdate, sysdate, 5, 5
216: from ad_patch_hist_snaps_temp t

Line 219: from ad_snapshot_bugfixes sb2

215: sysdate, sysdate, 5, 5
216: from ad_patch_hist_snaps_temp t
217: where t.action_code = L_BUGSTAT_EXPL_ACT_CD
218: and not exists (select 'Bug not yet recorded in the curr-vw'
219: from ad_snapshot_bugfixes sb2
220: where sb2.snapshot_id = p_global_snapshot_id
221: and sb2.bugfix_id = t.bug_id);
222:
223: l_snapshot_bugs_inserted := l_snapshot_bugs_inserted + sql%rowcount;

Line 237: update ad_snapshot_bugfixes sb

233: end if;
234:
235: -- update the status of existing ones, if they dont already say EXPLICIT, Y
236:
237: update ad_snapshot_bugfixes sb
238: set sb.bug_status = 'EXPLICIT',
239: sb.success_flag = 'Y',
240: sb.last_update_date = sysdate,
241: sb.last_updated_by = 5,

Line 762: ad_snapshot_bugfixes_s.nextval,

758: creation_date, last_update_date, last_updated_by, created_by,
759: inconsistent_flag
760: )
761: select
762: ad_snapshot_bugfixes_s.nextval,
763: l_global_snapshot_id,
764: sbs.bugfix_id,
765: sbs.bug_status,
766: sbs.success_flag,

Line 769: from ad_snapshot_bugfixes sbs -- seeded

765: sbs.bug_status,
766: sbs.success_flag,
767: sysdate, sysdate, 5, 5,
768: 'N' /* inconsistent_flag: set to 'N' */
769: from ad_snapshot_bugfixes sbs -- seeded
770: where sbs.snapshot_id = l_preseeded_snapshot_id
771: and not exists (select /*+ INDEX(SB2 AD_SNAPSHOT_BUGFIXES_U2) */
772: 'Already exists'
773: from ad_snapshot_bugfixes sb2

Line 773: from ad_snapshot_bugfixes sb2

769: from ad_snapshot_bugfixes sbs -- seeded
770: where sbs.snapshot_id = l_preseeded_snapshot_id
771: and not exists (select /*+ INDEX(SB2 AD_SNAPSHOT_BUGFIXES_U2) */
772: 'Already exists'
773: from ad_snapshot_bugfixes sb2
774: where sb2.snapshot_id = l_global_snapshot_id
775: and sb2.bugfix_id = sbs.bugfix_id);
776:
777:

Line 915: ad_snapshot_bugfixes_s.nextval, l_global_snapshot_id,

911: inconsistent_flag,
912: creation_date, last_update_date, last_updated_by, created_by
913: )
914: select
915: ad_snapshot_bugfixes_s.nextval, l_global_snapshot_id,
916: t.bugfix_id, t.bug_status, t.success_flag,
917: decode(l_count_appltops, 1, 'N', null),
918: sysdate, sysdate, 5, 5
919: from ad_snapshot_bugfixes_temp t

Line 921: from ad_snapshot_bugfixes sb2

917: decode(l_count_appltops, 1, 'N', null),
918: sysdate, sysdate, 5, 5
919: from ad_snapshot_bugfixes_temp t
920: where not exists (select 'Already exists'
921: from ad_snapshot_bugfixes sb2
922: where sb2.snapshot_id = l_global_snapshot_id
923: and sb2.bugfix_id = t.bugfix_id);
924:
925: -- Now insert files into actual table

Line 2447: ad_snapshot_bugfixes_s.nextval,

2443: bug_status, success_flag,
2444: creation_date, last_update_date, last_updated_by, created_by
2445: )
2446: select
2447: ad_snapshot_bugfixes_s.nextval,
2448: l_curr_vw_snapshot_id, sbs.bugfix_id,
2449: sbs.bug_status, sbs.success_flag,
2450: sysdate, sysdate, 5, 5
2451: from ad_snapshot_bugfixes sbs -- seeded

Line 2451: from ad_snapshot_bugfixes sbs -- seeded

2447: ad_snapshot_bugfixes_s.nextval,
2448: l_curr_vw_snapshot_id, sbs.bugfix_id,
2449: sbs.bug_status, sbs.success_flag,
2450: sysdate, sysdate, 5, 5
2451: from ad_snapshot_bugfixes sbs -- seeded
2452: where sbs.snapshot_id = l_preseeded_snapshot_id
2453: and not exists (select /*+ INDEX(SB2 AD_SNAPSHOT_BUGFIXES_U2) */
2454: 'Already exists'
2455: from ad_snapshot_bugfixes sb2

Line 2455: from ad_snapshot_bugfixes sb2

2451: from ad_snapshot_bugfixes sbs -- seeded
2452: where sbs.snapshot_id = l_preseeded_snapshot_id
2453: and not exists (select /*+ INDEX(SB2 AD_SNAPSHOT_BUGFIXES_U2) */
2454: 'Already exists'
2455: from ad_snapshot_bugfixes sb2
2456: where sb2.snapshot_id = l_curr_vw_snapshot_id
2457: and sb2.bugfix_id = sbs.bugfix_id);
2458:
2459: l_snapshot_bugs_inserted := sql%rowcount;