[Home] [Help]
PACKAGE BODY: APPS.CSI_T_TXN_LINE_DETAILS_PKG
Source
1 PACKAGE BODY CSI_T_TXN_LINE_DETAILS_PKG as
2 /* $Header: csitttdb.pls 120.1 2005/06/17 01:51:18 appldev $ */
3 -- Package name : CSI_T_TXN_LINE_DETAILS_PKG
4 -- Purpose : Table Handler for csi_t_txn_line_details
5 -- History : brmanesh created 12-MAY-2001
6 -- : epajaril 15-AUG-2003 added the instance_status_id
7 -- : rmamidip 19-NOV-2003 added install_location_tyype_code and install_location_id
8 -- : epajaril 17-MAR-2004 added the parent_instance_id
9 -- NOTE :
10
11
12 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_T_TXN_LINE_DETAILS_PKG';
13 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitttdb.pls';
14
15 -- Added for CZ Integration (Begin)
16 -- Following attributes are added to various modules.
17 -- p_CONFIG_INST_HDR_ID NUMBER ,
18 -- p_CONFIG_INST_REV_NUM NUMBER ,
19 -- p_CONFIG_INST_ITEM_ID NUMBER ,
20 -- p_CONFIG_INST_BASELINE_REV_NUM NUMBER ,
21 -- p_TARGET_COMMITMENT_DATE DATE ,
22 -- p_INSTANCE_DESCRIPTION VARCHAR2 ,
23 -- Added for CZ Integration (End)
24
25 -- Added for RMA Fl (Begin)
26 -- p_REFERENCE_SOURCE_LINE_ID
27 -- Added for RMA Fl (End)
28
29 PROCEDURE Insert_Row(
30 px_TXN_LINE_DETAIL_ID IN OUT NOCOPY NUMBER,
31 p_TRANSACTION_LINE_ID NUMBER,
32 p_SUB_TYPE_ID NUMBER,
33 p_INSTANCE_EXISTS_FLAG VARCHAR2,
34 p_SOURCE_TRANSACTION_FLAG VARCHAR2,
35 p_INSTANCE_ID NUMBER,
36 p_CSI_SYSTEM_ID NUMBER,
37 p_INVENTORY_ITEM_ID NUMBER,
38 p_INV_ORGANIZATION_ID NUMBER,
39 p_INVENTORY_REVISION VARCHAR2,
40 p_INSTANCE_TYPE_CODE VARCHAR2,
41 p_ITEM_CONDITION_ID NUMBER,
42 p_QUANTITY NUMBER,
43 p_UNIT_OF_MEASURE VARCHAR2,
44 p_QTY_REMAINING NUMBER,
45 p_SERIAL_NUMBER VARCHAR2,
46 p_LOT_NUMBER VARCHAR2,
47 p_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
48 p_LOCATION_TYPE_CODE VARCHAR2,
49 p_LOCATION_ID NUMBER,
50 p_INSTALLATION_DATE DATE,
51 p_IN_SERVICE_DATE DATE,
52 p_EXTERNAL_REFERENCE VARCHAR2,
53 p_VERSION_LABEL VARCHAR2,
54 p_TRANSACTION_SYSTEM_ID NUMBER,
55 p_SELLABLE_FLAG VARCHAR2,
56 p_RETURN_BY_DATE DATE,
57 p_ACTIVE_START_DATE DATE,
58 p_ACTIVE_END_DATE DATE,
59 p_PRESERVE_DETAIL_FLAG VARCHAR2,
60 p_CHANGED_INSTANCE_ID NUMBER,
61 p_REFERENCE_SOURCE_ID NUMBER,
62 p_REFERENCE_SOURCE_LINE_ID NUMBER,
63 p_REFERENCE_SOURCE_DATE DATE,
64 p_CSI_TRANSACTION_ID NUMBER,
65 p_SOURCE_TXN_LINE_DETAIL_ID NUMBER,
66 p_INV_MTL_TRANSACTION_ID NUMBER,
67 p_PROCESSING_STATUS VARCHAR2,
68 p_ERROR_CODE VARCHAR2,
69 p_ERROR_EXPLANATION VARCHAR2,
70 p_CONFIG_INST_HDR_ID NUMBER ,
71 p_CONFIG_INST_REV_NUM NUMBER ,
72 p_CONFIG_INST_ITEM_ID NUMBER ,
73 p_CONFIG_INST_BASELINE_REV_NUM NUMBER ,
74 p_TARGET_COMMITMENT_DATE DATE ,
75 p_INSTANCE_DESCRIPTION VARCHAR2 ,
76 p_INSTALL_LOCATION_TYPE_CODE VARCHAR2,
77 p_INSTALL_LOCATION_ID NUMBER,
78 p_CASCADE_OWNER_FLAG VARCHAR2,-- bug 2972082
79 p_ATTRIBUTE1 VARCHAR2,
80 p_ATTRIBUTE2 VARCHAR2,
81 p_ATTRIBUTE3 VARCHAR2,
82 p_ATTRIBUTE4 VARCHAR2,
83 p_ATTRIBUTE5 VARCHAR2,
84 p_ATTRIBUTE6 VARCHAR2,
85 p_ATTRIBUTE7 VARCHAR2,
86 p_ATTRIBUTE8 VARCHAR2,
87 p_ATTRIBUTE9 VARCHAR2,
88 p_ATTRIBUTE10 VARCHAR2,
89 p_ATTRIBUTE11 VARCHAR2,
90 p_ATTRIBUTE12 VARCHAR2,
91 p_ATTRIBUTE13 VARCHAR2,
92 p_ATTRIBUTE14 VARCHAR2,
93 p_ATTRIBUTE15 VARCHAR2,
94 p_CREATED_BY NUMBER,
95 p_CREATION_DATE DATE,
96 p_LAST_UPDATED_BY NUMBER,
97 p_LAST_UPDATE_DATE DATE,
98 p_LAST_UPDATE_LOGIN NUMBER,
99 p_OBJECT_VERSION_NUMBER NUMBER,
100 p_CONTEXT VARCHAR2,
101 p_instance_status_id NUMBER,
102 p_parent_instance_id NUMBER,
103 p_assc_txn_line_detail_id NUMBER,
104 p_OVERRIDING_CSI_TXN_ID NUMBER)
105
106 IS
107 CURSOR C2 IS SELECT CSI_T_TXN_LINE_DETAILS_S.nextval FROM sys.dual;
108 BEGIN
109 If (px_TXN_LINE_DETAIL_ID IS NULL) OR (px_TXN_LINE_DETAIL_ID = FND_API.G_MISS_NUM) then
110 OPEN C2;
111 FETCH C2 INTO px_TXN_LINE_DETAIL_ID;
112 CLOSE C2;
113 End If;
114 INSERT INTO CSI_T_TXN_LINE_DETAILS(
115 TXN_LINE_DETAIL_ID,
116 TRANSACTION_LINE_ID,
117 SUB_TYPE_ID,
118 INSTANCE_EXISTS_FLAG,
119 SOURCE_TRANSACTION_FLAG,
120 INSTANCE_ID,
121 CSI_SYSTEM_ID,
122 INVENTORY_ITEM_ID,
123 INV_ORGANIZATION_ID,
124 INVENTORY_REVISION,
125 INSTANCE_TYPE_CODE,
126 ITEM_CONDITION_ID,
127 QUANTITY,
128 UNIT_OF_MEASURE,
129 QTY_REMAINING,
130 SERIAL_NUMBER,
131 LOT_NUMBER,
132 MFG_SERIAL_NUMBER_FLAG,
133 LOCATION_TYPE_CODE,
134 LOCATION_ID,
135 INSTALLATION_DATE,
136 IN_SERVICE_DATE,
137 EXTERNAL_REFERENCE,
138 VERSION_LABEL,
139 TRANSACTION_SYSTEM_ID,
140 SELLABLE_FLAG,
141 RETURN_BY_DATE,
142 ACTIVE_START_DATE,
143 ACTIVE_END_DATE,
144 PRESERVE_DETAIL_FLAG,
145 CHANGED_INSTANCE_ID,
146 REFERENCE_SOURCE_ID,
147 REFERENCE_SOURCE_LINE_ID,
148 REFERENCE_SOURCE_DATE,
149 CSI_TRANSACTION_ID,
150 SOURCE_TXN_LINE_DETAIL_ID,
151 INV_MTL_TRANSACTION_ID,
152 PROCESSING_STATUS,
153 ERROR_CODE,
154 ERROR_EXPLANATION,
155 CONFIG_INST_HDR_ID ,
156 CONFIG_INST_REV_NUM ,
157 CONFIG_INST_ITEM_ID,
158 CONFIG_INST_BASELINE_REV_NUM,
159 TARGET_COMMITMENT_DATE,
160 INSTANCE_DESCRIPTION,
161 INSTALL_LOCATION_TYPE_CODE,
162 INSTALL_LOCATION_ID,
163 CASCADE_OWNER_FLAG,-- bug 2972082
164 ATTRIBUTE1,
165 ATTRIBUTE2,
166 ATTRIBUTE3,
167 ATTRIBUTE4,
168 ATTRIBUTE5,
169 ATTRIBUTE6,
170 ATTRIBUTE7,
171 ATTRIBUTE8,
172 ATTRIBUTE9,
173 ATTRIBUTE10,
174 ATTRIBUTE11,
175 ATTRIBUTE12,
176 ATTRIBUTE13,
177 ATTRIBUTE14,
178 ATTRIBUTE15,
179 CREATED_BY,
180 CREATION_DATE,
181 LAST_UPDATED_BY,
182 LAST_UPDATE_DATE,
183 LAST_UPDATE_LOGIN,
184 OBJECT_VERSION_NUMBER,
185 CONTEXT,
186 INSTANCE_STATUS_ID,
187 PARENT_INSTANCE_ID,
188 ASSC_TXN_LINE_DETAIL_ID,
189 OVERRIDING_CSI_TXN_ID
190 ) VALUES (
191 px_TXN_LINE_DETAIL_ID,
192 decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_LINE_ID),
193 decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SUB_TYPE_ID),
194 decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_EXISTS_FLAG),
195 decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_FLAG),
196 decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID),
197 decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_CSI_SYSTEM_ID),
198 decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
199 decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
200 decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
201 decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
202 decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_ITEM_CONDITION_ID),
203 decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
204 decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
205 decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, NULL, p_QTY_REMAINING),
206 decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
207 decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
208 decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
209 decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
210 decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
211 decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALLATION_DATE),
212 decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_IN_SERVICE_DATE),
213 decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
214 decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, NULL, p_VERSION_LABEL),
215 decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SYSTEM_ID),
216 decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
217 decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
218 decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
219 decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
220 decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRESERVE_DETAIL_FLAG),
221 decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_CHANGED_INSTANCE_ID),
222 decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_ID),
223 decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_LINE_ID),
224 decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REFERENCE_SOURCE_DATE),
225 decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_CSI_TRANSACTION_ID),
226 decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TXN_LINE_DETAIL_ID),
227 decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MTL_TRANSACTION_ID),
228 decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESSING_STATUS),
229 decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, NULL, p_ERROR_CODE),
230 decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, NULL, p_ERROR_EXPLANATION),
231 decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_HDR_ID),
232 decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_REV_NUM),
233 decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_ITEM_ID),
234 decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_BASELINE_REV_NUM),
235 decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
236 decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_DESCRIPTION),
237 decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
238 decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
239 decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, NULL, p_CASCADE_OWNER_FLAG),-- bug 2972082
240 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
241 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
242 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
243 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
244 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
245 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
246 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
247 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
248 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
249 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
250 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
251 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
252 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
253 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
254 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
255 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
256 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
257 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
258 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
259 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
260 decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
261 decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
262 decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
263 decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_INSTANCE_ID),
264 decode( p_ASSC_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ASSC_TXN_LINE_DETAIL_ID),
265 decode( p_OVERRIDING_CSI_TXN_ID, FND_API.G_MISS_NUM, NULL, p_OVERRIDING_CSI_TXN_ID));
266 End Insert_Row;
267
268 PROCEDURE Update_Row(
269 p_TXN_LINE_DETAIL_ID NUMBER,
270 p_TRANSACTION_LINE_ID NUMBER,
271 p_SUB_TYPE_ID NUMBER,
272 p_INSTANCE_EXISTS_FLAG VARCHAR2,
273 p_SOURCE_TRANSACTION_FLAG VARCHAR2,
274 p_INSTANCE_ID NUMBER,
275 p_CSI_SYSTEM_ID NUMBER,
276 p_INVENTORY_ITEM_ID NUMBER,
277 p_INV_ORGANIZATION_ID NUMBER,
278 p_INVENTORY_REVISION VARCHAR2,
279 p_INSTANCE_TYPE_CODE VARCHAR2,
280 p_ITEM_CONDITION_ID NUMBER,
281 p_QUANTITY NUMBER,
282 p_UNIT_OF_MEASURE VARCHAR2,
283 p_QTY_REMAINING NUMBER,
284 p_SERIAL_NUMBER VARCHAR2,
285 p_LOT_NUMBER VARCHAR2,
286 p_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
287 p_LOCATION_TYPE_CODE VARCHAR2,
288 p_LOCATION_ID NUMBER,
289 p_INSTALLATION_DATE DATE,
290 p_IN_SERVICE_DATE DATE,
291 p_EXTERNAL_REFERENCE VARCHAR2,
292 p_VERSION_LABEL VARCHAR2,
293 p_TRANSACTION_SYSTEM_ID NUMBER,
294 p_SELLABLE_FLAG VARCHAR2,
295 p_RETURN_BY_DATE DATE,
296 p_ACTIVE_START_DATE DATE,
297 p_ACTIVE_END_DATE DATE,
298 p_PRESERVE_DETAIL_FLAG VARCHAR2,
299 p_CHANGED_INSTANCE_ID NUMBER,
300 p_REFERENCE_SOURCE_ID NUMBER,
301 p_REFERENCE_SOURCE_LINE_ID NUMBER,
302 p_REFERENCE_SOURCE_DATE DATE,
303 p_CSI_TRANSACTION_ID NUMBER,
304 p_SOURCE_TXN_LINE_DETAIL_ID NUMBER,
305 p_INV_MTL_TRANSACTION_ID NUMBER,
306 p_PROCESSING_STATUS VARCHAR2,
307 p_ERROR_CODE VARCHAR2,
308 p_ERROR_EXPLANATION VARCHAR2,
309 p_CONFIG_INST_HDR_ID NUMBER ,
310 p_CONFIG_INST_REV_NUM NUMBER ,
311 p_CONFIG_INST_ITEM_ID NUMBER ,
312 p_CONFIG_INST_BASELINE_REV_NUM NUMBER ,
313 p_TARGET_COMMITMENT_DATE DATE ,
314 p_INSTANCE_DESCRIPTION VARCHAR2 ,
315 p_INSTALL_LOCATION_TYPE_CODE VARCHAR2,
316 p_INSTALL_LOCATION_ID NUMBER,
317 p_CASCADE_OWNER_FLAG VARCHAR2,-- bug 2972082
318 p_ATTRIBUTE1 VARCHAR2,
319 p_ATTRIBUTE2 VARCHAR2,
320 p_ATTRIBUTE3 VARCHAR2,
321 p_ATTRIBUTE4 VARCHAR2,
322 p_ATTRIBUTE5 VARCHAR2,
323 p_ATTRIBUTE6 VARCHAR2,
324 p_ATTRIBUTE7 VARCHAR2,
325 p_ATTRIBUTE8 VARCHAR2,
326 p_ATTRIBUTE9 VARCHAR2,
327 p_ATTRIBUTE10 VARCHAR2,
328 p_ATTRIBUTE11 VARCHAR2,
329 p_ATTRIBUTE12 VARCHAR2,
330 p_ATTRIBUTE13 VARCHAR2,
331 p_ATTRIBUTE14 VARCHAR2,
332 p_ATTRIBUTE15 VARCHAR2,
333 p_CREATED_BY NUMBER,
334 p_CREATION_DATE DATE,
335 p_LAST_UPDATED_BY NUMBER,
336 p_LAST_UPDATE_DATE DATE,
337 p_LAST_UPDATE_LOGIN NUMBER,
338 p_OBJECT_VERSION_NUMBER NUMBER,
339 p_CONTEXT VARCHAR2,
340 p_INSTANCE_STATUS_ID NUMBER,
341 p_PARENT_INSTANCE_ID NUMBER,
342 p_ASSC_TXN_LINE_DETAIL_ID NUMBER,
343 p_OVERRIDING_CSI_TXN_ID NUMBER)
344
345 IS
346 BEGIN
347 Update CSI_T_TXN_LINE_DETAILS
348 SET
349 TRANSACTION_LINE_ID = decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, TRANSACTION_LINE_ID, p_TRANSACTION_LINE_ID),
350 SUB_TYPE_ID = decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, SUB_TYPE_ID, p_SUB_TYPE_ID),
351 INSTANCE_EXISTS_FLAG = decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, INSTANCE_EXISTS_FLAG, p_INSTANCE_EXISTS_FLAG),
352 SOURCE_TRANSACTION_FLAG = decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_FLAG, p_SOURCE_TRANSACTION_FLAG),
353 INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
354 CSI_SYSTEM_ID = decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, CSI_SYSTEM_ID, p_CSI_SYSTEM_ID),
355 INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
356 INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
357 INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
358 INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
359 ITEM_CONDITION_ID = decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, ITEM_CONDITION_ID, p_ITEM_CONDITION_ID),
360 QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
361 UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
362 QTY_REMAINING = decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, QTY_REMAINING, p_QTY_REMAINING),
363 SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
364 LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
365 MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
366 LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
367 LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
368 INSTALLATION_DATE = decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, INSTALLATION_DATE, p_INSTALLATION_DATE),
369 IN_SERVICE_DATE = decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, IN_SERVICE_DATE, p_IN_SERVICE_DATE),
370 EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
371 VERSION_LABEL = decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, VERSION_LABEL, p_VERSION_LABEL),
372 TRANSACTION_SYSTEM_ID = decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, TRANSACTION_SYSTEM_ID, p_TRANSACTION_SYSTEM_ID),
376 ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
373 SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
374 RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
375 ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
377 PRESERVE_DETAIL_FLAG = decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, PRESERVE_DETAIL_FLAG, p_PRESERVE_DETAIL_FLAG),
378 CHANGED_INSTANCE_ID = decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, CHANGED_INSTANCE_ID, p_CHANGED_INSTANCE_ID),
379 REFERENCE_SOURCE_ID = decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_ID, p_REFERENCE_SOURCE_ID),
380 REFERENCE_SOURCE_LINE_ID = decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_LINE_ID, p_REFERENCE_SOURCE_LINE_ID),
381 REFERENCE_SOURCE_DATE = decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, REFERENCE_SOURCE_DATE, p_REFERENCE_SOURCE_DATE),
382 CSI_TRANSACTION_ID = decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, CSI_TRANSACTION_ID, p_CSI_TRANSACTION_ID),
383 SOURCE_TXN_LINE_DETAIL_ID = decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, SOURCE_TXN_LINE_DETAIL_ID, p_SOURCE_TXN_LINE_DETAIL_ID),
384 INV_MTL_TRANSACTION_ID = decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, INV_MTL_TRANSACTION_ID, p_INV_MTL_TRANSACTION_ID),
385 PROCESSING_STATUS = decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, PROCESSING_STATUS, p_PROCESSING_STATUS),
386 ERROR_CODE = decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, ERROR_CODE, p_ERROR_CODE),
387 ERROR_EXPLANATION = decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, ERROR_EXPLANATION, p_ERROR_EXPLANATION),
388 CONFIG_INST_HDR_ID = decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID , p_CONFIG_INST_HDR_ID),
389 CONFIG_INST_REV_NUM = decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM , p_CONFIG_INST_REV_NUM),
390 CONFIG_INST_ITEM_ID = decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID , p_CONFIG_INST_ITEM_ID),
391 CONFIG_INST_BASELINE_REV_NUM = decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM,CONFIG_INST_BASELINE_REV_NUM, p_CONFIG_INST_BASELINE_REV_NUM),
392 TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE , p_TARGET_COMMITMENT_DATE),
393 INSTANCE_DESCRIPTION = decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION , p_INSTANCE_DESCRIPTION),
394 INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
395 INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
396 CASCADE_OWNER_FLAG = decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, CASCADE_OWNER_FLAG, p_CASCADE_OWNER_FLAG),
397 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
398 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
399 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
400 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
401 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
402 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
403 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
404 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
405 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
406 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
407 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
408 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
409 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
410 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
411 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
412 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
413 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
414 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
415 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
416 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
417 OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
418 CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
419 INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
420 PARENT_INSTANCE_ID = decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, PARENT_INSTANCE_ID, p_PARENT_INSTANCE_ID),
421 ASSC_TXN_LINE_DETAIL_ID = decode( p_ASSC_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, ASSC_TXN_LINE_DETAIL_ID, p_ASSC_TXN_LINE_DETAIL_ID),
422 OVERRIDING_CSI_TXN_ID = decode( p_OVERRIDING_CSI_TXN_ID, FND_API.G_MISS_NUM, OVERRIDING_CSI_TXN_ID, p_OVERRIDING_CSI_TXN_ID)
423 where TXN_LINE_DETAIL_ID = p_TXN_LINE_DETAIL_ID;
424
425 If (SQL%NOTFOUND) then
426 RAISE NO_DATA_FOUND;
427 End If;
428 END Update_Row;
432 IS
429
430 PROCEDURE Delete_Row(
431 p_TXN_LINE_DETAIL_ID NUMBER)
433 BEGIN
434 DELETE FROM CSI_T_TXN_LINE_DETAILS
435 WHERE TXN_LINE_DETAIL_ID = p_TXN_LINE_DETAIL_ID;
436 If (SQL%NOTFOUND) then
437 RAISE NO_DATA_FOUND;
438 End If;
439 END Delete_Row;
440
441 PROCEDURE Lock_Row(
442 p_TXN_LINE_DETAIL_ID NUMBER,
443 p_TRANSACTION_LINE_ID NUMBER,
444 p_SUB_TYPE_ID NUMBER,
445 p_INSTANCE_EXISTS_FLAG VARCHAR2,
446 p_SOURCE_TRANSACTION_FLAG VARCHAR2,
447 p_INSTANCE_ID NUMBER,
448 p_CSI_SYSTEM_ID NUMBER,
449 p_INVENTORY_ITEM_ID NUMBER,
450 p_INV_ORGANIZATION_ID NUMBER,
451 p_INVENTORY_REVISION VARCHAR2,
452 p_INSTANCE_TYPE_CODE VARCHAR2,
453 p_ITEM_CONDITION_ID NUMBER,
454 p_QUANTITY NUMBER,
455 p_UNIT_OF_MEASURE VARCHAR2,
456 p_QTY_REMAINING NUMBER,
457 p_SERIAL_NUMBER VARCHAR2,
458 p_LOT_NUMBER VARCHAR2,
459 p_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
460 p_LOCATION_TYPE_CODE VARCHAR2,
461 p_LOCATION_ID NUMBER,
462 p_INSTALLATION_DATE DATE,
463 p_IN_SERVICE_DATE DATE,
464 p_EXTERNAL_REFERENCE VARCHAR2,
465 p_VERSION_LABEL VARCHAR2,
466 p_TRANSACTION_SYSTEM_ID NUMBER,
467 p_SELLABLE_FLAG VARCHAR2,
468 p_RETURN_BY_DATE DATE,
469 p_ACTIVE_START_DATE DATE,
470 p_ACTIVE_END_DATE DATE,
471 p_PRESERVE_DETAIL_FLAG VARCHAR2,
472 p_CHANGED_INSTANCE_ID NUMBER,
473 p_REFERENCE_SOURCE_ID NUMBER,
474 p_REFERENCE_SOURCE_LINE_ID NUMBER,
475 p_REFERENCE_SOURCE_DATE DATE,
476 p_CSI_TRANSACTION_ID NUMBER,
477 p_SOURCE_TXN_LINE_DETAIL_ID NUMBER,
478 p_INV_MTL_TRANSACTION_ID NUMBER,
479 p_PROCESSING_STATUS VARCHAR2,
480 p_ERROR_CODE VARCHAR2,
481 p_ERROR_EXPLANATION VARCHAR2,
482 p_CONFIG_INST_HDR_ID NUMBER ,
483 p_CONFIG_INST_REV_NUM NUMBER ,
484 p_CONFIG_INST_ITEM_ID NUMBER ,
485 p_CONFIG_INST_BASELINE_REV_NUM NUMBER ,
486 p_TARGET_COMMITMENT_DATE DATE ,
487 p_INSTANCE_DESCRIPTION VARCHAR2 ,
488 p_INSTALL_LOCATION_TYPE_CODE VARCHAR2,
489 p_INSTALL_LOCATION_ID NUMBER,
490 p_CASCADE_OWNER_FLAG VARCHAR2,-- bug 2972082
491 p_ATTRIBUTE1 VARCHAR2,
492 p_ATTRIBUTE2 VARCHAR2,
493 p_ATTRIBUTE3 VARCHAR2,
494 p_ATTRIBUTE4 VARCHAR2,
495 p_ATTRIBUTE5 VARCHAR2,
496 p_ATTRIBUTE6 VARCHAR2,
497 p_ATTRIBUTE7 VARCHAR2,
498 p_ATTRIBUTE8 VARCHAR2,
499 p_ATTRIBUTE9 VARCHAR2,
500 p_ATTRIBUTE10 VARCHAR2,
501 p_ATTRIBUTE11 VARCHAR2,
502 p_ATTRIBUTE12 VARCHAR2,
503 p_ATTRIBUTE13 VARCHAR2,
504 p_ATTRIBUTE14 VARCHAR2,
505 p_ATTRIBUTE15 VARCHAR2,
506 p_CREATED_BY NUMBER,
507 p_CREATION_DATE DATE,
508 p_LAST_UPDATED_BY NUMBER,
509 p_LAST_UPDATE_DATE DATE,
510 p_LAST_UPDATE_LOGIN NUMBER,
511 p_OBJECT_VERSION_NUMBER NUMBER,
512 p_CONTEXT VARCHAR2,
513 p_INSTANCE_STATUS_ID NUMBER,
514 p_PARENT_INSTANCE_ID NUMBER,
515 p_ASSC_TXN_LINE_DETAIL_ID NUMBER,
516 p_OVERRIDING_CSI_TXN_ID NUMBER)
517
518 IS
519 CURSOR C IS
520 SELECT *
521 FROM CSI_T_TXN_LINE_DETAILS
522 WHERE TXN_LINE_DETAIL_ID = p_TXN_LINE_DETAIL_ID
523 FOR UPDATE of TXN_LINE_DETAIL_ID NOWAIT;
524 Recinfo C%ROWTYPE;
525 BEGIN
526 OPEN C;
527 FETCH C INTO Recinfo;
528 If (C%NOTFOUND) then
529 CLOSE C;
530 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
531 APP_EXCEPTION.RAISE_EXCEPTION;
532 End If;
533 CLOSE C;
534 if (
535 ( Recinfo.TXN_LINE_DETAIL_ID = p_TXN_LINE_DETAIL_ID)
536 AND ( ( Recinfo.TRANSACTION_LINE_ID = p_TRANSACTION_LINE_ID)
537 OR ( ( Recinfo.TRANSACTION_LINE_ID IS NULL )
538 AND ( p_TRANSACTION_LINE_ID IS NULL )))
539 AND ( ( Recinfo.SUB_TYPE_ID = p_SUB_TYPE_ID)
540 OR ( ( Recinfo.SUB_TYPE_ID IS NULL )
541 AND ( p_SUB_TYPE_ID IS NULL )))
542 AND ( ( Recinfo.INSTANCE_EXISTS_FLAG = p_INSTANCE_EXISTS_FLAG)
543 OR ( ( Recinfo.INSTANCE_EXISTS_FLAG IS NULL )
544 AND ( p_INSTANCE_EXISTS_FLAG IS NULL )))
545 AND ( ( Recinfo.SOURCE_TRANSACTION_FLAG = p_SOURCE_TRANSACTION_FLAG)
546 OR ( ( Recinfo.SOURCE_TRANSACTION_FLAG IS NULL )
547 AND ( p_SOURCE_TRANSACTION_FLAG IS NULL )))
548 AND ( ( Recinfo.INSTANCE_ID = p_INSTANCE_ID)
549 OR ( ( Recinfo.INSTANCE_ID IS NULL )
550 AND ( p_INSTANCE_ID IS NULL )))
551 AND ( ( Recinfo.CSI_SYSTEM_ID = p_CSI_SYSTEM_ID)
552 OR ( ( Recinfo.CSI_SYSTEM_ID IS NULL )
553 AND ( p_CSI_SYSTEM_ID IS NULL )))
554 AND ( ( Recinfo.INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID)
555 OR ( ( Recinfo.INVENTORY_ITEM_ID IS NULL )
559 AND ( p_INV_ORGANIZATION_ID IS NULL )))
556 AND ( p_INVENTORY_ITEM_ID IS NULL )))
557 AND ( ( Recinfo.INV_ORGANIZATION_ID = p_INV_ORGANIZATION_ID)
558 OR ( ( Recinfo.INV_ORGANIZATION_ID IS NULL )
560 AND ( ( Recinfo.INVENTORY_REVISION = p_INVENTORY_REVISION)
561 OR ( ( Recinfo.INVENTORY_REVISION IS NULL )
562 AND ( p_INVENTORY_REVISION IS NULL )))
563 AND ( ( Recinfo.INSTANCE_TYPE_CODE = p_INSTANCE_TYPE_CODE)
564 OR ( ( Recinfo.INSTANCE_TYPE_CODE IS NULL )
565 AND ( p_INSTANCE_TYPE_CODE IS NULL )))
566 AND ( ( Recinfo.ITEM_CONDITION_ID = p_ITEM_CONDITION_ID)
567 OR ( ( Recinfo.ITEM_CONDITION_ID IS NULL )
568 AND ( p_ITEM_CONDITION_ID IS NULL )))
569 AND ( ( Recinfo.QUANTITY = p_QUANTITY)
570 OR ( ( Recinfo.QUANTITY IS NULL )
571 AND ( p_QUANTITY IS NULL )))
572 AND ( ( Recinfo.UNIT_OF_MEASURE = p_UNIT_OF_MEASURE)
573 OR ( ( Recinfo.UNIT_OF_MEASURE IS NULL )
574 AND ( p_UNIT_OF_MEASURE IS NULL )))
575 AND ( ( Recinfo.QTY_REMAINING = p_QTY_REMAINING)
576 OR ( ( Recinfo.QTY_REMAINING IS NULL )
577 AND ( p_QTY_REMAINING IS NULL )))
578 AND ( ( Recinfo.SERIAL_NUMBER = p_SERIAL_NUMBER)
579 OR ( ( Recinfo.SERIAL_NUMBER IS NULL )
580 AND ( p_SERIAL_NUMBER IS NULL )))
581 AND ( ( Recinfo.LOT_NUMBER = p_LOT_NUMBER)
582 OR ( ( Recinfo.LOT_NUMBER IS NULL )
583 AND ( p_LOT_NUMBER IS NULL )))
584 AND ( ( Recinfo.MFG_SERIAL_NUMBER_FLAG = p_MFG_SERIAL_NUMBER_FLAG)
585 OR ( ( Recinfo.MFG_SERIAL_NUMBER_FLAG IS NULL )
586 AND ( p_MFG_SERIAL_NUMBER_FLAG IS NULL )))
587 AND ( ( Recinfo.LOCATION_TYPE_CODE = p_LOCATION_TYPE_CODE)
588 OR ( ( Recinfo.LOCATION_TYPE_CODE IS NULL )
589 AND ( p_LOCATION_TYPE_CODE IS NULL )))
590 AND ( ( Recinfo.LOCATION_ID = p_LOCATION_ID)
591 OR ( ( Recinfo.LOCATION_ID IS NULL )
592 AND ( p_LOCATION_ID IS NULL )))
593 AND ( ( Recinfo.INSTALLATION_DATE = p_INSTALLATION_DATE)
594 OR ( ( Recinfo.INSTALLATION_DATE IS NULL )
595 AND ( p_INSTALLATION_DATE IS NULL )))
596 AND ( ( Recinfo.IN_SERVICE_DATE = p_IN_SERVICE_DATE)
597 OR ( ( Recinfo.IN_SERVICE_DATE IS NULL )
598 AND ( p_IN_SERVICE_DATE IS NULL )))
599 AND ( ( Recinfo.EXTERNAL_REFERENCE = p_EXTERNAL_REFERENCE)
600 OR ( ( Recinfo.EXTERNAL_REFERENCE IS NULL )
601 AND ( p_EXTERNAL_REFERENCE IS NULL )))
602 AND ( ( Recinfo.VERSION_LABEL = p_VERSION_LABEL)
603 OR ( ( Recinfo.VERSION_LABEL IS NULL )
604 AND ( p_VERSION_LABEL IS NULL )))
605 AND ( ( Recinfo.TRANSACTION_SYSTEM_ID = p_TRANSACTION_SYSTEM_ID)
606 OR ( ( Recinfo.TRANSACTION_SYSTEM_ID IS NULL )
607 AND ( p_TRANSACTION_SYSTEM_ID IS NULL )))
608 AND ( ( Recinfo.SELLABLE_FLAG = p_SELLABLE_FLAG)
609 OR ( ( Recinfo.SELLABLE_FLAG IS NULL )
610 AND ( p_SELLABLE_FLAG IS NULL )))
611 AND ( ( Recinfo.RETURN_BY_DATE = p_RETURN_BY_DATE)
612 OR ( ( Recinfo.RETURN_BY_DATE IS NULL )
613 AND ( p_RETURN_BY_DATE IS NULL )))
614 AND ( ( Recinfo.ACTIVE_START_DATE = p_ACTIVE_START_DATE)
615 OR ( ( Recinfo.ACTIVE_START_DATE IS NULL )
616 AND ( p_ACTIVE_START_DATE IS NULL )))
617 AND ( ( Recinfo.ACTIVE_END_DATE = p_ACTIVE_END_DATE)
618 OR ( ( Recinfo.ACTIVE_END_DATE IS NULL )
619 AND ( p_ACTIVE_END_DATE IS NULL )))
620 AND ( ( Recinfo.PRESERVE_DETAIL_FLAG = p_PRESERVE_DETAIL_FLAG)
621 OR ( ( Recinfo.PRESERVE_DETAIL_FLAG IS NULL )
622 AND ( p_PRESERVE_DETAIL_FLAG IS NULL )))
623 AND ( ( Recinfo.CHANGED_INSTANCE_ID = p_CHANGED_INSTANCE_ID)
624 OR ( ( Recinfo.CHANGED_INSTANCE_ID IS NULL )
625 AND ( p_CHANGED_INSTANCE_ID IS NULL )))
626 AND ( ( Recinfo.REFERENCE_SOURCE_ID = p_REFERENCE_SOURCE_ID)
627 OR ( ( Recinfo.REFERENCE_SOURCE_ID IS NULL )
628 AND ( p_REFERENCE_SOURCE_ID IS NULL )))
629 AND ( ( Recinfo.REFERENCE_SOURCE_LINE_ID = p_REFERENCE_SOURCE_LINE_ID)
630 OR ( ( Recinfo.REFERENCE_SOURCE_LINE_ID IS NULL )
631 AND ( p_REFERENCE_SOURCE_LINE_ID IS NULL )))
632 AND ( ( Recinfo.REFERENCE_SOURCE_DATE = p_REFERENCE_SOURCE_DATE)
633 OR ( ( Recinfo.REFERENCE_SOURCE_DATE IS NULL )
634 AND ( p_REFERENCE_SOURCE_DATE IS NULL )))
635 AND ( ( Recinfo.CSI_TRANSACTION_ID = p_CSI_TRANSACTION_ID)
636 OR ( ( Recinfo.CSI_TRANSACTION_ID IS NULL )
637 AND ( p_CSI_TRANSACTION_ID IS NULL )))
638 AND ( ( Recinfo.SOURCE_TXN_LINE_DETAIL_ID = p_SOURCE_TXN_LINE_DETAIL_ID)
639 OR ( ( Recinfo.SOURCE_TXN_LINE_DETAIL_ID IS NULL )
640 AND ( p_SOURCE_TXN_LINE_DETAIL_ID IS NULL )))
641 AND ( ( Recinfo.INV_MTL_TRANSACTION_ID = p_INV_MTL_TRANSACTION_ID)
642 OR ( ( Recinfo.INV_MTL_TRANSACTION_ID IS NULL )
643 AND ( p_INV_MTL_TRANSACTION_ID IS NULL )))
644 AND ( ( Recinfo.PROCESSING_STATUS = p_PROCESSING_STATUS)
645 OR ( ( Recinfo.PROCESSING_STATUS IS NULL )
646 AND ( p_PROCESSING_STATUS IS NULL )))
650 AND ( ( Recinfo.ERROR_EXPLANATION = p_ERROR_EXPLANATION)
647 AND ( ( Recinfo.ERROR_CODE = p_ERROR_CODE)
648 OR ( ( Recinfo.ERROR_CODE IS NULL )
649 AND ( p_ERROR_CODE IS NULL )))
651 OR ( ( Recinfo.ERROR_EXPLANATION IS NULL )
652 AND ( p_ERROR_EXPLANATION IS NULL )))
653 AND ( ( Recinfo.CONFIG_INST_HDR_ID = p_CONFIG_INST_HDR_ID)
654 OR ( ( Recinfo.CONFIG_INST_HDR_ID IS NULL )
655 AND ( p_CONFIG_INST_HDR_ID IS NULL )))
656 AND ( ( Recinfo.CONFIG_INST_REV_NUM = p_CONFIG_INST_REV_NUM)
657 OR ( ( Recinfo.CONFIG_INST_REV_NUM IS NULL )
658 AND ( p_CONFIG_INST_REV_NUM IS NULL )))
659 AND ( ( Recinfo.CONFIG_INST_ITEM_ID = p_CONFIG_INST_ITEM_ID)
660 OR ( ( Recinfo.CONFIG_INST_ITEM_ID IS NULL )
661 AND ( p_CONFIG_INST_ITEM_ID IS NULL )))
662 AND ( ( Recinfo.CONFIG_INST_BASELINE_REV_NUM = p_CONFIG_INST_BASELINE_REV_NUM)
663 OR ( ( Recinfo.CONFIG_INST_BASELINE_REV_NUM IS NULL )
664 AND ( p_CONFIG_INST_BASELINE_REV_NUM IS NULL )))
665 AND ( ( Recinfo.TARGET_COMMITMENT_DATE = p_TARGET_COMMITMENT_DATE)
666 OR ( ( Recinfo.TARGET_COMMITMENT_DATE IS NULL )
667 AND ( p_TARGET_COMMITMENT_DATE IS NULL )))
668 AND ( ( Recinfo.INSTANCE_DESCRIPTION = p_INSTANCE_DESCRIPTION)
669 OR ( ( Recinfo.INSTANCE_DESCRIPTION IS NULL )
670 AND ( p_INSTANCE_DESCRIPTION IS NULL )))
671 AND ( ( Recinfo.INSTALL_LOCATION_TYPE_CODE = p_INSTALL_LOCATION_TYPE_CODE)
672 OR ( ( Recinfo.INSTALL_LOCATION_TYPE_CODE IS NULL )
673 AND ( p_INSTALL_LOCATION_TYPE_CODE IS NULL )))
674 AND ( ( Recinfo.INSTALL_LOCATION_ID = p_INSTALL_LOCATION_ID)
675 OR ( ( Recinfo.INSTALL_LOCATION_ID IS NULL )
676 AND ( p_INSTALL_LOCATION_ID IS NULL )))
677 AND ( ( Recinfo.CASCADE_OWNER_FLAG = p_CASCADE_OWNER_FLAG)
678 OR ( ( Recinfo.CASCADE_OWNER_FLAG IS NULL )
679 AND ( p_CASCADE_OWNER_FLAG IS NULL )))
680 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
681 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
682 AND ( p_ATTRIBUTE1 IS NULL )))
683 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
684 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
685 AND ( p_ATTRIBUTE2 IS NULL )))
686 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
687 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
688 AND ( p_ATTRIBUTE3 IS NULL )))
689 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
690 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
691 AND ( p_ATTRIBUTE4 IS NULL )))
692 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
693 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
694 AND ( p_ATTRIBUTE5 IS NULL )))
695 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
696 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
697 AND ( p_ATTRIBUTE6 IS NULL )))
698 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
699 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
700 AND ( p_ATTRIBUTE7 IS NULL )))
701 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
702 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
703 AND ( p_ATTRIBUTE8 IS NULL )))
704 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
705 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
706 AND ( p_ATTRIBUTE9 IS NULL )))
707 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
708 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
709 AND ( p_ATTRIBUTE10 IS NULL )))
710 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
711 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
712 AND ( p_ATTRIBUTE11 IS NULL )))
713 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
714 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
715 AND ( p_ATTRIBUTE12 IS NULL )))
716 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
717 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
718 AND ( p_ATTRIBUTE13 IS NULL )))
719 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
720 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
721 AND ( p_ATTRIBUTE14 IS NULL )))
722 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
723 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
724 AND ( p_ATTRIBUTE15 IS NULL )))
725 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
726 OR ( ( Recinfo.CREATED_BY IS NULL )
727 AND ( p_CREATED_BY IS NULL )))
728 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
729 OR ( ( Recinfo.CREATION_DATE IS NULL )
730 AND ( p_CREATION_DATE IS NULL )))
731 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
732 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
733 AND ( p_LAST_UPDATED_BY IS NULL )))
734 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
735 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
736 AND ( p_LAST_UPDATE_DATE IS NULL )))
737 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
738 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
739 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
740 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
741 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
742 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
743 AND ( ( Recinfo.CONTEXT = p_CONTEXT)
744 OR ( ( Recinfo.CONTEXT IS NULL )
745 AND ( p_CONTEXT IS NULL )))
746 AND ( ( Recinfo.INSTANCE_STATUS_ID = p_INSTANCE_STATUS_ID)
747 OR ( ( Recinfo.INSTANCE_STATUS_ID IS NULL )
748 AND ( p_INSTANCE_STATUS_ID IS NULL )))
749 AND ( ( Recinfo.PARENT_INSTANCE_ID = p_PARENT_INSTANCE_ID)
750 OR ( ( Recinfo.PARENT_INSTANCE_ID IS NULL )
751 AND ( p_PARENT_INSTANCE_ID IS NULL )))
752 AND ( ( Recinfo.ASSC_TXN_LINE_DETAIL_ID = p_ASSC_TXN_LINE_DETAIL_ID)
753 OR ( ( Recinfo.ASSC_TXN_LINE_DETAIL_ID IS NULL )
754 AND ( p_ASSC_TXN_LINE_DETAIL_ID IS NULL )))
755 AND ( ( Recinfo.OVERRIDING_CSI_TXN_ID = p_OVERRIDING_CSI_TXN_ID)
756 OR ( ( Recinfo.OVERRIDING_CSI_TXN_ID IS NULL )
757 AND ( p_OVERRIDING_CSI_TXN_ID IS NULL )))
758 ) then
759 return;
760 else
761 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
762 APP_EXCEPTION.RAISE_EXCEPTION;
763 End If;
764 END Lock_Row;
765
766 End CSI_T_TXN_LINE_DETAILS_PKG;