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 49: p_item_ids IN JTF_NUMBER_TABLE,

45: PROCEDURE get_warranty_status
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,

Line 55: p_instance_ids IN JTF_NUMBER_TABLE,

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,
55: p_instance_ids IN JTF_NUMBER_TABLE,
56: x_contract_ids OUT NOCOPY JTF_NUMBER_TABLE,
57: x_contract_line_ids OUT NOCOPY JTF_NUMBER_TABLE,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,

Line 56: x_contract_ids OUT NOCOPY JTF_NUMBER_TABLE,

52: p_account_id IN NUMBER,
53: p_bill_to_site_use_id IN NUMBER,
54: p_ship_to_site_use_id IN NUMBER,
55: p_instance_ids IN JTF_NUMBER_TABLE,
56: x_contract_ids OUT NOCOPY JTF_NUMBER_TABLE,
57: x_contract_line_ids OUT NOCOPY JTF_NUMBER_TABLE,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2

Line 57: x_contract_line_ids OUT NOCOPY JTF_NUMBER_TABLE,

53: p_bill_to_site_use_id IN NUMBER,
54: p_ship_to_site_use_id IN NUMBER,
55: p_instance_ids IN JTF_NUMBER_TABLE,
56: x_contract_ids OUT NOCOPY JTF_NUMBER_TABLE,
57: x_contract_line_ids OUT NOCOPY JTF_NUMBER_TABLE,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2
61: )

Line 92: x_contract_ids := JTF_NUMBER_TABLE();

88: x_return_status := G_RET_STS_SUCCESS;
89: -- processing logic.
90: -- loop through the each item to see if its under warranty or not.
91: -- any errors during calculation of warranty to be treated as item not under warranty.
92: x_contract_ids := JTF_NUMBER_TABLE();
93: x_contract_line_ids := JTF_NUMBER_TABLE();
94:
95: FOR i IN 1 ..p_item_ids.COUNT
96: LOOP

Line 93: x_contract_line_ids := JTF_NUMBER_TABLE();

89: -- processing logic.
90: -- loop through the each item to see if its under warranty or not.
91: -- any errors during calculation of warranty to be treated as item not under warranty.
92: x_contract_ids := JTF_NUMBER_TABLE();
93: x_contract_line_ids := JTF_NUMBER_TABLE();
94:
95: FOR i IN 1 ..p_item_ids.COUNT
96: LOOP
97: -- clean up contract table type.

Line 234: p_item_ids IN JTF_NUMBER_TABLE,

