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 79: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

75: if (p_appl_top_id = -1)
76: then
77: begin
78: select s.snapshot_id into l_snapshot_id
79: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
80: FND_PRODUCT_GROUPS fpg
81: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
82: and s.snapshot_type =
83: ad_file_sys_snapshots_pkg.get_snapshot_type(GLOBAL_VIEW_SNP_NAME)

Line 96: from AD_SNAPSHOTS

92: end;
93: else
94: begin
95: select snapshot_id into l_snapshot_id
96: from AD_SNAPSHOTS
97: where appl_top_id = p_appl_top_id
98: and snapshot_name = CURRENT_VIEW_SNP_NAME
99: and snapshot_type =
100: ad_file_sys_snapshots_pkg.get_snapshot_type(CURRENT_VIEW_SNP_NAME);

Line 169: l_snapshot_id ad_snapshots.snapshot_id%type;

165: p_bug_number in varchar2,
166: p_language in varchar2)
167: return varchar2
168: is
169: l_snapshot_id ad_snapshots.snapshot_id%type;
170: l_bug_id ad_bugs.bug_id%type;
171: l_bugst ad_snapshot_bugfixes.bug_status%type;
172: BEGIN
173:

Line 178: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

174: if (p_appl_top_id = -1)
175: then
176: begin
177: select s.snapshot_id into l_snapshot_id
178: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
179: FND_PRODUCT_GROUPS fpg
180: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
181: and s.snapshot_type =
182: ad_file_sys_snapshots_pkg.get_snapshot_type(GLOBAL_VIEW_SNP_NAME)

Line 195: from AD_SNAPSHOTS

191: end;
192: else
193: begin
194: select snapshot_id into l_snapshot_id
195: from AD_SNAPSHOTS
196: where appl_top_id = p_appl_top_id
197: and snapshot_name = CURRENT_VIEW_SNP_NAME
198: and snapshot_type =
199: ad_file_sys_snapshots_pkg.get_snapshot_type(CURRENT_VIEW_SNP_NAME);

Line 357: l_snapshot_id ad_snapshots.snapshot_id%TYPE;

353: p_object_version in varchar2)
354: return varchar2
355: is
356: l_file_id ad_files.file_id%TYPE;
357: l_snapshot_id ad_snapshots.snapshot_id%TYPE;
358: l_ver ad_file_versions.version%TYPE;
359: l_dbver ad_file_versions.version%TYPE;
360: max_ver_indb ad_file_versions.version%TYPE;
361: ret boolean := FALSE;

Line 380: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

376: if (p_appl_top_id = -1)
377: then
378: begin
379: select s.snapshot_id into l_snapshot_id
380: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
381: FND_PRODUCT_GROUPS fpg
382: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
383: and s.snapshot_type =
384: ad_file_sys_snapshots_pkg.get_snapshot_type(GLOBAL_VIEW_SNP_NAME)

Line 398: from AD_SNAPSHOTS

394: end;
395: else
396: begin
397: select snapshot_id into l_snapshot_id
398: from AD_SNAPSHOTS
399: where appl_top_id = p_appl_top_id
400: and snapshot_name = CURRENT_VIEW_SNP_NAME
401: and snapshot_type =
402: ad_file_sys_snapshots_pkg.get_snapshot_type(CURRENT_VIEW_SNP_NAME);

Line 459: l_snapshot_id AD_SNAPSHOTS.snapshot_id%type;

455: procedure mark_patch_bug_in_snpbgfix(p_appl_top_id in number,
456: p_patch_run_id in number,
457: p_flag in varchar2)
458: is
459: l_snapshot_id AD_SNAPSHOTS.snapshot_id%type;
460:
461: cursor BUG_ID_CUR is
462: select bug_id
463: from AD_PATCH_RUN_BUGS

Line 478: from AD_SNAPSHOTS

474: begin
475:
476: begin
477: select snapshot_id into l_snapshot_id
478: from AD_SNAPSHOTS
479: where appl_top_id = p_appl_top_id
480: and snapshot_name = CURRENT_VIEW_SNP_NAME
481: and snapshot_type =
482: ad_file_sys_snapshots_pkg.get_snapshot_type(CURRENT_VIEW_SNP_NAME);

Line 553: l_snapshot_id AD_SNAPSHOTS.snapshot_id%type;

549: p_bug_id in number,
550: p_flag in varchar2)
551: is
552: l_bug_id ad_bugs.bug_id%TYPE;
553: l_snapshot_id AD_SNAPSHOTS.snapshot_id%type;
554:
555: cursor FIND_SUCC_CUR(p_bug_id in ad_bugs.bug_id%type) is
556: select success_flag
557: from AD_PATCH_RUN_BUGS

Line 567: from AD_SNAPSHOTS

563: begin
564:
565: begin
566: select snapshot_id into l_snapshot_id
567: from AD_SNAPSHOTS
568: where appl_top_id = p_appl_top_id
569: and snapshot_name = CURRENT_VIEW_SNP_NAME
570: and snapshot_type =
571: ad_file_sys_snapshots_pkg.get_snapshot_type(CURRENT_VIEW_SNP_NAME);

Line 844: l_snapshot_id ad_snapshots.snapshot_id%TYPE;

840: p_bug_number in varchar2,
841: p_bug_status in varchar2)
842: is
843: l_bug_id ad_bugs.bug_id%TYPE;
844: l_snapshot_id ad_snapshots.snapshot_id%TYPE;
845: l_snapshot_bug_id ad_snapshot_bugfixes.snapshot_bug_id%TYPE;
846:
847: begin
848:

Line 859: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

855: if (p_appl_top_id = -1)
856: then
857: begin
858: select s.snapshot_id into l_snapshot_id
859: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
860: FND_PRODUCT_GROUPS fpg
861: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
862: and s.snapshot_type =
863: ad_file_sys_snapshots_pkg.get_snapshot_type(GLOBAL_VIEW_SNP_NAME)

Line 877: from AD_SNAPSHOTS

873: end;
874: else
875: begin
876: select snapshot_id into l_snapshot_id
877: from AD_SNAPSHOTS
878: where appl_top_id = p_appl_top_id
879: and snapshot_name = CURRENT_VIEW_SNP_NAME
880: and snapshot_type =
881: ad_file_sys_snapshots_pkg.get_snapshot_type(CURRENT_VIEW_SNP_NAME);