DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on INV_RESERVATION_GLOBAL

Line 3209: l_rsv_tbl_tmp inv_reservation_global.mtl_reservation_tbl_type;

3205:
3206: l_repl_UOM_code VARCHAR2(3);
3207: l_Repl_Lot_Size NUMBER;
3208:
3209: l_rsv_tbl_tmp inv_reservation_global.mtl_reservation_tbl_type;
3210: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
3211: l_serial_number inv_reservation_global.serial_number_tbl_type;
3212: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
3213: l_quantity_reserved NUMBER;

Line 3210: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;

3206: l_repl_UOM_code VARCHAR2(3);
3207: l_Repl_Lot_Size NUMBER;
3208:
3209: l_rsv_tbl_tmp inv_reservation_global.mtl_reservation_tbl_type;
3210: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
3211: l_serial_number inv_reservation_global.serial_number_tbl_type;
3212: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
3213: l_quantity_reserved NUMBER;
3214: l_quantity_reserved2 NUMBER;

Line 3211: l_serial_number inv_reservation_global.serial_number_tbl_type;

3207: l_Repl_Lot_Size NUMBER;
3208:
3209: l_rsv_tbl_tmp inv_reservation_global.mtl_reservation_tbl_type;
3210: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
3211: l_serial_number inv_reservation_global.serial_number_tbl_type;
3212: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
3213: l_quantity_reserved NUMBER;
3214: l_quantity_reserved2 NUMBER;
3215: l_rsv_id NUMBER;

Line 3212: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

3208:
3209: l_rsv_tbl_tmp inv_reservation_global.mtl_reservation_tbl_type;
3210: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
3211: l_serial_number inv_reservation_global.serial_number_tbl_type;
3212: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
3213: l_quantity_reserved NUMBER;
3214: l_quantity_reserved2 NUMBER;
3215: l_rsv_id NUMBER;
3216: l_error_code NUMBER;

Line 3223: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

3219: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
3220: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
3221: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
3222:
3223: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
3224: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
3225: l_line_num NUMBER ;
3226:
3227: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 3224: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;

3220: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
3221: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
3222:
3223: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
3224: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
3225: l_line_num NUMBER ;
3226:
3227: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3228:

Line 4349: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;

4345: L_mo_quantity NUMBER;
4346: L_mo_uom_code VARCHAR2(3);
4347: L_mo_quantity_detailed NUMBER;
4348:
4349: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
4350: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
4351: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
4352: l_serial_number inv_reservation_global.serial_number_tbl_type;
4353: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

Line 4350: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

4346: L_mo_uom_code VARCHAR2(3);
4347: L_mo_quantity_detailed NUMBER;
4348:
4349: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
4350: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
4351: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
4352: l_serial_number inv_reservation_global.serial_number_tbl_type;
4353: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
4354: l_quantity_reserved NUMBER;

Line 4351: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;

4347: L_mo_quantity_detailed NUMBER;
4348:
4349: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
4350: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
4351: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
4352: l_serial_number inv_reservation_global.serial_number_tbl_type;
4353: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
4354: l_quantity_reserved NUMBER;
4355: l_quantity_reserved2 NUMBER;

Line 4352: l_serial_number inv_reservation_global.serial_number_tbl_type;

4348:
4349: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
4350: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
4351: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
4352: l_serial_number inv_reservation_global.serial_number_tbl_type;
4353: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
4354: l_quantity_reserved NUMBER;
4355: l_quantity_reserved2 NUMBER;
4356: l_rsv_id NUMBER;

Line 4353: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

4349: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
4350: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
4351: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
4352: l_serial_number inv_reservation_global.serial_number_tbl_type;
4353: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
4354: l_quantity_reserved NUMBER;
4355: l_quantity_reserved2 NUMBER;
4356: l_rsv_id NUMBER;
4357:

Line 4904: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

4900: l_att NUMBER;
4901: l_atr NUMBER;
4902: l_mtl_reservation_count NUMBER;
4903:
4904: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
4905: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
4906: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
4907:
4908: l_prev_org_id NUMBER;

Line 4905: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;

4901: l_atr NUMBER;
4902: l_mtl_reservation_count NUMBER;
4903:
4904: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
4905: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
4906: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
4907:
4908: l_prev_org_id NUMBER;
4909: l_prev_item_id NUMBER;

Line 4906: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;

4902: l_mtl_reservation_count NUMBER;
4903:
4904: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
4905: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
4906: l_rsv_rec inv_reservation_global.mtl_reservation_tbl_type;
4907:
4908: l_prev_org_id NUMBER;
4909: l_prev_item_id NUMBER;
4910: l_prev_sub_code VARCHAR2(10);

Line 4918: l_serial_number inv_reservation_global.serial_number_tbl_type;

4914: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
4915: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
4916: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
4917:
4918: l_serial_number inv_reservation_global.serial_number_tbl_type;
4919: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
4920: l_quantity_reserved NUMBER;
4921: l_quantity_reserved2 NUMBER;
4922: l_rsv_id NUMBER;

Line 4919: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

4915: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
4916: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
4917:
4918: l_serial_number inv_reservation_global.serial_number_tbl_type;
4919: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
4920: l_quantity_reserved NUMBER;
4921: l_quantity_reserved2 NUMBER;
4922: l_rsv_id NUMBER;
4923: l_error_code NUMBER;

Line 5642: l_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,

5638: l_supply_line_detail_id IN NUMBER,
5639: l_supply_expected_time IN DATE,
5640: l_demand_expected_time IN DATE,
5641: l_subinventory_code IN VARCHAR2 DEFAULT NULL,
5642: l_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
5643: l_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
5644: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
5645: l_quantity_reserved IN OUT NOCOPY NUMBER,
5646: l_quantity_reserved2 IN OUT NOCOPY NUMBER,

Line 5643: l_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,

5639: l_supply_expected_time IN DATE,
5640: l_demand_expected_time IN DATE,
5641: l_subinventory_code IN VARCHAR2 DEFAULT NULL,
5642: l_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
5643: l_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
5644: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
5645: l_quantity_reserved IN OUT NOCOPY NUMBER,
5646: l_quantity_reserved2 IN OUT NOCOPY NUMBER,
5647: l_rsv_id IN OUT NOCOPY NUMBER,

Line 5644: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,

5640: l_demand_expected_time IN DATE,
5641: l_subinventory_code IN VARCHAR2 DEFAULT NULL,
5642: l_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
5643: l_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
5644: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
5645: l_quantity_reserved IN OUT NOCOPY NUMBER,
5646: l_quantity_reserved2 IN OUT NOCOPY NUMBER,
5647: l_rsv_id IN OUT NOCOPY NUMBER,
5648: x_return_status IN OUT NOCOPY VARCHAR2,

Line 6925: l_rsv_tbl_tmp inv_reservation_global.mtl_reservation_tbl_type;

6921: L_PICK_UOM_CODE VARCHAR2(3);
6922: L_FIXED_LOT_MULTIPLE NUMBER;
6923: L_UNIT_CONV_QTY NUMBER;
6924:
6925: l_rsv_tbl_tmp inv_reservation_global.mtl_reservation_tbl_type;
6926: i NUMBER;
6927:
6928: L_CUR_SUB_HAS_CAPACITY BOOLEAN ;
6929: l_available_capacity NUMBER;