eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.ONT_BLANKET_LINE_DEF_UTIL

Source


1 PACKAGE BODY ONT_BLANKET_LINE_Def_Util AS
2 /* $Header: OEXDFWKB.pls 115.0 13-AUG-13 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 --  13-AUG-13 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
74   IF NVL(p_record.ATTRIBUTE14, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
71   RETURN NULL; 
72   END IF;
73 ELSIF p_attr_code =('ATTRIBUTE14') 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
228   END IF;
225   RETURN p_record.ENFORCE_ACCOUNTING_RULE_FLAG;
226   ELSE
227   RETURN NULL; 
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;
367 ELSIF p_attr_code =('PAYMENT_TERM_ID') THEN
364   ELSE
365   RETURN NULL; 
366   END IF;
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
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
377   RETURN NULL; 
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;
512 ELSIF p_attr_code =('ATTRIBUTE14') THEN
516     RETURN NULL; 
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');
515     ELSE
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; 
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
640     RETURN to_date(p_record.DELIVER_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
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');
650 ELSIF p_attr_code =('DISCOUNT_PERCENT') THEN
647     ELSE
648     RETURN NULL; 
649     END IF;
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
754     RETURN to_date(p_record.MIN_RELEASE_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
755     ELSE
756     RETURN NULL; 
757     END IF;
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
777     IF NVL(p_record.ORDER_QUANTITY_UOM, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
774     RETURN NULL; 
775     END IF;
776 ELSIF p_attr_code =('ORDER_QUANTITY_UOM') 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;