[Home] [Help]
719: -- Items which were under lot control were not being processed correctly,
720: -- because this code was formerly comparing the item_revision_control to 2
721: /* l_is_lot_control := (p_request_context.item_lot_control_code = 2);
722: --
723: inv_quantity_tree_pvt.build_sql
724: (
725: x_return_status => l_return_status
726: ,p_mode => inv_quantity_tree_pvt.g_transaction_mode
727: ,p_is_lot_control => l_is_lot_control
722: --
723: inv_quantity_tree_pvt.build_sql
724: (
725: x_return_status => l_return_status
726: ,p_mode => inv_quantity_tree_pvt.g_transaction_mode
727: ,p_is_lot_control => l_is_lot_control
728: ,p_asset_sub_only => FALSE
729: ,p_include_suggestion => TRUE
730: ,p_lot_expiration_date => NULL
754: (p_request_line_rec.inventory_item_id);
755: g_stmt := REPLACE(g_stmt,':inventory_item_id', l_identifier);
756: --
757: --demand source line id is in sql only if pjm is enabled
758: -- (see inv_quantity_tree_pvt.build_cursor)
759: /*IF g_unit_eff_enabled IS NULL THEN
760: g_unit_eff_enabled := pjm_unit_eff.enabled;
761: END IF;
762: IF g_unit_eff_enabled = 'Y' THEN
1082: -- create tree
1083: -- Bug 1890424 - Pass sysdate to create_tree so
1084: -- expired lots don't appear as available
1085:
1086: inv_quantity_tree_pvt.create_tree
1087: (
1088: p_api_version_number => 1.0
1089: ,p_init_msg_lst => fnd_api.g_false
1090: ,x_return_status => l_return_status
1091: ,x_msg_count => x_msg_count
1092: ,x_msg_data => x_msg_data
1093: ,p_organization_id => p_request_line_rec.organization_id
1094: ,p_inventory_item_id => p_request_line_rec.inventory_item_id
1095: ,p_tree_mode => inv_quantity_tree_pvt.g_transaction_mode
1096: ,p_is_revision_control => l_rev_flag
1097: ,p_is_lot_control => l_lot_flag
1098: ,p_is_serial_control => FALSE
1099: ,p_asset_sub_only => FALSE
1104: ,p_demand_source_delivery => p_request_context.txn_line_detail
1105: ,p_demand_source_name => NULL
1106: ,p_lot_expiration_date => sysdate
1107: ,x_tree_id => l_tree_id
1108: ,p_exclusive => inv_quantity_tree_pvt.g_exclusive
1109: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
1110: );
1111: --
1112: IF l_return_status = fnd_api.g_ret_sts_error THEN
1105: ,p_demand_source_name => NULL
1106: ,p_lot_expiration_date => sysdate
1107: ,x_tree_id => l_tree_id
1108: ,p_exclusive => inv_quantity_tree_pvt.g_exclusive
1109: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
1110: );
1111: --
1112: IF l_return_status = fnd_api.g_ret_sts_error THEN
1113: RAISE fnd_api.g_exc_error ;
1127: BEGIN
1128: -- If tree already exists, free it. This may occur if procedure is
1129: -- called on multiple occassions within the same session.
1130: IF 0 > 0 THEN
1131: inv_quantity_tree_pvt.free_tree
1132: (
1133: p_api_version_number => 1.0
1134: ,p_init_msg_lst => fnd_api.g_false
1135: ,x_return_status => l_return_status
1408: -- Query Tree
1409: -- Bug 1349981 - no longer passing in cost group when querying
1410: -- the quantity tree. It works out okay, since only one cg per
1411: -- subinventory
1412: inv_quantity_tree_pvt.query_tree
1413: (
1414: p_api_version_number => 1.0
1415: ,p_init_msg_lst => NULL
1416: ,x_return_status => x_return_status
1493: END IF;
1494:
1495: END IF;
1496: IF l_qty_to_update > 0 THEN
1497: inv_quantity_tree_pvt.update_quantities
1498: (
1499: p_api_version_number => 1
1500: ,p_init_msg_lst => fnd_api.g_false
1501: ,x_return_status => x_return_status
1506: ,p_lot_number => l_lot_number
1507: ,p_subinventory_code => l_from_subinventory
1508: ,p_locator_id => l_from_locator_id
1509: ,p_primary_quantity => l_qty_to_update
1510: ,p_quantity_type => inv_quantity_tree_pvt.g_qs_txn
1511: ,x_qoh => l_qoh
1512: ,x_rqoh => l_rqoh
1513: ,x_qr => l_qr
1514: ,x_qs => l_qs
1815: -- free the quantity tree after inserting output records
1816: -- Bug 1384720 - performance improvements
1817: -- No need to free tree; save it for other queries
1818: /*
1819: inv_quantity_tree_pvt.free_tree
1820: (
1821: p_api_version_number => 1.0
1822: ,p_init_msg_lst => fnd_api.g_false
1823: ,x_return_status => l_return_status