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_ORDER_TYPE_DEF_UTIL

Source


1 PACKAGE BODY ONT_ORDER_TYPE_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_ORDER_TYPE_Def_Util
11 --  
12 --  DESCRIPTION
13 --  
14 --      Body of package ONT_ORDER_TYPE_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_ORDER_TYPE_Def_Util';
25  
26  
27   g_database_object_name varchar2(30) :='OE_AK_ORDER_TYPES_V';
28  
29  
30 FUNCTION Get_Attr_Val_Varchar2
31 (   p_attr_code                     IN  VARCHAR2
32 ,   p_record                        IN  OE_AK_ORDER_TYPES_V%ROWTYPE 
33 ) RETURN VARCHAR2
34 IS
35 BEGIN
36  
37 IF p_attr_code =('ACCOUNTING_CREDIT_METHOD_CODE') THEN
38   IF NVL(p_record.ACCOUNTING_CREDIT_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
39   RETURN p_record.ACCOUNTING_CREDIT_METHOD_CODE;
40   ELSE
41   RETURN NULL; 
42   END IF;
43 ELSIF p_attr_code =('ACCOUNTING_RULE_ID') THEN
44   IF NVL(p_record.ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
45   RETURN p_record.ACCOUNTING_RULE_ID;
46   ELSE
47   RETURN NULL; 
48   END IF;
49 ELSIF p_attr_code =('AGREEMENT_TYPE_CODE') THEN
50   IF NVL(p_record.AGREEMENT_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
51   RETURN p_record.AGREEMENT_TYPE_CODE;
52   ELSE
53   RETURN NULL; 
54   END IF;
55 ELSIF p_attr_code =('CONVERSION_TYPE_CODE') THEN
56   IF NVL(p_record.CONVERSION_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
57   RETURN p_record.CONVERSION_TYPE_CODE;
58   ELSE
59   RETURN NULL; 
60   END IF;
61 ELSIF p_attr_code =('COST_OF_GOODS_SOLD_ACCOUNT') THEN
62   IF NVL(p_record.COST_OF_GOODS_SOLD_ACCOUNT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
63   RETURN p_record.COST_OF_GOODS_SOLD_ACCOUNT;
64   ELSE
65   RETURN NULL; 
66   END IF;
67 ELSIF p_attr_code =('CUST_TRXN_TYPE_ID') THEN
68   IF NVL(p_record.CUST_TRX_TYPE_ID, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
69   RETURN p_record.CUST_TRX_TYPE_ID;
70   ELSE
71   RETURN NULL; 
72   END IF;
73 ELSIF p_attr_code =('DEFAULT_FULFILLMENT_SET') THEN
74   IF NVL(p_record.DEFAULT_FULFILLMENT_SET, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
75   RETURN p_record.DEFAULT_FULFILLMENT_SET;
76   ELSE
77   RETURN NULL; 
78   END IF;
79 ELSIF p_attr_code =('DEFAULT_INBOUND_LINE_TYPE_ID') THEN
80   IF NVL(p_record.DEFAULT_INBOUND_LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
84   END IF;
81   RETURN p_record.DEFAULT_INBOUND_LINE_TYPE_ID;
82   ELSE
83   RETURN NULL; 
85 ELSIF p_attr_code =('DEFAULT_LINE_SET') THEN
86   IF NVL(p_record.DEFAULT_LINE_SET_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
87   RETURN p_record.DEFAULT_LINE_SET_CODE;
88   ELSE
89   RETURN NULL; 
90   END IF;
91 ELSIF p_attr_code =('DEFAULT_OUTBOUND_LINE_TYPE_ID') THEN
92   IF NVL(p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
93   RETURN p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID;
94   ELSE
95   RETURN NULL; 
96   END IF;
97 ELSIF p_attr_code =('DEF_TRANSACTION_PHASE_CODE') THEN
98   IF NVL(p_record.DEF_TRANSACTION_PHASE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
99   RETURN p_record.DEF_TRANSACTION_PHASE_CODE;
100   ELSE
101   RETURN NULL; 
102   END IF;
103 ELSIF p_attr_code =('DEMAND_CLASS_CODE') THEN
104   IF NVL(p_record.DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
105   RETURN p_record.DEMAND_CLASS_CODE;
106   ELSE
107   RETURN NULL; 
108   END IF;
109 ELSIF p_attr_code =('FOB_POINT_CODE') THEN
110   IF NVL(p_record.FOB_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
111   RETURN p_record.FOB_POINT_CODE;
112   ELSE
113   RETURN NULL; 
114   END IF;
115 ELSIF p_attr_code =('FREIGHT_TERMS_CODE') THEN
116   IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
117   RETURN p_record.FREIGHT_TERMS_CODE;
118   ELSE
119   RETURN NULL; 
120   END IF;
121 ELSIF p_attr_code =('INVOICE_SOURCE_ID') THEN
122   IF NVL(p_record.INVOICE_SOURCE_ID, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
123   RETURN p_record.INVOICE_SOURCE_ID;
124   ELSE
125   RETURN NULL; 
126   END IF;
127 ELSIF p_attr_code =('INVOICING_CREDIT_METHOD_CODE') THEN
128   IF NVL(p_record.INVOICING_CREDIT_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
129   RETURN p_record.INVOICING_CREDIT_METHOD_CODE;
130   ELSE
131   RETURN NULL; 
132   END IF;
133 ELSIF p_attr_code =('INVOICING_RULE_ID') THEN
134   IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
135   RETURN p_record.INVOICING_RULE_ID;
136   ELSE
137   RETURN NULL; 
138   END IF;
139 ELSIF p_attr_code =('NON_DELIVERY_INVOICE_SOURCE_ID') THEN
140   IF NVL(p_record.NON_DELIVERY_INVOICE_SOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
141   RETURN p_record.NON_DELIVERY_INVOICE_SOURCE_ID;
142   ELSE
143   RETURN NULL; 
144   END IF;
145 ELSIF p_attr_code =('OERDER_NUMBER_SOURCE_ID') THEN
146   IF NVL(p_record.ORDER_NUMBER_SOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
147   RETURN p_record.ORDER_NUMBER_SOURCE_ID;
148   ELSE
149   RETURN NULL; 
150   END IF;
151 ELSIF p_attr_code =('ORDER_CATEGORY_CODE') THEN
152   IF NVL(p_record.ORDER_CATEGORY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
153   RETURN p_record.ORDER_CATEGORY_CODE;
154   ELSE
155   RETURN NULL; 
156   END IF;
157 ELSIF p_attr_code =('ORDER_TYPE_ID') THEN
158   IF NVL(p_record.ORDER_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
159   RETURN p_record.ORDER_TYPE_ID;
160   ELSE
161   RETURN NULL; 
162   END IF;
163 ELSIF p_attr_code =('PRICE_LIST_ID') THEN
164   IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
165   RETURN p_record.PRICE_LIST_ID;
166   ELSE
167   RETURN NULL; 
168   END IF;
169 ELSIF p_attr_code =('SCHEDULING_LEVEL_CODE') THEN
170   IF NVL(p_record.SCHEDULING_LEVEL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
171   RETURN p_record.SCHEDULING_LEVEL_CODE;
172   ELSE
173   RETURN NULL; 
174   END IF;
175 ELSIF p_attr_code =('SHIPMENT_PRIORITY_CODE') THEN
176   IF NVL(p_record.SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
177   RETURN p_record.SHIPMENT_PRIORITY_CODE;
178   ELSE
179   RETURN NULL; 
180   END IF;
181 ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
182   IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
183   RETURN p_record.SHIPPING_METHOD_CODE;
184   ELSE
185   RETURN NULL; 
186   END IF;
187 ELSIF p_attr_code =('SHIP_FROM_ORG_ID') THEN
188   IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
189   RETURN p_record.SHIP_FROM_ORG_ID;
190   ELSE
191   RETURN NULL; 
192   END IF;
193 ELSIF p_attr_code =('TRANSACTIONAL_CURR_CODE') THEN
194   IF NVL(p_record.CURRENCY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
195   RETURN p_record.CURRENCY_CODE;
196   ELSE
197   RETURN NULL; 
198   END IF;
199 ELSE
200 RETURN NULL; 
201 END IF;
202 END  Get_Attr_Val_Varchar2;
203  
204  
205 FUNCTION Get_Attr_Val_Date
206 (   p_attr_code                     IN  VARCHAR2
207 ,   p_record                        IN  OE_AK_ORDER_TYPES_V%ROWTYPE 
208 ) RETURN DATE
209 IS
210 BEGIN
211  
212 IF p_attr_code =('ACCOUNTING_CREDIT_METHOD_CODE') THEN
213     IF NVL(p_record.ACCOUNTING_CREDIT_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
214     RETURN to_date(p_record.ACCOUNTING_CREDIT_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
215     ELSE
216     RETURN NULL; 
217     END IF;
218 ELSIF p_attr_code =('ACCOUNTING_RULE_ID') THEN
219     IF NVL(p_record.ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
220     RETURN to_date(p_record.ACCOUNTING_RULE_ID,'RRRR/MM/DD HH24:MI:SS');
221     ELSE
222     RETURN NULL; 
223     END IF;
224 ELSIF p_attr_code =('AGREEMENT_TYPE_CODE') THEN
225     IF NVL(p_record.AGREEMENT_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
226     RETURN to_date(p_record.AGREEMENT_TYPE_CODE,'RRRR/MM/DD HH24:MI:SS');
227     ELSE
228     RETURN NULL; 
229     END IF;
230 ELSIF p_attr_code =('CONVERSION_TYPE_CODE') THEN
231     IF NVL(p_record.CONVERSION_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
232     RETURN to_date(p_record.CONVERSION_TYPE_CODE,'RRRR/MM/DD HH24:MI:SS');
233     ELSE
234     RETURN NULL; 
235     END IF;
236 ELSIF p_attr_code =('COST_OF_GOODS_SOLD_ACCOUNT') THEN
237     IF NVL(p_record.COST_OF_GOODS_SOLD_ACCOUNT, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
238     RETURN to_date(p_record.COST_OF_GOODS_SOLD_ACCOUNT,'RRRR/MM/DD HH24:MI:SS');
239     ELSE
240     RETURN NULL; 
241     END IF;
242 ELSIF p_attr_code =('CUST_TRXN_TYPE_ID') THEN
243     IF NVL(p_record.CUST_TRX_TYPE_ID, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
244     RETURN to_date(p_record.CUST_TRX_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
245     ELSE
246     RETURN NULL; 
247     END IF;
248 ELSIF p_attr_code =('DEFAULT_FULFILLMENT_SET') THEN
249     IF NVL(p_record.DEFAULT_FULFILLMENT_SET, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
250     RETURN to_date(p_record.DEFAULT_FULFILLMENT_SET,'RRRR/MM/DD HH24:MI:SS');
251     ELSE
252     RETURN NULL; 
253     END IF;
254 ELSIF p_attr_code =('DEFAULT_INBOUND_LINE_TYPE_ID') THEN
255     IF NVL(p_record.DEFAULT_INBOUND_LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
256     RETURN to_date(p_record.DEFAULT_INBOUND_LINE_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
257     ELSE
258     RETURN NULL; 
259     END IF;
260 ELSIF p_attr_code =('DEFAULT_LINE_SET') THEN
261     IF NVL(p_record.DEFAULT_LINE_SET_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
262     RETURN to_date(p_record.DEFAULT_LINE_SET_CODE,'RRRR/MM/DD HH24:MI:SS');
263     ELSE
264     RETURN NULL; 
265     END IF;
266 ELSIF p_attr_code =('DEFAULT_OUTBOUND_LINE_TYPE_ID') THEN
267     IF NVL(p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
268     RETURN to_date(p_record.DEFAULT_OUTBOUND_LINE_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
269     ELSE
270     RETURN NULL; 
271     END IF;
272 ELSIF p_attr_code =('DEF_TRANSACTION_PHASE_CODE') THEN
273     IF NVL(p_record.DEF_TRANSACTION_PHASE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
274     RETURN to_date(p_record.DEF_TRANSACTION_PHASE_CODE,'RRRR/MM/DD HH24:MI:SS');
275     ELSE
276     RETURN NULL; 
277     END IF;
278 ELSIF p_attr_code =('DEMAND_CLASS_CODE') THEN
279     IF NVL(p_record.DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
280     RETURN to_date(p_record.DEMAND_CLASS_CODE,'RRRR/MM/DD HH24:MI:SS');
281     ELSE
282     RETURN NULL; 
283     END IF;
284 ELSIF p_attr_code =('FOB_POINT_CODE') THEN
285     IF NVL(p_record.FOB_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
286     RETURN to_date(p_record.FOB_POINT_CODE,'RRRR/MM/DD HH24:MI:SS');
287     ELSE
288     RETURN NULL; 
289     END IF;
290 ELSIF p_attr_code =('FREIGHT_TERMS_CODE') THEN
291     IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
292     RETURN to_date(p_record.FREIGHT_TERMS_CODE,'RRRR/MM/DD HH24:MI:SS');
293     ELSE
294     RETURN NULL; 
295     END IF;
296 ELSIF p_attr_code =('INVOICE_SOURCE_ID') THEN
297     IF NVL(p_record.INVOICE_SOURCE_ID, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
298     RETURN to_date(p_record.INVOICE_SOURCE_ID,'RRRR/MM/DD HH24:MI:SS');
299     ELSE
300     RETURN NULL; 
301     END IF;
302 ELSIF p_attr_code =('INVOICING_CREDIT_METHOD_CODE') THEN
303     IF NVL(p_record.INVOICING_CREDIT_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
304     RETURN to_date(p_record.INVOICING_CREDIT_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
305     ELSE
306     RETURN NULL; 
307     END IF;
308 ELSIF p_attr_code =('INVOICING_RULE_ID') THEN
309     IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
310     RETURN to_date(p_record.INVOICING_RULE_ID,'RRRR/MM/DD HH24:MI:SS');
311     ELSE
312     RETURN NULL; 
313     END IF;
314 ELSIF p_attr_code =('NON_DELIVERY_INVOICE_SOURCE_ID') THEN
315     IF NVL(p_record.NON_DELIVERY_INVOICE_SOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
316     RETURN to_date(p_record.NON_DELIVERY_INVOICE_SOURCE_ID,'RRRR/MM/DD HH24:MI:SS');
317     ELSE
318     RETURN NULL; 
319     END IF;
320 ELSIF p_attr_code =('OERDER_NUMBER_SOURCE_ID') THEN
321     IF NVL(p_record.ORDER_NUMBER_SOURCE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
322     RETURN to_date(p_record.ORDER_NUMBER_SOURCE_ID,'RRRR/MM/DD HH24:MI:SS');
323     ELSE
324     RETURN NULL; 
325     END IF;
326 ELSIF p_attr_code =('ORDER_CATEGORY_CODE') THEN
327     IF NVL(p_record.ORDER_CATEGORY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
328     RETURN to_date(p_record.ORDER_CATEGORY_CODE,'RRRR/MM/DD HH24:MI:SS');
329     ELSE
330     RETURN NULL; 
331     END IF;
332 ELSIF p_attr_code =('ORDER_TYPE_ID') THEN
333     IF NVL(p_record.ORDER_TYPE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
334     RETURN to_date(p_record.ORDER_TYPE_ID,'RRRR/MM/DD HH24:MI:SS');
335     ELSE
336     RETURN NULL; 
337     END IF;
338 ELSIF p_attr_code =('PRICE_LIST_ID') THEN
339     IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
340     RETURN to_date(p_record.PRICE_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
341     ELSE
342     RETURN NULL; 
343     END IF;
344 ELSIF p_attr_code =('SCHEDULING_LEVEL_CODE') THEN
345     IF NVL(p_record.SCHEDULING_LEVEL_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
346     RETURN to_date(p_record.SCHEDULING_LEVEL_CODE,'RRRR/MM/DD HH24:MI:SS');
347     ELSE
348     RETURN NULL; 
349     END IF;
350 ELSIF p_attr_code =('SHIPMENT_PRIORITY_CODE') THEN
351     IF NVL(p_record.SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
352     RETURN to_date(p_record.SHIPMENT_PRIORITY_CODE,'RRRR/MM/DD HH24:MI:SS');
353     ELSE
354     RETURN NULL; 
355     END IF;
356 ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
357     IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
358     RETURN to_date(p_record.SHIPPING_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
359     ELSE
360     RETURN NULL; 
361     END IF;
362 ELSIF p_attr_code =('SHIP_FROM_ORG_ID') THEN
363     IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
364     RETURN to_date(p_record.SHIP_FROM_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
365     ELSE
366     RETURN NULL; 
367     END IF;
368 ELSIF p_attr_code =('TRANSACTIONAL_CURR_CODE') THEN
369     IF NVL(p_record.CURRENCY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
370     RETURN to_date(p_record.CURRENCY_CODE,'RRRR/MM/DD HH24:MI:SS');
371     ELSE
372     RETURN NULL; 
373     END IF;
374 ELSE
375 RETURN NULL; 
376 END IF;
377  
378 END  Get_Attr_Val_Date;
379  
380  
381   PROCEDURE Clear_ORDER_TYPE_Cache
382   IS  
383   BEGIN  
384   g_cached_record.ORDER_TYPE_ID := null;
385    END Clear_ORDER_TYPE_Cache;
386  
387  
388 FUNCTION Sync_ORDER_TYPE_Cache
389 (   p_ORDER_TYPE_ID                 IN  NUMBER
390  
391  
392 ) RETURN NUMBER
393 IS
394 CURSOR cache IS 
395   SELECT * FROM   OE_AK_ORDER_TYPES_V
396   WHERE ORDER_TYPE_ID  = p_ORDER_TYPE_ID
397   ;
398 BEGIN
399  
400 IF (NVL(p_ORDER_TYPE_ID,FND_API.G_MISS_NUM)  = FND_API.G_MISS_NUM) 
401 THEN
402   RETURN 0 ;
403 ELSIF (NVL(g_cached_record.ORDER_TYPE_ID,FND_API.G_MISS_NUM)  <>  p_ORDER_TYPE_ID) 
404 THEN
405   Clear_ORDER_TYPE_Cache;
406   Open cache;
407   FETCH cache into g_cached_record;
408   IF cache%NOTFOUND THEN
409     RETURN 0;
410   END IF;
411   Close cache;
412   RETURN 1 ;
413 END IF;
414  
415   RETURN 1 ;
416 EXCEPTION
417   WHEN OTHERS THEN 
418   RETURN 0 ;
419 END Sync_ORDER_TYPE_Cache;
420  
421  
422 END ONT_ORDER_TYPE_Def_Util;