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.EAM_ASSETNUMBER_PUB

Source


1 PACKAGE EAM_AssetNumber_Pub AS
2 /* $Header: EAMPASNS.pls 120.3 2006/09/15 12:32:24 sshahid noship $ */
3 /*#
4  * This package is used for the INSERT / UPDATE of asset numbers.
5  * It defines 2 key procedures Insert_Asset_Number, Update_Asset_Number
6  * which first validates and massages the IN parameters
7 
8  * and then carries out the respective operations.
9  * @rep:scope public
10  * @rep:product EAM
11  * @rep:lifecycle active
12  * @rep:displayname Asset Number
13  * @rep:category BUSINESS_ENTITY EAM_ASSET_NUMBER
14  */
15 
16 
17 -- Start of comments
18 --	API name 	: Insert_Asset_Number
19 --	Type		: Public
20 --	Function	:
21 --	Pre-reqs	: None.
22 --	Parameters	:
23 --	IN		:	p_api_version           	IN NUMBER	Required
24 --				p_init_msg_list		IN VARCHAR2 	Optional
25 --					Default = FND_API.G_FALSE
26 --				p_commit	    		IN VARCHAR2	Optional
27 --					Default = FND_API.G_FALSE
28 --				p_validation_level		IN NUMBER	Optional
29 --					Default = FND_API.G_VALID_LEVEL_FULL
30 --				parameter1
31 --				parameter2
32 --				.
33 --				.
34 --	OUT		:	x_return_status		OUT	VARCHAR2(1)
35 --				x_msg_count			OUT	NUMBER
36 --				x_msg_data			OUT	VARCHAR2(2000)
37 --				parameter1
38 --				parameter2
39 --				.
40 --				.
41 --	Version	: Current version	x.x
42 --				Changed....
43 --			  previous version	y.y
44 --				Changed....
45 --			  .
46 --			  .
47 --			  previous version	2.0
48 --				Changed....
49 --			  Initial version 	1.0
50 --
51 --	Notes		: Note text
52 --
53 -- End of comments
54 
55 /*#
56  * This procedure is used to insert records in CSI_ITEM_INSTANCES.
57  * It is used to create Asset Numbers. This procedure also takes care of instantiation
58  * of the records at the time of insert if the p_instantiate_flag parameter is passed
59  * as true.
60  * @param p_api_version  Version of the API
61  * @param p_init_msg_list Flag to indicate initialization of message list
62  * @param p_commit Flag to indicate whether API should commit changes
63  * @param p_validation_level Validation Level of the API
64  * @param x_return_status Return status of the procedure call
65  * @param x_msg_count Count of the return messages that API returns
66  * @param x_msg_data The collection of the messages.
67  * @param x_object_id The new object id, primary key of new record.
68  * @param p_inventory_item_id Asset Group Identifier
69  * @param p_serial_number Asset Serial Number
70  * @param p_instance_number Asset Number
71  * @param p_current_status Current Status. 1: Defined but not used. 3: Resides in stores. 4: Issued out of stores. 5: Resides in intransit.
72  * @param p_descriptive_text Asset descriptive text
73  * @param p_current_organization_id Organization where the serial number is currently stored
74  * @param p_attribute_category Descriptive flexfield structure defining column
75  * @param p_attribute1 Descriptive flexfield segment
76  * @param p_attribute2 Descriptive flexfield segment
77  * @param p_attribute3 Descriptive flexfield segment
78  * @param p_attribute4 Descriptive flexfield segment
79  * @param p_attribute5 Descriptive flexfield segment
80  * @param p_attribute6 Descriptive flexfield segment
81  * @param p_attribute7 Descriptive flexfield segment
82  * @param p_attribute8 Descriptive flexfield segment
83  * @param p_attribute9 Descriptive flexfield segment
84  * @param p_attribute10 Descriptive flexfield segment
85  * @param p_attribute11 Descriptive flexfield segment
86  * @param p_attribute12 Descriptive flexfield segment
87  * @param p_attribute13 Descriptive flexfield segment
88  * @param p_attribute14 Descriptive flexfield segment
89  * @param p_attribute15 Descriptive flexfield segment
90  * @param p_wip_accounting_class_code WIP Accounting class code
91  * @param p_maintainable_flag Flag indicating whether the asset is maintainable
92  * @param p_owning_department_id Owning Department Identifier
93  * @param p_network_asset_flag Route Asset Flag
94  * @param p_fa_asset_id Fixed Asset Identifier
95  * @param p_pn_location_id Property Manager Location Identifier
96  * @param p_eam_location_id Area Identifier
97  * @param p_asset_criticality_code Asset criticality code
98  * @param p_category_id Category Identifier
99  * @param p_prod_organization_id Production Organization Identifier
100  * @param p_equipment_item_id Equipment Item Identifier
101  * @param p_eqp_serial_number Equipment serial number
102  * @param p_instantiate_flag Flag to indicate if asset number instantiation setups are complete. Setup includes creation of pm definition, meter, meter association, activity association for asset number being created.
103  * @param P_EAM_LINEAR_ID Linear Location Id
104  * @return Returns the status of the procedure call as well as the return messages
105  * @rep:scope public
106  * @rep:displayname Insert Asset Number
107  */
108 
109 PROCEDURE Insert_Asset_Number
110 ( 	p_api_version           IN	NUMBER				,
111   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE	,
112 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE	,
113 	p_validation_level	IN  	NUMBER	:=
114 						FND_API.G_VALID_LEVEL_FULL	,
115 	x_return_status		OUT 	NOCOPY	VARCHAR2		  	,
116 	x_msg_count		OUT	NOCOPY	NUMBER				,
117 	x_msg_data		OUT	NOCOPY	VARCHAR2			,
118 	x_object_id		OUT	NOCOPY 	NUMBER,
119 	p_INVENTORY_ITEM_ID	IN 	NUMBER,
120 	p_SERIAL_NUMBER		IN	VARCHAR2,
121 	p_INSTANCE_NUMBER	IN 	VARCHAR2 DEFAULT NULL,
122 	--p_INITIALIZATION_DATE	IN	DATE:=NULL,  -- always use sysdate
123 	p_CURRENT_STATUS	IN 	NUMBER:=3,
124 	p_DESCRIPTIVE_TEXT		IN	VARCHAR2:=NULL,
125 	p_CURRENT_ORGANIZATION_ID 	IN 	NUMBER,
126 	p_ATTRIBUTE_CATEGORY	IN	VARCHAR2:=NULL,
127 	p_ATTRIBUTE1		IN	VARCHAR2:=NULL,
128 	p_ATTRIBUTE2		IN	VARCHAR2:=NULL,
129 	p_ATTRIBUTE3		IN	VARCHAR2:=NULL,
130 	p_ATTRIBUTE4		IN	VARCHAR2:=NULL,
131 	p_ATTRIBUTE5		IN	VARCHAR2:=NULL,
132 	p_ATTRIBUTE6		IN	VARCHAR2:=NULL,
133 	p_ATTRIBUTE7		IN	VARCHAR2:=NULL,
134 	p_ATTRIBUTE8		IN	VARCHAR2:=NULL,
135 	p_ATTRIBUTE9		IN	VARCHAR2:=NULL,
136 	p_ATTRIBUTE10		IN	VARCHAR2:=NULL,
137 	p_ATTRIBUTE11		IN	VARCHAR2:=NULL,
138 	p_ATTRIBUTE12		IN	VARCHAR2:=NULL,
139 	p_ATTRIBUTE13		IN	VARCHAR2:=NULL,
140 	p_ATTRIBUTE14		IN	VARCHAR2:=NULL,
141 	p_ATTRIBUTE15		IN	VARCHAR2:=NULL,
142 	P_ATTRIBUTE16                   VARCHAR2 DEFAULT NULL,
143 	P_ATTRIBUTE17                   VARCHAR2 DEFAULT NULL,
144 	P_ATTRIBUTE18                   VARCHAR2 DEFAULT NULL,
145 	P_ATTRIBUTE19                   VARCHAR2 DEFAULT NULL,
146 	P_ATTRIBUTE20                   VARCHAR2 DEFAULT NULL,
147 	P_ATTRIBUTE21                   VARCHAR2 DEFAULT NULL,
148 	P_ATTRIBUTE22                   VARCHAR2 DEFAULT NULL,
149 	P_ATTRIBUTE23                   VARCHAR2 DEFAULT NULL,
150 	P_ATTRIBUTE24                   VARCHAR2 DEFAULT NULL,
151 	P_ATTRIBUTE25                   VARCHAR2 DEFAULT NULL,
152 	P_ATTRIBUTE26                   VARCHAR2 DEFAULT NULL,
153 	P_ATTRIBUTE27                   VARCHAR2 DEFAULT NULL,
154 	P_ATTRIBUTE28                   VARCHAR2 DEFAULT NULL,
155 	P_ATTRIBUTE29                   VARCHAR2 DEFAULT NULL,
156         P_ATTRIBUTE30                   VARCHAR2 DEFAULT NULL,
157 --	p_STATUS_ID		IN 	NUMBER:=1,
158 --	p_PREVIOUS_STATUS		IN 	NUMBER:=NULL,
159 	p_WIP_ACCOUNTING_CLASS_CODE	IN	VARCHAR2:=NULL,
160 	p_MAINTAINABLE_FLAG		IN	VARCHAR2:=NULL,
161 	p_OWNING_DEPARTMENT_ID		IN 	NUMBER,
162 	p_NETWORK_ASSET_FLAG		IN	VARCHAR2:=NULL,
163 	p_FA_ASSET_ID			IN 	NUMBER:=NULL,
164 	p_PN_LOCATION_ID		IN 	NUMBER:=NULL,
165 	p_EAM_LOCATION_ID		IN 	NUMBER:=NULL,
166 	p_ASSET_CRITICALITY_CODE	IN	VARCHAR2:=NULL,
167 	p_CATEGORY_ID			IN 	NUMBER:=NULL,
168 	p_PROD_ORGANIZATION_ID 		IN 	NUMBER:=NULL,
169 	p_EQUIPMENT_ITEM_ID		IN 	NUMBER:=NULL,
170 	p_EQP_SERIAL_NUMBER		IN	VARCHAR2:=NULL,
171 	p_EQUIPMENT_GEN_OBJECT_ID	IN 	NUMBER := NULL,
172 	p_instantiate_flag		IN 	BOOLEAN:=FALSE,
173 	p_eam_linear_id			IN	NUMBER:=NULL
174 	,p_active_start_date	        DATE := NULL
175 	,p_active_end_date	        DATE := NULL
176 	,p_location		        NUMBER := NULL
177 	,p_operational_log_flag	  	VARCHAR2 := NULL
178 	,p_checkin_status		NUMBER := NULL
179 	,p_supplier_warranty_exp_date   DATE := NULL
180 );
181 
182 -- Start of comments
183 --	API name 	: Update_Asset_Number
184 --	Type		: Public
185 --	Function	:
186 --	Pre-reqs	: None.
187 --	Parameters	:
188 --	IN		:	p_api_version           	IN NUMBER	Required
189 --				p_init_msg_list		IN VARCHAR2 	Optional
190 --					Default = FND_API.G_FALSE
191 --				p_commit	    		IN VARCHAR2	Optional
192 --					Default = FND_API.G_FALSE
193 --				p_validation_level		IN NUMBER	Optional
194 --					Default = FND_API.G_VALID_LEVEL_FULL
195 --				parameter1
196 --				parameter2
197 --				.
198 --				.
199 --	OUT		:	x_return_status		OUT	VARCHAR2(1)
200 --				x_msg_count			OUT	NUMBER
201 --				x_msg_data			OUT	VARCHAR2(2000)
202 --				parameter1
203 --				parameter2
204 --				.
205 --				.
206 --	Version	: Current version	x.x
207 --				Changed....
208 --			  previous version	y.y
209 --				Changed....
210 --			  .
211 --			  .
212 --			  previous version	2.0
213 --				Changed....
214 --			  Initial version 	1.0
215 --
216 --	Notes		: Note text
217 --
218 -- End of comments
219 
220 /*#
221  * This procedure is used to update the existing records in MTL_SERIAL_NUMBERS.
222  * It is used to update Asset Numbers.
223  * @param p_api_version  Version of the API
224  * @param p_init_msg_list Flag to indicate initialization of message list
225  * @param p_commit Flag to indicate whether API should commit changes
226  * @param p_validation_level Validation Level of the API
227  * @param x_return_status Return status of the procedure call
228  * @param x_msg_count Count of the return messages that API returns
229  * @param x_msg_data The collection of the messages.
230  * @param p_inventory_item_id Asset Group Identifier
231  * @param p_serial_number Asset Number
232  * @param p_current_status Current Status. 1: Defined but not used. 3: Resides in stores. 4: Issued out of stores. 5: Resides in intransit.
233  * @param p_descriptive_text Unit descriptive text
234  * @param p_current_organization_id Organization where the serial number is currently stored
235  * @param p_attribute_category Descriptive flexfield structure defining column
236  * @param p_attribute1 Descriptive flexfield segment
237  * @param p_attribute2 Descriptive flexfield segment
238  * @param p_attribute3 Descriptive flexfield segment
239  * @param p_attribute4 Descriptive flexfield segment
240  * @param p_attribute5 Descriptive flexfield segment
241  * @param p_attribute6 Descriptive flexfield segment
242  * @param p_attribute7 Descriptive flexfield segment
243  * @param p_attribute8 Descriptive flexfield segment
244  * @param p_attribute9 Descriptive flexfield segment
245  * @param p_attribute10 Descriptive flexfield segment
246  * @param p_attribute11 Descriptive flexfield segment
247  * @param p_attribute12 Descriptive flexfield segment
248  * @param p_attribute13 Descriptive flexfield segment
249  * @param p_attribute14 Descriptive flexfield segment
250  * @param p_attribute15 Descriptive flexfield segment
251  * @param p_wip_accounting_class_code WIP Accounting class code
252  * @param p_maintainable_flag Flag indicating whether the asset is maintainable
253  * @param p_owning_department_id Owning Department Identifier
254  * @param p_network_asset_flag Route Asset Flag
255  * @param p_fa_asset_id Fixed Asset Identifier
256  * @param p_pn_location_id Property Manager Location Identifier
257  * @param p_eam_location_id Area Identifier
258  * @param p_asset_criticality_code Asset criticality code
259  * @param p_category_id Category Identifier
260  * @param p_prod_organization_id Production Organization Identifier
261  * @param p_equipment_item_id Equipment Item Identifier
262  * @param p_eqp_serial_number Equipment serial number
263  * @param P_EAM_LINEAR_ID Linear Location Id
264  * @return Returns the status of the procedure call as well as the return messages
265  * @rep:scope public
266  * @rep:displayname Update Asset Number
267  */
268 
269 PROCEDURE Update_Asset_Number
270 ( 	p_api_version           IN	NUMBER				,
271   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE	,
272 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE	,
273 	p_validation_level	IN  	NUMBER	:=
274 						FND_API.G_VALID_LEVEL_FULL	,
275 	x_return_status		OUT	NOCOPY	VARCHAR2		  	,
276 	x_msg_count		OUT	NOCOPY	NUMBER				,
277 	x_msg_data		OUT	NOCOPY	VARCHAR2			,
278 	--p_GEN_OBJECT_ID		IN  	NUMBER:=NULL,
279 	p_INVENTORY_ITEM_ID	IN 	NUMBER,
280 	p_SERIAL_NUMBER		IN	VARCHAR2,
281 	p_INSTANCE_NUMBER	IN 	VARCHAR2:= NULL,
282 	P_INSTANCE_ID		IN 	NUMBER:=NULL,
283 	--p_INITIALIZATION_DATE	IN	DATE:=NULL,
284 	p_CURRENT_STATUS	IN 	NUMBER:=3,
285 	p_DESCRIPTIVE_TEXT	IN	VARCHAR2:=NULL,
286 	p_CURRENT_ORGANIZATION_ID IN 	NUMBER,
287 	p_ATTRIBUTE_CATEGORY	IN	VARCHAR2:=NULL,
288 	p_ATTRIBUTE1		IN	VARCHAR2:=NULL,
289 	p_ATTRIBUTE2		IN	VARCHAR2:=NULL,
290 	p_ATTRIBUTE3		IN	VARCHAR2:=NULL,
291 	p_ATTRIBUTE4		IN	VARCHAR2:=NULL,
292 	p_ATTRIBUTE5		IN	VARCHAR2:=NULL,
293 	p_ATTRIBUTE6		IN	VARCHAR2:=NULL,
294 	p_ATTRIBUTE7		IN	VARCHAR2:=NULL,
295 	p_ATTRIBUTE8		IN	VARCHAR2:=NULL,
296 	p_ATTRIBUTE9		IN	VARCHAR2:=NULL,
297 	p_ATTRIBUTE10		IN	VARCHAR2:=NULL,
298 	p_ATTRIBUTE11		IN	VARCHAR2:=NULL,
299 	p_ATTRIBUTE12		IN	VARCHAR2:=NULL,
300 	p_ATTRIBUTE13		IN	VARCHAR2:=NULL,
301 	p_ATTRIBUTE14		IN	VARCHAR2:=NULL,
302 	p_ATTRIBUTE15		IN	VARCHAR2:=NULL,
303 	P_ATTRIBUTE16                   VARCHAR2 DEFAULT NULL,
304 	P_ATTRIBUTE17                   VARCHAR2 DEFAULT NULL,
305 	P_ATTRIBUTE18                   VARCHAR2 DEFAULT NULL,
306 	P_ATTRIBUTE19                   VARCHAR2 DEFAULT NULL,
307 	P_ATTRIBUTE20                   VARCHAR2 DEFAULT NULL,
308 	P_ATTRIBUTE21                   VARCHAR2 DEFAULT NULL,
309 	P_ATTRIBUTE22                   VARCHAR2 DEFAULT NULL,
310 	P_ATTRIBUTE23                   VARCHAR2 DEFAULT NULL,
311 	P_ATTRIBUTE24                   VARCHAR2 DEFAULT NULL,
312 	P_ATTRIBUTE25                   VARCHAR2 DEFAULT NULL,
313 	P_ATTRIBUTE26                   VARCHAR2 DEFAULT NULL,
314 	P_ATTRIBUTE27                   VARCHAR2 DEFAULT NULL,
315 	P_ATTRIBUTE28                   VARCHAR2 DEFAULT NULL,
316 	P_ATTRIBUTE29                   VARCHAR2 DEFAULT NULL,
317         P_ATTRIBUTE30                   VARCHAR2 DEFAULT NULL,
318 	--p_STATUS_ID		IN 	NUMBER:=1,
319 	--p_PREVIOUS_STATUS		IN 	NUMBER:=NULL,
320 	p_WIP_ACCOUNTING_CLASS_CODE	IN	VARCHAR2:=NULL,
321 	p_MAINTAINABLE_FLAG		IN	VARCHAR2:=NULL,
322 	p_OWNING_DEPARTMENT_ID		IN 	NUMBER,
323 	p_NETWORK_ASSET_FLAG		IN	VARCHAR2:=NULL,
324 	p_FA_ASSET_ID			IN 	NUMBER:=NULL,
325 	p_PN_LOCATION_ID		IN 	NUMBER:=NULL,
326 	p_EAM_LOCATION_ID		IN 	NUMBER:=NULL,
327 	p_ASSET_CRITICALITY_CODE	IN	VARCHAR2:=NULL,
328 	p_CATEGORY_ID			IN 	NUMBER:=NULL,
329 	p_PROD_ORGANIZATION_ID 		IN 	NUMBER:=NULL,
330 	p_EQUIPMENT_ITEM_ID		IN 	NUMBER:=NULL,
331 	p_EQP_SERIAL_NUMBER		IN	VARCHAR2:=NULL,
332 	p_EAM_LINEAR_ID			IN	NUMBER:=NULL
333 	,P_LOCATION_TYPE_CODE		IN	VARCHAR2:=NULL
334 	,P_LOCATION_ID			IN	NUMBER:=NULL
335 	,P_ACTIVE_END_DATE		IN 	DATE:=NULL
336 	,P_OPERATIONAL_LOG_FLAG	  	IN	VARCHAR2:=NULL
337 	,P_CHECKIN_STATUS		IN 	NUMBER:=NULL
338 	,P_SUPPLIER_WARRANTY_EXP_DATE	IN	DATE:=NULL
339 	,P_EQUIPMENT_GEN_OBJECT_ID	IN	NUMBER:=NULL
340 	,P_DISASSOCIATE_FA_FLAG		IN      VARCHAR2:='N'
341 
342 );
343 
344 function validate_fields
345 (
346 	p_CURRENT_ORGANIZATION_ID	IN	number,
347 	p_INVENTORY_ITEM_ID		IN	number,
348 	p_SERIAL_NUMBER			IN	varchar2,
349         p_WIP_ACCOUNTING_CLASS_CODE     IN      VARCHAR2:=NULL,
350         p_MAINTAINABLE_FLAG             IN      VARCHAR2:=NULL,
351         p_OWNING_DEPARTMENT_ID          IN      NUMBER,
352         p_NETWORK_ASSET_FLAG            IN      VARCHAR2:=NULL,
353         p_FA_ASSET_ID                   IN      NUMBER:=NULL,
354         p_PN_LOCATION_ID                IN      NUMBER:=NULL,
355         p_EAM_LOCATION_ID               IN      NUMBER:=NULL,
356         p_ASSET_CRITICALITY_CODE        IN      VARCHAR2:=NULL,
357         p_CATEGORY_ID                   IN      NUMBER:=NULL,
358         p_PROD_ORGANIZATION_ID          IN      NUMBER:=NULL,
359         p_EQUIPMENT_ITEM_ID             IN      NUMBER:=NULL,
360         p_EQP_SERIAL_NUMBER             IN      VARCHAR2:=NULL,
361         p_ATTRIBUTE_CATEGORY    IN      VARCHAR2:=NULL,
362         p_ATTRIBUTE1            IN      VARCHAR2:=NULL,
363         p_ATTRIBUTE2            IN      VARCHAR2:=NULL,
364         p_ATTRIBUTE3            IN      VARCHAR2:=NULL,
365         p_ATTRIBUTE4            IN      VARCHAR2:=NULL,
366         p_ATTRIBUTE5            IN      VARCHAR2:=NULL,
367         p_ATTRIBUTE6            IN      VARCHAR2:=NULL,
368         p_ATTRIBUTE7            IN      VARCHAR2:=NULL,
369         p_ATTRIBUTE8            IN      VARCHAR2:=NULL,
370         p_ATTRIBUTE9            IN      VARCHAR2:=NULL,
371         p_ATTRIBUTE10           IN      VARCHAR2:=NULL,
372         p_ATTRIBUTE11           IN      VARCHAR2:=NULL,
373         p_ATTRIBUTE12           IN      VARCHAR2:=NULL,
374         p_ATTRIBUTE13           IN      VARCHAR2:=NULL,
375         p_ATTRIBUTE14           IN      VARCHAR2:=NULL,
376         p_ATTRIBUTE15           IN      VARCHAR2:=NULL,
377 	p_EAM_LINEAR_ID		IN	NUMBER:= NULL,
378         p_equipment_object_id	IN	NUMBER := NULL,
379 	p_operational_log_flag	IN      VARCHAR2 := NULL,
380 	p_checkin_status	IN      NUMBER := NULL,
381   	p_supplier_warranty_exp_date IN     DATE := NULL,
382   	x_reason_failed         OUT     NOCOPY VARCHAR2,
383         x_token                 OUT     NOCOPY VARCHAR2
384 )
385 return boolean;
386 
387 procedure add_error (p_error_code IN varchar2);
388 
389 END eam_assetnumber_pub;