DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PUB dependencies on INV_RESERVATION_GLOBAL

Line 3442: l_reservation_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;

3438: -- Order Line Detail which is being Pick
3439: -- Confirmed. If invoked at Ship Confirm,
3440: -- this will most likely be derived from the
3441: -- demand and supply source parameters.
3442: l_reservation_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
3443: -- Temporary reservation record for retrieving
3444: -- the reservation to transfer.
3445: l_reservation_count NUMBER; -- The number of reservations which match the
3446: -- demand/supply source parameters passed in.

Line 3447: l_cc_reservation_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;

3443: -- Temporary reservation record for retrieving
3444: -- the reservation to transfer.
3445: l_reservation_count NUMBER; -- The number of reservations which match the
3446: -- demand/supply source parameters passed in.
3447: l_cc_reservation_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
3448: -- Temporary reservation record for the amount
3449: -- to be transferred to Cycle Count.
3450: l_reservations_tbl INV_Reservation_GLOBAL.MTL_RESERVATION_TBL_TYPE;
3451: -- The table of reservations for given

Line 3450: l_reservations_tbl INV_Reservation_GLOBAL.MTL_RESERVATION_TBL_TYPE;

3446: -- demand/supply source parameters passed in.
3447: l_cc_reservation_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
3448: -- Temporary reservation record for the amount
3449: -- to be transferred to Cycle Count.
3450: l_reservations_tbl INV_Reservation_GLOBAL.MTL_RESERVATION_TBL_TYPE;
3451: -- The table of reservations for given
3452: -- supply and demand source
3453: l_dummy_sn INV_Reservation_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
3454: l_new_rsv_id NUMBER; -- The reservation ID that has been transferred

Line 3453: l_dummy_sn INV_Reservation_GLOBAL.SERIAL_NUMBER_TBL_TYPE;

3449: -- to be transferred to Cycle Count.
3450: l_reservations_tbl INV_Reservation_GLOBAL.MTL_RESERVATION_TBL_TYPE;
3451: -- The table of reservations for given
3452: -- supply and demand source
3453: l_dummy_sn INV_Reservation_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
3454: l_new_rsv_id NUMBER; -- The reservation ID that has been transferred
3455: -- to or updated
3456: l_mso_header_id NUMBER; -- The header ID for the record in
3457: -- MTL_SALES_ORDERS that corresponds to the OE

Line 3531: INV_Reservation_GLOBAL.g_source_type_oe;

3527:
3528: l_reservation_rec.inventory_item_id := p_inventory_item_id;
3529: l_reservation_rec.organization_id := p_organization_id;
3530: l_reservation_rec.demand_source_type_id :=
3531: INV_Reservation_GLOBAL.g_source_type_oe;
3532: l_reservation_rec.demand_source_header_id := p_demand_source_header_id;
3533: l_reservation_rec.demand_source_line_id := p_demand_source_line_id;
3534: -- R12 Crossdock changes
3535: l_reservation_rec.demand_source_line_detail := NULL;