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.ASO_STATUS_TRANS_PKG

Source


1 PACKAGE BODY ASO_STATUS_TRANS_PKG as
2 /* $Header: asotstrb.pls 120.1 2005/06/29 12:40:37 appldev ship $ */
3 -- Start of Comments
4 -- Package name     : ASO_STATUS_TRANS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_STATUS_TRANS_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotstrb.pls';
13 
14 PROCEDURE Insert_Row(
15           px_TRANSITION_ID   IN OUT NOCOPY /* file.sql.39 change */   NUMBER,
16           p_CREATION_DATE    DATE,
17           p_CREATED_BY    NUMBER,
18           p_LAST_UPDATED_BY    NUMBER,
19           p_LAST_UPDATE_DATE    DATE,
20           p_LAST_UPDATE_LOGIN    NUMBER,
21           p_REQUEST_ID    NUMBER,
22           p_PROGRAM_APPLICATION_ID    NUMBER,
23           p_PROGRAM_ID    NUMBER,
24           p_PROGRAM_UPDATE_DATE    DATE,
25           p_FROM_STATUS_ID    NUMBER,
26           p_TO_STATUS_ID    NUMBER,
27           p_ENABLED_FLAG    VARCHAR2,
28           p_LOV_DRIVEN_FLAG         VARCHAR2,
29           p_USER_MAINTAINABLE_FLAG  VARCHAR2,
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_ATTRIBUTE16    VARCHAR2,
47           p_ATTRIBUTE17    VARCHAR2,
48           p_ATTRIBUTE18    VARCHAR2,
49           p_ATTRIBUTE19    VARCHAR2,
50           p_ATTRIBUTE20    VARCHAR2)
51 
52  IS
53    CURSOR C2 IS SELECT ASO_QUOTE_STATUS_TRANSITIONS_S.nextval FROM sys.dual;
54 BEGIN
55    If (px_TRANSITION_ID IS NULL) OR (px_TRANSITION_ID = FND_API.G_MISS_NUM) then
56        OPEN C2;
57        FETCH C2 INTO px_TRANSITION_ID;
58        CLOSE C2;
59    End If;
60    INSERT INTO ASO_QUOTE_STATUS_TRANSITIONS(
61            TRANSITION_ID,
62            CREATION_DATE,
63            CREATED_BY,
64            LAST_UPDATED_BY,
65            LAST_UPDATE_DATE,
66            LAST_UPDATE_LOGIN,
67            REQUEST_ID,
68            PROGRAM_APPLICATION_ID,
69            PROGRAM_ID,
70            PROGRAM_UPDATE_DATE,
71            FROM_STATUS_ID,
72            TO_STATUS_ID,
73            ENABLED_FLAG,
74            LOV_DRIVEN_FLAG,
75            USER_MAINTAINABLE_FLAG,
76            ATTRIBUTE_CATEGORY,
77            ATTRIBUTE1,
78            ATTRIBUTE2,
79            ATTRIBUTE3,
80            ATTRIBUTE4,
81            ATTRIBUTE5,
82            ATTRIBUTE6,
83            ATTRIBUTE7,
84            ATTRIBUTE8,
85            ATTRIBUTE9,
86            ATTRIBUTE10,
87            ATTRIBUTE11,
88            ATTRIBUTE12,
89            ATTRIBUTE13,
90            ATTRIBUTE14,
91            ATTRIBUTE15,
92            ATTRIBUTE16,
93            ATTRIBUTE17,
94            ATTRIBUTE18,
95            ATTRIBUTE19,
96            ATTRIBUTE20
97           ) VALUES (
98            px_TRANSITION_ID,
99            ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
100            decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
101            decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
102            ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
103            decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
104            decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
105            decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
106            decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
107            ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
108            decode( p_FROM_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_FROM_STATUS_ID),
109            decode( p_TO_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_TO_STATUS_ID),
110            decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
111            decode( p_LOV_DRIVEN_FLAG, FND_API.G_MISS_CHAR, NULL, p_LOV_DRIVEN_FLAG),
112            decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_USER_MAINTAINABLE_FLAG),
113            decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
114            decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
115            decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
116            decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
117            decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
118            decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
119            decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
120            decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
121            decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
122            decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
123            decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
124            decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
125            decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
126            decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
127            decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
128            decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
129            decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
130            decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
131            decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
132            decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
133            decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20));
134 End Insert_Row;
135 
136 PROCEDURE Update_Row(
137           p_TRANSITION_ID    NUMBER,
138           p_CREATION_DATE    DATE,
139           p_CREATED_BY    NUMBER,
140           p_LAST_UPDATED_BY    NUMBER,
141           p_LAST_UPDATE_DATE    DATE,
142           p_LAST_UPDATE_LOGIN    NUMBER,
143           p_REQUEST_ID    NUMBER,
144           p_PROGRAM_APPLICATION_ID    NUMBER,
145           p_PROGRAM_ID    NUMBER,
146           p_PROGRAM_UPDATE_DATE    DATE,
147           p_FROM_STATUS_ID    NUMBER,
148           p_TO_STATUS_ID    NUMBER,
149           p_ENABLED_FLAG    VARCHAR2,
150           p_LOV_DRIVEN_FLAG         VARCHAR2,
151           p_USER_MAINTAINABLE_FLAG  VARCHAR2,
152           p_ATTRIBUTE_CATEGORY    VARCHAR2,
153           p_ATTRIBUTE1    VARCHAR2,
154           p_ATTRIBUTE2    VARCHAR2,
155           p_ATTRIBUTE3    VARCHAR2,
156           p_ATTRIBUTE4    VARCHAR2,
157           p_ATTRIBUTE5    VARCHAR2,
158           p_ATTRIBUTE6    VARCHAR2,
159           p_ATTRIBUTE7    VARCHAR2,
160           p_ATTRIBUTE8    VARCHAR2,
161           p_ATTRIBUTE9    VARCHAR2,
162           p_ATTRIBUTE10    VARCHAR2,
163           p_ATTRIBUTE11    VARCHAR2,
164           p_ATTRIBUTE12    VARCHAR2,
165           p_ATTRIBUTE13    VARCHAR2,
166           p_ATTRIBUTE14    VARCHAR2,
167           p_ATTRIBUTE15    VARCHAR2,
168           p_ATTRIBUTE16    VARCHAR2,
169           p_ATTRIBUTE17    VARCHAR2,
170           p_ATTRIBUTE18    VARCHAR2,
171           p_ATTRIBUTE19    VARCHAR2,
172           p_ATTRIBUTE20    VARCHAR2
173           )
174 
175  IS
176  BEGIN
177     Update ASO_QUOTE_STATUS_TRANSITIONS
178     SET
179               CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
180               CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
181               LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
182               LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
183               LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
184               REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
185               PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
186               PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
187               PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
188               FROM_STATUS_ID = decode( p_FROM_STATUS_ID, FND_API.G_MISS_NUM, FROM_STATUS_ID, p_FROM_STATUS_ID),
189               TO_STATUS_ID = decode( p_TO_STATUS_ID, FND_API.G_MISS_NUM, TO_STATUS_ID, p_TO_STATUS_ID),
190               ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
191               LOV_DRIVEN_FLAG = decode( p_LOV_DRIVEN_FLAG, FND_API.G_MISS_CHAR, LOV_DRIVEN_FLAG, p_LOV_DRIVEN_FLAG),
192               USER_MAINTAINABLE_FLAG = decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, USER_MAINTAINABLE_FLAG, p_USER_MAINTAINABLE_FLAG),
193               ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
194               ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
195               ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
196               ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
197               ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
198               ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
199               ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
200               ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
201               ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
202               ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
203               ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
204               ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
205               ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
206               ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
207               ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
208               ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
209                ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
210               ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
211               ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
212               ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
213               ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20)
214     where TRANSITION_ID = p_TRANSITION_ID;
215 
216     If (SQL%NOTFOUND) then
217         RAISE NO_DATA_FOUND;
218     End If;
219 END Update_Row;
220 
221 PROCEDURE Delete_Row(
222     p_TRANSITION_ID  NUMBER)
223  IS
224  BEGIN
225    DELETE FROM ASO_QUOTE_STATUS_TRANSITIONS
226     WHERE TRANSITION_ID = p_TRANSITION_ID;
227    If (SQL%NOTFOUND) then
228        RAISE NO_DATA_FOUND;
229    End If;
230  END Delete_Row;
231 
232 PROCEDURE Lock_Row(
233           p_TRANSITION_ID    NUMBER,
234           p_CREATION_DATE    DATE,
235           p_CREATED_BY    NUMBER,
236           p_LAST_UPDATED_BY    NUMBER,
237           p_LAST_UPDATE_DATE    DATE,
238           p_LAST_UPDATE_LOGIN    NUMBER,
239           p_REQUEST_ID    NUMBER,
240           p_PROGRAM_APPLICATION_ID    NUMBER,
241           p_PROGRAM_ID    NUMBER,
242           p_PROGRAM_UPDATE_DATE    DATE,
243           p_FROM_STATUS_ID    NUMBER,
244           p_TO_STATUS_ID    NUMBER,
245           p_ENABLED_FLAG    VARCHAR2,
246           p_LOV_DRIVEN_FLAG         VARCHAR2,
247           p_USER_MAINTAINABLE_FLAG  VARCHAR2,
248           p_ATTRIBUTE_CATEGORY    VARCHAR2,
249           p_ATTRIBUTE1    VARCHAR2,
250           p_ATTRIBUTE2    VARCHAR2,
251           p_ATTRIBUTE3    VARCHAR2,
252           p_ATTRIBUTE4    VARCHAR2,
253           p_ATTRIBUTE5    VARCHAR2,
254           p_ATTRIBUTE6    VARCHAR2,
255           p_ATTRIBUTE7    VARCHAR2,
256           p_ATTRIBUTE8    VARCHAR2,
257           p_ATTRIBUTE9    VARCHAR2,
258           p_ATTRIBUTE10    VARCHAR2,
259           p_ATTRIBUTE11    VARCHAR2,
260           p_ATTRIBUTE12    VARCHAR2,
261           p_ATTRIBUTE13    VARCHAR2,
262           p_ATTRIBUTE14    VARCHAR2,
263           p_ATTRIBUTE15    VARCHAR2)
264 
265  IS
266    CURSOR C IS
267         SELECT TRANSITION_ID,
268 CREATION_DATE,
269 CREATED_BY,
270 LAST_UPDATED_BY,
271 LAST_UPDATE_DATE,
272 LAST_UPDATE_LOGIN,
273 REQUEST_ID,
277 FROM_STATUS_ID,
274 PROGRAM_APPLICATION_ID,
275 PROGRAM_ID,
276 PROGRAM_UPDATE_DATE,
278 TO_STATUS_ID,
279 ENABLED_FLAG,
280 LOV_DRIVEN_FLAG,
281 USER_MAINTAINABLE_FLAG,
282 ATTRIBUTE_CATEGORY,
283 ATTRIBUTE1,
284 ATTRIBUTE2,
285 ATTRIBUTE3,
286 ATTRIBUTE4,
287 ATTRIBUTE5,
288 ATTRIBUTE6,
289 ATTRIBUTE7,
290 ATTRIBUTE8,
291 ATTRIBUTE9,
292 ATTRIBUTE10,
293 ATTRIBUTE11,
294 ATTRIBUTE12,
295 ATTRIBUTE13,
296 ATTRIBUTE14,
297 ATTRIBUTE15
298          FROM ASO_QUOTE_STATUS_TRANSITIONS
299         WHERE TRANSITION_ID =  p_TRANSITION_ID
300         FOR UPDATE of TRANSITION_ID NOWAIT;
301    Recinfo C%ROWTYPE;
302  BEGIN
303     OPEN C;
304     FETCH C INTO Recinfo;
305     If (C%NOTFOUND) then
306         CLOSE C;
307         FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
308         APP_EXCEPTION.RAISE_EXCEPTION;
309     End If;
310     CLOSE C;
311     if (
312 /*
313            (      Recinfo.TRANSITION_ID = p_TRANSITION_ID)
314        AND (    ( Recinfo.CREATION_DATE = p_CREATION_DATE)
315             OR (    ( Recinfo.CREATION_DATE IS NULL )
316                 AND (  p_CREATION_DATE IS NULL )))
317        AND (    ( Recinfo.CREATED_BY = p_CREATED_BY)
318             OR (    ( Recinfo.CREATED_BY IS NULL )
319                 AND (  p_CREATED_BY IS NULL )))
320        AND (    ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
321             OR (    ( Recinfo.LAST_UPDATED_BY IS NULL )
322                 AND (  p_LAST_UPDATED_BY IS NULL )))
323        AND
324 */
325 	  (    ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
326             OR (    ( Recinfo.LAST_UPDATE_DATE IS NULL )
327                 AND (  p_LAST_UPDATE_DATE IS NULL )))
328 /*
329        AND (    ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
330             OR (    ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
331                 AND (  p_LAST_UPDATE_LOGIN IS NULL )))
332        AND (    ( Recinfo.REQUEST_ID = p_REQUEST_ID)
333             OR (    ( Recinfo.REQUEST_ID IS NULL )
334                 AND (  p_REQUEST_ID IS NULL )))
335        AND (    ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
336             OR (    ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
337                 AND (  p_PROGRAM_APPLICATION_ID IS NULL )))
338        AND (    ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
339             OR (    ( Recinfo.PROGRAM_ID IS NULL )
340                 AND (  p_PROGRAM_ID IS NULL )))
341        AND (    ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
342             OR (    ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
343                 AND (  p_PROGRAM_UPDATE_DATE IS NULL )))
344        AND (    ( Recinfo.FROM_STATUS_ID = p_FROM_STATUS_ID)
345             OR (    ( Recinfo.FROM_STATUS_ID IS NULL )
346                 AND (  p_FROM_STATUS_ID IS NULL )))
347        AND (    ( Recinfo.TO_STATUS_ID = p_TO_STATUS_ID)
348             OR (    ( Recinfo.TO_STATUS_ID IS NULL )
349                 AND (  p_TO_STATUS_ID IS NULL )))
350        AND (    ( Recinfo.ENABLED_FLAG = p_ENABLED_FLAG)
351             OR (    ( Recinfo.ENABLED_FLAG IS NULL )
352                 AND (  p_ENABLED_FLAG IS NULL )))
353        AND (    ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
354             OR (    ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
355                 AND (  p_ATTRIBUTE_CATEGORY IS NULL )))
356        AND (    ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
357             OR (    ( Recinfo.ATTRIBUTE1 IS NULL )
358                 AND (  p_ATTRIBUTE1 IS NULL )))
359        AND (    ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
360             OR (    ( Recinfo.ATTRIBUTE2 IS NULL )
361                 AND (  p_ATTRIBUTE2 IS NULL )))
362        AND (    ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
363             OR (    ( Recinfo.ATTRIBUTE3 IS NULL )
364                 AND (  p_ATTRIBUTE3 IS NULL )))
365        AND (    ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
366             OR (    ( Recinfo.ATTRIBUTE4 IS NULL )
367                 AND (  p_ATTRIBUTE4 IS NULL )))
368        AND (    ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
369             OR (    ( Recinfo.ATTRIBUTE5 IS NULL )
370                 AND (  p_ATTRIBUTE5 IS NULL )))
371        AND (    ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
372             OR (    ( Recinfo.ATTRIBUTE6 IS NULL )
373                 AND (  p_ATTRIBUTE6 IS NULL )))
374        AND (    ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
375             OR (    ( Recinfo.ATTRIBUTE7 IS NULL )
376                 AND (  p_ATTRIBUTE7 IS NULL )))
377        AND (    ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
378             OR (    ( Recinfo.ATTRIBUTE8 IS NULL )
379                 AND (  p_ATTRIBUTE8 IS NULL )))
380        AND (    ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
381             OR (    ( Recinfo.ATTRIBUTE9 IS NULL )
382                 AND (  p_ATTRIBUTE9 IS NULL )))
383        AND (    ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
384             OR (    ( Recinfo.ATTRIBUTE10 IS NULL )
385                 AND (  p_ATTRIBUTE10 IS NULL )))
386        AND (    ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
387             OR (    ( Recinfo.ATTRIBUTE11 IS NULL )
388                 AND (  p_ATTRIBUTE11 IS NULL )))
389        AND (    ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
390             OR (    ( Recinfo.ATTRIBUTE12 IS NULL )
391                 AND (  p_ATTRIBUTE12 IS NULL )))
392        AND (    ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
393             OR (    ( Recinfo.ATTRIBUTE13 IS NULL )
394                 AND (  p_ATTRIBUTE13 IS NULL )))
395        AND (    ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
396             OR (    ( Recinfo.ATTRIBUTE14 IS NULL )
397                 AND (  p_ATTRIBUTE14 IS NULL )))
398        AND (    ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
399             OR (    ( Recinfo.ATTRIBUTE15 IS NULL )
400                 AND (  p_ATTRIBUTE15 IS NULL )))
401 */
402        ) then
403        return;
404    else
405        FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
406        APP_EXCEPTION.RAISE_EXCEPTION;
407    End If;
408 END Lock_Row;
409 
410 End ASO_STATUS_TRANS_PKG;