[Home] [Help]
PACKAGE: APPS.FND_OAM_UMS_LOADER
Source
1 package fnd_oam_ums_loader 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;