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_ASSETATTR_VALUE_PUB

Source


1 PACKAGE EAM_ASSETATTR_VALUE_PUB AS
2 /* $Header: EAMPAAVS.pls 120.0 2005/05/25 15:39:13 appldev noship $ */
3 /*#
4  * This package is used for the INSERT / UPDATE /Validation of asset attribute values.
5  * It defines 2 key procedures insert_assetattr_value and update_assetattr_value
6  * which first validates and massages the IN parameters and then carries out
7  * the respective operations.
8  * @rep:scope public
9  * @rep:product EAM
10  * @rep:lifecycle active
11  * @rep:displayname Asset Attributes Values
12  * @rep:category BUSINESS_ENTITY EAM_ASSET_ATTRIBUTE_VALUE
13  */
14 
15 -- Start of comments
16 --	API name 	: EAM_ASSETATTR_VALUE_PUB
17 --	Type		: Public
18 --	Function	: insert_dept_appr, update_dept_appr
19 --	Pre-reqs	: None.
20 --	Parameters	:
21 --	IN		:	p_api_version           IN NUMBER	Required
22 --				p_init_msg_list		IN VARCHAR2 	Optional
23 --					Default = FND_API.G_FALSE
24 --				p_commit	    	IN VARCHAR2	Optional
25 --					Default = FND_API.G_FALSE
26 --				p_validation_level	IN NUMBER	Optional
27 --					Default = FND_API.G_VALID_LEVEL_FULL
28 --				parameter1
29 --				parameter2
30 --				.
31 --				.
32 --	OUT		:	x_return_status		OUT	VARCHAR2(1)
33 --				x_msg_count		OUT	NUMBER
34 --				x_msg_data		OUT	VARCHAR2(2000)
35 --				parameter1
36 --				parameter2
37 --				.
38 --				.
39 --	Version	: Current version	x.x
40 --				Changed....
41 --			  previous version	y.y
42 --				Changed....
43 --			  .
44 --			  .
45 --			  previous version	2.0
46 --				Changed....
47 --			  Initial version 	1.0
48 --
49 --	Notes		: Note text
50 --
51 -- End of comments
52 
53       /*#
54 	* This procedure is used to insert records in MTL_EAM_ASSET_ATTR_VALUES.
55 	* It is used to create Asset Attribute Values
56 	* @param p_api_version  Version of the API
57 	* @param p_init_msg_list Flag to indicate initialization of message list
58 	* @param p_commit Flag to indicate whether API should commit changes
59 	* @param p_validation_level Validation Level of the API
60 	* @param x_return_status Return status of the procedure call
61 	* @param x_msg_count Count of the return messages that API returns
62 	* @param x_msg_data The collection of the messages
63 	* @param P_ASSOCIATION_ID Asset Group and Attribute Group association ID. This is the foreign key to MTL_EAM_ASSET_ATTR_GROUPS.ASSOCIATION_ID
64 	* @param P_APPLICATION_ID Application Identifier of the flexfield for the attribute group. From MTL_EAM_ASSET_ATTR_GROUPS.APPLICATION_ID
65 	* @param P_DESCRIPTIVE_FLEXFIELD_NAME Name of flexfield for the attribute group. From MTL_EAM_ASSET_ATTR_GROUPS.DESCRIPTIVE_FLEXFIELD_NAME
66 	* @param P_INVENTORY_ITEM_ID Inventory item identifier of the asset group
67 	* @param P_SERIAL_NUMBER Asset Number
68 	* @param P_ORGANIZATION_ID Organization identifier of the Asset group
69 	* @param P_ATTRIBUTE_CATEGORY Descriptive flexfield structure defining column
70 	* @param P_C_ATTRIBUTE1 Descriptive flexfield column
71 	* @param P_C_ATTRIBUTE2 Descriptive flexfield column
72 	* @param P_C_ATTRIBUTE3 Descriptive flexfield column
73 	* @param P_C_ATTRIBUTE4 Descriptive flexfield column
74 	* @param P_C_ATTRIBUTE5 Descriptive flexfield column
75 	* @param P_C_ATTRIBUTE6 Descriptive flexfield column
76 	* @param P_C_ATTRIBUTE7 Descriptive flexfield column
77 	* @param P_C_ATTRIBUTE8 Descriptive flexfield column
78 	* @param P_C_ATTRIBUTE9 Descriptive flexfield column
79 	* @param P_C_ATTRIBUTE10 Descriptive flexfield column
80 	* @param P_C_ATTRIBUTE11 Descriptive flexfield column
81 	* @param P_C_ATTRIBUTE12 Descriptive flexfield column
82 	* @param P_C_ATTRIBUTE13 Descriptive flexfield column
83 	* @param P_C_ATTRIBUTE14 Descriptive flexfield column
84 	* @param P_C_ATTRIBUTE15 Descriptive flexfield column
85 	* @param P_C_ATTRIBUTE16 Descriptive flexfield column
86 	* @param P_C_ATTRIBUTE17 Descriptive flexfield column
87 	* @param P_C_ATTRIBUTE18 Descriptive flexfield column
88 	* @param P_C_ATTRIBUTE19 Descriptive flexfield column
89 	* @param P_C_ATTRIBUTE20 Descriptive flexfield column
90 	* @param P_D_ATTRIBUTE1 Descriptive flexfield column
91 	* @param P_D_ATTRIBUTE2 Descriptive flexfield column
92 	* @param P_D_ATTRIBUTE3 Descriptive flexfield column
93 	* @param P_D_ATTRIBUTE4 Descriptive flexfield column
94 	* @param P_D_ATTRIBUTE5 Descriptive flexfield column
95 	* @param P_D_ATTRIBUTE6 Descriptive flexfield column
96 	* @param P_D_ATTRIBUTE7 Descriptive flexfield column
97 	* @param P_D_ATTRIBUTE8 Descriptive flexfield column
98 	* @param P_D_ATTRIBUTE9 Descriptive flexfield column
99 	* @param P_D_ATTRIBUTE10 Descriptive flexfield column
100 	* @param P_N_ATTRIBUTE1 Descriptive flexfield column
101 	* @param P_N_ATTRIBUTE2 Descriptive flexfield column
102 	* @param P_N_ATTRIBUTE3 Descriptive flexfield column
103 	* @param P_N_ATTRIBUTE4 Descriptive flexfield column
104 	* @param P_N_ATTRIBUTE5 Descriptive flexfield column
105 	* @param P_N_ATTRIBUTE6 Descriptive flexfield column
106 	* @param P_N_ATTRIBUTE7 Descriptive flexfield column
107 	* @param P_N_ATTRIBUTE8 Descriptive flexfield column
108 	* @param P_N_ATTRIBUTE9 Descriptive flexfield column
109 	* @param P_N_ATTRIBUTE10 Descriptive flexfield column
110 	* @param P_MAINTENANCE_OBJECT_TYPE Object Type
111 	* @param P_MAINTENANCE_OBJECT_ID Object ID
112 	* @param P_CREATION_ORGANIZATION_ID Creation Organization Identifier
113 	* @return Returns the status of the procedure call as well as the return messages
114 	* @rep:scope public
115 	* @rep:displayname Insert Asset Attribute Values
116 	*/
117 
118 procedure insert_assetattr_value
119 (
120 	p_api_version           	IN	NUMBER			,
121   	p_init_msg_list	   	IN	VARCHAR2:= FND_API.G_FALSE	,
122 	p_commit	    	IN  	VARCHAR2:= FND_API.G_FALSE	,
123 	p_validation_level	IN  	NUMBER  := FND_API.G_VALID_LEVEL_FULL,
124 	x_return_status		OUT NOCOPY VARCHAR2	 ,
125 	x_msg_count		OUT NOCOPY NUMBER	 ,
126 	x_msg_data	    	OUT NOCOPY VARCHAR2  ,
127 	P_ASSOCIATION_ID	IN	NUMBER	,
128 	P_APPLICATION_ID	IN	NUMBER	default 401,
129 	P_DESCRIPTIVE_FLEXFIELD_NAME  	IN	VARCHAR2 default 'MTL_EAM_ASSET_ATTR_VALUES'	,
130 	P_INVENTORY_ITEM_ID	IN	NUMBER	default null,
131 	P_SERIAL_NUMBER		IN	VARCHAR2 default null	,
132 	P_ORGANIZATION_ID	IN	NUMBER	,
133 	P_ATTRIBUTE_CATEGORY	IN	VARCHAR2	,
134 	P_C_ATTRIBUTE1		IN	VARCHAR2	default null,
135 	P_C_ATTRIBUTE2		IN	VARCHAR2	default null,
136 	P_C_ATTRIBUTE3		IN	VARCHAR2	default null,
137 	P_C_ATTRIBUTE4		IN	VARCHAR2	default null,
138 	P_C_ATTRIBUTE5		IN	VARCHAR2	default null,
139 	P_C_ATTRIBUTE6		IN	VARCHAR2	default null,
140 	P_C_ATTRIBUTE7		IN	VARCHAR2	default null,
141 	P_C_ATTRIBUTE8		IN	VARCHAR2	default null,
142 	P_C_ATTRIBUTE9		IN	VARCHAR2	default null,
143 	P_C_ATTRIBUTE10		IN	VARCHAR2	default null,
144 	P_C_ATTRIBUTE11		IN	VARCHAR2	default null,
145 	P_C_ATTRIBUTE12		IN	VARCHAR2	default null,
146 	P_C_ATTRIBUTE13		IN	VARCHAR2	default null,
147 	P_C_ATTRIBUTE14		IN	VARCHAR2	default null,
148 	P_C_ATTRIBUTE15		IN	VARCHAR2	default null,
149 	P_C_ATTRIBUTE16		IN	VARCHAR2	default null,
150 	P_C_ATTRIBUTE17		IN	VARCHAR2	default null,
151 	P_C_ATTRIBUTE18		IN	VARCHAR2	default null,
152 	P_C_ATTRIBUTE19		IN	VARCHAR2	default null,
153 	P_C_ATTRIBUTE20		IN	VARCHAR2	default null,
154 	P_D_ATTRIBUTE1		IN	DATE	default null,
155 	P_D_ATTRIBUTE2		IN	DATE	default null,
156 	P_D_ATTRIBUTE3		IN	DATE	default null,
157 	P_D_ATTRIBUTE4		IN	DATE	default null,
158 	P_D_ATTRIBUTE5		IN	DATE	default null,
159 	P_D_ATTRIBUTE6		IN	DATE	default null,
160 	P_D_ATTRIBUTE7		IN	DATE	default null,
161 	P_D_ATTRIBUTE8		IN	DATE	default null,
162 	P_D_ATTRIBUTE9		IN	DATE	default null,
163 	P_D_ATTRIBUTE10		IN	DATE	default null,
164 	P_N_ATTRIBUTE1		IN	NUMBER	default null,
165 	P_N_ATTRIBUTE2		IN	NUMBER	default null,
166 	P_N_ATTRIBUTE3		IN	NUMBER	default null,
167 	P_N_ATTRIBUTE4		IN	NUMBER	default null,
168 	P_N_ATTRIBUTE5		IN	NUMBER	default null,
169 	P_N_ATTRIBUTE6		IN	NUMBER	default null,
170 	P_N_ATTRIBUTE7		IN	NUMBER	default null,
171 	P_N_ATTRIBUTE8		IN	NUMBER	default null,
172 	P_N_ATTRIBUTE9		IN	NUMBER	default null,
173 	P_N_ATTRIBUTE10		IN	NUMBER	default null,
174 	P_MAINTENANCE_OBJECT_TYPE     	IN	VARCHAR2 default null	,
175 	P_MAINTENANCE_OBJECT_ID		IN	NUMBER	default null,
176 	P_CREATION_ORGANIZATION_ID  	IN	NUMBER	default null
177 );
178 
179 /*#
180  * This procedure is used to update the existing records in MTL_EAM_ASSET_ATTR_VALUES.
181  * It is used to update Asset Attribute Values.
182  * @param p_api_version  Version of the API
183  * @param p_init_msg_list Flag to indicate initialization of message list
184  * @param p_commit Flag to indicate whether API should commit changes
185  * @param p_validation_level Validation Level of the API
186  * @param x_return_status Return status of the procedure call
187  * @param x_msg_count Count of the return messages that API returns
188  * @param x_msg_data The collection of the messages.
189  * @param P_ASSOCIATION_ID Asset Group and Attribute Group association ID. This is the foreign key to MTL_EAM_ASSET_ATTR_GROUPS.ASSOCIATION_ID
190 * @param P_APPLICATION_ID Application Identifier of the flexfield for the attribute group. From MTL_EAM_ASSET_ATTR_GROUPS.APPLICATION_ID
191 * @param P_DESCRIPTIVE_FLEXFIELD_NAME Name of flexfield for the attribute group. From MTL_EAM_ASSET_ATTR_GROUPS.DESCRIPTIVE_FLEXFIELD_NAME
192 * @param P_INVENTORY_ITEM_ID Inventory item identifier of the asset group
193 * @param P_SERIAL_NUMBER Asset Number
194 * @param P_ORGANIZATION_ID Organization identifier of the Asset group
195 * @param P_ATTRIBUTE_CATEGORY Descriptive flexfield structure defining column
196 * @param P_C_ATTRIBUTE1 Descriptive flexfield column
197 * @param P_C_ATTRIBUTE2 Descriptive flexfield column
198 * @param P_C_ATTRIBUTE3 Descriptive flexfield column
199 * @param P_C_ATTRIBUTE4 Descriptive flexfield column
200 * @param P_C_ATTRIBUTE5 Descriptive flexfield column
201 * @param P_C_ATTRIBUTE6 Descriptive flexfield column
202 * @param P_C_ATTRIBUTE7 Descriptive flexfield column
203 * @param P_C_ATTRIBUTE8 Descriptive flexfield column
204 * @param P_C_ATTRIBUTE9 Descriptive flexfield column
205 * @param P_C_ATTRIBUTE10 Descriptive flexfield column
206 * @param P_C_ATTRIBUTE11 Descriptive flexfield column
207 * @param P_C_ATTRIBUTE12 Descriptive flexfield column
208 * @param P_C_ATTRIBUTE13 Descriptive flexfield column
209 * @param P_C_ATTRIBUTE14 Descriptive flexfield column
210 * @param P_C_ATTRIBUTE15 Descriptive flexfield column
211 * @param P_C_ATTRIBUTE16 Descriptive flexfield column
212 * @param P_C_ATTRIBUTE17 Descriptive flexfield column
213 * @param P_C_ATTRIBUTE18 Descriptive flexfield column
214 * @param P_C_ATTRIBUTE19 Descriptive flexfield column
215 * @param P_C_ATTRIBUTE20 Descriptive flexfield column
216 * @param P_D_ATTRIBUTE1 Descriptive flexfield column
217 * @param P_D_ATTRIBUTE2 Descriptive flexfield column
218 * @param P_D_ATTRIBUTE3 Descriptive flexfield column
219 * @param P_D_ATTRIBUTE4 Descriptive flexfield column
220 * @param P_D_ATTRIBUTE5 Descriptive flexfield column
221 * @param P_D_ATTRIBUTE6 Descriptive flexfield column
222 * @param P_D_ATTRIBUTE7 Descriptive flexfield column
223 * @param P_D_ATTRIBUTE8 Descriptive flexfield column
224 * @param P_D_ATTRIBUTE9 Descriptive flexfield column
225 * @param P_D_ATTRIBUTE10 Descriptive flexfield column
226 * @param P_N_ATTRIBUTE1 Descriptive flexfield column
227 * @param P_N_ATTRIBUTE2 Descriptive flexfield column
228 * @param P_N_ATTRIBUTE3 Descriptive flexfield column
229 * @param P_N_ATTRIBUTE4 Descriptive flexfield column
230 * @param P_N_ATTRIBUTE5 Descriptive flexfield column
231 * @param P_N_ATTRIBUTE6 Descriptive flexfield column
232 * @param P_N_ATTRIBUTE7 Descriptive flexfield column
233 * @param P_N_ATTRIBUTE8 Descriptive flexfield column
234 * @param P_N_ATTRIBUTE9 Descriptive flexfield column
235 * @param P_N_ATTRIBUTE10 Descriptive flexfield column
236 * @param P_MAINTENANCE_OBJECT_TYPE Object Type
237 * @param P_MAINTENANCE_OBJECT_ID Object ID
238 * @param P_CREATION_ORGANIZATION_ID Creation Organization Identifier
242  */
239  * @return Returns the status of the procedure call as well as the return messages
240  * @scope public
241  * @rep:displayname Update Asset Attribute Values
243 
244 procedure update_assetattr_value
245 (   p_api_version           	IN	NUMBER			,
246   	p_init_msg_list	   	IN	VARCHAR2:= FND_API.G_FALSE	,
247 	p_commit	    	IN  	VARCHAR2:= FND_API.G_FALSE	,
248 	p_validation_level	IN  	NUMBER  := FND_API.G_VALID_LEVEL_FULL,
249 	x_return_status		OUT NOCOPY VARCHAR2	 ,
250 	x_msg_count		OUT NOCOPY NUMBER	 ,
251 	x_msg_data	 	OUT NOCOPY VARCHAR2  ,
252 	P_ASSOCIATION_ID	IN	NUMBER	,
253 	P_APPLICATION_ID	IN	NUMBER	default 401,
254 	P_DESCRIPTIVE_FLEXFIELD_NAME  IN	VARCHAR2 default 'MTL_EAM_ASSET_ATTR_VALUES'	,
255 	P_INVENTORY_ITEM_ID	IN	NUMBER	default null,
256 	P_SERIAL_NUMBER		IN	VARCHAR2	default null,
257 	P_ORGANIZATION_ID	IN	NUMBER	,
258 	P_ATTRIBUTE_CATEGORY	IN	VARCHAR2	,
259 	P_C_ATTRIBUTE1		IN	VARCHAR2	default null,
260 	P_C_ATTRIBUTE2		IN	VARCHAR2	default null,
261 	P_C_ATTRIBUTE3		IN	VARCHAR2	default null,
262 	P_C_ATTRIBUTE4		IN	VARCHAR2	default null,
263 	P_C_ATTRIBUTE5		IN	VARCHAR2	default null,
264 	P_C_ATTRIBUTE6		IN	VARCHAR2	default null,
265 	P_C_ATTRIBUTE7		IN	VARCHAR2	default null,
266 	P_C_ATTRIBUTE8		IN	VARCHAR2	default null,
267 	P_C_ATTRIBUTE9		IN	VARCHAR2	default null,
268 	P_C_ATTRIBUTE10		IN	VARCHAR2	default null,
269 	P_C_ATTRIBUTE11		IN	VARCHAR2	default null,
270 	P_C_ATTRIBUTE12		IN	VARCHAR2	default null,
271 	P_C_ATTRIBUTE13		IN	VARCHAR2	default null,
272 	P_C_ATTRIBUTE14		IN	VARCHAR2	default null,
273 	P_C_ATTRIBUTE15		IN	VARCHAR2	default null,
274 	P_C_ATTRIBUTE16		IN	VARCHAR2	default null,
275 	P_C_ATTRIBUTE17		IN	VARCHAR2	default null,
276 	P_C_ATTRIBUTE18		IN	VARCHAR2	default null,
277 	P_C_ATTRIBUTE19		IN	VARCHAR2	default null,
278 	P_C_ATTRIBUTE20		IN	VARCHAR2	default null,
279 	P_D_ATTRIBUTE1		IN	DATE	default null,
280 	P_D_ATTRIBUTE2		IN	DATE	default null,
281 	P_D_ATTRIBUTE3		IN	DATE	default null,
282 	P_D_ATTRIBUTE4		IN	DATE	default null,
283 	P_D_ATTRIBUTE5		IN	DATE	default null,
284 	P_D_ATTRIBUTE6		IN	DATE	default null,
285 	P_D_ATTRIBUTE7		IN	DATE	default null,
286 	P_D_ATTRIBUTE8		IN	DATE	default null,
287 	P_D_ATTRIBUTE9		IN	DATE	default null,
288 	P_D_ATTRIBUTE10		IN	DATE	default null,
289 	P_N_ATTRIBUTE1		IN	NUMBER	default null,
290 	P_N_ATTRIBUTE2		IN	NUMBER	default null,
291 	P_N_ATTRIBUTE3		IN	NUMBER	default null,
292 	P_N_ATTRIBUTE4		IN	NUMBER	default null,
293 	P_N_ATTRIBUTE5		IN	NUMBER	default null,
294 	P_N_ATTRIBUTE6		IN	NUMBER	default null,
295 	P_N_ATTRIBUTE7		IN	NUMBER	default null,
296 	P_N_ATTRIBUTE8		IN	NUMBER	default null,
297 	P_N_ATTRIBUTE9		IN	NUMBER	default null,
298 	P_N_ATTRIBUTE10		IN	NUMBER	default null,
299 	P_MAINTENANCE_OBJECT_TYPE     	IN	VARCHAR2	default null,
300 	P_MAINTENANCE_OBJECT_ID		IN	NUMBER	default null,
301 	P_CREATION_ORGANIZATION_ID  	IN	NUMBER	default null
302 );
303 
304 END EAM_ASSETATTR_VALUE_PUB;