DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on INV_CONVERT

Line 69: inv_convert.inv_um_conversion (

65: RETURN p_fm_quantity * g_item_uom_conversion_tb(l_inventory_item_id)(p_fm_uom)(p_to_uom);
66: ELSE
67: -- conversion rate is not cached
68: g_progress := 'Call convert API and store the value';
69: inv_convert.inv_um_conversion (
70: from_unit => p_fm_uom
71: , to_unit => p_to_uom
72: , item_id => l_inventory_item_id
73: , uom_rate => l_conversion_rate );

Line 2324: l_new.tare_weight := NVL( l_new.tare_weight,0) + inv_convert.inv_um_convert(

2320: --AND NVL(p_lpn_table(lpn_tbl_cnt).inventory_item_id ,G_NULL_NUM) = G_NULL_NUM
2321: ) THEN
2322: IF (l_new.tare_weight_uom_code IS NOT NULL ) THEN
2323: IF ( l_change_in_weight_uom <> l_new.tare_weight_uom_code ) THEN
2324: l_new.tare_weight := NVL( l_new.tare_weight,0) + inv_convert.inv_um_convert(
2325: l_new.inventory_item_id,
2326: 6,
2327: l_change_in_weight,
2328: l_change_in_weight_uom ,

Line 4783: l_sec_converted_quantity := inv_convert.inv_um_convert(p_content_item_id,

4779: END IF;
4780:
4781: --INCONV kkillams
4782: IF p_sec_uom IS NOT NULL THEN
4783: l_sec_converted_quantity := inv_convert.inv_um_convert(p_content_item_id,
4784: g_precision,
4785: l_existing_record_cursor.secondary_quantity,
4786: l_existing_record_cursor.secondary_uom_code,
4787: p_sec_uom,

Line 4976: inv_convert.inv_um_convert(inventory_item_id

4972: , source_line_id = p_source_line_id
4973: , source_line_detail_id = p_source_line_detail_id
4974: , source_name = p_source_name
4975: , secondary_quantity = CASE WHEN p_sec_uom IS NOT NULL THEN NVL(l_one_time_item_rec.secondary_quantity, 1) +
4976: inv_convert.inv_um_convert(inventory_item_id
4977: ,g_precision
4978: ,NVL(l_quantity,1)
4979: ,p_uom
4980: ,p_sec_uom

Line 5139: l_sec_converted_quantity := inv_convert.inv_um_convert(p_content_item_id,

5135: --INCONV kkillams
5136: IF (p_sec_uom IS NOT NULL ) AND
5137: (p_sec_uom <> l_temp_record.secondary_uom_code)
5138: THEN
5139: l_sec_converted_quantity := inv_convert.inv_um_convert(p_content_item_id,
5140: g_precision,
5141: l_temp_record.secondary_quantity,
5142: l_temp_record.secondary_uom_code,
5143: p_sec_uom,

Line 5176: THEN (l_sec_converted_quantity - inv_convert.inv_um_convert(p_content_item_id,

5172: , request_id = l_request_id
5173: , quantity = quantity - l_converted_quantity
5174: , primary_quantity = primary_quantity - l_item_quantity
5175: , secondary_quantity = CASE WHEN p_sec_uom IS NOT NULL
5176: THEN (l_sec_converted_quantity - inv_convert.inv_um_convert(p_content_item_id,
5177: g_precision,
5178: l_item_quantity,
5179: inv_cache.item_rec.primary_uom_code,
5180: p_sec_uom,

Line 7076: l_sec_pack_quantity := inv_convert.inv_um_convert(p_inventory_item_id,

7072: l_pack_quantity := l_quantity;
7073: l_sec_pack_quantity := l_sec_quantity; -- INVCONV kkillams
7074: ELSE
7075: l_pack_quantity := l_max_load_quantity;
7076: l_sec_pack_quantity := inv_convert.inv_um_convert(p_inventory_item_id,
7077: g_precision,
7078: l_max_load_quantity,
7079: p_uom,
7080: p_sec_uom,