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