[Home] [Help]
PACKAGE BODY: APPS.CSP_CARRIER_DELIVERY_TIMES_PKG
Source
1 PACKAGE BODY CSP_CARRIER_DELIVERY_TIMES_PKG AS
2 /* $Header: csptcdtb.pls 115.6 2002/11/26 07:42:14 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name : CSP_SCH_INT_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11
12 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_CARRIER_DELIVERY_TIMES_PKG';
13 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptcdtb.pls';
14
15 PROCEDURE Insert_Row(
16 px_RELATION_SHIP_ID IN OUT NOCOPY NUMBER,
17 p_CREATED_BY NUMBER,
18 p_CREATION_DATE DATE,
19 p_LAST_UPDATED_BY NUMBER,
20 p_LAST_UPDATE_DATE DATE,
21 p_LAST_UPDATE_LOGIN NUMBER,
22 p_ORGANIZATION_ID NUMBER,
23 p_FREIGHT_CODE VARCHAR2,
24 p_SHIPPING_METHODE VARCHAR2,
25 p_LEAD_TIME NUMBER,
26 p_LEAD_TIME_UOM VARCHAR2,
27 p_DELIVERY_TIME DATE,
28 p_CUTOFF_TIME DATE,
29 p_TIMEZONE_ID NUMBER,
30 p_ATTRIBUTE_CATEGORY VARCHAR2,
31 p_ATTRIBUTE1 VARCHAR2,
32 p_ATTRIBUTE2 VARCHAR2,
33 p_ATTRIBUTE3 VARCHAR2,
34 p_ATTRIBUTE4 VARCHAR2,
35 p_ATTRIBUTE5 VARCHAR2,
36 p_ATTRIBUTE6 VARCHAR2,
37 p_ATTRIBUTE7 VARCHAR2,
38 p_ATTRIBUTE8 VARCHAR2,
39 p_ATTRIBUTE9 VARCHAR2,
40 p_ATTRIBUTE10 VARCHAR2,
41 p_ATTRIBUTE11 VARCHAR2,
42 p_ATTRIBUTE12 VARCHAR2,
43 p_ATTRIBUTE13 VARCHAR2,
44 p_ATTRIBUTE14 VARCHAR2,
45 p_ATTRIBUTE15 VARCHAR2,
46 p_SAFTEY_ZONE NUMBER)
47
48 IS
49 CURSOR C2 IS SELECT CSP_CARRIER_DELIVERY_TIMES_S1.nextval FROM sys.dual;
50 BEGIN
51 If (px_RELATION_SHIP_ID IS NULL) OR (px_RELATION_SHIP_ID = FND_API.G_MISS_NUM) then
52 OPEN C2;
53 FETCH C2 INTO px_RELATION_SHIP_ID;
54 CLOSE C2;
55 End If;
56 INSERT INTO CSP_CARRIER_DELIVERY_TIMES(
57 RELATION_SHIP_ID,
58 CREATED_BY,
59 CREATION_DATE,
60 LAST_UPDATED_BY,
61 LAST_UPDATE_DATE,
62 LAST_UPDATE_LOGIN,
63 ORGANIZATION_ID,
64 FREIGHT_CODE,
65 SHIPPING_METHOD,
66 LEAD_TIME,
67 LEAD_TIME_UOM,
68 DELIVERY_TIME,
69 CUTOFF_TIME,
70 TIMEZONE_ID,
71 ATTRIBUTE_CATEGORY,
72 ATTRIBUTE1,
73 ATTRIBUTE2,
74 ATTRIBUTE3,
75 ATTRIBUTE4,
76 ATTRIBUTE5,
77 ATTRIBUTE6,
78 ATTRIBUTE7,
79 ATTRIBUTE8,
80 ATTRIBUTE9,
81 ATTRIBUTE10,
82 ATTRIBUTE11,
83 ATTRIBUTE12,
84 ATTRIBUTE13,
85 ATTRIBUTE14,
86 ATTRIBUTE15,
87 SAFETY_ZONE
88 ) VALUES (
89 px_RELATION_SHIP_ID,
90 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
91 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
92 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
93 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
94 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
95 decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
96 decode( p_FREIGHT_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_CODE),
97 decode( p_SHIPPING_METHODE, FND_API.G_MISS_CHAR, NULL, p_SHIPPING_METHODE),
98 decode( p_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_LEAD_TIME),
99 decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_LEAD_TIME_UOM),
100 decode( p_DELIVERY_TIME, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DELIVERY_TIME),
101 decode( p_CUTOFF_TIME, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CUTOFF_TIME),
102 decode( p_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_TIMEZONE_ID),
103 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
104 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
105 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
106 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
107 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
108 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
109 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
110 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
111 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
112 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
113 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
114 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
115 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
116 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
117 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
118 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
119 decode( p_SAFTEY_ZONE, FND_API.G_MISS_NUM, NULL, p_SAFTEY_ZONE));
120 End Insert_Row;
121
122 PROCEDURE Update_Row(
123 p_RELATION_SHIP_ID NUMBER,
124 p_CREATED_BY NUMBER,
125 p_CREATION_DATE DATE,
126 p_LAST_UPDATED_BY NUMBER,
127 p_LAST_UPDATE_DATE DATE,
128 p_LAST_UPDATE_LOGIN NUMBER,
129 p_ORGANIZATION_ID NUMBER,
130 p_FREIGHT_CODE VARCHAR2,
131 p_SHIPPING_METHODE VARCHAR2,
132 p_LEAD_TIME NUMBER,
133 p_LEAD_TIME_UOM VARCHAR2,
134 p_DELIVERY_TIME DATE,
135 p_CUTOFF_TIME DATE,
136 p_TIMEZONE_ID NUMBER,
137 p_ATTRIBUTE_CATEGORY VARCHAR2,
138 p_ATTRIBUTE1 VARCHAR2,
139 p_ATTRIBUTE2 VARCHAR2,
140 p_ATTRIBUTE3 VARCHAR2,
141 p_ATTRIBUTE4 VARCHAR2,
142 p_ATTRIBUTE5 VARCHAR2,
143 p_ATTRIBUTE6 VARCHAR2,
144 p_ATTRIBUTE7 VARCHAR2,
145 p_ATTRIBUTE8 VARCHAR2,
146 p_ATTRIBUTE9 VARCHAR2,
147 p_ATTRIBUTE10 VARCHAR2,
148 p_ATTRIBUTE11 VARCHAR2,
149 p_ATTRIBUTE12 VARCHAR2,
150 p_ATTRIBUTE13 VARCHAR2,
151 p_ATTRIBUTE14 VARCHAR2,
152 p_ATTRIBUTE15 VARCHAR2,
153 p_SAFTEY_ZONE NUMBER)
154
155 IS
156 BEGIN
157 Update CSP_CARRIER_DELIVERY_TIMES
158 SET
159 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
160 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
161 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
162 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
163 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
164 ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
165 FREIGHT_CODE = decode( p_FREIGHT_CODE, FND_API.G_MISS_CHAR, FREIGHT_CODE, p_FREIGHT_CODE),
166 SHIPPING_METHOD = decode( p_SHIPPING_METHODE, FND_API.G_MISS_CHAR, SHIPPING_METHOD, p_SHIPPING_METHODE),
167 LEAD_TIME = decode( p_LEAD_TIME, FND_API.G_MISS_NUM, LEAD_TIME, p_LEAD_TIME),
168 LEAD_TIME_UOM = decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, LEAD_TIME_UOM, p_LEAD_TIME_UOM),
169 DELIVERY_TIME = decode( p_DELIVERY_TIME, FND_API.G_MISS_DATE, DELIVERY_TIME, p_DELIVERY_TIME),
170 CUTOFF_TIME = decode( p_CUTOFF_TIME, FND_API.G_MISS_DATE, CUTOFF_TIME, p_CUTOFF_TIME),
171 TIMEZONE_ID = decode( p_TIMEZONE_ID, FND_API.G_MISS_NUM, TIMEZONE_ID, p_TIMEZONE_ID),
172 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
173 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
174 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
175 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
176 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
177 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
178 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
179 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
180 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
181 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
182 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
183 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
184 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
185 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
186 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
187 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
188 SAFETY_ZONE = decode( p_SAFTEY_ZONE, FND_API.G_MISS_NUM, SAFETY_ZONE, p_SAFTEY_ZONE)
189 where RELATION_SHIP_ID = p_RELATION_SHIP_ID;
190
191 If (SQL%NOTFOUND) then
192 RAISE NO_DATA_FOUND;
193 End If;
194 END Update_Row;
195
196 PROCEDURE Delete_Row(
197 p_RELATION_SHIP_ID NUMBER)
198 IS
199 BEGIN
200 DELETE FROM CSP_CARRIER_DELIVERY_TIMES
201 WHERE RELATION_SHIP_ID = p_RELATION_SHIP_ID;
202 If (SQL%NOTFOUND) then
203 RAISE NO_DATA_FOUND;
204 End If;
205 END Delete_Row;
206
207 PROCEDURE Lock_Row(
208 p_RELATION_SHIP_ID NUMBER,
209 p_CREATED_BY NUMBER,
210 p_CREATION_DATE DATE,
211 p_LAST_UPDATED_BY NUMBER,
212 p_LAST_UPDATE_DATE DATE,
213 p_LAST_UPDATE_LOGIN NUMBER,
214 p_ORGANIZATION_ID NUMBER,
215 p_FREIGHT_CODE VARCHAR2,
216 p_SHIPPING_METHODE VARCHAR2,
217 p_LEAD_TIME NUMBER,
218 p_LEAD_TIME_UOM VARCHAR2,
219 p_DELIVERY_TIME DATE,
220 p_CUTOFF_TIME DATE,
221 p_TIMEZONE_ID NUMBER,
222 p_ATTRIBUTE_CATEGORY VARCHAR2,
223 p_ATTRIBUTE1 VARCHAR2,
224 p_ATTRIBUTE2 VARCHAR2,
225 p_ATTRIBUTE3 VARCHAR2,
226 p_ATTRIBUTE4 VARCHAR2,
227 p_ATTRIBUTE5 VARCHAR2,
228 p_ATTRIBUTE6 VARCHAR2,
229 p_ATTRIBUTE7 VARCHAR2,
230 p_ATTRIBUTE8 VARCHAR2,
231 p_ATTRIBUTE9 VARCHAR2,
232 p_ATTRIBUTE10 VARCHAR2,
233 p_ATTRIBUTE11 VARCHAR2,
234 p_ATTRIBUTE12 VARCHAR2,
235 p_ATTRIBUTE13 VARCHAR2,
236 p_ATTRIBUTE14 VARCHAR2,
237 p_ATTRIBUTE15 VARCHAR2,
238 p_SAFTEY_ZONE NUMBER)
239
240 IS
241 CURSOR C IS
242 SELECT *
243 FROM CSP_CARRIER_DELIVERY_TIMES
244 WHERE RELATION_SHIP_ID = p_RELATION_SHIP_ID
245 FOR UPDATE of RELATION_SHIP_ID NOWAIT;
246 Recinfo C%ROWTYPE;
247 BEGIN
248 OPEN C;
249 FETCH C INTO Recinfo;
250 If (C%NOTFOUND) then
251 CLOSE C;
252 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
253 APP_EXCEPTION.RAISE_EXCEPTION;
254 End If;
255 CLOSE C;
256 if (
257 ( Recinfo.RELATION_SHIP_ID = p_RELATION_SHIP_ID)
258 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
259 OR ( ( Recinfo.CREATED_BY IS NULL )
260 AND ( p_CREATED_BY IS NULL )))
261 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
262 OR ( ( Recinfo.CREATION_DATE IS NULL )
268 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
263 AND ( p_CREATION_DATE IS NULL )))
264 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
265 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
266 AND ( p_LAST_UPDATED_BY IS NULL )))
267 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
269 AND ( p_LAST_UPDATE_DATE IS NULL )))
270 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
271 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
272 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
273 AND ( ( Recinfo.ORGANIZATION_ID = p_ORGANIZATION_ID)
274 OR ( ( Recinfo.ORGANIZATION_ID IS NULL )
275 AND ( p_ORGANIZATION_ID IS NULL )))
276 AND ( ( Recinfo.FREIGHT_CODE = p_FREIGHT_CODE)
277 OR ( ( Recinfo.FREIGHT_CODE IS NULL )
278 AND ( p_FREIGHT_CODE IS NULL )))
279 AND ( ( Recinfo.SHIPPING_METHOD = p_SHIPPING_METHODE)
280 OR ( ( Recinfo.SHIPPING_METHOD IS NULL )
281 AND ( p_SHIPPING_METHODE IS NULL )))
282 AND ( ( Recinfo.LEAD_TIME = p_LEAD_TIME)
283 OR ( ( Recinfo.LEAD_TIME IS NULL )
284 AND ( p_LEAD_TIME IS NULL )))
285 AND ( ( Recinfo.LEAD_TIME_UOM = p_LEAD_TIME_UOM)
286 OR ( ( Recinfo.LEAD_TIME_UOM IS NULL )
287 AND ( p_LEAD_TIME_UOM IS NULL )))
288 AND ( ( Recinfo.DELIVERY_TIME = p_DELIVERY_TIME)
289 OR ( ( Recinfo.DELIVERY_TIME IS NULL )
290 AND ( p_DELIVERY_TIME IS NULL )))
291 AND ( ( Recinfo.CUTOFF_TIME = p_CUTOFF_TIME)
292 OR ( ( Recinfo.CUTOFF_TIME IS NULL )
293 AND ( p_CUTOFF_TIME IS NULL )))
294 AND ( ( Recinfo.TIMEZONE_ID = p_TIMEZONE_ID)
295 OR ( ( Recinfo.TIMEZONE_ID IS NULL )
296 AND ( p_TIMEZONE_ID IS NULL )))
297 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
298 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
299 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
300 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
301 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
302 AND ( p_ATTRIBUTE1 IS NULL )))
303 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
304 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
305 AND ( p_ATTRIBUTE2 IS NULL )))
306 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
307 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
308 AND ( p_ATTRIBUTE3 IS NULL )))
309 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
310 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
311 AND ( p_ATTRIBUTE4 IS NULL )))
312 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
313 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
314 AND ( p_ATTRIBUTE5 IS NULL )))
315 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
316 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
317 AND ( p_ATTRIBUTE6 IS NULL )))
318 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
319 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
320 AND ( p_ATTRIBUTE7 IS NULL )))
321 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
322 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
323 AND ( p_ATTRIBUTE8 IS NULL )))
324 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
325 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
326 AND ( p_ATTRIBUTE9 IS NULL )))
327 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
328 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
329 AND ( p_ATTRIBUTE10 IS NULL )))
330 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
331 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
332 AND ( p_ATTRIBUTE11 IS NULL )))
333 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
334 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
335 AND ( p_ATTRIBUTE12 IS NULL )))
336 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
337 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
338 AND ( p_ATTRIBUTE13 IS NULL )))
339 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
340 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
341 AND ( p_ATTRIBUTE14 IS NULL )))
342 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
343 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
344 AND ( p_ATTRIBUTE15 IS NULL )))
345 AND ( ( Recinfo.SAFETY_ZONE = p_SAFTEY_ZONE)
346 OR ( ( Recinfo.SAFETY_ZONE IS NULL )
347 AND ( p_SAFTEY_ZONE IS NULL )))
348 ) then
349 return;
350 else
351 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
352 APP_EXCEPTION.RAISE_EXCEPTION;
353 End If;
354 END Lock_Row;
355
356 End CSP_CARRIER_DELIVERY_TIMES_PKG;