eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TRANSFER_ORDER_PVT dependencies on INV_RESERVATION_GLOBAL

Line 160: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;

156: END get_primary_quantity;
157:
158: PROCEDURE delete_troldt(x_return_status OUT NOCOPY VARCHAR2, x_msg_data OUT NOCOPY VARCHAR2, x_msg_count OUT NOCOPY NUMBER, p_troldt_tbl IN inv_mo_line_detail_util.g_mmtt_tbl_type, p_move_order_type IN NUMBER) IS
159: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
160: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
161: l_mtl_reservation_count NUMBER;
162: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
163: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
164: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 162: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

158: PROCEDURE delete_troldt(x_return_status OUT NOCOPY VARCHAR2, x_msg_data OUT NOCOPY VARCHAR2, x_msg_count OUT NOCOPY NUMBER, p_troldt_tbl IN inv_mo_line_detail_util.g_mmtt_tbl_type, p_move_order_type IN NUMBER) IS
159: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
160: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
161: l_mtl_reservation_count NUMBER;
162: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
163: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
164: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
165: l_msg_count NUMBER;
166: l_msg_data VARCHAR2(2000);

Line 163: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

159: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
160: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
161: l_mtl_reservation_count NUMBER;
162: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
163: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
164: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
165: l_msg_count NUMBER;
166: l_msg_data VARCHAR2(2000);
167: l_error_code NUMBER;

Line 164: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

160: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
161: l_mtl_reservation_count NUMBER;
162: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
163: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
164: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
165: l_msg_count NUMBER;
166: l_msg_data VARCHAR2(2000);
167: l_error_code NUMBER;
168: l_return_status VARCHAR2(1);

Line 543: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;

539: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
540: l_trolin_rec inv_move_order_pub.trolin_rec_type;
541: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
542: l_quantity_cancel NUMBER;
543: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
544: l_mtl_reservation_count NUMBER;
545: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
546: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
547: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 545: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

541: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
542: l_quantity_cancel NUMBER;
543: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
544: l_mtl_reservation_count NUMBER;
545: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
546: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
547: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
548: l_msg_count NUMBER;
549: l_msg_data VARCHAR2(2000);

Line 546: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

542: l_quantity_cancel NUMBER;
543: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
544: l_mtl_reservation_count NUMBER;
545: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
546: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
547: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
548: l_msg_count NUMBER;
549: l_msg_data VARCHAR2(2000);
550: l_error_code NUMBER;

Line 547: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

543: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
544: l_mtl_reservation_count NUMBER;
545: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
546: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
547: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
548: l_msg_count NUMBER;
549: l_msg_data VARCHAR2(2000);
550: l_error_code NUMBER;
551: l_return_status VARCHAR2(1);

Line 1122: l_mtl_reservations inv_reservation_global.mtl_reservation_tbl_type;

1118: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1119: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1120: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
1121: l_quantity_cancel NUMBER;
1122: l_mtl_reservations inv_reservation_global.mtl_reservation_tbl_type;
1123: l_mtl_reservation_count NUMBER;
1124: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
1125: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1126: l_msg_count NUMBER;

Line 1124: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

1120: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
1121: l_quantity_cancel NUMBER;
1122: l_mtl_reservations inv_reservation_global.mtl_reservation_tbl_type;
1123: l_mtl_reservation_count NUMBER;
1124: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
1125: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1126: l_msg_count NUMBER;
1127: l_msg_data VARCHAR2(2000);
1128: l_move_order_type NUMBER;

Line 1125: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1121: l_quantity_cancel NUMBER;
1122: l_mtl_reservations inv_reservation_global.mtl_reservation_tbl_type;
1123: l_mtl_reservation_count NUMBER;
1124: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
1125: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1126: l_msg_count NUMBER;
1127: l_msg_data VARCHAR2(2000);
1128: l_move_order_type NUMBER;
1129: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;

Line 1592: x_mtl_reservation_tbl OUT INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE

1588: p_locator_id IN NUMBER := FND_API.G_MISS_NUM,
1589: p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
1590: p_lot_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
1591: p_serial_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
1592: x_mtl_reservation_tbl OUT INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE
1593: )
1594: IS
1595: l_rsv_temp_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
1596: l_mtl_reservation INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;

Line 1595: l_rsv_temp_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;

1591: p_serial_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
1592: x_mtl_reservation_tbl OUT INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE
1593: )
1594: IS
1595: l_rsv_temp_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
1596: l_mtl_reservation INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1597: l_mtl_reservation_count NUMBER;
1598: l_rsv_result_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1599: BEGIN

Line 1596: l_mtl_reservation INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;

1592: x_mtl_reservation_tbl OUT INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE
1593: )
1594: IS
1595: l_rsv_temp_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
1596: l_mtl_reservation INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1597: l_mtl_reservation_count NUMBER;
1598: l_rsv_result_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1599: BEGIN
1600: l_rsv_temp_rec.demand_source_header_id := p_source_header_id;

Line 1598: l_rsv_result_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;

1594: IS
1595: l_rsv_temp_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
1596: l_mtl_reservation INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1597: l_mtl_reservation_count NUMBER;
1598: l_rsv_result_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1599: BEGIN
1600: l_rsv_temp_rec.demand_source_header_id := p_source_header_id;
1601: l_rsv_temp_Rec.demand_source_line_id := p_source_line_id;
1602: l_rsv_temp_rec.demand_source_delivery := p_source_delivery_id;

Line 2123: l_original_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

2119: SELECT reservation_id, transaction_quantity, primary_quantity
2120: FROM mtl_material_transactions_temp
2121: WHERE move_order_line_id = p_line_id;
2122:
2123: l_original_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2124: l_new_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2125:
2126: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2127: l_mtl_reservation_tbl_count NUMBER;

Line 2124: l_new_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

2120: FROM mtl_material_transactions_temp
2121: WHERE move_order_line_id = p_line_id;
2122:
2123: l_original_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2124: l_new_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2125:
2126: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2127: l_mtl_reservation_tbl_count NUMBER;
2128: l_reservation_id NUMBER;

Line 2126: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

2122:
2123: l_original_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2124: l_new_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2125:
2126: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2127: l_mtl_reservation_tbl_count NUMBER;
2128: l_reservation_id NUMBER;
2129: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2130:

Line 2129: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

2125:
2126: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2127: l_mtl_reservation_tbl_count NUMBER;
2128: l_reservation_id NUMBER;
2129: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2130:
2131: l_msg_count NUMBER;
2132: l_msg_data VARCHAR2(2000);
2133: l_return_status VARCHAR2(1);

Line 2283: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

2279: l_return_status VARCHAR2(1);
2280: l_msg_count NUMBER;
2281: l_msg_data VARCHAR2(2000);
2282: l_unstaged_so_exists NUMBER := 0;
2283: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2284: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2285: l_ato_item number := 0 ;
2286: l_debug number;
2287: BEGIN

Line 2284: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

2280: l_msg_count NUMBER;
2281: l_msg_data VARCHAR2(2000);
2282: l_unstaged_so_exists NUMBER := 0;
2283: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2284: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2285: l_ato_item number := 0 ;
2286: l_debug number;
2287: BEGIN
2288: -- Use cache to get value for l_debug

Line 2458: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

2454: )
2455: IS
2456: l_api_name CONSTANT VARCHAR2(30) := 'Finalize_Pick_Confirm';
2457:
2458: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2459: l_query_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2460: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2461: l_mtl_reservation_rec2 inv_reservation_global.mtl_reservation_rec_type;
2462: l_mtl_reservation_rec3 inv_reservation_global.mtl_reservation_rec_type;

Line 2459: l_query_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

