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.WMS_RULE_PVT dependencies on INV_CONVERT

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

1224: -- the base UOM of the class which contains the
1225: -- item's primary UOM. Support interclass and intraclass
1226: -- conversions.
1227: -- Notes : private procedure for internal use only;
1228: -- Similar to inv_convert.inv_um_converstion, but no
1229: -- Used to order locations returned from rule package
1230: FUNCTION getconversionrate(p_uom_code VARCHAR2, p_organization_id NUMBER, p_inventory_item_id NUMBER)
1231: RETURN NUMBER IS
1232: l_conversion_rate NUMBER;

Line 4784: l_pri_conv_qty := inv_convert.inv_um_convert(

4780: --
4781: IF NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S'
4782: THEN
4783: IF(l_allocate_lot_flag = 'N') THEN
4784: l_pri_conv_qty := inv_convert.inv_um_convert(
4785: item_id => p_inventory_item_id
4786: , precision => NULL
4787: , from_quantity => p_needed_sec_quantity
4788: , from_unit => p_secondary_uom

Line 4794: l_pri_conv_qty := inv_convert.inv_um_convert(

4790: , from_name => NULL
4791: , to_name => NULL
4792: );
4793: ELSE
4794: l_pri_conv_qty := inv_convert.inv_um_convert(
4795: item_id => p_inventory_item_id
4796: , lot_number => g_locs(p_record_id).lot_number
4797: , organization_id => p_organization_id
4798: , precision => NULL

Line 4827: l_needed_sec_quantity := inv_convert.inv_um_convert(

4823: END IF;
4824: END IF;
4825: ELSIF NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_needed_sec_quantity <= 0
4826: THEN
4827: l_needed_sec_quantity := inv_convert.inv_um_convert(
4828: item_id => p_inventory_item_id
4829: , lot_number => g_locs(p_record_id).lot_number
4830: , organization_id => p_organization_id
4831: , precision => NULL

Line 5021: l_lot_allocation_quantity := inv_convert.inv_um_convert(

5017: END IF;
5018:
5019: IF (l_lot_control_code = 2 AND l_lot_conv_factor_flag > 0 ) THEN --{
5020: -- use lot specific conversion
5021: l_lot_allocation_quantity := inv_convert.inv_um_convert(
5022: item_id => p_inventory_item_id
5023: , lot_number => g_locs(p_record_id).lot_number
5024: , organization_id => p_organization_id
5025: , precision => NULL

Line 5050: l_are_qties_valid := INV_CONVERT.within_deviation(

5046: IF (g_alloc_qty(l_rsv_id) <> l_lot_allocation_quantity) THEN
5047: --
5048: -- if user played with the deviation on top of the lot specific
5049: --
5050: l_are_qties_valid := INV_CONVERT.within_deviation(
5051: p_organization_id => p_organization_id
5052: , p_inventory_item_id => p_inventory_item_id
5053: , p_lot_number => g_locs(p_record_id).lot_number
5054: , p_precision => NULL

Line 5110: l_lot_allocation_quantity := inv_convert.inv_um_convert(

5106: --} l_rsv_id > 0
5107: ELSE
5108: --{ No reservation exists
5109: IF (l_lot_control_code = 2 AND l_lot_conv_factor_flag > 0 ) THEN
5110: l_lot_allocation_quantity := inv_convert.inv_um_convert(
5111: item_id => p_inventory_item_id
5112: , lot_number => g_locs(p_record_id).lot_number
5113: , organization_id => p_organization_id
5114: , precision => NULL

Line 5151: l_lot_sallocation_quantity := inv_convert.inv_um_convert(

5147: IF wms_engine_pvt.g_sec_qty_round_mode IS NOT NULL THEN --{
5148: IF l_allocation_quantity <= g_locs(p_record_id).quantity THEN --{
5149:
5150: IF (l_lot_control_code = 2 AND l_lot_conv_factor_flag > 0 ) THEN --{
5151: l_lot_sallocation_quantity := inv_convert.inv_um_convert(
5152: item_id => p_inventory_item_id
5153: , lot_number => g_locs(p_record_id).lot_number
5154: , organization_id => p_organization_id
5155: , precision => NULL

Line 5200: l_allocation_quantity := inv_convert.inv_um_convert(

5196: x_inserted_record := FALSE;
5197: RETURN;
5198: ELSE
5199: IF (l_lot_control_code = 2 AND l_lot_conv_factor_flag > 0 ) THEN
5200: l_allocation_quantity := inv_convert.inv_um_convert(
5201: item_id => p_inventory_item_id
5202: , lot_number => g_locs(p_record_id).lot_number
5203: , organization_id => p_organization_id
5204: , precision => NULL

Line 5316: l_lot_sallocation_quantity := inv_convert.inv_um_convert(

5312: END IF;
5313:
5314: IF (l_lot_control_code = 2 AND l_lot_conv_factor_flag > 0 ) THEN --{
5315: -- use lot specific conversion
5316: l_lot_sallocation_quantity := inv_convert.inv_um_convert(
5317: item_id => p_inventory_item_id
5318: , lot_number => g_locs(p_record_id).lot_number
5319: , organization_id => p_organization_id
5320: , precision => null

Line 5343: l_are_qties_valid := INV_CONVERT.within_deviation(

5339: IF (g_sec_alloc_qty(l_rsv_id) <> l_lot_sallocation_quantity) THEN
5340: --
5341: -- if user played with the deviation on top of the lot specific
5342: --
5343: l_are_qties_valid := INV_CONVERT.within_deviation(
5344: p_organization_id => p_organization_id
5345: , p_inventory_item_id => p_inventory_item_id
5346: , p_lot_number => g_locs(p_record_id).lot_number
5347: , p_precision => NULL

Line 5401: l_lot_sallocation_quantity := inv_convert.inv_um_convert(

5397: --} l_rsv_id > 0
5398: ELSE
5399: -- No reservation exists
5400: IF (l_lot_control_code = 2 AND l_lot_conv_factor_flag > 0 ) THEN
5401: l_lot_sallocation_quantity := inv_convert.inv_um_convert(
5402: item_id => p_inventory_item_id
5403: , lot_number => g_locs(p_record_id).lot_number
5404: , organization_id => p_organization_id
5405: , precision => NULL

Line 5506: l_pri_conv_qty := inv_convert.inv_um_convert(

5502: )
5503: THEN
5504: IF NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' THEN
5505: l_sallocation_quantity := g_locs(p_record_id).secondary_quantity;
5506: l_pri_conv_qty := inv_convert.inv_um_convert(
5507: item_id => p_inventory_item_id
5508: , lot_number => g_locs(p_record_id).lot_number
5509: , organization_id => p_organization_id
5510: , precision => NULL

Line 5801: l_sallocation_quantity := inv_convert.inv_um_convert(

5797: THEN --{
5798: IF NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P'
5799: AND wms_engine_pvt.g_sec_qty_round_mode IS NOT NULL
5800: THEN --{
5801: l_sallocation_quantity := inv_convert.inv_um_convert(
5802: item_id => p_inventory_item_id
5803: , lot_number => (CASE WHEN l_lot_conv_factor_flag = 0 THEN
5804: NULL
5805: ELSE g_locs(p_record_id).lot_number

Line 5835: l_allocation_quantity := inv_convert.inv_um_convert(

5831: x_sec_allocated_quantity := 0;
5832: x_inserted_record := FALSE;
5833: RETURN;
5834: ELSE
5835: l_allocation_quantity := inv_convert.inv_um_convert(
5836: item_id => p_inventory_item_id
5837: , lot_number => (CASE WHEN l_lot_conv_factor_flag = 0 THEN
5838: NULL
5839: ELSE g_locs(p_record_id).lot_number

Line 6043: l_possible_uom_qty := inv_convert.inv_um_convert(

6039: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND g_locs(p_record_id).uom_code <> p_secondary_uom) )
6040: THEN --{
6041: IF NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' THEN --{
6042: -- convert from secondary uom to pick uom
6043: l_possible_uom_qty := inv_convert.inv_um_convert(
6044: item_id => p_inventory_item_id
6045: , lot_number => (CASE WHEN l_lot_conv_factor_flag = 0 THEN
6046: NULL
6047: ELSE g_locs(p_record_id).lot_number

Line 6101: l_possible_uom_qty := inv_convert.inv_um_convert(

6097: -- 8809951 calling uom_convert from wms_cache
6098: IF (wms_engine_pvt.g_sec_qty_round_mode IS NULL
6099: OR (g_locs(p_record_id).uom_code <> p_secondary_uom))
6100: THEN --{
6101: l_possible_uom_qty := inv_convert.inv_um_convert(
6102: item_id => p_inventory_item_id
6103: , lot_number => (CASE WHEN l_lot_conv_factor_flag = 0 THEN
6104: NULL
6105: ELSE g_locs(p_record_id).lot_number

Line 6266: l_possible_trx_qty := inv_convert.inv_um_convert(

6262: ELSIF p_transaction_uom = p_secondary_uom THEN
6263: l_possible_trx_qty := l_sallocation_quantity;
6264: ELSE
6265: IF NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' THEN
6266: l_possible_trx_qty := inv_convert.inv_um_convert(
6267: item_id => p_inventory_item_id
6268: , lot_number => (CASE WHEN l_lot_conv_factor_flag = 0 THEN
6269: NULL
6270: ELSE g_locs(p_record_id).lot_number

Line 6281: l_possible_trx_qty := inv_convert.inv_um_convert(

6277: , from_name => NULL
6278: , to_name => NULL
6279: );
6280: ELSE
6281: l_possible_trx_qty := inv_convert.inv_um_convert(
6282: item_id => p_inventory_item_id
6283: , lot_number => (CASE WHEN l_lot_conv_factor_flag = 0 THEN
6284: NULL
6285: ELSE g_locs(p_record_id).lot_number

Line 6957: l_possible_uom_qty := inv_convert.inv_um_convert(

6953: IF l_debug = 1 THEN
6954: log_statement(l_api_name, 'start_uom_conversion', 'Converting from primary uom to pick uom');
6955: END IF;
6956: --convert from primary uom to pick uom
6957: l_possible_uom_qty := inv_convert.inv_um_convert(
6958: p_inventory_item_id
6959: , NULL
6960: , l_allocation_quantity
6961: , p_primary_uom

Line 6979: l_allocation_quantity := inv_convert.inv_um_convert(

6975: IF l_debug = 1 THEN
6976: log_statement(l_api_name, 'to_primary_uom', 'Converting from pick uom to primary uom');
6977: END IF;
6978: --convert back to primary uom
6979: l_allocation_quantity := inv_convert.inv_um_convert(
6980: p_inventory_item_id
6981: , NULL
6982: , l_possible_uom_qty
6983: , g_locs(p_record_id).uom_code

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

7035: IF p_transaction_uom = p_primary_uom THEN
7036: l_possible_trx_qty := l_allocation_quantity;
7037: ELSE
7038: l_possible_trx_qty :=
7039: inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_allocation_quantity, p_primary_uom, p_transaction_uom, NULL, NULL);
7040: END IF;
7041: IF l_debug = 1 THEN
7042: log_statement(l_api_name, 'insert_wtt_rec', 'Inserting wtt recs. Trx Qty: ' || l_possible_trx_qty);
7043: END IF;

Line 8017: l_possible_uom_qty := inv_convert.inv_um_convert(

8013: IF l_debug = 1 THEN
8014: log_statement(l_api_name, 'start_uom_conversion', 'Converting from secondary uom to pick uom');
8015: END IF;
8016: -- convert from primary uom to pick uom
8017: l_possible_uom_qty := inv_convert.inv_um_convert(
8018: p_inventory_item_id
8019: , NULL
8020: , l_sec_possible_quantity
8021: , p_secondary_uom

Line 8039: l_sec_possible_quantity := inv_convert.inv_um_convert(

8035: IF l_debug = 1 THEN
8036: log_statement(l_api_name, 'to_secondary_uom', 'Converting from pick uom to secondary uom');
8037: END IF;
8038: -- convert back to secondary uom
8039: l_sec_possible_quantity := inv_convert.inv_um_convert(
8040: p_inventory_item_id
8041: , NULL
8042: , l_possible_uom_qty
8043: , g_locs(p_record_id).uom_code

Line 8076: l_possible_uom_qty := inv_convert.inv_um_convert(

8072: IF l_debug = 1 THEN
8073: log_statement(l_api_name, 'start_uom_conversion', 'Converting from primary uom to pick uom');
8074: END IF;
8075: -- convert from primary uom to pick uom
8076: l_possible_uom_qty := inv_convert.inv_um_convert(
8077: p_inventory_item_id
8078: , NULL
8079: , l_possible_quantity
8080: , p_primary_uom

Line 8098: l_possible_quantity := inv_convert.inv_um_convert(

8094: IF l_debug = 1 THEN
8095: log_statement(l_api_name, 'to_primary_uom', 'Converting from pick uom to primary uom');
8096: END IF;
8097: -- convert back to primary uom
8098: l_possible_quantity := inv_convert.inv_um_convert(
8099: p_inventory_item_id
8100: , NULL
8101: , l_possible_uom_qty
8102: , g_locs(p_record_id).uom_code

Line 12814: l_possible_quantity := inv_convert.inv_um_convert(

12810: IF p_transaction_uom <> p_primary_uom THEN
12811: IF l_debug = 1 THEN
12812: log_statement(l_api_name, 'poss_put_qty', 'In the condition for transaction_uom and primary uom different');
12813: END IF;
12814: l_possible_quantity := inv_convert.inv_um_convert(
12815: p_inventory_item_id
12816: , NULL
12817: , l_possible_quantity
12818: , p_transaction_uom

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

13003: IF p_transaction_uom = p_primary_uom THEN
13004: l_possible_trx_qty := l_possible_quantity;
13005: ELSE
13006: l_possible_trx_qty :=
13007: inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_possible_quantity, p_primary_uom, p_transaction_uom, NULL, NULL);
13008: END IF;
13009:
13010: IF l_debug = 1 THEN
13011: log_statement(l_api_name, 'insert_put_wtt_recs', 'Before insert values of l_possible_trx_qty'|| l_possible_trx_qty);

Line 14586: inv_convert.inv_um_convert(

14582: IF p_transaction_uom = p_primary_uom THEN
14583: l_possible_trx_qty := l_possible_quantity;
14584: ELSE
14585: l_possible_trx_qty :=
14586: inv_convert.inv_um_convert(
14587: p_inventory_item_id
14588: ,NULL
14589: ,l_possible_quantity
14590: ,p_primary_uom