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