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_HEADER_DEF_UTIL

Source


1 PACKAGE BODY ONT_BLANKET_HEADER_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_HEADER_Def_Util
11 --  
12 --  DESCRIPTION
13 --  
14 --      Body of package ONT_BLANKET_HEADER_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_HEADER_Def_Util';
25  
26  
27   g_database_object_name varchar2(30) :='OE_AK_BLANKET_HEADERS_V';
28  
29  
30 FUNCTION Get_Attr_Val_Varchar2
31 (   p_attr_code                     IN  VARCHAR2
32 ,   p_record                        IN  OE_AK_BLANKET_HEADERS_V%ROWTYPE 
33 ) RETURN VARCHAR2
34 IS
35 BEGIN
36  
37 IF p_attr_code =('ACCOUNTING_RULE_ID') THEN
41   RETURN NULL; 
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
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_MAX_AMOUNT') THEN
164   IF NVL(p_record.BLANKET_MAX_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
165   RETURN p_record.BLANKET_MAX_AMOUNT;
166   ELSE
167   RETURN NULL; 
168   END IF;
169 ELSIF p_attr_code =('BLANKET_MIN_AMOUNT') THEN
170   IF NVL(p_record.BLANKET_MIN_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
171   RETURN p_record.BLANKET_MIN_AMOUNT;
172   ELSE
173   RETURN NULL; 
174   END IF;
175 ELSIF p_attr_code =('CONTEXT') THEN
176   IF NVL(p_record.CONTEXT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
177   RETURN p_record.CONTEXT;
178   ELSE
179   RETURN NULL; 
180   END IF;
181 ELSIF p_attr_code =('CONTRACT_TERMS') THEN
182   IF NVL(p_record.CONTRACT_TERMS, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
183   RETURN p_record.CONTRACT_TERMS;
184   ELSE
185   RETURN NULL; 
186   END IF;
187 ELSIF p_attr_code =('CONVERSION_TYPE_CODE') THEN
188   IF NVL(p_record.CONVERSION_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
189   RETURN p_record.CONVERSION_TYPE_CODE;
190   ELSE
191   RETURN NULL; 
192   END IF;
193 ELSIF p_attr_code =('CUSTOMER_SIGNATURE') THEN
197   RETURN NULL; 
194   IF NVL(p_record.CUSTOMER_SIGNATURE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
195   RETURN p_record.CUSTOMER_SIGNATURE;
196   ELSE
198   END IF;
199 ELSIF p_attr_code =('CUSTOMER_SIGNATURE_DATE') THEN
200   IF NVL(p_record.CUSTOMER_SIGNATURE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
201   RETURN p_record.CUSTOMER_SIGNATURE_DATE;
202   ELSE
203   RETURN NULL; 
204   END IF;
205 ELSIF p_attr_code =('CUST_PO_NUMBER') THEN
206   IF NVL(p_record.CUST_PO_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
207   RETURN p_record.CUST_PO_NUMBER;
208   ELSE
209   RETURN NULL; 
210   END IF;
211 ELSIF p_attr_code =('DEFAULT_DISCOUNT_AMOUNT') THEN
212   IF NVL(p_record.DEFAULT_DISCOUNT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
213   RETURN p_record.DEFAULT_DISCOUNT_AMOUNT;
214   ELSE
215   RETURN NULL; 
216   END IF;
217 ELSIF p_attr_code =('DEFAULT_DISCOUNT_PERCENT') THEN
218   IF NVL(p_record.DEFAULT_DISCOUNT_PERCENT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
219   RETURN p_record.DEFAULT_DISCOUNT_PERCENT;
220   ELSE
221   RETURN NULL; 
222   END IF;
223 ELSIF p_attr_code =('DELIVER_TO_ORG_ID') THEN
224   IF NVL(p_record.DELIVER_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
225   RETURN p_record.DELIVER_TO_ORG_ID;
226   ELSE
227   RETURN NULL; 
228   END IF;
229 ELSIF p_attr_code =('DRAFT_SUBMITTED_FLAG') THEN
230   IF NVL(p_record.DRAFT_SUBMITTED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
231   RETURN p_record.DRAFT_SUBMITTED_FLAG;
232   ELSE
233   RETURN NULL; 
234   END IF;
235 ELSIF p_attr_code =('END_DATE_ACTIVE') THEN
236   IF NVL(p_record.END_DATE_ACTIVE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
237   RETURN p_record.END_DATE_ACTIVE;
238   ELSE
239   RETURN NULL; 
240   END IF;
241 ELSIF p_attr_code =('ENFORCE_ACCOUNTING_RULE_FLAG') THEN
242   IF NVL(p_record.ENFORCE_ACCOUNTING_RULE_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
243   RETURN p_record.ENFORCE_ACCOUNTING_RULE_FLAG;
244   ELSE
245   RETURN NULL; 
246   END IF;
247 ELSIF p_attr_code =('ENFORCE_FREIGHT_TERM_FLAG') THEN
248   IF NVL(p_record.ENFORCE_FREIGHT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
249   RETURN p_record.ENFORCE_FREIGHT_TERM_FLAG;
250   ELSE
251   RETURN NULL; 
252   END IF;
253 ELSIF p_attr_code =('ENFORCE_INVOICE_TO_FLAG') THEN
254   IF NVL(p_record.ENFORCE_INVOICE_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
255   RETURN p_record.ENFORCE_INVOICE_TO_FLAG;
256   ELSE
257   RETURN NULL; 
258   END IF;
259 ELSIF p_attr_code =('ENFORCE_INVOICING_RULE_FLAG') THEN
260   IF NVL(p_record.ENFORCE_INVOICING_RULE_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
261   RETURN p_record.ENFORCE_INVOICING_RULE_FLAG;
262   ELSE
263   RETURN NULL; 
264   END IF;
265 ELSIF p_attr_code =('ENFORCE_PAYMENT_TERM_FLAG') THEN
266   IF NVL(p_record.ENFORCE_PAYMENT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
267   RETURN p_record.ENFORCE_PAYMENT_TERM_FLAG;
268   ELSE
269   RETURN NULL; 
270   END IF;
271 ELSIF p_attr_code =('ENFORCE_PRICE_LIST_FLAG') THEN
272   IF NVL(p_record.ENFORCE_PRICE_LIST_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
273   RETURN p_record.ENFORCE_PRICE_LIST_FLAG;
274   ELSE
275   RETURN NULL; 
276   END IF;
277 ELSIF p_attr_code =('ENFORCE_SHIPPING_METHOD_FLAG') THEN
278   IF NVL(p_record.ENFORCE_SHIPPING_METHOD_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
279   RETURN p_record.ENFORCE_SHIPPING_METHOD_FLAG;
280   ELSE
281   RETURN NULL; 
282   END IF;
283 ELSIF p_attr_code =('ENFORCE_SHIP_TO_FLAG') THEN
284   IF NVL(p_record.ENFORCE_SHIP_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
285   RETURN p_record.ENFORCE_SHIP_TO_FLAG;
286   ELSE
287   RETURN NULL; 
288   END IF;
289 ELSIF p_attr_code =('FLOW_STATUS_CODE') THEN
290   IF NVL(p_record.FLOW_STATUS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
291   RETURN p_record.FLOW_STATUS_CODE;
292   ELSE
293   RETURN NULL; 
294   END IF;
295 ELSIF p_attr_code =('FREIGHT_TERMS_CODE') THEN
296   IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
297   RETURN p_record.FREIGHT_TERMS_CODE;
298   ELSE
299   RETURN NULL; 
300   END IF;
301 ELSIF p_attr_code =('INVOICE_TO_ORG_ID') THEN
302   IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
303   RETURN p_record.INVOICE_TO_ORG_ID;
304   ELSE
305   RETURN NULL; 
306   END IF;
307 ELSIF p_attr_code =('INVOICING_RULE_ID') THEN
308   IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
309   RETURN p_record.INVOICING_RULE_ID;
310   ELSE
311   RETURN NULL; 
312   END IF;
313 ELSIF p_attr_code =('NEW_MODIFIER_LIST_ID') THEN
314   IF NVL(p_record.NEW_MODIFIER_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
315   RETURN p_record.NEW_MODIFIER_LIST_ID;
316   ELSE
317   RETURN NULL; 
318   END IF;
319 ELSIF p_attr_code =('NEW_PRICE_LIST_ID') THEN
320   IF NVL(p_record.NEW_PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
321   RETURN p_record.NEW_PRICE_LIST_ID;
322   ELSE
323   RETURN NULL; 
324   END IF;
325 ELSIF p_attr_code =('ON_HOLD_FLAG') THEN
326   IF NVL(p_record.ON_HOLD_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
327   RETURN p_record.ON_HOLD_FLAG;
328   ELSE
329   RETURN NULL; 
330   END IF;
331 ELSIF p_attr_code =('OPEN_FLAG') THEN
335   RETURN NULL; 
332   IF NVL(p_record.OPEN_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
333   RETURN p_record.OPEN_FLAG;
334   ELSE
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_TYPE_ID') THEN
344   IF NVL(p_record.ORDER_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
345   RETURN p_record.ORDER_TYPE_ID;
346   ELSE
347   RETURN NULL; 
348   END IF;
349 ELSIF p_attr_code =('OVERRIDE_AMOUNT_FLAG') THEN
350   IF NVL(p_record.OVERRIDE_AMOUNT_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
351   RETURN p_record.OVERRIDE_AMOUNT_FLAG;
352   ELSE
353   RETURN NULL; 
354   END IF;
355 ELSIF p_attr_code =('PACKING_INSTRUCTIONS') THEN
356   IF NVL(p_record.PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
357   RETURN p_record.PACKING_INSTRUCTIONS;
358   ELSE
359   RETURN NULL; 
360   END IF;
361 ELSIF p_attr_code =('PAYMENT_TERM_ID') THEN
362   IF NVL(p_record.PAYMENT_TERM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
363   RETURN p_record.PAYMENT_TERM_ID;
364   ELSE
365   RETURN NULL; 
366   END IF;
367 ELSIF p_attr_code =('PRICE_LIST_ID') THEN
368   IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
369   RETURN p_record.PRICE_LIST_ID;
370   ELSE
371   RETURN NULL; 
372   END IF;
373 ELSIF p_attr_code =('QUOTE_DATE') THEN
374   IF NVL(p_record.QUOTE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
375   RETURN p_record.QUOTE_DATE;
376   ELSE
377   RETURN NULL; 
378   END IF;
379 ELSIF p_attr_code =('QUOTE_NUMBER') THEN
380   IF NVL(p_record.QUOTE_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
381   RETURN p_record.QUOTE_NUMBER;
382   ELSE
383   RETURN NULL; 
384   END IF;
385 ELSIF p_attr_code =('REVISION_CHANGE_DATE') THEN
386   IF NVL(p_record.REVISION_CHANGE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
387   RETURN p_record.REVISION_CHANGE_DATE;
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 =('SALES_DOCUMENT_NAME') THEN
398   IF NVL(p_record.SALES_DOCUMENT_NAME, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
399   RETURN p_record.SALES_DOCUMENT_NAME;
400   ELSE
401   RETURN NULL; 
402   END IF;
403 ELSIF p_attr_code =('SHIPPING_INSTRUCTIONS') THEN
404   IF NVL(p_record.SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
405   RETURN p_record.SHIPPING_INSTRUCTIONS;
406   ELSE
407   RETURN NULL; 
408   END IF;
409 ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
410   IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
411   RETURN p_record.SHIPPING_METHOD_CODE;
412   ELSE
413   RETURN NULL; 
414   END IF;
415 ELSIF p_attr_code =('SHIP_FROM_ORG_ID') THEN
416   IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
417   RETURN p_record.SHIP_FROM_ORG_ID;
418   ELSE
419   RETURN NULL; 
420   END IF;
421 ELSIF p_attr_code =('SHIP_TO_ORG_ID') THEN
422   IF NVL(p_record.SHIP_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
423   RETURN p_record.SHIP_TO_ORG_ID;
424   ELSE
425   RETURN NULL; 
426   END IF;
427 ELSIF p_attr_code =('SOLD_TO_CONTACT_ID') THEN
428   IF NVL(p_record.SOLD_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
429   RETURN p_record.SOLD_TO_CONTACT_ID;
430   ELSE
431   RETURN NULL; 
432   END IF;
433 ELSIF p_attr_code =('SOLD_TO_ORG_ID') THEN
434   IF NVL(p_record.SOLD_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
435   RETURN p_record.SOLD_TO_ORG_ID;
436   ELSE
437   RETURN NULL; 
438   END IF;
439 ELSIF p_attr_code =('SOLD_TO_SITE_USE_ID') THEN
440   IF NVL(p_record.SOLD_TO_SITE_USE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
441   RETURN p_record.SOLD_TO_SITE_USE_ID;
442   ELSE
443   RETURN NULL; 
444   END IF;
445 ELSIF p_attr_code =('SOURCE_DOCUMENT_TYPE_ID') THEN
446   IF NVL(p_record.SOURCE_DOCUMENT_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
447   RETURN p_record.SOURCE_DOCUMENT_TYPE_ID;
448   ELSE
449   RETURN NULL; 
450   END IF;
451 ELSIF p_attr_code =('SOURCE_DOCUMENT_VERSION_NUMBER') THEN
452   IF NVL(p_record.SOURCE_DOCUMENT_VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
453   RETURN p_record.SOURCE_DOCUMENT_VERSION_NUMBER;
454   ELSE
455   RETURN NULL; 
456   END IF;
457 ELSIF p_attr_code =('START_DATE_ACTIVE') THEN
458   IF NVL(p_record.START_DATE_ACTIVE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
459   RETURN p_record.START_DATE_ACTIVE;
460   ELSE
461   RETURN NULL; 
462   END IF;
463 ELSIF p_attr_code =('SUPPLIER_SIGNATURE') THEN
464   IF NVL(p_record.SUPPLIER_SIGNATURE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
465   RETURN p_record.SUPPLIER_SIGNATURE;
466   ELSE
467   RETURN NULL; 
468   END IF;
469 ELSIF p_attr_code =('SUPPLIER_SIGNATURE_DATE') THEN
470   IF NVL(p_record.SUPPLIER_SIGNATURE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
471   RETURN p_record.SUPPLIER_SIGNATURE_DATE;
472   ELSE
473   RETURN NULL; 
474   END IF;
475 ELSIF p_attr_code =('TRANSACTIONAL_CURR_CODE') THEN
479   RETURN NULL; 
476   IF NVL(p_record.TRANSACTIONAL_CURR_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
477   RETURN p_record.TRANSACTIONAL_CURR_CODE;
478   ELSE
480   END IF;
481 ELSIF p_attr_code =('TRANSACTION_PHASE_CODE') THEN
482   IF NVL(p_record.TRANSACTION_PHASE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
483   RETURN p_record.TRANSACTION_PHASE_CODE;
484   ELSE
485   RETURN NULL; 
486   END IF;
487 ELSIF p_attr_code =('USER_STATUS_CODE') THEN
488   IF NVL(p_record.USER_STATUS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
489   RETURN p_record.USER_STATUS_CODE;
490   ELSE
491   RETURN NULL; 
492   END IF;
493 ELSIF p_attr_code =('VERSION_NUMBER') THEN
494   IF NVL(p_record.VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
495   RETURN p_record.VERSION_NUMBER;
496   ELSE
497   RETURN NULL; 
498   END IF;
499 ELSE
500 RETURN NULL; 
501 END IF;
502 END  Get_Attr_Val_Varchar2;
503  
504  
505 FUNCTION Get_Attr_Val_Date
506 (   p_attr_code                     IN  VARCHAR2
507 ,   p_record                        IN  OE_AK_BLANKET_HEADERS_V%ROWTYPE 
508 ) RETURN DATE
509 IS
510 BEGIN
511  
512 IF p_attr_code =('CUSTOMER_SIGNATURE_DATE') THEN
513     IF NVL(p_record.CUSTOMER_SIGNATURE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
514     RETURN p_record.CUSTOMER_SIGNATURE_DATE;
515     ELSE
516     RETURN NULL; 
517     END IF;
518 ELSIF p_attr_code =('END_DATE_ACTIVE') THEN
519     IF NVL(p_record.END_DATE_ACTIVE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
520     RETURN p_record.END_DATE_ACTIVE;
521     ELSE
522     RETURN NULL; 
523     END IF;
524 ELSIF p_attr_code =('QUOTE_DATE') THEN
525     IF NVL(p_record.QUOTE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
526     RETURN p_record.QUOTE_DATE;
527     ELSE
528     RETURN NULL; 
529     END IF;
530 ELSIF p_attr_code =('REVISION_CHANGE_DATE') THEN
531     IF NVL(p_record.REVISION_CHANGE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
532     RETURN p_record.REVISION_CHANGE_DATE;
533     ELSE
534     RETURN NULL; 
535     END IF;
536 ELSIF p_attr_code =('START_DATE_ACTIVE') THEN
537     IF NVL(p_record.START_DATE_ACTIVE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
538     RETURN p_record.START_DATE_ACTIVE;
539     ELSE
540     RETURN NULL; 
541     END IF;
542 ELSIF p_attr_code =('SUPPLIER_SIGNATURE_DATE') THEN
543     IF NVL(p_record.SUPPLIER_SIGNATURE_DATE, FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE THEN
544     RETURN p_record.SUPPLIER_SIGNATURE_DATE;
545     ELSE
546     RETURN NULL; 
547     END IF;
548 ELSIF p_attr_code =('ACCOUNTING_RULE_ID') THEN
549     IF NVL(p_record.ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
550     RETURN to_date(p_record.ACCOUNTING_RULE_ID,'RRRR/MM/DD HH24:MI:SS');
551     ELSE
552     RETURN NULL; 
553     END IF;
554 ELSIF p_attr_code =('ATTRIBUTE1') THEN
555     IF NVL(p_record.ATTRIBUTE1, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
556     RETURN to_date(p_record.ATTRIBUTE1,'RRRR/MM/DD HH24:MI:SS');
557     ELSE
558     RETURN NULL; 
559     END IF;
560 ELSIF p_attr_code =('ATTRIBUTE10') THEN
561     IF NVL(p_record.ATTRIBUTE10, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
562     RETURN to_date(p_record.ATTRIBUTE10,'RRRR/MM/DD HH24:MI:SS');
563     ELSE
564     RETURN NULL; 
565     END IF;
566 ELSIF p_attr_code =('ATTRIBUTE11') THEN
567     IF NVL(p_record.ATTRIBUTE11, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
568     RETURN to_date(p_record.ATTRIBUTE11,'RRRR/MM/DD HH24:MI:SS');
569     ELSE
570     RETURN NULL; 
571     END IF;
572 ELSIF p_attr_code =('ATTRIBUTE12') THEN
573     IF NVL(p_record.ATTRIBUTE12, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
574     RETURN to_date(p_record.ATTRIBUTE12,'RRRR/MM/DD HH24:MI:SS');
575     ELSE
576     RETURN NULL; 
577     END IF;
578 ELSIF p_attr_code =('ATTRIBUTE13') THEN
579     IF NVL(p_record.ATTRIBUTE13, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
580     RETURN to_date(p_record.ATTRIBUTE13,'RRRR/MM/DD HH24:MI:SS');
581     ELSE
582     RETURN NULL; 
583     END IF;
584 ELSIF p_attr_code =('ATTRIBUTE14') THEN
585     IF NVL(p_record.ATTRIBUTE14, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
586     RETURN to_date(p_record.ATTRIBUTE14,'RRRR/MM/DD HH24:MI:SS');
587     ELSE
588     RETURN NULL; 
589     END IF;
590 ELSIF p_attr_code =('ATTRIBUTE15') THEN
591     IF NVL(p_record.ATTRIBUTE15, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
592     RETURN to_date(p_record.ATTRIBUTE15,'RRRR/MM/DD HH24:MI:SS');
593     ELSE
594     RETURN NULL; 
595     END IF;
596 ELSIF p_attr_code =('ATTRIBUTE16') THEN
597     IF NVL(p_record.ATTRIBUTE16, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
598     RETURN to_date(p_record.ATTRIBUTE16,'RRRR/MM/DD HH24:MI:SS');
599     ELSE
600     RETURN NULL; 
601     END IF;
602 ELSIF p_attr_code =('ATTRIBUTE17') THEN
603     IF NVL(p_record.ATTRIBUTE17, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
604     RETURN to_date(p_record.ATTRIBUTE17,'RRRR/MM/DD HH24:MI:SS');
605     ELSE
606     RETURN NULL; 
607     END IF;
608 ELSIF p_attr_code =('ATTRIBUTE18') THEN
609     IF NVL(p_record.ATTRIBUTE18, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
610     RETURN to_date(p_record.ATTRIBUTE18,'RRRR/MM/DD HH24:MI:SS');
611     ELSE
612     RETURN NULL; 
613     END IF;
614 ELSIF p_attr_code =('ATTRIBUTE19') THEN
615     IF NVL(p_record.ATTRIBUTE19, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
619     END IF;
616     RETURN to_date(p_record.ATTRIBUTE19,'RRRR/MM/DD HH24:MI:SS');
617     ELSE
618     RETURN NULL; 
620 ELSIF p_attr_code =('ATTRIBUTE2') THEN
621     IF NVL(p_record.ATTRIBUTE2, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
622     RETURN to_date(p_record.ATTRIBUTE2,'RRRR/MM/DD HH24:MI:SS');
623     ELSE
624     RETURN NULL; 
625     END IF;
626 ELSIF p_attr_code =('ATTRIBUTE20') THEN
627     IF NVL(p_record.ATTRIBUTE20, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
628     RETURN to_date(p_record.ATTRIBUTE20,'RRRR/MM/DD HH24:MI:SS');
629     ELSE
630     RETURN NULL; 
631     END IF;
632 ELSIF p_attr_code =('ATTRIBUTE3') THEN
633     IF NVL(p_record.ATTRIBUTE3, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
634     RETURN to_date(p_record.ATTRIBUTE3,'RRRR/MM/DD HH24:MI:SS');
635     ELSE
636     RETURN NULL; 
637     END IF;
638 ELSIF p_attr_code =('ATTRIBUTE4') THEN
639     IF NVL(p_record.ATTRIBUTE4, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
640     RETURN to_date(p_record.ATTRIBUTE4,'RRRR/MM/DD HH24:MI:SS');
641     ELSE
642     RETURN NULL; 
643     END IF;
644 ELSIF p_attr_code =('ATTRIBUTE5') THEN
645     IF NVL(p_record.ATTRIBUTE5, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
646     RETURN to_date(p_record.ATTRIBUTE5,'RRRR/MM/DD HH24:MI:SS');
647     ELSE
648     RETURN NULL; 
649     END IF;
650 ELSIF p_attr_code =('ATTRIBUTE6') THEN
651     IF NVL(p_record.ATTRIBUTE6, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
652     RETURN to_date(p_record.ATTRIBUTE6,'RRRR/MM/DD HH24:MI:SS');
653     ELSE
654     RETURN NULL; 
655     END IF;
656 ELSIF p_attr_code =('ATTRIBUTE7') THEN
657     IF NVL(p_record.ATTRIBUTE7, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
658     RETURN to_date(p_record.ATTRIBUTE7,'RRRR/MM/DD HH24:MI:SS');
659     ELSE
660     RETURN NULL; 
661     END IF;
662 ELSIF p_attr_code =('ATTRIBUTE8') THEN
663     IF NVL(p_record.ATTRIBUTE8, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
664     RETURN to_date(p_record.ATTRIBUTE8,'RRRR/MM/DD HH24:MI:SS');
665     ELSE
666     RETURN NULL; 
667     END IF;
668 ELSIF p_attr_code =('ATTRIBUTE9') THEN
669     IF NVL(p_record.ATTRIBUTE9, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
670     RETURN to_date(p_record.ATTRIBUTE9,'RRRR/MM/DD HH24:MI:SS');
671     ELSE
672     RETURN NULL; 
673     END IF;
674 ELSIF p_attr_code =('BLANKET_MAX_AMOUNT') THEN
675     IF NVL(p_record.BLANKET_MAX_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
676     RETURN to_date(p_record.BLANKET_MAX_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
677     ELSE
678     RETURN NULL; 
679     END IF;
680 ELSIF p_attr_code =('BLANKET_MIN_AMOUNT') THEN
681     IF NVL(p_record.BLANKET_MIN_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
682     RETURN to_date(p_record.BLANKET_MIN_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
683     ELSE
684     RETURN NULL; 
685     END IF;
686 ELSIF p_attr_code =('CONTEXT') THEN
687     IF NVL(p_record.CONTEXT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
688     RETURN to_date(p_record.CONTEXT,'RRRR/MM/DD HH24:MI:SS');
689     ELSE
690     RETURN NULL; 
691     END IF;
692 ELSIF p_attr_code =('CONTRACT_TERMS') THEN
693     IF NVL(p_record.CONTRACT_TERMS, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
694     RETURN to_date(p_record.CONTRACT_TERMS,'RRRR/MM/DD HH24:MI:SS');
695     ELSE
696     RETURN NULL; 
697     END IF;
698 ELSIF p_attr_code =('CONVERSION_TYPE_CODE') THEN
699     IF NVL(p_record.CONVERSION_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
700     RETURN to_date(p_record.CONVERSION_TYPE_CODE,'RRRR/MM/DD HH24:MI:SS');
701     ELSE
702     RETURN NULL; 
703     END IF;
704 ELSIF p_attr_code =('CUSTOMER_SIGNATURE') THEN
705     IF NVL(p_record.CUSTOMER_SIGNATURE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
706     RETURN to_date(p_record.CUSTOMER_SIGNATURE,'RRRR/MM/DD HH24:MI:SS');
707     ELSE
708     RETURN NULL; 
709     END IF;
710 ELSIF p_attr_code =('CUST_PO_NUMBER') THEN
711     IF NVL(p_record.CUST_PO_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
712     RETURN to_date(p_record.CUST_PO_NUMBER,'RRRR/MM/DD HH24:MI:SS');
713     ELSE
714     RETURN NULL; 
715     END IF;
716 ELSIF p_attr_code =('DEFAULT_DISCOUNT_AMOUNT') THEN
717     IF NVL(p_record.DEFAULT_DISCOUNT_AMOUNT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
718     RETURN to_date(p_record.DEFAULT_DISCOUNT_AMOUNT,'RRRR/MM/DD HH24:MI:SS');
719     ELSE
720     RETURN NULL; 
721     END IF;
722 ELSIF p_attr_code =('DEFAULT_DISCOUNT_PERCENT') THEN
723     IF NVL(p_record.DEFAULT_DISCOUNT_PERCENT, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
724     RETURN to_date(p_record.DEFAULT_DISCOUNT_PERCENT,'RRRR/MM/DD HH24:MI:SS');
725     ELSE
726     RETURN NULL; 
727     END IF;
728 ELSIF p_attr_code =('DELIVER_TO_ORG_ID') THEN
729     IF NVL(p_record.DELIVER_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
730     RETURN to_date(p_record.DELIVER_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
731     ELSE
732     RETURN NULL; 
733     END IF;
734 ELSIF p_attr_code =('DRAFT_SUBMITTED_FLAG') THEN
735     IF NVL(p_record.DRAFT_SUBMITTED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
736     RETURN to_date(p_record.DRAFT_SUBMITTED_FLAG,'RRRR/MM/DD HH24:MI:SS');
737     ELSE
738     RETURN NULL; 
739     END IF;
740 ELSIF p_attr_code =('ENFORCE_ACCOUNTING_RULE_FLAG') THEN
741     IF NVL(p_record.ENFORCE_ACCOUNTING_RULE_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
742     RETURN to_date(p_record.ENFORCE_ACCOUNTING_RULE_FLAG,'RRRR/MM/DD HH24:MI:SS');
743     ELSE
744     RETURN NULL; 
745     END IF;
746 ELSIF p_attr_code =('ENFORCE_FREIGHT_TERM_FLAG') THEN
750     RETURN NULL; 
747     IF NVL(p_record.ENFORCE_FREIGHT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
748     RETURN to_date(p_record.ENFORCE_FREIGHT_TERM_FLAG,'RRRR/MM/DD HH24:MI:SS');
749     ELSE
751     END IF;
752 ELSIF p_attr_code =('ENFORCE_INVOICE_TO_FLAG') THEN
753     IF NVL(p_record.ENFORCE_INVOICE_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
754     RETURN to_date(p_record.ENFORCE_INVOICE_TO_FLAG,'RRRR/MM/DD HH24:MI:SS');
755     ELSE
756     RETURN NULL; 
757     END IF;
758 ELSIF p_attr_code =('ENFORCE_INVOICING_RULE_FLAG') THEN
759     IF NVL(p_record.ENFORCE_INVOICING_RULE_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
760     RETURN to_date(p_record.ENFORCE_INVOICING_RULE_FLAG,'RRRR/MM/DD HH24:MI:SS');
761     ELSE
762     RETURN NULL; 
763     END IF;
764 ELSIF p_attr_code =('ENFORCE_PAYMENT_TERM_FLAG') THEN
765     IF NVL(p_record.ENFORCE_PAYMENT_TERM_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
766     RETURN to_date(p_record.ENFORCE_PAYMENT_TERM_FLAG,'RRRR/MM/DD HH24:MI:SS');
767     ELSE
768     RETURN NULL; 
769     END IF;
770 ELSIF p_attr_code =('ENFORCE_PRICE_LIST_FLAG') THEN
771     IF NVL(p_record.ENFORCE_PRICE_LIST_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
772     RETURN to_date(p_record.ENFORCE_PRICE_LIST_FLAG,'RRRR/MM/DD HH24:MI:SS');
773     ELSE
774     RETURN NULL; 
775     END IF;
776 ELSIF p_attr_code =('ENFORCE_SHIPPING_METHOD_FLAG') THEN
777     IF NVL(p_record.ENFORCE_SHIPPING_METHOD_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
778     RETURN to_date(p_record.ENFORCE_SHIPPING_METHOD_FLAG,'RRRR/MM/DD HH24:MI:SS');
779     ELSE
780     RETURN NULL; 
781     END IF;
782 ELSIF p_attr_code =('ENFORCE_SHIP_TO_FLAG') THEN
783     IF NVL(p_record.ENFORCE_SHIP_TO_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
784     RETURN to_date(p_record.ENFORCE_SHIP_TO_FLAG,'RRRR/MM/DD HH24:MI:SS');
785     ELSE
786     RETURN NULL; 
787     END IF;
788 ELSIF p_attr_code =('FLOW_STATUS_CODE') THEN
789     IF NVL(p_record.FLOW_STATUS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
790     RETURN to_date(p_record.FLOW_STATUS_CODE,'RRRR/MM/DD HH24:MI:SS');
791     ELSE
792     RETURN NULL; 
793     END IF;
794 ELSIF p_attr_code =('FREIGHT_TERMS_CODE') THEN
795     IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
796     RETURN to_date(p_record.FREIGHT_TERMS_CODE,'RRRR/MM/DD HH24:MI:SS');
797     ELSE
798     RETURN NULL; 
799     END IF;
800 ELSIF p_attr_code =('INVOICE_TO_ORG_ID') THEN
801     IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
802     RETURN to_date(p_record.INVOICE_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
803     ELSE
804     RETURN NULL; 
805     END IF;
806 ELSIF p_attr_code =('INVOICING_RULE_ID') THEN
807     IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
808     RETURN to_date(p_record.INVOICING_RULE_ID,'RRRR/MM/DD HH24:MI:SS');
809     ELSE
810     RETURN NULL; 
811     END IF;
812 ELSIF p_attr_code =('NEW_MODIFIER_LIST_ID') THEN
813     IF NVL(p_record.NEW_MODIFIER_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
814     RETURN to_date(p_record.NEW_MODIFIER_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
815     ELSE
816     RETURN NULL; 
817     END IF;
818 ELSIF p_attr_code =('NEW_PRICE_LIST_ID') THEN
819     IF NVL(p_record.NEW_PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
820     RETURN to_date(p_record.NEW_PRICE_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
821     ELSE
822     RETURN NULL; 
823     END IF;
824 ELSIF p_attr_code =('ON_HOLD_FLAG') THEN
825     IF NVL(p_record.ON_HOLD_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
826     RETURN to_date(p_record.ON_HOLD_FLAG,'RRRR/MM/DD HH24:MI:SS');
827     ELSE
828     RETURN NULL; 
829     END IF;
830 ELSIF p_attr_code =('OPEN_FLAG') THEN
831     IF NVL(p_record.OPEN_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
832     RETURN to_date(p_record.OPEN_FLAG,'RRRR/MM/DD HH24:MI:SS');
833     ELSE
834     RETURN NULL; 
835     END IF;
836 ELSIF p_attr_code =('ORDER_NUMBER') THEN
837     IF NVL(p_record.ORDER_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
838     RETURN to_date(p_record.ORDER_NUMBER,'RRRR/MM/DD HH24:MI:SS');
839     ELSE
840     RETURN NULL; 
841     END IF;
842 ELSIF p_attr_code =('ORDER_TYPE_ID') THEN
843     IF NVL(p_record.ORDER_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
844     RETURN to_date(p_record.ORDER_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
845     ELSE
846     RETURN NULL; 
847     END IF;
848 ELSIF p_attr_code =('OVERRIDE_AMOUNT_FLAG') THEN
849     IF NVL(p_record.OVERRIDE_AMOUNT_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
850     RETURN to_date(p_record.OVERRIDE_AMOUNT_FLAG,'RRRR/MM/DD HH24:MI:SS');
851     ELSE
852     RETURN NULL; 
853     END IF;
854 ELSIF p_attr_code =('PACKING_INSTRUCTIONS') THEN
855     IF NVL(p_record.PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
856     RETURN to_date(p_record.PACKING_INSTRUCTIONS,'RRRR/MM/DD HH24:MI:SS');
857     ELSE
858     RETURN NULL; 
859     END IF;
860 ELSIF p_attr_code =('PAYMENT_TERM_ID') THEN
861     IF NVL(p_record.PAYMENT_TERM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
862     RETURN to_date(p_record.PAYMENT_TERM_ID,'RRRR/MM/DD HH24:MI:SS');
863     ELSE
864     RETURN NULL; 
865     END IF;
866 ELSIF p_attr_code =('PRICE_LIST_ID') THEN
867     IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
868     RETURN to_date(p_record.PRICE_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
872 ELSIF p_attr_code =('QUOTE_NUMBER') THEN
869     ELSE
870     RETURN NULL; 
871     END IF;
873     IF NVL(p_record.QUOTE_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
874     RETURN to_date(p_record.QUOTE_NUMBER,'RRRR/MM/DD HH24:MI:SS');
875     ELSE
876     RETURN NULL; 
877     END IF;
878 ELSIF p_attr_code =('SALESREP_ID') THEN
879     IF NVL(p_record.SALESREP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
880     RETURN to_date(p_record.SALESREP_ID,'RRRR/MM/DD HH24:MI:SS');
881     ELSE
882     RETURN NULL; 
883     END IF;
884 ELSIF p_attr_code =('SALES_DOCUMENT_NAME') THEN
885     IF NVL(p_record.SALES_DOCUMENT_NAME, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
886     RETURN to_date(p_record.SALES_DOCUMENT_NAME,'RRRR/MM/DD HH24:MI:SS');
887     ELSE
888     RETURN NULL; 
889     END IF;
890 ELSIF p_attr_code =('SHIPPING_INSTRUCTIONS') THEN
891     IF NVL(p_record.SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
892     RETURN to_date(p_record.SHIPPING_INSTRUCTIONS,'RRRR/MM/DD HH24:MI:SS');
893     ELSE
894     RETURN NULL; 
895     END IF;
896 ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
897     IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
898     RETURN to_date(p_record.SHIPPING_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
899     ELSE
900     RETURN NULL; 
901     END IF;
902 ELSIF p_attr_code =('SHIP_FROM_ORG_ID') THEN
903     IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
904     RETURN to_date(p_record.SHIP_FROM_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
905     ELSE
906     RETURN NULL; 
907     END IF;
908 ELSIF p_attr_code =('SHIP_TO_ORG_ID') THEN
909     IF NVL(p_record.SHIP_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
910     RETURN to_date(p_record.SHIP_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
911     ELSE
912     RETURN NULL; 
913     END IF;
914 ELSIF p_attr_code =('SOLD_TO_CONTACT_ID') THEN
915     IF NVL(p_record.SOLD_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
916     RETURN to_date(p_record.SOLD_TO_CONTACT_ID,'RRRR/MM/DD HH24:MI:SS');
917     ELSE
918     RETURN NULL; 
919     END IF;
920 ELSIF p_attr_code =('SOLD_TO_ORG_ID') THEN
921     IF NVL(p_record.SOLD_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
922     RETURN to_date(p_record.SOLD_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
923     ELSE
924     RETURN NULL; 
925     END IF;
926 ELSIF p_attr_code =('SOLD_TO_SITE_USE_ID') THEN
927     IF NVL(p_record.SOLD_TO_SITE_USE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
928     RETURN to_date(p_record.SOLD_TO_SITE_USE_ID,'RRRR/MM/DD HH24:MI:SS');
929     ELSE
930     RETURN NULL; 
931     END IF;
932 ELSIF p_attr_code =('SOURCE_DOCUMENT_TYPE_ID') THEN
933     IF NVL(p_record.SOURCE_DOCUMENT_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
934     RETURN to_date(p_record.SOURCE_DOCUMENT_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
935     ELSE
936     RETURN NULL; 
937     END IF;
938 ELSIF p_attr_code =('SOURCE_DOCUMENT_VERSION_NUMBER') THEN
939     IF NVL(p_record.SOURCE_DOCUMENT_VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
940     RETURN to_date(p_record.SOURCE_DOCUMENT_VERSION_NUMBER,'RRRR/MM/DD HH24:MI:SS');
941     ELSE
942     RETURN NULL; 
943     END IF;
944 ELSIF p_attr_code =('SUPPLIER_SIGNATURE') THEN
945     IF NVL(p_record.SUPPLIER_SIGNATURE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
946     RETURN to_date(p_record.SUPPLIER_SIGNATURE,'RRRR/MM/DD HH24:MI:SS');
947     ELSE
948     RETURN NULL; 
949     END IF;
950 ELSIF p_attr_code =('TRANSACTIONAL_CURR_CODE') THEN
951     IF NVL(p_record.TRANSACTIONAL_CURR_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
952     RETURN to_date(p_record.TRANSACTIONAL_CURR_CODE,'RRRR/MM/DD HH24:MI:SS');
953     ELSE
954     RETURN NULL; 
955     END IF;
956 ELSIF p_attr_code =('TRANSACTION_PHASE_CODE') THEN
957     IF NVL(p_record.TRANSACTION_PHASE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
958     RETURN to_date(p_record.TRANSACTION_PHASE_CODE,'RRRR/MM/DD HH24:MI:SS');
959     ELSE
960     RETURN NULL; 
961     END IF;
962 ELSIF p_attr_code =('USER_STATUS_CODE') THEN
963     IF NVL(p_record.USER_STATUS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
964     RETURN to_date(p_record.USER_STATUS_CODE,'RRRR/MM/DD HH24:MI:SS');
965     ELSE
966     RETURN NULL; 
967     END IF;
968 ELSIF p_attr_code =('VERSION_NUMBER') THEN
969     IF NVL(p_record.VERSION_NUMBER, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
970     RETURN to_date(p_record.VERSION_NUMBER,'RRRR/MM/DD HH24:MI:SS');
971     ELSE
972     RETURN NULL; 
973     END IF;
974 ELSE
975 RETURN NULL; 
976 END IF;
977  
978 END  Get_Attr_Val_Date;
979  
980  
981   PROCEDURE Clear_BLANKET_HEADER_Cache
982   IS  
983   BEGIN  
984   g_cached_record.ORDER_NUMBER := null;
985    END Clear_BLANKET_HEADER_Cache;
986  
987  
988 FUNCTION Sync_BLANKET_HEADER_Cache
989 (   p_ORDER_NUMBER                  IN  NUMBER
990  
991  
992 ) RETURN NUMBER
993 IS
994 CURSOR cache IS 
995   SELECT * FROM   OE_AK_BLANKET_HEADERS_V
996   WHERE ORDER_NUMBER  = p_ORDER_NUMBER
997   ;
998 BEGIN
999  
1000 IF (NVL(p_ORDER_NUMBER,FND_API.G_MISS_NUM)  = FND_API.G_MISS_NUM) 
1001 THEN
1002   RETURN 0 ;
1003 ELSIF (NVL(g_cached_record.ORDER_NUMBER,FND_API.G_MISS_NUM)  <>  p_ORDER_NUMBER) 
1004 THEN
1005   Clear_BLANKET_HEADER_Cache;
1006   Open cache;
1007   FETCH cache into g_cached_record;
1008   IF cache%NOTFOUND THEN
1009     RETURN 0;
1010   END IF;
1011   Close cache;
1012   RETURN 1 ;
1013 END IF;
1014  
1015   RETURN 1 ;
1016 EXCEPTION
1017   WHEN OTHERS THEN 
1018   RETURN 0 ;
1019 END Sync_BLANKET_HEADER_Cache;
1020  
1021  
1022 END ONT_BLANKET_HEADER_Def_Util;