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_PARAMETER_PVT dependencies on INV_CONVERT

Line 827: l_quantity := inv_convert.inv_um_convert(

823: -- convert capacity to base uom
824: -- round up
825: -- ( convert back to transaction uom )
826: IF p_transaction_uom <> p_base_uom THEN
827: l_quantity := inv_convert.inv_um_convert(
828: p_inventory_item_id
829: , NULL
830: , CEIL(inv_convert.inv_um_convert(p_inventory_item_id, NULL, p_quantity, p_transaction_uom, p_base_uom, NULL, NULL))
831: , p_base_uom

Line 830: , CEIL(inv_convert.inv_um_convert(p_inventory_item_id, NULL, p_quantity, p_transaction_uom, p_base_uom, NULL, NULL))

826: IF p_transaction_uom <> p_base_uom THEN
827: l_quantity := inv_convert.inv_um_convert(
828: p_inventory_item_id
829: , NULL
830: , CEIL(inv_convert.inv_um_convert(p_inventory_item_id, NULL, p_quantity, p_transaction_uom, p_base_uom, NULL, NULL))
831: , p_base_uom
832: , p_transaction_uom
833: , NULL
834: , NULL

Line 883: l_quantity := inv_convert.inv_um_convert(

879: -- convert capacity to base uom
880: -- cut decimals
881: -- ( convert back to transaction uom )
882: IF p_transaction_uom <> p_base_uom THEN
883: l_quantity := inv_convert.inv_um_convert(
884: p_inventory_item_id
885: , NULL
886: , FLOOR(inv_convert.inv_um_convert(p_inventory_item_id, NULL, p_quantity, p_transaction_uom, p_base_uom, NULL, NULL))
887: , p_base_uom

Line 886: , FLOOR(inv_convert.inv_um_convert(p_inventory_item_id, NULL, p_quantity, p_transaction_uom, p_base_uom, NULL, NULL))

882: IF p_transaction_uom <> p_base_uom THEN
883: l_quantity := inv_convert.inv_um_convert(
884: p_inventory_item_id
885: , NULL
886: , FLOOR(inv_convert.inv_um_convert(p_inventory_item_id, NULL, p_quantity, p_transaction_uom, p_base_uom, NULL, NULL))
887: , p_base_uom
888: , p_transaction_uom
889: , NULL
890: , NULL

Line 1247: l_capacity := inv_convert.inv_um_convert(

1243: END IF;
1244:
1245:
1246: IF p_unit_volume_uom_code <> l_volume_uom_code THEN
1247: l_capacity := inv_convert.inv_um_convert(
1248: p_inventory_item_id
1249: , NULL
1250: , l_max_cubic_area
1251: , l_volume_uom_code

Line 1267: l_capacity := inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_capacity, p_primary_uom, p_transaction_uom, NULL, NULL);

1263: l_capacity := l_max_cubic_area / p_unit_volume;
1264: END IF;
1265:
1266: IF p_primary_uom <> p_transaction_uom THEN
1267: l_capacity := inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_capacity, p_primary_uom, p_transaction_uom, NULL, NULL);
1268: END IF;
1269:
1270: -- l_capacity is negative if setup data is missing or wrong
1271: -- If setup data is missing or wrong, return infinite

Line 1386: l_capacity := inv_convert.inv_um_convert_new(

1382: RETURN 0;
1383: END IF;
1384:
1385: IF p_unit_weight_uom_code <> l_weight_uom_code THEN
1386: l_capacity := inv_convert.inv_um_convert_new(
1387: p_inventory_item_id
1388: , NULL
1389: , l_max_weight
1390: , l_weight_uom_code

Line 1406: l_capacity := inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_capacity, p_primary_uom, p_transaction_uom, NULL, NULL);

1402: l_capacity := l_max_weight / p_unit_weight;
1403: END IF;
1404:
1405: IF p_primary_uom <> p_transaction_uom THEN
1406: l_capacity := inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_capacity, p_primary_uom, p_transaction_uom, NULL, NULL);
1407: END IF;
1408:
1409: -- l_capacity is negative if setup data is missing or wrong
1410: -- If setup data is missing or wrong, return infinite

Line 1518: l_capacity := inv_convert.inv_um_convert_new(

1514: RETURN 0;
1515: END IF;
1516:
1517: IF p_unit_volume_uom_code <> l_volume_uom_code THEN
1518: l_capacity := inv_convert.inv_um_convert_new(
1519: p_inventory_item_id
1520: , NULL
1521: , l_capacity
1522: , l_volume_uom_code

Line 1537: inv_convert.inv_um_convert(

1533: END IF;
1534:
1535: IF p_primary_uom <> p_transaction_uom THEN
1536: l_capacity :=
1537: inv_convert.inv_um_convert(
1538: p_inventory_item_id,
1539: NULL,
1540: l_capacity,
1541: p_primary_uom,

Line 1664: l_capacity := inv_convert.inv_um_convert_new(

1660: RETURN 0;
1661: END IF;
1662:
1663: IF p_unit_weight_uom_code <> l_weight_uom_code THEN
1664: l_capacity := inv_convert.inv_um_convert_new(
1665: p_inventory_item_id
1666: , NULL
1667: , l_capacity
1668: , l_weight_uom_code

Line 1682: l_capacity := inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_capacity, p_primary_uom, p_transaction_uom, NULL, NULL);

1678: l_capacity := l_capacity / p_unit_weight;
1679: END IF;
1680:
1681: IF p_primary_uom <> p_transaction_uom THEN
1682: l_capacity := inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_capacity, p_primary_uom, p_transaction_uom, NULL, NULL);
1683: IF l_capacity <= 0 THEN
1684: RETURN 0;
1685: END IF;
1686: END IF;

Line 1801: l_capacity := inv_convert.inv_um_convert_new(

1797: RETURN 0;
1798: END IF;
1799:
1800: IF p_unit_volume_uom_code <> l_volume_uom_code THEN
1801: l_capacity := inv_convert.inv_um_convert_new(
1802: p_inventory_item_id
1803: , NULL
1804: , l_avail_cubic_area
1805: , l_volume_uom_code

Line 1819: l_capacity := inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_capacity, p_primary_uom, p_transaction_uom, NULL, NULL);

1815: l_capacity := l_avail_cubic_area / p_unit_volume;
1816: END IF;
1817:
1818: IF p_primary_uom <> p_transaction_uom THEN
1819: l_capacity := inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_capacity, p_primary_uom, p_transaction_uom, NULL, NULL);
1820: IF l_capacity < 0 THEN
1821: RETURN 1e125;
1822: END IF;
1823: END IF;

Line 1943: l_capacity := inv_convert.inv_um_convert_new(

1939: RETURN 0;
1940: END IF;
1941:
1942: IF p_unit_weight_uom_code <> l_weight_uom_code THEN
1943: l_capacity := inv_convert.inv_um_convert_new(
1944: p_inventory_item_id
1945: , NULL
1946: , l_avail_weight
1947: , l_weight_uom_code

Line 1963: l_capacity := inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_capacity, p_primary_uom, p_transaction_uom, NULL, NULL);

1959: l_capacity := l_avail_weight / p_unit_weight;
1960: END IF;
1961:
1962: IF p_primary_uom <> p_transaction_uom THEN
1963: l_capacity := inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_capacity, p_primary_uom, p_transaction_uom, NULL, NULL);
1964: -- l_capacity is negative if setup data is missing or wrong
1965: -- If setup data is missing or wrong, return infinite
1966: IF l_capacity < 0 THEN
1967: RETURN 1e125;

Line 2229: l_weight_capacity := inv_convert.inv_um_convert_new

2225:
2226: l_weight_capacity := 1e125;
2227: ELSE
2228: IF p_unit_weight_uom_code <> p_weight_uom_code THEN
2229: l_weight_capacity := inv_convert.inv_um_convert_new
2230: (p_inventory_item_id,
2231: NULL,
2232: p_max_weight,
2233: p_weight_uom_code,

Line 2258: l_volume_capacity := inv_convert.inv_um_convert_new

2254:
2255: l_volume_capacity := 1e125;
2256: ELSE
2257: IF p_unit_volume_uom_code <> p_volume_uom_code THEN
2258: l_volume_capacity := inv_convert.inv_um_convert_new
2259: (p_inventory_item_id,
2260: NULL,
2261: p_max_cubic_area,
2262: p_volume_uom_code,

Line 2287: l_capacity:= inv_convert.inv_um_convert

2283:
2284: --no need to convert or round if capacity is zero or infinite
2285: IF l_capacity NOT IN (1e125,0) THEN
2286: IF p_primary_uom <> p_transaction_uom THEN
2287: l_capacity:= inv_convert.inv_um_convert
2288: (p_inventory_item_id,
2289: NULL,
2290: l_capacity,
2291: p_primary_uom,

Line 2542: l_weight_capacity := inv_convert.inv_um_convert_new

2538: l_weight_capacity := 0;
2539: ELSE
2540: l_weight_capacity := NVL(p_current_weight, 0) + NVL(p_suggested_weight, 0);
2541: IF p_unit_weight_uom_code <> p_weight_uom_code THEN
2542: l_weight_capacity := inv_convert.inv_um_convert_new
2543: (p_inventory_item_id,
2544: NULL,
2545: l_weight_capacity,
2546: p_weight_uom_code,

Line 2571: l_volume_capacity := inv_convert.inv_um_convert_new

2567: l_volume_capacity := 0;
2568: ELSE
2569: l_volume_capacity := NVL(p_current_cubic_area,0) + NVL(p_suggested_cubic_area,0);
2570: IF p_unit_volume_uom_code <> p_volume_uom_code THEN
2571: l_volume_capacity := inv_convert.inv_um_convert_new
2572: (p_inventory_item_id,
2573: NULL,
2574: l_volume_capacity,
2575: p_volume_uom_code,

Line 2600: l_capacity:= inv_convert.inv_um_convert

2596:
2597: -- if capacity is zero, no need to convert or round
2598: IF l_capacity > 0 THEN
2599: IF p_primary_uom <> p_transaction_uom THEN
2600: l_capacity:= inv_convert.inv_um_convert
2601: (p_inventory_item_id,
2602: NULL,
2603: l_capacity,
2604: p_primary_uom,

Line 2867: l_weight_capacity := inv_convert.inv_um_convert_new

2863: l_weight_capacity := 1e125;
2864: ELSE
2865: l_weight_capacity := p_available_weight;
2866: IF p_unit_weight_uom_code <> p_weight_uom_code THEN
2867: l_weight_capacity := inv_convert.inv_um_convert_new
2868: (p_inventory_item_id,
2869: NULL,
2870: l_weight_capacity,
2871: p_weight_uom_code,

Line 2897: l_volume_capacity := inv_convert.inv_um_convert_new

2893: l_volume_capacity := 1e125;
2894: ELSE
2895: l_volume_capacity :=p_available_cubic_area;
2896: IF p_unit_volume_uom_code <> p_volume_uom_code THEN
2897: l_volume_capacity := inv_convert.inv_um_convert_new
2898: (p_inventory_item_id,
2899: NULL,
2900: l_volume_capacity,
2901: p_volume_uom_code,

Line 2926: l_capacity:= inv_convert.inv_um_convert

2922:
2923: -- no need to convert or round if capacity is zero or infinite
2924: IF l_capacity NOT IN (1e125,0) THEN
2925: IF p_primary_uom <> p_transaction_uom THEN
2926: l_capacity:= inv_convert.inv_um_convert
2927: (p_inventory_item_id,
2928: NULL,
2929: l_capacity,
2930: p_primary_uom,

Line 3359: l_weight_capacity := inv_convert.inv_um_convert_new

3355:
3356: l_weight_capacity := 1e125;
3357: ELSE
3358: IF p_unit_weight_uom_code <> p_weight_uom_code THEN
3359: l_weight_capacity := inv_convert.inv_um_convert_new
3360: (p_inventory_item_id,
3361: NULL,
3362: p_max_weight,
3363: p_weight_uom_code,

Line 3388: l_volume_capacity := inv_convert.inv_um_convert_new

3384:
3385: l_volume_capacity := 1e125;
3386: ELSE
3387: IF p_unit_volume_uom_code <> p_volume_uom_code THEN
3388: l_volume_capacity := inv_convert.inv_um_convert_new
3389: (p_inventory_item_id,
3390: NULL,
3391: p_max_cubic_area,
3392: p_volume_uom_code,

Line 3425: l_capacity:= inv_convert.inv_um_convert

3421:
3422: --no need to convert or round if capacity is 0 or infinite
3423: IF l_capacity NOT IN (1e125,0) THEN
3424: IF p_primary_uom <> p_transaction_uom THEN
3425: l_capacity:= inv_convert.inv_um_convert
3426: (p_inventory_item_id,
3427: NULL,
3428: l_capacity,
3429: p_primary_uom,

Line 3675: l_weight_capacity := inv_convert.inv_um_convert_new

3671: l_weight_capacity := 0;
3672: ELSE
3673: l_weight_capacity := NVL(p_current_weight, 0) + NVL(p_suggested_weight, 0);
3674: IF p_unit_weight_uom_code <> p_weight_uom_code THEN
3675: l_weight_capacity := inv_convert.inv_um_convert_new
3676: (p_inventory_item_id,
3677: NULL,
3678: l_weight_capacity,
3679: p_weight_uom_code,

Line 3704: l_volume_capacity := inv_convert.inv_um_convert_new

3700: l_volume_capacity := 0;
3701: ELSE
3702: l_volume_capacity := NVL(p_current_cubic_area,0) + NVL(p_suggested_cubic_area,0);
3703: IF p_unit_volume_uom_code <> p_volume_uom_code THEN
3704: l_volume_capacity := inv_convert.inv_um_convert_new
3705: (p_inventory_item_id,
3706: NULL,
3707: l_volume_capacity,
3708: p_volume_uom_code,

Line 3746: l_capacity:= inv_convert.inv_um_convert

3742:
3743: -- no need to round if capacity is 0
3744: IF l_capacity > 0 THEN
3745: IF p_primary_uom <> p_transaction_uom THEN
3746: l_capacity:= inv_convert.inv_um_convert
3747: (p_inventory_item_id,
3748: NULL,
3749: l_capacity,
3750: p_primary_uom,

Line 3993: l_weight_capacity := inv_convert.inv_um_convert_new -- INV_UM_CONVERT_NEW

3989: l_weight_capacity := 1e125;
3990: ELSE
3991: l_weight_capacity := p_available_weight;
3992: IF p_unit_weight_uom_code <> p_weight_uom_code THEN
3993: l_weight_capacity := inv_convert.inv_um_convert_new -- INV_UM_CONVERT_NEW
3994: (p_inventory_item_id,
3995: NULL,
3996: l_weight_capacity,
3997: p_weight_uom_code,

Line 4023: l_volume_capacity := inv_convert.inv_um_convert_new -- INV_UM_CONVERT_NEW

4019: l_volume_capacity := 1e125;
4020: ELSE
4021: l_volume_capacity := p_available_cubic_area;
4022: IF p_unit_volume_uom_code <> p_volume_uom_code THEN
4023: l_volume_capacity := inv_convert.inv_um_convert_new -- INV_UM_CONVERT_NEW
4024: (p_inventory_item_id,
4025: NULL,
4026: l_volume_capacity,
4027: p_volume_uom_code,

Line 4061: l_capacity:= inv_convert.inv_um_convert -- INV_UM_CONVERT_NEW

4057:
4058: --no need to round or convert if capacity is zero or infinite
4059: IF l_capacity NOT IN (1e125,0) THEN
4060: IF p_primary_uom <> p_transaction_uom THEN
4061: l_capacity:= inv_convert.inv_um_convert -- INV_UM_CONVERT_NEW
4062: (p_inventory_item_id,
4063: NULL,
4064: l_capacity,
4065: p_primary_uom,

Line 4823: inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_primary_quantity, p_primary_uom, p_transaction_uom, NULL, NULL);

4819: IF p_primary_uom IS NOT NULL
4820: AND p_transaction_uom IS NOT NULL
4821: AND p_primary_uom <> p_transaction_uom THEN
4822: l_transaction_quantity :=
4823: inv_convert.inv_um_convert(p_inventory_item_id, NULL, l_primary_quantity, p_primary_uom, p_transaction_uom, NULL, NULL);
4824: ELSE
4825: l_transaction_quantity := l_primary_quantity;
4826: END IF;
4827: -- log_mesg('GetItemonhand', 'l_transaction_quantity:', l_transaction_quantity );

Line 4984: l_total_quantity := inv_convert.inv_um_convert(

4980: END IF;
4981:
4982: IF l_primary_quantity > 0
4983: AND l_primary_uom_code <> p_transaction_uom THEN
4984: l_total_quantity := inv_convert.inv_um_convert(
4985: p_locator_inventory_item_id
4986: , NULL
4987: , l_primary_quantity
4988: , l_primary_uom_code

Line 5005: inv_convert.inv_um_convert(l_current_item_id, NULL, l_primary_quantity, l_primary_uom_code, p_transaction_uom, NULL, NULL);

5001: EXIT WHEN l_tot_onhand%NOTFOUND;
5002:
5003: IF l_primary_uom_code <> p_transaction_uom THEN
5004: l_current_quantity :=
5005: inv_convert.inv_um_convert(l_current_item_id, NULL, l_primary_quantity, l_primary_uom_code, p_transaction_uom, NULL, NULL);
5006: ELSE
5007: l_current_quantity := l_primary_quantity;
5008: END IF;
5009: