[Home] [Help]
1004: -- Bug 1890424 - pass in expiration date of sysdate. Expired lots
1005: -- shouldn't appear as available
1006: -- Added following secondary qty related section for Bug 7377744
1007:
1008: inv_quantity_tree_pub.query_quantities(
1009: p_api_version_number => 1.0
1010: , p_init_msg_lst => fnd_api.g_false
1011: , x_return_status => l_api_return_status
1012: , x_msg_count => x_msg_count
1012: , x_msg_count => x_msg_count
1013: , x_msg_data => x_msg_data
1014: , p_organization_id => p_mo_line_rec.organization_id
1015: , p_inventory_item_id => p_mo_line_rec.inventory_item_id
1016: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode
1017: , p_is_revision_control => l_is_revision_control
1018: , p_is_lot_control => l_is_lot_control
1019: , p_is_serial_control => l_is_serial_control
1020: , p_demand_source_type_id => p_demand_source_type
1171: print_debug('updating quantity tree','Inv_Pick_Release_PVT.Process_Reservations');
1172: END IF;
1173:
1174: -- Added following secondary qty related section for Bug 7377744
1175: inv_quantity_tree_pub.update_quantities(
1176: p_api_version_number => 1.0
1177: , p_init_msg_lst => fnd_api.g_false
1178: , x_return_status => l_api_return_status
1179: , x_msg_count => x_msg_count
1179: , x_msg_count => x_msg_count
1180: , x_msg_data => x_msg_data
1181: , p_organization_id => p_mo_line_rec.organization_id
1182: , p_inventory_item_id => p_mo_line_rec.inventory_item_id
1183: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode
1184: , p_is_revision_control => l_is_revision_control
1185: , p_is_lot_control => l_is_lot_control
1186: , p_is_serial_control => l_is_serial_control
1187: , p_demand_source_type_id => p_demand_source_type
1194: , p_subinventory_code => NULL
1195: , p_locator_id => NULL
1196: , p_primary_quantity => l_quantity_to_reserve
1197: , p_secondary_quantity => l_sec_quantity_to_reserve -- Bug 7377744
1198: , p_quantity_type => inv_quantity_tree_pub.g_qr_same_demand
1199: , x_qoh => l_qty_on_hand
1200: , x_rqoh => l_qty_res_on_hand
1201: , x_qr => l_qty_res
1202: , x_qs => l_qty_sug
3016: l_is_serial_control := FALSE;
3017: END IF;
3018:
3019: -- Added secondary qty related parameters section for Bug 7377744
3020: inv_quantity_tree_pub.update_quantities(
3021: p_api_version_number => 1.0
3022: , p_init_msg_lst => fnd_api.g_false
3023: , x_return_status => l_api_return_status
3024: , x_msg_count => x_msg_count
3024: , x_msg_count => x_msg_count
3025: , x_msg_data => x_msg_data
3026: , p_organization_id => p_mo_line_rec.organization_id
3027: , p_inventory_item_id => p_mo_line_rec.inventory_item_id
3028: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode
3029: , p_is_revision_control => l_is_revision_control
3030: , p_is_lot_control => l_is_lot_control
3031: , p_is_serial_control => l_is_serial_control
3032: , p_demand_source_type_id => l_demand_source_type
3039: , p_subinventory_code => NULL
3040: , p_locator_id => NULL
3041: , p_primary_quantity => -(l_rsv_qty_available)
3042: , p_secondary_quantity => -(l_rsv_qty2_available) -- Bug 7377744
3043: , p_quantity_type => inv_quantity_tree_pub.g_qr_same_demand
3044: , x_qoh => l_qty_on_hand
3045: , x_rqoh => l_qty_res_on_hand
3046: , x_qr => l_qty_res
3047: , x_qs => l_qty_sug
3407: --update quantity tree
3408: IF is_debug THEN
3409: print_debug('updating quantity tree', 'Inv_Pick_Release_PVT.Process_Line');
3410: END IF;
3411: inv_quantity_tree_pub.update_quantities(
3412: p_api_version_number => 1.0
3413: , p_init_msg_lst => fnd_api.g_false
3414: , x_return_status => l_api_return_status
3415: , x_msg_count => x_msg_count
3415: , x_msg_count => x_msg_count
3416: , x_msg_data => x_msg_data
3417: , p_organization_id => p_mo_line_rec.organization_id
3418: , p_inventory_item_id => p_mo_line_rec.inventory_item_id
3419: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode
3420: , p_is_revision_control => l_is_revision_control
3421: , p_is_lot_control => l_is_lot_control
3422: , p_is_serial_control => l_is_serial_control
3423: , p_demand_source_type_id => l_demand_source_type
3431: , p_locator_id => l_demand_rsvs_ordered(l_res_ordered_index).locator_id
3432: , p_primary_quantity => -(l_reservation_detailed_qty - l_prev_rsv_detailed_qty)
3433: , p_secondary_quantity => -(l_rsv_detailed_qty2 - l_prev_rsv_detailed_qty2) /* Bug 7377744 */
3434: , p_lpn_id => l_demand_rsvs_ordered(l_res_ordered_index).lpn_id /* Bug 7229711 */
3435: , p_quantity_type => inv_quantity_tree_pub.g_qr_same_demand
3436: , x_qoh => l_qty_on_hand
3437: , x_rqoh => l_qty_res_on_hand
3438: , x_qr => l_qty_res
3439: , x_qs => l_qty_sug