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