DBA Data[Home] [Help]

APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on INV_CONVERT

Line 3928: * inv_convert.inv_um_convert *

3924: * *
3925: * if( primary uom is different from the uom of the parent lot ) then *
3926: * -- call inv_um.convert *
3927: * calculate the primary qty of the parent lot by calling *
3928: * inv_convert.inv_um_convert *
3929: * end if; *
3930: * *
3931: * for i in 1..l_result_count LOOP *
3932: * if( result lot uom <> primary uom of parent lot ) then *

Line 4147: --bug 8526689 added lot number and org id to make the inv_convert call lot specific

4143: -- check if the total result qty do not exceed the parent lot quantity
4144: IF (l_start_primary_uom <> p_st_uom_tbl (1))
4145: THEN
4146: -- call inv_um.convert
4147: --bug 8526689 added lot number and org id to make the inv_convert call lot specific
4148: l_start_primary_qty :=
4149: inv_convert.inv_um_convert (item_id => l_inventory_item_id
4150: , lot_number => l_lot_number
4151: , organization_id => l_organization_id

Line 4149: inv_convert.inv_um_convert (item_id => l_inventory_item_id

4145: THEN
4146: -- call inv_um.convert
4147: --bug 8526689 added lot number and org id to make the inv_convert call lot specific
4148: l_start_primary_qty :=
4149: inv_convert.inv_um_convert (item_id => l_inventory_item_id
4150: , lot_number => l_lot_number
4151: , organization_id => l_organization_id
4152: , PRECISION => 5
4153: , from_quantity => l_start_qty

Line 4237: --bug 8526689 added lot number and org id to make the inv_convert call lot specific

4233: END IF;
4234:
4235: IF (p_rs_uom_tbl (i) <> l_start_primary_uom) THEN
4236: -- convert to start uom
4237: --bug 8526689 added lot number and org id to make the inv_convert call lot specific
4238: l_result_qty :=
4239: inv_convert.inv_um_convert
4240: (item_id => l_inventory_item_id
4241: , lot_number => p_st_lot_num_tbl(i)

Line 4239: inv_convert.inv_um_convert

4235: IF (p_rs_uom_tbl (i) <> l_start_primary_uom) THEN
4236: -- convert to start uom
4237: --bug 8526689 added lot number and org id to make the inv_convert call lot specific
4238: l_result_qty :=
4239: inv_convert.inv_um_convert
4240: (item_id => l_inventory_item_id
4241: , lot_number => p_st_lot_num_tbl(i)
4242: , organization_id => p_st_org_id_tbl(i)
4243: , PRECISION => 5

Line 4367: --bug 8526689 added lot number and org id to make the inv_convert call lot specific

4363: ELSIF (p_transaction_type_id = inv_globals.g_type_inv_lot_merge) THEN
4364: FOR i IN 1 .. l_start_count
4365: LOOP
4366: IF (l_start_primary_uom <> p_st_uom_tbl (i)) THEN
4367: --bug 8526689 added lot number and org id to make the inv_convert call lot specific
4368: l_start_primary_qty :=
4369: inv_convert.inv_um_convert(item_id => p_st_item_id_tbl(i)
4370: , lot_number => p_st_lot_num_tbl(i)
4371: , organization_id => p_st_org_id_tbl(i)

Line 4369: inv_convert.inv_um_convert(item_id => p_st_item_id_tbl(i)

4365: LOOP
4366: IF (l_start_primary_uom <> p_st_uom_tbl (i)) THEN
4367: --bug 8526689 added lot number and org id to make the inv_convert call lot specific
4368: l_start_primary_qty :=
4369: inv_convert.inv_um_convert(item_id => p_st_item_id_tbl(i)
4370: , lot_number => p_st_lot_num_tbl(i)
4371: , organization_id => p_st_org_id_tbl(i)
4372: , PRECISION => 5
4373: , from_quantity => p_st_quantity_tbl(i)

Line 4481: --bug 8526689 added lot number and org id to make the inv_convert call lot specific

4477: END LOOP;
4478:
4479: IF (p_rs_uom_tbl (1) <> l_start_primary_uom) THEN
4480: -- convert to start uom
4481: --bug 8526689 added lot number and org id to make the inv_convert call lot specific
4482: l_result_qty :=
4483: inv_convert.inv_um_convert (item_id => l_inventory_item_id
4484: , lot_number => l_lot_number
4485: , organization_id => l_organization_id

Line 4483: inv_convert.inv_um_convert (item_id => l_inventory_item_id

4479: IF (p_rs_uom_tbl (1) <> l_start_primary_uom) THEN
4480: -- convert to start uom
4481: --bug 8526689 added lot number and org id to make the inv_convert call lot specific
4482: l_result_qty :=
4483: inv_convert.inv_um_convert (item_id => l_inventory_item_id
4484: , lot_number => l_lot_number
4485: , organization_id => l_organization_id
4486: , PRECISION => 5
4487: , from_quantity => p_rs_quantity_tbl(1)