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_PATCH dependencies on AD_SNAPSHOTS

Line 25: the query has to join on ad_snapshots,ad_snapshot_bugfixes and ad_bugs

21: resulting in simpler joins. This function queries on AD_SNAPSHOT_BUGFIXES
22: bug_status column to report the status of a bug.
23: With the snapshot project, and changes to the patch history data
24: model, the bug_status column is moved to ad_snapshot_bugfixes and hence
25: the query has to join on ad_snapshots,ad_snapshot_bugfixes and ad_bugs
26: tables.
27: 2/15/02 : app_short_name is moved from AD_BUGS to AD_PATCH_RUN_BUGS
28: due to AOL's requirement, since AOL doesn't always know
29: app_short_name to pass.

Line 65: l_snapshot_id ad_snapshots.snapshot_id%type;

61: );
62:
63: l_bugst ad_snapshot_bugfixes.bug_status%type;
64: l_bugid ad_bugs.bug_id%type;
65: l_snapshot_id ad_snapshots.snapshot_id%type;
66:
67: l_row_found boolean := TRUE;
68: begin
69:

Line 74: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

70: if (p_appl_top_id = -1)
71: then
72: begin
73: select s.snapshot_id into l_snapshot_id
74: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
75: FND_PRODUCT_GROUPS fpg
76: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
77: and s.snapshot_type = 'G'
78: and s.appl_top_id = a.appl_top_id

Line 90: from AD_SNAPSHOTS

86: end;
87: else
88: begin
89: select snapshot_id into l_snapshot_id
90: from AD_SNAPSHOTS
91: where appl_top_id = p_appl_top_id
92: and snapshot_name = CURRENT_VIEW_SNP_NAME
93: and snapshot_type = 'C';
94: exception

Line 162: l_snapshot_id ad_snapshots.snapshot_id%type;

158: p_bug_number in varchar2,
159: p_language in varchar2)
160: return varchar2
161: is
162: l_snapshot_id ad_snapshots.snapshot_id%type;
163: l_bug_id ad_bugs.bug_id%type;
164: l_bugst ad_snapshot_bugfixes.bug_status%type;
165: BEGIN
166:

Line 171: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

167: if (p_appl_top_id = -1)
168: then
169: begin
170: select s.snapshot_id into l_snapshot_id
171: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
172: FND_PRODUCT_GROUPS fpg
173: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
174: and s.snapshot_type = 'G'
175: and s.appl_top_id = a.appl_top_id

Line 187: from AD_SNAPSHOTS

183: end;
184: else
185: begin
186: select snapshot_id into l_snapshot_id
187: from AD_SNAPSHOTS
188: where appl_top_id = p_appl_top_id
189: and snapshot_name = CURRENT_VIEW_SNP_NAME
190: and snapshot_type = 'C';
191: exception

Line 348: l_snapshot_id ad_snapshots.snapshot_id%TYPE;

344: p_object_version in varchar2)
345: return varchar2
346: is
347: l_file_id ad_files.file_id%TYPE;
348: l_snapshot_id ad_snapshots.snapshot_id%TYPE;
349: l_ver ad_file_versions.version%TYPE;
350: l_dbver ad_file_versions.version%TYPE;
351: max_ver_indb ad_file_versions.version%TYPE;
352: ret boolean := FALSE;

Line 371: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

367: if (p_appl_top_id = -1)
368: then
369: begin
370: select s.snapshot_id into l_snapshot_id
371: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
372: FND_PRODUCT_GROUPS fpg
373: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
374: and s.snapshot_type = 'G'
375: and s.appl_top_id = a.appl_top_id

Line 388: from AD_SNAPSHOTS

384: end;
385: else
386: begin
387: select snapshot_id into l_snapshot_id
388: from AD_SNAPSHOTS
389: where appl_top_id = p_appl_top_id
390: and snapshot_name = CURRENT_VIEW_SNP_NAME
391: and snapshot_type = 'C';
392: exception

Line 448: l_snapshot_id AD_SNAPSHOTS.snapshot_id%type;

444: procedure mark_patch_bug_in_snpbgfix(p_appl_top_id in number,
445: p_patch_run_id in number,
446: p_flag in varchar2)
447: is
448: l_snapshot_id AD_SNAPSHOTS.snapshot_id%type;
449:
450: cursor BUG_ID_CUR is
451: select bug_id
452: from AD_PATCH_RUN_BUGS

Line 467: from AD_SNAPSHOTS

463: begin
464:
465: begin
466: select snapshot_id into l_snapshot_id
467: from AD_SNAPSHOTS
468: where appl_top_id = p_appl_top_id
469: and snapshot_name = CURRENT_VIEW_SNP_NAME
470: and snapshot_type = 'C';
471: exception

Line 541: l_snapshot_id AD_SNAPSHOTS.snapshot_id%type;

537: p_bug_id in number,
538: p_flag in varchar2)
539: is
540: l_bug_id ad_bugs.bug_id%TYPE;
541: l_snapshot_id AD_SNAPSHOTS.snapshot_id%type;
542:
543: cursor FIND_SUCC_CUR(p_bug_id in ad_bugs.bug_id%type) is
544: select success_flag
545: from AD_PATCH_RUN_BUGS

Line 555: from AD_SNAPSHOTS

551: begin
552:
553: begin
554: select snapshot_id into l_snapshot_id
555: from AD_SNAPSHOTS
556: where appl_top_id = p_appl_top_id
557: and snapshot_name = CURRENT_VIEW_SNP_NAME
558: and snapshot_type = 'C';
559: exception

Line 831: l_snapshot_id ad_snapshots.snapshot_id%TYPE;

827: p_bug_number in varchar2,
828: p_bug_status in varchar2)
829: is
830: l_bug_id ad_bugs.bug_id%TYPE;
831: l_snapshot_id ad_snapshots.snapshot_id%TYPE;
832: l_snapshot_bug_id ad_snapshot_bugfixes.snapshot_bug_id%TYPE;
833:
834: begin
835:

Line 846: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

842: if (p_appl_top_id = -1)
843: then
844: begin
845: select s.snapshot_id into l_snapshot_id
846: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
847: FND_PRODUCT_GROUPS fpg
848: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
849: and s.snapshot_type = 'G'
850: and s.appl_top_id = a.appl_top_id

Line 863: from AD_SNAPSHOTS

859: end;
860: else
861: begin
862: select snapshot_id into l_snapshot_id
863: from AD_SNAPSHOTS
864: where appl_top_id = p_appl_top_id
865: and snapshot_name = CURRENT_VIEW_SNP_NAME
866: and snapshot_type = 'C';
867: exception