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