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.
PACKAGE: APPS.FND_OAM_UMS_LOADER

Source


1 package fnd_oam_ums_loader AUTHID CURRENT_USER as
2 /* $Header: AFOAMUMSLDS.pls 120.1 2006/05/23 18:02:58 rjaiswal noship $ */
3 
4 --------------------------------------------------------------------------------
5 -- UMS Constants
6 --------------------------------------------------------------------------------
7 
8 -- bugfix types:
9 
10 BUGFIX_TYPE_BUGFIX   constant varchar2(30) := 'BUGFIX';
11 BUGFIX_TYPE_PATCHSET constant varchar2(30) := 'PATCHSET';
12 BUGFIX_TYPE_INTERNAL constant varchar2(30) := 'INTERNAL';
13 
14 -- bugfix relation types:
15 
16 REL_TYPE_PREREQS              constant varchar2(30) := 'PREREQS';
17 REL_TYPE_INDIRECTLY_PREREQS   constant varchar2(30) := 'INDIRECTLY_PREREQS';
18 REL_TYPE_INCLUDES             constant varchar2(30) := 'INCLUDES';
19 REL_TYPE_INDIRECTLY_INCLUDES  constant varchar2(30) := 'INDIRECTLY_INCLUDES';
20 REL_TYPE_REPLACED_BY          constant varchar2(30) := 'REPLACED_BY';
21 REL_TYPE_REPLACES             constant varchar2(30) := 'REPLACES';
22 REL_TYPE_REP_BY_FIRST_NON_OBS constant varchar2(30) := 'REPLACED_BY_FIRST_NON_OBSOLETE';
23 
24 -- download modes:
25 
26 DL_MODE_NONE               constant varchar2(30) := 'NONE';
27 DL_MODE_FILES_ONLY         constant varchar2(30) := 'FILES_ONLY';
28 DL_MODE_REPLACEMENTS_ONLY  constant varchar2(30) := 'REPLACEMENTS_ONLY';
29 DL_MODE_REPLACEMENTS_FILES constant varchar2(30) := 'REPLACEMENTS_FILES';
30 DL_MODE_PREREQS_ONLY       constant varchar2(30) := 'PREREQS_ONLY';
31 DL_MODE_PREREQS_FILES      constant varchar2(30) := 'PREREQS_FILES';
32 DL_MODE_LINKS_ONLY         constant varchar2(30) := 'LINKS_ONLY';
33 DL_MODE_LINKS_FILES        constant varchar2(30) := 'LINKS_FILES';
34 
35 --------------------------------------------------------------------------------
36 -- Sets the debug flag.
37 --
38 -- p_debug_flag - the debug flag (e.g., 'N', 'Y')
39 --------------------------------------------------------------------------------
40 procedure set_debugging(p_debug_flag in varchar2);
41 
42 --------------------------------------------------------------------------------
43 -- Uploads a FND_UMS_BUGFIX.
44 --
45 -- p_upload_phase - the upload phase (e.g., 'BEGIN' or 'END')
46 -- p_release_name - the release name (e.g., '11i')
47 -- p_baseline - the baseline (e.g., 'FND.H')
48 -- p_bug_number - the bug number (e.g., 1794581)
49 -- p_download_mode - the download mode (e.g. 'PREREQS_ONLY')
50 -- p_application_short_name - the application short name (e.g., 'FND')
51 -- p_release_status - the release status (e.g., 'RELEASED')
52 -- p_type - the bugfix type (e.g., 'BUGFIX', 'PATCHSET')
53 -- p_abstract - the bug abstract (e.g., 'FLEXFIELD ROLLUP')
54 -- p_last_definition_date - the last definition date (e.g., '2001/04/08 14:10:33')
55 -- p_last_update_date - the last update date (e.g., '2001/04/08 14:10:33')
56 -- p_custom_mode - custom mode flag (e.g., 'FORCE')
57 --------------------------------------------------------------------------------
58 procedure up_fnd_ums_bugfix
59   (p_upload_phase           in varchar2,
60    p_release_name           in varchar2,
61    p_baseline               in varchar2,
62    p_bug_number             in varchar2,
63    p_download_mode          in varchar2,
64    p_application_short_name in varchar2,
65    p_release_status         in varchar2,
66    p_type                   in varchar2,
67    p_abstract               in varchar2,
68    p_last_definition_date   in varchar2,
69    p_last_update_date       in varchar2,
70    p_custom_mode            in varchar2);
71 
72 --------------------------------------------------------------------------------
73 -- Uploads a FND_UMS_BUGFIX_FILE.
74 --
75 -- p_application_short_name - the application short name (e.g., 'FND')
76 -- p_location - the file location (e.g., 'java/flexj')
77 -- p_name - the file name (e.g., 'DescriptiveFlexfield.class')
78 -- p_version - the file version (e.g., '115.17')
79 --------------------------------------------------------------------------------
80 procedure up_fnd_ums_bugfix_file
81   (p_application_short_name in varchar2,
82    p_location               in varchar2,
83    p_name                   in varchar2,
84    p_version                in varchar2);
85 
86 --------------------------------------------------------------------------------
87 -- Uploads a FND_UMS_BUGFIX_RELATIONSHIP.
88 --
89 -- p_relation_type - the relation type (e.g., 'PREREQS')
90 -- p_related_bugfix_release_name - the related bugfix release name (e.g., '11i')
91 -- p_related_bugfix_bug_number - the related bugfix bug number (e.g., 1961677)
92 -- p_related_bugfix_download_mode - the related bugfix download mode (e.g. 'PREREQS_ONLY')
93 --------------------------------------------------------------------------------
94 procedure up_fnd_ums_bugfix_relationship
95   (p_relation_type                in varchar2,
96    p_related_bugfix_release_name  in varchar2,
97    p_related_bugfix_bug_number    in varchar2,
98    p_related_bugfix_download_mode in varchar2);
99 
100 --------------------------------------------------------------------------------
101 -- Uploads a FND_UMS_ONE_BUGFIX.
102 --
103 -- p_upload_phase - the upload phase (e.g., 'BEGIN' or 'END')
104 -- p_release_name - the release name (e.g., '11i')
105 -- p_baseline - the baseline (e.g., 'FND.H')
106 -- p_bug_number - the bug number (e.g., 1794581)
107 --------------------------------------------------------------------------------
108 procedure up_fnd_ums_one_bugfix
109   (p_upload_phase in varchar2,
110    p_release_name in varchar2,
111    p_baseline in varchar2,
112    p_bug_number   in varchar2);
113 
114 --------------------------------------------------------------------------------
115 -- Uploads a FND_UMS_BUGFIXES.
116 --
117 -- p_upload_phase - the upload phase (e.g., 'BEGIN' or 'END')
118 -- p_entity_download_mode - the entity download mode
119 --                          (e.g., 'ONE', 'UPDATED', 'ALL')
120 -- p_release_name - the release name (e.g., '11i')
121 -- p_bug_number - the bug number (e.g., 1794581)
122 --                (Only applies in entity download mode 'ONE')
123 -- p_start_date - the start date
124 --                (Only applies in entity download modes 'UPDATED' and 'ALL')
125 -- p_end_date - the end_date
126 --              (Only applies in entity download modes 'UPDATED' and 'ALL')
127 --------------------------------------------------------------------------------
128 procedure up_fnd_ums_bugfixes
129   (p_upload_phase         in varchar2,
130    p_entity_download_mode in varchar2,
131    p_release_name         in varchar2,
132    p_bug_number           in varchar2,
133    p_start_date           in varchar2,
134    p_end_date             in varchar2);
135 
136 --------------------------------------------------------------------------------
137 -- Returns newline character independent of the platform
138 -- Copy of the fnd_global.newline() function. However, UMS should not depend
139 -- on any other package.
140 --------------------------------------------------------------------------------
141 function newline return varchar2;
142 
143 end fnd_oam_ums_loader;