[Home] [Help]
PACKAGE: APPS.CSD_REPAIR_ACTUAL_LINES_PVT
Source
1 PACKAGE CSD_REPAIR_ACTUAL_LINES_PVT AUTHID CURRENT_USER as
2 /* $Header: csdvalns.pls 120.4 2011/01/11 23:20:01 vicli ship $ csdvalns.pls */
3
4 -- ---------------------------------------------------------
5 -- Define global variables
6 -- ---------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIR_ACTUALS_LINES_PVT';
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvalns.pls';
9 g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
10
11 /*--------------------------------------------------------------------*/
12 /* Record name: CSD_ACTUAL_LINES_REC_TYPE */
13 /* Description : Record used for Create/Update Repair Actuals */
14 /* */
15 /* */
16 /* Called from : Depot Repair Actuals UI */
17 /* Change Hist : */
18 /* 08/11/03 travikan Initial Creation. */
19 /* */
20 /* */
21 /* */
22 /*--------------------------------------------------------------------*/
23 TYPE CSD_ACTUAL_LINES_REC_TYPE IS RECORD
24 (
25 REPAIR_ACTUAL_LINE_ID NUMBER
26 , OBJECT_VERSION_NUMBER NUMBER
27 , ESTIMATE_DETAIL_ID NUMBER
28 , REPAIR_ACTUAL_ID NUMBER
29 , REPAIR_LINE_ID NUMBER
30 , CREATED_BY NUMBER
31 , CREATION_DATE DATE
32 , LAST_UPDATED_BY NUMBER
33 , LAST_UPDATE_DATE DATE
34 , LAST_UPDATE_LOGIN NUMBER
35 , ITEM_COST NUMBER
36 , JUSTIFICATION_NOTES VARCHAR2(240)
37 , RESOURCE_ID NUMBER
38 , OVERRIDE_CHARGE_FLAG VARCHAR2(1)
39 , ACTUAL_SOURCE_CODE VARCHAR2(30)
40 , ACTUAL_SOURCE_ID NUMBER
41 , WARRANTY_CLAIM_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
42 , WARRANTY_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR
43 , WARRANTY_STATUS_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR
44 , REPLACED_ITEM_ID NUMBER := FND_API.G_MISS_NUM
45 , ATTRIBUTE_CATEGORY VARCHAR2(30)
46 , ATTRIBUTE1 VARCHAR2(150)
47 , ATTRIBUTE2 VARCHAR2(150)
48 , ATTRIBUTE3 VARCHAR2(150)
49 , ATTRIBUTE4 VARCHAR2(150)
50 , ATTRIBUTE5 VARCHAR2(150)
51 , ATTRIBUTE6 VARCHAR2(150)
52 , ATTRIBUTE7 VARCHAR2(150)
53 , ATTRIBUTE8 VARCHAR2(150)
54 , ATTRIBUTE9 VARCHAR2(150)
55 , ATTRIBUTE10 VARCHAR2(150)
56 , ATTRIBUTE11 VARCHAR2(150)
57 , ATTRIBUTE12 VARCHAR2(150)
58 , ATTRIBUTE13 VARCHAR2(150)
59 , ATTRIBUTE14 VARCHAR2(150)
60 , ATTRIBUTE15 VARCHAR2(150)
61 , LOCATOR_ID NUMBER
62 , LOC_SEGMENT1 VARCHAR2(40)
63 , LOC_SEGMENT2 VARCHAR2(40)
64 , LOC_SEGMENT3 VARCHAR2(40)
65 , LOC_SEGMENT4 VARCHAR2(40)
66 , LOC_SEGMENT5 VARCHAR2(40)
67 , LOC_SEGMENT6 VARCHAR2(40)
68 , LOC_SEGMENT7 VARCHAR2(40)
69 , LOC_SEGMENT8 VARCHAR2(40)
70 , LOC_SEGMENT9 VARCHAR2(40)
71 , LOC_SEGMENT10 VARCHAR2(40)
72 , LOC_SEGMENT11 VARCHAR2(40)
73 , LOC_SEGMENT12 VARCHAR2(40)
74 , LOC_SEGMENT13 VARCHAR2(40)
75 , LOC_SEGMENT14 VARCHAR2(40)
76 , LOC_SEGMENT15 VARCHAR2(40)
77 , LOC_SEGMENT16 VARCHAR2(40)
78 , LOC_SEGMENT17 VARCHAR2(40)
79 , LOC_SEGMENT18 VARCHAR2(40)
80 , LOC_SEGMENT19 VARCHAR2(40)
81 , LOC_SEGMENT20 VARCHAR2(40)
82 , UPDATE_ADD_TO_ORDER_FLAG VARCHAR2(1) -- vicli: bug#10102119
83 );
84
85
86 /*--------------------------------------------------------------------*/
87 /* Type to Return the Record Type for Creating / Updating the */
88 /* Repair Actual Lines */
89 /* */
90 /* Called from : Depot Repair */
91 /*--------------------------------------------------------------------*/
92 TYPE CSD_ACTUAL_LINES_TBL_TYPE IS TABLE OF CSD_ACTUAL_LINES_REC_TYPE
93 INDEX BY BINARY_INTEGER;
94
95
96 /*--------------------------------------------------------------------*/
97 /* procedure name: CREATE_REPAIR_ACTUAL_LINES */
98 /* description : procedure used to Create Repair Actuals */
99 /* */
100 /* */
101 /* */
102 /* Called from : Depot Repair Actuals UI */
103 /* Input Parm : */
104 /* p_api_version NUMBER Req Api Version number */
105 /* p_init_msg_list VARCHAR2 Opt Initialize message stack */
106 /* p_commit VARCHAR2 Opt Commits in API */
107 /* p_validation_level NUMBER Opt validation steps */
108 /* px_CSD_ACTUAL_LINES_REC REC Req Actuals lines Record */
109 /* px_Charges_Rec REC Req Charges line Record */
110 /* Output Parm : */
111 /* x_return_status VARCHAR2 Return status after the call. */
112 /* x_msg_count NUMBER Number of messages in stack */
113 /* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */
114 /* Change Hist : */
115 /* 08/11/03 travikan Initial Creation. */
116 /* */
117 /* */
118 /* */
119 /*--------------------------------------------------------------------*/
120 PROCEDURE CREATE_REPAIR_ACTUAL_LINES(
121 P_Api_Version IN NUMBER,
122 P_Commit IN VARCHAR2,
123 P_Init_Msg_List IN VARCHAR2,
124 p_validation_level IN NUMBER,
125 px_CSD_ACTUAL_LINES_REC IN OUT NOCOPY CSD_ACTUAL_LINES_REC_TYPE,
126 px_Charges_Rec IN OUT NOCOPY CS_CHARGE_DETAILS_PUB.CHARGES_REC_TYPE,
127 X_Return_Status OUT NOCOPY VARCHAR2,
128 X_Msg_Count OUT NOCOPY NUMBER,
129 X_Msg_Data OUT NOCOPY VARCHAR2
130 );
131
132 /*--------------------------------------------------------------------*/
133 /* procedure name: UPDATE_REPAIR_ACTUAL_LINES */
134 /* description : procedure used to Update Repair Actuals */
135 /* */
136 /* */
137 /* */
138 /* Called from : Depot Repair Actuals UI */
139 /* Input Parm : */
140 /* p_api_version NUMBER Req Api Version number */
141 /* p_init_msg_list VARCHAR2 Opt Initialize message stack */
142 /* p_commit VARCHAR2 Opt Commits in API */
143 /* p_validation_level NUMBER Opt validation steps */
144 /* px_CSD_ACTUAL_LINES_REC REC Req Actuals lines Record */
145 /* px_Charges_Rec REC Req Charges line Record */
146 /* Output Parm : */
147 /* x_return_status VARCHAR2 Return status after the call. */
148 /* x_msg_count NUMBER Number of messages in stack */
149 /* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */
150 /* Change Hist : */
151 /* 08/11/03 travikan Initial Creation. */
152 /* */
153 /* */
154 /* */
155 /*--------------------------------------------------------------------*/
156 PROCEDURE UPDATE_REPAIR_ACTUAL_LINES(
157 P_Api_Version IN NUMBER,
158 P_Commit IN VARCHAR2,
159 P_Init_Msg_List IN VARCHAR2,
160 p_validation_level IN NUMBER,
161 px_CSD_ACTUAL_LINES_REC IN OUT NOCOPY CSD_ACTUAL_LINES_REC_TYPE,
162 px_Charges_Rec IN OUT NOCOPY CS_CHARGE_DETAILS_PUB.CHARGES_REC_TYPE,
163 X_Return_Status OUT NOCOPY VARCHAR2,
164 X_Msg_Count OUT NOCOPY NUMBER,
165 X_Msg_Data OUT NOCOPY VARCHAR2
166 );
167
168
169
170 /*--------------------------------------------------------------------*/
171 /* procedure name: DELETE_REPAIR_ACTUAL_LINES */
172 /* description : procedure used to Delete Repair Actuals */
173 /* */
174 /* */
175 /* */
176 /* Called from : Depot Repair Actuals UI */
177 /* Input Parm : */
178 /* p_api_version NUMBER Req Api Version number */
179 /* p_init_msg_list VARCHAR2 Opt Initialize message stack */
180 /* p_commit VARCHAR2 Opt Commits in API */
181 /* p_validation_level NUMBER Opt validation steps */
182 /* px_CSD_ACTUAL_LINES_REC REC Req Actuals lines Record */
183 /* px_Charges_Rec REC Req Charges line Record */
184 /* Output Parm : */
185 /* x_return_status VARCHAR2 Return status after the call. */
186 /* x_msg_count NUMBER Number of messages in stack */
187 /* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */
188 /* Change Hist : */
189 /* 08/11/03 travikan Initial Creation. */
190 /* */
191 /* */
192 /* */
193 /*--------------------------------------------------------------------*/
194 PROCEDURE DELETE_REPAIR_ACTUAL_LINES(
195 P_Api_Version IN NUMBER,
196 P_Commit IN VARCHAR2,
197 P_Init_Msg_List IN VARCHAR2,
198 p_validation_level IN NUMBER,
199 px_CSD_ACTUAL_LINES_REC IN OUT NOCOPY CSD_ACTUAL_LINES_REC_TYPE,
200 px_Charges_Rec IN OUT NOCOPY CS_CHARGE_DETAILS_PUB.CHARGES_REC_TYPE,
201 X_Return_Status OUT NOCOPY VARCHAR2,
202 X_Msg_Count OUT NOCOPY NUMBER,
203 X_Msg_Data OUT NOCOPY VARCHAR2
204 );
205
206
207
208 /*--------------------------------------------------------------------*/
209 /* procedure name: LOCK_REPAIR_ACTUAL_LINES */
210 /* description : procedure used to Lock Repair Actuals */
211 /* */
212 /* */
213 /* */
214 /* Called from : Depot Repair Actuals UI */
215 /* Input Parm : */
216 /* p_api_version NUMBER Req Api Version number */
217 /* p_init_msg_list VARCHAR2 Opt Initialize message stack */
218 /* p_commit VARCHAR2 Opt Commits in API */
219 /* p_validation_level NUMBER Opt validation steps */
220 /* px_CSD_ACTUAL_LINES_REC REC Req Actuals lines Record */
221 /* Output Parm : */
222 /* x_return_status VARCHAR2 Return status after the call. */
223 /* x_msg_count NUMBER Number of messages in stack */
224 /* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */
225 /* Change Hist : */
226 /* 08/11/03 travikan Initial Creation. */
227 /* */
228 /* */
229 /* */
230 /*--------------------------------------------------------------------*/
231 PROCEDURE LOCK_REPAIR_ACTUAL_LINES(
232 P_Api_Version IN NUMBER,
233 P_Commit IN VARCHAR2,
234 P_Init_Msg_List IN VARCHAR2,
235 p_validation_level IN NUMBER,
236 px_CSD_ACTUAL_LINES_REC IN OUT NOCOPY CSD_ACTUAL_LINES_REC_TYPE,
237 X_Return_Status OUT NOCOPY VARCHAR2,
238 X_Msg_Count OUT NOCOPY NUMBER,
239 X_Msg_Data OUT NOCOPY VARCHAR2
240 );
241 /*------------------------------------------------------------------------------
242 TYPE CSD_ACTUAL_LINES_REC_TYPE IS RECORD
243 (
244 REPAIR_ACTUAL_LINE_ID NUMBER
245 , OBJECT_VERSION_NUMBER NUMBER
246 , ESTIMATE_DETAIL_ID NUMBER
247 , REPAIR_ACTUAL_ID NUMBER
248 , REPAIR_LINE_ID NUMBER
249 , CREATED_BY NUMBER
250 , CREATION_DATE DATE
251 , LAST_UPDATED_BY NUMBER
252 , LAST_UPDATE_DATE DATE
253 , LAST_UPDATE_LOGIN NUMBER
254 , ITEM_COST NUMBER
255 , JUSTIFICATION_NOTES VARCHAR2(240)
256 , RESOURCE_ID NUMBER
257 , OVERRIDE_CHARGE_FLAG VARCHAR2(1)
258 , ACTUAL_SOURCE_CODE VARCHAR2(30)
259 , ACTUAL_SOURCE_ID NUMBER
260 , ATTRIBUTE_CATEGORY VARCHAR2(30)
261 , ATTRIBUTE1 VARCHAR2(150)
262 , ATTRIBUTE2 VARCHAR2(150)
263 , ATTRIBUTE3 VARCHAR2(150)
264 , ATTRIBUTE4 VARCHAR2(150)
265 , ATTRIBUTE5 VARCHAR2(150)
266 , ATTRIBUTE6 VARCHAR2(150)
267 , ATTRIBUTE7 VARCHAR2(150)
268 , ATTRIBUTE8 VARCHAR2(150)
269 , ATTRIBUTE9 VARCHAR2(150)
270 , ATTRIBUTE10 VARCHAR2(150)
271 , ATTRIBUTE11 VARCHAR2(150)
272 , ATTRIBUTE12 VARCHAR2(150)
273 , ATTRIBUTE13 VARCHAR2(150)
274 , ATTRIBUTE14 VARCHAR2(150)
275 , ATTRIBUTE15 VARCHAR2(150)
276 , LOCATOR_ID NUMBER
277 , LOC_SEGMENT1 VARCHAR2(40)
278 , LOC_SEGMENT2 VARCHAR2(40)
279 , LOC_SEGMENT3 VARCHAR2(40)
280 , LOC_SEGMENT4 VARCHAR2(40)
281 , LOC_SEGMENT5 VARCHAR2(40)
282 , LOC_SEGMENT6 VARCHAR2(40)
283 , LOC_SEGMENT7 VARCHAR2(40)
284 , LOC_SEGMENT8 VARCHAR2(40)
285 , LOC_SEGMENT9 VARCHAR2(40)
286 , LOC_SEGMENT10 VARCHAR2(40)
287 , LOC_SEGMENT11 VARCHAR2(40)
288 , LOC_SEGMENT12 VARCHAR2(40)
289 , LOC_SEGMENT13 VARCHAR2(40)
290 , LOC_SEGMENT14 VARCHAR2(40)
291 , LOC_SEGMENT15 VARCHAR2(40)
292 , LOC_SEGMENT16 VARCHAR2(40)
293 , LOC_SEGMENT17 VARCHAR2(40)
294 , LOC_SEGMENT18 VARCHAR2(40)
295 , LOC_SEGMENT19 VARCHAR2(40)
296 , LOC_SEGMENT20 VARCHAR2(40)
297 , INCIDENT_ID NUMBER -- Begin For Charges Record
298 , TRANSACTION_TYPE_ID NUMBER
299 , BUSINESS_PROCESS_ID NUMBER
300 , TXN_BILLING_TYPE_ID NUMBER
301 , ORIGINAL_SOURCE_ID NUMBER
302 , ORIGINAL_SOURCE_CODE VARCHAR2(10)
303 , SOURCE_ID NUMBER
304 , SOURCE_CODE VARCHAR2(10)
305 , LINE_TYPE_ID NUMBER
306 , CUSTOMER_PRODUCT_ID NUMBER
307 , REFERENCE_NUMBER NUMBER
308 , ITEM_REVISION VARCHAR2(30)
309 , ORDER_NUMBER VARCHAR2(30)
310 , PURCHASE_ORDER_NUM VARCHAR2(30)
311 , SOURCE_NUMBER VARCHAR2(30)
312 , STATUS VARCHAR2(30)
313 , CURRENCY_CODE VARCHAR2(15)
314 , LINE_CATEGORY_CODE VARCHAR2(6)
315 , UNIT_OF_MEASURE_CODE VARCHAR2(3)
316 , ORIGINAL_SOURCE_NUMBER VARCHAR2(3)
317 , ORDER_HEADER_ID NUMBER
318 , ORDER_LINE_ID NUMBER
319 , INVENTORY_ITEM_ID NUMBER
320 , AFTER_WARRANTY_COST NUMBER
321 , SELLING_PRICE NUMBER
322 , ORIGINAL_SYSTEM_REFERENCE VARCHAR2(30)
323 , ESTIMATE_QUANTITY NUMBER
324 , SERIAL_NUMBER VARCHAR2(50)
325 , LOT_NUMBER VARCHAR2(80) -- fix for bug#4625226
326 , INSTANCE_ID NUMBER
327 , INSTANCE_NUMBER NUMBER
328 , PRICE_LIST_ID NUMBER
329 , CONTRACT_ID NUMBER
330 , CONTRACT_NUMBER VARCHAR2(30)
331 , COVERAGE_ID NUMBER
332 , CHARGE_LINE_TYPE VARCHAR2(30)
333 , APPLY_CONTRACT_DISCOUNT VARCHAR2(1)
334 , COVERAGE_TXN_GROUP_ID NUMBER
335 , COVERAGE_BILL_RATE_ID NUMBER
336 , SUB_INVENTORY VARCHAR2(30)
337 , ORGANIZATION_ID NUMBER
338 , INVOICE_TO_ORG_ID NUMBER
339 , SHIP_TO_ORG_ID NUMBER
340 , NO_CHARGE_FLAG VARCHAR2(1)
341 , INTERFACE_TO_OM_FLAG VARCHAR2(1)
342 , RETURN_REASON VARCHAR2(30)
343 , RETURN_BY_DATE DATE
344 , SECURITY_GROUP_ID NUMBER
345 , PRICING_CONTEXT VARCHAR2(30)
346 , PRICING_ATTRIBUTE1 VARCHAR2(150)
347 , PRICING_ATTRIBUTE2 VARCHAR2(150)
348 , PRICING_ATTRIBUTE3 VARCHAR2(150)
349 , PRICING_ATTRIBUTE4 VARCHAR2(150)
350 , PRICING_ATTRIBUTE5 VARCHAR2(150)
351 , PRICING_ATTRIBUTE6 VARCHAR2(150)
352 , PRICING_ATTRIBUTE7 VARCHAR2(150)
353 , PRICING_ATTRIBUTE8 VARCHAR2(150)
354 , PRICING_ATTRIBUTE9 VARCHAR2(150)
355 , PRICING_ATTRIBUTE10 VARCHAR2(150)
356 , PRICING_ATTRIBUTE11 VARCHAR2(150)
357 , PRICING_ATTRIBUTE12 VARCHAR2(150)
358 , PRICING_ATTRIBUTE13 VARCHAR2(150)
359 , PRICING_ATTRIBUTE14 VARCHAR2(150)
360 , PRICING_ATTRIBUTE15 VARCHAR2(150)
361 , PRICING_ATTRIBUTE16 VARCHAR2(150)
362 , PRICING_ATTRIBUTE17 VARCHAR2(150)
363 , PRICING_ATTRIBUTE18 VARCHAR2(150)
364 , PRICING_ATTRIBUTE19 VARCHAR2(150)
365 , PRICING_ATTRIBUTE20 VARCHAR2(150)
366 , PRICING_ATTRIBUTE21 VARCHAR2(150)
367 , PRICING_ATTRIBUTE22 VARCHAR2(150)
368 , PRICING_ATTRIBUTE123 VARCHAR2(150)
369 , PRICING_ATTRIBUTE24 VARCHAR2(150)
370 , PRICING_ATTRIBUTE25 VARCHAR2(150)
371 , PRICING_ATTRIBUTE26 VARCHAR2(150)
372 , PRICING_ATTRIBUTE27 VARCHAR2(150)
373 , PRICING_ATTRIBUTE28 VARCHAR2(150)
374 , PRICING_ATTRIBUTE29 VARCHAR2(150)
375 , PRICING_ATTRIBUTE30 VARCHAR2(150)
376 , PRICING_ATTRIBUTE31 VARCHAR2(150)
377 , PRICING_ATTRIBUTE32 VARCHAR2(150)
378 , PRICING_ATTRIBUTE33 VARCHAR2(150)
379 , PRICING_ATTRIBUTE34 VARCHAR2(150)
380 , PRICING_ATTRIBUTE35 VARCHAR2(150)
381 , PRICING_ATTRIBUTE36 VARCHAR2(150)
382 , PRICING_ATTRIBUTE37 VARCHAR2(150)
383 , PRICING_ATTRIBUTE38 VARCHAR2(150)
384 , PRICING_ATTRIBUTE39 VARCHAR2(150)
385 , PRICING_ATTRIBUTE40 VARCHAR2(150)
386 , PRICING_ATTRIBUTE41 VARCHAR2(150)
387 , PRICING_ATTRIBUTE42 VARCHAR2(150)
388 , PRICING_ATTRIBUTE43 VARCHAR2(150)
389 , PRICING_ATTRIBUTE44 VARCHAR2(150)
390 , PRICING_ATTRIBUTE45 VARCHAR2(150)
391 , PRICING_ATTRIBUTE46 VARCHAR2(150)
392 , PRICING_ATTRIBUTE47 VARCHAR2(150)
393 , PRICING_ATTRIBUTE48 VARCHAR2(150)
394 , PRICING_ATTRIBUTE49 VARCHAR2(150)
395 , PRICING_ATTRIBUTE50 VARCHAR2(150)
396 , PRICING_ATTRIBUTE51 VARCHAR2(150)
397 , PRICING_ATTRIBUTE52 VARCHAR2(150)
398 , PRICING_ATTRIBUTE53 VARCHAR2(150)
399 , PRICING_ATTRIBUTE54 VARCHAR2(150)
400 , PRICING_ATTRIBUTE55 VARCHAR2(150)
401 , PRICING_ATTRIBUTE56 VARCHAR2(150)
402 , PRICING_ATTRIBUTE57 VARCHAR2(150)
403 , PRICING_ATTRIBUTE58 VARCHAR2(150)
404 , PRICING_ATTRIBUTE59 VARCHAR2(150)
405 , PRICING_ATTRIBUTE60 VARCHAR2(150)
406 , PRICING_ATTRIBUTE61 VARCHAR2(150)
407 , PRICING_ATTRIBUTE62 VARCHAR2(150)
408 , PRICING_ATTRIBUTE63 VARCHAR2(150)
409 , PRICING_ATTRIBUTE64 VARCHAR2(150)
410 , PRICING_ATTRIBUTE65 VARCHAR2(150)
411 , PRICING_ATTRIBUTE66 VARCHAR2(150)
412 , PRICING_ATTRIBUTE67 VARCHAR2(150)
413 , PRICING_ATTRIBUTE68 VARCHAR2(150)
414 , PRICING_ATTRIBUTE69 VARCHAR2(150)
415 , PRICING_ATTRIBUTE70 VARCHAR2(150)
416 , PRICING_ATTRIBUTE71 VARCHAR2(150)
417 , PRICING_ATTRIBUTE72 VARCHAR2(150)
418 , PRICING_ATTRIBUTE73 VARCHAR2(150)
419 , PRICING_ATTRIBUTE74 VARCHAR2(150)
420 , PRICING_ATTRIBUTE75 VARCHAR2(150)
421 , PRICING_ATTRIBUTE76 VARCHAR2(150)
422 , PRICING_ATTRIBUTE77 VARCHAR2(150)
423 , PRICING_ATTRIBUTE78 VARCHAR2(150)
424 , PRICING_ATTRIBUTE79 VARCHAR2(150)
425 , PRICING_ATTRIBUTE80 VARCHAR2(150)
426 , PRICING_ATTRIBUTE81 VARCHAR2(150)
427 , PRICING_ATTRIBUTE82 VARCHAR2(150)
428 , PRICING_ATTRIBUTE83 VARCHAR2(150)
429 , PRICING_ATTRIBUTE84 VARCHAR2(150)
430 , PRICING_ATTRIBUTE85 VARCHAR2(150)
431 , PRICING_ATTRIBUTE86 VARCHAR2(150)
432 , PRICING_ATTRIBUTE87 VARCHAR2(150)
433 , PRICING_ATTRIBUTE88 VARCHAR2(150)
434 , PRICING_ATTRIBUTE89 VARCHAR2(150)
435 , PRICING_ATTRIBUTE90 VARCHAR2(150)
436 , PRICING_ATTRIBUTE91 VARCHAR2(150)
437 , PRICING_ATTRIBUTE92 VARCHAR2(150)
438 , PRICING_ATTRIBUTE93 VARCHAR2(150)
439 , PRICING_ATTRIBUTE94 VARCHAR2(150)
440 , PRICING_ATTRIBUTE95 VARCHAR2(150)
441 , PRICING_ATTRIBUTE96 VARCHAR2(150)
442 , PRICING_ATTRIBUTE97 VARCHAR2(150)
443 , PRICING_ATTRIBUTE98 VARCHAR2(150)
444 , PRICING_ATTRIBUTE99 VARCHAR2(150)
445 , PRICING_ATTRIBUTE100 VARCHAR2(150) -- End For Charges Record
446 );
447 ------------------------------------------------------------------------------*/
448 End CSD_REPAIR_ACTUAL_LINES_PVT;