[Home] [Help]
PACKAGE BODY: APPS.HZ_CUST_ACCOUNTS_PKG
Source
1 PACKAGE BODY HZ_CUST_ACCOUNTS_PKG AS
2 /*$Header: ARHCACTB.pls 120.6 2007/12/13 11:10:34 rgokavar ship $ */
3
4 PROCEDURE Insert_Row (
5 X_CUST_ACCOUNT_ID IN OUT NOCOPY NUMBER,
6 X_PARTY_ID IN NUMBER,
7 X_ACCOUNT_NUMBER IN OUT NOCOPY VARCHAR2,
8 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
9 X_ATTRIBUTE1 IN VARCHAR2,
10 X_ATTRIBUTE2 IN VARCHAR2,
11 X_ATTRIBUTE3 IN VARCHAR2,
12 X_ATTRIBUTE4 IN VARCHAR2,
13 X_ATTRIBUTE5 IN VARCHAR2,
14 X_ATTRIBUTE6 IN VARCHAR2,
15 X_ATTRIBUTE7 IN VARCHAR2,
16 X_ATTRIBUTE8 IN VARCHAR2,
17 X_ATTRIBUTE9 IN VARCHAR2,
18 X_ATTRIBUTE10 IN VARCHAR2,
19 X_ATTRIBUTE11 IN VARCHAR2,
20 X_ATTRIBUTE12 IN VARCHAR2,
21 X_ATTRIBUTE13 IN VARCHAR2,
22 X_ATTRIBUTE14 IN VARCHAR2,
23 X_ATTRIBUTE15 IN VARCHAR2,
24 X_ATTRIBUTE16 IN VARCHAR2,
25 X_ATTRIBUTE17 IN VARCHAR2,
26 X_ATTRIBUTE18 IN VARCHAR2,
27 X_ATTRIBUTE19 IN VARCHAR2,
28 X_ATTRIBUTE20 IN VARCHAR2,
29 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
30 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
31 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
32 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
33 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
34 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
35 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
36 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
37 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
38 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
39 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
40 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
41 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
42 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
43 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
44 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
45 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
46 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
47 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
48 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
49 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
50 X_ORIG_SYSTEM_REFERENCE IN VARCHAR2,
51 X_STATUS IN VARCHAR2,
52 X_CUSTOMER_TYPE IN VARCHAR2,
53 X_CUSTOMER_CLASS_CODE IN VARCHAR2,
54 X_PRIMARY_SALESREP_ID IN NUMBER,
55 X_SALES_CHANNEL_CODE IN VARCHAR2,
56 X_ORDER_TYPE_ID IN NUMBER,
57 X_PRICE_LIST_ID IN NUMBER,
58 X_TAX_CODE IN VARCHAR2,
59 X_FOB_POINT IN VARCHAR2,
60 X_FREIGHT_TERM IN VARCHAR2,
61 X_SHIP_PARTIAL IN VARCHAR2,
62 X_SHIP_VIA IN VARCHAR2,
63 X_WAREHOUSE_ID IN NUMBER,
64 X_TAX_HEADER_LEVEL_FLAG IN VARCHAR2,
65 X_TAX_ROUNDING_RULE IN VARCHAR2,
66 X_COTERMINATE_DAY_MONTH IN VARCHAR2,
67 X_PRIMARY_SPECIALIST_ID IN NUMBER,
68 X_SECONDARY_SPECIALIST_ID IN NUMBER,
69 X_ACCOUNT_LIABLE_FLAG IN VARCHAR2,
70 X_CURRENT_BALANCE IN NUMBER,
71 X_ACCOUNT_ESTABLISHED_DATE IN DATE,
72 X_ACCOUNT_TERMINATION_DATE IN DATE,
73 X_ACCOUNT_ACTIVATION_DATE IN DATE,
74 X_DEPARTMENT IN VARCHAR2,
75 X_HELD_BILL_EXPIRATION_DATE IN DATE,
76 X_HOLD_BILL_FLAG IN VARCHAR2,
77 X_REALTIME_RATE_FLAG IN VARCHAR2,
78 X_ACCT_LIFE_CYCLE_STATUS IN VARCHAR2,
79 X_ACCOUNT_NAME IN VARCHAR2,
80 X_DEPOSIT_REFUND_METHOD IN VARCHAR2,
81 X_DORMANT_ACCOUNT_FLAG IN VARCHAR2,
82 X_NPA_NUMBER IN VARCHAR2,
83 X_SUSPENSION_DATE IN DATE,
84 X_SOURCE_CODE IN VARCHAR2,
85 X_COMMENTS IN VARCHAR2,
86 X_DATES_NEGATIVE_TOLERANCE IN NUMBER,
87 X_DATES_POSITIVE_TOLERANCE IN NUMBER,
88 X_DATE_TYPE_PREFERENCE IN VARCHAR2,
89 X_OVER_SHIPMENT_TOLERANCE IN NUMBER,
90 X_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
91 X_OVER_RETURN_TOLERANCE IN NUMBER,
92 X_UNDER_RETURN_TOLERANCE IN NUMBER,
93 X_ITEM_CROSS_REF_PREF IN VARCHAR2,
94 X_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
95 X_ARRIVALSETS_INCL_LINES_FLAG IN VARCHAR2,
96 X_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
97 X_INVOICE_QUANTITY_RULE IN VARCHAR2,
98 X_PRICING_EVENT IN VARCHAR2,
99 X_STATUS_UPDATE_DATE IN DATE,
100 X_AUTOPAY_FLAG IN VARCHAR2,
101 X_NOTIFY_FLAG IN VARCHAR2,
102 X_LAST_BATCH_ID IN NUMBER,
103 X_SELLING_PARTY_ID IN NUMBER,
104 X_OBJECT_VERSION_NUMBER IN NUMBER,
105 X_CREATED_BY_MODULE IN VARCHAR2,
106 X_APPLICATION_ID IN NUMBER
107 ) IS
108
109 l_success VARCHAR2(1) := 'N';
110
111 BEGIN
112
113 IF X_CUST_ACCOUNT_ID = FND_API.G_MISS_NUM THEN
114 X_CUST_ACCOUNT_ID := NULL;
115 END IF;
116
117 WHILE l_success = 'N' LOOP
118 BEGIN
119 INSERT INTO HZ_CUST_ACCOUNTS (
120 CUST_ACCOUNT_ID,
121 ACCOUNT_NUMBER,
122 PARTY_ID,
123 LAST_UPDATE_DATE,
124 LAST_UPDATED_BY,
125 CREATION_DATE,
126 CREATED_BY,
127 LAST_UPDATE_LOGIN,
128 REQUEST_ID,
129 PROGRAM_APPLICATION_ID,
130 PROGRAM_ID,
131 PROGRAM_UPDATE_DATE,
132 ATTRIBUTE_CATEGORY,
133 ATTRIBUTE1,
134 ATTRIBUTE2,
135 ATTRIBUTE3,
136 ATTRIBUTE4,
137 ATTRIBUTE5,
138 ATTRIBUTE6,
139 ATTRIBUTE7,
140 ATTRIBUTE8,
141 ATTRIBUTE9,
142 ATTRIBUTE10,
143 ATTRIBUTE11,
144 ATTRIBUTE12,
145 ATTRIBUTE13,
146 ATTRIBUTE14,
147 ATTRIBUTE15,
148 ATTRIBUTE16,
149 ATTRIBUTE17,
150 ATTRIBUTE18,
151 ATTRIBUTE19,
152 ATTRIBUTE20,
153 GLOBAL_ATTRIBUTE_CATEGORY,
154 GLOBAL_ATTRIBUTE1,
155 GLOBAL_ATTRIBUTE2,
156 GLOBAL_ATTRIBUTE3,
157 GLOBAL_ATTRIBUTE4,
158 GLOBAL_ATTRIBUTE5,
159 GLOBAL_ATTRIBUTE6,
160 GLOBAL_ATTRIBUTE7,
161 GLOBAL_ATTRIBUTE8,
162 GLOBAL_ATTRIBUTE9,
163 GLOBAL_ATTRIBUTE10,
164 GLOBAL_ATTRIBUTE11,
165 GLOBAL_ATTRIBUTE12,
166 GLOBAL_ATTRIBUTE13,
167 GLOBAL_ATTRIBUTE14,
168 GLOBAL_ATTRIBUTE15,
169 GLOBAL_ATTRIBUTE16,
170 GLOBAL_ATTRIBUTE17,
171 GLOBAL_ATTRIBUTE18,
172 GLOBAL_ATTRIBUTE19,
173 GLOBAL_ATTRIBUTE20,
174 ORIG_SYSTEM_REFERENCE,
175 STATUS,
176 CUSTOMER_TYPE,
177 CUSTOMER_CLASS_CODE,
178 SALES_CHANNEL_CODE,
179 PRICE_LIST_ID,
180 TAX_CODE,
181 FOB_POINT,
182 FREIGHT_TERM,
183 -- SHIP_PARTIAL,
184 SHIP_VIA,
185 WAREHOUSE_ID,
186 TAX_HEADER_LEVEL_FLAG,
187 TAX_ROUNDING_RULE,
188 COTERMINATE_DAY_MONTH,
189 PRIMARY_SPECIALIST_ID,
190 SECONDARY_SPECIALIST_ID,
191 ACCOUNT_ESTABLISHED_DATE,
192 HELD_BILL_EXPIRATION_DATE,
193 HOLD_BILL_FLAG,
194 ACCOUNT_NAME,
195 DEPOSIT_REFUND_METHOD,
196 NPA_NUMBER,
197 SOURCE_CODE,
198 COMMENTS,
199 DATES_NEGATIVE_TOLERANCE,
200 DATES_POSITIVE_TOLERANCE,
201 DATE_TYPE_PREFERENCE,
202 OVER_SHIPMENT_TOLERANCE,
203 UNDER_SHIPMENT_TOLERANCE,
204 OVER_RETURN_TOLERANCE,
205 UNDER_RETURN_TOLERANCE,
206 ITEM_CROSS_REF_PREF,
207 SHIP_SETS_INCLUDE_LINES_FLAG,
208 ARRIVALSETS_INCLUDE_LINES_FLAG,
209 SCHED_DATE_PUSH_FLAG,
210 INVOICE_QUANTITY_RULE,
211 PRICING_EVENT,
212 STATUS_UPDATE_DATE,
213 AUTOPAY_FLAG,
214 LAST_BATCH_ID,
215 SELLING_PARTY_ID,
216 OBJECT_VERSION_NUMBER,
217 CREATED_BY_MODULE,
218 APPLICATION_ID
219 )
220 VALUES (
221 DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, HZ_CUST_ACCOUNTS_S.NEXTVAL, NULL, HZ_CUST_ACCOUNTS_S.NEXTVAL, X_CUST_ACCOUNT_ID ),
222 DECODE( X_ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), NULL, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), X_ACCOUNT_NUMBER ),
223 DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
224 HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
225 HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
226 HZ_UTILITY_V2PUB.CREATION_DATE,
227 HZ_UTILITY_V2PUB.CREATED_BY,
228 HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
229 HZ_UTILITY_V2PUB.REQUEST_ID,
230 HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
231 HZ_UTILITY_V2PUB.PROGRAM_ID,
232 HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
233 DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
234 DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
235 DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
236 DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
237 DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
238 DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
239 DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
240 DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
241 DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
242 DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
243 DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
244 DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
245 DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
246 DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
247 DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
248 DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
249 DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
250 DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
251 DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
252 DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
253 DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
254 DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
255 DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
256 DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
257 DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
258 DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
259 DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
260 DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
261 DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
262 DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
263 DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
264 DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
265 DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
266 DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
267 DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
268 DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
269 DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
270 DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
271 DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
272 DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
273 DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
274 DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
275 DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCOUNT_ID,HZ_CUST_ACCOUNTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCOUNT_ID,HZ_CUST_ACCOUNTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
276 DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
277 DECODE( X_CUSTOMER_TYPE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_TYPE ),
278 DECODE( X_CUSTOMER_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CLASS_CODE ),
279 DECODE( X_SALES_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, X_SALES_CHANNEL_CODE ),
280 DECODE( X_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, X_PRICE_LIST_ID ),
281 DECODE( X_TAX_CODE, FND_API.G_MISS_CHAR, NULL, X_TAX_CODE ),
282 DECODE( X_FOB_POINT, FND_API.G_MISS_CHAR, NULL, X_FOB_POINT ),
283 DECODE( X_FREIGHT_TERM, FND_API.G_MISS_CHAR, NULL, X_FREIGHT_TERM ),
284 -- DECODE( X_SHIP_PARTIAL, FND_API.G_MISS_CHAR, NULL, X_SHIP_PARTIAL ),
285 DECODE( X_SHIP_VIA, FND_API.G_MISS_CHAR, NULL, X_SHIP_VIA ),
286 DECODE( X_WAREHOUSE_ID, FND_API.G_MISS_NUM, NULL, X_WAREHOUSE_ID ),
287 --Bug 2463928 DECODE( X_TAX_HEADER_LEVEL_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_TAX_HEADER_LEVEL_FLAG ),
288 DECODE( X_TAX_HEADER_LEVEL_FLAG, FND_API.G_MISS_CHAR, NULL, X_TAX_HEADER_LEVEL_FLAG ),
289 DECODE( X_TAX_ROUNDING_RULE, FND_API.G_MISS_CHAR, NULL, X_TAX_ROUNDING_RULE ),
290 DECODE( X_COTERMINATE_DAY_MONTH, FND_API.G_MISS_CHAR, NULL, X_COTERMINATE_DAY_MONTH ),
291 DECODE( X_PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
292 DECODE( X_SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
293 DECODE( X_ACCOUNT_ESTABLISHED_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_ACCOUNT_ESTABLISHED_DATE ),
294 DECODE( X_HELD_BILL_EXPIRATION_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_HELD_BILL_EXPIRATION_DATE ),
295 DECODE( X_HOLD_BILL_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_HOLD_BILL_FLAG ),
299 DECODE( X_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, X_SOURCE_CODE ),
296 DECODE( X_ACCOUNT_NAME, FND_API.G_MISS_CHAR, NULL, X_ACCOUNT_NAME ),
297 DECODE( X_DEPOSIT_REFUND_METHOD, FND_API.G_MISS_CHAR, NULL, X_DEPOSIT_REFUND_METHOD ),
298 DECODE( X_NPA_NUMBER, FND_API.G_MISS_CHAR, NULL, X_NPA_NUMBER ),
300 DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
301 DECODE( X_DATES_NEGATIVE_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_DATES_NEGATIVE_TOLERANCE ),
302 DECODE( X_DATES_POSITIVE_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_DATES_POSITIVE_TOLERANCE ),
303 DECODE( X_DATE_TYPE_PREFERENCE, FND_API.G_MISS_CHAR, NULL, X_DATE_TYPE_PREFERENCE ),
304 DECODE( X_OVER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_OVER_SHIPMENT_TOLERANCE ),
305 DECODE( X_UNDER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_UNDER_SHIPMENT_TOLERANCE ),
306 DECODE( X_OVER_RETURN_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_OVER_RETURN_TOLERANCE ),
307 DECODE( X_UNDER_RETURN_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_UNDER_RETURN_TOLERANCE ),
308 DECODE( X_ITEM_CROSS_REF_PREF, FND_API.G_MISS_CHAR, NULL, X_ITEM_CROSS_REF_PREF ),
309 DECODE( X_SHIP_SETS_INCLUDE_LINES_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_SHIP_SETS_INCLUDE_LINES_FLAG ),
310 DECODE( X_ARRIVALSETS_INCL_LINES_FLAG, FND_API.G_MISS_CHAR, NULL, X_ARRIVALSETS_INCL_LINES_FLAG ),
311 DECODE( X_SCHED_DATE_PUSH_FLAG, FND_API.G_MISS_CHAR, NULL, X_SCHED_DATE_PUSH_FLAG ),
312 DECODE( X_INVOICE_QUANTITY_RULE, FND_API.G_MISS_CHAR, NULL, X_INVOICE_QUANTITY_RULE ),
313 DECODE( X_PRICING_EVENT, FND_API.G_MISS_CHAR, NULL, X_PRICING_EVENT ),
314 DECODE( X_STATUS_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_STATUS_UPDATE_DATE ),
315 DECODE( X_AUTOPAY_FLAG, FND_API.G_MISS_CHAR, NULL, X_AUTOPAY_FLAG ),
316 DECODE( X_LAST_BATCH_ID, FND_API.G_MISS_NUM, NULL, X_LAST_BATCH_ID ),
317 DECODE( X_SELLING_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_SELLING_PARTY_ID ),
318 DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
319 DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
320 DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
321 ) RETURNING
322 CUST_ACCOUNT_ID,
323 ACCOUNT_NUMBER
324 INTO
325 X_CUST_ACCOUNT_ID,
326 X_ACCOUNT_NUMBER;
327
328 l_success := 'Y';
329
330 EXCEPTION
331 WHEN DUP_VAL_ON_INDEX THEN
332 IF INSTRB( SQLERRM, 'HZ_CUST_ACCOUNTS_U1' ) <> 0 OR
333 INSTRB( SQLERRM, 'HZ_CUST_ACCOUNTS_PK' ) <> 0
334 THEN
335 DECLARE
336 l_count NUMBER;
337 l_dummy VARCHAR2(1);
338 BEGIN
339 l_count := 1;
340 WHILE l_count > 0 LOOP
341 SELECT HZ_CUST_ACCOUNTS_S.NEXTVAL
342 INTO X_CUST_ACCOUNT_ID FROM dual;
343 BEGIN
344 SELECT 'Y' INTO l_dummy
345 FROM HZ_CUST_ACCOUNTS
346 WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID;
347 l_count := 1;
348 EXCEPTION
349 WHEN NO_DATA_FOUND THEN
350 l_count := 0;
351 END;
352 END LOOP;
353 END;
354 ELSIF INSTRB( SQLERRM, 'HZ_CUST_ACCOUNTS_U2' ) <> 0 THEN
355 DECLARE
356 l_count NUMBER;
357 l_dummy VARCHAR2(1);
358 l_profile VARCHAR2(1);
359 BEGIN
360 -- Bug6521505 If Generate (Automatic) Customer Number Flag (Profile) is set to 'N'
361 -- System should not Generate Account number from Sequence, and also
362 -- system should raise an Error.
363
364 l_profile := HZ_MO_GLOBAL_CACHE.Get_Generate_Customer_Number;
365
366 IF l_profile = 'N' THEN
367 FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
368 FND_MESSAGE.SET_TOKEN( 'COLUMN', 'account_number' );
369 FND_MSG_PUB.ADD;
370 RAISE FND_API.G_EXC_ERROR;
371 END IF ;
372
373 l_count := 1;
374 WHILE l_count > 0 LOOP
375 SELECT TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL )
376 INTO X_ACCOUNT_NUMBER FROM dual;
377 BEGIN
378 SELECT 'Y' INTO l_dummy
379 FROM HZ_CUST_ACCOUNTS
380 WHERE ACCOUNT_NUMBER = X_ACCOUNT_NUMBER;
381 l_count := 1;
382 EXCEPTION
383 WHEN NO_DATA_FOUND THEN
384 l_count := 0;
385 END;
386 END LOOP;
387 END;
388 ELSE
389 RAISE;
390 END IF;
391
392 END;
393 END LOOP;
394
395 END Insert_Row;
396
397 PROCEDURE Update_Row (
398 X_Rowid IN OUT NOCOPY VARCHAR2,
399 X_CUST_ACCOUNT_ID IN NUMBER,
400 X_PARTY_ID IN NUMBER,
401 X_ACCOUNT_NUMBER IN VARCHAR2,
405 X_ATTRIBUTE3 IN VARCHAR2,
402 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
403 X_ATTRIBUTE1 IN VARCHAR2,
404 X_ATTRIBUTE2 IN VARCHAR2,
406 X_ATTRIBUTE4 IN VARCHAR2,
407 X_ATTRIBUTE5 IN VARCHAR2,
408 X_ATTRIBUTE6 IN VARCHAR2,
409 X_ATTRIBUTE7 IN VARCHAR2,
410 X_ATTRIBUTE8 IN VARCHAR2,
411 X_ATTRIBUTE9 IN VARCHAR2,
412 X_ATTRIBUTE10 IN VARCHAR2,
413 X_ATTRIBUTE11 IN VARCHAR2,
414 X_ATTRIBUTE12 IN VARCHAR2,
415 X_ATTRIBUTE13 IN VARCHAR2,
416 X_ATTRIBUTE14 IN VARCHAR2,
417 X_ATTRIBUTE15 IN VARCHAR2,
418 X_ATTRIBUTE16 IN VARCHAR2,
419 X_ATTRIBUTE17 IN VARCHAR2,
420 X_ATTRIBUTE18 IN VARCHAR2,
421 X_ATTRIBUTE19 IN VARCHAR2,
422 X_ATTRIBUTE20 IN VARCHAR2,
423 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
424 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
425 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
426 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
427 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
428 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
429 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
430 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
431 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
432 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
433 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
434 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
435 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
436 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
437 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
438 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
439 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
440 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
441 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
442 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
443 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
444 X_ORIG_SYSTEM_REFERENCE IN VARCHAR2,
445 X_STATUS IN VARCHAR2,
446 X_CUSTOMER_TYPE IN VARCHAR2,
447 X_CUSTOMER_CLASS_CODE IN VARCHAR2,
448 X_PRIMARY_SALESREP_ID IN NUMBER,
449 X_SALES_CHANNEL_CODE IN VARCHAR2,
450 X_ORDER_TYPE_ID IN NUMBER,
451 X_PRICE_LIST_ID IN NUMBER,
452 X_TAX_CODE IN VARCHAR2,
453 X_FOB_POINT IN VARCHAR2,
454 X_FREIGHT_TERM IN VARCHAR2,
455 X_SHIP_PARTIAL IN VARCHAR2,
456 X_SHIP_VIA IN VARCHAR2,
457 X_WAREHOUSE_ID IN NUMBER,
458 X_TAX_HEADER_LEVEL_FLAG IN VARCHAR2,
459 X_TAX_ROUNDING_RULE IN VARCHAR2,
460 X_COTERMINATE_DAY_MONTH IN VARCHAR2,
461 X_PRIMARY_SPECIALIST_ID IN NUMBER,
462 X_SECONDARY_SPECIALIST_ID IN NUMBER,
463 X_ACCOUNT_LIABLE_FLAG IN VARCHAR2,
464 X_CURRENT_BALANCE IN NUMBER,
465 X_ACCOUNT_ESTABLISHED_DATE IN DATE,
466 X_ACCOUNT_TERMINATION_DATE IN DATE,
467 X_ACCOUNT_ACTIVATION_DATE IN DATE,
468 X_DEPARTMENT IN VARCHAR2,
469 X_HELD_BILL_EXPIRATION_DATE IN DATE,
470 X_HOLD_BILL_FLAG IN VARCHAR2,
471 X_REALTIME_RATE_FLAG IN VARCHAR2,
472 X_ACCT_LIFE_CYCLE_STATUS IN VARCHAR2,
473 X_ACCOUNT_NAME IN VARCHAR2,
474 X_DEPOSIT_REFUND_METHOD IN VARCHAR2,
475 X_DORMANT_ACCOUNT_FLAG IN VARCHAR2,
476 X_NPA_NUMBER IN VARCHAR2,
477 X_SUSPENSION_DATE IN DATE,
478 X_SOURCE_CODE IN VARCHAR2,
479 X_COMMENTS IN VARCHAR2,
480 X_DATES_NEGATIVE_TOLERANCE IN NUMBER,
481 X_DATES_POSITIVE_TOLERANCE IN NUMBER,
482 X_DATE_TYPE_PREFERENCE IN VARCHAR2,
483 X_OVER_SHIPMENT_TOLERANCE IN NUMBER,
484 X_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
485 X_OVER_RETURN_TOLERANCE IN NUMBER,
486 X_UNDER_RETURN_TOLERANCE IN NUMBER,
487 X_ITEM_CROSS_REF_PREF IN VARCHAR2,
488 X_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
489 X_ARRIVALSETS_INCL_LINES_FLAG IN VARCHAR2,
490 X_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
491 X_INVOICE_QUANTITY_RULE IN VARCHAR2,
495 X_NOTIFY_FLAG IN VARCHAR2,
492 X_PRICING_EVENT IN VARCHAR2,
493 X_STATUS_UPDATE_DATE IN DATE,
494 X_AUTOPAY_FLAG IN VARCHAR2,
496 X_LAST_BATCH_ID IN NUMBER,
497 X_SELLING_PARTY_ID IN NUMBER,
498 X_OBJECT_VERSION_NUMBER IN NUMBER,
499 X_CREATED_BY_MODULE IN VARCHAR2,
500 X_APPLICATION_ID IN NUMBER
501 ) IS
502
503 BEGIN
504
505 UPDATE HZ_CUST_ACCOUNTS SET
506 CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
507 PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
508 LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
509 ACCOUNT_NUMBER = DECODE( X_ACCOUNT_NUMBER, NULL, ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_ACCOUNT_NUMBER ),
510 LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
511 CREATION_DATE = CREATION_DATE,
512 CREATED_BY = CREATED_BY,
513 LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
514 REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
515 PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
516 PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
517 PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
518 ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
519 ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
520 ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
521 ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
522 ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
523 ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
524 ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
525 ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
526 ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
527 ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
528 ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
529 ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
530 ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
531 ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
532 ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
533 ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
534 ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
535 ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
536 ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
537 ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
538 ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
539 GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
540 GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
541 GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
542 GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
543 GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
544 GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
545 GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
546 GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
547 GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
548 GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
549 GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
550 GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
551 GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
552 GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
553 GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
554 GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
558 GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
555 GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
556 GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
557 GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
559 GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
560 ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_CUST_ACCOUNT_ID), X_ORIG_SYSTEM_REFERENCE ),
561 STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
562 CUSTOMER_TYPE = DECODE( X_CUSTOMER_TYPE, NULL, CUSTOMER_TYPE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_TYPE ),
563 CUSTOMER_CLASS_CODE = DECODE( X_CUSTOMER_CLASS_CODE, NULL, CUSTOMER_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CLASS_CODE ),
564 SALES_CHANNEL_CODE = DECODE( X_SALES_CHANNEL_CODE, NULL, SALES_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, X_SALES_CHANNEL_CODE ),
565 PRICE_LIST_ID = DECODE( X_PRICE_LIST_ID, NULL, PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, X_PRICE_LIST_ID ),
566 TAX_CODE = DECODE( X_TAX_CODE, NULL, TAX_CODE, FND_API.G_MISS_CHAR, NULL, X_TAX_CODE ),
567 FOB_POINT = DECODE( X_FOB_POINT, NULL, FOB_POINT, FND_API.G_MISS_CHAR, NULL, X_FOB_POINT ),
568 FREIGHT_TERM = DECODE( X_FREIGHT_TERM, NULL, FREIGHT_TERM, FND_API.G_MISS_CHAR, NULL, X_FREIGHT_TERM ),
569 -- SHIP_PARTIAL = DECODE( X_SHIP_PARTIAL, NULL, SHIP_PARTIAL, FND_API.G_MISS_CHAR, NULL, X_SHIP_PARTIAL ),
570 SHIP_VIA = DECODE( X_SHIP_VIA, NULL, SHIP_VIA, FND_API.G_MISS_CHAR, NULL, X_SHIP_VIA ),
571 WAREHOUSE_ID = DECODE( X_WAREHOUSE_ID, NULL, WAREHOUSE_ID, FND_API.G_MISS_NUM, NULL, X_WAREHOUSE_ID ),
572 --Bug 2463928 User is allowed to choose NULL value for tax_header_level_flag
573 TAX_HEADER_LEVEL_FLAG = DECODE( X_TAX_HEADER_LEVEL_FLAG, NULL, TAX_HEADER_LEVEL_FLAG, FND_API.G_MISS_CHAR, NULL, X_TAX_HEADER_LEVEL_FLAG ),
574 TAX_ROUNDING_RULE = DECODE( X_TAX_ROUNDING_RULE, NULL, TAX_ROUNDING_RULE, FND_API.G_MISS_CHAR, NULL, X_TAX_ROUNDING_RULE ),
575 COTERMINATE_DAY_MONTH = DECODE( X_COTERMINATE_DAY_MONTH, NULL, COTERMINATE_DAY_MONTH, FND_API.G_MISS_CHAR, NULL, X_COTERMINATE_DAY_MONTH ),
576 PRIMARY_SPECIALIST_ID = DECODE( X_PRIMARY_SPECIALIST_ID, NULL, PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
577 SECONDARY_SPECIALIST_ID = DECODE( X_SECONDARY_SPECIALIST_ID, NULL, SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
578 ACCOUNT_ESTABLISHED_DATE = DECODE( X_ACCOUNT_ESTABLISHED_DATE, NULL, ACCOUNT_ESTABLISHED_DATE, FND_API.G_MISS_DATE, NULL, X_ACCOUNT_ESTABLISHED_DATE ),
579 HELD_BILL_EXPIRATION_DATE = DECODE( X_HELD_BILL_EXPIRATION_DATE, NULL, HELD_BILL_EXPIRATION_DATE, FND_API.G_MISS_DATE, NULL, X_HELD_BILL_EXPIRATION_DATE ),
580 HOLD_BILL_FLAG = DECODE( X_HOLD_BILL_FLAG, NULL, HOLD_BILL_FLAG, FND_API.G_MISS_CHAR, 'N', X_HOLD_BILL_FLAG ),
581 ACCOUNT_NAME = DECODE( X_ACCOUNT_NAME, NULL, ACCOUNT_NAME, FND_API.G_MISS_CHAR, NULL, X_ACCOUNT_NAME ),
582 DEPOSIT_REFUND_METHOD = DECODE( X_DEPOSIT_REFUND_METHOD, NULL, DEPOSIT_REFUND_METHOD, FND_API.G_MISS_CHAR, NULL, X_DEPOSIT_REFUND_METHOD ),
583 NPA_NUMBER = DECODE( X_NPA_NUMBER, NULL, NPA_NUMBER, FND_API.G_MISS_CHAR, NULL, X_NPA_NUMBER ),
584 SOURCE_CODE = DECODE( X_SOURCE_CODE, NULL, SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, X_SOURCE_CODE ),
585 COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
586 DATES_NEGATIVE_TOLERANCE = DECODE( X_DATES_NEGATIVE_TOLERANCE, NULL, DATES_NEGATIVE_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_DATES_NEGATIVE_TOLERANCE ),
587 DATES_POSITIVE_TOLERANCE = DECODE( X_DATES_POSITIVE_TOLERANCE, NULL, DATES_POSITIVE_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_DATES_POSITIVE_TOLERANCE ),
588 DATE_TYPE_PREFERENCE = DECODE( X_DATE_TYPE_PREFERENCE, NULL, DATE_TYPE_PREFERENCE, FND_API.G_MISS_CHAR, NULL, X_DATE_TYPE_PREFERENCE ),
589 OVER_SHIPMENT_TOLERANCE = DECODE( X_OVER_SHIPMENT_TOLERANCE, NULL, OVER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_OVER_SHIPMENT_TOLERANCE ),
590 UNDER_SHIPMENT_TOLERANCE = DECODE( X_UNDER_SHIPMENT_TOLERANCE, NULL, UNDER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_UNDER_SHIPMENT_TOLERANCE ),
591 OVER_RETURN_TOLERANCE = DECODE( X_OVER_RETURN_TOLERANCE, NULL, OVER_RETURN_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_OVER_RETURN_TOLERANCE ),
592 UNDER_RETURN_TOLERANCE = DECODE( X_UNDER_RETURN_TOLERANCE, NULL, UNDER_RETURN_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_UNDER_RETURN_TOLERANCE ),
593 ITEM_CROSS_REF_PREF = DECODE( X_ITEM_CROSS_REF_PREF, NULL, ITEM_CROSS_REF_PREF, FND_API.G_MISS_CHAR, NULL, X_ITEM_CROSS_REF_PREF ),
594 SHIP_SETS_INCLUDE_LINES_FLAG = DECODE( X_SHIP_SETS_INCLUDE_LINES_FLAG, NULL, SHIP_SETS_INCLUDE_LINES_FLAG, FND_API.G_MISS_CHAR, 'N', X_SHIP_SETS_INCLUDE_LINES_FLAG ),
595 ARRIVALSETS_INCLUDE_LINES_FLAG = DECODE( X_ARRIVALSETS_INCL_LINES_FLAG, NULL, ARRIVALSETS_INCLUDE_LINES_FLAG, FND_API.G_MISS_CHAR, NULL, X_ARRIVALSETS_INCL_LINES_FLAG ),
596 SCHED_DATE_PUSH_FLAG = DECODE( X_SCHED_DATE_PUSH_FLAG, NULL, SCHED_DATE_PUSH_FLAG, FND_API.G_MISS_CHAR, NULL, X_SCHED_DATE_PUSH_FLAG ),
597 INVOICE_QUANTITY_RULE = DECODE( X_INVOICE_QUANTITY_RULE, NULL, INVOICE_QUANTITY_RULE, FND_API.G_MISS_CHAR, NULL, X_INVOICE_QUANTITY_RULE ),
598 PRICING_EVENT = DECODE( X_PRICING_EVENT, NULL, PRICING_EVENT, FND_API.G_MISS_CHAR, NULL, X_PRICING_EVENT ),
599 STATUS_UPDATE_DATE = DECODE( X_STATUS_UPDATE_DATE, NULL, STATUS_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, X_STATUS_UPDATE_DATE ),
600 AUTOPAY_FLAG = DECODE( X_AUTOPAY_FLAG, NULL, AUTOPAY_FLAG, FND_API.G_MISS_CHAR, NULL, X_AUTOPAY_FLAG ),
604 CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
601 LAST_BATCH_ID = DECODE( X_LAST_BATCH_ID, NULL, LAST_BATCH_ID, FND_API.G_MISS_NUM, NULL, X_LAST_BATCH_ID ),
602 SELLING_PARTY_ID = DECODE( X_SELLING_PARTY_ID, NULL, SELLING_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_SELLING_PARTY_ID ),
603 OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
605 APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
606 WHERE ROWID = X_RowId;
607
608 IF ( SQL%NOTFOUND ) THEN
609 RAISE NO_DATA_FOUND;
610 END IF;
611
612 END Update_Row;
613
614 PROCEDURE Lock_Row (
615 X_Rowid IN OUT NOCOPY VARCHAR2,
616 X_CUST_ACCOUNT_ID IN NUMBER,
617 X_PARTY_ID IN NUMBER,
618 X_LAST_UPDATE_DATE IN DATE,
619 X_ACCOUNT_NUMBER IN VARCHAR2,
620 X_LAST_UPDATED_BY IN NUMBER,
621 X_CREATION_DATE IN DATE,
622 X_CREATED_BY IN NUMBER,
623 X_LAST_UPDATE_LOGIN IN NUMBER,
624 X_REQUEST_ID IN NUMBER,
625 X_PROGRAM_APPLICATION_ID IN NUMBER,
626 X_PROGRAM_ID IN NUMBER,
627 X_PROGRAM_UPDATE_DATE IN DATE,
628 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
629 X_ATTRIBUTE1 IN VARCHAR2,
630 X_ATTRIBUTE2 IN VARCHAR2,
631 X_ATTRIBUTE3 IN VARCHAR2,
632 X_ATTRIBUTE4 IN VARCHAR2,
633 X_ATTRIBUTE5 IN VARCHAR2,
634 X_ATTRIBUTE6 IN VARCHAR2,
635 X_ATTRIBUTE7 IN VARCHAR2,
636 X_ATTRIBUTE8 IN VARCHAR2,
637 X_ATTRIBUTE9 IN VARCHAR2,
638 X_ATTRIBUTE10 IN VARCHAR2,
639 X_ATTRIBUTE11 IN VARCHAR2,
640 X_ATTRIBUTE12 IN VARCHAR2,
641 X_ATTRIBUTE13 IN VARCHAR2,
642 X_ATTRIBUTE14 IN VARCHAR2,
643 X_ATTRIBUTE15 IN VARCHAR2,
644 X_ATTRIBUTE16 IN VARCHAR2,
645 X_ATTRIBUTE17 IN VARCHAR2,
646 X_ATTRIBUTE18 IN VARCHAR2,
647 X_ATTRIBUTE19 IN VARCHAR2,
648 X_ATTRIBUTE20 IN VARCHAR2,
649 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
650 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
651 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
652 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
653 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
654 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
655 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
656 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
657 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
658 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
659 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
660 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
661 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
662 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
663 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
664 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
665 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
666 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
667 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
668 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
669 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
670 X_ORIG_SYSTEM_REFERENCE IN VARCHAR2,
671 X_STATUS IN VARCHAR2,
672 X_CUSTOMER_TYPE IN VARCHAR2,
673 X_CUSTOMER_CLASS_CODE IN VARCHAR2,
674 X_PRIMARY_SALESREP_ID IN NUMBER,
675 X_SALES_CHANNEL_CODE IN VARCHAR2,
676 X_ORDER_TYPE_ID IN NUMBER,
677 X_PRICE_LIST_ID IN NUMBER,
678 X_TAX_CODE IN VARCHAR2,
679 X_FOB_POINT IN VARCHAR2,
680 X_FREIGHT_TERM IN VARCHAR2,
681 X_SHIP_PARTIAL IN VARCHAR2,
682 X_SHIP_VIA IN VARCHAR2,
683 X_WAREHOUSE_ID IN NUMBER,
684 X_TAX_HEADER_LEVEL_FLAG IN VARCHAR2,
685 X_TAX_ROUNDING_RULE IN VARCHAR2,
686 X_COTERMINATE_DAY_MONTH IN VARCHAR2,
687 X_PRIMARY_SPECIALIST_ID IN NUMBER,
688 X_SECONDARY_SPECIALIST_ID IN NUMBER,
689 X_ACCOUNT_LIABLE_FLAG IN VARCHAR2,
690 X_CURRENT_BALANCE IN NUMBER,
691 X_ACCOUNT_ESTABLISHED_DATE IN DATE,
692 X_ACCOUNT_TERMINATION_DATE IN DATE,
693 X_ACCOUNT_ACTIVATION_DATE IN DATE,
694 X_DEPARTMENT IN VARCHAR2,
698 X_ACCT_LIFE_CYCLE_STATUS IN VARCHAR2,
695 X_HELD_BILL_EXPIRATION_DATE IN DATE,
696 X_HOLD_BILL_FLAG IN VARCHAR2,
697 X_REALTIME_RATE_FLAG IN VARCHAR2,
699 X_ACCOUNT_NAME IN VARCHAR2,
700 X_DEPOSIT_REFUND_METHOD IN VARCHAR2,
701 X_DORMANT_ACCOUNT_FLAG IN VARCHAR2,
702 X_NPA_NUMBER IN VARCHAR2,
703 X_SUSPENSION_DATE IN DATE,
704 X_SOURCE_CODE IN VARCHAR2,
705 X_COMMENTS IN VARCHAR2,
706 X_DATES_NEGATIVE_TOLERANCE IN NUMBER,
707 X_DATES_POSITIVE_TOLERANCE IN NUMBER,
708 X_DATE_TYPE_PREFERENCE IN VARCHAR2,
709 X_OVER_SHIPMENT_TOLERANCE IN NUMBER,
710 X_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
711 X_OVER_RETURN_TOLERANCE IN NUMBER,
712 X_UNDER_RETURN_TOLERANCE IN NUMBER,
713 X_ITEM_CROSS_REF_PREF IN VARCHAR2,
714 X_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
715 X_ARRIVALSETS_INCL_LINES_FLAG IN VARCHAR2,
716 X_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
717 X_INVOICE_QUANTITY_RULE IN VARCHAR2,
718 X_PRICING_EVENT IN VARCHAR2,
719 X_STATUS_UPDATE_DATE IN DATE,
720 X_AUTOPAY_FLAG IN VARCHAR2,
721 X_NOTIFY_FLAG IN VARCHAR2,
722 X_LAST_BATCH_ID IN NUMBER,
723 X_SELLING_PARTY_ID IN NUMBER,
724 X_OBJECT_VERSION_NUMBER IN NUMBER,
725 X_CREATED_BY_MODULE IN VARCHAR2,
726 X_APPLICATION_ID IN NUMBER
727 ) IS
728
729 CURSOR C IS
730 SELECT * FROM HZ_CUST_ACCOUNTS
731 WHERE ROWID = x_Rowid
732 FOR UPDATE NOWAIT;
733 Recinfo C%ROWTYPE;
734
735 BEGIN
736
737 OPEN C;
738 FETCH C INTO Recinfo;
739 IF ( C%NOTFOUND ) THEN
740 CLOSE C;
741 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
742 APP_EXCEPTION.RAISE_EXCEPTION;
743 END IF;
744 CLOSE C;
745
746 IF (
747 ( ( Recinfo.CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID )
748 OR ( ( Recinfo.CUST_ACCOUNT_ID IS NULL )
749 AND ( X_CUST_ACCOUNT_ID IS NULL ) ) )
750 AND ( ( Recinfo.PARTY_ID = X_PARTY_ID )
751 OR ( ( Recinfo.PARTY_ID IS NULL )
752 AND ( X_PARTY_ID IS NULL ) ) )
753 AND ( ( Recinfo.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE )
754 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
755 AND ( X_LAST_UPDATE_DATE IS NULL ) ) )
756 AND ( ( Recinfo.ACCOUNT_NUMBER = X_ACCOUNT_NUMBER )
757 OR ( ( Recinfo.ACCOUNT_NUMBER IS NULL )
758 AND ( X_ACCOUNT_NUMBER IS NULL ) ) )
759 AND ( ( Recinfo.LAST_UPDATED_BY = X_LAST_UPDATED_BY )
760 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
761 AND ( X_LAST_UPDATED_BY IS NULL ) ) )
762 AND ( ( Recinfo.CREATION_DATE = X_CREATION_DATE )
763 OR ( ( Recinfo.CREATION_DATE IS NULL )
764 AND ( X_CREATION_DATE IS NULL ) ) )
765 AND ( ( Recinfo.CREATED_BY = X_CREATED_BY )
766 OR ( ( Recinfo.CREATED_BY IS NULL )
767 AND ( X_CREATED_BY IS NULL ) ) )
768 AND ( ( Recinfo.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN )
769 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
770 AND ( X_LAST_UPDATE_LOGIN IS NULL ) ) )
771 AND ( ( Recinfo.REQUEST_ID = X_REQUEST_ID )
772 OR ( ( Recinfo.REQUEST_ID IS NULL )
773 AND ( X_REQUEST_ID IS NULL ) ) )
774 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID )
775 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
776 AND ( X_PROGRAM_APPLICATION_ID IS NULL ) ) )
777 AND ( ( Recinfo.PROGRAM_ID = X_PROGRAM_ID )
778 OR ( ( Recinfo.PROGRAM_ID IS NULL )
779 AND ( X_PROGRAM_ID IS NULL ) ) )
780 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE )
781 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
782 AND ( X_PROGRAM_UPDATE_DATE IS NULL ) ) )
783 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY )
784 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
785 AND ( X_ATTRIBUTE_CATEGORY IS NULL ) ) )
786 AND ( ( Recinfo.ATTRIBUTE1 = X_ATTRIBUTE1 )
787 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
788 AND ( X_ATTRIBUTE1 IS NULL ) ) )
789 AND ( ( Recinfo.ATTRIBUTE2 = X_ATTRIBUTE2 )
790 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
791 AND ( X_ATTRIBUTE2 IS NULL ) ) )
792 AND ( ( Recinfo.ATTRIBUTE3 = X_ATTRIBUTE3 )
793 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
794 AND ( X_ATTRIBUTE3 IS NULL ) ) )
795 AND ( ( Recinfo.ATTRIBUTE4 = X_ATTRIBUTE4 )
796 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
797 AND ( X_ATTRIBUTE4 IS NULL ) ) )
798 AND ( ( Recinfo.ATTRIBUTE5 = X_ATTRIBUTE5 )
799 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
800 AND ( X_ATTRIBUTE5 IS NULL ) ) )
801 AND ( ( Recinfo.ATTRIBUTE6 = X_ATTRIBUTE6 )
802 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
803 AND ( X_ATTRIBUTE6 IS NULL ) ) )
804 AND ( ( Recinfo.ATTRIBUTE7 = X_ATTRIBUTE7 )
805 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
806 AND ( X_ATTRIBUTE7 IS NULL ) ) )
807 AND ( ( Recinfo.ATTRIBUTE8 = X_ATTRIBUTE8 )
808 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
812 AND ( X_ATTRIBUTE9 IS NULL ) ) )
809 AND ( X_ATTRIBUTE8 IS NULL ) ) )
810 AND ( ( Recinfo.ATTRIBUTE9 = X_ATTRIBUTE9 )
811 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
813 AND ( ( Recinfo.ATTRIBUTE10 = X_ATTRIBUTE10 )
814 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
815 AND ( X_ATTRIBUTE10 IS NULL ) ) )
816 AND ( ( Recinfo.ATTRIBUTE11 = X_ATTRIBUTE11 )
817 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
818 AND ( X_ATTRIBUTE11 IS NULL ) ) )
819 AND ( ( Recinfo.ATTRIBUTE12 = X_ATTRIBUTE12 )
820 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
821 AND ( X_ATTRIBUTE12 IS NULL ) ) )
822 AND ( ( Recinfo.ATTRIBUTE13 = X_ATTRIBUTE13 )
823 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
824 AND ( X_ATTRIBUTE13 IS NULL ) ) )
825 AND ( ( Recinfo.ATTRIBUTE14 = X_ATTRIBUTE14 )
826 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
827 AND ( X_ATTRIBUTE14 IS NULL ) ) )
828 AND ( ( Recinfo.ATTRIBUTE15 = X_ATTRIBUTE15 )
829 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
830 AND ( X_ATTRIBUTE15 IS NULL ) ) )
831 AND ( ( Recinfo.ATTRIBUTE16 = X_ATTRIBUTE16 )
832 OR ( ( Recinfo.ATTRIBUTE16 IS NULL )
833 AND ( X_ATTRIBUTE16 IS NULL ) ) )
834 AND ( ( Recinfo.ATTRIBUTE17 = X_ATTRIBUTE17 )
835 OR ( ( Recinfo.ATTRIBUTE17 IS NULL )
836 AND ( X_ATTRIBUTE17 IS NULL ) ) )
837 AND ( ( Recinfo.ATTRIBUTE18 = X_ATTRIBUTE18 )
838 OR ( ( Recinfo.ATTRIBUTE18 IS NULL )
839 AND ( X_ATTRIBUTE18 IS NULL ) ) )
840 AND ( ( Recinfo.ATTRIBUTE19 = X_ATTRIBUTE19 )
841 OR ( ( Recinfo.ATTRIBUTE19 IS NULL )
842 AND ( X_ATTRIBUTE19 IS NULL ) ) )
843 AND ( ( Recinfo.ATTRIBUTE20 = X_ATTRIBUTE20 )
844 OR ( ( Recinfo.ATTRIBUTE20 IS NULL )
845 AND ( X_ATTRIBUTE20 IS NULL ) ) )
846 AND ( ( Recinfo.GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY )
847 OR ( ( Recinfo.GLOBAL_ATTRIBUTE_CATEGORY IS NULL )
848 AND ( X_GLOBAL_ATTRIBUTE_CATEGORY IS NULL ) ) )
849 AND ( ( Recinfo.GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1 )
850 OR ( ( Recinfo.GLOBAL_ATTRIBUTE1 IS NULL )
851 AND ( X_GLOBAL_ATTRIBUTE1 IS NULL ) ) )
852 AND ( ( Recinfo.GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2 )
853 OR ( ( Recinfo.GLOBAL_ATTRIBUTE2 IS NULL )
854 AND ( X_GLOBAL_ATTRIBUTE2 IS NULL ) ) )
855 AND ( ( Recinfo.GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3 )
856 OR ( ( Recinfo.GLOBAL_ATTRIBUTE3 IS NULL )
857 AND ( X_GLOBAL_ATTRIBUTE3 IS NULL ) ) )
858 AND ( ( Recinfo.GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4 )
859 OR ( ( Recinfo.GLOBAL_ATTRIBUTE4 IS NULL )
860 AND ( X_GLOBAL_ATTRIBUTE4 IS NULL ) ) )
861 AND ( ( Recinfo.GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5 )
862 OR ( ( Recinfo.GLOBAL_ATTRIBUTE5 IS NULL )
863 AND ( X_GLOBAL_ATTRIBUTE5 IS NULL ) ) )
864 AND ( ( Recinfo.GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6 )
865 OR ( ( Recinfo.GLOBAL_ATTRIBUTE6 IS NULL )
866 AND ( X_GLOBAL_ATTRIBUTE6 IS NULL ) ) )
867 AND ( ( Recinfo.GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7 )
868 OR ( ( Recinfo.GLOBAL_ATTRIBUTE7 IS NULL )
869 AND ( X_GLOBAL_ATTRIBUTE7 IS NULL ) ) )
870 AND ( ( Recinfo.GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8 )
871 OR ( ( Recinfo.GLOBAL_ATTRIBUTE8 IS NULL )
872 AND ( X_GLOBAL_ATTRIBUTE8 IS NULL ) ) )
873 AND ( ( Recinfo.GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9 )
874 OR ( ( Recinfo.GLOBAL_ATTRIBUTE9 IS NULL )
875 AND ( X_GLOBAL_ATTRIBUTE9 IS NULL ) ) )
876 AND ( ( Recinfo.GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10 )
877 OR ( ( Recinfo.GLOBAL_ATTRIBUTE10 IS NULL )
878 AND ( X_GLOBAL_ATTRIBUTE10 IS NULL ) ) )
879 AND ( ( Recinfo.GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11 )
880 OR ( ( Recinfo.GLOBAL_ATTRIBUTE11 IS NULL )
881 AND ( X_GLOBAL_ATTRIBUTE11 IS NULL ) ) )
882 AND ( ( Recinfo.GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12 )
883 OR ( ( Recinfo.GLOBAL_ATTRIBUTE12 IS NULL )
884 AND ( X_GLOBAL_ATTRIBUTE12 IS NULL ) ) )
885 AND ( ( Recinfo.GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13 )
886 OR ( ( Recinfo.GLOBAL_ATTRIBUTE13 IS NULL )
887 AND ( X_GLOBAL_ATTRIBUTE13 IS NULL ) ) )
888 AND ( ( Recinfo.GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14 )
889 OR ( ( Recinfo.GLOBAL_ATTRIBUTE14 IS NULL )
890 AND ( X_GLOBAL_ATTRIBUTE14 IS NULL ) ) )
891 AND ( ( Recinfo.GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15 )
892 OR ( ( Recinfo.GLOBAL_ATTRIBUTE15 IS NULL )
893 AND ( X_GLOBAL_ATTRIBUTE15 IS NULL ) ) )
894 AND ( ( Recinfo.GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16 )
895 OR ( ( Recinfo.GLOBAL_ATTRIBUTE16 IS NULL )
896 AND ( X_GLOBAL_ATTRIBUTE16 IS NULL ) ) )
897 AND ( ( Recinfo.GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17 )
898 OR ( ( Recinfo.GLOBAL_ATTRIBUTE17 IS NULL )
899 AND ( X_GLOBAL_ATTRIBUTE17 IS NULL ) ) )
900 AND ( ( Recinfo.GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18 )
901 OR ( ( Recinfo.GLOBAL_ATTRIBUTE18 IS NULL )
902 AND ( X_GLOBAL_ATTRIBUTE18 IS NULL ) ) )
903 AND ( ( Recinfo.GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19 )
904 OR ( ( Recinfo.GLOBAL_ATTRIBUTE19 IS NULL )
905 AND ( X_GLOBAL_ATTRIBUTE19 IS NULL ) ) )
906 AND ( ( Recinfo.GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20 )
907 OR ( ( Recinfo.GLOBAL_ATTRIBUTE20 IS NULL )
908 AND ( X_GLOBAL_ATTRIBUTE20 IS NULL ) ) )
909 AND ( ( Recinfo.ORIG_SYSTEM_REFERENCE = X_ORIG_SYSTEM_REFERENCE )
913 OR ( ( Recinfo.STATUS IS NULL )
910 OR ( ( Recinfo.ORIG_SYSTEM_REFERENCE IS NULL )
911 AND ( X_ORIG_SYSTEM_REFERENCE IS NULL ) ) )
912 AND ( ( Recinfo.STATUS = X_STATUS )
914 AND ( X_STATUS IS NULL ) ) )
915 AND ( ( Recinfo.CUSTOMER_TYPE = X_CUSTOMER_TYPE )
916 OR ( ( Recinfo.CUSTOMER_TYPE IS NULL )
917 AND ( X_CUSTOMER_TYPE IS NULL ) ) )
918 AND ( ( Recinfo.CUSTOMER_CLASS_CODE = X_CUSTOMER_CLASS_CODE )
919 OR ( ( Recinfo.CUSTOMER_CLASS_CODE IS NULL )
920 AND ( X_CUSTOMER_CLASS_CODE IS NULL ) ) )
921 AND ( ( Recinfo.SALES_CHANNEL_CODE = X_SALES_CHANNEL_CODE )
922 OR ( ( Recinfo.SALES_CHANNEL_CODE IS NULL )
923 AND ( X_SALES_CHANNEL_CODE IS NULL ) ) )
924 AND ( ( Recinfo.PRICE_LIST_ID = X_PRICE_LIST_ID )
925 OR ( ( Recinfo.PRICE_LIST_ID IS NULL )
926 AND ( X_PRICE_LIST_ID IS NULL ) ) )
927 AND ( ( Recinfo.TAX_CODE = X_TAX_CODE )
928 OR ( ( Recinfo.TAX_CODE IS NULL )
929 AND ( X_TAX_CODE IS NULL ) ) )
930 AND ( ( Recinfo.FOB_POINT = X_FOB_POINT )
931 OR ( ( Recinfo.FOB_POINT IS NULL )
932 AND ( X_FOB_POINT IS NULL ) ) )
933 AND ( ( Recinfo.FREIGHT_TERM = X_FREIGHT_TERM )
934 OR ( ( Recinfo.FREIGHT_TERM IS NULL )
935 AND ( X_FREIGHT_TERM IS NULL ) ) )
936 AND ( ( Recinfo.SHIP_VIA = X_SHIP_VIA )
937 OR ( ( Recinfo.SHIP_VIA IS NULL )
938 AND ( X_SHIP_VIA IS NULL ) ) )
939 AND ( ( Recinfo.WAREHOUSE_ID = X_WAREHOUSE_ID )
940 OR ( ( Recinfo.WAREHOUSE_ID IS NULL )
941 AND ( X_WAREHOUSE_ID IS NULL ) ) )
942 AND ( ( Recinfo.TAX_HEADER_LEVEL_FLAG = X_TAX_HEADER_LEVEL_FLAG )
943 OR ( ( Recinfo.TAX_HEADER_LEVEL_FLAG IS NULL )
944 AND ( X_TAX_HEADER_LEVEL_FLAG IS NULL ) ) )
945 AND ( ( Recinfo.TAX_ROUNDING_RULE = X_TAX_ROUNDING_RULE )
946 OR ( ( Recinfo.TAX_ROUNDING_RULE IS NULL )
947 AND ( X_TAX_ROUNDING_RULE IS NULL ) ) )
948 AND ( ( Recinfo.COTERMINATE_DAY_MONTH = X_COTERMINATE_DAY_MONTH )
949 OR ( ( Recinfo.COTERMINATE_DAY_MONTH IS NULL )
950 AND ( X_COTERMINATE_DAY_MONTH IS NULL ) ) )
951 AND ( ( Recinfo.PRIMARY_SPECIALIST_ID = X_PRIMARY_SPECIALIST_ID )
952 OR ( ( Recinfo.PRIMARY_SPECIALIST_ID IS NULL )
953 AND ( X_PRIMARY_SPECIALIST_ID IS NULL ) ) )
954 AND ( ( Recinfo.SECONDARY_SPECIALIST_ID = X_SECONDARY_SPECIALIST_ID )
955 OR ( ( Recinfo.SECONDARY_SPECIALIST_ID IS NULL )
956 AND ( X_SECONDARY_SPECIALIST_ID IS NULL ) ) )
957 AND ( ( Recinfo.ACCOUNT_ESTABLISHED_DATE = X_ACCOUNT_ESTABLISHED_DATE )
958 OR ( ( Recinfo.ACCOUNT_ESTABLISHED_DATE IS NULL )
959 AND ( X_ACCOUNT_ESTABLISHED_DATE IS NULL ) ) )
960 AND ( ( Recinfo.HELD_BILL_EXPIRATION_DATE = X_HELD_BILL_EXPIRATION_DATE )
961 OR ( ( Recinfo.HELD_BILL_EXPIRATION_DATE IS NULL )
962 AND ( X_HELD_BILL_EXPIRATION_DATE IS NULL ) ) )
963 AND ( ( Recinfo.HOLD_BILL_FLAG = X_HOLD_BILL_FLAG )
964 OR ( ( Recinfo.HOLD_BILL_FLAG IS NULL )
965 AND ( X_HOLD_BILL_FLAG IS NULL ) ) )
966 AND ( ( Recinfo.ACCOUNT_NAME = X_ACCOUNT_NAME )
967 OR ( ( Recinfo.ACCOUNT_NAME IS NULL )
968 AND ( X_ACCOUNT_NAME IS NULL ) ) )
969 AND ( ( Recinfo.DEPOSIT_REFUND_METHOD = X_DEPOSIT_REFUND_METHOD )
970 OR ( ( Recinfo.DEPOSIT_REFUND_METHOD IS NULL )
971 AND ( X_DEPOSIT_REFUND_METHOD IS NULL ) ) )
972 AND ( ( Recinfo.NPA_NUMBER = X_NPA_NUMBER )
973 OR ( ( Recinfo.NPA_NUMBER IS NULL )
974 AND ( X_NPA_NUMBER IS NULL ) ) )
975 AND ( ( Recinfo.SOURCE_CODE = X_SOURCE_CODE )
976 OR ( ( Recinfo.SOURCE_CODE IS NULL )
977 AND ( X_SOURCE_CODE IS NULL ) ) )
978 AND ( ( Recinfo.COMMENTS = X_COMMENTS )
979 OR ( ( Recinfo.COMMENTS IS NULL )
980 AND ( X_COMMENTS IS NULL ) ) )
981 AND ( ( Recinfo.DATES_NEGATIVE_TOLERANCE = X_DATES_NEGATIVE_TOLERANCE )
982 OR ( ( Recinfo.DATES_NEGATIVE_TOLERANCE IS NULL )
983 AND ( X_DATES_NEGATIVE_TOLERANCE IS NULL ) ) )
984 AND ( ( Recinfo.DATES_POSITIVE_TOLERANCE = X_DATES_POSITIVE_TOLERANCE )
985 OR ( ( Recinfo.DATES_POSITIVE_TOLERANCE IS NULL )
986 AND ( X_DATES_POSITIVE_TOLERANCE IS NULL ) ) )
987 AND ( ( Recinfo.DATE_TYPE_PREFERENCE = X_DATE_TYPE_PREFERENCE )
988 OR ( ( Recinfo.DATE_TYPE_PREFERENCE IS NULL )
989 AND ( X_DATE_TYPE_PREFERENCE IS NULL ) ) )
990 AND ( ( Recinfo.OVER_SHIPMENT_TOLERANCE = X_OVER_SHIPMENT_TOLERANCE )
991 OR ( ( Recinfo.OVER_SHIPMENT_TOLERANCE IS NULL )
992 AND ( X_OVER_SHIPMENT_TOLERANCE IS NULL ) ) )
993 AND ( ( Recinfo.UNDER_SHIPMENT_TOLERANCE = X_UNDER_SHIPMENT_TOLERANCE )
994 OR ( ( Recinfo.UNDER_SHIPMENT_TOLERANCE IS NULL )
995 AND ( X_UNDER_SHIPMENT_TOLERANCE IS NULL ) ) )
996 AND ( ( Recinfo.OVER_RETURN_TOLERANCE = X_OVER_RETURN_TOLERANCE )
997 OR ( ( Recinfo.OVER_RETURN_TOLERANCE IS NULL )
998 AND ( X_OVER_RETURN_TOLERANCE IS NULL ) ) )
999 AND ( ( Recinfo.UNDER_RETURN_TOLERANCE = X_UNDER_RETURN_TOLERANCE )
1000 OR ( ( Recinfo.UNDER_RETURN_TOLERANCE IS NULL )
1001 AND ( X_UNDER_RETURN_TOLERANCE IS NULL ) ) )
1002 AND ( ( Recinfo.ITEM_CROSS_REF_PREF = X_ITEM_CROSS_REF_PREF )
1003 OR ( ( Recinfo.ITEM_CROSS_REF_PREF IS NULL )
1004 AND ( X_ITEM_CROSS_REF_PREF IS NULL ) ) )
1005 AND ( ( Recinfo.SHIP_SETS_INCLUDE_LINES_FLAG = X_SHIP_SETS_INCLUDE_LINES_FLAG )
1006 OR ( ( Recinfo.SHIP_SETS_INCLUDE_LINES_FLAG IS NULL )
1010 AND ( X_ARRIVALSETS_INCL_LINES_FLAG IS NULL ) ) )
1007 AND ( X_SHIP_SETS_INCLUDE_LINES_FLAG IS NULL ) ) )
1008 AND ( ( Recinfo.ARRIVALSETS_INCLUDE_LINES_FLAG = X_ARRIVALSETS_INCL_LINES_FLAG )
1009 OR ( ( Recinfo.ARRIVALSETS_INCLUDE_LINES_FLAG IS NULL )
1011 AND ( ( Recinfo.SCHED_DATE_PUSH_FLAG = X_SCHED_DATE_PUSH_FLAG )
1012 OR ( ( Recinfo.SCHED_DATE_PUSH_FLAG IS NULL )
1013 AND ( X_SCHED_DATE_PUSH_FLAG IS NULL ) ) )
1014 AND ( ( Recinfo.INVOICE_QUANTITY_RULE = X_INVOICE_QUANTITY_RULE )
1015 OR ( ( Recinfo.INVOICE_QUANTITY_RULE IS NULL )
1016 AND ( X_INVOICE_QUANTITY_RULE IS NULL ) ) )
1017 AND ( ( Recinfo.PRICING_EVENT = X_PRICING_EVENT )
1018 OR ( ( Recinfo.PRICING_EVENT IS NULL )
1019 AND ( X_PRICING_EVENT IS NULL ) ) )
1020 AND ( ( Recinfo.STATUS_UPDATE_DATE = X_STATUS_UPDATE_DATE )
1021 OR ( ( Recinfo.STATUS_UPDATE_DATE IS NULL )
1022 AND ( X_STATUS_UPDATE_DATE IS NULL ) ) )
1023 AND ( ( Recinfo.AUTOPAY_FLAG = X_AUTOPAY_FLAG )
1024 OR ( ( Recinfo.AUTOPAY_FLAG IS NULL )
1025 AND ( X_AUTOPAY_FLAG IS NULL ) ) )
1026 AND ( ( Recinfo.LAST_BATCH_ID = X_LAST_BATCH_ID )
1027 OR ( ( Recinfo.LAST_BATCH_ID IS NULL )
1028 AND ( X_LAST_BATCH_ID IS NULL ) ) )
1029 AND ( ( Recinfo.SELLING_PARTY_ID = X_SELLING_PARTY_ID )
1030 OR ( ( Recinfo.SELLING_PARTY_ID IS NULL )
1031 AND ( X_SELLING_PARTY_ID IS NULL ) ) )
1032 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER )
1033 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
1034 AND ( X_OBJECT_VERSION_NUMBER IS NULL ) ) )
1035 AND ( ( Recinfo.CREATED_BY_MODULE = X_CREATED_BY_MODULE )
1036 OR ( ( Recinfo.CREATED_BY_MODULE IS NULL )
1037 AND ( X_CREATED_BY_MODULE IS NULL ) ) )
1038 AND ( ( Recinfo.APPLICATION_ID = X_APPLICATION_ID )
1039 OR ( ( Recinfo.APPLICATION_ID IS NULL )
1040 AND ( X_APPLICATION_ID IS NULL ) ) )
1041 ) THEN
1042 RETURN;
1043 ELSE
1044 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1045 APP_EXCEPTION.RAISE_EXCEPTION;
1046 END IF;
1047
1048 END Lock_Row;
1049
1050 PROCEDURE Select_Row (
1051 X_CUST_ACCOUNT_ID IN OUT NOCOPY NUMBER,
1052 X_ACCOUNT_NUMBER OUT NOCOPY VARCHAR2,
1053 X_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
1054 X_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
1055 X_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
1056 X_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
1057 X_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
1058 X_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
1059 X_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
1060 X_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
1061 X_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
1062 X_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
1063 X_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
1064 X_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
1065 X_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
1066 X_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
1067 X_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
1068 X_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
1069 X_ATTRIBUTE16 OUT NOCOPY VARCHAR2,
1070 X_ATTRIBUTE17 OUT NOCOPY VARCHAR2,
1071 X_ATTRIBUTE18 OUT NOCOPY VARCHAR2,
1072 X_ATTRIBUTE19 OUT NOCOPY VARCHAR2,
1073 X_ATTRIBUTE20 OUT NOCOPY VARCHAR2,
1074 X_GLOBAL_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
1075 X_GLOBAL_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
1076 X_GLOBAL_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
1077 X_GLOBAL_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
1078 X_GLOBAL_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
1079 X_GLOBAL_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
1080 X_GLOBAL_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
1081 X_GLOBAL_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
1082 X_GLOBAL_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
1083 X_GLOBAL_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
1084 X_GLOBAL_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
1085 X_GLOBAL_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
1086 X_GLOBAL_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
1087 X_GLOBAL_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
1088 X_GLOBAL_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
1089 X_GLOBAL_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
1090 X_GLOBAL_ATTRIBUTE16 OUT NOCOPY VARCHAR2,
1091 X_GLOBAL_ATTRIBUTE17 OUT NOCOPY VARCHAR2,
1092 X_GLOBAL_ATTRIBUTE18 OUT NOCOPY VARCHAR2,
1093 X_GLOBAL_ATTRIBUTE19 OUT NOCOPY VARCHAR2,
1094 X_GLOBAL_ATTRIBUTE20 OUT NOCOPY VARCHAR2,
1095 X_ORIG_SYSTEM_REFERENCE OUT NOCOPY VARCHAR2,
1096 X_STATUS OUT NOCOPY VARCHAR2,
1097 X_CUSTOMER_TYPE OUT NOCOPY VARCHAR2,
1098 X_CUSTOMER_CLASS_CODE OUT NOCOPY VARCHAR2,
1099 X_PRIMARY_SALESREP_ID OUT NOCOPY NUMBER,
1100 X_SALES_CHANNEL_CODE OUT NOCOPY VARCHAR2,
1101 X_ORDER_TYPE_ID OUT NOCOPY NUMBER,
1105 X_FREIGHT_TERM OUT NOCOPY VARCHAR2,
1102 X_PRICE_LIST_ID OUT NOCOPY NUMBER,
1103 X_TAX_CODE OUT NOCOPY VARCHAR2,
1104 X_FOB_POINT OUT NOCOPY VARCHAR2,
1106 X_SHIP_PARTIAL OUT NOCOPY VARCHAR2,
1107 X_SHIP_VIA OUT NOCOPY VARCHAR2,
1108 X_WAREHOUSE_ID OUT NOCOPY NUMBER,
1109 X_TAX_HEADER_LEVEL_FLAG OUT NOCOPY VARCHAR2,
1110 X_TAX_ROUNDING_RULE OUT NOCOPY VARCHAR2,
1111 X_COTERMINATE_DAY_MONTH OUT NOCOPY VARCHAR2,
1112 X_PRIMARY_SPECIALIST_ID OUT NOCOPY NUMBER,
1113 X_SECONDARY_SPECIALIST_ID OUT NOCOPY NUMBER,
1114 X_ACCOUNT_LIABLE_FLAG OUT NOCOPY VARCHAR2,
1115 X_CURRENT_BALANCE OUT NOCOPY NUMBER,
1116 X_ACCOUNT_ESTABLISHED_DATE OUT NOCOPY DATE,
1117 X_ACCOUNT_TERMINATION_DATE OUT NOCOPY DATE,
1118 X_ACCOUNT_ACTIVATION_DATE OUT NOCOPY DATE,
1119 X_DEPARTMENT OUT NOCOPY VARCHAR2,
1120 X_HELD_BILL_EXPIRATION_DATE OUT NOCOPY DATE,
1121 X_HOLD_BILL_FLAG OUT NOCOPY VARCHAR2,
1122 X_REALTIME_RATE_FLAG OUT NOCOPY VARCHAR2,
1123 X_ACCT_LIFE_CYCLE_STATUS OUT NOCOPY VARCHAR2,
1124 X_ACCOUNT_NAME OUT NOCOPY VARCHAR2,
1125 X_DEPOSIT_REFUND_METHOD OUT NOCOPY VARCHAR2,
1126 X_DORMANT_ACCOUNT_FLAG OUT NOCOPY VARCHAR2,
1127 X_NPA_NUMBER OUT NOCOPY VARCHAR2,
1128 X_SUSPENSION_DATE OUT NOCOPY DATE,
1129 X_SOURCE_CODE OUT NOCOPY VARCHAR2,
1130 X_COMMENTS OUT NOCOPY VARCHAR2,
1131 X_DATES_NEGATIVE_TOLERANCE OUT NOCOPY NUMBER,
1132 X_DATES_POSITIVE_TOLERANCE OUT NOCOPY NUMBER,
1133 X_DATE_TYPE_PREFERENCE OUT NOCOPY VARCHAR2,
1134 X_OVER_SHIPMENT_TOLERANCE OUT NOCOPY NUMBER,
1135 X_UNDER_SHIPMENT_TOLERANCE OUT NOCOPY NUMBER,
1136 X_OVER_RETURN_TOLERANCE OUT NOCOPY NUMBER,
1137 X_UNDER_RETURN_TOLERANCE OUT NOCOPY NUMBER,
1138 X_ITEM_CROSS_REF_PREF OUT NOCOPY VARCHAR2,
1139 X_SHIP_SETS_INCLUDE_LINES_FLAG OUT NOCOPY VARCHAR2,
1140 X_ARRIVALSETS_INCL_LINES_FLAG OUT NOCOPY VARCHAR2,
1141 X_SCHED_DATE_PUSH_FLAG OUT NOCOPY VARCHAR2,
1142 X_INVOICE_QUANTITY_RULE OUT NOCOPY VARCHAR2,
1143 X_PRICING_EVENT OUT NOCOPY VARCHAR2,
1144 X_STATUS_UPDATE_DATE OUT NOCOPY DATE,
1145 X_AUTOPAY_FLAG OUT NOCOPY VARCHAR2,
1146 X_NOTIFY_FLAG OUT NOCOPY VARCHAR2,
1147 X_LAST_BATCH_ID OUT NOCOPY NUMBER,
1148 X_SELLING_PARTY_ID OUT NOCOPY NUMBER,
1149 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
1150 X_APPLICATION_ID OUT NOCOPY NUMBER
1151 ) IS
1152
1153 BEGIN
1154
1155 SELECT
1156 NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
1157 NVL( ACCOUNT_NUMBER, FND_API.G_MISS_CHAR ),
1158 NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1159 NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1160 NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1161 NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1162 NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1163 NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1164 NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1165 NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1166 NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1167 NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1168 NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1169 NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1170 NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1171 NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1172 NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1173 NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1174 NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
1175 NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
1176 NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
1177 NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
1178 NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
1179 NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1180 NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1181 NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1182 NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1183 NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1184 NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1185 NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1186 NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1187 NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1188 NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1189 NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1190 NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1191 NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1192 NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1193 NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1194 NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1198 NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
1195 NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
1196 NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
1197 NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
1199 NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
1200 NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
1201 NVL( STATUS, FND_API.G_MISS_CHAR ),
1202 NVL( CUSTOMER_TYPE, FND_API.G_MISS_CHAR ),
1203 NVL( CUSTOMER_CLASS_CODE, FND_API.G_MISS_CHAR ),
1204 NVL( PRIMARY_SALESREP_ID, FND_API.G_MISS_NUM ),
1205 NVL( SALES_CHANNEL_CODE, FND_API.G_MISS_CHAR ),
1206 NVL( ORDER_TYPE_ID, FND_API.G_MISS_NUM ),
1207 NVL( PRICE_LIST_ID, FND_API.G_MISS_NUM ),
1208 NVL( TAX_CODE, FND_API.G_MISS_CHAR ),
1209 NVL( FOB_POINT, FND_API.G_MISS_CHAR ),
1210 NVL( FREIGHT_TERM, FND_API.G_MISS_CHAR ),
1211 -- NVL( SHIP_PARTIAL, FND_API.G_MISS_CHAR ),
1212 NVL( SHIP_VIA, FND_API.G_MISS_CHAR ),
1213 NVL( WAREHOUSE_ID, FND_API.G_MISS_NUM ),
1214 NVL( TAX_HEADER_LEVEL_FLAG, FND_API.G_MISS_CHAR ),
1215 NVL( TAX_ROUNDING_RULE, FND_API.G_MISS_CHAR ),
1216 NVL( COTERMINATE_DAY_MONTH, FND_API.G_MISS_CHAR ),
1217 NVL( PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
1218 NVL( SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
1219 NVL( ACCOUNT_LIABLE_FLAG, FND_API.G_MISS_CHAR ),
1220 NVL( CURRENT_BALANCE, FND_API.G_MISS_NUM ),
1221 NVL( ACCOUNT_ESTABLISHED_DATE, FND_API.G_MISS_DATE ),
1222 NVL( ACCOUNT_TERMINATION_DATE, FND_API.G_MISS_DATE ),
1223 NVL( ACCOUNT_ACTIVATION_DATE, FND_API.G_MISS_DATE ),
1224 NVL( DEPARTMENT, FND_API.G_MISS_CHAR ),
1225 NVL( HELD_BILL_EXPIRATION_DATE, FND_API.G_MISS_DATE ),
1226 NVL( HOLD_BILL_FLAG, FND_API.G_MISS_CHAR ),
1227 NVL( REALTIME_RATE_FLAG, FND_API.G_MISS_CHAR ),
1228 NVL( ACCT_LIFE_CYCLE_STATUS, FND_API.G_MISS_CHAR ),
1229 NVL( ACCOUNT_NAME, FND_API.G_MISS_CHAR ),
1230 NVL( DEPOSIT_REFUND_METHOD, FND_API.G_MISS_CHAR ),
1231 NVL( DORMANT_ACCOUNT_FLAG, FND_API.G_MISS_CHAR ),
1232 NVL( NPA_NUMBER, FND_API.G_MISS_CHAR ),
1233 NVL( SUSPENSION_DATE, FND_API.G_MISS_DATE ),
1234 NVL( SOURCE_CODE, FND_API.G_MISS_CHAR ),
1235 NVL( COMMENTS, FND_API.G_MISS_CHAR ),
1236 NVL( DATES_NEGATIVE_TOLERANCE, FND_API.G_MISS_NUM ),
1237 NVL( DATES_POSITIVE_TOLERANCE, FND_API.G_MISS_NUM ),
1238 NVL( DATE_TYPE_PREFERENCE, FND_API.G_MISS_CHAR ),
1239 NVL( OVER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM ),
1240 NVL( UNDER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM ),
1241 NVL( OVER_RETURN_TOLERANCE, FND_API.G_MISS_NUM ),
1242 NVL( UNDER_RETURN_TOLERANCE, FND_API.G_MISS_NUM ),
1243 NVL( ITEM_CROSS_REF_PREF, FND_API.G_MISS_CHAR ),
1244 NVL( SHIP_SETS_INCLUDE_LINES_FLAG, FND_API.G_MISS_CHAR ),
1245 NVL( ARRIVALSETS_INCLUDE_LINES_FLAG, FND_API.G_MISS_CHAR ),
1246 NVL( SCHED_DATE_PUSH_FLAG, FND_API.G_MISS_CHAR ),
1247 NVL( INVOICE_QUANTITY_RULE, FND_API.G_MISS_CHAR ),
1248 NVL( PRICING_EVENT, FND_API.G_MISS_CHAR ),
1249 NVL( STATUS_UPDATE_DATE, FND_API.G_MISS_DATE ),
1250 NVL( AUTOPAY_FLAG, FND_API.G_MISS_CHAR ),
1251 NVL( NOTIFY_FLAG, FND_API.G_MISS_CHAR ),
1252 NVL( LAST_BATCH_ID, FND_API.G_MISS_NUM ),
1253 NVL( SELLING_PARTY_ID, FND_API.G_MISS_NUM ),
1254 NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
1255 NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
1256 INTO
1257 X_CUST_ACCOUNT_ID,
1258 X_ACCOUNT_NUMBER,
1259 X_ATTRIBUTE_CATEGORY,
1260 X_ATTRIBUTE1,
1261 X_ATTRIBUTE2,
1262 X_ATTRIBUTE3,
1263 X_ATTRIBUTE4,
1264 X_ATTRIBUTE5,
1265 X_ATTRIBUTE6,
1266 X_ATTRIBUTE7,
1267 X_ATTRIBUTE8,
1268 X_ATTRIBUTE9,
1269 X_ATTRIBUTE10,
1270 X_ATTRIBUTE11,
1271 X_ATTRIBUTE12,
1272 X_ATTRIBUTE13,
1273 X_ATTRIBUTE14,
1274 X_ATTRIBUTE15,
1275 X_ATTRIBUTE16,
1276 X_ATTRIBUTE17,
1277 X_ATTRIBUTE18,
1278 X_ATTRIBUTE19,
1279 X_ATTRIBUTE20,
1280 X_GLOBAL_ATTRIBUTE_CATEGORY,
1281 X_GLOBAL_ATTRIBUTE1,
1282 X_GLOBAL_ATTRIBUTE2,
1283 X_GLOBAL_ATTRIBUTE3,
1284 X_GLOBAL_ATTRIBUTE4,
1285 X_GLOBAL_ATTRIBUTE5,
1286 X_GLOBAL_ATTRIBUTE6,
1287 X_GLOBAL_ATTRIBUTE7,
1288 X_GLOBAL_ATTRIBUTE8,
1289 X_GLOBAL_ATTRIBUTE9,
1290 X_GLOBAL_ATTRIBUTE10,
1291 X_GLOBAL_ATTRIBUTE11,
1292 X_GLOBAL_ATTRIBUTE12,
1293 X_GLOBAL_ATTRIBUTE13,
1294 X_GLOBAL_ATTRIBUTE14,
1295 X_GLOBAL_ATTRIBUTE15,
1296 X_GLOBAL_ATTRIBUTE16,
1297 X_GLOBAL_ATTRIBUTE17,
1298 X_GLOBAL_ATTRIBUTE18,
1299 X_GLOBAL_ATTRIBUTE19,
1300 X_GLOBAL_ATTRIBUTE20,
1301 X_ORIG_SYSTEM_REFERENCE,
1302 X_STATUS,
1303 X_CUSTOMER_TYPE,
1304 X_CUSTOMER_CLASS_CODE,
1305 X_PRIMARY_SALESREP_ID,
1306 X_SALES_CHANNEL_CODE,
1307 X_ORDER_TYPE_ID,
1308 X_PRICE_LIST_ID,
1309 X_TAX_CODE,
1310 X_FOB_POINT,
1311 X_FREIGHT_TERM,
1312 -- X_SHIP_PARTIAL,
1313 X_SHIP_VIA,
1314 X_WAREHOUSE_ID,
1315 X_TAX_HEADER_LEVEL_FLAG,
1316 X_TAX_ROUNDING_RULE,
1317 X_COTERMINATE_DAY_MONTH,
1318 X_PRIMARY_SPECIALIST_ID,
1322 X_ACCOUNT_ESTABLISHED_DATE,
1319 X_SECONDARY_SPECIALIST_ID,
1320 X_ACCOUNT_LIABLE_FLAG,
1321 X_CURRENT_BALANCE,
1323 X_ACCOUNT_TERMINATION_DATE,
1324 X_ACCOUNT_ACTIVATION_DATE,
1325 X_DEPARTMENT,
1326 X_HELD_BILL_EXPIRATION_DATE,
1327 X_HOLD_BILL_FLAG,
1328 X_REALTIME_RATE_FLAG,
1329 X_ACCT_LIFE_CYCLE_STATUS,
1330 X_ACCOUNT_NAME,
1331 X_DEPOSIT_REFUND_METHOD,
1332 X_DORMANT_ACCOUNT_FLAG,
1333 X_NPA_NUMBER,
1334 X_SUSPENSION_DATE,
1335 X_SOURCE_CODE,
1336 X_COMMENTS,
1337 X_DATES_NEGATIVE_TOLERANCE,
1338 X_DATES_POSITIVE_TOLERANCE,
1339 X_DATE_TYPE_PREFERENCE,
1340 X_OVER_SHIPMENT_TOLERANCE,
1341 X_UNDER_SHIPMENT_TOLERANCE,
1342 X_OVER_RETURN_TOLERANCE,
1343 X_UNDER_RETURN_TOLERANCE,
1344 X_ITEM_CROSS_REF_PREF,
1345 X_SHIP_SETS_INCLUDE_LINES_FLAG,
1346 X_ARRIVALSETS_INCL_LINES_FLAG,
1347 X_SCHED_DATE_PUSH_FLAG,
1348 X_INVOICE_QUANTITY_RULE,
1349 X_PRICING_EVENT,
1350 X_STATUS_UPDATE_DATE,
1351 X_AUTOPAY_FLAG,
1352 X_NOTIFY_FLAG,
1353 X_LAST_BATCH_ID,
1354 X_SELLING_PARTY_ID,
1355 X_CREATED_BY_MODULE,
1356 X_APPLICATION_ID
1357 FROM HZ_CUST_ACCOUNTS
1361 WHEN NO_DATA_FOUND THEN
1358 WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID;
1359
1360 EXCEPTION
1362 FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1363 FND_MESSAGE.SET_TOKEN( 'RECORD', 'cust_account_rec');
1364 FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CUST_ACCOUNT_ID ) );
1365 FND_MSG_PUB.ADD;
1366 RAISE FND_API.G_EXC_ERROR;
1367
1368 END Select_Row;
1369
1370 PROCEDURE Delete_Row (
1371 X_CUST_ACCOUNT_ID IN NUMBER
1372 ) IS
1373
1374 BEGIN
1375
1376 DELETE FROM HZ_CUST_ACCOUNTS
1377 WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID;
1378
1379 IF ( SQL%NOTFOUND ) THEN
1380 RAISE NO_DATA_FOUND;
1381 END IF;
1382
1383 END Delete_Row;
1384
1385 END HZ_CUST_ACCOUNTS_PKG;