1284: PROCEDURE create_batch_step_transfers(p_old_batch_id IN NUMBER,
1285: p_new_batch_id IN NUMBER) IS
1286: CURSOR Cur_step_txfrs IS
1287: SELECT *
1288: FROM gme_batch_step_transfers_mig
1289: WHERE batch_id = p_old_batch_id;
1290: TYPE step_txfrs_mig_tab IS TABLE OF gme_batch_step_transfers_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1291: l_step_txfrs_mig_tbl step_txfrs_mig_tab;
1292: TYPE step_txfrs_tab IS TABLE OF gme_batch_step_transfers%ROWTYPE INDEX BY BINARY_INTEGER;
1286: CURSOR Cur_step_txfrs IS
1287: SELECT *
1288: FROM gme_batch_step_transfers_mig
1289: WHERE batch_id = p_old_batch_id;
1290: TYPE step_txfrs_mig_tab IS TABLE OF gme_batch_step_transfers_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1291: l_step_txfrs_mig_tbl step_txfrs_mig_tab;
1292: TYPE step_txfrs_tab IS TABLE OF gme_batch_step_transfers%ROWTYPE INDEX BY BINARY_INTEGER;
1293: l_step_txfrs_tbl step_txfrs_tab;
1294: l_api_name VARCHAR2(30) := 'create_batch_step_transfers';