[Home] [Help]
PACKAGE BODY: APPS.CSI_T_PARTY_DETAILS_PKG
Source
1 PACKAGE BODY CSI_T_PARTY_DETAILS_PKG as
2 /* $Header: csittptb.pls 120.1 2005/06/17 01:52:35 appldev $ */
3 -- Package name : CSI_T_PARTY_DETAILS_PKG
4 -- Purpose : Table Handler for csi_t_party_details
5 -- History : brmanesh created 12-MAY-2001
6 -- NOTE :
7
8
9 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_T_PARTY_DETAILS_PKG';
10 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csittptb.pls';
11
12 PROCEDURE Insert_Row(
13 px_TXN_PARTY_DETAIL_ID IN OUT NOCOPY NUMBER,
14 p_TXN_LINE_DETAIL_ID NUMBER,
15 p_PARTY_SOURCE_TABLE VARCHAR2,
16 p_PARTY_SOURCE_ID NUMBER,
17 p_RELATIONSHIP_TYPE_CODE VARCHAR2,
18 p_CONTACT_FLAG VARCHAR2,
19 p_ACTIVE_START_DATE DATE,
20 p_ACTIVE_END_DATE DATE,
21 p_PRESERVE_DETAIL_FLAG VARCHAR2,
22 p_INSTANCE_PARTY_ID NUMBER,
23 p_ATTRIBUTE1 VARCHAR2,
24 p_ATTRIBUTE2 VARCHAR2,
25 p_ATTRIBUTE3 VARCHAR2,
26 p_ATTRIBUTE4 VARCHAR2,
27 p_ATTRIBUTE5 VARCHAR2,
28 p_ATTRIBUTE6 VARCHAR2,
29 p_ATTRIBUTE7 VARCHAR2,
30 p_ATTRIBUTE8 VARCHAR2,
31 p_ATTRIBUTE9 VARCHAR2,
32 p_ATTRIBUTE10 VARCHAR2,
33 p_ATTRIBUTE11 VARCHAR2,
34 p_ATTRIBUTE12 VARCHAR2,
35 p_ATTRIBUTE13 VARCHAR2,
36 p_ATTRIBUTE14 VARCHAR2,
37 p_ATTRIBUTE15 VARCHAR2,
38 p_CREATED_BY NUMBER,
39 p_CREATION_DATE DATE,
40 p_LAST_UPDATED_BY NUMBER,
41 p_LAST_UPDATE_DATE DATE,
42 p_LAST_UPDATE_LOGIN NUMBER,
43 p_OBJECT_VERSION_NUMBER NUMBER,
44 p_CONTEXT VARCHAR2,
45 p_CONTACT_PARTY_ID NUMBER,
46 p_PRIMARY_FLAG VARCHAR2,
47 p_PREFERRED_FLAG VARCHAR2)
48
49 IS
50 CURSOR C2 IS SELECT CSI_T_PARTY_DETAILS_S.nextval FROM sys.dual;
51 BEGIN
52 If (px_TXN_PARTY_DETAIL_ID IS NULL) OR (px_TXN_PARTY_DETAIL_ID = FND_API.G_MISS_NUM) then
53 OPEN C2;
54 FETCH C2 INTO px_TXN_PARTY_DETAIL_ID;
55 CLOSE C2;
56 End If;
57 INSERT INTO CSI_T_PARTY_DETAILS(
58 TXN_PARTY_DETAIL_ID,
59 TXN_LINE_DETAIL_ID,
60 PARTY_SOURCE_TABLE,
61 PARTY_SOURCE_ID,
62 RELATIONSHIP_TYPE_CODE,
63 CONTACT_FLAG,
64 ACTIVE_START_DATE,
65 ACTIVE_END_DATE,
66 PRESERVE_DETAIL_FLAG,
67 INSTANCE_PARTY_ID,
68 ATTRIBUTE1,
69 ATTRIBUTE2,
70 ATTRIBUTE3,
71 ATTRIBUTE4,
72 ATTRIBUTE5,
73 ATTRIBUTE6,
74 ATTRIBUTE7,
75 ATTRIBUTE8,
76 ATTRIBUTE9,
77 ATTRIBUTE10,
78 ATTRIBUTE11,
79 ATTRIBUTE12,
80 ATTRIBUTE13,
81 ATTRIBUTE14,
82 ATTRIBUTE15,
83 CREATED_BY,
84 CREATION_DATE,
85 LAST_UPDATED_BY,
86 LAST_UPDATE_DATE,
87 LAST_UPDATE_LOGIN,
88 OBJECT_VERSION_NUMBER,
89 CONTEXT,
90 CONTACT_PARTY_ID,
91 PRIMARY_FLAG,
92 PREFERRED_FLAG
93 ) VALUES (
94 px_TXN_PARTY_DETAIL_ID,
95 decode( p_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_TXN_LINE_DETAIL_ID),
96 decode( p_PARTY_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, p_PARTY_SOURCE_TABLE),
97 decode( p_PARTY_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_PARTY_SOURCE_ID),
98 decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_RELATIONSHIP_TYPE_CODE),
99 decode( p_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_CONTACT_FLAG),
100 decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
101 decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
102 decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRESERVE_DETAIL_FLAG),
103 decode( p_INSTANCE_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_PARTY_ID),
104 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
105 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
106 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
107 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
108 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
109 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
110 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
111 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
112 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
113 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
114 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
115 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
116 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
117 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
118 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
119 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
120 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
121 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
122 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
123 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
124 decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
125 decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
126 decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_PARTY_ID),
127 decode( p_PRIMARY_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRIMARY_FLAG),
128 decode( p_PREFERRED_FLAG, FND_API.G_MISS_CHAR, NULL, p_PREFERRED_FLAG));
129 End Insert_Row;
130
131 PROCEDURE Update_Row(
132 p_TXN_PARTY_DETAIL_ID NUMBER,
133 p_TXN_LINE_DETAIL_ID NUMBER,
134 p_PARTY_SOURCE_TABLE VARCHAR2,
135 p_PARTY_SOURCE_ID NUMBER,
136 p_RELATIONSHIP_TYPE_CODE VARCHAR2,
137 p_CONTACT_FLAG VARCHAR2,
138 p_ACTIVE_START_DATE DATE,
139 p_ACTIVE_END_DATE DATE,
140 p_PRESERVE_DETAIL_FLAG VARCHAR2,
141 p_INSTANCE_PARTY_ID NUMBER,
142 p_ATTRIBUTE1 VARCHAR2,
143 p_ATTRIBUTE2 VARCHAR2,
144 p_ATTRIBUTE3 VARCHAR2,
145 p_ATTRIBUTE4 VARCHAR2,
146 p_ATTRIBUTE5 VARCHAR2,
147 p_ATTRIBUTE6 VARCHAR2,
148 p_ATTRIBUTE7 VARCHAR2,
149 p_ATTRIBUTE8 VARCHAR2,
150 p_ATTRIBUTE9 VARCHAR2,
151 p_ATTRIBUTE10 VARCHAR2,
152 p_ATTRIBUTE11 VARCHAR2,
153 p_ATTRIBUTE12 VARCHAR2,
154 p_ATTRIBUTE13 VARCHAR2,
155 p_ATTRIBUTE14 VARCHAR2,
156 p_ATTRIBUTE15 VARCHAR2,
157 p_CREATED_BY NUMBER,
158 p_CREATION_DATE DATE,
159 p_LAST_UPDATED_BY NUMBER,
160 p_LAST_UPDATE_DATE DATE,
161 p_LAST_UPDATE_LOGIN NUMBER,
162 p_OBJECT_VERSION_NUMBER NUMBER,
163 p_CONTEXT VARCHAR2,
164 p_CONTACT_PARTY_ID NUMBER,
165 p_PRIMARY_FLAG VARCHAR2,
166 p_PREFERRED_FLAG VARCHAR2)
167
168 IS
169 BEGIN
170 Update CSI_T_PARTY_DETAILS
171 SET
172 TXN_LINE_DETAIL_ID = decode( p_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, TXN_LINE_DETAIL_ID, p_TXN_LINE_DETAIL_ID),
173 PARTY_SOURCE_TABLE = decode( p_PARTY_SOURCE_TABLE, FND_API.G_MISS_CHAR, PARTY_SOURCE_TABLE, p_PARTY_SOURCE_TABLE),
174 PARTY_SOURCE_ID = decode( p_PARTY_SOURCE_ID, FND_API.G_MISS_NUM, PARTY_SOURCE_ID, p_PARTY_SOURCE_ID),
175 RELATIONSHIP_TYPE_CODE = decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, RELATIONSHIP_TYPE_CODE, p_RELATIONSHIP_TYPE_CODE),
176 CONTACT_FLAG = decode( p_CONTACT_FLAG, FND_API.G_MISS_CHAR, CONTACT_FLAG, p_CONTACT_FLAG),
177 ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
178 ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
179 PRESERVE_DETAIL_FLAG = decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, PRESERVE_DETAIL_FLAG, p_PRESERVE_DETAIL_FLAG),
180 INSTANCE_PARTY_ID = decode( p_INSTANCE_PARTY_ID, FND_API.G_MISS_NUM, INSTANCE_PARTY_ID, p_INSTANCE_PARTY_ID),
181 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
182 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
183 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
184 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
185 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
186 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
187 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
188 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
189 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
190 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
191 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
192 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
193 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
194 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
195 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
196 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
197 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
198 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
199 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
200 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
201 OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
202 CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
203 CONTACT_PARTY_ID = decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, CONTACT_PARTY_ID, p_CONTACT_PARTY_ID),
204 PRIMARY_FLAG = decode( p_PRIMARY_FLAG, FND_API.G_MISS_CHAR, PRIMARY_FLAG, p_PRIMARY_FLAG),
205 PREFERRED_FLAG = decode( p_PREFERRED_FLAG, FND_API.G_MISS_CHAR, PREFERRED_FLAG, p_PREFERRED_FLAG)
206 where TXN_PARTY_DETAIL_ID = p_TXN_PARTY_DETAIL_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_TXN_PARTY_DETAIL_ID NUMBER)
215 IS
216 BEGIN
217 DELETE FROM CSI_T_PARTY_DETAILS
218 WHERE TXN_PARTY_DETAIL_ID = p_TXN_PARTY_DETAIL_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_TXN_PARTY_DETAIL_ID NUMBER,
226 p_TXN_LINE_DETAIL_ID NUMBER,
227 p_PARTY_SOURCE_TABLE VARCHAR2,
228 p_PARTY_SOURCE_ID NUMBER,
229 p_RELATIONSHIP_TYPE_CODE VARCHAR2,
230 p_CONTACT_FLAG VARCHAR2,
231 p_ACTIVE_START_DATE DATE,
232 p_ACTIVE_END_DATE DATE,
233 p_PRESERVE_DETAIL_FLAG VARCHAR2,
234 p_INSTANCE_PARTY_ID NUMBER,
235 p_ATTRIBUTE1 VARCHAR2,
236 p_ATTRIBUTE2 VARCHAR2,
237 p_ATTRIBUTE3 VARCHAR2,
238 p_ATTRIBUTE4 VARCHAR2,
239 p_ATTRIBUTE5 VARCHAR2,
240 p_ATTRIBUTE6 VARCHAR2,
241 p_ATTRIBUTE7 VARCHAR2,
242 p_ATTRIBUTE8 VARCHAR2,
243 p_ATTRIBUTE9 VARCHAR2,
244 p_ATTRIBUTE10 VARCHAR2,
245 p_ATTRIBUTE11 VARCHAR2,
246 p_ATTRIBUTE12 VARCHAR2,
247 p_ATTRIBUTE13 VARCHAR2,
248 p_ATTRIBUTE14 VARCHAR2,
249 p_ATTRIBUTE15 VARCHAR2,
250 p_CREATED_BY NUMBER,
251 p_CREATION_DATE DATE,
252 p_LAST_UPDATED_BY NUMBER,
253 p_LAST_UPDATE_DATE DATE,
254 p_LAST_UPDATE_LOGIN NUMBER,
255 p_OBJECT_VERSION_NUMBER NUMBER,
256 p_CONTEXT VARCHAR2,
257 p_CONTACT_PARTY_ID NUMBER,
258 p_PRIMARY_FLAG VARCHAR2,
259 p_PREFERRED_FLAG VARCHAR2)
260
261 IS
262 CURSOR C IS
263 SELECT *
264 FROM CSI_T_PARTY_DETAILS
265 WHERE TXN_PARTY_DETAIL_ID = p_TXN_PARTY_DETAIL_ID
266 FOR UPDATE of TXN_PARTY_DETAIL_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.TXN_PARTY_DETAIL_ID = p_TXN_PARTY_DETAIL_ID)
279 AND ( ( Recinfo.TXN_LINE_DETAIL_ID = p_TXN_LINE_DETAIL_ID)
280 OR ( ( Recinfo.TXN_LINE_DETAIL_ID IS NULL )
281 AND ( p_TXN_LINE_DETAIL_ID IS NULL )))
282 AND ( ( Recinfo.PARTY_SOURCE_TABLE = p_PARTY_SOURCE_TABLE)
283 OR ( ( Recinfo.PARTY_SOURCE_TABLE IS NULL )
284 AND ( p_PARTY_SOURCE_TABLE IS NULL )))
285 AND ( ( Recinfo.PARTY_SOURCE_ID = p_PARTY_SOURCE_ID)
286 OR ( ( Recinfo.PARTY_SOURCE_ID IS NULL )
287 AND ( p_PARTY_SOURCE_ID IS NULL )))
288 AND ( ( Recinfo.RELATIONSHIP_TYPE_CODE = p_RELATIONSHIP_TYPE_CODE)
289 OR ( ( Recinfo.RELATIONSHIP_TYPE_CODE IS NULL )
290 AND ( p_RELATIONSHIP_TYPE_CODE IS NULL )))
291 AND ( ( Recinfo.CONTACT_FLAG = p_CONTACT_FLAG)
292 OR ( ( Recinfo.CONTACT_FLAG IS NULL )
293 AND ( p_CONTACT_FLAG IS NULL )))
294 AND ( ( Recinfo.ACTIVE_START_DATE = p_ACTIVE_START_DATE)
295 OR ( ( Recinfo.ACTIVE_START_DATE IS NULL )
296 AND ( p_ACTIVE_START_DATE IS NULL )))
297 AND ( ( Recinfo.ACTIVE_END_DATE = p_ACTIVE_END_DATE)
298 OR ( ( Recinfo.ACTIVE_END_DATE IS NULL )
299 AND ( p_ACTIVE_END_DATE IS NULL )))
300 AND ( ( Recinfo.PRESERVE_DETAIL_FLAG = p_PRESERVE_DETAIL_FLAG)
301 OR ( ( Recinfo.PRESERVE_DETAIL_FLAG IS NULL )
302 AND ( p_PRESERVE_DETAIL_FLAG IS NULL )))
303 AND ( ( Recinfo.INSTANCE_PARTY_ID = p_INSTANCE_PARTY_ID)
304 OR ( ( Recinfo.INSTANCE_PARTY_ID IS NULL )
305 AND ( p_INSTANCE_PARTY_ID IS NULL )))
306 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
307 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
308 AND ( p_ATTRIBUTE1 IS NULL )))
309 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
310 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
311 AND ( p_ATTRIBUTE2 IS NULL )))
312 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
313 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
314 AND ( p_ATTRIBUTE3 IS NULL )))
315 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
316 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
317 AND ( p_ATTRIBUTE4 IS NULL )))
318 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
319 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
320 AND ( p_ATTRIBUTE5 IS NULL )))
321 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
322 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
323 AND ( p_ATTRIBUTE6 IS NULL )))
327 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
324 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
325 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
326 AND ( p_ATTRIBUTE7 IS NULL )))
328 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
329 AND ( p_ATTRIBUTE8 IS NULL )))
330 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
331 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
332 AND ( p_ATTRIBUTE9 IS NULL )))
333 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
334 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
335 AND ( p_ATTRIBUTE10 IS NULL )))
336 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
337 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
338 AND ( p_ATTRIBUTE11 IS NULL )))
339 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
340 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
341 AND ( p_ATTRIBUTE12 IS NULL )))
342 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
343 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
344 AND ( p_ATTRIBUTE13 IS NULL )))
345 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
346 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
347 AND ( p_ATTRIBUTE14 IS NULL )))
348 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
349 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
350 AND ( p_ATTRIBUTE15 IS NULL )))
351 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
352 OR ( ( Recinfo.CREATED_BY IS NULL )
353 AND ( p_CREATED_BY IS NULL )))
354 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
355 OR ( ( Recinfo.CREATION_DATE IS NULL )
356 AND ( p_CREATION_DATE IS NULL )))
357 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
358 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
359 AND ( p_LAST_UPDATED_BY IS NULL )))
360 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
361 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
362 AND ( p_LAST_UPDATE_DATE IS NULL )))
363 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
364 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
365 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
366 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
367 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
368 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
369 AND ( ( Recinfo.CONTEXT = p_CONTEXT)
370 OR ( ( Recinfo.CONTEXT IS NULL )
371 AND ( p_CONTEXT IS NULL )))
372 AND ( ( Recinfo.CONTACT_PARTY_ID = p_CONTACT_PARTY_ID)
373 OR ( ( Recinfo.CONTACT_PARTY_ID IS NULL )
374 AND ( p_CONTACT_PARTY_ID IS NULL )))
375 AND ( ( Recinfo.PRIMARY_FLAG = p_PRIMARY_FLAG)
376 OR ( ( Recinfo.PRIMARY_FLAG IS NULL )
377 AND ( p_PRIMARY_FLAG IS NULL )))
378 AND ( ( Recinfo.PREFERRED_FLAG = p_PREFERRED_FLAG)
379 OR ( ( Recinfo.PREFERRED_FLAG IS NULL )
380 AND ( p_PREFERRED_FLAG 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_PARTY_DETAILS_PKG;