DBA Data[Home] [Help]

APPS.CSD_RETURNS_UTIL dependencies on JTF_VARCHAR2_TABLE_100

Line 21: p_serial_nums IN JTF_VARCHAR2_TABLE_100,

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,

Line 60: p_uom_codes IN JTF_VARCHAR2_TABLE_100,

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,

Line 235: p_uom_codes IN JTF_VARCHAR2_TABLE_100,

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,

Line 238: p_external_refs IN JTF_VARCHAR2_TABLE_100,

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,

Line 239: p_serial_nums IN JTF_VARCHAR2_TABLE_100,

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

Line 383: p_calculate_price IN JTF_VARCHAR2_TABLE_100,

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,

Line 385: p_ret_reasons IN JTF_VARCHAR2_TABLE_100,

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,

Line 389: p_attachment_title IN JTF_VARCHAR2_TABLE_100,

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,

Line 392: p_attachment_type IN JTF_VARCHAR2_TABLE_100,

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,

Line 397: p_attachment_file_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: