eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_RETURNS_UTIL dependencies on JTF_NUMBER_TABLE

Line 20: p_item_ids IN JTF_NUMBER_TABLE,

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,

Line 26: p_instance_ids IN JTF_NUMBER_TABLE,

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,

Line 27: x_contract_ids OUT NOCOPY JTF_NUMBER_TABLE,

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

Line 28: x_contract_line_ids OUT NOCOPY JTF_NUMBER_TABLE,

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: );

Line 56: p_item_ids IN JTF_NUMBER_TABLE,

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,

Line 57: p_contract_ids IN JTF_NUMBER_TABLE,

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,

Line 58: p_contract_line_ids IN JTF_NUMBER_TABLE,

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,

Line 59: p_repair_type_ids IN JTF_NUMBER_TABLE,

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,

Line 61: p_quantities 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,

Line 163: x_prices OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 164: x_price_lists OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 231: p_item_ids IN JTF_NUMBER_TABLE,

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,

Line 232: p_contract_ids IN JTF_NUMBER_TABLE,

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,

Line 233: p_contract_line_ids IN JTF_NUMBER_TABLE,

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,

Line 234: p_repair_type_ids IN JTF_NUMBER_TABLE,

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,

Line 236: p_quantities 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,

Line 237: p_price_lists 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,

Line 242: p_instance_ids 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,

Line 384: p_prices IN JTF_NUMBER_TABLE,

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,

Line 386: p_return_type_ids IN JTF_NUMBER_TABLE,

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,

Line 388: p_num_of_attachments IN JTF_NUMBER_TABLE,

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,

Line 391: p_attachment_catId 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,