DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on INV_RESERVATION_GLOBAL

Line 3297: l_rsv_tbl_tmp inv_reservation_global.mtl_reservation_tbl_type;

3293:
3294: l_repl_UOM_code VARCHAR2(3);
3295: l_Repl_Lot_Size NUMBER;
3296:
3297: l_rsv_tbl_tmp inv_reservation_global.mtl_reservation_tbl_type;
3298: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
3299: l_serial_number inv_reservation_global.serial_number_tbl_type;
3300: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
3301: l_quantity_reserved NUMBER;

Line 3298: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;

3294: l_repl_UOM_code VARCHAR2(3);
3295: l_Repl_Lot_Size NUMBER;
3296:
3297: l_rsv_tbl_tmp inv_reservation_global.mtl_reservation_tbl_type;
3298: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
3299: l_serial_number inv_reservation_global.serial_number_tbl_type;
3300: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
3301: l_quantity_reserved NUMBER;
3302: l_quantity_reserved2 NUMBER;

Line 3299: l_serial_number inv_reservation_global.serial_number_tbl_type;

3295: l_Repl_Lot_Size NUMBER;
3296:
3297: l_rsv_tbl_tmp inv_reservation_global.mtl_reservation_tbl_type;
3298: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
3299: l_serial_number inv_reservation_global.serial_number_tbl_type;
3300: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
3301: l_quantity_reserved NUMBER;
3302: l_quantity_reserved2 NUMBER;
3303: l_rsv_id NUMBER;

Line 3300: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

3296:
3297: l_rsv_tbl_tmp inv_reservation_global.mtl_reservation_tbl_type;
3298: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
3299: l_serial_number inv_reservation_global.serial_number_tbl_type;
3300: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
3301: l_quantity_reserved NUMBER;
3302: l_quantity_reserved2 NUMBER;
3303: l_rsv_id NUMBER;
3304: l_error_code NUMBER;

Line 3311: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

3307: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
3308: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
3309: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
3310:
3311: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
3312: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
3313: l_line_num NUMBER ;
3314:
3315: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 3312: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;

3308: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
3309: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
3310:
3311: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
3312: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
3313: l_line_num NUMBER ;
3314:
3315: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3316:

Line 4490: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;

4486: L_mo_quantity NUMBER;
4487: L_mo_uom_code VARCHAR2(3);
4488: L_mo_quantity_detailed NUMBER;
4489:
4490: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
4491: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
4492: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
4493: l_serial_number inv_reservation_global.serial_number_tbl_type;
4494: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

Line 4491: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

4487: L_mo_uom_code VARCHAR2(3);
4488: L_mo_quantity_detailed NUMBER;
4489:
4490: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
4491: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
4492: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
4493: l_serial_number inv_reservation_global.serial_number_tbl_type;
4494: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
4495: l_quantity_reserved NUMBER;

Line 4492: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;

4488: L_mo_quantity_detailed NUMBER;
4489:
4490: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
4491: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
4492: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
4493: l_serial_number inv_reservation_global.serial_number_tbl_type;
4494: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
4495: l_quantity_reserved NUMBER;
4496: l_quantity_reserved2 NUMBER;

Line 4493: l_serial_number inv_reservation_global.serial_number_tbl_type;

4489:
4490: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
4491: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
4492: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
4493: l_serial_number inv_reservation_global.serial_number_tbl_type;
4494: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
4495: l_quantity_reserved NUMBER;
4496: l_quantity_reserved2 NUMBER;
4497: l_rsv_id NUMBER;

Line 4494: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

4490: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
4491: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
4492: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
4493: l_serial_number inv_reservation_global.serial_number_tbl_type;
4494: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
4495: l_quantity_reserved NUMBER;
4496: l_quantity_reserved2 NUMBER;
4497: l_rsv_id NUMBER;
4498:

Line 5070: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

5066: l_att NUMBER;
5067: l_atr NUMBER;
5068: l_mtl_reservation_count NUMBER;
5069:
5070: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
5071: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
5072: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
5073:
5074: l_prev_org_id NUMBER;

Line 5071: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;

5067: l_atr NUMBER;
5068: l_mtl_reservation_count NUMBER;
5069:
5070: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
5071: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
5072: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
5073:
5074: l_prev_org_id NUMBER;
5075: l_prev_item_id NUMBER;

Line 5072: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;

5068: l_mtl_reservation_count NUMBER;
5069:
5070: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
5071: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
5072: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
5073:
5074: l_prev_org_id NUMBER;
5075: l_prev_item_id NUMBER;
5076: l_prev_sub_code VARCHAR2(10);

Line 5084: l_serial_number inv_reservation_global.serial_number_tbl_type;

5080: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
5081: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
5082: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
5083:
5084: l_serial_number inv_reservation_global.serial_number_tbl_type;
5085: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
5086: l_quantity_reserved NUMBER;
5087: l_quantity_reserved2 NUMBER;
5088: l_rsv_id NUMBER;

Line 5085: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

5081: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
5082: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
5083:
5084: l_serial_number inv_reservation_global.serial_number_tbl_type;
5085: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
5086: l_quantity_reserved NUMBER;
5087: l_quantity_reserved2 NUMBER;
5088: l_rsv_id NUMBER;
5089: l_error_code NUMBER;

Line 5812: l_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,

5808: l_supply_line_detail_id IN NUMBER,
5809: l_supply_expected_time IN DATE,
5810: l_demand_expected_time IN DATE,
5811: l_subinventory_code IN VARCHAR2 DEFAULT NULL,
5812: l_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
5813: l_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
5814: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
5815: l_quantity_reserved IN OUT NOCOPY NUMBER,
5816: l_quantity_reserved2 IN OUT NOCOPY NUMBER,

Line 5813: l_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,

5809: l_supply_expected_time IN DATE,
5810: l_demand_expected_time IN DATE,
5811: l_subinventory_code IN VARCHAR2 DEFAULT NULL,
5812: l_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
5813: l_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
5814: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
5815: l_quantity_reserved IN OUT NOCOPY NUMBER,
5816: l_quantity_reserved2 IN OUT NOCOPY NUMBER,
5817: l_rsv_id IN OUT NOCOPY NUMBER,

Line 5814: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,

5810: l_demand_expected_time IN DATE,
5811: l_subinventory_code IN VARCHAR2 DEFAULT NULL,
5812: l_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
5813: l_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
5814: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
5815: l_quantity_reserved IN OUT NOCOPY NUMBER,
5816: l_quantity_reserved2 IN OUT NOCOPY NUMBER,
5817: l_rsv_id IN OUT NOCOPY NUMBER,
5818: x_return_status IN OUT NOCOPY VARCHAR2,

Line 7100: l_rsv_tbl_tmp inv_reservation_global.mtl_reservation_tbl_type;

7096: L_PICK_UOM_CODE VARCHAR2(3);
7097: L_FIXED_LOT_MULTIPLE NUMBER;
7098: L_UNIT_CONV_QTY NUMBER;
7099:
7100: l_rsv_tbl_tmp inv_reservation_global.mtl_reservation_tbl_type;
7101: i NUMBER;
7102:
7103: L_CUR_SUB_HAS_CAPACITY BOOLEAN ;
7104: l_available_capacity NUMBER;