[Home] [Help]
PACKAGE BODY: APPS.CSD_REPAIRS_PKG
Source
1 PACKAGE BODY CSD_REPAIRS_PKG as
2 /* $Header: csdtdrab.pls 120.14.12020000.2 2013/01/23 20:53:16 vicli ship $ */
3 -- Start of Comments
4 -- Package name : CSD_REPAIRS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIRS_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtdrab.pls';
13 l_debug NUMBER ;
14
15 PROCEDURE Insert_Row(
16 px_REPAIR_LINE_ID IN OUT NOCOPY NUMBER
17 ,p_REQUEST_ID NUMBER
18 ,p_PROGRAM_ID NUMBER
19 ,p_PROGRAM_APPLICATION_ID NUMBER
20 ,p_PROGRAM_UPDATE_DATE DATE
21 ,p_CREATED_BY NUMBER
22 ,p_CREATION_DATE DATE
23 ,p_LAST_UPDATED_BY NUMBER
24 ,p_LAST_UPDATE_DATE DATE
25 ,p_LAST_UPDATE_LOGIN NUMBER
26 ,p_REPAIR_NUMBER VARCHAR2
27 ,p_INCIDENT_ID NUMBER
28 ,p_INVENTORY_ITEM_ID NUMBER
29 ,p_CUSTOMER_PRODUCT_ID NUMBER
30 ,p_UNIT_OF_MEASURE VARCHAR2
31 ,p_REPAIR_TYPE_ID NUMBER
32 -- RESOURCE_GROUP Added by Vijay 10/28/2004
33 ,p_RESOURCE_GROUP NUMBER
34 ,p_RESOURCE_ID NUMBER
35 ,p_INSTANCE_ID NUMBER
36 ,p_PROJECT_ID NUMBER
37 ,p_TASK_ID NUMBER
41 ,p_STATUS VARCHAR2
38 ,p_UNIT_NUMBER VARCHAR2 -- rfieldma, project integration
39 ,p_CONTRACT_LINE_ID NUMBER
40 ,p_QUANTITY NUMBER
42 ,p_APPROVAL_REQUIRED_FLAG VARCHAR2
43 ,p_DATE_CLOSED DATE
44 ,p_QUANTITY_IN_WIP NUMBER
45 ,p_APPROVAL_STATUS VARCHAR2
46 ,p_QUANTITY_RCVD NUMBER
47 ,p_QUANTITY_SHIPPED NUMBER
48 ,p_CURRENCY_CODE VARCHAR2
49 ,p_DEFAULT_PO_NUM VARCHAR2 := NULL
50 ,p_SERIAL_NUMBER VARCHAR2
51 ,p_PROMISE_DATE DATE
52 ,p_ATTRIBUTE_CATEGORY VARCHAR2
53 ,p_ATTRIBUTE1 VARCHAR2
54 ,p_ATTRIBUTE2 VARCHAR2
55 ,p_ATTRIBUTE3 VARCHAR2
56 ,p_ATTRIBUTE4 VARCHAR2
57 ,p_ATTRIBUTE5 VARCHAR2
58 ,p_ATTRIBUTE6 VARCHAR2
59 ,p_ATTRIBUTE7 VARCHAR2
60 ,p_ATTRIBUTE8 VARCHAR2
61 ,p_ATTRIBUTE9 VARCHAR2
62 ,p_ATTRIBUTE10 VARCHAR2
63 ,p_ATTRIBUTE11 VARCHAR2
64 ,p_ATTRIBUTE12 VARCHAR2
65 ,p_ATTRIBUTE13 VARCHAR2
66 ,p_ATTRIBUTE14 VARCHAR2
67 ,p_ATTRIBUTE15 VARCHAR2
68 --bug#7497907, 12.1 FP, subhat
69 ,p_ATTRIBUTE16 VARCHAR2
70 ,p_ATTRIBUTE17 VARCHAR2
71 ,p_ATTRIBUTE18 VARCHAR2
72 ,p_ATTRIBUTE19 VARCHAR2
73 ,p_ATTRIBUTE20 VARCHAR2
74 ,p_ATTRIBUTE21 VARCHAR2
75 ,p_ATTRIBUTE22 VARCHAR2
76 ,p_ATTRIBUTE23 VARCHAR2
77 ,p_ATTRIBUTE24 VARCHAR2
78 ,p_ATTRIBUTE25 VARCHAR2
79 ,p_ATTRIBUTE26 VARCHAR2
80 ,p_ATTRIBUTE27 VARCHAR2
81 ,p_ATTRIBUTE28 VARCHAR2
82 ,p_ATTRIBUTE29 VARCHAR2
83 ,p_ATTRIBUTE30 VARCHAR2
84 ,p_ORDER_LINE_ID NUMBER
85 ,p_ORIGINAL_SOURCE_REFERENCE VARCHAR2
86 ,p_STATUS_REASON_CODE VARCHAR2
87 ,p_OBJECT_VERSION_NUMBER NUMBER
88 ,p_AUTO_PROCESS_RMA VARCHAR2
89 ,p_REPAIR_MODE VARCHAR2
90 ,p_ITEM_REVISION VARCHAR2
91 ,p_REPAIR_GROUP_ID NUMBER
92 ,p_RO_TXN_STATUS VARCHAR2
93 ,p_ORIGINAL_SOURCE_HEADER_ID NUMBER
94 ,p_ORIGINAL_SOURCE_LINE_ID NUMBER
95 ,p_PRICE_LIST_HEADER_ID NUMBER
96 ,p_Supercession_inv_item_id Number
97 ,p_flow_status_Id Number
98 ,p_Inventory_Org_Id Number
99 ,p_PROBLEM_DESCRIPTION VARCHAR2 -- swai: bug 4666344
100 ,p_RO_PRIORITY_CODE VARCHAR2 -- swai: R12
101 ,p_RESOLVE_BY_DATE DATE -- rfieldma: 5355051
102 ,p_BULLETIN_CHECK_DATE DATE --- := FND_API.G_MISS_DATE
103 ,p_ESCALATION_CODE VARCHAR2 --:= FND_API.G_MISS_CHAR
104 ,p_RO_WARRANTY_STATUS_CODE VARCHAR2
105 ,p_REPAIR_YIELD_QUANTITY NUMBER --bug#6692459
106 ,p_RETURN_ATTRIBUTE_CATEGORY VARCHAR2 -- 12.2, returns portal project, subhat
107 ,p_RETURN_ATTRIBUTE1 VARCHAR2
108 ,p_RETURN_ATTRIBUTE2 VARCHAR2
109 ,p_RETURN_ATTRIBUTE3 VARCHAR2
110 ,p_RETURN_ATTRIBUTE4 VARCHAR2
111 ,p_RETURN_ATTRIBUTE5 VARCHAR2
112 ,p_RETURN_ATTRIBUTE6 VARCHAR2
113 ,p_RETURN_ATTRIBUTE7 VARCHAR2
114 ,p_RETURN_ATTRIBUTE8 VARCHAR2
115 ,p_RETURN_ATTRIBUTE9 VARCHAR2
116 ,p_RETURN_ATTRIBUTE10 VARCHAR2
117 ,p_RETURN_ATTRIBUTE11 VARCHAR2
118 ,p_RETURN_ATTRIBUTE12 VARCHAR2
119 ,p_RETURN_ATTRIBUTE13 VARCHAR2
120 ,p_RETURN_ATTRIBUTE14 VARCHAR2
121 ,p_RETURN_ATTRIBUTE15 VARCHAR2
122 ,p_RETURN_ATTRIBUTE16 VARCHAR2
123 ,p_RETURN_ATTRIBUTE17 VARCHAR2
124 ,p_RETURN_ATTRIBUTE18 VARCHAR2
125 ,p_RETURN_ATTRIBUTE19 VARCHAR2
126 ,p_RETURN_ATTRIBUTE20 VARCHAR2
127 ,p_RETURN_ATTRIBUTE21 VARCHAR2
128 ,p_RETURN_ATTRIBUTE22 VARCHAR2
129 ,p_RETURN_ATTRIBUTE23 VARCHAR2
130 ,p_RETURN_ATTRIBUTE24 VARCHAR2
131 ,p_RETURN_ATTRIBUTE25 VARCHAR2
132 ,p_RETURN_ATTRIBUTE26 VARCHAR2
133 ,p_RETURN_ATTRIBUTE27 VARCHAR2
134 ,p_RETURN_ATTRIBUTE28 VARCHAR2
135 ,p_RETURN_ATTRIBUTE29 VARCHAR2
136 ,p_RETURN_ATTRIBUTE30 VARCHAR2
137 ,p_waybill_no VARCHAR2
138 ,p_return_type_id VARCHAR2
139 ,p_PARENT_REPAIR_LINE_ID NUMBER -- bug#13698799 auto create ro, parent ro
140 )
141
142 IS
143 CURSOR C2 IS SELECT CSD_REPAIRS_S1.nextval FROM sys.dual;
144 BEGIN
145 If (px_REPAIR_LINE_ID IS NULL) OR (px_REPAIR_LINE_ID = FND_API.G_MISS_NUM) then
146 OPEN C2;
147 FETCH C2 INTO px_REPAIR_LINE_ID;
148 CLOSE C2;
149 End If;
150 INSERT INTO CSD_REPAIRS(
151 REPAIR_LINE_ID
152 ,REQUEST_ID
153 ,PROGRAM_ID
154 ,PROGRAM_APPLICATION_ID
155 ,PROGRAM_UPDATE_DATE
156 ,CREATED_BY
157 ,CREATION_DATE
161 ,REPAIR_NUMBER
158 ,LAST_UPDATED_BY
159 ,LAST_UPDATE_DATE
160 ,LAST_UPDATE_LOGIN
162 ,INCIDENT_ID
163 ,INVENTORY_ITEM_ID
164 ,CUSTOMER_PRODUCT_ID
165 ,UNIT_OF_MEASURE
166 ,REPAIR_TYPE_ID
167 -- RESOURCE_GROUP Added by Vijay 10/28/2004
168 ,OWNING_ORGANIZATION_ID
169 ,RESOURCE_ID
170 ,INSTANCE_ID
171 ,PROJECT_ID
172 ,TASK_ID
173 ,CONTRACT_LINE_ID
174 ,QUANTITY
175 ,STATUS
176 ,APPROVAL_REQUIRED_FLAG
177 ,DATE_CLOSED
178 ,QUANTITY_IN_WIP
179 ,APPROVAL_STATUS
180 ,QUANTITY_RCVD
181 ,QUANTITY_SHIPPED
182 ,CURRENCY_CODE
183 ,DEFAULT_PO_NUM
184 ,SERIAL_NUMBER
185 ,PROMISE_DATE
186 ,ATTRIBUTE_CATEGORY
187 ,ATTRIBUTE1
188 ,ATTRIBUTE2
189 ,ATTRIBUTE3
190 ,ATTRIBUTE4
191 ,ATTRIBUTE5
192 ,ATTRIBUTE6
193 ,ATTRIBUTE7
194 ,ATTRIBUTE8
195 ,ATTRIBUTE9
196 ,ATTRIBUTE10
197 ,ATTRIBUTE11
198 ,ATTRIBUTE12
199 ,ATTRIBUTE13
200 ,ATTRIBUTE14
201 ,ATTRIBUTE15
202 ,ORDER_LINE_ID
203 ,ORIGINAL_SOURCE_REFERENCE
204 ,STATUS_REASON_CODE
205 ,OBJECT_VERSION_NUMBER
206 ,AUTO_PROCESS_RMA
207 ,REPAIR_MODE
208 ,ITEM_REVISION
209 ,REPAIR_GROUP_ID
210 ,RO_TXN_STATUS
211 ,ORIGINAL_SOURCE_HEADER_ID
212 ,ORIGINAL_SOURCE_LINE_ID
213 ,PRICE_LIST_HEADER_ID
214 ,Supercession_Inv_Item_Id
215 ,flow_status_Id
216 ,Inventory_Org_Id
217 ,PROBLEM_DESCRIPTION -- swai: bug 4666344
218 ,UNIT_NUMBER -- rfieldma, project integration
219 ,RO_PRIORITY_CODE -- swai: R12
220 ,RESOLVE_BY_DATE -- rfieldma: 5355051
221 ,BULLETIN_CHECK_DATE
222 ,ESCALATION_CODE
223 ,RO_WARRANTY_STATUS_CODE
224 ,REPAIR_YIELD_QUANTITY --bug#6692459
225 --bug#7497907, 12.1 FP, subhat
226 ,ATTRIBUTE16
227 ,ATTRIBUTE17
228 ,ATTRIBUTE18
229 ,ATTRIBUTE19
230 ,ATTRIBUTE20
231 ,ATTRIBUTE21
232 ,ATTRIBUTE22
233 ,ATTRIBUTE23
234 ,ATTRIBUTE24
235 ,ATTRIBUTE25
236 ,ATTRIBUTE26
237 ,ATTRIBUTE27
238 ,ATTRIBUTE28
239 ,ATTRIBUTE29
240 ,ATTRIBUTE30
241 ,RETURN_ATTRIBUTE_CATEGORY --12.2 returns portal project, subhat
242 ,RETURN_ATTRIBUTE1
243 ,RETURN_ATTRIBUTE2
244 ,RETURN_ATTRIBUTE3
245 ,RETURN_ATTRIBUTE4
246 ,RETURN_ATTRIBUTE5
247 ,RETURN_ATTRIBUTE6
248 ,RETURN_ATTRIBUTE7
249 ,RETURN_ATTRIBUTE8
250 ,RETURN_ATTRIBUTE9
251 ,RETURN_ATTRIBUTE10
252 ,RETURN_ATTRIBUTE11
253 ,RETURN_ATTRIBUTE12
254 ,RETURN_ATTRIBUTE13
255 ,RETURN_ATTRIBUTE14
256 ,RETURN_ATTRIBUTE15
257 ,RETURN_ATTRIBUTE16
258 ,RETURN_ATTRIBUTE17
259 ,RETURN_ATTRIBUTE18
260 ,RETURN_ATTRIBUTE19
261 ,RETURN_ATTRIBUTE20
262 ,RETURN_ATTRIBUTE21
263 ,RETURN_ATTRIBUTE22
264 ,RETURN_ATTRIBUTE23
265 ,RETURN_ATTRIBUTE24
266 ,RETURN_ATTRIBUTE25
267 ,RETURN_ATTRIBUTE26
268 ,RETURN_ATTRIBUTE27
269 ,RETURN_ATTRIBUTE28
270 ,RETURN_ATTRIBUTE29
271 ,RETURN_ATTRIBUTE30
272 ,waybill_no
273 ,return_type_id
274 ,PARENT_REPAIR_LINE_ID -- bug#13698799 auto create ro, parent ro
275 ) VALUES (
276 px_REPAIR_LINE_ID
277 ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
278 ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
279 ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
280 ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
281 ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
282 ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
283 ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
284 ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
285 ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
286 ,decode( p_REPAIR_NUMBER, FND_API.G_MISS_CHAR, NULL, p_REPAIR_NUMBER)
287 ,decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, NULL, p_INCIDENT_ID)
291 ,decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_TYPE_ID)
288 ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
289 ,decode( p_CUSTOMER_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_PRODUCT_ID)
290 ,decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE)
292 -- RESOURCE_GROUP Added by Vijay 10/28/2004
293 ,decode( p_RESOURCE_GROUP, FND_API.G_MISS_NUM, NULL, p_RESOURCE_GROUP)
294 ,decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID)
295 ,decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID)
296 ,decode( p_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PROJECT_ID)
297 ,decode( p_TASK_ID, FND_API.G_MISS_NUM, NULL, p_TASK_ID)
298 ,decode( p_CONTRACT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_CONTRACT_LINE_ID)
299 ,decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY)
300 ,decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS)
301 ,decode( p_APPROVAL_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL, p_APPROVAL_REQUIRED_FLAG)
302 ,decode( p_DATE_CLOSED, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DATE_CLOSED)
303 ,decode( p_QUANTITY_IN_WIP, FND_API.G_MISS_NUM, NULL, p_QUANTITY_IN_WIP)
304 ,decode( p_APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL, p_APPROVAL_STATUS)
305 ,decode( p_QUANTITY_RCVD, FND_API.G_MISS_NUM, NULL, p_QUANTITY_RCVD)
306 ,decode( p_QUANTITY_SHIPPED, FND_API.G_MISS_NUM, NULL, p_QUANTITY_SHIPPED)
307 ,decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE)
308 ,decode( p_DEFAULT_PO_NUM, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PO_NUM)
309 ,decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER)
310 ,decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROMISE_DATE)
311 ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
312 ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
313 ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
314 ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
315 ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
316 ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
317 ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
318 ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
319 ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
320 ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
321 ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
322 ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
323 ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
324 ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
325 ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
326 ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
327 ,decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_LINE_ID)
328 ,decode( p_ORIGINAL_SOURCE_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIGINAL_SOURCE_REFERENCE)
329 ,decode( p_STATUS_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_REASON_CODE)
330 ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
331 ,decode( p_AUTO_PROCESS_RMA, FND_API.G_MISS_CHAR, NULL, p_AUTO_PROCESS_RMA)
332 ,decode( p_REPAIR_MODE, FND_API.G_MISS_CHAR, NULL, p_REPAIR_MODE)
333 ,decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, p_ITEM_REVISION)
334 ,decode( p_REPAIR_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_GROUP_ID)
335 ,decode( p_RO_TXN_STATUS, FND_API.G_MISS_CHAR, NULL, p_RO_TXN_STATUS)
336 ,decode( p_ORIGINAL_SOURCE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_SOURCE_HEADER_ID)
337 ,decode( p_ORIGINAL_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_SOURCE_LINE_ID)
338 ,decode( p_PRICE_LIST_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_HEADER_ID)
339 ,decode( p_Supercession_Inv_Item_ID, FND_API.G_MISS_NUM, NULL, p_Supercession_Inv_Item_ID)
340 ,decode( p_flow_status_Id, FND_API.G_MISS_NUM, NULL, p_flow_status_Id)
341 ,decode( p_Inventory_Org_Id, FND_API.G_MISS_NUM, NULL, p_Inventory_Org_Id)
342 ,decode( p_PROBLEM_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_PROBLEM_DESCRIPTION) -- swai: bug 4666344
343 ,decode( p_UNIT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_UNIT_NUMBER) -- rfieldma, project integration
344 ,decode( p_RO_PRIORITY_CODE, FND_API.G_MISS_CHAR, NULL, p_RO_PRIORITY_CODE) -- swai: R12
345 ,decode( p_RESOLVE_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RESOLVE_BY_DATE)
346 ,decode( p_BULLETIN_CHECK_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_BULLETIN_CHECK_DATE)
347 ,decode( p_ESCALATION_CODE, FND_API.G_MISS_CHAR, NULL, p_ESCALATION_CODE)
348 ,decode( p_RO_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_RO_WARRANTY_STATUS_CODE)
349 ,decode( p_REPAIR_YIELD_QUANTITY, FND_API.G_MISS_NUM, NULL, p_REPAIR_YIELD_QUANTITY) --bug#6692459
350 --bug#7497907, 12.1 FP, subhat
351 ,decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
352 ,decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
353 ,decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
354 ,decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
355 ,decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
356 ,decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
357 ,decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
358 ,decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
359 ,decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
360 ,decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
361 ,decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
365 ,decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
362 ,decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
363 ,decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
364 ,decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
366 -- 12.2
367 ,decode( p_RETURN_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE_CATEGORY) --12.2 returns portal project, subhat
368 ,decode( p_RETURN_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE1)
369 ,decode( p_RETURN_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE2)
370 ,decode( p_RETURN_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE3)
371 ,decode( p_RETURN_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE4)
372 ,decode( p_RETURN_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE5)
373 ,decode( p_RETURN_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE6)
374 ,decode( p_RETURN_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE7)
375 ,decode( p_RETURN_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE8)
376 ,decode( p_RETURN_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE9)
377 ,decode( p_RETURN_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE10)
378 ,decode( p_RETURN_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE11)
379 ,decode( p_RETURN_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE12)
380 ,decode( p_RETURN_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE13)
381 ,decode( p_RETURN_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE14)
382 ,decode( p_RETURN_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE15)
383 ,decode( p_RETURN_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE16)
384 ,decode( p_RETURN_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE17)
385 ,decode( p_RETURN_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE18)
386 ,decode( p_RETURN_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE19)
387 ,decode( p_RETURN_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE20)
388 ,decode( p_RETURN_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE21)
389 ,decode( p_RETURN_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE22)
390 ,decode( p_RETURN_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE23)
391 ,decode( p_RETURN_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE24)
392 ,decode( p_RETURN_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE25)
393 ,decode( p_RETURN_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE26)
394 ,decode( p_RETURN_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE27)
395 ,decode( p_RETURN_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE28)
396 ,decode( p_RETURN_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE29)
397 ,decode( p_RETURN_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE30)
398 ,decode(p_waybill_no, FND_API.G_MISS_CHAR, NULL, p_waybill_no)
399 ,decode(p_return_type_id, FND_API.G_MISS_NUM, NULL, p_return_type_id)
400 ,decode(p_PARENT_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_REPAIR_LINE_ID) -- bug#13698799 auto create ro, parent ro
401 );
402 End Insert_Row;
403
404
405 /*
406 Name: Update_Row
407 Description: Procedure to update a row in the CSD_REPAIRS table,which stores RO information
408 Code Change History:
409 -- 3/21/2010 nnadig 120.10.12010000.3 : Bug fix 9291206, Removed code that updated created_by
410 when updating an RO
411 */
412 PROCEDURE Update_Row(
413 p_REPAIR_LINE_ID NUMBER
414 ,p_REQUEST_ID NUMBER
415 ,p_PROGRAM_ID NUMBER
416 ,p_PROGRAM_APPLICATION_ID NUMBER
417 ,p_PROGRAM_UPDATE_DATE DATE
418 ,p_CREATED_BY NUMBER
419 ,p_CREATION_DATE DATE
420 ,p_LAST_UPDATED_BY NUMBER
421 ,p_LAST_UPDATE_DATE DATE
422 ,p_LAST_UPDATE_LOGIN NUMBER
423 ,p_REPAIR_NUMBER VARCHAR2
424 ,p_INCIDENT_ID NUMBER
425 ,p_INVENTORY_ITEM_ID NUMBER
426 ,p_CUSTOMER_PRODUCT_ID NUMBER
427 ,p_UNIT_OF_MEASURE VARCHAR2
428 ,p_REPAIR_TYPE_ID NUMBER
429 -- RESOURCE_GROUP Added by Vijay 10/28/2004
430 ,p_RESOURCE_GROUP NUMBER
431 ,p_RESOURCE_ID NUMBER
432 ,p_INSTANCE_ID NUMBER
433 ,p_PROJECT_ID NUMBER
434 ,p_TASK_ID NUMBER
435 ,p_UNIT_NUMBER VARCHAR2 -- rfieldma, project integration
436 ,p_CONTRACT_LINE_ID NUMBER
437 ,p_QUANTITY NUMBER
438 ,p_STATUS VARCHAR2
439 ,p_APPROVAL_REQUIRED_FLAG VARCHAR2
440 ,p_DATE_CLOSED DATE
441 ,p_QUANTITY_IN_WIP NUMBER
442 ,p_APPROVAL_STATUS VARCHAR2
443 ,p_QUANTITY_RCVD NUMBER
444 ,p_QUANTITY_SHIPPED NUMBER
445 ,p_CURRENCY_CODE VARCHAR2
446 ,p_DEFAULT_PO_NUM VARCHAR2 := NULL
447 ,p_SERIAL_NUMBER VARCHAR2
448 ,p_PROMISE_DATE DATE
449 ,p_ATTRIBUTE_CATEGORY VARCHAR2
450 ,p_ATTRIBUTE1 VARCHAR2
451 ,p_ATTRIBUTE2 VARCHAR2
452 ,p_ATTRIBUTE3 VARCHAR2
453 ,p_ATTRIBUTE4 VARCHAR2
454 ,p_ATTRIBUTE5 VARCHAR2
455 ,p_ATTRIBUTE6 VARCHAR2
456 ,p_ATTRIBUTE7 VARCHAR2
457 ,p_ATTRIBUTE8 VARCHAR2
458 ,p_ATTRIBUTE9 VARCHAR2
462 ,p_ATTRIBUTE13 VARCHAR2
459 ,p_ATTRIBUTE10 VARCHAR2
460 ,p_ATTRIBUTE11 VARCHAR2
461 ,p_ATTRIBUTE12 VARCHAR2
463 ,p_ATTRIBUTE14 VARCHAR2
464 ,p_ATTRIBUTE15 VARCHAR2
465 --bug#7497907, 12.1 FP, subhat
466 ,p_ATTRIBUTE16 VARCHAR2
467 ,p_ATTRIBUTE17 VARCHAR2
468 ,p_ATTRIBUTE18 VARCHAR2
469 ,p_ATTRIBUTE19 VARCHAR2
470 ,p_ATTRIBUTE20 VARCHAR2
471 ,p_ATTRIBUTE21 VARCHAR2
472 ,p_ATTRIBUTE22 VARCHAR2
473 ,p_ATTRIBUTE23 VARCHAR2
474 ,p_ATTRIBUTE24 VARCHAR2
475 ,p_ATTRIBUTE25 VARCHAR2
476 ,p_ATTRIBUTE26 VARCHAR2
477 ,p_ATTRIBUTE27 VARCHAR2
478 ,p_ATTRIBUTE28 VARCHAR2
479 ,p_ATTRIBUTE29 VARCHAR2
480 ,p_ATTRIBUTE30 VARCHAR2
481 ,p_ORDER_LINE_ID NUMBER
482 ,p_ORIGINAL_SOURCE_REFERENCE VARCHAR2
483 ,p_STATUS_REASON_CODE VARCHAR2
484 ,p_OBJECT_VERSION_NUMBER NUMBER
485 ,p_AUTO_PROCESS_RMA VARCHAR2
486 ,p_REPAIR_MODE VARCHAR2
487 ,p_ITEM_REVISION VARCHAR2
488 ,p_REPAIR_GROUP_ID NUMBER
489 ,p_RO_TXN_STATUS VARCHAR2
490 ,p_ORIGINAL_SOURCE_HEADER_ID NUMBER
491 ,p_ORIGINAL_SOURCE_LINE_ID NUMBER
492 ,p_PRICE_LIST_HEADER_ID NUMBER
493 ,p_PROBLEM_DESCRIPTION VARCHAR2 -- swai: bug 4666344
494 ,p_RO_PRIORITY_CODE VARCHAR2 -- swai: R12
495 ,p_RESOLVE_BY_DATE DATE -- rfieldma: 5355051
496 ,p_BULLETIN_CHECK_DATE DATE --:= FND_API.G_MISS_DATE
497 ,p_ESCALATION_CODE VARCHAR2 --:= FND_API.G_MISS_CHAR
498 ,p_RO_WARRANTY_STATUS_CODE VARCHAR2
499 ,p_RETURN_ATTRIBUTE_CATEGORY VARCHAR2 --12.2 returns portal project, subhat
500 ,p_RETURN_ATTRIBUTE1 VARCHAR2
501 ,p_RETURN_ATTRIBUTE2 VARCHAR2
502 ,p_RETURN_ATTRIBUTE3 VARCHAR2
503 ,p_RETURN_ATTRIBUTE4 VARCHAR2
504 ,p_RETURN_ATTRIBUTE5 VARCHAR2
505 ,p_RETURN_ATTRIBUTE6 VARCHAR2
506 ,p_RETURN_ATTRIBUTE7 VARCHAR2
507 ,p_RETURN_ATTRIBUTE8 VARCHAR2
508 ,p_RETURN_ATTRIBUTE9 VARCHAR2
509 ,p_RETURN_ATTRIBUTE10 VARCHAR2
510 ,p_RETURN_ATTRIBUTE11 VARCHAR2
511 ,p_RETURN_ATTRIBUTE12 VARCHAR2
512 ,p_RETURN_ATTRIBUTE13 VARCHAR2
513 ,p_RETURN_ATTRIBUTE14 VARCHAR2
514 ,p_RETURN_ATTRIBUTE15 VARCHAR2
515 ,p_RETURN_ATTRIBUTE16 VARCHAR2
516 ,p_RETURN_ATTRIBUTE17 VARCHAR2
517 ,p_RETURN_ATTRIBUTE18 VARCHAR2
518 ,p_RETURN_ATTRIBUTE19 VARCHAR2
519 ,p_RETURN_ATTRIBUTE20 VARCHAR2
520 ,p_RETURN_ATTRIBUTE21 VARCHAR2
521 ,p_RETURN_ATTRIBUTE22 VARCHAR2
522 ,p_RETURN_ATTRIBUTE23 VARCHAR2
523 ,p_RETURN_ATTRIBUTE24 VARCHAR2
524 ,p_RETURN_ATTRIBUTE25 VARCHAR2
525 ,p_RETURN_ATTRIBUTE26 VARCHAR2
526 ,p_RETURN_ATTRIBUTE27 VARCHAR2
527 ,p_RETURN_ATTRIBUTE28 VARCHAR2
528 ,p_RETURN_ATTRIBUTE29 VARCHAR2
529 ,p_RETURN_ATTRIBUTE30 VARCHAR2
530 ,p_waybill_no VARCHAR2
531 ,p_return_type_id VARCHAR2
532 ,p_PARENT_REPAIR_LINE_ID NUMBER -- bug#13698799 auto create ro, parent ro
533 )
534
535 IS
536 BEGIN
537 Update CSD_REPAIRS
538 SET
539 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
540 ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
541 ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
542 ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
543 ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
544 ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
545 ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
546 ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
547 ,REPAIR_NUMBER = decode( p_REPAIR_NUMBER, FND_API.G_MISS_CHAR, REPAIR_NUMBER, p_REPAIR_NUMBER)
548 ,INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, INCIDENT_ID, p_INCIDENT_ID)
549 ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
550 ,CUSTOMER_PRODUCT_ID = decode( p_CUSTOMER_PRODUCT_ID, FND_API.G_MISS_NUM, CUSTOMER_PRODUCT_ID, p_CUSTOMER_PRODUCT_ID)
551 ,UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE)
552 ,REPAIR_TYPE_ID = decode( p_REPAIR_TYPE_ID, FND_API.G_MISS_NUM, REPAIR_TYPE_ID, p_REPAIR_TYPE_ID)
553 -- RESOURCE_GROUP Added by Vijay 10/28/2004
554 ,OWNING_ORGANIZATION_ID = decode( p_RESOURCE_GROUP, FND_API.G_MISS_NUM, OWNING_ORGANIZATION_ID , p_RESOURCE_GROUP)
555 ,RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, p_RESOURCE_ID)
556 ,INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID)
557 ,PROJECT_ID = decode( p_PROJECT_ID, FND_API.G_MISS_NUM, PROJECT_ID, p_PROJECT_ID)
558 ,TASK_ID = decode( p_TASK_ID, FND_API.G_MISS_NUM, TASK_ID, p_TASK_ID)
562 -- ,STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS)
559 ,CONTRACT_LINE_ID = decode( p_CONTRACT_LINE_ID, FND_API.G_MISS_NUM, CONTRACT_LINE_ID, p_CONTRACT_LINE_ID)
560 ,QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY)
561 -- For R12 Flex Flow, We can no more update status via Update_Repair_Order API.
563 ,APPROVAL_REQUIRED_FLAG = decode( p_APPROVAL_REQUIRED_FLAG, FND_API.G_MISS_CHAR, APPROVAL_REQUIRED_FLAG, p_APPROVAL_REQUIRED_FLAG)
564 ,DATE_CLOSED = decode( p_DATE_CLOSED, FND_API.G_MISS_DATE, DATE_CLOSED, p_DATE_CLOSED)
565 ,QUANTITY_IN_WIP = decode( p_QUANTITY_IN_WIP, FND_API.G_MISS_NUM, QUANTITY_IN_WIP, p_QUANTITY_IN_WIP)
566 ,APPROVAL_STATUS = decode( p_APPROVAL_STATUS, FND_API.G_MISS_CHAR, APPROVAL_STATUS, p_APPROVAL_STATUS)
567 ,QUANTITY_RCVD = decode( p_QUANTITY_RCVD, FND_API.G_MISS_NUM, QUANTITY_RCVD, p_QUANTITY_RCVD)
568 ,QUANTITY_SHIPPED = decode( p_QUANTITY_SHIPPED, FND_API.G_MISS_NUM, QUANTITY_SHIPPED, p_QUANTITY_SHIPPED)
569 ,CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE)
570 ,DEFAULT_PO_NUM = decode( p_DEFAULT_PO_NUM, FND_API.G_MISS_CHAR, DEFAULT_PO_NUM, p_DEFAULT_PO_NUM)
571 ,SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER)
572 ,PROMISE_DATE = decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, PROMISE_DATE, p_PROMISE_DATE)
573 ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
574 ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
575 ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
576 ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
577 ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
578 ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
579 ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
580 ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
581 ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
582 ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
583 ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
584 ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
585 ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
586 ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
587 ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
588 ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
589 ,ORDER_LINE_ID = decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, ORDER_LINE_ID, p_ORDER_LINE_ID)
590 ,ORIGINAL_SOURCE_REFERENCE = decode( p_ORIGINAL_SOURCE_REFERENCE, FND_API.G_MISS_CHAR, ORIGINAL_SOURCE_REFERENCE, p_ORIGINAL_SOURCE_REFERENCE)
591 ,STATUS_REASON_CODE = decode( p_STATUS_REASON_CODE, FND_API.G_MISS_CHAR, STATUS_REASON_CODE, p_STATUS_REASON_CODE)
592 ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
593 ,AUTO_PROCESS_RMA = decode( p_AUTO_PROCESS_RMA, FND_API.G_MISS_CHAR, AUTO_PROCESS_RMA, p_AUTO_PROCESS_RMA)
594 ,REPAIR_MODE = decode( p_REPAIR_MODE, FND_API.G_MISS_CHAR, REPAIR_MODE, p_REPAIR_MODE)
595 ,ITEM_REVISION = decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, p_ITEM_REVISION)
596 ,REPAIR_GROUP_ID = decode( p_REPAIR_GROUP_ID, FND_API.G_MISS_NUM, REPAIR_GROUP_ID, p_REPAIR_GROUP_ID)
597 ,RO_TXN_STATUS = decode( p_RO_TXN_STATUS, FND_API.G_MISS_CHAR, RO_TXN_STATUS, p_RO_TXN_STATUS)
598 ,ORIGINAL_SOURCE_HEADER_ID = decode( p_ORIGINAL_SOURCE_HEADER_ID , FND_API.G_MISS_NUM, ORIGINAL_SOURCE_HEADER_ID, p_ORIGINAL_SOURCE_HEADER_ID)
599 ,ORIGINAL_SOURCE_LINE_ID = decode( p_ORIGINAL_SOURCE_LINE_ID , FND_API.G_MISS_NUM, ORIGINAL_SOURCE_LINE_ID, p_ORIGINAL_SOURCE_LINE_ID)
600 ,PRICE_LIST_HEADER_ID = decode( p_PRICE_LIST_HEADER_ID , FND_API.G_MISS_NUM, PRICE_LIST_HEADER_ID, p_PRICE_LIST_HEADER_ID)
601 ,PROBLEM_DESCRIPTION = decode( p_PROBLEM_DESCRIPTION , FND_API.G_MISS_CHAR, PROBLEM_DESCRIPTION, p_PROBLEM_DESCRIPTION) -- swai: bug 4666344
602 ,UNIT_NUMBER = decode( p_UNIT_NUMBER, FND_API.G_MISS_CHAR, UNIT_NUMBER, p_UNIT_NUMBER) -- rfieldma, project integration
603 ,RO_PRIORITY_CODE = decode( p_RO_PRIORITY_CODE , FND_API.G_MISS_CHAR, RO_PRIORITY_CODE, p_RO_PRIORITY_CODE) -- swai: R12
604 ,RESOLVE_BY_DATE = decode( p_RESOLVE_BY_DATE, FND_API.G_MISS_DATE, RESOLVE_BY_DATE, p_RESOLVE_BY_DATE) -- rfieldma: 5355051
605 ,BULLETIN_CHECK_DATE = decode( p_BULLETIN_CHECK_DATE, FND_API.G_MISS_DATE, BULLETIN_CHECK_DATE, p_BULLETIN_CHECK_DATE)
606 ,ESCALATION_CODE = decode( p_ESCALATION_CODE , FND_API.G_MISS_CHAR, ESCALATION_CODE, p_ESCALATION_CODE)
607 ,RO_WARRANTY_STATUS_CODE = decode( p_RO_WARRANTY_STATUS_CODE , FND_API.G_MISS_CHAR, RO_WARRANTY_STATUS_CODE, p_RO_WARRANTY_STATUS_CODE)
608 --bug#7497907, 12.1 FP, subhat
609 ,ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16)
610 ,ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17)
611 ,ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18)
612 ,ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19)
613 ,ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20)
614 ,ATTRIBUTE21 = decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, ATTRIBUTE21, p_ATTRIBUTE21)
615 ,ATTRIBUTE22 = decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, ATTRIBUTE22, p_ATTRIBUTE22)
616 ,ATTRIBUTE23 = decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, ATTRIBUTE23, p_ATTRIBUTE23)
620 ,ATTRIBUTE27 = decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, ATTRIBUTE27, p_ATTRIBUTE27)
617 ,ATTRIBUTE24 = decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, ATTRIBUTE24, p_ATTRIBUTE24)
618 ,ATTRIBUTE25 = decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, ATTRIBUTE25, p_ATTRIBUTE25)
619 ,ATTRIBUTE26 = decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, ATTRIBUTE26, p_ATTRIBUTE26)
621 ,ATTRIBUTE28 = decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, ATTRIBUTE28, p_ATTRIBUTE28)
622 ,ATTRIBUTE29 = decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, ATTRIBUTE29, p_ATTRIBUTE29)
623 ,ATTRIBUTE30 = decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, ATTRIBUTE30, p_ATTRIBUTE30)
624 ,RETURN_ATTRIBUTE_CATEGORY = decode( p_RETURN_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE_CATEGORY, p_RETURN_ATTRIBUTE_CATEGORY) --12.2 returns portal project, subhat
625 ,RETURN_ATTRIBUTE1 = decode( p_RETURN_ATTRIBUTE1, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE1, p_RETURN_ATTRIBUTE1)
626 ,RETURN_ATTRIBUTE2 = decode( p_RETURN_ATTRIBUTE2, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE2, p_RETURN_ATTRIBUTE2)
627 ,RETURN_ATTRIBUTE3 = decode( p_RETURN_ATTRIBUTE3, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE3, p_RETURN_ATTRIBUTE3)
628 ,RETURN_ATTRIBUTE4 = decode( p_RETURN_ATTRIBUTE4, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE4, p_RETURN_ATTRIBUTE4)
629 ,RETURN_ATTRIBUTE5 = decode( p_RETURN_ATTRIBUTE5, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE5, p_RETURN_ATTRIBUTE5)
630 ,RETURN_ATTRIBUTE6 = decode( p_RETURN_ATTRIBUTE6, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE6, p_RETURN_ATTRIBUTE6)
631 ,RETURN_ATTRIBUTE7 = decode( p_RETURN_ATTRIBUTE7, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE7, p_RETURN_ATTRIBUTE7)
632 ,RETURN_ATTRIBUTE8 = decode( p_RETURN_ATTRIBUTE8, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE8, p_RETURN_ATTRIBUTE8)
633 ,RETURN_ATTRIBUTE9 = decode( p_RETURN_ATTRIBUTE9, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE9, p_RETURN_ATTRIBUTE9)
634 ,RETURN_ATTRIBUTE10 = decode( p_RETURN_ATTRIBUTE10, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE10, p_RETURN_ATTRIBUTE10)
635 ,RETURN_ATTRIBUTE11 = decode( p_RETURN_ATTRIBUTE11, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE11, p_RETURN_ATTRIBUTE11)
636 ,RETURN_ATTRIBUTE12 = decode( p_RETURN_ATTRIBUTE12, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE12, p_RETURN_ATTRIBUTE12)
637 ,RETURN_ATTRIBUTE13 = decode( p_RETURN_ATTRIBUTE13, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE13, p_RETURN_ATTRIBUTE13)
638 ,RETURN_ATTRIBUTE14 = decode( p_RETURN_ATTRIBUTE14, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE14, p_RETURN_ATTRIBUTE14)
639 ,RETURN_ATTRIBUTE15 = decode( p_RETURN_ATTRIBUTE15, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE15, p_RETURN_ATTRIBUTE15)
640 ,RETURN_ATTRIBUTE16 = decode( p_RETURN_ATTRIBUTE16, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE16, p_RETURN_ATTRIBUTE16)
641 ,RETURN_ATTRIBUTE17 = decode( p_RETURN_ATTRIBUTE17, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE17, p_RETURN_ATTRIBUTE17)
642 ,RETURN_ATTRIBUTE18 = decode( p_RETURN_ATTRIBUTE18, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE18, p_RETURN_ATTRIBUTE18)
643 ,RETURN_ATTRIBUTE19 = decode( p_RETURN_ATTRIBUTE19, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE19, p_RETURN_ATTRIBUTE19)
644 ,RETURN_ATTRIBUTE20 = decode( p_RETURN_ATTRIBUTE20, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE20, p_RETURN_ATTRIBUTE20)
645 ,RETURN_ATTRIBUTE21 = decode( p_RETURN_ATTRIBUTE21, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE21, p_RETURN_ATTRIBUTE21)
646 ,RETURN_ATTRIBUTE22 = decode( p_RETURN_ATTRIBUTE22, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE22, p_RETURN_ATTRIBUTE22)
647 ,RETURN_ATTRIBUTE23 = decode( p_RETURN_ATTRIBUTE23, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE23, p_RETURN_ATTRIBUTE23)
648 ,RETURN_ATTRIBUTE24 = decode( p_RETURN_ATTRIBUTE24, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE24, p_RETURN_ATTRIBUTE24)
649 ,RETURN_ATTRIBUTE25 = decode( p_RETURN_ATTRIBUTE25, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE25, p_RETURN_ATTRIBUTE25)
650 ,RETURN_ATTRIBUTE26 = decode( p_RETURN_ATTRIBUTE26, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE26, p_RETURN_ATTRIBUTE26)
651 ,RETURN_ATTRIBUTE27 = decode( p_RETURN_ATTRIBUTE27, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE27, p_RETURN_ATTRIBUTE27)
652 ,RETURN_ATTRIBUTE28 = decode( p_RETURN_ATTRIBUTE28, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE28, p_RETURN_ATTRIBUTE28)
653 ,RETURN_ATTRIBUTE29 = decode( p_RETURN_ATTRIBUTE29, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE29, p_RETURN_ATTRIBUTE29)
654 ,RETURN_ATTRIBUTE30 = decode( p_RETURN_ATTRIBUTE30, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE30, p_RETURN_ATTRIBUTE30)
655 ,waybill_no = decode( p_waybill_no, FND_API.G_MISS_CHAR, waybill_no , p_waybill_no)
656 ,return_type_id = decode( p_return_type_id, FND_API.G_MISS_NUM, return_type_id , p_return_type_id)
657 ,PARENT_REPAIR_LINE_ID = decode(p_PARENT_REPAIR_LINE_ID, FND_API.G_MISS_NUM, PARENT_REPAIR_LINE_ID, p_PARENT_REPAIR_LINE_ID) -- bug#13698799 auto create ro, parent ro
658 where REPAIR_LINE_ID = p_REPAIR_LINE_ID;
659
660 If (SQL%NOTFOUND) then
661 RAISE NO_DATA_FOUND;
662 End If;
663 END Update_Row;
664
665 PROCEDURE Delete_Row(
666 p_REPAIR_LINE_ID NUMBER)
667 IS
668 BEGIN
669 DELETE FROM CSD_REPAIRS
670 WHERE REPAIR_LINE_ID = p_REPAIR_LINE_ID;
671 If (SQL%NOTFOUND) then
672 RAISE NO_DATA_FOUND;
673 End If;
674 END Delete_Row;
675
676 PROCEDURE Lock_Row
677 (
678 p_REPAIR_LINE_ID NUMBER
679 ,p_OBJECT_VERSION_NUMBER NUMBER
680 )
681
682 IS
683 CURSOR C IS
684 SELECT *
685 FROM CSD_REPAIRS
686 WHERE REPAIR_LINE_ID = p_REPAIR_LINE_ID
687 FOR UPDATE of REPAIR_LINE_ID NOWAIT;
688 Recinfo C%ROWTYPE;
689 BEGIN
690 OPEN C;
691 FETCH C INTO Recinfo;
692 If (C%NOTFOUND) then
693 CLOSE C;
694 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
695 APP_EXCEPTION.RAISE_EXCEPTION;
696 End If;
697 CLOSE C;
698
699 l_debug := csd_gen_utility_pvt.g_debug_level;
700 IF l_debug > 0 THEN
701 csd_gen_utility_pvt.add('CSD_REPAIRS_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);
702 csd_gen_utility_pvt.add('CSD_REPAIRS_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);
703 END IF;
704
705 If ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) then
706 return;
707 else
708 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
709 APP_EXCEPTION.RAISE_EXCEPTION;
710 End If;
711
712 END Lock_Row;
713
714 End CSD_REPAIRS_PKG;