[Home] [Help]
PACKAGE BODY: APPS.ONT_BLANKET_LINE_DEF_UTIL
Source
1 PACKAGE BODY ONT_BLANKET_LINE_Def_Util AS
2 /* $Header: OEXDFWKB.pls 115.0 30-MAR-09 23:23:31 appldev ship $ */
3
4 --
5 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- ONT_BLANKET_LINE_Def_Util
11 --
12 -- DESCRIPTION
13 --
14 -- Body of package ONT_BLANKET_LINE_Def_Util
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 30-MAR-09 Created
21 --
22
23 -- Global constant holding the package name
24 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ONT_BLANKET_LINE_Def_Util';
25
26
27 g_database_object_name varchar2(30) :='OE_AK_BLANKET_LINES_V';
28
29
30 FUNCTION Get_Attr_Val_Varchar2
31 ( p_attr_code IN VARCHAR2
32 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
33 ) RETURN VARCHAR2
34 IS
35 BEGIN
36
37 IF p_attr_code =('ACCOUNTING_RULE_ID') THEN
38 IF NVL(p_record.ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
39 RETURN p_record.ACCOUNTING_RULE_ID;
40 ELSE
41 RETURN NULL;
42 END IF;
43 ELSIF p_attr_code =('ATTRIBUTE1') THEN
44 IF NVL(p_record.ATTRIBUTE1, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
45 RETURN p_record.ATTRIBUTE1;
46 ELSE
47 RETURN NULL;
48 END IF;
49 ELSIF p_attr_code =('ATTRIBUTE10') THEN
50 IF NVL(p_record.ATTRIBUTE10, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
51 RETURN p_record.ATTRIBUTE10;
52 ELSE
53 RETURN NULL;
54 END IF;
55 ELSIF p_attr_code =('ATTRIBUTE11') THEN
56 IF NVL(p_record.ATTRIBUTE11, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
57 RETURN p_record.ATTRIBUTE11;
58 ELSE
59 RETURN NULL;
60 END IF;
61 ELSIF p_attr_code =('ATTRIBUTE12') THEN
62 IF NVL(p_record.ATTRIBUTE12, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
63 RETURN p_record.ATTRIBUTE12;
64 ELSE
65 RETURN NULL;
66 END IF;
67 ELSIF p_attr_code =('ATTRIBUTE13') THEN
68 IF NVL(p_record.ATTRIBUTE13, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
69 RETURN p_record.ATTRIBUTE13;
70 ELSE
71 RETURN NULL;
72 END IF;
73 ELSIF p_attr_code =('ATTRIBUTE14') THEN
74 IF NVL(p_record.ATTRIBUTE14, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
75 RETURN p_record.ATTRIBUTE14;
76 ELSE
77 RETURN NULL;
78 END IF;
79 ELSIF p_attr_code =('ATTRIBUTE15') THEN
80 IF NVL(p_record.ATTRIBUTE15, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
81 RETURN p_record.ATTRIBUTE15;
82 ELSE
83 RETURN NULL;
84 END IF;
85 ELSIF p_attr_code =('ATTRIBUTE16') THEN
86 IF NVL(p_record.ATTRIBUTE16, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
87 RETURN p_record.ATTRIBUTE16;
88 ELSE
89 RETURN NULL;
90 END IF;
91 ELSIF p_attr_code =('ATTRIBUTE17') THEN
92 IF NVL(p_record.ATTRIBUTE17, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
93 RETURN p_record.ATTRIBUTE17;
94 ELSE
95 RETURN NULL;
96 END IF;
97 ELSIF p_attr_code =('ATTRIBUTE18') THEN
98 IF NVL(p_record.ATTRIBUTE18, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
99 RETURN p_record.ATTRIBUTE18;
100 ELSE
101 RETURN NULL;
102 END IF;
103 ELSIF p_attr_code =('ATTRIBUTE19') THEN
104 IF NVL(p_record.ATTRIBUTE19, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
105 RETURN p_record.ATTRIBUTE19;
106 ELSE
107 RETURN NULL;
108 END IF;
109 ELSIF p_attr_code =('ATTRIBUTE2') THEN
110 IF NVL(p_record.ATTRIBUTE2, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
111 RETURN p_record.ATTRIBUTE2;
112 ELSE
113 RETURN NULL;
114 END IF;
115 ELSIF p_attr_code =('ATTRIBUTE20') THEN
116 IF NVL(p_record.ATTRIBUTE20, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
117 RETURN p_record.ATTRIBUTE20;
118 ELSE
119 RETURN NULL;
120 END IF;
121 ELSIF p_attr_code =('ATTRIBUTE3') THEN
122 IF NVL(p_record.ATTRIBUTE3, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
123 RETURN p_record.ATTRIBUTE3;
124 ELSE
125 RETURN NULL;
126 END IF;
127 ELSIF p_attr_code =('ATTRIBUTE4') THEN
128 IF NVL(p_record.ATTRIBUTE4, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
129 RETURN p_record.ATTRIBUTE4;
130 ELSE
131 RETURN NULL;
132 END IF;
133 ELSIF p_attr_code =('ATTRIBUTE5') THEN
134 IF NVL(p_record.ATTRIBUTE5, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
135 RETURN p_record.ATTRIBUTE5;
136 ELSE
137 RETURN NULL;
138 END IF;
139 ELSIF p_attr_code =('ATTRIBUTE6') THEN
140 IF NVL(p_record.ATTRIBUTE6, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
141 RETURN p_record.ATTRIBUTE6;
142 ELSE
143 RETURN NULL;
144 END IF;
145 ELSIF p_attr_code =('ATTRIBUTE7') THEN
146 IF NVL(p_record.ATTRIBUTE7, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
147 RETURN p_record.ATTRIBUTE7;
148 ELSE
149 RETURN NULL;
150 END IF;
151 ELSIF p_attr_code =('ATTRIBUTE8') THEN
152 IF NVL(p_record.ATTRIBUTE8, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
153 RETURN p_record.ATTRIBUTE8;
154 ELSE
155 RETURN NULL;
156 END IF;
157 ELSIF p_attr_code =('ATTRIBUTE9') THEN
158 IF NVL(p_record.ATTRIBUTE9, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
159 RETURN p_record.ATTRIBUTE9;
160 ELSE
161 RETURN NULL;
162 END IF;
163 ELSIF p_attr_code =('BLANKET_LINE_MAX_AMOUNT') THEN
164 IF NVL(p_record.BLANKET_LINE_MAX_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
165 RETURN p_record.BLANKET_LINE_MAX_AMOUNT;
166 ELSE
167 RETURN NULL;
168 END IF;
169 ELSIF p_attr_code =('BLANKET_LINE_MIN_AMOUNT') THEN
170 IF NVL(p_record.BLANKET_LINE_MIN_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
171 RETURN p_record.BLANKET_LINE_MIN_AMOUNT;
172 ELSE
173 RETURN NULL;
174 END IF;
175 ELSIF p_attr_code =('BLANKET_MAX_QUANTITY') THEN
176 IF NVL(p_record.BLANKET_MAX_QUANTITY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
177 RETURN p_record.BLANKET_MAX_QUANTITY;
178 ELSE
179 RETURN NULL;
180 END IF;
181 ELSIF p_attr_code =('BLANKET_MIN_QUANTITY') THEN
182 IF NVL(p_record.BLANKET_MIN_QUANTITY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
183 RETURN p_record.BLANKET_MIN_QUANTITY;
184 ELSE
185 RETURN NULL;
186 END IF;
187 ELSIF p_attr_code =('CONTEXT') THEN
188 IF NVL(p_record.CONTEXT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
189 RETURN p_record.CONTEXT;
190 ELSE
191 RETURN NULL;
192 END IF;
193 ELSIF p_attr_code =('CUST_PO_NUMBER') THEN
194 IF NVL(p_record.CUST_PO_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
195 RETURN p_record.CUST_PO_NUMBER;
196 ELSE
197 RETURN NULL;
198 END IF;
199 ELSIF p_attr_code =('DELIVER_TO_ORG_ID') THEN
200 IF NVL(p_record.DELIVER_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
201 RETURN p_record.DELIVER_TO_ORG_ID;
202 ELSE
203 RETURN NULL;
204 END IF;
205 ELSIF p_attr_code =('DISCOUNT_AMOUNT') THEN
206 IF NVL(p_record.DISCOUNT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
207 RETURN p_record.DISCOUNT_AMOUNT;
208 ELSE
209 RETURN NULL;
210 END IF;
211 ELSIF p_attr_code =('DISCOUNT_PERCENT') THEN
212 IF NVL(p_record.DISCOUNT_PERCENT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
213 RETURN p_record.DISCOUNT_PERCENT;
214 ELSE
215 RETURN NULL;
216 END IF;
217 ELSIF p_attr_code =('END_DATE_ACTIVE') THEN
218 IF NVL(p_record.END_DATE_ACTIVE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
219 RETURN p_record.END_DATE_ACTIVE;
220 ELSE
221 RETURN NULL;
222 END IF;
223 ELSIF p_attr_code =('ENFORCE_ACCOUNTING_RULE_FLAG') THEN
224 IF NVL(p_record.ENFORCE_ACCOUNTING_RULE_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
225 RETURN p_record.ENFORCE_ACCOUNTING_RULE_FLAG;
226 ELSE
227 RETURN NULL;
228 END IF;
229 ELSIF p_attr_code =('ENFORCE_FREIGHT_TERM_FLAG') THEN
230 IF NVL(p_record.ENFORCE_FREIGHT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
231 RETURN p_record.ENFORCE_FREIGHT_TERM_FLAG;
232 ELSE
233 RETURN NULL;
234 END IF;
235 ELSIF p_attr_code =('ENFORCE_INVOICE_TO_FLAG') THEN
236 IF NVL(p_record.ENFORCE_INVOICE_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
237 RETURN p_record.ENFORCE_INVOICE_TO_FLAG;
238 ELSE
239 RETURN NULL;
240 END IF;
241 ELSIF p_attr_code =('ENFORCE_INVOICING_RULE_FLAG') THEN
242 IF NVL(p_record.ENFORCE_INVOICING_RULE_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
243 RETURN p_record.ENFORCE_INVOICING_RULE_FLAG;
244 ELSE
245 RETURN NULL;
246 END IF;
247 ELSIF p_attr_code =('ENFORCE_PAYMENT_TERM_FLAG') THEN
248 IF NVL(p_record.ENFORCE_PAYMENT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
249 RETURN p_record.ENFORCE_PAYMENT_TERM_FLAG;
250 ELSE
251 RETURN NULL;
252 END IF;
253 ELSIF p_attr_code =('ENFORCE_PRICE_LIST_FLAG') THEN
254 IF NVL(p_record.ENFORCE_PRICE_LIST_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
255 RETURN p_record.ENFORCE_PRICE_LIST_FLAG;
256 ELSE
257 RETURN NULL;
258 END IF;
259 ELSIF p_attr_code =('ENFORCE_SHIPPING_METHOD_FLAG') THEN
260 IF NVL(p_record.ENFORCE_SHIPPING_METHOD_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
261 RETURN p_record.ENFORCE_SHIPPING_METHOD_FLAG;
262 ELSE
263 RETURN NULL;
264 END IF;
265 ELSIF p_attr_code =('ENFORCE_SHIP_TO_FLAG') THEN
266 IF NVL(p_record.ENFORCE_SHIP_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
267 RETURN p_record.ENFORCE_SHIP_TO_FLAG;
268 ELSE
269 RETURN NULL;
270 END IF;
271 ELSIF p_attr_code =('FREIGHT_TERMS_CODE') THEN
272 IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
273 RETURN p_record.FREIGHT_TERMS_CODE;
274 ELSE
275 RETURN NULL;
276 END IF;
277 ELSIF p_attr_code =('INVENTORY_ITEM_ID') THEN
278 IF NVL(p_record.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
279 RETURN p_record.INVENTORY_ITEM_ID;
280 ELSE
281 RETURN NULL;
282 END IF;
283 ELSIF p_attr_code =('INVOICE_TO_ORG_ID') THEN
284 IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
285 RETURN p_record.INVOICE_TO_ORG_ID;
286 ELSE
287 RETURN NULL;
288 END IF;
289 ELSIF p_attr_code =('INVOICING_RULE_ID') THEN
290 IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
291 RETURN p_record.INVOICING_RULE_ID;
292 ELSE
293 RETURN NULL;
294 END IF;
295 ELSIF p_attr_code =('ITEM_IDENTIFIER_TYPE') THEN
296 IF NVL(p_record.ITEM_IDENTIFIER_TYPE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
297 RETURN p_record.ITEM_IDENTIFIER_TYPE;
298 ELSE
299 RETURN NULL;
300 END IF;
301 ELSIF p_attr_code =('LINE_NUMBER') THEN
302 IF NVL(p_record.LINE_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
303 RETURN p_record.LINE_NUMBER;
304 ELSE
305 RETURN NULL;
306 END IF;
307 ELSIF p_attr_code =('MAX_RELEASE_AMOUNT') THEN
308 IF NVL(p_record.MAX_RELEASE_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
309 RETURN p_record.MAX_RELEASE_AMOUNT;
310 ELSE
311 RETURN NULL;
312 END IF;
313 ELSIF p_attr_code =('MAX_RELEASE_QUANTITY') THEN
314 IF NVL(p_record.MAX_RELEASE_QUANTITY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
315 RETURN p_record.MAX_RELEASE_QUANTITY;
316 ELSE
317 RETURN NULL;
318 END IF;
319 ELSIF p_attr_code =('MIN_RELEASE_AMOUNT') THEN
320 IF NVL(p_record.MIN_RELEASE_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
321 RETURN p_record.MIN_RELEASE_AMOUNT;
322 ELSE
323 RETURN NULL;
324 END IF;
325 ELSIF p_attr_code =('MIN_RELEASE_QUANTITY') THEN
326 IF NVL(p_record.MIN_RELEASE_QUANTITY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
327 RETURN p_record.MIN_RELEASE_QUANTITY;
328 ELSE
329 RETURN NULL;
330 END IF;
331 ELSIF p_attr_code =('MODIFIER_LIST_LINE_ID') THEN
332 IF NVL(p_record.MODIFIER_LIST_LINE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
333 RETURN p_record.MODIFIER_LIST_LINE_ID;
334 ELSE
335 RETURN NULL;
336 END IF;
337 ELSIF p_attr_code =('ORDER_NUMBER') THEN
338 IF NVL(p_record.ORDER_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
339 RETURN p_record.ORDER_NUMBER;
340 ELSE
341 RETURN NULL;
342 END IF;
343 ELSIF p_attr_code =('ORDER_QUANTITY_UOM') THEN
344 IF NVL(p_record.ORDER_QUANTITY_UOM, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
345 RETURN p_record.ORDER_QUANTITY_UOM;
346 ELSE
347 RETURN NULL;
348 END IF;
349 ELSIF p_attr_code =('OVERRIDE_BLANKET_CONTROLS_FLAG') THEN
350 IF NVL(p_record.OVERRIDE_BLANKET_CONTROLS_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
351 RETURN p_record.OVERRIDE_BLANKET_CONTROLS_FLAG;
352 ELSE
353 RETURN NULL;
354 END IF;
355 ELSIF p_attr_code =('OVERRIDE_RELEASE_CONTROLS_FLAG') THEN
356 IF NVL(p_record.OVERRIDE_RELEASE_CONTROLS_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
357 RETURN p_record.OVERRIDE_RELEASE_CONTROLS_FLAG;
358 ELSE
359 RETURN NULL;
360 END IF;
361 ELSIF p_attr_code =('PACKING_INSTRUCTIONS') THEN
362 IF NVL(p_record.PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
363 RETURN p_record.PACKING_INSTRUCTIONS;
364 ELSE
365 RETURN NULL;
366 END IF;
367 ELSIF p_attr_code =('PAYMENT_TERM_ID') THEN
368 IF NVL(p_record.PAYMENT_TERM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
369 RETURN p_record.PAYMENT_TERM_ID;
370 ELSE
371 RETURN NULL;
372 END IF;
373 ELSIF p_attr_code =('PREFERRED_GRADE') THEN
377 RETURN NULL;
374 IF NVL(p_record.PREFERRED_GRADE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
375 RETURN p_record.PREFERRED_GRADE;
376 ELSE
378 END IF;
379 ELSIF p_attr_code =('PRICE_LIST_ID') THEN
380 IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
381 RETURN p_record.PRICE_LIST_ID;
382 ELSE
383 RETURN NULL;
384 END IF;
385 ELSIF p_attr_code =('PRICING_QUANTITY_UOM') THEN
386 IF NVL(p_record.PRICING_QUANTITY_UOM, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
387 RETURN p_record.PRICING_QUANTITY_UOM;
388 ELSE
389 RETURN NULL;
390 END IF;
391 ELSIF p_attr_code =('SALESREP_ID') THEN
392 IF NVL(p_record.SALESREP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
393 RETURN p_record.SALESREP_ID;
394 ELSE
395 RETURN NULL;
396 END IF;
397 ELSIF p_attr_code =('SHIPPING_INSTRUCTIONS') THEN
398 IF NVL(p_record.SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
399 RETURN p_record.SHIPPING_INSTRUCTIONS;
400 ELSE
401 RETURN NULL;
402 END IF;
403 ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
404 IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
405 RETURN p_record.SHIPPING_METHOD_CODE;
406 ELSE
407 RETURN NULL;
408 END IF;
409 ELSIF p_attr_code =('SHIP_FROM_ORG_ID') THEN
410 IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
411 RETURN p_record.SHIP_FROM_ORG_ID;
412 ELSE
413 RETURN NULL;
414 END IF;
415 ELSIF p_attr_code =('SHIP_TO_ORG_ID') THEN
416 IF NVL(p_record.SHIP_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
417 RETURN p_record.SHIP_TO_ORG_ID;
418 ELSE
419 RETURN NULL;
420 END IF;
421 ELSIF p_attr_code =('SOURCE_DOCUMENT_TYPE_ID') THEN
422 IF NVL(p_record.SOURCE_DOCUMENT_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
423 RETURN p_record.SOURCE_DOCUMENT_TYPE_ID;
424 ELSE
425 RETURN NULL;
426 END IF;
427 ELSIF p_attr_code =('SOURCE_DOCUMENT_VERSION_NUMBER') THEN
428 IF NVL(p_record.SOURCE_DOCUMENT_VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
429 RETURN p_record.SOURCE_DOCUMENT_VERSION_NUMBER;
430 ELSE
431 RETURN NULL;
432 END IF;
433 ELSIF p_attr_code =('START_DATE_ACTIVE') THEN
434 IF NVL(p_record.START_DATE_ACTIVE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
435 RETURN p_record.START_DATE_ACTIVE;
436 ELSE
437 RETURN NULL;
438 END IF;
439 ELSIF p_attr_code =('TRANSACTION_PHASE_CODE') THEN
440 IF NVL(p_record.TRANSACTION_PHASE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
441 RETURN p_record.TRANSACTION_PHASE_CODE;
442 ELSE
443 RETURN NULL;
444 END IF;
445 ELSIF p_attr_code =('UNIT_LIST_PRICE') THEN
446 IF NVL(p_record.UNIT_LIST_PRICE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
447 RETURN p_record.UNIT_LIST_PRICE;
448 ELSE
449 RETURN NULL;
450 END IF;
451 ELSE
452 RETURN NULL;
453 END IF;
454 END Get_Attr_Val_Varchar2;
455
456
457 FUNCTION Get_Attr_Val_Date
458 ( p_attr_code IN VARCHAR2
459 , p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
460 ) RETURN DATE
461 IS
462 BEGIN
463
464 IF p_attr_code =('END_DATE_ACTIVE') THEN
465 IF NVL(p_record.END_DATE_ACTIVE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
466 RETURN p_record.END_DATE_ACTIVE;
467 ELSE
468 RETURN NULL;
469 END IF;
470 ELSIF p_attr_code =('START_DATE_ACTIVE') THEN
471 IF NVL(p_record.START_DATE_ACTIVE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
472 RETURN p_record.START_DATE_ACTIVE;
473 ELSE
474 RETURN NULL;
475 END IF;
476 ELSIF p_attr_code =('ACCOUNTING_RULE_ID') THEN
477 IF NVL(p_record.ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
478 RETURN to_date(p_record.ACCOUNTING_RULE_ID,'RRRR/MM/DD HH24:MI:SS');
479 ELSE
480 RETURN NULL;
481 END IF;
482 ELSIF p_attr_code =('ATTRIBUTE1') THEN
483 IF NVL(p_record.ATTRIBUTE1, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
484 RETURN to_date(p_record.ATTRIBUTE1,'RRRR/MM/DD HH24:MI:SS');
485 ELSE
486 RETURN NULL;
487 END IF;
488 ELSIF p_attr_code =('ATTRIBUTE10') THEN
489 IF NVL(p_record.ATTRIBUTE10, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
490 RETURN to_date(p_record.ATTRIBUTE10,'RRRR/MM/DD HH24:MI:SS');
491 ELSE
492 RETURN NULL;
493 END IF;
494 ELSIF p_attr_code =('ATTRIBUTE11') THEN
495 IF NVL(p_record.ATTRIBUTE11, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
496 RETURN to_date(p_record.ATTRIBUTE11,'RRRR/MM/DD HH24:MI:SS');
497 ELSE
498 RETURN NULL;
499 END IF;
500 ELSIF p_attr_code =('ATTRIBUTE12') THEN
501 IF NVL(p_record.ATTRIBUTE12, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
502 RETURN to_date(p_record.ATTRIBUTE12,'RRRR/MM/DD HH24:MI:SS');
503 ELSE
504 RETURN NULL;
505 END IF;
506 ELSIF p_attr_code =('ATTRIBUTE13') THEN
507 IF NVL(p_record.ATTRIBUTE13, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
508 RETURN to_date(p_record.ATTRIBUTE13,'RRRR/MM/DD HH24:MI:SS');
509 ELSE
510 RETURN NULL;
511 END IF;
515 ELSE
512 ELSIF p_attr_code =('ATTRIBUTE14') THEN
513 IF NVL(p_record.ATTRIBUTE14, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
514 RETURN to_date(p_record.ATTRIBUTE14,'RRRR/MM/DD HH24:MI:SS');
516 RETURN NULL;
517 END IF;
518 ELSIF p_attr_code =('ATTRIBUTE15') THEN
519 IF NVL(p_record.ATTRIBUTE15, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
520 RETURN to_date(p_record.ATTRIBUTE15,'RRRR/MM/DD HH24:MI:SS');
521 ELSE
522 RETURN NULL;
523 END IF;
524 ELSIF p_attr_code =('ATTRIBUTE16') THEN
525 IF NVL(p_record.ATTRIBUTE16, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
526 RETURN to_date(p_record.ATTRIBUTE16,'RRRR/MM/DD HH24:MI:SS');
527 ELSE
528 RETURN NULL;
529 END IF;
530 ELSIF p_attr_code =('ATTRIBUTE17') THEN
531 IF NVL(p_record.ATTRIBUTE17, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
532 RETURN to_date(p_record.ATTRIBUTE17,'RRRR/MM/DD HH24:MI:SS');
533 ELSE
534 RETURN NULL;
535 END IF;
536 ELSIF p_attr_code =('ATTRIBUTE18') THEN
537 IF NVL(p_record.ATTRIBUTE18, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
538 RETURN to_date(p_record.ATTRIBUTE18,'RRRR/MM/DD HH24:MI:SS');
539 ELSE
540 RETURN NULL;
541 END IF;
542 ELSIF p_attr_code =('ATTRIBUTE19') THEN
543 IF NVL(p_record.ATTRIBUTE19, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
544 RETURN to_date(p_record.ATTRIBUTE19,'RRRR/MM/DD HH24:MI:SS');
545 ELSE
546 RETURN NULL;
547 END IF;
548 ELSIF p_attr_code =('ATTRIBUTE2') THEN
549 IF NVL(p_record.ATTRIBUTE2, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
550 RETURN to_date(p_record.ATTRIBUTE2,'RRRR/MM/DD HH24:MI:SS');
551 ELSE
552 RETURN NULL;
553 END IF;
554 ELSIF p_attr_code =('ATTRIBUTE20') THEN
555 IF NVL(p_record.ATTRIBUTE20, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
556 RETURN to_date(p_record.ATTRIBUTE20,'RRRR/MM/DD HH24:MI:SS');
557 ELSE
558 RETURN NULL;
559 END IF;
560 ELSIF p_attr_code =('ATTRIBUTE3') THEN
561 IF NVL(p_record.ATTRIBUTE3, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
562 RETURN to_date(p_record.ATTRIBUTE3,'RRRR/MM/DD HH24:MI:SS');
563 ELSE
564 RETURN NULL;
565 END IF;
566 ELSIF p_attr_code =('ATTRIBUTE4') THEN
567 IF NVL(p_record.ATTRIBUTE4, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
568 RETURN to_date(p_record.ATTRIBUTE4,'RRRR/MM/DD HH24:MI:SS');
569 ELSE
570 RETURN NULL;
571 END IF;
572 ELSIF p_attr_code =('ATTRIBUTE5') THEN
573 IF NVL(p_record.ATTRIBUTE5, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
574 RETURN to_date(p_record.ATTRIBUTE5,'RRRR/MM/DD HH24:MI:SS');
575 ELSE
576 RETURN NULL;
577 END IF;
578 ELSIF p_attr_code =('ATTRIBUTE6') THEN
579 IF NVL(p_record.ATTRIBUTE6, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
580 RETURN to_date(p_record.ATTRIBUTE6,'RRRR/MM/DD HH24:MI:SS');
581 ELSE
582 RETURN NULL;
583 END IF;
584 ELSIF p_attr_code =('ATTRIBUTE7') THEN
585 IF NVL(p_record.ATTRIBUTE7, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
586 RETURN to_date(p_record.ATTRIBUTE7,'RRRR/MM/DD HH24:MI:SS');
587 ELSE
588 RETURN NULL;
589 END IF;
590 ELSIF p_attr_code =('ATTRIBUTE8') THEN
591 IF NVL(p_record.ATTRIBUTE8, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
592 RETURN to_date(p_record.ATTRIBUTE8,'RRRR/MM/DD HH24:MI:SS');
593 ELSE
594 RETURN NULL;
595 END IF;
596 ELSIF p_attr_code =('ATTRIBUTE9') THEN
597 IF NVL(p_record.ATTRIBUTE9, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
598 RETURN to_date(p_record.ATTRIBUTE9,'RRRR/MM/DD HH24:MI:SS');
599 ELSE
600 RETURN NULL;
601 END IF;
602 ELSIF p_attr_code =('BLANKET_LINE_MAX_AMOUNT') THEN
603 IF NVL(p_record.BLANKET_LINE_MAX_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
604 RETURN to_date(p_record.BLANKET_LINE_MAX_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
605 ELSE
606 RETURN NULL;
607 END IF;
608 ELSIF p_attr_code =('BLANKET_LINE_MIN_AMOUNT') THEN
609 IF NVL(p_record.BLANKET_LINE_MIN_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
610 RETURN to_date(p_record.BLANKET_LINE_MIN_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
611 ELSE
612 RETURN NULL;
613 END IF;
614 ELSIF p_attr_code =('BLANKET_MAX_QUANTITY') THEN
615 IF NVL(p_record.BLANKET_MAX_QUANTITY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
616 RETURN to_date(p_record.BLANKET_MAX_QUANTITY,'RRRR/MM/DD HH24:MI:SS');
617 ELSE
618 RETURN NULL;
619 END IF;
620 ELSIF p_attr_code =('BLANKET_MIN_QUANTITY') THEN
621 IF NVL(p_record.BLANKET_MIN_QUANTITY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
622 RETURN to_date(p_record.BLANKET_MIN_QUANTITY,'RRRR/MM/DD HH24:MI:SS');
623 ELSE
624 RETURN NULL;
625 END IF;
626 ELSIF p_attr_code =('CONTEXT') THEN
627 IF NVL(p_record.CONTEXT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
628 RETURN to_date(p_record.CONTEXT,'RRRR/MM/DD HH24:MI:SS');
629 ELSE
630 RETURN NULL;
631 END IF;
632 ELSIF p_attr_code =('CUST_PO_NUMBER') THEN
633 IF NVL(p_record.CUST_PO_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
634 RETURN to_date(p_record.CUST_PO_NUMBER,'RRRR/MM/DD HH24:MI:SS');
635 ELSE
636 RETURN NULL;
640 RETURN to_date(p_record.DELIVER_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
637 END IF;
638 ELSIF p_attr_code =('DELIVER_TO_ORG_ID') THEN
639 IF NVL(p_record.DELIVER_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
641 ELSE
642 RETURN NULL;
643 END IF;
644 ELSIF p_attr_code =('DISCOUNT_AMOUNT') THEN
645 IF NVL(p_record.DISCOUNT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
646 RETURN to_date(p_record.DISCOUNT_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
647 ELSE
648 RETURN NULL;
649 END IF;
650 ELSIF p_attr_code =('DISCOUNT_PERCENT') THEN
651 IF NVL(p_record.DISCOUNT_PERCENT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
652 RETURN to_date(p_record.DISCOUNT_PERCENT,'RRRR/MM/DD HH24:MI:SS');
653 ELSE
654 RETURN NULL;
655 END IF;
656 ELSIF p_attr_code =('ENFORCE_ACCOUNTING_RULE_FLAG') THEN
657 IF NVL(p_record.ENFORCE_ACCOUNTING_RULE_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
658 RETURN to_date(p_record.ENFORCE_ACCOUNTING_RULE_FLAG,'RRRR/MM/DD HH24:MI:SS');
659 ELSE
660 RETURN NULL;
661 END IF;
662 ELSIF p_attr_code =('ENFORCE_FREIGHT_TERM_FLAG') THEN
663 IF NVL(p_record.ENFORCE_FREIGHT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
664 RETURN to_date(p_record.ENFORCE_FREIGHT_TERM_FLAG,'RRRR/MM/DD HH24:MI:SS');
665 ELSE
666 RETURN NULL;
667 END IF;
668 ELSIF p_attr_code =('ENFORCE_INVOICE_TO_FLAG') THEN
669 IF NVL(p_record.ENFORCE_INVOICE_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
670 RETURN to_date(p_record.ENFORCE_INVOICE_TO_FLAG,'RRRR/MM/DD HH24:MI:SS');
671 ELSE
672 RETURN NULL;
673 END IF;
674 ELSIF p_attr_code =('ENFORCE_INVOICING_RULE_FLAG') THEN
675 IF NVL(p_record.ENFORCE_INVOICING_RULE_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
676 RETURN to_date(p_record.ENFORCE_INVOICING_RULE_FLAG,'RRRR/MM/DD HH24:MI:SS');
677 ELSE
678 RETURN NULL;
679 END IF;
680 ELSIF p_attr_code =('ENFORCE_PAYMENT_TERM_FLAG') THEN
681 IF NVL(p_record.ENFORCE_PAYMENT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
682 RETURN to_date(p_record.ENFORCE_PAYMENT_TERM_FLAG,'RRRR/MM/DD HH24:MI:SS');
683 ELSE
684 RETURN NULL;
685 END IF;
686 ELSIF p_attr_code =('ENFORCE_PRICE_LIST_FLAG') THEN
687 IF NVL(p_record.ENFORCE_PRICE_LIST_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
688 RETURN to_date(p_record.ENFORCE_PRICE_LIST_FLAG,'RRRR/MM/DD HH24:MI:SS');
689 ELSE
690 RETURN NULL;
691 END IF;
692 ELSIF p_attr_code =('ENFORCE_SHIPPING_METHOD_FLAG') THEN
693 IF NVL(p_record.ENFORCE_SHIPPING_METHOD_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
694 RETURN to_date(p_record.ENFORCE_SHIPPING_METHOD_FLAG,'RRRR/MM/DD HH24:MI:SS');
695 ELSE
696 RETURN NULL;
697 END IF;
698 ELSIF p_attr_code =('ENFORCE_SHIP_TO_FLAG') THEN
699 IF NVL(p_record.ENFORCE_SHIP_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
700 RETURN to_date(p_record.ENFORCE_SHIP_TO_FLAG,'RRRR/MM/DD HH24:MI:SS');
701 ELSE
702 RETURN NULL;
703 END IF;
704 ELSIF p_attr_code =('FREIGHT_TERMS_CODE') THEN
705 IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
706 RETURN to_date(p_record.FREIGHT_TERMS_CODE,'RRRR/MM/DD HH24:MI:SS');
707 ELSE
708 RETURN NULL;
709 END IF;
710 ELSIF p_attr_code =('INVENTORY_ITEM_ID') THEN
711 IF NVL(p_record.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
712 RETURN to_date(p_record.INVENTORY_ITEM_ID,'RRRR/MM/DD HH24:MI:SS');
713 ELSE
714 RETURN NULL;
715 END IF;
716 ELSIF p_attr_code =('INVOICE_TO_ORG_ID') THEN
717 IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
718 RETURN to_date(p_record.INVOICE_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
719 ELSE
720 RETURN NULL;
721 END IF;
722 ELSIF p_attr_code =('INVOICING_RULE_ID') THEN
723 IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
724 RETURN to_date(p_record.INVOICING_RULE_ID,'RRRR/MM/DD HH24:MI:SS');
725 ELSE
726 RETURN NULL;
727 END IF;
728 ELSIF p_attr_code =('ITEM_IDENTIFIER_TYPE') THEN
729 IF NVL(p_record.ITEM_IDENTIFIER_TYPE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
730 RETURN to_date(p_record.ITEM_IDENTIFIER_TYPE,'RRRR/MM/DD HH24:MI:SS');
731 ELSE
732 RETURN NULL;
733 END IF;
734 ELSIF p_attr_code =('LINE_NUMBER') THEN
735 IF NVL(p_record.LINE_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
736 RETURN to_date(p_record.LINE_NUMBER,'RRRR/MM/DD HH24:MI:SS');
737 ELSE
738 RETURN NULL;
739 END IF;
740 ELSIF p_attr_code =('MAX_RELEASE_AMOUNT') THEN
741 IF NVL(p_record.MAX_RELEASE_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
742 RETURN to_date(p_record.MAX_RELEASE_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
743 ELSE
744 RETURN NULL;
745 END IF;
746 ELSIF p_attr_code =('MAX_RELEASE_QUANTITY') THEN
747 IF NVL(p_record.MAX_RELEASE_QUANTITY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
748 RETURN to_date(p_record.MAX_RELEASE_QUANTITY,'RRRR/MM/DD HH24:MI:SS');
749 ELSE
750 RETURN NULL;
751 END IF;
752 ELSIF p_attr_code =('MIN_RELEASE_AMOUNT') THEN
753 IF NVL(p_record.MIN_RELEASE_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
757 END IF;
754 RETURN to_date(p_record.MIN_RELEASE_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
755 ELSE
756 RETURN NULL;
758 ELSIF p_attr_code =('MIN_RELEASE_QUANTITY') THEN
759 IF NVL(p_record.MIN_RELEASE_QUANTITY, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
760 RETURN to_date(p_record.MIN_RELEASE_QUANTITY,'RRRR/MM/DD HH24:MI:SS');
761 ELSE
762 RETURN NULL;
763 END IF;
764 ELSIF p_attr_code =('MODIFIER_LIST_LINE_ID') THEN
765 IF NVL(p_record.MODIFIER_LIST_LINE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
766 RETURN to_date(p_record.MODIFIER_LIST_LINE_ID,'RRRR/MM/DD HH24:MI:SS');
767 ELSE
768 RETURN NULL;
769 END IF;
770 ELSIF p_attr_code =('ORDER_NUMBER') THEN
771 IF NVL(p_record.ORDER_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
772 RETURN to_date(p_record.ORDER_NUMBER,'RRRR/MM/DD HH24:MI:SS');
773 ELSE
774 RETURN NULL;
775 END IF;
776 ELSIF p_attr_code =('ORDER_QUANTITY_UOM') THEN
777 IF NVL(p_record.ORDER_QUANTITY_UOM, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
778 RETURN to_date(p_record.ORDER_QUANTITY_UOM,'RRRR/MM/DD HH24:MI:SS');
779 ELSE
780 RETURN NULL;
781 END IF;
782 ELSIF p_attr_code =('OVERRIDE_BLANKET_CONTROLS_FLAG') THEN
783 IF NVL(p_record.OVERRIDE_BLANKET_CONTROLS_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
784 RETURN to_date(p_record.OVERRIDE_BLANKET_CONTROLS_FLAG,'RRRR/MM/DD HH24:MI:SS');
785 ELSE
786 RETURN NULL;
787 END IF;
788 ELSIF p_attr_code =('OVERRIDE_RELEASE_CONTROLS_FLAG') THEN
789 IF NVL(p_record.OVERRIDE_RELEASE_CONTROLS_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
790 RETURN to_date(p_record.OVERRIDE_RELEASE_CONTROLS_FLAG,'RRRR/MM/DD HH24:MI:SS');
791 ELSE
792 RETURN NULL;
793 END IF;
794 ELSIF p_attr_code =('PACKING_INSTRUCTIONS') THEN
795 IF NVL(p_record.PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
796 RETURN to_date(p_record.PACKING_INSTRUCTIONS,'RRRR/MM/DD HH24:MI:SS');
797 ELSE
798 RETURN NULL;
799 END IF;
800 ELSIF p_attr_code =('PAYMENT_TERM_ID') THEN
801 IF NVL(p_record.PAYMENT_TERM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
802 RETURN to_date(p_record.PAYMENT_TERM_ID,'RRRR/MM/DD HH24:MI:SS');
803 ELSE
804 RETURN NULL;
805 END IF;
806 ELSIF p_attr_code =('PREFERRED_GRADE') THEN
807 IF NVL(p_record.PREFERRED_GRADE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
808 RETURN to_date(p_record.PREFERRED_GRADE,'RRRR/MM/DD HH24:MI:SS');
809 ELSE
810 RETURN NULL;
811 END IF;
812 ELSIF p_attr_code =('PRICE_LIST_ID') THEN
813 IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
814 RETURN to_date(p_record.PRICE_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
815 ELSE
816 RETURN NULL;
817 END IF;
818 ELSIF p_attr_code =('PRICING_QUANTITY_UOM') THEN
819 IF NVL(p_record.PRICING_QUANTITY_UOM, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
820 RETURN to_date(p_record.PRICING_QUANTITY_UOM,'RRRR/MM/DD HH24:MI:SS');
821 ELSE
822 RETURN NULL;
823 END IF;
824 ELSIF p_attr_code =('SALESREP_ID') THEN
825 IF NVL(p_record.SALESREP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
826 RETURN to_date(p_record.SALESREP_ID,'RRRR/MM/DD HH24:MI:SS');
827 ELSE
828 RETURN NULL;
829 END IF;
830 ELSIF p_attr_code =('SHIPPING_INSTRUCTIONS') THEN
831 IF NVL(p_record.SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
832 RETURN to_date(p_record.SHIPPING_INSTRUCTIONS,'RRRR/MM/DD HH24:MI:SS');
833 ELSE
834 RETURN NULL;
835 END IF;
836 ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
837 IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
838 RETURN to_date(p_record.SHIPPING_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
839 ELSE
840 RETURN NULL;
841 END IF;
842 ELSIF p_attr_code =('SHIP_FROM_ORG_ID') THEN
843 IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
844 RETURN to_date(p_record.SHIP_FROM_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
845 ELSE
846 RETURN NULL;
847 END IF;
848 ELSIF p_attr_code =('SHIP_TO_ORG_ID') THEN
849 IF NVL(p_record.SHIP_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
850 RETURN to_date(p_record.SHIP_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
851 ELSE
852 RETURN NULL;
853 END IF;
854 ELSIF p_attr_code =('SOURCE_DOCUMENT_TYPE_ID') THEN
855 IF NVL(p_record.SOURCE_DOCUMENT_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
856 RETURN to_date(p_record.SOURCE_DOCUMENT_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
857 ELSE
858 RETURN NULL;
859 END IF;
860 ELSIF p_attr_code =('SOURCE_DOCUMENT_VERSION_NUMBER') THEN
861 IF NVL(p_record.SOURCE_DOCUMENT_VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
862 RETURN to_date(p_record.SOURCE_DOCUMENT_VERSION_NUMBER,'RRRR/MM/DD HH24:MI:SS');
863 ELSE
864 RETURN NULL;
865 END IF;
866 ELSIF p_attr_code =('TRANSACTION_PHASE_CODE') THEN
867 IF NVL(p_record.TRANSACTION_PHASE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
868 RETURN to_date(p_record.TRANSACTION_PHASE_CODE,'RRRR/MM/DD HH24:MI:SS');
869 ELSE
870 RETURN NULL;
871 END IF;
872 ELSIF p_attr_code =('UNIT_LIST_PRICE') THEN
873 IF NVL(p_record.UNIT_LIST_PRICE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
874 RETURN to_date(p_record.UNIT_LIST_PRICE,'RRRR/MM/DD HH24:MI:SS');
875 ELSE
876 RETURN NULL;
877 END IF;
878 ELSE
879 RETURN NULL;
880 END IF;
881
882 END Get_Attr_Val_Date;
883
884
885 PROCEDURE Clear_BLANKET_LINE_Cache
886 IS
887 BEGIN
888 g_cached_record.ORDER_NUMBER := null;
889 g_cached_record.LINE_NUMBER := null;
890 END Clear_BLANKET_LINE_Cache;
891
892
893 FUNCTION Sync_BLANKET_LINE_Cache
894 ( p_ORDER_NUMBER IN NUMBER
895 , p_LINE_NUMBER IN NUMBER
896
897
898 ) RETURN NUMBER
899 IS
900 CURSOR cache IS
901 SELECT * FROM OE_AK_BLANKET_LINES_V
902 WHERE ORDER_NUMBER = p_ORDER_NUMBER
903 AND LINE_NUMBER = p_LINE_NUMBER
904 ;
905 BEGIN
906
907 IF (NVL(p_ORDER_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
908 OR (NVL(p_LINE_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
909 THEN
910 RETURN 0 ;
911 ELSIF (NVL(g_cached_record.ORDER_NUMBER,FND_API.G_MISS_NUM) <> p_ORDER_NUMBER)
912 OR (NVL(g_cached_record.LINE_NUMBER,FND_API.G_MISS_NUM) <> p_LINE_NUMBER)
913 THEN
914 Clear_BLANKET_LINE_Cache;
915 Open cache;
916 FETCH cache into g_cached_record;
917 IF cache%NOTFOUND THEN
918 RETURN 0;
919 END IF;
920 Close cache;
921 RETURN 1 ;
922 END IF;
923
924 RETURN 1 ;
925 EXCEPTION
926 WHEN OTHERS THEN
927 RETURN 0 ;
928 END Sync_BLANKET_LINE_Cache;
929
930
931 END ONT_BLANKET_LINE_Def_Util;