230: PROCEDURE get_estimated_price
231: (p_api_version IN NUMBER DEFAULT 1.0,
232: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
233: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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,

Line 235: p_contract_ids IN JTF_NUMBER_TABLE,

231: (p_api_version IN NUMBER DEFAULT 1.0,
232: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
233: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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,

Line 236: p_contract_line_ids IN JTF_NUMBER_TABLE,

232: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
233: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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,

Line 237: p_repair_type_ids IN JTF_NUMBER_TABLE,

233: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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,

Line 239: p_quantities 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,
243: p_pricing_ATTRIBUTE4 IN JTF_VARCHAR2_TABLE_300,

Line 341: x_prices OUT NOCOPY JTF_NUMBER_TABLE,

337: p_pricing_ATTRIBUTE98 IN JTF_VARCHAR2_TABLE_300,
338: p_pricing_ATTRIBUTE99 IN JTF_VARCHAR2_TABLE_300,
339: p_pricing_ATTRIBUTE100 IN JTF_VARCHAR2_TABLE_300,
340: p_pricing_CONTEXT IN JTF_VARCHAR2_TABLE_300,
341: x_prices OUT NOCOPY JTF_NUMBER_TABLE,
342: x_price_lists OUT NOCOPY JTF_NUMBER_TABLE,
343: x_return_status OUT NOCOPY VARCHAR2,
344: x_currency OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,

Line 342: x_price_lists OUT NOCOPY JTF_NUMBER_TABLE,

338: p_pricing_ATTRIBUTE99 IN JTF_VARCHAR2_TABLE_300,
339: p_pricing_ATTRIBUTE100 IN JTF_VARCHAR2_TABLE_300,
340: p_pricing_CONTEXT IN JTF_VARCHAR2_TABLE_300,
341: x_prices OUT NOCOPY JTF_NUMBER_TABLE,
342: x_price_lists OUT NOCOPY JTF_NUMBER_TABLE,
343: x_return_status OUT NOCOPY VARCHAR2,
344: x_currency OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,
346: x_msg_data OUT NOCOPY VARCHAR2,

Line 380: x_prices := JTF_NUMBER_TABLE();

376: Fnd_Msg_Pub.initialize;
377: END IF;
378:
379: x_return_status := G_RET_STS_SUCCESS;
380: x_prices := JTF_NUMBER_TABLE();
381: x_price_lists := JTF_NUMBER_TABLE();
382: -- processing logic.
383: -- For each item entered, if the calculate charges is yes, then we will calculate the
384: -- charge by making call to advanced pricing, and then a call to calculate the contract discount.

Line 381: x_price_lists := JTF_NUMBER_TABLE();

377: END IF;
378:
379: x_return_status := G_RET_STS_SUCCESS;
380: x_prices := JTF_NUMBER_TABLE();
381: x_price_lists := JTF_NUMBER_TABLE();
382: -- processing logic.
383: -- For each item entered, if the calculate charges is yes, then we will calculate the
384: -- charge by making call to advanced pricing, and then a call to calculate the contract discount.
385: -- the final charge will be price - discount.

Line 1153: p_item_ids IN JTF_NUMBER_TABLE,

1149: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1150: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1151: p_party_id IN NUMBER,
1152: p_account_id IN NUMBER,
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,

Line 1154: p_contract_ids IN JTF_NUMBER_TABLE,

1150: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1151: p_party_id IN NUMBER,
1152: p_account_id IN NUMBER,
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,

Line 1155: p_contract_line_ids IN JTF_NUMBER_TABLE,

1151: p_party_id IN NUMBER,
1152: p_account_id IN NUMBER,
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,

Line 1156: p_repair_type_ids IN JTF_NUMBER_TABLE,

1152: p_account_id IN NUMBER,
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,

Line 1158: p_quantities 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,
1162: p_bill_to_addr_use_id IN NUMBER,

Line 1159: p_price_lists 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,
1162: p_bill_to_addr_use_id IN NUMBER,
1163: p_ship_to_addr_use_id IN NUMBER,

Line 1164: p_instance_ids 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
1166: p_pricing_ATTRIBUTE2 IN JTF_VARCHAR2_TABLE_300,
1167: p_pricing_ATTRIBUTE3 IN JTF_VARCHAR2_TABLE_300,
1168: p_pricing_ATTRIBUTE4 IN JTF_VARCHAR2_TABLE_300,

Line 1306: p_prices IN JTF_NUMBER_TABLE,

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,
1310: p_num_of_attachments IN JTF_NUMBER_TABLE,

Line 1308: p_return_type_ids IN JTF_NUMBER_TABLE,

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,
1312: p_attachment_descr IN JTF_VARCHAR2_TABLE_300,

Line 1310: p_num_of_attachments IN JTF_NUMBER_TABLE,

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,
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,

Line 1313: p_attachment_catId 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,
1316: p_attachment_text IN JTF_VARCHAR2_TABLE_4000,
1317: p_attachment_file IN JTF_BLOB_TABLE,

Line 1327: l_serial_flag JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1323: lc_api_version CONSTANT NUMBER := 1.0;
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;

Line 1329: l_item_ids_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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;
1333: l_estimate_lines_rec csd_repair_estimate_pvt.repair_estimate_line_rec;

Line 1361: l_repair_line_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1357: x_request_id NUMBER;
1358: retcode VARCHAR2(100);
1359: errbuff VARCHAR2(2000);
1360: l_attach_index NUMBER := 1;
1361: l_repair_line_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1362: l_crt_inst_party_relation VARCHAR2(30) := fnd_profile.value('CSD_DEF_INST_PTY_RELTN');
1363: l_relationship VARCHAR2(30);
1364: x_relationship_created VARCHAR2(1);
1365:

Line 1587: (SELECT * FROM TABLE(CAST(p_item_ids AS JTF_NUMBER_TABLE))

1583: BULK COLLECT INTO
1584: l_serial_flag,l_ib_control_flag,l_item_ids_tbl
1585: FROM mtl_system_items_b
1586: WHERE inventory_item_id IN
1587: (SELECT * FROM TABLE(CAST(p_item_ids AS JTF_NUMBER_TABLE))
1588: )
1589: AND organization_id = fnd_profile.value('CSD_DEF_REP_INV_ORG');
1590:
1591: -- bug#14094846, subhat.

Line 2338: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2334: p_ship_to_org_id IN NUMBER
2335: )
2336: IS
2337: lc_api_name CONSTANT VARCHAR2(80) := 'CSD_RETURNS_UTIL.create_logistics_lines_cp';
2338: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2339: l_return_reason_code VARCHAR2(4000) := p_return_reason_code;
2340: l_ret_reason VARCHAR2(30);
2341: x_return_status VARCHAR2(1);
2342: x_msg_count NUMBER;