DBA Data[Home] [Help]

APPS.INV_RESERVATION_AVAIL_PVT dependencies on INV_CONVERT

Line 300: debug_print('calling inv_convert.inv_um_convert');

296:
297: -- need uom conversion if source uom is different from primary uom
298: IF (l_available_quantity > 0 AND l_source_uom_code is not NULL AND l_source_uom_code <> l_source_primary_uom_code) THEN
299: IF (l_debug = 1) THEN
300: debug_print('calling inv_convert.inv_um_convert');
301: debug_print('item_id = ' || p_item_id);
302: debug_print('org_id = ' || p_organization_id);
303: debug_print('lot_number = ' || p_lot_number);
304: debug_print('l_available_quantity = ' || l_available_quantity);

Line 309: l_primary_available_qty := inv_convert.inv_um_convert

305: debug_print('l_source_uom_code = ' || l_source_uom_code);
306: debug_print('l_source_primary_uom_code = ' || l_source_primary_uom_code);
307: END IF;
308:
309: l_primary_available_qty := inv_convert.inv_um_convert
310: (
311: item_id => p_item_id
312: , lot_number => p_lot_number
313: , organization_id => p_organization_id

Line 438: debug_print('calling inv_convert.inv_um_convert');

434:
435: -- need uom conversion if source uom is different from primary uom
436: IF (l_available_quantity > 0 AND l_source_uom_code is not NULL AND l_source_uom_code <> l_source_primary_uom_code) THEN
437: IF (l_debug = 1) THEN
438: debug_print('calling inv_convert.inv_um_convert');
439: debug_print('item_id = ' || p_item_id);
440: debug_print('org_id = ' || p_organization_id);
441: debug_print('lot_number = ' || p_lot_number);
442: debug_print('l_available_quantity = ' || l_available_quantity);

Line 447: l_primary_available_qty := inv_convert.inv_um_convert

443: debug_print('l_source_uom_code = ' || l_source_uom_code);
444: debug_print('l_source_primary_uom_code = ' || l_source_primary_uom_code);
445: END IF;
446:
447: l_primary_available_qty := inv_convert.inv_um_convert
448: (
449: item_id => p_item_id
450: , lot_number => p_lot_number
451: , organization_id => p_organization_id

Line 570: debug_print('calling inv_convert.inv_um_convert');

566:
567: -- need uom conversion if source uom is different from primary uom
568: IF (l_available_quantity > 0 AND l_source_uom_code is not NULL AND l_source_uom_code <> l_source_primary_uom_code) THEN
569: IF (l_debug = 1) THEN
570: debug_print('calling inv_convert.inv_um_convert');
571: debug_print('item_id = ' || p_item_id);
572: debug_print('org_id = ' || p_organization_id);
573: debug_print('lot_number = ' || p_lot_number);
574: debug_print('l_available_quantity = ' || l_available_quantity);

Line 579: l_primary_available_qty := inv_convert.inv_um_convert

575: debug_print('l_source_uom_code = ' || l_source_uom_code);
576: debug_print('l_source_primary_uom_code = ' || l_source_primary_uom_code);
577: END IF;
578:
579: l_primary_available_qty := inv_convert.inv_um_convert
580: (
581: item_id => p_item_id
582: , lot_number => p_lot_number
583: , organization_id => p_organization_id

Line 1032: debug_print('calling inv_convert.inv_um_convert');

1028:
1029: -- need uom conversion if source uom is different from primary uom
1030: IF (l_source_uom_code <> l_source_primary_uom_code) THEN
1031: IF (l_debug = 1) THEN
1032: debug_print('calling inv_convert.inv_um_convert');
1033: debug_print('l_available_quantity = ' || l_available_quantity);
1034: debug_print('l_source_uom_code = ' || l_source_uom_code);
1035: debug_print('l_source_primary_uom_code = ' || l_source_primary_uom_code);
1036: END IF;

Line 1038: l_primary_available_qty := inv_convert.inv_um_convert

1034: debug_print('l_source_uom_code = ' || l_source_uom_code);
1035: debug_print('l_source_primary_uom_code = ' || l_source_primary_uom_code);
1036: END IF;
1037:
1038: l_primary_available_qty := inv_convert.inv_um_convert
1039: (
1040: item_id => p_item_id
1041: , lot_number => null
1042: , organization_id => p_organization_id

Line 1218: l_lot_rsv_quantity_rsv_uom := inv_convert.inv_um_convert(

1214: IF (l_debug = 1) THEN
1215: debug_print('primary_uom_code and reservation_uom_code are different');
1216: END IF;
1217:
1218: l_lot_rsv_quantity_rsv_uom := inv_convert.inv_um_convert(
1219: Item_id => rsv_with_lots_rec.inventory_item_id
1220: , Lot_number => rsv_with_lots_rec.lot_number
1221: , Organization_id => rsv_with_lots_rec.organization_id
1222: , Precision => null

Line 1234: l_lot_primary_rsv_qty := inv_convert.inv_um_convert(

1230: debug_print('reservation qty with lots in reservation uom (honoring lot conversion) = '
1231: || l_lot_rsv_quantity_rsv_uom);
1232: END IF;
1233:
1234: l_lot_primary_rsv_qty := inv_convert.inv_um_convert(
1235: Item_id => rsv_with_lots_rec.inventory_item_id
1236: , Organization_id => rsv_with_lots_rec.organization_id
1237: , Precision => null
1238: , From_quantity => l_lot_rsv_quantity_rsv_uom

Line 1259: l_lot_rsv_qty_order_uom := inv_convert.inv_um_convert(

1255: IF (l_debug = 1) THEN
1256: debug_print('primary_uom_code and order_uom_code are different');
1257: END IF;
1258:
1259: l_lot_rsv_qty_order_uom := inv_convert.inv_um_convert(
1260: Item_id => rsv_with_lots_rec.inventory_item_id
1261: , Lot_number => rsv_with_lots_rec.lot_number
1262: , Organization_id => rsv_with_lots_rec.organization_id
1263: , Precision => null

Line 1275: l_lot_primary_rsv_qty := inv_convert.inv_um_convert(

1271: debug_print('reservation qty with lots in order uom (honoring lot conversion) = '
1272: || l_lot_rsv_qty_order_uom);
1273: END IF;
1274:
1275: l_lot_primary_rsv_qty := inv_convert.inv_um_convert(
1276: Item_id => rsv_with_lots_rec.inventory_item_id
1277: , Organization_id => rsv_with_lots_rec.organization_id
1278: , Precision => null
1279: , From_quantity => l_lot_rsv_qty_order_uom

Line 1389: l_lot_rsv_quantity_rsv_uom := inv_convert.inv_um_convert(

1385: IF (l_debug = 1) THEN
1386: debug_print('primary_uom_code and reservation_uom_code are different');
1387: END IF;
1388:
1389: l_lot_rsv_quantity_rsv_uom := inv_convert.inv_um_convert(
1390: Item_id => rsv_with_lots_rec.inventory_item_id
1391: , Lot_number => rsv_with_lots_rec.lot_number
1392: , Organization_id => rsv_with_lots_rec.organization_id
1393: , Precision => null

Line 1405: l_lot_primary_rsv_qty := inv_convert.inv_um_convert(

1401: debug_print('reservation qty with lots in reservation uom (honoring lot conversion) = '
1402: || l_lot_rsv_quantity_rsv_uom);
1403: END IF;
1404:
1405: l_lot_primary_rsv_qty := inv_convert.inv_um_convert(
1406: Item_id => rsv_with_lots_rec.inventory_item_id
1407: , Organization_id => rsv_with_lots_rec.organization_id
1408: , Precision => null
1409: , From_quantity => l_lot_rsv_quantity_rsv_uom

Line 1429: l_lot_rsv_qty_order_uom := inv_convert.inv_um_convert(

1425: IF (l_debug = 1) THEN
1426: debug_print('primary_uom_code and order_uom_code are different');
1427: END IF;
1428:
1429: l_lot_rsv_qty_order_uom := inv_convert.inv_um_convert(
1430: Item_id => rsv_with_lots_rec.inventory_item_id
1431: , Lot_number => rsv_with_lots_rec.lot_number
1432: , Organization_id => rsv_with_lots_rec.organization_id
1433: , Precision => null

Line 1445: l_lot_primary_rsv_qty := inv_convert.inv_um_convert(

1441: debug_print('reservation qty with lots in order uom (honoring lot conversion) = '
1442: || l_lot_rsv_qty_order_uom);
1443: END IF;
1444:
1445: l_lot_primary_rsv_qty := inv_convert.inv_um_convert(
1446: Item_id => rsv_with_lots_rec.inventory_item_id
1447: , Organization_id => rsv_with_lots_rec.organization_id
1448: , Precision => null
1449: , From_quantity => l_lot_rsv_qty_order_uom

Line 1577: l_primary_available_qty := inv_convert.inv_um_convert

1573: l_rsv_secondary_uom_code:= l_order_quantity_uom2;
1574: END IF;
1575:
1576: IF (l_order_quantity_uom_code <> l_rsv_primary_uom_code) THEN
1577: l_primary_available_qty := inv_convert.inv_um_convert
1578: (
1579: item_id => p_item_id
1580: , lot_number => null
1581: , organization_id => p_organization_id

Line 1637: l_primary_wdd_picked_qty := inv_convert.inv_um_convert

1633: END IF;
1634: END;
1635:
1636: IF (l_wdd_uom_code IS NOT NULL AND l_wdd_uom_code <> l_rsv_primary_uom_code) THEN
1637: l_primary_wdd_picked_qty := inv_convert.inv_um_convert
1638: (
1639: item_id => p_item_id
1640: , lot_number => null
1641: , organization_id => p_organization_id