[Home] [Help]
PACKAGE: APPS.CSD_REPAIR_ESTIMATE_PVT
Source
1 Package Csd_Repair_Estimate_Pvt AS
2 /* $Header: csdvests.pls 120.9.12020000.2 2013/03/27 19:42:56 swai ship $ */
3
4 /*--------------------------------------------------*/
5 /* Record name: REPAIR_ESTIMATE_REC */
6 /* description : Record used for repair estimate rec*/
7 /* */
8 /*--------------------------------------------------*/
9
10 TYPE REPAIR_ESTIMATE_REC IS RECORD(
11 repair_estimate_id NUMBER := Fnd_Api.G_MISS_NUM,
12 repair_line_id NUMBER := Fnd_Api.G_MISS_NUM,
13 note_id NUMBER := Fnd_Api.G_MISS_NUM,
14 estimate_date DATE := Fnd_Api.G_MISS_DATE,
15 estimate_status VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
16 lead_time NUMBER := Fnd_Api.G_MISS_NUM,
17 lead_time_uom VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
18 estimate_freeze_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR,
19 work_summary VARCHAR2(240) := Fnd_Api.G_MISS_CHAR,
20 po_number VARCHAR2(50) := Fnd_Api.G_MISS_CHAR,
21 estimate_reason_code VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
22 not_to_exceed NUMBER := Fnd_Api.G_MISS_NUM, -- R12 Bug#5334454
23 last_update_date DATE := Fnd_Api.G_MISS_DATE,
24 creation_date DATE := Fnd_Api.G_MISS_DATE,
25 last_updated_by NUMBER := Fnd_Api.G_MISS_NUM,
26 created_by NUMBER := Fnd_Api.G_MISS_NUM,
27 last_update_login NUMBER := Fnd_Api.G_MISS_NUM,
28 attribute1 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
29 attribute2 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
30 attribute3 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
31 attribute4 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
32 attribute5 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
33 attribute6 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
34 attribute7 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
35 attribute8 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
36 attribute9 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
37 attribute10 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
38 attribute11 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
39 attribute12 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
40 attribute13 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
41 attribute14 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
42 attribute15 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
43 context VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
44 object_version_number NUMBER := Fnd_Api.G_MISS_NUM,
45 security_group_id NUMBER := Fnd_Api.G_MISS_NUM
46
47 );
48
49 /*--------------------------------------------------*/
50 /* Record name: REPAIR_ESTIMATE_LINE_REC */
51 /* description : Record used for repair estimate rec*/
52 /* */
53 /*--------------------------------------------------*/
54
55 -- added contract_number to the record
56 -- added charge_line_type and apply_contract_discount to the record
57 -- travi forward port of Bug # 2789754 fix added override_charge_flag
58 -- to the record
59
60 TYPE REPAIR_ESTIMATE_LINE_REC IS RECORD(
61 repair_estimate_line_id NUMBER := Fnd_Api.G_MISS_NUM,
62 repair_estimate_id NUMBER := Fnd_Api.G_MISS_NUM,
63 repair_line_id NUMBER := Fnd_Api.G_MISS_NUM,
64 estimate_detail_id NUMBER := Fnd_Api.G_MISS_NUM,
65 incident_id NUMBER := Fnd_Api.G_MISS_NUM,
66 transaction_type_id NUMBER := Fnd_Api.G_MISS_NUM,
67 business_process_id NUMBER := Fnd_Api.G_MISS_NUM,
68 txn_billing_type_id NUMBER := Fnd_Api.G_MISS_NUM,
69 original_source_id NUMBER := Fnd_Api.G_MISS_NUM,
70 original_source_code VARCHAR2(10) := Fnd_Api.G_MISS_CHAR,
71 source_id NUMBER := Fnd_Api.G_MISS_NUM,
72 source_code VARCHAR2(10) := Fnd_Api.G_MISS_CHAR,
73 line_type_id NUMBER := Fnd_Api.G_MISS_NUM,
74 item_cost NUMBER := Fnd_Api.G_MISS_NUM,
75 resource_id NUMBER := Fnd_Api.G_MISS_NUM,
76 customer_product_id NUMBER := Fnd_Api.G_MISS_NUM,
77 reference_number NUMBER := Fnd_Api.G_MISS_NUM,
78 item_revision VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
79 justification_notes VARCHAR2(240) := Fnd_Api.G_MISS_CHAR,
80 estimate_status VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
81 order_number VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
82 -- purchase_order_num VARCHAR2(30) := FND_API.G_MISS_CHAR,
83 -- Above line replaced by line below. bugfix 3485965. vkjain
84 purchase_order_num VARCHAR2(50) := Fnd_Api.G_MISS_CHAR,
85 source_number VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
86 status VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
87 currency_code VARCHAR2(15) := Fnd_Api.G_MISS_CHAR,
88 line_category_code VARCHAR2(6) := Fnd_Api.G_MISS_CHAR,
89 unit_of_measure_code VARCHAR2(3) := Fnd_Api.G_MISS_CHAR,
90 original_source_number VARCHAR2(3) := Fnd_Api.G_MISS_CHAR,
91 add_to_order_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR,
92 order_header_id NUMBER := Fnd_Api.G_MISS_NUM,
93 order_line_id NUMBER := Fnd_Api.G_MISS_NUM,
94 inventory_item_id NUMBER := Fnd_Api.G_MISS_NUM,
95 after_warranty_cost NUMBER := Fnd_Api.G_MISS_NUM,
96 selling_price NUMBER := Fnd_Api.G_MISS_NUM,
97 original_system_reference VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
98 estimate_quantity NUMBER := Fnd_Api.G_MISS_NUM,
99 serial_number VARCHAR2(50) := Fnd_Api.G_MISS_CHAR,
100 lot_number VARCHAR2(80) := Fnd_Api.G_MISS_CHAR, -- fix for bug#4625226
101 instance_id NUMBER := Fnd_Api.G_MISS_NUM,
102 instance_number NUMBER := Fnd_Api.G_MISS_NUM,
103 price_list_id NUMBER := Fnd_Api.G_MISS_NUM,
104 contract_id NUMBER := Fnd_Api.G_MISS_NUM,
105 contract_number VARCHAR2(120) := Fnd_Api.G_MISS_CHAR,
106 coverage_bill_rate_id NUMBER := Fnd_Api.G_MISS_NUM,
107 sub_inventory VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
108 organization_id NUMBER := Fnd_Api.G_MISS_NUM,
109 invoice_to_org_id NUMBER := Fnd_Api.G_MISS_NUM,
110 ship_to_org_id NUMBER := Fnd_Api.G_MISS_NUM,
111 no_charge_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR,
112 override_charge_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR,
113 interface_to_om_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR,
114 return_reason VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
115 return_by_date DATE := Fnd_Api.G_MISS_DATE,
116 last_update_date DATE := Fnd_Api.G_MISS_DATE,
117 creation_date DATE := Fnd_Api.G_MISS_DATE,
118 last_updated_by NUMBER := Fnd_Api.G_MISS_NUM,
119 created_by NUMBER := Fnd_Api.G_MISS_NUM,
120 last_update_login NUMBER := Fnd_Api.G_MISS_NUM,
121 attribute1 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
122 attribute2 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
123 attribute3 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
124 attribute4 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
125 attribute5 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
126 attribute6 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
127 attribute7 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
128 attribute8 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
129 attribute9 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
130 attribute10 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
131 attribute11 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
132 attribute12 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
133 attribute13 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
134 attribute14 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
135 attribute15 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
136 context VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
137 object_version_number NUMBER := Fnd_Api.G_MISS_NUM,
138 security_group_id NUMBER := Fnd_Api.G_MISS_NUM,
139 charge_line_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
140 apply_contract_discount VARCHAR2(1) := Fnd_Api.G_MISS_CHAR,
141 coverage_id NUMBER := Fnd_Api.G_MISS_NUM,
142 coverage_txn_group_id NUMBER := Fnd_Api.G_MISS_NUM,
143 -- swai bug fix 3099740
144 -- add contract discount amount to pass to charges
145 contract_discount_amount NUMBER := Fnd_Api.G_MISS_NUM,
146 -- end swai bug fix 3099740
147
148 --
149 -- swai 11.5.10
150 -- new fields
151 --
152 EST_LINE_SOURCE_TYPE_CODE VARCHAR2(30),
153 EST_LINE_SOURCE_ID1 NUMBER,
154 EST_LINE_SOURCE_ID2 NUMBER,
155 RO_SERVICE_CODE_ID NUMBER,
156 --
157 -- end swai 11.5.10 new fields
158 --
159 pricing_context VARCHAR2(30) := Fnd_Api.G_MISS_CHAR,
160 pricing_attribute1 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
161 pricing_attribute2 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
162 pricing_attribute3 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
163 pricing_attribute4 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
164 pricing_attribute5 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
165 pricing_attribute6 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
166 pricing_attribute7 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
167 pricing_attribute8 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
168 pricing_attribute9 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
169 pricing_attribute10 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
170 pricing_attribute11 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
171 pricing_attribute12 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
172 pricing_attribute13 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
173 pricing_attribute14 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
174 pricing_attribute15 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
175 pricing_attribute16 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
176 pricing_attribute17 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
177 pricing_attribute18 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
178 pricing_attribute19 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
179 pricing_attribute20 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
180 pricing_attribute21 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
181 pricing_attribute22 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
182 pricing_attribute23 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
183 pricing_attribute24 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
184 pricing_attribute25 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
185 pricing_attribute26 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
186 pricing_attribute27 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
187 pricing_attribute28 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
188 pricing_attribute29 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
189 pricing_attribute30 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
190 pricing_attribute31 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
191 pricing_attribute32 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
192 pricing_attribute33 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
193 pricing_attribute34 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
194 pricing_attribute35 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
195 pricing_attribute36 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
196 pricing_attribute37 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
197 pricing_attribute38 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
198 pricing_attribute39 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
199 pricing_attribute40 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
200 pricing_attribute41 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
201 pricing_attribute42 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
202 pricing_attribute43 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
203 pricing_attribute44 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
204 pricing_attribute45 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
205 pricing_attribute46 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
206 pricing_attribute47 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
207 pricing_attribute48 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
208 pricing_attribute49 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
209 pricing_attribute50 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
210 pricing_attribute51 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
211 pricing_attribute52 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
212 pricing_attribute53 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
213 pricing_attribute54 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
214 pricing_attribute55 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
215 pricing_attribute56 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
216 pricing_attribute57 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
217 pricing_attribute58 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
218 pricing_attribute59 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
219 pricing_attribute60 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
220 pricing_attribute61 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
221 pricing_attribute62 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
222 pricing_attribute63 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
223 pricing_attribute64 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
224 pricing_attribute65 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
225 pricing_attribute66 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
226 pricing_attribute67 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
227 pricing_attribute68 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
228 pricing_attribute69 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
229 pricing_attribute70 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
230 pricing_attribute71 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
231 pricing_attribute72 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
232 pricing_attribute73 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
233 pricing_attribute74 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
234 pricing_attribute75 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
235 pricing_attribute76 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
236 pricing_attribute77 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
237 pricing_attribute78 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
238 pricing_attribute79 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
239 pricing_attribute80 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
240 pricing_attribute81 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
241 pricing_attribute82 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
242 pricing_attribute83 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
243 pricing_attribute84 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
244 pricing_attribute85 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
245 pricing_attribute86 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
246 pricing_attribute87 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
247 pricing_attribute88 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
248 pricing_attribute89 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
249 pricing_attribute90 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
250 pricing_attribute91 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
251 pricing_attribute92 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
252 pricing_attribute93 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
253 pricing_attribute94 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
254 pricing_attribute95 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
255 pricing_attribute96 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
256 pricing_attribute97 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
257 pricing_attribute98 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
258 pricing_attribute99 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
259 pricing_attribute100 VARCHAR2(150) := Fnd_Api.G_MISS_CHAR,
260
261 -- R12 new fields, added for contract re arch changes.
262 contract_line_id NUMBER,
263 rate_type_code VARCHAR2(40) -- this is added because charges table has a new column, may not be used currently.
264
265 );
266
267 TYPE REPAIR_ESTIMATE_LINE_TBL IS TABLE OF REPAIR_ESTIMATE_LINE_REC INDEX BY BINARY_INTEGER;
268
269 --
270 -- swai 11.5.10
271 --
272 /*--------------------------------------------------*/
273 /* Record name: MLE_LINES_REC_TYPE */
274 /* description : Record used for mle lines */
275 /* */
276 /*--------------------------------------------------*/
277
278 TYPE MLE_LINES_REC_TYPE IS RECORD(
279 INVENTORY_ITEM_ID NUMBER,
280 UOM VARCHAR2(3),
281 QUANTITY NUMBER,
282 SELLING_PRICE NUMBER,
283 ITEM_NAME VARCHAR2(100),
284 COMMS_NL_TRACKABLE_FLAG VARCHAR2(1),
285 TXN_BILLING_TYPE_ID NUMBER,
286 EST_LINE_SOURCE_TYPE_CODE VARCHAR2(30),
287 EST_LINE_SOURCE_ID1 NUMBER,
288 EST_LINE_SOURCE_ID2 NUMBER,
289 RO_SERVICE_CODE_ID NUMBER,
290 RESOURCE_ID NUMBER -- vkjain. fix 3449978
291 );
292 TYPE MLE_LINES_TBL_TYPE IS TABLE OF MLE_LINES_REC_TYPE INDEX BY BINARY_INTEGER;
293
294 --
295 -- end swai 11.5.10
296 --
297
298 /*--------------------------------------------------*/
299 /* swai: 12.1 Service costing (bug 6960295) */
300 /* procedure name: process_estimate_lines */
301 /* description : procedure used to create/update */
302 /* delete charge lines. This */
303 /* procedure allows the overriding */
304 /* of the create/update/delete cost */
305 /* flag introduced in the Charges */
306 /* API for 12.1 release */
307 /*--------------------------------------------------*/
308
309 PROCEDURE PROCESS_ESTIMATE_LINES(p_api_version IN NUMBER,
310 p_commit IN VARCHAR2 := Fnd_Api.g_false,
311 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
312 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
313 p_action IN VARCHAR2,
314 p_cs_cost_flag IN VARCHAR2 := 'Y',
315 x_Charges_Rec IN OUT NOCOPY Cs_Charge_Details_Pub.Charges_Rec_Type,
316 x_return_status OUT NOCOPY VARCHAR2,
317 x_msg_count OUT NOCOPY NUMBER,
318 x_msg_data OUT NOCOPY VARCHAR2);
319
320 /*--------------------------------------------------*/
321 /* procedure name: update_ro_group_estimate */
322 /* description : procedure used to update */
323 /* repair group for estimate changes*/
324 /*--------------------------------------------------*/
325 PROCEDURE UPDATE_RO_GROUP_ESTIMATE(p_api_version IN NUMBER,
326 p_commit IN VARCHAR2 := Fnd_Api.g_false,
327 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
328 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
329 p_repair_line_id IN NUMBER,
330 x_object_version_number OUT NOCOPY NUMBER,
331 x_return_status OUT NOCOPY VARCHAR2,
332 x_msg_count OUT NOCOPY NUMBER,
333 x_msg_data OUT NOCOPY VARCHAR2);
334
335 /*--------------------------------------------------*/
336 /* procedure name: create_repair_estimate */
337 /* description : procedure used to create */
338 /* repair estimate header */
339 /* */
340 /*--------------------------------------------------*/
341
342 PROCEDURE CREATE_REPAIR_ESTIMATE(p_api_version IN NUMBER,
343 p_commit IN VARCHAR2 := Fnd_Api.g_false,
344 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
345 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
346 x_estimate_rec IN OUT NOCOPY REPAIR_ESTIMATE_REC,
347 x_estimate_id OUT NOCOPY NUMBER,
348 x_return_status OUT NOCOPY VARCHAR2,
349 x_msg_count OUT NOCOPY NUMBER,
350 x_msg_data OUT NOCOPY VARCHAR2);
351
352 /*--------------------------------------------------*/
353 /* procedure name: update_repair_estimate */
354 /* description : procedure used to update */
355 /* repair estimate header */
356 /* */
357 /*--------------------------------------------------*/
358
359 PROCEDURE UPDATE_REPAIR_ESTIMATE(p_api_version IN NUMBER,
360 p_commit IN VARCHAR2 := Fnd_Api.g_false,
361 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
362 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
363 x_estimate_rec IN OUT NOCOPY REPAIR_ESTIMATE_REC,
364 x_return_status OUT NOCOPY VARCHAR2,
365 x_msg_count OUT NOCOPY NUMBER,
366 x_msg_data OUT NOCOPY VARCHAR2);
367
368 /*--------------------------------------------------*/
369 /* procedure name: delete_repair_estimate */
370 /* description : procedure used to delete */
371 /* repair estimate lines */
372 /* */
373 /*--------------------------------------------------*/
374
375 PROCEDURE DELETE_REPAIR_ESTIMATE(p_api_version IN NUMBER,
376 p_commit IN VARCHAR2 := Fnd_Api.g_false,
377 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
378 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
379 p_estimate_id IN NUMBER,
380 x_return_status OUT NOCOPY VARCHAR2,
381 x_msg_count OUT NOCOPY NUMBER,
382 x_msg_data OUT NOCOPY VARCHAR2);
383
384 /*--------------------------------------------------*/
385 /* procedure name: lock_repair_estimate */
386 /* description : procedure used to lock */
387 /* repair estimate lines */
388 /* */
389 /*--------------------------------------------------*/
390
391 PROCEDURE LOCK_REPAIR_ESTIMATE(p_api_version IN NUMBER,
392 p_commit IN VARCHAR2 := Fnd_Api.g_false,
393 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
394 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
395 p_estimate_rec IN REPAIR_ESTIMATE_REC,
396 x_return_status OUT NOCOPY VARCHAR2,
397 x_msg_count OUT NOCOPY NUMBER,
398 x_msg_data OUT NOCOPY VARCHAR2);
399
400 /*--------------------------------------------------*/
401 /* procedure name: create_repair_estimate_lines */
402 /* description : procedure used to create */
403 /* repair estimate lines */
404 /* */
405 /*--------------------------------------------------*/
406
407 PROCEDURE CREATE_REPAIR_ESTIMATE_LINES(p_api_version IN NUMBER,
408 p_commit IN VARCHAR2 := Fnd_Api.g_false,
409 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
410 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
411 x_estimate_line_rec IN OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC,
412 x_estimate_line_id OUT NOCOPY NUMBER,
413 x_return_status OUT NOCOPY VARCHAR2,
414 x_msg_count OUT NOCOPY NUMBER,
415 x_msg_data OUT NOCOPY VARCHAR2);
416
417 /*--------------------------------------------------*/
418 /* procedure name: update_repair_estimate_lines */
419 /* description : procedure used to update */
420 /* repair estimate lines */
421 /* */
422 /*--------------------------------------------------*/
423
424 PROCEDURE UPDATE_REPAIR_ESTIMATE_LINES(p_api_version IN NUMBER,
425 p_commit IN VARCHAR2 := Fnd_Api.g_false,
426 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
427 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
428 x_estimate_line_rec IN OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC,
429 x_return_status OUT NOCOPY VARCHAR2,
430 x_msg_count OUT NOCOPY NUMBER,
431 x_msg_data OUT NOCOPY VARCHAR2);
432
433 /*--------------------------------------------------*/
434 /* procedure name: delete_repair_estimate_lines */
435 /* description : procedure used to delete */
436 /* repair estimate lines */
437 /* */
438 /*--------------------------------------------------*/
439
440 PROCEDURE DELETE_REPAIR_ESTIMATE_LINES(p_api_version IN NUMBER,
441 p_commit IN VARCHAR2 := Fnd_Api.g_false,
442 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
443 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
444 p_estimate_line_id IN NUMBER,
445 x_return_status OUT NOCOPY VARCHAR2,
446 x_msg_count OUT NOCOPY NUMBER,
447 x_msg_data OUT NOCOPY VARCHAR2);
448
449 /*--------------------------------------------------*/
450 /* procedure name: lock_repair_estimate_lines */
451 /* description : procedure used to lock */
452 /* repair estimate lines */
453 /* */
454 /*--------------------------------------------------*/
455
456 PROCEDURE LOCK_REPAIR_ESTIMATE_LINES(p_api_version IN NUMBER,
457 p_commit IN VARCHAR2 := Fnd_Api.g_false,
458 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
459 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
460 p_estimate_line_rec IN REPAIR_ESTIMATE_LINE_REC,
461 x_return_status OUT NOCOPY VARCHAR2,
462 x_msg_count OUT NOCOPY NUMBER,
463 x_msg_data OUT NOCOPY VARCHAR2);
464
465 /*--------------------------------------------------*/
466 /* procedure name: repair_estimate_print */
467 /* description : procedure used to submit */
468 /* repair estimate concurrent program */
469 /* */
470 /*--------------------------------------------------*/
471
472 PROCEDURE REPAIR_ESTIMATE_PRINT(p_api_version IN NUMBER,
473 p_commit IN VARCHAR2 := Fnd_Api.g_false,
474 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
475 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
476 p_repair_line_id IN NUMBER,
477 x_request_id OUT NOCOPY NUMBER,
478 x_return_status OUT NOCOPY VARCHAR2,
479 x_msg_count OUT NOCOPY NUMBER,
480 x_msg_data OUT NOCOPY VARCHAR2);
481
482 /*--------------------------------------------------*/
483 /* procedure name: submit_estimate_lines */
484 /* description : procedure used to submit */
485 /* repair estimate lines */
486 /* */
487 /*--------------------------------------------------*/
488
489 PROCEDURE SUBMIT_REPAIR_ESTIMATE_LINES(p_api_version IN NUMBER,
490 p_commit IN VARCHAR2 := Fnd_Api.g_false,
491 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
492 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
493 p_repair_line_id IN NUMBER,
494 x_return_status OUT NOCOPY VARCHAR2,
495 x_msg_count OUT NOCOPY NUMBER,
496 x_msg_data OUT NOCOPY VARCHAR2);
497
498 --
499 -- swai 11.5.10
500 --
501 /*--------------------------------------------------*/
502 /* procedure name: Get_total_estimated_charge */
503 /* description : given a repair line id, returns */
504 /* the total estimated charge -- */
505 /* total of MLE charges on estimate*/
506 /* lines. If no estimate lines for*/
507 /* the repair line, return error */
508 /* status and null charge */
509 /*--------------------------------------------------*/
510 PROCEDURE get_total_estimated_charge(p_repair_line_id IN NUMBER,
511 x_estimated_charge OUT NOCOPY NUMBER,
512 x_return_status OUT NOCOPY VARCHAR2);
513
514 /*--------------------------------------------------*/
515 /* procedure name: Autocreate_Estimate_Lines */
516 /* description : The main procedure that is */
517 /* triggered by the click of the */
518 /* button on the `Estimates' tab. */
519 /* Creates all the estimate lines */
520 /* for TASK or BOM. */
521 /* x_warning_flag : FND_API.G_TRUE if any non-fatal */
522 /* errors occured. FND_API.G_FALSE */
523 /* if everything was successful. */
524 /* Note that this value could be */
525 /* G_TRUE even if x_return_status */
526 /* is G_RET_STS_SUCCESS */
527 /* called from: Depot Repair UI */
528 /*--------------------------------------------------*/
529 PROCEDURE Autocreate_Estimate_Lines(p_api_version IN NUMBER,
530 p_commit IN VARCHAR2 := Fnd_Api.g_false,
531 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
532 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
533 x_return_status OUT NOCOPY VARCHAR2,
534 x_msg_count OUT NOCOPY NUMBER,
535 x_msg_data OUT NOCOPY VARCHAR2,
536 p_repair_line_id IN NUMBER,
537 p_estimate_id IN NUMBER,
538 p_repair_type_id IN NUMBER,
539 p_business_process_id IN NUMBER,
540 p_currency_code IN VARCHAR2,
541 p_incident_id IN NUMBER,
542 p_repair_mode IN VARCHAR2,
543 p_inventory_item_id IN NUMBER,
544 p_organization_id IN NUMBER,
545 x_warning_flag OUT NOCOPY VARCHAR2);
546
547 /*--------------------------------------------------*/
548 /* procedure name: Get_Estimates_From_Task */
549 /* description : Fetches ML lines for the tasks */
550 /* associated via Service Codes and */
551 /* (optionally) Solution. */
552 /* x_warning_flag : FND_API.G_TRUE if any non-fatal */
553 /* errors occured. FND_API.G_FALSE */
554 /* if everything was successful. */
555 /* Note that this value could be */
556 /* G_TRUE even if x_return_status */
557 /* is G_RET_STS_SUCCESS */
558 /* called from: Autocreate_Estimate_Lines */
559 /*--------------------------------------------------*/
560 PROCEDURE Get_Estimates_From_Task(p_api_version IN NUMBER,
561 p_commit IN VARCHAR2,
562 p_init_msg_list IN VARCHAR2,
563 p_validation_level IN NUMBER,
564 x_return_status OUT NOCOPY VARCHAR2,
565 x_msg_count OUT NOCOPY NUMBER,
566 x_msg_data OUT NOCOPY VARCHAR2,
567 p_repair_line_id IN NUMBER,
568 p_estimate_id IN NUMBER,
569 p_repair_type_id IN NUMBER,
570 p_business_process_id IN NUMBER,
571 p_currency_code IN VARCHAR2,
572 p_incident_id IN NUMBER,
573 p_repair_mode IN VARCHAR2,
574 p_inventory_item_id IN NUMBER,
575 p_organization_id IN NUMBER,
576 p_price_list_id IN NUMBER,
577 p_contract_line_id IN NUMBER,
578 x_est_lines_tbl OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_TBL,
579 x_warning_flag OUT NOCOPY VARCHAR2);
580
581 /*--------------------------------------------------*/
582 /* procedure name: Get_Estimates_From_BOM */
583 /* description : Fetches ML lines for the */
584 /* BOM/Route references associated */
585 /* via Service Codes. */
586 /* x_warning_flag : FND_API.G_TRUE if any non-fatal */
587 /* errors occured. FND_API.G_FALSE */
588 /* if everything was successful. */
589 /* Note that this value could be */
590 /* G_TRUE even if x_return_status */
591 /* is G_RET_STS_SUCCESS */
592 /* called from: Autocreate_Estimate_Lines */
593 /*--------------------------------------------------*/
594 PROCEDURE Get_Estimates_From_BOM(p_api_version IN NUMBER,
595 p_commit IN VARCHAR2,
596 p_init_msg_list IN VARCHAR2,
597 p_validation_level IN NUMBER,
598 x_return_status OUT NOCOPY VARCHAR2,
599 x_msg_count OUT NOCOPY NUMBER,
600 x_msg_data OUT NOCOPY VARCHAR2,
601 p_repair_line_id IN NUMBER,
602 p_estimate_id IN NUMBER,
603 p_repair_type_id IN NUMBER,
604 p_business_process_id IN NUMBER,
605 p_currency_code IN VARCHAR2,
606 p_incident_id IN NUMBER,
607 p_repair_mode IN VARCHAR2,
608 p_inventory_item_id IN NUMBER,
609 p_organization_id IN NUMBER,
610 p_price_list_id IN NUMBER,
611 p_contract_line_id IN NUMBER,
612 x_est_lines_tbl OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_TBL,
613 x_warning_flag OUT NOCOPY VARCHAR2);
614
615 /*--------------------------------------------------*/
616 /* procedure name: Convert_To_Est_Lines */
617 /* description : The procedure to manipulate */
618 /* different structures. It converts*/
619 /* data from MLE_LINES_REC_TYPE to */
620 /* REPAIR_ESTIMATE_LINE_REC. It also*/
621 /* sets the item cost and logs */
622 /* warnings. */
623 /* x_warning_flag : FND_API.G_TRUE if any non-fatal */
624 /* errors occured. FND_API.G_FALSE */
625 /* if everything was successful. */
626 /* Note that this value could be */
627 /* G_TRUE even if x_return_status */
628 /* is G_RET_STS_SUCCESS */
629 /* called from: Get_Estimates_From_BOM */
630 /* Get_Estimates_From_Task */
631 /*--------------------------------------------------*/
632 PROCEDURE Convert_To_Est_Lines(p_api_version IN NUMBER,
633 p_commit IN VARCHAR2,
634 p_init_msg_list IN VARCHAR2,
635 p_validation_level IN NUMBER,
636 x_return_status OUT NOCOPY VARCHAR2,
637 x_msg_count OUT NOCOPY NUMBER,
638 x_msg_data OUT NOCOPY VARCHAR2,
639 p_repair_line_id IN NUMBER,
640 p_estimate_id IN NUMBER,
641 p_repair_type_id IN NUMBER,
642 p_business_process_id IN NUMBER,
643 p_currency_code IN VARCHAR2,
644 p_incident_id IN NUMBER,
645 p_organization_id IN NUMBER,
646 p_price_list_id IN NUMBER,
647 p_contract_line_id IN NUMBER,
648 p_MLE_lines_tbl IN MLE_LINES_TBL_TYPE,
649 x_est_lines_tbl IN OUT NOCOPY REPAIR_ESTIMATE_LINE_TBL,
650 x_warning_flag OUT NOCOPY VARCHAR2);
651 --
652 -- end swai 11.5.10
653 --
654
655 ----Begin change for 3931317, wrpper aPI forward port
656
657 /*----------------------------------------------------------------------------*/
658 /* procedure name: CREATE_ESTIMATE_HEADER */
659 /* description : Wrapper procedure used to create estimate header */
660 /* Updates repair order estimate approved flag and creates Depot estimate */
661 /* header record with information like, summary, lead time etc */
662 /* Change History : Created 7th Dec 2004 by Vijay */
663 /* 20-June-2005: Vijay: Modified the name from CREATE_EST_WRAPR */
664 /*----------------------------------------------------------------------------*/
665 PROCEDURE CREATE_ESTIMATE_HEADER(p_api_version IN NUMBER,
666 p_init_msg_list IN VARCHAR2,
667 p_commit IN VARCHAR2,
668 p_validation_level IN NUMBER,
669 x_return_status OUT NOCOPY VARCHAR2,
670 x_msg_count OUT NOCOPY NUMBER,
671 x_msg_data OUT NOCOPY VARCHAR2,
672 p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC,
673 x_estimate_hdr_id OUT NOCOPY NUMBER);
674
675 /*----------------------------------------------------------------------------*/
676 /* procedure name: UPDATE_ESTIMATE_HEADER */
677 /* description : procedure used to update estimate header */
678 /* Updates repair order estimate approved flag and creates Depot estimate */
679 /* header record with information like, summary, lead time etc */
680 /* Change History : Created 24-June-2005 by Vijay */
681 /*----------------------------------------------------------------------------*/
682 PROCEDURE UPDATE_ESTIMATE_HEADER(p_api_version IN NUMBER,
683 p_init_msg_list IN VARCHAR2,
684 p_commit IN VARCHAR2,
685 p_validation_level IN NUMBER,
686 x_return_status OUT NOCOPY VARCHAR2,
687 x_msg_count OUT NOCOPY NUMBER,
688 x_msg_data OUT NOCOPY VARCHAR2,
689 p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC,
690 x_object_version_number OUT NOCOPY NUMBER);
691
692 /*----------------------------------------------------------------------------*/
693 /* procedure name: CREATE_ESTIMATE_LINE */
694 /* description : Wrapper procedure used to create estimate line */
695 /* Creates Depot estimate line record and submits */
696 /* based on some validations. */
697 /* Change History : Created 7th Dec 2004 by Vijay */
698 /* 20-June-2005: Vijay: Modified the name from CREATE_EST_LINE_WRAPR */
699 /*----------------------------------------------------------------------------*/
700
701 PROCEDURE CREATE_ESTIMATE_LINE(p_api_version IN NUMBER,
702 p_init_msg_list IN VARCHAR2,
703 p_commit IN VARCHAR2,
704 p_validation_level IN NUMBER,
705 x_return_status OUT NOCOPY VARCHAR2,
706 x_msg_count OUT NOCOPY NUMBER,
707 x_msg_data OUT NOCOPY VARCHAR2,
708 p_estimate_line_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC,
709 x_estimate_line_id OUT NOCOPY NUMBER);
710
711 /*----------------------------------------------------------------------------*/
712 /* procedure name: UPDATE_ESTIMATE_LINE */
713 /* description : procedure used to update estimate line */
714 /* Updates Depot estimate line record and submits */
715 /* based on some validations. */
716 /* Change History : Created 24-June-2005 by Vijay */
717 /*----------------------------------------------------------------------------*/
718
719 PROCEDURE UPDATE_ESTIMATE_LINE(p_api_version IN NUMBER,
720 p_init_msg_list IN VARCHAR2,
721 p_commit IN VARCHAR2,
722 p_validation_level IN NUMBER,
723 x_return_status OUT NOCOPY VARCHAR2,
724 x_msg_count OUT NOCOPY NUMBER,
725 x_msg_data OUT NOCOPY VARCHAR2,
726 p_estimate_line_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC,
727 x_object_version_number OUT NOCOPY NUMBER);
728
729 -- swai: bug 14804275, FP of bug 14752421 new procedure for creating estimates from wip
730 /*--------------------------------------------------------------------*/
731 /* procedure name: Import_Estimates_From_Wip */
732 /* description : Procedure is used to import WIP debrief lines into */
733 /* repair estimate lines. We consider material and */
734 /* resource transactions as well as untransacted */
735 /* material and resource requirements to create */
736 /* charge/repair estimate lines */
737 /* */
738 /* Called from : CSD_HV_WIP_JOB_PVT.generate_estimate_from_wip */
739 /* */
740 /* x_warning_flag : This flag communicates to the calling procedure */
741 /* whether there are any messages logged that can be */
742 /* displayed to the user. If the value is G_TRUE */
743 /* then it indicates that one or more message have */
744 /* been logged. */
745 /* */
746 /*--------------------------------------------------------------------*/
747 PROCEDURE Import_Estimates_From_Wip( p_api_version IN NUMBER,
748 p_commit IN VARCHAR2,
749 p_init_msg_list IN VARCHAR2,
750 p_validation_level IN NUMBER,
751 x_return_status OUT NOCOPY VARCHAR2,
752 x_msg_count OUT NOCOPY NUMBER,
753 x_msg_data OUT NOCOPY VARCHAR2,
754 p_repair_line_id IN NUMBER,
755 p_repair_estimate_id IN NUMBER,
756 p_repair_type_id IN NUMBER,
757 p_business_process_id IN NUMBER,
758 p_currency_code IN VARCHAR2,
759 p_incident_id IN NUMBER,
760 p_organization_id IN NUMBER,
761 x_warning_flag OUT NOCOPY VARCHAR2 );
762
763 END Csd_Repair_Estimate_Pvt;