[Home] [Help]
PACKAGE BODY: APPS.CSI_T_TRANSACTION_LINES_PKG
Source
1 PACKAGE BODY CSI_T_TRANSACTION_LINES_PKG as
2 /* $Header: csitttlb.pls 115.7 2002/11/12 00:27:20 rmamidip noship $ */
3 -- Package name : CSI_T_TRANSACTION_LINES_PKG
4 -- Purpose : Table Handler for csi_t_transaction_lines
5 -- History : brmanesh created 12-MAY-2001
6 -- NOTE :
7
8 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_T_TRANSACTION_LINES_PKG';
9 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitttlb.pls';
10
11 PROCEDURE Insert_Row(
12 px_TRANSACTION_LINE_ID IN OUT NOCOPY NUMBER,
13 p_SOURCE_TRANSACTION_TYPE_ID NUMBER,
14 p_SOURCE_TRANSACTION_TABLE VARCHAR2,
15 p_SOURCE_TXN_HEADER_ID NUMBER,
16 p_SOURCE_TRANSACTION_ID NUMBER,
17 P_CONFIG_SESSION_HDR_ID NUMBER ,
18 P_CONFIG_SESSION_REV_NUM NUMBER ,
19 P_CONFIG_SESSION_ITEM_ID NUMBER ,
20 P_CONFIG_VALID_STATUS VARCHAR2 ,
21 P_SOURCE_TRANSACTION_STATUS VARCHAR2 ,
22 p_ERROR_CODE VARCHAR2,
23 p_ERROR_EXPLANATION VARCHAR2,
24 p_PROCESSING_STATUS VARCHAR2,
25 p_ATTRIBUTE1 VARCHAR2,
26 p_ATTRIBUTE2 VARCHAR2,
27 p_ATTRIBUTE3 VARCHAR2,
28 p_ATTRIBUTE4 VARCHAR2,
29 p_ATTRIBUTE5 VARCHAR2,
30 p_ATTRIBUTE6 VARCHAR2,
31 p_ATTRIBUTE7 VARCHAR2,
32 p_ATTRIBUTE8 VARCHAR2,
33 p_ATTRIBUTE9 VARCHAR2,
34 p_ATTRIBUTE10 VARCHAR2,
35 p_ATTRIBUTE11 VARCHAR2,
36 p_ATTRIBUTE12 VARCHAR2,
37 p_ATTRIBUTE13 VARCHAR2,
38 p_ATTRIBUTE14 VARCHAR2,
39 p_ATTRIBUTE15 VARCHAR2,
40 p_CREATED_BY NUMBER,
41 p_CREATION_DATE DATE,
42 p_LAST_UPDATED_BY NUMBER,
43 p_LAST_UPDATE_DATE DATE,
44 p_LAST_UPDATE_LOGIN NUMBER,
45 p_OBJECT_VERSION_NUMBER NUMBER,
46 p_CONTEXT VARCHAR2)
47
48 IS
49 CURSOR C2 IS SELECT CSI_T_TRANSACTION_LINES_S.nextval FROM sys.dual;
50 BEGIN
51 If (px_TRANSACTION_LINE_ID IS NULL) OR (px_TRANSACTION_LINE_ID = FND_API.G_MISS_NUM) then
52 OPEN C2;
53 FETCH C2 INTO px_TRANSACTION_LINE_ID;
54 CLOSE C2;
55 End If;
56 INSERT INTO CSI_T_TRANSACTION_LINES(
57 TRANSACTION_LINE_ID,
58 SOURCE_TRANSACTION_TYPE_ID,
59 SOURCE_TRANSACTION_TABLE,
60 SOURCE_TXN_HEADER_ID,
61 SOURCE_TRANSACTION_ID,
62 CONFIG_SESSION_HDR_ID ,
63 CONFIG_SESSION_REV_NUM,
64 CONFIG_SESSION_ITEM_ID ,
65 CONFIG_VALID_STATUS ,
66 SOURCE_TRANSACTION_STATUS ,
67 ERROR_CODE,
68 ERROR_EXPLANATION,
69 PROCESSING_STATUS,
70 ATTRIBUTE1,
71 ATTRIBUTE2,
72 ATTRIBUTE3,
73 ATTRIBUTE4,
74 ATTRIBUTE5,
75 ATTRIBUTE6,
76 ATTRIBUTE7,
77 ATTRIBUTE8,
78 ATTRIBUTE9,
79 ATTRIBUTE10,
80 ATTRIBUTE11,
81 ATTRIBUTE12,
82 ATTRIBUTE13,
83 ATTRIBUTE14,
84 ATTRIBUTE15,
85 CREATED_BY,
86 CREATION_DATE,
87 LAST_UPDATED_BY,
88 LAST_UPDATE_DATE,
89 LAST_UPDATE_LOGIN,
90 OBJECT_VERSION_NUMBER,
91 CONTEXT
92 ) VALUES (
93 px_TRANSACTION_LINE_ID,
94 decode( p_SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_TYPE_ID),
95 decode( p_SOURCE_TRANSACTION_TABLE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_TABLE),
96 decode( p_SOURCE_TXN_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TXN_HEADER_ID),
97 decode( p_SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_ID),
98 decode( p_CONFIG_SESSION_HDR_ID, FND_API.G_MISS_NUM, NULL, p_CONFIG_SESSION_HDR_ID),
99 decode( p_CONFIG_SESSION_REV_NUM, FND_API.G_MISS_NUM, NULL, p_CONFIG_SESSION_REV_NUM),
100 decode( p_CONFIG_SESSION_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_CONFIG_SESSION_ITEM_ID),
101 decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL, p_CONFIG_VALID_STATUS),
102 decode( p_SOURCE_TRANSACTION_STATUS, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_STATUS),
103 decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, NULL, p_ERROR_CODE),
104 decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, NULL, p_ERROR_EXPLANATION),
105 decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESSING_STATUS),
106 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
107 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
108 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
109 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
110 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
111 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
112 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
113 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
114 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
115 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
116 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
117 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
118 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
119 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
120 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
121 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
122 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
123 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
124 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
125 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
126 decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
127 decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT));
128 End Insert_Row;
129
130 PROCEDURE Update_Row(
131 p_TRANSACTION_LINE_ID NUMBER,
132 p_SOURCE_TRANSACTION_TYPE_ID NUMBER,
133 p_SOURCE_TRANSACTION_TABLE VARCHAR2,
134 p_SOURCE_TXN_HEADER_ID NUMBER,
135 p_SOURCE_TRANSACTION_ID NUMBER,
136 P_CONFIG_SESSION_HDR_ID NUMBER ,
137 P_CONFIG_SESSION_REV_NUM NUMBER ,
138 P_CONFIG_SESSION_ITEM_ID NUMBER ,
139 P_CONFIG_VALID_STATUS VARCHAR2 ,
140 P_SOURCE_TRANSACTION_STATUS VARCHAR2 ,
141 p_ERROR_CODE VARCHAR2,
142 p_ERROR_EXPLANATION VARCHAR2,
143 p_PROCESSING_STATUS VARCHAR2,
144 p_ATTRIBUTE1 VARCHAR2,
145 p_ATTRIBUTE2 VARCHAR2,
146 p_ATTRIBUTE3 VARCHAR2,
147 p_ATTRIBUTE4 VARCHAR2,
148 p_ATTRIBUTE5 VARCHAR2,
149 p_ATTRIBUTE6 VARCHAR2,
150 p_ATTRIBUTE7 VARCHAR2,
151 p_ATTRIBUTE8 VARCHAR2,
152 p_ATTRIBUTE9 VARCHAR2,
153 p_ATTRIBUTE10 VARCHAR2,
154 p_ATTRIBUTE11 VARCHAR2,
155 p_ATTRIBUTE12 VARCHAR2,
156 p_ATTRIBUTE13 VARCHAR2,
157 p_ATTRIBUTE14 VARCHAR2,
158 p_ATTRIBUTE15 VARCHAR2,
159 p_CREATED_BY NUMBER,
160 p_CREATION_DATE DATE,
161 p_LAST_UPDATED_BY NUMBER,
162 p_LAST_UPDATE_DATE DATE,
163 p_LAST_UPDATE_LOGIN NUMBER,
164 p_OBJECT_VERSION_NUMBER NUMBER,
165 p_CONTEXT VARCHAR2)
166
167 IS
168 BEGIN
169 Update CSI_T_TRANSACTION_LINES
170 SET
171 SOURCE_TRANSACTION_TYPE_ID = decode( p_SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, SOURCE_TRANSACTION_ID, p_SOURCE_TRANSACTION_TYPE_ID),
172 SOURCE_TRANSACTION_TABLE = decode( p_SOURCE_TRANSACTION_TABLE, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_TABLE, p_SOURCE_TRANSACTION_TABLE),
173 SOURCE_TXN_HEADER_ID = decode( p_SOURCE_TXN_HEADER_ID,
174 FND_API.G_MISS_NUM, SOURCE_TXN_HEADER_ID, p_SOURCE_TXN_HEADER_ID),
175 SOURCE_TRANSACTION_ID = decode( p_SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, SOURCE_TRANSACTION_ID, p_SOURCE_TRANSACTION_ID),
176 CONFIG_SESSION_HDR_ID = decode( p_CONFIG_SESSION_HDR_ID, FND_API.G_MISS_NUM,CONFIG_SESSION_HDR_ID, p_CONFIG_SESSION_HDR_ID),
177 CONFIG_SESSION_REV_NUM = decode( p_CONFIG_SESSION_REV_NUM, FND_API.G_MISS_NUM,CONFIG_SESSION_REV_NUM , p_CONFIG_SESSION_REV_NUM),
178 CONFIG_SESSION_ITEM_ID = decode( p_CONFIG_SESSION_ITEM_ID, FND_API.G_MISS_NUM,CONFIG_SESSION_ITEM_ID , p_CONFIG_SESSION_ITEM_ID),
179 CONFIG_VALID_STATUS = decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR,CONFIG_VALID_STATUS , p_CONFIG_VALID_STATUS),
180 SOURCE_TRANSACTION_STATUS = decode( p_SOURCE_TRANSACTION_STATUS, FND_API.G_MISS_CHAR,SOURCE_TRANSACTION_STATUS, p_SOURCE_TRANSACTION_STATUS),
181 ERROR_CODE = decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, ERROR_CODE, p_ERROR_CODE),
182 ERROR_EXPLANATION = decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, ERROR_EXPLANATION, p_ERROR_EXPLANATION),
183 PROCESSING_STATUS = decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, PROCESSING_STATUS, p_PROCESSING_STATUS),
184 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
185 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
186 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
187 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
188 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
189 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
190 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
191 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
192 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
193 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
194 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
195 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
196 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
197 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
198 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
199 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
200 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
201 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
202 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
203 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
204 OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
205 CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT)
206 where TRANSACTION_LINE_ID = p_TRANSACTION_LINE_ID;
207
208 If (SQL%NOTFOUND) then
209 RAISE NO_DATA_FOUND;
210 End If;
211 END Update_Row;
212
213 PROCEDURE Delete_Row(
214 p_TRANSACTION_LINE_ID NUMBER)
215 IS
216 BEGIN
217 DELETE FROM CSI_T_TRANSACTION_LINES
218 WHERE TRANSACTION_LINE_ID = p_TRANSACTION_LINE_ID;
219 If (SQL%NOTFOUND) then
220 RAISE NO_DATA_FOUND;
221 End If;
222 END Delete_Row;
223
224 PROCEDURE Lock_Row(
225 p_TRANSACTION_LINE_ID NUMBER,
226 p_SOURCE_TRANSACTION_TYPE_ID NUMBER,
227 p_SOURCE_TRANSACTION_TABLE VARCHAR2,
228 p_SOURCE_TXN_HEADER_ID NUMBER,
229 p_SOURCE_TRANSACTION_ID NUMBER,
230 P_CONFIG_SESSION_HDR_ID NUMBER ,
231 P_CONFIG_SESSION_REV_NUM NUMBER ,
232 P_CONFIG_SESSION_ITEM_ID NUMBER ,
233 P_CONFIG_VALID_STATUS VARCHAR2 ,
234 P_SOURCE_TRANSACTION_STATUS VARCHAR2 ,
235 p_ERROR_CODE VARCHAR2,
236 p_ERROR_EXPLANATION VARCHAR2,
237 p_PROCESSING_STATUS VARCHAR2,
238 p_ATTRIBUTE1 VARCHAR2,
239 p_ATTRIBUTE2 VARCHAR2,
240 p_ATTRIBUTE3 VARCHAR2,
241 p_ATTRIBUTE4 VARCHAR2,
242 p_ATTRIBUTE5 VARCHAR2,
243 p_ATTRIBUTE6 VARCHAR2,
244 p_ATTRIBUTE7 VARCHAR2,
245 p_ATTRIBUTE8 VARCHAR2,
246 p_ATTRIBUTE9 VARCHAR2,
247 p_ATTRIBUTE10 VARCHAR2,
248 p_ATTRIBUTE11 VARCHAR2,
249 p_ATTRIBUTE12 VARCHAR2,
250 p_ATTRIBUTE13 VARCHAR2,
251 p_ATTRIBUTE14 VARCHAR2,
252 p_ATTRIBUTE15 VARCHAR2,
253 p_CREATED_BY NUMBER,
254 p_CREATION_DATE DATE,
255 p_LAST_UPDATED_BY NUMBER,
256 p_LAST_UPDATE_DATE DATE,
257 p_LAST_UPDATE_LOGIN NUMBER,
258 p_OBJECT_VERSION_NUMBER NUMBER,
259 p_CONTEXT VARCHAR2)
260
261 IS
262 CURSOR C IS
263 SELECT *
264 FROM CSI_T_TRANSACTION_LINES
265 WHERE TRANSACTION_LINE_ID = p_TRANSACTION_LINE_ID
266 FOR UPDATE of TRANSACTION_LINE_ID NOWAIT;
267 Recinfo C%ROWTYPE;
268 BEGIN
269 OPEN C;
270 FETCH C INTO Recinfo;
271 If (C%NOTFOUND) then
272 CLOSE C;
273 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
274 APP_EXCEPTION.RAISE_EXCEPTION;
275 End If;
276 CLOSE C;
277 if (
278 ( Recinfo.TRANSACTION_LINE_ID = p_TRANSACTION_LINE_ID)
279 AND ( ( Recinfo.SOURCE_TRANSACTION_TYPE_ID = p_SOURCE_TRANSACTION_TYPE_ID)
280 OR ( ( Recinfo.SOURCE_TRANSACTION_TYPE_ID IS NULL )
281 AND ( p_SOURCE_TRANSACTION_TYPE_ID IS NULL )))
282 AND ( ( Recinfo.SOURCE_TRANSACTION_TABLE = p_SOURCE_TRANSACTION_TABLE)
283 OR ( ( Recinfo.SOURCE_TRANSACTION_TABLE IS NULL )
284 AND ( p_SOURCE_TRANSACTION_TABLE IS NULL )))
285 AND ( ( Recinfo.SOURCE_TXN_HEADER_ID = p_SOURCE_TXN_HEADER_ID)
286 OR ( ( Recinfo.SOURCE_TXN_HEADER_ID IS NULL )
287 AND ( p_SOURCE_TXN_HEADER_ID IS NULL )))
288 AND ( ( Recinfo.SOURCE_TRANSACTION_ID = p_SOURCE_TRANSACTION_ID)
289 OR ( ( Recinfo.SOURCE_TRANSACTION_ID IS NULL )
290 AND ( p_SOURCE_TRANSACTION_ID IS NULL )))
291 AND ( ( Recinfo.CONFIG_SESSION_HDR_ID = p_CONFIG_SESSION_HDR_ID)
292 OR ( ( Recinfo.CONFIG_SESSION_HDR_ID IS NULL )
293 AND ( p_CONFIG_SESSION_HDR_ID IS NULL )))
294 AND ( ( Recinfo.CONFIG_SESSION_REV_NUM = p_CONFIG_SESSION_REV_NUM)
295 OR ( ( Recinfo.CONFIG_SESSION_REV_NUM IS NULL )
296 AND ( p_CONFIG_SESSION_REV_NUM IS NULL )))
297 AND ( ( Recinfo.CONFIG_SESSION_ITEM_ID = p_CONFIG_SESSION_ITEM_ID)
298 OR ( ( Recinfo.CONFIG_SESSION_ITEM_ID IS NULL )
299 AND ( p_CONFIG_SESSION_ITEM_ID IS NULL )))
300 AND ( ( Recinfo.CONFIG_VALID_STATUS = p_CONFIG_VALID_STATUS)
301 OR ( ( Recinfo.CONFIG_VALID_STATUS IS NULL )
302 AND ( p_CONFIG_VALID_STATUS IS NULL )))
303 AND ( ( Recinfo.SOURCE_TRANSACTION_STATUS = p_SOURCE_TRANSACTION_STATUS)
304 OR ( ( Recinfo.SOURCE_TRANSACTION_STATUS IS NULL )
305 AND ( p_SOURCE_TRANSACTION_STATUS IS NULL )))
306 AND ( ( Recinfo.ERROR_CODE = p_ERROR_CODE)
307 OR ( ( Recinfo.ERROR_CODE IS NULL )
308 AND ( p_ERROR_CODE IS NULL )))
309 AND ( ( Recinfo.ERROR_EXPLANATION = p_ERROR_EXPLANATION)
310 OR ( ( Recinfo.ERROR_EXPLANATION IS NULL )
311 AND ( p_ERROR_EXPLANATION IS NULL )))
312 AND ( ( Recinfo.PROCESSING_STATUS = p_PROCESSING_STATUS)
313 OR ( ( Recinfo.PROCESSING_STATUS IS NULL )
314 AND ( p_PROCESSING_STATUS IS NULL )))
315 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
316 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
317 AND ( p_ATTRIBUTE1 IS NULL )))
318 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
319 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
320 AND ( p_ATTRIBUTE2 IS NULL )))
321 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
322 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
323 AND ( p_ATTRIBUTE3 IS NULL )))
324 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
325 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
326 AND ( p_ATTRIBUTE4 IS NULL )))
327 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
328 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
329 AND ( p_ATTRIBUTE5 IS NULL )))
330 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
331 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
332 AND ( p_ATTRIBUTE6 IS NULL )))
333 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
337 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
334 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
335 AND ( p_ATTRIBUTE7 IS NULL )))
336 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
338 AND ( p_ATTRIBUTE8 IS NULL )))
339 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
340 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
341 AND ( p_ATTRIBUTE9 IS NULL )))
342 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
343 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
344 AND ( p_ATTRIBUTE10 IS NULL )))
345 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
346 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
347 AND ( p_ATTRIBUTE11 IS NULL )))
348 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
349 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
350 AND ( p_ATTRIBUTE12 IS NULL )))
351 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
352 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
353 AND ( p_ATTRIBUTE13 IS NULL )))
354 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
355 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
356 AND ( p_ATTRIBUTE14 IS NULL )))
357 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
358 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
359 AND ( p_ATTRIBUTE15 IS NULL )))
360 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
361 OR ( ( Recinfo.CREATED_BY IS NULL )
362 AND ( p_CREATED_BY IS NULL )))
363 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
364 OR ( ( Recinfo.CREATION_DATE IS NULL )
365 AND ( p_CREATION_DATE IS NULL )))
366 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
367 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
368 AND ( p_LAST_UPDATED_BY IS NULL )))
369 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
370 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
371 AND ( p_LAST_UPDATE_DATE IS NULL )))
372 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
373 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
374 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
375 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
376 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
377 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
378 AND ( ( Recinfo.CONTEXT = p_CONTEXT)
379 OR ( ( Recinfo.CONTEXT IS NULL )
380 AND ( p_CONTEXT IS NULL )))
381 ) then
382 return;
383 else
384 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
385 APP_EXCEPTION.RAISE_EXCEPTION;
386 End If;
387 END Lock_Row;
388
389 End CSI_T_TRANSACTION_LINES_PKG;