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