[Home] [Help]
PACKAGE: APPS.INV_ITEM_REVISION_PUB
Source
1 PACKAGE INV_ITEM_REVISION_PUB AUTHID CURRENT_USER AS
2 /* $Header: INVPREVS.pls 120.4.12010000.2 2009/07/13 12:07:19 jiabraha ship $ */
3
4 -- ============================================================================
5 -- Global variables and cursors
6 -- ============================================================================
7
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'INVPREVS.pls';
9
10 -- ============================================================================
11 -- Record Type: Item_Revision_rec_type
12 -- ============================================================================
13
14 TYPE Item_Revision_rec_type IS RECORD
15 (
16 inventory_item_id NUMBER
17 , organization_id NUMBER
18 , revision_id NUMBER
19 , revision VARCHAR2(3)
20 , description VARCHAR2(240)
21 , change_notice VARCHAR2(10)
22 , ecn_initiation_date DATE
23 , implementation_date DATE
24 , effectivity_date DATE
25 , revised_item_sequence_id NUMBER
26 , attribute_category VARCHAR2(30)
27 , attribute1 VARCHAR2(150)
28 , attribute2 VARCHAR2(150)
29 , attribute3 VARCHAR2(150)
30 , attribute4 VARCHAR2(150)
31 , attribute5 VARCHAR2(150)
32 , attribute6 VARCHAR2(150)
33 , attribute7 VARCHAR2(150)
34 , attribute8 VARCHAR2(150)
35 , attribute9 VARCHAR2(150)
36 , attribute10 VARCHAR2(150)
37 , attribute11 VARCHAR2(150)
38 , attribute12 VARCHAR2(150)
39 , attribute13 VARCHAR2(150)
40 , attribute14 VARCHAR2(150)
41 , attribute15 VARCHAR2(150)
42 , creation_date DATE
43 , created_by NUMBER
44 , last_update_date DATE
45 , last_updated_by NUMBER
46 , last_update_login NUMBER
47 , request_id NUMBER
48 , program_application_id NUMBER
49 , program_id NUMBER
50 , program_update_date DATE
51 , object_version_number NUMBER
52 , revision_label VARCHAR2(80)
53 , revision_reason VARCHAR2(30)
54 , lifecycle_id NUMBER
55 , current_phase_id NUMBER
56 , template_id MTL_ITEM_TEMPLATES_B.TEMPLATE_ID%TYPE --5208102
57 , template_name MTL_ITEM_TEMPLATES_TL.TEMPLATE_NAME%TYPE --5208102
58 , return_status VARCHAR2(1)
59 , transaction_type VARCHAR2(30)
60 );
61
62
63 -- ------------------- Variables representing missing values ------------------
64
65 g_Miss_Item_Revision_rec Item_Revision_rec_type;
66
67
68 -- ============================================================================
69 -- Start of Comments
70 --
71 -- API Name: Create_Item_Revision
72 --
73 -- Type: Public
74 --
75 -- Pre-Req
76 --
77 -- Parameters
78 --
79 -- IN
80 -- p_api_version IN NUMBER Required
81 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
82 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
83 --
84 -- OUT
85 -- x_return_status OUT VARCHAR2
86 -- x_msg_count OUT NUMBER
87 -- x_msg_data OUT VARCHAR2
88 --
89 -- IN OUT
90 -- p_Item_Revision_rec IN OUT Item_Revision_rec_type Required
91 --
92 -- Version: Current version 1.0
93 --
94 -- End of Comments
95 -- ============================================================================
96
97 PROCEDURE Create_Item_Revision
98 (
99 p_api_version IN NUMBER
100 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
101 , p_commit IN VARCHAR2 := FND_API.G_FALSE
102 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
103 , p_process_control IN VARCHAR2 := NULL
104 , x_return_status OUT NOCOPY VARCHAR2
105 , x_msg_count OUT NOCOPY NUMBER
106 , x_msg_data OUT NOCOPY VARCHAR2
107 , p_Item_Revision_rec IN OUT NOCOPY Item_Revision_rec_type
108 );
109
110 -- ============================================================================
111 -- Start of Comments
112 --
113 -- API Name: Update_Item_Revision
114 --
115 -- Type: Public
116 --
117 -- Pre-Req
118 --
119 -- Parameters
120 --
121 -- IN
122 -- p_api_version_number IN NUMBER Required
123 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125 -- p_process_control IN VARCHAR2 := NULL To identify the caller Bug 5525054
126 -- p_Item_Revision_rec IN Item_Revision_rec_type Required
127 --
128 -- OUT
129 -- x_return_status OUT VARCHAR2
130 -- x_msg_count OUT NUMBER
131 -- x_msg_data OUT VARCHAR2
132 --
133 -- Version: Current version 1.0
134 --
135 -- End of Comments
136 -- ============================================================================
137
138 PROCEDURE Update_Item_Revision
139 (
140 p_api_version IN NUMBER
141 , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
142 , p_commit IN VARCHAR2 := FND_API.g_FALSE
143 , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
144 , p_process_control IN VARCHAR2 := NULL
145 , x_return_status OUT NOCOPY VARCHAR2
146 , x_msg_count OUT NOCOPY NUMBER
147 , x_msg_data OUT NOCOPY VARCHAR2
148 , p_Item_Revision_rec IN OUT NOCOPY Item_Revision_rec_type
149 );
150
151
152 -- ============================================================================
153 -- Start of Comments
154 --
155 -- API Name: Lock_Item_Revision
156 --
157 -- Type: Public
158 --
159 -- Note: For usage in Oracle Forms Apps only.
160 --
161 -- Pre-Req
162 --
163 -- Parameters
164 --
165 -- IN
166 -- p_api_version_number IN NUMBER Required
167 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
168 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
169 -- p_inventory_item_id IN NUMBER Required
170 -- p_organization_id IN NUMBER Required
171 -- p_revision IN VARCHAR2 Required
172 -- p_object_version_number IN NUMBER Required
173 --
174 -- OUT
175 -- x_return_status OUT VARCHAR2
176 -- x_msg_count OUT NUMBER
177 -- x_msg_data OUT VARCHAR2
178 --
179 -- Version: Current version 1.0
180 --
181 -- End of Comments
182 -- ============================================================================
183
184 PROCEDURE Lock_Item_Revision
185 (
186 p_api_version IN NUMBER
187 , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
188 , x_return_status OUT NOCOPY VARCHAR2
189 , x_msg_count OUT NOCOPY NUMBER
190 , x_msg_data OUT NOCOPY VARCHAR2
191 , p_inventory_item_id IN NUMBER
192 , p_organization_id IN NUMBER
193 , p_revision IN VARCHAR2
194 , p_object_version_number IN NUMBER
195 );
196
197
198 -- ============================================================================
199 -- Start of Comments
200 --
201 -- API Name: Delete_Item_Revision
202 --
203 -- Type: Public
204 --
205 -- Pre-Req
206 --
207 -- Parameters
208 --
209 -- IN
210 -- p_api_version_number IN NUMBER Required
211 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
212 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
213 -- p_inventory_item_id IN NUMBER Required
214 -- p_organization_id IN NUMBER Required
215 -- p_revision IN VARCHAR2 Required
216 -- p_object_version_number IN NUMBER Required
217 --
218 -- OUT
219 -- x_return_status OUT VARCHAR2
220 -- x_msg_count OUT NUMBER
221 -- x_msg_data OUT VARCHAR2
222 --
223 -- Version: Current version 1.0
224 --
225 -- End of Comments
226 -- ============================================================================
227
228 PROCEDURE Delete_Item_Revision
229 (
230 p_api_version IN NUMBER
231 , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
232 , p_commit IN VARCHAR2 := FND_API.g_FALSE
233 , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
234 , x_return_status OUT NOCOPY VARCHAR2
235 , x_msg_count OUT NOCOPY NUMBER
236 , x_msg_data OUT NOCOPY VARCHAR2
237 , p_inventory_item_id IN NUMBER
238 , p_organization_id IN NUMBER
239 , p_revision IN VARCHAR2
240 , p_object_version_number IN NUMBER
241 );
242
243 PROCEDURE Process_Item_Revision
244 (
245 p_inventory_item_id IN NUMBER
246 , p_organization_id IN NUMBER
247 , p_revision IN VARCHAR2
248 , p_description IN VARCHAR2 := NULL
249 , p_change_notice IN VARCHAR2 := NULL
250 , p_ecn_initiation_date IN DATE := NULL
251 , p_implementation_date IN DATE := NULL
252 , p_effectivity_date IN DATE := NULL
253 , p_revised_item_sequence_id IN NUMBER := NULL
254 , p_attribute_category IN VARCHAR2 := NULL
255 , p_attribute1 IN VARCHAR2 := NULL
256 , p_attribute2 IN VARCHAR2 := NULL
257 , p_attribute3 IN VARCHAR2 := NULL
258 , p_attribute4 IN VARCHAR2 := NULL
259 , p_attribute5 IN VARCHAR2 := NULL
260 , p_attribute6 IN VARCHAR2 := NULL
261 , p_attribute7 IN VARCHAR2 := NULL
262 , p_attribute8 IN VARCHAR2 := NULL
263 , p_attribute9 IN VARCHAR2 := NULL
264 , p_attribute10 IN VARCHAR2 := NULL
265 , p_attribute11 IN VARCHAR2 := NULL
266 , p_attribute12 IN VARCHAR2 := NULL
267 , p_attribute13 IN VARCHAR2 := NULL
268 , p_attribute14 IN VARCHAR2 := NULL
269 , p_attribute15 IN VARCHAR2 := NULL
270 , p_object_version_number IN NUMBER
271 , p_revision_label IN VARCHAR2 := NULL
272 , p_revision_reason IN VARCHAR2 := NULL
273 , p_lifecycle_id IN NUMBER := NULL
274 , p_current_phase_id IN NUMBER := NULL
275 , p_template_id IN NUMBER := NULL --5208102
276 , p_template_name IN VARCHAR2 := NULL --5208102
277 , p_language_code IN VARCHAR2 := 'US'
278 , p_transaction_type IN VARCHAR2
279 , p_message_API IN VARCHAR2 := 'FND'
280 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
281 , x_Return_Status OUT NOCOPY VARCHAR2
282 , x_msg_count OUT NOCOPY NUMBER
283 , x_msg_data OUT NOCOPY VARCHAR2 /*Added for bug 8634732 to ensure error message is displayed*/
284 , x_revision_id IN OUT NOCOPY NUMBER
285 , x_object_version_number IN OUT NOCOPY NUMBER
286 , p_debug IN VARCHAR2 := 'N'
287 , p_output_dir IN VARCHAR2 := NULL
288 , p_debug_filename IN VARCHAR2 := 'Ego_Item_Revision.log'
289 , p_revision_id IN NUMBER := NULL
290 , p_process_control IN VARCHAR2 := NULL
291 );
292
293
294 -- ============================================================================
295 -- Start of Comments
296 --
297 -- API Name: Copy_Rev_UDA
298 --
299 -- Type: Public
300 --
301 -- Pre-Req
302 --
303 -- Parameters
304 --
305 -- IN
306 -- p_organization_id IN NUMBER Required
307 -- p_inventory_item_id IN NUMBER Required
308 -- p_revision_id IN NUMBER Required
309 -- p_revision IN VARCHAR2 Required
310 -- p_source_revision_id IN NUMBER Optionsal Default NULL
311 --
312 -- OUT
313 --
314 -- Version: Current version 1.0
315 --
316 -- End of Comments
317 -- ============================================================================
318 PROCEDURE Copy_Rev_UDA
319 (
320 p_organization_id IN NUMBER
321 , p_inventory_item_id IN NUMBER
322 , p_revision_id IN NUMBER
323 , p_revision IN VARCHAR2
324 , p_source_revision_id IN NUMBER DEFAULT NULL
325 );
326
327
328 END INV_ITEM_REVISION_PUB;