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 1200: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

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;

Line 1201: l_rsv_rec2 inv_reservation_global.mtl_reservation_rec_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;

Line 1202: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

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;

Line 1203: l_update_rec inv_reservation_global.mtl_reservation_rec_type;

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;

Line 1204: l_serial_tbl 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;

Line 1207: l_dummy_sn inv_reservation_global.serial_number_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;
1209: l_sec_quantity_to_delete NUMBER; --INVCONV
1210: l_sec_deleted_quantity NUMBER; --INVCONV
1211: l_sec_quantity NUMBER; --INVCONV

Line 2245: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

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;

Line 2246: l_rsv_tbl inv_reservation_global.mtl_reservation_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;

Line 2247: l_update_rec inv_reservation_global.mtl_reservation_rec_type;

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

Line 2249: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

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