[Home] [Help]
PACKAGE: APPS.CSD_REPAIR_ESTIMATE_PUB
Source
1 PACKAGE Csd_Repair_Estimate_Pub AUTHID CURRENT_USER AS
2 /* $Header: csdpests.pls 120.8 2012/03/27 23:21:13 swai ship $ */
3 /*#
4 -- * This is the public interface for managing a repair estimate. It allows
5 -- * creation of repair estimate for a repair order.
6 */
7
8 /*--------------------------------------------------*/
9 /* Record name: ESTIMATE_HDR_REC_TYPE */
10 /* description : Record used for repair estimate rec*/
11 /* */
12 /*--------------------------------------------------*/
13
14 TYPE ESTIMATE_HDR_REC IS RECORD(
15 repair_estimate_id NUMBER,
16 repair_line_id NUMBER,
17 note_id NUMBER,
18 estimate_date DATE,
19 estimate_status VARCHAR2(30),
20 lead_time NUMBER,
21 lead_time_uom VARCHAR2(30),
22 estimate_freeze_flag VARCHAR2(1),
23 work_summary VARCHAR2(240),
24 po_number VARCHAR2(50),
25 estimate_reason_code VARCHAR2(30),
26 last_update_date DATE,
27 creation_date DATE,
28 last_updated_by NUMBER,
29 created_by NUMBER,
30 last_update_login NUMBER,
31 attribute1 VARCHAR2(150),
32 attribute2 VARCHAR2(150),
33 attribute3 VARCHAR2(150),
34 attribute4 VARCHAR2(150),
35 attribute5 VARCHAR2(150),
36 attribute6 VARCHAR2(150),
37 attribute7 VARCHAR2(150),
38 attribute8 VARCHAR2(150),
39 attribute9 VARCHAR2(150),
40 attribute10 VARCHAR2(150),
41 attribute11 VARCHAR2(150),
42 attribute12 VARCHAR2(150),
43 attribute13 VARCHAR2(150),
44 attribute14 VARCHAR2(150),
45 attribute15 VARCHAR2(150),
46 context VARCHAR2(30),
47 object_version_number NUMBER,
48 -- These two are added for updating repair order status when the status is
49 -- accepted or rejected.
50 repair_line_quantity NUMBER,
51 ro_object_version_number NUMBER,
52 not_to_exceed NUMBER := NULL -- swai: bug 9462789
53 );
54
55 /*--------------------------------------------------*/
56 /* Record name: ESTIMATE_LINE_REC */
57 /* description : Record used for repair estimate rec*/
58 /* */
59 /*--------------------------------------------------*/
60
61 TYPE ESTIMATE_LINE_REC IS RECORD(
62 billing_Category VARCHAR2(30),
63 repair_estimate_line_id NUMBER,
64 repair_estimate_id NUMBER,
65 repair_line_id NUMBER,
66 estimate_detail_id NUMBER,
67 incident_id NUMBER,
68 transaction_type_id NUMBER,
69 business_process_id NUMBER,
70 txn_billing_type_id NUMBER,
71 original_source_id NUMBER,
72 original_source_code VARCHAR2(10),
73 source_id NUMBER,
74 source_code VARCHAR2(10),
75 line_type_id NUMBER,
76 item_cost NUMBER,
77 resource_id NUMBER,
78 customer_product_id NUMBER,
79 reference_number NUMBER,
80 item_revision VARCHAR2(30),
81 justification_notes VARCHAR2(240),
82 estimate_status VARCHAR2(30),
83 order_number VARCHAR2(30),
84 purchase_order_num VARCHAR2(50),
85 source_number VARCHAR2(30),
86 status VARCHAR2(30),
87 currency_code VARCHAR2(15),
88 line_category_code VARCHAR2(6),
89 unit_of_measure_code VARCHAR2(3),
90 original_source_number VARCHAR2(3),
91 add_to_order_flag VARCHAR2(1),
92 order_header_id NUMBER,
93 order_line_id NUMBER,
94 inventory_item_id NUMBER,
95 after_warranty_cost NUMBER,
96 selling_price NUMBER,
97 original_system_reference VARCHAR2(30),
98 estimate_quantity NUMBER,
99 serial_number VARCHAR2(50),
100 lot_number VARCHAR2(80), -- fix for bug#4625226
101 instance_id NUMBER,
102 instance_number NUMBER,
103 price_list_id NUMBER,
104 contract_id NUMBER,
105 contract_number VARCHAR2(120),
106 coverage_bill_rate_id NUMBER,
107 sub_inventory VARCHAR2(30),
108 organization_id NUMBER,
109 invoice_to_org_id NUMBER,
110 ship_to_org_id NUMBER,
111 no_charge_flag VARCHAR2(1),
112 override_charge_flag VARCHAR2(1),
113 interface_to_om_flag VARCHAR2(1),
114 return_reason VARCHAR2(30),
115 return_by_date DATE,
116 last_update_date DATE,
117 creation_date DATE,
118 last_updated_by NUMBER,
119 created_by NUMBER,
120 last_update_login NUMBER,
121 attribute1 VARCHAR2(150),
122 attribute2 VARCHAR2(150),
123 attribute3 VARCHAR2(150),
124 attribute4 VARCHAR2(150),
125 attribute5 VARCHAR2(150),
126 attribute6 VARCHAR2(150),
127 attribute7 VARCHAR2(150),
128 attribute8 VARCHAR2(150),
129 attribute9 VARCHAR2(150),
130 attribute10 VARCHAR2(150),
131 attribute11 VARCHAR2(150),
132 attribute12 VARCHAR2(150),
133 attribute13 VARCHAR2(150),
134 attribute14 VARCHAR2(150),
135 attribute15 VARCHAR2(150),
136 context VARCHAR2(30),
137 object_version_number NUMBER,
138 security_group_id NUMBER,
139 charge_line_type VARCHAR2(30),
140 apply_contract_discount VARCHAR2(1),
141 coverage_id NUMBER,
142 coverage_txn_group_id NUMBER,
143 contract_discount_amount NUMBER,
144 EST_LINE_SOURCE_TYPE_CODE VARCHAR2(30),
145 EST_LINE_SOURCE_ID1 NUMBER,
146 EST_LINE_SOURCE_ID2 NUMBER,
147 RO_SERVICE_CODE_ID NUMBER,
148 pricing_context VARCHAR2(30),
149 pricing_attribute1 VARCHAR2(150),
150 pricing_attribute2 VARCHAR2(150),
151 pricing_attribute3 VARCHAR2(150),
152 pricing_attribute4 VARCHAR2(150),
153 pricing_attribute5 VARCHAR2(150),
154 pricing_attribute6 VARCHAR2(150),
155 pricing_attribute7 VARCHAR2(150),
156 pricing_attribute8 VARCHAR2(150),
157 pricing_attribute9 VARCHAR2(150),
158 pricing_attribute10 VARCHAR2(150),
159 pricing_attribute11 VARCHAR2(150),
160 pricing_attribute12 VARCHAR2(150),
161 pricing_attribute13 VARCHAR2(150),
162 pricing_attribute14 VARCHAR2(150),
163 pricing_attribute15 VARCHAR2(150),
164 pricing_attribute16 VARCHAR2(150),
165 pricing_attribute17 VARCHAR2(150),
166 pricing_attribute18 VARCHAR2(150),
167 pricing_attribute19 VARCHAR2(150),
168 pricing_attribute20 VARCHAR2(150),
169 pricing_attribute21 VARCHAR2(150),
170 pricing_attribute22 VARCHAR2(150),
171 pricing_attribute23 VARCHAR2(150),
172 pricing_attribute24 VARCHAR2(150),
173 pricing_attribute25 VARCHAR2(150),
174 pricing_attribute26 VARCHAR2(150),
175 pricing_attribute27 VARCHAR2(150),
176 pricing_attribute28 VARCHAR2(150),
177 pricing_attribute29 VARCHAR2(150),
178 pricing_attribute30 VARCHAR2(150),
179 pricing_attribute31 VARCHAR2(150),
180 pricing_attribute32 VARCHAR2(150),
181 pricing_attribute33 VARCHAR2(150),
182 pricing_attribute34 VARCHAR2(150),
183 pricing_attribute35 VARCHAR2(150),
184 pricing_attribute36 VARCHAR2(150),
185 pricing_attribute37 VARCHAR2(150),
186 pricing_attribute38 VARCHAR2(150),
187 pricing_attribute39 VARCHAR2(150),
188 pricing_attribute40 VARCHAR2(150),
189 pricing_attribute41 VARCHAR2(150),
190 pricing_attribute42 VARCHAR2(150),
191 pricing_attribute43 VARCHAR2(150),
192 pricing_attribute44 VARCHAR2(150),
193 pricing_attribute45 VARCHAR2(150),
194 pricing_attribute46 VARCHAR2(150),
195 pricing_attribute47 VARCHAR2(150),
196 pricing_attribute48 VARCHAR2(150),
197 pricing_attribute49 VARCHAR2(150),
198 pricing_attribute50 VARCHAR2(150),
199 pricing_attribute51 VARCHAR2(150),
200 pricing_attribute52 VARCHAR2(150),
201 pricing_attribute53 VARCHAR2(150),
202 pricing_attribute54 VARCHAR2(150),
203 pricing_attribute55 VARCHAR2(150),
204 pricing_attribute56 VARCHAR2(150),
205 pricing_attribute57 VARCHAR2(150),
206 pricing_attribute58 VARCHAR2(150),
207 pricing_attribute59 VARCHAR2(150),
208 pricing_attribute60 VARCHAR2(150),
209 pricing_attribute61 VARCHAR2(150),
210 pricing_attribute62 VARCHAR2(150),
211 pricing_attribute63 VARCHAR2(150),
212 pricing_attribute64 VARCHAR2(150),
213 pricing_attribute65 VARCHAR2(150),
214 pricing_attribute66 VARCHAR2(150),
215 pricing_attribute67 VARCHAR2(150),
216 pricing_attribute68 VARCHAR2(150),
217 pricing_attribute69 VARCHAR2(150),
218 pricing_attribute70 VARCHAR2(150),
219 pricing_attribute71 VARCHAR2(150),
220 pricing_attribute72 VARCHAR2(150),
221 pricing_attribute73 VARCHAR2(150),
222 pricing_attribute74 VARCHAR2(150),
223 pricing_attribute75 VARCHAR2(150),
224 pricing_attribute76 VARCHAR2(150),
225 pricing_attribute77 VARCHAR2(150),
226 pricing_attribute78 VARCHAR2(150),
227 pricing_attribute79 VARCHAR2(150),
228 pricing_attribute80 VARCHAR2(150),
229 pricing_attribute81 VARCHAR2(150),
230 pricing_attribute82 VARCHAR2(150),
231 pricing_attribute83 VARCHAR2(150),
232 pricing_attribute84 VARCHAR2(150),
233 pricing_attribute85 VARCHAR2(150),
234 pricing_attribute86 VARCHAR2(150),
235 pricing_attribute87 VARCHAR2(150),
236 pricing_attribute88 VARCHAR2(150),
237 pricing_attribute89 VARCHAR2(150),
238 pricing_attribute90 VARCHAR2(150),
239 pricing_attribute91 VARCHAR2(150),
240 pricing_attribute92 VARCHAR2(150),
241 pricing_attribute93 VARCHAR2(150),
242 pricing_attribute94 VARCHAR2(150),
243 pricing_attribute95 VARCHAR2(150),
244 pricing_attribute96 VARCHAR2(150),
245 pricing_attribute97 VARCHAR2(150),
246 pricing_attribute98 VARCHAR2(150),
247 pricing_attribute99 VARCHAR2(150),
248 pricing_attribute100 VARCHAR2(150),
249 contract_line_id NUMBER, -- yvchen: bug 12545399
250 rate_type_code VARCHAR2(40) -- yvchen: bug 12545399
251 );
252
253 TYPE ESTIMATE_LINE_TBL IS TABLE OF ESTIMATE_LINE_REC INDEX BY BINARY_INTEGER;
254
255 /*--------------------------------------------------*/
256 /* procedure name: create_estimate_header */
257 /* description : procedure used to create */
258 /* repair estimate header */
259 /* */
260 /*--------------------------------------------------*/
261
262 /*#
263 -- * Creates a new Repair Estimate header for the given Repair order. The Estimate Header
264 */
265 PROCEDURE CREATE_ESTIMATE_HEADER(p_api_version IN NUMBER,
266 p_commit IN VARCHAR2,
267 p_init_msg_list IN VARCHAR2,
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_msg_data OUT NOCOPY VARCHAR2,
271 p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC,
272 x_estimate_hdr_id OUT NOCOPY NUMBER);
273
274 /*--------------------------------------------------*/
275 /* procedure name: update_estimate_header */
276 /* description : procedure used to update */
277 /* repair estimate header */
278 /* */
279 /*--------------------------------------------------*/
280
281 /*#
282 -- * Updates a given estimate header record.
283 */
284 PROCEDURE UPDATE_ESTIMATE_HEADER(p_api_version IN NUMBER,
285 p_commit IN VARCHAR2,
286 p_init_msg_list IN VARCHAR2,
287 x_return_status OUT NOCOPY VARCHAR2,
288 x_msg_count OUT NOCOPY NUMBER,
289 x_msg_data OUT NOCOPY VARCHAR2,
290 p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC,
291 x_object_version_number OUT NOCOPY NUMBER);
292
293 /*#
294 -- * Creates an estimate line record under an estimate header.
295 */
296 PROCEDURE CREATE_ESTIMATE_LINE(p_api_version IN NUMBER,
297 p_commit IN VARCHAR2,
298 p_init_msg_list IN VARCHAR2,
299 x_return_status OUT NOCOPY VARCHAR2,
300 x_msg_count OUT NOCOPY NUMBER,
301 x_msg_data OUT NOCOPY VARCHAR2,
302 p_estimate_line_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC,
303 x_estimate_line_id OUT NOCOPY NUMBER);
304
305 /*#
306 -- * Updates a given estimate line record.
307 */
308 PROCEDURE UPDATE_ESTIMATE_LINE(p_api_version IN NUMBER,
309 p_init_msg_list IN VARCHAR2,
310 p_commit IN VARCHAR2,
311 x_return_status OUT NOCOPY VARCHAR2,
312 x_msg_count OUT NOCOPY NUMBER,
313 x_msg_data OUT NOCOPY VARCHAR2,
314 p_estimate_line_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC,
315 x_object_version_number OUT NOCOPY NUMBER);
316
317 END Csd_Repair_Estimate_Pub;