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