2455: IS
2456: l_api_name CONSTANT VARCHAR2(30) := 'Finalize_Pick_Confirm';
2457:
2458: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2459: l_query_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2460: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2461: l_mtl_reservation_rec2 inv_reservation_global.mtl_reservation_rec_type;
2462: l_mtl_reservation_rec3 inv_reservation_global.mtl_reservation_rec_type;
2463: l_mtl_reservation_tbl_count NUMBER;

Line 2460: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

2456: l_api_name CONSTANT VARCHAR2(30) := 'Finalize_Pick_Confirm';
2457:
2458: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2459: l_query_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2460: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2461: l_mtl_reservation_rec2 inv_reservation_global.mtl_reservation_rec_type;
2462: l_mtl_reservation_rec3 inv_reservation_global.mtl_reservation_rec_type;
2463: l_mtl_reservation_tbl_count NUMBER;
2464: l_return_status VARCHAR2(1);

Line 2461: l_mtl_reservation_rec2 inv_reservation_global.mtl_reservation_rec_type;

2457:
2458: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2459: l_query_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2460: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2461: l_mtl_reservation_rec2 inv_reservation_global.mtl_reservation_rec_type;
2462: l_mtl_reservation_rec3 inv_reservation_global.mtl_reservation_rec_type;
2463: l_mtl_reservation_tbl_count NUMBER;
2464: l_return_status VARCHAR2(1);
2465: l_msg_count NUMBER;

Line 2462: l_mtl_reservation_rec3 inv_reservation_global.mtl_reservation_rec_type;

2458: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2459: l_query_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2460: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2461: l_mtl_reservation_rec2 inv_reservation_global.mtl_reservation_rec_type;
2462: l_mtl_reservation_rec3 inv_reservation_global.mtl_reservation_rec_type;
2463: l_mtl_reservation_tbl_count NUMBER;
2464: l_return_status VARCHAR2(1);
2465: l_msg_count NUMBER;
2466: l_msg_data VARCHAR2(2000);

Line 2472: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

2468: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2469: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
2470: l_mmtt_count NUMBER;
2471: l_reservation_id NUMBER;
2472: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2473: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
2474: l_shipping_attr wsh_interface.changedattributetabtype;
2475: l_source_header_id NUMBER;
2476: l_source_line_id NUMBER;

Line 2473: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

2469: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
2470: l_mmtt_count NUMBER;
2471: l_reservation_id NUMBER;
2472: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2473: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
2474: l_shipping_attr wsh_interface.changedattributetabtype;
2475: l_source_header_id NUMBER;
2476: l_source_line_id NUMBER;
2477: l_delivery_detail_id NUMBER;

Line 3940: l_mtl_reservation_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;

3936: l_mtl_reservation_rec.reservation_uom_id := NULL;
3937: l_mtl_reservation_rec.autodetail_group_id := NULL;
3938: l_mtl_reservation_rec.external_source_code := NULL;
3939: l_mtl_reservation_rec.external_source_line_id := NULL;
3940: l_mtl_reservation_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
3941: l_mtl_reservation_rec.supply_source_header_id := NULL;
3942: l_mtl_reservation_rec.supply_source_line_id := NULL;
3943: l_mtl_reservation_rec.supply_source_name := NULL;
3944: l_mtl_reservation_rec.supply_source_line_detail := NULL;

Line 5737: l_mtl_reservation_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;

5733: l_mtl_reservation_rec.reservation_uom_id := NULL;
5734: l_mtl_reservation_rec.autodetail_group_id := NULL;
5735: l_mtl_reservation_rec.external_source_code := NULL;
5736: l_mtl_reservation_rec.external_source_line_id := NULL;
5737: l_mtl_reservation_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
5738: l_mtl_reservation_rec.supply_source_header_id := NULL;
5739: l_mtl_reservation_rec.supply_source_line_id := NULL;
5740: l_mtl_reservation_rec.supply_source_name := NULL;
5741: l_mtl_reservation_rec.supply_source_line_detail := NULL;