APPS.WMS_RULE_PVT dependencies on INV_CONVERT

Line 1145: -- Similar to inv_convert.inv_um_converstion, but no

1141: -- the base UOM of the class which contains the
1142: -- item's primary UOM. Support interclass and intraclass
1143: -- conversions.
1144: -- Notes : private procedure for internal use only;
1145: -- Similar to inv_convert.inv_um_converstion, but no
1146: -- Used to order locations returned from rule package
1147: FUNCTION getconversionrate(p_uom_code VARCHAR2, p_organization_id NUMBER, p_inventory_item_id NUMBER)
1148: RETURN NUMBER IS
1149: l_conversion_rate NUMBER;

Line 4341: l_sallocation_quantity := inv_convert.inv_um_convert(

4337: Close c_detailed_reservation;
4338: if l_detailed_rsv_exist = 1 Then
4339: l_sallocation_quantity := l_dummy_qty;
4340: else
4341: l_sallocation_quantity := inv_convert.inv_um_convert(
4342: Item_id => p_inventory_item_id
4343: , Lot_number => g_locs(p_record_id).lot_number
4344: , Organization_id => p_organization_id
4345: , Precision => null

Line 4593: l_possible_uom_qty := inv_convert.inv_um_convert(

4589: IF l_debug = 1 THEN
4590: log_statement(l_api_name, 'start_uom_conversion', 'Converting from primary uom to pick uom');
4591: END IF;
4592: --convert from primary uom to pick uom
4593: l_possible_uom_qty := inv_convert.inv_um_convert(
4594: p_inventory_item_id
4595: , NULL
4596: , l_allocation_quantity
4597: , p_primary_uom

Line 4615: l_allocation_quantity := inv_convert.inv_um_convert(

4611: IF l_debug = 1 THEN
4612: log_statement(l_api_name, 'to_primary_uom', 'Converting from pick uom to primary uom');
4613: END IF;
4614: --convert back to primary uom
4615: l_allocation_quantity := inv_convert.inv_um_convert(
4616: p_inventory_item_id
4617: , NULL
4618: , l_possible_uom_qty
4619: , g_locs(p_record_id).uom_code

Line 4731: inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_allocation_quantity, p_primary_uom, p_transaction_uom, NULL, NULL);

4727: IF p_transaction_uom = p_primary_uom THEN
4728: l_possible_trx_qty := l_allocation_quantity;
4729: ELSE
4730: l_possible_trx_qty :=
4731: inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_allocation_quantity, p_primary_uom, p_transaction_uom, NULL, NULL);
4732: END IF;
4733: l_sec_possible_trx_qty := l_sallocation_quantity;
4734:
4735: IF l_debug = 1 THEN

Line 5226: l_possible_uom_qty := inv_convert.inv_um_convert(

5222: IF l_debug = 1 THEN
5223: log_statement(l_api_name, 'start_uom_conversion', 'Converting from primary uom to pick uom');
5224: END IF;
5225: --convert from primary uom to pick uom
5226: l_possible_uom_qty := inv_convert.inv_um_convert(
5227: p_inventory_item_id
5228: , NULL
5229: , l_allocation_quantity
5230: , p_primary_uom

Line 5248: l_allocation_quantity := inv_convert.inv_um_convert(

5244: IF l_debug = 1 THEN
5245: log_statement(l_api_name, 'to_primary_uom', 'Converting from pick uom to primary uom');
5246: END IF;
5247: --convert back to primary uom
5248: l_allocation_quantity := inv_convert.inv_um_convert(
5249: p_inventory_item_id
5250: , NULL
5251: , l_possible_uom_qty
5252: , g_locs(p_record_id).uom_code

Line 5308: inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_allocation_quantity, p_primary_uom, p_transaction_uom, NULL, NULL);

5304: IF p_transaction_uom = p_primary_uom THEN
5305: l_possible_trx_qty := l_allocation_quantity;
5306: ELSE
5307: l_possible_trx_qty :=
5308: inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_allocation_quantity, p_primary_uom, p_transaction_uom, NULL, NULL);
5309: END IF;
5310: IF l_debug = 1 THEN
5311: log_statement(l_api_name, 'insert_wtt_rec', 'Inserting wtt recs. Trx Qty: ' || l_possible_trx_qty);
5312: END IF;

Line 6147: l_possible_uom_qty := inv_convert.inv_um_convert(

6143: IF l_debug = 1 THEN
6144: log_statement(l_api_name, 'start_uom_conversion', 'Converting from primary uom to pick uom');
6145: END IF;
6146: --convert from primary uom to pick uom
6147: l_possible_uom_qty := inv_convert.inv_um_convert(
6148: p_inventory_item_id
6149: , NULL
6150: , l_possible_quantity
6151: , p_primary_uom

Line 6168: l_possible_quantity := inv_convert.inv_um_convert(

6164: IF l_debug = 1 THEN
6165: log_statement(l_api_name, 'to_primary_uom', 'Converting from pick uom to primary uom');
6166: END IF;
6167: --convert back to primary uom
6168: l_possible_quantity := inv_convert.inv_um_convert(
6169: p_inventory_item_id
6170: , NULL
6171: , l_possible_uom_qty
6172: , g_locs(p_record_id).uom_code

Line 10331: l_possible_quantity := inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_possible_quantity, p_transaction_uom, p_primary_uom , NULL, NULL);

10327: IF p_transaction_uom <> p_primary_uom THEN
10328: IF l_debug = 1 THEN
10329: log_statement(l_api_name, 'poss_put_qty', 'In the condition for transaction_uom and primary uom different');
10330: END IF;
10331: l_possible_quantity := inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_possible_quantity, p_transaction_uom, p_primary_uom , NULL, NULL);
10332: END IF;
10333:
10334: IF l_debug = 1 THEN
10335: log_statement(l_api_name, 'poss_put_qty', 'Value of l_possible_quantity' || l_possible_quantity);

Line 10499: inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_possible_quantity, p_primary_uom, p_transaction_uom, NULL, NULL);

10495: IF p_transaction_uom = p_primary_uom THEN
10496: l_possible_trx_qty := l_possible_quantity;
10497: ELSE
10498: l_possible_trx_qty :=
10499: inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_possible_quantity, p_primary_uom, p_transaction_uom, NULL, NULL);
10500: END IF;
10501:
10502: IF l_debug = 1 THEN
10503: log_statement(l_api_name, 'insert_put_wtt_recs', 'Before insert values of l_possible_trx_qty'|| l_possible_trx_qty);

Line 11985: inv_convert.inv_um_convert(

11981: IF p_transaction_uom = p_primary_uom THEN
11982: l_possible_trx_qty := l_possible_quantity;
11983: ELSE
11984: l_possible_trx_qty :=
11985: inv_convert.inv_um_convert(
11986: p_inventory_item_id
11987: ,NULL
11988: ,l_possible_quantity
11989: ,p_primary_uom