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