DBA Data[Home] [Help]

APPS.INV_MO_CANCEL_PVT dependencies on INV_RESERVATION_GLOBAL

Line 57: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

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;

Line 58: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

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

Line 59: l_update_rec inv_reservation_global.mtl_reservation_rec_type;

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

Line 60: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

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

Line 86: l_serial_tbl inv_reservation_global.serial_number_tbl_type;

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:

Line 1198: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1194: l_return_status VARCHAR2(1);
1195: l_deleted_quantity NUMBER;
1196: l_reservation_id NUMBER;
1197: l_primary_quantity NUMBER;
1198: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1199: l_rsv_rec2 inv_reservation_global.mtl_reservation_rec_type;
1200: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1201: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
1202: l_serial_tbl inv_reservation_global.serial_number_tbl_type;

Line 1199: l_rsv_rec2 inv_reservation_global.mtl_reservation_rec_type;

1195: l_deleted_quantity NUMBER;
1196: l_reservation_id NUMBER;
1197: l_primary_quantity NUMBER;
1198: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1199: l_rsv_rec2 inv_reservation_global.mtl_reservation_rec_type;
1200: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1201: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
1202: l_serial_tbl inv_reservation_global.serial_number_tbl_type;
1203: l_rsv_count NUMBER;

Line 1200: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

1196: l_reservation_id NUMBER;
1197: l_primary_quantity NUMBER;
1198: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1199: l_rsv_rec2 inv_reservation_global.mtl_reservation_rec_type;
1200: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1201: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
1202: l_serial_tbl inv_reservation_global.serial_number_tbl_type;
1203: l_rsv_count NUMBER;
1204: l_rsv_index NUMBER;

Line 1201: l_update_rec inv_reservation_global.mtl_reservation_rec_type;

1197: l_primary_quantity NUMBER;
1198: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1199: l_rsv_rec2 inv_reservation_global.mtl_reservation_rec_type;
1200: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1201: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
1202: l_serial_tbl inv_reservation_global.serial_number_tbl_type;
1203: l_rsv_count NUMBER;
1204: l_rsv_index NUMBER;
1205: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 1202: l_serial_tbl inv_reservation_global.serial_number_tbl_type;

1198: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1199: l_rsv_rec2 inv_reservation_global.mtl_reservation_rec_type;
1200: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1201: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
1202: l_serial_tbl inv_reservation_global.serial_number_tbl_type;
1203: l_rsv_count NUMBER;
1204: l_rsv_index NUMBER;
1205: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1206: l_quantity_to_delete NUMBER;

Line 1205: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

1201: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
1202: l_serial_tbl inv_reservation_global.serial_number_tbl_type;
1203: l_rsv_count NUMBER;
1204: l_rsv_index NUMBER;
1205: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1206: l_quantity_to_delete NUMBER;
1207: l_sec_quantity_to_delete NUMBER; --INVCONV
1208: l_sec_deleted_quantity NUMBER; --INVCONV
1209: l_sec_quantity NUMBER; --INVCONV

Line 2260: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

2256: l_reservation_id NUMBER;
2257: l_transaction_temp_id NUMBER;
2258: l_task_qty NUMBER;
2259: l_primary_quantity NUMBER;
2260: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2261: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
2262: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
2263: l_rsv_count NUMBER;
2264: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 2261: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

2257: l_transaction_temp_id NUMBER;
2258: l_task_qty NUMBER;
2259: l_primary_quantity NUMBER;
2260: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2261: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
2262: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
2263: l_rsv_count NUMBER;
2264: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
2265: l_quantity_to_delete NUMBER;

Line 2262: l_update_rec inv_reservation_global.mtl_reservation_rec_type;

2258: l_task_qty NUMBER;
2259: l_primary_quantity NUMBER;
2260: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2261: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
2262: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
2263: l_rsv_count NUMBER;
2264: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
2265: l_quantity_to_delete NUMBER;
2266: l_sec_quantity_to_delete NUMBER; --INVCONV

Line 2264: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

2260: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2261: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
2262: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
2263: l_rsv_count NUMBER;
2264: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
2265: l_quantity_to_delete NUMBER;
2266: l_sec_quantity_to_delete NUMBER; --INVCONV
2267: l_sec_qty NUMBER; --INVCONV
2268: l_sec_deleted_quantity NUMBER; --INVCONV