1 PACKAGE CSD_RETURNS_UTIL AUTHID CURRENT_USER AS
2 /* $Header: csdurets.pls 120.3.12020000.2 2013/04/08 10:37:39 subhat ship $ */
3 -- Start of Comments
4 -- Package name : CSD_RETURNS_UTIL
5 -- Purpose : Mar-07-2011 subhat created
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 /********************************************************************************/
11 /* Procedure Name: Get_warranty_status */
12 /* Description: returns if each return line is covered by oracle service */
13 /* contracts or not. There is a call out to a user hook before and */
14 /* after the warranty status calculation. */
15 /********************************************************************************/
16 PROCEDURE get_warranty_status
17 (p_api_version IN NUMBER DEFAULT 1.0,
18 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
19 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
20 p_item_ids IN JTF_NUMBER_TABLE,
21 p_serial_nums IN JTF_VARCHAR2_TABLE_100,
22 p_customer_id IN NUMBER,
23 p_account_id IN NUMBER,
24 p_bill_to_site_use_id IN NUMBER,
25 p_ship_to_site_use_id IN NUMBER,
26 p_instance_ids IN JTF_NUMBER_TABLE,
27 x_contract_ids OUT NOCOPY JTF_NUMBER_TABLE,
28 x_contract_line_ids OUT NOCOPY JTF_NUMBER_TABLE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE return_parameter_value
35 (p_api_version IN NUMBER DEFAULT 1.0,
36 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
37 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
39 p_param_code IN VARCHAR2,
40 p_return_type IN NUMBER,
41 p_customer_id IN NUMBER,
42 p_bill_to_site_use_id IN NUMBER,
43 p_ship_to_site_use_id IN NUMBER,
44 p_item_id IN NUMBER,
45 p_item_category_id IN NUMBER,
46 p_contract_id IN NUMBER,
47 x_param_value OUT NOCOPY VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2
51 );
52 PROCEDURE get_estimated_price
53 (p_api_version IN NUMBER DEFAULT 1.0,
54 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
55 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56 p_item_ids IN JTF_NUMBER_TABLE,
57 p_contract_ids IN JTF_NUMBER_TABLE,
58 p_contract_line_ids IN JTF_NUMBER_TABLE,
59 p_repair_type_ids IN JTF_NUMBER_TABLE,
60 p_uom_codes IN JTF_VARCHAR2_TABLE_100,
61 p_quantities IN JTF_NUMBER_TABLE,
62 p_pricing_ATTRIBUTE1 IN JTF_VARCHAR2_TABLE_300,
63 p_pricing_ATTRIBUTE2 IN JTF_VARCHAR2_TABLE_300,
64 p_pricing_ATTRIBUTE3 IN JTF_VARCHAR2_TABLE_300,
65 p_pricing_ATTRIBUTE4 IN JTF_VARCHAR2_TABLE_300,
66 p_pricing_ATTRIBUTE5 IN JTF_VARCHAR2_TABLE_300,
67 p_pricing_ATTRIBUTE6 IN JTF_VARCHAR2_TABLE_300,
68 p_pricing_ATTRIBUTE7 IN JTF_VARCHAR2_TABLE_300,
69 p_pricing_ATTRIBUTE8 IN JTF_VARCHAR2_TABLE_300,
70 p_pricing_ATTRIBUTE9 IN JTF_VARCHAR2_TABLE_300,
71 p_pricing_ATTRIBUTE10 IN JTF_VARCHAR2_TABLE_300,
72 p_pricing_ATTRIBUTE11 IN JTF_VARCHAR2_TABLE_300,
73 p_pricing_ATTRIBUTE12 IN JTF_VARCHAR2_TABLE_300,
74 p_pricing_ATTRIBUTE13 IN JTF_VARCHAR2_TABLE_300,
75 p_pricing_ATTRIBUTE14 IN JTF_VARCHAR2_TABLE_300,
76 p_pricing_ATTRIBUTE15 IN JTF_VARCHAR2_TABLE_300,
77 p_pricing_ATTRIBUTE16 IN JTF_VARCHAR2_TABLE_300,
78 p_pricing_ATTRIBUTE17 IN JTF_VARCHAR2_TABLE_300,
79 p_pricing_ATTRIBUTE18 IN JTF_VARCHAR2_TABLE_300,
80 p_pricing_ATTRIBUTE19 IN JTF_VARCHAR2_TABLE_300,
81 p_pricing_ATTRIBUTE20 IN JTF_VARCHAR2_TABLE_300,
82 p_pricing_ATTRIBUTE21 IN JTF_VARCHAR2_TABLE_300,
83 p_pricing_ATTRIBUTE22 IN JTF_VARCHAR2_TABLE_300,
84 p_pricing_ATTRIBUTE23 IN JTF_VARCHAR2_TABLE_300,
85 p_pricing_ATTRIBUTE24 IN JTF_VARCHAR2_TABLE_300,
86 p_pricing_ATTRIBUTE25 IN JTF_VARCHAR2_TABLE_300,
87 p_pricing_ATTRIBUTE26 IN JTF_VARCHAR2_TABLE_300,
88 p_pricing_ATTRIBUTE27 IN JTF_VARCHAR2_TABLE_300,
89 p_pricing_ATTRIBUTE28 IN JTF_VARCHAR2_TABLE_300,
90 p_pricing_ATTRIBUTE29 IN JTF_VARCHAR2_TABLE_300,
91 p_pricing_ATTRIBUTE30 IN JTF_VARCHAR2_TABLE_300,
92 p_pricing_ATTRIBUTE31 IN JTF_VARCHAR2_TABLE_300,
93 p_pricing_ATTRIBUTE32 IN JTF_VARCHAR2_TABLE_300,
94 p_pricing_ATTRIBUTE33 IN JTF_VARCHAR2_TABLE_300,
95 p_pricing_ATTRIBUTE34 IN JTF_VARCHAR2_TABLE_300,
96 p_pricing_ATTRIBUTE35 IN JTF_VARCHAR2_TABLE_300,
97 p_pricing_ATTRIBUTE36 IN JTF_VARCHAR2_TABLE_300,
98 p_pricing_ATTRIBUTE37 IN JTF_VARCHAR2_TABLE_300,
99 p_pricing_ATTRIBUTE38 IN JTF_VARCHAR2_TABLE_300,
100 p_pricing_ATTRIBUTE39 IN JTF_VARCHAR2_TABLE_300,
101 p_pricing_ATTRIBUTE40 IN JTF_VARCHAR2_TABLE_300,
102 p_pricing_ATTRIBUTE41 IN JTF_VARCHAR2_TABLE_300,
103 p_pricing_ATTRIBUTE42 IN JTF_VARCHAR2_TABLE_300,
104 p_pricing_ATTRIBUTE43 IN JTF_VARCHAR2_TABLE_300,
105 p_pricing_ATTRIBUTE44 IN JTF_VARCHAR2_TABLE_300,
106 p_pricing_ATTRIBUTE45 IN JTF_VARCHAR2_TABLE_300,
107 p_pricing_ATTRIBUTE46 IN JTF_VARCHAR2_TABLE_300,
108 p_pricing_ATTRIBUTE47 IN JTF_VARCHAR2_TABLE_300,
109 p_pricing_ATTRIBUTE48 IN JTF_VARCHAR2_TABLE_300,
110 p_pricing_ATTRIBUTE49 IN JTF_VARCHAR2_TABLE_300,
111 p_pricing_ATTRIBUTE50 IN JTF_VARCHAR2_TABLE_300,
112 p_pricing_ATTRIBUTE51 IN JTF_VARCHAR2_TABLE_300,
113 p_pricing_ATTRIBUTE52 IN JTF_VARCHAR2_TABLE_300,
114 p_pricing_ATTRIBUTE53 IN JTF_VARCHAR2_TABLE_300,
115 p_pricing_ATTRIBUTE54 IN JTF_VARCHAR2_TABLE_300,
116 p_pricing_ATTRIBUTE55 IN JTF_VARCHAR2_TABLE_300,
117 p_pricing_ATTRIBUTE56 IN JTF_VARCHAR2_TABLE_300,
118 p_pricing_ATTRIBUTE57 IN JTF_VARCHAR2_TABLE_300,
119 p_pricing_ATTRIBUTE58 IN JTF_VARCHAR2_TABLE_300,
120 p_pricing_ATTRIBUTE59 IN JTF_VARCHAR2_TABLE_300,
121 p_pricing_ATTRIBUTE60 IN JTF_VARCHAR2_TABLE_300,
122 p_pricing_ATTRIBUTE61 IN JTF_VARCHAR2_TABLE_300,
123 p_pricing_ATTRIBUTE62 IN JTF_VARCHAR2_TABLE_300,
124 p_pricing_ATTRIBUTE63 IN JTF_VARCHAR2_TABLE_300,
125 p_pricing_ATTRIBUTE64 IN JTF_VARCHAR2_TABLE_300,
126 p_pricing_ATTRIBUTE65 IN JTF_VARCHAR2_TABLE_300,
127 p_pricing_ATTRIBUTE66 IN JTF_VARCHAR2_TABLE_300,
128 p_pricing_ATTRIBUTE67 IN JTF_VARCHAR2_TABLE_300,
129 p_pricing_ATTRIBUTE68 IN JTF_VARCHAR2_TABLE_300,
130 p_pricing_ATTRIBUTE69 IN JTF_VARCHAR2_TABLE_300,
131 p_pricing_ATTRIBUTE70 IN JTF_VARCHAR2_TABLE_300,
132 p_pricing_ATTRIBUTE71 IN JTF_VARCHAR2_TABLE_300,
133 p_pricing_ATTRIBUTE72 IN JTF_VARCHAR2_TABLE_300,
134 p_pricing_ATTRIBUTE73 IN JTF_VARCHAR2_TABLE_300,
135 p_pricing_ATTRIBUTE74 IN JTF_VARCHAR2_TABLE_300,
136 p_pricing_ATTRIBUTE75 IN JTF_VARCHAR2_TABLE_300,
137 p_pricing_ATTRIBUTE76 IN JTF_VARCHAR2_TABLE_300,
138 p_pricing_ATTRIBUTE77 IN JTF_VARCHAR2_TABLE_300,
139 p_pricing_ATTRIBUTE78 IN JTF_VARCHAR2_TABLE_300,
140 p_pricing_ATTRIBUTE79 IN JTF_VARCHAR2_TABLE_300,
141 p_pricing_ATTRIBUTE80 IN JTF_VARCHAR2_TABLE_300,
142 p_pricing_ATTRIBUTE81 IN JTF_VARCHAR2_TABLE_300,
143 p_pricing_ATTRIBUTE82 IN JTF_VARCHAR2_TABLE_300,
144 p_pricing_ATTRIBUTE83 IN JTF_VARCHAR2_TABLE_300,
145 p_pricing_ATTRIBUTE84 IN JTF_VARCHAR2_TABLE_300,
146 p_pricing_ATTRIBUTE85 IN JTF_VARCHAR2_TABLE_300,
147 p_pricing_ATTRIBUTE86 IN JTF_VARCHAR2_TABLE_300,
148 p_pricing_ATTRIBUTE87 IN JTF_VARCHAR2_TABLE_300,
149 p_pricing_ATTRIBUTE88 IN JTF_VARCHAR2_TABLE_300,
150 p_pricing_ATTRIBUTE89 IN JTF_VARCHAR2_TABLE_300,
151 p_pricing_ATTRIBUTE90 IN JTF_VARCHAR2_TABLE_300,
152 p_pricing_ATTRIBUTE91 IN JTF_VARCHAR2_TABLE_300,
153 p_pricing_ATTRIBUTE92 IN JTF_VARCHAR2_TABLE_300,
154 p_pricing_ATTRIBUTE93 IN JTF_VARCHAR2_TABLE_300,
155 p_pricing_ATTRIBUTE94 IN JTF_VARCHAR2_TABLE_300,
156 p_pricing_ATTRIBUTE95 IN JTF_VARCHAR2_TABLE_300,
157 p_pricing_ATTRIBUTE96 IN JTF_VARCHAR2_TABLE_300,
158 p_pricing_ATTRIBUTE97 IN JTF_VARCHAR2_TABLE_300,
159 p_pricing_ATTRIBUTE98 IN JTF_VARCHAR2_TABLE_300,
160 p_pricing_ATTRIBUTE99 IN JTF_VARCHAR2_TABLE_300,
161 p_pricing_ATTRIBUTE100 IN JTF_VARCHAR2_TABLE_300,
162 p_pricing_CONTEXT IN JTF_VARCHAR2_TABLE_300,
163 x_prices OUT NOCOPY JTF_NUMBER_TABLE,
164 x_price_lists OUT NOCOPY JTF_NUMBER_TABLE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_currency OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_account_id IN NUMBER
170 );
171
172 PROCEDURE process_credit_card
173 (p_api_version IN NUMBER DEFAULT 1.0,
174 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
175 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
176 p_cc_number IN VARCHAR2,
177 p_cch_name IN VARCHAR2,
178 p_expiry_date IN DATE,
179 p_card_issuer_code IN VARCHAR2,
180 p_party_id IN NUMBER,
181 p_account_id IN NUMBER,
182 p_bill_to_site_use_id IN NUMBER,
183 p_ship_to_site_use_id IN NUMBER,
184 p_amount IN NUMBER,
185 p_currency_code IN VARCHAR2,
186 p_authorize_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
187 p_create_txn_extn_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
188 p_add_instr_asgn_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
189 p_order_id IN VARCHAR2,
190 x_instr_id OUT NOCOPY NUMBER,
191 x_txn_id OUT NOCOPY NUMBER,
192 x_authorized_flag OUT NOCOPY VARCHAR2,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg OUT NOCOPY VARCHAR2
195 );
196
197 PROCEDURE create_address
198 (p_api_version IN NUMBER DEFAULT 1.0,
199 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
200 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
201 p_party_id IN VARCHAR2,
202 p_site_use_type IN VARCHAR2,
203 p_country IN VARCHAR2,
204 p_address1 IN VARCHAR2,
205 p_address2 IN VARCHAR2,
206 p_address3 IN VARCHAR2,
207 p_address4 IN VARCHAR2,
208 p_city IN VARCHAR2,
209 p_postal_code IN VARCHAR2,
210 p_state IN VARCHAR2,
211 p_province IN VARCHAR2,
212 p_county IN VARCHAR2,
213 p_address_style IN VARCHAR2,
214 p_address_lines_phonetic IN VARCHAR2,
215 p_location_id IN NUMBER DEFAULT NULL,
216 x_location_id OUT NOCOPY NUMBER,
217 x_party_site_id OUT NOCOPY NUMBER,
218 x_party_site_use_id OUT NOCOPY NUMBER,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2
222 );
223
224
225 PROCEDURE process_returns
226 (p_api_version IN NUMBER DEFAULT 1.0,
227 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
228 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229 p_party_id IN NUMBER,
230 p_account_id IN NUMBER,
231 p_item_ids IN JTF_NUMBER_TABLE,
232 p_contract_ids IN JTF_NUMBER_TABLE,
233 p_contract_line_ids IN JTF_NUMBER_TABLE,
234 p_repair_type_ids IN JTF_NUMBER_TABLE,
235 p_uom_codes IN JTF_VARCHAR2_TABLE_100,
236 p_quantities IN JTF_NUMBER_TABLE,
237 p_price_lists IN JTF_NUMBER_TABLE,
238 p_external_refs IN JTF_VARCHAR2_TABLE_100,
239 p_serial_nums IN JTF_VARCHAR2_TABLE_100,
240 p_bill_to_addr_use_id IN NUMBER,
241 p_ship_to_addr_use_id IN NUMBER,
242 p_instance_ids IN JTF_NUMBER_TABLE,
243 p_pricing_ATTRIBUTE1 IN JTF_VARCHAR2_TABLE_300, -- pricing attributes start
244 p_pricing_ATTRIBUTE2 IN JTF_VARCHAR2_TABLE_300,
245 p_pricing_ATTRIBUTE3 IN JTF_VARCHAR2_TABLE_300,
246 p_pricing_ATTRIBUTE4 IN JTF_VARCHAR2_TABLE_300,
247 p_pricing_ATTRIBUTE5 IN JTF_VARCHAR2_TABLE_300,
248 p_pricing_ATTRIBUTE6 IN JTF_VARCHAR2_TABLE_300,
249 p_pricing_ATTRIBUTE7 IN JTF_VARCHAR2_TABLE_300,
250 p_pricing_ATTRIBUTE8 IN JTF_VARCHAR2_TABLE_300,
251 p_pricing_ATTRIBUTE9 IN JTF_VARCHAR2_TABLE_300,
252 p_pricing_ATTRIBUTE10 IN JTF_VARCHAR2_TABLE_300,
253 p_pricing_ATTRIBUTE11 IN JTF_VARCHAR2_TABLE_300,
254 p_pricing_ATTRIBUTE12 IN JTF_VARCHAR2_TABLE_300,
255 p_pricing_ATTRIBUTE13 IN JTF_VARCHAR2_TABLE_300,
256 p_pricing_ATTRIBUTE14 IN JTF_VARCHAR2_TABLE_300,
257 p_pricing_ATTRIBUTE15 IN JTF_VARCHAR2_TABLE_300,
258 p_pricing_ATTRIBUTE16 IN JTF_VARCHAR2_TABLE_300,
259 p_pricing_ATTRIBUTE17 IN JTF_VARCHAR2_TABLE_300,
260 p_pricing_ATTRIBUTE18 IN JTF_VARCHAR2_TABLE_300,
261 p_pricing_ATTRIBUTE19 IN JTF_VARCHAR2_TABLE_300,
262 p_pricing_ATTRIBUTE20 IN JTF_VARCHAR2_TABLE_300,
263 p_pricing_ATTRIBUTE21 IN JTF_VARCHAR2_TABLE_300,
264 p_pricing_ATTRIBUTE22 IN JTF_VARCHAR2_TABLE_300,
265 p_pricing_ATTRIBUTE23 IN JTF_VARCHAR2_TABLE_300,
266 p_pricing_ATTRIBUTE24 IN JTF_VARCHAR2_TABLE_300,
270 p_pricing_ATTRIBUTE28 IN JTF_VARCHAR2_TABLE_300,
267 p_pricing_ATTRIBUTE25 IN JTF_VARCHAR2_TABLE_300,
268 p_pricing_ATTRIBUTE26 IN JTF_VARCHAR2_TABLE_300,
269 p_pricing_ATTRIBUTE27 IN JTF_VARCHAR2_TABLE_300,
271 p_pricing_ATTRIBUTE29 IN JTF_VARCHAR2_TABLE_300,
272 p_pricing_ATTRIBUTE30 IN JTF_VARCHAR2_TABLE_300,
273 p_pricing_ATTRIBUTE31 IN JTF_VARCHAR2_TABLE_300,
274 p_pricing_ATTRIBUTE32 IN JTF_VARCHAR2_TABLE_300,
275 p_pricing_ATTRIBUTE33 IN JTF_VARCHAR2_TABLE_300,
276 p_pricing_ATTRIBUTE34 IN JTF_VARCHAR2_TABLE_300,
277 p_pricing_ATTRIBUTE35 IN JTF_VARCHAR2_TABLE_300,
278 p_pricing_ATTRIBUTE36 IN JTF_VARCHAR2_TABLE_300,
279 p_pricing_ATTRIBUTE37 IN JTF_VARCHAR2_TABLE_300,
280 p_pricing_ATTRIBUTE38 IN JTF_VARCHAR2_TABLE_300,
281 p_pricing_ATTRIBUTE39 IN JTF_VARCHAR2_TABLE_300,
282 p_pricing_ATTRIBUTE40 IN JTF_VARCHAR2_TABLE_300,
283 p_pricing_ATTRIBUTE41 IN JTF_VARCHAR2_TABLE_300,
284 p_pricing_ATTRIBUTE42 IN JTF_VARCHAR2_TABLE_300,
285 p_pricing_ATTRIBUTE43 IN JTF_VARCHAR2_TABLE_300,
286 p_pricing_ATTRIBUTE44 IN JTF_VARCHAR2_TABLE_300,
287 p_pricing_ATTRIBUTE45 IN JTF_VARCHAR2_TABLE_300,
288 p_pricing_ATTRIBUTE46 IN JTF_VARCHAR2_TABLE_300,
289 p_pricing_ATTRIBUTE47 IN JTF_VARCHAR2_TABLE_300,
290 p_pricing_ATTRIBUTE48 IN JTF_VARCHAR2_TABLE_300,
291 p_pricing_ATTRIBUTE49 IN JTF_VARCHAR2_TABLE_300,
292 p_pricing_ATTRIBUTE50 IN JTF_VARCHAR2_TABLE_300,
293 p_pricing_ATTRIBUTE51 IN JTF_VARCHAR2_TABLE_300,
294 p_pricing_ATTRIBUTE52 IN JTF_VARCHAR2_TABLE_300,
295 p_pricing_ATTRIBUTE53 IN JTF_VARCHAR2_TABLE_300,
296 p_pricing_ATTRIBUTE54 IN JTF_VARCHAR2_TABLE_300,
297 p_pricing_ATTRIBUTE55 IN JTF_VARCHAR2_TABLE_300,
298 p_pricing_ATTRIBUTE56 IN JTF_VARCHAR2_TABLE_300,
299 p_pricing_ATTRIBUTE57 IN JTF_VARCHAR2_TABLE_300,
300 p_pricing_ATTRIBUTE58 IN JTF_VARCHAR2_TABLE_300,
301 p_pricing_ATTRIBUTE59 IN JTF_VARCHAR2_TABLE_300,
302 p_pricing_ATTRIBUTE60 IN JTF_VARCHAR2_TABLE_300,
303 p_pricing_ATTRIBUTE61 IN JTF_VARCHAR2_TABLE_300,
304 p_pricing_ATTRIBUTE62 IN JTF_VARCHAR2_TABLE_300,
305 p_pricing_ATTRIBUTE63 IN JTF_VARCHAR2_TABLE_300,
306 p_pricing_ATTRIBUTE64 IN JTF_VARCHAR2_TABLE_300,
307 p_pricing_ATTRIBUTE65 IN JTF_VARCHAR2_TABLE_300,
308 p_pricing_ATTRIBUTE66 IN JTF_VARCHAR2_TABLE_300,
309 p_pricing_ATTRIBUTE67 IN JTF_VARCHAR2_TABLE_300,
310 p_pricing_ATTRIBUTE68 IN JTF_VARCHAR2_TABLE_300,
311 p_pricing_ATTRIBUTE69 IN JTF_VARCHAR2_TABLE_300,
312 p_pricing_ATTRIBUTE70 IN JTF_VARCHAR2_TABLE_300,
313 p_pricing_ATTRIBUTE71 IN JTF_VARCHAR2_TABLE_300,
314 p_pricing_ATTRIBUTE72 IN JTF_VARCHAR2_TABLE_300,
315 p_pricing_ATTRIBUTE73 IN JTF_VARCHAR2_TABLE_300,
316 p_pricing_ATTRIBUTE74 IN JTF_VARCHAR2_TABLE_300,
317 p_pricing_ATTRIBUTE75 IN JTF_VARCHAR2_TABLE_300,
318 p_pricing_ATTRIBUTE76 IN JTF_VARCHAR2_TABLE_300,
319 p_pricing_ATTRIBUTE77 IN JTF_VARCHAR2_TABLE_300,
320 p_pricing_ATTRIBUTE78 IN JTF_VARCHAR2_TABLE_300,
321 p_pricing_ATTRIBUTE79 IN JTF_VARCHAR2_TABLE_300,
322 p_pricing_ATTRIBUTE80 IN JTF_VARCHAR2_TABLE_300,
323 p_pricing_ATTRIBUTE81 IN JTF_VARCHAR2_TABLE_300,
324 p_pricing_ATTRIBUTE82 IN JTF_VARCHAR2_TABLE_300,
325 p_pricing_ATTRIBUTE83 IN JTF_VARCHAR2_TABLE_300,
326 p_pricing_ATTRIBUTE84 IN JTF_VARCHAR2_TABLE_300,
327 p_pricing_ATTRIBUTE85 IN JTF_VARCHAR2_TABLE_300,
328 p_pricing_ATTRIBUTE86 IN JTF_VARCHAR2_TABLE_300,
329 p_pricing_ATTRIBUTE87 IN JTF_VARCHAR2_TABLE_300,
330 p_pricing_ATTRIBUTE88 IN JTF_VARCHAR2_TABLE_300,
331 p_pricing_ATTRIBUTE89 IN JTF_VARCHAR2_TABLE_300,
332 p_pricing_ATTRIBUTE90 IN JTF_VARCHAR2_TABLE_300,
333 p_pricing_ATTRIBUTE91 IN JTF_VARCHAR2_TABLE_300,
334 p_pricing_ATTRIBUTE92 IN JTF_VARCHAR2_TABLE_300,
335 p_pricing_ATTRIBUTE93 IN JTF_VARCHAR2_TABLE_300,
336 p_pricing_ATTRIBUTE94 IN JTF_VARCHAR2_TABLE_300,
337 p_pricing_ATTRIBUTE95 IN JTF_VARCHAR2_TABLE_300,
338 p_pricing_ATTRIBUTE96 IN JTF_VARCHAR2_TABLE_300,
339 p_pricing_ATTRIBUTE97 IN JTF_VARCHAR2_TABLE_300,
340 p_pricing_ATTRIBUTE98 IN JTF_VARCHAR2_TABLE_300,
341 p_pricing_ATTRIBUTE99 IN JTF_VARCHAR2_TABLE_300,
342 p_pricing_ATTRIBUTE100 IN JTF_VARCHAR2_TABLE_300,
343 p_pricing_CONTEXT IN JTF_VARCHAR2_TABLE_300, -- end pricing attributes.
344 p_return_attribute_category IN JTF_VARCHAR2_TABLE_200, -- return attributes start.
345 p_return_attribute1 IN JTF_VARCHAR2_TABLE_200,
346 p_return_attribute2 IN JTF_VARCHAR2_TABLE_200,
347 p_return_attribute3 IN JTF_VARCHAR2_TABLE_200,
348 p_return_attribute4 IN JTF_VARCHAR2_TABLE_200,
349 p_return_attribute5 IN JTF_VARCHAR2_TABLE_200,
350 p_return_attribute6 IN JTF_VARCHAR2_TABLE_200,
351 p_return_attribute7 IN JTF_VARCHAR2_TABLE_200,
352 p_return_attribute8 IN JTF_VARCHAR2_TABLE_200,
353 p_return_attribute9 IN JTF_VARCHAR2_TABLE_200,
354 p_return_attribute10 IN JTF_VARCHAR2_TABLE_200,
355 p_return_attribute11 IN JTF_VARCHAR2_TABLE_200,
356 p_return_attribute12 IN JTF_VARCHAR2_TABLE_200,
360 p_return_attribute16 IN JTF_VARCHAR2_TABLE_200,
357 p_return_attribute13 IN JTF_VARCHAR2_TABLE_200,
358 p_return_attribute14 IN JTF_VARCHAR2_TABLE_200,
359 p_return_attribute15 IN JTF_VARCHAR2_TABLE_200,
361 p_return_attribute17 IN JTF_VARCHAR2_TABLE_200,
362 p_return_attribute18 IN JTF_VARCHAR2_TABLE_200,
363 p_return_attribute19 IN JTF_VARCHAR2_TABLE_200,
364 p_return_attribute20 IN JTF_VARCHAR2_TABLE_200,
365 p_return_attribute21 IN JTF_VARCHAR2_TABLE_200,
366 p_return_attribute22 IN JTF_VARCHAR2_TABLE_200,
367 p_return_attribute23 IN JTF_VARCHAR2_TABLE_200,
368 p_return_attribute24 IN JTF_VARCHAR2_TABLE_200,
369 p_return_attribute25 IN JTF_VARCHAR2_TABLE_200,
370 p_return_attribute26 IN JTF_VARCHAR2_TABLE_200,
371 p_return_attribute27 IN JTF_VARCHAR2_TABLE_200,
372 p_return_attribute28 IN JTF_VARCHAR2_TABLE_200,
373 p_return_attribute29 IN JTF_VARCHAR2_TABLE_200,
374 p_return_attribute30 IN JTF_VARCHAR2_TABLE_200, -- end return attributes.
375 p_cc_txn_id IN NUMBER,
376 p_currency_code IN VARCHAR2,
377 p_email IN VARCHAR2,
378 x_incident_number OUT NOCOPY VARCHAR2,
379 x_incident_id OUT NOCOPY NUMBER,
380 x_return_status OUT NOCOPY VARCHAR2,
381 x_msg_count OUT NOCOPY NUMBER,
382 x_msg_data OUT NOCOPY VARCHAR2,
383 p_calculate_price IN JTF_VARCHAR2_TABLE_100,
384 p_prices IN JTF_NUMBER_TABLE,
385 p_ret_reasons IN JTF_VARCHAR2_TABLE_100,
386 p_return_type_ids IN JTF_NUMBER_TABLE,
387 p_cc_trxn_id IN NUMBER DEFAULT NULL,
388 p_num_of_attachments IN JTF_NUMBER_TABLE,
389 p_attachment_title IN JTF_VARCHAR2_TABLE_100,
390 p_attachment_descr IN JTF_VARCHAR2_TABLE_300,
391 p_attachment_catId IN JTF_NUMBER_TABLE,
392 p_attachment_type IN JTF_VARCHAR2_TABLE_100,
393 p_attachment_url IN JTF_VARCHAR2_TABLE_4000,
394 p_attachment_text IN JTF_VARCHAR2_TABLE_4000,
395 p_attachment_file IN JTF_BLOB_TABLE,
396 p_attachment_file_name IN JTF_VARCHAR2_TABLE_2100,
397 p_attachment_file_type IN JTF_VARCHAR2_TABLE_100
398 );
399
400 FUNCTION get_credit_card(p_incident_id IN NUMBER) RETURN VARCHAR2;
401
402 PROCEDURE create_logistics_lines_cp
403 (errbuf OUT NOCOPY VARCHAR2,
404 retcode OUT NOCOPY VARCHAR2,
405 p_incident_id IN NUMBER,
406 p_return_reason_code IN VARCHAR2,
407 p_invoice_to_org_id IN NUMBER,
408 p_ship_to_org_id IN NUMBER
409 );
410
411 END CSD_RETURNS_UTIL;