DBA Data[Home] [Help]

APPS.CSD_RETURNS_UTIL dependencies on JTF_VARCHAR2_TABLE_100

Line 50: p_serial_nums IN JTF_VARCHAR2_TABLE_100,

46: (p_api_version IN NUMBER DEFAULT 1.0,
47: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
48: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
49: p_item_ids IN JTF_NUMBER_TABLE,
50: p_serial_nums IN JTF_VARCHAR2_TABLE_100,
51: p_customer_id IN NUMBER,
52: p_account_id IN NUMBER,
53: p_bill_to_site_use_id IN NUMBER,
54: p_ship_to_site_use_id IN NUMBER,

Line 238: p_uom_codes IN JTF_VARCHAR2_TABLE_100,

234: p_item_ids IN JTF_NUMBER_TABLE,
235: p_contract_ids IN JTF_NUMBER_TABLE,
236: p_contract_line_ids IN JTF_NUMBER_TABLE,
237: p_repair_type_ids IN JTF_NUMBER_TABLE,
238: p_uom_codes IN JTF_VARCHAR2_TABLE_100,
239: p_quantities IN JTF_NUMBER_TABLE,
240: p_pricing_ATTRIBUTE1 IN JTF_VARCHAR2_TABLE_300,
241: p_pricing_ATTRIBUTE2 IN JTF_VARCHAR2_TABLE_300,
242: p_pricing_ATTRIBUTE3 IN JTF_VARCHAR2_TABLE_300,

Line 1157: p_uom_codes IN JTF_VARCHAR2_TABLE_100,

1153: p_item_ids IN JTF_NUMBER_TABLE,
1154: p_contract_ids IN JTF_NUMBER_TABLE,
1155: p_contract_line_ids IN JTF_NUMBER_TABLE,
1156: p_repair_type_ids IN JTF_NUMBER_TABLE,
1157: p_uom_codes IN JTF_VARCHAR2_TABLE_100,
1158: p_quantities IN JTF_NUMBER_TABLE,
1159: p_price_lists IN JTF_NUMBER_TABLE,
1160: p_external_refs IN JTF_VARCHAR2_TABLE_100,
1161: p_serial_nums IN JTF_VARCHAR2_TABLE_100,

Line 1160: p_external_refs IN JTF_VARCHAR2_TABLE_100,

1156: p_repair_type_ids IN JTF_NUMBER_TABLE,
1157: p_uom_codes IN JTF_VARCHAR2_TABLE_100,
1158: p_quantities IN JTF_NUMBER_TABLE,
1159: p_price_lists IN JTF_NUMBER_TABLE,
1160: p_external_refs IN JTF_VARCHAR2_TABLE_100,
1161: p_serial_nums IN JTF_VARCHAR2_TABLE_100,
1162: p_bill_to_addr_use_id IN NUMBER,
1163: p_ship_to_addr_use_id IN NUMBER,
1164: p_instance_ids IN JTF_NUMBER_TABLE,

Line 1161: p_serial_nums IN JTF_VARCHAR2_TABLE_100,

1157: p_uom_codes IN JTF_VARCHAR2_TABLE_100,
1158: p_quantities IN JTF_NUMBER_TABLE,
1159: p_price_lists IN JTF_NUMBER_TABLE,
1160: p_external_refs IN JTF_VARCHAR2_TABLE_100,
1161: p_serial_nums IN JTF_VARCHAR2_TABLE_100,
1162: p_bill_to_addr_use_id IN NUMBER,
1163: p_ship_to_addr_use_id IN NUMBER,
1164: p_instance_ids IN JTF_NUMBER_TABLE,
1165: p_pricing_ATTRIBUTE1 IN JTF_VARCHAR2_TABLE_300, -- pricing attributes start

Line 1305: p_calculate_price IN JTF_VARCHAR2_TABLE_100,

1301: x_incident_id OUT NOCOPY NUMBER,
1302: x_return_status OUT NOCOPY VARCHAR2,
1303: x_msg_count OUT NOCOPY NUMBER,
1304: x_msg_data OUT NOCOPY VARCHAR2,
1305: p_calculate_price IN JTF_VARCHAR2_TABLE_100,
1306: p_prices IN JTF_NUMBER_TABLE,
1307: p_ret_reasons IN JTF_VARCHAR2_TABLE_100,
1308: p_return_type_ids IN JTF_NUMBER_TABLE,
1309: p_cc_trxn_id IN NUMBER DEFAULT NULL,

Line 1307: p_ret_reasons IN JTF_VARCHAR2_TABLE_100,

1303: x_msg_count OUT NOCOPY NUMBER,
1304: x_msg_data OUT NOCOPY VARCHAR2,
1305: p_calculate_price IN JTF_VARCHAR2_TABLE_100,
1306: p_prices IN JTF_NUMBER_TABLE,
1307: p_ret_reasons IN JTF_VARCHAR2_TABLE_100,
1308: p_return_type_ids IN JTF_NUMBER_TABLE,
1309: p_cc_trxn_id IN NUMBER DEFAULT NULL,
1310: p_num_of_attachments IN JTF_NUMBER_TABLE,
1311: p_attachment_title IN JTF_VARCHAR2_TABLE_100,

Line 1311: p_attachment_title IN JTF_VARCHAR2_TABLE_100,

1307: p_ret_reasons IN JTF_VARCHAR2_TABLE_100,
1308: p_return_type_ids IN JTF_NUMBER_TABLE,
1309: p_cc_trxn_id IN NUMBER DEFAULT NULL,
1310: p_num_of_attachments IN JTF_NUMBER_TABLE,
1311: p_attachment_title IN JTF_VARCHAR2_TABLE_100,
1312: p_attachment_descr IN JTF_VARCHAR2_TABLE_300,
1313: p_attachment_catId IN JTF_NUMBER_TABLE,
1314: p_attachment_type IN JTF_VARCHAR2_TABLE_100,
1315: p_attachment_url IN JTF_VARCHAR2_TABLE_4000,

Line 1314: p_attachment_type IN JTF_VARCHAR2_TABLE_100,

1310: p_num_of_attachments IN JTF_NUMBER_TABLE,
1311: p_attachment_title IN JTF_VARCHAR2_TABLE_100,
1312: p_attachment_descr IN JTF_VARCHAR2_TABLE_300,
1313: p_attachment_catId IN JTF_NUMBER_TABLE,
1314: p_attachment_type IN JTF_VARCHAR2_TABLE_100,
1315: p_attachment_url IN JTF_VARCHAR2_TABLE_4000,
1316: p_attachment_text IN JTF_VARCHAR2_TABLE_4000,
1317: p_attachment_file IN JTF_BLOB_TABLE,
1318: p_attachment_file_name IN JTF_VARCHAR2_TABLE_2100,

Line 1319: p_attachment_file_type IN JTF_VARCHAR2_TABLE_100

1315: p_attachment_url IN JTF_VARCHAR2_TABLE_4000,
1316: p_attachment_text IN JTF_VARCHAR2_TABLE_4000,
1317: p_attachment_file IN JTF_BLOB_TABLE,
1318: p_attachment_file_name IN JTF_VARCHAR2_TABLE_2100,
1319: p_attachment_file_type IN JTF_VARCHAR2_TABLE_100
1320: )
1321: IS
1322: lc_api_name CONSTANT VARCHAR2(80) := 'CSD_RETURNS_UTIL.process_returns';
1323: lc_api_version CONSTANT NUMBER := 1.0;

Line 1328: l_ib_control_flag JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1324: l_service_request_rec csd_process_pvt.service_request_rec := csd_process_util.sr_rec;
1325: l_party_type VARCHAR2(30);
1326: l_sr_notes_tbl cs_servicerequest_pub.notes_table;
1327: l_serial_flag JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1328: l_ib_control_flag JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1329: l_item_ids_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1330: l_param_value VARCHAR2(500);
1331: l_instance_rec csd_mass_rcv_pvt.instance_rec_type;
1332: l_repln_rec csd_repairs_pub.repln_rec_type;