190:
191: PROCEDURE revert_line
192: (p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE
193: ,p_material_details_rec IN gme_material_details%ROWTYPE
194: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
195: ,x_return_status OUT NOCOPY VARCHAR2)IS
196:
197: /* Local variable definitions */
198: l_return_status VARCHAR2(1);
202: l_rel_type NUMBER;
203: l_batch_header_rec gme_batch_header%ROWTYPE;
204: l_material_details_rec gme_material_details%ROWTYPE;
205: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
206: l_batch_step_rec gme_batch_steps%ROWTYPE;
207: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
208: l_rsrc_trans_count NUMBER;
209: l_message_count NUMBER;
210: l_message_list VARCHAR2(2000);
203: l_batch_header_rec gme_batch_header%ROWTYPE;
204: l_material_details_rec gme_material_details%ROWTYPE;
205: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
206: l_batch_step_rec gme_batch_steps%ROWTYPE;
207: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
208: l_rsrc_trans_count NUMBER;
209: l_message_count NUMBER;
210: l_message_list VARCHAR2(2000);
211: l_exception_material_tbl gme_common_pvt.exceptions_tab;