DBA Data[Home] [Help]

APPS.WMS_TASK_MGMT_PUB dependencies on INV_RESERVATION_GLOBAL

Line 3406: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

3402: x_return_status OUT NOCOPY VARCHAR2 ,
3403: x_msg_count OUT NOCOPY NUMBER ,
3404: x_msg_data OUT NOCOPY VARCHAR2 ) IS
3405:
3406: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
3407: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
3408: l_mtl_reservation_tbl_count NUMBER;
3409: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
3410: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

Line 3407: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

3403: x_msg_count OUT NOCOPY NUMBER ,
3404: x_msg_data OUT NOCOPY VARCHAR2 ) IS
3405:
3406: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
3407: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
3408: l_mtl_reservation_tbl_count NUMBER;
3409: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
3410: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
3411: l_error_code NUMBER;

Line 3409: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

3405:
3406: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
3407: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
3408: l_mtl_reservation_tbl_count NUMBER;
3409: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
3410: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
3411: l_error_code NUMBER;
3412: l_count NUMBER;
3413: l_success BOOLEAN;

Line 3410: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

3406: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
3407: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
3408: l_mtl_reservation_tbl_count NUMBER;
3409: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
3410: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
3411: l_error_code NUMBER;
3412: l_count NUMBER;
3413: l_success BOOLEAN;
3414: l_umconvert_trans_quantity NUMBER := 0;

Line 3979: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

3975: l_pri_rsv_qty NUMBER;
3976: l_rsv_qty NUMBER;
3977: l_pri_rsv_uom VARCHAR2(3);
3978: l_rsv_uom VARCHAR2(3);
3979: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
3980: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
3981: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
3982: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
3983: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;

Line 3980: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

3976: l_rsv_qty NUMBER;
3977: l_pri_rsv_uom VARCHAR2(3);
3978: l_rsv_uom VARCHAR2(3);
3979: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
3980: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
3981: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
3982: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
3983: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
3984: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec

Line 3981: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;

3977: l_pri_rsv_uom VARCHAR2(3);
3978: l_rsv_uom VARCHAR2(3);
3979: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
3980: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
3981: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
3982: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
3983: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
3984: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
3985: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec

Line 4371: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

4367: l_pri_rsv_qty NUMBER;
4368: l_rsv_qty NUMBER;
4369: l_pri_rsv_uom VARCHAR2(3);
4370: l_rsv_uom VARCHAR2(3);
4371: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4372: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4373: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4374: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4375: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;

Line 4372: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

4368: l_rsv_qty NUMBER;
4369: l_pri_rsv_uom VARCHAR2(3);
4370: l_rsv_uom VARCHAR2(3);
4371: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4372: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4373: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4374: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4375: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4376: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec

Line 4373: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;

4369: l_pri_rsv_uom VARCHAR2(3);
4370: l_rsv_uom VARCHAR2(3);
4371: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4372: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4373: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4374: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4375: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4376: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4377: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec