DBA Data[Home] [Help]

APPS.WMS_TASK_MGMT_PUB dependencies on INV_RESERVATION_GLOBAL

Line 3495: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

3491: x_return_status OUT NOCOPY VARCHAR2 ,
3492: x_msg_count OUT NOCOPY NUMBER ,
3493: x_msg_data OUT NOCOPY VARCHAR2 ) IS
3494:
3495: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
3496: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
3497: l_mtl_reservation_tbl_count NUMBER;
3498: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
3499: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

Line 3496: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

3492: x_msg_count OUT NOCOPY NUMBER ,
3493: x_msg_data OUT NOCOPY VARCHAR2 ) IS
3494:
3495: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
3496: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
3497: l_mtl_reservation_tbl_count NUMBER;
3498: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
3499: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
3500: l_error_code NUMBER;

Line 3498: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

3494:
3495: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
3496: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
3497: l_mtl_reservation_tbl_count NUMBER;
3498: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
3499: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
3500: l_error_code NUMBER;
3501: l_count NUMBER;
3502: l_success BOOLEAN;

Line 3499: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

3495: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
3496: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
3497: l_mtl_reservation_tbl_count NUMBER;
3498: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
3499: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
3500: l_error_code NUMBER;
3501: l_count NUMBER;
3502: l_success BOOLEAN;
3503: l_umconvert_trans_quantity NUMBER := 0;

Line 4068: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

4064: l_pri_rsv_qty NUMBER;
4065: l_rsv_qty NUMBER;
4066: l_pri_rsv_uom VARCHAR2(3);
4067: l_rsv_uom VARCHAR2(3);
4068: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4069: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4070: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4071: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4072: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;

Line 4069: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

4065: l_rsv_qty NUMBER;
4066: l_pri_rsv_uom VARCHAR2(3);
4067: l_rsv_uom VARCHAR2(3);
4068: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4069: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4070: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4071: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4072: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4073: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec

Line 4070: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;

4066: l_pri_rsv_uom VARCHAR2(3);
4067: l_rsv_uom VARCHAR2(3);
4068: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4069: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4070: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4071: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4072: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4073: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4074: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec

Line 4460: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

4456: l_pri_rsv_qty NUMBER;
4457: l_rsv_qty NUMBER;
4458: l_pri_rsv_uom VARCHAR2(3);
4459: l_rsv_uom VARCHAR2(3);
4460: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4461: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4462: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4463: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4464: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;

Line 4461: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

4457: l_rsv_qty NUMBER;
4458: l_pri_rsv_uom VARCHAR2(3);
4459: l_rsv_uom VARCHAR2(3);
4460: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4461: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4462: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4463: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4464: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4465: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec

Line 4462: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;

4458: l_pri_rsv_uom VARCHAR2(3);
4459: l_rsv_uom VARCHAR2(3);
4460: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4461: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4462: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4463: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4464: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4465: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4466: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec