DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on INV_CONVERT

Line 72: inv_convert.inv_um_conversion (

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

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

2516: --AND NVL(p_lpn_table(lpn_tbl_cnt).inventory_item_id ,G_NULL_NUM) = G_NULL_NUM
2517: ) THEN
2518: IF (l_new.tare_weight_uom_code IS NOT NULL ) THEN
2519: IF ( l_change_in_weight_uom <> l_new.tare_weight_uom_code ) THEN
2520: l_new.tare_weight := NVL( l_new.tare_weight,0) + inv_convert.inv_um_convert(
2521: l_new.inventory_item_id,
2522: 6,
2523: l_change_in_weight,
2524: l_change_in_weight_uom ,

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

5247: END IF;
5248:
5249: --INCONV kkillams
5250: IF p_sec_uom IS NOT NULL THEN
5251: l_sec_converted_quantity := inv_convert.inv_um_convert(p_content_item_id,
5252: g_precision,
5253: l_existing_record_cursor.secondary_quantity,
5254: l_existing_record_cursor.secondary_uom_code,
5255: p_sec_uom,

Line 5449: inv_convert.inv_um_convert(inventory_item_id

5445: , source_line_id = p_source_line_id
5446: , source_line_detail_id = p_source_line_detail_id
5447: , source_name = p_source_name
5448: , secondary_quantity = CASE WHEN p_sec_uom IS NOT NULL THEN NVL(l_one_time_item_rec.secondary_quantity, 1) +
5449: inv_convert.inv_um_convert(inventory_item_id
5450: ,g_precision
5451: ,NVL(l_quantity,1)
5452: ,p_uom
5453: ,p_sec_uom

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

5614: -- Bug 7665639 rework
5615:
5616: IF (p_sec_uom IS NOT NULL )
5617: AND (p_sec_uom <> l_temp_record.secondary_uom_code) THEN
5618: l_sec_converted_quantity := inv_convert.inv_um_convert(p_content_item_id,
5619: g_precision,
5620: l_temp_record.secondary_quantity,
5621: l_temp_record.secondary_uom_code,
5622: p_sec_uom,

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

7632: l_pack_quantity := l_quantity;
7633: l_sec_pack_quantity := l_sec_quantity; -- INVCONV kkillams
7634: ELSE
7635: l_pack_quantity := l_max_load_quantity;
7636: l_sec_pack_quantity := inv_convert.inv_um_convert(p_inventory_item_id,
7637: g_precision,
7638: l_max_load_quantity,
7639: p_uom,
7640: p_sec_uom,