[Home] [Help]
PACKAGE: APPS.FND_UMS_LOADER
Source
1 package fnd_ums_loader AUTHID CURRENT_USER as
2 /* $Header: AFUMSLDS.pls 115.20 2003/05/07 23:14:32 golgun 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_bug_number - the bug number (e.g., 1794581)
48 -- p_download_mode - the download mode (e.g. 'PREREQS_ONLY')
49 -- p_application_short_name - the application short name (e.g., 'FND')
50 -- p_release_status - the release status (e.g., 'RELEASED')
51 -- p_type - the bugfix type (e.g., 'BUGFIX', 'PATCHSET')
52 -- p_abstract - the bug abstract (e.g., 'FLEXFIELD ROLLUP')
53 -- p_last_definition_date - the last definition date (e.g., '2001/04/08 14:10:33')
54 -- p_last_update_date - the last update date (e.g., '2001/04/08 14:10:33')
55 -- p_custom_mode - custom mode flag (e.g., 'FORCE')
56 --------------------------------------------------------------------------------
57 procedure up_fnd_ums_bugfix
58 (p_upload_phase in varchar2,
59 p_release_name in varchar2,
60 p_bug_number in varchar2,
61 p_download_mode in varchar2,
62 p_application_short_name in varchar2,
63 p_release_status in varchar2,
64 p_type in varchar2,
65 p_abstract in varchar2,
66 p_last_definition_date in varchar2,
67 p_last_update_date in varchar2,
68 p_custom_mode in varchar2);
69
70 --------------------------------------------------------------------------------
71 -- Uploads a FND_UMS_BUGFIX_FILE.
72 --
73 -- p_application_short_name - the application short name (e.g., 'FND')
74 -- p_location - the file location (e.g., 'java/flexj')
75 -- p_name - the file name (e.g., 'DescriptiveFlexfield.class')
76 -- p_version - the file version (e.g., '115.17')
77 --------------------------------------------------------------------------------
78 procedure up_fnd_ums_bugfix_file
79 (p_application_short_name in varchar2,
80 p_location in varchar2,
81 p_name in varchar2,
82 p_version in varchar2);
83
84 --------------------------------------------------------------------------------
85 -- Uploads a FND_UMS_BUGFIX_RELATIONSHIP.
86 --
87 -- p_relation_type - the relation type (e.g., 'PREREQS')
88 -- p_related_bugfix_release_name - the related bugfix release name (e.g., '11i')
89 -- p_related_bugfix_bug_number - the related bugfix bug number (e.g., 1961677)
90 -- p_related_bugfix_download_mode - the related bugfix download mode (e.g. 'PREREQS_ONLY')
91 --------------------------------------------------------------------------------
92 procedure up_fnd_ums_bugfix_relationship
93 (p_relation_type in varchar2,
94 p_related_bugfix_release_name in varchar2,
95 p_related_bugfix_bug_number in varchar2,
96 p_related_bugfix_download_mode in varchar2);
97
98 --------------------------------------------------------------------------------
99 -- Uploads a FND_UMS_ONE_BUGFIX.
100 --
101 -- p_upload_phase - the upload phase (e.g., 'BEGIN' or 'END')
102 -- p_release_name - the release name (e.g., '11i')
103 -- p_bug_number - the bug number (e.g., 1794581)
104 --------------------------------------------------------------------------------
105 procedure up_fnd_ums_one_bugfix
106 (p_upload_phase in varchar2,
107 p_release_name in varchar2,
108 p_bug_number in varchar2);
109
110 --------------------------------------------------------------------------------
111 -- Uploads a FND_UMS_BUGFIXES.
112 --
113 -- p_upload_phase - the upload phase (e.g., 'BEGIN' or 'END')
114 -- p_entity_download_mode - the entity download mode
115 -- (e.g., 'ONE', 'UPDATED', 'ALL')
116 -- p_release_name - the release name (e.g., '11i')
117 -- p_bug_number - the bug number (e.g., 1794581)
118 -- (Only applies in entity download mode 'ONE')
119 -- p_start_date - the start date
120 -- (Only applies in entity download modes 'UPDATED' and 'ALL')
121 -- p_end_date - the end_date
122 -- (Only applies in entity download modes 'UPDATED' and 'ALL')
123 --------------------------------------------------------------------------------
124 procedure up_fnd_ums_bugfixes
125 (p_upload_phase in varchar2,
126 p_entity_download_mode in varchar2,
127 p_release_name in varchar2,
128 p_bug_number in varchar2,
129 p_start_date in varchar2,
130 p_end_date in varchar2);
131
132 --------------------------------------------------------------------------------
133 -- Returns newline character independent of the platform
134 -- Copy of the fnd_global.newline() function. However, UMS should not depend
135 -- on any other package.
136 --------------------------------------------------------------------------------
137 function newline return varchar2;
138
139 end fnd_ums_loader;