1 PACKAGE EAM_ASSET_ROUTES_PUB AS
2 /* $Header: EAMPAROS.pls 120.3 2005/07/07 16:04:00 hkarmach noship $ */
3 /*#
4 * This package is used for the INSERT / UPDATE of asset routes.
5 * It defines 2 key procedures insert_asset_routes, update_asset_routes
6 * which first validates and massages the IN parameters
7 * and then carries out the respective operations.
8 * @rep:scope public
9 * @rep:product EAM
10 * @rep:lifecycle active
11 * @rep:displayname Asset Routes
12 * @rep:category BUSINESS_ENTITY EAM_ASSET_ROUTE
13 */
14
15 -- Start of comments
16 -- API name : EAM_ASSET_ROUTES_PUB
17 -- Type : Public
18 -- Function : insert_asset_routes, update_asset_routes
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 * This procedure is used to insert records in MTL_EAM_NETWORK_ASSETS.
54 * It is used to create Asset Routes.
55 * @param p_api_version Version of the API
56 * @param p_init_msg_list Flag to indicate initialization of message list
57 * @param p_commit Flag to indicate whether API should commit changes
58 * @param p_validation_level Validation Level of the API
59 * @param x_return_status Return status of the procedure call
60 * @param x_msg_count Count of the return messages that API returns
61 * @param x_msg_data The collection of the messages.
62 * @param P_ORGANIZATION_ID Organization identifier of the asset route
63 * @param P_START_DATE_ACTIVE Effective start date of the member asset
64 * @param P_END_DATE_ACTIVE Effective end date of the member asset
65 * @param p_attribute_category Attribute Category
66 * @param p_attribute1 Descriptive flexfield column
67 * @param p_attribute2 Descriptive flexfield column
68 * @param p_attribute3 Descriptive flexfield column
69 * @param p_attribute4 Descriptive flexfield column
70 * @param p_attribute5 Descriptive flexfield column
71 * @param p_attribute6 Descriptive flexfield column
72 * @param p_attribute7 Descriptive flexfield column
73 * @param p_attribute8 Descriptive flexfield column
74 * @param p_attribute9 Descriptive flexfield column
75 * @param p_attribute10 Descriptive flexfield column
76 * @param p_attribute11 Descriptive flexfield column
77 * @param p_attribute12 Descriptive flexfield column
78 * @param p_attribute13 Descriptive flexfield column
79 * @param p_attribute14 Descriptive flexfield column
80 * @param p_attribute15 Descriptive flexfield column
81 * @param p_NETWORK_ITEM_ID Inventory item identifier for asset route
82 * @param p_NETWORK_SERIAL_NUMBER Asset route serial number
83 * @param p_INVENTORY_ITEM_ID Inventory item identifier for the asset group
84 * @param p_SERIAL_NUMBER Serial number for the asset
85 * @param p_NETWORK_OBJECT_TYPE Asset Route Object Type. 1 indicates serialized, 2 indicates non-serialized. Currently 1 is the only valid value
86 * @param p_NETWORK_OBJECT_ID Asset Route Object Identifier
87 * @param p_MAINTENANCE_OBJECT_TYPE Maintenance Object Type
88 * @param p_MAINTENANCE_OBJECT_ID Maintenance Object Identifier
89 * @param p_asset_number instance number new parameter as part of Cons Asset Repository
90 * @return Returns the status of the procedure call as well as the return messages
91 * @rep:scope public
92 * @rep:displayname Insert Asset Route
93
94 */
95
96
97 PROCEDURE insert_asset_routes
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 x_return_status OUT NOCOPY VARCHAR2 ,
104 x_msg_count OUT NOCOPY NUMBER ,
105 x_msg_data OUT NOCOPY VARCHAR2 ,
106
107 P_ORGANIZATION_ID IN NUMBER ,
108 P_START_DATE_ACTIVE IN DATE default null,
109 P_END_DATE_ACTIVE IN DATE default null,
110 P_ATTRIBUTE_CATEGORY IN VARCHAR2 default null,
111 P_ATTRIBUTE1 IN VARCHAR2 default null,
112 P_ATTRIBUTE2 IN VARCHAR2 default null,
113 P_ATTRIBUTE3 IN VARCHAR2 default null,
114 P_ATTRIBUTE4 IN VARCHAR2 default null,
115 P_ATTRIBUTE5 IN VARCHAR2 default null,
116 P_ATTRIBUTE6 IN VARCHAR2 default null,
117 P_ATTRIBUTE7 IN VARCHAR2 default null,
118 P_ATTRIBUTE8 IN VARCHAR2 default null,
119 P_ATTRIBUTE9 IN VARCHAR2 default null,
120 P_ATTRIBUTE10 IN VARCHAR2 default null,
121 P_ATTRIBUTE11 IN VARCHAR2 default null,
122 P_ATTRIBUTE12 IN VARCHAR2 default null,
123 P_ATTRIBUTE13 IN VARCHAR2 default null,
124 P_ATTRIBUTE14 IN VARCHAR2 default null,
125 P_ATTRIBUTE15 IN VARCHAR2 default null,
126 P_NETWORK_ITEM_ID IN NUMBER ,
127 P_NETWORK_SERIAL_NUMBER IN VARCHAR2 ,
128 P_INVENTORY_ITEM_ID IN NUMBER default null ,
129 P_SERIAL_NUMBER IN VARCHAR2 default null ,
130 P_NETWORK_OBJECT_TYPE IN NUMBER default null ,
131 P_NETWORK_OBJECT_ID IN NUMBER default null ,
132 P_MAINTENANCE_OBJECT_TYPE IN NUMBER default null ,
133 P_MAINTENANCE_OBJECT_ID IN NUMBER default null ,
134 P_NETWORK_ASSET_NUMBER IN VARCHAR2 default null ,
135 P_ASSET_NUMBER IN VARCHAR2 default null
136 );
137
138 /*#
139 * This procedure is used to update the existing records in MTL_EAM_NETWORK_ASSETS .
140 * It is used to update Asset Routes.
141 * @param p_api_version Version of the API
142 * @param p_init_msg_list Flag to indicate initialization of message list
143 * @param p_commit Flag to indicate whether API should commit changes
144 * @param p_validation_level Validation Level of the API
145 * @param x_return_status Return status of the procedure call
146 * @param x_msg_count Count of the return messages that API returns
147 * @param x_msg_data The collection of the messages.
148 * @param P_ORGANIZATION_ID Organization identifier of the asset route
149 * @param P_START_DATE_ACTIVE Effective start date of the member asset
150 * @param P_END_DATE_ACTIVE Effective end date of the member asset
151 * @param p_attribute_category Attribute Category
152 * @param p_attribute1 Descriptive flexfield column
153 * @param p_attribute2 Descriptive flexfield column
154 * @param p_attribute3 Descriptive flexfield column
155 * @param p_attribute4 Descriptive flexfield column
156 * @param p_attribute5 Descriptive flexfield column
157 * @param p_attribute6 Descriptive flexfield column
158 * @param p_attribute7 Descriptive flexfield column
159 * @param p_attribute8 Descriptive flexfield column
160 * @param p_attribute9 Descriptive flexfield column
161 * @param p_attribute10 Descriptive flexfield column
162 * @param p_attribute11 Descriptive flexfield column
163 * @param p_attribute12 Descriptive flexfield column
164 * @param p_attribute13 Descriptive flexfield column
165 * @param p_attribute14 Descriptive flexfield column
166 * @param p_attribute15 Descriptive flexfield column
167 * @param p_NETWORK_ITEM_ID Inventory item identifier for asset route
168 * @param p_NETWORK_SERIAL_NUMBER Asset route serial number
169 * @param p_INVENTORY_ITEM_ID Inventory item identifier for the asset group
170 * @param p_SERIAL_NUMBER Serial number for the asset
171 * @param P_NETWORK_ASSOCIATION_ID Primary key, association ID
172 * @param p_NETWORK_OBJECT_TYPE Asset Route Object Type. 1 indicates serialized, 2 indicates non-serialized. Currently 1 is the only valid value
173 * @param p_NETWORK_OBJECT_ID Asset Route Object Identifier
174 * @param p_MAINTENANCE_OBJECT_TYPE Maintenance Object Type
175 * @param p_MAINTENANCE_OBJECT_ID Maintenance Object Identifier
176 * @return Returns the status of the procedure call as well as the return messages
177 * @rep:scope public
178 * @rep:displayname Update Asset Route
179 */
180
181 PROCEDURE update_asset_routes
182 (
183 p_api_version IN NUMBER ,
184 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
185 p_commit IN VARCHAR2:= FND_API.G_FALSE ,
186 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187 x_return_status OUT NOCOPY VARCHAR2 ,
188 x_msg_count OUT NOCOPY NUMBER ,
189 x_msg_data OUT NOCOPY VARCHAR2 ,
190
191 P_ORGANIZATION_ID IN NUMBER ,
192 P_START_DATE_ACTIVE IN DATE default null,
193 P_END_DATE_ACTIVE IN DATE default null,
194 P_ATTRIBUTE_CATEGORY IN VARCHAR2 default null,
195 P_ATTRIBUTE1 IN VARCHAR2 default null,
196 P_ATTRIBUTE2 IN VARCHAR2 default null,
197 P_ATTRIBUTE3 IN VARCHAR2 default null,
198 P_ATTRIBUTE4 IN VARCHAR2 default null,
199 P_ATTRIBUTE5 IN VARCHAR2 default null,
200 P_ATTRIBUTE6 IN VARCHAR2 default null,
201 P_ATTRIBUTE7 IN VARCHAR2 default null,
202 P_ATTRIBUTE8 IN VARCHAR2 default null,
203 P_ATTRIBUTE9 IN VARCHAR2 default null,
204 P_ATTRIBUTE10 IN VARCHAR2 default null,
205 P_ATTRIBUTE11 IN VARCHAR2 default null,
206 P_ATTRIBUTE12 IN VARCHAR2 default null,
207 P_ATTRIBUTE13 IN VARCHAR2 default null,
208 P_ATTRIBUTE14 IN VARCHAR2 default null,
209 P_ATTRIBUTE15 IN VARCHAR2 default null,
210 P_NETWORK_ITEM_ID IN NUMBER ,
211 P_NETWORK_SERIAL_NUMBER IN VARCHAR2 ,
212 P_INVENTORY_ITEM_ID IN NUMBER default null,
213 P_SERIAL_NUMBER IN VARCHAR2 default null ,
214 P_NETWORK_ASSOCIATION_ID IN NUMBER ,
215 P_NETWORK_OBJECT_TYPE IN NUMBER default null ,
216 P_NETWORK_OBJECT_ID IN NUMBER default null ,
217 P_MAINTENANCE_OBJECT_TYPE IN NUMBER default null ,
218 P_MAINTENANCE_OBJECT_ID IN NUMBER default null ,
219 P_NETWORK_ASSET_NUMBER IN VARCHAR2 default null ,
220 P_ASSET_NUMBER IN VARCHAR2 default null
221 );
222
223 END;