[Home] [Help]
PACKAGE: APPS.AMS_ITEM_OWNER_PVT
Source
1 PACKAGE AMS_ITEM_OWNER_PVT as
2 /* $Header: amsvinvs.pls 120.1 2006/05/03 05:38:49 inanaiah noship $ */
3 -- Start of Comments
4 -- Package name : AMS_ITEM_OWNER_PVT
5 -- Purpose :
6
7 -- History :
8 -- 09/20/2000 abhola created.
9 -- 12/05/2000 musman added two more record type for the
10 -- wrapper of INV_Item_GRP pkg record types.
11 -- 01/21/2002 musman Added three more attributes unit_weight,weight_uom_code and event_flag
12 -- 03/22/2002 musman Added one more flag comms_nl_trackable_flag
13 -- 04/26/2002 musman Added 6 more attributes
14 -- 12/17/2002 musman Added one more flag so_transactions_flag
15 -- 05/03/2006 inanaiah Bug 5191150 fix - Changed MESSAGE_TEXT from VARCHAR2(240) to VARCHAR2(2000)
16
17 -- NOTE :
18 -- End of Comments
19
20 -- Default number of records fetch per call
21 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
22 -- *******************************************************
23 -- Start of Comments
24 -- -------------------------------------------------------
25 -- Record name:ITEM_OWNER_Rec_Type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- ITEM_OWNER_ID
29 -- OBJECT_VERSION_NUMBER
30 -- INVENTORY_ITEM_ID
31 -- ORGANIZATION_ID
32 -- ITEM_NUMBER
33 -- OWNER_ID
34 -- STATUS_CODE
35 -- EFFECTIVE_DATE
36 --
37 -- Required:
38 -- Defaults:
39 -- Note: This is automatic generated record definition, it includes all columns
40 -- defined in the table, developer must manually add or delete some of the attributes.
41 --
42 -- End of Comments
43
44 TYPE ITEM_OWNER_Rec_Type IS RECORD
45 (
46 ITEM_OWNER_ID NUMBER := FND_API.G_MISS_NUM,
47 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
48 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50 ITEM_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
51 OWNER_ID NUMBER := FND_API.G_MISS_NUM,
52 STATUS_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
53 EFFECTIVE_DATE DATE := FND_API.G_MISS_DATE,
54 IS_MASTER_ITEM VARCHAR2(20) := FND_API.G_MISS_CHAR,
55 ITEM_SETUP_TYPE VARCHAR2(1) := FND_API.G_MISS_CHAR,
56 CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
57 );
58
59 G_MISS_ITEM_OWNER_REC ITEM_OWNER_Rec_Type;
60 TYPE ITEM_OWNER_Tbl_Type IS TABLE OF ITEM_OWNER_Rec_Type
61 INDEX BY BINARY_INTEGER;
62 G_MISS_ITEM_OWNER_TBL ITEM_OWNER_Tbl_Type;
63
64
65 -- *******************************************************
66 -- Start of Comments
67 -- -------------------------------------------------------
68 -- Record name:ITEM_Rec_Type
69 -- -------------------------------------------------------
70 -- Description: This record type is to wrap the INV_Item_GRP.Item_rec_type
71 --
72 -- Required:
73 -- Defaults:
74 -- Note: This is automatic generated record definition, it includes all columns
75 -- defined in the table, developer must manually add or delete some of the attributes.
76 --
77 -- End of Comments
78
79
80 TYPE ITEM_rec_type is RECORD (
81
82 inventory_item_id NUMBER := FND_API.G_MISS_NUM,
83 organization_id NUMBER := FND_API.G_MISS_NUM,
84 item_number VARCHAR2(2000) := FND_API.g_MISS_CHAR,
85 description VARCHAR2(240):= FND_API.G_MISS_CHAR,
86 long_description VARCHAR2(4000):=FND_API.G_MISS_CHAR,
87
88 item_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
89
90 primary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
91 primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR,
92
93 start_date_active DATE := FND_API.g_MISS_DATE,
94 end_date_active DATE := FND_API.g_MISS_DATE ,
95
96 inventory_item_status_codE VARCHAR2(10) := FND_API.g_MISS_CHAR,
97
98 inventory_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
99 stock_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
100 mtl_transactions_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
101 revision_qty_control_code NUMBER := FND_API.g_MISS_NUM,
102
103 bom_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104 bom_item_type NUMBER := FND_API.G_MISS_NUM,
105
106 costing_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
107
108 electronic_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
109 downloadable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
110
111 customer_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
112 customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
113
114 internal_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
115 internal_order_enabled_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
116
117 shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
118 returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
119 comms_activation_reqd_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
120 replenish_to_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
121 invoiceable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
122 invoice_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123
124 service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
125 serviceable_product_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
126 vendor_warranty_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
127 coverage_schedule_id NUMBER := FND_API.g_MISS_NUM,
128 service_duration NUMBER := FND_API.g_MISS_NUM,
129 service_duration_period_code VARCHAR2(10) := FND_API.g_MISS_CHAR,
130 defect_tracking_on_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
131
132 orderable_on_web_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
133 back_orderable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
134 collateral_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
135 weight_uom_code VARCHAR2(3) := FND_API.g_MISS_CHAR,
136 unit_weight NUMBER := FND_API.g_MISS_NUM,
137 event_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
138 comms_nl_trackable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
139
140 subscription_depend_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
141 contract_item_type_code VARCHAR2(30) := FND_API.g_MISS_CHAR,
142 web_status VARCHAR2(30) := FND_API.g_MISS_CHAR,
143 indivisible_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
144 material_billable_flag VARCHAR2(30) := FND_API.g_MISS_CHAR,
145 pick_components_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
146 ,so_transactions_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
147
148 ,attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
149 ,attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
150 ,attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
151 ,attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
152 ,attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
153 ,attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
154 ,attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
155 ,attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
156 ,attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
157 ,attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
158 ,attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
159 ,attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
160 ,attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
161 ,attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
162 ,attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
163 ,attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
164
165
166 );
167
168 G_MISS_ITEM_REC ITEM_rec_type;
169
170 -- *******************************************************
171 -- Start of Comments
172 -- -------------------------------------------------------
173 -- Record name: Error_Rec_Type
174 -- -------------------------------------------------------
175 -- Parameters:
176 -- TRANSACTION_ID
177 -- UNIQUE_ID
178 -- MESSAGE_NAME
179 -- MESSAGE_TEXT
180 -- TABLE_NAME
181 -- COLUMN_NAME
182 -- ORGANIZATION_ID
183 --
184 -- Required:
185 -- Defaults:
186 -- Note: This is automatic generated record definition, it includes all columns
187 -- defined in the table, developer must manually add or delete some of the attributes.
188 --
189 -- End of Comments
190
191 TYPE Error_rec_type IS RECORD(
192 TRANSACTION_ID NUMBER,
193 UNIQUE_ID NUMBER,
194 MESSAGE_NAME VARCHAR2(30),
195 MESSAGE_TEXT VARCHAR2(2000),
196 TABLE_NAME VARCHAR2(30),
197 COLUMN_NAME VARCHAR2(32),
198 ORGANIZATION_ID NUMBER
199 );
200
201 TYPE Error_tbl_type IS TABLE OF Error_rec_type
202 INDEX BY BINARY_INTEGER;
203
204
205
206 -- *******************************************************
207 -- Start of Comments
208 -- *******************************************************
209 -- API Name: Create_item_owner
210 -- Type : Private
211 -- Pre-Req :
212 -- Parameters:
213 -- IN
214 -- p_api_version_number IN NUMBER Required
215 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
218 -- P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type Required
219 --
220 -- OUT:
221 -- x_return_status OUT VARCHAR2
222 -- x_msg_count OUT NUMBER
223 -- x_msg_data OUT VARCHAR2
224 -- Version : Current version 1.0
225 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
226 -- and basic operation, developer must manually add parameters and business logic as necessary.
227 --
228 -- End of Comments
229 --
230 PROCEDURE Create_item_owner(
231 P_Api_Version_Number IN NUMBER,
232 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
233 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
234 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235
236 X_Return_Status OUT NOCOPY VARCHAR2,
237 X_Msg_Count OUT NOCOPY NUMBER,
238 X_Msg_Data OUT NOCOPY VARCHAR2,
239
240 P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type := G_MISS_ITEM_OWNER_REC,
241 X_ITEM_OWNER_ID OUT NOCOPY NUMBER ,
242
243 P_ITEM_REC_In IN ITEM_rec_type := G_MISS_ITEM_REC, /*INV_Item_GRP.Item_rec_type := INV_Item_GRP.g_miss_Item_rec,*/
244 P_ITEM_REC_Out OUT NOCOPY ITEM_rec_type, /*INV_Item_GRP.Item_rec_type,*/
245 x_item_return_status OUT NOCOPY VARCHAR2,
246 x_error_tbl OUT NOCOPY Error_tbl_type /*INV_Item_GRP.Error_tbl_type*/
247 );
248
249 -- *******************************************************
250 -- Start of Comments
251 -- *******************************************************
252 -- API Name: Update_item_owner
253 -- Type : Private
254 -- Pre-Req :
255 -- Parameters:
256 -- IN
257 -- p_api_version_number IN NUMBER Required
258 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
259 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
260 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
261 -- P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type Required
262 --
263 -- OUT:
264 -- x_return_status OUT VARCHAR2
265 -- x_msg_count OUT NUMBER
266 -- x_msg_data OUT VARCHAR2
267 -- Version : Current version 1.0
268 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
269 -- and basic operation, developer must manually add parameters and business logic as necessary.
270 --
271 -- End of Comments
272 --
273 PROCEDURE Update_item_owner(
274 P_Api_Version_Number IN NUMBER,
275 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
276 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
277 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278
279 X_Return_Status OUT NOCOPY VARCHAR2,
280 X_Msg_Count OUT NOCOPY NUMBER,
281 X_Msg_Data OUT NOCOPY VARCHAR2,
282
283 P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type,
284 X_Object_Version_Number OUT NOCOPY NUMBER,
285
286 P_ITEM_REC_In IN ITEM_rec_type := G_MISS_ITEM_REC, /*INV_Item_GRP.Item_rec_type := INV_Item_GRP.g_miss_Item_rec,*/
287 P_ITEM_REC_Out OUT NOCOPY ITEM_rec_type ,/*INV_Item_GRP.Item_rec_type,*/
288 x_item_return_status OUT NOCOPY VARCHAR2,
289 x_Error_tbl OUT NOCOPY Error_tbl_type/*INV_Item_GRP.Error_tbl_type*/
290 );
291
292 -- *******************************************************
293 -- Start of Comments
294 -- *******************************************************
295 -- API Name: Delete_item_owner
296 -- Type : Private
297 -- Pre-Req :
298 -- Parameters:
299 -- IN
300 -- p_api_version_number IN NUMBER Required
301 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
302 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
306 --
303 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
304 -- p_ITEM_OWNER_ID IN NUMBER
305 -- p_object_version_number IN NUMBER Optional Default = NULL
307 -- OUT:
308 -- x_return_status OUT VARCHAR2
309 -- x_msg_count OUT NUMBER
310 -- x_msg_data OUT VARCHAR2
311 -- Version : Current version 1.0
312 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
313 -- and basic operation, developer must manually add parameters and business logic as necessary.
314 --
315 -- End of Comments
316 --
317 PROCEDURE Delete_item_owner(
318 P_Api_Version_Number IN NUMBER,
319 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
320 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
321 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
322 X_Return_Status OUT NOCOPY VARCHAR2,
323 X_Msg_Count OUT NOCOPY NUMBER,
324 X_Msg_Data OUT NOCOPY VARCHAR2,
325 P_ITEM_OWNER_ID IN NUMBER,
326 P_Object_Version_Number IN NUMBER
327 );
328
329
330 -- Start of Comments
331 --
332 -- Record level validation procedures
333 --
334 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
335 -- For create: G_CREATE, for update: G_UPDATE
336 -- Note: 1. This is automated generated item level validation procedure.
337 -- The actual validation detail is needed to be added.
338 -- 2. Developer can manually added inter-field level validation.
339 -- End of Comments
340
341 /*PROCEDURE Validate_ITEM_OWNER_rec(
342 P_Api_Version_Number IN NUMBER,
343 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
344 X_Return_Status OUT NOCOPY VARCHAR2,
345 X_Msg_Count OUT NOCOPY NUMBER,
346 X_Msg_Data OUT NOCOPY VARCHAR2,
347 P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type
348 );
349 */
350 -- Start of Comments
351 --
352 -- validation procedures
353 --
354 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
355 -- For create: G_CREATE, for update: G_UPDATE
356 -- Note: 1. This is automated generated item level validation procedure.
357 -- The actual validation detail is needed to be added.
358 -- 2. We can also validate table instead of record. There will be an option for user to choose.
359 -- End of Comments
360
361 PROCEDURE Validate_item_owner(
362 P_Api_Version_Number IN NUMBER,
363 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
364 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
365 P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type,
366 P_ITEM_REC_In IN ITEM_rec_type := G_MISS_ITEM_REC,
367 X_Return_Status OUT NOCOPY VARCHAR2,
368 X_Msg_Count OUT NOCOPY NUMBER,
369 X_Msg_Data OUT NOCOPY VARCHAR2
370 );
371 End AMS_ITEM_OWNER_PVT;