[Home] [Help]
PACKAGE BODY: APPS.ONT_DEL_TO_ORG_DEF_UTIL
Source
1 PACKAGE BODY ONT_DEL_TO_ORG_Def_Util AS
2 /* $Header: OEXDFWKB.pls 115.0 30-MAR-09 23:23:31 appldev ship $ */
3
4 --
5 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- ONT_DEL_TO_ORG_Def_Util
11 --
12 -- DESCRIPTION
13 --
14 -- Body of package ONT_DEL_TO_ORG_Def_Util
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 30-MAR-09 Created
21 --
22
23 -- Global constant holding the package name
24 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ONT_DEL_TO_ORG_Def_Util';
25
26
27 g_database_object_name varchar2(30) :='OE_AK_DELIVER_TO_ORGS_V';
28
29
30 FUNCTION Get_Attr_Val_Varchar2
31 ( p_attr_code IN VARCHAR2
32 , p_record IN OE_AK_DELIVER_TO_ORGS_V%ROWTYPE
33 ) RETURN VARCHAR2
34 IS
35 BEGIN
36
37 IF p_attr_code =('CONTACT_ID') THEN
38 IF NVL(p_record.CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
39 RETURN p_record.CONTACT_ID;
40 ELSE
41 RETURN NULL;
42 END IF;
43 ELSIF p_attr_code =('FOB_POINT_CODE') THEN
44 IF NVL(p_record.FOB_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
45 RETURN p_record.FOB_POINT_CODE;
46 ELSE
47 RETURN NULL;
48 END IF;
49 ELSIF p_attr_code =('FREIGHT_TERMS_CODE') THEN
50 IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
51 RETURN p_record.FREIGHT_TERMS_CODE;
52 ELSE
53 RETURN NULL;
54 END IF;
55 ELSIF p_attr_code =('INVOICE_TO_ORG_ID') THEN
56 IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
57 RETURN p_record.INVOICE_TO_ORG_ID;
58 ELSE
59 RETURN NULL;
60 END IF;
61 ELSIF p_attr_code =('ORGANIZATION_ID') THEN
62 IF NVL(p_record.ORGANIZATION_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
63 RETURN p_record.ORGANIZATION_ID;
64 ELSE
65 RETURN NULL;
66 END IF;
67 ELSIF p_attr_code =('PRICE_LIST_ID') THEN
68 IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
69 RETURN p_record.PRICE_LIST_ID;
70 ELSE
71 RETURN NULL;
72 END IF;
73 ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
74 IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
75 RETURN p_record.SHIPPING_METHOD_CODE;
76 ELSE
77 RETURN NULL;
78 END IF;
79 ELSIF p_attr_code =('SHIP_FROM_ORG_ID') THEN
80 IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
81 RETURN p_record.SHIP_FROM_ORG_ID;
82 ELSE
83 RETURN NULL;
84 END IF;
85 ELSIF p_attr_code =('SHIP_PARTIAL_ALLOWED') THEN
86 IF NVL(p_record.SHIP_PARTIAL_ALLOWED, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
87 RETURN p_record.SHIP_PARTIAL_ALLOWED;
88 ELSE
89 RETURN NULL;
90 END IF;
91 ELSE
92 RETURN NULL;
93 END IF;
94 END Get_Attr_Val_Varchar2;
95
96
97 FUNCTION Get_Attr_Val_Date
98 ( p_attr_code IN VARCHAR2
99 , p_record IN OE_AK_DELIVER_TO_ORGS_V%ROWTYPE
100 ) RETURN DATE
101 IS
102 BEGIN
103
104 IF p_attr_code =('CONTACT_ID') THEN
105 IF NVL(p_record.CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
106 RETURN to_date(p_record.CONTACT_ID,'RRRR/MM/DD HH24:MI:SS');
107 ELSE
108 RETURN NULL;
109 END IF;
110 ELSIF p_attr_code =('FOB_POINT_CODE') THEN
111 IF NVL(p_record.FOB_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
112 RETURN to_date(p_record.FOB_POINT_CODE,'RRRR/MM/DD HH24:MI:SS');
113 ELSE
114 RETURN NULL;
115 END IF;
116 ELSIF p_attr_code =('FREIGHT_TERMS_CODE') THEN
117 IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
118 RETURN to_date(p_record.FREIGHT_TERMS_CODE,'RRRR/MM/DD HH24:MI:SS');
119 ELSE
120 RETURN NULL;
121 END IF;
122 ELSIF p_attr_code =('INVOICE_TO_ORG_ID') THEN
123 IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
124 RETURN to_date(p_record.INVOICE_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
125 ELSE
126 RETURN NULL;
127 END IF;
128 ELSIF p_attr_code =('ORGANIZATION_ID') THEN
129 IF NVL(p_record.ORGANIZATION_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
130 RETURN to_date(p_record.ORGANIZATION_ID,'RRRR/MM/DD HH24:MI:SS');
131 ELSE
132 RETURN NULL;
133 END IF;
134 ELSIF p_attr_code =('PRICE_LIST_ID') THEN
135 IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
136 RETURN to_date(p_record.PRICE_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
137 ELSE
138 RETURN NULL;
139 END IF;
140 ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
141 IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
142 RETURN to_date(p_record.SHIPPING_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
143 ELSE
144 RETURN NULL;
145 END IF;
146 ELSIF p_attr_code =('SHIP_FROM_ORG_ID') THEN
147 IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
148 RETURN to_date(p_record.SHIP_FROM_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
149 ELSE
150 RETURN NULL;
151 END IF;
152 ELSIF p_attr_code =('SHIP_PARTIAL_ALLOWED') THEN
153 IF NVL(p_record.SHIP_PARTIAL_ALLOWED, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
154 RETURN to_date(p_record.SHIP_PARTIAL_ALLOWED,'RRRR/MM/DD HH24:MI:SS');
155 ELSE
156 RETURN NULL;
157 END IF;
158 ELSE
159 RETURN NULL;
160 END IF;
161
162 END Get_Attr_Val_Date;
163
164
165 PROCEDURE Clear_DEL_TO_ORG_Cache
166 IS
167 BEGIN
168 g_cached_record.ORGANIZATION_ID := null;
169 END Clear_DEL_TO_ORG_Cache;
170
171
172 FUNCTION Sync_DEL_TO_ORG_Cache
173 ( p_ORGANIZATION_ID IN NUMBER
174
175
176 ) RETURN NUMBER
177 IS
178 CURSOR cache IS
179 SELECT * FROM OE_AK_DELIVER_TO_ORGS_V
180 WHERE ORGANIZATION_ID = p_ORGANIZATION_ID
181 ;
182 BEGIN
183
184 IF (NVL(p_ORGANIZATION_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
185 THEN
186 RETURN 0 ;
187 ELSIF (NVL(g_cached_record.ORGANIZATION_ID,FND_API.G_MISS_NUM) <> p_ORGANIZATION_ID)
188 THEN
189 Clear_DEL_TO_ORG_Cache;
190 Open cache;
191 FETCH cache into g_cached_record;
192 IF cache%NOTFOUND THEN
193 RETURN 0;
194 END IF;
195 Close cache;
196 RETURN 1 ;
197 END IF;
198
199 RETURN 1 ;
200 EXCEPTION
201 WHEN OTHERS THEN
202 RETURN 0 ;
203 END Sync_DEL_TO_ORG_Cache;
204
205
206 END ONT_DEL_TO_ORG_Def_Util;