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