[Home] [Help]
PACKAGE BODY: APPS.IEX_WRITEOFFS_PKG
Source
1 PACKAGE BODY IEX_WRITEOFFS_PKG as
2 /* $Header: iextwrob.pls 120.1 2007/10/31 13:00:26 ehuh ship $ */
3 -- Start of Comments
4 -- Package name : IEX_WRITEOFFS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_WRITEOFFS_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'iextwrob.pls';
13
14 --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
15 PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
16
17 PROCEDURE Insert_Row(
18 X_ROWID IN out NOCOPY VARCHAR2,
19 p_WRITEOFF_ID IN NUMBER,
20 p_PARTY_ID IN NUMBER,
21 p_DELINQUENCY_ID IN NUMBER,
22 p_CAS_ID IN NUMBER,
23 p_CUST_ACCOUNT_ID IN NUMBER,
24 p_DISPOSITION_CODE IN VARCHAR2,
25 p_OBJECT_ID IN NUMBER,
26 p_OBJECT_CODE IN VARCHAR2,
27 p_WRITEOFF_TYPE IN VARCHAR2,
28 p_ACTIVE_FLAG IN VARCHAR2,
29 p_OBJECT_VERSION_NUMBER IN NUMBER,
30 p_WRITEOFF_REASON IN VARCHAR2,
31 p_WRITEOFF_AMOUNT IN NUMBER,
32 p_WRITEOFF_CURRENCY_CODE IN VARCHAR2,
33 p_WRITEOFF_DATE IN DATE,
34 p_WRITEOFF_REQUEST_DATE IN DATE,
35 p_WRITEOFF_PROCESS IN VARCHAR2,
36 p_WRITEOFF_SCORE IN VARCHAR2,
37 p_BAD_DEBT_REASON IN VARCHAR2,
38 p_LEASING_CODE IN VARCHAR2,
39 p_REPOSSES_SCH_DATE IN DATE,
40 p_REPOSSES_COMP_DATE IN DATE,
41 p_CREDIT_HOLD_YN IN VARCHAR2,
42 p_APPROVER_ID IN VARCHAR2,
43 p_EXTERNAL_AGENT_ID IN VARCHAR2,
44 p_PROCEDURE_CODE IN VARCHAR2,
45 p_CHECKLIST_CODE IN VARCHAR2,
46 p_REQUEST_ID IN NUMBER,
47 p_PROGRAM_APPLICATION_ID IN NUMBER,
48 p_PROGRAM_ID IN NUMBER,
49 p_PROGRAM_UPDATE_DATE IN DATE,
50 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
51 p_ATTRIBUTE1 IN VARCHAR2,
52 p_ATTRIBUTE2 IN VARCHAR2,
53 p_ATTRIBUTE3 IN VARCHAR2,
54 p_ATTRIBUTE4 IN VARCHAR2,
55 p_ATTRIBUTE5 IN VARCHAR2,
56 p_ATTRIBUTE6 IN VARCHAR2,
57 p_ATTRIBUTE7 IN VARCHAR2,
58 p_ATTRIBUTE8 IN VARCHAR2,
59 p_ATTRIBUTE9 IN VARCHAR2,
60 p_ATTRIBUTE10 IN VARCHAR2,
61 p_ATTRIBUTE11 IN VARCHAR2,
62 p_ATTRIBUTE12 IN VARCHAR2,
63 p_ATTRIBUTE13 IN VARCHAR2,
64 p_ATTRIBUTE14 IN VARCHAR2,
65 p_ATTRIBUTE15 IN VARCHAR2,
66 p_CREATED_BY IN VARCHAR2,
67 p_CREATION_DATE IN DATE,
68 p_LAST_UPDATED_BY IN NUMBER,
69 p_LAST_UPDATE_DATE IN DATE,
70 p_LAST_UPDATE_LOGIN IN NUMBER
71 ,p_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2
72 ,p_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2
73 ,p_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2
74 ,p_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2
75 ,p_SUGGESTION_APPROVED_FLAG IN VARCHAR2
76 ,p_CUSTOMER_SITE_USE_ID IN NUMBER
77 ,p_ORG_ID IN NUMBER
78 ,p_CONTRACT_ID IN NUMBER
79 ,p_CONTRACT_NUMBER IN VARCHAR2
80 )
81
82 IS
83
84 cursor C is select ROWID from IEX_WRITEOFFS
85 where writeoff_id = p_writeoff_id ;
86
87 BEGIN
88 -- IF PG_DEBUG < 10 THEN
89 IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
90 IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.INSERT_ROW ******** ');
91 END IF;
92
93
94 INSERT INTO IEX_WRITEOFFS(
95 WRITEOFF_ID,
96 PARTY_ID,
97 DELINQUENCY_ID ,
98 CAS_ID,
99 CUST_ACCOUNT_ID ,
100 DISPOSITION_CODE ,
101 OBJECT_ID,
102 OBJECT_CODE,
103 WRITEOFF_TYPE,
104 ACTIVE_FLAG,
105 OBJECT_VERSION_NUMBER,
106 WRITEOFF_REASON,
107 WRITEOFF_AMOUNT,
108 WRITEOFF_CURRENCY_CODE,
109 WRITEOFF_DATE,
110 WRITEOFF_REQUEST_DATE,
111 WRITEOFF_PROCESS,
112 WRITEOFF_SCORE,
113 BAD_DEBT_REASON,
114 LEASING_CODE,
115 REPOSSES_SCH_DATE,
116 REPOSSES_COMP_DATE,
117 CREDIT_HOLD_YN,
118 APPROVER_ID,
119 EXTERNAL_AGENT_ID,
120 PROCEDURE_CODE,
121 CHECKLIST_CODE,
122 REQUEST_ID,
123 PROGRAM_APPLICATION_ID,
124 PROGRAM_ID,
125 PROGRAM_UPDATE_DATE,
126 ATTRIBUTE_CATEGORY,
127 ATTRIBUTE1,
128 ATTRIBUTE2,
129 ATTRIBUTE3,
130 ATTRIBUTE4,
131 ATTRIBUTE5,
132 ATTRIBUTE6,
133 ATTRIBUTE7,
134 ATTRIBUTE8,
135 ATTRIBUTE9,
136 ATTRIBUTE10,
137 ATTRIBUTE11,
138 ATTRIBUTE12,
139 ATTRIBUTE13,
140 ATTRIBUTE14,
141 ATTRIBUTE15,
142 CREATED_BY,
143 CREATION_DATE,
144 LAST_UPDATED_BY,
145 LAST_UPDATE_DATE,
146 LAST_UPDATE_LOGIN
147 ,CREDIT_HOLD_REQUEST_FLAG
148 ,CREDIT_HOLD_APPROVED_FLAG
149 ,SERVICE_HOLD_REQUEST_FLAG
150 ,SERVICE_HOLD_APPROVED_FLAG
151 ,SUGGESTION_APPROVED_FLAG
152 ,CUSTOMER_SITE_USE_ID
153 ,ORG_ID
154 ,CONTRACT_ID
155 ,CONTRACT_NUMBER
156 ) VALUES (
157 p_WRITEOFF_ID,
158 p_PARTY_ID,
159 decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, NULL, p_DELINQUENCY_ID),
160 decode( p_CAS_ID, FND_API.G_MISS_NUM, NULL, p_CAS_ID),
161 decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
162 decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, p_DISPOSITION_CODE),
163 decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),
164 decode( p_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_OBJECT_CODE),
165 p_WRITEOFF_TYPE,
166 p_ACTIVE_FLAG,
167 p_OBJECT_VERSION_NUMBER,
168 p_WRITEOFF_REASON,
169 decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WRITEOFF_AMOUNT),
170 decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_CURRENCY_CODE),
171 decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_DATE),
172 decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_WRITEOFF_REQUEST_DATE),
173 decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_PROCESS),
174 decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, NULL, p_WRITEOFF_SCORE),
175 decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, NULL, p_BAD_DEBT_REASON),
176 decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, NULL, p_LEASING_CODE),
177 decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_SCH_DATE),
178 decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REPOSSES_COMP_DATE),
179 decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_YN),
180 decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, NULL, p_APPROVER_ID),
181 decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_AGENT_ID),
182 decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, NULL, p_PROCEDURE_CODE),
183 decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, NULL, p_CHECKLIST_CODE),
184 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
185 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
186 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
187 decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
188 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
189 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
190 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
191 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
192 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
193 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
194 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
195 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
196 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
197 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
198 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
199 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
200 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
201 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
202 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
203 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
204 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
205 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
206 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
207 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
208 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
209 ,decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_REQUEST_FLAG)
210 ,decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREDIT_HOLD_APPROVED_FLAG)
211 ,decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_REQUEST_FLAG)
212 ,decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_HOLD_APPROVED_FLAG)
213 ,decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, NULL, p_SUGGESTION_APPROVED_FLAG)
214 ,decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_SITE_USE_ID)
215 ,decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID)
216 ,decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTRACT_ID)
217 ,decode( p_CONTRACT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_CONTRACT_NUMBER));
218
219
220 open c;
221 fetch c into X_ROWID;
222 -- IF PG_DEBUG < 10 THEN
223 IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
224 IEX_DEBUG_PUB.LogMessage ('Insert_Row: ' || 'Value of ROWID = '||X_ROWID);
225 END IF;
226 if (c%notfound) then
227 close c;
228 raise no_data_found;
229 end if;
230 close c;
231 -- IF PG_DEBUG < 10 THEN
232 IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
233 IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFFS_PKG.INSERT_ROW ******** ');
234 END IF;
235
236 End Insert_Row;
237
238 PROCEDURE Update_Row(
239 p_WRITEOFF_ID IN NUMBER,
240 p_PARTY_ID IN NUMBER,
241 p_DELINQUENCY_ID IN NUMBER,
242 p_CAS_ID IN NUMBER,
243 p_CUST_ACCOUNT_ID IN NUMBER,
244 p_DISPOSITION_CODE IN VARCHAR2,
245 p_OBJECT_ID IN NUMBER,
246 p_OBJECT_CODE IN VARCHAR2,
247 p_WRITEOFF_TYPE IN VARCHAR2,
248 p_ACTIVE_FLAG IN VARCHAR2,
249 p_OBJECT_VERSION_NUMBER IN NUMBER,
250 p_WRITEOFF_REASON IN VARCHAR2,
251 p_WRITEOFF_AMOUNT IN NUMBER,
252 p_WRITEOFF_CURRENCY_CODE IN VARCHAR2,
253 p_WRITEOFF_DATE IN DATE,
254 p_WRITEOFF_REQUEST_DATE IN DATE,
255 p_WRITEOFF_PROCESS IN VARCHAR2,
256 p_WRITEOFF_SCORE IN VARCHAR2,
257 p_BAD_DEBT_REASON IN VARCHAR2,
258 p_LEASING_CODE IN VARCHAR2,
259 p_REPOSSES_SCH_DATE IN DATE,
260 p_REPOSSES_COMP_DATE IN DATE,
261 p_CREDIT_HOLD_YN IN VARCHAR2,
262 p_APPROVER_ID IN VARCHAR2,
263 p_EXTERNAL_AGENT_ID IN VARCHAR2,
264 p_PROCEDURE_CODE IN VARCHAR2,
265 p_CHECKLIST_CODE IN VARCHAR2,
266 p_REQUEST_ID IN NUMBER,
267 p_PROGRAM_APPLICATION_ID IN NUMBER,
268 p_PROGRAM_ID IN NUMBER,
269 p_PROGRAM_UPDATE_DATE IN DATE,
270 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
271 p_ATTRIBUTE1 IN VARCHAR2,
272 p_ATTRIBUTE2 IN VARCHAR2,
273 p_ATTRIBUTE3 IN VARCHAR2,
274 p_ATTRIBUTE4 IN VARCHAR2,
275 p_ATTRIBUTE5 IN VARCHAR2,
276 p_ATTRIBUTE6 IN VARCHAR2,
277 p_ATTRIBUTE7 IN VARCHAR2,
278 p_ATTRIBUTE8 IN VARCHAR2,
279 p_ATTRIBUTE9 IN VARCHAR2,
280 p_ATTRIBUTE10 IN VARCHAR2,
281 p_ATTRIBUTE11 IN VARCHAR2,
282 p_ATTRIBUTE12 IN VARCHAR2,
283 p_ATTRIBUTE13 IN VARCHAR2,
284 p_ATTRIBUTE14 IN VARCHAR2,
285 p_ATTRIBUTE15 IN VARCHAR2,
286 p_LAST_UPDATED_BY IN NUMBER,
287 p_LAST_UPDATE_DATE IN DATE,
288 p_LAST_UPDATE_LOGIN IN NUMBER
289 ,p_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2
290 ,p_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2
291 ,p_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2
292 ,p_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2
293 ,p_SUGGESTION_APPROVED_FLAG IN VARCHAR2
294 ,p_CUSTOMER_SITE_USE_ID IN NUMBER
295 ,p_ORG_ID IN NUMBER
296 ,p_CONTRACT_ID IN NUMBER
297 ,p_CONTRACT_NUMBER IN VARCHAR2)
298
299
300 IS
301 BEGIN
302 -- IF PG_DEBUG < 10 THEN
303 IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
304 IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.UPDATE_ROW ******** ');
305 END IF;
306 Update IEX_WRITEOFFS
307 SET
308 PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
309 DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID),
310 CAS_ID = decode( p_CAS_ID, FND_API.G_MISS_NUM, CAS_ID, p_CAS_ID),
311 CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM,
312 CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
313 DISPOSITION_CODE = decode( p_DISPOSITION_CODE, FND_API.G_MISS_CHAR,
314 DISPOSITION_CODE, p_DISPOSITION_CODE),
315 OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
316 OBJECT_CODE = decode( p_OBJECT_CODE, FND_API.G_MISS_CHAR, OBJECT_CODE, p_OBJECT_CODE),
317 WRITEOFF_TYPE = decode( p_WRITEOFF_TYPE, FND_API.G_MISS_CHAR, WRITEOFF_TYPE, p_WRITEOFF_TYPE),
318 ACTIVE_FLAG = decode( p_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
319 OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
320 OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
321 WRITEOFF_REASON = decode( p_WRITEOFF_REASON, FND_API.G_MISS_CHAR, WRITEOFF_REASON, p_WRITEOFF_REASON),
322 WRITEOFF_AMOUNT = decode( p_WRITEOFF_AMOUNT, FND_API.G_MISS_NUM, WRITEOFF_AMOUNT, p_WRITEOFF_AMOUNT),
323 WRITEOFF_CURRENCY_CODE = decode( p_WRITEOFF_CURRENCY_CODE, FND_API.G_MISS_CHAR, WRITEOFF_CURRENCY_CODE, p_WRITEOFF_CURRENCY_CODE),
324 WRITEOFF_DATE = decode( p_WRITEOFF_DATE, FND_API.G_MISS_DATE, WRITEOFF_DATE, p_WRITEOFF_DATE),
325 WRITEOFF_REQUEST_DATE = decode( p_WRITEOFF_REQUEST_DATE, FND_API.G_MISS_DATE, WRITEOFF_REQUEST_DATE, p_WRITEOFF_REQUEST_DATE),
326 WRITEOFF_PROCESS = decode( p_WRITEOFF_PROCESS, FND_API.G_MISS_CHAR, WRITEOFF_PROCESS, p_WRITEOFF_PROCESS),
330 REPOSSES_SCH_DATE = decode( p_REPOSSES_SCH_DATE, FND_API.G_MISS_DATE, REPOSSES_SCH_DATE, p_REPOSSES_SCH_DATE),
327 WRITEOFF_SCORE = decode( p_WRITEOFF_SCORE, FND_API.G_MISS_CHAR, WRITEOFF_SCORE, p_WRITEOFF_SCORE),
328 BAD_DEBT_REASON = decode( p_BAD_DEBT_REASON, FND_API.G_MISS_CHAR, BAD_DEBT_REASON, p_BAD_DEBT_REASON),
329 LEASING_CODE = decode( p_LEASING_CODE, FND_API.G_MISS_CHAR, LEASING_CODE, p_LEASING_CODE),
331 REPOSSES_COMP_DATE = decode( p_REPOSSES_COMP_DATE, FND_API.G_MISS_DATE, REPOSSES_COMP_DATE, p_REPOSSES_COMP_DATE),
332 CREDIT_HOLD_YN = decode( p_CREDIT_HOLD_YN, FND_API.G_MISS_CHAR, CREDIT_HOLD_YN, p_CREDIT_HOLD_YN),
333 APPROVER_ID = decode( p_APPROVER_ID, FND_API.G_MISS_CHAR, APPROVER_ID, p_APPROVER_ID),
334 EXTERNAL_AGENT_ID = decode( p_EXTERNAL_AGENT_ID, FND_API.G_MISS_CHAR, EXTERNAL_AGENT_ID, p_EXTERNAL_AGENT_ID),
335 PROCEDURE_CODE = decode( p_PROCEDURE_CODE, FND_API.G_MISS_CHAR, PROCEDURE_CODE, p_PROCEDURE_CODE),
336 CHECKLIST_CODE = decode( p_CHECKLIST_CODE, FND_API.G_MISS_CHAR, CHECKLIST_CODE, p_CHECKLIST_CODE),
337 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
338 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
339 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
340 PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
341 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
342 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
343 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
344 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
345 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
346 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
347 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
348 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
349 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
350 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
351 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
352 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
353 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
354 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
355 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
356 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
357 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
358 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
359 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
360 ,CREDIT_HOLD_REQUEST_FLAG = decode( p_CREDIT_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_REQUEST_FLAG, p_CREDIT_HOLD_REQUEST_FLAG)
361 ,CREDIT_HOLD_APPROVED_FLAG = decode( p_CREDIT_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, CREDIT_HOLD_APPROVED_FLAG, p_CREDIT_HOLD_APPROVED_FLAG)
362 ,SERVICE_HOLD_REQUEST_FLAG = decode( p_SERVICE_HOLD_REQUEST_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_REQUEST_FLAG, p_SERVICE_HOLD_REQUEST_FLAG)
363 ,SERVICE_HOLD_APPROVED_FLAG = decode( p_SERVICE_HOLD_APPROVED_FLAG, FND_API.G_MISS_CHAR, SERVICE_HOLD_APPROVED_FLAG, p_SERVICE_HOLD_APPROVED_FLAG)
364 ,SUGGESTION_APPROVED_FLAG = decode( p_SUGGESTION_APPROVED_FLAG, FND_API.G_MISS_CHAR, SUGGESTION_APPROVED_FLAG, p_SUGGESTION_APPROVED_FLAG)
365 ,CUSTOMER_SITE_USE_ID = decode( p_CUSTOMER_SITE_USE_ID, FND_API.G_MISS_NUM, CUSTOMER_SITE_USE_ID, p_CUSTOMER_SITE_USE_ID)
366 ,ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)
367 ,CONTRACT_ID = decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, CONTRACT_ID, p_CONTRACT_ID)
368 ,CONTRACT_NUMBER = decode( p_CONTRACT_NUMBER, FND_API.G_MISS_CHAR, CONTRACT_NUMBER, p_CONTRACT_NUMBER)
369 where WRITEOFF_ID = p_WRITEOFF_ID;
370
371 If (SQL%NOTFOUND) then
372 RAISE NO_DATA_FOUND;
373 End If;
374 -- IF PG_DEBUG < 10 THEN
375 IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
376 IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFFS_PKG.UPDATE_ROW ******** ');
377 END IF;
378 END Update_Row;
379
380 PROCEDURE Delete_Row(
381 p_WRITEOFF_ID NUMBER)
382 IS
383 BEGIN
384 DELETE FROM IEX_WRITEOFFS
385 WHERE WRITEOFF_ID = p_WRITEOFF_ID;
386 If (SQL%NOTFOUND) then
387 RAISE NO_DATA_FOUND;
388 End If;
389 END Delete_Row;
390
391
392 PROCEDURE LOCK_ROW (
393 p_writeoff_id in NUMBER,
394 p_OBJECT_VERSION_NUMBER in NUMBER
395 ) is
396 cursor c is select OBJECT_VERSION_NUMBER
397 from IEX_WRITEOFFS
398 where writeoff_id = p_writeoff_id
399 and OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER
400 for update of writeoff_id nowait;
401 recinfo c%rowtype;
402
403 begin
404 -- IF PG_DEBUG < 10 THEN
405 IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
409 fetch c into recinfo;
406 IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.LOCK_ROW ******** ');
407 END IF;
408 open c;
410 if (c%notfound) then
411 close c;
412 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
413 app_exception.raise_exception;
414 end if;
415
416 close c;
417
418 if recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER then
419 null;
420 else
421 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
422 app_exception.raise_exception;
423 end if;
424 --IF PG_DEBUG < 10 THEN
425 IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
426 IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFFS_PKG.LOCK_ROW ******** ');
427 END IF;
428 end LOCK_ROW;
429
430
431 /*
432 PROCEDURE Lock_Row(
433 p_WRITEOFF_ID IN NUMBER,
434 p_PARTY_ID IN NUMBER,
435 p_DELINQUENCY_ID IN NUMBER,
436 p_CAS_ID IN NUMBER,
437 p_CUST_ACCOUNT_ID IN NUMBER,
438 p_DISPOSITION_CODE IN VARCHAR2,
439 p_OBJECT_ID IN NUMBER,
440 p_OBJECT_CODE IN VARCHAR2,
441 p_WRITEOFF_TYPE IN VARCHAR2,
442 p_ACTIVE_FLAG IN VARCHAR2,
443 p_OBJECT_VERSION_NUMBER IN NUMBER,
444 p_WRITEOFF_REASON IN VARCHAR2,
445 p_WRITEOFF_AMOUNT IN NUMBER,
446 p_WRITEOFF_CURRENCY_CODE IN VARCHAR2,
447 p_WRITEOFF_DATE IN DATE,
448 p_WRITEOFF_REQUEST_DATE IN DATE,
449 p_WRITEOFF_PROCESS IN VARCHAR2,
450 p_WRITEOFF_SCORE IN VARCHAR2,
451 p_BAD_DEBT_REASON IN VARCHAR2,
452 p_LEASING_CODE IN VARCHAR2,
453 p_REPOSSES_SCH_DATE IN DATE,
454 p_REPOSSES_COMP_DATE IN DATE,
455 p_CREDIT_HOLD_YN IN VARCHAR2,
456 p_APPROVER_ID IN VARCHAR2,
457 p_EXTERNAL_AGENT_ID IN VARCHAR2,
458 p_PROCEDURE_CODE IN VARCHAR2,
459 p_CHECKLIST_CODE IN VARCHAR2,
460 p_REQUEST_ID IN NUMBER,
461 p_PROGRAM_APPLICATION_ID IN NUMBER,
462 p_PROGRAM_ID IN NUMBER,
463 p_PROGRAM_UPDATE_DATE IN DATE,
464 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
465 p_ATTRIBUTE1 IN VARCHAR2,
466 p_ATTRIBUTE2 IN VARCHAR2,
467 p_ATTRIBUTE3 IN VARCHAR2,
468 p_ATTRIBUTE4 IN VARCHAR2,
469 p_ATTRIBUTE5 IN VARCHAR2,
470 p_ATTRIBUTE6 IN VARCHAR2,
471 p_ATTRIBUTE7 IN VARCHAR2,
472 p_ATTRIBUTE8 IN VARCHAR2,
473 p_ATTRIBUTE9 IN VARCHAR2,
474 p_ATTRIBUTE10 IN VARCHAR2,
475 p_ATTRIBUTE11 IN VARCHAR2,
476 p_ATTRIBUTE12 IN VARCHAR2,
477 p_ATTRIBUTE13 IN VARCHAR2,
478 p_ATTRIBUTE14 IN VARCHAR2,
479 p_ATTRIBUTE15 IN VARCHAR2,
480 p_CREATED_BY IN VARCHAR2,
481 p_CREATION_DATE IN DATE,
482 p_LAST_UPDATED_BY IN NUMBER,
483 p_LAST_UPDATE_DATE IN DATE,
484 p_LAST_UPDATE_LOGIN IN NUMBER
485 ,p_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2
486 ,p_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2
487 ,p_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2
488 ,p_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2
489 ,p_SUGGESTION_APPROVED_FLAG IN VARCHAR2)
490
491
492 IS
493 CURSOR C IS
494 SELECT *
495 FROM IEX_WRITEOFFS
496 WHERE WRITEOFF_ID = p_WRITEOFF_ID
497 FOR UPDATE of WRITEOFF_ID NOWAIT;
498 Recinfo C%ROWTYPE;
499 BEGIN
500 OPEN C;
501 FETCH C INTO Recinfo;
502 If (C%NOTFOUND) then
503 CLOSE C;
504 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
505 APP_EXCEPTION.RAISE_EXCEPTION;
506 End If;
507 CLOSE C;
508 if (
509 ( Recinfo.WRITEOFF_ID = p_WRITEOFF_ID)
510 AND ( ( Recinfo.PARTY_ID = p_PARTY_ID)
511 OR ( ( Recinfo.PARTY_ID IS NULL )
512 AND ( p_PARTY_ID IS NULL )))
513 AND ( ( Recinfo.DELINQUENCY_ID = p_DELINQUENCY_ID)
514 OR ( ( Recinfo.DELINQUENCY_ID IS NULL )
515 AND ( p_DELINQUENCY_ID IS NULL )))
516 AND ( ( Recinfo.CAS_ID = p_CAS_ID)
517 OR ( ( Recinfo.CAS_ID IS NULL )
518 AND ( p_CAS_ID IS NULL )))
519 AND ( ( Recinfo.OBJECT_ID = p_OBJECT_ID)
520 OR ( ( Recinfo.OBJECT_ID IS NULL )
521 AND ( p_OBJECT_ID IS NULL )))
522 AND ( ( Recinfo.OBJECT_CODE = p_OBJECT_CODE)
523 OR ( ( Recinfo.OBJECT_CODE IS NULL )
524 AND ( p_OBJECT_CODE IS NULL )))
525 AND ( ( Recinfo.WRITEOFF_TYPE = p_WRITEOFF_TYPE)
526 OR ( ( Recinfo.WRITEOFF_TYPE IS NULL )
527 AND ( p_WRITEOFF_TYPE IS NULL )))
528 AND ( ( Recinfo.ACTIVE_FLAG = p_ACTIVE_FLAG)
529 OR ( ( Recinfo.ACTIVE_FLAG IS NULL )
530 AND ( p_ACTIVE_FLAG IS NULL )))
531 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
535 OR ( ( Recinfo.WRITEOFF_REASON IS NULL )
532 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
533 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
534 AND ( ( Recinfo.WRITEOFF_REASON = p_WRITEOFF_REASON)
536 AND ( p_WRITEOFF_REASON IS NULL )))
537 AND ( ( Recinfo.WRITEOFF_AMOUNT = p_WRITEOFF_AMOUNT)
538 OR ( ( Recinfo.WRITEOFF_AMOUNT IS NULL )
539 AND ( p_WRITEOFF_AMOUNT IS NULL )))
540 AND ( ( Recinfo.WRITEOFF_CURRENCY_CODE = p_WRITEOFF_CURRENCY_CODE)
541 OR ( ( Recinfo.WRITEOFF_CURRENCY_CODE IS NULL )
542 AND ( p_WRITEOFF_CURRENCY_CODE IS NULL )))
543 AND ( ( Recinfo.WRITEOFF_DATE = p_WRITEOFF_DATE)
544 OR ( ( Recinfo.WRITEOFF_DATE IS NULL )
545 AND ( p_WRITEOFF_DATE IS NULL )))
546 AND ( ( Recinfo.WRITEOFF_REQUEST_DATE = p_WRITEOFF_REQUEST_DATE)
547 OR ( ( Recinfo.WRITEOFF_REQUEST_DATE IS NULL )
548 AND ( p_WRITEOFF_REQUEST_DATE IS NULL )))
549 AND ( ( Recinfo.WRITEOFF_PROCESS = p_WRITEOFF_PROCESS)
550 OR ( ( Recinfo.WRITEOFF_PROCESS IS NULL )
551 AND ( p_WRITEOFF_PROCESS IS NULL )))
552 AND ( ( Recinfo.WRITEOFF_SCORE = p_WRITEOFF_SCORE)
553 OR ( ( Recinfo.WRITEOFF_SCORE IS NULL )
554 AND ( p_WRITEOFF_SCORE IS NULL )))
555 AND ( ( Recinfo.BAD_DEBT_REASON = p_BAD_DEBT_REASON)
556 OR ( ( Recinfo.BAD_DEBT_REASON IS NULL )
557 AND ( p_BAD_DEBT_REASON IS NULL )))
558 AND ( ( Recinfo.LEASING_CODE = p_LEASING_CODE)
559 OR ( ( Recinfo.LEASING_CODE IS NULL )
560 AND ( p_LEASING_CODE IS NULL )))
561 AND ( ( Recinfo.REPOSSES_SCH_DATE = p_REPOSSES_SCH_DATE)
562 OR ( ( Recinfo.REPOSSES_SCH_DATE IS NULL )
563 AND ( p_REPOSSES_SCH_DATE IS NULL )))
564 AND ( ( Recinfo.REPOSSES_COMP_DATE = p_REPOSSES_COMP_DATE)
565 OR ( ( Recinfo.REPOSSES_COMP_DATE IS NULL )
566 AND ( p_REPOSSES_COMP_DATE IS NULL )))
567 AND ( ( Recinfo.CREDIT_HOLD_YN = p_CREDIT_HOLD_YN)
568 OR ( ( Recinfo.CREDIT_HOLD_YN IS NULL )
569 AND ( p_CREDIT_HOLD_YN IS NULL )))
570 AND ( ( Recinfo.APPROVER_ID = p_APPROVER_ID)
571 OR ( ( Recinfo.APPROVER_ID IS NULL )
572 AND ( p_APPROVER_ID IS NULL )))
573 AND ( ( Recinfo.EXTERNAL_AGENT_ID = p_EXTERNAL_AGENT_ID)
574 OR ( ( Recinfo.EXTERNAL_AGENT_ID IS NULL )
575 AND ( p_EXTERNAL_AGENT_ID IS NULL )))
576 AND ( ( Recinfo.PROCEDURE_CODE = p_PROCEDURE_CODE)
577 OR ( ( Recinfo.PROCEDURE_CODE IS NULL )
578 AND ( p_PROCEDURE_CODE IS NULL )))
579 AND ( ( Recinfo.CHECKLIST_CODE = p_CHECKLIST_CODE)
580 OR ( ( Recinfo.CHECKLIST_CODE IS NULL )
581 AND ( p_CHECKLIST_CODE IS NULL )))
582 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
583 OR ( ( Recinfo.REQUEST_ID IS NULL )
584 AND ( p_REQUEST_ID IS NULL )))
585 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
586 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
587 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
588 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
589 OR ( ( Recinfo.PROGRAM_ID IS NULL )
590 AND ( p_PROGRAM_ID IS NULL )))
591 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
592 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
593 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
594 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
595 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
596 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
597 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
598 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
599 AND ( p_ATTRIBUTE1 IS NULL )))
600 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
601 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
602 AND ( p_ATTRIBUTE2 IS NULL )))
603 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
604 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
605 AND ( p_ATTRIBUTE3 IS NULL )))
606 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
607 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
608 AND ( p_ATTRIBUTE4 IS NULL )))
609 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
610 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
611 AND ( p_ATTRIBUTE5 IS NULL )))
612 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
613 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
614 AND ( p_ATTRIBUTE6 IS NULL )))
615 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
616 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
617 AND ( p_ATTRIBUTE7 IS NULL )))
618 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
619 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
620 AND ( p_ATTRIBUTE8 IS NULL )))
621 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
622 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
623 AND ( p_ATTRIBUTE9 IS NULL )))
624 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
625 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
626 AND ( p_ATTRIBUTE10 IS NULL )))
627 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
628 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
629 AND ( p_ATTRIBUTE11 IS NULL )))
630 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
631 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
632 AND ( p_ATTRIBUTE12 IS NULL )))
633 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
634 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
635 AND ( p_ATTRIBUTE13 IS NULL )))
636 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
637 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
638 AND ( p_ATTRIBUTE14 IS NULL )))
639 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
640 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
641 AND ( p_ATTRIBUTE15 IS NULL )))
642 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
643 OR ( ( Recinfo.CREATED_BY IS NULL )
644 AND ( p_CREATED_BY IS NULL )))
645 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
646 OR ( ( Recinfo.CREATION_DATE IS NULL )
647 AND ( p_CREATION_DATE IS NULL )))
648 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
649 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
650 AND ( p_LAST_UPDATED_BY IS NULL )))
651 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
652 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
653 AND ( p_LAST_UPDATE_DATE IS NULL )))
654 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
655 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
656 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
657 AND ( ( Recinfo.CREDIT_HOLD_REQUEST_FLAG = p_CREDIT_HOLD_REQUEST_FLAG)
658 OR ( ( Recinfo.CREDIT_HOLD_REQUEST_FLAG IS NULL )
659 AND ( p_CREDIT_HOLD_REQUEST_FLAG IS NULL )))
660 AND ( ( Recinfo.CREDIT_HOLD_APPROVED_FLAG = p_CREDIT_HOLD_APPROVED_FLAG)
661 OR ( ( Recinfo.CREDIT_HOLD_APPROVED_FLAG IS NULL )
662 AND ( p_CREDIT_HOLD_APPROVED_FLAG IS NULL )))
663 AND ( ( Recinfo.SERVICE_HOLD_REQUEST_FLAG = p_SERVICE_HOLD_REQUEST_FLAG)
664 OR ( ( Recinfo.SERVICE_HOLD_REQUEST_FLAG IS NULL )
665 AND ( p_SERVICE_HOLD_REQUEST_FLAG IS NULL )))
666 AND ( ( Recinfo.SERVICE_HOLD_APPROVED_FLAG = p_SERVICE_HOLD_APPROVED_FLAG)
667 OR ( ( Recinfo.SERVICE_HOLD_APPROVED_FLAG IS NULL )
668 AND ( p_SERVICE_HOLD_APPROVED_FLAG IS NULL )))
669 AND ( ( Recinfo.SUGGESTION_APPROVED_FLAG = p_SUGGESTION_APPROVED_FLAG)
670 OR ( ( Recinfo.SUGGESTION_APPROVED_FLAG IS NULL )
671 AND ( p_SUGGESTION_APPROVED_FLAG IS NULL )))
672 ) then
673 return;
674 else
675 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
676 APP_EXCEPTION.RAISE_EXCEPTION;
677 End If;
678 END Lock_Row;
679 */
680 End IEX_WRITEOFFS_PKG;