[Home] [Help]
PACKAGE BODY: APPS.CSI_IEA_VALUES_H_PKG
Source
1 PACKAGE BODY CSI_IEA_VALUES_H_PKG as
2 /* $Header: csitivhb.pls 115.20 2003/09/04 00:20:55 sguthiva ship $ */
3
4
5 g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_IEA_VALUES_H_PKG';
6
7 PROCEDURE Insert_Row(
8 px_ATTRIBUTE_VALUE_HISTORY_ID IN OUT NOCOPY NUMBER,
9 p_ATTRIBUTE_VALUE_ID NUMBER,
10 p_TRANSACTION_ID NUMBER,
11 p_OLD_ATTRIBUTE_VALUE VARCHAR2,
12 p_NEW_ATTRIBUTE_VALUE VARCHAR2,
13 p_OLD_ACTIVE_START_DATE DATE,
14 p_NEW_ACTIVE_START_DATE DATE,
15 p_OLD_ACTIVE_END_DATE DATE,
16 p_NEW_ACTIVE_END_DATE DATE,
17 p_OLD_CONTEXT VARCHAR2,
18 p_NEW_CONTEXT VARCHAR2,
19 p_OLD_ATTRIBUTE1 VARCHAR2,
20 p_NEW_ATTRIBUTE1 VARCHAR2,
21 p_OLD_ATTRIBUTE2 VARCHAR2,
22 p_NEW_ATTRIBUTE2 VARCHAR2,
23 p_OLD_ATTRIBUTE3 VARCHAR2,
24 p_NEW_ATTRIBUTE3 VARCHAR2,
25 p_OLD_ATTRIBUTE4 VARCHAR2,
26 p_NEW_ATTRIBUTE4 VARCHAR2,
27 p_OLD_ATTRIBUTE5 VARCHAR2,
28 p_NEW_ATTRIBUTE5 VARCHAR2,
29 p_OLD_ATTRIBUTE6 VARCHAR2,
30 p_NEW_ATTRIBUTE6 VARCHAR2,
31 p_OLD_ATTRIBUTE7 VARCHAR2,
32 p_NEW_ATTRIBUTE7 VARCHAR2,
33 p_OLD_ATTRIBUTE8 VARCHAR2,
34 p_NEW_ATTRIBUTE8 VARCHAR2,
35 p_OLD_ATTRIBUTE9 VARCHAR2,
36 p_NEW_ATTRIBUTE9 VARCHAR2,
37 p_OLD_ATTRIBUTE10 VARCHAR2,
38 p_NEW_ATTRIBUTE10 VARCHAR2,
39 p_OLD_ATTRIBUTE11 VARCHAR2,
40 p_NEW_ATTRIBUTE11 VARCHAR2,
41 p_OLD_ATTRIBUTE12 VARCHAR2,
42 p_NEW_ATTRIBUTE12 VARCHAR2,
43 p_OLD_ATTRIBUTE13 VARCHAR2,
44 p_NEW_ATTRIBUTE13 VARCHAR2,
45 p_OLD_ATTRIBUTE14 VARCHAR2,
46 p_NEW_ATTRIBUTE14 VARCHAR2,
47 p_OLD_ATTRIBUTE15 VARCHAR2,
48 p_NEW_ATTRIBUTE15 VARCHAR2,
49 p_FULL_DUMP_FLAG VARCHAR2,
50 p_CREATED_BY NUMBER,
51 p_CREATION_DATE DATE,
52 p_LAST_UPDATED_BY NUMBER,
53 p_LAST_UPDATE_DATE DATE,
54 p_LAST_UPDATE_LOGIN NUMBER,
55 p_OBJECT_VERSION_NUMBER NUMBER)
56 IS
57 CURSOR C2 IS SELECT CSI_IEA_VALUES_H_S.nextval FROM sys.dual;
58 BEGIN
59 If (px_ATTRIBUTE_VALUE_HISTORY_ID IS NULL) OR (px_ATTRIBUTE_VALUE_HISTORY_ID = FND_API.G_MISS_NUM) then
60 OPEN C2;
61 FETCH C2 INTO px_ATTRIBUTE_VALUE_HISTORY_ID;
62 CLOSE C2;
63 End If;
64 INSERT INTO CSI_IEA_VALUES_H(
65 ATTRIBUTE_VALUE_HISTORY_ID,
66 ATTRIBUTE_VALUE_ID,
67 TRANSACTION_ID,
68 OLD_ATTRIBUTE_VALUE,
69 NEW_ATTRIBUTE_VALUE,
70 OLD_ACTIVE_START_DATE,
71 NEW_ACTIVE_START_DATE,
72 OLD_ACTIVE_END_DATE,
73 NEW_ACTIVE_END_DATE,
74 OLD_CONTEXT,
75 NEW_CONTEXT,
76 OLD_ATTRIBUTE1,
77 NEW_ATTRIBUTE1,
78 OLD_ATTRIBUTE2,
79 NEW_ATTRIBUTE2,
80 OLD_ATTRIBUTE3,
81 NEW_ATTRIBUTE3,
82 OLD_ATTRIBUTE4,
83 NEW_ATTRIBUTE4,
84 OLD_ATTRIBUTE5,
85 NEW_ATTRIBUTE5,
86 OLD_ATTRIBUTE6,
87 NEW_ATTRIBUTE6,
88 OLD_ATTRIBUTE7,
89 NEW_ATTRIBUTE7,
90 OLD_ATTRIBUTE8,
91 NEW_ATTRIBUTE8,
92 OLD_ATTRIBUTE9,
93 NEW_ATTRIBUTE9,
94 OLD_ATTRIBUTE10,
95 NEW_ATTRIBUTE10,
96 OLD_ATTRIBUTE11,
97 NEW_ATTRIBUTE11,
98 OLD_ATTRIBUTE12,
99 NEW_ATTRIBUTE12,
100 OLD_ATTRIBUTE13,
101 NEW_ATTRIBUTE13,
102 OLD_ATTRIBUTE14,
103 NEW_ATTRIBUTE14,
104 OLD_ATTRIBUTE15,
105 NEW_ATTRIBUTE15,
106 FULL_DUMP_FLAG,
107 CREATED_BY,
108 CREATION_DATE,
109 LAST_UPDATED_BY,
110 LAST_UPDATE_DATE,
111 LAST_UPDATE_LOGIN,
112 OBJECT_VERSION_NUMBER
113 ) VALUES (
114 px_ATTRIBUTE_VALUE_HISTORY_ID,
115 decode( p_ATTRIBUTE_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_VALUE_ID),
116 decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID),
117 decode( p_OLD_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE_VALUE),
118 decode( p_NEW_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE_VALUE),
119 decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_START_DATE),
120 decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_START_DATE),
121 decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_END_DATE),
122 decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_END_DATE),
123 decode( p_OLD_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_OLD_CONTEXT),
124 decode( p_NEW_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_NEW_CONTEXT),
125 decode( p_OLD_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE1),
126 decode( p_NEW_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE1),
127 decode( p_OLD_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE2),
128 decode( p_NEW_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE2),
129 decode( p_OLD_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE3),
130 decode( p_NEW_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE3),
131 decode( p_OLD_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE4),
132 decode( p_NEW_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE4),
133 decode( p_OLD_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE5),
134 decode( p_NEW_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE5),
135 decode( p_OLD_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE6),
136 decode( p_NEW_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE6),
137 decode( p_OLD_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE7),
138 decode( p_NEW_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE7),
139 decode( p_OLD_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE8),
140 decode( p_NEW_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE8),
141 decode( p_OLD_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE9),
142 decode( p_NEW_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE9),
143 decode( p_OLD_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE10),
144 decode( p_NEW_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE10),
145 decode( p_OLD_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE11),
146 decode( p_NEW_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE11),
147 decode( p_OLD_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE12),
148 decode( p_NEW_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE12),
149 decode( p_OLD_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE13),
150 decode( p_NEW_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE13),
151 decode( p_OLD_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE14),
152 decode( p_NEW_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE14),
153 decode( p_OLD_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE15),
154 decode( p_NEW_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE15),
155 decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),
156 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
157 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
158 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
159 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
160 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
161 decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER));
162 End Insert_Row;
163
164 PROCEDURE Update_Row(
165 p_ATTRIBUTE_VALUE_HISTORY_ID NUMBER,
166 p_ATTRIBUTE_VALUE_ID NUMBER,
167 p_TRANSACTION_ID NUMBER,
168 p_OLD_ATTRIBUTE_VALUE VARCHAR2,
169 p_NEW_ATTRIBUTE_VALUE VARCHAR2,
170 p_OLD_ACTIVE_START_DATE DATE,
171 p_NEW_ACTIVE_START_DATE DATE,
172 p_OLD_ACTIVE_END_DATE DATE,
173 p_NEW_ACTIVE_END_DATE DATE,
174 p_OLD_CONTEXT VARCHAR2,
175 p_NEW_CONTEXT VARCHAR2,
176 p_OLD_ATTRIBUTE1 VARCHAR2,
177 p_NEW_ATTRIBUTE1 VARCHAR2,
178 p_OLD_ATTRIBUTE2 VARCHAR2,
179 p_NEW_ATTRIBUTE2 VARCHAR2,
180 p_OLD_ATTRIBUTE3 VARCHAR2,
181 p_NEW_ATTRIBUTE3 VARCHAR2,
182 p_OLD_ATTRIBUTE4 VARCHAR2,
183 p_NEW_ATTRIBUTE4 VARCHAR2,
184 p_OLD_ATTRIBUTE5 VARCHAR2,
185 p_NEW_ATTRIBUTE5 VARCHAR2,
186 p_OLD_ATTRIBUTE6 VARCHAR2,
187 p_NEW_ATTRIBUTE6 VARCHAR2,
188 p_OLD_ATTRIBUTE7 VARCHAR2,
189 p_NEW_ATTRIBUTE7 VARCHAR2,
190 p_OLD_ATTRIBUTE8 VARCHAR2,
191 p_NEW_ATTRIBUTE8 VARCHAR2,
192 p_OLD_ATTRIBUTE9 VARCHAR2,
193 p_NEW_ATTRIBUTE9 VARCHAR2,
194 p_OLD_ATTRIBUTE10 VARCHAR2,
195 p_NEW_ATTRIBUTE10 VARCHAR2,
196 p_OLD_ATTRIBUTE11 VARCHAR2,
197 p_NEW_ATTRIBUTE11 VARCHAR2,
198 p_OLD_ATTRIBUTE12 VARCHAR2,
199 p_NEW_ATTRIBUTE12 VARCHAR2,
200 p_OLD_ATTRIBUTE13 VARCHAR2,
201 p_NEW_ATTRIBUTE13 VARCHAR2,
202 p_OLD_ATTRIBUTE14 VARCHAR2,
203 p_NEW_ATTRIBUTE14 VARCHAR2,
204 p_OLD_ATTRIBUTE15 VARCHAR2,
205 p_NEW_ATTRIBUTE15 VARCHAR2,
206 p_FULL_DUMP_FLAG VARCHAR2,
207 p_CREATED_BY NUMBER,
208 p_CREATION_DATE DATE,
209 p_LAST_UPDATED_BY NUMBER,
210 p_LAST_UPDATE_DATE DATE,
211 p_LAST_UPDATE_LOGIN NUMBER,
212 p_OBJECT_VERSION_NUMBER NUMBER)
213
214 IS
215 BEGIN
216 Update CSI_IEA_VALUES_H
217 SET
218 ATTRIBUTE_VALUE_ID = decode( p_ATTRIBUTE_VALUE_ID, FND_API.G_MISS_NUM, ATTRIBUTE_VALUE_ID, p_ATTRIBUTE_VALUE_ID),
219 TRANSACTION_ID = decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
220 OLD_ATTRIBUTE_VALUE = decode( p_OLD_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE_VALUE, p_OLD_ATTRIBUTE_VALUE),
221 NEW_ATTRIBUTE_VALUE = decode( p_NEW_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE_VALUE, p_NEW_ATTRIBUTE_VALUE),
222 OLD_ACTIVE_START_DATE = decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_START_DATE, p_OLD_ACTIVE_START_DATE),
226 OLD_CONTEXT = decode( p_OLD_CONTEXT, FND_API.G_MISS_CHAR, OLD_CONTEXT, p_OLD_CONTEXT),
223 NEW_ACTIVE_START_DATE = decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_START_DATE, p_NEW_ACTIVE_START_DATE),
224 OLD_ACTIVE_END_DATE = decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_END_DATE, p_OLD_ACTIVE_END_DATE),
225 NEW_ACTIVE_END_DATE = decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_END_DATE, p_NEW_ACTIVE_END_DATE),
227 NEW_CONTEXT = decode( p_NEW_CONTEXT, FND_API.G_MISS_CHAR, NEW_CONTEXT, p_NEW_CONTEXT),
228 OLD_ATTRIBUTE1 = decode( p_OLD_ATTRIBUTE1, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE1, p_OLD_ATTRIBUTE1),
229 NEW_ATTRIBUTE1 = decode( p_NEW_ATTRIBUTE1, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE1, p_NEW_ATTRIBUTE1),
230 OLD_ATTRIBUTE2 = decode( p_OLD_ATTRIBUTE2, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE2, p_OLD_ATTRIBUTE2),
231 NEW_ATTRIBUTE2 = decode( p_NEW_ATTRIBUTE2, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE2, p_NEW_ATTRIBUTE2),
232 OLD_ATTRIBUTE3 = decode( p_OLD_ATTRIBUTE3, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE3, p_OLD_ATTRIBUTE3),
233 NEW_ATTRIBUTE3 = decode( p_NEW_ATTRIBUTE3, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE3, p_NEW_ATTRIBUTE3),
234 OLD_ATTRIBUTE4 = decode( p_OLD_ATTRIBUTE4, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE4, p_OLD_ATTRIBUTE4),
235 NEW_ATTRIBUTE4 = decode( p_NEW_ATTRIBUTE4, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE4, p_NEW_ATTRIBUTE4),
236 OLD_ATTRIBUTE5 = decode( p_OLD_ATTRIBUTE5, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE5, p_OLD_ATTRIBUTE5),
237 NEW_ATTRIBUTE5 = decode( p_NEW_ATTRIBUTE5, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE5, p_NEW_ATTRIBUTE5),
238 OLD_ATTRIBUTE6 = decode( p_OLD_ATTRIBUTE6, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE6, p_OLD_ATTRIBUTE6),
239 NEW_ATTRIBUTE6 = decode( p_NEW_ATTRIBUTE6, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE6, p_NEW_ATTRIBUTE6),
240 OLD_ATTRIBUTE7 = decode( p_OLD_ATTRIBUTE7, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE7, p_OLD_ATTRIBUTE7),
241 NEW_ATTRIBUTE7 = decode( p_NEW_ATTRIBUTE7, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE7, p_NEW_ATTRIBUTE7),
242 OLD_ATTRIBUTE8 = decode( p_OLD_ATTRIBUTE8, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE8, p_OLD_ATTRIBUTE8),
243 NEW_ATTRIBUTE8 = decode( p_NEW_ATTRIBUTE8, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE8, p_NEW_ATTRIBUTE8),
244 OLD_ATTRIBUTE9 = decode( p_OLD_ATTRIBUTE9, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE9, p_OLD_ATTRIBUTE9),
245 NEW_ATTRIBUTE9 = decode( p_NEW_ATTRIBUTE9, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE9, p_NEW_ATTRIBUTE9),
246 OLD_ATTRIBUTE10 = decode( p_OLD_ATTRIBUTE10, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE10, p_OLD_ATTRIBUTE10),
247 NEW_ATTRIBUTE10 = decode( p_NEW_ATTRIBUTE10, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE10, p_NEW_ATTRIBUTE10),
248 OLD_ATTRIBUTE11 = decode( p_OLD_ATTRIBUTE11, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE11, p_OLD_ATTRIBUTE11),
249 NEW_ATTRIBUTE11 = decode( p_NEW_ATTRIBUTE11, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE11, p_NEW_ATTRIBUTE11),
250 OLD_ATTRIBUTE12 = decode( p_OLD_ATTRIBUTE12, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE12, p_OLD_ATTRIBUTE12),
251 NEW_ATTRIBUTE12 = decode( p_NEW_ATTRIBUTE12, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE12, p_NEW_ATTRIBUTE12),
252 OLD_ATTRIBUTE13 = decode( p_OLD_ATTRIBUTE13, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE13, p_OLD_ATTRIBUTE13),
253 NEW_ATTRIBUTE13 = decode( p_NEW_ATTRIBUTE13, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE13, p_NEW_ATTRIBUTE13),
254 OLD_ATTRIBUTE14 = decode( p_OLD_ATTRIBUTE14, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE14, p_OLD_ATTRIBUTE14),
255 NEW_ATTRIBUTE14 = decode( p_NEW_ATTRIBUTE14, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE14, p_NEW_ATTRIBUTE14),
256 OLD_ATTRIBUTE15 = decode( p_OLD_ATTRIBUTE15, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE15, p_OLD_ATTRIBUTE15),
257 NEW_ATTRIBUTE15 = decode( p_NEW_ATTRIBUTE15, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE15, p_NEW_ATTRIBUTE15), FULL_DUMP_FLAG = decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, FULL_DUMP_FLAG, p_FULL_DUMP_FLAG),
258 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
259 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
260 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
261 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
262 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
263 -- OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
264 OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
265 where ATTRIBUTE_VALUE_HISTORY_ID = p_ATTRIBUTE_VALUE_HISTORY_ID;
266
267 If (SQL%NOTFOUND) then
268 RAISE NO_DATA_FOUND;
269 End If;
270 END Update_Row;
271
272 PROCEDURE Delete_Row(
273 p_ATTRIBUTE_VALUE_HISTORY_ID NUMBER)
274 IS
275 BEGIN
276 DELETE FROM CSI_IEA_VALUES_H
277 WHERE ATTRIBUTE_VALUE_HISTORY_ID = p_ATTRIBUTE_VALUE_HISTORY_ID;
278 If (SQL%NOTFOUND) then
279 RAISE NO_DATA_FOUND;
280 End If;
281 END Delete_Row;
282
283 PROCEDURE Lock_Row(
284 p_ATTRIBUTE_VALUE_HISTORY_ID NUMBER,
285 p_ATTRIBUTE_VALUE_ID NUMBER,
286 p_TRANSACTION_ID NUMBER,
287 p_OLD_ATTRIBUTE_VALUE VARCHAR2,
288 p_NEW_ATTRIBUTE_VALUE VARCHAR2,
289 p_OLD_ACTIVE_START_DATE DATE,
290 p_NEW_ACTIVE_START_DATE DATE,
291 p_OLD_ACTIVE_END_DATE DATE,
292 p_NEW_ACTIVE_END_DATE DATE,
293 p_OLD_CONTEXT VARCHAR2,
294 p_NEW_CONTEXT VARCHAR2,
295 p_OLD_ATTRIBUTE1 VARCHAR2,
299 p_OLD_ATTRIBUTE3 VARCHAR2,
296 p_NEW_ATTRIBUTE1 VARCHAR2,
297 p_OLD_ATTRIBUTE2 VARCHAR2,
298 p_NEW_ATTRIBUTE2 VARCHAR2,
300 p_NEW_ATTRIBUTE3 VARCHAR2,
301 p_OLD_ATTRIBUTE4 VARCHAR2,
302 p_NEW_ATTRIBUTE4 VARCHAR2,
303 p_OLD_ATTRIBUTE5 VARCHAR2,
304 p_NEW_ATTRIBUTE5 VARCHAR2,
305 p_OLD_ATTRIBUTE6 VARCHAR2,
306 p_NEW_ATTRIBUTE6 VARCHAR2,
307 p_OLD_ATTRIBUTE7 VARCHAR2,
308 p_NEW_ATTRIBUTE7 VARCHAR2,
309 p_OLD_ATTRIBUTE8 VARCHAR2,
310 p_NEW_ATTRIBUTE8 VARCHAR2,
311 p_OLD_ATTRIBUTE9 VARCHAR2,
312 p_NEW_ATTRIBUTE9 VARCHAR2,
313 p_OLD_ATTRIBUTE10 VARCHAR2,
314 p_NEW_ATTRIBUTE10 VARCHAR2,
315 p_OLD_ATTRIBUTE11 VARCHAR2,
316 p_NEW_ATTRIBUTE11 VARCHAR2,
317 p_OLD_ATTRIBUTE12 VARCHAR2,
318 p_NEW_ATTRIBUTE12 VARCHAR2,
319 p_OLD_ATTRIBUTE13 VARCHAR2,
320 p_NEW_ATTRIBUTE13 VARCHAR2,
321 p_OLD_ATTRIBUTE14 VARCHAR2,
322 p_NEW_ATTRIBUTE14 VARCHAR2,
323 p_OLD_ATTRIBUTE15 VARCHAR2,
324 p_NEW_ATTRIBUTE15 VARCHAR2,
325 p_FULL_DUMP_FLAG VARCHAR2,
326 p_CREATED_BY NUMBER,
327 p_CREATION_DATE DATE,
328 p_LAST_UPDATED_BY NUMBER,
329 p_LAST_UPDATE_DATE DATE,
330 p_LAST_UPDATE_LOGIN NUMBER,
331 p_OBJECT_VERSION_NUMBER NUMBER)
332
333 IS
334 CURSOR C IS
335 SELECT *
336 FROM CSI_IEA_VALUES_H
337 WHERE ATTRIBUTE_VALUE_HISTORY_ID = p_ATTRIBUTE_VALUE_HISTORY_ID
338 FOR UPDATE of ATTRIBUTE_VALUE_HISTORY_ID NOWAIT;
339 Recinfo C%ROWTYPE;
340 BEGIN
341 OPEN C;
342 FETCH C INTO Recinfo;
343 If (C%NOTFOUND) then
344 CLOSE C;
345 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
346 APP_EXCEPTION.RAISE_EXCEPTION;
347 End If;
348 CLOSE C;
349 if (
350 ( Recinfo.ATTRIBUTE_VALUE_HISTORY_ID = p_ATTRIBUTE_VALUE_HISTORY_ID)
351 AND ( ( Recinfo.ATTRIBUTE_VALUE_ID = p_ATTRIBUTE_VALUE_ID)
352 OR ( ( Recinfo.ATTRIBUTE_VALUE_ID IS NULL )
353 AND ( p_ATTRIBUTE_VALUE_ID IS NULL )))
354 AND ( ( Recinfo.TRANSACTION_ID = p_TRANSACTION_ID)
355 OR ( ( Recinfo.TRANSACTION_ID IS NULL )
356 AND ( p_TRANSACTION_ID IS NULL )))
357 AND ( ( Recinfo.OLD_ATTRIBUTE_VALUE = p_OLD_ATTRIBUTE_VALUE)
358 OR ( ( Recinfo.OLD_ATTRIBUTE_VALUE IS NULL )
359 AND ( p_OLD_ATTRIBUTE_VALUE IS NULL )))
360 AND ( ( Recinfo.NEW_ATTRIBUTE_VALUE = p_NEW_ATTRIBUTE_VALUE)
361 OR ( ( Recinfo.NEW_ATTRIBUTE_VALUE IS NULL )
362 AND ( p_NEW_ATTRIBUTE_VALUE IS NULL )))
363 AND ( ( Recinfo.OLD_ACTIVE_START_DATE = p_OLD_ACTIVE_START_DATE)
364 OR ( ( Recinfo.OLD_ACTIVE_START_DATE IS NULL )
365 AND ( p_OLD_ACTIVE_START_DATE IS NULL )))
366 AND ( ( Recinfo.NEW_ACTIVE_START_DATE = p_NEW_ACTIVE_START_DATE)
367 OR ( ( Recinfo.NEW_ACTIVE_START_DATE IS NULL )
368 AND ( p_NEW_ACTIVE_START_DATE IS NULL )))
369 AND ( ( Recinfo.OLD_ACTIVE_END_DATE = p_OLD_ACTIVE_END_DATE)
370 OR ( ( Recinfo.OLD_ACTIVE_END_DATE IS NULL )
371 AND ( p_OLD_ACTIVE_END_DATE IS NULL )))
372 AND ( ( Recinfo.NEW_ACTIVE_END_DATE = p_NEW_ACTIVE_END_DATE)
373 OR ( ( Recinfo.NEW_ACTIVE_END_DATE IS NULL )
374 AND ( p_NEW_ACTIVE_END_DATE IS NULL )))
375
376 AND ( ( Recinfo.OLD_CONTEXT = p_OLD_CONTEXT)
377 OR ( ( Recinfo.OLD_CONTEXT IS NULL )
378 AND ( p_OLD_CONTEXT IS NULL )))
379 AND ( ( Recinfo.NEW_CONTEXT = p_NEW_CONTEXT)
380 OR ( ( Recinfo.NEW_CONTEXT IS NULL )
381 AND ( p_NEW_CONTEXT IS NULL )))
382
383 AND ( ( Recinfo.OLD_ATTRIBUTE1 = p_OLD_ATTRIBUTE1)
384 OR ( ( Recinfo.OLD_ATTRIBUTE1 IS NULL )
385 AND ( p_OLD_ATTRIBUTE1 IS NULL )))
386 AND ( ( Recinfo.NEW_ATTRIBUTE1 = p_NEW_ATTRIBUTE1)
387 OR ( ( Recinfo.NEW_ATTRIBUTE1 IS NULL )
388 AND ( p_NEW_ATTRIBUTE1 IS NULL )))
389
390 AND ( ( Recinfo.OLD_ATTRIBUTE2 = p_OLD_ATTRIBUTE2)
391 OR ( ( Recinfo.OLD_ATTRIBUTE2 IS NULL )
392 AND ( p_OLD_ATTRIBUTE2 IS NULL )))
393 AND ( ( Recinfo.NEW_ATTRIBUTE2 = p_NEW_ATTRIBUTE2)
394 OR ( ( Recinfo.NEW_ATTRIBUTE2 IS NULL )
395 AND ( p_NEW_ATTRIBUTE2 IS NULL )))
396
397 AND ( ( Recinfo.OLD_ATTRIBUTE3 = p_OLD_ATTRIBUTE3)
398 OR ( ( Recinfo.OLD_ATTRIBUTE3 IS NULL )
399 AND ( p_OLD_ATTRIBUTE3 IS NULL )))
400 AND ( ( Recinfo.NEW_ATTRIBUTE3 = p_NEW_ATTRIBUTE3)
401 OR ( ( Recinfo.NEW_ATTRIBUTE3 IS NULL )
402 AND ( p_NEW_ATTRIBUTE3 IS NULL )))
403
404 AND ( ( Recinfo.OLD_ATTRIBUTE4 = p_OLD_ATTRIBUTE4)
405 OR ( ( Recinfo.OLD_ATTRIBUTE4 IS NULL )
406 AND ( p_OLD_ATTRIBUTE4 IS NULL )))
407 AND ( ( Recinfo.NEW_ATTRIBUTE4 = p_NEW_ATTRIBUTE4)
408 OR ( ( Recinfo.NEW_ATTRIBUTE4 IS NULL )
412 OR ( ( Recinfo.OLD_ATTRIBUTE5 IS NULL )
409 AND ( p_NEW_ATTRIBUTE4 IS NULL )))
410
411 AND ( ( Recinfo.OLD_ATTRIBUTE5 = p_OLD_ATTRIBUTE5)
413 AND ( p_OLD_ATTRIBUTE5 IS NULL )))
414 AND ( ( Recinfo.NEW_ATTRIBUTE5 = p_NEW_ATTRIBUTE5)
415 OR ( ( Recinfo.NEW_ATTRIBUTE5 IS NULL )
416 AND ( p_NEW_ATTRIBUTE5 IS NULL )))
417
418 AND ( ( Recinfo.OLD_ATTRIBUTE6 = p_OLD_ATTRIBUTE6)
419 OR ( ( Recinfo.OLD_ATTRIBUTE6 IS NULL )
420 AND ( p_OLD_ATTRIBUTE6 IS NULL )))
421 AND ( ( Recinfo.NEW_ATTRIBUTE6 = p_NEW_ATTRIBUTE6)
422 OR ( ( Recinfo.NEW_ATTRIBUTE6 IS NULL )
423 AND ( p_NEW_ATTRIBUTE6 IS NULL )))
424
425 AND ( ( Recinfo.OLD_ATTRIBUTE7 = p_OLD_ATTRIBUTE7)
426 OR ( ( Recinfo.OLD_ATTRIBUTE7 IS NULL )
427 AND ( p_OLD_ATTRIBUTE7 IS NULL )))
428 AND ( ( Recinfo.NEW_ATTRIBUTE7 = p_NEW_ATTRIBUTE7)
429 OR ( ( Recinfo.NEW_ATTRIBUTE7 IS NULL )
430 AND ( p_NEW_ATTRIBUTE7 IS NULL )))
431
432 AND ( ( Recinfo.OLD_ATTRIBUTE8 = p_OLD_ATTRIBUTE8)
433 OR ( ( Recinfo.OLD_ATTRIBUTE8 IS NULL )
434 AND ( p_OLD_ATTRIBUTE8 IS NULL )))
435 AND ( ( Recinfo.NEW_ATTRIBUTE8 = p_NEW_ATTRIBUTE8)
436 OR ( ( Recinfo.NEW_ATTRIBUTE8 IS NULL )
437 AND ( p_NEW_ATTRIBUTE8 IS NULL )))
438
439 AND ( ( Recinfo.OLD_ATTRIBUTE9 = p_OLD_ATTRIBUTE9)
440 OR ( ( Recinfo.OLD_ATTRIBUTE9 IS NULL )
441 AND ( p_OLD_ATTRIBUTE9 IS NULL )))
442 AND ( ( Recinfo.NEW_ATTRIBUTE9 = p_NEW_ATTRIBUTE9)
443 OR ( ( Recinfo.NEW_ATTRIBUTE9 IS NULL )
444 AND ( p_NEW_ATTRIBUTE9 IS NULL )))
445
446 AND ( ( Recinfo.OLD_ATTRIBUTE10 = p_OLD_ATTRIBUTE10)
447 OR ( ( Recinfo.OLD_ATTRIBUTE10 IS NULL )
448 AND ( p_OLD_ATTRIBUTE10 IS NULL )))
449 AND ( ( Recinfo.NEW_ATTRIBUTE10 = p_NEW_ATTRIBUTE10)
450 OR ( ( Recinfo.NEW_ATTRIBUTE10 IS NULL )
451 AND ( p_NEW_ATTRIBUTE10 IS NULL )))
452
453 AND ( ( Recinfo.OLD_ATTRIBUTE11 = p_OLD_ATTRIBUTE11)
454 OR ( ( Recinfo.OLD_ATTRIBUTE11 IS NULL )
455 AND ( p_OLD_ATTRIBUTE11 IS NULL )))
456 AND ( ( Recinfo.NEW_ATTRIBUTE11 = p_NEW_ATTRIBUTE11)
457 OR ( ( Recinfo.NEW_ATTRIBUTE12 IS NULL )
458 AND ( p_NEW_ATTRIBUTE12 IS NULL )))
459
460 AND ( ( Recinfo.OLD_ATTRIBUTE12 = p_OLD_ATTRIBUTE12)
461 OR ( ( Recinfo.OLD_ATTRIBUTE12 IS NULL )
462 AND ( p_OLD_ATTRIBUTE12 IS NULL )))
463 AND ( ( Recinfo.NEW_ATTRIBUTE12 = p_NEW_ATTRIBUTE12)
464 OR ( ( Recinfo.NEW_ATTRIBUTE12 IS NULL )
465 AND ( p_NEW_ATTRIBUTE12 IS NULL )))
466
467 AND ( ( Recinfo.OLD_ATTRIBUTE13 = p_OLD_ATTRIBUTE13)
468 OR ( ( Recinfo.OLD_ATTRIBUTE13 IS NULL )
469 AND ( p_OLD_ATTRIBUTE13 IS NULL )))
470 AND ( ( Recinfo.NEW_ATTRIBUTE13 = p_NEW_ATTRIBUTE13)
471 OR ( ( Recinfo.NEW_ATTRIBUTE13 IS NULL )
472 AND ( p_NEW_ATTRIBUTE13 IS NULL )))
473
474 AND ( ( Recinfo.OLD_ATTRIBUTE14 = p_OLD_ATTRIBUTE14)
475 OR ( ( Recinfo.OLD_ATTRIBUTE14 IS NULL )
476 AND ( p_OLD_ATTRIBUTE14 IS NULL )))
477 AND ( ( Recinfo.NEW_ATTRIBUTE14 = p_NEW_ATTRIBUTE14)
478 OR ( ( Recinfo.NEW_ATTRIBUTE14 IS NULL )
479 AND ( p_NEW_ATTRIBUTE14 IS NULL )))
480
481 AND ( ( Recinfo.OLD_ATTRIBUTE15 = p_OLD_ATTRIBUTE15)
482 OR ( ( Recinfo.OLD_ATTRIBUTE15 IS NULL )
483 AND ( p_OLD_ATTRIBUTE15 IS NULL )))
484 AND ( ( Recinfo.NEW_ATTRIBUTE15 = p_NEW_ATTRIBUTE15)
485 OR ( ( Recinfo.NEW_ATTRIBUTE15 IS NULL )
486 AND ( p_NEW_ATTRIBUTE15 IS NULL )))
487
488 AND ( ( Recinfo.FULL_DUMP_FLAG = p_FULL_DUMP_FLAG)
489 OR ( ( Recinfo.FULL_DUMP_FLAG IS NULL )
490 AND ( p_FULL_DUMP_FLAG IS NULL )))
491
492 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
493 OR ( ( Recinfo.CREATED_BY IS NULL )
494 AND ( p_CREATED_BY IS NULL )))
495 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
496 OR ( ( Recinfo.CREATION_DATE IS NULL )
497 AND ( p_CREATION_DATE IS NULL )))
498 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
499 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
500 AND ( p_LAST_UPDATED_BY IS NULL )))
501 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
502 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
503 AND ( p_LAST_UPDATE_DATE IS NULL )))
504 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
505 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
506 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
507 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
508 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
509 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
510 ) then
511 return;
512 else
513 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
514 APP_EXCEPTION.RAISE_EXCEPTION;
515 End If;
516 END Lock_Row;
517
518 End CSI_IEA_VALUES_H_PKG;