3308: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
3309: ,p_old_line_rec IN OE_Order_Pub.Line_Rec_Type
3310: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3311: IS
3312: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3313: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
3314: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
3315: l_sales_order_id NUMBER;
3316: l_lock_records VARCHAR2(1);
3309: ,p_old_line_rec IN OE_Order_Pub.Line_Rec_Type
3310: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3311: IS
3312: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3313: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
3314: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
3315: l_sales_order_id NUMBER;
3316: l_lock_records VARCHAR2(1);
3317: l_sort_by_req_date NUMBER;
3310: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3311: IS
3312: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3313: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
3314: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
3315: l_sales_order_id NUMBER;
3316: l_lock_records VARCHAR2(1);
3317: l_sort_by_req_date NUMBER;
3318: l_buffer VARCHAR2(2000);