DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PUB dependencies on INV_RESERVATION_GLOBAL

Line 3610: l_reservation_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;

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.

Line 3615: l_cc_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.
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

Line 3618: l_reservations_tbl INV_Reservation_GLOBAL.MTL_RESERVATION_TBL_TYPE;

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

Line 3621: l_dummy_sn INV_Reservation_GLOBAL.SERIAL_NUMBER_TBL_TYPE;

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

Line 3699: INV_Reservation_GLOBAL.g_source_type_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;

Line 4057: l_reservation_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;

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.

Line 4062: l_cc_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.
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

Line 4065: l_reservations_tbl INV_Reservation_GLOBAL.MTL_RESERVATION_TBL_TYPE;

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

Line 4068: l_dummy_sn INV_Reservation_GLOBAL.SERIAL_NUMBER_TBL_TYPE;

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

Line 4146: INV_Reservation_GLOBAL.g_source_type_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