53: l_reservation_id NUMBER;
54: l_delete_reservations VARCHAR2(1);
55: l_task_dispatched VARCHAR2(1);
56: l_rsv_count NUMBER;
57: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
58: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
59: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
60: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
61: l_error_code NUMBER;
54: l_delete_reservations VARCHAR2(1);
55: l_task_dispatched VARCHAR2(1);
56: l_rsv_count NUMBER;
57: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
58: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
59: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
60: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
61: l_error_code NUMBER;
62: l_alloc_flag VARCHAR2(1); --ER3969328: CI project
55: l_task_dispatched VARCHAR2(1);
56: l_rsv_count NUMBER;
57: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
58: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
59: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
60: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
61: l_error_code NUMBER;
62: l_alloc_flag VARCHAR2(1); --ER3969328: CI project
63: l_flag BOOLEAN; --ER3969328: CI project
56: l_rsv_count NUMBER;
57: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
58: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
59: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
60: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
61: l_error_code NUMBER;
62: l_alloc_flag VARCHAR2(1); --ER3969328: CI project
63: l_flag BOOLEAN; --ER3969328: CI project
64: l_count NUMBER; --ER3969328: CI project
82: l_debug NUMBER;
83: l_dummy VARCHAR2(1);
84: l_api_return_status VARCHAR2(1);
85:
86: l_serial_tbl inv_reservation_global.serial_number_tbl_type;
87:
88: TYPE xdock_rsv_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
89: l_xdock_rsv_tbl xdock_rsv_tbl;
90:
1196: l_return_status VARCHAR2(1);
1197: l_deleted_quantity NUMBER;
1198: l_reservation_id NUMBER;
1199: l_primary_quantity NUMBER;
1200: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1201: l_rsv_rec2 inv_reservation_global.mtl_reservation_rec_type;
1202: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1203: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
1204: l_serial_tbl inv_reservation_global.serial_number_tbl_type;
1197: l_deleted_quantity NUMBER;
1198: l_reservation_id NUMBER;
1199: l_primary_quantity NUMBER;
1200: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1201: l_rsv_rec2 inv_reservation_global.mtl_reservation_rec_type;
1202: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1203: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
1204: l_serial_tbl inv_reservation_global.serial_number_tbl_type;
1205: l_rsv_count NUMBER;
1198: l_reservation_id NUMBER;
1199: l_primary_quantity NUMBER;
1200: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1201: l_rsv_rec2 inv_reservation_global.mtl_reservation_rec_type;
1202: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1203: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
1204: l_serial_tbl inv_reservation_global.serial_number_tbl_type;
1205: l_rsv_count NUMBER;
1206: l_rsv_index NUMBER;
1199: l_primary_quantity NUMBER;
1200: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1201: l_rsv_rec2 inv_reservation_global.mtl_reservation_rec_type;
1202: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1203: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
1204: l_serial_tbl inv_reservation_global.serial_number_tbl_type;
1205: l_rsv_count NUMBER;
1206: l_rsv_index NUMBER;
1207: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1200: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1201: l_rsv_rec2 inv_reservation_global.mtl_reservation_rec_type;
1202: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1203: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
1204: l_serial_tbl inv_reservation_global.serial_number_tbl_type;
1205: l_rsv_count NUMBER;
1206: l_rsv_index NUMBER;
1207: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1208: l_quantity_to_delete NUMBER;
1203: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
1204: l_serial_tbl inv_reservation_global.serial_number_tbl_type;
1205: l_rsv_count NUMBER;
1206: l_rsv_index NUMBER;
1207: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1208: l_quantity_to_delete NUMBER;
1209: l_sec_quantity_to_delete NUMBER; --INVCONV
1210: l_sec_deleted_quantity NUMBER; --INVCONV
1211: l_sec_quantity NUMBER; --INVCONV
2241: l_reservation_id NUMBER;
2242: l_transaction_temp_id NUMBER;
2243: l_task_qty NUMBER;
2244: l_primary_quantity NUMBER;
2245: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2246: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
2247: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
2248: l_rsv_count NUMBER;
2249: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
2242: l_transaction_temp_id NUMBER;
2243: l_task_qty NUMBER;
2244: l_primary_quantity NUMBER;
2245: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2246: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
2247: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
2248: l_rsv_count NUMBER;
2249: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
2250: l_quantity_to_delete NUMBER;
2243: l_task_qty NUMBER;
2244: l_primary_quantity NUMBER;
2245: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2246: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
2247: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
2248: l_rsv_count NUMBER;
2249: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
2250: l_quantity_to_delete NUMBER;
2251: l_sec_quantity_to_delete NUMBER; --INVCONV
2245: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2246: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
2247: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
2248: l_rsv_count NUMBER;
2249: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
2250: l_quantity_to_delete NUMBER;
2251: l_sec_quantity_to_delete NUMBER; --INVCONV
2252: l_sec_qty NUMBER; --INVCONV
2253: l_sec_deleted_quantity NUMBER; --INVCONV