[Home] [Help]
PACKAGE: APPS.EAM_ASSET_ATTR_PVT
Source
1 PACKAGE EAM_ASSET_ATTR_PVT AUTHID CURRENT_USER as
2 /* $Header: EAMVAATS.pls 115.6 2004/02/18 13:56:14 ashetye ship $ */
3 -- Start of comments
4 -- API name : EAM_ASSET_ATTR_PVT
5 -- Type : Private
6 -- Function :
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN P_API_VERSION IN NUMBER REQUIRED
10 -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
11 -- DEFAULT = FND_API.G_FALSE
12 -- P_COMMIT IN VARCHAR2 OPTIONAL
13 -- DEFAULT = FND_API.G_FALSE
14 -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
15 -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
16 -- P_ROWID IN OUT VARCHAR2 REQUIRED
17 -- P_INVENTORY_ITEM_ID IN NUMBER
18 -- P_SERIAL_NUMBER IN VARCHAR2
19 -- P_START_DATE_ACTIVE IN DATE
20 -- P_DESCRIPTIVE_TEXT IN VARCHAR2
21 -- P_ORGANIZATION_ID IN NUMBER
22 -- P_CATEGORY_ID IN NUMBER
23 -- P_PN_LOCATION_ID IN NUMBER
24 -- P_EAM_LOCATION_ID IN NUMBER
25 -- P_FA_ASSET_ID IN NUMBER
26 -- P_ASSET_STATUS_CODE IN VARCHAR2
27 -- P_ASSET_CRITICALITY_CODE IN VARCHAR2
28 -- P_WIP_ACCOUNTING_CLASS_CODE IN VARCHAR2
29 -- P_MAINTAINABLE_FLAG IN VARCHAR2
30 -- P_NETWORK_ASSET_FLAG IN VARCHAR2
31 -- P_OWNING_DEPARTMENT_ID IN NUMBER
32 -- P_DEPENDENT_ASSET_FLAG IN VARCHAR2
33 -- P_ATTRIBUTE_CATEGORY IN VARCHAR2 OPTIONAL
34 -- P_ATTRIBUTE1 IN VARCHAR2 OPTIONAL
35 -- P_ATTRIBUTE2 IN VARCHAR2 OPTIONAL
36 -- P_ATTRIBUTE3 IN VARCHAR2 OPTIONAL
37 -- P_ATTRIBUTE4 IN VARCHAR2 OPTIONAL
38 -- P_ATTRIBUTE5 IN VARCHAR2 OPTIONAL
39 -- P_ATTRIBUTE6 IN VARCHAR2 OPTIONAL
40 -- P_ATTRIBUTE7 IN VARCHAR2 OPTIONAL
41 -- P_ATTRIBUTE8 IN VARCHAR2 OPTIONAL
42 -- P_ATTRIBUTE9 IN VARCHAR2 OPTIONAL
43 -- P_ATTRIBUTE10 IN VARCHAR2 OPTIONAL
44 -- P_ATTRIBUTE11 IN VARCHAR2 OPTIONAL
45 -- P_ATTRIBUTE12 IN VARCHAR2 OPTIONAL
46 -- P_ATTRIBUTE13 IN VARCHAR2 OPTIONAL
47 -- P_ATTRIBUTE14 IN VARCHAR2 OPTIONAL
48 -- P_ATTRIBUTE15 IN VARCHAR2 OPTIONAL
49 -- P_LAST_UPDATE_DATE IN DATE REQUIRED
50 -- P_LAST_UPDATED_BY IN NUMBER REQUIRED
51 -- P_CREATION_DATE IN DATE REQUIRED
52 -- P_CREATED_BY IN NUMBER REQUIRED
53 -- P_LAST_UPDATE_LOGIN IN NUMBER REQUIRED
54 -- P_REQUEST_ID IN NUMBER DEFAULT NULL OPTIONAL
55 -- P_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT NULL OPTIONAL
56 -- P_PROGRAM_ID IN NUMBER DEFAULT NULL OPTIONAL
57 -- P_PROGRAM_UPDATE_DATE IN DATE DEFAULT NULL
58 -- OUT X_OBJECT_ID OUT NUMBER
59 -- X_RETURN_STATUS OUT VARCHAR2(1)
60 -- X_MSG_COUNT OUT NUMBER
61 -- X_MSG_DATA OUT VARCHAR2(2000)
62 --
63 -- Version Current version 115.0
64 --
65 -- Notes : Note text
66 --
67 -- End of comments
68
69
70 PROCEDURE INSERT_ROW(
71 P_API_VERSION IN NUMBER,
72 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
73 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
74 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75 P_ROWID IN OUT NOCOPY VARCHAR2,
76 P_ASSOCIATION_ID NUMBER,
77 P_APPLICATION_ID NUMBER,
78 P_DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2,
79 P_INVENTORY_ITEM_ID NUMBER,
80 P_SERIAL_NUMBER VARCHAR2,
81 P_ORGANIZATION_ID NUMBER,
82 P_ATTRIBUTE_CATEGORY VARCHAR2,
83 P_C_ATTRIBUTE1 VARCHAR2,
84 P_C_ATTRIBUTE2 VARCHAR2,
85 P_C_ATTRIBUTE3 VARCHAR2,
86 P_C_ATTRIBUTE4 VARCHAR2,
87 P_C_ATTRIBUTE5 VARCHAR2,
88 P_C_ATTRIBUTE6 VARCHAR2,
89 P_C_ATTRIBUTE7 VARCHAR2,
90 P_C_ATTRIBUTE8 VARCHAR2,
91 P_C_ATTRIBUTE9 VARCHAR2,
92 P_C_ATTRIBUTE10 VARCHAR2,
93 P_C_ATTRIBUTE11 VARCHAR2,
94 P_C_ATTRIBUTE12 VARCHAR2,
95 P_C_ATTRIBUTE13 VARCHAR2,
96 P_C_ATTRIBUTE14 VARCHAR2,
97 P_C_ATTRIBUTE15 VARCHAR2,
98 P_C_ATTRIBUTE16 VARCHAR2,
99 P_C_ATTRIBUTE17 VARCHAR2,
100 P_C_ATTRIBUTE18 VARCHAR2,
101 P_C_ATTRIBUTE19 VARCHAR2,
102 P_C_ATTRIBUTE20 VARCHAR2,
103 P_D_ATTRIBUTE1 DATE,
104 P_D_ATTRIBUTE2 DATE,
105 P_D_ATTRIBUTE3 DATE,
106 P_D_ATTRIBUTE4 DATE,
107 P_D_ATTRIBUTE5 DATE,
108 P_D_ATTRIBUTE6 DATE,
109 P_D_ATTRIBUTE7 DATE,
110 P_D_ATTRIBUTE8 DATE,
111 P_D_ATTRIBUTE9 DATE,
112 P_D_ATTRIBUTE10 DATE,
113 P_N_ATTRIBUTE1 NUMBER,
114 P_N_ATTRIBUTE2 NUMBER,
115 P_N_ATTRIBUTE3 NUMBER,
116 P_N_ATTRIBUTE4 NUMBER,
117 P_N_ATTRIBUTE5 NUMBER,
118 P_N_ATTRIBUTE6 NUMBER,
119 P_N_ATTRIBUTE7 NUMBER,
120 P_N_ATTRIBUTE8 NUMBER,
121 P_N_ATTRIBUTE9 NUMBER,
122 P_N_ATTRIBUTE10 NUMBER,
123 P_REQUEST_ID NUMBER DEFAULT NULL,
124 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
125 P_PROGRAM_ID NUMBER DEFAULT NULL,
126 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
127 P_MAINTENANCE_OBJECT_TYPE NUMBER,
128 P_MAINTENANCE_OBJECT_ID NUMBER,
129 P_CREATION_ORGANIZATION_ID NUMBER,
130 P_LAST_UPDATE_DATE DATE,
131 P_LAST_UPDATED_BY NUMBER,
132 P_CREATION_DATE DATE,
133 P_CREATED_BY NUMBER,
134 P_LAST_UPDATE_LOGIN NUMBER,
135 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
136 X_MSG_COUNT OUT NOCOPY NUMBER,
137 X_MSG_DATA OUT NOCOPY VARCHAR2);
138
139
140
141 PROCEDURE LOCK_ROW(
142 P_API_VERSION IN NUMBER,
143 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
144 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
145 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146 P_ROWID IN OUT NOCOPY VARCHAR2,
147 P_ASSOCIATION_ID NUMBER,
148 P_APPLICATION_ID NUMBER,
149 P_DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2,
150 P_INVENTORY_ITEM_ID NUMBER,
151 P_SERIAL_NUMBER VARCHAR2,
152 P_ORGANIZATION_ID NUMBER,
153 P_ATTRIBUTE_CATEGORY VARCHAR2,
154 P_C_ATTRIBUTE1 VARCHAR2,
155 P_C_ATTRIBUTE2 VARCHAR2,
156 P_C_ATTRIBUTE3 VARCHAR2,
157 P_C_ATTRIBUTE4 VARCHAR2,
158 P_C_ATTRIBUTE5 VARCHAR2,
159 P_C_ATTRIBUTE6 VARCHAR2,
160 P_C_ATTRIBUTE7 VARCHAR2,
161 P_C_ATTRIBUTE8 VARCHAR2,
162 P_C_ATTRIBUTE9 VARCHAR2,
163 P_C_ATTRIBUTE10 VARCHAR2,
164 P_C_ATTRIBUTE11 VARCHAR2,
165 P_C_ATTRIBUTE12 VARCHAR2,
166 P_C_ATTRIBUTE13 VARCHAR2,
167 P_C_ATTRIBUTE14 VARCHAR2,
168 P_C_ATTRIBUTE15 VARCHAR2,
169 P_C_ATTRIBUTE16 VARCHAR2,
170 P_C_ATTRIBUTE17 VARCHAR2,
171 P_C_ATTRIBUTE18 VARCHAR2,
172 P_C_ATTRIBUTE19 VARCHAR2,
173 P_C_ATTRIBUTE20 VARCHAR2,
174 P_D_ATTRIBUTE1 DATE,
175 P_D_ATTRIBUTE2 DATE,
176 P_D_ATTRIBUTE3 DATE,
177 P_D_ATTRIBUTE4 DATE,
178 P_D_ATTRIBUTE5 DATE,
179 P_D_ATTRIBUTE6 DATE,
180 P_D_ATTRIBUTE7 DATE,
181 P_D_ATTRIBUTE8 DATE,
182 P_D_ATTRIBUTE9 DATE,
183 P_D_ATTRIBUTE10 DATE,
184 P_N_ATTRIBUTE1 NUMBER,
185 P_N_ATTRIBUTE2 NUMBER,
186 P_N_ATTRIBUTE3 NUMBER,
187 P_N_ATTRIBUTE4 NUMBER,
188 P_N_ATTRIBUTE5 NUMBER,
189 P_N_ATTRIBUTE6 NUMBER,
190 P_N_ATTRIBUTE7 NUMBER,
191 P_N_ATTRIBUTE8 NUMBER,
192 P_N_ATTRIBUTE9 NUMBER,
193 P_N_ATTRIBUTE10 NUMBER,
194 P_REQUEST_ID NUMBER DEFAULT NULL,
195 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
196 P_PROGRAM_ID NUMBER DEFAULT NULL,
197 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
198 P_MAINTENANCE_OBJECT_TYPE NUMBER,
199 P_MAINTENANCE_OBJECT_ID NUMBER,
200 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
201 X_MSG_COUNT OUT NOCOPY NUMBER,
202 X_MSG_DATA OUT NOCOPY VARCHAR2);
203
204
205
206 PROCEDURE UPDATE_ROW(
207 P_API_VERSION IN NUMBER,
208 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
209 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
210 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
211 P_ROWID IN OUT NOCOPY VARCHAR2,
212 P_C_ATTRIBUTE1 VARCHAR2,
213 P_C_ATTRIBUTE2 VARCHAR2,
214 P_C_ATTRIBUTE3 VARCHAR2,
215 P_C_ATTRIBUTE4 VARCHAR2,
216 P_C_ATTRIBUTE5 VARCHAR2,
217 P_C_ATTRIBUTE6 VARCHAR2,
218 P_C_ATTRIBUTE7 VARCHAR2,
219 P_C_ATTRIBUTE8 VARCHAR2,
220 P_C_ATTRIBUTE9 VARCHAR2,
221 P_C_ATTRIBUTE10 VARCHAR2,
222 P_C_ATTRIBUTE11 VARCHAR2,
223 P_C_ATTRIBUTE12 VARCHAR2,
224 P_C_ATTRIBUTE13 VARCHAR2,
225 P_C_ATTRIBUTE14 VARCHAR2,
226 P_C_ATTRIBUTE15 VARCHAR2,
227 P_C_ATTRIBUTE16 VARCHAR2,
228 P_C_ATTRIBUTE17 VARCHAR2,
229 P_C_ATTRIBUTE18 VARCHAR2,
230 P_C_ATTRIBUTE19 VARCHAR2,
231 P_C_ATTRIBUTE20 VARCHAR2,
232 P_D_ATTRIBUTE1 DATE,
233 P_D_ATTRIBUTE2 DATE,
234 P_D_ATTRIBUTE3 DATE,
235 P_D_ATTRIBUTE4 DATE,
236 P_D_ATTRIBUTE5 DATE,
237 P_D_ATTRIBUTE6 DATE,
238 P_D_ATTRIBUTE7 DATE,
239 P_D_ATTRIBUTE8 DATE,
240 P_D_ATTRIBUTE9 DATE,
241 P_D_ATTRIBUTE10 DATE,
242 P_N_ATTRIBUTE1 NUMBER,
243 P_N_ATTRIBUTE2 NUMBER,
244 P_N_ATTRIBUTE3 NUMBER,
245 P_N_ATTRIBUTE4 NUMBER,
246 P_N_ATTRIBUTE5 NUMBER,
247 P_N_ATTRIBUTE6 NUMBER,
248 P_N_ATTRIBUTE7 NUMBER,
249 P_N_ATTRIBUTE8 NUMBER,
250 P_N_ATTRIBUTE9 NUMBER,
251 P_N_ATTRIBUTE10 NUMBER,
252 P_REQUEST_ID NUMBER DEFAULT NULL,
253 P_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL,
254 P_PROGRAM_ID NUMBER DEFAULT NULL,
255 P_PROGRAM_UPDATE_DATE DATE DEFAULT NULL,
256 P_MAINTENANCE_OBJECT_TYPE NUMBER,
257 P_MAINTENANCE_OBJECT_ID NUMBER,
258 P_LAST_UPDATE_DATE DATE,
259 P_LAST_UPDATED_BY NUMBER,
260 P_LAST_UPDATE_LOGIN NUMBER,
261 /* Bug 3371507 */
262 P_FROM_PUBLIC_API VARCHAR2 DEFAULT 'Y',
263 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
264 X_MSG_COUNT OUT NOCOPY NUMBER,
265 X_MSG_DATA OUT NOCOPY VARCHAR2);
266
267
268
269 PROCEDURE DELETE_ROW(
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 := FND_API.G_VALID_LEVEL_FULL,
274 P_ROWID IN OUT NOCOPY VARCHAR2,
275 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
276 X_MSG_COUNT OUT NOCOPY NUMBER,
277 X_MSG_DATA OUT NOCOPY VARCHAR2);
278
279
280
281 PROCEDURE COPY_ATTRIBUTE(
282 P_API_VERSION IN NUMBER,
283 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
284 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
285 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286 P_INVENTORY_ITEM_ID IN NUMBER,
287 P_ORGANIZATION_ID IN NUMBER,
288 P_SERIAL_NUMBER_FROM IN VARCHAR2,
289 P_SERIAL_NUMBER_TO IN VARCHAR2,
290 X_OBJECT_ID OUT NOCOPY NUMBER,
294
291 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
292 X_MSG_COUNT OUT NOCOPY NUMBER,
293 X_MSG_DATA OUT NOCOPY VARCHAR2);
295
296 END EAM_ASSET_ATTR_PVT;