3606: -- Order Line Detail which is being Pick
3607: -- Confirmed. If invoked at Ship Confirm,
3608: -- this will most likely be derived from the
3609: -- demand and supply source parameters.
3610: l_reservation_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
3611: -- Temporary reservation record for retrieving
3612: -- the reservation to transfer.
3613: l_reservation_count NUMBER; -- The number of reservations which match the
3614: -- demand/supply source parameters passed in.
3611: -- Temporary reservation record for retrieving
3612: -- the reservation to transfer.
3613: l_reservation_count NUMBER; -- The number of reservations which match the
3614: -- demand/supply source parameters passed in.
3615: l_cc_reservation_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
3616: -- Temporary reservation record for the amount
3617: -- to be transferred to Cycle Count.
3618: l_reservations_tbl INV_Reservation_GLOBAL.MTL_RESERVATION_TBL_TYPE;
3619: -- The table of reservations for given
3614: -- demand/supply source parameters passed in.
3615: l_cc_reservation_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
3616: -- Temporary reservation record for the amount
3617: -- to be transferred to Cycle Count.
3618: l_reservations_tbl INV_Reservation_GLOBAL.MTL_RESERVATION_TBL_TYPE;
3619: -- The table of reservations for given
3620: -- supply and demand source
3621: l_dummy_sn INV_Reservation_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
3622: l_new_rsv_id NUMBER; -- The reservation ID that has been transferred
3617: -- to be transferred to Cycle Count.
3618: l_reservations_tbl INV_Reservation_GLOBAL.MTL_RESERVATION_TBL_TYPE;
3619: -- The table of reservations for given
3620: -- supply and demand source
3621: l_dummy_sn INV_Reservation_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
3622: l_new_rsv_id NUMBER; -- The reservation ID that has been transferred
3623: -- to or updated
3624: l_mso_header_id NUMBER; -- The header ID for the record in
3625: -- MTL_SALES_ORDERS that corresponds to the OE
3695:
3696: l_reservation_rec.inventory_item_id := p_inventory_item_id;
3697: l_reservation_rec.organization_id := p_organization_id;
3698: l_reservation_rec.demand_source_type_id :=
3699: INV_Reservation_GLOBAL.g_source_type_oe;
3700: l_reservation_rec.demand_source_header_id := p_demand_source_header_id;
3701: l_reservation_rec.demand_source_line_id := p_demand_source_line_id;
3702: -- R12 Crossdock changes
3703: l_reservation_rec.demand_source_line_detail := NULL;
4053: -- Order Line Detail which is being Pick
4054: -- Confirmed. If invoked at Ship Confirm,
4055: -- this will most likely be derived from the
4056: -- demand and supply source parameters.
4057: l_reservation_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
4058: -- Temporary reservation record for retrieving
4059: -- the reservation to transfer.
4060: l_reservation_count NUMBER; -- The number of reservations which match the
4061: -- demand/supply source parameters passed in.
4058: -- Temporary reservation record for retrieving
4059: -- the reservation to transfer.
4060: l_reservation_count NUMBER; -- The number of reservations which match the
4061: -- demand/supply source parameters passed in.
4062: l_cc_reservation_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
4063: -- Temporary reservation record for the amount
4064: -- to be transferred to Cycle Count.
4065: l_reservations_tbl INV_Reservation_GLOBAL.MTL_RESERVATION_TBL_TYPE;
4066: -- The table of reservations for given
4061: -- demand/supply source parameters passed in.
4062: l_cc_reservation_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
4063: -- Temporary reservation record for the amount
4064: -- to be transferred to Cycle Count.
4065: l_reservations_tbl INV_Reservation_GLOBAL.MTL_RESERVATION_TBL_TYPE;
4066: -- The table of reservations for given
4067: -- supply and demand source
4068: l_dummy_sn INV_Reservation_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
4069: l_new_rsv_id NUMBER; -- The reservation ID that has been transferred
4064: -- to be transferred to Cycle Count.
4065: l_reservations_tbl INV_Reservation_GLOBAL.MTL_RESERVATION_TBL_TYPE;
4066: -- The table of reservations for given
4067: -- supply and demand source
4068: l_dummy_sn INV_Reservation_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
4069: l_new_rsv_id NUMBER; -- The reservation ID that has been transferred
4070: -- to or updated
4071: l_mso_header_id NUMBER; -- The header ID for the record in
4072: -- MTL_SALES_ORDERS that corresponds to the OE
4142:
4143: l_reservation_rec.inventory_item_id := p_inventory_item_id;
4144: l_reservation_rec.organization_id := p_organization_id;
4145: l_reservation_rec.demand_source_type_id :=
4146: INV_Reservation_GLOBAL.g_source_type_oe;
4147: l_reservation_rec.demand_source_header_id := p_demand_source_header_id;
4148: l_reservation_rec.demand_source_line_id := p_demand_source_line_id;
4149:
4150: IF p_subinventory_code <> fnd_api.g_miss_char THEN