[Home] [Help]
PACKAGE BODY: APPS.HZ_CUSTOMER_PROFILES_PKG
Source
1 PACKAGE BODY HZ_CUSTOMER_PROFILES_PKG AS
2 /*$Header: ARHCPFTB.pls 120.13.12010000.4 2008/11/04 09:41:01 avjha ship $ */
3
4 PROCEDURE Insert_Row (
5 X_CUST_ACCOUNT_PROFILE_ID IN OUT NOCOPY NUMBER,
6 X_CUST_ACCOUNT_ID IN NUMBER,
7 X_STATUS IN VARCHAR2,
8 X_COLLECTOR_ID IN NUMBER,
9 X_CREDIT_ANALYST_ID IN NUMBER,
10 X_CREDIT_CHECKING IN VARCHAR2,
11 X_NEXT_CREDIT_REVIEW_DATE IN DATE,
12 X_TOLERANCE IN NUMBER,
13 X_DISCOUNT_TERMS IN VARCHAR2,
14 X_DUNNING_LETTERS IN VARCHAR2,
15 X_INTEREST_CHARGES IN VARCHAR2,
16 X_SEND_STATEMENTS IN VARCHAR2,
17 X_CREDIT_BALANCE_STATEMENTS IN VARCHAR2,
18 X_CREDIT_HOLD IN VARCHAR2,
19 X_PROFILE_CLASS_ID IN NUMBER,
20 X_SITE_USE_ID IN NUMBER,
21 X_CREDIT_RATING IN VARCHAR2,
22 X_RISK_CODE IN VARCHAR2,
23 X_STANDARD_TERMS IN NUMBER,
24 X_OVERRIDE_TERMS IN VARCHAR2,
25 X_DUNNING_LETTER_SET_ID IN NUMBER,
26 X_INTEREST_PERIOD_DAYS IN NUMBER,
27 X_PAYMENT_GRACE_DAYS IN NUMBER,
28 X_DISCOUNT_GRACE_DAYS IN NUMBER,
29 X_STATEMENT_CYCLE_ID IN NUMBER,
30 X_ACCOUNT_STATUS IN VARCHAR2,
31 X_PERCENT_COLLECTABLE IN NUMBER,
32 X_AUTOCASH_HIERARCHY_ID IN NUMBER,
33 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
34 X_ATTRIBUTE1 IN VARCHAR2,
35 X_ATTRIBUTE2 IN VARCHAR2,
36 X_ATTRIBUTE3 IN VARCHAR2,
37 X_ATTRIBUTE4 IN VARCHAR2,
38 X_ATTRIBUTE5 IN VARCHAR2,
39 X_ATTRIBUTE6 IN VARCHAR2,
40 X_ATTRIBUTE7 IN VARCHAR2,
41 X_ATTRIBUTE8 IN VARCHAR2,
42 X_ATTRIBUTE9 IN VARCHAR2,
43 X_ATTRIBUTE10 IN VARCHAR2,
44 X_ATTRIBUTE11 IN VARCHAR2,
45 X_ATTRIBUTE12 IN VARCHAR2,
46 X_ATTRIBUTE13 IN VARCHAR2,
47 X_ATTRIBUTE14 IN VARCHAR2,
48 X_ATTRIBUTE15 IN VARCHAR2,
49 X_AUTO_REC_INCL_DISPUTED_FLAG IN VARCHAR2,
50 X_TAX_PRINTING_OPTION IN VARCHAR2,
51 X_CHARGE_ON_FINANCE_CHARGE_FG IN VARCHAR2,
52 X_GROUPING_RULE_ID IN NUMBER,
53 X_CLEARING_DAYS IN NUMBER,
54 X_JGZZ_ATTRIBUTE_CATEGORY IN VARCHAR2,
55 X_JGZZ_ATTRIBUTE1 IN VARCHAR2,
56 X_JGZZ_ATTRIBUTE2 IN VARCHAR2,
57 X_JGZZ_ATTRIBUTE3 IN VARCHAR2,
58 X_JGZZ_ATTRIBUTE4 IN VARCHAR2,
59 X_JGZZ_ATTRIBUTE5 IN VARCHAR2,
60 X_JGZZ_ATTRIBUTE6 IN VARCHAR2,
61 X_JGZZ_ATTRIBUTE7 IN VARCHAR2,
62 X_JGZZ_ATTRIBUTE8 IN VARCHAR2,
63 X_JGZZ_ATTRIBUTE9 IN VARCHAR2,
64 X_JGZZ_ATTRIBUTE10 IN VARCHAR2,
65 X_JGZZ_ATTRIBUTE11 IN VARCHAR2,
66 X_JGZZ_ATTRIBUTE12 IN VARCHAR2,
67 X_JGZZ_ATTRIBUTE13 IN VARCHAR2,
68 X_JGZZ_ATTRIBUTE14 IN VARCHAR2,
69 X_JGZZ_ATTRIBUTE15 IN VARCHAR2,
70 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
71 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
72 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
73 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
74 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
75 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
76 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
77 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
78 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
79 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
80 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
81 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
82 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
83 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
84 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
85 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
86 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
87 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
88 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
89 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
90 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
91 X_CONS_INV_FLAG IN VARCHAR2,
92 X_CONS_INV_TYPE IN VARCHAR2,
93 X_AUTOCASH_HIERARCHY_ID_ADR IN NUMBER,
94 X_LOCKBOX_MATCHING_OPTION IN VARCHAR2,
95 X_OBJECT_VERSION_NUMBER IN NUMBER,
96 X_CREATED_BY_MODULE IN VARCHAR2,
97 X_APPLICATION_ID IN NUMBER,
98 X_REVIEW_CYCLE IN VARCHAR2 ,
99 X_LAST_CREDIT_REVIEW_DATE IN DATE ,
100 X_PARTY_ID IN NUMBER ,
101 X_CREDIT_CLASSIFICATION IN VARCHAR2,
102 X_CONS_BILL_LEVEL IN VARCHAR2,
103 X_LATE_CHARGE_CALCULATION_TRX IN VARCHAR2,
104 X_CREDIT_ITEMS_FLAG IN VARCHAR2,
105 X_DISPUTED_TRANSACTIONS_FLAG IN VARCHAR2,
106 X_LATE_CHARGE_TYPE IN VARCHAR2,
107 X_LATE_CHARGE_TERM_ID IN NUMBER,
108 X_INTEREST_CALCULATION_PERIOD IN VARCHAR2,
109 X_HOLD_CHARGED_INVOICES_FLAG IN VARCHAR2,
110 X_MESSAGE_TEXT_ID IN NUMBER,
111 X_MULTIPLE_INTEREST_RATES_FLAG IN VARCHAR2,
112 X_CHARGE_BEGIN_DATE IN DATE
113 ) IS
114
115 l_success VARCHAR2(1) := 'N';
116
117 l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
118
119 BEGIN
120
121 -- x_profile_class_id is defaulted to default profile class id
122 -- before calling table handler.
123
124 SELECT * INTO l_profile_class_rec
125 FROM HZ_CUST_PROFILE_CLASSES
126 WHERE PROFILE_CLASS_ID = X_PROFILE_CLASS_ID;
127
128 WHILE l_success = 'N' LOOP
129 BEGIN
130 INSERT INTO HZ_CUSTOMER_PROFILES (
131 CUST_ACCOUNT_PROFILE_ID,
132 LAST_UPDATED_BY,
133 LAST_UPDATE_DATE,
134 LAST_UPDATE_LOGIN,
135 CREATED_BY,
136 CREATION_DATE,
137 CUST_ACCOUNT_ID,
138 STATUS,
139 COLLECTOR_ID,
140 CREDIT_ANALYST_ID,
141 CREDIT_CHECKING,
142 NEXT_CREDIT_REVIEW_DATE,
143 TOLERANCE,
144 DISCOUNT_TERMS,
145 DUNNING_LETTERS,
146 INTEREST_CHARGES,
147 SEND_STATEMENTS,
148 CREDIT_BALANCE_STATEMENTS,
149 CREDIT_HOLD,
150 PROFILE_CLASS_ID,
151 SITE_USE_ID,
152 CREDIT_RATING,
153 RISK_CODE,
154 STANDARD_TERMS,
155 OVERRIDE_TERMS,
156 DUNNING_LETTER_SET_ID,
157 INTEREST_PERIOD_DAYS,
158 PAYMENT_GRACE_DAYS,
159 DISCOUNT_GRACE_DAYS,
160 STATEMENT_CYCLE_ID,
161 ACCOUNT_STATUS,
162 PERCENT_COLLECTABLE,
163 AUTOCASH_HIERARCHY_ID,
164 ATTRIBUTE_CATEGORY,
165 ATTRIBUTE1,
166 ATTRIBUTE2,
167 ATTRIBUTE3,
168 ATTRIBUTE4,
169 ATTRIBUTE5,
170 ATTRIBUTE6,
171 ATTRIBUTE7,
172 ATTRIBUTE8,
173 ATTRIBUTE9,
174 ATTRIBUTE10,
175 PROGRAM_APPLICATION_ID,
176 PROGRAM_ID,
177 PROGRAM_UPDATE_DATE,
178 REQUEST_ID,
179 ATTRIBUTE11,
180 ATTRIBUTE12,
181 ATTRIBUTE13,
182 ATTRIBUTE14,
183 ATTRIBUTE15,
184 AUTO_REC_INCL_DISPUTED_FLAG,
185 TAX_PRINTING_OPTION,
186 CHARGE_ON_FINANCE_CHARGE_FLAG,
187 GROUPING_RULE_ID,
188 CLEARING_DAYS,
189 JGZZ_ATTRIBUTE_CATEGORY,
190 JGZZ_ATTRIBUTE1,
191 JGZZ_ATTRIBUTE2,
192 JGZZ_ATTRIBUTE3,
193 JGZZ_ATTRIBUTE4,
194 JGZZ_ATTRIBUTE5,
195 JGZZ_ATTRIBUTE6,
196 JGZZ_ATTRIBUTE7,
197 JGZZ_ATTRIBUTE8,
198 JGZZ_ATTRIBUTE9,
199 JGZZ_ATTRIBUTE10,
200 JGZZ_ATTRIBUTE11,
201 JGZZ_ATTRIBUTE12,
202 JGZZ_ATTRIBUTE13,
203 JGZZ_ATTRIBUTE14,
204 JGZZ_ATTRIBUTE15,
205 GLOBAL_ATTRIBUTE1,
206 GLOBAL_ATTRIBUTE2,
207 GLOBAL_ATTRIBUTE3,
208 GLOBAL_ATTRIBUTE4,
209 GLOBAL_ATTRIBUTE5,
210 GLOBAL_ATTRIBUTE6,
211 GLOBAL_ATTRIBUTE7,
212 GLOBAL_ATTRIBUTE8,
213 GLOBAL_ATTRIBUTE9,
214 GLOBAL_ATTRIBUTE10,
215 GLOBAL_ATTRIBUTE11,
216 GLOBAL_ATTRIBUTE12,
217 GLOBAL_ATTRIBUTE13,
218 GLOBAL_ATTRIBUTE14,
219 GLOBAL_ATTRIBUTE15,
220 GLOBAL_ATTRIBUTE16,
221 GLOBAL_ATTRIBUTE17,
222 GLOBAL_ATTRIBUTE18,
223 GLOBAL_ATTRIBUTE19,
224 GLOBAL_ATTRIBUTE20,
225 GLOBAL_ATTRIBUTE_CATEGORY,
226 CONS_INV_FLAG,
227 CONS_INV_TYPE,
228 AUTOCASH_HIERARCHY_ID_FOR_ADR,
229 LOCKBOX_MATCHING_OPTION,
230 OBJECT_VERSION_NUMBER,
231 CREATED_BY_MODULE,
232 APPLICATION_ID,
233 REVIEW_CYCLE ,
234 LAST_CREDIT_REVIEW_DATE,
235 PARTY_ID,
236 CREDIT_CLASSIFICATION,
237 CONS_BILL_LEVEL,
238 LATE_CHARGE_CALCULATION_TRX,
239 CREDIT_ITEMS_FLAG,
240 DISPUTED_TRANSACTIONS_FLAG,
241 LATE_CHARGE_TYPE,
242 LATE_CHARGE_TERM_ID,
243 INTEREST_CALCULATION_PERIOD,
244 HOLD_CHARGED_INVOICES_FLAG,
245 MESSAGE_TEXT_ID,
246 MULTIPLE_INTEREST_RATES_FLAG,
247 CHARGE_BEGIN_DATE
248 )
249 VALUES (
250 DECODE( X_CUST_ACCOUNT_PROFILE_ID, FND_API.G_MISS_NUM, HZ_CUSTOMER_PROFILES_S.NEXTVAL, NULL, HZ_CUSTOMER_PROFILES_S.NEXTVAL, X_CUST_ACCOUNT_PROFILE_ID ),
251 HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
252 HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
253 HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
254 HZ_UTILITY_V2PUB.CREATED_BY,
255 HZ_UTILITY_V2PUB.CREATION_DATE,
256 DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
257 DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
258 DECODE( X_COLLECTOR_ID, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.collector_id, X_COLLECTOR_ID ),
259 DECODE( X_CREDIT_ANALYST_ID, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.credit_analyst_id, X_CREDIT_ANALYST_ID ),
260 DECODE( X_CREDIT_CHECKING, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.credit_checking, X_CREDIT_CHECKING ),
261 DECODE( X_NEXT_CREDIT_REVIEW_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_NEXT_CREDIT_REVIEW_DATE ),
262 DECODE( X_TOLERANCE, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.tolerance, X_TOLERANCE ),
263 DECODE( X_DISCOUNT_TERMS, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.discount_terms, X_DISCOUNT_TERMS ),
264 DECODE( X_DUNNING_LETTERS, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.dunning_letters, X_DUNNING_LETTERS ),
265 DECODE( X_INTEREST_CHARGES, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.interest_charges, X_INTEREST_CHARGES ),
266 DECODE( X_SEND_STATEMENTS, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.statements, X_SEND_STATEMENTS ),
267 DECODE( X_CREDIT_BALANCE_STATEMENTS, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.credit_balance_statements, X_CREDIT_BALANCE_STATEMENTS ),
268 DECODE( X_CREDIT_HOLD, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_CREDIT_HOLD ),
269 DECODE( X_PROFILE_CLASS_ID, FND_API.G_MISS_NUM, NULL, X_PROFILE_CLASS_ID ),
270 DECODE( X_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_SITE_USE_ID ),
271 DECODE( X_CREDIT_RATING, FND_API.G_MISS_CHAR, NULL, X_CREDIT_RATING ),
272 DECODE( X_RISK_CODE, FND_API.G_MISS_CHAR, NULL, X_RISK_CODE ),
273 DECODE( X_STANDARD_TERMS, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.standard_terms, X_STANDARD_TERMS ),
274 DECODE( X_OVERRIDE_TERMS, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.override_terms, X_OVERRIDE_TERMS ),
275 --DECODE( X_DUNNING_LETTER_SET_ID, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.dunning_letter_set_id, X_DUNNING_LETTER_SET_ID ),
276 DECODE( X_DUNNING_LETTER_SET_ID,FND_API.G_MISS_NUM, NULL, NULL,decode(nvl(X_DUNNING_LETTERS,l_profile_class_rec.dunning_letters),'Y',l_profile_class_rec.dunning_letter_set_id,X_DUNNING_LETTER_SET_ID),X_DUNNING_LETTER_SET_ID ),
277 DECODE( X_INTEREST_PERIOD_DAYS, FND_API.G_MISS_NUM, NULL,NULL,decode(nvl(X_INTEREST_CHARGES,l_profile_class_rec.interest_charges),'Y',l_profile_class_rec.interest_period_days,X_INTEREST_PERIOD_DAYS),X_INTEREST_PERIOD_DAYS ),
278 DECODE( X_PAYMENT_GRACE_DAYS, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.payment_grace_days, X_PAYMENT_GRACE_DAYS ),
279 DECODE( X_DISCOUNT_GRACE_DAYS, FND_API.G_MISS_NUM, NULL, NULL,decode(nvl(x_discount_terms,l_profile_class_rec.discount_terms),'Y',l_profile_class_rec.discount_grace_days,NULL), X_DISCOUNT_GRACE_DAYS ),
280 --DECODE( X_STATEMENT_CYCLE_ID, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.statement_cycle_id, X_STATEMENT_CYCLE_ID ),
281 DECODE( X_STATEMENT_CYCLE_ID, FND_API.G_MISS_NUM, NULL, NULL,decode(nvl(X_SEND_STATEMENTS,l_profile_class_rec.statements),'Y',l_profile_class_rec.statement_cycle_id, X_STATEMENT_CYCLE_ID), X_STATEMENT_CYCLE_ID),
282 DECODE( X_ACCOUNT_STATUS, FND_API.G_MISS_CHAR, NULL, X_ACCOUNT_STATUS ),
283 DECODE( X_PERCENT_COLLECTABLE, FND_API.G_MISS_NUM, NULL, X_PERCENT_COLLECTABLE ),
284 DECODE( X_AUTOCASH_HIERARCHY_ID, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.autocash_hierarchy_id, X_AUTOCASH_HIERARCHY_ID ),
285 DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute_category, X_ATTRIBUTE_CATEGORY ),
286 DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute1, X_ATTRIBUTE1 ),
287 DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute2, X_ATTRIBUTE2 ),
288 DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute3, X_ATTRIBUTE3 ),
289 DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute4, X_ATTRIBUTE4 ),
290 DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute5, X_ATTRIBUTE5 ),
291 DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute6, X_ATTRIBUTE6 ),
292 DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute7, X_ATTRIBUTE7 ),
293 DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute8, X_ATTRIBUTE8 ),
294 DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute9, X_ATTRIBUTE9 ),
295 DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute10, X_ATTRIBUTE10 ),
296 HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
297 HZ_UTILITY_V2PUB.PROGRAM_ID,
298 HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
299 HZ_UTILITY_V2PUB.REQUEST_ID,
300 DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute11, X_ATTRIBUTE11 ),
301 DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute12, X_ATTRIBUTE12 ),
302 DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute13, X_ATTRIBUTE13 ),
303 DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute14, X_ATTRIBUTE14 ),
304 DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute15, X_ATTRIBUTE15 ),
305 DECODE( X_AUTO_REC_INCL_DISPUTED_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.auto_rec_incl_disputed_flag, X_AUTO_REC_INCL_DISPUTED_FLAG ),
306 DECODE( X_TAX_PRINTING_OPTION, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.tax_printing_option, X_TAX_PRINTING_OPTION ),
307 DECODE( X_CHARGE_ON_FINANCE_CHARGE_FG, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.charge_on_finance_charge_flag, X_CHARGE_ON_FINANCE_CHARGE_FG ),
308 DECODE( X_GROUPING_RULE_ID, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.grouping_rule_id, X_GROUPING_RULE_ID ),
309 DECODE( X_CLEARING_DAYS, FND_API.G_MISS_NUM, NULL, X_CLEARING_DAYS ),
310 DECODE( X_JGZZ_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute_category, X_JGZZ_ATTRIBUTE_CATEGORY ),
311 DECODE( X_JGZZ_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute1, X_JGZZ_ATTRIBUTE1 ),
312 DECODE( X_JGZZ_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute2, X_JGZZ_ATTRIBUTE2 ),
313 DECODE( X_JGZZ_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute3, X_JGZZ_ATTRIBUTE3 ),
314 DECODE( X_JGZZ_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute4, X_JGZZ_ATTRIBUTE4 ),
315 DECODE( X_JGZZ_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute5, X_JGZZ_ATTRIBUTE5 ),
316 DECODE( X_JGZZ_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute6, X_JGZZ_ATTRIBUTE6 ),
317 DECODE( X_JGZZ_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute7, X_JGZZ_ATTRIBUTE7 ),
318 DECODE( X_JGZZ_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute8, X_JGZZ_ATTRIBUTE8 ),
319 DECODE( X_JGZZ_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute9, X_JGZZ_ATTRIBUTE9 ),
320 DECODE( X_JGZZ_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute10, X_JGZZ_ATTRIBUTE10 ),
321 DECODE( X_JGZZ_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute11, X_JGZZ_ATTRIBUTE11 ),
322 DECODE( X_JGZZ_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute12, X_JGZZ_ATTRIBUTE12 ),
323 DECODE( X_JGZZ_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute13, X_JGZZ_ATTRIBUTE13 ),
324 DECODE( X_JGZZ_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute14, X_JGZZ_ATTRIBUTE14 ),
325 DECODE( X_JGZZ_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.jgzz_attribute15, X_JGZZ_ATTRIBUTE15 ),
326 DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute1, X_GLOBAL_ATTRIBUTE1 ),
327 DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute2, X_GLOBAL_ATTRIBUTE2 ),
328 DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute3, X_GLOBAL_ATTRIBUTE3 ),
329 DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute4, X_GLOBAL_ATTRIBUTE4 ),
330 DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute5, X_GLOBAL_ATTRIBUTE5 ),
331 DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute6, X_GLOBAL_ATTRIBUTE6 ),
332 DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute7, X_GLOBAL_ATTRIBUTE7 ),
333 DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute8, X_GLOBAL_ATTRIBUTE8 ),
334 DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute9, X_GLOBAL_ATTRIBUTE9 ),
335 DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute10, X_GLOBAL_ATTRIBUTE10 ),
336 DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute11, X_GLOBAL_ATTRIBUTE11 ),
337 DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute12, X_GLOBAL_ATTRIBUTE12 ),
338 DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute13, X_GLOBAL_ATTRIBUTE13 ),
339 DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute14, X_GLOBAL_ATTRIBUTE14 ),
340 DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute15, X_GLOBAL_ATTRIBUTE15 ),
341 DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute16, X_GLOBAL_ATTRIBUTE16 ),
342 DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute17, X_GLOBAL_ATTRIBUTE17 ),
343 DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute18, X_GLOBAL_ATTRIBUTE18 ),
344 DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute19, X_GLOBAL_ATTRIBUTE19 ),
345 DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute20, X_GLOBAL_ATTRIBUTE20 ),
346 DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.global_attribute_category, X_GLOBAL_ATTRIBUTE_CATEGORY ),
347 DECODE( X_CONS_INV_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.cons_inv_flag, X_CONS_INV_FLAG ),
348 DECODE( X_CONS_INV_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.cons_inv_type, X_CONS_INV_TYPE ),
349 DECODE( X_AUTOCASH_HIERARCHY_ID_ADR, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.autocash_hierarchy_id_for_adr, X_AUTOCASH_HIERARCHY_ID_ADR ),
350 DECODE( X_LOCKBOX_MATCHING_OPTION, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.lockbox_matching_option, X_LOCKBOX_MATCHING_OPTION ),
351 DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
352 DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
353 DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
354 DECODE( X_REVIEW_CYCLE, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.review_cycle, X_REVIEW_CYCLE),
355 DECODE( X_LAST_CREDIT_REVIEW_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), X_LAST_CREDIT_REVIEW_DATE ),
356 DECODE( X_PARTY_ID , FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
357 DECODE( X_CREDIT_CLASSIFICATION ,FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.credit_classification, X_CREDIT_CLASSIFICATION ),
358 DECODE( X_CONS_BILL_LEVEL, FND_API.G_MISS_CHAR, NULL, X_CONS_BILL_LEVEL),
359 DECODE( X_LATE_CHARGE_CALCULATION_TRX, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.late_charge_calculation_trx, X_LATE_CHARGE_CALCULATION_TRX ),
360 DECODE( X_CREDIT_ITEMS_FLAG, FND_API.G_MISS_CHAR, NULL, X_CREDIT_ITEMS_FLAG),
361 DECODE( X_DISPUTED_TRANSACTIONS_FLAG, FND_API.G_MISS_CHAR, NULL, X_DISPUTED_TRANSACTIONS_FLAG),
362 DECODE( X_LATE_CHARGE_TYPE, FND_API.G_MISS_CHAR, NULL, X_LATE_CHARGE_TYPE),
363 DECODE( X_LATE_CHARGE_TERM_ID, FND_API.G_MISS_NUM, NULL, X_LATE_CHARGE_TERM_ID),
364 DECODE( X_INTEREST_CALCULATION_PERIOD, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.INTEREST_CALCULATION_PERIOD, X_INTEREST_CALCULATION_PERIOD),
365 DECODE( X_HOLD_CHARGED_INVOICES_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.HOLD_CHARGED_INVOICES_FLAG, X_HOLD_CHARGED_INVOICES_FLAG),
366 DECODE( X_MESSAGE_TEXT_ID, FND_API.G_MISS_NUM, NULL, X_MESSAGE_TEXT_ID),
367 DECODE( X_MULTIPLE_INTEREST_RATES_FLAG, FND_API.G_MISS_CHAR, NULL, X_MULTIPLE_INTEREST_RATES_FLAG),
368 DECODE( X_CHARGE_BEGIN_DATE, FND_API.G_MISS_DATE, NULL, X_CHARGE_BEGIN_DATE)
369 ) RETURNING
370 CUST_ACCOUNT_PROFILE_ID
371 INTO
372 X_CUST_ACCOUNT_PROFILE_ID;
373
374 l_success := 'Y';
375
376 EXCEPTION
377 WHEN DUP_VAL_ON_INDEX THEN
378 IF INSTRB( SQLERRM, 'HZ_CUSTOMER_PROFILES_U1' ) <> 0 OR
379 INSTRB( SQLERRM, 'HZ_CUSTOMER_PROFILES_PK' ) <> 0
380 THEN
381 DECLARE
382 l_count NUMBER;
383 l_dummy VARCHAR2(1);
384 BEGIN
385 l_count := 1;
386 WHILE l_count > 0 LOOP
387 SELECT HZ_CUSTOMER_PROFILES_S.NEXTVAL
388 INTO X_CUST_ACCOUNT_PROFILE_ID FROM dual;
389 BEGIN
390 SELECT 'Y' INTO l_dummy
391 FROM HZ_CUSTOMER_PROFILES
392 WHERE CUST_ACCOUNT_PROFILE_ID = X_CUST_ACCOUNT_PROFILE_ID;
393 l_count := 1;
394 EXCEPTION
395 WHEN NO_DATA_FOUND THEN
396 l_count := 0;
397 END;
398 END LOOP;
399 END;
400 ELSE
401 RAISE;
402 END IF;
403
404 END;
405 END LOOP;
406
407 END Insert_Row;
408
409 PROCEDURE Update_Row (
410 X_Rowid IN OUT NOCOPY VARCHAR2,
411 X_CUST_ACCOUNT_PROFILE_ID IN NUMBER,
412 X_CUST_ACCOUNT_ID IN NUMBER,
413 X_STATUS IN VARCHAR2,
414 X_COLLECTOR_ID IN NUMBER,
415 X_CREDIT_ANALYST_ID IN NUMBER,
416 X_CREDIT_CHECKING IN VARCHAR2,
417 X_NEXT_CREDIT_REVIEW_DATE IN DATE,
418 X_TOLERANCE IN NUMBER,
419 X_DISCOUNT_TERMS IN VARCHAR2,
420 X_DUNNING_LETTERS IN VARCHAR2,
421 X_INTEREST_CHARGES IN VARCHAR2,
422 X_SEND_STATEMENTS IN VARCHAR2,
423 X_CREDIT_BALANCE_STATEMENTS IN VARCHAR2,
424 X_CREDIT_HOLD IN VARCHAR2,
425 X_PROFILE_CLASS_ID IN NUMBER,
426 X_SITE_USE_ID IN NUMBER,
427 X_CREDIT_RATING IN VARCHAR2,
428 X_RISK_CODE IN VARCHAR2,
429 X_STANDARD_TERMS IN NUMBER,
430 X_OVERRIDE_TERMS IN VARCHAR2,
431 X_DUNNING_LETTER_SET_ID IN NUMBER,
432 X_INTEREST_PERIOD_DAYS IN NUMBER,
433 X_PAYMENT_GRACE_DAYS IN NUMBER,
434 X_DISCOUNT_GRACE_DAYS IN NUMBER,
435 X_STATEMENT_CYCLE_ID IN NUMBER,
436 X_ACCOUNT_STATUS IN VARCHAR2,
437 X_PERCENT_COLLECTABLE IN NUMBER,
438 X_AUTOCASH_HIERARCHY_ID IN NUMBER,
439 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
440 X_ATTRIBUTE1 IN VARCHAR2,
441 X_ATTRIBUTE2 IN VARCHAR2,
442 X_ATTRIBUTE3 IN VARCHAR2,
443 X_ATTRIBUTE4 IN VARCHAR2,
444 X_ATTRIBUTE5 IN VARCHAR2,
445 X_ATTRIBUTE6 IN VARCHAR2,
446 X_ATTRIBUTE7 IN VARCHAR2,
447 X_ATTRIBUTE8 IN VARCHAR2,
448 X_ATTRIBUTE9 IN VARCHAR2,
449 X_ATTRIBUTE10 IN VARCHAR2,
450 X_ATTRIBUTE11 IN VARCHAR2,
451 X_ATTRIBUTE12 IN VARCHAR2,
452 X_ATTRIBUTE13 IN VARCHAR2,
453 X_ATTRIBUTE14 IN VARCHAR2,
454 X_ATTRIBUTE15 IN VARCHAR2,
455 X_AUTO_REC_INCL_DISPUTED_FLAG IN VARCHAR2,
456 X_TAX_PRINTING_OPTION IN VARCHAR2,
457 X_CHARGE_ON_FINANCE_CHARGE_FG IN VARCHAR2,
458 X_GROUPING_RULE_ID IN NUMBER,
459 X_CLEARING_DAYS IN NUMBER,
460 X_JGZZ_ATTRIBUTE_CATEGORY IN VARCHAR2,
461 X_JGZZ_ATTRIBUTE1 IN VARCHAR2,
462 X_JGZZ_ATTRIBUTE2 IN VARCHAR2,
463 X_JGZZ_ATTRIBUTE3 IN VARCHAR2,
464 X_JGZZ_ATTRIBUTE4 IN VARCHAR2,
465 X_JGZZ_ATTRIBUTE5 IN VARCHAR2,
466 X_JGZZ_ATTRIBUTE6 IN VARCHAR2,
467 X_JGZZ_ATTRIBUTE7 IN VARCHAR2,
468 X_JGZZ_ATTRIBUTE8 IN VARCHAR2,
469 X_JGZZ_ATTRIBUTE9 IN VARCHAR2,
470 X_JGZZ_ATTRIBUTE10 IN VARCHAR2,
471 X_JGZZ_ATTRIBUTE11 IN VARCHAR2,
472 X_JGZZ_ATTRIBUTE12 IN VARCHAR2,
473 X_JGZZ_ATTRIBUTE13 IN VARCHAR2,
474 X_JGZZ_ATTRIBUTE14 IN VARCHAR2,
475 X_JGZZ_ATTRIBUTE15 IN VARCHAR2,
476 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
477 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
478 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
479 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
480 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
481 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
482 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
483 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
484 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
485 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
486 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
487 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
488 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
489 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
490 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
491 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
492 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
493 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
494 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
495 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
496 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
497 X_CONS_INV_FLAG IN VARCHAR2,
498 X_CONS_INV_TYPE IN VARCHAR2,
499 X_AUTOCASH_HIERARCHY_ID_ADR IN NUMBER,
500 X_LOCKBOX_MATCHING_OPTION IN VARCHAR2,
501 X_OBJECT_VERSION_NUMBER IN NUMBER,
502 X_CREATED_BY_MODULE IN VARCHAR2,
503 X_APPLICATION_ID IN NUMBER,
504 X_REVIEW_CYCLE IN VARCHAR2 ,
505 X_LAST_CREDIT_REVIEW_DATE IN DATE ,
506 X_PARTY_ID IN NUMBER ,
507 X_CREDIT_CLASSIFICATION IN VARCHAR2,
508 X_CONS_BILL_LEVEL IN VARCHAR2,
509 X_LATE_CHARGE_CALCULATION_TRX IN VARCHAR2,
510 X_CREDIT_ITEMS_FLAG IN VARCHAR2,
511 X_DISPUTED_TRANSACTIONS_FLAG IN VARCHAR2,
512 X_LATE_CHARGE_TYPE IN VARCHAR2,
513 X_LATE_CHARGE_TERM_ID IN NUMBER,
514 X_INTEREST_CALCULATION_PERIOD IN VARCHAR2,
515 X_HOLD_CHARGED_INVOICES_FLAG IN VARCHAR2,
516 X_MESSAGE_TEXT_ID IN NUMBER,
517 X_MULTIPLE_INTEREST_RATES_FLAG IN VARCHAR2,
518 X_CHARGE_BEGIN_DATE IN DATE
519 ) IS
520
521 l_profile_class_updated VARCHAR2(1) := 'N';
522
523 l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
524
525 BEGIN
526
527 -- profile_class_id cannot be updated to null.
528 IF X_PROFILE_CLASS_ID IS NOT NULL THEN
529 l_profile_class_updated := 'Y';
530
531 SELECT * INTO l_profile_class_rec
532 FROM HZ_CUST_PROFILE_CLASSES
533 WHERE PROFILE_CLASS_ID = X_PROFILE_CLASS_ID;
534 END IF;
535
536 UPDATE HZ_CUSTOMER_PROFILES SET
537 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 ),
538 LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
539 LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
540 LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
541 CREATED_BY = CREATED_BY,
542 CREATION_DATE = CREATION_DATE,
543 CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
544 STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
545 COLLECTOR_ID = DECODE( X_COLLECTOR_ID, NULL, DECODE( l_profile_class_updated, 'N', COLLECTOR_ID, l_profile_class_rec.collector_id ), FND_API.G_MISS_NUM, NULL, X_COLLECTOR_ID ),
546 CREDIT_ANALYST_ID = DECODE( X_CREDIT_ANALYST_ID, NULL, DECODE( l_profile_class_updated, 'N', CREDIT_ANALYST_ID, l_profile_class_rec.credit_analyst_id ), FND_API.G_MISS_NUM, NULL, X_CREDIT_ANALYST_ID ),
547 CREDIT_CHECKING = DECODE( X_CREDIT_CHECKING, NULL, DECODE( l_profile_class_updated, 'N', CREDIT_CHECKING, l_profile_class_rec.credit_checking ), FND_API.G_MISS_CHAR, NULL, X_CREDIT_CHECKING ),
548 NEXT_CREDIT_REVIEW_DATE = DECODE( X_NEXT_CREDIT_REVIEW_DATE, NULL, NEXT_CREDIT_REVIEW_DATE, FND_API.G_MISS_DATE, NULL, X_NEXT_CREDIT_REVIEW_DATE ),
549 TOLERANCE = DECODE( X_TOLERANCE, NULL, DECODE( l_profile_class_updated, 'N', TOLERANCE, l_profile_class_rec.tolerance), FND_API.G_MISS_NUM, NULL, X_TOLERANCE ),
550 DISCOUNT_TERMS = DECODE( X_DISCOUNT_TERMS, NULL, DECODE( l_profile_class_updated, 'N', DISCOUNT_TERMS, l_profile_class_rec.discount_terms ), FND_API.G_MISS_CHAR, NULL, X_DISCOUNT_TERMS ),
551 DUNNING_LETTERS = DECODE( X_DUNNING_LETTERS, NULL, DECODE( l_profile_class_updated, 'N', DUNNING_LETTERS, l_profile_class_rec.dunning_letters ), FND_API.G_MISS_CHAR, NULL, X_DUNNING_LETTERS ),
552 INTEREST_CHARGES = DECODE( X_INTEREST_CHARGES, NULL, DECODE( l_profile_class_updated, 'N', INTEREST_CHARGES, l_profile_class_rec.interest_charges ), FND_API.G_MISS_CHAR, NULL, X_INTEREST_CHARGES ),
553 SEND_STATEMENTS = DECODE( X_SEND_STATEMENTS, NULL, DECODE( l_profile_class_updated, 'N', SEND_STATEMENTS, l_profile_class_rec.statements ), FND_API.G_MISS_CHAR, NULL, X_SEND_STATEMENTS ),
554 CREDIT_BALANCE_STATEMENTS = DECODE( X_CREDIT_BALANCE_STATEMENTS, NULL, DECODE( l_profile_class_updated, 'N', CREDIT_BALANCE_STATEMENTS, l_profile_class_rec.credit_balance_statements ), FND_API.G_MISS_CHAR, NULL, X_CREDIT_BALANCE_STATEMENTS ),
555 CREDIT_HOLD = DECODE( X_CREDIT_HOLD, NULL, CREDIT_HOLD, FND_API.G_MISS_CHAR, 'N', X_CREDIT_HOLD ),
556 PROFILE_CLASS_ID = DECODE( X_PROFILE_CLASS_ID, NULL, PROFILE_CLASS_ID, FND_API.G_MISS_NUM, NULL, X_PROFILE_CLASS_ID ),
557 SITE_USE_ID = DECODE( X_SITE_USE_ID, NULL, SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_SITE_USE_ID ),
558 CREDIT_RATING = DECODE( X_CREDIT_RATING, NULL, CREDIT_RATING, FND_API.G_MISS_CHAR, NULL, X_CREDIT_RATING ),
559 RISK_CODE = DECODE( X_RISK_CODE, NULL, RISK_CODE, FND_API.G_MISS_CHAR, NULL, X_RISK_CODE ),
560 STANDARD_TERMS = DECODE( X_STANDARD_TERMS, NULL, DECODE( l_profile_class_updated, 'N', STANDARD_TERMS, l_profile_class_rec.standard_terms ), FND_API.G_MISS_NUM, NULL, X_STANDARD_TERMS ),
561 OVERRIDE_TERMS = DECODE( X_OVERRIDE_TERMS, NULL, DECODE( l_profile_class_updated, 'N', OVERRIDE_TERMS, l_profile_class_rec.override_terms ), FND_API.G_MISS_CHAR, NULL, X_OVERRIDE_TERMS ),
562 --DUNNING_LETTER_SET_ID = DECODE( X_DUNNING_LETTER_SET_ID, NULL, DECODE( l_profile_class_updated, 'N', DUNNING_LETTER_SET_ID, l_profile_class_rec.dunning_letter_set_id ), FND_API.G_MISS_NUM, NULL, X_DUNNING_LETTER_SET_ID ),
563 DUNNING_LETTER_SET_ID = DECODE( X_DUNNING_LETTER_SET_ID, NULL, DECODE( l_profile_class_updated, 'N', DUNNING_LETTER_SET_ID,
564 decode(nvl(X_DUNNING_LETTERS,l_profile_class_rec.dunning_letters),'Y',l_profile_class_rec.dunning_letter_set_id,X_DUNNING_LETTER_SET_ID)), FND_API.G_MISS_NUM, NULL, X_DUNNING_LETTER_SET_ID ),
565 INTEREST_PERIOD_DAYS = DECODE( X_INTEREST_PERIOD_DAYS,NULL,DECODE( l_profile_class_updated, 'N', INTEREST_PERIOD_DAYS,
566 decode(nvl(X_INTEREST_CHARGES,l_profile_class_rec.interest_charges),'Y',l_profile_class_rec.interest_period_days,X_INTEREST_PERIOD_DAYS)),FND_API.G_MISS_NUM, NULL, X_INTEREST_PERIOD_DAYS ),
567 PAYMENT_GRACE_DAYS = DECODE( X_PAYMENT_GRACE_DAYS, NULL, DECODE( l_profile_class_updated, 'N', PAYMENT_GRACE_DAYS, l_profile_class_rec.payment_grace_days ), FND_API.G_MISS_NUM, NULL, X_PAYMENT_GRACE_DAYS ),
568 DISCOUNT_GRACE_DAYS = DECODE( X_DISCOUNT_GRACE_DAYS, NULL, DECODE( l_profile_class_updated, 'N', DISCOUNT_GRACE_DAYS,
569 decode(nvl(x_discount_terms,l_profile_class_rec.discount_terms),'Y',l_profile_class_rec.discount_grace_days,NULL) ), FND_API.G_MISS_NUM, NULL, X_DISCOUNT_GRACE_DAYS ),
570 --STATEMENT_CYCLE_ID = DECODE( X_STATEMENT_CYCLE_ID, NULL, DECODE( l_profile_class_updated, 'N', STATEMENT_CYCLE_ID, l_profile_class_rec.statement_cycle_id ), FND_API.G_MISS_NUM, NULL, X_STATEMENT_CYCLE_ID ),
571 STATEMENT_CYCLE_ID = DECODE( X_STATEMENT_CYCLE_ID, NULL, DECODE( l_profile_class_updated, 'N', STATEMENT_CYCLE_ID,
572 decode(nvl(X_SEND_STATEMENTS,l_profile_class_rec.statements),'Y',l_profile_class_rec.statement_cycle_id, X_STATEMENT_CYCLE_ID)), FND_API.G_MISS_NUM, NULL, X_STATEMENT_CYCLE_ID ),
573 ACCOUNT_STATUS = DECODE( X_ACCOUNT_STATUS, NULL, ACCOUNT_STATUS, FND_API.G_MISS_CHAR, NULL, X_ACCOUNT_STATUS ),
574 PERCENT_COLLECTABLE = DECODE( X_PERCENT_COLLECTABLE, NULL, PERCENT_COLLECTABLE, FND_API.G_MISS_NUM, NULL, X_PERCENT_COLLECTABLE ),
575 AUTOCASH_HIERARCHY_ID = DECODE( X_AUTOCASH_HIERARCHY_ID, NULL, DECODE( l_profile_class_updated, 'N', AUTOCASH_HIERARCHY_ID, l_profile_class_rec.autocash_hierarchy_id ), FND_API.G_MISS_NUM, NULL, X_AUTOCASH_HIERARCHY_ID ),
576 ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE_CATEGORY, l_profile_class_rec.attribute_category ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
577 ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE1, l_profile_class_rec.attribute1 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
578 ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE2, l_profile_class_rec.attribute2 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
579 ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE3, l_profile_class_rec.attribute3 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
580 ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE4, l_profile_class_rec.attribute4 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
581 ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE5, l_profile_class_rec.attribute5 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
582 ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE6, l_profile_class_rec.attribute6 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
583 ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE7, l_profile_class_rec.attribute7 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
584 ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE8, l_profile_class_rec.attribute8 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
585 ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE9, l_profile_class_rec.attribute9 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
586 ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE10, l_profile_class_rec.attribute10 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
587 PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
588 PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
589 PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
590 REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
591 ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE11, l_profile_class_rec.attribute11 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
592 ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE12, l_profile_class_rec.attribute12 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
593 ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE13, l_profile_class_rec.attribute13 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
594 ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE14, l_profile_class_rec.attribute14 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
595 ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE15, l_profile_class_rec.attribute15 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
596 AUTO_REC_INCL_DISPUTED_FLAG = DECODE( X_AUTO_REC_INCL_DISPUTED_FLAG, NULL,
597 DECODE( l_profile_class_updated, 'N', AUTO_REC_INCL_DISPUTED_FLAG, l_profile_class_rec.auto_rec_incl_disputed_flag ),
598 FND_API.G_MISS_CHAR, NULL, X_AUTO_REC_INCL_DISPUTED_FLAG ),
599 TAX_PRINTING_OPTION = DECODE( X_TAX_PRINTING_OPTION, NULL, DECODE( l_profile_class_updated, 'N', TAX_PRINTING_OPTION, l_profile_class_rec.tax_printing_option ), FND_API.G_MISS_CHAR, NULL, X_TAX_PRINTING_OPTION ),
600 CHARGE_ON_FINANCE_CHARGE_FLAG = DECODE( X_CHARGE_ON_FINANCE_CHARGE_FG, NULL,
601 DECODE( l_profile_class_updated, 'N', CHARGE_ON_FINANCE_CHARGE_FLAG, l_profile_class_rec.charge_on_finance_charge_flag ),
602 FND_API.G_MISS_CHAR, NULL, X_CHARGE_ON_FINANCE_CHARGE_FG ),
603 GROUPING_RULE_ID = DECODE( X_GROUPING_RULE_ID, NULL, DECODE( l_profile_class_updated, 'N', GROUPING_RULE_ID, l_profile_class_rec.grouping_rule_id ), FND_API.G_MISS_NUM, NULL, X_GROUPING_RULE_ID ),
604 CLEARING_DAYS = DECODE( X_CLEARING_DAYS, NULL, CLEARING_DAYS, FND_API.G_MISS_NUM, NULL, X_CLEARING_DAYS ),
605 JGZZ_ATTRIBUTE_CATEGORY = DECODE( X_JGZZ_ATTRIBUTE_CATEGORY, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE_CATEGORY, l_profile_class_rec.jgzz_attribute_category ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE_CATEGORY ),
606 JGZZ_ATTRIBUTE1 = DECODE( X_JGZZ_ATTRIBUTE1, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE1, l_profile_class_rec.jgzz_attribute1 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE1 ),
607 JGZZ_ATTRIBUTE2 = DECODE( X_JGZZ_ATTRIBUTE2, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE2, l_profile_class_rec.jgzz_attribute2 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE2 ),
608 JGZZ_ATTRIBUTE3 = DECODE( X_JGZZ_ATTRIBUTE3, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE3, l_profile_class_rec.jgzz_attribute3 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE3 ),
609 JGZZ_ATTRIBUTE4 = DECODE( X_JGZZ_ATTRIBUTE4, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE4, l_profile_class_rec.jgzz_attribute4 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE4 ),
610 JGZZ_ATTRIBUTE5 = DECODE( X_JGZZ_ATTRIBUTE5, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE5, l_profile_class_rec.jgzz_attribute5 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE5 ),
611 JGZZ_ATTRIBUTE6 = DECODE( X_JGZZ_ATTRIBUTE6, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE6, l_profile_class_rec.jgzz_attribute6 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE6 ),
612 JGZZ_ATTRIBUTE7 = DECODE( X_JGZZ_ATTRIBUTE7, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE7, l_profile_class_rec.jgzz_attribute7 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE7 ),
613 JGZZ_ATTRIBUTE8 = DECODE( X_JGZZ_ATTRIBUTE8, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE8, l_profile_class_rec.jgzz_attribute8 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE8 ),
614 JGZZ_ATTRIBUTE9 = DECODE( X_JGZZ_ATTRIBUTE9, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE9, l_profile_class_rec.jgzz_attribute9 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE9 ),
615 JGZZ_ATTRIBUTE10 = DECODE( X_JGZZ_ATTRIBUTE10, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE10, l_profile_class_rec.jgzz_attribute10 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE10 ),
616 JGZZ_ATTRIBUTE11 = DECODE( X_JGZZ_ATTRIBUTE11, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE11, l_profile_class_rec.jgzz_attribute11 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE11 ),
617 JGZZ_ATTRIBUTE12 = DECODE( X_JGZZ_ATTRIBUTE12, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE12, l_profile_class_rec.jgzz_attribute12 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE12 ),
618 JGZZ_ATTRIBUTE13 = DECODE( X_JGZZ_ATTRIBUTE13, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE13, l_profile_class_rec.jgzz_attribute13 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE13 ),
619 JGZZ_ATTRIBUTE14 = DECODE( X_JGZZ_ATTRIBUTE14, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE14, l_profile_class_rec.jgzz_attribute14 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE14 ),
620 JGZZ_ATTRIBUTE15 = DECODE( X_JGZZ_ATTRIBUTE15, NULL, DECODE( l_profile_class_updated, 'N', JGZZ_ATTRIBUTE15, l_profile_class_rec.jgzz_attribute15 ), FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE15 ),
621 GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE1, l_profile_class_rec.global_attribute1 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
622 GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE2, l_profile_class_rec.global_attribute2 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
623 GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE3, l_profile_class_rec.global_attribute3 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
624 GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE4, l_profile_class_rec.global_attribute4 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
625 GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE5, l_profile_class_rec.global_attribute5 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
626 GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE6, l_profile_class_rec.global_attribute6 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
627 GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE7, l_profile_class_rec.global_attribute7 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
628 GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE8, l_profile_class_rec.global_attribute8 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
629 GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE9, l_profile_class_rec.global_attribute9 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
630 GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE10, l_profile_class_rec.global_attribute10 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
631 GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE11, l_profile_class_rec.global_attribute11 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
632 GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE12, l_profile_class_rec.global_attribute12 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
633 GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE13, l_profile_class_rec.global_attribute13 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
634 GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE14, l_profile_class_rec.global_attribute14 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
635 GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE15, l_profile_class_rec.global_attribute15 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
636 GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE16, l_profile_class_rec.global_attribute16 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
637 GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE17, l_profile_class_rec.global_attribute17 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
638 GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE18, l_profile_class_rec.global_attribute18 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
639 GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE19, l_profile_class_rec.global_attribute19 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
640 GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE20, l_profile_class_rec.global_attribute20 ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
641 GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, DECODE( l_profile_class_updated, 'N', GLOBAL_ATTRIBUTE_CATEGORY, l_profile_class_rec.global_attribute_category ), FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
642 CONS_INV_FLAG = DECODE( X_CONS_INV_FLAG, NULL, DECODE( l_profile_class_updated, 'N', CONS_INV_FLAG, l_profile_class_rec.cons_inv_flag ), FND_API.G_MISS_CHAR, NULL, X_CONS_INV_FLAG ),
643 CONS_INV_TYPE = DECODE( X_CONS_INV_TYPE, NULL, DECODE( l_profile_class_updated, 'N', CONS_INV_TYPE, l_profile_class_rec.cons_inv_type ), FND_API.G_MISS_CHAR,NULL, X_CONS_INV_TYPE ),
644 AUTOCASH_HIERARCHY_ID_FOR_ADR = DECODE( X_AUTOCASH_HIERARCHY_ID_ADR, NULL,
645 DECODE( l_profile_class_updated, 'N', AUTOCASH_HIERARCHY_ID_FOR_ADR, l_profile_class_rec.autocash_hierarchy_id_for_adr ),
646 FND_API.G_MISS_NUM, NULL, X_AUTOCASH_HIERARCHY_ID_ADR ),
647 LOCKBOX_MATCHING_OPTION = DECODE( X_LOCKBOX_MATCHING_OPTION, NULL, DECODE( l_profile_class_updated, 'N', LOCKBOX_MATCHING_OPTION, l_profile_class_rec.lockbox_matching_option ), FND_API.G_MISS_CHAR, NULL, X_LOCKBOX_MATCHING_OPTION ),
648 OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
649 CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
650 APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
651 REVIEW_CYCLE = DECODE( X_REVIEW_CYCLE , NULL, REVIEW_CYCLE , FND_API.G_MISS_CHAR,NULL, X_REVIEW_CYCLE ),
652 LAST_CREDIT_REVIEW_DATE= DECODE( X_LAST_CREDIT_REVIEW_DATE, NULL, LAST_CREDIT_REVIEW_DATE , FND_API.G_MISS_DATE ,NULL, X_LAST_CREDIT_REVIEW_DATE ),
653 PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID , FND_API.G_MISS_NUM ,NULL, X_PARTY_ID ),
654 CREDIT_CLASSIFICATION = DECODE(X_CREDIT_CLASSIFICATION, NULL, DECODE(l_profile_class_updated, 'N', CREDIT_CLASSIFICATION, l_profile_class_rec.credit_classification ), FND_API.G_MISS_CHAR ,NULL, X_CREDIT_CLASSIFICATION),
655 CONS_BILL_LEVEL = DECODE( X_CONS_BILL_LEVEL, NULL, DECODE(l_profile_class_updated, 'N', CONS_BILL_LEVEL, l_profile_class_rec.CONS_BILL_LEVEL ), FND_API.G_MISS_CHAR, NULL, X_CONS_BILL_LEVEL ),
656 LATE_CHARGE_CALCULATION_TRX = DECODE( X_LATE_CHARGE_CALCULATION_TRX, NULL, DECODE(l_profile_class_updated, 'N', LATE_CHARGE_CALCULATION_TRX, l_profile_class_rec.LATE_CHARGE_CALCULATION_TRX ), FND_API.G_MISS_CHAR, NULL, X_LATE_CHARGE_CALCULATION_TRX),
657 CREDIT_ITEMS_FLAG = DECODE( X_CREDIT_ITEMS_FLAG, NULL, DECODE(l_profile_class_updated, 'N', CREDIT_ITEMS_FLAG, l_profile_class_rec.CREDIT_ITEMS_FLAG ), FND_API.G_MISS_CHAR, NULL, X_CREDIT_ITEMS_FLAG),
658 DISPUTED_TRANSACTIONS_FLAG = DECODE( X_DISPUTED_TRANSACTIONS_FLAG, NULL, DECODE(l_profile_class_updated, 'N', DISPUTED_TRANSACTIONS_FLAG, l_profile_class_rec.DISPUTED_TRANSACTIONS_FLAG ), FND_API.G_MISS_CHAR, NULL, X_DISPUTED_TRANSACTIONS_FLAG),
659 LATE_CHARGE_TYPE = DECODE( X_LATE_CHARGE_TYPE, NULL, DECODE(l_profile_class_updated, 'N', LATE_CHARGE_TYPE, l_profile_class_rec.LATE_CHARGE_TYPE ), FND_API.G_MISS_CHAR, NULL, X_LATE_CHARGE_TYPE),
660 LATE_CHARGE_TERM_ID = DECODE( X_LATE_CHARGE_TERM_ID, NULL, DECODE(l_profile_class_updated, 'N', LATE_CHARGE_TERM_ID, l_profile_class_rec.LATE_CHARGE_TERM_ID ), FND_API.G_MISS_NUM, NULL, X_LATE_CHARGE_TERM_ID),
661 INTEREST_CALCULATION_PERIOD = DECODE( X_INTEREST_CALCULATION_PERIOD, NULL, DECODE(l_profile_class_updated, 'N', INTEREST_CALCULATION_PERIOD, l_profile_class_rec.INTEREST_CALCULATION_PERIOD ), FND_API.G_MISS_CHAR, NULL, X_INTEREST_CALCULATION_PERIOD),
662 HOLD_CHARGED_INVOICES_FLAG = DECODE( X_HOLD_CHARGED_INVOICES_FLAG, NULL, DECODE(l_profile_class_updated, 'N', HOLD_CHARGED_INVOICES_FLAG, l_profile_class_rec.HOLD_CHARGED_INVOICES_FLAG ), FND_API.G_MISS_CHAR, NULL, X_HOLD_CHARGED_INVOICES_FLAG),
663 MESSAGE_TEXT_ID = DECODE( X_MESSAGE_TEXT_ID, NULL, DECODE(l_profile_class_updated, 'N', MESSAGE_TEXT_ID, l_profile_class_rec.MESSAGE_TEXT_ID ), FND_API.G_MISS_NUM, NULL, X_MESSAGE_TEXT_ID),
664 MULTIPLE_INTEREST_RATES_FLAG =
665 DECODE( X_MULTIPLE_INTEREST_RATES_FLAG, NULL, DECODE(l_profile_class_updated, 'N', MULTIPLE_INTEREST_RATES_FLAG, l_profile_class_rec.MULTIPLE_INTEREST_RATES_FLAG ), FND_API.G_MISS_CHAR, NULL, X_MULTIPLE_INTEREST_RATES_FLAG),
666 CHARGE_BEGIN_DATE = DECODE( X_CHARGE_BEGIN_DATE, NULL, DECODE(l_profile_class_updated, 'N', CHARGE_BEGIN_DATE, l_profile_class_rec.CHARGE_BEGIN_DATE ), FND_API.G_MISS_DATE, NULL, X_CHARGE_BEGIN_DATE)
667 WHERE ROWID = X_RowId ;
668
669
670 IF ( SQL%NOTFOUND ) THEN
671 RAISE NO_DATA_FOUND;
672 END IF;
673
674 END Update_Row;
675
676 PROCEDURE Lock_Row (
677 X_Rowid IN OUT NOCOPY VARCHAR2,
678 X_CUST_ACCOUNT_PROFILE_ID IN NUMBER,
679 X_LAST_UPDATED_BY IN NUMBER,
680 X_LAST_UPDATE_DATE IN DATE,
681 X_LAST_UPDATE_LOGIN IN NUMBER,
682 X_CREATED_BY IN NUMBER,
683 X_CREATION_DATE IN DATE,
684 X_CUST_ACCOUNT_ID IN NUMBER,
685 X_STATUS IN VARCHAR2,
686 X_COLLECTOR_ID IN NUMBER,
687 X_CREDIT_ANALYST_ID IN NUMBER,
688 X_CREDIT_CHECKING IN VARCHAR2,
689 X_NEXT_CREDIT_REVIEW_DATE IN DATE,
690 X_TOLERANCE IN NUMBER,
691 X_DISCOUNT_TERMS IN VARCHAR2,
692 X_DUNNING_LETTERS IN VARCHAR2,
693 X_INTEREST_CHARGES IN VARCHAR2,
694 X_SEND_STATEMENTS IN VARCHAR2,
695 X_CREDIT_BALANCE_STATEMENTS IN VARCHAR2,
696 X_CREDIT_HOLD IN VARCHAR2,
697 X_PROFILE_CLASS_ID IN NUMBER,
698 X_SITE_USE_ID IN NUMBER,
699 X_CREDIT_RATING IN VARCHAR2,
700 X_RISK_CODE IN VARCHAR2,
701 X_STANDARD_TERMS IN NUMBER,
702 X_OVERRIDE_TERMS IN VARCHAR2,
703 X_DUNNING_LETTER_SET_ID IN NUMBER,
704 X_INTEREST_PERIOD_DAYS IN NUMBER,
705 X_PAYMENT_GRACE_DAYS IN NUMBER,
706 X_DISCOUNT_GRACE_DAYS IN NUMBER,
707 X_STATEMENT_CYCLE_ID IN NUMBER,
708 X_ACCOUNT_STATUS IN VARCHAR2,
709 X_PERCENT_COLLECTABLE IN NUMBER,
710 X_AUTOCASH_HIERARCHY_ID IN NUMBER,
711 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
712 X_ATTRIBUTE1 IN VARCHAR2,
713 X_ATTRIBUTE2 IN VARCHAR2,
714 X_ATTRIBUTE3 IN VARCHAR2,
715 X_ATTRIBUTE4 IN VARCHAR2,
716 X_ATTRIBUTE5 IN VARCHAR2,
717 X_ATTRIBUTE6 IN VARCHAR2,
718 X_ATTRIBUTE7 IN VARCHAR2,
719 X_ATTRIBUTE8 IN VARCHAR2,
720 X_ATTRIBUTE9 IN VARCHAR2,
721 X_ATTRIBUTE10 IN VARCHAR2,
722 X_PROGRAM_APPLICATION_ID IN NUMBER,
723 X_PROGRAM_ID IN NUMBER,
724 X_PROGRAM_UPDATE_DATE IN DATE,
725 X_REQUEST_ID IN NUMBER,
726 X_ATTRIBUTE11 IN VARCHAR2,
727 X_ATTRIBUTE12 IN VARCHAR2,
728 X_ATTRIBUTE13 IN VARCHAR2,
729 X_ATTRIBUTE14 IN VARCHAR2,
730 X_ATTRIBUTE15 IN VARCHAR2,
731 X_AUTO_REC_INCL_DISPUTED_FLAG IN VARCHAR2,
732 X_TAX_PRINTING_OPTION IN VARCHAR2,
733 X_CHARGE_ON_FINANCE_CHARGE_FG IN VARCHAR2,
734 X_GROUPING_RULE_ID IN NUMBER,
735 X_CLEARING_DAYS IN NUMBER,
736 X_JGZZ_ATTRIBUTE_CATEGORY IN VARCHAR2,
737 X_JGZZ_ATTRIBUTE1 IN VARCHAR2,
738 X_JGZZ_ATTRIBUTE2 IN VARCHAR2,
739 X_JGZZ_ATTRIBUTE3 IN VARCHAR2,
740 X_JGZZ_ATTRIBUTE4 IN VARCHAR2,
741 X_JGZZ_ATTRIBUTE5 IN VARCHAR2,
742 X_JGZZ_ATTRIBUTE6 IN VARCHAR2,
743 X_JGZZ_ATTRIBUTE7 IN VARCHAR2,
744 X_JGZZ_ATTRIBUTE8 IN VARCHAR2,
745 X_JGZZ_ATTRIBUTE9 IN VARCHAR2,
746 X_JGZZ_ATTRIBUTE10 IN VARCHAR2,
747 X_JGZZ_ATTRIBUTE11 IN VARCHAR2,
748 X_JGZZ_ATTRIBUTE12 IN VARCHAR2,
749 X_JGZZ_ATTRIBUTE13 IN VARCHAR2,
750 X_JGZZ_ATTRIBUTE14 IN VARCHAR2,
751 X_JGZZ_ATTRIBUTE15 IN VARCHAR2,
752 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
753 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
754 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
755 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
756 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
757 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
758 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
759 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
760 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
761 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
762 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
763 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
764 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
765 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
766 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
767 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
768 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
769 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
770 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
771 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
772 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
773 X_CONS_INV_FLAG IN VARCHAR2,
774 X_CONS_INV_TYPE IN VARCHAR2,
775 X_AUTOCASH_HIERARCHY_ID_ADR IN NUMBER,
776 X_LOCKBOX_MATCHING_OPTION IN VARCHAR2,
777 X_OBJECT_VERSION_NUMBER IN NUMBER,
778 X_CREATED_BY_MODULE IN VARCHAR2,
779 X_APPLICATION_ID IN NUMBER,
780 X_REVIEW_CYCLE IN VARCHAR2,
781 X_LAST_CREDIT_REVIEW_DATE IN DATE,
782 X_PARTY_ID IN NUMBER,
783 X_CREDIT_CLASSIFICATION IN VARCHAR2,
784 X_CONS_BILL_LEVEL IN VARCHAR2,
785 X_LATE_CHARGE_CALCULATION_TRX IN VARCHAR2,
786 X_CREDIT_ITEMS_FLAG IN VARCHAR2,
787 X_DISPUTED_TRANSACTIONS_FLAG IN VARCHAR2,
788 X_LATE_CHARGE_TYPE IN VARCHAR2,
789 X_LATE_CHARGE_TERM_ID IN NUMBER,
790 X_INTEREST_CALCULATION_PERIOD IN VARCHAR2,
791 X_HOLD_CHARGED_INVOICES_FLAG IN VARCHAR2,
792 X_MESSAGE_TEXT_ID IN NUMBER,
793 X_MULTIPLE_INTEREST_RATES_FLAG IN VARCHAR2,
794 X_CHARGE_BEGIN_DATE IN DATE
795 ) IS
796
797 CURSOR C IS
798 SELECT * FROM HZ_CUSTOMER_PROFILES
799 WHERE ROWID = x_Rowid
800 FOR UPDATE NOWAIT;
801 Recinfo C%ROWTYPE;
802
803 BEGIN
804
805 OPEN C;
806 FETCH C INTO Recinfo;
807 IF ( C%NOTFOUND ) THEN
808 CLOSE C;
809 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
810 APP_EXCEPTION.RAISE_EXCEPTION;
811 END IF;
812 CLOSE C;
813
814 IF (
815 ( ( Recinfo.CUST_ACCOUNT_PROFILE_ID = X_CUST_ACCOUNT_PROFILE_ID )
816 OR ( ( Recinfo.CUST_ACCOUNT_PROFILE_ID IS NULL )
817 AND ( X_CUST_ACCOUNT_PROFILE_ID IS NULL ) ) )
818 AND ( ( Recinfo.LAST_UPDATED_BY = X_LAST_UPDATED_BY )
819 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
820 AND ( X_LAST_UPDATED_BY IS NULL ) ) )
821 AND ( ( Recinfo.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE )
822 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
823 AND ( X_LAST_UPDATE_DATE IS NULL ) ) )
824 AND ( ( Recinfo.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN )
825 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
826 AND ( X_LAST_UPDATE_LOGIN IS NULL ) ) )
827 AND ( ( Recinfo.CREATED_BY = X_CREATED_BY )
828 OR ( ( Recinfo.CREATED_BY IS NULL )
829 AND ( X_CREATED_BY IS NULL ) ) )
830 AND ( ( Recinfo.CREATION_DATE = X_CREATION_DATE )
831 OR ( ( Recinfo.CREATION_DATE IS NULL )
832 AND ( X_CREATION_DATE IS NULL ) ) )
833 AND ( ( Recinfo.CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID )
834 OR ( ( Recinfo.CUST_ACCOUNT_ID IS NULL )
835 AND ( X_CUST_ACCOUNT_ID IS NULL ) ) )
836 AND ( ( Recinfo.STATUS = X_STATUS )
837 OR ( ( Recinfo.STATUS IS NULL )
838 AND ( X_STATUS IS NULL ) ) )
839 AND ( ( Recinfo.COLLECTOR_ID = X_COLLECTOR_ID )
840 OR ( ( Recinfo.COLLECTOR_ID IS NULL )
841 AND ( X_COLLECTOR_ID IS NULL ) ) )
842 AND ( ( Recinfo.CREDIT_ANALYST_ID = X_CREDIT_ANALYST_ID )
843 OR ( ( Recinfo.CREDIT_ANALYST_ID IS NULL )
844 AND ( X_CREDIT_ANALYST_ID IS NULL ) ) )
845 AND ( ( Recinfo.CREDIT_CHECKING = X_CREDIT_CHECKING )
846 OR ( ( Recinfo.CREDIT_CHECKING IS NULL )
847 AND ( X_CREDIT_CHECKING IS NULL ) ) )
848 AND ( ( Recinfo.NEXT_CREDIT_REVIEW_DATE = X_NEXT_CREDIT_REVIEW_DATE )
849 OR ( ( Recinfo.NEXT_CREDIT_REVIEW_DATE IS NULL )
850 AND ( X_NEXT_CREDIT_REVIEW_DATE IS NULL ) ) )
851 AND ( ( Recinfo.TOLERANCE = X_TOLERANCE )
852 OR ( ( Recinfo.TOLERANCE IS NULL )
853 AND ( X_TOLERANCE IS NULL ) ) )
854 AND ( ( Recinfo.DISCOUNT_TERMS = X_DISCOUNT_TERMS )
855 OR ( ( Recinfo.DISCOUNT_TERMS IS NULL )
856 AND ( X_DISCOUNT_TERMS IS NULL ) ) )
857 AND ( ( Recinfo.DUNNING_LETTERS = X_DUNNING_LETTERS )
858 OR ( ( Recinfo.DUNNING_LETTERS IS NULL )
859 AND ( X_DUNNING_LETTERS IS NULL ) ) )
860 AND ( ( Recinfo.INTEREST_CHARGES = X_INTEREST_CHARGES )
861 OR ( ( Recinfo.INTEREST_CHARGES IS NULL )
862 AND ( X_INTEREST_CHARGES IS NULL ) ) )
863 AND ( ( Recinfo.SEND_STATEMENTS = X_SEND_STATEMENTS )
864 OR ( ( Recinfo.SEND_STATEMENTS IS NULL )
865 AND ( X_SEND_STATEMENTS IS NULL ) ) )
866 AND ( ( Recinfo.CREDIT_BALANCE_STATEMENTS = X_CREDIT_BALANCE_STATEMENTS )
867 OR ( ( Recinfo.CREDIT_BALANCE_STATEMENTS IS NULL )
868 AND ( X_CREDIT_BALANCE_STATEMENTS IS NULL ) ) )
869 AND ( ( Recinfo.CREDIT_HOLD = X_CREDIT_HOLD )
870 OR ( ( Recinfo.CREDIT_HOLD IS NULL )
871 AND ( X_CREDIT_HOLD IS NULL ) ) )
872 AND ( ( Recinfo.PROFILE_CLASS_ID = X_PROFILE_CLASS_ID )
873 OR ( ( Recinfo.PROFILE_CLASS_ID IS NULL )
874 AND ( X_PROFILE_CLASS_ID IS NULL ) ) )
875 AND ( ( Recinfo.SITE_USE_ID = X_SITE_USE_ID )
876 OR ( ( Recinfo.SITE_USE_ID IS NULL )
877 AND ( X_SITE_USE_ID IS NULL ) ) )
878 AND ( ( Recinfo.CREDIT_RATING = X_CREDIT_RATING )
879 OR ( ( Recinfo.CREDIT_RATING IS NULL )
880 AND ( X_CREDIT_RATING IS NULL ) ) )
881 AND ( ( Recinfo.RISK_CODE = X_RISK_CODE )
882 OR ( ( Recinfo.RISK_CODE IS NULL )
883 AND ( X_RISK_CODE IS NULL ) ) )
884 AND ( ( Recinfo.STANDARD_TERMS = X_STANDARD_TERMS )
885 OR ( ( Recinfo.STANDARD_TERMS IS NULL )
886 AND ( X_STANDARD_TERMS IS NULL ) ) )
887 AND ( ( Recinfo.OVERRIDE_TERMS = X_OVERRIDE_TERMS )
888 OR ( ( Recinfo.OVERRIDE_TERMS IS NULL )
889 AND ( X_OVERRIDE_TERMS IS NULL ) ) )
890 AND ( ( Recinfo.DUNNING_LETTER_SET_ID = X_DUNNING_LETTER_SET_ID )
891 OR ( ( Recinfo.DUNNING_LETTER_SET_ID IS NULL )
892 AND ( X_DUNNING_LETTER_SET_ID IS NULL ) ) )
893 AND ( ( Recinfo.INTEREST_PERIOD_DAYS = X_INTEREST_PERIOD_DAYS )
894 OR ( ( Recinfo.INTEREST_PERIOD_DAYS IS NULL )
895 AND ( X_INTEREST_PERIOD_DAYS IS NULL ) ) )
896 AND ( ( Recinfo.PAYMENT_GRACE_DAYS = X_PAYMENT_GRACE_DAYS )
897 OR ( ( Recinfo.PAYMENT_GRACE_DAYS IS NULL )
898 AND ( X_PAYMENT_GRACE_DAYS IS NULL ) ) )
899 AND ( ( Recinfo.DISCOUNT_GRACE_DAYS = X_DISCOUNT_GRACE_DAYS )
900 OR ( ( Recinfo.DISCOUNT_GRACE_DAYS IS NULL )
901 AND ( X_DISCOUNT_GRACE_DAYS IS NULL ) ) )
902 AND ( ( Recinfo.STATEMENT_CYCLE_ID = X_STATEMENT_CYCLE_ID )
903 OR ( ( Recinfo.STATEMENT_CYCLE_ID IS NULL )
904 AND ( X_STATEMENT_CYCLE_ID IS NULL ) ) )
905 AND ( ( Recinfo.ACCOUNT_STATUS = X_ACCOUNT_STATUS )
906 OR ( ( Recinfo.ACCOUNT_STATUS IS NULL )
907 AND ( X_ACCOUNT_STATUS IS NULL ) ) )
908 AND ( ( Recinfo.PERCENT_COLLECTABLE = X_PERCENT_COLLECTABLE )
909 OR ( ( Recinfo.PERCENT_COLLECTABLE IS NULL )
910 AND ( X_PERCENT_COLLECTABLE IS NULL ) ) )
911 AND ( ( Recinfo.AUTOCASH_HIERARCHY_ID = X_AUTOCASH_HIERARCHY_ID )
912 OR ( ( Recinfo.AUTOCASH_HIERARCHY_ID IS NULL )
913 AND ( X_AUTOCASH_HIERARCHY_ID IS NULL ) ) )
914 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY )
915 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
916 AND ( X_ATTRIBUTE_CATEGORY IS NULL ) ) )
917 AND ( ( Recinfo.ATTRIBUTE1 = X_ATTRIBUTE1 )
918 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
919 AND ( X_ATTRIBUTE1 IS NULL ) ) )
920 AND ( ( Recinfo.ATTRIBUTE2 = X_ATTRIBUTE2 )
921 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
922 AND ( X_ATTRIBUTE2 IS NULL ) ) )
923 AND ( ( Recinfo.ATTRIBUTE3 = X_ATTRIBUTE3 )
924 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
925 AND ( X_ATTRIBUTE3 IS NULL ) ) )
926 AND ( ( Recinfo.ATTRIBUTE4 = X_ATTRIBUTE4 )
927 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
928 AND ( X_ATTRIBUTE4 IS NULL ) ) )
929 AND ( ( Recinfo.ATTRIBUTE5 = X_ATTRIBUTE5 )
930 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
931 AND ( X_ATTRIBUTE5 IS NULL ) ) )
932 AND ( ( Recinfo.ATTRIBUTE6 = X_ATTRIBUTE6 )
933 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
934 AND ( X_ATTRIBUTE6 IS NULL ) ) )
935 AND ( ( Recinfo.ATTRIBUTE7 = X_ATTRIBUTE7 )
936 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
937 AND ( X_ATTRIBUTE7 IS NULL ) ) )
938 AND ( ( Recinfo.ATTRIBUTE8 = X_ATTRIBUTE8 )
939 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
940 AND ( X_ATTRIBUTE8 IS NULL ) ) )
941 AND ( ( Recinfo.ATTRIBUTE9 = X_ATTRIBUTE9 )
942 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
943 AND ( X_ATTRIBUTE9 IS NULL ) ) )
944 AND ( ( Recinfo.ATTRIBUTE10 = X_ATTRIBUTE10 )
945 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
946 AND ( X_ATTRIBUTE10 IS NULL ) ) )
947 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID )
948 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
949 AND ( X_PROGRAM_APPLICATION_ID IS NULL ) ) )
950 AND ( ( Recinfo.PROGRAM_ID = X_PROGRAM_ID )
951 OR ( ( Recinfo.PROGRAM_ID IS NULL )
952 AND ( X_PROGRAM_ID IS NULL ) ) )
953 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE )
954 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
955 AND ( X_PROGRAM_UPDATE_DATE IS NULL ) ) )
956 AND ( ( Recinfo.REQUEST_ID = X_REQUEST_ID )
957 OR ( ( Recinfo.REQUEST_ID IS NULL )
958 AND ( X_REQUEST_ID IS NULL ) ) )
959 AND ( ( Recinfo.ATTRIBUTE11 = X_ATTRIBUTE11 )
960 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
961 AND ( X_ATTRIBUTE11 IS NULL ) ) )
962 AND ( ( Recinfo.ATTRIBUTE12 = X_ATTRIBUTE12 )
963 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
964 AND ( X_ATTRIBUTE12 IS NULL ) ) )
965 AND ( ( Recinfo.ATTRIBUTE13 = X_ATTRIBUTE13 )
966 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
967 AND ( X_ATTRIBUTE13 IS NULL ) ) )
968 AND ( ( Recinfo.ATTRIBUTE14 = X_ATTRIBUTE14 )
969 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
970 AND ( X_ATTRIBUTE14 IS NULL ) ) )
971 AND ( ( Recinfo.ATTRIBUTE15 = X_ATTRIBUTE15 )
972 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
973 AND ( X_ATTRIBUTE15 IS NULL ) ) )
974 AND ( ( Recinfo.AUTO_REC_INCL_DISPUTED_FLAG = X_AUTO_REC_INCL_DISPUTED_FLAG )
975 OR ( ( Recinfo.AUTO_REC_INCL_DISPUTED_FLAG IS NULL )
976 AND ( X_AUTO_REC_INCL_DISPUTED_FLAG IS NULL ) ) )
977 AND ( ( Recinfo.TAX_PRINTING_OPTION = X_TAX_PRINTING_OPTION )
978 OR ( ( Recinfo.TAX_PRINTING_OPTION IS NULL )
979 AND ( X_TAX_PRINTING_OPTION IS NULL ) ) )
980 AND ( ( Recinfo.CHARGE_ON_FINANCE_CHARGE_FLAG = X_CHARGE_ON_FINANCE_CHARGE_FG )
981 OR ( ( Recinfo.CHARGE_ON_FINANCE_CHARGE_FLAG IS NULL )
982 AND ( X_CHARGE_ON_FINANCE_CHARGE_FG IS NULL ) ) )
983 AND ( ( Recinfo.GROUPING_RULE_ID = X_GROUPING_RULE_ID )
984 OR ( ( Recinfo.GROUPING_RULE_ID IS NULL )
985 AND ( X_GROUPING_RULE_ID IS NULL ) ) )
986 AND ( ( Recinfo.CLEARING_DAYS = X_CLEARING_DAYS )
987 OR ( ( Recinfo.CLEARING_DAYS IS NULL )
988 AND ( X_CLEARING_DAYS IS NULL ) ) )
989 AND ( ( Recinfo.JGZZ_ATTRIBUTE_CATEGORY = X_JGZZ_ATTRIBUTE_CATEGORY )
990 OR ( ( Recinfo.JGZZ_ATTRIBUTE_CATEGORY IS NULL )
991 AND ( X_JGZZ_ATTRIBUTE_CATEGORY IS NULL ) ) )
992 AND ( ( Recinfo.JGZZ_ATTRIBUTE1 = X_JGZZ_ATTRIBUTE1 )
993 OR ( ( Recinfo.JGZZ_ATTRIBUTE1 IS NULL )
994 AND ( X_JGZZ_ATTRIBUTE1 IS NULL ) ) )
995 AND ( ( Recinfo.JGZZ_ATTRIBUTE2 = X_JGZZ_ATTRIBUTE2 )
996 OR ( ( Recinfo.JGZZ_ATTRIBUTE2 IS NULL )
997 AND ( X_JGZZ_ATTRIBUTE2 IS NULL ) ) )
998 AND ( ( Recinfo.JGZZ_ATTRIBUTE3 = X_JGZZ_ATTRIBUTE3 )
999 OR ( ( Recinfo.JGZZ_ATTRIBUTE3 IS NULL )
1000 AND ( X_JGZZ_ATTRIBUTE3 IS NULL ) ) )
1001 AND ( ( Recinfo.JGZZ_ATTRIBUTE4 = X_JGZZ_ATTRIBUTE4 )
1002 OR ( ( Recinfo.JGZZ_ATTRIBUTE4 IS NULL )
1003 AND ( X_JGZZ_ATTRIBUTE4 IS NULL ) ) )
1004 AND ( ( Recinfo.JGZZ_ATTRIBUTE5 = X_JGZZ_ATTRIBUTE5 )
1005 OR ( ( Recinfo.JGZZ_ATTRIBUTE5 IS NULL )
1006 AND ( X_JGZZ_ATTRIBUTE5 IS NULL ) ) )
1007 AND ( ( Recinfo.JGZZ_ATTRIBUTE6 = X_JGZZ_ATTRIBUTE6 )
1008 OR ( ( Recinfo.JGZZ_ATTRIBUTE6 IS NULL )
1009 AND ( X_JGZZ_ATTRIBUTE6 IS NULL ) ) )
1010 AND ( ( Recinfo.JGZZ_ATTRIBUTE7 = X_JGZZ_ATTRIBUTE7 )
1011 OR ( ( Recinfo.JGZZ_ATTRIBUTE7 IS NULL )
1012 AND ( X_JGZZ_ATTRIBUTE7 IS NULL ) ) )
1013 AND ( ( Recinfo.JGZZ_ATTRIBUTE8 = X_JGZZ_ATTRIBUTE8 )
1014 OR ( ( Recinfo.JGZZ_ATTRIBUTE8 IS NULL )
1015 AND ( X_JGZZ_ATTRIBUTE8 IS NULL ) ) )
1016 AND ( ( Recinfo.JGZZ_ATTRIBUTE9 = X_JGZZ_ATTRIBUTE9 )
1017 OR ( ( Recinfo.JGZZ_ATTRIBUTE9 IS NULL )
1018 AND ( X_JGZZ_ATTRIBUTE9 IS NULL ) ) )
1019 AND ( ( Recinfo.JGZZ_ATTRIBUTE10 = X_JGZZ_ATTRIBUTE10 )
1020 OR ( ( Recinfo.JGZZ_ATTRIBUTE10 IS NULL )
1021 AND ( X_JGZZ_ATTRIBUTE10 IS NULL ) ) )
1022 AND ( ( Recinfo.JGZZ_ATTRIBUTE11 = X_JGZZ_ATTRIBUTE11 )
1023 OR ( ( Recinfo.JGZZ_ATTRIBUTE11 IS NULL )
1024 AND ( X_JGZZ_ATTRIBUTE11 IS NULL ) ) )
1025 AND ( ( Recinfo.JGZZ_ATTRIBUTE12 = X_JGZZ_ATTRIBUTE12 )
1026 OR ( ( Recinfo.JGZZ_ATTRIBUTE12 IS NULL )
1027 AND ( X_JGZZ_ATTRIBUTE12 IS NULL ) ) )
1028 AND ( ( Recinfo.JGZZ_ATTRIBUTE13 = X_JGZZ_ATTRIBUTE13 )
1029 OR ( ( Recinfo.JGZZ_ATTRIBUTE13 IS NULL )
1030 AND ( X_JGZZ_ATTRIBUTE13 IS NULL ) ) )
1031 AND ( ( Recinfo.JGZZ_ATTRIBUTE14 = X_JGZZ_ATTRIBUTE14 )
1032 OR ( ( Recinfo.JGZZ_ATTRIBUTE14 IS NULL )
1033 AND ( X_JGZZ_ATTRIBUTE14 IS NULL ) ) )
1034 AND ( ( Recinfo.JGZZ_ATTRIBUTE15 = X_JGZZ_ATTRIBUTE15 )
1035 OR ( ( Recinfo.JGZZ_ATTRIBUTE15 IS NULL )
1036 AND ( X_JGZZ_ATTRIBUTE15 IS NULL ) ) )
1037 AND ( ( Recinfo.GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1 )
1038 OR ( ( Recinfo.GLOBAL_ATTRIBUTE1 IS NULL )
1039 AND ( X_GLOBAL_ATTRIBUTE1 IS NULL ) ) )
1040 AND ( ( Recinfo.GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2 )
1041 OR ( ( Recinfo.GLOBAL_ATTRIBUTE2 IS NULL )
1042 AND ( X_GLOBAL_ATTRIBUTE2 IS NULL ) ) )
1043 AND ( ( Recinfo.GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3 )
1044 OR ( ( Recinfo.GLOBAL_ATTRIBUTE3 IS NULL )
1045 AND ( X_GLOBAL_ATTRIBUTE3 IS NULL ) ) )
1046 AND ( ( Recinfo.GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4 )
1047 OR ( ( Recinfo.GLOBAL_ATTRIBUTE4 IS NULL )
1048 AND ( X_GLOBAL_ATTRIBUTE4 IS NULL ) ) )
1049 AND ( ( Recinfo.GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5 )
1050 OR ( ( Recinfo.GLOBAL_ATTRIBUTE5 IS NULL )
1051 AND ( X_GLOBAL_ATTRIBUTE5 IS NULL ) ) )
1052 AND ( ( Recinfo.GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6 )
1053 OR ( ( Recinfo.GLOBAL_ATTRIBUTE6 IS NULL )
1054 AND ( X_GLOBAL_ATTRIBUTE6 IS NULL ) ) )
1055 AND ( ( Recinfo.GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7 )
1056 OR ( ( Recinfo.GLOBAL_ATTRIBUTE7 IS NULL )
1057 AND ( X_GLOBAL_ATTRIBUTE7 IS NULL ) ) )
1058 AND ( ( Recinfo.GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8 )
1059 OR ( ( Recinfo.GLOBAL_ATTRIBUTE8 IS NULL )
1060 AND ( X_GLOBAL_ATTRIBUTE8 IS NULL ) ) )
1061 AND ( ( Recinfo.GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9 )
1062 OR ( ( Recinfo.GLOBAL_ATTRIBUTE9 IS NULL )
1063 AND ( X_GLOBAL_ATTRIBUTE9 IS NULL ) ) )
1064 AND ( ( Recinfo.GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10 )
1065 OR ( ( Recinfo.GLOBAL_ATTRIBUTE10 IS NULL )
1066 AND ( X_GLOBAL_ATTRIBUTE10 IS NULL ) ) )
1067 AND ( ( Recinfo.GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11 )
1068 OR ( ( Recinfo.GLOBAL_ATTRIBUTE11 IS NULL )
1069 AND ( X_GLOBAL_ATTRIBUTE11 IS NULL ) ) )
1070 AND ( ( Recinfo.GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12 )
1071 OR ( ( Recinfo.GLOBAL_ATTRIBUTE12 IS NULL )
1072 AND ( X_GLOBAL_ATTRIBUTE12 IS NULL ) ) )
1073 AND ( ( Recinfo.GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13 )
1074 OR ( ( Recinfo.GLOBAL_ATTRIBUTE13 IS NULL )
1075 AND ( X_GLOBAL_ATTRIBUTE13 IS NULL ) ) )
1076 AND ( ( Recinfo.GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14 )
1077 OR ( ( Recinfo.GLOBAL_ATTRIBUTE14 IS NULL )
1078 AND ( X_GLOBAL_ATTRIBUTE14 IS NULL ) ) )
1079 AND ( ( Recinfo.GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15 )
1080 OR ( ( Recinfo.GLOBAL_ATTRIBUTE15 IS NULL )
1081 AND ( X_GLOBAL_ATTRIBUTE15 IS NULL ) ) )
1082 AND ( ( Recinfo.GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16 )
1083 OR ( ( Recinfo.GLOBAL_ATTRIBUTE16 IS NULL )
1084 AND ( X_GLOBAL_ATTRIBUTE16 IS NULL ) ) )
1085 AND ( ( Recinfo.GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17 )
1086 OR ( ( Recinfo.GLOBAL_ATTRIBUTE17 IS NULL )
1087 AND ( X_GLOBAL_ATTRIBUTE17 IS NULL ) ) )
1088 AND ( ( Recinfo.GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18 )
1089 OR ( ( Recinfo.GLOBAL_ATTRIBUTE18 IS NULL )
1090 AND ( X_GLOBAL_ATTRIBUTE18 IS NULL ) ) )
1091 AND ( ( Recinfo.GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19 )
1092 OR ( ( Recinfo.GLOBAL_ATTRIBUTE19 IS NULL )
1093 AND ( X_GLOBAL_ATTRIBUTE19 IS NULL ) ) )
1094 AND ( ( Recinfo.GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20 )
1095 OR ( ( Recinfo.GLOBAL_ATTRIBUTE20 IS NULL )
1096 AND ( X_GLOBAL_ATTRIBUTE20 IS NULL ) ) )
1097 AND ( ( Recinfo.GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY )
1098 OR ( ( Recinfo.GLOBAL_ATTRIBUTE_CATEGORY IS NULL )
1099 AND ( X_GLOBAL_ATTRIBUTE_CATEGORY IS NULL ) ) )
1100 AND ( ( Recinfo.CONS_INV_FLAG = X_CONS_INV_FLAG )
1101 OR ( ( Recinfo.CONS_INV_FLAG IS NULL )
1102 AND ( X_CONS_INV_FLAG IS NULL ) ) )
1103 AND ( ( Recinfo.CONS_INV_TYPE = X_CONS_INV_TYPE )
1104 OR ( ( Recinfo.CONS_INV_TYPE IS NULL )
1105 AND ( X_CONS_INV_TYPE IS NULL ) ) )
1106 AND ( ( Recinfo.AUTOCASH_HIERARCHY_ID_FOR_ADR = X_AUTOCASH_HIERARCHY_ID_ADR )
1107 OR ( ( Recinfo.AUTOCASH_HIERARCHY_ID_FOR_ADR IS NULL )
1108 AND ( X_AUTOCASH_HIERARCHY_ID_ADR IS NULL ) ) )
1109 AND ( ( Recinfo.LOCKBOX_MATCHING_OPTION = X_LOCKBOX_MATCHING_OPTION )
1110 OR ( ( Recinfo.LOCKBOX_MATCHING_OPTION IS NULL )
1111 AND ( X_LOCKBOX_MATCHING_OPTION IS NULL ) ) )
1112 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER )
1113 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
1114 AND ( X_OBJECT_VERSION_NUMBER IS NULL ) ) )
1115 AND ( ( Recinfo.CREATED_BY_MODULE = X_CREATED_BY_MODULE )
1116 OR ( ( Recinfo.CREATED_BY_MODULE IS NULL )
1117 AND ( X_CREATED_BY_MODULE IS NULL ) ) )
1118 AND ( ( Recinfo.APPLICATION_ID = X_APPLICATION_ID )
1119 OR ( ( Recinfo.APPLICATION_ID IS NULL )
1120 AND ( X_APPLICATION_ID IS NULL ) ) )
1121 AND ( ( Recinfo.REVIEW_CYCLE = X_REVIEW_CYCLE )
1122 OR ( ( Recinfo.REVIEW_CYCLE IS NULL )
1123 AND ( X_REVIEW_CYCLE IS NULL ) ) )
1124 AND ( ( Recinfo.LAST_CREDIT_REVIEW_DATE = X_LAST_CREDIT_REVIEW_DATE )
1125 OR ( ( Recinfo.LAST_CREDIT_REVIEW_DATE IS NULL )
1126 AND ( X_LAST_CREDIT_REVIEW_DATE IS NULL ) ) )
1127 AND ( ( Recinfo.PARTY_ID = X_PARTY_ID )
1128 OR ( ( Recinfo.PARTY_ID IS NULL )
1129 AND ( X_PARTY_ID IS NULL ) ) )
1130 AND ( ( Recinfo.CREDIT_CLASSIFICATION = X_CREDIT_CLASSIFICATION)
1131 OR (( Recinfo.CREDIT_CLASSIFICATION IS NULL )
1132 AND ( X_CREDIT_CLASSIFICATION IS NULL ) ) )
1133 AND ( ( Recinfo.CONS_BILL_LEVEL = X_CONS_BILL_LEVEL )
1134 OR ( ( Recinfo.CONS_BILL_LEVEL IS NULL )
1135 AND ( X_CONS_BILL_LEVEL IS NULL ) ) )
1136 AND ( ( Recinfo.LATE_CHARGE_CALCULATION_TRX = X_LATE_CHARGE_CALCULATION_TRX )
1137 OR ( ( Recinfo.LATE_CHARGE_CALCULATION_TRX IS NULL )
1138 AND ( X_LATE_CHARGE_CALCULATION_TRX IS NULL ) ) )
1139 AND ( ( Recinfo.CREDIT_ITEMS_FLAG = X_CREDIT_ITEMS_FLAG )
1140 OR ( ( Recinfo.CREDIT_ITEMS_FLAG IS NULL )
1141 AND ( X_CREDIT_ITEMS_FLAG IS NULL ) ) )
1142 AND ( ( Recinfo.DISPUTED_TRANSACTIONS_FLAG = X_DISPUTED_TRANSACTIONS_FLAG )
1143 OR ( ( Recinfo.DISPUTED_TRANSACTIONS_FLAG IS NULL )
1144 AND ( X_DISPUTED_TRANSACTIONS_FLAG IS NULL ) ) )
1145 AND ( ( Recinfo.LATE_CHARGE_TYPE = X_LATE_CHARGE_TYPE )
1146 OR ( ( Recinfo.LATE_CHARGE_TYPE IS NULL )
1147 AND ( X_LATE_CHARGE_TYPE IS NULL ) ) )
1148 AND ( ( Recinfo.LATE_CHARGE_TERM_ID = X_LATE_CHARGE_TERM_ID )
1149 OR ( ( Recinfo.LATE_CHARGE_TERM_ID IS NULL )
1150 AND ( X_LATE_CHARGE_TERM_ID IS NULL ) ) )
1151 AND ( ( Recinfo.INTEREST_CALCULATION_PERIOD = X_INTEREST_CALCULATION_PERIOD )
1152 OR ( ( Recinfo.INTEREST_CALCULATION_PERIOD IS NULL )
1153 AND ( X_INTEREST_CALCULATION_PERIOD IS NULL ) ) )
1154 AND ( ( Recinfo.HOLD_CHARGED_INVOICES_FLAG = X_HOLD_CHARGED_INVOICES_FLAG )
1155 OR ( ( Recinfo.HOLD_CHARGED_INVOICES_FLAG IS NULL )
1156 AND ( X_HOLD_CHARGED_INVOICES_FLAG IS NULL ) ) )
1157 AND ( ( Recinfo.MESSAGE_TEXT_ID = X_MESSAGE_TEXT_ID )
1158 OR ( ( Recinfo.MESSAGE_TEXT_ID IS NULL )
1159 AND ( X_MESSAGE_TEXT_ID IS NULL ) ) )
1160 AND ( ( Recinfo.MULTIPLE_INTEREST_RATES_FLAG = X_MULTIPLE_INTEREST_RATES_FLAG )
1161 OR ( ( Recinfo.MULTIPLE_INTEREST_RATES_FLAG IS NULL )
1162 AND ( X_MULTIPLE_INTEREST_RATES_FLAG IS NULL ) ) )
1163 AND ( ( Recinfo.CHARGE_BEGIN_DATE = X_CHARGE_BEGIN_DATE )
1164 OR ( ( Recinfo.CHARGE_BEGIN_DATE IS NULL )
1165 AND ( X_CHARGE_BEGIN_DATE IS NULL ) ) )
1166 ) THEN
1167 RETURN;
1168 ELSE
1169 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1170 APP_EXCEPTION.RAISE_EXCEPTION;
1171 END IF;
1172
1173 END Lock_Row;
1174
1175 PROCEDURE Select_Row (
1176 X_CUST_ACCOUNT_PROFILE_ID IN OUT NOCOPY NUMBER,
1177 X_CUST_ACCOUNT_ID OUT NOCOPY NUMBER,
1178 X_STATUS OUT NOCOPY VARCHAR2,
1179 X_COLLECTOR_ID OUT NOCOPY NUMBER,
1180 X_CREDIT_ANALYST_ID OUT NOCOPY NUMBER,
1181 X_CREDIT_CHECKING OUT NOCOPY VARCHAR2,
1182 X_NEXT_CREDIT_REVIEW_DATE OUT NOCOPY DATE,
1183 X_TOLERANCE OUT NOCOPY NUMBER,
1184 X_DISCOUNT_TERMS OUT NOCOPY VARCHAR2,
1185 X_DUNNING_LETTERS OUT NOCOPY VARCHAR2,
1186 X_INTEREST_CHARGES OUT NOCOPY VARCHAR2,
1187 X_SEND_STATEMENTS OUT NOCOPY VARCHAR2,
1188 X_CREDIT_BALANCE_STATEMENTS OUT NOCOPY VARCHAR2,
1189 X_CREDIT_HOLD OUT NOCOPY VARCHAR2,
1190 X_PROFILE_CLASS_ID OUT NOCOPY NUMBER,
1191 X_SITE_USE_ID OUT NOCOPY NUMBER,
1192 X_CREDIT_RATING OUT NOCOPY VARCHAR2,
1193 X_RISK_CODE OUT NOCOPY VARCHAR2,
1194 X_STANDARD_TERMS OUT NOCOPY NUMBER,
1195 X_OVERRIDE_TERMS OUT NOCOPY VARCHAR2,
1196 X_DUNNING_LETTER_SET_ID OUT NOCOPY NUMBER,
1197 X_INTEREST_PERIOD_DAYS OUT NOCOPY NUMBER,
1198 X_PAYMENT_GRACE_DAYS OUT NOCOPY NUMBER,
1199 X_DISCOUNT_GRACE_DAYS OUT NOCOPY NUMBER,
1200 X_STATEMENT_CYCLE_ID OUT NOCOPY NUMBER,
1201 X_ACCOUNT_STATUS OUT NOCOPY VARCHAR2,
1202 X_PERCENT_COLLECTABLE OUT NOCOPY NUMBER,
1203 X_AUTOCASH_HIERARCHY_ID OUT NOCOPY NUMBER,
1204 X_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
1205 X_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
1206 X_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
1207 X_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
1208 X_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
1209 X_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
1210 X_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
1211 X_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
1212 X_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
1213 X_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
1214 X_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
1215 X_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
1216 X_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
1217 X_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
1218 X_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
1219 X_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
1220 X_AUTO_REC_INCL_DISPUTED_FLAG OUT NOCOPY VARCHAR2,
1221 X_TAX_PRINTING_OPTION OUT NOCOPY VARCHAR2,
1222 X_CHARGE_ON_FINANCE_CHARGE_FG OUT NOCOPY VARCHAR2,
1223 X_GROUPING_RULE_ID OUT NOCOPY NUMBER,
1224 X_CLEARING_DAYS OUT NOCOPY NUMBER,
1225 X_JGZZ_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
1226 X_JGZZ_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
1227 X_JGZZ_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
1228 X_JGZZ_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
1229 X_JGZZ_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
1230 X_JGZZ_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
1231 X_JGZZ_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
1232 X_JGZZ_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
1233 X_JGZZ_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
1234 X_JGZZ_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
1235 X_JGZZ_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
1236 X_JGZZ_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
1237 X_JGZZ_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
1238 X_JGZZ_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
1239 X_JGZZ_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
1240 X_JGZZ_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
1241 X_GLOBAL_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
1242 X_GLOBAL_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
1243 X_GLOBAL_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
1244 X_GLOBAL_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
1245 X_GLOBAL_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
1246 X_GLOBAL_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
1247 X_GLOBAL_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
1248 X_GLOBAL_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
1249 X_GLOBAL_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
1250 X_GLOBAL_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
1251 X_GLOBAL_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
1252 X_GLOBAL_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
1253 X_GLOBAL_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
1254 X_GLOBAL_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
1255 X_GLOBAL_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
1256 X_GLOBAL_ATTRIBUTE16 OUT NOCOPY VARCHAR2,
1257 X_GLOBAL_ATTRIBUTE17 OUT NOCOPY VARCHAR2,
1258 X_GLOBAL_ATTRIBUTE18 OUT NOCOPY VARCHAR2,
1259 X_GLOBAL_ATTRIBUTE19 OUT NOCOPY VARCHAR2,
1260 X_GLOBAL_ATTRIBUTE20 OUT NOCOPY VARCHAR2,
1261 X_GLOBAL_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
1262 X_CONS_INV_FLAG OUT NOCOPY VARCHAR2,
1263 X_CONS_INV_TYPE OUT NOCOPY VARCHAR2,
1264 X_AUTOCASH_HIERARCHY_ID_ADR OUT NOCOPY NUMBER,
1265 X_LOCKBOX_MATCHING_OPTION OUT NOCOPY VARCHAR2,
1266 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
1267 X_APPLICATION_ID OUT NOCOPY NUMBER,
1268 X_REVIEW_CYCLE OUT NOCOPY VARCHAR2 ,
1269 X_LAST_CREDIT_REVIEW_DATE OUT NOCOPY DATE ,
1270 X_PARTY_ID OUT NOCOPY NUMBER ,
1271 X_CREDIT_CLASSIFICATION OUT NOCOPY VARCHAR2,
1272 X_CONS_BILL_LEVEL OUT NOCOPY VARCHAR2,
1273 X_LATE_CHARGE_CALCULATION_TRX OUT NOCOPY VARCHAR2,
1274 X_CREDIT_ITEMS_FLAG OUT NOCOPY VARCHAR2,
1275 X_DISPUTED_TRANSACTIONS_FLAG OUT NOCOPY VARCHAR2,
1276 X_LATE_CHARGE_TYPE OUT NOCOPY VARCHAR2,
1277 X_LATE_CHARGE_TERM_ID OUT NOCOPY NUMBER,
1278 X_INTEREST_CALCULATION_PERIOD OUT NOCOPY VARCHAR2,
1279 X_HOLD_CHARGED_INVOICES_FLAG OUT NOCOPY VARCHAR2,
1280 X_MESSAGE_TEXT_ID OUT NOCOPY NUMBER,
1281 X_MULTIPLE_INTEREST_RATES_FLAG OUT NOCOPY VARCHAR2,
1282 X_CHARGE_BEGIN_DATE OUT NOCOPY DATE
1283 ) IS
1284
1285 BEGIN
1286
1287 SELECT
1288 NVL( CUST_ACCOUNT_PROFILE_ID, FND_API.G_MISS_NUM ),
1289 NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
1290 NVL( STATUS, FND_API.G_MISS_CHAR ),
1291 NVL( COLLECTOR_ID, FND_API.G_MISS_NUM ),
1292 NVL( CREDIT_ANALYST_ID, FND_API.G_MISS_NUM ),
1293 NVL( CREDIT_CHECKING, FND_API.G_MISS_CHAR ),
1294 NVL( NEXT_CREDIT_REVIEW_DATE, FND_API.G_MISS_DATE ),
1295 NVL( TOLERANCE, FND_API.G_MISS_NUM ),
1296 NVL( DISCOUNT_TERMS, FND_API.G_MISS_CHAR ),
1297 NVL( DUNNING_LETTERS, FND_API.G_MISS_CHAR ),
1298 NVL( INTEREST_CHARGES, FND_API.G_MISS_CHAR ),
1299 NVL( SEND_STATEMENTS, FND_API.G_MISS_CHAR ),
1300 NVL( CREDIT_BALANCE_STATEMENTS, FND_API.G_MISS_CHAR ),
1301 NVL( CREDIT_HOLD, FND_API.G_MISS_CHAR ),
1302 NVL( PROFILE_CLASS_ID, FND_API.G_MISS_NUM ),
1303 NVL( SITE_USE_ID, FND_API.G_MISS_NUM ),
1304 NVL( CREDIT_RATING, FND_API.G_MISS_CHAR ),
1305 NVL( RISK_CODE, FND_API.G_MISS_CHAR ),
1306 NVL( STANDARD_TERMS, FND_API.G_MISS_NUM ),
1307 NVL( OVERRIDE_TERMS, FND_API.G_MISS_CHAR ),
1308 NVL( DUNNING_LETTER_SET_ID, FND_API.G_MISS_NUM ),
1309 NVL( INTEREST_PERIOD_DAYS, FND_API.G_MISS_NUM ),
1310 NVL( PAYMENT_GRACE_DAYS, FND_API.G_MISS_NUM ),
1311 NVL( DISCOUNT_GRACE_DAYS, FND_API.G_MISS_NUM ),
1312 NVL( STATEMENT_CYCLE_ID, FND_API.G_MISS_NUM ),
1313 NVL( ACCOUNT_STATUS, FND_API.G_MISS_CHAR ),
1314 NVL( PERCENT_COLLECTABLE, FND_API.G_MISS_NUM ),
1315 NVL( AUTOCASH_HIERARCHY_ID, FND_API.G_MISS_NUM ),
1316 NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1317 NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1318 NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1319 NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1320 NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1321 NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1322 NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1323 NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1324 NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1325 NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1326 NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1327 NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1328 NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1329 NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1330 NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1331 NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1332 NVL( AUTO_REC_INCL_DISPUTED_FLAG, FND_API.G_MISS_CHAR ),
1333 NVL( TAX_PRINTING_OPTION, FND_API.G_MISS_CHAR ),
1334 NVL( CHARGE_ON_FINANCE_CHARGE_FLAG, FND_API.G_MISS_CHAR ),
1335 NVL( GROUPING_RULE_ID, FND_API.G_MISS_NUM ),
1336 NVL( CLEARING_DAYS, FND_API.G_MISS_NUM ),
1337 NVL( JGZZ_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1338 NVL( JGZZ_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1339 NVL( JGZZ_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1340 NVL( JGZZ_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1341 NVL( JGZZ_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1342 NVL( JGZZ_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1343 NVL( JGZZ_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1344 NVL( JGZZ_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1345 NVL( JGZZ_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1346 NVL( JGZZ_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1347 NVL( JGZZ_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1348 NVL( JGZZ_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1349 NVL( JGZZ_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1350 NVL( JGZZ_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1351 NVL( JGZZ_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1352 NVL( JGZZ_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1353 NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1354 NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1355 NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1356 NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1357 NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1358 NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1359 NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1360 NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1361 NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1362 NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1363 NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1364 NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1365 NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1366 NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1367 NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1368 NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
1369 NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
1370 NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
1371 NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
1372 NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
1373 NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1374 NVL( CONS_INV_FLAG, FND_API.G_MISS_CHAR ),
1375 NVL( CONS_INV_TYPE, FND_API.G_MISS_CHAR ),
1376 NVL( AUTOCASH_HIERARCHY_ID_FOR_ADR, FND_API.G_MISS_NUM ),
1377 NVL( LOCKBOX_MATCHING_OPTION, FND_API.G_MISS_CHAR ),
1378 NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
1379 NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
1380 NVL(REVIEW_CYCLE , FND_API.G_MISS_CHAR),
1381 NVL(LAST_CREDIT_REVIEW_DATE , FND_API.G_MISS_DATE),
1382 NVL(PARTY_ID , FND_API.G_MISS_NUM),
1383 NVL(CREDIT_CLASSIFICATION , FND_API.G_MISS_CHAR),
1384 NVL(CONS_BILL_LEVEL, FND_API.G_MISS_CHAR),
1385 NVL(LATE_CHARGE_CALCULATION_TRX, FND_API.G_MISS_CHAR),
1386 NVL(CREDIT_ITEMS_FLAG, FND_API.G_MISS_CHAR),
1387 NVL(DISPUTED_TRANSACTIONS_FLAG, FND_API.G_MISS_CHAR),
1388 NVL(LATE_CHARGE_TYPE, FND_API.G_MISS_CHAR),
1389 NVL(LATE_CHARGE_TERM_ID, FND_API.G_MISS_NUM),
1390 NVL(INTEREST_CALCULATION_PERIOD, FND_API.G_MISS_CHAR),
1391 NVL(HOLD_CHARGED_INVOICES_FLAG, FND_API.G_MISS_CHAR),
1392 NVL(MESSAGE_TEXT_ID, FND_API.G_MISS_NUM),
1393 NVL(MULTIPLE_INTEREST_RATES_FLAG, FND_API.G_MISS_CHAR),
1394 NVL(CHARGE_BEGIN_DATE, FND_API.G_MISS_DATE)
1395 INTO
1396 X_CUST_ACCOUNT_PROFILE_ID,
1397 X_CUST_ACCOUNT_ID,
1398 X_STATUS,
1399 X_COLLECTOR_ID,
1400 X_CREDIT_ANALYST_ID,
1401 X_CREDIT_CHECKING,
1402 X_NEXT_CREDIT_REVIEW_DATE,
1403 X_TOLERANCE,
1404 X_DISCOUNT_TERMS,
1405 X_DUNNING_LETTERS,
1406 X_INTEREST_CHARGES,
1407 X_SEND_STATEMENTS,
1408 X_CREDIT_BALANCE_STATEMENTS,
1409 X_CREDIT_HOLD,
1410 X_PROFILE_CLASS_ID,
1411 X_SITE_USE_ID,
1412 X_CREDIT_RATING,
1413 X_RISK_CODE,
1414 X_STANDARD_TERMS,
1415 X_OVERRIDE_TERMS,
1416 X_DUNNING_LETTER_SET_ID,
1417 X_INTEREST_PERIOD_DAYS,
1418 X_PAYMENT_GRACE_DAYS,
1419 X_DISCOUNT_GRACE_DAYS,
1420 X_STATEMENT_CYCLE_ID,
1421 X_ACCOUNT_STATUS,
1422 X_PERCENT_COLLECTABLE,
1423 X_AUTOCASH_HIERARCHY_ID,
1424 X_ATTRIBUTE_CATEGORY,
1425 X_ATTRIBUTE1,
1426 X_ATTRIBUTE2,
1427 X_ATTRIBUTE3,
1428 X_ATTRIBUTE4,
1429 X_ATTRIBUTE5,
1430 X_ATTRIBUTE6,
1431 X_ATTRIBUTE7,
1432 X_ATTRIBUTE8,
1433 X_ATTRIBUTE9,
1434 X_ATTRIBUTE10,
1435 X_ATTRIBUTE11,
1436 X_ATTRIBUTE12,
1437 X_ATTRIBUTE13,
1438 X_ATTRIBUTE14,
1439 X_ATTRIBUTE15,
1440 X_AUTO_REC_INCL_DISPUTED_FLAG,
1441 X_TAX_PRINTING_OPTION,
1442 X_CHARGE_ON_FINANCE_CHARGE_FG,
1443 X_GROUPING_RULE_ID,
1444 X_CLEARING_DAYS,
1445 X_JGZZ_ATTRIBUTE_CATEGORY,
1446 X_JGZZ_ATTRIBUTE1,
1447 X_JGZZ_ATTRIBUTE2,
1448 X_JGZZ_ATTRIBUTE3,
1449 X_JGZZ_ATTRIBUTE4,
1450 X_JGZZ_ATTRIBUTE5,
1451 X_JGZZ_ATTRIBUTE6,
1452 X_JGZZ_ATTRIBUTE7,
1453 X_JGZZ_ATTRIBUTE8,
1454 X_JGZZ_ATTRIBUTE9,
1455 X_JGZZ_ATTRIBUTE10,
1456 X_JGZZ_ATTRIBUTE11,
1457 X_JGZZ_ATTRIBUTE12,
1458 X_JGZZ_ATTRIBUTE13,
1459 X_JGZZ_ATTRIBUTE14,
1460 X_JGZZ_ATTRIBUTE15,
1461 X_GLOBAL_ATTRIBUTE1,
1462 X_GLOBAL_ATTRIBUTE2,
1463 X_GLOBAL_ATTRIBUTE3,
1464 X_GLOBAL_ATTRIBUTE4,
1465 X_GLOBAL_ATTRIBUTE5,
1466 X_GLOBAL_ATTRIBUTE6,
1467 X_GLOBAL_ATTRIBUTE7,
1468 X_GLOBAL_ATTRIBUTE8,
1469 X_GLOBAL_ATTRIBUTE9,
1470 X_GLOBAL_ATTRIBUTE10,
1471 X_GLOBAL_ATTRIBUTE11,
1472 X_GLOBAL_ATTRIBUTE12,
1473 X_GLOBAL_ATTRIBUTE13,
1474 X_GLOBAL_ATTRIBUTE14,
1475 X_GLOBAL_ATTRIBUTE15,
1476 X_GLOBAL_ATTRIBUTE16,
1477 X_GLOBAL_ATTRIBUTE17,
1478 X_GLOBAL_ATTRIBUTE18,
1479 X_GLOBAL_ATTRIBUTE19,
1480 X_GLOBAL_ATTRIBUTE20,
1481 X_GLOBAL_ATTRIBUTE_CATEGORY,
1482 X_CONS_INV_FLAG,
1483 X_CONS_INV_TYPE,
1484 X_AUTOCASH_HIERARCHY_ID_ADR,
1485 X_LOCKBOX_MATCHING_OPTION,
1486 X_CREATED_BY_MODULE,
1487 X_APPLICATION_ID,
1488 X_REVIEW_CYCLE ,
1489 X_LAST_CREDIT_REVIEW_DATE,
1490 X_PARTY_ID ,
1491 X_CREDIT_CLASSIFICATION,
1492 X_CONS_BILL_LEVEL,
1493 X_LATE_CHARGE_CALCULATION_TRX,
1494 X_CREDIT_ITEMS_FLAG,
1495 X_DISPUTED_TRANSACTIONS_FLAG,
1496 X_LATE_CHARGE_TYPE,
1497 X_LATE_CHARGE_TERM_ID,
1498 X_INTEREST_CALCULATION_PERIOD,
1499 X_HOLD_CHARGED_INVOICES_FLAG,
1500 X_MESSAGE_TEXT_ID,
1501 X_MULTIPLE_INTEREST_RATES_FLAG,
1502 X_CHARGE_BEGIN_DATE
1503 FROM HZ_CUSTOMER_PROFILES
1504 WHERE CUST_ACCOUNT_PROFILE_ID = X_CUST_ACCOUNT_PROFILE_ID;
1505
1506 EXCEPTION
1507 WHEN NO_DATA_FOUND THEN
1508 FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1509 FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer_profile_rec');
1510 FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CUST_ACCOUNT_PROFILE_ID ) );
1511 FND_MSG_PUB.ADD;
1512 RAISE FND_API.G_EXC_ERROR;
1513
1514 END Select_Row;
1515
1516 PROCEDURE Delete_Row (
1517 X_CUST_ACCOUNT_PROFILE_ID IN NUMBER
1518 ) IS
1519
1520 BEGIN
1521
1522 DELETE FROM HZ_CUSTOMER_PROFILES
1523 WHERE CUST_ACCOUNT_PROFILE_ID = X_CUST_ACCOUNT_PROFILE_ID;
1524
1525 IF ( SQL%NOTFOUND ) THEN
1526 RAISE NO_DATA_FOUND;
1527 END IF;
1528
1529 END Delete_Row;
1530
1531 END HZ_CUSTOMER_PROFILES_PKG;