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