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