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