[Home] [Help]
PACKAGE BODY: APPS.HZ_CUST_PROF_CLASS_AMTS_PKG
Source
1 PACKAGE BODY HZ_CUST_PROF_CLASS_AMTS_PKG AS
2 /*$Header: ARHPCMTB.pls 120.3 2006/02/24 00:26:37 baianand ship $ */
3
4 PROCEDURE Insert_Row (
5 X_PROFILE_CLASS_AMOUNT_ID IN OUT NOCOPY NUMBER,
6 X_PROFILE_CLASS_ID IN NUMBER,
7 X_CURRENCY_CODE IN VARCHAR2,
8 X_TRX_CREDIT_LIMIT IN NUMBER,
9 X_OVERALL_CREDIT_LIMIT IN NUMBER,
10 X_MIN_DUNNING_AMOUNT IN NUMBER,
11 X_MAX_INTEREST_CHARGE IN NUMBER,
12 X_MIN_STATEMENT_AMOUNT IN NUMBER,
13 X_AUTO_REC_MIN_RECEIPT_AMOUNT IN NUMBER,
14 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
15 X_ATTRIBUTE1 IN VARCHAR2,
16 X_ATTRIBUTE2 IN VARCHAR2,
17 X_ATTRIBUTE3 IN VARCHAR2,
18 X_ATTRIBUTE4 IN VARCHAR2,
19 X_ATTRIBUTE5 IN VARCHAR2,
20 X_ATTRIBUTE6 IN VARCHAR2,
21 X_ATTRIBUTE7 IN VARCHAR2,
22 X_ATTRIBUTE8 IN VARCHAR2,
23 X_ATTRIBUTE9 IN VARCHAR2,
24 X_ATTRIBUTE10 IN VARCHAR2,
25 X_ATTRIBUTE11 IN VARCHAR2,
26 X_ATTRIBUTE12 IN VARCHAR2,
27 X_ATTRIBUTE13 IN VARCHAR2,
28 X_ATTRIBUTE14 IN VARCHAR2,
29 X_ATTRIBUTE15 IN VARCHAR2,
30 X_INTEREST_RATE IN NUMBER,
31 X_MIN_FC_BALANCE_AMOUNT IN NUMBER,
32 X_MIN_FC_INVOICE_AMOUNT IN NUMBER,
33 X_MIN_DUNNING_INVOICE_AMOUNT IN NUMBER,
34 X_EXPIRATION_DATE IN DATE,
35 X_JGZZ_ATTRIBUTE_CATEGORY IN VARCHAR2,
36 X_JGZZ_ATTRIBUTE1 IN VARCHAR2,
37 X_JGZZ_ATTRIBUTE2 IN VARCHAR2,
38 X_JGZZ_ATTRIBUTE3 IN VARCHAR2,
39 X_JGZZ_ATTRIBUTE4 IN VARCHAR2,
40 X_JGZZ_ATTRIBUTE5 IN VARCHAR2,
41 X_JGZZ_ATTRIBUTE6 IN VARCHAR2,
42 X_JGZZ_ATTRIBUTE7 IN VARCHAR2,
43 X_JGZZ_ATTRIBUTE8 IN VARCHAR2,
44 X_JGZZ_ATTRIBUTE9 IN VARCHAR2,
45 X_JGZZ_ATTRIBUTE10 IN VARCHAR2,
46 X_JGZZ_ATTRIBUTE11 IN VARCHAR2,
47 X_JGZZ_ATTRIBUTE12 IN VARCHAR2,
48 X_JGZZ_ATTRIBUTE13 IN VARCHAR2,
49 X_JGZZ_ATTRIBUTE14 IN VARCHAR2,
50 X_JGZZ_ATTRIBUTE15 IN VARCHAR2,
51 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
52 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
53 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
54 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
55 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
56 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
57 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
58 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
59 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
60 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
61 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
62 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
63 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
64 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
65 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
66 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
67 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
68 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
69 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
70 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
71 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
72 X_EXCHANGE_RATE_TYPE IN VARCHAR2,
73 X_MIN_FC_INVOICE_OVERDUE_TYPE IN VARCHAR2,
74 X_MIN_FC_INVOICE_PERCENT IN NUMBER,
75 X_MIN_FC_BALANCE_OVERDUE_TYPE IN VARCHAR2,
76 X_MIN_FC_BALANCE_PERCENT IN NUMBER,
77 X_INTEREST_TYPE IN VARCHAR2,
78 X_INTEREST_FIXED_AMOUNT IN NUMBER,
79 X_INTEREST_SCHEDULE_ID IN NUMBER,
80 X_PENALTY_TYPE IN VARCHAR2,
81 X_PENALTY_RATE IN NUMBER,
82 X_MIN_INTEREST_CHARGE IN NUMBER,
83 X_PENALTY_FIXED_AMOUNT IN NUMBER,
84 X_PENALTY_SCHEDULE_ID IN NUMBER
85 ) IS
86
87 l_success VARCHAR2(1) := 'N';
88
89 BEGIN
90
91 WHILE l_success = 'N' LOOP
92 BEGIN
93 INSERT INTO HZ_CUST_PROF_CLASS_AMTS (
94 PROFILE_CLASS_AMOUNT_ID,
95 LAST_UPDATED_BY,
96 LAST_UPDATE_DATE,
97 CREATED_BY,
98 CREATION_DATE,
99 REQUEST_ID,
100 PROFILE_CLASS_ID,
101 PROGRAM_APPLICATION_ID,
102 PROGRAM_ID,
103 CURRENCY_CODE,
104 PROGRAM_UPDATE_DATE,
105 LAST_UPDATE_LOGIN,
106 TRX_CREDIT_LIMIT,
107 OVERALL_CREDIT_LIMIT,
108 MIN_DUNNING_AMOUNT,
109 MAX_INTEREST_CHARGE,
110 MIN_STATEMENT_AMOUNT,
111 AUTO_REC_MIN_RECEIPT_AMOUNT,
112 ATTRIBUTE_CATEGORY,
113 ATTRIBUTE1,
114 ATTRIBUTE2,
115 ATTRIBUTE3,
116 ATTRIBUTE4,
117 ATTRIBUTE5,
118 ATTRIBUTE6,
119 ATTRIBUTE7,
120 ATTRIBUTE8,
121 ATTRIBUTE9,
122 ATTRIBUTE10,
123 ATTRIBUTE11,
124 ATTRIBUTE12,
125 ATTRIBUTE13,
126 ATTRIBUTE14,
127 ATTRIBUTE15,
128 INTEREST_RATE,
129 MIN_FC_BALANCE_AMOUNT,
130 MIN_FC_INVOICE_AMOUNT,
131 MIN_DUNNING_INVOICE_AMOUNT,
132 EXPIRATION_DATE,
133 JGZZ_ATTRIBUTE_CATEGORY,
134 JGZZ_ATTRIBUTE1,
135 JGZZ_ATTRIBUTE2,
136 JGZZ_ATTRIBUTE3,
137 JGZZ_ATTRIBUTE4,
138 JGZZ_ATTRIBUTE5,
139 JGZZ_ATTRIBUTE6,
140 JGZZ_ATTRIBUTE7,
141 JGZZ_ATTRIBUTE8,
142 JGZZ_ATTRIBUTE9,
143 JGZZ_ATTRIBUTE10,
144 JGZZ_ATTRIBUTE11,
145 JGZZ_ATTRIBUTE12,
146 JGZZ_ATTRIBUTE13,
147 JGZZ_ATTRIBUTE14,
148 JGZZ_ATTRIBUTE15,
149 GLOBAL_ATTRIBUTE1,
150 GLOBAL_ATTRIBUTE2,
151 GLOBAL_ATTRIBUTE3,
152 GLOBAL_ATTRIBUTE4,
153 GLOBAL_ATTRIBUTE5,
154 GLOBAL_ATTRIBUTE6,
155 GLOBAL_ATTRIBUTE7,
156 GLOBAL_ATTRIBUTE8,
157 GLOBAL_ATTRIBUTE9,
158 GLOBAL_ATTRIBUTE10,
159 GLOBAL_ATTRIBUTE11,
160 GLOBAL_ATTRIBUTE12,
161 GLOBAL_ATTRIBUTE13,
162 GLOBAL_ATTRIBUTE14,
163 GLOBAL_ATTRIBUTE15,
164 GLOBAL_ATTRIBUTE16,
165 GLOBAL_ATTRIBUTE17,
166 GLOBAL_ATTRIBUTE18,
167 GLOBAL_ATTRIBUTE19,
168 GLOBAL_ATTRIBUTE20,
169 GLOBAL_ATTRIBUTE_CATEGORY,
170 EXCHANGE_RATE_TYPE,
171 MIN_FC_INVOICE_OVERDUE_TYPE,
172 MIN_FC_INVOICE_PERCENT,
173 MIN_FC_BALANCE_OVERDUE_TYPE,
174 MIN_FC_BALANCE_PERCENT,
175 INTEREST_TYPE,
176 INTEREST_FIXED_AMOUNT,
177 INTEREST_SCHEDULE_ID,
178 PENALTY_TYPE,
179 PENALTY_RATE,
180 MIN_INTEREST_CHARGE,
181 PENALTY_FIXED_AMOUNT,
182 PENALTY_SCHEDULE_ID
183 )
184 VALUES (
185 DECODE( X_PROFILE_CLASS_AMOUNT_ID, FND_API.G_MISS_NUM, HZ_CUST_PROF_CLASS_AMTS_S.NEXTVAL, NULL, HZ_CUST_PROF_CLASS_AMTS_S.NEXTVAL, X_PROFILE_CLASS_AMOUNT_ID ),
186 HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
187 HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
188 HZ_UTILITY_V2PUB.CREATED_BY,
189 HZ_UTILITY_V2PUB.CREATION_DATE,
190 HZ_UTILITY_V2PUB.REQUEST_ID,
191 DECODE( X_PROFILE_CLASS_ID, FND_API.G_MISS_NUM, NULL, X_PROFILE_CLASS_ID ),
192 HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
193 HZ_UTILITY_V2PUB.PROGRAM_ID,
194 DECODE( X_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, X_CURRENCY_CODE ),
195 HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
196 HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
197 DECODE( X_TRX_CREDIT_LIMIT, FND_API.G_MISS_NUM, NULL, X_TRX_CREDIT_LIMIT ),
198 DECODE( X_OVERALL_CREDIT_LIMIT, FND_API.G_MISS_NUM, NULL, X_OVERALL_CREDIT_LIMIT ),
199 DECODE( X_MIN_DUNNING_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_DUNNING_AMOUNT ),
200 DECODE( X_MAX_INTEREST_CHARGE, FND_API.G_MISS_NUM, NULL, X_MAX_INTEREST_CHARGE ),
201 DECODE( X_MIN_STATEMENT_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_STATEMENT_AMOUNT ),
202 DECODE( X_AUTO_REC_MIN_RECEIPT_AMOUNT, FND_API.G_MISS_NUM, NULL, X_AUTO_REC_MIN_RECEIPT_AMOUNT ),
203 DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
204 DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
205 DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
206 DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
207 DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
208 DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
209 DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
210 DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
211 DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
212 DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
213 DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
214 DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
215 DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
216 DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
217 DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
218 DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
219 DECODE( X_INTEREST_RATE, FND_API.G_MISS_NUM, NULL, X_INTEREST_RATE ),
220 DECODE( X_MIN_FC_BALANCE_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_BALANCE_AMOUNT ),
221 DECODE( X_MIN_FC_INVOICE_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_INVOICE_AMOUNT ),
222 DECODE( X_MIN_DUNNING_INVOICE_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_DUNNING_INVOICE_AMOUNT ),
223 DECODE( X_EXPIRATION_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_EXPIRATION_DATE ),
224 DECODE( X_JGZZ_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE_CATEGORY ),
225 DECODE( X_JGZZ_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE1 ),
226 DECODE( X_JGZZ_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE2 ),
227 DECODE( X_JGZZ_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE3 ),
228 DECODE( X_JGZZ_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE4 ),
229 DECODE( X_JGZZ_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE5 ),
230 DECODE( X_JGZZ_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE6 ),
231 DECODE( X_JGZZ_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE7 ),
232 DECODE( X_JGZZ_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE8 ),
233 DECODE( X_JGZZ_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE9 ),
234 DECODE( X_JGZZ_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE10 ),
235 DECODE( X_JGZZ_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE11 ),
236 DECODE( X_JGZZ_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE12 ),
237 DECODE( X_JGZZ_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE13 ),
238 DECODE( X_JGZZ_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE14 ),
239 DECODE( X_JGZZ_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE15 ),
240 DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
241 DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
242 DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
243 DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
244 DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
245 DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
246 DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
247 DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
248 DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
249 DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
250 DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
251 DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
252 DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
253 DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
254 DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
255 DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
256 DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
257 DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
258 DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
259 DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
260 DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
261 DECODE( X_EXCHANGE_RATE_TYPE, FND_API.G_MISS_CHAR, NULL, X_EXCHANGE_RATE_TYPE ),
262 DECODE( X_MIN_FC_INVOICE_OVERDUE_TYPE, FND_API.G_MISS_CHAR, NULL, X_MIN_FC_INVOICE_OVERDUE_TYPE ),
263 DECODE( X_MIN_FC_INVOICE_PERCENT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_INVOICE_PERCENT ),
264 DECODE( X_MIN_FC_BALANCE_OVERDUE_TYPE, FND_API.G_MISS_CHAR, NULL, X_MIN_FC_BALANCE_OVERDUE_TYPE ),
265 DECODE( X_MIN_FC_BALANCE_PERCENT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_BALANCE_PERCENT ),
266 DECODE( X_INTEREST_TYPE, FND_API.G_MISS_CHAR, NULL, X_INTEREST_TYPE ),
267 DECODE( X_INTEREST_FIXED_AMOUNT, FND_API.G_MISS_NUM, NULL, X_INTEREST_FIXED_AMOUNT ),
268 DECODE( X_INTEREST_SCHEDULE_ID, FND_API.G_MISS_NUM, NULL, X_INTEREST_SCHEDULE_ID ),
269 DECODE( X_PENALTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PENALTY_TYPE ),
270 DECODE( X_PENALTY_RATE, FND_API.G_MISS_NUM, NULL, X_PENALTY_RATE ),
271 DECODE( X_MIN_INTEREST_CHARGE, FND_API.G_MISS_NUM, NULL, X_MIN_INTEREST_CHARGE ),
272 DECODE( X_PENALTY_FIXED_AMOUNT, FND_API.G_MISS_NUM, NULL, X_PENALTY_FIXED_AMOUNT ),
273 DECODE( X_PENALTY_SCHEDULE_ID, FND_API.G_MISS_NUM, NULL, X_PENALTY_SCHEDULE_ID )
274 ) RETURNING
275 PROFILE_CLASS_AMOUNT_ID
276 INTO
277 X_PROFILE_CLASS_AMOUNT_ID;
278
279 l_success := 'Y';
280
281 EXCEPTION
282 WHEN DUP_VAL_ON_INDEX THEN
283 IF INSTRB( SQLERRM, 'HZ_CUST_PROF_CLASS_AMTS_U1' ) <> 0 OR
284 INSTRB( SQLERRM, 'HZ_CUST_PROF_CLASS_AMTS_PK' ) <> 0
285 THEN
286 DECLARE
287 l_count NUMBER;
288 l_dummy VARCHAR2(1);
289 BEGIN
290 l_count := 1;
291 WHILE l_count > 0 LOOP
292 SELECT HZ_CUST_PROF_CLASS_AMTS_S.NEXTVAL
293 INTO X_PROFILE_CLASS_AMOUNT_ID FROM dual;
294 BEGIN
298 l_count := 1;
295 SELECT 'Y' INTO l_dummy
296 FROM HZ_CUST_PROF_CLASS_AMTS
297 WHERE PROFILE_CLASS_AMOUNT_ID = X_PROFILE_CLASS_AMOUNT_ID;
299 EXCEPTION
300 WHEN NO_DATA_FOUND THEN
301 l_count := 0;
302 END;
303 END LOOP;
304 END;
305 ELSE
306 RAISE;
307 END IF;
308
309 END;
310 END LOOP;
311
312 END Insert_Row;
313
314 PROCEDURE Update_Row (
315 X_Rowid IN OUT NOCOPY VARCHAR2,
316 X_PROFILE_CLASS_AMOUNT_ID IN NUMBER,
317 X_PROFILE_CLASS_ID IN NUMBER,
318 X_CURRENCY_CODE IN VARCHAR2,
319 X_TRX_CREDIT_LIMIT IN NUMBER,
320 X_OVERALL_CREDIT_LIMIT IN NUMBER,
321 X_MIN_DUNNING_AMOUNT IN NUMBER,
322 X_MAX_INTEREST_CHARGE IN NUMBER,
323 X_MIN_STATEMENT_AMOUNT IN NUMBER,
324 X_AUTO_REC_MIN_RECEIPT_AMOUNT IN NUMBER,
325 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
326 X_ATTRIBUTE1 IN VARCHAR2,
327 X_ATTRIBUTE2 IN VARCHAR2,
328 X_ATTRIBUTE3 IN VARCHAR2,
329 X_ATTRIBUTE4 IN VARCHAR2,
330 X_ATTRIBUTE5 IN VARCHAR2,
331 X_ATTRIBUTE6 IN VARCHAR2,
332 X_ATTRIBUTE7 IN VARCHAR2,
333 X_ATTRIBUTE8 IN VARCHAR2,
334 X_ATTRIBUTE9 IN VARCHAR2,
335 X_ATTRIBUTE10 IN VARCHAR2,
336 X_ATTRIBUTE11 IN VARCHAR2,
337 X_ATTRIBUTE12 IN VARCHAR2,
338 X_ATTRIBUTE13 IN VARCHAR2,
339 X_ATTRIBUTE14 IN VARCHAR2,
340 X_ATTRIBUTE15 IN VARCHAR2,
341 X_INTEREST_RATE IN NUMBER,
342 X_MIN_FC_BALANCE_AMOUNT IN NUMBER,
343 X_MIN_FC_INVOICE_AMOUNT IN NUMBER,
344 X_MIN_DUNNING_INVOICE_AMOUNT IN NUMBER,
345 X_EXPIRATION_DATE IN DATE,
346 X_JGZZ_ATTRIBUTE_CATEGORY IN VARCHAR2,
347 X_JGZZ_ATTRIBUTE1 IN VARCHAR2,
348 X_JGZZ_ATTRIBUTE2 IN VARCHAR2,
349 X_JGZZ_ATTRIBUTE3 IN VARCHAR2,
350 X_JGZZ_ATTRIBUTE4 IN VARCHAR2,
351 X_JGZZ_ATTRIBUTE5 IN VARCHAR2,
352 X_JGZZ_ATTRIBUTE6 IN VARCHAR2,
353 X_JGZZ_ATTRIBUTE7 IN VARCHAR2,
354 X_JGZZ_ATTRIBUTE8 IN VARCHAR2,
355 X_JGZZ_ATTRIBUTE9 IN VARCHAR2,
356 X_JGZZ_ATTRIBUTE10 IN VARCHAR2,
357 X_JGZZ_ATTRIBUTE11 IN VARCHAR2,
358 X_JGZZ_ATTRIBUTE12 IN VARCHAR2,
359 X_JGZZ_ATTRIBUTE13 IN VARCHAR2,
360 X_JGZZ_ATTRIBUTE14 IN VARCHAR2,
361 X_JGZZ_ATTRIBUTE15 IN VARCHAR2,
362 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
363 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
364 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
365 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
366 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
367 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
368 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
369 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
370 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
371 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
372 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
373 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
374 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
375 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
376 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
377 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
378 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
379 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
380 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
381 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
382 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
383 X_EXCHANGE_RATE_TYPE IN VARCHAR2,
384 X_MIN_FC_INVOICE_OVERDUE_TYPE IN VARCHAR2,
385 X_MIN_FC_INVOICE_PERCENT IN NUMBER,
386 X_MIN_FC_BALANCE_OVERDUE_TYPE IN VARCHAR2,
387 X_MIN_FC_BALANCE_PERCENT IN NUMBER,
388 X_INTEREST_TYPE IN VARCHAR2,
389 X_INTEREST_FIXED_AMOUNT IN NUMBER,
390 X_INTEREST_SCHEDULE_ID IN NUMBER,
391 X_PENALTY_TYPE IN VARCHAR2,
392 X_PENALTY_RATE IN NUMBER,
393 X_MIN_INTEREST_CHARGE IN NUMBER,
397
394 X_PENALTY_FIXED_AMOUNT IN NUMBER,
395 X_PENALTY_SCHEDULE_ID IN NUMBER
396 ) IS
398 BEGIN
399
400 UPDATE HZ_CUST_PROF_CLASS_AMTS SET
401 PROFILE_CLASS_AMOUNT_ID = DECODE( X_PROFILE_CLASS_AMOUNT_ID, NULL, PROFILE_CLASS_AMOUNT_ID, FND_API.G_MISS_NUM, NULL, X_PROFILE_CLASS_AMOUNT_ID ),
402 LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
403 LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
404 CREATED_BY = CREATED_BY,
405 CREATION_DATE = CREATION_DATE,
406 REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
407 PROFILE_CLASS_ID = DECODE( X_PROFILE_CLASS_ID, NULL, PROFILE_CLASS_ID, FND_API.G_MISS_NUM, NULL, X_PROFILE_CLASS_ID ),
408 PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
409 PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
410 CURRENCY_CODE = DECODE( X_CURRENCY_CODE, NULL, CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, X_CURRENCY_CODE ),
411 PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
412 LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
413 TRX_CREDIT_LIMIT = DECODE( X_TRX_CREDIT_LIMIT, NULL, TRX_CREDIT_LIMIT, FND_API.G_MISS_NUM, NULL, X_TRX_CREDIT_LIMIT ),
414 OVERALL_CREDIT_LIMIT = DECODE( X_OVERALL_CREDIT_LIMIT, NULL, OVERALL_CREDIT_LIMIT, FND_API.G_MISS_NUM, NULL, X_OVERALL_CREDIT_LIMIT ),
415 MIN_DUNNING_AMOUNT = DECODE( X_MIN_DUNNING_AMOUNT, NULL, MIN_DUNNING_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_DUNNING_AMOUNT ),
416 MAX_INTEREST_CHARGE = DECODE( X_MAX_INTEREST_CHARGE, NULL, MAX_INTEREST_CHARGE, FND_API.G_MISS_NUM, NULL, X_MAX_INTEREST_CHARGE ),
417 MIN_STATEMENT_AMOUNT = DECODE( X_MIN_STATEMENT_AMOUNT, NULL, MIN_STATEMENT_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_STATEMENT_AMOUNT ),
418 AUTO_REC_MIN_RECEIPT_AMOUNT = DECODE( X_AUTO_REC_MIN_RECEIPT_AMOUNT, NULL, AUTO_REC_MIN_RECEIPT_AMOUNT, FND_API.G_MISS_NUM, NULL, X_AUTO_REC_MIN_RECEIPT_AMOUNT ),
419 ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
420 ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
421 ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
422 ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
423 ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
424 ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
425 ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
426 ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
427 ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
428 ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
429 ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
430 ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
431 ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
432 ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
433 ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
434 ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
435 INTEREST_RATE = DECODE( X_INTEREST_RATE, NULL, INTEREST_RATE, FND_API.G_MISS_NUM, NULL, X_INTEREST_RATE ),
436 MIN_FC_BALANCE_AMOUNT = DECODE( X_MIN_FC_BALANCE_AMOUNT, NULL, MIN_FC_BALANCE_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_BALANCE_AMOUNT ),
437 MIN_FC_INVOICE_AMOUNT = DECODE( X_MIN_FC_INVOICE_AMOUNT, NULL, MIN_FC_INVOICE_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_INVOICE_AMOUNT ),
438 MIN_DUNNING_INVOICE_AMOUNT = DECODE( X_MIN_DUNNING_INVOICE_AMOUNT, NULL, MIN_DUNNING_INVOICE_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_DUNNING_INVOICE_AMOUNT ),
439 EXPIRATION_DATE = DECODE( X_EXPIRATION_DATE, NULL, EXPIRATION_DATE, FND_API.G_MISS_DATE,
440 NULL, X_EXPIRATION_DATE ),
441 JGZZ_ATTRIBUTE_CATEGORY = DECODE( X_JGZZ_ATTRIBUTE_CATEGORY, NULL, JGZZ_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE_CATEGORY ),
442 JGZZ_ATTRIBUTE1 = DECODE( X_JGZZ_ATTRIBUTE1, NULL, JGZZ_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE1 ),
443 JGZZ_ATTRIBUTE2 = DECODE( X_JGZZ_ATTRIBUTE2, NULL, JGZZ_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE2 ),
444 JGZZ_ATTRIBUTE3 = DECODE( X_JGZZ_ATTRIBUTE3, NULL, JGZZ_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE3 ),
445 JGZZ_ATTRIBUTE4 = DECODE( X_JGZZ_ATTRIBUTE4, NULL, JGZZ_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE4 ),
446 JGZZ_ATTRIBUTE5 = DECODE( X_JGZZ_ATTRIBUTE5, NULL, JGZZ_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE5 ),
447 JGZZ_ATTRIBUTE6 = DECODE( X_JGZZ_ATTRIBUTE6, NULL, JGZZ_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE6 ),
448 JGZZ_ATTRIBUTE7 = DECODE( X_JGZZ_ATTRIBUTE7, NULL, JGZZ_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE7 ),
449 JGZZ_ATTRIBUTE8 = DECODE( X_JGZZ_ATTRIBUTE8, NULL, JGZZ_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE8 ),
450 JGZZ_ATTRIBUTE9 = DECODE( X_JGZZ_ATTRIBUTE9, NULL, JGZZ_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE9 ),
451 JGZZ_ATTRIBUTE10 = DECODE( X_JGZZ_ATTRIBUTE10, NULL, JGZZ_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE10 ),
452 JGZZ_ATTRIBUTE11 = DECODE( X_JGZZ_ATTRIBUTE11, NULL, JGZZ_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE11 ),
456 JGZZ_ATTRIBUTE15 = DECODE( X_JGZZ_ATTRIBUTE15, NULL, JGZZ_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE15 ),
453 JGZZ_ATTRIBUTE12 = DECODE( X_JGZZ_ATTRIBUTE12, NULL, JGZZ_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE12 ),
454 JGZZ_ATTRIBUTE13 = DECODE( X_JGZZ_ATTRIBUTE13, NULL, JGZZ_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE13 ),
455 JGZZ_ATTRIBUTE14 = DECODE( X_JGZZ_ATTRIBUTE14, NULL, JGZZ_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE14 ),
457 GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
458 GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
459 GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
460 GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
461 GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
462 GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
463 GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
464 GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
465 GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
466 GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
467 GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
468 GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
469 GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
470 GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
471 GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
472 GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
473 GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
474 GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
475 GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
476 GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
477 GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
478 EXCHANGE_RATE_TYPE = DECODE( X_EXCHANGE_RATE_TYPE, NULL, EXCHANGE_RATE_TYPE, FND_API.G_MISS_CHAR, NULL, X_EXCHANGE_RATE_TYPE ),
479 MIN_FC_INVOICE_OVERDUE_TYPE = DECODE( MIN_FC_INVOICE_OVERDUE_TYPE, NULL, MIN_FC_INVOICE_OVERDUE_TYPE, FND_API.G_MISS_CHAR, NULL, X_MIN_FC_INVOICE_OVERDUE_TYPE ),
480 MIN_FC_INVOICE_PERCENT = DECODE( X_MIN_FC_INVOICE_PERCENT, NULL, MIN_FC_INVOICE_PERCENT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_INVOICE_PERCENT ),
481 MIN_FC_BALANCE_OVERDUE_TYPE = DECODE( X_MIN_FC_BALANCE_OVERDUE_TYPE, NULL, MIN_FC_BALANCE_OVERDUE_TYPE, FND_API.G_MISS_CHAR, NULL, X_MIN_FC_BALANCE_OVERDUE_TYPE ),
482 MIN_FC_BALANCE_PERCENT = DECODE( X_MIN_FC_BALANCE_PERCENT, NULL, MIN_FC_BALANCE_PERCENT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_BALANCE_PERCENT ),
483 INTEREST_TYPE = DECODE( X_INTEREST_TYPE, NULL, INTEREST_TYPE, FND_API.G_MISS_CHAR, NULL, X_INTEREST_TYPE ),
484 INTEREST_FIXED_AMOUNT = DECODE( X_INTEREST_FIXED_AMOUNT, NULL, INTEREST_FIXED_AMOUNT, FND_API.G_MISS_NUM, NULL, X_INTEREST_FIXED_AMOUNT ),
485 INTEREST_SCHEDULE_ID = DECODE( X_INTEREST_SCHEDULE_ID, NULL, INTEREST_SCHEDULE_ID, FND_API.G_MISS_NUM, NULL, X_INTEREST_SCHEDULE_ID ),
486 PENALTY_TYPE = DECODE( X_PENALTY_TYPE, NULL, PENALTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PENALTY_TYPE ),
487 PENALTY_RATE = DECODE( X_PENALTY_RATE, NULL, PENALTY_RATE, FND_API.G_MISS_NUM, NULL, X_PENALTY_RATE ),
488 MIN_INTEREST_CHARGE = DECODE( X_MIN_INTEREST_CHARGE, NULL, MIN_INTEREST_CHARGE, FND_API.G_MISS_NUM, NULL, X_MIN_INTEREST_CHARGE ),
489 PENALTY_FIXED_AMOUNT = DECODE( X_PENALTY_FIXED_AMOUNT, NULL, PENALTY_FIXED_AMOUNT, FND_API.G_MISS_NUM, NULL, X_PENALTY_FIXED_AMOUNT ),
490 PENALTY_SCHEDULE_ID = DECODE( X_PENALTY_SCHEDULE_ID, NULL, PENALTY_SCHEDULE_ID, FND_API.G_MISS_NUM, NULL, X_PENALTY_SCHEDULE_ID )
491 WHERE ROWID = X_RowId;
492
493 IF ( SQL%NOTFOUND ) THEN
494 RAISE NO_DATA_FOUND;
495 END IF;
496
497 END Update_Row;
498
499 PROCEDURE Lock_Row (
500 X_Rowid IN OUT NOCOPY VARCHAR2,
501 X_PROFILE_CLASS_AMOUNT_ID IN NUMBER,
502 X_LAST_UPDATED_BY IN NUMBER,
503 X_LAST_UPDATE_DATE IN DATE,
504 X_CREATED_BY IN NUMBER,
505 X_CREATION_DATE IN DATE,
506 X_REQUEST_ID IN NUMBER,
507 X_PROFILE_CLASS_ID IN NUMBER,
508 X_PROGRAM_APPLICATION_ID IN NUMBER,
509 X_PROGRAM_ID IN NUMBER,
510 X_CURRENCY_CODE IN VARCHAR2,
511 X_PROGRAM_UPDATE_DATE IN DATE,
515 X_MIN_DUNNING_AMOUNT IN NUMBER,
512 X_LAST_UPDATE_LOGIN IN NUMBER,
513 X_TRX_CREDIT_LIMIT IN NUMBER,
514 X_OVERALL_CREDIT_LIMIT IN NUMBER,
516 X_MAX_INTEREST_CHARGE IN NUMBER,
517 X_MIN_STATEMENT_AMOUNT IN NUMBER,
518 X_AUTO_REC_MIN_RECEIPT_AMOUNT IN NUMBER,
519 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
520 X_ATTRIBUTE1 IN VARCHAR2,
521 X_ATTRIBUTE2 IN VARCHAR2,
522 X_ATTRIBUTE3 IN VARCHAR2,
523 X_ATTRIBUTE4 IN VARCHAR2,
524 X_ATTRIBUTE5 IN VARCHAR2,
525 X_ATTRIBUTE6 IN VARCHAR2,
526 X_ATTRIBUTE7 IN VARCHAR2,
527 X_ATTRIBUTE8 IN VARCHAR2,
528 X_ATTRIBUTE9 IN VARCHAR2,
529 X_ATTRIBUTE10 IN VARCHAR2,
530 X_ATTRIBUTE11 IN VARCHAR2,
531 X_ATTRIBUTE12 IN VARCHAR2,
532 X_ATTRIBUTE13 IN VARCHAR2,
533 X_ATTRIBUTE14 IN VARCHAR2,
534 X_ATTRIBUTE15 IN VARCHAR2,
535 X_INTEREST_RATE IN NUMBER,
536 X_MIN_FC_BALANCE_AMOUNT IN NUMBER,
537 X_MIN_FC_INVOICE_AMOUNT IN NUMBER,
538 X_MIN_DUNNING_INVOICE_AMOUNT IN NUMBER,
539 X_EXPIRATION_DATE IN DATE,
540 X_JGZZ_ATTRIBUTE_CATEGORY IN VARCHAR2,
541 X_JGZZ_ATTRIBUTE1 IN VARCHAR2,
542 X_JGZZ_ATTRIBUTE2 IN VARCHAR2,
543 X_JGZZ_ATTRIBUTE3 IN VARCHAR2,
544 X_JGZZ_ATTRIBUTE4 IN VARCHAR2,
545 X_JGZZ_ATTRIBUTE5 IN VARCHAR2,
546 X_JGZZ_ATTRIBUTE6 IN VARCHAR2,
547 X_JGZZ_ATTRIBUTE7 IN VARCHAR2,
548 X_JGZZ_ATTRIBUTE8 IN VARCHAR2,
549 X_JGZZ_ATTRIBUTE9 IN VARCHAR2,
550 X_JGZZ_ATTRIBUTE10 IN VARCHAR2,
551 X_JGZZ_ATTRIBUTE11 IN VARCHAR2,
552 X_JGZZ_ATTRIBUTE12 IN VARCHAR2,
553 X_JGZZ_ATTRIBUTE13 IN VARCHAR2,
554 X_JGZZ_ATTRIBUTE14 IN VARCHAR2,
555 X_JGZZ_ATTRIBUTE15 IN VARCHAR2,
556 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
557 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
558 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
559 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
560 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
561 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
562 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
563 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
564 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
565 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
566 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
567 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
568 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
569 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
570 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
571 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
572 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
573 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
574 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
575 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
576 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
577 X_EXCHANGE_RATE_TYPE IN VARCHAR2,
578 X_MIN_FC_INVOICE_OVERDUE_TYPE IN VARCHAR2,
579 X_MIN_FC_INVOICE_PERCENT IN NUMBER,
580 X_MIN_FC_BALANCE_OVERDUE_TYPE IN VARCHAR2,
581 X_MIN_FC_BALANCE_PERCENT IN NUMBER,
582 X_INTEREST_TYPE IN VARCHAR2,
583 X_INTEREST_FIXED_AMOUNT IN NUMBER,
584 X_INTEREST_SCHEDULE_ID IN NUMBER,
585 X_PENALTY_TYPE IN VARCHAR2,
586 X_PENALTY_RATE IN NUMBER,
587 X_MIN_INTEREST_CHARGE IN NUMBER,
588 X_PENALTY_FIXED_AMOUNT IN NUMBER,
589 X_PENALTY_SCHEDULE_ID IN NUMBER
590 ) IS
591
592 CURSOR C IS
593 SELECT * FROM HZ_CUST_PROF_CLASS_AMTS
594 WHERE ROWID = x_Rowid
595 FOR UPDATE NOWAIT;
596 Recinfo C%ROWTYPE;
597
598 BEGIN
599
600 OPEN C;
601 FETCH C INTO Recinfo;
602 IF ( C%NOTFOUND ) THEN
603 CLOSE C;
604 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
605 APP_EXCEPTION.RAISE_EXCEPTION;
606 END IF;
607 CLOSE C;
608
609 IF (
610 ( ( Recinfo.PROFILE_CLASS_AMOUNT_ID = X_PROFILE_CLASS_AMOUNT_ID )
611 OR ( ( Recinfo.PROFILE_CLASS_AMOUNT_ID IS NULL )
612 AND ( X_PROFILE_CLASS_AMOUNT_ID IS NULL ) ) )
613 AND ( ( Recinfo.LAST_UPDATED_BY = X_LAST_UPDATED_BY )
614 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
615 AND ( X_LAST_UPDATED_BY IS NULL ) ) )
616 AND ( ( Recinfo.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE )
620 OR ( ( Recinfo.CREATED_BY IS NULL )
617 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
618 AND ( X_LAST_UPDATE_DATE IS NULL ) ) )
619 AND ( ( Recinfo.CREATED_BY = X_CREATED_BY )
621 AND ( X_CREATED_BY IS NULL ) ) )
622 AND ( ( Recinfo.CREATION_DATE = X_CREATION_DATE )
623 OR ( ( Recinfo.CREATION_DATE IS NULL )
624 AND ( X_CREATION_DATE IS NULL ) ) )
625 AND ( ( Recinfo.REQUEST_ID = X_REQUEST_ID )
626 OR ( ( Recinfo.REQUEST_ID IS NULL )
627 AND ( X_REQUEST_ID IS NULL ) ) )
628 AND ( ( Recinfo.PROFILE_CLASS_ID = X_PROFILE_CLASS_ID )
629 OR ( ( Recinfo.PROFILE_CLASS_ID IS NULL )
630 AND ( X_PROFILE_CLASS_ID IS NULL ) ) )
631 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID )
632 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
633 AND ( X_PROGRAM_APPLICATION_ID IS NULL ) ) )
634 AND ( ( Recinfo.PROGRAM_ID = X_PROGRAM_ID )
635 OR ( ( Recinfo.PROGRAM_ID IS NULL )
636 AND ( X_PROGRAM_ID IS NULL ) ) )
637 AND ( ( Recinfo.CURRENCY_CODE = X_CURRENCY_CODE )
638 OR ( ( Recinfo.CURRENCY_CODE IS NULL )
639 AND ( X_CURRENCY_CODE IS NULL ) ) )
640 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE )
641 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
642 AND ( X_PROGRAM_UPDATE_DATE IS NULL ) ) )
643 AND ( ( Recinfo.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN )
644 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
645 AND ( X_LAST_UPDATE_LOGIN IS NULL ) ) )
646 AND ( ( Recinfo.TRX_CREDIT_LIMIT = X_TRX_CREDIT_LIMIT )
647 OR ( ( Recinfo.TRX_CREDIT_LIMIT IS NULL )
648 AND ( X_TRX_CREDIT_LIMIT IS NULL ) ) )
649 AND ( ( Recinfo.OVERALL_CREDIT_LIMIT = X_OVERALL_CREDIT_LIMIT )
650 OR ( ( Recinfo.OVERALL_CREDIT_LIMIT IS NULL )
651 AND ( X_OVERALL_CREDIT_LIMIT IS NULL ) ) )
652 AND ( ( Recinfo.MIN_DUNNING_AMOUNT = X_MIN_DUNNING_AMOUNT )
653 OR ( ( Recinfo.MIN_DUNNING_AMOUNT IS NULL )
654 AND ( X_MIN_DUNNING_AMOUNT IS NULL ) ) )
655 AND ( ( Recinfo.MAX_INTEREST_CHARGE = X_MAX_INTEREST_CHARGE )
656 OR ( ( Recinfo.MAX_INTEREST_CHARGE IS NULL )
657 AND ( X_MAX_INTEREST_CHARGE IS NULL ) ) )
658 AND ( ( Recinfo.MIN_STATEMENT_AMOUNT = X_MIN_STATEMENT_AMOUNT )
659 OR ( ( Recinfo.MIN_STATEMENT_AMOUNT IS NULL )
660 AND ( X_MIN_STATEMENT_AMOUNT IS NULL ) ) )
661 AND ( ( Recinfo.AUTO_REC_MIN_RECEIPT_AMOUNT = X_AUTO_REC_MIN_RECEIPT_AMOUNT )
662 OR ( ( Recinfo.AUTO_REC_MIN_RECEIPT_AMOUNT IS NULL )
663 AND ( X_AUTO_REC_MIN_RECEIPT_AMOUNT IS NULL ) ) )
664 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY )
665 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
666 AND ( X_ATTRIBUTE_CATEGORY IS NULL ) ) )
667 AND ( ( Recinfo.ATTRIBUTE1 = X_ATTRIBUTE1 )
668 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
669 AND ( X_ATTRIBUTE1 IS NULL ) ) )
670 AND ( ( Recinfo.ATTRIBUTE2 = X_ATTRIBUTE2 )
671 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
672 AND ( X_ATTRIBUTE2 IS NULL ) ) )
673 AND ( ( Recinfo.ATTRIBUTE3 = X_ATTRIBUTE3 )
674 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
675 AND ( X_ATTRIBUTE3 IS NULL ) ) )
676 AND ( ( Recinfo.ATTRIBUTE4 = X_ATTRIBUTE4 )
677 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
678 AND ( X_ATTRIBUTE4 IS NULL ) ) )
679 AND ( ( Recinfo.ATTRIBUTE5 = X_ATTRIBUTE5 )
680 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
681 AND ( X_ATTRIBUTE5 IS NULL ) ) )
682 AND ( ( Recinfo.ATTRIBUTE6 = X_ATTRIBUTE6 )
683 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
684 AND ( X_ATTRIBUTE6 IS NULL ) ) )
685 AND ( ( Recinfo.ATTRIBUTE7 = X_ATTRIBUTE7 )
686 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
687 AND ( X_ATTRIBUTE7 IS NULL ) ) )
688 AND ( ( Recinfo.ATTRIBUTE8 = X_ATTRIBUTE8 )
689 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
690 AND ( X_ATTRIBUTE8 IS NULL ) ) )
691 AND ( ( Recinfo.ATTRIBUTE9 = X_ATTRIBUTE9 )
692 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
693 AND ( X_ATTRIBUTE9 IS NULL ) ) )
694 AND ( ( Recinfo.ATTRIBUTE10 = X_ATTRIBUTE10 )
695 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
696 AND ( X_ATTRIBUTE10 IS NULL ) ) )
697 AND ( ( Recinfo.ATTRIBUTE11 = X_ATTRIBUTE11 )
698 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
699 AND ( X_ATTRIBUTE11 IS NULL ) ) )
700 AND ( ( Recinfo.ATTRIBUTE12 = X_ATTRIBUTE12 )
701 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
702 AND ( X_ATTRIBUTE12 IS NULL ) ) )
703 AND ( ( Recinfo.ATTRIBUTE13 = X_ATTRIBUTE13 )
704 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
705 AND ( X_ATTRIBUTE13 IS NULL ) ) )
706 AND ( ( Recinfo.ATTRIBUTE14 = X_ATTRIBUTE14 )
707 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
708 AND ( X_ATTRIBUTE14 IS NULL ) ) )
709 AND ( ( Recinfo.ATTRIBUTE15 = X_ATTRIBUTE15 )
710 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
711 AND ( X_ATTRIBUTE15 IS NULL ) ) )
712 AND ( ( Recinfo.INTEREST_RATE = X_INTEREST_RATE )
713 OR ( ( Recinfo.INTEREST_RATE IS NULL )
714 AND ( X_INTEREST_RATE IS NULL ) ) )
715 AND ( ( Recinfo.MIN_FC_BALANCE_AMOUNT = X_MIN_FC_BALANCE_AMOUNT )
716 OR ( ( Recinfo.MIN_FC_BALANCE_AMOUNT IS NULL )
717 AND ( X_MIN_FC_BALANCE_AMOUNT IS NULL ) ) )
718 AND ( ( Recinfo.MIN_FC_INVOICE_AMOUNT = X_MIN_FC_INVOICE_AMOUNT )
719 OR ( ( Recinfo.MIN_FC_INVOICE_AMOUNT IS NULL )
720 AND ( X_MIN_FC_INVOICE_AMOUNT IS NULL ) ) )
724 AND ( ( Recinfo.EXPIRATION_DATE = X_EXPIRATION_DATE )
721 AND ( ( Recinfo.MIN_DUNNING_INVOICE_AMOUNT = X_MIN_DUNNING_INVOICE_AMOUNT )
722 OR ( ( Recinfo.MIN_DUNNING_INVOICE_AMOUNT IS NULL )
723 AND ( X_MIN_DUNNING_INVOICE_AMOUNT IS NULL ) ) )
725 OR ( ( Recinfo.EXPIRATION_DATE IS NULL )
726 AND ( X_EXPIRATION_DATE IS NULL ) ) )
727 AND ( ( Recinfo.JGZZ_ATTRIBUTE_CATEGORY = X_JGZZ_ATTRIBUTE_CATEGORY )
728 OR ( ( Recinfo.JGZZ_ATTRIBUTE_CATEGORY IS NULL )
729 AND ( X_JGZZ_ATTRIBUTE_CATEGORY IS NULL ) ) )
730 AND ( ( Recinfo.JGZZ_ATTRIBUTE1 = X_JGZZ_ATTRIBUTE1 )
731 OR ( ( Recinfo.JGZZ_ATTRIBUTE1 IS NULL )
732 AND ( X_JGZZ_ATTRIBUTE1 IS NULL ) ) )
733 AND ( ( Recinfo.JGZZ_ATTRIBUTE2 = X_JGZZ_ATTRIBUTE2 )
734 OR ( ( Recinfo.JGZZ_ATTRIBUTE2 IS NULL )
735 AND ( X_JGZZ_ATTRIBUTE2 IS NULL ) ) )
736 AND ( ( Recinfo.JGZZ_ATTRIBUTE3 = X_JGZZ_ATTRIBUTE3 )
737 OR ( ( Recinfo.JGZZ_ATTRIBUTE3 IS NULL )
738 AND ( X_JGZZ_ATTRIBUTE3 IS NULL ) ) )
739 AND ( ( Recinfo.JGZZ_ATTRIBUTE4 = X_JGZZ_ATTRIBUTE4 )
740 OR ( ( Recinfo.JGZZ_ATTRIBUTE4 IS NULL )
741 AND ( X_JGZZ_ATTRIBUTE4 IS NULL ) ) )
742 AND ( ( Recinfo.JGZZ_ATTRIBUTE5 = X_JGZZ_ATTRIBUTE5 )
743 OR ( ( Recinfo.JGZZ_ATTRIBUTE5 IS NULL )
744 AND ( X_JGZZ_ATTRIBUTE5 IS NULL ) ) )
745 AND ( ( Recinfo.JGZZ_ATTRIBUTE6 = X_JGZZ_ATTRIBUTE6 )
746 OR ( ( Recinfo.JGZZ_ATTRIBUTE6 IS NULL )
747 AND ( X_JGZZ_ATTRIBUTE6 IS NULL ) ) )
748 AND ( ( Recinfo.JGZZ_ATTRIBUTE7 = X_JGZZ_ATTRIBUTE7 )
749 OR ( ( Recinfo.JGZZ_ATTRIBUTE7 IS NULL )
750 AND ( X_JGZZ_ATTRIBUTE7 IS NULL ) ) )
751 AND ( ( Recinfo.JGZZ_ATTRIBUTE8 = X_JGZZ_ATTRIBUTE8 )
752 OR ( ( Recinfo.JGZZ_ATTRIBUTE8 IS NULL )
753 AND ( X_JGZZ_ATTRIBUTE8 IS NULL ) ) )
754 AND ( ( Recinfo.JGZZ_ATTRIBUTE9 = X_JGZZ_ATTRIBUTE9 )
755 OR ( ( Recinfo.JGZZ_ATTRIBUTE9 IS NULL )
756 AND ( X_JGZZ_ATTRIBUTE9 IS NULL ) ) )
757 AND ( ( Recinfo.JGZZ_ATTRIBUTE10 = X_JGZZ_ATTRIBUTE10 )
758 OR ( ( Recinfo.JGZZ_ATTRIBUTE10 IS NULL )
759 AND ( X_JGZZ_ATTRIBUTE10 IS NULL ) ) )
760 AND ( ( Recinfo.JGZZ_ATTRIBUTE11 = X_JGZZ_ATTRIBUTE11 )
761 OR ( ( Recinfo.JGZZ_ATTRIBUTE11 IS NULL )
762 AND ( X_JGZZ_ATTRIBUTE11 IS NULL ) ) )
763 AND ( ( Recinfo.JGZZ_ATTRIBUTE12 = X_JGZZ_ATTRIBUTE12 )
764 OR ( ( Recinfo.JGZZ_ATTRIBUTE12 IS NULL )
765 AND ( X_JGZZ_ATTRIBUTE12 IS NULL ) ) )
766 AND ( ( Recinfo.JGZZ_ATTRIBUTE13 = X_JGZZ_ATTRIBUTE13 )
767 OR ( ( Recinfo.JGZZ_ATTRIBUTE13 IS NULL )
768 AND ( X_JGZZ_ATTRIBUTE13 IS NULL ) ) )
769 AND ( ( Recinfo.JGZZ_ATTRIBUTE14 = X_JGZZ_ATTRIBUTE14 )
770 OR ( ( Recinfo.JGZZ_ATTRIBUTE14 IS NULL )
771 AND ( X_JGZZ_ATTRIBUTE14 IS NULL ) ) )
772 AND ( ( Recinfo.JGZZ_ATTRIBUTE15 = X_JGZZ_ATTRIBUTE15 )
773 OR ( ( Recinfo.JGZZ_ATTRIBUTE15 IS NULL )
774 AND ( X_JGZZ_ATTRIBUTE15 IS NULL ) ) )
775 AND ( ( Recinfo.GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1 )
776 OR ( ( Recinfo.GLOBAL_ATTRIBUTE1 IS NULL )
777 AND ( X_GLOBAL_ATTRIBUTE1 IS NULL ) ) )
778 AND ( ( Recinfo.GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2 )
779 OR ( ( Recinfo.GLOBAL_ATTRIBUTE2 IS NULL )
780 AND ( X_GLOBAL_ATTRIBUTE2 IS NULL ) ) )
781 AND ( ( Recinfo.GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3 )
782 OR ( ( Recinfo.GLOBAL_ATTRIBUTE3 IS NULL )
783 AND ( X_GLOBAL_ATTRIBUTE3 IS NULL ) ) )
784 AND ( ( Recinfo.GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4 )
785 OR ( ( Recinfo.GLOBAL_ATTRIBUTE4 IS NULL )
786 AND ( X_GLOBAL_ATTRIBUTE4 IS NULL ) ) )
787 AND ( ( Recinfo.GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5 )
788 OR ( ( Recinfo.GLOBAL_ATTRIBUTE5 IS NULL )
789 AND ( X_GLOBAL_ATTRIBUTE5 IS NULL ) ) )
790 AND ( ( Recinfo.GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6 )
791 OR ( ( Recinfo.GLOBAL_ATTRIBUTE6 IS NULL )
792 AND ( X_GLOBAL_ATTRIBUTE6 IS NULL ) ) )
793 AND ( ( Recinfo.GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7 )
794 OR ( ( Recinfo.GLOBAL_ATTRIBUTE7 IS NULL )
795 AND ( X_GLOBAL_ATTRIBUTE7 IS NULL ) ) )
796 AND ( ( Recinfo.GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8 )
797 OR ( ( Recinfo.GLOBAL_ATTRIBUTE8 IS NULL )
798 AND ( X_GLOBAL_ATTRIBUTE8 IS NULL ) ) )
799 AND ( ( Recinfo.GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9 )
800 OR ( ( Recinfo.GLOBAL_ATTRIBUTE9 IS NULL )
801 AND ( X_GLOBAL_ATTRIBUTE9 IS NULL ) ) )
802 AND ( ( Recinfo.GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10 )
803 OR ( ( Recinfo.GLOBAL_ATTRIBUTE10 IS NULL )
804 AND ( X_GLOBAL_ATTRIBUTE10 IS NULL ) ) )
805 AND ( ( Recinfo.GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11 )
806 OR ( ( Recinfo.GLOBAL_ATTRIBUTE11 IS NULL )
807 AND ( X_GLOBAL_ATTRIBUTE11 IS NULL ) ) )
808 AND ( ( Recinfo.GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12 )
809 OR ( ( Recinfo.GLOBAL_ATTRIBUTE12 IS NULL )
810 AND ( X_GLOBAL_ATTRIBUTE12 IS NULL ) ) )
811 AND ( ( Recinfo.GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13 )
812 OR ( ( Recinfo.GLOBAL_ATTRIBUTE13 IS NULL )
813 AND ( X_GLOBAL_ATTRIBUTE13 IS NULL ) ) )
814 AND ( ( Recinfo.GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14 )
815 OR ( ( Recinfo.GLOBAL_ATTRIBUTE14 IS NULL )
816 AND ( X_GLOBAL_ATTRIBUTE14 IS NULL ) ) )
817 AND ( ( Recinfo.GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15 )
818 OR ( ( Recinfo.GLOBAL_ATTRIBUTE15 IS NULL )
822 AND ( X_GLOBAL_ATTRIBUTE16 IS NULL ) ) )
819 AND ( X_GLOBAL_ATTRIBUTE15 IS NULL ) ) )
820 AND ( ( Recinfo.GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16 )
821 OR ( ( Recinfo.GLOBAL_ATTRIBUTE16 IS NULL )
823 AND ( ( Recinfo.GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17 )
824 OR ( ( Recinfo.GLOBAL_ATTRIBUTE17 IS NULL )
825 AND ( X_GLOBAL_ATTRIBUTE17 IS NULL ) ) )
826 AND ( ( Recinfo.GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18 )
827 OR ( ( Recinfo.GLOBAL_ATTRIBUTE18 IS NULL )
828 AND ( X_GLOBAL_ATTRIBUTE18 IS NULL ) ) )
829 AND ( ( Recinfo.GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19 )
830 OR ( ( Recinfo.GLOBAL_ATTRIBUTE19 IS NULL )
831 AND ( X_GLOBAL_ATTRIBUTE19 IS NULL ) ) )
832 AND ( ( Recinfo.GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20 )
833 OR ( ( Recinfo.GLOBAL_ATTRIBUTE20 IS NULL )
834 AND ( X_GLOBAL_ATTRIBUTE20 IS NULL ) ) )
835 AND ( ( Recinfo.GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY )
836 OR ( ( Recinfo.GLOBAL_ATTRIBUTE_CATEGORY IS NULL )
837 AND ( X_GLOBAL_ATTRIBUTE_CATEGORY IS NULL ) ) )
838 AND ( ( Recinfo.EXCHANGE_RATE_TYPE = X_EXCHANGE_RATE_TYPE )
839 OR ( ( Recinfo.EXCHANGE_RATE_TYPE IS NULL )
840 AND ( X_EXCHANGE_RATE_TYPE IS NULL ) ) )
841 AND ( ( Recinfo.MIN_FC_INVOICE_OVERDUE_TYPE = X_MIN_FC_INVOICE_OVERDUE_TYPE )
842 OR ( ( Recinfo.MIN_FC_INVOICE_OVERDUE_TYPE IS NULL )
843 AND ( X_MIN_FC_INVOICE_OVERDUE_TYPE IS NULL ) ) )
844 AND ( ( Recinfo.MIN_FC_INVOICE_PERCENT = X_MIN_FC_INVOICE_PERCENT )
845 OR ( ( Recinfo.MIN_FC_INVOICE_PERCENT IS NULL )
846 AND ( X_MIN_FC_INVOICE_PERCENT IS NULL ) ) )
847 AND ( ( Recinfo.MIN_FC_BALANCE_OVERDUE_TYPE = X_MIN_FC_BALANCE_OVERDUE_TYPE )
848 OR ( ( Recinfo.MIN_FC_BALANCE_OVERDUE_TYPE IS NULL )
849 AND ( X_MIN_FC_BALANCE_OVERDUE_TYPE IS NULL ) ) )
850 AND ( ( Recinfo.MIN_FC_BALANCE_PERCENT = X_MIN_FC_BALANCE_PERCENT )
851 OR ( ( Recinfo.MIN_FC_BALANCE_PERCENT IS NULL )
852 AND ( X_MIN_FC_BALANCE_PERCENT IS NULL ) ) )
853 AND ( ( Recinfo.INTEREST_TYPE = X_INTEREST_TYPE )
854 OR ( ( Recinfo.INTEREST_TYPE IS NULL )
855 AND ( X_INTEREST_TYPE IS NULL ) ) )
856 AND ( ( Recinfo.INTEREST_FIXED_AMOUNT = X_INTEREST_FIXED_AMOUNT )
857 OR ( ( Recinfo.INTEREST_FIXED_AMOUNT IS NULL )
858 AND ( X_INTEREST_FIXED_AMOUNT IS NULL ) ) )
859 AND ( ( Recinfo.INTEREST_SCHEDULE_ID = X_INTEREST_SCHEDULE_ID )
860 OR ( ( Recinfo.INTEREST_SCHEDULE_ID IS NULL )
861 AND ( X_INTEREST_SCHEDULE_ID IS NULL ) ) )
862 AND ( ( Recinfo.PENALTY_TYPE = X_PENALTY_TYPE )
863 OR ( ( Recinfo.PENALTY_TYPE IS NULL )
864 AND ( X_PENALTY_TYPE IS NULL ) ) )
865 AND ( ( Recinfo.PENALTY_RATE = X_PENALTY_RATE )
866 OR ( ( Recinfo.PENALTY_RATE IS NULL )
867 AND ( X_PENALTY_RATE IS NULL ) ) )
868 AND ( ( Recinfo.MIN_INTEREST_CHARGE = X_MIN_INTEREST_CHARGE )
869 OR ( ( Recinfo.MIN_INTEREST_CHARGE IS NULL )
870 AND ( X_MIN_INTEREST_CHARGE IS NULL ) ) )
871 AND ( ( Recinfo.PENALTY_FIXED_AMOUNT = X_PENALTY_FIXED_AMOUNT )
872 OR ( ( Recinfo.PENALTY_FIXED_AMOUNT IS NULL )
873 AND ( X_PENALTY_FIXED_AMOUNT IS NULL ) ) )
874 AND ( ( Recinfo.PENALTY_SCHEDULE_ID = X_PENALTY_SCHEDULE_ID )
875 OR ( ( Recinfo.PENALTY_SCHEDULE_ID IS NULL )
876 AND ( X_PENALTY_SCHEDULE_ID IS NULL ) ) )
877 ) THEN
878 RETURN;
879 ELSE
880 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
881 APP_EXCEPTION.RAISE_EXCEPTION;
882 END IF;
883
884 END Lock_Row;
885
886 PROCEDURE Select_Row (
887 X_PROFILE_CLASS_AMOUNT_ID IN OUT NOCOPY NUMBER,
888 X_PROFILE_CLASS_ID OUT NOCOPY NUMBER,
889 X_CURRENCY_CODE OUT NOCOPY VARCHAR2,
890 X_TRX_CREDIT_LIMIT OUT NOCOPY NUMBER,
891 X_OVERALL_CREDIT_LIMIT OUT NOCOPY NUMBER,
892 X_MIN_DUNNING_AMOUNT OUT NOCOPY NUMBER,
893 X_MAX_INTEREST_CHARGE OUT NOCOPY NUMBER,
894 X_MIN_STATEMENT_AMOUNT OUT NOCOPY NUMBER,
895 X_AUTO_REC_MIN_RECEIPT_AMOUNT OUT NOCOPY NUMBER,
896 X_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
897 X_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
898 X_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
899 X_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
900 X_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
901 X_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
902 X_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
903 X_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
904 X_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
905 X_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
906 X_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
907 X_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
908 X_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
909 X_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
910 X_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
911 X_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
912 X_INTEREST_RATE OUT NOCOPY NUMBER,
916 X_EXPIRATION_DATE OUT NOCOPY DATE,
913 X_MIN_FC_BALANCE_AMOUNT OUT NOCOPY NUMBER,
914 X_MIN_FC_INVOICE_AMOUNT OUT NOCOPY NUMBER,
915 X_MIN_DUNNING_INVOICE_AMOUNT OUT NOCOPY NUMBER,
917 X_JGZZ_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
918 X_JGZZ_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
919 X_JGZZ_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
920 X_JGZZ_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
921 X_JGZZ_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
922 X_JGZZ_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
923 X_JGZZ_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
924 X_JGZZ_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
925 X_JGZZ_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
926 X_JGZZ_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
927 X_JGZZ_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
928 X_JGZZ_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
929 X_JGZZ_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
930 X_JGZZ_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
931 X_JGZZ_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
932 X_JGZZ_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
933 X_GLOBAL_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
934 X_GLOBAL_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
935 X_GLOBAL_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
936 X_GLOBAL_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
937 X_GLOBAL_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
938 X_GLOBAL_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
939 X_GLOBAL_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
940 X_GLOBAL_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
941 X_GLOBAL_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
942 X_GLOBAL_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
943 X_GLOBAL_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
944 X_GLOBAL_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
945 X_GLOBAL_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
946 X_GLOBAL_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
947 X_GLOBAL_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
948 X_GLOBAL_ATTRIBUTE16 OUT NOCOPY VARCHAR2,
949 X_GLOBAL_ATTRIBUTE17 OUT NOCOPY VARCHAR2,
950 X_GLOBAL_ATTRIBUTE18 OUT NOCOPY VARCHAR2,
951 X_GLOBAL_ATTRIBUTE19 OUT NOCOPY VARCHAR2,
952 X_GLOBAL_ATTRIBUTE20 OUT NOCOPY VARCHAR2,
953 X_GLOBAL_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
954 X_EXCHANGE_RATE_TYPE OUT NOCOPY VARCHAR2,
955 X_MIN_FC_INVOICE_OVERDUE_TYPE OUT NOCOPY VARCHAR2,
956 X_MIN_FC_INVOICE_PERCENT OUT NOCOPY NUMBER,
957 X_MIN_FC_BALANCE_OVERDUE_TYPE OUT NOCOPY VARCHAR2,
958 X_MIN_FC_BALANCE_PERCENT OUT NOCOPY NUMBER,
959 X_INTEREST_TYPE OUT NOCOPY VARCHAR2,
960 X_INTEREST_FIXED_AMOUNT OUT NOCOPY NUMBER,
961 X_INTEREST_SCHEDULE_ID OUT NOCOPY NUMBER,
962 X_PENALTY_TYPE OUT NOCOPY VARCHAR2,
963 X_PENALTY_RATE OUT NOCOPY NUMBER,
964 X_MIN_INTEREST_CHARGE OUT NOCOPY NUMBER,
965 X_PENALTY_FIXED_AMOUNT OUT NOCOPY NUMBER,
966 X_PENALTY_SCHEDULE_ID OUT NOCOPY NUMBER
967 ) IS
968
969 BEGIN
970
971 SELECT
972 NVL( PROFILE_CLASS_AMOUNT_ID, FND_API.G_MISS_NUM ),
973 NVL( PROFILE_CLASS_ID, FND_API.G_MISS_NUM ),
974 NVL( CURRENCY_CODE, FND_API.G_MISS_CHAR ),
975 NVL( TRX_CREDIT_LIMIT, FND_API.G_MISS_NUM ),
976 NVL( OVERALL_CREDIT_LIMIT, FND_API.G_MISS_NUM ),
977 NVL( MIN_DUNNING_AMOUNT, FND_API.G_MISS_NUM ),
978 NVL( MAX_INTEREST_CHARGE, FND_API.G_MISS_NUM ),
979 NVL( MIN_STATEMENT_AMOUNT, FND_API.G_MISS_NUM ),
980 NVL( AUTO_REC_MIN_RECEIPT_AMOUNT, FND_API.G_MISS_NUM ),
981 NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
982 NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
983 NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
984 NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
985 NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
986 NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
987 NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
988 NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
989 NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
990 NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
991 NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
992 NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
993 NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
994 NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
995 NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
996 NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
997 NVL( INTEREST_RATE, FND_API.G_MISS_NUM ),
998 NVL( MIN_FC_BALANCE_AMOUNT, FND_API.G_MISS_NUM ),
999 NVL( MIN_FC_INVOICE_AMOUNT, FND_API.G_MISS_NUM ),
1000 NVL( MIN_DUNNING_INVOICE_AMOUNT, FND_API.G_MISS_NUM ),
1001 NVL( EXPIRATION_DATE, FND_API.G_MISS_DATE ),
1002 NVL( JGZZ_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1003 NVL( JGZZ_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1004 NVL( JGZZ_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1005 NVL( JGZZ_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1006 NVL( JGZZ_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1010 NVL( JGZZ_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1007 NVL( JGZZ_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1008 NVL( JGZZ_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1009 NVL( JGZZ_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1011 NVL( JGZZ_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1012 NVL( JGZZ_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1013 NVL( JGZZ_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1014 NVL( JGZZ_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1015 NVL( JGZZ_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1016 NVL( JGZZ_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1017 NVL( JGZZ_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1018 NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1019 NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1020 NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1021 NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1022 NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1023 NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1024 NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1025 NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1026 NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1027 NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1028 NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1029 NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1030 NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1031 NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1032 NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1033 NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
1034 NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
1035 NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
1036 NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
1037 NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
1038 NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1039 NVL( EXCHANGE_RATE_TYPE, FND_API.G_MISS_CHAR ),
1040 NVL( MIN_FC_INVOICE_OVERDUE_TYPE, FND_API.G_MISS_CHAR ),
1041 NVL( MIN_FC_INVOICE_PERCENT, FND_API.G_MISS_NUM ),
1042 NVL( MIN_FC_BALANCE_OVERDUE_TYPE, FND_API.G_MISS_CHAR ),
1043 NVL( MIN_FC_BALANCE_PERCENT, FND_API.G_MISS_NUM ),
1044 NVL( INTEREST_TYPE, FND_API.G_MISS_CHAR ),
1045 NVL( INTEREST_FIXED_AMOUNT, FND_API.G_MISS_NUM ),
1046 NVL( INTEREST_SCHEDULE_ID, FND_API.G_MISS_NUM ),
1047 NVL( PENALTY_TYPE, FND_API.G_MISS_CHAR ),
1048 NVL( PENALTY_RATE, FND_API.G_MISS_NUM ),
1049 NVL( MIN_INTEREST_CHARGE, FND_API.G_MISS_NUM ),
1050 NVL( PENALTY_FIXED_AMOUNT, FND_API.G_MISS_NUM ),
1051 NVL( PENALTY_SCHEDULE_ID, FND_API.G_MISS_NUM )
1052 INTO
1053 X_PROFILE_CLASS_AMOUNT_ID,
1054 X_PROFILE_CLASS_ID,
1055 X_CURRENCY_CODE,
1056 X_TRX_CREDIT_LIMIT,
1057 X_OVERALL_CREDIT_LIMIT,
1058 X_MIN_DUNNING_AMOUNT,
1059 X_MAX_INTEREST_CHARGE,
1060 X_MIN_STATEMENT_AMOUNT,
1061 X_AUTO_REC_MIN_RECEIPT_AMOUNT,
1062 X_ATTRIBUTE_CATEGORY,
1063 X_ATTRIBUTE1,
1064 X_ATTRIBUTE2,
1065 X_ATTRIBUTE3,
1066 X_ATTRIBUTE4,
1067 X_ATTRIBUTE5,
1068 X_ATTRIBUTE6,
1069 X_ATTRIBUTE7,
1070 X_ATTRIBUTE8,
1071 X_ATTRIBUTE9,
1072 X_ATTRIBUTE10,
1073 X_ATTRIBUTE11,
1074 X_ATTRIBUTE12,
1075 X_ATTRIBUTE13,
1076 X_ATTRIBUTE14,
1077 X_ATTRIBUTE15,
1078 X_INTEREST_RATE,
1079 X_MIN_FC_BALANCE_AMOUNT,
1080 X_MIN_FC_INVOICE_AMOUNT,
1081 X_MIN_DUNNING_INVOICE_AMOUNT,
1082 X_EXPIRATION_DATE,
1083 X_JGZZ_ATTRIBUTE_CATEGORY,
1084 X_JGZZ_ATTRIBUTE1,
1085 X_JGZZ_ATTRIBUTE2,
1086 X_JGZZ_ATTRIBUTE3,
1087 X_JGZZ_ATTRIBUTE4,
1088 X_JGZZ_ATTRIBUTE5,
1089 X_JGZZ_ATTRIBUTE6,
1090 X_JGZZ_ATTRIBUTE7,
1091 X_JGZZ_ATTRIBUTE8,
1092 X_JGZZ_ATTRIBUTE9,
1093 X_JGZZ_ATTRIBUTE10,
1094 X_JGZZ_ATTRIBUTE11,
1095 X_JGZZ_ATTRIBUTE12,
1096 X_JGZZ_ATTRIBUTE13,
1097 X_JGZZ_ATTRIBUTE14,
1098 X_JGZZ_ATTRIBUTE15,
1099 X_GLOBAL_ATTRIBUTE1,
1100 X_GLOBAL_ATTRIBUTE2,
1101 X_GLOBAL_ATTRIBUTE3,
1102 X_GLOBAL_ATTRIBUTE4,
1103 X_GLOBAL_ATTRIBUTE5,
1104 X_GLOBAL_ATTRIBUTE6,
1105 X_GLOBAL_ATTRIBUTE7,
1106 X_GLOBAL_ATTRIBUTE8,
1107 X_GLOBAL_ATTRIBUTE9,
1108 X_GLOBAL_ATTRIBUTE10,
1109 X_GLOBAL_ATTRIBUTE11,
1110 X_GLOBAL_ATTRIBUTE12,
1111 X_GLOBAL_ATTRIBUTE13,
1112 X_GLOBAL_ATTRIBUTE14,
1113 X_GLOBAL_ATTRIBUTE15,
1114 X_GLOBAL_ATTRIBUTE16,
1115 X_GLOBAL_ATTRIBUTE17,
1116 X_GLOBAL_ATTRIBUTE18,
1117 X_GLOBAL_ATTRIBUTE19,
1118 X_GLOBAL_ATTRIBUTE20,
1119 X_GLOBAL_ATTRIBUTE_CATEGORY,
1120 X_EXCHANGE_RATE_TYPE,
1121 X_MIN_FC_INVOICE_OVERDUE_TYPE,
1122 X_MIN_FC_INVOICE_PERCENT,
1123 X_MIN_FC_BALANCE_OVERDUE_TYPE,
1124 X_MIN_FC_BALANCE_PERCENT,
1125 X_INTEREST_TYPE,
1126 X_INTEREST_FIXED_AMOUNT,
1127 X_INTEREST_SCHEDULE_ID,
1128 X_PENALTY_TYPE,
1129 X_PENALTY_RATE,
1130 X_MIN_INTEREST_CHARGE,
1131 X_PENALTY_FIXED_AMOUNT,
1132 X_PENALTY_SCHEDULE_ID
1133 FROM HZ_CUST_PROF_CLASS_AMTS
1134 WHERE PROFILE_CLASS_AMOUNT_ID = X_PROFILE_CLASS_AMOUNT_ID;
1135
1136 EXCEPTION
1137 WHEN NO_DATA_FOUND THEN
1138 FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1139 FND_MESSAGE.SET_TOKEN( 'RECORD', 'cust_prof_class_amt_rec');
1140 FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_PROFILE_CLASS_AMOUNT_ID ) );
1141 FND_MSG_PUB.ADD;
1142 RAISE FND_API.G_EXC_ERROR;
1143
1144 END Select_Row;
1145
1146 PROCEDURE Delete_Row (
1147 X_PROFILE_CLASS_AMOUNT_ID IN NUMBER
1148 ) IS
1149
1150 BEGIN
1151
1152 DELETE FROM HZ_CUST_PROF_CLASS_AMTS
1153 WHERE PROFILE_CLASS_AMOUNT_ID = X_PROFILE_CLASS_AMOUNT_ID;
1154
1155 IF ( SQL%NOTFOUND ) THEN
1156 RAISE NO_DATA_FOUND;
1157 END IF;
1158
1159 END Delete_Row;
1160
1161 END HZ_CUST_PROF_CLASS_AMTS_PKG;